Data source: Big Local News · About: Big Local

493 rows where grade = "grade_7", state = "MA" and year = 2015 sorted by rowid descending

View and edit SQL

year

  • 2015 · 493

grade

  • grade_7 · 493
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
745193 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2015   grade_7 21 2 4 0   0     0   3   16 14                       30 21 2 4 0   0     0   3   16 14                 30
745180 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No 4 KG 12 2015   grade_7 45 6 14 0   2     0   5   37 35                       72 45 6 14 0   2     0   5   37 35                 72
745164 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes 4 07 10 2015   grade_7 22 28 11 0   7     0   2   34 36                       70 22 28 11 0   7     0   2   34 36                 70
745147 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes 2 06 08 2015   grade_7 7 30 41 0   1     0   0   38 41                       79 7 30 41 0   1     0   0   38 41                 79
745020 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No 2 06 08 2015   grade_7 135 3 3 0   2     0   5   79 69                       148 135 3 3 0   2     0   5   79 69                 148
745017 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000207 7800310 Whitman Middle   Regular School No 2 06 08 2015   grade_7 162 7 2 0   5     2   3   92 89                       181 162 7 2 0   5     2   3   92 89                 181
744991 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No 2 07 08 2015   grade_7 87 3 4 0   1     0   0   55 40                       95 87 3 4 0   1     0   0   55 40                 95
744968 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No 2 05 08 2015   grade_7 103 0 4 0   4     0   0   61 50                       111 103 0 4 0   4     0   0   61 50                 111
744964 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No 2 06 08 2015   grade_7 117 1 8 0   1     0   2   66 63                       129 117 1 8 0   1     0   2   66 63                 129
744961 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Mountview Middle   Regular School No 2 06 08 2015   grade_7 199 6 14 0   7     0   10   122 114                       236 199 6 14 0   7     0   10   122 114                 236
744955 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No 1 KG 08 2015   grade_7 48 0 0 0   0     0   2   25 25                       50 48 0 0 0   0     0   2   25 25                 50
744946 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2015   grade_7 60 3 3 0   2     0   0   32 36                       68 60 3 3 0   2     0   0   32 36                 68
744910 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2015   grade_7 35 0 0 1   1     0   1   24 14                       38 35 0 0 1   1     0   1   24 14                 38
744889 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton Regional Middle School   Regular School No 2 07 08 2015   grade_7 222 5 7 0   3     0   1   125 113                       238 222 5 7 0   3     0   1   125 113                 238
744854 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua Regional Jr High   Regular School No 2 07 08 2015   grade_7 252 2 16 1   3     0   8   132 150                       282 252 2 16 1   3     0   8   132 150                 282
744847 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Junior High   Regular School No 2 06 08 2015   grade_7 99 2 13 0   1     0   1   77 39                       116 99 2 13 0   1     0   1   77 39                 116
744825 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301781 7660305 Powder Mill   Regular School No 2 05 08 2015   grade_7 118 2 2 0   1     0   0   73 50                       123 118 2 2 0   1     0   0   73 50                 123
744821 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_7 14 0 0 0   0     0   0   8 6                       14 14 0 0 0   0     0   0   8 6                 14
744802 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No 3 07 12 2015   grade_7 46 0 7 0   0     0   2   29 26                       55 46 0 7 0   0     0   2   29 26                 55
744774 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake Regional Middle School   Regular School No 2 06 08 2015   grade_7 298 5 2 0   5     1   2   157 156                       313 298 5 2 0   5     1   2   157 156                 313
744763 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No 3 07 12 2015   grade_7 101 7 7 1   1     0   8   71 54                       125 101 7 7 1   1     0   8   71 54                 125
744755 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No 2 07 08 2015   grade_7 188 1 4 0   2     0   5   102 98                       200 188 1 4 0   2     0   5   102 98                 200
744720 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No 3 07 12 2015   grade_7 71 0 0 0   0     0   2   35 38                       73 71 0 0 0   0     0   2   35 38                 73
744685 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket Regional Middle   Regular School No 2 07 08 2015   grade_7 243 0 5 0   2     0   1   143 108                       251 243 0 5 0   2     0   1   143 108                 251
744655 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No 2 07 08 2015   grade_7 205 5 5 0   4     0   4   116 107                       223 205 5 5 0   4     0   4   116 107                 223
744647 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No 2 05 08 2015   grade_7 133 2 9 1   1     0   2   79 69                       148 133 2 9 1   1     0   2   79 69                 148
744638 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No 2 05 08 2015   grade_7 127 1 8 0   0     0   4   66 74                       140 127 1 8 0   0     0   4   66 74                 140
744605 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No 2 06 08 2015   grade_7 85 0 2 0   3     0   2   45 47                       92 85 0 2 0   3     0   2   45 47                 92
744602 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No 2 06 08 2015   grade_7 71 2 1 0   1     0   1   38 38                       76 71 2 1 0   1     0   1   38 38                 76
744599 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2015   grade_7 77 0 3 0   3     0   2   41 44                       85 77 0 3 0   3     0   2   41 44                 85
744571 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2015   grade_7 109 1 2 0   0     0   1   51 62                       113 109 1 2 0   0     0   1   51 62                 113
744552 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No 3 07 12 2015   grade_7 60 0 3 0   1     0   2   30 36                       66 60 0 3 0   1     0   2   30 36                 66
744515 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No 3 07 12 2015   grade_7 90 0 3 0   1     1   2   51 46                       97 90 0 3 0   1     1   2   51 46                 97
744508 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No 2 05 07 2015   grade_7 116 10 6 1   5     0   5   75 68                       143 116 10 6 1   5     0   5   75 68                 143
744481 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No 2 05 08 2015   grade_7 191 2 4 0   3     0   5   99 106                       205 191 2 4 0   3     0   5   99 106                 205
744466 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet Regional Middle School   Regular School No 2 07 08 2015   grade_7 306 0 8 1   5     0   7   162 165                       327 306 0 8 1   5     0   7   162 165                 327
744455 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No 2 06 08 2015   grade_7 120 0 2 0   2     0   0   55 69                       124 120 0 2 0   2     0   0   55 69                 124
744434 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No 2 07 08 2015   grade_7 384 2 16 0   7     0   11   218 202                       420 384 2 16 0   7     0   11   218 202                 420
744414 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2015   grade_7 133 0 3 0   0     0   4   69 71                       140 133 0 3 0   0     0   4   69 71                 140
744408 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No 2 06 08 2015   grade_7 142 3 5 0   10     0   6   76 90                       166 142 3 5 0   10     0   6   76 90                 166
744405 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002547 6800305 Thornton Burgess   Regular School No 2 05 08 2015   grade_7 69 0 2 0   2     0   5   43 35                       78 69 0 2 0   2     0   5   43 35                 78
744384 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No 2 06 08 2015   grade_7 133 0 2 0   4     0   0   56 83                       139 133 0 2 0   4     0   0   56 83                 139
744357 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Great Falls Middle   Regular School No 2 06 08 2015   grade_7 76 1 5 0   0     0   3   49 36                       85 76 1 5 0   0     0   3   49 36                 85
744335 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No 2 05 08 2015   grade_7 194 2 1 0   9     1   0   106 101                       207 194 2 1 0   9     1   0   106 101                 207
744313 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway Regional Junior High School   Regular School No 2 07 08 2015   grade_7 79 0 3 0   0     0   3   33 52                       85 79 0 3 0   0     0   3   33 52                 85
744294 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No 3 07 12 2015   grade_7 102 1 6 0   5     0   3   69 48                       117 102 1 6 0   5     0   3   69 48                 117
744288 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No 2 06 08 2015   grade_7 248 3 1 0   3     1   2   151 107                       258 248 3 1 0   3     1   2   151 107                 258
744260 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No 2 06 08 2015   grade_7 168 8 1 1   8     0   6   90 102                       192 168 8 1 1   8     0   6   90 102                 192
744253 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No 2 05 08 2015   grade_7 168 4 10 0   3     0   2   89 98                       187 168 4 10 0   3     0   2   89 98                 187
744249 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No 2 05 08 2015   grade_7 146 6 12 2   1     0   2   94 75                       169 146 6 12 2   1     0   2   94 75                 169
744229 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No 2 06 08 2015   grade_7 150 4 9 0   10     0   8   90 91                       181 150 4 9 0   10     0   8   90 91                 181
744221 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No 2 05 08 2015   grade_7 128 2 6 0   3     0   2   75 66                       141 128 2 6 0   3     0   2   75 66                 141
744217 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No 2 05 08 2015   grade_7 85 1 3 0   3     0   1   47 46                       93 85 1 3 0   3     0   1   47 46                 93
744199 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No 2 06 07 2015   grade_7 174 19 18 4   7     0   13   102 133                       235 174 19 18 4   7     0   13   102 133                 235
744171 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No 2 06 08 2015   grade_7 121 0 6 0   0     0   2   73 56                       129 121 0 6 0   0     0   2   73 56                 129
744127 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No 2 07 08 2015   grade_7 228 6 3 0   2     0   2   122 119                       241 228 6 3 0   2     0   2   122 119                 241
744125 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No 2 05 08 2015   grade_7 152 5 4 0   5     1   7   92 82                       174 152 5 4 0   5     1   7   92 82                 174
744103 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No 2 06 08 2015   grade_7 140 0 8 0   1     0   1   69 81                       150 140 0 8 0   1     0   1   69 81                 150
744083 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2015   grade_7 78 2 4 0   0     0   0   48 36                       84 78 2 4 0   0     0   0   48 36                 84
744075 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2015   grade_7 93 2 7 0   1     1   1   55 50                       105 93 2 7 0   1     1   1   55 50                 105
744061 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No 2 06 08 2015   grade_7 93 10 12 0   3     0   5   68 55                       123 93 10 12 0   3     0   5   68 55                 123
744039 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2015   grade_7 99 2 10 0   1     0   0   57 55                       112 99 2 10 0   1     0   0   57 55                 112
744012 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No 2 06 08 2015   grade_7 178 3 3 0   2     0   3   99 90                       189 178 3 3 0   2     0   3   99 90                 189
743991 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No 2 07 08 2015   grade_7 138 11 31 1   21     1   18   110 111                       221 138 11 31 1   21     1   18   110 111                 221
743985 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_7 105 6 2 0   0     0   0   54 59                       113 105 6 2 0   0     0   0   54 59                 113
743965 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No 2 07 08 2015   grade_7 262 7 10 2   131     0   16   220 208                       428 262 7 10 2   131     0   16   220 208                 428
743915 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science   Regular School Yes 4 06 12 2015   grade_7 30 12 15 0   1     0   2   37 23                       60 30 12 15 0   1     0   2   37 23                 60
743913 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes 2 05 07 2015   grade_7 4 17 47 0   1     0   7   37 39                       76 4 17 47 0   1     0   7   37 39                 76
743907 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter(District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes 4 KG 10 2015   grade_7 6 1 0 0   7     0   1   4 11                       15 6 1 0 0   7     0   1   4 11                 15
743894 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2015   grade_7 48 10 28 0   1     0   1   39 49                       88 48 10 28 0   1     0   1   39 49                 88
743886 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes 3 07 12 2015   grade_7 18 21 16 3   10     0   1   40 29                       69 18 21 16 3   10     0   1   40 29                 69
743873 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_7 80 5 8 0   1     0   6   36 64                       100 80 5 8 0   1     0   6   36 64                 100
743856 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes 4 KG 12 2015   grade_7 30 12 0 0   2     0   1   23 22                       45 30 12 0 0   2     0   1   23 22                 45
743843 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2015   grade_7 9 50 23 1   10     0   1   45 49                       94 9 50 23 1   10     0   1   45 49                 94
743834 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes 1 KG 08 2015   grade_7 7 23 26 0   1     0   1   31 27                       58 7 23 26 0   1     0   1   31 27                 58
743821 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2015   grade_7 39 5 22 0   3     0   0   34 35                       69 39 5 22 0   3     0   0   34 35                 69
743818 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 08 2015   grade_7 5 135 90 0   2     0   3   108 127                       235 5 135 90 0   2     0   3   108 127                 235
743810 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2015   grade_7 80 0 1 1   3     0   3   38 50                       88 80 0 1 1   3     0   3   38 50                 88
743806 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes 1 KG 08 2015   grade_7 30 0 1 0   1     0   0   14 18                       32 30 0 1 0   1     0   0   14 18                 32
743789 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes 2 06 08 2015   grade_7 15 66 46 1   9     0   2   62 77                       139 15 66 46 1   9     0   2   62 77                 139
743782 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes 3 07 12 2015   grade_7 47 5 10 0   2     0   3   20 47                       67 47 5 10 0   2     0   3   20 47                 67
743776 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes 3 07 12 2015   grade_7 66 0 3 0   1     0   1   39 32                       71 66 0 3 0   1     0   1   39 32                 71
743768 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2015   grade_7 0 29 7 0   0     2   0   19 19                       38 0 29 7 0   0     2   0   19 19                 38
743759 MA Worcester   school 2500073 474   The Sizer School: A North Central Charter Essential (District) 250007301750 4740505 The Sizer School: A North Central Charter Essential School   Regular School Yes 3 07 12 2015   grade_7 58 5 6 0   1     0   1   38 33                       71 58 5 6 0   1     0   1   38 33                 71
743753 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2015   grade_7 76 17 6 2   14     0   6   47 74                       121 76 17 6 2   14     0   6   47 74                 121
743740 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2015   grade_7 3 40 40 0   0     0   1   49 35                       84 3 40 40 0   0     0   1   49 35                 84
743721 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2015   grade_7 11 1 0 0   0     0   2   7 7                       14 11 1 0 0   0     0   2   7 7                 14
743712 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes 2 04 08 2015   grade_7 37 1 0 0   2     0   0   17 23                       40 37 1 0 0   2     0   0   17 23                 40
743708 MA Essex   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes 2 05 07 2015   grade_7 0 49 23 0   0     0   0   41 31                       72 0 49 23 0   0     0   0   41 31                 72
743700 MA Suffolk   school 2500539 457   Brooke Charter School East Boston (District) 250053902720 4570205 Brooke Charter School East Boston   Regular School Yes 1 KG 07 2015   grade_7 2 9 22 0   2     0   1   16 20                       36 2 9 22 0   2     0   1   16 20                 36
743693 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes 1 PK 07 2015   grade_7 4 21 25 0   21     0   1   28 44                       72 4 21 25 0   21     0   1   28 44                 72
743683 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes 1 KG 08 2015   grade_7 26 0 7 0   0     0   0   11 22                       33 26 0 7 0   0     0   0   11 22                 33
743674 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 KG 08 2015   grade_7 0 0 62 0   0     0   0   27 35                       62 0 0 62 0   0     0   0   27 35                 62
743665 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes 1 KG 08 2015   grade_7 10 0 80 0   0     0   3   42 51                       93 10 0 80 0   0     0   3   42 51                 93
743652 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2015   grade_7 15 0 2 0   1     0   2   10 10                       20 15 0 2 0   1     0   2   10 10                 20
743639 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2015   grade_7 39 29 21 2   2     0   2   48 47                       95 39 29 21 2   2     0   2   48 47                 95
743635 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2015   grade_7 41 1 1 0   5     0   1   25 24                       49 41 1 1 0   5     0   1   25 24                 49
743622 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2015   grade_7 58 31 8 0   10     0   5   50 62                       112 58 31 8 0   10     0   5   50 62                 112
743609 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_7 38 23 47 0   5     0   4   59 58                       117 38 23 47 0   5     0   4   59 58                 117
743600 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2015   grade_7 3 27 6 0   0     0   2   16 22                       38 3 27 6 0   0     0   2   16 22                 38

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