enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
1171510 1171510 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Not Reported M M 2018   kindergarten                                                   0.0                                             0
1172148 1172148 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Not Reported M M 2018   kindergarten                                                   0.0                                             0
1172396 1172396 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Not Reported M M 2018   kindergarten                                                   0.0                                             0
1172574 1172574 OR     school 4110040 2180   Portland SD 1J 411004001537 4212 Self Enhancement, Inc/SEI Academy   Regular School Yes Not Reported M M 2018   kindergarten                                                   0.0                                             0
1172969 1172969 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Not Reported M M 2018   grade_1                                                   0.0                                             0
1173607 1173607 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Not Reported M M 2018   grade_1                                                   0.0                                             0
1173855 1173855 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Not Reported M M 2018   grade_1                                                   0.0                                             0
1174033 1174033 OR     school 4110040 2180   Portland SD 1J 411004001537 4212 Self Enhancement, Inc/SEI Academy   Regular School Yes Not Reported M M 2018   grade_1                                                   0.0                                             0
1174428 1174428 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Not Reported M M 2018   grade_2                                                   0.0                                             0
1175066 1175066 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Not Reported M M 2018   grade_2                                                   0.0                                             0
1175314 1175314 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Not Reported M M 2018   grade_2                                                   0.0                                             0
1175492 1175492 OR     school 4110040 2180   Portland SD 1J 411004001537 4212 Self Enhancement, Inc/SEI Academy   Regular School Yes Not Reported M M 2018   grade_2                                                   0.0                                             0
1175887 1175887 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Not Reported M M 2018   grade_3                                                   0.0                                             0
1176525 1176525 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Not Reported M M 2018   grade_3                                                   0.0                                             0
1176773 1176773 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Not Reported M M 2018   grade_3                                                   0.0                                             0
1176951 1176951 OR     school 4110040 2180   Portland SD 1J 411004001537 4212 Self Enhancement, Inc/SEI Academy   Regular School Yes Not Reported M M 2018   grade_3                                                   0.0                                             0
1177346 1177346 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Not Reported M M 2018   grade_4                                                   0.0                                             0
1177984 1177984 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Not Reported M M 2018   grade_4                                                   0.0                                             0
1178232 1178232 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Not Reported M M 2018   grade_4                                                   0.0                                             0
1178410 1178410 OR     school 4110040 2180   Portland SD 1J 411004001537 4212 Self Enhancement, Inc/SEI Academy   Regular School Yes Not Reported M M 2018   grade_4                                                   0.0                                             0
1178805 1178805 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Not Reported M M 2018   grade_5                                                   0.0                                             0
1179443 1179443 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Not Reported M M 2018   grade_5                                                   0.0                                             0
1179691 1179691 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Not Reported M M 2018   grade_5                                                   0.0                                             0
1179869 1179869 OR     school 4110040 2180   Portland SD 1J 411004001537 4212 Self Enhancement, Inc/SEI Academy   Regular School Yes Not Reported M M 2018   grade_5                                                   0.0                                             0
1180264 1180264 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Not Reported M M 2018   grade_6                                                   0.0                                             0
1180902 1180902 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Not Reported M M 2018   grade_6                                                   0.0                                             0
1181150 1181150 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Not Reported M M 2018   grade_6                                                   0.0                                             0
1181328 1181328 OR     school 4110040 2180   Portland SD 1J 411004001537 4212 Self Enhancement, Inc/SEI Academy   Regular School Yes Not Reported M M 2018   grade_6                                                   0.0                                             0
1181723 1181723 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Not Reported M M 2018   grade_7                                                   0.0                                             0
1182361 1182361 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Not Reported M M 2018   grade_7                                                   0.0                                             0
1182609 1182609 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Not Reported M M 2018   grade_7                                                   0.0                                             0
1182787 1182787 OR     school 4110040 2180   Portland SD 1J 411004001537 4212 Self Enhancement, Inc/SEI Academy   Regular School Yes Not Reported M M 2018   grade_7                                                   0.0                                             0
1183182 1183182 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Not Reported M M 2018   grade_8                                                   0.0                                             0
1183820 1183820 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Not Reported M M 2018   grade_8                                                   0.0                                             0
1184068 1184068 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Not Reported M M 2018   grade_8                                                   0.0                                             0
1184246 1184246 OR     school 4110040 2180   Portland SD 1J 411004001537 4212 Self Enhancement, Inc/SEI Academy   Regular School Yes Not Reported M M 2018   grade_8                                                   0.0                                             0
1184641 1184641 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Not Reported M M 2018   grade_9                                                   0.0                                             0
1185279 1185279 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Not Reported M M 2018   grade_9                                                   0.0                                             0
1185527 1185527 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Not Reported M M 2018   grade_9                                                   0.0                                             0
1185705 1185705 OR     school 4110040 2180   Portland SD 1J 411004001537 4212 Self Enhancement, Inc/SEI Academy   Regular School Yes Not Reported M M 2018   grade_9                                                   0.0                                             0
1186100 1186100 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Not Reported M M 2018   grade_10                                                   0.0                                             0
1186738 1186738 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Not Reported M M 2018   grade_10                                                   0.0                                             0
1186986 1186986 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Not Reported M M 2018   grade_10                                                   0.0                                             0
1187164 1187164 OR     school 4110040 2180   Portland SD 1J 411004001537 4212 Self Enhancement, Inc/SEI Academy   Regular School Yes Not Reported M M 2018   grade_10                                                   0.0                                             0
1187559 1187559 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Not Reported M M 2018   grade_11                                                   0.0                                             0
1188197 1188197 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Not Reported M M 2018   grade_11                                                   0.0                                             0
1188445 1188445 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Not Reported M M 2018   grade_11                                                   0.0                                             0
1188623 1188623 OR     school 4110040 2180   Portland SD 1J 411004001537 4212 Self Enhancement, Inc/SEI Academy   Regular School Yes Not Reported M M 2018   grade_11                                                   0.0                                             0
1189018 1189018 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Not Reported M M 2018   grade_12                                                   0.0                                             0
1189656 1189656 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Not Reported M M 2018   grade_12                                                   0.0                                             0
1189904 1189904 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Not Reported M M 2018   grade_12                                                   0.0                                             0
1190082 1190082 OR     school 4110040 2180   Portland SD 1J 411004001537 4212 Self Enhancement, Inc/SEI Academy   Regular School Yes Not Reported M M 2018   grade_12                                                   0.0                                             0
1190477 1190477 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Not Reported M M 2018   k_12_total 0.0 0.0 0.0   0.0 0.0     0.0   0.0                               0 0 0   0 0     0   0                        
1191115 1191115 OR     school 4107200 2212   La Grande SD 1 410720001768 1071 Willow Elementary School   Regular School No Not Reported M M 2018   k_12_total 0.0 0.0 0.0   0.0 0.0     0.0   0.0                               0 0 0   0 0     0   0                        
1191363 1191363 OR     school 4100043 3477   ODE YCEP District 410004300490 1827 Robert S Farrell High School   Regular School No Not Reported M M 2018   k_12_total 0.0 0.0 0.0   0.0 0.0     0.0   0.0                               0 0 0   0 0     0   0                        
1191541 1191541 OR     school 4110040 2180   Portland SD 1J 411004001537 4212 Self Enhancement, Inc/SEI Academy   Regular School Yes Not Reported M M 2018   k_12_total 0.0 0.0 0.0   0.0 0.0     0.0   0.0                               0 0 0   0 0     0   0                        
1171747 1171747 OR     school 4103390 1964   Coquille SD 8 410339000200 189 Lincoln School of Early Learning   Regular School No Elementary PK KG 2018   kindergarten                                                   77.0                                             77
1171943 1171943 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2018   kindergarten                                                   131.0                                             131
1172455 1172455 OR     school 4109510 2207   Pendleton SD 16 410951001838 5287 Pendleton Early Learning Center   Regular School No Elementary PK KG 2018   kindergarten                                                   255.0                                             255
1172607 1172607 OR     school 4110350 1977   Redmond SD 2J 411035001850 5340 Redmond Early Learning Center at Hugh Hartman   Regular School No Elementary PK KG 2018   kindergarten                                                   390.0                                             390
1173206 1173206 OR     school 4103390 1964   Coquille SD 8 410339000200 189 Lincoln School of Early Learning   Regular School No Elementary PK KG 2018   grade_1                                                   0.0                                             0
1173402 1173402 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2018   grade_1                                                   0.0                                             0
1173914 1173914 OR     school 4109510 2207   Pendleton SD 16 410951001838 5287 Pendleton Early Learning Center   Regular School No Elementary PK KG 2018   grade_1                                                   0.0                                             0
1174066 1174066 OR     school 4110350 1977   Redmond SD 2J 411035001850 5340 Redmond Early Learning Center at Hugh Hartman   Regular School No Elementary PK KG 2018   grade_1                                                   0.0                                             0
1174665 1174665 OR     school 4103390 1964   Coquille SD 8 410339000200 189 Lincoln School of Early Learning   Regular School No Elementary PK KG 2018   grade_2                                                   0.0                                             0
1174861 1174861 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2018   grade_2                                                   0.0                                             0
1175373 1175373 OR     school 4109510 2207   Pendleton SD 16 410951001838 5287 Pendleton Early Learning Center   Regular School No Elementary PK KG 2018   grade_2                                                   0.0                                             0
1175525 1175525 OR     school 4110350 1977   Redmond SD 2J 411035001850 5340 Redmond Early Learning Center at Hugh Hartman   Regular School No Elementary PK KG 2018   grade_2                                                   0.0                                             0
1176124 1176124 OR     school 4103390 1964   Coquille SD 8 410339000200 189 Lincoln School of Early Learning   Regular School No Elementary PK KG 2018   grade_3                                                   0.0                                             0
1176320 1176320 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2018   grade_3                                                   0.0                                             0
1176832 1176832 OR     school 4109510 2207   Pendleton SD 16 410951001838 5287 Pendleton Early Learning Center   Regular School No Elementary PK KG 2018   grade_3                                                   0.0                                             0
1176984 1176984 OR     school 4110350 1977   Redmond SD 2J 411035001850 5340 Redmond Early Learning Center at Hugh Hartman   Regular School No Elementary PK KG 2018   grade_3                                                   0.0                                             0
1177583 1177583 OR     school 4103390 1964   Coquille SD 8 410339000200 189 Lincoln School of Early Learning   Regular School No Elementary PK KG 2018   grade_4                                                   0.0                                             0
1177779 1177779 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2018   grade_4                                                   0.0                                             0
1178291 1178291 OR     school 4109510 2207   Pendleton SD 16 410951001838 5287 Pendleton Early Learning Center   Regular School No Elementary PK KG 2018   grade_4                                                   0.0                                             0
1178443 1178443 OR     school 4110350 1977   Redmond SD 2J 411035001850 5340 Redmond Early Learning Center at Hugh Hartman   Regular School No Elementary PK KG 2018   grade_4                                                   0.0                                             0
1179042 1179042 OR     school 4103390 1964   Coquille SD 8 410339000200 189 Lincoln School of Early Learning   Regular School No Elementary PK KG 2018   grade_5                                                   0.0                                             0
1179238 1179238 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2018   grade_5                                                   0.0                                             0
1179750 1179750 OR     school 4109510 2207   Pendleton SD 16 410951001838 5287 Pendleton Early Learning Center   Regular School No Elementary PK KG 2018   grade_5                                                   0.0                                             0
1179902 1179902 OR     school 4110350 1977   Redmond SD 2J 411035001850 5340 Redmond Early Learning Center at Hugh Hartman   Regular School No Elementary PK KG 2018   grade_5                                                   0.0                                             0
1180501 1180501 OR     school 4103390 1964   Coquille SD 8 410339000200 189 Lincoln School of Early Learning   Regular School No Elementary PK KG 2018   grade_6                                                   0.0                                             0
1180697 1180697 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2018   grade_6                                                   0.0                                             0
1181209 1181209 OR     school 4109510 2207   Pendleton SD 16 410951001838 5287 Pendleton Early Learning Center   Regular School No Elementary PK KG 2018   grade_6                                                   0.0                                             0
1181361 1181361 OR     school 4110350 1977   Redmond SD 2J 411035001850 5340 Redmond Early Learning Center at Hugh Hartman   Regular School No Elementary PK KG 2018   grade_6                                                   0.0                                             0
1181960 1181960 OR     school 4103390 1964   Coquille SD 8 410339000200 189 Lincoln School of Early Learning   Regular School No Elementary PK KG 2018   grade_7                                                   0.0                                             0
1182156 1182156 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2018   grade_7                                                   0.0                                             0
1182668 1182668 OR     school 4109510 2207   Pendleton SD 16 410951001838 5287 Pendleton Early Learning Center   Regular School No Elementary PK KG 2018   grade_7                                                   0.0                                             0
1182820 1182820 OR     school 4110350 1977   Redmond SD 2J 411035001850 5340 Redmond Early Learning Center at Hugh Hartman   Regular School No Elementary PK KG 2018   grade_7                                                   0.0                                             0
1183419 1183419 OR     school 4103390 1964   Coquille SD 8 410339000200 189 Lincoln School of Early Learning   Regular School No Elementary PK KG 2018   grade_8                                                   0.0                                             0
1183615 1183615 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2018   grade_8                                                   0.0                                             0
1184127 1184127 OR     school 4109510 2207   Pendleton SD 16 410951001838 5287 Pendleton Early Learning Center   Regular School No Elementary PK KG 2018   grade_8                                                   0.0                                             0
1184279 1184279 OR     school 4110350 1977   Redmond SD 2J 411035001850 5340 Redmond Early Learning Center at Hugh Hartman   Regular School No Elementary PK KG 2018   grade_8                                                   0.0                                             0
1184878 1184878 OR     school 4103390 1964   Coquille SD 8 410339000200 189 Lincoln School of Early Learning   Regular School No Elementary PK KG 2018   grade_9                                                   0.0                                             0
1185074 1185074 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2018   grade_9                                                   0.0                                             0
1185586 1185586 OR     school 4109510 2207   Pendleton SD 16 410951001838 5287 Pendleton Early Learning Center   Regular School No Elementary PK KG 2018   grade_9                                                   0.0                                             0
1185738 1185738 OR     school 4110350 1977   Redmond SD 2J 411035001850 5340 Redmond Early Learning Center at Hugh Hartman   Regular School No Elementary PK KG 2018   grade_9                                                   0.0                                             0
1186337 1186337 OR     school 4103390 1964   Coquille SD 8 410339000200 189 Lincoln School of Early Learning   Regular School No Elementary PK KG 2018   grade_10                                                   0.0                                             0
1186533 1186533 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2018   grade_10                                                   0.0                                             0
1187045 1187045 OR     school 4109510 2207   Pendleton SD 16 410951001838 5287 Pendleton Early Learning Center   Regular School No Elementary PK KG 2018   grade_10                                                   0.0                                             0
1187197 1187197 OR     school 4110350 1977   Redmond SD 2J 411035001850 5340 Redmond Early Learning Center at Hugh Hartman   Regular School No Elementary PK KG 2018   grade_10                                                   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]);