enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by native_american_int descending

✎ 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
936794 936794 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No 1 03 04 2016   grade_3 193 7 93 14   5     0   14   176 150                       326 193 7 93 14   5     0   14   176 150                 326
2233826 2233826 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford: Woodland   Regular School No Elementary 03 05 2018   grade_5 184 7 102 14   5     0   14   169 157                       326.0 184 7 102 14   5     0   14   169 157                 326
2044092 2044092 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2019   grade_6 193 9 107 14   5     0   13   185 156                       341.0 193 9 107 14   5     0   13   185 156                 341
936573 936573 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_5 103 5 3 13   6     0   5   58 77                       135 103 5 3 13   6     0   5   58 77                 135
1126742 1126742 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   grade_6 106 5 2 13   5     0   6   60 77                       137 106 5 2 13   5     0   6   60 77                 137
1127008 1127008 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2017   grade_4 192 8 100 13   4     0   14   175 156                       331 192 8 100 13   4     0   14   175 156                 331
2233557 2233557 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee: Mashpee Middle School   Regular School No Middle 07 08 2018   grade_7 104 10 2 13   4     0   7   58 82                       140.0 104 10 2 13   4     0   7   58 82                 140
2043867 2043867 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2019   grade_8 105 10 2 13   4     0   6   59 81                       140.0 105 10 2 13   4     0   6   59 81                 140
1369022 1369022 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2020   grade_7 201 8 110 13   5     0   14   187 164 *                     351.0 201 8 110 13   5     0   14   187 164                 351
1676271 1676271 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford - Stacy Middle   Regular School No Middle 06 08 2021   grade_8 202 6 113 13   5     0   16   185 170 *                     355.0 202 6 113 13   5     0   16   185 170                 355
739728 739728 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_4 107 4 3 12   6     0   4   58 78                       136 107 4 3 12   6     0   4   58 78                 136
2042305 2042305 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2019   grade_5 225 8 14 12   5     0   22   153 133                       286.0 225 8 14 12   5     0   22   153 133                 286
1367236 1367236 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Morse Pond School   Regular School No Middle 05 06 2020   grade_6 217 9 15 11   4     0   24   148 132 *                     280.0 217 9 15 11   4     0   24   148 132                 280
739726 739726 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2015   grade_8 111 6 5 10   3     0   6   76 65                       141 111 6 5 10   3     0   6   76 65                 141
739948 739948 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No 1 KG 05 2015   grade_2 106 3 44 10   5     0   4   92 80                       172 106 3 44 10   5     0   4   92 80                 172
936575 936575 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2016   grade_9 86 4 4 10   2     0   8   66 48                       114 86 4 4 10   2     0   8   66 48                 114
941025 941025 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No 2 06 07 2016   grade_7 155 20 20 10   4     1   14   125 99                       224 155 20 20 10   4     1   14   125 99                 224
1126745 1126745 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2017   grade_10 79 4 3 10   2     0   7   60 45                       105 79 4 3 10   2     0   7   60 45                 105
2233567 2233567 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee: Mashpee High   Regular School No High 09 12 2018   grade_11 84 5 4 10   0     0   8   59 52                       111.0 84 5 4 10   0     0   8   59 52                 111
1368801 1368801 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2020   grade_9 89 8 2 10   4     0   6   56 63 *                     119.0 89 8 2 10   4     0   6   56 63                 119
1676052 1676052 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee - Mashpee High   Regular School No High 09 12 2021   grade_10 92 9 2 10   3     0   6   59 63 *                     122.0 92 9 2 10   3     0   6   59 63                 122
739721 739721 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   kindergarten 74 2 11 9   1     0   9   52 54                       106 74 2 11 9   1     0   9   52 54                 106
744198 744198 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No 2 06 07 2015   grade_6 163 17 19 9   4     0   14   123 103                       226 163 17 19 9   4     0   14   123 103                 226
936567 936567 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2016   grade_1 72 1 8 9   1     0   9   47 53                       100 72 1 8 9   1     0   9   47 53                 100
937113 937113 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_9 209 68 261 9   4     1   25   339 238                       577 209 68 261 9   4     1   25   339 238                 577
1126734 1126734 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   grade_2 67 1 7 9   1     0   10   44 51                       95 67 1 7 9   1     0   10   44 51                 95
1126737 1126737 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2017   grade_8 120 7 6 9   3     0   3   68 80                       148 120 7 6 9   3     0   3   68 80                 148
2233552 2233552 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee: Kenneth Coombs School   Regular School No Elementary PK 02 2018   kindergarten 86 3 6 9   3     0   15   73 49                       122.0 86 3 6 9   3     0   15   73 49                 122
2233560 2233560 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_3 84 2 8 9   1     0   12   54 62                       116.0 84 2 8 9   1     0   12   54 62                 116
2233562 2233562 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_5 105 3 3 9   4     0   11   65 70                       135.0 105 3 3 9   4     0   11   65 70                 135
2043870 2043870 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_5 100 6 4 9   2     0   7   64 64                       128.0 100 6 4 9   2     0   7   64 64                 128
2043871 2043871 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_6 106 4 5 9   4     0   12   68 72                       140.0 106 4 5 9   4     0   12   68 72                 140
2043873 2043873 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2019   grade_10 92 5 7 9   5     0   2   56 64                       120.0 92 5 7 9   5     0   2   56 64                 120
2044090 2044090 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2019   grade_4 199 13 93 9   3     1   18   179 157                       336.0 199 13 93 9   3     1   18   179 157                 336
1368797 1368797 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_3 64 7 6 9   1     0   13   45 55 *                     100.0 64 7 6 9   1     0   13   45 55                 100
1370317 1370317 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2020   grade_11 162 16 322 9   30     0   10   285 264 *                     549.0 162 16 322 9   30     0   10   285 264                 549
1674471 1674471 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth - Lawrence   Regular School No Middle 07 08 2021   grade_7 197 9 15 9   3     0   20   131 122 *                     253.0 197 9 15 9   3     0   20   131 122                 253
1676048 1676048 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee - Quashnet School   Regular School No Elementary 03 06 2021   grade_4 62 7 7 9   1     0   11   44 53 *                     97.0 62 7 7 9   1     0   11   44 53                 97
1677566 1677566 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere - Revere High   Regular School No High 09 12 2021   grade_12 148 17 258 9   31     0   9   239 233 *                     472.0 148 17 258 9   31     0   9   239 233                 472
1679385 1679385 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Worcester - Head Start   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 155 106 22 9   14     0   13   157 162 *                     319.0 155 106 22 9   14     0   13   157 162                 319
739723 739723 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   grade_1 98 3 5 8   1     0   7   62 60                       122 98 3 5 8   1     0   7   62 60                 122
739724 739724 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   grade_2 97 3 3 8   3     0   9   59 64                       123 97 3 3 8   3     0   9   59 64                 123
739730 739730 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_6 125 5 5 8   4     0   2   67 82                       149 125 5 5 8   4     0   2   67 82                 149
740275 740275 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_9 213 54 248 8   3     4   27   322 235                       557 213 54 248 8   3     4   27   322 235                 557
936565 936565 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2016   kindergarten 86 5 10 8   2     0   9   61 59                       120 86 5 10 8   2     0   9   61 59                 120
936568 936568 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2016   grade_2 101 5 4 8   1     0   6   62 63                       125 101 5 4 8   1     0   6   62 63                 125
936569 936569 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2016   grade_7 123 7 6 8   3     0   2   69 80                       149 123 7 6 8   3     0   2   69 80                 149
936571 936571 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_3 109 2 3 8   3     0   10   69 66                       135 109 2 3 8   3     0   10   69 66                 135
936574 936574 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_6 109 5 4 8   2     0   3   72 59                       131 109 5 4 8   2     0   3   72 59                 131
936795 936795 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No 1 03 04 2016   grade_4 210 6 84 8   9     0   11   176 152                       328 210 6 84 8   9     0   11   176 152                 328
1126733 1126733 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   grade_1 80 6 10 8   3     0   9   60 56                       116 80 6 10 8   3     0   9   60 56                 116
1126739 1126739 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   grade_3 97 5 4 8   2     0   5   59 62                       121 97 5 4 8   2     0   5   59 62                 121
1126740 1126740 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   grade_4 106 3 2 8   3     0   12   65 69                       134 106 3 2 8   3     0   12   65 69                 134
1127007 1127007 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2017   grade_3 193 11 87 8   7     0   13   161 158                       319 193 11 87 8   7     0   13   161 158                 319
1127009 1127009 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2017   grade_5 217 6 82 8   10     0   10   182 151                       333 217 6 82 8   10     0   10   182 151                 333
1132003 1132003 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_8 154 20 21 8   4     1   13   125 96                       221 154 20 21 8   4     1   13   125 96                 221
2233554 2233554 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee: Kenneth Coombs School   Regular School No Elementary PK 02 2018   grade_1 68 5 6 8   2     1   11   47 54                       101.0 68 5 6 8   2     1   11   47 54                 101
2233555 2233555 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee: Kenneth Coombs School   Regular School No Elementary PK 02 2018   grade_2 84 6 9 8   1     0   11   60 59                       119.0 84 6 9 8   1     0   11   60 59                 119
2233561 2233561 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_4 103 6 3 8   2     0   10   65 67                       132.0 103 6 3 8   2     0   10   65 67                 132
2233565 2233565 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee: Mashpee High   Regular School No High 09 12 2018   grade_9 99 7 7 8   5     0   3   64 65                       129.0 99 7 7 8   5     0   3   64 65                 129
2233825 2233825 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford: Woodland   Regular School No Elementary 03 05 2018   grade_4 185 9 93 8   9     0   11   164 151                       315.0 185 9 93 8   9     0   11   164 151                 315
2233828 2233828 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford: Stacy Middle   Regular School No Middle 06 08 2018   grade_6 212 7 80 8   9     0   10   180 146                       326.0 212 7 80 8   9     0   10   180 146                 326
2233833 2233833 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford: Milford High   Regular School No High 09 12 2018   grade_10 201 6 63 8   5     0   8   139 152                       291.0 201 6 63 8   5     0   8   139 152                 291
2235358 2235358 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere: Revere High   Regular School No High 09 12 2018   grade_9 184 19 363 8   30     0   10   320 294                       614.0 184 19 363 8   30     0   10   320 294                 614
2043868 2043868 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_3 86 5 8 8   1     0   11   58 61                       119.0 86 5 8 8   1     0   11   58 61                 119
2043869 2043869 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_4 86 2 8 8   1     0   11   53 63                       116.0 86 2 8 8   1     0   11   53 63                 116
2043875 2043875 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2019   grade_12 82 6 4 8   2     0   9   62 49                       111.0 82 6 4 8   2     0   9   62 49                 111
2044091 2044091 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2019   grade_5 190 11 95 8   11     0   14   178 151                       329.0 190 11 95 8   11     0   14   178 151                 329
2045389 2045389 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2019   grade_10 170 18 321 8   29     0   8   279 275                       554.0 170 18 321 8   29     0   8   279 275                 554
2048312 2048312 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2019   grade_4 170 19 20 8   2     0   28   123 124                       247.0 170 19 20 8   2     0   28   123 124                 247
1368795 1368795 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2020   grade_7 107 6 5 8   5     0   16   71 76 *                     147.0 107 6 5 8   5     0   16   71 76                 147
1368798 1368798 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_4 84 6 10 8   2     0   10   60 60 *                     120.0 84 6 10 8   2     0   10   60 60                 120
1368799 1368799 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_5 86 2 8 8   2     0   11   56 61 *                     117.0 86 2 8 8   2     0   11   56 61                 117
1368800 1368800 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_6 97 6 4 8   2     0   6   63 60 *                     123.0 97 6 4 8   2     0   6   63 60                 123
1369020 1369020 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2020   grade_5 199 11 93 8   4     1   17   180 153 *                     333.0 199 11 93 8   4     1   17   180 153                 333
1369021 1369021 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Stacy Middle   Regular School No Middle 06 08 2020   grade_6 197 12 100 8   8     0   12   181 156 *                     337.0 197 12 100 8   8     0   12   181 156                 337
1373251 1373251 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2020   grade_5 164 17 21 8   2     0   28   123 117 *                     240.0 164 17 21 8   2     0   28   123 117                 240
1676045 1676045 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee - Mashpee Middle School   Regular School No Middle 07 08 2021   grade_7 89 5 5 8   2     0   6   58 57 *                     115.0 89 5 5 8   2     0   6   58 57                 115
1676046 1676046 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee - Mashpee Middle School   Regular School No Middle 07 08 2021   grade_8 101 6 5 8   5     0   16   69 72 *                     141.0 101 6 5 8   5     0   16   69 72                 141
1676049 1676049 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee - Quashnet School   Regular School No Elementary 03 06 2021   grade_5 82 7 10 8   1     0   11   57 62 *                     119.0 82 7 10 8   1     0   11   57 62                 119
1680514 1680514 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth - Nathaniel H. Wixon School   Regular School No Elementary 04 05 2021   grade_4 148 25 20 8   5     2   20   130 98 *                     228.0 148 25 20 8   5     2   20   130 98                 228
739729 739729 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_5 109 5 4 7   3     1   2   74 57                       131 109 5 4 7   3     1   2   74 57                 131
739733 739733 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2015   grade_11 76 2 7 7   2     1   4   41 58                       99 76 2 7 7   2     1   4   41 58                 99
739950 739950 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No 1 03 04 2015   grade_3 209 7 88 7   8     0   13   179 153                       332 209 7 88 7   8     0   13   179 153                 332
739955 739955 MA Worcester   school 2507860 185   Milford 250786002439 1850310 Milford Middle East   Regular School No 4 08 08 2015   grade_8 228 9 57 7   13     0   4   170 148                       318 228 9 57 7   13     0   4   170 148                 318
936789 936789 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No 1 KG 02 2016   grade_2 89 6 42 7   2     0   4   89 61                       150 89 6 42 7   2     0   4   89 61                 150
936800 936800 MA Worcester   school 2507860 185   Milford 250786002439 1850310 Milford Middle East   Regular School No 4 08 08 2016   grade_8 223 9 55 7   7     0   10   152 159                       311 223 9 55 7   7     0   10   152 159                 311
1124841 1124841 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2017   grade_3 33 4 1 7   1     0   5   33 18                       51 33 4 1 7   1     0   5   33 18                 51
1126736 1126736 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2017   grade_7 105 4 4 7   3     1   5   71 58                       129 105 4 4 7   3     1   5   71 58                 129
2231669 2231669 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth: Teaticket   Regular School No Elementary PK 04 2018   grade_4 32 3 2 7   0     0   4   27 21                       48.0 32 3 2 7   0     0   4   27 21                 48
2233563 2233563 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_6 82 3 3 7   1     0   6   59 43                       102.0 82 3 3 7   1     0   6   59 43                 102
2233824 2233824 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Milford: Woodland   Regular School No Elementary 03 05 2018   grade_3 198 13 82 7   5     1   18   178 146                       324.0 198 13 82 7   5     1   18   178 146                 324
2233834 2233834 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford: Milford High   Regular School No High 09 12 2018   grade_11 176 7 76 7   9     0   4   142 137                       279.0 176 7 76 7   9     0   4   142 137                 279
2238827 2238827 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth: N H Wixon Innovation School   Regular School No Elementary 04 05 2018   grade_4 170 29 43 7   3     0   18   136 134                       270.0 170 29 43 7   3     0   18   136 134                 270
2043865 2043865 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   grade_2 69 7 3 7   3     1   13   48 55                       103.0 69 7 3 7   3     1   13   48 55                 103
2044096 2044096 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2019   grade_10 185 13 93 7   5     0   11   163 151                       314.0 185 13 93 7   5     0   11   163 151                 314
2044097 2044097 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2019   grade_11 205 4 64 7   5     0   11   138 158                       296.0 205 4 64 7   5     0   11   138 158                 296
2048313 2048313 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2019   grade_5 162 28 47 7   4     0   17   136 129                       265.0 162 28 47 7   4     0   17   136 129                 265
1368803 1368803 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2020   grade_11 89 5 6 7   4     0   2   51 62 *                     113.0 89 5 6 7   4     0   2   51 62                 113
1369026 1369026 MA Worcester   school 2507860 185   Milford 250786001239 1850505 Milford High   Regular School No High 09 12 2020   grade_11 179 14 88 7   4     0   12   152 152 *                     304.0 179 14 88 7   4     0   12   152 152                 304

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