enrollments

Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 3,938 ✖
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
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
2042616 2042616 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary PK 06 2019   grade_6 47 0 4 0   1     0   0   31 21                       52.0 47 0 4 0   1     0   0   31 21                 52
2232059 2232059 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 Granby: East Meadow   Regular School No Middle 04 06 2018   grade_6 52 0 3 0   1     0   1   28 29                       57.0 52 0 3 0   1     0   1   28 29                 57
738475 738475 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No 2 04 07 2015   grade_6 * * * *   *     *   *   2 *                       3                         2                   3
738483 738483 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No 2 04 07 2015   grade_6 79 1 23 0   6     0   8   65 52                       117 79 1 23 0   6     0   8   65 52                 117
935334 935334 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No 2 04 07 2016   grade_6 101 3 20 0   3     0   8   69 66                       135 101 3 20 0   3     0   8   69 66                 135
1125266 1125266 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_6 * * * *   *     *   *   * *                       *                                              
1125282 1125282 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Elementary 04 07 2017   grade_6 96 1 24 0   1     0   7   66 63                       129 96 1 24 0   1     0   7   66 63                 129
1367567 1367567 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Middle 05 07 2020   grade_6 102 3 22 0   1     0   9   67 70 *                     137.0 102 3 22 0   1     0   9   67 70                 137
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
2042640 2042640 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Middle 05 07 2019   grade_6 94 2 21 0   1     0   7   67 58                       125.0 94 2 21 0   1     0   7   67 58                 125
2232095 2232095 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield: Greenfield Middle   Regular School No Middle 05 07 2018   grade_6 94 2 21 0   4     0   10   69 62                       131.0 94 2 21 0   4     0   10   69 62                 131
738498 738498 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   grade_6 44 0 3 0   0     0   2   24 25                       49 44 0 3 0   0     0   2   24 25                 49
935349 935349 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2016   grade_6 36 2 2 1   0     1   3   26 19                       45 36 2 2 1   0     1   3   26 19                 45
1125298 1125298 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   grade_6 37 0 1 0   0     5   0   23 20                       43 37 0 1 0   0     5   0   23 20                 43
1367581 1367581 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2020   grade_6 35 1 7 0   2     1   2   20 28 *                     48.0 35 1 7 0   2     1   2   20 28                 48
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
2042655 2042655 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2019   grade_6 34 2 6 0   2     0   1   25 20                       45.0 34 2 6 0   2     0   1   25 20                 45
2232111 2232111 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley: Hadley Elementary   Regular School No Elementary PK 06 2018   grade_6 40 1 3 0   1     3   3   27 24                       51.0 40 1 3 0   1     3   3   27 24                 51
738512 738512 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2015   grade_6 90 2 0 0   3     0   1   43 53                       96 90 2 0 0   3     0   1   43 53                 96
935362 935362 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2016   grade_6 62 0 0 0   1     0   1   38 26                       64 62 0 0 0   1     0   1   38 26                 64
1125313 1125313 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2017   grade_6 82 0 3 0   1     0   0   51 35                       86 82 0 3 0   1     0   0   51 35                 86
1367594 1367594 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2020   grade_6 76 1 2 1   0     0   3   39 44 *                     83.0 76 1 2 1   0     0   3   39 44                 83
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
2042669 2042669 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2019   grade_6 84 1 1 0   0     0   1   42 45                       87.0 84 1 1 0   0     0   1   42 45                 87
2232126 2232126 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax: Halifax Elementary   Regular School No Elementary KG 06 2018   grade_6 68 2 2 0   2     1   2   45 32                       77.0 68 2 2 0   2     1   2   45 32                 77
738519 738519 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   grade_6 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
935369 935369 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2016   grade_6 * * * *   *     *   *   2 2                       4                         2 2                 4
1367601 1367601 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2020   grade_6 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
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
2042674 2042674 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   3 2                       5.0                         3 2                 5
2232133 2232133 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock: Hancock Elementary   Regular School No Elementary PK 06 2018   grade_6 10 0 0 0   0     0   0   8 2                       10.0 10 0 0 0   0     0   0   8 2                 10
738532 738532 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No 2 05 08 2015   grade_6 218 1 5 0   7     0   0   119 112                       231 218 1 5 0   7     0   0   119 112                 231
935382 935382 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No 2 05 08 2016   grade_6 206 1 3 0   4     0   0   115 99                       214 206 1 3 0   4     0   0   115 99                 214
1125337 1125337 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2017   grade_6 172 1 2 0   5     0   0   91 89                       180 172 1 2 0   5     0   0   91 89                 180
1367609 1367609 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2020   grade_6 172 1 8 0   4     0   0   104 81 *                     185.0 172 1 8 0   4     0   0   104 81                 185
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
2042687 2042687 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2019   grade_6 197 5 8 0   5     0   3   100 118                       218.0 197 5 8 0   5     0   3   100 118                 218
2232150 2232150 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover: Hanover Middle   Regular School No Middle 05 08 2018   grade_6 210 1 5 0   6     0   1   124 99                       223.0 210 1 5 0   6     0   1   124 99                 223
738547 738547 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_6 80 3 3 0   11     0   2   53 46                       99 80 3 3 0   11     0   2   53 46                 99
935397 935397 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_6 76 2 5 0   14     0   1   46 52                       98 76 2 5 0   14     0   1   46 52                 98
1125354 1125354 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_6 58 3 2 0   9     0   0   41 31                       72 58 3 2 0   9     0   0   41 31                 72
1367623 1367623 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2020   grade_6 79 1 3 0   5     0   7   39 55 *                     95.0 79 1 3 0   5     0   7   39 55                 95
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
2042702 2042702 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2019   grade_6 60 2 5 0   7     0   0   39 35                       74.0 60 2 5 0   7     0   0   39 35                 74
2232167 2232167 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard: Bromfield   Regular School No High 06 12 2018   grade_6 64 0 5 0   11     0   1   47 34                       81.0 64 0 5 0   11     0   1   47 34                 81
738561 738561 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2015   grade_6 34 0 0 0   0     0   0   24 10                       34 34 0 0 0   0     0   0   24 10                 34
935411 935411 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2016   grade_6 39 0 0 0   1     0   2   17 25                       42 39 0 0 0   1     0   2   17 25                 42
1125369 1125369 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   grade_6 27 0 4 0   0     0   0   17 14                       31 27 0 4 0   0     0   0   17 14                 31
1367637 1367637 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2020   grade_6 34 1 3 0   0     0   0   17 21 *                     38.0 34 1 3 0   0     0   0   17 21                 38
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
2042716 2042716 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2019   grade_6 38 0 1 0   0     0   1   22 18                       40.0 38 0 1 0   0     0   1   22 18                 40
2232182 2232182 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield: Hatfield Elementary   Regular School No Elementary PK 06 2018   grade_6 30 1 1 0   0     0   0   17 15                       32.0 30 1 1 0   0     0   0   17 15                 32
738589 738589 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2015   grade_6 110 6 20 0   3     0   0   71 68                       139 110 6 20 0   3     0   0   71 68                 139
738594 738594 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2015   grade_6 88 2 46 0   2     0   0   70 68                       138 88 2 46 0   2     0   0   70 68                 138
738603 738603 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
738619 738619 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2015   grade_6 97 1 29 0   1     0   0   74 54                       128 97 1 29 0   1     0   0   74 54                 128
738628 738628 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_6 140 8 62 1   1     0   2   108 106                       214 140 8 62 1   1     0   2   108 106                 214
935438 935438 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2016   grade_6 104 6 18 0   1     1   1   61 70                       131 104 6 18 0   1     1   1   61 70                 131
935443 935443 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2016   grade_6 74 8 39 0   2     0   1   59 65                       124 74 8 39 0   2     0   1   59 65                 124
935466 935466 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2016   grade_6 98 6 32 0   3     1   1   71 70                       141 98 6 32 0   3     1   1   71 70                 141
935474 935474 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_6 105 5 93 0   4     0   1   100 108                       208 105 5 93 0   4     0   1   100 108                 208
1125405 1125405 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No Middle 06 08 2017   grade_6 117 7 27 0   2     0   3   77 79                       156 117 7 27 0   2     0   3   77 79                 156
1125412 1125412 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2017   grade_6 66 5 48 0   4     0   1   68 56                       124 66 5 48 0   4     0   1   68 56                 124
1125424 1125424 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_6 * * * *   *     *   *   4 1                       *                         4 1                  
1125439 1125439 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2017   grade_6 79 4 33 0   2     0   0   53 65                       118 79 4 33 0   2     0   0   53 65                 118
1125448 1125448 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_6 106 1 99 0   4     1   2   98 115                       213 106 1 99 0   4     1   2   98 115                 213
1367660 1367660 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2020   grade_6 114 12 43 1   3     0   1   90 84 *                     174.0 114 12 43 1   3     0   1   90 84                 174
1367668 1367668 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2020   grade_6 54 8 69 0   2     0   2   76 59 *                     135.0 54 8 69 0   2     0   2   76 59                 135
1367686 1367686 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_6 * * * *   *     *   *   1 * *                     1.0                         1                   1
1367701 1367701 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2020   grade_6 60 7 64 0   2     1   3   60 77 *                     137.0 60 7 64 0   2     1   3   60 77                 137
1367705 1367705 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_6 83 4 108 0   7     0   4   116 90 *                     206.0 83 4 108 0   7     0   4   116 90                 206
1367710 1367710 MA Essex   school 2505970 128   Haverhill 250597002906 1280105 Tilton Upper Middle School   Regular School No Middle 04 06 2020   grade_6 6 2 19 0   0     0   0   15 12 *                     27.0 6 2 19 0   0     0   0   15 12                 27
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
2042743 2042743 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2019   grade_6 115 10 29 0   4     0   3   83 78                       161.0 115 10 29 0   4     0   3   83 78                 161
2042751 2042751 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2019   grade_6 72 5 47 1   4     1   6   72 64                       136.0 72 5 47 1   4     1   6   72 64                 136
2042770 2042770 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_6 4 0 3 0   0     0   1   7 *                       8.0 4 0 3 0   0     0   1   7                   8
2042787 2042787 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2019   grade_6 118 5 30 0   2     0   1   83 73                       156.0 118 5 30 0   2     0   1   83 73                 156
2042792 2042792 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_6 127 13 103 1   7     0   3   126 128                       254.0 127 13 103 1   7     0   3   126 128                 254
2232216 2232216 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill: Caleb Dustin Hunking School   Regular School No Elementary KG 08 2018   grade_6 151 9 33 0   3     1   2   105 94                       199.0 151 9 33 0   3     1   2   105 94                 199
2232228 2232228 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill: Dr Paul Nettle   Regular School No Middle 05 08 2018   grade_6 62 5 56 0   4     1   1   63 66                       129.0 62 5 56 0   4     1   1   63 66                 129
2232257 2232257 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill: John G Whittier   Regular School No Middle 05 08 2018   grade_6 83 6 32 1   3     0   1   69 57                       126.0 83 6 32 1   3     0   1   69 57                 126
2232264 2232264 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill: Consentino Middle School   Regular School No Middle 03 08 2018   grade_6 114 11 89 1   2     0   1   115 103                       218.0 114 11 89 1   2     0   1   115 103                 218
738661 738661 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2015   grade_6 366 5 3 0   9     0   5   188 200                       388 366 5 3 0   9     0   5   188 200                 388
935507 935507 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2016   grade_6 341 4 9 0   9     1   10   191 183                       374 341 4 9 0   9     1   10   191 183                 374
1125486 1125486 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2017   grade_6 323 2 10 0   16     0   11   195 167                       362 323 2 10 0   16     0   11   195 167                 362
1367744 1367744 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2020   grade_6 317 4 13 0   14     0   8   196 160 *                     356.0 317 4 13 0   14     0   8   196 160                 356
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
2042825 2042825 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2019   grade_6 288 2 9 0   11     0   12   161 161                       322.0 288 2 9 0   11     0   12   161 161                 322
2232302 2232302 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham: Hingham Middle School   Regular School No Middle 06 08 2018   grade_6 320 7 7 0   4     0   13   189 162                       351.0 320 7 7 0   4     0   13   189 162                 351
738676 738676 MA Norfolk   school 2506150 133   Holbrook 250615000882 1330025 South   Regular School No 2 04 06 2015   grade_6 69 11 11 0   5     0   3   57 42                       99 69 11 11 0   5     0   3   57 42                 99
935522 935522 MA Norfolk   school 2506150 133   Holbrook 250615000882 1330025 South   Regular School No 2 04 06 2016   grade_6 77 23 9 0   4     0   10   62 61                       123 77 23 9 0   4     0   10   62 61                 123
1125503 1125503 MA Norfolk   school 2506150 133   Holbrook 250615000882 1330025 South   Regular School No Elementary 04 06 2017   grade_6 48 19 13 0   4     0   7   44 47                       91 48 19 13 0   4     0   7   44 47                 91
1367759 1367759 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2020   grade_6 53 16 19 1   4     0   13   55 51 *                     106.0 53 16 19 1   4     0   13   55 51                 106
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
2042840 2042840 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2019   grade_6 49 21 13 0   6     0   10   43 55                       99.0 49 21 13 0   6     0   10   43 55                 99

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