enrollments

Data source: Big Local News · About: Big Local

257,968 rows where state = "MO" sorted by white_int

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
3309482 3309482 MO     school 2929280 115115   ST. LOUIS CITY 292928002009 1800 SUMNER HIGH   Regular School No 3 09 12 2016   k_12_total * 355 * *   *       * *           *         *   88   356   355                                     88   356
3309483 3309483 MO     school 2929280 115115   ST. LOUIS CITY 292928002009 1800 SUMNER HIGH   Regular School No High 09 12 2017   k_12_total * 319 * *   *       * *           *         *   96   320   319                                     96   320
3309484 3309484 MO     school 2929280 115115   ST. LOUIS CITY 292928002009 1800 SUMNER HIGH   Regular School No High 09 12 2018   k_12_total * 269 * *   *       * *           *         *   77   272   269                                     77   272
3309485 3309485 MO     school 2929280 115115   ST. LOUIS CITY 292928002009 1800 SUMNER HIGH   Regular School No High 09 12 2019   k_12_total * 262 * *   *       * *           *         *   69   267   262                                     69   267
3309486 3309486 MO     school 2929280 115115   ST. LOUIS CITY 292928002009 1800 SUMNER HIGH   Regular School No High 09 12 2020   k_12_total * 190 * *   *       * *           *         *   52   193   190                                     52   193
3309487 3309487 MO     school 2929280 115115   ST. LOUIS CITY 292928002011 1830 VASHON HIGH   Regular School No 3 09 12 2015   k_12_total * 642 * *   *       * *           9         *   126   645   642                             9       126   645
3309488 3309488 MO     school 2929280 115115   ST. LOUIS CITY 292928002011 1830 VASHON HIGH   Regular School No 3 09 12 2016   k_12_total * 613 * *   *       * *           *         *   127   616   613                                     127   616
3309489 3309489 MO     school 2929280 115115   ST. LOUIS CITY 292928002011 1830 VASHON HIGH   Regular School No High 09 12 2017   k_12_total * 506 * *   *       * *           *         *   104   510   506                                     104   510
3309490 3309490 MO     school 2929280 115115   ST. LOUIS CITY 292928002011 1830 VASHON HIGH   Regular School No High 09 12 2018   k_12_total * 418 * *   *       * *           *         *   92   422   418                                     92   422
3309491 3309491 MO     school 2929280 115115   ST. LOUIS CITY 292928002011 1830 VASHON HIGH   Regular School No High 09 12 2019   k_12_total * 434 * *   *       * *           *         *   103   440   434                                     103   440
3309499 3309499 MO     school 2929280 115115   ST. LOUIS CITY 292928002878 2080 YEATMAN-LIDDELL MIDDLE SCHOOL   Regular School No 2 06 08 2015   k_12_total * 356 * *   *       * *           5         *   84   358   356                             5       84   358
3309500 3309500 MO     school 2929280 115115   ST. LOUIS CITY 292928002878 2080 YEATMAN-LIDDELL MIDDLE SCHOOL   Regular School No 2 06 08 2016   k_12_total * 345 * *   *       * *           *         *   80   350   345                                     80   350
3309502 3309502 MO     school 2929280 115115   ST. LOUIS CITY 292928002878 2080 YEATMAN-LIDDELL MIDDLE SCHOOL   Regular School No Middle 06 08 2018   k_12_total * 298 * *   *       * *           *         *   85   301   298                                     85   301
3309503 3309503 MO     school 2929280 115115   ST. LOUIS CITY 292928002878 2080 YEATMAN-LIDDELL MIDDLE SCHOOL   Regular School No Middle 06 08 2019   k_12_total * 386 * *   *       * *           *         *   97   390   386                                     97   390
3309529 3309529 MO     school 2929280 115115   ST. LOUIS CITY 292928001957 3240 LANGSTON MIDDLE   Regular School No 2 06 08 2015   k_12_total * 276 * *   *       * *           7         *   62   282   276                             7       62   282
3309530 3309530 MO     school 2929280 115115   ST. LOUIS CITY 292928001957 3240 LANGSTON MIDDLE   Regular School No 2 06 08 2016   k_12_total * 228 * *   *       * *           *         *   63   228   228                                     63   228
3309531 3309531 MO     school 2929280 115115   ST. LOUIS CITY 292928001957 3240 LANGSTON MIDDLE   Regular School No Middle 06 08 2017   k_12_total * 181 * *   *       * *           *         *   49   182   181                                     49   182
3309556 3309556 MO     school 2929280 115115   ST. LOUIS CITY 292928001877 4060 ASHLAND ELEM. AND BR.   Regular School No 1 PK 06 2015   k_12_total * 329 * *   *       * *           *         *   41   329   329                                     41   329
3309557 3309557 MO     school 2929280 115115   ST. LOUIS CITY 292928001877 4060 ASHLAND ELEM. AND BR.   Regular School No 1 PK 06 2016   k_12_total * 292 * *   *       * *           *         *   31   292   292                                     31   292
3309558 3309558 MO     school 2929280 115115   ST. LOUIS CITY 292928001877 4060 ASHLAND ELEM. AND BR.   Regular School No Elementary PK 06 2017   k_12_total * 264 * *   *       * *           *         *   28   267   264                                     28   267
3309559 3309559 MO     school 2929280 115115   ST. LOUIS CITY 292928001877 4060 ASHLAND ELEM. AND BR.   Regular School No Elementary PK 06 2018   k_12_total * 240 * *   *       * *           *         *   23   242   240                                     23   242
3309560 3309560 MO     school 2929280 115115   ST. LOUIS CITY 292928001877 4060 ASHLAND ELEM. AND BR.   Regular School No Elementary PK 06 2019   k_12_total * 184 * *   *       * *           *         *   23   184   184                                     23   184
3309561 3309561 MO     school 2929280 115115   ST. LOUIS CITY 292928001877 4060 ASHLAND ELEM. AND BR.   Regular School No Elementary PK 06 2020   k_12_total * 167 * *   *       * *           *         *   29   167   167                                     29   167
3309562 3309562 MO     school 2929280 115115   ST. LOUIS CITY 292928001888 4180 BRYAN HILL ELEM.   Regular School No 1 PK 05 2015   k_12_total * 181 * *   *       * *           *         *   21   184   181                                     21   184
3309563 3309563 MO     school 2929280 115115   ST. LOUIS CITY 292928001888 4180 BRYAN HILL ELEM.   Regular School No 1 PK 05 2016   k_12_total * 154 * *   *       * *           *         *   20   154   154                                     20   154
3309564 3309564 MO     school 2929280 115115   ST. LOUIS CITY 292928001888 4180 BRYAN HILL ELEM.   Regular School No Elementary PK 05 2017   k_12_total * 180 * *   *       * *           *         *   34   180   180                                     34   180
3309565 3309565 MO     school 2929280 115115   ST. LOUIS CITY 292928001888 4180 BRYAN HILL ELEM.   Regular School No Elementary PK 05 2018   k_12_total * 164 * *   *       * *           *         *   35   164   164                                     35   164
3309566 3309566 MO     school 2929280 115115   ST. LOUIS CITY 292928001888 4180 BRYAN HILL ELEM.   Regular School No Elementary PK 05 2019   k_12_total * 150 * *   *       * *           *         *   24   150   150                                     24   150
3309567 3309567 MO     school 2929280 115115   ST. LOUIS CITY 292928001888 4180 BRYAN HILL ELEM.   Regular School No Elementary PK 05 2020   k_12_total * 133 * *   *       * *           *         *   23   133   133                                     23   133
3309574 3309574 MO     school 2929280 115115   ST. LOUIS CITY 292928002570 4250 AMES VISUAL/PERF. ARTS   Regular School No 1 PK 05 2015   k_12_total * 341 * *   *       * *           *         *   45   345   341                                     45   345
3309575 3309575 MO     school 2929280 115115   ST. LOUIS CITY 292928002570 4250 AMES VISUAL/PERF. ARTS   Regular School No 1 PK 05 2016   k_12_total * 359 * *   *       * *           *         *   58   363   359                                     58   363
3309576 3309576 MO     school 2929280 115115   ST. LOUIS CITY 292928002570 4250 AMES VISUAL/PERF. ARTS   Regular School No Elementary PK 05 2017   k_12_total * 332 * *   *       * *           *         *   42   338   332                                     42   338
3309580 3309580 MO     school 2929280 115115   ST. LOUIS CITY 292928001903 4360 CLAY ELEM.   Regular School No 1 PK 05 2015   k_12_total * 160 * *   *       * *           *         *   22   164   160                                     22   164
3309581 3309581 MO     school 2929280 115115   ST. LOUIS CITY 292928001903 4360 CLAY ELEM.   Regular School No 1 PK 05 2016   k_12_total * 114 * *   *       * *           *         *   22   116   114                                     22   116
3309582 3309582 MO     school 2929280 115115   ST. LOUIS CITY 292928001903 4360 CLAY ELEM.   Regular School No Elementary PK 05 2017   k_12_total * 138 * *   *       * *           *         *   24   140   138                                     24   140
3309583 3309583 MO     school 2929280 115115   ST. LOUIS CITY 292928001903 4360 CLAY ELEM.   Regular School No Elementary PK 05 2018   k_12_total * 121 * *   *       * *           *         *   24   123   121                                     24   123
3309584 3309584 MO     school 2929280 115115   ST. LOUIS CITY 292928001903 4360 CLAY ELEM.   Regular School No Elementary PK 05 2019   k_12_total * 124 * *   *       * *           *         *   15   131   124                                     15   131
3309585 3309585 MO     school 2929280 115115   ST. LOUIS CITY 292928001903 4360 CLAY ELEM.   Regular School No Elementary PK 05 2020   k_12_total * 98 * *   *       * *           *         *   16   101   98                                     16   101
3309587 3309587 MO     school 2929280 115115   ST. LOUIS CITY 292928001906 4400 COLE ELEM.   Regular School No 1 PK 08 2016   k_12_total * 347 * *   *       * *           *         *   53   352   347                                     53   352
3309588 3309588 MO     school 2929280 115115   ST. LOUIS CITY 292928001906 4400 COLE ELEM.   Regular School No Elementary PK 08 2017   k_12_total * 349 * *   *       * *           *         *   35   357   349                                     35   357
3309589 3309589 MO     school 2929280 115115   ST. LOUIS CITY 292928001906 4400 COLE ELEM.   Regular School No Elementary PK 08 2018   k_12_total * 345 5 *   *       * *           *         *   40   353   345 5                                   40   353
3309590 3309590 MO     school 2929280 115115   ST. LOUIS CITY 292928001906 4400 COLE ELEM.   Regular School No Elementary PK 08 2019   k_12_total * 329 5 *   *       * *           *         *   44   336   329 5                                   44   336
3309591 3309591 MO     school 2929280 115115   ST. LOUIS CITY 292928001906 4400 COLE ELEM.   Regular School No Elementary PK 08 2020   k_12_total * 272 * *   *       * *           *         *   33   280   272                                     33   280
3309592 3309592 MO     school 2929280 115115   ST. LOUIS CITY 292928002693 4420 COLUMBIA ELEM. COMM. ED. CTR.   Regular School No 1 PK 06 2015   k_12_total * 181 * *   *       * *           *         *   24   182   181                                     24   182
3309593 3309593 MO     school 2929280 115115   ST. LOUIS CITY 292928002693 4420 COLUMBIA ELEM. COMM. ED. CTR.   Regular School No 1 PK 06 2016   k_12_total * 125 * *   *       * *           *         *   18   125   125                                     18   125
3309594 3309594 MO     school 2929280 115115   ST. LOUIS CITY 292928002693 4420 COLUMBIA ELEM. COMM. ED. CTR.   Regular School No Elementary PK 06 2017   k_12_total * 155 * *   *       * *           *         *   16   157   155                                     16   157
3309595 3309595 MO     school 2929280 115115   ST. LOUIS CITY 292928002693 4420 COLUMBIA ELEM. COMM. ED. CTR.   Regular School No Elementary PK 06 2018   k_12_total * 150 * *   *       * *           *         *   14   150   150                                     14   150
3309596 3309596 MO     school 2929280 115115   ST. LOUIS CITY 292928002693 4420 COLUMBIA ELEM. COMM. ED. CTR.   Regular School No Elementary PK 06 2019   k_12_total * 173 * *   *       * *           *         *   14   175   173                                     14   175
3309597 3309597 MO     school 2929280 115115   ST. LOUIS CITY 292928002693 4420 COLUMBIA ELEM. COMM. ED. CTR.   Regular School No Elementary PK 06 2020   k_12_total * 171 * *   *       * *           *         *   13   172   171                                     13   172
3309598 3309598 MO     school 2929280 115115   ST. LOUIS CITY 292928001911 4440 COTE BRILLIANTE ELEM.   Regular School No 1 PK 06 2015   k_12_total * 231 * *   *       * *           *         *   38   235   231                                     38   235
3309599 3309599 MO     school 2929280 115115   ST. LOUIS CITY 292928001911 4440 COTE BRILLIANTE ELEM.   Regular School No 1 PK 06 2016   k_12_total * 184 * *   *       * *           *         *   30   185   184                                     30   185
3309600 3309600 MO     school 2929280 115115   ST. LOUIS CITY 292928001911 4440 COTE BRILLIANTE ELEM.   Regular School No Elementary PK 06 2017   k_12_total * 136 * *   *       * *           *         *   15   138   136                                     15   138
3309607 3309607 MO     school 2929280 115115   ST. LOUIS CITY 292928001916 4480 DUNBAR AND BR.   Regular School No 1 PK 06 2015   k_12_total * 192 * *   *       * *           *         *   32   194   192                                     32   194
3309608 3309608 MO     school 2929280 115115   ST. LOUIS CITY 292928001916 4480 DUNBAR AND BR.   Regular School No 1 PK 06 2016   k_12_total * 149 * *   *       * *           *         *   13   150   149                                     13   150
3309609 3309609 MO     school 2929280 115115   ST. LOUIS CITY 292928001916 4480 DUNBAR AND BR.   Regular School No Elementary PK 06 2017   k_12_total * 148 * *   *       * *           *         *   21   148   148                                     21   148
3309610 3309610 MO     school 2929280 115115   ST. LOUIS CITY 292928001916 4480 DUNBAR AND BR.   Regular School No Elementary PK 06 2018   k_12_total * 123 * *   *       * *           *         *   14   123   123                                     14   123
3309611 3309611 MO     school 2929280 115115   ST. LOUIS CITY 292928001916 4480 DUNBAR AND BR.   Regular School No Elementary PK 06 2019   k_12_total * 119 * *   *       * *           *         *   14   119   119                                     14   119
3309612 3309612 MO     school 2929280 115115   ST. LOUIS CITY 292928001916 4480 DUNBAR AND BR.   Regular School No Elementary PK 06 2020   k_12_total * 123 * *   *       * *           5         *   12   123   123                             5       12   123
3309613 3309613 MO     school 2929280 115115   ST. LOUIS CITY 292928001923 4580 FARRAGUT ELEM.   Regular School No 1 PK 06 2015   k_12_total * 164 * *   *       * *           *         *   15   164   164                                     15   164
3309614 3309614 MO     school 2929280 115115   ST. LOUIS CITY 292928001923 4580 FARRAGUT ELEM.   Regular School No 1 PK 06 2016   k_12_total * 144 * *   *       * *           *         *   20   144   144                                     20   144
3309615 3309615 MO     school 2929280 115115   ST. LOUIS CITY 292928001923 4580 FARRAGUT ELEM.   Regular School No Elementary PK 06 2017   k_12_total * 149 * *   *       * *           *         *   20   150   149                                     20   150
3309616 3309616 MO     school 2929280 115115   ST. LOUIS CITY 292928001923 4580 FARRAGUT ELEM.   Regular School No Elementary PK 06 2018   k_12_total * 124 * *   *       * *           *         *   21   124   124                                     21   124
3309617 3309617 MO     school 2929280 115115   ST. LOUIS CITY 292928001923 4580 FARRAGUT ELEM.   Regular School No Elementary PK 06 2019   k_12_total * 115 * *   *       * *           *         *   17   115   115                                     17   115
3309618 3309618 MO     school 2929280 115115   ST. LOUIS CITY 292928001923 4580 FARRAGUT ELEM.   Regular School No Elementary PK 06 2020   k_12_total * 128 * *   *       * *           *         *   31   128   128                                     31   128
3309619 3309619 MO     school 2929280 115115   ST. LOUIS CITY 292928002571 4630 FORD-FORD BR. ELEM. COMM. ED.   Regular School No 1 PK 06 2015   k_12_total * 295 * *   *       * *           *         *   32   297   295                                     32   297
3309620 3309620 MO     school 2929280 115115   ST. LOUIS CITY 292928002571 4630 FORD-FORD BR. ELEM. COMM. ED.   Regular School No 1 PK 06 2016   k_12_total * 232 * *   *       * *           *         *   27   233   232                                     27   233
3309621 3309621 MO     school 2929280 115115   ST. LOUIS CITY 292928002571 4630 FORD-FORD BR. ELEM. COMM. ED.   Regular School No Elementary PK 06 2017   k_12_total * 226 * *   *       * *           *         *   30   229   226                                     30   229
3309622 3309622 MO     school 2929280 115115   ST. LOUIS CITY 292928002571 4630 FORD-FORD BR. ELEM. COMM. ED.   Regular School No Elementary PK 06 2018   k_12_total * 186 * *   *       * *           *         *   18   186   186                                     18   186
3309623 3309623 MO     school 2929280 115115   ST. LOUIS CITY 292928002571 4630 FORD-FORD BR. ELEM. COMM. ED.   Regular School No Elementary PK 06 2019   k_12_total * 167 * *   *       * *           *         *   20   167   167                                     20   167
3309624 3309624 MO     school 2929280 115115   ST. LOUIS CITY 292928002571 4630 FORD-FORD BR. ELEM. COMM. ED.   Regular School No Elementary PK 06 2020   k_12_total * 136 * *   *       * *           *         *   20   136   136                                     20   136
3309637 3309637 MO     school 2929280 115115   ST. LOUIS CITY 292928001937 4780 HAMILTON ELEM. COMMUNITY ED.   Regular School No 1 PK 05 2015   k_12_total * 349 * *   *       * *           10         *   50   350   349                             10       50   350
3309638 3309638 MO     school 2929280 115115   ST. LOUIS CITY 292928001937 4780 HAMILTON ELEM. COMMUNITY ED.   Regular School No 1 PK 05 2016   k_12_total * 281 * *   *       * *           *         *   45   283   281                                     45   283
3309639 3309639 MO     school 2929280 115115   ST. LOUIS CITY 292928001937 4780 HAMILTON ELEM. COMMUNITY ED.   Regular School No Elementary PK 05 2017   k_12_total * 279 6 *   *       * *           6         *   40   288   279 6                           6       40   288
3309640 3309640 MO     school 2929280 115115   ST. LOUIS CITY 292928001937 4780 HAMILTON ELEM. COMMUNITY ED.   Regular School No Elementary PK 05 2018   k_12_total * 289 * *   *       * *           *         *   43   293   289                                     43   293
3309641 3309641 MO     school 2929280 115115   ST. LOUIS CITY 292928001937 4780 HAMILTON ELEM. COMMUNITY ED.   Regular School No Elementary PK 05 2019   k_12_total * 238 * *   *       * *           *         *   33   241   238                                     33   241
3309642 3309642 MO     school 2929280 115115   ST. LOUIS CITY 292928001937 4780 HAMILTON ELEM. COMMUNITY ED.   Regular School No Elementary PK 05 2020   k_12_total * 251 * *   *       * *           *         *   37   252   251                                     37   252
3309643 3309643 MO     school 2929280 115115   ST. LOUIS CITY 292928001942 4880 HENRY ELEM.   Regular School No 1 PK 06 2015   k_12_total * 181 * *   *       * *           *         *   14   182   181                                     14   182
3309644 3309644 MO     school 2929280 115115   ST. LOUIS CITY 292928001942 4880 HENRY ELEM.   Regular School No 1 PK 06 2016   k_12_total * 178 * *   *       * *           *         *   20   180   178                                     20   180
3309645 3309645 MO     school 2929280 115115   ST. LOUIS CITY 292928001942 4880 HENRY ELEM.   Regular School No Elementary PK 06 2017   k_12_total * 224 * *   *       * *           *         *   28   228   224                                     28   228
3309646 3309646 MO     school 2929280 115115   ST. LOUIS CITY 292928001942 4880 HENRY ELEM.   Regular School No Elementary PK 06 2018   k_12_total * 240 * *   *       * *           *         *   32   241   240                                     32   241
3309647 3309647 MO     school 2929280 115115   ST. LOUIS CITY 292928001942 4880 HENRY ELEM.   Regular School No Elementary PK 06 2019   k_12_total * 199 * *   *       * *           *         *   26   199   199                                     26   199
3309648 3309648 MO     school 2929280 115115   ST. LOUIS CITY 292928001942 4880 HENRY ELEM.   Regular School No Elementary PK 06 2020   k_12_total * 209 * *   *       * *           *         *   38   211   209                                     38   211
3309649 3309649 MO     school 2929280 115115   ST. LOUIS CITY 292928000444 4890 HICKEY ELEM.   Regular School No 1 PK 05 2015   k_12_total * 194 * *   *       * *           *         *   38   196   194                                     38   196
3309650 3309650 MO     school 2929280 115115   ST. LOUIS CITY 292928000444 4890 HICKEY ELEM.   Regular School No 1 PK 05 2016   k_12_total * 156 * *   *       * *           *         *   25   157   156                                     25   157
3309651 3309651 MO     school 2929280 115115   ST. LOUIS CITY 292928000444 4890 HICKEY ELEM.   Regular School No Elementary PK 05 2017   k_12_total * 173 * *   *       * *           *         *   33   174   173                                     33   174
3309652 3309652 MO     school 2929280 115115   ST. LOUIS CITY 292928000444 4890 HICKEY ELEM.   Regular School No Elementary PK 05 2018   k_12_total * 179 * *   *       * *           *         *   22   180   179                                     22   180
3309653 3309653 MO     school 2929280 115115   ST. LOUIS CITY 292928000444 4890 HICKEY ELEM.   Regular School No Elementary PK 05 2019   k_12_total * 175 * *   *       * *           *         *   13   175   175                                     13   175
3309654 3309654 MO     school 2929280 115115   ST. LOUIS CITY 292928000444 4890 HICKEY ELEM.   Regular School No Elementary PK 05 2020   k_12_total * 185 * *   *       * *           *         *   16   185   185                                     16   185
3309655 3309655 MO     school 2929280 115115   ST. LOUIS CITY 292928001943 4900 HERZOG ELEM.   Regular School No 1 PK 06 2015   k_12_total * 400 * *   *       * *           *         *   38   401   400                                     38   401
3309656 3309656 MO     school 2929280 115115   ST. LOUIS CITY 292928001943 4900 HERZOG ELEM.   Regular School No 1 PK 06 2016   k_12_total * 297 * *   *       * *           *         *   25   298   297                                     25   298
3309657 3309657 MO     school 2929280 115115   ST. LOUIS CITY 292928001943 4900 HERZOG ELEM.   Regular School No Elementary PK 06 2017   k_12_total * 271 * *   *       * *           *         *   21   272   271                                     21   272
3309658 3309658 MO     school 2929280 115115   ST. LOUIS CITY 292928001943 4900 HERZOG ELEM.   Regular School No Elementary PK 06 2018   k_12_total * 269 * *   *       * *           *         *   21   270   269                                     21   270
3309659 3309659 MO     school 2929280 115115   ST. LOUIS CITY 292928001943 4900 HERZOG ELEM.   Regular School No Elementary PK 06 2019   k_12_total * 233 * *   *       * *           *         *   24   234   233                                     24   234
3309660 3309660 MO     school 2929280 115115   ST. LOUIS CITY 292928001943 4900 HERZOG ELEM.   Regular School No Elementary PK 06 2020   k_12_total * 203 * *   *       * *           *         *   18   205   203                                     18   205
3309663 3309663 MO     school 2929280 115115   ST. LOUIS CITY 292928002170 4920 HODGEN ELEM.   Regular School No Elementary PK 06 2017   k_12_total * 200 * *   *       * *           5         *   38   203   200                             5       38   203
3309664 3309664 MO     school 2929280 115115   ST. LOUIS CITY 292928002170 4920 HODGEN ELEM.   Regular School No Elementary PK 06 2018   k_12_total * 184 * *   *       * *           6         *   37   187   184                             6       37   187
3309665 3309665 MO     school 2929280 115115   ST. LOUIS CITY 292928002170 4920 HODGEN ELEM.   Regular School No Elementary PK 06 2019   k_12_total * 194 * *   *       * *           7         *   40   198   194                             7       40   198
3309666 3309666 MO     school 2929280 115115   ST. LOUIS CITY 292928002170 4920 HODGEN ELEM.   Regular School No Elementary PK 06 2020   k_12_total * 147 * *   *       * *           6         *   35   156   147                             6       35   156
3309678 3309678 MO     school 2929280 115115   ST. LOUIS CITY 292928003211 4990 ACAD OF ENVT SCI/MATH ELEM   Regular School No 1 PK 05 2015   k_12_total * 324 * *   *       * *           *         *   25   328   324                                     25   328
3309679 3309679 MO     school 2929280 115115   ST. LOUIS CITY 292928003211 4990 ACAD OF ENVT SCI/MATH ELEM   Regular School No 1 PK 05 2016   k_12_total * 261 * *   *       * *           *         *   18   261   261                                     18   261

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