enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1367601 1367601 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2020   grade_6 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
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
1368368 1368368 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_6 * * * *   *     *   *   5 * *                     5.0                         5                   5
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
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
1371352 1371352 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2020   grade_6 * * * *   *     *   *   2 3 *                     5.0                         2 3                 5
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
1374313 1374313 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1365739 1365739 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2020   grade_6 0 8 36 0   0     0   0   23 21 *                     44.0 0 8 36 0   0     0   0   23 21                 44
1365802 1365802 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   grade_6 0 21 14 0   0     0   1   17 19 *                     36.0 0 21 14 0   0     0   1   17 19                 36
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
1368018 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
1368061 1368061 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_6 0 0 9 0   0     0   0   8 1 *                     9.0 0 0 9 0   0     0   0   8 1                 9
1372503 1372503 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 08 2020   grade_6 0 22 12 0   0     0   0   15 19 *                     34.0 0 22 12 0   0     0   0   15 19                 34
1372519 1372519 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2020   grade_6 0 36 2 0   0     0   0   19 19 *                     38.0 0 36 2 0   0     0   0   19 19                 38
1372531 1372531 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 08 2020   grade_6 0 1 34 0   0     0   0   23 12 *                     35.0 0 1 34 0   0     0   0   23 12                 35
1372606 1372606 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2020   grade_6 0 16 4 0   0     0   0   12 8 *                     20.0 0 16 4 0   0     0   0   12 8                 20
1372620 1372620 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2020   grade_6 0 28 10 0   1     0   1   19 21 *                     40.0 0 28 10 0   1     0   1   19 21                 40
1372630 1372630 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2020   grade_6 0 0 43 0   0     0   0   20 23 *                     43.0 0 0 43 0   0     0   0   20 23                 43
1372763 1372763 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2020   grade_6 0 46 16 0   0     0   0   32 30 *                     62.0 0 46 16 0   0     0   0   32 30                 62
1365610 1365610 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2020   grade_6 1 19 29 0   3     0   0   32 20 *                     52.0 1 19 29 0   3     0   0   32 20                 52
1365829 1365829 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2020   grade_6 1 34 15 0   1     0   1   24 28 *                     52.0 1 34 15 0   1     0   1   24 28                 52
1365835 1365835 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 03 08 2020   grade_6 1 25 15 0   1     0   4   19 27 *                     46.0 1 25 15 0   1     0   4   19 27                 46
1365845 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
1365855 1365855 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_6 1 45 26 0   0     0   2   38 36 *                     74.0 1 45 26 0   0     0   2   38 36                 74
1366039 1366039 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2020   grade_6 1 0 30 0   0     0   1   13 19 *                     32.0 1 0 30 0   0     0   1   13 19                 32
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
1368001 1368001 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2020   grade_6 1 3 135 0   1     0   0   86 54 *                     140.0 1 3 135 0   1     0   0   86 54                 140
1371011 1371011 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2020   grade_6 1 4 9 0   0     0   0   13 1 *                     14.0 1 4 9 0   0     0   0   13 1                 14
1372731 1372731 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2020   grade_6 1 0 75 0   0     0   0   42 34 *                     76.0 1 0 75 0   0     0   0   42 34                 76
1372840 1372840 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2020   grade_6 1 51 19 0   1     0   5   34 43 *                     77.0 1 51 19 0   1     0   5   34 43                 77
1374217 1374217 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2020   grade_6 1 44 37 0   1     1   1   50 35 *                     85.0 1 44 37 0   1     1   1   50 35                 85
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
1374258 1374258 MA Hampden   school 2500586 3514   Libertas Charter School (District) 250058602878 35140305 Libertas Academy Charter School   Regular School Yes Middle 06 08 2020   grade_6 1 14 71 0   1     1   2   46 44 *                     90.0 1 14 71 0   1     1   2   46 44                 90
1368378 1368378 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2020   grade_6 10 1 22 0   19     0   4   26 30 *                     56.0 10 1 22 0   19     0   4   26 30                 56
1370097 1370097 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_6 10 2 2 0   0     0   3   9 8 *                     17.0 10 2 2 0   0     0   3   9 8                 17
1371014 1371014 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2020   grade_6 10 22 55 0   3     0   1   54 37 *                     91.0 10 22 55 0   3     0   1   54 37                 91
1371031 1371031 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2020   grade_6 10 5 37 0   0     0   2   15 39 *                     54.0 10 5 37 0   0     0   2   15 39                 54
1372138 1372138 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2020   grade_6 10 3 12 0   2     0   1   16 12 *                     28.0 10 3 12 0   2     0   1   16 12                 28
1372145 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
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
1369334 1369334 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2020   grade_6 101 43 128 1   0     1   14   146 142 *                     288.0 101 43 128 1   0     1   14   146 142                 288
1370423 1370423 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2020   grade_6 101 17 96 0   8     0   10   117 115 *                     232.0 101 17 96 0   8     0   10   117 115                 232
1371784 1371784 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2020   grade_6 101 3 7 1   48     0   7   80 87 *                     167.0 101 3 7 1   48     0   7   80 87                 167
1372113 1372113 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2020   grade_6 101 18 13 0   15     2   7   77 79 *                     156.0 101 18 13 0   15     2   7   77 79                 156
1367567 1367567 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Middle 05 07 2020   grade_6 102 3 22 0   1     0   9   67 70 *                     137.0 102 3 22 0   1     0   9   67 70                 137
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
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
1373107 1373107 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2020   grade_6 102 8 22 0   4     0   4   72 68 *                     140.0 102 8 22 0   4     0   4   72 68                 140
1373564 1373564 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2020   grade_6 102 8 9 2   2     0   13   65 71 *                     136.0 102 8 9 2   2     0   13   65 71                 136
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
1371500 1371500 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2020   grade_6 103 18 47 0   10     0   6   103 81 *                     184.0 103 18 47 0   10     0   6   103 81                 184
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
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
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
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
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
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
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
1365029 1365029 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2020   grade_6 108 8 27 0   6     0   8   86 71 *                     157.0 108 8 27 0   6     0   8   86 71                 157
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
1369997 1369997 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2020   grade_6 108 17 28 1   2     0   21   98 79 *                     177.0 108 17 28 1   2     0   21   98 79                 177
1371450 1371450 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2020   grade_6 108 2 7 0   23     0   6   80 66 *                     146.0 108 2 7 0   23     0   6   80 66                 146
1371565 1371565 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No Middle 06 08 2020   grade_6 109 5 51 0   20     0   8   105 88 *                     193.0 109 5 51 0   20     0   8   105 88                 193
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
1366595 1366595 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2020   grade_6 11 6 171 1   1     1   2   99 94 *                     193.0 11 6 171 1   1     1   2   99 94                 193
1366599 1366599 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2020   grade_6 11 9 136 0   0     0   2   91 67 *                     158.0 11 9 136 0   0     0   2   91 67                 158
1368052 1368052 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2020   grade_6 11 3 117 0   2     0   5   78 60 *                     138.0 11 3 117 0   2     0   5   78 60                 138
1370331 1370331 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2020   grade_6 11 0 2 0   0     0   1   4 10 *                     14.0 11 0 2 0   0     0   1   4 10                 14
1370654 1370654 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2020   grade_6 11 7 29 0   1     0   2   29 21 *                     50.0 11 7 29 0   1     0   2   29 21                 50
1370702 1370702 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2020   grade_6 11 8 24 0   6     0   1   31 19 *                     50.0 11 8 24 0   6     0   1   31 19                 50
1371002 1371002 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No Middle 06 08 2020   grade_6 11 59 142 0   13     0   6   132 99 *                     231.0 11 59 142 0   13     0   6   132 99                 231
1372175 1372175 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_6 11 3 59 0   0     0   1   34 40 *                     74.0 11 3 59 0   0     0   1   34 40                 74
1372213 1372213 MA Worcester   school 2513230 348   Worcester 251323002211 3480095 Elm Park Community   Regular School No Elementary KG 06 2020   grade_6 11 12 28 0   1     0   2   29 25 *                     54.0 11 12 28 0   1     0   2   29 25                 54
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
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
1369461 1369461 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2020   grade_6 110 6 11 0   27     0   8   72 89 *                     162.0 110 6 11 0   27     0   8   72 89                 162
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
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
1365021 1365021 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2020   grade_6 111 16 9 2   10     0   14   82 80 *                     162.0 111 16 9 2   10     0   14   82 80                 162
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
1370539 1370539 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2020   grade_6 111 4 11 0   13     0   5   72 72 *                     144.0 111 4 11 0   13     0   5   72 72                 144
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
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
1368239 1368239 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2020   grade_6 113 3 4 0   20     0   3   69 74 *                     143.0 113 3 4 0   20     0   3   69 74                 143
1373163 1373163 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2020   grade_6 113 3 11 0   2     0   7   61 75 *                     136.0 113 3 11 0   2     0   7   61 75                 136
1367660 1367660 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2020   grade_6 114 12 43 1   3     0   1   90 84 *                     174.0 114 12 43 1   3     0   1   90 84                 174
1371360 1371360 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2020   grade_6 114 12 5 0   14     0   5   82 68 *                     150.0 114 12 5 0   14     0   5   82 68                 150
1373638 1373638 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 06 08 2020   grade_6 116 2 8 1   2     0   6   77 58 *                     135.0 116 2 8 1   2     0   6   77 58                 135
1367190 1367190 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2020   grade_6 117 16 53 1   9     0   18   122 92 *                     214.0 117 16 53 1   9     0   18   122 92                 214
1369651 1369651 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2020   grade_6 117 4 11 0   21     1   5   78 81 *                     159.0 117 4 11 0   21     1   5   78 81                 159
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
1368205 1368205 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2020   grade_6 118 13 9 0   134     0   26   148 152 *                     300.0 118 13 9 0   134     0   26   148 152                 300
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
1373285 1373285 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2020   grade_6 119 7 14 0   28     0   16   93 91 *                     184.0 119 7 14 0   28     0   16   93 91                 184
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
1366394 1366394 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2020   grade_6 12 4 20 0   2     0   4   22 20 *                     42.0 12 4 20 0   2     0   4   22 20                 42
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
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
1372152 1372152 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2020   grade_6 12 12 15 0   1     0   3   21 22 *                     43.0 12 12 15 0   1     0   3   21 22                 43

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