# Open Data DC schema ERD

Table and field reference for the Fivetran Open Data DC connector.

## Table & Field Reference

### crash_in_dc_coordinate

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| crash_in_dc_crime_id | String | PK, FK |
| coordinate | Double |  |

### crash_in_dc

| Column | Type | Keys |
| --- | --- | --- |
| crime_id | String | PK |
| address | String |  |
| bicyclists_impaired | Int |  |
| ccn | String |  |
| drivers_impaired | Int |  |
| event_id | String |  |
| fatal_bicyclist | Int |  |
| fatal_driver | Int |  |
| fatal_passenger | Int |  |
| fatal_pedestrian | Int |  |
| from_date | Instant |  |
| geometry_type | String |  |
| id | Long |  |
| int_approach_direction | String |  |
| last_update_date | Instant |  |
| latitude | Double |  |
| location_error | String |  |
| longitude | Double |  |
| major_injuries_bicyclist | Int |  |
| major_injuries_driver | Int |  |
| major_injuries_passenger | Int |  |
| major_injuries_pedestrian | Int |  |
| mar_address | String |  |
| mar_id | Int |  |
| mar_score | Double |  |
| measure | Double |  |
| minor_injuries_bicyclist | Int |  |
| minor_injuries_driver | Int |  |
| minor_injuries_passenger | Int |  |
| minor_injuries_pedestrian | Int |  |
| mpd_latitude | Double |  |
| mpd_longitude | Double |  |
| mpdgeox | Double |  |
| mpdgeoy | Double |  |
| nearest_int_route_id | String |  |
| nearest_int_street_name | String |  |
| offintersection | Double |  |
| offsets | Double |  |
| pedestrians_impaired | Int |  |
| report_date | Instant |  |
| roadways_egid | Int |  |
| route_id | String |  |
| speeding_involved | Int |  |
| streets_egid | Int |  |
| to_date | Instant |  |
| total_bicycles | Int |  |
| total_government | Int |  |
| total_pedestrians | Int |  |
| total_taxis | Int |  |
| total_vehicles | Int |  |
| type | String |  |
| unknown_injuries_bicyclist | Int |  |
| unknown_injuries_driver | Int |  |
| unknown_injuries_passenger | Int |  |
| unknown_injuries_pedestrian | Int |  |
| ward | String |  |
| x_coord | Double |  |
| y_coord | Double |  |

### crash_in_dc_detail

| Column | Type | Keys |
| --- | --- | --- |
| person_id | String | PK |
| crime_id | String | PK, FK |
| age | Int |  |
| ccn | String |  |
| fatal | String |  |
| impaired | String |  |
| in_vehicle_type | String |  |
| license_plate_state | String |  |
| major_injury | String |  |
| minor_injury | String |  |
| object_id | Long |  |
| person_type | String |  |
| speeding | String |  |
| ticket_issued | String |  |
| vehicle_id | String |  |

## Relationships

- crash_in_dc_coordinate(crash_in_dc_crime_id) → crash_in_dc(crime_id)
- crash_in_dc_detail(crime_id) → crash_in_dc(crime_id)