Data source: Big Local News · About: Big Local

2,748 rows where grade = "grade_12" and state = "MA" sorted by white_int

View and edit SQL

year

grade

  • grade_12 · 2,648
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
933110 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No 4 06 12 2016   grade_12 1 4 0 0   1     0   0   5 1                       6 1 4 0 0   1     0   0   5 1                 6
933550 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2016   grade_12 1 27 16 0   1     0   0   35 10                       45 1 27 16 0   1     0   0   35 10                 45
933771 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No 3 09 12 2016   grade_12 1 10 2 1   1     0   0   9 6                       15 1 10 2 1   1     0   0   9 6                 15
935835 MA Essex   school 2506660 149   Lawrence 250666002636 1490531 Health & Human Services High School   Regular School No 3 09 12 2016   grade_12 1 0 124 0   2     0   1   58 70                       128 1 0 124 0   2     0   1   58 70                 128
935874 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative Education School No 3 09 12 2016   grade_12 1 0 15 0   0     0   0   4 12                       16 1 0 15 0   0     0   0   4 12                 16
940274 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2016   grade_12 1 28 11 0   0     1   4   10 35                       45 1 28 11 0   0     1   4   10 35                 45
940356 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes 4 06 12 2016   grade_12 1 35 16 1   1     0   1   19 36                       55 1 35 16 1   1     0   1   19 36                 55
940716 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy   Regular School Yes 3 09 12 2016   grade_12 1 8 21 0   1     0   0   16 15                       31 1 8 21 0   1     0   0   16 15                 31
941998 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes 3 09 12 2016   grade_12 1 3 5 0   0     0   0   1 8                       9 1 3 5 0   0     0   0   1 8                 9
1123278 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No High 09 12 2017   grade_12 1 43 18 0   5     0   1   30 38                       68 1 43 18 0   5     0   1   30 38                 68
1123395 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No High 09 12 2017   grade_12 1 18 10 0   0     0   0   11 18                       29 1 18 10 0   0     0   0   11 18                 29
1123453 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_12 1 2 2 0   2     0   0   5 2                       7 1 2 2 0   2     0   0   5 2                 7
1125889 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_12 1 1 14 0   0     0   0   13 3                       16 1 1 14 0   0     0   0   13 3                 16
1127398 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No Other 06 12 2017   grade_12 1 4 5 0   0     0   1   5 6                       11 1 4 5 0   0     0   1   5 6                 11
1129418 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield Public Day High School   Regular School No High 09 12 2017   grade_12 1 2 7 0   0     0   0   6 4                       10 1 2 7 0   0     0   0   6 4                 10
1131262 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes High 09 12 2017   grade_12 1 30 17 1   0     1   0   21 29                       50 1 30 17 1   0     1   0   21 29                 50
1131636 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy   Regular School Yes High 09 12 2017   grade_12 1 12 12 0   0     0   0   14 11                       25 1 12 12 0   0     0   0   14 11                 25
1133134 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2017   grade_12 1 27 12 0   0     0   0   15 25                       40 1 27 12 0   0     0   0   15 25                 40
1365916 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2020   grade_12 1 11 3 0   0     0   0   5 10 *                     15.0 1 11 3 0   0     0   0   5 10                 15
1365924 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2020   grade_12 1 87 26 0   0     1   2   63 54 *                     117.0 1 87 26 0   0     1   2   63 54                 117
1365938 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2020   grade_12 1 46 81 1   1     0   4   59 75 *                     134.0 1 46 81 1   1     0   4   59 75                 134
1365943 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2020   grade_12 1 28 55 0   1     0   1   33 53 *                     86.0 1 28 55 0   1     0   1   33 53                 86
1365957 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No High 09 12 2020   grade_12 1 7 11 0   0     0   1   8 12 *                     20.0 1 7 11 0   0     0   1   8 12                 20
1366000 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No High 12 12 2020   grade_12 1 20 18 0   0     0   0   22 17 *                     39.0 1 20 18 0   0     0   0   22 17                 39
1366031 MA Suffolk   school 2502790 35   Boston 250279000217 350690 Snowden International School at Copley   Regular School No High 09 12 2020   grade_12 1 31 52 0   8     0   1   45 48 *                     93.0 1 31 52 0   8     0   1   45 48                 93
1368057 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No High 09 12 2020   grade_12 1 1 77 1   1     0   0   47 34 *                     81.0 1 1 77 1   1     0   0   47 34                 81
1371060 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield Public Day High School   Regular School No High 09 12 2020   grade_12 1 2 7 0   0     0   0   8 2 *                     10.0 1 2 7 0   0     0   0   8 2                 10
1372495 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2020   grade_12 1 32 17 0   0     0   1   26 25 *                     51.0 1 32 17 0   0     0   1   26 25                 51
1372546 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_12 1 30 23 0   1     0   1   20 36 *                     56.0 1 30 23 0   1     0   1   20 36                 56
1372934 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy   Regular School Yes High 09 12 2020   grade_12 1 3 5 0   0     0   0   2 7 *                     9.0 1 3 5 0   0     0   0   2 7                 9
1374188 MA Hampshire   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2020   grade_12 1 2 52 0   0     0   1   20 36 *                     56.0 1 2 52 0   0     0   1   20 36                 56
1672615 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston - Dearborn   Regular School No High 06 12 2021   grade_12 1 40 13 0   0     0   2   29 27 *                     56.0 1 40 13 0   0     0   2   29 27                 56
1673143 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston - Boston International High School   Regular School No High 09 12 2021   grade_12 1 31 54 0   10     0   0   50 46 *                     96.0 1 31 54 0   10     0   0   50 46                 96
1673162 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Boston - Jeremiah E Burke High   Regular School No High 09 12 2021   grade_12 1 75 34 0   0     2   4   66 50 *                     116.0 1 75 34 0   0     2   4   66 50                 116
1673195 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Boston - Greater Egleston Community High School   Regular School No High 09 12 2021   grade_12 1 19 28 0   1     0   2   27 24 *                     51.0 1 19 28 0   1     0   2   27 24                 51
1673229 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston - Quincy Upper School   Regular School No High 06 12 2021   grade_12 1 16 15 0   32     0   1   39 26 *                     65.0 1 16 15 0   32     0   1   39 26                 65
1673240 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Boston - Community Academy of Science and Health   Regular School No High 09 12 2021   grade_12 1 62 21 0   1     0   1   44 42 *                     86.0 1 62 21 0   1     0   1   44 42                 86
1673840 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea - Chelsea Opportunity Academy   Alternative School No High 09 12 2021   grade_12 1 1 48 0   0     0   0   32 18 *                     50.0 1 1 48 0   0     0   0   32 18                 50
1678322 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield - Springfield Public Day High School   Regular School No High 09 12 2021   grade_12 1 2 12 0   0     0   0   12 3 *                     15.0 1 2 12 0   0     0   0   12 3                 15
1679758 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public (District) - Boston Preparatory Charter Public School   Regular School Yes High 06 12 2021   grade_12 1 50 21 0   0     0   0   31 41 *                     72.0 1 50 21 0   0     0   0   31 41                 72
1679857 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge (District) - Community Charter School of Cambridge   Regular School Yes High 06 12 2021   grade_12 1 21 8 0   1     0   0   12 19 *                     31.0 1 21 8 0   1     0   0   12 19                 31
1679875 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District) - Codman Academy Charter Public School   Regular School Yes Other PK 12 2021   grade_12 1 16 5 1   0     0   0   8 15 *                     23.0 1 16 5 1   0     0   0   8 15                 23
1680130 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District) - Roxbury Preparatory Charter School   Regular School Yes High 05 12 2021   grade_12 1 53 45 0   0     0   1   55 45 *                     100.0 1 53 45 0   0     0   1   55 45                 100
1680198 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy (District) - Phoenix Charter Academy   Regular School Yes High 09 12 2021   grade_12 1 1 12 0   0     0   0   6 8 *                     14.0 1 1 12 0   0     0   0   6 8                 14
1681443 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District) - Baystate Academy Charter Public School   Regular School Yes High 06 12 2021   grade_12 1 14 36 0   1     0   0   26 26 *                     52.0 1 14 36 0   1     0   0   26 26                 52
2040391 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   grade_12 1 2 2 0   2     0   0   4 3                       7.0 1 2 2 0   2     0   0   4 3                 7
2040960 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2019   grade_12 1 4 2 0   0     0   0   5 2                       7.0 1 4 2 0   0     0   0   5 2                 7
2040968 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Jeremiah E Burke High   Regular School No High 09 12 2019   grade_12 1 99 18 0   1     0   1   64 56                       120.0 1 99 18 0   1     0   1   64 56                 120
2040997 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   grade_12 1 53 30 0   1     0   0   37 48                       85.0 1 53 30 0   1     0   0   37 48                 85
2041014 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative School No High 11 12 2019   grade_12 1 20 15 0   3     0   0   21 18                       39.0 1 20 15 0   3     0   0   21 18                 39
2041018 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Margarita Muniz Academy   Regular School No High 09 12 2019   grade_12 1 1 60 0   0     0   0   23 39                       62.0 1 1 60 0   0     0   0   23 39                 62
2041052 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No High 09 12 2019   grade_12 1 58 20 0   0     0   1   33 47                       80.0 1 58 20 0   0     0   1   33 47                 80
2041074 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No High 06 12 2019   grade_12 1 101 22 0   8     0   2   73 61                       134.0 1 101 22 0   8     0   2   73 61                 134
2043151 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_12 1 0 10 0   0     0   0   9 2                       11.0 1 0 10 0   0     0   0   9 2                 11
2046136 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield Public Day High School   Regular School No High 09 12 2019   grade_12 1 5 6 0   0     0   0   11 1                       12.0 1 5 6 0   0     0   0   11 1                 12
2046151 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative School No High 09 12 2019   grade_12 1 2 4 0   0     0   0   2 5                       7.0 1 2 4 0   0     0   0   2 5                 7
2047670 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes High 09 12 2019   grade_12 1 34 4 0   0     0   0   16 23                       39.0 1 34 4 0   0     0   0   16 23                 39
2049271 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2019   grade_12 1 11 38 0   0     0   0   22 28                       50.0 1 11 38 0   0     0   0   22 28                 50
2049284 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2019   grade_12 1 43 12 0   3     0   0   25 34                       59.0 1 43 12 0   3     0   0   25 34                 59
2230138 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Boston: Greater Egleston Community High School   Regular School No High 10 12 2018   grade_12 1 22 39 0   0     0   2   28 36                       64.0 1 22 39 0   0     0   2   28 36                 64
2230153 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston: Boston Adult Academy   Alternative School No High 11 12 2018   grade_12 1 19 12 0   0     0   1   17 16                       33.0 1 19 12 0   0     0   1   17 16                 33
2230158 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Boston: Margarita Muniz Academy   Regular School No High 09 12 2018   grade_12 1 1 65 0   0     0   1   27 41                       68.0 1 1 65 0   0     0   1   27 41                 68
2230272 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_12 1 0 5 0   1     0   1   4 4                       8.0 1 0 5 0   1     0   1   4 4                 8
2232705 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_12 1 0 11 0   0     0   0   10 2                       12.0 1 0 11 0   0     0   0   10 2                 12
2232710 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Lawrence: Phoenix Academy Lawrence   Alternative School No High 09 12 2018   grade_12 1 1 17 0   0     0   0   10 9                       19.0 1 1 17 0   0     0   0   10 9                 19
2233096 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Lowell: Leblanc Therapeutic Day School   Regular School No High 09 12 2018   grade_12 1 1 3 0   0     0   1   5 1                       6.0 1 1 3 0   0     0   1   5 1                 6
2235366 MA Suffolk   school 2510050 248   Revere 251005001659 2480520 Revere: Seacoast School   Regular School No High 09 12 2018   grade_12 1 2 8 0   0     0   1   11 1                       12.0 1 2 8 0   0     0   1   11 1                 12
2236249 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Springfield: Gateway to College at Holyoke Community College   Regular School No High 10 12 2018   grade_12 1 3 5 0   0     0   0   3 6                       9.0 1 3 5 0   0     0   0   3 6                 9
2239979 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield (District): Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2018   grade_12 1 10 14 0   1     0   5   14 17                       31.0 1 10 14 0   1     0   5   14 17                 31
736886 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   grade_12 2 16 10 0   28     0   2   33 25                       58 2 16 10 0   28     0   2   33 25                 58
736902 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No 3 09 12 2015   grade_12 2 51 10 0   2     0   2   34 33                       67 2 51 10 0   2     0   2   34 33                 67
736907 MA Suffolk   school 2502790 35   Boston 250279002676 350651 Dorchester Academy   Regular School No 3 09 12 2015   grade_12 2 64 22 1   6     1   3   45 54                       99 2 64 22 1   6     1   3   45 54                 99
736928 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_12 2 101 16 1   5     1   2   61 67                       128 2 101 16 1   5     1   2   61 67                 128
740290 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_12 2 4 9 0   0     1   2   12 6                       18 2 4 9 0   0     1   2   12 6                 18
742012 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield Public Day High School   Regular School No 3 09 12 2015   grade_12 2 5 18 0   0     0   0   17 8                       25 2 5 18 0   0     0   0   17 8                 25
742024 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No 3 10 12 2015   grade_12 2 3 7 0   0     0   0   5 7                       12 2 3 7 0   0     0   0   5 7                 12
743549 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2015   grade_12 2 18 8 0   1     0   0   10 19                       29 2 18 8 0   1     0   0   10 19                 29
743657 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes 3 09 12 2015   grade_12 2 46 30 4   3     0   2   27 60                       87 2 46 30 4   3     0   2   27 60                 87
743745 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2015   grade_12 2 34 20 0   0     0   1   27 30                       57 2 34 20 0   0     0   1   27 30                 57
743885 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy   Regular School Yes 3 09 12 2015   grade_12 2 6 18 0   0     0   0   13 13                       26 2 6 18 0   0     0   0   13 13                 26
933669 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No 3 09 12 2016   grade_12 2 39 24 0   4     0   1   39 31                       70 2 39 24 0   4     0   1   39 31                 70
933733 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Margarita Muniz Academy   Regular School No 3 09 12 2016   grade_12 2 6 59 0   1     0   0   32 36                       68 2 6 59 0   1     0   0   32 36                 68
933766 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No 3 09 12 2016   grade_12 2 83 15 1   2     0   1   51 53                       104 2 83 15 1   2     0   1   51 53                 104
934413 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2016   grade_12 2 1 5 0   0     0   0   5 3                       8 2 1 5 0   0     0   0   5 3                 8
935857 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No 3 09 12 2016   grade_12 2 0 62 0   0     0   0   38 26                       64 2 0 62 0   0     0   0   38 26                 64
935869 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_12 2 1 17 0   0     0   0   14 6                       20 2 1 17 0   0     0   0   14 6                 20
938824 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield Public Day High School   Regular School No 3 09 12 2016   grade_12 2 6 5 0   0     0   0   10 3                       13 2 6 5 0   0     0   0   10 3                 13
938836 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No 3 09 12 2016   grade_12 2 3 5 0   0     0   0   3 7                       10 2 3 5 0   0     0   0   3 7                 10
940574 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2016   grade_12 2 41 20 0   0     0   0   26 37                       63 2 41 20 0   0     0   0   26 37                 63
1122642 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2017   grade_12 2 6 1 0   0     0   0   8 1                       9 2 6 1 0   0     0   0   8 1                 9
1123348 MA Suffolk   school 2502790 35   Boston 250279001511 350548 Boston Adult Academy   Alternative School No High 11 12 2017   grade_12 2 57 25 0   2     0   2   38 50                       88 2 57 25 0   2     0   2   38 50                 88
1124152 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_12 2 1 8 0   0     0   1   9 3                       12 2 1 8 0   0     0   1   9 3                 12
1125876 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No High 09 12 2017   grade_12 2 1 84 0   0     0   0   55 32                       87 2 1 84 0   0     0   0   55 32                 87
1125996 MA Worcester   school 2506780 153   Leominster 250678002779 1530515 Leominster Center for Excellence   Regular School No High 09 12 2017   grade_12 2 1 3 0   0     0   1   3 4                       7 2 1 3 0   0     0   1   3 4                 7
1129422 MA Hampden   school 2511130 281   Springfield 251113002734 2810560 Liberty Preparatory Academy   Regular School No High 09 12 2017   grade_12 2 0 4 0   0     0   0   4 *                       6 2 0 4 0   0     0   0   4                   6
1129427 MA Hampden   school 2511130 281   Springfield 251113002724 2810570 Springfield High School   Regular School No High 09 12 2017   grade_12 2 1 5 0   0     0   0   6 2                       8 2 1 5 0   0     0   0   6 2                 8
1131386 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes High 09 12 2017   grade_12 2 46 37 0   1     0   1   23 64                       87 2 46 37 0   1     0   1   23 64                 87
1365902 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2020   grade_12 2 54 77 0   9     0   2   82 62 *                     144.0 2 54 77 0   9     0   2   82 62                 144
1365953 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2020   grade_12 2 39 33 0   1     0   2   35 42 *                     77.0 2 39 33 0   1     0   2   35 42                 77
1365974 MA Suffolk   school 2502790 35   Boston 250279002753 350549 Margarita Muniz Academy   Regular School No High 09 12 2020   grade_12 2 0 64 0   0     0   0   26 40 *                     66.0 2 0 64 0   0     0   0   26 40                 66

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