fastCRW Pergamon
Government · US
data.oaklandca.gov
data.oaklandca.gov
Socrata open data portal at data.oaklandca.gov, publishing 739 public datasets from the publishing organisation, led by the Equity Indicators category.
Showing the catalogue
GET /v1/data/data-oaklandca-gov/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/data-oaklandca-gov/catalog-search?offset=0" \ -H "Authorization: Bearer $FASTCRW_API_KEY"
2Response example
A sample shape. Press Run to see live data from data.oaklandca.gov.
JSON
{
"results": [
{
"resource": {
"name": "CrimeWatch Maps Past 90-Days",
"id": "ym6k-rx7a",
"resource_name": null,
"parent_fxf": [],
"description": "The Oakland Police Department provides crime data to the public through the City of Oakland's Crime Watch web site. This site presents the data in a geographic format, which allows users of the information to produce maps and/or reports. \n\nThe file that you are about to electronically download, copy, or otherwise retrieve by other means is a tabular representation of the same data without maps or reporting capabilities. Be advised that the exact address of each crime has been substituted with the block address to protect the privacy of the victim. \n\nPlease note: This Crime data are captured from reports filed with the police Department. There may be delays in data due to data processing, incident reporting or maybe technical in nature. Please allow up to 90 days from the end of each month for the data to be completely processed. For example, if you want to retrieve the full data set for the month of March, you will need to generate your report on or after June 30th. (A full 90 days after March 31st)",
"attribution": "Oakland Police Department",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T13:01:38.000Z",
"createdAt": "2013-01-23T20:03:10.000Z",
"metadata_updated_at": "2026-10-23T13:01:34.000Z",
"data_updated_at": "2026-10-23T13:01:38.000Z",
"page_views": {
"page_views_last_week": 329,
"page_views_last_month": 1222,
"page_views_total": 159624,
"page_views_last_week_log": 8.366322214245816,
"page_views_last_month_log": 10.256208688527387,
"page_views_total_log": 17.284327094364812
},
"columns_name": [
"Zip Codes 2",
"STATE",
"Location",
"ADDRESS",
"CRIMETYPE",
"DATETIME",
"CASENUMBER",
"POLICEBEAT",
"DESCRIPTION",
"CITY"
],
"columns_field_name": [
":@computed_region_w23w_jfhw",
"state",
"location_1",
"address",
"crimetype",
"datetime",
"casenumber",
"policebeat",
"description",
"city"
],
"columns_datatype": [
"Number",
"Text",
"Point",
"Text",
"Text",
"Calendar date",
"Text",
"Text",
"Text",
"Text"
],
"columns_description": [
"This column was automatically created in order to record in what polygon from the dataset 'Zip Codes' (w23w-jfhw) the point in column 'location_1' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
"",
"",
"",
"",
"",
"",
"",
"",
""
],
"columns_format": [
{},
{
"align": "left"
},
{},
{
"align": "left"
},
{},
{},
{},
{},
{},
{
"align": "left"
}
],
"download_count": 18247,
"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": "2020-10-26T21:43:27.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Public Safety",
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.oaklandca.gov"
},
"permalink": "https://data.oaklandca.gov/d/ym6k-rx7a",
"link": "https://data.oaklandca.gov/Public-Safety/CrimeWatch-Maps-Past-90-Days/ym6k-rx7a",
"owner": {
"id": "6tru-24hn",
"user_type": "interactive",
"display_name": "City of Oakland"
},
"creator": {
"id": "6tru-24hn",
"user_type": "interactive",
"display_name": "City of Oakland"
}
},
{
"resource": {
"name": "CrimeWatch Data",
"id": "ppgh-7dqv",
"resource_name": null,
"parent_fxf": [],
"description": "A full dataset of CrimeWatch data.\n\nThe Oakland Police Department provides crime data to the public through the City of Oakland's Crime Watch web site. This site presents the data in a geographic format, which allows users of the information to produce maps and/or reports.\n\nThe file that you are about to electronically download, copy, or otherwise retrieve by other means is a tabular representation of the same data without maps or reporting capabilities. Be advised that the exact address of each crime has been substituted with the block address to protect the privacy of the victim.\n\nPlease note: This Crime data are captured from reports filed with the police Department. There may be delays in data due to data processing, incident reporting or maybe technical in nature. Please allow up to 90 days from the end of each month for the data to be completely processed. For example, if you want to retrieve the full data set for the month of March, you will need to generate your report on or after June 30th. (A full 90 days after March 31st)",
"attribution": "Oakland Police Department",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T12:54:13.000Z",
"createdAt": "2021-06-17T15:44:42.000Z",
"metadata_updated_at": "2026-10-23T12:39:23.000Z",
"data_updated_at": "2026-10-23T12:54:13.000Z",
"page_views": {
"page_views_last_week": 404,
"page_views_last_month": 1469,
"page_views_total": 38977,
"page_views_last_week_log": 8.661778097771986,
"page_views_last_month_log": 10.521600439723727,
"page_views_total_log": 15.250372445924969
},
"columns_name": [
"CaseNumber",
"Address",
"City",
"Zip Codes",
"State",
"PoliceBeat",
"DateTime",
"Description",
"CrimeType",
"Location"
],
"columns_field_name": [
"casenumber",
"address",
"city",
":@computed_region_w23w_jfhw",
"state",
"policebeat",
"datetime",
"description",
"crimetype",
"location"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Number",
"Text",
"Text",
"Calendar date",
"Text",
"Text",
"Point"
],
"columns_description": [
"",
"",
"",
"This column was automatically created in order to record in what polygon from the dataset 'Zip Codes' (w23w-jfhw) the point in column 'location' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
"",
"",
"",
"",
"",
""
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{},
{}
],
"download_count": 9010,
"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-06-17T17:13:35.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Public Safety",
"domain_tags": [
"crime"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.oaklandca.gov"
},
"permalink": "https://data.oaklandca.gov/d/ppgh-7dqv",
"link": "https://data.oaklandca.gov/Public-Safety/CrimeWatch-Data/ppgh-7dqv",
"owner": {
"id": "t6gj-rebw",
"user_type": "interactive",
"display_name": "Oakland Support Team"
},
"creator": {
"id": "t6gj-rebw",
"user_type": "interactive",
"display_name": "Oakland Support Team"
}
},
{
"resource": {
"name": "Service requests received by the Oakland Call Center (OAK 311)",
"id": "quth-gb8e",
"resource_name": null,
"parent_fxf": [],
"description": "REQUESTID = The service request number. This should be shown as an integer without decimals. 5-digit REQUESTIDs were imported from the Recycling Hotline’s prior tracking system when they switched to the same system as the Oakland Call Center in August 2012. All others are 6 digits. \n\nDATETIMEINIT = The Date that the request was initiated. \n\nSOURCE = Indicates if the request was received via SeeClickFix or the OAK 311 mobile app, via the legacy Report A Problem website, or via (Phone or Email). \n\nDESCRIPTION = Type of issue. Most of these are self-explanatory. Notes: “test template” and “This is a test subject. Ignore this ticket.” were for testing/training purposes only. Descriptions starting with “Business” “City Services” “CityBldg” (no space) “Events” “Misc” are/were used by the Recycling Hotline “TE” means “Traffic Engineering” \n\nREQCATEGORY = Request Category \n\nREQADDRESS = Request Address An address of ZZ indicates that the address was not recorded, usually this is for general inquiries to the Recycling Hotline. \n\n\nSTATUS = The status as of date of upload. PENDING: Request received for review OPEN: Request assigned to work unit WOCREATE: Work Order created for work to be done (not all work units use this status, so Open service requests may also have work orders created for work to be done) CLOSED: Request is resolved REFERRED: Oakland Call Center received the request and forwarded it to another entity (see REFERREDTO) UNFUNDED: Request is for an service that the City is not funded to provide CANCEL: Request was canceled, generally because it was created erroneously, it was used for testing/training, or it is a request that was received that duplicated an existing unresolved request WAITING ON CUSTOMER: Request involves a process where customer needs to provide information requested by staff EVALUATED - NO FURTHER ACTION: Staff has evaluated the service request and no further action will be taken (e.g., limited resources, temporary issue, staff alerted to ongo…",
"attribution": "City of Oakland Public Works / Department of Transportation",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T13:08:34.000Z",
"createdAt": "2013-04-16T17:57:36.000Z",
"metadata_updated_at": "2026-10-23T13:08:34.000Z",
"data_updated_at": "2026-10-19T13:14:51.000Z",
"page_views": {
"page_views_last_week": 172,
"page_views_last_month": 888,
"page_views_total": 33437,
"page_views_last_week_log": 7.4346282276367255,
"page_views_last_month_log": 9.796039608829771,
"page_views_total_log": 15.029200938799262
},
"columns_name": [
"DATETIMEINIT",
"STATUS",
"REQADDRESS",
"REQCATEGORY",
"DESCRIPTION",
"REQADDRESS (state)",
"DATETIMECLOSED",
"REFERREDTO",
"REQADDRESS (city)",
"REQUESTID",
"… 12 more items"
],
"columns_field_name": [
"datetimeinit",
"status",
"reqaddress",
"reqcategory",
"description",
"reqaddress_state",
"datetimeclosed",
"referredto",
"reqaddress_city",
"requestid",
"… 12 more items"
],
"columns_datatype": [
"Calendar date",
"Text",
"Point",
"Text",
"Text",
"Text",
"Calendar date",
"Text",
"Text",
"Number",
"… 12 more items"
],
"columns_description": [
"The Date that the request was initiated.",
"STATUS = The status as of date of upload. PENDING: Request received for review OPEN: Request assigned to work unit WOCREATE: Work Order created for work to be done (not all work units use this status, so Open service requests may also have work orders created for work to be done) CLOSED: Request is resolved REFERRED: Oakland Call Center received the request and forwarded it to another entity (see REFERREDTO) UNFUNDED: Request is for an service that the City is not funded to provide CANCEL: Request was canceled, generally because it was created erroneously, it was used for testing/training, or it is a request that was received that duplicated an existing unresolved request WAITING ON CUSTOMER: Request involves a process where customer needs to provide information requested by staff EVALUATED - NO FURTHER ACTION: Staff has evaluated the service request and no further action will be taken (e.g., limited resources, temporary issue, staff alerted to ongoing issue, professional judgement says to leave situation as-is, unable to provide requested action) GONE ON ARRIVAL: Staff went to location and was unable to verify the issue",
"Request Address",
"Request Category",
"Type of issue. Most of these are self-explanatory. Notes: “test template” and “This is a test subject. Ignore this ticket.” were for testing/training purposes only. Descriptions starting with “Business” “City Services” “CityBldg” (no space) “Events” “Misc” are/were used by the Recycling Hotline “TE” means “Traffic Engineering”",
"",
"The Date that the request was closed",
" If the status is Referred, this shows who it was referred to.",
"",
"The service request number. This should be shown as an integer without decimals. 5-digit REQUESTIDs were imported from the Recycling Hotline’s prior tracking system when they switched to the same system as the Oakland Call Center in August 2012. All others are 6 digits.",
"… 12 more items"
],
"columns_format": [
{
"view": "date_time",
"align": "left"
},
{
"displayStyle": "plain",
"align": "left"
},
{
"view": "address_coords",
"align": "left"
},
{
"align": "left"
},
{
"align": "left"
},
{},
{
"view": "date_time",
"align": "left"
},
{
"align": "left"
},
{},
{
"precisionStyle": "standard",
"noCommas": "false",
"align": "right",
"mask": "######"
},
"… 12 more items"
],
"download_count": 6686,
"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-07-25T18:41:07.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Infrastructure",
"domain_tags": [
"maintenance",
"illegal dumping",
"public works",
"pot holes",
"311",
"transportation",
"service requests"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.oaklandca.gov",
"license": "Public Domain"
},
"permalink": "https://data.oaklandca.gov/d/quth-gb8e",
"link": "https://data.oaklandca.gov/Infrastructure/Service-requests-received-by-the-Oakland-Call-Cent/quth-gb8e",
"owner": {
"id": "8sqi-42eu",
"user_type": "interactive",
"display_name": "Will"
},
"creator": {
"id": "8sqi-42eu",
"user_type": "interactive",
"display_name": "Will"
}
},
{
"resource": {
"name": "Oakland Police: Arrests",
"id": "eqyv-8xr2",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2022-04-19T16:53:52.615Z",
"createdAt": "2021-03-03T00:26:16.000Z",
"metadata_updated_at": "2021-06-02T21:55:24.000Z",
"data_updated_at": "2022-04-19T16:53:52.615Z",
"page_views": {
"page_views_last_week": 212,
"page_views_last_month": 1103,
"page_views_total": 28111,
"page_views_last_week_log": 7.734709620225839,
"page_views_last_month_log": 10.108524456778168,
"page_views_total_log": 14.778898476008377
},
"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": "2021-06-02T21:55:24.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.oaklandca.gov"
},
"permalink": "https://data.oaklandca.gov/stories/s/eqyv-8xr2",
"link": "https://data.oaklandca.gov/stories/s/eqyv-8xr2",
"owner": {
"id": "t6gj-rebw",
"user_type": "interactive",
"display_name": "Oakland Support Team"
},
"creator": {
"id": "t6gj-rebw",
"user_type": "interactive",
"display_name": "Oakland Support Team"
}
},
{
"resource": {
"name": "Financial Health",
"id": "2z9b-x57f",
"resource_name": null,
"parent_fxf": [
"vmky-h4jx",
"2d8e-kc2m",
"r6tb-cdq8"
],
"description": "The Financial Health Topic includes three Indicators that consider economic security and stability through measures of banking, income, and poverty. The first Indicator measures disparities in the rate of access to healthy financial institutions in White and non-White zip codes. The second Indicator measures racial and ethnic disparities in median household income, while the third Indicator focuses on poverty.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2020-11-10T16:34:44.770Z",
"createdAt": "2018-07-11T20:23:38.000Z",
"metadata_updated_at": "2018-09-04T15:45:07.000Z",
"data_updated_at": "2020-11-10T16:34:44.770Z",
"page_views": {
"page_views_last_week": 45,
"page_views_last_month": 239,
"page_views_total": 22101,
"page_views_last_week_log": 5.523561956057013,
"page_views_last_month_log": 7.906890595608519,
"page_views_total_log": 14.431889303895977
},
"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": "2018-07-11T20:24:59.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Equity Indicators",
"domain_tags": [
"racial equity reports",
"report",
"economy",
"equity",
"equity data",
"equity indicators",
"financial health",
"oakland",
"race",
"racial equity oakland"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.oaklandca.gov"
},
"permalink": "https://data.oaklandca.gov/stories/s/2z9b-x57f",
"link": "https://data.oaklandca.gov/stories/s/2z9b-x57f",
"owner": {
"id": "b6sx-5aq2",
"user_type": "interactive",
"display_name": "Kevin Donohue"
},
"creator": {
"id": "b6sx-5aq2",
"user_type": "interactive",
"display_name": "Kevin Donohue"
}
},
{
"resource": {
"name": "Oakland Police: Pursuits",
"id": "j6sd-cq8q",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2022-04-19T18:04:16.713Z",
"createdAt": "2021-03-02T17:31:32.000Z",
"metadata_updated_at": "2021-06-02T22:13:27.000Z",
"data_updated_at": "2022-04-19T18:04:16.713Z",
"page_views": {
"page_views_last_week": 60,
"page_views_last_month": 222,
"page_views_total": 20193,
"page_views_last_week_log": 5.930737337562887,
"page_views_last_month_log": 7.800899899920305,
"page_views_total_log": 14.301639085592372
},
"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": "2021-06-02T22:13:27.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.oaklandca.gov"
},
"permalink": "https://data.oaklandca.gov/stories/s/j6sd-cq8q",
"link": "https://data.oaklandca.gov/stories/s/j6sd-cq8q",
"owner": {
"id": "t6gj-rebw",
"user_type": "interactive",
"display_name": "Oakland Support Team"
},
"creator": {
"id": "t6gj-rebw",
"user_type": "interactive",
"display_name": "Oakland Support Team"
}
},
{
"resource": {
"name": "Essentials",
"id": "uzsp-6qvc",
"resource_name": null,
"parent_fxf": [
"3xq4-ermg"
],
"description": "This dataset includes all itemized monetary contributions ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule \"A\" Monetary Contributions from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76",
"attribution": "City of Oakland Public Ethics Commission",
"attribution_link": "http://nf4.netfile.com/pub2/",
"contact_email": null,
"type": "filter",
"updatedAt": "2026-10-23T13:31:57.000Z",
"createdAt": "2015-01-15T21:21:13.000Z",
"metadata_updated_at": "2025-01-30T06:06:06.000Z",
"data_updated_at": "2026-10-23T13:31:57.000Z",
"page_views": {
"page_views_last_week": 13,
"page_views_last_month": 52,
"page_views_total": 19193,
"page_views_last_week_log": 3.8073549220576037,
"page_views_last_month_log": 5.7279204545632,
"page_views_total_log": 14.22836777783683
},
"columns_name": [
"Filer_ID",
"Tran_Date",
"Tran_Amt2",
"Tran_NamL",
"Tran_Amt1",
"Rpt_Date",
"Filer_NamL",
"Tran_NamF"
],
"columns_field_name": [
"filer_id",
"tran_date",
"tran_amt2",
"tran_naml",
"tran_amt1",
"rpt_date",
"filer_naml",
"tran_namf"
],
"columns_datatype": [
"Text",
"Calendar date",
"Number",
"Text",
"Number",
"Calendar date",
"Text",
"Text"
],
"columns_description": [
"ID number of Filer",
"Date of Transation",
"Cumulative Year-To-Date",
"Contributer's Last Name",
"Transaction Amount this Period",
"Date this Report is Filed",
"Name of Filer",
"Contributer's First Name"
],
"columns_format": [
{},
{
"view": "date",
"align": "left"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "2"
},
{},
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "2"
},
{
"view": "date",
"align": "left"
},
{},
{}
],
"download_count": 424,
"provenance": "community",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2014-03-19T03:06:33.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [
"contributions",
"fppc",
"schedule a",
"monetary",
"460",
"campaign",
"form",
"finance",
"ethics"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.oaklandca.gov",
"license": "Creative Commons 1.0 Universal (Public Domain Dedication)"
},
"permalink": "https://data.oaklandca.gov/d/uzsp-6qvc",
"link": "https://data.oaklandca.gov/dataset/Essentials/uzsp-6qvc",
"owner": {
"id": "jf8z-xuw7",
"user_type": "interactive",
"display_name": "Proto"
},
"creator": {
"id": "jf8z-xuw7",
"user_type": "interactive",
"display_name": "Proto"
}
},
{
"resource": {
"name": "Oakland Equity Indicators",
"id": "brb2-j4ad",
"resource_name": null,
"parent_fxf": [],
"description": "The purpose of Oakland’s Equity Indicators Report is to develop a baseline quantitative framework that can be used by City staff and community members alike to better understand the impacts of race, measure inequities, and track changes in the disparities for different groups over time. This framework can then be used to guide and inform policies that address these disparities.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2020-11-10T16:58:56.037Z",
"createdAt": "2018-07-03T16:50:40.000Z",
"metadata_updated_at": "2018-08-31T18:13:42.000Z",
"data_updated_at": "2020-11-10T16:58:56.037Z",
"page_views": {
"page_views_last_week": 35,
"page_views_last_month": 220,
"page_views_total": 18289,
"page_views_last_week_log": 5.169925001442312,
"page_views_last_month_log": 7.787902559391432,
"page_views_total_log": 14.158767454636079
},
"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": "2018-07-09T20:37:30.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Equity Indicators",
"domain_tags": [
"report",
"race",
"oakland",
"equity indicators",
"equity data",
"equity",
"racial equity reports",
"racial equity oakland"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.oaklandca.gov"
},
"permalink": "https://data.oaklandca.gov/stories/s/brb2-j4ad",
"link": "https://data.oaklandca.gov/stories/s/brb2-j4ad",
"owner": {
"id": "b6sx-5aq2",
"user_type": "interactive",
"display_name": "Kevin Donohue"
},
"creator": {
"id": "b6sx-5aq2",
"user_type": "interactive",
"display_name": "Kevin Donohue"
}
},
{
"resource": {
"name": "City of Oakland Proposed Policy Budget FY2013-15",
"id": "b8mb-8tti",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2015-03-16T16:04:01.000Z",
"createdAt": "2013-04-17T19:34:17.000Z",
"metadata_updated_at": "2015-03-16T16:04:01.000Z",
"data_updated_at": "2013-04-17T19:34:41.000Z",
"page_views": {
"page_views_last_week": 4,
"page_views_last_month": 19,
"page_views_total": 18055,
"page_views_last_week_log": 2.321928094887362,
"page_views_last_month_log": 4.321928094887363,
"page_views_total_log": 14.140190703191838
},
"columns_name": [
"Department",
"Division",
"Org Description",
"Fund Code",
"Account Category",
"Account Description",
"Account Type",
"Budget Year Name",
"Department Order",
"Account Code",
"… 5 more items"
],
"columns_field_name": [
"department",
"division",
"org_description",
"fund_code",
"account_category",
"account_description",
"account_type",
"budget_year_name",
"department_order",
"account_code",
"… 5 more items"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Number",
"Text",
"Text",
"Text",
"Text",
"Number",
"Number",
"… 5 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 5 more items"
],
"columns_format": [
{},
{},
{},
{
"precisionStyle": "standard",
"noCommas": "true",
"align": "right"
},
{},
{},
{},
{},
{},
{
"precisionStyle": "standard",
"noCommas": "true",
"align": "right"
},
"… 5 more items"
],
"download_count": 863,
"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": "2013-04-17T19:41:04.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Financial",
"domain_tags": [
"budget"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.oaklandca.gov"
},
"permalink": "https://data.oaklandca.gov/d/b8mb-8tti",
"link": "https://data.oaklandca.gov/Financial/City-of-Oakland-Proposed-Policy-Budget-FY2013-15/b8mb-8tti",
"owner": {
"id": "6tru-24hn",
"user_type": "interactive",
"display_name": "City of Oakland"
},
"creator": {
"id": "6tru-24hn",
"user_type": "interactive",
"display_name": "City of Oakland"
}
},
{
"resource": {
"name": "Oakland Crime Incidents Map (last 90 days)",
"id": "mrwt-jswm",
"resource_name": null,
"parent_fxf": [
"ym6k-rx7a"
],
"description": "",
"attribution": "Oakland Police Department",
"attribution_link": null,
"contact_email": null,
"type": "map",
"updatedAt": "2026-10-23T13:01:38.000Z",
"createdAt": "2018-07-13T18:34:26.000Z",
"metadata_updated_at": "2020-11-07T00:38:23.000Z",
"data_updated_at": "2026-10-23T13:01:38.000Z",
"page_views": {
"page_views_last_week": 375,
"page_views_last_month": 1190,
"page_views_total": 13689,
"page_views_last_week_log": 8.554588851677638,
"page_views_last_month_log": 10.217957697864113,
"page_views_total_log": 13.740834826145262
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 30,
"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": "2018-07-13T18:34:26.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Public Safety",
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.oaklandca.gov"
},
"permalink": "https://data.oaklandca.gov/d/mrwt-jswm",
"link": "https://data.oaklandca.gov/Public-Safety/Oakland-Crime-Incidents-Map-last-90-days-/mrwt-jswm",
"owner": {
"id": "nm3q-d5md",
"user_type": "interactive",
"display_name": "Bruce Stoffmacher"
},
"creator": {
"id": "nm3q-d5md",
"user_type": "interactive",
"display_name": "Bruce Stoffmacher"
}
},
"… 10 more items"
],
"resultSetSize": 739,
"timings": {
"serviceMillis": 23,
"searchMillis": [
11,
4
]
},
"warnings": []
}Attribution: Source: data.oaklandca.gov. Dataset attribution as stated by each publishing agency.
Licence: Datasets on this portal declare the licence "Creative Commons 1.0 Universal (Public Domain Dedication)" 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 data.oaklandca.gov (data-oaklandca-gov) 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 "data-oaklandca-gov" 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 data.oaklandca.gov (data-oaklandca-gov) 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=k5m5-tw4s. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-oaklandca-gov" 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 data.oaklandca.gov (data-oaklandca-gov) 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 "data-oaklandca-gov" 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 data.oaklandca.gov (data-oaklandca-gov) 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=k5m5-tw4s. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-oaklandca-gov" 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>