Data source: Big Local News · About: Big Local

572 rows where grade = "grade_6", state = "MA" and year = 2019 sorted by asian_int

View and edit SQL

year

  • 2019 · 572

grade

  • grade_6 · 572
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
2040420 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Dante Alighieri Montessori School   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2041287 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2042269 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_6 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2042674 MA Berkshire   school 2505760 121   Hancock 250576000826 1210005 Hancock Elementary   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   3 2                       5.0                         3 2                 5
2043675 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2019   grade_6 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2045461 MA Franklin   school 2510230 253   Rowe 251023001649 2530005 Rowe Elementary   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2047496 MA Hampshire   school 2513260 349   Worthington 251326002850 3490010 R. H. Conwell   Regular School No Elementary PK 06 2019   grade_6 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2048406 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507001852 6650015 George R Austin Intermediate School   Regular School No Middle 04 06 2019   grade_6 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2040216 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2019   grade_6 84 0 4 0   0     0   2   44 46                       90.0 84 0 4 0   0     0   2   44 46                 90
2040347 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_6 17 13 19 0   0     0   2   29 22                       51.0 17 13 19 0   0     0   2   29 22                 51
2040595 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2019   grade_6 6 2 28 0   0     0   0   19 17                       36.0 6 2 28 0   0     0   0   19 17                 36
2040653 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_6 1 10 39 0   0     0   0   17 33                       50.0 1 10 39 0   0     0   0   17 33                 50
2040782 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_6 2 8 20 0   0     0   1   17 14                       31.0 2 8 20 0   0     0   1   17 14                 31
2040879 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_6 2 25 25 0   0     0   1   35 18                       53.0 2 25 25 0   0     0   1   35 18                 53
2040889 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Mildred Avenue K-8   Regular School No Elementary PK 08 2019   grade_6 3 55 37 0   0     0   1   56 40                       96.0 3 55 37 0   0     0   1   56 40                 96
2040899 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_6 0 17 26 0   0     0   0   25 18                       43.0 0 17 26 0   0     0   0   25 18                 43
2040909 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_6 4 3 12 0   0     0   2   12 9                       21.0 4 3 12 0   0     0   2   12 9                 21
2041092 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2019   grade_6 3 0 35 0   0     0   0   19 19                       38.0 3 0 35 0   0     0   0   19 19                 38
2041100 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_6 1 4 4 0   0     0   0   7 2                       9.0 1 4 4 0   0     0   0   7 2                 9
2041299 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2019   grade_6 29 135 32 0   0     0   9   111 94                       205.0 29 135 32 0   0     0   9   111 94                 205
2041332 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_6 39 0 2 0   0     0   4   20 25                       45.0 39 0 2 0   0     0   4   20 25                 45
2041464 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Amigos School   Regular School No Elementary PK 08 2019   grade_6 17 0 23 0   0     0   5   23 22                       45.0 17 0 23 0   0     0   5   23 22                 45
2041758 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2019   grade_6 21 0 0 0   0     0   2   12 11                       23.0 21 0 0 0   0     0   2   12 11                 23
2041821 MA Franklin   school 2503900 68   Conway 250390000528 680005 Conway Grammar   Regular School No Elementary PK 06 2019   grade_6 19 0 1 0   0     0   0   9 11                       20.0 19 0 1 0   0     0   0   9 11                 20
2041924 MA Franklin   school 2504080 74   Deerfield 250408000049 740015 Deerfield Elementary   Regular School No Elementary PK 06 2019   grade_6 52 0 2 0   0     0   2   33 23                       56.0 52 0 2 0   0     0   2   33 23                 56
2042001 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 Gordon W. Mitchell School   Regular School No Elementary 03 06 2019   grade_6 150 7 2 1   0     1   6   101 66                       167.0 150 7 2 1   0     1   6   101 66                 167
2042098 MA Franklin   school 2504710 91   Erving 250471000626 910030 Erving Elementary   Regular School No Elementary PK 06 2019   grade_6 17 0 0 0   0     0   3   8 12                       20.0 17 0 0 0   0     0   3   8 12                 20
2042136 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_6 2 5 3 0   0     0   1   10 1                       11.0 2 5 3 0   0     0   1   10 1                 11
2042231 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2019   grade_6 23 2 23 0   0     0   5   27 26                       53.0 23 2 23 0   0     0   5   27 26                 53
2042368 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2019   grade_6 12 1 0 0   0     0   0   7 6                       13.0 12 1 0 0   0     0   0   7 6                 13
2042669 MA Plymouth   school 2505610 118   Halifax 250561000815 1180005 Halifax Elementary   Regular School No Elementary KG 06 2019   grade_6 84 1 1 0   0     0   1   42 45                       87.0 84 1 1 0   0     0   1   42 45                 87
2042716 MA Hampshire   school 2505940 127   Hatfield 250594000843 1270005 Hatfield Elementary   Regular School No Elementary PK 06 2019   grade_6 38 0 1 0   0     0   1   22 18                       40.0 38 0 1 0   0     0   1   22 18                 40
2042770 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_6 4 0 3 0   0     0   1   7 *                       8.0 4 0 3 0   0     0   1   7                   8
2042855 MA Hampden   school 2506210 135   Holland 250621000889 1350005 Holland Elementary   Regular School No Elementary PK 06 2019   grade_6 30 0 2 0   0     0   0   16 16                       32.0 30 0 2 0   0     0   0   16 16                 32
2042895 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2019   grade_6 4 2 47 0   0     0   0   30 23                       53.0 4 2 47 0   0     0   0   30 23                 53
2042904 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2019   grade_6 5 0 44 0   0     0   0   24 25                       49.0 5 0 44 0   0     0   0   24 25                 49
2042930 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2019   grade_6 6 0 40 0   0     0   0   22 24                       46.0 6 0 40 0   0     0   0   22 24                 46
2042952 MA Worcester   school 2506300 138   Hopedale 250630000916 1380010 Memorial   Regular School No Elementary KG 06 2019   grade_6 69 3 7 0   0     0   2   44 37                       81.0 69 3 7 0   0     0   2   44 37                 81
2043006 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2019   grade_6 51 0 2 0   0     0   1   24 30                       54.0 51 0 2 0   0     0   1   24 30                 54
2043043 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston Intermediate   Regular School No Elementary 03 06 2019   grade_6 140 3 9 1   0     0   2   79 76                       155.0 140 3 9 1   0     0   2   79 76                 155
2043068 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2019   grade_6 3 1 162 0   0     0   1   87 80                       167.0 3 1 162 0   0     0   1   87 80                 167
2043085 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2019   grade_6 4 0 108 0   0     0   1   53 60                       113.0 4 0 108 0   0     0   1   53 60                 113
2043102 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2019   grade_6 1 0 106 0   0     0   0   57 50                       107.0 1 0 106 0   0     0   0   57 50                 107
2043127 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2019   grade_6 2 0 69 0   0     0   1   34 38                       72.0 2 0 69 0   0     0   1   34 38                 72
2043146 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_6 2 0 11 0   0     0   1   11 3                       14.0 2 0 11 0   0     0   1   11 3                 14
2043248 MA Franklin   school 2506810 154   Leverett 250681000992 1540005 Leverett Elementary   Regular School No Elementary PK 06 2019   grade_6 12 0 3 0   0     0   2   8 9                       17.0 12 0 3 0   0     0   2   8 9                 17
2043453 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_6 3 0 3 0   0     0   0   6 *                       6.0 3 0 3 0   0     0   0   6                   6
2043508 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   grade_6 4 0 2 0   0     0   0   3 3                       6.0 4 0 2 0   0     0   0   3 3                 6
2043517 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2019   grade_6 179 7 19 2   0     0   4   115 96                       211.0 179 7 19 2   0     0   4   115 96                 211
2043532 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2019   grade_6 107 2 14 0   0     0   3   64 62                       126.0 107 2 14 0   0     0   3   64 62                 126
2044122 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2019   grade_6 80 1 5 0   0     0   7   47 46                       93.0 80 1 5 0   0     0   7   47 46                 93
2044185 MA Essex   school 2508220 196   Nahant 250822002394 1960010 Johnson   Regular School No Elementary PK 06 2019   grade_6 23 0 0 0   0     0   0   9 14                       23.0 23 0 0 0   0     0   0   9 14                 23
2044407 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2019   grade_6 116 47 139 0   0     0   20   162 160                       322.0 116 47 139 0   0     0   20   162 160                 322
2044415 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_6 2 1 5 0   0     0   0   6 2                       8.0 2 1 5 0   0     0   0   6 2                 8
2044578 MA Berkshire   school 2508670 209   North Adams 250867001389 2090015 Greylock   Regular School No Elementary PK 06 2019   grade_6 25 1 4 0   0     1   3   20 14                       34.0 25 1 4 0   0     1   3   20 14                 34
2044586 MA Berkshire   school 2508670 209   North Adams 250867001390 2090035 Brayton   Regular School No Elementary PK 06 2019   grade_6 34 1 3 0   0     0   3   21 20                       41.0 34 1 3 0   0     0   3   21 20                 41
2044749 MA Worcester   school 2508760 215   North Brookfield 250876001410 2150015 North Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_6 43 0 1 0   0     0   2   26 20                       46.0 43 0 1 0   0     0   2   26 20                 46
2044865 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2019   grade_6 38 1 9 1   0     0   5   29 25                       54.0 38 1 9 1   0     0   5   29 25                 54
2044982 MA Hampshire   school 2509390 230   Pelham 250939001507 2300005 Pelham Elementary   Regular School No Elementary KG 06 2019   grade_6 18 1 2 0   0     0   0   6 15                       21.0 18 1 2 0   0     0   0   6 15                 21
2044996 MA Plymouth   school 2509420 231   Pembroke 250942001509 2310010 Hobomock Elementary   Regular School No Elementary KG 06 2019   grade_6 82 0 1 0   0     0   0   41 42                       83.0 82 0 1 0   0     0   0   41 42                 83
2045018 MA Worcester   school 2509540 234   Petersham 250954001514 2340005 Petersham Center   Regular School No Elementary KG 06 2019   grade_6 12 0 2 0   0     0   0   6 8                       14.0 12 0 2 0   0     0   0   6 8                 14
2045071 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2019   grade_6 127 30 20 1   0     0   16   89 105                       194.0 127 30 20 1   0     0   16   89 105                 194
2045163 MA Plymouth   school 2509780 240   Plympton 250978001551 2400010 Dennett Elementary   Regular School No Elementary KG 06 2019   grade_6 18 0 2 0   0     0   0   10 10                       20.0 18 0 2 0   0     0   0   10 10                 20
2045171 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2019   grade_6 2 6 1 0   0     0   0   3 6                       9.0 2 6 1 0   0     0   0   3 6                 9
2045404 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2019   grade_6 18 1 2 0   0     0   0   10 11                       21.0 18 1 2 0   0     0   0   10 11                 21
2045414 MA Plymouth   school 2510140 250   Rochester 251014001637 2500005 Rochester Memorial   Regular School No Elementary PK 06 2019   grade_6 65 2 2 0   0     0   6   44 31                       75.0 65 2 2 0   0     0   6   44 31                 75
2045692 MA Franklin   school 2510800 272   Shutesbury 251080001720 2720005 Shutesbury Elementary   Regular School No Elementary PK 06 2019   grade_6 10 1 1 0   0     0   1   8 5                       13.0 10 1 1 0   0     0   1   8 5                 13
2045800 MA Hampshire   school 2510950 275   Southampton 251095001758 2750005 William E Norris   Regular School No Elementary PK 06 2019   grade_6 62 0 10 0   0     0   2   39 35                       74.0 62 0 10 0   0     0   2   39 35                 74
2045959 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2019   grade_6 8 2 18 0   0     0   1   9 20                       29.0 8 2 18 0   0     0   1   9 20                 29
2046060 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2019   grade_6 20 21 63 0   0     0   0   44 60                       104.0 20 21 63 0   0     0   0   44 60                 104
2046086 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield Public Day Middle School   Regular School No Middle 06 08 2019   grade_6 0 2 10 0   0     0   1   11 2                       13.0 0 2 10 0   0     0   1   11 2                 13
2046089 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2019   grade_6 16 21 61 0   0     0   1   57 42                       99.0 16 21 61 0   0     0   1   57 42                 99
2046092 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No Middle 06 08 2019   grade_6 1 7 63 0   0     0   0   35 36                       71.0 1 7 63 0   0     0   0   35 36                 71
2046100 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Impact Prep at Chestnut   Regular School No Middle 06 08 2019   grade_6 6 18 119 0   0     0   1   79 65                       144.0 6 18 119 0   0     0   1   79 65                 144
2046106 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2019   grade_6 5 9 40 0   0     0   2   15 41                       56.0 5 9 40 0   0     0   2   15 41                 56
2046113 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2019   grade_6 6 18 72 0   0     0   3   60 39                       99.0 6 18 72 0   0     0   3   60 39                 99
2046231 MA Worcester   school 2511310 287   Sturbridge 251131001870 2870005 Burgess Elementary   Regular School No Elementary PK 06 2019   grade_6 108 3 5 1   0     1   4   73 49                       122.0 108 3 5 1   0     1   4   73 49                 122
2046320 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2019   grade_6 182 1 4 0   0     0   2   102 87                       189.0 182 1 4 0   0     0   2   102 87                 189
2046410 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_6 30 3 6 1   0     0   2   25 17                       42.0 30 3 6 1   0     0   2   25 17                 42
2046495 MA Hampden   school 2511940 306   Wales 251194001956 3060005 Wales Elementary   Regular School No Elementary PK 06 2019   grade_6 18 0 1 0   0     0   1   14 6                       20.0 18 0 1 0   0     0   1   14 6                 20
2046591 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware Middle School   Regular School No Middle 04 06 2019   grade_6 104 3 7 0   0     0   4   59 59                       118.0 104 3 7 0   0     0   4   59 59                 118
2046773 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No High 06 12 2019   grade_6 56 1 10 0   0     0   4   29 42                       71.0 56 1 10 0   0     0   4   29 42                 71
2046787 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 Howard School   Regular School No Middle 04 06 2019   grade_6 84 6 4 0   0     0   4   42 56                       98.0 84 6 4 0   0     0   4   42 56                 98
2046875 MA Hampshire   school 2512690 327   Westhampton 251269002083 3270005 Westhampton Elementary School   Regular School No Elementary PK 06 2019   grade_6 16 0 1 0   0     0   0   9 8                       17.0 16 0 1 0   0     0   0   9 8                 17
2047041 MA Franklin   school 2512870 337   Whately 251287002126 3370005 Whately Elementary   Regular School No Elementary PK 06 2019   grade_6 19 0 2 0   0     0   0   9 12                       21.0 19 0 2 0   0     0   0   9 12                 21
2047049 MA Hampshire   school 2512990 340   Williamsburg 251299002767 3400020 Anne T. Dunphy School   Regular School No Elementary PK 06 2019   grade_6 16 1 0 0   0     0   0   8 9                       17.0 16 1 0 0   0     0   0   8 9                 17
2047211 MA Worcester   school 2513230 348   Worcester 251323002250 3480026 Wawecus Road School   Regular School No Elementary KG 06 2019   grade_6 11 5 6 0   0     0   0   11 11                       22.0 11 5 6 0   0     0   0   11 11                 22
2047248 MA Worcester   school 2513230 348   Worcester 251323002506 3480052 Chandler Magnet   Regular School No Elementary PK 06 2019   grade_6 2 2 38 0   0     0   1   27 16                       43.0 2 2 38 0   0     0   1   27 16                 43
2047264 MA Worcester   school 2513230 348   Worcester 251323002206 3480055 Clark St Community   Regular School No Elementary PK 06 2019   grade_6 3 3 16 0   0     0   2   15 9                       24.0 3 3 16 0   0     0   2   15 9                 24
2047421 MA Worcester   school 2513230 348   Worcester 251323002247 3480235 Thorndyke Road   Regular School No Elementary KG 06 2019   grade_6 25 8 17 0   0     0   1   29 22                       51.0 25 8 17 0   0     0   1   29 22                 51
2047522 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_6 8 10 31 0   0     0   0   21 28                       49.0 8 10 31 0   0     0   0   21 28                 49
2047526 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_6 25 10 139 0   0     1   2   90 87                       177.0 25 10 139 0   0     1   2   90 87                 177
2047576 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_6 0 20 14 0   0     0   5   18 21                       39.0 0 20 14 0   0     0   5   18 21                 39
2047578 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2019   grade_6 138 0 1 0   0     0   0   72 67                       139.0 138 0 1 0   0     0   0   72 67                 139
2047581 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_6 0 47 22 0   0     0   0   33 36                       69.0 0 47 22 0   0     0   0   33 36                 69
2047603 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 07 2019   grade_6 0 0 39 0   0     0   0   21 18                       39.0 0 0 39 0   0     0   0   21 18                 39
2047678 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_6 0 17 2 0   0     0   0   7 12                       19.0 0 17 2 0   0     0   0   7 12                 19
2047702 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_6 3 1 38 0   0     0   0   23 19                       42.0 3 1 38 0   0     0   0   23 19                 42
2047779 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_6 29 0 2 0   0     0   1   15 16                       32.0 29 0 2 0   0     0   1   15 16                 32
2047802 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_6 1 1 79 0   0     0   0   31 50                       81.0 1 1 79 0   0     0   0   31 50                 81

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