enrollments

Data source: Big Local News · About: Big Local

982 rows where grade = "grade_2", state = "MA" and year = 2017 sorted by black

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 882 ✖

grade ✖

  • grade_2 · 882 ✖
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
1127749 1127749 MA Worcester   school 2508880 213   Northborough 250888001208 2130020 Marion E Zeh   Regular School No Elementary PK 05 2017   grade_2 32 0 1 0   6     0   1   27 13                       40 32 0 1 0   6     0   1   27 13                 40
1127779 1127779 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_2 33 0 1 0   0     0   1   19 16                       35 33 0 1 0   0     0   1   19 16                 35
1127795 1127795 MA Middlesex   school 2508820 217   North Reading 250882000505 2170003 E Ethel Little School   Regular School No Elementary PK 05 2017   grade_2 37 0 1 0   3     0   5   30 16                       46 37 0 1 0   3     0   5   30 16                 46
1127802 1127802 MA Middlesex   school 2508820 217   North Reading 250882001420 2170005 L D Batchelder   Regular School No Elementary KG 05 2017   grade_2 64 0 1 0   1     0   1   39 28                       67 64 0 1 0   1     0   1   39 28                 67
1127809 1127809 MA Middlesex   school 2508820 217   North Reading 250882001419 2170010 J Turner Hood   Regular School No Elementary PK 05 2017   grade_2 57 0 1 0   3     0   1   30 32                       62 57 0 1 0   3     0   1   30 32                 62
1127857 1127857 MA Plymouth   school 2509030 219   Norwell 250903001458 2190020 William G Vinal   Regular School No Elementary PK 05 2017   grade_2 82 0 0 0   0     0   3   43 42                       85 82 0 0 0   0     0   3   43 42                 85
1127990 1127990 MA Essex   school 2509360 229   Peabody 250936001496 2290007 John E Burke   Regular School No Elementary KG 05 2017   grade_2 35 0 2 0   0     0   1   23 15                       38 35 0 2 0   0     0   1   23 15                 38
1128077 1128077 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No Elementary PK 06 2017   grade_2 72 0 0 0   1     0   3   41 35                       76 72 0 0 0   1     0   3   41 35                 76
1128093 1128093 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2017   grade_2 18 0 0 0   0     0   0   8 10                       18 18 0 0 0   0     0   0   8 10                 18
1128116 1128116 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2017   grade_2 26 0 1 0   0     0   4   20 11                       31 26 0 1 0   0     0   4   20 11                 31
1128139 1128139 MA Berkshire   school 2509630 236   Pittsfield 250963002489 2360090 Stearns   Regular School No Elementary KG 05 2017   grade_2 40 0 4 0   1     0   3   26 22                       48 40 0 4 0   1     0   3   26 22                 48
1128198 1128198 MA Plymouth   school 2509720 239   Plymouth 250972001541 2390010 Hedge   Regular School No Elementary KG 05 2017   grade_2 28 0 3 0   1     0   4   20 16                       36 28 0 3 0   1     0   4   20 16                 36
1128219 1128219 MA Plymouth   school 2509720 239   Plymouth 250972001543 2390015 Manomet Elementary   Regular School No Elementary KG 05 2017   grade_2 51 0 0 0   0     0   1   25 27                       52 51 0 0 0   0     0   1   25 27                 52
1128265 1128265 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2017   grade_2 21 0 0 0   0     0   0   11 10                       21 21 0 0 0   0     0   0   11 10                 21
1128286 1128286 MA Norfolk   school 2509870 243   Quincy 250987000772 2430020 Beechwood Knoll Elementary   Regular School No Elementary KG 05 2017   grade_2 39 0 0 0   13     0   0   23 29                       52 39 0 0 0   13     0   0   23 29                 52
1128490 1128490 MA Suffolk   school 2510050 248   Revere 251005001962 2480013 Beachmont Veterans Memorial School   Regular School No Elementary PK 05 2017   grade_2 19 0 24 0   1     0   2   25 21                       46 19 0 24 0   1     0   2   25 21                 46
1128550 1128550 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_2 17 0 0 0   0     0   1   7 11                       18 17 0 0 0   0     0   1   7 11                 18
1128580 1128580 MA Plymouth   school 2510170 251   Rockland 251017001708 2510060 Jefferson Elementary School   Regular School No Elementary KG 04 2017   grade_2 47 0 3 0   1     0   2   20 33                       53 47 0 3 0   1     0   2   20 33                 53
1128598 1128598 MA Essex   school 2510200 252   Rockport 251020002533 2520005 Rockport Elementary   Regular School No Elementary PK 05 2017   grade_2 55 0 2 0   2     0   1   30 30                       60 55 0 2 0   2     0   1   30 30                 60
1128615 1128615 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2017   grade_2 7 0 1 0   0     0   0   4 4                       8 7 0 1 0   0     0   0   4 4                 8
1128750 1128750 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   grade_2 9 0 0 0   0     0   0   3 6                       9 9 0 0 0   0     0   0   3 6                 9
1128836 1128836 MA Norfolk   school 2510620 266   Sharon 251062001704 2660015 Heights Elementary   Regular School No Elementary KG 05 2017   grade_2 42 0 4 0   26     0   6   40 38                       78 42 0 4 0   26     0   6   40 38                 78
1128854 1128854 MA Middlesex   school 2510710 269   Sherborn 251071001709 2690010 Pine Hill   Regular School No Elementary PK 05 2017   grade_2 53 0 1 0   4     0   5   37 26                       63 53 0 1 0   4     0   5   37 26                 63
1128875 1128875 MA Worcester   school 2510770 271   Shrewsbury 251077001719 2710025 Walter J Paton   Regular School No Elementary KG 04 2017   grade_2 62 0 6 0   16     0   6   48 42                       90 62 0 6 0   16     0   6   48 42                 90
1128884 1128884 MA Worcester   school 2510770 271   Shrewsbury 251077001718 2710035 Spring Street   Regular School No Elementary KG 04 2017   grade_2 51 0 10 0   21     0   5   42 45                       87 51 0 10 0   21     0   5   42 45                 87
1128901 1128901 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2017   grade_2 17 0 1 0   0     0   2   9 11                       20 17 0 1 0   0     0   2   9 11                 20
1128910 1128910 MA Bristol   school 2510860 273   Somerset 251086001723 2730005 Chace Street   Regular School No Elementary PK 05 2017   grade_2 45 0 1 0   0     0   1   21 26                       47 45 0 1 0   0     0   1   21 26                 47
1128917 1128917 MA Bristol   school 2510860 273   Somerset 251086002536 2730008 North Elementary   Regular School No Elementary KG 05 2017   grade_2 63 0 2 0   2     0   1   33 35                       68 63 0 2 0   2     0   1   33 35                 68
1128938 1128938 MA Middlesex   school 2510890 274   Somerville 251089001732 2740015 Benjamin G Brown   Regular School No Elementary KG 05 2017   grade_2 25 0 3 0   4     0   7   17 22                       39 25 0 3 0   4     0   7   17 22                 39
1129025 1129025 MA Hampshire   school 2510950 275   Southampton 251095001758 2750005 William E Norris   Regular School No Elementary PK 06 2017   grade_2 59 0 2 0   0     0   2   34 29                       63 59 0 2 0   0     0   2   34 29                 63
1129454 1129454 MA Middlesex   school 2511220 284   Stoneham 251122001855 2840025 Robin Hood   Regular School No Elementary PK 04 2017   grade_2 52 0 5 0   4     0   1   28 34                       62 52 0 5 0   4     0   1   28 34                 62
1129460 1129460 MA Middlesex   school 2511220 284   Stoneham 251122001856 2840030 South   Regular School No Elementary KG 04 2017   grade_2 49 0 8 2   2     0   2   36 27                       63 49 0 8 2   2     0   2   36 27                 63
1129524 1129524 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2017   grade_2 97 0 3 2   2     0   3   64 43                       107 97 0 3 2   2     0   3   64 43                 107
1129554 1129554 MA Middlesex   school 2511340 288   Sudbury 251134001877 2880030 Peter Noyes   Regular School No Elementary PK 05 2017   grade_2 64 0 2 0   10     0   10   45 41                       86 64 0 2 0   10     0   10   45 41                 86
1129592 1129592 MA Essex   school 2511430 291   Swampscott 251143001883 2910005 Clarke   Regular School No Elementary KG 04 2017   grade_2 30 0 6 0   4     0   1   16 25                       41 30 0 6 0   4     0   1   16 25                 41
1129604 1129604 MA Essex   school 2511430 291   Swampscott 251143001886 2910020 Stanley   Regular School No Elementary KG 04 2017   grade_2 46 0 4 0   1     0   2   27 26                       53 46 0 4 0   1     0   2   27 26                 53
1129630 1129630 MA Bristol   school 2511460 292   Swansea 251146000129 2920017 Mark G Hoyle Elementary   Regular School No Elementary PK 02 2017   grade_2 64 0 2 1   2     0   6   36 39                       75 64 0 2 1   2     0   6   36 39                 75
1129741 1129741 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_2 23 0 5 0   0     0   3   17 14                       31 23 0 5 0   0     0   3   17 14                 31
1129756 1129756 MA Essex   school 2511670 298   Topsfield 251167001929 2980010 Steward Elementary   Regular School No Elementary PK 03 2017   grade_2 81 0 1 1   2     0   0   43 42                       85 81 0 1 1   2     0   0   43 42                 85
1129762 1129762 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_2 9 0 0 0   0     0   2   9 2                       11 9 0 0 0   0     0   2   9 2                 11
1129811 1129811 MA Middlesex   school 2511910 305   Wakefield 251191001941 3050005 Dolbeare   Regular School No Elementary KG 04 2017   grade_2 76 0 5 0   2     0   2   46 39                       85 76 0 5 0   2     0   2   46 39                 85
1129828 1129828 MA Middlesex   school 2511910 305   Wakefield 251191001948 3050040 Walton   Regular School No Elementary 01 04 2017   grade_2 41 0 2 0   2     0   3   25 23                       48 41 0 2 0   2     0   3   25 23                 48
1130097 1130097 MA Norfolk   school 2512270 317   Wellesley 251227002022 3170025 Hunnewell   Regular School No Elementary KG 05 2017   grade_2 35 0 1 0   1     0   7   24 20                       44 35 0 1 0   1     0   7   24 20                 44
1130135 1130135 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2017   grade_2 13 0 2 0   0     0   0   8 7                       15 13 0 2 0   0     0   0   8 7                 15
1130153 1130153 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Elsie A Hastings Elementary   Regular School No Elementary PK 03 2017   grade_2 45 0 10 0   38     0   2   52 43                       95 45 0 10 0   38     0   2   52 43                 95
1130171 1130171 MA Worcester   school 2512390 322   West Boylston 251239002034 3220005 Major Edwards Elementary   Regular School No Elementary PK 05 2017   grade_2 45 0 8 0   1     0   1   26 29                       55 45 0 8 0   1     0   1   26 29                 55
1130248 1130248 MA Hampden   school 2512630 325   Westfield 251263002066 3250055 Russell Elementary School   Regular School No Elementary KG 05 2017   grade_2 31 0 2 0   0     0   0   17 16                       33 31 0 2 0   0     0   0   17 16                 33
1130313 1130313 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2017   grade_2 18 0 0 0   0     0   0   8 10                       18 18 0 0 0   0     0   0   8 10                 18
1130346 1130346 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2017   grade_2 108 0 3 1   1     0   7   58 62                       120 108 0 3 1   1     0   7   58 62                 120
1130409 1130409 MA Norfolk   school 2512810 335   Westwood 251281000794 3350010 Deerfield School   Regular School No Elementary KG 05 2017   grade_2 31 0 1 0   6     0   4   23 19                       42 31 0 1 0   6     0   4   23 19                 42
1130423 1130423 MA Norfolk   school 2512810 335   Westwood 251281002099 3350015 Paul Hanlon   Regular School No Elementary KG 05 2017   grade_2 29 0 2 0   5     0   4   22 18                       40 29 0 2 0   5     0   4   22 18                 40
1130430 1130430 MA Norfolk   school 2512810 335   Westwood 251281002098 3350017 Martha Jones   Regular School No Elementary KG 05 2017   grade_2 36 0 3 0   4     0   1   22 22                       44 36 0 3 0   4     0   1   22 22                 44
1130437 1130437 MA Norfolk   school 2512810 335   Westwood 251281002101 3350025 William E Sheehan   Regular School No Elementary KG 05 2017   grade_2 61 0 4 0   4     0   2   32 39                       71 61 0 4 0   4     0   2   32 39                 71
1130480 1130480 MA Norfolk   school 2512840 336   Weymouth 251284002114 3360065 Lawrence W Pingree   Regular School No Elementary KG 04 2017   grade_2 41 0 4 0   3     0   1   23 26                       49 41 0 4 0   3     0   1   23 26                 49
1130519 1130519 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2017   grade_2 15 0 0 0   0     0   1   10 6                       16 15 0 0 0   0     0   1   10 6                 16
1130528 1130528 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2017   grade_2 15 0 1 0   0     0   0   6 10                       16 15 0 1 0   0     0   0   6 10                 16
1130550 1130550 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Woburn Street   Regular School No Elementary 01 03 2017   grade_2 88 0 8 0   5     0   5   58 48                       106 88 0 8 0   5     0   5   58 48                 106
1130576 1130576 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No Elementary KG 02 2017   grade_2 76 0 5 0   3     0   1   56 29                       85 76 0 5 0   3     0   1   56 29                 85
1130598 1130598 MA Middlesex   school 2513110 344   Winchester 251311002165 3440005 Lincoln Elementary   Regular School No Elementary KG 05 2017   grade_2 64 0 1 0   7     0   3   40 34                       75 64 0 1 0   7     0   3   40 34                 75
1130613 1130613 MA Middlesex   school 2513110 344   Winchester 251311002172 3440025 Vinson-Owen Elementary   Regular School No Elementary KG 05 2017   grade_2 43 0 3 0   17     0   4   32 35                       67 43 0 3 0   17     0   4   32 35                 67
1130620 1130620 MA Middlesex   school 2513110 344   Winchester 251311002168 3440040 Muraco Elementary   Regular School No Elementary KG 05 2017   grade_2 47 0 1 0   14     0   3   35 30                       65 47 0 1 0   14     0   3   35 30                 65
1130627 1130627 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No Elementary KG 05 2017   grade_2 75 0 2 0   3     0   2   46 36                       82 75 0 2 0   3     0   2   46 36                 82
1130669 1130669 MA Middlesex   school 2513200 347   Woburn 251320002183 3470020 Daniel P Hurld   Regular School No Elementary KG 05 2017   grade_2 32 0 0 0   2     0   1   15 20                       35 32 0 0 0   2     0   1   15 20                 35
1130706 1130706 MA Middlesex   school 2513200 347   Woburn 251320002194 3470060 Wyman   Regular School No Elementary KG 05 2017   grade_2 28 0 4 0   3     0   1   14 22                       36 28 0 4 0   3     0   1   14 22                 36
1130744 1130744 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   grade_2 11 0 8 0   2     0   1   11 11                       22 11 0 8 0   2     0   1   11 11                 22
1130916 1130916 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No Elementary KG 06 2017   grade_2 24 0 2 0   3     0   2   15 16                       31 24 0 2 0   3     0   2   15 16                 31
1131073 1131073 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   grade_2 7 0 0 0   0     0   0   4 3                       7 7 0 0 0   0     0   0   4 3                 7
1131081 1131081 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Delaney   Regular School No Elementary PK 03 2017   grade_2 115 0 4 1   4     0   5   62 67                       129 115 0 4 1   4     0   5   62 67                 129
1131233 1131233 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 Elementary PK 05 2017   grade_2 2 0 40 0   0     0   0   17 25                       42 2 0 40 0   0     0   0   17 25                 42
1131293 1131293 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2017   grade_2 0 0 47 0   0     0   0   28 19                       47 0 0 47 0   0     0   0   28 19                 47
1131356 1131356 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2017   grade_2 33 0 0 0   14     0   3   21 29                       50 33 0 0 0   14     0   3   21 29                 50
1131375 1131375 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2017   grade_2 17 0 1 0   0     0   3   11 10                       21 17 0 1 0   0     0   3   11 10                 21
1131451 1131451 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_2 10 0 1 0   0     0   5   8 8                       16 10 0 1 0   0     0   5   8 8                 16
1131538 1131538 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2017   grade_2 30 0 0 0   3     0   1   18 16                       34 30 0 0 0   3     0   1   18 16                 34
1131659 1131659 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2017   grade_2 24 0 3 0   8     0   10   20 25                       45 24 0 3 0   8     0   10   20 25                 45
1131688 1131688 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Blanchard Memorial School   Regular School No Elementary KG 06 2017   grade_2 35 0 1 0   16     0   1   33 20                       53 35 0 1 0   16     0   1   33 20                 53
1131696 1131696 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2017   grade_2 49 0 3 0   16     0   1   36 33                       69 49 0 3 0   16     0   1   36 33                 69
1131712 1131712 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 C.T. Douglas Elementary School   Regular School No Elementary KG 06 2017   grade_2 48 0 0 0   16     0   5   38 31                       69 48 0 0 0   16     0   5   38 31                 69
1131784 1131784 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002368 6100025 Briggs Elementary   Regular School No Elementary PK 05 2017   grade_2 75 0 10 0   1     0   1   42 45                       87 75 0 10 0   1     0   1   42 45                 87
1131807 1131807 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2017   grade_2 15 0 0 0   0     0   1   4 12                       16 15 0 0 0   0     0   1   4 12                 16
1131851 1131851 MA Berkshire   school 2502530 618   Berkshire Hills 250253001999 6180035 Muddy Brook Regional Elementary School   Regular School No Elementary PK 04 2017   grade_2 49 0 8 0   1     0   4   36 26                       62 49 0 8 0   1     0   4   36 26                 62
1131880 1131880 MA Worcester   school 2502715 622   Blackstone-Millville 250271500185 6220010 Millville Elementary   Regular School No Elementary PK 05 2017   grade_2 33 0 2 0   1     0   0   19 17                       36 33 0 2 0   1     0   0   19 17                 36
1131937 1131937 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_2 17 0 1 1   0     0   0   11 8                       19 17 0 1 1   0     0   0   11 8                 19
1131945 1131945 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2017   grade_2 18 0 0 0   0     0   1   12 7                       19 18 0 0 0   0     0   1   12 7                 19
1131953 1131953 MA Berkshire   school 2503390 635   Central Berkshire 250339000462 6350025 Craneville   Regular School No Elementary PK 05 2017   grade_2 50 0 1 0   3     0   3   39 18                       57 50 0 1 0   3     0   3   39 18                 57
1131961 1131961 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No Elementary PK 05 2017   grade_2 15 0 0 0   0     0   0   9 6                       15 15 0 0 0   0     0   0   9 6                 15
1132011 1132011 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002427 6500005 Dighton Elementary   Regular School No Elementary KG 04 2017   grade_2 76 0 1 0   1     0   1   39 40                       79 76 0 1 0   1     0   1   39 40                 79
1132089 1132089 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   grade_2 13 0 0 0   0     0   0   8 5                       13 13 0 0 0   0     0   0   8 5                 13
1132154 1132154 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000806 6730005 Swallow/Union School   Regular School No Elementary KG 04 2017   grade_2 61 0 0 0   5     0   0   37 29                       66 61 0 0 0   5     0   0   37 29                 66
1132186 1132186 MA Franklin   school 2505270 674   Gill-Montague 250527002385 6740050 Sheffield Elementary School   Regular School No Elementary 02 05 2017   grade_2 40 0 9 0   0     0   5   32 22                       54 40 0 9 0   0     0   5   32 22                 54
1132209 1132209 MA Essex   school 2505670 675   Hamilton-Wenham 250567000818 6750010 Cutler School   Regular School No Elementary KG 05 2017   grade_2 37 0 0 0   0     3   1   19 22                       41 37 0 0 0   0     3   1   19 22                 41
1132234 1132234 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 04 2017   grade_2 46 0 3 0   0     0   3   23 29                       52 46 0 3 0   0     0   3   23 29                 52
1132272 1132272 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2017   grade_2 15 0 1 0   0     0   1   10 7                       17 15 0 1 0   0     0   1   10 7                 17
1132294 1132294 MA Essex   school 2500067 698   Manchester Essex Regional 250006701110 6980010 Manchester Memorial Elementary   Regular School No Elementary PK 05 2017   grade_2 50 0 1 0   0     0   0   32 19                       51 50 0 1 0   0     0   0   32 19                 51
1132301 1132301 MA Essex   school 2500067 698   Manchester Essex Regional 250006700627 6980020 Essex Elementary   Regular School No Elementary KG 05 2017   grade_2 35 0 1 0   0     0   1   19 18                       37 35 0 1 0   0     0   1   19 18                 37
1132343 1132343 MA Worcester   school 2507680 710   Mendon-Upton 250768001200 7100179 Henry P Clough   Regular School No Elementary PK 04 2017   grade_2 67 0 4 0   0     0   2   35 38                       73 67 0 4 0   0     0   2   35 38                 73
1132386 1132386 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No Elementary PK 06 2017   grade_2 35 0 1 0   0     0   2   22 16                       38 35 0 1 0   0     0   2   22 16                 38
1132395 1132395 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2017   grade_2 19 0 0 0   0     0   0   10 9                       19 19 0 0 0   0     0   0   10 9                 19
1132410 1132410 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2017   grade_2 16 0 1 0   0     0   1   9 9                       18 16 0 1 0   0     0   1   9 9                 18
1132426 1132426 MA Worcester   school 2508280 720   Narragansett 250828001287 7200003 Phillipston Memorial   Regular School No Elementary PK 04 2017   grade_2 14 0 2 0   0     0   1   11 6                       17 14 0 2 0   0     0   1   11 6                 17

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