enrollments

Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,537 ✖
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
1365271 1365271 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2020   kindergarten 13 10 9 0   5     0   3   26 14 *                     40.0 13 10 9 0   5     0   3   26 14                 40
1365272 1365272 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2020   pre_kindergarten 31 4 17 0   25     0   3   46 34 *                     80.0 31 4 17 0   25     0   3   46 34                 80
1365273 1365273 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2020   grade_1 10 3 14 0   6     0   1   19 15 *                     34.0 10 3 14 0   6     0   1   19 15                 34
1365283 1365283 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2020   kindergarten 2 10 9 0   4     0   4   18 11 *                     29.0 2 10 9 0   4     0   4   18 11                 29
1365284 1365284 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2020   pre_kindergarten 8 11 22 0   4     0   1   20 26 *                     46.0 8 11 22 0   4     0   1   20 26                 46
1365285 1365285 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2020   grade_1 4 9 14 1   4     0   1   17 16 *                     33.0 4 9 14 1   4     0   1   17 16                 33
1365291 1365291 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No Elementary PK 01 2020   kindergarten 15 1 45 0   1     1   0   28 35 *                     63.0 15 1 45 0   1     1   0   28 35                 63
1365292 1365292 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No Elementary PK 01 2020   pre_kindergarten 26 7 49 1   2     0   3   45 43 *                     88.0 26 7 49 1   2     0   3   45 43                 88
1365293 1365293 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No Elementary PK 01 2020   grade_1 20 3 34 0   1     0   0   28 30 *                     58.0 20 3 34 0   1     0   0   28 30                 58
1365294 1365294 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No Elementary PK 01 2020   kindergarten 3 27 36 1   5     0   2   40 34 *                     74.0 3 27 36 1   5     0   2   40 34                 74
1365295 1365295 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No Elementary PK 01 2020   pre_kindergarten 2 27 24 1   2     0   2   35 23 *                     58.0 2 27 24 1   2     0   2   35 23                 58
1365296 1365296 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No Elementary PK 01 2020   grade_1 2 38 25 2   4     0   2   33 40 *                     73.0 2 38 25 2   4     0   2   33 40                 73
1365687 1365687 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No Elementary PK 01 2020   kindergarten 30 15 14 0   6     1   1   25 41 *                     67.0 30 15 14 0   6     1   1   25 41                 67
1365688 1365688 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No Elementary PK 01 2020   pre_kindergarten 27 20 12 0   7     0   9   33 42 *                     75.0 27 20 12 0   7     0   9   33 42                 75
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
1366569 1366569 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2020   kindergarten 30 20 442 1   0     0   2   261 234 *                     495.0 30 20 442 1   0     0   2   261 234                 495
1366570 1366570 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2020   pre_kindergarten 27 18 239 0   0     0   6   151 139 *                     290.0 27 18 239 0   0     0   6   151 139                 290
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
1366856 1366856 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2020   kindergarten 86 1 9 0   0     0   2   49 49 *                     98.0 86 1 9 0   0     0   2   49 49                 98
1366857 1366857 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2020   pre_kindergarten 54 1 3 0   1     0   0   24 35 *                     59.0 54 1 3 0   1     0   0   24 35                 59
1366858 1366858 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2020   grade_1 83 0 6 0   1     0   1   54 37 *                     91.0 83 0 6 0   1     0   1   54 37                 91
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
1367447 1367447 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2020   pre_kindergarten 46 4 17 0   4     0   4   40 35 *                     75.0 46 4 17 0   4     0   4   40 35                 75
1367448 1367448 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2020   grade_1 102 3 38 0   0     0   17   96 64 *                     160.0 102 3 38 0   0     0   17   96 64                 160
1367514 1367514 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2020   kindergarten 96 4 6 0   22     0   2   71 59 *                     130.0 96 4 6 0   22     0   2   71 59                 130
1367515 1367515 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 47 3 6 0   14     0   0   40 30 *                     70.0 47 3 6 0   14     0   0   40 30                 70
1367516 1367516 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2020   grade_1 74 1 6 0   14     0   5   62 38 *                     100.0 74 1 6 0   14     0   5   62 38                 100
1367517 1367517 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2020   kindergarten 88 1 4 0   10     0   4   43 64 *                     107.0 88 1 4 0   10     0   4   43 64                 107
1367518 1367518 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 32 0 2 0   12     0   1   27 20 *                     47.0 32 0 2 0   12     0   1   27 20                 47
1367519 1367519 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2020   grade_1 76 2 4 0   21     0   0   53 50 *                     103.0 76 2 4 0   21     0   0   53 50                 103
1367602 1367602 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No Elementary PK 01 2020   kindergarten 191 2 1 0   3     0   1   97 101 *                     198.0 191 2 1 0   3     0   1   97 101                 198
1367603 1367603 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 75 1 1 0   3     0   0   42 38 *                     80.0 75 1 1 0   3     0   0   42 38                 80
1367604 1367604 MA Plymouth   school 2505790 122   Hanover 250579000827 1220004 Cedar Elementary   Regular School No Elementary PK 01 2020   grade_1 183 1 8 0   5     0   3   107 93 *                     200.0 183 1 8 0   5     0   3   107 93                 200
1367880 1367880 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Marathon Elementary School   Regular School No Elementary KG 01 2020   kindergarten 160 2 14 0   79     0   13   144 124 *                     268.0 160 2 14 0   79     0   13   144 124                 268
1367881 1367881 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Marathon Elementary School   Regular School No Elementary KG 01 2020   grade_1 181 0 17 0   79     0   18   146 149 *                     295.0 181 0 17 0   79     0   18   146 149                 295
1368427 1368427 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No Elementary PK 01 2020   kindergarten 124 3 25 0   5     0   4   88 73 *                     161.0 124 3 25 0   5     0   4   88 73                 161
1368428 1368428 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten 70 0 10 0   2     0   6   49 39 *                     88.0 70 0 10 0   2     0   6   49 39                 88
1368429 1368429 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No Elementary PK 01 2020   grade_1 117 4 21 0   1     0   4   70 77 *                     147.0 117 4 21 0   1     0   4   70 77                 147
1368827 1368827 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2020   kindergarten 172 5 4 0   5     0   9   88 107 *                     195.0 172 5 4 0   5     0   9   88 107                 195
1368828 1368828 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2020   pre_kindergarten 47 1 2 0   0     0   0   29 21 *                     50.0 47 1 2 0   0     0   0   29 21                 50
1368829 1368829 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2020   grade_1 172 2 4 1   7     0   5   100 91 *                     191.0 172 2 4 1   7     0   5   100 91                 191
1368884 1368884 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No Elementary PK 01 2020   kindergarten 124 2 13 0   4     0   2   68 77 *                     145.0 124 2 13 0   4     0   2   68 77                 145
1368885 1368885 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 32 1 5 0   0     0   2   27 13 *                     40.0 32 1 5 0   0     0   2   27 13                 40
1368886 1368886 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No Elementary PK 01 2020   grade_1 135 2 6 1   3     0   2   87 62 *                     149.0 135 2 6 1   3     0   2   87 62                 149
1369657 1369657 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No Elementary PK 01 2020   kindergarten 147 0 11 0   0     0   4   89 73 *                     162.0 147 0 11 0   0     0   4   89 73                 162
1369658 1369658 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 67 0 3 0   0     0   7   44 33 *                     77.0 67 0 3 0   0     0   7   44 33                 77
1369659 1369659 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No Elementary PK 01 2020   grade_1 101 1 11 0   0     0   8   66 55 *                     121.0 101 1 11 0   0     0   8   66 55                 121
1369812 1369812 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2020   kindergarten 78 0 17 0   1     0   6   46 56 *                     102.0 78 0 17 0   1     0   6   46 56                 102
1369813 1369813 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2020   pre_kindergarten 34 1 7 0   1     0   3   26 20 *                     46.0 34 1 7 0   1     0   3   26 20                 46
1369814 1369814 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2020   grade_1 92 1 15 1   0     0   3   54 58 *                     112.0 92 1 15 1   0     0   3   54 58                 112
1370579 1370579 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2020   kindergarten 97 6 18 1   123     0   5   131 119 *                     250.0 97 6 18 1   123     0   5   131 119                 250
1370580 1370580 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2020   grade_1 6 6 1 2   45     0   6   33 33 *                     66.0 6 6 1 2   45     0   6   33 33                 66
1370725 1370725 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2020   kindergarten 95 4 9 1   24     2   5   84 56 *                     140.0 95 4 9 1   24     2   5   84 56                 140
1370726 1370726 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2020   pre_kindergarten 43 3 2 1   33     0   0   49 33 *                     82.0 43 3 2 1   33     0   0   49 33                 82
1370727 1370727 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2020   grade_1 89 1 6 1   14     0   6   58 59 *                     117.0 89 1 6 1   14     0   6   58 59                 117
1370739 1370739 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No Elementary PK 01 2020   kindergarten 52 2 107 0   4     0   2   73 94 *                     167.0 52 2 107 0   4     0   2   73 94                 167
1370740 1370740 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No Elementary PK 01 2020   pre_kindergarten 22 0 43 0   1     0   2   45 23 *                     68.0 22 0 43 0   1     0   2   45 23                 68
1370741 1370741 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No Elementary PK 01 2020   grade_1 48 1 76 1   2     1   0   62 67 *                     129.0 48 1 76 1   2     1   0   62 67                 129
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
1370757 1370757 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 57 1 11 0   2     0   2   41 32 *                     73.0 57 1 11 0   2     0   2   41 32                 73
1370758 1370758 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No Elementary PK 01 2020   grade_1 118 3 23 0   3     0   6   74 79 *                     153.0 118 3 23 0   3     0   6   74 79                 153
1373055 1373055 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000397 6100010 Meetinghouse School   Regular School No Elementary KG 01 2020   kindergarten 75 1 6 0   0     0   4   41 45 *                     86.0 75 1 6 0   0     0   4   41 45                 86
1373056 1373056 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000397 6100010 Meetinghouse School   Regular School No Elementary KG 01 2020   grade_1 102 1 7 0   1     0   2   59 54 *                     113.0 102 1 7 0   1     0   2   59 54                 113
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
1373176 1373176 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002102 6250020 Merrill Elementary School   Regular School No Elementary KG 01 2020   grade_1 139 8 6 0   6     0   7   92 74 *                     166.0 139 8 6 0   6     0   7   92 74                 166
1373295 1373295 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No Elementary PK 01 2020   kindergarten 88 2 12 0   0     0   2   48 56 *                     104.0 88 2 12 0   0     0   2   48 56                 104
1373296 1373296 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No Elementary PK 01 2020   pre_kindergarten 44 0 8 1   0     0   4   36 21 *                     57.0 44 0 8 1   0     0   4   36 21                 57
1373297 1373297 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No Elementary PK 01 2020   grade_1 92 1 14 1   1     0   6   68 47 *                     115.0 92 1 14 1   1     0   6   68 47                 115
1373298 1373298 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No Elementary PK 01 2020   kindergarten 127 1 12 0   0     0   2   77 65 *                     142.0 127 1 12 0   0     0   2   77 65                 142
1373299 1373299 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 59 0 4 0   1     0   1   36 29 *                     65.0 59 0 4 0   1     0   1   36 29                 65
1373300 1373300 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No Elementary PK 01 2020   grade_1 121 2 17 0   1     0   6   72 75 *                     147.0 121 2 17 0   1     0   6   72 75                 147
1373406 1373406 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No Elementary PK 01 2020   kindergarten 35 1 12 0   0     0   3   26 25 *                     51.0 35 1 12 0   0     0   3   26 25                 51
1373407 1373407 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten 27 0 9 0   0     0   2   24 14 *                     38.0 27 0 9 0   0     0   2   24 14                 38
1373408 1373408 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No Elementary PK 01 2020   grade_1 46 2 9 0   2     0   5   37 27 *                     64.0 46 2 9 0   2     0   5   37 27                 64
1373457 1373457 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2020   kindergarten 125 3 9 1   3     0   7   77 71 *                     148.0 125 3 9 1   3     0   7   77 71                 148
1373458 1373458 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2020   pre_kindergarten 51 1 5 0   2     0   3   37 25 *                     62.0 51 1 5 0   2     0   3   37 25                 62
1373459 1373459 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2020   grade_1 119 3 16 0   4     2   8   79 73 *                     152.0 119 3 16 0   4     2   8   79 73                 152
1373804 1373804 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary KG 01 2020   kindergarten 23 1 1 0   0     0   0   14 11 *                     25.0 23 1 1 0   0     0   0   14 11                 25
1373805 1373805 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary KG 01 2020   grade_1 18 0 2 0   0     0   1   9 12 *                     21.0 18 0 2 0   0     0   1   9 12                 21
1373850 1373850 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No Elementary KG 01 2020   kindergarten 8 0 1 0   1     0   0   * 6 *                     10.0 8 0 1 0   1     0   0     6                 10
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
1364788 1364788 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_1 130 9 9 3   5     0   1   80 77 *                     157.0 130 9 9 3   5     0   1   80 77                 157
1364789 1364789 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2020   grade_2 119 10 10 2   3     0   1   68 77 *                     145.0 119 10 10 2   3     0   1   68 77                 145
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
1364982 1364982 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2020   grade_1 131 6 29 1   44     0   11   126 96 *                     222.0 131 6 29 1   44     0   11   126 96                 222
1364983 1364983 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2020   grade_2 118 7 27 0   43     0   9   103 101 *                     204.0 118 7 27 0   43     0   9   103 101                 204
1365039 1365039 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2020   kindergarten 80 1 11 1   1     0   6   48 52 *                     100.0 80 1 11 1   1     0   6   48 52                 100
1365040 1365040 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2020   grade_1 70 1 10 0   6     0   3   53 37 *                     90.0 70 1 10 0   6     0   3   53 37                 90
1365041 1365041 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2020   grade_2 78 2 12 0   3     0   1   52 44 *                     96.0 78 2 12 0   3     0   1   52 44                 96
1365042 1365042 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   kindergarten 72 0 8 0   2     0   2   38 46 *                     84.0 72 0 8 0   2     0   2   38 46                 84
1365043 1365043 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   pre_kindergarten 40 0 4 0   2     0   2   28 20 *                     48.0 40 0 4 0   2     0   2   28 20                 48
1365044 1365044 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   grade_1 82 2 12 0   3     0   2   55 46 *                     101.0 82 2 12 0   3     0   2   55 46                 101
1365045 1365045 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2020   grade_2 62 0 5 0   4     0   4   36 39 *                     75.0 62 0 5 0   4     0   4   36 39                 75
1365102 1365102 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary PK 02 2020   kindergarten 113 11 10 0   37     0   12   107 76 *                     183.0 113 11 10 0   37     0   12   107 76                 183
1365103 1365103 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary PK 02 2020   pre_kindergarten 27 3 0 0   13     0   2   30 15 *                     45.0 27 3 0 0   13     0   2   30 15                 45
1365104 1365104 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary PK 02 2020   grade_1 108 11 11 0   52     0   16   117 81 *                     198.0 108 11 11 0   52     0   16   117 81                 198
1365105 1365105 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary PK 02 2020   grade_2 125 11 10 0   51     0   20   94 123 *                     217.0 125 11 10 0   51     0   20   94 123                 217
1365322 1365322 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2020   kindergarten 1 17 18 1   0     0   0   19 18 *                     37.0 1 17 18 1   0     0   0   19 18                 37
1365323 1365323 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2020   pre_kindergarten 0 13 11 0   2     0   1   13 14 *                     27.0 0 13 11 0   2     0   1   13 14                 27
1365324 1365324 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2020   grade_1 0 18 18 0   0     0   1   22 15 *                     37.0 0 18 18 0   0     0   1   22 15                 37

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