ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
114 rows where county = "Crawford" and deaths = 8 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 9
county 1
- Crawford · 114 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917621 | 917621 | 2021-01-11 | Crawford | Georgia | 13079 | 481 | 8 |
914376 | 914376 | 2021-01-10 | Crawford | Georgia | 13079 | 474 | 8 |
911131 | 911131 | 2021-01-09 | Crawford | Georgia | 13079 | 471 | 8 |
907886 | 907886 | 2021-01-08 | Crawford | Georgia | 13079 | 466 | 8 |
904640 | 904640 | 2021-01-07 | Crawford | Georgia | 13079 | 460 | 8 |
901395 | 901395 | 2021-01-06 | Crawford | Georgia | 13079 | 457 | 8 |
898150 | 898150 | 2021-01-05 | Crawford | Georgia | 13079 | 454 | 8 |
894905 | 894905 | 2021-01-04 | Crawford | Georgia | 13079 | 446 | 8 |
895191 | 895191 | 2021-01-04 | Crawford | Indiana | 18025 | 624 | 8 |
891658 | 891658 | 2021-01-03 | Crawford | Georgia | 13079 | 440 | 8 |
891944 | 891944 | 2021-01-03 | Crawford | Indiana | 18025 | 622 | 8 |
888411 | 888411 | 2021-01-02 | Crawford | Georgia | 13079 | 435 | 8 |
888698 | 888698 | 2021-01-02 | Crawford | Indiana | 18025 | 614 | 8 |
885166 | 885166 | 2021-01-01 | Crawford | Georgia | 13079 | 428 | 8 |
885452 | 885452 | 2021-01-01 | Crawford | Indiana | 18025 | 604 | 8 |
881921 | 881921 | 2020-12-31 | Crawford | Georgia | 13079 | 422 | 8 |
882207 | 882207 | 2020-12-31 | Crawford | Indiana | 18025 | 592 | 8 |
878676 | 878676 | 2020-12-30 | Crawford | Georgia | 13079 | 414 | 8 |
878962 | 878962 | 2020-12-30 | Crawford | Indiana | 18025 | 584 | 8 |
875431 | 875431 | 2020-12-29 | Crawford | Georgia | 13079 | 402 | 8 |
875717 | 875717 | 2020-12-29 | Crawford | Indiana | 18025 | 579 | 8 |
872186 | 872186 | 2020-12-28 | Crawford | Georgia | 13079 | 398 | 8 |
872472 | 872472 | 2020-12-28 | Crawford | Indiana | 18025 | 572 | 8 |
868941 | 868941 | 2020-12-27 | Crawford | Georgia | 13079 | 390 | 8 |
869227 | 869227 | 2020-12-27 | Crawford | Indiana | 18025 | 570 | 8 |
865696 | 865696 | 2020-12-26 | Crawford | Georgia | 13079 | 386 | 8 |
865982 | 865982 | 2020-12-26 | Crawford | Indiana | 18025 | 570 | 8 |
862451 | 862451 | 2020-12-25 | Crawford | Georgia | 13079 | 383 | 8 |
862737 | 862737 | 2020-12-25 | Crawford | Indiana | 18025 | 565 | 8 |
859206 | 859206 | 2020-12-24 | Crawford | Georgia | 13079 | 381 | 8 |
859492 | 859492 | 2020-12-24 | Crawford | Indiana | 18025 | 553 | 8 |
855961 | 855961 | 2020-12-23 | Crawford | Georgia | 13079 | 371 | 8 |
856247 | 856247 | 2020-12-23 | Crawford | Indiana | 18025 | 545 | 8 |
852716 | 852716 | 2020-12-22 | Crawford | Georgia | 13079 | 362 | 8 |
853002 | 853002 | 2020-12-22 | Crawford | Indiana | 18025 | 544 | 8 |
849471 | 849471 | 2020-12-21 | Crawford | Georgia | 13079 | 357 | 8 |
849757 | 849757 | 2020-12-21 | Crawford | Indiana | 18025 | 534 | 8 |
846226 | 846226 | 2020-12-20 | Crawford | Georgia | 13079 | 350 | 8 |
846512 | 846512 | 2020-12-20 | Crawford | Indiana | 18025 | 531 | 8 |
842980 | 842980 | 2020-12-19 | Crawford | Georgia | 13079 | 345 | 8 |
843266 | 843266 | 2020-12-19 | Crawford | Indiana | 18025 | 520 | 8 |
839735 | 839735 | 2020-12-18 | Crawford | Georgia | 13079 | 342 | 8 |
836490 | 836490 | 2020-12-17 | Crawford | Georgia | 13079 | 326 | 8 |
833244 | 833244 | 2020-12-16 | Crawford | Georgia | 13079 | 322 | 8 |
829997 | 829997 | 2020-12-15 | Crawford | Georgia | 13079 | 316 | 8 |
826751 | 826751 | 2020-12-14 | Crawford | Georgia | 13079 | 308 | 8 |
823504 | 823504 | 2020-12-13 | Crawford | Georgia | 13079 | 303 | 8 |
820258 | 820258 | 2020-12-12 | Crawford | Georgia | 13079 | 296 | 8 |
817012 | 817012 | 2020-12-11 | Crawford | Georgia | 13079 | 291 | 8 |
813766 | 813766 | 2020-12-10 | Crawford | Georgia | 13079 | 288 | 8 |
793785 | 793785 | 2020-12-03 | Crawford | Wisconsin | 55023 | 1378 | 8 |
790540 | 790540 | 2020-12-02 | Crawford | Wisconsin | 55023 | 1346 | 8 |
787295 | 787295 | 2020-12-01 | Crawford | Wisconsin | 55023 | 1343 | 8 |
744222 | 744222 | 2020-11-18 | Crawford | Pennsylvania | 42039 | 1241 | 8 |
736065 | 736065 | 2020-11-16 | Crawford | Illinois | 17033 | 859 | 8 |
732819 | 732819 | 2020-11-15 | Crawford | Illinois | 17033 | 841 | 8 |
729574 | 729574 | 2020-11-14 | Crawford | Illinois | 17033 | 835 | 8 |
726331 | 726331 | 2020-11-13 | Crawford | Illinois | 17033 | 812 | 8 |
723088 | 723088 | 2020-11-12 | Crawford | Illinois | 17033 | 792 | 8 |
719845 | 719845 | 2020-11-11 | Crawford | Illinois | 17033 | 788 | 8 |
698599 | 698599 | 2020-11-04 | Crawford | Ohio | 39033 | 648 | 8 |
695356 | 695356 | 2020-11-03 | Crawford | Ohio | 39033 | 631 | 8 |
692114 | 692114 | 2020-11-02 | Crawford | Ohio | 39033 | 618 | 8 |
688870 | 688870 | 2020-11-01 | Crawford | Ohio | 39033 | 609 | 8 |
685625 | 685625 | 2020-10-31 | Crawford | Ohio | 39033 | 599 | 8 |
681831 | 681831 | 2020-10-30 | Crawford | Missouri | 29055 | 675 | 8 |
682382 | 682382 | 2020-10-30 | Crawford | Ohio | 39033 | 594 | 8 |
678587 | 678587 | 2020-10-29 | Crawford | Missouri | 29055 | 665 | 8 |
679139 | 679139 | 2020-10-29 | Crawford | Ohio | 39033 | 581 | 8 |
675345 | 675345 | 2020-10-28 | Crawford | Missouri | 29055 | 646 | 8 |
675896 | 675896 | 2020-10-28 | Crawford | Ohio | 39033 | 548 | 8 |
672102 | 672102 | 2020-10-27 | Crawford | Missouri | 29055 | 639 | 8 |
672653 | 672653 | 2020-10-27 | Crawford | Ohio | 39033 | 540 | 8 |
668860 | 668860 | 2020-10-26 | Crawford | Missouri | 29055 | 629 | 8 |
669411 | 669411 | 2020-10-26 | Crawford | Ohio | 39033 | 526 | 8 |
665616 | 665616 | 2020-10-25 | Crawford | Missouri | 29055 | 621 | 8 |
666167 | 666167 | 2020-10-25 | Crawford | Ohio | 39033 | 513 | 8 |
662371 | 662371 | 2020-10-24 | Crawford | Missouri | 29055 | 609 | 8 |
662922 | 662922 | 2020-10-24 | Crawford | Ohio | 39033 | 503 | 8 |
659678 | 659678 | 2020-10-23 | Crawford | Ohio | 39033 | 468 | 8 |
655271 | 655271 | 2020-10-22 | Crawford | Kansas | 20037 | 1381 | 8 |
656434 | 656434 | 2020-10-22 | Crawford | Ohio | 39033 | 452 | 8 |
652026 | 652026 | 2020-10-21 | Crawford | Kansas | 20037 | 1381 | 8 |
653189 | 653189 | 2020-10-21 | Crawford | Ohio | 39033 | 441 | 8 |
648782 | 648782 | 2020-10-20 | Crawford | Kansas | 20037 | 1351 | 8 |
649944 | 649944 | 2020-10-20 | Crawford | Ohio | 39033 | 430 | 8 |
645537 | 645537 | 2020-10-19 | Crawford | Kansas | 20037 | 1351 | 8 |
646700 | 646700 | 2020-10-19 | Crawford | Ohio | 39033 | 417 | 8 |
642290 | 642290 | 2020-10-18 | Crawford | Kansas | 20037 | 1326 | 8 |
643454 | 643454 | 2020-10-18 | Crawford | Ohio | 39033 | 408 | 8 |
639043 | 639043 | 2020-10-17 | Crawford | Kansas | 20037 | 1326 | 8 |
640206 | 640206 | 2020-10-17 | Crawford | Ohio | 39033 | 401 | 8 |
635797 | 635797 | 2020-10-16 | Crawford | Kansas | 20037 | 1326 | 8 |
636960 | 636960 | 2020-10-16 | Crawford | Ohio | 39033 | 376 | 8 |
632551 | 632551 | 2020-10-15 | Crawford | Kansas | 20037 | 1294 | 8 |
629307 | 629307 | 2020-10-14 | Crawford | Kansas | 20037 | 1294 | 8 |
626064 | 626064 | 2020-10-13 | Crawford | Kansas | 20037 | 1256 | 8 |
622822 | 622822 | 2020-10-12 | Crawford | Kansas | 20037 | 1256 | 8 |
619578 | 619578 | 2020-10-11 | Crawford | Kansas | 20037 | 1223 | 8 |
616336 | 616336 | 2020-10-10 | Crawford | Kansas | 20037 | 1223 | 8 |
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);