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

311 Service Requests for 2008

uzcy-9pukSocial Services61 columns
311 Service Requests for 2008. This is historical data and will not be updated.
View on NYC Open Data↗

Quality

C72.1 / 100

From a 500-row sample across 45 columns.

completeness58/ 25% weight
consistency93/ 20% weight
accuracy87/ 20% weight
timeliness9/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • 311 Service Requests for 20090.77
    joins onlongituderoad_ramplocation_state+58
  • 311 Service Requests from 2010 to 20190.46
    joins onlongituderoad_rampbridge_highway_segment+37

Geography

Mappable — Socrata point column `location`.

Open on the map →

Sample rows

unique_keycreated_dateclosed_dateagencyagency_namecomplaint_typedescriptorlocation_typeincident_addressstreet_namecross_street_1cross_street_2
107621722008-03-20T00:00:00.0002008-03-20T00:00:00.000DSNYBronx 11Sanitation Condition12 Dead AnimalsSidewalk 2339 KINGSLAND AVENUE2339 KINGSLAND AVENUEASTOR AVENUEWARING AVENUE

Columns

52 queryable · 51 profiled

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

FieldTypeDescriptionNullValues
unique_keytext—0%101730691017307010173089
created_datedatetime—0%2008-12-22T00:00:00.0002008-01-03T00:00:00.0002008-10-28T00:00:00.000
closed_datedatetime—2%2009-06-01T00:00:00.0002008-12-29T00:00:00.0002008-12-01T00:00:00.000
agencycategorical—0%HPDDOTDEPof 14

Query this from your own app

GET /api/datasets/uzcy-9puk
GET /api/datasets/uzcy-9puk/quality
GET /api/datasets/uzcy-9puk/related
GET /api/columns?dataset=uzcy-9puk
  • 311 Service Requests from 2020 to Present0.38
    joins onlongituderoad_rampbridge_highway_segment+37
  • NYC Service: Volunteer Opportunities (Historical)0.34
    joins onlongitude:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q+8
  • LinkNYC New Site Permit Applications0.28
    joins onlongitude:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q+7
  • DYCD Program Sites0.28
    joins onlongitude:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q+6
  • DHS Data Dashboard0.28
  • Shelter Repair Scorecard0.28
    joins onboroughfacility_type
    • 107621802008-03-20T00:00:00.0002008-03-20T00:00:00.000DOTDepartment of TransportationTraffic Signal ConditionVeh Signal Visor—————
    107622472008-03-20T00:00:00.0002008-03-20T00:00:00.000DOTDepartment of TransportationTraffic Signal ConditionController—————
    107622542008-03-20T00:00:00.0002008-03-21T00:00:00.000DOTDepartment of TransportationTraffic Signal ConditionVeh Signal Head—————
    107622582008-03-20T00:00:00.0002008-03-22T00:00:00.000DEPDepartment of Environmental ProtectionSewerCatch Basin Clogged/Flooding (Use Comments) (SC)—————
    107622612008-03-20T00:00:00.0002008-03-20T00:00:00.000DOTDepartment of TransportationTraffic Signal ConditionController—————
    107622652008-03-20T00:00:00.0002008-03-21T00:00:00.000DOTDepartment of TransportationTraffic Signal ConditionController—————
    107612062008-03-20T00:00:00.0002008-03-20T00:00:00.000DOTDepartment of TransportationTraffic Signal ConditionController—————
    107620832008-03-20T00:00:00.0002008-03-20T00:00:00.000DEPDepartment of Environmental ProtectionWater SystemNo Water/Low Pressure (WA5)—1114 BAY RDGE AVEBAY RDGE AVE11 AVE12 AVE
    107581512008-03-20T00:00:00.0002008-03-20T00:00:00.000DOTDepartment of TransportationTraffic Signal ConditionController—————

    Showing 12 of 31 columns. All of them are listed below.

    agency_nametext—0%Department of Housing Pr…Department of Transporta…Department of Environmen…
    complaint_typetext—0%HEATINGStreet Light ConditionGENERAL CONSTRUCTION
    descriptortext—0%HEATStreet Light OutVERMIN
    location_typetext—35%RESIDENTIAL BUILDINGStreetStreet/Sidewalk
    incident_ziptext—7%112261120710458
    incident_addresstext—22%223 EAST 32 STREET34 ARDEN STREET BELT PKWY
    street_nametext—22%BROADWAYGRAND CONCOURSEOCEAN AVENUE
    cross_street_1text—23%BENDBROADWAY3 AVENUE
    cross_street_2text—23%BENDBROADWAY2 AVENUE
    intersection_street_1text—79%BROADWAY3 AVE4 AVENUE
    intersection_street_2text—79%BROADWAY5 AVENUE3 AVENUE
    address_typecategorical—3%ADDRESSINTERSECTIONBLOCKFACEof 4
    citytext—7%BROOKLYNNEW YORKBRONX
    landmarktext—100%J F K AIRPORTLA GUARDIA AIRPORTPENNSYLVANIA STATION
    facility_typecategorical—0%N/APrecinctDSNY Garageof 5
    statuscategorical—0%ClosedPendingAssignedof 8
    due_datedatetime—77%2006-03-22T00:00:00.0002008-04-19T00:00:00.0002008-04-25T00:00:00.000
    resolution_action_updated_datedatetime—1%2008-06-30T00:00:00.0002008-12-29T00:00:00.0002009-06-01T00:00:00.000
    community_boardtext—0%0 Unspecified12 QUEENS07 QUEENS
    boroughcategorical—0%UnspecifiedQUEENSBROOKLYNof 6
    x_coordinate_state_plane_integer—7%99025010044021001778
    y_coordinate_state_plane_integer—7%210392253313251472
    park_facility_nametext—0%UnspecifiedRiverside ParkCentral Park
    park_boroughcategorical—0%UnspecifiedQUEENSBROOKLYNof 6
    school_nametext—0%UnspecifiedRiverside ParkCentral Park
    school_numbertext—0%UnspecifiedM010M071
    school_regioncategorical—0%UnspecifiedRegion 7Region 2of 13
    school_codetext—0%Unspecified20K20120K505
    school_phone_numbertext—0%Unspecified21240801007189658900
    school_addresstext—0%UnspecifiedRiverside Drive to Hudso…5th Avenue to Central Pa…
    school_citytext—0%UnspecifiedBROOKLYNNEW YORK
    school_statecategorical—0%UnspecifiedNYof 2
    school_ziptext—0%Unspecified1002310021
    school_not_foundcategorical—100%NYof 2
    school_or_citywide_complaintcategorical—100%SchoolCitywide Complaintof 2
    vehicle_typecategorical—100%Car ServiceAmbulette / ParatransitCommuter Vanof 3
    taxi_company_boroughcategorical—100%BROOKLYNQUEENSMANHATTANof 5
    taxi_pick_up_locationcategorical—99%OtherIntersectionJFK Airportof 7
    bridge_highway_nametext—100%BQE/Gowanus ExpwyBelt PkwyVan Wyck Expwy
    bridge_highway_directiontext—100%West/Staten Island BoundNorth/Bronx BoundEast/Queens Bound
    road_rampcategorical—100%RoadwayRampN/Aof 3
    bridge_highway_segmenttext—100%RoadwayRampN/A
    garage_lot_nametext—100%Flushing #1 FieldSI Ferry TerminalFlushing #3 Field
    ferry_directioncategorical—100%Staten Island BoundManhattan BoundN/Aof 3
    ferry_terminal_nametext—100%UnknownSt. George Terminal (Sta…Whitehall Terminal (Manh…
    latitudefloat—7%40.7441520003032840.8619373819063140.85688767546475
    longitudefloat—7%-73.97834694751151-73.92714580413967-73.93255208623478
    locationcoordinate———