enrollments

Data source: Big Local News · About: Big Local

3,459 rows where grade = "grade_8" and state = "MA"

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 3,359 ✖
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
737485 737485 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No 2 05 08 2015   grade_8 185 9 5 0   17     0   4   123 97                       220 185 9 5 0   17     0   4   123 97                 220
737511 737511 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2015   grade_8 18 13 97 0   3     0   1   58 74                       132 18 13 97 0   3     0   1   58 74                 132
737515 737515 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2015   grade_8 9 4 126 0   1     0   1   75 66                       141 9 4 126 0   1     0   1   75 66                 141
737519 737519 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2015   grade_8 9 15 130 0   3     0   0   88 69                       157 9 15 130 0   3     0   0   88 69                 157
737549 737549 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_8 4 0 8 0   0     0   0   9 3                       12 4 0 8 0   0     0   0   9 3                 12
737586 737586 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No 2 06 08 2015   grade_8 151 6 98 1   7     0   6   124 145                       269 151 6 98 1   7     0   6   124 145                 269
737589 737589 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Fairview Middle   Regular School No 2 06 08 2015   grade_8 161 5 68 0   6     0   7   137 110                       247 161 5 68 0   6     0   7   137 110                 247
737608 737608 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   grade_8 24 0 1 0   0     0   1   12 14                       26 24 0 1 0   0     0   1   12 14                 26
737618 737618 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2015   grade_8 97 4 31 0   4     0   0   61 75                       136 97 4 31 0   4     0   0   61 75                 136
737634 737634 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_8 126 4 1 0   2     0   0   61 72                       133 126 4 1 0   2     0   0   61 72                 133
737661 737661 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No 2 06 08 2015   grade_8 185 10 14 0   20     0   12   111 130                       241 185 10 14 0   20     0   12   111 130                 241
737703 737703 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No 2 06 08 2015   grade_8 257 6 17 0   9     2   5   155 141                       296 257 6 17 0   9     2   5   155 141                 296
737730 737730 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No 2 06 08 2015   grade_8 311 5 7 1   9     0   4   181 156                       337 311 5 7 1   9     0   4   181 156                 337
737761 737761 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No 2 06 08 2015   grade_8 159 18 24 1   9     0   6   116 101                       217 159 18 24 1   9     0   6   116 101                 217
737783 737783 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2015   grade_8 131 0 1 0   0     0   0   70 62                       132 131 0 1 0   0     0   0   70 62                 132
737821 737821 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No 2 06 08 2015   grade_8 261 9 26 0   17     0   6   172 147                       319 261 9 26 0   17     0   6   172 147                 319
737840 737840 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No 2 06 08 2015   grade_8 245 0 2 0   7     0   4   130 128                       258 245 0 2 0   7     0   4   130 128                 258
737854 737854 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No 3 07 12 2015   grade_8 168 5 0 0   0     0   5   85 93                       178 168 5 0 0   0     0   5   85 93                 178
737885 737885 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No 2 05 08 2015   grade_8 112 2 17 0   3     0   2   73 63                       136 112 2 17 0   3     0   2   73 63                 136
737903 737903 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No 2 06 08 2015   grade_8 190 12 13 0   7     1   0   114 109                       223 190 12 13 0   7     1   0   114 109                 223
737926 737926 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No 2 06 08 2015   grade_8 284 17 13 0   15     0   10   151 188                       339 284 17 13 0   15     0   10   151 188                 339
737940 737940 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2015   grade_8 29 0 7 1   0     0   0   21 16                       37 29 0 7 1   0     0   0   21 16                 37
737958 737958 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2015   grade_8 12 7 20 2   4     0   1   21 25                       46 12 7 20 2   4     0   1   21 25                 46
737973 737973 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2015   grade_8 47 18 37 0   0     0   4   62 44                       106 47 18 37 0   0     0   4   62 44                 106
737982 737982 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2015   grade_8 35 12 31 1   10     1   1   44 47                       91 35 12 31 1   10     1   1   44 47                 91
737985 737985 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 01 12 2015   grade_8 2 1 3 0   0     0   1   6 1                       7 2 1 3 0   0     0   1   6 1                 7
737997 737997 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2015   grade_8 44 19 30 0   5     0   0   52 46                       98 44 19 30 0   5     0   0   52 46                 98
738006 738006 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2015   grade_8 27 17 79 0   1     0   0   52 72                       124 27 17 79 0   1     0   0   52 72                 124
738027 738027 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No 2 06 08 2015   grade_8 125 0 5 0   1     0   2   73 60                       133 125 0 5 0   1     0   2   73 60                 133
738075 738075 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2015   grade_8 18 5 13 1   1     0   2   17 23                       40 18 5 13 1   1     0   2   17 23                 40
738107 738107 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No 2 06 08 2015   grade_8 142 13 66 0   15     0   7   123 120                       243 142 13 66 0   15     0   7   123 120                 243
738110 738110 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No 2 06 08 2015   grade_8 126 13 40 0   8     2   11   84 116                       200 126 13 40 0   8     2   11   84 116                 200
738113 738113 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No 2 06 08 2015   grade_8 163 16 47 2   8     0   15   125 126                       251 163 16 47 2   8     0   15   125 126                 251
738120 738120 MA Bristol   school 2504830 95   Fall River 250483002696 950326 Stone Therapeutic Day Middle School   Regular School No 2 06 08 2015   grade_8 9 0 2 0   0     1   1   10 *                       13 9 0 2 0   0     1   1   10                   13
738122 738122 MA Bristol   school 2504830 95   Fall River 250483002838 950335 Resiliency Middle School   Regular School No 2 07 08 2015   grade_8 6 2 9 0   0     0   1   8 10                       18 6 2 9 0   0     0   1   8 10                 18
738152 738152 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No 2 07 08 2015   grade_8 228 15 8 3   9     0   12   133 142                       275 228 15 8 3   9     0   12   133 142                 275
738172 738172 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No 2 05 08 2015   grade_8 58 12 74 0   10     0   11   81 84                       165 58 12 74 0   10     0   11   81 84                 165
738182 738182 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2015   grade_8 31 11 53 0   7     0   10   50 62                       112 31 11 53 0   7     0   10   50 62                 112
738192 738192 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2015   grade_8 30 4 27 0   3     0   4   27 41                       68 30 4 27 0   3     0   4   27 41                 68
738212 738212 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_8 10 0 1 0   0     0   0   4 7                       11 10 0 1 0   0     0   0   4 7                 11
738232 738232 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No 2 05 08 2015   grade_8 203 6 4 0   8     0   2   122 101                       223 203 6 4 0   8     0   2   122 101                 223
738289 738289 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No 2 06 08 2015   grade_8 121 10 32 0   4     0   8   92 83                       175 121 10 32 0   4     0   8   92 83                 175
738292 738292 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No 2 06 08 2015   grade_8 70 13 59 0   5     0   5   88 64                       152 70 13 59 0   5     0   5   88 64                 152
738295 738295 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2015   grade_8 122 16 68 0   19     0   7   117 115                       232 122 16 68 0   19     0   7   117 115                 232
738339 738339 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No 2 06 08 2015   grade_8 150 2 1 1   3     0   2   77 82                       159 150 2 1 1   3     0   2   77 82                 159
738342 738342 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2015   grade_8 134 0 6 0   6     2   2   73 77                       150 134 0 6 0   6     2   2   73 77                 150
738345 738345 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No 2 06 08 2015   grade_8 127 1 3 1   9     1   4   78 68                       146 127 1 3 1   9     1   4   78 68                 146
738363 738363 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 06 08 2015   grade_8 134 3 28 0   6     0   8   89 90                       179 134 3 28 0   6     0   8   89 90                 179
738382 738382 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No 2 06 08 2015   grade_8 110 0 0 0   1     0   1   56 56                       112 110 0 0 0   1     0   1   56 56                 112
738420 738420 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2015   grade_8 215 2 10 2   5     1   3   133 105                       238 215 2 10 2   5     1   3   133 105                 238
738444 738444 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No 2 07 08 2015   grade_8 196 6 6 0   32     0   7   124 123                       247 196 6 6 0   32     0   7   124 123                 247
738459 738459 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No 3 07 12 2015   grade_8 64 1 2 0   2     0   4   43 30                       73 64 1 2 0   2     0   4   43 30                 73
738485 738485 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No 3 08 12 2015   grade_8 89 2 22 1   3     0   3   68 52                       120 89 2 22 1   3     0   3   68 52                 120
738500 738500 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2015   grade_8 43 4 7 0   1     1   1   25 32                       57 43 4 7 0   1     1   1   25 32                 57
738534 738534 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No 2 05 08 2015   grade_8 227 1 2 0   5     0   0   138 97                       235 227 1 2 0   5     0   0   138 97                 235
738549 738549 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_8 83 4 3 0   12     0   1   56 47                       103 83 4 3 0   12     0   1   56 47                 103
738563 738563 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2015   grade_8 35 0 1 0   2     0   0   17 21                       38 35 0 1 0   2     0   0   17 21                 38
738585 738585 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No 4 06 12 2015   grade_8 5 2 2 0   0     0   0   8 1                       9 5 2 2 0   0     0   0   8 1                 9
738591 738591 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2015   grade_8 109 9 17 0   2     1   0   64 74                       138 109 9 17 0   2     1   0   64 74                 138
738596 738596 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2015   grade_8 70 3 42 0   0     0   0   60 55                       115 70 3 42 0   0     0   0   60 55                 115
738605 738605 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_8 * * * *   *     *   *   4 1                       5                         4 1                 5
738621 738621 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2015   grade_8 88 5 19 0   3     0   2   74 43                       117 88 5 19 0   3     0   2   74 43                 117
738630 738630 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_8 118 5 90 0   6     0   1   113 107                       220 118 5 90 0   6     0   1   113 107                 220
738663 738663 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2015   grade_8 283 4 4 0   3     0   5   151 148                       299 283 4 4 0   3     0   5   151 148                 299
738678 738678 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2015   grade_8 59 15 8 1   4     0   2   47 42                       89 59 15 8 1   4     0   2   47 42                 89
738701 738701 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No 2 06 08 2015   grade_8 189 1 9 0   10     0   6   107 108                       215 189 1 9 0   10     0   6   107 108                 215
738717 738717 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2015   grade_8 11 0 23 0   0     0   0   16 18                       34 11 0 23 0   0     0   0   16 18                 34
738727 738727 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2015   grade_8 1 1 30 0   0     0   1   21 12                       33 1 1 30 0   0     0   1   21 12                 33
738732 738732 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2015   grade_8 8 4 85 0   2     0   1   52 48                       100 8 4 85 0   2     0   1   52 48                 100
738741 738741 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2015   grade_8 0 0 58 0   2     0   0   30 30                       60 0 0 58 0   2     0   0   30 30                 60
738750 738750 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 KG 08 2015   grade_8 8 3 37 0   0     0   0   26 22                       48 8 3 37 0   0     0   0   26 22                 48
738759 738759 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2015   grade_8 12 3 36 0   0     0   1   28 24                       52 12 3 36 0   0     0   1   28 24                 52
738768 738768 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No 1 KG 08 2015   grade_8 11 5 48 0   0     0   0   32 32                       64 11 5 48 0   0     0   0   32 32                 64
738790 738790 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2015   grade_8 87 0 2 4   0     0   2   45 50                       95 87 0 2 4   0     0   2   45 50                 95
738804 738804 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No 2 06 08 2015   grade_8 236 0 8 0   16     0   7   138 129                       267 236 0 8 0   16     0   7   138 129                 267
738831 738831 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No 3 08 12 2015   grade_8 209 1 12 0   8     0   4   124 110                       234 209 1 12 0   8     0   4   124 110                 234
738845 738845 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No 2 06 08 2015   grade_8 81 1 1 0   0     0   2   46 39                       85 81 1 1 0   0     0   2   46 39                 85
738866 738866 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No 2 06 08 2015   grade_8 131 1 5 0   5     0   6   77 71                       148 131 1 5 0   5     0   6   77 71                 148
738909 738909 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2015   grade_8 4 3 84 0   1     0   1   47 46                       93 4 3 84 0   1     0   1   47 46                 93
738910 738910 MA Essex   school 2506660 149   Lawrence 250666001920 1490016 South Lawrence East Middle School   Regular School No 4 08 08 2015   grade_8 6 6 140 0   6     0   1   84 75                       159 6 6 140 0   6     0   1   84 75                 159
738914 738914 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2015   grade_8 3 2 125 0   0     0   0   63 67                       130 3 2 125 0   0     0   0   63 67                 130
738931 738931 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No 2 05 08 2015   grade_8 2 2 118 0   4     0   0   53 73                       126 2 2 118 0   4     0   0   53 73                 126
738935 738935 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No 2 05 08 2015   grade_8 9 2 136 0   1     0   3   76 75                       151 9 2 136 0   1     0   3   76 75                 151
738949 738949 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No 2 06 08 2015   grade_8 2 0 97 1   0     0   1   54 47                       101 2 0 97 1   0     0   1   54 47                 101
738968 738968 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2015   grade_8 7 0 66 0   1     0   0   42 32                       74 7 0 66 0   1     0   0   42 32                 74
738974 738974 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No 2 06 08 2015   grade_8 3 1 110 0   0     0   0   70 44                       114 3 1 110 0   0     0   0   70 44                 114
738978 738978 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No 2 05 08 2015   grade_8 9 2 101 0   5     0   1   54 64                       118 9 2 101 0   5     0   1   54 64                 118
739016 739016 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_8 1 0 18 0   0     0   0   17 2                       19 1 0 18 0   0     0   0   17 2                 19
739035 739035 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No 3 07 12 2015   grade_8 42 0 2 0   4     0   3   28 23                       51 42 0 2 0   4     0   3   28 23                 51
739049 739049 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No 2 06 08 2015   grade_8 118 5 7 0   2     1   0   68 65                       133 118 5 7 0   2     1   0   68 65                 133
739063 739063 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2015   grade_8 39 0 7 1   0     0   2   20 29                       49 39 0 7 1   0     0   2   20 29                 49
739098 739098 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No 2 06 08 2015   grade_8 110 7 40 1   4     0   6   99 69                       168 110 7 40 1   4     0   6   99 69                 168
739101 739101 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No 2 06 08 2015   grade_8 154 25 74 0   7     0   10   146 124                       270 154 25 74 0   7     0   10   146 124                 270
739159 739159 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No 2 06 08 2015   grade_8 170 8 11 0   92     0   13   158 136                       294 170 8 11 0   92     0   13   158 136                 294
739162 739162 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2015   grade_8 168 4 6 0   82     0   17   134 143                       277 168 4 6 0   82     0   17   134 143                 277
739181 739181 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No 1 PK 08 2015   grade_8 32 3 7 0   6     0   4   25 27                       52 32 3 7 0   6     0   4   25 27                 52
739186 739186 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No 2 04 08 2015   grade_8 24 13 7 0   2     0   1   17 30                       47 24 13 7 0   2     0   1   17 30                 47
739196 739196 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No 2 06 08 2015   grade_8 104 1 1 0   1     1   4   48 64                       112 104 1 1 0   1     1   4   48 64                 112
739216 739216 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No 2 06 08 2015   grade_8 81 2 0 0   8     0   0   54 37                       91 81 2 0 0   8     0   0   54 37                 91
739225 739225 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No 2 06 08 2015   grade_8 121 4 7 0   6     0   2   68 72                       140 121 4 7 0   6     0   2   68 72                 140

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