enrollments

Data source: Big Local News · About: Big Local

989 rows where grade = "grade_1", state = "MA" and year = 2018 sorted by school_nces_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 989 ✖

grade ✖

  • grade_1 · 989 ✖
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
2230204 2230204 MA Suffolk   school   35   Boston   350652               2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2238919 2238919 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Reg: Farmington River Elementary   Regular School No Elementary PK 06 2018   grade_1 14 0 0 0   0     0   0   7 7                       14.0 14 0 0 0   0     0   0   7 7                 14
2237905 2237905 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham: Delaney   Regular School No Elementary PK 03 2018   grade_1 105 2 9 0   3     0   3   64 58                       122.0 105 2 9 0   3     0   3   64 58                 122
2237897 2237897 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 Worthington: R. H. Conwell   Regular School No Elementary PK 06 2018   grade_1 9 0 0 0   0     0   0   1 8                       9.0 9 0 0 0   0     0   0   1 8                 9
2237622 2237622 MA Worcester   school 2513230 348   Worcester 251323002610 3480053 Worcester: City View   Regular School No Elementary PK 06 2018   grade_1 13 10 31 0   1     0   4   28 31                       59.0 13 10 31 0   1     0   4   28 31                 59
2237699 2237699 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Worcester: Jacob Hiatt Magnet   Regular School No Elementary PK 06 2018   grade_1 5 19 30 0   1     0   1   27 29                       56.0 5 19 30 0   1     0   1   27 29                 56
2237613 2237613 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Worcester: Chandler Magnet   Regular School No Elementary PK 06 2018   grade_1 7 1 50 0   5     0   0   32 31                       63.0 7 1 50 0   5     0   0   32 31                 63
2237835 2237835 MA Worcester   school 2513230 348   Worcester 251323002422 3480280 Worcester: Vernon Hill School   Regular School No Elementary PK 06 2018   grade_1 11 13 35 0   3     0   4   34 32                       66.0 11 13 35 0   3     0   4   34 32                 66
2237826 2237826 MA Worcester   school 2513230 348   Worcester 251323002251 3480260 Worcester: West Tatnuck   Regular School No Elementary PK 06 2018   grade_1 32 2 3 0   3     0   3   20 23                       43.0 32 2 3 0   3     0   3   20 23                 43
2237571 2237571 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Worcester: Wawecus Road School   Regular School No Elementary KG 06 2018   grade_1 3 2 7 0   0     0   1   6 7                       13.0 3 2 7 0   0     0   1   6 7                 13
2237817 2237817 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Worcester: Union Hill School   Regular School No Elementary KG 06 2018   grade_1 11 8 37 0   1     0   4   31 30                       61.0 11 8 37 0   1     0   4   31 30                 61
2237809 2237809 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Worcester: Thorndyke Road   Regular School No Elementary KG 06 2018   grade_1 28 13 13 0   9     0   2   29 36                       65.0 28 13 13 0   9     0   2   29 36                 65
2237801 2237801 MA Worcester   school 2513230 348   Worcester 251323002246 3480230 Worcester: Tatnuck   Regular School No Elementary PK 06 2018   grade_1 22 11 15 0   5     0   2   26 29                       55.0 22 11 15 0   5     0   2   26 29                 55
2237792 2237792 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester: Worcester Arts Magnet School   Regular School No Elementary PK 06 2018   grade_1 28 7 15 0   3     0   5   35 23                       58.0 28 7 15 0   3     0   5   35 23                 58
2237783 2237783 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Worcester: Roosevelt   Regular School No Elementary PK 06 2018   grade_1 52 12 26 0   5     0   1   43 53                       96.0 52 12 26 0   5     0   1   43 53                 96
2237774 2237774 MA Worcester   school 2513230 348   Worcester 251323002242 3480215 Worcester: Rice Square   Regular School No Elementary KG 06 2018   grade_1 15 12 28 0   5     0   2   41 21                       62.0 15 12 28 0   5     0   2   41 21                 62
2237766 2237766 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Worcester: Quinsigamond   Regular School No Elementary PK 06 2018   grade_1 33 18 43 1   4     0   6   49 56                       105.0 33 18 43 1   4     0   6   49 56                 105
2237757 2237757 MA Worcester   school 2513230 348   Worcester 251323002238 3480202 Worcester: Norrback Avenue   Regular School No Elementary PK 06 2018   grade_1 23 15 25 0   2     0   4   36 33                       69.0 23 15 25 0   2     0   4   36 33                 69
2237748 2237748 MA Worcester   school 2513230 348   Worcester 251323002236 3480200 Worcester: Nelson Place   Regular School No Elementary PK 06 2018   grade_1 41 6 15 0   4     0   4   42 28                       70.0 41 6 15 0   4     0   4   42 28                 70
2237739 2237739 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Worcester: Midland Street   Regular School No Elementary KG 06 2018   grade_1 22 1 5 0   2     0   2   16 16                       32.0 22 1 5 0   2     0   2   16 16                 32
2237723 2237723 MA Worcester   school 2513230 348   Worcester 251323002231 3480175 Worcester: May Street   Regular School No Elementary KG 06 2018   grade_1 19 5 10 0   6     0   4   19 25                       44.0 19 5 10 0   6     0   4   19 25                 44
2237715 2237715 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Worcester: Lincoln Street   Regular School No Elementary KG 06 2018   grade_1 0 7 17 1   1     0   0   15 11                       26.0 0 7 17 1   1     0   0   15 11                 26
2237707 2237707 MA Worcester   school 2513230 348   Worcester 251323002226 3480145 Worcester: Lake View   Regular School No Elementary KG 06 2018   grade_1 22 9 9 0   7     0   2   31 18                       49.0 22 9 9 0   7     0   2   31 18                 49
2237690 2237690 MA Worcester   school 2513230 348   Worcester 251323002224 3480136 Worcester: Heard Street   Regular School No Elementary KG 06 2018   grade_1 23 5 11 0   3     0   2   26 18                       44.0 23 5 11 0   3     0   2   26 18                 44
2237682 2237682 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Worcester: Grafton Street   Regular School No Elementary KG 06 2018   grade_1 15 7 34 0   7     0   1   36 28                       64.0 15 7 34 0   7     0   1   36 28                 64
2237674 2237674 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Worcester: Gates Lane   Regular School No Elementary PK 06 2018   grade_1 20 10 28 2   7     0   5   43 29                       72.0 20 10 28 2   7     0   5   43 29                 72
2237665 2237665 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Worcester: Goddard School/Science Technical   Regular School No Elementary PK 06 2018   grade_1 9 5 39 1   5     0   3   26 36                       62.0 9 5 39 1   5     0   3   26 36                 62
2237731 2237731 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Worcester: Francis J McGrath Elementary   Regular School No Elementary KG 06 2018   grade_1 12 7 13 0   1     0   3   20 16                       36.0 12 7 13 0   1     0   3   20 16                 36
2237648 2237648 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Worcester: Flagg Street   Regular School No Elementary KG 06 2018   grade_1 39 4 8 0   4     0   4   32 27                       59.0 39 4 8 0   4     0   4   32 27                 59
2237656 2237656 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Worcester: Elm Park Community   Regular School No Elementary KG 06 2018   grade_1 9 5 43 0   2     0   1   32 28                       60.0 9 5 43 0   2     0   1   32 28                 60
2237640 2237640 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Worcester: Columbus Park   Regular School No Elementary PK 06 2018   grade_1 12 10 37 1   3     0   1   32 32                       64.0 12 10 37 1   3     0   1   32 32                 64
2237631 2237631 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Worcester: Clark St Community   Regular School No Elementary PK 06 2018   grade_1 5 9 29 0   1     0   2   23 23                       46.0 5 9 29 0   1     0   2   23 23                 46
2237604 2237604 MA Worcester   school 2513230 348   Worcester 251323002204 3480050 Worcester: Chandler Elementary Community   Regular School No Elementary KG 06 2018   grade_1 4 8 52 0   4     0   1   31 38                       69.0 4 8 52 0   4     0   1   31 38                 69
2237596 2237596 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Worcester: Canterbury   Regular School No Elementary PK 06 2018   grade_1 10 7 31 0   11     0   1   33 27                       60.0 10 7 31 0   11     0   1   33 27                 60
2237587 2237587 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Worcester: Burncoat Street   Regular School No Elementary KG 06 2018   grade_1 14 3 18 0   2     0   2   20 19                       39.0 14 3 18 0   2     0   2   20 19                 39
2237563 2237563 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Worcester: Belmont Street Community   Regular School No Elementary PK 06 2018   grade_1 11 16 35 0   8     0   5   43 32                       75.0 11 16 35 0   8     0   5   43 32                 75
2237579 2237579 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Worcester: Woodland Academy   Regular School No Elementary KG 06 2018   grade_1 9 6 74 0   5     0   2   46 50                       96.0 9 6 74 0   5     0   2   46 50                 96
2237533 2237533 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Woburn: Wyman   Regular School No Elementary KG 05 2018   grade_1 19 1 4 0   5     0   0   13 16                       29.0 19 1 4 0   5     0   0   13 16                 29
2237519 2237519 MA Middlesex   school 2513200 347   Woburn 251320002191 3470043 Woburn: Shamrock   Regular School No Elementary PK 05 2018   grade_1 21 3 7 0   1     0   3   20 15                       35.0 21 3 7 0   1     0   3   20 15                 35
2237540 2237540 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Woburn: Mary D Altavesta   Regular School No Elementary KG 05 2018   grade_1 25 5 3 1   4     0   3   23 18                       41.0 25 5 3 1   4     0   3   23 18                 41
2237526 2237526 MA Middlesex   school 2513200 347   Woburn 251320002188 3470055 Woburn: Malcolm White   Regular School No Elementary KG 05 2018   grade_1 40 1 1 1   0     1   1   20 25                       45.0 40 1 1 1   0     1   1   20 25                 45
2237503 2237503 MA Middlesex   school 2513200 347   Woburn 251320002187 3470025 Woburn: Linscott-Rumford   Regular School No Elementary KG 05 2018   grade_1 23 5 1 0   12     0   1   20 22                       42.0 23 5 1 0   12     0   1   20 22                 42
2237489 2237489 MA Middlesex   school 2513200 347   Woburn 251320002184 3470005 Woburn: Goodyear Elementary School   Regular School No Elementary KG 05 2018   grade_1 45 5 0 0   3     0   0   34 19                       53.0 45 5 0 0   3     0   0   34 19                 53
2237496 2237496 MA Middlesex   school 2513200 347   Woburn 251320002183 3470020 Woburn: Daniel P Hurld   Regular School No Elementary KG 05 2018   grade_1 35 1 0 0   3     0   0   21 18                       39.0 35 1 0 0   3     0   0   21 18                 39
2237511 2237511 MA Middlesex   school 2513200 347   Woburn 251320002181 3470040 Woburn: Clyde Reeves   Regular School No Elementary PK 05 2018   grade_1 46 4 7 0   6     0   4   26 41                       67.0 46 4 7 0   6     0   4   26 41                 67
2237471 2237471 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 Winthrop: William P. Gorman/Fort Banks Elementary   Regular School No Elementary PK 02 2018   grade_1 126 1 19 0   2     0   3   74 77                       151.0 126 1 19 0   2     0   3   74 77                 151
2237440 2237440 MA Middlesex   school 2513110 344   Winchester 251311002172 3440025 Winchester: Vinson-Owen Elementary   Regular School No Elementary PK 05 2018   grade_1 39 0 1 0   12     0   4   27 29                       56.0 39 0 1 0   12     0   4   27 29                 56
2237447 2237447 MA Middlesex   school 2513110 344   Winchester 251311002168 3440040 Winchester: Muraco Elementary   Regular School No Elementary KG 05 2018   grade_1 47 2 1 0   9     0   7   34 32                       66.0 47 2 1 0   9     0   7   34 32                 66
2237432 2237432 MA Middlesex   school 2513110 344   Winchester 251311002166 3440020 Winchester: Lynch Elementary   Regular School No Elementary PK 05 2018   grade_1 44 1 4 0   24     0   5   46 32                       78.0 44 1 4 0   24     0   5   46 32                 78
2237424 2237424 MA Middlesex   school 2513110 344   Winchester 251311002165 3440005 Winchester: Lincoln Elementary   Regular School No Elementary KG 05 2018   grade_1 68 0 1 0   7     0   7   28 55                       83.0 68 0 1 0   7     0   7   28 55                 83
2237454 2237454 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Winchester: Ambrose Elementary   Regular School No Elementary KG 05 2018   grade_1 56 0 0 0   3     0   2   32 29                       61.0 56 0 0 0   3     0   2   32 29                 61
2237403 2237403 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Winchendon: Memorial   Regular School No Elementary KG 02 2018   grade_1 90 1 5 0   1     0   6   62 41                       103.0 90 1 5 0   1     0   6   62 41                 103
2237377 2237377 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Wilmington: Woburn Street   Regular School No Elementary 01 03 2018   grade_1 114 6 3 1   3     0   5   71 61                       132.0 114 6 3 1   3     0   5   71 61                 132
2237381 2237381 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Wilmington: Shawsheen Elementary   Regular School No Elementary 01 03 2018   grade_1 89 1 7 0   10     0   4   58 53                       111.0 89 1 7 0   10     0   4   58 53                 111
2237364 2237364 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown: Williamstown Elementary   Regular School No Elementary PK 06 2018   grade_1 48 1 4 0   1     0   4   31 27                       58.0 48 1 4 0   1     0   4   31 27                 58
2237355 2237355 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Williamsburg: Anne T. Dunphy School   Regular School No Elementary PK 06 2018   grade_1 18 1 0 0   0     0   0   6 13                       19.0 18 1 0 0   0     0   0   6 13                 19
2239764 2239764 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 Whitman-Hanson: John H Duval   Regular School No Elementary KG 05 2018   grade_1 63 0 6 0   0     0   3   39 33                       72.0 63 0 6 0   0     0   3   39 33                 72
2239760 2239760 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Whitman-Hanson: Maquan Elementary   Regular School No Elementary PK 02 2018   grade_1 97 0 3 1   2     0   4   66 41                       107.0 97 0 3 1   2     0   4   66 41                 107
2239752 2239752 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Whitman-Hanson: Louise A Conley   Regular School No Elementary KG 05 2018   grade_1 73 2 8 2   0     0   1   42 44                       86.0 73 2 8 2   0     0   1   42 44                 86
2237346 2237346 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately: Whately Elementary   Regular School No Elementary PK 06 2018   grade_1 20 0 0 0   0     0   0   10 10                       20.0 20 0 0 0   0     0   0   10 10                 20
2237295 2237295 MA Norfolk   school 2512840 336   Weymouth 251284002565 3360050 Weymouth: Frederick C Murphy   Regular School No Elementary KG 04 2018   grade_1 35 4 5 0   0     0   1   25 20                       45.0 35 4 5 0   0     0   1   25 20                 45
2237313 2237313 MA Norfolk   school 2512840 336   Weymouth 251284002125 3360080 Weymouth: William Seach   Regular School No Elementary KG 04 2018   grade_1 33 18 9 0   7     0   3   34 36                       70.0 33 18 9 0   7     0   3   34 36                 70
2237331 2237331 MA Norfolk   school 2512840 336   Weymouth 251284002122 3360110 Weymouth: Wessagusset   Regular School No Elementary KG 04 2018   grade_1 46 0 5 0   1     0   2   33 21                       54.0 46 0 5 0   1     0   2   33 21                 54
2237325 2237325 MA Norfolk   school 2512840 336   Weymouth 251284002120 3360105 Weymouth: Thomas W. Hamilton Primary School   Regular School No Elementary KG 04 2018   grade_1 41 3 7 0   6     0   7   36 28                       64.0 41 3 7 0   6     0   7   36 28                 64
2237319 2237319 MA Norfolk   school 2512840 336   Weymouth 251284002116 3360085 Weymouth: Ralph Talbot   Regular School No Elementary KG 04 2018   grade_1 31 5 7 0   5     0   2   23 27                       50.0 31 5 7 0   5     0   2   23 27                 50
2237307 2237307 MA Norfolk   school 2512840 336   Weymouth 251284002114 3360065 Weymouth: Lawrence W Pingree   Regular School No Elementary KG 04 2018   grade_1 30 4 0 0   1     0   1   16 20                       36.0 30 4 0 0   1     0   1   16 20                 36
2237284 2237284 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Weymouth: Academy Avenue   Regular School No Elementary KG 04 2018   grade_1 47 1 8 0   8     0   3   38 29                       67.0 47 1 8 0   8     0   3   38 29                 67
2237301 2237301 MA Norfolk   school 2512840 336   Weymouth 251284000509 3360060 Weymouth: Thomas V Nash   Regular School No Elementary KG 04 2018   grade_1 32 1 2 0   0     0   0   15 20                       35.0 32 1 2 0   0     0   0   15 20                 35
2237264 2237264 MA Norfolk   school 2512810 335   Westwood 251281002101 3350025 Westwood: William E Sheehan   Regular School No Elementary KG 05 2018   grade_1 43 0 0 0   0     0   3   26 20                       46.0 43 0 0 0   0     0   3   26 20                 46
2237250 2237250 MA Norfolk   school 2512810 335   Westwood 251281002099 3350015 Westwood: Paul Hanlon   Regular School No Elementary KG 05 2018   grade_1 22 1 1 0   6     0   1   17 14                       31.0 22 1 1 0   6     0   1   17 14                 31
2237257 2237257 MA Norfolk   school 2512810 335   Westwood 251281002098 3350017 Westwood: Martha Jones   Regular School No Elementary KG 05 2018   grade_1 32 1 2 0   2     0   3   22 18                       40.0 32 1 2 0   2     0   3   22 18                 40
2237243 2237243 MA Norfolk   school 2512810 335   Westwood 251281002096 3350012 Westwood: Downey   Regular School No Elementary KG 05 2018   grade_1 33 0 1 0   6     0   3   25 18                       43.0 33 0 1 0   6     0   3   25 18                 43
2237236 2237236 MA Norfolk   school 2512810 335   Westwood 251281000794 3350010 Westwood: Deerfield School   Regular School No Elementary KG 05 2018   grade_1 21 1 1 0   3     0   3   21 8                       29.0 21 1 1 0   3     0   3   21 8                 29
2237160 2237160 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Westport: Alice A Macomber   Regular School No Elementary PK 02 2018   grade_1 94 0 4 0   0     0   6   57 47                       104.0 94 0 4 0   0     0   6   57 47                 104
2237145 2237145 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Weston: Woodland   Regular School No Elementary PK 03 2018   grade_1 54 4 5 0   13     1   2   45 34                       79.0 54 4 5 0   13     1   2   45 34                 79
2237136 2237136 MA Middlesex   school 2512750 330   Weston 251275002085 3300010 Weston: Country   Regular School No Elementary PK 03 2018   grade_1 43 1 7 0   6     0   3   29 31                       60.0 43 1 7 0   6     0   3   29 31                 60
2237127 2237127 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton: Westhampton Elementary School   Regular School No Elementary PK 06 2018   grade_1 14 0 1 0   0     0   0   10 5                       15.0 14 0 1 0   0     0   0   10 5                 15
2237097 2237097 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Westford: Nabnasset   Regular School No Elementary KG 02 2018   grade_1 76 0 5 0   26     0   4   57 54                       111.0 76 0 5 0   26     0   4   57 54                 111
2237101 2237101 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Westford: Col John Robinson   Regular School No Elementary KG 02 2018   grade_1 75 1 1 0   24     0   4   53 52                       105.0 75 1 1 0   24     0   4   53 52                 105
2237109 2237109 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Westford: Rita E. Miller Elementary School   Regular School No Elementary KG 02 2018   grade_1 65 0 2 0   33     0   8   60 48                       108.0 65 0 2 0   33     0   8   60 48                 108
2237048 2237048 MA Hampden   school 2512630 325   Westfield 251263002606 3250036 Westfield: Paper Mill   Regular School No Elementary KG 05 2018   grade_1 43 4 21 0   0     1   3   38 34                       72.0 43 4 21 0   0     1   3   38 34                 72
2237041 2237041 MA Hampden   school 2512630 325   Westfield 251263002605 3250033 Westfield: Munger Hill   Regular School No Elementary KG 05 2018   grade_1 55 1 5 0   1     0   1   27 36                       63.0 55 1 5 0   1     0   1   27 36                 63
2237055 2237055 MA Hampden   school 2512630 325   Westfield 251263002071 3250040 Westfield: Southampton Road   Regular School No Elementary KG 05 2018   grade_1 62 0 5 0   0     0   3   31 39                       70.0 62 0 5 0   0     0   3   31 39                 70
2237062 2237062 MA Hampden   school 2512630 325   Westfield 251263002066 3250055 Westfield: Russell Elementary School   Regular School No Elementary KG 05 2018   grade_1 22 0 2 0   0     0   0   10 14                       24.0 22 0 2 0   0     0   0   10 14                 24
2237034 2237034 MA Hampden   school 2512630 325   Westfield 251263002065 3250025 Westfield: Highland   Regular School No Elementary KG 05 2018   grade_1 39 0 12 0   6     0   1   28 30                       58.0 39 0 12 0   6     0   1   28 30                 58
2237020 2237020 MA Hampden   school 2512630 325   Westfield 251263002064 3250015 Westfield: Franklin Ave   Regular School No Elementary KG 05 2018   grade_1 25 4 15 0   1     0   0   18 27                       45.0 25 4 15 0   1     0   0   18 27                 45
2237027 2237027 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Westfield: Abner Gibbs   Regular School No Elementary KG 05 2018   grade_1 28 0 8 0   2     0   1   18 21                       39.0 28 0 8 0   2     0   1   18 21                 39
2236967 2236967 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Westborough: Elsie A Hastings Elementary   Regular School No Elementary PK 03 2018   grade_1 39 3 17 1   39     0   2   46 55                       101.0 39 3 17 1   39     0   2   46 55                 101
2236956 2236956 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 Westborough: J Harding Armstrong   Regular School No Elementary KG 03 2018   grade_1 49 1 10 0   50     0   5   59 56                       115.0 49 1 10 0   50     0   5   59 56                 115
2236961 2236961 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Westborough: Annie E Fales   Regular School No Elementary KG 03 2018   grade_1 43 0 3 0   39     0   3   36 52                       88.0 43 0 3 0   39     0   3   36 52                 88
2236556 2236556 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury: Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_1 16 2 9 0   0     0   2   18 11                       29.0 16 2 9 0   0     0   2   18 11                 29
2237222 2237222 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_1 * * * *   *     *   *   * *                       0.0                                             0
2237205 2237205 MA Hampden   school 2512510 332   West Springfield 251251002050 3320040 West Springfield: Tatham   Regular School No Elementary KG 05 2018   grade_1 48 0 1 0   0     0   2   27 24                       51.0 48 0 1 0   0     0   2   27 24                 51
2237198 2237198 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 West Springfield: Mittineague   Regular School No Elementary 01 05 2018   grade_1 27 2 8 0   0     0   0   21 16                       37.0 27 2 8 0   0     0   0   21 16                 37
2237192 2237192 MA Hampden   school 2512510 332   West Springfield 251251002047 3320025 West Springfield: Memorial   Regular School No Elementary 01 05 2018   grade_1 21 1 12 0   3     0   1   21 17                       38.0 21 1 12 0   3     0   1   21 17                 38
2237186 2237186 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 West Springfield: John R Fausey   Regular School No Elementary 01 05 2018   grade_1 56 3 18 0   3     0   2   38 44                       82.0 56 3 18 0   3     0   2   38 44                 82
2237180 2237180 MA Hampden   school 2512510 332   West Springfield 251251001242 3320007 West Springfield: Philip G Coburn   Regular School No Elementary KG 05 2018   grade_1 74 6 19 0   17     0   2   48 70                       118.0 74 6 19 0   17     0   2   48 70                 118
2236999 2236999 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 West Bridgewater: Rose L Macdonald   Regular School No Elementary 01 03 2018   grade_1 73 2 4 0   1     0   4   41 43                       84.0 73 2 4 0   1     0   4   41 43                 84
2236985 2236985 MA Worcester   school 2512390 322   West Boylston 251239002034 3220005 West Boylston: Major Edwards Elementary   Regular School No Elementary PK 05 2018   grade_1 48 2 9 0   1     0   1   35 26                       61.0 48 2 9 0   1     0   1   35 26                 61
2236949 2236949 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet: Wellfleet Elementary   Regular School No Elementary PK 05 2018   grade_1 13 0 2 0   1     0   2   10 8                       18.0 13 0 2 0   1     0   2   10 8                 18

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