enrollments

Data source: Big Local News · About: Big Local

20,426 rows where state = "OR" and year = 2018 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2018 · 20,426 ✖
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
1171535 1171535 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2018   kindergarten                                                   0.0                                             0
1171536 1171536 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
1171537 1171537 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2018   kindergarten                                                   0.0                                             0
1171538 1171538 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2018   kindergarten                                                   0.0                                             0
1171539 1171539 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2018   kindergarten                                                   71.0                                             71
1171540 1171540 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2018   kindergarten                                                   121.0                                             121
1171541 1171541 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2018   kindergarten                                                   0.0                                             0
1171542 1171542 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2018   kindergarten                                                   22.0                                             22
1171543 1171543 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2018   kindergarten                                                   0.0                                             0
1171544 1171544 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2018   kindergarten                                                   0.0                                             0
1172994 1172994 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2018   grade_1                                                   0.0                                             0
1172995 1172995 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2018   grade_1                                                   0.0                                             0
1172996 1172996 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2018   grade_1                                                   0.0                                             0
1172997 1172997 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2018   grade_1                                                   0.0                                             0
1172998 1172998 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2018   grade_1                                                   78.0                                             78
1172999 1172999 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2018   grade_1                                                   108.0                                             108
1173000 1173000 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2018   grade_1                                                   0.0                                             0
1173001 1173001 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2018   grade_1                                                   20.0                                             20
1173002 1173002 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2018   grade_1                                                   5.0                                             5
1173003 1173003 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2018   grade_1                                                   0.0                                             0
1174453 1174453 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2018   grade_2                                                   0.0                                             0
1174454 1174454 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2018   grade_2                                                   0.0                                             0
1174455 1174455 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2018   grade_2                                                   0.0                                             0
1174456 1174456 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2018   grade_2                                                   0.0                                             0
1174457 1174457 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2018   grade_2                                                   74.0                                             74
1174458 1174458 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2018   grade_2                                                   110.0                                             110
1174459 1174459 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2018   grade_2                                                   0.0                                             0
1174460 1174460 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2018   grade_2                                                   22.0                                             22
1174461 1174461 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2018   grade_2                                                   4.0                                             4
1174462 1174462 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2018   grade_2                                                   0.0                                             0
1175912 1175912 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2018   grade_3                                                   0.0                                             0
1175913 1175913 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2018   grade_3                                                   0.0                                             0
1175914 1175914 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2018   grade_3                                                   0.0                                             0
1175915 1175915 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2018   grade_3                                                   0.0                                             0
1175916 1175916 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2018   grade_3                                                   76.0                                             76
1175917 1175917 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2018   grade_3                                                   111.0                                             111
1175918 1175918 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2018   grade_3                                                   0.0                                             0
1175919 1175919 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2018   grade_3                                                   20.0                                             20
1175920 1175920 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2018   grade_3                                                   3.0                                             3
1175921 1175921 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2018   grade_3                                                   0.0                                             0
1177371 1177371 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2018   grade_4                                                   0.0                                             0
1177372 1177372 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2018   grade_4                                                   0.0                                             0
1177373 1177373 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2018   grade_4                                                   0.0                                             0
1177374 1177374 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2018   grade_4                                                   0.0                                             0
1177375 1177375 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2018   grade_4                                                   72.0                                             72
1177376 1177376 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2018   grade_4                                                   0.0                                             0
1177377 1177377 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2018   grade_4                                                   0.0                                             0
1177378 1177378 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2018   grade_4                                                   25.0                                             25
1177379 1177379 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2018   grade_4                                                   6.0                                             6
1177380 1177380 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2018   grade_4                                                   129.0                                             129
1178830 1178830 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2018   grade_5                                                   0.0                                             0
1178831 1178831 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2018   grade_5                                                   0.0                                             0
1178832 1178832 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2018   grade_5                                                   0.0                                             0
1178833 1178833 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2018   grade_5                                                   0.0                                             0
1178834 1178834 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2018   grade_5                                                   97.0                                             97
1178835 1178835 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2018   grade_5                                                   0.0                                             0
1178836 1178836 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2018   grade_5                                                   0.0                                             0
1178837 1178837 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2018   grade_5                                                   17.0                                             17
1178838 1178838 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2018   grade_5                                                   6.0                                             6
1178839 1178839 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2018   grade_5                                                   115.0                                             115
1180289 1180289 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2018   grade_6                                                   0.0                                             0
1180290 1180290 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2018   grade_6                                                   0.0                                             0
1180291 1180291 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2018   grade_6                                                   0.0                                             0
1180292 1180292 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2018   grade_6                                                   0.0                                             0
1180293 1180293 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2018   grade_6                                                   107.0                                             107
1180294 1180294 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2018   grade_6                                                   0.0                                             0
1180295 1180295 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2018   grade_6                                                   0.0                                             0
1180296 1180296 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2018   grade_6                                                   23.0                                             23
1180297 1180297 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2018   grade_6                                                   1.0                                             1
1180298 1180298 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2018   grade_6                                                   102.0                                             102
1181748 1181748 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2018   grade_7                                                   0.0                                             0
1181749 1181749 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1181750 1181750 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2018   grade_7                                                   131.0                                             131
1181751 1181751 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2018   grade_7                                                   0.0                                             0
1181752 1181752 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2018   grade_7                                                   129.0                                             129
1181753 1181753 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2018   grade_7                                                   0.0                                             0
1181754 1181754 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2018   grade_7                                                   0.0                                             0
1181755 1181755 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1181756 1181756 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2018   grade_7                                                   0.0                                             0
1181757 1181757 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2018   grade_7                                                   0.0                                             0
1183207 1183207 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2018   grade_8                                                   0.0                                             0
1183208 1183208 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2018   grade_8                                                   0.0                                             0
1183209 1183209 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2018   grade_8                                                   98.0                                             98
1183210 1183210 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2018   grade_8                                                   0.0                                             0
1183211 1183211 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2018   grade_8                                                   144.0                                             144
1183212 1183212 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2018   grade_8                                                   0.0                                             0
1183213 1183213 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2018   grade_8                                                   0.0                                             0
1183214 1183214 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2018   grade_8                                                   0.0                                             0
1183215 1183215 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2018   grade_8                                                   0.0                                             0
1183216 1183216 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2018   grade_8                                                   0.0                                             0
1184666 1184666 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2018   grade_9                                                   1.0                                             1
1184667 1184667 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2018   grade_9                                                   115.0                                             115
1184668 1184668 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2018   grade_9                                                   0.0                                             0
1184669 1184669 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2018   grade_9                                                   0.0                                             0
1184670 1184670 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2018   grade_9                                                   155.0                                             155
1184671 1184671 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2018   grade_9                                                   0.0                                             0
1184672 1184672 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2018   grade_9                                                   3.0                                             3
1184673 1184673 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2018   grade_9                                                   0.0                                             0
1184674 1184674 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2018   grade_9                                                   0.0                                             0
1184675 1184675 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2018   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]);