Data source: Big Local News · About: Big Local

3,371,677 rows sorted by unknown_race descending

View and edit SQL

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race ▲ male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2730528 CA SAN DIEGO 6073 school 606810 3767991 Elementary School District Cajon Valley Union 60681005234 6112890 Hillsdale Middle Intermediate/Middle Schools (Public) Regular School No Middle 06 08 2020 October k_12_total 854.0 62.0 389.0   5.0 61.0     6.0   58.0 99.0 791.0 743.0   0.0 155.0         635.0       1534.0 854 62 389   5 61     6   58 99 791 743   0 155     635     1534
2927551 CA SAN BERNARDINO 6071 school 636970 3673957 Unified School District Snowline Joint Unified 63697007876 3630233 Serrano High High Schools (Public) Regular School No High 09 12 2021 October k_12_total 693 89 1124   8.0 38     1   21 99.0 1068 1005   0.0 147.0         1388.0       2073.0 693 89 1124   8 38     1   21 99 1068 1005   0 147     1388     2073
2929022 CA SAN MATEO 6081 school 634230 4169013 Elementary School District San Bruno Park Elementary 63423005397 6044671 John Muir Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2021 October k_12_total 87 2 102   1.0 100     2   5 99.0 204 194   0.0 55.0         60.0       398.0 87 2 102   1 100     2   5 99 204 194   0 55     60     398
2710644 CA SAN MATEO 6081 school 634980 4169047 High School District San Mateo Union High 63498005926 4136370 San Mateo High High Schools (Public) Regular School No High 09 12 2020 October grade_11 0.0 4.0 192.0   0.0 110.0     5.0   14.0 98.0 221.0 202.0   0.0 77.0                 423.0 0 4 192   0 110     5   14 98 221 202   0 77           423
2730414 CA SAN BERNARDINO 6071 school 636970 3673957 Unified School District Snowline Joint Unified 63697009195 6106710 Baldy Mesa Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October k_12_total 267.0 12.0 476.0   6.0 4.0     4.0   2.0 96.0 422.0 445.0   0.0 111.0         606.0       867.0 267 12 476   6 4     4   2 96 422 445   0 111     606     867
2921339 CA CONTRA COSTA 6013 school 626370 761754 Unified School District Mt. Diablo Unified 62637001967 6111504 Diablo View Middle Intermediate/Middle Schools (Public) Regular School No Middle 06 08 2021 October k_12_total 225 14 127   1.0 63     0   51 96.0 310 267   0.0 19.0         85.0       577.0 225 14 127   1 63     0   51 96 310 267   0 19     85     577
2722820 CA VENTURA 6111 school 630990 5672553 Elementary School District Pleasant Valley 60249414413 139592 Peak Prep Pleasant Valley K-12 Schools (Public) Regular School Yes Other KG 12 2020 October grade_12 1.0 0.0 11.0   0.0 1.0     0.0   1.0 95.0 50.0 59.0   0.0 7.0                 109.0 1 0 11   0 1     0   1 95 50 59   0 7           109
2724520 CA FRESNO 6019 school 609120 1062125 Unified School District Coalinga-Huron Unified 60912000934 6005961 Huron Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October k_12_total 6.0 4.0 679.0   0.0 21.0     0.0   0.0 95.0 401.0 404.0   0.0 629.0         794.0       805.0 6 4 679   0 21     0   0 95 401 404   0 629     794     805
2927686 CA SAN DIEGO 6073 school 606810 3767991 Elementary School District Cajon Valley Union 60681005234 6112890 Hillsdale Middle Intermediate/Middle Schools (Public) Regular School No Middle 06 08 2021 October k_12_total 844 77 354   2.0 58     8   61 94.0 785 713   0.0 238.0         639.0       1498.0 844 77 354   2 58     8   61 94 785 713   0 238     639     1498
2922560 CA LOS ANGELES 6037 school 601620 1964212 Unified School District ABC Unified 60162000017 6010920 Hawaiian Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2021 October k_12_total 0 1 200   2.0 0     2   1 91.0 161 136   0.0 183.0         252.0       297.0 0 1 200   2 0     2   1 91 161 136   0 183     252     297
2925317 CA NEVADA 6057 school 630930 2966373 Elementary School District Pleasant Ridge Union Elementary 63093007330 6101018 Cottage Hill Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2021 October k_12_total 192 0 75   1.0 3     0   32 91.0 202 192   0.0 4.0         103.0       394.0 192 0 75   1 3     0   32 91 202 192   0 4     103     394
2927063 CA SAN BERNARDINO 6071 school 691029 3610363 County Office of Education (COE) San Bernardino County Office of Education 60251814426 139147 Sycamore Academy of Science and Cultural Arts - Ch Elementary Schools (Public) Regular School Yes Elementary KG 08 2021 October k_12_total 57 3 52   0.0 25     3   20 91.0 141 110   0.0 10.0         58.0       251.0 57 3 52   0 25     3   20 91 141 110   0 10     58     251
2928051 CA SAN DIEGO 6073 school 634320 3768338 Unified School District San Diego Unified 60187603939 3730959 Charter School of San Diego K-12 Schools (Public) Regular School Yes High 06 12 2021 October k_12_total 310 115 1021   2.0 60     9   114 91.0 847 872   3.0 218.0         1177.0       1722.0 310 115 1021   2 60     9   114 91 847 872   3 218     1177     1722
2721230 CA SAN MATEO 6081 school 634980 4169047 High School District San Mateo Union High 63498005923 4133070 Hillsdale High High Schools (Public) Regular School No High 09 12 2020 October grade_12 44.0 2.0 147.0   0.0 67.0     2.0   25.0 90.0 205.0 172.0   0.0 51.0                 377.0 44 2 147   0 67     2   25 90 205 172   0 51           377
2725362 CA LOS ANGELES 6037 school 691078 1910199 County Office of Education (COE) Los Angeles County Office of Education 69107809663 1933399 L.A. County High School for the Arts Opportunity Schools Alternative School No High 09 12 2020 October k_12_total 146.0 36.0 144.0   0.0 70.0     1.0   41.0 90.0 186.0 340.0   2.0 3.0         97.0       528.0 146 36 144   0 70     1   41 90 186 340   2 3     97     528
2731774 CA SAN MATEO 6081 school 634230 4169013 Elementary School District San Bruno Park Elementary 63423005397 6044671 John Muir Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October k_12_total 110.0 5.0 126.0   1.0 117.0     6.0   2.0 90.0 237.0 220.0   0.0 86.0         87.0       457.0 110 5 126   1 117     6   2 90 237 220   0 86     87     457
2732989 CA STANISLAUS 6099 school 637950 5071282 Elementary School District Stanislaus Union Elementary 63795011497 105700 Mary Lou Dieterich Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October k_12_total 144.0 27.0 218.0   5.0 83.0     5.0   3.0 90.0 297.0 278.0   0.0 95.0         253.0       575.0 144 27 218   5 83     5   3 90 297 278   0 95     253     575
2927558 CA SAN BERNARDINO 6071 school 636970 3673957 Unified School District Snowline Joint Unified 63697009195 6106710 Baldy Mesa Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2021 October k_12_total 215 9 490   6.0 10     4   6 90.0 401 429   0.0 109.0         603.0       830.0 215 9 490   6 10     4   6 90 401 429   0 109     603     830
2586187 CA ALAMEDA 6001 school 628050 161259 Unified School District Oakland Unified 62805004275 6001911 Hillcrest Elementary Elementary Schools (Public) Regular School No Elementary KG 08 2020 October combined_K 28.0 4.0 4.0   0.0 8.0     0.0   12.0 9.0 36.0 29.0   0.0 1.0                 65.0 28 4 4   0 8     0   12 9 36 29   0 1           65
2586241 CA ALAMEDA 6001 school 634680 161291 Unified School District San Leandro Unified 63468005841 6002448 Roosevelt Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 26.0 14.0 42.0   0.0 16.0     1.0   13.0 9.0 59.0 62.0   0.0 20.0                 121.0 26 14 42   0 16     1   13 9 59 62   0 20           121
2586370 CA BUTTE 6007 school 629540 461523 Elementary School District Palermo Union Elementary 62954004556 6003289 Helen M. Wilcox Elementary Elementary Schools (Public) Regular School No Elementary KG 03 2020 October combined_K 73.0 0.0 52.0   8.0 4.0     0.0   18.0 9.0 79.0 85.0   0.0 23.0                 164.0 73 0 52   8 4     0   18 9 79 85   0 23           164
2586728 CA CONTRA COSTA 6013 school   777024 State Board of Education SBE - Rocketship Futuro Academy 60216214044 134072 Rocketship Futuro Academy Elemen Schools In 1 School Dist. (Public) Regular School Yes Elementary KG 05 2020 October combined_K 2.0 5.0 119.0   0.0 3.0     0.0   0.0 9.0 71.0 67.0   0.0 74.0                 138.0 2 5 119   0 3     0   0 9 71 67   0 74           138
2587877 CA LOS ANGELES 6037 school 606450 1964337 Unified School District Burbank Unified 60645000567 6011894 Ralph Emerson Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 78.0 3.0 13.0   0.0 12.0     0.0   4.0 9.0 67.0 52.0   0.0 22.0                 119.0 78 3 13   0 12     0   4 9 67 52   0 22           119
2587998 CA LOS ANGELES 6037 school 611850 1964485 Elementary School District East Whittier City Elementary 61185001321 6013106 Orchard Dale Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 7.0 0.0 111.0   1.0 3.0     0.0   2.0 9.0 67.0 66.0   0.0 4.0                 133.0 7 0 111   1 3     0   2 9 67 66   0 4           133
2588016 CA LOS ANGELES 6037 school 606450 1964337 Unified School District Burbank Unified 60645000568 6011910 Bret Harte Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 60.0 1.0 35.0   0.0 7.0     0.0   12.0 9.0 75.0 49.0   0.0 12.0                 124.0 60 1 35   0 7     0   12 9 75 49   0 12           124
2588255 CA LOS ANGELES 6037 school 622500 1964725 Unified School District Long Beach Unified 62250002703 6015192 Burcham Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 35.0 4.0 46.0   0.0 7.0     2.0   9.0 9.0 62.0 50.0   0.0 5.0                 112.0 35 4 46   0 7     2   9 9 62 50   0 5           112
2590691 CA ORANGE 6059 school 607440 3066464 Unified School District Capistrano Unified 60744008537 6117634 Don Juan Avila Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 60.0 0.0 18.0   1.0 31.0     0.0   14.0 9.0 78.0 55.0   0.0 20.0                 133.0 60 0 18   1 31     0   14 9 78 55   0 20           133
2590840 CA ORANGE 6059 school 618030 3066530 Elementary School District Huntington Beach City Elementary 60221014050 134221 Kinetic Academy Elementary Schools (Public) Regular School Yes Elementary KG 08 2020 October combined_K 34.0 0.0 11.0   0.0 6.0     0.0   3.0 9.0 39.0 24.0   0.0 1.0                 63.0 34 0 11   0 6     0   3 9 39 24   0 1           63
2590994 CA ORANGE 6059 school 607440 3066464 Unified School District Capistrano Unified 60744011248 100909 Ladera Ranch Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 84.0 2.0 9.0   0.0 17.0     0.0   11.0 9.0 66.0 66.0   0.0 9.0                 132.0 84 2 9   0 17     0   11 9 66 66   0 9           132
2592635 CA SAN BERNARDINO 6071 school 634170 3667876 Unified School District San Bernardino City Unified 63417011107 109496 Roger Anton Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October combined_K 4.0 10.0 100.0   0.0 4.0     0.0   0.0 9.0 73.0 54.0   0.0 56.0                 127.0 4 10 100   0 4     0   0 9 73 54   0 56           127
2592666 CA SAN BERNARDINO 6071 school 634170 3667876 Unified School District San Bernardino City Unified 63417005347 6036776 Barton Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October combined_K 6.0 22.0 54.0   0.0 1.0     0.0   2.0 9.0 50.0 44.0   0.0 20.0                 94.0 6 22 54   0 1     0   2 9 50 44   0 20           94
2592688 CA SAN BERNARDINO 6071 school 634170 3667876 Unified School District San Bernardino City Unified 63417008959 6037063 Highland Pacific Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October combined_K 0.0 8.0 39.0   0.0 1.0     0.0   3.0 9.0 31.0 29.0   0.0 12.0                 60.0 0 8 39   0 1     0   3 9 31 29   0 12           60
2592865 CA SAN DIEGO 6073 school 606810 3767991 Elementary School District Cajon Valley Union 60681000608 6037592 Chase Avenue Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 49.0 7.0 50.0   0.0 8.0     3.0   5.0 9.0 70.0 61.0   0.0 54.0                 131.0 49 7 50   0 8     3   5 9 70 61   0 54           131
2592938 CA SAN DIEGO 6073 school 609870 3768031 Unified School District Coronado Unified 60987001070 6038053 Coronado Village Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 100.0 3.0 20.0   1.0 1.0     0.0   13.0 9.0 79.0 67.0   1.0 10.0                 147.0 100 3 20   1 1     0   13 9 79 67   1 10           147
2593103 CA SAN DIEGO 6073 school 631530 3768296 Unified School District Poway Unified 63153011133 102822 Stone Ranch Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 49.0 2.0 13.0   0.0 61.0     0.0   14.0 9.0 84.0 64.0   0.0 26.0                 148.0 49 2 13   0 61     0   14 9 84 64   0 26           148
2593115 CA SAN DIEGO 6073 school 631530 3768296 Unified School District Poway Unified 63153004886 6038970 Garden Road Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 53.0 1.0 17.0   0.0 9.0     0.0   14.0 9.0 56.0 47.0   0.0 10.0                 103.0 53 1 17   0 9     0   14 9 56 47   0 10           103
2593127 CA SAN DIEGO 6073 school 631530 3768296 Unified School District Poway Unified 63153004894 6097208 Rolling Hills Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 49.0 1.0 17.0   0.0 13.0     0.0   9.0 9.0 52.0 46.0   0.0 11.0                 98.0 49 1 17   0 13     0   9 9 52 46   0 11           98
2593632 CA SAN FRANCISCO 6075 school 634410 3868478 Unified School District San Francisco Unified 63441005586 6040737 Argonne Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 28.0 1.0 3.0   0.0 21.0     1.0   5.0 9.0 30.0 38.0   0.0 16.0                 68.0 28 1 3   0 21     1   5 9 30 38   0 16           68
2593640 CA SAN FRANCISCO 6075 school 634410 3868478 Unified School District San Francisco Unified 63441005599 6040877 Lau (Gordon J.) Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 2.0 0.0 9.0   0.0 98.0     0.0   3.0 9.0 59.0 62.0   0.0 83.0                 121.0 2 0 9   0 98     0   3 9 59 62   0 83           121
2593659 CA SAN FRANCISCO 6075 school 634410 3868478 Unified School District San Francisco Unified 63441005631 6041230 Jefferson Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 24.0 1.0 14.0   0.0 31.0     0.0   10.0 9.0 47.0 42.0   0.0 30.0                 89.0 24 1 14   0 31     0   10 9 47 42   0 30           89
2593690 CA SAN FRANCISCO 6075 school 634410 3868478 Unified School District San Francisco Unified 63441005679 6041727 West Portal Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 28.0 0.0 2.0   0.0 50.0     0.0   10.0 9.0 57.0 42.0   0.0 34.0                 99.0 28 0 2   0 50     0   10 9 57 42   0 34           99
2593707 CA SAN FRANCISCO 6075 school 634410 3868478 Unified School District San Francisco Unified 63441005661 6089775 Rooftop Elementary Elementary Schools (Public) Regular School No Elementary KG 08 2020 October combined_K 26.0 8.0 11.0   0.0 7.0     0.0   5.0 9.0 35.0 31.0   0.0 4.0                 66.0 26 8 11   0 7     0   5 9 35 31   0 4           66
2594850 CA SHASTA 6089 school 612810 4569971 Elementary School District Enterprise Elementary 61281001440 6050223 Lassen View Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October combined_K 45.0 0.0 11.0   2.0 6.0     1.0   13.0 9.0 41.0 46.0   0.0 6.0                 87.0 45 0 11   2 6     1   13 9 41 46   0 6           87
2594946 CA SOLANO 6095 school 691122 4810488 County Office of Education (COE) Solano County Office of Education 60248514376 139030 Elite Public K-12 Schools (Public) Regular School Yes Other KG 12 2020 October combined_K 0.0 60.0 46.0   1.0 4.0     3.0   5.0 9.0 63.0 65.0   0.0 6.0                 128.0 0 60 46   1 4     3   5 9 63 65   0 6           128
2596759 CA ALAMEDA 6001 school 628050 161259 Unified School District Oakland Unified 62805004239 6001648 Chabot Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_1 48.0 10.0 10.0   0.0 9.0     0.0   25.0 9.0 63.0 48.0   0.0 5.0                 111.0 48 10 10   0 9     0   25 9 63 48   0 5           111
2597077 CA CONTRA COSTA 6013 school 605910 761655 Elementary School District Brentwood Union Elementary 60591010754 108019 Marsh Creek Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_1 42.0 3.0 45.0   0.0 17.0     0.0   12.0 9.0 59.0 69.0   0.0 22.0                 128.0 42 3 45   0 17     0   12 9 59 69   0 22           128
2597343 CA EL DORADO 6017 school 606270 961838 Elementary School District Buckeye Union Elementary 60252414444 139006 Cottonwood K-12 Schools (Public) Regular School Yes Other KG 12 2020 October grade_1 141.0 9.0 47.0   0.0 9.0     0.0   13.0 9.0 114.0 114.0   0.0 16.0                 228.0 141 9 47   0 9     0   13 9 114 114   0 16           228
2597464 CA FRESNO 6019 school 609120 1062125 Unified School District Coalinga-Huron Unified 60912000934 6005961 Huron Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_1 0.0 1.0 108.0   0.0 5.0     0.0   0.0 9.0 65.0 58.0   0.0 97.0                 123.0 0 1 108   0 5     0   0 9 65 58   0 97           123
2600906 CA MARIN 6041 school 619380 2165334 Elementary School District Kentfield Elementary 61938002327 6024319 Anthony G. Bacich Elementary Elementary Schools (Public) Regular School No Elementary KG 04 2020 October grade_1 87.0 0.0 11.0   0.0 2.0     0.0   10.0 9.0 60.0 59.0   0.0 8.0                 119.0 87 0 11   0 2     0   10 9 60 59   0 8           119
2603390 CA SAN BERNARDINO 6071 school 600015 3675051 Unified School District Lucerne Valley Unified 60251614425 139188 Granite Mountain Charter K-12 Schools (Public) Regular School Yes Other KG 12 2020 October grade_1 147.0 18.0 126.0   1.0 9.0     6.0   16.0 9.0 166.0 166.0   0.0 5.0                 332.0 147 18 126   1 9     6   16 9 166 166   0 5           332
2603451 CA SAN DIEGO 6073 school 606810 3767991 Elementary School District Cajon Valley Union 60681000606 6037576 Bostonia Language Academy Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_1 15.0 6.0 91.0   0.0 1.0     0.0   2.0 9.0 65.0 59.0   0.0 49.0                 124.0 15 6 91   0 1     0   2 9 65 59   0 49           124
2603457 CA SAN DIEGO 6073 school 606810 3767991 Elementary School District Cajon Valley Union 60681000614 6037642 Fuerte Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_1 69.0 3.0 17.0   1.0 4.0     1.0   0.0 9.0 54.0 50.0   0.0 10.0                 104.0 69 3 17   1 4     1   0 9 54 50   0 10           104
2603460 CA SAN DIEGO 6073 school 606810 3767991 Elementary School District Cajon Valley Union 60681000618 6037683 Lexington Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_1 60.0 7.0 52.0   0.0 5.0     0.0   0.0 9.0 65.0 68.0   0.0 93.0                 133.0 60 7 52   0 5     0   0 9 65 68   0 93           133
2603722 CA SAN DIEGO 6073 school 631530 3768296 Unified School District Poway Unified 63153010007 6109326 Turtleback Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_1 47.0 3.0 12.0   0.0 24.0     0.0   8.0 9.0 61.0 42.0   0.0 14.0                 103.0 47 3 12   0 24     0   8 9 61 42   0 14           103
2604634 CA SAN MATEO 6081 school 606480 4168882 Elementary School District Burlingame Elementary 60648000584 6043574 McKinley Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_1 37.0 0.0 30.0   0.0 15.0     1.0   16.0 9.0 56.0 52.0   0.0 22.0                 108.0 37 0 30   0 15     1   16 9 56 52   0 22           108
2607108 CA ALAMEDA 6001 school 601770 161119 Unified School District Alameda Unified 60177000054 6090021 Frank Otis Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_2 45.0 3.0 14.0   0.0 28.0     0.0   22.0 9.0 49.0 72.0   0.0 11.0                 121.0 45 3 14   0 28     0   22 9 49 72   0 11           121
2607371 CA ALAMEDA 6001 school 628050 161259 Unified School District Oakland Unified 62805004302 6002083 Montclair Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_2 47.0 9.0 16.0   0.0 10.0     0.0   16.0 9.0 57.0 50.0   0.0 2.0                 107.0 47 9 16   0 10     0   16 9 57 50   0 2           107
2607772 CA CONTRA COSTA 6013 school 626370 761754 Unified School District Mt. Diablo Unified 62637003959 6004188 Mt. Diablo Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_2 61.0 2.0 18.0   0.0 13.0     0.0   15.0 9.0 52.0 66.0   0.0 5.0                 118.0 61 2 18   0 13     0   15 9 52 66   0 5           118
2608251 CA FRESNO 6019 school 642210 1062547 Elementary School District Westside Elementary 60246014019 135103 Inspire Charter School - Central K-12 Schools (Public) Regular School Yes Other KG 12 2020 October grade_2 117.0 3.0 62.0   1.0 8.0     0.0   18.0 9.0 99.0 119.0   0.0 4.0                 218.0 117 3 62   1 8     0   18 9 99 119   0 4           218
2609192 CA LOS ANGELES 6037 school 606450 1964337 Unified School District Burbank Unified 60645000568 6011910 Bret Harte Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_2 43.0 2.0 32.0   0.0 3.0     0.0   6.0 9.0 48.0 47.0   0.0 5.0                 95.0 43 2 32   0 3     0   6 9 48 47   0 5           95
2609462 CA LOS ANGELES 6037 school 622500 1964725 Unified School District Long Beach Unified 62250002739 6015473 Lowell Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_2 49.0 1.0 22.0   1.0 4.0     0.0   7.0 9.0 38.0 55.0   0.0 3.0                 93.0 49 1 22   1 4     0   7 9 38 55   0 3           93
2609712 CA LOS ANGELES 6037 school 622710 1964733 Unified School District Los Angeles Unified 60218613088 126193 Citizens of the World Charter School Mar Vista Elementary Schools (Public) Regular School Yes Elementary KG 08 2020 October grade_2 33.0 7.0 32.0   0.0 5.0     0.0   4.0 9.0 48.0 42.0   0.0 11.0                 90.0 33 7 32   0 5     0   4 9 48 42   0 11           90
2611218 CA LOS ANGELES 6037 school 609620 1973437 Unified School District Compton Unified 60962000995 6012397 Rosecrans Elementary Elementary Schools (Public) Regular School No Elementary KG 08 2020 October grade_2 0.0 7.0 80.0   0.0 0.0     1.0   0.0 9.0 55.0 42.0   0.0 42.0                 97.0 0 7 80   0 0     1   0 9 55 42   0 42           97
2611520 CA MONTEREY 6053 school 601950 2765961 Elementary School District Alisal Union 60195009694 6109466 John E. Steinbeck Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October grade_2 0.0 1.0 56.0   0.0 1.0     1.0   1.0 9.0 31.0 38.0   0.0 15.0                 69.0 0 1 56   0 1     1   1 9 31 38   0 15           69
2613856 CA SAN BERNARDINO 6071 school 634170 3667876 Unified School District San Bernardino City Unified 63417005367 6036974 Lytle Creek Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October grade_2 1.0 4.0 96.0   0.0 0.0     0.0   0.0 9.0 63.0 47.0   0.0 75.0                 110.0 1 4 96   0 0     0   0 9 63 47   0 75           110
2613947 CA SAN BERNARDINO 6071 school 636970 3673957 Unified School District Snowline Joint Unified 63697005069 6112924 Heritage Elementary Schools (Public) Regular School No Elementary KG 08 2020 October grade_2 20.0 0.0 18.0   0.0 1.0     0.0   0.0 9.0 27.0 21.0   0.0 2.0                 48.0 20 0 18   0 1     0   0 9 27 21   0 2           48
2614816 CA SAN FRANCISCO 6075 school 634410 3868478 Unified School District San Francisco Unified 63441005599 6040877 Lau (Gordon J.) Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_2 1.0 1.0 6.0   0.0 98.0     0.0   2.0 9.0 60.0 57.0   0.0 102.0                 117.0 1 1 6   0 98     0   2 9 60 57   0 102           117
2614844 CA SAN FRANCISCO 6075 school 634410 3868478 Unified School District San Francisco Unified 63441005641 6041362 Longfellow Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_2 0.0 2.0 32.0   0.0 31.0     0.0   3.0 9.0 42.0 35.0   0.0 47.0                 77.0 0 2 32   0 31     0   3 9 42 35   0 47           77
2614861 CA SAN FRANCISCO 6075 school 634410 3868478 Unified School District San Francisco Unified 63441005671 6041602 King (Thomas Starr) Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_2 4.0 5.0 6.0   0.0 21.0     3.0   11.0 9.0 38.0 21.0   0.0 10.0                 59.0 4 5 6   0 21     3   11 9 38 21   0 10           59
2614883 CA SAN FRANCISCO 6075 school 634410 3868478 Unified School District San Francisco Unified 63441005661 6089775 Rooftop Elementary Elementary Schools (Public) Regular School No Elementary KG 08 2020 October grade_2 23.0 5.0 16.0   0.0 6.0     0.0   7.0 9.0 36.0 30.0   0.0 4.0                 66.0 23 5 16   0 6     0   7 9 36 30   0 4           66
2615221 CA SAN MATEO 6081 school 606480 4168882 Elementary School District Burlingame Elementary 60648000583 6043566 Lincoln Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_2 36.0 0.0 10.0   0.0 24.0     0.0   13.0 9.0 57.0 35.0   0.0 9.0                 92.0 36 0 10   0 24     0   13 9 57 35   0 9           92
2615306 CA SAN MATEO 6081 school 634230 4169013 Elementary School District San Bruno Park Elementary 63423005397 6044671 John Muir Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_2 31.0 0.0 16.0   0.0 25.0     2.0   0.0 9.0 44.0 39.0   0.0 15.0                 83.0 31 0 16   0 25     2   0 9 44 39   0 15           83
2615696 CA SANTA CLARA 6085 school 615180 4369484 Unified School District Gilroy Unified 61518001909 6047294 El Roble Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_2 18.0 0.0 60.0   0.0 2.0     0.0   3.0 9.0 49.0 43.0   0.0 25.0                 92.0 18 0 60   0 2     0   3 9 49 43   0 25           92
2616529 CA STANISLAUS 6099 school 638670 5071290 Elementary School District Sylvan Union Elementary 63867011851 113795 Crossroads Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_2 52.0 1.0 57.0   0.0 8.0     1.0   7.0 9.0 75.0 60.0   0.0 23.0                 135.0 52 1 57   0 8     1   7 9 75 60   0 23           135
2618257 CA CONTRA COSTA 6013 school 605910 761655 Elementary School District Brentwood Union Elementary 60591000536 6070981 Garin Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_3 43.0 10.0 36.0   0.0 14.0     2.0   6.0 9.0 53.0 67.0   0.0 9.0                 120.0 43 10 36   0 14     2   6 9 53 67   0 9           120
2618258 CA CONTRA COSTA 6013 school 605910 761655 Elementary School District Brentwood Union Elementary 60591010194 6109730 Ron Nunn Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_3 54.0 9.0 24.0   0.0 18.0     1.0   15.0 9.0 60.0 70.0   0.0 6.0                 130.0 54 9 24   0 18     1   15 9 60 70   0 6           130
2619265 CA KERN 6029 school 623820 1563628 Unified School District Maricopa Unified 60206214020 134312 Blue Ridge Academy K-12 Schools (Public) Regular School Yes Other KG 12 2020 October grade_3 289.0 42.0 201.0   1.0 36.0     0.0   57.0 9.0 322.0 313.0   0.0 8.0                 635.0 289 42 201   1 36     0   57 9 322 313   0 8           635
2622682 CA NEVADA 6057 school 630930 2966373 Elementary School District Pleasant Ridge Union Elementary 63093007330 6101018 Cottage Hill Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_3 40.0 0.0 14.0   0.0 0.0     0.0   5.0 9.0 31.0 37.0   0.0 0.0                 68.0 40 0 14   0 0     0   5 9 31 37   0 0           68
2623405 CA RIVERSIDE 6065 school 619260 3367090 Unified School District Jurupa Unified 61926009380 6106835 Camino Real Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October grade_3 25.0 3.0 66.0   0.0 5.0     1.0   7.0 9.0 55.0 61.0   0.0 10.0                 116.0 25 3 66   0 5     1   7 9 55 61   0 10           116
2624098 CA SAN BERNARDINO 6071 school 601710 3667587 Elementary School District Adelanto Elementary 60171009110 6106694 Westside Park Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_3 7.0 39.0 51.0   0.0 0.0     0.0   2.0 9.0 50.0 58.0   0.0 15.0                 108.0 7 39 51   0 0     0   2 9 50 58   0 15           108
2624644 CA SAN DIEGO 6073 school 606810 3767991 Elementary School District Cajon Valley Union 60681007655 6101794 Vista Grande Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_3 76.0 1.0 13.0   0.0 3.0     0.0   5.0 9.0 62.0 45.0   0.0 23.0                 107.0 76 1 13   0 3     0   5 9 62 45   0 23           107
2624707 CA SAN DIEGO 6073 school 610710 3768049 Elementary School District Dehesa Elementary 60196114103 136416 Pacific Coast Academy K-12 Schools (Public) Regular School Yes Other KG 12 2020 October grade_3 211.0 7.0 98.0   1.0 13.0     1.0   40.0 9.0 184.0 196.0   0.0 12.0                 380.0 211 7 98   1 13     1   40 9 184 196   0 12           380
2625422 CA SAN FRANCISCO 6075 school 634410 3868478 Unified School District San Francisco Unified 63441005630 6041206 Parker (Jean) Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_3 0.0 3.0 4.0   0.0 27.0     0.0   1.0 9.0 21.0 23.0   0.0 22.0                 44.0 0 3 4   0 27     0   1 9 21 23   0 22           44
2625423 CA SAN FRANCISCO 6075 school 634410 3868478 Unified School District San Francisco Unified 63441005631 6041230 Jefferson Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_3 20.0 2.0 10.0   1.0 33.0     0.0   8.0 9.0 33.0 50.0   0.0 20.0                 83.0 20 2 10   1 33     0   8 9 33 50   0 20           83
2625479 CA SAN FRANCISCO 6075 school 634410 3868478 Unified School District San Francisco Unified 63441006556 6113997 Sunset Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_3 17.0 0.0 2.0   0.0 31.0     0.0   7.0 9.0 36.0 30.0   0.0 14.0                 66.0 17 0 2   0 31     0   7 9 36 30   0 14           66
2625480 CA SAN FRANCISCO 6075 school 634410 3868478 Unified School District San Francisco Unified 63441007732 6115901 Tenderloin Community Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_3 8.0 10.0 24.0   1.0 9.0     0.0   1.0 9.0 29.0 33.0   0.0 30.0                 62.0 8 10 24   1 9     0   1 9 29 33   0 30           62
2627970 CA STANISLAUS 6099 school 625130 5071167 Elementary School District Modesto City Elementary 62513003735 6052708 John Fremont Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October grade_3 31.0 2.0 40.0   1.0 0.0     0.0   11.0 9.0 50.0 44.0   0.0 20.0                 94.0 31 2 40   1 0     0   11 9 50 44   0 20           94
2628916 CA CONTRA COSTA 6013 school 626370 761754 Unified School District Mt. Diablo Unified 62637003967 6004246 Pleasant Hill Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_4 43.0 3.0 27.0   0.0 9.0     1.0   8.0 9.0 53.0 47.0   0.0 15.0                 100.0 43 3 27   0 9     1   8 9 53 47   0 15           100
2629766 CA KERN 6029 school 606390 1563362 Elementary School District Panama-Buena Vista Union 60639007503 6115257 Ronald Reagan Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October grade_4 40.0 3.0 34.0   1.0 47.0     2.0   3.0 9.0 73.0 66.0   0.0 7.0                 139.0 40 3 34   1 47     2   3 9 73 66   0 7           139
2632988 CA ORANGE 6059 school 607440 3066464 Unified School District Capistrano Unified 60744010984 108704 Oso Grande Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_4 127.0 1.0 13.0   0.0 17.0     2.0   17.0 9.0 100.0 86.0   0.0 2.0                 186.0 127 1 13   0 17     2   17 9 100 86   0 2           186
2633158 CA ORANGE 6059 school 614880 3066522 Unified School District Garden Grove Unified 61488001865 6028526 John Murdy Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October grade_4 0.0 0.0 7.0   0.0 30.0     0.0   0.0 9.0 25.0 21.0   0.0 14.0                 46.0 0 0 7   0 30     0   0 9 25 21   0 14           46
2635150 CA SAN BERNARDINO 6071 school 600015 3675051 Unified School District Lucerne Valley Unified 60174311860 115089 Sky Mountain Charter K-12 Schools (Public) Regular School Yes Other KG 12 2020 October grade_4 53.0 3.0 43.0   0.0 8.0     0.0   14.0 9.0 70.0 60.0   0.0 2.0                 130.0 53 3 43   0 8     0   14 9 70 60   0 2           130
2636470 CA SAN MATEO 6081 school 632130 4169005 Elementary School District Redwood City Elementary 60235713060 127282 Connect Community Charter Elementary Schools (Public) Regular School Yes Elementary KG 08 2020 October grade_4 0.0 1.0 14.0   0.0 1.0     0.0   0.0 9.0 15.0 10.0   0.0 15.0                 25.0 0 1 14   0 1     0   0 9 15 10   0 15           25
2637202 CA SHASTA 6089 school 612810 4569971 Elementary School District Enterprise Elementary 61281001440 6050223 Lassen View Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_4 24.0 0.0 10.0   0.0 7.0     0.0   10.0 9.0 31.0 29.0   0.0 6.0                 60.0 24 0 10   0 7     0   10 9 31 29   0 6           60
2638583 CA SAN BERNARDINO 6071 school 636970 3673957 Unified School District Snowline Joint Unified 63697009640 6108260 Pinon Hills Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_4 28.0 1.0 43.0   0.0 2.0     0.0   1.0 9.0 46.0 38.0   0.0 16.0                 84.0 28 1 43   0 2     0   1 9 46 38   0 16           84
2639497 CA CONTRA COSTA 6013 school 626370 761754 Unified School District Mt. Diablo Unified 62637003951 6004105 Highlands Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_5 31.0 2.0 15.0   0.0 5.0     1.0   11.0 9.0 44.0 30.0   0.0 2.0                 74.0 31 2 15   0 5     1   11 9 44 30   0 2           74
2639504 CA CONTRA COSTA 6013 school 626370 761754 Unified School District Mt. Diablo Unified 62637003967 6004246 Pleasant Hill Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_5 39.0 2.0 24.0   0.0 8.0     0.0   10.0 9.0 49.0 43.0   0.0 5.0                 92.0 39 2 24   0 8     0   10 9 49 43   0 5           92
2639990 CA FRESNO 6019 school 635250 1062414 Unified School District Sanger Unified 63525005971 6007132 Jackson Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October grade_5 6.0 0.0 36.0   0.0 2.0     0.0   0.0 9.0 23.0 30.0   0.0 7.0                 53.0 6 0 36   0 2     0   0 9 23 30   0 7           53
2640807 CA LOS ANGELES 6037 school 605610 1964329 Unified School District Bonita Unified 60561010235 6110035 Oak Mesa Elementary Elementary Schools (Public) Regular School No Elementary KG 05 2020 October grade_5 33.0 1.0 30.0   0.0 14.0     0.0   13.0 9.0 48.0 52.0   0.0 4.0                 100.0 33 1 30   0 14     0   13 9 48 52   0 4           100
2643284 CA MONTEREY 6053 school 601950 2765961 Elementary School District Alisal Union 60195009694 6109466 John E. Steinbeck Elementary Elementary Schools (Public) Regular School No Elementary KG 06 2020 October grade_5 8.0 1.0 77.0   0.0 2.0     1.0   1.0 9.0 49.0 50.0   0.0 25.0                 99.0 8 1 77   0 2     1   1 9 49 50   0 25           99

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);