Skip to main content
fastcrw
All providersProvider terms
fastCRW Pergamon
Government

dubuque.data.socrata.com

dubuque.data.socrata.com

Socrata open data portal at dubuque.data.socrata.com, publishing 8 public datasets from the publishing organisation, led by the Demographics, Economy & Jobs category.

Showing the catalogue

1Request

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/dubuque-data-socrata-com/catalog-search?offset=0" \
  -H "Authorization: Bearer $FASTCRW_API_KEY"

2Response example

A sample shape. Press Run to see live data from dubuque.data.socrata.com.

resourceclassificationmetadatapermalinklinkownercreator
{"name":"Dubuque County Average Monthly Earnings By Quarter","id":"3yn3-duqc","resource_name":null,"parent_fxf":[],"description":"Dubuque County Average Monthly Earnings By Quarter from US Census Bureau","attribution":"United States Census Bureau","attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2017-09-29T13:49:14.000Z","createdAt":"2017-09-29T13:48:01.000Z","metadata_updated_at":"2017-09-29T13:49:14.000Z","data_updated_at":"2017-09-29T13:48:02.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":10,"page_views_total":677,"page_views_last_week_log":1,"page_views_last_month_log":3.4594316186372978,"page_views_total_log":9.405141463136344},"columns_name":["Quarter","Monthly Income"],"columns_field_name":["quarter","monthly_income"],"columns_datatype":["Text","Number"],"columns_description":["",""],"columns_format":[{},{"decimalSeparator":".","groupSeparator":","}],"download_count":656,"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":"2017-09-29T13:49:14.000Z"}{"categories":[],"tags":[],"domain_category":"Demographics, Economy & Jobs","domain_tags":["dubuque","earnings","census"],"domain_metadata":[{"key":"Updates_Agency","value":""},{"key":"Updates_Update-Notes","value":""},{"key":"Updates_Update-Frequency","value":""},{"key":"Updates_Update-Time-Period","value":""},{"key":"Coverage_Area","value":""},{"key":"Coverage_Time","value":""},{"key":"Disclaimers_Limitations","value":""},{"key":"Disclaimers_Completeness","value":""}]}{"domain":"dubuque.data.socrata.com"}https://dubuque.data.socrata.com/d/3yn3-duqchttps://dubuque.data.socrata.com/Demographics-Economy-Jobs/Dubuque-County-Average-Monthly-Earnings-By-Quarter/3yn3-duqc{"id":"9fdw-6h7n","user_type":"interactive","display_name":"Joe Pregler"}{"id":"9fdw-6h7n","user_type":"interactive","display_name":"Joe Pregler"}
{"name":"Iowa Public Health Data Sorted By Category","id":"2szx-whxk","resource_name":null,"parent_fxf":[],"description":"Iowa Public Health Data Sorted By Category","attribution":"Iowa Department of Public Health","attribution_link":null,"contact_email":null,"type":"href","updatedAt":"2017-09-28T19:31:18.000Z","createdAt":"2017-09-28T19:31:02.000Z","metadata_updated_at":"2017-09-28T19:31:18.000Z","data_updated_at":"2017-09-28T19:31:02.000Z","page_views":{"page_views_last_week":4,"page_views_last_month":20,"page_views_total":660,"page_views_last_week_log":2.321928094887362,"page_views_last_month_log":4.392317422778761,"page_views_total_log":9.36850646150769},"columns_name":[],"columns_field_name":[],"columns_datatype":[],"columns_description":[],"columns_format":[],"download_count":0,"provenance":"official","lens_view_type":"href","lens_display_type":"href","locked":false,"backend":"not_a_dataset","blob_mime_type":null,"hide_from_data_json":false,"publication_date":"2017-09-28T19:31:17.000Z"}{"categories":[],"tags":[],"domain_category":"Health, Environment & Community","domain_tags":["health","public","iowa"],"domain_metadata":[{"key":"Updates_Agency","value":""},{"key":"Updates_Update-Notes","value":""},{"key":"Updates_Update-Frequency","value":""},{"key":"Updates_Update-Time-Period","value":""},{"key":"Coverage_Area","value":""},{"key":"Coverage_Time","value":""},{"key":"Disclaimers_Limitations","value":""},{"key":"Disclaimers_Completeness","value":""}]}{"domain":"dubuque.data.socrata.com","access_points":{"unknown":"https://idph.iowa.gov/PublicHealthData/reports"}}https://dubuque.data.socrata.com/d/2szx-whxkhttps://dubuque.data.socrata.com/Health-Environment-Community/Iowa-Public-Health-Data-Sorted-By-Category/2szx-whxk{"id":"9fdw-6h7n","user_type":"interactive","display_name":"Joe Pregler"}{"id":"9fdw-6h7n","user_type":"interactive","display_name":"Joe Pregler"}
{"name":"Hero","id":"99qb-uxmx","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"file","updatedAt":"2022-10-31T15:10:57.000Z","createdAt":"2022-10-31T15:09:17.000Z","metadata_updated_at":"2022-10-31T15:10:57.000Z","data_updated_at":"2022-10-31T15:09:17.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":7,"page_views_total":579,"page_views_last_week_log":1,"page_views_last_month_log":3,"page_views_total_log":9.179909090014934},"columns_name":[],"columns_field_name":[],"columns_datatype":[],"columns_description":[],"columns_format":[],"download_count":6,"provenance":"official","lens_view_type":"blobby","lens_display_type":"blob","locked":false,"backend":"not_a_dataset","blob_mime_type":"image/jpeg","hide_from_data_json":false,"publication_date":"2022-10-31T15:10:57.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"dubuque.data.socrata.com"}https://dubuque.data.socrata.com/d/99qb-uxmxhttps://dubuque.data.socrata.com/dataset/Hero/99qb-uxmx{"id":"yfpq-ybtn","user_type":"interactive","display_name":"Colleen Schroeder"}{"id":"yfpq-ybtn","user_type":"interactive","display_name":"Colleen Schroeder"}
{"name":"Vendor Insurance Approvals","id":"ivu8-vnz7","resource_name":null,"parent_fxf":[],"description":"List of Vendor Insurance Approvals and relevant information","attribution":"City of Dubuque","attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2019-12-01T07:30:06.000Z","createdAt":"2017-09-27T16:24:25.000Z","metadata_updated_at":"2017-09-28T19:21:13.000Z","data_updated_at":"2019-12-01T07:30:06.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":12,"page_views_total":549,"page_views_last_week_log":1,"page_views_last_month_log":3.700439718141092,"page_views_total_log":9.103287808412022},"columns_name":["Agency","Vendor Name","Projected Start Date","Project Cost_Estimated","CIP Number/Project","Certificate Expiration Date","Reference No","Excavating Involved","Project Duration","Pollution/RR Protective Coverages","… 3 more items"],"columns_field_name":["agency","vendor_name","projected_start_date","project_cost_estimated","cip_number_project","certificate_expiration_date","reference_no","excavating_involved","project_duration","pollution_rr_protective_coverages","… 3 more items"],"columns_datatype":["Text","Text","Calendar date","Text","Text","Calendar date","Text","Text","Text","Text","… 3 more items"],"columns_description":["","","","","","","","","","","… 3 more items"],"columns_format":[{},{},{"view":"date_time"},{},{},{"view":"date_time"},{},{},{},{},"… 3 more items"],"download_count":666,"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":"2017-09-28T19:21:13.000Z"}{"categories":[],"tags":[],"domain_category":"City Administration","domain_tags":["vendor","approval","insurance"],"domain_metadata":[{"key":"Updates_Agency","value":"City of Dubuque"},{"key":"Updates_Update-Notes","value":"Updated Monthly on the 1st day of the month"},{"key":"Updates_Update-Frequency","value":"Monthly"},{"key":"Updates_Update-Time-Period","value":""},{"key":"Coverage_Area","value":""},{"key":"Coverage_Time","value":""},{"key":"Disclaimers_Limitations","value":""},{"key":"Disclaimers_Completeness","value":""}]}{"domain":"dubuque.data.socrata.com"}https://dubuque.data.socrata.com/d/ivu8-vnz7https://dubuque.data.socrata.com/City-Administration/Vendor-Insurance-Approvals/ivu8-vnz7{"id":"9fdw-6h7n","user_type":"interactive","display_name":"Joe Pregler"}{"id":"9fdw-6h7n","user_type":"interactive","display_name":"Joe Pregler"}
{"name":"Dubuque County Employment By Quarter","id":"tuep-i49a","resource_name":null,"parent_fxf":[],"description":"Dubuque County Employment Numbers By Quarter From Census","attribution":"United States Census Bureau","attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2017-09-29T13:37:04.000Z","createdAt":"2017-09-29T13:35:01.000Z","metadata_updated_at":"2017-09-29T13:37:04.000Z","data_updated_at":"2017-09-29T13:35:02.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":5,"page_views_total":536,"page_views_last_week_log":1,"page_views_last_month_log":2.584962500721156,"page_views_total_log":9.068778277985412},"columns_name":["Quarter","Employment"],"columns_field_name":["quarter","employment"],"columns_datatype":["Text","Number"],"columns_description":["",""],"columns_format":[{},{"decimalSeparator":".","groupSeparator":","}],"download_count":662,"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":"2017-09-29T13:37:04.000Z"}{"categories":[],"tags":[],"domain_category":"Demographics, Economy & Jobs","domain_tags":["employment","dubuque","county","census"],"domain_metadata":[{"key":"Updates_Agency","value":""},{"key":"Updates_Update-Notes","value":""},{"key":"Updates_Update-Frequency","value":""},{"key":"Updates_Update-Time-Period","value":""},{"key":"Coverage_Area","value":""},{"key":"Coverage_Time","value":""},{"key":"Disclaimers_Limitations","value":""},{"key":"Disclaimers_Completeness","value":""}]}{"domain":"dubuque.data.socrata.com"}https://dubuque.data.socrata.com/d/tuep-i49ahttps://dubuque.data.socrata.com/Demographics-Economy-Jobs/Dubuque-County-Employment-By-Quarter/tuep-i49a{"id":"9fdw-6h7n","user_type":"interactive","display_name":"Joe Pregler"}{"id":"9fdw-6h7n","user_type":"interactive","display_name":"Joe Pregler"}
{"name":"Health Vital Statistics of Iowa 2016","id":"vy4a-7pqw","resource_name":null,"parent_fxf":[],"description":"Health Vital Statistics of Iowa 2016 by state and by county","attribution":"Iowa Department of Public Health","attribution_link":null,"contact_email":null,"type":"href","updatedAt":"2018-02-07T19:15:51.000Z","createdAt":"2017-09-28T19:27:47.000Z","metadata_updated_at":"2018-02-07T19:15:51.000Z","data_updated_at":"2017-09-28T19:27:47.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":11,"page_views_total":444,"page_views_last_week_log":1,"page_views_last_month_log":3.5849625007211565,"page_views_total_log":8.79766152585376},"columns_name":[],"columns_field_name":[],"columns_datatype":[],"columns_description":[],"columns_format":[],"download_count":0,"provenance":"official","lens_view_type":"href","lens_display_type":"href","locked":false,"backend":"not_a_dataset","blob_mime_type":null,"hide_from_data_json":false,"publication_date":"2017-09-28T19:28:00.000Z"}{"categories":[],"tags":[],"domain_category":"Health, Environment & Community","domain_tags":["vital","statistics","health"],"domain_metadata":[]}{"domain":"dubuque.data.socrata.com","additional_access_points":[{"urls":{"pdf":"https://idph.iowa.gov/Portals/1/userfiles/68/HealthStats/vital_stats_2016-20171211.pdf"}}],"access_points":{"pdf":"https://idph.iowa.gov/Portals/1/userfiles/68/HealthStats/vital_stats_2016-20171211.pdf"}}https://dubuque.data.socrata.com/d/vy4a-7pqwhttps://dubuque.data.socrata.com/Health-Environment-Community/Health-Vital-Statistics-of-Iowa-2016/vy4a-7pqw{"id":"9fdw-6h7n","user_type":"interactive","display_name":"Joe Pregler"}{"id":"9fdw-6h7n","user_type":"interactive","display_name":"Joe Pregler"}
{"name":"2014 Radon Data by Zip Code","id":"kdfa-9j2r","resource_name":null,"parent_fxf":[],"description":"2014 Radon Data by Zip Code","attribution":"Iowa Department of Public Health","attribution_link":null,"contact_email":null,"type":"href","updatedAt":"2017-09-28T19:21:47.000Z","createdAt":"2017-09-28T19:16:45.000Z","metadata_updated_at":"2017-09-28T19:21:47.000Z","data_updated_at":"2017-09-28T19:16:45.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":9,"page_views_total":427,"page_views_last_week_log":1,"page_views_last_month_log":3.3219280948873626,"page_views_total_log":8.741466986401146},"columns_name":[],"columns_field_name":[],"columns_datatype":[],"columns_description":[],"columns_format":[],"download_count":0,"provenance":"official","lens_view_type":"href","lens_display_type":"href","locked":false,"backend":"not_a_dataset","blob_mime_type":null,"hide_from_data_json":false,"publication_date":"2017-09-28T19:21:47.000Z"}{"categories":[],"tags":[],"domain_category":"Health, Environment & Community","domain_tags":["radon"],"domain_metadata":[{"key":"Updates_Agency","value":""},{"key":"Updates_Update-Notes","value":""},{"key":"Updates_Update-Frequency","value":""},{"key":"Updates_Update-Time-Period","value":""},{"key":"Coverage_Area","value":""},{"key":"Coverage_Time","value":""},{"key":"Disclaimers_Limitations","value":""},{"key":"Disclaimers_Completeness","value":""}]}{"domain":"dubuque.data.socrata.com","access_points":{"csv":"https://idph.iowa.gov/Portals/1/userfiles/97/Radon_ZipCode_2014.csv"}}https://dubuque.data.socrata.com/d/kdfa-9j2rhttps://dubuque.data.socrata.com/Health-Environment-Community/2014-Radon-Data-by-Zip-Code/kdfa-9j2r{"id":"9fdw-6h7n","user_type":"interactive","display_name":"Joe Pregler"}{"id":"9fdw-6h7n","user_type":"interactive","display_name":"Joe Pregler"}
{"name":"test","id":"u3ek-hyct","resource_name":null,"parent_fxf":["3yn3-duqc"],"description":"","attribution":"United States Census Bureau","attribution_link":null,"contact_email":null,"type":"filter","updatedAt":"2024-07-20T13:52:11.000Z","createdAt":"2024-07-20T13:51:54.000Z","metadata_updated_at":"2024-07-20T13:52:11.000Z","data_updated_at":"2017-09-29T13:48:02.000Z","page_views":{"page_views_last_week":0,"page_views_last_month":0,"page_views_total":57,"page_views_last_week_log":0,"page_views_last_month_log":0,"page_views_total_log":5.857980995127572},"columns_name":["Quarter","Monthly Income"],"columns_field_name":["quarter","monthly_income"],"columns_datatype":["Text","Number"],"columns_description":["",""],"columns_format":[{},{"decimalSeparator":".","groupSeparator":","}],"download_count":34,"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":"2024-07-20T13:52:10.000Z"}{"categories":[],"tags":[],"domain_category":"Demographics, Economy & Jobs","domain_tags":[],"domain_metadata":[]}{"domain":"dubuque.data.socrata.com"}https://dubuque.data.socrata.com/d/u3ek-hycthttps://dubuque.data.socrata.com/Demographics-Economy-Jobs/test/u3ek-hyct{"id":"6xuc-er95","user_type":"interactive","display_name":"ricochet"}{"id":"6xuc-er95","user_type":"interactive","display_name":"ricochet"}

Attribution: Source: dubuque.data.socrata.com. Dataset attribution as stated by each publishing agency.

Licence: No licence is declared in the dataset metadata this portal exposes through its catalogue API. No reuse grant is made here: commercial use and redistribution are recorded as false and no rights are claimed over the upstream data.

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 dubuque.data.socrata.com (dubuque-data-socrata-com) 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 "dubuque-data-socrata-com" 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 dubuque.data.socrata.com (dubuque-data-socrata-com) 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=3yn3-duqc. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "dubuque-data-socrata-com" 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 dubuque.data.socrata.com (dubuque-data-socrata-com) 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 "dubuque-data-socrata-com" 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 dubuque.data.socrata.com (dubuque-data-socrata-com) 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=3yn3-duqc. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "dubuque-data-socrata-com" 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>