ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
810 rows where fips = 53063 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537500 | 537500 | 2020-09-15 | Spokane | Washington | 53063 | 5985 | 150 |
534264 | 534264 | 2020-09-14 | Spokane | Washington | 53063 | 5947 | 150 |
531029 | 531029 | 2020-09-13 | Spokane | Washington | 53063 | 5831 | 146 |
527792 | 527792 | 2020-09-12 | Spokane | Washington | 53063 | 5818 | 146 |
524556 | 524556 | 2020-09-11 | Spokane | Washington | 53063 | 5764 | 146 |
521320 | 521320 | 2020-09-10 | Spokane | Washington | 53063 | 5764 | 145 |
518083 | 518083 | 2020-09-09 | Spokane | Washington | 53063 | 5687 | 144 |
514848 | 514848 | 2020-09-08 | Spokane | Washington | 53063 | 5659 | 141 |
511615 | 511615 | 2020-09-07 | Spokane | Washington | 53063 | 5542 | 141 |
508382 | 508382 | 2020-09-06 | Spokane | Washington | 53063 | 5542 | 141 |
505150 | 505150 | 2020-09-05 | Spokane | Washington | 53063 | 5533 | 141 |
501916 | 501916 | 2020-09-04 | Spokane | Washington | 53063 | 5533 | 141 |
498682 | 498682 | 2020-09-03 | Spokane | Washington | 53063 | 5492 | 141 |
495449 | 495449 | 2020-09-02 | Spokane | Washington | 53063 | 5457 | 141 |
492215 | 492215 | 2020-09-01 | Spokane | Washington | 53063 | 5396 | 139 |
488982 | 488982 | 2020-08-31 | Spokane | Washington | 53063 | 5364 | 138 |
485749 | 485749 | 2020-08-30 | Spokane | Washington | 53063 | 5293 | 134 |
482514 | 482514 | 2020-08-29 | Spokane | Washington | 53063 | 5265 | 134 |
479280 | 479280 | 2020-08-28 | Spokane | Washington | 53063 | 5215 | 134 |
476047 | 476047 | 2020-08-27 | Spokane | Washington | 53063 | 5165 | 131 |
472814 | 472814 | 2020-08-26 | Spokane | Washington | 53063 | 5124 | 131 |
469582 | 469582 | 2020-08-25 | Spokane | Washington | 53063 | 5080 | 130 |
466353 | 466353 | 2020-08-24 | Spokane | Washington | 53063 | 5051 | 127 |
463124 | 463124 | 2020-08-23 | Spokane | Washington | 53063 | 5018 | 126 |
459895 | 459895 | 2020-08-22 | Spokane | Washington | 53063 | 4989 | 125 |
456668 | 456668 | 2020-08-21 | Spokane | Washington | 53063 | 4949 | 123 |
453440 | 453440 | 2020-08-20 | Spokane | Washington | 53063 | 4915 | 121 |
450212 | 450212 | 2020-08-19 | Spokane | Washington | 53063 | 4860 | 119 |
446984 | 446984 | 2020-08-18 | Spokane | Washington | 53063 | 4843 | 117 |
443757 | 443757 | 2020-08-17 | Spokane | Washington | 53063 | 4813 | 112 |
440531 | 440531 | 2020-08-16 | Spokane | Washington | 53063 | 4798 | 109 |
437305 | 437305 | 2020-08-15 | Spokane | Washington | 53063 | 4730 | 104 |
434079 | 434079 | 2020-08-14 | Spokane | Washington | 53063 | 4674 | 98 |
430854 | 430854 | 2020-08-13 | Spokane | Washington | 53063 | 4674 | 98 |
427626 | 427626 | 2020-08-12 | Spokane | Washington | 53063 | 4674 | 93 |
424402 | 424402 | 2020-08-11 | Spokane | Washington | 53063 | 4511 | 93 |
421181 | 421181 | 2020-08-10 | Spokane | Washington | 53063 | 4511 | 93 |
417960 | 417960 | 2020-08-09 | Spokane | Washington | 53063 | 4422 | 92 |
414739 | 414739 | 2020-08-08 | Spokane | Washington | 53063 | 4199 | 82 |
411519 | 411519 | 2020-08-07 | Spokane | Washington | 53063 | 4199 | 82 |
408300 | 408300 | 2020-08-06 | Spokane | Washington | 53063 | 4012 | 70 |
405080 | 405080 | 2020-08-05 | Spokane | Washington | 53063 | 4012 | 70 |
401862 | 401862 | 2020-08-04 | Spokane | Washington | 53063 | 4012 | 70 |
398646 | 398646 | 2020-08-03 | Spokane | Washington | 53063 | 3916 | 64 |
395430 | 395430 | 2020-08-02 | Spokane | Washington | 53063 | 3870 | 63 |
392214 | 392214 | 2020-08-01 | Spokane | Washington | 53063 | 3813 | 63 |
388997 | 388997 | 2020-07-31 | Spokane | Washington | 53063 | 3620 | 60 |
385780 | 385780 | 2020-07-30 | Spokane | Washington | 53063 | 3620 | 60 |
382562 | 382562 | 2020-07-29 | Spokane | Washington | 53063 | 3518 | 59 |
379345 | 379345 | 2020-07-28 | Spokane | Washington | 53063 | 3514 | 57 |
376129 | 376129 | 2020-07-27 | Spokane | Washington | 53063 | 3435 | 53 |
372915 | 372915 | 2020-07-26 | Spokane | Washington | 53063 | 3276 | 51 |
369703 | 369703 | 2020-07-25 | Spokane | Washington | 53063 | 3197 | 49 |
366494 | 366494 | 2020-07-24 | Spokane | Washington | 53063 | 3197 | 50 |
363288 | 363288 | 2020-07-23 | Spokane | Washington | 53063 | 3078 | 49 |
360082 | 360082 | 2020-07-22 | Spokane | Washington | 53063 | 2965 | 47 |
356877 | 356877 | 2020-07-21 | Spokane | Washington | 53063 | 2894 | 46 |
353674 | 353674 | 2020-07-20 | Spokane | Washington | 53063 | 2813 | 46 |
350472 | 350472 | 2020-07-19 | Spokane | Washington | 53063 | 2667 | 46 |
347271 | 347271 | 2020-07-18 | Spokane | Washington | 53063 | 2577 | 46 |
344071 | 344071 | 2020-07-17 | Spokane | Washington | 53063 | 2577 | 46 |
340872 | 340872 | 2020-07-16 | Spokane | Washington | 53063 | 2447 | 45 |
337676 | 337676 | 2020-07-15 | Spokane | Washington | 53063 | 2356 | 44 |
334481 | 334481 | 2020-07-14 | Spokane | Washington | 53063 | 2259 | 43 |
331288 | 331288 | 2020-07-13 | Spokane | Washington | 53063 | 2183 | 43 |
328102 | 328102 | 2020-07-12 | Spokane | Washington | 53063 | 2067 | 43 |
324916 | 324916 | 2020-07-11 | Spokane | Washington | 53063 | 1946 | 43 |
321735 | 321735 | 2020-07-10 | Spokane | Washington | 53063 | 1946 | 43 |
318556 | 318556 | 2020-07-09 | Spokane | Washington | 53063 | 1902 | 43 |
315383 | 315383 | 2020-07-08 | Spokane | Washington | 53063 | 1850 | 42 |
312208 | 312208 | 2020-07-07 | Spokane | Washington | 53063 | 1792 | 42 |
309039 | 309039 | 2020-07-06 | Spokane | Washington | 53063 | 1741 | 41 |
305871 | 305871 | 2020-07-05 | Spokane | Washington | 53063 | 1606 | 41 |
302707 | 302707 | 2020-07-04 | Spokane | Washington | 53063 | 1555 | 41 |
299543 | 299543 | 2020-07-03 | Spokane | Washington | 53063 | 1533 | 41 |
296381 | 296381 | 2020-07-02 | Spokane | Washington | 53063 | 1489 | 41 |
293226 | 293226 | 2020-07-01 | Spokane | Washington | 53063 | 1420 | 41 |
290073 | 290073 | 2020-06-30 | Spokane | Washington | 53063 | 1385 | 40 |
286923 | 286923 | 2020-06-29 | Spokane | Washington | 53063 | 1306 | 39 |
283777 | 283777 | 2020-06-28 | Spokane | Washington | 53063 | 1197 | 39 |
280631 | 280631 | 2020-06-27 | Spokane | Washington | 53063 | 1183 | 39 |
277483 | 277483 | 2020-06-26 | Spokane | Washington | 53063 | 1171 | 39 |
274335 | 274335 | 2020-06-25 | Spokane | Washington | 53063 | 1126 | 38 |
271195 | 271195 | 2020-06-24 | Spokane | Washington | 53063 | 1085 | 38 |
268061 | 268061 | 2020-06-23 | Spokane | Washington | 53063 | 1055 | 38 |
264932 | 264932 | 2020-06-22 | Spokane | Washington | 53063 | 1002 | 39 |
261803 | 261803 | 2020-06-21 | Spokane | Washington | 53063 | 978 | 38 |
258676 | 258676 | 2020-06-20 | Spokane | Washington | 53063 | 958 | 38 |
255549 | 255549 | 2020-06-19 | Spokane | Washington | 53063 | 940 | 37 |
252430 | 252430 | 2020-06-18 | Spokane | Washington | 53063 | 897 | 37 |
249315 | 249315 | 2020-06-17 | Spokane | Washington | 53063 | 881 | 37 |
246203 | 246203 | 2020-06-16 | Spokane | Washington | 53063 | 864 | 37 |
243090 | 243090 | 2020-06-15 | Spokane | Washington | 53063 | 846 | 37 |
239979 | 239979 | 2020-06-14 | Spokane | Washington | 53063 | 824 | 37 |
236871 | 236871 | 2020-06-13 | Spokane | Washington | 53063 | 808 | 37 |
233764 | 233764 | 2020-06-12 | Spokane | Washington | 53063 | 806 | 37 |
230659 | 230659 | 2020-06-11 | Spokane | Washington | 53063 | 796 | 37 |
227555 | 227555 | 2020-06-10 | Spokane | Washington | 53063 | 792 | 37 |
224455 | 224455 | 2020-06-09 | Spokane | Washington | 53063 | 778 | 37 |
221359 | 221359 | 2020-06-08 | Spokane | Washington | 53063 | 767 | 35 |
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);