Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by school_nces_id descending

View and edit SQL

year

  • 2020 · 9,537
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
1373324 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   kindergarten 13 0 0 0   0     0   0   9 4 *                     13.0 13 0 0 0   0     0   0   9 4                 13
1373325 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten 24 0 0 0   0     0   0   11 13 *                     24.0 24 0 0 0   0     0   0   11 13                 24
1373326 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_1 12 0 0 0   0     0   0   6 6 *                     12.0 12 0 0 0   0     0   0   6 6                 12
1373327 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_2 10 0 1 0   0     0   0   6 5 *                     11.0 10 0 1 0   0     0   0   6 5                 11
1373328 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_3 13 0 0 0   0     0   0   6 7 *                     13.0 13 0 0 0   0     0   0   6 7                 13
1373329 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_4 9 0 0 0   0     0   0   4 5 *                     9.0 9 0 0 0   0     0   0   4 5                 9
1373330 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_5 10 0 0 0   0     0   0   7 3 *                     10.0 10 0 0 0   0     0   0   7 3                 10
1373331 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_6 13 0 0 0   0     0   0   11 2 *                     13.0 13 0 0 0   0     0   0   11 2                 13
1372424 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2020   kindergarten 96 1 5 0   1     0   6   53 56 *                     109.0 96 1 5 0   1     0   6   53 56                 109
1372425 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2020   pre_kindergarten 73 3 2 0   4     0   5   49 38 *                     87.0 73 3 2 0   4     0   5   49 38                 87
1372426 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2020   grade_1 89 0 6 0   4     0   4   55 48 *                     103.0 89 0 6 0   4     0   4   55 48                 103
1372427 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2020   grade_2 107 3 6 0   4     0   10   62 68 *                     130.0 107 3 6 0   4     0   10   62 68                 130
1372428 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2020   grade_3 107 2 9 0   2     0   3   64 59 *                     123.0 107 2 9 0   2     0   3   64 59                 123
1372429 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Middle 04 06 2020   grade_4 94 1 6 2   4     1   7   54 61 *                     115.0 94 1 6 2   4     1   7   54 61                 115
1372430 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Middle 04 06 2020   grade_5 114 0 7 1   4     0   7   64 69 *                     133.0 114 0 7 1   4     0   7   64 69                 133
1372431 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Charles E Roderick   Regular School No Middle 04 06 2020   grade_6 132 3 7 1   3     0   6   87 65 *                     152.0 132 3 7 1   3     0   6   87 65                 152
1372417 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   kindergarten 8 0 0 1   0     0   1   4 6 *                     10.0 8 0 0 1   0     0   1   4 6                 10
1372418 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   pre_kindergarten 12 0 2 1   0     0   0   11 4 *                     15.0 12 0 2 1   0     0   0   11 4                 15
1372419 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_1 8 0 1 0   0     0   1   5 5 *                     10.0 8 0 1 0   0     0   1   5 5                 10
1372420 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_2 13 0 1 0   0     0   0   9 5 *                     14.0 13 0 1 0   0     0   0   9 5                 14
1372421 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_4 9 0 0 0   0     0   0   2 7 *                     9.0 9 0 0 0   0     0   0   2 7                 9
1372422 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_5 10 0 0 0   0     0   0   7 3 *                     10.0 10 0 0 0   0     0   0   7 3                 10
1372423 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_6 10 0 0 0   0     0   1   5 6 *                     11.0 10 0 0 0   0     0   1   5 6                 11
1372123 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 253 86 23 3   13     0   15   191 202 *                     393.0 253 86 23 3   13     0   15   191 202                 393
1372176 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   kindergarten 19 9 23 0   2     0   3   28 28 *                     56.0 19 9 23 0   2     0   3   28 28                 56
1372177 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   pre_kindergarten 6 10 9 0   2     0   1   14 14 *                     28.0 6 10 9 0   2     0   1   14 14                 28
1372178 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   grade_1 12 9 29 0   1     0   5   34 22 *                     56.0 12 9 29 0   1     0   5   34 22                 56
1372179 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   grade_2 14 6 47 0   2     0   7   36 40 *                     76.0 14 6 47 0   2     0   7   36 40                 76
1372180 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   grade_3 15 10 35 0   1     0   4   30 35 *                     65.0 15 10 35 0   1     0   4   30 35                 65
1372181 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   grade_4 18 13 37 0   0     0   4   35 37 *                     72.0 18 13 37 0   0     0   4   35 37                 72
1372182 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   grade_5 20 15 31 0   1     0   3   42 28 *                     70.0 20 15 31 0   1     0   3   42 28                 70
1372183 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   grade_6 13 6 31 0   2     0   2   25 29 *                     54.0 13 6 31 0   2     0   2   25 29                 54
1372244 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2020   kindergarten 14 21 25 0   3     0   6   32 37 *                     69.0 14 21 25 0   3     0   6   32 37                 69
1372245 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2020   pre_kindergarten 7 6 23 0   0     0   2   26 12 *                     38.0 7 6 23 0   0     0   2   26 12                 38
1372246 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2020   grade_1 5 26 27 0   1     0   1   25 35 *                     60.0 5 26 27 0   1     0   1   25 35                 60
1372247 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2020   grade_2 2 18 34 0   1     0   1   31 25 *                     56.0 2 18 34 0   1     0   1   31 25                 56
1372248 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2020   grade_3 5 21 25 0   2     0   1   27 27 *                     54.0 5 21 25 0   2     0   1   27 27                 54
1372249 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2020   grade_4 4 16 23 0   1     0   4   17 31 *                     48.0 4 16 23 0   1     0   4   17 31                 48
1372250 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2020   grade_5 8 14 23 0   0     0   4   25 24 *                     49.0 8 14 23 0   0     0   4   25 24                 49
1372251 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2020   grade_6 7 13 17 0   0     0   1   20 18 *                     38.0 7 13 17 0   0     0   1   20 18                 38
1372168 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   kindergarten 15 3 50 0   3     0   1   28 44 *                     72.0 15 3 50 0   3     0   1   28 44                 72
1372169 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   pre_kindergarten 9 1 2 0   1     0   0   7 6 *                     13.0 9 1 2 0   1     0   0   7 6                 13
1372170 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_1 14 2 58 0   2     0   1   39 38 *                     77.0 14 2 58 0   2     0   1   39 38                 77
1372171 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_2 7 0 61 0   0     0   1   34 35 *                     69.0 7 0 61 0   0     0   1   34 35                 69
1372172 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_3 4 2 45 0   2     0   0   27 26 *                     53.0 4 2 45 0   2     0   0   27 26                 53
1372173 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_4 6 4 66 0   0     0   0   32 44 *                     76.0 6 4 66 0   0     0   0   32 44                 76
1372174 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_5 11 0 66 0   1     0   1   41 38 *                     79.0 11 0 66 0   1     0   1   41 38                 79
1372175 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_6 11 3 59 0   0     0   1   34 40 *                     74.0 11 3 59 0   0     0   1   34 40                 74
1372364 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No Elementary PK 06 2020   kindergarten 15 23 32 0   1     0   1   37 35 *                     72.0 15 23 32 0   1     0   1   37 35                 72
1372365 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No Elementary PK 06 2020   pre_kindergarten 5 21 20 0   3     0   3   26 26 *                     52.0 5 21 20 0   3     0   3   26 26                 52
1372366 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No Elementary PK 06 2020   grade_1 14 17 47 0   1     0   3   44 38 *                     82.0 14 17 47 0   1     0   3   44 38                 82
1372367 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No Elementary PK 06 2020   grade_2 8 15 36 0   1     0   2   33 29 *                     62.0 8 15 36 0   1     0   2   33 29                 62
1372368 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No Elementary PK 06 2020   grade_3 10 16 41 0   2     0   3   35 37 *                     72.0 10 16 41 0   2     0   3   35 37                 72
1372369 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No Elementary PK 06 2020   grade_4 15 12 25 0   0     0   2   30 24 *                     54.0 15 12 25 0   0     0   2   30 24                 54
1372370 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No Elementary PK 06 2020   grade_5 12 12 38 1   0     0   1   40 24 *                     64.0 12 12 38 1   0     0   1   40 24                 64
1372371 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No Elementary PK 06 2020   grade_6 20 19 27 0   2     0   6   39 35 *                     74.0 20 19 27 0   2     0   6   39 35                 74
1372413 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2020   grade_9 124 70 154 0   30     0   15   155 238 *                     393.0 124 70 154 0   30     0   15   155 238                 393
1372414 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2020   grade_10 137 54 136 1   36     1   12   170 207 *                     377.0 137 54 136 1   36     1   12   170 207                 377
1372415 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2020   grade_11 132 57 132 1   24     0   13   180 179 *                     359.0 132 57 132 1   24     0   13   180 179                 359
1372416 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2020   grade_12 122 63 116 0   27     0   9   140 197 *                     337.0 122 63 116 0   27     0   9   140 197                 337
1372388 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2020   grade_7 70 62 187 0   19     1   14   175 178 *                     353.0 70 62 187 0   19     1   14   175 178                 353
1372389 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 07 08 2020   grade_8 59 80 183 1   36     0   16   181 194 *                     375.0 59 80 183 1   36     0   16   181 194                 375
1372356 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2020   kindergarten 27 3 11 1   3     0   5   26 24 *                     50.0 27 3 11 1   3     0   5   26 24                 50
1372357 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2020   pre_kindergarten 25 6 9 0   3     0   3   29 17 *                     46.0 25 6 9 0   3     0   3   29 17                 46
1372358 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2020   grade_1 19 6 10 0   3     0   4   21 21 *                     42.0 19 6 10 0   3     0   4   21 21                 42
1372359 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2020   grade_2 27 5 15 0   2     0   5   30 24 *                     54.0 27 5 15 0   2     0   5   30 24                 54
1372360 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2020   grade_3 29 4 3 0   2     0   3   19 22 *                     41.0 29 4 3 0   2     0   3   19 22                 41
1372361 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2020   grade_4 17 4 7 0   2     0   3   16 17 *                     33.0 17 4 7 0   2     0   3   16 17                 33
1372362 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2020   grade_5 29 3 7 0   3     0   1   20 23 *                     43.0 29 3 7 0   3     0   1   20 23                 43
1372363 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2020   grade_6 29 1 8 0   2     0   3   16 27 *                     43.0 29 1 8 0   2     0   3   16 27                 43
1372132 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   kindergarten 11 6 8 0   1     0   1   11 16 *                     27.0 11 6 8 0   1     0   1   11 16                 27
1372133 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_1 5 1 3 0   3     0   1   5 8 *                     13.0 5 1 3 0   3     0   1   5 8                 13
1372134 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_2 3 2 9 0   0     0   1   9 6 *                     15.0 3 2 9 0   0     0   1   9 6                 15
1372135 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_3 7 2 11 0   3     0   0   12 11 *                     23.0 7 2 11 0   3     0   0   12 11                 23
1372136 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_4 5 3 9 0   2     0   2   12 9 *                     21.0 5 3 9 0   2     0   2   12 9                 21
1372137 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_5 11 1 10 0   3     0   2   13 14 *                     27.0 11 1 10 0   3     0   2   13 14                 27
1372138 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_6 10 3 12 0   2     0   1   16 12 *                     28.0 10 3 12 0   2     0   1   16 12                 28
1372349 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2020   kindergarten 16 5 30 0   1     0   0   24 28 *                     52.0 16 5 30 0   1     0   0   24 28                 52
1372350 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2020   grade_1 6 8 30 0   1     0   1   21 25 *                     46.0 6 8 30 0   1     0   1   21 25                 46
1372351 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2020   grade_2 7 10 39 0   1     0   2   37 22 *                     59.0 7 10 39 0   1     0   2   37 22                 59
1372352 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2020   grade_3 9 6 45 0   1     0   3   36 28 *                     64.0 9 6 45 0   1     0   3   36 28                 64
1372353 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2020   grade_4 7 3 36 0   1     0   2   23 26 *                     49.0 7 3 36 0   1     0   2   23 26                 49
1372354 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2020   grade_5 13 8 37 0   0     0   0   25 33 *                     58.0 13 8 37 0   0     0   0   25 33                 58
1372355 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2020   grade_6 15 8 31 0   1     0   2   28 29 *                     57.0 15 8 31 0   1     0   2   28 29                 57
1372342 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2020   kindergarten 20 6 15 0   3     0   1   21 24 *                     45.0 20 6 15 0   3     0   1   21 24                 45
1372343 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2020   grade_1 18 9 14 0   2     0   1   27 17 *                     44.0 18 9 14 0   2     0   1   27 17                 44
1372344 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2020   grade_2 23 16 16 0   5     0   1   32 29 *                     61.0 23 16 16 0   5     0   1   32 29                 61
1372345 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2020   grade_3 24 8 18 0   7     0   1   19 39 *                     58.0 24 8 18 0   7     0   1   19 39                 58
1372346 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2020   grade_4 19 11 14 0   4     0   2   32 18 *                     50.0 19 11 14 0   4     0   2   32 18                 50
1372347 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2020   grade_5 30 7 10 0   1     0   3   28 23 *                     51.0 30 7 10 0   1     0   3   28 23                 51
1372348 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2020   grade_6 19 2 16 0   3     0   5   21 24 *                     45.0 19 2 16 0   3     0   5   21 24                 45
1372334 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2020   kindergarten 33 15 17 0   1     0   2   37 31 *                     68.0 33 15 17 0   1     0   2   37 31                 68
1372335 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2020   pre_kindergarten 14 2 5 0   5     0   1   19 8 *                     27.0 14 2 5 0   5     0   1   19 8                 27
1372336 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2020   grade_1 23 19 19 0   2     0   4   31 36 *                     67.0 23 19 19 0   2     0   4   31 36                 67
1372337 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2020   grade_2 19 4 16 1   4     1   0   26 19 *                     45.0 19 4 16 1   4     1   0   26 19                 45
1372338 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2020   grade_3 22 16 15 0   6     0   1   30 30 *                     60.0 22 16 15 0   6     0   1   30 30                 60
1372339 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2020   grade_4 21 8 15 0   2     0   3   23 26 *                     49.0 21 8 15 0   2     0   3   23 26                 49
1372340 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2020   grade_5 20 14 10 0   4     0   3   24 27 *                     51.0 20 14 10 0   4     0   3   24 27                 51
1372341 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2020   grade_6 20 15 14 0   3     0   6   26 32 *                     58.0 20 15 14 0   3     0   6   26 32                 58
1372326 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2020   kindergarten 19 18 15 0   4     0   0   27 29 *                     56.0 19 18 15 0   4     0   0   27 29                 56

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