📖
Police Data Access Point Docs
pdap.ioGitHub
  • 👋Welcome
  • ⚡Activities
    • Label new Data Sources
      • Labeling events
    • Volunteer for Data Requests
    • Search for Data Sources
    • Publish data
    • Web scraping
    • FOIA requests
    • Advocate for open data
  • 🔬About
    • Search the PDAP database
    • Terms & definitions
      • What is a Data Source?
      • Terminology
    • Database details
      • Data Sources data dictionary
      • Agencies data dictionary
      • Requests data dictionary
      • Record Types taxonomy
      • Hidden properties
    • GitHub
    • Hugging Face
  • 📡API
    • Introduction/Getting Started
  • 🛠️Tools & Resources
    • Related projects
    • Resources for using data
    • Using LLMs like ChatGPT
  • 🔁Meta
    • Internal Tools (Retool)
    • Internal dev resources
      • GitHub issue template
      • GitHub pull request template
      • Product changes checklist
      • ☑️Production QA Checklist
      • Retool
    • Operations
      • Staff resources
        • Meeting Minutes
          • 2021-07-14
          • 2021-06-16
          • 2021-03-14
          • 2020 11-21 Tech Stack discussion
          • 2020-09-30 Leadership Cadence
          • 2020-10-14 Leadership Cadence
          • 2020-10-21 Leadership Cadence
          • 2020-10-28 Leadership Cadence
          • 2020-11-04 Leadership Cadence
          • 2020-11-12 Leadership Cadence
          • 2020-11-18 Leadership Cadence
          • 2020-11-25 Leadership Cadence Notes
          • 2020-12-02 Leadership Cadence Notes
          • 2020-12-09 Leadership Cadence Notes
          • 2020-12-12 Working Session
          • 2020-12-16 Leadership Cadence
          • 2020-12-30 Leadership Cadence Notes
          • 2021-01-06 Leadership Cadence Notes
          • 2021-01-13 Leadership Cadence Notes
          • 2021-01-20 Leadership Cadence Notes
          • 2021-01-27 Leadership Cadence Notes
          • 2021-02-03 Leadership Cadence Notes
          • 2021-02-10 Leadership Cadence Notes
          • 2021-02-17 Leadership Cadence Notes
          • 2021-02-24 Leadership Cadence Notes
          • 2021-03-03 Leadership Cadence Notes
          • 2021-03-10 Leadership Cadence Notes
          • 2021-03-16 Leadership Cadence Notes
          • 2021-03-27 database working session
          • 2021-03-31
          • 2020-12-1
          • 2021-01-23
          • 2021-04-10 Meeting notes
          • 2021-04-17 Meeting notes
          • 2021-04-21 Leadership Cadence
          • 2021-04-28 Leadership Cadence
          • 2021-05-05 Leadership Cadence
          • 2021-05-12 Leadership Cadence
          • 2021-05-19 Leadership Cadence
          • 2021-05-26 Leadership Cadence
          • 2021-06-02 Leadership Cadence
          • Decision log
        • Brand assets
      • Legal
        • Public records access laws & precedent
        • Legal Data Scraping
        • State Computer Crimes laws
      • Policy
        • Impartiality resolution
        • PDAP Access
        • PDAP Privacy Policy
        • Password Management
        • Personally Identifiable Information
    • Community calls
      • October 17, 2023
      • February 22, 2023
      • February 1, 2023
      • January 20, 2023
      • January 5, 2023
      • October 25, 2022
      • September 22, 2022
      • August 23, 2022
      • October 2, 2021
      • September 25, 2021
      • September 11, 2021
      • September 4, 2021
      • August 7, 2021
      • July 27 Dolt Bounty retro
      • July 17, 2021
      • July 10, 2021
      • June 26, 2021
      • June 19, 2021
      • June 12, 2021
      • June 5, 2021
      • May 1, 2021
      • April 24, 2021
    • Newsletter
    • Join our Discord
Powered by GitBook
On this page
  • Required properties for submission
  • Identification & web presence
  • Geographic
  • Meta & utility

Was this helpful?

Edit on GitHub
  1. About
  2. Database details

Agencies data dictionary

PreviousData Sources data dictionaryNextRequests data dictionary

Last updated 10 months ago

Was this helpful?

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

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

🔬
submission form