Data source: Big Local News · About: Big Local

15,758 rows where state = "WA" and year = 2017 sorted by school

View and edit SQL

grade

year

  • 2017 · 15,758
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
624093 WA Snohomish   school 5304860 31025   Marysville School District 530486002475 1656 10th Street School   Regular School No Middle 06 08 2017   grade_6 42 1 8   0 2     0   8   30 31 0   3   0   14       1.0 61 42 1 8   0 2     0   8   30 31 0   3 0 14     1 61
624094 WA Snohomish   school 5304860 31025   Marysville School District 530486002475 1656 10th Street School   Regular School No Middle 06 08 2017   grade_7 43 1 6   4 3     0   6   27 36 0   2   0   9       2.0 63 43 1 6   4 3     0   6   27 36 0   2 0 9     2 63
624095 WA Snohomish   school 5304860 31025   Marysville School District 530486002475 1656 10th Street School   Regular School No Middle 06 08 2017   grade_8 43 0 6   3 1     0   3   20 36 0   0   0   10       3.0 56 43 0 6   3 1     0   3   20 36 0   0 0 10     3 56
624096 WA Snohomish   school 5304860 31025   Marysville School District 530486002475 1656 10th Street School   Regular School No Middle 06 08 2017   pk_12_total 128 2 20   7 6     0   17   77 103 0   5   0   33       6.0 180 128 2 20   7 6     0   17   77 103 0   5 0 33     6 180
620909 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2017   grade_10 10 0 0   0 0     0   0   9 1 0   1   1   5       0.0 10 10 0 0   0 0     0   0   9 1 0   1 1 5     0 10
620910 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2017   grade_11 4 2 1   1 0     0   1   7 2 0   0   0   5       0.0 9 4 2 1   1 0     0   1   7 2 0   0 0 5     0 9
620911 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2017   grade_12 40 8 9   0 8     0   2   48 19 0   1   0   41       0.0 67 40 8 9   0 8     0   2   48 19 0   1 0 41     0 67
620912 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2017   grade_1 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
620913 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2017   grade_2 1 0 0   0 0     0   1   2 0 0   0   0   2       0.0 2 1 0 0   0 0     0   1   2 0 0   0 0 2     0 2
620914 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2017   grade_3 1 0 1   0 0     0   0   2 0 0   0   0   2       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 2     0 2
620915 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2017   grade_4 3 0 0   0 0     0   0   2 1 0   0   0   2       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 2     0 3
620916 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2017   grade_5 3 0 0   0 0     0   0   3 0 0   0   0   2       0.0 3 3 0 0   0 0     0   0   3 0 0   0 0 2     0 3
620917 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2017   grade_7 2 0 1   0 0     0   0   2 1 0   0   0   2       0.0 3 2 0 1   0 0     0   0   2 1 0   0 0 2     0 3
620918 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2017   grade_8 4 0 0   0 1     0   0   4 1 0   0   0   5       0.0 5 4 0 0   0 1     0   0   4 1 0   0 0 5     0 5
620919 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2017   grade_9 3 1 0   0 0     0   0   3 1 0   0   0   4       0.0 4 3 1 0   0 0     0   0   3 1 0   0 0 4     0 4
620920 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2017   pk_12_total 72 11 12   1 9     0   4   82 27 0   2   1   71       0.0 109 72 11 12   1 9     0   4   82 27 0   2 1 71     0 109
631260 WA Thurston   school 5309100 34033   Tumwater School District 530910002602 4500 A G West Black Hills High School   Regular School No High 09 12 2017   grade_10 147 5 20   1 7     0   20   103 97 0   1   3   57       10.0 200 147 5 20   1 7     0   20   103 97 0   1 3 57     10 200
631261 WA Thurston   school 5309100 34033   Tumwater School District 530910002602 4500 A G West Black Hills High School   Regular School No High 09 12 2017   grade_11 173 7 14   2 9     2   19   115 111 0   4   2   52       10.0 226 173 7 14   2 9     2   19   115 111 0   4 2 52     10 226
631262 WA Thurston   school 5309100 34033   Tumwater School District 530910002602 4500 A G West Black Hills High School   Regular School No High 09 12 2017   grade_12 150 3 14   1 13     3   16   109 91 0   0   6   53       19.0 200 150 3 14   1 13     3   16   109 91 0   0 6 53     19 200
631263 WA Thurston   school 5309100 34033   Tumwater School District 530910002602 4500 A G West Black Hills High School   Regular School No High 09 12 2017   grade_8 0 0 1   0 0     0   0   1 0 0   0   1   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 1 1     0 1
631264 WA Thurston   school 5309100 34033   Tumwater School District 530910002602 4500 A G West Black Hills High School   Regular School No High 09 12 2017   grade_9 183 6 23   2 6     0   18   129 109 0   0   5   71       13.0 238 183 6 23   2 6     0   18   129 109 0   0 5 71     13 238
631265 WA Thurston   school 5309100 34033   Tumwater School District 530910002602 4500 A G West Black Hills High School   Regular School No High 09 12 2017   pk_12_total 653 21 72   6 35     5   73   457 408 0   5   17   234       52.0 865 653 21 72   6 35     5   73   457 408 0   5 17 234     52 865
617041 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_1 26 1 22   1 0     0   5   25 30 0   14   4   49       1.0 55 26 1 22   1 0     0   5   25 30 0   14 4 49     1 55
617042 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_2 38 0 38   3 0     0   5   42 42 0   24   4   71       0.0 84 38 0 38   3 0     0   5   42 42 0   24 4 71     0 84
617043 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_3 19 0 19   3 1     0   3   24 21 0   10   3   37       2.0 45 19 0 19   3 1     0   3   24 21 0   10 3 37     2 45
617044 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_4 38 0 22   0 2     0   2   29 35 0   9   4   51       4.0 64 38 0 22   0 2     0   2   29 35 0   9 4 51     4 64
617045 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_5 24 1 21   2 0     0   4   28 24 0   11   2   39       1.0 52 24 1 21   2 0     0   4   28 24 0   11 2 39     1 52
617046 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_6 16 0 19   1 1     0   3   24 16 0   6   1   33       0.0 40 16 0 19   1 1     0   3   24 16 0   6 1 33     0 40
617047 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_7 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
617048 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   pk_12_total 203 3 174   11 4     0   31   219 207 0   91   23   348       8.0 426 203 3 174   11 4     0   31   219 207 0   91 23 348     8 426
617049 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   kindergarten 30 0 23   1 0     0   7   32 29 0   16   5   47       0.0 61 30 0 23   1 0     0   7   32 29 0   16 5 47     0 61
617050 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 12 1 9   0 0     0   2   15 9 0   0   0   20       0.0 24 12 1 9   0 0     0   2   15 9 0   0 0 20     0 24
629735 WA Spokane   school 5308250 32081   Spokane School District 530825002361 1533 A-3 Multiagency Adolescent Prog   Regular School No High 09 12 2017   grade_10 5 1 0   0 0     0   0   2 4 0   0   0   6       1.0 6 5 1 0   0 0     0   0   2 4 0   0 0 6     1 6
629736 WA Spokane   school 5308250 32081   Spokane School District 530825002361 1533 A-3 Multiagency Adolescent Prog   Regular School No High 09 12 2017   grade_11 2 0 1   0 0     0   1   1 3 0   0   0   1       1.0 4 2 0 1   0 0     0   1   1 3 0   0 0 1     1 4
629737 WA Spokane   school 5308250 32081   Spokane School District 530825002361 1533 A-3 Multiagency Adolescent Prog   Regular School No High 09 12 2017   grade_12 4 0 0   0 0     0   1   2 3 0   0   0   3       1.0 5 4 0 0   0 0     0   1   2 3 0   0 0 3     1 5
629738 WA Spokane   school 5308250 32081   Spokane School District 530825002361 1533 A-3 Multiagency Adolescent Prog   Regular School No High 09 12 2017   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
629739 WA Spokane   school 5308250 32081   Spokane School District 530825002361 1533 A-3 Multiagency Adolescent Prog   Regular School No High 09 12 2017   pk_12_total 12 1 1   0 0     0   2   5 11 0   0   0   11       3.0 16 12 1 1   0 0     0   2   5 11 0   0 0 11     3 16
624982 WA Snohomish   school 5305430 31006   Mukilteo School District 530543002063 4247 ACES High School   Alternative School No High 09 12 2017   grade_10 10 0 3   0 0     0   1   10 4 0   0   0   7       3.0 14 10 0 3   0 0     0   1   10 4 0   0 0 7     3 14
624983 WA Snohomish   school 5305430 31006   Mukilteo School District 530543002063 4247 ACES High School   Alternative School No High 09 12 2017   grade_11 21 3 15   1 2     2   7   30 21 0   6   3   40       1.0 51 21 3 15   1 2     2   7   30 21 0   6 3 40     1 51
624984 WA Snohomish   school 5305430 31006   Mukilteo School District 530543002063 4247 ACES High School   Alternative School No High 09 12 2017   grade_12 51 5 51   1 3     1   9   71 50 0   15   4   87       5.0 121 51 5 51   1 3     1   9   71 50 0   15 4 87     5 121
624985 WA Snohomish   school 5305430 31006   Mukilteo School District 530543002063 4247 ACES High School   Alternative School No High 09 12 2017   pk_12_total 82 8 69   2 5     3   17   111 75 0   21   7   134       9.0 186 82 8 69   2 5     3   17   111 75 0   21 7 134     9 186
629274 WA Snohomish   school 5308020 31201   Snohomish School District 530802002068 4265 AIM High School   Alternative School No High 09 12 2017   grade_10 9 0 0   0 0     0   0   5 4 0   0   0   2       0.0 9 9 0 0   0 0     0   0   5 4 0   0 0 2     0 9
629275 WA Snohomish   school 5308020 31201   Snohomish School District 530802002068 4265 AIM High School   Alternative School No High 09 12 2017   grade_11 31 0 5   0 0     0   2   17 21 0   0   2   17       4.0 38 31 0 5   0 0     0   2   17 21 0   0 2 17     4 38
629276 WA Snohomish   school 5308020 31201   Snohomish School District 530802002068 4265 AIM High School   Alternative School No High 09 12 2017   grade_12 69 0 9   2 1     0   5   37 49 0   1   3   30       7.0 86 69 0 9   2 1     0   5   37 49 0   1 3 30     7 86
629277 WA Snohomish   school 5308020 31201   Snohomish School District 530802002068 4265 AIM High School   Alternative School No High 09 12 2017   grade_9 3 0 0   0 0     0   1   2 2 0   0   1   2       0.0 4 3 0 0   0 0     0   1   2 2 0   0 1 2     0 4
629278 WA Snohomish   school 5308020 31201   Snohomish School District 530802002068 4265 AIM High School   Alternative School No High 09 12 2017   pk_12_total 112 0 14   2 1     0   8   61 76 0   1   6   51       11.0 137 112 0 14   2 1     0   8   61 76 0   1 6 51     11 137
632066 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2017   grade_1 23 0 61   0 0     0   1   51 34 0   46   9   64       5.0 85 23 0 61   0 0     0   1   51 34 0   46 9 64     5 85
632067 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2017   grade_2 19 1 64   0 0     0   1   46 39 0   46   15   65       1.0 85 19 1 64   0 0     0   1   46 39 0   46 15 65     1 85
632068 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2017   grade_3 14 0 74   0 0     0   1   45 44 0   44   9   82       7.0 89 14 0 74   0 0     0   1   45 44 0   44 9 82     7 89
632069 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2017   grade_4 21 0 65   0 0     0   2   44 44 0   34   9   67       5.0 88 21 0 65   0 0     0   2   44 44 0   34 9 67     5 88
632070 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2017   grade_5 20 1 55   1 0     0   0   37 40 0   25   4   64       3.0 77 20 1 55   1 0     0   0   37 40 0   25 4 64     3 77
632071 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2017   pk_12_total 110 2 381   1 0     0   6   262 238 0   239   64   407       23.0 500 110 2 381   1 0     0   6   262 238 0   239 64 407     23 500
632072 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2017   kindergarten 13 0 62   0 0     0   1   39 37 0   44   18   65       2.0 76 13 0 62   0 0     0   1   39 37 0   44 18 65     2 76
621938 WA King   school 5303540 17401   Highline School District 530354003069 5063 Academy of Citizenship and Empowerment (Closed after 2016-2017 school year)   Regular School No High 09 12 2017   grade_10 10 23 56   3 13     11   4   61 59 0   40   16   108       5.0 120 10 23 56   3 13     11   4   61 59 0   40 16 108     5 120
621939 WA King   school 5303540 17401   Highline School District 530354003069 5063 Academy of Citizenship and Empowerment (Closed after 2016-2017 school year)   Regular School No High 09 12 2017   grade_11 15 26 36   0 22     8   6   57 56 0   29   19   88       1.0 113 15 26 36   0 22     8   6   57 56 0   29 19 88     1 113
621940 WA King   school 5303540 17401   Highline School District 530354003069 5063 Academy of Citizenship and Empowerment (Closed after 2016-2017 school year)   Regular School No High 09 12 2017   grade_12 16 24 44   2 10     11   6   58 55 0   39   25   101       2.0 113 16 24 44   2 10     11   6   58 55 0   39 25 101     2 113
621941 WA King   school 5303540 17401   Highline School District 530354003069 5063 Academy of Citizenship and Empowerment (Closed after 2016-2017 school year)   Regular School No High 09 12 2017   grade_9 9 18 56   3 17     18   3   65 59 0   36   12   112       1.0 124 9 18 56   3 17     18   3   65 59 0   36 12 112     1 124
621942 WA King   school 5303540 17401   Highline School District 530354003069 5063 Academy of Citizenship and Empowerment (Closed after 2016-2017 school year)   Regular School No High 09 12 2017   pk_12_total 50 91 192   8 62     48   19   241 229 0   144   72   409       9.0 470 50 91 192   8 62     48   19   241 229 0   144 72 409     9 470
624097 WA Snohomish   school 5304860 31025   Marysville School District 530486003325 5209 Academy of Const and Engineering (Closed after 2016-2017 school year)   Regular School No High 09 12 2017   grade_10 52 3 29   3 14     1   11   92 21 0   5   5   53       1.0 113 52 3 29   3 14     1   11   92 21 0   5 5 53     1 113
624098 WA Snohomish   school 5304860 31025   Marysville School District 530486003325 5209 Academy of Const and Engineering (Closed after 2016-2017 school year)   Regular School No High 09 12 2017   grade_11 41 0 18   4 1     1   10   60 15 0   7   0   34       1.0 75 41 0 18   4 1     1   10   60 15 0   7 0 34     1 75
624099 WA Snohomish   school 5304860 31025   Marysville School District 530486003325 5209 Academy of Const and Engineering (Closed after 2016-2017 school year)   Regular School No High 09 12 2017   grade_12 41 0 25   3 10     2   6   64 23 0   6   2   41       1.0 87 41 0 25   3 10     2   6   64 23 0   6 2 41     1 87
624100 WA Snohomish   school 5304860 31025   Marysville School District 530486003325 5209 Academy of Const and Engineering (Closed after 2016-2017 school year)   Regular School No High 09 12 2017   grade_9 68 0 23   3 6     2   13   90 25 0   8   4   60       6.0 115 68 0 23   3 6     2   13   90 25 0   8 4 60     6 115
624101 WA Snohomish   school 5304860 31025   Marysville School District 530486003325 5209 Academy of Const and Engineering (Closed after 2016-2017 school year)   Regular School No High 09 12 2017   pk_12_total 202 3 95   13 31     6   40   306 84 0   26   11   188       9.0 390 202 3 95   13 31     6   40   306 84 0   26 11 188     9 390
618018 WA Pierce   school 5300480 27403   Bethel School District 530048003466 5372 Acceleration Academy   Alternative School No High 09 12 2017   grade_10 2 1 0   0 0     0   0   1 2 0   0   1   3       0.0 3 2 1 0   0 0     0   0   1 2 0   0 1 3     0 3
618019 WA Pierce   school 5300480 27403   Bethel School District 530048003466 5372 Acceleration Academy   Alternative School No High 09 12 2017   grade_11 37 8 14   3 0     2   2   40 26 0   3   3   40       7.0 66 37 8 14   3 0     2   2   40 26 0   3 3 40     7 66
618020 WA Pierce   school 5300480 27403   Bethel School District 530048003466 5372 Acceleration Academy   Alternative School No High 09 12 2017   grade_12 81 23 16   2 8     6   22   87 71 0   2   3   93       8.0 158 81 23 16   2 8     6   22   87 71 0   2 3 93     8 158
618021 WA Pierce   school 5300480 27403   Bethel School District 530048003466 5372 Acceleration Academy   Alternative School No High 09 12 2017   pk_12_total 120 32 30   5 8     8   24   128 99 0   5   7   136       15.0 227 120 32 30   5 8     8   24   128 99 0   5 7 136     15 227
624813 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2017   grade_1 31 0 8   3 0     0   7   26 23 0   1   0   21       0.0 49 31 0 8   3 0     0   7   26 23 0   1 0 21     0 49
624814 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2017   grade_2 18 0 2   5 0     0   9   21 13 0   1   1   22       0.0 34 18 0 2   5 0     0   9   21 13 0   1 1 22     0 34
624815 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2017   grade_3 25 1 1   2 0     0   5   13 21 0   0   1   20       1.0 34 25 1 1   2 0     0   5   13 21 0   0 1 20     1 34
624816 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2017   grade_4 23 0 3   1 0     0   6   16 17 0   4   0   15       1.0 33 23 0 3   1 0     0   6   16 17 0   4 0 15     1 33
624817 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2017   grade_5 16 0 1   5 0     0   1   11 12 0   4   0   12       3.0 23 16 0 1   5 0     0   1   11 12 0   4 0 12     3 23
624818 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2017   grade_6 32 0 5   4 0     0   3   27 17 0   4   2   24       1.0 44 32 0 5   4 0     0   3   27 17 0   4 2 24     1 44
624819 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2017   pk_12_total 164 1 22   21 0     0   33   130 111 0   15   4   125       6.0 241 164 1 22   21 0     0   33   130 111 0   15 4 125     6 241
624820 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2017   kindergarten 19 0 2   1 0     0   2   16 8 0   1   0   11       0.0 24 19 0 2   1 0     0   2   16 8 0   1 0 11     0 24
618816 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2017   grade_1 55 2 8   1 5     0   8   37 42 0   7   1   43       1.0 79 55 2 8   1 5     0   8   37 42 0   7 1 43     1 79
618817 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2017   grade_2 70 0 18   2 4     1   4   52 47 0   10   1   50       3.0 99 70 0 18   2 4     1   4   52 47 0   10 1 50     3 99
618818 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2017   grade_3 74 2 8   1 3     1   4   50 43 0   7   2   53       3.0 93 74 2 8   1 3     1   4   50 43 0   7 2 53     3 93
618819 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2017   grade_4 60 0 11   0 3     2   2   48 30 0   5   2   44       5.0 78 60 0 11   0 3     2   2   48 30 0   5 2 44     5 78
618820 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2017   grade_5 74 0 6   2 1     0   1   45 39 0   7   0   51       3.0 84 74 0 6   2 1     0   1   45 39 0   7 0 51     3 84
618821 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2017   pk_12_total 403 8 61   8 19     4   25   279 249 0   44   7   288       15.0 528 403 8 61   8 19     4   25   279 249 0   44 7 288     15 528
618822 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2017   kindergarten 59 4 9   2 3     0   4   38 43 0   8   1   46       0.0 81 59 4 9   2 3     0   4   38 43 0   8 1 46     0 81
618823 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 11 0 1   0 0     0   2   9 5 0   0   0   1       0.0 14 11 0 1   0 0     0   2   9 5 0   0 0 1     0 14
629740 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2017   grade_1 32 0 9   2 3     0   9   31 24 0   3   2   29       2.0 55 32 0 9   2 3     0   9   31 24 0   3 2 29     2 55
629741 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2017   grade_2 32 0 5   1 0     0   12   21 29 0   5   2   36       3.0 50 32 0 5   1 0     0   12   21 29 0   5 2 36     3 50
629742 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2017   grade_3 28 0 7   1 3     0   11   21 29 0   6   1   38       0.0 50 28 0 7   1 3     0   11   21 29 0   6 1 38     0 50
629743 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2017   grade_4 27 2 4   0 0     0   8   20 21 0   0   0   28       4.0 41 27 2 4   0 0     0   8   20 21 0   0 0 28     4 41
629744 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2017   grade_5 24 2 6   1 2     1   11   22 25 0   2   2   40       3.0 47 24 2 6   1 2     1   11   22 25 0   2 2 40     3 47
629745 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2017   grade_6 24 2 11   1 1     0   9   22 26 0   1   3   35       4.0 48 24 2 11   1 1     0   9   22 26 0   1 3 35     4 48
629746 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2017   pk_12_total 212 8 53   6 10     4   64   169 188 0   22   11   247       18.0 357 212 8 53   6 10     4   64   169 188 0   22 11 247     18 357
629747 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2017   kindergarten 41 2 10   0 1     3   4   27 34 0   5   1   40       2.0 61 41 2 10   0 1     3   4   27 34 0   5 1 40     2 61
629748 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten 4 0 1   0 0     0   0   5 0 0   0   0   1       0.0 5 4 0 1   0 0     0   0   5 0 0   0 0 1     0 5
631892 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary PK 05 2017   grade_1 2 0 34   14 0     0   2   28 24 0   21   7   52       0.0 52 2 0 34   14 0     0   2   28 24 0   21 7 52     0 52
631893 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary PK 05 2017   grade_2 2 0 28   8 1     0   0   24 15 0   16   4   39       0.0 39 2 0 28   8 1     0   0   24 15 0   16 4 39     0 39
631894 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary PK 05 2017   grade_3 4 0 46   11 0     0   4   32 33 0   25   5   61       0.0 65 4 0 46   11 0     0   4   32 33 0   25 5 61     0 65
631895 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary PK 05 2017   grade_4 3 0 37   7 2     0   2   30 21 0   20   1   47       1.0 51 3 0 37   7 2     0   2   30 21 0   20 1 47     1 51
631896 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary PK 05 2017   grade_5 1 0 43   11 0     0   1   33 23 0   18   4   52       2.0 56 1 0 43   11 0     0   1   33 23 0   18 4 52     2 56
631897 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary PK 05 2017   pk_12_total 18 0 276   73 3     1   13   221 163 0   117   32   360       3.0 384 18 0 276   73 3     1   13   221 163 0   117 32 360     3 384
631898 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary PK 05 2017   kindergarten 2 0 27   6 0     0   3   24 14 0   17   6   35       0.0 38 2 0 27   6 0     0   3   24 14 0   17 6 35     0 38
631899 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten 4 0 61   16 0     1   1   50 33 0   0   5   74       0.0 83 4 0 61   16 0     1   1   50 33 0   0 5 74     0 83

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