ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Sandusky" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536547 | 536547 | 2020-09-15 | Sandusky | Ohio | 39143 | 547 | 20 |
533311 | 533311 | 2020-09-14 | Sandusky | Ohio | 39143 | 544 | 20 |
530076 | 530076 | 2020-09-13 | Sandusky | Ohio | 39143 | 543 | 20 |
526839 | 526839 | 2020-09-12 | Sandusky | Ohio | 39143 | 544 | 20 |
523603 | 523603 | 2020-09-11 | Sandusky | Ohio | 39143 | 540 | 20 |
520367 | 520367 | 2020-09-10 | Sandusky | Ohio | 39143 | 536 | 19 |
517131 | 517131 | 2020-09-09 | Sandusky | Ohio | 39143 | 535 | 19 |
513896 | 513896 | 2020-09-08 | Sandusky | Ohio | 39143 | 533 | 19 |
510663 | 510663 | 2020-09-07 | Sandusky | Ohio | 39143 | 533 | 19 |
507430 | 507430 | 2020-09-06 | Sandusky | Ohio | 39143 | 533 | 19 |
504198 | 504198 | 2020-09-05 | Sandusky | Ohio | 39143 | 534 | 19 |
500964 | 500964 | 2020-09-04 | Sandusky | Ohio | 39143 | 531 | 19 |
497730 | 497730 | 2020-09-03 | Sandusky | Ohio | 39143 | 528 | 18 |
494497 | 494497 | 2020-09-02 | Sandusky | Ohio | 39143 | 525 | 17 |
491263 | 491263 | 2020-09-01 | Sandusky | Ohio | 39143 | 520 | 17 |
488030 | 488030 | 2020-08-31 | Sandusky | Ohio | 39143 | 518 | 17 |
484797 | 484797 | 2020-08-30 | Sandusky | Ohio | 39143 | 517 | 17 |
481562 | 481562 | 2020-08-29 | Sandusky | Ohio | 39143 | 510 | 17 |
478328 | 478328 | 2020-08-28 | Sandusky | Ohio | 39143 | 505 | 17 |
475095 | 475095 | 2020-08-27 | Sandusky | Ohio | 39143 | 499 | 17 |
471861 | 471861 | 2020-08-26 | Sandusky | Ohio | 39143 | 494 | 17 |
468629 | 468629 | 2020-08-25 | Sandusky | Ohio | 39143 | 483 | 17 |
465401 | 465401 | 2020-08-24 | Sandusky | Ohio | 39143 | 483 | 17 |
462172 | 462172 | 2020-08-23 | Sandusky | Ohio | 39143 | 478 | 17 |
458944 | 458944 | 2020-08-22 | Sandusky | Ohio | 39143 | 477 | 17 |
455716 | 455716 | 2020-08-21 | Sandusky | Ohio | 39143 | 469 | 17 |
452488 | 452488 | 2020-08-20 | Sandusky | Ohio | 39143 | 492 | 17 |
449260 | 449260 | 2020-08-19 | Sandusky | Ohio | 39143 | 480 | 17 |
446032 | 446032 | 2020-08-18 | Sandusky | Ohio | 39143 | 472 | 17 |
442806 | 442806 | 2020-08-17 | Sandusky | Ohio | 39143 | 450 | 17 |
439579 | 439579 | 2020-08-16 | Sandusky | Ohio | 39143 | 442 | 17 |
436354 | 436354 | 2020-08-15 | Sandusky | Ohio | 39143 | 435 | 17 |
433128 | 433128 | 2020-08-14 | Sandusky | Ohio | 39143 | 421 | 17 |
429902 | 429902 | 2020-08-13 | Sandusky | Ohio | 39143 | 407 | 17 |
426677 | 426677 | 2020-08-12 | Sandusky | Ohio | 39143 | 399 | 17 |
423454 | 423454 | 2020-08-11 | Sandusky | Ohio | 39143 | 390 | 17 |
420231 | 420231 | 2020-08-10 | Sandusky | Ohio | 39143 | 384 | 17 |
417011 | 417011 | 2020-08-09 | Sandusky | Ohio | 39143 | 377 | 16 |
413790 | 413790 | 2020-08-08 | Sandusky | Ohio | 39143 | 373 | 16 |
410570 | 410570 | 2020-08-07 | Sandusky | Ohio | 39143 | 368 | 16 |
407350 | 407350 | 2020-08-06 | Sandusky | Ohio | 39143 | 363 | 16 |
404131 | 404131 | 2020-08-05 | Sandusky | Ohio | 39143 | 354 | 16 |
400913 | 400913 | 2020-08-04 | Sandusky | Ohio | 39143 | 343 | 17 |
397698 | 397698 | 2020-08-03 | Sandusky | Ohio | 39143 | 332 | 17 |
394481 | 394481 | 2020-08-02 | Sandusky | Ohio | 39143 | 329 | 17 |
391265 | 391265 | 2020-08-01 | Sandusky | Ohio | 39143 | 319 | 17 |
388048 | 388048 | 2020-07-31 | Sandusky | Ohio | 39143 | 315 | 17 |
384831 | 384831 | 2020-07-30 | Sandusky | Ohio | 39143 | 298 | 16 |
381613 | 381613 | 2020-07-29 | Sandusky | Ohio | 39143 | 293 | 16 |
378396 | 378396 | 2020-07-28 | Sandusky | Ohio | 39143 | 288 | 16 |
375179 | 375179 | 2020-07-27 | Sandusky | Ohio | 39143 | 282 | 15 |
371967 | 371967 | 2020-07-26 | Sandusky | Ohio | 39143 | 275 | 15 |
368755 | 368755 | 2020-07-25 | Sandusky | Ohio | 39143 | 271 | 15 |
365546 | 365546 | 2020-07-24 | Sandusky | Ohio | 39143 | 264 | 15 |
362340 | 362340 | 2020-07-23 | Sandusky | Ohio | 39143 | 254 | 15 |
359134 | 359134 | 2020-07-22 | Sandusky | Ohio | 39143 | 240 | 15 |
355930 | 355930 | 2020-07-21 | Sandusky | Ohio | 39143 | 234 | 15 |
352727 | 352727 | 2020-07-20 | Sandusky | Ohio | 39143 | 230 | 15 |
349524 | 349524 | 2020-07-19 | Sandusky | Ohio | 39143 | 221 | 15 |
346323 | 346323 | 2020-07-18 | Sandusky | Ohio | 39143 | 208 | 15 |
343124 | 343124 | 2020-07-17 | Sandusky | Ohio | 39143 | 207 | 15 |
339926 | 339926 | 2020-07-16 | Sandusky | Ohio | 39143 | 191 | 15 |
336730 | 336730 | 2020-07-15 | Sandusky | Ohio | 39143 | 186 | 15 |
333536 | 333536 | 2020-07-14 | Sandusky | Ohio | 39143 | 180 | 15 |
330344 | 330344 | 2020-07-13 | Sandusky | Ohio | 39143 | 176 | 15 |
327157 | 327157 | 2020-07-12 | Sandusky | Ohio | 39143 | 169 | 15 |
323972 | 323972 | 2020-07-11 | Sandusky | Ohio | 39143 | 160 | 15 |
320792 | 320792 | 2020-07-10 | Sandusky | Ohio | 39143 | 157 | 15 |
317615 | 317615 | 2020-07-09 | Sandusky | Ohio | 39143 | 142 | 15 |
314442 | 314442 | 2020-07-08 | Sandusky | Ohio | 39143 | 138 | 14 |
311270 | 311270 | 2020-07-07 | Sandusky | Ohio | 39143 | 137 | 14 |
308101 | 308101 | 2020-07-06 | Sandusky | Ohio | 39143 | 136 | 14 |
304934 | 304934 | 2020-07-05 | Sandusky | Ohio | 39143 | 134 | 14 |
301771 | 301771 | 2020-07-04 | Sandusky | Ohio | 39143 | 127 | 14 |
298608 | 298608 | 2020-07-03 | Sandusky | Ohio | 39143 | 126 | 14 |
295448 | 295448 | 2020-07-02 | Sandusky | Ohio | 39143 | 122 | 13 |
292293 | 292293 | 2020-07-01 | Sandusky | Ohio | 39143 | 122 | 13 |
289141 | 289141 | 2020-06-30 | Sandusky | Ohio | 39143 | 122 | 13 |
285991 | 285991 | 2020-06-29 | Sandusky | Ohio | 39143 | 120 | 13 |
282846 | 282846 | 2020-06-28 | Sandusky | Ohio | 39143 | 115 | 13 |
279700 | 279700 | 2020-06-27 | Sandusky | Ohio | 39143 | 114 | 13 |
276552 | 276552 | 2020-06-26 | Sandusky | Ohio | 39143 | 114 | 13 |
273405 | 273405 | 2020-06-25 | Sandusky | Ohio | 39143 | 112 | 13 |
270266 | 270266 | 2020-06-24 | Sandusky | Ohio | 39143 | 110 | 13 |
267132 | 267132 | 2020-06-23 | Sandusky | Ohio | 39143 | 110 | 13 |
264004 | 264004 | 2020-06-22 | Sandusky | Ohio | 39143 | 110 | 13 |
260876 | 260876 | 2020-06-21 | Sandusky | Ohio | 39143 | 109 | 13 |
257749 | 257749 | 2020-06-20 | Sandusky | Ohio | 39143 | 109 | 13 |
254624 | 254624 | 2020-06-19 | Sandusky | Ohio | 39143 | 109 | 13 |
251509 | 251509 | 2020-06-18 | Sandusky | Ohio | 39143 | 106 | 13 |
248394 | 248394 | 2020-06-17 | Sandusky | Ohio | 39143 | 104 | 13 |
245281 | 245281 | 2020-06-16 | Sandusky | Ohio | 39143 | 104 | 13 |
242169 | 242169 | 2020-06-15 | Sandusky | Ohio | 39143 | 104 | 13 |
239060 | 239060 | 2020-06-14 | Sandusky | Ohio | 39143 | 103 | 13 |
235952 | 235952 | 2020-06-13 | Sandusky | Ohio | 39143 | 102 | 13 |
232847 | 232847 | 2020-06-12 | Sandusky | Ohio | 39143 | 102 | 13 |
229742 | 229742 | 2020-06-11 | Sandusky | Ohio | 39143 | 102 | 13 |
226638 | 226638 | 2020-06-10 | Sandusky | Ohio | 39143 | 102 | 13 |
223538 | 223538 | 2020-06-09 | Sandusky | Ohio | 39143 | 98 | 13 |
220443 | 220443 | 2020-06-08 | Sandusky | Ohio | 39143 | 97 | 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);