Data source: Big Local News · About: Big Local

2,320 rows where grade = "k_12_total", state = "MO" and year = 2020 sorted by free_and_reduced

View and edit SQL

year

  • 2020 · 2,320

grade

  • k_12_total · 2,320
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
3296792 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3296864 MO     school 2920810 4110   MEXICO 59 292081001136 2050 MEXICO MIDDLE   Regular School No Middle 06 08 2020   k_12_total 408 28 55 *   *       * 51           20         *   75   543 408 28 55               51           20       75   543
3296870 MO     school 2920810 4110   MEXICO 59 292081001132 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 05 2020   k_12_total 284 51 27 *   *       * 50           15         *   50   416 284 51 27               50           15       50   416
3296876 MO     school 2920810 4110   MEXICO 59 292081001133 4060 HAWTHORNE ELEM.   Regular School No Elementary 01 05 2020   k_12_total 322 30 47 *   *       * 44           28         *   53   444 322 30 47               44           28       53   444
3296882 MO     school 2920810 4110   MEXICO 59 292081001134 4080 MCMILLAN EARLY LEARNING CENTER   Regular School No Elementary PK KG 2020   k_12_total 151 13 16 *   *       * 18           12         *   39   199 151 13 16               18           12       39   199
3296965 MO     school 2928200 5127   SHELL KNOB 78 292820003350 1010 TRI-LAKES SPECL. EDUC. COOP.   Regular School No Other PK 12 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3296971 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No Elementary PK 08 2020   k_12_total 72 * * *   *       * 60           *         *   21   133 72                   60                   21   133
3297037 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No Other PK 12 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297127 MO     school 2915240 7126   HUDSON R-IX 291524000693 4020 HUDSON ELEM.   Regular School No Elementary PK 08 2020   k_12_total 36 * * *   *       * *           *         *   *   36 36                                           36
3297142 MO     school 2906360 7129   BUTLER R-V 290636003308 7500 BUTLER EARLY CHILDHOOD   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297160 MO     school 2931070 8107   WARSAW R-IX 293107002152 1050 WARSAW HIGH   Regular School No High 09 12 2020   k_12_total 368 * * *   *       * *           *         *   75   378 368                                       75   378
3297166 MO     school 2931070 8107   WARSAW R-IX 293107002650 3000 JOHN BOISE MIDDLE   Regular School No Middle 06 08 2020   k_12_total 273 * 8 *   *       * 13           *         *   67   295 273   8               13                   67   295
3297172 MO     school 2931070 8107   WARSAW R-IX 293107002153 4020 NORTH ELEM.   Regular School No Elementary KG 05 2020   k_12_total 318 * 8 *   *       * 14           *         *   81   348 318   8               14                   81   348
3297178 MO     school 2931070 8107   WARSAW R-IX 293107002154 4040 SOUTH ELEM.   Regular School No Elementary PK 05 2020   k_12_total 140 * * *   *       * 5           *         *   23   150 140                   5                   23   150
3297206 MO     school 2909900 8111   COLE CAMP R-I 290990003248 7500 COLE CAMP PRESCHOOL   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297238 MO     school 2932490 9079   ZALMA R-V 293249002270 1050 ZALMA HIGH   Regular School No High 07 12 2020   k_12_total 109 * * *   *       * *           *         *   15   113 109                                       15   113
3297244 MO     school 2932490 9079   ZALMA R-V 293249002269 4020 ZALMA ELEM.   Regular School No Elementary KG 06 2020   k_12_total 112 * * *   *       * *           *         *   18   112 112                                       18   112
3297382 MO     school 2901000 10093   COLUMBIA 93 290100002281 1020 FREDERICK DOUGLASS HIGH   Alternative School No Other PK 12 2020   k_12_total 44 54 17 *   6       * 8           53         *   8   130 44 54 17     6         8           53       8   130
3297442 MO     school 2901000 10093   COLUMBIA 93 290100000313 4020 THOMAS BENTON ELEM.   Regular School No Elementary PK 05 2020   k_12_total 88 94 * *   *       * 33           *         *   33   219 88 94                 33                   33   219
3297448 MO     school 2901000 10093   COLUMBIA 93 290100003152 4030 ALPHA HART LEWIS   Regular School No Elementary PK 05 2020   k_12_total 147 135 13 *   6       * 76           13         *   49   380 147 135 13     6         76           13       49   380
3297454 MO     school 2901000 10093   COLUMBIA 93 290100000298 4040 BLUE RIDGE ELEM.   Regular School No Elementary PK 05 2020   k_12_total 135 144 111 *   14       * 43           103         *   52   448 135 144 111     14         43           103       52   448
3297466 MO     school 2901000 10093   COLUMBIA 93 290100002665 4055 DERBY RIDGE ELEM.   Regular School No Elementary PK 05 2020   k_12_total 151 176 47 *   30       * 60           69         *   81   466 151 176 47     30         60           69       81   466
3297477 MO     school 2901000 10093   COLUMBIA 93 290100003271 4070 ELIOT BATTLE ELEMENTARY   Regular School No Elementary KG 05 2020   k_12_total 186 158 23 *   5       * 52           33         *   55   427 186 158 23     5         52           33       55   427
3297553 MO     school 2901000 10093   COLUMBIA 93 290100000316 6020 WEST BLVD. ELEM.   Regular School No Elementary PK 05 2020   k_12_total 112 128 19 *   7       * 45           28         *   50   312 112 128 19     7         45           28       50   312
3297565 MO     school 2901000 10093   COLUMBIA 93 290100001598 6080 Center for Gifted Education   Regular School No Elementary 01 05 2020   k_12_total 31 * * *   *       * *           *         *   *   40 31                                           40
3297569 MO     school 2901000 10093   COLUMBIA 93 290100003287 7500 CENTER FOR EARLY LRNING-NORTH   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297635 MO     school 2927060 11082   ST. JOSEPH 292706001670 3000 ROBIDOUX MIDDLE   Regular School No Middle 06 08 2020   k_12_total 306 34 45 *   5       6 45           30         *   61   442 306 34 45     5       6 45           30       61   442
3297647 MO     school 2927060 11082   ST. JOSEPH 292706001673 3020 SPRING GARDEN MIDDLE   Regular School No Middle 06 08 2020   k_12_total 415 16 50 7   *       6 41           41         *   68   537 415 16 50 7           6 41           41       68   537
3297653 MO     school 2927060 11082   ST. JOSEPH 292706001674 3050 TRUMAN MIDDLE   Regular School No Middle 07 08 2020   k_12_total 357 25 49 *   *       * 47           18         *   91   485 357 25 49               47           18       91   485
3297659 MO     school 2927060 11082   ST. JOSEPH 292706001649 4040 EDISON ELEM.   Regular School No Elementary PK 06 2020   k_12_total 159 57 78 *   *       17 60           79         *   47   375 159 57 78             17 60           79       47   375
3297671 MO     school 2927060 11082   ST. JOSEPH 292706003250 4070 CARDEN PARK ELEM   Regular School No Elementary KG 06 2020   k_12_total 429 47 64 *   *       10 55           62         *   101   606 429 47 64             10 55           62       101   606
3297689 MO     school 2927060 11082   ST. JOSEPH 292706001654 4140 COLEMAN ELEM.   Regular School No Elementary KG 06 2020   k_12_total 165 63 41 *   25       38 37           107         *   37   369 165 63 41     25       38 37           107       37   369
3297695 MO     school 2927060 11082   ST. JOSEPH 292706001657 4180 HOSEA ELEM.   Regular School No Elementary KG 05 2020   k_12_total 358 14 63 *   *       15 37           70         *   46   489 358 14 63             15 37           70       46   489
3297715 MO     school 2927060 11082   ST. JOSEPH 292706001662 4260 LINDBERGH ELEM.   Regular School No Elementary KG 05 2020   k_12_total 353 31 49 *   *       18 62           47         *   50   515 353 31 49             18 62           47       50   515
3297721 MO     school 2927060 11082   ST. JOSEPH 292706001663 4280 MARK TWAIN ELEM.   Regular School No Elementary KG 06 2020   k_12_total 244 30 24 *   6       * 48           24         *   33   355 244 30 24     6         48           24       33   355
3297727 MO     school 2927060 11082   ST. JOSEPH 292706001667 4390 PARKWAY ELEM.   Regular School No Elementary KG 06 2020   k_12_total 311 15 21 *   *       7 37           16         *   33   396 311 15 21             7 37           16       33   396
3297739 MO     school 2927060 11082   ST. JOSEPH 292706001669 4420 PICKETT ELEM.   Regular School No Elementary PK 06 2020   k_12_total 232 10 15 *   *       * 31           5         *   33   291 232 10 15               31           5       33   291
3297781 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001467 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 03 2020   k_12_total 234 45 6 *   *       * 20           *         *   52   307 234 45 6               20                   52   307
3297793 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001471 4080 LAKE ROAD ELEM.   Regular School No Elementary 01 05 2020   k_12_total 224 49 * *   *       * 34           *         *   61   310 224 49                 34                   61   310
3297799 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001472 5020 POPLAR BLUFF KINDERGARTEN CTR.   Regular School No Elementary KG KG 2020   k_12_total 273 45 8 *   *       * 30           *         *   43   359 273 45 8               30                   43   359
3297805 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001474 5040 OAK GROVE ELEM.   Regular School No Elementary 01 03 2020   k_12_total 256 17 9 *   5       * 12           *         *   42   300 256 17 9     5         12                   42   300
3297811 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001473 5060 O'NEAL ELEM.   Regular School No Elementary 01 03 2020   k_12_total 265 40 7 *   *       * 15           *         *   81   330 265 40 7               15                   81   330
3297817 MO     school 2925450 12109   POPLAR BLUFF R-I 292545002769 7500 POPLAR BLUFF EARLY CHILDHOOD C   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297823 MO     school 2930520 12110   TWIN RIVERS R-X 293052002095 1050 TWIN RIVERS HIGH   Regular School No High 09 12 2020   k_12_total 247 * 6 *   *       * 5           *         *   42   263 247   6               5                   42   263
3297825 MO     school 2930520 12110   TWIN RIVERS R-X 293052003337 3000 QULIN MIDDLE   Regular School No Middle 04 08 2020   k_12_total 139 * * *   *       * *           *         *   22   146 139                                       22   146
3297831 MO     school 2930520 12110   TWIN RIVERS R-X 293052002093 4040 FISK ELEMENTARY   Regular School No Elementary PK 08 2020   k_12_total 330 * 10 *   *       * 12           *         *   72   357 330   10               12                   72   357
3297837 MO     school 2930520 12110   TWIN RIVERS R-X 293052002094 4060 QULIN ELEMENTARY   Regular School No Elementary PK 03 2020   k_12_total 108 * * *   *       * 5           *         *   19   115 108                   5                   19   115
3297921 MO     school 2916620 13062   KINGSTON 42 291662000908 4020 KINGSTON ELEM.   Regular School No Elementary PK 08 2020   k_12_total 26 * * *   *       * *           *         *   5   27 26                                       5   27
3298017 MO     school 2900020 14400   MO SCHOOL FOR THE DEAF 290002003021 1050 WHEELER HIGH   Special Education School No High 09 12 2020   k_12_total 14 * * *   *       * *           *         *   *   22 14                                           22
3298023 MO     school 2900020 14400   MO SCHOOL FOR THE DEAF 290002003022 3000 WHEELER MIDDLE   Special Education School No Middle 06 08 2020   k_12_total 8 * * *   *       * *           *         *   *   10 8                                           10
3298047 MO     school 2906990 15002   CAMDENTON R-III 290699001953 1015 JUVENILE JUSTICE CENTER   Alternative School No High 05 12 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298107 MO     school 2919380 15004   MACKS CREEK R-V 291938001049 1050 MACKS CREEK HIGH   Regular School No High 07 12 2020   k_12_total 133 * 9 *   *       * *           *         *   25   149 133   9                                   25   149
3298113 MO     school 2919380 15004   MACKS CREEK R-V 291938001048 4020 MACKS CREEK ELEM.   Regular School No Elementary PK 06 2020   k_12_total 144 * 6 *   *       * 5           *         *   25   158 144   6               5                   25   158
3298202 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712000186 1050 CENTRAL HIGH   Regular School No High 09 12 2020   k_12_total 700 340 63 *   27       * 101           27         *   190   1233 700 340 63     27         101           27       190   1233
3298208 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712000185 2050 CENTRAL JR. HIGH   Regular School No Middle 07 08 2020   k_12_total 326 228 32 *   13       * 70           13         *   103   669 326 228 32     13         70           13       103   669
3298214 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712000184 4020 ALMA SCHRADER ELEM.   Regular School No Elementary KG 04 2020   k_12_total 292 41 13 *   17       * 24           16         *   51   387 292 41 13     17         24           16       51   387
3298220 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712000187 4040 FRANKLIN ELEM.   Regular School No Elementary PK 04 2020   k_12_total 59 117 30 *   5       * 46           15         *   50   257 59 117 30     5         46           15       50   257
3298226 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712002722 4050 BLANCHARD ELEM.   Regular School No Elementary PK 04 2020   k_12_total 149 119 13 *   5       * 42           9         *   40   328 149 119 13     5         42           9       40   328
3298232 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712000188 4060 CLIPPARD ELEM.   Regular School No Elementary PK 04 2020   k_12_total 140 119 43 *   8       * 53           39         *   56   364 140 119 43     8         53           39       56   364
3298238 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712000189 4080 JEFFERSON ELEM.   Regular School No Elementary PK 04 2020   k_12_total 97 139 25 *   *       * 48           15         *   50   309 97 139 25               48           15       50   309
3298244 MO     school 2907120 16096   CAPE GIRARDEAU 63 290712002798 4090 CENTRAL MIDDLE   Regular School No Middle 05 06 2020   k_12_total 322 207 36 *   8       * 69           16         *   133   642 322 207 36     8         69           16       133   642
3298280 MO     school 2905610 17124   BOSWORTH R-V 290561000107 1050 BOSWORTH HIGH   Regular School No High 07 12 2020   k_12_total 23 * * *   *       * *           *         *   *   25 23                                           25
3298286 MO     school 2905610 17124   BOSWORTH R-V 290561000106 4020 BOSWORTH ELEM.   Regular School No Elementary PK 06 2020   k_12_total 19 * * *   *       * *           *         *   *   21 19                                           21
3298433 MO     school 2923730 19142   RAYMORE-PECULIAR R-II 292373003316 7500 SHULL EARLY LEARNING CENTER   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298599 MO     school 2904620 19152   BELTON 124 290462002725 7500 GRACE EARLY CHILD. & ED. CTR.   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298600 MO     school 2929520 20001   STOCKTON R-I 292952003351 1010 EXCEPTIONAL PUPIL COOP. - ECSE   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298620 MO     school 2929520 20001   STOCKTON R-I 292952003323 7500 LITTLE TIGER PRESCHOOL   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298638 MO     school 2911310 20002   EL DORADO SPRINGS R-II 291131000400 4040 EL DORADO SPRINGS ELEM.   Regular School No Elementary PK 05 2020   k_12_total 463 * 5 *   *       * 16           *         *   67   487 463   5               16                   67   487
3298716 MO     school 2922530 22089   Nixa Public Schools 292253003132 4030 EARLY LEARNING CENTER   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298764 MO     school 2922530 22089   Nixa Public Schools 292253003242 7500 EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298788 MO     school 2928740 22090   SPARTA R-III 292874003260 7500 SPARTA PK CENTER   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298856 MO     school 2923430 22093   OZARK R-VI 292343003333 7500 OZARK TIGERPAW EARLY CHILD CTR   Regular School No Elementary PK KG 2020   k_12_total * * * *   *       * *           *         *   *   9                                             9
3298905 MO     school 2916380 23101   CLARK CO. R-I 291638003254 7500 EARLY CHILDHOOD CENTER   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298950 MO     school 2916450 24086   KEARNEY R-I 291645003329 7500 KEARNEY EARLY EDUCATION CENTER   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3298988 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165000071 1080 EXCELSIOR SPRINGS TECH. HIGH   Career and Technical School No High 10 12 2020   k_12_total 78 67 10 *   *       * 12           *         *   *   168 78 67 10               12                       168
3299013 MO     school 2911650 24089   EXCELSIOR SPRINGS 40 291165003352 7500 EXCELSIOR SPRINGS EAR CHLD CTR   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3299121 MO     school 2918540 24090   LIBERTY 53 291854002615 7500 EARLY CHILD. EDUCATION CTR.   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3299317 MO     school 2922800 24093   NORTH KANSAS CITY 74 292280002662 7500 PLEASANT VALLEY EARLY CHILDHOO   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3299455 MO     school 2916190 26006   JEFFERSON CITY 291619002288 4025 CALLAWAY HILLS ELEM.   Regular School No Elementary KG 05 2020   k_12_total 208 11 7 *   *       * 26           *         *   34   253 208 11 7               26                   34   253
3299467 MO     school 2916190 26006   JEFFERSON CITY 291619000748 4040 EAST ELEM.   Regular School No Elementary KG 05 2020   k_12_total 110 122 19 *   *       * 39           *         *   34   290 110 122 19               39                   34   290
3299491 MO     school 2916190 26006   JEFFERSON CITY 291619000755 4080 SOUTH ELEM.   Regular School No Elementary KG 05 2020   k_12_total 107 126 14 *   20       * 27           14         *   33   295 107 126 14     20         27           14       33   295
3299503 MO     school 2916190 26006   JEFFERSON CITY 291619000757 5020 THORPE J. GORDON ELEM.   Regular School No Elementary KG 05 2020   k_12_total 115 141 12 *   *       * 53           8         *   38   324 115 141 12               53           8       38   324
3299515 MO     school 2916190 26006   JEFFERSON CITY 291619003121 7500 SOUTHWEST EARLY CHILDHOOD CTR   Regular School No Prekindergarten PK PK 2020   k_12_total * * * *   *       * *           *         *   *   0                                             0
3299581 MO     school 2905580 27061   BOONVILLE R-I 290558000105 3000 LAURA SPEED ELLIOTT MIDDLE   Regular School No Middle 06 08 2020   k_12_total 301 30 10 *   *       * 28           *         *   68   372 301 30 10               28                   68   372
3299587 MO     school 2905580 27061   BOONVILLE R-I 290558000102 4020 HANNAH COLE PRIMARY   Regular School No Elementary PK 02 2020   k_12_total 239 27 10 *   *       * 31           *         *   38   312 239 27 10               31                   38   312
3299593 MO     school 2905580 27061   BOONVILLE R-I 290558000103 4040 DAVID BARTON ELEM.   Regular School No Elementary 03 05 2020   k_12_total 245 20 10 *   *       * 33           *         *   54   310 245 20 10               33                   54   310
3299682 MO     school 2911580 29003   EVERTON R-III 291158000413 1050 EVERTON HIGH   Regular School No High 07 12 2020   k_12_total 68 * * *   *       * *           *         *   10   75 68                                       10   75
3299690 MO     school 2911580 29003   EVERTON R-III 291158000412 4020 EVERTON ELEM.   Regular School No Elementary PK 06 2020   k_12_total 83 * * *   *       * *           *         *   13   87 83                                       13   87
3299751 MO     school 2915630 31118   NORTH DAVIESS R-III 291563000741 1050 NORTH DAVIESS HIGH   Regular School No High 07 12 2020   k_12_total 27 * * *   *       * *           *         *   8   27 27                                       8   27
3299757 MO     school 2915630 31118   NORTH DAVIESS R-III 291563000740 4020 NORTH DAVIESS ELEM.   Regular School No Elementary PK 06 2020   k_12_total 33 * * *   *       * *           *         *   9   33 33                                       9   33
3299839 MO     school 2927090 33090   SALEM R-80 292709001678 1050 SALEM SR. HIGH   Regular School No High 09 12 2020   k_12_total 536 * 16 *   *       * 11           *         *   70   570 536   16               11                   70   570
3299845 MO     school 2927090 33090   SALEM R-80 292709001677 2050 SALEM MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 227 * * *   *       * 11           *         *   44   246 227                   11                   44   246
3299851 MO     school 2927090 33090   SALEM R-80 292709001679 4020 WM. H. LYNCH ELEM.   Regular School No Elementary PK 01 2020   k_12_total 198 * 5 *   *       * *           *         *   47   210 198   5                                   47   210
3299857 MO     school 2927090 33090   SALEM R-80 292709001676 4040 SALEM UPPER ELEM.   Regular School No Elementary 02 05 2020   k_12_total 306 * 7 *   *       * 21           *         *   76   340 306   7               21                   76   340
3299917 MO     school 2919890 35092   MALDEN R-I 291989001058 1050 MALDEN HIGH   Regular School No High 07 12 2020   k_12_total 274 101 14 *   *       * *           *         *   55   395 274 101 14                                   55   395
3299923 MO     school 2919890 35092   MALDEN R-I 291989001056 4020 MALDEN LOWER ELEM.   Regular School No Elementary PK 06 2020   k_12_total 319 138 22 *   *       * 32           *         *   66   512 319 138 22               32                   66   512
3299941 MO     school 2914460 35094   HOLCOMB R-III 291446000678 1050 HOLCOMB HIGH   Regular School No High 07 12 2020   k_12_total 181 * 30 *   *       * *           6         *   28   211 181   30                           6       28   211
3299947 MO     school 2914460 35094   HOLCOMB R-III 291446000677 4020 HOLCOMB ELEM.   Regular School No Elementary PK 06 2020   k_12_total 209 * 31 *   *       * *           8         *   44   242 209   31                           8       44   242
3299953 MO     school 2909120 35097   CLARKTON C-4 290912000269 1050 CLARKTON HIGH   Regular School No High 07 12 2020   k_12_total 105 10 28 *   *       * *           8         *   23   148 105 10 28                           8       23   148
3299959 MO     school 2909120 35097   CLARKTON C-4 290912000268 4020 CLARKTON ELEM.   Regular School No Elementary PK 06 2020   k_12_total 121 20 46 *   *       * *           16         *   28   190 121 20 46                           16       28   190

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