ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where county = "Maries", deaths = 6 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 |
---|---|---|---|---|---|---|---|
896036 | 896036 | 2021-01-04 | Maries | Missouri | 29125 | 474 | 6 |
892789 | 892789 | 2021-01-03 | Maries | Missouri | 29125 | 474 | 6 |
889543 | 889543 | 2021-01-02 | Maries | Missouri | 29125 | 470 | 6 |
886297 | 886297 | 2021-01-01 | Maries | Missouri | 29125 | 469 | 6 |
883052 | 883052 | 2020-12-31 | Maries | Missouri | 29125 | 463 | 6 |
879807 | 879807 | 2020-12-30 | Maries | Missouri | 29125 | 455 | 6 |
876562 | 876562 | 2020-12-29 | Maries | Missouri | 29125 | 453 | 6 |
873317 | 873317 | 2020-12-28 | Maries | Missouri | 29125 | 453 | 6 |
870072 | 870072 | 2020-12-27 | Maries | Missouri | 29125 | 452 | 6 |
866827 | 866827 | 2020-12-26 | Maries | Missouri | 29125 | 451 | 6 |
863582 | 863582 | 2020-12-25 | Maries | Missouri | 29125 | 450 | 6 |
860337 | 860337 | 2020-12-24 | Maries | Missouri | 29125 | 446 | 6 |
857092 | 857092 | 2020-12-23 | Maries | Missouri | 29125 | 439 | 6 |
853847 | 853847 | 2020-12-22 | Maries | Missouri | 29125 | 438 | 6 |
850602 | 850602 | 2020-12-21 | Maries | Missouri | 29125 | 436 | 6 |
847357 | 847357 | 2020-12-20 | Maries | Missouri | 29125 | 433 | 6 |
844111 | 844111 | 2020-12-19 | Maries | Missouri | 29125 | 432 | 6 |
840866 | 840866 | 2020-12-18 | Maries | Missouri | 29125 | 429 | 6 |
837621 | 837621 | 2020-12-17 | Maries | Missouri | 29125 | 424 | 6 |
834375 | 834375 | 2020-12-16 | Maries | Missouri | 29125 | 421 | 6 |
831128 | 831128 | 2020-12-15 | Maries | Missouri | 29125 | 417 | 6 |
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);