Dataset: Greenbook

About this Dataset

Greenbook

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.
Organization: City of New York
Last updated: 2020-11-10T17:04:07.811477
Tags: admin, cei, city-government, citywide-equity-and-inclusion, construction-and-technical-services, contacts, cts, dcas, dem, department-of-citywide-administrative-services, department-of-energy-management, eal-estate-services, facilities-management, fbm, fiscal-and-business-management, fleet, fm, government, greenbook, hc, human-capital, ocp, office-of-citywide-procurement, office-of-general-counsel, ogc, res

Tables

Table 1

@usgov.city_of_new_york_greenbook.table_1

132.77 KB
2592 rows
23 columns


CREATE TABLE table_1 (
  "agency_name" VARCHAR,
  "agency_acronym" VARCHAR,
  "agency_website" VARCHAR,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "middle_initial" VARCHAR,
  "name_suffix" VARCHAR,
  "office_title" VARCHAR,
  "division_name" VARCHAR,
  "parent_division" VARCHAR,
  "grand_parent_division" VARCHAR,
  "great_grand_parent_division" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "phone_1" VARCHAR,
  "phone_2" VARCHAR,
  "fax_1" VARCHAR,
  "fax_2" VARCHAR,
  "agency_primary_phone" VARCHAR,
  "division_primary_phone" VARCHAR,
  "section" VARCHAR
);