enrollments

Data source: Big Local News · About: Big Local

592 rows where grade = "grade_6", state = "MA" and year = 2021 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 592 ✖

grade ✖

  • grade_6 · 592 ✖
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
1672015 1672015 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington - Abington Middle School   Regular School No Middle 05 08 2021   grade_6 136 5 20 0   4     1   3   95 74 *                     169.0 136 5 20 0   4     1   3   95 74                 169
1672196 1672196 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Arlington - Gibbs School   Regular School No Middle 06 06 2021   grade_6 334 21 31 2   60     1   34   260 223 *                     483.0 334 21 31 2   60     1   34   260 223                 483
1674613 1674613 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Framingham - Cameron Middle School   Regular School No Middle 06 08 2021   grade_6 121 10 36 0   4     0   8   94 85 *                     179.0 121 10 36 0   4     0   8   94 85                 179
1674616 1674616 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham - Fuller Middle   Regular School No Middle 06 08 2021   grade_6 65 13 100 0   3     0   8   102 87 *                     189.0 65 13 100 0   3     0   8   102 87                 189
1674619 1674619 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham - Walsh Middle   Regular School No Middle 06 08 2021   grade_6 126 16 91 0   20     0   3   120 136 *                     256.0 126 16 91 0   20     0   3   120 136                 256
1674663 1674663 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin - Annie Sullivan Middle School   Regular School No Middle 06 08 2021   grade_6 83 0 3 0   4     1   1   50 42 *                     92.0 83 0 3 0   4     1   1   50 42                 92
1674666 1674666 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin - Remington Middle   Regular School No Middle 06 08 2021   grade_6 112 2 8 0   14     1   1   78 60 *                     138.0 112 2 8 0   14     1   1   78 60                 138
1674669 1674669 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin - Horace Mann   Regular School No Middle 06 08 2021   grade_6 101 1 8 0   4     2   2   54 64 *                     118.0 101 1 8 0   4     2   2   54 64                 118
1674684 1674684 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner - Gardner Middle School   Regular School No Middle 05 07 2021   grade_6 119 4 39 1   1     0   27   109 82 *                     191.0 119 4 39 1   1     0   27   109 82                 191
1674703 1674703 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown - Penn Brook   Regular School No Elementary KG 06 2021   grade_6 75 2 2 0   1     0   2   42 40 *                     82.0 75 2 2 0   1     0   2   42 40                 82
1674741 1674741 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester - Ralph B O'Maley Middle   Regular School No Middle 06 08 2021   grade_6 170 1 27 1   5     0   2   112 94 *                     206.0 170 1 27 1   5     0   2   112 94                 206
1674756 1674756 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1674774 1674774 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton - North Street Elementary School   Regular School No Elementary 02 06 2021   grade_6 114 0 10 0   13     0   6   74 69 *                     143.0 114 0 10 0   13     0   6   74 69                 143
1674779 1674779 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton - Millbury Street Elementary School   Regular School No Elementary 02 06 2021   grade_6 98 0 15 0   29     0   1   76 67 *                     143.0 98 0 15 0   29     0   1   76 67                 143
1674793 1674793 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 Granby - East Meadow   Regular School No Elementary PK 06 2021   grade_6 40 0 4 0   0     0   1   19 26 *                     45.0 40 0 4 0   0     0   1   19 26                 45
1674817 1674817 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield - Greenfield Middle   Regular School No Middle 05 07 2021   grade_6 79 4 29 0   1     0   6   53 66 *                     119.0 79 4 29 0   1     0   6   53 66                 119
1674831 1674831 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley - Hadley Elementary   Regular School No Elementary PK 06 2021   grade_6 26 3 3 0   1     1   1   17 18 *                     35.0 26 3 3 0   1     1   1   17 18                 35
1674844 1674844 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax - Halifax Elementary   Regular School No Elementary KG 06 2021   grade_6 70 1 5 1   0     0   4   46 35 *                     81.0 70 1 5 1   0     0   4   46 35                 81
1674852 1674852 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock - Hancock Elementary   Regular School No Elementary PK 06 2021   grade_6 11 0 0 0   0     0   1   6 6 *                     12.0 11 0 0 0   0     0   1   6 6                 12
1674860 1674860 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover - Hanover Middle   Regular School No Middle 05 08 2021   grade_6 193 6 7 0   3     0   3   106 106 *                     212.0 193 6 7 0   3     0   3   106 106                 212
1674875 1674875 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard - Bromfield   Regular School No High 06 12 2021   grade_6 61 1 2 0   9     0   4   39 38 *                     77.0 61 1 2 0   9     0   4   39 38                 77
1674889 1674889 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield - Hatfield Elementary   Regular School No Elementary PK 06 2021   grade_6 34 0 3 0   0     0   0   21 16 *                     37.0 34 0 3 0   0     0   0   21 16                 37
1674912 1674912 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill - Caleb Dustin Hunking School   Regular School No Elementary KG 08 2021   grade_6 113 6 40 0   3     0   5   90 77 *                     167.0 113 6 40 0   3     0   5   90 77                 167
1674922 1674922 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill - Dr Paul Nettle   Regular School No Middle 05 08 2021   grade_6 72 8 93 0   6     0   6   103 82 *                     185.0 72 8 93 0   6     0   6   103 82                 185
1674936 1674936 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 Haverhill - TEACH   Regular School No Other 02 11 2021   grade_6 * * * *   *     *   *   2 3 *                     5.0                         2 3                 5
1674946 1674946 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill - John G Whittier   Regular School No Middle 05 08 2021   grade_6 69 2 38 1   1     0   1   63 49 *                     112.0 69 2 38 1   1     0   1   63 49                 112
1674950 1674950 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill - Consentino Middle School   Regular School No Middle 05 08 2021   grade_6 95 12 108 0   7     0   12   131 103 *                     234.0 95 12 108 0   7     0   12   131 103                 234
1674989 1674989 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham - Hingham Middle School   Regular School No Middle 06 08 2021   grade_6 265 9 13 0   3     0   8   144 153 *                     298.0 265 9 13 0   3     0   8   144 153                 298
1675004 1675004 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook - Holbrook Middle High School   Regular School No High 06 12 2021   grade_6 49 21 10 0   4     0   5   48 41 *                     89.0 49 21 10 0   4     0   5   48 41                 89
1675019 1675019 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland - Holland Elementary   Regular School No Elementary PK 06 2021   grade_6 28 0 3 0   0     0   0   15 16 *                     31.0 28 0 3 0   0     0   0   15 16                 31
1675027 1675027 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Holliston - Robert H. Adams Middle School   Regular School No Middle 06 08 2021   grade_6 174 3 12 0   29     0   9   113 114 *                     227.0 174 3 12 0   29     0   9   113 114                 227
1675041 1675041 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Holyoke - Joseph Metcalf School   Regular School No Elementary PK 06 2021   grade_6 6 1 25 0   0     0   0   9 23 *                     32.0 6 1 25 0   0     0   0   9 23                 32
1675049 1675049 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke - Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2021   grade_6 13 0 25 0   2     0   1   19 22 *                     41.0 13 0 25 0   2     0   1   19 22                 41
1675060 1675060 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 Holyoke - William R. Peck School   Regular School No Middle 04 08 2021   grade_6 3 2 41 0   0     0   2   21 27 *                     48.0 3 2 41 0   0     0   2   21 27                 48
1675084 1675084 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke - Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2021   grade_6 8 2 41 0   1     0   0   27 25 *                     52.0 8 2 41 0   1     0   0   27 25                 52
1675101 1675101 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Holyoke - Veritas Prep Holyoke   Regular School No Middle 05 07 2021   grade_6 3 5 90 0   1     0   1   61 39 *                     100.0 3 5 90 0   1     0   1   61 39                 100
1675103 1675103 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke - Holyoke STEM Academy   Regular School No Middle 06 08 2021   grade_6 13 2 80 0   0     0   0   51 44 *                     95.0 13 2 80 0   0     0   0   51 44                 95
1675117 1675117 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Hopedale - Memorial   Regular School No Elementary KG 06 2021   grade_6 67 0 8 0   1     0   1   38 39 *                     77.0 67 0 8 0   1     0   1   38 39                 77
1675131 1675131 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton - Hopkinton Middle School   Regular School No Middle 06 08 2021   grade_6 210 3 8 2   66     0   14   161 142 *                     303.0 210 3 8 2   66     0   14   161 142                 303
1672210 1672210 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland - Ashland Middle   Regular School No Middle 06 08 2021   grade_6 158 7 27 3   29     0   5   115 114 *                     229.0 158 7 27 3   29     0   5   115 114                 229
1675157 1675157 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 Hudson - David J. Quinn Middle School   Regular School No Middle 05 07 2021   grade_6 124 7 29 0   2     0   1   75 88 *                     163.0 124 7 29 0   2     0   1   75 88                 163
1675171 1675171 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Hull - Memorial Middle   Regular School No Middle 06 08 2021   grade_6 57 0 1 0   1     0   2   29 32 *                     61.0 57 0 1 0   1     0   2   29 32                 61
1675191 1675191 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich - Ipswich Middle School   Regular School No Middle 06 08 2021   grade_6 97 1 5 0   4     0   6   53 60 *                     113.0 97 1 5 0   4     0   6   53 60                 113
1675204 1675204 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston - Kingston Intermediate   Regular School No Elementary 03 06 2021   grade_6 141 3 4 1   0     0   1   77 73 *                     150.0 141 3 4 1   0     0   1   77 73                 150
1675225 1675225 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence - Alexander B Bruce   Regular School No Middle 03 08 2021   grade_6 4 0 81 0   1     0   0   34 52 *                     86.0 4 0 81 0   1     0   0   34 52                 86
1675229 1675229 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence - Arlington Middle School   Regular School No Middle 05 08 2021   grade_6 0 1 149 0   0     0   0   85 64 *                     150.0 0 1 149 0   0     0   0   85 64                 150
1675246 1675246 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence - Guilmette Middle School   Regular School No Middle 05 08 2021   grade_6 4 0 123 0   0     0   0   68 59 *                     127.0 4 0 123 0   0     0   0   68 59                 127
1675250 1675250 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence - Parthum Middle School   Regular School No Middle 05 08 2021   grade_6 5 0 130 0   1     0   0   63 73 *                     136.0 5 0 130 0   1     0   0   63 73                 136
1675263 1675263 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence - UP Academy Oliver Middle School   Regular School No Middle 06 08 2021   grade_6 2 2 96 0   1     0   0   56 44 *                     101.0 2 2 96 0   1     0   0   56 44                 101
1675282 1675282 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence - Emily G Wetherbee   Regular School No Elementary KG 08 2021   grade_6 3 0 54 0   1     0   0   24 34 *                     58.0 3 0 54 0   1     0   0   24 34                 58
1675285 1675285 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Lawrence - Spark Academy   Regular School No Middle 06 08 2021   grade_6 6 1 140 0   1     0   0   92 56 *                     148.0 6 1 140 0   1     0   0   92 56                 148
1675288 1675288 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 Lawrence - UP Academy Leonard Middle School   Regular School No Middle 06 08 2021   grade_6 3 0 118 0   0     0   0   67 54 *                     121.0 3 0 118 0   0     0   0   67 54                 121
1675297 1675297 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence - Frost Middle School   Regular School No Middle 05 08 2021   grade_6 13 0 114 0   4     0   1   64 68 *                     132.0 13 0 114 0   4     0   1   64 68                 132
1675305 1675305 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_6 0 0 12 0   0     0   0   8 4 *                     12.0 0 0 12 0   0     0   0   8 4                 12
1675322 1675322 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee - Lee Elementary   Regular School No Elementary PK 06 2021   grade_6 36 1 9 0   2     0   2   32 18 *                     50.0 36 1 9 0   2     0   2   32 18                 50
1675337 1675337 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester - Leicester Middle   Regular School No Middle 05 08 2021   grade_6 71 5 13 0   3     0   4   53 43 *                     96.0 71 5 13 0   3     0   4   53 43                 96
1675351 1675351 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox - Lenox Memorial High   Regular School No High 06 12 2021   grade_6 49 0 8 0   3     0   0   30 30 *                     60.0 49 0 8 0   3     0   0   30 30                 60
1675385 1675385 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Leominster - Samoset School   Regular School No Middle 06 08 2021   grade_6 83 10 63 0   2     0   10   85 83 *                     168.0 83 10 63 0   2     0   10   85 83                 168
1675388 1675388 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Leominster - Sky View Middle School   Regular School No Middle 06 08 2021   grade_6 138 22 117 0   10     0   18   139 166 *                     305.0 138 22 117 0   10     0   18   139 166                 305
1675409 1675409 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett - Leverett Elementary   Regular School No Elementary PK 06 2021   grade_6 23 0 0 0   0     0   0   16 7 *                     23.0 23 0 0 0   0     0   0   16 7                 23
1675447 1675447 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Lexington - Jonas Clarke Middle   Regular School No Middle 06 08 2021   grade_6 115 11 11 1   120     0   20   150 128 *                     278.0 115 11 11 1   120     0   20   150 128                 278
1675450 1675450 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington - Wm Diamond Middle   Regular School No Middle 06 08 2021   grade_6 127 13 12 0   113     0   24   152 137 *                     289.0 127 13 12 0   113     0   24   152 137                 289
1675469 1675469 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln - Lincoln School   Regular School No Elementary PK 08 2021   grade_6 37 7 7 0   2     0   4   31 26 *                     57.0 37 7 7 0   2     0   4   31 26                 57
1675474 1675474 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Lincoln - Hanscom Middle   Regular School No Middle 04 08 2021   grade_6 21 5 14 0   0     2   7   21 28 *                     49.0 21 5 14 0   0     2   7   21 28                 49
1675484 1675484 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton - Littleton Middle School   Regular School No Middle 06 08 2021   grade_6 108 1 4 1   21     1   0   72 64 *                     136.0 108 1 4 1   21     1   0   72 64                 136
1675503 1675503 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Longmeadow - Glenbrook Middle   Regular School No Middle 06 08 2021   grade_6 83 7 5 0   12     0   6   61 52 *                     113.0 83 7 5 0   12     0   6   61 52                 113
1675513 1675513 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Longmeadow - Williams Middle   Regular School No Middle 06 08 2021   grade_6 77 0 6 0   8     0   3   54 40 *                     94.0 77 0 6 0   8     0   3   54 40                 94
1672244 1672244 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro - Robert J. Coelho Middle School   Regular School No Middle 05 08 2021   grade_6 97 9 15 0   8     0   7   75 61 *                     136.0 97 9 15 0   8     0   7   75 61                 136
1672248 1672248 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro - Cyril K. Brennan Middle School   Regular School No Middle 05 08 2021   grade_6 102 11 36 0   3     0   11   86 77 *                     163.0 102 11 36 0   3     0   11   86 77                 163
1672252 1672252 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro - Wamsutta Middle School   Regular School No Middle 05 08 2021   grade_6 86 11 18 0   1     0   18   62 72 *                     134.0 86 11 18 0   1     0   18   62 72                 134
1675533 1675533 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Lowell - Rogers STEM Academy   Regular School No Elementary KG 08 2021   grade_6 27 11 45 0   22     0   6   53 58 *                     111.0 27 11 45 0   22     0   6   53 58                 111
1675555 1675555 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Lowell - Pyne Arts   Regular School No Elementary PK 08 2021   grade_6 21 6 20 0   11     0   1   28 31 *                     59.0 21 6 20 0   11     0   1   28 31                 59
1675613 1675613 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_6 * * * *   *     *   *   1 * *                     1.0                         1                   1
1675623 1675623 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Lowell - Bartlett Community Partnership   Regular School No Elementary PK 08 2021   grade_6 6 4 26 0   23     0   0   27 32 *                     59.0 6 4 26 0   23     0   0   27 32                 59
1675627 1675627 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 Lowell - B.F. Butler Middle School   Regular School No Middle 05 08 2021   grade_6 32 11 45 0   46     0   6   69 71 *                     140.0 32 11 45 0   46     0   6   69 71                 140
1675631 1675631 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 Lowell - James S Daley Middle School   Regular School No Middle 05 08 2021   grade_6 50 6 36 0   79     0   9   97 83 *                     180.0 50 6 36 0   79     0   9   97 83                 180
1675639 1675639 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Lowell - Henry J Robinson Middle   Regular School No Middle 05 08 2021   grade_6 40 17 84 0   28     0   3   84 88 *                     172.0 40 17 84 0   28     0   3   84 88                 172
1675643 1675643 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 Lowell - James Sullivan Middle School   Regular School No Middle 05 08 2021   grade_6 57 13 74 0   14     0   10   104 64 *                     168.0 57 13 74 0   14     0   10   104 64                 168
1675647 1675647 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Lowell - Dr An Wang School   Regular School No Middle 05 08 2021   grade_6 48 12 61 0   36     0   6   82 81 *                     163.0 48 12 61 0   36     0   6   82 81                 163
1675651 1675651 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Lowell - Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2021   grade_6 23 5 62 0   72     0   7   95 74 *                     169.0 23 5 62 0   72     0   7   95 74                 169
1675666 1675666 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell - Dr. Janice Adie Day School   Special Education School No Other PK 12 2021   grade_6 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1675676 1675676 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Ludlow - Paul R Baird Middle   Regular School No Middle 06 08 2021   grade_6 136 4 20 1   0     0   9   73 97 *                     170.0 136 4 20 1   0     0   9   73 97                 170
1675690 1675690 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg - Lunenburg Middle School   Regular School No Middle 06 08 2021   grade_6 103 1 12 0   0     1   8   58 67 *                     125.0 103 1 12 0   0     1   8   58 67                 125
1675704 1675704 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1675824 1675824 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn - Thurgood Marshall Mid   Regular School No Middle 06 08 2021   grade_6 38 46 336 1   34     1   13   233 236 *                     469.0 38 46 336 1   34     1   13   233 236                 469
1675827 1675827 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn - Breed Middle School   Regular School No Middle 06 08 2021   grade_6 52 39 329 1   37     0   17   257 217 *                     475.0 52 39 329 1   37     0   17   257 217                 475
1675830 1675830 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Lynn - Pickering Middle   Regular School No Middle 06 08 2021   grade_6 60 15 97 1   10     0   4   97 90 *                     187.0 60 15 97 1   10     0   4   97 90                 187
1675841 1675841 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn - Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2021   grade_6 2 0 5 0   0     0   0   5 2 *                     7.0 2 0 5 0   0     0   0   5 2                 7
1675869 1675869 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield - Lynnfield Middle School   Regular School No Middle 05 08 2021   grade_6 145 2 16 0   11     0   6   93 87 *                     180.0 145 2 16 0   11     0   6   93 87                 180
1675882 1675882 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden - Beebe   Regular School No Elementary KG 08 2021   grade_6 30 20 16 0   31     0   5   52 50 *                     102.0 30 20 16 0   31     0   5   52 50                 102
1675891 1675891 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden - Ferryway   Regular School No Elementary KG 08 2021   grade_6 25 21 39 0   15     0   4   45 59 *                     104.0 25 21 39 0   15     0   4   45 59                 104
1675900 1675900 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Malden - Forestdale   Regular School No Elementary KG 08 2021   grade_6 34 11 19 0   7     0   5   45 31 *                     76.0 34 11 19 0   7     0   5   45 31                 76
1675909 1675909 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden - Linden   Regular School No Elementary KG 08 2021   grade_6 37 18 23 0   18     0   4   52 48 *                     100.0 37 18 23 0   18     0   4   52 48                 100
1675919 1675919 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Malden - Salemwood   Regular School No Elementary KG 08 2021   grade_6 27 27 45 0   26     0   6   63 68 *                     131.0 27 27 45 0   26     0   6   63 68                 131
1675934 1675934 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Mansfield - Harold L Qualters Middle   Regular School No Middle 06 08 2021   grade_6 202 15 8 0   21     0   9   136 119 *                     255.0 202 15 8 0   21     0   9   136 119                 255
1675947 1675947 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Marblehead - Village School   Regular School No Elementary 03 06 2021   grade_6 165 10 15 0   5     0   7   109 92 *                     202.0 165 10 15 0   5     0   7   109 92                 202
1675968 1675968 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Marion - Sippican   Regular School No Elementary PK 06 2021   grade_6 52 5 1 0   0     0   2   26 34 *                     60.0 52 5 1 0   0     0   2   26 34                 60
1672272 1672272 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn - Auburn Middle   Regular School No Middle 06 08 2021   grade_6 163 6 23 0   18     0   3   110 103 *                     213.0 163 6 23 0   18     0   3   110 103                 213
1675994 1675994 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 Marlborough - 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2021   grade_6 136 16 205 0   4     0   14   178 197 *                     375.0 136 16 205 0   4     0   14   178 197                 375
1676034 1676034 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Marshfield - Furnace Brook Middle   Regular School No Middle 06 08 2021   grade_6 269 0 12 0   3     0   7   148 143 *                     291.0 269 0 12 0   3     0   7   148 143                 291

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