enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 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
2040420 2040420 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2041287 2041287 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2042269 2042269 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2042674 2042674 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   3 2                       5.0                         3 2                 5
2043675 2043675 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2019   grade_6 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2045461 2045461 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2047496 2047496 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2048406 2048406 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507001852 6650015 George R Austin Intermediate School   Regular School No Middle 04 06 2019   grade_6 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2040872 2040872 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2019   grade_6 0 28 16 0   1     0   2   20 27                       47.0 0 28 16 0   1     0   2   20 27                 47
2040899 2040899 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_6 0 17 26 0   0     0   0   25 18                       43.0 0 17 26 0   0     0   0   25 18                 43
2046086 2046086 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2019   grade_6 0 2 10 0   0     0   1   11 2                       13.0 0 2 10 0   0     0   1   11 2                 13
2047562 2047562 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2019   grade_6 0 60 22 0   2     0   4   42 46                       88.0 0 60 22 0   2     0   4   42 46                 88
2047576 2047576 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_6 0 20 14 0   0     0   5   18 21                       39.0 0 20 14 0   0     0   5   18 21                 39
2047581 2047581 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2019   grade_6 0 47 22 0   0     0   0   33 36                       69.0 0 47 22 0   0     0   0   33 36                 69
2047591 2047591 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_6 0 42 5 0   1     0   0   27 21                       48.0 0 42 5 0   1     0   0   27 21                 48
2047603 2047603 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 07 2019   grade_6 0 0 39 0   0     0   0   21 18                       39.0 0 0 39 0   0     0   0   21 18                 39
2047660 2047660 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes High 06 12 2019   grade_6 0 22 6 0   3     1   3   21 14                       35.0 0 22 6 0   3     1   3   21 14                 35
2047678 2047678 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_6 0 17 2 0   0     0   0   7 12                       19.0 0 17 2 0   0     0   0   7 12                 19
2047834 2047834 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2019   grade_6 0 42 21 0   1     0   0   40 24                       64.0 0 42 21 0   1     0   0   40 24                 64
2047912 2047912 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2019   grade_6 0 52 20 0   0     0   1   38 35                       73.0 0 52 20 0   0     0   1   38 35                 73
2040653 2040653 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_6 1 10 39 0   0     0   0   17 33                       50.0 1 10 39 0   0     0   0   17 33                 50
2040845 2040845 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_6 1 27 12 0   1     2   1   28 16                       44.0 1 27 12 0   1     2   1   28 16                 44
2041100 2041100 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_6 1 4 4 0   0     0   0   7 2                       9.0 1 4 4 0   0     0   0   7 2                 9
2043102 2043102 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2019   grade_6 1 0 106 0   0     0   0   57 50                       107.0 1 0 106 0   0     0   0   57 50                 107
2046092 2046092 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No Middle 06 08 2019   grade_6 1 7 63 0   0     0   0   35 36                       71.0 1 7 63 0   0     0   0   35 36                 71
2047647 2047647 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 07 2019   grade_6 1 0 34 0   1     0   0   16 20                       36.0 1 0 34 0   1     0   0   16 20                 36
2047692 2047692 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2019   grade_6 1 22 16 0   2     0   2   18 25                       43.0 1 22 16 0   2     0   2   18 25                 43
2047802 2047802 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2019   grade_6 1 1 79 0   0     0   0   31 50                       81.0 1 1 79 0   0     0   0   31 50                 81
2047821 2047821 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2019   grade_6 1 19 37 0   16     0   4   41 36                       77.0 1 19 37 0   16     0   4   41 36                 77
2047951 2047951 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2019   grade_6 1 35 35 0   0     0   2   36 37                       73.0 1 35 35 0   0     0   2   36 37                 73
2049330 2049330 MA Hampden   school 2500586 3514   Libertas Academy Charter School (District) 250058602878 35140305 Libertas Academy Charter School   Regular School Yes Middle 06 07 2019   grade_6 1 12 74 0   0     0   0   44 43                       87.0 1 12 74 0   0     0   0   44 43                 87
2040452 2040452 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_6 10 2 88 0   1     0   0   53 48                       101.0 10 2 88 0   1     0   0   53 48                 101
2040694 2040694 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   grade_6 10 8 3 1   2     0   1   13 12                       25.0 10 8 3 1   2     0   1   13 12                 25
2040792 2040792 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2019   grade_6 10 9 25 0   1     0   3   24 24                       48.0 10 9 25 0   1     0   3   24 24                 48
2041030 2041030 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2019   grade_6 10 19 22 0   84     0   8   78 65                       143.0 10 19 22 0   84     0   8   78 65                 143
2041664 2041664 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2019   grade_6 10 5 147 1   1     0   3   90 77                       167.0 10 5 147 1   1     0   3   90 77                 167
2045692 2045692 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2019   grade_6 10 1 1 0   0     0   1   8 5                       13.0 10 1 1 0   0     0   1   8 5                 13
2047225 2047225 MA Worcester   school 2513230 348   Worcester 251323002201 3480035 Burncoat Street   Regular School No Elementary KG 06 2019   grade_6 10 6 19 0   3     0   1   19 20                       39.0 10 6 19 0   3     0   1   19 20                 39
2047542 2047542 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_6 10 43 24 0   1     0   2   39 41                       80.0 10 43 24 0   1     0   2   39 41                 80
2047615 2047615 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_6 10 85 79 1   3     0   5   95 88                       183.0 10 85 79 1   3     0   5   95 88                 183
2047725 2047725 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 10 2019   grade_6 10 32 19 0   1     0   4   38 28                       66.0 10 32 19 0   1     0   4   38 28                 66
2042503 2042503 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2019   grade_6 101 5 5 0   8     0   2   68 53                       121.0 101 5 5 0   8     0   2   68 53                 121
2045496 2045496 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2019   grade_6 101 16 91 0   6     0   9   122 101                       223.0 101 16 91 0   6     0   9   122 101                 223
2044534 2044534 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2019   grade_6 102 10 23 1   22     0   12   77 93                       170.0 102 10 23 1   22     0   12   77 93                 170
2045808 2045808 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No Middle 06 08 2019   grade_6 102 1 8 0   17     0   8   68 68                       136.0 102 1 8 0   17     0   8   68 68                 136
2040052 2040052 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2019   grade_6 104 10 37 0   9     0   5   91 73                       165.0 104 10 37 0   9     0   5   91 73                 165
2046591 2046591 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Middle 04 06 2019   grade_6 104 3 7 0   0     0   4   59 59                       118.0 104 3 7 0   0     0   4   59 59                 118
2046902 2046902 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2019   grade_6 104 0 4 0   1     0   9   72 46                       118.0 104 0 4 0   1     0   9   72 46                 118
2049137 2049137 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2019   grade_6 104 1 7 0   3     0   1   58 58                       116.0 104 1 7 0   3     0   1   58 58                 116
2046857 2046857 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2019   grade_6 105 5 3 2   55     0   11   98 83                       181.0 105 5 3 2   55     0   11   98 83                 181
2048699 2048699 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2019   grade_6 105 3 7 0   0     1   6   64 58                       122.0 105 3 7 0   0     1   6   64 58                 122
2043871 2043871 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Quashnet School   Regular School No Elementary 03 06 2019   grade_6 106 4 5 9   4     0   12   68 72                       140.0 106 4 5 9   4     0   12   68 72                 140
2046275 2046275 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2019   grade_6 106 1 2 0   1     0   5   56 59                       115.0 106 1 2 0   1     0   5   56 59                 115
2046521 2046521 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Bird Middle   Regular School No Middle 06 08 2019   grade_6 106 5 11 0   5     0   3   62 68                       130.0 106 5 11 0   5     0   3   62 68                 130
2043323 2043323 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2019   grade_6 107 1 5 0   7     0   4   67 57                       124.0 107 1 5 0   7     0   4   67 57                 124
2043532 2043532 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2019   grade_6 107 2 14 0   0     0   3   64 62                       126.0 107 2 14 0   0     0   3   64 62                 126
2044543 2044543 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2019   grade_6 108 9 13 0   62     0   14   121 85                       206.0 108 9 13 0   62     0   14   121 85                 206
2046231 2046231 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2019   grade_6 108 3 5 1   0     1   4   73 49                       122.0 108 3 5 1   0     1   4   73 49                 122
2048944 2048944 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2019   grade_6 108 1 3 0   1     0   2   54 61                       115.0 108 1 3 0   1     0   2   54 61                 115
2046888 2046888 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No Middle 06 08 2019   grade_6 109 16 13 0   28     0   15   102 79                       181.0 109 16 13 0   28     0   15   102 79                 181
2042107 2042107 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2019   grade_6 11 5 57 0   4     0   1   44 34                       78.0 11 5 57 0   4     0   1   44 34                 78
2042920 2042920 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2019   grade_6 11 2 53 0   3     0   0   36 33                       69.0 11 2 53 0   3     0   0   36 33                 69
2045730 2045730 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2019   grade_6 11 10 27 0   6     0   2   25 31                       56.0 11 10 27 0   6     0   2   25 31                 56
2047211 2047211 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2019   grade_6 11 5 6 0   0     0   0   11 11                       22.0 11 5 6 0   0     0   0   11 11                 22
2047309 2047309 MA Worcester   school 2513230 348   Worcester 251323002219 3480115 Grafton Street   Regular School No Elementary KG 06 2019   grade_6 11 3 23 0   3     0   0   21 19                       40.0 11 3 23 0   3     0   0   21 19                 40
2048367 2048367 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley Middle School   Regular School No Middle 05 08 2019   grade_6 110 2 8 0   1     0   1   61 61                       122.0 110 2 8 0   1     0   1   61 61                 122
2042500 2042500 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2019   grade_6 111 2 4 1   4     0   0   70 52                       122.0 111 2 4 1   4     0   0   70 52                 122
2041783 2041783 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No High 06 12 2019   grade_6 112 3 0 0   1     0   4   71 49                       120.0 112 3 0 0   1     0   4   71 49                 120
2044893 2044893 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2019   grade_6 112 2 27 0   3     0   11   82 73                       155.0 112 2 27 0   3     0   11   82 73                 155
2043029 2043029 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2019   grade_6 113 0 5 0   3     0   3   59 65                       124.0 113 0 5 0   3     0   3   59 65                 124
2049082 2049082 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2019   grade_6 113 2 6 0   4     0   3   65 63                       128.0 113 2 6 0   4     0   3   65 63                 128
2048286 2048286 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2019   grade_6 114 2 5 0   0     0   3   70 54                       124.0 114 2 5 0   0     0   3   70 54                 124
2041598 2041598 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2019   grade_6 115 0 6 0   1     1   0   70 53                       123.0 115 0 6 0   1     1   0   70 53                 123
2042743 2042743 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2019   grade_6 115 10 29 0   4     0   3   83 78                       161.0 115 10 29 0   4     0   3   83 78                 161
2042601 2042601 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Millbury Street Elementary School   Regular School No Elementary 02 06 2019   grade_6 116 4 9 0   12     0   6   81 66                       147.0 116 4 9 0   12     0   6   81 66                 147
2044407 2044407 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2019   grade_6 116 47 139 0   0     0   20   162 160                       322.0 116 47 139 0   0     0   20   162 160                 322
2042787 2042787 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2019   grade_6 118 5 30 0   2     0   1   83 73                       156.0 118 5 30 0   2     0   1   83 73                 156
2047135 2047135 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2019   grade_6 119 2 21 0   1     0   1   64 80                       144.0 119 2 21 0   1     0   1   64 80                 144
2041068 2041068 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2019   grade_6 12 58 36 0   2     0   5   62 51                       113.0 12 58 36 0   2     0   5   62 51                 113
2042368 2042368 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_6 12 1 0 0   0     0   0   7 6                       13.0 12 1 0 0   0     0   0   7 6                 13
2043248 2043248 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2019   grade_6 12 0 3 0   0     0   2   8 9                       17.0 12 0 3 0   0     0   2   8 9                 17
2043463 2043463 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2019   grade_6 12 5 19 0   15     0   1   30 22                       52.0 12 5 19 0   15     0   1   30 22                 52
2045018 2045018 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2019   grade_6 12 0 2 0   0     0   0   6 8                       14.0 12 0 2 0   0     0   0   6 8                 14
2046267 2046267 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No Elementary PK 06 2019   grade_6 12 0 2 0   2     0   4   12 8                       20.0 12 0 2 0   2     0   4   12 8                 20
2047428 2047428 MA Worcester   school 2513230 348   Worcester 251323002248 3480240 Union Hill School   Regular School No Elementary KG 06 2019   grade_6 12 7 34 0   1     0   1   27 28                       55.0 12 7 34 0   1     0   1   27 28                 55
2040048 2040048 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2019   grade_6 120 9 24 0   6     0   10   98 71                       169.0 120 9 24 0   6     0   10   98 71                 169
2045330 2045330 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2019   grade_6 120 1 3 0   1     0   3   70 58                       128.0 120 1 3 0   1     0   3   70 58                 128
2046449 2046449 MA Worcester   school 2511850 304   Uxbridge 251185002892 3040405 Whitin Intermediate   Regular School No Middle 04 07 2019   grade_6 120 0 5 2   2     0   1   67 63                       130.0 120 0 5 2   2     0   1   67 63                 130
2048503 2048503 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2019   grade_6 121 1 6 0   3     0   4   67 68                       135.0 121 1 6 0   3     0   4   67 68                 135
2041741 2041741 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2019   grade_6 122 9 111 1   8     0   9   141 119                       260.0 122 9 111 1   8     0   9   141 119                 260
2044107 2044107 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Raymond E. Shaw Elementary   Regular School No Middle 04 06 2019   grade_6 122 4 10 0   9     0   13   83 75                       158.0 122 4 10 0   9     0   13   83 75                 158
2044734 2044734 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge Middle   Regular School No Middle 05 08 2019   grade_6 122 3 20 0   1     0   12   70 88                       158.0 122 3 20 0   1     0   12   70 88                 158
2046524 2046524 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2019   grade_6 122 6 8 2   12     0   5   85 70                       155.0 122 6 8 2   12     0   5   85 70                 155
2048181 2048181 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2019   grade_6 122 4 19 0   1     0   4   81 69                       150.0 122 4 19 0   1     0   4   81 69                 150
2048767 2048767 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2019   grade_6 122 2 1 0   5     0   3   72 61                       133.0 122 2 1 0   5     0   3   72 61                 133
2044226 2044226 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 J F Kennedy Middle School   Regular School No Middle 05 08 2019   grade_6 123 2 14 0   11     0   12   93 69                       162.0 123 2 14 0   11     0   12   93 69                 162
2045840 2045840 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2019   grade_6 123 3 23 0   2     0   2   62 91                       153.0 123 3 23 0   2     0   2   62 91                 153
2039946 2039946 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2019   grade_6 124 4 9 0   27     0   7   95 76                       171.0 124 4 9 0   27     0   7   95 76                 171
2047186 2047186 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2019   grade_6 124 14 20 0   12     0   5   83 92                       175.0 124 14 20 0   12     0   5   83 92                 175
2048574 2048574 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2019   grade_6 124 0 0 0   2     0   1   59 68                       127.0 124 0 0 0   2     0   1   59 68                 127

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