Data source: Big Local News · About: Big Local

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

View and edit SQL

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 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 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_6 * * * *   *     *   *   1 * *                     1.0                         1                   1
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 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 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 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 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 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1365190 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_6 107 0 1 0   0     0   6   59 55 *                     114.0 107 0 1 0   0     0   6   59 55                 114
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
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 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 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
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
1365855 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_6 1 45 26 0   0     0   2   38 36 *                     74.0 1 45 26 0   0     0   2   38 36                 74
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
1366020 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2020   grade_6 3 61 40 0   0     0   5   51 58 *                     109.0 3 61 40 0   0     0   5   51 58                 109
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 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
1366180 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_6 17 79 22 1   0     0   8   61 66 *                     127.0 17 79 22 1   0     0   8   61 66                 127
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
1366262 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_6 34 0 1 0   0     0   2   16 21 *                     37.0 34 0 1 0   0     0   2   16 21                 37
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
1366591 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2020   grade_6 7 8 113 0   0     0   6   77 57 *                     134.0 7 8 113 0   0     0   6   77 57                 134
1366599 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2020   grade_6 11 9 136 0   0     0   2   91 67 *                     158.0 11 9 136 0   0     0   2   91 67                 158
1366688 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_6 33 0 0 0   0     0   1   14 20 *                     34.0 33 0 0 0   0     0   1   14 20                 34
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
1367016 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2020   grade_6 26 3 9 1   0     0   2   17 24 *                     41.0 26 3 9 1   0     0   2   17 24                 41
1367026 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2020   grade_6 14 1 0 0   0     0   3   12 6 *                     18.0 14 1 0 0   0     0   3   12 6                 18
1367064 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2020   grade_6 4 2 2 0   0     0   1   8 1 *                     9.0 4 2 2 0   0     0   1   8 1                 9
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
1367468 MA Essex   school 2505220 105   Georgetown 250522000765 1050010 Penn Brook   Regular School No Elementary KG 06 2020   grade_6 112 1 1 0   0     1   1   59 57 *                     116.0 112 1 1 0   0     1   1   59 57                 116
1367594 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2020   grade_6 76 1 2 1   0     0   3   39 44 *                     83.0 76 1 2 1   0     0   3   39 44                 83
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 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
1367803 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2020   grade_6 13 1 27 0   0     0   2   25 18 *                     43.0 13 1 27 0   0     0   2   25 18                 43
1367814 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2020   grade_6 4 2 53 0   0     0   1   35 25 *                     60.0 4 2 53 0   0     0   1   35 25                 60
1367839 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2020   grade_6 3 1 58 0   0     0   1   36 27 *                     63.0 3 1 58 0   0     0   1   36 27                 63
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 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
1367926 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2020   grade_6 60 0 0 0   0     0   1   36 25 *                     61.0 60 0 0 0   0     0   1   36 25                 61
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
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 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 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 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 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
1368434 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2020   grade_6 158 4 38 2   0     0   6   107 101 *                     208.0 158 4 38 2   0     0   6   107 101                 208
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
1368820 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2020   grade_6 79 4 13 0   0     0   3   42 57 *                     99.0 79 4 13 0   0     0   3   42 57                 99
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
1369334 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2020   grade_6 101 43 128 1   0     1   14   146 142 *                     288.0 101 43 128 1   0     1   14   146 142                 288
1369343 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2020   grade_6 6 2 2 0   0     0   1   9 2 *                     11.0 6 2 2 0   0     0   1   9 2                 11
1369497 MA Berkshire   school 2508670 209   North Adams 250867001388 2090008 Colegrove Park Elementary   Regular School No Elementary PK 06 2020   grade_6 24 3 2 0   0     0   2   16 15 *                     31.0 24 3 2 0   0     0   2   16 15                 31
1369505 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary PK 06 2020   grade_6 24 1 2 0   0     1   4   17 15 *                     32.0 24 1 2 0   0     1   4   17 15                 32
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
1369675 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No Elementary PK 06 2020   grade_6 41 1 2 0   0     0   4   31 17 *                     48.0 41 1 2 0   0     0   4   31 17                 48
1369915 MA Plymouth   school 2509420 231   Pembroke 250942001508 2310003 Bryantville Elementary   Regular School No Elementary KG 06 2020   grade_6 68 0 0 0   0     0   2   27 43 *                     70.0 68 0 0 0   0     0   2   27 43                 70
1369922 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No Elementary KG 06 2020   grade_6 55 1 0 0   0     0   1   40 17 *                     57.0 55 1 0 0   0     0   1   40 17                 57
1370069 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 06 08 2020   grade_6 195 1 10 1   0     0   5   112 100 *                     212.0 195 1 10 1   0     0   5   112 100                 212
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
1370097 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_6 10 2 2 0   0     0   3   9 8 *                     17.0 10 2 2 0   0     0   3   9 8                 17
1370331 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2020   grade_6 11 0 2 0   0     0   1   4 10 *                     14.0 11 0 2 0   0     0   1   4 10                 14
1370341 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester Memorial   Regular School No Elementary PK 06 2020   grade_6 60 0 1 0   0     0   7   36 32 *                     68.0 60 0 1 0   0     0   7   36 32                 68
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
1370616 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2020   grade_6 9 0 1 0   0     0   3   4 9 *                     13.0 9 0 1 0   0     0   3   4 9                 13
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
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 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
1371025 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2020   grade_6 4 11 115 0   0     0   1   69 62 *                     131.0 4 11 115 0   0     0   1   69 62                 131
1371031 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2020   grade_6 10 5 37 0   0     0   2   15 39 *                     54.0 10 5 37 0   0     0   2   15 39                 54
1371191 MA Franklin   school 2511370 289   Sunderland 251137001878 2890005 Sunderland Elementary   Regular School No Elementary PK 06 2020   grade_6 24 2 5 0   0     0   3   22 12 *                     34.0 24 2 5 0   0     0   3   22 12                 34
1371334 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_6 21 1 18 0   0     0   2   15 27 *                     42.0 21 1 18 0   0     0   2   15 27                 42
1371517 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Middle 04 06 2020   grade_6 88 2 8 0   0     0   3   55 46 *                     101.0 88 2 8 0   0     0   3   55 46                 101
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
1371828 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport Elementary   Regular School No Elementary 03 06 2020   grade_6 102 0 4 0   0     0   7   67 46 *                     113.0 102 0 4 0   0     0   7   67 46                 113
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
1372175 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2020   grade_6 11 3 59 0   0     0   1   34 40 *                     74.0 11 3 59 0   0     0   1   34 40                 74
1372251 MA Worcester   school 2513230 348   Worcester 251323002566 3480140 Jacob Hiatt Magnet   Regular School No Elementary PK 06 2020   grade_6 7 13 17 0   0     0   1   20 18 *                     38.0 7 13 17 0   0     0   1   20 18                 38
1372279 MA Worcester   school 2513230 348   Worcester 251323002214 3480177 Francis J McGrath Elementary   Regular School No Elementary KG 06 2020   grade_6 13 1 12 0   0     0   1   11 16 *                     27.0 13 1 12 0   0     0   1   11 16                 27
1372333 MA Worcester   school 2513230 348   Worcester 251323002245 3480225 Worcester Arts Magnet School   Regular School No Elementary PK 06 2020   grade_6 29 11 11 0   0     0   2   29 24 *                     53.0 29 11 11 0   0     0   2   29 24                 53
1372423 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2020   grade_6 10 0 0 0   0     0   1   5 6 *                     11.0 10 0 0 0   0     0   1   5 6                 11
1372449 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2020   grade_6 28 15 51 0   0     0   2   40 56 *                     96.0 28 15 51 0   0     0   2   40 56                 96
1372460 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_6 2 25 32 0   0     0   4   27 36 *                     63.0 2 25 32 0   0     0   4   27 36                 63
1372469 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 2020   grade_6 6 46 22 0   0     0   1   46 29 *                     75.0 6 46 22 0   0     0   1   46 29                 75
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 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 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 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
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 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 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
1372740 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2020   grade_6 29 0 4 0   0     0   1   14 20 *                     34.0 29 0 4 0   0     0   1   14 20                 34
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
1372777 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2020   grade_6 9 0 2 0   0     0   2   4 9 *                     13.0 9 0 2 0   0     0   2   4 9                 13
1372792 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_6 3 47 42 0   0     0   3   48 47 *                     95.0 3 47 42 0   0     0   3   48 47                 95
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 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
1372879 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2020   grade_6 5 42 26 0   0     0   2   37 38 *                     75.0 5 42 26 0   0     0   2   37 38                 75
1373037 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Hoosac Valley Middle School   Regular School No Middle 04 07 2020   grade_6 97 3 2 0   0     0   2   52 52 *                     104.0 97 3 2 0   0     0   2   52 52                 104

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