ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Warren" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635770 | 635770 | 2020-10-16 | Warren | Iowa | 19181 | 1126 | 6 |
632524 | 632524 | 2020-10-15 | Warren | Iowa | 19181 | 1108 | 6 |
629280 | 629280 | 2020-10-14 | Warren | Iowa | 19181 | 1095 | 6 |
626037 | 626037 | 2020-10-13 | Warren | Iowa | 19181 | 1079 | 6 |
622795 | 622795 | 2020-10-12 | Warren | Iowa | 19181 | 1065 | 6 |
619551 | 619551 | 2020-10-11 | Warren | Iowa | 19181 | 1061 | 6 |
616309 | 616309 | 2020-10-10 | Warren | Iowa | 19181 | 1045 | 6 |
613068 | 613068 | 2020-10-09 | Warren | Iowa | 19181 | 1033 | 6 |
609826 | 609826 | 2020-10-08 | Warren | Iowa | 19181 | 1023 | 6 |
606583 | 606583 | 2020-10-07 | Warren | Iowa | 19181 | 1012 | 6 |
603341 | 603341 | 2020-10-06 | Warren | Iowa | 19181 | 1004 | 6 |
600098 | 600098 | 2020-10-05 | Warren | Iowa | 19181 | 997 | 6 |
596856 | 596856 | 2020-10-04 | Warren | Iowa | 19181 | 998 | 6 |
593614 | 593614 | 2020-10-03 | Warren | Iowa | 19181 | 995 | 6 |
590373 | 590373 | 2020-10-02 | Warren | Iowa | 19181 | 994 | 6 |
587132 | 587132 | 2020-10-01 | Warren | Iowa | 19181 | 989 | 6 |
583892 | 583892 | 2020-09-30 | Warren | Iowa | 19181 | 972 | 6 |
580653 | 580653 | 2020-09-29 | Warren | Iowa | 19181 | 969 | 6 |
577412 | 577412 | 2020-09-28 | Warren | Iowa | 19181 | 966 | 6 |
574170 | 574170 | 2020-09-27 | Warren | Iowa | 19181 | 965 | 6 |
570927 | 570927 | 2020-09-26 | Warren | Iowa | 19181 | 956 | 6 |
567685 | 567685 | 2020-09-25 | Warren | Iowa | 19181 | 951 | 6 |
564445 | 564445 | 2020-09-24 | Warren | Iowa | 19181 | 948 | 6 |
561205 | 561205 | 2020-09-23 | Warren | Iowa | 19181 | 945 | 6 |
557969 | 557969 | 2020-09-22 | Warren | Iowa | 19181 | 939 | 6 |
554732 | 554732 | 2020-09-21 | Warren | Iowa | 19181 | 932 | 6 |
551493 | 551493 | 2020-09-20 | Warren | Iowa | 19181 | 928 | 6 |
548254 | 548254 | 2020-09-19 | Warren | Iowa | 19181 | 927 | 6 |
545016 | 545016 | 2020-09-18 | Warren | Iowa | 19181 | 922 | 6 |
541780 | 541780 | 2020-09-17 | Warren | Iowa | 19181 | 919 | 6 |
538543 | 538543 | 2020-09-16 | Warren | Iowa | 19181 | 914 | 6 |
535307 | 535307 | 2020-09-15 | Warren | Iowa | 19181 | 911 | 6 |
532072 | 532072 | 2020-09-14 | Warren | Iowa | 19181 | 906 | 6 |
528835 | 528835 | 2020-09-13 | Warren | Iowa | 19181 | 903 | 6 |
525599 | 525599 | 2020-09-12 | Warren | Iowa | 19181 | 902 | 6 |
522363 | 522363 | 2020-09-11 | Warren | Iowa | 19181 | 891 | 6 |
519126 | 519126 | 2020-09-10 | Warren | Iowa | 19181 | 880 | 6 |
515891 | 515891 | 2020-09-09 | Warren | Iowa | 19181 | 869 | 6 |
512658 | 512658 | 2020-09-08 | Warren | Iowa | 19181 | 861 | 5 |
509425 | 509425 | 2020-09-07 | Warren | Iowa | 19181 | 855 | 5 |
506193 | 506193 | 2020-09-06 | Warren | Iowa | 19181 | 852 | 5 |
502959 | 502959 | 2020-09-05 | Warren | Iowa | 19181 | 845 | 5 |
499725 | 499725 | 2020-09-04 | Warren | Iowa | 19181 | 824 | 5 |
496492 | 496492 | 2020-09-03 | Warren | Iowa | 19181 | 810 | 6 |
493258 | 493258 | 2020-09-02 | Warren | Iowa | 19181 | 792 | 6 |
490025 | 490025 | 2020-09-01 | Warren | Iowa | 19181 | 784 | 5 |
486792 | 486792 | 2020-08-31 | Warren | Iowa | 19181 | 779 | 5 |
483557 | 483557 | 2020-08-30 | Warren | Iowa | 19181 | 775 | 5 |
480323 | 480323 | 2020-08-29 | Warren | Iowa | 19181 | 766 | 5 |
477090 | 477090 | 2020-08-28 | Warren | Iowa | 19181 | 753 | 5 |
473857 | 473857 | 2020-08-27 | Warren | Iowa | 19181 | 742 | 5 |
470625 | 470625 | 2020-08-26 | Warren | Iowa | 19181 | 680 | 5 |
467396 | 467396 | 2020-08-25 | Warren | Iowa | 19181 | 666 | 5 |
464167 | 464167 | 2020-08-24 | Warren | Iowa | 19181 | 660 | 5 |
460938 | 460938 | 2020-08-23 | Warren | Iowa | 19181 | 655 | 5 |
457711 | 457711 | 2020-08-22 | Warren | Iowa | 19181 | 649 | 4 |
454483 | 454483 | 2020-08-21 | Warren | Iowa | 19181 | 632 | 4 |
451255 | 451255 | 2020-08-20 | Warren | Iowa | 19181 | 628 | 4 |
448027 | 448027 | 2020-08-19 | Warren | Iowa | 19181 | 613 | 3 |
444800 | 444800 | 2020-08-18 | Warren | Iowa | 19181 | 608 | 3 |
441574 | 441574 | 2020-08-17 | Warren | Iowa | 19181 | 606 | 3 |
438347 | 438347 | 2020-08-16 | Warren | Iowa | 19181 | 603 | 2 |
435122 | 435122 | 2020-08-15 | Warren | Iowa | 19181 | 603 | 2 |
431897 | 431897 | 2020-08-14 | Warren | Iowa | 19181 | 597 | 2 |
428669 | 428669 | 2020-08-13 | Warren | Iowa | 19181 | 590 | 2 |
425445 | 425445 | 2020-08-12 | Warren | Iowa | 19181 | 582 | 1 |
422224 | 422224 | 2020-08-11 | Warren | Iowa | 19181 | 572 | 1 |
419001 | 419001 | 2020-08-10 | Warren | Iowa | 19181 | 569 | 1 |
415780 | 415780 | 2020-08-09 | Warren | Iowa | 19181 | 564 | 1 |
412560 | 412560 | 2020-08-08 | Warren | Iowa | 19181 | 550 | 1 |
409340 | 409340 | 2020-08-07 | Warren | Iowa | 19181 | 550 | 1 |
406121 | 406121 | 2020-08-06 | Warren | Iowa | 19181 | 547 | 1 |
402903 | 402903 | 2020-08-05 | Warren | Iowa | 19181 | 542 | 1 |
399686 | 399686 | 2020-08-04 | Warren | Iowa | 19181 | 534 | 1 |
396471 | 396471 | 2020-08-03 | Warren | Iowa | 19181 | 528 | 1 |
393255 | 393255 | 2020-08-02 | Warren | Iowa | 19181 | 526 | 1 |
390038 | 390038 | 2020-08-01 | Warren | Iowa | 19181 | 517 | 1 |
386821 | 386821 | 2020-07-31 | Warren | Iowa | 19181 | 503 | 1 |
383603 | 383603 | 2020-07-30 | Warren | Iowa | 19181 | 499 | 1 |
380386 | 380386 | 2020-07-29 | Warren | Iowa | 19181 | 486 | 1 |
377169 | 377169 | 2020-07-28 | Warren | Iowa | 19181 | 478 | 1 |
373954 | 373954 | 2020-07-27 | Warren | Iowa | 19181 | 474 | 1 |
370742 | 370742 | 2020-07-26 | Warren | Iowa | 19181 | 468 | 1 |
367532 | 367532 | 2020-07-25 | Warren | Iowa | 19181 | 457 | 1 |
364325 | 364325 | 2020-07-24 | Warren | Iowa | 19181 | 442 | 1 |
361118 | 361118 | 2020-07-23 | Warren | Iowa | 19181 | 432 | 1 |
357913 | 357913 | 2020-07-22 | Warren | Iowa | 19181 | 425 | 1 |
354711 | 354711 | 2020-07-21 | Warren | Iowa | 19181 | 419 | 1 |
351509 | 351509 | 2020-07-20 | Warren | Iowa | 19181 | 415 | 1 |
348309 | 348309 | 2020-07-19 | Warren | Iowa | 19181 | 404 | 1 |
345108 | 345108 | 2020-07-18 | Warren | Iowa | 19181 | 394 | 1 |
341908 | 341908 | 2020-07-17 | Warren | Iowa | 19181 | 386 | 1 |
338712 | 338712 | 2020-07-16 | Warren | Iowa | 19181 | 373 | 1 |
335516 | 335516 | 2020-07-15 | Warren | Iowa | 19181 | 348 | 1 |
332323 | 332323 | 2020-07-14 | Warren | Iowa | 19181 | 337 | 1 |
329136 | 329136 | 2020-07-13 | Warren | Iowa | 19181 | 337 | 1 |
325950 | 325950 | 2020-07-12 | Warren | Iowa | 19181 | 333 | 1 |
322769 | 322769 | 2020-07-11 | Warren | Iowa | 19181 | 319 | 1 |
319590 | 319590 | 2020-07-10 | Warren | Iowa | 19181 | 312 | 1 |
316417 | 316417 | 2020-07-09 | Warren | Iowa | 19181 | 300 | 1 |
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);