ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 39085 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536518 | 536518 | 2020-09-15 | Lake | Ohio | 39085 | 1530 | 46 |
533282 | 533282 | 2020-09-14 | Lake | Ohio | 39085 | 1516 | 46 |
530047 | 530047 | 2020-09-13 | Lake | Ohio | 39085 | 1507 | 45 |
526810 | 526810 | 2020-09-12 | Lake | Ohio | 39085 | 1502 | 45 |
523574 | 523574 | 2020-09-11 | Lake | Ohio | 39085 | 1463 | 45 |
520338 | 520338 | 2020-09-10 | Lake | Ohio | 39085 | 1459 | 45 |
517102 | 517102 | 2020-09-09 | Lake | Ohio | 39085 | 1444 | 45 |
513867 | 513867 | 2020-09-08 | Lake | Ohio | 39085 | 1438 | 45 |
510634 | 510634 | 2020-09-07 | Lake | Ohio | 39085 | 1437 | 45 |
507401 | 507401 | 2020-09-06 | Lake | Ohio | 39085 | 1418 | 45 |
504169 | 504169 | 2020-09-05 | Lake | Ohio | 39085 | 1412 | 45 |
500935 | 500935 | 2020-09-04 | Lake | Ohio | 39085 | 1373 | 45 |
497701 | 497701 | 2020-09-03 | Lake | Ohio | 39085 | 1362 | 44 |
494468 | 494468 | 2020-09-02 | Lake | Ohio | 39085 | 1339 | 44 |
491234 | 491234 | 2020-09-01 | Lake | Ohio | 39085 | 1328 | 44 |
488001 | 488001 | 2020-08-31 | Lake | Ohio | 39085 | 1320 | 44 |
484768 | 484768 | 2020-08-30 | Lake | Ohio | 39085 | 1310 | 44 |
481533 | 481533 | 2020-08-29 | Lake | Ohio | 39085 | 1303 | 44 |
478299 | 478299 | 2020-08-28 | Lake | Ohio | 39085 | 1296 | 44 |
475066 | 475066 | 2020-08-27 | Lake | Ohio | 39085 | 1285 | 44 |
471832 | 471832 | 2020-08-26 | Lake | Ohio | 39085 | 1267 | 44 |
468600 | 468600 | 2020-08-25 | Lake | Ohio | 39085 | 1262 | 44 |
465372 | 465372 | 2020-08-24 | Lake | Ohio | 39085 | 1254 | 44 |
462143 | 462143 | 2020-08-23 | Lake | Ohio | 39085 | 1244 | 44 |
458915 | 458915 | 2020-08-22 | Lake | Ohio | 39085 | 1233 | 44 |
455687 | 455687 | 2020-08-21 | Lake | Ohio | 39085 | 1225 | 44 |
452459 | 452459 | 2020-08-20 | Lake | Ohio | 39085 | 1216 | 45 |
449231 | 449231 | 2020-08-19 | Lake | Ohio | 39085 | 1205 | 45 |
446003 | 446003 | 2020-08-18 | Lake | Ohio | 39085 | 1199 | 43 |
442777 | 442777 | 2020-08-17 | Lake | Ohio | 39085 | 1187 | 43 |
439550 | 439550 | 2020-08-16 | Lake | Ohio | 39085 | 1176 | 43 |
436325 | 436325 | 2020-08-15 | Lake | Ohio | 39085 | 1170 | 43 |
433099 | 433099 | 2020-08-14 | Lake | Ohio | 39085 | 1163 | 43 |
429873 | 429873 | 2020-08-13 | Lake | Ohio | 39085 | 1154 | 43 |
426648 | 426648 | 2020-08-12 | Lake | Ohio | 39085 | 1146 | 42 |
423425 | 423425 | 2020-08-11 | Lake | Ohio | 39085 | 1131 | 41 |
420202 | 420202 | 2020-08-10 | Lake | Ohio | 39085 | 1124 | 38 |
416982 | 416982 | 2020-08-09 | Lake | Ohio | 39085 | 1114 | 38 |
413761 | 413761 | 2020-08-08 | Lake | Ohio | 39085 | 1111 | 38 |
410541 | 410541 | 2020-08-07 | Lake | Ohio | 39085 | 1087 | 38 |
407321 | 407321 | 2020-08-06 | Lake | Ohio | 39085 | 1073 | 38 |
404102 | 404102 | 2020-08-05 | Lake | Ohio | 39085 | 1064 | 37 |
400884 | 400884 | 2020-08-04 | Lake | Ohio | 39085 | 1054 | 36 |
397669 | 397669 | 2020-08-03 | Lake | Ohio | 39085 | 1043 | 36 |
394452 | 394452 | 2020-08-02 | Lake | Ohio | 39085 | 1034 | 35 |
391236 | 391236 | 2020-08-01 | Lake | Ohio | 39085 | 1024 | 34 |
388019 | 388019 | 2020-07-31 | Lake | Ohio | 39085 | 1008 | 34 |
384802 | 384802 | 2020-07-30 | Lake | Ohio | 39085 | 983 | 33 |
381584 | 381584 | 2020-07-29 | Lake | Ohio | 39085 | 971 | 31 |
378367 | 378367 | 2020-07-28 | Lake | Ohio | 39085 | 957 | 29 |
375150 | 375150 | 2020-07-27 | Lake | Ohio | 39085 | 929 | 28 |
371938 | 371938 | 2020-07-26 | Lake | Ohio | 39085 | 914 | 27 |
368726 | 368726 | 2020-07-25 | Lake | Ohio | 39085 | 900 | 27 |
365517 | 365517 | 2020-07-24 | Lake | Ohio | 39085 | 878 | 27 |
362311 | 362311 | 2020-07-23 | Lake | Ohio | 39085 | 851 | 26 |
359105 | 359105 | 2020-07-22 | Lake | Ohio | 39085 | 837 | 25 |
355901 | 355901 | 2020-07-21 | Lake | Ohio | 39085 | 823 | 25 |
352698 | 352698 | 2020-07-20 | Lake | Ohio | 39085 | 812 | 24 |
349495 | 349495 | 2020-07-19 | Lake | Ohio | 39085 | 789 | 24 |
346294 | 346294 | 2020-07-18 | Lake | Ohio | 39085 | 762 | 23 |
343095 | 343095 | 2020-07-17 | Lake | Ohio | 39085 | 706 | 23 |
339897 | 339897 | 2020-07-16 | Lake | Ohio | 39085 | 679 | 23 |
336701 | 336701 | 2020-07-15 | Lake | Ohio | 39085 | 661 | 22 |
333507 | 333507 | 2020-07-14 | Lake | Ohio | 39085 | 643 | 22 |
330315 | 330315 | 2020-07-13 | Lake | Ohio | 39085 | 627 | 23 |
327128 | 327128 | 2020-07-12 | Lake | Ohio | 39085 | 609 | 23 |
323943 | 323943 | 2020-07-11 | Lake | Ohio | 39085 | 589 | 23 |
320763 | 320763 | 2020-07-10 | Lake | Ohio | 39085 | 570 | 22 |
317586 | 317586 | 2020-07-09 | Lake | Ohio | 39085 | 551 | 22 |
314413 | 314413 | 2020-07-08 | Lake | Ohio | 39085 | 529 | 20 |
311241 | 311241 | 2020-07-07 | Lake | Ohio | 39085 | 508 | 19 |
308072 | 308072 | 2020-07-06 | Lake | Ohio | 39085 | 500 | 18 |
304905 | 304905 | 2020-07-05 | Lake | Ohio | 39085 | 497 | 18 |
301742 | 301742 | 2020-07-04 | Lake | Ohio | 39085 | 492 | 18 |
298579 | 298579 | 2020-07-03 | Lake | Ohio | 39085 | 480 | 18 |
295419 | 295419 | 2020-07-02 | Lake | Ohio | 39085 | 443 | 16 |
292264 | 292264 | 2020-07-01 | Lake | Ohio | 39085 | 443 | 16 |
289112 | 289112 | 2020-06-30 | Lake | Ohio | 39085 | 433 | 17 |
285962 | 285962 | 2020-06-29 | Lake | Ohio | 39085 | 422 | 17 |
282817 | 282817 | 2020-06-28 | Lake | Ohio | 39085 | 415 | 17 |
279671 | 279671 | 2020-06-27 | Lake | Ohio | 39085 | 405 | 17 |
276523 | 276523 | 2020-06-26 | Lake | Ohio | 39085 | 393 | 17 |
273376 | 273376 | 2020-06-25 | Lake | Ohio | 39085 | 390 | 17 |
270237 | 270237 | 2020-06-24 | Lake | Ohio | 39085 | 381 | 14 |
267103 | 267103 | 2020-06-23 | Lake | Ohio | 39085 | 373 | 15 |
263975 | 263975 | 2020-06-22 | Lake | Ohio | 39085 | 369 | 14 |
260847 | 260847 | 2020-06-21 | Lake | Ohio | 39085 | 367 | 14 |
257720 | 257720 | 2020-06-20 | Lake | Ohio | 39085 | 364 | 14 |
254595 | 254595 | 2020-06-19 | Lake | Ohio | 39085 | 358 | 13 |
251480 | 251480 | 2020-06-18 | Lake | Ohio | 39085 | 356 | 13 |
248365 | 248365 | 2020-06-17 | Lake | Ohio | 39085 | 354 | 12 |
245252 | 245252 | 2020-06-16 | Lake | Ohio | 39085 | 350 | 12 |
242140 | 242140 | 2020-06-15 | Lake | Ohio | 39085 | 348 | 12 |
239031 | 239031 | 2020-06-14 | Lake | Ohio | 39085 | 347 | 12 |
235923 | 235923 | 2020-06-13 | Lake | Ohio | 39085 | 346 | 12 |
232818 | 232818 | 2020-06-12 | Lake | Ohio | 39085 | 344 | 12 |
229713 | 229713 | 2020-06-11 | Lake | Ohio | 39085 | 338 | 12 |
226609 | 226609 | 2020-06-10 | Lake | Ohio | 39085 | 337 | 12 |
223509 | 223509 | 2020-06-09 | Lake | Ohio | 39085 | 337 | 12 |
220414 | 220414 | 2020-06-08 | Lake | Ohio | 39085 | 334 | 12 |
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);