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

Property	Type	Description
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 police, court, jail, and aggregated, which usually represents coverage of multiple types of agency.
contracting_agency	link to other records from agencies table	If the jurisdiction or agency contracts its police services to another agency, it can be selected here.
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

Property	Type	Description
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

Property	Type	Description
airtable_uid	string	The Airtable-generated UID of this particular data source