Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • kindergarten · 6,647
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
738393 MA Essex   school 2505280 107   Gloucester 250528000771 1070020 East Gloucester Elementary   Regular School No 1 KG 05 2015   kindergarten 37 0 4 0   0     0   1   26 16                       42 37 0 4 0   0     0   1   26 16                 42
738406 MA Essex   school 2505280 107   Gloucester 250528000780 1070045 Veterans Memorial   Regular School No 1 KG 05 2015   kindergarten 27 0 5 0   0     0   0   12 20                       32 27 0 5 0   0     0   0   12 20                 32
738453 MA Hampshire   school 2505400 111   Granby 250540000791 1110010 West Street   Regular School No 1 PK 03 2015   kindergarten 46 0 1 1   0     0   1   19 30                       49 46 0 1 1   0     0   1   19 30                 49
738465 MA Franklin   school 2505490 114   Greenfield 250549002577 1140010 Federal Street School   Regular School No 1 KG 03 2015   kindergarten 47 0 7 0   0     0   0   23 31                       54 47 0 7 0   0     0   0   23 31                 54
738469 MA Franklin   school 2505490 114   Greenfield 250549000798 1140025 Discovery School at Four Corners   Regular School No 1 KG 03 2015   kindergarten 40 0 6 0   0     0   0   14 32                       46 40 0 6 0   0     0   0   14 32                 46
738477 MA Franklin   school 2505490 114   Greenfield 250549002578 1140035 Newton School   Regular School No 1 KG 03 2015   kindergarten 38 1 15 0   0     0   0   23 31                       54 38 1 15 0   0     0   0   23 31                 54
738491 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No 1 PK 06 2015   kindergarten 24 1 4 0   0     1   0   17 13                       30 24 1 4 0   0     1   0   17 13                 30
738506 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2015   kindergarten 73 2 0 1   0     0   1   46 31                       77 73 2 0 1   0     0   1   46 31                 77
738554 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No 1 PK 06 2015   kindergarten 28 0 3 0   0     0   0   20 11                       31 28 0 3 0   0     0   0   20 11                 31
738569 MA Essex   school 2505970 128   Haverhill 250597001168 1280008 Bradford Elementary   Regular School No 1 KG 05 2015   kindergarten 43 0 4 0   0     0   1   26 22                       48 43 0 4 0   0     0   1   26 22                 48
738576 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No 1 KG 04 2015   kindergarten 29 3 29 0   0     0   3   26 38                       64 29 3 29 0   0     0   3   26 38                 64
738622 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   kindergarten 10 1 7 0   0     0   1   17 2                       19 10 1 7 0   0     0   1   17 2                 19
738636 MA Plymouth   school 2506090 131   Hingham 250609002671 1310005 East Elementary School   Regular School No 1 PK 05 2015   kindergarten 54 0 0 0   0     0   2   32 24                       56 54 0 0 0   0     0   2   32 24                 56
738643 MA Plymouth   school 2506090 131   Hingham 250609000876 1310010 Wm L Foster Elementary   Regular School No 1 KG 05 2015   kindergarten 45 0 2 0   0     0   2   25 24                       49 45 0 2 0   0     0   2   25 24                 49
738649 MA Plymouth   school 2506090 131   Hingham 250609000873 1310019 Plymouth River   Regular School No 1 KG 05 2015   kindergarten 57 0 5 0   0     0   1   32 31                       63 57 0 5 0   0     0   1   32 31                 63
738684 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No 1 PK 06 2015   kindergarten 24 2 1 1   0     0   0   15 13                       28 24 2 1 1   0     0   0   15 13                 28
738707 MA Hampden   school 2506270 137   Holyoke 250627001178 1370003 Joseph Metcalf School   Regular School No 1 PK KG 2015   kindergarten 9 0 14 0   0     0   0   9 14                       23 9 0 14 0   0     0   0   9 14                 23
738718 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2015   kindergarten 1 1 41 0   0     0   0   21 22                       43 1 1 41 0   0     0   0   21 22                 43
738733 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2015   kindergarten 1 1 68 0   0     0   0   39 31                       70 1 1 68 0   0     0   0   39 31                 70
738742 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 KG 08 2015   kindergarten 6 1 36 0   0     0   1   21 23                       44 6 1 36 0   0     0   1   21 23                 44
738751 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2015   kindergarten 12 3 52 0   0     0   0   31 36                       67 12 3 52 0   0     0   0   31 36                 67
738769 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No 1 KG 03 2015   kindergarten 4 1 74 0   0     0   0   44 35                       79 4 1 74 0   0     0   0   44 35                 79
738782 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2015   kindergarten 62 0 2 0   0     0   2   38 28                       66 62 0 2 0   0     0   2   38 28                 66
738816 MA Middlesex   school 2506390 141   Hudson 250639000925 1410015 Forest Avenue Elementary   Regular School No 1 KG 04 2015   kindergarten 51 0 4 0   0     0   1   28 28                       56 51 0 4 0   0     0   1   28 28                 56
738857 MA Essex   school 2506480 144   Ipswich 250648000939 1440015 Winthrop   Regular School No 1 PK 05 2015   kindergarten 44 1 2 0   0     0   5   23 29                       52 44 1 2 0   0     0   5   23 29                 52
738872 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No 1 KG 02 2015   kindergarten 124 2 2 1   0     0   0   60 69                       129 124 2 2 1   0     0   0   60 69                 129
738879 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No 1 PK 06 2015   kindergarten 15 0 1 0   0     0   0   7 9                       16 15 0 1 0   0     0   0   7 9                 16
738896 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 PK 04 2015   kindergarten 2 0 79 0   0     0   0   42 39                       81 2 0 79 0   0     0   0   42 39                 81
738936 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No 1 KG 05 2015   kindergarten 3 0 107 0   0     0   0   62 48                       110 3 0 107 0   0     0   0   62 48                 110
738960 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2015   kindergarten 6 0 56 0   0     0   0   28 34                       62 6 0 56 0   0     0   0   28 34                 62
739089 MA Worcester   school 2506780 153   Leominster 250678000988 1530030 Northwest   Regular School No 1 KG 05 2015   kindergarten 35 1 9 0   0     0   3   28 20                       48 35 1 9 0   0     0   3   28 20                 48
739112 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2015   kindergarten 20 0 0 0   0     0   0   13 7                       20 20 0 0 0   0     0   0   13 7                 20
739380 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No 1 PK 03 2015   kindergarten 97 0 6 0   0     1   7   49 62                       111 97 0 6 0   0     1   7   49 62                 111
739472 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No 1 KG 05 2015   kindergarten 22 1 1 0   0     0   2   11 15                       26 22 1 1 0   0     0   2   11 15                 26
739649 MA Plymouth   school 2507290 169   Marion 250729001127 1690005 Sippican   Regular School No 1 PK 06 2015   kindergarten 39 3 1 0   0     0   2   21 24                       45 39 3 1 0   0     0   2   21 24                 45
739682 MA Plymouth   school 2507350 171   Marshfield 250735000760 1710005 Eames Way School   Regular School No 1 KG 05 2015   kindergarten 26 0 0 0   0     0   1   17 10                       27 26 0 0 0   0     0   1   17 10                 27
739694 MA Plymouth   school 2507350 171   Marshfield 250735001137 1710015 Daniel Webster   Regular School No 1 PK 05 2015   kindergarten 40 0 5 0   0     0   1   23 23                       46 40 0 5 0   0     0   1   23 23                 46
739701 MA Plymouth   school 2507350 171   Marshfield 250735001140 1710020 Gov Edward Winslow   Regular School No 1 KG 05 2015   kindergarten 43 0 1 0   0     0   1   29 16                       45 43 0 1 0   0     0   1   29 16                 45
739845 MA Middlesex   school 2507620 178   Melrose 250762001191 1780025 Horace Mann   Regular School No 1 KG 05 2015   kindergarten 41 0 1 0   0     0   2   21 23                       44 41 0 1 0   0     0   2   21 23                 44
740139 MA Bristol   school 2508430 201   New Bedford 250843001321 2010010 Charles S Ashley   Regular School No 1 KG 05 2015   kindergarten 36 3 9 1   0     0   2   34 17                       51 36 3 9 1   0     0   2   34 17                 51
740145 MA Bristol   school 2508430 201   New Bedford 250843001322 2010015 Elizabeth Carter Brooks   Regular School No 1 PK 05 2015   kindergarten 14 4 13 0   0     0   2   13 20                       33 14 4 13 0   0     0   2   13 20                 33
740152 MA Bristol   school 2508430 201   New Bedford 250843001324 2010020 Elwyn G Campbell   Regular School No 1 PK 05 2015   kindergarten 31 1 6 0   0     0   3   16 25                       41 31 1 6 0   0     0   3   16 25                 41
740159 MA Bristol   school 2508430 201   New Bedford 250843001329 2010040 James B Congdon   Regular School No 1 KG 05 2015   kindergarten 26 5 36 1   0     0   5   36 37                       73 26 5 36 1   0     0   5   36 37                 73
740165 MA Bristol   school 2508430 201   New Bedford 250843001341 2010045 Sgt Wm H Carney Academy   Regular School No 1 PK 05 2015   kindergarten 41 26 38 0   0     0   9   69 45                       114 41 26 38 0   0     0   9   69 45                 114
740178 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No 1 PK 05 2015   kindergarten 14 11 48 1   0     0   2   34 42                       76 14 11 48 1   0     0   2   34 42                 76
740190 MA Bristol   school 2508430 201   New Bedford 250843001323 2010075 Ellen R Hathaway   Regular School No 1 KG 05 2015   kindergarten 24 14 52 0   0     0   6   45 51                       96 24 14 52 0   0     0   6   45 51                 96
740196 MA Bristol   school 2508430 201   New Bedford 250843001327 2010078 Hayden/McFadden   Regular School No 1 PK 05 2015   kindergarten 34 10 44 1   0     0   6   50 45                       95 34 10 44 1   0     0   6   50 45                 95
740203 MA Bristol   school 2508430 201   New Bedford 250843001328 2010085 Horatio A Kempton   Regular School No 1 KG 05 2015   kindergarten 7 2 6 0   0     0   1   12 4                       16 7 2 6 0   0     0   1   12 4                 16
740209 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No 1 KG 05 2015   kindergarten 59 15 38 0   0     0   11   67 56                       123 59 15 38 0   0     0   11   67 56                 123
740215 MA Bristol   school 2508430 201   New Bedford 250843001335 2010105 Carlos Pacheco   Regular School No 1 PK 05 2015   kindergarten 28 14 27 0   0     0   3   38 34                       72 28 14 27 0   0     0   3   38 34                 72
740222 MA Bristol   school 2508430 201   New Bedford 250843001331 2010115 John Avery Parker   Regular School No 1 PK 05 2015   kindergarten 16 8 21 0   0     0   6   23 28                       51 16 8 21 0   0     0   6   23 28                 51
740236 MA Bristol   school 2508430 201   New Bedford 250843002802 2010124 Renaissance Community School for the Arts   Regular School No 1 PK 03 2015   kindergarten 7 10 31 0   0     0   4   26 26                       52 7 10 31 0   0     0   4   26 26                 52
740241 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 Thomas R Rodman   Regular School No 1 PK 05 2015   kindergarten 13 4 7 0   0     0   1   10 15                       25 13 4 7 0   0     0   1   10 15                 25
740248 MA Bristol   school 2508430 201   New Bedford 250843001330 2010130 Jireh Swift   Regular School No 1 KG 05 2015   kindergarten 39 0 4 0   0     0   4   22 25                       47 39 0 4 0   0     0   4   22 25                 47
740254 MA Bristol   school 2508430 201   New Bedford 250843001343 2010135 William H Taylor   Regular School No 1 KG 05 2015   kindergarten 34 2 8 0   0     0   4   18 30                       48 34 2 8 0   0     0   4   18 30                 48
740427 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 J S Sullivan   Regular School No 1 KG 07 2015   kindergarten 26 2 2 0   0     0   2   19 13                       32 26 2 2 0   0     0   2   19 13                 32
740443 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No 1 PK 07 2015   kindergarten 42 1 2 0   0     0   4   19 30                       49 42 1 2 0   0     0   4   19 30                 49
740470 MA Hampshire   school 2508850 210   Northampton 250885001431 2100025 Leeds   Regular School No 1 KG 05 2015   kindergarten 36 0 9 0   0     0   2   31 16                       47 36 0 9 0   0     0   2   31 16                 47
740615 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No 1 PK 06 2015   kindergarten 34 0 1 0   0     0   1   15 21                       36 34 0 1 0   0     0   1   15 21                 36
740673 MA Plymouth   school 2509030 219   Norwell 250903001454 2190005 Grace Farrar Cole   Regular School No 1 PK 05 2015   kindergarten 60 0 2 0   0     0   2   33 31                       64 60 0 2 0   0     0   2   33 31                 64
740680 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No 1 PK 05 2015   kindergarten 72 0 0 0   0     0   3   38 37                       75 72 0 0 0   0     0   3   38 37                 75
740743 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Fisher Hill   Regular School No 1 PK 02 2015   kindergarten 69 1 7 0   0     0   1   39 39                       78 69 1 7 0   0     0   1   39 39                 78
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
740756 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No 1 KG 02 2015   kindergarten 120 3 12 0   0     0   3   67 71                       138 120 3 12 0   0     0   3   67 71                 138
740794 MA Essex   school 2509360 229   Peabody 250936001496 2290007 John E Burke   Regular School No 1 KG 05 2015   kindergarten 37 0 2 0   0     0   2   26 15                       41 37 0 2 0   0     0   2   26 15                 41
740819 MA Essex   school 2509360 229   Peabody 250936001506 2290027 William A Welch Sr   Regular School No 1 PK 05 2015   kindergarten 27 4 26 0   0     0   1   24 34                       58 27 4 26 0   0     0   1   24 34                 58
740826 MA Essex   school 2509360 229   Peabody 250936001502 2290035 South Memorial   Regular School No 1 PK 05 2015   kindergarten 54 3 7 0   0     0   2   34 32                       66 54 3 7 0   0     0   2   34 32                 66
740833 MA Essex   school 2509360 229   Peabody 250936001505 2290045 West Memorial   Regular School No 1 PK 05 2015   kindergarten 23 1 2 0   0     0   0   18 8                       26 23 1 2 0   0     0   0   18 8                 26
740847 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No 1 KG 06 2015   kindergarten 16 2 0 0   0     0   0   8 10                       18 16 2 0 0   0     0   0   8 10                 18
740854 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No 1 KG 06 2015   kindergarten 69 0 0 0   0     0   4   38 35                       73 69 0 0 0   0     0   4   38 35                 73
740861 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No 1 KG 06 2015   kindergarten 50 1 0 0   0     0   0   31 20                       51 50 1 0 0   0     0   0   31 20                 51
740883 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No 1 KG 06 2015   kindergarten 16 0 0 0   0     0   0   6 10                       16 16 0 0 0   0     0   0   6 10                 16
740902 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No 1 PK 05 2015   kindergarten 26 0 2 0   0     0   5   19 14                       33 26 0 2 0   0     0   5   19 14                 33
740909 MA Berkshire   school 2509630 236   Pittsfield 250963001524 2360055 Morningside Community School   Regular School No 1 PK 05 2015   kindergarten 36 4 9 0   0     0   11   35 25                       60 36 4 9 0   0     0   11   35 25                 60
740923 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Stearns   Regular School No 1 KG 05 2015   kindergarten 40 0 3 0   0     0   2   24 21                       45 40 0 3 0   0     0   2   24 21                 45
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
740983 MA Plymouth   school 2509720 239   Plymouth 250972001542 2390012 Indian Brook   Regular School No 1 KG 05 2015   kindergarten 66 1 0 0   0     0   4   34 37                       71 66 1 0 0   0     0   4   34 37                 71
740989 MA Plymouth   school 2509720 239   Plymouth 250972001543 2390015 Manomet Elementary   Regular School No 1 KG 05 2015   kindergarten 50 0 0 0   0     0   1   26 25                       51 50 0 0 0   0     0   1   26 25                 51
741007 MA Plymouth   school 2509720 239   Plymouth 250972001548 2390047 West Elementary   Regular School No 1 KG 05 2015   kindergarten 41 1 0 0   0     0   1   26 17                       43 41 1 0 0   0     0   1   26 17                 43
741028 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No 1 KG 06 2015   kindergarten 21 0 0 0   0     0   0   11 10                       21 21 0 0 0   0     0   0   11 10                 21
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
741177 MA Middlesex   school 2509990 246   Reading 250999001606 2460005 Birch Meadow   Regular School No 1 KG 05 2015   kindergarten 57 1 0 0   0     0   4   32 30                       62 57 1 0 0   0     0   4   32 30                 62
741278 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester Memorial   Regular School No 1 PK 06 2015   kindergarten 45 2 0 0   0     0   3   28 22                       50 45 2 0 0   0     0   3   28 22                 50
741331 MA Essex   school 2510380 258   Salem 251038001653 2580003 Bates   Regular School No 1 KG 05 2015   kindergarten 40 2 11 0   0     0   4   28 29                       57 40 2 11 0   0     0   4   28 29                 57
741343 MA Essex   school 2510380 258   Salem 251038001656 2580015 Carlton   Regular School No 1 KG 05 2015   kindergarten 19 1 12 0   0     0   2   17 17                       34 19 1 12 0   0     0   2   17 17                 34
741424 MA Essex   school 2510500 262   Saugus 251050001682 2620050 Oaklandvale   Regular School No 1 KG 05 2015   kindergarten 20 2 2 0   0     1   1   9 17                       26 20 2 2 0   0     1   1   9 17                 26
741436 MA Essex   school 2510500 262   Saugus 251050001677 2620067 Douglas Waybright   Regular School No 1 KG 05 2015   kindergarten 13 1 2 0   0     0   2   5 13                       18 13 1 2 0   0     0   2   5 13                 18
741450 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No 1 PK 05 2015   kindergarten 7 0 0 0   0     0   0   2 5                       7 7 0 0 0   0     0   0   2 5                 7
741457 MA Plymouth   school 2510560 264   Scituate 251056001689 2640007 Cushing Elementary   Regular School No 1 KG 06 2015   kindergarten 42 3 0 1   0     0   0   24 22                       46 42 3 0 1   0     0   0   24 22                 46
741464 MA Plymouth   school 2510560 264   Scituate 251056001691 2640010 Hatherly Elementary   Regular School No 1 KG 06 2015   kindergarten 35 1 0 0   0     0   2   21 17                       38 35 1 0 0   0     0   2   21 17                 38
741478 MA Plymouth   school 2510560 264   Scituate 251056002289 2640020 Wampatuck Elementary   Regular School No 1 PK 06 2015   kindergarten 41 0 0 0   0     0   1   18 24                       42 41 0 0 0   0     0   1   18 24                 42
741499 MA Bristol   school 2510590 265   Seekonk 251059001696 2650015 Mildred Aitken School   Regular School No 1 PK 05 2015   kindergarten 54 1 1 0   0     0   2   31 27                       58 54 1 1 0   0     0   2   31 27                 58
741577 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No 1 PK 06 2015   kindergarten 15 1 1 0   0     0   2   9 10                       19 15 1 1 0   0     0   2   9 10                 19
741592 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 North Elementary   Regular School No 1 KG 05 2015   kindergarten 54 0 1 0   0     0   4   24 35                       59 54 0 1 0   0     0   4   24 35                 59
741598 MA Bristol   school 2510860 273   Somerset 251086001727 2730015 South   Regular School No 1 KG 05 2015   kindergarten 46 1 2 0   0     0   2   24 27                       51 46 1 2 0   0     0   2   24 27                 51
741616 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No 1 PK 08 2015   kindergarten 10 11 35 0   0     0   2   25 33                       58 10 11 35 0   0     0   2   25 33                 58
741646 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No 1 KG 08 2015   kindergarten 13 3 47 0   0     0   3   37 29                       66 13 3 47 0   0     0   3   37 29                 66
741724 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No 1 PK 01 2015   kindergarten 107 0 20 1   0     0   9   67 70                       137 107 0 20 1   0     0   9   67 70                 137
741763 MA Hampden   school 2511130 281   Springfield 251113000896 2810023 Milton Bradley School   Regular School No 1 PK 05 2015   kindergarten 4 15 89 1   0     0   0   64 45                       109 4 15 89 1   0     0   0   64 45                 109
741770 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No 1 KG 05 2015   kindergarten 0 8 38 0   0     0   0   24 22                       46 0 8 38 0   0     0   0   24 22                 46

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