enrollments

Data source: Big Local News · About: Big Local

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

✎ 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                  
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
1122107 1122107 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2017   grade_6 164 0 5 2   27     0   6   99 105                       204 164 0 5 2   27     0   6   99 105                 204
1122872 1122872 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_6 6 0 26 0   0     0   1   14 19                       33 6 0 26 0   0     0   1   14 19                 33
1123438 1123438 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2017   grade_6 0 0 31 0   0     0   0   9 22                       31 0 0 31 0   0     0   0   9 22                 31
1123720 1123720 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2017   grade_6 44 0 3 0   0     0   1   22 26                       48 44 0 3 0   0     0   1   22 26                 48
1124213 1124213 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_6 16 0 0 0   0     0   0   7 9                       16 16 0 0 0   0     0   0   7 9                 16
1124286 1124286 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2017   grade_6 26 0 0 0   0     0   0   14 12                       26 26 0 0 0   0     0   0   14 12                 26
1124408 1124408 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2017   grade_6 57 0 2 0   1     0   0   30 30                       60 57 0 2 0   1     0   0   30 30                 60
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
1124483 1124483 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2017   grade_6 229 0 3 0   2     0   9   135 108                       243 229 0 3 0   2     0   9   135 108                 243
1124603 1124603 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2017   grade_6 23 0 7 0   0     0   4   17 17                       34 23 0 7 0   0     0   4   17 17                 34
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
1125081 1125081 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2017   grade_6 150 0 3 0   4     0   1   87 71                       158 150 0 3 0   4     0   1   87 71                 158
1125089 1125089 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2017   grade_6 132 0 5 0   11     0   5   65 88                       153 132 0 5 0   11     0   5   65 88                 153
1125230 1125230 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 East Meadow   Regular School No Elementary 04 06 2017   grade_6 51 0 5 0   0     0   1   36 21                       57 51 0 5 0   0     0   1   36 21                 57
1125298 1125298 MA Hampshire   school 2505580 117   Hadley 250558000879 1170015 Hadley Elementary   Regular School No Elementary PK 06 2017   grade_6 37 0 1 0   0     5   0   23 20                       43 37 0 1 0   0     5   0   23 20                 43
1125313 1125313 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2017   grade_6 82 0 3 0   1     0   0   51 35                       86 82 0 3 0   1     0   0   51 35                 86
1125369 1125369 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2017   grade_6 27 0 4 0   0     0   0   17 14                       31 27 0 4 0   0     0   0   17 14                 31
1125519 1125519 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2017   grade_6 33 0 1 0   1     0   0   13 22                       35 33 0 1 0   1     0   0   13 22                 35
1125578 1125578 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary KG 08 2017   grade_6 2 0 39 0   0     0   0   22 19                       41 2 0 39 0   0     0   0   22 19                 41
1125610 1125610 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2017   grade_6 6 0 32 0   0     0   2   22 18                       40 6 0 32 0   0     0   2   22 18                 40
1125636 1125636 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No Elementary KG 06 2017   grade_6 69 0 2 0   7     1   4   48 35                       83 69 0 2 0   7     1   4   48 35                 83
1125703 1125703 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2017   grade_6 63 0 0 0   0     0   0   37 26                       63 63 0 0 0   0     0   0   37 26                 63
1125753 1125753 MA Berkshire   school 2506630 148   Lanesborough 250663000949 1480005 Lanesborough Elementary   Regular School No Elementary PK 06 2017   grade_6 22 0 0 0   0     0   0   10 12                       22 22 0 0 0   0     0   0   10 12                 22
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
1125812 1125812 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_6 3 0 143 0   0     0   0   77 69                       146 3 0 143 0   0     0   0   77 69                 146
1125859 1125859 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2017   grade_6 2 0 80 0   0     0   0   45 37                       82 2 0 80 0   0     0   0   45 37                 82
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
1125938 1125938 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No Other 06 12 2017   grade_6 58 0 4 0   5     0   1   34 34                       68 58 0 4 0   5     0   1   34 34                 68
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
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
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
1126757 1126757 MA Plymouth   school 2507470 173   Mattapoisett 250747001149 1730010 Old Hammondtown   Regular School No Elementary 04 06 2017   grade_6 65 0 3 0   2     0   2   47 25                       72 65 0 3 0   2     0   2   47 25                 72
1126921 1126921 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2017   grade_6 103 0 30 0   3     0   5   67 74                       141 103 0 30 0   3     0   5   67 74                 141
1126943 1126943 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2017   grade_6 79 0 55 0   6     0   14   81 73                       154 79 0 55 0   6     0   14   81 73                 154
1126954 1126954 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No Elementary PK 08 2017   grade_6 54 0 74 0   8     0   6   84 58                       142 54 0 74 0   8     0   6   84 58                 142
1127102 1127102 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Granite Valley Middle   Regular School No Middle 05 08 2017   grade_6 54 0 1 1   0     0   0   28 28                       56 54 0 1 1   0     0   0   28 28                 56
1127118 1127118 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2017   grade_6 14 0 0 0   0     0   0   8 6                       14 14 0 0 0   0     0   0   8 6                 14
1127168 1127168 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No Middle 05 08 2017   grade_6 131 0 7 0   22     0   4   71 93                       164 131 0 7 0   22     0   4   71 93                 164
1127409 1127409 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2017   grade_6 178 0 5 0   2     0   3   97 91                       188 178 0 5 0   2     0   3   97 91                 188
1127576 1127576 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary KG 07 2017   grade_6 18 0 3 0   0     0   4   16 9                       25 18 0 3 0   0     0   4   16 9                 25
1127767 1127767 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2017   grade_6 167 0 9 0   0     0   9   107 78                       185 167 0 9 0   0     0   9   107 78                 185
1128056 1128056 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2017   grade_6 16 0 0 0   1     0   1   13 5                       18 16 0 0 0   1     0   1   13 5                 18
1128072 1128072 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No Elementary KG 06 2017   grade_6 74 0 0 0   1     0   0   42 33                       75 74 0 0 0   1     0   0   42 33                 75
1128097 1128097 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2017   grade_6 16 0 0 0   0     0   1   9 8                       17 16 0 0 0   0     0   1   9 8                 17
1128245 1128245 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 05 08 2017   grade_6 217 0 5 1   1     0   8   123 109                       232 217 0 5 1   1     0   8   123 109                 232
1128269 1128269 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2017   grade_6 32 0 0 0   0     0   0   11 21                       32 32 0 0 0   0     0   0   11 21                 32
1128554 1128554 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_6 15 0 0 0   0     0   1   8 8                       16 15 0 0 0   0     0   1   8 8                 16
1128603 1128603 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No Middle 06 08 2017   grade_6 68 0 1 0   1     0   3   33 40                       73 68 0 1 0   1     0   3   33 40                 73
1128769 1128769 MA Plymouth   school 2510560 264   Scituate 251056001691 2640010 Hatherly Elementary   Regular School No Elementary KG 06 2017   grade_6 36 0 0 0   2     0   1   14 25                       39 36 0 0 0   2     0   1   14 25                 39
1128777 1128777 MA Plymouth   school 2510560 264   Scituate 251056002068 2640015 Jenkins Elementary School   Regular School No Elementary KG 06 2017   grade_6 92 0 1 0   2     0   0   43 52                       95 92 0 1 0   2     0   0   43 52                 95
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
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
1129745 1129745 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_6 20 0 9 0   0     0   0   19 10                       29 20 0 9 0   0     0   0   19 10                 29
1129751 1129751 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Proctor Elementary   Regular School No Elementary 04 06 2017   grade_6 82 0 5 0   0     0   2   40 49                       89 82 0 5 0   0     0   2   40 49                 89
1129766 1129766 MA Barnstable   school 2511730 300   Truro 251173001930 3000005 Truro Central   Regular School No Elementary PK 06 2017   grade_6 8 0 1 0   0     0   0   3 6                       9 8 0 1 0   0     0   0   3 6                 9
1129849 1129849 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2017   grade_6 18 0 0 1   0     0   1   8 12                       20 18 0 0 1   0     0   1   8 12                 20
1130301 1130301 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2017   grade_6 176 0 0 0   70     0   5   144 107                       251 176 0 0 0   70     0   5   144 107                 251
1130317 1130317 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2017   grade_6 16 0 1 0   0     0   0   6 11                       17 16 0 1 0   0     0   0   6 11                 17
1130523 1130523 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2017   grade_6 19 0 1 0   0     0   0   14 6                       20 19 0 1 0   0     0   0   14 6                 20
1130532 1130532 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2017   grade_6 25 0 0 0   0     0   0   16 9                       25 25 0 0 0   0     0   0   16 9                 25
1130541 1130541 MA Berkshire   school 2513020 341   Williamstown 251302002146 3410010 Williamstown Elementary   Regular School No Elementary PK 06 2017   grade_6 50 0 4 0   2     0   3   30 29                       59 50 0 4 0   2     0   3   30 29                 59
1130582 1130582 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2017   grade_6 80 0 4 0   4     0   6   52 42                       94 80 0 4 0   4     0   6   52 42                 94
1130650 1130650 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2017   grade_6 128 0 15 0   1     0   2   77 69                       146 128 0 15 0   1     0   2   77 69                 146
1130920 1130920 MA Worcester   school 2513230 348   Worcester 251323002233 3480185 Midland Street   Regular School No Elementary KG 06 2017   grade_6 15 0 5 0   6     0   4   16 14                       30 15 0 5 0   6     0   4   16 14                 30
1131076 1131076 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2017   grade_6 8 0 0 0   0     0   0   3 5                       8 8 0 0 0   0     0   0   3 5                 8
1131297 1131297 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 2017   grade_6 1 0 18 0   1     0   0   11 9                       20 1 0 18 0   1     0   0   11 9                 20
1131379 1131379 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2017   grade_6 26 0 2 0   0     0   3   20 11                       31 26 0 2 0   0     0   3   20 11                 31
1131394 1131394 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes Elementary KG 08 2017   grade_6 7 0 76 0   0     0   3   39 47                       86 7 0 76 0   0     0   3   39 47                 86
1131405 1131405 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2017   grade_6 0 0 55 0   0     0   0   25 30                       55 0 0 55 0   0     0   0   25 30                 55
1131724 1131724 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Paul P Gates Elementary School   Regular School No Elementary KG 06 2017   grade_6 38 0 1 0   34     0   1   44 30                       74 38 0 1 0   34     0   1   44 30                 74
1131789 1131789 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2017   grade_6 177 0 6 0   1     0   4   85 103                       188 177 0 6 0   1     0   4   85 103                 188
1131814 1131814 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2017   grade_6 78 0 7 0   0     0   3   47 41                       88 78 0 7 0   0     0   3   47 41                 88
1131940 1131940 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2017   grade_6 19 0 1 0   0     0   0   11 9                       20 19 0 1 0   0     0   0   11 9                 20
1132027 1132027 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2017   grade_6 136 0 4 0   1     0   5   62 84                       146 136 0 4 0   1     0   5   62 84                 146
1132068 1132068 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Charlton Middle School   Regular School No Middle 05 08 2017   grade_6 162 0 8 0   2     1   2   81 94                       175 162 0 8 0   2     1   2   81 94                 175
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
1132141 1132141 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway Regional Middle School   Regular School No Middle 06 08 2017   grade_6 59 0 4 1   0     0   1   37 28                       65 59 0 4 1   0     0   1   37 28                 65
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
1132249 1132249 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002547 6800305 Thornton Burgess   Regular School No Middle 05 08 2017   grade_6 45 0 1 0   0     0   2   20 28                       48 45 0 1 0   0     0   2   20 28                 48
1132276 1132276 MA Franklin   school 2506000 685   Hawlemont 250600000869 6850005 Hawlemont Regional   Regular School No Elementary PK 06 2017   grade_6 7 0 0 1   0     0   0   3 5                       8 7 0 0 1   0     0   0   3 5                 8
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
1132336 1132336 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2017   grade_6 179 0 6 0   7     0   4   89 107                       196 179 0 6 0   7     0   4   89 107                 196
1132390 1132390 MA Franklin   school 2507990 717   Mohawk Trail 250799000424 7170005 Buckland-Shelburne Regional   Regular School No Elementary PK 06 2017   grade_6 24 0 1 0   0     0   0   8 17                       25 24 0 1 0   0     0   0   8 17                 25
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
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
1132438 1132438 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2017   grade_6 91 0 7 0   0     0   1   53 46                       99 91 0 7 0   0     0   1   53 46                 99
1132470 1132470 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2017   grade_6 77 0 3 0   2     0   0   41 41                       82 77 0 3 0   2     0   0   41 41                 82

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