Data source: Big Local News · About: Big Local

15,474 rows where state = "WA" and year = 2019

View and edit SQL

grade

year

  • 2019 · 15,474
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
2412992 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_1 24 1 26   0 0     0   4   29 26 0   13   4   45       2.0 55 24 1 26   0 0     0   4   29 26 0   13 4 45     2 55
2412993 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_2 31 0 19   0 0     0   8   29 29 0   12   2   46       2.0 58 31 0 19   0 0     0   8   29 29 0   12 2 46     2 58
2412994 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_3 25 0 23   0 0     0   3   26 25 0   13   2   37       3.0 51 25 0 23   0 0     0   3   26 25 0   13 2 37     3 51
2412995 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_4 34 1 32   3 0     0   5   33 42 0   17   3   61       3.0 75 34 1 32   3 0     0   5   33 42 0   17 3 61     3 75
2412996 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_5 18 0 25   3 1     0   3   28 22 0   12   1   36       2.0 50 18 0 25   3 1     0   3   28 22 0   12 1 36     2 50
2412997 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_6 29 1 24   0 1     0   3   24 34 0   7   3   50       7.0 58 29 1 24   0 1     0   3   24 34 0   7 3 50     7 58
2412998 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   grade_7 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
2412999 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   pk_12_total 190 4 195   9 3     0   33   207 227 0   93   22   345       20.0 434 190 4 195   9 3     0   33   207 227 0   93 22 345     20 434
2413000 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   kindergarten 20 1 35   2 1     0   4   25 38 0   18   6   49       1.0 63 20 1 35   2 1     0   4   25 38 0   18 6 49     1 63
2413001 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 9 0 10   1 0     0   3   12 11 0   0   1   20       0.0 23 9 0 10   1 0     0   3   12 11 0   0 1 20     0 23
2413002 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2019   grade_1 18 0 3   0 2     0   6   19 10 0   0   0   17       0.0 29 18 0 3   0 2     0   6   19 10 0   0 0 17     0 29
2413003 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2019   grade_2 14 0 1   0 0     0   1   9 7 0   0   0   11       1.0 16 14 0 1   0 0     0   1   9 7 0   0 0 11     1 16
2413004 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2019   grade_3 19 0 3   0 1     0   2   12 13 0   0   0   14       0.0 25 19 0 3   0 1     0   2   12 13 0   0 0 14     0 25
2413005 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2019   grade_4 21 0 9   1 0     0   1   19 13 0   4   1   19       0.0 32 21 0 9   1 0     0   1   19 13 0   4 1 19     0 32
2413006 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2019   grade_5 21 0 5   0 0     0   2   10 18 0   1   0   17       0.0 28 21 0 5   0 0     0   2   10 18 0   1 0 17     0 28
2413007 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2019   grade_6 15 0 5   0 1     0   2   12 11 0   1   0   15       2.0 23 15 0 5   0 1     0   2   12 11 0   1 0 15     2 23
2413008 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2019   pk_12_total 134 0 31   1 5     0   19   100 90 0   9   2   111       6.0 190 134 0 31   1 5     0   19   100 90 0   9 2 111     6 190
2413009 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2019   kindergarten 26 0 5   0 1     0   5   19 18 0   3   1   18       3.0 37 26 0 5   0 1     0   5   19 18 0   3 1 18     3 37
2413010 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   grade_10 0 0 0   4 0     0   0   1 3 0   0   0   1       0.0 4 0 0 0   4 0     0   0   1 3 0   0 0 1     0 4
2413011 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   grade_11 1 0 0   1 0     0   0   0 2 0   0   0   1       0.0 2 1 0 0   1 0     0   0   0 2 0   0 0 1     0 2
2413012 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   grade_12 1 0 1   0 0     0   0   1 1 0   0   0   0       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 0     0 2
2413013 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   grade_7 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
2413014 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   grade_8 3 0 0   0 0     0   0   2 1 0   0   0   0       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 0     0 3
2413015 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   grade_9 0 0 0   1 0     0   0   1 0 0   0   1   0       0.0 1 0 0 0   1 0     0   0   1 0 0   0 1 0     0 1
2413016 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2019   pk_12_total 6 0 1   6 0     0   0   6 7 0   0   1   3       0.0 13 6 0 1   6 0     0   0   6 7 0   0 1 3     0 13
2413017 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No High 06 12 2019   grade_10 3 0 0   0 0     0   0   2 1 0   0   1   1       0.0 3 3 0 0   0 0     0   0   2 1 0   0 1 1     0 3
2413018 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No High 06 12 2019   grade_11 4 0 2   0 0     0   0   4 2 0   0   1   4       0.0 6 4 0 2   0 0     0   0   4 2 0   0 1 4     0 6
2413019 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No High 06 12 2019   grade_12 2 1 0   1 0     0   1   4 1 0   0   0   3       0.0 5 2 1 0   1 0     0   1   4 1 0   0 0 3     0 5
2413020 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No High 06 12 2019   grade_9 2 0 0   1 0     0   0   2 1 0   0   0   2       0.0 3 2 0 0   1 0     0   0   2 1 0   0 0 2     0 3
2413021 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No High 06 12 2019   pk_12_total 11 1 2   2 0     0   1   12 5 0   0   2   10       0.0 17 11 1 2   2 0     0   1   12 5 0   0 2 10     0 17
2413022 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000002 3857 Harbor High School   Regular School No High 09 12 2019   grade_10 9 0 5   0 0     0   1   6 9 0   1   1   13       2.0 15 9 0 5   0 0     0   1   6 9 0   1 1 13     2 15
2413023 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000002 3857 Harbor High School   Regular School No High 09 12 2019   grade_11 10 0 4   1 0     0   0   4 11 0   0   5   14       2.0 15 10 0 4   1 0     0   0   4 11 0   0 5 14     2 15
2413024 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000002 3857 Harbor High School   Regular School No High 09 12 2019   grade_12 30 0 15   3 0     1   2   22 29 0   8   19   40       4.0 51 30 0 15   3 0     1   2   22 29 0   8 19 40     4 51
2413025 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000002 3857 Harbor High School   Regular School No High 09 12 2019   grade_9 2 0 0   0 0     0   1   2 1 0   0   0   2       1.0 3 2 0 0   0 0     0   1   2 1 0   0 0 2     1 3
2413026 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000002 3857 Harbor High School   Regular School No High 09 12 2019   pk_12_total 51 0 24   4 0     1   4   34 50 0   9   25   69       9.0 84 51 0 24   4 0     1   4   34 50 0   9 25 69     9 84
2413027 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002271 3154 Hopkins Elementary   Regular School No Prekindergarten PK PK 2019   pk_12_total 75 1 36   2 0     0   13   67 60 0   0   3   106       0.0 127 75 1 36   2 0     0   13   67 60 0   0 3 106     0 127
2413028 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002271 3154 Hopkins Elementary   Regular School No Prekindergarten PK PK 2019   pre_kindergarten 75 1 36   2 0     0   13   67 60 0   0   3   106       0.0 127 75 1 36   2 0     0   13   67 60 0   0 3 106     0 127
2413029 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000007 3476 J M Weatherwax High School   Regular School No High 09 12 2019   grade_10 137 2 72   12 6     0   18   118 129 0   18   9   141       11.0 247 137 2 72   12 6     0   18   118 129 0   18 9 141     11 247
2413030 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000007 3476 J M Weatherwax High School   Regular School No High 09 12 2019   grade_11 138 3 58   10 4     2   13   98 130 0   21   12   119       8.0 228 138 3 58   10 4     2   13   98 130 0   21 12 119     8 228
2413031 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000007 3476 J M Weatherwax High School   Regular School No High 09 12 2019   grade_12 126 2 64   4 9     0   17   126 96 0   17   12   111       10.0 222 126 2 64   4 9     0   17   126 96 0   17 12 111     10 222
2413032 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000007 3476 J M Weatherwax High School   Regular School No High 09 12 2019   grade_9 154 2 78   5 7     0   14   118 142 0   23   13   165       12.0 260 154 2 78   5 7     0   14   118 142 0   23 13 165     12 260
2413033 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000007 3476 J M Weatherwax High School   Regular School No High 09 12 2019   pk_12_total 555 9 272   31 26     2   62   460 497 0   79   46   536       41.0 957 555 9 272   31 26     2   62   460 497 0   79 46 536     41 957
2413034 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2019   grade_1 28 0 14   0 1     0   8   19 32 0   10   1   40       2.0 51 28 0 14   0 1     0   8   19 32 0   10 1 40     2 51
2413035 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2019   grade_2 24 1 12   2 1     0   6   19 27 0   10   1   38       2.0 46 24 1 12   2 1     0   6   19 27 0   10 1 38     2 46
2413036 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2019   grade_3 22 0 13   3 0     0   12   24 26 0   7   1   38       9.0 50 22 0 13   3 0     0   12   24 26 0   7 1 38     9 50
2413037 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2019   grade_4 27 0 21   0 0     0   1   25 24 0   9   2   34       2.0 49 27 0 21   0 0     0   1   25 24 0   9 2 34     2 49
2413038 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2019   grade_5 32 0 16   0 0     0   9   31 26 0   4   0   37       2.0 57 32 0 16   0 0     0   9   31 26 0   4 0 37     2 57
2413039 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2019   grade_6 32 1 18   0 0     0   4   27 28 0   9   0   39       1.0 55 32 1 18   0 0     0   4   27 28 0   9 0 39     1 55
2413040 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2019   grade_8 1 0 1   0 0     0   0   1 1 0   1   0   0       0.0 2 1 0 1   0 0     0   0   1 1 0   1 0 0     0 2
2413041 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2019   pk_12_total 194 3 107   8 2     1   48   177 186 0   57   7   263       18.0 363 194 3 107   8 2     1   48   177 186 0   57 7 263     18 363
2413042 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2019   kindergarten 28 1 12   3 0     1   8   31 22 0   7   2   37       0.0 53 28 1 12   3 0     1   8   31 22 0   7 2 37     0 53
2413043 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 07 08 2019   grade_7 132 5 79   13 6     0   24   122 137 0   25   10   176       8.0 259 132 5 79   13 6     0   24   122 137 0   25 10 176     8 259
2413044 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 07 08 2019   grade_8 130 0 76   8 3     0   14   119 112 0   30   11   180       14.0 231 130 0 76   8 3     0   14   119 112 0   30 11 180     14 231
2413045 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 07 08 2019   pk_12_total 262 5 155   21 9     0   38   241 249 0   55   21   356       22.0 490 262 5 155   21 9     0   38   241 249 0   55 21 356     22 490
2413046 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   grade_1 21 0 17   0 0     0   6   23 21 0   10   2   38       0.0 44 21 0 17   0 0     0   6   23 21 0   10 2 38     0 44
2413047 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   grade_2 25 0 18   0 0     0   1   22 22 0   8   1   34       3.0 44 25 0 18   0 0     0   1   22 22 0   8 1 34     3 44
2413048 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   grade_3 27 0 22   0 1     0   2   24 28 0   11   2   44       4.0 52 27 0 22   0 1     0   2   24 28 0   11 2 44     4 52
2413049 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   grade_4 19 0 20   2 0     1   5   24 23 0   13   1   31       1.0 47 19 0 20   2 0     1   5   24 23 0   13 1 31     1 47
2413050 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   grade_5 33 0 26   1 0     0   3   30 33 0   13   5   55       4.0 63 33 0 26   1 0     0   3   30 33 0   13 5 55     4 63
2413051 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   grade_6 23 0 23   1 1     0   3   29 22 0   7   4   40       3.0 51 23 0 23   1 1     0   3   29 22 0   7 4 40     3 51
2413052 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   pk_12_total 175 0 140   5 2     1   22   176 169 0   71   18   281       15.0 345 175 0 140   5 2     1   22   176 169 0   71 18 281     15 345
2413053 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2019   kindergarten 27 0 14   1 0     0   2   24 20 0   9   3   39       0.0 44 27 0 14   1 0     0   2   24 20 0   9 3 39     0 44
2413054 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   grade_1 26 0 19   0 1     0   14   32 28 0   13   6   48       0.0 60 26 0 19   0 1     0   14   32 28 0   13 6 48     0 60
2413055 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   grade_2 27 0 26   1 0     0   7   28 33 0   25   4   55       0.0 61 27 0 26   1 0     0   7   28 33 0   25 4 55     0 61
2413056 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   grade_3 35 0 23   0 0     0   6   31 33 0   13   1   53       0.0 64 35 0 23   0 0     0   6   31 33 0   13 1 53     0 64
2413057 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   grade_4 32 2 23   0 2     0   4   39 24 0   10   5   56       1.0 63 32 2 23   0 2     0   4   39 24 0   10 5 56     1 63
2413058 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   grade_5 50 1 26   2 5     0   14   49 49 0   12   1   77       3.0 98 50 1 26   2 5     0   14   49 49 0   12 1 77     3 98
2413059 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   grade_6 37 0 24   2 3     0   3   30 39 0   2   7   57       3.0 69 37 0 24   2 3     0   3   30 39 0   2 7 57     3 69
2413060 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   pk_12_total 255 7 179   6 12     0   54   266 247 0   87   32   425       8.0 513 255 7 179   6 12     0   54   266 247 0   87 32 425     8 513
2413061 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   kindergarten 26 2 21   1 0     0   4   27 27 0   12   4   44       1.0 54 26 2 21   1 0     0   4   27 27 0   12 4 44     1 54
2413062 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2019   pre_kindergarten 22 2 17   0 1     0   2   30 14 0   0   4   35       0.0 44 22 2 17   0 1     0   2   30 14 0   0 4 35     0 44
2413063 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003334 5208 Twin Harbors, A Branch of New Market Skills Center   Career and Technical School No High 09 12 2019   grade_11 3 0 0   0 0     0   0   2 1 0   0   0   0       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 0     0 3
2413064 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003334 5208 Twin Harbors, A Branch of New Market Skills Center   Career and Technical School No High 09 12 2019   grade_12 6 1 0   1 0     0   0   3 5 0   0   0   2       0.0 8 6 1 0   1 0     0   0   3 5 0   0 0 2     0 8
2413065 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003334 5208 Twin Harbors, A Branch of New Market Skills Center   Career and Technical School No High 09 12 2019   pk_12_total 9 1 0   1 0     0   0   5 6 0   0   0   2       0.0 11 9 1 0   1 0     0   0   5 6 0   0 0 2     0 11
2413066 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   grade_1 35 1 1   0 1     0   1   15 24 0   0   2   6       0.0 39 35 1 1   0 1     0   1   15 24 0   0 2 6     0 39
2413067 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   grade_2 37 1 2   0 0     0   0   15 25 0   0   1   14       0.0 40 37 1 2   0 0     0   0   15 25 0   0 1 14     0 40
2413068 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   grade_3 29 1 1   1 0     0   0   14 18 0   0   1   7       0.0 32 29 1 1   1 0     0   0   14 18 0   0 1 7     0 32
2413069 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   grade_4 46 3 2   1 0     0   0   28 24 0   0   1   17       0.0 52 46 3 2   1 0     0   0   28 24 0   0 1 17     0 52
2413070 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   grade_5 44 0 7   1 0     0   0   24 28 0   0   2   16       0.0 52 44 0 7   1 0     0   0   24 28 0   0 2 16     0 52
2413071 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 223 6 15   3 1     0   2   111 139 0   0   7   66       0.0 250 223 6 15   3 1     0   2   111 139 0   0 7 66     0 250
2413072 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   kindergarten 29 0 2   0 0     0   0   12 19 0   0   0   5       0.0 31 29 0 2   0 0     0   0   12 19 0   0 0 5     0 31
2413073 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2019   pre_kindergarten 3 0 0   0 0     0   1   3 1 0   0   0   1       0.0 4 3 0 0   0 0     0   1   3 1 0   0 0 1     0 4
2413074 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2019   grade_10 61 1 5   0 0     0   2   34 35 0   1   2   18       3.0 69 61 1 5   0 0     0   2   34 35 0   1 2 18     3 69
2413075 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2019   grade_11 46 0 2   0 0     0   3   25 26 0   0   1   16       2.0 51 46 0 2   0 0     0   3   25 26 0   0 1 16     2 51
2413076 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2019   grade_12 60 0 5   0 0     0   0   39 26 0   0   2   17       4.0 65 60 0 5   0 0     0   0   39 26 0   0 2 17     4 65
2413077 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2019   grade_6 52 0 4   1 1     0   0   32 26 0   1   1   20       1.0 58 52 0 4   1 1     0   0   32 26 0   1 1 20     1 58
2413078 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2019   grade_7 47 0 4   0 1     0   1   25 28 0   0   0   16       2.0 53 47 0 4   0 1     0   1   25 28 0   0 0 16     2 53
2413079 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2019   grade_8 37 0 2   0 1     0   1   22 19 0   0   1   18       1.0 41 37 0 2   0 1     0   1   22 19 0   0 1 18     1 41
2413080 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2019   grade_9 50 0 2   1 1     0   2   23 33 0   0   2   20       4.0 56 50 0 2   1 1     0   2   23 33 0   0 2 20     4 56
2413081 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2019   pk_12_total 353 1 24   2 4     0   9   200 193 0   2   9   125       17.0 393 353 1 24   2 4     0   9   200 193 0   2 9 125     17 393
2413082 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_1 3 0 0   0 0     0   1   2 2 0   0   0   1       1.0 4 3 0 0   0 0     0   1   2 2 0   0 0 1     1 4
2413083 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_2 11 0 0   0 0     0   0   6 5 0   0   0   1       1.0 11 11 0 0   0 0     0   0   6 5 0   0 0 1     1 11
2413084 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_3 7 0 0   0 0     0   2   2 7 0   0   0   5       0.0 9 7 0 0   0 0     0   2   2 7 0   0 0 5     0 9
2413085 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_4 5 0 0   0 0     0   2   3 4 0   0   0   2       0.0 7 5 0 0   0 0     0   2   3 4 0   0 0 2     0 7
2413086 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_5 7 0 0   0 0     0   0   5 2 0   0   0   2       0.0 7 7 0 0   0 0     0   0   5 2 0   0 0 2     0 7
2413087 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_6 16 0 3   0 0     0   0   13 6 0   0   0   8       2.0 19 16 0 3   0 0     0   0   13 6 0   0 0 8     2 19
2413088 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_7 17 0 2   0 0     0   4   7 16 0   0   0   10       0.0 23 17 0 2   0 0     0   4   7 16 0   0 0 10     0 23
2413089 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   grade_8 15 0 0   0 0     0   2   5 12 0   0   0   10       0.0 17 15 0 0   0 0     0   2   5 12 0   0 0 10     0 17
2413090 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   pk_12_total 99 0 6   0 0     0   11   50 66 0   0   0   43       4.0 116 99 0 6   0 0     0   11   50 66 0   0 0 43     4 116
2413091 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary PK 08 2019   kindergarten 10 0 1   0 0     0   0   3 8 0   0   0   2       0.0 11 10 0 1   0 0     0   0   3 8 0   0 0 2     0 11

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