ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
741 rows where county = "Monroe" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921299 | 921299 | 2021-01-12 | Monroe | Iowa | 19135 | 781 | 18 |
918054 | 918054 | 2021-01-11 | Monroe | Iowa | 19135 | 772 | 18 |
914809 | 914809 | 2021-01-10 | Monroe | Iowa | 19135 | 769 | 18 |
911564 | 911564 | 2021-01-09 | Monroe | Iowa | 19135 | 769 | 18 |
908319 | 908319 | 2021-01-08 | Monroe | Iowa | 19135 | 752 | 18 |
905073 | 905073 | 2021-01-07 | Monroe | Iowa | 19135 | 744 | 17 |
901828 | 901828 | 2021-01-06 | Monroe | Iowa | 19135 | 727 | 17 |
898583 | 898583 | 2021-01-05 | Monroe | Iowa | 19135 | 716 | 17 |
895338 | 895338 | 2021-01-04 | Monroe | Iowa | 19135 | 707 | 17 |
892091 | 892091 | 2021-01-03 | Monroe | Iowa | 19135 | 696 | 17 |
888845 | 888845 | 2021-01-02 | Monroe | Iowa | 19135 | 683 | 17 |
885599 | 885599 | 2021-01-01 | Monroe | Iowa | 19135 | 682 | 17 |
882354 | 882354 | 2020-12-31 | Monroe | Iowa | 19135 | 670 | 17 |
879109 | 879109 | 2020-12-30 | Monroe | Iowa | 19135 | 648 | 16 |
875864 | 875864 | 2020-12-29 | Monroe | Iowa | 19135 | 628 | 16 |
872619 | 872619 | 2020-12-28 | Monroe | Iowa | 19135 | 621 | 16 |
869374 | 869374 | 2020-12-27 | Monroe | Iowa | 19135 | 617 | 16 |
866129 | 866129 | 2020-12-26 | Monroe | Iowa | 19135 | 612 | 16 |
862884 | 862884 | 2020-12-25 | Monroe | Iowa | 19135 | 607 | 16 |
859639 | 859639 | 2020-12-24 | Monroe | Iowa | 19135 | 603 | 16 |
856394 | 856394 | 2020-12-23 | Monroe | Iowa | 19135 | 599 | 16 |
853149 | 853149 | 2020-12-22 | Monroe | Iowa | 19135 | 588 | 16 |
849904 | 849904 | 2020-12-21 | Monroe | Iowa | 19135 | 570 | 16 |
846659 | 846659 | 2020-12-20 | Monroe | Iowa | 19135 | 558 | 16 |
843413 | 843413 | 2020-12-19 | Monroe | Iowa | 19135 | 557 | 16 |
840168 | 840168 | 2020-12-18 | Monroe | Iowa | 19135 | 548 | 16 |
836923 | 836923 | 2020-12-17 | Monroe | Iowa | 19135 | 533 | 16 |
833677 | 833677 | 2020-12-16 | Monroe | Iowa | 19135 | 527 | 15 |
830430 | 830430 | 2020-12-15 | Monroe | Iowa | 19135 | 516 | 15 |
827184 | 827184 | 2020-12-14 | Monroe | Iowa | 19135 | 513 | 15 |
823937 | 823937 | 2020-12-13 | Monroe | Iowa | 19135 | 504 | 15 |
820691 | 820691 | 2020-12-12 | Monroe | Iowa | 19135 | 497 | 15 |
817445 | 817445 | 2020-12-11 | Monroe | Iowa | 19135 | 493 | 15 |
814199 | 814199 | 2020-12-10 | Monroe | Iowa | 19135 | 483 | 14 |
810954 | 810954 | 2020-12-09 | Monroe | Iowa | 19135 | 478 | 14 |
807709 | 807709 | 2020-12-08 | Monroe | Iowa | 19135 | 475 | 14 |
804464 | 804464 | 2020-12-07 | Monroe | Iowa | 19135 | 475 | 13 |
801219 | 801219 | 2020-12-06 | Monroe | Iowa | 19135 | 474 | 13 |
797974 | 797974 | 2020-12-05 | Monroe | Iowa | 19135 | 473 | 13 |
794729 | 794729 | 2020-12-04 | Monroe | Iowa | 19135 | 469 | 13 |
791484 | 791484 | 2020-12-03 | Monroe | Iowa | 19135 | 451 | 13 |
788239 | 788239 | 2020-12-02 | Monroe | Iowa | 19135 | 451 | 13 |
784995 | 784995 | 2020-12-01 | Monroe | Iowa | 19135 | 450 | 13 |
781750 | 781750 | 2020-11-30 | Monroe | Iowa | 19135 | 447 | 12 |
778504 | 778504 | 2020-11-29 | Monroe | Iowa | 19135 | 444 | 12 |
775259 | 775259 | 2020-11-28 | Monroe | Iowa | 19135 | 443 | 12 |
772014 | 772014 | 2020-11-27 | Monroe | Iowa | 19135 | 439 | 12 |
768769 | 768769 | 2020-11-26 | Monroe | Iowa | 19135 | 437 | 12 |
765523 | 765523 | 2020-11-25 | Monroe | Iowa | 19135 | 437 | 12 |
762278 | 762278 | 2020-11-24 | Monroe | Iowa | 19135 | 431 | 12 |
759033 | 759033 | 2020-11-23 | Monroe | Iowa | 19135 | 429 | 12 |
755786 | 755786 | 2020-11-22 | Monroe | Iowa | 19135 | 428 | 12 |
752540 | 752540 | 2020-11-21 | Monroe | Iowa | 19135 | 416 | 12 |
749294 | 749294 | 2020-11-20 | Monroe | Iowa | 19135 | 404 | 12 |
746048 | 746048 | 2020-11-19 | Monroe | Iowa | 19135 | 397 | 12 |
742801 | 742801 | 2020-11-18 | Monroe | Iowa | 19135 | 392 | 12 |
739554 | 739554 | 2020-11-17 | Monroe | Iowa | 19135 | 384 | 12 |
736310 | 736310 | 2020-11-16 | Monroe | Iowa | 19135 | 378 | 12 |
733064 | 733064 | 2020-11-15 | Monroe | Iowa | 19135 | 374 | 12 |
729819 | 729819 | 2020-11-14 | Monroe | Iowa | 19135 | 367 | 12 |
726576 | 726576 | 2020-11-13 | Monroe | Iowa | 19135 | 357 | 12 |
723333 | 723333 | 2020-11-12 | Monroe | Iowa | 19135 | 350 | 12 |
720090 | 720090 | 2020-11-11 | Monroe | Iowa | 19135 | 342 | 12 |
716847 | 716847 | 2020-11-10 | Monroe | Iowa | 19135 | 334 | 12 |
713603 | 713603 | 2020-11-09 | Monroe | Iowa | 19135 | 322 | 12 |
710359 | 710359 | 2020-11-08 | Monroe | Iowa | 19135 | 323 | 12 |
707115 | 707115 | 2020-11-07 | Monroe | Iowa | 19135 | 313 | 12 |
703872 | 703872 | 2020-11-06 | Monroe | Iowa | 19135 | 305 | 12 |
700630 | 700630 | 2020-11-05 | Monroe | Iowa | 19135 | 293 | 12 |
697386 | 697386 | 2020-11-04 | Monroe | Iowa | 19135 | 289 | 12 |
694144 | 694144 | 2020-11-03 | Monroe | Iowa | 19135 | 282 | 12 |
690901 | 690901 | 2020-11-02 | Monroe | Iowa | 19135 | 280 | 12 |
687656 | 687656 | 2020-11-01 | Monroe | Iowa | 19135 | 280 | 12 |
684412 | 684412 | 2020-10-31 | Monroe | Iowa | 19135 | 278 | 12 |
681169 | 681169 | 2020-10-30 | Monroe | Iowa | 19135 | 275 | 12 |
677926 | 677926 | 2020-10-29 | Monroe | Iowa | 19135 | 272 | 12 |
674683 | 674683 | 2020-10-28 | Monroe | Iowa | 19135 | 266 | 11 |
671441 | 671441 | 2020-10-27 | Monroe | Iowa | 19135 | 262 | 11 |
668198 | 668198 | 2020-10-26 | Monroe | Iowa | 19135 | 259 | 11 |
664954 | 664954 | 2020-10-25 | Monroe | Iowa | 19135 | 259 | 11 |
661709 | 661709 | 2020-10-24 | Monroe | Iowa | 19135 | 258 | 11 |
658465 | 658465 | 2020-10-23 | Monroe | Iowa | 19135 | 258 | 11 |
655220 | 655220 | 2020-10-22 | Monroe | Iowa | 19135 | 252 | 11 |
651975 | 651975 | 2020-10-21 | Monroe | Iowa | 19135 | 249 | 11 |
648731 | 648731 | 2020-10-20 | Monroe | Iowa | 19135 | 245 | 11 |
645486 | 645486 | 2020-10-19 | Monroe | Iowa | 19135 | 238 | 11 |
642239 | 642239 | 2020-10-18 | Monroe | Iowa | 19135 | 237 | 11 |
638992 | 638992 | 2020-10-17 | Monroe | Iowa | 19135 | 236 | 11 |
635746 | 635746 | 2020-10-16 | Monroe | Iowa | 19135 | 232 | 11 |
632500 | 632500 | 2020-10-15 | Monroe | Iowa | 19135 | 226 | 11 |
629256 | 629256 | 2020-10-14 | Monroe | Iowa | 19135 | 224 | 11 |
626013 | 626013 | 2020-10-13 | Monroe | Iowa | 19135 | 211 | 11 |
622771 | 622771 | 2020-10-12 | Monroe | Iowa | 19135 | 194 | 11 |
619527 | 619527 | 2020-10-11 | Monroe | Iowa | 19135 | 198 | 11 |
616285 | 616285 | 2020-10-10 | Monroe | Iowa | 19135 | 198 | 11 |
613044 | 613044 | 2020-10-09 | Monroe | Iowa | 19135 | 191 | 11 |
609802 | 609802 | 2020-10-08 | Monroe | Iowa | 19135 | 179 | 11 |
606559 | 606559 | 2020-10-07 | Monroe | Iowa | 19135 | 173 | 11 |
603317 | 603317 | 2020-10-06 | Monroe | Iowa | 19135 | 171 | 11 |
600074 | 600074 | 2020-10-05 | Monroe | Iowa | 19135 | 172 | 11 |
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);