Data source: Big Local News · About: Big Local

15,431 rows where state = "WA" and year = 2018 sorted by county_state_id

View and edit SQL

grade

year

  • 2018 · 15,431
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
2457557 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2018   grade_1 28 0 21   0 0     0   7   28 28 0   14   4   45       1.0 56 28 0 21   0 0     0   7   28 28 0   14 4 45     1 56
2457558 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2018   grade_2 23 1 23   0 0     0   4   27 24 0   14   4   40       2.0 51 23 1 23   0 0     0   4   27 24 0   14 4 40     2 51
2457559 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2018   grade_3 33 0 33   2 0     0   4   35 37 0   16   0   56       1.0 72 33 0 33   2 0     0   4   35 37 0   16 0 56     1 72
2457560 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2018   grade_4 19 0 26   3 1     0   3   29 23 0   14   6   41       2.0 52 19 0 26   3 1     0   3   29 23 0   14 6 41     2 52
2457561 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2018   grade_5 30 0 24   0 2     0   3   28 31 0   8   1   47       6.0 59 30 0 24   0 2     0   3   28 31 0   8 1 47     6 59
2457562 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2018   grade_6 22 1 25   2 0     0   2   26 26 0   8   5   37       5.0 52 22 1 25   2 0     0   2   26 26 0   8 5 37     5 52
2457563 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2018   grade_7 0 0 0   1 0     0   0   1 0 0   0   1   1       1.0 1 0 0 0   1 0     0   0   1 0 0   0 1 1     1 1
2457564 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2018   pk_12_total 192 3 192   8 3     0   27   211 214 0   88   26   332       21.0 425 192 3 192   8 3     0   27   211 214 0   88 26 332     21 425
2457565 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2018   kindergarten 26 1 28   0 0     0   4   30 29 0   14   4   48       2.0 59 26 1 28   0 0     0   4   30 29 0   14 4 48     2 59
2457566 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 11 0 12   0 0     0   0   7 16 0   0   1   17       1.0 23 11 0 12   0 0     0   0   7 16 0   0 1 17     1 23
2457567 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2018   grade_1 16 0 1   0 0     0   1   10 8 0   0   0   10       1.0 18 16 0 1   0 0     0   1   10 8 0   0 0 10     1 18
2457568 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2018   grade_2 19 0 3   0 1     0   3   13 13 0   1   0   16       0.0 26 19 0 3   0 1     0   3   13 13 0   1 0 16     0 26
2457569 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2018   grade_3 25 0 8   1 0     0   2   21 15 0   4   1   19       1.0 36 25 0 8   1 0     0   2   21 15 0   4 1 19     1 36
2457570 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2018   grade_4 22 0 5   0 0     0   3   11 19 0   1   1   20       0.0 30 22 0 5   0 0     0   3   11 19 0   1 1 20     0 30
2457571 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2018   grade_5 14 0 6   0 1     0   2   12 11 0   1   1   15       2.0 23 14 0 6   0 1     0   2   12 11 0   1 1 15     2 23
2457572 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2018   grade_6 20 1 4   0 0     0   5   17 13 0   0   1   16       1.0 30 20 1 4   0 0     0   5   17 13 0   0 1 16     1 30
2457573 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2018   pk_12_total 134 1 30   1 3     0   23   103 89 0   7   6   114       5.0 192 134 1 30   1 3     0   23   103 89 0   7 6 114     5 192
2457574 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2018   kindergarten 18 0 3   0 1     0   7   19 10 0   0   2   18       0.0 29 18 0 3   0 1     0   7   19 10 0   0 2 18     0 29
2457575 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No High 06 12 2018   grade_10 3 0 1   0 0     0   0   3 1 0   0   1   3       1.0 4 3 0 1   0 0     0   0   3 1 0   0 1 3     1 4
2457576 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No High 06 12 2018   grade_11 0 0 2   0 0     0   0   1 1 0   0   0   1       0.0 2 0 0 2   0 0     0   0   1 1 0   0 0 1     0 2
2457577 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No High 06 12 2018   grade_12 0 0 1   1 0     0   0   2 0 0   1   0   2       0.0 2 0 0 1   1 0     0   0   2 0 0   1 0 2     0 2
2457578 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No High 06 12 2018   grade_8 2 0 0   0 0     0   0   1 1 0   0   0   1       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 1     0 2
2457579 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No High 06 12 2018   grade_9 2 0 1   0 0     0   0   2 1 0   0   0   1       0.0 3 2 0 1   0 0     0   0   2 1 0   0 0 1     0 3
2457580 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No High 06 12 2018   pk_12_total 7 0 5   1 0     0   0   9 4 0   1   1   8       1.0 13 7 0 5   1 0     0   0   9 4 0   1 1 8     1 13
2457581 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000002 3857 Harbor High School   Regular School No High 09 12 2018   grade_10 6 0 2   1 0     0   0   4 5 0   0   2   8       0.0 9 6 0 2   1 0     0   0   4 5 0   0 2 8     0 9
2457582 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000002 3857 Harbor High School   Regular School No High 09 12 2018   grade_11 12 0 7   0 0     1   0   9 11 0   3   7   17       3.0 20 12 0 7   0 0     1   0   9 11 0   3 7 17     3 20
2457583 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000002 3857 Harbor High School   Regular School No High 09 12 2018   grade_12 32 1 21   4 1     0   8   37 30 0   4   14   56       4.0 67 32 1 21   4 1     0   8   37 30 0   4 14 56     4 67
2457584 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000002 3857 Harbor High School   Regular School No High 09 12 2018   grade_9 3 0 1   0 0     0   0   2 2 0   0   1   3       1.0 4 3 0 1   0 0     0   0   2 2 0   0 1 3     1 4
2457585 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000002 3857 Harbor High School   Regular School No High 09 12 2018   pk_12_total 53 1 31   5 1     1   8   52 48 0   7   24   84       8.0 100 53 1 31   5 1     1   8   52 48 0   7 24 84     8 100
2457586 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002271 3154 Hopkins Elementary   Regular School No Prekindergarten PK PK 2018   pk_12_total 49 0 37   4 1     0   10   58 43 0   0   6   86       5.0 101 49 0 37   4 1     0   10   58 43 0   0 6 86     5 101
2457587 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002271 3154 Hopkins Elementary   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 49 0 37   4 1     0   10   58 43 0   0   6   86       5.0 101 49 0 37   4 1     0   10   58 43 0   0 6 86     5 101
2457588 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000007 3476 J M Weatherwax High School   Regular School No High 09 12 2018   grade_10 144 3 63   11 6     2   12   112 129 0   22   7   139       7.0 241 144 3 63   11 6     2   12   112 129 0   22 7 139     7 241
2457589 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000007 3476 J M Weatherwax High School   Regular School No High 09 12 2018   grade_11 114 3 67   5 9     1   13   114 98 0   21   7   120       9.0 212 114 3 67   5 9     1   13   114 98 0   21 7 120     9 212
2457590 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000007 3476 J M Weatherwax High School   Regular School No High 09 12 2018   grade_12 137 4 65   12 8     1   7   122 112 0   21   16   133       11.0 234 137 4 65   12 8     1   7   122 112 0   21 16 133     11 234
2457591 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000007 3476 J M Weatherwax High School   Regular School No High 09 12 2018   grade_8 0 0 1   0 0     0   0   0 1 0   1   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   1 0 1     0 1
2457592 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000007 3476 J M Weatherwax High School   Regular School No High 09 12 2018   grade_9 139 2 74   17 8     0   16   120 136 0   16   15   173       11.0 256 139 2 74   17 8     0   16   120 136 0   16 15 173     11 256
2457593 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000007 3476 J M Weatherwax High School   Regular School No High 09 12 2018   pk_12_total 534 12 270   45 31     4   48   468 476 0   81   45   566       38.0 944 534 12 270   45 31     4   48   468 476 0   81 45 566     38 944
2457594 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2018   grade_1 32 1 13   2 0     0   11   27 32 0   9   3   45       1.0 59 32 1 13   2 0     0   11   27 32 0   9 3 45     1 59
2457595 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2018   grade_2 26 0 15   3 0     0   14   29 29 0   7   2   44       8.0 58 26 0 15   3 0     0   14   29 29 0   7 2 44     8 58
2457596 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2018   grade_3 29 0 19   2 0     0   1   28 23 0   12   0   39       1.0 51 29 0 19   2 0     0   1   28 23 0   12 0 39     1 51
2457597 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2018   grade_4 28 0 16   0 0     0   10   28 26 0   6   1   38       2.0 54 28 0 16   0 0     0   10   28 26 0   6 1 38     2 54
2457598 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2018   grade_5 37 1 19   0 0     0   3   30 30 0   9   3   42       1.0 60 37 1 19   0 0     0   3   30 30 0   9 3 42     1 60
2457599 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2018   grade_6 26 0 14   2 2     0   3   22 25 0   6   1   30       1.0 47 26 0 14   2 2     0   3   22 25 0   6 1 30     1 47
2457600 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2018   grade_8 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2457601 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2018   pk_12_total 209 2 109   9 2     0   50   185 196 0   57   10   272       16.0 381 209 2 109   9 2     0   50   185 196 0   57 10 272     16 381
2457602 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2018   kindergarten 26 0 13   0 0     0   8   17 30 0   8   0   34       2.0 47 26 0 13   0 0     0   8   17 30 0   8 0 34     2 47
2457603 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2018   pre_kindergarten 4 0 0   0 0     0   0   3 1 0   0   0   0       0.0 4 4 0 0   0 0     0   0   3 1 0   0 0 0     0 4
2457604 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 07 08 2018   grade_7 127 0 80   9 3     0   16   120 115 0   28   13   176       9.0 235 127 0 80   9 3     0   16   120 115 0   28 13 176     9 235
2457605 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 07 08 2018   grade_8 150 3 66   10 6     0   15   118 132 0   25   9   188       10.0 250 150 3 66   10 6     0   15   118 132 0   25 9 188     10 250
2457606 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 07 08 2018   pk_12_total 277 3 146   19 9     0   31   238 247 0   53   22   364       19.0 485 277 3 146   19 9     0   31   238 247 0   53 22 364     19 485
2457607 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2018   grade_1 20 0 18   0 0     0   2   19 21 0   9   1   35       1.0 40 20 0 18   0 0     0   2   19 21 0   9 1 35     1 40
2457608 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2018   grade_2 29 0 22   0 1     0   3   25 30 0   16   2   49       2.0 55 29 0 22   0 1     0   3   25 30 0   16 2 49     2 55
2457609 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2018   grade_3 20 0 17   1 0     1   7   22 24 0   14   2   38       2.0 46 20 0 17   1 0     1   7   22 24 0   14 2 38     2 46
2457610 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2018   grade_4 34 0 25   2 0     0   3   31 33 0   15   4   59       3.0 64 34 0 25   2 0     0   3   31 33 0   15 4 59     3 64
2457611 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2018   grade_5 20 0 21   1 1     0   3   24 22 0   7   4   41       2.0 46 20 0 21   1 1     0   3   24 22 0   7 4 41     2 46
2457612 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2018   grade_6 27 0 15   2 1     0   8   21 32 0   3   4   42       2.0 53 27 0 15   2 1     0   8   21 32 0   3 4 42     2 53
2457613 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2018   pk_12_total 182 0 143   7 3     2   34   177 194 0   74   24   322       12.0 371 182 0 143   7 3     2   34   177 194 0   74 24 322     12 371
2457614 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2018   kindergarten 20 0 15   1 0     0   6   23 19 0   10   5   35       0.0 42 20 0 15   1 0     0   6   23 19 0   10 5 35     0 42
2457615 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000010 2763 Robert Gray Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 12 0 10   0 0     1   2   12 13 0   0   2   23       0.0 25 12 0 10   0 0     1   2   12 13 0   0 2 23     0 25
2457616 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2018   grade_1 28 0 27   1 0     0   5   29 32 0   24   4   54       0.0 61 28 0 27   1 0     0   5   29 32 0   24 4 54     0 61
2457617 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2018   grade_2 36 1 25   0 0     0   5   29 38 0   12   5   53       0.0 67 36 1 25   0 0     0   5   29 38 0   12 5 53     0 67
2457618 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2018   grade_3 34 2 26   0 2     0   6   43 27 0   13   6   64       1.0 70 34 2 26   0 2     0   6   43 27 0   13 6 64     1 70
2457619 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2018   grade_4 47 1 27   2 5     0   15   49 48 0   17   2   79       1.0 97 47 1 27   2 5     0   15   49 48 0   17 2 79     1 97
2457620 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2018   grade_5 34 0 28   1 4     0   2   32 37 0   5   6   56       1.0 69 34 0 28   1 4     0   2   32 37 0   5 6 56     1 69
2457621 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2018   grade_6 31 2 21   7 3     0   7   37 34 0   11   2   56       0.0 71 31 2 21   7 3     0   7   37 34 0   11 2 56     0 71
2457622 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2018   pk_12_total 245 7 193   12 17     0   59   265 268 0   94   33   451       3.0 533 245 7 193   12 17     0   59   265 268 0   94 33 451     3 533
2457623 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2018   kindergarten 19 0 18   0 3     0   15   28 27 0   12   5   48       0.0 55 19 0 18   0 3     0   15   28 27 0   12 5 48     0 55
2457624 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000011 2971 Stevens Elementary School   Regular School No Elementary PK 06 2018   pre_kindergarten 16 1 21   1 0     0   4   18 25 0   0   3   41       0.0 43 16 1 21   1 0     0   4   18 25 0   0 3 41     0 43
2457625 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 2018   grade_10 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2457626 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 2018   grade_11 12 0 3   0 0     0   0   8 7 0   0   0   4       0.0 15 12 0 3   0 0     0   0   8 7 0   0 0 4     0 15
2457627 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 2018   grade_12 26 1 3   2 0     0   0   15 17 0   0   0   1       0.0 32 26 1 3   2 0     0   0   15 17 0   0 0 1     0 32
2457628 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 2018   pk_12_total 39 1 6   2 0     0   0   24 24 0   0   0   5       0.0 48 39 1 6   2 0     0   0   24 24 0   0 0 5     0 48
2457629 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2018   grade_1 36 1 1   0 0     0   0   16 22 0   0   0   12       0.0 38 36 1 1   0 0     0   0   16 22 0   0 0 12     0 38
2457630 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2018   grade_2 35 0 1   1 0     0   0   20 17 0   0   0   9       0.0 37 35 0 1   1 0     0   0   20 17 0   0 0 9     0 37
2457631 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2018   grade_3 49 2 3   1 0     0   0   29 26 0   0   3   18       0.0 55 49 2 3   1 0     0   0   29 26 0   0 3 18     0 55
2457632 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2018   grade_4 42 0 4   1 0     0   0   21 26 0   0   1   9       0.0 47 42 0 4   1 0     0   0   21 26 0   0 1 9     0 47
2457633 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2018   grade_5 42 0 3   1 0     0   0   26 20 0   0   3   18       0.0 46 42 0 3   1 0     0   0   26 20 0   0 3 18     0 46
2457634 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2018   pk_12_total 243 3 13   4 0     0   2   126 139 0   0   7   73       0.0 265 243 3 13   4 0     0   2   126 139 0   0 7 73     0 265
2457635 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2018   kindergarten 37 0 1   0 0     0   1   13 26 0   0   0   7       0.0 39 37 0 1   0 0     0   1   13 26 0   0 0 7     0 39
2457636 WA Lewis   school 5300060 21226   Adna School District 530006000012 2227 Adna Elementary School   Regular School No Elementary PK 05 2018   pre_kindergarten 2 0 0   0 0     0   1   1 2 0   0   0   0       0.0 3 2 0 0   0 0     0   1   1 2 0   0 0 0     0 3
2457637 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2018   grade_10 50 0 3   0 0     0   4   27 30 0   0   0   23       3.0 57 50 0 3   0 0     0   4   27 30 0   0 0 23     3 57
2457638 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2018   grade_11 59 0 5   1 1     0   0   42 24 0   0   0   14       4.0 66 59 0 5   1 1     0   0   42 24 0   0 0 14     4 66
2457639 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2018   grade_12 48 0 4   0 1     0   5   27 31 0   0   3   13       3.0 58 48 0 4   0 1     0   5   27 31 0   0 3 13     3 58
2457640 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2018   grade_6 47 0 4   0 1     0   1   25 28 0   0   1   19       1.0 53 47 0 4   0 1     0   1   25 28 0   0 1 19     1 53
2457641 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2018   grade_7 32 0 1   0 1     0   1   20 15 0   0   1   12       0.0 35 32 0 1   0 1     0   1   20 15 0   0 1 12     0 35
2457642 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2018   grade_8 44 0 3   0 1     0   2   22 28 0   0   1   19       2.0 50 44 0 3   0 1     0   2   22 28 0   0 1 19     2 50
2457643 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2018   grade_9 56 0 4   0 0     0   2   28 34 0   0   0   20       3.0 62 56 0 4   0 0     0   2   28 34 0   0 0 20     3 62
2457644 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2018   pk_12_total 336 0 24   1 5     0   15   191 190 0   0   6   120       16.0 381 336 0 24   1 5     0   15   191 190 0   0 6 120     16 381
2457645 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2018   grade_1 10 0 1   0 0     0   0   6 5 0   0   0   1       0.0 11 10 0 1   0 0     0   0   6 5 0   0 0 1     0 11
2457646 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2018   grade_2 5 0 0   0 0     0   0   3 2 0   0   0   2       0.0 5 5 0 0   0 0     0   0   3 2 0   0 0 2     0 5
2457647 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2018   grade_3 3 0 1   0 0     0   2   2 4 0   0   0   1       0.0 6 3 0 1   0 0     0   2   2 4 0   0 0 1     0 6
2457648 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2018   grade_4 6 0 0   0 0     0   0   4 2 0   0   0   3       0.0 6 6 0 0   0 0     0   0   4 2 0   0 0 3     0 6
2457649 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2018   grade_5 4 0 1   0 0     0   0   4 1 0   0   0   2       0.0 5 4 0 1   0 0     0   0   4 1 0   0 0 2     0 5
2457650 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2018   grade_6 18 0 3   0 0     0   4   8 17 0   0   0   13       0.0 25 18 0 3   0 0     0   4   8 17 0   0 0 13     0 25
2457651 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2018   grade_7 17 0 0   0 0     0   1   6 12 0   0   0   10       0.0 18 17 0 0   0 0     0   1   6 12 0   0 0 10     0 18
2457652 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2018   grade_8 21 0 2   0 0     0   2   12 13 0   0   0   10       1.0 25 21 0 2   0 0     0   2   12 13 0   0 0 10     1 25
2457653 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2018   pk_12_total 96 0 9   0 0     0   9   48 66 0   0   0   44       1.0 114 96 0 9   0 0     0   9   48 66 0   0 0 44     1 114
2457654 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2018   kindergarten 3 0 0   0 0     0   0   1 2 0   0   0   1       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 1     0 3
2457655 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2018   pre_kindergarten 9 0 1   0 0     0   0   2 8 0   0   0   1       0.0 10 9 0 1   0 0     0   0   2 8 0   0 0 1     0 10
2457656 WA Skagit   school 5300150 29103   Anacortes School District 530015000016 2467 Anacortes High School   Regular School No High 09 12 2018   grade_10 172 1 15   3 15     0   4   110 100 0   2   3   58       11.0 210 172 1 15   3 15     0   4   110 100 0   2 3 58     11 210

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