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

Street Construction Permits - Related Agency

cj3v-xdpdTransportation5 columns
DOT issues over 150 different types of sidewalk and roadway construction permits to utilities, contractors, government agencies and homeowners. Permits cover activities such as street openings, sidewalk construction and installing canopies over sidewalks. If additional organizations are associated with a permit, they are listed here.
View on NYC Open Data↗

Quality

A94.9 / 100

From a 500-row sample across 5 columns.

completeness100/ 25% weight
consistency80/ 20% weight
accuracy100/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • Street Construction Permits - Cranes0.82
    joins onmodifiedoncreatedonpermitnumber
  • Street Construction Permits - Fee0.75
    joins onmodifiedoncreatedonpermitnumber
  • Street Construction Permits - Stipulations (2020 - Present)0.69
    joins oncreatedonpermitnumber
  • Street Construction Permits - Stipulations (Historical)0.69
    joins oncreatedonpermitnumber
  • Street Construction Permits (2022 - Present)0.53

Sample rows

permitnumberpermitrelatedagencydescrelatedpermitnumbercreatedonmodifiedon
B012015127A08DEP7229362015-05-07T08:11:56.0002018-06-12T09:01:59.000
M012018240B84CAR20185860153-012018-08-28T13:23:54.0002021-10-05T00:05:17.000
Q012018155B02LAYOUTS17-08067-1Q2018-06-04T10:25:56.0002021-08-03T00:05:16.000
M022024087G09

Columns

5 queryable · 5 profiled

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

FieldTypeDescriptionNullValues
permitnumbertext—0%Q022017009A23Q022017009A31Q022017342B48
permitrelatedagencydesctext—0%DOBSECTIONCONTRACTOR
relatedpermitnumbertext—0%360MECC362
createdondatetime—0%2025-08-12T10:46:08.0002025-08-12T11:22:32.0002018-03-06T15:35:41.000

Query this from your own app

GET /api/datasets/cj3v-xdpd
GET /api/datasets/cj3v-xdpd/quality
GET /api/datasets/cj3v-xdpd/related
GET /api/columns?dataset=cj3v-xdpd
joins onmodifiedoncreatedonpermitnumber
  • Street Construction Permits (2013-2021)0.52
    joins onmodifiedoncreatedonpermitnumber
  • Medallion Taxi Initial Inspection Schedule0.31
  • Taxi Improvement Fund (TIF) Medallion Payments0.31
  • CONTRACTOR
    NETWORK
    2024-03-27T14:54:57.000
    2024-05-08T00:05:08.000
    B012024229C33EMPLOYEE236312024-08-16T16:00:15.0002024-09-22T00:05:24.000
    B012021259A68verizon1a4x7yw-2512021-09-16T09:45:01.0002024-10-20T00:05:46.000
    M012023066A04SECTION2032023-03-07T06:12:47.0002026-04-13T00:06:01.000
    B022017361C93DOB320623615-01-EQ-FN2017-12-27T14:48:27.0002018-03-18T00:05:06.000
    B012021263A78Work OrderT1021150092021-09-20T09:31:03.0002024-10-20T00:05:46.000
    B012024264A74SECTION3622024-09-20T08:39:36.0002024-10-20T00:05:37.000
    modifiedon
    datetime
    —
    0%
    2024-11-14T00:05:28.0002018-01-01T00:05:45.0002026-01-01T00:05:13.000