enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1122259 1122259 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2017   kindergarten 88 1 4 0   2     0   5   51 49                       100 88 1 4 0   2     0   5   51 49                 100
1122260 1122260 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2017   grade_1 77 1 14 2   1     0   3   53 45                       98 77 1 14 2   1     0   3   53 45                 98
1122261 1122261 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2017   grade_2 67 2 11 0   6     0   2   45 43                       88 67 2 11 0   6     0   2   45 43                 88
1122262 1122262 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122263 1122263 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary KG 02 2017   kindergarten 75 4 5 0   4     0   7   45 50                       95 75 4 5 0   4     0   7   45 50                 95
1122264 1122264 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary KG 02 2017   grade_1 77 2 8 0   4     0   2   53 40                       93 77 2 8 0   4     0   2   53 40                 93
1122265 1122265 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary KG 02 2017   grade_2 76 2 10 0   3     0   2   49 44                       93 76 2 10 0   3     0   2   49 44                 93
1122266 1122266 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary KG 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122267 1122267 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2017   grade_3 160 4 12 0   5     0   7   78 110                       188 160 4 12 0   5     0   7   78 110                 188
1122268 1122268 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2017   grade_4 142 1 16 0   6     0   7   91 81                       172 142 1 16 0   6     0   7   91 81                 172
1122269 1122269 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2017   grade_5 149 3 13 0   7     0   5   96 81                       177 149 3 13 0   7     0   5   96 81                 177
1122270 1122270 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122271 1122271 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2017   grade_6 174 4 15 1   9     0   3   114 92                       206 174 4 15 1   9     0   3   114 92                 206
1122272 1122272 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2017   grade_7 179 3 14 0   5     0   9   105 105                       210 179 3 14 0   5     0   9   105 105                 210
1122273 1122273 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2017   grade_8 181 4 5 1   12     0   5   97 111                       208 181 4 5 1   12     0   5   97 111                 208
1122274 1122274 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122275 1122275 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2017   pre_kindergarten 72 2 5 0   6     0   3   45 43                       88 72 2 5 0   6     0   3   45 43                 88
1122276 1122276 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2017   grade_9 138 4 16 1   8     0   7   87 87                       174 138 4 16 1   8     0   7   87 87                 174
1122277 1122277 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2017   grade_10 168 5 8 0   11     0   5   97 100                       197 168 5 8 0   11     0   5   97 100                 197
1122278 1122278 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2017   grade_11 149 4 14 0   5     0   3   79 96                       175 149 4 14 0   5     0   3   79 96                 175
1122279 1122279 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2017   grade_12 137 2 8 2   4     0   4   72 85                       157 137 2 8 2   4     0   4   72 85                 157
1122280 1122280 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122442 1122442 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   kindergarten 26 1 0 0   1     0   0   14 14                       28 26 1 0 0   1     0   0   14 14                 28
1122443 1122443 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   pre_kindergarten 15 0 1 0   1     0   1   9 9                       18 15 0 1 0   1     0   1   9 9                 18
1122444 1122444 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   grade_1 28 0 2 1   0     0   2   18 15                       33 28 0 2 1   0     0   2   18 15                 33
1122445 1122445 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   grade_2 20 0 0 0   0     0   0   14 6                       20 20 0 0 0   0     0   0   14 6                 20
1122446 1122446 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   grade_3 23 0 2 0   1     0   0   16 10                       26 23 0 2 0   1     0   0   16 10                 26
1122447 1122447 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   grade_4 27 0 1 0   0     0   1   14 15                       29 27 0 1 0   0     0   1   14 15                 29
1122448 1122448 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   grade_5 30 0 1 0   1     0   4   24 12                       36 30 0 1 0   1     0   4   24 12                 36
1122449 1122449 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123494 1123494 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2017   kindergarten 23 0 1 2   2     0   3   15 16                       31 23 0 1 2   2     0   3   15 16                 31
1123495 1123495 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 26 0 1 0   1     0   1   16 13                       29 26 0 1 0   1     0   1   16 13                 29
1123496 1123496 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2017   grade_1 37 0 2 0   2     0   2   24 19                       43 37 0 2 0   2     0   2   24 19                 43
1123497 1123497 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2017   grade_2 32 0 1 0   2     0   1   12 24                       36 32 0 1 0   2     0   1   12 24                 36
1123498 1123498 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2017   grade_3 40 0 2 0   1     0   2   22 23                       45 40 0 2 0   1     0   2   22 23                 45
1123499 1123499 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2017   grade_4 46 2 1 0   4     0   2   25 30                       55 46 2 1 0   4     0   2   25 30                 55
1123500 1123500 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2017   grade_5 48 2 2 0   2     0   0   27 27                       54 48 2 2 0   2     0   0   27 27                 54
1123501 1123501 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1123713 1123713 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   kindergarten 37 0 2 1   0     0   1   23 18                       41 37 0 2 1   0     0   1   23 18                 41
1123714 1123714 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 26 1 1 0   0     0   3   15 16                       31 26 1 1 0   0     0   3   15 16                 31
1123715 1123715 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_1 38 0 2 0   0     0   0   19 21                       40 38 0 2 0   0     0   0   19 21                 40
1123716 1123716 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_2 37 0 0 0   0     0   2   19 20                       39 37 0 0 0   0     0   2   19 20                 39
1123717 1123717 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_3 33 0 3 0   0     0   2   16 22                       38 33 0 3 0   0     0   2   16 22                 38
1123718 1123718 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_4 33 0 1 0   0     0   5   19 20                       39 33 0 1 0   0     0   5   19 20                 39
1123719 1123719 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_5 40 0 1 0   0     0   1   24 18                       42 40 0 1 0   0     0   1   24 18                 42
1123720 1123720 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_6 44 0 3 0   0     0   1   22 26                       48 44 0 3 0   0     0   1   22 26                 48
1123721 1123721 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124217 1124217 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 03 2017   kindergarten 94 6 34 0   2     0   3   66 73                       139 94 6 34 0   2     0   3   66 73                 139
1124218 1124218 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 03 2017   pre_kindergarten 68 1 25 0   0     0   1   59 36                       95 68 1 25 0   0     0   1   59 36                 95
1124219 1124219 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 03 2017   grade_1 102 4 28 0   2     0   3   70 69                       139 102 4 28 0   2     0   3   70 69                 139
1124220 1124220 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 03 2017   grade_2 102 5 37 0   1     0   2   75 72                       147 102 5 37 0   1     0   2   75 72                 147
1124221 1124221 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 03 2017   grade_3 142 5 31 0   3     0   5   102 84                       186 142 5 31 0   3     0   5   102 84                 186
1124222 1124222 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124223 1124223 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_4 116 10 35 0   2     0   3   97 69                       166 116 10 35 0   2     0   3   97 69                 166
1124224 1124224 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_5 104 2 37 0   2     0   0   77 68                       145 104 2 37 0   2     0   0   77 68                 145
1124225 1124225 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_6 93 5 24 0   1     0   0   74 49                       123 93 5 24 0   1     0   0   74 49                 123
1124226 1124226 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_7 90 4 30 0   1     0   2   70 57                       127 90 4 30 0   1     0   2   70 57                 127
1124227 1124227 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_8 93 12 28 0   2     0   4   70 69                       139 93 12 28 0   2     0   4   70 69                 139
1124228 1124228 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124229 1124229 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2017   pre_kindergarten 20 1 5 0   0     0   0   17 9                       26 20 1 5 0   0     0   0   17 9                 26
1124230 1124230 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2017   grade_9 72 7 33 0   2     0   1   66 49                       115 72 7 33 0   2     0   1   66 49                 115
1124231 1124231 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2017   grade_10 71 4 30 0   5     0   0   55 55                       110 71 4 30 0   5     0   0   55 55                 110
1124232 1124232 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2017   grade_11 69 4 34 1   1     0   1   51 59                       110 69 4 34 1   1     0   1   51 59                 110
1124233 1124233 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2017   grade_12 62 3 31 0   4     0   2   63 39                       102 62 3 31 0   4     0   2   63 39                 102
1124234 1124234 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124410 1124410 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2017   kindergarten 75 0 2 0   0     0   2   44 35                       79 75 0 2 0   0     0   2   44 35                 79
1124411 1124411 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2017   pre_kindergarten 46 0 2 0   1     0   3   29 23                       52 46 0 2 0   1     0   3   29 23                 52
1124412 1124412 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2017   grade_1 91 0 6 0   1     0   1   51 48                       99 91 0 6 0   1     0   1   51 48                 99
1124413 1124413 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124414 1124414 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2017   grade_2 82 0 0 0   0     0   1   45 38                       83 82 0 0 0   0     0   1   45 38                 83
1124415 1124415 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2017   grade_3 76 0 0 0   1     0   3   42 38                       80 76 0 0 0   1     0   3   42 38                 80
1124416 1124416 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2017   grade_4 100 1 3 0   3     0   4   50 61                       111 100 1 3 0   3     0   4   50 61                 111
1124417 1124417 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2017   grade_5 120 1 3 0   2     0   4   78 52                       130 120 1 3 0   2     0   4   78 52                 130
1124418 1124418 MA Worcester   school 2504230 77   Douglas 250423002791 770015 Douglas Elementary School   Regular School No Elementary 02 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124419 1124419 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2017   grade_6 92 0 9 0   3     0   1   50 55                       105 92 0 9 0   3     0   1   50 55                 105
1124420 1124420 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2017   grade_7 115 0 3 0   2     1   2   68 55                       123 115 0 3 0   2     1   2   68 55                 123
1124421 1124421 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2017   grade_8 121 2 3 0   2     1   3   64 68                       132 121 2 3 0   2     1   3   64 68                 132
1124422 1124422 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124423 1124423 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No High 09 12 2017   grade_9 96 0 3 0   3     1   3   47 59                       106 96 0 3 0   3     1   3   47 59                 106
1124424 1124424 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No High 09 12 2017   grade_10 95 0 3 0   0     0   1   52 47                       99 95 0 3 0   0     0   1   52 47                 99
1124425 1124425 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No High 09 12 2017   grade_11 83 0 1 0   0     0   0   44 40                       84 83 0 1 0   0     0   0   44 40                 84
1124426 1124426 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No High 09 12 2017   grade_12 97 2 3 0   1     0   1   42 62                       104 97 2 3 0   1     0   1   42 62                 104
1124427 1124427 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124867 1124867 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2017   kindergarten 41 3 57 0   3     0   15   64 55                       119 41 3 57 0   3     0   15   64 55                 119
1124868 1124868 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten 35 3 47 0   3     0   4   48 44                       92 35 3 47 0   3     0   4   48 44                 92
1124869 1124869 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2017   grade_1 40 7 66 2   3     0   4   65 57                       122 40 7 66 2   3     0   4   65 57                 122
1124870 1124870 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2017   grade_2 39 6 55 0   1     1   9   61 50                       111 39 6 55 0   1     1   9   61 50                 111
1124871 1124871 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2017   grade_3 34 4 52 0   4     0   5   52 47                       99 34 4 52 0   4     0   5   52 47                 99
1124872 1124872 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2017   grade_4 30 6 53 0   2     0   8   47 52                       99 30 6 53 0   2     0   8   47 52                 99
1124873 1124873 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124874 1124874 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary KG 04 2017   kindergarten 46 6 59 0   5     0   10   74 52                       126 46 6 59 0   5     0   10   74 52                 126
1124875 1124875 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary KG 04 2017   grade_1 41 10 56 0   3     0   9   57 62                       119 41 10 56 0   3     0   9   57 62                 119
1124876 1124876 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary KG 04 2017   grade_2 53 8 62 0   3     0   10   71 65                       136 53 8 62 0   3     0   10   71 65                 136
1124877 1124877 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary KG 04 2017   grade_3 49 8 51 0   4     1   10   66 57                       123 49 8 51 0   4     1   10   66 57                 123
1124878 1124878 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary KG 04 2017   grade_4 48 4 51 0   4     0   11   55 63                       118 48 4 51 0   4     0   11   55 63                 118
1124879 1124879 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124880 1124880 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No Middle 05 08 2017   grade_5 52 8 91 0   13     0   10   89 85                       174 52 8 91 0   13     0   10   89 85                 174
1124881 1124881 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No Middle 05 08 2017   grade_6 64 12 103 0   12     0   13   107 97                       204 64 12 103 0   12     0   13   107 97                 204
1124882 1124882 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No Middle 05 08 2017   grade_7 42 6 98 0   7     0   10   91 72                       163 42 6 98 0   7     0   10   91 72                 163
1124883 1124883 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No Middle 05 08 2017   grade_8 56 14 82 0   7     0   16   73 102                       175 56 14 82 0   7     0   16   73 102                 175

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