enrollments

Data source: Big Local News · About: Big Local

6,831 rows where grade = "grade_2" and state = "MA" sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 6,731 ✖
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
1672310 1672310 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable - Hyannis West Elementary   Regular School No Elementary KG 03 2021   grade_2 16 10 38 1   1     0   5   35 36 *                     71.0 16 10 38 1   1     0   5   35 36                 71
1672314 1672314 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable - West Villages Elementary School   Regular School No Elementary KG 03 2021   grade_2 77 1 8 0   3     0   7   51 45 *                     96.0 77 1 8 0   3     0   7   51 45                 96
1673296 1673296 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne - Bournedale Elementary School   Regular School No Elementary PK 02 2021   grade_2 91 1 4 1   3     0   3   45 58 *                     103.0 91 1 4 1   3     0   3   45 58                 103
1673363 1673363 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster - Stony Brook Elementary   Regular School No Elementary PK 02 2021   grade_2 51 1 8 0   0     0   2   23 39 *                     62.0 51 1 8 0   0     0   2   23 39                 62
1674170 1674170 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham - Eastham Elementary   Regular School No Elementary PK 05 2021   grade_2 21 1 2 0   2     0   2   16 12 *                     28.0 21 1 2 0   2     0   2   16 12                 28
1674450 1674450 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth - East Falmouth Elementary   Regular School No Elementary PK 04 2021   grade_2 32 1 8 0   3     0   1   21 24 *                     45.0 32 1 8 0   3     0   1   21 24                 45
1674456 1674456 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth - Teaticket   Regular School No Elementary PK 04 2021   grade_2 27 7 1 1   0     0   2   17 21 *                     38.0 27 7 1 1   0     0   2   17 21                 38
1674461 1674461 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth - Mullen-Hall   Regular School No Elementary KG 04 2021   grade_2 63 4 10 0   2     0   4   34 49 *                     83.0 63 4 10 0   2     0   4   34 49                 83
1674466 1674466 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 Falmouth - North Falmouth Elementary   Regular School No Elementary KG 04 2021   grade_2 49 3 6 0   0     0   4   26 36 *                     62.0 49 3 6 0   0     0   4   26 36                 62
1676044 1676044 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee - Kenneth Coombs School   Regular School No Elementary PK 02 2021   grade_2 56 4 12 4   1     0   14   49 42 *                     91.0 56 4 12 4   1     0   14   49 42                 91
1677052 1677052 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans - Orleans Elementary   Regular School No Elementary KG 05 2021   grade_2 24 1 3 1   0     0   0   15 14 *                     29.0 24 1 3 1   0     0   0   15 14                 29
1677341 1677341 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_2 3 6 0 0   0     0   1   3 7 *                     10.0 3 6 0 0   0     0   1   3 7                 10
1677693 1677693 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Sandwich - Forestdale School   Regular School No Elementary PK 02 2021   grade_2 167 5 6 0   7     0   0   90 95 *                     185.0 167 5 6 0   7     0   0   90 95                 185
1678600 1678600 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro - Truro Central   Regular School No Elementary PK 06 2021   grade_2 11 2 0 0   0     0   3   9 7 *                     16.0 11 2 0 0   0     0   3   9 7                 16
1678916 1678916 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet - Wellfleet Elementary   Regular School No Elementary KG 05 2021   grade_2 18 0 1 0   0     0   4   13 10 *                     23.0 18 0 1 0   0     0   4   13 10                 23
1680503 1680503 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Dennis-Yarmouth - Ezra H Baker Innovation School   Regular School No Elementary PK 03 2021   grade_2 45 5 11 1   0     0   6   33 35 *                     68.0 45 5 11 1   0     0   6   33 35                 68
1680508 1680508 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Dennis-Yarmouth - Marguerite E Small Elementary   Regular School No Elementary PK 03 2021   grade_2 39 8 6 2   3     0   3   36 25 *                     61.0 39 8 6 2   3     0   3   36 25                 61
1680512 1680512 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Dennis-Yarmouth - Station Avenue Elementary   Regular School No Elementary KG 03 2021   grade_2 84 8 10 0   4     0   11   59 58 *                     117.0 84 8 10 0   4     0   11   59 58                 117
1680817 1680817 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Monomoy Regional School District - Chatham Elementary School   Regular School No Elementary PK 04 2021   grade_2 21 2 4 0   1     0   2   14 16 *                     30.0 21 2 4 0   1     0   2   14 16                 30
1680823 1680823 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Monomoy Regional School District - Harwich Elementary School   Regular School No Elementary PK 04 2021   grade_2 66 2 11 1   1     0   7   46 42 *                     88.0 66 2 11 1   1     0   7   46 42                 88
2040104 2040104 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2019   grade_2 48 3 6 0   3     0   4   36 28                       64.0 48 3 6 0   3     0   4   36 28                 64
2040108 2040108 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2019   grade_2 35 5 7 0   2     0   3   29 23                       52.0 35 5 7 0   2     0   3   29 23                 52
2040112 2040112 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2019   grade_2 26 16 27 0   1     0   7   33 44                       77.0 26 16 27 0   1     0   7   33 44                 77
2040116 2040116 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2019   grade_2 93 5 4 0   1     0   6   53 56                       109.0 93 5 4 0   1     0   6   53 56                 109
2041114 2041114 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2019   grade_2 63 0 2 2   0     0   1   31 37                       68.0 63 0 2 2   0     0   1   31 37                 68
2041119 2041119 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No Elementary KG 04 2019   grade_2 54 2 6 0   2     0   1   32 33                       65.0 54 2 6 0   2     0   1   32 33                 65
2041197 2041197 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2019   grade_2 68 3 5 0   0     0   5   40 41                       81.0 68 3 5 0   0     0   5   40 41                 81
2042011 2042011 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2019   grade_2 25 1 0 0   1     0   1   14 14                       28.0 25 1 0 0   1     0   1   14 14                 28
2042286 2042286 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary KG 04 2019   grade_2 33 2 2 3   0     0   4   26 18                       44.0 33 2 2 3   0     0   4   26 18                 44
2042292 2042292 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2019   grade_2 33 8 3 1   0     0   8   26 27                       53.0 33 8 3 1   0     0   8   26 27                 53
2042297 2042297 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2019   grade_2 62 2 6 2   1     0   9   44 38                       82.0 62 2 6 2   1     0   9   44 38                 82
2042302 2042302 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2019   grade_2 45 2 3 0   2     0   2   33 21                       54.0 45 2 3 0   2     0   2   33 21                 54
2043865 2043865 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   grade_2 69 7 3 7   3     1   13   48 55                       103.0 69 7 3 7   3     1   13   48 55                 103
2044878 2044878 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2019   grade_2 32 2 2 0   0     0   0   14 22                       36.0 32 2 2 0   0     0   0   14 22                 36
2045167 2045167 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   grade_2 6 3 3 0   0     0   0   3 9                       12.0 6 3 3 0   0     0   0   3 9                 12
2045516 2045516 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2019   grade_2 165 1 10 1   5     0   4   91 95                       186.0 165 1 10 1   5     0   4   91 95                 186
2046424 2046424 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2019   grade_2 8 4 1 0   0     0   1   6 8                       14.0 8 4 1 0   0     0   1   6 8                 14
2046740 2046740 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2019   grade_2 11 0 2 0   1     0   2   9 7                       16.0 11 0 2 0   1     0   2   9 7                 16
2047607 2047607 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes Elementary KG 03 2019   grade_2 29 16 17 0   3     0   1   31 35                       66.0 29 16 17 0   3     0   1   31 35                 66
2048301 2048301 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2019   grade_2 47 4 7 2   0     0   9   37 32                       69.0 47 4 7 2   0     0   9   37 32                 69
2048306 2048306 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2019   grade_2 37 6 8 3   0     1   6   40 21                       61.0 37 6 8 3   0     1   6   40 21                 61
2048310 2048310 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2019   grade_2 77 10 8 5   3     1   5   63 46                       109.0 77 10 8 5   3     1   5   63 46                 109
2048615 2048615 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2019   grade_2 29 6 6 0   0     1   3   27 18                       45.0 29 6 6 0   0     1   3   27 18                 45
2048621 2048621 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2019   grade_2 81 5 4 0   0     0   6   43 53                       96.0 81 5 4 0   0     0   6   43 53                 96
2229107 2229107 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable: West Barnstable Elementary   Regular School No Elementary KG 03 2018   grade_2 57 2 5 0   1     0   1   41 25                       66.0 57 2 5 0   1     0   1   41 25                 66
2229112 2229112 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable: Centerville Elementary   Regular School No Elementary KG 03 2018   grade_2 59 2 5 0   0     0   2   36 32                       68.0 59 2 5 0   0     0   2   36 32                 68
2229117 2229117 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable: Hyannis West Elementary   Regular School No Elementary KG 03 2018   grade_2 29 17 36 1   3     0   4   50 40                       90.0 29 17 36 1   3     0   4   50 40                 90
2229122 2229122 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable: West Villages Elementary School   Regular School No Elementary KG 03 2018   grade_2 82 3 6 0   0     0   4   55 40                       95.0 82 3 6 0   0     0   4   55 40                 95
2230282 2230282 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne: Bournedale Elementary School   Regular School No Elementary PK 04 2018   grade_2 57 3 4 1   0     1   4   35 35                       70.0 57 3 4 1   0     1   4   35 35                 70
2230288 2230288 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Bourne: Peebles Elementary School   Regular School No Elementary KG 04 2018   grade_2 65 5 8 0   1     1   3   42 41                       83.0 65 5 8 0   1     1   3   42 41                 83
2230380 2230380 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster: Stony Brook Elementary   Regular School No Elementary PK 02 2018   grade_2 60 2 5 0   0     0   5   37 35                       72.0 60 2 5 0   0     0   5   37 35                 72
2231329 2231329 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham: Eastham Elementary   Regular School No Elementary PK 05 2018   grade_2 22 2 1 0   1     0   0   10 16                       26.0 22 2 1 0   1     0   0   10 16                 26
2231660 2231660 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth: East Falmouth Elementary   Regular School No Elementary KG 04 2018   grade_2 39 2 4 0   1     0   6   27 25                       52.0 39 2 4 0   1     0   6   27 25                 52
2231667 2231667 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth: Teaticket   Regular School No Elementary PK 04 2018   grade_2 43 6 5 0   0     0   0   21 33                       54.0 43 6 5 0   0     0   0   21 33                 54
2231673 2231673 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth: Mullen-Hall   Regular School No Elementary KG 04 2018   grade_2 74 0 5 0   2     0   6   47 40                       87.0 74 0 5 0   2     0   6   47 40                 87
2231679 2231679 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 Falmouth: North Falmouth Elementary   Regular School No Elementary KG 04 2018   grade_2 51 1 5 0   0     0   4   23 38                       61.0 51 1 5 0   0     0   4   23 38                 61
2233555 2233555 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee: Kenneth Coombs School   Regular School No Elementary PK 02 2018   grade_2 84 6 9 8   1     0   11   60 59                       119.0 84 6 9 8   1     0   11   60 59                 119
2234758 2234758 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans: Orleans Elementary   Regular School No Elementary KG 05 2018   grade_2 30 0 4 0   1     0   1   15 21                       36.0 30 0 4 0   1     0   1   15 21                 36
2235095 2235095 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown: Provincetown Schools   Regular School No Elementary PK 08 2018   grade_2 7 1 4 0   0     0   3   10 5                       15.0 7 1 4 0   0     0   3   10 5                 15
2235515 2235515 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Sandwich: Forestdale School   Regular School No Elementary PK 02 2018   grade_2 195 3 9 0   6     1   0   106 108                       214.0 195 3 9 0   6     1   0   106 108                 214
2236578 2236578 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro: Truro Central   Regular School No Elementary PK 05 2018   grade_2 8 1 3 0   0     0   3   7 8                       15.0 8 1 3 0   0     0   3   7 8                 15
2236950 2236950 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet: Wellfleet Elementary   Regular School No Elementary PK 05 2018   grade_2 12 1 0 0   0     0   3   6 10                       16.0 12 1 0 0   0     0   3   6 10                 16
2238025 2238025 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public (District): Barnstable Community Horace Mann Charter Public School   Regular School Yes Elementary KG 03 2018   grade_2 27 23 17 0   3     0   5   36 39                       75.0 27 23 17 0   3     0   5   36 39                 75
2238812 2238812 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Dennis-Yarmouth: Ezra H Baker Innovation School   Regular School No Elementary PK 04 2018   grade_2 61 9 9 1   4     0   10   57 37                       94.0 61 9 9 1   4     0   10   57 37                 94
2238819 2238819 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Dennis-Yarmouth: Marguerite E Small Elementary   Regular School No Elementary PK 03 2018   grade_2 34 4 11 3   1     0   6   29 30                       59.0 34 4 11 3   1     0   6   29 30                 59
2238824 2238824 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Dennis-Yarmouth: Station Avenue Elementary   Regular School No Elementary KG 03 2018   grade_2 85 7 9 0   3     0   12   59 57                       116.0 85 7 9 0   3     0   12   59 57                 116
2239186 2239186 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Monomoy Regional School District: Chatham Elementary School   Regular School No Elementary PK 04 2018   grade_2 36 1 4 0   1     0   0   20 22                       42.0 36 1 4 0   1     0   0   20 22                 42
2239193 2239193 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Monomoy Regional School District: Harwich Elementary School   Regular School No Elementary PK 04 2018   grade_2 78 7 5 1   3     0   7   58 43                       101.0 78 7 5 1   3     0   7   58 43                 101
737602 737602 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   grade_2 16 1 0 0   0     0   0   11 6                       17 16 1 0 0   0     0   0   11 6                 17
738206 738206 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_2 13 0 0 0   0     0   0   5 8                       13 13 0 0 0   0     0   0   5 8                 13
738516 738516 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   grade_2 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
738882 738882 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_2 25 0 0 0   0     0   3   14 14                       28 25 0 0 0   0     0   3   14 14                 28
739029 739029 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2015   grade_2 34 0 3 0   0     0   2   12 27                       39 34 0 3 0   0     0   2   12 27                 39
739057 739057 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No 1 PK 05 2015   grade_2 42 0 2 0   3     0   2   31 18                       49 42 0 2 0   3     0   2   31 18                 49
740429 740429 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 J S Sullivan   Regular School No 1 KG 07 2015   grade_2 41 0 2 0   0     1   2   20 26                       46 41 0 2 0   0     1   2   20 26                 46
740437 740437 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No 1 KG 07 2015   grade_2 22 2 1 0   0     0   1   15 11                       26 22 2 1 0   0     0   1   15 11                 26
740446 740446 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2015   grade_2 55 1 4 0   0     0   5   31 34                       65 55 1 4 0   0     0   5   31 34                 65
740892 740892 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No 1 KG 05 2015   grade_2 40 6 5 1   2     0   4   33 25                       58 40 6 5 1   2     0   4   33 25                 58
740898 740898 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Egremont   Regular School No 1 KG 05 2015   grade_2 58 10 16 0   2     0   3   34 55                       89 58 10 16 0   2     0   3   34 55                 89
740905 740905 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No 1 PK 05 2015   grade_2 27 2 0 0   0     0   1   11 19                       30 27 2 0 0   0     0   1   11 19                 30
740912 740912 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Morningside Community School   Regular School No 1 PK 05 2015   grade_2 56 14 10 0   0     0   4   47 37                       84 56 14 10 0   0     0   4   47 37                 84
740919 740919 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No 1 PK 05 2015   grade_2 43 16 7 0   0     0   8   40 34                       74 43 16 7 0   0     0   8   40 34                 74
740925 740925 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Stearns   Regular School No 1 KG 05 2015   grade_2 24 3 3 0   0     0   1   15 16                       31 24 3 3 0   0     0   1   15 16                 31
740931 740931 MA Berkshire   school 2509630 236   Pittsfield 250963001536 2360100 Williams   Regular School No 1 KG 05 2015   grade_2 48 2 1 0   8     0   5   30 34                       64 48 2 1 0   8     0   5   30 34                 64
740938 740938 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No 1 PK 05 2015   grade_2 21 10 11 0   0     0   10   25 27                       52 21 10 11 0   0     0   10   25 27                 52
741271 741271 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_2 16 1 0 0   0     0   1   8 10                       18 16 1 0 0   0     0   1   8 10                 18
741453 741453 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No 1 PK 05 2015   grade_2 * * * *   *     *   *   3 1                       4                         3 1                 4
742945 742945 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No 1 PK 06 2015   grade_2 45 1 2 0   4     0   6   28 30                       58 45 1 2 0   4     0   6   28 30                 58
743974 743974 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No 1 PK 05 2015   grade_2 30 1 1 0   0     0   0   14 18                       32 30 1 1 0   0     0   0   14 18                 32
743980 743980 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No 1 KG 05 2015   grade_2 68 6 2 0   0     0   0   44 32                       76 68 6 2 0   0     0   0   44 32                 76
744070 744070 MA Berkshire   school 2502530 618   Berkshire Hills 250253001999 6180035 Muddy Brook Regional Elementary School   Regular School No 1 PK 04 2015   grade_2 54 1 3 0   2     0   7   39 28                       67 54 1 3 0   2     0   7   39 28                 67
744145 744145 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No 1 PK 05 2015   grade_2 15 0 1 0   0     0   0   11 5                       16 15 0 1 0   0     0   0   11 5                 16
744152 744152 MA Berkshire   school 2503390 635   Central Berkshire 250339002545 6350010 Berkshire Trail Elementary   Regular School No 1 PK 05 2015   grade_2 * * * *   *     *   *   3 1                       4                         3 1                 4
744159 744159 MA Berkshire   school 2503390 635   Central Berkshire 250339000462 6350025 Craneville   Regular School No 1 PK 05 2015   grade_2 63 1 2 0   2     0   3   37 34                       71 63 1 2 0   2     0   3   37 34                 71
744166 744166 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No 1 PK 05 2015   grade_2 21 1 1 0   0     0   1   14 10                       24 21 1 1 0   0     0   1   14 10                 24
744270 744270 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2015   grade_2 15 0 0 0   0     0   0   7 8                       15 15 0 0 0   0     0   0   7 8                 15
744789 744789 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No 1 PK 04 2015   grade_2 15 0 1 0   0     0   2   10 8                       18 15 0 1 0   0     0   2   10 8                 18
744797 744797 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No 1 PK 06 2015   grade_2 42 0 2 0   0     0   5   25 24                       49 42 0 2 0   0     0   5   25 24                 49
934462 934462 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2016   grade_2 28 0 0 0   0     0   1   14 15                       29 28 0 0 0   0     0   1   14 15                 29
935060 935060 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2016   grade_2 10 0 0 0   0     0   0   6 4                       10 10 0 0 0   0     0   0   6 4                 10

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