ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Clark" and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537474 | 537474 | 2020-09-15 | Clark | Washington | 53011 | 3005 | 62 |
534238 | 534238 | 2020-09-14 | Clark | Washington | 53011 | 2971 | 62 |
531003 | 531003 | 2020-09-13 | Clark | Washington | 53011 | 2895 | 61 |
527766 | 527766 | 2020-09-12 | Clark | Washington | 53011 | 2895 | 61 |
524530 | 524530 | 2020-09-11 | Clark | Washington | 53011 | 2895 | 61 |
521294 | 521294 | 2020-09-10 | Clark | Washington | 53011 | 2855 | 61 |
518057 | 518057 | 2020-09-09 | Clark | Washington | 53011 | 2820 | 60 |
514822 | 514822 | 2020-09-08 | Clark | Washington | 53011 | 2799 | 59 |
511589 | 511589 | 2020-09-07 | Clark | Washington | 53011 | 2717 | 59 |
508356 | 508356 | 2020-09-06 | Clark | Washington | 53011 | 2717 | 59 |
505124 | 505124 | 2020-09-05 | Clark | Washington | 53011 | 2717 | 59 |
501890 | 501890 | 2020-09-04 | Clark | Washington | 53011 | 2717 | 59 |
498656 | 498656 | 2020-09-03 | Clark | Washington | 53011 | 2690 | 58 |
495423 | 495423 | 2020-09-02 | Clark | Washington | 53011 | 2651 | 58 |
492189 | 492189 | 2020-09-01 | Clark | Washington | 53011 | 2633 | 58 |
488956 | 488956 | 2020-08-31 | Clark | Washington | 53011 | 2612 | 57 |
485723 | 485723 | 2020-08-30 | Clark | Washington | 53011 | 2536 | 56 |
482488 | 482488 | 2020-08-29 | Clark | Washington | 53011 | 2536 | 56 |
479254 | 479254 | 2020-08-28 | Clark | Washington | 53011 | 2536 | 56 |
476021 | 476021 | 2020-08-27 | Clark | Washington | 53011 | 2504 | 56 |
472788 | 472788 | 2020-08-26 | Clark | Washington | 53011 | 2480 | 55 |
469556 | 469556 | 2020-08-25 | Clark | Washington | 53011 | 2457 | 55 |
466327 | 466327 | 2020-08-24 | Clark | Washington | 53011 | 2437 | 54 |
463098 | 463098 | 2020-08-23 | Clark | Washington | 53011 | 2387 | 54 |
459869 | 459869 | 2020-08-22 | Clark | Washington | 53011 | 2387 | 54 |
456642 | 456642 | 2020-08-21 | Clark | Washington | 53011 | 2387 | 54 |
453414 | 453414 | 2020-08-20 | Clark | Washington | 53011 | 2380 | 53 |
450186 | 450186 | 2020-08-19 | Clark | Washington | 53011 | 2332 | 53 |
446958 | 446958 | 2020-08-18 | Clark | Washington | 53011 | 2327 | 52 |
443731 | 443731 | 2020-08-17 | Clark | Washington | 53011 | 2301 | 51 |
440505 | 440505 | 2020-08-16 | Clark | Washington | 53011 | 2221 | 51 |
437279 | 437279 | 2020-08-15 | Clark | Washington | 53011 | 2221 | 49 |
434053 | 434053 | 2020-08-14 | Clark | Washington | 53011 | 2221 | 48 |
430828 | 430828 | 2020-08-13 | Clark | Washington | 53011 | 2183 | 48 |
427600 | 427600 | 2020-08-12 | Clark | Washington | 53011 | 2162 | 45 |
424376 | 424376 | 2020-08-11 | Clark | Washington | 53011 | 2123 | 45 |
421155 | 421155 | 2020-08-10 | Clark | Washington | 53011 | 2112 | 45 |
417934 | 417934 | 2020-08-09 | Clark | Washington | 53011 | 2020 | 45 |
414713 | 414713 | 2020-08-08 | Clark | Washington | 53011 | 2020 | 44 |
411493 | 411493 | 2020-08-07 | Clark | Washington | 53011 | 2020 | 44 |
408274 | 408274 | 2020-08-06 | Clark | Washington | 53011 | 1994 | 44 |
405054 | 405054 | 2020-08-05 | Clark | Washington | 53011 | 1993 | 44 |
401836 | 401836 | 2020-08-04 | Clark | Washington | 53011 | 1948 | 44 |
398620 | 398620 | 2020-08-03 | Clark | Washington | 53011 | 1887 | 44 |
395404 | 395404 | 2020-08-02 | Clark | Washington | 53011 | 1780 | 44 |
392188 | 392188 | 2020-08-01 | Clark | Washington | 53011 | 1780 | 44 |
388971 | 388971 | 2020-07-31 | Clark | Washington | 53011 | 1780 | 42 |
385754 | 385754 | 2020-07-30 | Clark | Washington | 53011 | 1758 | 41 |
382536 | 382536 | 2020-07-29 | Clark | Washington | 53011 | 1729 | 41 |
379319 | 379319 | 2020-07-28 | Clark | Washington | 53011 | 1719 | 39 |
376103 | 376103 | 2020-07-27 | Clark | Washington | 53011 | 1682 | 39 |
372889 | 372889 | 2020-07-26 | Clark | Washington | 53011 | 1634 | 39 |
369677 | 369677 | 2020-07-25 | Clark | Washington | 53011 | 1634 | 39 |
366468 | 366468 | 2020-07-24 | Clark | Washington | 53011 | 1634 | 39 |
363262 | 363262 | 2020-07-23 | Clark | Washington | 53011 | 1605 | 37 |
360056 | 360056 | 2020-07-22 | Clark | Washington | 53011 | 1577 | 37 |
356851 | 356851 | 2020-07-21 | Clark | Washington | 53011 | 1566 | 38 |
353648 | 353648 | 2020-07-20 | Clark | Washington | 53011 | 1526 | 37 |
350446 | 350446 | 2020-07-19 | Clark | Washington | 53011 | 1434 | 34 |
347245 | 347245 | 2020-07-18 | Clark | Washington | 53011 | 1434 | 34 |
344045 | 344045 | 2020-07-17 | Clark | Washington | 53011 | 1434 | 34 |
340846 | 340846 | 2020-07-16 | Clark | Washington | 53011 | 1390 | 33 |
337650 | 337650 | 2020-07-15 | Clark | Washington | 53011 | 1344 | 33 |
334455 | 334455 | 2020-07-14 | Clark | Washington | 53011 | 1319 | 33 |
331262 | 331262 | 2020-07-13 | Clark | Washington | 53011 | 1272 | 33 |
328076 | 328076 | 2020-07-12 | Clark | Washington | 53011 | 1166 | 32 |
324891 | 324891 | 2020-07-11 | Clark | Washington | 53011 | 1166 | 32 |
321710 | 321710 | 2020-07-10 | Clark | Washington | 53011 | 1166 | 32 |
318531 | 318531 | 2020-07-09 | Clark | Washington | 53011 | 1128 | 31 |
315358 | 315358 | 2020-07-08 | Clark | Washington | 53011 | 1090 | 30 |
312183 | 312183 | 2020-07-07 | Clark | Washington | 53011 | 1053 | 30 |
309014 | 309014 | 2020-07-06 | Clark | Washington | 53011 | 1008 | 30 |
305846 | 305846 | 2020-07-05 | Clark | Washington | 53011 | 922 | 30 |
302682 | 302682 | 2020-07-04 | Clark | Washington | 53011 | 920 | 30 |
299518 | 299518 | 2020-07-03 | Clark | Washington | 53011 | 901 | 30 |
296356 | 296356 | 2020-07-02 | Clark | Washington | 53011 | 901 | 30 |
293201 | 293201 | 2020-07-01 | Clark | Washington | 53011 | 883 | 30 |
290048 | 290048 | 2020-06-30 | Clark | Washington | 53011 | 843 | 30 |
286898 | 286898 | 2020-06-29 | Clark | Washington | 53011 | 826 | 30 |
283752 | 283752 | 2020-06-28 | Clark | Washington | 53011 | 758 | 30 |
280606 | 280606 | 2020-06-27 | Clark | Washington | 53011 | 758 | 30 |
277458 | 277458 | 2020-06-26 | Clark | Washington | 53011 | 758 | 30 |
274310 | 274310 | 2020-06-25 | Clark | Washington | 53011 | 741 | 30 |
271170 | 271170 | 2020-06-24 | Clark | Washington | 53011 | 732 | 30 |
268036 | 268036 | 2020-06-23 | Clark | Washington | 53011 | 719 | 30 |
264907 | 264907 | 2020-06-22 | Clark | Washington | 53011 | 703 | 30 |
261778 | 261778 | 2020-06-21 | Clark | Washington | 53011 | 685 | 30 |
258651 | 258651 | 2020-06-20 | Clark | Washington | 53011 | 685 | 29 |
255524 | 255524 | 2020-06-19 | Clark | Washington | 53011 | 685 | 29 |
252405 | 252405 | 2020-06-18 | Clark | Washington | 53011 | 671 | 28 |
249290 | 249290 | 2020-06-17 | Clark | Washington | 53011 | 659 | 28 |
246178 | 246178 | 2020-06-16 | Clark | Washington | 53011 | 656 | 28 |
243065 | 243065 | 2020-06-15 | Clark | Washington | 53011 | 647 | 28 |
239954 | 239954 | 2020-06-14 | Clark | Washington | 53011 | 630 | 28 |
236846 | 236846 | 2020-06-13 | Clark | Washington | 53011 | 630 | 28 |
233739 | 233739 | 2020-06-12 | Clark | Washington | 53011 | 630 | 28 |
230634 | 230634 | 2020-06-11 | Clark | Washington | 53011 | 622 | 28 |
227530 | 227530 | 2020-06-10 | Clark | Washington | 53011 | 607 | 28 |
224430 | 224430 | 2020-06-09 | Clark | Washington | 53011 | 605 | 28 |
221334 | 221334 | 2020-06-08 | Clark | Washington | 53011 | 603 | 28 |
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);