enrollments

Data source: Big Local News · About: Big Local

9,565 rows where state = "MA" and year = 2019 sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

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
2048887 2048887 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2019   grade_9 165 1 12 0   1     1   6   88 98                       186.0 165 1 12 0   1     1   6   88 98                 186
2048888 2048888 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2019   grade_10 141 0 3 0   1     0   4   72 77                       149.0 141 0 3 0   1     0   4   72 77                 149
2048889 2048889 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2019   grade_11 133 1 5 0   3     0   4   71 75                       146.0 133 1 5 0   3     0   4   71 75                 146
2048890 2048890 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2019   grade_12 130 2 6 0   0     0   6   71 73                       144.0 130 2 6 0   0     0   6   71 73                 144
2048891 2048891 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin Regional High School   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2048885 2048885 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2019   grade_7 170 1 7 0   3     0   2   87 96                       183.0 170 1 7 0   3     0   2   87 96                 183
2048886 2048886 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2019   grade_8 164 0 6 0   1     0   5   76 100                       176.0 164 0 6 0   1     0   5   76 100                 176
2048856 2048856 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2019   kindergarten 22 0 1 0   0     0   0   14 9                       23.0 22 0 1 0   0     0   0   14 9                 23
2048857 2048857 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2019   grade_1 20 0 1 1   0     0   0   15 7                       22.0 20 0 1 1   0     0   0   15 7                 22
2048858 2048858 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2019   grade_2 14 0 3 0   0     0   0   11 6                       17.0 14 0 3 0   0     0   0   11 6                 17
2048859 2048859 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2019   grade_3 22 0 4 0   0     0   0   16 10                       26.0 22 0 4 0   0     0   0   16 10                 26
2048860 2048860 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2019   grade_4 21 0 2 1   0     0   0   11 13                       24.0 21 0 2 1   0     0   0   11 13                 24
2048861 2048861 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2019   grade_5 29 0 4 0   0     0   0   22 11                       33.0 29 0 4 0   0     0   0   22 11                 33
2048862 2048862 MA Worcester   school 2500001 753   Quabbin 250000102398 7530005 Hardwick Elementary   Regular School No Elementary KG 06 2019   grade_6 25 1 3 0   0     0   0   17 12                       29.0 25 1 3 0   0     0   0   17 12                 29
2048863 2048863 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2019   kindergarten 29 0 3 0   1     0   2   17 18                       35.0 29 0 3 0   1     0   2   17 18                 35
2048864 2048864 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2019   grade_1 46 0 2 0   1     0   0   26 23                       49.0 46 0 2 0   1     0   0   26 23                 49
2048865 2048865 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2019   grade_2 42 1 1 0   1     0   0   23 22                       45.0 42 1 1 0   1     0   0   23 22                 45
2048866 2048866 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2019   grade_3 41 0 1 0   0     0   0   22 20                       42.0 41 0 1 0   0     0   0   22 20                 42
2048867 2048867 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2019   grade_4 42 1 2 0   0     0   0   21 24                       45.0 42 1 2 0   0     0   0   21 24                 45
2048868 2048868 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2019   grade_5 44 0 3 0   0     0   0   18 29                       47.0 44 0 3 0   0     0   0   18 29                 47
2048869 2048869 MA Worcester   school 2500001 753   Quabbin 250000102399 7530010 Hubbardston Center   Regular School No Elementary KG 06 2019   grade_6 43 1 0 0   1     0   1   22 24                       46.0 43 1 0 0   1     0   1   22 24                 46
2048870 2048870 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary KG 01 2019   kindergarten 20 0 2 0   0     0   1   10 13                       23.0 20 0 2 0   0     0   1   10 13                 23
2048871 2048871 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary KG 01 2019   grade_1 33 0 4 0   0     0   1   22 16                       38.0 33 0 4 0   0     0   1   22 16                 38
2048872 2048872 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2019   grade_2 18 1 1 0   0     0   0   8 12                       20.0 18 1 1 0   0     0   0   8 12                 20
2048873 2048873 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2019   grade_3 20 0 2 0   0     0   1   5 18                       23.0 20 0 2 0   0     0   1   5 18                 23
2048874 2048874 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2019   grade_4 29 0 1 0   0     0   0   9 21                       30.0 29 0 1 0   0     0   0   9 21                 30
2048875 2048875 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2019   grade_5 22 0 2 0   0     0   0   13 11                       24.0 22 0 2 0   0     0   0   13 11                 24
2048876 2048876 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Oakham Center   Regular School No Elementary 02 06 2019   grade_6 28 2 0 0   0     0   0   11 19                       30.0 28 2 0 0   0     0   0   11 19                 30
2048877 2048877 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2019   pre_kindergarten 66 0 1 0   0     0   0   40 27                       67.0 66 0 1 0   0     0   0   40 27                 67
2048878 2048878 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2019   kindergarten 46 1 1 0   1     1   1   28 23                       51.0 46 1 1 0   1     1   1   28 23                 51
2048879 2048879 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2019   grade_1 46 2 4 0   0     0   0   27 25                       52.0 46 2 4 0   0     0   0   27 25                 52
2048880 2048880 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2019   grade_2 46 0 1 0   0     0   1   24 24                       48.0 46 0 1 0   0     0   1   24 24                 48
2048881 2048881 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2019   grade_3 47 0 3 0   1     0   2   26 27                       53.0 47 0 3 0   1     0   2   26 27                 53
2048882 2048882 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2019   grade_4 68 1 2 0   1     0   3   38 37                       75.0 68 1 2 0   1     0   3   38 37                 75
2048883 2048883 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2019   grade_5 56 0 5 0   1     1   0   37 26                       63.0 56 0 5 0   1     1   0   37 26                 63
2048884 2048884 MA Worcester   school 2500001 753   Quabbin 250000102403 7530030 Ruggles Lane   Regular School No Elementary PK 06 2019   grade_6 48 0 4 0   0     0   1   27 26                       53.0 48 0 4 0   0     0   1   27 26                 53
2048965 2048965 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2019   grade_5 85 2 14 0   2     0   4   59 48                       107.0 85 2 14 0   2     0   4   59 48                 107
2048966 2048966 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2019   grade_6 84 2 10 1   2     0   4   52 51                       103.0 84 2 10 1   2     0   4   52 51                 103
2048967 2048967 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2019   grade_7 91 2 19 0   2     0   5   73 46                       119.0 91 2 19 0   2     0   5   73 46                 119
2048968 2048968 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2019   grade_8 87 2 17 0   2     0   1   61 48                       109.0 87 2 17 0   2     0   1   61 48                 109
2048952 2048952 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 65 3 14 0   0     0   3   46 39                       85.0 65 3 14 0   0     0   3   46 39                 85
2048953 2048953 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2019   kindergarten 17 0 2 0   0     0   0   11 8                       19.0 17 0 2 0   0     0   0   11 8                 19
2048954 2048954 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_1 24 0 3 0   0     0   0   15 12                       27.0 24 0 3 0   0     0   0   15 12                 27
2048955 2048955 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_2 18 0 2 0   0     0   0   10 10                       20.0 18 0 2 0   0     0   0   10 10                 20
2048956 2048956 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_3 19 1 2 0   0     0   1   14 9                       23.0 19 1 2 0   0     0   1   14 9                 23
2048957 2048957 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_4 15 0 1 1   0     0   2   9 10                       19.0 15 0 1 1   0     0   2   9 10                 19
2048958 2048958 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_5 26 2 1 0   0     0   1   17 13                       30.0 26 2 1 0   0     0   1   17 13                 30
2048959 2048959 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201766 7670008 East Brookfield Elementary   Regular School No Elementary PK 06 2019   grade_6 18 0 1 0   0     0   1   9 11                       20.0 18 0 1 0   0     0   1   9 11                 20
2048969 2048969 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2019   grade_9 50 1 10 0   1     0   3   37 28                       65.0 50 1 10 0   1     0   3   37 28                 65
2048970 2048970 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2019   grade_10 48 2 6 1   1     0   0   28 30                       58.0 48 2 6 1   1     0   0   28 30                 58
2048971 2048971 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2019   grade_11 52 1 7 1   3     0   1   40 25                       65.0 52 1 7 1   3     0   1   40 25                 65
2048972 2048972 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2019   grade_12 74 1 7 0   0     0   3   46 39                       85.0 74 1 7 0   0     0   3   46 39                 85
2048973 2048973 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             1.0                                             1
2048960 2048960 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2019   kindergarten 60 0 9 0   0     0   0   35 34                       69.0 60 0 9 0   0     0   0   35 34                 69
2048961 2048961 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2019   grade_1 68 4 18 0   0     0   5   54 40                       95.0 68 4 18 0   0     0   5   54 40                 95
2048962 2048962 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2019   grade_2 83 4 17 0   0     0   0   58 46                       104.0 83 4 17 0   0     0   0   58 46                 104
2048963 2048963 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2019   grade_3 55 0 12 0   0     0   2   31 38                       69.0 55 0 12 0   0     0   2   31 38                 69
2048964 2048964 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201859 7670040 Wire Village School   Regular School No Elementary KG 04 2019   grade_4 73 1 11 0   1     0   1   45 42                       87.0 73 1 11 0   1     0   1   45 42                 87
2048945 2048945 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   grade_7 101 0 7 0   1     0   4   57 56                       113.0 101 0 7 0   1     0   4   57 56                 113
2048946 2048946 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   grade_8 109 3 4 0   2     0   2   63 57                       120.0 109 3 4 0   2     0   2   63 57                 120
2048947 2048947 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   grade_9 114 4 2 1   0     0   1   57 65                       122.0 114 4 2 1   0     0   1   57 65                 122
2048948 2048948 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   grade_10 102 2 7 1   1     0   2   60 55                       115.0 102 2 7 1   1     0   2   60 55                 115
2048949 2048949 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   grade_11 114 1 1 0   1     0   0   62 55                       117.0 114 1 1 0   1     0   0   62 55                 117
2048950 2048950 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   grade_12 109 3 6 0   1     0   3   59 63                       122.0 109 3 6 0   1     0   3   59 63                 122
2048951 2048951 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2048937 2048937 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2019   pre_kindergarten 40 0 3 0   0     0   1   26 18                       44.0 40 0 3 0   0     0   1   26 18                 44
2048938 2048938 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2019   kindergarten 91 2 7 1   0     0   3   52 52                       104.0 91 2 7 1   0     0   3   52 52                 104
2048939 2048939 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2019   grade_1 77 1 6 1   3     0   1   53 36                       89.0 77 1 6 1   3     0   1   53 36                 89
2048940 2048940 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2019   grade_2 92 2 6 0   1     0   3   55 49                       104.0 92 2 6 0   1     0   3   55 49                 104
2048941 2048941 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2019   grade_3 105 2 2 0   0     0   0   56 53                       109.0 105 2 2 0   0     0   0   56 53                 109
2048942 2048942 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2019   grade_4 105 1 6 1   1     0   5   63 56                       119.0 105 1 6 1   1     0   5   63 56                 119
2048943 2048943 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2019   grade_5 99 5 6 0   1     0   4   54 61                       115.0 99 5 6 0   1     0   4   54 61                 115
2048944 2048944 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Powder Mill School   Regular School No Elementary 03 06 2019   grade_6 108 1 3 0   1     0   2   54 61                       115.0 108 1 3 0   1     0   2   54 61                 115
2048259 2048259 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 15 0 0 0   0     0   0   6 9                       15.0 15 0 0 0   0     0   0   6 9                 15
2048260 2048260 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2019   kindergarten 13 0 0 0   0     0   0   8 5                       13.0 13 0 0 0   0     0   0   8 5                 13
2048261 2048261 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2019   grade_1 18 1 0 0   0     0   0   12 7                       19.0 18 1 0 0   0     0   0   12 7                 19
2048262 2048262 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2019   grade_2 18 0 0 1   0     0   0   9 10                       19.0 18 0 0 1   0     0   0   9 10                 19
2048263 2048263 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2019   grade_3 14 0 0 0   0     0   0   8 6                       14.0 14 0 0 0   0     0   0   8 6                 14
2048264 2048264 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2019   grade_4 15 0 1 1   0     0   0   8 9                       17.0 15 0 1 1   0     0   0   8 9                 17
2048265 2048265 MA Hampshire   school 2500014 632   Chesterfield-Goshen 250001401275 6320025 New Hingham Regional Elementary   Regular School No Elementary PK 06 2019   grade_6 19 1 0 0   0     0   0   13 7                       20.0 19 1 0 0   0     0   0   13 7                 20
2047541 2047541 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 High 05 12 2019   grade_5 8 49 14 0   0     0   1   46 26                       72.0 8 49 14 0   0     0   1   46 26                 72
2047542 2047542 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 High 05 12 2019   grade_6 10 43 24 0   1     0   2   39 41                       80.0 10 43 24 0   1     0   2   39 41                 80
2047543 2047543 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 High 05 12 2019   grade_7 5 43 25 0   1     0   1   34 41                       75.0 5 43 25 0   1     0   1   34 41                 75
2047544 2047544 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 High 05 12 2019   grade_8 3 43 23 0   0     0   4   34 39                       73.0 3 43 23 0   0     0   4   34 39                 73
2047545 2047545 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 High 05 12 2019   grade_9 10 43 17 0   1     0   0   37 34                       71.0 10 43 17 0   1     0   0   37 34                 71
2047546 2047546 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 High 05 12 2019   grade_10 3 47 19 0   1     0   0   36 34                       70.0 3 47 19 0   1     0   0   36 34                 70
2047547 2047547 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 High 05 12 2019   grade_11 6 29 10 0   1     0   1   22 25                       47.0 6 29 10 0   1     0   1   22 25                 47
2047548 2047548 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 High 05 12 2019   grade_12 2 21 10 0   1     1   3   19 19                       38.0 2 21 10 0   1     1   3   19 19                 38
2047584 2047584 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   pre_kindergarten 0 21 3 0   0     0   0   11 13                       24.0 0 21 3 0   0     0   0   11 13                 24
2047585 2047585 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   kindergarten 3 33 6 0   0     1   2   17 28                       45.0 3 33 6 0   0     1   2   17 28                 45
2047586 2047586 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_1 1 42 5 0   0     0   2   23 27                       50.0 1 42 5 0   0     0   2   23 27                 50
2047587 2047587 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_2 1 40 6 0   0     0   3   24 26                       50.0 1 40 6 0   0     0   3   24 26                 50
2047588 2047588 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_3 2 39 3 1   2     1   0   27 21                       48.0 2 39 3 1   2     1   0   27 21                 48
2047589 2047589 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_4 0 40 8 0   0     0   0   23 25                       48.0 0 40 8 0   0     0   0   23 25                 48
2047590 2047590 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_5 0 38 3 0   0     0   0   22 19                       41.0 0 38 3 0   0     0   0   22 19                 41
2047591 2047591 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2019   grade_6 0 42 5 0   1     0   0   27 21                       48.0 0 42 5 0   1     0   0   27 21                 48
2047649 2047649 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2019   grade_6 71 1 4 1   2     0   2   34 47                       81.0 71 1 4 1   2     0   2   34 47                 81
2047650 2047650 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2019   grade_7 65 3 5 0   1     0   6   40 40                       80.0 65 3 5 0   1     0   6   40 40                 80
2047651 2047651 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2019   grade_8 71 2 2 0   2     0   4   36 45                       81.0 71 2 2 0   2     0   4   36 45                 81
2047652 2047652 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2019   grade_5 75 3 9 1   8     0   4   47 53                       100.0 75 3 9 1   8     0   4   47 53                 100

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