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,326 ✖
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
1186125 1186125 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2018   grade_10                                                   64.0                                             64
1186126 1186126 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2018   grade_10                                                   129.0                                             129
1186127 1186127 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2018   grade_10                                                   0.0                                             0
1186128 1186128 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2018   grade_10                                                   2.0                                             2
1186129 1186129 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2018   grade_10                                                   144.0                                             144
1186130 1186130 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2018   grade_10                                                   0.0                                             0
1186131 1186131 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2018   grade_10                                                   1.0                                             1
1186132 1186132 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2018   grade_10                                                   0.0                                             0
1186133 1186133 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2018   grade_10                                                   0.0                                             0
1186134 1186134 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2018   grade_10                                                   0.0                                             0
1187584 1187584 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2018   grade_11                                                   109.0                                             109
1187585 1187585 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2018   grade_11                                                   103.0                                             103
1187586 1187586 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2018   grade_11                                                   0.0                                             0
1187587 1187587 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2018   grade_11                                                   3.0                                             3
1187588 1187588 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2018   grade_11                                                   124.0                                             124
1187589 1187589 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2018   grade_11                                                   0.0                                             0
1187590 1187590 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2018   grade_11                                                   9.0                                             9
1187591 1187591 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2018   grade_11                                                   0.0                                             0
1187592 1187592 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2018   grade_11                                                   0.0                                             0
1187593 1187593 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2018   grade_11                                                   0.0                                             0
1189043 1189043 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2018   grade_12                                                   105.0                                             105
1189044 1189044 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2018   grade_12                                                   105.0                                             105
1189045 1189045 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2018   grade_12                                                   0.0                                             0
1189046 1189046 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2018   grade_12                                                   7.0                                             7
1189047 1189047 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2018   grade_12                                                   89.0                                             89
1189048 1189048 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2018   grade_12                                                   0.0                                             0
1189049 1189049 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2018   grade_12                                                   14.0                                             14
1189050 1189050 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2018   grade_12                                                   0.0                                             0
1189051 1189051 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2018   grade_12                                                   0.0                                             0
1189052 1189052 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2018   grade_12                                                   0.0                                             0
1190502 1190502 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2018   k_12_total 247.0 4.0 15.0   0.0 6.0     0.0   7.0                               247 4 15   0 6     0   7                        
1190503 1190503 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2018   k_12_total 381.0 1.0 42.0   4.0 4.0     0.0   20.0                               381 1 42   4 4     0   20                        
1190504 1190504 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2018   k_12_total 189.0 0.0 27.0   3.0 3.0     0.0   7.0                               189 0 27   3 3     0   7                        
1190505 1190505 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2018   k_12_total 11.0 0.0 0.0   1.0 0.0     0.0   0.0                               11 0 0   1 0     0   0                        
1190506 1190506 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2018   k_12_total 1111.0 31.0 128.0   28.0 23.0     8.0   31.0                               1111 31 128   28 23     8   31                        
1190507 1190507 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2018   k_12_total 390.0 2.0 36.0   4.0 0.0     1.0   17.0                               390 2 36   4 0     1   17                        
1190508 1190508 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2018   k_12_total 24.0 0.0 3.0   0.0 0.0     0.0   0.0                               24 0 3   0 0     0   0                        
1190509 1190509 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2018   k_12_total 133.0 0.0 11.0   2.0 1.0     0.0   2.0                               133 0 11   2 1     0   2                        
1190510 1190510 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2018   k_12_total 16.0 0.0 5.0   1.0 0.0     0.0   3.0                               16 0 5   1 0     0   3                        
1190511 1190511 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2018   k_12_total 278.0 0.0 41.0   6.0 0.0     0.0   21.0                               278 0 41   6 0     0   21                        
1172078 1172078 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2018   kindergarten                                                   7.0                                             7
1173537 1173537 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2018   grade_1                                                   5.0                                             5
1174996 1174996 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2018   grade_2                                                   7.0                                             7
1176455 1176455 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2018   grade_3                                                   7.0                                             7
1177914 1177914 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2018   grade_4                                                   7.0                                             7
1179373 1179373 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2018   grade_5                                                   7.0                                             7
1180832 1180832 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2018   grade_6                                                   7.0                                             7
1182291 1182291 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2018   grade_7                                                   6.0                                             6
1183750 1183750 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2018   grade_8                                                   7.0                                             7
1185209 1185209 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2018   grade_9                                                   5.0                                             5
1186668 1186668 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2018   grade_10                                                   12.0                                             12
1188127 1188127 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2018   grade_11                                                   12.0                                             12
1189586 1189586 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2018   grade_12                                                   3.0                                             3
1191045 1191045 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2018   k_12_total 73.0 0.0 10.0   1.0 6.0     0.0   2.0                               73 0 10   1 6     0   2                        
1171672 1171672 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2018   kindergarten                                                   3.0                                             3
1173131 1173131 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2018   grade_1                                                   4.0                                             4
1174590 1174590 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2018   grade_2                                                   0.0                                             0
1176049 1176049 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2018   grade_3                                                   0.0                                             0
1177508 1177508 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2018   grade_4                                                   1.0                                             1
1178967 1178967 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2018   grade_5                                                   1.0                                             1
1180426 1180426 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2018   grade_6                                                   4.0                                             4
1181885 1181885 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2018   grade_7                                                   1.0                                             1
1183344 1183344 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2018   grade_8                                                   1.0                                             1
1184803 1184803 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2018   grade_9                                                   1.0                                             1
1186262 1186262 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2018   grade_10                                                   8.0                                             8
1187721 1187721 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2018   grade_11                                                   12.0                                             12
1189180 1189180 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2018   grade_12                                                   2.0                                             2
1190639 1190639 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2018   k_12_total 28.0 0.0 3.0   0.0 6.0     0.0   1.0                               28 0 3   0 6     0   1                        
1172478 1172478 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2018   kindergarten                                                   19.0                                             19
1173937 1173937 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2018   grade_1                                                   16.0                                             16
1175396 1175396 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2018   grade_2                                                   18.0                                             18
1176855 1176855 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2018   grade_3                                                   10.0                                             10
1178314 1178314 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2018   grade_4                                                   14.0                                             14
1179773 1179773 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2018   grade_5                                                   10.0                                             10
1181232 1181232 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2018   grade_6                                                   19.0                                             19
1182691 1182691 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2018   grade_7                                                   9.0                                             9
1184150 1184150 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2018   grade_8                                                   20.0                                             20
1185609 1185609 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2018   grade_9                                                   16.0                                             16
1187068 1187068 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2018   grade_10                                                   11.0                                             11
1188527 1188527 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2018   grade_11                                                   17.0                                             17
1189986 1189986 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2018   grade_12                                                   16.0                                             16
1191445 1191445 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2018   k_12_total 161.0 0.0 22.0   1.0 0.0     0.0   11.0                               161 0 22   1 0     0   11                        
1172263 1172263 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2018   kindergarten                                                   30.0                                             30
1172264 1172264 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2018   kindergarten                                                   0.0                                             0
1173722 1173722 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2018   grade_1                                                   33.0                                             33
1173723 1173723 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2018   grade_1                                                   0.0                                             0
1175181 1175181 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2018   grade_2                                                   35.0                                             35
1175182 1175182 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2018   grade_2                                                   0.0                                             0
1176640 1176640 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2018   grade_3                                                   25.0                                             25
1176641 1176641 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2018   grade_3                                                   0.0                                             0
1178099 1178099 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2018   grade_4                                                   46.0                                             46
1178100 1178100 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2018   grade_4                                                   0.0                                             0
1179558 1179558 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2018   grade_5                                                   29.0                                             29
1179559 1179559 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2018   grade_5                                                   0.0                                             0
1181017 1181017 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2018   grade_6                                                   28.0                                             28
1181018 1181018 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2018   grade_6                                                   0.0                                             0
1182476 1182476 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2018   grade_7                                                   34.0                                             34
1182477 1182477 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2018   grade_7                                                   0.0                                             0
1183935 1183935 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2018   grade_8                                                   34.0                                             34
1183936 1183936 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2018   grade_8                                                   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]);