enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1124085 1124085 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2017   grade_2 19 15 162 0   1     0   3   107 93                       200 19 15 162 0   1     0   3   107 93                 200
934357 934357 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2016   grade_2 14 11 154 1   4     0   2   99 87                       186 14 11 154 1   4     0   2   99 87                 186
2043050 2043050 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2019   grade_2 7 0 149 0   3     0   0   88 71                       159.0 7 0 149 0   3     0   0   88 71                 159
2232581 2232581 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 Lawrence: South Lawrence East Elementary School   Regular School No Elementary 01 05 2018   grade_2 7 2 147 0   2     0   1   86 73                       159.0 7 2 147 0   2     0   1   86 73                 159
934361 934361 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2016   grade_2 6 3 143 0   1     0   2   71 84                       155 6 3 143 0   1     0   2   71 84                 155
1124090 1124090 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 04 2017   grade_2 6 5 142 0   2     0   2   86 71                       157 6 5 142 0   2     0   2   86 71                 157
1675268 1675268 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Lawrence - Edward F. Parthum   Regular School No Elementary KG 04 2021   grade_2 2 1 141 0   0     0   0   81 62 *                     144.0 2 1 141 0   0     0   0   81 62                 144
2041656 2041656 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2019   grade_2 4 7 137 0   1     0   0   87 62                       149.0 4 7 137 0   1     0   0   87 62                 149
738893 738893 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No 1 01 04 2015   grade_2 6 2 134 0   4     0   3   79 70                       149 6 2 134 0   4     0   3   79 70                 149
935773 935773 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No 1 01 04 2016   grade_2 4 2 134 0   2     0   2   75 69                       144 4 2 134 0   2     0   2   75 69                 144
1367997 1367997 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2020   grade_2 3 3 133 0   1     0   0   68 72 *                     140.0 3 3 133 0   1     0   0   68 72                 140
738899 738899 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 PK 04 2015   grade_2 3 2 131 0   0     0   0   67 69                       136 3 2 131 0   0     0   0   67 69                 136
1368023 1368023 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary KG 04 2020   grade_2 6 3 131 0   0     0   0   69 71 *                     140.0 6 3 131 0   0     0   0   69 71                 140
1367966 1367966 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary 01 05 2020   grade_2 5 3 129 0   2     0   0   68 71 *                     139.0 5 3 129 0   2     0   0   68 71                 139
2232652 2232652 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Lawrence: Edward F. Parthum   Regular School No Elementary KG 04 2018   grade_2 7 0 128 0   1     0   1   77 60                       137.0 7 0 128 0   1     0   1   77 60                 137
934353 934353 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2016   grade_2 12 10 127 0   1     0   1   78 73                       151 12 10 127 0   1     0   1   78 73                 151
1675211 1675211 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 Lawrence - South Lawrence East Elementary School   Regular School No Elementary 01 05 2021   grade_2 6 5 127 0   5     0   1   72 72 *                     144.0 6 5 127 0   5     0   1   72 72                 144
2230900 2230900 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea: Edgar A Hooks Elementary   Regular School No Elementary 01 04 2018   grade_2 13 8 127 0   1     0   4   89 64                       153.0 13 8 127 0   1     0   4   89 64                 153
935742 935742 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No 1 KG 05 2016   grade_2 9 3 126 0   5     0   0   74 69                       143 9 3 126 0   5     0   0   74 69                 143
1673804 1673804 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea - William A Berkowitz Elementary   Regular School No Elementary 01 04 2021   grade_2 13 4 125 0   0     0   2   72 72 *                     144.0 13 4 125 0   0     0   2   72 72                 144
737501 737501 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No 1 01 04 2015   grade_2 7 1 124 0   1     0   1   65 69                       134 7 1 124 0   1     0   1   65 69                 134
935748 935748 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 KG 04 2016   grade_2 3 0 124 0   0     0   0   64 63                       127 3 0 124 0   0     0   0   64 63                 127
1125802 1125802 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2017   grade_2 6 4 124 0   0     0   1   67 68                       135 6 4 124 0   0     0   1   67 68                 135
1366587 1366587 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2020   grade_2 12 7 124 0   0     0   2   66 79 *                     145.0 12 7 124 0   0     0   2   66 79                 145
934365 934365 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2016   grade_2 10 8 123 0   2     0   2   80 65                       145 10 8 123 0   2     0   2   80 65                 145
1125764 1125764 MA Essex   school 2506660 149   Lawrence 250666001918 1490004 South Lawrence East Elementary School   Regular School No Elementary KG 05 2017   grade_2 7 1 123 0   6     0   0   81 56                       137 7 1 123 0   6     0   0   81 56                 137
737493 737493 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No 1 01 04 2015   grade_2 17 13 122 0   1     0   1   76 78                       154 17 13 122 0   1     0   1   76 78                 154
737497 737497 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No 1 01 04 2015   grade_2 10 9 122 2   4     0   2   80 69                       149 10 9 122 2   4     0   2   80 69                 149
1366577 1366577 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2020   grade_2 20 7 122 0   0     0   1   74 76 *                     150.0 20 7 122 0   0     0   1   74 76                 150
2043056 2043056 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2019   grade_2 1 2 122 0   0     0   2   61 66                       127.0 1 2 122 0   0     0   2   61 66                 127
2232619 2232619 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Lawrence: Gerard A. Guilmette   Regular School No Elementary 01 04 2018   grade_2 3 3 122 0   2     0   0   75 55                       130.0 3 3 122 0   2     0   0   75 55                 130
738952 738952 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No 1 KG 04 2015   grade_2 19 1 121 0   1     0   2   67 77                       144 19 1 121 0   1     0   2   67 77                 144
1367972 1367972 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2020   grade_2 2 0 120 0   0     0   0   64 58 0                     122.0 2 0 120 0   0     0   0   64 58 0               122
2232588 2232588 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Lawrence: Community Day Arlington   Regular School No Elementary KG 04 2018   grade_2 3 3 120 0   0     0   0   67 59                       126.0 3 3 120 0   0     0   0   67 59                 126
2041647 2041647 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Edgar A Hooks Elementary   Regular School No Elementary 01 04 2019   grade_2 16 10 119 1   0     0   1   73 74                       147.0 16 10 119 1   0     0   1   73 74                 147
1125771 1125771 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2017   grade_2 1 0 118 0   0     0   0   57 62                       119 1 0 118 0   0     0   0   57 62                 119
2230910 2230910 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea: Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2018   grade_2 15 4 118 0   0     0   2   66 73                       139.0 15 4 118 0   0     0   2   66 73                 139
737505 737505 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No 1 01 04 2015   grade_2 14 10 117 0   0     0   3   68 76                       144 14 10 117 0   0     0   3   68 76                 144
738925 738925 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No 1 01 04 2015   grade_2 4 1 116 0   1     0   0   56 66                       122 4 1 116 0   1     0   0   56 66                 122
935800 935800 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No 1 KG 04 2016   grade_2 9 1 116 1   0     0   2   70 59                       129 9 1 116 1   0     0   2   70 59                 129
2043107 2043107 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary PK 04 2019   grade_2 10 3 115 0   0     0   0   75 53                       128.0 10 3 115 0   0     0   0   75 53                 128
2041643 2041643 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2019   grade_2 9 8 114 0   0     0   0   70 61                       131.0 9 8 114 0   0     0   0   70 61                 131
1125792 1125792 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2017   grade_2 14 2 113 0   2     0   1   61 71                       132 14 2 113 0   2     0   1   61 71                 132
1673818 1673818 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea - Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2021   grade_2 11 3 113 0   1     0   0   61 67 *                     128.0 11 3 113 0   1     0   0   61 67                 128
1125835 1125835 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary KG 04 2017   grade_2 12 2 112 0   2     0   0   59 69                       128 12 2 112 0   2     0   0   59 69                 128
1675217 1675217 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Lawrence - Community Day Arlington   Regular School No Elementary KG 04 2021   grade_2 5 1 112 0   0     0   0   60 58 *                     118.0 5 1 112 0   0     0   0   60 58                 118
1675234 1675234 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Lawrence - Robert Frost   Regular School No Elementary KG 04 2021   grade_2 5 3 110 0   6     0   0   63 59 *                     124.0 5 3 110 0   6     0   0   63 59                 124
1366573 1366573 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2020   grade_2 6 10 108 0   0     0   7   66 65 *                     131.0 6 10 108 0   0     0   7   66 65                 131
2043098 2043098 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2019   grade_2 1 1 107 0   1     0   0   56 54                       110.0 1 1 107 0   1     0   0   56 54                 110
2230905 2230905 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea: George F. Kelly Elementary   Regular School No Elementary 01 04 2018   grade_2 9 3 107 0   0     0   1   57 63                       120.0 9 3 107 0   0     0   1   57 63                 120
1124080 1124080 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2017   grade_2 19 7 106 0   4     0   2   79 59                       138 19 7 106 0   4     0   2   79 59                 138
1675242 1675242 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Lawrence - Gerard A. Guilmette   Regular School No Elementary 01 04 2021   grade_2 2 2 106 0   1     0   0   63 48 *                     111.0 2 2 106 0   1     0   0   63 48                 111
738917 738917 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No 1 KG 04 2015   grade_2 19 2 105 0   5     0   5   76 60                       136 19 2 105 0   5     0   5   76 60                 136
1673808 1673808 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea - Edgar A Hooks Elementary   Regular School No Elementary 01 04 2021   grade_2 15 9 105 0   0     0   2   57 74 *                     131.0 15 9 105 0   0     0   2   57 74                 131
2043073 2043073 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2019   grade_2 9 5 104 0   1     0   1   53 67                       120.0 9 5 104 0   1     0   1   53 67                 120
2043081 2043081 MA Essex   school 2506660 149   Lawrence 250666001626 1490022 Gerard A. Guilmette   Regular School No Elementary 01 04 2019   grade_2 4 2 104 0   1     0   1   57 55                       112.0 4 2 104 0   1     0   1   57 55                 112
2230895 2230895 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 Chelsea: William A Berkowitz Elementary   Regular School No Elementary 01 04 2018   grade_2 6 8 103 0   1     0   1   65 54                       119.0 6 8 103 0   1     0   1   65 54                 119
935765 935765 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No 1 KG 04 2016   grade_2 8 5 102 0   3     0   3   61 60                       121 8 5 102 0   3     0   3   61 60                 121
1673812 1673812 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_2 6 4 102 0   0     0   0   55 57 *                     112.0 6 4 102 0   0     0   0   55 57                 112
2041651 2041651 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 05 2019   grade_2 3 5 101 0   0     0   1   55 55                       110.0 3 5 101 0   0     0   1   55 55                 110
1679812 1679812 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter (District) - KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2021   grade_2 9 14 97 0   1     2   1   54 70 *                     124.0 9 14 97 0   1     2   1   54 70                 124
2232609 2232609 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Lawrence: Robert Frost   Regular School No Elementary KG 04 2018   grade_2 11 3 97 0   2     0   1   59 55                       114.0 11 3 97 0   2     0   1   59 55                 114
1366581 1366581 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_2 4 5 96 0   0     0   0   47 58 *                     105.0 4 5 96 0   0     0   0   47 58                 105
1125824 1125824 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2017   grade_2 6 0 95 0   1     0   1   62 41                       103 6 0 95 0   1     0   1   62 41                 103
1367351 1367351 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   grade_2 19 4 94 0   0     0   4   47 74 *                     121.0 19 4 94 0   0     0   4   47 74                 121
2232635 2232635 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Lawrence: Francis M Leahy   Regular School No Elementary KG 05 2018   grade_2 5 1 94 0   0     0   0   55 45                       100.0 5 1 94 0   0     0   0   55 45                 100
2233235 2233235 MA Essex   school 2507110 163   Lynn 250711001073 1630050 Lynn: Robert L Ford   Regular School No Elementary 01 05 2018   grade_2 7 6 94 1   9     0   2   61 58                       119.0 7 6 94 1   9     0   2   61 58                 119
1124095 1124095 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2017   grade_2 10 16 93 0   4     0   4   63 64                       127 10 16 93 0   4     0   4   63 64                 127
1674585 1674585 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham - Barbieri Elementary   Regular School No Elementary KG 05 2021   grade_2 18 4 93 0   0     0   6   54 67 *                     121.0 18 4 93 0   0     0   6   54 67                 121
738943 738943 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2015   grade_2 2 1 92 0   1     0   1   58 39                       97 2 1 92 0   1     0   1   58 39                 97
935786 935786 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2016   grade_2 3 1 91 0   0     0   0   46 49                       95 3 1 91 0   0     0   0   46 49                 95
935791 935791 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No 1 01 05 2016   grade_2 1 4 91 0   1     0   0   42 55                       97 1 4 91 0   1     0   0   42 55                 97
2043093 2043093 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2019   grade_2 4 0 91 0   0     0   0   42 53                       95.0 4 0 91 0   0     0   0   42 53                 95
1125818 1125818 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary KG 05 2017   grade_2 2 2 90 0   0     0   0   50 44                       94 2 2 90 0   0     0   0   50 44                 94
2045914 2045914 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2019   grade_2 6 22 90 0   0     0   2   60 60                       120.0 6 22 90 0   0     0   2   60 60                 120
741944 741944 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No 1 PK 05 2015   grade_2 2 9 89 0   0     0   0   44 56                       100 2 9 89 0   0     0   0   44 56                 100
1367989 1367989 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2020   grade_2 10 0 89 0   6     0   1   53 53 *                     106.0 10 0 89 0   6     0   1   53 53                 106
1675747 1675747 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Lynn - Cobbet Elementary   Regular School No Elementary KG 05 2021   grade_2 5 7 89 0   3     0   1   59 46 *                     105.0 5 7 89 0   3     0   1   59 46                 105
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
936279 936279 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No 1 KG 05 2016   grade_2 3 11 88 0   4     0   3   46 63                       109 3 11 88 0   4     0   3   46 63                 109
938552 938552 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No 1 PK 05 2016   grade_2 11 12 88 0   3     0   2   55 61                       116 11 12 88 0   3     0   2   55 61                 116
1125799 1125799 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2017   grade_2 4 2 88 0   2     0   0   47 49                       96 4 2 88 0   2     0   0   47 49                 96
1129325 1129325 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2017   grade_2 4 6 88 0   0     0   0   49 49                       98 4 6 88 0   0     0   0   49 49                 98
741249 741249 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No 1 PK 05 2015   grade_2 39 5 87 0   11     0   1   73 70                       143 39 5 87 0   11     0   1   73 70                 143
935581 935581 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2016   grade_2 1 1 87 0   2     0   1   42 50                       92 1 1 87 0   2     0   1   42 50                 92
1675259 1675259 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Lawrence - Oliver Partnership School   Regular School No Elementary 01 05 2021   grade_2 1 0 87 0   1     0   0   49 40 *                     89.0 1 0 87 0   1     0   0   49 40                 89
1372549 1372549 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2020   grade_2 9 19 86 0   4     0   6   58 66 *                     124.0 9 19 86 0   4     0   6   58 66                 124
938750 938750 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No 1 PK 05 2016   grade_2 2 13 85 0   2     0   0   61 41                       102 2 13 85 0   2     0   0   61 41                 102
1126406 1126406 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No Elementary PK 05 2017   grade_2 8 10 85 0   10     0   2   54 61                       115 8 10 85 0   10     0   2   54 61                 115
1129163 1129163 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2017   grade_2 5 35 85 0   0     0   2   66 61                       127 5 35 85 0   0     0   2   66 61                 127
2231816 2231816 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham: Barbieri Elementary   Regular School No Elementary KG 05 2018   grade_2 17 4 85 0   0     0   5   56 55                       111.0 17 4 85 0   0     0   5   56 55                 111
936293 936293 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No 1 PK 05 2016   grade_2 3 11 84 0   5     0   7   58 52                       110 3 11 84 0   5     0   7   58 52                 110
1125430 1125430 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Tilton   Regular School No Elementary 01 04 2017   grade_2 50 2 84 2   0     0   2   86 54                       140 50 2 84 2   0     0   2   86 54                 140
1368009 1368009 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_2 1 2 84 0   0     0   0   42 45 *                     87.0 1 2 84 0   0     0   0   42 45                 87
1368505 1368505 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No Elementary KG 05 2020   grade_2 4 4 84 0   4     0   1   55 42 *                     97.0 4 4 84 0   4     0   1   55 42                 97
2041224 2041224 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Manthala George Jr. School   Regular School No Elementary KG 05 2019   grade_2 14 66 84 2   2     0   4   84 88                       172.0 14 66 84 2   2     0   4   84 88                 172
2047798 2047798 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2019   grade_2 0 0 84 0   0     0   0   35 49                       84.0 0 0 84 0   0     0   0   35 49                 84
2232616 2232616 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 Lawrence: James F Hennessey   Regular School No Elementary PK 02 2018   grade_2 4 1 84 0   1     0   2   41 51                       92.0 4 1 84 0   1     0   2   41 51                 92
936261 936261 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No 1 KG 05 2016   grade_2 9 13 83 0   16     0   2   59 64                       123 9 13 83 0   16     0   2   59 64                 123
936514 936514 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Charles Jaworek School   Regular School No 1 KG 04 2016   grade_2 60 4 83 0   10     0   3   85 75                       160 60 4 83 0   10     0   3   85 75                 160

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