enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 970 ✖

grade ✖

  • kindergarten · 970 ✖
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 ▼
1123194 1123194 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   kindergarten * * * *   *     *   *   1 1                       *                         1 1                  
1125185 1125185 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   kindergarten * * * *   *     *   *   * *                       *                                              
1125259 1125259 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   kindergarten * * * *   *     *   *   * *                       *                                              
1125389 1125389 MA Essex   school 2505970 128   Haverhill 250597000296 1280026 Golden Hill   Regular School No Elementary KG 04 2017   kindergarten * * * *   *     *   *   1 3                       *                         1 3                  
1126445 1126445 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   kindergarten * * * *   *     *   *   1 *                       *                         1                    
1130371 1130371 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No Elementary KG 05 2017   kindergarten * * * *   *     *   *   1 1                       *                         1 1                  
1132401 1132401 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No Elementary PK 06 2017   kindergarten * * * *   *     *   *   2 3                       *                         2 3                  
1132701 1132701 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No Elementary KG 01 2017   kindergarten 6 0 0 0   0     0   0   4 *                       6 6 0 0 0   0     0   0   4                   6
1124919 1124919 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   kindergarten 7 0 0 0   0     0   0   4 3                       7 7 0 0 0   0     0   0   4 3                 7
1132725 1132725 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   kindergarten 7 0 0 0   0     0   0   3 4                       7 7 0 0 0   0     0   0   3 4                 7
1123442 1123442 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   kindergarten 2 4 2 0   0     0   0   6 2                       8 2 4 2 0   0     0   0   6 2                 8
1128271 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
1132125 1132125 MA Hampden   school 2505160 672   Gateway 250516000757 6720059 Chester Elementary   Regular School No Elementary PK 05 2017   kindergarten 7 0 0 1   0     0   0   4 4                       8 7 0 0 1   0     0   0   4 4                 8
1132590 1132590 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No Elementary PK 06 2017   kindergarten 8 0 0 0   0     0   0   4 4                       8 8 0 0 0   0     0   0   4 4                 8
1132606 1132606 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary KG 06 2017   kindergarten 8 0 0 0   0     0   0   6 2                       8 8 0 0 0   0     0   0   6 2                 8
1132817 1132817 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2017   kindergarten 6 0 0 0   0     0   2   3 5                       8 6 0 0 0   0     0   2   3 5                 8
1128747 1128747 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   kindergarten 8 0 1 0   0     0   0   7 2                       9 8 0 1 0   0     0   0   7 2                 9
1124607 1124607 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2017   kindergarten 9 0 0 0   0     0   2   8 3                       11 9 0 0 0   0     0   2   8 3                 11
1122561 1122561 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2017   kindergarten 1 3 6 0   2     0   0   6 6                       12 1 3 6 0   2     0   0   6 6                 12
1124302 1124302 MA Essex   school 2503990 71   Danvers 250399000536 710030 Riverside   Regular School No Elementary PK 05 2017   kindergarten 10 1 1 0   0     0   0   6 6                       12 10 1 1 0   0     0   0   6 6                 12
1128612 1128612 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2017   kindergarten 10 0 1 0   0     0   1   7 5                       12 10 0 1 0   0     0   1   7 5                 12
1129759 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
1131070 1131070 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   kindergarten 11 0 0 0   1     0   0   3 9                       12 11 0 0 0   1     0   0   3 9                 12
1131805 1131805 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2017   kindergarten 12 0 0 0   0     0   0   7 5                       12 12 0 0 0   0     0   0   7 5                 12
1132392 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
1122668 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 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 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 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 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
1126003 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 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 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 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
1124207 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 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 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 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 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
1124279 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 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 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 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 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
1128898 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 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 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
1128731 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 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 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 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 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 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 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
1123060 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 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 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 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 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 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 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
1122589 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 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 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
1122983 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 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 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 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 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 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
1122753 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 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 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 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 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 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
1123531 1123531 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Archie T Morrison   Regular School No Elementary KG 05 2017   kindergarten 17 3 0 0   4     0   0   13 11                       24 17 3 0 0   4     0   0   13 11                 24
1127686 1127686 MA Bristol   school 2508730 212   North Attleborough 250873001402 2120010 Falls   Regular School No Elementary KG 05 2017   kindergarten 20 1 2 0   1     0   0   12 12                       24 20 1 2 0   1     0   0   12 12                 24
1122837 1122837 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2017   kindergarten 8 9 7 0   0     0   1   13 12                       25 8 9 7 0   0     0   1   13 12                 25
1123518 1123518 MA Norfolk   school 2502940 40   Braintree 250294000367 400020 Mary E Flaherty School   Regular School No Elementary KG 05 2017   kindergarten 18 1 0 0   6     0   0   11 14                       25 18 1 0 0   6     0   0   11 14                 25
1123631 1123631 MA Plymouth   school 2503090 44   Brockton 250309000221 440050 Gilmore School Early Childhood Center   Regular School No Elementary PK KG 2017   kindergarten 4 13 5 0   1     0   2   19 6                       25 4 13 5 0   1     0   2   19 6                 25
1124154 1124154 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2017   kindergarten 19 1 5 0   0     0   0   13 12                       25 19 1 5 0   0     0   0   13 12                 25
1130246 1130246 MA Hampden   school 2512630 325   Westfield 251263002066 3250055 Russell Elementary School   Regular School No Elementary KG 05 2017   kindergarten 23 0 3 0   0     0   0   11 15                       26 23 0 3 0   0     0   0   11 15                 26
1122956 1122956 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2017   kindergarten 12 6 6 0   1     0   2   19 8                       27 12 6 6 0   1     0   2   19 8                 27
1124509 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
1122442 1122442 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   kindergarten 26 1 0 0   1     0   0   14 14                       28 26 1 0 0   1     0   0   14 14                 28
1125291 1125291 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   kindergarten 21 2 1 1   0     2   1   15 13                       28 21 2 1 1   0     2   1   15 13                 28
1129738 1129738 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   kindergarten 15 2 8 0   0     0   3   17 11                       28 15 2 8 0   0     0   3   17 11                 28
1131742 1131742 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No Elementary PK 05 2017   kindergarten 28 0 0 0   0     0   0   14 14                       28 28 0 0 0   0     0   0   14 14                 28
1123164 1123164 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2017   kindergarten 7 5 12 0   5     0   0   14 15                       29 7 5 12 0   5     0   0   14 15                 29
1125746 1125746 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   kindergarten 28 1 0 0   0     0   0   15 14                       29 28 1 0 0   0     0   0   15 14                 29
1127579 1127579 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 07 2017   kindergarten 25 0 2 0   0     0   2   16 13                       29 25 0 2 0   0     0   2   16 13                 29
1127739 1127739 MA Worcester   school 2508880 213   Northborough 250888001436 2130015 Fannie E Proctor   Regular School No Elementary KG 05 2017   kindergarten 23 0 5 0   1     0   0   18 11                       29 23 0 5 0   1     0   0   18 11                 29
1128263 1128263 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2017   kindergarten 27 0 0 0   0     0   2   18 11                       29 27 0 0 0   0     0   2   18 11                 29
1128717 1128717 MA Essex   school 2510500 262   Saugus 251050001682 2620050 Oaklandvale   Regular School No Elementary KG 05 2017   kindergarten 22 1 3 0   3     0   0   13 16                       29 22 1 3 0   3     0   0   13 16                 29
1130704 1130704 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   kindergarten 19 1 3 0   5     0   1   15 14                       29 19 1 3 0   5     0   1   15 14                 29
1131958 1131958 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No Elementary PK 05 2017   kindergarten 28 0 0 0   0     0   1   10 19                       29 28 0 0 0   0     0   1   10 19                 29
1132299 1132299 MA Essex   school 2500067 698   Manchester Essex Regional 250006700627 6980020 Essex Elementary   Regular School No Elementary KG 05 2017   kindergarten 28 0 1 0   0     0   0   15 14                       29 28 0 1 0   0     0   0   15 14                 29
1123502 1123502 MA Norfolk   school 2502940 40   Braintree 250294002570 400005 Hollis   Regular School No Elementary KG 05 2017   kindergarten 21 2 0 0   7     0   0   17 13                       30 21 2 0 0   7     0   0   17 13                 30
1125362 1125362 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   kindergarten 27 0 2 0   0     0   1   18 12                       30 27 0 2 0   0     0   1   18 12                 30

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