enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1366597 1366597 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2020   grade_8 11 2 137 1   0     0   1   78 74 *                     152.0 11 2 137 1   0     0   1   78 74                 152
1366601 1366601 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2020   grade_8 8 5 129 0   0     0   2   67 77 *                     144.0 8 5 129 0   0     0   2   67 77                 144
1366633 1366633 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2020   grade_8 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1366670 1366670 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2020   grade_8 134 6 109 0   8     0   17   134 140 *                     274.0 134 6 109 0   8     0   17   134 140                 274
1366673 1366673 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2020   grade_8 118 7 100 0   7     0   11   133 110 *                     243.0 118 7 100 0   7     0   11   133 110                 243
1366690 1366690 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_8 14 1 0 0   0     0   1   7 9 *                     16.0 14 1 0 0   0     0   1   7 9                 16
1366700 1366700 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Middle 05 08 2020   grade_8 91 3 51 0   2     0   0   74 73 *                     147.0 91 3 51 0   2     0   0   74 73                 147
1366715 1366715 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset Middle School   Regular School No Middle 06 08 2020   grade_8 86 3 3 0   3     0   2   47 50 *                     97.0 86 3 3 0   3     0   2   47 50                 97
1366743 1366743 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2020   grade_8 172 12 18 1   16     0   17   115 121 *                     236.0 172 12 18 1   16     0   17   115 121                 236
1366785 1366785 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2020   grade_8 235 5 24 0   9     0   6   142 137 *                     279.0 235 5 24 0   9     0   6   142 137                 279
1366813 1366813 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2020   grade_8 277 5 15 0   0     0   21   170 148 *                     318.0 277 5 15 0   0     0   21   170 148                 318
1366842 1366842 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2020   grade_8 137 13 29 0   9     0   7   108 87 *                     195.0 137 13 29 0   9     0   7   108 87                 195
1366865 1366865 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2020   grade_8 109 0 3 0   1     0   3   73 43 *                     116.0 109 0 3 0   1     0   3   73 43                 116
1366904 1366904 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No Middle 06 08 2020   grade_8 210 15 29 1   28     0   5   137 149 *                     288.0 210 15 29 1   28     0   5   137 149                 288
1366918 1366918 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2020   grade_8 223 2 5 0   6     0   12   123 125 *                     248.0 223 2 5 0   6     0   12   123 125                 248
1366932 1366932 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2020   grade_8 167 2 5 1   0     0   4   102 77 *                     179.0 167 2 5 1   0     0   4   102 77                 179
1366963 1366963 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2020   grade_8 78 0 11 0   6     0   2   39 58 *                     97.0 78 0 11 0   6     0   2   39 58                 97
1366981 1366981 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2020   grade_8 174 7 13 0   10     0   5   104 105 *                     209.0 174 7 13 0   10     0   5   104 105                 209
1367003 1367003 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2020   grade_8 245 12 17 0   10     0   9   154 139 *                     293.0 245 12 17 0   10     0   9   154 139                 293
1367018 1367018 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2020   grade_8 28 2 5 0   0     0   1   17 19 *                     36.0 28 2 5 0   0     0   1   17 19                 36
1367037 1367037 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2020   grade_8 10 7 34 1   4     0   2   29 29 *                     58.0 10 7 34 1   4     0   2   29 29                 58
1367053 1367053 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2020   grade_8 37 9 43 2   6     1   3   54 47 *                     101.0 37 9 43 2   6     1   3   54 47                 101
1367062 1367062 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2020   grade_8 32 23 63 1   12     0   1   68 64 *                     132.0 32 23 63 1   12     0   1   68 64                 132
1367066 1367066 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2020   grade_8 * * * *   *     *   *   2 3 *                     5.0                         2 3                 5
1367078 1367078 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2020   grade_8 21 21 55 1   6     0   5   45 64 *                     109.0 21 21 55 1   6     0   5   45 64                 109
1367087 1367087 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2020   grade_8 10 18 103 0   3     0   0   65 69 *                     134.0 10 18 103 0   3     0   0   65 69                 134
1367108 1367108 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2020   grade_8 136 2 8 0   5     0   9   92 68 *                     160.0 136 2 8 0   5     0   9   92 68                 160
1367150 1367150 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2020   grade_8 19 7 17 0   2     0   5   33 17 *                     50.0 19 7 17 0   2     0   5   33 17                 50
1367160 1367160 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2020   grade_8 22 3 8 0   3     0   5   22 19 *                     41.0 22 3 8 0   3     0   5   22 19                 41
1367189 1367189 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2020   grade_8 72 18 65 0   6     0   13   92 82 *                     174.0 72 18 65 0   6     0   13   92 82                 174
1367192 1367192 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2020   grade_8 112 16 45 0   9     0   13   118 77 *                     195.0 112 16 45 0   9     0   13   118 77                 195
1367195 1367195 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2020   grade_8 138 24 40 0   13     0   11   106 120 *                     226.0 138 24 40 0   13     0   11   106 120                 226
1367199 1367199 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_8 3 1 0 0   0     0   4   7 1 *                     8.0 3 1 0 0   0     0   4   7 1                 8
1367208 1367208 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2020   grade_8 8 5 11 0   0     0   2   14 12 *                     26.0 8 5 11 0   0     0   2   14 12                 26
1367238 1367238 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2020   grade_8 204 19 16 1   2     0   14   130 126 *                     256.0 204 19 16 1   2     0   14   130 126                 256
1367259 1367259 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2020   grade_8 50 10 94 0   14     0   10   82 96 *                     178.0 50 10 94 0   14     0   10   82 96                 178
1367269 1367269 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2020   grade_8 33 10 95 0   7     0   10   85 70 *                     155.0 33 10 95 0   7     0   10   85 70                 155
1367279 1367279 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2020   grade_8 21 4 34 0   4     0   3   35 31 *                     66.0 21 4 34 0   4     0   3   35 31                 66
1367298 1367298 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_8 7 0 0 0   0     0   0   1 6 *                     7.0 7 0 0 0   0     0   0   1 6                 7
1367318 1367318 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2020   grade_8 168 16 15 0   4     1   5   108 100 *                     209.0 168 16 15 0   4     1   5   108 100                 209
1367381 1367381 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2020   grade_8 108 15 43 0   6     0   8   95 85 *                     180.0 108 15 43 0   6     0   8   95 85                 180
1367384 1367384 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2020   grade_8 107 17 113 0   7     1   5   123 127 *                     250.0 107 17 113 0   7     1   5   123 127                 250
1367387 1367387 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2020   grade_8 149 7 85 0   7     0   4   130 122 *                     252.0 149 7 85 0   7     0   4   130 122                 252
1367431 1367431 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2020   grade_8 108 1 11 0   6     1   3   67 63 *                     130.0 108 1 11 0   6     1   3   67 63                 130
1367434 1367434 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2020   grade_8 137 4 2 0   7     0   3   77 76 *                     153.0 137 4 2 0   7     0   3   77 76                 153
1367437 1367437 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2020   grade_8 130 3 4 0   9     0   4   77 73 *                     150.0 130 3 4 0   9     0   4   77 73                 150
1367452 1367452 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2020   grade_8 131 6 41 0   1     0   12   97 94 *                     191.0 131 6 41 0   1     0   12   97 94                 191
1367470 1367470 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2020   grade_8 91 2 3 0   0     0   0   50 46 *                     96.0 91 2 3 0   0     0   0   50 46                 96
1367508 1367508 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2020   grade_8 201 4 19 0   4     1   8   123 114 *                     237.0 201 4 19 0   4     1   8   123 114                 237
1367531 1367531 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2020   grade_8 201 5 16 2   28     2   6   130 130 *                     260.0 201 5 16 2   28     2   6   130 130                 260
1367545 1367545 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2020   grade_8 50 0 4 0   1     0   2   29 28 *                     57.0 50 0 4 0   1     0   2   29 28                 57
1367569 1367569 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2020   grade_8 82 2 21 0   3     0   10   64 54 *                     118.0 82 2 21 0   3     0   10   64 54                 118
1367583 1367583 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2020   grade_8 36 1 5 0   3     3   3   27 24 *                     51.0 36 1 5 0   3     3   3   27 24                 51
1367611 1367611 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2020   grade_8 208 5 5 0   5     0   1   125 99 *                     224.0 208 5 5 0   5     0   1   125 99                 224
1367625 1367625 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2020   grade_8 66 0 5 0   11     0   2   41 43 *                     84.0 66 0 5 0   11     0   2   41 43                 84
1367639 1367639 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2020   grade_8 29 1 0 0   0     0   0   16 14 *                     30.0 29 1 0 0   0     0   0   16 14                 30
1367662 1367662 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2020   grade_8 153 11 40 0   5     1   4   111 103 *                     214.0 153 11 40 0   5     1   4   111 103                 214
1367670 1367670 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2020   grade_8 50 5 66 0   1     1   2   61 64 *                     125.0 50 5 66 0   1     1   2   61 64                 125
1367688 1367688 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_8 * * * *   *     *   *   2 * *                     2.0                         2                   2
1367703 1367703 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2020   grade_8 73 7 41 1   3     0   1   67 59 *                     126.0 73 7 41 1   3     0   1   67 59                 126
1367707 1367707 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_8 101 9 100 1   4     0   1   119 97 *                     216.0 101 9 100 1   4     0   1   119 97                 216
1367746 1367746 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2020   grade_8 299 6 10 0   6     0   15   171 165 *                     336.0 299 6 10 0   6     0   15   171 165                 336
1367761 1367761 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2020   grade_8 67 24 17 0   5     0   8   64 57 *                     121.0 67 24 17 0   5     0   8   64 57                 121
1367784 1367784 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2020   grade_8 189 2 17 1   17     0   2   112 116 *                     228.0 189 2 17 1   17     0   2   112 116                 228
1367805 1367805 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2020   grade_8 14 0 35 0   0     0   0   25 24 *                     49.0 14 0 35 0   0     0   0   25 24                 49
1367816 1367816 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2020   grade_8 3 3 42 0   0     0   0   30 18 *                     48.0 3 3 42 0   0     0   0   30 18                 48
1367824 1367824 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2020   grade_8 0 2 37 0   0     0   0   24 15 *                     39.0 0 2 37 0   0     0   0   24 15                 39
1367841 1367841 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2020   grade_8 10 4 44 0   0     0   0   29 29 *                     58.0 10 4 44 0   0     0   0   29 29                 58
1367851 1367851 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2020   grade_8 5 1 35 0   0     0   0   15 26 *                     41.0 5 1 35 0   0     0   0   15 26                 41
1367860 1367860 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke STEM Academy   Regular School No Middle 06 08 2020   grade_8 5 5 64 0   0     0   1   37 38 *                     75.0 5 5 64 0   0     0   1   37 38                 75
1367874 1367874 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2020   grade_8 79 2 5 1   2     0   1   49 41 *                     90.0 79 2 5 1   2     0   1   49 41                 90
1367888 1367888 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2020   grade_8 188 6 14 1   36     0   10   126 129 *                     255.0 188 6 14 1   36     0   10   126 129                 255
1367914 1367914 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2020   grade_8 181 1 25 0   8     0   2   99 118 *                     217.0 181 1 25 0   8     0   2   99 118                 217
1367928 1367928 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2020   grade_8 56 1 0 0   1     0   1   28 31 *                     59.0 56 1 0 0   1     0   1   28 31                 59
1367948 1367948 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2020   grade_8 127 2 11 1   3     0   3   74 73 *                     147.0 127 2 11 1   3     0   3   74 73                 147
1367982 1367982 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_8 4 2 82 0   3     0   0   48 43 *                     91.0 4 2 82 0   3     0   0   48 43                 91
1367986 1367986 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2020   grade_8 2 1 146 0   0     0   0   74 73 *                     149.0 2 1 146 0   0     0   0   74 73                 149
1368003 1368003 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2020   grade_8 0 3 105 0   1     0   0   50 59 *                     109.0 0 3 105 0   1     0   0   50 59                 109
1368007 1368007 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2020   grade_8 7 0 130 0   0     0   2   58 81 *                     139.0 7 0 130 0   0     0   2   58 81                 139
1368020 1368020 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2020   grade_8 6 0 110 0   1     0   1   62 56 *                     118.0 6 0 110 0   1     0   1   62 56                 118
1368039 1368039 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2020   grade_8 0 1 65 0   2     0   0   31 37 *                     68.0 0 1 65 0   2     0   0   31 37                 68
1368042 1368042 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2020   grade_8 3 3 146 0   4     0   0   81 75 *                     156.0 3 3 146 0   4     0   0   81 75                 156
1368045 1368045 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2020   grade_8 0 1 102 0   1     0   0   60 44 *                     104.0 0 1 102 0   1     0   0   60 44                 104
1368054 1368054 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2020   grade_8 9 4 112 0   4     0   0   58 71 *                     129.0 9 4 112 0   4     0   0   58 71                 129
1368063 1368063 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_8 1 0 12 0   0     0   0   11 2 *                     13.0 1 0 12 0   0     0   0   11 2                 13
1368078 1368078 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2020   grade_8 50 1 4 0   2     0   1   31 27 *                     58.0 50 1 4 0   2     0   1   31 27                 58
1368093 1368093 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 05 08 2020   grade_8 102 6 15 0   7     0   5   77 58 *                     135.0 102 6 15 0   7     0   5   77 58                 135
1368107 1368107 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2020   grade_8 59 0 9 0   2     0   2   42 30 *                     72.0 59 0 9 0   2     0   2   42 30                 72
1368141 1368141 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No Middle 06 08 2020   grade_8 77 14 76 0   3     0   2   90 82 *                     172.0 77 14 76 0   3     0   2   90 82                 172
1368144 1368144 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2020   grade_8 140 23 113 0   15     0   9   160 140 *                     300.0 140 23 113 0   15     0   9   160 140                 300
1368204 1368204 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2020   grade_8 127 14 17 0   126     0   23   149 157 *                     307.0 127 14 17 0   126     0   23   149 157                 307
1368207 1368207 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2020   grade_8 119 14 14 0   108     0   26   128 153 *                     281.0 119 14 14 0   108     0   26   128 153                 281
1368226 1368226 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2020   grade_8 43 2 5 1   4     0   3   30 28 *                     58.0 43 2 5 1   4     0   3   30 28                 58
1368231 1368231 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2020   grade_8 18 4 10 0   1     1   5   20 19 *                     39.0 18 4 10 0   1     1   5   20 19                 39
1368241 1368241 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2020   grade_8 107 5 2 0   6     0   5   52 73 *                     125.0 107 5 2 0   6     0   5   52 73                 125
1368260 1368260 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2020   grade_8 79 4 9 0   16     0   4   51 61 *                     112.0 79 4 9 0   16     0   4   51 61                 112
1368270 1368270 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2020   grade_8 88 1 10 0   10     0   3   52 60 *                     112.0 88 1 10 0   10     0   3   52 60                 112
1368290 1368290 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 08 2020   grade_8 16 8 24 0   10     0   0   39 19 *                     58.0 16 8 24 0   10     0   0   39 19                 58
1368312 1368312 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2020   grade_8 24 2 26 0   5     0   2   31 28 *                     59.0 24 2 26 0   5     0   2   31 28                 59
1368370 1368370 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_8 * * * *   *     *   *   3 * *                     3.0                         3                   3

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