Data is uploaded every Friday morning after the weekly check run is completed. <b>Update Frequency:</b> Weekly <b>Data Disclaimer:</b> The City Of Corona (“Corona”) provides data available on this website as a service to the public. The data provided by Corona is based on historical data, information directly provided by Corona, information directly provided by Corona contractors and in some cases, information acquired during physical inspections. Corona does not guarantee the accuracy of this data and assumes no liability for any errors. The data shall be used for the sole purpose of providing the public with information regarding this program and not for any commercial, legal or other use. Corona assumes no liability for any decisions made or action taken or not taken by anyone using data provided from this website. Corona reserves the right to alter, amend or terminate at any time the display of this data.
This dataset has the following 17 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| fiscal_year | fiscal_year | text | 2023 2022 2021 2020 2024 view top 100 |
| fiscal_year_period | fiscal_year_period | text | 9 6 10 4 1 view top 100 |
| fund_name | fund_name | text | GENERAL FUND WATER FUND SEWER FUND FLEET OPERATIONS FUND SPECIAL TAXING DISTRICT FUND view top 100 |
| department_code | department_code | text | 50 47 16 41 32 view top 100 |
| department | department | text | UTILITIES DEPARTMENT COMMUNITY SERVICES GENL RESP-SHARED MAINTENANCE SERVICES POLICE view top 100 |
| department_activity | department_activity | text | GENERAL GOVERNMENT PARKS, TREES & MEDIANS MAINT WATER - OPERATIONS NA CITY FLEET MAINTENANCE view top 100 |
| vendor_id | vendor_id | text | 102286 125327 124052 120809 PC000001 view top 100 |
| vendor | vendor | text | SOUTHERN CALIFORNIA EDISON CO FASTENAL CO AT AND T AMAZON MKTPLACE PMTS CINTAS CORP 150 view top 100 |
| vendor_city | vendor_city | text | CORONA RIVERSIDE CHICAGO SEATTLE ROSEMEAD view top 100 |
| vendor_st | vendor_st | text | CA IL WA AZ MN view top 100 |
| vendor_zip | vendor_zip | text | 92882 98109 91772-0001 92878 55987-1286 view top 100 |
| payment_id | payment_id | text | 00225595 00219023 00221407 00220659 00216869 view top 100 |
| payment_date | payment_date | calendar_date | 2022-12-15T00:00:00.000 2015-07-31T00:00:00.000 2024-02-15T00:00:00.000 2023-06-15T00:00:00.000 2016-03-25T00:00:00.000 view top 100 |
| invoice_id | invoice_id | text | CF020123 CF030122 CF090122 CF060122 CF050124 view top 100 |
| expense_category | expense_category | text | MATERIALS AND SUPPLIES CONTRACTUAL SERVICES PERSONNEL SERVICES UTILITIES OTHER view top 100 |
| description | description | text | MONTHLY RETIREE HEALTH REIMB UTILITY BILL PROCESSING ZIPBOOKS GASOLINE WAGE ASSIGNMENTS view top 100 |
| amount | amount | number | 50 25 60 35 100 view top 100 |