ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where county = "Flathead", deaths = 0 and fips = 30029 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 |
---|---|---|---|---|---|---|---|
52512 | 52512 | 2020-04-12 | Flathead | Montana | 30029 | 34 | 0 |
49839 | 49839 | 2020-04-11 | Flathead | Montana | 30029 | 34 | 0 |
47191 | 47191 | 2020-04-10 | Flathead | Montana | 30029 | 34 | 0 |
44581 | 44581 | 2020-04-09 | Flathead | Montana | 30029 | 34 | 0 |
42002 | 42002 | 2020-04-08 | Flathead | Montana | 30029 | 31 | 0 |
39447 | 39447 | 2020-04-07 | Flathead | Montana | 30029 | 31 | 0 |
36931 | 36931 | 2020-04-06 | Flathead | Montana | 30029 | 31 | 0 |
34464 | 34464 | 2020-04-05 | Flathead | Montana | 30029 | 25 | 0 |
32036 | 32036 | 2020-04-04 | Flathead | Montana | 30029 | 23 | 0 |
29654 | 29654 | 2020-04-03 | Flathead | Montana | 30029 | 20 | 0 |
27332 | 27332 | 2020-04-02 | Flathead | Montana | 30029 | 18 | 0 |
25075 | 25075 | 2020-04-01 | Flathead | Montana | 30029 | 17 | 0 |
22886 | 22886 | 2020-03-31 | Flathead | Montana | 30029 | 11 | 0 |
20766 | 20766 | 2020-03-30 | Flathead | Montana | 30029 | 9 | 0 |
18731 | 18731 | 2020-03-29 | Flathead | Montana | 30029 | 8 | 0 |
16808 | 16808 | 2020-03-28 | Flathead | Montana | 30029 | 6 | 0 |
14982 | 14982 | 2020-03-27 | Flathead | Montana | 30029 | 6 | 0 |
13252 | 13252 | 2020-03-26 | Flathead | Montana | 30029 | 5 | 0 |
11654 | 11654 | 2020-03-25 | Flathead | Montana | 30029 | 5 | 0 |
10225 | 10225 | 2020-03-24 | Flathead | Montana | 30029 | 4 | 0 |
8923 | 8923 | 2020-03-23 | Flathead | Montana | 30029 | 4 | 0 |
7730 | 7730 | 2020-03-22 | Flathead | Montana | 30029 | 2 | 0 |
6641 | 6641 | 2020-03-21 | Flathead | Montana | 30029 | 2 | 0 |
5650 | 5650 | 2020-03-20 | Flathead | Montana | 30029 | 1 | 0 |
4811 | 4811 | 2020-03-19 | Flathead | Montana | 30029 | 1 | 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);