Data source: Big Local News · About: Big Local

9,499 rows where state = "MA" and year = 2016 sorted by school_nces_id

View and edit SQL

year

  • 2016 · 9,399
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
940291 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2016   grade_4 3 40 5 1   0     0   1   16 34                       50 3 40 5 1   0     0   1   16 34                 50
940292 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2016   grade_5 0 26 9 1   1     0   2   19 20                       39 0 26 9 1   1     0   2   19 20                 39
940293 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes 1 KG 06 2016   grade_6 1 32 4 0   1     0   0   20 18                       38 1 32 4 0   1     0   0   20 18                 38
940339 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2016   grade_6 70 1 4 0   0     0   5   32 48                       80 70 1 4 0   0     0   5   32 48                 80
940340 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2016   grade_7 71 0 5 0   1     0   3   31 49                       80 71 0 5 0   1     0   3   31 49                 80
940341 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2016   grade_8 70 3 1 0   2     0   4   42 38                       80 70 3 1 0   2     0   4   42 38                 80
940342 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_5 86 2 6 0   6     0   5   63 42                       105 86 2 6 0   6     0   5   63 42                 105
940343 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_6 83 4 1 0   10     0   2   48 52                       100 83 4 1 0   10     0   2   48 52                 100
940344 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_7 80 3 6 0   8     0   3   51 49                       100 80 3 6 0   8     0   3   51 49                 100
940345 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_8 82 3 4 1   6     0   4   47 53                       100 82 3 4 1   6     0   4   47 53                 100
940346 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_9 88 5 8 0   4     0   5   50 60                       110 88 5 8 0   4     0   5   50 60                 110
940347 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_10 81 2 9 0   8     0   4   46 58                       104 81 2 9 0   8     0   4   46 58                 104
940348 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_11 74 3 7 0   7     0   3   41 53                       94 74 3 7 0   7     0   3   41 53                 94
940349 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_12 68 4 4 0   2     0   1   44 35                       79 68 4 4 0   2     0   1   44 35                 79
940357 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes 3 09 12 2016   grade_9 2 87 17 0   0     0   2   46 62                       108 2 87 17 0   0     0   2   46 62                 108
940358 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes 3 09 12 2016   grade_10 3 32 23 0   0     0   2   24 36                       60 3 32 23 0   0     0   2   24 36                 60
940359 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes 3 09 12 2016   grade_11 1 39 20 1   0     1   0   30 32                       62 1 39 20 1   0     1   0   30 32                 62
940360 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes 3 09 12 2016   grade_12 0 35 19 0   0     0   0   26 28                       54 0 35 19 0   0     0   0   26 28                 54
940383 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2016   kindergarten 0 1 49 0   0     0   0   25 25                       50 0 1 49 0   0     0   0   25 25                 50
940384 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2016   pre_kindergarten 2 0 40 0   0     0   0   22 20                       42 2 0 40 0   0     0   0   22 20                 42
940385 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2016   grade_1 0 0 47 0   0     0   0   29 18                       47 0 0 47 0   0     0   0   29 18                 47
940386 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2016   grade_2 0 0 46 0   0     0   0   23 23                       46 0 0 46 0   0     0   0   23 23                 46
940387 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2016   grade_3 4 1 37 0   0     0   0   22 20                       42 4 1 37 0   0     0   0   22 20                 42
940388 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2016   grade_4 2 0 40 0   0     0   0   16 26                       42 2 0 40 0   0     0   0   16 26                 42
940389 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2016   grade_5 1 0 18 0   1     0   0   11 9                       20 1 0 18 0   1     0   0   11 9                 20
940390 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2016   grade_6 2 0 19 0   1     0   0   12 10                       22 2 0 19 0   1     0   0   12 10                 22
940391 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2016   grade_7 2 0 44 0   0     0   0   24 22                       46 2 0 44 0   0     0   0   24 22                 46
940392 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2016   grade_8 5 1 37 0   0     0   0   12 31                       43 5 1 37 0   0     0   0   12 31                 43
940393 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   kindergarten 19 28 45 0   3     0   5   55 45                       100 19 28 45 0   3     0   5   55 45                 100
940394 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_1 24 25 54 0   5     0   4   61 51                       112 24 25 54 0   5     0   4   61 51                 112
940395 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_2 24 42 38 0   9     0   7   58 62                       120 24 42 38 0   9     0   7   58 62                 120
940396 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_3 26 30 61 0   5     0   6   68 60                       128 26 30 61 0   5     0   6   68 60                 128
940397 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_4 33 39 47 0   5     0   4   65 63                       128 33 39 47 0   5     0   4   65 63                 128
940398 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_5 30 32 53 0   6     0   7   64 64                       128 30 32 53 0   6     0   7   64 64                 128
940399 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_6 34 36 47 0   5     0   12   61 73                       134 34 36 47 0   5     0   12   61 73                 134
940400 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_7 47 28 41 0   5     0   7   60 68                       128 47 28 41 0   5     0   7   60 68                 128
940401 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_8 29 35 53 0   7     0   7   66 65                       131 29 35 53 0   7     0   7   66 65                 131
940402 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_9 33 49 41 0   8     0   5   63 73                       136 33 49 41 0   8     0   5   63 73                 136
940403 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_10 28 48 34 0   2     0   1   58 55                       113 28 48 34 0   2     0   1   58 55                 113
940404 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_11 35 31 37 0   0     0   4   42 65                       107 35 31 37 0   0     0   4   42 65                 107
940405 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_12 29 37 32 0   2     0   8   50 58                       108 29 37 32 0   2     0   8   50 58                 108
940415 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2016   kindergarten 7 25 5 0   3     0   2   18 24                       42 7 25 5 0   3     0   2   18 24                 42
940416 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2016   pre_kindergarten 11 18 5 0   4     0   2   15 25                       40 11 18 5 0   4     0   2   15 25                 40
940417 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2016   grade_1 8 18 13 0   2     0   1   21 21                       42 8 18 13 0   2     0   1   21 21                 42
940418 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2016   grade_2 8 25 3 1   1     0   3   17 24                       41 8 25 3 1   1     0   3   17 24                 41
940419 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2016   grade_3 10 21 7 0   0     0   4   23 19                       42 10 21 7 0   0     0   4   23 19                 42
940420 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2016   grade_4 6 22 6 1   2     0   5   24 18                       42 6 22 6 1   2     0   5   24 18                 42
940421 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2016   grade_5 9 19 9 0   1     0   3   24 17                       41 9 19 9 0   1     0   3   24 17                 41
940422 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2016   grade_6 9 21 6 2   2     0   0   20 20                       40 9 21 6 2   2     0   0   20 20                 40
940423 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2016   grade_7 5 17 7 0   2     0   0   17 14                       31 5 17 7 0   2     0   0   17 14                 31
940424 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2016   grade_8 4 22 6 0   0     0   2   14 20                       34 4 22 6 0   0     0   2   14 20                 34
940451 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2016   kindergarten 50 0 0 0   0     0   0   30 20                       50 50 0 0 0   0     0   0   30 20                 50
940452 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2016   grade_1 32 0 0 0   15     0   3   20 30                       50 32 0 0 0   15     0   3   20 30                 50
940453 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2016   grade_2 35 0 3 0   9     0   3   27 23                       50 35 0 3 0   9     0   3   27 23                 50
940454 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2016   grade_3 39 0 0 0   12     0   0   19 32                       51 39 0 0 0   12     0   0   19 32                 51
940455 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2016   grade_4 39 1 2 1   8     0   1   23 29                       52 39 1 2 1   8     0   1   23 29                 52
940456 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2016   grade_5 33 0 3 0   10     0   5   28 23                       51 33 0 3 0   10     0   5   28 23                 51
940457 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2016   grade_6 34 1 0 0   12     0   0   22 25                       47 34 1 0 0   12     0   0   22 25                 47
940458 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2016   grade_7 30 0 1 0   14     0   3   32 16                       48 30 0 1 0   14     0   3   32 16                 48
940459 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2016   grade_8 38 1 1 0   6     0   1   20 27                       47 38 1 1 0   6     0   1   20 27                 47
940468 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2016   kindergarten 18 0 1 0   0     0   1   9 11                       20 18 0 1 0   0     0   1   9 11                 20
940469 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2016   grade_1 16 0 1 0   0     0   3   10 10                       20 16 0 1 0   0     0   3   10 10                 20
940470 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2016   grade_2 17 0 0 0   1     0   3   9 12                       21 17 0 0 0   1     0   3   9 12                 21
940471 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2016   grade_3 19 1 1 0   0     0   0   13 8                       21 19 1 1 0   0     0   0   13 8                 21
940472 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2016   grade_4 17 0 2 0   0     0   2   12 9                       21 17 0 2 0   0     0   2   12 9                 21
940473 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2016   grade_5 19 0 1 0   0     0   2   15 7                       22 19 0 1 0   0     0   2   15 7                 22
940474 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2016   grade_6 25 0 5 0   1     0   1   12 20                       32 25 0 5 0   1     0   1   12 20                 32
940475 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2016   grade_7 29 0 2 0   0     0   0   19 12                       31 29 0 2 0   0     0   0   19 12                 31
940476 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2016   grade_8 15 0 2 0   1     0   5   11 12                       23 15 0 2 0   1     0   5   11 12                 23
940490 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   kindergarten 0 0 80 0   0     0   0   36 44                       80 0 0 80 0   0     0   0   36 44                 80
940491 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   pre_kindergarten 0 0 85 0   0     0   0   38 47                       85 0 0 85 0   0     0   0   38 47                 85
940492 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   grade_1 0 1 82 0   0     0   0   43 40                       83 0 1 82 0   0     0   0   43 40                 83
940493 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   grade_2 1 0 83 0   0     0   0   48 36                       84 1 0 83 0   0     0   0   48 36                 84
940494 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   grade_3 1 1 78 0   0     0   0   32 48                       80 1 1 78 0   0     0   0   32 48                 80
940495 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   grade_4 1 2 56 0   0     0   0   28 31                       59 1 2 56 0   0     0   0   28 31                 59
940496 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   grade_5 0 0 56 0   0     0   0   26 30                       56 0 0 56 0   0     0   0   26 30                 56
940497 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   grade_6 0 1 54 0   0     0   0   20 35                       55 0 1 54 0   0     0   0   20 35                 55
940498 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   grade_7 1 0 55 0   0     0   0   26 30                       56 1 0 55 0   0     0   0   26 30                 56
940499 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   grade_8 0 0 62 0   0     0   0   27 35                       62 0 0 62 0   0     0   0   27 35                 62
940528 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter School   Regular School Yes 3 09 12 2016   grade_9 11 0 7 0   2     0   2   11 11                       22 11 0 7 0   2     0   2   11 11                 22
940529 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter School   Regular School Yes 3 09 12 2016   grade_10 10 1 4 0   0     0   1   8 8                       16 10 1 4 0   0     0   1   8 8                 16
940530 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter School   Regular School Yes 3 09 12 2016   grade_11 13 1 9 0   3     0   3   15 14                       29 13 1 9 0   3     0   3   15 14                 29
940531 MA Middlesex   school 2500033 458   Lowell Middlesex Academy Charter (District) 250003300555 4580505 Lowell Middlesex Academy Charter School   Regular School Yes 3 09 12 2016   grade_12 13 2 5 0   2     0   6   10 18                       28 13 2 5 0   2     0   6   10 18                 28
940538 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes 2 04 08 2016   grade_4 42 1 1 0   2     0   2   27 21                       48 42 1 1 0   2     0   2   27 21                 48
940539 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes 2 04 08 2016   grade_5 46 2 2 1   0     0   0   31 20                       51 46 2 2 1   0     0   0   31 20                 51
940540 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes 2 04 08 2016   grade_6 46 1 0 0   1     0   0   23 25                       48 46 1 0 0   1     0   0   23 25                 48
940541 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes 2 04 08 2016   grade_7 45 0 2 0   1     0   0   21 27                       48 45 0 2 0   1     0   0   21 27                 48
940542 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes 2 04 08 2016   grade_8 33 1 0 0   2     0   0   16 20                       36 33 1 0 0   2     0   0   16 20                 36
940543 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   kindergarten 14 0 1 0   0     0   1   7 9                       16 14 0 1 0   0     0   1   7 9                 16
940544 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_1 9 0 1 0   0     0   4   6 8                       14 9 0 1 0   0     0   4   6 8                 14
940545 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_2 12 0 0 0   0     0   2   3 11                       14 12 0 0 0   0     0   2   3 11                 14
940546 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_3 14 1 1 0   0     0   1   8 9                       17 14 1 1 0   0     0   1   8 9                 17
940547 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_4 12 2 0 0   0     0   0   4 10                       14 12 2 0 0   0     0   0   4 10                 14
940548 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_5 13 1 1 0   1     0   2   6 12                       18 13 1 1 0   1     0   2   6 12                 18
940549 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_6 4 2 1 0   0     0   1   2 6                       8 4 2 1 0   0     0   1   2 6                 8
940550 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_7 12 0 1 0   2     0   1   12 4                       16 12 0 1 0   2     0   1   12 4                 16
940551 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_8 12 1 0 0   0     0   2   7 8                       15 12 1 0 0   0     0   2   7 8                 15
940552 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_9 5 0 1 0   0     0   0   3 3                       6 5 0 1 0   0     0   0   3 3                 6
940553 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_10 14 1 0 0   1     0   1   8 9                       17 14 1 0 0   1     0   1   8 9                 17
940554 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_11 11 0 2 0   0     0   1   5 9                       14 11 0 2 0   0     0   1   5 9                 14

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