data.cincinnati-oh.gov
Open data portalsUSdata.cincinnati-oh.gov
Socrata open data portal at data.cincinnati-oh.gov, publishing 140 public datasets from the publishing organisation, led by the Thriving Neighborhoods category.
Capabilities (5)
GET /v1/data/data-cincinnati-oh-gov/catalog-search1 creditKeyword search over the datasets published on data.cincinnati-oh.gov: each hit carries the dataset id, name, description, attribution, category, tags, column names and last update time, plus the total match count.
GET /v1/data/data-cincinnati-oh-gov/dataset1 creditThe complete metadata document for one dataset: name, description, attribution, licence, category, tags, all column definitions with data types, and the table id used for queries.
GET /v1/data/data-cincinnati-oh-gov/datasets1 creditA page of the portal's own dataset records (id, name, description, category, attribution, creation and update timestamps, view count) without the full column metadata.
GET /v1/data/data-cincinnati-oh-gov/row-count1 creditOne number: how many rows the dataset currently holds, as a SoQL count aggregate.
GET /v1/data/data-cincinnati-oh-gov/rows1 creditThe first 100 rows of a dataset as JSON objects keyed by field name. Column names are the API field names, so they can be used directly in a later SoQL query.
Response example
The shape of data from data-cincinnati-oh-gov/catalog-search (Catalogue search). A sample, not live data.
Example truncated, full shape in JSON from the API.
{
"results": [
{
"resource": {
"name": "Business Opportunities (Archived)",
"id": "pid3-z56k",
"resource_name": null,
"parent_fxf": [],
"description": "This data set contains all business opportunities posted from 09/15/2015 - 12/31/2020. \n\nBusiness Opportunities has moved to https://www.cincinnati-oh.gov/noncms/cmgr/business-opportunities/. Please update any browser bookmarks and contact our office at (513) 352-3209 if you have questions.\n\nOfferors may register as a City vendor online at https://vss.cincinnati-oh.gov/vssprod/Advantage4.\n\nThe City publishes information on the City of Cincinnati Internet web site at www.cincinnati-oh.gov, which includes the Cincinnati Municipal Code (CMC) and the information concerning the rules and regulations governing the City’s Small Business Enterprise (SBE) Program and Minority/Women Business Enterprise (M/WBE) Program.",
"attribution": "City of Cincinnati Division of Purchasing",
"attribution_link": "https://www.cincinnati-oh.gov/purchasing/",
"contact_email": null,
"type": "dataset",
"updatedAt": "2022-05-27T13:15:17.000Z",
"createdAt": "2021-03-11T22:40:35.000Z",
"metadata_updated_at": "2022-05-27T13:15:17.000Z",
"data_updated_at": "2021-09-30T21:18:41.000Z",
"page_views": {
"page_views_last_week": 264,
"page_views_last_month": 1233,
"page_views_total": 326297,
"page_views_last_week_log": 8.049848549450562,
"page_views_last_month_log": 10.26912667914942,
"page_views_total_log": 18.31583061908717
},
"columns_name": [
"Supporting Doc 2 (PDF)",
"Addendum 1 (PDF)",
"Addendum 8 (PDF)",
"Addendum 9 (PDF)",
"Addendum 10 (PDF)",
"Addendum 11(pdf)",
"Bid Tabs",
"Plan Holders List (PDF)",
"Awarded Contract (PDF)",
"Awarded Contract 2 (PDF)",
"… 28 more items"
],
"columns_field_name": [
"supporting_doc_2_pdf",
"addendum_1_pdf",
"addendum_8_pdf",
"addendum_9_pdf",
"addendum_10_pdf",
"addendum_11_pdf",
"bid_tabs",
"plan_holders_list_pdf",
"awarded_contract_pdf",
"awarded_contract_2_pdf",
"… 28 more items"
],
"columns_datatype": [
"URL",
"URL",
"URL",
"URL",
"URL",
"URL",
"URL",
"URL",
"URL",
"URL",
"… 28 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 28 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
"… 28 more items"
],
"download_count": 45964,
"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-03-12T12:57:52.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "fiscal sustainability",
"domain_tags": [
"contracts",
"mbe",
"opportunity",
"purchasing",
"business",
"sbe",
"service",
"archive",
"bidding",
"bids",
"… 3 more items"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.cincinnati-oh.gov",
"license": "Public Domain"
},
"permalink": "https://data.cincinnati-oh.gov/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.cincinnati-oh.gov (data-cincinnati-oh-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-cincinnati-oh-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.cincinnati-oh.gov (data-cincinnati-oh-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=y8vb-stgi. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-cincinnati-oh-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.cincinnati-oh.gov (data-cincinnati-oh-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-cincinnati-oh-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.cincinnati-oh.gov (data-cincinnati-oh-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=y8vb-stgi. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-cincinnati-oh-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>
Licence
Datasets on this portal declare the licence "Public Domain" 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.
https://data.cincinnati-oh.gov/Attribution
Display this wherever you show the data. It arrives on every response as provenance.attribution_text.
Source: data.cincinnati-oh.gov. Dataset attribution as stated by each publishing agency.
Cache: up to 3600s
