This dataset has the following 30 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| Fiscal Year | fiscal_year | number | 2013 2014 2015 2023 2019 view top 100 |
| Fiscal Year Period | fiscal_year_period | number | 12 4 9 10 7 view top 100 |
| Payment Date | payment_date | calendar_date | 2023-11-29T00:00:00.000 2020-01-29T00:00:00.000 2015-04-29T00:00:00.000 2016-09-28T00:00:00.000 2022-06-29T00:00:00.000 view top 100 |
| Service | service | text | Operating Departments General Government Public Safety Citywide Unknown view top 100 |
| Department | department | text | Public Works Finance Police Transportation Non-Departmental view top 100 |
| Program | program | text | Operating Bureaus Central Stores Non-Departmental Balance Sheet Rental Assistance view top 100 |
| Expense Category | expense_category | text | Retiree Medical P Office Supp&Exp Other O&M Contract Services Central Stores view top 100 |
| Fund | fund | text | General Fund Central Stores Fund Municipal Bus Lines Fund Section 8 Fund Equipment Maintenance Fund view top 100 |
| Fund Type | fund_type | text | Tax Supported Funds Non-Tax Supported Funds view top 100 |
| Vendor | vendor | text | ***Redacted*** Golden State Water Company Southern California Edison CalPERS Refund view top 100 |
| Vendor ID | vendor_id | text | 101418 100331 100000 100258 100994 view top 100 |
| Vendor ZIP | vendor_zip | text | 90232 90230 91772-0001 95809-1982 90045 view top 100 |
| Payment ID | payment_id | text | 48593 43917 28411 49800 34027 view top 100 |
| Payment Method | payment_method | text | Not Defined view top 100 |
| Payment Status | payment_status | text | Not Defined view top 100 |
| Invoice ID | invoice_id | text | 23-Feb 23-Jan 24-Feb 22-Aug 14-Jan view top 100 |
| Invoice Line | invoice_line | number | 1 2 3 4 5 view top 100 |
| Invoice Distribution Line | invoice_distribution_line | number | 1 view top 100 |
| Invoice Date | invoice_date | calendar_date | 2014-01-01T00:00:00.000 2016-08-01T00:00:00.000 2013-10-01T00:00:00.000 2019-07-01T00:00:00.000 2015-07-01T00:00:00.000 view top 100 |
| Amount | amount | number | 50 60 500 300 232.94 view top 100 |
| Description | description | text | ***Redacted*** Parts Supplies Uniforms NEW FLYER PART AND SUPPLIES view top 100 |
| Contract Number | contract_num | text | 31900307M 31300028 31300048 31400141 31300008 view top 100 |
| PO Number | po_num | text | 22200156 22400027 22300020 21600187 21900092 view top 100 |
| Fund Code | fund_code | text | 101 310 203 426 308 view top 100 |
| Org Code | org_code | text | 10140200 31014600 10116100 42650510 101 view top 100 |
| Org Description | org_description | text | Operating Bureaus Central Stores Non-Departmental Rental Assistance General Fund view top 100 |
| Object Code | object_code | text | 435500 600900 619800 513000 618520 view top 100 |
| Object Description | object_description | text | Retiree Insurance Central Stores Other Contractual Services Utilities Rent Sub HAP Pmts-Voucher/POut view top 100 |
| Project Code | project_code | text | PZ497 PZ502 PZ612 CV019 PZ132 view top 100 |
| Project Name | project_name | text | Stormwater Discharge Program/NPDES Art Fund Administration Upgrade Park Irrigation Systems Coronavirus COVID-19 Building Repairs view top 100 |