Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

OpenRecords FOIL Requests

kegn-anvqCity Government8 columns
The OpenRecords Requests dataset consists of information about FOIL Requests including Agency name, date created, date closed, due date, status. For further details visit the OpenRecords portal at https://a860-openrecords.nyc.gov/
View on NYC Open Data↗

Quality

A92.9 / 100

From a 500-row sample across 8 columns.

completeness96/ 25% weight
consistency75/ 20% weight
accuracy100/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • NYC Historical Vital Records: Index to Digitized Birth Certificates0.39
  • NYC Historical Vital Records: Index to Digitized Marriage Certificates0.38
  • NYC Historical Vital Records: Index to Digitized Death Certificates0.35
  • NYC Historical Vital Records: Index to Digitized Marriage Licenses0.35
  • New York City Municipal Archives Data Collection: Digital Objects0.32
  • NYC Open Data Plan: FOIL Metrics0.30
    joins onagency_name
  • Civil List0.28

Sample rows

request_idagency_namerequest_created_daterequest_submitted_daterequest_due_datesubmission_methodrequest_statusrequest_close_date
FOIL-2025-056-19837New York City Police Department2025-06-30T13:45:25.0002025-06-30T13:45:25.0002025-11-17T22:00:00.000Direct InputClosed2026-03-31T12:15:35.000
FOIL-2025-827-00341Department of Sanitation2025-09-29T14:00:31.0002025-09-29T14:00:31.0002025-12-19T22:00:00.000

Columns

8 queryable · 8 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
request_idtextUnique identification number given to a request.0%FOIL-2026-841-01202FOIL-2018-056-00278FOIL-2024-810-01171
agency_nametextThe Agency in which the request is assigned0%New York City Police Dep…New York City Fire Depar…Department of Transporta…
request_created_datedatetimeThe date the user created the request.0%2017-07-10T16:00:00.0002011-04-04T16:00:00.0002015-02-17T16:00:00.000
request_submitted_datedatetimeThe date a request is submitted to an agency.0%

Query this from your own app

GET /api/datasets/kegn-anvq
GET /api/datasets/kegn-anvq/quality
GET /api/datasets/kegn-anvq/related
GET /api/columns?dataset=kegn-anvq
joins onagency_name
  • Civil Service List (Terminated)0.28
    • Direct Input
    Closed
    2025-11-21T16:33:54.000
    FOIL-2025-057-01822New York City Fire Department2025-02-25T16:09:25.0002025-02-25T16:09:25.0002025-11-17T22:00:00.000Direct InputClosed2026-04-10T18:42:15.000
    FOIL-2026-056-17132New York City Police Department2026-05-28T16:29:50.0002026-05-28T16:29:50.0002026-10-14T21:00:00.000Direct InputClosed2026-10-05T16:01:44.000
    FOIL-2026-056-17129New York City Police Department2026-05-28T16:19:56.0002026-05-28T16:19:56.0002026-10-14T21:00:00.000Direct InputDue Soon—
    FOIL-2025-057-06480New York City Fire Department2025-07-16T12:11:10.0002025-07-16T12:11:10.0002025-11-17T22:00:00.000Direct InputOverdue—
    FOIL-2025-057-08948New York City Fire Department2025-10-08T12:36:39.0002025-10-08T12:36:39.0002025-11-17T22:00:00.000Direct InputOverdue—
    FOIL-2026-810-02909Department of Buildings2026-05-28T14:03:25.0002026-05-28T14:03:25.0002026-08-31T21:00:00.000Direct InputClosed2026-05-28T16:20:58.000
    FOIL-2025-057-03751New York City Fire Department2025-04-24T21:29:45.0002025-04-24T21:29:45.0002025-11-17T22:00:00.000Direct InputClosed2026-01-20T19:31:50.000
    FOIL-2025-057-08952New York City Fire Department2025-10-08T14:21:48.0002025-10-08T14:21:48.0002026-04-10T21:00:00.000Direct InputClosed2026-02-04T21:08:37.000
    2018-05-08T04:00:00.0002018-05-14T04:00:00.0002018-10-22T04:00:00.000
    request_due_datedatetimeThe due date for a request.0%2022-06-24T21:00:00.0002025-10-06T21:00:00.0002026-09-30T21:00:00.000
    submission_methodcategoricalThe method in which the request was submitted0%Direct InputMailIn-Personof 7
    request_statuscategoricalCurrent status of a request.0%ClosedOverdueIn Progressof 5
    request_close_datedatetimeThe date the request was closed15%2024-12-31T22:00:00.0002018-04-25T04:00:00.0002018-06-29T04:00:00.000