enrollments

Data source: Big Local News · About: Big Local

3,371,677 rows sorted by school descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
534867 534867 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969003469 5356 re-engagement   Alternative Education School No 3 09 12 2016   grade_11 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
534868 534868 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969003469 5356 re-engagement   Alternative Education School No 3 09 12 2016   grade_12 5 0 0   0 0     0   0   3 2 0   0   0   4       0.0 5 5 0 0   0 0     0   0   3 2 0   0 0 4     0 5
534869 534869 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969003469 5356 re-engagement   Alternative Education School No 3 09 12 2016   pk_12_total 6 0 0   0 0     0   0   4 2 0   0   0   5       0.0 6 6 0 0   0 0     0   0   4 2 0   0 0 5     0 6
2427883 2427883 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969003469 5356 re-engagement   Alternative School No High 09 12 2019   grade_12 2 0 0   0 0     0   0   2 0 0   0   0   2       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 2     0 2
2427884 2427884 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969003469 5356 re-engagement   Alternative School No High 09 12 2019   pk_12_total 2 0 0   0 0     0   0   2 0 0   0   0   2       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 2     0 2
2472400 2472400 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969003469 5356 re-engagement   Alternative School No High 09 12 2018   grade_11 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
2472401 2472401 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969003469 5356 re-engagement   Alternative School No High 09 12 2018   grade_12 3 0 0   0 0     0   0   1 2 0   0   0   2       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 2     0 3
2472402 2472402 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969003469 5356 re-engagement   Alternative School No High 09 12 2018   pk_12_total 4 0 0   0 0     0   0   1 3 0   0   0   2       0.0 4 4 0 0   0 0     0   0   1 3 0   0 0 2     0 4
2585314 2585314 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969003469 5356 re-engagement   Alternative School No High 09 12 2020   grade_11 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
2585315 2585315 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969003469 5356 re-engagement   Alternative School No High 09 12 2020   grade_12 2 0 0   0 0     0   0   1 1 0   0   0   1       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 1     0 2
2585316 2585316 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969003469 5356 re-engagement   Alternative School No High 09 12 2020   pk_12_total 3 0 0   0 0     0   0   2 1 0   0   0   2       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 2     0 3
65649 65649 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2021   pre_kindergarten                                                   *                                              
67965 67965 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2021   kindergarten                                                   63                                             63
70281 70281 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2021   grade_1                                                   71                                             71
72597 72597 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2021   grade_2                                                   60                                             60
74913 74913 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2021   grade_3                                                   63                                             63
77229 77229 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2021   grade_4                                                   41                                             41
79545 79545 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2021   grade_5                                                   43                                             43
81861 81861 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2021   grade_6                                                   52                                             52
84177 84177 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2021   grade_7                                                   43                                             43
86493 86493 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2021   grade_8                                                   65                                             65
88809 88809 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2021   grade_9                                                   44                                             44
91125 91125 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2021   grade_10                                                   58                                             58
93441 93441 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2021   grade_11                                                   88                                             88
95757 95757 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2021   grade_12                                                   159                                             159
98073 98073 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2021   pk_12_total 501 35 226   12 22     *   51   444 406     18   *         57   850 501 35 226   12 22         51   444 406     18       57   850
132192 132192 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2020   pre_kindergarten                                                   *                                              
134442 134442 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2020   kindergarten                                                   *                                              
136692 136692 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2020   grade_1                                                   *                                              
138942 138942 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2020   grade_2                                                   *                                              
141192 141192 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2020   grade_3                                                   *                                              
143442 143442 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2020   grade_4                                                   *                                              
145692 145692 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2020   grade_5                                                   *                                              
147942 147942 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2020   grade_6                                                   *                                              
150192 150192 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2020   grade_7                                                   *                                              
152442 152442 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2020   grade_8                                                   *                                              
154692 154692 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2020   grade_9                                                   *                                              
156942 156942 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2020   grade_10                                                   19                                             19
159192 159192 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2020   grade_11                                                   19                                             19
161442 161442 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2020   grade_12                                                   80                                             80
163692 163692 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2020   pk_12_total 73 * 38   * *         *   54 71     *   *         *   125 73   38                   54 71                 125
536739 536739 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2018   pre_kindergarten                                                   *                                              
538714 538714 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2018   kindergarten                                                   *                                              
540689 540689 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2018   grade_1                                                   *                                              
542664 542664 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2018   grade_2                                                   *                                              
544639 544639 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2018   grade_3                                                   *                                              
546614 546614 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2018   grade_4                                                   *                                              
548589 548589 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2018   grade_5                                                   *                                              
550564 550564 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2018   grade_6                                                   *                                              
552539 552539 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2018   grade_7                                                   *                                              
554514 554514 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2018   grade_8                                                   *                                              
556489 556489 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2018   grade_9                                                   *                                              
558464 558464 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2018   grade_10                                                   12                                             12
560439 560439 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2018   grade_11                                                   19                                             19
562414 562414 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2018   grade_12                                                   37                                             37
564389 564389 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2018   pk_12_total 56 * 18   * *     *   *   45 40     *             *   85 56   18                   45 40                 85
566351 566351 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2019   pre_kindergarten                                                   *                                              
568322 568322 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2019   kindergarten                                                   *                                              
570293 570293 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2019   grade_1                                                   *                                              
572264 572264 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2019   grade_2                                                   *                                              
574235 574235 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2019   grade_3                                                   *                                              
576206 576206 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2019   grade_4                                                   *                                              
578177 578177 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2019   grade_5                                                   *                                              
580148 580148 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2019   grade_6                                                   *                                              
582119 582119 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2019   grade_7                                                   *                                              
584090 584090 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2019   grade_8                                                   *                                              
586061 586061 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2019   grade_9                                                   *                                              
588032 588032 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2019   grade_10                                                   15                                             15
590003 590003 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2019   grade_11                                                   22                                             22
591974 591974 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2019   grade_12                                                   42                                             42
593945 593945 AZ     school 405930 4241   Paradise Valley Unified District 40593003216 90782 pvONLINE   Regular School No Other KG 12 2019   pk_12_total 46 * 23   * *     *   *   43 42     *             *   85 46   23                   43 42                 85
1762743 1762743 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 02 2019   grade_1                         12.0 9.0                       21.0                         12 9                 21
1762744 1762744 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 02 2019   grade_2                         7.0 13.0                       20.0                         7 13                 20
1762745 1762745 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 02 2019   kindergarten                         21.0 23.0                       44.0                         21 23                 44
1762746 1762746 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 02 2019   pk_12_total 10.0 37.0 14.0 1.0             23.0   40.0 45.0     6.0         66.0   11.0   85.0 10 37 14 1             23   40 45     6     66 11   85
1918201 1918201 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 03 2020   grade_1                         24.0 31.0                       55.0                         24 31                 55
1918202 1918202 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 03 2020   grade_2                         18.0 9.0                       27.0                         18 9                 27
1918203 1918203 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 03 2020   grade_3                         10.0 15.0                       25.0                         10 15                 25
1918204 1918204 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 03 2020   kindergarten                         27.0 25.0                       52.0                         27 25                 52
1918205 1918205 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 03 2020   pk_12_total 27.0 73.0 28.0 3.0             28.0   79.0 80.0     11.0         140.0   11.0   159.0 27 73 28 3             28   79 80     11     140 11   159
1930154 1930154 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 04 2021   grade_1                         23.0 26.0                       49.0                         23 26                 49
1930155 1930155 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 04 2021   grade_2                         19.0 26.0                       45.0                         19 26                 45
1930156 1930156 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 04 2021   grade_3                         16.0 5.0                       21.0                         16 5                 21
1930157 1930157 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 04 2021   grade_4                         6.0 13.0                       19.0                         6 13                 19
1930158 1930158 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 04 2021   kindergarten                         26.0 25.0                       51.0                         26 25                 51
1930159 1930159 IN     school 1800202 9085   pilotED Schools 180020202661 1006 pilotED Schools Bethel Park   Regular School Yes Elementary KG 04 2021   pk_12_total 28.0 87.0 34.0 3.0             33.0   90.0 95.0     17.0         153.0   11.0   185.0 28 87 34 3             33   90 95     17     153 11   185
2595659 2595659 CA SAN JOAQUIN 6077 school 691031 3910397 County Office of Education (COE) San Joaquin County Office of Education 60234012462 120717 one.Charter County Community Alternative School Yes Other KG 12 2020 October combined_K 0.0 1.0 1.0   0.0 0.0     0.0   0.0 0.0 2.0 0.0   0.0 0.0                 2.0 0 1 1   0 0     0   0 0 2 0   0 0           2
2606247 2606247 CA SAN JOAQUIN 6077 school 691031 3910397 County Office of Education (COE) San Joaquin County Office of Education 60234012462 120717 one.Charter County Community Alternative School Yes Other KG 12 2020 October grade_1 0.0 1.0 4.0   0.0 0.0     0.0   0.0 0.0 4.0 1.0   0.0 0.0                 5.0 0 1 4   0 0     0   0 0 4 1   0 0           5
2616835 2616835 CA SAN JOAQUIN 6077 school 691031 3910397 County Office of Education (COE) San Joaquin County Office of Education 60234012462 120717 one.Charter County Community Alternative School Yes Other KG 12 2020 October grade_2 0.0 1.0 2.0   0.0 0.0     0.0   0.0 0.0 2.0 1.0   0.0 0.0                 3.0 0 1 2   0 0     0   0 0 2 1   0 0           3
2627423 2627423 CA SAN JOAQUIN 6077 school 691031 3910397 County Office of Education (COE) San Joaquin County Office of Education 60234012462 120717 one.Charter County Community Alternative School Yes Other KG 12 2020 October grade_3 0.0 1.0 4.0   0.0 0.0     0.0   0.0 0.0 2.0 3.0   0.0 0.0                 5.0 0 1 4   0 0     0   0 0 2 3   0 0           5
2638011 2638011 CA SAN JOAQUIN 6077 school 691031 3910397 County Office of Education (COE) San Joaquin County Office of Education 60234012462 120717 one.Charter County Community Alternative School Yes Other KG 12 2020 October grade_4 0.0 1.0 6.0   0.0 0.0     0.0   0.0 0.0 5.0 2.0   0.0 1.0                 7.0 0 1 6   0 0     0   0 0 5 2   0 1           7
2648599 2648599 CA SAN JOAQUIN 6077 school 691031 3910397 County Office of Education (COE) San Joaquin County Office of Education 60234012462 120717 one.Charter County Community Alternative School Yes Other KG 12 2020 October grade_5 1.0 0.0 1.0   0.0 0.0     0.0   0.0 0.0 1.0 1.0   0.0 0.0                 2.0 1 0 1   0 0     0   0 0 1 1   0 0           2
2659187 2659187 CA SAN JOAQUIN 6077 school 691031 3910397 County Office of Education (COE) San Joaquin County Office of Education 60234012462 120717 one.Charter County Community Alternative School Yes Other KG 12 2020 October grade_6 1.0 0.0 3.0   0.0 0.0     0.0   0.0 0.0 3.0 1.0   0.0 0.0                 4.0 1 0 3   0 0     0   0 0 3 1   0 0           4
2669775 2669775 CA SAN JOAQUIN 6077 school 691031 3910397 County Office of Education (COE) San Joaquin County Office of Education 60234012462 120717 one.Charter County Community Alternative School Yes Other KG 12 2020 October grade_7 0.0 0.0 0.0   0.0 0.0     0.0   0.0 0.0 0.0 0.0   0.0 0.0                 0.0 0 0 0   0 0     0   0 0 0 0   0 0           0
2680363 2680363 CA SAN JOAQUIN 6077 school 691031 3910397 County Office of Education (COE) San Joaquin County Office of Education 60234012462 120717 one.Charter County Community Alternative School Yes Other KG 12 2020 October grade_8 0.0 0.0 5.0   0.0 0.0     0.0   0.0 0.0 1.0 4.0   0.0 0.0                 5.0 0 0 5   0 0     0   0 0 1 4   0 0           5
2690951 2690951 CA SAN JOAQUIN 6077 school 691031 3910397 County Office of Education (COE) San Joaquin County Office of Education 60234012462 120717 one.Charter County Community Alternative School Yes Other KG 12 2020 October grade_9 3.0 2.0 7.0   0.0 0.0     0.0   0.0 0.0 7.0 5.0   0.0 2.0                 12.0 3 2 7   0 0     0   0 0 7 5   0 2           12
2701539 2701539 CA SAN JOAQUIN 6077 school 691031 3910397 County Office of Education (COE) San Joaquin County Office of Education 60234012462 120717 one.Charter County Community Alternative School Yes Other KG 12 2020 October grade_10 4.0 3.0 12.0   0.0 0.0     0.0   4.0 0.0 13.0 10.0   0.0 2.0                 23.0 4 3 12   0 0     0   4 0 13 10   0 2           23
2712127 2712127 CA SAN JOAQUIN 6077 school 691031 3910397 County Office of Education (COE) San Joaquin County Office of Education 60234012462 120717 one.Charter County Community Alternative School Yes Other KG 12 2020 October grade_11 9.0 12.0 18.0   1.0 1.0     1.0   2.0 2.0 28.0 18.0   0.0 3.0                 46.0 9 12 18   1 1     1   2 2 28 18   0 3           46
2722715 2722715 CA SAN JOAQUIN 6077 school 691031 3910397 County Office of Education (COE) San Joaquin County Office of Education 60234012462 120717 one.Charter County Community Alternative School Yes Other KG 12 2020 October grade_12 54.0 99.0 379.0   5.0 45.0     1.0   36.0 4.0 241.0 382.0   0.0 58.0                 623.0 54 99 379   5 45     1   36 4 241 382   0 58           623
2733303 2733303 CA SAN JOAQUIN 6077 school 691031 3910397 County Office of Education (COE) San Joaquin County Office of Education 60234012462 120717 one.Charter County Community Alternative School Yes Other KG 12 2020 October k_12_total 72.0 121.0 442.0   6.0 46.0     2.0   42.0 6.0 309.0 428.0   0.0 66.0         611.0       737.0 72 121 442   6 46     2   42 6 309 428   0 66     611     737

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]);