Socrata

Close
Author
Edwin Avanessian
Description
Financial Data for the Checkbook Explorer since Fiscal Year 2012.
Category
Purchasing
Tags
checkbook, echeckbook, expenditures, vendors, agencies
Rating
Current value: 0 out of 5
Data Provided By
Controller
Source Link
http://controller.lacity.org
License
Attribution 4.0 International
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

ID NUMBER
id_number
FISCAL YEAR
fiscal_year
DEPARTMENT NAME
department_name
VENDOR NAME
vendor_name
TRANSACTION DATE
transaction_date
DOLLAR AMOUNT
dollar_amount
AUTHORITY
authority
BUSINESS TAX REGISTRATION CERTIFICATE
business_tax_registration_certificate
GOVERNMENT ACTIVITY
government_activity
FUND GROUP NAME
fund_group_name
FUND TYPE
fund_type
FUND NAME
fund_name
FUND
fund
ACCOUNT NAME
account_name
ACCOUNT CODE
account_code
TRANSACTION ID
transaction_id
EXPENDITURE TYPE
expenditure_type
SETTLEMENT/JUDGMENT
settlement_judgment
FISCAL MONTH NUMBER
fiscal_month_number
FISCAL YEAR-MONTH
fiscal_year_month
FISCAL YEAR-QUARTER
fiscal_year_quarter
CALENDAR MONTH NUMBER
calendar_month_number
CALENDAR MONTH/YEAR
calendar_month_year
CALENDAR MONTH
calendar_month
DATA SOURCE
data_source
AUTHORITY NAME
authority_name
AUTHORITY LINK
authority_link

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.