enrollments

Data source: Big Local News · About: Big Local

489 rows where grade = "grade_8", state = "MA" and year = 2015 sorted by white_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2015 · 489 ✖

grade ✖

  • grade_8 · 489 ✖
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
735707 735707 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 05 08 2015   grade_8 * * * *   *     *   *   2 3                       5                         2 3                 5
736238 736238 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No 3 07 12 2015   grade_8 * * * *   *     *   *   3 2                       5                         3 2                 5
737141 737141 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_8 * * * *   *     *   *   3 1                       4                         3 1                 4
738605 738605 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_8 * * * *   *     *   *   4 1                       5                         4 1                 5
739535 739535 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 07 12 2015   grade_8 * * * *   *     *   *   1 1                       2                         1 1                 2
742480 742480 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No 3 07 12 2015   grade_8 * * * *   *     *   *   4                         4                         4                   4
736442 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
736507 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
736557 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
736726 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
736774 736774 MA Suffolk   school 2502790 35   Boston 250279001615 350413 Boston Middle School Academy   Regular School No 2 07 08 2015   grade_8 0 5 2 0   0     0   0   5 *                       7 0 5 2 0   0     0   0   5                   7
736949 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
737129 737129 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 B B Russell Alternative School   Regular School No 3 07 12 2015   grade_8 0 4 1 0   0     0   1   5 1                       6 0 4 1 0   0     0   1   5 1                 6
738741 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
743468 743468 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 2 06 08 2015   grade_8 0 56 12 0   1     0   2   24 47                       71 0 56 12 0   1     0   2   24 47                 71
743497 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
743591 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
743675 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
736232 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
736279 736279 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No 4 06 10 2015   grade_8 1 43 24 0   0     0   2   33 37                       70 1 43 24 0   0     0   2   33 37                 70
736452 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
736638 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
736736 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
736742 736742 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No 2 04 08 2015   grade_8 1 76 25 1   2     0   1   68 38                       106 1 76 25 1   2     0   1   68 38                 106
736752 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 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
736959 736959 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_8 1 2 3 0   1     0   0   2 5                       7 1 2 3 0   1     0   0   2 5                 7
738727 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
739016 739016 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_8 1 0 18 0   0     0   0   17 2                       19 1 0 18 0   0     0   0   17 2                 19
739339 739339 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No 3 08 12 2015   grade_8 1 1 5 0   0     0   0   7 *                       7 1 1 5 0   0     0   0   7                   7
741973 741973 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No 2 06 08 2015   grade_8 1 5 19 0   0     0   0   19 6                       25 1 5 19 0   0     0   0   19 6                 25
743559 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
743601 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
736882 736882 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   grade_8 2 14 12 0   43     0   1   42 30                       72 2 14 12 0   43     0   1   42 30                 72
737985 737985 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 01 12 2015   grade_8 2 1 3 0   0     0   1   6 1                       7 2 1 3 0   0     0   1   6 1                 7
738931 738931 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No 2 05 08 2015   grade_8 2 2 118 0   4     0   0   53 73                       126 2 2 118 0   4     0   0   53 73                 126
738949 738949 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No 2 06 08 2015   grade_8 2 0 97 1   0     0   1   54 47                       101 2 0 97 1   0     0   1   54 47                 101
743453 743453 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2015   grade_8 2 44 11 0   1     0   0   32 26                       58 2 44 11 0   1     0   0   32 26                 58
743769 743769 MA Suffolk   school 2500521 475   Dorchester Collegiate Academy Charter (District) 250052102685 4750505 Dorchester Collegiate Academy Charter   Regular School Yes 2 04 08 2015   grade_8 2 28 5 0   0     1   1   16 21                       37 2 28 5 0   0     1   1   16 21                 37
743819 743819 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 08 2015   grade_8 2 90 60 0   0     0   4   75 81                       156 2 90 60 0   0     0   4   75 81                 156
736339 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
736679 736679 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_8 3 14 12 0   0     0   0   17 12                       29 3 14 12 0   0     0   0   17 12                 29
736765 736765 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Lilla G. Frederick Middle School   Regular School No 2 06 08 2015   grade_8 3 104 105 0   3     1   5   126 95                       221 3 104 105 0   3     1   5   126 95                 221
736793 736793 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No 2 06 08 2015   grade_8 3 72 110 0   0     1   0   74 112                       186 3 72 110 0   0     1   0   74 112                 186
738914 738914 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2015   grade_8 3 2 125 0   0     0   0   63 67                       130 3 2 125 0   0     0   0   63 67                 130
738974 738974 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No 2 06 08 2015   grade_8 3 1 110 0   0     0   0   70 44                       114 3 1 110 0   0     0   0   70 44                 114
740280 740280 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No 3 07 12 2015   grade_8 3 0 3 0   0     0   0   5 1                       6 3 0 3 0   0     0   0   5 1                 6
741979 741979 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No 2 06 08 2015   grade_8 3 14 86 0   1     0   1   60 45                       105 3 14 86 0   1     0   1   60 45                 105
742484 742484 MA Plymouth   school 2512060 310   Wareham 251206002105 3100315 Wareham Cooperative Junior/Senior High School   Regular School No 3 07 12 2015   grade_8 3 2 1 1   0     0   0   5 2                       7 3 2 1 1   0     0   0   5 2                 7
743531 743531 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes 4 06 12 2015   grade_8 3 36 20 1   9     0   3   36 36                       72 3 36 20 1   9     0   3   36 36                 72
743569 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
743741 743741 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2015   grade_8 3 41 37 1   1     0   4   40 47                       87 3 41 37 1   1     0   4   40 47                 87
736299 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
736790 736790 MA Suffolk   school 2502790 35   Boston 250279000345 350470 Wm B Rogers Middle   Regular School No 2 06 08 2015   grade_8 4 107 47 1   11     0   5   95 80                       175 4 107 47 1   11     0   5   95 80                 175
736924 736924 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_8 4 97 27 1   9     0   2   74 66                       140 4 97 27 1   9     0   2   74 66                 140
737549 737549 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_8 4 0 8 0   0     0   0   9 3                       12 4 0 8 0   0     0   0   9 3                 12
738909 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
739528 739528 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No 3 07 12 2015   grade_8 4 1 5 1   1     0   2   9 5                       14 4 1 5 1   1     0   2   9 5                 14
740760 740760 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Project C.O.F.F.E.E.   Special Education School No 4 05 12 2015   grade_8 4 2 2 0   0     0   0   7 1                       8 4 2 2 0   0     0   0   7 1                 8
741851 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
743835 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
736030 736030 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_8 5 0 1 0   0     0   0   4 2                       6 5 0 1 0   0     0   0   4 2                 6
736216 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
738585 738585 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No 4 06 12 2015   grade_8 5 2 2 0   0     0   0   8 1                       9 5 2 2 0   0     0   0   8 1                 9
741044 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
741677 741677 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative Education School No 2 06 08 2015   grade_8 5 2 3 0   2     0   0   8 *                       12 5 2 3 0   2     0   0   8                   12
741982 741982 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No 2 06 08 2015   grade_8 5 4 24 0   1     0   0   23 11                       34 5 4 24 0   1     0   0   23 11                 34
745148 745148 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes 2 06 08 2015   grade_8 5 21 42 0   0     0   2   29 41                       70 5 21 42 0   0     0   2   29 41                 70
736182 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
736322 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
736648 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
736787 736787 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No 2 06 08 2015   grade_8 6 62 60 0   3     0   5   71 65                       136 6 62 60 0   3     0   5   71 65                 136
738122 738122 MA Bristol   school 2504830 95   Fall River 250483002838 950335 Resiliency Middle School   Regular School No 2 07 08 2015   grade_8 6 2 9 0   0     0   1   8 10                       18 6 2 9 0   0     0   1   8 10                 18
738910 738910 MA Essex   school 2506660 149   Lawrence 250666001920 1490016 South Lawrence East Middle School   Regular School No 4 08 08 2015   grade_8 6 6 140 0   6     0   1   84 75                       159 6 6 140 0   6     0   1   84 75                 159
741985 741985 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No 2 06 08 2015   grade_8 6 10 89 0   1     0   0   54 52                       106 6 10 89 0   1     0   0   54 52                 106
743666 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
736563 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 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
736778 736778 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 05 11 2015   grade_8 7 37 16 2   5     1   1   42 27                       69 7 37 16 2   5     1   1   42 27                 69
738968 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
740287 740287 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_8 7 4 6 0   0     0   0   10 7                       17 7 4 6 0   0     0   0   10 7                 17
741654 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
741988 741988 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No 2 06 08 2015   grade_8 7 13 65 0   0     0   2   46 41                       87 7 13 65 0   0     0   2   46 41                 87
743352 743352 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 University Pk Campus School   Regular School No 3 07 12 2015   grade_8 7 2 20 1   11     0   3   25 19                       44 7 2 20 1   11     0   3   25 19                 44
743501 743501 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_8 7 27 57 0   2     0   2   42 53                       95 7 27 57 0   2     0   2   42 53                 95
736206 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
737318 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
738732 738732 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2015   grade_8 8 4 85 0   2     0   1   52 48                       100 8 4 85 0   2     0   1   52 48                 100
738750 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
741277 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
743358 743358 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No 3 07 12 2015   grade_8 8 15 67 0   6     0   2   35 63                       98 8 15 67 0   6     0   2   35 63                 98
736469 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
737515 737515 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2015   grade_8 9 4 126 0   1     0   1   75 66                       141 9 4 126 0   1     0   1   75 66                 141
737519 737519 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2015   grade_8 9 15 130 0   3     0   0   88 69                       157 9 15 130 0   3     0   0   88 69                 157
738120 738120 MA Bristol   school 2504830 95   Fall River 250483002696 950326 Stone Therapeutic Day Middle School   Regular School No 2 06 08 2015   grade_8 9 0 2 0   0     1   1   10 *                       13 9 0 2 0   0     1   1   10                   13
738935 738935 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No 2 05 08 2015   grade_8 9 2 136 0   1     0   3   76 75                       151 9 2 136 0   1     0   3   76 75                 151
738978 738978 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No 2 05 08 2015   grade_8 9 2 101 0   5     0   1   54 64                       118 9 2 101 0   5     0   1   54 64                 118
741674 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
743844 743844 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2015   grade_8 9 56 19 0   8     0   5   47 50                       97 9 56 19 0   8     0   5   47 50                 97
738212 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

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