# US Education Data API (`lentic_clockss/us-education-search`) Actor Search 16 US education data sources — College Scorecard costs & earnings, CUNY/SUNY enrollment, K-12 assessment scores, graduation rates, school expenditures, and graduate outcomes. Covers federal and state-level data from CT, DE, MA, NY, TX, WA, and CO via SIP Public Data Gateway. - **URL**: https://apify.com/lentic\_clockss/us-education-search.md - **Developed by:** [kane liu](https://apify.com/lentic_clockss) (community) - **Categories:** Lead generation, MCP servers - **Stats:** 1 total users, 0 monthly users, 0.0% runs succeeded, NaN bookmarks - **User rating**: No ratings yet ## Pricing Pay per usage This Actor is paid per platform usage. The Actor is free to use, and you only pay for the Apify platform usage, which gets cheaper the higher subscription plan you have. Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-usage ## What's an Apify Actor? Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases. In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours, and optionally produces a well-defined JSON output, datasets with results, or files in key-value store. In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server. Actors are written with capital "A". ## How to integrate an Actor? If asked about integration, you help developers integrate Actors into their projects. You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready. The best way to integrate Actors is as follows. In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js.md): ```bash npm install apify-client ``` In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.md): ```bash pip install apify-client ``` In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md): ````bash # MacOS / Linux curl -fsSL https://apify.com/install-cli.sh | bash # Windows irm https://apify.com/install-cli.ps1 | iex ```bash In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/platform/integrations/mcp.md). If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md). For usage examples, see the [API](#api) section below. For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt). # README ## US Education Data Search Apify Actor that queries the **SIP Public Data Gateway** over HTTPS — **no browser, no scraping** of government portals. Provide search terms (institution names, district names, keywords) and the Actor queries up to 16 US education data products in parallel, returning normalized rows across four toggleable categories. ### What it does - Searches **16 US education data products** exposed through SIP, grouped into four optional categories you can enable or disable per run. - All product calls run in **parallel per search term** using `asyncio.gather` — a 16-product run completes in roughly one round-trip instead of sixteen. - Enriches every row with `_product_id`, `_source`, `_search_term`, and `_collected_at` metadata for downstream filtering. - Respects SIP's **200-result cap** per product call; set `maxResultsPerSource` between 1 and 200. ### Data sources | Category | Product key | SIP product_id | Coverage | |----------|-------------|----------------|----------| | College & University | `college_scorecard` | `us_edu_college_scorecard` | Federal — costs, earnings, graduation, debt for ~6,000 US colleges | | College & University | `ny_cuny_enrollment` | `us_edu_ny_cuny_enrollment` | City University of New York enrollment by campus and program | | College & University | `ny_suny_campuses` | `us_edu_ny_suny_campuses` | State University of New York campus directory | | College & University | `co_financial_aid` | `us_edu_co_financial_aid` | Colorado state financial aid awards | | K-12 Performance | `de_assessment` | `us_edu_de_assessment` | Delaware state assessment scores by school | | K-12 Performance | `de_graduation` | `us_edu_de_graduation` | Delaware graduation cohort rates | | K-12 Performance | `wa_assessment` | `us_edu_wa_assessment` | Washington state assessment results | | K-12 Performance | `tx_graduation_rates` | `us_edu_tx_graduation_rates` | Texas four-year graduation rates by district | | K-12 Performance | `ct_directory` | `us_edu_ct_directory` | Connecticut school directory with district/address detail | | Financials | `ma_district_expenditure` | `us_edu_ma_district_expenditure` | Massachusetts per-pupil district expenditure | | Financials | `ma_school_expenditure` | `us_edu_ma_school_expenditure` | Massachusetts per-pupil school expenditure | | Financials | `wa_expenditure` | `us_edu_wa_expenditure` | Washington state school expenditure by district | | Financials | `de_educator_salary` | `us_edu_de_educator_salary` | Delaware educator salary schedule | | Student Outcomes | `wa_graduate_outcomes` | `us_edu_wa_graduate_outcomes` | Washington post-secondary employment and wage outcomes | | Student Outcomes | `de_discipline` | `us_edu_de_discipline` | Delaware student discipline incidents by school | | Student Outcomes | `ma_discipline` | `us_edu_ma_discipline` | Massachusetts student discipline rates by school | ### Use cases #### College research and selection Search College Scorecard for cost of attendance, median earnings after graduation, and completion rates. Cross-reference CUNY or SUNY enrollment data to understand program scale at New York public institutions. Combine with Colorado financial aid data for aid availability analysis. #### Education policy and benchmarking Pull K-12 assessment scores and graduation rates across Delaware, Washington, and Texas to compare academic performance across districts or over time. Useful for policy researchers, think tanks, and education journalists tracking state-level outcomes. #### School district analysis Search district expenditure data from Massachusetts and Washington alongside performance metrics. Analyze spend-per-pupil relative to assessment outcomes for budget accountability work, grant applications, or legislative testimony. #### Workforce and economic planning Washington's graduate outcomes product links post-secondary programs to employment wages. Combine with College Scorecard earnings data to map educational pathways to regional labor market outcomes — relevant for workforce development agencies and economic development offices. ### Input | Field | Type | Default | Description | |-------|------|---------|-------------| | `searchTerms` | `string[]` | — | **Required.** Institution names or keywords (e.g. `["University of New York", "Hartford"]`). | | `includeCollegeData` | `boolean` | `true` | College Scorecard, CUNY/SUNY enrollment, CO financial aid. | | `includeK12Performance` | `boolean` | `true` | Assessment scores, graduation rates, school directory (DE, WA, TX, CT). | | `includeFinancials` | `boolean` | `false` | District/school expenditures and educator salary (MA, WA, DE). | | `includeStudentOutcomes` | `boolean` | `false` | Graduate employment outcomes and discipline records (WA, DE, MA). | | `maxResultsPerSource` | `integer` | `50` | Per-product result cap (1–200; SIP gateway enforces 200 maximum). | #### Example input ```json { "searchTerms": ["University of New York", "Columbia"], "includeCollegeData": true, "includeK12Performance": false, "includeFinancials": false, "includeStudentOutcomes": false, "maxResultsPerSource": 100 } ```` ### Output Each dataset item is a SIP search hit from one product, enriched with Actor metadata: - **Education fields (examples):** `institution_name`, `school_name`, `district_name`, `city`, `state`, `enrollment`, `graduation_rate`, `median_earnings`, `expenditure_per_pupil`, `assessment_score` (exact field names vary by product schema). - **Actor metadata:** `_product_id`, `_source` (product label key), `_search_term`, `_collected_at` (ISO-8601 UTC). #### Example record — College Scorecard ```json { "institution_name": "City University of New York", "city": "New York", "state": "NY", "median_earnings": 42000, "admission_rate": 0.55, "graduation_rate": 0.48, "avg_net_price": 8500, "_product_id": "us_edu_college_scorecard", "_source": "college_scorecard", "_search_term": "University of New York", "_collected_at": "2026-04-08T10:00:00Z" } ``` #### Example record — TX graduation rates ```json { "district_name": "Houston Independent School District", "state": "TX", "graduation_rate_4yr": 82.1, "cohort_year": 2023, "_product_id": "us_edu_tx_graduation_rates", "_source": "tx_graduation_rates", "_search_term": "Houston", "_collected_at": "2026-04-08T10:00:00Z" } ``` ### Configuration Set the SIP gateway key as an **environment variable** in the Apify Actor settings (mark as secret): | Variable | Description | |----------|-------------| | `SIP_API_KEY` | SIP `X-API-Key` value. Mark as **secret** in Apify Actor environment variables. | | `SIP_API_BASE` | Optional. Override gateway root URL. Default: `https://sip.myskillstore.dev/api/v1/data`. | For local testing only, you may pass `sipApiKey` in the Actor input JSON. Prefer environment variables on Apify so the key is not stored in run input. ### Pricing reference Approximate target pricing: **~$2 per 1,000 results** combined (small per-run start fee plus per-result charge). Configure exact USD amounts in the Apify Actor **Pricing** tab. This README does not lock prices. ### Local development ```bash cd "/Users/kane/Projects/Apify Actors/sip-us-education-search" python3.13 -m venv .venv .venv/bin/pip install -r requirements.txt export SIP_API_KEY="your-key" mkdir -p storage/key_value_stores/default echo '{"searchTerms":["University of New York"],"includeCollegeData":true,"includeK12Performance":true,"maxResultsPerSource":10}' \ > storage/key_value_stores/default/INPUT.json apify run ``` Or run directly: ```bash SIP_API_KEY=your-key python -m src ``` (Requires `INPUT.json` under `storage/key_value_stores/default/` when using Apify SDK conventions.) ### Deploy ```bash apify login apify push ``` Use `APIFY_TOKEN` or CLI login — never commit tokens to source control. ### Legal You must comply with SIP **terms of use**, Apify **terms of service**, and all applicable **data protection** and **privacy laws** (including FERPA for student-level education data). This Actor is an API client to your own SIP gateway instance; you are responsible for lawful use of all downstream government and education data. Student-level records may carry additional legal obligations — consult legal counsel before processing personally identifiable information. ### Use as MCP Tool (AI Agent Integration) This Actor works as an MCP tool — AI agents (Claude, GPT, Cursor) can discover and run it automatically. #### Quick setup (Claude Desktop / Cursor / VS Code) Add to your MCP config: ```json { "mcpServers": { "apify": { "url": "https://mcp.apify.com", "headers": { "Authorization": "Bearer YOUR_APIFY_TOKEN" } } } } ``` Then ask your AI: *"Search for Stanford in US education databases"* #### Direct API call ```python from apify_client import ApifyClient client = ApifyClient("YOUR_APIFY_TOKEN") run = client.actor("lentic_clockss/us-education-search").call( run_input={"searchTerms": ["Stanford"], "maxResultsPerSource": 50} ) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item) ``` ### Other Data API Actors - [EU Energy & Education Data API](https://apify.com/lentic_clockss/eu-energy-education-search) - [Denmark Government Data API](https://apify.com/lentic_clockss/denmark-data-search) - [Australia Government Data API](https://apify.com/lentic_clockss/australia-data-search) # Actor input Schema ## `searchTerms` (type: `array`): Institution names, district names, or keywords to search (e.g. 'University of New York', 'Hartford Public Schools'). Each term is searched across all enabled data sources. ## `includeCollegeData` (type: `boolean`): Search federal College Scorecard (costs, earnings, graduation), CUNY enrollment, SUNY campus data, and Colorado financial aid records. ## `includeK12Performance` (type: `boolean`): Search K-12 assessment scores, graduation rates, and school directory data from DE, WA, TX, and CT. ## `includeFinancials` (type: `boolean`): Search school and district expenditure records from MA and WA, plus Delaware educator salary data. ## `includeStudentOutcomes` (type: `boolean`): Search graduate employment outcomes (WA), and student discipline records (DE, MA). ## `maxResultsPerSource` (type: `integer`): Maximum rows to return per SIP search call (gateway caps at 200). ## Actor input object example ```json { "searchTerms": [ "University of New York" ], "includeCollegeData": true, "includeK12Performance": true, "includeFinancials": false, "includeStudentOutcomes": false, "maxResultsPerSource": 50 } ``` # Actor output Schema ## `educationRecords` (type: `string`): Dataset containing college costs, earnings, admissions, K-12 assessments, graduation rates, and expenditures from 16 US education data sources. # API You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup. ## JavaScript example ```javascript import { ApifyClient } from 'apify-client'; // Initialize the ApifyClient with your Apify API token // Replace the '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = { "searchTerms": [ "University of New York" ] }; // Run the Actor and wait for it to finish const run = await client.actor("lentic_clockss/us-education-search").call(input); // Fetch and print Actor results from the run's dataset (if any) console.log('Results from dataset'); console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`); const { items } = await client.dataset(run.defaultDatasetId).listItems(); items.forEach((item) => { console.dir(item); }); // 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs ``` ## Python example ```python from apify_client import ApifyClient # Initialize the ApifyClient with your Apify API token # Replace '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = { "searchTerms": ["University of New York"] } # Run the Actor and wait for it to finish run = client.actor("lentic_clockss/us-education-search").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"]) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item) # 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{ "searchTerms": [ "University of New York" ] }' | apify call lentic_clockss/us-education-search --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=lentic_clockss/us-education-search", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "US Education Data API", "description": "Search 16 US education data sources — College Scorecard costs & earnings, CUNY/SUNY enrollment, K-12 assessment scores, graduation rates, school expenditures, and graduate outcomes. Covers federal and state-level data from CT, DE, MA, NY, TX, WA, and CO via SIP Public Data Gateway.", "version": "0.1", "x-build-id": "U85algd4wj7QQXaRm" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/lentic_clockss~us-education-search/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-lentic_clockss-us-education-search", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/lentic_clockss~us-education-search/runs": { "post": { "operationId": "runs-sync-lentic_clockss-us-education-search", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/lentic_clockss~us-education-search/run-sync": { "post": { "operationId": "run-sync-lentic_clockss-us-education-search", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "required": [ "searchTerms" ], "properties": { "searchTerms": { "title": "Search terms", "type": "array", "description": "Institution names, district names, or keywords to search (e.g. 'University of New York', 'Hartford Public Schools'). Each term is searched across all enabled data sources.", "items": { "type": "string" } }, "includeCollegeData": { "title": "Include college & university data", "type": "boolean", "description": "Search federal College Scorecard (costs, earnings, graduation), CUNY enrollment, SUNY campus data, and Colorado financial aid records.", "default": true }, "includeK12Performance": { "title": "Include K-12 performance data", "type": "boolean", "description": "Search K-12 assessment scores, graduation rates, and school directory data from DE, WA, TX, and CT.", "default": true }, "includeFinancials": { "title": "Include financial & expenditure data", "type": "boolean", "description": "Search school and district expenditure records from MA and WA, plus Delaware educator salary data.", "default": false }, "includeStudentOutcomes": { "title": "Include student outcome data", "type": "boolean", "description": "Search graduate employment outcomes (WA), and student discipline records (DE, MA).", "default": false }, "maxResultsPerSource": { "title": "Max results per source", "minimum": 1, "maximum": 200, "type": "integer", "description": "Maximum rows to return per SIP search call (gateway caps at 200).", "default": 50 } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } } } } } } } } } ```