About this Dataset

City Record Online

The City Record Online (CROL) is a fully searchable database of notices published in the City Record newspaper, including, but not limited to: public hearings and meetings, public auctions and sales, solicitations and awards and official rules proposed and adopted by city agencies.
Organization: City of New York
Last updated: 2020-11-10T17:02:29.281516
Tags: admin, auctions, awards, cei, city-record, city-record-online, citywide-equity-and-inclusion, construction-and-technical-services, cro, cts, dcas, dem, department-of-citywide-administrative-services, department-of-energy-management, eal-estate-services, facilities-management, fbm, fiscal-and-business-management, fleet, fm, hc, human-capital, ocp, office-of-citywide-procurement, office-of-general-counsel, official-notices, ogc, public-hearings, res, rules, solicitations

Tables

Table 1

@usgov.city_of_new_york_city_record_online.table_1

133.72 MB
1,014,828 rows
37 columns

CREATE TABLE table_1 (
  "requestid" BIGINT,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "agencyname" VARCHAR,
  "typeofnoticedescription" VARCHAR,
  "categorydescription" VARCHAR,
  "shorttitle" VARCHAR,
  "selectionmethoddescription" VARCHAR,
  "sectionname" VARCHAR,
  "specialcasereasondescription" VARCHAR,
  "pin" VARCHAR,
  "duedate" VARCHAR,
  "addresstorequest" VARCHAR,
  "contactname" VARCHAR,
  "contactphone" VARCHAR,
  "email" VARCHAR,
  "contractamount" DOUBLE,
  "contactfax" DOUBLE,
  "additionaldescription1" VARCHAR,
  "additionaldesctription2" VARCHAR,
  "additionaldescription3" VARCHAR,
  "otherinfo1" VARCHAR,
  "otherinfo2" VARCHAR,
  "otherinfo3" VARCHAR,
  "vendorname" VARCHAR,
  "vendoraddress" VARCHAR,
  "printout1" VARCHAR,
  "printout2" VARCHAR,
  "printout3" VARCHAR,
  "documentlinks" VARCHAR,
  "eventdate" VARCHAR,
  "eventbuildingname" VARCHAR,
  "eventstreetaddress1" VARCHAR,
  "eventstreetaddress2" VARCHAR,
  "eventcity" VARCHAR,
  "eventstatecode" VARCHAR,
  "eventzipcode" VARCHAR
);