enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
2230209 2230209 MA Suffolk   school   35   Boston   350652               2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
739014 739014 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_6 1 0 19 0   0     0   0   16 4                       20 1 0 19 0   0     0   0   16 4                 20
739319 739319 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 01 07 2015   grade_6 * * * *   *     *   *   3 *                       3                         3                   3
739482 739482 MA Essex   school 2507110 163   Lynn 250711002527 1630080 William R Fallon   Regular School No 1 01 06 2015   grade_6 3 1 3 0   0     0   0   5 2                       7 3 1 3 0   0     0   0   5 2                 7
934971 934971 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No 1 01 08 2016   grade_6 2 4 1 0   0     0   1   7 1                       8 2 4 1 0   0     0   1   7 1                 8
935474 935474 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_6 105 5 93 0   4     0   1   100 108                       208 105 5 93 0   4     0   1   100 108                 208
935863 935863 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_6 2 1 14 0   0     0   0   14 3                       17 2 1 14 0   0     0   0   14 3                 17
1123137 1123137 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_6 3 7 5 1   0     0   0   15 1                       16 3 7 5 1   0     0   0   15 1                 16
1125424 1125424 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_6 * * * *   *     *   *   4 1                       *                         4 1                  
1125448 1125448 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_6 106 1 99 0   4     1   2   98 115                       213 106 1 99 0   4     1   2   98 115                 213
1125883 1125883 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_6 2 0 13 0   0     0   0   13 2                       15 2 0 13 0   0     0   0   13 2                 15
1366585 1366585 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 George F. Kelly Elementary   Regular School No Elementary 01 06 2020   grade_6 0 0 32 0   0     0   0   11 21 *                     32.0 0 0 32 0   0     0   0   11 21                 32
1369099 1369099 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Granite Valley School   Regular School No Elementary 01 06 2020   grade_6 65 1 4 0   1     0   2   35 38 *                     73.0 65 1 4 0   1     0   2   35 38                 73
1373782 1373782 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary 01 06 2020   grade_6 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1673283 1673283 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_6 0 4 4 0   0     0   0   6 2 *                     8.0 0 4 4 0   0     0   0   6 2                 8
1673816 1673816 MA Suffolk   school 2503540 57   Chelsea 250354000858 570035 Chelsea - George F. Kelly Elementary   Regular School No Elementary 01 06 2021   grade_6 1 0 37 0   0     0   1   16 23 *                     39.0 1 0 37 0   0     0   1   16 23                 39
1674430 1674430 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_6 3 1 1 0   0     0   1   4 2 *                     6.0 3 1 1 0   0     0   1   4 2                 6
1676346 1676346 MA Hampden   school 2508040 191   Monson 250804002903 1910030 Monson - Granite Valley School   Regular School No Elementary 01 06 2021   grade_6 67 3 2 0   0     1   5   35 42 *                     78.0 67 3 2 0   0     1   5   35 42                 78
2040823 2040823 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_6 2 10 8 0   1     0   0   18 3                       21.0 2 10 8 0   1     0   0   18 3                 21
2042269 2042269 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2042770 2042770 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_6 4 0 3 0   0     0   1   7 *                       8.0 4 0 3 0   0     0   1   7                   8
2043146 2043146 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_6 2 0 11 0   0     0   1   11 3                       14.0 2 0 11 0   0     0   1   11 3                 14
2229941 2229941 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_6 1 5 12 0   0     0   0   15 3                       18.0 1 5 12 0   0     0   0   15 3                 18
2230002 2230002 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_6 0 20 21 0   0     0   4   22 23                       45.0 0 20 21 0   0     0   4   22 23                 45
2231475 2231475 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_6 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2231497 2231497 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_6 15 23 72 0   3     0   0   54 59                       113.0 15 23 72 0   3     0   0   54 59                 113
2232699 2232699 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_6 2 0 9 0   0     0   0   9 2                       11.0 2 0 9 0   0     0   0   9 2                 11
738437 738437 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2015   grade_6 88 3 4 0   4     0   1   50 50                       100 88 3 4 0   4     0   1   50 50                 100
738442 738442 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2015   grade_6 79 1 4 0   21     0   9   60 54                       114 79 1 4 0   21     0   9   60 54                 114
738603 738603 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
744747 744747 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2015   grade_6 46 0 1 0   0     0   0   21 26                       47 46 0 1 0   0     0   0   21 26                 47
935289 935289 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No 1 02 06 2016   grade_6 94 2 3 0   11     0   4   57 57                       114 94 2 3 0   11     0   4   57 57                 114
935294 935294 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No 1 02 06 2016   grade_6 123 0 6 0   23     0   4   73 83                       156 123 0 6 0   23     0   4   73 83                 156
936166 936166 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 02 07 2016   grade_6 * * * *   *     *   *   3 *                       3                         3                   3
941572 941572 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No 1 02 06 2016   grade_6 39 0 4 0   1     0   0   23 21                       44 39 0 4 0   1     0   0   23 21                 44
1124818 1124818 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_6 * * * *   *     *   *   5 *                       *                         5                    
1125212 1125212 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2017   grade_6 106 1 4 0   10     0   2   49 74                       123 106 1 4 0   10     0   2   49 74                 123
1125218 1125218 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2017   grade_6 111 3 5 0   18     0   4   71 70                       141 111 3 5 0   18     0   4   71 70                 141
1126251 1126251 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_6 * * * *   *     *   *   4 *                       *                         4                    
1132645 1132645 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2017   grade_6 34 0 1 0   1     0   1   22 15                       37 34 0 1 0   1     0   1   22 15                 37
1365882 1365882 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_6 9 30 18 0   3     0   4   36 28 *                     64.0 9 30 18 0   3     0   4   36 28                 64
1366218 1366218 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_6 1 4 0 0   0     0   1   4 2 *                     6.0 1 4 0 0   0     0   1   4 2                 6
1367524 1367524 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2020   grade_6 83 2 8 1   6     0   4   65 39 *                     104.0 83 2 8 1   6     0   4   65 39                 104
1367529 1367529 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2020   grade_6 108 2 10 0   20     0   1   68 73 *                     141.0 108 2 10 0   20     0   1   68 73                 141
1367686 1367686 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_6 * * * *   *     *   *   1 * *                     1.0                         1                   1
1373810 1373810 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2020   grade_6 27 0 3 0   0     0   0   16 14 *                     30.0 27 0 3 0   0     0   0   16 14                 30
1673119 1673119 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_6 14 26 18 0   7     0   0   31 34 *                     65.0 14 26 18 0   7     0   0   31 34                 65
1674774 1674774 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton - North Street Elementary School   Regular School No Elementary 02 06 2021   grade_6 114 0 10 0   13     0   6   74 69 *                     143.0 114 0 10 0   13     0   6   74 69                 143
1674779 1674779 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton - Millbury Street Elementary School   Regular School No Elementary 02 06 2021   grade_6 98 0 15 0   29     0   1   76 67 *                     143.0 98 0 15 0   29     0   1   76 67                 143
1674936 1674936 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 Haverhill - TEACH   Regular School No Other 02 11 2021   grade_6 * * * *   *     *   *   2 3 *                     5.0                         2 3                 5
2040879 2040879 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_6 2 25 25 0   0     0   1   35 18                       53.0 2 25 25 0   0     0   1   35 18                 53
2040926 2040926 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_6 17 21 25 0   3     0   0   34 32                       66.0 17 21 25 0   3     0   0   34 32                 66
2042596 2042596 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 North Street Elementary School   Regular School No Elementary 02 06 2019   grade_6 94 1 7 0   14     0   4   69 51                       120.0 94 1 7 0   14     0   4   69 51                 120
2042601 2042601 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2019   grade_6 116 4 9 0   12     0   6   81 66                       147.0 116 4 9 0   12     0   6   81 66                 147
2043453 2043453 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_6 3 0 3 0   0     0   0   6 *                       6.0 3 0 3 0   0     0   0   6                   6
2048876 2048876 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2019   grade_6 28 2 0 0   0     0   0   11 19                       30.0 28 2 0 0   0     0   0   11 19                 30
2230055 2230055 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_6 10 33 11 0   5     0   3   32 30                       62.0 10 33 11 0   5     0   3   32 30                 62
2230482 2230482 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton: Huntington Therapeutic Day School   Alternative School No Other 02 12 2018   grade_6 2 3 0 0   0     0   1   5 1                       6.0 2 3 0 0   0     0   1   5 1                 6
2232041 2232041 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton: North Street Elementary School   Regular School No Elementary 02 06 2018   grade_6 89 1 6 2   7     2   3   63 47                       110.0 89 1 6 2   7     2   3   63 47                 110
2232047 2232047 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton: Millbury Street Elementary School   Regular School No Elementary 02 06 2018   grade_6 93 3 8 0   22     0   3   67 62                       129.0 93 3 8 0   22     0   3   67 62                 129
2239469 2239469 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Quabbin: Oakham Center   Regular School No Elementary 02 06 2018   grade_6 26 0 0 0   0     0   0   13 13                       26.0 26 0 0 0   0     0   0   13 13                 26
736561 736561 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_6 21 25 49 0   11     0   9   68 47                       115 21 25 49 0   11     0   9   68 47                 115
736990 736990 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2015   grade_6 102 1 2 0   7     1   1   56 58                       114 102 1 2 0   7     1   1   56 58                 114
737852 737852 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No 1 03 06 2015   grade_6 173 3 0 1   3     0   5   85 100                       185 173 3 0 1   3     0   5   85 100                 185
738878 738878 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No 1 03 06 2015   grade_6 168 2 0 0   2     0   0   82 90                       172 168 2 0 0   2     0   0   82 90                 172
738907 738907 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2015   grade_6 1 1 88 0   3     0   0   53 40                       93 1 1 88 0   3     0   0   53 40                 93
739730 739730 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2015   grade_6 125 5 5 8   4     0   2   67 82                       149 125 5 5 8   4     0   2   67 82                 149
739942 739942 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No 1 03 06 2015   grade_6 114 1 6 0   6     0   1   66 62                       128 114 1 6 0   6     0   1   66 62                 128
740422 740422 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No 1 03 06 2015   grade_6 123 3 0 0   0     0   9   71 64                       135 123 3 0 0   0     0   9   71 64                 135
740742 740742 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No 1 03 06 2015   grade_6 65 2 12 0   3     0   3   43 42                       85 65 2 12 0   3     0   3   43 42                 85
742552 742552 MA Worcester   school 2512240 316   Webster 251224002298 3160305 Webster Middle School   Regular School No 1 03 06 2015   grade_6 106 11 29 0   2     1   7   78 78                       156 106 11 29 0   2     1   7   78 78                 156
744672 744672 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Helen R Donaghue School   Regular School No 1 03 06 2015   grade_6 86 1 1 0   0     0   4   41 51                       92 86 1 1 0   0     0   4   41 51                 92
933430 933430 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2016   grade_6 26 35 60 0   3     0   4   74 54                       128 26 35 60 0   3     0   4   74 54                 128
933855 933855 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No 1 03 06 2016   grade_6 100 1 1 0   5     0   2   55 54                       109 100 1 1 0   5     0   2   55 54                 109
934706 934706 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No 1 03 06 2016   grade_6 185 2 1 1   0     0   1   87 103                       190 185 2 1 1   0     0   1   87 103                 190
935727 935727 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No 1 03 06 2016   grade_6 163 5 2 0   2     0   1   98 75                       173 163 5 2 0   2     0   1   98 75                 173
935756 935756 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2016   grade_6 4 2 72 0   0     0   0   42 36                       78 4 2 72 0   0     0   0   42 36                 78
936574 936574 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No 1 03 06 2016   grade_6 109 5 4 8   2     0   3   72 59                       131 109 5 4 8   2     0   3   72 59                 131
936786 936786 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No 1 03 06 2016   grade_6 90 0 5 0   3     0   3   45 56                       101 90 0 5 0   3     0   3   45 56                 101
937257 937257 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No 1 03 06 2016   grade_6 125 0 3 0   2     0   2   64 68                       132 125 0 3 0   2     0   2   64 68                 132
937570 937570 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No 1 03 06 2016   grade_6 79 2 4 0   1     0   7   37 56                       93 79 2 4 0   1     0   7   37 56                 93
938217 938217 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No 1 03 06 2016   grade_6 212 3 2 2   5     0   1   122 103                       225 212 3 2 2   5     0   1   122 103                 225
939598 939598 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No 1 03 06 2016   grade_6 116 0 4 0   2     0   5   70 57                       127 116 0 4 0   2     0   5   70 57                 127
941495 941495 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Helen R Donaghue School   Regular School No 1 03 06 2016   grade_6 68 0 6 0   2     0   3   47 32                       79 68 0 6 0   2     0   3   47 32                 79
941646 941646 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No 1 03 06 2016   grade_6 107 4 2 0   0     0   2   56 59                       115 107 4 2 0   0     0   2   56 59                 115
1123008 1123008 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Elementary 03 08 2017   grade_6 39 23 48 0   9     2   2   76 47                       123 39 23 48 0   9     2   2   76 47                 123
1123250 1123250 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_6 12 17 15 0   7     0   1   31 21                       52 12 17 15 0   7     0   1   31 21                 52
1123492 1123492 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2017   grade_6 116 1 6 0   3     1   4   73 58                       131 116 1 6 0   3     1   4   73 58                 131
1124500 1124500 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W Mitchell   Regular School No Elementary 03 06 2017   grade_6 170 6 3 1   3     0   4   90 96                       187 170 6 3 1   3     0   4   90 96                 187
1125744 1125744 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2017   grade_6 145 3 2 0   2     0   1   82 71                       153 145 3 2 0   2     0   1   82 71                 153
1125781 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
1126742 1126742 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2017   grade_6 106 5 2 13   5     0   6   60 77                       137 106 5 2 13   5     0   6   60 77                 137
1126995 1126995 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2017   grade_6 93 1 7 0   5     0   3   57 52                       109 93 1 7 0   5     0   3   57 52                 109
1127554 1127554 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No Elementary 03 06 2017   grade_6 109 3 5 0   1     0   1   64 55                       119 109 3 5 0   1     0   1   64 55                 119
1127927 1127927 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No Elementary 03 06 2017   grade_6 74 1 5 0   0     0   0   43 37                       80 74 1 5 0   0     0   0   43 37                 80
1128698 1128698 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Oak Ridge   Regular School No Elementary 03 06 2017   grade_6 223 1 1 4   6     0   1   118 118                       236 223 1 1 4   6     0   1   118 118                 236
1130351 1130351 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2017   grade_6 103 1 3 0   1     0   5   62 51                       113 103 1 3 0   1     0   5   62 51                 113
1132557 1132557 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Helen R Donaghue School   Regular School No Elementary 03 06 2017   grade_6 61 0 2 0   0     0   3   43 23                       66 61 0 2 0   0     0   3   43 23                 66
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
1365667 1365667 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2020   grade_6 30 35 49 0   8     0   8   71 59 *                     130.0 30 35 49 0   8     0   8   71 59                 130

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