Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by total descending

View and edit SQL

year

  • 2020 · 9,537
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
1365014 MA Bristol   school 2502190 16   Attleboro 250219000089 160045 Hill-Roberts Elementary School   Regular School No Elementary KG 04 2020   grade_4 68 6 10 0   7     0   8   55 44 *                     99.0 68 6 10 0   7     0   8   55 44                 99
1365247 MA Middlesex   school 2502670 31   Billerica 250267000184 310015 Parker   Regular School No Elementary KG 04 2020   grade_4 64 5 9 1   14     0   6   54 45 *                     99.0 64 5 9 1   14     0   6   54 45                 99
1365335 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2020   grade_3 35 16 42 0   0     0   6   46 53 *                     99.0 35 16 42 0   0     0   6   46 53                 99
1365337 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2020   grade_5 30 17 44 0   3     0   5   39 60 *                     99.0 30 17 44 0   3     0   5   39 60                 99
1365845 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2020   grade_6 1 70 23 1   2     0   2   54 45 *                     99.0 1 70 23 1   2     0   2   54 45                 99
1366468 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2020   grade_7 45 19 15 1   10     0   9   57 42 *                     99.0 45 19 15 1   10     0   9   57 42                 99
1366475 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2020   grade_8 43 26 11 0   11     0   8   41 58 *                     99.0 43 26 11 0   11     0   8   41 58                 99
1366549 MA Middlesex   school 2503510 56   Chelmsford 250351000474 560025 Charles D Harrington   Regular School No Elementary KG 04 2020   grade_2 63 5 10 0   21     0   0   47 52 *                     99.0 63 5 10 0   21     0   0   47 52                 99
1366552 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2020   kindergarten 76 1 7 0   12     0   3   54 45 *                     99.0 76 1 7 0   12     0   3   54 45                 99
1366556 MA Middlesex   school 2503510 56   Chelmsford 250351000472 560030 Byam School   Regular School No Elementary KG 04 2020   grade_4 75 0 12 0   6     0   6   55 44 *                     99.0 75 0 12 0   6     0   6   55 44                 99
1366795 MA Bristol   school 2504020 72   Dartmouth 250402000544 720015 Joseph Demello   Regular School No Elementary 01 05 2020   grade_3 79 3 6 0   1     0   10   57 42 *                     99.0 79 3 6 0   1     0   10   57 42                 99
1366880 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Joseph A Campbell Elementary   Regular School No Elementary PK 05 2020   grade_2 81 3 9 0   2     0   4   55 44 *                     99.0 81 3 9 0   2     0   4   55 44                 99
1366976 MA Hampden   school 2504500 87   East Longmeadow 250450000606 870015 Mountain View   Regular School No Elementary 03 05 2020   grade_3 80 0 7 0   5     0   7   53 46 *                     99.0 80 0 7 0   5     0   7   53 46                 99
1367139 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Letourneau Elementary School   Regular School No Elementary PK 05 2020   grade_4 50 7 37 0   1     0   4   47 52 *                     99.0 50 7 37 0   1     0   4   47 52                 99
1367377 MA Middlesex   school 2504980 100   Framingham 250498000734 1000055 Woodrow Wilson   Regular School No Elementary KG 05 2020   grade_4 49 9 37 0   0     0   4   42 57 *                     99.0 49 9 37 0   0     0   4   42 57                 99
1367627 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2020   grade_10 72 2 6 0   16     0   3   44 55 *                     99.0 72 2 6 0   16     0   3   44 55                 99
1367628 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2020   grade_11 76 3 3 0   14     0   3   51 48 *                     99.0 76 3 3 0   14     0   3   51 48                 99
1368012 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_5 1 0 98 0   0     0   0   55 44 *                     99.0 1 0 98 0   0     0   0   55 44                 99
1368120 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No Elementary KG 05 2020   kindergarten 36 10 44 0   5     0   4   53 46 *                     99.0 36 10 44 0   5     0   4   53 46                 99
1368243 MA Middlesex   school 2506960 158   Littleton 250696001012 1580505 Littleton High School   Regular School No High 09 12 2020   grade_10 84 1 2 0   9     0   3   48 51 *                     99.0 84 1 2 0   9     0   3   48 51                 99
1368356 MA Middlesex   school 2507020 160   Lowell 250702000088 1600075 S Christa McAuliffe Elementary   Regular School No Elementary PK 04 2020   grade_1 40 5 42 0   9     0   3   42 57 *                     99.0 40 5 42 0   9     0   3   42 57                 99
1368637 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_2 29 11 16 0   39     0   4   51 48 *                     99.0 29 11 16 0   39     0   4   51 48                 99
1368817 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No Elementary PK 03 2020   grade_3 75 1 15 0   0     0   8   58 41 *                     99.0 75 1 15 0   0     0   8   58 41                 99
1368820 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2020   grade_6 79 4 13 0   0     0   3   42 57 *                     99.0 79 4 13 0   0     0   3   42 57                 99
1369067 MA Norfolk   school 2507980 189   Milton 250798002485 1890007 Cunningham School   Regular School No Elementary PK 05 2020   grade_3 75 6 5 0   8     0   5   50 49 *                     99.0 75 6 5 0   8     0   5   50 49                 99
1369074 MA Norfolk   school 2507980 189   Milton 250798001261 1890010 Glover   Regular School No Elementary KG 05 2020   grade_4 77 8 2 0   4     0   8   49 50 *                     99.0 77 8 2 0   4     0   8   49 50                 99
1369373 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2020   grade_3 68 2 6 0   16     0   7   55 44 *                     99.0 68 2 6 0   16     0   7   55 44                 99
1369606 MA Bristol   school 2508730 212   North Attleborough 250873001404 2120013 Joseph W Martin Jr Elementary   Regular School No Elementary KG 05 2020   grade_5 83 5 2 0   5     0   4   48 51 *                     99.0 83 5 2 0   5     0   4   48 51                 99
1369798 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No Elementary 03 06 2020   grade_6 87 2 9 0   1     0   0   49 50 *                     99.0 87 2 9 0   1     0   0   49 50                 99
1370058 MA Plymouth   school 2509720 239   Plymouth 250972001547 2390046 South Elementary   Regular School No Elementary KG 05 2020   grade_1 82 4 4 1   1     0   7   46 53 *                     99.0 82 4 4 1   1     0   7   46 53                 99
1370267 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2020   kindergarten 34 2 53 0   7     0   3   59 40 *                     99.0 34 2 53 0   7     0   3   59 40                 99
1370420 MA Essex   school 2510380 258   Salem 251038001668 2580070 Witchcraft Heights   Regular School No Elementary KG 05 2020   grade_3 34 11 43 0   4     0   7   47 52 *                     99.0 34 11 43 0   4     0   7   47 52                 99
1370560 MA Norfolk   school 2510620 266   Sharon 251062001704 2660015 Heights Elementary   Regular School No Elementary KG 05 2020   grade_1 55 3 5 0   30     0   6   52 47 *                     99.0 55 3 5 0   30     0   6   52 47                 99
1370752 MA Worcester   school 2511010 277   Southbridge 251101002868 2770515 Southbridge High School   Regular School No High 09 12 2020   grade_12 31 2 62 0   2     1   1   50 49 *                     99.0 31 2 62 0   2     1   1   50 49                 99
1371150 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2020   grade_1 88 1 4 0   2     0   4   49 50 *                     99.0 88 1 4 0   2     0   4   49 50                 99
1371268 MA Bristol   school 2511520 293   Taunton 251152002697 2930015 Mulcahey Elementary School   Regular School No Elementary PK 04 2020   kindergarten 52 19 22 0   1     0   5   50 49 *                     99.0 52 19 22 0   1     0   5   50 49                 99
1371613 MA Norfolk   school 2512270 317   Wellesley 251227002893 3170001 Preschool at Wellesley Schools   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 63 2 10 0   19     0   5   48 51 *                     99.0 63 2 10 0   19     0   5   48 51                 99
1371771 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No Elementary KG 02 2020   kindergarten 79 1 0 0   16     0   3   50 49 *                     99.0 79 1 0 0   16     0   3   50 49                 99
1372489 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2020   grade_6 6 65 23 0   1     1   3   54 45 *                     99.0 6 65 23 0   1     1   3   54 45                 99
1372586 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_11 65 12 11 0   9     0   2   44 55 *                     99.0 65 12 11 0   9     0   2   44 55                 99
1372865 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_12 0 60 37 0   1     0   1   38 61 *                     99.0 0 60 37 0   1     0   1   38 61                 99
1373054 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204002367 6100005 Westminster Elementary   Regular School No Elementary 02 05 2020   grade_5 86 0 6 0   1     0   6   53 46 *                     99.0 86 0 6 0   1     0   6   53 46                 99
1373635 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Templeton Elementary School   Regular School No Elementary PK 05 2020   grade_3 90 1 3 0   1     0   4   51 48 *                     99.0 90 1 3 0   1     0   4   51 48                 99
1373673 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2020   grade_6 88 1 3 0   3     0   4   56 43 *                     99.0 88 1 3 0   3     0   4   56 43                 99
1373875 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2020   grade_9 91 2 2 0   2     0   2   47 52 *                     99.0 91 2 2 0   2     0   2   47 52                 99
1373960 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No Elementary KG 02 2020   grade_2 84 1 10 0   1     0   3   47 52 *                     99.0 84 1 10 0   1     0   3   47 52                 99
1374037 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2020   grade_8 88 1 6 0   0     0   4   56 43 *                     99.0 88 1 6 0   0     0   4   56 43                 99
1365017 MA Bristol   school 2502190 16   Attleboro 250219001294 160050 Peter Thacher Elementary School   Regular School No Elementary KG 04 2020   grade_2 57 14 9 1   10     0   7   51 47 *                     98.0 57 14 9 1   10     0   7   51 47                 98
1365131 MA Norfolk   school 2502460 25   Bellingham 250246000670 250003 Bellingham Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 82 3 3 0   10     0   0   52 46 *                     98.0 82 3 3 0   10     0   0   52 46                 98
1365188 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley Community School   Regular School No Elementary PK 04 2020   grade_4 90 0 3 0   0     0   5   38 60 *                     98.0 90 0 3 0   0     0   5   38 60                 98
1365921 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2020   grade_9 2 55 34 0   2     0   5   47 51 *                     98.0 2 55 34 0   2     0   5   47 51                 98
1366149 MA Plymouth   school 2503090 44   Brockton 250309002649 440002 Mary E. Baker School   Regular School No Elementary KG 05 2020   kindergarten 29 48 16 0   2     1   2   54 44 *                     98.0 29 48 16 0   2     1   2   54 44                 98
1366166 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2020   grade_4 30 61 5 0   0     0   2   47 51 *                     98.0 30 61 5 0   0     0   2   47 51                 98
1366167 MA Plymouth   school 2503090 44   Brockton 250309000386 440010 Brookfield   Regular School No Elementary KG 05 2020   grade_5 16 60 12 0   3     1   6   51 47 *                     98.0 16 60 12 0   3     1   6   51 47                 98
1366186 MA Plymouth   school 2503090 44   Brockton 250309000396 440045 Hancock   Regular School No Elementary KG 05 2020   grade_3 37 42 12 0   0     0   7   51 47 *                     98.0 37 42 12 0   0     0   7   51 47                 98
1366213 MA Plymouth   school 2503090 44   Brockton 250309000387 440110 Downey   Regular School No Elementary KG 05 2020   grade_3 16 53 17 1   1     1   9   60 38 *                     98.0 16 53 17 1   1     1   9   60 38                 98
1366370 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Francis Wyman Elementary   Regular School No Elementary KG 05 2020   grade_5 60 10 6 0   19     0   3   48 50 *                     98.0 60 10 6 0   19     0   3   48 50                 98
1366471 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Putnam Avenue Upper School   Regular School No Middle 06 08 2020   grade_7 29 33 14 0   14     1   7   39 59 *                     98.0 29 33 14 0   14     1   7   39 59                 98
1366619 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2020   grade_2 41 10 43 0   1     0   3   52 46 *                     98.0 41 10 43 0   1     0   3   52 46                 98
1366692 MA Worcester   school 2503750 64   Clinton 250375002379 640050 Clinton Elementary   Regular School No Elementary PK 04 2020   pre_kindergarten 61 2 31 0   1     0   3   54 44 *                     98.0 61 2 31 0   1     0   3   54 44                 98
1366856 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2020   kindergarten 86 1 9 0   0     0   2   49 49 *                     98.0 86 1 9 0   0     0   2   49 49                 98
1366970 MA Hampden   school 2504500 87   East Longmeadow 250450000604 870010 Mapleshade   Regular School No Elementary 03 05 2020   grade_4 74 1 12 0   7     0   4   48 50 *                     98.0 74 1 12 0   7     0   4   48 50                 98
1366992 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2020   grade_1 83 5 5 0   1     0   4   47 51 *                     98.0 83 5 5 0   1     0   4   47 51                 98
1367288 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Goodrich Academy   Regular School No High 09 12 2020   grade_12 45 7 40 0   1     0   5   55 43 *                     98.0 45 7 40 0   1     0   5   55 43                 98
1367372 MA Middlesex   school 2504980 100   Framingham 250498000728 1000050 Miriam F McCarthy School   Regular School No Elementary KG 05 2020   grade_5 37 18 35 0   1     0   7   51 47 *                     98.0 37 18 35 0   1     0   7   51 47                 98
1367859 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke STEM Academy   Regular School No Middle 06 08 2020   grade_7 9 6 79 0   2     0   2   52 46 *                     98.0 9 6 79 0   2     0   2   52 46                 98
1368011 MA Essex   school 2506660 149   Lawrence 250666000956 1490040 Francis M Leahy   Regular School No Elementary 01 05 2020   grade_4 4 1 92 0   0     0   1   49 49 *                     98.0 4 1 92 0   0     0   1   49 49                 98
1368016 MA Essex   school 2506660 149   Lawrence 250666002799 1490048 Oliver Partnership School   Regular School No Elementary 01 05 2020   grade_4 5 0 93 0   0     0   0   50 48 *                     98.0 5 0 93 0   0     0   0   50 48                 98
1368124 MA Worcester   school 2506780 153   Leominster 250678002637 1530010 Frances Drake School   Regular School No Elementary KG 05 2020   grade_4 31 8 50 0   2     0   7   50 48 *                     98.0 31 8 50 0   2     0   7   50 48                 98
1368359 MA Middlesex   school 2507020 160   Lowell 250702000088 1600075 S Christa McAuliffe Elementary   Regular School No Elementary PK 04 2020   grade_4 29 6 54 0   8     0   1   49 49 *                     98.0 29 6 54 0   8     0   1   49 49                 98
1368513 MA Essex   school 2507110 163   Lynn 250711001087 1630040 Wm P Connery   Regular School No Elementary PK 05 2020   grade_3 7 5 78 0   6     0   2   41 57 *                     98.0 7 5 78 0   6     0   2   41 57                 98
1368520 MA Essex   school 2507110 163   Lynn 250711001070 1630045 E J Harrington   Regular School No Elementary PK 05 2020   grade_3 9 8 75 0   5     0   1   52 46 *                     98.0 9 8 75 0   5     0   1   52 46                 98
1368642 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_7 25 13 18 0   39     0   3   55 43 *                     98.0 25 13 18 0   39     0   3   55 43                 98
1368645 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2020   grade_1 25 19 26 0   24     0   4   50 48 *                     98.0 25 19 26 0   24     0   4   50 48                 98
1368648 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2020   grade_4 19 22 31 1   17     0   8   53 45 *                     98.0 19 22 31 1   17     0   8   53 45                 98
1369290 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2020   pre_kindergarten 65 10 21 0   0     0   2   45 53 *                     98.0 65 10 21 0   0     0   2   45 53                 98
1369295 MA Bristol   school 2508430 201   New Bedford 250843001320 2010123 Casimir Pulaski   Regular School No Elementary PK 05 2020   grade_5 66 8 17 0   0     0   7   47 51 *                     98.0 66 8 17 0   0     0   7   47 51                 98
1369713 MA Bristol   school 2509000 218   Norton 250900001449 2180015 J C Solmonese   Regular School No Elementary PK 03 2020   kindergarten 91 0 3 0   0     0   4   47 51 *                     98.0 91 0 3 0   0     0   4   47 51                 98
1369823 MA Worcester   school 2509270 226   Oxford 250927001482 2260505 Oxford High   Regular School No High 08 12 2020   grade_9 78 2 15 1   2     0   0   41 57 *                     98.0 78 2 15 1   2     0   0   41 57                 98
1370148 MA Norfolk   school 2509870 243   Quincy 250987001582 2430090 Snug Harbor Community School   Regular School No Elementary PK 05 2020   pre_kindergarten 43 6 11 1   31     0   6   55 43 *                     98.0 43 6 11 1   31     0   6   55 43                 98
1370175 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 South West Middle School   Regular School No Middle 05 08 2020   grade_5 41 7 11 1   35     0   3   64 34 *                     98.0 41 7 11 1   35     0   3   64 34                 98
1370888 MA Hampden   school 2511130 281   Springfield 251113001810 2810100 Indian Orchard Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten 9 22 64 0   2     0   1   55 43 *                     98.0 9 22 64 0   2     0   1   55 43                 98
1370893 MA Hampden   school 2511130 281   Springfield 251113001810 2810100 Indian Orchard Elementary   Regular School No Elementary PK 05 2020   grade_5 7 22 65 0   1     0   3   48 50 *                     98.0 7 22 65 0   1     0   3   48 50                 98
1370986 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2020   grade_7 18 22 58 0   0     0   0   40 58 *                     98.0 18 22 58 0   0     0   0   40 58                 98
1371030 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2020   grade_8 14 19 62 0   3     0   0   45 53 *                     98.0 14 19 62 0   3     0   0   45 53                 98
1371234 MA Bristol   school 2511460 292   Swansea 251146001892 2920015 Gardner   Regular School No Elementary KG 02 2020   kindergarten 94 1 1 1   0     0   1   52 46 *                     98.0 94 1 1 1   0     0   1   52 46                 98
1371555 MA Middlesex   school 2512180 314   Watertown 251218002001 3140020 Hosmer   Regular School No Elementary PK 05 2020   grade_3 52 3 24 0   8     0   11   56 42 *                     98.0 52 3 24 0   8     0   11   56 42                 98
1371576 MA Middlesex   school 2512210 315   Wayland 251221002007 3150005 Claypit Hill School   Regular School No Elementary KG 05 2020   grade_3 75 5 1 0   10     1   6   48 50 *                     98.0 75 5 1 0   10     1   6   48 50                 98
1372124 MA Worcester   school 2513230 348   Worcester 251323002197 3480020 Belmont Street Community   Regular School No Elementary PK 06 2020   kindergarten 26 13 45 0   8     0   6   59 39 *                     98.0 26 13 45 0   8     0   6   59 39                 98
1372318 MA Worcester   school 2513230 348   Worcester 251323002243 3480220 Roosevelt   Regular School No Elementary PK 06 2020   kindergarten 32 22 31 1   4     0   8   54 44 *                     98.0 32 22 31 1   4     0   8   54 44                 98
1372694 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2020   grade_5 49 32 11 0   1     0   5   53 45 *                     98.0 49 32 11 0   1     0   5   53 45                 98
1372787 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_1 1 58 39 0   0     0   0   44 54 *                     98.0 1 58 39 0   0     0   0   44 54                 98
1372788 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_2 1 53 40 0   1     1   2   48 50 *                     98.0 1 53 40 0   1     1   2   48 50                 98
1373263 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002427 6500005 Dighton Elementary   Regular School No Elementary PK 04 2020   grade_3 79 2 6 0   2     0   9   50 48 *                     98.0 79 2 6 0   2     0   9   50 48                 98
1373674 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2020   grade_7 77 1 7 1   11     0   1   58 40 *                     98.0 77 1 7 1   11     0   1   58 40                 98
1374056 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001497 7800035 Indian Head   Regular School No Elementary KG 04 2020   grade_1 88 1 5 0   2     0   2   44 54 *                     98.0 88 1 5 0   2     0   2   44 54                 98
1374236 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_8 65 12 14 0   2     0   5   56 42 *                     98.0 65 12 14 0   2     0   5   56 42                 98
1364849 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Charles C Cashman Elementary   Regular School No Elementary PK 04 2020   grade_4 78 2 12 0   2     0   3   57 40 *                     97.0 78 2 12 0   2     0   3   57 40                 97
1364887 MA Essex   school 2501950 9   Andover 250195000047 90003 Bancroft Elementary   Regular School No Elementary KG 05 2020   grade_2 84 2 2 0   7     0   2   51 46 *                     97.0 84 2 2 0   7     0   2   51 46                 97
1365191 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_7 91 0 4 0   0     0   2   48 49 *                     97.0 91 0 4 0   0     0   2   48 49                 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]);