Data source: Big Local News · About: Big Local

5,859 rows where grade = "k_12_total" and state = "OR" sorted by ccd_school_low_grade descending

View and edit SQL

year

grade

  • k_12_total · 5,859
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
656805 OR     school 4101660 2208   Athena-Weston SD 29RJ 410166001112 1053 Athena Elementary School   Regular School No Elementary PK 03 2021   k_12_total 91 0 14   3 0     0   11                               91 0 14   3 0     0   11                        
656828 OR     school 4101920 2243   Beaverton SD 48J 410192001204 1153 Aloha-Huber Park School   Regular School No Elementary PK 08 2021   k_12_total 187 42 493   3 50     2   45                               187 42 493   3 50     2   45                        
656831 OR     school 4101920 2243   Beaverton SD 48J 410192001205 1154 Barnes Elementary School   Regular School No Elementary PK 05 2021   k_12_total 119 25 334   0 12     5   20                               119 25 334   0 12     5   20                        
656837 OR     school 4101920 2243   Beaverton SD 48J 410192001753 4671 Bonny Slope Elementary School   Regular School No Elementary PK 05 2021   k_12_total 311 7 54   1 146     1   53                               311 7 54   1 146     1   53                        
656850 OR     school 4101920 2243   Beaverton SD 48J 410192001289 1157 Greenway Elementary School   Regular School No Elementary PK 05 2021   k_12_total 137 13 124   0 8     4   22                               137 13 124   0 8     4   22                        
656858 OR     school 4101920 2243   Beaverton SD 48J 410192001219 1168 McKay Elementary School   Regular School No Elementary PK 05 2021   k_12_total 136 10 93   0 14     6   25                               136 10 93   0 14     6   25                        
656881 OR     school 4101920 2243   Beaverton SD 48J 410192001230 1177 Vose Elementary School   Regular School No Elementary PK 05 2021   k_12_total 170 14 447   0 14     6   40                               170 14 447   0 14     6   40                        
656885 OR     school 4101920 2243   Beaverton SD 48J 410192001232 1179 William Walker Elementary School   Regular School No Elementary PK 05 2021   k_12_total 96 10 320   1 18     4   25                               96 10 320   1 18     4   25                        
656952 OR     school 4102610 1995   Camas Valley SD 21J 410261000315 3400 Camas Valley School   Regular School Yes Other PK 12 2021   k_12_total 187 0 14   1 0     0   24                               187 0 14   1 0     0   24                        
657024 OR     school 4103390 1964   Coquille SD 8 410339000200 189 Lincoln School of Early Learning   Regular School No Elementary PK 01 2021   k_12_total 114 1 18   2 0     0   16                               114 1 18   2 0     0   16                        
657076 OR     school 4103940 2187   David Douglas SD 40 410394001025 972 Cherry Park Elementary School   Regular School No Elementary PK 05 2021   k_12_total 153 50 109   2 52     9   46                               153 50 109   2 52     9   46                        
657079 OR     school 4103940 2187   David Douglas SD 40 410394004180 3525 Earl Boyles Elementary   Regular School No Elementary PK 05 2021   k_12_total 135 23 120   4 50     6   39                               135 23 120   4 50     6   39                        
657083 OR     school 4103940 2187   David Douglas SD 40 410394001031 975 Lincoln Park Elementary School   Regular School No Elementary PK 05 2021   k_12_total 171 54 142   2 98     9   21                               171 54 142   2 98     9   21                        
657085 OR     school 4103940 2187   David Douglas SD 40 410394001033 977 Mill Park Elementary School   Regular School No Elementary PK 05 2021   k_12_total 115 92 155   7 75     11   17                               115 92 155   7 75     11   17                        
657094 OR     school 4104020 2011   Dayville SD 16J 410402000358 3353 Dayville School   Regular School No Other PK 12 2021   k_12_total 52 0 2   0 0     0   3                               52 0 2   0 0     0   3                        
657099 OR     school 4110710 1991   Douglas County SD 4 411071000288 269 Eastwood Elementary School   Regular School No Elementary PK 05 2021   k_12_total 289 0 52   3 1     0   25                               289 0 52   3 1     0   25                        
657102 OR     school 4110710 1991   Douglas County SD 4 411071000291 272 Green Elementary School   Regular School No Elementary PK 05 2021   k_12_total 223 3 31   0 1     0   17                               223 3 31   0 1     0   17                        
657112 OR     school 4110710 1991   Douglas County SD 4 411071000297 277 Winchester Elementary   Regular School No Elementary PK 05 2021   k_12_total 254 0 36   6 5     0   19                               254 0 36   6 5     0   19                        
657128 OR     school 4104530 2203   Echo SD 5 410453001089 3433 Echo School   Regular School No Other PK 12 2021   k_12_total 234 2 40   2 1     0   11                               234 2 40   2 1     0   11                        
657130 OR     school 4104590 2217   Elgin SD 23 410459001140 1082 Stella Mayfield Elementary School   Regular School No Elementary PK 06 2021   k_12_total 207 0 9   2 0     1   5                               207 0 9   2 0     1   5                        
657201 OR     school 4105160 2241   Forest Grove SD 15 410516001182 1128 Cornelius Elementary School   Regular School No Elementary PK 04 2021   k_12_total 39 1 314   1 1     0   1                               39 1 314   1 1     0   1                        
657204 OR     school 4105160 2241   Forest Grove SD 15 410516001184 1130 Echo Shaw Elementary School   Regular School No Elementary PK 06 2021   k_12_total 11 0 395   3 0     0   0                               11 0 395   3 0     0   0                        
657205 OR     school 4105160 2241   Forest Grove SD 15 410516001578 3986 Fern Hill Elementary School   Regular School No Elementary PK 04 2021   k_12_total 55 1 151   1 6     1   11                               55 1 151   1 6     1   11                        
657225 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2021   k_12_total 86 0 18   2 2     1   13                               86 0 18   2 2     1   13                        
657342 OR     school 4100023 2239   Hillsboro SD 1J 410002301200 1149 Reedville Elementary School   Regular School No Elementary PK 06 2021   k_12_total 32 5 171   1 9     0   8                               32 5 171   1 9     0   8                        
657376 OR     school 4106750 1934   Jewell SD 8 410675000158 3352 Jewell School   Regular School No Other PK 12 2021   k_12_total 89 0 15   0 0     0   8                               89 0 15   0 0     0   8                        
657486 OR     school 4107530 2012   Long Creek SD 17 410753000360 3366 Long Creek School   Regular School No Other PK 12 2021   k_12_total 24 0 3   1 6     0   3                               24 0 3   1 6     0   3                        
657639 OR     school 4108880 2141   North Marion SD 15 410888001424 3146 North Marion Primary School   Regular School No Elementary PK 02 2021   k_12_total 131 0 183   1 4     0   20                               131 0 183   1 4     0   20                        
657732 OR     school 4109480 2181   Parkrose SD 3 410948000979 925 Prescott Elementary School   Regular School No Elementary PK 05 2021   k_12_total 97 53 92   2 19     17   28                               97 53 92   2 19     17   28                        
657740 OR     school 4109510 2207   Pendleton SD 16 410951001838 5287 Pendleton Early Learning Center   Regular School No Elementary PK KG 2021   k_12_total 133 1 27   18 1     0   22                               133 1 27   18 1     0   22                        
657770 OR     school 4109960 2062   Plush SD 18 410996000523 497 Plush Elementary School   Regular School No Elementary PK 08 2021   k_12_total 10 0 2   0 0     0   0                               10 0 2   0 0     0   0                        
657781 OR     school 4110040 2180   Portland SD 1J 411004000873 830 Beach Elementary School   Regular School No Elementary PK 05 2021   k_12_total 205 37 110   0 0     0   30                               205 37 110   0 0     0   30                        
657785 OR     school 4110040 2180   Portland SD 1J 411004000876 833 Boise-Eliot Elementary School   Regular School No Elementary PK 05 2021   k_12_total 73 144 52   1 8     5   46                               73 144 52   1 8     5   46                        
657799 OR     school 4110040 2180   Portland SD 1J 411004000911 866 Dr. Martin Luther King Jr. School   Regular School No Elementary PK 05 2021   k_12_total 89 98 68   2 18     7   37                               89 98 68   2 18     7   37                        
657802 OR     school 4110040 2180   Portland SD 1J 411004000890 847 Faubion Elementary School   Regular School No Elementary PK 08 2021   k_12_total 177 198 206   13 13     10   84                               177 198 206   13 13     10   84                        
657852 OR     school 4110040 2180   Portland SD 1J 411004000930 883 Richmond Elementary School   Regular School No Elementary PK 05 2021   k_12_total 281 6 24   0 54     0   236                               281 6 24   0 54     0   236                        
657856 OR     school 4110040 2180   Portland SD 1J 411004000872 829 Rosa Parks Elementary School   Regular School No Elementary PK 05 2021   k_12_total 34 109 75   4 3     9   32                               34 109 75   4 3     9   32                        
657860 OR     school 4110040 2180   Portland SD 1J 411004000933 886 Sabin Elementary School   Regular School No Elementary PK 05 2021   k_12_total 247 59 24   1 4     0   26                               247 59 24   1 4     0   26                        
657870 OR     school 4110040 2180   Portland SD 1J 411004000944 895 Vernon Elementary School   Regular School No Elementary PK 08 2021   k_12_total 333 97 75   0 3     2   60                               333 97 75   0 3     2   60                        
657878 OR     school 4110040 2180   Portland SD 1J 411004000952 902 Woodlawn Elementary School   Regular School No Elementary PK 05 2021   k_12_total 117 94 54   2 5     4   42                               117 94 54   2 5     4   42                        
658034 OR     school 4111290 2244   Sherwood SD 88J 411129001244 1191 Hawks View Elementary School   Regular School No Elementary PK 05 2021   k_12_total 296 2 84   0 13     3   24                               296 2 84   0 13     3   24                        
658075 OR     school 4111610 1994   South Umpqua SD 19 411161000310 290 Myrtle Creek Elementary School   Regular School No Elementary PK 05 2021   k_12_total 197 0 33   2 0     0   27                               197 0 33   2 0     0   27                        
658077 OR     school 4111610 1994   South Umpqua SD 19 411161000312 292 Tri City Elementary School   Regular School No Elementary PK 05 2021   k_12_total 213 1 25   4 0     0   30                               213 1 25   4 0     0   30                        
658125 OR     school 4111760 2144   St Paul SD 45 411176000823 778 St Paul Elementary School   Regular School No Elementary PK 06 2021   k_12_total 79 0 56   0 0     0   2                               79 0 56   0 0     0   2                        
658130 OR     school 4111940 2003   Sutherlin SD 130 411194000338 318 East Sutherlin Primary School   Regular School No Elementary PK 02 2021   k_12_total 255 0 51   1 2     0   8                               255 0 51   1 2     0   8                        
658155 OR     school 4106900 2055   Three Rivers/Josephine County SD 410690001797 4823 Sunny Wolf Charter School   Regular School Yes Elementary PK 06 2021   k_12_total 99 0 8   1 0     0   9                               99 0 8   1 0     0   9                        
658199 OR     school 4112990 2220   Wallowa SD 12 411299001371 1088 Wallowa Elementary School   Regular School No Elementary PK 06 2021   k_12_total 73 0 8   1 0     0   2                               73 0 8   1 0     0   2                        
658205 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001356 1272 Boeckman Creek Primary School   Regular School No Elementary PK 05 2021   k_12_total 300 3 92   0 14     5   47                               300 3 92   0 14     5   47                        
658206 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001447 3455 Bolton Primary School   Regular School No Elementary PK 05 2021   k_12_total 239 0 19   0 10     0   26                               239 0 19   0 10     0   26                        
658207 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001575 3913 Boones Ferry Primary School   Regular School No Elementary PK 05 2021   k_12_total 325 4 121   0 15     7   48                               325 4 121   0 15     7   48                        
658208 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000053 45 Cedaroak Park Primary School   Regular School No Elementary PK 05 2021   k_12_total 215 1 18   0 4     2   28                               215 1 18   0 4     2   28                        
658210 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001822 5056 Lowrie Primary School   Regular School No Elementary PK 05 2021   k_12_total 282 4 129   0 25     0   48                               282 4 129   0 25     0   48                        
658213 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000054 47 Stafford Primary School   Regular School No Elementary PK 05 2021   k_12_total 302 0 9   0 13     0   26                               302 0 9   0 13     0   26                        
658214 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317000055 48 Sunset Primary School   Regular School No Elementary PK 05 2021   k_12_total 248 3 32   0 13     2   53                               248 3 32   0 13     2   53                        
658216 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001825 5057 Trillium Creek Primary School   Regular School No Elementary PK 05 2021   k_12_total 367 4 29   1 27     3   70                               367 4 29   1 27     3   70                        
658219 OR     school 4113170 1922   West Linn-Wilsonville SD 3J 411317001377 1286 Willamette Primary School   Regular School No Elementary PK 05 2021   k_12_total 369 3 37   1 12     2   44                               369 3 37   1 12     2   44                        
916684 OR     school 4101920 2243   Beaverton SD 48J 410192001204 1153 Aloha-Huber Park School   Regular School No Elementary PK 08 2020   k_12_total 222 44 525   4 53     2   40                               222 44 525   4 53     2   40                        
916687 OR     school 4101920 2243   Beaverton SD 48J 410192001205 1154 Barnes Elementary School   Regular School No Elementary PK 05 2020   k_12_total 171 31 332   0 15     11   28                               171 31 332   0 15     11   28                        
916692 OR     school 4101920 2243   Beaverton SD 48J 410192001753 4671 Bonny Slope Elementary School   Regular School No Elementary PK 05 2020   k_12_total 365 6 58   2 158     4   64                               365 6 58   2 158     4   64                        
916704 OR     school 4101920 2243   Beaverton SD 48J 410192001289 1157 Greenway Elementary School   Regular School No Elementary PK 05 2020   k_12_total 132 10 144   2 9     6   20                               132 10 144   2 9     6   20                        
916713 OR     school 4101920 2243   Beaverton SD 48J 410192001219 1168 McKay Elementary School   Regular School No Elementary PK 05 2020   k_12_total 157 10 90   0 9     3   26                               157 10 90   0 9     3   26                        
916735 OR     school 4101920 2243   Beaverton SD 48J 410192001230 1177 Vose Elementary School   Regular School No Elementary PK 05 2020   k_12_total 171 16 462   0 14     3   37                               171 16 462   0 14     3   37                        
916739 OR     school 4101920 2243   Beaverton SD 48J 410192001232 1179 William Walker Elementary School   Regular School No Elementary PK 05 2020   k_12_total 127 8 329   1 24     5   25                               127 8 329   1 24     5   25                        
916807 OR     school 4102610 1995   Camas Valley SD 21J 410261000315 3400 Camas Valley School   Regular School Yes Other PK 12 2020   k_12_total 177 0 16   1 0     0   22                               177 0 16   1 0     0   22                        
916876 OR     school 4103390 1964   Coquille SD 8 410339000200 189 Lincoln School of Early Learning   Regular School No Elementary PK 01 2020   k_12_total 105 1 11   3 0     0   17                               105 1 11   3 0     0   17                        
916926 OR     school 4103940 2187   David Douglas SD 40 410394001025 972 Cherry Park Elementary School   Regular School No Elementary PK 05 2020   k_12_total 176 60 125   3 48     9   51                               176 60 125   3 48     9   51                        
916929 OR     school 4103940 2187   David Douglas SD 40 410394004180 3525 Earl Boyles Elementary   Regular School No Elementary PK 05 2020   k_12_total 156 28 123   5 61     9   44                               156 28 123   5 61     9   44                        
916935 OR     school 4103940 2187   David Douglas SD 40 410394001033 977 Mill Park Elementary School   Regular School No Elementary PK 05 2020   k_12_total 117 98 159   6 67     13   20                               117 98 159   6 67     13   20                        
916945 OR     school 4104020 2011   Dayville SD 16J 410402000358 3353 Dayville School   Regular School No Other PK 12 2020   k_12_total 52 0 1   0 0     0   2                               52 0 1   0 0     0   2                        
916978 OR     school 4104530 2203   Echo SD 5 410453001089 3433 Echo School   Regular School No Other PK 12 2020   k_12_total 226 2 38   4 0     0   10                               226 2 38   4 0     0   10                        
916980 OR     school 4104590 2217   Elgin SD 23 410459001140 1082 Stella Mayfield Elementary School   Regular School No Elementary PK 06 2020   k_12_total 204 0 13   2 0     0   7                               204 0 13   2 0     0   7                        
917052 OR     school 4105160 2241   Forest Grove SD 15 410516001182 1128 Cornelius Elementary School   Regular School No Elementary PK 04 2020   k_12_total 37 0 326   0 1     0   3                               37 0 326   0 1     0   3                        
917054 OR     school 4105160 2241   Forest Grove SD 15 410516001184 1130 Echo Shaw Elementary School   Regular School No Elementary PK 06 2020   k_12_total 8 0 395   2 0     0   0                               8 0 395   2 0     0   0                        
917075 OR     school 4105610 1931   Gladstone SD 115 410561001774 4719 Gladstone Center for Children and Families   Regular School No Elementary PK KG 2020   k_12_total 100 3 20   1 1     1   23                               100 3 20   1 1     1   23                        
917226 OR     school 4106750 1934   Jewell SD 8 410675000158 3352 Jewell School   Regular School No Other PK 12 2020   k_12_total 135 0 15   0 0     0   12                               135 0 15   0 0     0   12                        
917337 OR     school 4107530 2012   Long Creek SD 17 410753000360 3366 Long Creek School   Regular School No Other PK 12 2020   k_12_total 23 0 5   1 3     0   3                               23 0 5   1 3     0   3                        
917488 OR     school 4108880 2141   North Marion SD 15 410888001424 3146 North Marion Primary School   Regular School No Elementary PK 02 2020   k_12_total 164 0 189   0 4     0   16                               164 0 189   0 4     0   16                        
917579 OR     school 4109480 2181   Parkrose SD 3 410948000979 925 Prescott Elementary School   Regular School No Elementary PK 05 2020   k_12_total 109 51 100   0 22     24   25                               109 51 100   0 22     24   25                        
917587 OR     school 4109510 2207   Pendleton SD 16 410951001838 5287 Pendleton Early Learning Center   Regular School No Elementary PK KG 2020   k_12_total 148 0 45   25 4     2   23                               148 0 45   25 4     2   23                        
917616 OR     school 4109960 2062   Plush SD 18 410996000523 497 Plush Elementary School   Regular School No Elementary PK 08 2020   k_12_total 6 0 0   0 0     0   1                               6 0 0   0 0     0   1                        
917626 OR     school 4110040 2180   Portland SD 1J 411004000873 830 Beach Elementary School   Regular School No Elementary PK 05 2020   k_12_total 225 41 130   1 5     0   31                               225 41 130   1 5     0   31                        
917630 OR     school 4110040 2180   Portland SD 1J 411004000876 833 Boise-Eliot Elementary School   Regular School No Elementary PK 05 2020   k_12_total 75 162 43   1 8     1   35                               75 162 43   1 8     1   35                        
917644 OR     school 4110040 2180   Portland SD 1J 411004000911 866 Dr. Martin Luther King Jr. School   Regular School No Elementary PK 05 2020   k_12_total 78 108 72   4 19     4   36                               78 108 72   4 19     4   36                        
917647 OR     school 4110040 2180   Portland SD 1J 411004000890 847 Faubion Elementary School   Regular School No Elementary PK 08 2020   k_12_total 177 200 201   14 15     8   86                               177 200 201   14 15     8   86                        
917696 OR     school 4110040 2180   Portland SD 1J 411004000930 883 Richmond Elementary School   Regular School No Elementary PK 05 2020   k_12_total 315 6 25   0 60     1   220                               315 6 25   0 60     1   220                        
917700 OR     school 4110040 2180   Portland SD 1J 411004000872 829 Rosa Parks Elementary School   Regular School No Elementary PK 05 2020   k_12_total 36 111 87   4 4     5   31                               36 111 87   4 4     5   31                        
917704 OR     school 4110040 2180   Portland SD 1J 411004000933 886 Sabin Elementary School   Regular School No Elementary PK 05 2020   k_12_total 285 59 32   2 4     1   33                               285 59 32   2 4     1   33                        
917715 OR     school 4110040 2180   Portland SD 1J 411004000944 895 Vernon Elementary School   Regular School No Elementary PK 08 2020   k_12_total 349 115 75   0 5     3   61                               349 115 75   0 5     3   61                        
917724 OR     school 4110040 2180   Portland SD 1J 411004000952 902 Woodlawn Elementary School   Regular School No Elementary PK 05 2020   k_12_total 109 102 54   1 4     6   32                               109 102 54   1 4     6   32                        
917740 OR     school 4110350 1977   Redmond SD 2J 411035001850 5340 Redmond Early Learning Center at Hugh Hartman   Regular School No Elementary PK KG 2020   k_12_total 312 2 78   2 3     1   20                               312 2 78   2 3     1   20                        
917878 OR     school 4111290 2244   Sherwood SD 88J 411129001244 1191 J Clyde Hopkins Elementary School   Regular School No Elementary PK 05 2020   k_12_total 325 3 87   0 12     0   31                               325 3 87   0 12     0   31                        
917923 OR     school 4111610 1994   South Umpqua SD 19 411161000310 290 Myrtle Creek Elementary School   Regular School No Elementary PK 05 2020   k_12_total 219 0 35   4 0     1   38                               219 0 35   4 0     1   38                        
917925 OR     school 4111610 1994   South Umpqua SD 19 411161000312 292 Tri City Elementary School   Regular School No Elementary PK 05 2020   k_12_total 249 0 27   4 0     0   29                               249 0 27   4 0     0   29                        
917971 OR     school 4111760 2144   St Paul SD 45 411176000823 778 St Paul Elementary School   Regular School No Elementary PK 06 2020   k_12_total 86 0 56   0 0     0   1                               86 0 56   0 0     0   1                        
917976 OR     school 4111940 2003   Sutherlin SD 130 411194000338 318 East Sutherlin Primary School   Regular School No Elementary PK 02 2020   k_12_total 301 1 42   3 1     0   11                               301 1 42   3 1     0   11                        
918045 OR     school 4112990 2220   Wallowa SD 12 411299001371 1088 Wallowa Elementary School   Regular School No Elementary PK 06 2020   k_12_total 79 0 5   1 0     0   2                               79 0 5   1 0     0   2                        
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 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 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 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                        

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