johnstonia.data.socrata.com
johnstonia.data.socrata.com
Socrata open data portal at johnstonia.data.socrata.com, publishing 7 public datasets from the publishing organisation.
GET /v1/data/johnstonia-data-socrata-com/catalog-search1Request
Full-text query over dataset names and descriptions.
Zero-based offset into the results; step by 20 to page.
curl "https://api.fastcrw.com/v1/data/johnstonia-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 johnstonia.data.socrata.com.
| resource | classification | metadata | permalink | link | owner | creator |
|---|---|---|---|---|---|---|
| {"name":"Expenditures","id":"mk2i-qbx9","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2024-02-11T03:45:19.000Z","createdAt":"2019-04-02T21:07:45.000Z","metadata_updated_at":"2024-02-11T03:45:11.000Z","data_updated_at":"2024-02-11T03:45:19.000Z","page_views":{"page_views_last_week":0,"page_views_last_month":2,"page_views_total":198,"page_views_last_week_log":0,"page_views_last_month_log":1.5849625007211563,"page_views_total_log":7.636624620543649},"columns_name":["description","vendor_id","fiscal_period","department","date","invoice_id","payment_check_number","vendor_name","expense_catagory","payment_method","… 4 more items"],"columns_field_name":["description","vendor_id","fiscal_period","department","date","invoice_id","payment_check_number","vendor_name","expense_catagory","payment_method","… 4 more items"],"columns_datatype":["Text","Text","Number","Text","Calendar date","Text","Text","Text","Text","Text","… 4 more items"],"columns_description":["","","","","","","","","","","… 4 more items"],"columns_format":[{},{},{},{},{},{},{},{},{},{},"… 4 more items"],"download_count":51,"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":"2019-04-23T18:04:00.000Z"} | {"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]} | {"domain":"johnstonia.data.socrata.com"} | https://johnstonia.data.socrata.com/d/mk2i-qbx9 | https://johnstonia.data.socrata.com/dataset/Expenditures/mk2i-qbx9 | {"id":"trc9-69xh","user_type":"interactive","display_name":"Socrata (DoNotDelete)"} | {"id":"trc9-69xh","user_type":"interactive","display_name":"Socrata (DoNotDelete)"} |
| {"name":"Payroll","id":"6maz-ry8d","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2024-02-10T23:58:02.000Z","createdAt":"2019-04-02T21:07:45.000Z","metadata_updated_at":"2024-02-10T23:58:00.000Z","data_updated_at":"2024-02-10T23:58:02.000Z","page_views":{"page_views_last_week":0,"page_views_last_month":4,"page_views_total":185,"page_views_last_week_log":0,"page_views_last_month_log":2.321928094887362,"page_views_total_log":7.539158811108032},"columns_name":["pay_benefits_actual","pay_base_actual","pay_total_actual","pay_other_actual","projected_total","position_title","service_end_date","employee_id","transaction_date","year","… 6 more items"],"columns_field_name":["pay_benefits_actual","pay_base_actual","pay_total_actual","pay_other_actual","projected_total","position_title","service_end_date","employee_id","transaction_date","year","… 6 more items"],"columns_datatype":["Number","Number","Number","Number","Number","Text","Text","Text","Text","Text","… 6 more items"],"columns_description":["","","","","","","","","","","… 6 more items"],"columns_format":[{},{},{},{},{},{},{},{},{},{},"… 6 more items"],"download_count":62,"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":"2019-04-23T18:15:15.000Z"} | {"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]} | {"domain":"johnstonia.data.socrata.com"} | https://johnstonia.data.socrata.com/d/6maz-ry8d | https://johnstonia.data.socrata.com/dataset/Payroll/6maz-ry8d | {"id":"trc9-69xh","user_type":"interactive","display_name":"Socrata (DoNotDelete)"} | {"id":"trc9-69xh","user_type":"interactive","display_name":"Socrata (DoNotDelete)"} |
| {"name":"Vendors","id":"vhvu-nphn","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2024-02-10T20:24:21.000Z","createdAt":"2019-04-02T21:07:45.000Z","metadata_updated_at":"2024-02-10T20:24:20.000Z","data_updated_at":"2024-02-10T20:24:21.000Z","page_views":{"page_views_last_week":0,"page_views_last_month":3,"page_views_total":182,"page_views_last_week_log":0,"page_views_last_month_log":2,"page_views_total_log":7.515699838284044},"columns_name":["vendor_name","vendor_city","vendor_catagory","vendor_zip","vendor_id","vendor_address_1","vendor_state","vendor_contact_name","vendor_address_2","vendor_phone","… 3 more items"],"columns_field_name":["vendor_name","vendor_city","vendor_catagory","vendor_zip","vendor_id","vendor_address_1","vendor_state","vendor_contact_name","vendor_address_2","vendor_phone","… 3 more items"],"columns_datatype":["Text","Text","Text","Text","Text","Text","Text","Text","Text","Text","… 3 more items"],"columns_description":["","","","","","","","","","","… 3 more items"],"columns_format":[{},{},{},{},{},{},{},{},{},{},"… 3 more items"],"download_count":62,"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":"2019-04-02T21:07:59.000Z"} | {"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]} | {"domain":"johnstonia.data.socrata.com"} | https://johnstonia.data.socrata.com/d/vhvu-nphn | https://johnstonia.data.socrata.com/dataset/Vendors/vhvu-nphn | {"id":"trc9-69xh","user_type":"interactive","display_name":"Socrata (DoNotDelete)"} | {"id":"trc9-69xh","user_type":"interactive","display_name":"Socrata (DoNotDelete)"} |
| {"name":"Budgeted Expenses","id":"pkdw-7uz7","resource_name":"incode_9_budgeted_expenses","parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2024-04-02T21:35:16.000Z","createdAt":"2019-04-02T21:07:45.000Z","metadata_updated_at":"2024-04-02T21:35:16.000Z","data_updated_at":"2024-02-10T21:06:39.000Z","page_views":{"page_views_last_week":2,"page_views_last_month":4,"page_views_total":180,"page_views_last_week_log":1.5849625007211563,"page_views_last_month_log":2.321928094887362,"page_views_total_log":7.499845887083206},"columns_name":["fiscal_year","fund","description","approved_amount","recommended_amount","department","actual_amount"],"columns_field_name":["fiscal_year","fund","description","approved_amount","recommended_amount","department","actual_amount"],"columns_datatype":["Number","Text","Text","Number","Number","Text","Number"],"columns_description":["","","","","","",""],"columns_format":[{},{},{},{},{},{},{}],"download_count":60,"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":"2019-04-23T18:25:36.000Z"} | {"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]} | {"domain":"johnstonia.data.socrata.com"} | https://johnstonia.data.socrata.com/d/pkdw-7uz7 | https://johnstonia.data.socrata.com/dataset/Budgeted-Expenses/pkdw-7uz7 | {"id":"trc9-69xh","user_type":"interactive","display_name":"Socrata (DoNotDelete)"} | {"id":"trc9-69xh","user_type":"interactive","display_name":"Socrata (DoNotDelete)"} |
| {"name":"Budgeted Revenues","id":"yrcb-xajq","resource_name":"incode_9_budgeted_revenues","parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2024-04-02T21:35:07.000Z","createdAt":"2019-04-02T21:07:45.000Z","metadata_updated_at":"2024-04-02T21:35:07.000Z","data_updated_at":"2024-02-11T09:11:15.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":1,"page_views_total":169,"page_views_last_week_log":1,"page_views_last_month_log":1,"page_views_total_log":7.409390936137703},"columns_name":["description","approved_amount","department","recommended_amount","fund","actual_amount","fiscal_year"],"columns_field_name":["description","approved_amount","department","recommended_amount","fund","actual_amount","fiscal_year"],"columns_datatype":["Text","Number","Text","Number","Text","Number","Number"],"columns_description":["","","","","","",""],"columns_format":[{},{},{},{},{},{},{}],"download_count":52,"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":"2019-04-23T18:24:51.000Z"} | {"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]} | {"domain":"johnstonia.data.socrata.com"} | https://johnstonia.data.socrata.com/d/yrcb-xajq | https://johnstonia.data.socrata.com/dataset/Budgeted-Revenues/yrcb-xajq | {"id":"trc9-69xh","user_type":"interactive","display_name":"Socrata (DoNotDelete)"} | {"id":"trc9-69xh","user_type":"interactive","display_name":"Socrata (DoNotDelete)"} |
| {"name":"City of Johnston 2020 Wages","id":"bnpy-rq5z","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"file","updatedAt":"2021-08-10T22:41:51.000Z","createdAt":"2019-10-10T19:12:53.000Z","metadata_updated_at":"2021-08-10T22:41:51.000Z","data_updated_at":"2019-10-10T19:12:53.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":1,"page_views_total":127,"page_views_last_week_log":1,"page_views_last_month_log":1,"page_views_total_log":7},"columns_name":[],"columns_field_name":[],"columns_datatype":[],"columns_description":[],"columns_format":[],"download_count":127,"provenance":"official","lens_view_type":"blobby","lens_display_type":"blob","locked":false,"backend":"not_a_dataset","blob_mime_type":"application/pdf","hide_from_data_json":false,"publication_date":"2019-10-10T19:15:01.000Z"} | {"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]} | {"domain":"johnstonia.data.socrata.com"} | https://johnstonia.data.socrata.com/d/bnpy-rq5z | https://johnstonia.data.socrata.com/dataset/City-of-Johnston-2020-Wages/bnpy-rq5z | {"id":"yq4y-w7ef","user_type":"interactive","display_name":"Glenn Newcomb"} | {"id":"yq4y-w7ef","user_type":"interactive","display_name":"Glenn Newcomb"} |
| {"name":"test","id":"rctc-r7ue","resource_name":null,"parent_fxf":["mk2i-qbx9"],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"filter","updatedAt":"2024-07-20T13:58:38.000Z","createdAt":"2024-07-20T13:58:21.000Z","metadata_updated_at":"2024-07-20T13:58:38.000Z","data_updated_at":"2024-02-11T03:45:19.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":1,"page_views_total":52,"page_views_last_week_log":1,"page_views_last_month_log":1,"page_views_total_log":5.7279204545632},"columns_name":["entry_type","vendor_name","vendor_id","payment_status","payment_method","payment_check_number","invoice_id","fiscal_year","fiscal_period","expense_catagory","… 4 more items"],"columns_field_name":["entry_type","vendor_name","vendor_id","payment_status","payment_method","payment_check_number","invoice_id","fiscal_year","fiscal_period","expense_catagory","… 4 more items"],"columns_datatype":["Text","Text","Text","Text","Text","Text","Text","Number","Number","Text","… 4 more items"],"columns_description":["","","","","","","","","","","… 4 more items"],"columns_format":[{},{},{},{},{},{},{},{},{},{},"… 4 more items"],"download_count":13,"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:58:37.000Z"} | {"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]} | {"domain":"johnstonia.data.socrata.com"} | https://johnstonia.data.socrata.com/d/rctc-r7ue | https://johnstonia.data.socrata.com/dataset/test/rctc-r7ue | {"id":"6xuc-er95","user_type":"interactive","display_name":"ricochet"} | {"id":"6xuc-er95","user_type":"interactive","display_name":"ricochet"} |
Attribution: Source: johnstonia.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 johnstonia.data.socrata.com (johnstonia-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 "johnstonia-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 johnstonia.data.socrata.com (johnstonia-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=vhvu-nphn. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "johnstonia-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 johnstonia.data.socrata.com (johnstonia-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 "johnstonia-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 johnstonia.data.socrata.com (johnstonia-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=vhvu-nphn. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "johnstonia-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>