Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by ccd_charter_school descending

View and edit SQL

year

  • 2019 · 9,565
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
2047509 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2019   pre_kindergarten 1 24 13 0   0     0   1   21 18                       39.0 1 24 13 0   0     0   1   21 18                 39
2047510 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2019   kindergarten 0 22 11 0   0     0   0   18 15                       33.0 0 22 11 0   0     0   0   18 15                 33
2047511 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2019   grade_1 3 23 12 0   0     0   0   18 20                       38.0 3 23 12 0   0     0   0   18 20                 38
2047512 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2019   grade_2 0 28 13 1   0     0   0   21 21                       42.0 0 28 13 1   0     0   0   21 21                 42
2047513 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2019   grade_3 0 20 19 0   0     0   0   16 23                       39.0 0 20 19 0   0     0   0   16 23                 39
2047514 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2019   grade_4 1 25 11 0   0     0   0   17 20                       37.0 1 25 11 0   0     0   0   17 20                 37
2047515 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2019   grade_5 0 18 10 0   0     0   0   11 17                       28.0 0 18 10 0   0     0   0   11 17                 28
2047516 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   kindergarten 15 6 32 0   0     0   0   23 30                       53.0 15 6 32 0   0     0   0   23 30                 53
2047517 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_1 9 9 33 1   0     0   0   25 27                       52.0 9 9 33 1   0     0   0   25 27                 52
2047518 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_2 8 8 32 1   0     0   0   21 28                       49.0 8 8 32 1   0     0   0   21 28                 49
2047519 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_3 15 7 27 1   0     0   0   22 28                       50.0 15 7 27 1   0     0   0   22 28                 50
2047520 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_4 9 7 34 0   0     0   0   25 25                       50.0 9 7 34 0   0     0   0   25 25                 50
2047521 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_5 16 7 27 0   0     0   0   17 33                       50.0 16 7 27 0   0     0   0   17 33                 50
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
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
2047524 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_8 10 9 20 0   0     0   1   18 22                       40.0 10 9 20 0   0     0   1   18 22                 40
2047525 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_5 28 12 129 1   2     0   1   82 91                       173.0 28 12 129 1   2     0   1   82 91                 173
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
2047527 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_7 20 6 142 1   3     1   2   93 82                       175.0 20 6 142 1   3     1   2   93 82                 175
2047528 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_8 29 14 123 4   3     2   0   81 94                       175.0 29 14 123 4   3     2   0   81 94                 175
2047529 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_9 11 8 147 2   1     0   1   78 92                       170.0 11 8 147 2   1     0   1   78 92                 170
2047530 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_10 13 8 148 1   0     0   1   90 81                       171.0 13 8 148 1   0     0   1   90 81                 171
2047531 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_11 14 10 129 0   3     0   0   77 79                       156.0 14 10 129 0   3     0   0   77 79                 156
2047532 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2019   grade_12 8 15 71 2   4     0   0   45 55                       100.0 8 15 71 2   4     0   0   45 55                 100
2047533 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_6 5 24 19 0   2     0   2   26 26                       52.0 5 24 19 0   2     0   2   26 26                 52
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
2047535 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_8 4 27 29 0   0     0   1   34 27                       61.0 4 27 29 0   0     0   1   34 27                 61
2047536 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_9 6 33 41 1   2     2   1   47 39                       86.0 6 33 41 1   2     2   1   47 39                 86
2047537 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_10 9 43 28 0   3     0   3   47 39                       86.0 9 43 28 0   3     0   3   47 39                 86
2047538 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_11 12 31 26 0   3     0   5   33 44                       77.0 12 31 26 0   3     0   5   33 44                 77
2047539 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_12 3 27 19 0   3     0   0   24 28                       52.0 3 27 19 0   3     0   0   24 28                 52
2047540 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   sped_beyond_grade_12 0 6 4 0   0     0   0                             10.0 0 6 4 0   0     0   0                       10
2047541 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_5 8 49 14 0   0     0   1   46 26                       72.0 8 49 14 0   0     0   1   46 26                 72
2047542 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_6 10 43 24 0   1     0   2   39 41                       80.0 10 43 24 0   1     0   2   39 41                 80
2047543 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_7 5 43 25 0   1     0   1   34 41                       75.0 5 43 25 0   1     0   1   34 41                 75
2047544 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_8 3 43 23 0   0     0   4   34 39                       73.0 3 43 23 0   0     0   4   34 39                 73
2047545 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_9 10 43 17 0   1     0   0   37 34                       71.0 10 43 17 0   1     0   0   37 34                 71
2047546 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_10 3 47 19 0   1     0   0   36 34                       70.0 3 47 19 0   1     0   0   36 34                 70
2047547 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_11 6 29 10 0   1     0   1   22 25                       47.0 6 29 10 0   1     0   1   22 25                 47
2047548 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_12 2 21 10 0   1     1   3   19 19                       38.0 2 21 10 0   1     1   3   19 19                 38
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
2047550 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_8 34 0 3 0   0     0   1   20 18                       38.0 34 0 3 0   0     0   1   20 18                 38
2047551 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_9 33 1 2 1   0     0   1   20 18                       38.0 33 1 2 1   0     0   1   20 18                 38
2047552 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_10 27 0 6 0   2     0   3   18 20                       38.0 27 0 6 0   2     0   3   18 20                 38
2047553 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_11 30 0 2 0   2     0   3   16 21                       37.0 30 0 2 0   2     0   3   16 21                 37
2047554 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_12 27 0 2 0   0     0   2   14 17                       31.0 27 0 2 0   0     0   2   14 17                 31
2047555 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2019   grade_6 39 6 6 1   2     0   5   33 26                       59.0 39 6 6 1   2     0   5   33 26                 59
2047556 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2019   grade_7 51 6 11 0   2     0   5   41 34                       75.0 51 6 11 0   2     0   5   41 34                 75
2047557 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2019   grade_8 53 9 7 0   4     0   5   39 39                       78.0 53 9 7 0   4     0   5   39 39                 78
2047558 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2019   grade_9 43 8 4 0   0     0   4   29 30                       59.0 43 8 4 0   0     0   4   29 30                 59
2047559 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2019   grade_10 33 8 3 0   0     0   1   22 23                       45.0 33 8 3 0   0     0   1   22 23                 45
2047560 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2019   grade_11 23 2 3 0   2     0   1   19 12                       31.0 23 2 3 0   2     0   1   19 12                 31
2047561 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2019   grade_12 22 6 1 0   1     0   1   16 15                       31.0 22 6 1 0   1     0   1   16 15                 31
2047562 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_6 0 60 22 0   2     0   4   42 46                       88.0 0 60 22 0   2     0   4   42 46                 88
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
2047564 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_8 0 42 14 0   2     1   3   27 35                       62.0 0 42 14 0   2     1   3   27 35                 62
2047565 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_9 0 58 29 1   1     0   1   46 44                       90.0 0 58 29 1   1     0   1   46 44                 90
2047566 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_10 2 55 27 0   1     0   0   39 46                       85.0 2 55 27 0   1     0   0   39 46                 85
2047567 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_11 1 33 19 0   0     0   1   28 26                       54.0 1 33 19 0   0     0   1   28 26                 54
2047568 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_12 2 43 11 0   3     0   1   34 26                       60.0 2 43 11 0   3     0   1   34 26                 60
2047569 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   pre_kindergarten 1 24 10 0   1     1   1   26 12                       38.0 1 24 10 0   1     1   1   26 12                 38
2047570 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   kindergarten 1 27 8 0   0     0   1   20 17                       37.0 1 27 8 0   0     0   1   20 17                 37
2047571 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_1 0 25 14 0   1     0   0   21 19                       40.0 0 25 14 0   1     0   0   21 19                 40
2047572 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_2 1 34 5 0   0     0   0   15 25                       40.0 1 34 5 0   0     0   0   15 25                 40
2047573 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_3 0 26 13 0   1     0   0   20 20                       40.0 0 26 13 0   1     0   0   20 20                 40
2047574 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_4 0 23 15 0   0     0   3   22 19                       41.0 0 23 15 0   0     0   3   22 19                 41
2047575 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_5 0 26 13 0   1     0   0   17 23                       40.0 0 26 13 0   1     0   0   17 23                 40
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
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
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
2047579 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_7 82 8 20 0   7     0   16   65 68                       133.0 82 8 20 0   7     0   16   65 68                 133
2047580 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_8 80 2 30 1   9     0   4   66 60                       126.0 80 2 30 1   9     0   4   66 60                 126
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
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
2047583 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_8 0 39 17 1   1     1   0   31 28                       59.0 0 39 17 1   1     1   0   31 28                 59
2047584 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   pre_kindergarten 0 21 3 0   0     0   0   11 13                       24.0 0 21 3 0   0     0   0   11 13                 24
2047585 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   kindergarten 3 33 6 0   0     1   2   17 28                       45.0 3 33 6 0   0     1   2   17 28                 45
2047586 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_1 1 42 5 0   0     0   2   23 27                       50.0 1 42 5 0   0     0   2   23 27                 50
2047587 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_2 1 40 6 0   0     0   3   24 26                       50.0 1 40 6 0   0     0   3   24 26                 50
2047588 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_3 2 39 3 1   2     1   0   27 21                       48.0 2 39 3 1   2     1   0   27 21                 48
2047589 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_4 0 40 8 0   0     0   0   23 25                       48.0 0 40 8 0   0     0   0   23 25                 48
2047590 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_5 0 38 3 0   0     0   0   22 19                       41.0 0 38 3 0   0     0   0   22 19                 41
2047591 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_6 0 42 5 0   1     0   0   27 21                       48.0 0 42 5 0   1     0   0   27 21                 48
2047592 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2019   grade_9 3 46 42 2   0     0   1   46 48                       94.0 3 46 42 2   0     0   1   46 48                 94
2047593 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2019   grade_10 4 34 31 0   1     0   0   31 39                       70.0 4 34 31 0   1     0   0   31 39                 70
2047594 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2019   grade_11 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2047595 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2019   grade_12 16 118 107 0   3     0   10   127 126                       254.0 16 118 107 0   3     0   10   127 126                 254
2047596 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   pre_kindergarten 3 0 36 1   0     0   0   20 20                       40.0 3 0 36 1   0     0   0   20 20                 40
2047597 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   kindergarten 2 2 38 0   0     0   0   24 18                       42.0 2 2 38 0   0     0   0   24 18                 42
2047598 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_1 1 0 41 0   0     0   0   25 17                       42.0 1 0 41 0   0     0   0   25 17                 42
2047599 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_2 0 0 42 0   0     0   0   15 27                       42.0 0 0 42 0   0     0   0   15 27                 42
2047600 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_3 2 0 40 0   0     0   0   23 19                       42.0 2 0 40 0   0     0   0   23 19                 42
2047601 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_4 0 1 41 0   1     0   0   22 21                       43.0 0 1 41 0   1     0   0   22 21                 43
2047602 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_5 1 1 35 0   0     0   0   23 14                       37.0 1 1 35 0   0     0   0   23 14                 37
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
2047604 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_7 0 0 32 0   1     0   0   14 19                       33.0 0 0 32 0   1     0   0   14 19                 33
2047605 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes Elementary KG 03 2019   kindergarten 35 5 24 0   4     0   4   36 36                       72.0 35 5 24 0   4     0   4   36 36                 72
2047606 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes Elementary KG 03 2019   grade_1 43 11 24 1   1     0   2   45 37                       82.0 43 11 24 1   1     0   2   45 37                 82
2047607 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes Elementary KG 03 2019   grade_2 29 16 17 0   3     0   1   31 35                       66.0 29 16 17 0   3     0   1   31 35                 66
2047608 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes Elementary KG 03 2019   grade_3 25 20 18 0   2     0   5   33 37                       70.0 25 20 18 0   2     0   5   33 37                 70

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