nih-ncats.data.socrata.com
Open data portalsnih-ncats.data.socrata.com
Socrata open data portal at nih-ncats.data.socrata.com, publishing 7 public datasets from the publishing organisation.
Capabilities (5)
GET /v1/data/nih-ncats-data-socrata-com/catalog-search1 creditKeyword search over the datasets published on nih-ncats.data.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/nih-ncats-data-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/nih-ncats-data-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/nih-ncats-data-socrata-com/row-count1 creditOne number: how many rows the dataset currently holds, as a SoQL count aggregate.
GET /v1/data/nih-ncats-data-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 nih-ncats-data-socrata-com/catalog-search (Catalogue search). A sample, not live data.
Example truncated, full shape in JSON from the API.
{
"results": [
{
"resource": {
"name": "N3C Contributing Sites",
"id": "igwk-ne47",
"resource_name": null,
"parent_fxf": [],
"description": "Institutions that contribute electronic health record data to the N3C Data Enclave, with their location, institution type, the common data model they submit in, and the status of their data. Also includes the community health clinics of the OCHIN network, whose data is pending.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-16T18:59:51.000Z",
"createdAt": "2026-10-16T18:17:00.000Z",
"metadata_updated_at": "2026-10-16T18:59:51.000Z",
"data_updated_at": "2026-10-16T18:30:06.000Z",
"page_views": {
"page_views_last_week": 12,
"page_views_last_month": 12,
"page_views_total": 12,
"page_views_last_week_log": 3.700439718141092,
"page_views_last_month_log": 3.700439718141092,
"page_views_total_log": 3.700439718141092
},
"columns_name": [
"site_type",
"organization_id",
"site",
"status",
"data_model",
"network",
"website",
"location",
"longitude",
"latitude"
],
"columns_field_name": [
"site_type",
"organization_id",
"site",
"status",
"data_model",
"network",
"website",
"location",
"longitude",
"latitude"
],
"columns_datatype": [
"Text",
"URL",
"Text",
"Text",
"Text",
"Text",
"URL",
"Point",
"Number",
"Number"
],
"columns_description": [
"CTSA hub (NIH Clinical and Translational Science Award), IDeA-CTR (IDeA Clinical and Translational Research program), Regional, Unaffiliated, or OCHIN clinic.",
"Research Organization Registry (ROR) ID, where known. ",
"Research Organization Registry (ROR) ID, where known.",
"Available (data in the Enclave), Submitted (sent, not yet available), or Pending.",
"Common data model the site submits in: OMOP, PCORnet, TriNetX, or ACT. Empty while data is pending.",
"N3C for direct data partners, OCHIN for clinics of the OCHIN network.",
"Institution website, where known.",
"",
" Longitude | Number | Site",
"Site latitude"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
}
],
"download_count": 0,
"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": "2026-10-16T18:30:16.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "nih-ncats.data.socrata.com"
},
"permalink": "https://nih-ncats.data.socrata.com/d/igwk-ne47",
"link": "https://nih-ncats.data.socrata.com/dataset/N3C-Contributing-Sites/igwk-ne47",
"owner": {
"id": "khxs-y4ru",
"user_type": "interactive",
"display_name": "Aaron"
},
"creator": {
"id": "khxs-y4ru",
"user_type": "interactive",
"display_name": "Aaron"
}
},
{
"resource": {
"name": "odp-demo-screening.csv",
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 nih-ncats.data.socrata.com (nih-ncats-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 "nih-ncats-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 nih-ncats.data.socrata.com (nih-ncats-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=igwk-ne47. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "nih-ncats-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 nih-ncats.data.socrata.com (nih-ncats-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 "nih-ncats-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 nih-ncats.data.socrata.com (nih-ncats-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=igwk-ne47. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "nih-ncats-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>
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.
https://nih-ncats.data.socrata.com/Attribution
Display this wherever you show the data. It arrives on every response as provenance.attribution_text.
Source: nih-ncats.data.socrata.com. Dataset attribution as stated by each publishing agency.
Cache: up to 3600s
