enrollments

Data source: Big Local News · About: Big Local

499 rows where grade = "grade_8", state = "MA" and year = 2021 sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 499 ✖

grade ✖

  • grade_8 · 499 ✖
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
1679931 1679931 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   grade_8 19 61 31 0   0     0   0   54 57 *                     111.0 19 61 31 0   0     0   0   54 57                 111
1672017 1672017 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington - Abington Middle School   Regular School No Middle 05 08 2021   grade_8 136 5 18 1   3     0   6   82 87 *                     169.0 136 5 18 1   3     0   6   82 87                 169
1679734 1679734 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District) - Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2021   grade_8 9 44 22 0   0     0   1   39 37 *                     76.0 9 44 22 0   0     0   1   39 37                 76
1680288 1680288 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Acton-Boxborough - Raymond J Grey Junior High   Regular School No Middle 07 08 2021   grade_8 202 14 28 2   159     2   14   212 208 *                     421.0 202 14 28 2   159     2   14   212 208                 421
1672032 1672032 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_8 99 0 4 0   1     0   5   59 50 *                     109.0 99 0 4 0   1     0   5   59 50                 109
1680303 1680303 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Regional - Hoosac Valley High School   Regular School No High 08 12 2021   grade_8 83 6 4 0   0     0   2   48 47 *                     95.0 83 6 4 0   0     0   2   48 47                 95
1679825 1679825 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District) - Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2021   grade_8 87 2 8 0   19     0   9   65 60 *                     125.0 87 2 8 0   19     0   9   65 60                 125
1672057 1672057 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam - Agawam Junior High   Regular School No Middle 07 08 2021   grade_8 229 13 20 0   4     0   9   138 137 *                     275.0 229 13 20 0   4     0   9   138 137                 275
1679715 1679715 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_8 8 11 29 0   0     0   0   19 29 *                     48.0 8 11 29 0   0     0   0   19 29                 48
1672077 1672077 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_8 121 5 11 0   3     1   6   70 77 *                     147.0 121 5 11 0   3     1   6   70 77                 147
1680309 1680309 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst-Pelham - Amherst Regional Middle School   Regular School No Middle 07 08 2021   grade_8 101 14 40 0   26     0   22   115 88 *                     203.0 101 14 40 0   26     0   22   115 88                 203
1672141 1672141 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover - Doherty Middle   Regular School No Middle 06 08 2021   grade_8 133 2 12 1   17     1   4   83 87 *                     170.0 133 2 12 1   17     1   4   83 87                 170
1672144 1672144 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover - Andover West Middle   Regular School No Middle 06 08 2021   grade_8 119 6 14 0   29     0   7   97 78 *                     175.0 119 6 14 0   29     0   7   97 78                 175
1672147 1672147 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover - Wood Hill Middle School   Regular School No Middle 06 08 2021   grade_8 62 3 12 1   50     0   3   73 58 *                     131.0 62 3 12 1   50     0   3   73 58                 131
1681476 1681476 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2021   grade_8 69 10 24 0   1     0   5   58 51 *                     109.0 69 10 24 0   1     0   5   58 51                 109
1672198 1672198 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington - Ottoson Middle   Regular School No Middle 07 08 2021   grade_8 309 15 35 1   46     1   29   239 196 *                     436.0 309 15 35 1   46     1   29   239 196                 436
1680330 1680330 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Ashburnham-Westminster - Overlook Middle School   Regular School No Middle 06 08 2021   grade_8 165 1 7 0   2     0   4   90 89 *                     179.0 165 1 7 0   2     0   4   90 89                 179
1672212 1672212 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland - Ashland Middle   Regular School No Middle 06 08 2021   grade_8 142 7 33 0   28     0   8   110 108 *                     218.0 142 7 33 0   28     0   8   110 108                 218
1680352 1680352 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston - Athol-Royalston Middle School   Regular School No Middle 05 08 2021   grade_8 90 0 14 1   3     0   3   68 43 *                     111.0 90 0 14 1   3     0   3   68 43                 111
1680185 1680185 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_8 82 3 16 0   2     0   7   49 61 *                     110.0 82 3 16 0   2     0   7   49 61                 110
1672246 1672246 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro - Robert J. Coelho Middle School   Regular School No Middle 05 08 2021   grade_8 128 12 23 0   6     0   11   99 81 *                     180.0 128 12 23 0   6     0   11   99 81                 180
1672250 1672250 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro - Cyril K. Brennan Middle School   Regular School No Middle 05 08 2021   grade_8 100 9 41 0   9     0   5   94 70 *                     164.0 100 9 41 0   9     0   5   94 70                 164
1672254 1672254 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro - Wamsutta Middle School   Regular School No Middle 05 08 2021   grade_8 85 11 21 0   11     0   7   64 71 *                     135.0 85 11 21 0   11     0   7   64 71                 135
1672274 1672274 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn - Auburn Middle   Regular School No Middle 06 08 2021   grade_8 152 5 26 0   10     0   9   104 98 *                     202.0 152 5 26 0   10     0   9   104 98                 202
1672290 1672290 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon - Avon Middle High School   Regular School No High 07 12 2021   grade_8 28 19 6 0   3     0   5   27 34 *                     61.0 28 19 6 0   3     0   5   27 34                 61
1680373 1680373 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley School District - Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2021   grade_8 108 4 19 1   1     0   4   79 58 *                     137.0 108 4 19 1   1     0   4   79 58                 137
1672320 1672320 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_8 265 31 62 0   11     2   18   192 197 *                     389.0 265 31 62 0   11     2   18   192 197                 389
1681439 1681439 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District) - Baystate Academy Charter Public School   Regular School Yes High 06 12 2021   grade_8 3 16 58 0   0     0   0   35 42 *                     77.0 3 16 58 0   0     0   0   35 42                 77
1672335 1672335 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 Bedford - John Glenn Middle   Regular School No Middle 06 08 2021   grade_8 141 10 12 1   41     0   1   120 86 *                     206.0 141 10 12 1   41     0   1   120 86                 206
1672349 1672349 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Belchertown - Jabish Middle School   Regular School No Middle 07 08 2021   grade_8 165 7 7 0   3     1   4   101 85 *                     187.0 165 7 7 0   3     1   4   101 85                 187
1672367 1672367 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham - Bellingham High School   Regular School No High 08 12 2021   grade_8 144 0 9 0   10     0   0   81 82 *                     163.0 144 0 9 0   10     0   0   81 82                 163
1672400 1672400 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_8 212 14 16 0   76     0   25   175 168 *                     343.0 212 14 16 0   76     0   25   175 168                 343
1679957 1679957 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District) - Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2021   grade_8 35 2 0 0   15     0   0   22 30 *                     52.0 35 2 0 0   15     0   0   22 30                 52
1672414 1672414 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley - Berkley Middle School   Regular School No Middle 05 08 2021   grade_8 88 1 5 0   0     0   2   48 48 *                     96.0 88 1 5 0   0     0   2   48 48                 96
1679747 1679747 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_8 40 10 8 1   3     0   5   38 28 *                     67.0 40 10 8 1   3     0   5   38 28                 67
1680387 1680387 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_8 79 3 11 0   2     0   5   60 40 *                     100.0 79 3 11 0   2     0   5   60 40                 100
1680408 1680408 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Berlin-Boylston - Tahanto Regional High   Regular School No High 06 12 2021   grade_8 65 4 2 0   3     0   3   32 45 *                     77.0 65 4 2 0   3     0   3   32 45                 77
1672444 1672444 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly - Beverly Middle School   Regular School No Middle 05 08 2021   grade_8 265 10 56 0   12     0   7   178 172 *                     350.0 265 10 56 0   12     0   7   178 172                 350
1672482 1672482 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica - Billerica Memorial High School   Regular School No High 08 12 2021   grade_8 303 26 29 1   30     1   13   205 198 *                     403.0 303 26 29 1   30     1   13   205 198                 403
1680428 1680428 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Blackstone-Millville - Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2021   grade_8 120 0 18 0   2     0   5   62 83 *                     145.0 120 0 18 0   2     0   5   62 83                 145
1672504 1672504 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston - Lyon K-8   Regular School No Elementary KG 08 2021   grade_8 3 4 8 0   1     0   1   13 4 *                     17.0 3 4 8 0   1     0   1   13 4                 17
1672528 1672528 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston - Boston Teachers Union School   Regular School No Elementary PK 08 2021   grade_8 3 14 12 1   0     0   0   15 15 *                     30.0 3 14 12 1   0     0   0   15 15                 30
1672538 1672538 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Boston - Jackson Mann   Regular School No Elementary PK 08 2021   grade_8 1 17 17 0   2     0   0   21 16 *                     37.0 1 17 17 0   2     0   0   21 16                 37
1672563 1672563 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston - Curley K-8 School   Regular School No Elementary PK 08 2021   grade_8 2 20 57 0   1     0   3   38 45 *                     83.0 2 20 57 0   1     0   3   38 45                 83
1672611 1672611 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston - Dearborn   Regular School No High 06 12 2021   grade_8 2 52 29 0   2     2   2   45 44 *                     89.0 2 52 29 0   2     2   2   45 44                 89
1672625 1672625 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston - Dennis C Haley   Regular School No Elementary PK 08 2021   grade_8 1 17 23 0   0     1   3   22 23 *                     45.0 1 17 23 0   0     1   3   22 23                 45
1672635 1672635 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston - Donald Mckay   Regular School No Elementary PK 08 2021   grade_8 5 1 91 0   1     0   0   52 46 *                     98.0 5 1 91 0   1     0   0   52 46                 98
1672653 1672653 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston - Eliot Elementary   Regular School No Elementary PK 08 2021   grade_8 16 8 19 1   5     0   1   25 25 *                     50.0 16 8 19 1   5     0   1   25 25                 50
1672670 1672670 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Boston - Franklin D Roosevelt   Regular School No Elementary PK 08 2021   grade_8 2 20 21 0   1     0   2   27 19 *                     46.0 2 20 21 0   1     0   2   27 19                 46
1672710 1672710 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston - Condon K-8   Regular School No Elementary PK 08 2021   grade_8 18 27 29 0   3     0   1   42 36 *                     78.0 18 27 29 0   3     0   1   42 36                 78
1672719 1672719 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston - James W Hennigan   Regular School No Elementary KG 08 2021   grade_8 4 14 55 0   0     0   0   32 41 *                     73.0 4 14 55 0   0     0   0   32 41                 73
1672758 1672758 MA Suffolk   school 2502790 35   Boston 250279000269 350179 Boston - John W McCormack   Regular School No Middle 06 08 2021   grade_8 5 35 60 0   3     0   2   42 63 *                     105.0 5 35 60 0   3     0   2   42 63                 105
1672783 1672783 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston - Joseph J Hurley   Regular School No Elementary PK 08 2021   grade_8 0 1 19 0   0     0   0   13 7 *                     20.0 0 1 19 0   0     0   0   13 7                 20
1672793 1672793 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston - Joseph Lee   Regular School No Elementary PK 08 2021   grade_8 2 29 19 0   4     0   6   31 29 *                     60.0 2 29 19 0   4     0   6   31 29                 60
1672811 1672811 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston - Joyce Kilmer   Regular School No Elementary PK 08 2021   grade_8 9 5 10 0   2     0   2   14 14 *                     28.0 9 5 10 0   2     0   2   14 14                 28
1672844 1672844 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston - Maurice J Tobin   Regular School No Elementary PK 08 2021   grade_8 3 8 26 0   1     0   0   12 26 *                     38.0 3 8 26 0   1     0   0   12 26                 38
1672869 1672869 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston - Richard J Murphy   Regular School No Elementary PK 08 2021   grade_8 2 26 29 0   28     0   2   52 35 *                     87.0 2 26 29 0   28     0   2   52 35                 87
1672886 1672886 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston - Oliver Hazard Perry   Regular School No Elementary PK 08 2021   grade_8 7 3 2 0   1     0   1   6 8 *                     14.0 7 3 2 0   1     0   1   6 8                 14
1672896 1672896 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   grade_8 1 42 46 0   0     1   0   44 46 *                     90.0 1 42 46 0   0     1   0   44 46                 90
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
1672912 1672912 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston - Lyndon   Regular School No Elementary PK 08 2021   grade_8 4 6 16 0   0     0   1   13 14 *                     27.0 4 6 16 0   0     0   1   13 14                 27
1672977 1672977 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston - Sarah Greenwood   Regular School No Elementary PK 08 2021   grade_8 2 6 19 0   0     0   0   16 11 *                     27.0 2 6 19 0   0     0   0   16 11                 27
1672987 1672987 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Boston - Gardner Pilot Academy   Regular School No Elementary PK 08 2021   grade_8 6 8 22 0   2     0   1   21 18 *                     39.0 6 8 22 0   2     0   1   21 18                 39
1673005 1673005 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston - Warren-Prescott   Regular School No Elementary PK 08 2021   grade_8 12 5 11 0   1     0   4   13 20 *                     33.0 12 5 11 0   1     0   4   13 20                 33
1673019 1673019 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_8 3 12 10 0   1     0   1   22 5 *                     27.0 3 12 10 0   1     0   1   22 5                 27
1673041 1673041 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_8 1 12 5 0   0     0   1   11 8 *                     19.0 1 12 5 0   0     0   1   11 8                 19
1673058 1673058 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston - Edison K-8   Regular School No Elementary PK 08 2021   grade_8 3 13 33 0   4     0   3   32 24 *                     56.0 3 13 33 0   4     0   3   32 24                 56
1673068 1673068 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston - King K-8   Regular School No Elementary PK 08 2021   grade_8 2 21 17 0   0     0   1   20 21 *                     41.0 2 21 17 0   0     0   1   20 21                 41
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
1673084 1673084 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston - Mildred Avenue K-8   Regular School No Elementary PK 08 2021   grade_8 2 50 38 0   1     0   0   56 35 *                     91.0 2 50 38 0   1     0   0   56 35                 91
1673094 1673094 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston - Young Achievers   Alternative School No Elementary PK 08 2021   grade_8 1 19 24 0   0     0   0   22 22 *                     44.0 1 19 24 0   0     0   0   22 22                 44
1673104 1673104 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_8 3 2 12 0   0     0   1   10 8 *                     18.0 3 2 12 0   0     0   1   10 8                 18
1673107 1673107 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Boston - Lilla G. Frederick Middle School   Regular School No Middle 06 08 2021   grade_8 2 62 66 0   9     0   4   78 65 *                     143.0 2 62 66 0   9     0   4   78 65                 143
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
1673128 1673128 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Boston - Clarence R Edwards Middle   Regular School No Middle 06 08 2021   grade_8 13 17 84 0   2     0   1   60 57 *                     117.0 13 17 84 0   2     0   1   60 57                 117
1673131 1673131 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Boston - Washington Irving Middle   Regular School No Middle 06 08 2021   grade_8 5 28 44 0   0     0   0   37 40 *                     77.0 5 28 44 0   0     0   0   37 40                 77
1673134 1673134 MA Suffolk   school 2502790 35   Boston 250279000258 350485 Boston - James P Timilty Middle   Regular School No Middle 06 08 2021   grade_8 1 36 54 0   2     0   0   46 47 *                     93.0 1 36 54 0   2     0   0   46 47                 93
1673188 1673188 MA Suffolk   school 2502790 35   Boston 250279000704 350542 Boston - New Mission High School   Alternative School No High 07 12 2021   grade_8 2 25 22 0   0     0   1   22 28 *                     50.0 2 25 22 0   0     0   1   22 28                 50
1673197 1673197 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston - Boston Latin Academy   Regular School No High 07 12 2021   grade_8 94 56 73 1   43     0   14   119 162 *                     281.0 94 56 73 1   43     0   14   119 162                 281
1673218 1673218 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston - Boston Latin   Regular School No High 07 12 2021   grade_8 186 30 52 1   126     0   22   189 227 *                     417.0 186 30 52 1   126     0   22   189 227                 417
1673225 1673225 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston - Quincy Upper School   Regular School No High 06 12 2021   grade_8 2 14 21 0   38     0   1   39 37 *                     76.0 2 14 21 0   38     0   1   39 37                 76
1673232 1673232 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston - O'Bryant School Math/Science   Regular School No High 07 12 2021   grade_8 26 49 58 0   32     1   3   91 78 *                     169.0 26 49 58 0   32     1   3   91 78                 169
1673256 1673256 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston - Mario Umana Academy   Regular School No Elementary PK 08 2021   grade_8 7 1 137 0   1     0   1   74 73 *                     147.0 7 1 137 0   1     0   1   74 73                 147
1673259 1673259 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston - TechBoston Academy   Regular School No High 06 12 2021   grade_8 6 73 36 0   2     0   4   61 60 *                     121.0 6 73 36 0   2     0   4   61 60                 121
1673277 1673277 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_8 2 0 23 0   0     0   0   12 13 *                     25.0 2 0 23 0   0     0   0   12 13                 25
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
1679961 1679961 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District) - Boston Collegiate Charter School   Regular School Yes High 05 12 2021   grade_8 47 34 10 0   0     0   4   47 48 *                     95.0 47 34 10 0   0     0   4   47 48                 95
1679726 1679726 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School (District) - Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2021   grade_8 5 28 29 0   1     0   3   35 31 *                     66.0 5 28 29 0   1     0   3   35 31                 66
1679754 1679754 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public (District) - Boston Preparatory Charter Public School   Regular School Yes High 06 12 2021   grade_8 1 73 26 0   1     0   4   57 48 *                     105.0 1 73 26 0   1     0   4   57 48                 105
1673302 1673302 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne - Bourne Middle School   Regular School No Middle 06 08 2021   grade_8 132 3 10 3   2     0   7   88 69 *                     157.0 132 3 10 3   2     0   7   88 69                 157
1673351 1673351 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 Braintree - East Middle School   Regular School No Middle 05 08 2021   grade_8 135 28 15 0   64     0   1   124 119 *                     243.0 135 28 15 0   64     0   1   124 119                 243
1673354 1673354 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree - South Middle School   Regular School No Middle 06 08 2021   grade_8 168 9 10 0   54     0   1   115 127 *                     242.0 168 9 10 0   54     0   1   115 127                 242
1679768 1679768 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School (District) - Bridge Boston Charter School   Regular School Yes Elementary PK 08 2021   grade_8 0 12 5 0   0     0   3   11 9 *                     20.0 0 12 5 0   0     0   3   11 9                 20
1680449 1680449 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham - Raynham Middle School   Regular School No Middle 05 08 2021   grade_8 158 14 4 0   4     0   8   122 65 *                     188.0 158 14 4 0   4     0   8   122 65                 188
1680451 1680451 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater-Raynham - Bridgewater Middle School   Regular School No Middle 07 08 2021   grade_8 243 20 5 1   5     1   21   141 155 *                     296.0 243 20 5 1   5     1   21   141 155                 296
1680452 1680452 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Bridgewater-Raynham - Therapeutic Day School   Special Education School No High 07 12 2021   grade_8 * * * *   *     *   *   1 * *                     1.0                         1                   1
1673416 1673416 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_8 16 79 19 1   2     0   7   58 66 *                     124.0 16 79 19 1   2     0   7   58 66                 124
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
1673460 1673460 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 Brockton - East Middle School   Regular School No Middle 06 08 2021   grade_8 24 188 31 2   3     0   10   128 130 *                     258.0 24 188 31 2   3     0   10   128 130                 258
1673464 1673464 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 Brockton - South Middle School   Regular School No Middle 06 08 2021   grade_8 26 142 30 0   0     0   6   113 91 *                     204.0 26 142 30 0   0     0   6   113 91                 204

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