This dataset has the following 47 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
AccountStatus | accountstatus | text | Active Inactive view top 100 |
AccountType | accounttype | text | Expense Balance Sheet view top 100 |
Actual | actual | number | 15.00 300.00 71.74 100.00 77.47 view top 100 |
CharacterCode | charactercode | text | 40 30 60 20 80 view top 100 |
CharacterCodeDescription | charactercodedescription | text | OTHER CHARGES & SERVICES OFFICE/OPERATING SUPPLIES UNKNOWN CAPITAL OUTLAY BENEFITS view top 100 |
Date | date | calendar_date | 2020-01-29T00:00:00.000 2020-12-31T00:00:00.000 2021-07-21T00:00:00.000 2022-07-20T00:00:00.000 2022-10-12T00:00:00.000 view top 100 |
Department | department | text | view top 100 |
DepartmentGroup | departmentgroup | text | view top 100 |
Description | description | text | UB REFUND OFFICE SUPPLIES UTILITY TAX REBATE LAB ANALYSIS TEXT MESSAGE ARCHIVING view top 100 |
Employee | employee | checkbox | false view top 100 |
Entity | entity | text | City view top 100 |
EntryType | entrytype | text | D C view top 100 |
FiscalPeriod | fiscalperiod | number | 12 3 8 2 6 view top 100 |
FiscalYear | fiscalyear | number | 2022 2020 2021 view top 100 |
FullAccount | fullaccount | text | 501 -00-00-000-000-00-141100- 501 -54-18-000-548-65-534000- 401 -00-00-000-000-00-122110- 401 -00-00-000-000-00-122130- 401 -53-20-407-534-80-541000- view top 100 |
FunctionDescription | functiondescription | text | view top 100 |
FunctionGroup | functiongroup | text | view top 100 |
Fund | fund | text | GENERAL FUND WATER/SEWER OPERATING FUND FLEET SERVICES FACILITY MAINTENANCE GOLF COURSE OPERATING view top 100 |
FundCode | fundcode | text | 001 401 501 502 420 view top 100 |
FundGroup | fundgroup | text | view top 100 |
InvoiceId | invoiceid | text | 178837 182804 184468 181829 182790 view top 100 |
InvoiceStatus | invoicestatus | text | Paid Void view top 100 |
Object | object | text | OFFICE & OPERATING SUPPLIES PUBLIC UTILITY SERVICE PROFESSIONAL SERVICES COMMUNICATION MISCELLANEOUS view top 100 |
ObjectCode | objectcode | text | 531000 547000 541000 542000 549000 view top 100 |
Organization | organization | text | POLICE PATROL WATER/SEWER OPERATION EQUIPMENT RENTAL PARK & RECREATION FAC UTIL ADMIN view top 100 |
OrganizationCode | organizationcode | text | 00103222 401 50100065 40143410 40142480 view top 100 |
PaymentCheckNumber | paymentchecknumber | text | 0 146458 150407 137916 147559 view top 100 |
Project | project | text | UNKNOWN ANNEXATION EXPENSES STATE - COVID ASSISTANCE CIVIC CENTER PROJECT PATROL VEHICLES (2) view top 100 |
ProjectCode | projectcode | text | A1601 G0267 1837 2001 RPLC view top 100 |
Segment2 | segment2 | text | UTILITIES & ENVIRONMENT GENERAL GOVERNMENT SERVICES TRANSPORTATION SECURITY OF PERSONS AND PROP CULTURE AND RECREATION view top 100 |
Segment2Code | segment2code | text | 53 51 54 52 57 view top 100 |
Segment3 | segment3 | text | POLICE GENERAL STREETS WATER SERVICES PARKS view top 100 |
Segment3Code | segment3code | text | 08 00 16 20 10 view top 100 |
Segment4 | segment4 | text | GENERAL POLICE PATROL PARK & RECREATION FAC UTIL ADMIN WASTE WATER TREATMENT PLNT view top 100 |
Segment4Code | segment4code | text | 000 032 053 434 424 view top 100 |
Segment5 | segment5 | text | LAW ENFORCEMENT GENERAL WATER UTILITIES CENTRAL SERVICES ROAD AND STREET MAINTENANCE view top 100 |
Segment5Code | segment5code | text | 521 000 534 518 542 view top 100 |
Segment6 | segment6 | text | UTILITIES MISCELLANEOUS GENERAL ADMINISTRATION-GENL ADMINISTRATION view top 100 |
Segment6Code | segment6code | text | 80 00 30 10 20 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 | 115327-2042053-1803-24145-26248-268771 110221-1947946-4279-22622-24663-258361 113180-2000217-3978-16736-16736-264803 111231-1966148-2304-133-133-260830 114651-2028181-4035-25497-27673-267367 view top 100 |
VendorId | vendorid | text | 148 25570 24535 160 5018 view top 100 |
VendorName | vendorname | text | PUD NO 1 OF SNOHOMISH COUNTY NORTHWEST FIBER, LLC AMAZON CAPITAL SERVICES, INC. VERIZON WIRELESS BANK OF AMERICA view top 100 |
VendorType | vendortype | text | NORMAL PAYROLL TEMPORARY EMPLOYEE view top 100 |