Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by total descending

View and edit SQL

year

grade

  • grade_6 · 4,038
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
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
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
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
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
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
1672708 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston - Condon K-8   Regular School No Elementary PK 08 2021   grade_6 25 20 37 0   12     0   5   49 50 *                     99.0 25 20 37 0   12     0   5   49 50                 99
2040940 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2019   grade_6 3 31 63 0   2     0   0   50 49                       99.0 3 31 63 0   2     0   0   50 49                 99
2042840 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2019   grade_6 49 21 13 0   6     0   10   43 55                       99.0 49 21 13 0   6     0   10   43 55                 99
2046089 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2019   grade_6 16 21 61 0   0     0   1   57 42                       99.0 16 21 61 0   0     0   1   57 42                 99
2046113 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2019   grade_6 6 18 72 0   0     0   3   60 39                       99.0 6 18 72 0   0     0   3   60 39                 99
2231958 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Georgetown: Penn Brook   Regular School No Elementary KG 06 2018   grade_6 95 2 2 0   0     0   0   53 46                       99.0 95 2 2 0   0     0   0   53 46                 99
2238197 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District): Boston Collegiate Charter School   Regular School Yes High 05 12 2018   grade_6 30 38 24 0   4     0   3   51 48                       99.0 30 38 24 0   4     0   3   51 48                 99
738547 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_6 80 3 3 0   11     0   2   53 46                       99 80 3 3 0   11     0   2   53 46                 99
738676 MA Norfolk   school 2506150 133   Holbrook 250615000882 1330025 South   Regular School No 2 04 06 2015   grade_6 69 11 11 0   5     0   3   57 42                       99 69 11 11 0   5     0   3   57 42                 99
739214 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No 2 06 08 2015   grade_6 73 4 5 0   12     0   5   53 46                       99 73 4 5 0   12     0   5   53 46                 99
937703 MA Plymouth   school 2509420 231   Pembroke 250942001510 2310015 North Pembroke Elementary   Regular School No 1 PK 06 2016   grade_6 93 0 3 0   1     0   2   48 51                       99 93 0 3 0   1     0   2   48 51                 99
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
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
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
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
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
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
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
1673105 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Boston - Lilla G. Frederick Middle School   Regular School No Middle 06 08 2021   grade_6 2 38 43 0   14     0   1   57 41 *                     98.0 2 38 43 0   14     0   1   57 41                 98
2042123 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2019   grade_6 37 14 43 0   4     0   0   52 46                       98.0 37 14 43 0   4     0   0   52 46                 98
2046787 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No Middle 04 06 2019   grade_6 84 6 4 0   0     0   4   42 56                       98.0 84 6 4 0   0     0   4   42 56                 98
2048159 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2019   grade_6 80 0 12 0   2     0   4   55 43                       98.0 80 0 12 0   2     0   4   55 43                 98
2229524 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston: Donald Mckay   Regular School No Elementary PK 08 2018   grade_6 6 3 88 0   0     0   1   47 51                       98.0 6 3 88 0   0     0   1   47 51                 98
2237584 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Worcester: Woodland Academy   Regular School No Elementary KG 06 2018   grade_6 9 12 65 0   10     0   2   47 51                       98.0 9 12 65 0   10     0   2   47 51                 98
2238420 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District): Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2018   grade_6 23 54 9 1   8     0   3   56 42                       98.0 23 54 9 1   8     0   3   56 42                 98
738004 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2015   grade_6 30 26 39 0   1     0   2   50 48                       98 30 26 39 0   1     0   2   50 48                 98
741974 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No 2 06 08 2015   grade_6 13 29 52 0   1     0   3   61 37                       98 13 29 52 0   1     0   3   61 37                 98
741986 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No 2 06 08 2015   grade_6 5 4 89 0   0     0   0   47 51                       98 5 4 89 0   0     0   0   47 51                 98
742663 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No 2 04 06 2015   grade_6 85 1 4 0   4     0   4   50 48                       98 85 1 4 0   4     0   4   50 48                 98
935397 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_6 76 2 5 0   14     0   1   46 52                       98 76 2 5 0   14     0   1   46 52                 98
935637 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No 1 KG 06 2016   grade_6 90 2 5 0   0     0   1   47 51                       98 90 2 5 0   0     0   1   47 51                 98
938779 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No 2 06 08 2016   grade_6 13 24 59 0   2     0   0   66 32                       98 13 24 59 0   2     0   0   66 32                 98
940016 MA Worcester   school 2513230 348   Worcester 251323002217 3480110 Gates Lane   Regular School No 1 PK 06 2016   grade_6 31 10 32 0   19     0   6   65 33                       98 31 10 32 0   19     0   6   65 33                 98
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
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
1368018 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2020   grade_6 0 0 97 0   0     0   0   46 50 *                     97.0 0 0 97 0   0     0   0   46 50                 97
1368650 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2020   grade_6 23 14 40 0   16     0   4   49 48 *                     97.0 23 14 40 0   16     0   4   49 48                 97
1371041 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle Academy   Regular School No Middle 06 08 2020   grade_6 9 8 79 0   1     0   0   55 42 *                     97.0 9 8 79 0   1     0   0   55 42                 97
1372145 MA Worcester   school 2513230 348   Worcester 251323002106 3480030 Woodland Academy   Regular School No Elementary KG 06 2020   grade_6 10 10 69 0   7     0   1   53 44 *                     97.0 10 10 69 0   7     0   1   53 44                 97
1672633 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston - Donald Mckay   Regular School No Elementary PK 08 2021   grade_6 8 0 88 0   0     0   1   44 53 *                     97.0 8 0 88 0   0     0   1   44 53                 97
1679959 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District) - Boston Collegiate Charter School   Regular School Yes High 05 12 2021   grade_6 49 32 12 0   1     0   3   53 44 *                     97.0 49 32 12 0   1     0   3   53 44                 97
2041351 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2019   grade_6 57 5 19 0   7     0   9   52 45                       97.0 57 5 19 0   7     0   9   52 45                 97
2048109 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2019   grade_6 85 6 6 0   0     0   0   51 46                       97.0 85 6 6 0   0     0   0   51 46                 97
736230 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No 1 PK 08 2015   grade_6 10 23 58 1   2     0   3   44 53                       97 10 23 58 1   2     0   3   44 53                 97
739593 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No 1 KG 08 2015   grade_6 36 18 16 0   23     0   4   51 46                       97 36 18 16 0   23     0   4   51 46                 97
741977 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No 2 06 08 2015   grade_6 1 14 79 0   2     0   1   53 44                       97 1 14 79 0   2     0   1   53 44                 97
743842 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2015   grade_6 8 57 21 0   10     0   1   57 40                       97 8 57 21 0   10     0   1   57 40                 97
934053 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2016   grade_6 52 3 11 0   19     1   11   49 48                       97 52 3 11 0   19     1   11   49 48                 97
940672 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2016   grade_6 9 64 18 0   5     0   1   41 56                       97 9 64 18 0   5     0   1   41 56                 97
1122801 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2017   grade_6 12 24 56 0   2     0   3   46 51                       97 12 24 56 0   2     0   3   46 51                 97
1123209 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   grade_6 2 54 32 2   3     0   4   54 43                       97 2 54 32 2   3     0   4   54 43                 97
1123258 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2017   grade_6 8 11 68 0   8     0   2   54 43                       97 8 11 68 0   8     0   2   54 43                 97
1125781 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_6 6 0 88 0   3     0   0   48 49                       97 6 0 88 0   3     0   0   48 49                 97
1128179 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No Elementary 04 06 2017   grade_6 83 2 4 0   3     0   5   55 42                       97 83 2 4 0   3     0   5   55 42                 97
1365562 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2020   grade_6 4 41 33 0   7     0   11   42 54 *                     96.0 4 41 33 0   7     0   11   42 54                 96
1371339 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No Middle 04 06 2020   grade_6 87 1 2 0   1     0   5   41 55 *                     96.0 87 1 2 0   1     0   5   41 55                 96
1372449 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2020   grade_6 28 15 51 0   0     0   2   40 56 *                     96.0 28 15 51 0   0     0   2   40 56                 96
1675337 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester - Leicester Middle   Regular School No Middle 05 08 2021   grade_6 71 5 13 0   3     0   4   53 43 *                     96.0 71 5 13 0   3     0   4   53 43                 96
1678278 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 Springfield - STEM Middle Academy   Regular School No Middle 06 08 2021   grade_6 4 22 62 0   5     0   3   50 46 *                     96.0 4 22 62 0   5     0   3   50 46                 96
1679955 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District) - Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2021   grade_6 69 6 1 1   17     0   2   40 56 *                     96.0 69 6 1 1   17     0   2   40 56                 96
2040889 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2019   grade_6 3 55 37 0   0     0   1   56 40                       96.0 3 55 37 0   0     0   1   56 40                 96
2045088 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No Middle 04 06 2019   grade_6 80 3 8 1   3     0   1   50 46                       96.0 80 3 8 1   3     0   1   50 46                 96
2047864 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2019   grade_6 2 46 43 0   2     0   3   38 58                       96.0 2 46 43 0   2     0   3   38 58                 96
2048334 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2019   grade_6 83 1 6 0   1     0   5   46 50                       96.0 83 1 6 0   1     0   5   46 50                 96
2233588 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Maynard: Fowler School   Regular School No Middle 04 08 2018   grade_6 77 2 9 0   2     0   6   45 51                       96.0 77 2 9 0   2     0   6   45 51                 96
2238306 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District): MATCH Charter Public School   Regular School Yes Other PK 12 2018   grade_6 1 28 65 0   0     1   1   47 49                       96.0 1 28 65 0   0     1   1   47 49                 96
738512 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No 1 KG 06 2015   grade_6 90 2 0 0   3     0   1   43 53                       96 90 2 0 0   3     0   1   43 53                 96
743798 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2015   grade_6 1 58 29 0   2     0   6   44 52                       96 1 58 29 0   2     0   6   44 52                 96
743984 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_6 90 5 0 0   1     0   0   56 40                       96 90 5 0 0   1     0   0   56 40                 96
744038 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2015   grade_6 85 1 6 0   0     0   4   48 48                       96 85 1 6 0   0     0   4   48 48                 96
934258 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No 2 06 08 2016   grade_6 42 29 7 0   11     0   7   41 55                       96 42 29 7 0   11     0   7   41 55                 96
936420 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2016   grade_6 20 30 21 1   22     0   2   41 55                       96 20 30 21 1   22     0   2   41 55                 96
941422 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2016   grade_6 86 0 4 0   3     0   3   41 55                       96 86 0 4 0   3     0   3   41 55                 96
1123962 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Rindge Avenue Upper School   Regular School No Middle 06 08 2017   grade_6 44 28 9 0   6     1   8   46 50                       96 44 28 9 0   6     1   8   46 50                 96
1131473 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2017   grade_6 2 44 46 0   3     0   1   45 51                       96 2 44 46 0   3     0   1   45 51                 96
1132901 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2017   grade_6 85 1 6 0   2     0   2   48 48                       96 85 1 6 0   2     0   2   48 48                 96
1367623 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2020   grade_6 79 1 3 0   5     0   7   39 55 *                     95.0 79 1 3 0   5     0   7   39 55                 95
1372792 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_6 3 47 42 0   0     0   3   48 47 *                     95.0 3 47 42 0   0     0   3   48 47                 95
1372888 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2020   grade_6 6 56 22 0   6     2   3   46 49 *                     95.0 6 56 22 0   6     2   3   46 49                 95
1675103 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke - Holyoke STEM Academy   Regular School No Middle 06 08 2021   grade_6 13 2 80 0   0     0   0   51 44 *                     95.0 13 2 80 0   0     0   0   51 44                 95
1679573 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Worcester - Quinsigamond   Regular School No Elementary PK 06 2021   grade_6 26 15 46 0   5     0   3   52 43 *                     95.0 26 15 46 0   5     0   3   52 43                 95
1680350 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston - Athol-Royalston Middle School   Regular School No Middle 05 08 2021   grade_6 84 1 5 0   3     0   2   54 41 *                     95.0 84 1 5 0   3     0   2   54 41                 95
2045255 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Point Webster Middle   Regular School No Middle 05 08 2019   grade_6 32 17 10 0   31     0   5   46 49                       95.0 32 17 10 0   31     0   5   46 49                 95
2047960 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2019   grade_6 15 47 20 2   8     0   3   53 42                       95.0 15 47 20 2   8     0   3   53 42                 95
2048734 MA Middlesex   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2019   grade_6 76 1 7 0   10     0   1   54 41                       95.0 76 1 7 0   10     0   1   54 41                 95
2236180 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 Springfield: STEM Middle Academy   Regular School No Middle 06 08 2018   grade_6 13 13 63 0   4     0   2   53 42                       95.0 13 13 63 0   4     0   2   53 42                 95
2238696 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Berlin-Boylston: Tahanto Regional High   Regular School No High 06 12 2018   grade_6 82 2 4 0   4     0   3   55 40                       95.0 82 2 4 0   4     0   3   55 40                 95
2239716 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Wachusett: Chocksett Middle School   Regular School No Middle 05 08 2018   grade_6 88 0 4 0   1     0   2   43 52                       95.0 88 0 4 0   1     0   2   43 52                 95
739603 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No 1 KG 08 2015   grade_6 25 23 20 0   19     0   8   46 49                       95 25 23 20 0   19     0   8   46 49                 95
744601 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No 2 06 08 2015   grade_6 85 3 2 0   2     0   3   52 43                       95 85 3 2 0   2     0   3   52 43                 95
936411 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No 1 KG 08 2016   grade_6 25 17 13 0   38     0   2   41 54                       95 25 17 13 0   38     0   2   41 54                 95
939783 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No 2 06 08 2016   grade_6 76 4 9 1   3     0   2   50 45                       95 76 4 9 1   3     0   2   50 45                 95
1128777 MA Plymouth   school 2510560 264   Scituate 251056002068 2640015 Jenkins Elementary School   Regular School No Elementary KG 06 2017   grade_6 92 0 1 0   2     0   0   43 52                       95 92 0 1 0   2     0   0   43 52                 95
1365661 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_6 2 36 50 1   1     1   3   42 52 *                     94.0 2 36 50 1   1     1   3   42 52                 94
1367051 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2020   grade_6 33 7 46 0   6     0   2   48 46 *                     94.0 33 7 46 0   6     0   2   48 46                 94

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