enrollments

Data source: Big Local News · About: Big Local

82,026 rows where state = "OR" sorted by ccd_school_type descending

✎ 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
1687110 1687110 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   kindergarten                                                   1.0                                             1
1688580 1688580 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   grade_1                                                   7.0                                             7
1690050 1690050 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   grade_2                                                   3.0                                             3
1691520 1691520 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   grade_3                                                   1.0                                             1
1692990 1692990 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   grade_4                                                   2.0                                             2
1694460 1694460 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   grade_5                                                   10.0                                             10
1695930 1695930 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   grade_6                                                   7.0                                             7
1697400 1697400 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   grade_7                                                   6.0                                             6
1698870 1698870 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   grade_8                                                   4.0                                             4
1700340 1700340 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   grade_9                                                   18.0                                             18
1701810 1701810 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   grade_10                                                   9.0                                             9
1703280 1703280 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   grade_11                                                   12.0                                             12
1704750 1704750 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   grade_12                                                   43.0                                             43
1706220 1706220 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2017   k_12_total 49.0 8.0 48.0     4.0     5.0   5.0                               49 8 48     4     5   5                        
1172429 1172429 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   kindergarten                                                   1.0                                             1
1173888 1173888 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   grade_1                                                   1.0                                             1
1175347 1175347 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   grade_2                                                   9.0                                             9
1176806 1176806 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   grade_3                                                   2.0                                             2
1178265 1178265 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   grade_4                                                   2.0                                             2
1179724 1179724 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   grade_5                                                   3.0                                             3
1181183 1181183 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   grade_6                                                   16.0                                             16
1182642 1182642 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   grade_7                                                   7.0                                             7
1184101 1184101 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   grade_8                                                   6.0                                             6
1185560 1185560 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   grade_9                                                   10.0                                             10
1187019 1187019 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   grade_10                                                   17.0                                             17
1188478 1188478 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   grade_11                                                   10.0                                             10
1189937 1189937 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   grade_12                                                   34.0                                             34
1191396 1191396 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2018   k_12_total 50.0 6.0 44.0   3.0 3.0     5.0   7.0                               50 6 44   3 3     5   7                        
898594 898594 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   kindergarten                                                   7                                             7
900053 900053 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   grade_1                                                   6                                             6
901512 901512 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   grade_2                                                   4                                             4
902971 902971 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   grade_3                                                   0                                             0
904430 904430 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   grade_4                                                   7                                             7
905889 905889 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   grade_5                                                   1                                             1
907348 907348 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   grade_6                                                   11                                             11
908807 908807 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   grade_7                                                   6                                             6
910266 910266 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   grade_8                                                   16                                             16
911725 911725 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   grade_9                                                   15                                             15
913184 913184 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   grade_10                                                   8                                             8
914643 914643 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   grade_11                                                   10                                             10
916102 916102 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   grade_12                                                   30                                             30
917561 917561 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2020   k_12_total 50 5 42   4 6     4   10                               50 5 42   4 6     4   10                        
638591 638591 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   kindergarten                                                   0                                             0
640062 640062 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   grade_1                                                   6                                             6
641533 641533 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   grade_2                                                   7                                             7
643004 643004 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   grade_3                                                   5                                             5
644475 644475 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   grade_4                                                   1                                             1
645946 645946 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   grade_5                                                   6                                             6
647417 647417 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   grade_6                                                   1                                             1
648888 648888 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   grade_7                                                   9                                             9
650359 650359 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   grade_8                                                   4                                             4
651830 651830 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   grade_9                                                   17                                             17
653301 653301 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   grade_10                                                   13                                             13
654772 654772 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   grade_11                                                   9                                             9
656243 656243 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   grade_12                                                   17                                             17
657714 657714 OR     school 4100009 2336   Oregon Department of Education 410000900062 1832 Oregon School for the Deaf   Special Education School No Other KG 12 2021   k_12_total 38 4 34   4 3     4   8                               38 4 34   4 3     4   8                        
1686178 1686178 OR     school 4100990 2063   Adel SD 21 410099000524 498 Adel Elementary School   Regular School No Elementary 04 08 2017   kindergarten                                                   0.0                                             0
1686179 1686179 OR     school 4101020 2113   Adrian SD 61 410102000755 707 Adrian Elementary School   Regular School No Elementary KG 08 2017   kindergarten                                                   21.0                                             21
1686180 1686180 OR     school 4101020 2113   Adrian SD 61 410102000756 708 Adrian High School   Regular School No High 09 12 2017   kindergarten                                                   0.0                                             0
1686181 1686181 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Elementary KG 06 2017   kindergarten                                                   12.0                                             12
1686182 1686182 OR     school 4101200 1899   Alsea SD 7J 410120000019 17 Alsea High School   Regular School No High 07 12 2017   kindergarten                                                   0.0                                             0
1686183 1686183 OR     school 4101230 2252   Amity SD 4J 410123001260 1208 Amity Elementary School   Regular School No Elementary KG 05 2017   kindergarten                                                   59.0                                             59
1686184 1686184 OR     school 4101230 2252   Amity SD 4J 410123001263 1210 Amity High School   Regular School No High 09 12 2017   kindergarten                                                   0.0                                             0
1686185 1686185 OR     school 4101230 2252   Amity SD 4J 410123001320 1209 Amity Middle School   Regular School No Middle 06 08 2017   kindergarten                                                   0.0                                             0
1686186 1686186 OR     school 4101230 2252   Amity SD 4J 410123001653 4505 Eola Hills Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   0.0                                             0
1686187 1686187 OR     school 4101350 2111   Annex SD 29 410135000753 705 Annex Charter School   Regular School Yes Elementary KG 08 2017   kindergarten                                                   6.0                                             6
1686189 1686189 OR     school 4101470 2005   Arlington SD 3 410147000343 323 Arlington Community Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   7.0                                             7
1686190 1686190 OR     school 4101500 2115   Arock SD 81 410150000759 711 W W Jones Elementary School   Regular School No Elementary KG 08 2017   kindergarten                                                   3.0                                             3
1686191 1686191 OR     school 4101560 2041   Ashland SD 5 410156000401 381 Ashland High School   Regular School No High 09 12 2017   kindergarten                                                   0.0                                             0
1686192 1686192 OR     school 4101560 2041   Ashland SD 5 410156000400 380 Ashland Middle School   Regular School No Middle 06 08 2017   kindergarten                                                   0.0                                             0
1686194 1686194 OR     school 4101560 2041   Ashland SD 5 410156000395 375 Bellview Elementary School   Regular School No Elementary KG 05 2017   kindergarten                                                   48.0                                             48
1686195 1686195 OR     school 4101560 2041   Ashland SD 5 410156000397 377 Helman Elementary School   Regular School No Elementary KG 05 2017   kindergarten                                                   46.0                                             46
1686196 1686196 OR     school 4101560 2041   Ashland SD 5 410156001654 4476 John Muir Elementary School   Regular School No Elementary KG 08 2017   kindergarten                                                   12.0                                             12
1686197 1686197 OR     school 4101560 2041   Ashland SD 5 410156000399 379 Walker Elementary School   Regular School No Elementary KG 05 2017   kindergarten                                                   68.0                                             68
1686198 1686198 OR     school 4101590 2051   Ashwood SD 8 410159000448 427 Ashwood Elementary School   Regular School No Elementary KG 06 2017   kindergarten                                                   1.0                                             1
1686199 1686199 OR     school 4101620 1933   Astoria SD 1 410162000152 143 Astor Elementary School   Regular School No Elementary KG 02 2017   kindergarten                                                   154.0                                             154
1686200 1686200 OR     school 4101620 1933   Astoria SD 1 410162000153 144 Astoria Middle School   Regular School No Middle 06 08 2017   kindergarten                                                   0.0                                             0
1686202 1686202 OR     school 4101620 1933   Astoria SD 1 410162000155 146 Astoria Senior High School   Regular School No High 09 12 2017   kindergarten                                                   0.0                                             0
1686203 1686203 OR     school 4101620 1933   Astoria SD 1 410162000156 147 Lewis & Clark Elementary School   Regular School No Elementary 03 05 2017   kindergarten                                                   0.0                                             0
1686204 1686204 OR     school 4101660 2208   Athena-Weston SD 29RJ 410166001112 1053 Athena Elementary School   Regular School No Elementary KG 03 2017   kindergarten                                                   34.0                                             34
1686205 1686205 OR     school 4101660 2208   Athena-Weston SD 29RJ 410166001114 1055 Weston Middle School   Regular School No Elementary 04 08 2017   kindergarten                                                   0.0                                             0
1686206 1686206 OR     school 4101660 2208   Athena-Weston SD 29RJ 410166001115 1056 Weston-McEwen High School   Regular School No High 09 12 2017   kindergarten                                                   0.0                                             0
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
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
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
1686217 1686217 OR     school 4101800 1969   Bandon SD 54 410180000237 218 Bandon Senior High School   Regular School No High 09 12 2017   kindergarten                                                   0.0                                             0
1686218 1686218 OR     school 4101800 1969   Bandon SD 54 410180000235 216 Harbor Lights Middle School   Regular School No Middle 05 08 2017   kindergarten                                                   0.0                                             0
1686219 1686219 OR     school 4101800 1969   Bandon SD 54 410180000236 217 Ocean Crest Elementary School   Regular School No Elementary KG 04 2017   kindergarten                                                   40.0                                             40
1686220 1686220 OR     school 4101830 2240   Banks SD 13 410183001176 1120 Banks Elementary School   Regular School No Elementary KG 05 2017   kindergarten                                                   78.0                                             78
1686221 1686221 OR     school 4101830 2240   Banks SD 13 410183001180 1124 Banks High School   Regular School No High 09 12 2017   kindergarten                                                   0.0                                             0
1686222 1686222 OR     school 4101830 2240   Banks SD 13 410183001179 1123 Banks Middle School   Regular School No Middle 06 08 2017   kindergarten                                                   0.0                                             0
1686224 1686224 OR     school 4101920 2243   Beaverton SD 48J 410192001239 1186 Aloha High School   Regular School No High 09 12 2017   kindergarten                                                   0.0                                             0
1686225 1686225 OR     school 4101920 2243   Beaverton SD 48J 410192001204 1153 Aloha-Huber Park School   Regular School No Elementary PK 08 2017   kindergarten                                                   111.0                                             111
1686226 1686226 OR     school 4101920 2243   Beaverton SD 48J 410192001791 4805 Arco Iris Spanish Immersion School   Regular School Yes Elementary 01 08 2017   kindergarten                                                   0.0                                             0
1686227 1686227 OR     school 4101920 2243   Beaverton SD 48J 410192000213 1304 Arts and Communication Magnet Academy   Regular School No Other 06 12 2017   kindergarten                                                   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]);