enrollments

Data source: Big Local News · About: Big Local

960 rows where grade = "kindergarten", state = "MA" and year = 2019

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 860 ✖

grade ✖

  • kindergarten · 860 ✖
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
2040633 2040633 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Manassah E Bradley   Regular School No Elementary PK 05 2019   kindergarten 13 2 23 0   2     0   2   21 21                       42.0 13 2 23 0   2     0   2   21 21                 42
2040640 2040640 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No Elementary PK 05 2019   kindergarten 5 29 14 0   29     0   5   39 43                       82.0 5 29 14 0   29     0   5   39 43                 82
2040647 2040647 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   kindergarten 2 15 23 0   1     0   1   23 19                       42.0 2 15 23 0   1     0   1   23 19                 42
2040657 2040657 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary PK 05 2019   kindergarten 2 7 11 0   1     0   0   9 12                       21.0 2 7 11 0   1     0   0   9 12                 21
2040664 2040664 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2019   kindergarten 15 3 5 0   0     0   1   12 12                       24.0 15 3 5 0   0     0   1   12 12                 24
2040671 2040671 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2019   kindergarten 5 10 13 0   36     0   1   36 29                       65.0 5 10 13 0   36     0   1   36 29                 65
2040681 2040681 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2019   kindergarten 3 8 7 0   4     0   0   9 13                       22.0 3 8 7 0   4     0   0   9 13                 22
2040688 2040688 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   kindergarten 19 3 1 0   1     0   2   12 14                       26.0 19 3 1 0   1     0   2   12 14                 26
2040698 2040698 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2019   kindergarten 8 34 32 2   2     0   2   41 39                       80.0 8 34 32 2   2     0   2   41 39                 80
2040714 2040714 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2019   kindergarten 41 5 15 0   1     0   3   35 30                       65.0 41 5 15 0   1     0   3   35 30                 65
2040724 2040724 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No Elementary PK 05 2019   kindergarten 1 1 37 0   0     0   0   17 22                       39.0 1 1 37 0   0     0   0   17 22                 39
2040731 2040731 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No Elementary PK 01 2019   kindergarten 18 29 7 0   9     1   4   38 30                       68.0 18 29 7 0   9     1   4   38 30                 68
2040734 2040734 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No Elementary PK 05 2019   kindergarten 3 18 36 0   2     0   0   37 22                       59.0 3 18 36 0   2     0   0   37 22                 59
2040741 2040741 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No Elementary PK 05 2019   kindergarten 9 12 12 1   2     0   1   19 18                       37.0 9 12 12 1   2     0   1   19 18                 37
2040748 2040748 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2019   kindergarten 20 15 10 0   63     0   5   53 60                       113.0 20 15 10 0   63     0   5   53 60                 113
2040755 2040755 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2019   kindergarten 3 6 6 0   2     0   1   11 7                       18.0 3 6 6 0   2     0   1   11 7                 18
2040762 2040762 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Samuel Adams   Regular School No Elementary PK 05 2019   kindergarten 10 1 18 0   1     0   0   14 16                       30.0 10 1 18 0   1     0   0   14 16                 30
2040769 2040769 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No Elementary PK 05 2019   kindergarten 3 20 12 0   0     0   1   23 13                       36.0 3 20 12 0   0     0   1   23 13                 36
2040776 2040776 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   kindergarten 0 6 37 0   1     0   0   24 20                       44.0 0 6 37 0   1     0   0   24 20                 44
2040786 2040786 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2019   kindergarten 9 3 23 0   2     0   2   24 15                       39.0 9 3 23 0   2     0   2   24 15                 39
2040796 2040796 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No Elementary PK 05 2019   kindergarten 11 10 10 0   7     0   1   19 20                       39.0 11 10 10 0   7     0   1   19 20                 39
2040803 2040803 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2019   kindergarten 44 7 11 0   3     0   4   39 30                       69.0 44 7 11 0   3     0   4   39 30                 69
2040813 2040813 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No Elementary PK 05 2019   kindergarten 4 11 15 0   2     0   1   15 18                       33.0 4 11 15 0   2     0   1   15 18                 33
2040832 2040832 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No Elementary PK 05 2019   kindergarten 3 16 34 0   6     0   0   31 28                       59.0 3 16 34 0   6     0   0   31 28                 59
2040839 2040839 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   kindergarten 2 35 21 1   2     2   2   31 34                       65.0 2 35 21 1   2     2   2   31 34                 65
2040849 2040849 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2019   kindergarten 8 9 10 0   12     0   4   23 20                       43.0 8 9 10 0   12     0   4   23 20                 43
2040856 2040856 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2019   kindergarten 7 8 17 0   14     0   2   25 23                       48.0 7 8 17 0   14     0   2   25 23                 48
2040866 2040866 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2019   kindergarten 2 39 18 1   1     0   2   27 36                       63.0 2 39 18 1   1     0   2   27 36                 63
2040883 2040883 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2019   kindergarten 1 30 8 0   0     0   0   20 19                       39.0 1 30 8 0   0     0   0   20 19                 39
2040893 2040893 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   kindergarten 0 26 25 1   0     0   2   27 27                       54.0 0 26 25 1   0     0   2   27 27                 54
2040903 2040903 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   kindergarten 11 4 4 0   0     0   3   13 9                       22.0 11 4 4 0   0     0   3   13 9                 22
2040916 2040916 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No Elementary PK 05 2019   kindergarten 4 18 46 0   3     0   3   40 34                       74.0 4 18 46 0   3     0   3   40 34                 74
2041059 2041059 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2019   kindergarten 6 4 48 0   2     0   0   35 25                       60.0 6 4 48 0   2     0   0   35 25                 60
2041086 2041086 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2019   kindergarten 3 2 43 0   0     0   1   23 26                       49.0 3 2 43 0   0     0   1   23 26                 49
2041095 2041095 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   kindergarten * * * *   *     *   *   1 1                       2.0                         1 1                 2
2041112 2041112 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2019   kindergarten 71 0 6 0   2     0   3   41 41                       82.0 71 0 6 0   2     0   3   41 41                 82
2041117 2041117 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No Elementary KG 04 2019   kindergarten 33 2 4 0   0     0   1   20 20                       40.0 33 2 4 0   0     0   1   20 20                 40
2041132 2041132 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2019   kindergarten 60 0 5 0   1     0   10   44 32                       76.0 60 0 5 0   1     0   10   44 32                 76
2041140 2041140 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2019   kindergarten 29 0 4 0   4     0   1   21 17                       38.0 29 0 4 0   4     0   1   21 17                 38
2041146 2041146 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Hollis   Regular School No Elementary KG 05 2019   kindergarten 35 0 1 0   11     0   0   31 16                       47.0 35 0 1 0   11     0   0   31 16                 47
2041152 2041152 MA Norfolk   school 2502940 40   Braintree 250294002789 400009 Monatiquot Kindergarten Center   Regular School No Elementary KG KG 2019   kindergarten 183 5 12 0   68     0   4   137 135                       272.0 183 5 12 0   68     0   4   137 135                 272
2041153 2041153 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No Elementary KG 05 2019   kindergarten 19 1 0 0   1     0   0   11 10                       21.0 19 1 0 0   1     0   0   11 10                 21
2041159 2041159 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Mary E Flaherty School   Regular School No Elementary KG 05 2019   kindergarten 16 0 0 0   10     0   0   16 10                       26.0 16 0 0 0   10     0   0   16 10                 26
2041170 2041170 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No Elementary KG 05 2019   kindergarten 17 0 1 0   2     0   0   8 12                       20.0 17 0 1 0   2     0   0   8 12                 20
2041176 2041176 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No Elementary KG 05 2019   kindergarten 11 1 0 0   9     0   0   13 8                       21.0 11 1 0 0   9     0   0   13 8                 21
2041195 2041195 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2019   kindergarten 56 1 5 0   0     0   4   29 37                       66.0 56 1 5 0   0     0   4   29 37                 66
2041202 2041202 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2019   kindergarten 23 0 0 1   0     0   0   13 11                       24.0 23 0 0 1   0     0   0   13 11                 24
2041210 2041210 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2019   kindergarten 9 65 24 0   0     0   6   56 48                       104.0 9 65 24 0   0     0   6   56 48                 104
2041216 2041216 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2019   kindergarten 28 50 11 0   3     0   6   50 48                       98.0 28 50 11 0   3     0   6   50 48                 98
2041222 2041222 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2019   kindergarten 16 105 78 0   1     0   5   107 98                       205.0 16 105 78 0   1     0   5   107 98                 205
2041229 2041229 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2019   kindergarten 22 49 6 0   0     0   11   56 32                       88.0 22 49 6 0   0     0   11   56 32                 88
2041235 2041235 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2019   kindergarten 22 59 9 0   2     0   3   49 46                       95.0 22 59 9 0   2     0   3   49 46                 95
2041241 2041241 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2019   kindergarten 11 64 8 1   2     1   7   47 47                       94.0 11 64 8 1   2     1   7   47 47                 94
2041250 2041250 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No Elementary KG 05 2019   kindergarten 21 37 10 0   0     1   3   32 40                       72.0 21 37 10 0   0     1   3   32 40                 72
2041256 2041256 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Gilmore Elementary School   Regular School No Elementary KG 05 2019   kindergarten 1 56 5 0   0     0   3   29 36                       65.0 1 56 5 0   0     0   3   29 36                 65
2041262 2041262 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2019   kindergarten 19 59 7 0   5     0   6   50 46                       96.0 19 59 7 0   5     0   6   50 46                 96
2041268 2041268 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2019   kindergarten 16 100 17 0   2     0   3   79 59                       138.0 16 100 17 0   2     0   3   79 59                 138
2041279 2041279 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2019   kindergarten 20 43 11 0   3     0   2   42 37                       79.0 20 43 11 0   3     0   2   42 37                 79
2041326 2041326 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2019   kindergarten 33 0 3 0   0     0   0   21 15                       36.0 33 0 3 0   0     0   0   21 15                 36
2041335 2041335 MA Middlesex   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2019   kindergarten 32 4 4 0   27     0   6   34 39                       73.0 32 4 4 0   27     0   6   34 39                 73
2041345 2041345 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2019   kindergarten 63 4 16 0   15     0   11   51 57                       109.0 63 4 16 0   15     0   11   51 57                 109
2041355 2041355 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2019   kindergarten 33 4 5 0   16     0   12   32 38                       70.0 33 4 5 0   16     0   12   32 38                 70
2041365 2041365 MA Middlesex   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2019   kindergarten 31 4 3 0   5     0   6   25 24                       49.0 31 4 3 0   5     0   6   25 24                 49
2041374 2041374 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2019   kindergarten 36 5 8 0   33     0   5   39 48                       87.0 36 5 8 0   33     0   5   39 48                 87
2041383 2041383 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2019   kindergarten 24 3 10 0   19     0   6   30 32                       62.0 24 3 10 0   19     0   6   30 32                 62
2041392 2041392 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2019   kindergarten 44 4 4 0   38     0   9   52 47                       99.0 44 4 4 0   38     0   9   52 47                 99
2041402 2041402 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2019   kindergarten 28 4 2 0   11     0   9   33 21                       54.0 28 4 2 0   11     0   9   33 21                 54
2041417 2041417 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Fox Hill   Regular School No Elementary KG 05 2019   kindergarten 62 3 4 0   19     0   0   37 51                       88.0 62 3 4 0   19     0   0   37 51                 88
2041423 2041423 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Memorial   Regular School No Elementary KG 05 2019   kindergarten 43 1 3 0   14     0   2   36 27                       63.0 43 1 3 0   14     0   2   36 27                 63
2041429 2041429 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Pine Glen Elementary   Regular School No Elementary KG 05 2019   kindergarten 48 1 1 0   7     0   3   33 27                       60.0 48 1 1 0   7     0   3   33 27                 60
2041435 2041435 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Francis Wyman Elementary   Regular School No Elementary KG 05 2019   kindergarten 37 14 6 0   14     0   3   40 34                       74.0 37 14 6 0   14     0   3   40 34                 74
2041445 2041445 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No Other 09 12 2019   kindergarten 13 1 0 0   0     0   0   12 2                       14.0 13 1 0 0   0     0   0   12 2                 14
2041451 2041451 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No Elementary PK 05 2019   kindergarten 40 11 5 0   4     0   4   36 28                       64.0 40 11 5 0   4     0   4   36 28                 64
2041458 2041458 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   kindergarten 26 1 16 0   1     0   3   28 19                       47.0 26 1 16 0   1     0   3   28 19                 47
2041468 2041468 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2019   kindergarten 30 7 4 0   3     0   6   25 25                       50.0 30 7 4 0   3     0   6   25 25                 50
2041475 2041475 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No Elementary PK 05 2019   kindergarten 22 7 4 0   11     0   4   17 31                       48.0 22 7 4 0   11     0   4   17 31                 48
2041482 2041482 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2019   kindergarten 25 8 2 1   21     0   10   32 35                       67.0 25 8 2 1   21     0   10   32 35                 67
2041489 2041489 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2019   kindergarten 28 8 6 0   5     0   13   31 29                       60.0 28 8 6 0   5     0   13   31 29                 60
2041496 2041496 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No Elementary PK 05 2019   kindergarten 7 8 9 0   15     0   2   21 20                       41.0 7 8 9 0   15     0   2   21 20                 41
2041503 2041503 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2019   kindergarten 27 13 3 0   5     0   3   19 32                       51.0 27 13 3 0   5     0   3   19 32                 51
2041510 2041510 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No Elementary PK 05 2019   kindergarten 25 10 4 0   9     0   2   28 22                       50.0 25 10 4 0   9     0   2   28 22                 50
2041517 2041517 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No Elementary PK 05 2019   kindergarten 18 8 5 0   6     0   3   22 18                       40.0 18 8 5 0   6     0   3   22 18                 40
2041524 2041524 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2019   kindergarten 27 4 1 0   17     0   5   26 28                       54.0 27 4 1 0   17     0   5   26 28                 54
2041531 2041531 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No Elementary PK 05 2019   kindergarten 6 26 7 0   7     0   4   37 13                       50.0 6 26 7 0   7     0   4   37 13                 50
2041555 2041555 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Lt Peter M Hansen   Regular School No Elementary KG 05 2019   kindergarten 40 9 6 0   9     0   6   38 32                       70.0 40 9 6 0   9     0   6   38 32                 70
2041561 2041561 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No Elementary KG 05 2019   kindergarten 63 6 1 0   8     0   9   48 39                       87.0 63 6 1 0   8     0   9   48 39                 87
2041567 2041567 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No Elementary KG 05 2019   kindergarten 60 3 4 0   5     0   6   39 39                       78.0 60 3 4 0   5     0   6   39 39                 78
2041582 2041582 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2019   kindergarten 37 2 3 0   8     0   8   28 30                       58.0 37 2 3 0   8     0   8   28 30                 58
2041592 2041592 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2019   kindergarten 122 1 3 0   0     0   3   62 67                       129.0 122 1 3 0   0     0   3   62 67                 129
2041607 2041607 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No Elementary KG 04 2019   kindergarten 75 2 5 0   18     0   3   56 47                       103.0 75 2 5 0   18     0   3   56 47                 103
2041612 2041612 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 South Row   Regular School No Elementary KG 04 2019   kindergarten 66 0 4 1   17     0   4   52 40                       92.0 66 0 4 1   17     0   4   52 40                 92
2041617 2041617 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No Elementary KG 04 2019   kindergarten 56 5 10 0   20     0   4   42 53                       95.0 56 5 10 0   20     0   4   42 53                 95
2041622 2041622 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2019   kindergarten 63 2 8 0   12     0   1   40 46                       86.0 63 2 8 0   12     0   1   40 46                 86
2041640 2041640 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2019   kindergarten 44 23 446 0   4     0   3   239 281                       520.0 44 23 446 0   4     0   3   239 281                 520
2041681 2041681 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No Elementary KG 05 2019   kindergarten 30 4 30 0   2     0   3   36 33                       69.0 30 4 30 0   2     0   3   36 33                 69
2041687 2041687 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2019   kindergarten 41 7 23 0   2     0   1   35 39                       74.0 41 7 23 0   2     0   1   35 39                 74
2041690 2041690 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No Elementary KG 05 2019   kindergarten 19 6 46 0   2     0   2   35 40                       75.0 19 6 46 0   2     0   2   35 40                 75
2041696 2041696 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No Elementary KG 05 2019   kindergarten 31 1 13 0   2     0   1   22 26                       48.0 31 1 13 0   2     0   1   22 26                 48
2041708 2041708 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2019   kindergarten 18 0 2 0   0     0   0   6 14                       20.0 18 0 2 0   0     0   0   6 14                 20
2041714 2041714 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No Elementary KG 05 2019   kindergarten 27 4 8 0   2     0   2   30 13                       43.0 27 4 8 0   2     0   2   30 13                 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]);