enrollments

Data source: Big Local News · About: Big Local

976 rows where grade = "grade_2", state = "MA" and year = 2018

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 876 ✖

grade ✖

  • grade_2 · 876 ✖
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
2229773 2229773 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston: Richard J Murphy   Regular School No Elementary PK 08 2018   grade_2 14 18 15 1   36     1   1   55 31                       86.0 14 18 15 1   36     1   1   55 31                 86
2229784 2229784 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston: Nathan Hale   Regular School No Elementary PK 05 2018   grade_2 0 16 3 0   1     0   1   10 11                       21.0 0 16 3 0   1     0   1   10 11                 21
2229792 2229792 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston: Oliver Hazard Perry   Regular School No Elementary PK 08 2018   grade_2 15 10 4 0   1     0   0   14 16                       30.0 15 10 4 0   1     0   0   14 16                 30
2229802 2229802 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston: Orchard Gardens   Regular School No Elementary PK 08 2018   grade_2 1 58 32 1   2     0   4   46 52                       98.0 1 58 32 1   2     0   4   46 52                 98
2229820 2229820 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston: Lyndon   Regular School No Elementary PK 08 2018   grade_2 46 3 16 0   0     0   3   39 29                       68.0 46 3 16 0   0     0   3   39 29                 68
2229831 2229831 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Boston: Patrick J Kennedy   Regular School No Elementary PK 05 2018   grade_2 5 0 44 0   1     0   0   33 17                       50.0 5 0 44 0   1     0   0   33 17                 50
2229843 2229843 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Boston: Paul A Dever   Regular School No Elementary PK 05 2018   grade_2 2 7 41 0   5     0   1   28 28                       56.0 2 7 41 0   5     0   1   28 28                 56
2229851 2229851 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Boston: Phineas Bates   Regular School No Elementary PK 05 2018   grade_2 8 13 12 0   3     0   2   18 20                       38.0 8 13 12 0   3     0   2   18 20                 38
2229859 2229859 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Boston: Josiah Quincy   Regular School No Elementary PK 05 2018   grade_2 12 15 14 1   71     0   4   58 59                       117.0 12 15 14 1   71     0   4   58 59                 117
2229867 2229867 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Boston: Roger Clap   Regular School No Elementary PK 05 2018   grade_2 7 12 10 0   2     0   2   17 16                       33.0 7 12 10 0   2     0   2   17 16                 33
2229875 2229875 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Boston: Samuel Adams   Regular School No Elementary PK 05 2018   grade_2 7 1 39 1   0     0   0   22 26                       48.0 7 1 39 1   0     0   0   22 26                 48
2229883 2229883 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Boston: Samuel W Mason   Regular School No Elementary PK 05 2018   grade_2 2 20 14 1   0     0   1   18 20                       38.0 2 20 14 1   0     0   1   18 20                 38
2229891 2229891 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston: Sarah Greenwood   Regular School No Elementary PK 08 2018   grade_2 0 14 39 0   0     0   2   26 29                       55.0 0 14 39 0   0     0   2   26 29                 55
2229902 2229902 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Boston: Gardner Pilot Academy   Regular School No Elementary PK 08 2018   grade_2 3 1 29 0   2     0   5   18 22                       40.0 3 1 29 0   2     0   5   18 22                 40
2229913 2229913 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Boston: Thomas J Kenny   Regular School No Elementary PK 05 2018   grade_2 9 20 11 0   6     0   0   25 21                       46.0 9 20 11 0   6     0   0   25 21                 46
2229921 2229921 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston: Warren-Prescott   Regular School No Elementary PK 08 2018   grade_2 36 9 16 0   4     0   4   30 39                       69.0 36 9 16 0   4     0   4   30 39                 69
2229932 2229932 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston: William Ellery Channing   Regular School No Elementary PK 05 2018   grade_2 3 15 18 0   1     0   1   18 20                       38.0 3 15 18 0   1     0   1   18 20                 38
2229952 2229952 MA Suffolk   school 2502790 35   Boston 250279000337 350366 Boston: William E Russell   Regular School No Elementary PK 05 2018   grade_2 0 21 27 1   8     1   0   26 32                       58.0 0 21 27 1   8     1   0   26 32                 58
2229960 2229960 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston: William Monroe Trotter   Regular School No Elementary PK 08 2018   grade_2 0 31 27 0   2     0   2   31 31                       62.0 0 31 27 0   2     0   2   31 31                 62
2229971 2229971 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Boston: Winship Elementary   Regular School No Elementary PK 05 2018   grade_2 10 4 15 0   2     0   1   21 11                       32.0 10 4 15 0   2     0   1   21 11                 32
2229979 2229979 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston: Edison K-8   Regular School No Elementary PK 08 2018   grade_2 10 12 27 0   15     0   2   37 29                       66.0 10 12 27 0   15     0   2   37 29                 66
2229990 2229990 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston: King K-8   Regular School No Elementary PK 08 2018   grade_2 2 33 15 0   0     1   3   28 26                       54.0 2 33 15 0   0     1   3   28 26                 54
2230009 2230009 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston: Mildred Avenue K-8   Regular School No Elementary PK 08 2018   grade_2 0 35 9 0   0     0   0   20 24                       44.0 0 35 9 0   0     0   0   20 24                 44
2230020 2230020 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston: Young Achievers   Alternative School No Elementary PK 08 2018   grade_2 2 25 32 0   0     0   1   31 29                       60.0 2 25 32 0   0     0   1   31 29                 60
2230031 2230031 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston: Mission Hill School   Regular School No Elementary PK 08 2018   grade_2 9 3 9 0   0     1   0   14 8                       22.0 9 3 9 0   0     1   0   14 8                 22
2230046 2230046 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Boston: Blackstone   Regular School No Elementary PK 05 2018   grade_2 3 17 55 0   1     0   2   43 35                       78.0 3 17 55 0   1     0   2   43 35                 78
2230051 2230051 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_2 24 7 8 0   3     0   2   20 24                       44.0 24 7 8 0   3     0   2   20 24                 44
2230205 2230205 MA Suffolk   school   35   Boston   350652               2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
2230225 2230225 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston: Mario Umana Academy   Regular School No Elementary PK 08 2018   grade_2 1 3 66 0   1     0   0   38 33                       71.0 1 3 66 0   1     0   0   38 33                 71
2230254 2230254 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston: Rafael Hernandez   Regular School No Elementary PK 08 2018   grade_2 2 3 42 0   0     0   1   27 21                       48.0 2 3 42 0   0     0   1   27 21                 48
2230264 2230264 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_2 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2230282 2230282 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne: Bournedale Elementary School   Regular School No Elementary PK 04 2018   grade_2 57 3 4 1   0     1   4   35 35                       70.0 57 3 4 1   0     1   4   35 35                 70
2230288 2230288 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Bourne: Peebles Elementary School   Regular School No Elementary KG 04 2018   grade_2 65 5 8 0   1     1   3   42 41                       83.0 65 5 8 0   1     1   3   42 41                 83
2230305 2230305 MA Essex   school 2502880 38   Boxford 250288000357 380005 Boxford: Harry Lee Cole   Regular School No Elementary PK 02 2018   grade_2 100 0 4 1   3     0   5   60 53                       113.0 100 0 4 1   3     0   5   60 53                 113
2230315 2230315 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston: Boylston Elementary   Regular School No Elementary PK 05 2018   grade_2 42 0 2 0   3     0   2   26 23                       49.0 42 0 2 0   3     0   2   26 23                 49
2230322 2230322 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Braintree: Hollis   Regular School No Elementary KG 05 2018   grade_2 47 3 6 1   23     0   2   46 36                       82.0 47 3 6 1   23     0   2   46 36                 82
2230331 2230331 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Braintree: Highlands   Regular School No Elementary KG 05 2018   grade_2 69 4 2 1   9     0   0   49 36                       85.0 69 4 2 1   9     0   0   49 36                 85
2230338 2230338 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Braintree: Mary E Flaherty School   Regular School No Elementary KG 05 2018   grade_2 44 2 3 1   14     0   4   27 41                       68.0 44 2 3 1   14     0   4   27 41                 68
2230344 2230344 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Braintree: Liberty   Regular School No Elementary 01 05 2018   grade_2 56 1 1 0   25     0   3   42 44                       86.0 56 1 1 0   25     0   3   42 44                 86
2230351 2230351 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Braintree: Archie T Morrison   Regular School No Elementary KG 05 2018   grade_2 65 7 3 0   9     0   2   37 49                       86.0 65 7 3 0   9     0   2   37 49                 86
2230358 2230358 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Braintree: Donald Ross   Regular School No Elementary KG 05 2018   grade_2 31 3 2 0   6     0   0   27 15                       42.0 31 3 2 0   6     0   0   27 15                 42
2230380 2230380 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster: Stony Brook Elementary   Regular School No Elementary PK 02 2018   grade_2 60 2 5 0   0     0   5   37 35                       72.0 60 2 5 0   0     0   5   37 35                 72
2230389 2230389 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield: Brimfield Elementary   Regular School No Elementary PK 06 2018   grade_2 25 1 0 0   1     0   0   15 12                       27.0 25 1 0 0   1     0   0   15 12                 27
2230397 2230397 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Brockton: Dr W Arnone Community School   Regular School No Elementary KG 05 2018   grade_2 21 78 11 3   0     0   9   75 47                       122.0 21 78 11 3   0     0   9   75 47                 122
2230404 2230404 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Brockton: Mary E. Baker School   Regular School No Elementary KG 05 2018   grade_2 35 78 18 0   5     0   3   71 68                       139.0 35 78 18 0   5     0   3   71 68                 139
2230411 2230411 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Brockton: Manthala George Jr. School   Regular School No Elementary KG 05 2018   grade_2 20 41 81 0   1     0   6   69 80                       149.0 20 41 81 0   1     0   6   69 80                 149
2230420 2230420 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brockton: Brookfield   Regular School No Elementary KG 05 2018   grade_2 38 62 5 0   0     0   4   57 52                       109.0 38 62 5 0   0     0   4   57 52                 109
2230427 2230427 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 Brockton: John F Kennedy   Regular School No Elementary KG 05 2018   grade_2 31 43 9 0   7     0   10   43 57                       100.0 31 43 9 0   7     0   10   43 57                 100
2230434 2230434 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton: Edgar B Davis   Regular School No Elementary KG 08 2018   grade_2 20 73 31 0   0     0   10   67 67                       134.0 20 73 31 0   0     0   10   67 67                 134
2230444 2230444 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Brockton: Hancock   Regular School No Elementary KG 05 2018   grade_2 38 43 8 0   2     0   8   43 56                       99.0 38 43 8 0   2     0   8   43 56                 99
2230451 2230451 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Brockton: Gilmore Elementary School   Regular School No Elementary KG 05 2018   grade_2 7 65 17 0   0     0   5   41 53                       94.0 7 65 17 0   0     0   5   41 53                 94
2230458 2230458 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton: Louis F Angelo Elementary   Regular School No Elementary KG 05 2018   grade_2 24 71 21 1   12     0   5   68 66                       134.0 24 71 21 1   12     0   5   68 66                 134
2230465 2230465 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton: Oscar F Raymond   Regular School No Elementary KG 05 2018   grade_2 17 102 18 1   3     0   4   76 69                       145.0 17 102 18 1   3     0   4   76 69                 145
2230476 2230476 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Brockton: Downey   Regular School No Elementary KG 05 2018   grade_2 23 54 23 1   2     0   7   62 48                       110.0 23 54 23 1   2     0   7   62 48                 110
2230530 2230530 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield: Brookfield Elementary   Regular School No Elementary PK 06 2018   grade_2 40 0 2 0   0     0   0   19 23                       42.0 40 0 2 0   0     0   0   19 23                 42
2230542 2230542 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline: Edith C Baker   Regular School No Elementary KG 08 2018   grade_2 45 5 3 0   18     0   5   31 45                       76.0 45 5 3 0   18     0   5   31 45                 76
2230552 2230552 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline: Edward Devotion   Regular School No Elementary KG 08 2018   grade_2 63 8 11 0   10     0   4   54 42                       96.0 63 8 11 0   10     0   4   54 42                 96
2230563 2230563 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline: Michael Driscoll   Regular School No Elementary PK 08 2018   grade_2 32 2 9 0   16     0   9   37 31                       68.0 32 2 9 0   16     0   9   37 31                 68
2230574 2230574 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline: Heath   Regular School No Elementary PK 08 2018   grade_2 34 0 8 0   12     0   7   37 24                       61.0 34 0 8 0   12     0   7   37 24                 61
2230584 2230584 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Brookline: Lawrence   Regular School No Elementary KG 08 2018   grade_2 41 5 7 0   27     0   11   51 40                       91.0 41 5 7 0   27     0   11   51 40                 91
2230594 2230594 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline: William H Lincoln   Regular School No Elementary KG 08 2018   grade_2 26 4 8 0   20     0   4   30 32                       62.0 26 4 8 0   20     0   4   30 32                 62
2230604 2230604 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline: Pierce   Regular School No Elementary KG 08 2018   grade_2 65 7 7 0   24     0   8   52 59                       111.0 65 7 7 0   24     0   8   52 59                 111
2230615 2230615 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline: John D Runkle   Regular School No Elementary PK 08 2018   grade_2 47 1 6 0   7     0   5   35 31                       66.0 47 1 6 0   7     0   5   35 31                 66
2230633 2230633 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Burlington: Fox Hill   Regular School No Elementary KG 05 2018   grade_2 40 5 6 0   17     0   3   39 32                       71.0 40 5 6 0   17     0   3   39 32                 71
2230640 2230640 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Burlington: Memorial   Regular School No Elementary KG 05 2018   grade_2 56 0 4 1   8     0   7   35 41                       76.0 56 0 4 1   8     0   7   35 41                 76
2230647 2230647 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Burlington: Pine Glen Elementary   Regular School No Elementary KG 05 2018   grade_2 45 3 5 0   11     0   2   29 37                       66.0 45 3 5 0   11     0   2   29 37                 66
2230654 2230654 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Burlington: Francis Wyman Elementary   Regular School No Elementary KG 05 2018   grade_2 42 9 9 1   18     0   5   40 44                       84.0 42 9 9 1   18     0   5   40 44                 84
2230673 2230673 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Cambridge: Maria L. Baldwin   Regular School No Elementary PK 05 2018   grade_2 20 8 5 0   4     0   8   25 20                       45.0 20 8 5 0   4     0   8   25 20                 45
2230681 2230681 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge: Amigos School   Regular School No Elementary PK 08 2018   grade_2 16 3 18 0   5     0   3   24 21                       45.0 16 3 18 0   5     0   3   24 21                 45
2230692 2230692 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridge: Cambridgeport   Regular School No Elementary PK 05 2018   grade_2 28 8 1 0   3     0   2   19 23                       42.0 28 8 1 0   3     0   2   19 23                 42
2230700 2230700 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Cambridge: Haggerty   Regular School No Elementary PK 05 2018   grade_2 19 9 4 0   5     0   5   23 19                       42.0 19 9 4 0   5     0   5   23 19                 42
2230708 2230708 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Cambridge: Martin Luther King Jr.   Regular School No Elementary PK 05 2018   grade_2 13 11 8 0   5     0   11   22 26                       48.0 13 11 8 0   5     0   11   22 26                 48
2230716 2230716 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 Cambridge: King Open   Alternative School No Elementary PK 05 2018   grade_2 31 4 8 0   4     0   4   23 28                       51.0 31 4 8 0   4     0   4   23 28                 51
2230724 2230724 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Cambridge: Kennedy-Longfellow   Regular School No Elementary PK 05 2018   grade_2 15 7 8 0   11     0   4   28 17                       45.0 15 7 8 0   11     0   4   28 17                 45
2230732 2230732 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Cambridge: Morse   Regular School No Elementary PK 05 2018   grade_2 16 11 7 1   4     0   4   21 22                       43.0 16 11 7 1   4     0   4   21 22                 43
2230740 2230740 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Cambridge: Peabody   Regular School No Elementary PK 05 2018   grade_2 26 8 1 0   9     0   3   17 30                       47.0 26 8 1 0   9     0   3   17 30                 47
2230748 2230748 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 Cambridge: John M Tobin   Regular School No Elementary PK 05 2018   grade_2 18 6 6 1   4     0   4   16 23                       39.0 18 6 6 1   4     0   4   16 23                 39
2230756 2230756 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Cambridge: Graham and Parks   Alternative School No Elementary PK 05 2018   grade_2 30 13 2 0   9     0   2   29 27                       56.0 30 13 2 0   9     0   2   29 27                 56
2230764 2230764 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Cambridge: Fletcher/Maynard Academy   Regular School No Elementary PK 05 2018   grade_2 8 20 5 0   2     0   2   20 17                       37.0 8 20 5 0   2     0   2   20 17                 37
2230794 2230794 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Canton: Lt Peter M Hansen   Regular School No Elementary KG 05 2018   grade_2 46 14 4 0   10     0   5   38 41                       79.0 46 14 4 0   10     0   5   38 41                 79
2230801 2230801 MA Norfolk   school 2503300 50   Canton 250330000454 500017 Canton: John F Kennedy   Regular School No Elementary KG 05 2018   grade_2 63 5 5 0   11     0   4   47 41                       88.0 63 5 5 0   11     0   4   47 41                 88
2230808 2230808 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Canton: Dean S Luce   Regular School No Elementary KG 05 2018   grade_2 50 8 4 0   12     0   7   40 41                       81.0 50 8 4 0   12     0   7   40 41                 81
2230825 2230825 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle: Carlisle School   Regular School No Elementary PK 08 2018   grade_2 52 0 2 0   4     0   2   35 25                       60.0 52 0 2 0   4     0   2   35 25                 60
2230836 2230836 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver: Carver Elementary School   Regular School No Elementary PK 05 2018   grade_2 115 1 3 0   2     0   1   67 55                       122.0 115 1 3 0   2     0   1   67 55                 122
2230853 2230853 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Chelmsford: Center Elementary School   Regular School No Elementary KG 04 2018   grade_2 53 6 3 0   18     0   2   40 42                       82.0 53 6 3 0   18     0   2   40 42                 82
2230859 2230859 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 Chelmsford: South Row   Regular School No Elementary KG 04 2018   grade_2 56 0 11 0   8     0   2   41 36                       77.0 56 0 11 0   8     0   2   41 36                 77
2230865 2230865 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Chelmsford: Charles D Harrington   Regular School No Elementary KG 04 2018   grade_2 54 3 14 0   14     0   6   47 44                       91.0 54 3 14 0   14     0   6   47 44                 91
2230871 2230871 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Chelmsford: Byam School   Regular School No Elementary KG 04 2018   grade_2 76 3 10 0   7     0   3   54 45                       99.0 76 3 10 0   7     0   3   54 45                 99
2230895 2230895 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea: William A Berkowitz Elementary   Regular School No Elementary 01 04 2018   grade_2 6 8 103 0   1     0   1   65 54                       119.0 6 8 103 0   1     0   1   65 54                 119
2230900 2230900 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea: Edgar A Hooks Elementary   Regular School No Elementary 01 04 2018   grade_2 13 8 127 0   1     0   4   89 64                       153.0 13 8 127 0   1     0   4   89 64                 153
2230905 2230905 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea: George F. Kelly Elementary   Regular School No Elementary 01 04 2018   grade_2 9 3 107 0   0     0   1   57 63                       120.0 9 3 107 0   0     0   1   57 63                 120
2230910 2230910 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea: Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2018   grade_2 15 4 118 0   0     0   2   66 73                       139.0 15 4 118 0   0     0   2   66 73                 139
2230938 2230938 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Chicopee: Barry   Regular School No Elementary KG 05 2018   grade_2 39 0 15 0   1     0   2   28 29                       57.0 39 0 15 0   1     0   2   28 29                 57
2230945 2230945 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Chicopee: Belcher   Regular School No Elementary KG 02 2018   grade_2 45 7 22 0   0     0   2   40 36                       76.0 45 7 22 0   0     0   2   40 36                 76
2230950 2230950 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Chicopee: Bowe   Regular School No Elementary PK 05 2018   grade_2 28 5 28 0   1     0   5   36 31                       67.0 28 5 28 0   1     0   5   36 31                 67
2230957 2230957 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Chicopee: Bowie   Regular School No Elementary KG 05 2018   grade_2 46 2 12 1   1     1   0   41 22                       63.0 46 2 12 1   1     1   0   41 22                 63
2230971 2230971 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Chicopee: Litwin   Regular School No Elementary KG 05 2018   grade_2 19 1 5 0   0     0   1   14 12                       26.0 19 1 5 0   0     0   1   14 12                 26
2230978 2230978 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Chicopee: Lambert-Lavoie   Regular School No Elementary KG 05 2018   grade_2 42 1 14 0   0     0   0   30 27                       57.0 42 1 14 0   0     0   0   30 27                 57
2230985 2230985 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Chicopee: Fairview Elementary   Regular School No Elementary KG 05 2018   grade_2 30 2 35 0   1     0   4   35 37                       72.0 30 2 35 0   1     0   4   35 37                 72
2230992 2230992 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Chicopee: Streiber Memorial School   Regular School No Elementary KG 05 2018   grade_2 32 3 8 0   0     0   0   23 20                       43.0 32 3 8 0   0     0   0   23 20                 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]);