ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Clark" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1169201 | 1169201 | 2021-03-29 | Clark | Ohio | 39023 | 13048 | 280 |
1165953 | 1165953 | 2021-03-28 | Clark | Ohio | 39023 | 13023 | 280 |
1162705 | 1162705 | 2021-03-27 | Clark | Ohio | 39023 | 12995 | 280 |
1159456 | 1159456 | 2021-03-26 | Clark | Ohio | 39023 | 12961 | 280 |
1156209 | 1156209 | 2021-03-25 | Clark | Ohio | 39023 | 12895 | 279 |
1152962 | 1152962 | 2021-03-24 | Clark | Ohio | 39023 | 12857 | 279 |
1149715 | 1149715 | 2021-03-23 | Clark | Ohio | 39023 | 12828 | 279 |
1146468 | 1146468 | 2021-03-22 | Clark | Ohio | 39023 | 12788 | 279 |
1143221 | 1143221 | 2021-03-21 | Clark | Ohio | 39023 | 12763 | 279 |
1139974 | 1139974 | 2021-03-20 | Clark | Ohio | 39023 | 12736 | 279 |
1136728 | 1136728 | 2021-03-19 | Clark | Ohio | 39023 | 12691 | 279 |
1133482 | 1133482 | 2021-03-18 | Clark | Ohio | 39023 | 12657 | 272 |
1130234 | 1130234 | 2021-03-17 | Clark | Ohio | 39023 | 12622 | 272 |
1126987 | 1126987 | 2021-03-16 | Clark | Ohio | 39023 | 12587 | 272 |
1123741 | 1123741 | 2021-03-15 | Clark | Ohio | 39023 | 12546 | 266 |
1120495 | 1120495 | 2021-03-14 | Clark | Ohio | 39023 | 12532 | 266 |
1117248 | 1117248 | 2021-03-13 | Clark | Ohio | 39023 | 12518 | 266 |
1114001 | 1114001 | 2021-03-12 | Clark | Ohio | 39023 | 12506 | 266 |
1110755 | 1110755 | 2021-03-11 | Clark | Ohio | 39023 | 12465 | 260 |
1107509 | 1107509 | 2021-03-10 | Clark | Ohio | 39023 | 12453 | 260 |
1104263 | 1104263 | 2021-03-09 | Clark | Ohio | 39023 | 12432 | 260 |
1101017 | 1101017 | 2021-03-08 | Clark | Ohio | 39023 | 12411 | 256 |
1097771 | 1097771 | 2021-03-07 | Clark | Ohio | 39023 | 12394 | 256 |
1094523 | 1094523 | 2021-03-06 | Clark | Ohio | 39023 | 12376 | 256 |
1091277 | 1091277 | 2021-03-05 | Clark | Ohio | 39023 | 12352 | 256 |
1088032 | 1088032 | 2021-03-04 | Clark | Ohio | 39023 | 12319 | 248 |
1084787 | 1084787 | 2021-03-03 | Clark | Ohio | 39023 | 12288 | 248 |
1081541 | 1081541 | 2021-03-02 | Clark | Ohio | 39023 | 12268 | 248 |
1078295 | 1078295 | 2021-03-01 | Clark | Ohio | 39023 | 12246 | 336 |
1075050 | 1075050 | 2021-02-28 | Clark | Ohio | 39023 | 12223 | 336 |
1071804 | 1071804 | 2021-02-27 | Clark | Ohio | 39023 | 12210 | 335 |
1068558 | 1068558 | 2021-02-26 | Clark | Ohio | 39023 | 12194 | 335 |
1065313 | 1065313 | 2021-02-25 | Clark | Ohio | 39023 | 12162 | 335 |
1062069 | 1062069 | 2021-02-24 | Clark | Ohio | 39023 | 12139 | 333 |
1058823 | 1058823 | 2021-02-23 | Clark | Ohio | 39023 | 12121 | 332 |
1055577 | 1055577 | 2021-02-22 | Clark | Ohio | 39023 | 12101 | 331 |
1052331 | 1052331 | 2021-02-21 | Clark | Ohio | 39023 | 12082 | 330 |
1049084 | 1049084 | 2021-02-20 | Clark | Ohio | 39023 | 12064 | 329 |
1045837 | 1045837 | 2021-02-19 | Clark | Ohio | 39023 | 12046 | 328 |
1042592 | 1042592 | 2021-02-18 | Clark | Ohio | 39023 | 12018 | 320 |
1039347 | 1039347 | 2021-02-17 | Clark | Ohio | 39023 | 11995 | 317 |
1036102 | 1036102 | 2021-02-16 | Clark | Ohio | 39023 | 11978 | 317 |
1032857 | 1032857 | 2021-02-15 | Clark | Ohio | 39023 | 11957 | 321 |
1029611 | 1029611 | 2021-02-14 | Clark | Ohio | 39023 | 11930 | 320 |
1026364 | 1026364 | 2021-02-13 | Clark | Ohio | 39023 | 11913 | 320 |
1023119 | 1023119 | 2021-02-12 | Clark | Ohio | 39023 | 11881 | 318 |
1019874 | 1019874 | 2021-02-11 | Clark | Ohio | 39023 | 11838 | 303 |
1016629 | 1016629 | 2021-02-10 | Clark | Ohio | 39023 | 11815 | 301 |
1013384 | 1013384 | 2021-02-09 | Clark | Ohio | 39023 | 11778 | 300 |
1010139 | 1010139 | 2021-02-08 | Clark | Ohio | 39023 | 11741 | 299 |
1006893 | 1006893 | 2021-02-07 | Clark | Ohio | 39023 | 11716 | 299 |
1003647 | 1003647 | 2021-02-06 | Clark | Ohio | 39023 | 11685 | 299 |
1000401 | 1000401 | 2021-02-05 | Clark | Ohio | 39023 | 11633 | 295 |
997155 | 997155 | 2021-02-04 | Clark | Ohio | 39023 | 11599 | 295 |
993909 | 993909 | 2021-02-03 | Clark | Ohio | 39023 | 11552 | 295 |
990663 | 990663 | 2021-02-02 | Clark | Ohio | 39023 | 11518 | 293 |
987417 | 987417 | 2021-02-01 | Clark | Ohio | 39023 | 11462 | 289 |
984170 | 984170 | 2021-01-31 | Clark | Ohio | 39023 | 11420 | 288 |
980923 | 980923 | 2021-01-30 | Clark | Ohio | 39023 | 11372 | 288 |
977677 | 977677 | 2021-01-29 | Clark | Ohio | 39023 | 11297 | 288 |
974432 | 974432 | 2021-01-28 | Clark | Ohio | 39023 | 11205 | 281 |
971187 | 971187 | 2021-01-27 | Clark | Ohio | 39023 | 11147 | 266 |
967942 | 967942 | 2021-01-26 | Clark | Ohio | 39023 | 11094 | 266 |
964698 | 964698 | 2021-01-25 | Clark | Ohio | 39023 | 11058 | 265 |
961453 | 961453 | 2021-01-24 | Clark | Ohio | 39023 | 10995 | 265 |
958208 | 958208 | 2021-01-23 | Clark | Ohio | 39023 | 10942 | 265 |
954962 | 954962 | 2021-01-22 | Clark | Ohio | 39023 | 10867 | 265 |
951717 | 951717 | 2021-01-21 | Clark | Ohio | 39023 | 10802 | 265 |
948472 | 948472 | 2021-01-20 | Clark | Ohio | 39023 | 10723 | 264 |
945226 | 945226 | 2021-01-19 | Clark | Ohio | 39023 | 10672 | 264 |
941979 | 941979 | 2021-01-18 | Clark | Ohio | 39023 | 10648 | 264 |
938734 | 938734 | 2021-01-17 | Clark | Ohio | 39023 | 10608 | 264 |
935489 | 935489 | 2021-01-16 | Clark | Ohio | 39023 | 10557 | 264 |
932244 | 932244 | 2021-01-15 | Clark | Ohio | 39023 | 10451 | 263 |
928999 | 928999 | 2021-01-14 | Clark | Ohio | 39023 | 10334 | 261 |
925754 | 925754 | 2021-01-13 | Clark | Ohio | 39023 | 10235 | 260 |
922508 | 922508 | 2021-01-12 | Clark | Ohio | 39023 | 10177 | 260 |
919263 | 919263 | 2021-01-11 | Clark | Ohio | 39023 | 10057 | 251 |
916018 | 916018 | 2021-01-10 | Clark | Ohio | 39023 | 9945 | 248 |
912773 | 912773 | 2021-01-09 | Clark | Ohio | 39023 | 9876 | 247 |
909528 | 909528 | 2021-01-08 | Clark | Ohio | 39023 | 9758 | 247 |
906283 | 906283 | 2021-01-07 | Clark | Ohio | 39023 | 9624 | 244 |
903037 | 903037 | 2021-01-06 | Clark | Ohio | 39023 | 9494 | 240 |
899792 | 899792 | 2021-01-05 | Clark | Ohio | 39023 | 9380 | 207 |
896547 | 896547 | 2021-01-04 | Clark | Ohio | 39023 | 9303 | 189 |
893301 | 893301 | 2021-01-03 | Clark | Ohio | 39023 | 9240 | 186 |
890055 | 890055 | 2021-01-02 | Clark | Ohio | 39023 | 9151 | 186 |
886808 | 886808 | 2021-01-01 | Clark | Ohio | 39023 | 8988 | 186 |
883563 | 883563 | 2020-12-31 | Clark | Ohio | 39023 | 8988 | 186 |
880318 | 880318 | 2020-12-30 | Clark | Ohio | 39023 | 8868 | 186 |
877073 | 877073 | 2020-12-29 | Clark | Ohio | 39023 | 8763 | 184 |
873828 | 873828 | 2020-12-28 | Clark | Ohio | 39023 | 8686 | 179 |
870583 | 870583 | 2020-12-27 | Clark | Ohio | 39023 | 8651 | 179 |
867338 | 867338 | 2020-12-26 | Clark | Ohio | 39023 | 8586 | 179 |
864093 | 864093 | 2020-12-25 | Clark | Ohio | 39023 | 8449 | 179 |
860848 | 860848 | 2020-12-24 | Clark | Ohio | 39023 | 8449 | 179 |
857603 | 857603 | 2020-12-23 | Clark | Ohio | 39023 | 8353 | 179 |
854358 | 854358 | 2020-12-22 | Clark | Ohio | 39023 | 8280 | 173 |
851113 | 851113 | 2020-12-21 | Clark | Ohio | 39023 | 8196 | 173 |
847868 | 847868 | 2020-12-20 | Clark | Ohio | 39023 | 8144 | 172 |
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);