enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 982 ✖

grade ✖

  • grade_2 · 982 ✖
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
1133198 1133198 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   grade_2 16 3 5 0   1     0   6   16 15                       31 16 3 5 0   1     0   6   16 15                 31
1133184 1133184 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   grade_2 28 4 8 0   0     0   0   18 22                       40 28 4 8 0   0     0   0   18 22                 40
1133173 1133173 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2017   grade_2 16 8 27 0   2     0   1   29 25                       54 16 8 27 0   2     0   1   29 25                 54
1133169 1133169 MA Hampden   school 2500557 3510   Springfield Preparatory Charter 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 02 2017   grade_2 4 12 35 0   0     0   4   29 26                       55 4 12 35 0   0     0   4   29 26                 55
1133139 1133139 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   grade_2 1 42 24 0   2     0   1   36 34                       70 1 42 24 0   2     0   1   36 34                 70
1133125 1133125 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 06 2017   grade_2 19 16 36 1   19     0   3   44 50                       94 19 16 36 1   19     0   3   44 50                 94
1132950 1132950 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000200 7800030 John H Duval   Regular School No Elementary KG 05 2017   grade_2 69 3 3 0   0     1   3   42 37                       79 69 3 3 0   0     1   3   42 37                 79
1132946 1132946 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000199 7800025 Maquan Elementary   Regular School No Elementary PK 02 2017   grade_2 98 0 5 0   2     0   2   58 49                       107 98 0 5 0   2     0   2   58 49                 107
1132938 1132938 MA Plymouth   school 2512930 780   Whitman-Hanson 251293000190 7800010 Louise A Conley   Regular School No Elementary KG 05 2017   grade_2 74 2 7 1   1     0   1   48 38                       86 74 2 7 1   1     0   1   48 38                 86
1132922 1132922 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_2 41 0 2 0   0     0   3   24 22                       46 41 0 2 0   0     0   3   24 22                 46
1132913 1132913 MA Worcester   school 2512100 778   Quaboag Regional 251210001993 7780005 Warren Elementary   Regular School No Elementary PK 06 2017   grade_2 60 0 5 0   0     0   2   35 32                       67 60 0 5 0   0     0   2   35 32                 67
1132880 1132880 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No Elementary KG 08 2017   grade_2 47 0 1 0   0     0   0   22 26                       48 47 0 1 0   0     0   0   22 26                 48
1132870 1132870 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No Elementary KG 08 2017   grade_2 45 2 5 0   2     0   0   31 23                       54 45 2 5 0   2     0   0   31 23                 54
1132863 1132863 MA Worcester   school 2511880 775   Wachusett 251188001488 7750032 Leroy E.Mayo   Regular School No Elementary KG 05 2017   grade_2 73 3 6 0   1     0   0   51 32                       83 73 3 6 0   1     0   0   51 32                 83
1132857 1132857 MA Worcester   school 2511880 775   Wachusett 251188001476 7750027 Houghton Elementary   Regular School No Elementary KG 04 2017   grade_2 63 1 2 0   1     0   3   43 27                       70 63 1 2 0   1     0   3   43 27                 70
1132850 1132850 MA Worcester   school 2511880 775   Wachusett 251188000884 7750020 Dawson   Regular School No Elementary KG 05 2017   grade_2 70 3 3 0   4     0   2   45 37                       82 70 3 3 0   4     0   2   45 37                 82
1132843 1132843 MA Worcester   school 2511880 775   Wachusett 251188001607 7750018 Davis Hill Elementary   Regular School No Elementary KG 05 2017   grade_2 60 3 4 0   2     0   1   38 32                       70 60 3 4 0   2     0   1   38 32                 70
1132839 1132839 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No Elementary KG 02 2017   grade_2 85 3 2 2   1     0   3   43 53                       96 85 3 2 2   1     0   3   43 53                 96
1132827 1132827 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_2 30 1 4 1   0     0   2   16 22                       38 30 1 4 1   0     0   2   16 22                 38
1132819 1132819 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2017   grade_2 4 0 1 0   0     0   2   5 2                       7 4 0 1 0   0     0   2   5 2                 7
1132803 1132803 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No Elementary PK 06 2017   grade_2 61 0 1 1   0     0   5   35 33                       68 61 0 1 1   0     0   5   35 33                 68
1132794 1132794 MA Essex   school 2511740 773   Triton 251174001348 7730020 Newbury Elementary   Regular School No Elementary PK 06 2017   grade_2 52 1 1 0   1     0   0   30 25                       55 52 1 1 0   1     0   0   30 25                 55
1132785 1132785 MA Essex   school 2511740 773   Triton 251174001669 7730015 Salisbury Elementary   Regular School No Elementary PK 06 2017   grade_2 58 1 0 0   1     1   1   38 24                       62 58 1 0 0   1     1   1   38 24                 62
1132755 1132755 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   grade_2 89 1 8 0   1     0   2   52 49                       101 89 1 8 0   1     0   2   52 49                 101
1132747 1132747 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_2 16 0 1 1   0     0   2   10 10                       20 16 0 1 1   0     0   2   10 10                 20
1132723 1132723 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2017   grade_2 85 1 6 0   1     0   4   47 50                       97 85 1 6 0   1     0   4   47 50                 97
1132707 1132707 MA Berkshire   school 2511040 765   Southern Berkshire 251104000428 7650035 Undermountain   Regular School No Elementary PK 06 2017   grade_2 28 3 3 0   0     0   2   24 12                       36 28 3 3 0   0     0   2   24 12                 36
1132697 1132697 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2017   grade_2 16 0 0 1   0     0   0   6 11                       17 16 0 0 1   0     0   0   6 11                 17
1132649 1132649 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary KG 06 2017   grade_2 52 0 3 0   1     0   2   30 28                       58 52 0 3 0   1     0   2   30 28                 58
1132641 1132641 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   grade_2 28 0 0 0   0     0   0   8 20                       28 28 0 0 0   0     0   0   8 20                 28
1132631 1132631 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2017   grade_2 44 0 1 0   0     0   0   18 27                       45 44 0 1 0   0     0   0   18 27                 45
1132623 1132623 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   grade_2 21 0 2 1   0     0   0   11 13                       24 21 0 2 1   0     0   0   11 13                 24
1132608 1132608 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary KG 06 2017   grade_2 10 0 0 0   0     0   0   5 5                       10 10 0 0 0   0     0   0   5 5                 10
1132600 1132600 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2017   grade_2 17 0 2 0   0     0   1   9 11                       20 17 0 2 0   0     0   1   9 11                 20
1132593 1132593 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No Elementary PK 06 2017   grade_2 6 0 0 0   0     0   0   2 4                       6 6 0 0 0   0     0   0   2 4                 6
1132584 1132584 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2017   grade_2 20 0 0 0   0     0   2   10 12                       22 20 0 0 0   0     0   2   10 12                 22
1132571 1132571 MA Essex   school 2509450 745   Pentucket 250945000414 7450020 Dr Frederick N Sweetsir   Regular School No Elementary PK 02 2017   grade_2 44 0 5 0   1     0   3   28 25                       53 44 0 5 0   1     0   3   28 25                 53
1132562 1132562 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Dr John C Page School   Regular School No Elementary PK 06 2017   grade_2 47 1 0 0   2     0   0   32 18                       50 47 1 0 0   2     0   0   32 18                 50
1132548 1132548 MA Essex   school 2509450 745   Pentucket 250945000403 7450005 Elmer S Bagnall   Regular School No Elementary PK 06 2017   grade_2 63 0 2 0   1     0   0   37 29                       66 63 0 2 0   1     0   0   37 29                 66
1132522 1132522 MA Middlesex   school 2508790 735   North Middlesex 250879002281 7350035 Varnum Brook   Regular School No Elementary KG 04 2017   grade_2 96 0 4 0   1     0   6   59 48                       107 96 0 4 0   1     0   6   59 48                 107
1132511 1132511 MA Middlesex   school 2508790 735   North Middlesex 250879001412 7350010 Ashby Elementary   Regular School No Elementary KG 04 2017   grade_2 44 1 1 0   0     0   0   22 24                       46 44 1 1 0   0     0   0   22 24                 46
1132505 1132505 MA Middlesex   school 2508790 735   North Middlesex 250879000621 7350005 Spaulding Memorial   Regular School No Elementary KG 04 2017   grade_2 74 1 4 1   1     0   2   43 40                       83 74 1 4 1   1     0   2   43 40                 83
1132490 1132490 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No Elementary PK 06 2017   grade_2 15 0 0 0   0     0   2   9 8                       17 15 0 0 0   0     0   2   9 8                 17
1132466 1132466 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2017   grade_2 60 0 0 0   3     0   3   34 32                       66 60 0 0 0   3     0   3   34 32                 66
1132458 1132458 MA Worcester   school 2508310 725   Nashoba 250831000362 7250020 Center School   Regular School No Elementary PK 05 2017   grade_2 93 2 3 0   5     0   3   51 55                       106 93 2 3 0   5     0   3   51 55                 106
1132450 1132450 MA Worcester   school 2508310 725   Nashoba 250831000948 7250010 Mary Rowlandson Elementary   Regular School No Elementary PK 05 2017   grade_2 74 0 5 1   1     0   0   39 42                       81 74 0 5 1   1     0   0   39 42                 81
1132430 1132430 MA Worcester   school 2508280 720   Narragansett 250828001283 7200005 Baldwinville Elementary   Regular School No Elementary 02 04 2017   grade_2 89 0 5 0   0     0   6   49 51                       100 89 0 5 0   0     0   6   49 51                 100
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
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
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
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
1132362 1132362 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2017   grade_2 85 2 7 1   0     0   8   49 54                       103 85 2 7 1   0     0   8   49 54                 103
1132355 1132355 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400469 7120001 Chatham Elementary School   Regular School No Elementary PK 04 2017   grade_2 51 4 1 0   0     0   1   26 31                       57 51 4 1 0   0     0   1   26 31                 57
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
1132331 1132331 MA Worcester   school 2507680 710   Mendon-Upton 250768001277 7100001 Memorial School   Regular School No Elementary PK 04 2017   grade_2 70 1 3 0   3     0   2   47 32                       79 70 1 3 0   3     0   2   47 32                 79
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
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
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
1132245 1132245 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001464 6800050 Stony Hill School   Regular School No Elementary 02 03 2017   grade_2 118 2 11 0   6     0   7   75 69                       144 118 2 11 0   6     0   7   75 69                 144
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
1132217 1132217 MA Essex   school 2505670 675   Hamilton-Wenham 250567000821 6750015 Winthrop School   Regular School No Elementary PK 05 2017   grade_2 49 2 1 1   1     0   1   26 29                       55 49 2 1 1   1     0   1   26 29                 55
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
1132202 1132202 MA Essex   school 2505670 675   Hamilton-Wenham 250567001459 6750007 Bessie Buker Elementary   Regular School No Elementary KG 05 2017   grade_2 38 1 3 0   2     0   1   26 19                       45 38 1 3 0   2     0   1   26 19                 45
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
1132176 1132176 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No Elementary KG 06 2017   grade_2 13 1 1 0   0     0   1   7 9                       16 13 1 1 0   0     0   1   7 9                 16
1132160 1132160 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No Elementary KG 04 2017   grade_2 86 1 2 0   11     0   3   48 55                       103 86 1 2 0   11     0   3   48 55                 103
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
1132136 1132136 MA Hampshire   school 2505160 672   Gateway 250516000761 6720143 Littleville Elementary School   Regular School No Elementary PK 05 2017   grade_2 51 1 0 0   0     0   2   30 24                       54 51 1 0 0   0     0   2   30 24                 54
1132128 1132128 MA Hampden   school 2505160 672   Gateway 250516000757 6720059 Chester Elementary   Regular School No Elementary PK 05 2017   grade_2 18 1 1 0   0     0   0   9 11                       20 18 1 1 0   0     0   0   9 11                 20
1132103 1132103 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Assawompset Elementary School   Regular School No Elementary KG 03 2017   grade_2 88 4 1 0   1     0   2   60 36                       96 88 4 1 0   1     0   2   60 36                 96
1132098 1132098 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No Elementary PK 03 2017   grade_2 87 1 0 0   0     0   1   44 45                       89 87 1 0 0   0     0   1   44 45                 89
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
1132058 1132058 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436002518 6580030 Heritage School   Regular School No Elementary 02 04 2017   grade_2 132 3 13 0   0     0   6   83 71                       154 132 3 13 0   0     0   6   83 71                 154
1132046 1132046 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000588 6580005 Dudley Elementary   Regular School No Elementary 02 04 2017   grade_2 110 3 13 0   0     0   3   81 48                       129 110 3 13 0   0     0   3   81 48                 129
1132017 1132017 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002428 6500010 Palmer River   Regular School No Elementary KG 04 2017   grade_2 89 2 3 0   2     0   6   48 54                       102 89 2 3 0   2     0   6   48 54                 102
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
1131993 1131993 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Station Avenue Elementary   Regular School No Elementary KG 03 2017   grade_2 83 6 2 3   1     0   11   54 52                       106 83 6 2 3   1     0   11   54 52                 106
1131988 1131988 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Marguerite E Small Elementary   Regular School No Elementary PK 03 2017   grade_2 31 2 10 4   0     0   6   30 23                       53 31 2 10 4   0     0   6   30 23                 53
1131982 1131982 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Ezra H Baker Innovation School   Regular School No Elementary PK 03 2017   grade_2 70 6 8 1   2     0   8   49 46                       95 70 6 8 1   2     0   8   49 46                 95
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
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
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
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
1131907 1131907 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001755 6250050 Laliberte Elementary School   Regular School No Elementary 02 04 2017   grade_2 141 8 2 0   4     0   4   71 88                       159 141 8 2 0   4     0   4   71 88                 159
1131901 1131901 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Mitchell Elementary School   Regular School No Elementary PK 03 2017   grade_2 178 16 8 0   2     0   9   114 99                       213 178 16 8 0   2     0   9   114 99                 213
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
1131875 1131875 MA Worcester   school 2502715 622   Blackstone-Millville 250271502372 6220008 John F Kennedy Elementary   Regular School No Elementary KG 02 2017   grade_2 69 2 6 0   1     0   8   47 39                       86 69 2 6 0   1     0   8   47 39                 86
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
1131834 1131834 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202736 6160002 Page Hilltop Elementary School   Regular School No Elementary PK 05 2017   grade_2 62 3 10 1   2     1   1   49 31                       80 62 3 10 1   2     1   1   49 31                 80
1131826 1131826 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202731 6160001 Lura A. White Elementary School   Regular School No Elementary PK 05 2017   grade_2 55 2 6 0   3     0   0   41 25                       66 55 2 6 0   3     0   0   41 25                 66
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
1131801 1131801 MA Worcester   school 2502160 615   Athol-Royalston 250216000080 6150020 Athol Community Elementary School   Regular School No Elementary PK 04 2017   grade_2 79 1 9 0   2     0   4   56 39                       95 79 1 9 0   2     0   4   56 39                 95
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
1131773 1131773 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No Elementary 02 05 2017   grade_2 68 2 5 0   0     0   3   43 35                       78 68 2 5 0   0     0   3   43 35                 78
1131752 1131752 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Plunkett Elementary   Regular School No Elementary KG 05 2017   grade_2 72 3 3 0   1     1   3   47 36                       83 72 3 3 0   1     1   3   47 36                 83
1131745 1131745 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No Elementary PK 05 2017   grade_2 26 6 0 0   0     0   1   13 20                       33 26 6 0 0   0     0   1   13 20                 33
1131728 1131728 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Luther Conant School   Regular School No Elementary KG 06 2017   grade_2 11 2 1 0   30     0   1   24 21                       45 11 2 1 0   30     0   1   24 21                 45
1131720 1131720 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2017   grade_2 26 2 1 2   36     0   1   32 36                       68 26 2 1 2   36     0   1   32 36                 68
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
1131704 1131704 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 McCarthy-Towne School   Regular School No Elementary KG 06 2017   grade_2 43 3 9 2   8     0   3   36 32                       68 43 3 9 2   8     0   3   36 32                 68

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