Data source: Big Local News · About: Big Local

500 rows where grade = "grade_8", state = "MA" and year = 2020 sorted by ccd_school_lvl

View and edit SQL

year

  • 2020 · 500

grade

  • grade_8 · 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
1365282 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2020   grade_8 3 2 6 0   0     0   2   7 6 *                     13.0 3 2 6 0   0     0   2   7 6                 13
1365306 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2020   grade_8 0 8 14 0   0     0   1   10 13 *                     23.0 0 8 14 0   0     0   1   10 13                 23
1365316 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2020   grade_8 3 16 14 0   2     0   2   22 15 *                     37.0 3 16 14 0   2     0   2   22 15                 37
1365340 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2020   grade_8 4 24 59 0   1     0   1   48 41 *                     89.0 4 24 59 0   1     0   1   48 41                 89
1365401 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2020   grade_8 1 7 11 0   0     0   4   13 10 *                     23.0 1 7 11 0   0     0   4   13 10                 23
1365411 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2020   grade_8 9 2 89 0   0     0   1   46 55 *                     101.0 9 2 89 0   0     0   1   46 55                 101
1365428 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2020   grade_8 9 2 12 0   3     0   1   15 12 *                     27.0 9 2 12 0   3     0   1   15 12                 27
1365445 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2020   grade_8 5 21 11 0   0     0   1   14 24 *                     38.0 5 21 11 0   0     0   1   14 24                 38
1365483 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Condon K-8   Regular School No Elementary PK 08 2020   grade_8 9 23 33 0   4     0   2   43 28 *                     71.0 9 23 33 0   4     0   2   43 28                 71
1365492 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2020   grade_8 3 14 30 0   2     0   3   27 25 *                     52.0 3 14 30 0   2     0   3   27 25                 52
1365554 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2020   grade_8 0 0 15 0   0     0   0   9 6 *                     15.0 0 0 15 0   0     0   0   9 6                 15
1365564 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2020   grade_8 1 30 15 0   2     0   3   28 23 *                     51.0 1 30 15 0   2     0   3   28 23                 51
1365581 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2020   grade_8 8 3 8 0   0     0   1   8 12 *                     20.0 8 3 8 0   0     0   1   8 12                 20
1365612 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2020   grade_8 0 9 21 0   3     0   0   19 14 *                     33.0 0 9 21 0   3     0   0   19 14                 33
1365636 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2020   grade_8 4 16 32 0   25     0   2   41 38 *                     79.0 4 16 32 0   25     0   2   41 38                 79
1365653 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2020   grade_8 10 9 8 0   0     0   1   15 13 *                     28.0 10 9 8 0   0     0   1   15 13                 28
1365663 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2020   grade_8 2 52 38 1   0     0   1   45 49 *                     94.0 2 52 38 1   0     0   1   45 49                 94
1365679 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2020   grade_8 5 10 19 0   0     0   3   22 15 *                     37.0 5 10 19 0   0     0   3   22 15                 37
1365741 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2020   grade_8 0 10 13 0   0     0   0   16 7 *                     23.0 0 10 13 0   0     0   0   16 7                 23
1365751 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2020   grade_8 1 6 28 0   1     0   2   22 16 *                     38.0 1 6 28 0   1     0   2   22 16                 38
1365768 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2020   grade_8 10 5 15 0   2     0   0   12 20 *                     32.0 10 5 15 0   2     0   0   12 20                 32
1365804 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2020   grade_8 0 10 12 0   0     0   5   15 12 *                     27.0 0 10 12 0   0     0   5   15 12                 27
1365821 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2020   grade_8 9 14 45 0   4     0   0   43 29 *                     72.0 9 14 45 0   4     0   0   43 29                 72
1365831 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2020   grade_8 0 21 16 0   0     0   3   17 23 *                     40.0 0 21 16 0   0     0   3   17 23                 40
1365847 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2020   grade_8 3 61 21 2   1     0   3   44 47 *                     91.0 3 61 21 2   1     0   3   44 47                 91
1365857 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2020   grade_8 0 19 18 0   0     0   1   23 15 *                     38.0 0 19 18 0   0     0   1   23 15                 38
1365867 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2020   grade_8 0 3 9 0   0     0   2   10 4 *                     14.0 0 3 9 0   0     0   2   10 4                 14
1366019 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2020   grade_8 6 5 138 0   2     0   1   78 74 *                     152.0 6 5 138 0   2     0   1   78 74                 152
1366041 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2020   grade_8 0 0 15 0   0     0   0   4 11 *                     15.0 0 0 15 0   0     0   0   4 11                 15
1366182 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2020   grade_8 19 79 15 0   0     1   6   65 55 *                     120.0 19 79 15 0   0     1   6   65 55                 120
1366274 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2020   grade_8 32 4 8 0   25     0   8   47 30 *                     77.0 32 4 8 0   25     0   8   47 30                 77
1366284 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Coolidge Corner School   Regular School No Elementary PK 08 2020   grade_8 45 4 14 0   12     0   8   40 43 *                     83.0 45 4 14 0   12     0   8   40 43                 83
1366293 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary KG 08 2020   grade_8 36 5 9 0   14     0   14   40 38 *                     78.0 36 5 9 0   14     0   14   40 38                 78
1366303 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2020   grade_8 34 2 3 0   11     0   3   31 22 *                     53.0 34 2 3 0   11     0   3   31 22                 53
1366312 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2020   grade_8 35 2 15 0   11     0   9   39 33 *                     72.0 35 2 15 0   11     0   9   39 33                 72
1366321 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2020   grade_8 27 8 9 0   13     0   3   30 30 *                     60.0 27 8 9 0   13     0   3   30 30                 60
1366330 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2020   grade_8 39 7 15 0   9     0   5   40 35 *                     75.0 39 7 15 0   9     0   5   40 35                 75
1366340 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2020   grade_8 35 2 10 0   7     0   9   35 28 *                     63.0 35 2 10 0   7     0   9   35 28                 63
1366396 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2020   grade_8 13 0 21 0   1     0   2   12 25 *                     37.0 13 0 21 0   1     0   2   12 25                 37
1366520 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2020   grade_8 52 0 4 0   5     0   10   38 33 *                     71.0 52 0 4 0   5     0   10   38 33                 71
1366690 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_8 14 1 0 0   0     0   1   7 9 *                     16.0 14 1 0 0   0     0   1   7 9                 16
1367018 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2020   grade_8 28 2 5 0   0     0   1   17 19 *                     36.0 28 2 5 0   0     0   1   17 19                 36
1367037 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2020   grade_8 10 7 34 1   4     0   2   29 29 *                     58.0 10 7 34 1   4     0   2   29 29                 58
1367053 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2020   grade_8 37 9 43 2   6     1   3   54 47 *                     101.0 37 9 43 2   6     1   3   54 47                 101
1367062 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2020   grade_8 32 23 63 1   12     0   1   68 64 *                     132.0 32 23 63 1   12     0   1   68 64                 132
1367078 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2020   grade_8 21 21 55 1   6     0   5   45 64 *                     109.0 21 21 55 1   6     0   5   45 64                 109
1367087 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2020   grade_8 10 18 103 0   3     0   0   65 69 *                     134.0 10 18 103 0   3     0   0   65 69                 134
1367150 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2020   grade_8 19 7 17 0   2     0   5   33 17 *                     50.0 19 7 17 0   2     0   5   33 17                 50
1367160 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2020   grade_8 22 3 8 0   3     0   5   22 19 *                     41.0 22 3 8 0   3     0   5   22 19                 41
1367279 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2020   grade_8 21 4 34 0   4     0   3   35 31 *                     66.0 21 4 34 0   4     0   3   35 31                 66
1367298 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_8 7 0 0 0   0     0   0   1 6 *                     7.0 7 0 0 0   0     0   0   1 6                 7
1367662 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2020   grade_8 153 11 40 0   5     1   4   111 103 *                     214.0 153 11 40 0   5     1   4   111 103                 214
1367805 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2020   grade_8 14 0 35 0   0     0   0   25 24 *                     49.0 14 0 35 0   0     0   0   25 24                 49
1367824 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2020   grade_8 0 2 37 0   0     0   0   24 15 *                     39.0 0 2 37 0   0     0   0   24 15                 39
1367841 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary PK 08 2020   grade_8 10 4 44 0   0     0   0   29 29 *                     58.0 10 4 44 0   0     0   0   29 29                 58
1367851 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2020   grade_8 5 1 35 0   0     0   0   15 26 *                     41.0 5 1 35 0   0     0   0   15 26                 41
1368039 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2020   grade_8 0 1 65 0   2     0   0   31 37 *                     68.0 0 1 65 0   2     0   0   31 37                 68
1368226 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2020   grade_8 43 2 5 1   4     0   3   30 28 *                     58.0 43 2 5 1   4     0   3   30 28                 58
1368290 MA Middlesex   school 2507020 160   Lowell 250702002761 1600005 Rogers STEM Academy   Regular School No Elementary KG 08 2020   grade_8 16 8 24 0   10     0   0   39 19 *                     58.0 16 8 24 0   10     0   0   39 19                 58
1368312 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2020   grade_8 24 2 26 0   5     0   2   31 28 *                     59.0 24 2 26 0   5     0   2   31 28                 59
1368380 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2020   grade_8 12 6 18 0   22     0   2   27 33 *                     60.0 12 6 18 0   22     0   2   27 33                 60
1368643 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2020   grade_8 27 19 15 0   41     1   1   58 46 *                     104.0 27 19 15 0   41     1   1   58 46                 104
1368652 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2020   grade_8 20 18 42 0   19     0   7   45 61 *                     106.0 20 18 42 0   19     0   7   45 61                 106
1368661 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2020   grade_8 24 11 14 0   6     0   2   37 20 *                     57.0 24 11 14 0   6     0   2   37 20                 57
1368670 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2020   grade_8 41 17 15 1   17     0   3   48 45 *                     94.0 41 17 15 1   17     0   3   48 45                 94
1368680 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2020   grade_8 35 28 49 0   24     0   2   70 68 *                     138.0 35 28 49 0   24     0   2   70 68                 138
1368947 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2020   grade_8 77 1 46 0   10     0   7   70 71 *                     141.0 77 1 46 0   10     0   7   70 71                 141
1368957 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2020   grade_8 63 4 32 0   5     0   2   44 62 *                     106.0 63 4 32 0   5     0   2   44 62                 106
1368967 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2020   grade_8 59 2 87 0   5     0   12   93 72 *                     165.0 59 2 87 0   5     0   12   93 72                 165
1368977 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No Elementary PK 08 2020   grade_8 69 3 76 0   3     0   7   78 80 *                     158.0 69 3 76 0   3     0   7   78 80                 158
1369794 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2020   grade_8 32 3 7 1   1     0   3   19 28 *                     47.0 32 3 7 1   1     0   3   19 28                 47
1370099 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_8 6 4 3 0   0     0   2   7 8 *                     15.0 6 4 3 0   0     0   2   7 8                 15
1370333 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2020   grade_8 18 0 3 0   0     0   1   12 10 *                     22.0 18 0 3 0   0     0   1   12 10                 22
1370416 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No Elementary KG 08 2020   grade_8 22 1 16 0   1     0   4   21 23 *                     44.0 22 1 16 0   1     0   4   21 23                 44
1370656 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2020   grade_8 19 7 17 0   3     0   0   17 29 *                     46.0 19 7 17 0   3     0   0   17 29                 46
1370665 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No Elementary PK 08 2020   grade_8 50 3 8 0   3     0   3   37 30 *                     67.0 50 3 8 0   3     0   3   37 30                 67
1370675 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2020   grade_8 17 6 12 0   7     0   3   26 19 *                     45.0 17 6 12 0   7     0   3   26 19                 45
1370684 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No Elementary KG 08 2020   grade_8 10 5 63 0   4     0   0   42 40 *                     82.0 10 5 63 0   4     0   0   42 40                 82
1370694 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2020   grade_8 17 4 5 0   2     0   1   14 15 *                     29.0 17 4 5 0   2     0   1   14 15                 29
1370704 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2020   grade_8 8 13 32 0   6     0   1   35 25 *                     60.0 8 13 32 0   6     0   1   35 25                 60
1370886 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2020   grade_8 5 10 14 0   0     0   1   12 18 *                     30.0 5 10 14 0   0     0   1   12 18                 30
1371336 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_8 17 2 10 2   0     0   7   17 21 *                     38.0 17 2 10 2   0     0   7   17 21                 38
1372451 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_8 16 6 21 0   0     0   0   22 21 *                     43.0 16 6 21 0   0     0   0   22 21                 43
1372505 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 08 2020   grade_8 0 15 6 0   0     0   1   10 12 *                     22.0 0 15 6 0   0     0   1   10 12                 22
1372533 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_8 0 0 32 0   1     0   0   14 19 *                     33.0 0 0 32 0   1     0   0   14 19                 33
1372576 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_8 0 0 30 0   0     0   0   18 12 *                     30.0 0 0 30 0   0     0   0   18 12                 30
1372622 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2020   grade_8 0 15 9 0   0     0   0   7 17 *                     24.0 0 15 9 0   0     0   0   7 17                 24
1372632 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_8 2 0 30 0   0     0   0   10 22 *                     32.0 2 0 30 0   0     0   0   10 22                 32
1372693 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2020   grade_8 36 0 2 0   11     0   3   21 31 *                     52.0 36 0 2 0   11     0   3   21 31                 52
1372710 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2020   grade_8 17 2 4 0   0     0   4   15 12 *                     27.0 17 2 4 0   0     0   4   15 12                 27
1372723 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes Elementary KG 08 2020   grade_8 4 1 59 0   0     0   0   31 33 *                     64.0 4 1 59 0   0     0   0   31 33                 64
1372733 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_8 1 0 47 0   0     0   0   20 28 *                     48.0 1 0 47 0   0     0   0   20 28                 48
1372742 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_8 22 3 8 0   0     0   2   13 22 *                     35.0 22 3 8 0   0     0   2   13 22                 35
1372752 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_8 3 22 26 0   18     0   2   39 32 *                     71.0 3 22 26 0   18     0   2   39 32                 71
1372765 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_8 0 39 18 0   0     0   1   24 34 *                     58.0 0 39 18 0   0     0   1   24 34                 58
1372849 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2020   grade_8 22 0 2 0   1     0   1   7 18 *                     26.0 22 0 2 0   1     0   1   7 18                 26
1372881 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2020   grade_8 5 35 29 0   0     0   1   41 29 *                     70.0 5 35 29 0   0     0   1   41 29                 70
1373456 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2020   grade_8 10 1 1 0   0     0   1   7 6 *                     13.0 10 1 1 0   0     0   1   7 6                 13
1373669 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2020   grade_8 56 0 2 0   11     0   2   36 35 *                     71.0 56 0 2 0   11     0   2   36 35                 71
1373956 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_8 37 0 2 1   1     0   3   29 15 *                     44.0 37 0 2 1   1     0   3   29 15                 44

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