Data source: Big Local News · About: Big Local

1,470 rows where grade = "k_12_total", state = "OR" and year = 2017 sorted by district_state_id

View and edit SQL

year

  • 2017 · 1,470

grade

  • k_12_total · 1,470
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
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 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 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 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 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 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 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 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 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 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                        
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                        
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                        
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                        
1706052 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2017   k_12_total 224.0 0.0 68.0     2.0     0.0   11.0                               224 0 68     2     0   11                        
1706053 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2017   k_12_total 101.0 0.0 27.0     1.0     0.0   4.0                               101 0 27     1     0   4                        
1705291 OR     school 4101200 1899   Alsea SD 7J 410120001502 16 Alsea Elementary School   Regular School No Elementary KG 06 2017   k_12_total 63.0 0.0 7.0     0.0     0.0   3.0                               63 0 7     0     0   3                        
1705292 OR     school 4101200 1899   Alsea SD 7J 410120000019 17 Alsea High School   Regular School No High 07 12 2017   k_12_total 59.0 0.0 6.0     0.0     0.0   0.0                               59 0 6     0     0   0                        
1706254 OR     school 4109600 1900   Philomath SD 17J 410960000020 18 Blodgett Elementary School   Regular School No Elementary KG 04 2017   k_12_total 28.0 1.0 1.0     0.0     0.0   2.0                               28 1 1     0     0   2                        
1706255 OR     school 4109600 1900   Philomath SD 17J 410960001481 3162 Clemens Primary School   Regular School No Elementary KG 01 2017   k_12_total 139.0 1.0 13.0     1.0     1.0   8.0                               139 1 13     1     1   8                        
1706256 OR     school 4109600 1900   Philomath SD 17J 410960000021 3440 Kings Valley Charter School   Regular School Yes Other KG 12 2017   k_12_total 160.0 0.0 12.0     2.0     0.0   7.0                               160 0 12     2     0   7                        
1706257 OR     school 4109600 1900   Philomath SD 17J 410960000022 20 Philomath Elementary School   Regular School No Elementary 02 05 2017   k_12_total 347.0 1.0 30.0     5.0     0.0   18.0                               347 1 30     5     0   18                        
1706258 OR     school 4109600 1900   Philomath SD 17J 410960000024 22 Philomath High School   Regular School No High 09 12 2017   k_12_total 399.0 0.0 37.0     6.0     0.0   16.0                               399 0 37     6     0   16                        
1706259 OR     school 4109600 1900   Philomath SD 17J 410960000023 21 Philomath Middle School   Regular School No Middle 06 08 2017   k_12_total 289.0 0.0 22.0     2.0     0.0   21.0                               289 0 22     2     0   21                        
1705532 OR     school 4103480 1901   Corvallis SD 509J 410348000032 27 Adams Elementary School   Regular School No Elementary KG 05 2017   k_12_total 327.0 9.0 13.0     23.0     2.0   29.0                               327 9 13     23     2   29                        
1705533 OR     school 4103480 1901   Corvallis SD 509J 410348000033 28 Cheldelin Middle School   Regular School No Middle 06 08 2017   k_12_total 388.0 5.0 48.0     40.0     2.0   56.0                               388 5 48     40     2   56                        
1705534 OR     school 4103480 1901   Corvallis SD 509J 410348000047 40 Corvallis High School   Regular School No High 09 12 2017   k_12_total 784.0 22.0 216.0     59.0     10.0   105.0                               784 22 216     59     10   105                        
1705535 OR     school 4103480 1901   Corvallis SD 509J   1901 Corvallis SD 509J             2017   k_12_total 55.0 1.0 16.0     5.0     0.0   5.0                               55 1 16     5     0   5                        
1705536 OR     school 4103480 1901   Corvallis SD 509J 410348000048 41 Crescent Valley High School   Regular School No High 09 12 2017   k_12_total 754.0 8.0 88.0     88.0     3.0   57.0                               754 8 88     88     3   57                        
1705537 OR     school 4103480 1901   Corvallis SD 509J 410348000570 1322 Franklin School   Alternative School No Elementary KG 08 2017   k_12_total 227.0 5.0 31.0     43.0     1.0   33.0                               227 5 31     43     1   33                        
1705538 OR     school 4103480 1901   Corvallis SD 509J 410348000037 30 Garfield Elementary School   Regular School No Elementary KG 05 2017   k_12_total 191.0 6.0 195.0     13.0     0.0   24.0                               191 6 195     13     0   24                        
1705539 OR     school 4103480 1901   Corvallis SD 509J 410348000040 33 Hoover Elementary School   Regular School No Elementary KG 05 2017   k_12_total 284.0 8.0 31.0     57.0     0.0   43.0                               284 8 31     57     0   43                        
1705540 OR     school 4103480 1901   Corvallis SD 509J 410348001743 4637 Inavale Community Partners dba Muddy Creek Charter School   Regular School Yes Elementary KG 05 2017   k_12_total 93.0 2.0 12.0     0.0     0.0   3.0                               93 2 12     0     0   3                        
1705541 OR     school 4103480 1901   Corvallis SD 509J 410348000042 35 Jefferson Elementary School   Regular School No Elementary KG 05 2017   k_12_total 269.0 3.0 16.0     10.0     2.0   24.0                               269 3 16     10     2   24                        
1705542 OR     school 4103480 1901   Corvallis SD 509J 410348000043 36 Lincoln Elementary School   Regular School No Elementary KG 05 2017   k_12_total 212.0 6.0 120.0     2.0     0.0   19.0                               212 6 120     2     0   19                        
1705543 OR     school 4103480 1901   Corvallis SD 509J 410348000045 38 Linus Pauling Middle School   Regular School No Middle 06 08 2017   k_12_total 464.0 6.0 181.0     21.0     3.0   48.0                               464 6 181     21     3   48                        
1705544 OR     school 4103480 1901   Corvallis SD 509J 410348000044 37 Mt View Elementary School   Regular School No Elementary KG 05 2017   k_12_total 281.0 4.0 22.0     10.0     1.0   21.0                               281 4 22     10     1   21                        
1705545 OR     school 4103480 1901   Corvallis SD 509J 410348000046 39 Wilson Elementary School   Regular School No Elementary KG 05 2017   k_12_total 268.0 8.0 46.0     26.0     4.0   32.0                               268 8 46     26     4   32                        
1705546 OR     school 4103480 1901   Corvallis SD 509J   1874 YES House Alternative School             2017   k_12_total 8.0 0.0 5.0     0.0     0.0   3.0                               8 0 5     0     0   3                        
1705504 OR     school   1902   Clackamas ESD   1902 Clackamas ESD             2017   k_12_total 159.0 5.0 32.0     5.0     0.0   14.0                               159 5 32     5     0   14                        
1705505 OR     school   1902   Clackamas ESD   4689 Clackamas River School             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1705506 OR     school   1902   Clackamas ESD   1246 Merrick School             2017   k_12_total 0.0 0.0 0.0     0.0     0.0   0.0                               0 0 0     0     0   0                        
1706709 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001786 4773 Arts and Technology High School   Alternative School No High 09 12 2017   k_12_total 64.0 2.0 8.0     0.0     0.0   6.0                               64 2 8     0     0   6                        
1706710 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000056 1287 Athey Creek Middle School   Regular School No Middle 06 08 2017   k_12_total 550.0 10.0 30.0     36.0     0.0   35.0                               550 10 30     36     0   35                        
1706711 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001356 1272 Boeckman Creek Primary School   Regular School No Elementary PK 05 2017   k_12_total 369.0 9.0 73.0     20.0     5.0   28.0                               369 9 73     20     5   28                        
1706712 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001447 3455 Bolton Primary School   Regular School No Elementary PK 05 2017   k_12_total 337.0 5.0 12.0     11.0     0.0   16.0                               337 5 12     11     0   16                        
1706713 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001575 3913 Boones Ferry Primary School   Regular School No Elementary PK 05 2017   k_12_total 379.0 1.0 118.0     14.0     10.0   30.0                               379 1 118     14     10   30                        
1706714 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000053 45 Cedaroak Park Primary School   Regular School No Elementary PK 05 2017   k_12_total 262.0 1.0 16.0     5.0     0.0   23.0                               262 1 16     5     0   23                        
1706715 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001318 46 Inza R Wood Middle School   Regular School No Middle 06 08 2017   k_12_total 541.0 6.0 160.0     28.0     8.0   64.0                               541 6 160     28     8   64                        
1706716 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001822 5056 Lowrie Primary School   Regular School No Elementary PK 05 2017   k_12_total 344.0 5.0 144.0     30.0     3.0   45.0                               344 5 144     30     3   45                        
1706717 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001414 2787 Rosemont Ridge Middle School   Regular School No Middle 06 08 2017   k_12_total 670.0 13.0 47.0     33.0     1.0   67.0                               670 13 47     33     1   67                        
1706718 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000054 47 Stafford Primary School   Regular School No Elementary KG 05 2017   k_12_total 367.0 2.0 16.0     33.0     1.0   32.0                               367 2 16     33     1   32                        
1706719 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000055 48 Sunset Primary School   Regular School No Elementary KG 05 2017   k_12_total 252.0 2.0 20.0     14.0     0.0   28.0                               252 2 20     14     0   28                        
1706720 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001437 3452 Three Rivers Charter School   Regular School Yes Elementary 04 08 2017   k_12_total 79.0 0.0 6.0     14.0     0.0   11.0                               79 0 6     14     0   11                        
1706721 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001825 5057 Trillium Creek Primary School   Regular School No Elementary PK 05 2017   k_12_total 475.0 7.0 42.0     23.0     1.0   66.0                               475 7 42     23     1   66                        
1706722 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000058 51 West Linn High School   Regular School No High 09 12 2017   k_12_total 1443.0 9.0 129.0     96.0     3.0   122.0                               1443 9 129     96     3   122                        
1706723 OR     school 4113170 1922   West Linn-Wilsonville SD 3J   1922 West Linn-Wilsonville SD 3J             2017   k_12_total 27.0 1.0 3.0     0.0     0.0   4.0                               27 1 3     0     0   4                        
1706724 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001377 1286 Willamette Primary School   Regular School No Elementary KG 05 2017   k_12_total 449.0 6.0 38.0     16.0     1.0   48.0                               449 6 38     16     1   48                        
1706725 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000574 1323 Wilsonville High School   Regular School No High 09 12 2017   k_12_total 817.0 14.0 199.0     32.0     5.0   83.0                               817 14 199     32     5   83                        
1705943 OR     school 4107230 1923   Lake Oswego SD 7J 410723000060 53 Forest Hills Elementary School   Regular School No Elementary KG 05 2017   k_12_total 361.0 4.0 16.0     30.0     0.0   29.0                               361 4 16     30     0   29                        
1705944 OR     school 4107230 1923   Lake Oswego SD 7J 410723001308 54 Hallinan Elementary School   Regular School No Elementary KG 05 2017   k_12_total 344.0 2.0 43.0     28.0     2.0   38.0                               344 2 43     28     2   38                        
1705945 OR     school 4107230 1923   Lake Oswego SD 7J 410723000061 55 Lake Grove Elementary School   Regular School No Elementary KG 05 2017   k_12_total 328.0 5.0 20.0     64.0     5.0   37.0                               328 5 20     64     5   37                        
1705946 OR     school 4107230 1923   Lake Oswego SD 7J 410723000066 59 Lake Oswego Middle School   Regular School No Middle 06 08 2017   k_12_total 665.0 10.0 70.0     113.0     1.0   51.0                               665 10 70     113     1   51                        
1705947 OR     school 4107230 1923   Lake Oswego SD 7J   1923 Lake Oswego SD 7J             2017   k_12_total 40.0 0.0 6.0     1.0     0.0   7.0                               40 0 6     1     0   7                        
1705948 OR     school 4107230 1923   Lake Oswego SD 7J 410723000068 61 Lake Oswego Senior High School   Regular School No High 09 12 2017   k_12_total 969.0 12.0 71.0     163.0     3.0   92.0                               969 12 71     163     3   92                        
1705949 OR     school 4107230 1923   Lake Oswego SD 7J 410723000069 62 Lakeridge High School   Regular School No High 09 12 2017   k_12_total 886.0 10.0 62.0     73.0     1.0   82.0                               886 10 62     73     1   82                        
1705950 OR     school 4107230 1923   Lake Oswego SD 7J 410723000067 60 Lakeridge Middle School   Regular School No Middle 06 08 2017   k_12_total 662.0 4.0 54.0     47.0     3.0   69.0                               662 4 54     47     3   69                        
1705951 OR     school 4107230 1923   Lake Oswego SD 7J 410723001378 1288 Oak Creek Elementary School   Regular School No Elementary 01 05 2017   k_12_total 281.0 3.0 36.0     104.0     1.0   52.0                               281 3 36     104     1   52                        
1705952 OR     school 4107230 1923   Lake Oswego SD 7J 410723000064 56 River Grove Elementary School   Regular School No Elementary KG 05 2017   k_12_total 386.0 2.0 50.0     48.0     4.0   48.0                               386 2 50     48     4   48                        
1705953 OR     school 4107230 1923   Lake Oswego SD 7J 410723001307 58 Westridge Elementary School   Regular School No Elementary KG 05 2017   k_12_total 392.0 3.0 23.0     30.0     3.0   22.0                               392 3 23     30     3   22                        
1706103 OR     school 4108830 1924   North Clackamas SD 12 410883004189 3530 Alder Creek Middle School   Regular School No Middle 06 08 2017   k_12_total 619.0 13.0 233.0     28.0     5.0   63.0                               619 13 233     28     5   63                        
1706104 OR     school 4108830 1924   North Clackamas SD 12 410883000070 4762 Ardenwald Elementary School   Regular School No Elementary KG 05 2017   k_12_total 302.0 3.0 94.0     7.0     2.0   32.0                               302 3 94     7     2   32                        
1706105 OR     school 4108830 1924   North Clackamas SD 12 410883000072 65 Bilquist Elementary School   Regular School No Elementary KG 05 2017   k_12_total 291.0 5.0 101.0     15.0     1.0   34.0                               291 5 101     15     1   34                        
1706106 OR     school 4108830 1924   North Clackamas SD 12 410883001658 4475 Cascade Heights Public Charter School   Regular School Yes Elementary KG 08 2017   k_12_total 161.0 1.0 8.0     26.0     0.0   18.0                               161 1 8     26     0   18                        
1706107 OR     school 4108830 1924   North Clackamas SD 12 410883000093 85 Clackamas High School   Regular School No High 09 12 2017   k_12_total 1577.0 34.0 277.0     408.0     7.0   188.0                               1577 34 277     408     7   188                        
1706108 OR     school 4108830 1924   North Clackamas SD 12 410883001544 4226 Clackamas Middle College   Regular School Yes High 09 12 2017   k_12_total 229.0 10.0 29.0     12.0     2.0   17.0                               229 10 29     12     2   17                        
1706109 OR     school 4108830 1924   North Clackamas SD 12 410883001543 4223 Clackamas Web Academy   Regular School Yes Other 01 12 2017   k_12_total 384.0 8.0 36.0     9.0     2.0   22.0                               384 8 36     9     2   22                        
1706110 OR     school 4108830 1924   North Clackamas SD 12 410883001584 4005 El Puente   Regular School No Elementary KG 05 2017   k_12_total 74.0 2.0 165.0     2.0     0.0   10.0                               74 2 165     2     0   10                        
1706111 OR     school 4108830 1924   North Clackamas SD 12 410883000076 4763 Happy Valley Elementary School   Regular School No Elementary KG 05 2017   k_12_total 337.0 6.0 24.0     55.0     1.0   36.0                               337 6 24     55     1   36                        
1706112 OR     school 4108830 1924   North Clackamas SD 12 410883001782 4715 Happy Valley Middle School   Regular School No Middle 06 08 2017   k_12_total 711.0 18.0 88.0     177.0     6.0   89.0                               711 18 88     177     6   89                        
1706113 OR     school 4108830 1924   North Clackamas SD 12 410883000085 4764 Lewelling Elementary School   Regular School No Elementary KG 05 2017   k_12_total 211.0 12.0 88.0     8.0     8.0   24.0                               211 12 88     8     8   24                        
1706114 OR     school 4108830 1924   North Clackamas SD 12 410883000079 4765 Linwood Elementary School   Regular School No Elementary KG 05 2017   k_12_total 174.0 16.0 81.0     10.0     11.0   22.0                               174 16 81     10     11   22                        
1706115 OR     school 4108830 1924   North Clackamas SD 12 410883001686 4369 Milwaukie Academy of the Arts   Regular School Yes High 09 12 2017   k_12_total 231.0 6.0 47.0     6.0     1.0   27.0                               231 6 47     6     1   27                        
1706116 OR     school 4108830 1924   North Clackamas SD 12 410883000081 73 Milwaukie Elementary School   Regular School No Elementary KG 05 2017   k_12_total 123.0 3.0 19.0     1.0     0.0   21.0                               123 3 19     1     0   21                        
1706117 OR     school 4108830 1924   North Clackamas SD 12 410883000094 86 Milwaukie High School   Regular School No High 09 12 2017   k_12_total 533.0 34.0 293.0     32.0     16.0   59.0                               533 34 293     32     16   59                        
1706118 OR     school 4108830 1924   North Clackamas SD 12 410883001354 1264 Mount Scott Elementary School   Regular School No Elementary KG 05 2017   k_12_total 238.0 4.0 42.0     51.0     8.0   23.0                               238 4 42     51     8   23                        
1706119 OR     school 4108830 1924   North Clackamas SD 12 410883001583 4004 New Urban High School   Regular School No High 09 12 2017   k_12_total 106.0 4.0 21.0     0.0     0.0   7.0                               106 4 21     0     0   7                        
1706120 OR     school 4108830 1924   North Clackamas SD 12   1924 North Clackamas SD 12             2017   k_12_total 69.0 2.0 22.0     5.0     0.0   4.0                               69 2 22     5     0   4                        
1706121 OR     school 4108830 1924   North Clackamas SD 12 410883001484 3342 Oak Grove Elementary   Regular School No Elementary KG 05 2017   k_12_total 275.0 5.0 78.0     5.0     1.0   34.0                               275 5 78     5     1   34                        
1706122 OR     school 4108830 1924   North Clackamas SD 12 410883000008 4766 Oregon Trail Elementary School   Regular School No Elementary KG 05 2017   k_12_total 348.0 6.0 57.0     54.0     3.0   32.0                               348 6 57     54     3   32                        
1706123 OR     school 4108830 1924   North Clackamas SD 12 410883000095 87 Putnam High School   Regular School No High 09 12 2017   k_12_total 784.0 16.0 228.0     25.0     3.0   76.0                               784 16 228     25     3   76                        
1706124 OR     school 4108830 1924   North Clackamas SD 12 410883000084 76 Riverside Elementary School   Regular School No Elementary KG 05 2017   k_12_total 268.0 5.0 141.0     0.0     1.0   22.0                               268 5 141     0     1   22                        
1706125 OR     school 4108830 1924   North Clackamas SD 12 410883001379 4767 Rock Creek Middle School   Regular School No Middle 06 08 2017   k_12_total 556.0 18.0 138.0     95.0     6.0   62.0                               556 18 138     95     6   62                        
1706126 OR     school 4108830 1924   North Clackamas SD 12 410883000092 84 Rowe Middle School   Regular School No Middle 06 08 2017   k_12_total 468.0 13.0 239.0     12.0     8.0   62.0                               468 13 239     12     8   62                        
1706127 OR     school 4108830 1924   North Clackamas SD 12 410883001775 4713 Scouters Mountain Elementary   Regular School No Elementary KG 05 2017   k_12_total 323.0 11.0 45.0     120.0     0.0   32.0                               323 11 45     120     0   32                        
1706128 OR     school 4108830 1924   North Clackamas SD 12 410883001317 2733 Sojourner School   Regular School No Elementary KG 05 2017   k_12_total 129.0 0.0 14.0     0.0     1.0   15.0                               129 0 14     0     1   15                        
1706129 OR     school 4108830 1924   North Clackamas SD 12 410883001483 3198 Spring Mountain Elementary School   Regular School No Elementary KG 05 2017   k_12_total 349.0 10.0 42.0     69.0     2.0   60.0                               349 10 42     69     2   60                        
1706130 OR     school 4108830 1924   North Clackamas SD 12 410883000086 78 Sunnyside Elementary School   Regular School No Elementary KG 05 2017   k_12_total 332.0 21.0 89.0     69.0     2.0   44.0                               332 21 89     69     2   44                        
1706131 OR     school 4108830 1924   North Clackamas SD 12 410883001777 4714 Verne A Duncan Elementary School   Regular School No Elementary KG 05 2017   k_12_total 420.0 6.0 103.0     15.0     1.0   30.0                               420 6 103     15     1   30                        
1706132 OR     school 4108830 1924   North Clackamas SD 12 410883000087 79 View Acres Elementary School   Regular School No Elementary KG 05 2017   k_12_total 325.0 2.0 47.0     14.0     3.0   39.0                               325 2 47     14     3   39                        
1706133 OR     school 4108830 1924   North Clackamas SD 12 410883000080 72 Whitcomb Elementary School   Regular School No Elementary KG 05 2017   k_12_total 195.0 8.0 204.0     11.0     2.0   26.0                               195 8 204     11     2   26                        

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