enrollments

Data source: Big Local News · About: Big Local

986 rows where grade = "grade_1", state = "MA" and year = 2017 sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 986 ✖

grade ✖

  • grade_1 · 986 ✖
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 ▼
1123444 1123444 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_1 * * * *   *     *   *   2 3                       *                         2 3                  
1125187 1125187 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_1 * * * *   *     *   *   * *                       *                                              
1125261 1125261 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_1 * * * *   *     *   *   * *                       *                                              
1125316 1125316 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2017   grade_1 * * * *   *     *   *   3 1                       *                         3 1                  
1126446 1126446 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No Elementary KG 06 2017   grade_1 * * * *   *     *   *   4 *                       *                         4                    
1128614 1128614 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2017   grade_1 * * * *   *     *   *   1 2                       *                         1 2                  
1128749 1128749 MA Berkshire   school 2510530 263   Savoy 251053001688 2630010 Emma L Miller Elementary School   Regular School No Elementary PK 05 2017   grade_1 * * * *   *     *   *   2 1                       *                         2 1                  
1132818 1132818 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2017   grade_1 * * * *   *     *   *   2 2                       *                         2 2                  
1128900 1128900 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2017   grade_1 6 0 0 0   0     0   0   5 1                       6 6 0 0 0   0     0   0   5 1                 6
1132403 1132403 MA Franklin   school 2507990 717   Mohawk Trail 250799000934 7170015 Heath Elementary   Regular School No Elementary PK 06 2017   grade_1 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
1132592 1132592 MA Franklin   school 2509600 750   Pioneer Valley 250960002613 7500007 Pearl E Rhodes Elementary   Regular School No Elementary PK 06 2017   grade_1 6 0 0 0   0     0   0   4 2                       6 6 0 0 0   0     0   0   4 2                 6
1132607 1132607 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary KG 06 2017   grade_1 6 0 0 0   0     0   0   3 3                       6 6 0 0 0   0     0   0   3 3                 6
1124921 1124921 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_1 7 0 0 0   0     0   0   3 4                       7 7 0 0 0   0     0   0   3 4                 7
1132702 1132702 MA Berkshire   school 2511040 765   Southern Berkshire 251104001778 7650030 South Egremont   Regular School No Elementary KG 01 2017   grade_1 6 0 1 0   0     0   0   5 *                       7 6 0 1 0   0     0   0   5                   7
1125878 1125878 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_1 1 0 7 0   0     0   0   5 3                       8 1 0 7 0   0     0   0   5 3                 8
1131072 1131072 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   grade_1 10 0 0 0   0     0   0   3 7                       10 10 0 0 0   0     0   0   3 7                 10
1132696 1132696 MA Berkshire   school 2511040 765   Southern Berkshire 251104001775 7650018 New Marlborough Central   Regular School No Elementary PK 04 2017   grade_1 9 0 0 0   0     0   1   4 6                       10 9 0 0 0   0     0   1   4 6                 10
1130518 1130518 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2017   grade_1 11 0 1 0   0     0   0   7 5                       12 11 0 1 0   0     0   0   7 5                 12
1132088 1132088 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   grade_1 12 0 0 0   0     0   0   7 5                       12 12 0 0 0   0     0   0   7 5                 12
1132409 1132409 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2017   grade_1 11 0 0 1   0     0   0   4 8                       12 11 0 0 1   0     0   0   4 8                 12
1122670 1122670 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   grade_1 5 0 6 0   0     0   2   7 6                       13 5 0 6 0   0     0   2   7 6                 13
1122562 1122562 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2017   grade_1 9 1 2 0   0     0   2   7 7                       14 9 1 2 0   0     0   2   7 7                 14
1128273 1128273 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   grade_1 6 2 3 0   0     0   3   8 6                       14 6 2 3 0   0     0   3   8 6                 14
1129761 1129761 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_1 8 1 2 0   0     0   3   7 7                       14 8 1 2 0   0     0   3   7 7                 14
1131936 1131936 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_1 14 0 0 0   0     0   0   8 6                       14 14 0 0 0   0     0   0   8 6                 14
1132726 1132726 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_1 13 0 0 0   0     0   1   8 6                       14 13 0 0 0   0     0   1   8 6                 14
1124281 1124281 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   grade_1 14 0 0 0   0     0   1   7 8                       15 14 0 0 0   0     0   1   7 8                 15
1126005 1126005 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2017   grade_1 12 0 1 0   1     0   1   7 8                       15 12 0 1 0   1     0   1   7 8                 15
1131450 1131450 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_1 13 0 1 0   0     0   1   6 9                       15 13 0 1 0   0     0   1   6 9                 15
1131944 1131944 MA Berkshire   school 2503390 635   Central Berkshire 250339000459 6350005 Becket Washington School   Regular School No Elementary PK 05 2017   grade_1 15 0 0 0   0     0   0   8 7                       15 15 0 0 0   0     0   0   8 7                 15
1132271 1132271 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2017   grade_1 14 0 1 0   0     0   0   5 10                       15 14 0 1 0   0     0   0   5 10                 15
1128092 1128092 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2017   grade_1 15 0 0 0   0     0   1   11 5                       16 15 0 0 0   0     0   1   11 5                 16
1132425 1132425 MA Worcester   school 2508280 720   Narragansett 250828001287 7200003 Phillipston Memorial   Regular School No Elementary PK 04 2017   grade_1 12 0 1 0   0     0   3   8 8                       16 12 0 1 0   0     0   3   8 8                 16
1130312 1130312 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2017   grade_1 14 0 2 0   0     0   1   10 7                       17 14 0 2 0   0     0   1   10 7                 17
1131960 1131960 MA Berkshire   school 2503390 635   Central Berkshire 250339000465 6350035 Kittredge   Regular School No Elementary PK 05 2017   grade_1 15 1 0 0   0     0   1   10 7                       17 15 1 0 0   0     0   1   10 7                 17
1122977 1122977 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Nathan Hale   Regular School No Elementary PK 05 2017   grade_1 0 12 4 0   1     0   1   9 9                       18 0 12 4 0   1     0   1   9 9                 18
1124208 1124208 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_1 17 0 0 0   0     0   1   4 14                       18 17 0 0 0   0     0   1   4 14                 18
1130134 1130134 MA Barnstable   school 2512300 318   Wellfleet 251230002031 3180005 Wellfleet Elementary   Regular School No Elementary PK 05 2017   grade_1 13 1 1 0   0     0   3   7 11                       18 13 1 1 0   0     0   3   7 11                 18
1132489 1132489 MA Franklin   school 2508530 728   New Salem-Wendell 250853001346 7280015 Swift River   Regular School No Elementary PK 06 2017   grade_1 16 0 1 0   0     0   1   9 9                       18 16 0 1 0   0     0   1   9 9                 18
1124609 1124609 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2017   grade_1 17 0 1 0   0     0   1   11 8                       19 17 0 1 0   0     0   1   11 8                 19
1128549 1128549 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_1 15 2 2 0   0     0   0   10 9                       19 15 2 2 0   0     0   0   10 9                 19
1130743 1130743 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2017   grade_1 5 4 6 0   1     0   3   11 8                       19 5 4 6 0   1     0   3   11 8                 19
1132127 1132127 MA Hampden   school 2505160 672   Gateway 250516000757 6720059 Chester Elementary   Regular School No Elementary PK 05 2017   grade_1 19 0 0 0   0     0   0   14 5                       19 19 0 0 0   0     0   0   14 5                 19
1132175 1132175 MA Franklin   school 2505270 674   Gill-Montague 250527002382 6740005 Gill Elementary   Regular School No Elementary KG 06 2017   grade_1 17 0 0 0   0     0   2   10 9                       19 17 0 0 0   0     0   2   10 9                 19
1132394 1132394 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2017   grade_1 18 1 0 0   0     0   0   8 11                       19 18 1 0 0   0     0   0   8 11                 19
1122591 1122591 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_1 8 3 6 0   0     0   3   6 14                       20 8 3 6 0   0     0   3   6 14                 20
1125748 1125748 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   grade_1 19 1 0 0   0     0   0   6 14                       20 19 1 0 0   0     0   0   6 14                 20
1131374 1131374 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_1 18 0 1 0   0     0   1   10 10                       20 18 0 1 0   0     0   1   10 10                 20
1132583 1132583 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2017   grade_1 19 0 0 0   0     0   1   10 10                       20 19 0 0 0   0     0   1   10 10                 20
1125364 1125364 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   grade_1 18 0 2 0   1     0   0   10 11                       21 18 0 2 0   1     0   0   10 11                 21
1128051 1128051 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2017   grade_1 15 0 5 0   0     0   1   11 10                       21 15 0 5 0   0     0   1   11 10                 21
1130527 1130527 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2017   grade_1 19 2 0 0   0     0   0   13 8                       21 19 2 0 0   0     0   0   13 8                 21
1122839 1122839 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2017   grade_1 7 9 4 0   1     0   1   12 10                       22 7 9 4 0   1     0   1   12 10                 22
1124155 1124155 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2017   grade_1 17 0 4 0   0     0   1   11 11                       22 17 0 4 0   0     0   1   11 11                 22
1126439 1126439 MA Essex   school 2507110 163   Lynn 250711001081 1630075 Lynn Woods   Regular School No Elementary KG 05 2017   grade_1 15 1 3 1   0     0   2   13 9                       22 15 1 3 1   0     0   2   13 9                 22
1129844 1129844 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2017   grade_1 21 0 0 1   0     0   0   8 14                       22 21 0 0 1   0     0   0   8 14                 22
1130117 1130117 MA Norfolk   school 2512270 317   Wellesley 251227002021 3170050 Ernest F Upham   Regular School No Elementary KG 05 2017   grade_1 18 2 0 0   2     0   0   17 5                       22 18 2 0 0   2     0   0   17 5                 22
1130247 1130247 MA Hampden   school 2512630 325   Westfield 251263002066 3250055 Russell Elementary School   Regular School No Elementary KG 05 2017   grade_1 20 1 1 0   0     0   0   13 9                       22 20 1 1 0   0     0   0   13 9                 22
1131266 1131266 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_1 0 17 5 0   0     0   0   11 11                       22 0 17 5 0   0     0   0   11 11                 22
1131806 1131806 MA Worcester   school 2502160 615   Athol-Royalston 250216000931 6150050 Royalston Community School   Regular School No Elementary KG 06 2017   grade_1 22 0 0 0   0     0   0   12 10                       22 22 0 0 0   0     0   0   12 10                 22
1122889 1122889 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Joseph P Manning   Regular School No Elementary PK 05 2017   grade_1 11 3 6 0   1     0   2   12 11                       23 11 3 6 0   1     0   2   12 11                 23
1123226 1123226 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2017   grade_1 8 2 10 0   0     1   2   15 8                       23 8 2 10 0   0     1   2   15 8                 23
1125514 1125514 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2017   grade_1 20 1 0 0   1     0   1   17 6                       23 20 1 0 0   1     0   1   17 6                 23
1127113 1127113 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2017   grade_1 23 0 0 0   0     0   0   11 12                       23 23 0 0 0   0     0   0   11 12                 23
1132599 1132599 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2017   grade_1 24 0 0 0   0     0   0   12 12                       24 24 0 0 0   0     0   0   12 12                 24
1132639 1132639 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary PK 01 2017   grade_1 21 0 2 0   0     0   1   10 14                       24 21 0 2 0   0     0   1   10 14                 24
1122958 1122958 MA Suffolk   school 2502790 35   Boston 250279000294 350237 Mozart   Regular School No Elementary PK 05 2017   grade_1 13 7 4 0   1     0   1   16 10                       26 13 7 4 0   1     0   1   16 10                 26
1130803 1130803 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary KG 06 2017   grade_1 3 5 15 0   2     0   1   11 15                       26 3 5 15 0   2     0   1   11 15                 26
1127345 1127345 MA Bristol   school 2508430 201   New Bedford 250843001342 2010125 Thomas R Rodman   Regular School No Elementary KG 05 2017   grade_1 15 0 11 0   0     0   1   14 13                       27 15 0 11 0   0     0   1   14 13                 27
1127581 1127581 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 07 2017   grade_1 22 2 2 0   0     0   1   12 15                       27 22 2 2 0   0     0   1   12 15                 27
1132746 1132746 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_1 24 0 2 0   0     0   1   15 12                       27 24 0 2 0   0     0   1   15 12                 27
1133197 1133197 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_1 15 3 3 1   1     0   4   17 10                       27 15 3 3 1   1     0   4   17 10                 27
1128115 1128115 MA Berkshire   school 2509630 236   Pittsfield 250963001522 2360045 Robert T. Capeless Elementary School   Regular School No Elementary PK 05 2017   grade_1 22 0 3 0   0     0   3   13 15                       28 22 0 3 0   0     0   3   13 15                 28
1131744 1131744 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000018 6030004 Cheshire Elementary   Regular School No Elementary PK 05 2017   grade_1 27 0 0 0   1     0   0   14 14                       28 27 0 0 0   1     0   0   14 14                 28
1132300 1132300 MA Essex   school 2500067 698   Manchester Essex Regional 250006700627 6980020 Essex Elementary   Regular School No Elementary KG 05 2017   grade_1 27 0 0 0   0     0   1   17 11                       28 27 0 0 0   0     0   1   17 11                 28
1132622 1132622 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2017   grade_1 24 0 3 0   0     0   1   16 12                       28 24 0 3 0   0     0   1   16 12                 28
1122985 1122985 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_1 17 6 1 0   3     0   2   15 14                       29 17 6 1 0   3     0   2   15 14                 29
1123570 1123570 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2017   grade_1 27 1 0 0   1     0   0   17 12                       29 27 1 0 0   1     0   0   17 12                 29
1124511 1124511 MA Barnstable   school 2504530 85   Eastham 250453000607 850005 Eastham Elementary   Regular School No Elementary PK 05 2017   grade_1 24 1 3 0   0     0   1   13 16                       29 24 1 3 0   0     0   1   13 16                 29
1128197 1128197 MA Plymouth   school 2509720 239   Plymouth 250972001541 2390010 Hedge   Regular School No Elementary KG 05 2017   grade_1 23 0 0 0   3     0   3   15 14                       29 23 0 0 0   3     0   3   15 14                 29
1126432 1126432 MA Essex   school 2507110 163   Lynn 250711001079 1630070 Lincoln-Thomson   Regular School No Elementary KG 05 2017   grade_1 9 0 18 0   2     0   1   13 17                       30 9 0 18 0   2     0   1   13 17                 30
1127619 1127619 MA Hampshire   school 2508850 210   Northampton 250885001433 2100029 R. K. Finn Ryan Road   Regular School No Elementary KG 05 2017   grade_1 21 1 4 0   2     0   2   17 13                       30 21 1 4 0   2     0   2   17 13                 30
1130408 1130408 MA Norfolk   school 2512810 335   Westwood 251281000794 3350010 Deerfield School   Regular School No Elementary KG 05 2017   grade_1 22 0 2 0   3     0   3   19 11                       30 22 0 2 0   3     0   3   19 11                 30
1122573 1122573 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2017   grade_1 1 7 20 0   0     0   3   17 14                       31 1 7 20 0   0     0   3   17 14                 31
1122859 1122859 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No Elementary PK 05 2017   grade_1 10 9 7 0   3     0   2   19 12                       31 10 9 7 0   3     0   2   19 12                 31
1122559 1122559 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2017   grade_1 7 5 13 0   6     0   1   18 14                       32 7 5 13 0   6     0   1   18 14                 32
1123062 1123062 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2017   grade_1 8 13 6 0   3     0   2   16 16                       32 8 13 6 0   3     0   2   16 16                 32
1125075 1125075 MA Norfolk   school 2505010 101   Franklin 250501000736 1010035 Davis Thayer   Regular School No Elementary KG 05 2017   grade_1 32 0 0 0   0     0   0   17 15                       32 32 0 0 0   0     0   0   17 15                 32
1127935 1127935 MA Barnstable   school 2509210 224   Orleans 250921001477 2240005 Orleans Elementary   Regular School No Elementary KG 05 2017   grade_1 27 0 3 0   1     0   1   13 19                       32 27 0 3 0   1     0   1   13 19                 32
1131537 1131537 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2017   grade_1 32 0 0 0   0     0   0   14 18                       32 32 0 0 0   0     0   0   14 18                 32
1132385 1132385 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No Elementary PK 06 2017   grade_1 29 0 1 0   0     0   2   15 17                       32 29 0 1 0   0     0   2   15 17                 32
1133183 1133183 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_1 18 6 6 0   0     0   2   16 16                       32 18 6 6 0   0     0   2   16 16                 32
1122444 1122444 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin Memorial   Regular School No Elementary PK 05 2017   grade_1 28 0 2 1   0     0   2   18 15                       33 28 0 2 1   0     0   2   18 15                 33
1122662 1122662 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Curtis Guild   Regular School No Elementary PK 05 2017   grade_1 6 0 27 0   0     0   0   15 18                       33 6 0 27 0   0     0   0   15 18                 33
1122950 1122950 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Michael J Perkins   Regular School No Elementary KG 05 2017   grade_1 5 12 14 0   0     0   2   17 16                       33 5 12 14 0   0     0   2   17 16                 33
1123166 1123166 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2017   grade_1 9 5 15 0   3     0   1   22 11                       33 9 5 15 0   3     0   1   22 11                 33
1128630 1128630 MA Essex   school 2510380 258   Salem 251038001656 2580015 Carlton   Regular School No Elementary KG 05 2017   grade_1 18 1 13 0   0     0   1   9 24                       33 18 1 13 0   0     0   1   9 24                 33
1129740 1129740 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_1 17 1 11 0   0     0   4   19 14                       33 17 1 11 0   0     0   4   19 14                 33
1130384 1130384 MA Hampden   school 2512510 332   West Springfield 251251002048 3320030 Mittineague   Regular School No Elementary 01 05 2017   grade_1 27 1 4 0   1     0   0   19 14                       33 27 1 4 0   1     0   0   19 14                 33
1122532 1122532 MA Middlesex   school 2502670 31   Billerica 250267000178 310030 Eugene C Vining   Regular School No Elementary KG 05 2017   grade_1 28 2 2 0   1     0   1   17 17                       34 28 2 2 0   1     0   1   17 17                 34

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