fastCRW Pergamon
Government
controllerdata.lacity.org
controllerdata.lacity.org
Socrata open data portal at controllerdata.lacity.org, publishing 347 public datasets from the publishing organisation, led by the Payroll category.
Showing the catalogue
GET /v1/data/controllerdata-lacity-org/catalog-search1Request
Full-text query over dataset names and descriptions.
Zero-based offset into the results; step by 20 to page.
1 credit⌘ ↵
Code follows the fields above
curl "https://api.fastcrw.com/v1/data/controllerdata-lacity-org/catalog-search?offset=0" \ -H "Authorization: Bearer $FASTCRW_API_KEY"
2Response example
A sample shape. Press Run to see live data from controllerdata.lacity.org.
JSON
{
"results": [
{
"resource": {
"name": "City Employee Payroll (Current)",
"id": "g9h8-fvhu",
"resource_name": null,
"parent_fxf": [],
"description": "Payroll information for all Los Angeles City Employees including the City's three proprietary departments: Water and Power, Airports and Harbor. Data is updated bi-weekly by the Los Angeles City Controller's Office. Payroll information for employees of the Department of Water and Power is updated every three months.",
"attribution": "Controller",
"attribution_link": "https://lacontroller.org/",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T17:48:12.000Z",
"createdAt": "2020-01-22T21:32:11.000Z",
"metadata_updated_at": "2025-09-11T17:33:39.000Z",
"data_updated_at": "2026-10-23T17:48:12.000Z",
"page_views": {
"page_views_last_week": 777,
"page_views_last_month": 5310,
"page_views_total": 481526,
"page_views_last_week_log": 9.603626344986191,
"page_views_last_month_log": 12.374767814092824,
"page_views_total_log": 18.87725716902478
},
"columns_name": [
"OVERTIME_PAY",
"BENEFIT_PAY",
"GENDER",
"MOU_TITLE",
"ALL_OTHER_PAY",
"LAST_NAME",
"DEPARTMENT_NO",
"JOB_CLASS_PGRADE",
"JOB_TITLE",
"TOTAL_PAY",
"… 10 more items"
],
"columns_field_name": [
"overtime_pay",
"benefit_pay",
"gender",
"mou_title",
"all_other_pay",
"last_name",
"fms_dept",
"job_class_pgrade",
"job_title",
"total_pay",
"… 10 more items"
],
"columns_datatype": [
"Number",
"Number",
"Text",
"Text",
"Number",
"Text",
"Number",
"Text",
"Text",
"Number",
"… 10 more items"
],
"columns_description": [
"Payments attributable to hours worked beyond regular work schedule",
"City contribution for the employee's health care, dental care, vision care, and life insurance",
"Gender as self-reported by employee",
"Title of Memorandum of Understanding",
"Any payments other than Regular and Overtime. This includes bonuses, adjustments, and lump sum payouts. Examples of bonuses include Permanent, Longevity, and Temporary Bonuses. Lump Sum Pay includes significant one-time payouts due to retirement, lawsuit settlements, or other adjustments.",
"Employee last name",
"Department Number in City Payroll System",
"Job Class and Pay Grade ",
"Job Title",
"Sum of regular, overtime and all other payments",
"… 10 more items"
],
"columns_format": [
{
"precisionStyle": "currency",
"precision": "2"
},
{
"precisionStyle": "currency",
"precision": "2"
},
{},
{},
{
"precisionStyle": "currency",
"noCommas": "false",
"precision": "2"
},
{},
{
"noCommas": "true"
},
{},
{},
{
"precisionStyle": "currency",
"precision": "2"
},
"… 10 more items"
],
"download_count": 6781,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2023-06-08T16:20:18.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Payroll",
"domain_tags": [
"payroll",
"healthcare",
"bonuses",
"personnel",
"overtime"
],
"domain_metadata": [
{
"key": "Department_System",
"value": "PaySR"
},
{
"key": "Department_Division",
"value": "Payroll"
},
{
"key": "Department_Department",
"value": "Controller"
},
{
"key": "Update-Information_Refresh-Rate",
"value": "bi-weekly"
}
]
},
"metadata": {
"domain": "controllerdata.lacity.org",
"license": "Creative Commons Attribution 4.0 International"
},
"permalink": "https://controllerdata.lacity.org/d/g9h8-fvhu",
"link": "https://controllerdata.lacity.org/Payroll/City-Employee-Payroll-Current-/g9h8-fvhu",
"owner": {
"id": "tnxe-g5ww",
"user_type": "interactive",
"display_name": "Riad"
},
"creator": {
"id": "tnxe-g5ww",
"user_type": "interactive",
"display_name": "Riad"
}
},
{
"resource": {
"name": "All City Funds",
"id": "ej7u-di9z",
"resource_name": null,
"parent_fxf": [],
"description": "Current balances of all Funds for the City of Los Angeles. Includes General Fund, Reserve Fund, Budget Stabilization Fund, and Special Funds. Upated daily, Monday through Friday.\n\nFor figures pertaining to Fiscal Year 2018, view the \"All City Funds - FY18\" dataset at https://controllerdata.lacity.org/dataset/All-City-Funds-FY18/9wxw-98tn/data.",
"attribution": "Controller",
"attribution_link": "http://controller.lacity.org",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T13:04:37.000Z",
"createdAt": "2014-03-29T00:25:13.000Z",
"metadata_updated_at": "2025-08-26T16:19:00.000Z",
"data_updated_at": "2026-10-23T13:04:37.000Z",
"page_views": {
"page_views_last_week": 191,
"page_views_last_month": 2282,
"page_views_total": 429599,
"page_views_last_week_log": 7.584962500721156,
"page_views_last_month_log": 11.156715144224702,
"page_views_total_log": 18.71263446776014
},
"columns_name": [
"Replacement Of General Funds Allowed",
"Interest To General Fund",
"Eligible Uses",
"Assets",
"Budget Amendments",
"Administering Department",
"Current Cash Balance",
"Fund Type",
"Cash Expenses",
"Adopted Budget",
"… 30 more items"
],
"columns_field_name": [
"replacement_of_general_funds_allowed",
"interest_to_general_fund",
"eligible_uses",
"assets",
"budget_amendments",
"administering_department",
"current_cash_balance",
"fund_type",
"cash_expenses",
"adopted_budget",
"… 30 more items"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Number",
"Number",
"Text",
"Number",
"Text",
"Number",
"Number",
"… 30 more items"
],
"columns_description": [
"Replacement of General Fund is allowed",
"Interest eligible for the General Fund?",
"Eligible uses for the fund",
"(A) Total Assets include Cash, Grant Receivables, and Other Assets",
"Amendments to the budget adopted by the Mayor and City Council",
"Department administering the fund",
"Cash Balance at the time of Data update.",
"Agency, Capital Projects, Debt Service, Enterprise, General Fund, Pension Trust, General Long Term Debt Group, or Special Revenue",
"Cash disbursed in the current fiscal year",
"Budget adopted by the Mayor and City Council",
"… 30 more items"
],
"columns_format": [
{},
{},
{},
{
"precisionStyle": "currency"
},
{
"precisionStyle": "currency",
"precision": "2"
},
{},
{
"precisionStyle": "currency",
"precision": "2"
},
{},
{
"precisionStyle": "currency",
"precision": "2"
},
{
"precisionStyle": "currency",
"precision": "2"
},
"… 30 more items"
],
"download_count": 12707,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2021-02-22T18:22:29.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Audits and Reports",
"domain_tags": [
"activity type",
"asset type group",
"cafr",
"cafr statistical section",
"city of la",
"city of la controller",
"city of los angeles",
"city of los angeles controller",
"comprehensive annual financial report",
"expenditures",
"… 6 more items"
],
"domain_metadata": [
{
"key": "Department_System",
"value": "FMS"
},
{
"key": "Department_Division",
"value": "FMS"
},
{
"key": "Department_Department",
"value": "Controller"
},
{
"key": "Update-Information_Refresh-Rate",
"value": "Everyday Monday To Friday"
}
]
},
"metadata": {
"domain": "controllerdata.lacity.org",
"license": "Creative Commons Attribution 4.0 International"
},
"permalink": "https://controllerdata.lacity.org/d/ej7u-di9z",
"link": "https://controllerdata.lacity.org/Audits-and-Reports/All-City-Funds/ej7u-di9z",
"owner": {
"id": "tnxe-g5ww",
"user_type": "interactive",
"display_name": "Riad"
},
"creator": {
"id": "tnxe-g5ww",
"user_type": "interactive",
"display_name": "Riad"
}
},
{
"resource": {
"name": "Checkbook L.A. Data",
"id": "pggv-e4fn",
"resource_name": null,
"parent_fxf": [],
"description": "This dataset contains City spending data and is used to power the Controller's Checkbook L.A application. Data since fiscal year 2018.",
"attribution": "Controller",
"attribution_link": "http://controller.lacity.org",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-22T14:14:35.000Z",
"createdAt": "2013-10-16T16:27:00.000Z",
"metadata_updated_at": "2026-08-26T18:21:29.000Z",
"data_updated_at": "2026-10-22T14:14:35.000Z",
"page_views": {
"page_views_last_week": 1248,
"page_views_last_month": 4631,
"page_views_total": 426513,
"page_views_last_week_log": 10.286557761607957,
"page_views_last_month_log": 12.177419537989236,
"page_views_total_log": 18.70223357213297
},
"columns_name": [
"VENDOR NUM",
"AUTHORITY LINK",
"FUND GROUP NAME",
"SETTLEMENT/JUDGMENT",
"BU NAME",
"CURRENCY",
"PAYMENT METHOD",
"PROCUREMENT ORGANIZATION",
"SALES TAX",
"INV NUM",
"… 51 more items"
],
"columns_field_name": [
"vendor_num",
"authority_link",
"fund_group_name",
"settlement_judgment",
"bu_name",
"currency",
"payment_method",
"procurement_organization",
"sales_tax",
"inv_num",
"… 51 more items"
],
"columns_datatype": [
"Text",
"URL",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Number",
"Text",
"… 51 more items"
],
"columns_description": [
"Vendor ID + Vendor Name",
"Authority Link (if applicable)",
"Fund Group Name",
"Relates to Settlement/Judgment",
"City Business Unit Name",
"Type of currency used in transaction",
"How payment was made",
"",
"Sales Tax Amount",
"Invoice #",
"… 51 more items"
],
"columns_format": [
{},
{
"align": "left"
},
{},
{},
{},
{},
{},
{},
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "2"
},
{
"align": "left"
},
"… 51 more items"
],
"download_count": 8692,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2024-07-12T09:12:41.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Purchasing",
"domain_tags": [
"echeckbook",
"vendors",
"agencies",
"checkbook",
"expenditures"
],
"domain_metadata": [
{
"key": "Data-Owner_Data-Owner",
"value": "Controller's Office"
},
{
"key": "Department_System",
"value": "FMS"
},
{
"key": "Department_Division",
"value": "FMS"
},
{
"key": "Department_Department",
"value": "Controller"
},
{
"key": "Update-Information_Refresh-Rate",
"value": "Monthly"
}
]
},
"metadata": {
"domain": "controllerdata.lacity.org",
"license": "Creative Commons Attribution 4.0 International"
},
"permalink": "https://controllerdata.lacity.org/d/pggv-e4fn",
"link": "https://controllerdata.lacity.org/Purchasing/Checkbook-L-A-Data/pggv-e4fn",
"owner": {
"id": "tnxe-g5ww",
"user_type": "interactive",
"display_name": "Riad"
},
"creator": {
"id": "tnxe-g5ww",
"user_type": "interactive",
"display_name": "Riad"
}
},
{
"resource": {
"name": "City Revenue",
"id": "hfus-a659",
"resource_name": null,
"parent_fxf": [],
"description": "City revenue including adopted, amended, budgeted and revenue collected since fiscal year 2012. Data is updated monthly.",
"attribution": "Controller's Office",
"attribution_link": "https://controllerdata.lacity.org/resource/hfus-a659.csv",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-20T13:11:32.000Z",
"createdAt": "2013-10-18T04:08:06.000Z",
"metadata_updated_at": "2024-03-09T00:52:01.000Z",
"data_updated_at": "2026-10-20T13:11:32.000Z",
"page_views": {
"page_views_last_week": 64,
"page_views_last_month": 1888,
"page_views_total": 413402,
"page_views_last_week_log": 6.022367813028454,
"page_views_last_month_log": 10.88340698638837,
"page_views_total_log": 18.657189332647242
},
"columns_name": [
"FUND NAME",
"% REVENUE COLLECTED",
"AMENDED REVENUE BUDGET",
"REVENUE SOURCE CODE",
"REVENUE BUDGET",
"REVENUE CLASS CODE",
"FUND",
"ADOPTED REVENUE BUDGET",
"REVENUE COLLECTED",
"REVENUE CLASS NAME",
"… 4 more items"
],
"columns_field_name": [
"fund_name",
"revenue_collected_pct",
"amended_revenue_budget",
"revenue_source_code",
"revenue_budget",
"revenue_class_code",
"fund",
"adopted_revenue_budget",
"revenue_collected",
"revenue_class_name",
"… 4 more items"
],
"columns_datatype": [
"Text",
"Number",
"Number",
"Text",
"Number",
"Number",
"Text",
"Number",
"Number",
"Text",
"… 4 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 4 more items"
],
"columns_format": [
{},
{
"noCommas": "false",
"align": "right",
"percentScale": "100",
"precisionStyle": "percentage",
"view": "percent_bar_and_text"
},
{
"precision": "2",
"align": "right",
"aggregate": "sum",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{},
{
"precision": "2",
"align": "right",
"aggregate": "sum",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{},
{
"precisionStyle": "standard",
"noCommas": "false",
"align": "right"
},
{
"precision": "2",
"align": "right",
"aggregate": "sum",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"precision": "2",
"align": "right",
"aggregate": "sum",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{},
"… 4 more items"
],
"download_count": 2454,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2015-04-06T19:54:05.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Revenue",
"domain_tags": [
"revenues",
"budget",
"general fund",
"revenue"
],
"domain_metadata": [
{
"key": "Data-Owner_Data-Owner",
"value": "Controller's Office"
},
{
"key": "Department_System",
"value": "FMS"
},
{
"key": "Department_Division",
"value": "FMS"
},
{
"key": "Department_Department",
"value": "Controller"
},
{
"key": "Update-Information_Refresh-Rate",
"value": "Monthly"
}
]
},
"metadata": {
"domain": "controllerdata.lacity.org",
"license": "Public Domain"
},
"permalink": "https://controllerdata.lacity.org/d/hfus-a659",
"link": "https://controllerdata.lacity.org/Revenue/City-Revenue/hfus-a659",
"owner": {
"id": "tnxe-g5ww",
"user_type": "interactive",
"display_name": "Riad"
},
"creator": {
"id": "tnxe-g5ww",
"user_type": "interactive",
"display_name": "Riad"
}
},
{
"resource": {
"name": "City Boundaries for Los Angeles County",
"id": "sttr-9nxz",
"resource_name": null,
"parent_fxf": [
"v8gf-sgg2"
],
"description": "The Los Angeles County Department of Public Works provides the most current shapefiles representing city boundaries within Los Angeles County, and the shapefiles available in this download includes polygons and lines.",
"attribution": "Los Angeles County Department of Public Works",
"attribution_link": "http://egis3.lacounty.gov/dataportal/2013/01/03/city-boundaries/",
"contact_email": null,
"type": "map",
"updatedAt": "2024-04-24T18:36:23.000Z",
"createdAt": "2014-04-21T20:32:37.000Z",
"metadata_updated_at": "2024-04-24T18:36:23.000Z",
"data_updated_at": "2014-04-21T20:32:46.000Z",
"page_views": {
"page_views_last_week": 142,
"page_views_last_month": 284,
"page_views_total": 84237,
"page_views_last_week_log": 7.159871336778389,
"page_views_last_month_log": 8.154818109052105,
"page_views_total_log": 16.36218356348746
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 1187,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "visualization_canvas_map",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2014-04-21T20:32:54.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": [
{
"key": "Department_Other",
"value": ""
},
{
"key": "Department_Controller",
"value": ""
},
{
"key": "Update-Information_Refresh-Rate",
"value": ""
}
]
},
"metadata": {
"domain": "controllerdata.lacity.org"
},
"permalink": "https://controllerdata.lacity.org/d/sttr-9nxz",
"link": "https://controllerdata.lacity.org/dataset/City-Boundaries-for-Los-Angeles-County/sttr-9nxz",
"preview_image_url": "https://controllerdata.lacity.org/views/sttr-9nxz/files/07ac886c-92a8-4984-810d-10bd06fc8e15",
"owner": {
"id": "mnkj-bu52",
"user_type": "interactive",
"display_name": "Controller's Office"
},
"creator": {
"id": "mnkj-bu52",
"user_type": "interactive",
"display_name": "Controller's Office"
}
},
{
"resource": {
"name": "City Employee Payroll (2013-2018)",
"id": "pazn-qyym",
"resource_name": null,
"parent_fxf": [],
"description": "Note this dataset is no longer being updated. Please use the updated payroll dataset with current pay year information: https://controllerdata.lacity.org/Payroll/City-Employee-Payroll-Current-/g9h8-fvhu.\n\nPayroll information for all Los Angeles City Employees including the City's three proprietary departments: Water and Power, Airports and Harbor. Data is updated on a quarterly basis by the Los Angeles City Controller's Office. Payroll information for employees of the Department of Water and Power is provided by the Department.",
"attribution": "Controller",
"attribution_link": "http://controller.lacity.org",
"contact_email": null,
"type": "dataset",
"updatedAt": "2021-02-09T23:34:48.000Z",
"createdAt": "2015-07-28T19:57:27.000Z",
"metadata_updated_at": "2021-02-09T23:34:48.000Z",
"data_updated_at": "2019-06-05T17:35:18.000Z",
"page_views": {
"page_views_last_week": 41,
"page_views_last_month": 221,
"page_views_total": 69559,
"page_views_last_week_log": 5.392317422778761,
"page_views_last_month_log": 7.794415866350106,
"page_views_total_log": 16.08597031219395
},
"columns_name": [
"Job Class Title",
"Record Number",
"Payroll Department",
"Department Title",
"Row ID",
"Pay Grade",
"Permanent Bonus Pay",
"Benefits Plan",
"Employment Type",
"MOU Title",
"… 25 more items"
],
"columns_field_name": [
"job_class_title",
"record_number",
"payroll_department",
"department_title",
"row_id",
"pay_grade",
"permanent_bonus_pay",
"benefits_plan",
"employment_type",
"mou_title",
"… 25 more items"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Number",
"Text",
"Text",
"Text",
"… 25 more items"
],
"columns_description": [
"",
"",
"Department Number in City Payroll System",
"Title of City Department",
"Unique Identifier for each row",
"Pay Grade for the Job Class",
"Payments attributable to permanent bonuses; typically pensionable",
"",
"Employment Type - Full Time, Part Time, or Per Event",
"Title of Memorandum of Understanding",
"… 25 more items"
],
"columns_format": [
{},
{
"align": "left"
},
{
"displayStyle": "plain",
"align": "left"
},
{
"align": "left"
},
{
"precisionStyle": "standard",
"noCommas": "true",
"align": "right"
},
{
"align": "right"
},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"align": "left"
},
{
"align": "left"
},
{
"align": "left"
},
"… 25 more items"
],
"download_count": 6502,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2018-11-20T23:03:11.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Payroll",
"domain_tags": [
"personnel",
"payroll",
"healthcare",
"overtime",
"bonuses"
],
"domain_metadata": [
{
"key": "Department_System",
"value": "PaySR"
},
{
"key": "Department_Division",
"value": "Payroll"
},
{
"key": "Department_Department",
"value": "Controller"
},
{
"key": "Update-Information_Refresh-Rate",
"value": "Quarterly"
}
]
},
"metadata": {
"domain": "controllerdata.lacity.org",
"license": "Creative Commons Attribution 4.0 International"
},
"permalink": "https://controllerdata.lacity.org/d/pazn-qyym",
"link": "https://controllerdata.lacity.org/Payroll/City-Employee-Payroll-2013-2018-/pazn-qyym",
"owner": {
"id": "tnxe-g5ww",
"user_type": "interactive",
"display_name": "Riad"
},
"creator": {
"id": "tnxe-g5ww",
"user_type": "interactive",
"display_name": "Riad"
}
},
{
"resource": {
"name": "HOMELESSNESS EXPENSE TRACKER",
"id": "98ve-cuf5",
"resource_name": null,
"parent_fxf": [],
"description": "City expenditures related to Homelessness efforts in the City of LA starting with fiscal year 2024. Data populated by City departments who code and map expenses to homeless project categories. (Not all departments are included due to the way the department maps homeless expenditures)",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T13:02:31.000Z",
"createdAt": "2023-12-21T21:08:33.000Z",
"metadata_updated_at": "2024-03-09T00:45:24.000Z",
"data_updated_at": "2026-10-23T13:02:31.000Z",
"page_views": {
"page_views_last_week": 104,
"page_views_last_month": 244,
"page_views_total": 56237,
"page_views_last_week_log": 6.714245517666122,
"page_views_last_month_log": 7.936637939002572,
"page_views_total_log": 15.779257668103071
},
"columns_name": [
"TRANSACTION CLOSED",
"FISCAL YEAR",
"PAYMENT DESCRIPTION",
"BUSINESS TYPE",
"DEPARTMENT CODE",
"WORK ORDER",
"APPROPRIATION CODE",
"DOC ACCOUNTING LINE NUMBER",
"VENDOR CUST CODE",
"FUND CODE",
"… 12 more items"
],
"columns_field_name": [
"transaction_closed",
"fiscal_year",
"payment_description",
"business_type",
"dept_cd",
"work_order",
"appr_cd",
"doc_actg_ln_no",
"vend_cust_cd",
"fund_cd",
"… 12 more items"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Text",
"Number",
"Text",
"Text",
"Number",
"Text",
"Text",
"… 12 more items"
],
"columns_description": [
"",
"Fiscal year",
"Description",
"Business type of vendor",
"Department code",
"Work order code",
"Appropriation account code",
"",
"",
"",
"… 12 more items"
],
"columns_format": [
{},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{},
{},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{},
{},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{},
{},
"… 12 more items"
],
"download_count": 717,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2024-01-02T21:41:58.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "controllerdata.lacity.org"
},
"permalink": "https://controllerdata.lacity.org/d/98ve-cuf5",
"link": "https://controllerdata.lacity.org/dataset/HOMELESSNESS-EXPENSE-TRACKER/98ve-cuf5",
"owner": {
"id": "tnxe-g5ww",
"user_type": "interactive",
"display_name": "Riad"
},
"creator": {
"id": "tnxe-g5ww",
"user_type": "interactive",
"display_name": "Riad"
}
},
{
"resource": {
"name": "Pticket",
"id": "cmmd-pibt",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2023-04-12T18:41:34.000Z",
"createdAt": "2023-04-12T18:39:01.000Z",
"metadata_updated_at": "2023-04-12T18:41:34.000Z",
"data_updated_at": "2023-04-12T18:40:43.000Z",
"page_views": {
"page_views_last_week": 7,
"page_views_last_month": 22,
"page_views_total": 46768,
"page_views_last_week_log": 3,
"page_views_last_month_log": 4.523561956057013,
"page_views_total_log": 15.513264961385962
},
"columns_name": [
"Longitude",
"YEAR",
"LOCATION",
"VIOLATION",
"# OF CITATIONS",
"$ FINE AMT",
"City",
"State",
"Full_Address",
"Latitude"
],
"columns_field_name": [
"longitude",
"year",
"location",
"violation",
"of_citations",
"fine_amt",
"city",
"state",
"full_address",
"latitude"
],
"columns_datatype": [
"Number",
"Number",
"Text",
"Text",
"Number",
"Number",
"Text",
"Text",
"Text",
"Number"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
""
],
"columns_format": [
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{},
{},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{},
{},
{},
{
"decimalSeparator": ".",
"groupSeparator": ","
}
],
"download_count": 2826,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2023-04-12T18:41:34.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "controllerdata.lacity.org"
},
"permalink": "https://controllerdata.lacity.org/d/cmmd-pibt",
"link": "https://controllerdata.lacity.org/dataset/Pticket/cmmd-pibt",
"owner": {
"id": "26cb-izd6",
"user_type": "interactive",
"display_name": "Vartan Arzumanyan"
},
"creator": {
"id": "26cb-izd6",
"user_type": "interactive",
"display_name": "Vartan Arzumanyan"
}
},
{
"resource": {
"name": "Idle Funds",
"id": "ucfm-mnmk",
"resource_name": null,
"parent_fxf": [],
"description": "Idle Funds are Los Angeles City funds with no expenditures since June 30, 2014, as identified by LA Controller Ron Galperin.",
"attribution": "City of Los Angeles - Office of the Controller",
"attribution_link": "http://www.controllerdata.lacity.org",
"contact_email": null,
"type": "dataset",
"updatedAt": "2018-03-29T00:07:12.000Z",
"createdAt": "2018-03-28T19:00:28.000Z",
"metadata_updated_at": "2018-03-29T00:07:12.000Z",
"data_updated_at": "2018-03-29T00:06:54.000Z",
"page_views": {
"page_views_last_week": 10,
"page_views_last_month": 17,
"page_views_total": 42216,
"page_views_last_week_log": 3.4594316186372978,
"page_views_last_month_log": 4.169925001442312,
"page_views_total_log": 15.365536441917632
},
"columns_name": [
"Notes",
"Administering Department",
"Fund Name",
"Fund No.",
"Category",
"Recommendations",
"Years Since Last Expenditure",
"January 31 Cash Balance "
],
"columns_field_name": [
"notes",
"administering_department",
"fund_name",
"fund_no",
"category",
"recommendations",
"years_since_last_expenditure",
"january_31_cash_balance"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Number"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
""
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{
"precision": "2",
"align": "left",
"currencyStyle": "USD",
"precisionStyle": "currency",
"displayStyle": "plain"
}
],
"download_count": 5980,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2018-03-29T00:07:11.000Z"
},
"classification": {
"categories": [
"infrastructure"
],
"tags": [],
"domain_category": "Budget",
"domain_tags": [
"idle",
"los angeles",
"special",
"special funds",
"idle funds",
"unspent"
],
"domain_metadata": []
},
"metadata": {
"domain": "controllerdata.lacity.org"
},
"permalink": "https://controllerdata.lacity.org/d/ucfm-mnmk",
"link": "https://controllerdata.lacity.org/Budget/Idle-Funds/ucfm-mnmk",
"owner": {
"id": "594h-mv4h",
"user_type": "interactive",
"display_name": "Controller Galperin"
},
"creator": {
"id": "594h-mv4h",
"user_type": "interactive",
"display_name": "Controller Galperin"
}
},
{
"resource": {
"name": "City Elected Officials Pay Rate",
"id": "t9w5-r8bn",
"resource_name": null,
"parent_fxf": [
"i2m4-kg2v",
"j9n3-ckiy"
],
"description": "Current pay rate for Council Members, Mayor, City Attorney and City Controller",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2025-02-11T17:35:52.744Z",
"createdAt": "2022-12-22T19:22:04.000Z",
"metadata_updated_at": "2022-12-22T23:09:14.000Z",
"data_updated_at": "2025-02-11T17:35:52.744Z",
"page_views": {
"page_views_last_week": 209,
"page_views_last_month": 890,
"page_views_total": 34274,
"page_views_last_week_log": 7.714245517666122,
"page_views_last_month_log": 9.799281621521923,
"page_views_total_log": 15.064869045553952
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 0,
"provenance": "official",
"lens_view_type": "story",
"lens_display_type": "story",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2022-12-22T22:11:36.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "controllerdata.lacity.org"
},
"permalink": "https://controllerdata.lacity.org/stories/s/t9w5-r8bn",
"link": "https://controllerdata.lacity.org/stories/s/t9w5-r8bn",
"owner": {
"id": "22k2-6g7v",
"user_type": "interactive",
"display_name": "Guoxuan Chang"
},
"creator": {
"id": "22k2-6g7v",
"user_type": "interactive",
"display_name": "Guoxuan Chang"
}
},
"… 10 more items"
],
"resultSetSize": 347,
"timings": {
"serviceMillis": 34,
"searchMillis": [
19,
5
]
},
"warnings": []
}Attribution: Source: controllerdata.lacity.org. Dataset attribution as stated by each publishing agency.
Licence: Datasets on this portal declare the licence "Creative Commons Attribution 4.0 International" in their Socrata metadata; the portal publishes no separate API licence and different datasets may carry different terms. Quoted as found in the portal's own catalogue.
Ask with this source
A prompt for your agent that names this source and how to call it through the crw MCP.
Catalogue search
Use controllerdata.lacity.org (controllerdata-lacity-org) from fastCRW Pergamon, capability "Catalogue search" (catalog-search). You want to find a dataset on this portal by keyword and do not know its four-by-four id. Example options: q=taxi, offset=0, order=page_views_total DESC. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "controllerdata-lacity-org" and capability "catalog-search". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Dataset metadata
Use controllerdata.lacity.org (controllerdata-lacity-org) from fastCRW Pergamon, capability "Dataset metadata" (dataset). You already hold a dataset id and need its columns, licence or description before querying rows. Example options: id=g268-xe4i. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "controllerdata-lacity-org" and capability "dataset". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Dataset inventory
Use controllerdata.lacity.org (controllerdata-lacity-org) from fastCRW Pergamon, capability "Dataset inventory" (datasets). You need to enumerate what this portal publishes, or page through its newest datasets. Example options: offset=0, order=createdAt, category=Transportation. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "controllerdata-lacity-org" and capability "datasets". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Row count
Use controllerdata.lacity.org (controllerdata-lacity-org) from fastCRW Pergamon, capability "Row count" (row-count). You need to know how large a dataset is before downloading it, or want a cheap liveness check. Example options: id=g268-xe4i. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "controllerdata-lacity-org" and capability "row-count". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>