ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where deaths = 2 and fips = 53025 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 |
---|---|---|---|---|---|---|---|
154061 | 154061 | 2020-05-17 | Grant | Washington | 53025 | 223 | 2 |
151050 | 151050 | 2020-05-16 | Grant | Washington | 53025 | 223 | 2 |
148041 | 148041 | 2020-05-15 | Grant | Washington | 53025 | 223 | 2 |
145038 | 145038 | 2020-05-14 | Grant | Washington | 53025 | 224 | 2 |
142041 | 142041 | 2020-05-13 | Grant | Washington | 53025 | 221 | 2 |
139045 | 139045 | 2020-05-12 | Grant | Washington | 53025 | 221 | 2 |
136054 | 136054 | 2020-05-11 | Grant | Washington | 53025 | 219 | 2 |
133064 | 133064 | 2020-05-10 | Grant | Washington | 53025 | 219 | 2 |
130074 | 130074 | 2020-05-09 | Grant | Washington | 53025 | 219 | 2 |
127084 | 127084 | 2020-05-08 | Grant | Washington | 53025 | 219 | 2 |
124099 | 124099 | 2020-05-07 | Grant | Washington | 53025 | 183 | 2 |
121119 | 121119 | 2020-05-06 | Grant | Washington | 53025 | 181 | 2 |
118155 | 118155 | 2020-05-05 | Grant | Washington | 53025 | 181 | 2 |
115196 | 115196 | 2020-05-04 | Grant | Washington | 53025 | 179 | 2 |
112313 | 112313 | 2020-05-03 | Grant | Washington | 53025 | 174 | 2 |
109439 | 109439 | 2020-05-02 | Grant | Washington | 53025 | 174 | 2 |
106570 | 106570 | 2020-05-01 | Grant | Washington | 53025 | 170 | 2 |
103706 | 103706 | 2020-04-30 | Grant | Washington | 53025 | 166 | 2 |
100851 | 100851 | 2020-04-29 | Grant | Washington | 53025 | 160 | 2 |
98001 | 98001 | 2020-04-28 | Grant | Washington | 53025 | 157 | 2 |
95156 | 95156 | 2020-04-27 | Grant | Washington | 53025 | 157 | 2 |
92327 | 92327 | 2020-04-26 | Grant | Washington | 53025 | 157 | 2 |
89510 | 89510 | 2020-04-25 | Grant | Washington | 53025 | 156 | 2 |
86695 | 86695 | 2020-04-24 | Grant | Washington | 53025 | 154 | 2 |
83888 | 83888 | 2020-04-23 | Grant | Washington | 53025 | 154 | 2 |
61722 | 61722 | 2020-04-15 | Grant | Washington | 53025 | 129 | 2 |
59003 | 59003 | 2020-04-14 | Grant | Washington | 53025 | 121 | 2 |
56297 | 56297 | 2020-04-13 | Grant | Washington | 53025 | 121 | 2 |
53607 | 53607 | 2020-04-12 | Grant | Washington | 53025 | 119 | 2 |
50932 | 50932 | 2020-04-11 | Grant | Washington | 53025 | 111 | 2 |
48274 | 48274 | 2020-04-10 | Grant | Washington | 53025 | 101 | 2 |
45647 | 45647 | 2020-04-09 | Grant | Washington | 53025 | 101 | 2 |
43051 | 43051 | 2020-04-08 | Grant | Washington | 53025 | 95 | 2 |
40482 | 40482 | 2020-04-07 | Grant | Washington | 53025 | 93 | 2 |
37947 | 37947 | 2020-04-06 | Grant | Washington | 53025 | 90 | 2 |
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);