Data source: Big Local News · About: Big Local

964 rows where grade = "kindergarten", state = "MA" and year = 2016 sorted by white

View and edit SQL

year

  • 2016 · 964

grade

  • kindergarten · 964
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
933811 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   kindergarten * * * *   *     *   *   1 3                       4                         1 3                 4
938149 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No 1 PK 06 2016   kindergarten * * * *   *     *   *   1 2                       3                         1 2                 3
941537 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No 1 PK 06 2016   kindergarten * * * *   *     *   *   2 2                       4                         2 2                 4
941717 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No 1 KG 05 2016   kindergarten * * * *   *     *   *   2 1                       3                         2 1                 3
933288 MA Suffolk   school 2502790 35   Boston 250279000270 350180 John Winthrop   Regular School No 1 PK 05 2016   kindergarten 0 34 20 0   4     0   2   26 34                       60 0 34 20 0   4     0   2   26 34                 60
933400 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No 1 PK 05 2016   kindergarten 0 14 6 0   0     0   1   8 13                       21 0 14 6 0   0     0   1   8 13                 21
933497 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2016   kindergarten 0 9 32 0   0     0   2   21 22                       43 0 9 32 0   0     0   2   21 22                 43
933604 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 1 PK 08 2016   kindergarten 0 33 9 0   1     0   1   17 27                       44 0 33 9 0   1     0   1   17 27                 44
940222 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes 1 PK 04 2016   kindergarten 0 29 16 0   0     0   0   19 26                       45 0 29 16 0   0     0   0   19 26                 45
940275 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes 1 PK 04 2016   kindergarten 0 19 14 0   1     0   0   15 19                       34 0 19 14 0   1     0   0   15 19                 34
940333 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes 1 PK 04 2016   kindergarten 0 0 41 0   1     0   0   24 18                       42 0 0 41 0   1     0   0   24 18                 42
940361 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2016   kindergarten 0 17 5 0   0     0   0   10 12                       22 0 17 5 0   0     0   0   10 12                 22
940383 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2016   kindergarten 0 1 49 0   0     0   0   25 25                       50 0 1 49 0   0     0   0   25 25                 50
940490 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   kindergarten 0 0 80 0   0     0   0   36 44                       80 0 0 80 0   0     0   0   36 44                 80
940532 MA Essex   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes 1 KG 08 2016   kindergarten 0 50 21 0   0     0   0   36 35                       71 0 50 21 0   0     0   0   36 35                 71
933055 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No 1 PK 03 2016   kindergarten 1 12 24 0   0     0   2   18 21                       39 1 12 24 0   0     0   2   18 21                 39
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
933089 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No 1 PK 02 2016   kindergarten 1 18 27 0   0     0   1   19 28                       47 1 18 27 0   0     0   1   19 28                 47
933119 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Charles H Taylor   Regular School No 1 PK 05 2016   kindergarten 1 48 11 0   0     0   3   38 25                       63 1 48 11 0   0     0   3   38 25                 63
933339 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Harvard-Kent   Regular School No 1 PK 05 2016   kindergarten 1 16 20 0   15     0   3   33 22                       55 1 16 20 0   15     0   3   33 22                 55
933367 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2016   kindergarten 1 22 32 0   0     0   3   30 28                       58 1 22 32 0   0     0   3   30 28                 58
933455 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No 1 PK 05 2016   kindergarten 1 15 42 0   7     0   1   35 31                       66 1 15 42 0   7     0   1   35 31                 66
933552 MA Suffolk   school 2502790 35   Boston 250279000337 350366 William E Russell   Regular School No 1 PK 05 2016   kindergarten 1 22 26 0   9     1   1   31 29                       60 1 22 26 0   9     1   1   31 29                 60
933776 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2016   kindergarten 1 4 62 0   2     0   0   27 42                       69 1 4 62 0   2     0   0   27 42                 69
935617 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No 1 KG 03 2016   kindergarten 1 4 84 0   0     0   1   44 46                       90 1 4 84 0   0     0   1   44 46                 90
935746 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No 1 KG 04 2016   kindergarten 1 1 103 0   0     0   0   58 47                       105 1 1 103 0   0     0   0   58 47                 105
935808 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2016   kindergarten 1 1 54 0   3     0   2   32 29                       61 1 1 54 0   3     0   2   32 29                 61
936283 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No 1 PK 05 2016   kindergarten 1 4 70 0   14     0   5   53 41                       94 1 4 70 0   14     0   5   53 41                 94
938576 MA Hampden   school 2511130 281   Springfield 251113001796 2810025 Brightwood   Regular School No 1 KG 05 2016   kindergarten 1 4 37 0   0     0   0   24 18                       42 1 4 37 0   0     0   0   24 18                 42
938595 MA Hampden   school 2511130 281   Springfield 251113001838 2810045 William N. DeBerry   Regular School No 1 KG 05 2016   kindergarten 1 9 40 0   0     0   0   25 25                       50 1 9 40 0   0     0   0   25 25                 50
933076 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2016   kindergarten 10 31 26 0   15     1   6   47 42                       89 10 31 26 0   15     1   6   47 42                 89
933206 MA Suffolk   school 2502790 35   Boston 250279000241 350122 George H Conley   Regular School No 1 PK 05 2016   kindergarten 10 15 13 0   2     0   1   22 19                       41 10 15 13 0   2     0   1   22 19                 41
933295 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No 1 PK 05 2016   kindergarten 10 12 8 0   3     0   1   24 10                       34 10 12 8 0   3     0   1   24 10                 34
933469 MA Suffolk   school 2502790 35   Boston 250279000277 350286 Josiah Quincy   Regular School No 1 PK 05 2016   kindergarten 10 18 11 1   71     0   6   58 59                       117 10 18 11 1   71     0   6   58 59                 117
935598 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2016   kindergarten 10 1 45 0   1     0   2   32 27                       59 10 1 45 0   1     0   2   32 27                 59
935738 MA Essex   school 2506660 149   Lawrence 250666000471 1490002 Lawlor Early Childhood Center   Regular School No 1 KG KG 2016   kindergarten 10 3 136 0   0     1   1   65 86                       151 10 3 136 0   0     1   1   65 86                 151
938468 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No 1 PK 08 2016   kindergarten 10 3 16 0   2     0   2   16 17                       33 10 3 16 0   2     0   2   16 17                 33
938614 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No 1 PK 01 2016   kindergarten 10 17 31 0   0     0   3   40 21                       61 10 17 31 0   0     0   3   40 21                 61
940666 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2016   kindergarten 10 43 20 0   9     0   2   40 44                       84 10 43 20 0   9     0   2   40 44                 84
940791 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No 1 KG 06 2016   kindergarten 10 2 3 0   21     0   0   21 15                       36 10 2 3 0   21     0   0   21 15                 36
934487 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No 1 PK 02 2016   kindergarten 100 2 1 0   3     0   0   54 52                       106 100 2 1 0   3     0   0   54 52                 106
935376 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No 1 KG 02 2016   kindergarten 100 0 2 0   1     0   1   42 62                       104 100 0 2 0   1     0   1   42 62                 104
941036 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Palmer River   Regular School No 1 KG 04 2016   kindergarten 100 0 6 0   2     0   0   53 55                       108 100 0 6 0   2     0   0   53 55                 108
941065 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No 1 PK 01 2016   kindergarten 100 3 16 0   0     0   2   58 63                       121 100 3 16 0   0     0   2   58 63                 121
941824 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No 1 PK 02 2016   kindergarten 101 1 3 0   0     0   2   61 46                       107 101 1 3 0   0     0   2   61 46                 107
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
939833 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 William P. Gorman/Fort Banks Elementary   Regular School No 1 PK 03 2016   kindergarten 103 2 19 0   0     0   5   63 66                       129 103 2 19 0   0     0   5   63 66                 129
941107 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No 1 KG 03 2016   kindergarten 103 4 0 0   1     0   6   52 62                       114 103 4 0 0   1     0   6   52 62                 114
939591 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No 1 PK 02 2016   kindergarten 104 0 2 0   0     0   4   64 46                       110 104 0 2 0   0     0   4   64 46                 110
939354 MA Worcester   school 2512240 316   Webster 251224002018 3160015 Park Avenue Elementary   Regular School No 1 PK 04 2016   kindergarten 106 4 38 1   1     0   6   86 70                       156 106 4 38 1   1     0   6   86 70                 156
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
936807 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Elmwood Street   Regular School No 1 PK 03 2016   kindergarten 107 0 4 0   4     0   4   79 40                       119 107 0 4 0   4     0   4   79 40                 119
937583 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No 1 PK 02 2016   kindergarten 108 3 16 0   0     0   6   70 63                       133 108 3 16 0   0     0   6   70 63                 133
934469 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No 1 PK 03 2016   kindergarten 109 5 28 0   2     0   1   76 69                       145 109 5 28 0   2     0   1   76 69                 145
933040 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No 1 PK 01 2016   kindergarten 11 8 13 0   7     0   2   23 18                       41 11 8 13 0   7     0   2   23 18                 41
933066 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2016   kindergarten 11 4 7 0   0     0   3   9 16                       25 11 4 7 0   0     0   3   9 16                 25
933322 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No 1 PK 05 2016   kindergarten 11 2 5 0   1     0   2   11 10                       21 11 2 5 0   1     0   2   11 10                 21
934850 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2016   kindergarten 11 11 48 0   2     0   2   32 42                       74 11 11 48 0   2     0   2   32 42                 74
935958 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No 1 PK 06 2016   kindergarten 11 0 0 0   1     0   1   6 7                       13 11 0 0 0   1     0   1   6 7                 13
936308 MA Essex   school 2507110 163   Lynn 250711001075 1630060 Ingalls   Regular School No 1 KG 05 2016   kindergarten 11 7 54 0   16     0   11   41 58                       99 11 7 54 0   16     0   11   41 58                 99
938734 MA Hampden   school 2511130 281   Springfield 251113001836 2810185 Washington   Regular School No 1 PK 05 2016   kindergarten 11 17 39 0   4     0   2   46 27                       73 11 17 39 0   4     0   2   46 27                 73
939924 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No 1 PK 06 2016   kindergarten 11 8 57 0   4     0   2   36 46                       82 11 8 57 0   4     0   2   36 46                 82
939939 MA Worcester   school 2513230 348   Worcester 251323002203 3480045 Canterbury   Regular School No 1 PK 06 2016   kindergarten 11 6 26 0   8     0   3   33 21                       54 11 6 26 0   8     0   3   33 21                 54
941094 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No 1 PK 06 2016   kindergarten 11 0 0 0   0     0   0   7 4                       11 11 0 0 0   0     0   0   7 4                 11
941368 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No 1 PK 06 2016   kindergarten 11 0 0 0   0     0   0   4 7                       11 11 0 0 0   0     0   0   4 7                 11
941382 MA Worcester   school 2508280 720   Narragansett 250828001287 7200003 Phillipston Memorial   Regular School No 1 PK 04 2016   kindergarten 11 0 0 0   0     0   1   6 6                       12 11 0 0 0   0     0   1   6 6                 12
941611 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No 1 PK 04 2016   kindergarten 11 0 0 0   0     0   1   6 6                       12 11 0 0 0   0     0   1   6 6                 12
941222 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No 1 PK 01 2016   kindergarten 110 3 8 0   1     0   7   70 59                       129 110 3 8 0   1     0   7   70 59                 129
941734 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No 1 KG 02 2016   kindergarten 110 3 6 1   1     0   3   61 63                       124 110 3 6 1   1     0   3   61 63                 124
936033 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No 1 PK 02 2016   kindergarten 111 2 3 0   9     0   3   61 67                       128 111 2 3 0   9     0   3   61 67                 128
939755 MA Middlesex   school 2513050 342   Wilmington 251305000802 3420005 Boutwell   Regular School No 1 PK KG 2016   kindergarten 111 0 2 0   3     0   3   61 58                       119 111 0 2 0   3     0   3   61 58                 119
936212 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No 1 PK 01 2016   kindergarten 112 1 21 1   1     2   5   72 71                       143 112 1 21 1   1     2   5   72 71                 143
939067 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No 1 PK 02 2016   kindergarten 112 3 6 0   4     0   2   75 52                       127 112 3 6 0   4     0   2   75 52                 127
938528 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No 1 PK 01 2016   kindergarten 116 2 11 1   2     0   3   74 61                       135 116 2 11 1   2     0   3   74 61                 135
941068 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No 1 PK 01 2016   kindergarten 117 0 11 0   4     0   0   77 55                       132 117 0 11 0   4     0   0   77 55                 132
939126 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Taft Early Learning Center   Regular School No 1 PK 02 2016   kindergarten 119 0 4 0   2     0   2   71 56                       127 119 0 4 0   2     0   2   71 56                 127
933112 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No 1 PK 05 2016   kindergarten 12 13 47 0   2     0   5   36 43                       79 12 13 47 0   2     0   5   36 43                 79
933153 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No 1 PK 08 2016   kindergarten 12 9 12 0   0     0   5   20 18                       38 12 9 12 0   0     0   5   20 18                 38
936332 MA Essex   school 2507110 163   Lynn 250711001084 1630085 Sewell-Anderson   Regular School No 1 KG 05 2016   kindergarten 12 1 16 0   2     0   3   21 13                       34 12 1 16 0   2     0   3   21 13                 34
937972 MA Norfolk   school 2509930 244   Randolph 250993002596 2440018 J F Kennedy Elementary   Regular School No 1 PK 05 2016   kindergarten 12 30 4 0   9     0   3   38 20                       58 12 30 4 0   9     0   3   38 20                 58
938095 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2016   kindergarten 12 0 3 0   0     0   0   7 8                       15 12 0 3 0   0     0   0   7 8                 15
938243 MA Essex   school 2510500 262   Saugus 251050001677 2620067 Douglas Waybright   Regular School No 1 KG 05 2016   kindergarten 12 0 3 0   2     0   0   9 8                       17 12 0 3 0   2     0   0   9 8                 17
938419 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No 1 PK 08 2016   kindergarten 12 3 18 0   3     0   4   22 18                       40 12 3 18 0   3     0   4   22 18                 40
938683 MA Hampden   school 2511130 281   Springfield 251113001820 2810125 Mary A. Dryden Veterans Memorial School   Regular School No 1 PK 05 2016   kindergarten 12 3 27 0   4     0   2   18 30                       48 12 3 27 0   4     0   2   18 30                 48
939246 MA Middlesex   school 2512000 308   Waltham 251200001969 3080065 Henry Whittemore Elementary School   Regular School No 1 KG 05 2016   kindergarten 12 4 60 0   0     0   0   46 30                       76 12 4 60 0   0     0   0   46 30                 76
939419 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No 1 PK 05 2016   kindergarten 12 1 1 0   0     0   3   7 10                       17 12 1 1 0   0     0   3   7 10                 17
939731 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No 1 PK 06 2016   kindergarten 12 0 1 0   0     0   0   7 6                       13 12 0 1 0   0     0   0   7 6                 13
939954 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No 1 PK 06 2016   kindergarten 12 6 65 0   2     0   1   39 47                       86 12 6 65 0   2     0   1   39 47                 86
939978 MA Worcester   school 2513230 348   Worcester 251323002207 3480060 Columbus Park   Regular School No 1 PK 06 2016   kindergarten 12 6 32 0   4     0   5   34 25                       59 12 6 32 0   4     0   5   34 25                 59
940017 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No 1 PK 06 2016   kindergarten 12 9 25 0   5     0   4   27 28                       55 12 9 25 0   5     0   4   27 28                 55
940657 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes 1 KG 08 2016   kindergarten 12 49 26 0   1     0   8   50 46                       96 12 49 26 0   1     0   8   50 46                 96
941637 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No 1 KG 06 2016   kindergarten 12 0 0 0   0     0   0   6 6                       12 12 0 0 0   0     0   0   6 6                 12
935208 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No 1 PK 01 2016   kindergarten 120 5 26 0   4     0   17   76 96                       172 120 5 26 0   4     0   17   76 96                 172
937258 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No 1 PK 02 2016   kindergarten 120 0 8 0   1     0   3   74 58                       132 120 0 8 0   1     0   3   74 58                 132
939757 MA Middlesex   school 2513050 342   Wilmington 251305002157 3420015 Wildwood   Regular School No 1 PK KG 2016   kindergarten 120 1 3 0   10     1   5   65 75                       140 120 1 3 0   10     1   5   65 75                 140
932852 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No 1 KG 02 2016   kindergarten 121 12 15 0   26     0   16   99 91                       190 121 12 15 0   26     0   16   99 91                 190
937127 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Francis T Bresnahan Elementary   Regular School No 1 PK 03 2016   kindergarten 126 1 8 1   0     0   0   72 64                       136 126 1 8 1   0     0   0   72 64                 136
932733 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No 1 KG 02 2016   kindergarten 128 2 24 1   25     1   9   97 93                       190 128 2 24 1   25     1   9   97 93                 190
933383 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No 1 PK 05 2016   kindergarten 13 9 4 0   1     0   1   19 9                       28 13 9 4 0   1     0   1   19 9                 28
934438 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Gen John J Stefanik   Regular School No 1 KG 05 2016   kindergarten 13 5 51 0   1     0   1   31 40                       71 13 5 51 0   1     0   1   31 40                 71

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