enrollments

Data source: Big Local News · About: Big Local

491 rows where grade = "grade_7", state = "MA" and year = 2016 sorted by black_int descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 491 ✖

grade ✖

  • grade_7 · 491 ✖
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
934010 934010 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 North Middle School   Regular School No 2 06 08 2016   grade_7 13 137 30 0   4     1   6   98 93                       191 13 137 30 0   4     1   6   98 93                 191
934016 934016 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No 2 06 08 2016   grade_7 55 124 28 0   5     2   10   113 111                       224 55 124 28 0   5     2   10   113 111                 224
934007 934007 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 East Middle School   Regular School No 2 06 08 2016   grade_7 21 123 24 0   1     2   9   98 82                       180 21 123 24 0   1     2   9   98 82                 180
940647 940647 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 09 2016   grade_7 1 119 114 1   1     1   1   114 124                       238 1 119 114 1   1     1   1   114 124                 238
937992 937992 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No 2 06 08 2016   grade_7 29 113 37 0   41     1   8   123 106                       229 29 113 37 0   41     1   8   123 106                 229
934013 934013 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No 2 06 08 2016   grade_7 48 101 22 1   10     0   9   108 83                       191 48 101 22 1   10     0   9   108 83                 191
934022 934022 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No 2 06 08 2016   grade_7 63 91 51 2   7     0   10   111 113                       224 63 91 51 2   7     0   10   111 113                 224
933633 933633 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No 2 06 08 2016   grade_7 2 89 65 1   11     1   3   97 75                       172 2 89 65 1   11     1   3   97 75                 172
933786 933786 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2016   grade_7 4 80 46 1   3     0   3   67 70                       137 4 80 46 1   3     0   3   67 70                 137
940177 940177 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No 2 06 08 2016   grade_7 82 74 167 1   28     0   23   198 177                       375 82 74 167 1   28     0   23   198 177                 375
933964 933964 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_7 28 70 16 0   0     1   2   58 59                       117 28 70 16 0   0     1   2   58 59                 117
938904 938904 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 O'Donnell Middle School   Regular School No 2 06 08 2016   grade_7 183 67 25 0   15     0   4   146 148                       294 183 67 25 0   15     0   4   146 148                 294
933610 933610 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 1 PK 08 2016   grade_7 1 65 21 1   2     0   0   48 42                       90 1 65 21 1   2     0   0   48 42                 90
934019 934019 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No 2 06 08 2016   grade_7 67 64 11 0   1     0   8   73 78                       151 67 64 11 0   1     0   8   73 78                 151
940285 940285 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes 2 06 08 2016   grade_7 0 64 15 0   0     2   1   44 38                       82 0 64 15 0   0     2   1   44 38                 82
940618 940618 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 2016   grade_7 9 64 50 1   7     0   1   66 66                       132 9 64 50 1   7     0   1   66 66                 132
933286 933286 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No 2 06 08 2016   grade_7 9 62 81 0   11     0   2   84 81                       165 9 62 81 0   11     0   2   84 81                 165
940673 940673 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2016   grade_7 9 62 20 0   12     0   1   57 47                       104 9 62 20 0   12     0   1   57 47                 104
940180 940180 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No 2 06 08 2016   grade_7 114 61 168 1   41     0   15   216 184                       400 114 61 168 1   41     0   15   216 184                 400
938774 938774 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 M Marcus Kiley Middle   Regular School No 2 06 08 2016   grade_7 26 54 119 0   9     0   3   104 107                       211 26 54 119 0   9     0   3   104 107                 211
940174 940174 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No 2 07 08 2016   grade_7 235 53 145 1   33     0   26   255 238                       493 235 53 145 1   33     0   26   255 238                 493
933718 933718 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No 3 07 12 2016   grade_7 91 51 66 0   64     0   7   121 158                       279 91 51 66 0   64     0   7   121 158                 279
936863 936863 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Charles S Pierce Middle   Regular School No 2 06 08 2016   grade_7 207 49 13 1   21     1   9   163 138                       301 207 49 13 1   21     1   9   163 138                 301
937105 937105 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No 2 06 08 2016   grade_7 122 49 101 2   4     2   21   153 148                       301 122 49 101 2   4     2   21   153 148                 301
940172 940172 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No 2 07 08 2016   grade_7 74 49 120 1   8     0   14   127 139                       266 74 49 120 1   8     0   14   127 139                 266
940432 940432 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 2016   grade_7 27 49 34 1   7     0   2   54 66                       120 27 49 34 1   7     0   2   54 66                 120
940249 940249 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 2016   grade_7 3 48 22 0   1     0   1   36 39                       75 3 48 22 0   1     0   1   36 39                 75
938768 938768 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No 2 06 08 2016   grade_7 22 47 141 0   18     0   0   114 114                       228 22 47 141 0   18     0   0   114 114                 228
940269 940269 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2016   grade_7 2 47 17 0   0     0   1   33 34                       67 2 47 17 0   0     0   1   33 34                 67
940536 940536 MA Essex   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes 1 KG 08 2016   grade_7 0 46 22 0   0     0   1   38 31                       69 0 46 22 0   0     0   1   38 31                 69
933659 933659 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No 2 06 08 2016   grade_7 1 45 100 0   0     0   2   86 62                       148 1 45 100 0   0     0   2   86 62                 148
936360 936360 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2016   grade_7 57 45 241 1   40     0   12   216 180                       396 57 45 241 1   40     0   12   216 180                 396
938763 938763 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No 4 06 10 2016   grade_7 35 42 77 0   7     0   1   85 77                       162 35 42 77 0   7     0   1   85 77                 162
940569 940569 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2016   grade_7 2 42 38 2   0     0   1   47 38                       85 2 42 38 2   0     0   1   47 38                 85
940445 940445 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2016   grade_7 47 40 4 0   14     1   6   60 52                       112 47 40 4 0   14     1   6   60 52                 112
933752 933752 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2016   grade_7 30 39 48 2   24     0   3   71 75                       146 30 39 48 2   24     0   3   71 75                 146
940241 940241 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes 4 06 12 2016   grade_7 4 39 20 0   3     0   2   32 36                       68 4 39 20 0   3     0   2   32 36                 68
933320 933320 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No 1 PK 08 2016   grade_7 4 38 22 0   3     0   1   42 26                       68 4 38 22 0   3     0   1   42 26                 68
933656 933656 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No 2 05 08 2016   grade_7 6 38 49 1   1     0   2   57 40                       97 6 38 49 1   1     0   2   57 40                 97
933148 933148 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 11 2016   grade_7 1 36 14 0   0     0   1   28 24                       52 1 36 14 0   0     0   1   28 24                 52
940351 940351 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes 4 06 12 2016   grade_7 3 35 13 0   4     0   0   27 28                       55 3 35 13 0   4     0   0   27 28                 55
936357 936357 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No 2 06 08 2016   grade_7 36 34 233 0   29     0   10   194 148                       342 36 34 233 0   29     0   10   194 148                 342
939045 939045 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Joseph H Martin   Regular School No 2 05 07 2016   grade_7 156 34 32 0   4     0   8   108 126                       234 156 34 32 0   4     0   8   108 126                 234
938780 938780 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No 2 06 08 2016   grade_7 10 31 56 0   0     0   0   61 36                       97 10 31 56 0   0     0   0   61 36                 97
939053 939053 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No 2 05 07 2016   grade_7 90 31 38 0   1     0   4   77 87                       164 90 31 38 0   1     0   4   77 87                 164
940462 940462 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2016   grade_7 40 31 18 1   2     0   2   49 45                       94 40 31 18 1   2     0   2   49 45                 94
934286 934286 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Wm H Galvin Middle   Regular School No 2 06 08 2016   grade_7 186 30 9 0   34     0   14   134 139                       273 186 30 9 0   34     0   14   134 139                 273
937111 937111 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No 2 06 08 2016   grade_7 106 30 102 0   0     0   19   122 135                       257 106 30 102 0   0     0   19   122 135                 257
941987 941987 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes 1 PK 07 2016   grade_7 7 30 19 0   0     0   0   30 26                       56 7 30 19 0   0     0   0   30 26                 56
933084 933084 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2016   grade_7 9 29 24 0   4     0   1   42 25                       67 9 29 24 0   4     0   1   42 25                 67
934253 934253 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No 2 06 08 2016   grade_7 23 29 11 1   11     1   4   30 50                       80 23 29 11 1   11     1   4   30 50                 80
938755 938755 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2016   grade_7 24 29 53 1   0     1   0   61 47                       108 24 29 53 1   0     1   0   61 47                 108
940315 940315 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2016   grade_7 0 29 7 0   1     0   1   18 20                       38 0 29 7 0   1     0   1   18 20                 38
934256 934256 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No 2 06 08 2016   grade_7 30 28 14 0   10     0   5   47 40                       87 30 28 14 0   10     0   5   47 40                 87
940400 940400 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_7 47 28 41 0   5     0   7   60 68                       128 47 28 41 0   5     0   7   60 68                 128
932845 932845 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2016   grade_7 264 27 42 1   3     2   13   203 149                       352 264 27 42 1   3     2   13   203 149                 352
933425 933425 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2016   grade_7 1 27 43 0   2     0   1   39 35                       74 1 27 43 0   2     0   1   39 35                 74
933567 933567 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No 1 PK 07 2016   grade_7 1 27 9 0   0     0   0   16 21                       37 1 27 9 0   0     0   0   16 21                 37
933645 933645 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 04 12 2016   grade_7 9 27 17 0   4     0   1   30 28                       58 9 27 17 0   4     0   1   30 28                 58
934250 934250 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No 2 06 08 2016   grade_7 34 27 11 1   9     1   2   44 41                       85 34 27 11 1   9     1   2   44 41                 85
938771 938771 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No 2 06 08 2016   grade_7 12 27 91 0   0     0   0   63 67                       130 12 27 91 0   0     0   0   63 67                 130
939688 939688 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No 2 05 08 2016   grade_7 355 27 30 2   19     0   15   227 221                       448 355 27 30 2   19     0   15   227 221                 448
940597 940597 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2016   grade_7 0 27 7 0   0     0   0   17 17                       34 0 27 7 0   0     0   0   17 17                 34
933398 933398 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2016   grade_7 12 26 18 0   25     1   6   56 32                       88 12 26 18 0   25     1   6   56 32                 88
933431 933431 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2016   grade_7 9 26 46 0   3     0   7   60 31                       91 9 26 46 0   3     0   7   60 31                 91
937108 937108 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No 2 06 08 2016   grade_7 193 26 101 4   3     2   11   193 147                       340 193 26 101 4   3     2   11   193 147                 340
936449 936449 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No 1 KG 08 2016   grade_7 26 25 26 0   23     0   6   53 53                       106 26 25 26 0   23     0   6   53 53                 106
938802 938802 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Van Sickle Academy   Regular School No 2 06 08 2016   grade_7 10 25 84 0   1     0   0   69 51                       120 10 25 84 0   1     0   0   69 51                 120
934857 934857 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2016   grade_7 21 24 43 0   1     0   2   48 43                       91 21 24 43 0   1     0   2   48 43                 91
936421 936421 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2016   grade_7 29 24 20 1   22     0   5   68 33                       101 29 24 20 1   22     0   5   68 33                 101
937771 937771 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No 2 06 08 2016   grade_7 125 24 23 0   1     0   13   95 91                       186 125 24 23 0   1     0   13   95 91                 186
940320 940320 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2016   grade_7 10 24 79 0   3     0   4   52 68                       120 10 24 79 0   3     0   4   52 68                 120
933620 933620 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2016   grade_7 0 22 24 0   0     0   1   31 16                       47 0 22 24 0   0     0   1   31 16                 47
934259 934259 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No 2 06 08 2016   grade_7 31 22 6 2   10     0   8   47 32                       79 31 22 6 2   10     0   8   47 32                 79
939253 939253 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No 2 06 08 2016   grade_7 99 22 48 0   9     0   2   88 92                       180 99 22 48 0   9     0   2   88 92                 180
940517 940517 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes 1 PK 08 2016   grade_7 4 22 33 0   19     0   2   37 43                       80 4 22 33 0   19     0   2   37 43                 80
941988 941988 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 11 2016   grade_7 26 22 19 1   2     0   2   28 44                       72 26 22 19 1   2     0   2   28 44                 72
932818 932818 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2016   grade_7 34 21 4 1   4     0   2   36 30                       66 34 21 4 1   4     0   2   36 30                 66
933738 933738 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2016   grade_7 191 21 42 2   120     0   15   189 202                       391 191 21 42 2   120     0   15   189 202                 391
936647 936647 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 John J. McGlynn Middle School   Regular School No 2 06 08 2016   grade_7 88 20 25 0   18     0   7   84 74                       158 88 20 25 0   18     0   7   84 74                 158
937240 937240 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No 2 06 08 2016   grade_7 200 20 18 1   32     0   17   144 144                       288 200 20 18 1   32     0   17   144 144                 288
937774 937774 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No 2 06 08 2016   grade_7 147 20 26 1   6     0   9   108 101                       209 147 20 26 1   6     0   9   108 101                 209
940748 940748 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science   Regular School Yes 4 06 12 2016   grade_7 30 20 26 0   3     0   4   46 37                       83 30 20 26 0   3     0   4   46 37                 83
941025 941025 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Mattacheese Middle School   Regular School No 2 06 07 2016   grade_7 155 20 20 10   4     1   14   125 99                       224 155 20 20 10   4     1   14   125 99                 224
933161 933161 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 08 2016   grade_7 5 19 24 0   0     0   3   21 30                       51 5 19 24 0   0     0   3   21 30                 51
933204 933204 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2016   grade_7 5 19 22 0   1     0   0   26 21                       47 5 19 22 0   1     0   0   26 21                 47
933249 933249 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No 1 KG 07 2016   grade_7 0 19 43 0   1     1   0   35 29                       64 0 19 43 0   1     1   0   35 29                 64
933593 933593 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2016   grade_7 0 19 13 0   1     0   3   20 16                       36 0 19 13 0   1     0   3   20 16                 36
934678 934678 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No 2 06 08 2016   grade_7 258 19 23 0   16     0   4   167 153                       320 258 19 23 0   16     0   4   167 153                 320
937551 937551 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Dr. Philip O. Coakley Middle School   Regular School No 2 06 08 2016   grade_7 178 19 23 0   21     0   7   123 125                       248 178 19 23 0   21     0   7   123 125                 248
939056 939056 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Benjamin Friedman Middle   Regular School No 2 05 07 2016   grade_7 192 19 25 1   1     0   12   133 117                       250 192 19 25 1   1     0   12   133 117                 250
939256 939256 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 John W. McDevitt Middle School   Regular School No 2 06 08 2016   grade_7 90 19 73 0   7     0   9   113 85                       198 90 19 73 0   7     0   9   113 85                 198
940413 940413 MA Suffolk   school 2500528 443   Brooke Charter School Mattapan (District) 250052802711 4430205 Brooke Charter School Mattapan   Regular School Yes 1 KG 08 2016   grade_7 0 19 9 0   0     0   2   15 15                       30 0 19 9 0   0     0   2   15 15                 30
940717 940717 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes 3 07 12 2016   grade_7 14 19 32 2   4     1   1   38 35                       73 14 19 32 2   4     1   1   38 35                 73
941967 941967 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes 2 06 09 2016   grade_7 3 19 50 0   1     0   1   36 38                       74 3 19 50 0   1     0   1   36 38                 74
934778 934778 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2016   grade_7 247 18 11 0   9     0   6   134 157                       291 247 18 11 0   9     0   6   134 157                 291
934848 934848 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2016   grade_7 30 18 30 0   8     0   3   40 49                       89 30 18 30 0   8     0   3   40 49                 89
938805 938805 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle International Baccalaureate   Regular School No 2 06 08 2016   grade_7 16 18 100 0   1     0   0   67 68                       135 16 18 100 0   1     0   0   67 68                 135
933101 933101 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No 1 PK 08 2016   grade_7 0 17 55 0   0     0   0   34 38                       72 0 17 55 0   0     0   0   34 38                 72
933583 933583 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2016   grade_7 9 17 40 1   12     0   2   47 34                       81 9 17 40 1   12     0   2   47 34                 81

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