enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 6,780 ✖
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
1672309 1672309 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable - Hyannis West Elementary   Regular School No Elementary KG 03 2021   grade_1 21 13 17 0   0     0   10   26 35 *                     61.0 21 13 17 0   0     0   10   26 35                 61
1672313 1672313 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable - West Villages Elementary School   Regular School No Elementary KG 03 2021   grade_1 67 1 13 0   0     0   12   45 48 *                     93.0 67 1 13 0   0     0   12   45 48                 93
1673295 1673295 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne - Bournedale Elementary School   Regular School No Elementary PK 02 2021   grade_1 88 2 12 1   3     0   9   62 53 *                     115.0 88 2 12 1   3     0   9   62 53                 115
1673362 1673362 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster - Stony Brook Elementary   Regular School No Elementary PK 02 2021   grade_1 49 0 8 0   0     0   7   35 29 *                     64.0 49 0 8 0   0     0   7   35 29                 64
1674169 1674169 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham - Eastham Elementary   Regular School No Elementary PK 05 2021   grade_1 24 2 1 0   0     0   3   17 13 *                     30.0 24 2 1 0   0     0   3   17 13                 30
1674449 1674449 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth - East Falmouth Elementary   Regular School No Elementary PK 04 2021   grade_1 22 1 4 1   1     0   0   18 11 *                     29.0 22 1 4 1   1     0   0   18 11                 29
1674455 1674455 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth - Teaticket   Regular School No Elementary PK 04 2021   grade_1 32 4 7 0   1     0   3   27 20 *                     47.0 32 4 7 0   1     0   3   27 20                 47
1674460 1674460 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth - Mullen-Hall   Regular School No Elementary KG 04 2021   grade_1 61 1 11 0   4     0   11   54 34 *                     88.0 61 1 11 0   4     0   11   54 34                 88
1674465 1674465 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 Falmouth - North Falmouth Elementary   Regular School No Elementary KG 04 2021   grade_1 52 1 3 0   0     0   3   30 29 *                     59.0 52 1 3 0   0     0   3   30 29                 59
1676043 1676043 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee - Kenneth Coombs School   Regular School No Elementary PK 02 2021   grade_1 62 6 8 2   1     0   13   52 40 *                     92.0 62 6 8 2   1     0   13   52 40                 92
1677051 1677051 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans - Orleans Elementary   Regular School No Elementary KG 05 2021   grade_1 19 2 1 0   1     0   1   13 11 *                     24.0 19 2 1 0   1     0   1   13 11                 24
1677340 1677340 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_1 4 2 1 0   0     0   1   3 5 *                     8.0 4 2 1 0   0     0   1   3 5                 8
1677692 1677692 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Sandwich - Forestdale School   Regular School No Elementary PK 02 2021   grade_1 137 1 7 0   4     0   2   71 80 *                     151.0 137 1 7 0   4     0   2   71 80                 151
1678599 1678599 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro - Truro Central   Regular School No Elementary PK 06 2021   grade_1 8 1 0 0   0     0   4   7 6 *                     13.0 8 1 0 0   0     0   4   7 6                 13
1678915 1678915 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet - Wellfleet Elementary   Regular School No Elementary KG 05 2021   grade_1 13 0 0 0   0     0   3   11 5 *                     16.0 13 0 0 0   0     0   3   11 5                 16
1680502 1680502 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Dennis-Yarmouth - Ezra H Baker Innovation School   Regular School No Elementary PK 03 2021   grade_1 49 7 10 0   2     0   4   29 43 *                     72.0 49 7 10 0   2     0   4   29 43                 72
1680507 1680507 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Dennis-Yarmouth - Marguerite E Small Elementary   Regular School No Elementary PK 03 2021   grade_1 28 4 15 1   0     0   3   30 21 *                     51.0 28 4 15 1   0     0   3   30 21                 51
1680511 1680511 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Dennis-Yarmouth - Station Avenue Elementary   Regular School No Elementary KG 03 2021   grade_1 78 11 7 0   5     0   3   58 46 *                     104.0 78 11 7 0   5     0   3   58 46                 104
1680816 1680816 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_1 24 3 7 0   0     0   2   21 15 *                     36.0 24 3 7 0   0     0   2   21 15                 36
1680822 1680822 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_1 56 4 9 0   0     0   9   48 30 *                     78.0 56 4 9 0   0     0   9   48 30                 78
2040103 2040103 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2019   grade_1 51 3 6 0   0     0   7   39 28                       67.0 51 3 6 0   0     0   7   39 28                 67
2040107 2040107 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2019   grade_1 45 4 7 0   1     0   6   34 29                       63.0 45 4 7 0   1     0   6   34 29                 63
2040111 2040111 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2019   grade_1 32 9 21 0   2     0   13   35 42                       77.0 32 9 21 0   2     0   13   35 42                 77
2040115 2040115 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2019   grade_1 88 2 12 0   0     0   10   57 55                       112.0 88 2 12 0   0     0   10   57 55                 112
2041113 2041113 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2019   grade_1 65 3 4 1   0     0   1   41 33                       74.0 65 3 4 1   0     0   1   41 33                 74
2041118 2041118 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No Elementary KG 04 2019   grade_1 56 0 4 0   1     0   4   26 39                       65.0 56 0 4 0   1     0   4   26 39                 65
2041196 2041196 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2019   grade_1 53 0 1 0   0     0   1   34 21                       55.0 53 0 1 0   0     0   1   34 21                 55
2042010 2042010 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2019   grade_1 23 3 1 0   0     0   0   18 9                       27.0 23 3 1 0   0     0   0   18 9                 27
2042285 2042285 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary KG 04 2019   grade_1 33 2 4 1   0     0   7   24 23                       47.0 33 2 4 1   0     0   7   24 23                 47
2042291 2042291 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2019   grade_1 35 3 6 1   1     0   5   31 20                       51.0 35 3 6 1   1     0   5   31 20                 51
2042296 2042296 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2019   grade_1 65 3 9 0   2     0   7   57 29                       86.0 65 3 9 0   2     0   7   57 29                 86
2042301 2042301 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2019   grade_1 62 3 7 0   1     0   3   38 38                       76.0 62 3 7 0   1     0   3   38 38                 76
2043864 2043864 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   grade_1 85 2 4 6   3     0   14   66 48                       114.0 85 2 4 6   3     0   14   66 48                 114
2044877 2044877 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2019   grade_1 28 1 6 0   0     0   2   17 20                       37.0 28 1 6 0   0     0   2   17 20                 37
2045166 2045166 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   grade_1 8 2 1 0   0     0   0   3 8                       11.0 8 2 1 0   0     0   0   3 8                 11
2045515 2045515 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2019   grade_1 156 2 12 0   5     0   3   89 89                       178.0 156 2 12 0   5     0   3   89 89                 178
2046423 2046423 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2019   grade_1 9 0 1 0   0     0   3   4 9                       13.0 9 0 1 0   0     0   3   4 9                 13
2046739 2046739 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2019   grade_1 14 0 0 0   0     0   2   10 6                       16.0 14 0 0 0   0     0   2   10 6                 16
2047606 2047606 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_1 43 11 24 1   1     0   2   45 37                       82.0 43 11 24 1   1     0   2   45 37                 82
2048300 2048300 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2019   grade_1 35 7 9 0   0     1   6   33 25                       58.0 35 7 9 0   0     1   6   33 25                 58
2048305 2048305 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2019   grade_1 29 8 10 1   2     0   2   26 26                       52.0 29 8 10 1   2     0   2   26 26                 52
2048309 2048309 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2019   grade_1 75 6 8 1   5     1   3   46 53                       99.0 75 6 8 1   5     1   3   46 53                 99
2048614 2048614 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2019   grade_1 26 1 3 0   0     0   2   10 22                       32.0 26 1 3 0   0     0   2   10 22                 32
2048620 2048620 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2019   grade_1 79 6 9 1   2     0   12   66 43                       109.0 79 6 9 1   2     0   12   66 43                 109
2229106 2229106 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable: West Barnstable Elementary   Regular School No Elementary KG 03 2018   grade_1 49 4 6 0   1     0   3   33 30                       63.0 49 4 6 0   1     0   3   33 30                 63
2229111 2229111 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable: Centerville Elementary   Regular School No Elementary KG 03 2018   grade_1 36 3 4 0   2     0   3   28 20                       48.0 36 3 4 0   2     0   3   28 20                 48
2229116 2229116 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable: Hyannis West Elementary   Regular School No Elementary KG 03 2018   grade_1 32 16 19 0   2     0   8   32 45                       77.0 32 16 19 0   2     0   8   32 45                 77
2229121 2229121 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable: West Villages Elementary School   Regular School No Elementary KG 03 2018   grade_1 97 3 5 0   1     0   4   58 52                       110.0 97 3 5 0   1     0   4   58 52                 110
2230281 2230281 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne: Bournedale Elementary School   Regular School No Elementary PK 04 2018   grade_1 61 1 1 2   0     0   2   31 36                       67.0 61 1 1 2   0     0   2   31 36                 67
2230287 2230287 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Bourne: Peebles Elementary School   Regular School No Elementary KG 04 2018   grade_1 48 0 6 0   3     0   1   32 26                       58.0 48 0 6 0   3     0   1   32 26                 58
2230379 2230379 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster: Stony Brook Elementary   Regular School No Elementary PK 02 2018   grade_1 65 3 5 0   0     0   5   34 44                       78.0 65 3 5 0   0     0   5   34 44                 78
2231328 2231328 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham: Eastham Elementary   Regular School No Elementary PK 05 2018   grade_1 24 1 0 0   0     0   1   13 13                       26.0 24 1 0 0   0     0   1   13 13                 26
2231659 2231659 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 Falmouth: East Falmouth Elementary   Regular School No Elementary KG 04 2018   grade_1 36 2 3 3   0     0   4   28 20                       48.0 36 2 3 3   0     0   4   28 20                 48
2231666 2231666 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Falmouth: Teaticket   Regular School No Elementary PK 04 2018   grade_1 34 9 2 2   0     0   8   26 29                       55.0 34 9 2 2   0     0   8   26 29                 55
2231672 2231672 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Falmouth: Mullen-Hall   Regular School No Elementary KG 04 2018   grade_1 63 1 6 1   2     0   8   47 34                       81.0 63 1 6 1   2     0   8   47 34                 81
2231678 2231678 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 Falmouth: North Falmouth Elementary   Regular School No Elementary KG 04 2018   grade_1 41 3 2 0   1     0   1   28 20                       48.0 41 3 2 0   1     0   1   28 20                 48
2233554 2233554 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee: Kenneth Coombs School   Regular School No Elementary PK 02 2018   grade_1 68 5 6 8   2     1   11   47 54                       101.0 68 5 6 8   2     1   11   47 54                 101
2234757 2234757 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans: Orleans Elementary   Regular School No Elementary KG 05 2018   grade_1 31 3 2 0   0     0   0   15 21                       36.0 31 3 2 0   0     0   0   15 21                 36
2235094 2235094 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown: Provincetown Schools   Regular School No Elementary PK 08 2018   grade_1 5 4 3 0   0     0   0   4 8                       12.0 5 4 3 0   0     0   0   4 8                 12
2235514 2235514 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Sandwich: Forestdale School   Regular School No Elementary PK 02 2018   grade_1 164 3 11 1   5     0   4   92 96                       188.0 164 3 11 1   5     0   4   92 96                 188
2236577 2236577 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro: Truro Central   Regular School No Elementary PK 05 2018   grade_1 9 1 1 0   0     0   1   4 8                       12.0 9 1 1 0   0     0   1   4 8                 12
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
2238024 2238024 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_1 37 16 19 0   3     0   3   35 43                       78.0 37 16 19 0   3     0   3   35 43                 78
2238811 2238811 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Dennis-Yarmouth: Ezra H Baker Innovation School   Regular School No Elementary PK 04 2018   grade_1 52 5 6 2   1     0   11   43 34                       77.0 52 5 6 2   1     0   11   43 34                 77
2238818 2238818 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Dennis-Yarmouth: Marguerite E Small Elementary   Regular School No Elementary PK 03 2018   grade_1 31 5 7 3   0     1   5   35 17                       52.0 31 5 7 3   0     1   5   35 17                 52
2238823 2238823 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Dennis-Yarmouth: Station Avenue Elementary   Regular School No Elementary KG 03 2018   grade_1 70 10 6 5   2     1   6   61 39                       100.0 70 10 6 5   2     1   6   61 39                 100
2239185 2239185 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_1 32 5 5 0   0     1   2   27 18                       45.0 32 5 5 0   0     1   2   27 18                 45
2239192 2239192 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_1 80 6 6 0   0     0   5   44 53                       97.0 80 6 6 0   0     0   5   44 53                 97
737601 737601 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   grade_1 24 0 0 0   0     0   1   13 12                       25 24 0 0 0   0     0   1   13 12                 25
738205 738205 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_1 10 0 0 0   0     0   0   5 5                       10 10 0 0 0   0     0   0   5 5                 10
738515 738515 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No 1 PK 06 2015   grade_1 * * * *   *     *   *   1 4                       5                         1 4                 5
738881 738881 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   grade_1 27 0 0 0   1     0   1   19 10                       29 27 0 0 0   1     0   1   19 10                 29
739028 739028 MA Berkshire   school 2506690 150   Lee 250669000969 1500025 Lee Elementary   Regular School No 1 PK 06 2015   grade_1 37 0 5 0   2     0   1   20 25                       45 37 0 5 0   2     0   1   20 25                 45
739056 739056 MA Berkshire   school 2506750 152   Lenox 250675000979 1520015 Morris   Regular School No 1 PK 05 2015   grade_1 42 0 2 0   2     0   2   28 20                       48 42 0 2 0   2     0   2   28 20                 48
740428 740428 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 J S Sullivan   Regular School No 1 KG 07 2015   grade_1 28 3 2 0   0     0   1   16 18                       34 28 3 2 0   0     0   1   16 18                 34
740436 740436 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No 1 KG 07 2015   grade_1 31 0 2 0   0     0   3   19 17                       36 31 0 2 0   0     0   3   19 17                 36
740445 740445 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2015   grade_1 46 1 3 0   0     1   5   31 25                       56 46 1 3 0   0     1   5   31 25                 56
740891 740891 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No 1 KG 05 2015   grade_1 33 3 9 0   1     0   2   25 23                       48 33 3 9 0   1     0   2   25 23                 48
740897 740897 MA Berkshire   school 2509630 236   Pittsfield 250963001519 2360035 Egremont   Regular School No 1 KG 05 2015   grade_1 60 3 5 0   1     0   10   37 42                       79 60 3 5 0   1     0   10   37 42                 79
740904 740904 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No 1 PK 05 2015   grade_1 31 0 1 0   0     0   5   19 18                       37 31 0 1 0   0     0   5   19 18                 37
740911 740911 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Morningside Community School   Regular School No 1 PK 05 2015   grade_1 43 10 9 1   2     1   9   33 42                       75 43 10 9 1   2     1   9   33 42                 75
740918 740918 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No 1 PK 05 2015   grade_1 26 6 5 0   0     0   8   28 17                       45 26 6 5 0   0     0   8   28 17                 45
740924 740924 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Stearns   Regular School No 1 KG 05 2015   grade_1 34 1 4 0   0     0   1   25 15                       40 34 1 4 0   0     0   1   25 15                 40
740930 740930 MA Berkshire   school 2509630 236   Pittsfield 250963001536 2360100 Williams   Regular School No 1 KG 05 2015   grade_1 39 3 2 0   5     0   2   28 23                       51 39 3 2 0   5     0   2   28 23                 51
740937 740937 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No 1 PK 05 2015   grade_1 22 12 11 1   1     0   10   28 29                       57 22 12 11 1   1     0   10   28 29                 57
741270 741270 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_1 11 0 1 0   0     0   0   3 9                       12 11 0 1 0   0     0   0   3 9                 12
741452 741452 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No 1 PK 05 2015   grade_1 9 0 0 0   0     0   0   1 8                       9 9 0 0 0   0     0   0   1 8                 9
742944 742944 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No 1 PK 06 2015   grade_1 43 1 6 0   2     0   2   30 24                       54 43 1 6 0   2     0   2   30 24                 54
743973 743973 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No 1 PK 05 2015   grade_1 28 0 1 0   0     0   0   18 11                       29 28 0 1 0   0     0   0   18 11                 29
743979 743979 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No 1 KG 05 2015   grade_1 73 3 2 0   0     0   2   41 39                       80 73 3 2 0   0     0   2   41 39                 80
744069 744069 MA Berkshire   school 2502530 618   Berkshire Hills 250253001999 6180035 Muddy Brook Regional Elementary School   Regular School No 1 PK 04 2015   grade_1 52 1 5 0   2     0   6   40 26                       66 52 1 5 0   2     0   6   40 26                 66
744144 744144 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No 1 PK 05 2015   grade_1 15 0 0 0   0     0   0   9 6                       15 15 0 0 0   0     0   0   9 6                 15
744151 744151 MA Berkshire   school 2503390 635   Central Berkshire 250339002545 6350010 Berkshire Trail Elementary   Regular School No 1 PK 05 2015   grade_1 12 0 0 0   0     0   0   5 7                       12 12 0 0 0   0     0   0   5 7                 12
744158 744158 MA Berkshire   school 2503390 635   Central Berkshire 250339000462 6350025 Craneville   Regular School No 1 PK 05 2015   grade_1 58 0 1 0   0     0   1   33 27                       60 58 0 1 0   0     0   1   33 27                 60
744165 744165 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No 1 PK 05 2015   grade_1 11 0 2 0   0     0   0   6 7                       13 11 0 2 0   0     0   0   6 7                 13
744269 744269 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2015   grade_1 18 0 0 0   0     0   0   11 7                       18 18 0 0 0   0     0   0   11 7                 18
744788 744788 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No 1 PK 04 2015   grade_1 13 0 0 0   0     0   0   9 4                       13 13 0 0 0   0     0   0   9 4                 13
744793 744793 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No 1 KG 01 2015   grade_1 * * * *   *     *   *   * 2                       5                           2                 5
744796 744796 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No 1 PK 06 2015   grade_1 26 1 2 0   0     0   0   12 17                       29 26 1 2 0   0     0   0   12 17                 29
934461 934461 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2016   grade_1 16 0 1 0   0     0   0   10 7                       17 16 0 1 0   0     0   0   10 7                 17

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