ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
741 rows where county = "Monroe" and fips = 19135 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
422200 | 422200 | 2020-08-11 | Monroe | Iowa | 19135 | 74 | 8 |
425421 | 425421 | 2020-08-12 | Monroe | Iowa | 19135 | 74 | 8 |
428645 | 428645 | 2020-08-13 | Monroe | Iowa | 19135 | 75 | 8 |
431873 | 431873 | 2020-08-14 | Monroe | Iowa | 19135 | 75 | 8 |
435098 | 435098 | 2020-08-15 | Monroe | Iowa | 19135 | 77 | 8 |
438324 | 438324 | 2020-08-16 | Monroe | Iowa | 19135 | 78 | 8 |
441550 | 441550 | 2020-08-17 | Monroe | Iowa | 19135 | 79 | 8 |
444776 | 444776 | 2020-08-18 | Monroe | Iowa | 19135 | 81 | 8 |
448003 | 448003 | 2020-08-19 | Monroe | Iowa | 19135 | 82 | 8 |
451231 | 451231 | 2020-08-20 | Monroe | Iowa | 19135 | 87 | 8 |
454459 | 454459 | 2020-08-21 | Monroe | Iowa | 19135 | 89 | 8 |
457687 | 457687 | 2020-08-22 | Monroe | Iowa | 19135 | 91 | 8 |
460914 | 460914 | 2020-08-23 | Monroe | Iowa | 19135 | 92 | 8 |
464143 | 464143 | 2020-08-24 | Monroe | Iowa | 19135 | 93 | 8 |
467372 | 467372 | 2020-08-25 | Monroe | Iowa | 19135 | 93 | 8 |
470601 | 470601 | 2020-08-26 | Monroe | Iowa | 19135 | 93 | 8 |
473833 | 473833 | 2020-08-27 | Monroe | Iowa | 19135 | 96 | 8 |
477066 | 477066 | 2020-08-28 | Monroe | Iowa | 19135 | 102 | 8 |
480299 | 480299 | 2020-08-29 | Monroe | Iowa | 19135 | 102 | 8 |
483533 | 483533 | 2020-08-30 | Monroe | Iowa | 19135 | 107 | 8 |
486768 | 486768 | 2020-08-31 | Monroe | Iowa | 19135 | 110 | 8 |
490001 | 490001 | 2020-09-01 | Monroe | Iowa | 19135 | 112 | 8 |
493234 | 493234 | 2020-09-02 | Monroe | Iowa | 19135 | 114 | 8 |
496468 | 496468 | 2020-09-03 | Monroe | Iowa | 19135 | 118 | 8 |
499701 | 499701 | 2020-09-04 | Monroe | Iowa | 19135 | 119 | 8 |
502935 | 502935 | 2020-09-05 | Monroe | Iowa | 19135 | 121 | 8 |
506169 | 506169 | 2020-09-06 | Monroe | Iowa | 19135 | 121 | 8 |
509401 | 509401 | 2020-09-07 | Monroe | Iowa | 19135 | 122 | 8 |
512634 | 512634 | 2020-09-08 | Monroe | Iowa | 19135 | 123 | 8 |
515867 | 515867 | 2020-09-09 | Monroe | Iowa | 19135 | 124 | 8 |
519102 | 519102 | 2020-09-10 | Monroe | Iowa | 19135 | 125 | 8 |
522339 | 522339 | 2020-09-11 | Monroe | Iowa | 19135 | 130 | 8 |
525575 | 525575 | 2020-09-12 | Monroe | Iowa | 19135 | 132 | 8 |
528811 | 528811 | 2020-09-13 | Monroe | Iowa | 19135 | 132 | 8 |
532048 | 532048 | 2020-09-14 | Monroe | Iowa | 19135 | 132 | 8 |
535283 | 535283 | 2020-09-15 | Monroe | Iowa | 19135 | 133 | 8 |
538519 | 538519 | 2020-09-16 | Monroe | Iowa | 19135 | 140 | 9 |
541756 | 541756 | 2020-09-17 | Monroe | Iowa | 19135 | 141 | 10 |
544992 | 544992 | 2020-09-18 | Monroe | Iowa | 19135 | 144 | 10 |
548230 | 548230 | 2020-09-19 | Monroe | Iowa | 19135 | 146 | 10 |
551469 | 551469 | 2020-09-20 | Monroe | Iowa | 19135 | 148 | 10 |
554708 | 554708 | 2020-09-21 | Monroe | Iowa | 19135 | 150 | 10 |
557945 | 557945 | 2020-09-22 | Monroe | Iowa | 19135 | 151 | 10 |
561181 | 561181 | 2020-09-23 | Monroe | Iowa | 19135 | 153 | 10 |
564421 | 564421 | 2020-09-24 | Monroe | Iowa | 19135 | 157 | 10 |
567661 | 567661 | 2020-09-25 | Monroe | Iowa | 19135 | 157 | 10 |
570903 | 570903 | 2020-09-26 | Monroe | Iowa | 19135 | 159 | 11 |
574146 | 574146 | 2020-09-27 | Monroe | Iowa | 19135 | 159 | 11 |
577388 | 577388 | 2020-09-28 | Monroe | Iowa | 19135 | 160 | 11 |
580629 | 580629 | 2020-09-29 | Monroe | Iowa | 19135 | 162 | 11 |
583868 | 583868 | 2020-09-30 | Monroe | Iowa | 19135 | 163 | 11 |
587108 | 587108 | 2020-10-01 | Monroe | Iowa | 19135 | 164 | 11 |
590349 | 590349 | 2020-10-02 | Monroe | Iowa | 19135 | 164 | 11 |
593590 | 593590 | 2020-10-03 | Monroe | Iowa | 19135 | 164 | 11 |
596832 | 596832 | 2020-10-04 | Monroe | Iowa | 19135 | 165 | 11 |
600074 | 600074 | 2020-10-05 | Monroe | Iowa | 19135 | 172 | 11 |
603317 | 603317 | 2020-10-06 | Monroe | Iowa | 19135 | 171 | 11 |
606559 | 606559 | 2020-10-07 | Monroe | Iowa | 19135 | 173 | 11 |
609802 | 609802 | 2020-10-08 | Monroe | Iowa | 19135 | 179 | 11 |
613044 | 613044 | 2020-10-09 | Monroe | Iowa | 19135 | 191 | 11 |
616285 | 616285 | 2020-10-10 | Monroe | Iowa | 19135 | 198 | 11 |
619527 | 619527 | 2020-10-11 | Monroe | Iowa | 19135 | 198 | 11 |
622771 | 622771 | 2020-10-12 | Monroe | Iowa | 19135 | 194 | 11 |
626013 | 626013 | 2020-10-13 | Monroe | Iowa | 19135 | 211 | 11 |
629256 | 629256 | 2020-10-14 | Monroe | Iowa | 19135 | 224 | 11 |
632500 | 632500 | 2020-10-15 | Monroe | Iowa | 19135 | 226 | 11 |
635746 | 635746 | 2020-10-16 | Monroe | Iowa | 19135 | 232 | 11 |
638992 | 638992 | 2020-10-17 | Monroe | Iowa | 19135 | 236 | 11 |
642239 | 642239 | 2020-10-18 | Monroe | Iowa | 19135 | 237 | 11 |
645486 | 645486 | 2020-10-19 | Monroe | Iowa | 19135 | 238 | 11 |
648731 | 648731 | 2020-10-20 | Monroe | Iowa | 19135 | 245 | 11 |
651975 | 651975 | 2020-10-21 | Monroe | Iowa | 19135 | 249 | 11 |
655220 | 655220 | 2020-10-22 | Monroe | Iowa | 19135 | 252 | 11 |
658465 | 658465 | 2020-10-23 | Monroe | Iowa | 19135 | 258 | 11 |
661709 | 661709 | 2020-10-24 | Monroe | Iowa | 19135 | 258 | 11 |
664954 | 664954 | 2020-10-25 | Monroe | Iowa | 19135 | 259 | 11 |
668198 | 668198 | 2020-10-26 | Monroe | Iowa | 19135 | 259 | 11 |
671441 | 671441 | 2020-10-27 | Monroe | Iowa | 19135 | 262 | 11 |
674683 | 674683 | 2020-10-28 | Monroe | Iowa | 19135 | 266 | 11 |
677926 | 677926 | 2020-10-29 | Monroe | Iowa | 19135 | 272 | 12 |
681169 | 681169 | 2020-10-30 | Monroe | Iowa | 19135 | 275 | 12 |
684412 | 684412 | 2020-10-31 | Monroe | Iowa | 19135 | 278 | 12 |
687656 | 687656 | 2020-11-01 | Monroe | Iowa | 19135 | 280 | 12 |
690901 | 690901 | 2020-11-02 | Monroe | Iowa | 19135 | 280 | 12 |
694144 | 694144 | 2020-11-03 | Monroe | Iowa | 19135 | 282 | 12 |
697386 | 697386 | 2020-11-04 | Monroe | Iowa | 19135 | 289 | 12 |
700630 | 700630 | 2020-11-05 | Monroe | Iowa | 19135 | 293 | 12 |
703872 | 703872 | 2020-11-06 | Monroe | Iowa | 19135 | 305 | 12 |
707115 | 707115 | 2020-11-07 | Monroe | Iowa | 19135 | 313 | 12 |
710359 | 710359 | 2020-11-08 | Monroe | Iowa | 19135 | 323 | 12 |
713603 | 713603 | 2020-11-09 | Monroe | Iowa | 19135 | 322 | 12 |
716847 | 716847 | 2020-11-10 | Monroe | Iowa | 19135 | 334 | 12 |
720090 | 720090 | 2020-11-11 | Monroe | Iowa | 19135 | 342 | 12 |
723333 | 723333 | 2020-11-12 | Monroe | Iowa | 19135 | 350 | 12 |
726576 | 726576 | 2020-11-13 | Monroe | Iowa | 19135 | 357 | 12 |
729819 | 729819 | 2020-11-14 | Monroe | Iowa | 19135 | 367 | 12 |
733064 | 733064 | 2020-11-15 | Monroe | Iowa | 19135 | 374 | 12 |
736310 | 736310 | 2020-11-16 | Monroe | Iowa | 19135 | 378 | 12 |
739554 | 739554 | 2020-11-17 | Monroe | Iowa | 19135 | 384 | 12 |
742801 | 742801 | 2020-11-18 | Monroe | Iowa | 19135 | 392 | 12 |
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);