enrollments

Data source: Big Local News · About: Big Local

1,459 rows where grade = "k_12_total", state = "OR" and year = 2020 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,459 ✖

grade ✖

  • k_12_total · 1,459 ✖
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
916666 916666 OR     school 4101710 1894   Baker SD 5J 410171001783 4759 Baker Early College   Regular School Yes High 09 12 2020   k_12_total 271 3 13   0 12     0   19                               271 3 13   0 12     0   19                        
916667 916667 OR     school 4101710 1894   Baker SD 5J 410171000009 8 Baker High School   Regular School No High 09 12 2020   k_12_total 357 1 54   3 5     1   19                               357 1 54   3 5     1   19                        
916668 916668 OR     school 4101710 1894   Baker SD 5J 410171000001 1 Baker Middle School   Regular School No Middle 07 08 2020   k_12_total 206 0 39   8 0     0   19                               206 0 39   8 0     0   19                        
916669 916669 OR     school 4101710 1894   Baker SD 5J   1894 Baker SD 5J             2020   k_12_total 2 0 0   0 0     0   0                               2 0 0   0 0     0   0                        
916670 916670 OR     school 4101710 1894   Baker SD 5J 410171001767 4728 Baker Web Academy   Regular School Yes Other KG 12 2020   k_12_total 1620 24 244   23 20     7   108                               1620 24 244   23 20     7   108                        
916671 916671 OR     school 4101710 1894   Baker SD 5J 410171000002 2 Brooklyn Primary School   Regular School No Elementary KG 03 2020   k_12_total 366 0 33   2 3     0   22                               366 0 33   2 3     0   22                        
916672 916672 OR     school 4101710 1894   Baker SD 5J 410171001516 3493 EAGLE CAP Innovative HS   Alternative School No High 07 12 2020   k_12_total 30 0 4   0 0     0   4                               30 0 4   0 0     0   4                        
916673 916673 OR     school 4101710 1894   Baker SD 5J 410171000030 4 Haines Elementary School   Regular School No Elementary KG 06 2020   k_12_total 126 0 16   1 2     0   6                               126 0 16   1 2     0   6                        
916674 916674 OR     school 4101710 1894   Baker SD 5J 410171000034 5 Keating Elementary School   Regular School No Elementary KG 06 2020   k_12_total 24 0 3   0 0     0   1                               24 0 3   0 0     0   1                        
916675 916675 OR     school 4101710 1894   Baker SD 5J 410171000007 7 South Baker Intermediate School   Regular School No Middle 04 06 2020   k_12_total 309 1 37   5 0     1   15                               309 1 37   5 0     1   15                        
917211 917211 OR     school 4106600 1895   Huntington SD 16J 410660000011 3351 Huntington School   Regular School Yes Other KG 12 2020   k_12_total 76 0 5   0 6     0   5                               76 0 5   0 6     0   5                        
916805 916805 OR     school 4101740 1896   Burnt River SD 30J 410174000013 3347 Burnt River School   Regular School Yes Other KG 12 2020   k_12_total 33 1 1   0 6     0   1                               33 1 1   0 6     0   1                        
917609 917609 OR     school 4109720 1897   Pine Eagle SD 61 410972000016 15 Pine Eagle Charter School   Regular School Yes Other KG 12 2020   k_12_total 201 1 20   0 0     1   4                               201 1 20   0 0     1   4                        
917400 917400 OR     school 4108430 1898   Monroe SD 1J 410843000027 1321 Monroe Grade School   Regular School No Elementary KG 08 2020   k_12_total 159 0 68   1 2     0   7                               159 0 68   1 2     0   7                        
917401 917401 OR     school 4108430 1898   Monroe SD 1J 410843000050 43 Monroe High School   Regular School No High 09 12 2020   k_12_total 82 0 25   0 0     0   5                               82 0 25   0 0     0   5                        
916641 916641 OR     school 4101200 1899   Alsea SD 7J 410120000019 17 Alsea Charter School   Regular School Yes Other KG 12 2020   k_12_total 253 2 28   5 18     0   15                               253 2 28   5 18     0   15                        
917593 917593 OR     school 4109600 1900   Philomath SD 17J 410960000020 18 Blodgett Elementary School   Regular School No Elementary KG 04 2020   k_12_total 17 2 1   1 0     0   1                               17 2 1   1 0     0   1                        
917594 917594 OR     school 4109600 1900   Philomath SD 17J 410960001481 3162 Clemens Primary School   Regular School No Elementary KG 01 2020   k_12_total 144 0 15   1 2     1   6                               144 0 15   1 2     1   6                        
917595 917595 OR     school 4109600 1900   Philomath SD 17J 410960000021 3440 Kings Valley Charter School   Regular School Yes Other KG 12 2020   k_12_total 174 1 14   3 2     1   10                               174 1 14   3 2     1   10                        
917596 917596 OR     school 4109600 1900   Philomath SD 17J 410960000022 20 Philomath Elementary School   Regular School No Elementary 02 05 2020   k_12_total 323 1 37   1 0     1   23                               323 1 37   1 0     1   23                        
917597 917597 OR     school 4109600 1900   Philomath SD 17J 410960000024 22 Philomath High School   Regular School No High 09 12 2020   k_12_total 411 0 47   4 7     0   32                               411 0 47   4 7     0   32                        
917598 917598 OR     school 4109600 1900   Philomath SD 17J 410960000023 21 Philomath Middle School   Regular School No Middle 06 08 2020   k_12_total 305 0 39   1 4     0   24                               305 0 39   1 4     0   24                        
916880 916880 OR     school 4103480 1901   Corvallis SD 509J 410348000032 27 Adams Elementary School   Regular School No Elementary KG 05 2020   k_12_total 311 5 37   2 32     0   43                               311 5 37   2 32     0   43                        
916881 916881 OR     school 4103480 1901   Corvallis SD 509J 410348000033 28 Cheldelin Middle School   Regular School No Middle 06 08 2020   k_12_total 458 8 62   1 33     4   49                               458 8 62   1 33     4   49                        
916882 916882 OR     school 4103480 1901   Corvallis SD 509J 410348000047 40 Corvallis High School   Regular School No High 09 12 2020   k_12_total 775 10 270   9 51     4   94                               775 10 270   9 51     4   94                        
916883 916883 OR     school 4103480 1901   Corvallis SD 509J   1901 Corvallis SD 509J             2020   k_12_total 45 1 12   1 4     0   5                               45 1 12   1 4     0   5                        
916884 916884 OR     school 4103480 1901   Corvallis SD 509J 410348000048 41 Crescent Valley High School   Regular School No High 09 12 2020   k_12_total 674 6 86   5 77     6   81                               674 6 86   5 77     6   81                        
916885 916885 OR     school 4103480 1901   Corvallis SD 509J 410348000570 1322 Franklin School   Regular School No Elementary KG 08 2020   k_12_total 216 5 34   1 37     2   22                               216 5 34   1 37     2   22                        
916886 916886 OR     school 4103480 1901   Corvallis SD 509J 410348000037 30 Garfield Elementary School   Regular School No Elementary KG 05 2020   k_12_total 182 7 208   8 10     0   30                               182 7 208   8 10     0   30                        
916887 916887 OR     school 4103480 1901   Corvallis SD 509J 410348000040 33 Hoover Elementary School   Regular School No Elementary KG 05 2020   k_12_total 222 2 37   0 80     5   36                               222 2 37   0 80     5   36                        
916888 916888 OR     school 4103480 1901   Corvallis SD 509J 410348001743 4637 Inavale Community Partners dba Muddy Creek Charter School   Regular School Yes Elementary KG 05 2020   k_12_total 99 3 13   0 0     0   6                               99 3 13   0 0     0   6                        
916889 916889 OR     school 4103480 1901   Corvallis SD 509J 410348000042 35 Jefferson Elementary School   Regular School No Elementary KG 05 2020   k_12_total 257 6 22   4 11     0   28                               257 6 22   4 11     0   28                        
916890 916890 OR     school 4103480 1901   Corvallis SD 509J 410348000043 36 Lincoln Elementary School   Regular School No Elementary KG 05 2020   k_12_total 231 4 109   5 1     1   25                               231 4 109   5 1     1   25                        
916891 916891 OR     school 4103480 1901   Corvallis SD 509J 410348000045 38 Linus Pauling Middle School   Regular School No Middle 06 08 2020   k_12_total 498 11 190   11 25     2   55                               498 11 190   11 25     2   55                        
916892 916892 OR     school 4103480 1901   Corvallis SD 509J 410348000044 37 Mt View Elementary School   Regular School No Elementary KG 05 2020   k_12_total 241 3 18   0 2     5   25                               241 3 18   0 2     5   25                        
916893 916893 OR     school 4103480 1901   Corvallis SD 509J 410348000046 39 Wilson Elementary School   Regular School No Elementary KG 05 2020   k_12_total 280 11 58   5 22     6   30                               280 11 58   5 22     6   30                        
916894 916894 OR     school 4103480 1901   Corvallis SD 509J   1874 YES House Alternative School             2020   k_12_total 12 0 5   0 0     0   0                               12 0 5   0 0     0   0                        
916856 916856 OR     school   1902   Clackamas ESD   1902 Clackamas ESD             2020   k_12_total 162 6 28   1 3     0   10                               162 6 28   1 3     0   10                        
918049 918049 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001786 4773 Arts and Technology High School   Alternative School No High 09 12 2020   k_12_total 55 0 18   0 0     1   5                               55 0 18   0 0     1   5                        
918050 918050 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000056 1287 Athey Creek Middle School   Regular School No Middle 06 08 2020   k_12_total 541 6 50   2 27     2   57                               541 6 50   2 27     2   57                        
918051 918051 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001356 1272 Boeckman Creek Primary School   Regular School No Elementary PK 05 2020   k_12_total 377 4 96   0 22     5   40                               377 4 96   0 22     5   40                        
918052 918052 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001447 3455 Bolton Primary School   Regular School No Elementary PK 05 2020   k_12_total 284 3 14   0 11     0   22                               284 3 14   0 11     0   22                        
918053 918053 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001575 3913 Boones Ferry Primary School   Regular School No Elementary PK 05 2020   k_12_total 412 4 112   1 16     10   50                               412 4 112   1 16     10   50                        
918054 918054 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000053 45 Cedaroak Park Primary School   Regular School No Elementary PK 05 2020   k_12_total 226 2 13   0 7     0   29                               226 2 13   0 7     0   29                        
918055 918055 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001318 46 Inza R Wood Middle School   Regular School No Middle 06 08 2020   k_12_total 333 4 135   4 20     2   40                               333 4 135   4 20     2   40                        
918056 918056 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001822 5056 Lowrie Primary School   Regular School No Elementary PK 05 2020   k_12_total 319 3 136   1 28     0   45                               319 3 136   1 28     0   45                        
918057 918057 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001851 5377 Meridian Creek Middle School   Regular School No Middle 06 08 2020   k_12_total 295 3 65   2 19     3   28                               295 3 65   2 19     3   28                        
918058 918058 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001414 2787 Rosemont Ridge Middle School   Regular School No Middle 06 08 2020   k_12_total 578 7 49   4 37     0   68                               578 7 49   4 37     0   68                        
918059 918059 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000054 47 Stafford Primary School   Regular School No Elementary PK 05 2020   k_12_total 376 0 13   0 18     0   30                               376 0 13   0 18     0   30                        
918060 918060 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000055 48 Sunset Primary School   Regular School No Elementary PK 05 2020   k_12_total 296 2 29   0 13     2   49                               296 2 29   0 13     2   49                        
918061 918061 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001437 3452 Three Rivers Charter School   Regular School Yes Middle 04 08 2020   k_12_total 63 0 5   0 27     0   13                               63 0 5   0 27     0   13                        
918062 918062 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001825 5057 Trillium Creek Primary School   Regular School No Elementary PK 05 2020   k_12_total 422 3 28   0 25     0   67                               422 3 28   0 25     0   67                        
918063 918063 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000058 51 West Linn High School   Regular School No High 09 12 2020   k_12_total 1503 22 102   4 101     5   140                               1503 22 102   4 101     5   140                        
918064 918064 OR     school 4113170 1922   West Linn-Wilsonville SD 3J   1922 West Linn-Wilsonville SD 3J             2020   k_12_total 4 0 0   0 0     0   3                               4 0 0   0 0     0   3                        
918065 918065 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001377 1286 Willamette Primary School   Regular School No Elementary PK 05 2020   k_12_total 391 4 29   0 8     2   44                               391 4 29   0 8     2   44                        
918066 918066 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000574 1323 Wilsonville High School   Regular School No High 09 12 2020   k_12_total 818 11 224   6 54     9   85                               818 11 224   6 54     9   85                        
917291 917291 OR     school 4107230 1923   Lake Oswego SD 7J 410723000060 53 Forest Hills Elementary School   Regular School No Elementary KG 05 2020   k_12_total 331 1 19   2 28     0   51                               331 1 19   2 28     0   51                        
917292 917292 OR     school 4107230 1923   Lake Oswego SD 7J 410723001308 54 Hallinan Elementary School   Regular School No Elementary KG 05 2020   k_12_total 322 1 34   0 25     1   39                               322 1 34   0 25     1   39                        
917293 917293 OR     school 4107230 1923   Lake Oswego SD 7J 410723001873 5455 Harmony Academy   Regular School Yes High 09 12 2020   k_12_total 13 0 1   0 0     0   0                               13 0 1   0 0     0   0                        
917294 917294 OR     school 4107230 1923   Lake Oswego SD 7J 410723000061 55 Lake Grove Elementary School   Regular School No Elementary KG 05 2020   k_12_total 272 2 19   1 62     2   48                               272 2 19   1 62     2   48                        
917295 917295 OR     school 4107230 1923   Lake Oswego SD 7J 410723000066 59 Lake Oswego Middle School   Regular School No Middle 06 08 2020   k_12_total 606 4 61   2 117     2   69                               606 4 61   2 117     2   69                        
917296 917296 OR     school 4107230 1923   Lake Oswego SD 7J   1923 Lake Oswego SD 7J             2020   k_12_total 34 0 7   0 4     0   6                               34 0 7   0 4     0   6                        
917297 917297 OR     school 4107230 1923   Lake Oswego SD 7J 410723000068 61 Lake Oswego Senior High School   Regular School No High 09 12 2020   k_12_total 899 7 103   4 155     2   89                               899 7 103   4 155     2   89                        
917298 917298 OR     school 4107230 1923   Lake Oswego SD 7J 410723000069 62 Lakeridge High School   Regular School No High 09 12 2020   k_12_total 930 9 84   2 83     2   111                               930 9 84   2 83     2   111                        
917299 917299 OR     school 4107230 1923   Lake Oswego SD 7J 410723000067 60 Lakeridge Middle School   Regular School No Middle 06 08 2020   k_12_total 623 5 65   1 52     0   81                               623 5 65   1 52     0   81                        
917300 917300 OR     school 4107230 1923   Lake Oswego SD 7J 410723001378 1288 Oak Creek Elementary School   Regular School No Elementary KG 05 2020   k_12_total 303 5 43   2 141     6   69                               303 5 43   2 141     6   69                        
917301 917301 OR     school 4107230 1923   Lake Oswego SD 7J 410723000064 56 River Grove Elementary School   Regular School No Elementary KG 05 2020   k_12_total 375 5 50   0 67     3   66                               375 5 50   0 67     3   66                        
917302 917302 OR     school 4107230 1923   Lake Oswego SD 7J 410723001307 58 Westridge Elementary School   Regular School No Elementary KG 05 2020   k_12_total 375 2 30   0 18     0   35                               375 2 30   0 18     0   35                        
917450 917450 OR     school 4108830 1924   North Clackamas SD 12 410883004189 3530 Alder Creek Middle School   Regular School No Middle 06 08 2020   k_12_total 608 18 252   7 20     5   75                               608 18 252   7 20     5   75                        
917451 917451 OR     school 4108830 1924   North Clackamas SD 12 410883000070 4762 Ardenwald Elementary School   Regular School No Elementary KG 05 2020   k_12_total 298 9 60   3 6     1   40                               298 9 60   3 6     1   40                        
917452 917452 OR     school 4108830 1924   North Clackamas SD 12 410883001874 5451 Beatrice Morrow Cannady Elementary   Regular School No Elementary KG 05 2020   k_12_total 249 4 30   0 92     1   56                               249 4 30   0 92     1   56                        
917453 917453 OR     school 4108830 1924   North Clackamas SD 12 410883000072 65 Bilquist Elementary School   Regular School No Elementary KG 05 2020   k_12_total 246 14 75   1 18     4   36                               246 14 75   1 18     4   36                        
917454 917454 OR     school 4108830 1924   North Clackamas SD 12 410883001658 4475 Cascade Heights Public Charter School   Regular School Yes Elementary KG 08 2020   k_12_total 171 0 16   1 21     0   14                               171 0 16   1 21     0   14                        
917455 917455 OR     school 4108830 1924   North Clackamas SD 12 410883000093 85 Clackamas High School   Regular School No High 09 12 2020   k_12_total 1501 43 344   3 436     12   212                               1501 43 344   3 436     12   212                        
917456 917456 OR     school 4108830 1924   North Clackamas SD 12 410883001544 4226 Clackamas Middle College   Regular School Yes High 09 12 2020   k_12_total 212 6 43   1 10     0   24                               212 6 43   1 10     0   24                        
917457 917457 OR     school 4108830 1924   North Clackamas SD 12 410883001543 4223 Clackamas Web Academy   Regular School Yes Other KG 12 2020   k_12_total 368 5 40   2 9     4   25                               368 5 40   2 9     4   25                        
917458 917458 OR     school 4108830 1924   North Clackamas SD 12 410883001584 4005 El Puente   Regular School No Elementary KG 05 2020   k_12_total 89 2 204   0 2     0   11                               89 2 204   0 2     0   11                        
917459 917459 OR     school 4108830 1924   North Clackamas SD 12 410883000076 4763 Happy Valley Elementary School   Regular School No Elementary KG 05 2020   k_12_total 309 10 30   1 76     1   37                               309 10 30   1 76     1   37                        
917460 917460 OR     school 4108830 1924   North Clackamas SD 12 410883001782 4715 Happy Valley Middle School   Regular School No Middle 06 08 2020   k_12_total 703 14 110   4 253     7   104                               703 14 110   4 253     7   104                        
917461 917461 OR     school 4108830 1924   North Clackamas SD 12 410883000085 4764 Lewelling Elementary School   Regular School No Elementary KG 05 2020   k_12_total 180 5 91   4 7     0   31                               180 5 91   4 7     0   31                        
917462 917462 OR     school 4108830 1924   North Clackamas SD 12 410883000079 4765 Linwood Elementary School   Regular School No Elementary KG 05 2020   k_12_total 158 9 65   0 7     18   23                               158 9 65   0 7     18   23                        
917463 917463 OR     school 4108830 1924   North Clackamas SD 12 410883001686 4369 Milwaukie Academy of the Arts   Regular School Yes High 09 12 2020   k_12_total 215 2 44   1 3     2   27                               215 2 44   1 3     2   27                        
917464 917464 OR     school 4108830 1924   North Clackamas SD 12 410883000081 73 Milwaukie Elementary School   Regular School No Elementary KG 05 2020   k_12_total 111 4 20   1 6     0   16                               111 4 20   1 6     0   16                        
917465 917465 OR     school 4108830 1924   North Clackamas SD 12 410883000094 86 Milwaukie High School   Regular School No High 09 12 2020   k_12_total 413 29 275   3 15     12   62                               413 29 275   3 15     12   62                        
917466 917466 OR     school 4108830 1924   North Clackamas SD 12 410883001354 1264 Mount Scott Elementary School   Regular School No Elementary KG 05 2020   k_12_total 207 8 47   3 63     6   42                               207 8 47   3 63     6   42                        
917467 917467 OR     school 4108830 1924   North Clackamas SD 12 410883001583 4004 New Urban High School   Regular School No High 09 12 2020   k_12_total 85 1 22   3 0     0   9                               85 1 22   3 0     0   9                        
917468 917468 OR     school 4108830 1924   North Clackamas SD 12   1924 North Clackamas SD 12             2020   k_12_total 37 3 7   1 1     0   0                               37 3 7   1 1     0   0                        
917469 917469 OR     school 4108830 1924   North Clackamas SD 12 410883001484 3342 Oak Grove Elementary   Regular School No Elementary KG 05 2020   k_12_total 224 6 54   1 4     0   40                               224 6 54   1 4     0   40                        
917470 917470 OR     school 4108830 1924   North Clackamas SD 12 410883000008 4766 Oregon Trail Elementary School   Regular School No Elementary KG 05 2020   k_12_total 309 8 59   3 97     5   48                               309 8 59   3 97     5   48                        
917471 917471 OR     school 4108830 1924   North Clackamas SD 12 410883000095 87 Putnam High School   Regular School No High 09 12 2020   k_12_total 753 18 272   6 36     5   106                               753 18 272   6 36     5   106                        
917472 917472 OR     school 4108830 1924   North Clackamas SD 12 410883000084 76 Riverside Elementary School   Regular School No Elementary KG 05 2020   k_12_total 246 2 126   2 2     1   15                               246 2 126   2 2     1   15                        
917473 917473 OR     school 4108830 1924   North Clackamas SD 12 410883001379 4767 Rock Creek Middle School   Regular School No Middle 06 08 2020   k_12_total 546 24 174   1 99     1   64                               546 24 174   1 99     1   64                        
917474 917474 OR     school 4108830 1924   North Clackamas SD 12 410883000092 84 Rowe Middle School   Regular School No Middle 06 08 2020   k_12_total 440 28 260   4 19     11   72                               440 28 260   4 19     11   72                        
917475 917475 OR     school 4108830 1924   North Clackamas SD 12 410883001775 4713 Scouters Mountain Elementary   Regular School No Elementary KG 05 2020   k_12_total 185 7 31   0 70     3   32                               185 7 31   0 70     3   32                        
917476 917476 OR     school 4108830 1924   North Clackamas SD 12 410883001317 2733 Sojourner School   Regular School No Elementary KG 05 2020   k_12_total 131 0 12   0 2     1   13                               131 0 12   0 2     1   13                        
917477 917477 OR     school 4108830 1924   North Clackamas SD 12 410883001483 3198 Spring Mountain Elementary School   Regular School No Elementary KG 05 2020   k_12_total 288 8 43   2 80     5   58                               288 8 43   2 80     5   58                        
917478 917478 OR     school 4108830 1924   North Clackamas SD 12 410883000086 78 Sunnyside Elementary School   Regular School No Elementary KG 05 2020   k_12_total 319 15 91   1 79     5   59                               319 15 91   1 79     5   59                        
917479 917479 OR     school 4108830 1924   North Clackamas SD 12 410883001777 4714 Verne A Duncan Elementary School   Regular School No Elementary KG 05 2020   k_12_total 367 8 105   0 14     2   45                               367 8 105   0 14     2   45                        
917480 917480 OR     school 4108830 1924   North Clackamas SD 12 410883000087 79 View Acres Elementary School   Regular School No Elementary KG 05 2020   k_12_total 326 5 52   0 6     1   33                               326 5 52   0 6     1   33                        
917481 917481 OR     school 4108830 1924   North Clackamas SD 12 410883000080 72 Whitcomb Elementary School   Regular School No Elementary KG 05 2020   k_12_total 167 11 161   3 14     2   25                               167 11 161   3 14     2   25                        

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