Data source: Big Local News · About: Big Local

970 rows where grade = "kindergarten", state = "MA" and year = 2017 sorted by total

View and edit SQL

year

  • 2017 · 870

grade

  • kindergarten · 870
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
1132392 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2017   kindergarten 11 0 1 0   0     0   1   4 9                       13 11 0 1 0   0     0   1   4 9                 13
1124018 MA Plymouth   school 2503360 52   Carver 250336002661 520015 Carver Elementary School   Regular School No Elementary PK 05 2017   kindergarten 129 1 0 0   0     0   0   60 70                       130 129 1 0 0   0     0   0   60 70                 130
1125978 MA Worcester   school 2506780 153   Leominster 250678000990 1530040 Priest Street   Regular School No Elementary KG KG 2017   kindergarten 61 4 51 0   6     0   8   66 64                       130 61 4 51 0   6     0   8   66 64                 130
1127556 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2017   kindergarten 118 1 1 0   4     0   6   69 61                       130 118 1 1 0   4     0   6   69 61                 130
1125737 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2017   kindergarten 129 2 0 0   0     0   0   70 61                       131 129 2 0 0   0     0   0   70 61                 131
1127400 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Francis T Bresnahan Elementary   Regular School No Elementary PK 03 2017   kindergarten 120 0 5 0   4     0   3   67 65                       132 120 0 5 0   4     0   3   67 65                 132
1121946 MA Plymouth   school 2501650 1   Abington 250165002727 10002 Center Elementary School   Regular School No Elementary PK KG 2017   kindergarten 115 5 12 0   2     0   0   73 61                       134 115 5 12 0   2     0   0   73 61                 134
1126914 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2017   kindergarten 81 1 39 0   5     0   8   70 64                       134 81 1 39 0   5     0   8   70 64                 134
1128521 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No Elementary PK 05 2017   kindergarten 38 1 84 0   9     0   2   69 65                       134 38 1 84 0   9     0   2   69 65                 134
1130546 MA Middlesex   school 2513050 342   Wilmington 251305002157 3420015 Wildwood   Regular School No Elementary PK KG 2017   kindergarten 114 4 5 1   5     0   7   77 59                       136 114 4 5 1   5     0   7   77 59                 136
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
1124217 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 03 2017   kindergarten 94 6 34 0   2     0   3   66 73                       139 94 6 34 0   2     0   3   66 73                 139
1125758 MA Essex   school 2506660 149   Lawrence 250666000471 1490002 Lawlor Early Childhood Center   Regular School No Elementary KG KG 2017   kindergarten 2 1 134 0   1     0   1   72 67                       139 2 1 134 0   1     0   1   72 67                 139
1122668 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   kindergarten 4 0 10 0   0     0   0   6 8                       14 4 0 10 0   0     0   0   6 8                 14
1130310 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2017   kindergarten 13 0 1 0   0     0   0   9 5                       14 13 0 1 0   0     0   0   9 5                 14
1131449 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   kindergarten 10 0 0 0   0     0   4   6 8                       14 10 0 0 0   0     0   4   6 8                 14
1132086 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   kindergarten 14 0 0 0   0     0   0   5 9                       14 14 0 0 0   0     0   0   5 9                 14
1132174 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No Elementary KG 06 2017   kindergarten 13 0 1 0   0     0   0   7 7                       14 13 0 1 0   0     0   0   7 7                 14
1122349 MA Hampshire   school 2502430 24   Belchertown 250243000136 240005 Cold Spring   Regular School No Elementary PK KG 2017   kindergarten 124 2 6 0   1     0   8   67 74                       141 124 2 6 0   1     0   8   67 74                 141
1132238 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2017   kindergarten 123 4 4 0   4     0   6   66 75                       141 123 4 4 0   4     0   6   66 75                 141
1124492 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2017   kindergarten 128 2 2 1   1     0   8   77 65                       142 128 2 2 1   1     0   8   77 65                 142
1131527 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2017   kindergarten 1 82 54 0   1     0   4   63 79                       142 1 82 54 0   1     0   4   63 79                 142
1126850 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No Elementary PK 01 2017   kindergarten 132 1 5 0   3     0   3   68 76                       144 132 1 5 0   3     0   3   68 76                 144
1130641 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 William P. Gorman/Fort Banks Elementary   Regular School No Elementary PK 02 2017   kindergarten 126 1 16 0   0     0   1   74 70                       144 126 1 16 0   0     0   1   74 70                 144
1127945 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2017   kindergarten 119 4 14 0   0     0   8   76 69                       145 119 4 14 0   0     0   8   76 69                 145
1126310 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No Elementary PK 01 2017   kindergarten 129 4 13 0   0     0   1   83 64                       147 129 4 13 0   0     0   1   83 64                 147
1132054 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No Elementary PK 01 2017   kindergarten 131 2 8 0   0     0   6   79 68                       147 131 2 8 0   0     0   6   79 68                 147
1129069 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No Elementary PK 01 2017   kindergarten 120 1 17 0   3     0   7   69 79                       148 120 1 17 0   3     0   7   69 79                 148
1129712 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2017   kindergarten 128 7 8 0   5     1   0   75 74                       149 128 7 8 0   5     1   0   75 74                 149
1130056 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No Elementary PK 04 2017   kindergarten 102 5 31 0   2     0   9   77 72                       149 102 5 31 0   2     0   9   77 72                 149
1126003 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2017   kindergarten 12 0 0 0   0     0   3   10 5                       15 12 0 0 0   0     0   3   10 5                 15
1130516 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2017   kindergarten 15 0 0 0   0     0   0   6 9                       15 15 0 0 0   0     0   0   6 9                 15
1131942 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2017   kindergarten 14 0 0 0   0     0   1   10 5                       15 14 0 0 0   0     0   1   10 5                 15
1132744 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   kindergarten 15 0 0 0   0     0   0   9 6                       15 15 0 0 0   0     0   0   9 6                 15
1125387 MA Essex   school 2505970 128   Haverhill 250597000851 1280020 Crowell   Regular School No Elementary KG KG 2017   kindergarten 53 6 85 1   1     0   4   80 70                       150 53 6 85 1   1     0   4   80 70                 150
1125378 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Bartlett Kindergarten Center   Regular School No Elementary KG KG 2017   kindergarten 55 7 87 0   1     0   1   88 63                       151 55 7 87 0   1     0   1   88 63                 151
1127762 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No Elementary PK 01 2017   kindergarten 128 0 14 1   4     0   9   82 74                       156 128 0 14 1   4     0   9   82 74                 156
1127001 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No Elementary KG 02 2017   kindergarten 95 5 50 0   2     1   4   78 79                       157 95 5 50 0   2     1   4   78 79                 157
1124207 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   kindergarten 16 0 0 0   0     0   0   7 9                       16 16 0 0 0   0     0   0   7 9                 16
1124295 MA Essex   school 2503990 71   Danvers 250399000531 710015 Great Oak   Regular School No Elementary KG 05 2017   kindergarten 12 0 3 0   0     0   1   8 8                       16 12 0 3 0   0     0   1   8 8                 16
1128196 MA Plymouth   school 2509720 239   Plymouth 250972001541 2390010 Hedge   Regular School No Elementary KG 05 2017   kindergarten 13 1 1 0   0     0   1   9 7                       16 13 1 1 0   0     0   1   9 7                 16
1130525 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2017   kindergarten 15 1 0 0   0     0   0   7 9                       16 15 1 0 0   0     0   0   7 9                 16
1132597 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2017   kindergarten 16 0 0 0   0     0   0   9 7                       16 16 0 0 0   0     0   0   9 7                 16
1126997 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No Elementary KG 02 2017   kindergarten 104 3 44 1   2     0   7   88 73                       161 104 3 44 1   2     0   7   88 73                 161
1124478 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2017   kindergarten 156 0 4 0   2     0   4   80 86                       166 156 0 4 0   2     0   4   80 86                 166
1131904 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002102 6250020 Merrill Elementary School   Regular School No Elementary KG 01 2017   kindergarten 147 10 0 0   5     0   4   82 84                       166 147 10 0 0   5     0   4   82 84                 166
1124279 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   kindergarten 15 0 2 0   0     0   0   11 6                       17 15 0 2 0   0     0   0   11 6                 17
1127111 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2017   kindergarten 17 0 0 0   0     0   0   6 11                       17 17 0 0 0   0     0   0   6 11                 17
1128547 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   kindergarten 17 0 0 0   0     0   0   10 7                       17 17 0 0 0   0     0   0   10 7                 17
1132269 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2017   kindergarten 13 0 4 0   0     0   0   9 8                       17 13 0 4 0   0     0   0   9 8                 17
1132487 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No Elementary PK 06 2017   kindergarten 15 0 1 0   0     0   1   7 10                       17 15 0 1 0   0     0   1   7 10                 17
1124550 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2017   kindergarten 145 1 11 0   9     0   5   91 80                       171 145 1 11 0   9     0   5   91 80                 171
1129970 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary KG 02 2017   kindergarten 128 10 11 1   1     0   22   75 98                       173 128 10 11 1   1     0   22   75 98                 173
1129051 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No Elementary PK 02 2017   kindergarten 69 2 101 0   2     0   0   84 90                       174 69 2 101 0   2     0   0   84 90                 174
1126776 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2017   kindergarten 150 2 12 0   6     0   6   99 77                       176 150 2 12 0   6     0   6   99 77                 176
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
1126669 MA Middlesex   school 2507320 170   Marlborough 250732001631 1700030 Charles Jaworek School   Regular School No Elementary KG 04 2017   kindergarten 84 2 74 0   16     0   1   92 85                       177 84 2 74 0   16     0   1   92 85                 177
1131200 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   kindergarten 5 104 64 0   5     0   0   81 97                       178 5 104 64 0   5     0   0   81 97                 178
1128898 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2017   kindergarten 15 0 1 0   0     0   2   10 8                       18 15 0 1 0   0     0   2   10 8                 18
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
1131264 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   kindergarten 0 14 4 0   0     0   0   6 12                       18 0 14 4 0   0     0   0   6 12                 18
1124365 MA Norfolk   school 2504050 73   Dedham 250405000460 730005 Early Childhood Center   Regular School No Elementary PK KG 2017   kindergarten 125 12 32 1   3     0   14   100 87                       187 125 12 32 1   3     0   14   100 87                 187
1128731 MA Essex   school 2510500 262   Saugus 251050001677 2620067 Douglas Waybright   Regular School No Elementary KG 05 2017   kindergarten 16 0 1 0   2     0   0   9 10                       19 16 0 1 0   2     0   0   9 10                 19
1129842 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2017   kindergarten 18 0 1 0   0     0   0   11 8                       19 18 0 1 0   0     0   0   11 8                 19
1132407 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2017   kindergarten 17 0 2 0   0     0   0   10 9                       19 17 0 2 0   0     0   0   10 9                 19
1132581 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2017   kindergarten 19 0 0 0   0     0   0   4 15                       19 19 0 0 0   0     0   0   4 15                 19
1132621 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   kindergarten 18 0 1 0   0     0   0   12 7                       19 18 0 1 0   0     0   0   12 7                 19
1132637 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary PK 01 2017   kindergarten 19 0 0 0   0     0   0   8 11                       19 19 0 0 0   0     0   0   8 11                 19
1132694 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2017   kindergarten 19 0 0 0   0     0   0   11 8                       19 19 0 0 0   0     0   0   11 8                 19
1122331 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2017   kindergarten 130 5 12 0   30     0   15   98 94                       192 130 5 12 0   30     0   15   98 94                 192
1125102 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2017   kindergarten 139 1 37 0   1     0   16   86 108                       194 139 1 37 0   1     0   16   86 108                 194
1123060 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2017   kindergarten 6 10 3 0   1     0   0   10 10                       20 6 10 3 0   1     0   0   10 10                 20
1123538 MA Norfolk   school 2502940 40   Braintree 250294000363 400050 Donald Ross   Regular School No Elementary KG 05 2017   kindergarten 14 2 0 0   4     0   0   11 9                       20 14 2 0 0   4     0   0   11 9                 20
1126438 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No Elementary KG 05 2017   kindergarten 13 0 3 0   1     0   3   9 11                       20 13 0 3 0   1     0   3   9 11                 20
1128091 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2017   kindergarten 17 0 1 0   0     0   2   7 13                       20 17 0 1 0   0     0   2   7 13                 20
1128873 MA Worcester   school 2510770 271   Shrewsbury 251077001719 2710025 Walter J Paton   Regular School No Elementary KG 04 2017   kindergarten 15 1 0 0   3     0   1   13 7                       20 15 1 0 0   3     0   1   13 7                 20
1131373 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2017   kindergarten 14 0 0 0   1     0   5   10 10                       20 14 0 0 0   1     0   5   10 10                 20
1133196 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   kindergarten 11 3 5 0   0     0   1   9 11                       20 11 3 5 0   0     0   1   9 11                 20
1125525 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2017   kindergarten 172 1 9 0   15     0   11   104 104                       208 172 1 9 0   15     0   11   104 104                 208
1122589 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   kindergarten 12 3 5 0   1     0   0   13 8                       21 12 3 5 0   1     0   0   13 8                 21
1122887 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2017   kindergarten 7 0 9 0   2     0   3   10 11                       21 7 0 9 0   2     0   3   10 11                 21
1128050 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2017   kindergarten 17 2 1 0   0     0   1   15 6                       21 17 2 1 0   0     0   1   15 6                 21
1122186 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2017   kindergarten 144 2 26 0   31     0   10   111 102                       213 144 2 26 0   31     0   10   111 102                 213
1123598 MA Plymouth   school 2503090 44   Brockton 250309002792 440007 Barrett Russell School   Regular School No Elementary KG KG 2017   kindergarten 24 129 42 1   4     0   19   117 102                       219 24 129 42 1   4     0   19   117 102                 219
1131898 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2017   kindergarten 189 15 4 0   5     0   6   117 102                       219 189 15 4 0   5     0   6   117 102                 219
1122983 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   kindergarten 21 1 0 0   0     0   0   10 12                       22 21 1 0 0   0     0   0   10 12                 22
1123511 MA Norfolk   school 2502940 40   Braintree 250294000365 400015 Highlands   Regular School No Elementary KG 05 2017   kindergarten 19 0 1 0   2     0   0   12 10                       22 19 0 1 0   2     0   0   12 10                 22
1130466 MA Norfolk   school 2512840 336   Weymouth 251284002565 3360050 Frederick C Murphy   Regular School No Elementary KG 04 2017   kindergarten 20 1 1 0   0     0   0   11 11                       22 20 1 1 0   0     0   0   11 11                 22
1130742 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   kindergarten 7 2 11 0   0     0   2   11 11                       22 7 2 11 0   0     0   2   11 11                 22
1131934 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   kindergarten 21 0 0 1   0     0   0   11 11                       22 21 0 0 1   0     0   0   11 11                 22
1132423 MA Worcester   school 2508280 720   Narragansett 250828001287 7200003 Phillipston Memorial   Regular School No Elementary PK 04 2017   kindergarten 19 1 0 1   0     0   1   14 8                       22 19 1 0 1   0     0   1   14 8                 22
1125647 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Center   Regular School No Elementary KG 01 2017   kindergarten 186 1 4 1   30     0   2   111 113                       224 186 1 4 1   30     0   2   111 113                 224
1126347 MA Essex   school 2507110 163   Lynn 250711002801 1630004 Early Childhood Center   Regular School No Elementary PK 05 2017   kindergarten 29 22 140 1   24     0   8   117 107                       224 29 22 140 1   24     0   8   117 107                 224
1130362 MA Hampden   school 2512510 332   West Springfield 251251002504 3320005 John Ashley   Regular School No Elementary KG KG 2017   kindergarten 169 6 40 0   5     0   6   121 105                       226 169 6 40 0   5     0   6   121 105                 226
1122753 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No Elementary PK 05 2017   kindergarten 7 5 11 0   0     0   0   16 7                       23 7 5 11 0   0     0   0   16 7                 23
1122975 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2017   kindergarten 4 7 10 0   1     0   1   10 13                       23 4 7 10 0   1     0   1   10 13                 23
1123224 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2017   kindergarten 12 5 6 0   0     0   0   10 13                       23 12 5 6 0   0     0   0   10 13                 23
1127351 MA Bristol   school 2508430 201   New Bedford 250843001330 2010130 Jireh Swift   Regular School No Elementary KG 05 2017   kindergarten 17 3 2 0   1     0   0   11 12                       23 17 3 2 0   1     0   0   11 12                 23
1130407 MA Norfolk   school 2512810 335   Westwood 251281000794 3350010 Deerfield School   Regular School No Elementary KG 05 2017   kindergarten 17 1 1 0   3     0   1   17 6                       23 17 1 1 0   3     0   1   17 6                 23
1133182 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   kindergarten 13 3 3 0   1     0   3   11 12                       23 13 3 3 0   1     0   3   11 12                 23

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