Adding a git issue to track the data model stuff from the Burlington Team.
Parser
Our team decided it is probably easiest to parse the court calendar which is updated every day.
Main Data We Will Track
docket (This is unique for that case…but will be repeated in the calendar for different events)
category (county + Division. CNCR (Chitenten and criminal) )
location (Courtroom)
day_of_week (DoW)
day (1-31)
month (Jan, Feb,Etc.)
time (1:00)
am_pm (am/pm)
court_calendar_url (ID the calendar we are looking at on the web.)
court_address
division
county
==New==
party (defendant name)
hearing_type (sentencing, bail, deposition, etc.)
The actual address of the court
Division
County
Party (defendant name)
Hearing Type (sentencing, bail, deposition, etc.)
Mapping table (for Things Below)
Mapping Table
We also have a mapping table to break out the category because category is an abbreviation of the Vermont County and Division).
Counties:
Ancr: 'Addison',
Bncr: 'Bennington',
Cacr: 'Caledonia',
Cncr: 'Chittenden',
Excr: 'Essex',
Frcr: 'Franklin',
Gicr: 'Grand Isle',
Lecr: 'Lamoille',
Oecr: 'Orange',
Oscr: 'Orleans',
Rdcr: 'Rutland',
Wncr: 'Washington',
Wmcr: 'Windham',
Wrcr: 'Windsor'
jdungan
commented
4 years ago
Adding a git issue to track the data model stuff from the Burlington Team.
Parser Our team decided it is probably easiest to parse the court calendar which is updated every day.
Main Data We Will Track
Mapping Table We also have a mapping table to break out the category because category is an abbreviation of the Vermont County and Division). Counties: Ancr: 'Addison', Bncr: 'Bennington', Cacr: 'Caledonia', Cncr: 'Chittenden', Excr: 'Essex', Frcr: 'Franklin', Gicr: 'Grand Isle', Lecr: 'Lamoille', Oecr: 'Orange', Oscr: 'Orleans', Rdcr: 'Rutland', Wncr: 'Washington', Wmcr: 'Windham', Wrcr: 'Windsor'
Division: cr-criminal cv-civil fa-family pr-probate sc-small claims dm-domestic