Agencies data dictionary
Last updated
Was this helpful?
Last updated
Was this helpful?
submitter_contact, submitted_name, homepage_url, jurisdiction_type, agency_type, + geographic info dependent on the jurisdiction_type.
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.
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.
airtable_uid
string
The Airtable-generated UID of this particular data source