enrollments

Data source: Big Local News · About: Big Local

970 rows where grade = "grade_2", state = "MA" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 870 ✖

grade ✖

  • grade_2 · 870 ✖
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
1672863 1672863 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston - Richard J Murphy   Regular School No Elementary PK 08 2021   grade_2 7 12 15 0   56     0   2   47 45 *                     92.0 7 12 15 0   56     0   2   47 45                 92
1672873 1672873 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston - Nathan Hale   Regular School No Elementary PK 06 2021   grade_2 2 9 7 0   4     0   0   8 14 *                     22.0 2 9 7 0   4     0   0   8 14                 22
1672881 1672881 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston - Oliver Hazard Perry   Regular School No Elementary PK 08 2021   grade_2 14 4 1 0   1     0   2   12 10 *                     22.0 14 4 1 0   1     0   2   12 10                 22
1672890 1672890 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   grade_2 6 47 33 2   1     0   3   40 52 *                     92.0 6 47 33 2   1     0   3   40 52                 92
1672906 1672906 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston - Lyndon   Regular School No Elementary PK 08 2021   grade_2 39 10 17 0   1     0   3   35 35 *                     70.0 39 10 17 0   1     0   3   35 35                 70
1672916 1672916 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Boston - Patrick J Kennedy   Regular School No Elementary PK 06 2021   grade_2 2 1 32 0   0     0   1   20 16 *                     36.0 2 1 32 0   0     0   1   20 16                 36
1672927 1672927 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Boston - Paul A Dever   Regular School No Elementary PK 05 2021   grade_2 4 18 36 1   3     0   0   37 25 *                     62.0 4 18 36 1   3     0   0   37 25                 62
1672934 1672934 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Boston - Phineas Bates   Regular School No Elementary PK 05 2021   grade_2 8 14 10 0   2     0   3   23 14 *                     37.0 8 14 10 0   2     0   3   23 14                 37
1672941 1672941 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Boston - Josiah Quincy   Regular School No Elementary PK 05 2021   grade_2 17 13 10 0   68     0   4   52 60 *                     112.0 17 13 10 0   68     0   4   52 60                 112
1672948 1672948 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Boston - Roger Clap   Regular School No Elementary PK 06 2021   grade_2 1 6 8 0   2     0   0   8 9 *                     17.0 1 6 8 0   2     0   0   8 9                 17
1672956 1672956 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Boston - Samuel Adams   Regular School No Elementary PK 06 2021   grade_2 11 1 28 0   3     0   0   22 21 *                     43.0 11 1 28 0   3     0   0   22 21                 43
1672964 1672964 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Boston - Samuel W Mason   Regular School No Elementary PK 05 2021   grade_2 2 25 12 0   0     0   0   20 18 *                     39.0 2 25 12 0   0     0   0   20 18                 39
1672971 1672971 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston - Sarah Greenwood   Regular School No Elementary PK 08 2021   grade_2 0 1 31 0   1     0   1   16 18 *                     34.0 0 1 31 0   1     0   1   16 18                 34
1672981 1672981 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Boston - Gardner Pilot Academy   Regular School No Elementary PK 08 2021   grade_2 8 5 24 0   1     0   2   28 12 *                     40.0 8 5 24 0   1     0   2   28 12                 40
1672991 1672991 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Boston - Thomas J Kenny   Regular School No Elementary PK 06 2021   grade_2 11 14 8 0   5     0   3   20 21 *                     41.0 11 14 8 0   5     0   3   20 21                 41
1672999 1672999 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston - Warren-Prescott   Regular School No Elementary PK 08 2021   grade_2 44 8 9 0   2     0   3   41 25 *                     66.0 44 8 9 0   2     0   3   41 25                 66
1673009 1673009 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston - William Ellery Channing   Regular School No Elementary PK 06 2021   grade_2 1 11 14 0   1     0   1   15 13 *                     28.0 1 11 14 0   1     0   1   15 13                 28
1673014 1673014 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_2 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1673028 1673028 MA Suffolk   school 2502790 35   Boston 250279000337 350366 Boston - William E Russell   Regular School No Elementary PK 05 2021   grade_2 2 19 37 0   6     0   0   34 30 *                     64.0 2 19 37 0   6     0   0   34 30                 64
1673035 1673035 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_2 0 24 17 0   1     2   3   22 25 *                     47.0 0 24 17 0   1     2   3   22 25                 47
1673045 1673045 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Boston - Winship Elementary   Regular School No Elementary PK 05 2021   grade_2 7 6 13 0   11     0   5   23 19 *                     42.0 7 6 13 0   11     0   5   23 19                 42
1673052 1673052 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston - Edison K-8   Regular School No Elementary PK 08 2021   grade_2 13 10 31 0   13     0   6   40 33 *                     73.0 13 10 31 0   13     0   6   40 33                 73
1673062 1673062 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston - King K-8   Regular School No Elementary PK 08 2021   grade_2 1 39 20 1   1     0   2   36 28 *                     64.0 1 39 20 1   1     0   2   36 28                 64
1673078 1673078 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston - Mildred Avenue K-8   Regular School No Elementary PK 08 2021   grade_2 1 27 11 0   1     0   0   20 20 *                     40.0 1 27 11 0   1     0   0   20 20                 40
1673088 1673088 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston - Young Achievers   Alternative School No Elementary PK 08 2021   grade_2 0 28 27 0   1     0   1   31 26 *                     57.0 0 28 27 0   1     0   1   31 26                 57
1673098 1673098 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_2 8 7 6 0   0     0   3   13 11 *                     24.0 8 7 6 0   0     0   3   13 11                 24
1673111 1673111 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Boston - Blackstone   Regular School No Elementary PK 05 2021   grade_2 6 25 53 0   2     0   3   48 41 *                     89.0 6 25 53 0   2     0   3   48 41                 89
1673115 1673115 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_2 13 32 11 0   8     1   4   37 32 *                     69.0 13 32 11 0   8     1   4   37 32                 69
1673250 1673250 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston - Mario Umana Academy   Regular School No Elementary PK 08 2021   grade_2 5 3 54 0   0     0   0   37 25 *                     62.0 5 3 54 0   0     0   0   37 25                 62
1673271 1673271 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_2 3 2 42 0   0     0   0   25 22 *                     47.0 3 2 42 0   0     0   0   25 22                 47
1673279 1673279 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_2 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1673296 1673296 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne - Bournedale Elementary School   Regular School No Elementary PK 02 2021   grade_2 91 1 4 1   3     0   3   45 58 *                     103.0 91 1 4 1   3     0   3   45 58                 103
1673311 1673311 MA Essex   school 2502880 38   Boxford 250288000357 380005 Boxford - Harry Lee Cole   Regular School No Elementary PK 02 2021   grade_2 67 0 5 0   0     0   8   42 38 *                     80.0 67 0 5 0   0     0   8   42 38                 80
1673318 1673318 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Braintree - Hollis   Regular School No Elementary KG 05 2021   grade_2 56 1 2 0   21     0   2   49 33 *                     82.0 56 1 2 0   21     0   2   49 33                 82
1673324 1673324 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Braintree - Highlands   Regular School No Elementary KG 05 2021   grade_2 52 2 3 0   15     0   0   38 34 *                     72.0 52 2 3 0   15     0   0   38 34                 72
1673330 1673330 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Braintree - Mary E Flaherty School   Regular School No Elementary KG 05 2021   grade_2 36 1 3 0   20     0   2   38 24 *                     62.0 36 1 3 0   20     0   2   38 24                 62
1673334 1673334 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree - Liberty   Regular School No Elementary 01 05 2021   grade_2 38 1 2 0   24     1   2   38 30 *                     68.0 38 1 2 0   24     1   2   38 30                 68
1673340 1673340 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Braintree - Archie T Morrison   Regular School No Elementary KG 05 2021   grade_2 54 8 4 0   18     0   0   35 49 *                     84.0 54 8 4 0   18     0   0   35 49                 84
1673345 1673345 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Braintree - Donald Ross   Regular School No Elementary KG 05 2021   grade_2 25 3 2 0   23     0   0   23 30 *                     53.0 25 3 2 0   23     0   0   23 30                 53
1673363 1673363 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster - Stony Brook Elementary   Regular School No Elementary PK 02 2021   grade_2 51 1 8 0   0     0   2   23 39 *                     62.0 51 1 8 0   0     0   2   23 39                 62
1673370 1673370 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield - Brimfield Elementary   Regular School No Elementary PK 06 2021   grade_2 25 0 1 0   0     0   0   16 10 *                     26.0 25 0 1 0   0     0   0   16 10                 26
1673378 1673378 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Brockton - Dr W Arnone Community School   Regular School No Elementary PK 05 2021   grade_2 5 60 19 0   0     0   6   50 40 *                     90.0 5 60 19 0   0     0   6   50 40                 90
1673384 1673384 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Brockton - Mary E. Baker School   Regular School No Elementary KG 05 2021   grade_2 27 55 18 1   3     0   8   58 54 *                     112.0 27 55 18 1   3     0   8   58 54                 112
1673390 1673390 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Brockton - Manthala George Jr. School   Regular School No Elementary KG 05 2021   grade_2 13 82 63 0   1     0   2   84 77 *                     161.0 13 82 63 0   1     0   2   84 77                 161
1673398 1673398 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brockton - Brookfield   Regular School No Elementary KG 05 2021   grade_2 21 50 4 0   0     0   7   47 35 *                     82.0 21 50 4 0   0     0   7   47 35                 82
1673404 1673404 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 Brockton - John F Kennedy   Regular School No Elementary KG 05 2021   grade_2 19 55 12 0   3     0   3   45 47 *                     92.0 19 55 12 0   3     0   3   45 47                 92
1673410 1673410 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_2 7 66 9 0   1     1   5   50 39 *                     89.0 7 66 9 0   1     1   5   50 39                 89
1673419 1673419 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Brockton - Hancock   Regular School No Elementary KG 05 2021   grade_2 15 39 13 0   2     1   2   34 38 *                     72.0 15 39 13 0   2     1   2   34 38                 72
1673425 1673425 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Brockton - Gilmore Elementary School   Regular School No Elementary KG 05 2021   grade_2 1 60 9 0   0     0   2   30 42 *                     72.0 1 60 9 0   0     0   2   30 42                 72
1673431 1673431 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   grade_2 17 59 14 0   5     0   6   56 45 *                     101.0 17 59 14 0   5     0   6   56 45                 101
1673437 1673437 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton - Oscar F Raymond   Regular School No Elementary KG 05 2021   grade_2 8 89 18 0   0     0   0   61 54 *                     115.0 8 89 18 0   0     0   0   61 54                 115
1673446 1673446 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Brockton - Downey   Regular School No Elementary KG 05 2021   grade_2 22 39 13 0   4     0   5   45 38 *                     83.0 22 39 13 0   4     0   5   45 38                 83
1673491 1673491 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield - Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_2 33 0 2 0   0     0   0   20 15 *                     35.0 33 0 2 0   0     0   0   20 15                 35
1673501 1673501 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline - Edith C Baker   Regular School No Elementary KG 08 2021   grade_2 32 4 4 0   23     0   5   30 38 *                     68.0 32 4 4 0   23     0   5   30 38                 68
1673511 1673511 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline - Florida Ruffin Ridley School   Regular School No Elementary PK 08 2021   grade_2 57 3 12 0   8     0   10   38 51 *                     90.0 57 3 12 0   8     0   10   38 51                 90
1673520 1673520 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline - Michael Driscoll   Regular School No Elementary KG 08 2021   grade_2 21 3 2 0   9     0   9   22 22 *                     44.0 21 3 2 0   9     0   9   22 22                 44
1673530 1673530 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline - Heath   Regular School No Elementary PK 08 2021   grade_2 29 4 4 0   11     0   8   26 30 *                     56.0 29 4 4 0   11     0   8   26 30                 56
1673539 1673539 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Brookline - Lawrence   Regular School No Elementary KG 08 2021   grade_2 34 3 7 0   20     0   4   31 37 *                     68.0 34 3 7 0   20     0   4   31 37                 68
1673548 1673548 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline - William H Lincoln   Regular School No Elementary KG 08 2021   grade_2 18 4 8 0   14     0   4   24 24 *                     48.0 18 4 8 0   14     0   4   24 24                 48
1673557 1673557 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline - Pierce   Regular School No Elementary KG 08 2021   grade_2 38 4 4 0   23     0   8   43 34 *                     77.0 38 4 4 0   23     0   8   43 34                 77
1673567 1673567 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline - John D Runkle   Regular School No Elementary PK 08 2021   grade_2 24 4 4 0   11     0   11   30 24 *                     54.0 24 4 4 0   11     0   11   30 24                 54
1673582 1673582 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Burlington - Fox Hill   Regular School No Elementary KG 05 2021   grade_2 59 4 5 0   16     0   1   38 47 *                     85.0 59 4 5 0   16     0   1   38 47                 85
1673588 1673588 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Burlington - Memorial   Regular School No Elementary KG 05 2021   grade_2 41 2 3 0   5     0   3   33 21 *                     54.0 41 2 3 0   5     0   3   33 21                 54
1673594 1673594 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Burlington - Pine Glen Elementary   Regular School No Elementary KG 05 2021   grade_2 46 0 1 0   7     0   5   30 29 *                     59.0 46 0 1 0   7     0   5   30 29                 59
1673600 1673600 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Burlington - Francis Wyman Elementary   Regular School No Elementary KG 05 2021   grade_2 42 11 8 0   20     0   3   39 45 *                     84.0 42 11 8 0   20     0   3   39 45                 84
1673615 1673615 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Cambridge - Maria L. Baldwin   Regular School No Elementary PK 05 2021   grade_2 34 9 5 0   5     0   3   32 24 *                     56.0 34 9 5 0   5     0   3   32 24                 56
1673622 1673622 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge - Amigos School   Regular School No Elementary PK 08 2021   grade_2 25 1 15 0   2     0   2   26 19 *                     45.0 25 1 15 0   2     0   2   26 19                 45
1673632 1673632 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridge - Cambridgeport   Regular School No Elementary PK 05 2021   grade_2 24 8 4 0   1     0   4   21 20 *                     41.0 24 8 4 0   1     0   4   21 20                 41
1673639 1673639 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Cambridge - Haggerty   Regular School No Elementary PK 05 2021   grade_2 19 6 2 0   9     0   2   14 24 *                     38.0 19 6 2 0   9     0   2   14 24                 38
1673646 1673646 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Cambridge - Martin Luther King Jr.   Regular School No Elementary PK 05 2021   grade_2 16 8 2 0   13     0   8   23 24 *                     47.0 16 8 2 0   13     0   8   23 24                 47
1673653 1673653 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 Cambridge - King Open   Alternative School No Elementary PK 05 2021   grade_2 26 7 4 0   4     0   10   23 28 *                     51.0 26 7 4 0   4     0   10   23 28                 51
1673660 1673660 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Cambridge - Kennedy-Longfellow   Regular School No Elementary PK 05 2021   grade_2 4 12 8 0   5     0   3   17 15 *                     32.0 4 12 8 0   5     0   3   17 15                 32
1673667 1673667 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Cambridge - Morse   Regular School No Elementary PK 05 2021   grade_2 17 11 3 0   3     0   5   13 26 *                     39.0 17 11 3 0   3     0   5   13 26                 39
1673674 1673674 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Cambridge - Peabody   Regular School No Elementary PK 05 2021   grade_2 20 10 2 0   9     0   1   23 19 *                     42.0 20 10 2 0   9     0   1   23 19                 42
1673681 1673681 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 Cambridge - John M Tobin   Regular School No Elementary PK 05 2021   grade_2 18 7 4 0   8     0   4   20 21 *                     41.0 18 7 4 0   8     0   4   20 21                 41
1673688 1673688 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Cambridge - Graham and Parks   Alternative School No Elementary PK 05 2021   grade_2 25 5 4 0   15     0   4   27 26 *                     53.0 25 5 4 0   15     0   4   27 26                 53
1673695 1673695 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Cambridge - Fletcher/Maynard Academy   Regular School No Elementary PK 05 2021   grade_2 2 22 8 0   3     0   5   27 13 *                     40.0 2 22 8 0   3     0   5   27 13                 40
1673719 1673719 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Canton - Lt Peter M Hansen   Regular School No Elementary KG 05 2021   grade_2 45 11 5 0   12     0   5   41 37 *                     78.0 45 11 5 0   12     0   5   41 37                 78
1673725 1673725 MA Norfolk   school 2503300 50   Canton 250330000454 500017 Canton - John F Kennedy   Regular School No Elementary KG 05 2021   grade_2 52 4 2 0   10     0   9   42 35 *                     77.0 52 4 2 0   10     0   9   42 35                 77
1673731 1673731 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Canton - Dean S Luce   Regular School No Elementary KG 05 2021   grade_2 57 4 4 0   7     0   7   41 38 *                     79.0 57 4 4 0   7     0   7   41 38                 79
1673746 1673746 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle - Carlisle School   Regular School No Elementary PK 08 2021   grade_2 37 2 5 0   11     1   7   36 27 *                     63.0 37 2 5 0   11     1   7   36 27                 63
1673756 1673756 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver - Carver Elementary School   Regular School No Elementary PK 05 2021   grade_2 117 1 3 0   0     0   3   58 66 *                     124.0 117 1 3 0   0     0   3   58 66                 124
1673770 1673770 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Chelmsford - Center Elementary School   Regular School No Elementary KG 04 2021   grade_2 74 2 5 0   22     0   3   59 47 *                     106.0 74 2 5 0   22     0   3   59 47                 106
1673775 1673775 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 Chelmsford - South Row   Regular School No Elementary KG 04 2021   grade_2 58 1 9 1   18     0   4   53 38 *                     91.0 58 1 9 1   18     0   4   53 38                 91
1673780 1673780 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Chelmsford - Charles D Harrington   Regular School No Elementary KG 04 2021   grade_2 56 5 11 0   22     0   4   44 54 *                     98.0 56 5 11 0   22     0   4   44 54                 98
1673785 1673785 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Chelmsford - Byam School   Regular School No Elementary KG 04 2021   grade_2 60 1 9 0   13     0   3   40 46 *                     86.0 60 1 9 0   13     0   3   40 46                 86
1673804 1673804 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea - William A Berkowitz Elementary   Regular School No Elementary 01 04 2021   grade_2 13 4 125 0   0     0   2   72 72 *                     144.0 13 4 125 0   0     0   2   72 72                 144
1673808 1673808 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea - Edgar A Hooks Elementary   Regular School No Elementary 01 04 2021   grade_2 15 9 105 0   0     0   2   57 74 *                     131.0 15 9 105 0   0     0   2   57 74                 131
1673812 1673812 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_2 6 4 102 0   0     0   0   55 57 *                     112.0 6 4 102 0   0     0   0   55 57                 112
1673818 1673818 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea - Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2021   grade_2 11 3 113 0   1     0   0   61 67 *                     128.0 11 3 113 0   1     0   0   61 67                 128
1673844 1673844 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Chicopee - Barry   Regular School No Elementary KG 05 2021   grade_2 30 3 20 0   2     0   1   32 24 *                     56.0 30 3 20 0   2     0   1   32 24                 56
1673850 1673850 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Chicopee - Belcher   Regular School No Elementary KG 02 2021   grade_2 31 8 22 0   1     0   1   33 30 *                     63.0 31 8 22 0   1     0   1   33 30                 63
1673853 1673853 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Chicopee - Bowe   Regular School No Elementary KG 05 2021   grade_2 15 4 47 0   1     0   3   36 34 *                     70.0 15 4 47 0   1     0   3   36 34                 70
1673859 1673859 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Chicopee - Bowie   Regular School No Elementary KG 05 2021   grade_2 28 2 8 0   3     0   0   19 22 *                     41.0 28 2 8 0   3     0   0   19 22                 41
1673868 1673868 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Chicopee - Litwin   Regular School No Elementary KG 05 2021   grade_2 16 0 3 0   0     0   0   5 14 *                     19.0 16 0 3 0   0     0   0   5 14                 19
1673874 1673874 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Chicopee - Lambert-Lavoie   Regular School No Elementary KG 05 2021   grade_2 26 3 7 0   2     0   2   28 12 *                     40.0 26 3 7 0   2     0   2   28 12                 40
1673880 1673880 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Chicopee - Fairview Elementary   Regular School No Elementary KG 05 2021   grade_2 32 6 39 0   2     0   2   49 32 *                     81.0 32 6 39 0   2     0   2   49 32                 81
1673886 1673886 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Chicopee - Streiber Memorial School   Regular School No Elementary KG 05 2021   grade_2 28 1 3 0   1     0   1   19 15 *                     34.0 28 1 3 0   1     0   1   19 15                 34
1673892 1673892 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Chicopee - Gen John J Stefanik   Regular School No Elementary KG 05 2021   grade_2 12 1 38 0   1     0   3   32 23 *                     55.0 12 1 38 0   1     0   3   32 23                 55
1673912 1673912 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_2 18 0 2 0   0     0   0   10 10 *                     20.0 18 0 2 0   0     0   0   10 10                 20

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