Data source: Big Local News · About: Big Local

3,459 rows where grade = "grade_8" and state = "MA" sorted by ccd_school_lvl

View and edit SQL

year

grade

  • grade_8 · 3,459
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
2230211 MA Suffolk   school   35   Boston   350652               2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
736182 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No 1 KG 08 2015   grade_8 6 6 2 0   4     0   1   13 6                       19 6 6 2 0   4     0   1   13 6                 19
736206 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No 1 PK 08 2015   grade_8 8 25 22 0   0     0   1   24 32                       56 8 25 22 0   0     0   1   24 32                 56
736216 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Jackson Mann   Regular School No 1 PK 08 2015   grade_8 5 18 40 0   5     0   2   34 36                       70 5 18 40 0   5     0   2   34 36                 70
736232 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Curley K-8 School   Regular School No 1 PK 08 2015   grade_8 1 31 78 1   1     0   2   62 52                       114 1 31 78 1   1     0   2   62 52                 114
736299 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No 1 KG 08 2015   grade_8 4 0 80 0   0     0   4   47 41                       88 4 0 80 0   0     0   4   47 41                 88
736322 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No 1 PK 08 2015   grade_8 6 4 16 0   4     0   1   14 17                       31 6 4 16 0   4     0   1   14 17                 31
736339 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No 1 PK 08 2015   grade_8 3 30 12 0   0     0   1   24 22                       46 3 30 12 0   0     0   1   24 22                 46
736442 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No 1 PK 08 2015   grade_8 0 0 12 0   0     0   1   7 6                       13 0 0 12 0   0     0   1   7 6                 13
736452 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Joseph Lee   Regular School No 1 PK 08 2015   grade_8 1 50 9 0   3     0   0   40 23                       63 1 50 9 0   3     0   0   40 23                 63
736469 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No 1 PK 08 2015   grade_8 9 3 7 0   2     0   3   11 13                       24 9 3 7 0   2     0   3   11 13                 24
736507 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No 1 PK 08 2015   grade_8 0 4 21 0   0     0   1   11 15                       26 0 4 21 0   0     0   1   11 15                 26
736530 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Richard J Murphy   Regular School No 1 PK 08 2015   grade_8 15 28 16 0   30     0   2   56 35                       91 15 28 16 0   30     0   2   56 35                 91
736547 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No 1 PK 08 2015   grade_8 13 11 7 0   1     0   0   18 14                       32 13 11 7 0   1     0   0   18 14                 32
736557 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Orchard Gardens   Regular School No 1 PK 08 2015   grade_8 0 41 43 0   0     2   0   39 47                       86 0 41 43 0   0     2   0   39 47                 86
736563 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No 1 03 08 2015   grade_8 7 45 46 0   0     0   0   56 42                       98 7 45 46 0   0     0   0   56 42                 98
736573 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No 1 PK 08 2015   grade_8 7 5 20 0   0     0   0   17 15                       32 7 5 20 0   0     0   0   17 15                 32
736638 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No 1 PK 08 2015   grade_8 1 10 18 0   0     0   1   14 16                       30 1 10 18 0   0     0   1   14 16                 30
736648 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No 1 PK 08 2015   grade_8 6 8 18 0   2     0   1   15 20                       35 6 8 18 0   2     0   1   15 20                 35
736665 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No 1 PK 08 2015   grade_8 17 5 21 0   1     0   3   27 20                       47 17 5 21 0   1     0   3   27 20                 47
736716 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No 1 PK 08 2015   grade_8 21 25 55 1   11     0   3   62 54                       116 21 25 55 1   11     0   3   62 54                 116
736726 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No 1 PK 08 2015   grade_8 0 14 8 0   0     1   1   14 10                       24 0 14 8 0   0     1   1   14 10                 24
736736 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No 1 PK 08 2015   grade_8 1 15 11 0   0     0   2   13 16                       29 1 15 11 0   0     0   2   13 16                 29
736752 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative Education School No 1 PK 08 2015   grade_8 1 25 23 1   2     0   1   24 29                       53 1 25 23 1   2     0   1   24 29                 53
736762 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No 1 PK 08 2015   grade_8 1 10 10 0   0     0   0   12 9                       21 1 10 10 0   0     0   0   12 9                 21
736921 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2015   grade_8 28 13 102 1   4     0   0   81 67                       148 28 13 102 1   4     0   0   81 67                 148
736949 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No 1 PK 08 2015   grade_8 0 1 27 0   0     0   0   17 11                       28 0 1 27 0   0     0   0   17 11                 28
737098 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2015   grade_8 20 73 12 0   2     0   3   55 55                       110 20 73 12 0   2     0   3   55 55                 110
737127 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No 1 KG 08 2015   grade_8 16 74 8 1   1     0   6   51 55                       106 16 74 8 1   1     0   6   51 55                 106
737195 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No 1 KG 08 2015   grade_8 48 2 8 0   11     0   0   33 36                       69 48 2 8 0   11     0   0   33 36                 69
737204 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Edward Devotion   Regular School No 1 KG 08 2015   grade_8 42 8 9 0   13     0   6   36 42                       78 42 8 9 0   13     0   6   36 42                 78
737214 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Michael Driscoll   Regular School No 1 PK 08 2015   grade_8 33 1 5 0   4     0   4   20 27                       47 33 1 5 0   4     0   4   20 27                 47
737224 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No 1 PK 08 2015   grade_8 32 2 5 0   3     0   4   20 26                       46 32 2 5 0   3     0   4   20 26                 46
737233 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Lawrence   Regular School No 1 KG 08 2015   grade_8 31 2 6 0   12     0   8   30 29                       59 31 2 6 0   12     0   8   30 29                 59
737242 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No 1 KG 08 2015   grade_8 32 4 10 0   10     0   1   25 32                       57 32 4 10 0   10     0   1   25 32                 57
737251 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Pierce   Regular School No 1 KG 08 2015   grade_8 51 10 7 0   16     0   6   44 46                       90 51 10 7 0   16     0   6   44 46                 90
737261 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 John D Runkle   Regular School No 1 PK 08 2015   grade_8 38 4 5 0   7     0   7   33 28                       61 38 4 5 0   7     0   7   33 28                 61
737318 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No 1 PK 08 2015   grade_8 8 2 13 0   0     0   1   8 16                       24 8 2 13 0   0     0   1   8 16                 24
737441 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No 1 PK 08 2015   grade_8 69 1 0 0   10     0   6   47 39                       86 69 1 0 0   10     0   6   47 39                 86
737608 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No 1 KG 08 2015   grade_8 24 0 1 0   0     0   1   12 14                       26 24 0 1 0   0     0   1   12 14                 26
737940 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No 1 PK 08 2015   grade_8 29 0 7 1   0     0   0   21 16                       37 29 0 7 1   0     0   0   21 16                 37
737958 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No 1 KG 08 2015   grade_8 12 7 20 2   4     0   1   21 25                       46 12 7 20 2   4     0   1   21 25                 46
737973 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No 1 KG 08 2015   grade_8 47 18 37 0   0     0   4   62 44                       106 47 18 37 0   0     0   4   62 44                 106
737982 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2015   grade_8 35 12 31 1   10     1   1   44 47                       91 35 12 31 1   10     1   1   44 47                 91
737997 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No 1 KG 08 2015   grade_8 44 19 30 0   5     0   0   52 46                       98 44 19 30 0   5     0   0   52 46                 98
738006 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No 1 KG 08 2015   grade_8 27 17 79 0   1     0   0   52 72                       124 27 17 79 0   1     0   0   52 72                 124
738075 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No 1 PK 08 2015   grade_8 18 5 13 1   1     0   2   17 23                       40 18 5 13 1   1     0   2   17 23                 40
738192 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No 1 PK 08 2015   grade_8 30 4 27 0   3     0   4   27 41                       68 30 4 27 0   3     0   4   27 41                 68
738212 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No 1 PK 08 2015   grade_8 10 0 1 0   0     0   0   4 7                       11 10 0 1 0   0     0   0   4 7                 11
738630 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 KG 08 2015   grade_8 118 5 90 0   6     0   1   113 107                       220 118 5 90 0   6     0   1   113 107                 220
738717 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2015   grade_8 11 0 23 0   0     0   0   16 18                       34 11 0 23 0   0     0   0   16 18                 34
738727 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2015   grade_8 1 1 30 0   0     0   1   21 12                       33 1 1 30 0   0     0   1   21 12                 33
738741 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2015   grade_8 0 0 58 0   2     0   0   30 30                       60 0 0 58 0   2     0   0   30 30                 60
738750 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 KG 08 2015   grade_8 8 3 37 0   0     0   0   26 22                       48 8 3 37 0   0     0   0   26 22                 48
738759 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2015   grade_8 12 3 36 0   0     0   1   28 24                       52 12 3 36 0   0     0   1   28 24                 52
738768 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No 1 KG 08 2015   grade_8 11 5 48 0   0     0   0   32 32                       64 11 5 48 0   0     0   0   32 32                 64
738909 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2015   grade_8 4 3 84 0   1     0   1   47 46                       93 4 3 84 0   1     0   1   47 46                 93
738968 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2015   grade_8 7 0 66 0   1     0   0   42 32                       74 7 0 66 0   1     0   0   42 32                 74
739181 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No 1 PK 08 2015   grade_8 32 3 7 0   6     0   4   25 27                       52 32 3 7 0   6     0   4   25 27                 52
739261 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No 1 PK 08 2015   grade_8 34 8 7 0   12     0   1   34 28                       62 34 8 7 0   12     0   1   34 28                 62
739330 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No 1 PK 08 2015   grade_8 14 6 15 0   19     0   1   25 30                       55 14 6 15 0   19     0   1   25 30                 55
739568 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No 1 KG 08 2015   grade_8 43 17 8 1   25     0   4   51 47                       98 43 17 8 1   25     0   4   51 47                 98
739577 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2015   grade_8 24 21 19 0   23     0   2   49 40                       89 24 21 19 0   23     0   2   49 40                 89
739586 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No 1 KG 08 2015   grade_8 27 7 10 0   2     0   2   24 24                       48 27 7 10 0   2     0   2   24 24                 48
739595 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No 1 KG 08 2015   grade_8 37 15 19 1   17     0   1   42 48                       90 37 15 19 1   17     0   1   42 48                 90
739605 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No 1 KG 08 2015   grade_8 28 22 30 0   30     0   5   59 56                       115 28 22 30 0   30     0   5   59 56                 115
739879 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2015   grade_8 99 5 35 0   3     0   1   71 72                       143 99 5 35 0   3     0   1   71 72                 143
739889 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No 1 PK 08 2015   grade_8 90 0 45 0   5     0   3   93 50                       143 90 0 45 0   5     0   3   93 50                 143
739899 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No 1 PK 08 2015   grade_8 87 4 60 0   3     1   2   79 78                       157 87 4 60 0   3     1   2   79 78                 157
739909 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No 1 PK 08 2015   grade_8 88 5 57 2   5     0   2   85 74                       159 88 5 57 2   5     0   2   85 74                 159
740738 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No 1 PK 08 2015   grade_8 20 0 2 1   0     1   1   16 9                       25 20 0 2 1   0     1   1   16 9                 25
741044 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No 1 PK 08 2015   grade_8 5 2 1 0   1     0   1   4 6                       10 5 2 1 0   1     0   1   4 6                 10
741277 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No 1 PK 08 2015   grade_8 8 0 0 0   2     0   0   5 5                       10 8 0 0 0   2     0   0   5 5                 10
741357 MA Essex   school 2510380 258   Salem 251038002559 2580025 Nathaniel Bowditch   Regular School No 1 KG 08 2015   grade_8 20 2 42 0   1     0   2   33 34                       67 20 2 42 0   1     0   2   33 34                 67
741372 MA Essex   school 2510380 258   Salem 251038000773 2580050 Saltonstall School   Regular School No 1 KG 08 2015   grade_8 16 1 4 0   0     0   2   12 11                       23 16 1 4 0   0     0   2   12 11                 23
741625 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Arthur D Healey   Regular School No 1 PK 08 2015   grade_8 16 10 19 0   1     0   0   23 23                       46 16 10 19 0   1     0   0   23 23                 46
741635 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 John F Kennedy   Regular School No 1 PK 08 2015   grade_8 31 9 13 0   7     0   0   34 26                       60 31 9 13 0   7     0   0   34 26                 60
741645 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No 1 PK 08 2015   grade_8 18 4 16 0   3     0   0   23 18                       41 18 4 16 0   3     0   0   23 18                 41
741654 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No 1 KG 08 2015   grade_8 7 6 40 0   1     0   0   23 31                       54 7 6 40 0   1     0   0   23 31                 54
741664 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No 1 PK 08 2015   grade_8 30 8 10 0   10     0   2   37 23                       60 30 8 10 0   10     0   2   37 23                 60
741674 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No 1 PK 08 2015   grade_8 9 11 32 0   13     0   0   33 32                       65 9 11 32 0   13     0   0   33 32                 65
741851 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No 1 PK 08 2015   grade_8 4 4 15 0   0     0   2   16 9                       25 4 4 15 0   0     0   2   16 9                 25
742287 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No 1 PK 08 2015   grade_8 23 0 5 0   0     0   2   23 7                       30 23 0 5 0   0     0   2   23 7                 30
743497 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2015   grade_8 0 26 9 0   0     0   0   15 20                       35 0 26 9 0   0     0   0   15 20                 35
743559 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes 1 PK 08 2015   grade_8 1 8 2 0   1     0   0   5 7                       12 1 8 2 0   1     0   0   5 7                 12
743569 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2015   grade_8 3 3 38 0   1     0   0   25 20                       45 3 3 38 0   1     0   0   25 20                 45
743591 MA Suffolk   school 2500528 443   Brooke Charter School Mattapan (District) 250052802711 4430205 Brooke Charter School Mattapan   Regular School Yes 1 KG 08 2015   grade_8 0 18 6 0   0     0   0   14 10                       24 0 18 6 0   0     0   0   14 10                 24
743601 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2015   grade_8 1 18 7 1   3     0   1   17 14                       31 1 18 7 1   3     0   1   17 14                 31
743636 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2015   grade_8 39 0 0 0   11     0   1   21 30                       51 39 0 0 0   11     0   1   21 30                 51
743653 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2015   grade_8 17 0 0 0   0     0   0   7 10                       17 17 0 0 0   0     0   0   7 10                 17
743666 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes 1 KG 08 2015   grade_8 6 3 59 0   1     0   0   29 40                       69 6 3 59 0   1     0   0   29 40                 69
743675 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 KG 08 2015   grade_8 0 0 58 0   0     0   0   21 37                       58 0 0 58 0   0     0   0   21 37                 58
743684 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public School   Regular School Yes 1 KG 08 2015   grade_8 27 2 3 0   0     0   1   14 19                       33 27 2 3 0   0     0   1   14 19                 33
743807 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes 1 KG 08 2015   grade_8 22 0 3 0   2     0   1   14 14                       28 22 0 3 0   2     0   1   14 14                 28
743835 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes 1 KG 08 2015   grade_8 4 17 24 0   2     0   3   17 33                       50 4 17 24 0   2     0   3   17 33                 50
744600 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2015   grade_8 94 1 3 0   3     0   4   37 68                       105 94 1 3 0   3     0   4   37 68                 105
744822 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_8 14 0 1 0   0     0   1   7 9                       16 14 0 1 0   0     0   1   7 9                 16
744911 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2015   grade_8 26 0 3 1   0     0   0   15 15                       30 26 0 3 1   0     0   0   15 15                 30
744947 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Paxton Center   Regular School No 1 KG 08 2015   grade_8 64 1 2 0   1     0   1   34 35                       69 64 1 2 0   1     0   1   34 35                 69
744956 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Thomas Prince   Regular School No 1 KG 08 2015   grade_8 45 1 1 0   1     1   1   25 25                       50 45 1 1 0   1     1   1   25 25                 50

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