enrollments

Data source: Big Local News · About: Big Local

499 rows where grade = "grade_7", state = "MA" and year = 2019

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 399 ✖

grade ✖

  • grade_7 · 399 ✖
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
2041661 2041661 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_7 9 10 116 0   0     0   0   73 62                       135.0 9 10 116 0   0     0   0   73 62                 135
2041665 2041665 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2019   grade_7 11 3 124 1   1     0   0   73 67                       140.0 11 3 124 1   1     0   0   73 67                 140
2041669 2041669 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2019   grade_7 8 5 126 0   1     0   1   63 78                       141.0 8 5 126 0   1     0   1   63 78                 141
2041702 2041702 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_7 * * * *   *     *   *   2 2                       4.0                         2 2                 4
2041739 2041739 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2019   grade_7 134 5 108 0   8     0   14   129 140                       269.0 134 5 108 0   8     0   14   129 140                 269
2041742 2041742 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2019   grade_7 123 12 94 0   5     0   10   137 107                       244.0 123 12 94 0   5     0   10   137 107                 244
2041759 2041759 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_7 15 0 0 0   0     0   2   8 9                       17.0 15 0 0 0   0     0   2   8 9                 17
2041769 2041769 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2019   grade_7 90 3 41 0   2     0   0   68 68                       136.0 90 3 41 0   2     0   0   68 68                 136
2041784 2041784 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No High 06 12 2019   grade_7 95 3 3 0   3     0   1   55 50                       105.0 95 3 3 0   3     0   1   55 50                 105
2041812 2041812 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2019   grade_7 173 11 16 1   16     0   17   111 123                       234.0 173 11 16 1   16     0   17   111 123                 234
2041854 2041854 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2019   grade_7 237 4 23 0   9     0   7   140 140                       280.0 237 4 23 0   9     0   7   140 140                 280
2041882 2041882 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2019   grade_7 279 5 15 0   1     0   20   174 146                       320.0 279 5 15 0   1     0   20   174 146                 320
2041911 2041911 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2019   grade_7 142 11 26 0   9     0   6   110 84                       194.0 142 11 26 0   9     0   6   110 84                 194
2041933 2041933 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2019   grade_7 114 0 3 0   1     0   4   79 43                       122.0 114 0 3 0   1     0   4   79 43                 122
2041972 2041972 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No Middle 06 08 2019   grade_7 211 15 26 1   26     0   3   131 151                       282.0 211 15 26 1   26     0   3   131 151                 282
2041987 2041987 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2019   grade_7 222 1 3 0   6     0   11   119 124                       243.0 222 1 3 0   6     0   11   119 124                 243
2042002 2042002 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2019   grade_7 165 3 5 1   0     0   5   101 78                       179.0 165 3 5 1   0     0   5   101 78                 179
2042033 2042033 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2019   grade_7 77 0 11 0   6     0   2   43 53                       96.0 77 0 11 0   6     0   2   43 53                 96
2042051 2042051 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2019   grade_7 179 9 15 0   9     0   6   110 108                       218.0 179 9 15 0   9     0   6   110 108                 218
2042074 2042074 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2019   grade_7 245 9 14 0   10     0   7   151 134                       285.0 245 9 14 0   10     0   7   151 134                 285
2042089 2042089 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2019   grade_7 30 2 5 0   0     0   1   18 20                       38.0 30 2 5 0   0     0   1   18 20                 38
2042108 2042108 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2019   grade_7 10 5 35 1   4     0   2   31 26                       57.0 10 5 35 1   4     0   2   31 26                 57
2042124 2042124 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2019   grade_7 41 10 50 2   7     1   2   57 56                       113.0 41 10 50 2   7     1   2   57 56                 113
2042133 2042133 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2019   grade_7 31 21 57 1   13     0   1   61 63                       124.0 31 21 57 1   13     0   1   61 63                 124
2042137 2042137 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_7 1 1 4 0   0     0   0   4 2                       6.0 1 1 4 0   0     0   0   4 2                 6
2042149 2042149 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2019   grade_7 22 22 54 1   6     0   6   50 61                       111.0 22 22 54 1   6     0   6   50 61                 111
2042158 2042158 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   grade_7 12 18 80 0   3     0   0   53 60                       113.0 12 18 80 0   3     0   0   53 60                 113
2042180 2042180 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2019   grade_7 138 2 8 0   5     0   6   90 69                       159.0 138 2 8 0   5     0   6   90 69                 159
2042222 2042222 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2019   grade_7 18 7 18 0   2     0   6   34 17                       51.0 18 7 18 0   2     0   6   34 17                 51
2042232 2042232 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2019   grade_7 25 4 7 0   3     0   5   24 20                       44.0 25 4 7 0   3     0   5   24 20                 44
2042260 2042260 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2019   grade_7 69 15 71 0   8     0   18   106 75                       181.0 69 15 71 0   8     0   18   106 75                 181
2042263 2042263 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2019   grade_7 106 14 49 0   10     0   16   111 84                       195.0 106 14 49 0   10     0   16   111 84                 195
2042266 2042266 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2019   grade_7 144 29 40 0   13     0   14   111 129                       240.0 144 29 40 0   13     0   14   111 129                 240
2042270 2042270 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_7 3 1 0 0   0     0   5   8 1                       9.0 3 1 0 0   0     0   5   8 1                 9
2042278 2042278 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_7 9 1 5 0   0     0   2   7 10                       17.0 9 1 5 0   0     0   2   7 10                 17
2042307 2042307 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2019   grade_7 212 18 17 2   3     0   14   131 135                       266.0 212 18 17 2   3     0   14   131 135                 266
2042328 2042328 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2019   grade_7 52 9 92 0   13     0   7   79 94                       173.0 52 9 92 0   13     0   7   79 94                 173
2042338 2042338 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2019   grade_7 35 12 92 0   7     0   10   87 69                       156.0 35 12 92 0   7     0   10   87 69                 156
2042348 2042348 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2019   grade_7 21 3 33 0   3     0   2   34 28                       62.0 21 3 33 0   3     0   2   34 28                 62
2042369 2042369 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_7 9 0 0 0   0     0   0   2 7                       9.0 9 0 0 0   0     0   0   2 7                 9
2042389 2042389 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2019   grade_7 172 17 14 0   5     1   5   109 104                       214.0 172 17 14 0   5     1   5   109 104                 214
2042451 2042451 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2019   grade_7 121 13 36 0   7     0   9   101 85                       186.0 121 13 36 0   7     0   9   101 85                 186
2042454 2042454 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2019   grade_7 113 19 74 0   4     1   5   114 102                       216.0 113 19 74 0   4     1   5   114 102                 216
2042457 2042457 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2019   grade_7 146 8 82 0   9     0   4   130 119                       249.0 146 8 82 0   9     0   4   130 119                 249
2042501 2042501 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2019   grade_7 109 3 5 0   6     1   3   62 65                       127.0 109 3 5 0   6     1   3   62 65                 127
2042504 2042504 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2019   grade_7 137 4 2 0   7     1   4   78 77                       155.0 137 4 2 0   7     1   4   78 77                 155
2042507 2042507 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2019   grade_7 132 2 4 0   8     0   3   76 73                       149.0 132 2 4 0   8     0   3   76 73                 149
2042522 2042522 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2019   grade_7 127 8 36 0   1     0   17   93 96                       189.0 127 8 36 0   1     0   17   93 96                 189
2042541 2042541 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2019   grade_7 94 1 2 0   0     0   0   51 46                       97.0 94 1 2 0   0     0   0   51 46                 97
2042579 2042579 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2019   grade_7 202 4 12 0   4     1   7   120 110                       230.0 202 4 12 0   4     1   7   120 110                 230
2042602 2042602 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2019   grade_7 189 4 16 2   30     2   6   128 121                       249.0 189 4 16 2   30     2   6   128 121                 249
2042617 2042617 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2019   grade_7 50 0 4 0   1     0   1   27 29                       56.0 50 0 4 0   1     0   1   27 29                 56
2042641 2042641 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Middle 05 07 2019   grade_7 84 3 21 0   2     0   9   63 56                       119.0 84 3 21 0   2     0   9   63 56                 119
2042656 2042656 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2019   grade_7 33 0 3 0   3     3   3   25 20                       45.0 33 0 3 0   3     3   3   25 20                 45
2042688 2042688 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2019   grade_7 204 4 5 0   6     0   1   121 99                       220.0 204 4 5 0   6     0   1   121 99                 220
2042703 2042703 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2019   grade_7 64 0 4 0   10     0   2   44 36                       80.0 64 0 4 0   10     0   2   44 36                 80
2042717 2042717 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2019   grade_7 29 1 1 0   0     0   0   15 16                       31.0 29 1 1 0   0     0   0   15 16                 31
2042744 2042744 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2019   grade_7 147 12 35 0   3     1   3   106 95                       201.0 147 12 35 0   3     1   3   106 95                 201
2042752 2042752 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2019   grade_7 58 4 62 0   2     1   3   61 69                       130.0 58 4 62 0   2     1   3   61 69                 130
2042771 2042771 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_7 * * * *   *     *   *   5 *                       5.0                         5                   5
2042788 2042788 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2019   grade_7 75 6 35 1   3     0   1   64 57                       121.0 75 6 35 1   3     0   1   64 57                 121
2042793 2042793 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_7 109 10 95 1   3     0   1   124 95                       219.0 109 10 95 1   3     0   1   124 95                 219
2042826 2042826 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2019   grade_7 304 7 9 0   6     0   13   175 164                       339.0 304 7 9 0   6     0   13   175 164                 339
2042841 2042841 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2019   grade_7 64 18 15 0   5     0   8   62 48                       110.0 64 18 15 0   5     0   8   62 48                 110
2042864 2042864 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2019   grade_7 191 3 16 1   16     0   3   111 119                       230.0 191 3 16 1   16     0   3   111 119                 230
2042885 2042885 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2019   grade_7 12 0 29 0   0     0   0   22 19                       41.0 12 0 29 0   0     0   0   22 19                 41
2042896 2042896 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2019   grade_7 2 3 40 0   0     0   0   32 13                       45.0 2 3 40 0   0     0   0   32 13                 45
2042905 2042905 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2019   grade_7 1 1 49 0   0     0   0   30 21                       51.0 1 1 49 0   0     0   0   30 21                 51
2042921 2042921 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2019   grade_7 8 4 48 0   0     0   0   28 32                       60.0 8 4 48 0   0     0   0   28 32                 60
2042931 2042931 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2019   grade_7 2 1 37 0   0     0   0   15 25                       40.0 2 1 37 0   0     0   0   15 25                 40
2042939 2042939 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke STEM Academy   Regular School No Middle 06 08 2019   grade_7 7 5 72 0   0     0   1   41 44                       85.0 7 5 72 0   0     0   1   41 44                 85
2042953 2042953 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2019   grade_7 77 2 4 1   2     0   1   49 38                       87.0 77 2 4 1   2     0   1   49 38                 87
2042967 2042967 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2019   grade_7 178 4 10 1   31     0   10   115 119                       234.0 178 4 10 1   31     0   10   115 119                 234
2042993 2042993 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2019   grade_7 179 0 24 0   7     0   2   98 114                       212.0 179 0 24 0   7     0   2   98 114                 212
2043007 2043007 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2019   grade_7 59 1 0 0   1     0   2   31 32                       63.0 59 1 0 0   1     0   2   31 32                 63
2043030 2043030 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2019   grade_7 128 2 9 1   3     0   3   71 75                       146.0 128 2 9 1   3     0   3   71 75                 146
2043065 2043065 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_7 4 2 76 0   3     0   0   45 40                       85.0 4 2 76 0   3     0   0   45 40                 85
2043069 2043069 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2019   grade_7 2 1 140 0   0     0   0   71 70                       143.0 2 1 140 0   0     0   0   71 70                 143
2043086 2043086 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2019   grade_7 2 2 108 0   1     0   0   50 63                       113.0 2 2 108 0   1     0   0   50 63                 113
2043090 2043090 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2019   grade_7 7 0 129 0   0     0   2   60 78                       138.0 7 0 129 0   0     0   2   60 78                 138
2043103 2043103 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2019   grade_7 7 0 106 0   0     0   0   61 52                       113.0 7 0 106 0   0     0   0   61 52                 113
2043122 2043122 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_7 1 1 72 0   2     0   0   36 40                       76.0 1 1 72 0   2     0   0   36 40                 76
2043125 2043125 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2019   grade_7 5 2 140 0   4     0   0   77 74                       151.0 5 2 140 0   4     0   0   77 74                 151
2043128 2043128 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2019   grade_7 0 1 99 0   1     0   0   59 42                       101.0 0 1 99 0   1     0   0   59 42                 101
2043137 2043137 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2019   grade_7 11 4 104 0   6     0   0   62 63                       125.0 11 4 104 0   6     0   0   62 63                 125
2043147 2043147 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_7 2 0 9 0   0     0   0   9 2                       11.0 2 0 9 0   0     0   0   9 2                 11
2043161 2043161 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2019   grade_7 50 1 2 0   2     0   1   31 25                       56.0 50 1 2 0   2     0   1   31 25                 56
2043176 2043176 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 06 08 2019   grade_7 106 6 14 0   7     0   4   81 56                       137.0 106 6 14 0   7     0   4   81 56                 137
2043190 2043190 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2019   grade_7 55 0 8 0   2     0   2   37 30                       67.0 55 0 8 0   2     0   2   37 30                 67
2043224 2043224 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No Middle 06 08 2019   grade_7 85 14 71 0   4     0   3   93 84                       177.0 85 14 71 0   4     0   3   93 84                 177
2043227 2043227 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2019   grade_7 138 29 110 0   13     0   8   161 137                       298.0 138 29 110 0   13     0   8   161 137                 298
2043287 2043287 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2019   grade_7 123 14 16 0   120     0   23   144 152                       296.0 123 14 16 0   120     0   23   144 152                 296
2043290 2043290 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_7 123 16 13 0   100     0   26   130 148                       278.0 123 16 13 0   100     0   26   130 148                 278
2043309 2043309 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2019   grade_7 44 3 5 1   4     0   5   33 29                       62.0 44 3 5 1   4     0   5   33 29                 62
2043314 2043314 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2019   grade_7 29 3 11 0   1     1   6   26 25                       51.0 29 3 11 0   1     1   6   26 25                 51
2043324 2043324 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2019   grade_7 105 5 1 0   6     0   5   51 71                       122.0 105 5 1 0   6     0   5   51 71                 122
2043343 2043343 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2019   grade_7 79 6 9 0   18     0   4   55 61                       116.0 79 6 9 0   18     0   4   55 61                 116
2043353 2043353 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2019   grade_7 85 1 9 0   10     0   3   50 58                       108.0 85 1 9 0   10     0   3   50 58                 108
2043373 2043373 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 07 2019   grade_7 20 4 19 0   11     0   1   36 19                       55.0 20 4 19 0   11     0   1   36 19                 55
2043394 2043394 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2019   grade_7 25 2 26 0   5     0   2   31 29                       60.0 25 2 26 0   5     0   2   31 29                 60

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