enrollments

Data source: Big Local News · About: Big Local

495 rows where grade = "grade_7", state = "MA" and year = 2018 sorted by native_american

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 395 ✖

grade ✖

  • grade_7 · 395 ✖
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
2231174 2231174 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth: Dartmouth Middle   Regular School No Middle 06 08 2018   grade_7 268 6 12 0   0     0   19   178 127                       305.0 268 6 12 0   0     0   19   178 127                 305
2231237 2231237 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas: Douglas Middle School   Regular School No Middle 06 08 2018   grade_7 92 0 6 0   1     0   1   49 51                       100.0 92 0 6 0   1     0   1   49 51                 100
2231301 2231301 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury: Duxbury Middle   Regular School No Middle 06 08 2018   grade_7 234 0 5 0   2     0   9   141 109                       250.0 234 0 5 0   2     0   9   141 109                 250
2231355 2231355 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton: White Brook Middle School   Regular School No Middle 05 08 2018   grade_7 86 2 12 0   3     0   2   60 45                       105.0 86 2 12 0   3     0   2   60 45                 105
2231377 2231377 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 East Longmeadow: Birchland Park   Regular School No Middle 06 08 2018   grade_7 183 8 16 0   10     0   4   126 95                       221.0 183 8 16 0   10     0   4   126 95                 221
2231405 2231405 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton: Easton Middle School   Regular School No Middle 06 08 2018   grade_7 264 18 10 0   10     0   3   157 148                       305.0 264 18 10 0   10     0   3   157 148                 305
2231421 2231421 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown: Edgartown Elementary   Regular School No Elementary PK 08 2018   grade_7 20 0 7 0   0     0   3   15 15                       30.0 20 0 7 0   0     0   3   15 15                 30
2231460 2231460 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett: Madeline English School   Regular School No Elementary KG 08 2018   grade_7 20 15 41 0   6     0   3   39 46                       85.0 20 15 41 0   6     0   3   39 46                 85
2231470 2231470 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett: George Keverian School   Regular School No Elementary KG 08 2018   grade_7 25 20 43 0   3     0   1   45 47                       92.0 25 20 43 0   3     0   1   45 47                 92
2231498 2231498 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_7 11 10 81 0   4     0   0   58 48                       106.0 11 10 81 0   4     0   0   58 48                 106
2231570 2231570 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River: Henry Lord Community School   Regular School No Elementary PK 08 2018   grade_7 30 8 22 0   2     0   2   36 28                       64.0 30 8 22 0   2     0   2   36 28                 64
2231581 2231581 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River: John J Doran   Regular School No Elementary PK 08 2018   grade_7 25 3 22 0   1     0   2   20 33                       53.0 25 3 22 0   1     0   2   20 33                 53
2231614 2231614 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Fall River: Talbot Innovation School   Regular School No Middle 06 08 2018   grade_7 87 13 55 0   10     0   8   96 77                       173.0 87 13 55 0   10     0   8   96 77                 173
2231622 2231622 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River: Matthew J Kuss Middle   Regular School No Middle 06 08 2018   grade_7 157 26 61 0   7     0   16   136 131                       267.0 157 26 61 0   7     0   16   136 131                 267
2231628 2231628 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River: Stone PK-12 School   Regular School No Other 02 12 2018   grade_7 5 0 3 0   0     0   0   7 1                       8.0 5 0 3 0   0     0   0   7 1                 8
2231651 2231651 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River: Resiliency Preparatory Academy   Alternative School No High 07 12 2018   grade_7 12 3 3 0   0     0   5   12 11                       23.0 12 3 3 0   0     0   5   12 11                 23
2231710 2231710 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg: Memorial Intermediate   Regular School No Middle 05 08 2018   grade_7 54 12 95 0   12     0   10   93 90                       183.0 54 12 95 0   12     0   10   93 90                 183
2231722 2231722 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg: Arthur M Longsjo Middle School   Regular School No Middle 05 08 2018   grade_7 42 12 88 0   8     0   8   88 70                       158.0 42 12 88 0   8     0   8   88 70                 158
2231733 2231733 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 Fitchburg: McKay Arts Academy   Regular School No Elementary PK 08 2018   grade_7 25 1 33 0   3     0   5   25 42                       67.0 25 1 33 0   3     0   5   25 42                 67
2231850 2231850 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Framingham: Cameron Middle School   Regular School No Middle 06 08 2018   grade_7 127 9 22 0   3     0   7   77 91                       168.0 127 9 22 0   3     0   7   77 91                 168
2231854 2231854 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham: Fuller Middle   Regular School No Middle 06 08 2018   grade_7 59 20 63 0   5     1   10   80 78                       158.0 59 20 63 0   5     1   10   80 78                 158
2231858 2231858 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham: Walsh Middle   Regular School No Middle 06 08 2018   grade_7 135 14 75 0   14     0   5   135 108                       243.0 135 14 75 0   14     0   5   135 108                 243
2231911 2231911 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin: Annie Sullivan Middle School   Regular School No Middle 06 08 2018   grade_7 149 0 4 0   5     0   1   89 70                       159.0 149 0 4 0   5     0   1   89 70                 159
2231915 2231915 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin: Remington Middle   Regular School No Middle 06 08 2018   grade_7 118 3 5 0   9     0   1   62 74                       136.0 118 3 5 0   9     0   1   62 74                 136
2231919 2231919 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin: Horace Mann   Regular School No Middle 06 08 2018   grade_7 129 0 5 0   11     0   6   64 87                       151.0 129 0 5 0   11     0   6   64 87                 151
2231937 2231937 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner: Gardner Middle School   Regular School No Middle 05 07 2018   grade_7 97 1 28 0   5     0   15   70 76                       146.0 97 1 28 0   5     0   15   70 76                 146
2231960 2231960 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown: Georgetown Middle School   Regular School No Middle 07 08 2018   grade_7 107 2 1 0   1     0   1   62 50                       112.0 107 2 1 0   1     0   1   62 50                 112
2232049 2232049 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton: Grafton Middle   Regular School No Middle 07 08 2018   grade_7 215 6 7 0   24     0   5   117 140                       257.0 215 6 7 0   24     0   5   117 140                 257
2232067 2232067 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby: Granby Jr Sr High School   Regular School No High 07 12 2018   grade_7 51 0 6 0   0     0   1   39 19                       58.0 51 0 6 0   0     0   1   39 19                 58
2232096 2232096 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield: Greenfield Middle   Regular School No Middle 05 07 2018   grade_7 86 1 26 0   1     0   8   64 58                       122.0 86 1 26 0   1     0   8   64 58                 122
2232113 2232113 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley: Hopkins Academy   Regular School No High 07 12 2018   grade_7 39 0 3 0   0     5   1   24 24                       48.0 39 0 3 0   0     5   1   24 24                 48
2232151 2232151 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover: Hanover Middle   Regular School No Middle 05 08 2018   grade_7 170 1 2 0   5     0   0   90 88                       178.0 170 1 2 0   5     0   0   90 88                 178
2232168 2232168 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard: Bromfield   Regular School No High 06 12 2018   grade_7 59 3 3 0   10     0   0   43 32                       75.0 59 3 3 0   10     0   0   43 32                 75
2232184 2232184 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Hatfield: Smith Academy   Regular School No High 07 12 2018   grade_7 28 0 3 0   0     0   0   16 15                       31.0 28 0 3 0   0     0   0   16 15                 31
2232217 2232217 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill: Caleb Dustin Hunking School   Regular School No Elementary KG 08 2018   grade_7 127 7 29 0   2     0   3   85 83                       168.0 127 7 29 0   2     0   3   85 83                 168
2232229 2232229 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill: Dr Paul Nettle   Regular School No Middle 05 08 2018   grade_7 69 6 50 0   4     0   1   67 63                       130.0 69 6 50 0   4     0   1   67 63                 130
2232258 2232258 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill: John G Whittier   Regular School No Middle 05 08 2018   grade_7 77 4 36 0   2     1   0   56 64                       120.0 77 4 36 0   2     1   0   56 64                 120
2232265 2232265 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill: Consentino Middle School   Regular School No Middle 03 08 2018   grade_7 97 6 101 0   5     1   3   95 118                       213.0 97 6 101 0   5     1   3   95 118                 213
2232303 2232303 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham: Hingham Middle School   Regular School No Middle 06 08 2018   grade_7 322 2 8 0   16     0   10   189 169                       358.0 322 2 8 0   16     0   10   189 169                 358
2232320 2232320 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook: Holbrook Middle High School   Regular School No High 06 12 2018   grade_7 50 20 15 0   4     0   9   47 51                       98.0 50 20 15 0   4     0   9   47 51                 98
2232368 2232368 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke: Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2018   grade_7 13 1 19 0   0     0   0   15 18                       33.0 13 1 19 0   0     0   0   15 18                 33
2232379 2232379 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Holyoke: Morgan Full Service Community School   Regular School No Elementary PK 08 2018   grade_7 0 2 37 0   0     0   0   21 18                       39.0 0 2 37 0   0     0   0   21 18                 39
2232385 2232385 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 Holyoke: William R. Peck School   Regular School No Middle 04 08 2018   grade_7 6 3 71 0   0     0   0   45 35                       80.0 6 3 71 0   0     0   0   45 35                 80
2232396 2232396 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Holyoke: Kelly Elementary   Regular School No Elementary PK 08 2018   grade_7 2 0 48 0   0     0   0   28 22                       50.0 2 0 48 0   0     0   0   28 22                 50
2232407 2232407 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 Holyoke: E N White Elementary   Regular School No Elementary PK 08 2018   grade_7 7 3 31 0   0     0   1   18 24                       42.0 7 3 31 0   0     0   1   18 24                 42
2232417 2232417 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke: Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2018   grade_7 8 4 49 0   0     0   1   26 36                       62.0 8 4 49 0   0     0   1   26 36                 62
2232428 2232428 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Holyoke: Maurice A Donahue Elementary   Regular School No Elementary PK 08 2018   grade_7 6 1 33 0   0     0   0   21 19                       40.0 6 1 33 0   0     0   0   21 19                 40
2232455 2232455 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale: Hopedale Jr Sr High   Regular School No High 07 12 2018   grade_7 70 0 4 0   6     1   4   49 36                       85.0 70 0 4 0   6     1   4   49 36                 85
2232474 2232474 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton: Hopkinton Middle School   Regular School No Middle 06 08 2018   grade_7 239 3 9 0   36     0   7   142 152                       294.0 239 3 9 0   36     0   7   142 152                 294
2232504 2232504 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 Hudson: David J. Quinn Middle School   Regular School No Middle 05 07 2018   grade_7 178 5 17 0   2     0   7   99 110                       209.0 178 5 17 0   2     0   7   99 110                 209
2232521 2232521 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Hull: Memorial Middle   Regular School No Middle 06 08 2018   grade_7 65 0 0 0   0     0   0   40 25                       65.0 65 0 0 0   0     0   0   40 25                 65
2232546 2232546 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich: Ipswich Middle School   Regular School No Middle 06 08 2018   grade_7 115 1 8 0   2     0   9   71 64                       135.0 115 1 8 0   2     0   9   71 64                 135
2232599 2232599 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence: Alexander B Bruce   Regular School No Middle 03 08 2018   grade_7 6 0 90 0   3     0   0   46 53                       99.0 6 0 90 0   3     0   0   46 53                 99
2232604 2232604 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence: Arlington Middle School   Regular School No Middle 05 08 2018   grade_7 3 1 143 0   0     0   1   80 68                       148.0 3 1 143 0   0     0   1   80 68                 148
2232625 2232625 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence: Guilmette Middle School   Regular School No Middle 05 08 2018   grade_7 3 3 124 0   0     0   1   65 66                       131.0 3 3 124 0   0     0   1   65 66                 131
2232630 2232630 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence: Parthum Middle School   Regular School No Middle 05 08 2018   grade_7 6 0 155 0   1     0   0   83 79                       162.0 6 0 155 0   1     0   0   83 79                 162
2232647 2232647 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence: UP Academy Oliver Middle School   Regular School No Middle 06 08 2018   grade_7 3 1 115 0   0     0   0   61 58                       119.0 3 1 115 0   0     0   0   61 58                 119
2232669 2232669 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence: Emily G Wetherbee   Regular School No Elementary KG 08 2018   grade_7 4 1 75 0   3     0   0   39 44                       83.0 4 1 75 0   3     0   0   39 44                 83
2232673 2232673 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Lawrence: Spark Academy   Regular School No Middle 06 08 2018   grade_7 5 2 129 0   3     0   1   61 79                       140.0 5 2 129 0   3     0   1   61 79                 140
2232677 2232677 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 Lawrence: UP Academy Leonard Middle School   Regular School No Middle 06 08 2018   grade_7 1 0 98 0   1     0   0   54 46                       100.0 1 0 98 0   1     0   0   54 46                 100
2232687 2232687 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence: Frost Middle School   Regular School No Middle 05 08 2018   grade_7 7 1 112 0   3     0   1   72 52                       124.0 7 1 112 0   3     0   1   72 52                 124
2232700 2232700 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_7 2 0 9 0   0     0   0   10 1                       11.0 2 0 9 0   0     0   0   10 1                 11
2232721 2232721 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee: Lee Middle/High School   Regular School No High 07 12 2018   grade_7 49 1 4 0   0     0   5   25 34                       59.0 49 1 4 0   0     0   5   25 34                 59
2232738 2232738 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester: Leicester Middle   Regular School No Middle 06 08 2018   grade_7 93 4 10 0   2     0   7   54 62                       116.0 93 4 10 0   2     0   7   54 62                 116
2232755 2232755 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox: Lenox Memorial High   Regular School No High 06 12 2018   grade_7 62 0 4 0   4     0   0   35 35                       70.0 62 0 4 0   4     0   0   35 35                 70
2232797 2232797 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Leominster: Samoset School   Regular School No Middle 06 08 2018   grade_7 106 9 39 0   5     0   4   87 75                       163.0 106 9 39 0   5     0   4   87 75                 163
2232801 2232801 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Leominster: Sky View Middle School   Regular School No Middle 06 08 2018   grade_7 137 23 93 0   16     0   13   141 141                       282.0 137 23 93 0   16     0   13   141 141                 282
2232873 2232873 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Lexington: Jonas Clarke Middle   Regular School No Middle 06 08 2018   grade_7 136 13 11 0   139     0   10   171 138                       309.0 136 13 11 0   139     0   10   171 138                 309
2232877 2232877 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington: Wm Diamond Middle   Regular School No Middle 06 08 2018   grade_7 152 10 9 0   128     0   22   161 160                       321.0 152 10 9 0   128     0   22   161 160                 321
2232899 2232899 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln: Lincoln School   Regular School No Elementary PK 08 2018   grade_7 47 9 4 0   0     0   3   33 30                       63.0 47 9 4 0   0     0   3   33 30                 63
2232905 2232905 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Lincoln: Hanscom Middle   Regular School No Middle 04 08 2018   grade_7 30 5 7 0   1     0   3   20 26                       46.0 30 5 7 0   1     0   3   20 26                 46
2232941 2232941 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Longmeadow: Glenbrook Middle   Regular School No Middle 06 08 2018   grade_7 87 4 6 0   14     0   2   57 56                       113.0 87 4 6 0   14     0   2   57 56                 113
2232953 2232953 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Longmeadow: Williams Middle   Regular School No Middle 06 08 2018   grade_7 84 1 4 0   6     0   3   61 37                       98.0 84 1 4 0   6     0   3   61 37                 98
2232999 2232999 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Lowell: Pyne Arts   Regular School No Elementary PK 08 2018   grade_7 24 1 20 0   9     0   2   30 26                       56.0 24 1 20 0   9     0   2   30 26                 56
2233080 2233080 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Lowell: Bartlett Community Partnership   Regular School No Elementary PK 08 2018   grade_7 8 3 24 0   19     0   1   22 33                       55.0 8 3 24 0   19     0   1   22 33                 55
2233085 2233085 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 Lowell: B.F. Butler Middle School   Regular School No Middle 05 08 2018   grade_7 39 11 41 0   30     0   6   68 59                       127.0 39 11 41 0   30     0   6   68 59                 127
2233090 2233090 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 Lowell: James S Daley Middle School   Regular School No Middle 05 08 2018   grade_7 46 8 35 0   76     0   8   93 80                       173.0 46 8 35 0   76     0   8   93 80                 173
2233100 2233100 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Lowell: Henry J Robinson Middle   Regular School No Middle 05 08 2018   grade_7 37 23 63 0   26     0   7   83 73                       156.0 37 23 63 0   26     0   7   83 73                 156
2233105 2233105 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 Lowell: James Sullivan Middle School   Regular School No Middle 05 08 2018   grade_7 48 13 57 0   21     0   5   77 67                       144.0 48 13 57 0   21     0   5   77 67                 144
2233110 2233110 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Lowell: Dr An Wang School   Regular School No Middle 05 08 2018   grade_7 35 16 70 0   23     0   6   92 58                       150.0 35 16 70 0   23     0   6   92 58                 150
2233115 2233115 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Lowell: Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2018   grade_7 16 6 55 0   85     0   6   91 77                       168.0 16 6 55 0   85     0   6   91 77                 168
2233162 2233162 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg: Lunenburg Middle School   Regular School No Middle 06 08 2018   grade_7 107 2 12 0   2     0   2   74 51                       125.0 107 2 12 0   2     0   2   74 51                 125
2233302 2233302 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_7 41 40 269 0   35     0   13   195 203                       398.0 41 40 269 0   35     0   13   195 203                 398
2233354 2233354 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield: Lynnfield Middle School   Regular School No Middle 05 08 2018   grade_7 129 3 13 0   9     0   5   90 69                       159.0 129 3 13 0   9     0   5   90 69                 159
2233369 2233369 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden: Beebe   Regular School No Elementary KG 08 2018   grade_7 23 11 10 0   41     0   2   40 47                       87.0 23 11 10 0   41     0   2   40 47                 87
2233379 2233379 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden: Ferryway   Regular School No Elementary KG 08 2018   grade_7 18 18 26 0   17     0   5   41 43                       84.0 18 18 26 0   17     0   5   41 43                 84
2233389 2233389 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Malden: Forestdale   Regular School No Elementary KG 08 2018   grade_7 22 11 22 0   7     0   0   32 30                       62.0 22 11 22 0   7     0   0   32 30                 62
2233411 2233411 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Malden: Salemwood   Regular School No Elementary KG 08 2018   grade_7 32 33 45 0   23     0   1   66 68                       134.0 32 33 45 0   23     0   1   66 68                 134
2233430 2233430 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Mansfield: Harold L Qualters Middle   Regular School No Middle 06 08 2018   grade_7 280 5 15 0   12     0   14   175 151                       326.0 280 5 15 0   12     0   14   175 151                 326
2233459 2233459 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead: Marblehead Veterans Middle School   Regular School No Middle 07 08 2018   grade_7 208 11 11 0   4     0   2   115 121                       236.0 208 11 11 0   4     0   2   115 121                 236
2233498 2233498 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 Marlborough: 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2018   grade_7 123 13 173 0   8     0   8   176 149                       325.0 123 13 173 0   8     0   8   176 149                 325
2233544 2233544 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Marshfield: Furnace Brook Middle   Regular School No Middle 06 08 2018   grade_7 328 1 8 0   4     1   3   183 161                       345.0 328 1 8 0   4     1   3   183 161                 345
2233589 2233589 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Maynard: Fowler School   Regular School No Middle 04 08 2018   grade_7 70 2 11 0   2     0   5   48 42                       90.0 70 2 11 0   2     0   5   48 42                 90
2233649 2233649 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Medford: Madeleine Dugger Andrews   Regular School No Middle 06 08 2018   grade_7 127 13 12 0   6     0   7   90 75                       165.0 127 13 12 0   6     0   7   90 75                 165
2233653 2233653 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 Medford: John J. McGlynn Middle School   Regular School No Middle 06 08 2018   grade_7 89 25 25 0   20     0   3   83 79                       162.0 89 25 25 0   20     0   3   83 79                 162
2233739 2233739 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen: Marsh Grammar School   Regular School No Elementary PK 08 2018   grade_7 100 0 33 0   4     0   5   70 72                       142.0 100 0 33 0   4     0   5   70 72                 142
2233750 2233750 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen: Comprehensive Grammar School   Regular School No Elementary PK 08 2018   grade_7 59 2 46 0   8     0   8   58 65                       123.0 59 2 46 0   8     0   8   58 65                 123
2233761 2233761 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Methuen: Tenney Grammar School   Regular School No Elementary PK 08 2018   grade_7 80 0 72 0   6     0   14   94 78                       172.0 80 0 72 0   6     0   14   94 78                 172
2233772 2233772 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Methuen: Donald P Timony Grammar   Regular School No Elementary PK 08 2018   grade_7 53 0 83 0   8     0   5   92 57                       149.0 53 0 83 0   8     0   5   92 57                 149
2233847 2233847 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury: Millbury Junior/Senior High   Regular School No High 07 12 2018   grade_7 117 3 9 0   2     0   1   56 76                       132.0 117 3 9 0   2     0   1   56 76                 132

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