Open Data DC Lite

is an open data portal that provides government data for Washington, D.C.

Features

Feature Name	Supported	Notes
		All tables
Custom data
		Column level

		Connector level
History
API configurable
Priority-first sync
Fivetran data models
Private networking

Sync overview

The connector syncs data for the dataset into your destination. To capture new records, we 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 the CRASH_IN_DC table and its child tables once a week.

Setup guide

Follow our to connect Open Data DC with your destination using Fivetran connectors.

Schema information

This schema applies to all Open Data DC connectors.