Open Data DC Lite
Open Data DC is an open data portal that provides government data for Washington, D.C.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API |
Sync overview
The connector syncs data for the Crashes In DC dataset into your destination. To capture new records, we incrementally sync the CRASH_IN_DC table and its child tables.
We sync all the tables once daily because the source data is not frequently updated. To capture updates and deletes, we also re-import the CRASH_IN_DC table and its child tables once a week.
Setup guide
Follow our step-by-step Open Data DC setup guide to connect Open Data DC with your destination using Fivetran connectors.
Schema information
This schema applies to all Open Data DC connectors.
Explore Open Data DC schema ERD