Dataset powers the City's Open Budget presentation. Excludes the Richmond Community Redevelopment Agency (RCRA) fund groups (fund 6101, 6102, 6103, 6104, 6105, 6106, 6201, 6202, 6203, 6204, 6205, 6206, 6207, 6208, 6300, 6301, 6302, 6303, 6304, 6305, 6306, 6307, 6308, 6309, 6401, 6402, 6403)
This dataset has the following 42 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
accountdescription | accountdescription | text | P-ROLL BEN/Medicare Tax-ER Shr P-ROLL BEN/Unemployment Ins P-ROLL BEN/Employee Assistance P-ROLL BEN/Vision P-ROLL BEN/OPEB view top 100 |
accountid | accountid | number | 24034 24065 5450 44570 8671 view top 100 |
accountstatus | accountstatus | text | Active Inactive Closed view top 100 |
accounttype | accounttype | text | Expense view top 100 |
actual | actual | number | 0.00 200.00 750.00 38.00 76.00 view top 100 |
charactercode | charactercode | text | 41 40 42 43 47 view top 100 |
charactercodedescription | charactercodedescription | text | PYRLL/FRINGE BENEFIT SALARIES AND WAGES PROF & ADMIN OTHER OPERATING COST POOL view top 100 |
department | department | text | view top 100 |
departmentgroup | departmentgroup | text | view top 100 |
entity | entity | text | City view top 100 |
fiscalmonth | fiscalmonth | calendar_date | 2021-07-01T00:00:00.000 2019-07-01T00:00:00.000 2022-07-01T00:00:00.000 2023-07-01T00:00:00.000 2020-07-01T00:00:00.000 view top 100 |
fiscalyear | fiscalyear | number | 2020 2022 2023 2021 2024 view top 100 |
fullaccount | fullaccount | text | 4003.22.222.114.000.000.0000.431.400122. 1050.16.162.000.000.000.0000.419.400002. 5001.18.182.083.000.000.0000.416.400149. 0001.18.181.000.000.000.0000.416.400103. 0001.26.261.000.000.000.0000.417.400002. view top 100 |
functiondescription | functiondescription | text | view top 100 |
functiongroup | functiongroup | text | view top 100 |
fund | fund | text | GENERAL FUND EMPLOYMENT & TRAINING CR-PLANNING & BUILDING WASTEWATER INSURANCE RESERVES view top 100 |
fundcode | fundcode | text | 0001 1205 1050 4003 5001 view top 100 |
fundgroup | fundgroup | text | view top 100 |
object | object | text | P-ROLL BEN/Medicare Tax-ER Shr P-ROLL BEN/Unemployment Ins P-ROLL BEN/Employee Assistance P-ROLL BEN/Vision P-ROLL BEN/OPEB view top 100 |
objectcode | objectcode | text | 400103 400116 400109 400111 400127 view top 100 |
organization | organization | text | GF-POLICE ADMIN DIV GF-PRKS&LNDSKP ADM (S-DIV) CR-PL&BD/CUR PLNING (S-DIV) GF-LIB&CL SVC/L-ADM DIV RHA-NEVIN PLAZA ADMN DIV view top 100 |
organizationcode | organizationcode | text | 01191021 01233631 15061219 01241055 44444191 view top 100 |
originalbudget | originalbudget | number | 0.00 1000.00 500.00 750.00 2000.00 view top 100 |
project | project | text | UNKNOWN E&T OPERATING COST POOL ACHIEVE SUMMER CAMP WIA DISLOCATED WORKER WIA ADULT view top 100 |
projectcode | projectcode | text | 42999 40F01 22902 22901 22923 view top 100 |
revisedbudget | revisedbudget | number | 0.00 1000.00 500.00 5000.00 1500.00 view top 100 |
segment2 | segment2 | text | PUBLIC WORK & ENGINEERING SVCS COMMUNITY SERVICES POLICE FINANCE FIRE view top 100 |
segment2code | segment2code | text | 23 25 19 17 20 view top 100 |
segment3 | segment3 | text | INFR&MAINT/FACILITIES MAINT E&T/RESOURCE MANAGEMENT RECREATION SVCS/C&N-HOOD CTRS INFR&MAINT/PRKS & LNDSKPING UTILITIES/WASTEWATER view top 100 |
segment3code | segment3code | text | 232 271 253 233 222 view top 100 |
segment4 | segment4 | text | SUB-DIVISION RHA-ADMINISTRATION ADMIN SVCS/ADMIN FACILITIES MAINTENANCE ADMIN PKS & LNDSKPING ADMIN view top 100 |
segment4code | segment4code | text | 000 121 071 031 036 view top 100 |
segment5 | segment5 | text | N/A view top 100 |
segment5code | segment5code | text | 000 view top 100 |
segment6 | segment6 | text | N/A view top 100 |
segment6code | segment6code | text | 000 view top 100 |
segment7 | segment7 | text | FUNDING SOURCE EMPLOYMENT & TRAIN SALARY POOL ADMINISTRATION OTHER SERVICES ET RICHMONDWORKS LOCAL PROGRAM view top 100 |
segment7code | segment7code | text | 0000 1295 1232 1226 1264 view top 100 |
segment8 | segment8 | text | PUBLIC WORKS RECREATION POLICE ACTIVITIES FINANCE FIRE ACTIVITIES view top 100 |
segment8code | segment8code | text | 431 451 421 415 422 view top 100 |
uniqueid | uniqueid | text | 2022-5-9620 2022-12-50240 2024-8-56419 2024-6-11161 2020-10-8641 view top 100 |
balance_remaining | balance_remaining | number | 0.00 -200.00 -750.00 -38.00 -100.00 view top 100 |