enrollments

Data source: Big Local News · About: Big Local

577 rows where grade = "grade_6", state = "MA" and year = 2017 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 577 ✖

grade ✖

  • grade_6 · 577 ✖
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
1122675 1122675 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2017   grade_6 * * * *   *     *   *   2 2                       *                         2 2                  
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                    
1124926 1124926 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_6 * * * *   *     *   *   2 2                       *                         2 2                  
1125192 1125192 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_6 * * * *   *     *   *   * *                       *                                              
1125266 1125266 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_6 * * * *   *     *   *   * *                       *                                              
1125424 1125424 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_6 * * * *   *     *   *   4 1                       *                         4 1                  
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                    
1126511 1126511 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other 06 12 2017   grade_6 * * * *   *     *   *   2 1                       *                         2 1                  
1129008 1129008 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_6 * * * *   *     *   *   1 *                       *                         1                    
1130462 1130462 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 05 08 2017   grade_6 * * * *   *     *   *   2 1                       *                         2 1                  
1131923 1131923 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_6 * * * *   *     *   *   1 *                       *                         1                    
1132002 1132002 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_6 * * * *   *     *   *   1 3                       *                         1 3                  
1132399 1132399 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2017   grade_6 10 0 0 0   0     0   0   3 7                       10 10 0 0 0   0     0   0   3 7                 10
1131365 1131365 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes Other 05 12 2017   grade_6 52 23 22 0   1     0   2   58 42                       100 52 23 22 0   1     0   2   58 42                 100
1131619 1131619 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_6 80 5 7 0   4     0   4   54 46                       100 80 5 7 0   4     0   4   54 46                 100
1124651 1124651 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2017   grade_6 32 22 41 0   4     0   2   54 47                       101 32 22 41 0   4     0   2   54 47                 101
1126136 1126136 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2017   grade_6 89 0 4 0   6     0   2   62 39                       101 89 0 4 0   6     0   2   62 39                 101
1124641 1124641 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2017   grade_6 28 19 43 2   7     0   3   48 54                       102 28 19 43 2   7     0   3   48 54                 102
1133163 1133163 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   grade_6 79 8 6 0   3     1   5   57 45                       102 79 8 6 0   3     1   5   57 45                 102
1122711 1122711 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2017   grade_6 14 1 86 0   1     0   1   45 58                       103 14 1 86 0   1     0   1   45 58                 103
1126577 1126577 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2017   grade_6 43 15 20 1   21     0   3   52 51                       103 43 15 20 1   21     0   3   52 51                 103
1123001 1123001 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2017   grade_6 3 44 51 0   2     1   3   57 47                       104 3 44 51 0   2     1   3   57 47                 104
1131243 1131243 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes Other 05 12 2017   grade_6 85 2 6 0   6     0   5   60 44                       104 85 2 6 0   6     0   5   60 44                 104
1124419 1124419 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2017   grade_6 92 0 9 0   3     0   1   50 55                       105 92 0 9 0   3     0   1   50 55                 105
1133178 1133178 MA Plymouth   school 2500559 3513   New Heights Charter of Brockton 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 08 2017   grade_6 1 92 10 0   0     0   2   55 50                       105 1 92 10 0   0     0   2   55 50                 105
1127045 1127045 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2017   grade_6 93 1 10 0   0     0   3   54 53                       107 93 1 10 0   0     0   3   54 53                 107
1129330 1129330 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No Other 06 12 2017   grade_6 22 24 60 0   1     0   0   55 52                       107 22 24 60 0   1     0   0   55 52                 107
1123620 1123620 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_6 19 66 12 0   0     1   10   47 61                       108 19 66 12 0   0     1   10   47 61                 108
1122628 1122628 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2017   grade_6 20 19 59 0   7     0   4   42 67                       109 20 19 59 0   7     0   4   42 67                 109
1124537 1124537 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2017   grade_6 88 4 13 0   3     0   1   60 49                       109 88 4 13 0   3     0   1   60 49                 109
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
1129381 1129381 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2017   grade_6 12 29 60 0   5     1   2   48 61                       109 12 29 60 0   5     1   2   48 61                 109
1131676 1131676 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science   Regular School Yes Other 06 12 2017   grade_6 50 27 30 0   1     0   1   59 50                       109 50 27 30 0   1     0   1   59 50                 109
1132516 1132516 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2017   grade_6 106 0 1 0   0     0   2   49 60                       109 106 0 1 0   0     0   2   49 60                 109
1132093 1132093 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2017   grade_6 11 0 0 0   0     0   0   3 8                       11 11 0 0 0   0     0   0   3 8                 11
1132414 1132414 MA Franklin   school 2507990 717   Mohawk Trail 250799001636 7170020 Sanderson Academy   Regular School No Elementary PK 06 2017   grade_6 11 0 0 0   0     0   0   7 4                       11 11 0 0 0   0     0   0   7 4                 11
1132612 1132612 MA Franklin   school 2509600 750   Pioneer Valley 250960002615 7500009 Warwick Community School   Regular School No Elementary KG 06 2017   grade_6 11 0 0 0   0     0   0   2 9                       11 11 0 0 0   0     0   0   2 9                 11
1130946 1130946 MA Worcester   school 2513230 348   Worcester 251323002241 3480210 Quinsigamond   Regular School No Elementary PK 06 2017   grade_6 25 21 50 0   7     0   7   53 57                       110 25 21 50 0   7     0   7   53 57                 110
1131346 1131346 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_6 54 35 4 1   7     0   9   58 52                       110 54 35 4 1   7     0   9   58 52                 110
1125129 1125129 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2017   grade_6 107 2 0 0   1     0   1   61 50                       111 107 2 0 0   1     0   1   61 50                 111
1129377 1129377 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No Middle 06 08 2017   grade_6 4 17 90 0   0     0   0   50 61                       111 4 17 90 0   0     0   0   50 61                 111
1131966 1131966 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2017   grade_6 102 1 3 0   1     0   4   52 59                       111 102 1 3 0   1     0   4   52 59                 111
1124670 1124670 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2017   grade_6 37 22 48 1   1     0   4   48 65                       113 37 22 48 1   1     0   4   48 65                 113
1126124 1126124 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2017   grade_6 85 5 7 0   14     0   2   60 53                       113 85 5 7 0   14     0   2   60 53                 113
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
1122792 1122792 MA Suffolk   school 2502790 35   Boston 250279000254 350146 James Condon Elementary   Regular School No Elementary PK 07 2017   grade_6 24 37 36 0   16     1   1   56 59                       115 24 37 36 0   16     1   1   56 59                 115
1125869 1125869 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2017   grade_6 7 1 103 0   3     0   1   71 44                       115 7 1 103 0   3     0   1   71 44                 115
1125439 1125439 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2017   grade_6 79 4 33 0   2     0   0   53 65                       118 79 4 33 0   2     0   0   53 65                 118
1124100 1124100 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2017   grade_6 11 6 96 2   2     0   2   67 52                       119 11 6 96 2   2     0   2   67 52                 119
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
1124614 1124614 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2017   grade_6 11 0 1 0   0     0   0   6 6                       12 11 0 1 0   0     0   0   6 6                 12
1132730 1132730 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302847 7660215 Granville Village School   Regular School No Elementary KG 06 2017   grade_6 12 0 0 0   0     0   0   5 7                       12 12 0 0 0   0     0   0   5 7                 12
1122115 1122115 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2017   grade_6 72 3 9 0   32     0   4   50 70                       120 72 3 9 0   32     0   4   50 70                 120
1125921 1125921 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 06 08 2017   grade_6 95 5 12 0   2     0   6   54 66                       120 95 5 12 0   2     0   6   54 66                 120
1126338 1126338 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2017   grade_6 104 2 10 0   2     0   2   72 48                       120 104 2 10 0   2     0   2   72 48                 120
1127128 1127128 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No Middle 06 08 2017   grade_6 68 12 33 0   1     0   6   59 61                       120 68 12 33 0   1     0   6   59 61                 120
1129392 1129392 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Van Sickle Academy   Regular School No Middle 06 08 2017   grade_6 9 17 90 0   2     0   2   60 60                       120 9 17 90 0   2     0   2   60 60                 120
1121973 1121973 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_6 119 0 1 0   0     0   1   61 60                       121 119 0 1 0   0     0   1   61 60                 121
1122241 1122241 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2017   grade_6 79 3 25 1   3     0   12   66 57                       123 79 3 25 1   3     0   12   66 57                 123
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
1124225 1124225 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_6 93 5 24 0   1     0   0   74 49                       123 93 5 24 0   1     0   0   74 49                 123
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
1125807 1125807 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2017   grade_6 4 4 114 0   0     0   1   66 57                       123 4 4 114 0   0     0   1   66 57                 123
1126932 1126932 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2017   grade_6 57 1 49 0   8     0   8   58 65                       123 57 1 49 0   8     0   8   58 65                 123
1132306 1132306 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2017   grade_6 121 0 0 0   1     0   1   71 52                       123 121 0 0 0   1     0   1   71 52                 123
1125412 1125412 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2017   grade_6 66 5 48 0   4     0   1   68 56                       124 66 5 48 0   4     0   1   68 56                 124
1131214 1131214 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2017   grade_6 8 23 88 0   2     0   3   74 50                       124 8 23 88 0   2     0   3   74 50                 124
1125829 1125829 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2017   grade_6 3 1 121 0   0     0   0   63 62                       125 3 1 121 0   0     0   0   63 62                 125
1129396 1129396 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle International Baccalaureate   Regular School No Middle 06 08 2017   grade_6 16 13 92 0   3     0   1   74 51                       125 16 13 92 0   3     0   1   74 51                 125
1132527 1132527 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2017   grade_6 114 0 5 0   4     0   2   70 55                       125 114 0 5 0   4     0   2   70 55                 125
1126101 1126101 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2017   grade_6 113 0 1 1   7     0   4   64 62                       126 113 0 1 1   7     0   4   64 62                 126
1129528 1129528 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2017   grade_6 109 0 6 0   2     0   9   70 56                       126 109 0 6 0   2     0   9   70 56                 126
1131487 1131487 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2017   grade_6 73 14 13 0   24     0   2   68 58                       126 73 14 13 0   24     0   2   68 58                 126
1129790 1129790 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 McCloskey Middle School   Regular School No Middle 06 08 2017   grade_6 115 3 6 0   2     0   1   73 54                       127 115 3 6 0   2     0   1   73 54                 127
1131332 1131332 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 2017   grade_6 29 63 26 0   3     0   6   65 62                       127 29 63 26 0   3     0   6   65 62                 127
1128364 1128364 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2017   grade_6 84 12 7 1   20     0   4   61 67                       128 84 12 7 1   20     0   4   61 67                 128
1131307 1131307 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   grade_6 26 35 52 0   7     0   8   67 61                       128 26 35 52 0   7     0   8   67 61                 128
1125282 1125282 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Elementary 04 07 2017   grade_6 96 1 24 0   1     0   7   66 63                       129 96 1 24 0   1     0   7   66 63                 129
1127972 1127972 MA Hampden   school 2509300 227   Palmer 250930002595 2270305 Converse Middle   Regular School No Middle 06 07 2017   grade_6 105 3 12 0   0     0   9   77 52                       129 105 3 12 0   0     0   9   77 52                 129
1128905 1128905 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2017   grade_6 10 0 1 0   0     0   2   6 7                       13 10 0 1 0   0     0   2   6 7                 13
1126589 1126589 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2017   grade_6 35 29 39 1   25     0   1   65 65                       130 35 29 39 1   25     0   1   65 65                 130
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
1132222 1132222 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2017   grade_6 122 0 2 0   4     1   2   60 71                       131 122 0 2 0   4     1   2   60 71                 131
1126266 1126266 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2017   grade_6 43 9 41 0   32     0   7   70 62                       132 43 9 41 0   32     0   7   70 62                 132
1129581 1129581 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2017   grade_6 119 1 3 0   4     0   5   72 60                       132 119 1 3 0   4     0   5   72 60                 132
1123413 1123413 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_6 4 69 47 0   8     1   4   84 49                       133 4 69 47 0   8     1   4   84 49                 133
1123367 1123367 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   grade_6 8 20 19 0   82     0   5   71 63                       134 8 20 19 0   82     0   5   71 63                 134
1125728 1125728 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2017   grade_6 114 1 8 0   2     0   9   66 68                       134 114 1 8 0   2     0   9   66 68                 134
1129776 1129776 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2017   grade_6 116 1 4 0   11     0   3   69 66                       135 116 1 4 0   11     0   3   69 66                 135
1122845 1122845 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2017   grade_6 7 50 65 0   11     0   3   73 63                       136 7 50 65 0   11     0   3   73 63                 136
1129694 1129694 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 John F Parker Middle   Regular School No Middle 05 07 2017   grade_6 77 32 14 1   1     0   11   62 74                       136 77 32 14 1   1     0   11   62 74                 136
1132963 1132963 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 06 08 2017   grade_6 129 1 5 0   0     0   1   84 52                       136 129 1 5 0   0     0   1   84 52                 136
1125085 1125085 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2017   grade_6 119 3 5 0   9     0   1   62 75                       137 119 3 5 0   9     0   1   62 75                 137
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
1127028 1127028 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No Elementary 04 06 2017   grade_6 121 2 10 0   2     0   2   58 79                       137 121 2 10 0   2     0   2   58 79                 137
1132896 1132896 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2017   grade_6 120 0 3 0   5     0   9   77 60                       137 120 0 3 0   5     0   9   77 60                 137
1123235 1123235 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2017   grade_6 0 52 60 0   21     0   6   75 64                       139 0 52 60 0   21     0   6   75 64                 139
1126281 1126281 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No Middle 05 08 2017   grade_6 35 16 57 0   27     0   4   81 58                       139 35 16 57 0   27     0   4   81 58                 139
1129078 1129078 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2017   grade_6 107 2 22 0   0     0   8   63 76                       139 107 2 22 0   0     0   8   63 76                 139
1126010 1126010 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2017   grade_6 11 0 0 0   2     0   1   8 6                       14 11 0 0 0   2     0   1   8 6                 14

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