enrollments

Data source: Big Local News · About: Big Local

975 rows where grade = "grade_1", state = "MA" and year = 2020 sorted by school_nces_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 975 ✖

grade ✖

  • grade_1 · 975 ✖
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
1373326 1373326 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_1 12 0 0 0   0     0   0   6 6 *                     12.0 12 0 0 0   0     0   0   6 6                 12
1372426 1372426 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2020   grade_1 89 0 6 0   4     0   4   55 48 *                     103.0 89 0 6 0   4     0   4   55 48                 103
1372419 1372419 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_1 8 0 1 0   0     0   1   5 5 *                     10.0 8 0 1 0   0     0   1   5 5                 10
1372178 1372178 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No Elementary PK 06 2020   grade_1 12 9 29 0   1     0   5   34 22 *                     56.0 12 9 29 0   1     0   5   34 22                 56
1372246 1372246 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2020   grade_1 5 26 27 0   1     0   1   25 35 *                     60.0 5 26 27 0   1     0   1   25 35                 60
1372170 1372170 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_1 14 2 58 0   2     0   1   39 38 *                     77.0 14 2 58 0   2     0   1   39 38                 77
1372366 1372366 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No Elementary PK 06 2020   grade_1 14 17 47 0   1     0   3   44 38 *                     82.0 14 17 47 0   1     0   3   44 38                 82
1372358 1372358 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No Elementary PK 06 2020   grade_1 19 6 10 0   3     0   4   21 21 *                     42.0 19 6 10 0   3     0   4   21 21                 42
1372133 1372133 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_1 5 1 3 0   3     0   1   5 8 *                     13.0 5 1 3 0   3     0   1   5 8                 13
1372350 1372350 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2020   grade_1 6 8 30 0   1     0   1   21 25 *                     46.0 6 8 30 0   1     0   1   21 25                 46
1372343 1372343 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2020   grade_1 18 9 14 0   2     0   1   27 17 *                     44.0 18 9 14 0   2     0   1   27 17                 44
1372336 1372336 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No Elementary PK 06 2020   grade_1 23 19 19 0   2     0   4   31 36 *                     67.0 23 19 19 0   2     0   4   31 36                 67
1372328 1372328 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2020   grade_1 29 10 14 1   4     0   0   32 26 *                     58.0 29 10 14 1   4     0   0   32 26                 58
1372320 1372320 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2020   grade_1 28 23 39 1   3     0   6   43 57 *                     100.0 28 23 39 1   3     0   6   43 57                 100
1372312 1372312 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No Elementary KG 06 2020   grade_1 19 7 31 0   4     0   1   25 37 *                     62.0 19 7 31 0   4     0   1   25 37                 62
1372305 1372305 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2020   grade_1 25 20 52 1   2     0   2   57 45 *                     102.0 25 20 52 1   2     0   2   57 45                 102
1372297 1372297 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No Elementary PK 06 2020   grade_1 25 26 35 0   3     0   3   49 43 *                     92.0 25 26 35 0   3     0   3   49 43                 92
1372289 1372289 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No Elementary PK 06 2020   grade_1 50 16 19 0   5     0   4   50 44 *                     94.0 50 16 19 0   5     0   4   50 44                 94
1372281 1372281 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No Elementary KG 06 2020   grade_1 25 2 7 0   0     0   3   16 21 *                     37.0 25 2 7 0   0     0   3   16 21                 37
1372267 1372267 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No Elementary KG 06 2020   grade_1 16 5 11 0   4     0   5   19 22 *                     41.0 16 5 11 0   4     0   5   19 22                 41
1372260 1372260 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary KG 06 2020   grade_1 8 6 27 0   3     0   0   27 17 *                     44.0 8 6 27 0   3     0   0   27 17                 44
1372253 1372253 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No Elementary KG 06 2020   grade_1 20 7 12 0   6     0   4   24 25 *                     49.0 20 7 12 0   6     0   4   24 25                 49
1372238 1372238 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No Elementary KG 06 2020   grade_1 16 4 11 0   2     0   4   18 19 *                     37.0 16 4 11 0   2     0   4   18 19                 37
1372231 1372231 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No Elementary KG 06 2020   grade_1 13 10 24 0   1     0   5   27 26 *                     53.0 13 10 24 0   1     0   5   27 26                 53
1372224 1372224 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No Elementary PK 06 2020   grade_1 23 15 34 0   8     0   3   50 33 *                     83.0 23 15 34 0   8     0   3   50 33                 83
1372216 1372216 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No Elementary PK 06 2020   grade_1 3 7 30 1   7     0   1   18 31 *                     49.0 3 7 30 1   7     0   1   18 31                 49
1372274 1372274 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary KG 06 2020   grade_1 9 4 22 0   1     0   1   20 17 *                     37.0 9 4 22 0   1     0   1   20 17                 37
1372201 1372201 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No Elementary KG 06 2020   grade_1 41 3 9 1   1     0   2   21 36 *                     57.0 41 3 9 1   1     0   2   21 36                 57
1372208 1372208 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No Elementary KG 06 2020   grade_1 10 8 42 0   5     0   3   33 35 *                     68.0 10 8 42 0   5     0   3   33 35                 68
1372194 1372194 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No Elementary PK 06 2020   grade_1 9 8 31 0   6     0   1   23 32 *                     55.0 9 8 31 0   6     0   1   23 32                 55
1372186 1372186 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2020   grade_1 3 7 18 0   1     0   1   16 14 *                     30.0 3 7 18 0   1     0   1   16 14                 30
1372162 1372162 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No Elementary KG 06 2020   grade_1 7 8 44 0   7     0   1   38 29 *                     67.0 7 8 44 0   7     0   1   38 29                 67
1372155 1372155 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No Elementary PK 06 2020   grade_1 3 8 24 0   5     0   0   18 22 *                     40.0 3 8 24 0   5     0   0   18 22                 40
1372147 1372147 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2020   grade_1 8 4 16 0   0     0   0   15 13 *                     28.0 8 4 16 0   0     0   0   15 13                 28
1372126 1372126 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2020   grade_1 13 20 57 0   7     0   3   50 50 *                     100.0 13 20 57 0   7     0   3   50 50                 100
1372140 1372140 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2020   grade_1 6 13 56 0   7     0   4   51 35 *                     86.0 6 13 56 0   7     0   4   51 35                 86
1372096 1372096 MA Middlesex   school 2513200 347   Woburn 251320002191 3470043 Shamrock   Regular School No Elementary PK 05 2020   grade_1 22 6 5 1   1     0   2   19 18 *                     37.0 22 6 5 1   1     0   2   19 18                 37
1372108 1372108 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Mary D Altavesta   Regular School No Elementary KG 05 2020   grade_1 23 3 6 0   11     0   2   22 23 *                     45.0 23 3 6 0   11     0   2   22 23                 45
1372102 1372102 MA Middlesex   school 2513200 347   Woburn 251320002188 3470055 Malcolm White   Regular School No Elementary KG 05 2020   grade_1 30 1 13 0   2     0   3   22 27 *                     49.0 30 1 13 0   2     0   3   22 27                 49
1372082 1372082 MA Middlesex   school 2513200 347   Woburn 251320002187 3470025 Linscott-Rumford   Regular School No Elementary KG 05 2020   grade_1 18 5 4 0   7     0   1   15 20 *                     35.0 18 5 4 0   7     0   1   15 20                 35
1372070 1372070 MA Middlesex   school 2513200 347   Woburn 251320002184 3470005 Goodyear Elementary School   Regular School No Elementary KG 05 2020   grade_1 40 5 6 0   5     0   2   32 26 *                     58.0 40 5 6 0   5     0   2   32 26                 58
1372076 1372076 MA Middlesex   school 2513200 347   Woburn 251320002183 3470020 Hurld-Wyman Elementary School   Regular School No Elementary KG 05 2020   grade_1 46 1 3 0   7     0   1   32 26 *                     58.0 46 1 3 0   7     0   1   32 26                 58
1372089 1372089 MA Middlesex   school 2513200 347   Woburn 251320002181 3470040 Clyde Reeves   Regular School No Elementary PK 05 2020   grade_1 49 7 2 2   6     0   4   33 37 *                     70.0 49 7 2 2   6     0   4   33 37                 70
1372056 1372056 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 William P. Gorman/Fort Banks Elementary   Regular School No Elementary PK 02 2020   grade_1 126 2 27 0   0     0   1   62 94 *                     156.0 126 2 27 0   0     0   1   62 94                 156
1372030 1372030 MA Middlesex   school 2513110 344   Winchester 251311002172 3440025 Vinson-Owen Elementary   Regular School No Elementary PK 05 2020   grade_1 41 0 1 0   12     0   10   38 26 *                     64.0 41 0 1 0   12     0   10   38 26                 64
1372036 1372036 MA Middlesex   school 2513110 344   Winchester 251311002168 3440040 Muraco Elementary   Regular School No Elementary KG 05 2020   grade_1 38 1 1 0   13     0   6   24 35 *                     59.0 38 1 1 0   13     0   6   24 35                 59
1372023 1372023 MA Middlesex   school 2513110 344   Winchester 251311002166 3440020 Lynch Elementary   Regular School No Elementary PK 05 2020   grade_1 45 0 4 0   28     0   11   45 43 *                     88.0 45 0 4 0   28     0   11   45 43                 88
1372016 1372016 MA Middlesex   school 2513110 344   Winchester 251311002165 3440005 Lincoln Elementary   Regular School No Elementary KG 05 2020   grade_1 58 0 0 0   7     0   3   36 32 *                     68.0 58 0 0 0   7     0   3   36 32                 68
1372042 1372042 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No Elementary KG 05 2020   grade_1 52 0 1 0   6     0   5   31 33 *                     64.0 52 0 1 0   6     0   5   31 33                 64
1371999 1371999 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No Elementary KG 02 2020   grade_1 90 1 3 0   3     0   3   51 49 *                     100.0 90 1 3 0   3     0   3   51 49                 100
1371980 1371980 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2020   grade_1 101 1 6 1   6     0   6   71 50 *                     121.0 101 1 6 1   6     0   6   71 50                 121
1371983 1371983 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No Elementary 01 03 2020   grade_1 93 1 3 0   7     1   6   62 49 *                     111.0 93 1 3 0   7     1   6   62 49                 111
1371970 1371970 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2020   grade_1 19 0 0 0   0     0   0   12 7 *                     19.0 19 0 0 0   0     0   0   12 7                 19
1374056 1374056 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary KG 04 2020   grade_1 88 1 5 0   2     0   2   44 54 *                     98.0 88 1 5 0   2     0   2   44 54                 98
1374050 1374050 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No Elementary KG 05 2020   grade_1 60 1 5 0   0     0   7   41 32 *                     73.0 60 1 5 0   0     0   7   41 32                 73
1374044 1374044 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No Elementary KG 05 2020   grade_1 67 1 5 0   0     0   4   39 38 *                     77.0 67 1 5 0   0     0   4   39 38                 77
1371962 1371962 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2020   grade_1 15 0 0 0   0     0   0   8 7 *                     15.0 15 0 0 0   0     0   0   8 7                 15
1371918 1371918 MA Norfolk   school 2512840 336   Weymouth 251284002565 3360050 Frederick C Murphy   Regular School No Elementary KG 04 2020   grade_1 22 3 8 0   4     0   3   21 19 *                     40.0 22 3 8 0   4     0   3   21 19                 40
1371933 1371933 MA Norfolk   school 2512840 336   Weymouth 251284002125 3360080 William Seach   Regular School No Elementary KG 04 2020   grade_1 23 11 18 0   11     0   1   32 32 *                     64.0 23 11 18 0   11     0   1   32 32                 64
1371948 1371948 MA Norfolk   school 2512840 336   Weymouth 251284002122 3360110 Wessagusset   Regular School No Elementary KG 04 2020   grade_1 37 3 4 0   3     0   2   21 28 *                     49.0 37 3 4 0   3     0   2   21 28                 49
1371943 1371943 MA Norfolk   school 2512840 336   Weymouth 251284002120 3360105 Thomas W. Hamilton Primary School   Regular School No Elementary KG 04 2020   grade_1 39 1 2 0   7     0   1   27 23 *                     50.0 39 1 2 0   7     0   1   27 23                 50
1371938 1371938 MA Norfolk   school 2512840 336   Weymouth 251284002116 3360085 Ralph Talbot   Regular School No Elementary KG 04 2020   grade_1 31 2 4 0   4     0   1   24 18 *                     42.0 31 2 4 0   4     0   1   24 18                 42
1371928 1371928 MA Norfolk   school 2512840 336   Weymouth 251284002114 3360065 Lawrence W Pingree   Regular School No Elementary KG 04 2020   grade_1 22 4 4 0   0     0   3   14 19 *                     33.0 22 4 4 0   0     0   3   14 19                 33
1371911 1371911 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2020   grade_1 38 0 10 0   8     1   3   29 31 *                     60.0 38 0 10 0   8     1   3   29 31                 60
1371923 1371923 MA Norfolk   school 2512840 336   Weymouth 251284000509 3360060 Thomas V Nash   Regular School No Elementary KG 04 2020   grade_1 19 2 1 0   3     0   1   11 15 *                     26.0 19 2 1 0   3     0   1   11 15                 26
1371896 1371896 MA Norfolk   school 2512810 335   Westwood 251281002101 3350025 William E Sheehan   Regular School No Elementary KG 05 2020   grade_1 47 1 1 0   3     0   5   28 29 *                     57.0 47 1 1 0   3     0   5   28 29                 57
1371884 1371884 MA Norfolk   school 2512810 335   Westwood 251281002099 3350015 Paul Hanlon   Regular School No Elementary KG 05 2020   grade_1 18 1 3 0   8     0   1   14 17 *                     31.0 18 1 3 0   8     0   1   14 17                 31
1371890 1371890 MA Norfolk   school 2512810 335   Westwood 251281002098 3350017 Martha Jones   Regular School No Elementary KG 05 2020   grade_1 30 0 2 0   1     0   6   17 22 *                     39.0 30 0 2 0   1     0   6   17 22                 39
1371878 1371878 MA Norfolk   school 2512810 335   Westwood 251281002096 3350012 Downey   Regular School No Elementary PK 05 2020   grade_1 42 0 3 0   13     0   2   37 23 *                     60.0 42 0 3 0   13     0   2   37 23                 60
1371872 1371872 MA Norfolk   school 2512810 335   Westwood 251281000794 3350010 Deerfield School   Regular School No Elementary KG 05 2020   grade_1 19 1 1 0   4     0   1   9 17 *                     26.0 19 1 1 0   4     0   1   9 17                 26
1371823 1371823 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2020   grade_1 98 1 4 0   0     0   3   47 59 *                     106.0 98 1 4 0   0     0   3   47 59                 106
1371811 1371811 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No Elementary PK 03 2020   grade_1 42 6 3 0   8     0   1   29 31 *                     60.0 42 6 3 0   8     0   1   29 31                 60
1371804 1371804 MA Middlesex   school 2512750 330   Weston 251275002085 3300010 Country   Regular School No Elementary PK 03 2020   grade_1 51 6 3 0   12     0   8   39 41 *                     80.0 51 6 3 0   12     0   8   39 41                 80
1371796 1371796 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2020   grade_1 15 0 0 0   0     0   0   9 6 *                     15.0 15 0 0 0   0     0   0   9 6                 15
1371772 1371772 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No Elementary KG 02 2020   grade_1 90 0 1 0   15     0   1   46 61 *                     107.0 90 0 1 0   15     0   1   46 61                 107
1371775 1371775 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Col John Robinson   Regular School No Elementary KG 02 2020   grade_1 57 1 1 0   27     0   6   49 43 *                     92.0 57 1 1 0   27     0   6   49 43                 92
1371782 1371782 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No Elementary PK 02 2020   grade_1 64 3 2 0   33     0   4   60 46 *                     106.0 64 3 2 0   33     0   4   60 46                 106
1371742 1371742 MA Hampden   school 2512630 325   Westfield 251263002606 3250036 Paper Mill   Regular School No Elementary KG 04 2020   grade_1 47 2 18 0   3     0   3   39 34 *                     73.0 47 2 18 0   3     0   3   39 34                 73
1371737 1371737 MA Hampden   school 2512630 325   Westfield 251263002605 3250033 Munger Hill   Regular School No Elementary KG 04 2020   grade_1 54 1 14 0   3     0   1   36 37 *                     73.0 54 1 14 0   3     0   1   36 37                 73
1371747 1371747 MA Hampden   school 2512630 325   Westfield 251263002071 3250040 Southampton Road   Regular School No Elementary KG 04 2020   grade_1 48 0 12 0   4     0   7   37 34 *                     71.0 48 0 12 0   4     0   7   37 34                 71
1371732 1371732 MA Hampden   school 2512630 325   Westfield 251263002065 3250025 Highland   Regular School No Elementary KG 04 2020   grade_1 69 0 10 0   4     0   2   40 45 *                     85.0 69 0 10 0   4     0   2   40 45                 85
1371722 1371722 MA Hampden   school 2512630 325   Westfield 251263002064 3250015 Franklin Ave   Regular School No Elementary KG 04 2020   grade_1 24 0 12 0   3     0   1   15 25 *                     40.0 24 0 12 0   3     0   1   15 25                 40
1371727 1371727 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 04 2020   grade_1 19 1 13 0   5     0   1   22 17 *                     39.0 19 1 13 0   5     0   1   22 17                 39
1371680 1371680 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No Elementary PK 03 2020   grade_1 36 3 12 1   39     0   3   47 47 *                     94.0 36 3 12 1   39     0   3   47 47                 94
1371671 1371671 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 J Harding Armstrong   Regular School No Elementary KG 03 2020   grade_1 44 1 11 0   29     0   1   40 46 *                     86.0 44 1 11 0   29     0   1   40 46                 86
1371675 1371675 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Annie E Fales   Regular School No Elementary KG 03 2020   grade_1 48 1 2 0   49     1   0   54 47 *                     101.0 48 1 2 0   49     1   0   54 47                 101
1371329 1371329 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_1 15 3 3 0   1     0   1   13 10 *                     23.0 15 3 3 0   1     0   1   13 10                 23
1371858 1371858 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No Elementary KG 05 2020   grade_1 43 0 10 0   3     0   1   32 25 *                     57.0 43 0 10 0   3     0   1   32 25                 57
1371853 1371853 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No Elementary 01 05 2020   grade_1 25 1 9 0   1     0   2   19 19 *                     38.0 25 1 9 0   1     0   2   19 19                 38
1371848 1371848 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No Elementary 01 05 2020   grade_1 13 2 20 0   2     0   4   20 21 *                     41.0 13 2 20 0   2     0   4   20 21                 41
1371843 1371843 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No Elementary 01 05 2020   grade_1 50 0 15 0   4     0   4   32 41 *                     73.0 50 0 15 0   4     0   4   32 41                 73
1371838 1371838 MA Hampden   school 2512510 332   West Springfield 251251001242 3320007 Philip G Coburn   Regular School No Elementary KG 05 2020   grade_1 46 2 17 1   20     0   1   39 48 *                     87.0 46 2 17 1   20     0   1   39 48                 87
1371706 1371706 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 Rose L Macdonald   Regular School No Elementary 01 03 2020   grade_1 95 4 8 0   0     0   5   54 58 *                     112.0 95 4 8 0   0     0   5   54 58                 112
1371694 1371694 MA Worcester   school 2512390 322   West Boylston 251239002034 3220005 Major Edwards Elementary   Regular School No Elementary PK 05 2020   grade_1 52 3 7 0   1     0   4   36 31 *                     67.0 52 3 7 0   1     0   4   36 31                 67
1371665 1371665 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary KG 05 2020   grade_1 14 0 0 0   0     0   4   9 9 *                     18.0 14 0 0 0   0     0   4   9 9                 18
1371639 1371639 MA Norfolk   school 2512270 317   Wellesley 251227002503 3170045 Schofield   Regular School No Elementary KG 05 2020   grade_1 38 3 4 0   12     0   3   28 32 *                     60.0 38 3 4 0   12     0   3   28 32                 60
1371615 1371615 MA Norfolk   school 2512270 317   Wellesley 251227002025 3170005 Katharine Lee Bates   Regular School No Elementary KG 05 2020   grade_1 46 0 2 0   3     0   3   31 23 *                     54.0 46 0 2 0   3     0   3   31 23                 54
1371621 1371621 MA Norfolk   school 2512270 317   Wellesley 251227002024 3170015 Joseph E Fiske   Regular School No Elementary KG 05 2020   grade_1 36 0 4 0   4     0   6   26 24 *                     50.0 36 0 4 0   4     0   6   26 24                 50
1371627 1371627 MA Norfolk   school 2512270 317   Wellesley 251227002023 3170020 John D Hardy   Regular School No Elementary KG 05 2020   grade_1 22 0 3 0   10     0   5   19 21 *                     40.0 22 0 3 0   10     0   5   19 21                 40
1371633 1371633 MA Norfolk   school 2512270 317   Wellesley 251227002022 3170025 Hunnewell   Regular School No Elementary KG 05 2020   grade_1 33 2 3 0   0     0   5   21 22 *                     43.0 33 2 3 0   0     0   5   21 22                 43

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