Data source: Big Local News · About: Big Local

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

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
3296702 MO     school 2916740 1091   KIRKSVILLE R-III 291674002611 3000 WILLIAM MATTHEW MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 488 32 10 *   10       * 35           25         293.2   72   575 488 32 10     10         35           25       72   575
3296756 MO     school 2927570 2097   SAVANNAH R-III 292757001693 1050 SAVANNAH HIGH   Regular School No High 09 12 2020   k_12_total 655 14 12 *   *       * 13           *         160.4   89   701 655 14 12               13                   89   701
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
3296828 MO     school 2911760 3033   FAIRFAX R-III 291176000432 4020 FAIRFAX ELEM.   Regular School No Elementary PK 06 2020   k_12_total 68 * * *   *       * *           *         28.2   8   69 68                                       8   69
3296858 MO     school 2920810 4110   MEXICO 59 292081001137 1050 MEXICO HIGH   Regular School No High 09 12 2020   k_12_total 529 46 68 *   *       * 60           8         249.3   62   709 529 46 68               60           8       62   709
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
3297109 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No Elementary PK 06 2020   k_12_total 159 7 * *   *       * *           *         111.1   25   176 159 7                                     25   176
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
3297256 MO     school 2919350 9080   WOODLAND R-IV 291935002985 3000 WOODLAND MIDDLE   Regular School No Middle 05 08 2020   k_12_total 286 * * *   *       * *           *         202.4   41   292 286                                       41   292
3297268 MO     school 2928560 10087   SOUTHERN BOONE CO. R-I 292856001766 1050 Southern Boone High   Regular School No High 09 12 2020   k_12_total 452 5 7 *   *       * 21           *         50.4   47   489 452 5 7               21                   47   489
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
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
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
3297394 MO     school 2901000 10093   COLUMBIA 93 290100003239 1060 MURIEL W. BATTLE HIGH SCHOOL   Regular School No High 09 12 2020   k_12_total 753 472 128 6   38       6 112           53         736.1   195   1515 753 472 128 6   38       6 112           53       195   1515
3297412 MO     school 2901000 10093   COLUMBIA 93 290100001402 2060 OAKLAND MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 256 208 67 *   13       * 56           73         394.4   96   607 256 208 67     13         56           73       96   607
3297418 MO     school 2901000 10093   COLUMBIA 93 290100000317 2075 WEST MIDDLE SCHOOL   Regular School No Middle 06 08 2020   k_12_total 419 136 32 *   16       * 55           5         266.3   95   661 419 136 32     16         55           5       95   661
3297424 MO     school 2901000 10093   COLUMBIA 93 290100000841 3000 ANN HAWKINS GENTRY MIDDLE   Regular School No Middle 06 08 2020   k_12_total 678 94 37 *   58       * 57           18         210.4   92   927 678 94 37     58         57           18       92   927
3297436 MO     school 2901000 10093   COLUMBIA 93 290100001946 3060 JOHN B. LANGE MIDDLE   Regular School No Middle 06 08 2020   k_12_total 284 206 46 *   18       * 65           9         382.3   76   626 284 206 46     18         65           9       76   626
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
3297483 MO     school 2901000 10093   COLUMBIA 93 290100000315 5000 ULYSSES S. GRANT ELEM.   Regular School No Elementary PK 05 2020   k_12_total 170 54 18 *   34       * 21           43         103.1   18   297 170 54 18     34         21           43       18   297
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
3297775 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001469 2050 POPLAR BLUFF JR. HIGH   Regular School No Middle 07 08 2020   k_12_total 654 75 18 *   *       * 39           *         490.2   147   792 654 75 18               39                   147   792
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
3297927 MO     school 2922740 14126   NORTH CALLAWAY CO. R-I 292274001254 1050 NORTH CALLAWAY HIGH   Regular School No High 09 12 2020   k_12_total 323 * 6 *   *       * 14           *         125.4   33   347 323   6               14                   33   347
3297945 MO     school 2922740 14126   NORTH CALLAWAY CO. R-I 292274001255 4060 WILLIAMSBURG ELEM.   Regular School No Elementary KG 08 2020   k_12_total 131 * * *   *       * 7           *         71.1   22   140 131                   7                   22   140
3297969 MO     school 2912550 14129   FULTON 58 291255002525 3000 FULTON MIDDLE   Regular School No Middle 06 08 2020   k_12_total 438 50 10 *   *       * 50           5         306.2   71   557 438 50 10               50           5       71   557
3297987 MO     school 2912550 14129   FULTON 58 291255000522 4080 MCINTIRE ELEM.   Regular School No Elementary PK 05 2020   k_12_total 280 36 6 *   *       * 54           *         247.1   65   377 280 36 6               54                   65   377
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
3298053 MO     school 2906990 15002   CAMDENTON R-III 290699000175 1050 CAMDENTON HIGH   Regular School No High 09 12 2020   k_12_total 1173 21 81 *   11       * 39           7         596.4   163   1331 1173 21 81     11         39           7       163   1331
3298059 MO     school 2906990 15002   CAMDENTON R-III 290699000173 3000 CAMDENTON MIDDLE   Regular School No Middle 07 08 2020   k_12_total 602 16 36 *   5       * 25           5         375.4   87   689 602 16 36     5         25           5       87   689
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
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
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
3298256 MO     school 2913500 17121   HALE R-I 291350000574 1050 HALE HIGH   Regular School No High 07 12 2020   k_12_total 68 * * *   *       * *           *         29.4   9   71 68                                       9   71
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
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
3298376 MO     school 2923730 19142   RAYMORE-PECULIAR R-II 292373001424 1050 RAYMORE-PECULIAR SR. HIGH   Regular School No High 09 12 2020   k_12_total 1488 200 143 6   22       * 112           9         479.3   187   1971 1488 200 143 6   22         112           9       187   1971
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
3298504 MO     school 2913760 19149   HARRISONVILLE R-IX 291376002659 3000 HARRISONVILLE MIDDLE   Regular School No Middle 06 08 2020   k_12_total 463 7 23 *   *       * 21           *         194.2   54   521 463 7 23               21                   54   521
3298552 MO     school 2904620 19152   BELTON 124 290462000055 1050 BELTON HIGH   Regular School No High 09 12 2020   k_12_total 925 138 228 5   11       6 93           51         643.2   223   1406 925 138 228 5   11       6 93           51       223   1406
3298587 MO     school 2904620 19152   BELTON 124 290462002724 4080 MILL CREEK UPPER ELEM.   Regular School No Middle 05 06 2020   k_12_total 362 52 81 *   *       * 40           24         316.4   100   546 362 52 81               40           24       100   546
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
3298612 MO     school 2929520 20001   STOCKTON R-I 292952000089 3000 STOCKTON MIDDLE   Regular School No Middle 05 08 2020   k_12_total 266 * 7 *   *       * *           *         161.3   36   285 266   7                                   36   285
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
3298704 MO     school 2922530 22089   Nixa Public Schools 292253000424 1050 NIXA HIGH   Regular School No High 09 12 2020   k_12_total 1572 11 71 10   22       * 115           10         430.3   158   1802 1572 11 71 10   22         115           10       158   1802
3298710 MO     school 2922530 22089   Nixa Public Schools 292253000425 3000 NIXA JUNIOR HIGH   Regular School No Middle 07 08 2020   k_12_total 852 8 55 *   7       * 68           12         308.4   117   992 852 8 55     7         68           12       117   992

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