From a 500-row sample across 13 columns.
pub_dateyear1_amtyear2_amt+5pub_dateprojtype_descpub_dateyear1_amt+7| pub_date | projtype | projtype_desc | budline | funding | num_yrs_prsnt | yr1_fy | year1_amt | year2_amt | year3_amt | year4_amt | year5_amt |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 20160426 | HD | HOUSING & DEVELOPMENT | HDKN525 | CITY | 5 | 2016 | 0.00 | 500 | 0 | 0 | 0 |
| 20160426 | E | EDUCATION |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
pub_date | integer | Date data published | 0% | 202001162020112320190207 |
projtype | text | Identifier derived from the Budget Line | 0% | PVPWP |
projtype_desc | text | Agency or Department Name | 0% | CULTURAL INSTITUTIONSPUBLIC BUILDINGSPARKS |
budline | text | Identifier of a Capital Unit of Appropriation | 0% | HW0001RWP0112PV0467 |
budline_desc |
GET /api/datasets/2cmn-uidm GET /api/datasets/2cmn-uidm/quality GET /api/datasets/2cmn-uidm/related GET /api/columns?dataset=2cmn-uidm
pub_date| E M4001 |
| CITY |
| 5 |
| 2016 |
| 40.00 |
| 150 |
| 0 |
| 0 |
| 0 |
| 20160426 | AG | DEPARTMENT FOR THE AGING | AGDN100 | CITY | 5 | 2016 | 503.00 | 0 | 0 | 0 | 0 |
| 20160426 | AG | DEPARTMENT FOR THE AGING | AGDN145 | CITY | 5 | 2016 | 0.00 | 0 | 510 | 0 | 0 |
| 20160426 | AG | DEPARTMENT FOR THE AGING | AGDN169 | CITY | 5 | 2016 | 0.00 | 118 | 0 | 0 | 0 |
| 20160426 | AG | DEPARTMENT FOR THE AGING | AGDN184 | CITY | 5 | 2016 | 1658.00 | 0 | 1149 | 0 | 0 |
| 20160426 | AG | DEPARTMENT FOR THE AGING | AGDN216 | CITY | 5 | 2016 | 119.00 | 331 | 0 | 0 | 0 |
| 20160426 | AG | DEPARTMENT FOR THE AGING | AGDN235 | CITY | 5 | 2016 | 236.00 | 0 | 0 | 3596 | 0 |
| 20160426 | AG | DEPARTMENT FOR THE AGING | AGDN262 | CITY | 5 | 2016 | 282.00 | 164 | 2907 | 257 | 0 |
| 20160426 | AG | DEPARTMENT FOR THE AGING | AGDN334 | CITY | 5 | 2016 | 50.00 | 0 | 0 | 0 | 0 |
Showing 12 of 13 columns. All of them are listed below.
| text |
| Legal description of what can be charged to a particular Budget Line. |
| 0% |
CONSTRUCTION OR ACQUISIT…CONSTRUCTION, IMPROVEMEN…CONSTRUCTION AND IMPROVE… |
funding | categorical | City or Non City | 0% | CITYNON CITYof 2 |
num_yrs_prsnt | categorical | Specify number of years presented for a specific published date | 0% | 54of 2 |
yr1_fy | categorical | Defines Fiscal Year of Year1 | 0% | 202020192018of 12 |
year1_amt | integer | Yr1_FY | 0% | 0.00500.00250.00 |
year2_amt | integer | Year1 + 1 | 0% | 05001000 |
year3_amt | integer | Year1 + 2 | 0% | 05001000 |
year4_amt | integer | Year1 + 3 | 0% | 05001000 |
year5_amt | integer | Year1 + 4 | 36% | 01000500 |