enrollments

Data source: Big Local News · About: Big Local

956 rows where grade = "kindergarten", state = "MA" and year = 2020 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 956 ✖

grade ✖

  • kindergarten · 956 ✖
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
1372534 1372534 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   kindergarten 6 99 68 1   5     0   7   81 105 *                     186.0 6 99 68 1   5     0   7   81 105                 186
1366201 1366201 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2020   kindergarten 7 96 11 0   0     1   3   66 52 *                     118.0 7 96 11 0   0     1   3   66 52                 118
1364787 1364787 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   kindergarten 131 9 22 1   4     0   2   82 86 *                     169.0 131 9 22 1   4     0   2   82 86                 169
1365010 1365010 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2020   kindergarten 63 9 11 0   6     0   6   46 49 *                     95.0 63 9 11 0   6     0   6   46 49                 95
1365331 1365331 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2020   kindergarten 46 9 22 0   3     0   8   50 38 *                     88.0 46 9 22 0   3     0   8   50 38                 88
1365613 1365613 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary PK 05 2020   kindergarten 5 9 5 0   3     0   3   11 14 *                     25.0 5 9 5 0   3     0   3   11 14                 25
1365732 1365732 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2020   kindergarten 3 9 36 0   0     0   0   20 28 *                     48.0 3 9 36 0   0     0   0   20 28                 48
1366365 1366365 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Francis Wyman Elementary   Regular School No Elementary KG 05 2020   kindergarten 53 9 5 0   12     0   4   45 38 *                     83.0 53 9 5 0   12     0   4   45 38                 83
1366890 1366890 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No Elementary KG 05 2020   kindergarten 55 9 9 0   6     0   1   46 34 *                     80.0 55 9 9 0   6     0   1   46 34                 80
1367127 1367127 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary PK 05 2020   kindergarten 33 9 42 0   3     0   6   56 37 *                     93.0 33 9 42 0   3     0   6   56 37                 93
1367244 1367244 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2020   kindergarten 29 9 68 0   4     0   10   59 61 *                     120.0 29 9 68 0   4     0   10   59 61                 120
1368282 1368282 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 08 2020   kindergarten 14 9 36 0   19     0   3   43 38 *                     81.0 14 9 36 0   19     0   3   43 38                 81
1368503 1368503 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No Elementary KG 05 2020   kindergarten 3 9 87 0   3     0   3   60 45 *                     105.0 3 9 87 0   3     0   3   60 45                 105
1369249 1369249 MA Bristol   school 2508430 201   New Bedford 250843001333 2010070 Irwin M. Jacobs Elementary School   Regular School No Elementary PK 05 2020   kindergarten 23 9 34 0   0     0   3   26 43 *                     69.0 23 9 34 0   0     0   3   26 43                 69
1369270 1369270 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2020   kindergarten 39 9 41 0   2     0   9   52 48 *                     100.0 39 9 41 0   2     0   9   52 48                 100
1370113 1370113 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2020   kindergarten 47 9 14 2   47     0   8   67 60 *                     127.0 47 9 14 2   47     0   8   67 60                 127
1370778 1370778 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No Elementary PK 05 2020   kindergarten 6 9 70 0   2     0   3   51 39 *                     90.0 6 9 70 0   2     0   3   51 39                 90
1370798 1370798 MA Hampden   school 2511130 281   Springfield 251113000896 2810023 Milton Bradley School   Regular School No Elementary PK 05 2020   kindergarten 6 9 45 0   1     0   0   28 33 *                     61.0 6 9 45 0   1     0   0   28 33                 61
1370805 1370805 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No Elementary PK 05 2020   kindergarten 2 9 49 0   0     0   2   29 33 *                     62.0 2 9 49 0   0     0   2   29 33                 62
1370933 1370933 MA Hampden   school 2511130 281   Springfield 251113001829 2810155 Mary M Walsh   Regular School No Elementary KG 05 2020   kindergarten 8 9 29 0   0     0   0   27 19 *                     46.0 8 9 29 0   0     0   0   27 19                 46
1370952 1370952 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No Elementary KG 05 2020   kindergarten 3 9 18 0   7     0   1   21 17 *                     38.0 3 9 18 0   7     0   1   21 17                 38
1370958 1370958 MA Hampden   school 2511130 281   Springfield 251113001835 2810180 Warner   Regular School No Elementary PK 05 2020   kindergarten 4 9 29 0   0     0   1   25 18 *                     43.0 4 9 29 0   0     0   1   25 18                 43
1371469 1371469 MA Middlesex   school 2512000 308   Waltham 251200001967 3080032 Douglas MacArthur Elementary School   Regular School No Elementary KG 05 2020   kindergarten 43 9 10 0   7     0   3   37 35 *                     72.0 43 9 10 0   7     0   3   37 35                 72
1371836 1371836 MA Hampden   school 2512510 332   West Springfield 251251002504 3320005 John Ashley   Regular School No Elementary KG KG 2020   kindergarten 134 9 58 0   17     0   15   113 120 *                     233.0 134 9 58 0   17     0   15   113 120                 233
1372176 1372176 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   kindergarten 19 9 23 0   2     0   3   28 28 *                     56.0 19 9 23 0   2     0   3   28 28                 56
1372259 1372259 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary KG 06 2020   kindergarten 9 9 17 0   3     0   4   29 13 *                     42.0 9 9 17 0   3     0   4   29 13                 42
1374240 1374240 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 05 2020   kindergarten 4 9 39 0   1     0   1   26 28 *                     54.0 4 9 39 0   1     0   1   26 28                 54
1374293 1374293 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2020   kindergarten 15 9 11 0   0     0   3   23 15 *                     38.0 15 9 11 0   0     0   3   23 15                 38
1366155 1366155 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2020   kindergarten 15 84 64 1   0     0   2   83 83 *                     166.0 15 84 64 1   0     0   2   83 83                 166
1372833 1372833 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2020   kindergarten 5 81 47 0   0     0   3   57 79 *                     136.0 5 81 47 0   0     0   3   57 79                 136
1365015 1365015 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2020   kindergarten 59 8 17 0   4     1   4   50 43 *                     93.0 59 8 17 0   4     1   4   50 43                 93
1365243 1365243 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No Elementary KG 04 2020   kindergarten 59 8 7 0   18     0   1   46 47 *                     93.0 59 8 7 0   18     0   1   46 47                 93
1365307 1365307 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2020   kindergarten 4 8 35 1   4     0   1   37 16 *                     53.0 4 8 35 1   4     0   1   37 16                 53
1365620 1365620 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2020   kindergarten 7 8 3 0   0     0   4   13 9 *                     22.0 7 8 3 0   0     0   4   13 9                 22
1366086 1366086 MA Norfolk   school 2502940 40   Braintree 250294002789 400009 Monatiquot Kindergarten Center   Regular School No Elementary KG KG 2020   kindergarten 163 8 12 1   67     0   4   143 112 *                     255.0 163 8 12 1   67     0   4   143 112                 255
1366994 1366994 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2020   kindergarten 49 8 6 0   1     0   3   34 33 *                     67.0 49 8 6 0   1     0   3   34 33                 67
1367260 1367260 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2020   kindergarten 25 8 63 0   2     0   11   72 37 *                     109.0 25 8 63 0   2     0   11   72 37                 109
1368297 1368297 MA Middlesex   school 2507020 160   Lowell 250702001033 1600015 Greenhalge   Regular School No Elementary PK 04 2020   kindergarten 18 8 45 0   7     0   3   46 35 *                     81.0 18 8 45 0   7     0   3   46 35                 81
1368330 1368330 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Pawtucketville Memorial   Regular School No Elementary PK 04 2020   kindergarten 36 8 20 0   23     0   5   44 48 *                     92.0 36 8 20 0   23     0   5   44 48                 92
1368509 1368509 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2020   kindergarten 3 8 70 0   6     0   0   39 48 *                     87.0 3 8 70 0   6     0   0   39 48                 87
1368516 1368516 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No Elementary PK 05 2020   kindergarten 12 8 72 0   7     0   3   61 41 *                     102.0 12 8 72 0   7     0   3   61 41                 102
1368558 1368558 MA Essex   school 2507110 163   Lynn 250711001084 1630085 Sewell-Anderson   Regular School No Elementary KG 05 2020   kindergarten 13 8 81 0   4     0   2   60 48 *                     108.0 13 8 81 0   4     0   2   60 48                 108
1369951 1369951 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Egremont   Regular School No Elementary KG 05 2020   kindergarten 38 8 14 0   3     0   9   34 38 *                     72.0 38 8 14 0   3     0   9   34 38                 72
1369990 1369990 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No Elementary PK 05 2020   kindergarten 23 8 9 0   0     0   7   25 22 *                     47.0 23 8 9 0   0     0   7   25 22                 47
1371307 1371307 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2020   kindergarten 108 8 7 0   11     0   2   63 73 *                     136.0 108 8 7 0   11     0   2   63 73                 136
1371551 1371551 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No Elementary PK 05 2020   kindergarten 67 8 5 0   4     1   12   55 42 *                     97.0 67 8 5 0   4     1   12   55 42                 97
1372139 1372139 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2020   kindergarten 12 8 53 1   8     0   0   47 35 *                     82.0 12 8 53 1   8     0   0   47 35                 82
1372161 1372161 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2020   kindergarten 20 8 42 0   5     0   0   42 33 *                     75.0 20 8 42 0   5     0   0   42 33                 75
1372273 1372273 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary KG 06 2020   kindergarten 11 8 11 0   4     0   3   23 14 *                     37.0 11 8 11 0   4     0   3   23 14                 37
1373175 1373175 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002102 6250020 Merrill Elementary School   Regular School No Elementary KG 01 2020   kindergarten 137 8 6 0   4     0   9   79 85 *                     164.0 137 8 6 0   4     0   9   79 85                 164
1364994 1364994 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2020   kindergarten 55 7 11 1   1     0   2   35 42 *                     77.0 55 7 11 1   1     0   2   35 42                 77
1365057 1365057 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Ralph D Butler   Regular School No Elementary PK 06 2020   kindergarten 32 7 4 0   2     0   3   22 26 *                     48.0 32 7 4 0   2     0   3   22 26                 48
1365204 1365204 MA Essex   school 2502640 30   Beverly 250264000169 300033 Hannah Elementary   Regular School No Elementary KG 04 2020   kindergarten 67 7 8 0   4     0   1   43 44 *                     87.0 67 7 8 0   4     0   1   43 44                 87
1365453 1365453 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Henry Grew   Regular School No Elementary PK 05 2020   kindergarten 9 7 12 1   0     0   3   16 16 *                     32.0 9 7 12 1   0     0   3   16 16                 32
1365507 1365507 MA Suffolk   school 2502790 35   Boston 250279000265 350166 John F Kennedy   Regular School No Elementary PK 05 2020   kindergarten 10 7 32 1   0     0   0   27 23 *                     50.0 10 7 32 1   0     0   0   27 23                 50
1365582 1365582 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No Elementary PK 05 2020   kindergarten 12 7 19 0   14     0   1   30 23 *                     53.0 12 7 19 0   14     0   1   30 23                 53
1365805 1365805 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2020   kindergarten 14 7 14 0   3     0   4   15 27 *                     42.0 14 7 14 0   3     0   4   15 27                 42
1366275 1366275 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2020   kindergarten 55 7 9 0   24     0   10   51 54 *                     105.0 55 7 9 0   24     0   10   51 54                 105
1366397 1366397 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2020   kindergarten 25 7 4 0   1     0   7   19 25 *                     44.0 25 7 4 0   1     0   7   19 25                 44
1366411 1366411 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2020   kindergarten 14 7 2 0   25     0   13   30 31 *                     61.0 14 7 2 0   25     0   13   30 31                 61
1366425 1366425 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No Elementary PK 05 2020   kindergarten 17 7 15 0   17     0   4   34 26 *                     60.0 17 7 15 0   17     0   4   34 26                 60
1366439 1366439 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No Elementary PK 05 2020   kindergarten 33 7 1 0   8     0   1   25 25 *                     50.0 33 7 1 0   8     0   1   25 25                 50
1366491 1366491 MA Norfolk   school 2503300 50   Canton 250330000454 500017 John F Kennedy   Regular School No Elementary KG 05 2020   kindergarten 67 7 6 0   3     0   4   49 38 *                     87.0 67 7 6 0   3     0   4   49 38                 87
1366497 1366497 MA Norfolk   school 2503300 50   Canton 250330000452 500020 Dean S Luce   Regular School No Elementary KG 05 2020   kindergarten 52 7 4 0   8     0   9   35 45 *                     80.0 52 7 4 0   8     0   9   35 45                 80
1367029 1367029 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2020   kindergarten 7 7 47 0   2     0   3   35 31 *                     66.0 7 7 47 0   2     0   3   35 31                 66
1367045 1367045 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2020   kindergarten 17 7 39 1   5     0   2   44 27 *                     71.0 17 7 39 1   5     0   2   44 27                 71
1367121 1367121 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2020   kindergarten 44 7 41 0   6     0   11   48 61 *                     109.0 44 7 41 0   6     0   11   48 61                 109
1367361 1367361 MA Middlesex   school 2504980 100   Framingham 250498000726 1000045 Mary E Stapleton Elementary   Regular School No Elementary KG 05 2020   kindergarten 20 7 20 0   6     0   2   27 28 *                     55.0 20 7 20 0   6     0   2   27 28                 55
1367446 1367446 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2020   kindergarten 118 7 39 0   2     0   10   100 76 *                     176.0 118 7 39 0   2     0   10   100 76                 176
1367649 1367649 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No Elementary KG 04 2020   kindergarten 45 7 28 0   0     0   1   48 33 *                     81.0 45 7 28 0   0     0   1   48 33                 81
1367654 1367654 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2020   kindergarten 58 7 16 0   3     0   0   41 43 *                     84.0 58 7 16 0   3     0   0   41 43                 84
1367671 1367671 MA Essex   school 2505970 128   Haverhill 250597001169 1280054 Pentucket Lake Elementary   Regular School No Elementary KG 04 2020   kindergarten 39 7 34 0   0     0   0   50 30 *                     80.0 39 7 34 0   0     0   0   50 30                 80
1367676 1367676 MA Essex   school 2505970 128   Haverhill 250597000299 1280067 Silver Hill Elementary School   Regular School No Elementary KG 05 2020   kindergarten 40 7 29 1   5     0   1   39 44 *                     83.0 40 7 29 1   5     0   1   39 44                 83
1367963 1367963 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 John Breen School   Regular School No Elementary PK KG 2020   kindergarten 3 7 113 0   6     0   1   62 67 *                     130.0 3 7 113 0   6     0   1   62 67                 130
1368085 1368085 MA Worcester   school 2506720 151   Leicester 250672000971 1510005 Leicester Elementary   Regular School No Elementary KG 04 2020   kindergarten 74 7 9 0   5     0   2   48 49 *                     97.0 74 7 9 0   5     0   2   48 49                 97
1368276 1368276 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No Elementary PK 04 2020   kindergarten 27 7 15 0   38     0   5   52 40 *                     92.0 27 7 15 0   38     0   5   52 40                 92
1368354 1368354 MA Middlesex   school 2507020 160   Lowell 250702000088 1600075 S Christa McAuliffe Elementary   Regular School No Elementary PK 04 2020   kindergarten 26 7 39 0   6     0   0   39 39 *                     78.0 26 7 39 0   6     0   0   39 39                 78
1368948 1368948 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2020   kindergarten 47 7 44 0   8     0   5   51 60 *                     111.0 47 7 44 0   8     0   5   51 60                 111
1369115 1369115 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket Elementary   Regular School No Elementary PK 02 2020   kindergarten 41 7 50 0   3     0   2   54 49 *                     103.0 41 7 50 0   3     0   2   54 49                 103
1369211 1369211 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 Elizabeth Carter Brooks   Regular School No Elementary KG 05 2020   kindergarten 19 7 24 0   0     0   3   25 28 *                     53.0 19 7 24 0   0     0   3   25 28                 53
1369224 1369224 MA Bristol   school 2508430 201   New Bedford 250843001329 2010040 James B Congdon   Regular School No Elementary KG 05 2020   kindergarten 18 7 15 0   0     0   1   20 21 *                     41.0 18 7 15 0   0     0   1   20 21                 41
1369276 1369276 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No Elementary KG 05 2020   kindergarten 13 7 27 0   0     0   1   22 26 *                     48.0 13 7 27 0   0     0   1   22 26                 48
1370352 1370352 MA Plymouth   school 2510170 251   Rockland 251017001708 2510060 Jefferson Elementary School   Regular School No Elementary KG 04 2020   kindergarten 30 7 15 0   0     0   2   21 33 *                     54.0 30 7 15 0   0     0   2   21 33                 54
1370756 1370756 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No Elementary PK 01 2020   kindergarten 87 7 23 0   5     0   4   64 62 *                     126.0 87 7 23 0   5     0   4   64 62                 126
1370812 1370812 MA Hampden   school 2511130 281   Springfield 251113001801 2810030 Elias Brookings   Regular School No Elementary PK 05 2020   kindergarten 1 7 40 0   0     0   1   30 19 *                     49.0 1 7 40 0   0     0   1   30 19                 49
1370826 1370826 MA Hampden   school 2511130 281   Springfield 251113001838 2810045 William N. DeBerry   Regular School No Elementary KG 05 2020   kindergarten 1 7 30 0   0     0   3   19 22 *                     41.0 1 7 30 0   0     0   3   19 22                 41
1370894 1370894 MA Hampden   school 2511130 281   Springfield 251113001813 2810110 Kensington International School   Regular School No Elementary PK 05 2020   kindergarten 2 7 25 1   0     0   1   13 23 *                     36.0 2 7 25 1   0     0   1   13 23                 36
1370920 1370920 MA Hampden   school 2511130 281   Springfield 251113001818 2810140 Mary M Lynch   Regular School No Elementary KG 05 2020   kindergarten 5 7 20 0   0     0   0   15 17 *                     32.0 5 7 20 0   0     0   0   15 17                 32
1371258 1371258 MA Bristol   school 2511520 293   Taunton 251152001565 2930008 Joseph C Chamberlain   Regular School No Elementary KG 04 2020   kindergarten 78 7 7 0   1     0   3   42 54 *                     96.0 78 7 7 0   1     0   3   42 54                 96
1371802 1371802 MA Middlesex   school 2512750 330   Weston 251275002085 3300010 Country   Regular School No Elementary PK 03 2020   kindergarten 51 7 4 0   7     0   3   35 37 *                     72.0 51 7 4 0   7     0   3   35 37                 72
1372192 1372192 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2020   kindergarten 15 7 27 0   5     0   1   31 24 *                     55.0 15 7 27 0   5     0   1   31 24                 55
1373236 1373236 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2020   kindergarten 52 7 8 0   2     0   4   32 41 *                     73.0 52 7 8 0   2     0   4   32 41                 73
1365326 1365326 MA Suffolk   school 2502790 35   Boston 250279002874 350016 Mattahunt Elementary School   Regular School No Elementary PK 03 2020   kindergarten 2 69 17 0   0     1   5   48 46 *                     94.0 2 69 17 0   0     1   5   48 46                 94
1366195 1366195 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2020   kindergarten 8 63 15 0   9     0   2   57 40 *                     97.0 8 63 15 0   9     0   2   57 40                 97
1372672 1372672 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   kindergarten 42 62 10 0   25     0   6   72 73 *                     145.0 42 62 10 0   25     0   6   72 73                 145
1364878 1364878 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   kindergarten 23 6 4 1   10     0   3   23 24 *                     47.0 23 6 4 1   10     0   3   23 24                 47
1364981 1364981 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2020   kindergarten 115 6 14 0   48     0   5   107 81 *                     188.0 115 6 14 0   48     0   5   107 81                 188
1365005 1365005 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Hyman Fine Elementary School   Regular School No Elementary KG 04 2020   kindergarten 68 6 12 0   1     0   6   39 54 *                     93.0 68 6 12 0   1     0   6   39 54                 93
1365697 1365697 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No Elementary PK 05 2020   kindergarten 18 6 5 1   0     0   3   14 19 *                     33.0 18 6 5 1   0     0   3   14 19                 33
1366313 1366313 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2020   kindergarten 28 6 5 0   17     0   6   31 31 *                     62.0 28 6 5 0   17     0   6   31 31                 62

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