enrollments

Data source: Big Local News · About: Big Local

3,459 rows where grade = "grade_8" and state = "MA" sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,459 ✖
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
2230211 2230211 MA Suffolk   school   35   Boston   350652               2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
737985 737985 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 01 12 2015   grade_8 2 1 3 0   0     0   1   6 1                       7 2 1 3 0   0     0   1   6 1                 7
739016 739016 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_8 1 0 18 0   0     0   0   17 2                       19 1 0 18 0   0     0   0   17 2                 19
934973 934973 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No 1 01 08 2016   grade_8 6 1 2 0   0     0   2   9 2                       11 6 1 2 0   0     0   2   9 2                 11
935455 935455 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 01 12 2016   grade_8 * * * *   *     *   *   2 2                       4                         2 2                 4
935476 935476 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_8 130 9 90 0   5     0   1   113 122                       235 130 9 90 0   5     0   1   113 122                 235
935865 935865 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_8 4 0 7 0   0     0   0   9 2                       11 4 0 7 0   0     0   0   9 2                 11
1123139 1123139 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_8 1 17 15 0   0     0   0   23 10                       33 1 17 15 0   0     0   0   23 10                 33
1125426 1125426 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_8 * * * *   *     *   *   2 3                       *                         2 3                  
1125450 1125450 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_8 134 7 86 0   3     0   2   120 112                       232 134 7 86 0   3     0   2   120 112                 232
1125885 1125885 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_8 1 0 17 0   1     0   0   15 4                       19 1 0 17 0   1     0   0   15 4                 19
1367199 1367199 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_8 3 1 0 0   0     0   4   7 1 *                     8.0 3 1 0 0   0     0   4   7 1                 8
1673284 1673284 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_8 0 3 6 0   0     0   0   7 2 *                     9.0 0 3 6 0   0     0   0   7 2                 9
1674432 1674432 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_8 4 2 3 0   0     0   1   8 2 *                     10.0 4 2 3 0   0     0   1   8 2                 10
2040825 2040825 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_8 3 14 11 1   0     0   0   23 6                       29.0 3 14 11 1   0     0   0   23 6                 29
2042271 2042271 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_8 4 0 2 0   0     0   0   3 3                       6.0 4 0 2 0   0     0   0   3 3                 6
2042772 2042772 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_8 * * * *   *     *   *   2 *                       2.0                         2                   2
2229943 2229943 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_8 2 17 14 0   1     0   3   30 7                       37.0 2 17 14 0   1     0   3   30 7                 37
2230004 2230004 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_8 0 15 18 0   0     0   2   18 17                       35.0 0 15 18 0   0     0   2   18 17                 35
2231477 2231477 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_8 5 0 2 0   0     0   0   3 4                       7.0 5 0 2 0   0     0   0   3 4                 7
2231499 2231499 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_8 15 20 90 2   2     0   0   61 68                       129.0 15 20 90 2   2     0   0   61 68                 129
2232701 2232701 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_8 1 1 8 0   0     0   0   9 1                       10.0 1 1 8 0   0     0   0   9 1                 10
738605 738605 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_8 * * * *   *     *   *   4 1                       5                         4 1                 5
1124820 1124820 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_8 2 1 3 0   0     0   0   6 *                       6 2 1 3 0   0     0   0   6                   6
1365884 1365884 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_8 4 27 9 0   7     0   4   26 25 *                     51.0 4 27 9 0   7     0   4   26 25                 51
1366220 1366220 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_8 5 3 1 0   0     0   0   7 2 *                     9.0 5 3 1 0   0     0   0   7 2                 9
1367688 1367688 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_8 * * * *   *     *   *   2 * *                     2.0                         2                   2
1673121 1673121 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_8 13 25 20 1   2     0   0   30 31 *                     61.0 13 25 20 1   2     0   0   30 31                 61
1673453 1673453 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_8 1 3 4 0   0     0   0   7 1 *                     8.0 1 3 4 0   0     0   0   7 1                 8
2040881 2040881 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_8 1 12 10 0   0     0   1   12 12                       24.0 1 12 10 0   0     0   1   12 12                 24
2040928 2040928 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_8 12 22 16 0   8     0   2   34 26                       60.0 12 22 16 0   8     0   2   34 26                 60
2043455 2043455 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_8 * * * *   *     *   *   5 *                       5.0                         5                   5
2230057 2230057 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_8 17 28 14 0   6     0   3   39 29                       68.0 17 28 14 0   6     0   3   39 29                 68
736563 736563 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_8 7 45 46 0   0     0   0   56 42                       98 7 45 46 0   0     0   0   56 42                 98
738909 738909 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2015   grade_8 4 3 84 0   1     0   1   47 46                       93 4 3 84 0   1     0   1   47 46                 93
933432 933432 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2016   grade_8 8 35 49 0   0     0   1   58 35                       93 8 35 49 0   0     0   1   58 35                 93
935758 935758 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2016   grade_8 5 1 86 0   1     0   0   53 40                       93 5 1 86 0   1     0   0   53 40                 93
1123010 1123010 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Elementary 03 08 2017   grade_8 9 25 45 0   2     0   5   58 28                       86 9 25 45 0   2     0   5   58 28                 86
1123252 1123252 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_8 11 28 14 0   5     0   2   26 34                       60 11 28 14 0   5     0   2   26 34                 60
1125783 1125783 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_8 1 1 80 0   3     0   0   44 41                       85 1 1 80 0   3     0   0   44 41                 85
1365669 1365669 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2020   grade_8 8 24 34 0   3     0   3   39 33 *                     72.0 8 24 34 0   3     0   3   39 33                 72
1365837 1365837 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 03 08 2020   grade_8 0 20 12 0   0     0   4   21 15 *                     36.0 0 20 12 0   0     0   4   21 15                 36
1367982 1367982 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_8 4 2 82 0   3     0   0   48 43 *                     91.0 4 2 82 0   3     0   0   48 43                 91
1368370 1368370 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_8 * * * *   *     *   *   3 * *                     3.0                         3                   3
1672902 1672902 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston - William H Ohrenberger   Regular School No Middle 03 08 2021   grade_8 4 23 39 0   0     0   4   42 28 *                     70.0 4 23 39 0   0     0   4   42 28                 70
1673074 1673074 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston - Higginson/Lewis K-8   Regular School No Middle 03 08 2021   grade_8 2 21 21 0   0     0   2   32 14 *                     46.0 2 21 21 0   0     0   2   32 14                 46
1675227 1675227 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence - Alexander B Bruce   Regular School No Middle 03 08 2021   grade_8 5 0 69 0   2     0   0   36 40 *                     76.0 5 0 69 0   2     0   0   36 40                 76
1675615 1675615 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_8 4 0 6 0   0     0   0   9 * *                     10.0 4 0 6 0   0     0   0   9                   10
2040712 2040712 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2019   grade_8 12 20 40 0   2     0   1   47 28                       75.0 12 20 40 0   2     0   1   47 28                 75
2041289 2041289 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_8 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2043066 2043066 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_8 6 0 88 0   3     0   0   46 51                       97.0 6 0 88 0   3     0   0   46 51                 97
2229815 2229815 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston: William H Ohrenberger   Regular School No Middle 03 08 2018   grade_8 10 31 44 0   2     0   1   45 43                       88.0 10 31 44 0   2     0   1   45 43                 88
2232266 2232266 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill: Consentino Middle School   Regular School No Middle 03 08 2018   grade_8 91 9 101 0   3     0   0   104 100                       204.0 91 9 101 0   3     0   0   104 100                 204
2232600 2232600 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence: Alexander B Bruce   Regular School No Middle 03 08 2018   grade_8 3 1 79 0   0     0   0   41 42                       83.0 3 1 79 0   0     0   0   41 42                 83
736742 736742 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   grade_8 1 76 25 1   2     0   1   68 38                       106 1 76 25 1   2     0   1   68 38                 106
737141 737141 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_8 * * * *   *     *   *   3 1                       4                         3 1                 4
737618 737618 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_8 97 4 31 0   4     0   0   61 75                       136 97 4 31 0   4     0   0   61 75                 136
738732 738732 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2015   grade_8 8 4 85 0   2     0   1   52 48                       100 8 4 85 0   2     0   1   52 48                 100
739186 739186 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No 2 04 08 2015   grade_8 24 13 7 0   2     0   1   17 30                       47 24 13 7 0   2     0   1   17 30                 47
743713 743713 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes 2 04 08 2015   grade_8 39 3 5 0   0     0   0   28 19                       47 39 3 5 0   0     0   0   28 19                 47
743769 743769 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2015   grade_8 2 28 5 0   0     1   1   16 21                       37 2 28 5 0   0     1   1   16 21                 37
932585 932585 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 04 08 2016   grade_8 * * * *   *     *   *   2 1                       3                         2 1                 3
933646 933646 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 04 12 2016   grade_8 7 40 6 0   4     0   3   28 32                       60 7 40 6 0   4     0   3   28 32                 60
934002 934002 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2016   grade_8 1 5 1 0   0     0   0   6 1                       7 1 5 1 0   0     0   0   6 1                 7
934478 934478 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2016   grade_8 84 5 30 1   2     0   2   74 50                       124 84 5 30 1   2     0   2   74 50                 124
935578 935578 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2016   grade_8 2 0 63 0   1     0   2   40 28                       68 2 0 63 0   1     0   2   40 28                 68
936032 936032 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No 2 04 08 2016   grade_8 21 8 7 0   2     1   4   17 26                       43 21 8 7 0   2     1   4   17 26                 43
940542 940542 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes 2 04 08 2016   grade_8 33 1 0 0   2     0   0   16 20                       36 33 1 0 0   2     0   0   16 20                 36
940598 940598 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2016   grade_8 0 35 9 0   0     0   0   24 20                       44 0 35 9 0   0     0   0   24 20                 44
941306 941306 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No 2 04 08 2016   grade_8 185 2 5 0   4     0   4   98 102                       200 185 2 5 0   4     0   4   98 102                 200
1124227 1124227 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_8 93 12 28 0   2     0   4   70 69                       139 93 12 28 0   2     0   4   70 69                 139
1125268 1125268 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125570 1125570 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Elementary 04 08 2017   grade_8 5 0 65 0   0     0   0   37 33                       70 5 0 65 0   0     0   0   37 33                 70
1126090 1126090 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Elementary 04 08 2017   grade_8 14 6 7 0   2     0   5   20 14                       34 14 6 7 0   2     0   5   20 14                 34
1131447 1131447 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Elementary 04 08 2017   grade_8 37 0 2 0   1     0   0   19 21                       40 37 0 2 0   1     0   0   19 21                 40
1367816 1367816 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2020   grade_8 3 3 42 0   0     0   0   30 18 *                     48.0 3 3 42 0   0     0   0   30 18                 48
1368231 1368231 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2020   grade_8 18 4 10 0   1     1   5   20 19 *                     39.0 18 4 10 0   1     1   5   20 19                 39
1368822 1368822 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2020   grade_8 70 1 8 0   2     0   4   39 46 *                     85.0 70 1 8 0   2     0   4   39 46                 85
1369345 1369345 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2020   grade_8 2 0 5 0   0     0   2   4 5 *                     9.0 2 0 5 0   0     0   2   4 5                 9
1372770 1372770 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2020   grade_8 26 3 3 0   2     0   2   18 18 *                     36.0 26 3 3 0   2     0   2   18 18                 36
1675062 1675062 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 Holyoke - William R. Peck School   Regular School No Middle 04 08 2021   grade_8 2 1 56 0   0     0   0   38 21 *                     59.0 2 1 56 0   0     0   0   38 21                 59
1675476 1675476 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Lincoln - Hanscom Middle   Regular School No Middle 04 08 2021   grade_8 17 6 13 0   1     0   5   19 23 *                     42.0 17 6 13 0   1     0   5   19 23                 42
1676072 1676072 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Maynard - Fowler School   Regular School No Middle 04 08 2021   grade_8 74 3 15 0   2     0   3   55 41 *                     97.0 74 3 15 0   2     0   3   55 41                 97
1676593 1676593 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_8 2 2 5 0   0     0   1   6 4 *                     10.0 2 2 5 0   0     0   1   6 4                 10
1680034 1680034 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public (District) - Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2021   grade_8 19 2 2 0   0     0   2   16 9 *                     25.0 19 2 2 0   0     0   2   16 9                 25
2042794 2042794 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_8 97 4 101 0   5     1   2   104 106                       210.0 97 4 101 0   5     1   2   104 106                 210
2042897 2042897 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2019   grade_8 6 1 59 0   0     0   0   41 25                       66.0 6 1 59 0   0     0   0   41 25                 66
2043315 2043315 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2019   grade_8 33 5 9 1   1     0   4   24 29                       53.0 33 5 9 1   1     0   4   24 29                 53
2043893 2043893 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2019   grade_8 74 1 10 0   2     0   4   48 43                       91.0 74 1 10 0   2     0   4   48 43                 91
2044417 2044417 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_8 9 3 7 0   0     0   1   12 8                       20.0 9 3 7 0   0     0   1   12 8                 20
2047841 2047841 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2019   grade_8 33 3 3 1   1     0   0   25 16                       41.0 33 3 3 1   1     0   0   25 16                 41
2231042 2231042 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton: Clinton Middle School   Regular School No Middle 04 08 2018   grade_8 93 5 29 0   1     0   3   73 58                       131.0 93 5 29 0   1     0   3   73 58                 131
2232386 2232386 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 Holyoke: William R. Peck School   Regular School No Middle 04 08 2018   grade_8 7 2 74 0   0     0   0   37 46                       83.0 7 2 74 0   0     0   0   37 46                 83
2232906 2232906 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Lincoln: Hanscom Middle   Regular School No Middle 04 08 2018   grade_8 27 5 9 0   1     0   5   29 18                       47.0 27 5 9 0   1     0   5   29 18                 47
2233590 2233590 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Maynard: Fowler School   Regular School No Middle 04 08 2018   grade_8 92 4 14 1   1     0   2   54 60                       114.0 92 4 14 1   1     0   2   54 60                 114
2238280 2238280 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public (District): Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2018   grade_8 34 0 0 0   1     0   1   19 17                       36.0 34 0 0 0   1     0   1   19 17                 36
735682 735682 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_8 114 0 0 0   1     0   0   55 60                       115 114 0 0 0   1     0   0   55 60                 115
735707 735707 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 05 08 2015   grade_8 * * * *   *     *   *   2 3                       5                         2 3                 5
735729 735729 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2015   grade_8 159 6 8 0   0     0   7   105 75                       180 159 6 8 0   0     0   7   105 75                 180
735899 735899 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2015   grade_8 121 5 10 0   7     0   7   80 70                       150 121 5 10 0   7     0   7   80 70                 150

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