Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by rowid 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
2049374 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_12 175 11 22 1   4     0   12   75 150                       225.0 175 11 22 1   4     0   12   75 150                 225
2049373 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_11 210 18 36 0   11     0   21   108 188                       296.0 210 18 36 0   11     0   21   108 188                 296
2049372 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_10 235 18 38 1   9     2   17   124 196                       320.0 235 18 38 1   9     2   17   124 196                 320
2049371 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_9 252 35 56 1   10     1   35   157 233                       390.0 252 35 56 1   10     1   35   157 233                 390
2049370 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_8 163 16 31 2   8     0   11   105 126                       231.0 163 16 31 2   8     0   11   105 126                 231
2049369 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_7 111 16 27 0   5     0   22   89 92                       181.0 111 16 27 0   5     0   22   89 92                 181
2049368 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_6 62 12 27 0   1     1   12   51 64                       115.0 62 12 27 0   1     1   12   51 64                 115
2049367 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_5 51 7 16 0   3     0   6   48 35                       83.0 51 7 16 0   3     0   6   48 35                 83
2049366 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_4 35 8 14 0   2     0   11   35 35                       70.0 35 8 14 0   2     0   11   35 35                 70
2049365 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_3 36 9 9 1   3     0   1   27 32                       59.0 36 9 9 1   3     0   1   27 32                 59
2049364 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_2 24 8 15 1   1     1   3   22 31                       53.0 24 8 15 1   1     1   3   22 31                 53
2049363 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_1 27 9 16 1   1     0   5   36 23                       59.0 27 9 16 1   1     0   5   36 23                 59
2049362 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   kindergarten 32 8 14 1   2     0   4   34 27                       61.0 32 8 14 1   2     0   4   34 27                 61
2049361 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_12 34 2 6 0   0     0   3   14 31                       45.0 34 2 6 0   0     0   3   14 31                 45
2049360 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_11 39 3 6 0   0     0   3   24 27                       51.0 39 3 6 0   0     0   3   24 27                 51
2049359 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_10 49 2 13 0   3     0   6   21 52                       73.0 49 2 13 0   3     0   6   21 52                 73
2049358 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_9 52 9 19 1   2     1   2   32 54                       86.0 52 9 19 1   2     1   2   32 54                 86
2049357 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_8 41 3 16 0   6     1   5   41 31                       72.0 41 3 16 0   6     1   5   41 31                 72
2049356 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_7 29 5 9 0   3     0   3   27 22                       49.0 29 5 9 0   3     0   3   27 22                 49
2049355 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_6 23 4 7 1   5     0   3   24 19                       43.0 23 4 7 1   5     0   3   24 19                 43
2049354 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_5 26 7 7 0   2     2   6   29 21                       50.0 26 7 7 0   2     2   6   29 21                 50
2049353 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_4 18 6 8 0   1     0   0   20 13                       33.0 18 6 8 0   1     0   0   20 13                 33
2049352 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_3 13 6 6 0   1     0   1   13 14                       27.0 13 6 6 0   1     0   1   13 14                 27
2049351 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_2 11 10 2 0   1     0   2   15 11                       26.0 11 10 2 0   1     0   2   15 11                 26
2049350 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_1 13 7 2 0   1     0   1   10 14                       24.0 13 7 2 0   1     0   1   10 14                 24
2049349 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   kindergarten 6 1 4 0   0     0   0   2 9                       11.0 6 1 4 0   0     0   0   2 9                 11
2049348 MA Essex   school 2500590 3518   Phoenix Academy Public Charter High School Lawrence (District) 250059002886 35180505 Phoenix Academy Public Charter High School Lawrence   Regular School Yes High 09 12 2019   grade_12 2 0 14 0   0     0   0   8 8                       16.0 2 0 14 0   0     0   0   8 8                 16
2049347 MA Essex   school 2500590 3518   Phoenix Academy Public Charter High School Lawrence (District) 250059002886 35180505 Phoenix Academy Public Charter High School Lawrence   Regular School Yes High 09 12 2019   grade_11 1 0 21 0   0     0   0   15 7                       22.0 1 0 21 0   0     0   0   15 7                 22
2049346 MA Essex   school 2500590 3518   Phoenix Academy Public Charter High School Lawrence (District) 250059002886 35180505 Phoenix Academy Public Charter High School Lawrence   Regular School Yes High 09 12 2019   grade_10 0 0 8 0   0     0   0   3 5                       8.0 0 0 8 0   0     0   0   3 5                 8
2049345 MA Essex   school 2500590 3518   Phoenix Academy Public Charter High School Lawrence (District) 250059002886 35180505 Phoenix Academy Public Charter High School Lawrence   Regular School Yes High 09 12 2019   grade_9 4 0 68 1   0     0   0   52 21                       73.0 4 0 68 1   0     0   0   52 21                 73
2049344 MA Plymouth   school 2500589 3517   Map Academy Charter School (District) 250058902885 35170505 Map Academy Charter School   Regular School Yes High 09 12 2019   grade_12 11 2 1 0   0     0   0   8 6                       14.0 11 2 1 0   0     0   0   8 6                 14
2049343 MA Plymouth   school 2500589 3517   Map Academy Charter School (District) 250058902885 35170505 Map Academy Charter School   Regular School Yes High 09 12 2019   grade_11 30 3 6 0   0     1   2   25 17                       42.0 30 3 6 0   0     1   2   25 17                 42
2049342 MA Plymouth   school 2500589 3517   Map Academy Charter School (District) 250058902885 35170505 Map Academy Charter School   Regular School Yes High 09 12 2019   grade_10 29 2 9 1   0     0   4   28 17                       45.0 29 2 9 1   0     0   4   28 17                 45
2049341 MA Plymouth   school 2500589 3517   Map Academy Charter School (District) 250058902885 35170505 Map Academy Charter School   Regular School Yes High 09 12 2019   grade_9 13 3 10 0   0     1   2   21 8                       29.0 13 3 10 0   0     1   2   21 8                 29
2049340 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West   Regular School Yes Middle 06 09 2019   grade_9 25 5 8 0   1     0   2   18 23                       41.0 25 5 8 0   1     0   2   18 23                 41
2049339 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West   Regular School Yes Middle 06 09 2019   grade_8 25 7 19 0   1     0   1   27 26                       53.0 25 7 19 0   1     0   1   27 26                 53
2049338 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West   Regular School Yes Middle 06 09 2019   grade_7 35 5 13 1   1     0   1   31 25                       56.0 35 5 13 1   1     0   1   31 25                 56
2049337 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West   Regular School Yes Middle 06 09 2019   grade_6 30 9 19 0   0     0   1   31 28                       59.0 30 9 19 0   0     0   1   31 28                 59
2049336 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter Public School (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 04 2019   grade_4 36 2 2 0   0     0   0   20 20                       40.0 36 2 2 0   0     0   0   20 20                 40
2049335 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter Public School (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 04 2019   grade_3 29 3 7 0   1     0   0   24 16                       40.0 29 3 7 0   1     0   0   24 16                 40
2049334 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter Public School (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 04 2019   grade_2 34 1 4 0   1     0   0   17 23                       40.0 34 1 4 0   1     0   0   17 23                 40
2049333 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter Public School (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 04 2019   grade_1 31 4 5 0   0     0   0   23 17                       40.0 31 4 5 0   0     0   0   23 17                 40
2049332 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter Public School (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 04 2019   kindergarten 32 1 5 0   1     0   1   20 20                       40.0 32 1 5 0   1     0   1   20 20                 40
2049331 MA Hampden   school 2500586 3514   Libertas Academy Charter School (District) 250058602878 35140305 Libertas Academy Charter School   Regular School Yes Middle 06 07 2019   grade_7 2 10 77 0   0     0   2   55 36                       91.0 2 10 77 0   0     0   2   55 36                 91
2049330 MA Hampden   school 2500586 3514   Libertas Academy Charter School (District) 250058602878 35140305 Libertas Academy Charter School   Regular School Yes Middle 06 07 2019   grade_6 1 12 74 0   0     0   0   44 43                       87.0 1 12 74 0   0     0   0   44 43                 87
2049329 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_10 1 81 5 0   5     0   0   45 47                       92.0 1 81 5 0   5     0   0   45 47                 92
2049328 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_9 1 99 9 0   0     0   0   57 52                       109.0 1 99 9 0   0     0   0   57 52                 109
2049327 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_8 1 95 10 0   0     0   2   49 59                       108.0 1 95 10 0   0     0   2   49 59                 108
2049326 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_7 3 101 9 1   0     0   0   62 52                       114.0 3 101 9 1   0     0   0   62 52                 114
2049325 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 10 2019   grade_6 5 100 4 0   0     0   0   51 58                       109.0 5 100 4 0   0     0   0   51 58                 109
2049324 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2019   grade_5 11 6 20 0   0     0   2   20 19                       39.0 11 6 20 0   0     0   2   20 19                 39
2049323 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2019   grade_4 13 7 34 0   3     0   0   26 31                       57.0 13 7 34 0   3     0   0   26 31                 57
2049322 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2019   grade_3 23 5 29 0   2     0   1   27 33                       60.0 23 5 29 0   2     0   1   27 33                 60
2049321 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2019   grade_2 16 8 35 0   2     0   1   28 34                       62.0 16 8 35 0   2     0   1   28 34                 62
2049320 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2019   grade_1 15 9 37 0   0     0   2   34 29                       63.0 15 9 37 0   0     0   2   34 29                 63
2049319 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2019   kindergarten 8 5 40 0   1     0   4   23 35                       58.0 8 5 40 0   1     0   4   23 35                 58
2049318 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 04 2019   grade_4 10 12 33 0   0     0   3   30 28                       58.0 10 12 33 0   0     0   3   30 28                 58
2049317 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 04 2019   grade_3 1 12 35 0   2     0   0   28 22                       50.0 1 12 35 0   2     0   0   28 22                 50
2049316 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 04 2019   grade_2 9 17 25 0   1     0   2   28 26                       54.0 9 17 25 0   1     0   2   28 26                 54
2049315 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 04 2019   grade_1 3 10 39 0   2     0   0   22 32                       54.0 3 10 39 0   2     0   0   22 32                 54
2049314 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 04 2019   kindergarten 5 7 41 0   1     0   1   31 24                       55.0 5 7 41 0   1     0   1   31 24                 55
2049313 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_10 16 7 7 0   1     0   2   16 17                       33.0 16 7 7 0   1     0   2   16 17                 33
2049312 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_9 68 14 23 0   2     0   7   59 55                       114.0 68 14 23 0   2     0   7   59 55                 114
2049311 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_8 70 8 17 1   2     0   5   54 49                       103.0 70 8 17 1   2     0   5   54 49                 103
2049310 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_7 69 13 16 0   2     0   6   62 44                       106.0 69 13 16 0   2     0   6   62 44                 106
2049309 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_6 71 8 24 0   1     0   6   57 53                       110.0 71 8 24 0   1     0   6   57 53                 110
2049308 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2019   grade_12 4 9 7 0   0     0   1   12 9                       21.0 4 9 7 0   0     0   1   12 9                 21
2049307 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2019   grade_11 2 9 10 0   0     0   1   14 8                       22.0 2 9 10 0   0     0   1   14 8                 22
2049306 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2019   grade_10 1 0 10 0   0     0   0   6 5                       11.0 1 0 10 0   0     0   0   6 5                 11
2049305 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2019   grade_9 10 17 112 0   1     0   4   66 78                       144.0 10 17 112 0   1     0   4   66 78                 144
2049304 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes High 09 12 2019   grade_12 14 4 11 0   0     0   1   13 17                       30.0 14 4 11 0   0     0   1   13 17                 30
2049303 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes High 09 12 2019   grade_11 15 7 24 1   0     0   2   23 26                       49.0 15 7 24 1   0     0   2   23 26                 49
2049302 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes High 09 12 2019   grade_10 24 6 27 0   2     0   1   28 32                       60.0 24 6 27 0   2     0   1   28 32                 60
2049301 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes High 09 12 2019   grade_9 26 7 37 1   0     0   7   49 28                       78.0 26 7 37 1   0     0   7   49 28                 78
2049300 MA Essex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2019   grade_12 11 11 13 0   10     0   0   28 17                       45.0 11 11 13 0   10     0   0   28 17                 45
2049299 MA Essex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2019   grade_11 14 20 6 0   9     0   0   23 26                       49.0 14 20 6 0   9     0   0   23 26                 49
2049298 MA Essex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2019   grade_10 21 26 13 0   3     0   1   33 31                       64.0 21 26 13 0   3     0   1   33 31                 64
2049297 MA Essex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2019   grade_9 16 25 20 0   8     0   1   24 46                       70.0 16 25 20 0   8     0   1   24 46                 70
2049296 MA Essex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2019   grade_8 21 18 19 0   13     0   2   35 38                       73.0 21 18 19 0   13     0   2   35 38                 73
2049295 MA Essex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2019   grade_7 19 18 16 0   6     0   2   35 26                       61.0 19 18 16 0   6     0   2   35 26                 61
2049294 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   grade_8 0 33 23 0   1     0   1   27 31                       58.0 0 33 23 0   1     0   1   27 31                 58
2049293 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   grade_7 0 37 36 0   2     1   1   36 41                       77.0 0 37 36 0   2     1   1   36 41                 77
2049292 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   grade_6 2 48 38 0   0     0   3   45 46                       91.0 2 48 38 0   0     0   3   45 46                 91
2049291 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   grade_5 1 48 39 0   1     1   1   51 40                       91.0 1 48 39 0   1     1   1   51 40                 91
2049290 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   grade_4 0 45 26 0   1     1   0   40 33                       73.0 0 45 26 0   1     1   0   40 33                 73
2049289 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   grade_3 0 44 27 0   1     0   2   39 35                       74.0 0 44 27 0   1     0   2   39 35                 74
2049288 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   grade_2 1 43 22 2   0     1   1   33 37                       70.0 1 43 22 2   0     1   1   33 37                 70
2049287 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   grade_1 2 39 30 0   0     0   2   38 35                       73.0 2 39 30 0   0     0   2   38 35                 73
2049286 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   kindergarten 1 32 27 0   0     0   1   34 27                       61.0 1 32 27 0   0     0   1   34 27                 61
2049285 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   pre_kindergarten 1 28 25 1   0     1   0   22 34                       56.0 1 28 25 1   0     1   0   22 34                 56
2049284 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2019   grade_12 1 43 12 0   3     0   0   25 34                       59.0 1 43 12 0   3     0   0   25 34                 59
2049283 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2019   grade_11 0 44 11 0   0     0   1   23 33                       56.0 0 44 11 0   0     0   1   23 33                 56
2049282 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2019   grade_10 0 36 14 0   2     0   1   25 28                       53.0 0 36 14 0   2     0   1   25 28                 53
2049281 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2019   grade_9 3 43 29 0   1     0   1   45 32                       77.0 3 43 29 0   1     0   1   45 32                 77
2049280 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 08 2019   grade_8 15 10 14 0   16     0   3   26 32                       58.0 15 10 14 0   16     0   3   26 32                 58
2049279 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 08 2019   grade_7 16 8 28 0   8     0   3   36 27                       63.0 16 8 28 0   8     0   3   36 27                 63
2049278 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 08 2019   grade_6 7 14 28 0   27     0   4   39 41                       80.0 7 14 28 0   27     0   4   39 41                 80
2049277 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 08 2019   grade_5 19 23 48 0   24     0   6   52 68                       120.0 19 23 48 0   24     0   6   52 68                 120
2049276 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 08 2019   grade_4 13 16 44 1   19     0   1   45 49                       94.0 13 16 44 1   19     0   1   45 49                 94
2049275 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 08 2019   grade_3 19 24 35 0   28     0   6   50 62                       112.0 19 24 35 0   28     0   6   50 62                 112

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