Data source: Big Local News · About: Big Local

16,123 rows where grade = "k_12_total" and state = "MO" sorted by district

View and edit SQL

year

grade

  • k_12_total · 16,023
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
3307645 MO     school 2902910 96098   AFFTON 101 290291000007 4040 MESNIER PRIMARY SCH.   Regular School No 1 PK 02 2016   k_12_total 459 44 37 *   18       * 38           114         221.3   73   601 459 44 37     18         38           114       73   601
3307646 MO     school 2902910 96098   AFFTON 101 290291000007 4040 MESNIER PRIMARY SCH.   Regular School No Elementary PK 02 2017   k_12_total 484 44 40 *   22       * 50           118         231   63   643 484 44 40     22         50           118     231 63   643
3307647 MO     school 2902910 96098   AFFTON 101 290291000007 4040 MESNIER PRIMARY SCH.   Regular School No Elementary PK 02 2018   k_12_total 464 48 41 *   24       * 61           107         213   69   639 464 48 41     24         61           107     213 69   639
3307648 MO     school 2902910 96098   AFFTON 101 290291000007 4040 MESNIER PRIMARY SCH.   Regular School No Elementary PK 02 2019   k_12_total 486 33 34 *   23       * 50           113         224.2   76   626 486 33 34     23         50           113       76   626
3307649 MO     school 2902910 96098   AFFTON 101 290291000007 4040 MESNIER PRIMARY SCH.   Regular School No Elementary KG 02 2020   k_12_total 476 32 36 *   21       * 56           100         178   96   621 476 32 36     21         56           100     178 96   621
3307650 MO     school 2902910 96098   AFFTON 101 290291000005 4080 GOTSCH INTERMEDIATE SCH.   Regular School No 1 03 05 2015   k_12_total 409 30 41 *   14       * 31           54         203   91   526 409 30 41     14         31           54     203 91   526
3307651 MO     school 2902910 96098   AFFTON 101 290291000005 4080 GOTSCH INTERMEDIATE SCH.   Regular School No 1 03 05 2016   k_12_total 406 32 54 *   11       * 40           65         243   90   543 406 32 54     11         40           65     243 90   543
3307652 MO     school 2902910 96098   AFFTON 101 290291000005 4080 GOTSCH INTERMEDIATE SCH.   Regular School No Elementary 03 05 2017   k_12_total 419 46 45 *   14       * 45           65         248   92   571 419 46 45     14         45           65     248 92   571
3307653 MO     school 2902910 96098   AFFTON 101 290291000005 4080 GOTSCH INTERMEDIATE SCH.   Regular School No Elementary 03 05 2018   k_12_total 445 48 32 *   14       * 50           74         222   94   592 445 48 32     14         50           74     222 94   592
3307654 MO     school 2902910 96098   AFFTON 101 290291000005 4080 GOTSCH INTERMEDIATE SCH.   Regular School No Elementary 03 05 2019   k_12_total 437 48 36 *   18       * 54           69         215   98   594 437 48 36     18         54           69     215 98   594
3307655 MO     school 2902910 96098   AFFTON 101 290291000005 4080 GOTSCH INTERMEDIATE SCH.   Regular School No Elementary 03 05 2020   k_12_total 434 56 44 *   24       * 54           83         210   103   613 434 56 44     24         54           83     210 103   613
3069876 MO     school 2902970 38046   ALBANY R-III 290297000010 1050 ALBANY HIGH   Regular School No High 09 12 2021   k_12_total                                                   127                                             127
3069877 MO     school 2902970 38046   ALBANY R-III 290297001478 3000 ALBANY MIDDLE   Regular School No Middle 06 08 2021   k_12_total                                                   93                                             93
3069878 MO     school 2902970 38046   ALBANY R-III 290297000011 4020 VIRGINIA E. GEORGE ELEM.   Regular School No Elementary PK 05 2021   k_12_total                                                   194                                             194
3300332 MO     school 2902970 38046   ALBANY R-III 290297000010 1050 ALBANY HIGH   Regular School No 3 09 12 2015   k_12_total 125 * * *   *       * *           *         68.4   14   127 125                                       14   127
3300333 MO     school 2902970 38046   ALBANY R-III 290297000010 1050 ALBANY HIGH   Regular School No 3 09 12 2016   k_12_total 111 * * *   *       * *           *         59   11   112 111                                     59 11   112
3300334 MO     school 2902970 38046   ALBANY R-III 290297000010 1050 ALBANY HIGH   Regular School No High 09 12 2017   k_12_total 104 * * *   *       * *           *         62.4   13   107 104                                       13   107
3300335 MO     school 2902970 38046   ALBANY R-III 290297000010 1050 ALBANY HIGH   Regular School No High 09 12 2018   k_12_total 110 * * *   *       * *           *         61   12   114 110                                     61 12   114
3300336 MO     school 2902970 38046   ALBANY R-III 290297000010 1050 ALBANY HIGH   Regular School No High 09 12 2019   k_12_total 110 * * *   *       * 5           *         59   12   116 110                   5                 59 12   116
3300337 MO     school 2902970 38046   ALBANY R-III 290297000010 1050 ALBANY HIGH   Regular School No High 09 12 2020   k_12_total 116 * * *   *       * 7           *         62.1   15   124 116                   7                   15   124
3300338 MO     school 2902970 38046   ALBANY R-III 290297001478 3000 ALBANY MIDDLE   Regular School No 2 06 08 2015   k_12_total 79 * * *   *       * *           *         42   6   86 79                                     42 6   86
3300339 MO     school 2902970 38046   ALBANY R-III 290297001478 3000 ALBANY MIDDLE   Regular School No 2 06 08 2016   k_12_total 81 * * *   *       * 5           *         54   9   88 81                   5                 54 9   88
3300340 MO     school 2902970 38046   ALBANY R-III 290297001478 3000 ALBANY MIDDLE   Regular School No Middle 06 08 2017   k_12_total 99 * * *   *       * 6           *         66   13   105 99                   6                 66 13   105
3300341 MO     school 2902970 38046   ALBANY R-III 290297001478 3000 ALBANY MIDDLE   Regular School No Middle 06 08 2018   k_12_total 97 * * *   *       * *           *         61   18   100 97                                     61 18   100
3300342 MO     school 2902970 38046   ALBANY R-III 290297001478 3000 ALBANY MIDDLE   Regular School No Middle 06 08 2019   k_12_total 96 * * *   *       * *           *         71   17   99 96                                     71 17   99
3300343 MO     school 2902970 38046   ALBANY R-III 290297001478 3000 ALBANY MIDDLE   Regular School No Middle 06 08 2020   k_12_total 89 * * *   *       * *           *         56   15   91 89                                     56 15   91
3300344 MO     school 2902970 38046   ALBANY R-III 290297000011 4020 VIRGINIA E. GEORGE ELEM.   Regular School No 1 PK 05 2015   k_12_total 202 * * *   *       * 8           *         130   32   213 202                   8                 130 32   213
3300345 MO     school 2902970 38046   ALBANY R-III 290297000011 4020 VIRGINIA E. GEORGE ELEM.   Regular School No 1 PK 05 2016   k_12_total 201 * * *   *       * 7           *         130   27   210 201                   7                 130 27   210
3300346 MO     school 2902970 38046   ALBANY R-III 290297000011 4020 VIRGINIA E. GEORGE ELEM.   Regular School No Elementary PK 05 2017   k_12_total 193 * * *   *       * *           *         135   28   197 193                                     135 28   197
3300347 MO     school 2902970 38046   ALBANY R-III 290297000011 4020 VIRGINIA E. GEORGE ELEM.   Regular School No Elementary PK 05 2018   k_12_total 178 * * *   *       * 5           *         130   24   184 178                   5                 130 24   184
3300348 MO     school 2902970 38046   ALBANY R-III 290297000011 4020 VIRGINIA E. GEORGE ELEM.   Regular School No Elementary PK 05 2019   k_12_total 194 * * *   *       * *           *         118   28   200 194                                     118 28   200
3300349 MO     school 2902970 38046   ALBANY R-III 290297000011 4020 VIRGINIA E. GEORGE ELEM.   Regular School No Elementary PK 05 2020   k_12_total 186 * * *   *       * 5           *         95   22   195 186                   5                 95 22   195
3070229 MO     school 2900025 48909   ALLEN VILLAGE 290002503233 1980 ALLEN VILLAGE HIGH SCHOOL   Regular School Yes High 09 12 2021   k_12_total                                                   164                                             164
3070230 MO     school 2900025 48909   ALLEN VILLAGE 290002503325 3930 ALLEN VILLAGE JUNIOR   Regular School Yes Middle 06 08 2021   k_12_total                                                   131                                             131
3070231 MO     school 2900025 48909   ALLEN VILLAGE 290002503327 6905 ALLEN VILLAGE PRIMARY   Regular School Yes Elementary KG 02 2021   k_12_total                                                   93                                             93
3070232 MO     school 2900025 48909   ALLEN VILLAGE 290002502748 6915 ALLEN VILLAGE ELEMENTARY   Regular School Yes Elementary 03 05 2021   k_12_total                                                   101                                             101
3070233 MO     school 2900025 48909   ALLEN VILLAGE 290002503379 7500 ALLEN VILLAGE PRESCHOOL   Regular School Yes Prekindergarten PK PK 2021   k_12_total                                                   0                                             0
3302449 MO     school 2900025 48909   ALLEN VILLAGE 290002503233 1980 ALLEN VILLAGE HIGH SCHOOL   Regular School Yes 3 09 12 2015   k_12_total * 66 69 *   *       * *           10         129   8   145   66 69                           10     129 8   145
3302450 MO     school 2900025 48909   ALLEN VILLAGE 290002503233 1980 ALLEN VILLAGE HIGH SCHOOL   Regular School Yes 3 09 12 2016   k_12_total * 63 89 *   *       * *           16         143   9   161   63 89                           16     143 9   161
3302451 MO     school 2900025 48909   ALLEN VILLAGE 290002503233 1980 ALLEN VILLAGE HIGH SCHOOL   Regular School Yes High 09 12 2017   k_12_total * 58 94 *   5       * *           5         145   10   162   58 94     5                     5     145 10   162
3302452 MO     school 2900025 48909   ALLEN VILLAGE 290002503233 1980 ALLEN VILLAGE HIGH SCHOOL   Regular School Yes High 09 12 2018   k_12_total 5 68 100 *   9       * *           13         *   14   186 5 68 100     9                     13       14   186
3302453 MO     school 2900025 48909   ALLEN VILLAGE 290002503233 1980 ALLEN VILLAGE HIGH SCHOOL   Regular School Yes High 09 12 2019   k_12_total 6 57 103 *   8       * 5           19         152   21   179 6 57 103     8         5           19     152 21   179
3302454 MO     school 2900025 48909   ALLEN VILLAGE 290002503233 1980 ALLEN VILLAGE HIGH SCHOOL   Regular School Yes High 09 12 2020   k_12_total * 63 104 *   6       * 5           24         162   21   182   63 104     6         5           24     162 21   182
3302455 MO     school 2900025 48909   ALLEN VILLAGE 290002503325 3930 ALLEN VILLAGE JUNIOR   Regular School Yes Middle 06 08 2019   k_12_total 6 58 85 *   6       * *           20         139   9   159 6 58 85     6                     20     139 9   159
3302456 MO     school 2900025 48909   ALLEN VILLAGE 290002503325 3930 ALLEN VILLAGE JUNIOR   Regular School Yes Middle 06 08 2020   k_12_total 7 41 94 *   5       * *           24         137   8   149 7 41 94     5                     24     137 8   149
3302457 MO     school 2900025 48909   ALLEN VILLAGE 290002503327 6905 ALLEN VILLAGE PRIMARY   Regular School Yes Elementary KG 02 2019   k_12_total * 33 62 *   7       * *           60         101   5   109   33 62     7                     60     101 5   109
3302458 MO     school 2900025 48909   ALLEN VILLAGE 290002503327 6905 ALLEN VILLAGE PRIMARY   Regular School Yes Elementary KG 02 2020   k_12_total * 28 56 *   *       * *           49         85   7   94   28 56                           49     85 7   94
3302459 MO     school 2900025 48909   ALLEN VILLAGE 290002502748 6915 ALLEN VILLAGE SCHOOL   Regular School Yes 1 KG 08 2015   k_12_total 20 188 265 *   12       * 8           140         447   36   494 20 188 265     12         8           140     447 36   494
3302460 MO     school 2900025 48909   ALLEN VILLAGE 290002502748 6915 ALLEN VILLAGE SCHOOL   Regular School Yes 1 KG 08 2016   k_12_total 16 198 273 *   12       * 11           140         474   34   511 16 198 273     12         11           140     474 34   511
3302461 MO     school 2900025 48909   ALLEN VILLAGE 290002502748 6915 ALLEN VILLAGE SCHOOL   Regular School Yes Elementary KG 08 2017   k_12_total 16 152 258 *   15       * 10           105         416   32   451 16 152 258     15         10           105     416 32   451
3302462 MO     school 2900025 48909   ALLEN VILLAGE 290002502748 6915 ALLEN VILLAGE SCHOOL   Regular School Yes Elementary KG 08 2018   k_12_total 14 151 225 *   15       * 14           118         362   30   419 14 151 225     15         14           118     362 30   419
3302463 MO     school 2900025 48909   ALLEN VILLAGE 290002502748 6915 ALLEN VILLAGE ELEMENTARY   Regular School Yes Elementary 03 05 2019   k_12_total * 46 72 *   *       * *           41         110   10   127   46 72                           41     110 10   127
3302464 MO     school 2900025 48909   ALLEN VILLAGE 290002502748 6915 ALLEN VILLAGE ELEMENTARY   Regular School Yes Elementary 03 05 2020   k_12_total * 39 75 *   *       * *           47         111   7   123   39 75                           47     111 7   123
3302407 MO     school 2900029 48902   ALTA VISTA CHARTER SCH. 290002902741 1925 ALTA VISTA CHARTER SCHOOL   Regular School Yes 3 09 12 2015   k_12_total * 9 304 *   *       * *           222         327   26   320   9 304                           222     327 26   320
3302408 MO     school 2900029 48902   ALTA VISTA CHARTER SCH. 290002902741 1925 ALTA VISTA CHARTER SCHOOL   Regular School Yes 3 09 12 2016   k_12_total * 19 334 *   *       * *           255         310   28   359   19 334                           255     310 28   359
3302409 MO     school 2900029 48902   ALTA VISTA CHARTER SCH. 290002902741 1925 ALTA VISTA CHARTER SCHOOL   Regular School Yes High 09 12 2017   k_12_total * 23 334 *   *       * 7           254         332   31   370   23 334               7           254     332 31   370
3302413 MO     school 2900029 48902   ALTA VISTA CHARTER SCH. 290002903166 3925 ALTA VISTA MIDDLE SCHOOL   Regular School Yes 2 06 08 2015   k_12_total 5 7 169 *   *       * 5           144         *   11   186 5 7 169               5           144       11   186
3302414 MO     school 2900029 48902   ALTA VISTA CHARTER SCH. 290002903166 3925 ALTA VISTA MIDDLE SCHOOL   Regular School Yes 2 06 08 2016   k_12_total 6 11 167 *   *       * 11           129         *   11   195 6 11 167               11           129       11   195
3302415 MO     school 2900029 48902   ALTA VISTA CHARTER SCH. 290002903166 3925 ALTA VISTA MIDDLE SCHOOL   Regular School Yes Middle 06 08 2017   k_12_total 5 * 186 *   *       * 7           152         *   17   202 5   186               7           152       17   202
3302419 MO     school 2900029 48902   ALTA VISTA CHARTER SCH. 290002903216 6905 ALTA VISTA ELEMENTARY SCHOOL   Regular School Yes 1 KG 02 2015   k_12_total * 9 172 *   *       * 20           165         211   30   205   9 172               20           165     211 30   205
3302420 MO     school 2900029 48902   ALTA VISTA CHARTER SCH. 290002903216 6905 ALTA VISTA ELEMENTARY SCHOOL   Regular School Yes 1 KG 03 2016   k_12_total 5 8 255 *   *       * 25           235         282   48   295 5 8 255               25           235     282 48   295
3302421 MO     school 2900029 48902   ALTA VISTA CHARTER SCH. 290002903216 6905 ALTA VISTA ELEMENTARY SCHOOL   Regular School Yes Elementary KG 04 2017   k_12_total * 7 320 *   *       * 20           301         330   54   351   7 320               20           301     330 54   351
3070679 MO     school 2903040 79078   ALTENBURG 48 290304000014 4020 ALTENBURG ELEM.   Regular School No Elementary KG 08 2021   k_12_total                                                   89                                             89
3305088 MO     school 2903040 79078   ALTENBURG 48 290304000014 4020 ALTENBURG ELEM.   Regular School No 1 KG 08 2015   k_12_total 90 * * *   *       * *           *         45   19   90 90                                     45 19   90
3305089 MO     school 2903040 79078   ALTENBURG 48 290304000014 4020 ALTENBURG ELEM.   Regular School No 1 KG 08 2016   k_12_total 96 * * *   *       * *           *         46   17   97 96                                     46 17   97
3305090 MO     school 2903040 79078   ALTENBURG 48 290304000014 4020 ALTENBURG ELEM.   Regular School No Elementary KG 08 2017   k_12_total 98 * * *   *       * *           *         29   14   100 98                                     29 14   100
3305091 MO     school 2903040 79078   ALTENBURG 48 290304000014 4020 ALTENBURG ELEM.   Regular School No Elementary KG 08 2018   k_12_total 91 * * *   *       * *           *         23   17   93 91                                     23 17   93
3305092 MO     school 2903040 79078   ALTENBURG 48 290304000014 4020 ALTENBURG ELEM.   Regular School No Elementary KG 08 2019   k_12_total 94 * * *   *       * *           *         20   21   98 94                                     20 21   98
3305093 MO     school 2903040 79078   ALTENBURG 48 290304000014 4020 ALTENBURG ELEM.   Regular School No Elementary KG 08 2020   k_12_total 97 * * *   *       * *           *         28   19   98 97                                     28 19   98
3070640 MO     school 2903060 75087   ALTON R-IV 290306000016 1050 Alton High   Regular School No High 06 12 2021   k_12_total                                                   322                                             322
3070641 MO     school 2903060 75087   ALTON R-IV 290306000015 4020 Alton Elementary   Regular School No Elementary PK 05 2021   k_12_total                                                   263                                             263
3304866 MO     school 2903060 75087   ALTON R-IV 290306000016 1050 Alton High   Regular School No 3 07 12 2015   k_12_total 304 * 7 *   *       * *           *         192.4   53   317 304   7                                   53   317
3304867 MO     school 2903060 75087   ALTON R-IV 290306000016 1050 Alton High   Regular School No 3 07 12 2016   k_12_total 294 * 5 *   *       * *           *         185   51   301 294   5                                 185 51   301
3304868 MO     school 2903060 75087   ALTON R-IV 290306000016 1050 Alton High   Regular School No High 07 12 2017   k_12_total 294 * * *   *       * *           *         170   62   301 294                                     170 62   301
3304869 MO     school 2903060 75087   ALTON R-IV 290306000016 1050 Alton High   Regular School No High 07 12 2018   k_12_total 293 * 5 *   *       * *           *         169.4   57   300 293   5                                   57   300
3304870 MO     school 2903060 75087   ALTON R-IV 290306000016 1050 Alton High   Regular School No High 07 12 2019   k_12_total 306 * * *   *       * *           *         184   64   315 306                                     184 64   315
3304871 MO     school 2903060 75087   ALTON R-IV 290306000016 1050 Alton High   Regular School No High 07 12 2020   k_12_total 300 * * 7   *       * *           *         181.1   48   313 300     7                                 48   313
3304872 MO     school 2903060 75087   ALTON R-IV 290306000015 4020 Alton Elementary   Regular School No 1 KG 06 2015   k_12_total 335 * 5 5   *       * *           *         248.4   65   348 335   5 5                                 65   348
3304873 MO     school 2903060 75087   ALTON R-IV 290306000015 4020 Alton Elementary   Regular School No 1 PK 06 2016   k_12_total 345 * 5 *   *       * *           *         252.3   81   354 345   5                                   81   354
3304874 MO     school 2903060 75087   ALTON R-IV 290306000015 4020 Alton Elementary   Regular School No Elementary PK 06 2017   k_12_total 336 * 7 5   *       * *           *         232.4   69   351 336   7 5                                 69   351
3304875 MO     school 2903060 75087   ALTON R-IV 290306000015 4020 Alton Elementary   Regular School No Elementary PK 06 2018   k_12_total 337 * 7 *   *       * *           *         250   69   347 337   7                                 250 69   347
3304876 MO     school 2903060 75087   ALTON R-IV 290306000015 4020 Alton Elementary   Regular School No Elementary PK 06 2019   k_12_total 357 * * *   *       * *           *         271   65   369 357                                     271 65   369
3304877 MO     school 2903060 75087   ALTON R-IV 290306000015 4020 Alton Elementary   Regular School No Elementary KG 06 2020   k_12_total 354 * * *   *       * *           *         234.3   63   368 354                                       63   368
3070917 MO     school 2903120 93120   APPLETON CITY R-II 290312000019 1050 APPLETON CITY HIGH   Regular School No High 06 12 2021   k_12_total                                                   182                                             182
3070918 MO     school 2903120 93120   APPLETON CITY R-II 290312000017 4010 APPLETON CITY ELEM.   Regular School No Elementary KG 05 2021   k_12_total                                                   147                                             147
3306479 MO     school 2903120 93120   APPLETON CITY R-II 290312000019 1050 APPLETON CITY HIGH   Regular School No 4 06 12 2015   k_12_total 190 * * *   *       * *           *         112   40   200 190                                     112 40   200
3306480 MO     school 2903120 93120   APPLETON CITY R-II 290312000019 1050 APPLETON CITY HIGH   Regular School No 4 06 12 2016   k_12_total 194 * 7 5   *       * *           *         111   33   209 194   7 5                               111 33   209
3306481 MO     school 2903120 93120   APPLETON CITY R-II 290312000019 1050 APPLETON CITY HIGH   Regular School No Other 06 12 2017   k_12_total 180 * 8 5   *       * *           *         112   28   196 180   8 5                               112 28   196
3306482 MO     school 2903120 93120   APPLETON CITY R-II 290312000019 1050 APPLETON CITY HIGH   Regular School No High 06 12 2018   k_12_total 184 * 5 *   *       * *           *         109   21   195 184   5                                 109 21   195
3306483 MO     school 2903120 93120   APPLETON CITY R-II 290312000019 1050 APPLETON CITY HIGH   Regular School No High 06 12 2019   k_12_total 166 * 8 *   *       * *           *         101   19   179 166   8                                 101 19   179
3306484 MO     school 2903120 93120   APPLETON CITY R-II 290312000019 1050 APPLETON CITY HIGH   Regular School No High 06 12 2020   k_12_total 163 * 5 6   *       * *           *         78   19   177 163   5 6                               78 19   177
3306485 MO     school 2903120 93120   APPLETON CITY R-II 290312000017 4010 APPLETON CITY ELEM.   Regular School No 1 KG 05 2015   k_12_total 124 8 * 5   *       * *           *         94   27   141 124 8   5                               94 27   141
3306486 MO     school 2903120 93120   APPLETON CITY R-II 290312000017 4010 APPLETON CITY ELEM.   Regular School No 1 KG 05 2016   k_12_total 120 * * *   *       * *           *         85   30   127 120                                     85 30   127
3306487 MO     school 2903120 93120   APPLETON CITY R-II 290312000017 4010 APPLETON CITY ELEM.   Regular School No Elementary PK 05 2017   k_12_total 135 * * *   *       * *           *         91   27   142 135                                     91 27   142
3306488 MO     school 2903120 93120   APPLETON CITY R-II 290312000017 4010 APPLETON CITY ELEM.   Regular School No Elementary PK 05 2018   k_12_total 147 * * *   *       * *           *         88   30   153 147                                     88 30   153
3306489 MO     school 2903120 93120   APPLETON CITY R-II 290312000017 4010 APPLETON CITY ELEM.   Regular School No Elementary PK 05 2019   k_12_total 141 * * *   *       * *           *         77   23   147 141                                     77 23   147
3306490 MO     school 2903120 93120   APPLETON CITY R-II 290312000017 4010 APPLETON CITY ELEM.   Regular School No Elementary PK 05 2020   k_12_total 145 * * *   *       * *           *         69   20   149 145                                     69 20   149
3070041 MO     school 2903150 47062   ARCADIA VALLEY R-II 290315000022 1050 ARCADIA VALLEY HIGH   Regular School No High 09 12 2021   k_12_total                                                   331                                             331
3070042 MO     school 2903150 47062   ARCADIA VALLEY R-II 290315000023 3000 ARCADIA VALLEY MIDDLE   Regular School No Middle 05 08 2021   k_12_total                                                   267                                             267
3070043 MO     school 2903150 47062   ARCADIA VALLEY R-II 290315000021 4020 ARCADIA VALLEY ELEM.   Regular School No Elementary PK 04 2021   k_12_total                                                   322                                             322

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