Data source: Big Local News · About: Big Local

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

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
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
2233552 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee: Kenneth Coombs School   Regular School No Elementary PK 02 2018   kindergarten 86 3 6 9   3     0   15   73 49                       122.0 86 3 6 9   3     0   15   73 49                 122
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
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
936512 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Charles Jaworek School   Regular School No 1 KG 04 2016   kindergarten 88 9 51 5   17     0   6   98 78                       176 88 9 51 5   17     0   6   98 78                 176
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
2049022 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2019   kindergarten 24 1 3 5   0     0   4   23 14                       37.0 24 1 3 5   0     0   4   23 14                 37
2235680 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Shrewsbury: Beal School   Regular School No Elementary KG 01 2018   kindergarten 108 11 22 5   95     0   13   128 126                       254.0 108 11 22 5   95     0   13   128 126                 254
735857 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2015   kindergarten 153 5 3 4   23     0   5   86 107                       193 153 5 3 4   23     0   5   86 107                 193
737931 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2015   kindergarten 29 1 7 4   0     0   4   22 23                       45 29 1 7 4   0     0   4   22 23                 45
739943 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No 1 KG 02 2015   kindergarten 94 5 40 4   6     1   11   94 67                       161 94 5 40 4   6     1   11   94 67                 161
941723 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2016   kindergarten 30 1 0 4   0     0   1   20 16                       36 30 1 0 4   0     0   1   20 16                 36
1676041 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee - Kenneth Coombs School   Regular School No Elementary PK 02 2021   kindergarten 65 5 6 4   3     1   9   48 45 *                     93.0 65 5 6 4   3     1   9   48 45                 93
1679362 MA Middlesex   school 2513200 347   Woburn 251320002188 3470055 Woburn - Malcolm White   Regular School No Elementary KG 05 2021   kindergarten 26 2 2 4   2     0   0   19 17 *                     36.0 26 2 2 4   2     0   0   19 17                 36
1679923 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   kindergarten 16 60 7 4   8     0   22   49 68 *                     117.0 16 60 7 4   8     0   22   49 68                 117
2045654 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2019   kindergarten 87 8 18 4   96     0   8   122 99                       221.0 87 8 18 4   96     0   8   122 99                 221
2236785 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 Wareham: John William Decas   Regular School No Elementary KG 02 2018   kindergarten 160 15 17 4   2     0   24   119 103                       222.0 160 15 17 4   2     0   24   119 103                 222
737077 MA Plymouth   school 2503090 44   Brockton 250309002792 440007 Barrett Russell School   Regular School No 1 KG KG 2015   kindergarten 52 123 32 3   3     0   23   129 107                       236 52 123 32 3   3     0   23   129 107                 236
739946 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No 1 KG 05 2015   kindergarten 111 7 41 3   2     0   8   85 87                       172 111 7 41 3   2     0   8   85 87                 172
742470 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No 1 KG 02 2015   kindergarten 175 19 11 3   2     0   28   129 109                       238 175 19 11 3   2     0   28   129 109                 238
743083 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Mary D Altavesta   Regular School No 1 KG 05 2015   kindergarten 20 2 10 3   14     0   1   27 23                       50 20 2 10 3   14     0   1   27 23                 50
743410 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 05 2015   kindergarten 11 2 19 3   0     1   3   20 19                       39 11 2 19 3   0     1   3   20 19                 39
933926 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2016   kindergarten 28 81 13 3   0     0   12   79 58                       137 28 81 13 3   0     0   12   79 58                 137
936615 MA Middlesex   school 2507560 176   Medford 250756001634 1760068 John J McGlynn Elementary School   Regular School No 1 PK 05 2016   kindergarten 47 14 13 3   10     0   4   40 51                       91 47 14 13 3   10     0   4   40 51                 91
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
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
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
1368571 MA Essex   school 2507110 163   Lynn 250711001072 1630095 Edward A Sisson   Regular School No Elementary PK 05 2020   kindergarten 16 3 28 3   6     0   7   29 34 *                     63.0 16 3 28 3   6     0   7   29 34                 63
1371525 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2020   kindergarten 138 11 16 3   2     0   28   96 102 *                     198.0 138 11 16 3   2     0   28   96 102                 198
1676262 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Milford - Brookside   Regular School No Elementary KG 02 2021   kindergarten 93 5 42 3   1     0   7   86 65 *                     151.0 93 5 42 3   1     0   7   86 65                 151
2043863 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   kindergarten 60 3 15 3   1     0   15   52 45                       97.0 60 3 15 3   1     0   15   52 45                 97
2043934 MA Middlesex   school 2507560 176   Medford 250756002062 1760150 Milton Fuller Roberts   Regular School No Elementary PK 05 2019   kindergarten 56 9 10 3   5     0   4   42 45                       87.0 56 9 10 3   5     0   4   42 45                 87
2045187 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2019   kindergarten 40 10 7 3   47     0   6   62 51                       113.0 40 10 7 3   47     0   6   62 51                 113
2047180 MA Middlesex   school 2513200 347   Woburn 251320002189 3470065 Mary D Altavesta   Regular School No Elementary KG 05 2019   kindergarten 20 6 4 3   11     0   3   24 23                       47.0 20 6 4 3   11     0   3   24 23                 47
735658 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No 1 PK KG 2015   kindergarten 138 2 3 2   3     0   0   80 68                       148 138 2 3 2   3     0   0   80 68                 148
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
737059 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No 1 KG 05 2015   kindergarten 19 84 24 2   0     1   10   72 68                       140 19 84 24 2   0     1   10   72 68                 140
737974 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2015   kindergarten 20 11 54 2   2     0   1   43 47                       90 20 11 54 2   2     0   1   43 47                 90
737989 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2015   kindergarten 32 21 47 2   5     0   2   57 52                       109 32 21 47 2   5     0   2   57 52                 109
738099 MA Bristol   school 2504830 95   Fall River 250483000677 950145 Samuel Watson   Regular School No 1 KG 05 2015   kindergarten 24 7 7 2   1     0   8   26 23                       49 24 7 7 2   1     0   8   26 23                 49
739043 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No 1 PK 02 2015   kindergarten 85 3 4 2   3     0   1   50 48                       98 85 3 4 2   3     0   1   50 48                 98
739365 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No 1 PK 01 2015   kindergarten 127 2 17 2   1     0   7   71 85                       156 127 2 17 2   1     0   7   71 85                 156
739399 MA Essex   school 2507110 163   Lynn 250711002658 1630005 Washington Elementary School   Regular School No 1 KG 05 2015   kindergarten 7 6 44 2   8     0   4   34 37                       71 7 6 44 2   8     0   4   34 37                 71
739757 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No 1 PK 01 2015   kindergarten 129 0 9 2   8     0   0   86 62                       148 129 0 9 2   8     0   0   86 62                 148
740729 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   kindergarten 36 0 5 2   1     0   4   19 29                       48 36 0 5 2   1     0   4   19 29                 48
740935 MA Berkshire   school 2509630 236   Pittsfield 250963001535 2360105 Silvio O Conte Community   Regular School No 1 PK 05 2015   kindergarten 37 20 18 2   0     0   13   51 39                       90 37 20 18 2   0     0   13   51 39                 90
742046 MA Middlesex   school 2511220 284   Stoneham 251122001856 2840030 South   Regular School No 1 KG 04 2015   kindergarten 51 1 4 2   1     0   0   35 24                       59 51 1 4 2   1     0   0   35 24                 59
742100 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No 1 PK 06 2015   kindergarten 101 0 3 2   1     0   4   66 45                       111 101 0 3 2   1     0   4   66 45                 111
742622 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Annie E Fales   Regular School No 1 KG 03 2015   kindergarten 50 1 4 2   18     0   2   46 31                       77 50 1 4 2   18     0   2   46 31                 77
743583 MA Suffolk   school 2500528 443   Brooke Charter School Mattapan (District) 250052802711 4430205 Brooke Charter School Mattapan   Regular School Yes 1 KG 08 2015   kindergarten 6 35 16 2   1     0   0   29 31                       60 6 35 16 2   1     0   0   29 31                 60
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
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
932792 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No 1 KG 02 2016   kindergarten 77 1 9 2   1     0   3   52 41                       93 77 1 9 2   1     0   3   52 41                 93
932914 MA Middlesex   school 2502490 26   Belmont 250249000144 260015 Daniel Butler   Regular School No 1 KG 04 2016   kindergarten 36 3 1 2   20     0   5   34 33                       67 36 3 1 2   20     0   5   34 33                 67
933063 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No 1 PK 01 2016   kindergarten 1 27 27 2   2     0   1   32 28                       60 1 27 27 2   2     0   1   32 28                 60
933944 MA Plymouth   school 2503090 44   Brockton 250309002792 440007 Barrett Russell School   Regular School No 1 KG KG 2016   kindergarten 31 123 44 2   0     0   9   110 99                       209 31 123 44 2   0     0   9   110 99                 209
935012 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No 1 PK 04 2016   kindergarten 35 7 63 2   3     0   6   61 55                       116 35 7 63 2   3     0   6   61 55                 116
935077 MA Norfolk   school 2504950 99   Foxborough 250495000864 990050 Charles Taylor Elementary   Regular School No 1 KG 04 2016   kindergarten 33 1 0 2   1     0   0   26 11                       37 33 1 0 2   1     0   0   26 11                 37
936320 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No 1 KG 05 2016   kindergarten 18 1 3 2   0     0   1   16 9                       25 18 1 3 2   0     0   1   16 9                 25
936345 MA Essex   school 2507110 163   Lynn 250711001072 1630095 Edward A Sisson   Regular School No 1 KG 05 2016   kindergarten 20 6 25 2   6     0   4   29 34                       63 20 6 25 2   6     0   4   29 34                 63
936790 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No 1 KG 06 2016   kindergarten 107 6 42 2   4     0   7   81 87                       168 107 6 42 2   4     0   7   81 87                 168
937060 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No 1 PK 05 2016   kindergarten 24 4 12 2   0     0   4   23 23                       46 24 4 12 2   0     0   4   23 23                 46
937744 MA Berkshire   school 2509630 236   Pittsfield 250963001528 2360065 Crosby   Regular School No 1 PK 05 2016   kindergarten 27 7 12 2   0     0   3   32 19                       51 27 7 12 2   0     0   3   32 19                 51
938351 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No 1 KG 01 2016   kindergarten 103 5 21 2   99     0   6   126 110                       236 103 5 21 2   99     0   6   126 110                 236
940047 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No 1 PK 06 2016   kindergarten 6 5 35 2   2     0   2   25 27                       52 6 5 35 2   2     0   2   25 27                 52
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
1123494 MA Worcester   school 2502910 39   Boylston 250291000359 390005 Boylston Elementary   Regular School No Elementary PK 05 2017   kindergarten 23 0 1 2   2     0   3   15 16                       31 23 0 1 2   2     0   3   15 16                 31
1123648 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2017   kindergarten 17 102 16 2   0     0   1   76 62                       138 17 102 16 2   0     0   1   76 62                 138
1123660 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2017   kindergarten 19 48 14 2   2     1   9   54 41                       95 19 48 14 2   2     1   9   54 41                 95
1124578 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2017   kindergarten 62 3 6 2   1     0   1   37 38                       75 62 3 6 2   1     0   1   37 38                 75
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
1125964 MA Worcester   school 2506780 153   Leominster 250678000985 1530025 Johnny Appleseed   Regular School No Elementary KG 05 2017   kindergarten 37 11 28 2   1     0   2   41 40                       81 37 11 28 2   1     0   2   41 40                 81
1127236 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 Elizabeth Carter Brooks   Regular School No Elementary PK 05 2017   kindergarten 26 5 20 2   1     0   2   24 32                       56 26 5 20 2   1     0   2   24 32                 56
1129911 MA Middlesex   school 2512000 308   Waltham 251200001974 3080040 Northeast Elementary School   Regular School No Elementary PK 05 2017   kindergarten 34 6 17 2   3     0   3   30 35                       65 34 6 17 2   3     0   3   30 35                 65
1130150 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No Elementary PK 03 2017   kindergarten 42 3 16 2   29     0   3   42 53                       95 42 3 16 2   29     0   3   42 53                 95
1131211 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2017   kindergarten 7 22 85 2   2     0   4   57 65                       122 7 22 85 2   2     0   4   57 65                 122
1132214 MA Essex   school 2505670 675   Hamilton-Wenham 250567000821 6750015 Winthrop School   Regular School No Elementary PK 05 2017   kindergarten 36 1 1 2   2     0   2   15 29                       44 36 1 1 2   2     0   2   15 29                 44
1132824 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   kindergarten 23 0 6 2   0     0   0   19 12                       31 23 0 6 2   0     0   0   19 12                 31
1132936 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No Elementary KG 05 2017   kindergarten 69 1 8 2   0     0   2   42 40                       82 69 1 8 2   0     0   2   42 40                 82
1365596 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No Elementary PK 05 2020   kindergarten 5 35 12 2   25     0   4   44 39 *                     83.0 5 35 12 2   25     0   4   44 39                 83
1366547 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No Elementary KG 04 2020   kindergarten 63 2 7 2   20     0   2   51 45 *                     96.0 63 2 7 2   20     0   2   51 45                 96
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
1369043 MA Norfolk   school 2507920 187   Millis 250792001252 1870005 Clyde F Brown   Regular School No Elementary PK 05 2020   kindergarten 67 0 8 2   1     0   2   47 33 *                     80.0 67 0 8 2   1     0   2   47 33                 80
1369243 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary KG 05 2020   kindergarten 9 12 60 2   0     0   1   39 45 *                     84.0 9 12 60 2   0     0   1   39 45                 84
1369633 MA Worcester   school 2508880 213   Northborough 250888001438 2130014 Marguerite E Peaslee   Regular School No Elementary KG 05 2020   kindergarten 28 0 3 2   4     0   3   21 19 *                     40.0 28 0 3 2   4     0   3   21 19                 40
1370113 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2020   kindergarten 47 9 14 2   47     0   8   67 60 *                     127.0 47 9 14 2   47     0   8   67 60                 127
1672539 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Boston - Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2021   kindergarten 0 24 10 2   0     0   1   25 12 *                     37.0 0 24 10 2   0     0   1   25 12                 37
1672742 MA Suffolk   school 2502790 35   Boston 250279000268 350167 Boston - UP Academy Holland   Regular School No Elementary PK 05 2021   kindergarten 1 30 31 2   3     0   2   40 29 *                     69.0 1 30 31 2   3     0   2   40 29                 69
1673800 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Chelsea - Shurtleff Early Childhood   Regular School No Elementary PK 01 2021   kindergarten 36 30 404 2   0     0   5   230 247 *                     477.0 36 30 404 2   0     0   5   230 247                 477
1675125 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Hopkinton - Marathon Elementary School   Regular School No Elementary KG 01 2021   kindergarten 164 1 10 2   79     0   14   145 125 *                     270.0 164 1 10 2   79     0   14   145 125                 270
1675885 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden - Ferryway   Regular School No Elementary KG 08 2021   kindergarten 15 13 31 2   33     0   2   49 47 *                     96.0 15 13 31 2   33     0   2   49 47                 96
1675903 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden - Linden   Regular School No Elementary KG 08 2021   kindergarten 26 14 20 2   18     0   2   43 39 *                     82.0 26 14 20 2   18     0   2   43 39                 82
1676251 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Middleton - Fuller Meadow   Regular School No Elementary KG 02 2021   kindergarten 80 1 7 2   6     0   2   55 43 *                     98.0 80 1 7 2   6     0   2   55 43                 98
1677188 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Pittsfield - Allendale   Regular School No Elementary KG 05 2021   kindergarten 21 4 6 2   0     0   3   19 17 *                     36.0 21 4 6 2   0     0   3   19 17                 36
1677690 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Sandwich - Forestdale School   Regular School No Elementary PK 02 2021   kindergarten 123 2 7 2   2     1   3   67 73 *                     140.0 123 2 7 2   2     1   3   67 73                 140
1678120 MA Hampden   school 2511130 281   Springfield 251113001804 2810080 Springfield - Frederick Harris   Regular School No Elementary PK 05 2021   kindergarten 16 16 31 2   2     0   2   34 35 *                     69.0 16 16 31 2   2     0   2   34 35                 69
1679949 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District) - Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2021   kindergarten 65 1 6 2   21     0   1   46 50 *                     96.0 65 1 6 2   21     0   1   46 50                 96
1680392 MA Worcester   school 2502580 620   Berlin-Boylston 250258002901 6200005 Berlin-Boylston - Berlin Memorial School   Regular School No Elementary PK 05 2021   kindergarten 26 0 4 2   1     0   0   11 22 *                     33.0 26 0 4 2   1     0   0   11 22                 33

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