ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Jefferson" and fips = 53031 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388981 | 388981 | 2020-07-31 | Jefferson | Washington | 53031 | 51 | 0 |
385764 | 385764 | 2020-07-30 | Jefferson | Washington | 53031 | 51 | 0 |
382546 | 382546 | 2020-07-29 | Jefferson | Washington | 53031 | 51 | 0 |
379329 | 379329 | 2020-07-28 | Jefferson | Washington | 53031 | 50 | 0 |
376113 | 376113 | 2020-07-27 | Jefferson | Washington | 53031 | 50 | 0 |
372899 | 372899 | 2020-07-26 | Jefferson | Washington | 53031 | 50 | 0 |
369687 | 369687 | 2020-07-25 | Jefferson | Washington | 53031 | 50 | 0 |
366478 | 366478 | 2020-07-24 | Jefferson | Washington | 53031 | 50 | 0 |
363272 | 363272 | 2020-07-23 | Jefferson | Washington | 53031 | 50 | 0 |
360066 | 360066 | 2020-07-22 | Jefferson | Washington | 53031 | 50 | 0 |
356861 | 356861 | 2020-07-21 | Jefferson | Washington | 53031 | 50 | 0 |
353658 | 353658 | 2020-07-20 | Jefferson | Washington | 53031 | 50 | 0 |
350456 | 350456 | 2020-07-19 | Jefferson | Washington | 53031 | 50 | 0 |
347255 | 347255 | 2020-07-18 | Jefferson | Washington | 53031 | 50 | 0 |
344055 | 344055 | 2020-07-17 | Jefferson | Washington | 53031 | 50 | 0 |
340856 | 340856 | 2020-07-16 | Jefferson | Washington | 53031 | 50 | 0 |
337660 | 337660 | 2020-07-15 | Jefferson | Washington | 53031 | 50 | 0 |
334465 | 334465 | 2020-07-14 | Jefferson | Washington | 53031 | 44 | 0 |
331272 | 331272 | 2020-07-13 | Jefferson | Washington | 53031 | 43 | 0 |
328086 | 328086 | 2020-07-12 | Jefferson | Washington | 53031 | 41 | 0 |
324900 | 324900 | 2020-07-11 | Jefferson | Washington | 53031 | 41 | 0 |
321719 | 321719 | 2020-07-10 | Jefferson | Washington | 53031 | 41 | 0 |
318540 | 318540 | 2020-07-09 | Jefferson | Washington | 53031 | 41 | 0 |
315367 | 315367 | 2020-07-08 | Jefferson | Washington | 53031 | 41 | 0 |
312192 | 312192 | 2020-07-07 | Jefferson | Washington | 53031 | 41 | 0 |
309023 | 309023 | 2020-07-06 | Jefferson | Washington | 53031 | 41 | 0 |
305855 | 305855 | 2020-07-05 | Jefferson | Washington | 53031 | 39 | 0 |
302691 | 302691 | 2020-07-04 | Jefferson | Washington | 53031 | 38 | 0 |
299527 | 299527 | 2020-07-03 | Jefferson | Washington | 53031 | 38 | 0 |
296365 | 296365 | 2020-07-02 | Jefferson | Washington | 53031 | 38 | 0 |
293210 | 293210 | 2020-07-01 | Jefferson | Washington | 53031 | 38 | 0 |
290057 | 290057 | 2020-06-30 | Jefferson | Washington | 53031 | 38 | 0 |
286907 | 286907 | 2020-06-29 | Jefferson | Washington | 53031 | 38 | 0 |
283761 | 283761 | 2020-06-28 | Jefferson | Washington | 53031 | 37 | 0 |
280615 | 280615 | 2020-06-27 | Jefferson | Washington | 53031 | 37 | 0 |
277467 | 277467 | 2020-06-26 | Jefferson | Washington | 53031 | 36 | 0 |
274319 | 274319 | 2020-06-25 | Jefferson | Washington | 53031 | 36 | 0 |
271179 | 271179 | 2020-06-24 | Jefferson | Washington | 53031 | 35 | 0 |
268045 | 268045 | 2020-06-23 | Jefferson | Washington | 53031 | 33 | 0 |
264916 | 264916 | 2020-06-22 | Jefferson | Washington | 53031 | 33 | 0 |
261787 | 261787 | 2020-06-21 | Jefferson | Washington | 53031 | 33 | 0 |
258660 | 258660 | 2020-06-20 | Jefferson | Washington | 53031 | 33 | 0 |
255533 | 255533 | 2020-06-19 | Jefferson | Washington | 53031 | 33 | 0 |
252414 | 252414 | 2020-06-18 | Jefferson | Washington | 53031 | 32 | 0 |
249299 | 249299 | 2020-06-17 | Jefferson | Washington | 53031 | 32 | 0 |
246187 | 246187 | 2020-06-16 | Jefferson | Washington | 53031 | 32 | 0 |
243074 | 243074 | 2020-06-15 | Jefferson | Washington | 53031 | 32 | 0 |
239963 | 239963 | 2020-06-14 | Jefferson | Washington | 53031 | 31 | 0 |
236855 | 236855 | 2020-06-13 | Jefferson | Washington | 53031 | 31 | 0 |
233748 | 233748 | 2020-06-12 | Jefferson | Washington | 53031 | 31 | 0 |
230643 | 230643 | 2020-06-11 | Jefferson | Washington | 53031 | 31 | 0 |
227539 | 227539 | 2020-06-10 | Jefferson | Washington | 53031 | 31 | 0 |
224439 | 224439 | 2020-06-09 | Jefferson | Washington | 53031 | 31 | 0 |
221343 | 221343 | 2020-06-08 | Jefferson | Washington | 53031 | 31 | 0 |
218251 | 218251 | 2020-06-07 | Jefferson | Washington | 53031 | 31 | 0 |
215161 | 215161 | 2020-06-06 | Jefferson | Washington | 53031 | 31 | 0 |
212074 | 212074 | 2020-06-05 | Jefferson | Washington | 53031 | 31 | 0 |
208989 | 208989 | 2020-06-04 | Jefferson | Washington | 53031 | 31 | 0 |
205907 | 205907 | 2020-06-03 | Jefferson | Washington | 53031 | 31 | 0 |
202828 | 202828 | 2020-06-02 | Jefferson | Washington | 53031 | 31 | 0 |
199752 | 199752 | 2020-06-01 | Jefferson | Washington | 53031 | 31 | 0 |
196679 | 196679 | 2020-05-31 | Jefferson | Washington | 53031 | 30 | 0 |
193609 | 193609 | 2020-05-30 | Jefferson | Washington | 53031 | 30 | 0 |
190543 | 190543 | 2020-05-29 | Jefferson | Washington | 53031 | 30 | 0 |
187479 | 187479 | 2020-05-28 | Jefferson | Washington | 53031 | 30 | 0 |
184422 | 184422 | 2020-05-27 | Jefferson | Washington | 53031 | 30 | 0 |
181371 | 181371 | 2020-05-26 | Jefferson | Washington | 53031 | 30 | 0 |
178327 | 178327 | 2020-05-25 | Jefferson | Washington | 53031 | 30 | 0 |
175282 | 175282 | 2020-05-24 | Jefferson | Washington | 53031 | 30 | 0 |
172239 | 172239 | 2020-05-23 | Jefferson | Washington | 53031 | 30 | 0 |
169198 | 169198 | 2020-05-22 | Jefferson | Washington | 53031 | 30 | 0 |
166162 | 166162 | 2020-05-21 | Jefferson | Washington | 53031 | 30 | 0 |
163133 | 163133 | 2020-05-20 | Jefferson | Washington | 53031 | 30 | 0 |
160105 | 160105 | 2020-05-19 | Jefferson | Washington | 53031 | 30 | 0 |
157081 | 157081 | 2020-05-18 | Jefferson | Washington | 53031 | 30 | 0 |
154064 | 154064 | 2020-05-17 | Jefferson | Washington | 53031 | 30 | 0 |
151053 | 151053 | 2020-05-16 | Jefferson | Washington | 53031 | 30 | 0 |
148044 | 148044 | 2020-05-15 | Jefferson | Washington | 53031 | 29 | 0 |
145041 | 145041 | 2020-05-14 | Jefferson | Washington | 53031 | 29 | 0 |
142044 | 142044 | 2020-05-13 | Jefferson | Washington | 53031 | 29 | 0 |
139048 | 139048 | 2020-05-12 | Jefferson | Washington | 53031 | 29 | 0 |
136057 | 136057 | 2020-05-11 | Jefferson | Washington | 53031 | 29 | 0 |
133067 | 133067 | 2020-05-10 | Jefferson | Washington | 53031 | 29 | 0 |
130077 | 130077 | 2020-05-09 | Jefferson | Washington | 53031 | 29 | 0 |
127087 | 127087 | 2020-05-08 | Jefferson | Washington | 53031 | 28 | 0 |
124102 | 124102 | 2020-05-07 | Jefferson | Washington | 53031 | 28 | 0 |
121122 | 121122 | 2020-05-06 | Jefferson | Washington | 53031 | 28 | 0 |
118158 | 118158 | 2020-05-05 | Jefferson | Washington | 53031 | 28 | 0 |
115199 | 115199 | 2020-05-04 | Jefferson | Washington | 53031 | 28 | 0 |
112316 | 112316 | 2020-05-03 | Jefferson | Washington | 53031 | 28 | 0 |
109442 | 109442 | 2020-05-02 | Jefferson | Washington | 53031 | 28 | 0 |
106573 | 106573 | 2020-05-01 | Jefferson | Washington | 53031 | 28 | 0 |
103709 | 103709 | 2020-04-30 | Jefferson | Washington | 53031 | 28 | 0 |
100854 | 100854 | 2020-04-29 | Jefferson | Washington | 53031 | 28 | 0 |
98004 | 98004 | 2020-04-28 | Jefferson | Washington | 53031 | 28 | 0 |
95159 | 95159 | 2020-04-27 | Jefferson | Washington | 53031 | 28 | 0 |
92330 | 92330 | 2020-04-26 | Jefferson | Washington | 53031 | 28 | 0 |
89513 | 89513 | 2020-04-25 | Jefferson | Washington | 53031 | 28 | 0 |
86698 | 86698 | 2020-04-24 | Jefferson | Washington | 53031 | 28 | 0 |
83891 | 83891 | 2020-04-23 | Jefferson | Washington | 53031 | 28 | 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);