Data source: Big Local News · About: Big Local

6,880 rows where grade = "grade_1" and state = "MA" sorted by multiracial_int descending

View and edit SQL

year

grade

  • grade_1 · 6,880
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
1678779 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 Wareham - John William Decas   Regular School No Elementary PK 02 2021   grade_1 124 7 18 3   1     0   31   91 93 *                     184.0 124 7 18 3   1     0   31   91 93                 184
1129971 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary KG 02 2017   grade_1 156 10 15 2   2     0   30   115 100                       215 156 10 15 2   2     0   30   115 100                 215
935210 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 01 2016   grade_1 137 7 26 1   0     0   26   106 91                       197 137 7 26 1   0     0   26   106 91                 197
939278 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2016   grade_1 166 18 14 1   2     0   26   124 103                       227 166 18 14 1   2     0   26   124 103                 227
742471 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2015   grade_1 169 20 8 6   2     0   23   101 127                       228 169 20 8 6   2     0   23   101 127                 228
1371527 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2020   grade_1 109 11 14 2   2     0   23   84 77 *                     161.0 109 11 14 2   2     0   23   84 77                 161
2046601 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2019   grade_1 136 17 21 3   1     0   21   107 92                       199.0 136 17 21 3   1     0   21   107 92                 199
2040129 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   grade_1 121 13 8 0   50     0   19   92 119                       211.0 121 13 8 0   50     0   19   92 119                 211
736404 MA Suffolk   school 2502790 35   Boston 250279000268 350167 UP Academy Holland   Regular School No 1 PK 05 2015   grade_1 1 66 51 1   4     0   18   79 62                       141 1 66 51 1   4     0   18   79 62                 141
1122415 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Roger E Wellington   Regular School No Elementary PK 04 2017   grade_1 76 4 2 0   10     0   18   62 48                       110 76 4 2 0   10     0   18   62 48                 110
1367881 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Marathon Elementary School   Regular School No Elementary KG 01 2020   grade_1 181 0 17 0   79     0   18   146 149 *                     295.0 181 0 17 0   79     0   18   146 149                 295
2230396 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Brockton: Dr W Arnone Community School   Regular School No Elementary KG 05 2018   grade_1 13 75 20 0   0     0   18   69 57                       126.0 13 75 20 0   0     0   18   69 57                 126
1125104 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2017   grade_1 118 6 35 1   4     0   17   80 101                       181 118 6 35 1   4     0   17   80 101                 181
1367448 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2020   grade_1 102 3 38 0   0     0   17   96 64 *                     160.0 102 3 38 0   0     0   17   96 64                 160
2046351 MA Bristol   school 2511520 293   Taunton 251152001907 2930027 Elizabeth Pole   Regular School No Elementary KG 04 2019   grade_1 51 30 16 0   1     0   17   67 48                       115.0 51 30 16 0   1     0   17   67 48                 115
2236786 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 Wareham: John William Decas   Regular School No Elementary KG 02 2018   grade_1 116 12 12 1   1     0   17   69 90                       159.0 116 12 12 1   1     0   17   69 90                 159
738046 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No 1 KG 05 2015   grade_1 67 15 43 1   8     0   16   72 78                       150 67 15 43 1   8     0   16   72 78                 150
739915 MA Plymouth   school 2507770 182   Middleborough 250777001223 1820008 Henry B. Burkland Elementary School   Regular School No 1 01 05 2015   grade_1 103 0 2 0   0     0   16   53 68                       121 103 0 2 0   0     0   16   53 68                 121
740167 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2015   grade_1 52 31 39 1   3     1   16   77 66                       143 52 31 39 1   3     1   16   77 66                 143
934892 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No 1 KG 05 2016   grade_1 68 5 35 0   6     0   16   71 59                       130 68 5 35 0   6     0   16   71 59                 130
1122332 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2017   grade_1 123 11 15 0   35     0   16   99 101                       200 123 11 15 0   35     0   16   99 101                 200
1127138 MA Middlesex   school 2508340 198   Natick 250834001291 1980005 Bennett-Hemenway   Regular School No Elementary KG 04 2017   grade_1 84 2 6 0   11     0   16   50 69                       119 84 2 6 0   11     0   16   50 69                 119
1127261 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No Elementary PK 05 2017   grade_1 53 20 41 0   0     0   16   84 46                       130 53 20 41 0   0     0   16   84 46                 130
1365104 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary PK 02 2020   grade_1 108 11 11 0   52     0   16   117 81 *                     198.0 108 11 11 0   52     0   16   117 81                 198
1367122 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2020   grade_1 49 12 40 0   2     0   16   57 62 *                     119.0 49 12 40 0   2     0   16   57 62                 119
2229138 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford: Lt Elezer Davis   Regular School No Elementary KG 02 2018   grade_1 129 9 10 0   35     0   16   102 97                       199.0 129 9 10 0   35     0   16   102 97                 199
2231548 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Fall River: Mary Fonseca Elementary School   Regular School No Elementary PK 05 2018   grade_1 43 14 47 0   3     0   16   71 52                       123.0 43 14 47 0   3     0   16   71 52                 123
738797 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Center   Regular School No 1 KG 01 2015   grade_1 175 2 10 0   25     0   15   110 117                       227 175 2 10 0   25     0   15   110 117                 227
933927 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   grade_1 17 98 30 2   0     0   15   90 72                       162 17 98 30 2   0     0   15   90 72                 162
1367116 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2020   grade_1 53 12 21 0   1     0   15   47 55 *                     102.0 53 12 21 0   1     0   15   47 55                 102
1368793 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2020   grade_1 60 3 13 3   1     0   15   48 47 *                     95.0 60 3 13 3   1     0   15   48 47                 95
1672422 MA Essex   school 2502640 30   Beverly 250264000168 300015 Beverly - Cove Elementary   Regular School No Elementary KG 04 2021   grade_1 100 6 25 0   6     0   15   85 67 *                     152.0 100 6 25 0   6     0   15   85 67                 152
1675126 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Hopkinton - Marathon Elementary School   Regular School No Elementary KG 01 2021   grade_1 159 1 14 0   89     0   15   145 133 *                     278.0 159 1 14 0   89     0   15   145 133                 278
2042202 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No Elementary PK 05 2019   grade_1 32 9 50 1   2     1   15   59 51                       110.0 32 9 50 1   2     1   15   59 51                 110
2042209 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No Elementary PK 05 2019   grade_1 49 6 28 0   1     0   15   54 45                       99.0 49 6 28 0   1     0   15   54 45                 99
2043263 MA Middlesex   school 2506840 155   Lexington 250684001000 1550010 Joseph Estabrook   Regular School No Elementary KG 05 2019   grade_1 36 4 3 0   41     0   15   58 41                       99.0 36 4 3 0   41     0   15   58 41                 99
2236818 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Watertown: Hosmer   Regular School No Elementary PK 05 2018   grade_1 58 2 23 0   14     0   15   63 49                       112.0 58 2 23 0   14     0   15   63 49                 112
742225 MA Bristol   school 2511520 293   Taunton 251152001907 2930027 Elizabeth Pole   Regular School No 1 KG 04 2015   grade_1 72 20 14 0   1     0   14   54 67                       121 72 20 14 0   1     0   14   54 67                 121
934067 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2016   grade_1 45 2 3 0   6     0   14   37 33                       70 45 2 3 0   6     0   14   37 33                 70
934886 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No 1 PK 05 2016   grade_1 71 8 23 0   3     0   14   67 52                       119 71 8 23 0   3     0   14   67 52                 119
934898 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Mary Fonseca Elementary School   Regular School No 1 KG 05 2016   grade_1 55 12 35 0   4     0   14   58 62                       120 55 12 35 0   4     0   14   58 62                 120
1124722 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2017   grade_1 65 7 39 1   8     0   14   76 58                       134 65 7 39 1   8     0   14   76 58                 134
1126601 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2017   grade_1 182 4 21 0   24     0   14   143 102                       245 182 4 21 0   24     0   14   143 102                 245
1368688 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2020   grade_1 178 10 12 0   14     0   14   119 109 *                     228.0 178 10 12 0   14     0   14   119 109                 228
1672191 MA Middlesex   school 2501980 10   Arlington 250198000062 100055 Arlington - M Norcross Stratton   Regular School No Elementary KG 05 2021   grade_1 41 3 10 0   15     0   14   40 43 *                     83.0 41 3 10 0   15     0   14   40 43                 83
1678895 MA Norfolk   school 2512270 317   Wellesley 251227001733 3170048 Wellesley - Sprague Elementary School   Regular School No Elementary KG 05 2021   grade_1 22 0 6 0   6     0   14   23 25 *                     48.0 22 0 6 0   6     0   14   23 25                 48
2041483 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2019   grade_1 13 9 1 0   17     0   14   27 27                       54.0 13 9 1 0   17     0   14   27 27                 54
2043754 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2019   grade_1 183 7 9 1   20     0   14   128 106                       234.0 183 7 9 1   20     0   14   128 106                 234
2043864 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   grade_1 85 2 4 6   3     0   14   66 48                       114.0 85 2 4 6   3     0   14   66 48                 114
2229223 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont: Roger E Wellington   Regular School No Elementary PK 04 2018   grade_1 80 2 2 0   19     0   14   62 55                       117.0 80 2 2 0   19     0   14   62 55                 117
2231696 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Fitchburg: Crocker Elementary   Regular School No Elementary PK 04 2018   grade_1 41 2 66 0   3     0   14   70 56                       126.0 41 2 66 0   3     0   14   70 56                 126
737244 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No 1 KG 08 2015   grade_1 57 3 11 0   28     0   13   47 65                       112 57 3 11 0   28     0   13   47 65                 112
743000 MA Middlesex   school 2513110 344   Winchester 251311002172 3440025 Vinson-Owen Elementary   Regular School No 1 KG 05 2015   grade_1 54 0 0 0   11     0   13   44 34                       78 54 0 0 0   11     0   13   44 34                 78
933996 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No 1 KG 05 2016   grade_1 21 65 14 1   1     3   13   65 53                       118 21 65 14 1   1     3   13   65 53                 118
934057 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2016   grade_1 74 5 8 0   10     0   13   54 56                       110 74 5 8 0   10     0   13   54 56                 110
934690 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No 1 PK 02 2016   grade_1 147 0 3 0   2     0   13   87 78                       165 147 0 3 0   2     0   13   87 78                 165
1125497 MA Norfolk   school 2506150 133   Holbrook 250615000880 1330018 John F Kennedy   Regular School No Elementary PK 03 2017   grade_1 62 16 7 0   3     0   13   55 46                       101 62 16 7 0   3     0   13   55 46                 101
1364937 MA Middlesex   school 2501980 10   Arlington 250198000054 100010 Brackett   Regular School No Elementary KG 05 2020   grade_1 82 0 4 0   7     0   13   59 47 *                     106.0 82 0 4 0   7     0   13   59 47                 106
1365121 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2020   grade_1 127 1 9 0   1     0   13   69 82 *                     151.0 127 1 9 0   1     0   13   69 82                 151
1672393 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont - Roger E Wellington   Regular School No Elementary PK 04 2021   grade_1 73 4 0 0   19     0   13   57 52 *                     109.0 73 4 0 0   19     0   13   57 52                 109
1674394 MA Bristol   school 2504830 95   Fall River 250483000684 950065 Fall River - William S Greene   Regular School No Elementary PK 05 2021   grade_1 46 14 38 0   8     0   13   54 65 *                     119.0 46 14 38 0   8     0   13   54 65                 119
1676043 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee - Kenneth Coombs School   Regular School No Elementary PK 02 2021   grade_1 62 6 8 2   1     0   13   52 40 *                     92.0 62 6 8 2   1     0   13   52 40                 92
1676638 MA Middlesex   school 2508610 207   Newton 250861001360 2070025 Newton - Cabot   Regular School No Elementary KG 05 2021   grade_1 31 5 9 0   13     0   13   34 37 *                     71.0 31 5 9 0   13     0   13   34 37                 71
1676662 MA Middlesex   school 2508610 207   Newton 250861001367 2070075 Newton - Horace Mann   Regular School No Elementary KG 05 2021   grade_1 39 2 7 0   7     0   13   39 29 *                     68.0 39 2 7 0   7     0   13   39 29                 68
1679924 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   grade_1 26 65 7 1   4     0   13   55 61 *                     116.0 26 65 7 1   4     0   13   55 61                 116
2040111 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2019   grade_1 32 9 21 0   2     0   13   35 42                       77.0 32 9 21 0   2     0   13   35 42                 77
2042189 MA Bristol   school 2504830 95   Fall River 250483001780 950005 North End Elementary   Regular School No Elementary PK 05 2019   grade_1 57 9 22 0   4     0   13   54 51                       105.0 57 9 22 0   4     0   13   54 51                 105
2042216 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2019   grade_1 32 10 27 0   2     0   13   43 41                       84.0 32 10 27 0   2     0   13   43 41                 84
2042242 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Spencer Borden   Regular School No Elementary KG 05 2019   grade_1 49 11 20 0   7     0   13   48 52                       100.0 49 11 20 0   7     0   13   48 52                 100
2042861 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2019   grade_1 160 1 13 0   19     0   13   107 99                       206.0 160 1 13 0   19     0   13   107 99                 206
2233422 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Mansfield: Everett W Robinson   Regular School No Elementary KG 02 2018   grade_1 183 8 14 0   18     0   13   118 118                       236.0 183 8 14 0   18     0   13   118 118                 236
737060 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2015   grade_1 13 83 30 1   1     0   12   74 66                       140 13 83 30 1   1     0   12   74 66                 140
737091 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2015   grade_1 23 68 25 1   1     0   12   65 65                       130 23 68 25 1   1     0   12   65 65                 130
743901 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter(District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes 4 KG 10 2015   grade_1 21 2 5 0   8     0   12   22 26                       48 21 2 5 0   8     0   12   22 26                 48
932753 MA Bristol   school 2502190 16   Attleboro 250219000098 160035 Thomas Willett Elementary School   Regular School No 1 KG 04 2016   grade_1 62 3 8 0   5     0   12   44 46                       90 62 3 8 0   5     0   12   44 46                 90
933952 MA Plymouth   school 2503090 44   Brockton 250309000401 440017 John F Kennedy   Regular School No 1 KG 05 2016   grade_1 34 57 8 0   6     1   12   63 55                       118 34 57 8 0   6     1   12   63 55                 118
935019 MA Worcester   school 2504890 97   Fitchburg 250489000702 970043 Reingold Elementary   Regular School No 1 KG 04 2016   grade_1 48 7 52 0   5     0   12   60 64                       124 48 7 52 0   5     0   12   60 64                 124
935974 MA Middlesex   school 2506840 155   Lexington 250684000994 1550008 Bowman   Regular School No 1 KG 05 2016   grade_1 43 4 2 0   32     0   12   47 46                       93 43 4 2 0   32     0   12   47 46                 93
936589 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No 1 PK 03 2016   grade_1 84 3 8 0   4     0   12   56 55                       111 84 3 8 0   4     0   12   56 55                 111
937824 MA Plymouth   school 2509720 239   Plymouth 250972001545 2390030 Nathaniel Morton Elementary   Regular School No 1 KG 05 2016   grade_1 95 0 2 0   2     0   12   53 58                       111 95 0 2 0   2     0   12   53 58                 111
941019 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No 1 KG 03 2016   grade_1 82 5 2 2   1     0   12   52 52                       104 82 5 2 2   1     0   12   52 52                 104
1123769 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2017   grade_1 39 5 3 0   30     0   12   49 40                       89 39 5 3 0   30     0   12   49 40                 89
1124494 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2017   grade_1 141 4 1 0   3     0   12   81 80                       161 141 4 1 0   3     0   12   81 80                 161
1364886 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   grade_1 64 0 11 0   6     0   12   47 46 *                     93.0 64 0 11 0   6     0   12   47 46                 93
1364962 MA Middlesex   school 2501980 10   Arlington 250198000066 100050 Thompson   Regular School No Elementary KG 05 2020   grade_1 55 4 9 0   12     0   12   51 41 *                     92.0 55 4 9 0   12     0   12   51 41                 92
1366277 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2020   grade_1 76 4 15 0   8     0   12   54 60 *                     115.0 76 4 15 0   8     0   12   54 60                 115
1366333 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2020   grade_1 28 4 6 0   11     0   12   33 28 *                     61.0 28 4 6 0   11     0   12   33 28                 61
1367262 MA Worcester   school 2504890 97   Fitchburg 250489002469 970060 South Street Elementary   Regular School No Elementary PK 04 2020   grade_1 22 10 80 0   3     0   12   70 57 *                     127.0 22 10 80 0   3     0   12   70 57                 127
1367344 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2020   grade_1 59 4 12 0   10     0   12   52 45 *                     97.0 59 4 12 0   10     0   12   52 45                 97
1368219 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2020   grade_1 45 10 6 0   3     0   12   35 41 *                     76.0 45 10 6 0   3     0   12   35 41                 76
1371275 MA Bristol   school 2511520 293   Taunton 251152001907 2930027 Elizabeth Pole   Regular School No Elementary KG 04 2020   grade_1 56 17 20 1   1     0   12   53 54 *                     107.0 56 17 20 1   1     0   12   53 54                 107
1371600 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No Elementary PK 04 2020   grade_1 75 13 50 0   4     0   12   82 72 *                     154.0 75 13 50 0   4     0   12   82 72                 154
1373172 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2020   grade_1 208 13 16 0   5     0   12   138 116 *                     254.0 208 13 16 0   5     0   12   138 116                 254
1373338 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No Elementary KG 03 2020   grade_1 109 0 3 0   1     0   12   66 59 *                     125.0 109 0 3 0   1     0   12   66 59                 125
1672154 MA Middlesex   school 2501980 10   Arlington 250198000059 100005 Arlington - John A Bishop   Regular School No Elementary KG 05 2021   grade_1 41 2 3 0   6     0   12   29 35 *                     64.0 41 2 3 0   6     0   12   29 35                 64
1672313 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable - West Villages Elementary School   Regular School No Elementary KG 03 2021   grade_1 67 1 13 0   0     0   12   45 48 *                     93.0 67 1 13 0   0     0   12   45 48                 93
1674347 MA Bristol   school 2504830 95   Fall River 250483001780 950005 Fall River - North End Elementary   Regular School No Elementary PK 05 2021   grade_1 58 16 30 0   0     0   12   53 63 *                     116.0 58 16 30 0   0     0   12   53 63                 116
1676518 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 New Bedford - Abraham Lincoln   Regular School No Elementary KG 05 2021   grade_1 50 14 59 0   2     0   12   75 62 *                     137.0 50 14 59 0   2     0   12   75 62                 137
2041366 MA Middlesex   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2019   grade_1 37 1 2 0   6     0   12   28 30                       58.0 37 1 2 0   6     0   12   28 30                 58
2041393 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2019   grade_1 49 4 9 0   29     0   12   56 47                       103.0 49 4 9 0   29     0   12   56 47                 103

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