enrollments

Data source: Big Local News · About: Big Local

9,536 rows where state = "MA" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,536 ✖
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
1672008 1672008 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington - Abington Early Education Program   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 44 4 2 0   1     0   0   28 23 *                     51.0 44 4 2 0   1     0   0   28 23                 51
1672009 1672009 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington - Woodsdale Elementary School   Regular School No Elementary 03 04 2021   grade_3 117 10 11 2   3     0   1   67 77 *                     144.0 117 10 11 2   3     0   1   67 77                 144
1672010 1672010 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington - Woodsdale Elementary School   Regular School No Elementary 03 04 2021   grade_4 129 7 20 2   2     1   1   83 79 *                     162.0 129 7 20 2   2     1   1   83 79                 162
1672011 1672011 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington - Beaver Brook Elementary   Regular School No Elementary KG 02 2021   kindergarten 124 10 23 0   4     0   12   79 94 *                     173.0 124 10 23 0   4     0   12   79 94                 173
1672012 1672012 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington - Beaver Brook Elementary   Regular School No Elementary KG 02 2021   grade_1 127 8 26 1   4     0   2   79 88 *                     168.0 127 8 26 1   4     0   2   79 88                 168
1672013 1672013 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington - Beaver Brook Elementary   Regular School No Elementary KG 02 2021   grade_2 128 8 13 4   5     0   3   85 76 *                     161.0 128 8 13 4   5     0   3   85 76                 161
1672014 1672014 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington - Abington Middle School   Regular School No Middle 05 08 2021   grade_5 109 7 15 0   5     0   4   58 82 *                     140.0 109 7 15 0   5     0   4   58 82                 140
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
1672016 1672016 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington - Abington Middle School   Regular School No Middle 05 08 2021   grade_7 128 7 17 2   4     0   3   84 77 *                     161.0 128 7 17 2   4     0   3   84 77                 161
1672017 1672017 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington - Abington Middle School   Regular School No Middle 05 08 2021   grade_8 136 5 18 1   3     0   6   82 87 *                     169.0 136 5 18 1   3     0   6   82 87                 169
1672018 1672018 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington - Abington High   Regular School No High 09 12 2021   grade_9 122 5 16 0   3     0   0   88 58 *                     146.0 122 5 16 0   3     0   0   88 58                 146
1672019 1672019 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington - Abington High   Regular School No High 09 12 2021   grade_10 121 8 22 0   7     0   2   80 80 *                     160.0 121 8 22 0   7     0   2   80 80                 160
1672020 1672020 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington - Abington High   Regular School No High 09 12 2021   grade_11 125 10 12 0   4     0   2   78 75 *                     153.0 125 10 12 0   4     0   2   78 75                 153
1672021 1672021 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington - Abington High   Regular School No High 09 12 2021   grade_12 125 8 14 0   3     0   2   75 77 *                     152.0 125 8 14 0   3     0   2   75 77                 152
1672022 1672022 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington - Abington High   Regular School No High 09 12 2021   sped_beyond_grade_12 6 0 1 0   1     0   0   5 3 *                     8.0 6 0 1 0   1     0   0   5 3                 8
1672023 1672023 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   kindergarten 71 0 11 0   0     0   4   48 38 *                     86.0 71 0 11 0   0     0   4   48 38                 86
1672024 1672024 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten 25 1 1 0   0     0   1   16 12 *                     28.0 25 1 1 0   0     0   1   16 12                 28
1672025 1672025 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   grade_1 75 1 3 0   1     0   3   47 36 *                     83.0 75 1 3 0   1     0   3   47 36                 83
1672026 1672026 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   grade_2 107 1 2 0   2     0   5   62 55 *                     117.0 107 1 2 0   2     0   5   62 55                 117
1672027 1672027 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   grade_3 85 3 3 0   1     0   3   48 47 *                     95.0 85 3 3 0   1     0   3   48 47                 95
1672028 1672028 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   grade_4 70 1 4 1   0     0   4   43 37 *                     80.0 70 1 4 1   0     0   4   43 37                 80
1672029 1672029 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_5 96 0 3 0   1     0   8   57 51 *                     108.0 96 0 3 0   1     0   8   57 51                 108
1672030 1672030 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_6 92 0 7 0   1     0   4   49 55 *                     104.0 92 0 7 0   1     0   4   49 55                 104
1672031 1672031 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_7 95 1 2 1   1     0   0   55 45 *                     100.0 95 1 2 1   1     0   0   55 45                 100
1672032 1672032 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_8 99 0 4 0   1     0   5   59 50 *                     109.0 99 0 4 0   1     0   5   59 50                 109
1672033 1672033 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam - Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten 77 3 16 0   7     0   3   59 47 *                     106.0 77 3 16 0   7     0   3   59 47                 106
1672034 1672034 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam - Clifford M Granger   Regular School No Elementary KG 04 2021   kindergarten 34 0 7 0   3     0   0   23 21 *                     44.0 34 0 7 0   3     0   0   23 21                 44
1672035 1672035 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam - Clifford M Granger   Regular School No Elementary KG 04 2021   grade_1 42 1 9 0   4     0   1   25 32 *                     57.0 42 1 9 0   4     0   1   25 32                 57
1672036 1672036 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam - Clifford M Granger   Regular School No Elementary KG 04 2021   grade_2 27 1 8 0   5     0   0   21 20 *                     41.0 27 1 8 0   5     0   0   21 20                 41
1672037 1672037 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam - Clifford M Granger   Regular School No Elementary KG 04 2021   grade_3 30 1 7 0   2     0   0   20 20 *                     40.0 30 1 7 0   2     0   0   20 20                 40
1672038 1672038 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam - Clifford M Granger   Regular School No Elementary KG 04 2021   grade_4 57 2 4 0   0     1   1   30 35 *                     65.0 57 2 4 0   0     1   1   30 35                 65
1672039 1672039 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam - Benjamin J Phelps   Regular School No Elementary KG 04 2021   kindergarten 54 0 3 0   1     0   5   36 27 *                     63.0 54 0 3 0   1     0   5   36 27                 63
1672040 1672040 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam - Benjamin J Phelps   Regular School No Elementary KG 04 2021   grade_1 60 1 5 0   3     0   1   37 33 *                     70.0 60 1 5 0   3     0   1   37 33                 70
1672041 1672041 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam - Benjamin J Phelps   Regular School No Elementary KG 04 2021   grade_2 60 1 2 0   2     0   0   39 26 *                     65.0 60 1 2 0   2     0   0   39 26                 65
1672042 1672042 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam - Benjamin J Phelps   Regular School No Elementary KG 04 2021   grade_3 55 0 8 0   2     0   5   38 32 *                     70.0 55 0 8 0   2     0   5   38 32                 70
1672043 1672043 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam - Benjamin J Phelps   Regular School No Elementary KG 04 2021   grade_4 74 0 5 0   1     0   2   32 50 *                     82.0 74 0 5 0   1     0   2   32 50                 82
1672044 1672044 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam - Robinson Park   Regular School No Elementary KG 04 2021   kindergarten 55 2 13 0   0     0   2   37 35 *                     72.0 55 2 13 0   0     0   2   37 35                 72
1672045 1672045 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam - Robinson Park   Regular School No Elementary KG 04 2021   grade_1 58 1 13 0   2     0   7   37 44 *                     81.0 58 1 13 0   2     0   7   37 44                 81
1672046 1672046 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam - Robinson Park   Regular School No Elementary KG 04 2021   grade_2 66 2 10 0   2     0   5   44 41 *                     85.0 66 2 10 0   2     0   5   44 41                 85
1672047 1672047 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam - Robinson Park   Regular School No Elementary KG 04 2021   grade_3 47 3 10 0   3     0   1   36 28 *                     64.0 47 3 10 0   3     0   1   36 28                 64
1672048 1672048 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam - Robinson Park   Regular School No Elementary KG 04 2021   grade_4 61 3 6 0   2     0   3   37 38 *                     75.0 61 3 6 0   2     0   3   37 38                 75
1672049 1672049 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam - James Clark School   Regular School No Elementary KG 04 2021   kindergarten 37 3 5 0   3     0   0   24 24 *                     48.0 37 3 5 0   3     0   0   24 24                 48
1672050 1672050 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam - James Clark School   Regular School No Elementary KG 04 2021   grade_1 35 0 5 0   6     0   3   22 27 *                     49.0 35 0 5 0   6     0   3   22 27                 49
1672051 1672051 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam - James Clark School   Regular School No Elementary KG 04 2021   grade_2 49 0 5 0   4     0   2   30 30 *                     60.0 49 0 5 0   4     0   2   30 30                 60
1672052 1672052 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam - James Clark School   Regular School No Elementary KG 04 2021   grade_3 44 2 7 0   1     0   2   26 30 *                     56.0 44 2 7 0   1     0   2   26 30                 56
1672053 1672053 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam - James Clark School   Regular School No Elementary KG 04 2021   grade_4 43 2 6 0   2     0   3   36 20 *                     56.0 43 2 6 0   2     0   3   36 20                 56
1672054 1672054 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam - Roberta G. Doering School   Regular School No Middle 05 08 2021   grade_5 215 3 24 0   6     0   6   132 122 *                     254.0 215 3 24 0   6     0   6   132 122                 254
1672055 1672055 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam - Roberta G. Doering School   Regular School No Middle 05 08 2021   grade_6 209 8 36 0   10     0   9   164 108 *                     272.0 209 8 36 0   10     0   9   164 108                 272
1672056 1672056 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam - Agawam Junior High   Regular School No Middle 07 08 2021   grade_7 241 4 39 0   12     0   11   145 162 *                     307.0 241 4 39 0   12     0   11   145 162                 307
1672057 1672057 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam - Agawam Junior High   Regular School No Middle 07 08 2021   grade_8 229 13 20 0   4     0   9   138 137 *                     275.0 229 13 20 0   4     0   9   138 137                 275
1672058 1672058 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam - Agawam High   Regular School No High 09 12 2021   grade_9 231 6 23 0   12     0   9   155 126 *                     281.0 231 6 23 0   12     0   9   155 126                 281
1672059 1672059 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam - Agawam High   Regular School No High 09 12 2021   grade_10 233 6 24 0   10     0   8   149 132 *                     281.0 233 6 24 0   10     0   8   149 132                 281
1672060 1672060 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam - Agawam High   Regular School No High 09 12 2021   grade_11 181 4 19 1   5     0   7   104 112 *                     217.0 181 4 19 1   5     0   7   104 112                 217
1672061 1672061 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam - Agawam High   Regular School No High 09 12 2021   grade_12 236 4 23 0   2     0   6   129 142 *                     271.0 236 4 23 0   2     0   6   129 142                 271
1672062 1672062 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   kindergarten 58 0 5 0   1     0   3   39 28 *                     67.0 58 0 5 0   1     0   3   39 28                 67
1672063 1672063 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 13 0 1 0   0     0   0   10 4 *                     14.0 13 0 1 0   0     0   0   10 4                 14
1672064 1672064 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   grade_1 50 1 2 0   0     0   1   33 21 *                     54.0 50 1 2 0   0     0   1   33 21                 54
1672065 1672065 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   grade_2 56 1 6 0   1     0   4   35 33 *                     68.0 56 1 6 0   1     0   4   35 33                 68
1672066 1672066 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   grade_3 38 0 5 0   0     0   4   27 20 *                     47.0 38 0 5 0   0     0   4   27 20                 47
1672067 1672067 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury - Amesbury Elementary   Regular School No Elementary PK 04 2021   grade_4 57 6 7 0   2     0   3   50 25 *                     75.0 57 6 7 0   2     0   3   50 25                 75
1672068 1672068 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   kindergarten 54 1 8 1   0     0   3   32 35 *                     67.0 54 1 8 1   0     0   3   32 35                 67
1672069 1672069 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   pre_kindergarten 11 0 0 0   0     0   0   7 4 *                     11.0 11 0 0 0   0     0   0   7 4                 11
1672070 1672070 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   grade_1 52 2 12 0   0     0   2   28 40 *                     68.0 52 2 12 0   0     0   2   28 40                 68
1672071 1672071 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   grade_2 42 1 4 0   0     1   0   29 19 *                     48.0 42 1 4 0   0     1   0   29 19                 48
1672072 1672072 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   grade_3 58 2 14 0   1     0   3   42 36 *                     78.0 58 2 14 0   1     0   3   42 36                 78
1672073 1672073 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury - Charles C Cashman Elementary   Regular School No Elementary PK 04 2021   grade_4 56 0 9 0   0     0   2   33 34 *                     67.0 56 0 9 0   0     0   2   33 34                 67
1672074 1672074 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_5 129 3 15 1   2     0   7   81 76 *                     157.0 129 3 15 1   2     0   7   81 76                 157
1672075 1672075 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_6 139 1 16 1   4     0   5   90 76 *                     166.0 139 1 16 1   4     0   5   90 76                 166
1672076 1672076 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_7 119 3 21 0   2     0   10   90 65 *                     155.0 119 3 21 0   2     0   10   90 65                 155
1672077 1672077 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_8 121 5 11 0   3     1   6   70 77 *                     147.0 121 5 11 0   3     1   6   70 77                 147
1672078 1672078 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury - Amesbury High   Regular School No High 09 12 2021   grade_9 105 6 16 0   1     0   4   61 71 *                     132.0 105 6 16 0   1     0   4   61 71                 132
1672079 1672079 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury - Amesbury High   Regular School No High 09 12 2021   grade_10 99 2 10 0   0     0   7   63 55 *                     118.0 99 2 10 0   0     0   7   63 55                 118
1672080 1672080 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury - Amesbury High   Regular School No High 09 12 2021   grade_11 107 2 7 0   2     0   5   64 59 *                     123.0 107 2 7 0   2     0   5   64 59                 123
1672081 1672081 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury - Amesbury High   Regular School No High 09 12 2021   grade_12 116 4 11 0   3     0   6   70 70 *                     140.0 116 4 11 0   3     0   6   70 70                 140
1672082 1672082 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury - Amesbury High   Regular School No High 09 12 2021   sped_beyond_grade_12 8 0 0 0   0     0   0   4 4 *                     8.0 8 0 0 0   0     0   0   4 4                 8
1672083 1672083 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury - Amesbury Innovation High School   Regular School No High 09 12 2021   grade_10 7 0 1 0   0     0   0   3 5 *                     8.0 7 0 1 0   0     0   0   3 5                 8
1672084 1672084 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury - Amesbury Innovation High School   Regular School No High 09 12 2021   grade_11 11 0 1 0   0     0   1   9 3 *                     13.0 11 0 1 0   0     0   1   9 3                 13
1672085 1672085 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury - Amesbury Innovation High School   Regular School No High 09 12 2021   grade_12 14 0 1 0   0     0   2   11 6 *                     17.0 14 0 1 0   0     0   2   11 6                 17
1672086 1672086 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   kindergarten 23 7 6 0   7     1   4   22 25 *                     48.0 23 7 6 0   7     1   4   22 25                 48
1672087 1672087 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten 14 3 10 0   4     0   1   23 9 *                     32.0 14 3 10 0   4     0   1   23 9                 32
1672088 1672088 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_1 19 3 2 0   5     0   2   13 17 *                     31.0 19 3 2 0   5     0   2   13 17                 31
1672089 1672089 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_2 28 5 12 0   4     0   5   24 30 *                     54.0 28 5 12 0   4     0   5   24 30                 54
1672090 1672090 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_3 19 4 8 2   6     0   2   19 21 *                     41.0 19 4 8 2   6     0   2   19 21                 41
1672091 1672091 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_4 20 4 7 0   6     0   6   27 16 *                     43.0 20 4 7 0   6     0   6   27 16                 43
1672092 1672092 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_5 30 7 10 0   9     0   0   29 27 *                     56.0 30 7 10 0   9     0   0   29 27                 56
1672093 1672093 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_6 26 1 15 0   6     0   2   26 24 *                     50.0 26 1 15 0   6     0   2   26 24                 50
1672094 1672094 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst - Fort River Elementary   Regular School No Elementary KG 06 2021   kindergarten 15 0 17 0   3     0   0   14 21 *                     35.0 15 0 17 0   3     0   0   14 21                 35
1672095 1672095 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst - Fort River Elementary   Regular School No Elementary KG 06 2021   grade_1 22 1 17 0   5     0   8   29 24 *                     53.0 22 1 17 0   5     0   8   29 24                 53
1672096 1672096 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst - Fort River Elementary   Regular School No Elementary KG 06 2021   grade_2 19 3 10 1   3     0   5   29 12 *                     41.0 19 3 10 1   3     0   5   29 12                 41
1672097 1672097 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst - Fort River Elementary   Regular School No Elementary KG 06 2021   grade_3 14 3 9 0   4     0   2   14 18 *                     32.0 14 3 9 0   4     0   2   14 18                 32
1672098 1672098 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst - Fort River Elementary   Regular School No Elementary KG 06 2021   grade_4 26 6 17 0   7     0   4   27 33 *                     60.0 26 6 17 0   7     0   4   27 33                 60
1672099 1672099 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst - Fort River Elementary   Regular School No Elementary KG 06 2021   grade_5 24 2 9 0   8     1   1   24 21 *                     45.0 24 2 9 0   8     1   1   24 21                 45
1672100 1672100 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst - Fort River Elementary   Regular School No Elementary KG 06 2021   grade_6 20 2 10 0   6     0   2   18 22 *                     40.0 20 2 10 0   6     0   2   18 22                 40
1672101 1672101 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst - Wildwood Elementary   Regular School No Elementary KG 06 2021   kindergarten 22 4 9 0   5     0   4   24 20 *                     44.0 22 4 9 0   5     0   4   24 20                 44
1672102 1672102 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst - Wildwood Elementary   Regular School No Elementary KG 06 2021   grade_1 24 10 6 1   7     0   2   25 25 *                     50.0 24 10 6 1   7     0   2   25 25                 50
1672103 1672103 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst - Wildwood Elementary   Regular School No Elementary KG 06 2021   grade_2 22 6 11 0   5     0   7   26 25 *                     51.0 22 6 11 0   5     0   7   26 25                 51
1672104 1672104 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst - Wildwood Elementary   Regular School No Elementary KG 06 2021   grade_3 29 12 9 0   5     0   4   28 31 *                     59.0 29 12 9 0   5     0   4   28 31                 59
1672105 1672105 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst - Wildwood Elementary   Regular School No Elementary KG 06 2021   grade_4 27 7 11 1   8     0   0   25 29 *                     54.0 27 7 11 1   8     0   0   25 29                 54
1672106 1672106 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst - Wildwood Elementary   Regular School No Elementary KG 06 2021   grade_5 31 9 12 0   5     0   3   30 30 *                     60.0 31 9 12 0   5     0   3   30 30                 60
1672107 1672107 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst - Wildwood Elementary   Regular School No Elementary KG 06 2021   grade_6 27 4 10 0   4     0   5   32 18 *                     50.0 27 4 10 0   4     0   5   32 18                 50

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