Socrata

Close
Author
Riad
Description
Financial Data for the Checkbook Explorer. Data 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
Public Domain
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
btrc
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
DEPARTMENT NUMBER
department_number
PROGRAM
program
VENDOR ID
vendor_id
ZIP
zip
PAYMENT METHOD
payment_method
PAYMENT STATUS
payment_status
INV NUM
inv_num
INVOICE DUE DATE
invoice_due_date
INVOICE DISCOUNT DUE DATE
invoice_discount_due_date
INV DATE
inv_date
INV LINE
inv_line
INVOICE DISTRIBUTION LINE
inv_dist_line
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
RECEIVER ID
receiver_id
PO DATE
po_date
PO LINE NUMBER
po_line_number
PROCUREMENT ORGANIZATION
procurement_organization
BUYER NAME
buyer_name
SUPPLIER CITY
supplier_city
SUPPLIER COUNTRY
supplier_country
BU NAME
bu_name
SITE LOCATION
site_location
ITEM CODE
item_code
ITEM CODE NAME
item_code_name
CURRENCY
currency
VALUE OF SPEND
value_of_spend
VENDOR NUM
vendor_num

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.