enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 465 ✖

grade ✖

  • grade_7 · 465 ✖
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
736278 736278 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 10 2015   grade_7 1 42 14 0   0     0   5   30 32                       62 1 42 14 0   0     0   5   30 32                 62
736441 736441 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No 1 PK 08 2015   grade_7 1 0 17 0   0     0   0   9 9                       18 1 0 17 0   0     0   0   9 9                 18
736451 736451 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No 1 PK 08 2015   grade_7 1 40 15 0   4     0   4   41 23                       64 1 40 15 0   4     0   4   41 23                 64
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
736637 736637 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2015   grade_7 1 12 13 1   0     0   0   20 7                       27 1 12 13 1   0     0   0   20 7                 27
736725 736725 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_7 1 14 7 0   0     0   1   12 11                       23 1 14 7 0   0     0   1   12 11                 23
738913 738913 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2015   grade_7 1 0 133 0   0     0   0   69 65                       134 1 0 133 0   0     0   0   69 65                 134
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
743452 743452 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2015   grade_7 1 38 19 0   0     0   0   26 32                       58 1 38 19 0   0     0   0   26 32                 58
743530 743530 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes 4 06 12 2015   grade_7 1 31 11 0   0     1   5   20 29                       49 1 31 11 0   0     1   5   20 29                 49
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
741990 741990 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No 2 06 08 2015   grade_7 10 10 48 0   3     0   0   27 44                       71 10 10 48 0   3     0   0   27 44                 71
743665 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
742553 742553 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett Jr Sr High School   Regular School No 3 07 12 2015   grade_7 100 6 21 0   4     0   11   75 67                       142 100 6 21 0   4     0   11   75 67                 142
739725 739725 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2015   grade_7 101 6 4 5   5     0   6   66 61                       127 101 6 4 5   5     0   6   66 61                 127
739800 739800 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No 2 06 08 2015   grade_7 101 19 10 0   9     0   6   68 77                       145 101 19 10 0   9     0   6   68 77                 145
743507 743507 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2015   grade_7 101 5 3 0   30     0   8   85 62                       147 101 5 3 0   30     0   8   85 62                 147
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
744294 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
739878 739878 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2015   grade_7 103 2 19 0   5     1   3   69 64                       133 103 2 19 0   5     1   3   69 64                 133
744968 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
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
743363 743363 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No 2 07 08 2015   grade_7 105 59 108 2   9     0   6   132 157                       289 105 59 108 2   9     0   6   132 157                 289
743985 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
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
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
741380 741380 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No 2 06 08 2015   grade_7 107 9 78 0   6     0   9   110 99                       209 107 9 78 0   6     0   9   110 99                 209
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
740398 740398 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No 2 06 08 2015   grade_7 108 18 12 0   22     0   8   75 93                       168 108 18 12 0   22     0   8   75 93                 168
735902 735902 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2015   grade_7 109 2 25 2   6     1   6   72 79                       151 109 2 25 2   6     1   6   72 79                 151
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
744571 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
736417 736417 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No 2 06 08 2015   grade_7 11 76 90 0   17     0   5   112 87                       199 11 76 90 0   17     0   5   112 87                 199
737126 737126 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_7 11 60 9 0   4     0   2   50 36                       86 11 60 9 0   4     0   2   50 36                 86
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
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
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
738934 738934 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No 2 05 08 2015   grade_7 11 4 120 0   0     0   0   75 60                       135 11 4 120 0   0     0   0   75 60                 135
743721 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
742152 742152 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No 2 06 08 2015   grade_7 112 1 1 0   0     0   3   48 69                       117 112 1 1 0   0     0   3   48 69                 117
738294 738294 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2015   grade_7 113 9 75 0   18     1   9   118 107                       225 113 9 75 0   18     1   9   118 107                 225
739224 739224 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No 2 06 08 2015   grade_7 114 3 2 0   15     0   4   69 69                       138 114 3 2 0   15     0   4   69 69                 138
742399 742399 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No 2 06 08 2015   grade_7 115 2 2 1   8     0   1   62 67                       129 115 2 2 1   8     0   1   62 67                 129
744508 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
737633 737633 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_7 117 7 3 0   6     0   0   62 71                       133 117 7 3 0   6     0   0   62 71                 133
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
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
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
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
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
738288 738288 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No 2 06 08 2015   grade_7 119 6 30 0   3     0   5   79 84                       163 119 6 30 0   3     0   5   79 84                 163
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
741356 741356 MA Essex   school 2510380 258   Salem 251038002559 2580025 Nathaniel Bowditch   Regular School No 1 KG 08 2015   grade_7 12 2 37 0   0     0   0   23 28                       51 12 2 37 0   0     0   0   23 28                 51
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
744455 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
738381 738381 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No 2 06 08 2015   grade_7 121 0 2 0   0     0   4   67 60                       127 121 0 2 0   0     0   4   67 60                 127
742515 742515 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No 2 06 08 2015   grade_7 121 4 19 3   9     0   9   76 89                       165 121 4 19 3   9     0   9   76 89                 165
744171 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
739048 739048 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No 2 06 08 2015   grade_7 122 2 6 0   3     0   4   71 66                       137 122 2 6 0   3     0   4   71 66                 137
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
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
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
742778 742778 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No 2 06 08 2015   grade_7 124 12 3 2   25     0   4   93 77                       170 124 12 3 2   25     0   4   93 77                 170
738106 738106 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No 2 06 08 2015   grade_7 125 16 53 2   16     0   13   116 109                       225 125 16 53 2   16     0   13   116 109                 225
742177 742177 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott Middle   Regular School No 2 05 08 2015   grade_7 125 5 25 0   4     0   1   70 90                       160 125 5 25 0   4     0   1   70 90                 160
742322 742322 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 McCloskey Middle School   Regular School No 2 06 08 2015   grade_7 125 1 4 2   3     0   7   82 60                       142 125 1 4 2   3     0   7   82 60                 142
743464 743464 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes 2 06 08 2015   grade_7 125 1 6 0   5     0   1   67 71                       138 125 1 6 0   5     0   1   67 71                 138
741703 741703 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No 2 06 08 2015   grade_7 126 2 8 0   18     1   5   83 77                       160 126 2 8 0   18     1   5   83 77                 160
735985 735985 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No 2 06 08 2015   grade_7 127 14 9 0   21     0   6   87 90                       177 127 14 9 0   21     0   6   87 90                 177
744638 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
737450 737450 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_7 128 1 0 0   0     0   0   67 62                       129 128 1 0 0   0     0   0   67 62                 129
739161 739161 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2015   grade_7 128 14 6 0   94     0   15   128 129                       257 128 14 6 0   94     0   15   128 129                 257
744221 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
739969 739969 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2015   grade_7 129 0 11 0   0     0   2   64 78                       142 129 0 11 0   0     0   2   64 78                 142
741118 741118 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No 2 06 08 2015   grade_7 129 9 3 0   72     0   3   97 119                       216 129 9 3 0   72     0   3   97 119                 216
736920 736920 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2015   grade_7 13 7 109 1   4     0   2   79 57                       136 13 7 109 1   4     0   2   79 57                 136
738758 738758 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2015   grade_7 13 0 46 0   0     0   3   29 33                       62 13 0 46 0   0     0   3   29 33                 62
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
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
738629 738629 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_7 131 9 81 1   5     0   1   111 117                       228 131 9 81 1   5     0   1   111 117                 228
740483 740483 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 John F Kennedy Middle School   Regular School No 2 06 08 2015   grade_7 132 4 41 2   4     0   9   95 97                       192 132 4 41 2   4     0   9   95 97                 192
742311 742311 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No 2 06 08 2015   grade_7 132 0 6 0   12     0   8   76 82                       158 132 0 6 0   12     0   8   76 82                 158
744384 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
744414 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
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
735898 735898 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2015   grade_7 134 9 11 0   8     0   4   94 72                       166 134 9 11 0   8     0   4   94 72                 166
743093 743093 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No 2 06 08 2015   grade_7 135 13 16 0   9     1   6   87 93                       180 135 13 16 0   9     1   6   87 93                 180
745020 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
735864 735864 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No 2 06 08 2015   grade_7 136 6 28 2   18     0   4   97 97                       194 136 6 28 2   18     0   4   97 97                 194
738344 738344 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No 2 06 08 2015   grade_7 136 0 2 1   8     0   5   76 76                       152 136 0 2 1   8     0   5   76 76                 152
742396 742396 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No 2 06 08 2015   grade_7 136 11 16 0   6     0   4   86 87                       173 136 11 16 0   6     0   4   86 87                 173
737480 737480 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No 2 05 08 2015   grade_7 137 3 7 0   16     0   3   73 93                       166 137 3 7 0   16     0   3   73 93                 166
740407 740407 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No 2 06 08 2015   grade_7 137 20 11 0   27     0   13   120 88                       208 137 20 11 0   27     0   13   120 88                 208
738026 738026 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No 2 06 08 2015   grade_7 138 1 6 0   3     0   1   78 71                       149 138 1 6 0   3     0   1   78 71                 149
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
743991 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
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
737782 737782 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2015   grade_7 140 0 2 0   3     1   4   65 85                       150 140 0 2 0   3     1   4   65 85                 150
741202 741202 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No 2 06 08 2015   grade_7 140 5 1 0   7     0   4   88 69                       157 140 5 1 0   7     0   4   88 69                 157

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