Data source: Big Local News · About: Big Local

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

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
2419962 WA Snohomish   school 5304860 31025   Marysville School District 530486002475 1656 10th Street School   Regular School No Middle 06 08 2019   grade_6 32 0 13   3 3     0   7   28 30 0   1   0   16       3.0 58 32 0 13   3 3     0   7   28 30 0   1 0 16     3 58
2419963 WA Snohomish   school 5304860 31025   Marysville School District 530486002475 1656 10th Street School   Regular School No Middle 06 08 2019   grade_7 32 1 7   6 3     0   8   25 32 0   3   0   18       3.0 57 32 1 7   6 3     0   8   25 32 0   3 0 18     3 57
2419964 WA Snohomish   school 5304860 31025   Marysville School District 530486002475 1656 10th Street School   Regular School No Middle 06 08 2019   grade_8 38 1 8   0 2     0   9   30 28 0   3   0   12       3.0 58 38 1 8   0 2     0   9   30 28 0   3 0 12     3 58
2419965 WA Snohomish   school 5304860 31025   Marysville School District 530486002475 1656 10th Street School   Regular School No Middle 06 08 2019   pk_12_total 102 2 28   9 8     0   24   83 90 0   7   0   46       9.0 173 102 2 28   9 8     0   24   83 90 0   7 0 46     9 173
2416826 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2019   grade_10 1 0 1   1 0     0   0   3 0 0   0   0   2       0.0 3 1 0 1   1 0     0   0   3 0 0   0 0 2     0 3
2416827 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2019   grade_11 3 1 0   0 0     0   0   4 0 0   0   0   2       0.0 4 3 1 0   0 0     0   0   4 0 0   0 0 2     0 4
2416828 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2019   grade_12 35 7 8   2 9     0   4   46 19 0   6   0   33       0.0 65 35 7 8   2 9     0   4   46 19 0   6 0 33     0 65
2416829 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2019   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
2416830 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2019   grade_3 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
2416831 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2019   grade_4 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
2416832 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2019   grade_5 1 1 1   0 0     1   0   4 0 0   0   1   3       0.0 4 1 1 1   0 0     1   0   4 0 0   0 1 3     0 4
2416833 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2019   grade_6 3 0 1   0 0     1   1   6 0 0   0   1   6       0.0 6 3 0 1   0 0     1   1   6 0 0   0 1 6     0 6
2416834 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2019   grade_7 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
2416835 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2019   grade_8 2 1 0   0 0     0   0   3 0 0   0   1   2       0.0 3 2 1 0   0 0     0   0   3 0 0   0 1 2     0 3
2416836 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2019   grade_9 2 1 1   0 0     0   0   4 0 0   0   0   4       0.0 4 2 1 1   0 0     0   0   4 0 0   0 0 4     0 4
2416837 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No Other KG 12 2019   pk_12_total 50 11 13   3 9     2   7   74 21 0   6   3   58       0.0 95 50 11 13   3 9     2   7   74 21 0   6 3 58     0 95
2426977 WA Thurston   school 5309100 34033   Tumwater School District 530910002602 4500 A G West Black Hills High School   Regular School No High 09 12 2019   grade_10 143 5 29   2 12     3   34   108 120 0   6   3   62       20.0 228 143 5 29   2 12     3   34   108 120 0   6 3 62     20 228
2426978 WA Thurston   school 5309100 34033   Tumwater School District 530910002602 4500 A G West Black Hills High School   Regular School No High 09 12 2019   grade_11 162 6 22   1 6     0   13   102 108 0   2   6   51       11.0 210 162 6 22   1 6     0   13   102 108 0   2 6 51     11 210
2426979 WA Thurston   school 5309100 34033   Tumwater School District 530910002602 4500 A G West Black Hills High School   Regular School No High 09 12 2019   grade_12 139 2 18   1 7     0   21   96 92 0   0   9   43       9.0 188 139 2 18   1 7     0   21   96 92 0   0 9 43     9 188
2426980 WA Thurston   school 5309100 34033   Tumwater School District 530910002602 4500 A G West Black Hills High School   Regular School No High 09 12 2019   grade_9 166 5 22   2 6     2   24   113 114 0   2   3   75       11.0 227 166 5 22   2 6     2   24   113 114 0   2 3 75     11 227
2426981 WA Thurston   school 5309100 34033   Tumwater School District 530910002602 4500 A G West Black Hills High School   Regular School No High 09 12 2019   pk_12_total 610 18 91   6 31     5   92   419 434 0   10   21   231       51.0 853 610 18 91   6 31     5   92   419 434 0   10 21 231     51 853
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
2425417 WA Spokane   school 5308250 32081   Spokane School District 530825002361 1533 A-3 Multiagency Adolescent Prog   Regular School No High 08 12 2019   grade_10 2 0 2   0 0     0   0   1 3 0   0   1   4       1.0 4 2 0 2   0 0     0   0   1 3 0   0 1 4     1 4
2425418 WA Spokane   school 5308250 32081   Spokane School District 530825002361 1533 A-3 Multiagency Adolescent Prog   Regular School No High 08 12 2019   grade_11 4 0 0   0 0     0   1   2 3 0   0   1   3       1.0 5 4 0 0   0 0     0   1   2 3 0   0 1 3     1 5
2425419 WA Spokane   school 5308250 32081   Spokane School District 530825002361 1533 A-3 Multiagency Adolescent Prog   Regular School No High 08 12 2019   grade_12 7 2 0   0 0     0   0   4 5 0   0   0   8       0.0 9 7 2 0   0 0     0   0   4 5 0   0 0 8     0 9
2425420 WA Spokane   school 5308250 32081   Spokane School District 530825002361 1533 A-3 Multiagency Adolescent Prog   Regular School No High 08 12 2019   grade_8 2 1 0   0 0     0   0   1 2 0   0   0   2       2.0 3 2 1 0   0 0     0   0   1 2 0   0 0 2     2 3
2425421 WA Spokane   school 5308250 32081   Spokane School District 530825002361 1533 A-3 Multiagency Adolescent Prog   Regular School No High 08 12 2019   grade_9 4 0 1   0 0     0   0   3 2 0   0   0   3       1.0 5 4 0 1   0 0     0   0   3 2 0   0 0 3     1 5
2425422 WA Spokane   school 5308250 32081   Spokane School District 530825002361 1533 A-3 Multiagency Adolescent Prog   Regular School No High 08 12 2019   pk_12_total 19 3 3   0 0     0   1   11 15 0   0   2   20       5.0 26 19 3 3   0 0     0   1   11 15 0   0 2 20     5 26
2420796 WA Snohomish   school 5305430 31006   Mukilteo School District 530543002063 4247 ACES High School   Alternative School No High 09 12 2019   grade_10 10 1 13   0 3     1   1   11 18 0   4   3   22       4.0 29 10 1 13   0 3     1   1   11 18 0   4 3 22     4 29
2420797 WA Snohomish   school 5305430 31006   Mukilteo School District 530543002063 4247 ACES High School   Alternative School No High 09 12 2019   grade_11 18 4 17   0 2     1   7   27 22 0   4   6   30       0.0 49 18 4 17   0 2     1   7   27 22 0   4 6 30     0 49
2420798 WA Snohomish   school 5305430 31006   Mukilteo School District 530543002063 4247 ACES High School   Alternative School No High 09 12 2019   grade_12 34 10 28   1 3     1   9   40 46 0   6   12   56       2.0 86 34 10 28   1 3     1   9   40 46 0   6 12 56     2 86
2420799 WA Snohomish   school 5305430 31006   Mukilteo School District 530543002063 4247 ACES High School   Alternative School No High 09 12 2019   pk_12_total 62 15 58   1 8     3   17   78 86 0   14   21   108       6.0 164 62 15 58   1 8     3   17   78 86 0   14 21 108     6 164
2424979 WA Snohomish   school 5308020 31201   Snohomish School District 530802002068 4265 AIM High School   Alternative School No High 09 12 2019   grade_10 17 0 2   0 0     0   2   10 11 0   0   0   3       5.0 21 17 0 2   0 0     0   2   10 11 0   0 0 3     5 21
2424980 WA Snohomish   school 5308020 31201   Snohomish School District 530802002068 4265 AIM High School   Alternative School No High 09 12 2019   grade_11 27 0 1   0 0     0   0   14 14 0   1   0   10       2.0 28 27 0 1   0 0     0   0   14 14 0   1 0 10     2 28
2424981 WA Snohomish   school 5308020 31201   Snohomish School District 530802002068 4265 AIM High School   Alternative School No High 09 12 2019   grade_12 76 1 10   1 0     0   4   55 37 0   2   3   28       14.0 92 76 1 10   1 0     0   4   55 37 0   2 3 28     14 92
2424982 WA Snohomish   school 5308020 31201   Snohomish School District 530802002068 4265 AIM High School   Alternative School No High 09 12 2019   grade_9 5 0 0   0 0     0   0   2 3 0   0   0   0       0.0 5 5 0 0   0 0     0   0   2 3 0   0 0 0     0 5
2424983 WA Snohomish   school 5308020 31201   Snohomish School District 530802002068 4265 AIM High School   Alternative School No High 09 12 2019   pk_12_total 125 1 13   1 0     0   6   81 65 0   3   3   41       21.0 146 125 1 13   1 0     0   6   81 65 0   3 3 41     21 146
2427746 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2019   grade_1 24 0 59   0 0     0   0   45 38 0   44   4   68       3.0 83 24 0 59   0 0     0   0   45 38 0   44 4 68     3 83
2427747 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2019   grade_2 17 0 71   0 1     0   0   46 43 0   49   15   75       2.0 89 17 0 71   0 1     0   0   46 43 0   49 15 75     2 89
2427748 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2019   grade_3 29 0 63   0 1     0   1   56 38 0   42   8   69       1.0 94 29 0 63   0 1     0   1   56 38 0   42 8 69     1 94
2427749 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2019   grade_4 20 1 70   0 0     0   1   47 45 0   35   8   76       1.0 92 20 1 70   0 0     0   1   47 45 0   35 8 76     1 92
2427750 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2019   grade_5 20 0 65   0 1     0   1   47 40 0   38   10   76       2.0 87 20 0 65   0 1     0   1   47 40 0   38 10 76     2 87
2427751 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2019   pk_12_total 130 1 384   0 3     0   4   282 240 0   249   52   413       9.0 522 130 1 384   0 3     0   4   282 240 0   249 52 413     9 522
2427752 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2019   kindergarten 20 0 56   0 0     0   1   41 36 0   41   7   49       0.0 77 20 0 56   0 0     0   1   41 36 0   41 7 49     0 77
2413970 WA Pierce   school 5300480 27403   Bethel School District 530048003466 5372 Acceleration Academy   Alternative School No High 09 12 2019   grade_10 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
2413971 WA Pierce   school 5300480 27403   Bethel School District 530048003466 5372 Acceleration Academy   Alternative School No High 09 12 2019   grade_11 13 4 6   1 0     0   2   16 10 0   0   3   9       1.0 26 13 4 6   1 0     0   2   16 10 0   0 3 9     1 26
2413972 WA Pierce   school 5300480 27403   Bethel School District 530048003466 5372 Acceleration Academy   Alternative School No High 09 12 2019   grade_12 116 19 26   6 6     3   8   105 79 0   7   8   70       6.0 184 116 19 26   6 6     3   8   105 79 0   7 8 70     6 184
2413973 WA Pierce   school 5300480 27403   Bethel School District 530048003466 5372 Acceleration Academy   Alternative School No High 09 12 2019   pk_12_total 129 23 33   7 6     3   10   122 89 0   7   11   80       7.0 211 129 23 33   7 6     3   10   122 89 0   7 11 80     7 211
2420637 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2019   grade_1 19 1 1   6 0     0   6   18 15 0   7   0   17       1.0 33 19 1 1   6 0     0   6   18 15 0   7 0 17     1 33
2420638 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2019   grade_2 19 0 1   3 0     0   1   14 10 0   3   0   12       0.0 24 19 0 1   3 0     0   1   14 10 0   3 0 12     0 24
2420639 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2019   grade_3 30 0 6   2 0     0   8   27 19 0   5   0   25       0.0 46 30 0 6   2 0     0   8   27 19 0   5 0 25     0 46
2420640 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2019   grade_4 18 0 3   5 0     0   8   19 15 0   4   1   21       1.0 34 18 0 3   5 0     0   8   19 15 0   4 1 21     1 34
2420641 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2019   grade_5 25 1 1   2 0     0   5   13 21 0   3   2   19       1.0 34 25 1 1   2 0     0   5   13 21 0   3 2 19     1 34
2420642 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2019   grade_6 20 0 4   2 0     0   5   14 17 0   5   2   17       2.0 31 20 0 4   2 0     0   5   14 17 0   5 2 17     2 31
2420643 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2019   pk_12_total 153 2 20   25 1     0   35   122 114 0   31   6   128       5.0 236 153 2 20   25 1     0   35   122 114 0   31 6 128     5 236
2420644 WA Whatcom   school 5305310 37507   Mount Baker School District 530531000799 2585 Acme Elementary   Regular School No Elementary KG 06 2019   kindergarten 22 0 4   5 1     0   2   17 17 0   4   1   17       0.0 34 22 0 4   5 1     0   2   17 17 0   4 1 17     0 34
2414743 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2019   grade_1 39 4 0   0 3     1   7   29 25 0   4   0   26       0.0 54 39 4 0   0 3     1   7   29 25 0   4 0 26     0 54
2414744 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2019   grade_2 44 2 1   1 1     1   2   29 23 0   3   0   33       1.0 52 44 2 1   1 1     1   2   29 23 0   3 0 33     1 52
2414745 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2019   grade_3 52 3 1   2 3     1   7   30 39 0   2   1   35       1.0 69 52 3 1   2 3     1   7   30 39 0   2 1 35     1 69
2414746 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2019   grade_4 62 2 2   2 3     2   3   40 36 0   3   1   40       3.0 76 62 2 2   2 3     2   3   40 36 0   3 1 40     3 76
2414747 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2019   grade_5 72 1 0   1 1     0   3   40 38 0   3   1   42       0.0 78 72 1 0   1 1     0   3   40 38 0   3 1 42     0 78
2414748 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2019   pk_12_total 334 14 6   6 16     6   27   213 196 0   21   4   213       5.0 409 334 14 6   6 16     6   27   213 196 0   21 4 213     5 409
2414749 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2019   kindergarten 55 2 2   0 2     1   4   37 29 0   6   1   35       0.0 66 55 2 2   0 2     1   4   37 29 0   6 1 35     0 66
2414750 WA Spokane   school 5301110 32356   Central Valley School District 530111000187 3259 Adams Elementary   Regular School No Elementary PK 05 2019   pre_kindergarten 10 0 0   0 3     0   1   8 6 0   0   0   2       0.0 14 10 0 0   0 3     0   1   8 6 0   0 0 2     0 14
2425423 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2019   grade_1 40 5 5   1 1     1   9   38 24 0   8   2   42       2.0 62 40 5 5   1 1     1   9   38 24 0   8 2 42     2 62
2425424 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2019   grade_2 36 4 5   1 2     0   6   20 34 0   2   2   40       2.0 54 36 4 5   1 2     0   6   20 34 0   2 2 40     2 54
2425425 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2019   grade_3 27 1 9   0 2     0   8   26 21 0   5   1   30       2.0 47 27 1 9   0 2     0   8   26 21 0   5 1 30     2 47
2425426 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2019   grade_4 37 0 4   0 0     0   10   20 31 0   3   0   33       4.0 51 37 0 4   0 0     0   10   20 31 0   3 0 33     4 51
2425427 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2019   grade_5 29 1 4   0 1     0   12   18 29 0   5   0   37       0.0 47 29 1 4   0 1     0   12   18 29 0   5 0 37     0 47
2425428 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2019   grade_6 38 2 7   0 0     0   7   27 27 0   1   3   39       4.0 54 38 2 7   0 0     0   7   27 27 0   1 3 39     4 54
2425429 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2019   pk_12_total 257 15 40   4 8     1   61   183 203 0   31   9   269       18.0 386 257 15 40   4 8     1   61   183 203 0   31 9 269     18 386
2425430 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2019   kindergarten 48 2 6   2 2     0   9   34 35 0   7   1   47       4.0 69 48 2 6   2 2     0   9   34 35 0   7 1 47     4 69
2425431 WA Spokane   school 5308250 32081   Spokane School District 530825001361 2156 Adams Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten 2 0 0   0 0     0   0   0 2 0   0   0   1       0.0 2 2 0 0   0 0     0   0   0 2 0   0 0 1     0 2
2427586 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary 03 05 2019   grade_3 1 0 106   17 2     0   7   64 69 0   77   9   126       0.0 133 1 0 106   17 2     0   7   64 69 0   77 9 126     0 133
2427587 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary 03 05 2019   grade_4 0 0 103   23 3     0   0   74 55 0   76   7   126       1.0 129 0 0 103   23 3     0   0   74 55 0   76 7 126     1 129
2427588 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary 03 05 2019   grade_5 2 0 109   28 2     0   8   91 58 0   79   7   141       0.0 149 2 0 109   28 2     0   8   91 58 0   79 7 141     0 149
2427589 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary 03 05 2019   pk_12_total 3 0 318   68 7     0   15   229 182 0   232   23   393       1.0 411 3 0 318   68 7     0   15   229 182 0   232 23 393     1 411
2423863 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2019   grade_1 62 1 2   0 1     0   12   38 40 0   7   1   3       1.0 78 62 1 2   0 1     0   12   38 40 0   7 1 3     1 78
2423864 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2019   grade_2 67 3 8   0 1     0   11   48 42 0   4   0   7       0.0 90 67 3 8   0 1     0   11   48 42 0   4 0 7     0 90
2423865 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2019   grade_3 68 2 12   1 2     0   11   48 48 0   4   4   22       1.0 96 68 2 12   1 2     0   11   48 48 0   4 4 22     1 96
2423866 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2019   grade_4 64 3 9   1 0     0   12   42 47 0   3   3   17       4.0 89 64 3 9   1 0     0   12   42 47 0   3 3 17     4 89
2423867 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2019   grade_5 69 6 12   0 2     0   10   50 49 0   9   4   16       3.0 99 69 6 12   0 2     0   10   50 49 0   9 4 16     3 99
2423868 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2019   pk_12_total 392 18 49   3 9     0   65   270 266 0   36   13   71       9.0 536 392 18 49   3 9     0   65   270 266 0   36 13 71     9 536
2423869 WA King   school 5307710 17001   Seattle School District No. 1 530771001127 2138 Adams Elementary School   Regular School No Elementary KG 05 2019   kindergarten 62 3 6   1 3     0   9   44 40 0   9   1   6       0.0 84 62 3 6   1 3     0   9   44 40 0   9 1 6     0 84
2428213 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_1 3 0 102   0 0     0   0   52 53 0   84   1   101       1.0 105 3 0 102   0 0     0   0   52 53 0   84 1 101     1 105
2428214 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_2 1 0 98   0 0     0   0   56 43 0   71   1   94       2.0 99 1 0 98   0 0     0   0   56 43 0   71 1 94     2 99
2428215 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_3 3 0 106   0 0     0   0   59 50 0   58   1   105       1.0 109 3 0 106   0 0     0   0   59 50 0   58 1 105     1 109
2428216 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_4 8 0 109   0 0     0   1   65 53 0   67   3   113       1.0 118 8 0 109   0 0     0   1   65 53 0   67 3 113     1 118
2428217 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_5 4 0 113   2 1     0   1   57 64 0   57   1   116       4.0 121 4 0 113   2 1     0   1   57 64 0   57 1 116     4 121
2428218 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2019   pk_12_total 24 0 688   2 1     0   2   372 345 0   435   8   689       13.0 717 24 0 688   2 1     0   2   372 345 0   435 8 689     13 717
2428219 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2019   kindergarten 3 0 109   0 0     0   0   60 52 0   98   0   107       3.0 112 3 0 109   0 0     0   0   60 52 0   98 0 107     3 112

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