ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

10,823 rows where county = "Washington" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

county

  • Washington · 10,823 ✖
Link rowid date ▲ county state fips cases deaths
1095763 1095763 2021-03-07 Washington Alabama 1129 1571 36
1095881 1095881 2021-03-07 Washington Arkansas 5143 29603 329
1096004 1096004 2021-03-07 Washington Colorado 8121 398 12
1096088 1096088 2021-03-07 Washington Florida 12133 2638 48
1096239 1096239 2021-03-07 Washington Georgia 13303 2083 72
1096298 1096298 2021-03-07 Washington Idaho 16087 1178 21
1096394 1096394 2021-03-07 Washington Illinois 17189 1588 30
1096489 1096489 2021-03-07 Washington Indiana 18175 2133 27
1096586 1096586 2021-03-07 Washington Iowa 19183 2370 47
1096695 1096695 2021-03-07 Washington Kansas 20201 528 9
1096814 1096814 2021-03-07 Washington Kentucky 21229 1355 30
1096879 1096879 2021-03-07 Washington Louisiana 22117 4130 122
1096900 1096900 2021-03-07 Washington Maine 23029 726 14
1096924 1096924 2021-03-07 Washington Maryland 24043 12522 258
1097108 1097108 2021-03-07 Washington Minnesota 27163 22247 262
1097189 1097189 2021-03-07 Washington Mississippi 28151 5235 130
1097308 1097308 2021-03-07 Washington Missouri 29221 2122 48
1097457 1097457 2021-03-07 Washington Nebraska 31177 2026 21
1097599 1097599 2021-03-07 Washington New York 36115 2406 54
1097697 1097697 2021-03-07 Washington North Carolina 37187 999 31
1097844 1097844 2021-03-07 Washington Ohio 39167 4755 96
1097923 1097923 2021-03-07 Washington Oklahoma 40147 4881 89
1097960 1097960 2021-03-07 Washington Oregon 41067 21400 218
1098025 1098025 2021-03-07 Washington Pennsylvania 42125 13926 265
1098114 1098114 2021-03-07 Washington Rhode Island 44009 7867 160
1098317 1098317 2021-03-07 Washington Tennessee 47179 12856 234
1098561 1098561 2021-03-07 Washington Texas 48477 3688 84
1098604 1098604 2021-03-07 Washington Utah 49053 20189 184
1098619 1098619 2021-03-07 Washington Vermont 50023 1467 14
1098750 1098750 2021-03-07 Washington Virginia 51191 4311 99
1098918 1098918 2021-03-07 Washington Wisconsin 55131 15642 144
1092517 1092517 2021-03-06 Washington Alabama 1129 1570 36
1092635 1092635 2021-03-06 Washington Arkansas 5143 29598 329
1092758 1092758 2021-03-06 Washington Colorado 8121 398 12
1092842 1092842 2021-03-06 Washington Florida 12133 2637 48
1092993 1092993 2021-03-06 Washington Georgia 13303 2083 72
1093052 1093052 2021-03-06 Washington Idaho 16087 1178 21
1093148 1093148 2021-03-06 Washington Illinois 17189 1587 30
1093243 1093243 2021-03-06 Washington Indiana 18175 2130 27
1093340 1093340 2021-03-06 Washington Iowa 19183 2370 47
1093449 1093449 2021-03-06 Washington Kansas 20201 528 9
1093568 1093568 2021-03-06 Washington Kentucky 21229 1354 30
1093633 1093633 2021-03-06 Washington Louisiana 22117 4124 122
1093653 1093653 2021-03-06 Washington Maine 23029 726 14
1093677 1093677 2021-03-06 Washington Maryland 24043 12503 257
1093861 1093861 2021-03-06 Washington Minnesota 27163 22208 262
1093942 1093942 2021-03-06 Washington Mississippi 28151 5232 130
1094061 1094061 2021-03-06 Washington Missouri 29221 2122 48
1094210 1094210 2021-03-06 Washington Nebraska 31177 2023 21
1094351 1094351 2021-03-06 Washington New York 36115 2397 54
1094449 1094449 2021-03-06 Washington North Carolina 37187 999 31
1094596 1094596 2021-03-06 Washington Ohio 39167 4743 96
1094675 1094675 2021-03-06 Washington Oklahoma 40147 4877 89
1094712 1094712 2021-03-06 Washington Oregon 41067 21377 218
1094777 1094777 2021-03-06 Washington Pennsylvania 42125 13904 264
1094866 1094866 2021-03-06 Washington Rhode Island 44009 7867 160
1095069 1095069 2021-03-06 Washington Tennessee 47179 12840 234
1095313 1095313 2021-03-06 Washington Texas 48477 3688 84
1095356 1095356 2021-03-06 Washington Utah 49053 20189 184
1095371 1095371 2021-03-06 Washington Vermont 50023 1457 14
1095502 1095502 2021-03-06 Washington Virginia 51191 4307 99
1095670 1095670 2021-03-06 Washington Wisconsin 55131 15635 144
1089271 1089271 2021-03-05 Washington Alabama 1129 1568 36
1089389 1089389 2021-03-05 Washington Arkansas 5143 29561 329
1089512 1089512 2021-03-05 Washington Colorado 8121 396 12
1089596 1089596 2021-03-05 Washington Florida 12133 2636 48
1089747 1089747 2021-03-05 Washington Georgia 13303 2081 71
1089806 1089806 2021-03-05 Washington Idaho 16087 1178 21
1089902 1089902 2021-03-05 Washington Illinois 17189 1587 30
1089997 1089997 2021-03-05 Washington Indiana 18175 2130 27
1090094 1090094 2021-03-05 Washington Iowa 19183 2370 47
1090203 1090203 2021-03-05 Washington Kansas 20201 528 9
1090322 1090322 2021-03-05 Washington Kentucky 21229 1350 30
1090387 1090387 2021-03-05 Washington Louisiana 22117 4124 122
1090407 1090407 2021-03-05 Washington Maine 23029 726 14
1090431 1090431 2021-03-05 Washington Maryland 24043 12487 257
1090615 1090615 2021-03-05 Washington Minnesota 27163 22183 261
1090696 1090696 2021-03-05 Washington Mississippi 28151 5229 130
1090815 1090815 2021-03-05 Washington Missouri 29221 2122 48
1090964 1090964 2021-03-05 Washington Nebraska 31177 2020 21
1091105 1091105 2021-03-05 Washington New York 36115 2380 54
1091203 1091203 2021-03-05 Washington North Carolina 37187 997 31
1091350 1091350 2021-03-05 Washington Ohio 39167 4736 96
1091429 1091429 2021-03-05 Washington Oklahoma 40147 4848 89
1091466 1091466 2021-03-05 Washington Oregon 41067 21364 218
1091531 1091531 2021-03-05 Washington Pennsylvania 42125 13863 262
1091620 1091620 2021-03-05 Washington Rhode Island 44009 7867 160
1091823 1091823 2021-03-05 Washington Tennessee 47179 12834 234
1092067 1092067 2021-03-05 Washington Texas 48477 3684 84
1092110 1092110 2021-03-05 Washington Utah 49053 20189 184
1092125 1092125 2021-03-05 Washington Vermont 50023 1455 14
1092256 1092256 2021-03-05 Washington Virginia 51191 4301 99
1092424 1092424 2021-03-05 Washington Wisconsin 55131 15614 144
1086026 1086026 2021-03-04 Washington Alabama 1129 1568 36
1086144 1086144 2021-03-04 Washington Arkansas 5143 29511 329
1086267 1086267 2021-03-04 Washington Colorado 8121 392 12
1086351 1086351 2021-03-04 Washington Florida 12133 2634 48
1086502 1086502 2021-03-04 Washington Georgia 13303 2081 70
1086561 1086561 2021-03-04 Washington Idaho 16087 1177 21
1086657 1086657 2021-03-04 Washington Illinois 17189 1587 30

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);