enrollments

Data source: Big Local News · About: Big Local

20,594 rows where state = "OR" and year = 2021 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2021 · 20,494 ✖
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
649457 649457 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2021   grade_8                                                   -                                              
649458 649458 OR     school 4101710 1894   Baker SD 5J 410171001879 5604 Baker Virtual Academy   Regular School No Elementary KG 06 2021   grade_8                                                   0                                             0
649459 649459 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2021   grade_8                                                   288                                             288
649460 649460 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary 01 03 2021   grade_8                                                   0                                             0
649461 649461 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 07 12 2021   grade_8                                                   24                                             24
649462 649462 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2021   grade_8                                                   0                                             0
649463 649463 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2021   grade_8                                                   0                                             0
649464 649464 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2021   grade_8                                                   0                                             0
650924 650924 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2021   grade_9                                                   2                                             2
650925 650925 OR     school 4101710 1894   Baker SD 5J 410171001878 5509 Baker Early Learning Center   Regular School No Elementary KG KG 2021   grade_9                                                   0                                             0
650926 650926 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2021   grade_9                                                   120                                             120
650927 650927 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2021   grade_9                                                   0                                             0
650928 650928 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2021   grade_9                                                   -                                              
650929 650929 OR     school 4101710 1894   Baker SD 5J 410171001879 5604 Baker Virtual Academy   Regular School No Elementary KG 06 2021   grade_9                                                   0                                             0
650930 650930 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2021   grade_9                                                   249                                             249
650931 650931 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary 01 03 2021   grade_9                                                   0                                             0
650932 650932 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 07 12 2021   grade_9                                                   20                                             20
650933 650933 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2021   grade_9                                                   0                                             0
650934 650934 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2021   grade_9                                                   0                                             0
650935 650935 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2021   grade_9                                                   0                                             0
652395 652395 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2021   grade_10                                                   54                                             54
652396 652396 OR     school 4101710 1894   Baker SD 5J 410171001878 5509 Baker Early Learning Center   Regular School No Elementary KG KG 2021   grade_10                                                   0                                             0
652397 652397 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2021   grade_10                                                   116                                             116
652398 652398 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2021   grade_10                                                   0                                             0
652399 652399 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2021   grade_10                                                   -                                              
652400 652400 OR     school 4101710 1894   Baker SD 5J 410171001879 5604 Baker Virtual Academy   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
652401 652401 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2021   grade_10                                                   266                                             266
652402 652402 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary 01 03 2021   grade_10                                                   0                                             0
652403 652403 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 07 12 2021   grade_10                                                   22                                             22
652404 652404 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
652405 652405 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2021   grade_10                                                   0                                             0
652406 652406 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2021   grade_10                                                   0                                             0
653866 653866 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2021   grade_11                                                   131                                             131
653867 653867 OR     school 4101710 1894   Baker SD 5J 410171001878 5509 Baker Early Learning Center   Regular School No Elementary KG KG 2021   grade_11                                                   0                                             0
653868 653868 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2021   grade_11                                                   78                                             78
653869 653869 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2021   grade_11                                                   0                                             0
653870 653870 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2021   grade_11                                                   -                                              
653871 653871 OR     school 4101710 1894   Baker SD 5J 410171001879 5604 Baker Virtual Academy   Regular School No Elementary KG 06 2021   grade_11                                                   0                                             0
653872 653872 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2021   grade_11                                                   235                                             235
653873 653873 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary 01 03 2021   grade_11                                                   0                                             0
653874 653874 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 07 12 2021   grade_11                                                   28                                             28
653875 653875 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2021   grade_11                                                   0                                             0
653876 653876 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2021   grade_11                                                   0                                             0
653877 653877 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2021   grade_11                                                   0                                             0
655337 655337 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2021   grade_12                                                   142                                             142
655338 655338 OR     school 4101710 1894   Baker SD 5J 410171001878 5509 Baker Early Learning Center   Regular School No Elementary KG KG 2021   grade_12                                                   0                                             0
655339 655339 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2021   grade_12                                                   79                                             79
655340 655340 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2021   grade_12                                                   0                                             0
655341 655341 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2021   grade_12                                                   -                                              
655342 655342 OR     school 4101710 1894   Baker SD 5J 410171001879 5604 Baker Virtual Academy   Regular School No Elementary KG 06 2021   grade_12                                                   0                                             0
655343 655343 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2021   grade_12                                                   190                                             190
655344 655344 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary 01 03 2021   grade_12                                                   0                                             0
655345 655345 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 07 12 2021   grade_12                                                   31                                             31
655346 655346 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2021   grade_12                                                   0                                             0
655347 655347 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2021   grade_12                                                   0                                             0
655348 655348 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2021   grade_12                                                   0                                             0
656808 656808 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2021   k_12_total 283 2 14   0 8     0   22                               283 2 14   0 8     0   22                        
656809 656809 OR     school 4101710 1894   Baker SD 5J 410171001878 5509 Baker Early Learning Center   Regular School No Elementary KG KG 2021   k_12_total 53 0 11   0 0     0   3                               53 0 11   0 0     0   3                        
656810 656810 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2021   k_12_total 351 1 11   8 4     0   18                               351 1 11   8 4     0   18                        
656811 656811 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2021   k_12_total 234 0 2   11 0     0   15                               234 0 2   11 0     0   15                        
656812 656812 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2021   k_12_total - - -   - -     -   -                                                                            
656813 656813 OR     school 4101710 1894   Baker SD 5J 410171001879 5604 Baker Virtual Academy   Regular School No Elementary KG 06 2021   k_12_total 74 0 0   0 0     0   9                               74 0 0   0 0     0   9                        
656814 656814 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2021   k_12_total 2209 24 292   22 27     9   144                               2209 24 292   22 27     9   144                        
656815 656815 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary 01 03 2021   k_12_total 228 0 12   0 2     0   20                               228 0 12   0 2     0   20                        
656816 656816 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 07 12 2021   k_12_total 120 0 5   3 1     0   9                               120 0 5   3 1     0   9                        
656817 656817 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2021   k_12_total 101 0 2   1 1     0   8                               101 0 2   1 1     0   8                        
656818 656818 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2021   k_12_total 19 0 0   0 0     0   1                               19 0 0   0 0     0   1                        
656819 656819 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2021   k_12_total 238 2 13   6 1     0   15                               238 2 13   6 1     0   15                        
638237 638237 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   kindergarten                                                   6                                             6
639708 639708 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   grade_1                                                   0                                             0
641179 641179 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   grade_2                                                   3                                             3
642650 642650 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   grade_3                                                   1                                             1
644121 644121 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   grade_4                                                   1                                             1
645592 645592 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   grade_5                                                   0                                             0
647063 647063 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   grade_6                                                   0                                             0
648534 648534 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   grade_7                                                   0                                             0
650005 650005 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   grade_8                                                   1                                             1
651476 651476 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   grade_9                                                   0                                             0
652947 652947 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   grade_10                                                   1                                             1
654418 654418 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   grade_11                                                   5                                             5
655889 655889 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   grade_12                                                   3                                             3
657360 657360 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2021   k_12_total 17 0 1   0 3     0   0                               17 0 1   0 3     0   0                        
637827 637827 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   kindergarten                                                   2                                             2
639298 639298 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   grade_1                                                   2                                             2
640769 640769 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   grade_2                                                   3                                             3
642240 642240 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   grade_3                                                   1                                             1
643711 643711 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   grade_4                                                   3                                             3
645182 645182 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   grade_5                                                   2                                             2
646653 646653 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   grade_6                                                   2                                             2
648124 648124 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   grade_7                                                   2                                             2
649595 649595 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   grade_8                                                   3                                             3
651066 651066 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   grade_9                                                   4                                             4
652537 652537 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   grade_10                                                   0                                             0
654008 654008 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   grade_11                                                   3                                             3
655479 655479 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   grade_12                                                   3                                             3
656950 656950 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2021   k_12_total 27 0 2   0 0     0   1                               27 0 2   0 0     0   1                        
638640 638640 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2021   kindergarten                                                   12                                             12
640111 640111 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2021   grade_1                                                   17                                             17
641582 641582 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2021   grade_2                                                   12                                             12
643053 643053 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2021   grade_3                                                   14                                             14

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