From a 500-row sample across 10 columns.
council_districtfiscal_yearboroughcouncil_districtboroughboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| reported | fiscal_year | borough | award | council_district | sponsor | title | description | id | budget_line |
|---|---|---|---|---|---|---|---|---|---|
| 2019 | FY19 | X | 250000 | 16 | Gibson | VOLUNTEERS OF AMERICA | CLARKE PLACE SENIOR RESIDENCE PROJECT | AG CN002 | HD D024 |
| 2019 | FY19 | K | 3640000 | 37 | Speaker, Espinal |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
reported | categorical | The Fiscal Year of the report. | 0% | 202020192022of 15 |
fiscal_year | categorical | The Fiscal Year the award was granted. | 0% | FY20FY19FY21of 11 |
borough | categorical | Borough of grantee. | 0% | QKMof 11 |
award | integer | Amount granted (in dollars) for the capital project represented by the row. | 0% | 50000100000150000 |
GET /api/datasets/t474-a92g GET /api/datasets/t474-a92g/quality GET /api/datasets/t474-a92g/related GET /api/columns?dataset=t474-a92g
titleborough| CYPRESS HILLS CHILD CARE CENTER |
| CONSTRUCTION OF A CHILD CARE CENTER |
| CS NC001 |
| CS DN956 |
| 2019 | FY19 | M | 425000 | 5 | Kallos | [SCA] [02M077/02M198] LOWER LAB/ISADOR E. IDA STRAUS | HVAC SYSTEM FOR CAFETERIA | E CN001 | E D001 |
| 2019 | FY19 | M | 100000 | 5 | Kallos | [SCA] [02M077/02M198] LOWER LAB/ISADOR E. IDA STRAUS | PLAYGROUND RENOVATION | E CN002 | E D001 |
| 2019 | FY19 | M | 35000 | 5 | Kallos | [SCA] [02M114] EAST SIDE MIDDLE SCHOOL | TECHNOLOGY UPGRADES | E CN003 | E D001 |
| 2019 | FY19 | M | 35000 | 5 | Kallos | [SCA] [02M151] YORKVILLE COMMUNITY SCHOOL | TECHNOLOGY UPGRADES | E CN004 | E D001 |
| 2019 | FY19 | M | 461000 | 5 | Kallos | [SCA] [02M151] YORKVILLE COMMUNITY SCHOOL | PLAYSPACE PROJECT | E CN005 | E D001 |
| 2019 | FY19 | M | 210000 | 5 | Kallos | [SCA] [02M158/02M177] BAYARD TAYLOR/YORKVILLE EAST MIDDLE SCHOOL | SECURITY CAMERAS | E CN006 | E D001 |
| 2019 | FY19 | M | 600000 | 5 | Kallos | [SCA] [02M183] ROBERT L. STEVENSON SCHOOL | HVAC SYSTEM FOR CAFETERIA | E CN007 | E D001 |
| 2019 | FY19 | M | 35000 | 5 | Kallos | [SCA] [02M217] ROOSEVELT ISLAND SCHOOL | TECHNOLOGY UPGRADES | E CN008 | E D001 |
council_district |
| integer |
| "Numeric ID version of ""Sponsor"". Comma separated list of numeric ID's of representatives supporting funding for the project. Numbers from 1 to 51 represent districts, others represent delegations, caucuses or the Speaker. " |
| 0% |
0503 |
sponsor | text | Comma separated names of the Representatives, delegations, and/or caucuses supporting funding. There can be multiple Sponsors. | 0% | SpeakerRiveraPowers |
title | text | A title for the capital project allocation. | 0% | QUEENS COLLEGETHE CAMPAIGN AGAINST HUN…MAIMONIDES MEDICAL CENTE… |
description | text | A description of what the funding will be used for (e.g. "AUDITORIUM UPGRADE" or "ROADWAY RESURFACING") | 0% | TECHNOLOGY UPGRADESTECHNOLOGY UPGRADETECHNOLOGY |
id | text | An ID for the award that is unique by year. | 0% | E CN459E CN182E CN024 |
budget_line | text | The funding line in which the project's funds were allocated. | 0% | E D001E D001P D019 |