enrollments

Data source: Big Local News · About: Big Local

3,371,677 rows sorted by pacific_islander_int

✎ View and edit SQL

This data as json, CSV (advanced)

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
3296779 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
3296780 3296780 MO     school 2927570 2097   SAVANNAH R-III 292757001690 4020 JOHN GLENN ELEM.   Regular School No Elementary KG 05 2020   k_12_total 251 5 9 *   *       * 5           *         96   37   270 251 5 9               5                 96 37   270
3296781 3296781 MO     school 2927570 2097   SAVANNAH R-III 292757001692 4040 MINNIE CLINE ELEM.   Regular School No 1 KG 05 2015   k_12_total 532 9 18 *   *       * *           *         264   89   566 532 9 18                                 264 89   566
3296782 3296782 MO     school 2927570 2097   SAVANNAH R-III 292757001692 4040 MINNIE CLINE ELEM.   Regular School No 1 KG 05 2016   k_12_total 503 6 14 *   *       * 5           *         245   84   532 503 6 14               5                 245 84   532
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
3296784 3296784 MO     school 2927570 2097   SAVANNAH R-III 292757001692 4040 MINNIE CLINE ELEM.   Regular School No Elementary KG 05 2018   k_12_total 547 7 6 *   *       * 9           *         213   90   574 547 7 6               9                 213 90   574
3296785 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
3296786 3296786 MO     school 2927570 2097   SAVANNAH R-III 292757001692 4040 MINNIE CLINE ELEM.   Regular School No Elementary KG 05 2020   k_12_total 584 7 6 *   *       * 13           *         231   84   614 584 7 6               13                 231 84   614
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
3296793 3296793 MO     school 2929940 3031   TARKIO R-I 292994002067 1050 TARKIO HIGH   Regular School No 3 07 12 2015   k_12_total 121 * * *   *       * *           *         43   17   125 121                                     43 17   125
3296794 3296794 MO     school 2929940 3031   TARKIO R-I 292994002067 1050 TARKIO HIGH   Regular School No 3 07 12 2016   k_12_total 120 * * *   *       * *           *         48   17   123 120                                     48 17   123
3296795 3296795 MO     school 2929940 3031   TARKIO R-I 292994002067 1050 TARKIO HIGH   Regular School No High 07 12 2017   k_12_total 118 * * *   *       * *           *         50   24   122 118                                     50 24   122
3296796 3296796 MO     school 2929940 3031   TARKIO R-I 292994002067 1050 TARKIO HIGH   Regular School No High 07 12 2018   k_12_total 138 * * *   *       * *           *         66   28   141 138                                     66 28   141
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
3296798 3296798 MO     school 2929940 3031   TARKIO R-I 292994002067 1050 TARKIO HIGH   Regular School No High 06 12 2020   k_12_total 158 5 6 *   *       * *           *         63   31   170 158 5 6                                 63 31   170
3296799 3296799 MO     school 2929940 3031   TARKIO R-I 292994002066 4020 TARKIO ELEM.   Regular School No 1 PK 06 2015   k_12_total 142 * 7 *   *       * *           *         90   30   151 142   7                                 90 30   151
3296800 3296800 MO     school 2929940 3031   TARKIO R-I 292994002066 4020 TARKIO ELEM.   Regular School No 1 PK 06 2016   k_12_total 162 * 7 *   *       * *           *         83   26   173 162   7                                 83 26   173
3296801 3296801 MO     school 2929940 3031   TARKIO R-I 292994002066 4020 TARKIO ELEM.   Regular School No Elementary PK 06 2017   k_12_total 157 * 7 *   *       * *           *         86   20   168 157   7                                 86 20   168
3296802 3296802 MO     school 2929940 3031   TARKIO R-I 292994002066 4020 TARKIO ELEM.   Regular School No Elementary PK 06 2018   k_12_total 166 * 7 *   *       * *           *         91   29   178 166   7                                 91 29   178
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
3296804 3296804 MO     school 2929940 3031   TARKIO R-I 292994002066 4020 TARKIO ELEM.   Regular School No Elementary PK 05 2020   k_12_total 140 * 6 *   *       * *           *         82   24   151 140   6                                 82 24   151
3296805 3296805 MO     school 2926790 3032   ROCK PORT R-II 292679001613 1050 ROCK PORT HIGH   Regular School No 3 07 12 2015   k_12_total 152 * * *   *       * *           *         44   16   153 152                                     44 16   153
3296806 3296806 MO     school 2926790 3032   ROCK PORT R-II 292679001613 1050 ROCK PORT HIGH   Regular School No 3 07 12 2016   k_12_total 161 * * *   *       * *           *         44   14   162 161                                     44 14   162
3296807 3296807 MO     school 2926790 3032   ROCK PORT R-II 292679001613 1050 ROCK PORT HIGH   Regular School No High 07 12 2017   k_12_total 158 * * *   *       * *           *         38   14   159 158                                     38 14   159
3296808 3296808 MO     school 2926790 3032   ROCK PORT R-II 292679001613 1050 ROCK PORT HIGH   Regular School No High 07 12 2018   k_12_total 156 * * *   *       * *           *         39   15   157 156                                     39 15   157
3296809 3296809 MO     school 2926790 3032   ROCK PORT R-II 292679001613 1050 ROCK PORT HIGH   Regular School No High 07 12 2019   k_12_total 153 * * *   *       * *           *         45   15   154 153                                     45 15   154
3296810 3296810 MO     school 2926790 3032   ROCK PORT R-II 292679001613 1050 ROCK PORT HIGH   Regular School No High 07 12 2020   k_12_total 152 * * *   *       * *           *         49   13   154 152                                     49 13   154
3296811 3296811 MO     school 2926790 3032   ROCK PORT R-II 292679001612 4020 ROCK PORT ELEM.   Regular School No 1 PK 06 2015   k_12_total 164 * * *   *       * *           *         66   21   165 164                                     66 21   165
3296812 3296812 MO     school 2926790 3032   ROCK PORT R-II 292679001612 4020 ROCK PORT ELEM.   Regular School No 1 PK 06 2016   k_12_total 164 * * *   *       * *           *         61   15   165 164                                     61 15   165
3296813 3296813 MO     school 2926790 3032   ROCK PORT R-II 292679001612 4020 ROCK PORT ELEM.   Regular School No Elementary PK 06 2017   k_12_total 178 * * *   *       * *           *         78   16   182 178                                     78 16   182
3296814 3296814 MO     school 2926790 3032   ROCK PORT R-II 292679001612 4020 ROCK PORT ELEM.   Regular School No Elementary PK 06 2018   k_12_total 175 * * *   *       * *           *         70   19   181 175                                     70 19   181
3296815 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
3296816 3296816 MO     school 2926790 3032   ROCK PORT R-II 292679001612 4020 ROCK PORT ELEM.   Regular School No Elementary PK 06 2020   k_12_total 169 6 * *   *       * *           *         68   21   181 169 6                                   68 21   181
3296817 3296817 MO     school 2911760 3033   FAIRFAX R-III 291176000433 1050 FAIRFAX HIGH   Regular School No 3 07 12 2015   k_12_total 64 * * *   *       * *           *         31   9   65 64                                     31 9   65
3296818 3296818 MO     school 2911760 3033   FAIRFAX R-III 291176000433 1050 FAIRFAX HIGH   Regular School No 3 07 12 2016   k_12_total 66 * * *   *       * *           *         32   *   68 66                                     32     68
3296819 3296819 MO     school 2911760 3033   FAIRFAX R-III 291176000433 1050 FAIRFAX HIGH   Regular School No High 07 12 2017   k_12_total 71 * * *   *       * *           *         37   *   74 71                                     37     74
3296820 3296820 MO     school 2911760 3033   FAIRFAX R-III 291176000433 1050 FAIRFAX HIGH   Regular School No High 07 12 2018   k_12_total 67 * * *   *       * *           *         32   6   69 67                                     32 6   69
3296821 3296821 MO     school 2911760 3033   FAIRFAX R-III 291176000433 1050 FAIRFAX HIGH   Regular School No High 07 12 2019   k_12_total 62 * * *   *       * *           *         35   7   67 62                                     35 7   67
3296822 3296822 MO     school 2911760 3033   FAIRFAX R-III 291176000433 1050 FAIRFAX HIGH   Regular School No High 07 12 2020   k_12_total 70 * * *   *       * *           *         34   8   76 70                                     34 8   76
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
3296829 3296829 MO     school 2910020 4106   COMMUNITY R-VI 291002000319 1050 COMMUNITY HIGH   Regular School No 4 06 12 2015   k_12_total 150 * * *   *       * *           *         59   17   152 150                                     59 17   152
3296830 3296830 MO     school 2910020 4106   COMMUNITY R-VI 291002000319 1050 COMMUNITY HIGH   Regular School No 4 06 12 2016   k_12_total 154 * * *   *       * *           *         64   17   157 154                                     64 17   157
3296831 3296831 MO     school 2910020 4106   COMMUNITY R-VI 291002000319 1050 COMMUNITY HIGH   Regular School No Other 06 12 2017   k_12_total 166 * * *   *       * *           *         64   16   169 166                                     64 16   169
3296832 3296832 MO     school 2910020 4106   COMMUNITY R-VI 291002000319 1050 COMMUNITY HIGH   Regular School No High 06 12 2018   k_12_total 169 * * *   *       * *           *         71   15   172 169                                     71 15   172
3296833 3296833 MO     school 2910020 4106   COMMUNITY R-VI 291002000319 1050 COMMUNITY HIGH   Regular School No High 06 12 2019   k_12_total 165 * * *   *       * *           *         82   22   169 165                                     82 22   169
3296834 3296834 MO     school 2910020 4106   COMMUNITY R-VI 291002000319 1050 COMMUNITY HIGH   Regular School No High 06 12 2020   k_12_total 162 * * *   *       * *           *         77   20   164 162                                     77 20   164
3296835 3296835 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No 1 PK 05 2015   k_12_total 111 * * *   *       * *           *         75   16   116 111                                     75 16   116
3296836 3296836 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No 1 PK 05 2016   k_12_total 105 * * *   *       * *           *         69   21   110 105                                     69 21   110
3296837 3296837 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No Elementary PK 05 2017   k_12_total 115 * * *   *       * 6           *         75   25   122 115                   6                 75 25   122
3296838 3296838 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No Elementary PK 05 2018   k_12_total 114 * * *   *       * 6           *         83   33   123 114                   6                 83 33   123
3296839 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
3296840 3296840 MO     school 2910020 4106   COMMUNITY R-VI 291002000318 4020 COMMUNITY ELEM.   Regular School No Elementary PK 05 2020   k_12_total 127 * * *   *       * *           *         83   32   131 127                                     83 32   131
3296841 3296841 MO     school 2930780 4109   VAN-FAR R-I 293078002124 1050 VAN-FAR JR./SR. HIGH   Regular School No 3 07 12 2015   k_12_total 217 7 7 *   *       * 8           *         89   33   239 217 7 7               8                 89 33   239
3296842 3296842 MO     school 2930780 4109   VAN-FAR R-I 293078002124 1050 VAN-FAR JR./SR. HIGH   Regular School No 3 07 12 2016   k_12_total 227 5 9 *   *       * 13           *         97   31   256 227 5 9               13                 97 31   256
3296843 3296843 MO     school 2930780 4109   VAN-FAR R-I 293078002124 1050 VAN-FAR JR./SR. HIGH   Regular School No High 07 12 2017   k_12_total 234 5 7 *   *       * 21           *         112   33   269 234 5 7               21                 112 33   269
3296844 3296844 MO     school 2930780 4109   VAN-FAR R-I 293078002124 1050 VAN-FAR JR./SR. HIGH   Regular School No High 07 12 2018   k_12_total 231 * 11 *   *       * 17           *         112   27   262 231   11               17                 112 27   262
3296845 3296845 MO     school 2930780 4109   VAN-FAR R-I 293078002124 1050 VAN-FAR JR./SR. HIGH   Regular School No High 07 12 2019   k_12_total 244 5 11 *   *       * 19           *         125   30   279 244 5 11               19                 125 30   279
3296846 3296846 MO     school 2930780 4109   VAN-FAR R-I 293078002124 1050 VAN-FAR JR./SR. HIGH   Regular School No High 07 12 2020   k_12_total 243 6 9 *   *       * 18           *         118   30   276 243 6 9               18                 118 30   276
3296847 3296847 MO     school 2930780 4109   VAN-FAR R-I 293078002125 4020 VAN-FAR ELEM.   Regular School No 1 PK 06 2015   k_12_total 305 8 8 *   *       * 29           *         186   49   350 305 8 8               29                 186 49   350
3296848 3296848 MO     school 2930780 4109   VAN-FAR R-I 293078002125 4020 VAN-FAR ELEM.   Regular School No 1 PK 06 2016   k_12_total 297 8 9 *   *       * 26           *         187   43   340 297 8 9               26                 187 43   340
3296849 3296849 MO     school 2930780 4109   VAN-FAR R-I 293078002125 4020 VAN-FAR ELEM.   Regular School No Elementary PK 06 2017   k_12_total 254 9 6 *   *       * 23           *         164   34   292 254 9 6               23                 164 34   292
3296850 3296850 MO     school 2930780 4109   VAN-FAR R-I 293078002125 4020 VAN-FAR ELEM.   Regular School No Elementary PK 06 2018   k_12_total 253 10 13 *   *       * 25           *         171   42   301 253 10 13               25                 171 42   301
3296851 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
3296852 3296852 MO     school 2930780 4109   VAN-FAR R-I 293078002125 4020 VAN-FAR ELEM.   Regular School No Elementary PK 06 2020   k_12_total 248 11 15 *   *       * 25           5         162   36   299 248 11 15               25           5     162 36   299
3296853 3296853 MO     school 2920810 4110   MEXICO 59 292081001137 1050 MEXICO HIGH   Regular School No 3 09 12 2015   k_12_total 561 55 26 *   *       * 29           9         262   65   675 561 55 26               29           9     262 65   675
3296854 3296854 MO     school 2920810 4110   MEXICO 59 292081001137 1050 MEXICO HIGH   Regular School No 3 09 12 2016   k_12_total 557 50 32 *   *       * 32           10         273   61   675 557 50 32               32           10     273 61   675
3296855 3296855 MO     school 2920810 4110   MEXICO 59 292081001137 1050 MEXICO HIGH   Regular School No High 09 12 2017   k_12_total 548 49 36 *   *       * 41           15         290   71   680 548 49 36               41           15     290 71   680
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
3296857 3296857 MO     school 2920810 4110   MEXICO 59 292081001137 1050 MEXICO HIGH   Regular School No High 09 12 2019   k_12_total 572 49 59 *   *       * 59           5         271   68   745 572 49 59               59           5     271 68   745
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
3296859 3296859 MO     school 2920810 4110   MEXICO 59 292081001136 2050 MEXICO MIDDLE   Regular School No 2 06 08 2015   k_12_total 405 34 42 *   *       * 35           18         282   56   521 405 34 42               35           18     282 56   521
3296860 3296860 MO     school 2920810 4110   MEXICO 59 292081001136 2050 MEXICO MIDDLE   Regular School No 2 06 08 2016   k_12_total 387 30 39 *   *       * 48           15         292   49   506 387 30 39               48           15     292 49   506
3296861 3296861 MO     school 2920810 4110   MEXICO 59 292081001136 2050 MEXICO MIDDLE   Regular School No Middle 06 08 2017   k_12_total 388 34 42 *   *       * 41           18         288   46   506 388 34 42               41           18     288 46   506
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

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