enrollments

Data source: Big Local News · About: Big Local

500 rows where grade = "grade_7", state = "MA" and year = 2020 sorted by white_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 500 ✖

grade ✖

  • grade_7 · 500 ✖
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
1366219 1366219 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_7 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1366632 1366632 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2020   grade_7 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1367687 1367687 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_7 * * * *   *     *   *   2 * *                     2.0                         2                   2
1368425 1368425 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 12 2020   grade_7 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1368464 1368464 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1368609 1368609 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   grade_7 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1370706 1370706 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2020   grade_7 * * * *   *     *   *   4 * *                     4.0                         4                   4
1371954 1371954 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 08 2020   grade_7 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1373189 1373189 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 07 12 2020   grade_7 * * * *   *     *   *   1 * *                     1.0                         1                   1
1374314 1374314 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1365553 1365553 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2020   grade_7 0 1 19 0   0     0   0   13 7 *                     20.0 0 1 19 0   0     0   0   13 7                 20
1365856 1365856 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_7 0 19 23 0   0     0   0   22 20 *                     42.0 0 19 23 0   0     0   0   22 20                 42
1366048 1366048 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_7 0 3 5 0   0     0   0   6 2 *                     8.0 0 3 5 0   0     0   0   6 2                 8
1371012 1371012 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2020   grade_7 0 5 12 0   0     0   2   17 2 *                     19.0 0 5 12 0   0     0   2   17 2                 19
1371020 1371020 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2020   grade_7 0 4 6 0   0     0   0   9 1 *                     10.0 0 4 6 0   0     0   0   9 1                 10
1372504 1372504 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 08 2020   grade_7 0 13 6 0   0     0   4   12 11 *                     23.0 0 13 6 0   0     0   4   12 11                 23
1372510 1372510 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_7 0 64 16 0   0     0   0   42 38 *                     80.0 0 64 16 0   0     0   0   42 38                 80
1372532 1372532 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_7 0 0 38 0   0     0   0   20 18 *                     38.0 0 0 38 0   0     0   0   20 18                 38
1372607 1372607 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_7 0 18 1 0   0     0   0   9 10 *                     19.0 0 18 1 0   0     0   0   9 10                 19
1372621 1372621 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2020   grade_7 0 18 14 0   0     0   1   16 17 *                     33.0 0 18 14 0   0     0   1   16 17                 33
1372764 1372764 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_7 0 34 22 0   0     0   0   34 22 *                     56.0 0 34 22 0   0     0   0   34 22                 56
1372860 1372860 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_7 0 134 98 0   1     0   1   119 115 *                     234.0 0 134 98 0   1     0   1   119 115                 234
1365315 1365315 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2020   grade_7 1 17 17 0   3     0   0   20 18 *                     38.0 1 17 17 0   3     0   0   20 18                 38
1365400 1365400 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2020   grade_7 1 15 21 0   0     1   3   18 23 *                     41.0 1 15 21 0   0     1   3   18 23                 41
1365444 1365444 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2020   grade_7 1 19 21 0   1     0   2   24 20 *                     44.0 1 19 21 0   1     0   2   24 20                 44
1365563 1365563 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2020   grade_7 1 32 21 0   4     0   6   31 33 *                     64.0 1 32 21 0   4     0   6   31 33                 64
1365611 1365611 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2020   grade_7 1 10 27 0   1     0   0   10 29 *                     39.0 1 10 27 0   1     0   0   10 29                 39
1365662 1365662 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_7 1 43 42 0   0     1   0   39 48 *                     87.0 1 43 42 0   0     1   0   39 48                 87
1365803 1365803 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   grade_7 1 15 9 0   1     2   0   20 8 *                     28.0 1 15 9 0   1     2   0   20 8                 28
1365897 1365897 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2020   grade_7 1 43 58 0   2     0   0   55 49 *                     104.0 1 43 58 0   2     0   0   55 49                 104
1367065 1367065 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2020   grade_7 1 4 3 0   0     0   1   8 1 *                     9.0 1 4 3 0   0     0   1   8 1                 9
1367985 1367985 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2020   grade_7 1 1 162 0   0     0   1   82 83 *                     165.0 1 1 162 0   0     0   1   82 83                 165
1372575 1372575 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_7 1 0 34 0   1     0   0   16 20 *                     36.0 1 0 34 0   1     0   0   16 20                 36
1372722 1372722 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes Elementary KG 08 2020   grade_7 1 0 71 0   1     0   2   39 36 *                     75.0 1 0 71 0   1     0   2   39 36                 75
1372732 1372732 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_7 1 3 78 0   0     0   0   33 49 *                     82.0 1 3 78 0   0     0   0   33 49                 82
1372751 1372751 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2020   grade_7 1 18 34 0   16     0   4   40 33 *                     73.0 1 18 34 0   16     0   4   40 33                 73
1372793 1372793 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_7 1 44 41 0   1     0   3   34 56 *                     90.0 1 44 41 0   1     0   3   34 56                 90
1372880 1372880 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2020   grade_7 1 34 33 0   0     0   2   34 36 *                     70.0 1 34 33 0   0     0   2   34 36                 70
1374259 1374259 MA Hampden   school 2500586 3514   Libertas Charter School (District) 250058602878 35140305 Libertas Academy Charter School   Regular School Yes Middle 06 08 2020   grade_7 1 15 72 0   1     0   1   44 46 *                     90.0 1 15 72 0   1     0   1   44 46                 90
1365281 1365281 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2020   grade_7 2 3 8 0   1     0   1   12 3 *                     15.0 2 3 8 0   1     0   1   12 3                 15
1365386 1365386 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2020   grade_7 2 49 26 0   3     2   2   41 43 *                     84.0 2 49 26 0   3     2   2   41 43                 84
1365740 1365740 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2020   grade_7 2 9 17 0   0     0   0   17 11 *                     28.0 2 9 17 0   0     0   0   17 11                 28
1365781 1365781 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_7 2 14 12 0   1     0   0   21 8 *                     29.0 2 14 12 0   1     0   0   21 8                 29
1365836 1365836 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 03 08 2020   grade_7 2 22 20 0   0     0   1   31 14 *                     45.0 2 22 20 0   0     0   1   31 14                 45
1365846 1365846 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2020   grade_7 2 52 38 0   0     0   2   55 39 *                     94.0 2 52 38 0   0     0   2   55 39                 94
1365869 1365869 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No Middle 06 08 2020   grade_7 2 57 70 0   13     1   6   87 62 *                     149.0 2 57 70 0   13     1   6   87 62                 149
1365948 1365948 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2020   grade_7 2 19 16 0   0     0   0   18 19 *                     37.0 2 19 16 0   0     0   0   18 19                 37
1365987 1365987 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2020   grade_7 2 14 21 0   38     0   2   39 38 *                     77.0 2 14 21 0   38     0   2   39 38                 77
1366040 1366040 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2020   grade_7 2 0 23 0   0     0   0   12 13 *                     25.0 2 0 23 0   0     0   0   12 13                 25
1367198 1367198 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_7 2 2 5 0   0     0   2   9 2 *                     11.0 2 2 5 0   0     0   2   9 2                 11
1367823 1367823 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2020   grade_7 2 0 47 0   0     0   0   26 23 *                     49.0 2 0 47 0   0     0   0   26 23                 49
1368019 1368019 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2020   grade_7 2 0 106 0   0     0   1   58 51 *                     109.0 2 0 106 0   0     0   1   58 51                 109
1368044 1368044 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2020   grade_7 2 0 80 0   0     0   1   42 40 *                     83.0 2 0 80 0   0     0   1   42 40                 83
1368062 1368062 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_7 2 0 13 0   0     0   1   14 2 *                     16.0 2 0 13 0   0     0   1   14 2                 16
1371018 1371018 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No Middle 06 08 2020   grade_7 2 10 71 0   0     0   0   38 45 *                     83.0 2 10 71 0   0     0   0   38 45                 83
1372490 1372490 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2020   grade_7 2 65 24 0   1     0   5   52 45 *                     97.0 2 65 24 0   1     0   5   52 45                 97
1372971 1372971 MA Hampden   school 2500536 498   Veritas Preparatory Charter School (District) 250053602714 4980405 Veritas Preparatory Charter School   Regular School Yes Middle 05 08 2020   grade_7 2 16 60 0   0     0   1   36 43 *                     79.0 2 16 60 0   0     0   1   36 43                 79
1374218 1374218 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2020   grade_7 2 40 34 0   0     0   1   39 38 *                     77.0 2 40 34 0   0     0   1   39 38                 77
1365339 1365339 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2020   grade_7 3 20 64 0   1     0   3   42 49 *                     91.0 3 20 64 0   1     0   3   42 49                 91
1365635 1365635 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2020   grade_7 3 19 32 0   24     0   3   47 34 *                     81.0 3 19 32 0   24     0   3   47 34                 81
1365830 1365830 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2020   grade_7 3 28 17 0   0     0   5   26 27 *                     53.0 3 28 17 0   0     0   5   26 27                 53
1365866 1365866 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2020   grade_7 3 3 11 0   0     0   1   9 9 *                     18.0 3 3 11 0   0     0   1   9 9                 18
1367207 1367207 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2020   grade_7 3 2 8 0   0     0   3   12 4 *                     16.0 3 2 8 0   0     0   3   12 4                 16
1367815 1367815 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2020   grade_7 3 2 48 0   0     0   0   33 20 *                     53.0 3 2 48 0   0     0   0   33 20                 53
1368041 1368041 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2020   grade_7 3 3 147 0   2     0   3   90 68 *                     158.0 3 3 147 0   2     0   3   90 68                 158
1368601 1368601 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2020   grade_7 3 0 4 0   0     0   2   8 1 *                     9.0 3 0 4 0   0     0   2   8 1                 9
1369344 1369344 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2020   grade_7 3 2 4 0   0     0   0   6 3 *                     9.0 3 2 4 0   0     0   0   6 3                 9
1370098 1370098 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_7 3 5 2 0   0     0   0   3 7 *                     10.0 3 5 2 0   0     0   0   3 7                 10
1372589 1372589 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes High 06 12 2020   grade_7 3 50 6 0   3     1   3   36 30 *                     66.0 3 50 6 0   3     1   3   36 30                 66
1372631 1372631 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_7 3 1 37 0   0     0   0   23 18 *                     41.0 3 1 37 0   0     0   0   23 18                 41
1372831 1372831 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_7 3 61 77 0   0     1   3   79 66 *                     145.0 3 61 77 0   0     1   3   79 66                 145
1374190 1374190 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2020   grade_7 3 15 57 0   0     0   0   35 40 *                     75.0 3 15 57 0   0     0   0   35 40                 75
1365305 1365305 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2020   grade_7 4 11 14 1   0     0   0   14 16 *                     30.0 4 11 14 1   0     0   0   14 16                 30
1365491 1365491 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2020   grade_7 4 14 55 0   0     0   2   35 40 *                     75.0 4 14 55 0   0     0   2   35 40                 75
1365678 1365678 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2020   grade_7 4 6 18 0   0     0   2   14 16 *                     30.0 4 6 18 0   0     0   2   14 16                 30
1365894 1365894 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No Middle 06 08 2020   grade_7 4 37 43 0   0     0   2   41 45 *                     86.0 4 37 43 0   0     0   2   41 45                 86
1366600 1366600 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2020   grade_7 4 2 140 0   0     0   1   76 71 *                     147.0 4 2 140 0   0     0   1   76 71                 147
1367981 1367981 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2020   grade_7 4 0 78 0   1     0   0   40 43 *                     83.0 4 0 78 0   1     0   0   40 43                 83
1368369 1368369 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_7 4 0 5 0   0     0   0   8 * *                     9.0 4 0 5 0   0     0   0   8                   9
1371042 1371042 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle Academy   Regular School No Middle 06 08 2020   grade_7 4 6 57 0   3     0   0   37 33 *                     70.0 4 6 57 0   3     0   0   37 33                 70
1374253 1374253 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_7 4 98 4 0   0     0   1   47 60 *                     107.0 4 98 4 0   0     0   1   47 60                 107
1368002 1368002 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2020   grade_7 5 2 114 0   0     0   2   61 62 *                     123.0 5 2 114 0   0     0   2   61 62                 123
1371023 1371023 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2020   grade_7 5 11 115 0   1     0   0   73 59 *                     132.0 5 11 115 0   1     0   0   73 59                 132
1371026 1371026 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2020   grade_7 5 18 113 0   0     0   1   79 58 *                     137.0 5 18 113 0   0     0   1   79 58                 137
1371032 1371032 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2020   grade_7 5 7 38 0   0     0   2   14 38 *                     52.0 5 7 38 0   0     0   2   14 38                 52
1365410 1365410 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2020   grade_7 6 1 97 0   1     0   0   55 50 *                     105.0 6 1 97 0   1     0   0   55 50                 105
1365652 1365652 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_7 6 5 5 0   2     0   2   9 11 *                     20.0 6 5 5 0   2     0   2   9 11                 20
1365668 1365668 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2020   grade_7 6 25 41 0   0     0   3   41 34 *                     75.0 6 25 41 0   0     0   3   41 34                 75
1365750 1365750 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2020   grade_7 6 8 20 0   2     0   2   22 16 *                     38.0 6 8 20 0   2     0   2   22 16                 38
1365820 1365820 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2020   grade_7 6 11 38 0   4     0   3   33 29 *                     62.0 6 11 38 0   4     0   3   33 29                 62
1367850 1367850 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2020   grade_7 6 0 42 0   0     0   0   21 27 *                     48.0 6 0 42 0   0     0   0   21 27                 48
1368038 1368038 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2020   grade_7 6 1 65 0   1     0   1   36 38 *                     74.0 6 1 65 0   1     0   1   36 38                 74
1370703 1370703 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2020   grade_7 6 10 35 0   3     0   0   25 29 *                     54.0 6 10 35 0   3     0   0   25 29                 54
1371039 1371039 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2020   grade_7 6 19 77 0   0     0   4   63 43 *                     106.0 6 19 77 0   0     0   4   63 43                 106
1372461 1372461 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2020   grade_7 6 26 27 0   0     0   3   33 29 *                     62.0 6 26 27 0   0     0   3   33 29                 62
1366018 1366018 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2020   grade_7 7 1 142 1   1     0   1   75 78 *                     153.0 7 1 142 1   1     0   1   75 78                 153
1366021 1366021 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2020   grade_7 7 67 35 0   2     0   5   58 58 *                     116.0 7 67 35 0   2     0   5   58 58                 116
1366592 1366592 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2020   grade_7 7 8 112 0   0     0   2   58 71 *                     129.0 7 8 112 0   0     0   2   58 71                 129
1372654 1372654 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 11 2020   grade_7 7 39 21 1   1     0   1   42 28 *                     70.0 7 39 21 1   1     0   1   42 28                 70
1365529 1365529 MA Suffolk   school 2502790 35   Boston 250279000269 350179 John W McCormack   Regular School No Middle 06 08 2020   grade_7 8 36 61 1   3     0   2   48 63 *                     111.0 8 36 61 1   3     0   2   48 63                 111

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