Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by rowid descending

View and edit SQL

year

  • 2020 · 9,537
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
1374320 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   sped_beyond_grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1374319 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1374318 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_11 * * * *   *     *   *   * * *                     0.0                                             0
1374317 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_10 * * * *   *     *   *   * * *                     0.0                                             0
1374316 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1374315 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1374314 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_7 * * * *   *     *   *   * * *                     0.0                                             0
1374313 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1374312 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1374311 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_4 * * * *   *     *   *   * * *                     0.0                                             0
1374310 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_3 * * * *   *     *   *   * * *                     0.0                                             0
1374309 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1374308 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1374307 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   pre_kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1374306 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   kindergarten * * * *   *     *   *   * * *                     0.0                                             0
1374305 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 2020   grade_12 205 8 39 0   12     1   12   91 186 *                     277.0 205 8 39 0   12     1   12   91 186                 277
1374304 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 2020   grade_11 228 17 41 0   8     2   13   105 204 *                     309.0 228 17 41 0   8     2   13   105 204                 309
1374303 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 2020   grade_10 242 29 52 2   3     1   28   130 227 *                     357.0 242 29 52 2   3     1   28   130 227                 357
1374302 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 2020   grade_9 248 21 71 1   8     0   29   176 202 *                     378.0 248 21 71 1   8     0   29   176 202                 378
1374301 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 2020   grade_8 156 19 37 0   7     0   18   91 146 *                     237.0 156 19 37 0   7     0   18   91 146                 237
1374300 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 2020   grade_7 109 14 39 0   2     0   17   87 94 *                     181.0 109 14 39 0   2     0   17   87 94                 181
1374299 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 2020   grade_6 76 10 20 0   6     3   9   66 58 *                     124.0 76 10 20 0   6     3   9   66 58                 124
1374298 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 2020   grade_5 33 9 14 0   3     0   9   37 31 *                     68.0 33 9 14 0   3     0   9   37 31                 68
1374297 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 2020   grade_4 36 9 16 1   4     0   4   30 40 *                     70.0 36 9 16 1   4     0   4   30 40                 70
1374296 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 2020   grade_3 22 8 13 0   1     0   5   20 29 *                     49.0 22 8 13 0   1     0   5   20 29                 49
1374295 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 2020   grade_2 22 8 16 0   3     1   4   28 26 *                     54.0 22 8 16 0   3     1   4   28 26                 54
1374294 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 2020   grade_1 21 7 10 0   1     0   2   25 16 *                     41.0 21 7 10 0   1     0   2   25 16                 41
1374293 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 2020   kindergarten 15 9 11 0   0     0   3   23 15 *                     38.0 15 9 11 0   0     0   3   23 15                 38
1374292 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_12 47 3 8 0   0     0   6   25 39 *                     64.0 47 3 8 0   0     0   6   25 39                 64
1374291 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_11 50 4 16 0   1     0   7   17 59 *                     78.0 50 4 16 0   1     0   7   17 59                 78
1374290 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_10 42 7 17 0   3     0   3   31 40 *                     72.0 42 7 17 0   3     0   3   31 40                 72
1374289 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_9 62 5 21 1   7     1   13   53 57 *                     110.0 62 5 21 1   7     1   13   53 57                 110
1374288 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_8 45 6 15 0   3     0   7   38 37 *                     76.0 45 6 15 0   3     0   7   38 37                 76
1374287 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_7 35 3 11 0   5     0   6   25 35 *                     60.0 35 3 11 0   5     0   6   25 35                 60
1374286 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_6 35 5 10 0   3     0   6   31 28 *                     59.0 35 5 10 0   3     0   6   31 28                 59
1374285 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_5 15 6 7 0   2     0   4   23 11 *                     34.0 15 6 7 0   2     0   4   23 11                 34
1374284 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_4 17 5 3 0   1     0   0   15 11 *                     26.0 17 5 3 0   1     0   0   15 11                 26
1374283 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_3 11 4 3 0   2     0   2   9 13 *                     22.0 11 4 3 0   2     0   2   9 13                 22
1374282 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_2 13 6 5 0   3     0   1   11 17 *                     28.0 13 6 5 0   3     0   1   11 17                 28
1374281 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_1 11 2 2 0   2     0   2   6 13 *                     19.0 11 2 2 0   2     0   2   6 13                 19
1374280 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   kindergarten 7 1 6 0   1     0   0   3 12 *                     15.0 7 1 6 0   1     0   0   3 12                 15
1374279 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 2020   grade_12 2 0 10 0   0     0   0   5 7 *                     12.0 2 0 10 0   0     0   0   5 7                 12
1374278 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 2020   grade_11 0 0 29 0   0     0   0   19 10 *                     29.0 0 0 29 0   0     0   0   19 10                 29
1374277 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 2020   grade_10 0 0 9 0   0     0   0   3 6 *                     9.0 0 0 9 0   0     0   0   3 6                 9
1374276 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 2020   grade_9 2 0 72 0   0     0   0   53 21 *                     74.0 2 0 72 0   0     0   0   53 21                 74
1374275 MA Plymouth   school 2500589 3517   Map Academy Charter School (District) 250058902885 35170505 Map Academy Charter School   Regular School Yes High 09 12 2020   grade_12 20 2 4 0   0     0   1   14 13 *                     27.0 20 2 4 0   0     0   1   14 13                 27
1374274 MA Plymouth   school 2500589 3517   Map Academy Charter School (District) 250058902885 35170505 Map Academy Charter School   Regular School Yes High 09 12 2020   grade_11 38 3 6 0   0     0   3   34 16 *                     50.0 38 3 6 0   0     0   3   34 16                 50
1374273 MA Plymouth   school 2500589 3517   Map Academy Charter School (District) 250058902885 35170505 Map Academy Charter School   Regular School Yes High 09 12 2020   grade_10 17 1 11 0   0     0   1   18 12 *                     30.0 17 1 11 0   0     0   1   18 12                 30
1374272 MA Plymouth   school 2500589 3517   Map Academy Charter School (District) 250058902885 35170505 Map Academy Charter School   Regular School Yes High 09 12 2020   grade_9 33 4 10 0   1     1   5   36 18 *                     54.0 33 4 10 0   1     1   5   36 18                 54
1374271 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 10 2020   grade_10 12 5 8 0   1     0   2   14 14 *                     28.0 12 5 8 0   1     0   2   14 14                 28
1374270 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 10 2020   grade_9 16 6 20 0   1     0   0   21 22 *                     43.0 16 6 20 0   1     0   0   21 22                 43
1374269 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 10 2020   grade_8 35 5 14 0   1     0   2   34 23 *                     57.0 35 5 14 0   1     0   2   34 23                 57
1374268 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 10 2020   grade_7 36 9 21 0   0     0   1   33 34 *                     67.0 36 9 21 0   0     0   1   33 34                 67
1374267 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 10 2020   grade_6 26 15 25 0   1     0   0   33 34 *                     67.0 26 15 25 0   1     0   0   33 34                 67
1374266 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 05 2020   grade_5 37 2 1 0   0     0   0   19 21 *                     40.0 37 2 1 0   0     0   0   19 21                 40
1374265 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 05 2020   grade_4 29 4 6 0   1     0   0   24 16 *                     40.0 29 4 6 0   1     0   0   24 16                 40
1374264 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 05 2020   grade_3 34 1 4 0   1     0   0   18 22 *                     40.0 34 1 4 0   1     0   0   18 22                 40
1374263 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 05 2020   grade_2 32 3 5 0   0     0   0   23 17 *                     40.0 32 3 5 0   0     0   0   23 17                 40
1374262 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 05 2020   grade_1 32 1 5 0   1     0   1   20 20 *                     40.0 32 1 5 0   1     0   1   20 20                 40
1374261 MA Worcester   school 2500587 3515   Old Sturbridge Academy Charter (District) 250058702877 35150205 Old Sturbridge Academy Charter Public School   Regular School Yes Elementary KG 05 2020   kindergarten 34 2 4 0   0     0   0   17 23 *                     40.0 34 2 4 0   0     0   0   17 23                 40
1374260 MA Hampden   school 2500586 3514   Libertas Charter School (District) 250058602878 35140305 Libertas Academy Charter School   Regular School Yes Middle 06 08 2020   grade_8 1 11 74 0   0     0   1   47 40 *                     87.0 1 11 74 0   0     0   1   47 40                 87
1374259 MA Hampden   school 2500586 3514   Libertas Charter School (District) 250058602878 35140305 Libertas Academy Charter School   Regular School Yes Middle 06 08 2020   grade_7 1 15 72 0   1     0   1   44 46 *                     90.0 1 15 72 0   1     0   1   44 46                 90
1374258 MA Hampden   school 2500586 3514   Libertas Charter School (District) 250058602878 35140305 Libertas Academy Charter School   Regular School Yes Middle 06 08 2020   grade_6 1 14 71 0   1     1   2   46 44 *                     90.0 1 14 71 0   1     1   2   46 44                 90
1374257 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_11 0 75 5 0   5     0   0   38 47 *                     85.0 0 75 5 0   5     0   0   38 47                 85
1374256 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_10 2 94 8 0   0     0   0   52 52 *                     104.0 2 94 8 0   0     0   0   52 52                 104
1374255 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_9 1 81 9 0   0     0   1   46 46 *                     92.0 1 81 9 0   0     0   1   46 46                 92
1374254 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_8 2 97 10 1   0     0   0   60 50 *                     110.0 2 97 10 1   0     0   0   60 50                 110
1374253 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_7 4 98 4 0   0     0   1   47 60 *                     107.0 4 98 4 0   0     0   1   47 60                 107
1374252 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Secondary 06 11 2020   grade_6 1 89 9 0   0     0   5   49 55 *                     104.0 1 89 9 0   0     0   5   49 55                 104
1374251 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2020   grade_5 11 9 31 0   3     0   1   24 31 *                     55.0 11 9 31 0   3     0   1   24 31                 55
1374250 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2020   grade_4 22 4 28 0   1     0   0   25 30 *                     55.0 22 4 28 0   1     0   0   25 30                 55
1374249 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2020   grade_3 10 7 35 0   2     0   1   25 30 *                     55.0 10 7 35 0   2     0   1   25 30                 55
1374248 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2020   grade_2 13 8 35 0   0     0   2   32 26 *                     58.0 13 8 35 0   0     0   2   32 26                 58
1374247 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2020   grade_1 7 5 40 0   1     0   4   24 33 *                     57.0 7 5 40 0   1     0   4   24 33                 57
1374246 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2020   kindergarten 10 10 31 0   1     0   0   25 27 *                     52.0 10 10 31 0   1     0   0   25 27                 52
1374245 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 05 2020   grade_5 6 10 35 0   0     0   3   32 22 *                     54.0 6 10 35 0   0     0   3   32 22                 54
1374244 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 05 2020   grade_4 3 11 38 0   2     0   0   29 25 *                     54.0 3 11 38 0   2     0   0   29 25                 54
1374243 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 05 2020   grade_3 7 12 32 0   1     0   2   32 22 *                     54.0 7 12 32 0   1     0   2   32 22                 54
1374242 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 05 2020   grade_2 3 9 41 0   2     0   0   22 33 *                     55.0 3 9 41 0   2     0   0   22 33                 55
1374241 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 05 2020   grade_1 3 7 41 0   1     0   1   32 21 *                     53.0 3 7 41 0   1     0   1   32 21                 53
1374240 MA Hampden   school 2500557 3510   Springfield Preparatory Charter School (District) 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 05 2020   kindergarten 4 9 39 0   1     0   1   26 28 *                     54.0 4 9 39 0   1     0   1   26 28                 54
1374239 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_11 15 7 6 0   1     0   1   15 15 *                     30.0 15 7 6 0   1     0   1   15 15                 30
1374238 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_10 42 10 9 0   0     0   5   34 32 *                     66.0 42 10 9 0   0     0   5   34 32                 66
1374237 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_9 49 14 24 1   2     0   3   54 39 *                     93.0 49 14 24 1   2     0   3   54 39                 93
1374236 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_8 65 12 14 0   2     0   5   56 42 *                     98.0 65 12 14 0   2     0   5   56 42                 98
1374235 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_7 73 11 26 0   3     0   7   62 58 *                     120.0 73 11 26 0   3     0   7   62 58                 120
1374234 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2020   grade_6 57 15 40 0   3     1   2   59 59 *                     118.0 57 15 40 0   3     1   2   59 59                 118
1374233 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 2020   grade_12 0 4 7 0   0     0   0   4 7 *                     11.0 0 4 7 0   0     0   0   4 7                 11
1374232 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 2020   grade_11 6 5 19 0   0     0   1   15 16 *                     31.0 6 5 19 0   0     0   1   15 16                 31
1374231 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 2020   grade_10 1 0 13 0   0     0   0   7 7 *                     14.0 1 0 13 0   0     0   0   7 7                 14
1374230 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 2020   grade_9 6 15 105 2   1     0   3   60 72 *                     132.0 6 15 105 2   1     0   3   60 72                 132
1374229 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 2020   grade_12 10 6 14 0   0     0   0   13 17 *                     30.0 10 6 14 0   0     0   0   13 17                 30
1374228 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 2020   grade_11 14 6 17 1   2     0   1   24 17 *                     41.0 14 6 17 1   2     0   1   24 17                 41
1374227 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 2020   grade_10 9 3 16 0   0     0   2   21 8 *                     30.0 9 3 16 0   0     0   2   21 8                 30
1374226 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 2020   grade_9 12 4 23 0   1     0   8   24 24 *                     48.0 12 4 23 0   1     0   8   24 24                 48
1374225 MA Middlesex   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 2020   grade_12 10 20 6 0   9     0   0   20 25 *                     45.0 10 20 6 0   9     0   0   20 25                 45
1374224 MA Middlesex   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 2020   grade_11 19 22 11 0   3     0   1   26 30 *                     56.0 19 22 11 0   3     0   1   26 30                 56
1374223 MA Middlesex   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 2020   grade_10 15 24 18 0   8     0   1   22 44 *                     66.0 15 24 18 0   8     0   1   22 44                 66
1374222 MA Middlesex   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 2020   grade_9 15 17 17 0   12     0   1   27 35 *                     62.0 15 17 17 0   12     0   1   27 35                 62
1374221 MA Middlesex   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 2020   grade_8 20 20 17 0   6     0   2   40 25 *                     65.0 20 20 17 0   6     0   2   40 25                 65

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