mischooldata.data.socrata.com
Governmentmischooldata.data.socrata.com
Socrata open data portal at mischooldata.data.socrata.com, publishing 42 public datasets from the publishing organisation, led by the Education category.
The crw MCP on your computer calls mischooldata.data.socrata.com directly. Calls cost no credits and the data does not pass through fastCRW. Install it once for Claude Code, Cursor, Codex, Windsurf, Gemini CLI or OpenCode, with your fastCRW API key in place of the placeholder:
Capabilities (5)
mischooldata-data-socrata-com/catalog-searchFree, runs locallyKeyword search over the datasets published on mischooldata.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.
mischooldata-data-socrata-com/datasetFree, runs locallyThe 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.
mischooldata-data-socrata-com/datasetsFree, runs locallyA page of the portal's own dataset records (id, name, description, category, attribution, creation and update timestamps, view count) without the full column metadata.
mischooldata-data-socrata-com/row-countFree, runs locallyOne number: how many rows the dataset currently holds, as a SoQL count aggregate.
mischooldata-data-socrata-com/rowsFree, runs locallyThe 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 mischooldata-data-socrata-com/catalog-search (Catalogue search). A sample, not live data.
Example truncated, full shape in JSON from the API.
{
"results": [
{
"resource": {
"name": "Entities",
"id": "t8xw-4gtw",
"resource_name": null,
"parent_fxf": [],
"description": "Michigan Schools",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2018-02-21T17:00:33.000Z",
"createdAt": "2017-08-16T19:39:33.000Z",
"metadata_updated_at": "2018-02-21T16:59:42.000Z",
"data_updated_at": "2018-02-21T17:00:33.000Z",
"page_views": {
"page_views_last_week": 2,
"page_views_last_month": 9,
"page_views_total": 2679,
"page_views_last_week_log": 1.5849625007211563,
"page_views_last_month_log": 3.3219280948873626,
"page_views_total_log": 11.388017285345136
},
"columns_name": [
"Location",
"PlaceFIPS",
"Shape",
"SecondaryName",
"TypeDescription",
"Type",
"SquareMiles",
"ODNFIPS",
"Name",
"ID",
"… 2 more items"
],
"columns_field_name": [
"location",
"placefips",
"shape",
"secondaryname",
"typedescription",
"type",
"squaremiles",
"odnfips",
"name",
"id",
"… 2 more items"
],
"columns_datatype": [
"Point",
"Text",
"MultiPolygon",
"Text",
"Text",
"Text",
"Number",
"Text",
"Text",
"Text",
"… 2 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"Unique ID",
"… 2 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{},
{
"displayStyle": "plain",
"align": "left"
},
"… 2 more items"
],
"download_count": 1242,
"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-11-14T05:13:09.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [
"local units",
"school districts"
],
"domain_metadata": []
},
"metadata": {
"domain": "mischooldata.data.socrata.com"
},
"permalink": "https://mischooldata.data.socrata.com/d/t8xw-4gtw",
"link": "https://mischooldata.data.socrata.com/dataset/Entities/t8xw-4gtw",
"owner": {
"id": "7krv-k7t3",
"user_type": "interactive",
"display_name": "Alicia Brown"
},
"creator": {
"id": "7krv-k7t3",
"user_type": "interactive",
"display_name": "Alicia Brown"
}
},
{
"resource": {
"name": "Pupil Enrollment",
"id": "nap3-cnry",
"resource_name": null,
"parent_fxf": [
"djkj-f7pd",
"kvct-vj2r",
"evgm-i5yw",
"8d99-bt4t",
"j7qj-y2vq"
],
"description": "Broken down by gender, ethnicity, and grade",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2016-10-14T17:47:59.048Z",
"createdAt": "2016-10-13T20:28:24.000Z",
"metadata_updated_at": "2016-10-14T17:47:59.000Z",
"data_updated_at": "2016-10-14T17:47:59.048Z",
"page_views": {
"page_views_last_week": 4,
"page_views_last_month": 22,
"page_views_total"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 mischooldata.data.socrata.com (mischooldata-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 "mischooldata-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 mischooldata.data.socrata.com (mischooldata-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=t8xw-4gtw. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "mischooldata-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 mischooldata.data.socrata.com (mischooldata-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 "mischooldata-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 mischooldata.data.socrata.com (mischooldata-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=t8xw-4gtw. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "mischooldata-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
You agree not to use for commercial purposes, or resell, or allow your employees, agents, or contractors to use for commercial purposes or resell any of the data derived from this website unless you have been specifically allowed to do so in a separate, written agreement with the State of Michigan, or other State of Michigan agency or department-specific terms provided with such data allow you to do.
https://www.michigan.gov/som/footer/policiesAttribution
Display this wherever you show the data. It arrives on every response as provenance.attributionText.
Source: mischooldata.data.socrata.com. Dataset attribution as stated by each publishing agency.