enrollments

Data source: Big Local News · About: Big Local

972 rows where grade = "grade_2", state = "MA" and year = 2020

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 872 ✖

grade ✖

  • grade_2 · 872 ✖
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
1365630 1365630 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2020   grade_2 9 15 11 0   49     0   5   41 48 *                     89.0 9 15 11 0   49     0   5   41 48                 89
1365640 1365640 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2020   grade_2 1 12 6 0   0     0   0   11 8 *                     19.0 1 12 6 0   0     0   0   11 8                 19
1365647 1365647 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_2 19 4 4 0   0     0   0   15 12 *                     27.0 19 4 4 0   0     0   0   15 12                 27
1365657 1365657 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_2 0 53 36 1   0     0   2   54 38 *                     92.0 0 53 36 1   0     0   2   54 38                 92
1365673 1365673 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2020   grade_2 39 5 19 1   3     0   5   38 34 *                     72.0 39 5 19 1   3     0   5   38 34                 72
1365683 1365683 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No Elementary PK 05 2020   grade_2 2 0 36 0   3     0   0   23 18 *                     41.0 2 0 36 0   3     0   0   23 18                 41
1365693 1365693 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No Elementary PK 05 2020   grade_2 4 18 43 0   4     0   1   36 34 *                     70.0 4 18 43 0   4     0   1   36 34                 70
1365700 1365700 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No Elementary PK 05 2020   grade_2 14 11 13 0   1     0   1   25 15 *                     40.0 14 11 13 0   1     0   1   25 15                 40
1365707 1365707 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2020   grade_2 10 14 10 0   80     0   3   63 54 *                     117.0 10 14 10 0   80     0   3   63 54                 117
1365714 1365714 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2020   grade_2 2 4 7 0   2     0   2   11 6 *                     17.0 2 4 7 0   2     0   2   11 6                 17
1365721 1365721 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Samuel Adams   Regular School No Elementary PK 05 2020   grade_2 3 1 35 0   0     0   0   19 20 *                     39.0 3 1 35 0   0     0   0   19 20                 39
1365728 1365728 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No Elementary PK 05 2020   grade_2 2 20 14 0   1     0   3   22 18 *                     40.0 2 20 14 0   1     0   3   22 18                 40
1365735 1365735 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2020   grade_2 0 2 41 0   0     0   2   26 19 *                     45.0 0 2 41 0   0     0   2   26 19                 45
1365745 1365745 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2020   grade_2 4 6 28 0   1     0   1   19 21 *                     40.0 4 6 28 0   1     0   1   19 21                 40
1365755 1365755 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No Elementary PK 05 2020   grade_2 13 9 7 0   5     0   6   22 18 *                     40.0 13 9 7 0   5     0   6   22 18                 40
1365762 1365762 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2020   grade_2 42 5 18 0   1     0   3   39 30 *                     69.0 42 5 18 0   1     0   3   39 30                 69
1365772 1365772 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No Elementary PK 05 2020   grade_2 3 19 15 0   0     0   0   23 14 *                     37.0 3 19 15 0   0     0   0   23 14                 37
1365776 1365776 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_2 0 2 4 0   0     0   1   6 1 *                     7.0 0 2 4 0   0     0   1   6 1                 7
1365791 1365791 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No Elementary PK 05 2020   grade_2 1 12 37 1   10     0   3   32 32 *                     64.0 1 12 37 1   10     0   3   32 32                 64
1365798 1365798 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   grade_2 1 36 19 0   0     1   3   25 35 *                     60.0 1 36 19 0   0     1   3   25 35                 60
1365808 1365808 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2020   grade_2 12 6 8 0   7     0   5   19 19 *                     38.0 12 6 8 0   7     0   5   19 19                 38
1365815 1365815 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2020   grade_2 8 10 41 1   9     1   2   49 23 *                     72.0 8 10 41 1   9     1   2   49 23                 72
1365825 1365825 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2020   grade_2 2 35 28 0   0     0   2   35 32 *                     67.0 2 35 28 0   0     0   2   35 32                 67
1365841 1365841 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2020   grade_2 0 30 11 1   0     0   1   24 19 *                     43.0 0 30 11 1   0     0   1   24 19                 43
1365851 1365851 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_2 1 22 40 0   0     0   0   37 26 *                     63.0 1 22 40 0   0     0   0   37 26                 63
1365861 1365861 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2020   grade_2 8 5 5 0   1     0   2   12 9 *                     21.0 8 5 5 0   1     0   2   12 9                 21
1365874 1365874 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No Elementary PK 05 2020   grade_2 3 29 41 0   1     0   1   42 33 *                     75.0 3 29 41 0   1     0   1   42 33                 75
1365878 1365878 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_2 29 15 13 0   12     0   2   35 36 *                     71.0 29 15 13 0   12     0   2   35 36                 71
1366013 1366013 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2020   grade_2 3 1 72 0   4     0   1   44 37 *                     81.0 3 1 72 0   4     0   1   44 37                 81
1366035 1366035 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2020   grade_2 3 1 43 0   0     0   3   28 22 *                     50.0 3 1 43 0   0     0   3   28 22                 50
1366044 1366044 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_2 2 5 2 0   0     0   0   6 3 *                     9.0 2 5 2 0   0     0   0   6 3                 9
1366060 1366060 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 02 2020   grade_2 125 3 8 0   1     0   6   68 75 *                     143.0 125 3 8 0   1     0   6   68 75                 143
1366075 1366075 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2020   grade_2 78 0 1 0   2     0   6   41 46 *                     87.0 78 0 1 0   2     0   6   41 46                 87
1366082 1366082 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Hollis   Regular School No Elementary KG 05 2020   grade_2 37 1 4 0   15     0   3   34 26 *                     60.0 37 1 4 0   15     0   3   34 26                 60
1366089 1366089 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No Elementary KG 05 2020   grade_2 41 0 1 0   21     0   1   34 30 *                     64.0 41 0 1 0   21     0   1   34 30                 64
1366095 1366095 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Mary E Flaherty School   Regular School No Elementary KG 05 2020   grade_2 41 1 3 0   14     0   5   28 36 *                     64.0 41 1 3 0   14     0   5   28 36                 64
1366100 1366100 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2020   grade_2 40 4 4 0   19     1   3   42 29 *                     71.0 40 4 4 0   19     1   3   42 29                 71
1366106 1366106 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No Elementary KG 05 2020   grade_2 55 6 3 0   11     0   0   52 23 *                     75.0 55 6 3 0   11     0   0   52 23                 75
1366112 1366112 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No Elementary KG 05 2020   grade_2 35 4 1 0   11     0   0   25 26 *                     51.0 35 4 1 0   11     0   0   25 26                 51
1366130 1366130 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2020   grade_2 54 0 1 0   0     0   2   36 21 *                     57.0 54 0 1 0   0     0   2   36 21                 57
1366137 1366137 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2020   grade_2 40 0 0 0   0     0   0   18 22 *                     40.0 40 0 0 0   0     0   0   18 22                 40
1366145 1366145 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2020   grade_2 9 69 29 0   0     0   6   66 47 *                     113.0 9 69 29 0   0     0   6   66 47                 113
1366151 1366151 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2020   grade_2 31 63 13 0   2     0   11   56 64 *                     120.0 31 63 13 0   2     0   11   56 64                 120
1366157 1366157 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2020   grade_2 19 67 65 0   0     0   7   84 74 *                     158.0 19 67 65 0   0     0   7   84 74                 158
1366164 1366164 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2020   grade_2 14 50 10 0   0     0   4   40 38 *                     78.0 14 50 10 0   0     0   4   40 38                 78
1366170 1366170 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2020   grade_2 20 62 9 0   1     0   3   44 51 *                     95.0 20 62 9 0   1     0   3   44 51                 95
1366176 1366176 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_2 19 87 14 1   0     0   11   66 66 *                     132.0 19 87 14 1   0     0   11   66 66                 132
1366185 1366185 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No Elementary KG 05 2020   grade_2 20 51 5 0   5     0   4   33 52 *                     85.0 20 51 5 0   5     0   4   33 52                 85
1366191 1366191 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Gilmore Elementary School   Regular School No Elementary KG 05 2020   grade_2 2 58 6 1   1     0   2   34 36 *                     70.0 2 58 6 1   1     0   2   34 36                 70
1366197 1366197 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2020   grade_2 18 70 15 0   6     0   3   60 52 *                     112.0 18 70 15 0   6     0   3   60 52                 112
1366203 1366203 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2020   grade_2 5 103 13 0   3     0   5   58 71 *                     129.0 5 103 13 0   3     0   5   58 71                 129
1366212 1366212 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2020   grade_2 18 62 16 1   1     0   4   65 37 *                     102.0 18 62 16 1   1     0   4   65 37                 102
1366258 1366258 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_2 36 0 3 0   0     0   2   23 18 *                     41.0 36 0 3 0   0     0   2   23 18                 41
1366268 1366268 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2020   grade_2 36 7 4 0   30     0   9   47 39 *                     86.0 36 7 4 0   30     0   9   47 39                 86
1366278 1366278 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2020   grade_2 49 5 7 0   21     0   11   55 38 *                     93.0 49 5 7 0   21     0   11   55 38                 93
1366287 1366287 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary KG 08 2020   grade_2 30 3 4 0   17     0   9   44 19 *                     63.0 30 3 4 0   17     0   9   44 19                 63
1366297 1366297 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2020   grade_2 38 1 3 0   7     0   12   31 30 *                     61.0 38 1 3 0   7     0   12   31 30                 61
1366306 1366306 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2020   grade_2 35 5 7 0   25     0   9   40 41 *                     81.0 35 5 7 0   25     0   9   40 41                 81
1366315 1366315 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2020   grade_2 29 8 10 1   19     0   3   27 43 *                     70.0 29 8 10 1   19     0   3   27 43                 70
1366324 1366324 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2020   grade_2 42 4 7 0   31     0   12   51 45 *                     96.0 42 4 7 0   31     0   12   51 45                 96
1366334 1366334 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2020   grade_2 38 1 10 0   10     0   4   37 26 *                     63.0 38 1 10 0   10     0   4   37 26                 63
1366349 1366349 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Fox Hill   Regular School No Elementary KG 05 2020   grade_2 43 3 3 0   19     0   7   39 36 *                     75.0 43 3 3 0   19     0   7   39 36                 75
1366355 1366355 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Memorial   Regular School No Elementary KG 05 2020   grade_2 39 2 10 0   14     0   3   35 33 *                     68.0 39 2 10 0   14     0   3   35 33                 68
1366361 1366361 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Pine Glen Elementary   Regular School No Elementary KG 05 2020   grade_2 35 3 2 0   18     0   6   37 27 *                     64.0 35 3 2 0   18     0   6   37 27                 64
1366367 1366367 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Francis Wyman Elementary   Regular School No Elementary KG 05 2020   grade_2 53 10 7 0   18     0   3   50 41 *                     91.0 53 10 7 0   18     0   3   50 41                 91
1366383 1366383 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No Elementary PK 05 2020   grade_2 31 2 7 0   3     0   10   23 30 *                     53.0 31 2 7 0   3     0   10   23 30                 53
1366390 1366390 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2020   grade_2 19 2 22 0   1     0   4   18 30 *                     48.0 19 2 22 0   1     0   4   18 30                 48
1366400 1366400 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2020   grade_2 31 6 4 0   5     0   9   29 26 *                     55.0 31 6 4 0   5     0   9   29 26                 55
1366407 1366407 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No Elementary PK 05 2020   grade_2 20 6 5 0   10     0   1   23 19 *                     42.0 20 6 5 0   10     0   1   23 19                 42
1366414 1366414 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2020   grade_2 15 7 1 0   16     0   13   27 25 *                     52.0 15 7 1 0   16     0   13   27 25                 52
1366421 1366421 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2020   grade_2 28 10 8 1   10     0   6   32 31 *                     63.0 28 10 8 1   10     0   6   32 31                 63
1366428 1366428 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No Elementary PK 05 2020   grade_2 15 13 6 0   10     1   3   20 28 *                     48.0 15 13 6 0   10     1   3   20 28                 48
1366435 1366435 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2020   grade_2 17 14 4 0   5     0   5   27 18 *                     45.0 17 14 4 0   5     0   5   27 18                 45
1366442 1366442 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No Elementary PK 05 2020   grade_2 23 7 5 0   5     0   6   21 25 *                     46.0 23 7 5 0   5     0   6   21 25                 46
1366449 1366449 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No Elementary PK 05 2020   grade_2 17 7 4 1   3     0   4   16 20 *                     36.0 17 7 4 1   3     0   4   16 20                 36
1366456 1366456 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2020   grade_2 31 9 3 0   11     0   3   31 26 *                     57.0 31 9 3 0   11     0   3   31 26                 57
1366463 1366463 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No Elementary PK 05 2020   grade_2 6 20 7 0   4     0   3   28 12 *                     40.0 6 20 7 0   4     0   3   28 12                 40
1366487 1366487 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Lt Peter M Hansen   Regular School No Elementary KG 05 2020   grade_2 43 6 9 0   12     0   6   35 41 *                     76.0 43 6 9 0   12     0   6   35 41                 76
1366493 1366493 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No Elementary KG 05 2020   grade_2 59 6 9 0   6     0   7   44 43 *                     87.0 59 6 9 0   6     0   7   44 43                 87
1366499 1366499 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No Elementary KG 05 2020   grade_2 50 7 2 0   5     0   2   36 30 *                     66.0 50 7 2 0   5     0   2   36 30                 66
1366514 1366514 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2020   grade_2 52 0 4 0   4     0   5   31 34 *                     65.0 52 0 4 0   4     0   5   31 34                 65
1366524 1366524 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2020   grade_2 107 3 1 0   0     0   2   55 58 *                     113.0 107 3 1 0   0     0   2   55 58                 113
1366539 1366539 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No Elementary KG 04 2020   grade_2 69 3 6 0   24     0   3   54 51 *                     105.0 69 3 6 0   24     0   3   54 51                 105
1366544 1366544 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 South Row   Regular School No Elementary KG 04 2020   grade_2 63 5 4 0   16     0   3   40 51 *                     91.0 63 5 4 0   16     0   3   40 51                 91
1366549 1366549 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No Elementary KG 04 2020   grade_2 63 5 10 0   21     0   0   47 52 *                     99.0 63 5 10 0   21     0   0   47 52                 99
1366554 1366554 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2020   grade_2 77 1 6 1   20     0   5   55 55 *                     110.0 77 1 6 1   20     0   5   55 55                 110
1366573 1366573 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2020   grade_2 6 10 108 0   0     0   7   66 65 *                     131.0 6 10 108 0   0     0   7   66 65                 131
1366577 1366577 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2020   grade_2 20 7 122 0   0     0   1   74 76 *                     150.0 20 7 122 0   0     0   1   74 76                 150
1366581 1366581 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_2 4 5 96 0   0     0   0   47 58 *                     105.0 4 5 96 0   0     0   0   47 58                 105
1366587 1366587 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2020   grade_2 12 7 124 0   0     0   2   66 79 *                     145.0 12 7 124 0   0     0   2   66 79                 145
1366613 1366613 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No Elementary KG 05 2020   grade_2 49 0 20 0   2     0   1   35 37 *                     72.0 49 0 20 0   2     0   1   35 37                 72
1366619 1366619 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2020   grade_2 41 10 43 0   1     0   3   52 46 *                     98.0 41 10 43 0   1     0   3   52 46                 98
1366622 1366622 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No Elementary KG 05 2020   grade_2 25 5 41 0   1     0   4   39 37 *                     76.0 25 5 41 0   1     0   4   39 37                 76
1366628 1366628 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No Elementary KG 05 2020   grade_2 29 0 6 0   1     0   2   18 20 *                     38.0 29 0 6 0   1     0   2   18 20                 38
1366640 1366640 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2020   grade_2 18 0 5 0   1     0   0   14 10 *                     24.0 18 0 5 0   1     0   0   14 10                 24
1366646 1366646 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No Elementary KG 05 2020   grade_2 26 1 18 0   0     0   1   27 19 *                     46.0 26 1 18 0   0     0   1   27 19                 46
1366652 1366652 MA Hampden   school 2503660 61   Chicopee 250366002463 610050 Fairview Elementary   Regular School No Elementary KG 05 2020   grade_2 30 3 36 0   2     0   3   48 26 *                     74.0 30 3 36 0   2     0   3   48 26                 74
1366658 1366658 MA Hampden   school 2503660 61   Chicopee 250366000504 610065 Streiber Memorial School   Regular School No Elementary KG 05 2020   grade_2 23 2 9 0   3     0   2   25 14 *                     39.0 23 2 9 0   3     0   2   25 14                 39
1366664 1366664 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No Elementary KG 05 2020   grade_2 14 3 34 0   0     0   1   25 27 *                     52.0 14 3 34 0   0     0   1   25 27                 52
1366684 1366684 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_2 31 0 1 0   0     0   0   19 13 *                     32.0 31 0 1 0   0     0   0   19 13                 32

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