ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
111 rows where county = "Wilkes" and deaths = 1 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 |
---|---|---|---|---|---|---|---|
325615 | 325615 | 2020-07-12 | Wilkes | Georgia | 13317 | 109 | 1 |
322434 | 322434 | 2020-07-11 | Wilkes | Georgia | 13317 | 98 | 1 |
319255 | 319255 | 2020-07-10 | Wilkes | Georgia | 13317 | 88 | 1 |
316082 | 316082 | 2020-07-09 | Wilkes | Georgia | 13317 | 87 | 1 |
312907 | 312907 | 2020-07-08 | Wilkes | Georgia | 13317 | 87 | 1 |
309737 | 309737 | 2020-07-07 | Wilkes | Georgia | 13317 | 85 | 1 |
306569 | 306569 | 2020-07-06 | Wilkes | Georgia | 13317 | 79 | 1 |
303405 | 303405 | 2020-07-05 | Wilkes | Georgia | 13317 | 76 | 1 |
300241 | 300241 | 2020-07-04 | Wilkes | Georgia | 13317 | 74 | 1 |
297079 | 297079 | 2020-07-03 | Wilkes | Georgia | 13317 | 61 | 1 |
293923 | 293923 | 2020-07-02 | Wilkes | Georgia | 13317 | 59 | 1 |
290769 | 290769 | 2020-07-01 | Wilkes | Georgia | 13317 | 57 | 1 |
287618 | 287618 | 2020-06-30 | Wilkes | Georgia | 13317 | 56 | 1 |
284472 | 284472 | 2020-06-29 | Wilkes | Georgia | 13317 | 54 | 1 |
281326 | 281326 | 2020-06-28 | Wilkes | Georgia | 13317 | 53 | 1 |
278179 | 278179 | 2020-06-27 | Wilkes | Georgia | 13317 | 52 | 1 |
275031 | 275031 | 2020-06-26 | Wilkes | Georgia | 13317 | 52 | 1 |
271891 | 271891 | 2020-06-25 | Wilkes | Georgia | 13317 | 52 | 1 |
268755 | 268755 | 2020-06-24 | Wilkes | Georgia | 13317 | 50 | 1 |
265625 | 265625 | 2020-06-23 | Wilkes | Georgia | 13317 | 49 | 1 |
262497 | 262497 | 2020-06-22 | Wilkes | Georgia | 13317 | 49 | 1 |
259370 | 259370 | 2020-06-21 | Wilkes | Georgia | 13317 | 43 | 1 |
256243 | 256243 | 2020-06-20 | Wilkes | Georgia | 13317 | 43 | 1 |
253124 | 253124 | 2020-06-19 | Wilkes | Georgia | 13317 | 43 | 1 |
250009 | 250009 | 2020-06-18 | Wilkes | Georgia | 13317 | 42 | 1 |
246897 | 246897 | 2020-06-17 | Wilkes | Georgia | 13317 | 42 | 1 |
243784 | 243784 | 2020-06-16 | Wilkes | Georgia | 13317 | 41 | 1 |
240673 | 240673 | 2020-06-15 | Wilkes | Georgia | 13317 | 39 | 1 |
237565 | 237565 | 2020-06-14 | Wilkes | Georgia | 13317 | 36 | 1 |
234458 | 234458 | 2020-06-13 | Wilkes | Georgia | 13317 | 36 | 1 |
231352 | 231352 | 2020-06-12 | Wilkes | Georgia | 13317 | 35 | 1 |
228249 | 228249 | 2020-06-11 | Wilkes | Georgia | 13317 | 35 | 1 |
225147 | 225147 | 2020-06-10 | Wilkes | Georgia | 13317 | 34 | 1 |
222052 | 222052 | 2020-06-09 | Wilkes | Georgia | 13317 | 34 | 1 |
218957 | 218957 | 2020-06-08 | Wilkes | Georgia | 13317 | 34 | 1 |
215866 | 215866 | 2020-06-07 | Wilkes | Georgia | 13317 | 34 | 1 |
212779 | 212779 | 2020-06-06 | Wilkes | Georgia | 13317 | 34 | 1 |
209694 | 209694 | 2020-06-05 | Wilkes | Georgia | 13317 | 34 | 1 |
206613 | 206613 | 2020-06-04 | Wilkes | Georgia | 13317 | 34 | 1 |
203533 | 203533 | 2020-06-03 | Wilkes | Georgia | 13317 | 34 | 1 |
200457 | 200457 | 2020-06-02 | Wilkes | Georgia | 13317 | 33 | 1 |
197384 | 197384 | 2020-06-01 | Wilkes | Georgia | 13317 | 33 | 1 |
194314 | 194314 | 2020-05-31 | Wilkes | Georgia | 13317 | 33 | 1 |
191247 | 191247 | 2020-05-30 | Wilkes | Georgia | 13317 | 33 | 1 |
188182 | 188182 | 2020-05-29 | Wilkes | Georgia | 13317 | 33 | 1 |
185126 | 185126 | 2020-05-28 | Wilkes | Georgia | 13317 | 33 | 1 |
182072 | 182072 | 2020-05-27 | Wilkes | Georgia | 13317 | 33 | 1 |
179028 | 179028 | 2020-05-26 | Wilkes | Georgia | 13317 | 33 | 1 |
175984 | 175984 | 2020-05-25 | Wilkes | Georgia | 13317 | 32 | 1 |
172941 | 172941 | 2020-05-24 | Wilkes | Georgia | 13317 | 32 | 1 |
169900 | 169900 | 2020-05-23 | Wilkes | Georgia | 13317 | 32 | 1 |
166863 | 166863 | 2020-05-22 | Wilkes | Georgia | 13317 | 32 | 1 |
163830 | 163830 | 2020-05-21 | Wilkes | Georgia | 13317 | 30 | 1 |
165166 | 165166 | 2020-05-21 | Wilkes | North Carolina | 37193 | 456 | 1 |
160802 | 160802 | 2020-05-20 | Wilkes | Georgia | 13317 | 30 | 1 |
162137 | 162137 | 2020-05-20 | Wilkes | North Carolina | 37193 | 451 | 1 |
157776 | 157776 | 2020-05-19 | Wilkes | Georgia | 13317 | 30 | 1 |
159110 | 159110 | 2020-05-19 | Wilkes | North Carolina | 37193 | 448 | 1 |
154760 | 154760 | 2020-05-18 | Wilkes | Georgia | 13317 | 30 | 1 |
156091 | 156091 | 2020-05-18 | Wilkes | North Carolina | 37193 | 425 | 1 |
151748 | 151748 | 2020-05-17 | Wilkes | Georgia | 13317 | 28 | 1 |
153074 | 153074 | 2020-05-17 | Wilkes | North Carolina | 37193 | 423 | 1 |
148739 | 148739 | 2020-05-16 | Wilkes | Georgia | 13317 | 28 | 1 |
150064 | 150064 | 2020-05-16 | Wilkes | North Carolina | 37193 | 405 | 1 |
145736 | 145736 | 2020-05-15 | Wilkes | Georgia | 13317 | 28 | 1 |
147057 | 147057 | 2020-05-15 | Wilkes | North Carolina | 37193 | 287 | 1 |
142736 | 142736 | 2020-05-14 | Wilkes | Georgia | 13317 | 28 | 1 |
144056 | 144056 | 2020-05-14 | Wilkes | North Carolina | 37193 | 277 | 1 |
139740 | 139740 | 2020-05-13 | Wilkes | Georgia | 13317 | 27 | 1 |
141061 | 141061 | 2020-05-13 | Wilkes | North Carolina | 37193 | 262 | 1 |
138065 | 138065 | 2020-05-12 | Wilkes | North Carolina | 37193 | 243 | 1 |
135075 | 135075 | 2020-05-11 | Wilkes | North Carolina | 37193 | 242 | 1 |
132084 | 132084 | 2020-05-10 | Wilkes | North Carolina | 37193 | 239 | 1 |
129095 | 129095 | 2020-05-09 | Wilkes | North Carolina | 37193 | 202 | 1 |
126106 | 126106 | 2020-05-08 | Wilkes | North Carolina | 37193 | 198 | 1 |
123123 | 123123 | 2020-05-07 | Wilkes | North Carolina | 37193 | 186 | 1 |
120148 | 120148 | 2020-05-06 | Wilkes | North Carolina | 37193 | 147 | 1 |
117187 | 117187 | 2020-05-05 | Wilkes | North Carolina | 37193 | 128 | 1 |
114307 | 114307 | 2020-05-04 | Wilkes | North Carolina | 37193 | 115 | 1 |
111426 | 111426 | 2020-05-03 | Wilkes | North Carolina | 37193 | 92 | 1 |
108553 | 108553 | 2020-05-02 | Wilkes | North Carolina | 37193 | 59 | 1 |
105686 | 105686 | 2020-05-01 | Wilkes | North Carolina | 37193 | 42 | 1 |
102824 | 102824 | 2020-04-30 | Wilkes | North Carolina | 37193 | 33 | 1 |
99971 | 99971 | 2020-04-29 | Wilkes | North Carolina | 37193 | 26 | 1 |
97122 | 97122 | 2020-04-28 | Wilkes | North Carolina | 37193 | 22 | 1 |
94285 | 94285 | 2020-04-27 | Wilkes | North Carolina | 37193 | 21 | 1 |
91459 | 91459 | 2020-04-26 | Wilkes | North Carolina | 37193 | 21 | 1 |
88644 | 88644 | 2020-04-25 | Wilkes | North Carolina | 37193 | 18 | 1 |
85831 | 85831 | 2020-04-24 | Wilkes | North Carolina | 37193 | 11 | 1 |
83027 | 83027 | 2020-04-23 | Wilkes | North Carolina | 37193 | 8 | 1 |
80228 | 80228 | 2020-04-22 | Wilkes | North Carolina | 37193 | 5 | 1 |
77439 | 77439 | 2020-04-21 | Wilkes | North Carolina | 37193 | 5 | 1 |
74658 | 74658 | 2020-04-20 | Wilkes | North Carolina | 37193 | 4 | 1 |
71883 | 71883 | 2020-04-19 | Wilkes | North Carolina | 37193 | 4 | 1 |
69117 | 69117 | 2020-04-18 | Wilkes | North Carolina | 37193 | 4 | 1 |
66360 | 66360 | 2020-04-17 | Wilkes | North Carolina | 37193 | 4 | 1 |
63617 | 63617 | 2020-04-16 | Wilkes | North Carolina | 37193 | 4 | 1 |
60891 | 60891 | 2020-04-15 | Wilkes | North Carolina | 37193 | 4 | 1 |
58177 | 58177 | 2020-04-14 | Wilkes | North Carolina | 37193 | 4 | 1 |
55476 | 55476 | 2020-04-13 | Wilkes | North Carolina | 37193 | 4 | 1 |
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);