The St. John Genealogy

Origin and Ancestry DNA Database & Electronic Archive

Reports


 #   Report Name   Description 
1. 2016 DNA Report testing reports function to pull DNA data from new fields in tng_dna_tests 
2. American Civil War 1861-1865  
3. American Revolutionary War 1775-1783  
4. Barons St. John of Bletso (1559 - current)  
5. Colonial America inhabitants The persons listed in these collections are found in the earliest records for the settlement. They were the first inhabitants, founders, and leaders of the community as found in the records. Profiles will be developed as time and information becomes available. 
6. Colonial Merchant & Navy Ships Colonial English and American Merchant & Navy Ships and their captains and crews as discovered 
7. Colonial Ship Captains This report identifies ship captains and crews connected to Navy & Merchant ships during the time of Colonial America's establishment. The 'marriage' form is used where marriage date = year of event; spouse name = captain or crew member at event; 'marriage place' represent connected historical events. 
8. Colony: Dorchester, Massachusetts History of South Boston (its past and present) and prospects for the future with sketches of prominent men by John J. Toomey and Edward P.B. Rankin. Published in 1901 by The Authors in Boston. pg. 14-15 https://openlibrary.org/books/OL7148564M/History_of_South_Boston_(its_past_and_present)_and_prospects_for_the_future Name List Electronically transcribed: 31 Dec. 2014 by Suzanne St. John Note: Additional Data will be supplemented from other sources as it becomes known.  
9. Colony: New England Settlers (All) New England Colonies: Massachusetts, New Hampshire, Connecticut, Rhode Island Middle Colonies: New York, Pennsylvania, New Jersey, Delaware Southern Colonies: Maryland, Virginia, North Carolina, South Carolina, Georgia 
10. Colony: Windsor, Connecticut The history of ancient Windsor, Connecticut, including East Windsor, South Windsor, and Ellington, prior to 1768 by Henry Reed Stiles (1832-1909). Published in 1859 by New York, C.B. Norton. pg. https://archive.org/details/historyofancient01stil Name List Electronically transcribed: 31 Dec. 2014 by Suzanne St. John Note: Additional Data will be supplemented from other sources as it becomes known.  
11. de Port-St. John, Baron St. John of Bletso  
12. Deaths: By year range  
13. DNA autosomal test  
14. DNA chromosome 1  
15. DNA Chromosome 24(Gender Y) (final result)  
16. DNA matching chromosome data  
17. DNA test report SELECT firstname, lastname, sex, test_number, test_type, haplogroup, terminal_snp, DYS393 FROM tng_people INNER JOIN tng_dna_tests ON tng_people.personID = tng_dna_tests.personID INNER JOIN tng_dna_tests ON tng_people.peopleid = tng_dna_tests.personID WHERE lastname LIKE 'St. John'; INNER JOIN tng_dna_tests ON tng_people.personID = tng_dna_tests.personID tng_dna_tests.paternal_surname LIKE 'St. John' 
18. dna_autosomal Chromosome 1 matches  
19. Dorchester Town Records Dorchester town records. https://openlibrary.org/books/OL6956427M/Dorchester_town_records. 3d ed., 1896. Published 1896 by Rockwell and Churchill, city printers in Boston . Written in English. Edition Notes Includes p. 5-429 of v. 1 of the original manuscript records, with entries dating from 1632 to 1692. Series Fourth report of the Record Commissioners of the city of Boston. 1880 Classifications Library of Congress F73.1 .B74 4th b The Physical Object Pagination 1 p.l., v, [1], 329 p. Number of pages 329 ID Numbers Open Library OL6956427M Internet Archive dorchestertownre00dorch LC Control Number 05018367 OCLC/WorldCat 4402457 
20. ERROR0001 General Book Errors in The St. John Genealogy, 1907 book by Orline St. John Alexander. This report will identify all records that have a known/suspected error associated with them. 
21. ERROR0002 Numbering Errors in The St. John Genealogy, 1907 book by Orline St. John Alexander. This report will identify all records that have a known/suspected error associated with them.  
22. ERROR0003 Naming Errors in The St. John Genealogy, 1907 book by Orline St. John Alexander. This report will identify all records that have a known/suspected error associated with them.  
23. Imigrated Persons  
24. Lived at Uchelolau (Highlight), Glamorgan, Wales  
25. Livery Clothworker Company Records  
26. Livery Companies  
27. London0001 - St. Olave, Silver Street Parish  
28. Maintenance: Documents not linked to an Event  
29. Math St. John (All) Mathias and Mathew St. Johns 
30. NEWS0001 2011 Births  
31. NEWS0002 2011 Marriages 
32. NEWS0003 2011 Deaths 
33. Private  
34. Record Status  
35. Records: St. John, FamilySearch.org  
36. Reminders: Birthdays this month From FIELD: Last Name, First Name Birth Date From CRITERIA or Operators: Month Only From Birth Date = Current Month From SORT: Day Only From Birth Date Last Name 
37. St. John Baronets of Lydiard Tregoze (1611 - 1716)  
38. St. John baronets, of Longthorpe  
39. St. John of Ulster, NY  
40. Viscount of Bolingbroke (1712 - current)  
41. Viscounts St. John (1716 - current)  
42. Books0001 The St. John Genealogy by Orline St. John Alexander. All St. John's given a unique ID number in the 1907 Book by Orline St. John Alexander. Watch as this list grows as more and more individuals from the book are added to this site. (Note, people listed in the book without a unique ID may still be in this database but just don't show up on this report. This report is generated mostly to see what gaps are missing in order to look up and add those persons to this site.) 
43. Books0002 The Descendents of Robert Lockwood from 1630. "The Descendents of Robert Lockwood from 1630" Published Privately in 1889 by E. Dunbar Lockwood and F.A. Holden. This report will identify Lockwood Family linked to the St. John Family and aid in research. Contains links to St. John's for all Lockwoods's given a unique ID number in this book. Watch as this list grows as more and more individuals from the book are added to this site. (Note, people listed in the book without a unique ID may still be in this database but just don't show up on this report. This report is generated mostly to see what gaps are missing in order to look up and add those persons to this site.) 
44. FAME0001 This report will identify US Presidents contained in this system. 
45. FAME0002 This report will identify famous race car drivers in this database. 
46. FAME0003 Actors  
47. SURNAME0001 Individuals with the Belden Surname. 
48. SURNAME0002 Individuals with the Keeler Surname. 
49. SURNAME0003 Individuals with the Kellogg Surname. 
50. SURNAME0004 Identifies all individuals in this tree with last name Lockwood. Sorted by first name then birth and death dates. 
51. SURNAME0005 Individuals with the Seeley Surname 
52. SURNAME0006 Individuals with the Seymour Surname. 
53. Tools0001 All individuals identified as living. 
54. Tools0002 Individuals identified as born in England. 
55. Tools0003 Gender - Unknown Clean Up. Helps to quickly identify individuals who's gender was not correctly inputted by reporting all genders classified as unknown. (Note: obviously some genders where name could be male or female or where person's identity remains unknown would result in an accurate unknown and therefore they cannot all be changed but this can be an aid for further identifying research opportunities.) 
56. Tools0004 Name is or is like Suzanne St. John. I just want to see how many Suzanne-like St. John's there are because I'm curious like that! :) 
57. Tools0005 Find William St. John born 1808. This report is to identify all William St. John's in order to identify errors in the 1907 The St. John Genealogy book and include current known public records for such effort. If you have information records for a William St. John please submit copies of your information to this site to help others in their research. 
58. Tools0006 Rufus Green St. John vs. Ruben Green St. John. Research results to determine if these individuals are one and the same. 
59. Tools0007 Samuel St. John & Thankful Lockwood. Identifies all individuals with either the name Samuel or Thankful Lockwood. 
60. Tools0008 Samuel St. John 
61. Autosomal DNA Raw Data Report SELECT tng_dna_tests.personID as PersonID,tng_dna_tests.vendor as Vendor,dna_autosomal.kit_id as Kit,dna_autosomal.chromosome as Chromosome,dna_autosomal.rsid as SNP,dna_autosomal.position as Position,dna_autosomal.allele_1 as Allele1,dna_autosomal.allele_2 as Allele2 FROM dna_autosomal LEFT JOIN tng_dna_tests ON dna_autosomal.kit_id = tng_dna_tests.test_number; 
62. Matching Autosomal DNA Raw Data  
63. Origin and Ancestry Generation Report SQL Code: SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, tng_people.branch,e284.info as info284,lastname, firstname,sex,birthdate,birthplace,deathdate,deathplace,(if(sex='M',families1.wife,families2.husband)) as spouse,(if(sex='M',families1.wife,families2.husband)) as spouse,DATE_FORMAT(tng_people.changedate,'%d %b %Y') as changedate_disp, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_families AS families1 ON (tng_people.gedcom = families1.gedcom AND tng_people.personID = families1.husband ) LEFT JOIN tng_families AS families2 ON (tng_people.gedcom = families2.gedcom AND tng_people.personID = families2.wife ) LEFT JOIN tng_events e284 ON tng_people.personID = e284.persfamID AND tng_people.gedcom = e284.gedcom AND e284.eventtypeID = "284" WHERE (e284.info >= 01) AND tng_people.gedcom = "OSA0001" ORDER BY e284.info,lastname,firstname 
64. Test Report  
65. Test Report - Children with Spouses and Parents  

This site powered by The Next Generation of Genealogy Sitebuilding v. 12.1, written by Darrin Lythgoe © 2001-2019.

Maintained by The St. John Genealogy. | Data Protection Policy.

This site is for the preservation of the St. John families. Material on this site is intended to educate those interested in St. John Family History.