enrollments

Data source: Big Local News · About: Big Local

11,264 rows where state = "MA" and year = 2017 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 11,264 ✖
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
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 * * * *   *     *   *                             *                                              
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 * * * *   *     *   *                             *                                              
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 * * * *   *     *   *                             *                                              
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 * * * *   *     *   *                             *                                              
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 * * * *   *     *   *                             *                                              
1122124 1122124 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   kindergarten 51 3 2 0   13     0   0   39 30                       69 51 3 2 0   13     0   0   39 30                 69
1122125 1122125 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_1 49 1 1 0   16     2   4   33 40                       73 49 1 1 0   16     2   4   33 40                 73
1122126 1122126 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_2 49 3 1 0   10     0   6   40 29                       69 49 3 1 0   10     0   6   40 29                 69
1122127 1122127 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_3 54 3 3 0   7     0   3   36 34                       70 54 3 3 0   7     0   3   36 34                 70
1122128 1122128 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_4 45 7 4 0   8     1   3   32 36                       68 45 7 4 0   8     1   3   32 36                 68
1122129 1122129 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   grade_5 62 1 2 0   8     0   3   30 46                       76 62 1 2 0   8     0   3   30 46                 76
1122130 1122130 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122131 1122131 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   kindergarten 67 2 2 0   17     0   1   50 39                       89 67 2 2 0   17     0   1   50 39                 89
1122132 1122132 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_1 58 0 3 0   4     0   5   35 35                       70 58 0 3 0   4     0   5   35 35                 70
1122133 1122133 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_2 68 1 8 0   7     1   8   48 45                       93 68 1 8 0   7     1   8   48 45                 93
1122134 1122134 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_3 64 2 4 0   4     0   5   38 41                       79 64 2 4 0   4     0   5   38 41                 79
1122135 1122135 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_4 50 1 1 0   7     0   4   36 27                       63 50 1 1 0   7     0   4   36 27                 63
1122136 1122136 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   grade_5 60 1 4 0   10     0   7   41 41                       82 60 1 4 0   10     0   7   41 41                 82
1122137 1122137 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122138 1122138 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   kindergarten 65 0 2 0   19     0   1   47 40                       87 65 0 2 0   19     0   1   47 40                 87
1122139 1122139 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_1 59 1 3 0   5     0   2   37 33                       70 59 1 3 0   5     0   2   37 33                 70
1122140 1122140 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_2 61 1 4 0   8     0   5   37 42                       79 61 1 4 0   8     0   5   37 42                 79
1122141 1122141 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_3 61 2 6 0   6     0   4   38 41                       79 61 2 6 0   6     0   4   38 41                 79
1122142 1122142 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_4 53 3 4 0   12     1   1   40 34                       74 53 3 4 0   12     1   1   40 34                 74
1122143 1122143 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   grade_5 64 1 2 0   8     0   2   43 34                       77 64 1 2 0   8     0   2   43 34                 77
1122144 1122144 MA Middlesex   school 2501980 10   Arlington 250198000057 100025 Cyrus E Dallin   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122145 1122145 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   kindergarten 67 1 9 0   18     0   0   53 42                       95 67 1 9 0   18     0   0   53 42                 95
1122146 1122146 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_1 59 4 3 0   11     1   1   39 40                       79 59 4 3 0   11     1   1   39 40                 79
1122147 1122147 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_2 47 4 6 1   14     0   4   46 30                       76 47 4 6 1   14     0   4   46 30                 76
1122148 1122148 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_3 46 6 4 0   6     0   2   32 32                       64 46 6 4 0   6     0   2   32 32                 64
1122149 1122149 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_4 41 3 4 0   9     0   4   39 22                       61 41 3 4 0   9     0   4   39 22                 61
1122150 1122150 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   grade_5 47 4 7 0   13     1   4   36 40                       76 47 4 7 0   13     1   4   36 40                 76
1122151 1122151 MA Middlesex   school 2501980 10   Arlington 250198000058 100030 Hardy   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122152 1122152 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No Elementary PK PK 2017   pre_kindergarten 55 0 4 0   9     0   2   44 26                       70 55 0 4 0   9     0   2   44 26                 70
1122153 1122153 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Menotomy Preschool   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122154 1122154 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   kindergarten 37 1 2 0   8     0   0   28 20                       48 37 1 2 0   8     0   0   28 20                 48
1122155 1122155 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_1 35 3 1 0   7     0   1   18 29                       47 35 3 1 0   7     0   1   18 29                 47
1122156 1122156 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_2 27 3 6 0   7     0   1   19 25                       44 27 3 6 0   7     0   1   19 25                 44
1122157 1122157 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_3 38 1 4 0   2     0   0   29 16                       45 38 1 4 0   2     0   0   29 16                 45
1122158 1122158 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_4 33 2 4 0   6     0   2   19 28                       47 33 2 4 0   6     0   2   19 28                 47
1122159 1122159 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   grade_5 31 1 6 0   4     0   3   24 21                       45 31 1 6 0   4     0   3   24 21                 45
1122160 1122160 MA Middlesex   school 2501980 10   Arlington 250198000065 100045 Peirce   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122161 1122161 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   kindergarten 55 7 13 1   19     0   0   44 51                       95 55 7 13 1   19     0   0   44 51                 95
1122162 1122162 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_1 48 5 7 0   10     0   6   42 34                       76 48 5 7 0   10     0   6   42 34                 76
1122163 1122163 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_2 55 4 6 1   13     1   6   46 40                       86 55 4 6 1   13     1   6   46 40                 86
1122164 1122164 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_3 45 3 13 0   12     0   3   40 36                       76 45 3 13 0   12     0   3   40 36                 76
1122165 1122165 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_4 56 4 5 1   12     0   4   46 36                       82 56 4 5 1   12     0   4   46 36                 82
1122166 1122166 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   grade_5 30 2 6 0   9     0   4   24 27                       51 30 2 6 0   9     0   4   24 27                 51
1122167 1122167 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122168 1122168 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   kindergarten 39 3 3 0   23     0   0   41 27                       68 39 3 3 0   23     0   0   41 27                 68
1122169 1122169 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_1 45 3 7 0   14     0   5   33 41                       74 45 3 7 0   14     0   5   33 41                 74
1122170 1122170 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_2 44 0 4 0   8     0   2   31 27                       58 44 0 4 0   8     0   2   31 27                 58
1122171 1122171 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_3 48 3 3 0   7     0   4   34 31                       65 48 3 3 0   7     0   4   34 31                 65
1122172 1122172 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_4 48 0 4 0   10     0   5   32 35                       67 48 0 4 0   10     0   5   32 35                 67
1122173 1122173 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   grade_5 47 1 4 0   10     0   2   26 38                       64 47 1 4 0   10     0   2   26 38                 64
1122174 1122174 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122175 1122175 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   grade_6 306 21 22 0   45     0   27   188 233                       421 306 21 22 0   45     0   27   188 233                 421
1122176 1122176 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   grade_7 302 16 22 0   48     0   21   201 208                       409 302 16 22 0   48     0   21   201 208                 409
1122177 1122177 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   grade_8 302 14 22 0   28     0   12   179 199                       378 302 14 22 0   28     0   12   179 199                 378
1122178 1122178 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122179 1122179 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2017   grade_9 252 15 20 0   35     1   9   175 157                       332 252 15 20 0   35     1   9   175 157                 332
1122180 1122180 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2017   grade_10 244 16 26 0   42     0   22   157 193                       350 244 16 26 0   42     0   22   157 193                 350
1122181 1122181 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2017   grade_11 252 15 14 0   25     1   5   160 152                       312 252 15 14 0   25     1   5   160 152                 312
1122182 1122182 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2017   grade_12 226 7 13 0   36     1   12   142 153                       295 226 7 13 0   36     1   12   142 153                 295
1122183 1122183 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124958 1124958 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Juniper Hill School   Regular School No Elementary PK PK 2017   pre_kindergarten 134 17 56 0   14     0   13   124 110                       234 134 17 56 0   14     0   13   124 110                 234
1124959 1124959 MA Middlesex   school 2504980 100   Framingham 250498002820 1000001 Juniper Hill School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124960 1124960 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 02 2017   kindergarten 53 8 2 0   12     0   6   47 34                       81 53 8 2 0   12     0   6   47 34                 81
1124961 1124961 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 02 2017   grade_1 51 3 19 0   9     0   8   48 42                       90 51 3 19 0   9     0   8   48 42                 90
1124962 1124962 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 02 2017   grade_2 49 5 13 0   7     0   5   47 32                       79 49 5 13 0   7     0   5   47 32                 79
1124963 1124963 MA Middlesex   school 2504980 100   Framingham 250498002823 1000005 King Elementary School   Regular School No Elementary KG 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124964 1124964 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   kindergarten 21 5 30 0   2     0   1   25 34                       59 21 5 30 0   2     0   1   25 34                 59
1124965 1124965 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   grade_1 26 6 40 0   3     0   1   34 42                       76 26 6 40 0   3     0   1   34 42                 76
1124966 1124966 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   grade_2 25 4 49 0   4     0   1   42 41                       83 25 4 49 0   4     0   1   42 41                 83
1124967 1124967 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   grade_3 32 6 56 0   8     0   1   50 53                       103 32 6 56 0   8     0   1   50 53                 103
1124968 1124968 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   grade_4 33 7 47 0   4     0   3   45 49                       94 33 7 47 0   4     0   3   45 49                 94
1124969 1124969 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   grade_5 30 11 53 0   2     0   4   56 44                       100 30 11 53 0   2     0   4   56 44                 100
1124970 1124970 MA Middlesex   school 2504980 100   Framingham 250498000714 1000006 Brophy   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124971 1124971 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2017   kindergarten 43 3 7 0   9     0   2   44 20                       64 43 3 7 0   9     0   2   44 20                 64
1124972 1124972 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2017   grade_1 50 7 4 0   9     0   2   37 35                       72 50 7 4 0   9     0   2   37 35                 72
1124973 1124973 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2017   grade_2 46 4 9 0   13     0   0   30 42                       72 46 4 9 0   13     0   0   30 42                 72
1124974 1124974 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2017   grade_3 65 4 12 0   12     0   4   46 51                       97 65 4 12 0   12     0   4   46 51                 97
1124975 1124975 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2017   grade_4 52 2 13 0   13     0   7   51 36                       87 52 2 13 0   13     0   7   51 36                 87
1124976 1124976 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2017   grade_5 63 4 9 0   8     0   3   53 34                       87 63 4 9 0   8     0   3   53 34                 87
1124977 1124977 MA Middlesex   school 2504980 100   Framingham 250498000716 1000007 Charlotte A Dunning   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124978 1124978 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2017   kindergarten 66 2 14 0   8     0   2   45 47                       92 66 2 14 0   8     0   2   45 47                 92

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