enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1364806 1364806 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_6 97 1 2 0   1     0   0   57 44 *                     101.0 97 1 2 0   1     0   0   57 44                 101
1365314 1365314 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2020   grade_6 13 14 23 0   10     0   0   37 23 *                     60.0 13 14 23 0   10     0   0   37 23                 60
1365528 1365528 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2020   grade_6 3 27 53 0   7     0   0   47 43 *                     90.0 3 27 53 0   7     0   0   47 43                 90
1365552 1365552 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2020   grade_6 7 2 23 0   0     0   0   16 16 *                     32.0 7 2 23 0   0     0   0   16 16                 32
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
1365651 1365651 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_6 13 6 5 0   0     0   0   14 10 *                     24.0 13 6 5 0   0     0   0   14 10                 24
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
1365780 1365780 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_6 2 10 9 0   0     0   0   16 5 *                     21.0 2 10 9 0   0     0   0   16 5                 21
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
1366713 1366713 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset Middle School   Regular School No Middle 06 08 2020   grade_6 128 4 1 0   1     0   0   67 67 *                     134.0 128 4 1 0   1     0   0   67 67                 134
1366751 1366751 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2020   grade_6 14 1 1 0   0     0   0   10 6 *                     16.0 14 1 1 0   0     0   0   10 6                 16
1366961 1366961 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2020   grade_6 78 2 13 0   7     0   0   59 41 *                     100.0 78 2 13 0   7     0   0   59 41                 100
1367296 1367296 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_6 14 0 0 0   0     0   0   9 5 *                     14.0 14 0 0 0   0     0   0   9 5                 14
1367609 1367609 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2020   grade_6 172 1 8 0   4     0   0   104 81 *                     185.0 172 1 8 0   4     0   0   104 81                 185
1367637 1367637 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2020   grade_6 34 1 3 0   0     0   0   17 21 *                     38.0 34 1 3 0   0     0   0   17 21                 38
1367710 1367710 MA Essex   school 2505970 128   Haverhill 250597002906 1280105 Tilton Upper Middle School   Regular School No Middle 04 06 2020   grade_6 6 2 19 0   0     0   0   15 12 *                     27.0 6 2 19 0   0     0   0   15 12                 27
1367774 1367774 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2020   grade_6 20 0 1 0   1     0   0   11 11 *                     22.0 20 0 1 0   1     0   0   11 11                 22
1367849 1367849 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2020   grade_6 4 1 40 0   0     0   0   22 23 *                     45.0 4 1 40 0   0     0   0   22 23                 45
1367858 1367858 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke STEM Academy   Regular School No Middle 06 08 2020   grade_6 8 2 38 0   0     0   0   25 23 *                     48.0 8 2 38 0   0     0   0   25 23                 48
1367959 1367959 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2020   grade_6 140 1 6 1   3     0   0   75 75 *                     151.0 140 1 6 1   3     0   0   75 75                 151
1367980 1367980 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_6 3 1 87 0   2     0   0   46 47 *                     93.0 3 1 87 0   2     0   0   46 47                 93
1367984 1367984 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2020   grade_6 4 0 140 1   0     0   0   69 75 *                     145.0 4 0 140 1   0     0   0   69 75                 145
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
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
1368037 1368037 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2020   grade_6 5 1 72 0   0     0   0   36 42 *                     78.0 5 1 72 0   0     0   0   36 42                 78
1368043 1368043 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2020   grade_6 4 0 110 0   0     0   0   53 61 *                     114.0 4 0 110 0   0     0   0   53 61                 114
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
1368164 1368164 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2020   grade_6 13 0 2 0   0     0   0   9 6 *                     15.0 13 0 2 0   0     0   0   9 6                 15
1368600 1368600 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2020   grade_6 3 2 9 0   0     0   0   12 2 *                     14.0 3 2 9 0   0     0   0   12 2                 14
1369114 1369114 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2020   grade_6 15 0 0 0   0     0   0   6 9 *                     15.0 15 0 0 0   0     0   0   6 9                 15
1369513 1369513 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 06 2020   grade_6 27 4 3 0   0     0   0   18 16 *                     34.0 27 4 3 0   0     0   0   18 16                 34
1369798 1369798 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Dexter Park   Regular School No Elementary 03 06 2020   grade_6 87 2 9 0   1     0   0   49 50 *                     99.0 87 2 9 0   1     0   0   49 50                 99
1370089 1370089 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2020   grade_6 31 0 0 0   0     0   0   16 15 *                     31.0 31 0 0 0   0     0   0   16 15                 31
1370374 1370374 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No Middle 06 08 2020   grade_6 68 0 0 0   2     0   0   43 27 *                     70.0 68 0 0 0   2     0   0   43 27                 70
1370387 1370387 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2020   grade_6 9 0 0 0   0     0   0   4 5 *                     9.0 9 0 0 0   0     0   0   4 5                 9
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
1370884 1370884 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2020   grade_6 5 6 27 0   0     0   0   17 21 *                     38.0 5 6 27 0   0     0   0   17 21                 38
1370995 1370995 MA Hampden   school 2511130 281   Springfield 251113002599 2810320 John J Duggan Middle   Regular School No High 06 12 2020   grade_6 19 44 100 1   4     0   0   98 70 *                     168.0 19 44 100 1   4     0   0   98 70                 168
1371005 1371005 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No Middle 06 08 2020   grade_6 15 42 116 0   1     0   0   87 87 *                     174.0 15 42 116 0   1     0   0   87 87                 174
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
1371017 1371017 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No Middle 06 08 2020   grade_6 3 15 70 0   0     0   0   45 43 *                     88.0 3 15 70 0   0     0   0   45 43                 88
1371022 1371022 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2020   grade_6 3 9 95 0   1     0   0   67 41 *                     108.0 3 9 95 0   1     0   0   67 41                 108
1371041 1371041 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle Academy   Regular School No Middle 06 08 2020   grade_6 9 8 79 0   1     0   0   55 42 *                     97.0 9 8 79 0   1     0   0   55 42                 97
1371699 1371699 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No High 06 12 2020   grade_6 61 0 7 0   1     0   0   34 35 *                     69.0 61 0 7 0   1     0   0   34 35                 69
1371801 1371801 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2020   grade_6 16 0 0 0   0     0   0   6 10 *                     16.0 16 0 0 0   0     0   0   6 10                 16
1371967 1371967 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2020   grade_6 16 0 1 0   0     0   0   9 8 *                     17.0 16 0 1 0   0     0   0   9 8                 17
1371975 1371975 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2020   grade_6 16 0 0 0   1     0   0   9 8 *                     17.0 16 0 0 0   1     0   0   9 8                 17
1372191 1372191 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2020   grade_6 5 8 5 0   1     0   0   11 8 *                     19.0 5 8 5 0   1     0   0   11 8                 19
1372206 1372206 MA Worcester   school 2513230 348   Worcester 251323002212 3480090 Flagg Street   Regular School No Elementary KG 06 2020   grade_6 40 3 8 0   1     0   0   30 22 *                     52.0 40 3 8 0   1     0   0   30 22                 52
1372221 1372221 MA Worcester   school 2513230 348   Worcester 251323002215 3480100 Goddard School/Science Technical   Regular School No Elementary PK 06 2020   grade_6 5 4 39 1   9     0   0   27 31 *                     58.0 5 4 39 1   9     0   0   27 31                 58
1372265 1372265 MA Worcester   school 2513230 348   Worcester 251323002229 3480160 Lincoln Street   Regular School No Elementary KG 06 2020   grade_6 3 3 9 0   2     0   0   3 14 *                     17.0 3 3 9 0   2     0   0   3 14                 17
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
1372509 1372509 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 2020   grade_6 3 61 9 0   0     0   0   35 38 *                     73.0 3 61 9 0   0     0   0   35 38                 73
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
1372574 1372574 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 08 2020   grade_6 3 2 29 0   1     0   0   12 23 *                     35.0 3 2 29 0   1     0   0   12 23                 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
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
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
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
1372768 1372768 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2020   grade_6 44 2 4 0   2     0   0   31 21 *                     52.0 44 2 4 0   2     0   0   31 21                 52
1372830 1372830 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2020   grade_6 5 51 67 0   12     0   0   79 56 *                     135.0 5 51 67 0   12     0   0   79 56                 135
1372847 1372847 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2020   grade_6 29 1 3 1   0     0   0   11 23 *                     34.0 29 1 3 1   0     0   0   11 23                 34
1372859 1372859 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_6 2 140 105 1   0     3   0   136 115 *                     251.0 2 140 105 1   0     3   0   136 115                 251
1372918 1372918 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_6 91 2 15 0   2     0   0   51 59 *                     110.0 91 2 15 0   2     0   0   51 59                 110
1372941 1372941 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2020   grade_6 28 16 16 0   4     0   0   27 37 *                     64.0 28 16 16 0   4     0   0   27 37                 64
1373331 1373331 MA Berkshire   school 2513321 662   Farmington River Reg 251332100402 6620020 Farmington River Elementary   Regular School No Elementary PK 06 2020   grade_6 13 0 0 0   0     0   0   11 2 *                     13.0 13 0 0 0   0     0   0   11 2                 13
1373371 1373371 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway Regional Middle School   Regular School No Middle 06 08 2020   grade_6 56 2 7 0   0     1   0   33 33 *                     66.0 56 2 7 0   0     1   0   33 33                 66
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
1373578 1373578 MA Berkshire   school 2508160 715   Mount Greylock 250816002887 7150005 Lanesborough Elementary   Regular School No Elementary PK 06 2020   grade_6 23 1 0 0   0     0   0   15 9 *                     24.0 23 1 0 0   0     0   0   15 9                 24
1373609 1373609 MA Franklin   school 2507990 717   Mohawk Trail 250799000425 7170010 Colrain Central   Regular School No Elementary PK 06 2020   grade_6 7 0 3 0   0     0   0   7 3 *                     10.0 7 0 3 0   0     0   0   7 3                 10
1373742 1373742 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Helen R Donaghue School   Regular School No Elementary 03 06 2020   grade_6 42 0 4 1   0     0   0   24 23 *                     47.0 42 0 4 1   0     0   0   24 23                 47
1373750 1373750 MA Essex   school 2509450 745   Pentucket 250945000408 7450015 Dr John C Page School   Regular School No Elementary PK 06 2020   grade_6 42 0 2 0   2     0   0   19 27 *                     46.0 42 0 2 0   2     0   0   19 27                 46
1373768 1373768 MA Franklin   school 2509600 750   Pioneer Valley 250960002612 7500006 Bernardston Elementary   Regular School No Elementary PK 06 2020   grade_6 18 0 0 0   0     0   0   8 10 *                     18.0 18 0 0 0   0     0   0   8 10                 18
1373776 1373776 MA Franklin   school 2509600 750   Pioneer Valley 250960002614 7500008 Northfield Elementary   Regular School No Elementary PK 06 2020   grade_6 22 0 0 0   0     0   0   12 10 *                     22.0 22 0 0 0   0     0   0   12 10                 22
1373796 1373796 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary PK 06 2020   grade_6 28 0 4 0   0     0   0   21 11 *                     32.0 28 0 4 0   0     0   0   21 11                 32
1373803 1373803 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2020   grade_6 46 0 3 0   0     0   0   19 30 *                     49.0 46 0 3 0   0     0   0   19 30                 49
1373810 1373810 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2020   grade_6 27 0 3 0   0     0   0   16 14 *                     30.0 27 0 3 0   0     0   0   16 14                 30
1373818 1373818 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2020   grade_6 57 0 5 0   1     1   0   37 27 *                     64.0 57 0 5 0   1     1   0   37 27                 64
1373934 1373934 MA Essex   school 2511740 773   Triton 251174001651 7730025 Pine Grove   Regular School No Elementary PK 06 2020   grade_6 52 1 0 0   2     0   0   25 30 *                     55.0 52 1 0 0   2     0   0   25 30                 55
1374035 1374035 MA Worcester   school 2512100 778   Quaboag Regional 251210002040 7780010 West Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_6 40 0 1 0   0     0   0   24 17 *                     41.0 40 0 1 0   0     0   0   24 17                 41
1374267 1374267 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West   Regular School Yes Middle 06 10 2020   grade_6 26 15 25 0   1     0   0   33 34 *                     67.0 26 15 25 0   1     0   0   33 34                 67
1365280 1365280 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2020   grade_6 5 5 3 0   3     0   1   9 8 *                     17.0 5 5 3 0   3     0   1   9 8                 17
1365304 1365304 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2020   grade_6 18 12 12 0   5     0   1   23 25 *                     48.0 18 12 12 0   5     0   1   23 25                 48
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
1365766 1365766 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2020   grade_6 37 5 15 0   4     0   1   37 25 *                     62.0 37 5 15 0   4     0   1   37 25                 62
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
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
1365865 1365865 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2020   grade_6 5 6 8 0   0     0   1   17 3 *                     20.0 5 6 8 0   0     0   1   17 3                 20
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
1366141 1366141 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield Elementary   Regular School No Elementary PK 06 2020   grade_6 37 3 1 0   0     0   1   16 26 *                     42.0 37 3 1 0   0     0   1   16 26                 42
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

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