City Record Online (CROL)

Source Metadata

name City Record Online
description 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.
attribution Department of Citywide Administrative Services (DCAS)
id dg92-zbpx
assetType dataset
attributionLink https://a856-cityrecord.nyc.gov/Section
category City Government
createdAt 2015-04-15 16:29:36
provenance official
rowsUpdatedAt 2025-12-17 13:29:38
Columns
Name Data Type Description Field Name
RequestID number Unique identifier for the City Record notice request_id
StartDate calendar_date The first date on which the notice appears in the paper publication start_date
EndDate calendar_date The last date on which the notice appears in the paper publication end_date
AgencyName text The agency which has submitted the notice agency_name
TypeOfNoticeDescription text A description of the published notice type_of_notice_description
CategoryDescription text The category of the published notice category_description
ShortTitle text Short Title short_title
SelectionMethodDescription text For procurement notices: the selection method to be used, such as Competitive Sealed Bids or Competitive Sealed Proposals selection_method_description
SectionName text The section of the City Record in which the notice appears section_name
SpecialCaseReasonDescription text For procurement notices: the rationale for using the listed selection method, such as "available only from a single source" special_case_reason_description
PIN text For procurement notices: Procurement Identification Number pin
DueDate calendar_date For procurement notices: The date when the bid or other response is due due_date
AddressToRequest text For procurement notices: The address to which bids or other responses are to be sent address_to_request
ContactName text For procurement notices: The person to contact for procurement notice information contact_name
ContactPhone text For procurement notices: The person to contact for procurement notice information contact_phone
Email text For procurement notices: The email address to which requests for procurement notice information can be sent email
ContractAmount number For procurement notices: The amount of the contract for which bids or other responses are being solicited contract_amount
ContactFax text For procurement notices: The fax number for procurement notice information contact_fax
AdditionalDescription1 text Additional information regarding the notice not included in other fields additional_description_1
AdditionalDesctription2 text Additional information regarding the notice not included in other fields(2) additional_description_2
AdditionalDescription3 text Additional information regarding the notice not included in other fields(3) additional_description_3
OtherInfo1 text Further information regarding the notice other_info_1
OtherInfo2 text Further information regarding the notice(2) other_info_2
OtherInfo3 text Further information regarding the notice(3) other_info_3
VendorName text For procurement award notices: name of vendor vendor_name
VendorAddress text For procurement award notices: address of vendor vendor_address
Printout1 text Formatted OtherInfo or AdditionalDescription, depending on the notice printout_1
Printout2 text Formatted OtherInfo or AdditionalDescription, depending on the notice(2) printout_2
Printout3 text Formatted OtherInfo or AdditionalDescription, depending on the notice(3) printout_3
DocumentLinks url Links to the public facing City Record website to view any documents associated with the notice document_links
EventDate calendar_date For public hearings and meetings notices: Date and time of event event_date
EventBuildingName text For public hearings and meetings notices: Building name where the event is being held building_name
EventStreetAddress1 text For public hearings and meetings notices: Address where the event is being held street_address_1
EventStreetAddress2 text For public hearings and meetings notices: Address where the event is being held(2) street_address_2
EventCity text For public hearings and meetings notices: City where the event is being held city
EventStateCode text For public hearings and meetings notices: State where the event is being held state
EventZipCode text For public hearings and meetings notices: Zip Code for the location where the event is being held zip_code

Databook Transformation

Normalized Fields AgencyName
Next Update Scheduled
Activity
Source Data Last Updated 2025-12-17 13:29:38
Transformed Data Last Updated 12/08/2025 19:16
Columns Added Calculating...
Added Column Names Calculating...

Data Previews

Loading data...

Loading data...