enrollments

Data source: Big Local News · About: Big Local

20,580 rows where state = "OR" and year = 2017 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2017 · 20,480 ✖
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
1700907 1700907 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2017   grade_10                                                   54.0                                             54
1700908 1700908 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2017   grade_10                                                   116.0                                             116
1700909 1700909 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2017   grade_10                                                   0.0                                             0
1700910 1700910 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2017   grade_10                                                   2.0                                             2
1700911 1700911 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   grade_10                                                   116.0                                             116
1700912 1700912 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2017   grade_10                                                   0.0                                             0
1700913 1700913 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2017   grade_10                                                   5.0                                             5
1700914 1700914 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2017   grade_10                                                   0.0                                             0
1700915 1700915 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2017   grade_10                                                   0.0                                             0
1700916 1700916 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Elementary 04 06 2017   grade_10                                                   0.0                                             0
1702377 1702377 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2017   grade_11                                                   82.0                                             82
1702378 1702378 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2017   grade_11                                                   115.0                                             115
1702379 1702379 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2017   grade_11                                                   0.0                                             0
1702380 1702380 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2017   grade_11                                                   9.0                                             9
1702381 1702381 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   grade_11                                                   94.0                                             94
1702382 1702382 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2017   grade_11                                                   0.0                                             0
1702383 1702383 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2017   grade_11                                                   12.0                                             12
1702384 1702384 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2017   grade_11                                                   0.0                                             0
1702385 1702385 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2017   grade_11                                                   0.0                                             0
1702386 1702386 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Elementary 04 06 2017   grade_11                                                   0.0                                             0
1703847 1703847 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2017   grade_12                                                   90.0                                             90
1703848 1703848 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2017   grade_12                                                   110.0                                             110
1703849 1703849 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2017   grade_12                                                   0.0                                             0
1703850 1703850 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2017   grade_12                                                   7.0                                             7
1703851 1703851 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   grade_12                                                   64.0                                             64
1703852 1703852 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2017   grade_12                                                   0.0                                             0
1703853 1703853 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2017   grade_12                                                   6.0                                             6
1703854 1703854 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2017   grade_12                                                   0.0                                             0
1703855 1703855 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2017   grade_12                                                   0.0                                             0
1703856 1703856 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Elementary 04 06 2017   grade_12                                                   0.0                                             0
1705317 1705317 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2017   k_12_total 203.0 4.0 9.0     4.0     1.0   6.0                               203 4 9     4     1   6                        
1705318 1705318 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2017   k_12_total 396.0 1.0 38.0     5.0     0.0   22.0                               396 1 38     5     0   22                        
1705319 1705319 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2017   k_12_total 166.0 0.0 27.0     1.0     0.0   10.0                               166 0 27     1     0   10                        
1705320 1705320 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2017   k_12_total 12.0 0.0 6.0     0.0     0.0   1.0                               12 0 6     0     0   1                        
1705321 1705321 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2017   k_12_total 856.0 20.0 90.0     19.0     2.0   26.0                               856 20 90     19     2   26                        
1705322 1705322 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2017   k_12_total 402.0 1.0 46.0     0.0     0.0   12.0                               402 1 46     0     0   12                        
1705323 1705323 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 09 12 2017   k_12_total 19.0 1.0 1.0     0.0     0.0   1.0                               19 1 1     0     0   1                        
1705324 1705324 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2017   k_12_total 135.0 0.0 10.0     1.0     0.0   7.0                               135 0 10     1     0   7                        
1705325 1705325 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2017   k_12_total 18.0 0.0 4.0     0.0     0.0   2.0                               18 0 4     0     0   2                        
1705326 1705326 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Elementary 04 06 2017   k_12_total 249.0 0.0 40.0     2.0     0.0   25.0                               249 0 40     2     0   25                        
1686755 1686755 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2017   kindergarten                                                   4.0                                             4
1688225 1688225 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2017   grade_1                                                   8.0                                             8
1689695 1689695 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2017   grade_2                                                   5.0                                             5
1691165 1691165 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2017   grade_3                                                   6.0                                             6
1692635 1692635 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2017   grade_4                                                   7.0                                             7
1694105 1694105 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2017   grade_5                                                   5.0                                             5
1695575 1695575 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2017   grade_6                                                   5.0                                             5
1697045 1697045 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2017   grade_7                                                   4.0                                             4
1698515 1698515 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2017   grade_8                                                   4.0                                             4
1699985 1699985 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2017   grade_9                                                   6.0                                             6
1701455 1701455 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2017   grade_10                                                   10.0                                             10
1702925 1702925 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2017   grade_11                                                   6.0                                             6
1704395 1704395 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2017   grade_12                                                   7.0                                             7
1705865 1705865 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2017   k_12_total 61.0 0.0 10.0     5.0     0.0   0.0                               61 0 10     5     0   0                        
1686342 1686342 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2017   kindergarten                                                   3.0                                             3
1687812 1687812 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2017   grade_1                                                   0.0                                             0
1689282 1689282 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2017   grade_2                                                   0.0                                             0
1690752 1690752 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2017   grade_3                                                   1.0                                             1
1692222 1692222 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2017   grade_4                                                   0.0                                             0
1693692 1693692 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2017   grade_5                                                   1.0                                             1
1695162 1695162 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2017   grade_6                                                   3.0                                             3
1696632 1696632 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2017   grade_7                                                   1.0                                             1
1698102 1698102 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2017   grade_8                                                   2.0                                             2
1699572 1699572 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2017   grade_9                                                   1.0                                             1
1701042 1701042 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2017   grade_10                                                   8.0                                             8
1702512 1702512 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2017   grade_11                                                   7.0                                             7
1703982 1703982 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2017   grade_12                                                   7.0                                             7
1705452 1705452 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2017   k_12_total 27.0 0.0 4.0     3.0     0.0   0.0                               27 0 4     3     0   0                        
1687160 1687160 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   kindergarten                                                   16.0                                             16
1688630 1688630 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   grade_1                                                   19.0                                             19
1690100 1690100 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   grade_2                                                   13.0                                             13
1691570 1691570 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   grade_3                                                   18.0                                             18
1693040 1693040 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   grade_4                                                   10.0                                             10
1694510 1694510 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   grade_5                                                   22.0                                             22
1695980 1695980 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   grade_6                                                   12.0                                             12
1697450 1697450 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   grade_7                                                   23.0                                             23
1698920 1698920 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   grade_8                                                   23.0                                             23
1700390 1700390 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   grade_9                                                   8.0                                             8
1701860 1701860 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   grade_10                                                   15.0                                             15
1703330 1703330 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   grade_11                                                   14.0                                             14
1704800 1704800 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   grade_12                                                   15.0                                             15
1706270 1706270 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2017   k_12_total 174.0 1.0 20.0     0.0     0.0   12.0                               174 1 20     0     0   12                        
1686942 1686942 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2017   kindergarten                                                   24.0                                             24
1686943 1686943 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2017   kindergarten                                                   0.0                                             0
1688412 1688412 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2017   grade_1                                                   33.0                                             33
1688413 1688413 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2017   grade_1                                                   0.0                                             0
1689882 1689882 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2017   grade_2                                                   28.0                                             28
1689883 1689883 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2017   grade_2                                                   0.0                                             0
1691352 1691352 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2017   grade_3                                                   47.0                                             47
1691353 1691353 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2017   grade_3                                                   0.0                                             0
1692822 1692822 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2017   grade_4                                                   30.0                                             30
1692823 1692823 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2017   grade_4                                                   0.0                                             0
1694292 1694292 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2017   grade_5                                                   32.0                                             32
1694293 1694293 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2017   grade_5                                                   0.0                                             0
1695762 1695762 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2017   grade_6                                                   38.0                                             38
1695763 1695763 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2017   grade_6                                                   0.0                                             0
1697232 1697232 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2017   grade_7                                                   33.0                                             33
1697233 1697233 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2017   grade_7                                                   0.0                                             0
1698702 1698702 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2017   grade_8                                                   40.0                                             40
1698703 1698703 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2017   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]);