Data source: Big Local News · About: Big Local

496 rows where grade = "grade_7", state = "MA" and year = 2021 sorted by rowid descending

View and edit SQL

year

  • 2021 · 496

grade

  • grade_7 · 496
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
1681538 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 2021   grade_7 159 15 40 0   11     1   15   109 132 *                     241.0 159 15 40 0   11     1   15   109 132                 241
1681525 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_7 63 6 17 0   7     0   8   54 46 1                     101.0 63 6 17 0   7     0   8   54 46 1               101
1681506 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West (District) - Hampden Charter School of Science West   Regular School Yes Secondary 06 11 2021   grade_7 30 15 25 0   1     0   0   34 37 *                     71.0 30 15 25 0   1     0   0   34 37                 71
1681496 MA Hampden   school 2500586 3514   Libertas Charter School (District) 250058602878 35140305 Libertas Academy Charter School (District) - Libertas Academy Charter School   Regular School Yes Middle 06 08 2021   grade_7 0 9 74 0   1     0   2   37 49 *                     86.0 0 9 74 0   1     0   2   37 49                 86
1681489 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 High 06 12 2021   grade_7 1 105 9 0   1     0   6   60 62 *                     122.0 1 105 9 0   1     0   6   60 62                 122
1681475 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_7 49 15 40 0   3     0   2   53 56 *                     109.0 49 15 40 0   3     0   2   53 56                 109
1681465 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 2021   grade_7 10 23 15 1   12     0   3   38 26 *                     64.0 10 23 15 1   12     0   3   38 26                 64
1681463 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 2021   grade_7 1 36 29 0   0     1   1   39 29 *                     68.0 1 36 29 0   0     1   1   39 29                 68
1681451 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 Other KG 09 2021   grade_7 16 27 48 0   25     0   5   53 68 *                     121.0 16 27 48 0   25     0   5   53 68                 121
1681438 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_7 31 30 12 0   0     1   5   36 43 *                     79.0 31 30 12 0   0     1   5   36 43                 79
1681313 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson - Hanson Middle School   Regular School No Middle 05 08 2021   grade_7 104 0 7 0   1     0   4   58 58 *                     116.0 104 0 7 0   1     0   4   58 58                 116
1681309 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman-Hanson - Whitman Middle   Regular School No Middle 06 08 2021   grade_7 161 8 12 2   2     0   8   98 95 *                     193.0 161 8 12 2   2     0   8   98 95                 193
1681284 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional - Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2021   grade_7 81 0 5 0   0     0   2   44 44 *                     88.0 81 0 5 0   0     0   2   44 44                 88
1681261 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Wachusett - Chocksett Middle School   Regular School No Middle 05 08 2021   grade_7 74 1 6 0   0     0   2   46 37 *                     83.0 74 1 6 0   0     0   2   46 37                 83
1681257 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Wachusett - Central Tree Middle   Regular School No Middle 06 08 2021   grade_7 89 3 9 0   3     0   5   55 54 *                     109.0 89 3 9 0   3     0   5   55 54                 109
1681254 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Wachusett - Mountview Middle   Regular School No Middle 06 08 2021   grade_7 199 12 17 0   8     0   10   126 120 *                     246.0 199 12 17 0   8     0   10   126 120                 246
1681248 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett - Thomas Prince   Regular School No Elementary KG 08 2021   grade_7 37 2 0 0   2     0   3   25 19 *                     44.0 37 2 0 0   2     0   3   25 19                 44
1681239 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Wachusett - Paxton Center   Regular School No Elementary KG 08 2021   grade_7 51 1 9 0   5     0   3   35 34 *                     69.0 51 1 9 0   5     0   3   35 34                 69
1681203 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional - West Tisbury Elementary   Regular School No Elementary PK 08 2021   grade_7 41 1 3 1   0     0   5   23 27 *                     51.0 41 1 3 1   0     0   5   23 27                 51
1681183 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton - Triton Regional Middle School   Regular School No Middle 07 08 2021   grade_7 152 2 7 0   6     1   2   84 86 *                     170.0 152 2 7 0   6     1   2   84 86                 170
1681149 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua - Tantasqua Regional Jr High   Regular School No Middle 07 08 2021   grade_7 261 7 18 1   4     0   8   156 143 *                     299.0 261 7 18 1   4     0   8   156 143                 299
1681142 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield - Knox Trail Middle School   Regular School No Middle 05 08 2021   grade_7 99 4 17 0   2     0   6   66 62 *                     128.0 99 4 17 0   2     0   6   66 62                 128
1681121 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 2021   grade_7 104 6 6 0   2     0   4   56 66 *                     122.0 104 6 6 0   2     0   4   56 66                 122
1681107 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Southern Berkshire - Mt Everett Regional   Regular School No High 06 12 2021   grade_7 31 0 2 0   0     0   2   22 13 *                     35.0 31 0 2 0   0     0   2   22 13                 35
1681080 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake - Silver Lake Regional Middle School   Regular School No Middle 07 08 2021   grade_7 246 0 9 2   3     0   4   128 135 *                     264.0 246 0 9 2   3     0   4   128 135                 264
1681074 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar - Ralph C Mahar Regional   Regular School No High 07 12 2021   grade_7 112 0 10 0   4     0   1   63 64 *                     127.0 112 0 10 0   4     0   1   63 64                 127
1681067 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin - Quabbin Regional Middle School   Regular School No Middle 06 08 2021   grade_7 165 0 12 0   1     1   2   93 88 *                     181.0 165 0 12 0   1     1   2   93 88                 181
1681034 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley - Pioneer Valley Regional   Regular School No High 07 12 2021   grade_7 53 1 0 0   1     0   2   28 29 *                     57.0 53 1 0 0   1     0   2   28 29                 57
1681012 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket - Pentucket Regional Middle   Regular School No Middle 07 08 2021   grade_7 132 0 9 1   2     0   1   73 72 *                     145.0 132 0 9 1   2     0   1   73 72                 145
1680981 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester - Old Rochester Regional Jr High   Regular School No Middle 07 08 2021   grade_7 184 2 2 0   2     0   13   117 86 *                     203.0 184 2 2 0   2     0   13   117 86                 203
1680974 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 North Middlesex - Nissitissit Middle School   Regular School No Middle 05 08 2021   grade_7 103 2 5 0   1     0   8   65 54 *                     119.0 103 2 5 0   1     0   8   65 54                 119
1680965 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex - Hawthorne Brook   Regular School No Middle 05 08 2021   grade_7 122 0 4 0   3     0   4   72 61 *                     133.0 122 0 4 0   3     0   4   72 61                 133
1680929 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Nashoba - Hale   Regular School No Middle 06 08 2021   grade_7 85 1 2 0   3     0   5   53 43 *                     96.0 85 1 2 0   3     0   5   53 43                 96
1680926 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Nashoba - Luther Burbank Middle School   Regular School No Middle 06 08 2021   grade_7 58 1 13 0   0     0   2   39 35 *                     74.0 58 1 13 0   0     0   2   39 35                 74
1680923 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Nashoba - Florence Sawyer School   Regular School No Elementary PK 08 2021   grade_7 68 1 2 0   0     0   6   38 39 *                     77.0 68 1 2 0   0     0   6   38 39                 77
1680895 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett - Narragansett Middle   Regular School No Middle 05 08 2021   grade_7 106 0 7 1   2     0   7   66 57 *                     123.0 106 0 7 1   2     0   7   66 57                 123
1680880 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail - Mohawk Trail Regional School   Regular School No High 07 12 2021   grade_7 50 0 4 0   0     0   1   28 27 *                     55.0 50 0 4 0   0     0   1   28 27                 55
1680850 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mount Greylock - Mt Greylock Regional High   Regular School No High 07 12 2021   grade_7 68 2 6 0   0     0   1   41 36 *                     77.0 68 2 6 0   0     0   1   41 36                 77
1680828 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 2021   grade_7 100 9 13 2   3     0   13   64 76 *                     140.0 100 9 13 2   3     0   13   64 76                 140
1680802 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Mendon-Upton - Miscoe Hill School   Regular School No Middle 05 08 2021   grade_7 172 0 11 0   7     0   5   109 86 *                     195.0 172 0 11 0   7     0   5   109 86                 195
1680788 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet - Masconomet Regional Middle School   Regular School No Middle 07 08 2021   grade_7 274 3 11 0   9     1   16   149 165 *                     314.0 274 3 11 0   9     1   16   149 165                 314
1680777 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional - Manchester Essex Regional Middle School   Regular School No Middle 06 08 2021   grade_7 112 0 1 0   0     0   0   59 54 *                     113.0 112 0 1 0   0     0   0   59 54                 113
1680756 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip - King Philip Middle School   Regular School No Middle 07 08 2021   grade_7 330 6 27 1   7     0   14   205 180 *                     385.0 330 6 27 1   7     0   14   205 180                 385
1680736 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire - Hampshire Regional High   Regular School No High 07 12 2021   grade_7 119 0 3 1   3     0   2   54 74 *                     128.0 119 0 3 1   3     0   2   54 74                 128
1680730 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Hampden-Wilbraham - Wilbraham Middle   Regular School No Middle 06 08 2021   grade_7 166 6 19 0   3     0   7   99 102 *                     201.0 166 6 19 0   3     0   7   99 102                 201
1680720 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Hampden-Wilbraham - Green Meadows Elementary   Regular School No Elementary PK 08 2021   grade_7 9 1 3 0   0     0   2   12 3 *                     15.0 9 1 3 0   0     0   2   12 3                 15
1680706 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Hamilton-Wenham - Miles River Middle   Regular School No Middle 06 08 2021   grade_7 119 0 3 0   4     0   1   69 58 *                     127.0 119 0 3 0   4     0   1   69 58                 127
1680679 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Gill-Montague - Great Falls Middle   Regular School No Middle 06 08 2021   grade_7 62 1 11 0   0     1   7   47 35 *                     82.0 62 1 11 0   0     1   7   47 35                 82
1680657 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton-Dunstable - Groton Dunstable Regional Middle   Regular School No Middle 05 08 2021   grade_7 149 3 7 0   9     0   4   85 87 *                     172.0 149 3 7 0   9     0   4   85 87                 172
1680637 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway - Gateway Regional Middle School   Regular School No Middle 06 08 2021   grade_7 59 1 8 0   0     1   0   34 35 *                     69.0 59 1 8 0   0     1   0   34 35                 69
1680616 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier - Frontier Regional   Regular School No High 07 12 2021   grade_7 90 2 13 0   2     0   7   67 47 *                     114.0 90 2 13 0   2     0   7   67 47                 114
1680610 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville - Freetown-Lakeville Middle School   Regular School No Middle 06 09 2021   grade_7 220 4 0 0   2     0   3   118 111 *                     229.0 220 4 0 0   2     0   3   118 111                 229
1680583 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset - Nauset Regional Middle   Regular School No Middle 06 08 2021   grade_7 159 8 12 0   4     0   7   99 90 *                     190.0 159 8 12 0   4     0   7   99 90                 190
1680575 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Dudley-Charlton Reg - Charlton Middle School   Regular School No Middle 05 08 2021   grade_7 161 1 15 1   3     0   3   93 91 *                     184.0 161 1 15 1   3     0   3   93 91                 184
1680571 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley-Charlton Reg - Dudley Middle School   Regular School No Middle 05 08 2021   grade_7 116 6 15 1   1     0   6   63 82 *                     145.0 116 6 15 1   1     0   6   63 82                 145
1680550 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn - Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2021   grade_7 120 6 14 0   29     0   18   96 91 *                     187.0 120 6 14 0   29     0   18   96 91                 187
1680542 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth - Dorothy L Beckwith   Regular School No Middle 05 08 2021   grade_7 116 1 7 1   2     0   4   63 68 *                     131.0 116 1 7 1   2     0   4   63 68                 131
1680538 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton-Rehoboth - Dighton Middle School   Regular School No Middle 05 08 2021   grade_7 88 2 4 0   1     0   5   59 41 *                     100.0 88 2 4 0   1     0   5   59 41                 100
1680518 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth - Mattacheese Middle School   Regular School No Middle 06 07 2021   grade_7 131 31 45 7   4     1   13   122 110 *                     232.0 131 31 45 7   4     1   13   122 110                 232
1680489 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Central Berkshire - Nessacus Regional Middle School   Regular School No Middle 06 08 2021   grade_7 110 0 3 1   0     0   1   59 56 *                     115.0 110 0 3 1   0     0   1   59 56                 115
1680450 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater-Raynham - Bridgewater Middle School   Regular School No Middle 07 08 2021   grade_7 211 22 8 0   7     0   7   128 127 *                     255.0 211 22 8 0   7     0   7   128 127                 255
1680448 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham - Raynham Middle School   Regular School No Middle 05 08 2021   grade_7 149 16 1 0   5     0   5   94 82 *                     176.0 149 16 1 0   5     0   5   94 82                 176
1680427 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Blackstone-Millville - Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2021   grade_7 109 3 11 0   2     0   7   61 71 *                     132.0 109 3 11 0   2     0   7   61 71                 132
1680407 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Berlin-Boylston - Tahanto Regional High   Regular School No High 06 12 2021   grade_7 77 1 6 0   5     1   2   45 47 *                     92.0 77 1 6 0   5     1   2   45 47                 92
1680386 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills - W.E.B. Du Bois Regional Middle School   Regular School No Middle 05 08 2021   grade_7 73 0 10 0   3     0   4   47 43 *                     90.0 73 0 10 0   3     0   4   47 43                 90
1680372 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_7 98 7 23 1   4     0   4   72 65 *                     137.0 98 7 23 1   4     0   4   72 65                 137
1680351 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston - Athol-Royalston Middle School   Regular School No Middle 05 08 2021   grade_7 92 3 15 0   1     0   5   71 45 *                     116.0 92 3 15 0   1     0   5   71 45                 116
1680329 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Ashburnham-Westminster - Overlook Middle School   Regular School No Middle 06 08 2021   grade_7 160 4 15 0   0     0   10   99 90 *                     189.0 160 4 15 0   0     0   10   99 90                 189
1680308 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst-Pelham - Amherst Regional Middle School   Regular School No Middle 07 08 2021   grade_7 119 18 44 0   14     0   15   101 109 *                     210.0 119 18 44 0   14     0   15   101 109                 210
1680302 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Regional - Hoosac Valley Middle School   Regular School No Middle 04 07 2021   grade_7 100 3 2 0   0     0   2   55 52 *                     107.0 100 3 2 0   0     0   2   55 52                 107
1680287 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Acton-Boxborough - Raymond J Grey Junior High   Regular School No Middle 07 08 2021   grade_7 214 14 25 1   139     1   16   203 207 *                     410.0 214 14 25 1   139     1   16   203 207                 410
1680238 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science East (District) - Hampden Charter School of Science East   Regular School Yes High 06 12 2021   grade_7 21 26 31 0   2     0   5   41 44 *                     85.0 21 26 31 0   2     0   5   41 44                 85
1680235 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 2021   grade_7 4 26 85 1   3     0   2   58 63 *                     121.0 4 26 85 1   3     0   2   58 63                 121
1680227 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 2021   grade_7 18 11 9 0   11     0   6   30 25 *                     55.0 18 11 9 0   11     0   6   30 25                 55
1680214 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 2021   grade_7 36 9 40 0   2     0   4   48 43 *                     91.0 36 9 40 0   2     0   4   48 43                 91
1680206 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 2021   grade_7 30 16 14 0   3     0   1   24 40 *                     64.0 30 16 14 0   3     0   1   24 40                 64
1680184 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_7 91 1 16 0   2     0   0   52 58 *                     110.0 91 1 16 0   2     0   0   52 58                 110
1680167 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 2021   grade_7 36 33 3 0   4     0   8   47 37 *                     84.0 36 33 3 0   4     0   8   47 37                 84
1680154 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 2021   grade_7 4 62 24 0   4     2   4   49 51 *                     100.0 4 62 24 0   4     2   4   49 51                 100
1680145 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Learning First Charter Public School (District) - Learning First Charter Public School   Regular School Yes Elementary KG 08 2021   grade_7 5 40 25 0   0     0   0   37 33 *                     70.0 5 40 25 0   0     0   0   37 33                 70
1680132 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 2021   grade_7 28 5 38 0   1     0   1   29 43 *                     73.0 28 5 38 0   1     0   1   29 43                 73
1680125 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District) - Roxbury Preparatory Charter School   Regular School Yes High 05 12 2021   grade_7 2 147 111 1   0     1   2   142 122 *                     264.0 2 147 111 1   0     1   2   142 122                 264
1680117 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 2021   grade_7 77 0 5 0   1     0   7   41 49 *                     90.0 77 0 5 0   1     0   7   41 49                 90
1680113 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 2021   grade_7 28 1 2 1   0     0   0   10 22 *                     32.0 28 1 2 1   0     0   0   10 22                 32
1680096 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 2021   grade_7 5 50 56 0   7     0   0   67 51 *                     118.0 5 50 56 0   7     0   0   67 51                 118
1680089 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 2021   grade_7 51 4 14 0   0     0   3   24 48 *                     72.0 51 4 14 0   0     0   3   24 48                 72
1680083 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 2021   grade_7 54 3 5 0   2     0   0   28 36 *                     64.0 54 3 5 0   2     0   0   28 36                 64
1680077 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 2021   grade_7 35 6 22 1   2     0   2   37 31 *                     68.0 35 6 22 1   2     0   2   37 31                 68
1680071 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 2021   grade_7 64 34 8 0   36     0   7   79 70 *                     149.0 64 34 8 0   36     0   7   79 70                 149
1680058 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 2021   grade_7 4 47 41 0   0     0   4   49 47 *                     96.0 4 47 41 0   0     0   4   49 47                 96
1680042 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 2021   grade_7 11 0 2 0   0     0   1   4 10 *                     14.0 11 0 2 0   0     0   1   4 10                 14
1680033 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_7 25 1 5 0   0     0   1   20 12 *                     32.0 25 1 5 0   0     0   1   20 12                 32
1680028 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 2021   grade_7 0 46 12 0   0     0   0   28 30 *                     58.0 0 46 12 0   0     0   0   28 30                 58
1680015 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 2021   grade_7 3 18 37 0   15     0   3   39 37 *                     76.0 3 18 37 0   15     0   3   39 37                 76
1680005 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 2021   grade_7 27 0 4 0   0     0   1   14 18 *                     32.0 27 0 4 0   0     0   1   14 18                 32
1679996 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 2021   grade_7 1 0 74 0   0     0   0   42 33 *                     75.0 1 0 74 0   0     0   0   42 33                 75
1679986 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 2021   grade_7 1 2 67 0   1     0   2   32 41 *                     73.0 1 2 67 0   1     0   2   32 41                 73
1679973 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 2021   grade_7 24 0 0 0   2     0   5   15 16 *                     31.0 24 0 0 0   2     0   5   15 16                 31
1679960 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_7 36 36 25 0   5     0   4   53 53 *                     106.0 36 36 25 0   5     0   4   53 53                 106
1679956 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_7 31 1 5 0   11     0   4   30 22 *                     52.0 31 1 5 0   11     0   4   30 22                 52

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