Data source: Big Local News · About: Big Local

37,120 rows where state = "MO" and year = 2020 sorted by free_and_reduced descending

View and edit SQL

grade

year

  • 2020 · 37,120
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
3297334 MO     school 2908400 10091   CENTRALIA R-VI 290840000244 1050 CENTRALIA HIGH   Regular School No High 09 12 2020   k_12_total 413 * 8 *   *       * 12           *         99   41   439 413   8               12                 99 41   439
3299103 MO     school 2918540 24090   LIBERTY 53 291854002902 4180 WARREN HILLS ELEM.   Regular School No Elementary KG 05 2020   k_12_total 470 32 57 *   21       * 36           32         99   53   617 470 32 57     21         36           32     99 53   617
3299185 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280003335 4020 RISING HILL ELEMENTARY   Regular School No Elementary KG 05 2020   k_12_total 237 16 32 *   *       * 31           *         99   30   320 237 16 32               31                 99 30   320
3306376 MO     school 2931650 92089   WENTZVILLE R-IV 293165003155 4110 DISCOVERY RIDGE ELEMENTARY   Regular School No Elementary KG 06 2020   k_12_total 698 29 44 *   21       * 33           27         99   107   825 698 29 44     21         33           27     99 107   825
3307289 MO     school 2916770 96092   KIRKWOOD R-VII 291677000921 5060 GEORGE R. ROBINSON ELEM.   Regular School No Elementary KG 05 2020   k_12_total 364 74 19 *   10       * 41           *         99   76   509 364 74 19     10         41                 99 76   509
3307331 MO     school 2918690 96093   LINDBERGH SCHOOLS 291869001018 4040 CRESTWOOD ELEM.   Regular School No Elementary KG 05 2020   k_12_total 370 23 22 *   13       * 33           30         99   88   461 370 23 22     13         33           30     99 88   461
3307427 MO     school 2920670 96094   MEHLVILLE R-IX 292067001097 4090 HAGEMANN ELEM.   Regular School No Elementary KG 05 2020   k_12_total 319 19 12 *   12       * 25           52         99   77   391 319 19 12     12         25           52     99 77   391
3307460 MO     school 2920670 96094   MEHLVILLE R-IX 292067001124 5100 WOHLWEND ELEM.   Regular School No Elementary KG 05 2020   k_12_total 367 30 15 *   10       * 9           47         99   72   431 367 30 15     10         9           47     99 72   431
3306696 MO     school 2913830 96088   HAZELWOOD 291383000625 1075 HAZELWOOD WEST HIGH   Regular School No High 09 12 2020   k_12_total 650 1282 66 *   35       7 62           52         985   336   2104 650 1282 66     35       7 62           52     985 336   2104
3304638 MO     school 2910800 73102   DIAMOND R-IV 291080000366 1050 DIAMOND HIGH   Regular School No High 09 12 2020   k_12_total 213 * * *   *       * 5           *         98.4   29   231 213                   5                   29   231
3297370 MO     school 2913710 10092   HARRISBURG R-VIII 291371000598 4020 HARRISBURG ELEM.   Regular School No Elementary PK 05 2020   k_12_total 230 6 5 *   *       * *           *         98   26   244 230 6 5                                 98 26   244
3298475 MO     school 2925330 19148   PLEASANT HILL R-III 292533001460 4020 PLEASANT HILL PRIMARY   Regular School No Elementary PK 02 2020   k_12_total 430 * 18 *   *       * 22           *         98   42   474 430   18               22                 98 42   474
3303568 MO     school 2925110 55105   PIERCE CITY R-VI 292511001441 1050 PIERCE CITY HIGH   Regular School No High 09 12 2020   k_12_total 229 * * *   8       * *           *         98   26   245 229         8                           98 26   245
3305322 MO     school 2919260 82108   LOUISIANA R-II 291926001043 1050 LOUISIANA HIGH   Regular School No High 09 12 2020   k_12_total 172 14 17 *   *       * 17           5         98   11   221 172 14 17               17           5     98 11   221
3305970 MO     school 2921720 91091   NAYLOR R-II 292172001198 1050 NAYLOR HIGH   Regular School No High 07 12 2020   k_12_total 161 9 * *   *       * *           *         98   27   179 161 9                                   98 27   179
3308328 MO     school 2929880 97131   SWEET SPRINGS R-VII 292988002062 4020 SWEET SPRINGS ELEM.   Regular School No Elementary PK 06 2020   k_12_total 189 * * *   *       * *           *         98   35   194 189                                     98 35   194
3308097 MO     school 2930690 96113   VALLEY PARK 293069002116 1050 VALLEY PARK SR. HIGH   Regular School No High 09 12 2020   k_12_total 164 69 14 *   7       * 11           6         97.1   34   269 164 69 14     7         11           6       34   269
3304907 MO     school 2931830 76083   OSAGE CO. R-III 293183002226 1050 FATIMA HIGH   Regular School No High 07 12 2020   k_12_total 514 * * *   *       * *           *         97   47   518 514                                     97 47   518
3308334 MO     school 2927660 98080   SCHUYLER CO. R-I 292766001702 1050 SCHUYLER CO. HIGH   Regular School No High 07 12 2020   k_12_total 230 * * *   *       * 6           *         97   29   240 230                   6                 97 29   240
3308578 MO     school 2925650 103130   PUXICO R-VIII 292565001508 1050 PUXICO HIGH   Regular School No High 09 12 2020   k_12_total 192 * * *   *       * *           *         97   28   194 192                                     97 28   194
3296780 MO     school 2927570 2097   SAVANNAH R-III 292757001690 4020 JOHN GLENN ELEM.   Regular School No Elementary KG 05 2020   k_12_total 251 5 9 *   *       * 5           *         96   37   270 251 5 9               5                 96 37   270
3301096 MO     school 2931460 43003   WEAUBLEAU R-III 293146002181 1050 WEAUBLEAU HIGH   Regular School No High 07 12 2020   k_12_total 172 * 8 *   5       * *           *         96   10   188 172   8     5                           96 10   188
3307205 MO     school 2926850 96091   ROCKWOOD R-VI 292685001628 4140 WESTRIDGE ELEM.   Regular School No Elementary KG 05 2020   k_12_total 289 34 29 *   69       * 25           31         96   75   446 289 34 29     69         25           31     96 75   446
3298172 MO     school 2915600 16090   JACKSON R-II 291560000739 4160 WEST LANE ELEM.   Regular School No Elementary KG 04 2020   k_12_total 307 5 * *   *       * 10           *         95.1   49   326 307 5                 10                   49   326
3298334 MO     school 2911100 18047   EAST CARTER CO. R-II 291110002916 3000 EAST CARTER CO. R-II MIDDLE   Regular School No Middle 06 08 2020   k_12_total 131 * * *   *       * 9           *         95   16   141 131                   9                 95 16   141
3298439 MO     school 2910320 19144   SHERWOOD CASS R-VIII 291032000335 1050 SHERWOOD HIGH   Regular School No High 09 12 2020   k_12_total 232 * 7 *   *       * *           *         95   29   244 232   7                                 95 29   244
3298680 MO     school 2927520 21151   SALISBURY R-IV 292752001685 1050 SALISBURY HIGH   Regular School No High 07 12 2020   k_12_total 221 9 5 *   *       * *           *         95   26   237 221 9 5                                 95 26   237
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
3300718 MO     school 2928860 39141   SPRINGFIELD R-XII 292886002306 4380 MCBRIDE ELEM.   Regular School No Elementary PK 04 2020   k_12_total 368 16 23 *   15       * 19           16         95   35   444 368 16 23     15         19           16     95 35   444
3305493 MO     school 2923550 83005   PARK HILL 292355002841 5080 HAWTHORN ELEM.   Regular School No Elementary KG 05 2020   k_12_total 392 45 47 *   14       6 16           23         95   62   521 392 45 47     14       6 16           23     95 62   521
3307061 MO     school 2923700 96090   PATTONVILLE R-III 292370001420 6020 ROSE ACRES ELEM.   Regular School No Elementary PK 05 2020   k_12_total 221 58 46 *   11       * 39           27         95   82   376 221 58 46     11         39           27     95 82   376
3308564 MO     school 2902880 103129   ADVANCE R-IV 290288000004 1050 ADVANCE HIGH   Regular School No High 07 12 2020   k_12_total 195 * * *   *       * *           *         95   26   198 195                                     95 26   198
3297103 MO     school 2926310 7124   RICH HILL R-IV 292631001544 1050 RICH HILL HIGH   Regular School No High 07 12 2020   k_12_total 144 * * *   *       * *           *         94   16   150 144                                     94 16   150
3297346 MO     school 2908400 10091   CENTRALIA R-VI 290840000242 4020 CHANCE ELEM.   Regular School No Elementary PK 02 2020   k_12_total 272 * 8 *   *       * 14           *         94   28   299 272   8               14                 94 28   299
3298445 MO     school 2910320 19144   SHERWOOD CASS R-VIII 291032001610 3000 SHERWOOD MIDDLE   Regular School No Middle 06 08 2020   k_12_total 180 * 5 *   *       * 7           *         94   34   193 180   5               7                 94 34   193
3298463 MO     school 2925330 19148   PLEASANT HILL R-III 292533001461 1050 PLEASANT HILL HIGH   Regular School No High 09 12 2020   k_12_total 616 * 23 *   *       * 25           *         94   55   673 616   23               25                 94 55   673
3304951 MO     school 2910950 77103   DORA R-III 291095000375 1050 DORA HIGH   Regular School No High 07 12 2020   k_12_total 165 * * *   *       * *           *         94   37   165 165                                     94 37   165
3304957 MO     school 2910950 77103   DORA R-III 291095000374 4020 DORA ELEM.   Regular School No Elementary PK 06 2020   k_12_total 127 * * *   *       * *           *         94   25   130 127                                     94 25   130
3307235 MO     school 2926850 96091   ROCKWOOD R-VI 292685002700 4165 WILD HORSE ELEM.   Regular School No Elementary KG 05 2020   k_12_total 220 41 59 *   231       * 14           120         94   81   567 220 41 59     231         14           120     94 81   567
3308480 MO     school 2932220 101105   WINONA R-III 293222002260 1050 WINONA HIGH   Regular School No High 09 12 2020   k_12_total 127 * * *   *       * *           *         94   25   128 127                                     94 25   128
3308474 MO     school 2923130 100065   ORAN R-III 292313001326 4020 ORAN ELEMENTARY SCHOOL   Regular School No Elementary KG 06 2020   k_12_total 158 * * *   *       * 10           *         93.2   29   169 158                   10                   29   169
3297495 MO     school 2901000 10093   COLUMBIA 93 290100000308 5020 Locust St Expressive Arts Elem   Regular School No Elementary PK 05 2020   k_12_total 97 46 6 *   28       * 23           39         93   13   201 97 46 6     28         23           39     93 13   201
3298155 MO     school 2915600 16090   JACKSON R-II 291560000736 4110 NORTH ELEM.   Regular School No Elementary KG 04 2020   k_12_total 224 * * *   *       * 9           *         93   29   242 224                   9                 93 29   242
3298196 MO     school 2923070 16094   OAK RIDGE R-VI 292307001320 4020 OAK RIDGE ELEM.   Regular School No Elementary PK 06 2020   k_12_total 193 * * *   *       * *           *         93   12   196 193                                     93 12   196
3301066 MO     school 2914320 43001   HICKORY CO. R-I 291432002372 1050 SKYLINE HIGH   Regular School No High 09 12 2020   k_12_total 207 * * *   *       * *           *         93   14   218 207                                     93 14   218
3304506 MO     school 2921330 70093   MONTGOMERY CO. R-II 292133001170 4040 JONESBURG ELEM.   Regular School No Elementary PK 05 2020   k_12_total 159 * 6 *   *       * 8           *         93   20   177 159   6               8                 93 20   177
3305310 MO     school 2925140 82101   PIKE CO. R-III 292514001444 4020 CLOPTON ELEM.   Regular School No Elementary PK 06 2020   k_12_total 192 * * *   *       * *           *         93   30   201 192                                     93 30   201
3298546 MO     school 2931800 19151   MIDWAY R-I 293180002223 4020 MIDWAY ELEM.   Regular School No Elementary KG 06 2020   k_12_total 225 * 8 *   *       * 8           *         92   43   244 225   8               8                 92 43   244
3299109 MO     school 2918540 24090   LIBERTY 53 291854003113 4200 KELLYBROOK ELEM SCHOOL   Regular School No Elementary KG 05 2020   k_12_total 425 31 57 *   *       * 36           *         92   44   555 425 31 57               36                 92 44   555
3305123 MO     school 2928380 80119   SMITHTON R-VI 292838001752 1050 SMITHTON HIGH   Regular School No High 07 12 2020   k_12_total 263 * 12 *   *       * 5           12         92   36   282 263   12               5           12     92 36   282
3303706 MO     school 2911400 57002   ELSBERRY R-II 291140000407 1050 ELSBERRY HIGH   Regular School No High 09 12 2020   k_12_total 206 * 10 *   *       * 6           *         91.4   19   228 206   10               6                   19   228
3297340 MO     school 2908400 10091   CENTRALIA R-VI 290840000243 3000 CHESTER BOREN MIDDLE   Regular School No Middle 06 08 2020   k_12_total 310 * 5 *   *       * 7           *         91   43   323 310   5               7                 91 43   323
3299061 MO     school 2918540 24090   LIBERTY 53 291854001005 4040 FRANKLIN ELEM.   Regular School No Elementary KG 05 2020   k_12_total 218 12 27 *   *       * 25           *         91   20   283 218 12 27               25                 91 20   283
3299394 MO     school 2926970 26001   COLE CO. R-I 292697001638 4020 COLE CO. R-I ELEM.   Regular School No Elementary PK 05 2020   k_12_total 237 * * *   *       * 6           *         91   34   249 237                   6                 91 34   249
3299424 MO     school 2911550 26005   COLE CO. R-V 291155000410 4020 EUGENE ELEM.   Regular School No Elementary PK 06 2020   k_12_total 326 * 6 *   *       * 7           *         91   29   342 326   6               7                 91 29   342
3309012 MO     school 2921840 108142   NEVADA R-V 292184001211 4020 BENTON ELEM.   Regular School No Elementary 02 02 2020   k_12_total 151 * 5 *   *       * 7           *         91   16   166 151   5               7                 91 16   166
3303592 MO     school 2920310 55106   MARIONVILLE R-IX 292031003139 3000 MARIONVILLE MIDDLE   Regular School No Middle 06 08 2020   k_12_total 150 * 6 *   *       * *           *         90.2   19   156 150   6                                   19   156
3297855 MO     school 2913590 13055   HAMILTON R-II 291359000580 1050 PENNEY HIGH   Regular School No High 09 12 2020   k_12_total 209 * * *   *       * 6           *         90   24   222 209                   6                 90 24   222
3299245 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001272 4280 GASHLAND ELEMENTARY   Regular School No Elementary PK 01 2020   k_12_total 145 26 38 *   *       * 25           23         90   15   239 145 26 38               25           23     90 15   239
3301992 MO     school 2915480 48077   INDEPENDENCE 30 291548000724 1075 WILLIAM CHRISMAN HIGH   Regular School No High 09 12 2020   k_12_total 847 181 217 15   14       25 114           40         897   150   1413 847 181 217 15   14       25 114           40     897 150   1413
3306190 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895000220 3200 FRANCIS HOWELL MIDDLE   Regular School No Middle 06 08 2020   k_12_total 718 37 33 *   43       * 30           6         89.4   120   862 718 37 33     43         30           6       120   862
3303460 MO     school 2910080 54037   CONCORDIA R-II 291008000322 1050 CONCORDIA HIGH   Regular School No High 07 12 2020   k_12_total 170 * 10 *   *       * *           5         89   17   187 170   10                           5     89 17   187
3308739 MO     school 2905280 104045   BLUE EYE R-V 290528001900 3000 BLUE EYE MIDDLE   Regular School No Middle 05 08 2020   k_12_total 142 * * *   *       * 6           *         89   36   153 142                   6                 89 36   153
3308982 MO     school 2925210 107156   PLATO R-V 292521001450 1050 PLATO HIGH   Regular School No High 06 12 2020   k_12_total 261 * * *   *       * 8           *         89   34   275 261                   8                 89 34   275
3309195 MO     school 2913380 111086   GREENVILLE R-II 291338000569 1050 GREENVILLE HIGH   Regular School No High 09 12 2020   k_12_total 180 * 6 *   *       * *           *         89   25   189 180   6                                 89 25   189
3297352 MO     school 2908400 10091   CENTRALIA R-VI 290840003092 4050 CENTRALIA INTERMEDIATE   Regular School No Elementary 03 05 2020   k_12_total 281 * 6 *   *       * 8           *         88.4   38   297 281   6               8                   38   297
3307943 MO     school 2926640 96110   RITENOUR 292664001568 4100 IVELAND ELEM.   Regular School No Elementary KG 05 2020   k_12_total 147 191 97 *   *       * 43           65         88.4   98   481 147 191 97               43           65       98   481
3299067 MO     school 2918540 24090   LIBERTY 53 291854001007 4060 LEWIS AND CLARK ELEM.   Regular School No Elementary KG 05 2020   k_12_total 478 18 41 *   18       * 43           10         88   47   600 478 18 41     18         43           10     88 47   600
3301084 MO     school 2931920 43002   WHEATLAND R-II 293192002235 1050 WHEATLAND HIGH   Regular School No High 07 12 2020   k_12_total 131 * * *   *       * *           *         88   12   133 131                                     88 12   133
3305111 MO     school 2916920 80118   LA MONTE R-IV 291692000937 1050 LA MONTE HIGH   Regular School No High 07 12 2020   k_12_total 77 * 54 *   *       * *           35         88   10   137 77   54                           35     88 10   137
3307055 MO     school 2923700 96090   PATTONVILLE R-III 292370001419 6000 TRADITIONAL SCH.   Regular School No Elementary KG 08 2020   k_12_total 209 87 40 *   22       * 27           33         88   75   387 209 87 40     22         27           33     88 75   387
3307587 MO     school 2923580 96095   PARKWAY C-2 292358001391 4180 MCKELVEY ELEM.   Regular School No Elementary KG 05 2020   k_12_total 200 92 40 8   298       * 38           123         88   88   676 200 92 40 8   298         38           123     88 88   676
3299133 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280001284 1050 NORTH KANSAS CITY HIGH   Regular School No High 09 12 2020   k_12_total 608 341 311 5   121       29 168           143         874.2   150   1583 608 341 311 5   121       29 168           143       150   1583
3298292 MO     school 2907380 17125   CARROLLTON R-VII 290738000202 1050 CARROLLTON SENIOR HIGH   Regular School No High 09 12 2020   k_12_total 230 * 6 *   *       * 7           *         87.4   32   244 230   6               7                   32   244
3297189 MO     school 2909900 8111   COLE CAMP R-I 290990000293 1050 COLE CAMP HIGH   Regular School No High 09 12 2020   k_12_total 207 * 7 *   *       * 5           *         87   14   219 207   7               5                 87 14   219
3299803 MO     school 2920550 32055   MAYSVILLE R-I 292055001099 1050 MAYSVILLE JR.-SR. HIGH   Regular School No High 07 12 2020   k_12_total 249 * * *   *       * *           *         87   30   258 249                                     87 30   258
3302951 MO     school 2913170 50002   GRANDVIEW R-II 291317002285 1050 GRANDVIEW HIGH   Regular School No High 09 12 2020   k_12_total 303 * 6 *   *       * *           *         87   46   316 303   6                                 87 46   316
3307352 MO     school 2918690 96093   LINDBERGH SCHOOLS 291869001025 5060 SAPPINGTON ELEM.   Regular School No Elementary KG 05 2020   k_12_total 442 14 28 *   26       * 13           53         87   88   523 442 14 28     26         13           53     87 88   523
3308558 MO     school 2904530 103128   BELL CITY R-II 290453000046 4020 BELL CITY ELEM.   Regular School No Elementary KG 06 2020   k_12_total 103 8 * *   *       * *           *         87   12   114 103 8                                   87 12   114
3310049 MO     school 2900614 115930   THE ARCH COMMUNITY SCHOOL 290061403302 6905 THE ARCH COMMUNITY SCHOOL   Regular School Yes Elementary KG 05 2020   k_12_total * 93 * *   *       * *           *         87   21   99   93                                   87 21   99
3306684 MO     school 2913830 96088   HAZELWOOD 291383000622 1050 HAZELWOOD CENTRAL HIGH   Regular School No High 09 12 2020   k_12_total 104 1617 31 *   20       * 7           22         866.3   276   1782 104 1617 31     20         7           22       276   1782
3297292 MO     school 2913560 10089   HALLSVILLE R-IV 291356000578 1050 HALLSVILLE HIGH   Regular School No High 09 12 2020   k_12_total 373 5 14 *   *       * 14           *         86.4   34   408 373 5 14               14                   34   408
3298929 MO     school 2916450 24086   KEARNEY R-I 291645000891 4040 KEARNEY ELEM.   Regular School No Elementary KG 05 2020   k_12_total 243 * 11 *   *       * 9           *         86   33   269 243   11               9                 86 33   269
3304932 MO     school 2904140 77101   BAKERSFIELD R-IV 290414000039 4020 BAKERSFIELD ELEM.   Regular School No Elementary PK 05 2020   k_12_total 135 * * *   *       * *           *         86   22   135 135                                     86 22   135
3305808 MO     school 2931860 88080   WESTRAN R-I 293186002232 1050 WESTRAN HIGH   Regular School No High 09 12 2020   k_12_total 164 * * *   *       * 8           *         86   21   179 164                   8                 86 21   179
3308757 MO     school 2913230 105123   GREEN CITY R-I 291323000560 4020 GREEN CITY ELEM.   Regular School No Elementary PK 06 2020   k_12_total 131 * 7 *   *       * *           *         86   18   143 131   7                                 86 18   143
3300730 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001810 4460 PERSHING ELEM.   Regular School No Elementary KG 05 2020   k_12_total 128 13 11 *   *       * 10           5         85.3   30   166 128 13 11               10           5       30   166
3300922 MO     school 2900002 41002   SOUTH HARRISON CO. R-II 290000201642 1050 SOUTH HARRISON HIGH   Regular School No High 09 12 2020   k_12_total 231 * * *   *       * *           *         85.3   22   233 231                                       22   233
3304913 MO     school 2931830 76083   OSAGE CO. R-III 293183002229 4060 FATIMA ELEM.   Regular School No Elementary PK 06 2020   k_12_total 275 * * *   *       * *           *         85.1   41   278 275                                       41   278
3300234 MO     school 2931110 36139   WASHINGTON 293111002158 4060 CLEARVIEW ELEM.   Regular School No Elementary KG 06 2020   k_12_total 305 * * *   *       * 6           *         85   35   316 305                   6                 85 35   316
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
3305475 MO     school 2923550 83005   PARK HILL 292355001374 5020 UNION CHAPEL ELEM.   Regular School No Elementary KG 05 2020   k_12_total 437 39 35 *   7       * 34           6         85   44   554 437 39 35     7         34           6     85 44   554
3306208 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895001854 4020 BECKY-DAVID ELEM.   Regular School No Elementary PK 05 2020   k_12_total 655 22 47 *   34       * 34           58         85   75   793 655 22 47     34         34           58     85 75   793
3306262 MO     school 2928950 92088   FRANCIS HOWELL R-III 292895002822 5040 WARREN ELEM.   Regular School No Elementary KG 05 2020   k_12_total 685 35 36 *   32       * 45           36         85   89   836 685 35 36     32         45           36     85 89   836
3308608 MO     school 2905250 103131   BLOOMFIELD R-XIV 290525000073 1050 BLOOMFIELD HIGH   Regular School No High 09 12 2020   k_12_total 191 * * *   *       * *           *         85   17   196 191                                     85 17   196
3297286 MO     school 2928560 10087   SOUTHERN BOONE CO. R-I 292856001765 4020 SOUTHERN BOONE ELEM.   Regular School No Elementary 03 05 2020   k_12_total 399 * 12 *   *       * 21           *         84   41   438 399   12               21                 84 41   438
3297587 MO     school 2911250 11076   EAST BUCHANAN CO. C-1 291125000390 4040 EAST BUCHANAN ELEM.   Regular School No Elementary PK 05 2020   k_12_total 303 * * *   *       * 11           *         84   60   319 303                   11                 84 60   319
3298698 MO     school 2908430 22088   CHADWICK R-I 290843000245 4020 CHADWICK ELEMENTARY   Regular School No Elementary PK 06 2020   k_12_total 131 * * *   *       * *           *         84   30   132 131                                     84 30   132
3299863 MO     school 2923040 33091   OAK HILL R-I 292304001319 4020 OAK HILL ELEM.   Regular School No Elementary PK 08 2020   k_12_total 114 * 5 *   *       * *           *         84   17   121 114   5                                 84 17   121
3300682 MO     school 2928860 39141   SPRINGFIELD R-XII 292886001797 4280 HICKORY HILLS ELEM.   Regular School No Elementary KG 05 2020   k_12_total 340 5 22 *   14       * 5           43         84   25   392 340 5 22     14         5           43     84 25   392

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