SF School Lottery
San Francisco Unifed School District (SFUSD) School Lottery Data - 5 Years
Data on San Francisco Unifed School District (SFUSD) lottery selections and outcomes. Data goes 5 years back for requests per seat/school/program, and 3 years back for fine grained school/program choices by rank.
Years available (more coming soon)
- 2024 (2024-2025 school year)
- 2023 (2023-2024 school year)
- 2022 (2022-2023 school year)
- 2021 (2021-2022 school year)
- 2020 (2020-2021 school year, seats table only)
- 2019 (2019-2020 school year, seats table only)
seats
Shows the number of requests per available seat for each school, grade and program (TK, K, 6 and 9 only).
- Source data for 2023
- Source data for 2022
- Source data for 2021
- Source data for 2020
- Source data for 2019
Some years may have incomplete data depending on the source PDF used.
requests
1st-10th choice school requests, stored per year, school, program.
Program codes
- GE for general education
- Multiple program codes for each grade, ensure you are filtering correctly
- Some years may not have program codes at all, filter by program name
Incorrect data
Please report inaccuracies to jason@sort.xyz so it may be promptly fixed. Inaccuracies may occur in program codes, program names, or general data input.
Queries
motherly-hornet733
2022 Requests
jasonz
2024 Top Kindergartens By First Choice
For 2024, across San Francisco
aheckmann
Joined table example
A demonstration of how to join the `seats` and `requests` tables.
jasonz
Lowell Requests / Seats
Number of total requests for Lowell HS in San Francisco
jasonz
Most Selected Kindergartens 2023
2023 where program is GE
jasonz
Most Selected Kindergartens 2023
Top requests per seat
jasonz
Number of 1st choices by year
Sum of all first choices per year
muted-sardine514
Q1