ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where deaths = 3, fips = 29035 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
714255 | 714255 | 2020-11-09 | Carter | Missouri | 29035 | 207 | 3 |
711011 | 711011 | 2020-11-08 | Carter | Missouri | 29035 | 206 | 3 |
707767 | 707767 | 2020-11-07 | Carter | Missouri | 29035 | 206 | 3 |
704524 | 704524 | 2020-11-06 | Carter | Missouri | 29035 | 202 | 3 |
701282 | 701282 | 2020-11-05 | Carter | Missouri | 29035 | 201 | 3 |
698038 | 698038 | 2020-11-04 | Carter | Missouri | 29035 | 198 | 3 |
694795 | 694795 | 2020-11-03 | Carter | Missouri | 29035 | 195 | 3 |
691553 | 691553 | 2020-11-02 | Carter | Missouri | 29035 | 194 | 3 |
688308 | 688308 | 2020-11-01 | Carter | Missouri | 29035 | 191 | 3 |
685064 | 685064 | 2020-10-31 | Carter | Missouri | 29035 | 189 | 3 |
681821 | 681821 | 2020-10-30 | Carter | Missouri | 29035 | 188 | 3 |
678577 | 678577 | 2020-10-29 | Carter | Missouri | 29035 | 185 | 3 |
675335 | 675335 | 2020-10-28 | Carter | Missouri | 29035 | 179 | 3 |
672092 | 672092 | 2020-10-27 | Carter | Missouri | 29035 | 176 | 3 |
668850 | 668850 | 2020-10-26 | Carter | Missouri | 29035 | 174 | 3 |
665606 | 665606 | 2020-10-25 | Carter | Missouri | 29035 | 172 | 3 |
662361 | 662361 | 2020-10-24 | Carter | Missouri | 29035 | 168 | 3 |
659117 | 659117 | 2020-10-23 | Carter | Missouri | 29035 | 166 | 3 |
655872 | 655872 | 2020-10-22 | Carter | Missouri | 29035 | 164 | 3 |
652627 | 652627 | 2020-10-21 | Carter | Missouri | 29035 | 157 | 3 |
649382 | 649382 | 2020-10-20 | Carter | Missouri | 29035 | 153 | 3 |
646138 | 646138 | 2020-10-19 | Carter | Missouri | 29035 | 153 | 3 |
642892 | 642892 | 2020-10-18 | Carter | Missouri | 29035 | 153 | 3 |
639644 | 639644 | 2020-10-17 | Carter | Missouri | 29035 | 149 | 3 |
636398 | 636398 | 2020-10-16 | Carter | Missouri | 29035 | 144 | 3 |
633152 | 633152 | 2020-10-15 | Carter | Missouri | 29035 | 143 | 3 |
629907 | 629907 | 2020-10-14 | Carter | Missouri | 29035 | 141 | 3 |
626663 | 626663 | 2020-10-13 | Carter | Missouri | 29035 | 137 | 3 |
623421 | 623421 | 2020-10-12 | Carter | Missouri | 29035 | 137 | 3 |
620178 | 620178 | 2020-10-11 | Carter | Missouri | 29035 | 137 | 3 |
616936 | 616936 | 2020-10-10 | Carter | Missouri | 29035 | 137 | 3 |
613695 | 613695 | 2020-10-09 | Carter | Missouri | 29035 | 113 | 3 |
610453 | 610453 | 2020-10-08 | Carter | Missouri | 29035 | 112 | 3 |
607211 | 607211 | 2020-10-07 | Carter | Missouri | 29035 | 112 | 3 |
603968 | 603968 | 2020-10-06 | Carter | Missouri | 29035 | 112 | 3 |
600726 | 600726 | 2020-10-05 | Carter | Missouri | 29035 | 110 | 3 |
597483 | 597483 | 2020-10-04 | Carter | Missouri | 29035 | 110 | 3 |
594242 | 594242 | 2020-10-03 | Carter | Missouri | 29035 | 107 | 3 |
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);