ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 19099 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635728 | 635728 | 2020-10-16 | Jasper | Iowa | 19099 | 1005 | 34 |
632482 | 632482 | 2020-10-15 | Jasper | Iowa | 19099 | 993 | 34 |
629238 | 629238 | 2020-10-14 | Jasper | Iowa | 19099 | 991 | 35 |
625995 | 625995 | 2020-10-13 | Jasper | Iowa | 19099 | 983 | 35 |
622753 | 622753 | 2020-10-12 | Jasper | Iowa | 19099 | 968 | 35 |
619509 | 619509 | 2020-10-11 | Jasper | Iowa | 19099 | 964 | 35 |
616267 | 616267 | 2020-10-10 | Jasper | Iowa | 19099 | 958 | 35 |
613026 | 613026 | 2020-10-09 | Jasper | Iowa | 19099 | 954 | 35 |
609784 | 609784 | 2020-10-08 | Jasper | Iowa | 19099 | 944 | 34 |
606541 | 606541 | 2020-10-07 | Jasper | Iowa | 19099 | 938 | 34 |
603299 | 603299 | 2020-10-06 | Jasper | Iowa | 19099 | 919 | 34 |
600056 | 600056 | 2020-10-05 | Jasper | Iowa | 19099 | 912 | 34 |
596814 | 596814 | 2020-10-04 | Jasper | Iowa | 19099 | 909 | 34 |
593572 | 593572 | 2020-10-03 | Jasper | Iowa | 19099 | 909 | 34 |
590331 | 590331 | 2020-10-02 | Jasper | Iowa | 19099 | 901 | 34 |
587090 | 587090 | 2020-10-01 | Jasper | Iowa | 19099 | 893 | 34 |
583850 | 583850 | 2020-09-30 | Jasper | Iowa | 19099 | 883 | 34 |
580611 | 580611 | 2020-09-29 | Jasper | Iowa | 19099 | 870 | 34 |
577370 | 577370 | 2020-09-28 | Jasper | Iowa | 19099 | 864 | 32 |
574128 | 574128 | 2020-09-27 | Jasper | Iowa | 19099 | 845 | 32 |
570885 | 570885 | 2020-09-26 | Jasper | Iowa | 19099 | 838 | 32 |
567643 | 567643 | 2020-09-25 | Jasper | Iowa | 19099 | 833 | 32 |
564403 | 564403 | 2020-09-24 | Jasper | Iowa | 19099 | 817 | 32 |
561163 | 561163 | 2020-09-23 | Jasper | Iowa | 19099 | 802 | 32 |
557927 | 557927 | 2020-09-22 | Jasper | Iowa | 19099 | 783 | 32 |
554690 | 554690 | 2020-09-21 | Jasper | Iowa | 19099 | 772 | 32 |
551451 | 551451 | 2020-09-20 | Jasper | Iowa | 19099 | 766 | 32 |
548212 | 548212 | 2020-09-19 | Jasper | Iowa | 19099 | 756 | 32 |
544974 | 544974 | 2020-09-18 | Jasper | Iowa | 19099 | 742 | 32 |
541738 | 541738 | 2020-09-17 | Jasper | Iowa | 19099 | 728 | 32 |
538501 | 538501 | 2020-09-16 | Jasper | Iowa | 19099 | 707 | 32 |
535265 | 535265 | 2020-09-15 | Jasper | Iowa | 19099 | 694 | 32 |
532030 | 532030 | 2020-09-14 | Jasper | Iowa | 19099 | 686 | 32 |
528793 | 528793 | 2020-09-13 | Jasper | Iowa | 19099 | 684 | 31 |
525557 | 525557 | 2020-09-12 | Jasper | Iowa | 19099 | 677 | 31 |
522321 | 522321 | 2020-09-11 | Jasper | Iowa | 19099 | 667 | 31 |
519084 | 519084 | 2020-09-10 | Jasper | Iowa | 19099 | 659 | 31 |
515849 | 515849 | 2020-09-09 | Jasper | Iowa | 19099 | 651 | 31 |
512616 | 512616 | 2020-09-08 | Jasper | Iowa | 19099 | 643 | 31 |
509383 | 509383 | 2020-09-07 | Jasper | Iowa | 19099 | 637 | 30 |
506151 | 506151 | 2020-09-06 | Jasper | Iowa | 19099 | 634 | 30 |
502917 | 502917 | 2020-09-05 | Jasper | Iowa | 19099 | 629 | 30 |
499683 | 499683 | 2020-09-04 | Jasper | Iowa | 19099 | 610 | 30 |
496450 | 496450 | 2020-09-03 | Jasper | Iowa | 19099 | 602 | 30 |
493216 | 493216 | 2020-09-02 | Jasper | Iowa | 19099 | 592 | 30 |
489983 | 489983 | 2020-09-01 | Jasper | Iowa | 19099 | 588 | 30 |
486750 | 486750 | 2020-08-31 | Jasper | Iowa | 19099 | 588 | 30 |
483515 | 483515 | 2020-08-30 | Jasper | Iowa | 19099 | 585 | 30 |
480281 | 480281 | 2020-08-29 | Jasper | Iowa | 19099 | 577 | 30 |
477048 | 477048 | 2020-08-28 | Jasper | Iowa | 19099 | 563 | 30 |
473815 | 473815 | 2020-08-27 | Jasper | Iowa | 19099 | 556 | 30 |
470583 | 470583 | 2020-08-26 | Jasper | Iowa | 19099 | 536 | 30 |
467354 | 467354 | 2020-08-25 | Jasper | Iowa | 19099 | 527 | 30 |
464125 | 464125 | 2020-08-24 | Jasper | Iowa | 19099 | 523 | 30 |
460896 | 460896 | 2020-08-23 | Jasper | Iowa | 19099 | 522 | 29 |
457669 | 457669 | 2020-08-22 | Jasper | Iowa | 19099 | 520 | 29 |
454441 | 454441 | 2020-08-21 | Jasper | Iowa | 19099 | 514 | 29 |
451213 | 451213 | 2020-08-20 | Jasper | Iowa | 19099 | 510 | 29 |
447985 | 447985 | 2020-08-19 | Jasper | Iowa | 19099 | 507 | 29 |
444758 | 444758 | 2020-08-18 | Jasper | Iowa | 19099 | 503 | 29 |
441532 | 441532 | 2020-08-17 | Jasper | Iowa | 19099 | 501 | 28 |
438306 | 438306 | 2020-08-16 | Jasper | Iowa | 19099 | 498 | 28 |
435080 | 435080 | 2020-08-15 | Jasper | Iowa | 19099 | 495 | 28 |
431855 | 431855 | 2020-08-14 | Jasper | Iowa | 19099 | 490 | 28 |
428627 | 428627 | 2020-08-13 | Jasper | Iowa | 19099 | 488 | 27 |
425403 | 425403 | 2020-08-12 | Jasper | Iowa | 19099 | 484 | 27 |
422182 | 422182 | 2020-08-11 | Jasper | Iowa | 19099 | 481 | 27 |
418959 | 418959 | 2020-08-10 | Jasper | Iowa | 19099 | 479 | 26 |
415738 | 415738 | 2020-08-09 | Jasper | Iowa | 19099 | 478 | 26 |
412518 | 412518 | 2020-08-08 | Jasper | Iowa | 19099 | 473 | 26 |
409299 | 409299 | 2020-08-07 | Jasper | Iowa | 19099 | 470 | 26 |
406079 | 406079 | 2020-08-06 | Jasper | Iowa | 19099 | 466 | 26 |
402861 | 402861 | 2020-08-05 | Jasper | Iowa | 19099 | 458 | 25 |
399645 | 399645 | 2020-08-04 | Jasper | Iowa | 19099 | 458 | 25 |
396429 | 396429 | 2020-08-03 | Jasper | Iowa | 19099 | 455 | 24 |
393213 | 393213 | 2020-08-02 | Jasper | Iowa | 19099 | 454 | 24 |
389996 | 389996 | 2020-08-01 | Jasper | Iowa | 19099 | 453 | 24 |
386779 | 386779 | 2020-07-31 | Jasper | Iowa | 19099 | 450 | 24 |
383561 | 383561 | 2020-07-30 | Jasper | Iowa | 19099 | 445 | 24 |
380344 | 380344 | 2020-07-29 | Jasper | Iowa | 19099 | 443 | 24 |
377127 | 377127 | 2020-07-28 | Jasper | Iowa | 19099 | 439 | 24 |
373912 | 373912 | 2020-07-27 | Jasper | Iowa | 19099 | 439 | 23 |
370700 | 370700 | 2020-07-26 | Jasper | Iowa | 19099 | 438 | 22 |
367490 | 367490 | 2020-07-25 | Jasper | Iowa | 19099 | 427 | 22 |
364283 | 364283 | 2020-07-24 | Jasper | Iowa | 19099 | 424 | 22 |
361076 | 361076 | 2020-07-23 | Jasper | Iowa | 19099 | 416 | 20 |
357871 | 357871 | 2020-07-22 | Jasper | Iowa | 19099 | 416 | 19 |
354669 | 354669 | 2020-07-21 | Jasper | Iowa | 19099 | 414 | 18 |
351467 | 351467 | 2020-07-20 | Jasper | Iowa | 19099 | 413 | 17 |
348267 | 348267 | 2020-07-19 | Jasper | Iowa | 19099 | 393 | 17 |
345066 | 345066 | 2020-07-18 | Jasper | Iowa | 19099 | 384 | 17 |
341866 | 341866 | 2020-07-17 | Jasper | Iowa | 19099 | 382 | 17 |
338670 | 338670 | 2020-07-16 | Jasper | Iowa | 19099 | 380 | 17 |
335474 | 335474 | 2020-07-15 | Jasper | Iowa | 19099 | 375 | 17 |
332281 | 332281 | 2020-07-14 | Jasper | Iowa | 19099 | 359 | 17 |
329094 | 329094 | 2020-07-13 | Jasper | Iowa | 19099 | 357 | 17 |
325908 | 325908 | 2020-07-12 | Jasper | Iowa | 19099 | 354 | 17 |
322727 | 322727 | 2020-07-11 | Jasper | Iowa | 19099 | 345 | 17 |
319548 | 319548 | 2020-07-10 | Jasper | Iowa | 19099 | 337 | 17 |
316375 | 316375 | 2020-07-09 | Jasper | Iowa | 19099 | 332 | 17 |
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);