Financial Data for the Checkbook Explorer. Data since Fiscal Year 2012.
This dataset has the following 62 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| ID NUMBER | id_number | number | Checkbook Transaction ID # | 2419319 5071221 2741968 5064399 6644621 view top 100 |
| FISCAL YEAR | fiscal_year | number | Fiscal Year | 2023 2013 2015 2012 2014 view top 100 |
| DEPARTMENT NAME | department_name | text | Department Name | WATER AND POWER view top 100 |
| VENDOR NAME | vendor_name | text | Vendor Name | ASSOCIATED READY MIXED CONCRETE, INC W. W. GRAINGER, INC. OFFICE DEPOT BUSINESS SERVICES DIVISION MISSION LINEN SUPPLY OFFICE DEPOT, INC., BUSINESS SOLUTIONS DIVISION view top 100 |
| TRANSACTION DATE | transaction_date | calendar_date | Transaction Date | 2015-12-23T00:00:00.000 2012-06-20T00:00:00.000 2016-06-29T00:00:00.000 2012-12-19T00:00:00.000 2017-06-28T00:00:00.000 view top 100 |
| DOLLAR AMOUNT | dollar_amount | number | Dollar Amount | 649.04 27.56 636.88 738.92 12.5 view top 100 |
| AUTHORITY | authority | text | BR164 9 00373 3 00845 7 00329 033 00121 023 view top 100 | |
| BUSINESS TAX REGISTRATION CERTIFICATE | btrc | text | Business Tax Registration Certificate | 9999999999 view top 100 |
| GOVERNMENT ACTIVITY | government_activity | text | Government Activity Category | TRANSPORTATION, COMMERCE AND ENTERPRISE FINANCIAL SERVICES view top 100 |
| FUND GROUP NAME | fund_group_name | text | Fund Group Name | PROPRIETARY view top 100 |
| FUND TYPE | fund_type | text | Fund Type | ENTERPRISE view top 100 |
| FUND NAME | fund_name | text | Fund Name | POWER REVENUE FUND WATER REVENUE FUND W & P ACTIVE EMPLOYEE HEALTHCARE BENEFITS FUND W & P EMPLOYEES' RETIREMENT DWP FLEXIBLE SPENDING ACCOUNTS (FSA) view top 100 |
| FUND | fund | text | Fund # | 704 705 922 809 776 view top 100 |
| ACCOUNT NAME | account_name | text | Account Name | POWER REVENUE FUND WATER REVENUE FUND W & P ACTIVE EMPLOYEE HEALTHCARE BENEFITS FUND W & P EMPLOYEES' RETIREMENT DWP FLEXIBLE SPENDING ACCOUNTS (FSA) view top 100 |
| ACCOUNT CODE | account_code | text | Account # Code | 51 1 01 36 33 view top 100 |
| TRANSACTION ID | transaction_id | text | Accounting System Transaction (FMS) ID | AD26220000011593 AD26210000015958 AD26230000010343 586497 589796 view top 100 |
| EXPENDITURE TYPE | expenditure_type | text | Expenditure Type | MATERIALS AND SUPPLIES OTHER OUTSIDE SERVICES RENTALS AND LEASES PROFESSIONAL SERVICES OTHER DIRECTS AND REBATES view top 100 |
| SETTLEMENT/JUDGMENT | settlement_judgment | text | Relates to Settlement/Judgment | view top 100 |
| FISCAL MONTH NUMBER | fiscal_month_number | number | Fiscal Month # | 12 2 3 9 11 view top 100 |
| FISCAL YEAR-MONTH | fiscal_year_month | text | Fiscal Year & Month | 2017-12(JUN) 2014-11(MAY) 2014-12(JUN) 2013-12(JUN) 2023-9(MAR) view top 100 |
| FISCAL YEAR-QUARTER | fiscal_year_quarter | text | Fiscal Year Quarter | 2014-04 2013-02 2023-04 2024-01 2012-02 view top 100 |
| CALENDAR MONTH NUMBER | calendar_month_number | number | Calendar Month # | 6 8 9 3 5 view top 100 |
| CALENDAR MONTH/YEAR | calendar_month_year | text | Calendar Month & Year | JUNE,2017 MAY,2014 JUNE,2014 JUNE,2013 MARCH,2023 view top 100 |
| CALENDAR MONTH | calendar_month | text | Calendar Month | JUNE AUGUST SEPTEMBER MARCH MAY view top 100 |
| DATA SOURCE | data_source | text | Data Sourced From | LADWP FMS view top 100 |
| AUTHORITY NAME | authority_name | text | Authory Name | ASSOCIATED READY MIXED CONCRETE, INC W. W. GRAINGER, INC. OFFICE DEPOT BUSINESS SERVICES DIVISION MISSION LINEN SUPPLY OFFICE DEPOT, INC., BUSINESS SOLUTIONS DIVISION view top 100 |
| AUTHORITY LINK | authority_link | url | Authority Link (if applicable) | view top 100 |
| DEPARTMENT NUMBER | department_number | text | Department # | 98 view top 100 |
| PROGRAM | program | text | Expense based on Program Activity | POWER REVENUE FUND WATER REVENUE FUND W & P ACTIVE EMPLOYEE HEALTHCARE BENEFITS FUND W & P EMPLOYEES' RETIREMENT DWP FLEXIBLE SPENDING ACCOUNTS (FSA) view top 100 |
| VENDOR ID | vendor_id | text | Vendor ID | 17371023 4422155 9413065 009413065 2085046 view top 100 |
| ZIP | zip | text | Vendor Zip Code | 92660 91505 90013 93514 90670 view top 100 |
| PAYMENT METHOD | payment_method | text | How payment was made | CHECK ADJUSTMENT view top 100 |
| PAYMENT STATUS | payment_status | text | Status of payment | PAID view top 100 |
| INV NUM | inv_num | text | Invoice # | DEX39BRIP22000003 RFP071111 ATTAZ 922GTE PACBELSAC view top 100 |
| INVOICE DUE DATE | invoice_due_date | calendar_date | Invoice due date | 2012-01-19T00:00:00.000 2012-10-02T00:00:00.000 2015-10-07T00:00:00.000 2012-05-11T00:00:00.000 2014-06-07T00:00:00.000 view top 100 |
| INVOICE DISCOUNT DUE DATE | invoice_discount_due_date | calendar_date | Invoice discount due date | 2012-01-19T00:00:00.000 2012-10-02T00:00:00.000 2015-10-07T00:00:00.000 2012-05-11T00:00:00.000 2014-06-07T00:00:00.000 view top 100 |
| INV DATE | inv_date | calendar_date | Invoice Receipt Date | 2012-01-18T00:00:00.000 2014-03-04T00:00:00.000 2012-05-10T00:00:00.000 2014-06-06T00:00:00.000 2015-01-07T00:00:00.000 view top 100 |
| INV LINE | inv_line | number | Vendor's Invoice Line Number | 1 2 3 4 5 view top 100 |
| INVOICE DISTRIBUTION LINE | inv_dist_line | number | System line associated with Vendor's Invoice Line Number | 1 2 3 4 5 view top 100 |
| PO NUM | po_num | text | Purchase Order Number | 95344 99999 61141 79642 72978 view top 100 |
| DESCRIPTION | description | text | Description of purchased item | MATERIALS AND SUPPLIES OTHER OUTSIDE SERVICES RENTALS AND LEASES PROFESSIONAL SERVICES OTHER DIRECTS AND REBATES view top 100 |
| DETAILED ITEM DESCRIPTION | detailed_item_description | text | Detailed description of purchase | MATERIALS AND SUPPLIES OTHER OUTSIDE SERVICES RENTALS AND LEASES PROFESSIONAL SERVICES OTHER DIRECTS AND REBATES view top 100 |
| UNIT PRICE | unit_price | number | Unit Price of purchased item | view top 100 |
| UNIT OF MEASURE | unit_of_measure | text | view top 100 | |
| QUANTITY | quantity | number | Number of items purchased | view top 100 |
| SALES TAX PERCENT | sales_tax_percent | number | Sales Tax % | view top 100 |
| SALES TAX | sales_tax | number | Sales Tax Amount | view top 100 |
| DISCOUNT | discount | number | Discount on purchased item | 0 34.16 33.52 15.08 28 view top 100 |
| RECEIVER ID | receiver_id | text | view top 100 | |
| PO DATE | po_date | calendar_date | Purchase Order Date | view top 100 |
| PO LINE NUMBER | po_line_number | number | Purchase Order Line Number | 0 view top 100 |
| PROCUREMENT ORGANIZATION | procurement_organization | text | LADWP view top 100 | |
| BUYER NAME | buyer_name | text | City Buyer ID | view top 100 |
| SUPPLIER CITY | supplier_city | text | Vendor City | LOS ANGELES NEWPORT BEACH BURBANK BISHOP NORTH HOLLYWOOD view top 100 |
| SUPPLIER COUNTRY | supplier_country | text | Vendor Country | USA view top 100 |
| BU NAME | bu_name | text | City Business Unit Name | CITY view top 100 |
| SITE LOCATION | site_location | text | Purchased Item Site Location | LOS ANGELES view top 100 |
| ITEM CODE | item_code | text | Purchased Item Code | view top 100 |
| ITEM CODE NAME | item_code_name | text | Purchased Item Code Name | view top 100 |
| CURRENCY | currency | text | Type of currency used in transaction | USD view top 100 |
| VALUE OF SPEND | value_of_spend | number | Calculation of Unit Price * Quanity | view top 100 |
| VENDOR NUM | vendor_num | text | Vendor ID + Vendor Name | 017371023 - ASSOCIATED READY MIXED CONCRETE, INC 004422155 - W. W. GRAINGER, INC. 009413065 - OFFICE DEPOT BUSINESS SERVICES DIVISION 000938130 - MISSION LINEN SUPPLY 009413065 - OFFICE DEPOT, INC., BUSINESS SOLUTIONS DIVISION view top 100 |