ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Geauga" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536503 | 536503 | 2020-09-15 | Geauga | Ohio | 39055 | 691 | 47 |
533267 | 533267 | 2020-09-14 | Geauga | Ohio | 39055 | 687 | 46 |
530032 | 530032 | 2020-09-13 | Geauga | Ohio | 39055 | 689 | 46 |
526795 | 526795 | 2020-09-12 | Geauga | Ohio | 39055 | 680 | 46 |
523559 | 523559 | 2020-09-11 | Geauga | Ohio | 39055 | 674 | 46 |
520323 | 520323 | 2020-09-10 | Geauga | Ohio | 39055 | 671 | 46 |
517087 | 517087 | 2020-09-09 | Geauga | Ohio | 39055 | 667 | 46 |
513852 | 513852 | 2020-09-08 | Geauga | Ohio | 39055 | 663 | 46 |
510619 | 510619 | 2020-09-07 | Geauga | Ohio | 39055 | 663 | 46 |
507386 | 507386 | 2020-09-06 | Geauga | Ohio | 39055 | 658 | 46 |
504154 | 504154 | 2020-09-05 | Geauga | Ohio | 39055 | 660 | 46 |
500920 | 500920 | 2020-09-04 | Geauga | Ohio | 39055 | 642 | 46 |
497686 | 497686 | 2020-09-03 | Geauga | Ohio | 39055 | 634 | 46 |
494453 | 494453 | 2020-09-02 | Geauga | Ohio | 39055 | 627 | 46 |
491219 | 491219 | 2020-09-01 | Geauga | Ohio | 39055 | 623 | 46 |
487986 | 487986 | 2020-08-31 | Geauga | Ohio | 39055 | 616 | 46 |
484753 | 484753 | 2020-08-30 | Geauga | Ohio | 39055 | 608 | 46 |
481518 | 481518 | 2020-08-29 | Geauga | Ohio | 39055 | 611 | 46 |
478284 | 478284 | 2020-08-28 | Geauga | Ohio | 39055 | 608 | 46 |
475051 | 475051 | 2020-08-27 | Geauga | Ohio | 39055 | 605 | 46 |
471817 | 471817 | 2020-08-26 | Geauga | Ohio | 39055 | 598 | 46 |
468585 | 468585 | 2020-08-25 | Geauga | Ohio | 39055 | 595 | 46 |
465357 | 465357 | 2020-08-24 | Geauga | Ohio | 39055 | 595 | 46 |
462128 | 462128 | 2020-08-23 | Geauga | Ohio | 39055 | 594 | 46 |
458900 | 458900 | 2020-08-22 | Geauga | Ohio | 39055 | 592 | 46 |
455672 | 455672 | 2020-08-21 | Geauga | Ohio | 39055 | 588 | 46 |
452444 | 452444 | 2020-08-20 | Geauga | Ohio | 39055 | 586 | 46 |
449216 | 449216 | 2020-08-19 | Geauga | Ohio | 39055 | 583 | 46 |
445988 | 445988 | 2020-08-18 | Geauga | Ohio | 39055 | 579 | 46 |
442762 | 442762 | 2020-08-17 | Geauga | Ohio | 39055 | 574 | 46 |
439535 | 439535 | 2020-08-16 | Geauga | Ohio | 39055 | 570 | 45 |
436310 | 436310 | 2020-08-15 | Geauga | Ohio | 39055 | 565 | 45 |
433084 | 433084 | 2020-08-14 | Geauga | Ohio | 39055 | 564 | 45 |
429858 | 429858 | 2020-08-13 | Geauga | Ohio | 39055 | 565 | 45 |
426633 | 426633 | 2020-08-12 | Geauga | Ohio | 39055 | 561 | 44 |
423410 | 423410 | 2020-08-11 | Geauga | Ohio | 39055 | 559 | 44 |
420187 | 420187 | 2020-08-10 | Geauga | Ohio | 39055 | 558 | 44 |
416967 | 416967 | 2020-08-09 | Geauga | Ohio | 39055 | 556 | 44 |
413746 | 413746 | 2020-08-08 | Geauga | Ohio | 39055 | 554 | 44 |
410526 | 410526 | 2020-08-07 | Geauga | Ohio | 39055 | 552 | 44 |
407306 | 407306 | 2020-08-06 | Geauga | Ohio | 39055 | 548 | 44 |
404087 | 404087 | 2020-08-05 | Geauga | Ohio | 39055 | 540 | 44 |
400869 | 400869 | 2020-08-04 | Geauga | Ohio | 39055 | 535 | 44 |
397654 | 397654 | 2020-08-03 | Geauga | Ohio | 39055 | 531 | 43 |
394437 | 394437 | 2020-08-02 | Geauga | Ohio | 39055 | 528 | 43 |
391221 | 391221 | 2020-08-01 | Geauga | Ohio | 39055 | 522 | 43 |
388004 | 388004 | 2020-07-31 | Geauga | Ohio | 39055 | 519 | 43 |
384787 | 384787 | 2020-07-30 | Geauga | Ohio | 39055 | 515 | 43 |
381569 | 381569 | 2020-07-29 | Geauga | Ohio | 39055 | 513 | 43 |
378352 | 378352 | 2020-07-28 | Geauga | Ohio | 39055 | 509 | 43 |
375135 | 375135 | 2020-07-27 | Geauga | Ohio | 39055 | 506 | 43 |
371923 | 371923 | 2020-07-26 | Geauga | Ohio | 39055 | 502 | 43 |
368711 | 368711 | 2020-07-25 | Geauga | Ohio | 39055 | 498 | 43 |
365502 | 365502 | 2020-07-24 | Geauga | Ohio | 39055 | 493 | 43 |
362296 | 362296 | 2020-07-23 | Geauga | Ohio | 39055 | 482 | 43 |
359090 | 359090 | 2020-07-22 | Geauga | Ohio | 39055 | 474 | 43 |
355886 | 355886 | 2020-07-21 | Geauga | Ohio | 39055 | 468 | 43 |
352683 | 352683 | 2020-07-20 | Geauga | Ohio | 39055 | 466 | 43 |
349480 | 349480 | 2020-07-19 | Geauga | Ohio | 39055 | 465 | 43 |
346279 | 346279 | 2020-07-18 | Geauga | Ohio | 39055 | 458 | 42 |
343080 | 343080 | 2020-07-17 | Geauga | Ohio | 39055 | 453 | 42 |
339882 | 339882 | 2020-07-16 | Geauga | Ohio | 39055 | 448 | 42 |
336686 | 336686 | 2020-07-15 | Geauga | Ohio | 39055 | 447 | 42 |
333492 | 333492 | 2020-07-14 | Geauga | Ohio | 39055 | 436 | 43 |
330300 | 330300 | 2020-07-13 | Geauga | Ohio | 39055 | 431 | 43 |
327113 | 327113 | 2020-07-12 | Geauga | Ohio | 39055 | 428 | 43 |
323928 | 323928 | 2020-07-11 | Geauga | Ohio | 39055 | 425 | 43 |
320748 | 320748 | 2020-07-10 | Geauga | Ohio | 39055 | 425 | 43 |
317571 | 317571 | 2020-07-09 | Geauga | Ohio | 39055 | 415 | 43 |
314398 | 314398 | 2020-07-08 | Geauga | Ohio | 39055 | 414 | 43 |
311226 | 311226 | 2020-07-07 | Geauga | Ohio | 39055 | 408 | 43 |
308057 | 308057 | 2020-07-06 | Geauga | Ohio | 39055 | 407 | 42 |
304890 | 304890 | 2020-07-05 | Geauga | Ohio | 39055 | 405 | 42 |
301727 | 301727 | 2020-07-04 | Geauga | Ohio | 39055 | 400 | 42 |
298564 | 298564 | 2020-07-03 | Geauga | Ohio | 39055 | 399 | 42 |
295404 | 295404 | 2020-07-02 | Geauga | Ohio | 39055 | 390 | 42 |
292249 | 292249 | 2020-07-01 | Geauga | Ohio | 39055 | 390 | 42 |
289097 | 289097 | 2020-06-30 | Geauga | Ohio | 39055 | 387 | 42 |
285947 | 285947 | 2020-06-29 | Geauga | Ohio | 39055 | 383 | 41 |
282802 | 282802 | 2020-06-28 | Geauga | Ohio | 39055 | 382 | 41 |
279656 | 279656 | 2020-06-27 | Geauga | Ohio | 39055 | 379 | 41 |
276508 | 276508 | 2020-06-26 | Geauga | Ohio | 39055 | 378 | 41 |
273361 | 273361 | 2020-06-25 | Geauga | Ohio | 39055 | 372 | 41 |
270222 | 270222 | 2020-06-24 | Geauga | Ohio | 39055 | 369 | 40 |
267088 | 267088 | 2020-06-23 | Geauga | Ohio | 39055 | 363 | 37 |
263960 | 263960 | 2020-06-22 | Geauga | Ohio | 39055 | 361 | 37 |
260832 | 260832 | 2020-06-21 | Geauga | Ohio | 39055 | 357 | 37 |
257705 | 257705 | 2020-06-20 | Geauga | Ohio | 39055 | 355 | 37 |
254580 | 254580 | 2020-06-19 | Geauga | Ohio | 39055 | 353 | 37 |
251465 | 251465 | 2020-06-18 | Geauga | Ohio | 39055 | 349 | 37 |
248350 | 248350 | 2020-06-17 | Geauga | Ohio | 39055 | 344 | 37 |
245237 | 245237 | 2020-06-16 | Geauga | Ohio | 39055 | 342 | 36 |
242125 | 242125 | 2020-06-15 | Geauga | Ohio | 39055 | 337 | 35 |
239016 | 239016 | 2020-06-14 | Geauga | Ohio | 39055 | 334 | 35 |
235908 | 235908 | 2020-06-13 | Geauga | Ohio | 39055 | 331 | 35 |
232803 | 232803 | 2020-06-12 | Geauga | Ohio | 39055 | 331 | 35 |
229698 | 229698 | 2020-06-11 | Geauga | Ohio | 39055 | 331 | 35 |
226594 | 226594 | 2020-06-10 | Geauga | Ohio | 39055 | 327 | 35 |
223494 | 223494 | 2020-06-09 | Geauga | Ohio | 39055 | 317 | 34 |
220399 | 220399 | 2020-06-08 | Geauga | Ohio | 39055 | 313 | 34 |
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);