enrollments

Data source: Big Local News · About: Big Local

497 rows where grade = "grade_7", state = "MA" and year = 2017 sorted by hispanic

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 497 ✖

grade ✖

  • grade_7 · 497 ✖
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
1122005 1122005 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_7 * * * *   *     *   *   2 1                       *                         2 1                  
1122638 1122638 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2017   grade_7 * * * *   *     *   *   1 2                       *                         1 2                  
1123668 1123668 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_7 * * * *   *     *   *   4 1                       *                         4 1                  
1124658 1124658 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_7 * * * *   *     *   *   2 2                       *                         2 2                  
1125193 1125193 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_7 * * * *   *     *   *   * *                       *                                              
1125267 1125267 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_7 * * * *   *     *   *   * *                       *                                              
1125425 1125425 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_7 * * * *   *     *   *   2 1                       *                         2 1                  
1129009 1129009 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_7 * * * *   *     *   *   3 *                       *                         3                    
1131924 1131924 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_7 * * * *   *     *   *   1 *                       *                         1                    
1124927 1124927 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_7 11 0 0 0   0     0   0   6 5                       11 11 0 0 0   0     0   0   6 5                 11
1125371 1125371 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2017   grade_7 41 0 0 0   3     0   2   19 27                       46 41 0 0 0   3     0   2   19 27                 46
1125704 1125704 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2017   grade_7 61 0 0 0   1     0   1   35 28                       63 61 0 0 0   1     0   1   35 28                 63
1127568 1127568 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary KG 07 2017   grade_7 24 0 0 0   0     0   1   11 14                       25 24 0 0 0   0     0   1   11 14                 25
1128361 1128361 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2017   grade_7 66 2 0 0   82     1   9   80 80                       160 66 2 0 0   82     1   9   80 80                 160
1128788 1128788 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Intermediate School   Regular School No Middle 07 08 2017   grade_7 243 9 0 0   6     0   3   126 135                       261 243 9 0 0   6     0   3   126 135                 261
1131361 1131361 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2017   grade_7 30 4 0 0   15     0   1   23 27                       50 30 4 0 0   15     0   1   23 27                 50
1131446 1131446 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Elementary 04 08 2017   grade_7 41 1 0 0   1     0   1   24 20                       44 41 1 0 0   1     0   1   24 20                 44
1131543 1131543 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2017   grade_7 29 0 0 0   0     0   2   10 21                       31 29 0 0 0   0     0   2   10 21                 31
1131548 1131548 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes Other 05 12 2017   grade_7 81 1 0 0   3     0   4   50 39                       89 81 1 0 0   3     0   4   50 39                 89
1132376 1132376 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2017   grade_7 84 0 0 0   1     0   5   42 48                       90 84 0 0 0   1     0   5   42 48                 90
1132614 1132614 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2017   grade_7 67 0 0 0   0     0   5   41 31                       72 67 0 0 0   0     0   5   41 31                 72
1124214 1124214 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_7 16 0 1 0   1     0   1   10 9                       19 16 0 1 0   1     0   1   10 9                 19
1125131 1125131 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2017   grade_7 112 1 1 0   2     0   1   66 51                       117 112 1 1 0   2     0   1   66 51                 117
1127103 1127103 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2017   grade_7 91 1 1 0   0     2   3   51 47                       98 91 1 1 0   0     2   3   51 47                 98
1127410 1127410 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2017   grade_7 155 2 1 0   1     0   4   98 65                       163 155 2 1 0   1     0   4   98 65                 163
1128468 1128468 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2017   grade_7 136 5 1 0   9     0   1   85 67                       152 136 5 1 0   9     0   1   85 67                 152
1128555 1128555 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_7 20 0 1 0   0     0   0   7 14                       21 20 0 1 0   0     0   0   7 14                 21
1128604 1128604 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No Middle 06 08 2017   grade_7 74 1 1 0   1     0   1   46 32                       78 74 1 1 0   1     0   1   46 32                 78
1128700 1128700 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2017   grade_7 218 4 1 2   3     0   1   122 107                       229 218 4 1 2   3     0   1   122 107                 229
1129582 1129582 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2017   grade_7 120 0 1 0   1     0   4   61 65                       126 120 0 1 0   1     0   4   61 65                 126
1130298 1130298 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2017   grade_7 144 2 1 2   63     1   1   116 98                       214 144 2 1 2   63     1   1   116 98                 214
1131134 1131134 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2017   grade_7 33 1 1 0   0     0   1   18 18                       36 33 1 1 0   0     0   1   18 18                 36
1131244 1131244 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes Other 05 12 2017   grade_7 84 4 1 0   9     0   2   47 53                       100 84 4 1 0   9     0   2   47 53                 100
1131456 1131456 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_7 10 2 1 0   0     0   1   5 9                       14 10 2 1 0   0     0   1   5 9                 14
1131601 1131601 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2017   grade_7 45 14 1 0   2     0   3   38 27                       65 45 14 1 0   2     0   3   38 27                 65
1131664 1131664 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2017   grade_7 32 1 1 0   10     0   5   23 26                       49 32 1 1 0   10     0   5   23 26                 49
1131758 1131758 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   grade_7 104 6 1 0   1     0   0   58 54                       112 104 6 1 0   1     0   0   58 54                 112
1132416 1132416 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional High   Regular School No High 07 12 2017   grade_7 72 1 1 0   0     0   2   37 39                       76 72 1 1 0   0     0   2   37 39                 76
1132713 1132713 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 07 12 2017   grade_7 42 1 1 0   0     0   2   27 19                       46 42 1 1 0   0     0   2   27 19                 46
1132832 1132832 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_7 38 1 1 3   1     0   2   33 13                       46 38 1 1 3   1     0   2   33 13                 46
1132902 1132902 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2017   grade_7 87 3 1 0   1     0   0   48 44                       92 87 3 1 0   1     0   0   48 44                 92
1122032 1122032 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_7 160 0 10 0   2     0   6   96 82                       178 160 0 10 0   2     0   6   96 82                 178
1122116 1122116 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2017   grade_7 88 3 10 0   39     0   3   76 67                       143 88 3 10 0   39     0   3   76 67                 143
1123550 1123550 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 South Middle School   Regular School No Middle 06 08 2017   grade_7 170 4 10 0   37     0   1   105 117                       222 170 4 10 0   37     0   1   105 117                 222
1123795 1123795 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2017   grade_7 53 2 10 0   16     0   5   40 46                       86 53 2 10 0   16     0   5   40 46                 86
1125884 1125884 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_7 2 1 10 0   0     0   0   11 2                       13 2 1 10 0   0     0   0   11 2                 13
1126548 1126548 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2017   grade_7 24 13 10 0   37     0   1   35 50                       85 24 13 10 0   37     0   1   35 50                 85
1126609 1126609 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2017   grade_7 267 9 10 0   18     0   14   162 156                       318 267 9 10 0   18     0   14   162 156                 318
1127973 1127973 MA Hampden   school 2509300 227   Palmer 250930002595 2270305 Converse Middle   Regular School No Middle 06 07 2017   grade_7 102 4 10 0   1     0   2   67 52                       119 102 4 10 0   1     0   2   67 52                 119
1128812 1128812 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2017   grade_7 150 3 10 0   6     0   5   89 85                       174 150 3 10 0   6     0   5   89 85                 174
1128994 1128994 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2017   grade_7 26 9 10 0   3     0   3   27 24                       51 26 9 10 0   3     0   3   27 24                 51
1130445 1130445 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2017   grade_7 203 10 10 0   34     0   5   121 141                       262 203 10 10 0   34     0   5   121 141                 262
1131840 1131840 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2017   grade_7 88 5 10 1   2     1   6   52 61                       113 88 5 10 1   2     1   6   52 61                 113
1131857 1131857 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2017   grade_7 104 1 10 1   1     0   2   42 77                       119 104 1 10 1   1     0   2   42 77                 119
1132761 1132761 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_7 82 0 10 0   1     0   4   52 45                       97 82 0 10 0   1     0   4   52 45                 97
1129339 1129339 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No Other 06 11 2017   grade_7 29 43 101 0   4     0   2   104 75                       179 29 43 101 0   4     0   2   104 75                 179
1127373 1127373 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2017   grade_7 124 43 104 2   4     0   19   165 131                       296 124 43 104 2   4     0   19   165 131                 296
1128530 1128530 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2017   grade_7 47 4 104 0   10     0   4   84 85                       169 47 4 104 0   10     0   4   84 85                 169
1127381 1127381 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2017   grade_7 103 43 109 1   2     1   12   141 130                       271 103 43 109 1   2     1   12   141 130                 271
1129350 1129350 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No Middle 06 08 2017   grade_7 14 24 109 0   1     0   2   79 71                       150 14 24 109 0   1     0   2   79 71                 150
1123161 1123161 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2017   grade_7 0 15 11 0   0     1   1   17 11                       28 0 15 11 0   0     1   1   17 11                 28
1123743 1123743 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No Elementary KG 08 2017   grade_7 37 4 11 0   14     0   6   48 24                       72 37 4 11 0   14     0   6   48 24                 72
1123871 1123871 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   grade_7 8 1 11 0   1     0   4   13 12                       25 8 1 11 0   1     0   4   13 12                 25
1124062 1124062 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2017   grade_7 133 3 11 0   34     0   0   88 93                       181 133 3 11 0   34     0   0   88 93                 181
1124276 1124276 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2017   grade_7 198 11 11 1   14     0   14   103 146                       249 198 11 11 1   14     0   14   103 146                 249
1125487 1125487 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2017   grade_7 340 4 11 0   8     1   11   195 180                       375 340 4 11 0   8     1   11   195 180                 375
1125505 1125505 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No High 07 12 2017   grade_7 69 21 11 0   5     0   9   60 55                       115 69 21 11 0   5     0   9   60 55                 115
1126057 1126057 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2017   grade_7 158 19 11 0   119     0   10   171 146                       317 158 19 11 0   119     0   10   171 146                 317
1126568 1126568 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2017   grade_7 23 9 11 0   3     0   5   21 30                       51 23 9 11 0   3     0   5   21 30                 51
1127956 1127956 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2017   grade_7 111 4 11 1   1     2   7   60 77                       137 111 4 11 1   1     2   7   60 77                 137
1129358 1129358 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2017   grade_7 1 4 11 0   0     0   0   12 4                       16 1 4 11 0   0     0   0   12 4                 16
1131287 1131287 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2017   grade_7 3 27 11 0   0     0   0   20 21                       41 3 27 11 0   0     0   0   20 21                 41
1132337 1132337 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2017   grade_7 183 2 11 0   5     0   0   104 97                       201 183 2 11 0   5     0   0   104 97                 201
1124101 1124101 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2017   grade_7 6 7 112 1   3     0   2   70 61                       131 6 7 112 1   3     0   2   70 61                 131
1125830 1125830 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2017   grade_7 2 2 113 0   0     0   0   71 46                       117 2 2 113 0   0     0   0   71 46                 117
1124111 1124111 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2017   grade_7 5 9 115 0   4     0   0   67 66                       133 5 9 115 0   4     0   0   67 66                 133
1125860 1125860 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2017   grade_7 6 1 116 0   0     0   0   63 60                       123 6 1 116 0   0     0   0   63 60                 123
1124106 1124106 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_7 1 2 117 0   2     0   1   65 58                       123 1 2 117 0   2     0   1   65 58                 123
1131557 1131557 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_7 0 125 117 0   2     0   2   117 129                       246 0 125 117 0   2     0   2   117 129                 246
1122686 1122686 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   grade_7 0 40 12 0   0     0   0   24 28                       52 0 40 12 0   0     0   0   24 28                 52
1123122 1123122 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2017   grade_7 7 5 12 0   2     0   0   18 8                       26 7 5 12 0   2     0   0   18 8                 26
1123621 1123621 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_7 14 70 12 2   0     0   2   52 48                       100 14 70 12 2   0     0   2   52 48                 100
1123733 1123733 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2017   grade_7 50 3 12 0   14     1   11   43 48                       91 50 3 12 0   14     1   11   43 48                 91
1123846 1123846 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Marshall Simonds Middle   Regular School No Middle 06 08 2017   grade_7 198 18 12 2   31     0   12   147 126                       273 198 18 12 2   31     0   12   147 126                 273
1124950 1124950 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2017   grade_7 185 8 12 2   4     0   3   113 101                       214 185 8 12 2   4     0   3   113 101                 214
1126638 1126638 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2017   grade_7 220 7 12 0   1     0   6   118 128                       246 220 7 12 0   1     0   6   118 128                 246
1126979 1126979 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 John T. Nichols Middle   Regular School No Middle 06 08 2017   grade_7 233 3 12 1   2     0   6   126 131                       257 233 3 12 1   2     0   6   126 131                 257
1127030 1127030 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2017   grade_7 112 5 12 0   5     0   6   71 69                       140 112 5 12 0   5     0   6   71 69                 140
1127174 1127174 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Wilson Middle   Regular School No Middle 05 08 2017   grade_7 180 9 12 1   9     0   14   112 113                       225 180 9 12 1   9     0   14   112 113                 225
1127538 1127538 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2017   grade_7 110 11 12 0   37     0   19   88 101                       189 110 11 12 0   37     0   19   88 101                 189
1129466 1129466 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No Middle 05 08 2017   grade_7 145 1 12 0   7     0   6   90 81                       171 145 1 12 0   7     0   6   90 81                 171
1129834 1129834 MA Middlesex   school 2511910 305   Wakefield 251191000776 3050310 Galvin Middle School   Regular School No Middle 05 08 2017   grade_7 252 9 12 0   11     0   6   140 150                       290 252 9 12 0   11     0   6   140 150                 290
1130723 1130723 MA Middlesex   school 2513200 347   Woburn 251320002182 3470410 Daniel L Joyce Middle School   Regular School No Middle 06 08 2017   grade_7 146 10 12 2   10     1   5   93 93                       186 146 10 12 2   10     1   5   93 93                 186
1132254 1132254 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No Middle 06 08 2017   grade_7 172 5 12 0   4     0   7   96 104                       200 172 5 12 0   4     0   7   96 104                 200
1132655 1132655 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2017   grade_7 190 0 12 0   1     0   5   106 102                       208 190 0 12 0   1     0   5   106 102                 208
1132769 1132769 MA Worcester   school 2511490 770   Tantasqua 251149001899 7700405 Tantasqua Regional Jr High   Regular School No Middle 07 08 2017   grade_7 262 2 12 0   5     0   12   142 151                       293 262 2 12 0   5     0   12   142 151                 293
1133164 1133164 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   grade_7 78 4 12 1   2     1   4   52 50                       102 78 4 12 1   2     1   4   52 50                 102
1133189 1133189 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 Other KG 12 2017   grade_7 44 11 12 0   2     1   2   40 32                       72 44 11 12 0   2     1   2   40 32                 72
1131031 1131031 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2017   grade_7 105 31 120 0   14     0   25   161 134                       295 105 31 120 0   14     0   25   161 134                 295
1125808 1125808 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2017   grade_7 1 2 125 0   2     0   0   57 73                       130 1 2 125 0   2     0   0   57 73                 130

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