Data source: Big Local News · About: Big Local

2,322 rows where grade = "k_12_total", state = "MO" and year = 2019 sorted by ccd_school_lvl

View and edit SQL

year

  • 2019 · 2,322

grade

  • k_12_total · 2,322
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
3296689 MO     school 2922980 1090   ADAIR CO. R-I 292298001314 4020 ADAIR CO. ELEM.   Regular School No Elementary PK 06 2019   k_12_total 120 * * *   *       * *           *         81   19   120 120                                     81 19   120
3296707 MO     school 2916740 1091   KIRKSVILLE R-III 291674002219 4030 KIRKSVILLE PRIMARY   Regular School No Elementary PK 02 2019   k_12_total 440 46 16 *   8       * 22           44         323   107   532 440 46 16     8         22           44     323 107   532
3296713 MO     school 2916740 1091   KIRKSVILLE R-III 291674000917 4050 RAY MILLER ELEM.   Regular School No Elementary 03 05 2019   k_12_total 481 39 9 *   8       * 27           31         323   86   564 481 39 9     8         27           31     323 86   564
3296725 MO     school 2905790 1092   ADAIR CO. R-II 290579000124 4020 ADAIR CO. ELEM.   Regular School No Elementary KG 06 2019   k_12_total 68 * * *   *       * *           *         25   15   69 68                                     25 15   69
3296743 MO     school 2922710 2089   NORTH ANDREW CO. R-VI 292271001250 4020 NORTH ANDREW ELEM.   Regular School No Elementary PK 05 2019   k_12_total 144 * * *   *       * *           *         55   17   145 144                                     55 17   145
3296749 MO     school 2904080 2090   AVENUE CITY R-IX 290408000037 4020 AVENUE CITY ELEM.   Regular School No Elementary PK 08 2019   k_12_total 151 * * *   *       * 5           *         26   14   159 151                   5                 26 14   159
3296767 MO     school 2927570 2097   SAVANNAH R-III 292757001688 4010 AMAZONIA ELEM.   Regular School No Elementary KG 05 2019   k_12_total 86 * 5 *   *       * *           *         52   18   93 86   5                                 52 18   93
3296773 MO     school 2927570 2097   SAVANNAH R-III 292757001689 4015 HELENA ELEM.   Regular School No Elementary KG 05 2019   k_12_total 87 * * *   *       * *           *         23   16   94 87                                     23 16   94
3296779 MO     school 2927570 2097   SAVANNAH R-III 292757001690 4020 JOHN GLENN ELEM.   Regular School No Elementary KG 05 2019   k_12_total 266 * 9 *   *       * 7           *         96   39   285 266   9               7                 96 39   285
3296785 MO     school 2927570 2097   SAVANNAH R-III 292757001692 4040 MINNIE CLINE ELEM.   Regular School No Elementary KG 05 2019   k_12_total 554 6 7 *   *       * 13           *         213   95   584 554 6 7               13                 213 95   584
3296803 MO     school 2929940 3031   TARKIO R-I 292994002066 4020 TARKIO ELEM.   Regular School No Elementary PK 06 2019   k_12_total 170 * 7 *   *       * *           *         94.4   29   182 170   7                                   29   182
3296815 MO     school 2926790 3032   ROCK PORT R-II 292679001612 4020 ROCK PORT ELEM.   Regular School No Elementary PK 06 2019   k_12_total 182 5 * *   *       * *           *         69   19   192 182 5                                   69 19   192
3296827 MO     school 2911760 3033   FAIRFAX R-III 291176000432 4020 FAIRFAX ELEM.   Regular School No Elementary PK 06 2019   k_12_total 70 * * *   *       * *           *         28.2   11   72 70                                       11   72
3296839 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No Elementary PK 05 2019   k_12_total 117 * * *   *       * 5           *         82   24   123 117                   5                 82 24   123
3296851 MO     school 2930780 4109   VAN-FAR R-I 293078002125 4020 VAN-FAR ELEM.   Regular School No Elementary PK 06 2019   k_12_total 269 12 12 *   *       * 29           5         199   35   322 269 12 12               29           5     199 35   322
3296869 MO     school 2920810 4110   MEXICO 59 292081001132 4020 EUGENE FIELD ELEM.   Regular School No Elementary KG 05 2019   k_12_total 279 45 17 *   *       * 50           *         *   45   391 279 45 17               50                   45   391
3296875 MO     school 2920810 4110   MEXICO 59 292081001133 4060 HAWTHORNE ELEM.   Regular School No Elementary KG 05 2019   k_12_total 307 30 59 *   *       * 28           54         *   29   428 307 30 59               28           54       29   428
3296881 MO     school 2920810 4110   MEXICO 59 292081001134 4080 MCMILLAN ELEM.   Regular School No Elementary PK 05 2019   k_12_total 160 15 10 *   *       * 18           *         *   32   204 160 15 10               18                   32   204
3296893 MO     school 2931950 5120   WHEATON R-III 293195002236 4020 WHEATON ELEM.   Regular School No Elementary PK 06 2019   k_12_total 152 * 7 *   37       7 11           32         151   31   215 152   7     37       7 11           32     151 31   215
3296911 MO     school 2928710 5121   SOUTHWEST R-V 292871001773 4020 SOUTHWEST ELEM.   Regular School No Elementary PK 04 2019   k_12_total 231 * 12 5   *       * 10           *         155   37   259 231   12 5             10                 155 37   259
3296923 MO     school 2911670 5122   EXETER R-VI 291167000426 4020 EXETER ELEM.   Regular School No Elementary KG 08 2019   k_12_total 167 * 5 *   15       * *           10         130   27   187 167   5     15                     10     130 27   187
3296941 MO     school 2908170 5123   CASSVILLE R-IV 290817000217 4020 EUNICE THOMAS ELEM.   Regular School No Elementary PK 02 2019   k_12_total 377 * 24 *   *       * 8           18         246   42   414 377   24               8           18     246 42   414
3296947 MO     school 2908170 5123   CASSVILLE R-IV 290817002718 4030 CASSVILLE INTERMEDIATE   Regular School No Elementary 03 05 2019   k_12_total 372 * 23 *   6       * 19           15         254   42   424 372   23     6         19           15     254 42   424
3296963 MO     school 2925620 5124   PURDY R-II 292562001501 4020 PURDY ELEM.   Regular School No Elementary PK 06 2019   k_12_total 203 * 105 *   7       * 5           71         219   62   322 203   105     7         5           71     219 62   322
3296970 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No Elementary PK 08 2019   k_12_total 113 * * *   *       * *           *         *   14   120 113                                       14   120
3296988 MO     school 2921120 5128   MONETT R-I 292112003089 4000 CENTRAL PARK ELEM.   Regular School No Elementary 03 04 2019   k_12_total 195 * 128 *   16       * 8           115         254   58   355 195   128     16         8           115     254 58   355
3296994 MO     school 2921120 5128   MONETT R-I 292112001160 4020 MONETT ELEM.   Regular School No Elementary PK 02 2019   k_12_total 262 * 192 *   15       * 10           180         354   62   487 262   192     15         10           180     354 62   487
3297018 MO     school 2918510 6101   LIBERAL R-II 291851001002 4020 LIBERAL ELEM.   Regular School No Elementary PK 05 2019   k_12_total 150 5 5 *   *       * *           *         91   29   164 150 5 5                                 91 29   164
3297030 MO     school 2912930 6103   GOLDEN CITY R-III 291293000541 4020 GOLDEN CITY ELEM.   Regular School No Elementary KG 06 2019   k_12_total 84 * * *   *       * 7           *         61   17   93 84                   7                 61 17   93
3297054 MO     school 2917850 6104   LAMAR R-I 291785000953 4020 LAMAR ELEM.   Regular School No Elementary 03 05 2019   k_12_total 216 * 14 5   *       * 16           8         156   50   254 216   14 5             16           8     156 50   254
3297060 MO     school 2917850 6104   LAMAR R-I 291785002720 4040 EAST ELEM.   Regular School No Elementary PK 02 2019   k_12_total 216 * 14 *   *       * 10           *         155   36   244 216   14               10                 155 36   244
3297072 MO     school 2920820 7121   MIAMI R-I 292082001138 4020 MIAMI ELEM.   Regular School No Elementary PK 06 2019   k_12_total 67 * * *   *       * *           *         43   10   74 67                                     43 10   74
3297084 MO     school 2904170 7122   BALLARD R-II 290417000041 4020 BALLARD ELEM.   Regular School No Elementary KG 06 2019   k_12_total 59 * * *   *       * *           *         36   12   64 59                                     36 12   64
3297096 MO     school 2902850 7123   ADRIAN R-III 290285000001 4020 ADRIAN ELEM.   Regular School No Elementary PK 05 2019   k_12_total 300 * 5 *   *       * *           *         107   37   305 300   5                                 107 37   305
3297108 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No Elementary PK 06 2019   k_12_total 144 10 * *   *       * *           *         99   27   162 144 10                                   99 27   162
3297120 MO     school 2915330 7125   HUME R-VIII 291533000698 4020 HUME ELEM.   Regular School No Elementary PK 06 2019   k_12_total 61 * * *   *       * *           *         52   13   68 61                                     52 13   68
3297126 MO     school 2915240 7126   HUDSON R-IX 291524000693 4020 HUDSON ELEM.   Regular School No Elementary PK 08 2019   k_12_total 47 * * *   *       * *           *         *   *   47 47                                           47
3297138 MO     school 2906360 7129   BUTLER R-V 290636000157 4020 BUTLER ELEM.   Regular School No Elementary KG 06 2019   k_12_total 432 * 14 *   *       * 21           *         293   81   471 432   14               21                 293 81   471
3297153 MO     school 2918670 8106   LINCOLN R-II 291867001015 4020 LINCOLN ELEM.   Regular School No Elementary KG 06 2019   k_12_total 249 * * *   *       * 6           *         162   44   261 249                   6                 162 44   261
3297171 MO     school 2931070 8107   WARSAW R-IX 293107002153 4020 NORTH ELEM.   Regular School No Elementary 01 05 2019   k_12_total 262 * 10 *   *       * 12           *         *   76   288 262   10               12                   76   288
3297177 MO     school 2931070 8107   WARSAW R-IX 293107002154 4040 SOUTH ELEM.   Regular School No Elementary PK 05 2019   k_12_total 145 * * *   *       * 7           *         *   29   160 145                   7                   29   160
3297183 MO     school 2931070 8107   WARSAW R-IX 293107000834 4060 RUTH MERCER ELEM.   Regular School No Elementary PK KG 2019   k_12_total 47 * * *   *       * *           *         *   11   50 47                                       11   50
3297200 MO     school 2909900 8111   COLE CAMP R-I 290990000292 4020 COLE CAMP ELEM.   Regular School No Elementary KG 04 2019   k_12_total 245 * 10 *   *       * 8           8         158   49   263 245   10               8           8     158 49   263
3297219 MO     school 2923640 9077   MEADOW HEIGHTS R-II 292364001407 4020 MEADOW HEIGHTS ELEM.   Regular School No Elementary PK 05 2019   k_12_total 225 * * *   *       * 5           *         137   38   231 225                   5                 137 38   231
3297231 MO     school 2918420 9078   LEOPOLD R-III 291842000988 4020 LEOPOLD ELEM.   Regular School No Elementary KG 06 2019   k_12_total 114 * * *   *       * *           *         30   9   114 114                                     30 9   114
3297243 MO     school 2932490 9079   ZALMA R-V 293249002269 4020 ZALMA ELEM.   Regular School No Elementary KG 06 2019   k_12_total 126 * * *   *       * *           *         83   17   127 126                                     83 17   127
3297261 MO     school 2919350 9080   WOODLAND R-IV 291935001045 4040 WOODLAND ELEM.   Regular School No Elementary PK 04 2019   k_12_total 320 * * *   *       * *           *         218.4   50   325 320                                       50   325
3297279 MO     school 2928560 10087   SOUTHERN BOONE CO. R-I 292856002802 4010 SOUTHERN BOONE PRIMARY   Regular School No Elementary PK 02 2019   k_12_total 407 * 13 *   *       * 20           *         105   44   448 407   13               20                 105 44   448
3297285 MO     school 2928560 10087   SOUTHERN BOONE CO. R-I 292856001765 4020 SOUTHERN BOONE ELEM.   Regular School No Elementary 03 05 2019   k_12_total 372 5 7 *   *       * 18           *         95   36   404 372 5 7               18                 95 36   404
3297303 MO     school 2913560 10089   HALLSVILLE R-IV 291356000577 4020 HALLSVILLE INTERMEDIATE   Regular School No Elementary 02 05 2019   k_12_total 384 10 10 *   12       * 31           9         158   47   449 384 10 10     12         31           9     158 47   449
3297309 MO     school 2913560 10089   HALLSVILLE R-IV 291356002975 4040 HALLSVILLE PRIMARY   Regular School No Elementary PK 01 2019   k_12_total 188 9 10 *   7       * 15           *         70   22   230 188 9 10     7         15                 70 22   230
3297327 MO     school 2929700 10090   STURGEON R-V 292970002052 4020 STURGEON ELEM.   Regular School No Elementary PK 04 2019   k_12_total 120 * * *   *       * 10           *         67   21   132 120                   10                 67 21   132
3297345 MO     school 2908400 10091   CENTRALIA R-VI 290840000242 4020 CHANCE ELEM.   Regular School No Elementary PK 02 2019   k_12_total 277 * 7 *   *       * 11           *         103   24   302 277   7               11                 103 24   302
3297351 MO     school 2908400 10091   CENTRALIA R-VI 290840003092 4050 CENTRALIA INTERMEDIATE   Regular School No Elementary 03 05 2019   k_12_total 273 * * *   *       * 9           *         90   38   289 273                   9                 90 38   289
3297369 MO     school 2913710 10092   HARRISBURG R-VIII 291371000598 4020 HARRISBURG ELEM.   Regular School No Elementary PK 05 2019   k_12_total 230 * * *   *       * *           *         82   47   240 230                                     82 47   240
3297441 MO     school 2901000 10093   COLUMBIA 93 290100000313 4020 THOMAS BENTON ELEM.   Regular School No Elementary PK 05 2019   k_12_total 81 115 7 *   *       * 38           *         *   38   244 81 115 7               38                   38   244
3297447 MO     school 2901000 10093   COLUMBIA 93 290100003152 4030 ALPHA HART LEWIS   Regular School No Elementary PK 05 2019   k_12_total 158 155 17 *   *       * 69           10         *   58   404 158 155 17               69           10       58   404
3297453 MO     school 2901000 10093   COLUMBIA 93 290100000298 4040 BLUE RIDGE ELEM.   Regular School No Elementary PK 05 2019   k_12_total 117 155 106 *   16       * 42           111         *   57   441 117 155 106     16         42           111       57   441
3297459 MO     school 2901000 10093   COLUMBIA 93 290100002279 4050 CEDAR RIDGE ELEM.   Regular School No Elementary KG 05 2019   k_12_total 257 72 28 5   9       * 27           16         188   41   398 257 72 28 5   9         27           16     188 41   398
3297465 MO     school 2901000 10093   COLUMBIA 93 290100002665 4055 DERBY RIDGE ELEM.   Regular School No Elementary PK 05 2019   k_12_total 145 154 43 *   28       * 55           67         *   72   425 145 154 43     28         55           67       72   425
3297471 MO     school 2901000 10093   COLUMBIA 93 290100000303 4060 FAIRVIEW ELEM.   Regular School No Elementary PK 05 2019   k_12_total 337 61 16 *   48       * 24           72         139   25   486 337 61 16     48         24           72     139 25   486
3297476 MO     school 2901000 10093   COLUMBIA 93 290100003271 4070 ELIOT BATTLE ELEMENTARY   Regular School No Elementary KG 05 2019   k_12_total 181 169 35 *   10       * 52           42         *   53   450 181 169 35     10         52           42       53   450
3297482 MO     school 2901000 10093   COLUMBIA 93 290100000315 5000 ULYSSES S. GRANT ELEM.   Regular School No Elementary PK 05 2019   k_12_total 177 50 11 *   46       * 30           46         122   18   314 177 50 11     46         30           46     122 18   314
3297488 MO     school 2901000 10093   COLUMBIA 93 290100002770 5010 MARY PAXTON KEELEY ELEM.   Regular School No Elementary PK 05 2019   k_12_total 409 88 44 *   84       * 73           115         238   51   699 409 88 44     84         73           115     238 51   699
3297494 MO     school 2901000 10093   COLUMBIA 93 290100000308 5020 Locust St Expressive Arts Elem   Regular School No Elementary PK 05 2019   k_12_total 134 53 10 *   33       * 23           46         110   16   254 134 53 10     33         23           46     110 16   254
3297500 MO     school 2901000 10093   COLUMBIA 93 290100001142 5025 MIDWAY HEIGHTS ELEM.   Regular School No Elementary PK 05 2019   k_12_total 183 * 7 *   *       * 17           *         47   9   212 183   7               17                 47 9   212
3297506 MO     school 2901000 10093   COLUMBIA 93 290100002546 5030 MILL CREEK ELEM.   Regular School No Elementary PK 05 2019   k_12_total 504 40 15 *   66       * 35           44         119   27   660 504 40 15     66         35           44     119 27   660
3297512 MO     school 2901000 10093   COLUMBIA 93 290100002280 5035 NEW HAVEN ELEM.   Regular School No Elementary PK 05 2019   k_12_total 126 37 56 *   9       * 19           63         145   38   247 126 37 56     9         19           63     145 38   247
3297518 MO     school 2901000 10093   COLUMBIA 93 290100000307 5040 PARKADE ELEM.   Regular School No Elementary PK 05 2019   k_12_total 247 102 30 *   17       * 60           34         276   48   462 247 102 30     17         60           34     276 48   462
3297522 MO     school 2901000 10093   COLUMBIA 93 290100003292 5050 BEULAH RALPH ELEMENTARY   Regular School No Elementary KG 05 2019   k_12_total 474 63 26 *   38       * 52           33         163   57   657 474 63 26     38         52           33     163 57   657
3297528 MO     school 2901000 10093   COLUMBIA 93 290100000305 5060 JOHN RIDGEWAY ELEM.   Regular School No Elementary KG 05 2019   k_12_total 177 17 8 *   11       * 20           5         29   22   234 177 17 8     11         20           5     29 22   234
3297534 MO     school 2901000 10093   COLUMBIA 93 290100000309 5080 ROCK BRIDGE ELEM.   Regular School No Elementary PK 05 2019   k_12_total 329 46 27 *   26       * 41           41         143   29   472 329 46 27     26         41           41     143 29   472
3297540 MO     school 2901000 10093   COLUMBIA 93 290100000310 6000 RUSSELL BLVD. ELEM.   Regular School No Elementary PK 05 2019   k_12_total 304 27 21 *   14       * 28           18         102   48   395 304 27 21     14         28           18     102 48   395
3297546 MO     school 2901000 10093   COLUMBIA 93 290100000312 6010 SHEPARD BLVD. ELEM.   Regular School No Elementary PK 05 2019   k_12_total 259 116 25 *   15       * 61           40         270   48   478 259 116 25     15         61           40     270 48   478
3297552 MO     school 2901000 10093   COLUMBIA 93 290100000316 6020 WEST BLVD. ELEM.   Regular School No Elementary PK 05 2019   k_12_total 116 135 27 *   9       * 41           38         *   40   329 116 135 27     9         41           38       40   329
3297558 MO     school 2901000 10093   COLUMBIA 93 290100000314 6040 TWO MILE PRAIRIE ELEM.   Regular School No Elementary KG 05 2019   k_12_total 146 5 6 *   *       * 15           6         67   19   175 146 5 6               15           6     67 19   175
3297564 MO     school 2901000 10093   COLUMBIA 93 290100001598 6080 Center for Gifted Education   Regular School No Elementary 01 05 2019   k_12_total 40 5 * *   *       * *           *         *   *   48 40 5                                         48
3297586 MO     school 2911250 11076   EAST BUCHANAN CO. C-1 291125000390 4040 EAST BUCHANAN ELEM.   Regular School No Elementary PK 05 2019   k_12_total 299 * * *   *       * 11           *         87   71   315 299                   11                 87 71   315
3297598 MO     school 2911940 11078   MID-BUCHANAN CO. R-V 291194000443 4020 MID-BUCHANAN ELEM.   Regular School No Elementary PK 06 2019   k_12_total 388 6 * *   *       * 6           *         86   60   404 388 6                 6                 86 60   404
3297610 MO     school 2910590 11079   BUCHANAN CO. R-IV 291059000356 4020 RUSHVILLE ELEM.   Regular School No Elementary PK 06 2019   k_12_total 170 * * *   *       * *           *         73   23   170 170                                     73 23   170
3297658 MO     school 2927060 11082   ST. JOSEPH 292706001649 4040 EDISON ELEM.   Regular School No Elementary PK 06 2019   k_12_total 194 57 82 *   *       5 51           69         *   68   393 194 57 82             5 51           69       68   393
3297664 MO     school 2927060 11082   ST. JOSEPH 292706001650 4060 ELLISON ELEM.   Regular School No Elementary KG 06 2019   k_12_total 271 21 11 *   7       * 24           8         146   30   335 271 21 11     7         24           8     146 30   335
3297670 MO     school 2927060 11082   ST. JOSEPH 292706003250 4070 CARDEN PARK ELEM   Regular School No Elementary PK 06 2019   k_12_total 403 47 71 *   *       11 53           73         *   114   587 403 47 71             11 53           73       114   587
3297676 MO     school 2927060 11082   ST. JOSEPH 292706003255 4080 OAK GROVE ELEM   Regular School No Elementary PK 06 2019   k_12_total 356 32 41 *   34       5 48           41         164   62   516 356 32 41     34       5 48           41     164 62   516
3297682 MO     school 2927060 11082   ST. JOSEPH 292706001652 4100 FIELD ELEM.   Regular School No Elementary KG 06 2019   k_12_total 251 8 15 *   30       * 18           36         128   21   325 251 8 15     30         18           36     128 21   325
3297688 MO     school 2927060 11082   ST. JOSEPH 292706001654 4140 COLEMAN ELEM.   Regular School No Elementary KG 06 2019   k_12_total 194 61 44 *   19       39 35           100         *   36   392 194 61 44     19       39 35           100       36   392
3297694 MO     school 2927060 11082   ST. JOSEPH 292706001657 4180 HOSEA ELEM.   Regular School No Elementary KG 05 2019   k_12_total 392 17 55 *   *       13 39           59         *   47   519 392 17 55             13 39           59       47   519
3297704 MO     school 2927060 11082   ST. JOSEPH 292706001659 4220 HYDE ELEM.   Regular School No Elementary KG 05 2019   k_12_total 305 7 43 *   5       8 27           51         251   40   395 305 7 43     5       8 27           51     251 40   395
3297714 MO     school 2927060 11082   ST. JOSEPH 292706001662 4260 LINDBERGH ELEM.   Regular School No Elementary KG 05 2019   k_12_total 377 46 38 *   *       9 62           32         *   70   533 377 46 38             9 62           32       70   533
3297720 MO     school 2927060 11082   ST. JOSEPH 292706001663 4280 MARK TWAIN ELEM.   Regular School No Elementary PK 06 2019   k_12_total 245 34 20 *   *       * 38           19         *   33   341 245 34 20               38           19       33   341
3297726 MO     school 2927060 11082   ST. JOSEPH 292706001667 4390 PARKWAY ELEM.   Regular School No Elementary KG 06 2019   k_12_total 310 20 21 *   *       7 35           17         *   34   399 310 20 21             7 35           17       34   399
3297732 MO     school 2927060 11082   ST. JOSEPH 292706001668 4400 PERSHING ELEM.   Regular School No Elementary KG 06 2019   k_12_total 256 * 13 *   5       * 26           12         175   33   304 256   13     5         26           12     175 33   304
3297738 MO     school 2927060 11082   ST. JOSEPH 292706001669 4420 PICKETT ELEM.   Regular School No Elementary PK 06 2019   k_12_total 235 11 17 *   *       * 38           *         *   35   301 235 11 17               38                   35   301
3297744 MO     school 2927060 11082   ST. JOSEPH 292706001672 4460 SKAITH ELEM.   Regular School No Elementary PK 06 2019   k_12_total 305 20 20 *   6       * 57           7         241   49   411 305 20 20     6         57           7     241 49   411
3297756 MO     school 2921750 12108   NEELYVILLE R-IV 292175001201 4040 HILLVIEW ELEM.   Regular School No Elementary PK 02 2019   k_12_total 135 * * *   *       * 5           *         93   26   142 135                   5                 93 26   142
3297762 MO     school 2921750 12108   NEELYVILLE R-IV 292175001202 4060 NEELYVILLE ELEM.   Regular School No Elementary 03 06 2019   k_12_total 185 6 * *   *       * 7           *         137   44   202 185 6                 7                 137 44   202
3297780 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001467 4020 EUGENE FIELD ELEM.   Regular School No Elementary 01 03 2019   k_12_total 243 30 8 *   *       * 19           *         *   48   300 243 30 8               19                   48   300
3297792 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001471 4080 LAKE ROAD ELEM.   Regular School No Elementary 01 04 2019   k_12_total 168 44 6 *   *       * 32           *         *   56   251 168 44 6               32                   56   251
3297798 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001472 5020 POPLAR BLUFF KINDERGARTEN CTR.   Regular School No Elementary KG KG 2019   k_12_total 301 40 8 *   *       * 22           *         *   50   374 301 40 8               22                   50   374
3297804 MO     school 2925450 12109   POPLAR BLUFF R-I 292545001474 5040 OAK GROVE ELEM.   Regular School No Elementary 01 03 2019   k_12_total 243 15 8 *   *       * 18           *         *   40   289 243 15 8               18                   40   289

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