Agencies data dictionary

To see which options are available for select fields, consult the submission form.

Required properties for submission

submitter_contact, submitted_name, homepage_url, jurisdiction_type, agency_type, + geographic info dependent on the jurisdiction_type.

Identification & web presence

PropertyTypeDescription

name

string

If a state is present, concatenates submitted_name + " - " + state_iso to help differentiate agencies with similar names in some Airtable menus. Otherwise, uses submitted_name.

submitted_name

string

What does the agency call itself?

agency_type

string

Options include law enforcement/police, court, and corrections.

multi_agency

boolean

True for utility agencies, used to geolocate data sources which cover multiple agencies. For example, a source about the "Allegheny County Aggregated" multi-agencies contains records about all agencies in Allegheny County.

defunct_year

integer

If present, denotes an agency which has defunct but may still have relevant records.

homepage_url

string

A URL for the homepage of this agency.

no_web_presence

boolean

True when an agency does not have a dedicated website.

Geographic

PropertyTypeDescription

jurisdiction_type

string

What is the highest level of jurisdiction for the agency? Can be an option like local or county.

state_iso

string

2-character ISO code. Does not apply to federal agencies.

county_fips

string (not an integer because of leading 0s)

Unique 5-digit code to identify counties. Does not apply to state or federal agencies.

county_name

string

Official County name. Does not apply to state or federal agencies.

municipality

string

Official municipality name. Does not apply to county, state, or federal agencies.

zip_code

string (not an integer because of leading 0s)

Postal code for the agency's headquarters.

lat

float

Geographic latitude for the agency's headquarters.

lng

float

Geographic longitude for the agency's headquarters.

Meta & utility

PropertyTypeDescription

airtable_uid

string

The Airtable-generated UID of this particular data source

Last updated