From a 500-row sample across 29 columns.
agency_namezip_codestate+1stateHas zip codes (`zip_code`) — joinable, but needs boundary shapes to draw.
| request_id | start_date | end_date | agency_name | short_title | section_name | additional_description_1 |
|---|---|---|---|---|---|---|
| 338008 | 2018-01-26T00:00:00.000 | 2018-01-01T00:00:00.000 | BOARD OF ELECTION POLL WORKERS | APPOINTED | Changes in Personnel | Effective Date: 01/01/2018; Provisional Status: Yes; Title Code: 9POLL; Reason For Change: APPOINTED; Salary: 1.00; Employee Name: MONERO,MALIACA N. |
| 540677 | 2020-10-16T00:00:00.000 | 2020-01-01T00:00:00.000 | BOARD OF ELECTION POLL WORKERS | APPOINTED | Changes in Personnel |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
request_id | integer | Unique identifier for the City Record notice | 0% | 345 |
start_date | datetime | The first date on which the notice appears in the paper publication | 0% | 2020-10-30T00:00:00.0002020-10-16T00:00:00.0002024-09-27T00:00:00.000 |
end_date | datetime | The last date on which the notice appears in the paper publication | 0% | 2020-01-01T00:00:00.0002016-01-01T00:00:00.0002024-01-01T00:00:00.000 |
agency_name | text | The agency which has submitted the notice | 0% |
GET /api/datasets/dg92-zbpx GET /api/datasets/dg92-zbpx/quality GET /api/datasets/dg92-zbpx/related GET /api/columns?dataset=dg92-zbpx
agency_name| Effective Date: 01/01/2020; Provisional Status: Yes; Title Code: 9POLL; Reason For Change: APPOINTED; Salary: 1.00; Employee Name: CARSWELL,DIVINE L. |
| 113454 | 2013-08-02T00:00:00.000 | 2013-01-01T00:00:00.000 | BOARD OF ELECTION POLL WORKERS | APPOINTED | Changes in Personnel | Effective Date: 01/01/2013; Provisional Status: Yes; Title Code: 9POLL; Reason For Change: APPOINTED; Salary: 1.00; Employee Name: MILLS,JAMES M. |
| 608329 | 2021-01-22T00:00:00.000 | 2021-01-01T00:00:00.000 | BOARD OF ELECTION POLL WORKERS | APPOINTED | Changes in Personnel | Effective Date: 01/01/2021; Provisional Status: Yes; Title Code: 9POLL; Reason For Change: APPOINTED; Salary: 1.00; Employee Name: NEFF,MAUREEN H. |
| 333004 | 2017-12-29T00:00:00.000 | 2017-11-19T00:00:00.000 | DEPARTMENT OF EDUCATION ADMIN | APPOINTED | Changes in Personnel | Effective Date: 11/19/2017; Provisional Status: Yes; Title Code: 12158; Reason For Change: APPOINTED; Salary: 47663.00; Employee Name: GENTOLIA,ADRIANNE . |
| 156773 | 2015-09-25T00:00:00.000 | 2015-09-03T00:00:00.000 | DEPARTMENT OF EDUCATION ADMIN | APPOINTED | Changes in Personnel | Effective Date: 09/03/2015; Provisional Status: Yes; Title Code: 56056; Reason For Change: APPOINTED; Salary: 29318.00; Employee Name: KARASEV,NIKITA . |
| 9208 | 2013-09-13T00:00:00.000 | 2013-01-01T00:00:00.000 | BOARD OF ELECTION POLL WORKERS | APPOINTED | Changes in Personnel | Effective Date: 01/01/2013; Provisional Status: Yes; Title Code: 9POLL; Reason For Change: APPOINTED; Salary: 1.00; Employee Name: MARTINEZ CORZO,MARIA A. |
| 124677 | 2014-03-14T00:00:00.000 | 2014-01-02T00:00:00.000 | HRA/DEPT OF SOCIAL SERVICES | RESIGNED | Changes in Personnel | Effective Date: 01/02/2014; Provisional Status: Yes; Title Code: 10050; Reason For Change: RESIGNED; Salary: 97344.00; Employee Name: SYLVIA,MICHAEL H. |
| 396621 | 2018-11-02T00:00:00.000 | 2018-09-27T00:00:00.000 | DEPT OF PARKS & RECREATION | RESIGNED | Changes in Personnel | Effective Date: 09/27/2018; Provisional Status: Yes; Title Code: 80633; Reason For Change: RESIGNED; Salary: 13.80; Employee Name: ORTIZ,MODESTA . |
| 218666 | 2016-08-26T00:00:00.000 | 2016-07-31T00:00:00.000 | DEPARTMENT OF TRANSPORTATION | APPOINTED | Changes in Personnel | Effective Date: 07/31/2016; Provisional Status: Yes; Title Code: 35007; Reason For Change: APPOINTED; Salary: 29842.00; Employee Name: COLON,ALEJANDR A. |
BOARD OF ELECTION POLL W…POLICE DEPARTMENTDEPARTMENT OF EDUCATION …type_of_notice_description | categorical | A description of the published notice | 88% | AwardSolicitationPublic Hearingsof 10 |
category_description | categorical | The category of the published notice | 90% | GoodsServices (other than hum…Human Services/Client Se…of 6 |
short_title | text | Short Title | 0% | APPOINTEDRESIGNEDINCREASE |
selection_method_description | text | For procurement notices: the selection method to be used, such as Competitive Sealed Bids or Competitive Sealed Proposals | 90% | Competitive Sealed BidsRenewalNegotiated Acquisition |
section_name | categorical | The section of the City Record in which the notice appears | 0% | Changes in PersonnelProcurementContract Award Hearingsof 9 |
special_case_reason_description | categorical | For procurement notices: the rationale for using the listed selection method, such as "available only from a single source" | 98% | Other (Describe below in…Judgment required in eva…Available only from a si…of 5 |
pin | text | For procurement notices: Procurement Identification Number | 91% | NoPINFoundSEE BELOWLINE 17 BELOW |
due_date | datetime | For procurement notices: The date when the bid or other response is due | 95% | 2006-02-15T15:00:00.0002006-12-26T15:00:00.0002006-02-16T15:00:00.000 |
address_to_request | text | For procurement notices: The address to which bids or other responses are to be sent | 96% | Office of Vendor Relatio…Olmsted Center, Room 64,…90 Church Street, 6th Fl… |
contact_name | text | For procurement notices: The person to contact for procurement notice information | 95% | Jeanette MegnaVendor HotlineJuan Alban |
contact_phone | text | For procurement notices: The person to contact for procurement notice information | 93% | 212669756421266975687183912601 |
email | For procurement notices: The email address to which requests for procurement notice information can be sent | 96% | vendorhotline@schools.ny…juan.alban@parks.nyc.govdcasdmssbids@dcas.nyc.go… |
contract_amount | integer | For procurement notices: The amount of the contract for which bids or other responses are being solicited | 95% | 0-1100000 |
contact_fax | text | For procurement notices: The fax number for procurement notice information | 99% | 212306510971839126152126697603 |
additional_description_1 | text | Additional information regarding the notice not included in other fields | 5% | A copy of the bid can be…<p> <strong>City Planni…Interested firms are inv… |
additional_description_2 | text | Additional information regarding the notice not included in other fields(2) | 100% | 07057</p> </td> <t…0in;line-height:normal;'…;0in;margin-bottom:0in;0… |
additional_description_3 | text | Additional information regarding the notice not included in other fields(3) | 100% | 021 New York City Execut….0pt;'>, 17, 20</span></…1e'><span style='font-si… |
other_info_1 | text | Further information regarding the notice | 97% | N/ABid documents are availa…The New York City Depart… |
other_info_2 | text | Further information regarding the notice(2) | 100% | — |
other_info_3 | text | Further information regarding the notice(3) | 100% | — |
vendor_name | text | For procurement award notices: name of vendor | 95% | Dell Marketing L.P.Compulink Technologies, …Gabrielli Truck Sales Lt… |
vendor_address | text | For procurement award notices: address of vendor | 95% | One Dell Way, MS RR#1-33260 W 39th Street153-20 South Conduit Ave… |
printout_1 | text | Formatted OtherInfo or AdditionalDescription, depending on the notice | 94% | DISASTER RELIEF SERVICES…ASBESTOS ABATEMENT - Sma…CONCESSION OPPORTUNITIES… |
printout_2 | text | Formatted OtherInfo or AdditionalDescription, depending on the notice(2) | 100% | — |
printout_3 | text | Formatted OtherInfo or AdditionalDescription, depending on the notice(3) | 100% | — |
document_links | url | Links to the public facing City Record website to view any documents associated with the notice | — | {'url': 'https://a856-ci…{'url': 'https://a856-ci…{'url': 'https://a856-ci… |
event_date | datetime | For public hearings and meetings notices: Date and time of event | 98% | 2022-02-24T10:00:00.0002021-01-13T10:00:00.0002021-08-19T10:00:00.000 |
building_name | text | For public hearings and meetings notices: Building name where the event is being held | 100% | The David N. Dinkins Mun…City HallOffice of the Bronx Boro… |
street_address_1 | text | For public hearings and meetings notices: Address where the event is being held | 99% | Address Not Listed In Th…1 Centre Street22 Reade Street |
street_address_2 | text | For public hearings and meetings notices: Address where the event is being held(2) | 100% | Spector HallNorth Mezzanine9th Floor |
city | text | For public hearings and meetings notices: City where the event is being held | 99% | New YorkFlushingBrooklyn |
state | text | For public hearings and meetings notices: State where the event is being held | 99% | NYof 1 |
zip_code | text | For public hearings and meetings notices: Zip Code for the location where the event is being held | 99% | 100071003810004 |