enrollments

Data source: Big Local News · About: Big Local

572 rows where grade = "grade_6", state = "MA" and year = 2020 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 572 ✖

grade ✖

  • grade_6 · 572 ✖
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
1368463 1368463 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1374313 1374313 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
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
1370705 1370705 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2020   grade_6 * * * *   *     *   *   1 * *                     1.0                         1                   1
1373609 1373609 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2020   grade_6 7 0 3 0   0     0   0   7 3 *                     10.0 7 0 3 0   0     0   0   7 3                 10
1366961 1366961 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2020   grade_6 78 2 13 0   7     0   0   59 41 *                     100.0 78 2 13 0   7     0   0   59 41                 100
1372581 1372581 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_6 75 3 10 1   7     0   4   45 55 *                     100.0 75 3 10 1   7     0   4   45 55                 100
1364806 1364806 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_6 97 1 2 0   1     0   0   57 44 *                     101.0 97 1 2 0   1     0   0   57 44                 101
1365385 1365385 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2020   grade_6 3 52 42 0   1     0   3   50 51 *                     101.0 3 52 42 0   1     0   3   50 51                 101
1367085 1367085 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2020   grade_6 12 16 69 0   3     0   1   49 52 *                     101.0 12 16 69 0   3     0   1   49 52                 101
1371517 1371517 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Middle 04 06 2020   grade_6 88 2 8 0   0     0   3   55 46 *                     101.0 88 2 8 0   0     0   3   55 46                 101
1365896 1365896 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2020   grade_6 5 31 60 0   1     0   5   44 58 *                     102.0 5 31 60 0   1     0   5   44 58                 102
1366282 1366282 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2020   grade_6 64 1 14 0   13     0   10   53 48 *                     102.0 64 1 14 0   13     0   10   53 48                 102
1366476 1366476 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Vassal Lane Upper School   Regular School No Middle 06 08 2020   grade_6 45 28 7 0   15     0   7   55 47 *                     102.0 45 28 7 0   15     0   7   55 47                 102
1372695 1372695 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2020   grade_6 44 30 21 0   5     0   2   51 51 *                     102.0 44 30 21 0   5     0   2   51 51                 102
1365409 1365409 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2020   grade_6 11 2 88 0   1     0   1   53 50 *                     103.0 11 2 88 0   1     0   1   53 50                 103
1366328 1366328 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2020   grade_6 58 3 11 0   19     0   12   47 56 *                     103.0 58 3 11 0   19     0   12   47 56                 103
1365481 1365481 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2020   grade_6 12 33 40 0   13     1   5   46 58 *                     104.0 12 33 40 0   13     1   5   46 58                 104
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
1370985 1370985 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2020   grade_6 14 24 61 0   2     0   3   54 50 *                     104.0 14 24 61 0   2     0   3   54 50                 104
1372560 1372560 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2020   grade_6 77 4 10 0   6     0   7   48 56 *                     104.0 77 4 10 0   6     0   7   48 56                 104
1373037 1373037 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2020   grade_6 97 3 2 0   0     0   2   52 52 *                     104.0 97 3 2 0   0     0   2   52 52                 104
1374252 1374252 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_6 1 89 9 0   0     0   5   49 55 *                     104.0 1 89 9 0   0     0   5   49 55                 104
1370176 1370176 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 South West Middle School   Regular School No Middle 05 08 2020   grade_6 44 18 11 0   22     0   10   63 42 *                     105.0 44 18 11 0   22     0   10   63 42                 105
1366467 1366467 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge Street Upper School   Regular School No Middle 06 08 2020   grade_6 43 27 17 1   7     0   11   62 44 *                     106.0 43 27 17 1   7     0   11   62 44                 106
1367759 1367759 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2020   grade_6 53 16 19 1   4     0   13   55 51 *                     106.0 53 16 19 1   4     0   13   55 51                 106
1366079 1366079 MA Essex   school 2502880 38   Boxford 250288000358 380013 Spofford Pond   Regular School No Elementary 03 06 2020   grade_6 90 1 3 0   6     0   7   56 51 *                     107.0 90 1 3 0   6     0   7   56 51                 107
1370169 1370169 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2020   grade_6 64 13 8 0   19     0   3   50 57 *                     107.0 64 13 8 0   19     0   3   50 57                 107
1371199 1371199 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2020   grade_6 89 1 5 0   2     0   10   53 54 *                     107.0 89 1 5 0   2     0   10   53 54                 107
1373272 1373272 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2020   grade_6 95 2 5 0   1     0   4   62 45 *                     107.0 95 2 5 0   1     0   4   62 45                 107
1369010 1369010 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Howe-Manning   Regular School No Elementary 03 06 2020   grade_6 84 1 10 0   5     0   8   51 57 *                     108.0 84 1 10 0   5     0   8   51 57                 108
1371022 1371022 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2020   grade_6 3 9 95 0   1     0   0   67 41 *                     108.0 3 9 95 0   1     0   0   67 41                 108
1371713 1371713 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No Middle 04 06 2020   grade_6 85 7 2 1   1     1   11   50 58 *                     108.0 85 7 2 1   1     1   11   50 58                 108
1373086 1373086 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2020   grade_6 93 0 11 0   1     0   3   63 45 *                     108.0 93 0 11 0   1     0   3   63 45                 108
1374064 1374064 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2020   grade_6 97 2 4 0   1     0   4   53 55 *                     108.0 97 2 4 0   1     0   4   53 55                 108
1366020 1366020 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2020   grade_6 3 61 40 0   0     0   5   51 58 *                     109.0 3 61 40 0   0     0   5   51 58                 109
1367060 1367060 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2020   grade_6 19 3 83 0   2     0   2   60 49 *                     109.0 19 3 83 0   2     0   2   60 49                 109
1371028 1371028 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2020   grade_6 12 25 65 0   4     0   3   58 51 *                     109.0 12 25 65 0   4     0   3   58 51                 109
1369343 1369343 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2020   grade_6 6 2 2 0   0     0   1   9 2 *                     11.0 6 2 2 0   0     0   1   9 2                 11
1372423 1372423 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_6 10 0 0 0   0     0   1   5 6 *                     11.0 10 0 0 0   0     0   1   5 6                 11
1368258 1368258 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2020   grade_6 81 3 8 0   16     0   2   63 47 *                     110.0 81 3 8 0   16     0   2   63 47                 110
1368288 1368288 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 08 2020   grade_6 24 13 45 0   25     0   3   59 51 *                     110.0 24 13 45 0   25     0   3   59 51                 110
1372918 1372918 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_6 91 2 15 0   2     0   0   51 59 *                     110.0 91 2 15 0   2     0   0   51 59                 110
1373225 1373225 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2020   grade_6 105 0 3 1   0     0   1   55 55 *                     110.0 105 0 3 1   0     0   1   55 55                 110
1372310 1372310 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2020   grade_6 37 20 42 0   8     0   4   57 54 *                     111.0 37 20 42 0   8     0   4   57 54                 111
1372970 1372970 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2020   grade_6 4 19 80 1   3     0   4   49 62 *                     111.0 4 19 80 1   3     0   4   49 62                 111
1369835 1369835 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 06 12 2020   grade_6 93 1 11 0   2     0   6   67 46 *                     113.0 93 1 11 0   2     0   6   67 46                 113
1371038 1371038 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2020   grade_6 8 16 84 0   1     0   4   61 52 *                     113.0 8 16 84 0   1     0   4   61 52                 113
1371828 1371828 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2020   grade_6 102 0 4 0   0     0   7   67 46 *                     113.0 102 0 4 0   0     0   7   67 46                 113
1374008 1374008 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2020   grade_6 96 3 5 0   4     0   5   58 55 *                     113.0 96 3 5 0   4     0   5   58 55                 113
1365190 1365190 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_6 107 0 1 0   0     0   6   59 55 *                     114.0 107 0 1 0   0     0   6   59 55                 114
1368043 1368043 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2020   grade_6 4 0 110 0   0     0   0   53 61 *                     114.0 4 0 110 0   0     0   0   53 61                 114
1373893 1373893 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2020   grade_6 87 4 16 0   2     0   5   61 53 *                     114.0 87 4 16 0   2     0   5   61 53                 114
1370014 1370014 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Beatrice H Wood Elementary   Regular School No Middle 04 06 2020   grade_6 90 2 15 1   4     0   3   55 60 *                     115.0 90 2 15 1   4     0   3   55 60                 115
1367468 1367468 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2020   grade_6 112 1 1 0   0     1   1   59 57 *                     116.0 112 1 1 0   0     1   1   59 57                 116
1365338 1365338 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2020   grade_6 18 22 72 0   1     0   4   71 46 *                     117.0 18 22 72 0   1     0   4   71 46                 117
1365490 1365490 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2020   grade_6 8 29 74 0   3     0   3   55 62 *                     117.0 8 29 74 0   3     0   3   55 62                 117
1369820 1369820 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2020   grade_6 102 2 8 0   1     0   5   65 53 *                     118.0 102 2 8 0   1     0   5   65 53                 118
1373512 1373512 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2020   grade_6 117 0 1 0   0     0   0   61 57 *                     118.0 117 0 1 0   0     0   0   61 57                 118
1374234 1374234 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_6 57 15 40 0   3     1   2   59 59 *                     118.0 57 15 40 0   3     1   2   59 59                 118
1368091 1368091 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 05 08 2020   grade_6 94 8 14 0   1     0   2   70 49 *                     119.0 94 8 14 0   1     0   2   70 49                 119
1372665 1372665 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_6 13 78 22 0   4     0   3   56 64 *                     120.0 13 78 22 0   4     0   3   56 64                 120
1374202 1374202 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_6 17 26 47 0   25     0   5   50 70 *                     120.0 17 26 47 0   25     0   5   50 70                 120
1373872 1373872 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2020   grade_6 104 6 6 0   1     0   4   56 65 *                     121.0 104 6 6 0   1     0   4   56 65                 121
1366528 1366528 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2020   grade_6 111 4 2 1   1     0   3   57 65 *                     122.0 111 4 2 1   1     0   3   57 65                 122
1367432 1367432 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2020   grade_6 107 3 4 1   6     0   1   64 58 *                     122.0 107 3 4 1   6     0   1   64 58                 122
1368800 1368800 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2020   grade_6 97 6 4 8   2     0   6   63 60 *                     123.0 97 6 4 8   2     0   6   63 60                 123
1371374 1371374 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Whitin Intermediate   Regular School No Middle 04 07 2020   grade_6 110 2 7 1   1     0   3   74 50 *                     124.0 110 2 7 1   1     0   3   74 50                 124
1372553 1372553 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2020   grade_6 3 30 81 0   8     0   2   65 59 *                     124.0 3 30 81 0   8     0   2   65 59                 124
1374299 1374299 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_6 76 10 20 0   6     3   9   66 58 *                     124.0 76 10 20 0   6     3   9   66 58                 124
1364922 1364922 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2020   grade_6 69 3 9 0   37     1   6   56 69 *                     125.0 69 3 9 0   37     1   6   56 69                 125
1367946 1367946 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2020   grade_6 106 2 10 0   2     0   5   67 58 *                     125.0 106 2 10 0   2     0   5   67 58                 125
1367857 1367857 MA Hampden   school 2506270 137   Holyoke 250627002895 1370075 Veritas Prep Holyoke   Regular School No Middle 05 06 2020   grade_6 4 7 113 0   1     0   1   68 58 *                     126.0 4 7 113 0   1     0   1   68 58                 126
1373716 1373716 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2020   grade_6 110 2 5 0   1     0   8   71 55 *                     126.0 110 2 5 0   1     0   8   71 55                 126
1366180 1366180 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_6 17 79 22 1   0     0   8   61 66 *                     127.0 17 79 22 1   0     0   8   61 66                 127
1368678 1368678 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2020   grade_6 29 22 53 0   19     0   4   72 55 *                     127.0 29 22 53 0   19     0   4   72 55                 127
1370732 1370732 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No Middle 06 08 2020   grade_6 84 2 10 0   24     0   8   65 63 *                     128.0 84 2 10 0   24     0   8   65 63                 128
1368268 1368268 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2020   grade_6 95 0 6 0   17     2   9   57 72 *                     129.0 95 0 6 0   17     2   9   57 72                 129
1368945 1368945 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2020   grade_6 78 1 42 0   4     0   4   65 64 *                     129.0 78 1 42 0   4     0   4   65 64                 129
1370616 1370616 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2020   grade_6 9 0 1 0   0     0   3   4 9 *                     13.0 9 0 1 0   0     0   3   4 9                 13
1372777 1372777 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2020   grade_6 9 0 2 0   0     0   2   4 9 *                     13.0 9 0 2 0   0     0   2   4 9                 13
1373331 1373331 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_6 13 0 0 0   0     0   0   11 2 *                     13.0 13 0 0 0   0     0   0   11 2                 13
1373617 1373617 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2020   grade_6 11 0 1 0   0     0   1   5 8 *                     13.0 11 0 1 0   0     0   1   5 8                 13
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
1367429 1367429 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2020   grade_6 113 4 7 0   5     0   1   66 64 *                     130.0 113 4 7 0   5     0   1   66 64                 130
1370763 1370763 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2020   grade_6 103 3 20 0   4     0   0   73 57 *                     130.0 103 3 20 0   4     0   0   73 57                 130
1367076 1367076 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2020   grade_6 33 21 65 0   11     0   1   64 67 *                     131.0 33 21 65 0   11     0   1   64 67                 131
1371025 1371025 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2020   grade_6 4 11 115 0   0     0   1   69 62 *                     131.0 4 11 115 0   0     0   1   69 62                 131
1369485 1369485 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Freeman-Kennedy School   Regular School No Elementary 03 06 2020   grade_6 124 1 3 0   1     0   3   73 59 *                     132.0 124 1 3 0   1     0   3   73 59                 132
1372639 1372639 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_6 18 41 54 0   12     0   7   68 64 *                     132.0 18 41 54 0   12     0   7   68 64                 132
1367435 1367435 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2020   grade_6 110 3 5 0   9     2   4   71 62 *                     133.0 110 3 5 0   9     2   4   71 62                 133
1366591 1366591 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2020   grade_6 7 8 113 0   0     0   6   77 57 *                     134.0 7 8 113 0   0     0   6   77 57                 134
1366713 1366713 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset Middle School   Regular School No Middle 06 08 2020   grade_6 128 4 1 0   1     0   0   67 67 *                     134.0 128 4 1 0   1     0   0   67 67                 134
1369036 1369036 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No Middle 04 06 2020   grade_6 105 1 16 0   3     0   9   61 73 *                     134.0 105 1 16 0   3     0   9   61 73                 134
1373707 1373707 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2020   grade_6 123 1 4 0   2     0   4   70 64 *                     134.0 123 1 4 0   2     0   4   70 64                 134
1367668 1367668 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2020   grade_6 54 8 69 0   2     0   2   76 59 *                     135.0 54 8 69 0   2     0   2   76 59                 135
1370257 1370257 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2020   grade_6 128 2 0 0   2     0   3   75 60 *                     135.0 128 2 0 0   2     0   3   75 60                 135
1371155 1371155 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2020   grade_6 119 2 8 1   2     0   3   81 54 *                     135.0 119 2 8 1   2     0   3   81 54                 135
1372830 1372830 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2020   grade_6 5 51 67 0   12     0   0   79 56 *                     135.0 5 51 67 0   12     0   0   79 56                 135
1373305 1373305 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2020   grade_6 107 5 15 0   2     0   6   60 75 *                     135.0 107 5 15 0   2     0   6   60 75                 135

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