gnb.socrata.com
Open data portalsgnb.socrata.com
Socrata open data portal at gnb.socrata.com, publishing 693 public datasets from the publishing organisation, led by the Quarterly Datasets category.
Capabilities (5)
GET /v1/data/gnb-socrata-com/catalog-search1 creditKeyword search over the datasets published on gnb.socrata.com: 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/gnb-socrata-com/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/gnb-socrata-com/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/gnb-socrata-com/row-count1 creditOne number: how many rows the dataset currently holds, as a SoQL count aggregate.
GET /v1/data/gnb-socrata-com/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 gnb-socrata-com/catalog-search (Catalogue search). A sample, not live data.
Example truncated, full shape in JSON from the API.
{
"results": [
{
"resource": {
"name": "2024 - Public Accounts - Comptes publics",
"id": "wx36-5q5c",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2024-12-16T12:37:01.061Z",
"createdAt": "2024-11-12T14:15:41.000Z",
"metadata_updated_at": "2024-12-17T12:25:47.000Z",
"data_updated_at": "2024-12-16T12:37:01.061Z",
"page_views": {
"page_views_last_week": 82,
"page_views_last_month": 330,
"page_views_total": 364617,
"page_views_last_week_log": 6.375039431346925,
"page_views_last_month_log": 8.370687406807217,
"page_views_total_log": 18.476026258714942
},
"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": "2024-12-16T12:37:01.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "gnb.socrata.com"
},
"permalink": "https://gnb.socrata.com/stories/s/wx36-5q5c",
"link": "https://gnb.socrata.com/stories/s/wx36-5q5c",
"owner": {
"id": "66qi-73dz",
"user_type": "interactive",
"display_name": "Open Data NB \\ Données ouvertes NB"
},
"creator": {
"id": "66qi-73dz",
"user_type": "interactive",
"display_name": "Open Data NB \\ Données ouvertes NB"
}
},
{
"resource": {
"name": "Senior Executive Expenses 2020-21 Q4 / Frais de déplacement et autres dépenses de l'exécutif supérieur 2020-2021 T4",
"id": "y2uk-apy8",
"resource_name": null,
"parent_fxf": [],
"description": "In an effort to ensure transparency and accountability, the Government of New Brunswick is providing quarterly expense information pertaining to senior executive travel and other expenses in an open data format.\nReported expenses include amounts reimbursed through the travel claim process and do not include constituency office expenses.\nExpense categories include:\n· transportation\n· allowances\n· lodging and meals\n· other expenses (business meetings, incidental travel, etc.)\n\nSenior executive expenses will be reported in a department where the individual was assigned during the quarter.\nTo view departmental expenses, click on “View Data” and then click on “More Views”.\n/\nÀ des fins de transparence et de responsabilisation, le gouvernement du Nouveau-Brunswick fournit de l’information sur les dépenses trimestrielles des cadres supérieurs, notamment les frais de déplacement et autres dépenses, dans un format de données ouvertes.\nLes dépenses déclarées comprennent les montants remboursés au moyen du processus de demande de remboursement des frais de déplacement et ne comprennent pas les dépenses des bureaux de circonscription.\nLes catégories des dépenses sont les suivantes :\n· transport;\n· allocations;\n· hébergement et repas;\n· autres dépenses (réunions d’affaires, frais accessoires de déplacement, etc.).\nLes dépenses seront déclarées dans l’information du ministère où les cadres supérieurs étaient affectés pendant le trimestre.\nPour afficher les dépenses du ministérielles cliquez sur « Voir données », puis sur « Plus de vues ».",
"attribution": "Finance and Treasury Board / Finances et Conseil du Trésor",
"attribution_link": null,
"contact_email": null,
"type":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 gnb.socrata.com (gnb-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 "gnb-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 gnb.socrata.com (gnb-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=ns3f-a88z. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "gnb-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 gnb.socrata.com (gnb-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 "gnb-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 gnb.socrata.com (gnb-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=ns3f-a88z. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "gnb-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>
Licence
Datasets on this portal declare the licence "New Brunswick Open Government Licence" 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://gnb.socrata.com/Attribution
Display this wherever you show the data. It arrives on every response as provenance.attribution_text.
Source: gnb.socrata.com. Dataset attribution as stated by each publishing agency.
Cache: up to 3600s
