ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Trumbull" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536553 | 536553 | 2020-09-15 | Trumbull | Ohio | 39155 | 1823 | 129 |
533317 | 533317 | 2020-09-14 | Trumbull | Ohio | 39155 | 1817 | 127 |
530082 | 530082 | 2020-09-13 | Trumbull | Ohio | 39155 | 1813 | 127 |
526845 | 526845 | 2020-09-12 | Trumbull | Ohio | 39155 | 1806 | 127 |
523609 | 523609 | 2020-09-11 | Trumbull | Ohio | 39155 | 1800 | 126 |
520373 | 520373 | 2020-09-10 | Trumbull | Ohio | 39155 | 1796 | 126 |
517137 | 517137 | 2020-09-09 | Trumbull | Ohio | 39155 | 1785 | 126 |
513902 | 513902 | 2020-09-08 | Trumbull | Ohio | 39155 | 1780 | 126 |
510669 | 510669 | 2020-09-07 | Trumbull | Ohio | 39155 | 1779 | 126 |
507436 | 507436 | 2020-09-06 | Trumbull | Ohio | 39155 | 1778 | 125 |
504204 | 504204 | 2020-09-05 | Trumbull | Ohio | 39155 | 1777 | 125 |
500970 | 500970 | 2020-09-04 | Trumbull | Ohio | 39155 | 1772 | 125 |
497736 | 497736 | 2020-09-03 | Trumbull | Ohio | 39155 | 1768 | 125 |
494503 | 494503 | 2020-09-02 | Trumbull | Ohio | 39155 | 1758 | 123 |
491269 | 491269 | 2020-09-01 | Trumbull | Ohio | 39155 | 1751 | 123 |
488036 | 488036 | 2020-08-31 | Trumbull | Ohio | 39155 | 1749 | 121 |
484803 | 484803 | 2020-08-30 | Trumbull | Ohio | 39155 | 1744 | 121 |
481568 | 481568 | 2020-08-29 | Trumbull | Ohio | 39155 | 1743 | 121 |
478334 | 478334 | 2020-08-28 | Trumbull | Ohio | 39155 | 1740 | 121 |
475101 | 475101 | 2020-08-27 | Trumbull | Ohio | 39155 | 1735 | 117 |
471867 | 471867 | 2020-08-26 | Trumbull | Ohio | 39155 | 1725 | 117 |
468635 | 468635 | 2020-08-25 | Trumbull | Ohio | 39155 | 1715 | 116 |
465407 | 465407 | 2020-08-24 | Trumbull | Ohio | 39155 | 1710 | 115 |
462178 | 462178 | 2020-08-23 | Trumbull | Ohio | 39155 | 1699 | 114 |
458950 | 458950 | 2020-08-22 | Trumbull | Ohio | 39155 | 1695 | 114 |
455722 | 455722 | 2020-08-21 | Trumbull | Ohio | 39155 | 1684 | 114 |
452494 | 452494 | 2020-08-20 | Trumbull | Ohio | 39155 | 1675 | 114 |
449266 | 449266 | 2020-08-19 | Trumbull | Ohio | 39155 | 1662 | 113 |
446038 | 446038 | 2020-08-18 | Trumbull | Ohio | 39155 | 1642 | 113 |
442812 | 442812 | 2020-08-17 | Trumbull | Ohio | 39155 | 1637 | 112 |
439585 | 439585 | 2020-08-16 | Trumbull | Ohio | 39155 | 1629 | 112 |
436360 | 436360 | 2020-08-15 | Trumbull | Ohio | 39155 | 1604 | 112 |
433134 | 433134 | 2020-08-14 | Trumbull | Ohio | 39155 | 1598 | 112 |
429908 | 429908 | 2020-08-13 | Trumbull | Ohio | 39155 | 1578 | 111 |
426683 | 426683 | 2020-08-12 | Trumbull | Ohio | 39155 | 1563 | 110 |
423460 | 423460 | 2020-08-11 | Trumbull | Ohio | 39155 | 1549 | 108 |
420237 | 420237 | 2020-08-10 | Trumbull | Ohio | 39155 | 1534 | 107 |
417017 | 417017 | 2020-08-09 | Trumbull | Ohio | 39155 | 1524 | 106 |
413796 | 413796 | 2020-08-08 | Trumbull | Ohio | 39155 | 1518 | 106 |
410576 | 410576 | 2020-08-07 | Trumbull | Ohio | 39155 | 1500 | 106 |
407356 | 407356 | 2020-08-06 | Trumbull | Ohio | 39155 | 1481 | 105 |
404137 | 404137 | 2020-08-05 | Trumbull | Ohio | 39155 | 1465 | 105 |
400919 | 400919 | 2020-08-04 | Trumbull | Ohio | 39155 | 1451 | 105 |
397704 | 397704 | 2020-08-03 | Trumbull | Ohio | 39155 | 1433 | 103 |
394487 | 394487 | 2020-08-02 | Trumbull | Ohio | 39155 | 1421 | 103 |
391271 | 391271 | 2020-08-01 | Trumbull | Ohio | 39155 | 1408 | 102 |
388054 | 388054 | 2020-07-31 | Trumbull | Ohio | 39155 | 1393 | 100 |
384837 | 384837 | 2020-07-30 | Trumbull | Ohio | 39155 | 1374 | 98 |
381619 | 381619 | 2020-07-29 | Trumbull | Ohio | 39155 | 1347 | 97 |
378402 | 378402 | 2020-07-28 | Trumbull | Ohio | 39155 | 1324 | 96 |
375185 | 375185 | 2020-07-27 | Trumbull | Ohio | 39155 | 1312 | 96 |
371973 | 371973 | 2020-07-26 | Trumbull | Ohio | 39155 | 1300 | 95 |
368761 | 368761 | 2020-07-25 | Trumbull | Ohio | 39155 | 1286 | 94 |
365552 | 365552 | 2020-07-24 | Trumbull | Ohio | 39155 | 1262 | 94 |
362346 | 362346 | 2020-07-23 | Trumbull | Ohio | 39155 | 1242 | 91 |
359140 | 359140 | 2020-07-22 | Trumbull | Ohio | 39155 | 1210 | 85 |
355936 | 355936 | 2020-07-21 | Trumbull | Ohio | 39155 | 1179 | 84 |
352733 | 352733 | 2020-07-20 | Trumbull | Ohio | 39155 | 1171 | 84 |
349530 | 349530 | 2020-07-19 | Trumbull | Ohio | 39155 | 1159 | 83 |
346329 | 346329 | 2020-07-18 | Trumbull | Ohio | 39155 | 1139 | 82 |
343130 | 343130 | 2020-07-17 | Trumbull | Ohio | 39155 | 1117 | 81 |
339932 | 339932 | 2020-07-16 | Trumbull | Ohio | 39155 | 1094 | 80 |
336736 | 336736 | 2020-07-15 | Trumbull | Ohio | 39155 | 1084 | 79 |
333542 | 333542 | 2020-07-14 | Trumbull | Ohio | 39155 | 1071 | 78 |
330350 | 330350 | 2020-07-13 | Trumbull | Ohio | 39155 | 1066 | 78 |
327163 | 327163 | 2020-07-12 | Trumbull | Ohio | 39155 | 1053 | 78 |
323978 | 323978 | 2020-07-11 | Trumbull | Ohio | 39155 | 1045 | 78 |
320798 | 320798 | 2020-07-10 | Trumbull | Ohio | 39155 | 1032 | 77 |
317621 | 317621 | 2020-07-09 | Trumbull | Ohio | 39155 | 1014 | 74 |
314448 | 314448 | 2020-07-08 | Trumbull | Ohio | 39155 | 997 | 74 |
311276 | 311276 | 2020-07-07 | Trumbull | Ohio | 39155 | 974 | 73 |
308107 | 308107 | 2020-07-06 | Trumbull | Ohio | 39155 | 967 | 70 |
304940 | 304940 | 2020-07-05 | Trumbull | Ohio | 39155 | 939 | 65 |
301777 | 301777 | 2020-07-04 | Trumbull | Ohio | 39155 | 925 | 65 |
298614 | 298614 | 2020-07-03 | Trumbull | Ohio | 39155 | 916 | 65 |
295454 | 295454 | 2020-07-02 | Trumbull | Ohio | 39155 | 863 | 62 |
292299 | 292299 | 2020-07-01 | Trumbull | Ohio | 39155 | 863 | 62 |
289147 | 289147 | 2020-06-30 | Trumbull | Ohio | 39155 | 834 | 62 |
285997 | 285997 | 2020-06-29 | Trumbull | Ohio | 39155 | 824 | 61 |
282852 | 282852 | 2020-06-28 | Trumbull | Ohio | 39155 | 809 | 58 |
279706 | 279706 | 2020-06-27 | Trumbull | Ohio | 39155 | 800 | 58 |
276558 | 276558 | 2020-06-26 | Trumbull | Ohio | 39155 | 788 | 57 |
273411 | 273411 | 2020-06-25 | Trumbull | Ohio | 39155 | 771 | 57 |
270272 | 270272 | 2020-06-24 | Trumbull | Ohio | 39155 | 756 | 56 |
267138 | 267138 | 2020-06-23 | Trumbull | Ohio | 39155 | 742 | 56 |
264010 | 264010 | 2020-06-22 | Trumbull | Ohio | 39155 | 726 | 55 |
260882 | 260882 | 2020-06-21 | Trumbull | Ohio | 39155 | 711 | 55 |
257755 | 257755 | 2020-06-20 | Trumbull | Ohio | 39155 | 698 | 55 |
254630 | 254630 | 2020-06-19 | Trumbull | Ohio | 39155 | 693 | 55 |
251515 | 251515 | 2020-06-18 | Trumbull | Ohio | 39155 | 682 | 54 |
248400 | 248400 | 2020-06-17 | Trumbull | Ohio | 39155 | 675 | 54 |
245287 | 245287 | 2020-06-16 | Trumbull | Ohio | 39155 | 665 | 54 |
242175 | 242175 | 2020-06-15 | Trumbull | Ohio | 39155 | 658 | 54 |
239066 | 239066 | 2020-06-14 | Trumbull | Ohio | 39155 | 656 | 54 |
235958 | 235958 | 2020-06-13 | Trumbull | Ohio | 39155 | 652 | 54 |
232853 | 232853 | 2020-06-12 | Trumbull | Ohio | 39155 | 642 | 53 |
229748 | 229748 | 2020-06-11 | Trumbull | Ohio | 39155 | 625 | 53 |
226644 | 226644 | 2020-06-10 | Trumbull | Ohio | 39155 | 620 | 53 |
223544 | 223544 | 2020-06-09 | Trumbull | Ohio | 39155 | 618 | 53 |
220449 | 220449 | 2020-06-08 | Trumbull | Ohio | 39155 | 616 | 53 |
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);