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

Greenbook

mdcw-n682City Government23 columns
The Green Book Online is a fully searchable database which gives New Yorkers the opportunity to search for the agencies, offices, boards and commissions that keep our City running. It includes listings for all levels of New York City government, County, and the unified Courts system.
View on NYC Open Data↗

Quality

B89.0 / 100

From a 500-row sample across 21 columns.

completeness66/ 25% weight
consistency98/ 20% weight
accuracy100/ 20% weight
timeliness100/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • City Record Online0.41
    joins onstatecityzip_code+1
  • Civil Service List Certification0.40
    joins onlast_namefirst_name
  • Civil Service List (Active)0.39
    joins onlast_namefirst_name
  • Jobs NYC Postings0.37
  • Civil List0.36
    joins onagency_name
  • Evictions

Geography

Has zip codes (`zip_code`) — joinable, but needs boundary shapes to draw.

Sample rows

agency_nameagency_acronymagency_websitefirst_namelast_nameoffice_titleaddresscitystatezip_codephone_1agency_primary_phone
Employees Retirement System Board of Trustees, NYCNYCERSNYC.gov/html/nycersElizabethReyesExecutive Director335 Adams St.BrooklynNY11201(347) 643-3377(347) 643-3000

Columns

23 queryable · 23 profiled

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

FieldTypeDescriptionNullValues
agency_nametextGovernment Agency Name0%City University of New Y…ComptrollerHealth & Mental Hygiene,…
agency_acronymtextGovernment Agency Acronym27%CUNYDOHMHHRA DSS
agency_websiteurlWeb Address (URL) of Government Agency16%www.cuny.eduhttps://comptroller.nyc.…NYC.gov/health
first_nametextFirst Name of Employee0%VacantMichael

Query this from your own app

GET /api/datasets/mdcw-n682
GET /api/datasets/mdcw-n682/quality
GET /api/datasets/mdcw-n682/related
GET /api/columns?dataset=mdcw-n682
0.32
  • Trade Waste Hauler Licensees0.32
    joins onstatecityaddress
  • Construction Demolition Registrants0.31
    joins onstatecityaddress
    • City Council
    NYCC
    —
    Elsie
    Encarnacion
    Member of City Council
    250 Broadway
    New York
    NY
    10007
    —
    (212) 788-7210
    City CouncilNYCC—ChiOsséMember of City Council250 BroadwayNew YorkNY10007—(212) 788-7210
    City University of New YorkCUNYwww.cuny.eduFélixMatos RodríguezChancellor205 E. 42nd St.New YorkNY10017(646) 664-91001-800-CUNY-YES
    City CouncilNYCC—ShirleyAldebolMember of City Council250 BroadwayNew YorkNY10007—(212) 788-7210
    Cultural AffairsDCLAhttps://www.nyc.gov/site/dcla/index.pageCristiánSamperPresident & CEO2300 Southern BoulevardBronxNY10460—(212) 298-8700
    Health & Mental Hygiene, Department ofDOHMHNYC.gov/healthJorgePetitExecutive Deputy Commissioner42-09 28th St.Long Island CityNY11101347-936-7153311
    New York State Supreme Court Appellate Division - First Department (New York and Bronx County)——VerónicaGuerreroCounsel to the Committee on Character & Fitness41 Madison Ave.New YorkNY10010—(212) 340-0400
    City University of New YorkCUNYwww.cuny.eduEugeneSohnExecutive Counsel & Labor Designee205 E. 42nd St.New YorkNY10017(718) 518-42811-800-CUNY-YES
    City CouncilNYCC—JulieMeninSpeaker of City Council250 BroadwayNew YorkNY10007—(212) 788-7210

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

    John
    last_nametextLast Name of Employee0%VacantWilliamsBrown
    m_itextMiddle Initial of Employee90%JMA
    name_suffixtextName Suffix of Employee92%Esq.P.E.PhD
    office_titletextOffice Title of Employee0%Assistant CommissionerDeputy CommissionerExecutive Director
    division_nametextPrimary Division/Office/Unit in which employee works28%AdministrationOperationsDistrict Attorney - Rich…
    parent_divisiontextDivision/Office/Unit overseeing primary Division71%Senior CollegesCommunity CollegesCultural Institutions Gr…
    grand_parent_divisioncategoricalDivision/Office/Unit overseeing Parent Division95%Members of the CouncilBorough OfficesOffice of the First Depu…of 11
    great_grand_parentdivisiontextDivision/Office/Unit overseeing Grand Parent Division100%—
    addresstextStreet address of employee work location0%205 E. 42nd St.1 Centre St.33 Beaver St.
    citytextCity of employee work location0%New YorkBrooklynLong Island City
    statecategoricalState of employee work location0%NYDCof 2
    zip_codetextZip code of employee work location0%100071001710038
    phone_1phonePrimary work phone number for employee19%(212) 788-5800(718) 590-3500(347) 404-9772
    phone_2phoneSecondary work phone number for employee99%(212) 274-5600(212) 323-1599(212) 323-1831of 13
    fax_1phonePrimary fax number for employee96%(212) 720-3303(212) 839-6490(718) 260-5406
    fax_2textSecondary fax number for employee100%—
    agency_primary_phonephoneMain phone number for agency10%1-800-CUNY-YES(212) NEW-YORK311
    division_primary_phonephoneMain phone number for division69%(718) 876-6300(212) 220-8000(718) 260-5400
    sectioncategoricalSection of Green Book for listing0%CityCountyCourtsof 3