ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 39043 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1081551 | 1081551 | 2021-03-02 | Erie | Ohio | 39043 | 6895 | 140 |
1078305 | 1078305 | 2021-03-01 | Erie | Ohio | 39043 | 6872 | 184 |
1075060 | 1075060 | 2021-02-28 | Erie | Ohio | 39043 | 6858 | 184 |
1071814 | 1071814 | 2021-02-27 | Erie | Ohio | 39043 | 6852 | 184 |
1068568 | 1068568 | 2021-02-26 | Erie | Ohio | 39043 | 6826 | 184 |
1065323 | 1065323 | 2021-02-25 | Erie | Ohio | 39043 | 6820 | 184 |
1062079 | 1062079 | 2021-02-24 | Erie | Ohio | 39043 | 6803 | 183 |
1058833 | 1058833 | 2021-02-23 | Erie | Ohio | 39043 | 6783 | 181 |
1055587 | 1055587 | 2021-02-22 | Erie | Ohio | 39043 | 6767 | 180 |
1052341 | 1052341 | 2021-02-21 | Erie | Ohio | 39043 | 6758 | 180 |
1049094 | 1049094 | 2021-02-20 | Erie | Ohio | 39043 | 6749 | 180 |
1045847 | 1045847 | 2021-02-19 | Erie | Ohio | 39043 | 6729 | 178 |
1042602 | 1042602 | 2021-02-18 | Erie | Ohio | 39043 | 6707 | 177 |
1039357 | 1039357 | 2021-02-17 | Erie | Ohio | 39043 | 6697 | 176 |
1036112 | 1036112 | 2021-02-16 | Erie | Ohio | 39043 | 6686 | 174 |
1032867 | 1032867 | 2021-02-15 | Erie | Ohio | 39043 | 6669 | 171 |
1029621 | 1029621 | 2021-02-14 | Erie | Ohio | 39043 | 6661 | 171 |
1026374 | 1026374 | 2021-02-13 | Erie | Ohio | 39043 | 6655 | 171 |
1023129 | 1023129 | 2021-02-12 | Erie | Ohio | 39043 | 6645 | 168 |
1019884 | 1019884 | 2021-02-11 | Erie | Ohio | 39043 | 6626 | 148 |
1016639 | 1016639 | 2021-02-10 | Erie | Ohio | 39043 | 6610 | 143 |
1013394 | 1013394 | 2021-02-09 | Erie | Ohio | 39043 | 6592 | 143 |
1010149 | 1010149 | 2021-02-08 | Erie | Ohio | 39043 | 6579 | 142 |
1006903 | 1006903 | 2021-02-07 | Erie | Ohio | 39043 | 6567 | 142 |
1003657 | 1003657 | 2021-02-06 | Erie | Ohio | 39043 | 6559 | 142 |
1000411 | 1000411 | 2021-02-05 | Erie | Ohio | 39043 | 6541 | 141 |
997165 | 997165 | 2021-02-04 | Erie | Ohio | 39043 | 6533 | 136 |
993919 | 993919 | 2021-02-03 | Erie | Ohio | 39043 | 6499 | 135 |
990673 | 990673 | 2021-02-02 | Erie | Ohio | 39043 | 6468 | 134 |
987427 | 987427 | 2021-02-01 | Erie | Ohio | 39043 | 6448 | 132 |
984180 | 984180 | 2021-01-31 | Erie | Ohio | 39043 | 6413 | 131 |
980933 | 980933 | 2021-01-30 | Erie | Ohio | 39043 | 6399 | 131 |
977687 | 977687 | 2021-01-29 | Erie | Ohio | 39043 | 6358 | 131 |
974442 | 974442 | 2021-01-28 | Erie | Ohio | 39043 | 6331 | 131 |
971197 | 971197 | 2021-01-27 | Erie | Ohio | 39043 | 6280 | 130 |
967952 | 967952 | 2021-01-26 | Erie | Ohio | 39043 | 6253 | 130 |
964708 | 964708 | 2021-01-25 | Erie | Ohio | 39043 | 6221 | 130 |
961463 | 961463 | 2021-01-24 | Erie | Ohio | 39043 | 6188 | 129 |
958218 | 958218 | 2021-01-23 | Erie | Ohio | 39043 | 6152 | 129 |
954972 | 954972 | 2021-01-22 | Erie | Ohio | 39043 | 6113 | 127 |
951727 | 951727 | 2021-01-21 | Erie | Ohio | 39043 | 6090 | 127 |
948482 | 948482 | 2021-01-20 | Erie | Ohio | 39043 | 6022 | 120 |
945236 | 945236 | 2021-01-19 | Erie | Ohio | 39043 | 5976 | 118 |
941989 | 941989 | 2021-01-18 | Erie | Ohio | 39043 | 5943 | 118 |
938744 | 938744 | 2021-01-17 | Erie | Ohio | 39043 | 5886 | 118 |
935499 | 935499 | 2021-01-16 | Erie | Ohio | 39043 | 5866 | 117 |
932254 | 932254 | 2021-01-15 | Erie | Ohio | 39043 | 5808 | 117 |
929009 | 929009 | 2021-01-14 | Erie | Ohio | 39043 | 5729 | 117 |
925764 | 925764 | 2021-01-13 | Erie | Ohio | 39043 | 5665 | 113 |
922518 | 922518 | 2021-01-12 | Erie | Ohio | 39043 | 5623 | 113 |
919273 | 919273 | 2021-01-11 | Erie | Ohio | 39043 | 5567 | 113 |
916028 | 916028 | 2021-01-10 | Erie | Ohio | 39043 | 5508 | 112 |
912783 | 912783 | 2021-01-09 | Erie | Ohio | 39043 | 5457 | 112 |
909538 | 909538 | 2021-01-08 | Erie | Ohio | 39043 | 5397 | 111 |
906293 | 906293 | 2021-01-07 | Erie | Ohio | 39043 | 5307 | 111 |
903047 | 903047 | 2021-01-06 | Erie | Ohio | 39043 | 5226 | 111 |
899802 | 899802 | 2021-01-05 | Erie | Ohio | 39043 | 5149 | 107 |
896557 | 896557 | 2021-01-04 | Erie | Ohio | 39043 | 5049 | 107 |
893311 | 893311 | 2021-01-03 | Erie | Ohio | 39043 | 5001 | 107 |
890065 | 890065 | 2021-01-02 | Erie | Ohio | 39043 | 4971 | 107 |
886818 | 886818 | 2021-01-01 | Erie | Ohio | 39043 | 4912 | 107 |
883573 | 883573 | 2020-12-31 | Erie | Ohio | 39043 | 4912 | 107 |
880328 | 880328 | 2020-12-30 | Erie | Ohio | 39043 | 4833 | 107 |
877083 | 877083 | 2020-12-29 | Erie | Ohio | 39043 | 4716 | 105 |
873838 | 873838 | 2020-12-28 | Erie | Ohio | 39043 | 4663 | 101 |
870593 | 870593 | 2020-12-27 | Erie | Ohio | 39043 | 4613 | 101 |
867348 | 867348 | 2020-12-26 | Erie | Ohio | 39043 | 4579 | 100 |
864103 | 864103 | 2020-12-25 | Erie | Ohio | 39043 | 4510 | 99 |
860858 | 860858 | 2020-12-24 | Erie | Ohio | 39043 | 4510 | 99 |
857613 | 857613 | 2020-12-23 | Erie | Ohio | 39043 | 4397 | 99 |
854368 | 854368 | 2020-12-22 | Erie | Ohio | 39043 | 4327 | 97 |
851123 | 851123 | 2020-12-21 | Erie | Ohio | 39043 | 4256 | 92 |
847878 | 847878 | 2020-12-20 | Erie | Ohio | 39043 | 4215 | 91 |
844633 | 844633 | 2020-12-19 | Erie | Ohio | 39043 | 4155 | 91 |
841387 | 841387 | 2020-12-18 | Erie | Ohio | 39043 | 4098 | 91 |
838142 | 838142 | 2020-12-17 | Erie | Ohio | 39043 | 4024 | 91 |
834896 | 834896 | 2020-12-16 | Erie | Ohio | 39043 | 3920 | 88 |
831650 | 831650 | 2020-12-15 | Erie | Ohio | 39043 | 3857 | 86 |
828403 | 828403 | 2020-12-14 | Erie | Ohio | 39043 | 3793 | 84 |
825157 | 825157 | 2020-12-13 | Erie | Ohio | 39043 | 3702 | 84 |
821910 | 821910 | 2020-12-12 | Erie | Ohio | 39043 | 3578 | 83 |
818664 | 818664 | 2020-12-11 | Erie | Ohio | 39043 | 3494 | 79 |
815418 | 815418 | 2020-12-10 | Erie | Ohio | 39043 | 3412 | 79 |
812172 | 812172 | 2020-12-09 | Erie | Ohio | 39043 | 3339 | 77 |
808928 | 808928 | 2020-12-08 | Erie | Ohio | 39043 | 3273 | 71 |
805683 | 805683 | 2020-12-07 | Erie | Ohio | 39043 | 2935 | 70 |
802438 | 802438 | 2020-12-06 | Erie | Ohio | 39043 | 2856 | 70 |
799193 | 799193 | 2020-12-05 | Erie | Ohio | 39043 | 2802 | 70 |
795948 | 795948 | 2020-12-04 | Erie | Ohio | 39043 | 2733 | 70 |
792703 | 792703 | 2020-12-03 | Erie | Ohio | 39043 | 2666 | 70 |
789458 | 789458 | 2020-12-02 | Erie | Ohio | 39043 | 2612 | 70 |
786213 | 786213 | 2020-12-01 | Erie | Ohio | 39043 | 2578 | 70 |
782969 | 782969 | 2020-11-30 | Erie | Ohio | 39043 | 2545 | 69 |
779723 | 779723 | 2020-11-29 | Erie | Ohio | 39043 | 2506 | 69 |
776478 | 776478 | 2020-11-28 | Erie | Ohio | 39043 | 2475 | 68 |
773233 | 773233 | 2020-11-27 | Erie | Ohio | 39043 | 2408 | 68 |
769988 | 769988 | 2020-11-26 | Erie | Ohio | 39043 | 2302 | 68 |
766742 | 766742 | 2020-11-25 | Erie | Ohio | 39043 | 2302 | 68 |
763497 | 763497 | 2020-11-24 | Erie | Ohio | 39043 | 2242 | 66 |
760252 | 760252 | 2020-11-23 | Erie | Ohio | 39043 | 2171 | 65 |
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);