enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,471 ✖
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
2240031 2240031 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District: TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2018   grade_7 95 11 19 1   6     0   7   62 77                       139.0 95 11 19 1   6     0   7   62 77                 139
2240017 2240017 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District: Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2018   grade_7 33 1 16 0   0     1   7   30 28                       58.0 33 1 16 0   0     1   7   30 28                 58
2239999 2239999 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District): New Heights Charter School of Brockton   Regular School Yes Middle 06 09 2018   grade_7 1 95 10 0   0     0   2   51 57                       108.0 1 95 10 0   0     0   2   51 57                 108
2239982 2239982 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District): Argosy Collegiate Charter School   Regular School Yes Middle 06 09 2018   grade_7 65 10 15 1   3     1   8   54 49                       103.0 65 10 15 1   3     1   8   54 49                 103
2239964 2239964 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II) (District): Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2018   grade_7 24 20 16 0   13     0   4   37 40                       77.0 24 20 16 0   13     0   4   37 40                 77
2239961 2239961 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester (District): UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2018   grade_7 0 39 28 1   1     0   2   33 38                       71.0 0 39 28 1   1     0   2   33 38                 71
2239946 2239946 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell (District): Collegiate Charter School of Lowell   Regular School Yes Elementary KG 07 2018   grade_7 15 11 20 0   16     0   2   32 32                       64.0 15 11 20 0   16     0   2   32 32                 64
2239933 2239933 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 Secondary 06 11 2018   grade_7 6 18 55 0   0     0   1   48 32                       80.0 6 18 55 0   0     0   1   48 32                 80
2239779 2239779 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson: Hanson Middle School   Regular School No Middle 06 08 2018   grade_7 125 1 4 0   0     0   1   83 48                       131.0 125 1 4 0   0     0   1   83 48                 131
2239775 2239775 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman-Hanson: Whitman Middle   Regular School No Middle 06 08 2018   grade_7 162 9 10 3   3     1   7   112 83                       195.0 162 9 10 3   3     1   7   112 83                 195
2239743 2239743 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional: Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2018   grade_7 113 0 9 0   0     0   4   64 62                       126.0 113 0 9 0   0     0   4   64 62                 126
2239717 2239717 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Wachusett: Chocksett Middle School   Regular School No Middle 05 08 2018   grade_7 83 1 7 0   2     0   3   48 48                       96.0 83 1 7 0   2     0   3   48 48                 96
2239712 2239712 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Wachusett: Central Tree Middle   Regular School No Middle 06 08 2018   grade_7 116 0 3 0   4     0   9   73 59                       132.0 116 0 3 0   4     0   9   73 59                 132
2239708 2239708 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Wachusett: Mountview Middle   Regular School No Middle 06 08 2018   grade_7 224 7 11 0   12     0   4   133 125                       258.0 224 7 11 0   12     0   4   133 125                 258
2239700 2239700 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett: Thomas Prince   Regular School No Elementary KG 08 2018   grade_7 38 1 2 0   0     0   1   19 23                       42.0 38 1 2 0   0     0   1   19 23                 42
2239690 2239690 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Wachusett: Paxton Center   Regular School No Elementary KG 08 2018   grade_7 57 1 2 0   1     0   1   37 25                       62.0 57 1 2 0   1     0   1   37 25                 62
2239647 2239647 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_7 45 2 1 1   2     0   2   24 29                       53.0 45 2 1 1   2     0   2   24 29                 53
2239624 2239624 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton: Triton Regional Middle School   Regular School No Middle 07 08 2018   grade_7 200 3 6 1   1     0   3   110 104                       214.0 200 3 6 1   1     0   3   110 104                 214
2239584 2239584 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua: Tantasqua Regional Jr High   Regular School No Middle 07 08 2018   grade_7 262 1 13 1   3     0   13   149 144                       293.0 262 1 13 1   3     0   13   149 144                 293
2239576 2239576 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield: Knox Trail Middle School   Regular School No Middle 05 08 2018   grade_7 100 1 12 0   2     0   1   67 49                       116.0 100 1 12 0   2     0   1   67 49                 116
2239552 2239552 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District: Southwick Regional School   Regular School No High 07 12 2018   grade_7 105 3 4 0   3     0   1   59 57                       116.0 105 3 4 0   3     0   1   59 57                 116
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
2239505 2239505 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake: Silver Lake Regional Middle School   Regular School No Middle 07 08 2018   grade_7 261 3 4 0   2     0   1   144 127                       271.0 261 3 4 0   2     0   1   144 127                 271
2239491 2239491 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar: Ralph C Mahar Regional   Regular School No High 07 12 2018   grade_7 114 1 8 0   2     0   1   69 57                       126.0 114 1 8 0   2     0   1   69 57                 126
2239480 2239480 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin: Quabbin Regional Middle School   Regular School No Middle 07 08 2018   grade_7 162 0 5 0   1     0   6   78 96                       174.0 162 0 5 0   1     0   6   78 96                 174
2239439 2239439 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley: Pioneer Valley Regional   Regular School No High 07 12 2018   grade_7 68 0 1 0   1     0   4   39 35                       74.0 68 0 1 0   1     0   4   39 35                 74
2239398 2239398 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket: Pentucket Regional Middle   Regular School No Middle 07 08 2018   grade_7 196 1 4 0   3     0   3   121 86                       207.0 196 1 4 0   3     0   3   121 86                 207
2239362 2239362 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester: Old Rochester Regional Jr High   Regular School No Middle 07 08 2018   grade_7 200 2 4 0   4     0   8   125 93                       218.0 200 2 4 0   4     0   8   125 93                 218
2239353 2239353 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 North Middlesex: Nissitissit Middle School   Regular School No Middle 05 08 2018   grade_7 116 0 3 0   4     0   2   72 53                       125.0 116 0 3 0   4     0   2   72 53                 125
2239342 2239342 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex: Hawthorne Brook   Regular School No Middle 05 08 2018   grade_7 105 0 1 0   0     0   2   46 62                       108.0 105 0 1 0   0     0   2   46 62                 108
2239304 2239304 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Nashoba: Hale   Regular School No Middle 06 08 2018   grade_7 71 2 5 0   4     0   2   42 42                       84.0 71 2 5 0   4     0   2   42 42                 84
2239300 2239300 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Nashoba: Luther Burbank Middle School   Regular School No Middle 06 08 2018   grade_7 60 2 7 0   4     0   1   45 29                       74.0 60 2 7 0   4     0   1   45 29                 74
2239296 2239296 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Nashoba: Florence Sawyer School   Regular School No Elementary PK 08 2018   grade_7 76 0 3 0   3     0   0   42 40                       82.0 76 0 3 0   3     0   0   42 40                 82
2239264 2239264 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett: Narragansett Middle   Regular School No Middle 05 08 2018   grade_7 95 0 7 0   0     0   2   55 49                       104.0 95 0 7 0   0     0   2   55 49                 104
2239241 2239241 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail: Mohawk Trail Regional High   Regular School No High 07 12 2018   grade_7 54 0 0 0   0     0   0   20 34                       54.0 54 0 0 0   0     0   0   20 34                 54
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
2239199 2239199 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional School District: Monomoy Regional Middle School   Regular School No Middle 05 07 2018   grade_7 110 10 7 0   1     0   4   56 76                       132.0 110 10 7 0   1     0   4   56 76                 132
2239168 2239168 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Mendon-Upton: Miscoe Hill School   Regular School No Middle 05 08 2018   grade_7 181 0 6 0   6     0   3   90 106                       196.0 181 0 6 0   6     0   3   90 106                 196
2239151 2239151 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet: Masconomet Regional Middle School   Regular School No Middle 07 08 2018   grade_7 309 2 6 0   8     0   8   168 165                       333.0 309 2 6 0   8     0   8   168 165                 333
2239138 2239138 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional: Manchester Essex Regional Middle School   Regular School No Middle 06 08 2018   grade_7 121 0 0 0   2     0   2   72 53                       125.0 121 0 0 0   2     0   2   72 53                 125
2239114 2239114 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip: King Philip Middle School   Regular School No Middle 07 08 2018   grade_7 314 8 10 0   4     0   10   177 169                       346.0 314 8 10 0   4     0   10   177 169                 346
2239093 2239093 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire: Hampshire Regional High   Regular School No High 07 12 2018   grade_7 112 1 3 0   1     0   1   58 60                       118.0 112 1 3 0   1     0   1   58 60                 118
2239085 2239085 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Hampden-Wilbraham: Wilbraham Middle   Regular School No Middle 06 08 2018   grade_7 170 3 11 2   7     0   2   102 93                       195.0 170 3 11 2   7     0   2   102 93                 195
2239081 2239081 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002547 6800305 Hampden-Wilbraham: Thornton Burgess   Regular School No Middle 06 08 2018   grade_7 30 0 2 0   0     0   2   19 15                       34.0 30 0 2 0   0     0   2   19 15                 34
2239054 2239054 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Hamilton-Wenham: Miles River Middle   Regular School No Middle 06 08 2018   grade_7 124 0 4 0   3     1   2   59 75                       134.0 124 0 4 0   3     1   2   59 75                 134
2239023 2239023 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Gill-Montague: Great Falls Middle   Regular School No Middle 06 08 2018   grade_7 74 4 9 0   0     0   7   56 38                       94.0 74 4 9 0   0     0   7   56 38                 94
2238997 2238997 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton-Dunstable: Groton Dunstable Regional Middle   Regular School No Middle 05 08 2018   grade_7 161 1 4 1   10     1   2   104 76                       180.0 161 1 4 1   10     1   2   104 76                 180
2238973 2238973 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway: Gateway Regional Middle School   Regular School No Middle 06 08 2018   grade_7 62 0 4 1   0     0   0   36 31                       67.0 62 0 4 1   0     0   0   36 31                 67
2238949 2238949 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier: Frontier Regional   Regular School No High 07 12 2018   grade_7 105 2 4 0   2     0   3   62 54                       116.0 105 2 4 0   2     0   3   62 54                 116
2238941 2238941 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville: Freetown-Lakeville Middle School   Regular School No Middle 06 08 2018   grade_7 242 2 3 0   2     0   2   130 121                       251.0 242 2 3 0   2     0   2   130 121                 251
2238909 2238909 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset: Nauset Regional Middle   Regular School No Middle 06 08 2018   grade_7 155 10 6 0   6     0   6   89 94                       183.0 155 10 6 0   6     0   6   89 94                 183
2238900 2238900 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Dudley-Charlton Reg: Charlton Middle School   Regular School No Middle 05 08 2018   grade_7 166 0 10 0   2     1   2   87 94                       181.0 166 0 10 0   2     1   2   87 94                 181
2238895 2238895 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley-Charlton Reg: Dudley Middle School   Regular School No Middle 05 08 2018   grade_7 128 4 8 0   3     0   4   67 80                       147.0 128 4 8 0   3     0   4   67 80                 147
2238869 2238869 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn: Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2018   grade_7 139 7 5 1   17     0   9   83 95                       178.0 139 7 5 1   17     0   9   83 95                 178
2238859 2238859 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth: Dorothy L Beckwith   Regular School No Middle 05 08 2018   grade_7 135 0 4 0   1     0   6   62 84                       146.0 135 0 4 0   1     0   6   62 84                 146
2238854 2238854 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton-Rehoboth: Dighton Middle School   Regular School No Middle 05 08 2018   grade_7 91 1 4 0   1     0   5   56 46                       102.0 91 1 4 0   1     0   5   56 46                 102
2238831 2238831 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth: Mattacheese Middle School   Regular School No Middle 05 08 2018   grade_7 156 22 18 5   5     0   11   115 102                       217.0 156 22 18 5   5     0   11   115 102                 217
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
2238751 2238751 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater-Raynham: Bridgewater Middle School   Regular School No Middle 07 08 2018   grade_7 232 9 0 1   4     0   9   133 122                       255.0 232 9 0 1   4     0   9   133 122                 255
2238748 2238748 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham: Raynham Middle School   Regular School No Middle 05 08 2018   grade_7 154 6 3 0   3     1   9   91 85                       176.0 154 6 3 0   3     1   9   91 85                 176
2238721 2238721 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Blackstone-Millville: Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2018   grade_7 128 4 4 0   0     0   5   71 70                       141.0 128 4 4 0   0     0   5   71 70                 141
2238697 2238697 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Berlin-Boylston: Tahanto Regional High   Regular School No High 06 12 2018   grade_7 81 1 6 0   3     0   0   52 39                       91.0 81 1 6 0   3     0   0   52 39                 91
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
2238671 2238671 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 2018   grade_7 109 7 18 1   0     1   2   67 71                       138.0 109 7 18 1   0     1   2   67 71                 138
2238646 2238646 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston: Athol-Royalston Middle School   Regular School No Middle 05 08 2018   grade_7 91 0 6 0   0     0   3   49 51                       100.0 91 0 6 0   0     0   3   49 51                 100
2238621 2238621 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Ashburnham-Westminster: Overlook Middle School   Regular School No Middle 06 08 2018   grade_7 187 1 6 0   1     0   4   92 107                       199.0 187 1 6 0   1     0   4   92 107                 199
2238596 2238596 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst-Pelham: Amherst Regional Middle School   Regular School No Middle 07 08 2018   grade_7 105 16 33 0   22     0   18   105 89                       194.0 105 16 33 0   22     0   18   105 89                 194
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
2238571 2238571 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Acton-Boxborough: Raymond J Grey Junior High   Regular School No Middle 07 08 2018   grade_7 273 14 15 0   173     0   11   257 229                       486.0 273 14 15 0   173     0   11   257 229                 486
2238514 2238514 MA Hampden   school 2500522 499   Hampden Charter School of Science East (District) 250052202680 4990305 Hampden Charter School of Science East (District): Hampden Charter School of Science East   Regular School Yes High 06 12 2018   grade_7 40 29 36 0   1     0   3   52 57                       109.0 40 29 36 0   1     0   3   52 57                 109
2238510 2238510 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School (District): Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2018   grade_7 5 19 57 0   1     0   0   32 50                       82.0 5 19 57 0   1     0   0   32 50                 82
2238501 2238501 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District): Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2018   grade_7 32 3 1 0   6     0   8   22 28                       50.0 32 3 1 0   6     0   8   22 28                 50
2238487 2238487 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public (District): Global Learning Charter Public School   Regular School Yes High 05 12 2018   grade_7 45 10 29 0   1     0   7   50 42                       92.0 45 10 29 0   1     0   7   50 42                 92
2238478 2238478 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science (District): Pioneer Charter School of Science   Regular School Yes Other KG 12 2018   grade_7 15 20 27 2   3     0   2   38 31                       69.0 15 20 27 2   3     0   2   38 31                 69
2238454 2238454 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_7 85 7 11 0   3     0   3   56 53                       109.0 85 7 11 0   3     0   3   56 53                 109
2238435 2238435 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public (District): South Shore Charter Public School   Regular School Yes Other KG 12 2018   grade_7 50 18 2 0   3     0   4   39 38                       77.0 50 18 2 0   3     0   4   39 38                 77
2238421 2238421 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District): Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2018   grade_7 7 64 14 0   4     0   4   52 41                       93.0 7 64 14 0   4     0   4   52 41                 93
2238411 2238411 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter Public (District): Seven Hills Charter School   Regular School Yes Elementary KG 08 2018   grade_7 5 25 27 0   0     0   3   29 31                       60.0 5 25 27 0   0     0   3   29 31                 60
2238397 2238397 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter (District): Salem Academy Charter School   Regular School Yes High 06 12 2018   grade_7 36 5 25 0   6     0   1   31 42                       73.0 36 5 25 0   6     0   1   31 42                 73
2238390 2238390 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_7 5 150 86 0   1     1   1   116 128                       244.0 5 150 86 0   1     1   1   116 128                 244
2238381 2238381 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public (District): Rising Tide Charter Public School   Regular School Yes High 05 12 2018   grade_7 80 1 3 1   1     0   5   42 49                       91.0 80 1 3 1   1     0   5   42 49                 91
2238376 2238376 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District): River Valley Charter School   Regular School Yes Elementary KG 08 2018   grade_7 27 1 1 0   0     0   2   11 20                       31.0 27 1 1 0   0     0   2   11 20                 31
2238357 2238357 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston (District): UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2018   grade_7 7 67 82 0   9     0   1   88 78                       166.0 7 67 82 0   9     0   1   88 78                 166
2238349 2238349 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public (District): Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2018   grade_7 48 5 12 0   1     0   2   18 50                       68.0 48 5 12 0   1     0   2   18 50                 68
2238342 2238342 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential (District): Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2018   grade_7 62 1 2 0   0     0   4   33 36                       69.0 62 1 2 0   0     0   4   33 36                 69
2238328 2238328 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2018   grade_7 45 3 22 0   0     0   5   45 30                       75.0 45 3 22 0   0     0   5   45 30                 75
2238321 2238321 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District): Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2018   grade_7 69 17 14 0   26     0   2   67 61                       128.0 69 17 14 0   26     0   2   67 61                 128
2238307 2238307 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District): MATCH Charter Public School   Regular School Yes Other PK 12 2018   grade_7 0 41 48 0   1     0   2   49 43                       92.0 0 41 48 0   1     0   2   49 43                 92
2238289 2238289 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District): Martha's Vineyard Charter School   Regular School Yes Other KG 12 2018   grade_7 12 2 3 0   0     0   2   10 9                       19.0 12 2 3 0   0     0   2   10 9                 19
2238279 2238279 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_7 35 2 1 1   2     0   0   30 11                       41.0 35 2 1 1   2     0   0   30 11                 41
2238273 2238273 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School (District): KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2018   grade_7 0 46 26 0   1     0   1   43 31                       74.0 0 46 26 0   1     0   1   43 31                 74
2238259 2238259 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public (District): Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2018   grade_7 2 25 36 0   17     0   2   39 43                       82.0 2 25 36 0   17     0   2   39 43                 82
2238248 2238248 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public (District): Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2018   grade_7 21 1 6 0   0     0   2   12 18                       30.0 21 1 6 0   0     0   2   12 18                 30
2238238 2238238 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter (District): Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2018   grade_7 0 0 54 0   0     0   0   24 30                       54.0 0 0 54 0   0     0   0   24 30                 54
2238227 2238227 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter (District): Holyoke Community Charter School   Regular School Yes Elementary KG 08 2018   grade_7 3 1 66 0   0     0   2   32 40                       72.0 3 1 66 0   0     0   2   32 40                 72
2238212 2238212 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District): Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2018   grade_7 26 0 1 0   0     0   3   17 13                       30.0 26 0 1 0   0     0   3   17 13                 30
2238198 2238198 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 2018   grade_7 49 24 22 0   1     0   2   53 45                       98.0 49 24 22 0   1     0   2   53 45                 98
2238193 2238193 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 2018   grade_7 25 1 3 0   15     0   1   25 20                       45.0 25 1 3 0   15     0   1   25 20                 45
2238179 2238179 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District): Foxborough Regional Charter School   Regular School Yes Other KG 12 2018   grade_7 54 52 4 1   6     0   11   63 65                       128.0 54 52 4 1   6     0   11   63 65                 128
2238165 2238165 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 2018   grade_7 26 62 25 0   3     0   7   65 58                       123.0 26 62 25 0   3     0   7   65 58                 123

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