ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Greene" and fips = 19073 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
338657 | 338657 | 2020-07-16 | Greene | Iowa | 19073 | 32 | 0 |
341853 | 341853 | 2020-07-17 | Greene | Iowa | 19073 | 34 | 0 |
345053 | 345053 | 2020-07-18 | Greene | Iowa | 19073 | 35 | 0 |
348254 | 348254 | 2020-07-19 | Greene | Iowa | 19073 | 37 | 0 |
351454 | 351454 | 2020-07-20 | Greene | Iowa | 19073 | 37 | 0 |
354656 | 354656 | 2020-07-21 | Greene | Iowa | 19073 | 37 | 0 |
357858 | 357858 | 2020-07-22 | Greene | Iowa | 19073 | 37 | 0 |
361063 | 361063 | 2020-07-23 | Greene | Iowa | 19073 | 37 | 0 |
364270 | 364270 | 2020-07-24 | Greene | Iowa | 19073 | 37 | 0 |
367477 | 367477 | 2020-07-25 | Greene | Iowa | 19073 | 37 | 0 |
370687 | 370687 | 2020-07-26 | Greene | Iowa | 19073 | 37 | 0 |
373899 | 373899 | 2020-07-27 | Greene | Iowa | 19073 | 37 | 0 |
377114 | 377114 | 2020-07-28 | Greene | Iowa | 19073 | 37 | 0 |
380331 | 380331 | 2020-07-29 | Greene | Iowa | 19073 | 37 | 0 |
383548 | 383548 | 2020-07-30 | Greene | Iowa | 19073 | 37 | 0 |
386766 | 386766 | 2020-07-31 | Greene | Iowa | 19073 | 38 | 0 |
389983 | 389983 | 2020-08-01 | Greene | Iowa | 19073 | 38 | 0 |
393200 | 393200 | 2020-08-02 | Greene | Iowa | 19073 | 38 | 0 |
396416 | 396416 | 2020-08-03 | Greene | Iowa | 19073 | 38 | 0 |
399632 | 399632 | 2020-08-04 | Greene | Iowa | 19073 | 38 | 0 |
402848 | 402848 | 2020-08-05 | Greene | Iowa | 19073 | 38 | 0 |
406066 | 406066 | 2020-08-06 | Greene | Iowa | 19073 | 39 | 0 |
409286 | 409286 | 2020-08-07 | Greene | Iowa | 19073 | 40 | 0 |
412505 | 412505 | 2020-08-08 | Greene | Iowa | 19073 | 41 | 0 |
415725 | 415725 | 2020-08-09 | Greene | Iowa | 19073 | 41 | 0 |
418946 | 418946 | 2020-08-10 | Greene | Iowa | 19073 | 42 | 0 |
422169 | 422169 | 2020-08-11 | Greene | Iowa | 19073 | 43 | 0 |
425390 | 425390 | 2020-08-12 | Greene | Iowa | 19073 | 42 | 0 |
428614 | 428614 | 2020-08-13 | Greene | Iowa | 19073 | 42 | 0 |
431842 | 431842 | 2020-08-14 | Greene | Iowa | 19073 | 42 | 0 |
435067 | 435067 | 2020-08-15 | Greene | Iowa | 19073 | 42 | 0 |
438293 | 438293 | 2020-08-16 | Greene | Iowa | 19073 | 42 | 0 |
441519 | 441519 | 2020-08-17 | Greene | Iowa | 19073 | 42 | 0 |
444745 | 444745 | 2020-08-18 | Greene | Iowa | 19073 | 42 | 0 |
447972 | 447972 | 2020-08-19 | Greene | Iowa | 19073 | 43 | 0 |
451200 | 451200 | 2020-08-20 | Greene | Iowa | 19073 | 43 | 0 |
454428 | 454428 | 2020-08-21 | Greene | Iowa | 19073 | 45 | 0 |
457656 | 457656 | 2020-08-22 | Greene | Iowa | 19073 | 46 | 0 |
460883 | 460883 | 2020-08-23 | Greene | Iowa | 19073 | 45 | 0 |
464112 | 464112 | 2020-08-24 | Greene | Iowa | 19073 | 47 | 0 |
467341 | 467341 | 2020-08-25 | Greene | Iowa | 19073 | 49 | 0 |
470570 | 470570 | 2020-08-26 | Greene | Iowa | 19073 | 52 | 0 |
473802 | 473802 | 2020-08-27 | Greene | Iowa | 19073 | 54 | 0 |
477035 | 477035 | 2020-08-28 | Greene | Iowa | 19073 | 53 | 0 |
480268 | 480268 | 2020-08-29 | Greene | Iowa | 19073 | 54 | 0 |
483502 | 483502 | 2020-08-30 | Greene | Iowa | 19073 | 54 | 0 |
486737 | 486737 | 2020-08-31 | Greene | Iowa | 19073 | 53 | 0 |
489970 | 489970 | 2020-09-01 | Greene | Iowa | 19073 | 58 | 0 |
493203 | 493203 | 2020-09-02 | Greene | Iowa | 19073 | 58 | 0 |
496437 | 496437 | 2020-09-03 | Greene | Iowa | 19073 | 60 | 0 |
499670 | 499670 | 2020-09-04 | Greene | Iowa | 19073 | 62 | 0 |
502904 | 502904 | 2020-09-05 | Greene | Iowa | 19073 | 64 | 0 |
506138 | 506138 | 2020-09-06 | Greene | Iowa | 19073 | 67 | 0 |
509370 | 509370 | 2020-09-07 | Greene | Iowa | 19073 | 67 | 0 |
512603 | 512603 | 2020-09-08 | Greene | Iowa | 19073 | 67 | 0 |
515836 | 515836 | 2020-09-09 | Greene | Iowa | 19073 | 67 | 0 |
519071 | 519071 | 2020-09-10 | Greene | Iowa | 19073 | 69 | 0 |
522308 | 522308 | 2020-09-11 | Greene | Iowa | 19073 | 69 | 0 |
525544 | 525544 | 2020-09-12 | Greene | Iowa | 19073 | 70 | 0 |
528780 | 528780 | 2020-09-13 | Greene | Iowa | 19073 | 71 | 0 |
532017 | 532017 | 2020-09-14 | Greene | Iowa | 19073 | 72 | 0 |
535252 | 535252 | 2020-09-15 | Greene | Iowa | 19073 | 72 | 0 |
538488 | 538488 | 2020-09-16 | Greene | Iowa | 19073 | 77 | 0 |
541725 | 541725 | 2020-09-17 | Greene | Iowa | 19073 | 80 | 0 |
544961 | 544961 | 2020-09-18 | Greene | Iowa | 19073 | 82 | 0 |
548199 | 548199 | 2020-09-19 | Greene | Iowa | 19073 | 84 | 0 |
551438 | 551438 | 2020-09-20 | Greene | Iowa | 19073 | 87 | 0 |
554677 | 554677 | 2020-09-21 | Greene | Iowa | 19073 | 89 | 0 |
557914 | 557914 | 2020-09-22 | Greene | Iowa | 19073 | 94 | 0 |
561150 | 561150 | 2020-09-23 | Greene | Iowa | 19073 | 99 | 0 |
564390 | 564390 | 2020-09-24 | Greene | Iowa | 19073 | 99 | 0 |
567630 | 567630 | 2020-09-25 | Greene | Iowa | 19073 | 100 | 0 |
570872 | 570872 | 2020-09-26 | Greene | Iowa | 19073 | 101 | 0 |
574115 | 574115 | 2020-09-27 | Greene | Iowa | 19073 | 101 | 0 |
577357 | 577357 | 2020-09-28 | Greene | Iowa | 19073 | 103 | 0 |
580598 | 580598 | 2020-09-29 | Greene | Iowa | 19073 | 105 | 0 |
583837 | 583837 | 2020-09-30 | Greene | Iowa | 19073 | 109 | 0 |
587077 | 587077 | 2020-10-01 | Greene | Iowa | 19073 | 115 | 0 |
590318 | 590318 | 2020-10-02 | Greene | Iowa | 19073 | 125 | 0 |
593559 | 593559 | 2020-10-03 | Greene | Iowa | 19073 | 126 | 0 |
596801 | 596801 | 2020-10-04 | Greene | Iowa | 19073 | 126 | 0 |
600043 | 600043 | 2020-10-05 | Greene | Iowa | 19073 | 132 | 0 |
603286 | 603286 | 2020-10-06 | Greene | Iowa | 19073 | 136 | 0 |
606528 | 606528 | 2020-10-07 | Greene | Iowa | 19073 | 141 | 0 |
609771 | 609771 | 2020-10-08 | Greene | Iowa | 19073 | 145 | 0 |
613013 | 613013 | 2020-10-09 | Greene | Iowa | 19073 | 148 | 0 |
616254 | 616254 | 2020-10-10 | Greene | Iowa | 19073 | 151 | 0 |
619496 | 619496 | 2020-10-11 | Greene | Iowa | 19073 | 151 | 0 |
622740 | 622740 | 2020-10-12 | Greene | Iowa | 19073 | 152 | 0 |
625982 | 625982 | 2020-10-13 | Greene | Iowa | 19073 | 155 | 0 |
629225 | 629225 | 2020-10-14 | Greene | Iowa | 19073 | 157 | 0 |
632469 | 632469 | 2020-10-15 | Greene | Iowa | 19073 | 158 | 0 |
635715 | 635715 | 2020-10-16 | Greene | Iowa | 19073 | 168 | 0 |
638961 | 638961 | 2020-10-17 | Greene | Iowa | 19073 | 170 | 0 |
642208 | 642208 | 2020-10-18 | Greene | Iowa | 19073 | 171 | 0 |
645455 | 645455 | 2020-10-19 | Greene | Iowa | 19073 | 173 | 0 |
648700 | 648700 | 2020-10-20 | Greene | Iowa | 19073 | 174 | 0 |
651944 | 651944 | 2020-10-21 | Greene | Iowa | 19073 | 180 | 0 |
655189 | 655189 | 2020-10-22 | Greene | Iowa | 19073 | 182 | 0 |
658434 | 658434 | 2020-10-23 | Greene | Iowa | 19073 | 183 | 0 |
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);