Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by ccd_charter_school descending

View and edit SQL

grade

year

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
743405 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes 1 PK 03 2015   kindergarten 0 33 9 0   0     0   2   17 27                       44 0 33 9 0   0     0   2   17 27                 44
743406 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes 1 PK 03 2015   pre_kindergarten 0 31 14 0   0     0   0   17 28                       45 0 31 14 0   0     0   0   17 28                 45
743407 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes 1 PK 03 2015   grade_1 0 31 12 1   0     0   0   21 23                       44 0 31 12 1   0     0   0   21 23                 44
743408 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes 1 PK 03 2015   grade_2 0 26 17 0   0     0   0   21 22                       43 0 26 17 0   0     0   0   21 22                 43
743409 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes 1 PK 03 2015   grade_3 0 27 17 0   0     0   0   18 26                       44 0 27 17 0   0     0   0   18 26                 44
743410 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 05 2015   kindergarten 11 2 19 3   0     1   3   20 19                       39 11 2 19 3   0     1   3   20 19                 39
743411 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 05 2015   grade_1 13 6 19 0   0     0   2   21 19                       40 13 6 19 0   0     0   2   21 19                 40
743412 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 05 2015   grade_2 6 9 21 1   0     0   1   14 24                       38 6 9 21 1   0     0   1   14 24                 38
743413 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 05 2015   grade_3 18 6 15 1   0     0   4   20 24                       44 18 6 15 1   0     0   4   20 24                 44
743414 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 05 2015   grade_4 9 7 19 0   0     0   3   17 21                       38 9 7 19 0   0     0   3   17 21                 38
743415 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes 1 KG 05 2015   grade_5 14 7 16 1   2     0   1   19 22                       41 14 7 16 1   2     0   1   19 22                 41
743416 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 08 2015   grade_5 14 10 136 5   2     0   0   80 87                       167 14 10 136 5   2     0   0   80 87                 167
743417 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 08 2015   grade_6 20 13 131 0   3     0   1   97 71                       168 20 13 131 0   3     0   1   97 71                 168
743418 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 08 2015   grade_7 19 12 131 0   2     0   3   85 82                       167 19 12 131 0   2     0   3   85 82                 167
743419 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 08 2015   grade_8 15 9 71 0   6     0   1   52 50                       102 15 9 71 0   6     0   1   52 50                 102
743420 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 4 06 12 2015   grade_6 4 40 21 0   4     0   0   33 36                       69 4 40 21 0   4     0   0   33 36                 69
743421 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 4 06 12 2015   grade_9 3 35 29 1   2     0   1   39 32                       71 3 35 29 1   2     0   1   39 32                 71
743422 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 4 06 12 2015   grade_10 8 46 24 1   3     0   1   45 38                       83 8 46 24 1   3     0   1   45 38                 83
743423 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 4 06 12 2015   grade_11 11 45 18 0   2     0   1   46 31                       77 11 45 18 0   2     0   1   46 31                 77
743424 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 4 06 12 2015   grade_12 11 43 24 0   2     0   0   38 42                       80 11 43 24 0   2     0   0   38 42                 80
743425 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 4 06 12 2015   SP 0 8 4 0   1     0   0                             13 0 8 4 0   1     0   0                       13
743426 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 4 05 12 2015   grade_5 16 41 19 0   0     0   1   38 39                       77 16 41 19 0   0     0   1   38 39                 77
743427 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 4 05 12 2015   grade_6 4 47 22 0   0     0   1   36 38                       74 4 47 22 0   0     0   1   36 38                 74
743428 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 4 05 12 2015   grade_7 12 48 14 0   1     0   2   38 39                       77 12 48 14 0   1     0   2   38 39                 77
743429 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 4 05 12 2015   grade_8 10 41 20 0   2     0   5   37 41                       78 10 41 20 0   2     0   5   37 41                 78
743430 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 4 05 12 2015   grade_9 6 33 12 0   0     0   1   22 30                       52 6 33 12 0   0     0   1   22 30                 52
743431 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 4 05 12 2015   grade_10 11 32 10 0   0     0   3   21 35                       56 11 32 10 0   0     0   3   21 35                 56
743432 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 4 05 12 2015   grade_11 14 37 4 0   0     0   3   27 31                       58 14 37 4 0   0     0   3   27 31                 58
743433 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 4 05 12 2015   grade_12 9 27 8 0   2     0   1   17 30                       47 9 27 8 0   2     0   1   17 30                 47
743434 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes 3 07 12 2015   grade_7 33 0 1 0   1     0   2   16 21                       37 33 0 1 0   1     0   2   16 21                 37
743435 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes 3 07 12 2015   grade_8 29 0 3 0   0     0   4   16 20                       36 29 0 3 0   0     0   4   16 20                 36
743436 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes 3 07 12 2015   grade_9 32 0 2 0   1     0   1   23 13                       36 32 0 2 0   1     0   1   23 13                 36
743437 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes 3 07 12 2015   grade_10 31 0 0 0   3     0   3   12 25                       37 31 0 0 0   3     0   3   12 25                 37
743438 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes 3 07 12 2015   grade_11 32 1 2 0   0     0   0   13 22                       35 32 1 2 0   0     0   0   13 22                 35
743439 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes 3 07 12 2015   grade_12 34 1 0 0   1     0   0   22 14                       36 34 1 0 0   1     0   0   22 14                 36
743440 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_6 51 17 1 0   0     0   3   39 33                       72 51 17 1 0   0     0   3   39 33                 72
743441 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_7 49 10 2 0   1     0   2   35 29                       64 49 10 2 0   1     0   2   35 29                 64
743442 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_8 46 11 6 0   3     0   3   35 34                       69 46 11 6 0   3     0   3   35 34                 69
743443 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_9 43 7 4 0   2     1   0   22 35                       57 43 7 4 0   2     1   0   22 35                 57
743444 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_10 22 1 0 0   0     0   0   11 12                       23 22 1 0 0   0     0   0   11 12                 23
743445 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_11 22 3 1 0   1     1   0   12 16                       28 22 3 1 0   1     1   0   12 16                 28
743446 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_12 19 1 0 0   0     0   1   9 12                       21 19 1 0 0   0     0   1   9 12                 21
743447 MA Essex   school 2500069 415   Amesbury Academy Charter Public (District) 250006901666 4150505 Amesbury Academy Charter Public School   Regular School Yes 3 09 12 2015   grade_9 8 0 0 0   0     0   1   6 3                       9 8 0 0 0   0     0   1   6 3                 9
743448 MA Essex   school 2500069 415   Amesbury Academy Charter Public (District) 250006901666 4150505 Amesbury Academy Charter Public School   Regular School Yes 3 09 12 2015   grade_10 15 0 0 0   0     0   0   9 6                       15 15 0 0 0   0     0   0   9 6                 15
743449 MA Essex   school 2500069 415   Amesbury Academy Charter Public (District) 250006901666 4150505 Amesbury Academy Charter Public School   Regular School Yes 3 09 12 2015   grade_11 8 0 1 0   0     0   0   4 5                       9 8 0 1 0   0     0   0   4 5                 9
743450 MA Essex   school 2500069 415   Amesbury Academy Charter Public (District) 250006901666 4150505 Amesbury Academy Charter Public School   Regular School Yes 3 09 12 2015   grade_12 10 0 1 0   1     0   1   6 7                       13 10 0 1 0   1     0   1   6 7                 13
743451 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2015   grade_6 2 40 15 0   0     0   1   30 28                       58 2 40 15 0   0     0   1   30 28                 58
743452 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2015   grade_7 1 38 19 0   0     0   0   26 32                       58 1 38 19 0   0     0   0   26 32                 58
743453 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2015   grade_8 2 44 11 0   1     0   0   32 26                       58 2 44 11 0   1     0   0   32 26                 58
743454 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2015   grade_9 4 55 16 0   0     0   0   42 33                       75 4 55 16 0   0     0   0   42 33                 75
743455 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2015   grade_10 2 33 14 2   0     0   2   22 31                       53 2 33 14 2   0     0   2   22 31                 53
743456 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2015   grade_11 1 28 11 0   0     1   4   9 36                       45 1 28 11 0   0     1   4   9 36                 45
743457 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2015   grade_12 0 29 13 1   0     0   1   22 22                       44 0 29 13 1   0     0   1   22 22                 44
743458 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes 1 PK 03 2015   kindergarten 0 22 13 0   0     0   5   19 21                       40 0 22 13 0   0     0   5   19 21                 40
743459 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes 1 PK 03 2015   pre_kindergarten 1 20 17 0   1     0   0   19 20                       39 1 20 17 0   1     0   0   19 20                 39
743460 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes 1 PK 03 2015   grade_1 0 23 13 0   1     0   1   19 19                       38 0 23 13 0   1     0   1   19 19                 38
743461 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes 1 PK 03 2015   grade_2 0 21 11 0   0     0   5   16 21                       37 0 21 11 0   0     0   5   16 21                 37
743462 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes 1 PK 03 2015   grade_3 0 23 10 0   1     0   1   15 20                       35 0 23 10 0   1     0   1   15 20                 35
743463 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes 2 06 08 2015   grade_6 95 10 22 1   11     0   5   80 64                       144 95 10 22 1   11     0   5   80 64                 144
743464 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes 2 06 08 2015   grade_7 125 1 6 0   5     0   1   67 71                       138 125 1 6 0   5     0   1   67 71                 138
743465 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes 2 06 08 2015   grade_8 83 9 14 2   10     0   3   55 66                       121 83 9 14 2   10     0   3   55 66                 121
743466 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes 2 06 08 2015   grade_6 0 55 12 0   0     1   1   36 33                       69 0 55 12 0   0     1   1   36 33                 69
743467 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes 2 06 08 2015   grade_7 0 69 13 0   0     0   2   45 39                       84 0 69 13 0   0     0   2   45 39                 84
743468 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes 2 06 08 2015   grade_8 0 56 12 0   1     0   2   24 47                       71 0 56 12 0   1     0   2   24 47                 71
743469 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   kindergarten 1 54 12 0   0     0   0   31 36                       67 1 54 12 0   0     0   0   31 36                 67
743470 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   grade_1 0 39 8 1   0     0   0   20 28                       48 0 39 8 1   0     0   0   20 28                 48
743471 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   grade_2 0 48 5 0   2     0   0   31 24                       55 0 48 5 0   2     0   0   31 24                 55
743472 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   grade_3 2 44 4 1   0     0   1   18 34                       52 2 44 4 1   0     0   1   18 34                 52
743473 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   grade_4 0 31 9 1   1     0   2   20 24                       44 0 31 9 1   1     0   2   20 24                 44
743474 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   grade_5 1 35 6 0   1     0   0   24 19                       43 1 35 6 0   1     0   0   24 19                 43
743475 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2015   grade_6 0 29 9 0   0     0   0   16 22                       38 0 29 9 0   0     0   0   16 22                 38
743476 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes 3 09 12 2015   grade_9 5 34 37 0   0     1   2   32 47                       79 5 34 37 0   0     1   2   32 47                 79
743477 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes 3 09 12 2015   grade_10 3 15 15 0   0     0   0   14 19                       33 3 15 15 0   0     0   0   14 19                 33
743478 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes 3 09 12 2015   grade_11 8 57 30 1   1     0   5   50 52                       102 8 57 30 1   1     0   5   50 52                 102
743479 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes 3 09 12 2015   grade_12 16 93 48 1   3     1   4   73 93                       166 16 93 48 1   3     1   4   73 93                 166
743480 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes 1 PK 03 2015   kindergarten 0 1 38 0   1     0   1   20 21                       41 0 1 38 0   1     0   1   20 21                 41
743481 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes 1 PK 03 2015   pre_kindergarten 3 0 38 0   0     0   0   20 21                       41 3 0 38 0   0     0   0   20 21                 41
743482 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes 1 PK 03 2015   grade_1 1 1 38 0   0     0   0   26 14                       40 1 1 38 0   0     0   0   26 14                 40
743483 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes 1 PK 03 2015   grade_2 1 0 38 0   0     0   0   22 17                       39 1 0 38 0   0     0   0   22 17                 39
743484 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes 1 PK 03 2015   grade_3 2 0 36 0   1     0   0   19 20                       39 2 0 36 0   1     0   0   19 20                 39
743485 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes 1 KG 03 2015   kindergarten 48 7 14 1   3     1   1   39 36                       75 48 7 14 1   3     1   1   39 36                 75
743486 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes 1 KG 03 2015   grade_1 52 4 9 2   0     0   1   33 35                       68 52 4 9 2   0     0   1   33 35                 68
743487 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes 1 KG 03 2015   grade_2 57 7 4 0   5     1   1   31 44                       75 57 7 4 0   5     1   1   31 44                 75
743488 MA Barnstable   school 2500081 427   Barnstable Community Horace Mann Charter Public (District) 250008101844 4270010 Barnstable Community Horace Mann Charter Public School   Regular School Yes 1 KG 03 2015   grade_3 55 3 11 0   1     0   3   40 33                       73 55 3 11 0   1     0   3   40 33                 73
743489 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2015   kindergarten 1 41 13 0   2     0   3   34 26                       60 1 41 13 0   2     0   3   34 26                 60
743490 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2015   grade_1 0 44 18 0   1     0   3   35 31                       66 0 44 18 0   1     0   3   35 31                 66
743491 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2015   grade_2 0 40 18 0   2     0   3   26 37                       63 0 40 18 0   2     0   3   26 37                 63
743492 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2015   grade_3 0 40 18 0   0     0   0   33 25                       58 0 40 18 0   0     0   0   33 25                 58
743493 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2015   grade_4 2 43 16 0   1     0   4   32 34                       66 2 43 16 0   1     0   4   32 34                 66
743494 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2015   grade_5 3 34 14 0   0     0   3   27 27                       54 3 34 14 0   0     0   3   27 27                 54
743495 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2015   grade_6 0 39 9 0   1     0   4   24 29                       53 0 39 9 0   1     0   4   24 29                 53
743496 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2015   grade_7 0 43 7 0   0     0   1   21 30                       51 0 43 7 0   0     0   1   21 30                 51
743497 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School Roslindale   Regular School Yes 1 KG 08 2015   grade_8 0 26 9 0   0     0   0   15 20                       35 0 26 9 0   0     0   0   15 20                 35
743498 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_5 12 33 69 0   1     0   5   62 58                       120 12 33 69 0   1     0   5   62 58                 120
743499 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_6 11 22 80 0   5     0   3   52 69                       121 11 22 80 0   5     0   3   52 69                 121
743500 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_7 13 34 69 0   2     0   2   61 59                       120 13 34 69 0   2     0   2   61 59                 120
743501 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_8 7 27 57 0   2     0   2   42 53                       95 7 27 57 0   2     0   2   42 53                 95
743502 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_9 10 28 69 0   2     0   3   61 51                       112 10 28 69 0   2     0   3   61 51                 112
743503 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_10 8 34 69 0   1     0   2   51 63                       114 8 34 69 0   1     0   2   51 63                 114
743504 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_11 7 25 47 0   4     0   1   37 47                       84 7 25 47 0   4     0   1   37 47                 84

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