ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Jefferson" and state = "Washington" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-06 1
- 2020-03-07 1
- 2020-03-08 1
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- …
state 1
- Washington · 799 ✖
fips 1
- 53031 799
county 1
- Jefferson · 799 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
649 | 649 | 2020-03-06 | Jefferson | Washington | 53031 | 1 | 0 |
743 | 743 | 2020-03-07 | Jefferson | Washington | 53031 | 1 | 0 |
855 | 855 | 2020-03-08 | Jefferson | Washington | 53031 | 1 | 0 |
986 | 986 | 2020-03-09 | Jefferson | Washington | 53031 | 1 | 0 |
1149 | 1149 | 2020-03-10 | Jefferson | Washington | 53031 | 1 | 0 |
1349 | 1349 | 2020-03-11 | Jefferson | Washington | 53031 | 1 | 0 |
1603 | 1603 | 2020-03-12 | Jefferson | Washington | 53031 | 1 | 0 |
1914 | 1914 | 2020-03-13 | Jefferson | Washington | 53031 | 1 | 0 |
2287 | 2287 | 2020-03-14 | Jefferson | Washington | 53031 | 1 | 0 |
2714 | 2714 | 2020-03-15 | Jefferson | Washington | 53031 | 3 | 0 |
3188 | 3188 | 2020-03-16 | Jefferson | Washington | 53031 | 3 | 0 |
3729 | 3729 | 2020-03-17 | Jefferson | Washington | 53031 | 4 | 0 |
4364 | 4364 | 2020-03-18 | Jefferson | Washington | 53031 | 4 | 0 |
5121 | 5121 | 2020-03-19 | Jefferson | Washington | 53031 | 4 | 0 |
6023 | 6023 | 2020-03-20 | Jefferson | Washington | 53031 | 4 | 0 |
7054 | 7054 | 2020-03-21 | Jefferson | Washington | 53031 | 4 | 0 |
8191 | 8191 | 2020-03-22 | Jefferson | Washington | 53031 | 6 | 0 |
9416 | 9416 | 2020-03-23 | Jefferson | Washington | 53031 | 7 | 0 |
10765 | 10765 | 2020-03-24 | Jefferson | Washington | 53031 | 8 | 0 |
12288 | 12288 | 2020-03-25 | Jefferson | Washington | 53031 | 10 | 0 |
13938 | 13938 | 2020-03-26 | Jefferson | Washington | 53031 | 11 | 0 |
15706 | 15706 | 2020-03-27 | Jefferson | Washington | 53031 | 11 | 0 |
17586 | 17586 | 2020-03-28 | Jefferson | Washington | 53031 | 13 | 0 |
19551 | 19551 | 2020-03-29 | Jefferson | Washington | 53031 | 14 | 0 |
21618 | 21618 | 2020-03-30 | Jefferson | Washington | 53031 | 14 | 0 |
23767 | 23767 | 2020-03-31 | Jefferson | Washington | 53031 | 14 | 0 |
25985 | 25985 | 2020-04-01 | Jefferson | Washington | 53031 | 17 | 0 |
28275 | 28275 | 2020-04-02 | Jefferson | Washington | 53031 | 19 | 0 |
30628 | 30628 | 2020-04-03 | Jefferson | Washington | 53031 | 19 | 0 |
33028 | 33028 | 2020-04-04 | Jefferson | Washington | 53031 | 20 | 0 |
35466 | 35466 | 2020-04-05 | Jefferson | Washington | 53031 | 22 | 0 |
37950 | 37950 | 2020-04-06 | Jefferson | Washington | 53031 | 27 | 0 |
40485 | 40485 | 2020-04-07 | Jefferson | Washington | 53031 | 27 | 0 |
43054 | 43054 | 2020-04-08 | Jefferson | Washington | 53031 | 27 | 0 |
45650 | 45650 | 2020-04-09 | Jefferson | Washington | 53031 | 28 | 0 |
48277 | 48277 | 2020-04-10 | Jefferson | Washington | 53031 | 28 | 0 |
50935 | 50935 | 2020-04-11 | Jefferson | Washington | 53031 | 28 | 0 |
53610 | 53610 | 2020-04-12 | Jefferson | Washington | 53031 | 28 | 0 |
56300 | 56300 | 2020-04-13 | Jefferson | Washington | 53031 | 28 | 0 |
59006 | 59006 | 2020-04-14 | Jefferson | Washington | 53031 | 28 | 0 |
61725 | 61725 | 2020-04-15 | Jefferson | Washington | 53031 | 28 | 0 |
64458 | 64458 | 2020-04-16 | Jefferson | Washington | 53031 | 28 | 0 |
67206 | 67206 | 2020-04-17 | Jefferson | Washington | 53031 | 28 | 0 |
69968 | 69968 | 2020-04-18 | Jefferson | Washington | 53031 | 29 | 0 |
72738 | 72738 | 2020-04-19 | Jefferson | Washington | 53031 | 28 | 0 |
75514 | 75514 | 2020-04-20 | Jefferson | Washington | 53031 | 28 | 0 |
78297 | 78297 | 2020-04-21 | Jefferson | Washington | 53031 | 28 | 0 |
81090 | 81090 | 2020-04-22 | Jefferson | Washington | 53031 | 28 | 0 |
83891 | 83891 | 2020-04-23 | Jefferson | Washington | 53031 | 28 | 0 |
86698 | 86698 | 2020-04-24 | Jefferson | Washington | 53031 | 28 | 0 |
89513 | 89513 | 2020-04-25 | Jefferson | Washington | 53031 | 28 | 0 |
92330 | 92330 | 2020-04-26 | Jefferson | Washington | 53031 | 28 | 0 |
95159 | 95159 | 2020-04-27 | Jefferson | Washington | 53031 | 28 | 0 |
98004 | 98004 | 2020-04-28 | Jefferson | Washington | 53031 | 28 | 0 |
100854 | 100854 | 2020-04-29 | Jefferson | Washington | 53031 | 28 | 0 |
103709 | 103709 | 2020-04-30 | Jefferson | Washington | 53031 | 28 | 0 |
106573 | 106573 | 2020-05-01 | Jefferson | Washington | 53031 | 28 | 0 |
109442 | 109442 | 2020-05-02 | Jefferson | Washington | 53031 | 28 | 0 |
112316 | 112316 | 2020-05-03 | Jefferson | Washington | 53031 | 28 | 0 |
115199 | 115199 | 2020-05-04 | Jefferson | Washington | 53031 | 28 | 0 |
118158 | 118158 | 2020-05-05 | Jefferson | Washington | 53031 | 28 | 0 |
121122 | 121122 | 2020-05-06 | Jefferson | Washington | 53031 | 28 | 0 |
124102 | 124102 | 2020-05-07 | Jefferson | Washington | 53031 | 28 | 0 |
127087 | 127087 | 2020-05-08 | Jefferson | Washington | 53031 | 28 | 0 |
130077 | 130077 | 2020-05-09 | Jefferson | Washington | 53031 | 29 | 0 |
133067 | 133067 | 2020-05-10 | Jefferson | Washington | 53031 | 29 | 0 |
136057 | 136057 | 2020-05-11 | Jefferson | Washington | 53031 | 29 | 0 |
139048 | 139048 | 2020-05-12 | Jefferson | Washington | 53031 | 29 | 0 |
142044 | 142044 | 2020-05-13 | Jefferson | Washington | 53031 | 29 | 0 |
145041 | 145041 | 2020-05-14 | Jefferson | Washington | 53031 | 29 | 0 |
148044 | 148044 | 2020-05-15 | Jefferson | Washington | 53031 | 29 | 0 |
151053 | 151053 | 2020-05-16 | Jefferson | Washington | 53031 | 30 | 0 |
154064 | 154064 | 2020-05-17 | Jefferson | Washington | 53031 | 30 | 0 |
157081 | 157081 | 2020-05-18 | Jefferson | Washington | 53031 | 30 | 0 |
160105 | 160105 | 2020-05-19 | Jefferson | Washington | 53031 | 30 | 0 |
163133 | 163133 | 2020-05-20 | Jefferson | Washington | 53031 | 30 | 0 |
166162 | 166162 | 2020-05-21 | Jefferson | Washington | 53031 | 30 | 0 |
169198 | 169198 | 2020-05-22 | Jefferson | Washington | 53031 | 30 | 0 |
172239 | 172239 | 2020-05-23 | Jefferson | Washington | 53031 | 30 | 0 |
175282 | 175282 | 2020-05-24 | Jefferson | Washington | 53031 | 30 | 0 |
178327 | 178327 | 2020-05-25 | Jefferson | Washington | 53031 | 30 | 0 |
181371 | 181371 | 2020-05-26 | Jefferson | Washington | 53031 | 30 | 0 |
184422 | 184422 | 2020-05-27 | Jefferson | Washington | 53031 | 30 | 0 |
187479 | 187479 | 2020-05-28 | Jefferson | Washington | 53031 | 30 | 0 |
190543 | 190543 | 2020-05-29 | Jefferson | Washington | 53031 | 30 | 0 |
193609 | 193609 | 2020-05-30 | Jefferson | Washington | 53031 | 30 | 0 |
196679 | 196679 | 2020-05-31 | Jefferson | Washington | 53031 | 30 | 0 |
199752 | 199752 | 2020-06-01 | Jefferson | Washington | 53031 | 31 | 0 |
202828 | 202828 | 2020-06-02 | Jefferson | Washington | 53031 | 31 | 0 |
205907 | 205907 | 2020-06-03 | Jefferson | Washington | 53031 | 31 | 0 |
208989 | 208989 | 2020-06-04 | Jefferson | Washington | 53031 | 31 | 0 |
212074 | 212074 | 2020-06-05 | Jefferson | Washington | 53031 | 31 | 0 |
215161 | 215161 | 2020-06-06 | Jefferson | Washington | 53031 | 31 | 0 |
218251 | 218251 | 2020-06-07 | Jefferson | Washington | 53031 | 31 | 0 |
221343 | 221343 | 2020-06-08 | Jefferson | Washington | 53031 | 31 | 0 |
224439 | 224439 | 2020-06-09 | Jefferson | Washington | 53031 | 31 | 0 |
227539 | 227539 | 2020-06-10 | Jefferson | Washington | 53031 | 31 | 0 |
230643 | 230643 | 2020-06-11 | Jefferson | Washington | 53031 | 31 | 0 |
233748 | 233748 | 2020-06-12 | Jefferson | Washington | 53031 | 31 | 0 |
236855 | 236855 | 2020-06-13 | Jefferson | Washington | 53031 | 31 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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] desc);