ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39041 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1081550 | 1081550 | 2021-03-02 | Delaware | Ohio | 39041 | 16471 | 116 |
1078304 | 1078304 | 2021-03-01 | Delaware | Ohio | 39041 | 16437 | 136 |
1075059 | 1075059 | 2021-02-28 | Delaware | Ohio | 39041 | 16415 | 135 |
1071813 | 1071813 | 2021-02-27 | Delaware | Ohio | 39041 | 16385 | 135 |
1068567 | 1068567 | 2021-02-26 | Delaware | Ohio | 39041 | 16347 | 135 |
1065322 | 1065322 | 2021-02-25 | Delaware | Ohio | 39041 | 16320 | 131 |
1062078 | 1062078 | 2021-02-24 | Delaware | Ohio | 39041 | 16289 | 129 |
1058832 | 1058832 | 2021-02-23 | Delaware | Ohio | 39041 | 16261 | 128 |
1055586 | 1055586 | 2021-02-22 | Delaware | Ohio | 39041 | 16176 | 128 |
1052340 | 1052340 | 2021-02-21 | Delaware | Ohio | 39041 | 16141 | 128 |
1049093 | 1049093 | 2021-02-20 | Delaware | Ohio | 39041 | 16108 | 128 |
1045846 | 1045846 | 2021-02-19 | Delaware | Ohio | 39041 | 16044 | 128 |
1042601 | 1042601 | 2021-02-18 | Delaware | Ohio | 39041 | 15994 | 124 |
1039356 | 1039356 | 2021-02-17 | Delaware | Ohio | 39041 | 15950 | 122 |
1036111 | 1036111 | 2021-02-16 | Delaware | Ohio | 39041 | 15904 | 122 |
1032866 | 1032866 | 2021-02-15 | Delaware | Ohio | 39041 | 15864 | 120 |
1029620 | 1029620 | 2021-02-14 | Delaware | Ohio | 39041 | 15835 | 122 |
1026373 | 1026373 | 2021-02-13 | Delaware | Ohio | 39041 | 15786 | 120 |
1023128 | 1023128 | 2021-02-12 | Delaware | Ohio | 39041 | 15742 | 114 |
1019883 | 1019883 | 2021-02-11 | Delaware | Ohio | 39041 | 15691 | 90 |
1016638 | 1016638 | 2021-02-10 | Delaware | Ohio | 39041 | 15644 | 86 |
1013393 | 1013393 | 2021-02-09 | Delaware | Ohio | 39041 | 15596 | 86 |
1010148 | 1010148 | 2021-02-08 | Delaware | Ohio | 39041 | 15535 | 85 |
1006902 | 1006902 | 2021-02-07 | Delaware | Ohio | 39041 | 15486 | 85 |
1003656 | 1003656 | 2021-02-06 | Delaware | Ohio | 39041 | 15452 | 85 |
1000410 | 1000410 | 2021-02-05 | Delaware | Ohio | 39041 | 15373 | 84 |
997164 | 997164 | 2021-02-04 | Delaware | Ohio | 39041 | 15323 | 84 |
993918 | 993918 | 2021-02-03 | Delaware | Ohio | 39041 | 15254 | 84 |
990672 | 990672 | 2021-02-02 | Delaware | Ohio | 39041 | 15165 | 82 |
987426 | 987426 | 2021-02-01 | Delaware | Ohio | 39041 | 15116 | 82 |
984179 | 984179 | 2021-01-31 | Delaware | Ohio | 39041 | 15061 | 82 |
980932 | 980932 | 2021-01-30 | Delaware | Ohio | 39041 | 15012 | 82 |
977686 | 977686 | 2021-01-29 | Delaware | Ohio | 39041 | 14938 | 81 |
974441 | 974441 | 2021-01-28 | Delaware | Ohio | 39041 | 14848 | 81 |
971196 | 971196 | 2021-01-27 | Delaware | Ohio | 39041 | 14737 | 81 |
967951 | 967951 | 2021-01-26 | Delaware | Ohio | 39041 | 14638 | 81 |
964707 | 964707 | 2021-01-25 | Delaware | Ohio | 39041 | 14536 | 80 |
961462 | 961462 | 2021-01-24 | Delaware | Ohio | 39041 | 14454 | 79 |
958217 | 958217 | 2021-01-23 | Delaware | Ohio | 39041 | 14388 | 78 |
954971 | 954971 | 2021-01-22 | Delaware | Ohio | 39041 | 14305 | 78 |
951726 | 951726 | 2021-01-21 | Delaware | Ohio | 39041 | 14226 | 78 |
948481 | 948481 | 2021-01-20 | Delaware | Ohio | 39041 | 14136 | 77 |
945235 | 945235 | 2021-01-19 | Delaware | Ohio | 39041 | 14030 | 77 |
941988 | 941988 | 2021-01-18 | Delaware | Ohio | 39041 | 13929 | 77 |
938743 | 938743 | 2021-01-17 | Delaware | Ohio | 39041 | 13821 | 77 |
935498 | 935498 | 2021-01-16 | Delaware | Ohio | 39041 | 13742 | 77 |
932253 | 932253 | 2021-01-15 | Delaware | Ohio | 39041 | 13645 | 76 |
929008 | 929008 | 2021-01-14 | Delaware | Ohio | 39041 | 13495 | 74 |
925763 | 925763 | 2021-01-13 | Delaware | Ohio | 39041 | 13366 | 74 |
922517 | 922517 | 2021-01-12 | Delaware | Ohio | 39041 | 13244 | 74 |
919272 | 919272 | 2021-01-11 | Delaware | Ohio | 39041 | 13100 | 73 |
916027 | 916027 | 2021-01-10 | Delaware | Ohio | 39041 | 12994 | 73 |
912782 | 912782 | 2021-01-09 | Delaware | Ohio | 39041 | 12860 | 73 |
909537 | 909537 | 2021-01-08 | Delaware | Ohio | 39041 | 12663 | 71 |
906292 | 906292 | 2021-01-07 | Delaware | Ohio | 39041 | 12429 | 71 |
903046 | 903046 | 2021-01-06 | Delaware | Ohio | 39041 | 12262 | 69 |
899801 | 899801 | 2021-01-05 | Delaware | Ohio | 39041 | 12063 | 67 |
896556 | 896556 | 2021-01-04 | Delaware | Ohio | 39041 | 11912 | 67 |
893310 | 893310 | 2021-01-03 | Delaware | Ohio | 39041 | 11786 | 66 |
890064 | 890064 | 2021-01-02 | Delaware | Ohio | 39041 | 11629 | 66 |
886817 | 886817 | 2021-01-01 | Delaware | Ohio | 39041 | 11362 | 65 |
883572 | 883572 | 2020-12-31 | Delaware | Ohio | 39041 | 11362 | 65 |
880327 | 880327 | 2020-12-30 | Delaware | Ohio | 39041 | 11216 | 63 |
877082 | 877082 | 2020-12-29 | Delaware | Ohio | 39041 | 11090 | 62 |
873837 | 873837 | 2020-12-28 | Delaware | Ohio | 39041 | 10914 | 62 |
870592 | 870592 | 2020-12-27 | Delaware | Ohio | 39041 | 10790 | 62 |
867347 | 867347 | 2020-12-26 | Delaware | Ohio | 39041 | 10655 | 62 |
864102 | 864102 | 2020-12-25 | Delaware | Ohio | 39041 | 10465 | 62 |
860857 | 860857 | 2020-12-24 | Delaware | Ohio | 39041 | 10465 | 62 |
857612 | 857612 | 2020-12-23 | Delaware | Ohio | 39041 | 10326 | 58 |
854367 | 854367 | 2020-12-22 | Delaware | Ohio | 39041 | 10127 | 55 |
851122 | 851122 | 2020-12-21 | Delaware | Ohio | 39041 | 9997 | 55 |
847877 | 847877 | 2020-12-20 | Delaware | Ohio | 39041 | 9869 | 55 |
844632 | 844632 | 2020-12-19 | Delaware | Ohio | 39041 | 9708 | 54 |
841386 | 841386 | 2020-12-18 | Delaware | Ohio | 39041 | 9549 | 54 |
838141 | 838141 | 2020-12-17 | Delaware | Ohio | 39041 | 9366 | 52 |
834895 | 834895 | 2020-12-16 | Delaware | Ohio | 39041 | 9211 | 50 |
831649 | 831649 | 2020-12-15 | Delaware | Ohio | 39041 | 9103 | 50 |
828402 | 828402 | 2020-12-14 | Delaware | Ohio | 39041 | 8956 | 50 |
825156 | 825156 | 2020-12-13 | Delaware | Ohio | 39041 | 8773 | 48 |
821909 | 821909 | 2020-12-12 | Delaware | Ohio | 39041 | 8629 | 48 |
818663 | 818663 | 2020-12-11 | Delaware | Ohio | 39041 | 8434 | 49 |
815417 | 815417 | 2020-12-10 | Delaware | Ohio | 39041 | 8287 | 43 |
812171 | 812171 | 2020-12-09 | Delaware | Ohio | 39041 | 8086 | 43 |
808927 | 808927 | 2020-12-08 | Delaware | Ohio | 39041 | 7944 | 43 |
805682 | 805682 | 2020-12-07 | Delaware | Ohio | 39041 | 7229 | 42 |
802437 | 802437 | 2020-12-06 | Delaware | Ohio | 39041 | 7088 | 42 |
799192 | 799192 | 2020-12-05 | Delaware | Ohio | 39041 | 6972 | 42 |
795947 | 795947 | 2020-12-04 | Delaware | Ohio | 39041 | 6828 | 43 |
792702 | 792702 | 2020-12-03 | Delaware | Ohio | 39041 | 6681 | 42 |
789457 | 789457 | 2020-12-02 | Delaware | Ohio | 39041 | 6519 | 42 |
786212 | 786212 | 2020-12-01 | Delaware | Ohio | 39041 | 6400 | 38 |
782968 | 782968 | 2020-11-30 | Delaware | Ohio | 39041 | 6271 | 37 |
779722 | 779722 | 2020-11-29 | Delaware | Ohio | 39041 | 6159 | 37 |
776477 | 776477 | 2020-11-28 | Delaware | Ohio | 39041 | 6058 | 37 |
773232 | 773232 | 2020-11-27 | Delaware | Ohio | 39041 | 5973 | 37 |
769987 | 769987 | 2020-11-26 | Delaware | Ohio | 39041 | 5725 | 37 |
766741 | 766741 | 2020-11-25 | Delaware | Ohio | 39041 | 5725 | 37 |
763496 | 763496 | 2020-11-24 | Delaware | Ohio | 39041 | 5564 | 36 |
760251 | 760251 | 2020-11-23 | Delaware | Ohio | 39041 | 5403 | 35 |
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);