ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Putnam" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
321781 | 321781 | 2020-07-10 | Putnam | West Virginia | 54079 | 79 | 0 |
318602 | 318602 | 2020-07-09 | Putnam | West Virginia | 54079 | 78 | 0 |
315429 | 315429 | 2020-07-08 | Putnam | West Virginia | 54079 | 75 | 0 |
312254 | 312254 | 2020-07-07 | Putnam | West Virginia | 54079 | 70 | 0 |
309085 | 309085 | 2020-07-06 | Putnam | West Virginia | 54079 | 69 | 0 |
305917 | 305917 | 2020-07-05 | Putnam | West Virginia | 54079 | 66 | 0 |
302753 | 302753 | 2020-07-04 | Putnam | West Virginia | 54079 | 64 | 0 |
299589 | 299589 | 2020-07-03 | Putnam | West Virginia | 54079 | 61 | 0 |
296427 | 296427 | 2020-07-02 | Putnam | West Virginia | 54079 | 60 | 0 |
293272 | 293272 | 2020-07-01 | Putnam | West Virginia | 54079 | 58 | 0 |
290119 | 290119 | 2020-06-30 | Putnam | West Virginia | 54079 | 55 | 0 |
286969 | 286969 | 2020-06-29 | Putnam | West Virginia | 54079 | 53 | 0 |
283823 | 283823 | 2020-06-28 | Putnam | West Virginia | 54079 | 52 | 0 |
280677 | 280677 | 2020-06-27 | Putnam | West Virginia | 54079 | 51 | 0 |
277529 | 277529 | 2020-06-26 | Putnam | West Virginia | 54079 | 51 | 0 |
274381 | 274381 | 2020-06-25 | Putnam | West Virginia | 54079 | 50 | 0 |
271241 | 271241 | 2020-06-24 | Putnam | West Virginia | 54079 | 45 | 0 |
268107 | 268107 | 2020-06-23 | Putnam | West Virginia | 54079 | 44 | 0 |
264978 | 264978 | 2020-06-22 | Putnam | West Virginia | 54079 | 45 | 0 |
261849 | 261849 | 2020-06-21 | Putnam | West Virginia | 54079 | 44 | 0 |
258722 | 258722 | 2020-06-20 | Putnam | West Virginia | 54079 | 44 | 0 |
255595 | 255595 | 2020-06-19 | Putnam | West Virginia | 54079 | 41 | 0 |
252476 | 252476 | 2020-06-18 | Putnam | West Virginia | 54079 | 40 | 0 |
249361 | 249361 | 2020-06-17 | Putnam | West Virginia | 54079 | 40 | 0 |
246249 | 246249 | 2020-06-16 | Putnam | West Virginia | 54079 | 42 | 0 |
243136 | 243136 | 2020-06-15 | Putnam | West Virginia | 54079 | 42 | 0 |
240025 | 240025 | 2020-06-14 | Putnam | West Virginia | 54079 | 42 | 0 |
236917 | 236917 | 2020-06-13 | Putnam | West Virginia | 54079 | 42 | 0 |
233810 | 233810 | 2020-06-12 | Putnam | West Virginia | 54079 | 42 | 0 |
230705 | 230705 | 2020-06-11 | Putnam | West Virginia | 54079 | 41 | 0 |
227601 | 227601 | 2020-06-10 | Putnam | West Virginia | 54079 | 41 | 0 |
224501 | 224501 | 2020-06-09 | Putnam | West Virginia | 54079 | 40 | 0 |
221405 | 221405 | 2020-06-08 | Putnam | West Virginia | 54079 | 40 | 0 |
218313 | 218313 | 2020-06-07 | Putnam | West Virginia | 54079 | 39 | 0 |
215223 | 215223 | 2020-06-06 | Putnam | West Virginia | 54079 | 39 | 0 |
212136 | 212136 | 2020-06-05 | Putnam | West Virginia | 54079 | 38 | 0 |
209051 | 209051 | 2020-06-04 | Putnam | West Virginia | 54079 | 38 | 0 |
205969 | 205969 | 2020-06-03 | Putnam | West Virginia | 54079 | 38 | 0 |
202890 | 202890 | 2020-06-02 | Putnam | West Virginia | 54079 | 37 | 0 |
199814 | 199814 | 2020-06-01 | Putnam | West Virginia | 54079 | 34 | 0 |
196741 | 196741 | 2020-05-31 | Putnam | West Virginia | 54079 | 34 | 0 |
193671 | 193671 | 2020-05-30 | Putnam | West Virginia | 54079 | 35 | 0 |
190605 | 190605 | 2020-05-29 | Putnam | West Virginia | 54079 | 35 | 0 |
187541 | 187541 | 2020-05-28 | Putnam | West Virginia | 54079 | 35 | 1 |
184484 | 184484 | 2020-05-27 | Putnam | West Virginia | 54079 | 33 | 1 |
181433 | 181433 | 2020-05-26 | Putnam | West Virginia | 54079 | 33 | 0 |
178389 | 178389 | 2020-05-25 | Putnam | West Virginia | 54079 | 32 | 0 |
175344 | 175344 | 2020-05-24 | Putnam | West Virginia | 54079 | 32 | 0 |
172301 | 172301 | 2020-05-23 | Putnam | West Virginia | 54079 | 31 | 0 |
169260 | 169260 | 2020-05-22 | Putnam | West Virginia | 54079 | 31 | 0 |
166224 | 166224 | 2020-05-21 | Putnam | West Virginia | 54079 | 31 | 0 |
163195 | 163195 | 2020-05-20 | Putnam | West Virginia | 54079 | 30 | 0 |
160167 | 160167 | 2020-05-19 | Putnam | West Virginia | 54079 | 29 | 0 |
157143 | 157143 | 2020-05-18 | Putnam | West Virginia | 54079 | 29 | 0 |
154126 | 154126 | 2020-05-17 | Putnam | West Virginia | 54079 | 29 | 0 |
151115 | 151115 | 2020-05-16 | Putnam | West Virginia | 54079 | 29 | 0 |
148106 | 148106 | 2020-05-15 | Putnam | West Virginia | 54079 | 29 | 0 |
145103 | 145103 | 2020-05-14 | Putnam | West Virginia | 54079 | 29 | 0 |
142106 | 142106 | 2020-05-13 | Putnam | West Virginia | 54079 | 29 | 0 |
139110 | 139110 | 2020-05-12 | Putnam | West Virginia | 54079 | 28 | 0 |
136119 | 136119 | 2020-05-11 | Putnam | West Virginia | 54079 | 28 | 0 |
133129 | 133129 | 2020-05-10 | Putnam | West Virginia | 54079 | 27 | 0 |
130139 | 130139 | 2020-05-09 | Putnam | West Virginia | 54079 | 27 | 0 |
127149 | 127149 | 2020-05-08 | Putnam | West Virginia | 54079 | 27 | 0 |
124164 | 124164 | 2020-05-07 | Putnam | West Virginia | 54079 | 27 | 0 |
121184 | 121184 | 2020-05-06 | Putnam | West Virginia | 54079 | 27 | 0 |
118219 | 118219 | 2020-05-05 | Putnam | West Virginia | 54079 | 27 | 0 |
115260 | 115260 | 2020-05-04 | Putnam | West Virginia | 54079 | 29 | 0 |
112377 | 112377 | 2020-05-03 | Putnam | West Virginia | 54079 | 28 | 0 |
109503 | 109503 | 2020-05-02 | Putnam | West Virginia | 54079 | 27 | 0 |
106634 | 106634 | 2020-05-01 | Putnam | West Virginia | 54079 | 27 | 1 |
103770 | 103770 | 2020-04-30 | Putnam | West Virginia | 54079 | 25 | 0 |
100915 | 100915 | 2020-04-29 | Putnam | West Virginia | 54079 | 25 | 0 |
98065 | 98065 | 2020-04-28 | Putnam | West Virginia | 54079 | 22 | 0 |
95220 | 95220 | 2020-04-27 | Putnam | West Virginia | 54079 | 21 | 0 |
92390 | 92390 | 2020-04-26 | Putnam | West Virginia | 54079 | 18 | 0 |
89572 | 89572 | 2020-04-25 | Putnam | West Virginia | 54079 | 17 | 0 |
86756 | 86756 | 2020-04-24 | Putnam | West Virginia | 54079 | 16 | 0 |
83949 | 83949 | 2020-04-23 | Putnam | West Virginia | 54079 | 17 | 0 |
81148 | 81148 | 2020-04-22 | Putnam | West Virginia | 54079 | 16 | 0 |
78355 | 78355 | 2020-04-21 | Putnam | West Virginia | 54079 | 16 | 0 |
75572 | 75572 | 2020-04-20 | Putnam | West Virginia | 54079 | 15 | 0 |
72796 | 72796 | 2020-04-19 | Putnam | West Virginia | 54079 | 14 | 0 |
70027 | 70027 | 2020-04-18 | Putnam | West Virginia | 54079 | 14 | 0 |
67265 | 67265 | 2020-04-17 | Putnam | West Virginia | 54079 | 14 | 0 |
64517 | 64517 | 2020-04-16 | Putnam | West Virginia | 54079 | 13 | 0 |
61784 | 61784 | 2020-04-15 | Putnam | West Virginia | 54079 | 13 | 0 |
59065 | 59065 | 2020-04-14 | Putnam | West Virginia | 54079 | 13 | 0 |
56358 | 56358 | 2020-04-13 | Putnam | West Virginia | 54079 | 12 | 0 |
53668 | 53668 | 2020-04-12 | Putnam | West Virginia | 54079 | 11 | 0 |
50991 | 50991 | 2020-04-11 | Putnam | West Virginia | 54079 | 11 | 0 |
48332 | 48332 | 2020-04-10 | Putnam | West Virginia | 54079 | 11 | 0 |
45704 | 45704 | 2020-04-09 | Putnam | West Virginia | 54079 | 11 | 0 |
43108 | 43108 | 2020-04-08 | Putnam | West Virginia | 54079 | 10 | 0 |
40536 | 40536 | 2020-04-07 | Putnam | West Virginia | 54079 | 10 | 0 |
37997 | 37997 | 2020-04-06 | Putnam | West Virginia | 54079 | 8 | 0 |
35512 | 35512 | 2020-04-05 | Putnam | West Virginia | 54079 | 6 | 0 |
33074 | 33074 | 2020-04-04 | Putnam | West Virginia | 54079 | 5 | 0 |
30673 | 30673 | 2020-04-03 | Putnam | West Virginia | 54079 | 5 | 0 |
28319 | 28319 | 2020-04-02 | Putnam | West Virginia | 54079 | 5 | 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);