Data catalog & agent guide

Public JSON datasets for researching Redwood City School District. This is an independent community project, not an official district website. No account or API key is required.

Choose the smallest relevant dataset. Cite its official source and reporting year. Source-check dates below come from the files; missing dates mean unknown freshness. Machine summaries, translations and transcripts may contain errors. Suppressed cells are not zero.

Example: find a school

Fetch schools.json, identify the school slug or CDS code, then join the matching school and year in a SARC or CDE dataset. For board documents, start with attachment-index.json; document-index.json contains only classified documents.

curl -fsS https://data.rcsd.info/json/schools.json

School directory

schools.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.

District-authorized charter schools

charters.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.

District property and leases

properties.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.

Trustees and district leadership

trustees.json

Source metadata as recorded (source / checked / method)

https://www.rcsdk8.net/our-district/our-board-of-trustees/meet-the-trustees

{
  "source": "https://www.rcsdk8.net/our-district/our-board-of-trustees/meet-the-trustees",
  "method": "Manually extracted from the official RCSD 'Meet the Trustees' page and district news releases. Officer roles, trustee-area numbers, school/area assignments, emails, and term-expiration years are stated verbatim on the source page. Superintendent succession is complete: Dr. Baker retired 2026-06-30 and Dr. Rubalcaba, appointed 2026-01-21, took office 2026-07-01 and is the sitting superintendent named on the Office of the Superintendent page. Baker is retained under superintendent.former for history and is not rendered. Cabinet and director names/titles are taken from the Office of the Superintendent page, which lists each person as a Name-pipe-Title heading. Headshots mirrored from the RCSD Finalsite CDN to R2 (data.rcsd.info/trustees/)."
}

freshness.json

Source metadata as recorded (source / checked / method)

https://www.rcsdk8.net/our-programs-and-services/our-superintendent

{
  "source": "https://www.rcsdk8.net/our-programs-and-services/our-superintendent",
  "scrapedAt": "2026-09-21T20:56:48.267Z",
  "method": "Direct HTTPS fetch of the district and per-school Finalsite pages, no JS execution. People are extracted structurally from \"<h2>Name | Title</h2>\" headings; the person titled exactly \"Principal\" (or \"Superintendent\") is taken as the officeholder. Courtesy titles (Mr./Mrs./Ms.) are dropped and post-nominals ignored for comparison; earned doctorates are preserved. A source that 404s or whose markup no longer matches is recorded in lastRun.failures and fails the run rather than being silently skipped. CDE year availability is a range-limited GET per candidate year, judged on whether the response carries rows beneath its header (DataQuest answers 200 for any year)."
}

School calendars

district-calendar-2025-26.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
district-calendar-2026-27.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.

Planned board agenda topics

governance-calendar.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.

Board meetings, agendas and attachments

meetings-data.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
attachment-index.json
Source metadata as recorded (source / checked / method)
```
{
  "source": "data/meetings-data.json"
}
```
document-index.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.

AI-generated meeting summaries and translations

meeting-summaries.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
meeting-summaries-es.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
school-board-summaries.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.

Meeting recordings and agenda timestamps

youtube-index.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
timestamp-map.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.

Board policy index and AI summaries; fetch individual policies on demand

policies-index.json

Source metadata as recorded (source / checked / method)

https://simbli.eboardsolutions.com/Policy/PolicyListing.aspx?S=36030397

{
  "source": "https://simbli.eboardsolutions.com/Policy/PolicyListing.aspx?S=36030397",
  "scrapedAt": "2026-05-24T15:24:42.991Z",
  "method": "Playwright + Simbli ViewPolicy API scraper"
}

policy-summaries.json

Source metadata as recorded (source / checked / method)

https://simbli.eboardsolutions.com/Policy/PolicyListing.aspx?S=36030397

{
  "source": "data/board-policies/*.json (scraped from https://simbli.eboardsolutions.com/Policy/PolicyListing.aspx?S=36030397 by scrape-board-policies.mjs)",
  "method": "AI-generated one-sentence summaries via the Claude API (scripts/generate-policy-summaries.mjs); one request per policy returning English and Spanish together as structured JSON; policy text truncated to the first 8000 chars as a cost/quality tradeoff; sourceHash is the sha256 of the full (untruncated) contentText for cache invalidation"
}

policy-titles-es.json

Source metadata as recorded (source / checked / method)

https://simbli.eboardsolutions.com/Policy/PolicyListing.aspx?S=36030397)

{
  "source": "data/policies-index.json (scraped from https://simbli.eboardsolutions.com/Policy/PolicyListing.aspx?S=36030397)",
  "method": "AI translation of policy titles and section names via the Claude API (scripts/translate-policy-titles.mjs); batched 50/request with structured JSON output; duplicate English titles translated once for consistency"
}

Special education enrollment and disability categories

sped-enrollment.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
sped-categories.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.

School accountability reports: academics, demographics and spending

sarc/adelante-selby.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
sarc/clifford.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
sarc/garfield.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
sarc/henry-ford.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
sarc/hoover.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
sarc/kennedy.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
sarc/mckinley-mit.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
sarc/north-star.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
sarc/orion.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
sarc/roosevelt.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
sarc/roy-cloud.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
sarc/sarc-summary.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.
sarc/taft.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.

State education data: absenteeism, English learners and staffing

cde/absenteeism-2024-25.json
Source metadata as recorded (source / checked / method)
https://www3.cde.ca.gov/demo-downloads/attendance/chronicabsenteeism25-v2.txt
```
{
  "source": "https://www3.cde.ca.gov/demo-downloads/attendance/chronicabsenteeism25-v2.txt"
}
```
cde/ltel-2024-25.json
Source metadata as recorded (source / checked / method)
https://dq.cde.ca.gov/dataquest/longtermel/lteldnld.aspx?year=2024-25
```
{
  "source": "https://dq.cde.ca.gov/dataquest/longtermel/lteldnld.aspx?year=2024-25"
}
```
cde/staff-ethnicity-2024-25.json
Source metadata as recorded (source / checked / method)
https://www3.cde.ca.gov/demo-downloads/staff/stre2425.txt
```
{
  "source": "https://www3.cde.ca.gov/demo-downloads/staff/stre2425.txt"
}
```
cde/staff-experience-2024-25.json
Source metadata as recorded (source / checked / method)
https://www3.cde.ca.gov/demo-downloads/staff/stex2425.txt
```
{
  "source": "https://www3.cde.ca.gov/demo-downloads/staff/stex2425.txt"
}
```
cde/staff-ratios-2024-25.json
Source metadata as recorded (source / checked / method)
https://www3.cde.ca.gov/demo-downloads/staff/strat2425.txt
```
{
  "source": "https://www3.cde.ca.gov/demo-downloads/staff/strat2425.txt"
}
```

School plan budgets and site councils

spsa-budgets.json

Source metadata as recorded (source / checked / method)

{
  "source": "Budget Summary pages in artifacts/documents/spsa/2025-26/"
}

ssc-membership.json
Source metadata as recorded (source / checked / method)
```
{
  "source": "SPSA documents at artifacts/documents/spsa/"
}
```

ssc-meetings.json

Source metadata as recorded (source / checked / method)

https://drive.google.com/drive/folders/1ZM8gRkBjer18QwlvNG_pEKOYmgFmwRZa

{
  "source": "Materials shared publicly by each school's SSC. Orion 2025-26: Google Drive folder https://drive.google.com/drive/folders/1ZM8gRkBjer18QwlvNG_pEKOYmgFmwRZa"
}

School presentations and AI-extracted club mentions

site-presentations.json

Source metadata as recorded (source / checked / method)

{
  "source": "data/document-index.json (attachments classified school-report/presentation)",
  "method": "build-site-presentations.mjs: one deck per school per school-year for the 3 most recent years; BoardDocs-only decks mirrored to R2 board-packets/. These are official district presentation decks republished verbatim."
}

school-clubs.json

Source metadata as recorded (source / checked / method)

{
  "source": "AssemblyAI transcripts of RCSD board school-site-presentation meetings (last 3 school years)",
  "method": "AI-extracted from board-presentation transcripts via claude-sonnet-4-6. BEST-EFFORT, NOT AUTHORITATIVE: reflects only clubs a principal named aloud on their presentation night, not a complete school club roster. Every club carries an evidence quote and the meeting date(s) it was mentioned."
}

Committee membership and meetings

committees/cboc.json

Source metadata as recorded (source / checked / method)

https://www.rcsdk8.net/our-programs-and-services/school-modernization-and-construction/phase-i-measure-t/measure-t-oversight-committee

{
  "source": "Authoritative: https://www.rcsdk8.net/our-programs-and-services/school-modernization-and-construction/phase-i-measure-t/measure-t-oversight-committee (members, annual reports, agendas, handouts, minutes, bylaws). Recordings from the RCSD YouTube channel."
}

committees/delac.json

Source metadata as recorded (source / checked / method)

{
  "source": "Redwood City School District BoardDocs and LCAP documentation."
}

Vendor payment coverage and aliases; fetch monthly registers on demand

warrants-index.json
Source metadata as recorded (source / checked / method)
No source-check metadata in this file; consult the source fields and research guide.

warrant-vendor-aliases.json

Source metadata as recorded (source / checked / method)

{
  "source": "Hand-curated from the top payees in data/warrants/*.json; extend as queries surface new variants."
}

warrant-pdf-manifest.json

Source metadata as recorded (source / checked / method)

{
  "source": "data/meetings-data.json warrant attachments (go.boarddocs.com $file URLs)"
}