enrollments

Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by ccd_school_high_grade descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,038 ✖
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
1368463 1368463 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1374313 1374313 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
1675704 1675704 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_6 * * * *   *     *   *   * * *                     0.0                                             0
736677 736677 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_6 2 14 11 0   0     0   1   22 6                       28 2 14 11 0   0     0   1   22 6                 28
736880 736880 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2015   grade_6 12 17 18 0   77     1   6   75 56                       131 12 17 18 0   77     1   6   75 56                 131
736922 736922 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2015   grade_6 2 72 39 1   8     0   1   62 61                       123 2 72 39 1   8     0   1   62 61                 123
736957 736957 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_6 * * * *   *     *   *   1 3                       4                         1 3                 4
737449 737449 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2015   grade_6 158 0 0 0   0     1   0   81 78                       159 158 0 0 0   0     1   0   81 78                 159
737632 737632 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2015   grade_6 136 6 1 0   5     0   0   75 73                       148 136 6 1 0   5     0   0   75 73                 148
738547 738547 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_6 80 3 3 0   11     0   2   53 46                       99 80 3 3 0   11     0   2   53 46                 99
738603 738603 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
739014 739014 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_6 1 0 19 0   0     0   0   16 4                       20 1 0 19 0   0     0   0   16 4                 20
739061 739061 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2015   grade_6 44 1 4 0   9     0   1   31 28                       59 44 1 4 0   9     0   1   31 28                 59
740285 740285 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_6 * * * *   *     *   *   1 1                       2                         1 1                 2
741717 741717 MA Worcester   school 2511010 277   Southbridge 251101002755 2770415 Southbridge Middle/High School   Regular School No 4 06 12 2015   grade_6 76 1 92 3   2     0   2   91 85                       176 76 1 92 3   2     0   2   91 85                 176
741948 741948 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2015   grade_6 19 29 49 1   0     1   2   59 42                       101 19 29 49 1   0     1   2   59 42                 101
742648 742648 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No 4 06 12 2015   grade_6 67 3 4 0   0     0   3   36 41                       77 67 3 4 0   0     0   3   36 41                 77
743420 743420 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes 4 06 12 2015   grade_6 4 40 21 0   4     0   0   33 36                       69 4 40 21 0   4     0   0   33 36                 69
743427 743427 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes 4 05 12 2015   grade_6 4 47 22 0   0     0   1   36 38                       74 4 47 22 0   0     0   1   36 38                 74
743440 743440 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_6 51 17 1 0   0     0   3   39 33                       72 51 17 1 0   0     0   3   39 33                 72
743451 743451 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2015   grade_6 2 40 15 0   0     0   1   30 28                       58 2 40 15 0   0     0   1   30 28                 58
743499 743499 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_6 11 22 80 0   5     0   3   52 69                       121 11 22 80 0   5     0   3   52 69                 121
743506 743506 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2015   grade_6 91 2 10 0   32     0   3   65 73                       138 91 2 10 0   32     0   3   65 73                 138
743522 743522 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2015   grade_6 80 3 6 0   8     0   3   52 48                       100 80 3 6 0   8     0   3   52 48                 100
743529 743529 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes 4 06 12 2015   grade_6 2 25 10 0   3     0   0   26 14                       40 2 25 10 0   3     0   0   26 14                 40
743545 743545 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2015   grade_6 1 18 2 0   0     0   0   7 14                       21 1 18 2 0   0     0   0   7 14                 21
743576 743576 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2015   grade_6 49 31 38 0   4     0   6   64 64                       128 49 31 38 0   4     0   6   64 64                 128
743608 743608 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_6 29 49 35 1   7     0   2   56 67                       123 29 49 35 1   7     0   2   56 67                 123
743621 743621 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2015   grade_6 58 28 5 0   14     1   7   58 55                       113 58 28 5 0   14     1   7   58 55                 113
743638 743638 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2015   grade_6 45 29 20 1   4     0   1   49 51                       100 45 29 20 1   4     0   1   49 51                 100
743720 743720 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2015   grade_6 12 1 1 0   2     0   1   11 6                       17 12 1 1 0   2     0   1   11 6                 17
743739 743739 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2015   grade_6 2 43 42 2   0     0   1   50 40                       90 2 43 42 2   0     0   1   50 40                 90
743752 743752 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2015   grade_6 65 14 3 0   23     0   4   56 53                       109 65 14 3 0   23     0   4   56 53                 109
743809 743809 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2015   grade_6 88 0 0 0   1     0   0   40 49                       89 88 0 0 0   1     0   0   40 49                 89
743820 743820 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2015   grade_6 29 4 21 2   5     0   0   27 34                       61 29 4 21 2   5     0   0   27 34                 61
743842 743842 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2015   grade_6 8 57 21 0   10     0   1   57 40                       97 8 57 21 0   10     0   1   57 40                 97
743855 743855 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes 4 KG 12 2015   grade_6 30 10 2 0   3     0   1   17 29                       46 30 10 2 0   3     0   1   17 29                 46
743893 743893 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2015   grade_6 36 11 35 0   2     0   6   44 46                       90 36 11 35 0   2     0   6   44 46                 90
743914 743914 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science   Regular School Yes 4 06 12 2015   grade_6 24 12 19 0   3     0   2   30 30                       60 24 12 19 0   3     0   2   30 30                 60
743984 743984 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_6 90 5 0 0   1     0   0   56 40                       96 90 5 0 0   1     0   0   56 40                 96
744082 744082 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2015   grade_6 74 1 1 0   5     0   5   45 41                       86 74 1 1 0   5     0   5   45 41                 86
745179 745179 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No 4 KG 12 2015   grade_6 48 12 15 1   2     0   3   41 40                       81 48 12 15 1   2     0   3   41 40                 81
745192 745192 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2015   grade_6 23 4 4 0   2     0   1   15 19                       34 23 4 4 0   2     0   1   15 19                 34
933544 933544 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2016   grade_6 2 12 11 0   0     0   3   23 5                       28 2 12 11 0   0     0   3   23 5                 28
933644 933644 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No 4 04 12 2016   grade_6 20 24 11 0   5     0   1   30 31                       61 20 24 11 0   5     0   1   30 31                 61
933744 933744 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2016   grade_6 6 18 24 1   91     0   4   73 71                       144 6 18 24 1   91     0   4   73 71                 144
933785 933785 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2016   grade_6 6 54 32 0   3     0   6   64 37                       101 6 54 32 0   3     0   6   64 37                 101
933816 933816 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   grade_6 1 2 3 0   1     0   0   4 3                       7 1 2 3 0   1     0   0   4 3                 7
934309 934309 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No 4 06 12 2016   grade_6 108 2 4 0   1     0   0   69 46                       115 108 2 4 0   1     0   0   69 46                 115
934491 934491 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2016   grade_6 128 4 3 2   3     0   2   77 65                       142 128 4 3 2   3     0   2   77 65                 142
935397 935397 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_6 76 2 5 0   14     0   1   46 52                       98 76 2 5 0   14     0   1   46 52                 98
935863 935863 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_6 2 1 14 0   0     0   0   14 3                       17 2 1 14 0   0     0   0   14 3                 17
935910 935910 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2016   grade_6 60 0 3 0   0     0   1   17 47                       64 60 0 3 0   0     0   1   17 47                 64
938521 938521 MA Worcester   school 2511010 277   Southbridge 251101002755 2770415 Southbridge Middle/High School   Regular School No 4 06 12 2016   grade_6 64 1 94 1   0     0   4   83 81                       164 64 1 94 1   0     0   4   83 81                 164
938754 938754 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2016   grade_6 29 28 54 0   2     0   0   58 55                       113 29 28 54 0   2     0   0   58 55                 113
939455 939455 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No 4 06 12 2016   grade_6 71 0 7 1   1     0   2   37 45                       82 71 0 7 1   1     0   2   37 45                 82
940240 940240 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes 4 06 12 2016   grade_6 5 40 25 0   1     0   2   42 31                       73 5 40 25 0   1     0   2   42 31                 73
940248 940248 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes 4 05 12 2016   grade_6 14 45 20 0   0     0   0   34 45                       79 14 45 20 0   0     0   0   34 45                 79
940261 940261 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2016   grade_6 58 8 6 1   0     0   1   38 36                       74 58 8 6 1   0     0   1   38 36                 74
940268 940268 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes 4 06 12 2016   grade_6 1 39 15 0   1     0   1   33 24                       57 1 39 15 0   1     0   1   33 24                 57
940319 940319 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2016   grade_6 11 33 72 0   2     0   6   60 64                       124 11 33 72 0   2     0   6   60 64                 124
940326 940326 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2016   grade_6 95 2 9 0   28     0   6   65 75                       140 95 2 9 0   28     0   6   65 75                 140
940343 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
940350 940350 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes 4 06 12 2016   grade_6 4 27 13 0   5     0   1   28 22                       50 4 27 13 0   5     0   1   28 22                 50
940367 940367 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2016   grade_6 0 16 5 0   0     0   1   9 13                       22 0 16 5 0   0     0   1   9 13                 22
940399 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
940431 940431 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2016   grade_6 26 63 28 0   7     0   0   57 67                       124 26 63 28 0   7     0   0   57 67                 124
940444 940444 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2016   grade_6 45 42 6 0   10     0   6   50 59                       109 45 42 6 0   10     0   6   50 59                 109
940461 940461 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2016   grade_6 46 29 22 0   1     0   2   43 57                       100 46 29 22 0   1     0   2   43 57                 100
940549 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
940568 940568 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2016   grade_6 3 36 52 0   1     0   1   45 48                       93 3 36 52 0   1     0   1   45 48                 93
940581 940581 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2016   grade_6 72 16 5 0   14     0   6   54 59                       113 72 16 5 0   14     0   6   54 59                 113
940638 940638 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2016   grade_6 81 1 0 0   3     0   4   50 39                       89 81 1 0 0   3     0   4   50 39                 89
940650 940650 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2016   grade_6 34 10 23 0   5     0   0   27 45                       72 34 10 23 0   5     0   0   27 45                 72
940672 940672 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2016   grade_6 9 64 18 0   5     0   1   41 56                       97 9 64 18 0   5     0   1   41 56                 97
940685 940685 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes 4 KG 12 2016   grade_6 32 10 0 0   1     0   2   27 18                       45 32 10 0 0   1     0   2   27 18                 45
940724 940724 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2016   grade_6 45 12 21 0   2     0   6   46 40                       86 45 12 21 0   2     0   6   46 40                 86
940747 940747 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science   Regular School Yes 4 06 12 2016   grade_6 44 23 15 0   3     0   1   38 48                       86 44 23 15 0   3     0   1   38 48                 86
940817 940817 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2016   grade_6 98 5 1 0   1     0   0   54 51                       105 98 5 1 0   1     0   0   54 51                 105
940916 940916 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No 4 06 12 2016   grade_6 80 1 3 0   2     0   1   52 35                       87 80 1 3 0   2     0   1   52 35                 87
942015 942015 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_6 38 11 8 1   3     0   1   39 23                       62 38 11 8 1   3     0   1   39 23                 62
942028 942028 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_6 27 6 4 0   4     0   11   23 29                       52 27 6 4 0   4     0   11   23 29                 52
1122685 1122685 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No Other 06 12 2017   grade_6 1 29 27 0   0     0   1   35 23                       58 1 29 27 0   0     0   1   35 23                 58
1123137 1123137 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_6 3 7 5 1   0     0   0   15 1                       16 3 7 5 1   0     0   0   15 1                 16
1123250 1123250 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_6 12 17 15 0   7     0   1   31 21                       52 12 17 15 0   7     0   1   31 21                 52
1123367 1123367 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   grade_6 8 20 19 0   82     0   5   71 63                       134 8 20 19 0   82     0   5   71 63                 134
1123413 1123413 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_6 4 69 47 0   8     1   4   84 49                       133 4 69 47 0   8     1   4   84 49                 133
1123447 1123447 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_6 0 3 3 0   0     0   0   2 4                       6 0 3 3 0   0     0   0   2 4                 6
1124026 1124026 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_6 137 1 2 0   1     0   0   62 79                       141 137 1 2 0   1     0   0   62 79                 141
1124244 1124244 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_6 134 3 1 0   4     0   1   68 75                       143 134 3 1 0   4     0   1   68 75                 143
1125354 1125354 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_6 58 3 2 0   9     0   0   41 31                       72 58 3 2 0   9     0   0   41 31                 72
1125424 1125424 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_6 * * * *   *     *   *   4 1                       *                         4 1                  
1125883 1125883 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_6 2 0 13 0   0     0   0   13 2                       15 2 0 13 0   0     0   0   13 2                 15
1125938 1125938 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No Other 06 12 2017   grade_6 58 0 4 0   5     0   1   34 34                       68 58 0 4 0   5     0   1   34 34                 68
1126511 1126511 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other 06 12 2017   grade_6 * * * *   *     *   *   2 1                       *                         2 1                  
1129330 1129330 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No Other 06 12 2017   grade_6 22 24 60 0   1     0   0   55 52                       107 22 24 60 0   1     0   0   55 52                 107
1130176 1130176 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No Other 06 12 2017   grade_6 70 2 6 0   1     0   3   35 47                       82 70 2 6 0   1     0   3   35 47                 82
1131117 1131117 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes Other 06 12 2017   grade_6 5 36 26 0   0     0   1   32 36                       68 5 36 26 0   0     0   1   32 36                 68
1131126 1131126 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_6 5 40 26 0   0     0   6   39 38                       77 5 40 26 0   0     0   6   39 38                 77
1131141 1131141 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_6 45 11 6 0   4     0   5   30 41                       71 45 11 6 0   4     0   5   30 41                 71

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