enrollments

Data source: Big Local News · About: Big Local

90,193 rows where state = "NY" and year = 2016 sorted by multiracial

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 90,193 ✖
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
1032114 1032114 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   grade_1 1.0 72.0 6.0   0.0     0.0         43.0 36.0             71     *   79 1 72 6   0     0         43 36         71       79
1032115 1032115 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   grade_10 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032116 1032116 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   grade_11 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032117 1032117 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   grade_12 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032118 1032118 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   grade_2 3.0 68.0 11.0   0.0     1.0         40.0 43.0             74     5   83 3 68 11   0     1         40 43         74   5   83
1032119 1032119 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   grade_3 1.0 65.0 5.0   1.0     0.0         37.0 35.0             65     *   72 1 65 5   1     0         37 35         65       72
1032120 1032120 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   grade_4 2.0 67.0 7.0   1.0     0.0         35.0 42.0             72     *   77 2 67 7   1     0         35 42         72       77
1032121 1032121 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   grade_5 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032122 1032122 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   grade_6 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032123 1032123 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   grade_7 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032124 1032124 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   grade_8 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032125 1032125 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032126 1032126 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   kindergarten_full_day 0.0 72.0 10.0   1.0     1.0         45.0 39.0             77     *   84 0 72 10   1     1         45 39         77       84
1032127 1032127 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032128 1032128 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   pk_12_total 7.0 344.0 39.0   3.0     2.0         200.0 195.0             359     13   395 7 344 39   3     2         200 195         359   13   395
1032129 1032129 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   pre_kindergarten_full_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032130 1032130 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032131 1032131 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   ungraded_elementary 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032132 1032132 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2016   ungraded_secondary 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032133 1032133 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   grade_1 3.0 69.0 2.0         2.0         37.0 39.0             55     *   76 3 69 2         2         37 39         55       76
1032134 1032134 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   grade_10 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1032135 1032135 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   grade_11 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1032136 1032136 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   grade_12 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1032137 1032137 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   grade_2 0.0 72.0 3.0         1.0         39.0 37.0             53     *   76 0 72 3         1         39 37         53       76
1032138 1032138 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   grade_3 0.0 70.0 6.0         0.0         37.0 39.0             56     *   76 0 70 6         0         37 39         56       76
1032139 1032139 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   grade_4 1.0 68.0 5.0         1.0         35.0 40.0             56     *   75 1 68 5         1         35 40         56       75
1032140 1032140 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   grade_5 0.0 73.0 1.0         0.0         27.0 47.0             56     *   74 0 73 1         0         27 47         56       74
1032141 1032141 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   grade_6 2.0 67.0 1.0         1.0         37.0 34.0             51     *   71 2 67 1         1         37 34         51       71
1032142 1032142 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   grade_7 1.0 64.0 6.0         0.0         39.0 32.0             53     *   71 1 64 6         0         39 32         53       71
1032143 1032143 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   grade_8 2.0 61.0 7.0         1.0         30.0 41.0             45     *   71 2 61 7         1         30 41         45       71
1032144 1032144 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   grade_9 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1032145 1032145 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   kindergarten_full_day 2.0 70.0 2.0         0.0         29.0 45.0             54     *   74 2 70 2         0         29 45         54       74
1032146 1032146 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   kindergarten_half_day 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1032147 1032147 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   pk_12_total 11.0 614.0 33.0         6.0         310.0 354.0             479     20   664 11 614 33         6         310 354         479   20   664
1032148 1032148 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   pre_kindergarten_full_day 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1032149 1032149 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   pre_kindergarten_half_day 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1032150 1032150 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   ungraded_elementary 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1032151 1032151 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   ungraded_secondary 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1032171 1032171 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   grade_1 0.0 0.0 0.0   0.0     0.0           0.0             0     0   0 0 0 0   0     0           0         0   0   0
1032172 1032172 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   grade_10 1.0 74.0 3.0   0.0     2.0           80.0             77     *   80 1 74 3   0     2           80         77       80
1032173 1032173 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   grade_11 3.0 57.0 8.0   0.0     7.0           75.0             71     *   75 3 57 8   0     7           75         71       75
1032174 1032174 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   grade_12 2.0 57.0 5.0   0.0     3.0           67.0             60     *   67 2 57 5   0     3           67         60       67
1032175 1032175 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0           0.0             0     0   0 0 0 0   0     0           0         0   0   0
1032176 1032176 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   grade_3 0.0 0.0 0.0   0.0     0.0           0.0             0     0   0 0 0 0   0     0           0         0   0   0
1032177 1032177 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   grade_4 0.0 0.0 0.0   0.0     0.0           0.0             0     0   0 0 0 0   0     0           0         0   0   0
1032178 1032178 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   grade_5 0.0 0.0 0.0   0.0     0.0           0.0             0     0   0 0 0 0   0     0           0         0   0   0
1032179 1032179 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   grade_6 0.0 0.0 0.0   0.0     0.0           0.0             0     0   0 0 0 0   0     0           0         0   0   0
1032180 1032180 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   grade_7 0.0 0.0 0.0   0.0     0.0           0.0             0     0   0 0 0 0   0     0           0         0   0   0
1032181 1032181 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   grade_8 0.0 0.0 0.0   0.0     0.0           0.0             0     0   0 0 0 0   0     0           0         0   0   0
1032182 1032182 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   grade_9 3.0 121.0 12.0   1.0     6.0           143.0             129     12   143 3 121 12   1     6           143         129   12   143
1032183 1032183 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0           0.0             0     0   0 0 0 0   0     0           0         0   0   0
1032184 1032184 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0           0.0             0     0   0 0 0 0   0     0           0         0   0   0
1032185 1032185 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   pk_12_total 9.0 309.0 28.0   1.0     18.0           365.0             337     20   365 9 309 28   1     18           365         337   20   365
1032186 1032186 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   pre_kindergarten_full_day 0.0 0.0 0.0   0.0     0.0           0.0             0     0   0 0 0 0   0     0           0         0   0   0
1032187 1032187 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0           0.0             0     0   0 0 0 0   0     0           0         0   0   0
1032188 1032188 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   ungraded_elementary 0.0 0.0 0.0   0.0     0.0           0.0             0     0   0 0 0 0   0     0           0         0   0   0
1032189 1032189 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   ungraded_secondary 0.0 0.0 0.0   0.0     0.0           0.0             0     0   0 0 0 0   0     0           0         0   0   0
1032190 1032190 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   grade_1 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032191 1032191 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   grade_10 78.0 0.0 0.0   0.0     0.0         42.0 36.0             31     *   78 78 0 0   0     0         42 36         31       78
1032192 1032192 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   grade_11 57.0 1.0 2.0   0.0     0.0         34.0 26.0             *     10   60 57 1 2   0     0         34 26             10   60
1032193 1032193 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   grade_12 61.0 1.0 1.0   0.0     1.0         29.0 35.0             24     7   64 61 1 1   0     1         29 35         24   7   64
1032194 1032194 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032195 1032195 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   grade_3 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032196 1032196 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   grade_4 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032197 1032197 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   grade_5 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032198 1032198 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   grade_6 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032199 1032199 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   grade_7 56.0 1.0 0.0   0.0     0.0         25.0 32.0             31     9   57 56 1 0   0     0         25 32         31   9   57
1032200 1032200 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   grade_8 59.0 2.0 1.0   1.0     0.0         30.0 33.0             24     11   63 59 2 1   1     0         30 33         24   11   63
1032201 1032201 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   grade_9 58.0 0.0 0.0   0.0     1.0         33.0 26.0             20     12   59 58 0 0   0     1         33 26         20   12   59
1032202 1032202 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032203 1032203 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032204 1032204 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   pk_12_total 371.0 5.0 4.0   1.0     2.0         194.0 189.0             149     55   383 371 5 4   1     2         194 189         149   55   383
1032205 1032205 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   pre_kindergarten_full_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032206 1032206 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032207 1032207 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   ungraded_elementary 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1032208 1032208 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   ungraded_secondary 2.0 0.0 0.0   0.0     0.0         1.0 1.0             *     *   2 2 0 0   0     0         1 1                 2
1033140 1033140 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   grade_1 31.0 0.0 1.0         0.0         13.0 19.0             19     *   32 31 0 1         0         13 19         19       32
1033141 1033141 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   grade_10 28.0 1.0 0.0         0.0         12.0 17.0             21     6   29 28 1 0         0         12 17         21   6   29
1033142 1033142 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   grade_11 24.0 0.0 0.0         0.0         15.0 9.0             10     *   24 24 0 0         0         15 9         10       24
1033143 1033143 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   grade_12 22.0 1.0 2.0         0.0         14.0 11.0             11     *   25 22 1 2         0         14 11         11       25
1033144 1033144 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   grade_2 21.0 0.0 0.0         0.0         8.0 13.0             13     *   21 21 0 0         0         8 13         13       21
1033145 1033145 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   grade_3 16.0 1.0 0.0         0.0         9.0 8.0             10     *   17 16 1 0         0         9 8         10       17
1033146 1033146 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   grade_4 23.0 1.0 0.0         1.0         10.0 15.0             16     *   25 23 1 0         1         10 15         16       25
1033147 1033147 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   grade_5 23.0 0.0 0.0         0.0         12.0 11.0             11     *   23 23 0 0         0         12 11         11       23
1033148 1033148 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   grade_6 18.0 0.0 0.0         0.0         11.0 7.0             9     *   18 18 0 0         0         11 7         9       18
1033149 1033149 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   grade_7 22.0 0.0 0.0         0.0         10.0 12.0             9     *   22 22 0 0         0         10 12         9       22
1033150 1033150 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   grade_8 28.0 0.0 0.0         0.0         12.0 16.0             17     *   28 28 0 0         0         12 16         17       28
1033151 1033151 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   grade_9 21.0 0.0 0.0         0.0         9.0 12.0             *     *   21 21 0 0         0         9 12                 21
1033152 1033152 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   kindergarten_full_day 20.0 0.0 0.0         0.0         6.0 14.0             13     *   20 20 0 0         0         6 14         13       20
1033153 1033153 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   kindergarten_half_day 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1033154 1033154 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   pk_12_total 312.0 4.0 4.0         1.0         150.0 171.0             171     39   321 312 4 4         1         150 171         171   39   321
1033155 1033155 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   pre_kindergarten_full_day 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1033156 1033156 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   pre_kindergarten_half_day 14.0 0.0 1.0         0.0         8.0 7.0             *     *   15 14 0 1         0         8 7                 15
1033157 1033157 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   ungraded_elementary 1.0 0.0 0.0         0.0         1.0 0.0             *     *   1 1 0 0         0         1 0                 1
1033158 1033158 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   ungraded_secondary 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1033197 1033197 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_1 22.0   0.0         0.0         12.0 10.0             14     *   22 22   0         0         12 10         14       22
1033198 1033198 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_10 20.0   0.0         0.0         7.0 13.0             11     *   20 20   0         0         7 13         11       20
1033199 1033199 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_11 12.0   0.0         0.0         1.0 11.0             *     0   12 12   0         0         1 11             0   12
1033200 1033200 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_12 16.0   0.0         0.0         11.0 5.0             9     *   16 16   0         0         11 5         9       16
1033201 1033201 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2016   grade_2 17.0   2.0         0.0         11.0 8.0             11     *   19 17   2         0         11 8         11       19

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