📖
Police Data Access Point Docs
pdap.ioGitHub
  • 👋Welcome
  • ⚡Activities
    • Label new Data Sources
    • 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
  • Form submission
  • Management & display

Was this helpful?

Edit on GitHub
  1. About
  2. Database details

Requests data dictionary

PreviousAgencies data dictionaryNextRecord Types taxonomy

Last updated 7 months ago

Was this helpful?

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

Required properties for submission

submitter_contact_info, request_notes, location_described

Form submission

Property
Type
Description

coverage_range

string

A range of dates or years covered by this request

data_requirements

string

Details the data must have, like "case numbers" or "incident location".

location_described

string

Is your research focused on a specific department? Are you comparing two counties or cities?

submission_notes

string (textarea)

What are you trying to learn? Are you trying to answer a specific question, or complete a specific project? Is there anything you've already tried?

submitter_email

string

How should we contact you to respond to this request? We won't share this with volunteers without your permission. We will never display it publicly or with volunteers without your permission.

target_date

string

When would you like to see this request filled? Are you working on a deadline?

Management & display

Property
Type
Description

archive_reason

string

Why was this archived?

data_sources

link to data sources

Airtable link to relevant sources by airtable ID

date_created

datetime

When this was created

date_status_last_changed

datetime

When the value of request_status last changed

github_issue_url

string

Link to the GitHub issue associated with this request. Added manually in Airtable, by integration in v2.

id

autonumber

Used for display in Airtable.

internal_notes

string

Internal notes by PDAP staff about the request.

pdap_response

string

Public notes by PDAP about the request.

record_types_required

array

related_requests

link to other requests

Manually linked. Will be deprecated in favor of GitHub.

request_status

array

Source of truth: GitHub. Not updated in Airtable.

sources_airtable_uid

array

The UID(s) of Data Sources associated with the Request

withdrawal_reason

array

Describe why issues were withdrawn, for metrics tracking.

work_required

array

Types of work that might be needed to respond to the request, such as "data location" or "web scraping"

Multi-select from our .

🔬
submission form
taxonomy