Skip to main content
All providers

gnb.socrata.com

Open data portals

gnb.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 credit

Keyword 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.

q?offset?order?only?categories?tags?domain_category?
GET /v1/data/gnb-socrata-com/dataset1 credit

The 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.

id
GET /v1/data/gnb-socrata-com/datasets1 credit

A page of the portal's own dataset records (id, name, description, category, attribution, creation and update timestamps, view count) without the full column metadata.

offset?order?category?
GET /v1/data/gnb-socrata-com/row-count1 credit

One number: how many rows the dataset currently holds, as a SoQL count aggregate.

id
GET /v1/data/gnb-socrata-com/rows1 credit

The 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.

id

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.

JSON
{
  "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