# RCSD Open Data

> Open data portal for the Redwood City School District (RCSD) — a TK-8 public school district in Redwood City, California serving 6,299 students across 12 schools. Independently compiled public records, meeting archives, and school data.

This site publishes structured JSON data files covering school directory information, board meeting archives with transcripts and video, district calendars, special education enrollment, school accountability reports (SARCs), demographics, and live lunch menus.

## Data Files

All data is available as JSON at [data.rcsd.info/json/](https://data.rcsd.info/json/).

- [schools.json](https://data.rcsd.info/json/schools.json): Directory of all 12 schools — names, addresses, principals, bell schedules, enrollment, lunch menu URLs, parent platform links, PTO/PTA info, CDS codes
- [meetings-data.json](https://data.rcsd.info/json/meetings-data.json): Comprehensive board meeting archive with agendas, agenda items, attachments, timestamps, and transcripts
- [meeting-summaries.json](https://data.rcsd.info/json/meeting-summaries.json): Curated English summaries of each board meeting
- [meeting-summaries-es.json](https://data.rcsd.info/json/meeting-summaries-es.json): Spanish translations of meeting summaries
- [school-board-summaries.json](https://data.rcsd.info/json/school-board-summaries.json): Board agenda items tagged to specific schools
- [district-calendar-2025-26.json](https://data.rcsd.info/json/district-calendar-2025-26.json): 2025-26 school year calendar (holidays, early release, board meetings)
- [district-calendar-2026-27.json](https://data.rcsd.info/json/district-calendar-2026-27.json): 2026-27 school year calendar
- [sped-enrollment.json](https://data.rcsd.info/json/sped-enrollment.json): Special education (IEP) student counts per school per grade (CDE 2024-25)
- [sped-categories.json](https://data.rcsd.info/json/sped-categories.json): Disability categories and LRE placement per school (CDE 2024-25)
- [sarc/sarc-summary.json](https://data.rcsd.info/json/sarc/sarc-summary.json): SARC data — demographics, CAASPP test scores, expenditures per school
- [youtube-index.json](https://data.rcsd.info/json/youtube-index.json): YouTube video links for board meeting recordings

## School Slugs

- `adelante-selby` — Adelante Selby Spanish Immersion School (TK-5, Choice)
- `clifford` — Clifford School (TK-8, Neighborhood)
- `garfield` — Garfield Community School (K-5, Neighborhood)
- `henry-ford` — Henry Ford School (TK-5, Neighborhood)
- `hoover` — Hoover Community School (TK-8, Neighborhood)
- `kennedy` — John F. Kennedy Middle School (6-8, Neighborhood)
- `mckinley-mit` — McKinley Institute of Technology (6-8, Choice)
- `north-star` — North Star Academy (3-8, Choice)
- `orion` — Orion Alternative School (TK-5, Choice)
- `roosevelt` — Roosevelt School (TK-5, Neighborhood)
- `roy-cloud` — Roy Cloud School (TK-8, Neighborhood)
- `taft` — Taft School (TK-5, Neighborhood)

## Website Pages

- [/](https://rcsd.info/): Homepage (bilingual English/Spanish)
- [/meetings/](https://rcsd.info/meetings/): Board meeting archive (English)
- [/reuniones/](https://rcsd.info/reuniones/): Board meeting archive (Spanish)
- [/district/](https://rcsd.info/district/): District overview (English)
- [/distrito/](https://rcsd.info/distrito/): District overview (Spanish)
- [/schools/{slug}/](https://rcsd.info/schools/): Individual school pages (English)
- [/escuelas/{slug}/](https://rcsd.info/escuelas/): Individual school pages (Spanish)
- [/budget/](https://rcsd.info/budget/): District budget visualization

## MCP Server

A remote [Model Context Protocol](https://modelcontextprotocol.io) server is available at:

```
https://mcp.rcsd.info/mcp
```

Connect it to Claude Desktop, claude.ai, VS Code, Cursor, or any MCP-compatible client. No authentication required. Tools available: `list-schools`, `query-school`, `check-calendar`, `get-lunch-menu`, `get-meeting-summary`, `get-school-board-items`, `get-sped-data`.

## Claude Code Plugin

Install the [rcsd-info plugin](https://github.com/dweekly/rcsd-meetings/tree/main/plugin) for [Claude Code](https://claude.com/claude-code) to query RCSD data from the terminal:

```
/plugin marketplace add dweekly/rcsd-meetings
/plugin install rcsd-info@rcsd-info
```

The plugin provides school info, live lunch menus, calendars, board meetings, demographics, and special education stats.

## Documents on CDN

- Agendas: `https://data.rcsd.info/agendas/{YYYY-MM-DD}-agenda.pdf`
- Minutes: `https://data.rcsd.info/minutes/{YYYY-MM-DD}-minutes.pdf`
- Board packets: `https://data.rcsd.info/board-packets/{AID}.pdf`
- SARCs: `https://data.rcsd.info/documents/sarc/2024-25/{slug}-sarc-2024-25.pdf`
- SPSAs: `https://data.rcsd.info/documents/spsa/2025-26/{slug}.pdf`

## Contact

- Email: team@rcsd.info
- Source: https://github.com/dweekly/rcsd-meetings
- Not an official RCSD product. For official info visit [rcsdk8.net](https://www.rcsdk8.net).