ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Franklin" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1081554 | 1081554 | 2021-03-02 | Franklin | Ohio | 39049 | 112182 | 1214 |
1078308 | 1078308 | 2021-03-01 | Franklin | Ohio | 39049 | 111987 | 1212 |
1075063 | 1075063 | 2021-02-28 | Franklin | Ohio | 39049 | 111851 | 1208 |
1071817 | 1071817 | 2021-02-27 | Franklin | Ohio | 39049 | 111688 | 1202 |
1068571 | 1068571 | 2021-02-26 | Franklin | Ohio | 39049 | 111496 | 1198 |
1065326 | 1065326 | 2021-02-25 | Franklin | Ohio | 39049 | 111312 | 1196 |
1062082 | 1062082 | 2021-02-24 | Franklin | Ohio | 39049 | 111107 | 1193 |
1058836 | 1058836 | 2021-02-23 | Franklin | Ohio | 39049 | 110938 | 1191 |
1055590 | 1055590 | 2021-02-22 | Franklin | Ohio | 39049 | 110653 | 1186 |
1052344 | 1052344 | 2021-02-21 | Franklin | Ohio | 39049 | 110499 | 1181 |
1049097 | 1049097 | 2021-02-20 | Franklin | Ohio | 39049 | 110335 | 1178 |
1045850 | 1045850 | 2021-02-19 | Franklin | Ohio | 39049 | 110079 | 1176 |
1042605 | 1042605 | 2021-02-18 | Franklin | Ohio | 39049 | 109830 | 1175 |
1039360 | 1039360 | 2021-02-17 | Franklin | Ohio | 39049 | 109605 | 1172 |
1036115 | 1036115 | 2021-02-16 | Franklin | Ohio | 39049 | 109415 | 1169 |
1032870 | 1032870 | 2021-02-15 | Franklin | Ohio | 39049 | 109190 | 1168 |
1029624 | 1029624 | 2021-02-14 | Franklin | Ohio | 39049 | 108993 | 1163 |
1026377 | 1026377 | 2021-02-13 | Franklin | Ohio | 39049 | 108800 | 1163 |
1023132 | 1023132 | 2021-02-12 | Franklin | Ohio | 39049 | 108550 | 1060 |
1019887 | 1019887 | 2021-02-11 | Franklin | Ohio | 39049 | 108226 | 783 |
1016642 | 1016642 | 2021-02-10 | Franklin | Ohio | 39049 | 107954 | 714 |
1013397 | 1013397 | 2021-02-09 | Franklin | Ohio | 39049 | 107627 | 714 |
1010152 | 1010152 | 2021-02-08 | Franklin | Ohio | 39049 | 107282 | 713 |
1006906 | 1006906 | 2021-02-07 | Franklin | Ohio | 39049 | 107107 | 713 |
1003660 | 1003660 | 2021-02-06 | Franklin | Ohio | 39049 | 106893 | 713 |
1000414 | 1000414 | 2021-02-05 | Franklin | Ohio | 39049 | 106526 | 712 |
997168 | 997168 | 2021-02-04 | Franklin | Ohio | 39049 | 106211 | 712 |
993922 | 993922 | 2021-02-03 | Franklin | Ohio | 39049 | 105796 | 712 |
990676 | 990676 | 2021-02-02 | Franklin | Ohio | 39049 | 105457 | 710 |
987430 | 987430 | 2021-02-01 | Franklin | Ohio | 39049 | 105102 | 709 |
984183 | 984183 | 2021-01-31 | Franklin | Ohio | 39049 | 104761 | 709 |
980936 | 980936 | 2021-01-30 | Franklin | Ohio | 39049 | 104449 | 709 |
977690 | 977690 | 2021-01-29 | Franklin | Ohio | 39049 | 104034 | 709 |
974445 | 974445 | 2021-01-28 | Franklin | Ohio | 39049 | 103578 | 709 |
971200 | 971200 | 2021-01-27 | Franklin | Ohio | 39049 | 103088 | 708 |
967955 | 967955 | 2021-01-26 | Franklin | Ohio | 39049 | 102616 | 707 |
964711 | 964711 | 2021-01-25 | Franklin | Ohio | 39049 | 102154 | 707 |
961466 | 961466 | 2021-01-24 | Franklin | Ohio | 39049 | 101705 | 707 |
958221 | 958221 | 2021-01-23 | Franklin | Ohio | 39049 | 101171 | 707 |
954975 | 954975 | 2021-01-22 | Franklin | Ohio | 39049 | 100550 | 707 |
951730 | 951730 | 2021-01-21 | Franklin | Ohio | 39049 | 100046 | 706 |
948485 | 948485 | 2021-01-20 | Franklin | Ohio | 39049 | 99253 | 706 |
945239 | 945239 | 2021-01-19 | Franklin | Ohio | 39049 | 98533 | 705 |
941992 | 941992 | 2021-01-18 | Franklin | Ohio | 39049 | 97996 | 705 |
938747 | 938747 | 2021-01-17 | Franklin | Ohio | 39049 | 97493 | 705 |
935502 | 935502 | 2021-01-16 | Franklin | Ohio | 39049 | 96935 | 704 |
932257 | 932257 | 2021-01-15 | Franklin | Ohio | 39049 | 96280 | 704 |
929012 | 929012 | 2021-01-14 | Franklin | Ohio | 39049 | 95508 | 704 |
925767 | 925767 | 2021-01-13 | Franklin | Ohio | 39049 | 94591 | 702 |
922521 | 922521 | 2021-01-12 | Franklin | Ohio | 39049 | 93903 | 702 |
919276 | 919276 | 2021-01-11 | Franklin | Ohio | 39049 | 93057 | 701 |
916031 | 916031 | 2021-01-10 | Franklin | Ohio | 39049 | 92060 | 700 |
912786 | 912786 | 2021-01-09 | Franklin | Ohio | 39049 | 91391 | 700 |
909541 | 909541 | 2021-01-08 | Franklin | Ohio | 39049 | 90416 | 700 |
906296 | 906296 | 2021-01-07 | Franklin | Ohio | 39049 | 89439 | 700 |
903050 | 903050 | 2021-01-06 | Franklin | Ohio | 39049 | 88447 | 700 |
899805 | 899805 | 2021-01-05 | Franklin | Ohio | 39049 | 87784 | 700 |
896560 | 896560 | 2021-01-04 | Franklin | Ohio | 39049 | 87106 | 698 |
893314 | 893314 | 2021-01-03 | Franklin | Ohio | 39049 | 86446 | 698 |
890068 | 890068 | 2021-01-02 | Franklin | Ohio | 39049 | 85553 | 698 |
886821 | 886821 | 2021-01-01 | Franklin | Ohio | 39049 | 84050 | 698 |
883576 | 883576 | 2020-12-31 | Franklin | Ohio | 39049 | 84050 | 698 |
880331 | 880331 | 2020-12-30 | Franklin | Ohio | 39049 | 83105 | 698 |
877086 | 877086 | 2020-12-29 | Franklin | Ohio | 39049 | 82402 | 697 |
873841 | 873841 | 2020-12-28 | Franklin | Ohio | 39049 | 81515 | 697 |
870596 | 870596 | 2020-12-27 | Franklin | Ohio | 39049 | 80939 | 697 |
867351 | 867351 | 2020-12-26 | Franklin | Ohio | 39049 | 79986 | 697 |
864106 | 864106 | 2020-12-25 | Franklin | Ohio | 39049 | 78759 | 696 |
860861 | 860861 | 2020-12-24 | Franklin | Ohio | 39049 | 78759 | 696 |
857616 | 857616 | 2020-12-23 | Franklin | Ohio | 39049 | 77807 | 695 |
854371 | 854371 | 2020-12-22 | Franklin | Ohio | 39049 | 77087 | 695 |
851126 | 851126 | 2020-12-21 | Franklin | Ohio | 39049 | 76188 | 695 |
847881 | 847881 | 2020-12-20 | Franklin | Ohio | 39049 | 75316 | 693 |
844636 | 844636 | 2020-12-19 | Franklin | Ohio | 39049 | 74477 | 693 |
841390 | 841390 | 2020-12-18 | Franklin | Ohio | 39049 | 73651 | 693 |
838145 | 838145 | 2020-12-17 | Franklin | Ohio | 39049 | 72583 | 693 |
834899 | 834899 | 2020-12-16 | Franklin | Ohio | 39049 | 71538 | 693 |
831653 | 831653 | 2020-12-15 | Franklin | Ohio | 39049 | 70879 | 693 |
828406 | 828406 | 2020-12-14 | Franklin | Ohio | 39049 | 69961 | 693 |
825160 | 825160 | 2020-12-13 | Franklin | Ohio | 39049 | 69074 | 693 |
821913 | 821913 | 2020-12-12 | Franklin | Ohio | 39049 | 68157 | 692 |
818667 | 818667 | 2020-12-11 | Franklin | Ohio | 39049 | 67043 | 691 |
815421 | 815421 | 2020-12-10 | Franklin | Ohio | 39049 | 66184 | 690 |
812175 | 812175 | 2020-12-09 | Franklin | Ohio | 39049 | 65094 | 682 |
808931 | 808931 | 2020-12-08 | Franklin | Ohio | 39049 | 64130 | 682 |
805686 | 805686 | 2020-12-07 | Franklin | Ohio | 39049 | 60938 | 682 |
802441 | 802441 | 2020-12-06 | Franklin | Ohio | 39049 | 60093 | 680 |
799196 | 799196 | 2020-12-05 | Franklin | Ohio | 39049 | 59137 | 680 |
795951 | 795951 | 2020-12-04 | Franklin | Ohio | 39049 | 58099 | 678 |
792706 | 792706 | 2020-12-03 | Franklin | Ohio | 39049 | 57040 | 674 |
789461 | 789461 | 2020-12-02 | Franklin | Ohio | 39049 | 56123 | 674 |
786216 | 786216 | 2020-12-01 | Franklin | Ohio | 39049 | 55382 | 672 |
782972 | 782972 | 2020-11-30 | Franklin | Ohio | 39049 | 54467 | 672 |
779726 | 779726 | 2020-11-29 | Franklin | Ohio | 39049 | 53887 | 672 |
776481 | 776481 | 2020-11-28 | Franklin | Ohio | 39049 | 53293 | 672 |
773236 | 773236 | 2020-11-27 | Franklin | Ohio | 39049 | 52652 | 672 |
769991 | 769991 | 2020-11-26 | Franklin | Ohio | 39049 | 51161 | 671 |
766745 | 766745 | 2020-11-25 | Franklin | Ohio | 39049 | 51161 | 671 |
763500 | 763500 | 2020-11-24 | Franklin | Ohio | 39049 | 50231 | 667 |
760255 | 760255 | 2020-11-23 | Franklin | Ohio | 39049 | 49267 | 665 |
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);