enrollments

Data source: Big Local News · About: Big Local

16,123 rows where grade = "k_12_total" and state = "MO" sorted by free_and_reduced_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • k_12_total · 16,123 ✖
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
3296692 3296692 MO     school 2916740 1091   KIRKSVILLE R-III 291674000916 1050 KIRKSVILLE SR. HIGH   Regular School No 3 09 12 2016   k_12_total 680 22 15 *   20       * 10           11         298.2   80   750 680 22 15     20         10           11       80   750
3296693 3296693 MO     school 2916740 1091   KIRKSVILLE R-III 291674000916 1050 KIRKSVILLE SR. HIGH   Regular School No High 09 12 2017   k_12_total 676 33 16 *   17       * 11           21         329.1   81   755 676 33 16     17         11           21       81   755
3296699 3296699 MO     school 2916740 1091   KIRKSVILLE R-III 291674002611 3000 WILLIAM MATTHEW MIDDLE SCHOOL   Regular School No Middle 06 08 2017   k_12_total 475 29 7 *   9       * 13           14         284.1   70   534 475 29 7     9         13           14       70   534
3296702 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
3296755 3296755 MO     school 2927570 2097   SAVANNAH R-III 292757001693 1050 SAVANNAH HIGH   Regular School No High 09 12 2019   k_12_total 680 16 * *   5       * 12           *         175.4   81   723 680 16       5         12                   81   723
3296756 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
3296783 3296783 MO     school 2927570 2097   SAVANNAH R-III 292757001692 4040 MINNIE CLINE ELEM.   Regular School No Elementary PK 05 2017   k_12_total 522 6 9 *   *       * 8           *         232.3   84   549 522 6 9               8                   84   549
3296787 3296787 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No 1 PK PK 2015   k_12_total * * * *   *       * *           *         *   *   0                                             0
3296788 3296788 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No 1 PK PK 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3296789 3296789 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No Elementary PK PK 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3296790 3296790 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No Prekindergarten PK PK 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3296791 3296791 MO     school 2927570 2097   SAVANNAH R-III 292757003186 7500 EARLY CHILDHOOD LEARNING CTR   Regular School No Prekindergarten PK PK 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3296792 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
3296797 3296797 MO     school 2929940 3031   TARKIO R-I 292994002067 1050 TARKIO HIGH   Regular School No High 07 12 2019   k_12_total 146 * * *   *       * *           *         64.3   32   152 146                                       32   152
3296803 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
3296823 3296823 MO     school 2911760 3033   FAIRFAX R-III 291176000432 4020 FAIRFAX ELEM.   Regular School No 1 PK 06 2015   k_12_total 59 * * *   *       * *           *         30.1   5   60 59                                       5   60
3296824 3296824 MO     school 2911760 3033   FAIRFAX R-III 291176000432 4020 FAIRFAX ELEM.   Regular School No 1 PK 06 2016   k_12_total 67 * * *   *       * *           *         32.2   6   67 67                                       6   67
3296825 3296825 MO     school 2911760 3033   FAIRFAX R-III 291176000432 4020 FAIRFAX ELEM.   Regular School No Elementary PK 06 2017   k_12_total 65 * * *   *       * *           *         29.2   8   67 65                                       8   67
3296826 3296826 MO     school 2911760 3033   FAIRFAX R-III 291176000432 4020 FAIRFAX ELEM.   Regular School No Elementary PK 06 2018   k_12_total 70 * * *   *       * *           *         32.2   14   72 70                                       14   72
3296827 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
3296828 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
3296856 3296856 MO     school 2920810 4110   MEXICO 59 292081001137 1050 MEXICO HIGH   Regular School No High 09 12 2018   k_12_total 544 56 43 *   6       * 50           8         270.3   67   700 544 56 43     6         50           8       67   700
3296858 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
3296862 3296862 MO     school 2920810 4110   MEXICO 59 292081001136 2050 MEXICO MIDDLE   Regular School No Middle 06 08 2018   k_12_total 414 35 47 *   *       * 39           18         *   59   537 414 35 47               39           18       59   537
3296863 3296863 MO     school 2920810 4110   MEXICO 59 292081001136 2050 MEXICO MIDDLE   Regular School No Middle 06 08 2019   k_12_total 386 31 58 *   *       * 46           18         *   53   523 386 31 58               46           18       53   523
3296864 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
3296865 3296865 MO     school 2920810 4110   MEXICO 59 292081001132 4020 EUGENE FIELD ELEM.   Regular School No 1 KG 05 2015   k_12_total 334 47 20 *   *       * 41           *         *   40   446 334 47 20               41                   40   446
3296866 3296866 MO     school 2920810 4110   MEXICO 59 292081001132 4020 EUGENE FIELD ELEM.   Regular School No 1 KG 05 2016   k_12_total 329 45 22 *   *       * 47           *         *   40   445 329 45 22               47                   40   445
3296867 3296867 MO     school 2920810 4110   MEXICO 59 292081001132 4020 EUGENE FIELD ELEM.   Regular School No Elementary KG 05 2017   k_12_total 325 43 23 *   *       * 43           *         *   37   435 325 43 23               43                   37   435
3296868 3296868 MO     school 2920810 4110   MEXICO 59 292081001132 4020 EUGENE FIELD ELEM.   Regular School No Elementary KG 05 2018   k_12_total 298 50 15 *   *       * 42           *         *   39   405 298 50 15               42                   39   405
3296869 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
3296870 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
3296871 3296871 MO     school 2920810 4110   MEXICO 59 292081001133 4060 HAWTHORNE ELEM.   Regular School No 1 KG 05 2015   k_12_total 309 14 71 *   *       * 38           59         *   43   435 309 14 71               38           59       43   435
3296872 3296872 MO     school 2920810 4110   MEXICO 59 292081001133 4060 HAWTHORNE ELEM.   Regular School No 1 KG 05 2016   k_12_total 304 24 66 *   *       * 37           60         *   34   435 304 24 66               37           60       34   435
3296873 3296873 MO     school 2920810 4110   MEXICO 59 292081001133 4060 HAWTHORNE ELEM.   Regular School No Elementary KG 05 2017   k_12_total 309 26 66 *   *       * 39           54         *   19   444 309 26 66               39           54       19   444
3296874 3296874 MO     school 2920810 4110   MEXICO 59 292081001133 4060 HAWTHORNE ELEM.   Regular School No Elementary KG 05 2018   k_12_total 326 35 64 *   5       * 33           53         *   19   464 326 35 64     5         33           53       19   464
3296875 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
3296876 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
3296877 3296877 MO     school 2920810 4110   MEXICO 59 292081001134 4080 MCMILLAN ELEM.   Regular School No 1 PK 05 2015   k_12_total 216 11 9 *   *       * 15           *         *   35   251 216 11 9               15                   35   251
3296878 3296878 MO     school 2920810 4110   MEXICO 59 292081001134 4080 MCMILLAN ELEM.   Regular School No 1 PK 05 2016   k_12_total 185 7 7 *   *       * 22           *         *   29   221 185 7 7               22                   29   221
3296879 3296879 MO     school 2920810 4110   MEXICO 59 292081001134 4080 MCMILLAN ELEM.   Regular School No Elementary PK 05 2017   k_12_total 181 10 * *   *       * 19           *         *   23   214 181 10                 19                   23   214
3296880 3296880 MO     school 2920810 4110   MEXICO 59 292081001134 4080 MCMILLAN ELEM.   Regular School No Elementary PK 05 2018   k_12_total 163 10 8 *   *       * 20           *         *   24   201 163 10 8               20                   24   201
3296881 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
3296882 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
3296953 3296953 MO     school 2925620 5124   PURDY R-II 292562001502 1050 PURDY HIGH   Regular School No High 07 12 2019   k_12_total 177 * 74 *   7       * *           23         146.3   19   261 177   74     7                     23       19   261
3296957 3296957 MO     school 2925620 5124   PURDY R-II 292562002221 3000 PURDY MIDDLE   Regular School No Middle 05 08 2017   k_12_total 149 * * *   7       44 *           12         136.3   25   206 149         7       44             12       25   206
3296958 3296958 MO     school 2925620 5124   PURDY R-II 292562002221 3000 PURDY MIDDLE   Regular School No Middle 05 08 2018   k_12_total 158 * 38 *   6       * *           18         126.3   27   205 158   38     6                     18       27   205
3296965 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
3296966 3296966 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No 1 PK 08 2015   k_12_total 112 * * *   *       * 5           *         *   20   122 112                   5                   20   122
3296967 3296967 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No 1 PK 08 2016   k_12_total 111 * * *   *       * 7           *         *   19   121 111                   7                   19   121
3296968 3296968 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No Elementary PK 08 2017   k_12_total 112 * * *   *       * 8           *         *   22   123 112                   8                   22   123
3296969 3296969 MO     school 2928200 5127   SHELL KNOB 78 292820001735 4020 SHELL KNOB ELEM.   Regular School No Elementary PK 08 2018   k_12_total 117 * * *   *       * 8           *         *   21   131 117                   8                   21   131
3296970 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
3296971 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
3296974 3296974 MO     school 2921120 5128   MONETT R-I 292112001162 1050 MONETT HIGH   Regular School No High 09 12 2017   k_12_total 456 5 238 8   8       * 15           57         383.2   80   733 456 5 238 8   8         15           57       80   733
3296975 3296975 MO     school 2921120 5128   MONETT R-I 292112001162 1050 MONETT HIGH   Regular School No High 09 12 2018   k_12_total 435 7 280 5   15       * 17           85         381.2   90   763 435 7 280 5   15         17           85       90   763
3296990 3296990 MO     school 2921120 5128   MONETT R-I 292112001160 4020 MONETT ELEM.   Regular School No 1 PK 02 2015   k_12_total 330 * 179 6   *       * 5           185         382.4   94   528 330   179 6             5           185       94   528
3296992 3296992 MO     school 2921120 5128   MONETT R-I 292112001160 4020 MONETT ELEM.   Regular School No Elementary PK 02 2017   k_12_total 271 * 182 *   *       * 13           166         343.1   83   478 271   182               13           166       83   478
3296993 3296993 MO     school 2921120 5128   MONETT R-I 292112001160 4020 MONETT ELEM.   Regular School No Elementary PK 02 2018   k_12_total 263 * 191 *   10       * 10           170         343.1   87   482 263   191     10         10           170       87   482
3297003 3297003 MO     school 2918510 6101   LIBERAL R-II 291851001003 1050 LIBERAL HIGH   Regular School No 3 09 12 2016   k_12_total 142 * * *   *       * *           *         64.2   27   148 142                                       27   148
3297027 3297027 MO     school 2912930 6103   GOLDEN CITY R-III 291293000541 4020 GOLDEN CITY ELEM.   Regular School No 1 KG 06 2016   k_12_total 106 * * *   *       * 9           *         82.4   18   116 106                   9                   18   116
3297032 3297032 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No 4 PK 12 2015   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297033 3297033 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No 4 PK 12 2016   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297034 3297034 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No Other PK 12 2017   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297035 3297035 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No Other PK 12 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297036 3297036 MO     school 2917850 6104   LAMAR R-I 291785001487 1010 LOCKWOOD SPECL. EDUC. COOP.   Special Education School No Other PK 12 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297037 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
3297076 3297076 MO     school 2904170 7122   BALLARD R-II 290417000042 1050 BALLARD HIGH   Regular School No High 07 12 2017   k_12_total 52 * * *   *       * *           *         22.3   9   56 52                                       9   56
3297090 3297090 MO     school 2902850 7123   ADRIAN R-III 290285000002 1050 ADRIAN SR. HIGH   Regular School No High 06 12 2019   k_12_total 343 * 7 *   *       * *           *         109.4   24   356 343   7                                   24   356
3297101 3297101 MO     school 2926310 7124   RICH HILL R-IV 292631001544 1050 RICH HILL HIGH   Regular School No High 07 12 2018   k_12_total 149 * * *   *       * *           *         96.3   22   153 149                                       22   153
3297104 3297104 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No 1 PK 06 2015   k_12_total 184 * * *   *       * *           *         *   25   190 184                                       25   190
3297105 3297105 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No 1 PK 06 2016   k_12_total 176 * * *   *       * 8           *         *   23   188 176                   8                   23   188
3297106 3297106 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No Elementary PK 06 2017   k_12_total 150 * * *   *       * 7           *         *   23   161 150                   7                   23   161
3297107 3297107 MO     school 2926310 7124   RICH HILL R-IV 292631001545 4020 RICH HILL ELEM.   Regular School No Elementary KG 06 2018   k_12_total 150 * * *   *       6 8           *         *   26   170 150                 6 8                   26   170
3297109 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
3297126 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
3297127 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
3297130 3297130 MO     school 2906360 7129   BUTLER R-V 290636000158 1050 BUTLER HIGH   Regular School No High 07 12 2017   k_12_total 447 9 8 *   *       * 5           *         233.3   54   475 447 9 8               5                   54   475
3297140 3297140 MO     school 2906360 7129   BUTLER R-V 290636003308 7500 BUTLER EARLY CHILDHOOD   Regular School No Prekindergarten PK PK 2018   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297141 3297141 MO     school 2906360 7129   BUTLER R-V 290636003308 7500 BUTLER EARLY CHILDHOOD   Regular School No Prekindergarten PK PK 2019   k_12_total * * * *   *       * *           *         *   *   0                                             0
3297142 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
3297155 3297155 MO     school 2931070 8107   WARSAW R-IX 293107002152 1050 WARSAW HIGH   Regular School No 3 09 12 2015   k_12_total 391 8 8 *   *       * *           *         *   87   412 391 8 8                                   87   412
3297156 3297156 MO     school 2931070 8107   WARSAW R-IX 293107002152 1050 WARSAW HIGH   Regular School No 3 09 12 2016   k_12_total 373 5 7 *   *       * *           *         *   68   388 373 5 7                                   68   388
3297157 3297157 MO     school 2931070 8107   WARSAW R-IX 293107002152 1050 WARSAW HIGH   Regular School No High 09 12 2017   k_12_total 353 5 6 *   *       * *           *         *   60   371 353 5 6                                   60   371
3297158 3297158 MO     school 2931070 8107   WARSAW R-IX 293107002152 1050 WARSAW HIGH   Regular School No High 09 12 2018   k_12_total 358 6 5 *   *       * 7           *         *   54   377 358 6 5               7                   54   377
3297159 3297159 MO     school 2931070 8107   WARSAW R-IX 293107002152 1050 WARSAW HIGH   Regular School No High 09 12 2019   k_12_total 342 5 6 *   *       * 7           *         *   60   361 342 5 6               7                   60   361
3297160 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
3297161 3297161 MO     school 2931070 8107   WARSAW R-IX 293107002650 3000 JOHN BOISE MIDDLE   Regular School No 2 06 08 2015   k_12_total 288 * 6 *   *       * 5           *         *   36   305 288   6               5                   36   305
3297162 3297162 MO     school 2931070 8107   WARSAW R-IX 293107002650 3000 JOHN BOISE MIDDLE   Regular School No 2 06 08 2016   k_12_total 286 * 5 *   *       * 7           *         *   44   303 286   5               7                   44   303
3297163 3297163 MO     school 2931070 8107   WARSAW R-IX 293107002650 3000 JOHN BOISE MIDDLE   Regular School No Middle 06 08 2017   k_12_total 263 * 6 *   *       * *           *         *   50   275 263   6                                   50   275
3297164 3297164 MO     school 2931070 8107   WARSAW R-IX 293107002650 3000 JOHN BOISE MIDDLE   Regular School No Middle 06 08 2018   k_12_total 260 * 6 *   *       * 6           *         *   54   274 260   6               6                   54   274
3297165 3297165 MO     school 2931070 8107   WARSAW R-IX 293107002650 3000 JOHN BOISE MIDDLE   Regular School No Middle 06 08 2019   k_12_total 244 * 8 *   *       * 10           *         *   57   263 244   8               10                   57   263
3297166 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
3297167 3297167 MO     school 2931070 8107   WARSAW R-IX 293107002153 4020 NORTH ELEM.   Regular School No 1 03 05 2015   k_12_total 136 * * *   *       * *           *         *   29   142 136                                       29   142
3297168 3297168 MO     school 2931070 8107   WARSAW R-IX 293107002153 4020 NORTH ELEM.   Regular School No 1 03 05 2016   k_12_total 127 * * *   *       * 7           *         *   24   137 127                   7                   24   137
3297169 3297169 MO     school 2931070 8107   WARSAW R-IX 293107002153 4020 NORTH ELEM.   Regular School No Elementary 03 05 2017   k_12_total 142 * * *   *       * 10           *         *   33   154 142                   10                   33   154
3297170 3297170 MO     school 2931070 8107   WARSAW R-IX 293107002153 4020 NORTH ELEM.   Regular School No Elementary 01 05 2018   k_12_total 248 * 12 *   *       * 18           *         *   65   282 248   12               18                   65   282
3297171 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
3297172 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
3297173 3297173 MO     school 2931070 8107   WARSAW R-IX 293107002154 4040 SOUTH ELEM.   Regular School No 1 PK 05 2015   k_12_total 222 * * *   *       * 9           *         *   42   236 222                   9                   42   236

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