Greenbook

Source Metadata

name Greenbook
description 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.
attribution Department of Citywide Administrative Services (DCAS)
id mdcw-n682
assetType dataset
attributionLink https://a856-gbol.nyc.gov/GBOLWebsite/GreenBook/Online
category City Government
createdAt 2015-04-27 21:26:31
provenance official
rowsUpdatedAt 2025-12-10 20:49:24
Columns
Name Data Type Description Field Name
Agency Name text Government Agency Name agency_name
Agency Acronym text Government Agency Acronym agency_acronym
Agency Website text Web Address (URL) of Government Agency agency_website
First Name text First Name of Employee first_name
Last Name text Last Name of Employee last_name
Middle Initial text Middle Initial of Employee m_i
Name Suffix text Name Suffix of Employee name_suffix
Office Title text Office Title of Employee office_title
Division Name text Primary Division/Office/Unit in which employee works division_name
Parent Division text Division/Office/Unit overseeing primary Division parent_division
Grand Parent Division text Division/Office/Unit overseeing Parent Division grand_parent_division
Great Grand Parent Division text Division/Office/Unit overseeing Grand Parent Division great_grand_parentdivision
Address text Street address of employee work location address
City text City of employee work location city
State text State of employee work location state
Zip Code text Zip code of employee work location zip_code
Phone 1 text Primary work phone number for employee phone_1
Phone 2 text Secondary work phone number for employee phone_2
Fax 1 text Primary fax number for employee fax_1
Fax 2 text Secondary fax number for employee fax_2
Agency Primary Phone text Main phone number for agency agency_primary_phone
Division Primary Phone text Main phone number for division division_primary_phone
Section text Section of Green Book for listing section

Databook Transformation

Normalized Fields Agency Name
Next Update Scheduled
Activity
Source Data Last Updated 2025-12-10 20:49:24
Transformed Data Last Updated 12/11/2025 03:22
Columns Added Calculating...
Added Column Names Calculating...

Data Previews

Loading data...

Loading data...