Data source: Big Local News · About: Big Local

6,747 rows where grade = "kindergarten" and state = "MA" sorted by hispanic_int descending

View and edit SQL

year

grade

  • kindergarten · 6,747
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
737490 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No 1 PK KG 2015   kindergarten 66 36 498 0   6     0   11   327 290                       617 66 36 498 0   6     0   11   327 290                 617
1124075 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2017   kindergarten 39 38 477 1   1     0   1   290 267                       557 39 38 477 1   1     0   1   290 267                 557
934350 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No 1 PK KG 2016   kindergarten 41 25 448 0   4     0   10   298 230                       528 41 25 448 0   4     0   10   298 230                 528
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
1366569 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2020   kindergarten 30 20 442 1   0     0   2   261 234 *                     495.0 30 20 442 1   0     0   2   261 234                 495
2230890 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Chelsea: Shurtleff Early Childhood   Regular School No Elementary PK 01 2018   kindergarten 39 33 429 0   8     0   4   241 272                       513.0 39 33 429 0   8     0   4   241 272                 513
1673800 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Chelsea - Shurtleff Early Childhood   Regular School No Elementary PK 01 2021   kindergarten 36 30 404 2   0     0   5   230 247 *                     477.0 36 30 404 2   0     0   5   230 247                 477
2043046 MA Essex   school 2506660 149   Lawrence 250666000471 1490002 Lawlor Early Childhood Center   Regular School No Elementary KG KG 2019   kindergarten 5 3 182 0   0     0   0   105 83                       190.0 5 3 182 0   0     0   0   105 83                 190
738889 MA Essex   school 2506660 149   Lawrence 250666000471 1490002 Lawlor Early Childhood Center   Regular School No 1 KG KG 2015   kindergarten 2 0 173 0   1     0   0   91 85                       176 2 0 173 0   1     0   0   91 85                 176
1367962 MA Essex   school 2506660 149   Lawrence 250666000471 1490002 Lawlor Early Childhood Center   Regular School No Elementary KG KG 2020   kindergarten 3 1 168 0   0     0   0   88 84 *                     172.0 3 1 168 0   0     0   0   88 84                 172
743667 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 KG 08 2015   kindergarten 0 1 164 0   0     0   0   78 87                       165 0 1 164 0   0     0   0   78 87                 165
2232575 MA Essex   school 2506660 149   Lawrence 250666000471 1490002 Lawrence: Lawlor Early Childhood Center   Regular School No Elementary KG KG 2018   kindergarten 2 2 158 0   0     0   1   87 76                       163.0 2 2 158 0   0     0   1   87 76                 163
936242 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No 1 PK 05 2016   kindergarten 15 13 154 1   17     0   9   107 102                       209 15 13 154 1   17     0   9   107 102                 209
739395 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No 1 PK 05 2015   kindergarten 31 25 145 0   16     0   14   128 103                       231 31 25 145 0   16     0   14   128 103                 231
1126347 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2017   kindergarten 29 22 140 1   24     0   8   117 107                       224 29 22 140 1   24     0   8   117 107                 224
2232592 MA Essex   school 2506660 149   Lawrence 250666002815 1490011 Lawrence: Lawrence Family Public Academy   Regular School No Elementary PK KG 2018   kindergarten 6 1 139 0   1     0   0   80 67                       147.0 6 1 139 0   1     0   0   80 67                 147
1675777 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Lynn - Ingalls   Regular School No Elementary KG 05 2021   kindergarten 12 22 137 1   8     0   5   94 91 *                     185.0 12 22 137 1   8     0   5   94 91                 185
935738 MA Essex   school 2506660 149   Lawrence 250666000471 1490002 Lawlor Early Childhood Center   Regular School No 1 KG KG 2016   kindergarten 10 3 136 0   0     1   1   65 86                       151 10 3 136 0   0     1   1   65 86                 151
2233171 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Lynn: Early Childhood Center   Regular School No Elementary PK 05 2018   kindergarten 8 20 136 0   18     0   3   91 94                       185.0 8 20 136 0   18     0   3   91 94                 185
1125758 MA Essex   school 2506660 149   Lawrence 250666000471 1490002 Lawlor Early Childhood Center   Regular School No Elementary KG KG 2017   kindergarten 2 1 134 0   1     0   1   72 67                       139 2 1 134 0   1     0   1   72 67                 139
935751 MA Essex   school 2506660 149   Lawrence 250666002815 1490011 Lawrence Family Public Academy   Regular School No 1 PK KG 2016   kindergarten 5 3 131 0   2     0   0   69 72                       141 5 3 131 0   2     0   0   69 72                 141
2043541 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2019   kindergarten 14 17 130 1   13     0   6   96 85                       181.0 14 17 130 1   13     0   6   96 85                 181
2043060 MA Essex   school 2506660 149   Lawrence 250666002815 1490011 Lawrence Family Public Academy   Regular School No Elementary PK KG 2019   kindergarten 5 4 127 0   1     0   1   82 56                       138.0 5 4 127 0   1     0   1   82 56                 138
1368535 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No Elementary KG 05 2020   kindergarten 9 15 125 1   10     0   7   86 81 *                     167.0 9 15 125 1   10     0   7   86 81                 167
1675207 MA Essex   school 2506660 149   Lawrence 250666000471 1490002 Lawrence - Lawlor Early Childhood Center   Regular School No Elementary KG KG 2021   kindergarten 3 2 121 0   0     0   1   63 64 *                     127.0 3 2 121 0   0     0   1   63 64                 127
1367963 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 John Breen School   Regular School No Elementary PK KG 2020   kindergarten 3 7 113 0   6     0   1   62 67 *                     130.0 3 7 113 0   6     0   1   62 67                 130
738902 MA Essex   school 2506660 149   Lawrence 250666002815 1490011 Lawrence Family Public Academy   Regular School No 1 PK KG 2015   kindergarten 4 3 112 0   2     0   1   61 61                       122 4 3 112 0   2     0   1   61 61                 122
2043048 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 John Breen School   Regular School No Elementary PK KG 2019   kindergarten 2 6 112 0   4     0   1   62 63                       125.0 2 6 112 0   4     0   1   62 63                 125
935739 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 John Breen School   Regular School No 1 PK KG 2016   kindergarten 6 2 111 0   2     0   0   72 49                       121 6 2 111 0   2     0   0   72 49                 121
738890 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 John Breen School   Regular School No 1 PK KG 2015   kindergarten 8 0 110 0   5     0   1   72 52                       124 8 0 110 0   5     0   1   72 52                 124
1125760 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 John Breen School   Regular School No Elementary PK KG 2017   kindergarten 9 1 108 0   3     0   2   71 52                       123 9 1 108 0   3     0   2   71 52                 123
738936 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2015   kindergarten 3 0 107 0   0     0   0   62 48                       110 3 0 107 0   0     0   0   62 48                 110
1368021 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary KG 04 2020   kindergarten 2 4 107 0   0     0   0   60 51 *                     113.0 2 4 107 0   0     0   0   60 51                 113
1370739 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No Elementary PK 01 2020   kindergarten 52 2 107 0   4     0   2   73 94 *                     167.0 52 2 107 0   4     0   2   73 94                 167
738920 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No 1 PK 02 2015   kindergarten 2 1 106 0   3     0   0   61 51                       112 2 1 106 0   3     0   0   61 51                 112
1675220 MA Essex   school 2506660 149   Lawrence 250666002815 1490011 Lawrence - Lawrence Family Public Academy   Regular School No Elementary PK KG 2021   kindergarten 2 1 106 0   2     0   1   60 52 *                     112.0 2 1 106 0   2     0   1   60 52                 112
2043105 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary PK 04 2019   kindergarten 2 2 105 0   0     0   0   62 47                       109.0 2 2 105 0   0     0   0   62 47                 109
2231445 MA Middlesex   school 2504770 93   Everett 250477002118 930015 Everett: Webster School   Regular School No Elementary PK 05 2018   kindergarten 40 25 105 0   3     0   1   96 78                       174.0 40 25 105 0   3     0   1   96 78                 174
935746 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 KG 04 2016   kindergarten 1 1 103 0   0     0   0   58 47                       105 1 1 103 0   0     0   0   58 47                 105
2043071 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2019   kindergarten 6 5 103 0   6     0   0   61 57                       120.0 6 5 103 0   6     0   0   61 57                 120
2232577 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 Lawrence: John Breen School   Regular School No Elementary PK KG 2018   kindergarten 7 2 102 0   5     0   0   54 62                       116.0 7 2 102 0   5     0   0   54 62                 116
1129051 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No Elementary PK 02 2017   kindergarten 69 2 101 0   2     0   0   84 90                       174 69 2 101 0   2     0   0   84 90                 174
1675745 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Lynn - Cobbet Elementary   Regular School No Elementary KG 05 2021   kindergarten 3 6 100 0   2     0   2   63 50 *                     113.0 3 6 100 0   2     0   2   63 50                 113
1675208 MA Essex   school 2506660 149   Lawrence 250666000730 1490003 Lawrence - John Breen School   Regular School No Elementary PK KG 2021   kindergarten 8 4 99 0   2     0   1   53 61 *                     114.0 8 4 99 0   2     0   1   53 61                 114
2231814 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham: Barbieri Elementary   Regular School No Elementary KG 05 2018   kindergarten 18 3 97 0   1     0   3   50 72                       122.0 18 3 97 0   1     0   3   50 72                 122
1125769 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2017   kindergarten 1 1 96 0   0     0   1   51 48                       99 1 1 96 0   0     0   1   51 48                 99
1125796 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2017   kindergarten 1 2 96 0   1     0   0   51 49                       100 1 2 96 0   1     0   0   51 49                 100
1372547 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2020   kindergarten 11 15 96 0   1     0   2   60 65 *                     125.0 11 15 96 0   1     0   2   60 65                 125
1367970 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2020   kindergarten 2 0 95 0   0     0   0   50 42 5                     97.0 2 0 95 0   0     0   0   50 42 5               97
2232586 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Lawrence: Community Day Arlington   Regular School No Elementary KG 04 2018   kindergarten 2 0 94 0   0     0   0   52 44                       96.0 2 0 94 0   0     0   0   52 44                 96
1367349 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2020   kindergarten 17 0 93 0   2     0   6   53 65 *                     118.0 17 0 93 0   2     0   6   53 65                 118
1367975 MA Essex   school 2506660 149   Lawrence 250666002815 1490011 Lawrence Family Public Academy   Regular School No Elementary PK KG 2020   kindergarten 2 0 93 0   1     0   0   45 50 *                     96.0 2 0 93 0   1     0   0   45 50                 96
1677991 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Southbridge - Eastford Road   Regular School No Elementary PK 01 2021   kindergarten 44 2 93 0   0     0   3   81 61 *                     142.0 44 2 93 0   0     0   3   81 61                 142
2042420 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2019   kindergarten 17 5 93 0   0     0   6   53 68                       121.0 17 5 93 0   0     0   6   53 68                 121
2043054 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2019   kindergarten 5 0 93 0   0     0   0   54 44                       98.0 5 0 93 0   0     0   0   54 44                 98
2047621 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2019   kindergarten 10 14 93 0   2     2   1   52 70                       122.0 10 14 93 0   2     2   1   52 70                 122
2235870 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Southbridge: Eastford Road   Regular School No Elementary PK 01 2018   kindergarten 65 5 93 0   1     0   2   68 98                       166.0 65 5 93 0   1     0   2   68 98                 166
741710 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No 1 PK 02 2015   kindergarten 80 3 92 1   3     0   3   100 82                       182 80 3 92 1   3     0   3   100 82                 182
741743 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No 1 PK 05 2015   kindergarten 5 13 92 0   6     0   2   72 46                       118 5 13 92 0   6     0   2   72 46                 118
935736 MA Essex   school 2506660 149   Lawrence 250666002651 1490001 Rollins Early Childhood Center   Regular School No 1 PK KG 2016   kindergarten 6 0 92 0   1     0   0   54 45                       99 6 0 92 0   1     0   0   54 45                 99
1674583 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Framingham - Barbieri Elementary   Regular School No Elementary KG 05 2021   kindergarten 16 4 92 0   1     0   3   68 48 *                     116.0 16 4 92 0   1     0   3   68 48                 116
741941 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No 1 PK 05 2015   kindergarten 3 16 91 0   1     0   0   60 51                       111 3 16 91 0   1     0   0   60 51                 111
935111 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No 1 KG 05 2016   kindergarten 20 3 91 0   0     0   4   67 51                       118 20 3 91 0   0     0   4   67 51                 118
741763 MA Hampden   school 2511130 281   Springfield 251113000896 2810023 Milton Bradley School   Regular School No 1 PK 05 2015   kindergarten 4 15 89 1   0     0   0   64 45                       109 4 15 89 1   0     0   0   64 45                 109
1679810 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   kindergarten 11 18 88 0   6     0   2   55 70 *                     125.0 11 18 88 0   6     0   2   55 70                 125
2043574 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No Elementary KG 05 2019   kindergarten 6 10 88 0   8     0   1   64 49                       113.0 6 10 88 0   8     0   1   64 49                 113
2232650 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Lawrence: Edward F. Parthum   Regular School No Elementary KG 04 2018   kindergarten 1 2 88 0   0     0   0   44 47                       91.0 1 2 88 0   0     0   0   44 47                 91
1125378 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Bartlett Kindergarten Center   Regular School No Elementary KG KG 2017   kindergarten 55 7 87 0   1     0   1   88 63                       151 55 7 87 0   1     0   1   88 63                 151
1125775 MA Essex   school 2506660 149   Lawrence 250666002815 1490011 Lawrence Family Public Academy   Regular School No Elementary PK KG 2017   kindergarten 4 3 87 0   1     0   1   56 40                       96 4 3 87 0   1     0   1   56 40                 96
1368503 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No Elementary KG 05 2020   kindergarten 3 9 87 0   3     0   3   60 45 *                     105.0 3 9 87 0   3     0   3   60 45                 105
1679797 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   kindergarten 9 77 87 0   3     2   7   88 97 *                     185.0 9 77 87 0   3     2   7   88 97                 185
1129116 MA Hampden   school 2511130 281   Springfield 251113000896 2810023 Milton Bradley School   Regular School No Elementary PK 05 2017   kindergarten 2 17 86 0   0     0   0   53 52                       105 2 17 86 0   0     0   0   53 52                 105
1675758 MA Essex   school 2507110 163   Lynn 250711001070 1630045 Lynn - E J Harrington   Regular School No Elementary PK 05 2021   kindergarten 13 8 86 0   2     0   1   51 59 *                     110.0 13 8 86 0   2     0   1   51 59                 110
940317 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2016   kindergarten 7 21 85 0   7     0   2   65 57                       122 7 21 85 0   7     0   2   65 57                 122
1125387 MA Essex   school 2505970 128   Haverhill 250597000851 1280020 Crowell   Regular School No Elementary KG KG 2017   kindergarten 53 6 85 1   1     0   4   80 70                       150 53 6 85 1   1     0   4   80 70                 150
1126388 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No Elementary KG 05 2017   kindergarten 8 8 85 0   7     0   3   53 58                       111 8 8 85 0   7     0   3   53 58                 111
1131211 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2017   kindergarten 7 22 85 2   2     0   4   57 65                       122 7 22 85 2   2     0   4   57 65                 122
2236141 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 Springfield: German Gerena Community School   Regular School No Elementary PK 05 2018   kindergarten 8 16 85 0   0     0   0   54 55                       109.0 8 16 85 0   0     0   0   54 55                 109
739429 MA Essex   school 2507110 163   Lynn 250711001068 1630035 Cobbet Elementary   Regular School No 1 KG 05 2015   kindergarten 4 13 84 0   9     0   2   63 49                       112 4 13 84 0   9     0   2   63 49                 112
935617 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No 1 KG 03 2016   kindergarten 1 4 84 0   0     0   1   44 46                       90 1 4 84 0   0     0   1   44 46                 90
1128521 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No Elementary PK 05 2017   kindergarten 38 1 84 0   9     0   2   69 65                       134 38 1 84 0   9     0   2   69 65                 134
1131398 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2017   kindergarten 0 0 84 0   0     0   0   38 46                       84 0 0 84 0   0     0   0   38 46                 84
2042315 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2019   kindergarten 28 5 84 0   3     0   8   68 60                       128.0 28 5 84 0   3     0   8   68 60                 128
741607 MA Middlesex   school 2510890 274   Somerville 251089002561 2740005 Capuano Early Childhood Center   Regular School No 1 PK KG 2015   kindergarten 28 3 83 0   16     0   2   77 55                       132 28 3 83 0   16     0   2   77 55                 132
1367987 MA Essex   school 2506660 149   Lawrence 250666002433 1490018 Robert Frost   Regular School No Elementary KG 04 2020   kindergarten 6 1 83 0   4     0   1   54 40 *                     95.0 6 1 83 0   4     0   1   54 40                 95
2042151 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   kindergarten 10 13 83 0   2     0   0   48 60                       108.0 10 13 83 0   2     0   0   48 60                 108
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
2046054 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2019   kindergarten 4 14 83 0   1     0   0   53 49                       102.0 4 14 83 0   1     0   0   53 49                 102
2233218 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Lynn: Wm P Connery   Regular School No Elementary PK 05 2018   kindergarten 5 5 83 0   11     0   2   56 50                       106.0 5 5 83 0   11     0   2   56 50                 106
2238230 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter (District): Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2018   kindergarten 1 1 83 0   0     0   0   39 46                       85.0 1 1 83 0   0     0   0   39 46                 85
1125833 MA Essex   school 2506660 149   Lawrence 250666001627 1490053 Edward F. Parthum   Regular School No Elementary KG 04 2017   kindergarten 7 0 82 0   0     0   0   52 37                       89 7 0 82 0   0     0   0   52 37                 89
2047796 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2019   kindergarten 1 1 82 0   0     0   0   39 45                       84.0 1 1 82 0   0     0   0   39 45                 84
2238040 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 2018   kindergarten 10 18 82 0   5     0   7   54 68                       122.0 10 18 82 0   5     0   7   54 68                 122
743115 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2015   kindergarten 8 10 81 0   9     0   5   60 53                       113 8 10 81 0   9     0   5   60 53                 113
1124985 MA Middlesex   school 2504980 100   Framingham 250498000727 1000035 Barbieri Elementary   Regular School No Elementary KG 05 2017   kindergarten 19 9 81 0   0     0   5   52 62                       114 19 9 81 0   0     0   5   52 62                 114
1368558 MA Essex   school 2507110 163   Lynn 250711001084 1630085 Sewell-Anderson   Regular School No Elementary KG 05 2020   kindergarten 13 8 81 0   4     0   2   60 48 *                     108.0 13 8 81 0   4     0   2   60 48                 108
1368958 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2020   kindergarten 45 4 81 0   1     0   0   71 60 *                     131.0 45 4 81 0   1     0   0   71 60                 131
738887 MA Essex   school 2506660 149   Lawrence 250666002651 1490001 Rollins Early Childhood Center   Regular School No 1 PK KG 2015   kindergarten 11 0 80 0   3     0   0   49 45                       94 11 0 80 0   3     0   0   49 45                 94
935768 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No 1 PK 02 2016   kindergarten 6 0 80 0   2     0   1   51 38                       89 6 0 80 0   2     0   1   51 38                 89
935784 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2016   kindergarten 3 1 80 0   0     0   0   49 35                       84 3 1 80 0   0     0   0   49 35                 84

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