ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Lorain" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536522 | 536522 | 2020-09-15 | Lorain | Ohio | 39093 | 2212 | 86 |
533286 | 533286 | 2020-09-14 | Lorain | Ohio | 39093 | 2211 | 85 |
530051 | 530051 | 2020-09-13 | Lorain | Ohio | 39093 | 2200 | 85 |
526814 | 526814 | 2020-09-12 | Lorain | Ohio | 39093 | 2197 | 85 |
523578 | 523578 | 2020-09-11 | Lorain | Ohio | 39093 | 2197 | 85 |
520342 | 520342 | 2020-09-10 | Lorain | Ohio | 39093 | 2190 | 85 |
517106 | 517106 | 2020-09-09 | Lorain | Ohio | 39093 | 2184 | 85 |
513871 | 513871 | 2020-09-08 | Lorain | Ohio | 39093 | 2181 | 85 |
510638 | 510638 | 2020-09-07 | Lorain | Ohio | 39093 | 2173 | 84 |
507405 | 507405 | 2020-09-06 | Lorain | Ohio | 39093 | 2165 | 83 |
504173 | 504173 | 2020-09-05 | Lorain | Ohio | 39093 | 2163 | 83 |
500939 | 500939 | 2020-09-04 | Lorain | Ohio | 39093 | 2140 | 83 |
497705 | 497705 | 2020-09-03 | Lorain | Ohio | 39093 | 2130 | 83 |
494472 | 494472 | 2020-09-02 | Lorain | Ohio | 39093 | 2115 | 81 |
491238 | 491238 | 2020-09-01 | Lorain | Ohio | 39093 | 2111 | 81 |
488005 | 488005 | 2020-08-31 | Lorain | Ohio | 39093 | 2107 | 81 |
484772 | 484772 | 2020-08-30 | Lorain | Ohio | 39093 | 2103 | 81 |
481537 | 481537 | 2020-08-29 | Lorain | Ohio | 39093 | 2090 | 81 |
478303 | 478303 | 2020-08-28 | Lorain | Ohio | 39093 | 2075 | 81 |
475070 | 475070 | 2020-08-27 | Lorain | Ohio | 39093 | 2059 | 81 |
471836 | 471836 | 2020-08-26 | Lorain | Ohio | 39093 | 2045 | 81 |
468604 | 468604 | 2020-08-25 | Lorain | Ohio | 39093 | 2036 | 81 |
465376 | 465376 | 2020-08-24 | Lorain | Ohio | 39093 | 2022 | 81 |
462147 | 462147 | 2020-08-23 | Lorain | Ohio | 39093 | 1998 | 80 |
458919 | 458919 | 2020-08-22 | Lorain | Ohio | 39093 | 1981 | 80 |
455691 | 455691 | 2020-08-21 | Lorain | Ohio | 39093 | 1976 | 80 |
452463 | 452463 | 2020-08-20 | Lorain | Ohio | 39093 | 1965 | 79 |
449235 | 449235 | 2020-08-19 | Lorain | Ohio | 39093 | 1959 | 78 |
446007 | 446007 | 2020-08-18 | Lorain | Ohio | 39093 | 1945 | 77 |
442781 | 442781 | 2020-08-17 | Lorain | Ohio | 39093 | 1937 | 77 |
439554 | 439554 | 2020-08-16 | Lorain | Ohio | 39093 | 1915 | 77 |
436329 | 436329 | 2020-08-15 | Lorain | Ohio | 39093 | 1906 | 77 |
433103 | 433103 | 2020-08-14 | Lorain | Ohio | 39093 | 1884 | 77 |
429877 | 429877 | 2020-08-13 | Lorain | Ohio | 39093 | 1867 | 77 |
426652 | 426652 | 2020-08-12 | Lorain | Ohio | 39093 | 1831 | 77 |
423429 | 423429 | 2020-08-11 | Lorain | Ohio | 39093 | 1813 | 77 |
420206 | 420206 | 2020-08-10 | Lorain | Ohio | 39093 | 1802 | 78 |
416986 | 416986 | 2020-08-09 | Lorain | Ohio | 39093 | 1770 | 78 |
413765 | 413765 | 2020-08-08 | Lorain | Ohio | 39093 | 1736 | 78 |
410545 | 410545 | 2020-08-07 | Lorain | Ohio | 39093 | 1713 | 78 |
407325 | 407325 | 2020-08-06 | Lorain | Ohio | 39093 | 1689 | 77 |
404106 | 404106 | 2020-08-05 | Lorain | Ohio | 39093 | 1665 | 77 |
400888 | 400888 | 2020-08-04 | Lorain | Ohio | 39093 | 1650 | 77 |
397673 | 397673 | 2020-08-03 | Lorain | Ohio | 39093 | 1634 | 76 |
394456 | 394456 | 2020-08-02 | Lorain | Ohio | 39093 | 1620 | 76 |
391240 | 391240 | 2020-08-01 | Lorain | Ohio | 39093 | 1596 | 76 |
388023 | 388023 | 2020-07-31 | Lorain | Ohio | 39093 | 1584 | 76 |
384806 | 384806 | 2020-07-30 | Lorain | Ohio | 39093 | 1563 | 75 |
381588 | 381588 | 2020-07-29 | Lorain | Ohio | 39093 | 1534 | 75 |
378371 | 378371 | 2020-07-28 | Lorain | Ohio | 39093 | 1513 | 75 |
375154 | 375154 | 2020-07-27 | Lorain | Ohio | 39093 | 1484 | 75 |
371942 | 371942 | 2020-07-26 | Lorain | Ohio | 39093 | 1474 | 75 |
368730 | 368730 | 2020-07-25 | Lorain | Ohio | 39093 | 1463 | 75 |
365521 | 365521 | 2020-07-24 | Lorain | Ohio | 39093 | 1423 | 75 |
362315 | 362315 | 2020-07-23 | Lorain | Ohio | 39093 | 1404 | 75 |
359109 | 359109 | 2020-07-22 | Lorain | Ohio | 39093 | 1375 | 75 |
355905 | 355905 | 2020-07-21 | Lorain | Ohio | 39093 | 1351 | 75 |
352702 | 352702 | 2020-07-20 | Lorain | Ohio | 39093 | 1344 | 73 |
349499 | 349499 | 2020-07-19 | Lorain | Ohio | 39093 | 1322 | 73 |
346298 | 346298 | 2020-07-18 | Lorain | Ohio | 39093 | 1305 | 71 |
343099 | 343099 | 2020-07-17 | Lorain | Ohio | 39093 | 1277 | 71 |
339901 | 339901 | 2020-07-16 | Lorain | Ohio | 39093 | 1243 | 71 |
336705 | 336705 | 2020-07-15 | Lorain | Ohio | 39093 | 1226 | 70 |
333511 | 333511 | 2020-07-14 | Lorain | Ohio | 39093 | 1208 | 70 |
330319 | 330319 | 2020-07-13 | Lorain | Ohio | 39093 | 1189 | 70 |
327132 | 327132 | 2020-07-12 | Lorain | Ohio | 39093 | 1152 | 69 |
323947 | 323947 | 2020-07-11 | Lorain | Ohio | 39093 | 1120 | 69 |
320767 | 320767 | 2020-07-10 | Lorain | Ohio | 39093 | 1097 | 69 |
317590 | 317590 | 2020-07-09 | Lorain | Ohio | 39093 | 1073 | 68 |
314417 | 314417 | 2020-07-08 | Lorain | Ohio | 39093 | 1064 | 68 |
311245 | 311245 | 2020-07-07 | Lorain | Ohio | 39093 | 1051 | 67 |
308076 | 308076 | 2020-07-06 | Lorain | Ohio | 39093 | 1035 | 67 |
304909 | 304909 | 2020-07-05 | Lorain | Ohio | 39093 | 1021 | 67 |
301746 | 301746 | 2020-07-04 | Lorain | Ohio | 39093 | 997 | 67 |
298583 | 298583 | 2020-07-03 | Lorain | Ohio | 39093 | 983 | 67 |
295423 | 295423 | 2020-07-02 | Lorain | Ohio | 39093 | 962 | 67 |
292268 | 292268 | 2020-07-01 | Lorain | Ohio | 39093 | 962 | 67 |
289116 | 289116 | 2020-06-30 | Lorain | Ohio | 39093 | 947 | 67 |
285966 | 285966 | 2020-06-29 | Lorain | Ohio | 39093 | 937 | 67 |
282821 | 282821 | 2020-06-28 | Lorain | Ohio | 39093 | 925 | 67 |
279675 | 279675 | 2020-06-27 | Lorain | Ohio | 39093 | 912 | 67 |
276527 | 276527 | 2020-06-26 | Lorain | Ohio | 39093 | 901 | 67 |
273380 | 273380 | 2020-06-25 | Lorain | Ohio | 39093 | 889 | 67 |
270241 | 270241 | 2020-06-24 | Lorain | Ohio | 39093 | 878 | 66 |
267107 | 267107 | 2020-06-23 | Lorain | Ohio | 39093 | 867 | 66 |
263979 | 263979 | 2020-06-22 | Lorain | Ohio | 39093 | 854 | 66 |
260851 | 260851 | 2020-06-21 | Lorain | Ohio | 39093 | 843 | 66 |
257724 | 257724 | 2020-06-20 | Lorain | Ohio | 39093 | 831 | 66 |
254599 | 254599 | 2020-06-19 | Lorain | Ohio | 39093 | 825 | 65 |
251484 | 251484 | 2020-06-18 | Lorain | Ohio | 39093 | 822 | 64 |
248369 | 248369 | 2020-06-17 | Lorain | Ohio | 39093 | 814 | 63 |
245256 | 245256 | 2020-06-16 | Lorain | Ohio | 39093 | 807 | 63 |
242144 | 242144 | 2020-06-15 | Lorain | Ohio | 39093 | 804 | 62 |
239035 | 239035 | 2020-06-14 | Lorain | Ohio | 39093 | 794 | 62 |
235927 | 235927 | 2020-06-13 | Lorain | Ohio | 39093 | 786 | 62 |
232822 | 232822 | 2020-06-12 | Lorain | Ohio | 39093 | 779 | 61 |
229717 | 229717 | 2020-06-11 | Lorain | Ohio | 39093 | 772 | 61 |
226613 | 226613 | 2020-06-10 | Lorain | Ohio | 39093 | 762 | 61 |
223513 | 223513 | 2020-06-09 | Lorain | Ohio | 39093 | 757 | 61 |
220418 | 220418 | 2020-06-08 | Lorain | Ohio | 39093 | 755 | 62 |
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);