Data source: Big Local News · About: Big Local

6,679 rows where grade = "grade_4" and state = "MA" sorted by multiracial_int descending

View and edit SQL

year

grade

  • grade_4 · 6,679
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
2042516 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2019   grade_4 127 2 34 1   0     0   28   113 79                       192.0 127 2 34 1   0     0   28   113 79                 192
2048312 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2019   grade_4 170 19 20 8   2     0   28   123 124                       247.0 170 19 20 8   2     0   28   123 124                 247
2236791 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Wareham: Minot Forest   Regular School No Elementary 03 04 2018   grade_4 139 20 13 2   3     0   26   90 113                       203.0 139 20 13 2   3     0   26   90 113                 203
1373250 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2020   grade_4 166 23 28 4   9     0   25   140 115 *                     255.0 166 23 28 4   9     0   25   140 115                 255
735968 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No 2 04 05 2015   grade_4 302 22 35 1   4     1   24   184 205                       389 302 22 35 1   4     1   24   184 205                 389
2046604 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No Elementary 03 04 2019   grade_4 127 20 17 2   1     1   24   103 89                       192.0 127 20 17 2   1     1   24   103 89                 192
2040118 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2019   grade_4 288 32 62 2   7     0   23   218 196                       414.0 288 32 62 2   7     0   23   218 196                 414
935207 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No 1 02 04 2016   grade_4 147 5 31 0   3     0   22   98 110                       208 147 5 31 0   3     0   22   98 110                 208
1672316 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable - Barnstable United Elementary School   Regular School No Elementary 04 05 2021   grade_4 212 24 71 0   11     0   22   175 164 *                     340.0 212 24 71 0   11     0   22   175 164                 340
1125100 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2017   grade_4 136 4 39 0   3     0   21   108 95                       203 136 4 39 0   3     0   21   108 95                 203
738352 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No 1 03 05 2015   grade_4 120 1 28 0   2     0   20   84 87                       171 120 1 28 0   2     0   20   84 87                 171
1365092 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2020   grade_4 265 29 74 1   5     0   20   208 186 *                     394.0 265 29 74 1   5     0   20   208 186                 394
1369235 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2020   grade_4 57 21 43 0   0     0   20   82 59 *                     141.0 57 21 43 0   0     0   20   82 59                 141
1680514 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth - Nathaniel H. Wixon School   Regular School No Elementary 04 05 2021   grade_4 148 25 20 8   5     2   20   130 98 *                     228.0 148 25 20 8   5     2   20   130 98                 228
2234082 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 New Bedford: Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2018   grade_4 48 33 48 0   3     0   20   81 71                       152.0 48 33 48 0   3     0   20   81 71                 152
1678782 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Wareham - Minot Forest   Regular School No Elementary 03 04 2021   grade_4 85 10 16 2   2     0   19   52 82 *                     134.0 85 10 16 2   2     0   19   52 82                 134
932842 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No 2 04 05 2016   grade_4 307 27 52 0   9     0   18   227 186                       413 307 27 52 0   9     0   18   227 186                 413
1131911 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No Elementary 04 06 2017   grade_4 238 11 13 2   3     2   18   139 148                       287 238 11 13 2   3     2   18   139 148                 287
1371530 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No Elementary 03 04 2020   grade_4 115 12 23 4   1     0   18   94 79 *                     173.0 115 12 23 4   1     0   18   94 79                 173
2041980 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2019   grade_4 167 0 4 0   3     0   18   100 92                       192.0 167 0 4 0   3     0   18   100 92                 192
2044090 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2019   grade_4 199 13 93 9   3     1   18   179 157                       336.0 199 13 93 9   3     1   18   179 157                 336
2238827 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 Dennis-Yarmouth: N H Wixon Innovation School   Regular School No Elementary 04 05 2018   grade_4 170 29 43 7   3     0   18   136 134                       270.0 170 29 43 7   3     0   18   136 134                 270
939282 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No 1 03 04 2016   grade_4 145 18 19 0   2     0   17   106 95                       201 145 18 19 0   2     0   17   106 95                 201
1368691 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Jordan/Jackson Elementary   Regular School No Elementary 03 05 2020   grade_4 194 10 20 0   27     0   17   152 116 *                     268.0 194 10 20 0   27     0   17   152 116                 268
1369133 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2020   grade_4 85 3 5 0   8     0   17   52 66 *                     118.0 85 3 5 0   8     0   17   52 66                 118
2231551 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Fall River: Mary Fonseca Elementary School   Regular School No Elementary PK 05 2018   grade_4 42 16 39 0   10     0   17   59 65                       124.0 42 16 39 0   10     0   17   59 65                 124
934070 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2016   grade_4 34 4 8 0   10     0   16   36 36                       72 34 4 8 0   10     0   16   36 36                 72
1124725 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2017   grade_4 66 12 42 1   8     0   16   70 75                       145 66 12 42 1   8     0   16   70 75                 145
1127264 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2017   grade_4 47 31 34 0   0     0   16   68 60                       128 47 31 34 0   0     0   16   68 60                 128
1365107 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2020   grade_4 120 12 14 0   40     0   16   104 98 *                     202.0 120 12 14 0   40     0   16   104 98                 202
2229125 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable: Barnstable United Elementary School   Regular School No Elementary 04 05 2018   grade_4 311 22 63 3   8     1   16   227 197                       424.0 311 22 63 3   8     1   16   227 197                 424
2231929 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Gardner: Elm Street School   Regular School No Elementary 02 04 2018   grade_4 127 2 36 0   4     0   16   107 78                       185.0 127 2 36 0   4     0   16   107 78                 185
742475 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No 1 03 04 2015   grade_4 176 14 12 3   0     0   15   108 112                       220 176 14 12 3   0     0   15   108 112                 220
1122319 MA Barnstable   school 2502310 20   Barnstable 250231002748 200050 Barnstable United Elementary School   Regular School No Elementary 04 05 2017   grade_4 343 27 49 0   9     3   15   217 229                       446 343 27 49 0   9     3   15   217 229                 446
1366999 MA Bristol   school 2504620 88   Easton 250462000983 880025 Richardson Olmsted School   Regular School No Elementary 03 05 2020   grade_4 211 17 16 2   6     0   15   147 120 *                     267.0 211 17 16 2   6     0   15   147 120                 267
1369019 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2020   grade_4 204 11 105 1   8     0   15   177 167 *                     344.0 204 11 105 1   8     0   15   177 167                 344
1672396 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont - Roger E Wellington   Regular School No Elementary PK 04 2021   grade_4 78 1 0 0   23     0   15   62 55 *                     117.0 78 1 0 0   23     0   15   62 55                 117
1124770 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2017   grade_4 86 4 24 0   3     0   14   56 75                       131 86 4 24 0   3     0   14   56 75                 131
1127008 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No Elementary 03 05 2017   grade_4 192 8 100 13   4     0   14   175 156                       331 192 8 100 13   4     0   14   175 156                 331
1127026 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No Elementary 04 06 2017   grade_4 119 3 13 0   5     0   14   84 70                       154 119 3 13 0   5     0   14   84 70                 154
1127309 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   grade_4 52 13 58 0   1     0   14   72 66                       138 52 13 58 0   1     0   14   72 66                 138
1129976 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No Elementary 03 04 2017   grade_4 159 12 7 2   4     0   14   114 84                       198 159 12 7 2   4     0   14   114 84                 198
1131996 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No Elementary 04 05 2017   grade_4 193 20 29 6   10     0   14   141 131                       272 193 20 29 6   10     0   14   141 131                 272
1365019 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2020   grade_4 41 9 11 0   8     0   14   40 43 *                     83.0 41 9 11 0   8     0   14   40 43                 83
1367445 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2020   grade_4 107 8 53 0   7     0   14   88 101 *                     189.0 107 8 53 0   7     0   14   88 101                 189
1367884 MA Middlesex   school 2506330 139   Hopkinton 250633001180 1390015 Hopkins Elementary School   Regular School No Elementary 04 05 2020   grade_4 190 1 11 1   70     0   14   141 146 *                     287.0 190 1 11 1   70     0   14   141 146                 287
1368704 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 03 06 2020   grade_4 166 6 18 0   0     0   14   107 97 *                     204.0 166 6 18 0   0     0   14   107 97                 204
1371179 MA Middlesex   school 2511340 288   Sudbury 251134001877 2880030 Peter Noyes   Regular School No Elementary PK 05 2020   grade_4 68 2 2 0   4     0   14   54 36 *                     90.0 68 2 2 0   4     0   14   54 36                 90
1674483 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Fitchburg - Crocker Elementary   Regular School No Elementary PK 04 2021   grade_4 36 1 69 0   3     0   14   71 52 *                     123.0 36 1 69 0   3     0   14   71 52                 123
1678933 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Westborough - Mill Pond School   Regular School No Middle 04 06 2021   grade_4 129 5 30 1   118     0   14   145 152 *                     297.0 129 5 30 1   118     0   14   145 152                 297
2043260 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No Elementary KG 05 2019   grade_4 43 5 2 0   35     0   14   52 47                       99.0 43 5 2 0   35     0   14   52 47                 99
2230606 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline: Pierce   Regular School No Elementary KG 08 2018   grade_4 63 3 10 0   24     0   14   50 64                       114.0 63 3 10 0   24     0   14   50 64                 114
2232470 MA Middlesex   school 2506330 139   Hopkinton 250633001180 1390015 Hopkinton: Hopkins Elementary School   Regular School No Elementary 04 05 2018   grade_4 196 2 11 1   38     0   14   139 123                       262.0 196 2 11 1   38     0   14   139 123                 262
2233783 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Middleborough: Henry B. Burkland Elementary School   Regular School No Elementary 01 05 2018   grade_4 101 2 4 0   0     0   14   53 68                       121.0 101 2 4 0   0     0   14   53 68                 121
736407 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No 1 PK 05 2015   grade_4 0 38 57 0   1     0   13   50 59                       109 0 38 57 0   1     0   13   50 59                 109
739615 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Jordan/Jackson Elementary   Regular School No 1 03 05 2015   grade_4 269 6 14 0   8     0   13   169 141                       310 269 6 14 0   8     0   13   169 141                 310
934901 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No 1 KG 05 2016   grade_4 52 10 36 0   7     0   13   61 57                       118 52 10 36 0   7     0   13   61 57                 118
940954 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No 2 04 06 2016   grade_4 207 5 7 0   0     0   13   135 97                       232 207 5 7 0   0     0   13   135 97                 232
1124902 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2017   grade_4 19 2 28 0   8     0   13   34 36                       70 19 2 28 0   8     0   13   34 36                 70
1365174 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2020   grade_4 84 1 3 0   12     0   13   61 52 *                     113.0 84 1 3 0   12     0   13   61 52                 113
1367119 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2020   grade_4 84 6 29 0   3     0   13   71 64 *                     135.0 84 6 29 0   3     0   13   71 64                 135
1367125 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2020   grade_4 60 13 46 0   6     0   13   64 74 *                     138.0 60 13 46 0   6     0   13   64 74                 138
1367166 MA Bristol   school 2504830 95   Fall River 250483000684 950065 William S Greene   Regular School No Elementary PK 05 2020   grade_4 67 5 30 0   9     0   13   62 62 *                     124.0 67 5 30 0   9     0   13   62 62                 124
1373180 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Williams Intermediate School   Regular School No Middle 04 06 2020   grade_4 187 9 2 0   4     0   13   107 108 *                     215.0 187 9 2 0   4     0   13   107 108                 215
1672331 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Bedford - Lt Job Lane School   Regular School No Elementary 03 05 2021   grade_4 117 15 13 0   33     0   13   93 98 *                     191.0 117 15 13 0   33     0   13   93 98                 191
1674363 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Fall River - Mary Fonseca Elementary School   Regular School No Elementary PK 05 2021   grade_4 38 11 43 0   4     0   13   66 43 *                     109.0 38 11 43 0   4     0   13   66 43                 109
1674404 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Fall River - Spencer Borden   Regular School No Elementary PK 05 2021   grade_4 52 9 16 0   3     0   13   48 45 *                     93.0 52 9 16 0   3     0   13   48 45                 93
1677214 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Pittsfield - Morningside Community School   Regular School No Elementary PK 05 2021   grade_4 19 6 10 0   0     0   13   30 18 *                     48.0 19 6 10 0   0     0   13   30 18                 48
1680068 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   grade_4 52 22 16 0   20     0   13   68 55 *                     123.0 52 22 16 0   20     0   13   68 55                 123
2041349 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2019   grade_4 56 5 9 0   10     0   13   43 50                       93.0 56 5 9 0   10     0   13   43 50                 93
2042192 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2019   grade_4 74 13 31 0   2     0   13   75 58                       133.0 74 13 31 0   2     0   13   75 58                 133
2042205 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary PK 05 2019   grade_4 43 8 38 1   5     0   13   53 55                       108.0 43 8 38 1   5     0   13   53 55                 108
2043220 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No Elementary KG 05 2019   grade_4 56 3 50 0   3     0   13   55 70                       125.0 56 3 50 0   3     0   13   55 70                 125
2229695 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston: Joseph Lee   Regular School No Elementary PK 08 2018   grade_4 4 35 28 0   5     0   13   38 47                       85.0 4 35 28 0   5     0   13   38 47                 85
2231718 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 Fitchburg: South Street Elementary   Regular School No Elementary PK 04 2018   grade_4 36 8 74 0   8     0   13   64 75                       139.0 36 8 74 0   8     0   13   64 75                 139
737094 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2015   grade_4 15 82 13 1   0     1   12   59 65                       124 15 82 13 1   0     1   12   59 65                 124
737200 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2015   grade_4 43 5 7 0   7     0   12   45 29                       74 43 5 7 0   7     0   12   45 29                 74
738049 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No 1 KG 05 2015   grade_4 69 12 26 0   9     0   12   64 64                       128 69 12 26 0   9     0   12   64 64                 128
739951 MA Worcester   school 2507860 185   Milford 250786001244 1850090 Woodland   Regular School No 1 03 04 2015   grade_4 230 13 79 4   7     0   12   172 173                       345 230 13 79 4   7     0   12   172 173                 345
742631 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Mill Pond School   Regular School No 2 04 06 2015   grade_4 150 2 12 0   66     0   12   131 111                       242 150 2 12 0   66     0   12   131 111                 242
933276 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No 1 PK 05 2016   grade_4 0 39 58 0   1     0   12   56 54                       110 0 39 58 0   1     0   12   56 54                 110
933984 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No 1 KG 05 2016   grade_4 60 85 25 2   12     0   12   103 93                       196 60 85 25 2   12     0   12   103 93                 196
934686 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No 1 03 05 2016   grade_4 215 1 3 0   5     0   12   116 120                       236 215 1 3 0   5     0   12   116 120                 236
934889 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2016   grade_4 74 8 19 0   7     0   12   62 58                       120 74 8 19 0   7     0   12   62 58                 120
941022 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414002803 6450050 N H Wixon Innovation School   Regular School No 2 04 05 2016   grade_4 174 20 32 6   4     1   12   115 134                       249 174 20 32 6   4     1   12   115 134                 249
1122418 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2017   grade_4 80 6 4 0   17     0   12   69 50                       119 80 6 4 0   17     0   12   69 50                 119
1122834 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No Elementary PK 05 2017   grade_4 2 45 65 0   5     0   12   68 61                       129 2 45 65 0   5     0   12   68 61                 129
1124718 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2017   grade_4 80 11 22 0   5     1   12   65 66                       131 80 11 22 0   5     1   12   65 66                 131
1126740 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   grade_4 106 3 2 8   3     0   12   65 69                       134 106 3 2 8   3     0   12   65 69                 134
1130061 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No Elementary PK 04 2017   grade_4 88 7 42 1   6     0   12   75 81                       156 88 7 42 1   6     0   12   75 81                 156
1130325 MA Middlesex   school 2512750 330   Weston 251275000785 3300012 Field Elementary School   Regular School No Elementary 04 05 2017   grade_4 121 18 11 0   28     0   12   105 85                       190 121 18 11 0   28     0   12   105 85                 190
1365163 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Mary Lee Burbank   Regular School No Elementary KG 04 2020   grade_4 42 9 4 0   20     0   12   43 44 *                     87.0 42 9 4 0   20     0   12   43 44                 87
1372676 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_4 35 86 5 2   12     0   12   71 81 *                     152.0 35 86 5 2   12     0   12   71 81                 152
1672385 MA Middlesex   school 2502490 26   Belmont 250249000146 260010 Belmont - Mary Lee Burbank   Regular School No Elementary KG 04 2021   grade_4 50 4 0 0   17     1   12   47 37 *                     84.0 50 4 0 0   17     1   12   47 37                 84
1674350 MA Bristol   school 2504830 95   Fall River 250483001780 950005 Fall River - North End Elementary   Regular School No Elementary PK 05 2021   grade_4 60 12 32 1   0     0   12   61 56 *                     117.0 60 12 32 1   0     0   12   61 56                 117
1674463 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth - Mullen-Hall   Regular School No Elementary KG 04 2021   grade_4 55 2 8 2   0     0   12   45 34 *                     79.0 55 2 8 2   0     0   12   45 34                 79
1674489 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Fitchburg - Reingold Elementary   Regular School No Elementary PK 04 2021   grade_4 36 5 71 0   5     0   12   76 53 *                     129.0 36 5 71 0   5     0   12   76 53                 129
1675932 MA Bristol   school 2507230 167   Mansfield 250723001365 1670014 Mansfield - Jordan/Jackson Elementary   Regular School No Elementary 03 05 2021   grade_4 183 15 11 0   22     0   12   118 125 *                     243.0 183 15 11 0   22     0   12   118 125                 243
1676329 MA Norfolk   school 2507980 189   Milton 250798001263 1890020 Milton - Tucker   Regular School No Elementary PK 05 2021   grade_4 19 36 3 0   8     0   12   32 46 *                     78.0 19 36 3 0   8     0   12   32 46                 78
2041359 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2019   grade_4 54 2 4 0   5     0   12   40 37                       77.0 54 2 4 0   5     0   12   40 37                 77

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