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 |
---|---|---|---|---|---|---|---|
1055569 | 1055569 | 2021-02-22 | Ashtabula | Ohio | 39007 | 5746 | 140 |
1052323 | 1052323 | 2021-02-21 | Ashtabula | Ohio | 39007 | 5629 | 140 |
1049076 | 1049076 | 2021-02-20 | Ashtabula | Ohio | 39007 | 5619 | 138 |
1045829 | 1045829 | 2021-02-19 | Ashtabula | Ohio | 39007 | 5585 | 137 |
1042584 | 1042584 | 2021-02-18 | Ashtabula | Ohio | 39007 | 5564 | 137 |
1039339 | 1039339 | 2021-02-17 | Ashtabula | Ohio | 39007 | 5526 | 137 |
1036094 | 1036094 | 2021-02-16 | Ashtabula | Ohio | 39007 | 5408 | 137 |
1032849 | 1032849 | 2021-02-15 | Ashtabula | Ohio | 39007 | 5382 | 136 |
1029603 | 1029603 | 2021-02-14 | Ashtabula | Ohio | 39007 | 5335 | 134 |
1026356 | 1026356 | 2021-02-13 | Ashtabula | Ohio | 39007 | 5327 | 134 |
1023111 | 1023111 | 2021-02-12 | Ashtabula | Ohio | 39007 | 5302 | 123 |
1019866 | 1019866 | 2021-02-11 | Ashtabula | Ohio | 39007 | 5246 | 90 |
1016621 | 1016621 | 2021-02-10 | Ashtabula | Ohio | 39007 | 5183 | 80 |
1013376 | 1013376 | 2021-02-09 | Ashtabula | Ohio | 39007 | 5085 | 80 |
1010131 | 1010131 | 2021-02-08 | Ashtabula | Ohio | 39007 | 5009 | 80 |
1006885 | 1006885 | 2021-02-07 | Ashtabula | Ohio | 39007 | 4979 | 80 |
1003639 | 1003639 | 2021-02-06 | Ashtabula | Ohio | 39007 | 4970 | 80 |
1000393 | 1000393 | 2021-02-05 | Ashtabula | Ohio | 39007 | 4947 | 80 |
997147 | 997147 | 2021-02-04 | Ashtabula | Ohio | 39007 | 4914 | 80 |
993901 | 993901 | 2021-02-03 | Ashtabula | Ohio | 39007 | 4874 | 77 |
990655 | 990655 | 2021-02-02 | Ashtabula | Ohio | 39007 | 4782 | 76 |
987409 | 987409 | 2021-02-01 | Ashtabula | Ohio | 39007 | 4722 | 75 |
984162 | 984162 | 2021-01-31 | Ashtabula | Ohio | 39007 | 4700 | 75 |
980915 | 980915 | 2021-01-30 | Ashtabula | Ohio | 39007 | 4689 | 75 |
977669 | 977669 | 2021-01-29 | Ashtabula | Ohio | 39007 | 4679 | 73 |
974424 | 974424 | 2021-01-28 | Ashtabula | Ohio | 39007 | 4627 | 73 |
971179 | 971179 | 2021-01-27 | Ashtabula | Ohio | 39007 | 4588 | 73 |
967934 | 967934 | 2021-01-26 | Ashtabula | Ohio | 39007 | 4579 | 73 |
964690 | 964690 | 2021-01-25 | Ashtabula | Ohio | 39007 | 4564 | 73 |
961445 | 961445 | 2021-01-24 | Ashtabula | Ohio | 39007 | 4546 | 73 |
958200 | 958200 | 2021-01-23 | Ashtabula | Ohio | 39007 | 4530 | 73 |
954954 | 954954 | 2021-01-22 | Ashtabula | Ohio | 39007 | 4510 | 73 |
951709 | 951709 | 2021-01-21 | Ashtabula | Ohio | 39007 | 4493 | 73 |
948464 | 948464 | 2021-01-20 | Ashtabula | Ohio | 39007 | 4463 | 73 |
945218 | 945218 | 2021-01-19 | Ashtabula | Ohio | 39007 | 4431 | 72 |
941971 | 941971 | 2021-01-18 | Ashtabula | Ohio | 39007 | 4405 | 72 |
938726 | 938726 | 2021-01-17 | Ashtabula | Ohio | 39007 | 4390 | 68 |
935481 | 935481 | 2021-01-16 | Ashtabula | Ohio | 39007 | 4372 | 68 |
932236 | 932236 | 2021-01-15 | Ashtabula | Ohio | 39007 | 4346 | 67 |
928991 | 928991 | 2021-01-14 | Ashtabula | Ohio | 39007 | 4314 | 67 |
925746 | 925746 | 2021-01-13 | Ashtabula | Ohio | 39007 | 4294 | 67 |
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 |
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);