enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 11,164 ✖
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
1127310 1127310 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   grade_5 72 12 35 1   1     0   6   76 51                       127 72 12 35 1   1     0   6   76 51                 127
1127311 1127311 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128499 1128499 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   kindergarten 36 2 40 0   2     0   2   40 42                       82 36 2 40 0   2     0   2   40 42                 82
1128500 1128500 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   pre_kindergarten 51 4 24 0   12     0   3   49 45                       94 51 4 24 0   12     0   3   49 45                 94
1128501 1128501 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   grade_1 47 7 45 0   1     0   0   57 43                       100 47 7 45 0   1     0   0   57 43                 100
1128502 1128502 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   grade_2 31 3 42 0   2     0   0   34 44                       78 31 3 42 0   2     0   0   34 44                 78
1128503 1128503 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   grade_3 45 6 50 0   6     0   1   50 58                       108 45 6 50 0   6     0   1   50 58                 108
1128504 1128504 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   grade_4 54 3 52 0   6     0   2   62 55                       117 54 3 52 0   6     0   2   62 55                 117
1128505 1128505 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   grade_5 43 7 35 0   3     0   2   50 40                       90 43 7 35 0   3     0   2   50 40                 90
1128506 1128506 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130455 1130455 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2017   kindergarten 46 1 3 0   9     0   2   36 25                       61 46 1 3 0   9     0   2   36 25                 61
1130456 1130456 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2017   grade_1 44 4 1 0   1     0   3   29 24                       53 44 4 1 0   1     0   3   29 24                 53
1130457 1130457 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2017   grade_2 45 2 7 0   4     0   2   27 33                       60 45 2 7 0   4     0   2   27 33                 60
1130458 1130458 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2017   grade_3 62 3 9 0   6     0   0   44 36                       80 62 3 9 0   6     0   0   44 36                 80
1130459 1130459 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2017   grade_4 42 2 10 0   8     0   1   37 26                       63 42 2 10 0   8     0   1   37 26                 63
1130460 1130460 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131125 1131125 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_5 5 41 32 0   1     0   0   35 44                       79 5 41 32 0   1     0   0   35 44                 79
1131126 1131126 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_6 5 40 26 0   0     0   6   39 38                       77 5 40 26 0   0     0   6   39 38                 77
1131127 1131127 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_7 13 47 20 0   1     0   0   37 44                       81 13 47 20 0   1     0   0   37 44                 81
1131128 1131128 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_8 4 53 20 0   1     0   1   40 39                       79 4 53 20 0   1     0   1   40 39                 79
1131129 1131129 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_9 5 45 11 0   1     0   2   35 29                       64 5 45 11 0   1     0   2   35 29                 64
1131130 1131130 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_10 6 29 14 0   1     1   4   29 26                       55 6 29 14 0   1     1   4   29 26                 55
1131131 1131131 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_11 5 26 11 0   0     0   1   17 26                       43 5 26 11 0   0     0   1   17 26                 43
1131132 1131132 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_12 12 25 10 0   0     0   2   18 31                       49 12 25 10 0   0     0   2   18 31                 49
1131133 1131133 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131737 1131737 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   grade_9 270 9 12 1   138     0   18   224 224                       448 270 9 12 1   138     0   18   224 224                 448
1131738 1131738 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   grade_10 297 7 18 0   153     0   17   258 234                       492 297 7 18 0   153     0   17   258 234                 492
1131739 1131739 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   grade_11 291 8 13 2   117     0   25   224 232                       456 291 8 13 2   117     0   25   224 232                 456
1131740 1131740 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   grade_12 316 4 21 0   117     0   9   236 231                       467 316 4 21 0   117     0   9   236 231                 467
1131741 1131741 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121965 1121965 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   kindergarten 75 1 4 1   0     0   3   43 41                       84 75 1 4 1   0     0   3   43 41                 84
1121966 1121966 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   pre_kindergarten 43 2 2 0   1     0   2   25 25                       50 43 2 2 0   1     0   2   25 25                 50
1121967 1121967 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_1 88 0 4 0   0     0   7   55 44                       99 88 0 4 0   0     0   7   55 44                 99
1121968 1121968 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_2 92 1 6 0   0     0   3   44 58                       102 92 1 6 0   0     0   3   44 58                 102
1121969 1121969 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_3 107 0 0 0   0     0   0   62 45                       107 107 0 0 0   0     0   0   62 45                 107
1121970 1121970 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_4 94 0 2 0   0     0   0   57 39                       96 94 0 2 0   0     0   0   57 39                 96
1121971 1121971 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124616 1124616 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Adams School   Regular School No Elementary PK PK 2017   pre_kindergarten 62 34 92 0   17     0   4   120 89                       209 62 34 92 0   17     0   4   120 89                 209
1124617 1124617 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Adams School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131222 1131222 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_6 106 4 11 0   20     0   13   84 70                       154 106 4 11 0   20     0   13   84 70                 154
1131223 1131223 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_7 103 3 9 0   27     0   9   71 80                       151 103 3 9 0   27     0   9   71 80                 151
1131224 1131224 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_8 101 1 10 0   32     0   5   73 76                       149 101 1 10 0   32     0   5   73 76                 149
1131225 1131225 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_9 97 5 5 1   26     0   8   84 58                       142 97 5 5 1   26     0   8   84 58                 142
1131226 1131226 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_10 86 4 2 1   22     0   11   55 71                       126 86 4 2 1   22     0   11   55 71                 126
1131227 1131227 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_11 73 3 6 0   18     0   5   63 42                       105 73 3 6 0   18     0   5   63 42                 105
1131228 1131228 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   grade_12 71 3 12 1   38     0   0   62 63                       125 71 3 12 1   38     0   0   62 63                 125
1131229 1131229 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121977 1121977 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten 108 7 19 0   13     0   4   87 64                       151 108 7 19 0   13     0   4   87 64                 151
1121978 1121978 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122011 1122011 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_9 272 3 14 0   6     0   4   151 148                       299 272 3 14 0   6     0   4   151 148                 299
1122012 1122012 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_10 270 6 20 0   7     0   6   164 145                       309 270 6 20 0   7     0   6   164 145                 309
1122013 1122013 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_11 257 5 16 0   6     1   8   159 134                       293 257 5 16 0   6     1   8   159 134                 293
1122014 1122014 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_12 280 1 21 0   8     0   5   158 157                       315 280 1 21 0   8     0   5   158 157                 315
1122015 1122015 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   sped_beyond_grade_12 6 0 0 0   0     0   0                             6 6 0 0 0   0     0   0                       6
1122008 1122008 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2017   grade_7 211 5 21 0   7     0   9   122 131                       253 211 5 21 0   7     0   9   122 131                 253
1122009 1122009 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2017   grade_8 278 3 19 0   1     0   8   147 162                       309 278 3 19 0   1     0   8   147 162                 309
1122010 1122010 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121972 1121972 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_5 103 1 0 0   0     0   1   58 47                       105 103 1 0 0   0     0   1   58 47                 105
1121973 1121973 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_6 119 0 1 0   0     0   1   61 60                       121 119 0 1 0   0     0   1   61 60                 121
1121974 1121974 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_7 73 0 3 0   0     0   1   42 35                       77 73 0 3 0   0     0   1   42 35                 77
1121975 1121975 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_8 111 2 0 0   1     0   0   51 63                       114 111 2 0 0   1     0   0   51 63                 114
1121976 1121976 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128965 1128965 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   kindergarten 19 0 11 0   8     0   2   20 20                       40 19 0 11 0   8     0   2   20 20                 40
1128966 1128966 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   pre_kindergarten 12 0 3 0   2     0   0   4 13                       17 12 0 3 0   2     0   0   4 13                 17
1128967 1128967 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   grade_1 37 6 38 0   4     0   5   48 42                       90 37 6 38 0   4     0   5   48 42                 90
1128968 1128968 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   grade_2 28 7 38 0   15     0   5   56 37                       93 28 7 38 0   15     0   5   56 37                 93
1128969 1128969 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   grade_3 27 6 31 0   4     0   2   30 40                       70 27 6 31 0   4     0   2   30 40                 70
1128970 1128970 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   grade_4 33 4 35 0   6     0   2   46 34                       80 33 4 35 0   6     0   2   46 34                 80
1128971 1128971 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   grade_5 16 2 16 0   5     0   3   21 21                       42 16 2 16 0   5     0   3   21 21                 42
1128972 1128972 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   grade_6 22 2 18 0   5     0   0   26 21                       47 22 2 18 0   5     0   0   26 21                 47
1128973 1128973 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   grade_7 18 2 19 0   7     0   2   20 28                       48 18 2 19 0   7     0   2   20 28                 48
1128974 1128974 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   grade_8 19 3 13 0   2     0   0   17 20                       37 19 3 13 0   2     0   0   17 20                 37
1128975 1128975 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129038 1129038 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2017   grade_2 87 1 5 0   25     0   9   65 62                       127 87 1 5 0   25     0   9   65 62                 127
1129039 1129039 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2017   grade_3 78 3 12 0   20     0   5   59 59                       118 78 3 12 0   20     0   5   59 59                 118
1129040 1129040 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124252 1124252 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2017   kindergarten 43 5 8 0   7     0   4   35 32                       67 43 5 8 0   7     0   4   35 32                 67
1124253 1124253 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2017   pre_kindergarten 3 1 1 0   0     0   1   4 2                       6 3 1 1 0   0     0   1   4 2                 6
1124254 1124254 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2017   grade_1 57 7 12 0   9     0   5   50 40                       90 57 7 12 0   9     0   5   50 40                 90
1124255 1124255 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2017   grade_2 53 7 4 0   4     0   7   37 38                       75 53 7 4 0   4     0   7   37 38                 75
1124256 1124256 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2017   grade_3 58 7 9 0   5     0   2   38 43                       81 58 7 9 0   5     0   2   38 43                 81
1124257 1124257 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2017   grade_4 61 4 6 0   6     0   6   43 40                       83 61 4 6 0   6     0   6   43 40                 83
1124258 1124258 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2017   grade_5 46 6 7 1   4     0   7   29 42                       71 46 6 7 1   4     0   7   29 42                 71
1124259 1124259 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124474 1124474 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2017   grade_3 209 1 9 0   2     0   4   118 107                       225 209 1 9 0   2     0   4   118 107                 225
1124475 1124475 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2017   grade_4 226 0 5 1   3     0   7   111 131                       242 226 0 5 1   3     0   7   111 131                 242
1124476 1124476 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2017   grade_5 220 0 3 0   5     0   11   118 121                       239 220 0 3 0   5     0   11   118 121                 239
1124477 1124477 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125778 1125778 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_3 3 2 84 0   1     0   0   43 47                       90 3 2 84 0   1     0   0   43 47                 90
1125779 1125779 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_4 7 0 67 0   1     0   0   35 40                       75 7 0 67 0   1     0   0   35 40                 75
1125780 1125780 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_5 4 2 80 0   2     0   0   48 40                       88 4 2 80 0   2     0   0   48 40                 88
1125781 1125781 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_6 6 0 88 0   3     0   0   48 49                       97 6 0 88 0   3     0   0   48 49                 97
1125782 1125782 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_7 2 2 75 0   0     0   0   39 40                       79 2 2 75 0   0     0   0   39 40                 79
1125783 1125783 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_8 1 1 80 0   3     0   0   44 41                       85 1 1 80 0   3     0   0   44 41                 85
1125784 1125784 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129208 1129208 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   kindergarten 5 15 23 0   0     0   3   26 20                       46 5 15 23 0   0     0   3   26 20                 46
1129209 1129209 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   pre_kindergarten 17 17 38 0   0     0   4   32 44                       76 17 17 38 0   0     0   4   32 44                 76
1129210 1129210 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   grade_1 8 9 20 0   0     0   0   18 19                       37 8 9 20 0   0     0   0   18 19                 37
1129211 1129211 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   grade_2 8 12 19 0   0     0   2   21 20                       41 8 12 19 0   0     0   2   21 20                 41
1129212 1129212 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   grade_3 8 7 28 0   0     0   0   23 20                       43 8 7 28 0   0     0   0   23 20                 43

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