# 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/).

- [agenda-attachments.json](https://data.rcsd.info/json/agenda-attachments.json): Board meeting attachment metadata with R2 CDN URLs
- [agenda-titles-es.json](https://data.rcsd.info/json/agenda-titles-es.json): Spanish translations of board agenda item titles
- [blog-posts.json](https://data.rcsd.info/json/blog-posts.json): Index of rcsd.info blog posts (EN/ES slugs, dates)
- [boarddocs-es.json](https://data.rcsd.info/json/boarddocs-es.json): Data file (no description yet — see the GitHub repo)
- [boarddocs-scraped.json](https://data.rcsd.info/json/boarddocs-scraped.json): Legacy board meeting data scraped from the retired BoardDocs portal
- [chapter-markers.json](https://data.rcsd.info/json/chapter-markers.json): YouTube chapter markers (agenda item → video offset) per board meeting
- [charters.json](https://data.rcsd.info/json/charters.json): Directory of RCSD-authorized charter schools — names, addresses, leaders, enrollment, CDS codes
- [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
- [document-index.json](https://data.rcsd.info/json/document-index.json): Index of board documents — titles mapped to direct file URLs
- [governance-calendar.json](https://data.rcsd.info/json/governance-calendar.json): Provisional topics planned for upcoming board meetings
- [linked-documents.json](https://data.rcsd.info/json/linked-documents.json): Curated district documents referenced in agenda memos but hosted off the board portal
- [meeting-summaries-es.json](https://data.rcsd.info/json/meeting-summaries-es.json): Spanish translations of meeting summaries
- [meeting-summaries.json](https://data.rcsd.info/json/meeting-summaries.json): Curated English summaries of each board meeting
- [meeting-titles.json](https://data.rcsd.info/json/meeting-titles.json): Display titles for board meetings keyed by meeting slug
- [meetings-data.json](https://data.rcsd.info/json/meetings-data.json): Comprehensive board meeting archive with agendas, agenda items, attachments, timestamps, and transcripts
- [minutes-aids.json](https://data.rcsd.info/json/minutes-aids.json): Per-meeting minutes notes (motions, votes, attendees) keyed by date
- [policies-index.json](https://data.rcsd.info/json/policies-index.json): Global catalog of all board policies, bylaws, and administrative regulations
- [policy-summaries.json](https://data.rcsd.info/json/policy-summaries.json): AI-generated one-sentence summaries of every board policy, English and Spanish, keyed by `{code}-{type}`
- [policy-titles-es.json](https://data.rcsd.info/json/policy-titles-es.json): Spanish translations of board policy titles
- [properties.json](https://data.rcsd.info/json/properties.json): Inventory of district real estate that is not an operating school — admin buildings, leased campuses
- [school-board-summaries.json](https://data.rcsd.info/json/school-board-summaries.json): Board agenda items tagged to specific schools
- [school-clubs.json](https://data.rcsd.info/json/school-clubs.json): Data file (no description yet — see the GitHub repo)
- [schools.json](https://data.rcsd.info/json/schools.json): Directory of all district schools — names, addresses, principals, bell schedules, enrollment, lunch menu URLs, PTO/PTA info, CDS codes
- [site-presentations.json](https://data.rcsd.info/json/site-presentations.json): Data file (no description yet — see the GitHub repo)
- [sped-categories.json](https://data.rcsd.info/json/sped-categories.json): Special education disability categories and LRE placement per school (CDE 2024-25)
- [sped-enrollment.json](https://data.rcsd.info/json/sped-enrollment.json): Special education (IEP) student counts per school per grade (CDE 2024-25)
- [spsa-budgets.json](https://data.rcsd.info/json/spsa-budgets.json): SPSA budget summaries extracted from each school plan
- [ssc-meetings.json](https://data.rcsd.info/json/ssc-meetings.json): School Site Council meeting agendas and minutes per school
- [ssc-membership.json](https://data.rcsd.info/json/ssc-membership.json): School Site Council member rosters per school
- [timestamp-map.json](https://data.rcsd.info/json/timestamp-map.json): Agenda item → video timestamp mapping per board meeting
- [trustees.json](https://data.rcsd.info/json/trustees.json): Board of Trustees roster with superintendent and cabinet
- [warrant-categories.json](https://data.rcsd.info/json/warrant-categories.json): Data file (no description yet — see the GitHub repo)
- [warrant-payee-overrides.json](https://data.rcsd.info/json/warrant-payee-overrides.json): Data file (no description yet — see the GitHub repo)
- [warrant-pdf-manifest-historical.json](https://data.rcsd.info/json/warrant-pdf-manifest-historical.json): Data file (no description yet — see the GitHub repo)
- [warrant-pdf-manifest.json](https://data.rcsd.info/json/warrant-pdf-manifest.json): Data file (no description yet — see the GitHub repo)
- [warrant-vendor-aliases.json](https://data.rcsd.info/json/warrant-vendor-aliases.json): Data file (no description yet — see the GitHub repo)
- [warrants-index.json](https://data.rcsd.info/json/warrants-index.json): Data file (no description yet — see the GitHub repo)
- [youtube-index.json](https://data.rcsd.info/json/youtube-index.json): YouTube video metadata for board meeting recordings
- [sarc/sarc-summary.json](https://data.rcsd.info/json/sarc/sarc-summary.json): SARC data — demographics, CAASPP test scores, expenditures per school
- [board-policies/](https://data.rcsd.info/json/board-policies/): Directory of per-policy JSON files (e.g. `0100-BP.json`) with full HTML content, plain-text body, legal references, and cross-references
- [board-policies-es/](https://data.rcsd.info/json/board-policies-es/): Spanish machine-translations of each policy body (same `{code}-{type}.json` filenames as board-policies/); the English version on Simbli is the only official text

## 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 (English)
- [/presupuesto/](https://rcsd.info/presupuesto/): District budget visualization (Spanish)
- [/policies/](https://rcsd.info/policies/): Board Policies Manual index — number, title, one-sentence summary per policy (English)
- [/politicas/](https://rcsd.info/politicas/): Board Policies Manual index (Spanish)
- [/policies/{code}-{type}/](https://rcsd.info/policies/): Individual policy pages — full text with hyperlinked cross-references. The slug is the policy code plus the type (bp or ar; exhibit entries use slugs like 6174-e-pdf-1-ar), lowercased, e.g. `/policies/5144.1-ar/` (English)
- [/politicas/{code}-{type}/](https://rcsd.info/politicas/): Individual policy pages, same slugs, machine-translated body (Spanish; the English Simbli version is the only official text)
- [/committees/](https://rcsd.info/committees/): District committees — members, meetings, recordings (English)
- [/comites/](https://rcsd.info/comites/): District committees (Spanish)
- [/search/](https://rcsd.info/search/): Site search (English)
- [/buscar/](https://rcsd.info/buscar/): Site search (Spanish)

## 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. Setup instructions: [rcsd.info/mcp/](https://rcsd.info/mcp/)

### Tools

- `list-schools`: List all 12 RCSD schools with key info (name, grades, type, enrollment)
- `query-school`: Get detailed information about a specific RCSD school by name or slug
- `check-calendar`: Check what falls on a given date (school day, holiday, break), or — called WITHOUT a date — list the school year's key dates (first/last day of school, breaks, holidays, board meetings). To find WHEN an event happens (e.g. 'when is the first day of school?'), call with no date and read the list; never guess-and-check specific dates.
- `get-lunch-menu`: Get the lunch menu for a school on a specific date (fetches live from HealthePro)
- `get-trustees`: Get the RCSD Board of Trustees (name, trustee area, officer role, term years, email, school assignments) plus the superintendent, cabinet, and district office contact info (address, phone)
- `list-meetings`: List board meetings newest-first (date, type, slug, video/transcript availability, topic line) with optional year/type filters and offset/limit paging
- `get-meeting-summary`: Get AI-generated board meeting summaries (English or Spanish). Returns the most recent meetings or a specific date.
- `get-meeting-details`: Get comprehensive details about a specific board meeting: agenda items, timestamps, chapter markers, transcript link, topics, and threads
- `search-transcript`: Search one board meeting's transcript for a word or phrase; returns matching utterances with timestamps and speakers. (Full-corpus transcript search is not offered — transcripts are one file per meeting.)
- `find-document`: Find board documents by title keywords — searches board-packet attachments, the classified document index, and curated off-portal documents; returns title, meeting date, and direct URL
- `get-school-board-items`: Get board agenda items related to a specific school (AI-generated summaries, English or Spanish)
- `get-sped-data`: Get special education (IEP) enrollment data for a school or district-wide
- `list-policies`: List all RCSD school board policies, bylaws, and regulations, with optional filtering
- `get-policy`: Get the full plain-text rules, legal citations, and cross-references of a specific board policy by code and type

## 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).