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,437 ✖
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
1365325 1365325 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2020   grade_2 1 14 24 0   0     0   1   22 18 *                     40.0 1 14 24 0   0     0   1   22 18                 40
1365341 1365341 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 02 2020   kindergarten 28 23 17 0   0     0   8   45 31 *                     76.0 28 23 17 0   0     0   8   45 31                 76
1365342 1365342 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 02 2020   pre_kindergarten 29 4 8 0   1     0   2   19 25 *                     44.0 29 4 8 0   1     0   2   19 25                 44
1365343 1365343 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 02 2020   grade_1 33 22 27 0   6     0   4   37 55 *                     92.0 33 22 27 0   6     0   4   37 55                 92
1365344 1365344 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 02 2020   grade_2 28 33 26 0   2     0   3   43 49 *                     92.0 28 33 26 0   2     0   3   43 49                 92
1366057 1366057 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 02 2020   kindergarten 106 2 12 1   3     0   8   71 61 *                     132.0 106 2 12 1   3     0   8   71 61                 132
1366058 1366058 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten 59 1 0 0   1     0   1   35 27 *                     62.0 59 1 0 0   1     0   1   35 27                 62
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
1366060 1366060 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 02 2020   grade_2 125 3 8 0   1     0   6   68 75 *                     143.0 125 3 8 0   1     0   6   68 75                 143
1366072 1366072 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2020   kindergarten 98 0 5 0   1     0   5   58 51 *                     109.0 98 0 5 0   1     0   5   58 51                 109
1366073 1366073 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2020   pre_kindergarten 40 0 2 0   3     0   2   24 23 *                     47.0 40 0 2 0   3     0   2   24 23                 47
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
1366075 1366075 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2020   grade_2 78 0 1 0   2     0   6   41 46 *                     87.0 78 0 1 0   2     0   6   41 46                 87
1366127 1366127 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2020   kindergarten 45 1 8 0   0     0   8   32 30 *                     62.0 45 1 8 0   0     0   8   32 30                 62
1366128 1366128 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten 27 0 6 0   0     0   1   21 13 *                     34.0 27 0 6 0   0     0   1   21 13                 34
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
1366130 1366130 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2020   grade_2 54 0 1 0   0     0   2   36 21 *                     57.0 54 0 1 0   0     0   2   36 21                 57
1366617 1366617 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2020   kindergarten 32 6 38 0   1     0   3   42 38 *                     80.0 32 6 38 0   1     0   3   42 38                 80
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
1366619 1366619 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2020   grade_2 41 10 43 0   1     0   3   52 46 *                     98.0 41 10 43 0   1     0   3   52 46                 98
1366709 1366709 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2020   kindergarten 92 4 2 0   0     0   5   51 52 *                     103.0 92 4 2 0   0     0   5   51 52                 103
1366710 1366710 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2020   pre_kindergarten 22 0 1 0   0     0   1   13 11 *                     24.0 22 0 1 0   0     0   1   13 11                 24
1366711 1366711 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2020   grade_1 96 6 1 0   1     0   1   52 53 *                     105.0 96 6 1 0   1     0   1   52 53                 105
1366712 1366712 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2020   grade_2 98 2 2 0   1     0   0   44 59 *                     103.0 98 2 2 0   1     0   0   44 59                 103
1366912 1366912 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2020   kindergarten 157 2 8 0   4     0   11   101 81 *                     182.0 157 2 8 0   4     0   11   101 81                 182
1366913 1366913 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten 58 1 2 0   0     0   5   40 26 *                     66.0 58 1 2 0   0     0   5   40 26                 66
1366914 1366914 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2020   grade_1 180 1 3 0   1     0   5   102 88 *                     190.0 180 1 3 0   1     0   5   102 88                 190
1366915 1366915 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2020   grade_2 183 1 6 0   0     0   9   100 99 *                     199.0 183 1 6 0   0     0   9   100 99                 199
1366923 1366923 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2020   kindergarten 129 6 5 1   3     0   5   67 82 *                     149.0 129 6 5 1   3     0   5   67 82                 149
1366924 1366924 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2020   pre_kindergarten 99 4 5 0   3     0   3   56 58 *                     114.0 99 4 5 0   3     0   3   56 58                 114
1366925 1366925 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2020   grade_1 126 6 4 0   2     0   6   67 77 *                     144.0 126 6 4 0   2     0   6   67 77                 144
1366926 1366926 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2020   grade_2 142 4 11 0   1     0   3   70 91 *                     161.0 142 4 11 0   1     0   3   70 91                 161
1366972 1366972 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2020   kindergarten 148 2 21 0   8     0   2   102 79 *                     181.0 148 2 21 0   8     0   2   102 79                 181
1366973 1366973 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2020   pre_kindergarten 30 4 9 0   1     0   4   29 19 *                     48.0 30 4 9 0   1     0   4   29 19                 48
1366974 1366974 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2020   grade_1 123 8 22 1   5     0   6   79 86 *                     165.0 123 8 22 1   5     0   6   79 86                 165
1366975 1366975 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2020   grade_2 151 1 24 0   8     0   9   97 96 *                     193.0 151 1 24 0   8     0   9   97 96                 193
1366986 1366986 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No Elementary PK 02 2020   kindergarten 57 11 8 0   1     0   2   42 37 *                     79.0 57 11 8 0   1     0   2   42 37                 79
1366987 1366987 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No Elementary PK 02 2020   pre_kindergarten 13 1 2 0   2     0   0   12 6 *                     18.0 13 1 2 0   2     0   0   12 6                 18
1366988 1366988 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No Elementary PK 02 2020   grade_1 46 8 2 0   5     0   1   30 32 *                     62.0 46 8 2 0   5     0   1   30 32                 62
1366989 1366989 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No Elementary PK 02 2020   grade_2 68 5 8 0   1     0   4   50 36 *                     86.0 68 5 8 0   1     0   4   50 36                 86
1366990 1366990 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2020   kindergarten 67 1 6 0   2     0   2   46 32 *                     78.0 67 1 6 0   2     0   2   46 32                 78
1366991 1366991 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten 30 4 2 0   3     0   4   26 17 *                     43.0 30 4 2 0   3     0   4   26 17                 43
1366992 1366992 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2020   grade_1 83 5 5 0   1     0   4   47 51 *                     98.0 83 5 5 0   1     0   4   47 51                 98
1366993 1366993 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2020   grade_2 75 3 8 1   1     0   6   41 53 *                     94.0 75 3 8 1   1     0   6   41 53                 94
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
1366995 1366995 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2020   pre_kindergarten 10 0 0 0   2     0   0   7 5 *                     12.0 10 0 0 0   2     0   0   7 5                 12
1366996 1366996 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2020   grade_1 58 5 6 1   5     1   4   36 44 *                     80.0 58 5 6 1   5     1   4   36 44                 80
1366997 1366997 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2020   grade_2 48 6 5 0   4     0   0   39 24 *                     63.0 48 6 5 0   4     0   0   39 24                 63
1367697 1367697 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No Elementary KG 02 2020   kindergarten 29 2 22 0   0     0   1   23 31 *                     54.0 29 2 22 0   0     0   1   23 31                 54
1367698 1367698 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No Elementary KG 02 2020   grade_1 30 3 14 0   0     0   1   24 24 *                     48.0 30 3 14 0   0     0   1   24 24                 48
1367699 1367699 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No Elementary KG 02 2020   grade_2 23 2 15 0   1     0   1   18 24 *                     42.0 23 2 15 0   1     0   1   18 24                 42
1367778 1367778 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2020   kindergarten 160 3 4 0   24     0   3   91 103 *                     194.0 160 3 4 0   24     0   3   91 103                 194
1367779 1367779 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten 85 2 1 1   12     0   4   68 37 *                     105.0 85 2 1 1   12     0   4   68 37                 105
1367780 1367780 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2020   grade_1 150 2 9 0   12     1   3   103 73 *                     177.0 150 2 9 0   12     1   3   103 73                 177
1367781 1367781 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2020   grade_2 164 0 13 2   18     0   13   109 101 *                     210.0 164 0 13 2   18     0   13   109 101                 210
1367953 1367953 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2020   kindergarten 145 2 2 0   2     0   3   77 77 *                     154.0 145 2 2 0   2     0   3   77 77                 154
1367954 1367954 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2020   grade_1 144 0 1 0   0     0   3   74 74 *                     148.0 144 0 1 0   0     0   3   74 74                 148
1367955 1367955 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2020   grade_2 146 0 4 1   2     0   1   82 72 *                     154.0 146 0 4 1   2     0   1   82 72                 154
1367992 1367992 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2020   kindergarten 1 0 68 0   1     0   0   38 32 *                     70.0 1 0 68 0   1     0   0   38 32                 70
1367993 1367993 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2020   pre_kindergarten 1 0 87 0   0     0   0   52 35 *                     88.0 1 0 87 0   0     0   0   52 35                 88
1367994 1367994 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2020   grade_1 7 2 78 0   1     0   0   43 44 *                     88.0 7 2 78 0   1     0   0   43 44                 88
1367995 1367995 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2020   grade_2 1 2 71 0   1     0   0   39 36 *                     75.0 1 2 71 0   1     0   0   39 36                 75
1368232 1368232 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2020   kindergarten 97 0 1 0   16     1   1   54 62 *                     116.0 97 0 1 0   16     1   1   54 62                 116
1368233 1368233 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten 58 0 0 0   6     1   0   41 24 *                     65.0 58 0 0 0   6     1   0   41 24                 65
1368234 1368234 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2020   grade_1 108 1 1 0   15     0   2   74 53 *                     127.0 108 1 1 0   15     0   2   74 53                 127
1368235 1368235 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2020   grade_2 112 0 4 0   20     0   1   61 76 *                     137.0 112 0 4 0   20     0   1   61 76                 137
1368442 1368442 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No Elementary PK 02 2020   kindergarten 103 2 11 0   2     0   3   66 55 *                     121.0 103 2 11 0   2     0   3   66 55                 121
1368443 1368443 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No Elementary PK 02 2020   pre_kindergarten 32 1 4 0   0     0   1   23 15 *                     38.0 32 1 4 0   0     0   1   23 15                 38
1368444 1368444 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No Elementary PK 02 2020   grade_1 124 7 12 0   0     1   3   75 72 *                     147.0 124 7 12 0   0     1   3   75 72                 147
1368445 1368445 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No Elementary PK 02 2020   grade_2 90 2 14 0   4     0   1   53 58 *                     111.0 90 2 14 0   4     0   1   53 58                 111
1368687 1368687 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2020   kindergarten 161 12 9 0   14     0   9   103 101 *                     205.0 161 12 9 0   14     0   9   103 101                 205
1368688 1368688 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2020   grade_1 178 10 12 0   14     0   14   119 109 *                     228.0 178 10 12 0   14     0   14   119 109                 228
1368689 1368689 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2020   grade_2 187 7 7 1   20     0   13   127 108 *                     235.0 187 7 7 1   20     0   13   127 108                 235
1368701 1368701 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 01 02 2020   grade_1 96 3 7 0   3     0   5   55 59 *                     114.0 96 3 7 0   3     0   5   55 59                 114
1368702 1368702 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 01 02 2020   grade_2 97 2 9 0   0     0   4   63 49 *                     112.0 97 2 9 0   0     0   4   63 49                 112
1368791 1368791 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2020   kindergarten 67 5 9 2   2     0   11   55 41 *                     96.0 67 5 9 2   2     0   11   55 41                 96
1368792 1368792 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2020   pre_kindergarten 71 1 7 1   2     1   8   54 37 *                     91.0 71 1 7 1   2     1   8   54 37                 91
1368793 1368793 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2020   grade_1 60 3 13 3   1     0   15   48 47 *                     95.0 60 3 13 3   1     0   15   48 47                 95
1368794 1368794 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2020   grade_2 83 2 4 6   1     0   15   68 43 *                     111.0 83 2 4 6   1     0   15   68 43                 111
1369003 1369003 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Fuller Meadow   Regular School No Elementary KG 02 2020   kindergarten 77 0 2 1   1     0   5   39 47 *                     86.0 77 0 2 1   1     0   5   39 47                 86
1369004 1369004 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Fuller Meadow   Regular School No Elementary KG 02 2020   grade_1 81 1 9 1   5     0   6   52 51 *                     103.0 81 1 9 1   5     0   6   52 51                 103
1369005 1369005 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Fuller Meadow   Regular School No Elementary KG 02 2020   grade_2 73 2 4 0   6     0   1   39 47 *                     86.0 73 2 4 0   6     0   1   39 47                 86
1369011 1369011 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No Elementary KG 02 2020   kindergarten 110 5 43 0   1     0   2   80 81 *                     161.0 110 5 43 0   1     0   2   80 81                 161
1369012 1369012 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No Elementary KG 02 2020   grade_1 79 5 61 1   2     0   4   79 73 *                     152.0 79 5 61 1   2     0   4   79 73                 152
1369013 1369013 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No Elementary KG 02 2020   grade_2 102 4 50 0   0     0   5   82 79 *                     161.0 102 4 50 0   0     0   5   82 79                 161
1369014 1369014 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No Elementary KG 02 2020   kindergarten 100 1 47 0   2     0   0   66 84 *                     150.0 100 1 47 0   2     0   0   66 84                 150
1369015 1369015 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No Elementary KG 02 2020   grade_1 93 8 42 0   3     0   4   83 67 *                     150.0 93 8 42 0   3     0   4   83 67                 150
1369016 1369016 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No Elementary KG 02 2020   grade_2 93 6 54 1   0     0   7   86 75 *                     161.0 93 6 54 1   0     0   7   86 75                 161
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
1369116 1369116 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten 22 6 26 0   1     0   4   33 26 *                     59.0 22 6 26 0   1     0   4   33 26                 59
1369117 1369117 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket Elementary   Regular School No Elementary PK 02 2020   grade_1 62 6 42 0   4     0   5   55 64 *                     119.0 62 6 42 0   4     0   5   55 64                 119
1369118 1369118 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket Elementary   Regular School No Elementary PK 02 2020   grade_2 50 9 54 0   1     0   7   61 60 *                     121.0 50 9 54 0   1     0   7   61 60                 121
1369486 1369486 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2020   kindergarten 124 0 3 0   3     0   3   62 71 *                     133.0 124 0 3 0   3     0   3   62 71                 133
1369487 1369487 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2020   pre_kindergarten 65 1 0 0   3     0   1   39 31 *                     70.0 65 1 0 0   3     0   1   39 31                 70
1369488 1369488 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2020   grade_1 119 1 4 0   2     0   3   62 67 *                     129.0 119 1 4 0   2     0   3   62 67                 129
1369489 1369489 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2020   grade_2 114 0 1 0   2     0   0   64 53 *                     117.0 114 0 1 0   2     0   0   64 53                 117
1369799 1369799 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Fisher Hill   Regular School No Elementary PK 02 2020   kindergarten 59 0 4 0   1     0   2   35 31 *                     66.0 59 0 4 0   1     0   2   35 31                 66
1369800 1369800 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Fisher Hill   Regular School No Elementary PK 02 2020   pre_kindergarten 36 0 1 0   0     0   2   20 19 *                     39.0 36 0 1 0   0     0   2   20 19                 39
1369801 1369801 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Fisher Hill   Regular School No Elementary PK 02 2020   grade_1 55 1 4 1   0     0   3   30 34 *                     64.0 55 1 4 1   0     0   3   30 34                 64
1369802 1369802 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Fisher Hill   Regular School No Elementary PK 02 2020   grade_2 51 1 9 0   0     0   4   38 27 *                     65.0 51 1 9 0   0     0   4   38 27                 65

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