enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 9,565 ✖
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
2040314 2040314 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2019   pre_kindergarten 28 7 18 0   24     0   5   46 36                       82.0 28 7 18 0   24     0   5   46 36                 82
2040315 2040315 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2019   kindergarten 13 5 15 1   7     0   1   23 19                       42.0 13 5 15 1   7     0   1   23 19                 42
2040316 2040316 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2019   grade_1 5 4 14 0   9     0   3   24 11                       35.0 5 4 14 0   9     0   3   24 11                 35
2040326 2040326 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2019   pre_kindergarten 13 12 16 0   4     0   1   26 20                       46.0 13 12 16 0   4     0   1   26 20                 46
2040327 2040327 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2019   kindergarten 4 10 14 0   4     0   1   15 18                       33.0 4 10 14 0   4     0   1   15 18                 33
2040328 2040328 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2019   grade_1 4 11 16 0   1     0   0   20 12                       32.0 4 11 16 0   1     0   0   20 12                 32
2040334 2040334 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No Elementary PK 01 2019   pre_kindergarten 23 0 47 1   1     1   1   32 42                       74.0 23 0 47 1   1     1   1   32 42                 74
2040335 2040335 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No Elementary PK 01 2019   kindergarten 23 4 32 0   2     0   0   34 27                       61.0 23 4 32 0   2     0   0   34 27                 61
2040336 2040336 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No Elementary PK 01 2019   grade_1 11 7 31 0   0     0   0   21 28                       49.0 11 7 31 0   0     0   0   21 28                 49
2040337 2040337 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No Elementary PK 01 2019   pre_kindergarten 3 25 19 1   3     0   0   34 17                       51.0 3 25 19 1   3     0   0   34 17                 51
2040338 2040338 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No Elementary PK 01 2019   kindergarten 2 34 25 1   4     0   1   32 35                       67.0 2 34 25 1   4     0   1   32 35                 67
2040339 2040339 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No Elementary PK 01 2019   grade_1 1 39 28 0   1     0   1   38 32                       70.0 1 39 28 0   1     0   1   38 32                 70
2040730 2040730 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No Elementary PK 01 2019   pre_kindergarten 36 15 12 0   8     0   6   31 46                       77.0 36 15 12 0   8     0   6   31 46                 77
2040731 2040731 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No Elementary PK 01 2019   kindergarten 18 29 7 0   9     1   4   38 30                       68.0 18 29 7 0   9     1   4   38 30                 68
2040732 2040732 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No Elementary PK 01 2019   grade_1 27 12 14 0   15     0   2   32 38                       70.0 27 12 14 0   15     0   2   32 38                 70
2041639 2041639 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2019   pre_kindergarten 23 11 211 0   1     0   1   143 104                       247.0 23 11 211 0   1     0   1   143 104                 247
2041640 2041640 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2019   kindergarten 44 23 446 0   4     0   3   239 281                       520.0 44 23 446 0   4     0   3   239 281                 520
2041641 2041641 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2019   grade_1 11 5 85 0   1     0   1   45 58                       103.0 11 5 85 0   1     0   1   45 58                 103
2041925 2041925 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2019   pre_kindergarten 51 0 4 0   0     0   1   29 27                       56.0 51 0 4 0   0     0   1   29 27                 56
2041926 2041926 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2019   kindergarten 79 0 4 0   1     0   1   50 35                       85.0 79 0 4 0   1     0   1   50 35                 85
2041927 2041927 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2019   grade_1 71 0 4 0   0     0   6   40 41                       81.0 71 0 4 0   0     0   6   40 41                 81
2042517 2042517 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2019   pre_kindergarten 54 5 12 0   0     0   4   41 34                       75.0 54 5 12 0   0     0   4   41 34                 75
2042518 2042518 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2019   kindergarten 115 3 39 0   0     0   16   102 71                       173.0 115 3 39 0   0     0   16   102 71                 173
2042519 2042519 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2019   grade_1 121 7 45 0   7     0   10   97 93                       190.0 121 7 45 0   7     0   10   97 93                 190
2042586 2042586 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2019   pre_kindergarten 50 3 7 0   6     0   2   40 28                       68.0 50 3 7 0   6     0   2   40 28                 68
2042587 2042587 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2019   kindergarten 80 3 3 0   15     0   5   61 45                       106.0 80 3 3 0   15     0   5   61 45                 106
2042588 2042588 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2019   grade_1 96 0 5 0   23     0   3   71 56                       127.0 96 0 5 0   23     0   3   71 56                 127
2042589 2042589 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2019   pre_kindergarten 32 0 0 0   7     0   0   21 18                       39.0 32 0 0 0   7     0   0   21 18                 39
2042590 2042590 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2019   kindergarten 69 2 4 0   19     0   0   45 49                       94.0 69 2 4 0   19     0   0   45 49                 94
2042591 2042591 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2019   grade_1 86 1 3 0   9     0   5   53 51                       104.0 86 1 3 0   9     0   5   53 51                 104
2042960 2042960 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Marathon Elementary School   Regular School No Elementary KG 01 2019   kindergarten 175 0 14 0   56     0   15   125 135                       260.0 175 0 14 0   56     0   15   125 135                 260
2042961 2042961 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Marathon Elementary School   Regular School No Elementary KG 01 2019   grade_1 144 2 6 0   62     0   12   111 115                       226.0 144 2 6 0   62     0   12   111 115                 226
2043510 2043510 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No Elementary PK 01 2019   pre_kindergarten 77 0 7 0   1     0   4   55 34                       89.0 77 0 7 0   1     0   4   55 34                 89
2043511 2043511 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No Elementary PK 01 2019   kindergarten 120 3 18 0   2     0   5   69 79                       148.0 120 3 18 0   2     0   5   69 79                 148
2043512 2043512 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No Elementary PK 01 2019   grade_1 125 1 24 1   1     0   3   77 78                       155.0 125 1 24 1   1     0   3   77 78                 155
2043898 2043898 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2019   pre_kindergarten 48 1 2 0   1     0   0   28 24                       52.0 48 1 2 0   1     0   0   28 24                 52
2043899 2043899 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2019   kindergarten 167 0 5 2   6     0   4   95 89                       184.0 167 0 5 2   6     0   4   95 89                 184
2043900 2043900 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2019   grade_1 164 4 6 0   4     0   9   82 105                       187.0 164 4 6 0   4     0   9   82 105                 187
2043955 2043955 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No Elementary PK 01 2019   pre_kindergarten 25 0 4 0   1     0   3   25 8                       33.0 25 0 4 0   1     0   3   25 8                 33
2043956 2043956 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No Elementary PK 01 2019   kindergarten 135 1 4 0   3     0   2   82 63                       145.0 135 1 4 0   3     0   2   82 63                 145
2043957 2043957 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No Elementary PK 01 2019   grade_1 140 0 4 0   3     1   2   72 78                       150.0 140 0 4 0   3     1   2   72 78                 150
2044730 2044730 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No Elementary PK 01 2019   pre_kindergarten 59 1 10 0   0     0   7   51 26                       77.0 59 1 10 0   0     0   7   51 26                 77
2044731 2044731 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No Elementary PK 01 2019   kindergarten 107 1 13 0   0     0   11   69 63                       132.0 107 1 13 0   0     0   11   69 63                 132
2044732 2044732 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No Elementary PK 01 2019   grade_1 125 0 21 0   0     0   7   90 63                       153.0 125 0 21 0   0     0   7   90 63                 153
2044885 2044885 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2019   pre_kindergarten 30 0 7 0   0     0   2   25 14                       39.0 30 0 7 0   0     0   2   25 14                 39
2044886 2044886 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2019   kindergarten 94 1 17 1   0     0   4   58 59                       117.0 94 1 17 1   0     0   4   58 59                 117
2044887 2044887 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2019   grade_1 85 2 9 0   1     0   3   51 49                       100.0 85 2 9 0   1     0   3   51 49                 100
2045654 2045654 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2019   kindergarten 87 8 18 4   96     0   8   122 99                       221.0 87 8 18 4   96     0   8   122 99                 221
2045655 2045655 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2019   grade_1 29 5 6 1   27     0   5   46 27                       73.0 29 5 6 1   27     0   5   46 27                 73
2045801 2045801 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2019   pre_kindergarten 48 2 0 1   29     0   2   45 37                       82.0 48 2 0 1   29     0   2   45 37                 82
2045802 2045802 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2019   kindergarten 87 1 5 1   11     0   6   54 57                       111.0 87 1 5 1   11     0   6   54 57                 111
2045803 2045803 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2019   grade_1 88 0 7 0   30     0   8   67 66                       133.0 88 0 7 0   30     0   8   67 66                 133
2045815 2045815 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No Elementary PK 01 2019   pre_kindergarten 25 2 31 0   2     0   2   35 27                       62.0 25 2 31 0   2     0   2   35 27                 62
2045816 2045816 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No Elementary PK 01 2019   kindergarten 53 1 83 1   1     1   1   68 73                       141.0 53 1 83 1   1     1   1   68 73                 141
2045817 2045817 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No Elementary PK 01 2019   grade_1 62 4 97 0   0     0   2   77 88                       165.0 62 4 97 0   0     0   2   77 88                 165
2045833 2045833 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No Elementary PK 01 2019   pre_kindergarten 48 1 12 0   4     0   4   38 31                       69.0 48 1 12 0   4     0   4   38 31                 69
2045834 2045834 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No Elementary PK 01 2019   kindergarten 114 1 21 0   4     0   4   65 79                       144.0 114 1 21 0   4     0   4   65 79                 144
2045835 2045835 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No Elementary PK 01 2019   grade_1 103 3 28 0   2     0   3   67 72                       139.0 103 3 28 0   2     0   3   67 72                 139
2045918 2045918 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No Elementary PK 01 2019   pre_kindergarten 24 35 85 3   4     0   4   86 69                       155.0 24 35 85 3   4     0   4   86 69                 155
2045919 2045919 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No Elementary PK 01 2019   kindergarten 4 11 20 0   0     0   0   20 15                       35.0 4 11 20 0   0     0   0   20 15                 35
2045920 2045920 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No Elementary PK 01 2019   grade_1 3 5 31 0   0     0   0   29 10                       39.0 3 5 31 0   0     0   0   29 10                 39
2048128 2048128 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000397 6100010 Meetinghouse School   Regular School No Elementary KG 01 2019   kindergarten 93 0 5 0   1     0   2   53 48                       101.0 93 0 5 0   1     0   2   53 48                 101
2048129 2048129 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000397 6100010 Meetinghouse School   Regular School No Elementary KG 01 2019   grade_1 75 1 4 0   1     0   1   37 45                       82.0 75 1 4 0   1     0   1   37 45                 82
2048236 2048236 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002102 6250020 Merrill Elementary School   Regular School No Elementary KG 01 2019   kindergarten 152 8 7 0   5     0   7   100 79                       179.0 152 8 7 0   5     0   7   100 79                 179
2048237 2048237 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002102 6250020 Merrill Elementary School   Regular School No Elementary KG 01 2019   grade_1 144 7 1 0   1     0   3   82 74                       156.0 144 7 1 0   1     0   3   82 74                 156
2048357 2048357 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No Elementary PK 01 2019   pre_kindergarten 41 0 5 0   0     0   2   25 23                       48.0 41 0 5 0   0     0   2   25 23                 48
2048358 2048358 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No Elementary PK 01 2019   kindergarten 89 1 9 1   1     0   6   64 43                       107.0 89 1 9 1   1     0   6   64 43                 107
2048359 2048359 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No Elementary PK 01 2019   grade_1 103 2 18 0   1     0   4   67 61                       128.0 103 2 18 0   1     0   4   67 61                 128
2048360 2048360 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No Elementary PK 01 2019   pre_kindergarten 60 1 2 0   0     0   1   39 25                       64.0 60 1 2 0   0     0   1   39 25                 64
2048361 2048361 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No Elementary PK 01 2019   kindergarten 117 2 18 0   1     0   6   70 74                       144.0 117 2 18 0   1     0   6   70 74                 144
2048362 2048362 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No Elementary PK 01 2019   grade_1 119 0 12 1   0     0   7   74 65                       139.0 119 0 12 1   0     0   7   74 65                 139
2048470 2048470 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No Elementary PK 01 2019   pre_kindergarten 22 0 9 0   0     0   1   21 11                       32.0 22 0 9 0   0     0   1   21 11                 32
2048471 2048471 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No Elementary PK 01 2019   kindergarten 43 2 7 0   2     0   4   36 22                       58.0 43 2 7 0   2     0   4   36 22                 58
2048472 2048472 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No Elementary PK 01 2019   grade_1 51 0 10 0   0     0   4   37 28                       65.0 51 0 10 0   0     0   4   37 28                 65
2048520 2048520 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2019   pre_kindergarten 59 1 4 0   2     0   1   40 27                       67.0 59 1 4 0   2     0   1   40 27                 67
2048521 2048521 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2019   kindergarten 118 3 14 0   4     2   6   75 72                       147.0 118 3 14 0   4     2   6   75 72                 147
2048522 2048522 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2019   grade_1 130 3 9 0   3     0   4   68 81                       149.0 130 3 9 0   3     0   4   68 81                 149
2048696 2048696 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Templeton Center   Regular School No Elementary KG 01 2019   kindergarten 85 1 5 0   0     0   3   48 46                       94.0 85 1 5 0   0     0   3   48 46                 94
2048697 2048697 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Templeton Center   Regular School No Elementary KG 01 2019   grade_1 78 0 7 0   0     0   3   46 42                       88.0 78 0 7 0   0     0   3   46 42                 88
2048870 2048870 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary KG 01 2019   kindergarten 20 0 2 0   0     0   1   10 13                       23.0 20 0 2 0   0     0   1   10 13                 23
2048871 2048871 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary KG 01 2019   grade_1 33 0 4 0   0     0   1   22 16                       38.0 33 0 4 0   0     0   1   22 16                 38
2039813 2039813 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   kindergarten 130 10 5 1   6     0   1   79 74                       153.0 130 10 5 1   6     0   1   79 74                 153
2039814 2039814 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_1 119 7 9 3   3     0   1   66 76                       142.0 119 7 9 3   3     0   1   66 76                 142
2039815 2039815 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_2 133 5 19 1   2     0   0   85 75                       160.0 133 5 19 1   2     0   0   85 75                 160
2040008 2040008 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2019   kindergarten 135 5 27 1   47     0   12   125 102                       227.0 135 5 27 1   47     0   12   125 102                 227
2040009 2040009 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2019   grade_1 123 9 25 1   36     0   10   100 104                       204.0 123 9 25 1   36     0   10   100 104                 204
2040010 2040010 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2019   grade_2 149 3 30 0   37     0   11   113 117                       230.0 149 3 30 0   37     0   11   113 117                 230
2040067 2040067 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2019   kindergarten 70 0 9 0   6     0   5   52 38                       90.0 70 0 9 0   6     0   5   52 38                 90
2040068 2040068 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2019   grade_1 79 1 11 0   3     0   2   52 44                       96.0 79 1 11 0   3     0   2   52 44                 96
2040069 2040069 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2019   grade_2 99 1 7 0   2     0   4   56 57                       113.0 99 1 7 0   2     0   4   56 57                 113
2040070 2040070 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2019   pre_kindergarten 32 0 5 1   1     0   1   27 13                       40.0 32 0 5 1   1     0   1   27 13                 40
2040071 2040071 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2019   kindergarten 81 1 11 0   2     0   2   53 44                       97.0 81 1 11 0   2     0   2   53 44                 97
2040072 2040072 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2019   grade_1 62 0 7 0   2     0   4   37 38                       75.0 62 0 7 0   2     0   4   37 38                 75
2040073 2040073 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2019   grade_2 75 5 5 0   4     0   5   50 44                       94.0 75 5 5 0   4     0   5   50 44                 94
2040128 2040128 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   kindergarten 106 12 11 0   47     0   15   110 81                       191.0 106 12 11 0   47     0   15   110 81                 191
2040129 2040129 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   grade_1 121 13 8 0   50     0   19   92 119                       211.0 121 13 8 0   50     0   19   92 119                 211
2040130 2040130 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   grade_2 126 13 9 0   34     0   15   100 97                       197.0 126 13 9 0   34     0   15   100 97                 197
2040365 2040365 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2019   pre_kindergarten 2 11 15 0   0     0   1   16 13                       29.0 2 11 15 0   0     0   1   16 13                 29
2040366 2040366 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2019   kindergarten 0 18 21 1   0     0   2   23 19                       42.0 0 18 21 1   0     0   2   23 19                 42
2040367 2040367 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2019   grade_1 1 17 26 0   0     0   2   24 22                       46.0 1 17 26 0   0     0   2   24 22                 46

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