enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,436 ✖
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
1679827 1679827 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District) - Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2021   grade_10 98 6 13 0   26     0   12   84 71 *                     155.0 98 6 13 0   26     0   12   84 71                 155
1679828 1679828 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District) - Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2021   grade_11 97 2 11 0   30     0   7   73 74 *                     147.0 97 2 11 0   30     0   7   73 74                 147
1679829 1679829 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District) - Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2021   grade_12 87 1 10 0   40     0   3   70 71 *                     141.0 87 1 10 0   40     0   3   70 71                 141
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
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
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
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
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
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
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
1679707 1679707 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   kindergarten 20 17 56 1   0     0   6   45 55 *                     100.0 20 17 56 1   0     0   6   45 55                 100
1679708 1679708 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_1 16 15 60 1   0     0   11   49 54 *                     103.0 16 15 60 1   0     0   11   49 54                 103
1679709 1679709 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_2 18 11 70 0   0     0   3   41 61 *                     102.0 18 11 70 0   0     0   3   41 61                 102
1679710 1679710 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_3 23 11 61 2   1     0   5   55 48 *                     103.0 23 11 61 2   1     0   5   55 48                 103
1679711 1679711 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_4 10 8 33 1   0     0   0   21 31 *                     52.0 10 8 33 1   0     0   0   21 31                 52
1679712 1679712 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_5 15 6 27 1   0     0   0   22 27 *                     49.0 15 6 27 1   0     0   0   22 27                 49
1679713 1679713 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_6 31 15 91 0   0     0   9   67 79 *                     146.0 31 15 91 0   0     0   9   67 79                 146
1679714 1679714 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_7 24 15 55 0   0     0   0   43 51 *                     94.0 24 15 55 0   0     0   0   43 51                 94
1679715 1679715 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District) - Alma del Mar Charter School   Regular School Yes Elementary KG 08 2021   grade_8 8 11 29 0   0     0   0   19 29 *                     48.0 8 11 29 0   0     0   0   19 29                 48
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
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
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
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
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
1680310 1680310 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst-Pelham - Amherst Regional High   Regular School No High 09 12 2021   grade_9 120 20 42 0   11     0   19   108 103 *                     212.0 120 20 42 0   11     0   19   108 103                 212
1680311 1680311 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst-Pelham - Amherst Regional High   Regular School No High 09 12 2021   grade_10 104 21 37 0   22     0   22   116 90 *                     206.0 104 21 37 0   22     0   22   116 90                 206
1680312 1680312 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst-Pelham - Amherst Regional High   Regular School No High 09 12 2021   grade_11 135 18 29 0   22     0   16   106 113 *                     220.0 135 18 29 0   22     0   16   106 113                 220
1680313 1680313 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst-Pelham - Amherst Regional High   Regular School No High 09 12 2021   grade_12 121 13 40 0   23     0   27   104 119 *                     224.0 121 13 40 0   23     0   27   104 119                 224
1680314 1680314 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst-Pelham - Amherst Regional High   Regular School No High 09 12 2021   sped_beyond_grade_12 6 0 2 0   0     0   0   3 5 *                     8.0 6 0 2 0   0     0   0   3 5                 8
1680308 1680308 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst-Pelham - Amherst Regional Middle School   Regular School No Middle 07 08 2021   grade_7 119 18 44 0   14     0   15   101 109 *                     210.0 119 18 44 0   14     0   15   101 109                 210
1680309 1680309 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst-Pelham - Amherst Regional Middle School   Regular School No Middle 07 08 2021   grade_8 101 14 40 0   26     0   22   115 88 *                     203.0 101 14 40 0   26     0   22   115 88                 203
1672148 1672148 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_9 285 19 42 0   78     0   13   209 226 *                     437.0 285 19 42 0   78     0   13   209 226                 437
1672149 1672149 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_10 312 8 25 2   78     0   12   195 242 *                     437.0 312 8 25 2   78     0   12   195 242                 437
1672150 1672150 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_11 275 9 31 2   85     0   6   193 215 *                     408.0 275 9 31 2   85     0   6   193 215                 408
1672151 1672151 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_12 304 9 25 0   97     0   11   196 249 *                     446.0 304 9 25 0   97     0   11   196 249                 446
1672152 1672152 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   sped_beyond_grade_12 22 0 3 0   3     0   0   23 5 *                     28.0 22 0 3 0   3     0   0   23 5                 28
1672142 1672142 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover - Andover West Middle   Regular School No Middle 06 08 2021   grade_6 129 5 18 0   26     0   4   89 93 *                     182.0 129 5 18 0   26     0   4   89 93                 182

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