enrollments

Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
2228754 2228754 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington: Abington Early Education Program   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 70 9 1 0   4     0   0   45 39                       84.0 70 9 1 0   4     0   0   45 39                 84
2228755 2228755 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington: Abington Early Education Program   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2039810 2039810 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 71 9 9 0   1     0   0   45 45                       90.0 71 9 9 0   1     0   0   45 45                 90
1364784 1364784 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington Early Education Program   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 68 9 7 0   4     0   0   43 45 *                     88.0 68 9 7 0   4     0   0   43 45                 88
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
735658 735658 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No 1 PK KG 2015   kindergarten 138 2 3 2   3     0   0   80 68                       148 138 2 3 2   3     0   0   80 68                 148
735659 735659 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No 1 PK KG 2015   pre_kindergarten 71 1 1 0   3     0   0   48 28                       76 71 1 1 0   3     0   0   48 28                 76
932536 932536 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No 1 PK KG 2016   kindergarten 98 2 7 0   1     0   2   50 60                       110 98 2 7 0   1     0   2   50 60                 110
932537 932537 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No 1 PK KG 2016   pre_kindergarten 63 2 5 0   1     0   1   41 31                       72 63 2 5 0   1     0   1   41 31                 72
1121946 1121946 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   kindergarten 115 5 12 0   2     0   0   73 61                       134 115 5 12 0   2     0   0   73 61                 134
1121947 1121947 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   pre_kindergarten 57 3 5 0   4     0   0   37 32                       69 57 3 5 0   4     0   0   37 32                 69
1121948 1121948 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
735660 735660 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_1 117 3 7 1   3     0   0   72 59                       131 117 3 7 1   3     0   0   72 59                 131
735661 735661 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_2 133 1 5 1   3     0   0   78 65                       143 133 1 5 1   3     0   0   78 65                 143
735662 735662 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_3 168 0 5 0   1     0   0   90 84                       174 168 0 5 0   1     0   0   90 84                 174
735663 735663 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2015   grade_4 162 6 0 1   3     0   0   81 91                       172 162 6 0 1   3     0   0   81 91                 172
932538 932538 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2016   grade_1 151 4 6 0   1     0   3   88 77                       165 151 4 6 0   1     0   3   88 77                 165
932539 932539 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2016   grade_2 124 4 8 0   1     0   3   72 68                       140 124 4 8 0   1     0   3   72 68                 140
932540 932540 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2016   grade_3 135 1 5 0   1     0   3   77 68                       145 135 1 5 0   1     0   3   77 68                 145
932541 932541 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No 1 01 04 2016   grade_4 169 4 8 0   0     0   2   98 85                       183 169 4 8 0   0     0   2   98 85                 183
1121949 1121949 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_1 109 1 10 1   3     1   0   52 73                       125 109 1 10 1   3     1   0   52 73                 125
1121950 1121950 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_2 147 3 11 0   3     0   0   89 75                       164 147 3 11 0   3     0   0   89 75                 164
1121951 1121951 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_3 127 5 11 1   3     0   1   77 71                       148 127 5 11 1   3     0   1   77 71                 148
1121952 1121952 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   grade_4 130 2 7 1   2     0   1   73 70                       143 130 2 7 1   2     0   1   73 70                 143
1121953 1121953 MA Plymouth   school 2501650 1   Abington 250165000434 10003 Beaver Brook Elementary School   Regular School No Elementary 01 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
735664 735664 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2015   grade_5 146 1 6 0   3     0   0   84 72                       156 146 1 6 0   3     0   0   84 72                 156
735665 735665 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2015   grade_6 158 7 6 1   2     0   0   94 80                       174 158 7 6 1   2     0   0   94 80                 174
932542 932542 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2016   grade_5 157 8 3 0   2     0   3   83 90                       173 157 8 3 0   2     0   3   83 90                 173
932543 932543 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2016   grade_6 149 1 7 0   0     0   4   86 75                       161 149 1 7 0   0     0   4   86 75                 161
1121954 1121954 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   grade_5 169 1 7 0   3     0   0   97 83                       180 169 1 7 0   3     0   0   97 83                 180
1121955 1121955 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   grade_6 156 6 8 0   2     0   1   82 91                       173 156 6 8 0   2     0   1   82 91                 173
1121956 1121956 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2228756 2228756 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington: Woodsdale Elementary School   Regular School No Elementary 03 04 2018   grade_3 146 3 15 0   3     0   1   92 76                       168.0 146 3 15 0   3     0   1   92 76                 168
2228757 2228757 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington: Woodsdale Elementary School   Regular School No Elementary 03 04 2018   grade_4 129 5 13 1   2     0   1   79 72                       151.0 129 5 13 1   2     0   1   79 72                 151
2228758 2228758 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington: Woodsdale Elementary School   Regular School No Elementary 03 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2039811 2039811 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2019   grade_3 108 5 8 0   5     1   2   55 74                       129.0 108 5 8 0   5     1   2   55 74                 129
2039812 2039812 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2019   grade_4 143 3 13 0   4     0   2   93 72                       165.0 143 3 13 0   4     0   2   93 72                 165
1364785 1364785 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2020   grade_3 135 6 21 0   2     1   0   81 84 *                     165.0 135 6 21 0   2     1   0   81 84                 165
1364786 1364786 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Elementary 03 04 2020   grade_4 110 7 11 0   5     0   3   61 75 *                     136.0 110 7 11 0   5     0   3   61 75                 136
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
2228759 2228759 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   kindergarten 113 6 13 2   3     0   0   67 70                       137.0 113 6 13 2   3     0   0   67 70                 137
2228760 2228760 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   grade_1 132 5 17 0   1     0   0   82 73                       155.0 132 5 17 0   1     0   0   82 73                 155
2228761 2228761 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   grade_2 113 4 8 0   5     1   1   59 73                       132.0 113 4 8 0   5     1   1   59 73                 132
2228762 2228762 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2039813 2039813 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   kindergarten 130 10 5 1   6     0   1   79 74                       153.0 130 10 5 1   6     0   1   79 74                 153
2039814 2039814 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_1 119 7 9 3   3     0   1   66 76                       142.0 119 7 9 3   3     0   1   66 76                 142
2039815 2039815 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_2 133 5 19 1   2     0   0   85 75                       160.0 133 5 19 1   2     0   0   85 75                 160
1364787 1364787 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   kindergarten 131 9 22 1   4     0   2   82 86 *                     169.0 131 9 22 1   4     0   2   82 86                 169
1364788 1364788 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_1 130 9 9 3   5     0   1   80 77 *                     157.0 130 9 9 3   5     0   1   80 77                 157
1364789 1364789 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_2 119 10 10 2   3     0   1   68 77 *                     145.0 119 10 10 2   3     0   1   68 77                 145
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
735666 735666 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No 2 07 08 2015   grade_7 146 2 4 0   2     0   2   77 79                       156 146 2 4 0   2     0   2   77 79                 156
735667 735667 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No 2 07 08 2015   grade_8 131 6 7 0   4     1   0   74 75                       149 131 6 7 0   4     1   0   74 75                 149
932544 932544 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No 2 07 08 2016   grade_7 150 7 8 0   1     0   3   90 79                       169 150 7 8 0   1     0   3   90 79                 169
932545 932545 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No 2 07 08 2016   grade_8 147 2 7 0   2     0   7   81 84                       165 147 2 7 0   2     0   7   81 84                 165
1121957 1121957 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   grade_7 142 2 9 0   5     0   1   84 75                       159 142 2 9 0   5     0   1   84 75                 159
1121958 1121958 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   grade_8 151 6 11 0   1     0   0   91 78                       169 151 6 11 0   1     0   0   91 78                 169
1121959 1121959 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2228763 2228763 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_5 138 1 8 1   3     0   3   80 74                       154.0 138 1 8 1   3     0   3   80 74                 154
2228764 2228764 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_6 173 2 10 0   3     0   0   106 82                       188.0 173 2 10 0   3     0   0   106 82                 188
2228765 2228765 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_7 155 7 12 0   2     0   2   85 93                       178.0 155 7 12 0   2     0   2   85 93                 178
2228766 2228766 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_8 144 5 12 0   5     0   1   84 83                       167.0 144 5 12 0   5     0   1   84 83                 167
2228767 2228767 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2039816 2039816 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_5 134 4 14 2   4     0   1   85 74                       159.0 134 4 14 2   4     0   1   85 74                 159
2039817 2039817 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_6 136 1 10 1   2     0   4   80 74                       154.0 136 1 10 1   2     0   4   80 74                 154
2039818 2039818 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_7 170 2 12 0   3     0   0   104 83                       187.0 170 2 12 0   3     0   0   104 83                 187
2039819 2039819 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_8 147 7 12 0   3     0   3   83 89                       172.0 147 7 12 0   3     0   3   83 89                 172
1364790 1364790 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_5 138 5 16 0   5     0   3   96 71 *                     167.0 138 5 16 0   5     0   3   96 71                 167
1364791 1364791 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_6 137 6 20 2   4     0   3   92 80 *                     172.0 137 6 20 2   4     0   3   92 80                 172
1364792 1364792 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_7 139 3 12 1   4     0   5   86 78 *                     164.0 139 3 12 1   4     0   5   86 78                 164
1364793 1364793 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_8 164 6 14 0   3     0   0   106 81 *                     187.0 164 6 14 0   3     0   0   106 81                 187
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
735668 735668 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_9 113 1 15 0   0     0   2   61 70                       131 113 1 15 0   0     0   2   61 70                 131
735669 735669 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_10 82 3 10 0   0     0   1   46 50                       96 82 3 10 0   0     0   1   46 50                 96
735670 735670 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_11 105 6 2 0   2     0   2   59 58                       117 105 6 2 0   2     0   2   59 58                 117
735671 735671 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_12 117 1 8 0   2     0   0   57 71                       128 117 1 8 0   2     0   0   57 71                 128
735672 735672 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             5                                             5
932546 932546 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2016   grade_9 93 6 6 0   0     1   4   51 59                       110 93 6 6 0   0     1   4   51 59                 110
932547 932547 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2016   grade_10 107 2 14 0   0     0   3   60 66                       126 107 2 14 0   0     0   3   60 66                 126
932548 932548 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2016   grade_11 83 2 11 0   0     0   0   44 52                       96 83 2 11 0   0     0   0   44 52                 96
932549 932549 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2016   grade_12 100 7 2 0   0     0   5   55 59                       114 100 7 2 0   0     0   5   55 59                 114
932550 932550 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   2 3                       5                         2 3                 5
1121960 1121960 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_9 106 3 8 1   4     0   2   55 69                       124 106 3 8 1   4     0   2   55 69                 124
1121961 1121961 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_10 91 4 10 0   3     1   0   50 59                       109 91 4 10 0   3     1   0   50 59                 109
1121962 1121962 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_11 105 1 15 0   0     0   2   59 64                       123 105 1 15 0   0     0   2   59 64                 123
1121963 1121963 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_12 82 2 8 0   0     0   0   41 51                       92 82 2 8 0   0     0   0   41 51                 92
1121964 1121964 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2228768 2228768 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   grade_9 126 7 17 1   1     0   1   81 72                       153.0 126 7 17 1   1     0   1   81 72                 153
2228769 2228769 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   grade_10 109 3 11 1   4     0   2   58 72                       130.0 109 3 11 1   4     0   2   58 72                 130
2228770 2228770 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   grade_11 91 5 9 0   5     1   0   50 61                       111.0 91 5 9 0   5     1   0   50 61                 111
2228771 2228771 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   grade_12 105 2 14 0   0     0   2   59 64                       123.0 105 2 14 0   0     0   2   59 64                 123
2228772 2228772 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2039820 2039820 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_9 134 8 12 0   4     0   1   82 77                       159.0 134 8 12 0   4     0   1   82 77                 159
2039821 2039821 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_10 127 6 13 0   2     0   1   79 70                       149.0 127 6 13 0   2     0   1   79 70                 149

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