enrollments

Data source: Big Local News · About: Big Local

988 rows where grade = "grade_1", state = "MA" and year = 2016 sorted by school_nces_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 988 ✖

grade ✖

  • grade_1 · 988 ✖
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
941096 941096 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2016   grade_1 11 0 0 0   0     0   0   7 4                       11 11 0 0 0   0     0   0   7 4                 11
940212 940212 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No 1 PK 03 2016   grade_1 114 0 4 0   3     0   5   61 65                       126 114 0 4 0   3     0   5   61 65                 126
940204 940204 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No 1 PK 06 2016   grade_1 5 0 0 0   0     0   1   3 3                       6 5 0 0 0   0     0   1   3 3                 6
939964 939964 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 City View   Regular School No 1 PK 06 2016   grade_1 30 11 32 0   4     0   5   50 32                       82 30 11 32 0   4     0   5   50 32                 82
940034 940034 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No 1 PK 06 2016   grade_1 8 18 31 0   1     0   6   36 28                       64 8 18 31 0   1     0   6   36 28                 64
939956 939956 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2016   grade_1 12 4 42 0   0     0   2   26 34                       60 12 4 42 0   0     0   2   26 34                 60
940154 940154 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Vernon Hill School   Regular School No 1 PK 06 2016   grade_1 20 15 34 0   2     0   4   43 32                       75 20 15 34 0   2     0   4   43 32                 75
940146 940146 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 West Tatnuck   Regular School No 1 PK 06 2016   grade_1 31 4 6 0   5     0   3   25 24                       49 31 4 6 0   5     0   3   25 24                 49
939918 939918 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No 1 KG 06 2016   grade_1 9 0 4 0   1     0   1   11 4                       15 9 0 4 0   1     0   1   11 4                 15
940138 940138 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No 1 KG 06 2016   grade_1 25 11 39 0   0     0   5   41 39                       80 25 11 39 0   0     0   5   41 39                 80
940131 940131 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No 1 KG 06 2016   grade_1 37 3 4 0   1     0   2   27 20                       47 37 3 4 0   1     0   2   27 20                 47
940124 940124 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Tatnuck   Regular School No 1 KG 06 2016   grade_1 31 9 6 0   6     0   3   32 23                       55 31 9 6 0   6     0   3   32 23                 55
940117 940117 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No 1 PK 06 2016   grade_1 33 11 9 0   2     0   7   27 35                       62 33 11 9 0   2     0   7   27 35                 62
940109 940109 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No 1 PK 06 2016   grade_1 47 15 20 0   9     0   3   47 47                       94 47 15 20 0   9     0   3   47 47                 94
940101 940101 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Rice Square   Regular School No 1 KG 06 2016   grade_1 25 7 21 0   4     0   5   33 29                       62 25 7 21 0   4     0   5   33 29                 62
940094 940094 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No 1 PK 06 2016   grade_1 38 21 27 0   8     0   6   51 49                       100 38 21 27 0   8     0   6   51 49                 100
940086 940086 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Norrback Avenue   Regular School No 1 PK 06 2016   grade_1 39 24 15 0   5     0   5   45 43                       88 39 24 15 0   5     0   5   45 43                 88
940078 940078 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Nelson Place   Regular School No 1 KG 06 2016   grade_1 43 10 12 0   3     0   9   46 31                       77 43 10 12 0   3     0   9   46 31                 77
940071 940071 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No 1 KG 06 2016   grade_1 23 1 4 0   4     0   2   16 18                       34 23 1 4 0   4     0   2   16 18                 34
940056 940056 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 May Street   Regular School No 1 KG 06 2016   grade_1 27 3 9 0   4     0   9   22 30                       52 27 3 9 0   4     0   9   22 30                 52
940049 940049 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No 1 PK 06 2016   grade_1 6 10 24 1   1     0   2   21 23                       44 6 10 24 1   1     0   2   21 23                 44
940041 940041 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Lake View   Regular School No 1 KG 06 2016   grade_1 24 6 9 1   5     0   3   18 30                       48 24 6 9 1   5     0   3   18 30                 48
940026 940026 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Heard Street   Regular School No 1 KG 06 2016   grade_1 25 8 7 0   8     0   2   22 28                       50 25 8 7 0   8     0   2   22 28                 50
940019 940019 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2016   grade_1 20 7 27 0   6     0   7   33 34                       67 20 7 27 0   6     0   7   33 34                 67
940011 940011 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2016   grade_1 30 18 35 0   8     0   6   61 36                       97 30 18 35 0   8     0   6   61 36                 97
940003 940003 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No 1 PK 06 2016   grade_1 9 8 32 1   5     0   3   31 27                       58 9 8 32 1   5     0   3   31 27                 58
940064 940064 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No 1 PK 06 2016   grade_1 16 8 10 0   3     0   1   20 18                       38 16 8 10 0   3     0   1   20 18                 38
939987 939987 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No 1 KG 06 2016   grade_1 37 5 8 0   4     0   5   28 31                       59 37 5 8 0   4     0   5   28 31                 59
939995 939995 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No 1 PK 06 2016   grade_1 22 10 36 0   2     0   3   40 33                       73 22 10 36 0   2     0   3   40 33                 73
939980 939980 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2016   grade_1 22 8 33 0   9     0   2   35 39                       74 22 8 33 0   9     0   2   35 39                 74
939972 939972 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No 1 PK 06 2016   grade_1 12 5 15 0   0     0   2   19 15                       34 12 5 15 0   0     0   2   19 15                 34
939948 939948 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Chandler Elementary Community   Regular School No 1 KG 06 2016   grade_1 21 12 44 0   6     0   2   40 45                       85 21 12 44 0   6     0   2   40 45                 85
939941 939941 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2016   grade_1 12 7 24 1   8     0   2   29 25                       54 12 7 24 1   8     0   2   29 25                 54
939933 939933 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No 1 KG 06 2016   grade_1 7 5 20 0   0     0   2   18 16                       34 7 5 20 0   0     0   2   18 16                 34
939911 939911 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No 1 PK 06 2016   grade_1 20 17 31 0   8     0   2   37 41                       78 20 17 31 0   8     0   2   37 41                 78
939926 939926 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2016   grade_1 9 8 73 0   8     0   6   50 54                       104 9 8 73 0   8     0   6   50 54                 104
939887 939887 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No 1 KG 05 2016   grade_1 30 0 3 0   4     0   0   14 23                       37 30 0 3 0   4     0   0   14 23                 37
939875 939875 MA Middlesex   school 2513200 347   Woburn 251320002191 3470043 Shamrock   Regular School No 1 PK 05 2016   grade_1 28 2 9 0   1     0   3   26 17                       43 28 2 9 0   1     0   3   26 17                 43
939893 939893 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Mary D Altavesta   Regular School No 1 KG 05 2016   grade_1 17 3 8 3   12     0   0   25 18                       43 17 3 8 3   12     0   0   25 18                 43
939881 939881 MA Middlesex   school 2513200 347   Woburn 251320002188 3470055 Malcolm White   Regular School No 1 KG 05 2016   grade_1 40 3 7 0   3     0   4   30 27                       57 40 3 7 0   3     0   4   30 27                 57
939861 939861 MA Middlesex   school 2513200 347   Woburn 251320002187 3470025 Linscott-Rumford   Regular School No 1 KG 05 2016   grade_1 21 2 1 0   9     0   0   13 20                       33 21 2 1 0   9     0   0   13 20                 33
939849 939849 MA Middlesex   school 2513200 347   Woburn 251320002184 3470005 Goodyear Elementary School   Regular School No 1 KG 05 2016   grade_1 35 8 4 1   2     0   2   24 28                       52 35 8 4 1   2     0   2   24 28                 52
939855 939855 MA Middlesex   school 2513200 347   Woburn 251320002183 3470020 Daniel P Hurld   Regular School No 1 KG 05 2016   grade_1 35 0 0 0   1     0   0   17 19                       36 35 0 0 0   1     0   0   17 19                 36
939868 939868 MA Middlesex   school 2513200 347   Woburn 251320002181 3470040 Clyde Reeves   Regular School No 1 PK 05 2016   grade_1 48 8 2 0   2     0   3   28 35                       63 48 8 2 0   2     0   3   28 35                 63
939835 939835 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 William P. Gorman/Fort Banks Elementary   Regular School No 1 PK 03 2016   grade_1 121 4 17 0   0     0   3   87 58                       145 121 4 17 0   0     0   3   87 58                 145
939809 939809 MA Middlesex   school 2513110 344   Winchester 251311002172 3440025 Vinson-Owen Elementary   Regular School No 1 KG 05 2016   grade_1 41 0 2 0   17     0   4   29 35                       64 41 0 2 0   17     0   4   29 35                 64
939815 939815 MA Middlesex   school 2513110 344   Winchester 251311002168 3440040 Muraco Elementary   Regular School No 1 KG 05 2016   grade_1 40 0 4 0   12     0   4   32 28                       60 40 0 4 0   12     0   4   32 28                 60
939803 939803 MA Middlesex   school 2513110 344   Winchester 251311002166 3440020 Lynch Elementary   Regular School No 1 PK 05 2016   grade_1 49 2 7 0   12     0   1   38 33                       71 49 2 7 0   12     0   1   38 33                 71
939796 939796 MA Middlesex   school 2513110 344   Winchester 251311002165 3440005 Lincoln Elementary   Regular School No 1 KG 05 2016   grade_1 61 0 1 0   7     0   4   41 32                       73 61 0 1 0   7     0   4   41 32                 73
939821 939821 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No 1 KG 05 2016   grade_1 72 0 2 0   3     0   2   46 33                       79 72 0 2 0   3     0   2   46 33                 79
939778 939778 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No 1 KG 02 2016   grade_1 84 0 6 0   1     0   2   61 32                       93 84 0 6 0   1     0   2   61 32                 93
939759 939759 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No 1 01 03 2016   grade_1 89 0 8 0   3     0   4   59 45                       104 89 0 8 0   3     0   4   59 45                 104
939762 939762 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Shawsheen Elementary   Regular School No 1 01 03 2016   grade_1 87 1 10 0   5     0   5   56 52                       108 87 1 10 0   5     0   5   56 52                 108
939749 939749 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No 1 PK 06 2016   grade_1 52 0 2 1   2     0   4   28 33                       61 52 0 2 1   2     0   4   28 33                 61
939741 939741 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No 1 PK 06 2016   grade_1 18 0 2 0   0     0   0   9 11                       20 18 0 2 0   0     0   0   9 11                 20
941829 941829 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No 1 KG 05 2016   grade_1 65 3 3 0   0     1   3   38 37                       75 65 3 3 0   0     1   3   38 37                 75
941826 941826 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No 1 PK 02 2016   grade_1 99 0 6 0   2     0   2   60 49                       109 99 0 6 0   2     0   2   60 49                 109
941819 941819 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No 1 KG 05 2016   grade_1 74 2 6 1   1     0   1   47 38                       85 74 2 6 1   1     0   1   47 38                 85
939733 939733 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No 1 PK 06 2016   grade_1 16 0 0 0   0     0   1   11 6                       17 16 0 0 0   0     0   1   11 6                 17
939691 939691 MA Norfolk   school 2512840 336   Weymouth 251284002565 3360050 Frederick C Murphy   Regular School No 1 KG 04 2016   grade_1 31 0 2 0   1     0   5   18 21                       39 31 0 2 0   1     0   5   18 21                 39
939706 939706 MA Norfolk   school 2512840 336   Weymouth 251284002125 3360080 William Seach   Regular School No 1 KG 04 2016   grade_1 38 8 8 1   7     0   3   33 32                       65 38 8 8 1   7     0   3   33 32                 65
939721 939721 MA Norfolk   school 2512840 336   Weymouth 251284002122 3360110 Wessagusset   Regular School No 1 KG 04 2016   grade_1 64 3 2 0   3     0   4   36 40                       76 64 3 2 0   3     0   4   36 40                 76
939716 939716 MA Norfolk   school 2512840 336   Weymouth 251284002120 3360105 Thomas W. Hamilton Primary School   Regular School No 1 KG 04 2016   grade_1 58 5 10 0   5     0   1   34 45                       79 58 5 10 0   5     0   1   34 45                 79
939711 939711 MA Norfolk   school 2512840 336   Weymouth 251284002116 3360085 Ralph Talbot   Regular School No 1 KG 04 2016   grade_1 47 2 7 0   2     0   0   24 34                       58 47 2 7 0   2     0   0   24 34                 58
939701 939701 MA Norfolk   school 2512840 336   Weymouth 251284002114 3360065 Lawrence W Pingree   Regular School No 1 KG 04 2016   grade_1 42 0 4 0   3     0   1   23 27                       50 42 0 4 0   3     0   1   23 27                 50
939683 939683 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No 1 KG 04 2016   grade_1 45 3 6 0   4     0   3   27 34                       61 45 3 6 0   4     0   3   27 34                 61
939696 939696 MA Norfolk   school 2512840 336   Weymouth 251284000509 3360060 Thomas V Nash   Regular School No 1 KG 04 2016   grade_1 37 1 1 0   4     0   1   18 26                       44 37 1 1 0   4     0   1   18 26                 44
939668 939668 MA Norfolk   school 2512810 335   Westwood 251281002101 3350025 William E Sheehan   Regular School No 1 KG 05 2016   grade_1 55 0 2 0   4     0   2   30 33                       63 55 0 2 0   4     0   2   30 33                 63
939656 939656 MA Norfolk   school 2512810 335   Westwood 251281002099 3350015 Paul Hanlon   Regular School No 1 KG 05 2016   grade_1 29 0 1 0   5     0   4   22 17                       39 29 0 1 0   5     0   4   22 17                 39
939662 939662 MA Norfolk   school 2512810 335   Westwood 251281002098 3350017 Martha Jones   Regular School No 1 KG 05 2016   grade_1 33 0 2 0   4     0   1   20 20                       40 33 0 2 0   4     0   1   20 20                 40
939650 939650 MA Norfolk   school 2512810 335   Westwood 251281002096 3350012 Downey   Regular School No 1 KG 05 2016   grade_1 25 0 4 0   3     0   1   15 18                       33 25 0 4 0   3     0   1   15 18                 33
939644 939644 MA Norfolk   school 2512810 335   Westwood 251281000794 3350010 Deerfield School   Regular School No 1 KG 05 2016   grade_1 33 0 1 0   5     0   3   24 18                       42 33 0 1 0   5     0   3   24 18                 42
939593 939593 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No 1 PK 02 2016   grade_1 110 1 2 1   1     0   6   58 63                       121 110 1 2 1   1     0   6   58 63                 121
939581 939581 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Woodland   Regular School No 1 PK 03 2016   grade_1 52 3 3 0   7     0   1   36 30                       66 52 3 3 0   7     0   1   36 30                 66
939574 939574 MA Middlesex   school 2512750 330   Weston 251275002085 3300010 Country   Regular School No 1 PK 03 2016   grade_1 43 6 7 0   11     0   5   31 41                       72 43 6 7 0   11     0   5   31 41                 72
939566 939566 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No 1 PK 06 2016   grade_1 17 0 1 0   0     0   0   8 10                       18 17 0 1 0   0     0   0   8 10                 18
939542 939542 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No 1 KG 02 2016   grade_1 107 1 2 0   20     0   7   76 61                       137 107 1 2 0   20     0   7   76 61                 137
939545 939545 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Col John Robinson   Regular School No 1 KG 02 2016   grade_1 62 1 3 0   22     0   5   40 53                       93 62 1 3 0   22     0   5   40 53                 93
939551 939551 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No 1 KG 02 2016   grade_1 66 2 0 0   48     0   6   66 56                       122 66 2 0 0   48     0   6   66 56                 122
939502 939502 MA Hampden   school 2512630 325   Westfield 251263002606 3250036 Paper Mill   Regular School No 1 KG 05 2016   grade_1 54 6 17 0   0     0   1   40 38                       78 54 6 17 0   0     0   1   40 38                 78
939496 939496 MA Hampden   school 2512630 325   Westfield 251263002605 3250033 Munger Hill   Regular School No 1 KG 05 2016   grade_1 41 3 3 0   1     0   2   26 24                       50 41 3 3 0   1     0   2   26 24                 50
939508 939508 MA Hampden   school 2512630 325   Westfield 251263002071 3250040 Southampton Road   Regular School No 1 KG 05 2016   grade_1 54 2 9 0   0     0   3   35 33                       68 54 2 9 0   0     0   3   35 33                 68
939514 939514 MA Hampden   school 2512630 325   Westfield 251263002066 3250055 Russell Elementary School   Regular School No 1 KG 05 2016   grade_1 33 0 2 0   0     0   0   18 17                       35 33 0 2 0   0     0   0   18 17                 35
939490 939490 MA Hampden   school 2512630 325   Westfield 251263002065 3250025 Highland   Regular School No 1 KG 05 2016   grade_1 53 1 12 0   5     0   1   38 34                       72 53 1 12 0   5     0   1   38 34                 72
939478 939478 MA Hampden   school 2512630 325   Westfield 251263002064 3250015 Franklin Ave   Regular School No 1 KG 05 2016   grade_1 20 1 11 1   0     0   2   19 16                       35 20 1 11 1   0     0   2   19 16                 35
939484 939484 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No 1 KG 05 2016   grade_1 20 0 6 0   3     0   1   17 13                       30 20 0 6 0   3     0   1   17 13                 30
939436 939436 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No 1 PK 03 2016   grade_1 41 0 11 0   34     0   2   45 43                       88 41 0 11 0   34     0   2   45 43                 88
939427 939427 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 J Harding Armstrong   Regular School No 1 KG 03 2016   grade_1 48 1 4 0   43     0   0   45 51                       96 48 1 4 0   43     0   0   45 51                 96
939431 939431 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Annie E Fales   Regular School No 1 KG 03 2016   grade_1 52 2 4 2   21     0   3   49 35                       84 52 2 4 2   21     0   3   49 35                 84
939088 939088 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No 1 PK 08 2016   grade_1 22 1 7 1   0     1   2   20 14                       34 22 1 7 1   0     1   2   20 14                 34
939628 939628 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 Tatham   Regular School No 1 01 05 2016   grade_1 42 0 5 0   0     0   1   26 22                       48 42 0 5 0   0     0   1   26 22                 48
939623 939623 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No 1 01 05 2016   grade_1 20 2 7 0   0     0   0   12 17                       29 20 2 7 0   0     0   0   12 17                 29
939618 939618 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 Memorial   Regular School No 1 01 05 2016   grade_1 30 2 10 0   4     0   2   20 28                       48 30 2 10 0   4     0   2   20 28                 48
939613 939613 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No 1 KG 05 2016   grade_1 54 4 8 0   4     0   2   49 23                       72 54 4 8 0   4     0   2   49 23                 72
939608 939608 MA Hampden   school 2512510 332   West Springfield 251251001242 3320007 Philip G Coburn   Regular School No 1 KG 05 2016   grade_1 74 1 17 0   17     0   3   59 53                       112 74 1 17 0   17     0   3   59 53                 112
939462 939462 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 Rose L Macdonald   Regular School No 1 01 03 2016   grade_1 70 4 4 0   2     0   0   41 39                       80 70 4 4 0   2     0   0   41 39                 80
939450 939450 MA Worcester   school 2512390 322   West Boylston 251239002034 3220005 Major Edwards Elementary   Regular School No 1 PK 05 2016   grade_1 46 0 7 0   1     0   1   27 28                       55 46 0 7 0   1     0   1   27 28                 55
939421 939421 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No 1 PK 05 2016   grade_1 13 0 2 0   0     0   0   9 6                       15 13 0 2 0   0     0   0   9 6                 15
939395 939395 MA Norfolk   school 2512270 317   Wellesley 251227002503 3170045 Schofield   Regular School No 1 KG 05 2016   grade_1 37 4 9 0   8     0   4   31 31                       62 37 4 9 0   8     0   4   31 31                 62
939370 939370 MA Norfolk   school 2512270 317   Wellesley 251227002025 3170005 Katharine Lee Bates   Regular School No 1 KG 05 2016   grade_1 49 2 0 0   4     0   2   28 29                       57 49 2 0 0   4     0   2   28 29                 57

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