From a 303-row sample across 10 columns.
pub_dtagy_cdfisc_yr+2pub_dtagy_cdagy_nm+2pub_dtfisc_yrpub_dtagy_cd| pub_dt | fisc_yr | agy_cd | agy_nm | ps_otps_ind | cat_nm | adp_amt | curr_mod_amt | fp_amt | subcat_nm |
|---|---|---|---|---|---|---|---|---|---|
| 20200630 | 2021 | 098 | MISCELLANEOUS | P | Personal Services | 1800684851 | 1010604730 | 1704955379 | — |
| 20200630 | 2021 | 098 | MISCELLANEOUS | P | Fringe Benefits |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
pub_dt | categorical | 8-digit number for date of publication | 0% | 202206142022042620230630of 13 |
fisc_yr | categorical | 4-digit fiscal year associating to current budget phase | 0% | 202620232024of 6 |
agy_cd | text | 3-digit number for agency number | 0% | 098of 1 |
agy_nm | text | Agency name | 0% | MISCELLANEOUSof 1 |
ps_otps_ind |
GET /api/datasets/fdgu-y9iy GET /api/datasets/fdgu-y9iy/quality GET /api/datasets/fdgu-y9iy/related GET /api/columns?dataset=fdgu-y9iy
fisc_yrpub_dtfisc_yr| 349296474 |
| 349296474 |
| 378396474 |
| Workers' Compensation |
| 20200630 | 2021 | 098 | MISCELLANEOUS | P | Fringe Benefits | 4362494584 | 4326783234 | 1828823592 | Health Insurance Plans |
| 20200630 | 2021 | 098 | MISCELLANEOUS | P | Fringe Benefits | 1209180475 | 1211055974 | 1183059972 | Social Security Contributions |
| 20200630 | 2021 | 098 | MISCELLANEOUS | P | Fringe Benefits | 22053564 | 22053564 | 22953564 | Unemployment Insurance Benefits |
| 20200630 | 2021 | 098 | MISCELLANEOUS | P | Fringe Benefits | 705100357 | 711933003 | 689282040 | Supplementary Employee Welfare Benefits |
| 20200630 | 2021 | 098 | MISCELLANEOUS | P | Fringe Benefits | 42400000 | 42400000 | 44100000 | Workers' Compensation-Other |
| 20200630 | 2021 | 098 | MISCELLANEOUS | O | Other Than Personal Services | 233063253 | 234794267 | 247260890 | Contractural Services and Other Payments |
| 20200630 | 2021 | 098 | MISCELLANEOUS | O | Other Than Personal Services | 199062895 | 237489335 | 298470248 | Criminal Justice Contracts |
| 20200630 | 2021 | 098 | MISCELLANEOUS | O | Other Than Personal Services | 711889219 | 732521219 | 727089219 | Judgments & Claims |
| categorical |
| Personal Service (P) or Other Than Personal Service (O) |
| 0% |
OPof 2 |
cat_nm | categorical | Category names under Miscellaneous Budget | 0% | Other Than Personal Serv…Fringe BenefitsPersonal Servicesof 4 |
subcat_nm | text | Subcategory names under Miscellaneous Budget | 8% | HYIC TEPHealth Insurance PlansWorkers' Compensation-Ot… |
adp_amt | integer | Financial plan amount as of previous Adopted Budget for current fiscal year | 0% | 0250000000156181189 |
curr_mod_amt | integer | The Adopted Budget as revised through modification and approval in accordance with the City Charter for current fiscal year | 0% | 050000000156181189 |
fp_amt | integer | Estimated operating expenditures for the City for the following fiscal year | 0% | 025000000010500000 |