ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
470 rows where deaths = 14 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1269945 | 1269945 | 2021-04-29 | Vinton | Ohio | 39163 | 818 | 14 |
1266698 | 1266698 | 2021-04-28 | Vinton | Ohio | 39163 | 817 | 14 |
1263451 | 1263451 | 2021-04-27 | Vinton | Ohio | 39163 | 816 | 14 |
1260204 | 1260204 | 2021-04-26 | Vinton | Ohio | 39163 | 816 | 14 |
1256957 | 1256957 | 2021-04-25 | Vinton | Ohio | 39163 | 816 | 14 |
1253710 | 1253710 | 2021-04-24 | Vinton | Ohio | 39163 | 816 | 14 |
1250463 | 1250463 | 2021-04-23 | Vinton | Ohio | 39163 | 816 | 14 |
1247216 | 1247216 | 2021-04-22 | Vinton | Ohio | 39163 | 817 | 14 |
1243969 | 1243969 | 2021-04-21 | Vinton | Ohio | 39163 | 816 | 14 |
1240722 | 1240722 | 2021-04-20 | Vinton | Ohio | 39163 | 816 | 14 |
1237475 | 1237475 | 2021-04-19 | Vinton | Ohio | 39163 | 816 | 14 |
1234228 | 1234228 | 2021-04-18 | Vinton | Ohio | 39163 | 815 | 14 |
1230980 | 1230980 | 2021-04-17 | Vinton | Ohio | 39163 | 815 | 14 |
1227732 | 1227732 | 2021-04-16 | Vinton | Ohio | 39163 | 814 | 14 |
1224484 | 1224484 | 2021-04-15 | Vinton | Ohio | 39163 | 814 | 14 |
1221237 | 1221237 | 2021-04-14 | Vinton | Ohio | 39163 | 813 | 14 |
1217989 | 1217989 | 2021-04-13 | Vinton | Ohio | 39163 | 810 | 14 |
1042662 | 1042662 | 2021-02-18 | Vinton | Ohio | 39163 | 759 | 14 |
1039417 | 1039417 | 2021-02-17 | Vinton | Ohio | 39163 | 757 | 14 |
1036172 | 1036172 | 2021-02-16 | Vinton | Ohio | 39163 | 756 | 14 |
1032927 | 1032927 | 2021-02-15 | Vinton | Ohio | 39163 | 756 | 14 |
1029681 | 1029681 | 2021-02-14 | Vinton | Ohio | 39163 | 756 | 14 |
1026434 | 1026434 | 2021-02-13 | Vinton | Ohio | 39163 | 755 | 14 |
1023189 | 1023189 | 2021-02-12 | Vinton | Ohio | 39163 | 755 | 14 |
1019944 | 1019944 | 2021-02-11 | Vinton | Ohio | 39163 | 753 | 14 |
1016699 | 1016699 | 2021-02-10 | Vinton | Ohio | 39163 | 751 | 14 |
1013454 | 1013454 | 2021-02-09 | Vinton | Ohio | 39163 | 747 | 14 |
1010209 | 1010209 | 2021-02-08 | Vinton | Ohio | 39163 | 748 | 14 |
1006963 | 1006963 | 2021-02-07 | Vinton | Ohio | 39163 | 748 | 14 |
1003717 | 1003717 | 2021-02-06 | Vinton | Ohio | 39163 | 746 | 14 |
1000471 | 1000471 | 2021-02-05 | Vinton | Ohio | 39163 | 745 | 14 |
997225 | 997225 | 2021-02-04 | Vinton | Ohio | 39163 | 742 | 14 |
993979 | 993979 | 2021-02-03 | Vinton | Ohio | 39163 | 737 | 14 |
990733 | 990733 | 2021-02-02 | Vinton | Ohio | 39163 | 733 | 14 |
987487 | 987487 | 2021-02-01 | Vinton | Ohio | 39163 | 734 | 14 |
984240 | 984240 | 2021-01-31 | Vinton | Ohio | 39163 | 732 | 14 |
980993 | 980993 | 2021-01-30 | Vinton | Ohio | 39163 | 729 | 14 |
977747 | 977747 | 2021-01-29 | Vinton | Ohio | 39163 | 726 | 14 |
974502 | 974502 | 2021-01-28 | Vinton | Ohio | 39163 | 724 | 14 |
971257 | 971257 | 2021-01-27 | Vinton | Ohio | 39163 | 720 | 14 |
968012 | 968012 | 2021-01-26 | Vinton | Ohio | 39163 | 717 | 14 |
964768 | 964768 | 2021-01-25 | Vinton | Ohio | 39163 | 713 | 14 |
919261 | 919261 | 2021-01-11 | Carroll | Ohio | 39019 | 1385 | 14 |
916016 | 916016 | 2021-01-10 | Carroll | Ohio | 39019 | 1333 | 14 |
912771 | 912771 | 2021-01-09 | Carroll | Ohio | 39019 | 1325 | 14 |
912814 | 912814 | 2021-01-09 | Meigs | Ohio | 39105 | 941 | 14 |
909526 | 909526 | 2021-01-08 | Carroll | Ohio | 39019 | 1294 | 14 |
909569 | 909569 | 2021-01-08 | Meigs | Ohio | 39105 | 930 | 14 |
906272 | 906272 | 2021-01-07 | Adams | Ohio | 39001 | 1502 | 14 |
906281 | 906281 | 2021-01-07 | Carroll | Ohio | 39019 | 1265 | 14 |
906324 | 906324 | 2021-01-07 | Meigs | Ohio | 39105 | 921 | 14 |
906337 | 906337 | 2021-01-07 | Pike | Ohio | 39131 | 1493 | 14 |
903026 | 903026 | 2021-01-06 | Adams | Ohio | 39001 | 1466 | 14 |
903078 | 903078 | 2021-01-06 | Meigs | Ohio | 39105 | 912 | 14 |
899781 | 899781 | 2021-01-05 | Adams | Ohio | 39001 | 1446 | 14 |
899788 | 899788 | 2021-01-05 | Brown | Ohio | 39015 | 2552 | 14 |
899833 | 899833 | 2021-01-05 | Meigs | Ohio | 39105 | 904 | 14 |
896536 | 896536 | 2021-01-04 | Adams | Ohio | 39001 | 1423 | 14 |
896588 | 896588 | 2021-01-04 | Meigs | Ohio | 39105 | 886 | 14 |
893290 | 893290 | 2021-01-03 | Adams | Ohio | 39001 | 1410 | 14 |
893342 | 893342 | 2021-01-03 | Meigs | Ohio | 39105 | 877 | 14 |
890044 | 890044 | 2021-01-02 | Adams | Ohio | 39001 | 1395 | 14 |
890096 | 890096 | 2021-01-02 | Meigs | Ohio | 39105 | 868 | 14 |
886797 | 886797 | 2021-01-01 | Adams | Ohio | 39001 | 1367 | 14 |
886849 | 886849 | 2021-01-01 | Meigs | Ohio | 39105 | 844 | 14 |
883552 | 883552 | 2020-12-31 | Adams | Ohio | 39001 | 1367 | 14 |
883604 | 883604 | 2020-12-31 | Meigs | Ohio | 39105 | 844 | 14 |
880307 | 880307 | 2020-12-30 | Adams | Ohio | 39001 | 1336 | 14 |
880359 | 880359 | 2020-12-30 | Meigs | Ohio | 39105 | 830 | 14 |
877062 | 877062 | 2020-12-29 | Adams | Ohio | 39001 | 1322 | 14 |
877114 | 877114 | 2020-12-29 | Meigs | Ohio | 39105 | 813 | 14 |
873817 | 873817 | 2020-12-28 | Adams | Ohio | 39001 | 1294 | 14 |
873869 | 873869 | 2020-12-28 | Meigs | Ohio | 39105 | 804 | 14 |
870572 | 870572 | 2020-12-27 | Adams | Ohio | 39001 | 1284 | 14 |
870624 | 870624 | 2020-12-27 | Meigs | Ohio | 39105 | 792 | 14 |
867327 | 867327 | 2020-12-26 | Adams | Ohio | 39001 | 1269 | 14 |
867379 | 867379 | 2020-12-26 | Meigs | Ohio | 39105 | 787 | 14 |
864082 | 864082 | 2020-12-25 | Adams | Ohio | 39001 | 1259 | 14 |
864134 | 864134 | 2020-12-25 | Meigs | Ohio | 39105 | 771 | 14 |
860837 | 860837 | 2020-12-24 | Adams | Ohio | 39001 | 1259 | 14 |
860889 | 860889 | 2020-12-24 | Meigs | Ohio | 39105 | 771 | 14 |
857592 | 857592 | 2020-12-23 | Adams | Ohio | 39001 | 1245 | 14 |
857644 | 857644 | 2020-12-23 | Meigs | Ohio | 39105 | 754 | 14 |
854347 | 854347 | 2020-12-22 | Adams | Ohio | 39001 | 1223 | 14 |
854399 | 854399 | 2020-12-22 | Meigs | Ohio | 39105 | 748 | 14 |
851102 | 851102 | 2020-12-21 | Adams | Ohio | 39001 | 1179 | 14 |
851154 | 851154 | 2020-12-21 | Meigs | Ohio | 39105 | 741 | 14 |
847857 | 847857 | 2020-12-20 | Adams | Ohio | 39001 | 1163 | 14 |
847909 | 847909 | 2020-12-20 | Meigs | Ohio | 39105 | 732 | 14 |
844612 | 844612 | 2020-12-19 | Adams | Ohio | 39001 | 1159 | 14 |
844664 | 844664 | 2020-12-19 | Meigs | Ohio | 39105 | 722 | 14 |
841366 | 841366 | 2020-12-18 | Adams | Ohio | 39001 | 1145 | 14 |
841418 | 841418 | 2020-12-18 | Meigs | Ohio | 39105 | 710 | 14 |
838121 | 838121 | 2020-12-17 | Adams | Ohio | 39001 | 1132 | 14 |
838173 | 838173 | 2020-12-17 | Meigs | Ohio | 39105 | 702 | 14 |
834875 | 834875 | 2020-12-16 | Adams | Ohio | 39001 | 1113 | 14 |
831629 | 831629 | 2020-12-15 | Adams | Ohio | 39001 | 1100 | 14 |
825199 | 825199 | 2020-12-13 | Perry | Ohio | 39127 | 1412 | 14 |
821952 | 821952 | 2020-12-12 | Perry | Ohio | 39127 | 1387 | 14 |
818706 | 818706 | 2020-12-11 | Perry | Ohio | 39127 | 1340 | 14 |
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);