ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 53065 and state = "Washington" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
283778 | 283778 | 2020-06-28 | Stevens | Washington | 53065 | 17 | 1 |
286924 | 286924 | 2020-06-29 | Stevens | Washington | 53065 | 17 | 1 |
290074 | 290074 | 2020-06-30 | Stevens | Washington | 53065 | 18 | 1 |
293227 | 293227 | 2020-07-01 | Stevens | Washington | 53065 | 18 | 1 |
296382 | 296382 | 2020-07-02 | Stevens | Washington | 53065 | 18 | 1 |
299544 | 299544 | 2020-07-03 | Stevens | Washington | 53065 | 19 | 1 |
302708 | 302708 | 2020-07-04 | Stevens | Washington | 53065 | 19 | 1 |
305872 | 305872 | 2020-07-05 | Stevens | Washington | 53065 | 20 | 1 |
309040 | 309040 | 2020-07-06 | Stevens | Washington | 53065 | 20 | 1 |
312209 | 312209 | 2020-07-07 | Stevens | Washington | 53065 | 20 | 1 |
315384 | 315384 | 2020-07-08 | Stevens | Washington | 53065 | 20 | 1 |
318557 | 318557 | 2020-07-09 | Stevens | Washington | 53065 | 21 | 1 |
321736 | 321736 | 2020-07-10 | Stevens | Washington | 53065 | 23 | 1 |
324917 | 324917 | 2020-07-11 | Stevens | Washington | 53065 | 23 | 1 |
328103 | 328103 | 2020-07-12 | Stevens | Washington | 53065 | 27 | 1 |
331289 | 331289 | 2020-07-13 | Stevens | Washington | 53065 | 28 | 1 |
334482 | 334482 | 2020-07-14 | Stevens | Washington | 53065 | 28 | 1 |
337677 | 337677 | 2020-07-15 | Stevens | Washington | 53065 | 30 | 1 |
340873 | 340873 | 2020-07-16 | Stevens | Washington | 53065 | 35 | 1 |
344072 | 344072 | 2020-07-17 | Stevens | Washington | 53065 | 37 | 1 |
347272 | 347272 | 2020-07-18 | Stevens | Washington | 53065 | 43 | 1 |
350473 | 350473 | 2020-07-19 | Stevens | Washington | 53065 | 44 | 1 |
353675 | 353675 | 2020-07-20 | Stevens | Washington | 53065 | 44 | 1 |
356878 | 356878 | 2020-07-21 | Stevens | Washington | 53065 | 46 | 1 |
360083 | 360083 | 2020-07-22 | Stevens | Washington | 53065 | 48 | 1 |
363289 | 363289 | 2020-07-23 | Stevens | Washington | 53065 | 50 | 1 |
366495 | 366495 | 2020-07-24 | Stevens | Washington | 53065 | 51 | 1 |
369704 | 369704 | 2020-07-25 | Stevens | Washington | 53065 | 55 | 1 |
372916 | 372916 | 2020-07-26 | Stevens | Washington | 53065 | 59 | 1 |
376130 | 376130 | 2020-07-27 | Stevens | Washington | 53065 | 59 | 1 |
379346 | 379346 | 2020-07-28 | Stevens | Washington | 53065 | 66 | 1 |
382563 | 382563 | 2020-07-29 | Stevens | Washington | 53065 | 69 | 1 |
385781 | 385781 | 2020-07-30 | Stevens | Washington | 53065 | 82 | 1 |
388998 | 388998 | 2020-07-31 | Stevens | Washington | 53065 | 82 | 1 |
392215 | 392215 | 2020-08-01 | Stevens | Washington | 53065 | 89 | 1 |
395431 | 395431 | 2020-08-02 | Stevens | Washington | 53065 | 89 | 1 |
398647 | 398647 | 2020-08-03 | Stevens | Washington | 53065 | 92 | 1 |
401863 | 401863 | 2020-08-04 | Stevens | Washington | 53065 | 94 | 1 |
405081 | 405081 | 2020-08-05 | Stevens | Washington | 53065 | 94 | 1 |
408301 | 408301 | 2020-08-06 | Stevens | Washington | 53065 | 94 | 1 |
411520 | 411520 | 2020-08-07 | Stevens | Washington | 53065 | 99 | 1 |
414740 | 414740 | 2020-08-08 | Stevens | Washington | 53065 | 99 | 1 |
417961 | 417961 | 2020-08-09 | Stevens | Washington | 53065 | 108 | 1 |
421182 | 421182 | 2020-08-10 | Stevens | Washington | 53065 | 110 | 1 |
424403 | 424403 | 2020-08-11 | Stevens | Washington | 53065 | 110 | 1 |
427627 | 427627 | 2020-08-12 | Stevens | Washington | 53065 | 110 | 1 |
430855 | 430855 | 2020-08-13 | Stevens | Washington | 53065 | 113 | 1 |
434080 | 434080 | 2020-08-14 | Stevens | Washington | 53065 | 113 | 1 |
437306 | 437306 | 2020-08-15 | Stevens | Washington | 53065 | 114 | 1 |
440532 | 440532 | 2020-08-16 | Stevens | Washington | 53065 | 117 | 1 |
443758 | 443758 | 2020-08-17 | Stevens | Washington | 53065 | 117 | 1 |
446985 | 446985 | 2020-08-18 | Stevens | Washington | 53065 | 118 | 1 |
450213 | 450213 | 2020-08-19 | Stevens | Washington | 53065 | 121 | 1 |
453441 | 453441 | 2020-08-20 | Stevens | Washington | 53065 | 120 | 1 |
456669 | 456669 | 2020-08-21 | Stevens | Washington | 53065 | 120 | 1 |
459896 | 459896 | 2020-08-22 | Stevens | Washington | 53065 | 122 | 1 |
463125 | 463125 | 2020-08-23 | Stevens | Washington | 53065 | 122 | 1 |
466354 | 466354 | 2020-08-24 | Stevens | Washington | 53065 | 123 | 1 |
469583 | 469583 | 2020-08-25 | Stevens | Washington | 53065 | 123 | 1 |
472815 | 472815 | 2020-08-26 | Stevens | Washington | 53065 | 125 | 1 |
476048 | 476048 | 2020-08-27 | Stevens | Washington | 53065 | 125 | 1 |
479281 | 479281 | 2020-08-28 | Stevens | Washington | 53065 | 124 | 1 |
482515 | 482515 | 2020-08-29 | Stevens | Washington | 53065 | 125 | 1 |
485750 | 485750 | 2020-08-30 | Stevens | Washington | 53065 | 125 | 1 |
488983 | 488983 | 2020-08-31 | Stevens | Washington | 53065 | 126 | 1 |
492216 | 492216 | 2020-09-01 | Stevens | Washington | 53065 | 126 | 1 |
495450 | 495450 | 2020-09-02 | Stevens | Washington | 53065 | 128 | 1 |
498683 | 498683 | 2020-09-03 | Stevens | Washington | 53065 | 128 | 1 |
501917 | 501917 | 2020-09-04 | Stevens | Washington | 53065 | 128 | 2 |
505151 | 505151 | 2020-09-05 | Stevens | Washington | 53065 | 128 | 2 |
508383 | 508383 | 2020-09-06 | Stevens | Washington | 53065 | 129 | 2 |
511616 | 511616 | 2020-09-07 | Stevens | Washington | 53065 | 129 | 2 |
514849 | 514849 | 2020-09-08 | Stevens | Washington | 53065 | 130 | 2 |
518084 | 518084 | 2020-09-09 | Stevens | Washington | 53065 | 130 | 2 |
521321 | 521321 | 2020-09-10 | Stevens | Washington | 53065 | 130 | 2 |
524557 | 524557 | 2020-09-11 | Stevens | Washington | 53065 | 130 | 2 |
527793 | 527793 | 2020-09-12 | Stevens | Washington | 53065 | 132 | 2 |
531030 | 531030 | 2020-09-13 | Stevens | Washington | 53065 | 133 | 2 |
534265 | 534265 | 2020-09-14 | Stevens | Washington | 53065 | 133 | 2 |
537501 | 537501 | 2020-09-15 | Stevens | Washington | 53065 | 133 | 2 |
540738 | 540738 | 2020-09-16 | Stevens | Washington | 53065 | 136 | 2 |
543974 | 543974 | 2020-09-17 | Stevens | Washington | 53065 | 136 | 2 |
547211 | 547211 | 2020-09-18 | Stevens | Washington | 53065 | 143 | 2 |
550450 | 550450 | 2020-09-19 | Stevens | Washington | 53065 | 146 | 2 |
553689 | 553689 | 2020-09-20 | Stevens | Washington | 53065 | 147 | 2 |
556926 | 556926 | 2020-09-21 | Stevens | Washington | 53065 | 147 | 2 |
560162 | 560162 | 2020-09-22 | Stevens | Washington | 53065 | 153 | 2 |
563401 | 563401 | 2020-09-23 | Stevens | Washington | 53065 | 161 | 2 |
566642 | 566642 | 2020-09-24 | Stevens | Washington | 53065 | 162 | 2 |
569883 | 569883 | 2020-09-25 | Stevens | Washington | 53065 | 165 | 2 |
573125 | 573125 | 2020-09-26 | Stevens | Washington | 53065 | 167 | 2 |
576369 | 576369 | 2020-09-27 | Stevens | Washington | 53065 | 167 | 2 |
579610 | 579610 | 2020-09-28 | Stevens | Washington | 53065 | 167 | 2 |
582849 | 582849 | 2020-09-29 | Stevens | Washington | 53065 | 167 | 2 |
586089 | 586089 | 2020-09-30 | Stevens | Washington | 53065 | 181 | 2 |
589330 | 589330 | 2020-10-01 | Stevens | Washington | 53065 | 183 | 3 |
592570 | 592570 | 2020-10-02 | Stevens | Washington | 53065 | 189 | 3 |
595812 | 595812 | 2020-10-03 | Stevens | Washington | 53065 | 193 | 3 |
599055 | 599055 | 2020-10-04 | Stevens | Washington | 53065 | 194 | 3 |
602298 | 602298 | 2020-10-05 | Stevens | Washington | 53065 | 200 | 3 |
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);