enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 393 ✖

grade ✖

  • grade_7 · 393 ✖
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
744802 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
744821 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
744955 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
745193 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
735681 735681 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_7 108 1 1 0   1     0   0   55 56                       111 108 1 1 0   1     0   0   55 56                 111
736338 736338 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2015   grade_7 5 19 19 0   1     0   2   21 25                       46 5 19 19 0   1     0   2   21 25                 46
736468 736468 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No 1 PK 08 2015   grade_7 8 4 8 0   1     0   0   10 11                       21 8 4 8 0   1     0   0   10 11                 21
736556 736556 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_7 1 33 43 0   1     1   2   27 54                       81 1 33 43 0   1     1   2   27 54                 81
736958 736958 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_7 0 5 5 0   1     0   0   5 6                       11 0 5 5 0   1     0   0   5 6                 11
737317 737317 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2015   grade_7 11 3 12 0   1     0   3   14 16                       30 11 3 12 0   1     0   3   14 16                 30
737617 737617 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_7 87 7 31 1   1     0   2   73 56                       129 87 7 31 1   1     0   2   73 56                 129
737839 737839 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No 2 06 08 2015   grade_7 258 1 4 0   1     0   3   136 131                       267 258 1 4 0   1     0   3   136 131                 267
737853 737853 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2015   grade_7 177 8 3 0   1     0   6   83 112                       195 177 8 3 0   1     0   6   83 112                 195
738121 738121 MA Bristol   school 2504830 95   Fall River 250483002838 950335 Resiliency Middle School   Regular School No 2 07 08 2015   grade_7 11 4 4 0   1     0   1   16 5                       21 11 4 4 0   1     0   1   16 5                 21
738590 738590 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2015   grade_7 109 4 15 0   1     0   0   63 66                       129 109 4 15 0   1     0   0   63 66                 129
738595 738595 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2015   grade_7 82 6 44 0   1     0   1   63 71                       134 82 6 44 0   1     0   1   63 71                 134
738620 738620 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2015   grade_7 79 5 34 1   1     0   3   73 50                       123 79 5 34 1   1     0   3   73 50                 123
738716 738716 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2015   grade_7 11 1 22 0   1     0   1   20 16                       36 11 1 22 0   1     0   1   20 16                 36
738731 738731 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2015   grade_7 3 1 58 0   1     0   0   42 21                       63 3 1 58 0   1     0   0   42 21                 63
738844 738844 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No 2 06 08 2015   grade_7 81 2 0 0   1     0   1   43 42                       85 81 2 0 0   1     0   1   43 42                 85
739034 739034 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No 3 07 12 2015   grade_7 46 0 4 0   1     0   0   25 26                       51 46 0 4 0   1     0   0   25 26                 51
739062 739062 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2015   grade_7 53 0 6 0   1     0   1   29 32                       61 53 0 6 0   1     0   1   29 32                 61
739097 739097 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No 2 06 08 2015   grade_7 104 7 41 0   1     0   5   75 83                       158 104 7 41 0   1     0   5   75 83                 158
739527 739527 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No 3 07 12 2015   grade_7 1 0 4 0   1     0   1   2 5                       7 1 0 4 0   1     0   1   2 5                 7
740270 740270 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2015   grade_7 212 29 97 1   1     2   16   183 175                       358 212 29 97 1   1     2   16   183 175                 358
740623 740623 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No 3 07 12 2015   grade_7 47 0 2 0   1     0   1   28 23                       51 47 0 2 0   1     0   1   28 23                 51
740737 740737 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   grade_7 28 1 3 0   1     0   6   15 24                       39 28 1 3 0   1     0   6   15 24                 39
740765 740765 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No 2 05 08 2015   grade_7 123 0 17 0   1     0   3   67 77                       144 123 0 17 0   1     0   3   67 77                 144
741653 741653 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No 1 KG 08 2015   grade_7 13 3 43 0   1     0   0   26 34                       60 13 3 43 0   1     0   0   26 34                 60
741963 741963 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No 2 06 08 2015   grade_7 28 34 133 0   1     0   5   101 100                       201 28 34 133 0   1     0   5   101 100                 201
742664 742664 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2015   grade_7 91 3 0 0   1     0   5   47 53                       100 91 3 0 0   1     0   5   47 53                 100
742793 742793 MA Bristol   school 2512780 331   Westport 251278002094 3310305 Westport Middle   Regular School No 2 06 08 2015   grade_7 119 0 4 2   1     0   4   70 60                       130 119 0 4 2   1     0   4   70 60                 130
743032 743032 MA Suffolk   school 2513170 346   Winthrop 251317001841 3460020 Arthur T. Cummings Elementary School   Regular School No 2 04 07 2015   grade_7 138 6 10 0   1     0   0   69 86                       155 138 6 10 0   1     0   0   69 86                 155
743428 743428 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes 4 05 12 2015   grade_7 12 48 14 0   1     0   2   38 39                       77 12 48 14 0   1     0   2   38 39                 77
743434 743434 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes 3 07 12 2015   grade_7 33 0 1 0   1     0   2   16 21                       37 33 0 1 0   1     0   2   16 21                 37
743441 743441 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_7 49 10 2 0   1     0   2   35 29                       64 49 10 2 0   1     0   2   35 29                 64
743652 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
743759 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
743776 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
743806 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
743834 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
743873 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
743894 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
743913 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
743915 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
744039 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
744075 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
744103 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
744249 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
744515 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
744552 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
744602 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
744647 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
744763 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
744825 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
744847 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
744910 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
744964 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
744991 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
745147 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
735666 735666 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No 2 07 08 2015   grade_7 146 2 4 0   2     0   2   77 79                       156 146 2 4 0   2     0   2   77 79                 156
735728 735728 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2015   grade_7 174 4 7 0   2     0   5   94 98                       192 174 4 7 0   2     0   5   94 98                 192
736000 736000 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Jabish Middle School   Regular School No 2 07 08 2015   grade_7 181 0 10 0   2     0   2   103 92                       195 181 0 10 0   2     0   2   103 92                 195
736215 736215 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2015   grade_7 4 27 24 0   2     0   3   29 31                       60 4 27 24 0   2     0   3   29 31                 60
736562 736562 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_7 7 31 48 0   2     0   2   56 34                       90 7 31 48 0   2     0   2   56 34                 90
737150 737150 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No 2 06 08 2015   grade_7 18 133 19 1   2     1   9   106 77                       183 18 133 19 1   2     1   9   106 77                 183
737518 737518 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2015   grade_7 10 19 122 1   2     0   0   83 71                       154 10 19 122 1   2     0   0   83 71                 154
737585 737585 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2015   grade_7 155 9 131 0   2     0   5   156 146                       302 155 9 131 0   2     0   5   156 146                 302
738005 738005 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2015   grade_7 22 23 45 1   2     0   2   40 55                       95 22 23 45 1   2     0   2   40 55                 95
738484 738484 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No 2 04 07 2015   grade_7 71 2 18 0   2     0   5   55 43                       98 71 2 18 0   2     0   5   55 43                 98
738767 738767 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No 1 KG 08 2015   grade_7 7 4 47 0   2     0   0   33 27                       60 7 4 47 0   2     0   0   33 27                 60
738829 738829 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No 2 05 07 2015   grade_7 215 5 15 1   2     0   5   129 114                       243 215 5 15 1   2     0   5   129 114                 243
738865 738865 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No 2 06 08 2015   grade_7 151 0 7 0   2     0   5   80 85                       165 151 0 7 0   2     0   5   80 85                 165
738930 738930 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No 2 05 08 2015   grade_7 8 2 121 0   2     0   0   72 61                       133 8 2 121 0   2     0   0   72 61                 133
739180 739180 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No 1 PK 08 2015   grade_7 43 7 6 0   2     0   6   35 29                       64 43 7 6 0   2     0   6   35 29                 64
739185 739185 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No 2 04 08 2015   grade_7 22 6 8 0   2     1   1   17 23                       40 22 6 8 0   2     1   1   17 23                 40
739195 739195 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No 2 06 08 2015   grade_7 123 1 2 0   2     0   3   58 73                       131 123 1 2 0   2     0   3   58 73                 131
739373 739373 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No 2 06 08 2015   grade_7 169 3 17 0   2     0   7   97 101                       198 169 3 17 0   2     0   7   97 101                 198
739388 739388 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2015   grade_7 106 4 2 0   2     0   0   63 51                       114 106 4 2 0   2     0   0   63 51                 114
739984 739984 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No 2 05 08 2015   grade_7 106 2 7 0   2     0   1   60 58                       118 106 2 7 0   2     0   1   60 58                 118
740267 740267 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2015   grade_7 117 56 95 3   2     2   17   158 134                       292 117 56 95 3   2     2   17   158 134                 292
740273 740273 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2015   grade_7 123 31 93 1   2     2   10   136 126                       262 123 31 93 1   2     2   10   136 126                 262
740608 740608 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No 2 05 08 2015   grade_7 159 0 11 0   2     0   7   93 86                       179 159 0 11 0   2     0   7   93 86                 179
740780 740780 MA Hampden   school 2509300 227   Palmer 250930002595 2270305 Converse Middle   Regular School No 2 05 07 2015   grade_7 107 4 5 0   2     0   0   73 45                       118 107 4 5 0   2     0   0   73 45                 118
740943 740943 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No 2 06 08 2015   grade_7 117 20 17 0   2     0   11   93 74                       167 117 20 17 0   2     0   11   93 74                 167
741015 741015 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No 2 05 08 2015   grade_7 217 2 4 0   2     0   7   119 113                       232 217 2 4 0   2     0   7   119 113                 232
741317 741317 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No 2 06 08 2015   grade_7 75 1 2 0   2     0   0   39 41                       80 75 1 2 0   2     0   0   39 41                 80
741624 741624 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No 1 PK 08 2015   grade_7 23 14 24 0   2     0   1   33 31                       64 23 14 24 0   2     0   1   33 31                 64
741732 741732 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No 2 05 08 2015   grade_7 118 2 7 0   2     0   9   63 75                       138 118 2 7 0   2     0   9   63 75                 138
741975 741975 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No 2 06 08 2015   grade_7 20 23 46 0   2     0   4   52 43                       95 20 23 46 0   2     0   4   52 43                 95
742197 742197 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No 2 06 08 2015   grade_7 160 1 6 1   2     0   2   85 87                       172 160 1 6 1   2     0   2   85 87                 172
742236 742236 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No 2 05 07 2015   grade_7 180 24 14 0   2     0   7   122 105                       227 180 24 14 0   2     0   7   122 105                 227
742463 742463 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No 3 07 12 2015   grade_7 88 2 11 0   2     0   1   46 58                       104 88 2 11 0   2     0   1   46 58                 104
742714 742714 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 North Middle School   Regular School No 2 06 08 2015   grade_7 197 4 22 0   2     0   9   116 118                       234 197 4 22 0   2     0   9   116 118                 234
743418 743418 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 08 2015   grade_7 19 12 131 0   2     0   3   85 82                       167 19 12 131 0   2     0   3   85 82                 167
743500 743500 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_7 13 34 69 0   2     0   2   61 59                       120 13 34 69 0   2     0   2   61 59                 120
743519 743519 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2015   grade_7 70 3 2 0   2     0   3   41 39                       80 70 3 2 0   2     0   3   41 39                 80
743590 743590 MA Suffolk   school 2500528 443   Brooke Charter School Mattapan (District) 250052802711 4430205 Brooke Charter School Mattapan   Regular School Yes 1 KG 08 2015   grade_7 0 21 11 0   2     0   0   16 18                       34 0 21 11 0   2     0   0   16 18                 34
743639 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
743700 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

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