ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where county = "Green" and deaths = 10 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
868440 | 868440 | 2020-12-26 | Green | Wisconsin | 55045 | 2309 | 10 |
865195 | 865195 | 2020-12-25 | Green | Wisconsin | 55045 | 2296 | 10 |
861950 | 861950 | 2020-12-24 | Green | Wisconsin | 55045 | 2268 | 10 |
858705 | 858705 | 2020-12-23 | Green | Wisconsin | 55045 | 2245 | 10 |
855460 | 855460 | 2020-12-22 | Green | Wisconsin | 55045 | 2213 | 10 |
852215 | 852215 | 2020-12-21 | Green | Wisconsin | 55045 | 2206 | 10 |
848970 | 848970 | 2020-12-20 | Green | Wisconsin | 55045 | 2202 | 10 |
829496 | 829496 | 2020-12-14 | Green | Wisconsin | 55045 | 2067 | 10 |
824119 | 824119 | 2020-12-13 | Green | Kentucky | 21087 | 696 | 10 |
820873 | 820873 | 2020-12-12 | Green | Kentucky | 21087 | 687 | 10 |
817627 | 817627 | 2020-12-11 | Green | Kentucky | 21087 | 680 | 10 |
814381 | 814381 | 2020-12-10 | Green | Kentucky | 21087 | 669 | 10 |
811136 | 811136 | 2020-12-09 | Green | Kentucky | 21087 | 660 | 10 |
807891 | 807891 | 2020-12-08 | Green | Kentucky | 21087 | 656 | 10 |
804646 | 804646 | 2020-12-07 | Green | Kentucky | 21087 | 648 | 10 |
801401 | 801401 | 2020-12-06 | Green | Kentucky | 21087 | 642 | 10 |
798156 | 798156 | 2020-12-05 | Green | Kentucky | 21087 | 639 | 10 |
794911 | 794911 | 2020-12-04 | Green | Kentucky | 21087 | 628 | 10 |
791666 | 791666 | 2020-12-03 | Green | Kentucky | 21087 | 620 | 10 |
788421 | 788421 | 2020-12-02 | Green | Kentucky | 21087 | 611 | 10 |
785177 | 785177 | 2020-12-01 | Green | Kentucky | 21087 | 594 | 10 |
781932 | 781932 | 2020-11-30 | Green | Kentucky | 21087 | 583 | 10 |
778686 | 778686 | 2020-11-29 | Green | Kentucky | 21087 | 574 | 10 |
775441 | 775441 | 2020-11-28 | Green | Kentucky | 21087 | 571 | 10 |
772196 | 772196 | 2020-11-27 | Green | Kentucky | 21087 | 571 | 10 |
768951 | 768951 | 2020-11-26 | Green | Kentucky | 21087 | 565 | 10 |
765705 | 765705 | 2020-11-25 | Green | Kentucky | 21087 | 565 | 10 |
762460 | 762460 | 2020-11-24 | Green | Kentucky | 21087 | 560 | 10 |
759215 | 759215 | 2020-11-23 | Green | Kentucky | 21087 | 549 | 10 |
755968 | 755968 | 2020-11-22 | Green | Kentucky | 21087 | 545 | 10 |
752722 | 752722 | 2020-11-21 | Green | Kentucky | 21087 | 543 | 10 |
749476 | 749476 | 2020-11-20 | Green | Kentucky | 21087 | 538 | 10 |
746230 | 746230 | 2020-11-19 | Green | Kentucky | 21087 | 528 | 10 |
742983 | 742983 | 2020-11-18 | Green | Kentucky | 21087 | 511 | 10 |
739736 | 739736 | 2020-11-17 | Green | Kentucky | 21087 | 503 | 10 |
736492 | 736492 | 2020-11-16 | Green | Kentucky | 21087 | 491 | 10 |
733246 | 733246 | 2020-11-15 | Green | Kentucky | 21087 | 473 | 10 |
730001 | 730001 | 2020-11-14 | Green | Kentucky | 21087 | 465 | 10 |
726758 | 726758 | 2020-11-13 | Green | Kentucky | 21087 | 452 | 10 |
723515 | 723515 | 2020-11-12 | Green | Kentucky | 21087 | 441 | 10 |
720272 | 720272 | 2020-11-11 | Green | Kentucky | 21087 | 440 | 10 |
717029 | 717029 | 2020-11-10 | Green | Kentucky | 21087 | 426 | 10 |
713785 | 713785 | 2020-11-09 | Green | Kentucky | 21087 | 420 | 10 |
710541 | 710541 | 2020-11-08 | Green | Kentucky | 21087 | 416 | 10 |
707297 | 707297 | 2020-11-07 | Green | Kentucky | 21087 | 408 | 10 |
704054 | 704054 | 2020-11-06 | Green | Kentucky | 21087 | 397 | 10 |
700812 | 700812 | 2020-11-05 | Green | Kentucky | 21087 | 390 | 10 |
697568 | 697568 | 2020-11-04 | Green | Kentucky | 21087 | 383 | 10 |
694325 | 694325 | 2020-11-03 | Green | Kentucky | 21087 | 377 | 10 |
691083 | 691083 | 2020-11-02 | Green | Kentucky | 21087 | 371 | 10 |
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);