ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Washington" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635425 | 635425 | 2020-10-16 | Washington | Georgia | 13303 | 788 | 11 |
632179 | 632179 | 2020-10-15 | Washington | Georgia | 13303 | 785 | 11 |
628935 | 628935 | 2020-10-14 | Washington | Georgia | 13303 | 779 | 11 |
625692 | 625692 | 2020-10-13 | Washington | Georgia | 13303 | 776 | 11 |
622449 | 622449 | 2020-10-12 | Washington | Georgia | 13303 | 776 | 10 |
619206 | 619206 | 2020-10-11 | Washington | Georgia | 13303 | 775 | 10 |
615964 | 615964 | 2020-10-10 | Washington | Georgia | 13303 | 774 | 10 |
612723 | 612723 | 2020-10-09 | Washington | Georgia | 13303 | 770 | 9 |
609481 | 609481 | 2020-10-08 | Washington | Georgia | 13303 | 769 | 9 |
606238 | 606238 | 2020-10-07 | Washington | Georgia | 13303 | 763 | 8 |
602996 | 602996 | 2020-10-06 | Washington | Georgia | 13303 | 757 | 8 |
599753 | 599753 | 2020-10-05 | Washington | Georgia | 13303 | 757 | 8 |
596510 | 596510 | 2020-10-04 | Washington | Georgia | 13303 | 689 | 8 |
593268 | 593268 | 2020-10-03 | Washington | Georgia | 13303 | 689 | 8 |
590028 | 590028 | 2020-10-02 | Washington | Georgia | 13303 | 685 | 8 |
586787 | 586787 | 2020-10-01 | Washington | Georgia | 13303 | 685 | 8 |
583547 | 583547 | 2020-09-30 | Washington | Georgia | 13303 | 676 | 8 |
580308 | 580308 | 2020-09-29 | Washington | Georgia | 13303 | 675 | 8 |
577067 | 577067 | 2020-09-28 | Washington | Georgia | 13303 | 672 | 8 |
573824 | 573824 | 2020-09-27 | Washington | Georgia | 13303 | 671 | 8 |
570582 | 570582 | 2020-09-26 | Washington | Georgia | 13303 | 670 | 8 |
567340 | 567340 | 2020-09-25 | Washington | Georgia | 13303 | 666 | 8 |
564100 | 564100 | 2020-09-24 | Washington | Georgia | 13303 | 664 | 8 |
560860 | 560860 | 2020-09-23 | Washington | Georgia | 13303 | 657 | 8 |
557624 | 557624 | 2020-09-22 | Washington | Georgia | 13303 | 655 | 8 |
554387 | 554387 | 2020-09-21 | Washington | Georgia | 13303 | 654 | 8 |
551148 | 551148 | 2020-09-20 | Washington | Georgia | 13303 | 654 | 8 |
547909 | 547909 | 2020-09-19 | Washington | Georgia | 13303 | 650 | 8 |
544671 | 544671 | 2020-09-18 | Washington | Georgia | 13303 | 652 | 7 |
541435 | 541435 | 2020-09-17 | Washington | Georgia | 13303 | 642 | 7 |
538198 | 538198 | 2020-09-16 | Washington | Georgia | 13303 | 641 | 7 |
534962 | 534962 | 2020-09-15 | Washington | Georgia | 13303 | 640 | 7 |
531727 | 531727 | 2020-09-14 | Washington | Georgia | 13303 | 638 | 7 |
528490 | 528490 | 2020-09-13 | Washington | Georgia | 13303 | 637 | 7 |
525254 | 525254 | 2020-09-12 | Washington | Georgia | 13303 | 637 | 7 |
522018 | 522018 | 2020-09-11 | Washington | Georgia | 13303 | 635 | 7 |
518781 | 518781 | 2020-09-10 | Washington | Georgia | 13303 | 634 | 7 |
515546 | 515546 | 2020-09-09 | Washington | Georgia | 13303 | 631 | 7 |
512313 | 512313 | 2020-09-08 | Washington | Georgia | 13303 | 630 | 6 |
509080 | 509080 | 2020-09-07 | Washington | Georgia | 13303 | 630 | 6 |
505848 | 505848 | 2020-09-06 | Washington | Georgia | 13303 | 627 | 6 |
502614 | 502614 | 2020-09-05 | Washington | Georgia | 13303 | 624 | 6 |
499380 | 499380 | 2020-09-04 | Washington | Georgia | 13303 | 619 | 6 |
496147 | 496147 | 2020-09-03 | Washington | Georgia | 13303 | 619 | 5 |
492913 | 492913 | 2020-09-02 | Washington | Georgia | 13303 | 616 | 5 |
489680 | 489680 | 2020-09-01 | Washington | Georgia | 13303 | 617 | 4 |
486447 | 486447 | 2020-08-31 | Washington | Georgia | 13303 | 614 | 4 |
483212 | 483212 | 2020-08-30 | Washington | Georgia | 13303 | 609 | 4 |
479978 | 479978 | 2020-08-29 | Washington | Georgia | 13303 | 607 | 4 |
476745 | 476745 | 2020-08-28 | Washington | Georgia | 13303 | 605 | 4 |
473512 | 473512 | 2020-08-27 | Washington | Georgia | 13303 | 598 | 4 |
470280 | 470280 | 2020-08-26 | Washington | Georgia | 13303 | 594 | 3 |
467051 | 467051 | 2020-08-25 | Washington | Georgia | 13303 | 592 | 3 |
463822 | 463822 | 2020-08-24 | Washington | Georgia | 13303 | 587 | 3 |
460593 | 460593 | 2020-08-23 | Washington | Georgia | 13303 | 586 | 3 |
457366 | 457366 | 2020-08-22 | Washington | Georgia | 13303 | 583 | 3 |
454138 | 454138 | 2020-08-21 | Washington | Georgia | 13303 | 579 | 3 |
450910 | 450910 | 2020-08-20 | Washington | Georgia | 13303 | 575 | 3 |
447682 | 447682 | 2020-08-19 | Washington | Georgia | 13303 | 564 | 3 |
444455 | 444455 | 2020-08-18 | Washington | Georgia | 13303 | 559 | 3 |
441229 | 441229 | 2020-08-17 | Washington | Georgia | 13303 | 540 | 3 |
438003 | 438003 | 2020-08-16 | Washington | Georgia | 13303 | 536 | 3 |
434777 | 434777 | 2020-08-15 | Washington | Georgia | 13303 | 531 | 3 |
431552 | 431552 | 2020-08-14 | Washington | Georgia | 13303 | 529 | 2 |
428324 | 428324 | 2020-08-13 | Washington | Georgia | 13303 | 518 | 2 |
425100 | 425100 | 2020-08-12 | Washington | Georgia | 13303 | 497 | 2 |
421879 | 421879 | 2020-08-11 | Washington | Georgia | 13303 | 486 | 2 |
418658 | 418658 | 2020-08-10 | Washington | Georgia | 13303 | 479 | 2 |
415437 | 415437 | 2020-08-09 | Washington | Georgia | 13303 | 475 | 2 |
412217 | 412217 | 2020-08-08 | Washington | Georgia | 13303 | 458 | 2 |
408998 | 408998 | 2020-08-07 | Washington | Georgia | 13303 | 454 | 2 |
405778 | 405778 | 2020-08-06 | Washington | Georgia | 13303 | 448 | 2 |
402560 | 402560 | 2020-08-05 | Washington | Georgia | 13303 | 449 | 2 |
399344 | 399344 | 2020-08-04 | Washington | Georgia | 13303 | 435 | 2 |
396128 | 396128 | 2020-08-03 | Washington | Georgia | 13303 | 427 | 2 |
392912 | 392912 | 2020-08-02 | Washington | Georgia | 13303 | 421 | 2 |
389695 | 389695 | 2020-08-01 | Washington | Georgia | 13303 | 410 | 2 |
386478 | 386478 | 2020-07-31 | Washington | Georgia | 13303 | 400 | 2 |
383260 | 383260 | 2020-07-30 | Washington | Georgia | 13303 | 387 | 1 |
380043 | 380043 | 2020-07-29 | Washington | Georgia | 13303 | 376 | 1 |
376826 | 376826 | 2020-07-28 | Washington | Georgia | 13303 | 365 | 1 |
373612 | 373612 | 2020-07-27 | Washington | Georgia | 13303 | 337 | 1 |
370400 | 370400 | 2020-07-26 | Washington | Georgia | 13303 | 332 | 1 |
367190 | 367190 | 2020-07-25 | Washington | Georgia | 13303 | 326 | 1 |
363983 | 363983 | 2020-07-24 | Washington | Georgia | 13303 | 301 | 1 |
360776 | 360776 | 2020-07-23 | Washington | Georgia | 13303 | 273 | 1 |
357571 | 357571 | 2020-07-22 | Washington | Georgia | 13303 | 254 | 1 |
354368 | 354368 | 2020-07-21 | Washington | Georgia | 13303 | 250 | 1 |
351166 | 351166 | 2020-07-20 | Washington | Georgia | 13303 | 244 | 1 |
347965 | 347965 | 2020-07-19 | Washington | Georgia | 13303 | 226 | 1 |
344765 | 344765 | 2020-07-18 | Washington | Georgia | 13303 | 221 | 1 |
341566 | 341566 | 2020-07-17 | Washington | Georgia | 13303 | 215 | 1 |
338369 | 338369 | 2020-07-16 | Washington | Georgia | 13303 | 208 | 1 |
335174 | 335174 | 2020-07-15 | Washington | Georgia | 13303 | 205 | 1 |
331981 | 331981 | 2020-07-14 | Washington | Georgia | 13303 | 198 | 1 |
328794 | 328794 | 2020-07-13 | Washington | Georgia | 13303 | 197 | 1 |
325608 | 325608 | 2020-07-12 | Washington | Georgia | 13303 | 188 | 1 |
322427 | 322427 | 2020-07-11 | Washington | Georgia | 13303 | 183 | 1 |
319248 | 319248 | 2020-07-10 | Washington | Georgia | 13303 | 177 | 1 |
316075 | 316075 | 2020-07-09 | Washington | Georgia | 13303 | 163 | 1 |
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);