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

Newsrack Inspections

aizm-q3sxTransportation16 columns
Tracks complaints, inspections and reinspections of News racks and reports on the Inspection results.
View on NYC Open Data↗

Quality

A94.6 / 100

From a 500-row sample across 16 columns.

completeness89/ 25% weight
consistency88/ 20% weight
accuracy100/ 20% weight
timeliness99/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Sidewalk Dismissal Inspection Tracking0.38
  • Street Resurfacing Schedule0.37
    joins onboroughnamefromstreetnametostreetname+1
  • Sidewalk Management Database - Inspection0.34
  • Sidewalk Management Database - Violations0.33
  • Street Closures due to Construction Activities by Intersection0.33
    joins onfromstreetnameonstreetname
  • Open Restaurants Inspections (Historical)0.32

Geography

Has borough codes (`boroughname`) — joinable, but needs boundary shapes to draw.

Sample rows

newsracklocationidboroughnamepublishernamepublicationnamenewsrackstatusnewsrackstatustypenewsrackstatusdatenewsrackactiveonstreetnamefromstreetnametostreetnamecompassdirection
14171QueensSchneps Media , LLCQueens FamilyInspected/In ComplianceInspection Status2023-08-03T12:19:23.000YesQUEENS BOULEVARD70 ROAD71 AVENUES

Columns

16 queryable · 16 profiled

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

FieldTypeDescriptionNullValues
newsracklocationidinteger—0%11532104099027
boroughnamecategorical—0%ManhattanBrooklynQueensof 5
publishernametext—0%Schneps Media , LLCU.S.A. Distributors, Inc…SB New York, Inc.
publicationnametext—0%El Especial / El Especia…AM New YorkMetro New York

Query this from your own app

GET /api/datasets/aizm-q3sx
GET /api/datasets/aizm-q3sx/quality
GET /api/datasets/aizm-q3sx/related
GET /api/columns?dataset=aizm-q3sx
TLC Approved LabCorp Patient Services Drug Test Locations0.32
  • Routes0.32
    • 6733BrooklynTachlis Magazine, LLCTachlis of BrooklynInspected/In ComplianceInspection Status2019-02-20T10:24:19.000Yes13 AVENUE44 STREET45 STREETE
    2924BrooklynWilliamsburg Bulletin Corp.Williamsburg BulletinNOV IssuedInspection Status2019-02-20T10:48:01.000Yes13 AVENUE45 STREET—N/E
    6713ManhattanU.S.A. Distributors, Inc.El Especial / El EspecialitoNOV IssuedInspection Status2019-03-01T15:10:26.000YesEAST 108 STREETLEXINGTON AVENUE—N/W
    6744Brooklyn5 Towns Jewish Times Inc.5 Towns Jewish TimesInspected/In ComplianceInspection Status2019-02-20T14:38:29.000Yes13 AVENUE49 STREET—S/E
    6784ManhattanMSP Distribution Systems, LLCEmployment Guide, TheInspected/In ComplianceInspection Status2019-03-30T14:27:18.000YesEAST 8 STREETUNIVERSITY PLACE—S/E
    2967BrooklynBrooklyn Link Inc., TheWeekly Link, TheInspected/In ComplianceInspection Status2019-02-20T15:41:33.000Yes13 AVENUE52 STREET—N/W
    6525BrooklynNew York Post Holdings, Inc.New York Post, TheRemoved By DOTInspection Status2019-02-07T11:20:55.000NoOLIVER STREETMARINE AVENUESHORE ROADE
    6764BrooklynTachlis Magazine, LLCTachlis of BrooklynInspected/In ComplianceInspection Status2019-02-21T13:19:13.000Yes13 AVENUE55 STREET56 STREETW
    6747BrooklynExpress Lane LLCExpress LaneRemoved By DOTInspection Status2019-02-07T14:21:30.000No13 AVENUE50 STREET—N/E

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

    newsrackstatuscategorical—0%Inspected/In ComplianceNewsrack Not FoundTicket Closed by DOTof 14
    newsrackstatustypecategorical—0%Inspection StatusInternal Process Statusof 2
    newsrackstatusdatedatetime—0%2015-09-29T14:15:07.0002015-09-29T14:15:06.0002015-09-29T14:15:05.000
    newsrackactivecategorical—0%YesNoof 2
    onstreetnametext—0%BROADWAY1 AVENUE5 AVENUE
    fromstreetnametext—0%LEXINGTON AVENUEQUEENS BOULEVARDROOSEVELT AVENUE
    tostreetnametext—69%WEST 15 STREETNYCTA SUBWAYEAST 14 STREET
    compassdirectioncategorical—0%N/WN/ES/Wof 8
    specificlocationtext—97%I.F.O City BankIn front of train statio…Ifo chase bank
    communitydistrictleftinteger—0%107108301
    lastinspecteddatedatetime—0%2023-03-16T08:51:13.0002023-02-27T13:49:59.0002023-02-27T11:48:01.000
    lastinspectionresultcategorical—0%Inspected/In ComplianceNewsrack Not FoundTicket Closed by DOTof 14