Data source: Big Local News · About: Big Local

490 rows where grade = "grade_8", state = "MA" and year = 2017 sorted by ccd_school_lvl

View and edit SQL

year

  • 2017 · 490

grade

  • grade_8 · 490
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
1122569 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No Elementary KG 08 2017   grade_8 11 1 3 0   1     0   1   10 7                       17 11 1 3 0   1     0   1   10 7                 17
1122598 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2017   grade_8 5 10 16 0   2     0   2   17 18                       35 5 10 16 0   2     0   2   17 18                 35
1122609 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No Elementary PK 08 2017   grade_8 8 30 32 0   5     0   1   50 26                       76 8 30 32 0   5     0   1   50 26                 76
1122630 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No Elementary PK 08 2017   grade_8 0 18 67 0   0     0   0   40 45                       85 0 18 67 0   0     0   0   40 45                 85
1122702 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2017   grade_8 5 24 20 0   0     0   2   18 33                       51 5 24 20 0   0     0   2   18 33                 51
1122713 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2017   grade_8 8 5 78 0   0     0   1   54 38                       92 8 5 78 0   0     0   1   54 38                 92
1122732 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2017   grade_8 7 7 11 0   2     0   0   17 10                       27 7 7 11 0   2     0   0   17 10                 27
1122751 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2017   grade_8 4 23 25 0   1     0   0   25 28                       53 4 23 25 0   1     0   0   25 28                 53
1122803 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2017   grade_8 0 16 36 0   0     1   0   31 22                       53 0 16 36 0   0     1   0   31 22                 53
1122874 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2017   grade_8 0 0 17 0   0     0   0   5 12                       17 0 0 17 0   0     0   0   5 12                 17
1122885 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No Elementary PK 08 2017   grade_8 4 39 23 0   5     0   1   44 28                       72 4 39 23 0   5     0   1   44 28                 72
1122904 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2017   grade_8 10 5 5 0   3     0   1   9 15                       24 10 5 5 0   3     0   1   9 15                 24
1122947 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2017   grade_8 0 10 37 0   0     0   0   26 21                       47 0 10 37 0   0     0   0   26 21                 47
1122973 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No Elementary PK 08 2017   grade_8 10 23 19 0   27     1   7   55 32                       87 10 23 19 0   27     1   7   55 32                 87
1122992 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_8 8 3 5 0   0     1   3   13 7                       20 8 3 5 0   0     1   3   13 7                 20
1123003 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No Elementary PK 08 2017   grade_8 3 24 41 0   2     0   1   36 35                       71 3 24 41 0   2     0   1   36 35                 71
1123010 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Elementary 03 08 2017   grade_8 9 25 45 0   2     0   5   58 28                       86 9 25 45 0   2     0   5   58 28                 86
1123021 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2017   grade_8 5 9 23 0   0     0   0   20 17                       37 5 9 23 0   0     0   0   20 17                 37
1123093 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_8 1 9 24 0   0     0   0   16 18                       34 1 9 24 0   0     0   0   16 18                 34
1123104 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2017   grade_8 5 5 23 0   1     0   1   24 11                       35 5 5 23 0   1     0   1   24 11                 35
1123123 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2017   grade_8 11 9 9 1   2     0   0   19 13                       32 11 9 9 1   2     0   0   19 13                 32
1123162 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2017   grade_8 1 19 6 0   0     0   0   9 17                       26 1 19 6 0   0     0   0   9 17                 26
1123181 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2017   grade_8 8 18 46 1   12     0   2   53 34                       87 8 18 46 1   12     0   2   53 34                 87
1123192 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2017   grade_8 0 15 10 0   1     0   3   16 13                       29 0 15 10 0   1     0   3   16 13                 29
1123201 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   grade_8 1 17 8 0   1     0   2   16 13                       29 1 17 8 0   1     0   2   16 13                 29
1123211 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2017   grade_8 2 65 20 2   1     0   0   50 40                       90 2 65 20 2   1     0   0   50 40                 90
1123222 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2017   grade_8 0 21 21 0   0     0   1   27 16                       43 0 21 21 0   0     0   1   27 16                 43
1123233 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2017   grade_8 1 4 7 0   0     0   0   7 5                       12 1 4 7 0   0     0   0   7 5                 12
1123411 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2017   grade_8 15 5 111 0   5     0   2   73 65                       138 15 5 111 0   5     0   2   73 65                 138
1123440 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2017   grade_8 0 1 24 0   0     0   0   12 13                       25 0 1 24 0   0     0   0   12 13                 25
1123622 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_8 23 57 15 0   0     1   3   49 50                       99 23 57 15 0   0     1   3   49 50                 99
1123734 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2017   grade_8 39 3 11 0   19     1   6   42 37                       79 39 3 11 0   19     1   6   42 37                 79
1123744 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No Elementary KG 08 2017   grade_8 44 5 10 0   8     0   8   39 36                       75 44 5 10 0   8     0   8   39 36                 75
1123755 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No Elementary PK 08 2017   grade_8 39 3 4 0   8     0   4   26 32                       58 39 3 4 0   8     0   4   26 32                 58
1123766 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2017   grade_8 38 2 4 0   11     0   2   25 31                       57 38 2 4 0   11     0   2   25 31                 57
1123776 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No Elementary KG 08 2017   grade_8 27 5 4 0   18     0   7   28 33                       61 27 5 4 0   18     0   7   28 33                 61
1123786 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2017   grade_8 28 5 9 0   11     0   8   33 28                       61 28 5 9 0   11     0   8   33 28                 61
1123796 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No Elementary KG 08 2017   grade_8 40 10 11 0   11     0   8   38 42                       80 40 10 11 0   11     0   8   38 42                 80
1123807 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No Elementary PK 08 2017   grade_8 34 2 6 0   12     0   6   30 30                       60 34 2 6 0   12     0   6   30 30                 60
1123872 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2017   grade_8 10 2 13 0   0     0   2   8 19                       27 10 2 13 0   0     0   2   8 19                 27
1124016 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2017   grade_8 54 0 0 0   9     0   5   35 33                       68 54 0 0 0   9     0   5   35 33                 68
1124215 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_8 16 0 0 0   0     0   0   6 10                       16 16 0 0 0   0     0   0   6 10                 16
1124227 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_8 93 12 28 0   2     0   4   70 69                       139 93 12 28 0   2     0   4   70 69                 139
1124605 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2017   grade_8 34 1 4 1   0     0   0   15 25                       40 34 1 4 1   0     0   0   15 25                 40
1124626 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2017   grade_8 4 3 25 0   3     0   0   19 16                       35 4 3 25 0   3     0   0   19 16                 35
1124643 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2017   grade_8 29 10 31 0   5     0   2   44 33                       77 29 10 31 0   5     0   2   44 33                 77
1124653 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2017   grade_8 34 14 39 0   11     0   3   53 48                       101 34 14 39 0   11     0   3   53 48                 101
1124672 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2017   grade_8 24 22 37 0   8     0   3   41 53                       94 24 22 37 0   8     0   3   41 53                 94
1124682 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2017   grade_8 17 30 52 0   3     0   2   48 56                       104 17 30 52 0   3     0   2   48 56                 104
1124752 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2017   grade_8 42 5 10 0   4     0   5   33 33                       66 42 5 10 0   4     0   5   33 33                 66
1124763 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2017   grade_8 26 2 20 0   3     0   2   30 23                       53 26 2 20 0   3     0   2   30 23                 53
1124820 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_8 2 1 3 0   0     0   0   6 *                       6 2 1 3 0   0     0   0   6                   6
1124906 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2017   grade_8 23 6 34 0   3     0   9   27 48                       75 23 6 34 0   3     0   9   27 48                 75
1125268 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125450 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_8 134 7 86 0   3     0   2   120 112                       232 134 7 86 0   3     0   2   120 112                 232
1125553 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   grade_8 10 0 33 1   0     0   0   29 15                       44 10 0 33 1   0     0   0   29 15                 44
1125564 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   grade_8 0 0 39 0   0     0   0   19 20                       39 0 0 39 0   0     0   0   19 20                 39
1125570 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Elementary 04 08 2017   grade_8 5 0 65 0   0     0   0   37 33                       70 5 0 65 0   0     0   0   37 33                 70
1125580 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary KG 08 2017   grade_8 1 0 40 0   2     0   0   17 26                       43 1 0 40 0   2     0   0   17 26                 43
1125591 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No Elementary PK 08 2017   grade_8 8 0 35 0   0     0   2   21 24                       45 8 0 35 0   0     0   2   21 24                 45
1125601 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2017   grade_8 5 1 47 0   2     0   1   29 27                       56 5 1 47 0   2     0   1   29 27                 56
1125612 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2017   grade_8 9 4 35 0   1     0   0   28 21                       49 9 4 35 0   1     0   0   28 21                 49
1125783 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_8 1 1 80 0   3     0   0   44 41                       85 1 1 80 0   3     0   0   44 41                 85
1125853 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2017   grade_8 4 0 87 0   4     0   1   52 44                       96 4 0 87 0   4     0   1   52 44                 96
1126084 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2017   grade_8 46 7 6 0   8     0   5   28 44                       72 46 7 6 0   8     0   5   28 44                 72
1126090 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Elementary 04 08 2017   grade_8 14 6 7 0   2     0   5   20 14                       34 14 6 7 0   2     0   5   20 14                 34
1126183 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2017   grade_8 29 7 7 0   8     0   2   21 32                       53 29 7 7 0   8     0   2   21 32                 53
1126263 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2017   grade_8 12 4 22 0   17     0   4   38 21                       59 12 4 22 0   17     0   4   38 21                 59
1126549 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2017   grade_8 30 12 13 0   24     1   4   43 41                       84 30 12 13 0   24     1   4   43 41                 84
1126559 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2017   grade_8 29 20 22 1   26     0   5   70 33                       103 29 20 22 1   26     0   5   70 33                 103
1126569 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2017   grade_8 24 11 16 0   5     0   0   30 26                       56 24 11 16 0   5     0   0   30 26                 56
1126579 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2017   grade_8 39 13 15 0   19     0   3   45 44                       89 39 13 15 0   19     0   3   45 44                 89
1126591 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2017   grade_8 25 30 25 0   27     0   7   57 57                       114 25 30 25 0   27     0   7   57 57                 114
1126923 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2017   grade_8 103 0 29 0   3     0   6   69 72                       141 103 0 29 0   3     0   6   69 72                 141
1126934 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2017   grade_8 83 0 48 0   7     0   5   72 71                       143 83 0 48 0   7     0   5   72 71                 143
1126945 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2017   grade_8 61 0 56 0   11     0   7   70 65                       135 61 0 56 0   11     0   7   70 65                 135
1126956 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No Elementary PK 08 2017   grade_8 72 0 67 1   3     0   8   83 68                       151 72 0 67 1   3     0   8   83 68                 151
1127922 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2017   grade_8 33 3 7 1   1     0   3   24 24                       48 33 3 7 1   1     0   3   24 24                 48
1128280 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   grade_8 9 1 4 0   0     0   3   11 6                       17 9 1 4 0   0     0   3   11 6                 17
1128556 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_8 5 1 1 0   0     0   1   2 6                       8 5 1 1 0   0     0   1   2 6                 8
1128644 MA Essex   school 2510380 258   Salem 251038002559 2580025 Nathaniel Bowditch   Regular School No Elementary KG 08 2017   grade_8 5 1 31 0   0     0   0   19 18                       37 5 1 31 0   0     0   0   19 18                 37
1128661 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No Elementary KG 08 2017   grade_8 24 0 10 0   0     0   3   13 24                       37 24 0 10 0   0     0   3   13 24                 37
1128952 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No Elementary PK 08 2017   grade_8 11 5 18 0   4     0   2   21 19                       40 11 5 18 0   4     0   2   21 19                 40
1128963 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No Elementary PK 08 2017   grade_8 39 6 10 0   0     0   0   30 25                       55 39 6 10 0   0     0   0   30 25                 55
1128974 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   grade_8 19 3 13 0   2     0   0   17 20                       37 19 3 13 0   2     0   0   17 20                 37
1128984 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No Elementary KG 08 2017   grade_8 13 3 36 0   2     0   1   31 24                       55 13 3 36 0   2     0   1   31 24                 55
1128995 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2017   grade_8 19 4 10 0   2     0   3   20 18                       38 19 4 10 0   2     0   3   20 18                 38
1129006 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2017   grade_8 12 6 29 0   5     0   0   28 24                       52 12 6 29 0   5     0   0   28 24                 52
1129217 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   grade_8 8 8 8 0   1     0   1   13 13                       26 8 8 8 0   1     0   1   13 13                 26
1129747 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_8 24 1 7 1   1     0   2   17 19                       36 24 1 7 1   1     0   2   17 19                 36
1131288 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2017   grade_8 1 16 4 0   0     0   1   11 11                       22 1 16 4 0   0     0   1   11 11                 22
1131299 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 2017   grade_8 2 0 44 0   0     0   0   24 22                       46 2 0 44 0   0     0   0   24 22                 46
1131324 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Elementary PK 08 2017   grade_8 7 26 9 0   2     0   0   24 20                       44 7 26 9 0   2     0   0   24 20                 44
1131362 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 2017   grade_8 29 0 1 0   14     0   2   32 14                       46 29 0 1 0   14     0   2   32 14                 46
1131381 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2017   grade_8 27 0 2 0   0     0   0   16 13                       29 27 0 2 0   0     0   0   16 13                 29
1131396 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes Elementary KG 08 2017   grade_8 4 4 59 0   0     0   1   30 38                       68 4 4 59 0   0     0   1   30 38                 68
1131407 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2017   grade_8 1 0 54 0   0     0   0   26 29                       55 1 0 54 0   0     0   0   26 29                 55
1131417 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 2017   grade_8 26 2 6 0   0     0   0   13 21                       34 26 2 6 0   0     0   0   13 21                 34
1131428 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2017   grade_8 1 21 31 0   16     0   2   33 38                       71 1 21 31 0   16     0   2   33 38                 71
1131441 MA Essex   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2017   grade_8 0 42 19 0   0     0   1   37 25                       62 0 42 19 0   0     0   1   37 25                 62

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