enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
735958 735958 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   grade_2 72 2 9 0   0     0   5   44 44                       88 72 2 9 0   0     0   5   44 44                 88
735959 735959 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   grade_3 55 7 6 0   2     0   3   39 34                       73 55 7 6 0   2     0   3   39 34                 73
735960 735960 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   kindergarten 32 11 19 1   3     0   15   46 35                       81 32 11 19 1   3     0   15   46 35                 81
735961 735961 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   grade_1 43 13 20 0   6     1   9   57 35                       92 43 13 20 0   6     1   9   57 35                 92
735962 735962 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   grade_2 54 17 14 1   1     1   6   42 52                       94 54 17 14 1   1     1   6   42 52                 94
735963 735963 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   grade_3 35 16 26 0   2     0   9   56 32                       88 35 16 26 0   2     0   9   56 32                 88
735964 735964 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   kindergarten 83 2 3 2   1     0   3   43 51                       94 83 2 3 2   1     0   3   43 51                 94
735965 735965 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   grade_1 69 18 7 0   3     1   6   46 58                       104 69 18 7 0   3     1   6   46 58                 104
735966 735966 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   grade_2 118 6 5 0   2     0   4   76 59                       135 118 6 5 0   2     0   4   76 59                 135
735967 735967 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   grade_3 103 3 4 0   3     0   4   60 57                       117 103 3 4 0   3     0   4   60 57                 117
735968 735968 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No 2 04 05 2015   grade_4 302 22 35 1   4     1   24   184 205                       389 302 22 35 1   4     1   24   184 205                 389
735969 735969 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No 2 04 05 2015   grade_5 299 29 29 2   7     0   17   186 197                       383 299 29 29 2   7     0   17   186 197                 383
735970 735970 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2015   grade_6 275 28 35 3   5     2   15   209 154                       363 275 28 35 3   5     2   15   209 154                 363
735971 735971 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No 2 06 07 2015   grade_7 292 29 38 4   13     1   11   185 203                       388 292 29 38 4   13     1   11   185 203                 388
735972 735972 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_8 316 22 13 4   21     2   20   197 201                       398 316 22 13 4   21     2   20   197 201                 398
735973 735973 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_9 287 31 41 5   12     2   18   193 203                       396 287 31 41 5   12     2   18   193 203                 396
735974 735974 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_10 269 29 42 6   11     0   12   180 189                       369 269 29 42 6   11     0   12   180 189                 369
735975 735975 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_11 313 28 28 4   13     0   13   189 210                       399 313 28 28 4   13     0   13   189 210                 399
735976 735976 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_12 273 18 20 2   9     2   10   161 173                       334 273 18 20 2   9     2   10   161 173                 334
735977 735977 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   SP 12 0 0 0   0     1   2                             15 12 0 0 0   0     1   2                       15
735978 735978 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2015   kindergarten 134 12 8 0   25     1   6   95 91                       186 134 12 8 0   25     1   6   95 91                 186
735979 735979 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2015   grade_1 143 14 6 0   32     0   7   102 100                       202 143 14 6 0   32     0   7   102 100                 202
735980 735980 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2015   grade_2 138 11 8 0   21     0   1   97 82                       179 138 11 8 0   21     0   1   97 82                 179
735981 735981 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No 1 03 05 2015   grade_3 113 12 10 0   20     0   9   92 72                       164 113 12 10 0   20     0   9   92 72                 164
735982 735982 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No 1 03 05 2015   grade_4 121 11 12 0   26     0   4   89 85                       174 121 11 12 0   26     0   4   89 85                 174
735983 735983 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No 1 03 05 2015   grade_5 143 10 7 0   35     0   7   105 97                       202 143 10 7 0   35     0   7   105 97                 202
735984 735984 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No 2 06 08 2015   grade_6 109 4 13 0   12     0   7   71 74                       145 109 4 13 0   12     0   7   71 74                 145
735985 735985 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No 2 06 08 2015   grade_7 127 14 9 0   21     0   6   87 90                       177 127 14 9 0   21     0   6   87 90                 177
735986 735986 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No 2 06 08 2015   grade_8 129 12 8 0   15     1   15   96 84                       180 129 12 8 0   15     1   15   96 84                 180
735987 735987 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2015   pre_kindergarten 20 2 5 0   3     0   2   15 17                       32 20 2 5 0   3     0   2   15 17                 32
735988 735988 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2015   grade_9 159 20 11 0   30     0   10   99 131                       230 159 20 11 0   30     0   10   99 131                 230
735989 735989 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2015   grade_10 160 15 8 0   22     1   14   112 108                       220 160 15 8 0   22     1   14   112 108                 220
735990 735990 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2015   grade_11 156 14 12 1   15     0   6   109 95                       204 156 14 12 1   15     0   6   109 95                 204
735991 735991 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2015   grade_12 156 23 12 2   28     0   6   100 127                       227 156 23 12 2   28     0   6   100 127                 227
735992 735992 MA Hampshire   school 2502430 24   Belchertown 250243000136 240005 Cold Spring   Regular School No 1 PK KG 2015   kindergarten 117 2 10 0   1     0   6   76 60                       136 117 2 10 0   1     0   6   76 60                 136
735993 735993 MA Hampshire   school 2502430 24   Belchertown 250243000136 240005 Cold Spring   Regular School No 1 PK KG 2015   pre_kindergarten 26 1 0 0   2     0   0   22 7                       29 26 1 0 0   2     0   0   22 7                 29
735994 735994 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No 2 04 06 2015   grade_4 174 1 6 0   6     1   8   102 94                       196 174 1 6 0   6     1   8   102 94                 196
735995 735995 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No 2 04 06 2015   grade_5 166 0 4 0   2     1   3   93 83                       176 166 0 4 0   2     1   3   93 83                 176
735996 735996 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No 2 04 06 2015   grade_6 183 3 4 0   4     0   4   105 93                       198 183 3 4 0   4     0   4   105 93                 198
735997 735997 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No 1 01 03 2015   grade_1 161 0 5 0   2     0   3   84 87                       171 161 0 5 0   2     0   3   84 87                 171
735998 735998 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No 1 01 03 2015   grade_2 158 5 3 0   4     1   1   98 74                       172 158 5 3 0   4     1   1   98 74                 172
735999 735999 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No 1 01 03 2015   grade_3 163 1 11 0   1     0   1   77 100                       177 163 1 11 0   1     0   1   77 100                 177
736000 736000 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Jabish Middle School   Regular School No 2 07 08 2015   grade_7 181 0 10 0   2     0   2   103 92                       195 181 0 10 0   2     0   2   103 92                 195
736001 736001 MA Hampshire   school 2502430 24   Belchertown 250243001873 240025 Jabish Middle School   Regular School No 2 07 08 2015   grade_8 188 3 10 0   1     0   4   118 88                       206 188 3 10 0   1     0   4   118 88                 206
736002 736002 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2015   grade_9 169 3 5 1   2     1   3   97 87                       184 169 3 5 1   2     1   3   97 87                 184
736003 736003 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2015   grade_10 155 2 8 0   6     0   4   75 100                       175 155 2 8 0   6     0   4   75 100                 175
736004 736004 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2015   grade_11 161 1 6 0   5     0   4   90 87                       177 161 1 6 0   5     0   4   90 87                 177
736005 736005 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2015   grade_12 162 3 1 0   2     0   4   80 92                       172 162 3 1 0   2     0   4   80 92                 172
736006 736006 MA Norfolk   school 2502460 25   Bellingham 250246000670 250003 Bellingham Early Childhood Center   Regular School No 1 PK PK 2015   pre_kindergarten 93 0 0 0   0     0   0   51 42                       93 93 0 0 0   0     0   0   51 42                 93
736007 736007 MA Norfolk   school 2502460 25   Bellingham 250246000140 250009 Clara Macy Elementary   Regular School No 1 KG 04 2015   kindergarten 37 0 1 0   1     0   2   16 25                       41 37 0 1 0   1     0   2   16 25                 41
736008 736008 MA Norfolk   school 2502460 25   Bellingham 250246000140 250009 Clara Macy Elementary   Regular School No 1 KG 04 2015   grade_1 55 0 2 0   2     0   3   29 33                       62 55 0 2 0   2     0   3   29 33                 62
736009 736009 MA Norfolk   school 2502460 25   Bellingham 250246000140 250009 Clara Macy Elementary   Regular School No 1 KG 04 2015   grade_2 38 0 0 0   3     0   0   23 18                       41 38 0 0 0   3     0   0   23 18                 41
736010 736010 MA Norfolk   school 2502460 25   Bellingham 250246000140 250009 Clara Macy Elementary   Regular School No 1 KG 04 2015   grade_3 39 1 5 0   1     0   1   21 26                       47 39 1 5 0   1     0   1   21 26                 47
736011 736011 MA Norfolk   school 2502460 25   Bellingham 250246000140 250009 Clara Macy Elementary   Regular School No 1 KG 04 2015   grade_4 36 0 1 0   4     0   1   20 22                       42 36 0 1 0   4     0   1   20 22                 42
736012 736012 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 04 2015   kindergarten 78 1 1 0   2     0   1   38 45                       83 78 1 1 0   2     0   1   38 45                 83
736013 736013 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 04 2015   grade_1 70 3 0 0   1     0   0   35 39                       74 70 3 0 0   1     0   0   35 39                 74
736014 736014 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 04 2015   grade_2 82 0 2 0   5     0   0   40 49                       89 82 0 2 0   5     0   0   40 49                 89
736015 736015 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 04 2015   grade_3 79 1 2 0   7     0   1   49 41                       90 79 1 2 0   7     0   1   49 41                 90
736016 736016 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 South Elementary   Regular School No 1 KG 04 2015   grade_4 93 1 4 0   2     0   0   47 53                       100 93 1 4 0   2     0   0   47 53                 100
736017 736017 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No 1 KG 04 2015   kindergarten 52 3 1 0   2     0   1   30 29                       59 52 3 1 0   2     0   1   30 29                 59
736018 736018 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No 1 KG 04 2015   grade_1 46 1 3 0   3     0   2   23 32                       55 46 1 3 0   3     0   2   23 32                 55
736019 736019 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No 1 KG 04 2015   grade_2 39 1 4 0   5     0   1   24 26                       50 39 1 4 0   5     0   1   24 26                 50
736020 736020 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No 1 KG 04 2015   grade_3 47 0 3 0   1     0   1   28 24                       52 47 0 3 0   1     0   1   28 24                 52
736021 736021 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No 1 KG 04 2015   grade_4 33 3 2 0   1     0   0   23 16                       39 33 3 2 0   1     0   0   23 16                 39
736022 736022 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial Middle School   Regular School No 2 05 08 2015   grade_5 169 4 2 0   5     0   4   92 92                       184 169 4 2 0   5     0   4   92 92                 184
736023 736023 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial Middle School   Regular School No 2 05 08 2015   grade_6 170 4 4 0   10     0   3   115 76                       191 170 4 4 0   10     0   3   115 76                 191
736024 736024 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial Middle School   Regular School No 2 05 08 2015   grade_7 168 3 10 1   7     0   3   90 102                       192 168 3 10 1   7     0   3   90 102                 192
736025 736025 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham Memorial Middle School   Regular School No 2 05 08 2015   grade_8 154 3 2 1   6     0   1   92 75                       167 154 3 2 1   6     0   1   92 75                 167
736026 736026 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 09 12 2015   grade_9 108 4 5 1   2     0   1   64 57                       121 108 4 5 1   2     0   1   64 57                 121
736027 736027 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 09 12 2015   grade_10 130 2 6 0   4     0   1   78 65                       143 130 2 6 0   4     0   1   78 65                 143
736028 736028 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 09 12 2015   grade_11 144 3 5 1   2     0   5   95 65                       160 144 3 5 1   2     0   5   95 65                 160
736029 736029 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 09 12 2015   grade_12 159 4 3 0   7     0   2   88 87                       175 159 4 3 0   7     0   2   88 87                 175
736030 736030 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_8 5 0 1 0   0     0   0   4 2                       6 5 0 1 0   0     0   0   4 2                 6
736031 736031 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_9 8 0 0 0   0     0   0   5 3                       8 8 0 0 0   0     0   0   5 3                 8
736032 736032 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_10 7 0 0 0   0     0   0   5 2                       7 7 0 0 0   0     0   0   5 2                 7
736033 736033 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_11 * * * *   *     *   *   1 3                       4                         1 3                 4
736034 736034 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_12 5 0 1 0   0     0   0   4 2                       6 5 0 1 0   0     0   0   4 2                 6
736035 736035 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No 1 KG 04 2015   kindergarten 63 1 4 0   24     0   3   53 42                       95 63 1 4 0   24     0   3   53 42                 95
736036 736036 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No 1 KG 04 2015   grade_1 53 1 3 1   28     0   9   46 49                       95 53 1 3 1   28     0   9   46 49                 95
736037 736037 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No 1 KG 04 2015   grade_2 55 3 2 0   29     0   6   46 49                       95 55 3 2 0   29     0   6   46 49                 95
736038 736038 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No 1 KG 04 2015   grade_3 65 0 3 1   20     0   4   42 51                       93 65 0 3 1   20     0   4   42 51                 93
736039 736039 MA Middlesex   school 2502490 26   Belmont 250249000148 260005 Winn Brook   Regular School No 1 KG 04 2015   grade_4 64 2 3 0   14     0   4   45 42                       87 64 2 3 0   14     0   4   45 42                 87
736040 736040 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2015   kindergarten 54 0 2 0   11     0   4   34 37                       71 54 0 2 0   11     0   4   34 37                 71
736041 736041 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2015   grade_1 41 0 0 0   19     0   8   36 32                       68 41 0 0 0   19     0   8   36 32                 68
736042 736042 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2015   grade_2 48 1 6 0   12     1   2   36 34                       70 48 1 6 0   12     1   2   36 34                 70
736043 736043 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2015   grade_3 45 2 8 0   9     0   7   33 38                       71 45 2 8 0   9     0   7   33 38                 71
736044 736044 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No 1 KG 04 2015   grade_4 47 1 2 0   15     0   6   40 31                       71 47 1 2 0   15     0   6   40 31                 71
736045 736045 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No 1 KG 04 2015   kindergarten 44 3 3 1   15     0   6   44 28                       72 44 3 3 1   15     0   6   44 28                 72
736046 736046 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No 1 KG 04 2015   grade_1 42 2 7 1   13     0   2   31 36                       67 42 2 7 1   13     0   2   31 36                 67
736047 736047 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No 1 KG 04 2015   grade_2 39 3 3 0   16     0   5   35 31                       66 39 3 3 0   16     0   5   35 31                 66
736048 736048 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No 1 KG 04 2015   grade_3 34 1 4 0   18     0   5   36 26                       62 34 1 4 0   18     0   5   36 26                 62
736049 736049 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No 1 KG 04 2015   grade_4 43 8 2 0   17     0   4   41 33                       74 43 8 2 0   17     0   4   41 33                 74
736050 736050 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   kindergarten 89 3 0 0   13     0   10   63 52                       115 89 3 0 0   13     0   10   63 52                 115
736051 736051 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   pre_kindergarten 47 0 2 1   9     0   4   38 25                       63 47 0 2 1   9     0   4   38 25                 63
736052 736052 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   grade_1 72 2 3 0   23     0   11   64 47                       111 72 2 3 0   23     0   11   64 47                 111
736053 736053 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   grade_2 73 3 3 0   14     0   8   56 45                       101 73 3 3 0   14     0   8   56 45                 101
736054 736054 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   grade_3 94 4 8 0   9     0   6   69 52                       121 94 4 8 0   9     0   6   69 52                 121
736055 736055 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2015   grade_4 76 3 0 0   9     1   5   37 57                       94 76 3 0 0   9     1   5   37 57                 94
736056 736056 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2015   grade_5 240 9 14 0   54     0   22   165 174                       339 240 9 14 0   54     0   22   165 174                 339
736057 736057 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No 2 05 08 2015   grade_6 229 12 12 0   57     0   21   164 167                       331 229 12 12 0   57     0   21   164 167                 331

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