enrollments

Data source: Big Local News · About: Big Local

11,264 rows where state = "MA" and year = 2017 sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 11,264 ✖
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
1123702 1123702 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_12 194 622 125 3   23     1   25   444 549                       993 194 622 125 3   23     1   25   444 549                 993
1125863 1125863 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2017   grade_9 39 16 921 1   12     0   1   561 429                       990 39 16 921 1   12     0   1   561 429                 990
1121967 1121967 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   grade_1 88 0 4 0   0     0   7   55 44                       99 88 0 4 0   0     0   7   55 44                 99
1122101 1122101 MA Essex   school 2501950 9   Andover 250195000051 90025 West Elementary   Regular School No Elementary KG 05 2017   grade_1 75 1 7 0   16     0   0   49 50                       99 75 1 7 0   16     0   0   49 50                 99
1122438 1122438 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2017   grade_6 93 1 0 0   0     0   5   47 52                       99 93 1 0 0   0     0   5   47 52                 99
1122440 1122440 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2017   grade_8 93 1 1 0   1     0   3   44 55                       99 93 1 1 0   1     0   3   44 55                 99
1122934 1122934 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Mather   Regular School No Elementary PK 05 2017   grade_3 9 38 22 1   25     0   4   53 46                       99 9 38 22 1   25     0   4   53 46                 99
1122998 1122998 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2017   grade_3 3 39 51 1   1     1   3   53 46                       99 3 39 51 1   1     1   3   53 46                 99
1123217 1123217 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_3 2 60 35 0   0     0   2   46 53                       99 2 60 35 0   0     0   2   46 53                 99
1123244 1123244 MA Suffolk   school 2502790 35   Boston 250279000201 350390 Blackstone   Regular School No Elementary PK 05 2017   grade_4 1 21 76 0   0     0   1   44 55                       99 1 21 76 0   0     0   1   44 55                 99
1123266 1123266 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2017   grade_6 1 27 66 0   5     0   0   41 58                       99 1 27 66 0   5     0   0   41 58                 99
1123383 1123383 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No High 09 12 2017   grade_10 10 45 41 0   1     0   2   58 41                       99 10 45 41 0   1     0   2   58 41                 99
1123490 1123490 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2017   grade_4 95 0 0 0   4     0   0   51 48                       99 95 0 0 0   4     0   0   51 48                 99
1123622 1123622 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_8 23 57 15 0   0     1   3   49 50                       99 23 57 15 0   0     1   3   49 50                 99
1124055 1124055 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2017   grade_1 73 3 9 0   11     0   3   56 43                       99 73 3 9 0   11     0   3   56 43                 99
1124352 1124352 MA Bristol   school 2504020 72   Dartmouth 250402002028 720040 James M. Quinn School   Regular School No Elementary KG 05 2017   grade_3 90 0 1 0   2     0   6   39 60                       99 90 0 1 0   2     0   6   39 60                 99
1124412 1124412 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2017   grade_1 91 0 6 0   1     0   1   51 48                       99 91 0 6 0   1     0   1   51 48                 99
1124424 1124424 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No High 09 12 2017   grade_10 95 0 3 0   0     0   1   52 47                       99 95 0 3 0   0     0   1   52 47                 99
1124556 1124556 MA Hampden   school 2504500 87   East Longmeadow 250450000606 870015 Mountain View   Regular School No Elementary 03 05 2017   grade_4 86 1 6 0   4     0   2   50 49                       99 86 1 6 0   4     0   2   50 49                 99
1124575 1124575 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2017   grade_1 82 3 5 0   1     0   8   56 43                       99 82 3 5 0   1     0   8   56 43                 99
1124652 1124652 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2017   grade_7 29 20 40 1   8     0   1   56 43                       99 29 20 40 1   8     0   1   56 43                 99
1124871 1124871 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2017   grade_3 34 4 52 0   4     0   5   52 47                       99 34 4 52 0   4     0   5   52 47                 99
1124872 1124872 MA Worcester   school 2504890 97   Fitchburg 250489000696 970016 Crocker Elementary   Regular School No Elementary PK 04 2017   grade_4 30 6 53 0   2     0   8   47 52                       99 30 6 53 0   2     0   8   47 52                 99
1125289 1125289 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2017   grade_12 80 5 9 0   3     0   2   49 50                       99 80 5 9 0   3     0   2   49 50                 99
1125710 1125710 MA Plymouth   school 2506420 142   Hull 250642000930 1420505 Hull High   Regular School No High 09 12 2017   grade_12 87 2 6 0   1     1   2   61 38                       99 87 2 6 0   1     1   2   61 38                 99
1125769 1125769 MA Essex   school 2506660 149   Lawrence 250666002777 1490009 Community Day Arlington   Regular School No Elementary KG 04 2017   kindergarten 1 1 96 0   0     0   1   51 48                       99 1 1 96 0   0     0   1   51 48                 99
1126016 1126016 MA Middlesex   school 2506840 155   Lexington 250684000995 1550006 Bridge   Regular School No Elementary KG 05 2017   grade_2 47 7 3 0   42     0   0   54 45                       99 47 7 3 0   42     0   0   54 45                 99
1127056 1127056 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary PK 05 2017   grade_1 83 3 3 0   6     0   4   60 39                       99 83 3 3 0   6     0   4   60 39                 99
1127058 1127058 MA Norfolk   school 2507980 189   Milton 250798001259 1890005 Collicot   Regular School No Elementary PK 05 2017   grade_3 79 5 2 0   7     1   5   52 47                       99 79 5 2 0   7     1   5   52 47                 99
1127333 1127333 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2017   grade_4 69 4 22 0   0     0   4   62 37                       99 69 4 22 0   0     0   4   62 37                 99
1127476 1127476 MA Middlesex   school 2508610 207   Newton 250861001371 2070080 Mason-Rice   Regular School No Elementary KG 05 2017   grade_2 66 4 5 0   17     0   7   54 45                       99 66 4 5 0   17     0   7   54 45                 99
1128177 1128177 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No Elementary 04 06 2017   grade_4 83 2 7 1   5     0   1   53 46                       99 83 2 7 1   5     0   1   53 46                 99
1129098 1129098 MA Hampden   school 2511130 281   Springfield 251113001794 2810010 Edward P. Boland School   Regular School No Elementary PK 05 2017   grade_4 10 11 75 0   1     0   2   53 46                       99 10 11 75 0   1     0   2   53 46                 99
1129165 1129165 MA Hampden   school 2511130 281   Springfield 251113000341 2810055 Rebecca M Johnson   Regular School No Elementary PK 05 2017   grade_4 3 33 59 0   1     0   3   48 51                       99 3 33 59 0   1     0   3   48 51                 99
1129332 1129332 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No Other 06 12 2017   grade_8 22 25 51 0   0     1   0   59 40                       99 22 25 51 0   0     1   0   59 40                 99
1129361 1129361 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2017   grade_6 13 22 62 0   2     0   0   66 33                       99 13 22 62 0   2     0   0   66 33                 99
1129577 1129577 MA Worcester   school 2511400 290   Sutton 251140001879 2900005 Sutton Elementary   Regular School No Elementary 03 05 2017   grade_3 84 0 2 0   4     0   9   51 48                       99 84 0 2 0   4     0   9   51 48                 99
1129961 1129961 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Elementary 04 06 2017   grade_6 79 1 12 0   2     0   5   48 51                       99 79 1 12 0   2     0   5   48 51                 99
1130200 1130200 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2017   grade_12 95 3 0 0   1     0   0   45 54                       99 95 3 0 0   1     0   0   45 54                 99
1130356 1130356 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2017   grade_10 89 1 3 0   3     0   3   52 47                       99 89 1 3 0   3     0   3   52 47                 99
1130376 1130376 MA Hampden   school 2512510 332   West Springfield 251251002044 3320010 John R Fausey   Regular School No Elementary KG 05 2017   grade_5 77 4 9 0   5     0   4   55 44                       99 77 4 9 0   5     0   4   55 44                 99
1130851 1130851 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No Elementary PK 06 2017   grade_5 25 17 41 0   13     0   3   65 34                       99 25 17 41 0   13     0   3   65 34                 99
1131505 1131505 MA Essex   school 2500520 477   Silver Hill Horace Mann Charter (District) 250052002641 4770010 Silver Hill Horace Mann Charter School   Regular School Yes Elementary KG 05 2017   grade_3 68 4 22 0   3     0   2   56 43                       99 68 4 22 0   3     0   2   56 43                 99
1131621 1131621 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_8 86 4 5 0   3     0   1   48 51                       99 86 4 5 0   3     0   1   48 51                 99
1131700 1131700 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Merriam School   Regular School No Elementary KG 06 2017   grade_6 63 3 3 0   27     0   3   55 44                       99 63 3 3 0   27     0   3   55 44                 99
1131895 1131895 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No High 09 12 2017   grade_11 93 1 2 0   1     0   2   47 52                       99 93 1 2 0   1     0   2   47 52                 99
1132021 1132021 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2017   grade_5 89 1 4 0   1     0   4   54 45                       99 89 1 4 0   1     0   4   54 45                 99
1132097 1132097 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No Elementary PK 03 2017   grade_1 92 3 3 0   1     0   0   50 49                       99 92 3 3 0   1     0   0   50 49                 99
1132161 1132161 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000808 6730010 Florence Roche School   Regular School No Elementary KG 04 2017   grade_3 87 1 2 0   5     0   4   48 51                       99 87 1 2 0   5     0   4   48 51                 99
1132438 1132438 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2017   grade_6 91 0 7 0   0     0   1   53 46                       99 91 0 7 0   0     0   1   53 46                 99
1132460 1132460 MA Worcester   school 2508310 725   Nashoba 250831000362 7250020 Center School   Regular School No Elementary PK 05 2017   grade_4 78 0 8 1   11     0   1   52 47                       99 78 0 8 1   11     0   1   52 47                 99
1132734 1132734 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2017   grade_5 87 2 6 0   1     0   3   50 49                       99 87 2 6 0   1     0   3   50 49                 99
1132735 1132735 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2017   grade_6 90 3 3 0   2     0   1   49 50                       99 90 3 3 0   2     0   1   49 50                 99
1132757 1132757 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2017   grade_4 85 2 5 0   3     0   4   50 49                       99 85 2 5 0   3     0   4   50 49                 99
1132858 1132858 MA Worcester   school 2511880 775   Wachusett 251188001476 7750027 Houghton Elementary   Regular School No Elementary KG 04 2017   grade_3 88 1 6 0   0     0   4   57 42                       99 88 1 6 0   0     0   4   57 42                 99
1133141 1133141 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_4 2 56 39 0   0     0   2   51 48                       99 2 56 39 0   0     0   2   51 48                 99
1122260 1122260 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2017   grade_1 77 1 14 2   1     0   3   53 45                       98 77 1 14 2   1     0   3   53 45                 98
1122647 1122647 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No Elementary PK 05 2017   grade_2 16 20 56 0   2     0   4   61 37                       98 16 20 56 0   2     0   4   61 37                 98
1124128 1124128 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2017   kindergarten 52 9 31 0   0     0   6   46 52                       98 52 9 31 0   0     0   6   46 52                 98
1124461 1124461 MA Middlesex   school 2504320 79   Dracut 250432002822 790045 George H. Englesby Elementary School   Regular School No Elementary KG 05 2017   grade_3 69 7 12 0   6     0   4   50 48                       98 69 7 12 0   6     0   4   50 48                 98
1124546 1124546 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No Elementary 03 05 2017   grade_3 78 4 3 0   11     0   2   42 56                       98 78 4 3 0   11     0   2   42 56                 98
1124666 1124666 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2017   grade_2 29 19 43 0   5     0   2   50 48                       98 29 19 43 0   5     0   2   50 48                 98
1124680 1124680 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2017   grade_6 11 16 63 0   7     0   1   52 46                       98 11 16 63 0   7     0   1   52 46                 98
1124721 1124721 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2017   kindergarten 49 5 34 0   2     0   8   55 43                       98 49 5 34 0   2     0   8   55 43                 98
1124846 1124846 MA Barnstable   school 2504860 96   Falmouth 250486000689 960020 Mullen-Hall   Regular School No Elementary KG 04 2017   grade_2 81 6 5 1   2     0   3   52 46                       98 81 6 5 1   2     0   3   52 46                 98
1124979 1124979 MA Middlesex   school 2504980 100   Framingham 250498000721 1000015 Hemenway   Regular School No Elementary KG 05 2017   grade_1 65 2 16 0   8     0   7   50 48                       98 65 2 16 0   8     0   7   50 48                 98
1125010 1125010 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2017   grade_4 49 13 27 0   3     0   6   48 50                       98 49 13 27 0   3     0   6   48 50                 98
1125014 1125014 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2017   grade_1 65 7 24 0   0     0   2   48 50                       98 65 7 24 0   0     0   2   48 50                 98
1125135 1125135 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No High 09 12 2017   grade_10 92 0 4 0   1     0   1   43 55                       98 92 0 4 0   1     0   1   43 55                 98
1125355 1125355 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_7 76 2 3 0   16     0   1   44 54                       98 76 2 3 0   16     0   1   44 54                 98
1126148 1126148 MA Middlesex   school 2507020 160   Lowell 250702000067 1600002 Dr Gertrude Bailey   Regular School No Elementary PK 04 2017   grade_2 39 4 25 0   25     0   5   53 45                       98 39 4 25 0   25     0   5   53 45                 98
1126209 1126209 MA Middlesex   school 2507020 160   Lowell 250702001044 1600036 Pawtucketville Memorial   Regular School No Elementary PK 04 2017   grade_2 34 5 27 0   27     0   5   52 46                       98 34 5 27 0   27     0   5   52 46                 98
1126238 1126238 MA Middlesex   school 2507020 160   Lowell 250702000088 1600075 S Christa McAuliffe Elementary   Regular School No Elementary PK 04 2017   grade_4 27 4 48 0   14     0   5   51 47                       98 27 4 48 0   14     0   5   51 47                 98
1126551 1126551 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2017   kindergarten 29 22 23 0   22     0   2   45 53                       98 29 22 23 0   22     0   2   45 53                 98
1127103 1127103 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2017   grade_7 91 1 1 0   0     2   3   51 47                       98 91 1 1 0   0     2   3   51 47                 98
1127163 1127163 MA Middlesex   school 2508340 198   Natick 250834001301 1980043 Memorial   Regular School No Elementary KG 04 2017   grade_2 88 0 4 0   1     0   5   54 44                       98 88 0 4 0   1     0   5   54 44                 98
1127277 1127277 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary PK 05 2017   grade_2 20 10 65 1   0     0   2   53 45                       98 20 10 65 1   0     0   2   53 45                 98
1127959 1127959 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2017   grade_9 72 2 17 0   1     0   6   44 54                       98 72 2 17 0   1     0   6   44 54                 98
1128232 1128232 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 04 2017   grade_1 84 0 9 0   1     0   4   47 51                       98 84 0 9 0   1     0   4   47 51                 98
1128301 1128301 MA Norfolk   school 2509870 243   Quincy 250987001571 2430035 Lincoln-Hancock Community School   Regular School No Elementary KG 04 2017   grade_3 41 13 11 0   27     0   6   59 39                       98 41 13 11 0   27     0   6   59 39                 98
1128522 1128522 MA Suffolk   school 2510050 248   Revere 251005001975 2480056 Garfield Elementary School   Regular School No Elementary PK 05 2017   pre_kindergarten 54 1 35 0   6     0   2   50 48                       98 54 1 35 0   6     0   2   50 48                 98
1129325 1129325 MA Hampden   school 2511130 281   Springfield 251113001822 2810195 German Gerena Community School   Regular School No Elementary PK 05 2017   grade_2 4 6 88 0   0     0   0   49 49                       98 4 6 88 0   0     0   0   49 49                 98
1129334 1129334 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No Other 06 12 2017   grade_10 24 27 44 0   3     0   0   48 50                       98 24 27 44 0   3     0   0   48 50                 98
1129393 1129393 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Van Sickle Academy   Regular School No Middle 06 08 2017   grade_7 10 16 67 0   3     0   2   52 46                       98 10 16 67 0   3     0   2   52 46                 98
1129757 1129757 MA Essex   school 2511670 298   Topsfield 251167001929 2980010 Steward Elementary   Regular School No Elementary PK 03 2017   grade_3 88 1 2 0   2     0   5   45 53                       98 88 1 2 0   2     0   5   45 53                 98
1130142 1130142 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 J Harding Armstrong   Regular School No Elementary KG 03 2017   grade_2 47 3 4 0   44     0   0   44 54                       98 47 3 4 0   44     0   0   44 54                 98
1130750 1130750 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary PK 06 2017   kindergarten 10 8 73 0   6     0   1   45 53                       98 10 8 73 0   6     0   1   45 53                 98
1131366 1131366 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes Other 05 12 2017   grade_7 43 31 23 0   0     0   1   47 51                       98 43 31 23 0   0     0   1   47 51                 98
1131507 1131507 MA Essex   school 2500520 477   Silver Hill Horace Mann Charter (District) 250052002641 4770010 Silver Hill Horace Mann Charter School   Regular School Yes Elementary KG 05 2017   grade_5 76 0 20 1   1     0   0   46 52                       98 76 0 20 1   1     0   0   46 52                 98
1131585 1131585 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2017   grade_5 22 56 9 1   7     0   3   53 45                       98 22 56 9 1   7     0   3   53 45                 98
1131820 1131820 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No High 09 12 2017   grade_11 86 3 8 0   1     0   0   47 51                       98 86 3 8 0   1     0   0   47 51                 98
1132099 1132099 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown Elementary School   Regular School No Elementary PK 03 2017   grade_3 98 0 0 0   0     0   0   46 52                       98 98 0 0 0   0     0   0   46 52                 98
1132312 1132312 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No High 09 12 2017   grade_11 98 0 0 0   0     0   0   46 52                       98 98 0 0 0   0     0   0   46 52                 98
1132359 1132359 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054400840 7120002 Harwich Elementary School   Regular School No Elementary PK 04 2017   kindergarten 82 5 6 0   0     0   5   46 52                       98 82 5 6 0   0     0   5   46 52                 98
1132472 1132472 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2017   grade_8 93 1 1 0   2     0   1   46 52                       98 93 1 1 0   2     0   1   46 52                 98
1132760 1132760 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_6 87 1 9 0   1     0   0   57 41                       98 87 1 9 0   1     0   0   57 41                 98
1132900 1132900 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2017   grade_5 91 0 3 0   2     0   2   44 54                       98 91 0 3 0   2     0   2   44 54                 98
1132955 1132955 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary 03 05 2017   grade_3 95 0 1 0   0     0   2   49 49                       98 95 0 1 0   0     0   2   49 49                 98
1123701 1123701 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_11 169 633 111 4   31     2   28   494 484                       978 169 633 111 4   31     2   28   494 484                 978
1122073 1122073 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2017   grade_3 74 3 7 0   7     0   6   43 54                       97 74 3 7 0   7     0   6   43 54                 97

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