HCMC Blogs

Deadline looming for DH presentation materials.

Did a short workshop on regexes for MoEML and other folks; the materials are in the MoEML repo. Also went to SB's DHSI class for a bit to answer Qs on Oxygen.

The side-by-side thing is working now, and we have more layers to show. The remaining thing is the display of source and responsibility information for the apparatus entries, but I have a good idea how to make that work.

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]

1) Clear data out of database
these tables first to avoid foreign-key violation errors:
TRUNCATE crimes
TRUNCATE trial_files
TRUNCATE criminals
[or
TRUNCATE crimes; TRUNCATE trial_files; TRUNCATE criminals;
]

These tables are virtually always modified when you add a new record(s), so do them next:
TRUNCATE outcomes
TRUNCATE respites
TRUNCATE trials
[or
TRUNCATE outcomes; TRUNCATE respites; TRUNCATE trials;
]

These tables are occasionally modified:
TRUNCATE aliases
TRUNCATE judge_respites
TRUNCATE outcome_durations
TRUNCATE execution_specials
TRUNCATE mercy_appeals
[or
TRUNCATE aliases; TRUNCATE judge_respites; TRUNCATE outcome_durations; TRUNCATE execution_specials; TRUNCATE mercy_appeals;
]

2) Run the Importer.php file on each data file to upload it into db. Can take up to a minute. Dev and production instances both working.

Received additional updates from SB this afternoon.
Have updated timetable page with new pdf.
Sent email to SB advising task completed (cc'd BB, JS, SA)

Leaving early for another appointment.

Got the map setup working properly, with nice functionality outlining zones of interest. Also created a lot of new graphics for the interchange presentation, which still isn't really finished.

Planned a simple 10-stage outline/worksheet thing for tomorrow's regex workshop.

Met with PAB. Added new material to Beck site; discussed Oxygen project setup for MyNDIR editors (templates, authoring CSS, rendering transformations, code templates).