ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Montgomery" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635747 | 635747 | 2020-10-16 | Montgomery | Iowa | 19137 | 149 | 5 |
632501 | 632501 | 2020-10-15 | Montgomery | Iowa | 19137 | 146 | 5 |
629257 | 629257 | 2020-10-14 | Montgomery | Iowa | 19137 | 139 | 5 |
626014 | 626014 | 2020-10-13 | Montgomery | Iowa | 19137 | 139 | 5 |
622772 | 622772 | 2020-10-12 | Montgomery | Iowa | 19137 | 139 | 5 |
619528 | 619528 | 2020-10-11 | Montgomery | Iowa | 19137 | 133 | 5 |
616286 | 616286 | 2020-10-10 | Montgomery | Iowa | 19137 | 132 | 5 |
613045 | 613045 | 2020-10-09 | Montgomery | Iowa | 19137 | 132 | 5 |
609803 | 609803 | 2020-10-08 | Montgomery | Iowa | 19137 | 119 | 5 |
606560 | 606560 | 2020-10-07 | Montgomery | Iowa | 19137 | 117 | 5 |
603318 | 603318 | 2020-10-06 | Montgomery | Iowa | 19137 | 114 | 5 |
600075 | 600075 | 2020-10-05 | Montgomery | Iowa | 19137 | 112 | 5 |
596833 | 596833 | 2020-10-04 | Montgomery | Iowa | 19137 | 109 | 5 |
593591 | 593591 | 2020-10-03 | Montgomery | Iowa | 19137 | 109 | 5 |
590350 | 590350 | 2020-10-02 | Montgomery | Iowa | 19137 | 107 | 5 |
587109 | 587109 | 2020-10-01 | Montgomery | Iowa | 19137 | 105 | 5 |
583869 | 583869 | 2020-09-30 | Montgomery | Iowa | 19137 | 100 | 5 |
580630 | 580630 | 2020-09-29 | Montgomery | Iowa | 19137 | 99 | 5 |
577389 | 577389 | 2020-09-28 | Montgomery | Iowa | 19137 | 97 | 5 |
574147 | 574147 | 2020-09-27 | Montgomery | Iowa | 19137 | 97 | 5 |
570904 | 570904 | 2020-09-26 | Montgomery | Iowa | 19137 | 96 | 5 |
567662 | 567662 | 2020-09-25 | Montgomery | Iowa | 19137 | 92 | 5 |
564422 | 564422 | 2020-09-24 | Montgomery | Iowa | 19137 | 90 | 5 |
561182 | 561182 | 2020-09-23 | Montgomery | Iowa | 19137 | 90 | 5 |
557946 | 557946 | 2020-09-22 | Montgomery | Iowa | 19137 | 90 | 5 |
554709 | 554709 | 2020-09-21 | Montgomery | Iowa | 19137 | 88 | 5 |
551470 | 551470 | 2020-09-20 | Montgomery | Iowa | 19137 | 86 | 5 |
548231 | 548231 | 2020-09-19 | Montgomery | Iowa | 19137 | 86 | 5 |
544993 | 544993 | 2020-09-18 | Montgomery | Iowa | 19137 | 85 | 5 |
541757 | 541757 | 2020-09-17 | Montgomery | Iowa | 19137 | 84 | 5 |
538520 | 538520 | 2020-09-16 | Montgomery | Iowa | 19137 | 84 | 5 |
535284 | 535284 | 2020-09-15 | Montgomery | Iowa | 19137 | 84 | 5 |
532049 | 532049 | 2020-09-14 | Montgomery | Iowa | 19137 | 83 | 5 |
528812 | 528812 | 2020-09-13 | Montgomery | Iowa | 19137 | 83 | 5 |
525576 | 525576 | 2020-09-12 | Montgomery | Iowa | 19137 | 83 | 5 |
522340 | 522340 | 2020-09-11 | Montgomery | Iowa | 19137 | 83 | 5 |
519103 | 519103 | 2020-09-10 | Montgomery | Iowa | 19137 | 83 | 5 |
515868 | 515868 | 2020-09-09 | Montgomery | Iowa | 19137 | 83 | 5 |
512635 | 512635 | 2020-09-08 | Montgomery | Iowa | 19137 | 83 | 5 |
509402 | 509402 | 2020-09-07 | Montgomery | Iowa | 19137 | 83 | 5 |
506170 | 506170 | 2020-09-06 | Montgomery | Iowa | 19137 | 83 | 5 |
502936 | 502936 | 2020-09-05 | Montgomery | Iowa | 19137 | 83 | 5 |
499702 | 499702 | 2020-09-04 | Montgomery | Iowa | 19137 | 84 | 5 |
496469 | 496469 | 2020-09-03 | Montgomery | Iowa | 19137 | 80 | 5 |
493235 | 493235 | 2020-09-02 | Montgomery | Iowa | 19137 | 82 | 5 |
490002 | 490002 | 2020-09-01 | Montgomery | Iowa | 19137 | 82 | 5 |
486769 | 486769 | 2020-08-31 | Montgomery | Iowa | 19137 | 78 | 5 |
483534 | 483534 | 2020-08-30 | Montgomery | Iowa | 19137 | 76 | 5 |
480300 | 480300 | 2020-08-29 | Montgomery | Iowa | 19137 | 76 | 4 |
477067 | 477067 | 2020-08-28 | Montgomery | Iowa | 19137 | 73 | 4 |
473834 | 473834 | 2020-08-27 | Montgomery | Iowa | 19137 | 70 | 4 |
470602 | 470602 | 2020-08-26 | Montgomery | Iowa | 19137 | 70 | 4 |
467373 | 467373 | 2020-08-25 | Montgomery | Iowa | 19137 | 68 | 4 |
464144 | 464144 | 2020-08-24 | Montgomery | Iowa | 19137 | 68 | 4 |
460915 | 460915 | 2020-08-23 | Montgomery | Iowa | 19137 | 69 | 4 |
457688 | 457688 | 2020-08-22 | Montgomery | Iowa | 19137 | 69 | 4 |
454460 | 454460 | 2020-08-21 | Montgomery | Iowa | 19137 | 68 | 4 |
451232 | 451232 | 2020-08-20 | Montgomery | Iowa | 19137 | 66 | 4 |
448004 | 448004 | 2020-08-19 | Montgomery | Iowa | 19137 | 66 | 4 |
444777 | 444777 | 2020-08-18 | Montgomery | Iowa | 19137 | 65 | 4 |
441551 | 441551 | 2020-08-17 | Montgomery | Iowa | 19137 | 64 | 4 |
438325 | 438325 | 2020-08-16 | Montgomery | Iowa | 19137 | 64 | 4 |
435099 | 435099 | 2020-08-15 | Montgomery | Iowa | 19137 | 64 | 4 |
431874 | 431874 | 2020-08-14 | Montgomery | Iowa | 19137 | 62 | 4 |
428646 | 428646 | 2020-08-13 | Montgomery | Iowa | 19137 | 61 | 4 |
425422 | 425422 | 2020-08-12 | Montgomery | Iowa | 19137 | 60 | 4 |
422201 | 422201 | 2020-08-11 | Montgomery | Iowa | 19137 | 60 | 4 |
418978 | 418978 | 2020-08-10 | Montgomery | Iowa | 19137 | 59 | 4 |
415757 | 415757 | 2020-08-09 | Montgomery | Iowa | 19137 | 59 | 4 |
412537 | 412537 | 2020-08-08 | Montgomery | Iowa | 19137 | 59 | 4 |
409318 | 409318 | 2020-08-07 | Montgomery | Iowa | 19137 | 54 | 4 |
406098 | 406098 | 2020-08-06 | Montgomery | Iowa | 19137 | 53 | 4 |
402880 | 402880 | 2020-08-05 | Montgomery | Iowa | 19137 | 45 | 4 |
399664 | 399664 | 2020-08-04 | Montgomery | Iowa | 19137 | 45 | 3 |
396448 | 396448 | 2020-08-03 | Montgomery | Iowa | 19137 | 43 | 3 |
393232 | 393232 | 2020-08-02 | Montgomery | Iowa | 19137 | 43 | 3 |
390015 | 390015 | 2020-08-01 | Montgomery | Iowa | 19137 | 43 | 3 |
386798 | 386798 | 2020-07-31 | Montgomery | Iowa | 19137 | 42 | 3 |
383580 | 383580 | 2020-07-30 | Montgomery | Iowa | 19137 | 41 | 3 |
380363 | 380363 | 2020-07-29 | Montgomery | Iowa | 19137 | 40 | 2 |
377146 | 377146 | 2020-07-28 | Montgomery | Iowa | 19137 | 40 | 2 |
373931 | 373931 | 2020-07-27 | Montgomery | Iowa | 19137 | 38 | 2 |
370719 | 370719 | 2020-07-26 | Montgomery | Iowa | 19137 | 38 | 2 |
367509 | 367509 | 2020-07-25 | Montgomery | Iowa | 19137 | 31 | 2 |
364302 | 364302 | 2020-07-24 | Montgomery | Iowa | 19137 | 30 | 2 |
361095 | 361095 | 2020-07-23 | Montgomery | Iowa | 19137 | 31 | 2 |
357890 | 357890 | 2020-07-22 | Montgomery | Iowa | 19137 | 25 | 2 |
354688 | 354688 | 2020-07-21 | Montgomery | Iowa | 19137 | 23 | 2 |
351486 | 351486 | 2020-07-20 | Montgomery | Iowa | 19137 | 21 | 2 |
348286 | 348286 | 2020-07-19 | Montgomery | Iowa | 19137 | 19 | 2 |
345085 | 345085 | 2020-07-18 | Montgomery | Iowa | 19137 | 18 | 2 |
341885 | 341885 | 2020-07-17 | Montgomery | Iowa | 19137 | 18 | 2 |
338689 | 338689 | 2020-07-16 | Montgomery | Iowa | 19137 | 18 | 2 |
335493 | 335493 | 2020-07-15 | Montgomery | Iowa | 19137 | 17 | 2 |
332300 | 332300 | 2020-07-14 | Montgomery | Iowa | 19137 | 15 | 2 |
329113 | 329113 | 2020-07-13 | Montgomery | Iowa | 19137 | 15 | 2 |
325927 | 325927 | 2020-07-12 | Montgomery | Iowa | 19137 | 15 | 2 |
322746 | 322746 | 2020-07-11 | Montgomery | Iowa | 19137 | 12 | 2 |
319567 | 319567 | 2020-07-10 | Montgomery | Iowa | 19137 | 11 | 2 |
316394 | 316394 | 2020-07-09 | Montgomery | Iowa | 19137 | 11 | 2 |
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);