inconsistent results for chart query vs table query
Query 1 to 14 year olds, 1730 to 1759
Manual query on database returns 15 results
Table query returns 15 results (see below)
Chart query returns 18 results (see below)
Travis had 2 simultaneous trials for Burglary. The table query counts each of those as 1 hit (likely due to GROUP BY = criminal_id); the graph query counts each of those as 2 hits (likely due to GROUP BY = crime_group_text, Year). Similarly Gadd, who has 3 simultaneous trials for Robbery.
That's why the counts are what they are, and inconsistent between table searches and chart searches.
Table results:
Name Age G Crime Trial Date Judge Jury RR Date Mercy? Respite Outcome
*John Peaverly 14 M Stealing in a Dwelling 1731-05-03 M 1731-05-11 No T (RR) Transport
*John Travis 14 M Burglary 1734-01-18 M 1734-02-07 No T14 (RR) Transport
*Thomas Stafford 14 M Housebreaking 1736-12-13 1737-02-28 No To Die (RR Executed(Hanged)
*Charlotte Gregg 14 F Stealing in a Dwelling 1737-10-15 1738-01-12 No Free (RR) Free
*Jarvis Hare 14 M Horse (1) 1739-06-09 L 1739-06-28 No T (RR) Transport
*John Hetherington 14 M Stealing in a Dwelling 1740-04-19 1740-04-30 No T (RR) Transport
*Charles Shooter 12 M Stealing in a Dwelling 1741-01-20 1741-03-11 Yes T (RR) Transport
*Jane Wood 14 F Stealing in a Dwelling 1742-09-13 1742-11-11 Yes T14 (RR) Transport
*Joseph Loach 14 M Robbery 1743-09-12 1743-10-13 No T14 (RR) Transport
*John Bunn 13 M Robbery 1743-09-12 1743-10-13 No T14 (RR) Transport
Joseph Fitzwater 13 M Robbery 1744-09-15 1744-09-27 Yes TL (RR) Transport
Henry Gadd 14 M Robbery 1744-12-10 L 1744-12-19 No To Die (RR) Executed(Hanged)
*Anthony Dunn 14 M Robbery 1749-07-10 No Died
*Mary Rimer 13 F Pickpocket 1753-09-10 Willes-J L 1753-09-26 Yes T7 (RR) Transport
*Stephen Barnes 13 M Housebreaking 1753-12-10 Moreton-W M 1754-01-29 Yes TL (RR) Transport
Description of Chart results:
1731 StealInDwelling 1 [Peaverly]
1734 Burglary 2 [Travis] []
1736 Burglary 1 [Housebreaking]
1737 StealInDwelling 1 [Gregg]
1739 AnimalTheft 1 [Hare]
1740 StealInDwelling 1 [Hetherington]
1741 StealInDwelling 1 [Shooter]
1742 StealInDwelling 1 [Wood]
1743 Robbery 2 [Loach] [Bunn]
1744 Robbery 4 [Fitzwater] [Gadd] [] []
1749 Robbery 1 [Dunn]
1753 Burglary 1 [Rimer]
1753 Miscellaneous 1 [Barnes]