Data source: Big Local News · About: Big Local

6,747 rows where grade = "kindergarten" and state = "MA" sorted by county

View and edit SQL

year

grade

  • kindergarten · 6,747
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
735951 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2015   kindergarten 49 4 3 0   0     0   3   34 25                       59 49 4 3 0   0     0   3   34 25                 59
735955 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 PK 03 2015   kindergarten 69 7 8 0   0     0   1   42 43                       85 69 7 8 0   0     0   1   42 43                 85
735960 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2015   kindergarten 32 11 19 1   3     0   15   46 35                       81 32 11 19 1   3     0   15   46 35                 81
735964 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2015   kindergarten 83 2 3 2   1     0   3   43 51                       94 83 2 3 2   1     0   3   43 51                 94
736964 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2015   kindergarten 84 4 4 1   1     0   2   63 33                       96 84 4 4 1   1     0   2   63 33                 96
736970 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2015   kindergarten 36 0 2 0   1     0   1   19 21                       40 36 0 2 0   1     0   1   19 21                 40
737044 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2015   kindergarten 67 0 7 0   1     0   2   34 43                       77 67 0 7 0   1     0   2   34 43                 77
737859 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2015   kindergarten 22 2 1 1   0     0   2   11 17                       28 22 2 1 1   0     0   2   11 17                 28
738127 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2015   kindergarten 40 6 1 1   1     0   2   21 30                       51 40 6 1 1   1     0   2   21 30                 51
738133 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2015   kindergarten 57 2 1 0   1     0   2   38 25                       63 57 2 1 0   1     0   2   38 25                 63
738139 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2015   kindergarten 77 6 8 1   2     0   3   53 44                       97 77 6 8 1   2     0   3   53 44                 97
738144 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2015   kindergarten 65 0 7 0   2     0   4   42 36                       78 65 0 7 0   2     0   4   42 36                 78
739721 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2015   kindergarten 74 2 11 9   1     0   9   52 54                       106 74 2 11 9   1     0   9   52 54                 106
740747 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No 1 KG 05 2015   kindergarten 31 0 0 0   0     0   0   19 12                       31 31 0 0 0   0     0   0   19 12                 31
741035 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2015   kindergarten 8 1 0 0   0     0   2   2 9                       11 8 1 0 0   0     0   2   2 9                 11
741389 MA Barnstable   school 2510470 261   Sandwich 251047001672 2610005 Henry T Wing   Regular School No 1 PK 06 2015   kindergarten 45 1 0 0   1     0   0   24 23                       47 45 1 0 0   1     0   0   24 23                 47
741397 MA Barnstable   school 2510470 261   Sandwich 251047002534 2610010 Forestdale   Regular School No 1 KG 06 2015   kindergarten 64 1 1 0   2     0   0   35 33                       68 64 1 1 0   2     0   0   35 33                 68
741404 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 KG 06 2015   kindergarten 59 0 0 0   1     0   0   30 30                       60 59 0 0 0   1     0   0   30 30                 60
742296 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No 1 PK 06 2015   kindergarten 10 0 0 0   0     0   2   10 2                       12 10 0 0 0   0     0   2   10 2                 12
742611 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No 1 PK 05 2015   kindergarten 13 0 1 0   0     0   0   8 6                       14 13 0 1 0   0     0   0   8 6                 14
743485 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   kindergarten 48 7 14 1   3     1   1   39 36                       75 48 7 14 1   3     1   1   39 36                 75
744182 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No 1 PK 03 2015   kindergarten 71 8 3 1   1     0   8   47 45                       92 71 8 3 1   1     0   8   47 45                 92
744187 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No 1 PK 03 2015   kindergarten 28 2 12 2   1     0   9   28 26                       54 28 2 12 2   1     0   9   28 26                 54
744192 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No 1 KG 03 2015   kindergarten 79 4 3 2   1     0   10   51 48                       99 79 4 3 2   1     0   10   51 48                 99
744494 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No 1 PK 04 2015   kindergarten 45 3 1 0   1     0   1   23 28                       51 45 3 1 0   1     0   1   23 28                 51
744500 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No 1 PK 04 2015   kindergarten 79 2 8 2   1     0   10   50 52                       102 79 2 8 2   1     0   10   50 52                 102
932826 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No 1 KG 03 2016   kindergarten 52 0 2 0   1     0   0   30 25                       55 52 0 2 0   1     0   0   30 25                 55
932830 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No 1 KG 03 2016   kindergarten 54 8 9 1   0     0   1   43 30                       73 54 8 9 1   0     0   1   43 30                 73
932834 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No 1 KG 03 2016   kindergarten 24 11 24 0   2     0   3   30 34                       64 24 11 24 0   2     0   3   30 34                 64
932838 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No 1 KG 03 2016   kindergarten 96 2 3 0   1     0   4   59 47                       106 96 2 3 0   1     0   4   59 47                 106
933829 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No 1 PK 04 2016   kindergarten 67 2 7 1   1     2   6   48 38                       86 67 2 7 1   1     2   6   48 38                 86
933835 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No 1 KG 04 2016   kindergarten 34 2 1 0   0     0   2   21 18                       39 34 2 1 0   0     0   2   21 18                 39
933911 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No 1 PK 02 2016   kindergarten 57 2 4 0   0     0   5   36 32                       68 57 2 4 0   0     0   5   36 32                 68
934713 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No 1 PK 05 2016   kindergarten 25 2 3 0   0     0   0   13 17                       30 25 2 3 0   0     0   0   13 17                 30
934981 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No 1 PK 04 2016   kindergarten 36 2 4 0   1     0   7   30 20                       50 36 2 4 0   1     0   7   30 20                 50
934987 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No 1 PK 04 2016   kindergarten 48 7 6 0   1     0   3   27 38                       65 48 7 6 0   1     0   3   27 38                 65
934993 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No 1 KG 04 2016   kindergarten 75 1 2 0   4     0   6   47 41                       88 75 1 2 0   4     0   6   47 41                 88
934998 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No 1 KG 04 2016   kindergarten 49 2 1 0   1     0   4   23 34                       57 49 2 1 0   1     0   4   23 34                 57
936565 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No 1 PK 02 2016   kindergarten 86 5 10 8   2     0   9   61 59                       120 86 5 10 8   2     0   9   61 59                 120
937575 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No 1 KG 05 2016   kindergarten 28 0 3 0   1     0   1   14 19                       33 28 0 3 0   1     0   1   14 19                 33
937864 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2016   kindergarten 6 2 2 0   0     0   3   8 5                       13 6 2 2 0   0     0   3   8 5                 13
938210 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No 1 PK 02 2016   kindergarten 187 2 7 0   5     2   0   96 107                       203 187 2 7 0   5     2   0   96 107                 203
939104 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No 1 PK 06 2016   kindergarten 8 1 2 0   0     0   3   7 7                       14 8 1 2 0   0     0   3   7 7                 14
939419 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No 1 PK 05 2016   kindergarten 12 1 1 0   0     0   3   7 10                       17 12 1 1 0   0     0   3   7 10                 17
940304 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   kindergarten 29 28 13 0   3     0   6   38 41                       79 29 28 13 0   3     0   6   38 41                 79
941008 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No 1 PK 03 2016   kindergarten 63 7 7 1   1     0   10   50 39                       89 63 7 7 1   1     0   10   50 39                 89
941013 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No 1 PK 03 2016   kindergarten 41 5 8 2   1     0   7   36 28                       64 41 5 8 2   1     0   7   36 28                 64
941018 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No 1 KG 03 2016   kindergarten 93 3 10 2   2     0   14   66 58                       124 93 3 10 2   2     0   14   66 58                 124
941318 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No 1 PK 04 2016   kindergarten 35 1 3 0   2     0   0   17 24                       41 35 1 3 0   2     0   0   17 24                 41
941324 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No 1 PK 04 2016   kindergarten 76 4 3 1   2     0   8   56 38                       94 76 4 3 1   2     0   8   56 38                 94
1122299 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2017   kindergarten 48 5 5 0   2     0   1   33 28                       61 48 5 5 0   2     0   1   33 28                 61
1122304 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2017   kindergarten 44 3 4 0   1     0   4   32 24                       56 44 3 4 0   1     0   4   32 24                 56
1122309 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2017   kindergarten 38 17 20 0   2     0   9   40 46                       86 38 17 20 0   2     0   9   40 46                 86
1122314 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2017   kindergarten 94 2 5 0   1     0   2   56 48                       104 94 2 5 0   1     0   2   56 48                 104
1123461 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 04 2017   kindergarten 64 1 1 0   0     0   1   34 33                       67 64 1 1 0   0     0   1   34 33                 67
1123468 MA Barnstable   school 2502820 36   Bourne 250282000353 360010 Peebles Elementary School   Regular School No Elementary KG 04 2017   kindergarten 32 1 0 0   1     0   0   18 16                       34 32 1 0 0   1     0   0   18 16                 34
1123559 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2017   kindergarten 62 3 5 0   0     0   5   32 43                       75 62 3 5 0   0     0   5   32 43                 75
1124509 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2017   kindergarten 26 1 0 0   0     0   0   13 14                       27 26 1 0 0   0     0   0   13 14                 27
1124830 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2017   kindergarten 39 3 4 3   0     0   3   30 22                       52 39 3 4 3   0     0   3   30 22                 52
1124837 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2017   kindergarten 35 8 3 1   0     0   6   27 26                       53 35 8 3 1   0     0   6   27 26                 53
1124844 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2017   kindergarten 57 2 4 2   4     0   10   46 33                       79 57 2 4 2   4     0   10   46 33                 79
1124850 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2017   kindergarten 38 3 4 0   1     0   2   27 21                       48 38 3 4 0   1     0   2   27 21                 48
1126731 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2017   kindergarten 51 5 5 5   3     1   3   36 37                       73 51 5 5 5   3     1   3   36 37                 73
1127934 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2017   kindergarten 29 4 1 0   0     0   1   17 18                       35 29 4 1 0   0     0   1   17 18                 35
1128271 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   kindergarten 4 2 2 0   0     0   0   4 4                       8 4 2 2 0   0     0   0   4 4                 8
1128690 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2017   kindergarten 153 2 11 1   5     0   4   86 90                       176 153 2 11 1   5     0   4   86 90                 176
1129759 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   kindergarten 7 2 2 0   0     0   1   4 8                       12 7 2 2 0   0     0   1   4 8                 12
1130132 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2017   kindergarten 14 1 2 0   0     0   1   10 8                       18 14 1 2 0   0     0   1   10 8                 18
1131195 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   kindergarten 31 20 23 0   3     0   3   39 41                       80 31 20 23 0   3     0   3   39 41                 80
1131980 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2017   kindergarten 53 6 6 1   0     0   10   43 33                       76 53 6 6 1   0     0   10   43 33                 76
1131985 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2017   kindergarten 31 4 9 3   0     1   5   35 18                       53 31 4 9 3   0     1   5   35 18                 53
1131991 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2017   kindergarten 72 10 5 6   1     1   6   57 44                       101 72 10 5 6   1     1   6   57 44                 101
1132352 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2017   kindergarten 33 3 5 0   0     1   2   24 20                       44 33 3 5 0   0     1   2   24 20                 44
1132359 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2017   kindergarten 82 5 6 0   0     0   5   46 52                       98 82 5 6 0   0     0   5   46 52                 98
1365072 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2020   kindergarten 41 2 11 0   0     0   4   34 24 *                     58.0 41 2 11 0   0     0   4   34 24                 58
1365076 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2020   kindergarten 32 4 11 0   0     0   8   25 30 *                     55.0 32 4 11 0   0     0   8   25 30                 55
1365080 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable Community Innovation School   Regular School No Elementary KG 03 2020   kindergarten 23 10 22 3   4     0   4   40 26 *                     66.0 23 10 22 3   4     0   4   40 26                 66
1365084 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2020   kindergarten 24 13 25 0   1     0   9   30 42 *                     72.0 24 13 25 0   1     0   9   30 42                 72
1365088 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2020   kindergarten 70 1 9 0   0     0   12   48 44 *                     92.0 70 1 9 0   0     0   12   48 44                 92
1366057 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bournedale Elementary School   Regular School No Elementary PK 02 2020   kindergarten 106 2 12 1   3     0   8   71 61 *                     132.0 106 2 12 1   3     0   8   71 61                 132
1366127 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2020   kindergarten 45 1 8 0   0     0   8   32 30 *                     62.0 45 1 8 0   0     0   8   32 30                 62
1366937 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2020   kindergarten 26 2 1 0   0     0   3   16 16 *                     32.0 26 2 1 0   0     0   3   16 16                 32
1367213 MA Barnstable   school 2504860 96   Falmouth 250486000685 960005 East Falmouth Elementary   Regular School No Elementary PK 04 2020   kindergarten 24 1 4 1   1     0   1   19 13 *                     32.0 24 1 4 1   1     0   1   19 13                 32
1367219 MA Barnstable   school 2504860 96   Falmouth 250486000691 960015 Teaticket   Regular School No Elementary PK 04 2020   kindergarten 38 4 6 0   2     0   3   33 20 *                     53.0 38 4 6 0   2     0   3   33 20                 53
1367225 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2020   kindergarten 62 1 9 0   4     0   11   55 32 *                     87.0 62 1 9 0   4     0   11   55 32                 87
1367230 MA Barnstable   school 2504860 96   Falmouth 250486000690 960030 North Falmouth Elementary   Regular School No Elementary KG 04 2020   kindergarten 47 1 3 0   1     0   2   26 28 *                     54.0 47 1 3 0   1     0   2   26 28                 54
1368791 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2020   kindergarten 67 5 9 2   2     0   11   55 41 *                     96.0 67 5 9 2   2     0   11   55 41                 96
1369803 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2020   kindergarten 18 1 1 0   0     0   2   11 11 *                     22.0 18 1 1 0   0     0   2   11 11                 22
1370090 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   kindergarten 5 2 1 0   0     0   1   4 5 *                     9.0 5 2 1 0   0     0   1   4 5                 9
1370439 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2020   kindergarten 141 2 5 1   5     0   1   74 81 *                     155.0 141 2 5 1   5     0   1   74 81                 155
1371345 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   kindergarten 8 1 0 0   0     0   3   6 6 *                     12.0 8 1 0 0   0     0   3   6 6                 12
1371664 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary KG 05 2020   kindergarten 16 0 0 0   0     0   3   13 6 *                     19.0 16 0 0 0   0     0   3   13 6                 19
1373236 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2020   kindergarten 52 7 8 0   2     0   4   32 41 *                     73.0 52 7 8 0   2     0   4   32 41                 73
1373241 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2020   kindergarten 31 3 14 1   1     0   3   29 24 *                     53.0 31 3 14 1   1     0   3   29 24                 53
1373246 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2020   kindergarten 76 11 7 0   5     0   3   56 46 *                     102.0 76 11 7 0   5     0   3   56 46                 102
1373551 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2020   kindergarten 25 3 5 0   0     0   1   19 15 *                     34.0 25 3 5 0   0     0   1   19 15                 34
1373557 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2020   kindergarten 66 4 9 0   1     0   8   54 34 *                     88.0 66 4 9 0   1     0   8   54 34                 88
1672296 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable - West Barnstable Elementary   Regular School No Elementary KG 03 2021   kindergarten 32 2 12 0   1     0   5   31 21 *                     52.0 32 2 12 0   1     0   5   31 21                 52
1672300 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable - Centerville Elementary   Regular School No Elementary KG 03 2021   kindergarten 32 4 8 0   0     0   11   31 24 *                     55.0 32 4 8 0   0     0   11   31 24                 55
1672304 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   kindergarten 22 9 27 0   1     0   6   38 27 *                     65.0 22 9 27 0   1     0   6   38 27                 65

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