enrollments

Data source: Big Local News · About: Big Local

89,718 rows where state = "NY" and year = 2017 sorted by multiracial

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 89,718 ✖
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
942396 942396 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_1 0.0 72.0 9.0   1.0     0.0         44.0 38.0     *       76         82 0 72 9   1     0         44 38         76       82
942397 942397 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   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
942398 942398 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   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
942399 942399 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   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
942400 942400 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_2 1.0 76.0 6.0   0.0     0.0         45.0 38.0     *       73         83 1 76 6   0     0         45 38         73       83
942401 942401 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_3 0.0 75.0 9.0   1.0     1.0         37.0 49.0     0       78         86 0 75 9   1     1         37 49     0   78       86
942402 942402 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   grade_4 1.0 62.0 6.0   0.0     0.0         31.0 38.0     *       57         69 1 62 6   0     0         31 38         57       69
942403 942403 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   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
942404 942404 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   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
942405 942405 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   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
942406 942406 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   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
942407 942407 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   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
942408 942408 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   kindergarten_full_day 0.0 47.0 13.0   0.0     0.0         35.0 25.0     *       51         60 0 47 13   0     0         35 25         51       60
942409 942409 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   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
942410 942410 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   pk_12_total 2.0 332.0 43.0   2.0     1.0         192.0 188.0     7       335         380 2 332 43   2     1         192 188     7   335       380
942411 942411 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   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
942412 942412 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   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
942413 942413 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   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
942414 942414 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   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
942415 942415 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_1 2.0 75.0 1.0         0.0         36.0 42.0     0       70     *   78 2 75 1         0         36 42     0   70       78
942416 942416 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   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
942417 942417 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   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
942418 942418 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   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
942419 942419 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_2 3.0 71.0 2.0         2.0         36.0 42.0     *       65     0   78 3 71 2         2         36 42         65   0   78
942420 942420 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_3 0.0 74.0 1.0         1.0         43.0 33.0     *       68     5   76 0 74 1         1         43 33         68   5   76
942421 942421 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_4 0.0 68.0 3.0         0.0         38.0 33.0     0       57     *   71 0 68 3         0         38 33     0   57       71
942422 942422 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_5 1.0 73.0 3.0         1.0         38.0 40.0     *       71     *   78 1 73 3         1         38 40         71       78
942423 942423 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_6 0.0 77.0 4.0         1.0         43.0 39.0     *       74     *   82 0 77 4         1         43 39         74       82
942424 942424 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_7 1.0 58.0 3.0         1.0         34.0 29.0     *       53     0   63 1 58 3         1         34 29         53   0   63
942425 942425 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_8 1.0 70.0 7.0         1.0         37.0 42.0     0       69     *   79 1 70 7         1         37 42     0   69       79
942426 942426 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   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
942427 942427 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   kindergarten_full_day 1.0 73.0 3.0         0.0         33.0 44.0     *       68     0   77 1 73 3         0         33 44         68   0   77
942428 942428 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   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
942429 942429 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   pk_12_total 9.0 639.0 27.0         7.0         338.0 344.0     8       595     16   682 9 639 27         7         338 344     8   595   16   682
942430 942430 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   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
942431 942431 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   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
942432 942432 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   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
942433 942433 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   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
942472 942472 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   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
942473 942473 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   grade_10 57.0 0.0 0.0   0.0     1.0         32.0 26.0             19     11   58 57 0 0   0     1         32 26         19   11   58
942474 942474 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   grade_11 74.0 0.0 1.0   0.0     0.0         42.0 33.0             27     *   75 74 0 1   0     0         42 33         27       75
942475 942475 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   grade_12 59.0 1.0 1.0   0.0     0.0         36.0 25.0             *     8   61 59 1 1   0     0         36 25             8   61
942476 942476 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   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
942477 942477 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   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
942478 942478 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   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
942479 942479 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   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
942480 942480 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   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
942481 942481 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   grade_7 56.0 0.0 0.0   0.0     0.0         32.0 24.0             19     8   56 56 0 0   0     0         32 24         19   8   56
942482 942482 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   grade_8 49.0 0.0 2.0   0.0     1.0         20.0 32.0             27     10   52 49 0 2   0     1         20 32         27   10   52
942483 942483 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   grade_9 61.0 2.0 1.0   1.0     1.0         32.0 34.0             25     10   66 61 2 1   1     1         32 34         25   10   66
942484 942484 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   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
942485 942485 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   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
942486 942486 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   pk_12_total 359.0 3.0 5.0   1.0     3.0         195.0 176.0             138     57   371 359 3 5   1     3         195 176         138   57   371
942487 942487 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   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
942488 942488 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   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
942489 942489 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   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
942490 942490 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   ungraded_secondary 3.0 0.0 0.0   0.0     0.0         1.0 2.0             *     *   3 3 0 0   0     0         1 2                 3
943422 943422 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_1 20.0 0.0           0.0         6.0 14.0             13     *   20 20 0           0         6 14         13       20
943423 943423 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_10 19.0 0.0           0.0         8.0 11.0             8     0   19 19 0           0         8 11         8   0   19
943424 943424 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_11 21.0 1.0           0.0         10.0 12.0             14     *   22 21 1           0         10 12         14       22
943425 943425 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_12 27.0 0.0           0.0         16.0 11.0             9     *   27 27 0           0         16 11         9       27
943426 943426 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_2 29.0 0.0           0.0         12.0 17.0             17     *   29 29 0           0         12 17         17       29
943427 943427 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_3 23.0 0.0           0.0         9.0 14.0             15     *   23 23 0           0         9 14         15       23
943428 943428 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_4 16.0 1.0           0.0         9.0 8.0             11     *   17 16 1           0         9 8         11       17
943429 943429 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_5 24.0 1.0           1.0         11.0 15.0             17     *   26 24 1           1         11 15         17       26
943430 943430 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_6 24.0 0.0           0.0         12.0 12.0             12     *   24 24 0           0         12 12         12       24
943431 943431 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_7 21.0 0.0           0.0         13.0 8.0             11     5   21 21 0           0         13 8         11   5   21
943432 943432 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_8 19.0 0.0           0.0         7.0 12.0             9     0   19 19 0           0         7 12         9   0   19
943433 943433 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_9 25.0 0.0           0.0         8.0 17.0             12     *   25 25 0           0         8 17         12       25
943434 943434 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   kindergarten_full_day 21.0 0.0           0.0         12.0 9.0             13     *   21 21 0           0         12 9         13       21
943435 943435 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   kindergarten_half_day 0.0 0.0           0.0         0.0 0.0             0     0   0 0 0           0         0 0         0   0   0
943436 943436 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   pk_12_total 312.0 3.0           1.0         145.0 171.0             171     35   316 312 3           1         145 171         171   35   316
943437 943437 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   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
943438 943438 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   pre_kindergarten_half_day 21.0 0.0           0.0         11.0 10.0             *     *   21 21 0           0         11 10                 21
943439 943439 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   ungraded_elementary 2.0 0.0           0.0         1.0 1.0             *     *   2 2 0           0         1 1                 2
943440 943440 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   ungraded_secondary 0.0 0.0           0.0         0.0 0.0             0     0   0 0 0           0         0 0         0   0   0
943479 943479 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_1 18.0 0.0 2.0         0.0         9.0 11.0             14     5   20 18 0 2         0         9 11         14   5   20
943480 943480 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_10 12.0 0.0 0.0         1.0         7.0 6.0             6     *   13 12 0 0         1         7 6         6       13
943481 943481 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_11 18.0 0.0 0.0         0.0         6.0 12.0             9     *   18 18 0 0         0         6 12         9       18
943482 943482 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_12 10.0 0.0 0.0         0.0         1.0 9.0             *     0   10 10 0 0         0         1 9             0   10
943483 943483 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_2 18.0 0.0 0.0         0.0         9.0 9.0             11     *   18 18 0 0         0         9 9         11       18
943484 943484 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_3 17.0 0.0 1.0         0.0         9.0 9.0             8     *   18 17 0 1         0         9 9         8       18
943485 943485 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_4 16.0 0.0 0.0         0.0         6.0 10.0             9     *   16 16 0 0         0         6 10         9       16
943486 943486 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_5 20.0 0.0 1.0         0.0         3.0 18.0             10     *   21 20 0 1         0         3 18         10       21
943487 943487 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_6 14.0 0.0 0.0         0.0         10.0 4.0             8     0   14 14 0 0         0         10 4         8   0   14
943488 943488 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_7 21.0 0.0 0.0         0.0         10.0 11.0             12     *   21 21 0 0         0         10 11         12       21
943489 943489 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_8 22.0 1.0 1.0         0.0         8.0 16.0             12     *   24 22 1 1         0         8 16         12       24
943490 943490 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_9 21.0 0.0 0.0         0.0         9.0 12.0             14     *   21 21 0 0         0         9 12         14       21
943491 943491 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   kindergarten_full_day 14.0 0.0 0.0         0.0         10.0 4.0             10     0   14 14 0 0         0         10 4         10   0   14
943492 943492 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   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
943493 943493 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   pk_12_total 242.0 1.0 7.0         1.0         108.0 143.0             143     34   251 242 1 7         1         108 143         143   34   251
943494 943494 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   pre_kindergarten_full_day 17.0 0.0 2.0         0.0         9.0 10.0             11     *   19 17 0 2         0         9 10         11       19
943495 943495 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   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
943496 943496 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   ungraded_elementary 4.0 0.0 0.0         0.0         2.0 2.0             *     *   4 4 0 0         0         2 2                 4
943497 943497 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   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
943517 943517 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_1 55.0 0.0 0.0   0.0     0.0         25.0 30.0             30     8   55 55 0 0   0     0         25 30         30   8   55
943518 943518 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_10 46.0 0.0 0.0   0.0     0.0         22.0 24.0             22     7   46 46 0 0   0     0         22 24         22   7   46
943519 943519 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_11 42.0 0.0 0.0   0.0     1.0         21.0 22.0             17     *   43 42 0 0   0     1         21 22         17       43
943520 943520 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_12 40.0 0.0 0.0   0.0     0.0         21.0 19.0             18     5   40 40 0 0   0     0         21 19         18   5   40
943521 943521 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 44.0 1.0 2.0   0.0     0.0         24.0 23.0             28     *   47 44 1 2   0     0         24 23         28       47

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