ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Ashtabula" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922500 | 922500 | 2021-01-12 | Ashtabula | Ohio | 39007 | 4263 | 66 |
919255 | 919255 | 2021-01-11 | Ashtabula | Ohio | 39007 | 4234 | 66 |
916010 | 916010 | 2021-01-10 | Ashtabula | Ohio | 39007 | 4203 | 66 |
912765 | 912765 | 2021-01-09 | Ashtabula | Ohio | 39007 | 4166 | 66 |
909520 | 909520 | 2021-01-08 | Ashtabula | Ohio | 39007 | 4129 | 66 |
906275 | 906275 | 2021-01-07 | Ashtabula | Ohio | 39007 | 4076 | 66 |
903029 | 903029 | 2021-01-06 | Ashtabula | Ohio | 39007 | 4037 | 66 |
899784 | 899784 | 2021-01-05 | Ashtabula | Ohio | 39007 | 4011 | 66 |
896539 | 896539 | 2021-01-04 | Ashtabula | Ohio | 39007 | 3957 | 66 |
893293 | 893293 | 2021-01-03 | Ashtabula | Ohio | 39007 | 3930 | 66 |
890047 | 890047 | 2021-01-02 | Ashtabula | Ohio | 39007 | 3900 | 66 |
886800 | 886800 | 2021-01-01 | Ashtabula | Ohio | 39007 | 3829 | 66 |
883555 | 883555 | 2020-12-31 | Ashtabula | Ohio | 39007 | 3829 | 66 |
880310 | 880310 | 2020-12-30 | Ashtabula | Ohio | 39007 | 3795 | 66 |
877065 | 877065 | 2020-12-29 | Ashtabula | Ohio | 39007 | 3776 | 66 |
873820 | 873820 | 2020-12-28 | Ashtabula | Ohio | 39007 | 3720 | 66 |
870575 | 870575 | 2020-12-27 | Ashtabula | Ohio | 39007 | 3705 | 65 |
867330 | 867330 | 2020-12-26 | Ashtabula | Ohio | 39007 | 3686 | 65 |
864085 | 864085 | 2020-12-25 | Ashtabula | Ohio | 39007 | 3636 | 65 |
860840 | 860840 | 2020-12-24 | Ashtabula | Ohio | 39007 | 3636 | 65 |
857595 | 857595 | 2020-12-23 | Ashtabula | Ohio | 39007 | 3597 | 65 |
854350 | 854350 | 2020-12-22 | Ashtabula | Ohio | 39007 | 3556 | 65 |
851105 | 851105 | 2020-12-21 | Ashtabula | Ohio | 39007 | 3523 | 65 |
847860 | 847860 | 2020-12-20 | Ashtabula | Ohio | 39007 | 3504 | 65 |
844615 | 844615 | 2020-12-19 | Ashtabula | Ohio | 39007 | 3453 | 65 |
841369 | 841369 | 2020-12-18 | Ashtabula | Ohio | 39007 | 3417 | 65 |
838124 | 838124 | 2020-12-17 | Ashtabula | Ohio | 39007 | 3347 | 65 |
834878 | 834878 | 2020-12-16 | Ashtabula | Ohio | 39007 | 3299 | 65 |
831632 | 831632 | 2020-12-15 | Ashtabula | Ohio | 39007 | 3284 | 65 |
828385 | 828385 | 2020-12-14 | Ashtabula | Ohio | 39007 | 3246 | 65 |
825139 | 825139 | 2020-12-13 | Ashtabula | Ohio | 39007 | 3206 | 62 |
821892 | 821892 | 2020-12-12 | Ashtabula | Ohio | 39007 | 3160 | 62 |
818646 | 818646 | 2020-12-11 | Ashtabula | Ohio | 39007 | 3108 | 62 |
815400 | 815400 | 2020-12-10 | Ashtabula | Ohio | 39007 | 3080 | 62 |
812154 | 812154 | 2020-12-09 | Ashtabula | Ohio | 39007 | 3066 | 61 |
808910 | 808910 | 2020-12-08 | Ashtabula | Ohio | 39007 | 3012 | 60 |
805665 | 805665 | 2020-12-07 | Ashtabula | Ohio | 39007 | 2903 | 58 |
802420 | 802420 | 2020-12-06 | Ashtabula | Ohio | 39007 | 2855 | 57 |
799175 | 799175 | 2020-12-05 | Ashtabula | Ohio | 39007 | 2806 | 57 |
795930 | 795930 | 2020-12-04 | Ashtabula | Ohio | 39007 | 2767 | 57 |
792685 | 792685 | 2020-12-03 | Ashtabula | Ohio | 39007 | 2719 | 57 |
789440 | 789440 | 2020-12-02 | Ashtabula | Ohio | 39007 | 2692 | 57 |
786195 | 786195 | 2020-12-01 | Ashtabula | Ohio | 39007 | 2630 | 56 |
782951 | 782951 | 2020-11-30 | Ashtabula | Ohio | 39007 | 2573 | 55 |
779705 | 779705 | 2020-11-29 | Ashtabula | Ohio | 39007 | 2515 | 55 |
776460 | 776460 | 2020-11-28 | Ashtabula | Ohio | 39007 | 2473 | 54 |
773215 | 773215 | 2020-11-27 | Ashtabula | Ohio | 39007 | 2404 | 54 |
769970 | 769970 | 2020-11-26 | Ashtabula | Ohio | 39007 | 2283 | 54 |
766724 | 766724 | 2020-11-25 | Ashtabula | Ohio | 39007 | 2283 | 54 |
763479 | 763479 | 2020-11-24 | Ashtabula | Ohio | 39007 | 2232 | 53 |
760234 | 760234 | 2020-11-23 | Ashtabula | Ohio | 39007 | 2157 | 53 |
756989 | 756989 | 2020-11-22 | Ashtabula | Ohio | 39007 | 2047 | 53 |
753742 | 753742 | 2020-11-21 | Ashtabula | Ohio | 39007 | 1981 | 53 |
750496 | 750496 | 2020-11-20 | Ashtabula | Ohio | 39007 | 1915 | 53 |
747250 | 747250 | 2020-11-19 | Ashtabula | Ohio | 39007 | 1831 | 53 |
744004 | 744004 | 2020-11-18 | Ashtabula | Ohio | 39007 | 1752 | 53 |
740757 | 740757 | 2020-11-17 | Ashtabula | Ohio | 39007 | 1678 | 53 |
737511 | 737511 | 2020-11-16 | Ashtabula | Ohio | 39007 | 1600 | 48 |
734267 | 734267 | 2020-11-15 | Ashtabula | Ohio | 39007 | 1543 | 48 |
731021 | 731021 | 2020-11-14 | Ashtabula | Ohio | 39007 | 1497 | 48 |
727777 | 727777 | 2020-11-13 | Ashtabula | Ohio | 39007 | 1446 | 48 |
724533 | 724533 | 2020-11-12 | Ashtabula | Ohio | 39007 | 1344 | 48 |
721290 | 721290 | 2020-11-11 | Ashtabula | Ohio | 39007 | 1301 | 48 |
718047 | 718047 | 2020-11-10 | Ashtabula | Ohio | 39007 | 1238 | 48 |
714804 | 714804 | 2020-11-09 | Ashtabula | Ohio | 39007 | 1189 | 48 |
711560 | 711560 | 2020-11-08 | Ashtabula | Ohio | 39007 | 1138 | 48 |
708316 | 708316 | 2020-11-07 | Ashtabula | Ohio | 39007 | 1085 | 48 |
705073 | 705073 | 2020-11-06 | Ashtabula | Ohio | 39007 | 1034 | 48 |
701830 | 701830 | 2020-11-05 | Ashtabula | Ohio | 39007 | 993 | 48 |
698586 | 698586 | 2020-11-04 | Ashtabula | Ohio | 39007 | 946 | 48 |
695343 | 695343 | 2020-11-03 | Ashtabula | Ohio | 39007 | 927 | 48 |
692101 | 692101 | 2020-11-02 | Ashtabula | Ohio | 39007 | 917 | 48 |
688857 | 688857 | 2020-11-01 | Ashtabula | Ohio | 39007 | 890 | 48 |
685612 | 685612 | 2020-10-31 | Ashtabula | Ohio | 39007 | 856 | 48 |
682369 | 682369 | 2020-10-30 | Ashtabula | Ohio | 39007 | 833 | 48 |
679126 | 679126 | 2020-10-29 | Ashtabula | Ohio | 39007 | 806 | 48 |
675883 | 675883 | 2020-10-28 | Ashtabula | Ohio | 39007 | 790 | 48 |
672640 | 672640 | 2020-10-27 | Ashtabula | Ohio | 39007 | 779 | 48 |
669398 | 669398 | 2020-10-26 | Ashtabula | Ohio | 39007 | 760 | 48 |
666154 | 666154 | 2020-10-25 | Ashtabula | Ohio | 39007 | 749 | 48 |
662909 | 662909 | 2020-10-24 | Ashtabula | Ohio | 39007 | 740 | 48 |
659665 | 659665 | 2020-10-23 | Ashtabula | Ohio | 39007 | 735 | 48 |
656421 | 656421 | 2020-10-22 | Ashtabula | Ohio | 39007 | 726 | 48 |
653176 | 653176 | 2020-10-21 | Ashtabula | Ohio | 39007 | 721 | 48 |
649931 | 649931 | 2020-10-20 | Ashtabula | Ohio | 39007 | 721 | 48 |
646687 | 646687 | 2020-10-19 | Ashtabula | Ohio | 39007 | 714 | 48 |
643441 | 643441 | 2020-10-18 | Ashtabula | Ohio | 39007 | 713 | 48 |
640193 | 640193 | 2020-10-17 | Ashtabula | Ohio | 39007 | 705 | 48 |
636947 | 636947 | 2020-10-16 | Ashtabula | Ohio | 39007 | 698 | 48 |
633701 | 633701 | 2020-10-15 | Ashtabula | Ohio | 39007 | 693 | 48 |
630456 | 630456 | 2020-10-14 | Ashtabula | Ohio | 39007 | 692 | 48 |
627212 | 627212 | 2020-10-13 | Ashtabula | Ohio | 39007 | 690 | 48 |
623970 | 623970 | 2020-10-12 | Ashtabula | Ohio | 39007 | 689 | 48 |
620727 | 620727 | 2020-10-11 | Ashtabula | Ohio | 39007 | 686 | 48 |
617485 | 617485 | 2020-10-10 | Ashtabula | Ohio | 39007 | 684 | 48 |
614243 | 614243 | 2020-10-09 | Ashtabula | Ohio | 39007 | 682 | 48 |
611002 | 611002 | 2020-10-08 | Ashtabula | Ohio | 39007 | 680 | 48 |
607760 | 607760 | 2020-10-07 | Ashtabula | Ohio | 39007 | 680 | 48 |
604517 | 604517 | 2020-10-06 | Ashtabula | Ohio | 39007 | 679 | 48 |
601275 | 601275 | 2020-10-05 | Ashtabula | Ohio | 39007 | 674 | 48 |
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);