enrollments

Data source: Big Local News · About: Big Local

975 rows where grade = "grade_1", state = "MA" and year = 2020 sorted by ccd_charter_school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 875 ✖

grade ✖

  • grade_1 · 875 ✖
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
1365598 1365598 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No Elementary PK 05 2020   grade_1 7 29 14 0   31     0   6   43 44 *                     87.0 7 29 14 0   31     0   6   43 44                 87
1365605 1365605 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2020   grade_1 3 14 27 0   0     0   2   25 21 *                     46.0 3 14 27 0   0     0   2   25 21                 46
1365615 1365615 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary PK 05 2020   grade_1 2 8 9 0   1     0   0   6 14 *                     20.0 2 8 9 0   1     0   0   6 14                 20
1365622 1365622 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2020   grade_1 15 4 5 0   0     0   1   12 13 *                     25.0 15 4 5 0   0     0   1   12 13                 25
1365629 1365629 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2020   grade_1 7 11 14 0   39     0   1   40 32 *                     72.0 7 11 14 0   39     0   1   40 32                 72
1365639 1365639 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2020   grade_1 3 9 7 0   4     0   0   9 14 *                     23.0 3 9 7 0   4     0   0   9 14                 23
1365646 1365646 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_1 19 4 1 0   1     0   2   14 13 *                     27.0 19 4 1 0   1     0   2   14 13                 27
1365656 1365656 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_1 4 40 32 2   1     0   3   36 46 *                     82.0 4 40 32 2   1     0   3   36 46                 82
1365672 1365672 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2020   grade_1 43 6 14 0   1     0   4   35 33 *                     68.0 43 6 14 0   1     0   4   35 33                 68
1365682 1365682 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Patrick J Kennedy   Regular School No Elementary PK 05 2020   grade_1 1 1 35 0   0     0   1   20 18 *                     38.0 1 1 35 0   0     0   1   20 18                 38
1365689 1365689 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No Elementary PK 01 2020   grade_1 16 28 10 0   11     1   4   41 29 *                     70.0 16 28 10 0   11     1   4   41 29                 70
1365692 1365692 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No Elementary PK 05 2020   grade_1 4 19 33 0   2     0   0   38 20 *                     58.0 4 19 33 0   2     0   0   38 20                 58
1365699 1365699 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No Elementary PK 05 2020   grade_1 9 14 14 0   2     0   1   23 17 *                     40.0 9 14 14 0   2     0   1   23 17                 40
1365706 1365706 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No Elementary PK 05 2020   grade_1 19 13 10 0   67     0   5   52 62 *                     114.0 19 13 10 0   67     0   5   52 62                 114
1365713 1365713 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2020   grade_1 4 4 7 0   2     0   1   8 10 *                     18.0 4 4 7 0   2     0   1   8 10                 18
1365720 1365720 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Samuel Adams   Regular School No Elementary PK 05 2020   grade_1 6 1 24 0   1     0   0   17 15 *                     32.0 6 1 24 0   1     0   0   17 15                 32
1365727 1365727 MA Suffolk   school 2502790 35   Boston 250279000322 350304 Samuel W Mason   Regular School No Elementary PK 05 2020   grade_1 3 21 11 0   0     0   2   22 14 *                     37.0 3 21 11 0   0     0   2   22 14                 37
1365734 1365734 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2020   grade_1 0 2 36 0   1     0   0   24 15 *                     39.0 0 2 36 0   1     0   0   24 15                 39
1365744 1365744 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2020   grade_1 8 5 25 0   1     0   2   28 13 *                     41.0 8 5 25 0   1     0   2   28 13                 41
1365754 1365754 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Thomas J Kenny   Regular School No Elementary PK 05 2020   grade_1 11 12 10 0   7     0   2   20 22 *                     42.0 11 12 10 0   7     0   2   20 22                 42
1365761 1365761 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2020   grade_1 47 9 8 0   3     0   4   42 29 *                     71.0 47 9 8 0   3     0   4   42 29                 71
1365771 1365771 MA Suffolk   school 2502790 35   Boston 250279000338 350360 William Ellery Channing   Regular School No Elementary PK 05 2020   grade_1 2 14 17 0   2     0   1   18 18 *                     36.0 2 14 17 0   2     0   1   18 18                 36
1365790 1365790 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No Elementary PK 05 2020   grade_1 2 16 33 0   7     0   0   35 23 *                     58.0 2 16 33 0   7     0   0   35 23                 58
1365797 1365797 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   grade_1 0 32 19 0   1     2   2   25 31 *                     56.0 0 32 19 0   1     2   2   25 31                 56
1365807 1365807 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2020   grade_1 7 6 10 0   15     0   4   23 19 *                     42.0 7 6 10 0   15     0   4   23 19                 42
1365814 1365814 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2020   grade_1 5 8 26 0   15     0   6   33 27 *                     60.0 5 8 26 0   15     0   6   33 27                 60
1365824 1365824 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2020   grade_1 4 37 17 1   1     0   3   33 30 *                     63.0 4 37 17 1   1     0   3   33 30                 63
1365840 1365840 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2020   grade_1 1 30 9 0   1     0   0   22 19 *                     41.0 1 30 9 0   1     0   0   22 19                 41
1365850 1365850 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_1 0 30 27 0   0     0   0   31 26 *                     57.0 0 30 27 0   0     0   0   31 26                 57
1365860 1365860 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2020   grade_1 11 6 3 0   0     0   2   12 10 *                     22.0 11 6 3 0   0     0   2   12 10                 22
1365873 1365873 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No Elementary PK 05 2020   grade_1 3 22 48 0   3     0   3   44 35 *                     79.0 3 22 48 0   3     0   3   44 35                 79
1366012 1366012 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2020   grade_1 6 3 54 0   0     0   0   37 26 *                     63.0 6 3 54 0   0     0   0   37 26                 63
1366034 1366034 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2020   grade_1 3 2 45 0   0     0   0   24 26 *                     50.0 3 2 45 0   0     0   0   24 26                 50
1366043 1366043 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_1 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1366059 1366059 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 02 2020   grade_1 106 2 7 1   3     0   5   57 67 *                     124.0 106 2 7 1   3     0   5   57 67                 124
1366074 1366074 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2020   grade_1 66 0 4 0   1     0   9   44 36 *                     80.0 66 0 4 0   1     0   9   44 36                 80
1366081 1366081 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Hollis   Regular School No Elementary KG 05 2020   grade_1 60 1 2 0   21     0   1   51 34 *                     85.0 60 1 2 0   21     0   1   51 34                 85
1366088 1366088 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No Elementary KG 05 2020   grade_1 63 1 2 0   14     0   0   40 40 *                     80.0 63 1 2 0   14     0   0   40 40                 80
1366094 1366094 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Mary E Flaherty School   Regular School No Elementary KG 05 2020   grade_1 33 0 3 0   21     0   1   34 24 *                     58.0 33 0 3 0   21     0   1   34 24                 58
1366099 1366099 MA Norfolk   school 2502940 40   Braintree 250294000368 400025 Liberty   Regular School No Elementary 01 05 2020   grade_1 44 1 6 0   26     0   2   40 39 *                     79.0 44 1 6 0   26     0   2   40 39                 79
1366105 1366105 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No Elementary KG 05 2020   grade_1 62 7 6 0   20     0   0   38 57 *                     95.0 62 7 6 0   20     0   0   38 57                 95
1366111 1366111 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No Elementary KG 05 2020   grade_1 24 2 1 0   16     0   1   22 22 *                     44.0 24 2 1 0   16     0   1   22 22                 44
1366129 1366129 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2020   grade_1 58 1 8 0   0     0   4   30 41 *                     71.0 58 1 8 0   0     0   4   30 41                 71
1366136 1366136 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2020   grade_1 27 0 1 0   0     0   0   15 13 *                     28.0 27 0 1 0   0     0   0   15 13                 28
1366144 1366144 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary PK 05 2020   grade_1 7 62 21 0   0     0   6   56 40 *                     96.0 7 62 21 0   0     0   6   56 40                 96
1366150 1366150 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2020   grade_1 29 41 15 0   3     0   6   50 44 *                     94.0 29 41 15 0   3     0   6   50 44                 94
1366156 1366156 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2020   grade_1 15 95 73 0   1     0   5   98 91 *                     189.0 15 95 73 0   1     0   5   98 91                 189
1366163 1366163 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2020   grade_1 22 48 4 1   0     0   10   51 34 *                     85.0 22 48 4 1   0     0   10   51 34                 85
1366169 1366169 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No Elementary KG 05 2020   grade_1 21 61 12 0   3     0   3   49 51 *                     100.0 21 61 12 0   3     0   3   49 51                 100
1366175 1366175 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_1 7 67 10 1   1     1   7   49 45 *                     94.0 7 67 10 1   1     1   7   49 45                 94
1366184 1366184 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No Elementary KG 05 2020   grade_1 18 39 13 0   2     1   4   36 41 *                     77.0 18 39 13 0   2     1   4   36 41                 77
1366190 1366190 MA Plymouth   school 2503090 44   Brockton 250309000398 440055 Gilmore Elementary School   Regular School No Elementary KG 05 2020   grade_1 1 55 9 0   0     0   1   27 39 *                     66.0 1 55 9 0   0     0   1   27 39                 66
1366196 1366196 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2020   grade_1 25 67 12 0   6     0   6   64 52 *                     116.0 25 67 12 0   6     0   6   64 52                 116
1366202 1366202 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2020   grade_1 7 96 18 0   0     0   1   69 53 *                     122.0 7 96 18 0   0     0   1   69 53                 122
1366211 1366211 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2020   grade_1 20 45 13 0   3     0   4   46 39 *                     85.0 20 45 13 0   3     0   4   46 39                 85
1366257 1366257 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_1 35 0 3 0   0     0   1   21 18 *                     39.0 35 0 3 0   0     0   1   21 18                 39
1366267 1366267 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2020   grade_1 35 4 4 0   30     0   5   32 46 *                     78.0 35 4 4 0   30     0   5   32 46                 78
1366277 1366277 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2020   grade_1 76 4 15 0   8     0   12   54 60 *                     115.0 76 4 15 0   8     0   12   54 60                 115
1366286 1366286 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary KG 08 2020   grade_1 31 3 3 0   15     0   10   29 33 *                     62.0 31 3 3 0   15     0   10   29 33                 62
1366296 1366296 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2020   grade_1 32 4 4 0   12     0   8   29 31 *                     60.0 32 4 4 0   12     0   8   29 31                 60
1366305 1366305 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2020   grade_1 39 4 7 0   30     0   5   40 45 *                     85.0 39 4 7 0   30     0   5   40 45                 85
1366314 1366314 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2020   grade_1 22 4 8 0   19     0   4   29 28 *                     57.0 22 4 8 0   19     0   4   29 28                 57
1366323 1366323 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2020   grade_1 46 4 4 0   31     0   10   50 45 *                     95.0 46 4 4 0   31     0   10   50 45                 95
1366333 1366333 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2020   grade_1 28 4 6 0   11     0   12   33 28 *                     61.0 28 4 6 0   11     0   12   33 28                 61
1366348 1366348 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Fox Hill   Regular School No Elementary KG 05 2020   grade_1 64 4 6 0   17     0   1   41 51 *                     92.0 64 4 6 0   17     0   1   41 51                 92
1366354 1366354 MA Middlesex   school 2503240 48   Burlington 250324000431 480015 Memorial   Regular School No Elementary KG 05 2020   grade_1 44 2 5 0   13     0   3   38 29 *                     67.0 44 2 5 0   13     0   3   38 29                 67
1366360 1366360 MA Middlesex   school 2503240 48   Burlington 250324000432 480020 Pine Glen Elementary   Regular School No Elementary KG 05 2020   grade_1 46 1 2 0   6     0   3   30 28 *                     58.0 46 1 2 0   6     0   3   30 28                 58
1366366 1366366 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Francis Wyman Elementary   Regular School No Elementary KG 05 2020   grade_1 42 12 5 0   15     0   5   40 39 *                     79.0 42 12 5 0   15     0   5   40 39                 79
1366382 1366382 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No Elementary PK 05 2020   grade_1 37 8 5 0   4     0   3   34 23 *                     57.0 37 8 5 0   4     0   3   34 23                 57
1366389 1366389 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2020   grade_1 25 1 15 0   2     0   2   25 20 *                     45.0 25 1 15 0   2     0   2   25 20                 45
1366399 1366399 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2020   grade_1 27 8 4 0   1     0   5   21 24 *                     45.0 27 8 4 0   1     0   5   21 24                 45
1366406 1366406 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Haggerty   Regular School No Elementary PK 05 2020   grade_1 20 7 3 0   10     0   2   13 29 *                     42.0 20 7 3 0   10     0   2   13 29                 42
1366413 1366413 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2020   grade_1 17 9 2 1   14     0   10   26 27 *                     53.0 17 9 2 1   14     0   10   26 27                 53
1366420 1366420 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2020   grade_1 29 9 6 0   3     0   10   28 29 *                     57.0 29 9 6 0   3     0   10   28 29                 57
1366427 1366427 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No Elementary PK 05 2020   grade_1 12 12 8 0   9     0   4   24 21 *                     45.0 12 12 8 0   9     0   4   24 21                 45
1366434 1366434 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2020   grade_1 24 11 3 0   4     0   5   17 30 *                     47.0 24 11 3 0   4     0   5   17 30                 47
1366441 1366441 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No Elementary PK 05 2020   grade_1 22 10 2 0   9     0   2   24 21 *                     45.0 22 10 2 0   9     0   2   24 21                 45
1366448 1366448 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No Elementary PK 05 2020   grade_1 19 7 6 0   7     0   3   22 20 *                     42.0 19 7 6 0   7     0   3   22 20                 42
1366455 1366455 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Graham and Parks   Alternative School No Elementary PK 05 2020   grade_1 28 6 6 0   14     0   5   32 27 *                     59.0 28 6 6 0   14     0   5   32 27                 59
1366462 1366462 MA Middlesex   school 2503270 49   Cambridge 250327001518 490090 Fletcher/Maynard Academy   Regular School No Elementary PK 05 2020   grade_1 5 23 8 0   4     0   4   30 14 *                     44.0 5 23 8 0   4     0   4   30 14                 44
1366486 1366486 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Lt Peter M Hansen   Regular School No Elementary KG 05 2020   grade_1 42 11 5 0   10     0   6   39 35 *                     74.0 42 11 5 0   10     0   6   39 35                 74
1366492 1366492 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No Elementary KG 05 2020   grade_1 62 4 2 0   9     0   9   43 43 *                     86.0 62 4 2 0   9     0   9   43 43                 86
1366498 1366498 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No Elementary KG 05 2020   grade_1 60 3 4 0   7     0   8   44 38 *                     82.0 60 3 4 0   7     0   8   44 38                 82
1366513 1366513 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2020   grade_1 38 2 4 0   8     1   8   33 28 *                     61.0 38 2 4 0   8     1   8   33 28                 61
1366523 1366523 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2020   grade_1 124 1 3 0   0     0   3   64 67 *                     131.0 124 1 3 0   0     0   3   64 67                 131
1366538 1366538 MA Middlesex   school 2503510 56   Chelmsford 250351001300 560005 Center Elementary School   Regular School No Elementary KG 04 2020   grade_1 75 2 7 0   20     0   3   58 49 *                     107.0 75 2 7 0   20     0   3   58 49                 107
1366543 1366543 MA Middlesex   school 2503510 56   Chelmsford 250351000480 560015 South Row   Regular School No Elementary KG 04 2020   grade_1 64 0 6 1   19     0   4   54 40 *                     94.0 64 0 6 1   19     0   4   54 40                 94
1366548 1366548 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No Elementary KG 04 2020   grade_1 62 5 8 0   22     0   4   44 57 *                     101.0 62 5 8 0   22     0   4   44 57                 101
1366553 1366553 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2020   grade_1 65 1 11 0   11     0   3   41 50 *                     91.0 65 1 11 0   11     0   3   41 50                 91
1366571 1366571 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2020   grade_1 4 1 98 0   0     0   0   46 57 *                     103.0 4 1 98 0   0     0   0   46 57                 103
1366572 1366572 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2020   grade_1 12 5 104 0   0     0   3   61 63 *                     124.0 12 5 104 0   0     0   3   61 63                 124
1366576 1366576 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2020   grade_1 12 8 84 0   0     0   2   44 62 *                     106.0 12 8 84 0   0     0   2   44 62                 106
1366580 1366580 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_1 6 5 95 0   0     0   0   52 54 *                     106.0 6 5 95 0   0     0   0   52 54                 106
1366586 1366586 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2020   grade_1 10 2 87 0   1     0   1   49 52 *                     101.0 10 2 87 0   1     0   1   49 52                 101
1366612 1366612 MA Hampden   school 2503660 61   Chicopee 250366000489 610003 Barry   Regular School No Elementary KG 05 2020   grade_1 29 2 24 0   1     0   4   36 24 *                     60.0 29 2 24 0   1     0   4   36 24                 60
1366618 1366618 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2020   grade_1 38 8 27 0   2     0   1   35 41 *                     76.0 38 8 27 0   2     0   1   35 41                 76
1366621 1366621 MA Hampden   school 2503660 61   Chicopee 250366000492 610015 Bowe   Regular School No Elementary KG 05 2020   grade_1 18 6 43 0   3     0   4   40 34 *                     74.0 18 6 43 0   3     0   4   40 34                 74
1366627 1366627 MA Hampden   school 2503660 61   Chicopee 250366000493 610020 Bowie   Regular School No Elementary KG 05 2020   grade_1 34 1 13 0   3     0   0   25 26 *                     51.0 34 1 13 0   3     0   0   25 26                 51
1366639 1366639 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2020   grade_1 18 0 2 0   0     0   0   6 14 *                     20.0 18 0 2 0   0     0   0   6 14                 20
1366645 1366645 MA Hampden   school 2503660 61   Chicopee 250366000501 610040 Lambert-Lavoie   Regular School No Elementary KG 05 2020   grade_1 30 4 6 0   1     0   2   28 15 *                     43.0 30 4 6 0   1     0   2   28 15                 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]);