ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 19171 and state = "Iowa" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
287946 | 287946 | 2020-06-30 | Tama | Iowa | 19171 | 445 | 29 |
291096 | 291096 | 2020-07-01 | Tama | Iowa | 19171 | 451 | 29 |
294250 | 294250 | 2020-07-02 | Tama | Iowa | 19171 | 458 | 29 |
297408 | 297408 | 2020-07-03 | Tama | Iowa | 19171 | 460 | 29 |
300570 | 300570 | 2020-07-04 | Tama | Iowa | 19171 | 463 | 29 |
303734 | 303734 | 2020-07-05 | Tama | Iowa | 19171 | 465 | 29 |
306899 | 306899 | 2020-07-06 | Tama | Iowa | 19171 | 465 | 29 |
310067 | 310067 | 2020-07-07 | Tama | Iowa | 19171 | 468 | 29 |
313237 | 313237 | 2020-07-08 | Tama | Iowa | 19171 | 473 | 29 |
316411 | 316411 | 2020-07-09 | Tama | Iowa | 19171 | 478 | 29 |
319584 | 319584 | 2020-07-10 | Tama | Iowa | 19171 | 483 | 29 |
322763 | 322763 | 2020-07-11 | Tama | Iowa | 19171 | 484 | 29 |
325944 | 325944 | 2020-07-12 | Tama | Iowa | 19171 | 487 | 29 |
329130 | 329130 | 2020-07-13 | Tama | Iowa | 19171 | 488 | 29 |
332317 | 332317 | 2020-07-14 | Tama | Iowa | 19171 | 490 | 29 |
335510 | 335510 | 2020-07-15 | Tama | Iowa | 19171 | 493 | 29 |
338706 | 338706 | 2020-07-16 | Tama | Iowa | 19171 | 500 | 29 |
341902 | 341902 | 2020-07-17 | Tama | Iowa | 19171 | 503 | 29 |
345102 | 345102 | 2020-07-18 | Tama | Iowa | 19171 | 507 | 29 |
348303 | 348303 | 2020-07-19 | Tama | Iowa | 19171 | 509 | 29 |
351503 | 351503 | 2020-07-20 | Tama | Iowa | 19171 | 510 | 29 |
354705 | 354705 | 2020-07-21 | Tama | Iowa | 19171 | 511 | 29 |
357907 | 357907 | 2020-07-22 | Tama | Iowa | 19171 | 513 | 29 |
361112 | 361112 | 2020-07-23 | Tama | Iowa | 19171 | 514 | 29 |
364319 | 364319 | 2020-07-24 | Tama | Iowa | 19171 | 517 | 29 |
367526 | 367526 | 2020-07-25 | Tama | Iowa | 19171 | 519 | 29 |
370736 | 370736 | 2020-07-26 | Tama | Iowa | 19171 | 520 | 29 |
373948 | 373948 | 2020-07-27 | Tama | Iowa | 19171 | 521 | 29 |
377163 | 377163 | 2020-07-28 | Tama | Iowa | 19171 | 524 | 29 |
380380 | 380380 | 2020-07-29 | Tama | Iowa | 19171 | 529 | 29 |
383597 | 383597 | 2020-07-30 | Tama | Iowa | 19171 | 532 | 29 |
386815 | 386815 | 2020-07-31 | Tama | Iowa | 19171 | 534 | 29 |
390032 | 390032 | 2020-08-01 | Tama | Iowa | 19171 | 535 | 29 |
393249 | 393249 | 2020-08-02 | Tama | Iowa | 19171 | 537 | 29 |
396465 | 396465 | 2020-08-03 | Tama | Iowa | 19171 | 537 | 29 |
399681 | 399681 | 2020-08-04 | Tama | Iowa | 19171 | 539 | 29 |
402897 | 402897 | 2020-08-05 | Tama | Iowa | 19171 | 543 | 29 |
406115 | 406115 | 2020-08-06 | Tama | Iowa | 19171 | 545 | 29 |
409335 | 409335 | 2020-08-07 | Tama | Iowa | 19171 | 547 | 29 |
412554 | 412554 | 2020-08-08 | Tama | Iowa | 19171 | 548 | 29 |
415774 | 415774 | 2020-08-09 | Tama | Iowa | 19171 | 551 | 29 |
418995 | 418995 | 2020-08-10 | Tama | Iowa | 19171 | 553 | 29 |
422218 | 422218 | 2020-08-11 | Tama | Iowa | 19171 | 554 | 29 |
425439 | 425439 | 2020-08-12 | Tama | Iowa | 19171 | 556 | 29 |
428663 | 428663 | 2020-08-13 | Tama | Iowa | 19171 | 560 | 29 |
431891 | 431891 | 2020-08-14 | Tama | Iowa | 19171 | 561 | 29 |
435116 | 435116 | 2020-08-15 | Tama | Iowa | 19171 | 562 | 29 |
438342 | 438342 | 2020-08-16 | Tama | Iowa | 19171 | 562 | 29 |
441568 | 441568 | 2020-08-17 | Tama | Iowa | 19171 | 562 | 29 |
444794 | 444794 | 2020-08-18 | Tama | Iowa | 19171 | 563 | 29 |
448021 | 448021 | 2020-08-19 | Tama | Iowa | 19171 | 572 | 29 |
451249 | 451249 | 2020-08-20 | Tama | Iowa | 19171 | 577 | 29 |
454477 | 454477 | 2020-08-21 | Tama | Iowa | 19171 | 582 | 29 |
457705 | 457705 | 2020-08-22 | Tama | Iowa | 19171 | 582 | 29 |
460932 | 460932 | 2020-08-23 | Tama | Iowa | 19171 | 584 | 29 |
464161 | 464161 | 2020-08-24 | Tama | Iowa | 19171 | 586 | 29 |
467390 | 467390 | 2020-08-25 | Tama | Iowa | 19171 | 590 | 29 |
470619 | 470619 | 2020-08-26 | Tama | Iowa | 19171 | 601 | 29 |
473851 | 473851 | 2020-08-27 | Tama | Iowa | 19171 | 610 | 29 |
477084 | 477084 | 2020-08-28 | Tama | Iowa | 19171 | 614 | 29 |
480317 | 480317 | 2020-08-29 | Tama | Iowa | 19171 | 619 | 29 |
483551 | 483551 | 2020-08-30 | Tama | Iowa | 19171 | 622 | 29 |
486786 | 486786 | 2020-08-31 | Tama | Iowa | 19171 | 623 | 29 |
490019 | 490019 | 2020-09-01 | Tama | Iowa | 19171 | 623 | 29 |
493252 | 493252 | 2020-09-02 | Tama | Iowa | 19171 | 628 | 29 |
496486 | 496486 | 2020-09-03 | Tama | Iowa | 19171 | 645 | 29 |
499719 | 499719 | 2020-09-04 | Tama | Iowa | 19171 | 646 | 29 |
502953 | 502953 | 2020-09-05 | Tama | Iowa | 19171 | 649 | 29 |
506187 | 506187 | 2020-09-06 | Tama | Iowa | 19171 | 652 | 29 |
509419 | 509419 | 2020-09-07 | Tama | Iowa | 19171 | 652 | 29 |
512652 | 512652 | 2020-09-08 | Tama | Iowa | 19171 | 655 | 30 |
515885 | 515885 | 2020-09-09 | Tama | Iowa | 19171 | 657 | 30 |
519120 | 519120 | 2020-09-10 | Tama | Iowa | 19171 | 662 | 30 |
522357 | 522357 | 2020-09-11 | Tama | Iowa | 19171 | 665 | 30 |
525593 | 525593 | 2020-09-12 | Tama | Iowa | 19171 | 670 | 30 |
528829 | 528829 | 2020-09-13 | Tama | Iowa | 19171 | 671 | 30 |
532066 | 532066 | 2020-09-14 | Tama | Iowa | 19171 | 673 | 30 |
535301 | 535301 | 2020-09-15 | Tama | Iowa | 19171 | 673 | 30 |
538537 | 538537 | 2020-09-16 | Tama | Iowa | 19171 | 676 | 30 |
541774 | 541774 | 2020-09-17 | Tama | Iowa | 19171 | 680 | 31 |
545010 | 545010 | 2020-09-18 | Tama | Iowa | 19171 | 685 | 31 |
548248 | 548248 | 2020-09-19 | Tama | Iowa | 19171 | 687 | 31 |
551487 | 551487 | 2020-09-20 | Tama | Iowa | 19171 | 690 | 31 |
554726 | 554726 | 2020-09-21 | Tama | Iowa | 19171 | 694 | 31 |
557963 | 557963 | 2020-09-22 | Tama | Iowa | 19171 | 696 | 31 |
561199 | 561199 | 2020-09-23 | Tama | Iowa | 19171 | 699 | 31 |
564439 | 564439 | 2020-09-24 | Tama | Iowa | 19171 | 704 | 31 |
567679 | 567679 | 2020-09-25 | Tama | Iowa | 19171 | 708 | 31 |
570921 | 570921 | 2020-09-26 | Tama | Iowa | 19171 | 713 | 31 |
574164 | 574164 | 2020-09-27 | Tama | Iowa | 19171 | 732 | 31 |
577406 | 577406 | 2020-09-28 | Tama | Iowa | 19171 | 739 | 32 |
580647 | 580647 | 2020-09-29 | Tama | Iowa | 19171 | 753 | 32 |
583886 | 583886 | 2020-09-30 | Tama | Iowa | 19171 | 757 | 32 |
587126 | 587126 | 2020-10-01 | Tama | Iowa | 19171 | 769 | 32 |
590367 | 590367 | 2020-10-02 | Tama | Iowa | 19171 | 789 | 32 |
593608 | 593608 | 2020-10-03 | Tama | Iowa | 19171 | 791 | 32 |
596850 | 596850 | 2020-10-04 | Tama | Iowa | 19171 | 791 | 32 |
600092 | 600092 | 2020-10-05 | Tama | Iowa | 19171 | 793 | 33 |
603335 | 603335 | 2020-10-06 | Tama | Iowa | 19171 | 810 | 34 |
606577 | 606577 | 2020-10-07 | Tama | Iowa | 19171 | 821 | 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);