enrollments

Data source: Big Local News · About: Big Local

6,831 rows where grade = "grade_2" and state = "MA" sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 6,831 ✖
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
2230205 2230205 MA Suffolk   school   35   Boston   350652               2018   grade_2 * * * *   *     *   *   * *                       0.0                                             0
735772 735772 MA Essex   school 2501950 9   Andover 250195002366 90005 Shawsheen School   Regular School No 1 PK 02 2015   grade_2 37 1 5 0   5     0   5   32 21                       53 37 1 5 0   5     0   5   32 21                 53
735859 735859 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2015   grade_2 146 4 16 0   28     0   5   95 104                       199 146 4 16 0   28     0   5   95 104                 199
735920 735920 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No 1 KG 02 2015   grade_2 66 1 7 0   2     0   5   52 29                       81 66 1 7 0   2     0   5   52 29                 81
735926 735926 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Mary D Stone   Regular School No 1 KG 02 2015   grade_2 79 0 9 0   5     0   3   45 51                       96 79 0 9 0   5     0   3   45 51                 96
735980 735980 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2015   grade_2 138 11 8 0   21     0   1   97 82                       179 138 11 8 0   21     0   1   97 82                 179
736222 736222 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No 1 PK 02 2015   grade_2 5 18 28 0   0     0   0   35 16                       51 5 18 28 0   0     0   0   35 16                 51
736986 736986 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No 1 PK 02 2015   grade_2 86 0 0 0   1     0   0   46 41                       87 86 0 0 0   1     0   0   46 41                 87
737047 737047 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2015   grade_2 66 0 2 0   1     0   2   38 33                       71 66 0 2 0   1     0   2   38 33                 71
737534 737534 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No 1 KG 02 2015   grade_2 56 8 49 1   2     0   1   50 67                       117 56 8 49 1   2     0   1   50 67                 117
737631 737631 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No 1 PK 02 2015   grade_2 116 3 0 0   1     0   4   71 53                       124 116 3 0 0   1     0   4   71 53                 124
737837 737837 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No 1 PK 02 2015   grade_2 211 1 4 0   1     0   4   104 117                       221 211 1 4 0   1     0   4   104 117                 221
737848 737848 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No 1 PK 02 2015   grade_2 151 3 2 1   0     0   4   93 68                       161 151 3 2 1   0     0   4   93 68                 161
737897 737897 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No 1 PK 02 2015   grade_2 144 6 15 0   7     0   5   91 86                       177 144 6 15 0   7     0   5   91 86                 177
737912 737912 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No 1 PK 02 2015   grade_2 75 4 0 0   2     0   1   34 48                       82 75 4 0 0   2     0   1   34 48                 82
737916 737916 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No 1 PK 02 2015   grade_2 100 4 4 1   1     0   3   59 54                       113 100 4 4 1   1     0   3   59 54                 113
737920 737920 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No 1 PK 02 2015   grade_2 68 4 7 0   3     0   4   45 41                       86 68 4 7 0   3     0   4   45 41                 86
738360 738360 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 02 2015   grade_2 71 6 22 0   0     0   10   54 55                       109 71 6 22 0   0     0   10   54 55                 109
738528 738528 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No 1 KG 02 2015   grade_2 101 0 4 0   0     0   3   47 61                       108 101 0 4 0   0     0   3   47 61                 108
738583 738583 MA Essex   school 2505970 128   Haverhill 250597000854 1280027 Greenleaf   Regular School No 1 KG 02 2015   grade_2 60 8 8 0   3     1   0   44 36                       80 60 8 8 0   3     1   0   44 36                 80
738617 738617 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No 1 KG 02 2015   grade_2 51 0 3 0   1     1   0   29 27                       56 51 0 3 0   1     1   0   29 27                 56
738698 738698 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No 1 PK 02 2015   grade_2 183 0 12 0   7     0   8   109 101                       210 183 0 12 0   7     0   8   109 101                 210
738874 738874 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No 1 KG 02 2015   grade_2 136 3 5 0   0     0   2   79 67                       146 136 3 5 0   0     0   2   79 67                 146
738923 738923 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No 1 PK 02 2015   grade_2 7 1 75 0   0     0   0   40 43                       83 7 1 75 0   0     0   0   40 43                 83
739046 739046 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No 1 PK 02 2015   grade_2 93 7 1 2   5     0   0   63 45                       108 93 7 1 2   5     0   0   63 45                 108
739190 739190 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No 1 PK 02 2015   grade_2 93 1 5 0   5     0   3   54 53                       107 93 1 5 0   5     0   3   54 53                 107
739239 739239 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers Early Learning Center   Regular School No 1 PK 02 2015   grade_2 13 13 42 0   20     0   3   46 45                       91 13 13 42 0   20     0   3   46 45                 91
739613 739613 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No 1 KG 02 2015   grade_2 225 4 12 1   12     0   3   133 124                       257 225 4 12 1   12     0   3   133 124                 257
739724 739724 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   grade_2 97 3 3 8   3     0   9   59 64                       123 97 3 3 8   3     0   9   59 64                 123
739937 739937 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Fuller Meadow   Regular School No 1 KG 02 2015   grade_2 72 0 2 1   4     0   2   47 34                       81 72 0 2 1   4     0   2   47 34                 81
739945 739945 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No 1 KG 02 2015   grade_2 84 3 50 5   5     0   9   87 69                       156 84 3 50 5   5     0   9   87 69                 156
740426 740426 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No 1 PK 02 2015   grade_2 88 1 7 0   0     0   3   49 50                       99 88 1 7 0   0     0   3   49 50                 99
740746 740746 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Fisher Hill   Regular School No 1 PK 02 2015   grade_2 69 0 9 1   1     0   8   51 37                       88 69 0 9 1   1     0   8   51 37                 88
740758 740758 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No 1 KG 02 2015   grade_2 124 1 27 1   1     0   7   81 80                       161 124 1 27 1   1     0   7   81 80                 161
742147 742147 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No 1 PK 02 2015   grade_2 96 0 2 0   1     0   7   49 57                       106 96 0 2 0   1     0   7   49 57                 106
742188 742188 MA Bristol   school 2511460 292   Swansea 251146001892 2920015 Gardner   Regular School No 1 KG 02 2015   grade_2 101 0 1 0   1     0   0   58 45                       103 101 0 1 0   1     0   0   58 45                 103
742192 742192 MA Bristol   school 2511460 292   Swansea 251146000129 2920017 Mark G Hoyle Elementary   Regular School No 1 PK 02 2015   grade_2 82 1 1 0   0     0   1   47 38                       85 82 1 1 0   0     0   1   47 38                 85
742261 742261 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No 1 PK 02 2015   grade_2 126 7 0 0   6     0   2   79 62                       141 126 7 0 0   6     0   2   79 62                 141
742264 742264 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Heath-Brook   Regular School No 1 KG 02 2015   grade_2 109 0 4 0   6     0   2   54 67                       121 109 0 4 0   6     0   2   54 67                 121
742320 742320 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Taft Early Learning Center   Regular School No 1 PK 02 2015   grade_2 124 0 6 1   2     0   3   68 68                       136 124 0 6 1   2     0   3   68 68                 136
742472 742472 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2015   grade_2 167 15 10 2   3     0   16   118 95                       213 167 15 10 2   3     0   16   118 95                 213
742548 742548 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No 1 PK 02 2015   grade_2 84 5 32 1   5     0   14   73 68                       141 84 5 32 1   5     0   14   73 68                 141
742737 742737 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No 1 KG 02 2015   grade_2 104 0 0 0   11     0   3   64 54                       118 104 0 0 0   11     0   3   64 54                 118
742740 742740 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Col John Robinson   Regular School No 1 KG 02 2015   grade_2 66 2 2 0   27     0   3   56 44                       100 66 2 2 0   27     0   3   56 44                 100
742746 742746 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No 1 KG 02 2015   grade_2 71 2 1 0   31     0   7   60 52                       112 71 2 1 0   31     0   7   60 52                 112
742975 742975 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No 1 KG 02 2015   grade_2 92 3 7 0   5     1   1   59 50                       109 92 3 7 0   5     1   1   59 50                 109
744684 744684 MA Essex   school 2509450 745   Pentucket 250945000414 7450020 Dr Frederick N Sweetsir   Regular School No 1 PK 02 2015   grade_2 63 0 3 0   0     0   4   39 31                       70 63 0 3 0   0     0   4   39 31                 70
744915 744915 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No 1 KG 02 2015   grade_2 109 2 9 0   5     0   4   64 65                       129 109 2 9 0   5     0   4   64 65                 129
745006 745006 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No 1 PK 02 2015   grade_2 102 1 4 0   1     0   2   58 52                       110 102 1 4 0   1     0   2   58 52                 110
932735 932735 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2016   grade_2 156 2 19 5   29     0   8   116 103                       219 156 2 19 5   29     0   8   116 103                 219
932794 932794 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No 1 KG 02 2016   grade_2 83 3 3 0   1     0   4   42 52                       94 83 3 3 0   1     0   4   42 52                 94
932797 932797 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No 1 KG 02 2016   grade_2 73 3 5 0   4     0   1   34 52                       86 73 3 5 0   4     0   1   34 52                 86
932854 932854 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2016   grade_2 142 10 5 0   33     0   8   101 97                       198 142 10 5 0   33     0   8   101 97                 198
933092 933092 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No 1 PK 02 2016   grade_2 0 20 27 0   0     0   2   32 17                       49 0 20 27 0   0     0   2   32 17                 49
933851 933851 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No 1 PK 02 2016   grade_2 80 1 1 0   1     0   4   45 42                       87 80 1 1 0   1     0   4   45 42                 87
933914 933914 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2016   grade_2 72 0 4 0   1     0   5   44 38                       82 72 0 4 0   1     0   5   44 38                 82
934394 934394 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No 1 KG 02 2016   grade_2 56 8 26 0   0     0   1   51 40                       91 56 8 26 0   0     0   1   51 40                 91
934490 934490 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No 1 PK 02 2016   grade_2 130 3 1 0   1     0   0   72 63                       135 130 3 1 0   1     0   0   72 63                 135
934691 934691 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No 1 PK 02 2016   grade_2 206 0 9 0   2     0   5   114 108                       222 206 0 9 0   2     0   5   114 108                 222
934702 934702 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No 1 PK 02 2016   grade_2 145 5 4 0   1     0   7   94 68                       162 145 5 4 0   1     0   7   94 68                 162
934751 934751 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No 1 PK 02 2016   grade_2 156 6 6 0   12     0   7   88 99                       187 156 6 6 0   12     0   7   88 99                 187
934765 934765 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No 1 PK 02 2016   grade_2 80 3 0 0   5     0   0   44 44                       88 80 3 0 0   5     0   0   44 44                 88
934769 934769 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No 1 PK 02 2016   grade_2 95 3 2 0   3     0   4   52 55                       107 95 3 2 0   3     0   4   52 55                 107
934773 934773 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No 1 PK 02 2016   grade_2 46 0 5 0   2     0   1   31 23                       54 46 0 5 0   2     0   1   31 23                 54
935378 935378 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No 1 KG 02 2016   grade_2 103 0 2 0   0     0   0   52 53                       105 103 0 2 0   0     0   0   52 53                 105
935432 935432 MA Essex   school 2505970 128   Haverhill 250597000854 1280027 Greenleaf   Regular School No 1 KG 02 2016   grade_2 58 4 19 1   2     0   0   42 42                       84 58 4 19 1   2     0   0   42 42                 84
935464 935464 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No 1 KG 02 2016   grade_2 32 0 11 0   0     0   2   12 33                       45 32 0 11 0   0     0   2   12 33                 45
935543 935543 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No 1 PK 02 2016   grade_2 180 2 15 1   12     0   6   106 110                       216 180 2 15 1   12     0   6   106 110                 216
935723 935723 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No 1 KG 02 2016   grade_2 137 0 2 1   1     0   1   71 71                       142 137 0 2 1   1     0   1   71 71                 142
935771 935771 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No 1 PK 02 2016   grade_2 2 3 88 0   1     0   0   50 44                       94 2 3 88 0   1     0   0   50 44                 94
935895 935895 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No 1 PK 02 2016   grade_2 104 11 3 1   1     0   0   66 54                       120 104 11 3 1   1     0   0   66 54                 120
936036 936036 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No 1 PK 02 2016   grade_2 101 3 2 0   19     0   1   64 62                       126 101 3 2 0   19     0   1   64 62                 126
936458 936458 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No 1 KG 02 2016   grade_2 218 7 16 0   13     0   5   142 117                       259 218 7 16 0   13     0   5   142 117                 259
936568 936568 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2016   grade_2 101 5 4 8   1     0   6   62 63                       125 101 5 4 8   1     0   6   62 63                 125
936781 936781 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Fuller Meadow   Regular School No 1 KG 02 2016   grade_2 83 1 6 0   5     0   9   51 53                       104 83 1 6 0   5     0   9   51 53                 104
936789 936789 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No 1 KG 02 2016   grade_2 89 6 42 7   2     0   4   89 61                       150 89 6 42 7   2     0   4   89 61                 150
937261 937261 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No 1 PK 02 2016   grade_2 127 1 3 0   0     0   4   73 62                       135 127 1 3 0   0     0   4   73 62                 135
937574 937574 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Fisher Hill   Regular School No 1 PK 02 2016   grade_2 80 2 5 0   0     0   3   47 43                       90 80 2 5 0   0     0   3   47 43                 90
937586 937586 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No 1 PK 02 2016   grade_2 120 2 8 0   1     0   4   71 64                       135 120 2 8 0   1     0   4   71 64                 135
938213 938213 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No 1 PK 02 2016   grade_2 190 4 3 1   6     0   3   102 105                       207 190 4 3 1   6     0   3   102 105                 207
938957 938957 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No 1 PK 02 2016   grade_2 79 1 2 0   2     0   9   49 44                       93 79 1 2 0   2     0   9   49 44                 93
938997 938997 MA Bristol   school 2511460 292   Swansea 251146001892 2920015 Gardner   Regular School No 1 KG 02 2016   grade_2 87 0 0 0   2     0   0   38 51                       89 87 0 0 0   2     0   0   38 51                 89
939001 939001 MA Bristol   school 2511460 292   Swansea 251146000129 2920017 Mark G Hoyle Elementary   Regular School No 1 PK 02 2016   grade_2 58 1 3 1   0     0   1   27 37                       64 58 1 3 1   0     0   1   27 37                 64
939070 939070 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No 1 PK 02 2016   grade_2 109 4 3 0   3     0   2   71 50                       121 109 4 3 0   3     0   2   71 50                 121
939073 939073 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Heath-Brook   Regular School No 1 KG 02 2016   grade_2 127 1 1 0   2     0   1   63 69                       132 127 1 1 0   2     0   1   63 69                 132
939129 939129 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Taft Early Learning Center   Regular School No 1 PK 02 2016   grade_2 121 0 2 0   3     0   1   72 55                       127 121 0 2 0   3     0   1   72 55                 127
939279 939279 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2016   grade_2 150 18 6 5   2     0   21   86 116                       202 150 18 6 5   2     0   21   86 116                 202
939543 939543 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No 1 KG 02 2016   grade_2 89 0 1 0   20     0   2   48 64                       112 89 0 1 0   20     0   2   48 64                 112
939546 939546 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Col John Robinson   Regular School No 1 KG 02 2016   grade_2 69 1 2 1   17     0   4   44 50                       94 69 1 2 1   17     0   4   44 50                 94
939552 939552 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No 1 KG 02 2016   grade_2 62 0 0 0   31     0   4   45 52                       97 62 0 0 0   31     0   4   45 52                 97
939594 939594 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No 1 PK 02 2016   grade_2 99 0 3 0   0     0   9   59 52                       111 99 0 3 0   0     0   9   59 52                 111
939779 939779 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No 1 KG 02 2016   grade_2 87 0 5 0   1     0   2   43 52                       95 87 0 5 0   1     0   2   43 52                 95
940925 940925 MA Worcester   school 2502715 622   Blackstone-Millville 250271502372 6220008 John F Kennedy Elementary   Regular School No 1 KG 02 2016   grade_2 87 3 6 0   2     0   4   49 53                       102 87 3 6 0   2     0   4   49 53                 102
941507 941507 MA Essex   school 2509450 745   Pentucket 250945000414 7450020 Dr Frederick N Sweetsir   Regular School No 1 PK 02 2016   grade_2 38 0 4 0   0     0   0   20 22                       42 38 0 4 0   0     0   0   20 22                 42
941636 941636 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No 1 PK 02 2016   grade_2 73 3 10 0   1     0   0   41 46                       87 73 3 10 0   1     0   0   41 46                 87
941736 941736 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No 1 KG 02 2016   grade_2 94 0 5 0   3     0   5   52 55                       107 94 0 5 0   3     0   5   52 55                 107
941827 941827 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No 1 PK 02 2016   grade_2 101 0 1 0   0     0   2   56 48                       104 101 0 1 0   0     0   2   56 48                 104
1122188 1122188 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2017   grade_2 159 5 15 4   32     0   4   104 115                       219 159 5 15 4   32     0   4   104 115                 219
1122261 1122261 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2017   grade_2 67 2 11 0   6     0   2   45 43                       88 67 2 11 0   6     0   2   45 43                 88
1122265 1122265 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary KG 02 2017   grade_2 76 2 10 0   3     0   2   49 44                       93 76 2 10 0   3     0   2   49 44                 93

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