Fetching weather...

Data Dictionary Repository

Welcome to the data dictionary reference guide. Below you will find the field mapping, structural data types, and sample entries for our integrated datasets.

What kind of information is in these datasets?

These dictionaries map the structure of our core financial and operational tracking systems. Depending on the dataset, you can expect to find fields related to:

Updating Sources: As new CSVs are ingested into our tracking environment, their schema structures will be appended to this directory to maintain consistency across all data dashboards.

Budgeted_Revenues_less_RCRA_Fund_Group

Data dictionary mapping the fields, types, and sample values for the Budgeted Revenues dataset (excluding RCRA).

Column Name Data Type Non-Null Count Unique Count Sample Values
accountdescription object 13,575 225 ['INT & INVEST/Fiscal Agent', 'INT & INVEST/Interest On Loans', 'INT & INVEST/Interest-Investmt']
accountid int64 13,575 1,096 [27583, 27584, 28011]
accountstatus object 13,575 3 ['Active', 'Closed', 'Inactive']
accounttype object 13,575 1 ['Revenue']
actual float64 13,575 9,439 [9.5, 19.0, 100.0]
charactercode object 13,575 19 ['36', '34', '61']
charactercodedescription object 13,575 19 ['USE OF MONEY&PROPRTY', 'LICENSES,PRMITS&FEES', 'LOAN/BOND PROCEEDS']
department float64 0 0 []
departmentgroup float64 0 0 []
entity object 13,575 1 ['City']
fiscalmonth object 13,575 49 ['08/01/2022 12:00:00 AM', '12/01/2022 12:00:00 AM', '04/01/2023 12:00:00 AM']
fiscalyear int64 13,575 5 [2023, 2024, 2026]
fullaccount object 13,575 1,096 ['2001.23.236.000...361702.0NC01', '2001.23.236.000...361702.0ND01']
functiondescription float64 0 0 []
functiongroup float64 0 0 []
fund object 13,575 92 ['GENERAL CAPITAL FUND', 'CAL-HOME GRANT FUND', 'RHA-CENTRAL OFFICE COST CNTR']
fundcode int64 13,575 92 [2001, 1209, 4501]
fundgroup float64 0 0 []
object object 13,575 220 ['INT & INVEST/Fiscal Agent', 'INT & INVEST/Interest On Loans', 'INT & INVEST/Interest-Investmt']
objectcode int64 13,575 220 [361702, 361707, 361711]
organization object 13,575 223 ['CAP OUTLAY-PW/CIP DIV', 'CAL-HOME', 'RHA-CENTRAL OFFICE ADMN DIV']
organizationcode int64 13,575 223 [20136031, 12931063, 45141191]
originalbudget float64 13,575 744 [0.0, 33686675.0, 4000000.0]
project object 13,575 322 ['COSCO BUSAN/PT MOLATE BEACH', 'COSCO BUSAN/MARINA BAY TRAIL', 'UNKNOWN']
projectcode object 2,130 329 ['0NC01', '0ND01', 'EOP01']
revisedbudget float64 13,575 1,192 [0.0, 65020.82, 1290.0]
segment2 object 13,575 29 ['PUBLIC WORK & ENGINEERING SVCS', 'HOUSING DEPARTMENT-COR', 'RICHMOND HSING AUTHORITY(RHA)']
segment2code int64 13,575 29 [23, 33, 34]
segment3 object 13,575 81 ['INFR&MAINT/CIP', 'HD/HOUSING DIVISION(COR)', 'RHA-CENTRAL OFFICE']
segment3code int64 13,575 81 [236, 331, 451]
segment4 object 13,575 65 ['SUB-DIVISION', 'RHA-ADMINISTRATION', 'BUILDING REGULATIONS']
segment4code int64 13,575 65 [0, 121, 66]
segment5 float64 0 0 []
segment5code int64 13,575 1 [0]
segment6 float64 0 0 []
segment6code int64 13,575 1 [0]
segment7 object 13,575 22 ['FUNDING SOURCE', 'WIA SYEP IN SCHOOL', 'SUMMER YOUTH DONATED FUNDS']
segment7code int64 13,575 22 [0, 1211, 1289]
segment8 object 13,575 23 ['PUBLIC WORKS', 'HOUSING', 'RICHMOND HOUSING AUTHORITY']
segment8code int64 13,575 23 [431, 463, 991]
uniqueid object 13,575 13,575 ['2023-2-27583', '2023-2-27584', '2023-2-28011']
budgettrfsadjs float64 13,575 514 [0.0, 65020.82, 1290.0]
availablebudget float64 13,575 10,305 [-9.5, -19.0, -100.0]
percentreceived float64 2,020 598 [1.104277, 34.149511, 0.082035]
object_prefix object 13,575 30 ['INT & INVEST', 'FEES', 'PERMITS']
object_suffix object 13,575 219 ['FISCAL AGENT', 'INTEREST ON LOANS', 'INTEREST-INVESTMT']

Budgeted_Expenses_less_RCRA_Group

Data dictionary mapping the fields, types, and sample values for the Budgeted Expenses dataset (Group 2, excluding RCRA).

Column Name Data Type Non-Null Count Unique Count Sample Values
accountdescription object 50,285 339 ['P-ROLL BEN/Unemployment Ins', 'P-ROLL BEN/PERS-Misc', 'P-ROLL BEN/PERS-Misc (UAL)']
accountid int64 50,285 6,069 [10226, 43393, 43395]
accountstatus object 50,285 3 ['Active', 'Closed', 'Inactive']
accounttype object 50,285 1 ['Expense']
actual float64 50,285 24,637 [148.2, 8473.61, 7118.9]
charactercode object 50,285 25 ['41', '40', '42']
charactercodedescription object 50,285 15 ['PYRLL/FRINGE BENEFIT', 'SALARIES AND WAGES', 'PROF & ADMIN']
department float64 0 0 []
departmentgroup float64 0 0 []
entity object 50,285 1 ['City']
fiscalmonth object 50,285 52 ['7/1/2025 0:00', '8/1/2025 0:00', '9/1/2025 0:00']
fiscalyear int64 50,285 6 [2026, 2025, 2022]
fullaccount object 50,285 6,069 ['0001.13.131.000...400116.', '0001.13.131.000...400149.']
functiondescription float64 0 0 []
functiongroup float64 0 0 []
fund object 50,285 88 ['GENERAL FUND', 'KIDS FIRST INITIATIVE', 'INSURANCE RESERVES']
fundcode int64 50,285 88 [1, 1303, 5001]
fundgroup float64 0 0 []
object object 50,285 319 ['P-ROLL BEN/Unemployment Ins', 'P-ROLL BEN/PERS-Misc']
objectcode int64 50,285 319 [400116, 400149, 400151]
organization object 50,285 343 ['GF-CITY MNGR ADMIN DIV', 'INTERNAL SERVICES-DPT YOUTH SV']
organizationcode int64 50,285 349 [1131013, 13371018, 1242155]
originalbudget float64 50,285 3,579 [2280.0, 121170.0, 109520.0]
project object 50,285 490 ['UNKNOWN', 'SUPPORT FOR WCCUSD LABOR NEGOTIATIO']
projectcode object 5,318 493 ['25005', '23011', '23021']
revisedbudget float64 50,285 4,807 [2280.0, 121170.0, 109520.0]
segment2 object 50,285 32 ['CITY MANAGER', 'INTERNAL SERVICES PROGRAM']
segment2code int64 50,285 32 [13, 37, 24]
segment3 object 50,285 98 ['CITY MANGER/ADMINISTRATION', 'INTERNAL SERVCS/ADMINISTRATION']
segment3code int64 50,285 98 [131, 371, 242]
segment4 object 50,285 87 ['SUB-DIVISION', 'REFERENCE SVCS', 'CASH MANAGEMENT']
segment4code int64 50,285 87 [0, 51, 77]
segment5 float64 0 0 []
segment5code int64 50,285 1 [0]
segment6 float64 0 0 []
segment6code int64 50,285 1 [0]
segment7 object 50,285 68 ['FUNDING SOURCE', 'EMPLOYMENT & TRAIN SALARY POOL']
segment7code int64 50,285 68 [0, 1295, 1293]
segment8 object 50,285 24 ['EXECUTIVE', 'INTERNAL SERVICES', 'LIBRARY']
segment8code int64 50,285 24 [413, 418, 455]
uniqueid object 50,285 50,285 ['2026-1-10226', '2026-1-43393', '2026-1-43395']
balance_remaining float64 50,285 28,298 [2131.8, 112696.39, 102401.1]

vendor

Data dictionary mapping the fields, types, and sample values for the external Vendor and Entity dataset.

Column Name Data Type Non-Null Count Unique Count Sample Values
City object 12,422 996 ['HAYWARD', 'SANTA ROSA', 'EL SEGUNDO']
Country float64 0 0 []
IsWomenOrMinorityBusinessEnterprise bool 12,433 1 ['False']
Phone float64 0 0 []
State object 12,418 54 ['CA', 'MO', 'TX']
VendorId int64 12,433 12,433 ['1', '10000', '10001']
VendorName object 12,433 11,697 ['AA OFFICE EQUIPMENT CO INC', 'JOHN HICKS', 'WALLACE LABORATORIES LLC']
WebAddress object 1,592 1,580 ['WLABS.COM', 'DOUGLASHOLLIS.COM', 'LOSCENZONTLES.COM']
Zip object 12,421 2,226 ['94545', '95402', '90245']
VendorType object 12,429 17 ['STANDARD VENDOR', 'REFUND', 'DISABILITY PAYMENT']
Employee bool 12,433 2 ['False', 'True']

Payroll

Data dictionary mapping the fields, types, and sample values for the Payroll and Employee Compensation dataset.

Column Name Data Type Non-Null Count Unique Count Sample Values
AccountDescription object 11,697 64 ['P-ROLL BEN/Medicare Tax-ER Shr', 'OTHER PAY/Vacation Lve Payout', 'P-ROLL BEN/Worker Comp-Clerica']
AccountStatus object 11,697 1 ['Active']
AccountType object 11,697 2 ['Expense', 'UNKNOWN']
BasePay float64 11,697 691 ['0.0', '1697.4', '282.9']
BenefitsAmount float64 11,697 2,968 ['317.05', '0.0', '149.88']
CharacterCode int64 11,697 5 ['41', '40', '42']
CharacterCodeDescription object 11,697 5 ['PYRLL/FRINGE BENEFIT', 'SALARIES AND WAGES', 'PROF & ADMIN']
CheckNumber int64 11,697 1,860 ['101002038', '101002040', '101002041']
Department object 11,697 25 ['PUBLIC WORKS DEPARTMENT', 'FINANCE', 'POLICE']
DepartmentGroup float64 0 0 []
EmployeeId int64 11,697 717 ['4380', '4579', '4633']
Entity object 11,697 1 ['City']
FirstName object 11,697 498 ['JOSEPH', 'CLAUDIA', 'RAJANNA']
FiscalPeriod int64 11,697 12 ['3', '2', '10']
FiscalYear int64 11,697 4 ['2023', '2025', '2026']
FullAccount object 11,697 931 ['5008.91.907...400103.', '0001.17.177...400121.']
FunctionDescription float64 0 0 []
FunctionGroup float64 0 0 []
Fund object 11,697 22 ['COMPENSATED ABSENCES', 'GENERAL FUND', 'WASTEWATER']
FundCode int64 11,697 22 ['5008', '1', '4003']
FundGroup float64 0 0 []
LastName object 11,697 586 ['LEACH', 'HERRERA-OCHOA', 'SUMLER']
NameSuffix object 403 6 ['II', 'JR', 'JR.']
Object object 11,697 60 ['P-ROLL BEN/Medicare Tax-ER Shr', 'OTHER PAY/Vacation Lve Payout']
ObjectCode int64 11,697 60 ['400103', '400054', '400121']
Organization object 11,697 91 ['COMPENSATED ABSENCES', 'FIN/REV COLLECTION DIV']
OrganizationCode int64 11,697 91 ['50817090', '1177015', '1253751']
OtherPay float64 11,697 967 ['0.0', '21865.6', '485.71']
OvertimePay float64 11,697 469 ['0.0', '25.06', '1804.34']
Position object 11,697 216 ['DIRECTOR OF PUBLIC WORKS', 'OFFICE CLERK-CASHIER G/III']
PositionType object 11,697 11 ['FULL TIME PERMANENT', 'PART-TIME GROUP III', 'F.T.S. PROBATIONARY']
Project object 11,697 1 ['UNKNOWN']
ProjectCode float64 0 0 []
Segment2 object 11,697 27 ['NON-DEPARTMENTAL', 'FINANCE', 'COMMUNITY SERVICES']
Segment2Code int64 11,697 27 ['91', '17', '25']
Segment3 object 11,697 65 ['NON-DEPARTMENTAL/NON-DEPT', 'FINANCE/REVENUE COLLECTION']
Segment3Code int64 11,697 65 ['907', '177', '253']
Segment4 object 11,697 38 ['SUB-DIVISION', 'RECREATION COMPLEX', 'FACILITIES MAINTENANCE ADMIN']
Segment4Code int64 11,697 38 ['0', '27', '31']
Segment5 float64 0 0 []
Segment5Code int64 11,697 1 ['0']
Segment6 float64 0 0 []
Segment6Code int64 11,697 1 ['0']
Segment7 object 11,697 2 ['FUNDING SOURCE', 'EMPLOYMENT & TRAIN SALARY POOL']
Segment7Code int64 11,697 2 ['0', '1295']
Segment8 object 11,697 22 ['NON-DEPARTMENTAL', 'FINANCE', 'RECREATION']
Segment8Code int64 11,697 22 ['990', '415', '451']
ServiceEndDate object 2,700 31 ['10/1/2022 0:00', '9/3/2022 0:00', '9/30/2022 0:00']
ServiceStartDate object 11,697 479 ['4/12/2021 0:00', '4/11/2022 0:00', '6/27/2022 0:00']
TotalPay float64 11,697 4,890 ['317.05', '21865.6', '149.88']
TransactionDate object 11,697 108 ['9/30/2022 0:00', '9/2/2022 0:00', '9/16/2022 0:00']
UniqueId object 11,697 11,697 ['156004-99137-23-61616...101002038', '178905-115104-17-297...101002040']
Minor bool 11,697 2 ['False', 'True']