enrollments

Data source: Big Local News · About: Big Local

3,471 rows where grade = "grade_7" and state = "MA" sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,371 ✖
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
941627 941627 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No 3 07 12 2016   grade_7 44 2 3 0   0     0   5   28 26                       54 44 2 3 0   0     0   5   28 26                 54
1124214 1124214 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_7 16 0 1 0   1     0   1   10 9                       19 16 0 1 0   1     0   1   10 9                 19
1124927 1124927 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_7 11 0 0 0   0     0   0   6 5                       11 11 0 0 0   0     0   0   6 5                 11
1125905 1125905 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2017   grade_7 38 0 6 0   1     0   2   28 19                       47 38 0 6 0   1     0   2   28 19                 47
1125939 1125939 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No Other 06 12 2017   grade_7 62 1 2 0   2     0   1   18 50                       68 62 1 2 0   2     0   1   18 50                 68
1127568 1127568 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary KG 07 2017   grade_7 24 0 0 0   0     0   1   11 14                       25 24 0 0 0   0     0   1   11 14                 25
1127577 1127577 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary KG 07 2017   grade_7 29 1 2 0   0     0   4   16 20                       36 29 1 2 0   0     0   4   16 20                 36
1127587 1127587 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 07 2017   grade_7 24 0 2 0   0     0   2   16 12                       28 24 0 2 0   0     0   2   16 12                 28
1128160 1128160 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2017   grade_7 133 20 24 1   0     0   16   90 104                       194 133 20 24 1   0     0   16   90 104                 194
1128164 1128164 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2017   grade_7 159 20 18 0   2     0   15   99 115                       214 159 20 18 0   2     0   15   99 115                 214
1128555 1128555 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_7 20 0 1 0   0     0   0   7 14                       21 20 0 1 0   0     0   0   7 14                 21
1131142 1131142 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_7 55 7 5 0   0     0   4   35 36                       71 55 7 5 0   0     0   4   35 36                 71
1131758 1131758 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   grade_7 104 6 1 0   1     0   0   58 54                       112 104 6 1 0   1     0   0   58 54                 112
1131857 1131857 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2017   grade_7 104 1 10 1   1     0   2   42 77                       119 104 1 10 1   1     0   2   42 77                 119
1131967 1131967 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2017   grade_7 123 2 2 0   1     0   6   76 58                       134 123 2 2 0   1     0   6   76 58                 134
1132376 1132376 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2017   grade_7 84 0 0 0   1     0   5   42 48                       90 84 0 0 0   1     0   5   42 48                 90
1132713 1132713 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 07 12 2017   grade_7 42 1 1 0   0     0   2   27 19                       46 42 1 1 0   0     0   2   27 19                 46
1366689 1366689 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_7 20 0 0 0   0     0   2   12 10 *                     22.0 20 0 0 0   0     0   2   12 10                 22
1367297 1367297 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_7 13 1 0 0   0     0   0   9 5 *                     14.0 13 1 0 0   0     0   0   9 5                 14
1368077 1368077 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2020   grade_7 42 0 5 0   3     0   3   19 34 *                     53.0 42 0 5 0   3     0   3   19 34                 53
1368106 1368106 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2020   grade_7 50 0 6 0   2     0   4   34 28 *                     62.0 50 0 6 0   2     0   4   34 28                 62
1369514 1369514 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2020   grade_7 103 2 8 0   1     1   10   60 65 *                     125.0 103 2 8 0   1     1   10   60 65                 125
1369998 1369998 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2020   grade_7 118 27 17 1   0     0   13   80 96 *                     176.0 118 27 17 1   0     0   13   80 96                 176
1370001 1370001 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2020   grade_7 136 30 28 0   2     0   15   103 108 *                     211.0 136 30 28 0   2     0   15   103 108                 211
1370332 1370332 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2020   grade_7 16 1 2 0   0     0   0   9 10 *                     19.0 16 1 2 0   0     0   0   9 10                 19
1372483 1372483 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2020   grade_7 42 8 7 1   2     0   4   37 27 *                     64.0 42 8 7 1   2     0   4   37 27                 64
1373038 1373038 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2020   grade_7 84 5 2 0   1     0   2   48 46 *                     94.0 84 5 2 0   1     0   2   48 46                 94
1373122 1373122 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2020   grade_7 77 3 10 0   2     0   5   56 41 *                     97.0 77 3 10 0   2     0   5   56 41                 97
1373226 1373226 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2020   grade_7 115 1 7 0   0     0   5   74 54 *                     128.0 115 1 7 0   0     0   5   74 54                 128
1373587 1373587 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2020   grade_7 81 3 3 0   0     0   4   50 41 *                     91.0 81 3 3 0   0     0   4   50 41                 91
1373859 1373859 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 06 12 2020   grade_7 45 1 3 1   0     0   4   27 27 *                     54.0 45 1 3 1   0     0   4   27 27                 54
1673917 1673917 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_7 30 0 0 0   0     0   0   13 17 *                     30.0 30 0 0 0   0     0   0   13 17                 30
1674531 1674531 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_7 18 0 0 0   0     0   0   11 7 *                     18.0 18 0 0 0   0     0   0   11 7                 18
1675323 1675323 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee - Lee Middle/High School   Regular School No High 07 12 2021   grade_7 32 0 5 0   2     0   1   20 19 *                     40.0 32 0 5 0   2     0   1   20 19                 40
1675352 1675352 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox - Lenox Memorial High   Regular School No High 06 12 2021   grade_7 50 0 5 0   3     0   4   32 30 *                     62.0 50 0 5 0   3     0   4   32 30                 62
1676763 1676763 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 North Adams - Drury High   Regular School No High 07 12 2021   grade_7 68 8 7 0   0     1   7   45 46 *                     91.0 68 8 7 0   0     1   7   45 46                 91
1677243 1677243 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 Pittsfield - John T Reid Middle   Regular School No Middle 06 08 2021   grade_7 100 15 25 1   4     0   21   95 71 *                     166.0 100 15 25 1   4     0   21   95 71                 166
1677246 1677246 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Pittsfield - Theodore Herberg Middle   Regular School No Middle 06 08 2021   grade_7 123 12 28 1   3     0   9   92 84 *                     176.0 123 12 28 1   3     0   9   92 84                 176
1677580 1677580 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond - Richmond Consolidated   Regular School No Elementary PK 08 2021   grade_7 15 0 1 0   0     0   1   5 12 *                     17.0 15 0 1 0   0     0   1   5 12                 17
1679746 1679746 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public (District) - Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2021   grade_7 45 8 11 0   1     0   3   33 35 *                     68.0 45 8 11 0   1     0   3   33 35                 68
1680302 1680302 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Regional - Hoosac Valley Middle School   Regular School No Middle 04 07 2021   grade_7 100 3 2 0   0     0   2   55 52 *                     107.0 100 3 2 0   0     0   2   55 52                 107
1680386 1680386 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills - W.E.B. Du Bois Regional Middle School   Regular School No Middle 05 08 2021   grade_7 73 0 10 0   3     0   4   47 43 *                     90.0 73 0 10 0   3     0   4   47 43                 90
1680489 1680489 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Central Berkshire - Nessacus Regional Middle School   Regular School No Middle 06 08 2021   grade_7 110 0 3 1   0     0   1   59 56 *                     115.0 110 0 3 1   0     0   1   59 56                 115
1680850 1680850 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mount Greylock - Mt Greylock Regional High   Regular School No High 07 12 2021   grade_7 68 2 6 0   0     0   1   41 36 *                     77.0 68 2 6 0   0     0   1   41 36                 77
1681107 1681107 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Southern Berkshire - Mt Everett Regional   Regular School No High 06 12 2021   grade_7 31 0 2 0   0     0   2   22 13 *                     35.0 31 0 2 0   0     0   2   22 13                 35
2041759 2041759 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_7 15 0 0 0   0     0   2   8 9                       17.0 15 0 0 0   0     0   2   8 9                 17
2042369 2042369 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_7 9 0 0 0   0     0   0   2 7                       9.0 9 0 0 0   0     0   0   2 7                 9
2043161 2043161 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2019   grade_7 50 1 2 0   2     0   1   31 25                       56.0 50 1 2 0   2     0   1   31 25                 56
2043190 2043190 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2019   grade_7 55 0 8 0   2     0   2   37 30                       67.0 55 0 8 0   2     0   2   37 30                 67
2044587 2044587 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2019   grade_7 100 4 4 0   1     0   5   61 53                       114.0 100 4 4 0   1     0   5   61 53                 114
2045072 2045072 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2019   grade_7 114 24 20 1   2     0   18   88 91                       179.0 114 24 20 1   2     0   18   88 91                 179
2045075 2045075 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2019   grade_7 155 25 27 0   3     0   12   114 108                       222.0 155 25 27 0   3     0   12   114 108                 222
2045405 2045405 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2019   grade_7 21 0 2 0   0     0   1   13 11                       24.0 21 0 2 0   0     0   1   13 11                 24
2047556 2047556 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2019   grade_7 51 6 11 0   2     0   5   41 34                       75.0 51 6 11 0   2     0   5   41 34                 75
2048110 2048110 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2019   grade_7 87 2 0 1   0     0   1   44 47                       91.0 87 2 0 1   0     0   1   44 47                 91
2048196 2048196 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2019   grade_7 61 2 6 1   5     0   6   43 38                       81.0 61 2 6 1   5     0   6   43 38                 81
2048287 2048287 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2019   grade_7 119 0 3 0   2     0   5   66 63                       129.0 119 0 3 0   2     0   5   66 63                 129
2048649 2048649 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2019   grade_7 116 3 1 0   1     0   1   50 72                       122.0 116 3 1 0   1     0   1   50 72                 122
2048931 2048931 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 07 12 2019   grade_7 42 0 1 0   0     0   2   18 27                       45.0 42 0 1 0   0     0   2   18 27                 45
2231029 2231029 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   grade_7 16 0 0 0   0     0   0   7 9                       16.0 16 0 0 0   0     0   0   7 9                 16
2232721 2232721 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee: Lee Middle/High School   Regular School No High 07 12 2018   grade_7 49 1 4 0   0     0   5   25 34                       59.0 49 1 4 0   0     0   5   25 34                 59
2232755 2232755 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox: Lenox Memorial High   Regular School No High 06 12 2018   grade_7 62 0 4 0   4     0   0   35 35                       70.0 62 0 4 0   4     0   0   35 35                 70
2234410 2234410 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 North Adams: Drury High   Regular School No High 07 12 2018   grade_7 85 4 4 0   0     0   7   52 48                       100.0 85 4 4 0   0     0   7   52 48                 100
2234982 2234982 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 Pittsfield: John T Reid Middle   Regular School No Middle 06 08 2018   grade_7 110 20 25 0   3     1   20   97 82                       179.0 110 20 25 0   3     1   20   97 82                 179
2234986 2234986 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Pittsfield: Theodore Herberg Middle   Regular School No Middle 06 08 2018   grade_7 128 22 28 0   3     0   21   100 102                       202.0 128 22 28 0   3     0   21   100 102                 202
2235376 2235376 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond: Richmond Consolidated   Regular School No Elementary PK 08 2018   grade_7 13 0 0 0   0     0   0   8 5                       13.0 13 0 0 0   0     0   0   8 5                 13
2237969 2237969 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public (District): Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2018   grade_7 47 8 8 1   4     0   5   33 40                       73.0 47 8 8 1   4     0   5   33 40                 73
2238588 2238588 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Adams-Cheshire: Hoosac Valley Middle School   Regular School No Middle 04 07 2018   grade_7 86 4 1 0   0     0   1   46 46                       92.0 86 4 1 0   0     0   1   46 46                 92
2238688 2238688 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills: Monument Valley Regional Middle School   Regular School No Middle 05 08 2018   grade_7 83 1 10 0   4     0   3   51 50                       101.0 83 1 10 0   4     0   3   51 50                 101
2238796 2238796 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Central Berkshire: Nessacus Regional Middle School   Regular School No Middle 06 08 2018   grade_7 107 1 3 0   0     0   4   54 61                       115.0 107 1 3 0   0     0   4   54 61                 115
2239207 2239207 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mount Greylock: Mt Greylock Regional High   Regular School No High 07 12 2018   grade_7 86 1 2 0   4     0   1   47 47                       94.0 86 1 2 0   4     0   1   47 47                 94
2239535 2239535 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Southern Berkshire: Mt Everett Regional   Regular School No High 07 12 2018   grade_7 53 2 3 1   0     0   3   27 35                       62.0 53 2 3 1   0     0   3   27 35                 62
735681 735681 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_7 108 1 1 0   1     0   0   55 56                       111 108 1 1 0   1     0   0   55 56                 111
735898 735898 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2015   grade_7 134 9 11 0   8     0   4   94 72                       166 134 9 11 0   8     0   4   94 72                 166
735902 735902 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2015   grade_7 109 2 25 2   6     1   6   72 79                       151 109 2 25 2   6     1   6   72 79                 151
735906 735906 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2015   grade_7 90 6 24 0   3     0   8   64 67                       131 90 6 24 0   3     0   8   64 67                 131
736072 736072 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No 2 05 08 2015   grade_7 87 2 3 0   0     0   1   45 48                       93 87 2 3 0   0     0   1   45 48                 93
737729 737729 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No 2 06 08 2015   grade_7 297 3 8 1   12     0   7   187 141                       328 297 3 8 1   12     0   7   187 141                 328
737925 737925 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2015   grade_7 240 11 12 1   5     0   6   142 133                       275 240 11 12 1   5     0   6   142 133                 275
738026 738026 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No 2 06 08 2015   grade_7 138 1 6 0   3     0   1   78 71                       149 138 1 6 0   3     0   1   78 71                 149
738074 738074 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2015   grade_7 28 4 9 0   0     0   3   22 22                       44 28 4 9 0   0     0   3   22 22                 44
738106 738106 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No 2 06 08 2015   grade_7 125 16 53 2   16     0   13   116 109                       225 125 16 53 2   16     0   13   116 109                 225
738109 738109 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2015   grade_7 150 17 44 1   7     0   10   117 112                       229 150 17 44 1   7     0   10   117 112                 229
738112 738112 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No 2 06 08 2015   grade_7 165 12 57 0   12     1   11   124 134                       258 165 12 57 0   12     1   11   124 134                 258
738119 738119 MA Bristol   school 2504830 95   Fall River 250483002696 950326 Stone Therapeutic Day Middle School   Regular School No 2 06 08 2015   grade_7 4 1 3 0   0     0   2   9 *                       10 4 1 3 0   0     0   2   9                   10
738121 738121 MA Bristol   school 2504830 95   Fall River 250483002838 950335 Resiliency Middle School   Regular School No 2 07 08 2015   grade_7 11 4 4 0   1     0   1   16 5                       21 11 4 4 0   1     0   1   16 5                 21
739618 739618 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2015   grade_7 305 8 12 0   16     0   10   188 163                       351 305 8 12 0   16     0   10   188 163                 351
740267 740267 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2015   grade_7 117 56 95 3   2     2   17   158 134                       292 117 56 95 3   2     2   17   158 134                 292
740270 740270 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2015   grade_7 212 29 97 1   1     2   16   183 175                       358 212 29 97 1   1     2   16   183 175                 358
740273 740273 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2015   grade_7 123 31 93 1   2     2   10   136 126                       262 123 31 93 1   2     2   10   136 126                 262
740286 740286 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_7 * * * *   *     *   *   3 2                       5                         3 2                 5
740565 740565 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2015   grade_7 342 7 11 1   24     1   10   193 203                       396 342 7 11 1   24     1   10   193 203                 396
740667 740667 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No 2 06 08 2015   grade_7 193 2 4 0   3     1   2   100 105                       205 193 2 4 0   3     1   2   100 105                 205
741507 741507 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No 2 06 08 2015   grade_7 161 3 6 0   5     0   2   81 96                       177 161 3 6 0   5     0   2   81 96                 177
741605 741605 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No 2 06 08 2015   grade_7 200 2 5 0   8     0   2   118 99                       217 200 2 5 0   8     0   2   118 99                 217
742197 742197 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No 2 06 08 2015   grade_7 160 1 6 1   2     0   2   85 87                       172 160 1 6 1   2     0   2   85 87                 172
742236 742236 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No 2 05 07 2015   grade_7 180 24 14 0   2     0   7   122 105                       227 180 24 14 0   2     0   7   122 105                 227
742244 742244 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No 2 05 07 2015   grade_7 83 24 25 0   0     2   4   67 71                       138 83 24 25 0   0     2   4   67 71                 138
742247 742247 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No 2 05 07 2015   grade_7 200 24 32 0   4     0   8   136 132                       268 200 24 32 0   4     0   8   136 132                 268
742793 742793 MA Bristol   school 2512780 331   Westport 251278002094 3310305 Westport Middle   Regular School No 2 06 08 2015   grade_7 119 0 4 2   1     0   4   70 60                       130 119 0 4 2   1     0   4   70 60                 130

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