enrollments

Data source: Big Local News · About: Big Local

3,471 rows where grade = "grade_7" and state = "MA" sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 3,371 ✖
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
1367568 1367568 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Middle 05 07 2020   grade_7 88 2 21 0   2     0   5   59 59 *                     118.0 88 2 21 0   2     0   5   59 59                 118
1674818 1674818 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield - Greenfield Middle   Regular School No Middle 05 07 2021   grade_7 85 5 19 0   1     0   9   61 58 *                     119.0 85 5 19 0   1     0   9   61 58                 119
2042641 2042641 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Middle 05 07 2019   grade_7 84 3 21 0   2     0   9   63 56                       119.0 84 3 21 0   2     0   9   63 56                 119
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
738499 738499 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2015   grade_7 35 0 3 0   3     1   0   21 21                       42 35 0 3 0   3     1   0   21 21                 42
935350 935350 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2016   grade_7 44 0 2 0   0     0   2   29 19                       48 44 0 2 0   0     0   2   29 19                 48
1125300 1125300 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2017   grade_7 34 2 3 1   0     1   1   24 18                       42 34 2 3 1   0     1   1   24 18                 42
1367582 1367582 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2020   grade_7 36 2 7 0   3     0   1   30 19 *                     49.0 36 2 7 0   3     0   1   30 19                 49
1674832 1674832 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley - Hopkins Academy   Regular School No High 07 12 2021   grade_7 32 1 5 0   3     1   2   20 24 *                     44.0 32 1 5 0   3     1   2   20 24                 44
2042656 2042656 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2019   grade_7 33 0 3 0   3     3   3   25 20                       45.0 33 0 3 0   3     3   3   25 20                 45
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
738533 738533 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No 2 05 08 2015   grade_7 192 1 2 0   3     0   0   104 94                       198 192 1 2 0   3     0   0   104 94                 198
935383 935383 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No 2 05 08 2016   grade_7 214 1 5 0   7     0   0   117 110                       227 214 1 5 0   7     0   0   117 110                 227
1125338 1125338 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2017   grade_7 201 1 3 0   4     0   0   115 94                       209 201 1 3 0   4     0   0   115 94                 209
1367610 1367610 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2020   grade_7 193 6 7 0   6     0   3   99 116 *                     215.0 193 6 7 0   6     0   3   99 116                 215
1674861 1674861 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover - Hanover Middle   Regular School No Middle 05 08 2021   grade_7 170 1 8 0   4     0   0   103 80 *                     183.0 170 1 8 0   4     0   0   103 80                 183
2042688 2042688 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2019   grade_7 204 4 5 0   6     0   1   121 99                       220.0 204 4 5 0   6     0   1   121 99                 220
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
738548 738548 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_7 78 1 4 0   9     0   2   45 49                       94 78 1 4 0   9     0   2   45 49                 94
935398 935398 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_7 79 3 3 0   11     0   3   52 47                       99 79 3 3 0   11     0   3   52 47                 99
1125355 1125355 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_7 76 2 3 0   16     0   1   44 54                       98 76 2 3 0   16     0   1   44 54                 98
1367624 1367624 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2020   grade_7 64 3 5 0   6     0   2   42 38 *                     80.0 64 3 5 0   6     0   2   42 38                 80
1674876 1674876 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard - Bromfield   Regular School No High 06 12 2021   grade_7 71 1 3 0   4     0   7   36 49 *                     86.0 71 1 3 0   4     0   7   36 49                 86
2042703 2042703 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2019   grade_7 64 0 4 0   10     0   2   44 36                       80.0 64 0 4 0   10     0   2   44 36                 80
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
738562 738562 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2015   grade_7 28 0 1 0   0     0   2   18 13                       31 28 0 1 0   0     0   2   18 13                 31
935412 935412 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2016   grade_7 35 0 1 0   0     0   0   26 10                       36 35 0 1 0   0     0   0   26 10                 36
1125371 1125371 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2017   grade_7 41 0 0 0   3     0   2   19 27                       46 41 0 0 0   3     0   2   19 27                 46
1367638 1367638 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2020   grade_7 37 0 1 0   0     0   1   22 17 *                     39.0 37 0 1 0   0     0   1   22 17                 39
1674890 1674890 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Hatfield - Smith Academy   Regular School No High 07 12 2021   grade_7 31 1 1 0   0     0   0   17 16 *                     33.0 31 1 1 0   0     0   0   17 16                 33
2042717 2042717 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2019   grade_7 29 1 1 0   0     0   0   15 16                       31.0 29 1 1 0   0     0   0   15 16                 31
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
738584 738584 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No 4 06 12 2015   grade_7 3 1 2 0   0     0   0   3 3                       6 3 1 2 0   0     0   0   3 3                 6
738590 738590 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2015   grade_7 109 4 15 0   1     0   0   63 66                       129 109 4 15 0   1     0   0   63 66                 129
738595 738595 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2015   grade_7 82 6 44 0   1     0   1   63 71                       134 82 6 44 0   1     0   1   63 71                 134
738604 738604 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_7 * * * *   *     *   *   1 1                       2                         1 1                 2
738620 738620 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2015   grade_7 79 5 34 1   1     0   3   73 50                       123 79 5 34 1   1     0   3   73 50                 123
738629 738629 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_7 131 9 81 1   5     0   1   111 117                       228 131 9 81 1   5     0   1   111 117                 228
935439 935439 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2016   grade_7 99 5 23 0   3     0   0   70 60                       130 99 5 23 0   3     0   0   70 60                 130
935444 935444 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2016   grade_7 79 2 53 0   2     0   0   66 70                       136 79 2 53 0   2     0   0   66 70                 136
935454 935454 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 01 12 2016   grade_7 * * * *   *     *   *   2 3                       5                         2 3                 5
935467 935467 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2016   grade_7 97 2 30 0   1     0   0   74 56                       130 97 2 30 0   1     0   0   74 56                 130
935475 935475 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_7 136 7 66 0   2     0   2   106 107                       213 136 7 66 0   2     0   2   106 107                 213
1125406 1125406 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No Middle 06 08 2017   grade_7 100 6 21 0   2     0   1   64 66                       130 100 6 21 0   2     0   1   64 66                 130
1125413 1125413 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2017   grade_7 69 7 41 0   2     0   0   52 67                       119 69 7 41 0   2     0   0   52 67                 119
1125425 1125425 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_7 * * * *   *     *   *   2 1                       *                         2 1                  
1125440 1125440 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2017   grade_7 97 7 30 0   3     1   1   67 72                       139 97 7 30 0   3     1   1   67 72                 139
1125449 1125449 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_7 96 8 98 0   3     0   1   99 107                       206 96 8 98 0   3     0   1   99 107                 206
1367661 1367661 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2020   grade_7 120 12 36 0   3     0   3   85 89 *                     174.0 120 12 36 0   3     0   3   85 89                 174
1367669 1367669 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2020   grade_7 70 6 59 1   5     1   5   73 74 *                     147.0 70 6 59 1   5     1   5   73 74                 147
1367687 1367687 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_7 * * * *   *     *   *   2 * *                     2.0                         2                   2
1367702 1367702 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2020   grade_7 108 6 33 0   2     0   0   77 72 *                     149.0 108 6 33 0   2     0   0   77 72                 149
1367706 1367706 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_7 118 14 82 1   7     0   2   118 106 *                     224.0 118 14 82 1   7     0   2   118 106                 224
1674913 1674913 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill - Caleb Dustin Hunking School   Regular School No Elementary KG 08 2021   grade_7 112 9 46 1   3     0   1   88 84 *                     172.0 112 9 46 1   3     0   1   88 84                 172
1674915 1674915 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill - Greenleaf Academy   Regular School No High 06 12 2021   grade_7 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1674923 1674923 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill - Dr Paul Nettle   Regular School No Middle 05 08 2021   grade_7 53 11 75 0   2     0   2   81 62 *                     143.0 53 11 75 0   2     0   2   81 62                 143
1674947 1674947 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill - John G Whittier   Regular School No Middle 05 08 2021   grade_7 60 8 66 0   2     1   3   60 80 *                     140.0 60 8 66 0   2     1   3   60 80                 140
1674951 1674951 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill - Consentino Middle School   Regular School No Middle 05 08 2021   grade_7 81 10 115 0   6     0   4   120 96 *                     216.0 81 10 115 0   6     0   4   120 96                 216
2042744 2042744 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2019   grade_7 147 12 35 0   3     1   3   106 95                       201.0 147 12 35 0   3     1   3   106 95                 201
2042752 2042752 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2019   grade_7 58 4 62 0   2     1   3   61 69                       130.0 58 4 62 0   2     1   3   61 69                 130
2042771 2042771 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_7 * * * *   *     *   *   5 *                       5.0                         5                   5
2042788 2042788 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2019   grade_7 75 6 35 1   3     0   1   64 57                       121.0 75 6 35 1   3     0   1   64 57                 121
2042793 2042793 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_7 109 10 95 1   3     0   1   124 95                       219.0 109 10 95 1   3     0   1   124 95                 219
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
738662 738662 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2015   grade_7 303 1 14 0   8     0   9   176 159                       335 303 1 14 0   8     0   9   176 159                 335
935508 935508 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2016   grade_7 342 5 4 0   8     0   6   173 192                       365 342 5 4 0   8     0   6   173 192                 365
1125487 1125487 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2017   grade_7 340 4 11 0   8     1   11   195 180                       375 340 4 11 0   8     1   11   195 180                 375
1367745 1367745 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2020   grade_7 268 5 9 0   12     0   13   152 155 *                     307.0 268 5 9 0   12     0   13   152 155                 307
1674990 1674990 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham - Hingham Middle School   Regular School No Middle 06 08 2021   grade_7 297 5 12 0   15     0   7   183 153 *                     336.0 297 5 12 0   15     0   7   183 153                 336
2042826 2042826 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2019   grade_7 304 7 9 0   6     0   13   175 164                       339.0 304 7 9 0   6     0   13   175 164                 339
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
738677 738677 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2015   grade_7 66 21 5 1   3     0   8   52 52                       104 66 21 5 1   3     0   8   52 52                 104
935523 935523 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2016   grade_7 62 11 15 0   5     0   2   52 43                       95 62 11 15 0   5     0   2   52 43                 95
1125505 1125505 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No High 07 12 2017   grade_7 69 21 11 0   5     0   9   60 55                       115 69 21 11 0   5     0   9   60 55                 115
1367760 1367760 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2020   grade_7 45 20 13 0   7     0   9   40 53 *                     94.0 45 20 13 0   7     0   9   40 53                 94
1675005 1675005 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook - Holbrook Middle High School   Regular School No High 06 12 2021   grade_7 51 18 17 1   5     0   9   54 47 *                     101.0 51 18 17 1   5     0   9   54 47                 101
2042841 2042841 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2019   grade_7 64 18 15 0   5     0   8   62 48                       110.0 64 18 15 0   5     0   8   62 48                 110
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
738700 738700 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No 2 06 08 2015   grade_7 216 1 4 0   14     0   8   134 109                       243 216 1 4 0   14     0   8   134 109                 243
935545 935545 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No 2 06 08 2016   grade_7 198 1 5 2   15     0   5   113 113                       226 198 1 5 2   15     0   5   113 113                 226
1125531 1125531 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2017   grade_7 195 1 7 1   18     0   4   100 126                       226 195 1 7 1   18     0   4   100 126                 226
1367783 1367783 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2020   grade_7 199 0 15 0   14     0   7   125 110 *                     235.0 199 0 15 0   14     0   7   125 110                 235
1675028 1675028 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Holliston - Robert H. Adams Middle School   Regular School No Middle 06 08 2021   grade_7 182 3 16 0   14     1   6   109 113 *                     222.0 182 3 16 0   14     1   6   109 113                 222
2042864 2042864 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2019   grade_7 191 3 16 1   16     0   3   111 119                       230.0 191 3 16 1   16     0   3   111 119                 230
2232346 2232346 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Holliston: Robert H. Adams Middle School   Regular School No Middle 06 08 2018   grade_7 174 3 15 2   20     0   6   117 103                       220.0 174 3 15 2   20     0   6   117 103                 220
738716 738716 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2015   grade_7 11 1 22 0   1     0   1   20 16                       36 11 1 22 0   1     0   1   20 16                 36
738726 738726 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2015   grade_7 2 1 39 0   0     0   0   21 21                       42 2 1 39 0   0     0   0   21 21                 42
738731 738731 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2015   grade_7 3 1 58 0   1     0   0   42 21                       63 3 1 58 0   1     0   0   42 21                 63
738740 738740 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2015   grade_7 0 0 47 0   0     0   0   19 28                       47 0 0 47 0   0     0   0   19 28                 47
738749 738749 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 KG 08 2015   grade_7 8 3 31 0   0     0   1   21 22                       43 8 3 31 0   0     0   1   21 22                 43
738758 738758 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2015   grade_7 13 0 46 0   0     0   3   29 33                       62 13 0 46 0   0     0   3   29 33                 62
738767 738767 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No 1 KG 08 2015   grade_7 7 4 47 0   2     0   0   33 27                       60 7 4 47 0   2     0   0   33 27                 60
935562 935562 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2016   grade_7 12 0 29 1   0     0   0   26 16                       42 12 0 29 1   0     0   0   26 16                 42
935572 935572 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2016   grade_7 2 0 35 0   0     0   0   19 18                       37 2 0 35 0   0     0   0   19 18                 37
935577 935577 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2016   grade_7 3 0 60 0   0     0   0   32 31                       63 3 0 60 0   0     0   0   32 31                 63
935586 935586 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2016   grade_7 0 0 45 0   2     0   0   20 27                       47 0 0 45 0   2     0   0   20 27                 47
935596 935596 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 PK 08 2016   grade_7 7 0 38 0   0     0   1   20 26                       46 7 0 38 0   0     0   1   20 26                 46

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