Data source: Big Local News · About: Big Local

499 rows where grade = "grade_7", state = "MA" and year = 2019 sorted by asian

View and edit SQL

year

  • 2019 · 499

grade

  • grade_7 · 499
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
2040387 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   grade_7 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2041274 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_7 * * * *   *     *   *   1 *                       1.0                         1                   1
2041702 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_7 * * * *   *     *   *   2 2                       4.0                         2 2                 4
2042771 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_7 * * * *   *     *   *   5 *                       5.0                         5                   5
2043454 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_7 * * * *   *     *   *   3 *                       4.0                         3                   4
2043509 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   grade_7 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2048250 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 06 12 2019   grade_7 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2039833 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_7 117 2 1 0   0     0   1   64 57                       121.0 117 2 1 0   0     0   1   64 57                 121
2039879 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2019   grade_7 138 5 18 0   0     1   4   79 87                       166.0 138 5 18 0   0     1   4   79 87                 166
2040217 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2019   grade_7 86 1 3 0   0     0   2   44 48                       92.0 86 1 3 0   0     0   2   44 48                 92
2040348 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_7 1 8 8 0   0     0   1   8 10                       18.0 1 8 8 0   0     0   1   8 10                 18
2040429 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2019   grade_7 0 36 19 0   0     2   1   26 32                       58.0 0 36 19 0   0     2   1   26 32                 58
2040443 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2019   grade_7 2 13 10 0   0     0   3   13 15                       28.0 2 13 10 0   0     0   3   13 15                 28
2040453 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Donald Mckay   Regular School No Elementary PK 08 2019   grade_7 8 2 90 0   0     0   1   50 51                       101.0 8 2 90 0   0     0   1   50 51                 101
2040487 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Franklin D Roosevelt   Regular School No Elementary PK 08 2019   grade_7 4 23 15 0   0     0   1   18 25                       43.0 4 23 15 0   0     0   1   18 25                 43
2040596 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2019   grade_7 0 0 16 0   0     0   0   9 7                       16.0 0 0 16 0   0     0   0   9 7                 16
2040623 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Joyce Kilmer   Regular School No Elementary PK 08 2019   grade_7 6 2 6 0   0     0   0   7 7                       14.0 6 2 6 0   0     0   0   7 7                 14
2040695 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   grade_7 10 7 4 0   0     0   1   15 7                       22.0 10 7 4 0   0     0   1   15 7                 22
2040711 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2019   grade_7 10 24 39 0   0     0   5   39 39                       78.0 10 24 39 0   0     0   5   39 39                 78
2040721 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2019   grade_7 4 11 18 0   0     0   2   22 13                       35.0 4 11 18 0   0     0   2   22 13                 35
2040783 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_7 0 9 14 0   0     0   0   16 7                       23.0 0 9 14 0   0     0   0   16 7                 23
2040793 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Gardner Pilot Academy   Regular School No Elementary PK 08 2019   grade_7 2 6 26 0   0     0   2   19 17                       36.0 2 6 26 0   0     0   2   19 17                 36
2040824 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_7 2 6 12 0   0     0   0   14 6                       20.0 2 6 12 0   0     0   0   14 6                 20
2040846 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_7 0 12 11 0   0     0   4   13 14                       27.0 0 12 11 0   0     0   4   13 14                 27
2040873 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2019   grade_7 0 22 16 0   0     0   3   17 24                       41.0 0 22 16 0   0     0   3   17 24                 41
2040880 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_7 0 21 13 0   0     0   5   22 17                       39.0 0 21 13 0   0     0   5   22 17                 39
2040890 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2019   grade_7 3 62 23 2   0     0   3   47 46                       93.0 3 62 23 2   0     0   3   47 46                 93
2040900 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_7 0 24 18 0   0     0   1   24 19                       43.0 0 24 18 0   0     0   1   24 19                 43
2040910 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_7 0 6 10 0   0     0   2   11 7                       18.0 0 6 10 0   0     0   2   11 7                 18
2040941 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2019   grade_7 1 41 54 0   0     0   2   42 56                       98.0 1 41 54 0   0     0   2   42 56                 98
2040992 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   grade_7 1 23 20 0   0     0   0   18 26                       44.0 1 23 20 0   0     0   0   18 26                 44
2041093 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2019   grade_7 0 0 16 0   0     0   0   4 12                       16.0 0 0 16 0   0     0   0   4 12                 16
2041248 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2019   grade_7 17 74 14 0   0     1   7   61 52                       113.0 17 74 14 0   0     1   7   61 52                 113
2041288 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_7 4 2 0 0   0     0   1   5 2                       7.0 4 2 0 0   0     0   1   5 2                 7
2041599 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2019   grade_7 121 1 3 0   0     0   3   80 48                       128.0 121 1 3 0   0     0   3   80 48                 128
2041661 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2019   grade_7 9 10 116 0   0     0   0   73 62                       135.0 9 10 116 0   0     0   0   73 62                 135
2041759 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_7 15 0 0 0   0     0   2   8 9                       17.0 15 0 0 0   0     0   2   8 9                 17
2042002 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2019   grade_7 165 3 5 1   0     0   5   101 78                       179.0 165 3 5 1   0     0   5   101 78                 179
2042089 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2019   grade_7 30 2 5 0   0     0   1   18 20                       38.0 30 2 5 0   0     0   1   18 20                 38
2042137 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_7 1 1 4 0   0     0   0   4 2                       6.0 1 1 4 0   0     0   0   4 2                 6
2042270 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_7 3 1 0 0   0     0   5   8 1                       9.0 3 1 0 0   0     0   5   8 1                 9
2042278 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_7 9 1 5 0   0     0   2   7 10                       17.0 9 1 5 0   0     0   2   7 10                 17
2042369 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_7 9 0 0 0   0     0   0   2 7                       9.0 9 0 0 0   0     0   0   2 7                 9
2042541 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2019   grade_7 94 1 2 0   0     0   0   51 46                       97.0 94 1 2 0   0     0   0   51 46                 97
2042717 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2019   grade_7 29 1 1 0   0     0   0   15 16                       31.0 29 1 1 0   0     0   0   15 16                 31
2042885 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2019   grade_7 12 0 29 0   0     0   0   22 19                       41.0 12 0 29 0   0     0   0   22 19                 41
2042896 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2019   grade_7 2 3 40 0   0     0   0   32 13                       45.0 2 3 40 0   0     0   0   32 13                 45
2042905 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2019   grade_7 1 1 49 0   0     0   0   30 21                       51.0 1 1 49 0   0     0   0   30 21                 51
2042921 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2019   grade_7 8 4 48 0   0     0   0   28 32                       60.0 8 4 48 0   0     0   0   28 32                 60
2042931 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2019   grade_7 2 1 37 0   0     0   0   15 25                       40.0 2 1 37 0   0     0   0   15 25                 40
2042939 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke STEM Academy   Regular School No Middle 06 08 2019   grade_7 7 5 72 0   0     0   1   41 44                       85.0 7 5 72 0   0     0   1   41 44                 85
2043069 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2019   grade_7 2 1 140 0   0     0   0   71 70                       143.0 2 1 140 0   0     0   0   71 70                 143
2043090 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2019   grade_7 7 0 129 0   0     0   2   60 78                       138.0 7 0 129 0   0     0   2   60 78                 138
2043103 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2019   grade_7 7 0 106 0   0     0   0   61 52                       113.0 7 0 106 0   0     0   0   61 52                 113
2043147 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_7 2 0 9 0   0     0   0   9 2                       11.0 2 0 9 0   0     0   0   9 2                 11
2044408 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2019   grade_7 109 49 104 1   0     1   9   139 134                       273.0 109 49 104 1   0     1   9   139 134                 273
2044416 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_7 1 0 4 0   0     0   1   3 3                       6.0 1 0 4 0   0     0   1   3 3                 6
2044422 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2019   grade_7 3 2 4 0   0     0   0   8 1                       9.0 3 2 4 0   0     0   0   8 1                 9
2044750 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2019   grade_7 56 0 4 0   0     0   3   35 28                       63.0 56 0 4 0   0     0   3   35 28                 63
2044866 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2019   grade_7 32 3 8 2   0     0   2   18 29                       47.0 32 3 8 2   0     0   2   18 29                 47
2045172 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   grade_7 5 4 2 0   0     0   1   6 6                       12.0 5 4 2 0   0     0   1   6 6                 12
2045405 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2019   grade_7 21 0 2 0   0     0   1   13 11                       24.0 21 0 2 0   0     0   1   13 11                 24
2045448 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No Middle 06 08 2019   grade_7 69 3 2 0   0     0   0   44 30                       74.0 69 3 2 0   0     0   0   44 30                 74
2045713 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2019   grade_7 197 0 9 0   0     0   1   106 101                       207.0 197 0 9 0   0     0   1   106 101                 207
2045781 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 07 08 2019   grade_7 0 2 4 0   0     0   0   6 *                       6.0 0 2 4 0   0     0   0   6                   6
2045960 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   grade_7 6 12 16 0   0     0   1   15 20                       35.0 6 12 16 0   0     0   1   15 20                 35
2046081 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No Middle 06 08 2019   grade_7 18 33 108 0   0     0   3   95 67                       162.0 18 33 108 0   0     0   3   95 67                 162
2046087 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2019   grade_7 2 4 13 0   0     0   0   15 4                       19.0 2 4 13 0   0     0   0   15 4                 19
2046093 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No Middle 06 08 2019   grade_7 1 8 75 0   0     0   1   41 44                       85.0 1 8 75 0   0     0   1   41 44                 85
2046095 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2019   grade_7 3 3 3 0   0     0   0   7 2                       9.0 3 3 3 0   0     0   0   7 2                 9
2046098 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Academy   Regular School No Middle 06 08 2019   grade_7 3 11 85 0   0     0   2   52 49                       101.0 3 11 85 0   0     0   2   52 49                 101
2046101 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2019   grade_7 7 17 92 0   0     0   0   55 61                       116.0 7 17 92 0   0     0   0   55 61                 116
2046107 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2019   grade_7 8 9 38 1   0     0   0   22 34                       56.0 8 9 38 1   0     0   0   22 34                 56
2046114 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2019   grade_7 11 11 69 0   0     0   1   48 44                       92.0 11 11 69 0   0     0   1   48 44                 92
2046117 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle Academy   Regular School No Middle 06 08 2019   grade_7 2 6 65 0   0     0   0   47 26                       73.0 2 6 65 0   0     0   0   47 26                 73
2046411 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_7 16 2 8 2   0     0   8   17 19                       36.0 16 2 8 2   0     0   8   17 19                 36
2046592 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No High 07 12 2019   grade_7 94 2 5 0   0     0   6   53 54                       107.0 94 2 5 0   0     0   6   53 54                 107
2046903 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2019   grade_7 137 0 7 0   0     0   6   79 71                       150.0 137 0 7 0   0     0   6   79 71                 150
2047079 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2019   grade_7 78 1 6 0   0     0   2   42 45                       87.0 78 1 6 0   0     0   2   42 45                 87
2047523 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 08 2019   grade_7 17 7 24 0   0     0   0   24 24                       48.0 17 7 24 0   0     0   0   24 24                 48
2047534 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2019   grade_7 4 23 25 0   0     0   0   25 27                       52.0 4 23 25 0   0     0   0   25 27                 52
2047549 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2019   grade_7 32 4 1 0   0     0   0   18 19                       37.0 32 4 1 0   0     0   0   18 19                 37
2047563 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2019   grade_7 1 51 30 0   0     0   5   43 44                       87.0 1 51 30 0   0     0   5   43 44                 87
2047577 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_7 0 16 7 0   0     0   1   12 12                       24.0 0 16 7 0   0     0   1   12 12                 24
2047582 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 Middle 06 08 2019   grade_7 1 51 11 0   0     0   0   35 28                       63.0 1 51 11 0   0     0   0   35 28                 63
2047648 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 07 2019   grade_7 1 0 31 0   0     0   0   18 14                       32.0 1 0 31 0   0     0   0   18 14                 32
2047679 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_7 0 15 3 0   0     0   0   8 10                       18.0 0 15 3 0   0     0   0   8 10                 18
2047693 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2019   grade_7 0 15 11 0   0     0   0   8 18                       26.0 0 15 11 0   0     0   0   8 18                 26
2047703 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 2019   grade_7 2 0 32 0   0     0   0   10 24                       34.0 2 0 32 0   0     0   0   10 24                 34
2047780 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2019   grade_7 21 2 3 0   0     0   4   16 14                       30.0 21 2 3 0   0     0   4   16 14                 30
2047793 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter School   Regular School Yes Elementary KG 08 2019   grade_7 6 0 65 0   0     0   0   33 38                       71.0 6 0 65 0   0     0   0   33 38                 71
2047803 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2019   grade_7 1 2 47 0   0     0   0   22 28                       50.0 1 2 47 0   0     0   0   22 28                 50
2047812 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 2019   grade_7 22 3 8 0   0     0   2   13 22                       35.0 22 3 8 0   0     0   2   13 22                 35
2047835 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2019   grade_7 0 44 14 0   0     0   1   26 33                       59.0 0 44 14 0   0     0   1   26 33                 59
2047849 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2019   grade_7 17 1 1 1   0     0   0   8 12                       20.0 17 1 1 1   0     0   0   8 12                 20
2047865 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2019   grade_7 1 29 61 0   0     0   1   44 48                       92.0 1 29 61 0   0     0   1   44 48                 92
2047890 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2019   grade_7 67 1 0 0   0     0   2   37 33                       70.0 67 1 0 0   0     0   2   37 33                 70
2047896 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2019   grade_7 47 4 9 0   0     0   9   26 43                       69.0 47 4 9 0   0     0   9   26 43                 69
2047952 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2019   grade_7 6 35 32 0   0     0   1   43 31                       74.0 6 35 32 0   0     0   1   43 31                 74
2048022 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes High 05 12 2019   grade_7 35 12 40 1   0     0   2   45 45                       90.0 35 12 40 1   0     0   2   45 45                 90

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