ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 39077 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
276519 | 276519 | 2020-06-26 | Huron | Ohio | 39077 | 147 | 1 |
279667 | 279667 | 2020-06-27 | Huron | Ohio | 39077 | 153 | 1 |
282813 | 282813 | 2020-06-28 | Huron | Ohio | 39077 | 159 | 1 |
285958 | 285958 | 2020-06-29 | Huron | Ohio | 39077 | 165 | 1 |
289108 | 289108 | 2020-06-30 | Huron | Ohio | 39077 | 170 | 1 |
292260 | 292260 | 2020-07-01 | Huron | Ohio | 39077 | 177 | 2 |
295415 | 295415 | 2020-07-02 | Huron | Ohio | 39077 | 177 | 2 |
298575 | 298575 | 2020-07-03 | Huron | Ohio | 39077 | 199 | 2 |
301738 | 301738 | 2020-07-04 | Huron | Ohio | 39077 | 211 | 2 |
304901 | 304901 | 2020-07-05 | Huron | Ohio | 39077 | 215 | 2 |
308068 | 308068 | 2020-07-06 | Huron | Ohio | 39077 | 220 | 2 |
311237 | 311237 | 2020-07-07 | Huron | Ohio | 39077 | 223 | 2 |
314409 | 314409 | 2020-07-08 | Huron | Ohio | 39077 | 228 | 2 |
317582 | 317582 | 2020-07-09 | Huron | Ohio | 39077 | 234 | 2 |
320759 | 320759 | 2020-07-10 | Huron | Ohio | 39077 | 238 | 2 |
323939 | 323939 | 2020-07-11 | Huron | Ohio | 39077 | 240 | 2 |
327124 | 327124 | 2020-07-12 | Huron | Ohio | 39077 | 247 | 2 |
330311 | 330311 | 2020-07-13 | Huron | Ohio | 39077 | 260 | 2 |
333503 | 333503 | 2020-07-14 | Huron | Ohio | 39077 | 264 | 3 |
336697 | 336697 | 2020-07-15 | Huron | Ohio | 39077 | 271 | 3 |
339893 | 339893 | 2020-07-16 | Huron | Ohio | 39077 | 275 | 3 |
343091 | 343091 | 2020-07-17 | Huron | Ohio | 39077 | 278 | 3 |
346290 | 346290 | 2020-07-18 | Huron | Ohio | 39077 | 284 | 3 |
349491 | 349491 | 2020-07-19 | Huron | Ohio | 39077 | 290 | 3 |
352694 | 352694 | 2020-07-20 | Huron | Ohio | 39077 | 303 | 3 |
355897 | 355897 | 2020-07-21 | Huron | Ohio | 39077 | 309 | 3 |
359101 | 359101 | 2020-07-22 | Huron | Ohio | 39077 | 311 | 3 |
362307 | 362307 | 2020-07-23 | Huron | Ohio | 39077 | 317 | 3 |
365513 | 365513 | 2020-07-24 | Huron | Ohio | 39077 | 320 | 3 |
368722 | 368722 | 2020-07-25 | Huron | Ohio | 39077 | 328 | 3 |
371934 | 371934 | 2020-07-26 | Huron | Ohio | 39077 | 329 | 3 |
375146 | 375146 | 2020-07-27 | Huron | Ohio | 39077 | 334 | 3 |
378363 | 378363 | 2020-07-28 | Huron | Ohio | 39077 | 343 | 3 |
381580 | 381580 | 2020-07-29 | Huron | Ohio | 39077 | 349 | 3 |
384798 | 384798 | 2020-07-30 | Huron | Ohio | 39077 | 359 | 4 |
388015 | 388015 | 2020-07-31 | Huron | Ohio | 39077 | 369 | 4 |
391232 | 391232 | 2020-08-01 | Huron | Ohio | 39077 | 368 | 4 |
394448 | 394448 | 2020-08-02 | Huron | Ohio | 39077 | 371 | 4 |
397665 | 397665 | 2020-08-03 | Huron | Ohio | 39077 | 376 | 4 |
400880 | 400880 | 2020-08-04 | Huron | Ohio | 39077 | 378 | 4 |
404098 | 404098 | 2020-08-05 | Huron | Ohio | 39077 | 383 | 5 |
407317 | 407317 | 2020-08-06 | Huron | Ohio | 39077 | 388 | 5 |
410537 | 410537 | 2020-08-07 | Huron | Ohio | 39077 | 393 | 5 |
413757 | 413757 | 2020-08-08 | Huron | Ohio | 39077 | 395 | 5 |
416978 | 416978 | 2020-08-09 | Huron | Ohio | 39077 | 396 | 5 |
420198 | 420198 | 2020-08-10 | Huron | Ohio | 39077 | 401 | 5 |
423421 | 423421 | 2020-08-11 | Huron | Ohio | 39077 | 404 | 5 |
426644 | 426644 | 2020-08-12 | Huron | Ohio | 39077 | 411 | 5 |
429869 | 429869 | 2020-08-13 | Huron | Ohio | 39077 | 413 | 5 |
433095 | 433095 | 2020-08-14 | Huron | Ohio | 39077 | 414 | 5 |
436321 | 436321 | 2020-08-15 | Huron | Ohio | 39077 | 418 | 5 |
439546 | 439546 | 2020-08-16 | Huron | Ohio | 39077 | 418 | 5 |
442773 | 442773 | 2020-08-17 | Huron | Ohio | 39077 | 420 | 5 |
445999 | 445999 | 2020-08-18 | Huron | Ohio | 39077 | 423 | 5 |
449227 | 449227 | 2020-08-19 | Huron | Ohio | 39077 | 425 | 6 |
452455 | 452455 | 2020-08-20 | Huron | Ohio | 39077 | 425 | 6 |
455683 | 455683 | 2020-08-21 | Huron | Ohio | 39077 | 459 | 6 |
458911 | 458911 | 2020-08-22 | Huron | Ohio | 39077 | 462 | 6 |
462139 | 462139 | 2020-08-23 | Huron | Ohio | 39077 | 462 | 6 |
465368 | 465368 | 2020-08-24 | Huron | Ohio | 39077 | 462 | 6 |
468596 | 468596 | 2020-08-25 | Huron | Ohio | 39077 | 462 | 6 |
471828 | 471828 | 2020-08-26 | Huron | Ohio | 39077 | 462 | 6 |
475062 | 475062 | 2020-08-27 | Huron | Ohio | 39077 | 465 | 6 |
478295 | 478295 | 2020-08-28 | Huron | Ohio | 39077 | 468 | 6 |
481529 | 481529 | 2020-08-29 | Huron | Ohio | 39077 | 469 | 6 |
484764 | 484764 | 2020-08-30 | Huron | Ohio | 39077 | 470 | 6 |
487997 | 487997 | 2020-08-31 | Huron | Ohio | 39077 | 475 | 6 |
491230 | 491230 | 2020-09-01 | Huron | Ohio | 39077 | 479 | 6 |
494464 | 494464 | 2020-09-02 | Huron | Ohio | 39077 | 481 | 6 |
497697 | 497697 | 2020-09-03 | Huron | Ohio | 39077 | 483 | 6 |
500931 | 500931 | 2020-09-04 | Huron | Ohio | 39077 | 487 | 6 |
504165 | 504165 | 2020-09-05 | Huron | Ohio | 39077 | 493 | 6 |
507397 | 507397 | 2020-09-06 | Huron | Ohio | 39077 | 493 | 6 |
510630 | 510630 | 2020-09-07 | Huron | Ohio | 39077 | 495 | 6 |
513863 | 513863 | 2020-09-08 | Huron | Ohio | 39077 | 496 | 6 |
517098 | 517098 | 2020-09-09 | Huron | Ohio | 39077 | 498 | 6 |
520334 | 520334 | 2020-09-10 | Huron | Ohio | 39077 | 499 | 6 |
523570 | 523570 | 2020-09-11 | Huron | Ohio | 39077 | 502 | 7 |
526806 | 526806 | 2020-09-12 | Huron | Ohio | 39077 | 504 | 7 |
530043 | 530043 | 2020-09-13 | Huron | Ohio | 39077 | 505 | 7 |
533278 | 533278 | 2020-09-14 | Huron | Ohio | 39077 | 509 | 7 |
536514 | 536514 | 2020-09-15 | Huron | Ohio | 39077 | 512 | 7 |
539751 | 539751 | 2020-09-16 | Huron | Ohio | 39077 | 517 | 7 |
542987 | 542987 | 2020-09-17 | Huron | Ohio | 39077 | 520 | 7 |
546224 | 546224 | 2020-09-18 | Huron | Ohio | 39077 | 520 | 7 |
549463 | 549463 | 2020-09-19 | Huron | Ohio | 39077 | 521 | 7 |
552702 | 552702 | 2020-09-20 | Huron | Ohio | 39077 | 523 | 7 |
555939 | 555939 | 2020-09-21 | Huron | Ohio | 39077 | 530 | 7 |
559176 | 559176 | 2020-09-22 | Huron | Ohio | 39077 | 533 | 7 |
562413 | 562413 | 2020-09-23 | Huron | Ohio | 39077 | 538 | 7 |
565654 | 565654 | 2020-09-24 | Huron | Ohio | 39077 | 542 | 7 |
568895 | 568895 | 2020-09-25 | Huron | Ohio | 39077 | 542 | 7 |
572137 | 572137 | 2020-09-26 | Huron | Ohio | 39077 | 546 | 7 |
575381 | 575381 | 2020-09-27 | Huron | Ohio | 39077 | 551 | 7 |
578622 | 578622 | 2020-09-28 | Huron | Ohio | 39077 | 555 | 7 |
581862 | 581862 | 2020-09-29 | Huron | Ohio | 39077 | 572 | 7 |
585102 | 585102 | 2020-09-30 | Huron | Ohio | 39077 | 588 | 7 |
588342 | 588342 | 2020-10-01 | Huron | Ohio | 39077 | 598 | 7 |
591583 | 591583 | 2020-10-02 | Huron | Ohio | 39077 | 606 | 7 |
594824 | 594824 | 2020-10-03 | Huron | Ohio | 39077 | 608 | 7 |
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);