enrollments

Data source: Big Local News · About: Big Local

82,026 rows where state = "OR" sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
1686207 1686207 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2017   kindergarten                                                   0.0                                             0
1686208 1686208 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2017   kindergarten                                                   0.0                                             0
1686209 1686209 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2017   kindergarten                                                   0.0                                             0
1686210 1686210 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2017   kindergarten                                                   0.0                                             0
1686211 1686211 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   kindergarten                                                   60.0                                             60
1686212 1686212 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2017   kindergarten                                                   112.0                                             112
1686213 1686213 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2017   kindergarten                                                   0.0                                             0
1686214 1686214 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2017   kindergarten                                                   23.0                                             23
1686215 1686215 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2017   kindergarten                                                   3.0                                             3
1686216 1686216 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Elementary 04 06 2017   kindergarten                                                   0.0                                             0
1687677 1687677 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2017   grade_1                                                   0.0                                             0
1687678 1687678 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2017   grade_1                                                   0.0                                             0
1687679 1687679 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2017   grade_1                                                   0.0                                             0
1687680 1687680 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2017   grade_1                                                   0.0                                             0
1687681 1687681 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   grade_1                                                   49.0                                             49
1687682 1687682 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2017   grade_1                                                   117.0                                             117
1687683 1687683 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2017   grade_1                                                   0.0                                             0
1687684 1687684 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2017   grade_1                                                   19.0                                             19
1687685 1687685 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2017   grade_1                                                   4.0                                             4
1687686 1687686 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Elementary 04 06 2017   grade_1                                                   0.0                                             0
1689147 1689147 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2017   grade_2                                                   0.0                                             0
1689148 1689148 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2017   grade_2                                                   0.0                                             0
1689149 1689149 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2017   grade_2                                                   0.0                                             0
1689150 1689150 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2017   grade_2                                                   0.0                                             0
1689151 1689151 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   grade_2                                                   57.0                                             57
1689152 1689152 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2017   grade_2                                                   110.0                                             110
1689153 1689153 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2017   grade_2                                                   0.0                                             0
1689154 1689154 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2017   grade_2                                                   21.0                                             21
1689155 1689155 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2017   grade_2                                                   3.0                                             3
1689156 1689156 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Elementary 04 06 2017   grade_2                                                   0.0                                             0
1690617 1690617 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2017   grade_3                                                   0.0                                             0
1690618 1690618 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2017   grade_3                                                   0.0                                             0
1690619 1690619 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2017   grade_3                                                   0.0                                             0
1690620 1690620 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2017   grade_3                                                   0.0                                             0
1690621 1690621 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   grade_3                                                   48.0                                             48
1690622 1690622 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2017   grade_3                                                   129.0                                             129
1690623 1690623 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2017   grade_3                                                   0.0                                             0
1690624 1690624 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2017   grade_3                                                   24.0                                             24
1690625 1690625 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2017   grade_3                                                   5.0                                             5
1690626 1690626 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Elementary 04 06 2017   grade_3                                                   0.0                                             0
1692087 1692087 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2017   grade_4                                                   0.0                                             0
1692088 1692088 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2017   grade_4                                                   0.0                                             0
1692089 1692089 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2017   grade_4                                                   0.0                                             0
1692090 1692090 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2017   grade_4                                                   0.0                                             0
1692091 1692091 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   grade_4                                                   63.0                                             63
1692092 1692092 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2017   grade_4                                                   0.0                                             0
1692093 1692093 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2017   grade_4                                                   0.0                                             0
1692094 1692094 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2017   grade_4                                                   22.0                                             22
1692095 1692095 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2017   grade_4                                                   5.0                                             5
1692096 1692096 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Elementary 04 06 2017   grade_4                                                   113.0                                             113
1693557 1693557 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2017   grade_5                                                   0.0                                             0
1693558 1693558 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2017   grade_5                                                   0.0                                             0
1693559 1693559 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2017   grade_5                                                   0.0                                             0
1693560 1693560 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2017   grade_5                                                   0.0                                             0
1693561 1693561 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   grade_5                                                   64.0                                             64
1693562 1693562 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2017   grade_5                                                   0.0                                             0
1693563 1693563 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2017   grade_5                                                   0.0                                             0
1693564 1693564 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2017   grade_5                                                   25.0                                             25
1693565 1693565 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2017   grade_5                                                   2.0                                             2
1693566 1693566 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Elementary 04 06 2017   grade_5                                                   105.0                                             105
1695027 1695027 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2017   grade_6                                                   0.0                                             0
1695028 1695028 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2017   grade_6                                                   0.0                                             0
1695029 1695029 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2017   grade_6                                                   0.0                                             0
1695030 1695030 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2017   grade_6                                                   0.0                                             0
1695031 1695031 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   grade_6                                                   85.0                                             85
1695032 1695032 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2017   grade_6                                                   0.0                                             0
1695033 1695033 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2017   grade_6                                                   0.0                                             0
1695034 1695034 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2017   grade_6                                                   21.0                                             21
1695035 1695035 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2017   grade_6                                                   3.0                                             3
1695036 1695036 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Elementary 04 06 2017   grade_6                                                   103.0                                             103
1696497 1696497 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2017   grade_7                                                   0.0                                             0
1696498 1696498 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2017   grade_7                                                   0.0                                             0
1696499 1696499 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2017   grade_7                                                   98.0                                             98
1696500 1696500 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2017   grade_7                                                   0.0                                             0
1696501 1696501 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   grade_7                                                   86.0                                             86
1696502 1696502 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2017   grade_7                                                   0.0                                             0
1696503 1696503 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2017   grade_7                                                   0.0                                             0
1696504 1696504 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2017   grade_7                                                   0.0                                             0
1696505 1696505 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2017   grade_7                                                   0.0                                             0
1696506 1696506 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Elementary 04 06 2017   grade_7                                                   0.0                                             0
1697967 1697967 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2017   grade_8                                                   0.0                                             0
1697968 1697968 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2017   grade_8                                                   0.0                                             0
1697969 1697969 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2017   grade_8                                                   108.0                                             108
1697970 1697970 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2017   grade_8                                                   1.0                                             1
1697971 1697971 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   grade_8                                                   121.0                                             121
1697972 1697972 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2017   grade_8                                                   0.0                                             0
1697973 1697973 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2017   grade_8                                                   0.0                                             0
1697974 1697974 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2017   grade_8                                                   0.0                                             0
1697975 1697975 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2017   grade_8                                                   0.0                                             0
1697976 1697976 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Elementary 04 06 2017   grade_8                                                   0.0                                             0
1699437 1699437 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2017   grade_9                                                   1.0                                             1
1699438 1699438 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2017   grade_9                                                   126.0                                             126
1699439 1699439 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2017   grade_9                                                   0.0                                             0
1699440 1699440 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2017   grade_9                                                   1.0                                             1
1699441 1699441 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   grade_9                                                   125.0                                             125
1699442 1699442 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2017   grade_9                                                   0.0                                             0
1699443 1699443 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2017   grade_9                                                   0.0                                             0
1699444 1699444 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2017   grade_9                                                   0.0                                             0
1699445 1699445 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2017   grade_9                                                   0.0                                             0
1699446 1699446 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Elementary 04 06 2017   grade_9                                                   0.0                                             0

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