ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 39085 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
273376 | 273376 | 2020-06-25 | Lake | Ohio | 39085 | 390 | 17 |
276523 | 276523 | 2020-06-26 | Lake | Ohio | 39085 | 393 | 17 |
279671 | 279671 | 2020-06-27 | Lake | Ohio | 39085 | 405 | 17 |
282817 | 282817 | 2020-06-28 | Lake | Ohio | 39085 | 415 | 17 |
285962 | 285962 | 2020-06-29 | Lake | Ohio | 39085 | 422 | 17 |
289112 | 289112 | 2020-06-30 | Lake | Ohio | 39085 | 433 | 17 |
292264 | 292264 | 2020-07-01 | Lake | Ohio | 39085 | 443 | 16 |
295419 | 295419 | 2020-07-02 | Lake | Ohio | 39085 | 443 | 16 |
298579 | 298579 | 2020-07-03 | Lake | Ohio | 39085 | 480 | 18 |
301742 | 301742 | 2020-07-04 | Lake | Ohio | 39085 | 492 | 18 |
304905 | 304905 | 2020-07-05 | Lake | Ohio | 39085 | 497 | 18 |
308072 | 308072 | 2020-07-06 | Lake | Ohio | 39085 | 500 | 18 |
311241 | 311241 | 2020-07-07 | Lake | Ohio | 39085 | 508 | 19 |
314413 | 314413 | 2020-07-08 | Lake | Ohio | 39085 | 529 | 20 |
317586 | 317586 | 2020-07-09 | Lake | Ohio | 39085 | 551 | 22 |
320763 | 320763 | 2020-07-10 | Lake | Ohio | 39085 | 570 | 22 |
323943 | 323943 | 2020-07-11 | Lake | Ohio | 39085 | 589 | 23 |
327128 | 327128 | 2020-07-12 | Lake | Ohio | 39085 | 609 | 23 |
330315 | 330315 | 2020-07-13 | Lake | Ohio | 39085 | 627 | 23 |
333507 | 333507 | 2020-07-14 | Lake | Ohio | 39085 | 643 | 22 |
336701 | 336701 | 2020-07-15 | Lake | Ohio | 39085 | 661 | 22 |
339897 | 339897 | 2020-07-16 | Lake | Ohio | 39085 | 679 | 23 |
343095 | 343095 | 2020-07-17 | Lake | Ohio | 39085 | 706 | 23 |
346294 | 346294 | 2020-07-18 | Lake | Ohio | 39085 | 762 | 23 |
349495 | 349495 | 2020-07-19 | Lake | Ohio | 39085 | 789 | 24 |
352698 | 352698 | 2020-07-20 | Lake | Ohio | 39085 | 812 | 24 |
355901 | 355901 | 2020-07-21 | Lake | Ohio | 39085 | 823 | 25 |
359105 | 359105 | 2020-07-22 | Lake | Ohio | 39085 | 837 | 25 |
362311 | 362311 | 2020-07-23 | Lake | Ohio | 39085 | 851 | 26 |
365517 | 365517 | 2020-07-24 | Lake | Ohio | 39085 | 878 | 27 |
368726 | 368726 | 2020-07-25 | Lake | Ohio | 39085 | 900 | 27 |
371938 | 371938 | 2020-07-26 | Lake | Ohio | 39085 | 914 | 27 |
375150 | 375150 | 2020-07-27 | Lake | Ohio | 39085 | 929 | 28 |
378367 | 378367 | 2020-07-28 | Lake | Ohio | 39085 | 957 | 29 |
381584 | 381584 | 2020-07-29 | Lake | Ohio | 39085 | 971 | 31 |
384802 | 384802 | 2020-07-30 | Lake | Ohio | 39085 | 983 | 33 |
388019 | 388019 | 2020-07-31 | Lake | Ohio | 39085 | 1008 | 34 |
391236 | 391236 | 2020-08-01 | Lake | Ohio | 39085 | 1024 | 34 |
394452 | 394452 | 2020-08-02 | Lake | Ohio | 39085 | 1034 | 35 |
397669 | 397669 | 2020-08-03 | Lake | Ohio | 39085 | 1043 | 36 |
400884 | 400884 | 2020-08-04 | Lake | Ohio | 39085 | 1054 | 36 |
404102 | 404102 | 2020-08-05 | Lake | Ohio | 39085 | 1064 | 37 |
407321 | 407321 | 2020-08-06 | Lake | Ohio | 39085 | 1073 | 38 |
410541 | 410541 | 2020-08-07 | Lake | Ohio | 39085 | 1087 | 38 |
413761 | 413761 | 2020-08-08 | Lake | Ohio | 39085 | 1111 | 38 |
416982 | 416982 | 2020-08-09 | Lake | Ohio | 39085 | 1114 | 38 |
420202 | 420202 | 2020-08-10 | Lake | Ohio | 39085 | 1124 | 38 |
423425 | 423425 | 2020-08-11 | Lake | Ohio | 39085 | 1131 | 41 |
426648 | 426648 | 2020-08-12 | Lake | Ohio | 39085 | 1146 | 42 |
429873 | 429873 | 2020-08-13 | Lake | Ohio | 39085 | 1154 | 43 |
433099 | 433099 | 2020-08-14 | Lake | Ohio | 39085 | 1163 | 43 |
436325 | 436325 | 2020-08-15 | Lake | Ohio | 39085 | 1170 | 43 |
439550 | 439550 | 2020-08-16 | Lake | Ohio | 39085 | 1176 | 43 |
442777 | 442777 | 2020-08-17 | Lake | Ohio | 39085 | 1187 | 43 |
446003 | 446003 | 2020-08-18 | Lake | Ohio | 39085 | 1199 | 43 |
449231 | 449231 | 2020-08-19 | Lake | Ohio | 39085 | 1205 | 45 |
452459 | 452459 | 2020-08-20 | Lake | Ohio | 39085 | 1216 | 45 |
455687 | 455687 | 2020-08-21 | Lake | Ohio | 39085 | 1225 | 44 |
458915 | 458915 | 2020-08-22 | Lake | Ohio | 39085 | 1233 | 44 |
462143 | 462143 | 2020-08-23 | Lake | Ohio | 39085 | 1244 | 44 |
465372 | 465372 | 2020-08-24 | Lake | Ohio | 39085 | 1254 | 44 |
468600 | 468600 | 2020-08-25 | Lake | Ohio | 39085 | 1262 | 44 |
471832 | 471832 | 2020-08-26 | Lake | Ohio | 39085 | 1267 | 44 |
475066 | 475066 | 2020-08-27 | Lake | Ohio | 39085 | 1285 | 44 |
478299 | 478299 | 2020-08-28 | Lake | Ohio | 39085 | 1296 | 44 |
481533 | 481533 | 2020-08-29 | Lake | Ohio | 39085 | 1303 | 44 |
484768 | 484768 | 2020-08-30 | Lake | Ohio | 39085 | 1310 | 44 |
488001 | 488001 | 2020-08-31 | Lake | Ohio | 39085 | 1320 | 44 |
491234 | 491234 | 2020-09-01 | Lake | Ohio | 39085 | 1328 | 44 |
494468 | 494468 | 2020-09-02 | Lake | Ohio | 39085 | 1339 | 44 |
497701 | 497701 | 2020-09-03 | Lake | Ohio | 39085 | 1362 | 44 |
500935 | 500935 | 2020-09-04 | Lake | Ohio | 39085 | 1373 | 45 |
504169 | 504169 | 2020-09-05 | Lake | Ohio | 39085 | 1412 | 45 |
507401 | 507401 | 2020-09-06 | Lake | Ohio | 39085 | 1418 | 45 |
510634 | 510634 | 2020-09-07 | Lake | Ohio | 39085 | 1437 | 45 |
513867 | 513867 | 2020-09-08 | Lake | Ohio | 39085 | 1438 | 45 |
517102 | 517102 | 2020-09-09 | Lake | Ohio | 39085 | 1444 | 45 |
520338 | 520338 | 2020-09-10 | Lake | Ohio | 39085 | 1459 | 45 |
523574 | 523574 | 2020-09-11 | Lake | Ohio | 39085 | 1463 | 45 |
526810 | 526810 | 2020-09-12 | Lake | Ohio | 39085 | 1502 | 45 |
530047 | 530047 | 2020-09-13 | Lake | Ohio | 39085 | 1507 | 45 |
533282 | 533282 | 2020-09-14 | Lake | Ohio | 39085 | 1516 | 46 |
536518 | 536518 | 2020-09-15 | Lake | Ohio | 39085 | 1530 | 46 |
539755 | 539755 | 2020-09-16 | Lake | Ohio | 39085 | 1536 | 46 |
542991 | 542991 | 2020-09-17 | Lake | Ohio | 39085 | 1548 | 49 |
546228 | 546228 | 2020-09-18 | Lake | Ohio | 39085 | 1558 | 49 |
549467 | 549467 | 2020-09-19 | Lake | Ohio | 39085 | 1572 | 49 |
552706 | 552706 | 2020-09-20 | Lake | Ohio | 39085 | 1576 | 49 |
555943 | 555943 | 2020-09-21 | Lake | Ohio | 39085 | 1581 | 49 |
559180 | 559180 | 2020-09-22 | Lake | Ohio | 39085 | 1586 | 49 |
562417 | 562417 | 2020-09-23 | Lake | Ohio | 39085 | 1596 | 50 |
565658 | 565658 | 2020-09-24 | Lake | Ohio | 39085 | 1608 | 50 |
568899 | 568899 | 2020-09-25 | Lake | Ohio | 39085 | 1619 | 51 |
572141 | 572141 | 2020-09-26 | Lake | Ohio | 39085 | 1628 | 51 |
575385 | 575385 | 2020-09-27 | Lake | Ohio | 39085 | 1638 | 51 |
578626 | 578626 | 2020-09-28 | Lake | Ohio | 39085 | 1648 | 51 |
581866 | 581866 | 2020-09-29 | Lake | Ohio | 39085 | 1660 | 51 |
585106 | 585106 | 2020-09-30 | Lake | Ohio | 39085 | 1671 | 53 |
588346 | 588346 | 2020-10-01 | Lake | Ohio | 39085 | 1677 | 53 |
591587 | 591587 | 2020-10-02 | Lake | Ohio | 39085 | 1687 | 54 |
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);