# |
Report Name |
Description |
1. | 100th Birthdays | Individuals with a 100th birthday this year or next year - and are not reported as deceased. |
2. | 75th Birthdays | Individuals with a 75th birthday this year or next year |
3. | 80th Birthdays | Individuals with an 80th birthday this year or next year |
4. | 85th Birthday | Individuals with an 85th birthday this year or next year |
5. | Age Descending | SELECT lastname, firstname, personID, birthdate, birthdatetr, deathdate, deathdatetr,
YEAR(deathdatetr)-YEAR(birthdatetr) AS Age, gedcom FROM tng_people
WHERE (birthdatetr<>"0000-00-00") AND (deathdatetr<>"0000-00-00") ORDER BY Age DESC, lastname, firstname
Edited ORDER by age to read ORDER by birthdate |
6. | Age to 100 or older (PA-121) | Sorted by age.
Please advise if otherwise. |
7. | Birth - 9 months after father's death | Children born > 9 months after father's death. Assuming the child's birth and father's death are correctly entered, then a negative entry in the YearsFatherDead field indicates the father was dead before the child was conceived. If the YearsFatherDead entry is zero (0) then the father's death might have been within the 3-month window preceding the subject child's normal, 9-month gestation period warranting a closer review of the death date. Estimating the father's death to "about" 9-months before the child's birth appears to rectify the discrepancy. Thus far the report ends if the father dies before the child's birth. Thus, some births results are false positives. |
8. | Birth - Date with Places ordered by Birthplace | Persons are listed alphabetically by birth place and last name.
(RJCarr: deleted altbirthdate,) |
9. | Burials by Cemetery Name | Results are sorted by cemetery name and last name.
The report does not include a branch selection which would require this statement after WHERE: "p.branch = 'G01' AND" but before the "p.living = 0" statement. |
10. | Burials by Last Name (RJC-2) | Burials are listed alphabetically. Hyperlinks to either the person or cemetery via the map tack at the end of the cemetery name. |
11. | Burials with Notes #2 | Can't set sort on Notes |
12. | Cemeteries (RC104) by Cemetery Name | Cemeteries are listed alphabetically with a map tack at the end of the name. Click on the map tack to link to that cemetery and to persons buried there. |
13. | Cemeteries w/ GPS sorted by Country & State | "Over time [Beckwith] amassed over 500 Smoky Mountain cemetery coordinates. Many hikers and genealogists have asked for a GPS interface. They find entering one at a time both time consuming and error prone. They have tried using a smart phone but TNG doesn't have a mobile interface and reception is not good in the mountains. I created a custom GPS "Point of Interest" report that can be imported into a GPS."
http://www.smokykin.com/tng/showreport.php?reportID=4 |
14. | Changes - Families in Last 90-Days (RF-190) | Families are sorted by date of change - most recent on top line. List does not include changes to data of a person already in the family. |
15. | Changes - Individuals in Last 90-Days (RP-190) | Living persons changed will not seen without a login.
Living persons are coded "1".
Deceased persons are coded "0". |
16. | Children with photos always on | Children's photos are a particular concern on the internet so this lists those now under 18 who are shown to the world.
Report source: TNG Maintenance |
17. | Couples - Where brothers are married to sisters | Or, where a woman was remarried a husband's brother
Example 1: John Smith married Ann Brown and his brother Peter Smith married Ann's sister Mary Brown.
Example 2: Susie Smith married Thomas Thompson and later married his brother Timothy Thompson
Developed Warren S Gilbert with an assist by Jerry Milo Johnson. |
18. | Marriages - A spouse < 18 years old | Applies to marriage dates AFTER 1785 (Administrator can change both the year 1785 and the age threshold.) |
19. | Military Service: All Soldiers | Men and women with known military service based upon military rosters, headstone inscriptions and/or family records. Available military records are linked to the individual pages. Sorted by last name. Living persons are not visible without a log-in. |
20. | Military Service: During Civil War with CSA | Men whose military service is annotated "CSA" based upon military rosters, headstone inscriptions and/ or family records. Sorted by date of death. |
21. | Military Service: During Civil War with GAR | Men whose military service is annotated "GAR" based upon military rosters, headstone inscriptions and/ or family records. |
22. | Military Service: During Vietnam War | Persons whose military service was in South Vietnam and whose records are annotated "Vietnam" based upon military rosters, headstone inscriptions and/ or family records. |
23. | Military Service: During WWI | Persons whose military service field is annotated "WWI" based upon military rosters, headstone inscriptions and/ or family records. |
24. | Military Service: During WWII - Army | Persons whose military service is annotated "WWII: US Army" based upon military rosters, headstone inscriptions and/ or family records. |
25. | Military Service: During WWII - Navy | Description: Persons whose military service is annotated "WWII: US Navy" based upon military rosters, headstone inscriptions and/ or family records. |
26. | Military Service: During WWII - All | Persons whose military service is annotated "WWII" based upon military rosters, headstone inscriptions and/ or family records. |
27. | Military Service: During WWII - USMC | Description: Persons whose military service is annotated "WWII: USMC" based upon military rosters, headstone inscriptions and/ or family records. |
28. | Military Service: KIA during all wars | The report includes servicemen whose records are annotated killed in action (KIA) based upon military records, headstone inscriptions and/or family records. Additionally, those listed as missing in action (MIA) are included in this report as are soldiers who died of wounds (DOW). CSA and GAR soldiers whose death occurred during the Civil War are presumed to be KIA/DOW unless available records stipulate otherwise. Sorted by date of death.
Soldiers who died during a conflict of non-battle causes (accidents, disease, etc.) are not listed in the report. Their cause of death are annotated on their Military Event entry. |
29. | Military Service: WWII Draft Age (1940) | This report lists men between 18 and 40 years of age who were required to report to the draft board for evaluation for service in the Armed Forces. Living persons will not be shown without a login. |
30. | Military Service: WWII Draft Age (1940) Alt | Lists men who were between age 15 & 40 in 1940 and hence, were eligible for the draft by 1943. |
31. | Person - Index | A very simple report of persons in CarrFamilyTree matched with the names of their Parents' and Spouses' - and it groups children of one family together. Sorted by: 1) person's last name, 2) parent's first name, and then 3) person's first name. Logical, if not tedious as well! |
32. | Person - Unknown Sex (PS-001) | TNG maintenace |
33. | Birth - Aquarius (PB-521) | 21 JAN to 19 FEB |
34. | Birth - Aries (PB-511) | 21 MAR to 20 APR |
35. | Birth - Cancer (PB-514) | 22 JUN to 22 JUL |
36. | Birth - Capricorn | 22 DEC to 20 JAN |
37. | Birth - Gemini (PB-513) | 21 MAY to 21 JUN |
38. | Birth - Leo (PB-515) | 23 JUL to 23 AUG |
39. | Birth - Libra (PB-517) | 24 SEP to 23 OCT |
40. | Birth - Pices (PB-522) | 20 FEB to 20 MAR |
41. | Birth - Sagitarius (PB-519) | 23 NOV to 21 DEC |
42. | Birth - Scorpio (PB-518) | 24 OCT to 22 NOV |
43. | Birth - Taurus (PB-512) | 21 APR to 20 MAY |
44. | Birth - Virgo (PB-516) | 24 AUG to 23 SEP |