This dataset has the following 46 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
AccountDescription | accountdescription | text | INVESTMENT INTEREST OPERATING TRANSFER OTHER MISC REVENUE LOCAL SALES TAX COPY CHARGES view top 100 |
AccountId | accountid | number | 4327 4424 4426 4795 4425 view top 100 |
AccountStatus | accountstatus | text | Active view top 100 |
AccountType | accounttype | text | Revenue view top 100 |
Actual | actual | number | 0.00 5410.49 150.00 66741.70 1250.00 view top 100 |
CharacterCode | charactercode | text | 34 35 33 view top 100 |
CharacterCodeDescription | charactercodedescription | text | UNKNOWN CHARGES FOR SERVICES FINES & FORFEITS INTERGOVERNMENTAL view top 100 |
Department | department | text | view top 100 |
DepartmentGroup | departmentgroup | text | view top 100 |
Encumbrance | encumbrance | number | 0.00 view top 100 |
Entity | entity | text | City view top 100 |
FiscalMonth | fiscalmonth | calendar_date | 2020-04-01T00:00:00.000 2020-01-01T00:00:00.000 2021-01-01T00:00:00.000 2022-01-01T00:00:00.000 2021-12-01T00:00:00.000 view top 100 |
FiscalYear | fiscalyear | number | 2020 2021 2022 view top 100 |
FullAccount | fullaccount | text | 310 -34-10-000-345-00-358500- 402 -34-42-000-343-00-334014- 001 -34-07-000-345-00-358200- 401 -34-57-000-343-00-335021- 001 -34-07-000-345-00-358300- view top 100 |
FunctionDescription | functiondescription | text | view top 100 |
FunctionGroup | functiongroup | text | view top 100 |
Fund | fund | text | GENERAL FUND WATER/SEWER OPERATING FUND GOLF COURSE OPERATING WATER/SEWER CONSTRUCTION FUND FLEET SERVICES view top 100 |
FundCode | fundcode | text | 001 401 420 402 501 view top 100 |
FundGroup | fundgroup | text | view top 100 |
LTDOriginalBudget | ltdoriginalbudget | number | 0.00 view top 100 |
LTDRevisedBudget | ltdrevisedbudget | number | 0.00 view top 100 |
MultiYear | multiyear | checkbox | false view top 100 |
Object | object | text | INVESTMENT INTEREST CHARGES FOR SERVICES OPERATING TRANSFER OTHER MISC REVENUE OTHER NON-BUSINESS LICENSE view top 100 |
ObjectCode | objectcode | text | 311100 391900 370000 399000 329000 view top 100 |
ObligatedAmount | obligatedamount | number | 0.00 5410.49 150.00 66741.70 1250.00 view top 100 |
Organization | organization | text | INTEREST AND OTHER EARNINGS PARKS-RECREATION GENL FUND-I/FND SERVICES GENL FUND BUSINESS LICENSE WATER-UTILITIES/ENVIRONMNT view top 100 |
OrganizationCode | organizationcode | text | 00110347 00100349 00100316 40142343 00108342 view top 100 |
OriginalBudget | originalbudget | number | 0.00 5000.00 10000.00 1000.00 15000.00 view top 100 |
Project | project | text | OPERATIONS OPERA HOUSE REVENUE FINANCE - CITY CLERK FINANCE - ACCOUNT HR DEPARTMENT ALLOCATION view top 100 |
ProjectCode | projectcode | text | OPERA 04ACT 04UB 03HR 03EXE view top 100 |
RevisedBudget | revisedbudget | number | 0.00 5000.00 10000.00 50000.00 15000.00 view top 100 |
Segment2 | segment2 | text | CHARGES FOR GOODS/SERVICES MISCELLANEOUS REVENUES TAXES INTERGOVERNMENTAL REVENUE FINES AND FORFEITS view top 100 |
Segment2Code | segment2code | text | 34 36 31 33 35 view top 100 |
Segment3 | segment3 | text | GENERAL POLICE PARKS STREETS COURTS view top 100 |
Segment3Code | segment3code | text | 00 08 10 16 02 view top 100 |
Segment4 | segment4 | text | GENERAL COMPUTER SERVICES view top 100 |
Segment4Code | segment4code | text | 000 006 view top 100 |
Segment5 | segment5 | text | INTEREST AND OTHER EARNINGS UTILITIES & ENVIRONMENT CULTURE AND RECREATION GENL GVRNMNT SERVICES INTERNAL SERVICE FUND CHGS view top 100 |
Segment5Code | segment5code | text | 361 343 347 341 348 view top 100 |
Segment6 | segment6 | text | GENERAL ADMINISTRATION-GENL MISCELLANEOUS CENTRAL SERVICES view top 100 |
Segment6Code | segment6code | text | 00 10 30 18 view top 100 |
Segment7 | segment7 | text | UNKNOWN view top 100 |
Segment7Code | segment7code | text | -1 view top 100 |
Segment8 | segment8 | text | UNKNOWN view top 100 |
Segment8Code | segment8code | text | -1 view top 100 |
UniqueId | uniqueid | text | 2022-8-4840 2020-3-4594 2022-4-5255 2021-2-4810 2022-9-4481 view top 100 |