Socrata

Close
Author
Controller Intern
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:

FISCAL YEAR
fiscal_year
DEPARTMENT NAME
department_name
VENDOR NAME
vendor_name
TRANSACTION DATE
transaction_date
DOLLAR AMOUNT
dollar_amount
AUTHORITY
authority
FUND NAME
fund_name
ACCOUNT NAME
account_name
DATA SOURCE
data_source
AUTHORITY NAME
authority_name
ZIP
zip
PAYMENT METHOD
payment_method
PO NUM
po_num
DESCRIPTION
description
DETAILED ITEM DESCRIPTION
detailed_item_description
UNIT PRICE
unit_price
UNIT OF MEASURE
unit_of_measure
QUANTITY
quantity
SALES TAX PERCENT
sales_tax_percent
SALES TAX
sales_tax
DISCOUNT
discount
PO DATE
po_date
SUPPLIER CITY
supplier_city
SUPPLIER COUNTRY
supplier_country
ITEM CODE NAME
item_code_name
CURRENCY
currency
VALUE OF SPEND
value_of_spend

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.