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,831 ✖
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
735953 735953 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2015   grade_2 54 1 6 0   2     0   3   32 34                       66 54 1 6 0   2     0   3   32 34                 66
735958 735958 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   grade_2 72 2 9 0   0     0   5   44 44                       88 72 2 9 0   0     0   5   44 44                 88
735962 735962 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   grade_2 54 17 14 1   1     1   6   42 52                       94 54 17 14 1   1     1   6   42 52                 94
735966 735966 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   grade_2 118 6 5 0   2     0   4   76 59                       135 118 6 5 0   2     0   4   76 59                 135
736967 736967 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2015   grade_2 62 0 3 0   1     0   0   36 30                       66 62 0 3 0   1     0   0   36 30                 66
736972 736972 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2015   grade_2 73 0 3 2   1     0   7   51 35                       86 73 0 3 2   1     0   7   51 35                 86
737047 737047 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2015   grade_2 66 0 2 0   1     0   2   38 33                       71 66 0 2 0   1     0   2   38 33                 71
737862 737862 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2015   grade_2 36 2 0 1   0     0   0   17 22                       39 36 2 0 1   0     0   0   17 22                 39
738130 738130 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2015   grade_2 33 7 0 1   1     0   1   24 19                       43 33 7 0 1   1     0   1   24 19                 43
738136 738136 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   grade_2 43 1 3 0   4     0   5   28 28                       56 43 1 3 0   4     0   5   28 28                 56
738141 738141 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   grade_2 81 4 7 0   3     0   7   52 50                       102 81 4 7 0   3     0   7   52 50                 102
738146 738146 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2015   grade_2 60 1 4 0   1     0   3   36 33                       69 60 1 4 0   1     0   3   36 33                 69
739724 739724 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   grade_2 97 3 3 8   3     0   9   59 64                       123 97 3 3 8   3     0   9   59 64                 123
740749 740749 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No 1 KG 05 2015   grade_2 29 1 0 0   1     0   0   17 14                       31 29 1 0 0   1     0   0   17 14                 31
741038 741038 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2015   grade_2 * * * *   *     *   *   3 2                       5                         3 2                 5
741392 741392 MA Barnstable   school 2510470 261   Sandwich 251047001672 2610005 Henry T Wing   Regular School No 1 PK 06 2015   grade_2 64 2 1 0   2     0   0   44 25                       69 64 2 1 0   2     0   0   44 25                 69
741399 741399 MA Barnstable   school 2510470 261   Sandwich 251047002534 2610010 Forestdale   Regular School No 1 KG 06 2015   grade_2 73 1 0 1   0     0   0   36 39                       75 73 1 0 1   0     0   0   36 39                 75
741406 741406 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 KG 06 2015   grade_2 66 2 0 0   1     0   0   32 37                       69 66 2 0 0   1     0   0   32 37                 69
742299 742299 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No 1 PK 06 2015   grade_2 13 1 3 0   0     0   1   5 13                       18 13 1 3 0   0     0   1   5 13                 18
742614 742614 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No 1 PK 05 2015   grade_2 27 0 3 0   0     0   0   11 19                       30 27 0 3 0   0     0   0   11 19                 30
743487 743487 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes 1 KG 03 2015   grade_2 57 7 4 0   5     1   1   31 44                       75 57 7 4 0   5     1   1   31 44                 75
744185 744185 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No 1 PK 03 2015   grade_2 78 10 14 2   4     0   6   56 58                       114 78 10 14 2   4     0   6   56 58                 114
744190 744190 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No 1 PK 03 2015   grade_2 34 1 4 1   1     0   6   30 17                       47 34 1 4 1   1     0   6   30 17                 47
744194 744194 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No 1 KG 03 2015   grade_2 84 8 10 2   2     0   4   55 55                       110 84 8 10 2   2     0   4   55 55                 110
744497 744497 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No 1 PK 04 2015   grade_2 47 2 2 0   0     0   1   34 18                       52 47 2 2 0   0     0   1   34 18                 52
744503 744503 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No 1 PK 04 2015   grade_2 112 6 8 0   0     0   0   64 62                       126 112 6 8 0   0     0   0   64 62                 126
932828 932828 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2016   grade_2 56 3 9 0   2     0   1   38 33                       71 56 3 9 0   2     0   1   38 33                 71
932832 932832 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 KG 03 2016   grade_2 70 1 8 1   2     0   0   46 36                       82 70 1 8 1   2     0   0   46 36                 82
932836 932836 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2016   grade_2 43 10 20 0   2     1   9   52 33                       85 43 10 20 0   2     1   9   52 33                 85
932840 932840 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2016   grade_2 91 2 8 1   2     1   6   49 62                       111 91 2 8 1   2     1   6   49 62                 111
933832 933832 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2016   grade_2 65 0 0 1   1     0   0   33 34                       67 65 0 0 1   1     0   0   33 34                 67
933837 933837 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2016   grade_2 59 2 1 3   2     0   5   34 38                       72 59 2 1 3   2     0   5   34 38                 72
933914 933914 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2016   grade_2 72 0 4 0   1     0   5   44 38                       82 72 0 4 0   1     0   5   44 38                 82
934716 934716 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2016   grade_2 20 1 0 0   1     0   1   13 10                       23 20 1 0 0   1     0   1   13 10                 23
934984 934984 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2016   grade_2 54 1 1 2   0     0   5   38 25                       63 54 1 1 2   0     0   5   38 25                 63
934990 934990 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2016   grade_2 34 3 0 4   1     0   5   26 21                       47 34 3 0 4   1     0   5   26 21                 47
934995 934995 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2016   grade_2 78 0 3 3   3     0   5   50 42                       92 78 0 3 3   3     0   5   50 42                 92
935000 935000 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2016   grade_2 57 1 7 0   0     0   3   32 36                       68 57 1 7 0   0     0   3   32 36                 68
936568 936568 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2016   grade_2 101 5 4 8   1     0   6   62 63                       125 101 5 4 8   1     0   6   62 63                 125
937577 937577 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No 1 KG 05 2016   grade_2 41 0 1 0   3     0   0   27 18                       45 41 0 1 0   3     0   0   27 18                 45
937867 937867 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2016   grade_2 13 0 0 0   0     0   2   8 7                       15 13 0 0 0   0     0   2   8 7                 15
938213 938213 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No 1 PK 02 2016   grade_2 190 4 3 1   6     0   3   102 105                       207 190 4 3 1   6     0   3   102 105                 207
939107 939107 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No 1 PK 06 2016   grade_2 10 1 2 0   0     0   1   7 7                       14 10 1 2 0   0     0   1   7 7                 14
939422 939422 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No 1 PK 05 2016   grade_2 8 0 0 0   0     0   1   3 6                       9 8 0 0 0   0     0   1   3 6                 9
940306 940306 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes 1 KG 03 2016   grade_2 46 3 9 2   0     0   1   29 32                       61 46 3 9 2   0     0   1   29 32                 61
941011 941011 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No 1 PK 03 2016   grade_2 59 15 11 1   1     0   4   48 43                       91 59 15 11 1   1     0   4   48 43                 91
941016 941016 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No 1 PK 03 2016   grade_2 36 6 13 3   1     0   7   32 34                       66 36 6 13 3   1     0   7   32 34                 66
941020 941020 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No 1 KG 03 2016   grade_2 80 7 14 3   2     0   8   56 58                       114 80 7 14 3   2     0   8   56 58                 114
941321 941321 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No 1 PK 04 2016   grade_2 42 2 4 0   0     0   3   18 33                       51 42 2 4 0   0     0   3   18 33                 51
941327 941327 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No 1 PK 04 2016   grade_2 78 7 7 2   1     0   7   47 55                       102 78 7 7 2   1     0   7   47 55                 102
1122301 1122301 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2017   grade_2 55 5 2 0   0     0   5   37 30                       67 55 5 2 0   0     0   5   37 30                 67
1122306 1122306 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2017   grade_2 64 5 8 0   1     0   1   39 40                       79 64 5 8 0   1     0   1   39 40                 79
1122311 1122311 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2017   grade_2 37 16 23 0   3     0   11   50 40                       90 37 16 23 0   3     0   11   50 40                 90
1122316 1122316 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2017   grade_2 110 3 4 1   0     0   4   58 64                       122 110 3 4 1   0     0   4   58 64                 122
1123464 1123464 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2017   grade_2 79 1 7 1   0     0   3   54 37                       91 79 1 7 1   0     0   3   54 37                 91
1123470 1123470 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No Elementary KG 04 2017   grade_2 64 2 1 0   1     0   2   28 42                       70 64 2 1 0   1     0   2   28 42                 70
1123562 1123562 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2017   grade_2 64 2 7 0   2     0   4   36 43                       79 64 2 7 0   2     0   4   36 43                 79
1124512 1124512 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2017   grade_2 23 0 0 1   0     0   1   9 16                       25 23 0 0 1   0     0   1   9 16                 25
1124833 1124833 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2017   grade_2 48 5 3 1   1     0   1   24 35                       59 48 5 3 1   1     0   1   24 35                 59
1124840 1124840 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2017   grade_2 50 3 2 0   1     0   2   34 24                       58 50 3 2 0   1     0   2   34 24                 58
1124846 1124846 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2017   grade_2 81 6 5 1   2     0   3   52 46                       98 81 6 5 1   2     0   3   52 46                 98
1124852 1124852 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2017   grade_2 65 0 3 0   2     0   4   35 39                       74 65 0 3 0   2     0   4   35 39                 74
1126734 1126734 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   grade_2 67 1 7 9   1     0   10   44 51                       95 67 1 7 9   1     0   10   44 51                 95
1127936 1127936 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2017   grade_2 32 1 0 0   0     0   0   22 11                       33 32 1 0 0   0     0   0   22 11                 33
1128274 1128274 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   grade_2 9 2 0 0   0     0   1   5 7                       12 9 2 0 0   0     0   1   5 7                 12
1128693 1128693 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2017   grade_2 169 3 6 0   2     0   1   94 87                       181 169 3 6 0   2     0   1   94 87                 181
1129762 1129762 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_2 9 0 0 0   0     0   2   9 2                       11 9 0 0 0   0     0   2   9 2                 11
1130135 1130135 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2017   grade_2 13 0 2 0   0     0   0   8 7                       15 13 0 2 0   0     0   0   8 7                 15
1131197 1131197 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 2017   grade_2 47 3 14 1   3     1   5   41 33                       74 47 3 14 1   3     1   5   41 33                 74
1131982 1131982 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2017   grade_2 70 6 8 1   2     0   8   49 46                       95 70 6 8 1   2     0   8   49 46                 95
1131988 1131988 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2017   grade_2 31 2 10 4   0     0   6   30 23                       53 31 2 10 4   0     0   6   30 23                 53
1131993 1131993 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2017   grade_2 83 6 2 3   1     0   11   54 52                       106 83 6 2 3   1     0   11   54 52                 106
1132355 1132355 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2017   grade_2 51 4 1 0   0     0   1   26 31                       57 51 4 1 0   0     0   1   26 31                 57
1132362 1132362 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2017   grade_2 85 2 7 1   0     0   8   49 54                       103 85 2 7 1   0     0   8   49 54                 103
1365074 1365074 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   grade_2 47 2 6 0   0     0   7   36 26 *                     62.0 47 2 6 0   0     0   7   36 26                 62
1365078 1365078 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   grade_2 42 4 6 0   1     0   7   34 26 *                     60.0 42 4 6 0   1     0   7   34 26                 60
1365082 1365082 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   grade_2 44 11 25 1   1     0   2   42 42 *                     84.0 44 11 25 1   1     0   2   42 42                 84
1365086 1365086 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2020   grade_2 29 11 28 0   3     0   13   35 49 *                     84.0 29 11 28 0   3     0   13   35 49                 84
1365090 1365090 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2020   grade_2 89 2 14 0   0     0   10   59 56 *                     115.0 89 2 14 0   0     0   10   59 56                 115
1366060 1366060 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 02 2020   grade_2 125 3 8 0   1     0   6   68 75 *                     143.0 125 3 8 0   1     0   6   68 75                 143
1366130 1366130 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2020   grade_2 54 0 1 0   0     0   2   36 21 *                     57.0 54 0 1 0   0     0   2   36 21                 57
1366940 1366940 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2020   grade_2 22 4 1 0   0     0   0   17 10 *                     27.0 22 4 1 0   0     0   0   17 10                 27
1367216 1367216 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2020   grade_2 30 2 5 1   1     0   5   20 24 *                     44.0 30 2 5 1   1     0   5   20 24                 44
1367222 1367222 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2020   grade_2 33 4 7 0   1     0   5   31 19 *                     50.0 33 4 7 0   1     0   5   31 19                 50
1367227 1367227 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2020   grade_2 69 3 8 0   1     0   8   59 30 *                     89.0 69 3 8 0   1     0   8   59 30                 89
1367232 1367232 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2020   grade_2 65 3 7 0   1     0   3   39 40 *                     79.0 65 3 7 0   1     0   3   39 40                 79
1368794 1368794 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2020   grade_2 83 2 4 6   1     0   15   68 43 *                     111.0 83 2 4 6   1     0   15   68 43                 111
1369805 1369805 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2020   grade_2 25 1 6 0   0     0   2   14 20 *                     34.0 25 1 6 0   0     0   2   14 20                 34
1370093 1370093 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_2 7 1 1 0   0     0   0   4 5 *                     9.0 7 1 1 0   0     0   0   4 5                 9
1370442 1370442 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2020   grade_2 165 0 14 0   3     1   5   92 96 *                     188.0 165 0 14 0   3     1   5   92 96                 188
1371348 1371348 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   grade_2 10 0 1 0   0     0   3   4 10 *                     14.0 10 0 1 0   0     0   3   4 10                 14
1371666 1371666 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary KG 05 2020   grade_2 14 0 0 0   0     0   1   9 6 *                     15.0 14 0 0 0   0     0   1   9 6                 15
1373239 1373239 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2020   grade_2 32 7 12 0   0     1   6   30 28 *                     58.0 32 7 12 0   0     1   6   30 28                 58
1373244 1373244 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2020   grade_2 31 8 8 1   2     0   2   25 27 *                     52.0 31 8 8 1   2     0   2   25 27                 52
1373248 1373248 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2020   grade_2 71 7 9 1   5     1   3   42 55 *                     97.0 71 7 9 1   5     1   3   42 55                 97
1373554 1373554 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2020   grade_2 25 1 3 0   0     0   2   9 22 *                     31.0 25 1 3 0   0     0   2   9 22                 31
1373560 1373560 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2020   grade_2 88 6 9 1   2     0   10   68 48 *                     116.0 88 6 9 1   2     0   10   68 48                 116
1672298 1672298 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable - West Barnstable Elementary   Regular School No Elementary KG 03 2021   grade_2 35 1 4 0   2     0   8   22 28 *                     50.0 35 1 4 0   2     0   8   22 28                 50
1672302 1672302 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable - Centerville Elementary   Regular School No Elementary KG 03 2021   grade_2 43 5 12 0   0     0   4   38 26 *                     64.0 43 5 12 0   0     0   4   38 26                 64
1672306 1672306 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   grade_2 36 7 24 0   5     0   6   38 39 *                     78.0 36 7 24 0   5     0   6   38 39                 78

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