Data source: Big Local News · About: Big Local

6,747 rows where grade = "kindergarten" and state = "MA" sorted by multiracial_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
742470 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2015   kindergarten 175 19 11 3   2     0   28   129 109                       238 175 19 11 3   2     0   28   129 109                 238
1371525 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2020   kindergarten 138 11 16 3   2     0   28   96 102 *                     198.0 138 11 16 3   2     0   28   96 102                 198
939277 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2016   kindergarten 165 11 12 1   0     0   27   120 96                       216 165 11 12 1   0     0   27   120 96                 216
2236785 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 Wareham: John William Decas   Regular School No Elementary KG 02 2018   kindergarten 160 15 17 4   2     0   24   119 103                       222.0 160 15 17 4   2     0   24   119 103                 222
737077 MA Plymouth   school 2503090 44   Brockton 250309002792 440007 Barrett Russell School   Regular School No 1 KG KG 2015   kindergarten 52 123 32 3   3     0   23   129 107                       236 52 123 32 3   3     0   23   129 107                 236
738357 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 02 2015   kindergarten 149 7 25 1   0     0   22   113 91                       204 149 7 25 1   0     0   22   113 91                 204
1129970 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary KG 02 2017   kindergarten 128 10 11 1   1     0   22   75 98                       173 128 10 11 1   1     0   22   75 98                 173
1679923 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   kindergarten 16 60 7 4   8     0   22   49 68 *                     117.0 16 60 7 4   8     0   22   49 68                 117
932919 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No 1 PK 04 2016   kindergarten 74 1 1 0   9     0   21   61 45                       106 74 1 1 0   9     0   21   61 45                 106
1674047 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Dedham - Early Childhood Center   Regular School No Elementary PK KG 2021   kindergarten 140 10 30 0   1     0   21   104 97 *                     202.0 140 10 30 0   1     0   21   104 97                 202
2046600 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2019   kindergarten 116 12 15 2   3     0   21   88 81                       169.0 116 12 15 2   3     0   21   88 81                 169
1366818 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No Elementary PK KG 2020   kindergarten 156 12 35 0   6     0   20   123 106 *                     229.0 156 12 35 0   6     0   20   123 106                 229
1123598 MA Plymouth   school 2503090 44   Brockton 250309002792 440007 Barrett Russell School   Regular School No Elementary KG KG 2017   kindergarten 24 129 42 1   4     0   19   117 102                       219 24 129 42 1   4     0   19   117 102                 219
1123577 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary KG 05 2017   kindergarten 12 59 22 0   0     0   18   65 46                       111 12 59 22 0   0     0   18   65 46                 111
1124728 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary KG 05 2017   kindergarten 47 8 52 0   4     0   18   76 53                       129 47 8 52 0   4     0   18   76 53                 129
1676807 MA Essex   school 2508700 211   North Andover 250870002883 2110005 North Andover - Anne Bradstreet Early Childhood Center   Regular School No Elementary PK KG 2021   kindergarten 190 7 42 1   25     0   18   152 131 *                     283.0 190 7 42 1   25     0   18   152 131                 283
2229137 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford: Lt Elezer Davis   Regular School No Elementary KG 02 2018   kindergarten 116 12 9 0   42     0   18   88 109                       197.0 116 12 9 0   42     0   18   88 109                 197
738045 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No 1 KG 05 2015   kindergarten 61 9 40 0   7     0   17   59 75                       134 61 9 40 0   7     0   17   59 75                 134
935208 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 01 2016   kindergarten 120 5 26 0   4     0   17   76 96                       172 120 5 26 0   4     0   17   76 96                 172
2231592 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Fall River: Spencer Borden   Regular School No Elementary KG 05 2018   kindergarten 48 11 21 0   6     0   17   49 54                       103.0 48 11 21 0   6     0   17   49 54                 103
932852 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2016   kindergarten 121 12 15 0   26     0   16   99 91                       190 121 12 15 0   26     0   16   99 91                 190
937009 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2016   kindergarten 52 22 32 0   0     0   16   77 45                       122 52 22 32 0   0     0   16   77 45                 122
937763 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No 1 PK 05 2016   kindergarten 30 11 12 0   0     0   16   43 26                       69 30 11 12 0   0     0   16   43 26                 69
1125102 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2017   kindergarten 139 1 37 0   1     0   16   86 108                       194 139 1 37 0   1     0   16   86 108                 194
1672326 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford - Lt Elezer Davis   Regular School No Elementary PK 02 2021   kindergarten 80 6 14 0   44     0   16   86 74 *                     160.0 80 6 14 0   44     0   16   86 74                 160
1673518 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline - Michael Driscoll   Regular School No Elementary KG 08 2021   kindergarten 21 2 7 0   3     0   16   30 19 *                     49.0 21 2 7 0   3     0   16   30 19                 49
1678777 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 Wareham - John William Decas   Regular School No Elementary PK 02 2021   kindergarten 123 8 14 0   2     0   16   69 94 *                     163.0 123 8 14 0   2     0   16   69 94                 163
1680433 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Bridgewater-Raynham - Mitchell Elementary School   Regular School No Elementary PK 03 2021   kindergarten 187 17 15 0   6     0   16   120 121 *                     241.0 187 17 15 0   6     0   16   120 121                 241
2042518 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2019   kindergarten 115 3 39 0   0     0   16   102 71                       173.0 115 3 39 0   0     0   16   102 71                 173
2044634 MA Essex   school 2508700 211   North Andover 250870002883 2110005 Anne Bradstreet Early Childhood Center   Regular School No Elementary PK KG 2019   kindergarten 255 8 38 0   26     0   16   168 175                       343.0 255 8 38 0   26     0   16   168 175                 343
2047096 MA Middlesex   school 2513110 344   Winchester 251311002166 3440020 Lynch Elementary   Regular School No Elementary PK 05 2019   kindergarten 45 1 5 0   22     0   16   49 40                       89.0 45 1 5 0   22     0   16   49 40                 89
2236488 MA Bristol   school 2511520 293   Taunton 251152001907 2930027 Taunton: Elizabeth Pole   Regular School No Elementary KG 04 2018   kindergarten 61 26 17 0   1     0   16   66 55                       121.0 61 26 17 0   1     0   16   66 55                 121
735960 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   kindergarten 32 11 19 1   3     0   15   46 35                       81 32 11 19 1   3     0   15   46 35                 81
738032 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2015   kindergarten 68 8 23 0   3     0   15   70 47                       117 68 8 23 0   3     0   15   70 47                 117
934594 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No 1 PK KG 2016   kindergarten 135 8 19 0   5     0   15   87 95                       182 135 8 19 0   5     0   15   87 95                 182
939606 MA Hampden   school 2512510 332   West Springfield 251251002504 3320005 John Ashley   Regular School No 1 KG KG 2016   kindergarten 173 7 33 0   8     0   15   119 117                       236 173 7 33 0   8     0   15   119 117                 236
1122331 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2017   kindergarten 130 5 12 0   30     0   15   98 94                       192 130 5 12 0   30     0   15   98 94                 192
1124867 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2017   kindergarten 41 3 57 0   3     0   15   64 55                       119 41 3 57 0   3     0   15   64 55                 119
1371836 MA Hampden   school 2512510 332   West Springfield 251251002504 3320005 John Ashley   Regular School No Elementary KG KG 2020   kindergarten 134 9 58 0   17     0   15   113 120 *                     233.0 134 9 58 0   17     0   15   113 120                 233
1674352 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Fall River - Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2021   kindergarten 44 5 32 0   4     0   15   50 50 *                     100.0 44 5 32 0   4     0   15   50 50                 100
1674372 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River - Henry Lord Community School   Regular School No Elementary PK 08 2021   kindergarten 32 5 22 0   1     0   15   37 38 *                     75.0 32 5 22 0   1     0   15   37 38                 75
2040128 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   kindergarten 106 12 11 0   47     0   15   110 81                       191.0 106 12 11 0   47     0   15   110 81                 191
2041889 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No Elementary PK KG 2019   kindergarten 144 7 29 0   6     0   15   104 97                       201.0 144 7 29 0   6     0   15   104 97                 201
2042194 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2019   kindergarten 44 14 34 0   5     0   15   50 62                       112.0 44 14 34 0   5     0   15   50 62                 112
2042235 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2019   kindergarten 44 10 39 0   4     0   15   58 54                       112.0 44 10 39 0   4     0   15   58 54                 112
2042960 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Marathon Elementary School   Regular School No Elementary KG 01 2019   kindergarten 175 0 14 0   56     0   15   125 135                       260.0 175 0 14 0   56     0   15   125 135                 260
2043753 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2019   kindergarten 172 9 12 0   14     0   15   116 106                       222.0 172 9 12 0   14     0   15   116 106                 222
2043863 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   kindergarten 60 3 15 3   1     0   15   52 45                       97.0 60 3 15 3   1     0   15   52 45                 97
2046672 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No Elementary PK 04 2019   kindergarten 76 12 44 0   4     0   15   74 77                       151.0 76 12 44 0   4     0   15   74 77                 151
2231531 MA Bristol   school 2504830 95   Fall River 250483001780 950005 Fall River: North End Elementary   Regular School No Elementary PK 05 2018   kindergarten 60 6 18 0   4     0   15   54 49                       103.0 60 6 18 0   4     0   15   54 49                 103
2232844 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Lexington: Joseph Estabrook   Regular School No Elementary KG 05 2018   kindergarten 33 3 2 0   30     0   15   47 36                       83.0 33 3 2 0   30     0   15   47 36                 83
2233552 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee: Kenneth Coombs School   Regular School No Elementary PK 02 2018   kindergarten 86 3 6 9   3     0   15   73 49                       122.0 86 3 6 9   3     0   15   73 49                 122
737196 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2015   kindergarten 71 4 7 0   15     0   14   53 58                       111 71 4 7 0   15     0   14   53 58                 111
737834 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No 1 PK 02 2015   kindergarten 145 0 0 0   3     0   14   90 72                       162 145 0 0 0   3     0   14   90 72                 162
738173 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No 1 PK 04 2015   kindergarten 44 3 58 0   7     0   14   60 66                       126 44 3 58 0   7     0   14   60 66                 126
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
742455 MA Hampshire   school 2512030 309   Ware 251203001982 3090020 Stanley M Koziol Elementary School   Regular School No 1 PK 03 2015   kindergarten 72 0 4 0   0     0   14   44 46                       90 72 0 4 0   0     0   14   44 46                 90
935515 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No 1 PK 03 2016   kindergarten 70 15 8 0   3     1   14   62 49                       111 70 15 8 0   3     1   14   62 49                 111
936907 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No 1 KG 04 2016   kindergarten 90 2 5 0   11     0   14   52 70                       122 90 2 5 0   11     0   14   52 70                 122
941018 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No 1 KG 03 2016   kindergarten 93 3 10 2   2     0   14   66 58                       124 93 3 10 2   2     0   14   66 58                 124
1124365 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No Elementary PK KG 2017   kindergarten 125 12 32 1   3     0   14   100 87                       187 125 12 32 1   3     0   14   100 87                 187
1364967 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 M Norcross Stratton   Regular School No Elementary KG 05 2020   kindergarten 41 4 9 0   16     0   14   39 45 *                     84.0 41 4 9 0   16     0   14   39 45                 84
1371644 MA Norfolk   school 2512270 317   Wellesley 251227001733 3170048 Sprague Elementary School   Regular School No Elementary KG 05 2020   kindergarten 24 0 5 0   7     0   14   25 25 *                     50.0 24 0 5 0   7     0   14   25 25                 50
1674392 MA Bristol   school 2504830 95   Fall River 250483000684 950065 Fall River - William S Greene   Regular School No Elementary PK 05 2021   kindergarten 28 5 26 0   4     0   14   36 41 *                     77.0 28 5 26 0   4     0   14   36 41                 77
1675125 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Hopkinton - Marathon Elementary School   Regular School No Elementary KG 01 2021   kindergarten 164 1 10 2   79     0   14   145 125 *                     270.0 164 1 10 2   79     0   14   145 125                 270
1680064 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District) - Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2021   kindergarten 54 20 18 1   55     0   14   79 83 *                     162.0 54 20 18 1   55     0   14   79 83                 162
2230602 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline: Pierce   Regular School No Elementary KG 08 2018   kindergarten 47 4 8 0   35     0   14   63 45                       108.0 47 4 8 0   35     0   14   63 45                 108
2230705 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Cambridge: Martin Luther King Jr.   Regular School No Elementary PK 05 2018   kindergarten 18 9 1 0   20     0   14   33 29                       62.0 18 9 1 0   20     0   14   33 29                 62
737205 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2015   kindergarten 43 2 4 0   6     0   13   36 32                       68 43 2 4 0   6     0   13   36 32                 68
738164 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2015   kindergarten 50 5 53 0   6     0   13   63 64                       127 50 5 53 0   6     0   13   63 64                 127
739077 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Southeast School   Regular School No 1 KG 05 2015   kindergarten 51 10 38 0   3     0   13   64 51                       115 51 10 38 0   3     0   13   64 51                 115
740935 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No 1 PK 05 2015   kindergarten 37 20 18 2   0     0   13   51 39                       90 37 20 18 2   0     0   13   51 39                 90
934891 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No 1 KG 05 2016   kindergarten 62 7 35 1   6     0   13   69 55                       124 62 7 35 1   6     0   13   69 55                 124
936456 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No 1 KG 02 2016   kindergarten 175 3 19 0   20     0   13   135 95                       230 175 3 19 0   20     0   13   135 95                 230
1131481 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2017   kindergarten 57 17 20 0   17     0   13   63 61                       124 57 17 20 0   17     0   13   63 61                 124
1364930 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 John A Bishop   Regular School No Elementary KG 05 2020   kindergarten 44 3 3 0   8     0   13   35 36 *                     71.0 44 3 3 0   8     0   13   35 36                 71
1366411 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2020   kindergarten 14 7 2 0   25     0   13   30 31 *                     61.0 14 7 2 0   25     0   13   30 31                 61
1367367 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2020   kindergarten 24 11 22 0   4     0   13   36 38 *                     74.0 24 11 22 0   4     0   13   36 38                 74
1367880 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Marathon Elementary School   Regular School No Elementary KG 01 2020   kindergarten 160 2 14 0   79     0   13   144 124 *                     268.0 160 2 14 0   79     0   13   144 124                 268
1368635 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   kindergarten 26 12 11 0   39     0   13   58 43 *                     101.0 26 12 11 0   39     0   13   58 43                 101
1672312 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable - West Villages Elementary School   Regular School No Elementary KG 03 2021   kindergarten 58 4 13 0   0     0   13   46 42 *                     88.0 58 4 13 0   0     0   13   46 42                 88
1673717 MA Norfolk   school 2503300 50   Canton 250330000455 500012 Canton - Lt Peter M Hansen   Regular School No Elementary KG 05 2021   kindergarten 48 4 8 0   9     0   13   50 32 *                     82.0 48 4 8 0   9     0   13   50 32                 82
1677937 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 Somerville - West Somerville Neighborhood   Regular School No Elementary PK 08 2021   kindergarten 23 1 5 0   4     0   13   26 20 *                     46.0 23 1 5 0   4     0   13   26 20                 46
1678526 MA Bristol   school 2511520 293   Taunton 251152002697 2930015 Taunton - Mulcahey Elementary School   Regular School No Elementary PK 04 2021   kindergarten 75 21 22 0   1     1   13   72 61 *                     133.0 75 21 22 0   1     1   13   72 61                 133
1680438 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002102 6250020 Bridgewater-Raynham - Merrill Elementary School   Regular School No Elementary KG 01 2021   kindergarten 103 17 9 0   3     0   13   80 65 *                     145.0 103 17 9 0   3     0   13   80 65                 145
2039963 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2019   kindergarten 77 0 4 0   7     0   13   54 47                       101.0 77 0 4 0   7     0   13   54 47                 101
2039988 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2019   kindergarten 53 3 9 0   11     0   13   50 39                       89.0 53 3 9 0   11     0   13   50 39                 89
2041489 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2019   kindergarten 28 8 6 0   5     0   13   31 29                       60.0 28 8 6 0   5     0   13   31 29                 60
2046625 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No Elementary PK 05 2019   kindergarten 65 4 22 0   12     0   13   61 55                       116.0 65 4 22 0   12     0   13   61 55                 116
2229115 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable: Hyannis West Elementary   Regular School No Elementary KG 03 2018   kindergarten 30 9 24 0   3     0   13   49 30                       79.0 30 9 24 0   3     0   13   49 30                 79
2232340 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Holliston: Placentino Elementary   Regular School No Elementary PK 02 2018   kindergarten 157 1 13 0   16     0   13   105 95                       200.0 157 1 13 0   16     0   13   105 95                 200
2233421 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Mansfield: Everett W Robinson   Regular School No Elementary KG 02 2018   kindergarten 176 5 8 0   21     0   13   121 102                       223.0 176 5 8 0   21     0   13   121 102                 223
2234973 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Pittsfield: Silvio O Conte Community   Regular School No Elementary PK 05 2018   kindergarten 29 11 18 0   1     0   13   33 39                       72.0 29 11 18 0   1     0   13   33 39                 72
2235680 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Shrewsbury: Beal School   Regular School No Elementary KG 01 2018   kindergarten 108 11 22 5   95     0   13   128 126                       254.0 108 11 22 5   95     0   13   128 126                 254
738039 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No 1 KG 05 2015   kindergarten 72 5 35 0   2     0   12   63 63                       126 72 5 35 0   2     0   12   63 63                 126
739611 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No 1 KG 02 2015   kindergarten 192 6 4 0   7     0   12   115 106                       221 192 6 4 0   7     0   12   115 106                 221
741546 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No 1 KG 01 2015   kindergarten 115 5 21 1   71     0   12   114 111                       225 115 5 21 1   71     0   12   114 111                 225
743746 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2015   kindergarten 67 28 6 1   14     0   12   65 63                       128 67 28 6 1   14     0   12   65 63                 128
932767 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No 1 KG 04 2016   kindergarten 44 4 9 0   7     0   12   37 39                       76 44 4 9 0   7     0   12   37 39                 76
933926 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   kindergarten 28 81 13 3   0     0   12   79 58                       137 28 81 13 3   0     0   12   79 58                 137

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