ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
748 rows where county = "Calhoun" and state = "West Virginia" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
92360 | 92360 | 2020-04-26 | Calhoun | West Virginia | 54013 | 1 | 0 |
95189 | 95189 | 2020-04-27 | Calhoun | West Virginia | 54013 | 1 | 0 |
98034 | 98034 | 2020-04-28 | Calhoun | West Virginia | 54013 | 1 | 0 |
100884 | 100884 | 2020-04-29 | Calhoun | West Virginia | 54013 | 1 | 0 |
103739 | 103739 | 2020-04-30 | Calhoun | West Virginia | 54013 | 1 | 0 |
106603 | 106603 | 2020-05-01 | Calhoun | West Virginia | 54013 | 1 | 0 |
109472 | 109472 | 2020-05-02 | Calhoun | West Virginia | 54013 | 1 | 0 |
112346 | 112346 | 2020-05-03 | Calhoun | West Virginia | 54013 | 1 | 0 |
115229 | 115229 | 2020-05-04 | Calhoun | West Virginia | 54013 | 1 | 0 |
118188 | 118188 | 2020-05-05 | Calhoun | West Virginia | 54013 | 1 | 0 |
121152 | 121152 | 2020-05-06 | Calhoun | West Virginia | 54013 | 1 | 0 |
124132 | 124132 | 2020-05-07 | Calhoun | West Virginia | 54013 | 1 | 0 |
127117 | 127117 | 2020-05-08 | Calhoun | West Virginia | 54013 | 1 | 0 |
130107 | 130107 | 2020-05-09 | Calhoun | West Virginia | 54013 | 1 | 0 |
133097 | 133097 | 2020-05-10 | Calhoun | West Virginia | 54013 | 1 | 0 |
136087 | 136087 | 2020-05-11 | Calhoun | West Virginia | 54013 | 1 | 0 |
139078 | 139078 | 2020-05-12 | Calhoun | West Virginia | 54013 | 1 | 0 |
142074 | 142074 | 2020-05-13 | Calhoun | West Virginia | 54013 | 1 | 0 |
145071 | 145071 | 2020-05-14 | Calhoun | West Virginia | 54013 | 1 | 0 |
148074 | 148074 | 2020-05-15 | Calhoun | West Virginia | 54013 | 1 | 0 |
151083 | 151083 | 2020-05-16 | Calhoun | West Virginia | 54013 | 1 | 0 |
154094 | 154094 | 2020-05-17 | Calhoun | West Virginia | 54013 | 2 | 0 |
157111 | 157111 | 2020-05-18 | Calhoun | West Virginia | 54013 | 2 | 0 |
160135 | 160135 | 2020-05-19 | Calhoun | West Virginia | 54013 | 2 | 0 |
163163 | 163163 | 2020-05-20 | Calhoun | West Virginia | 54013 | 2 | 0 |
166192 | 166192 | 2020-05-21 | Calhoun | West Virginia | 54013 | 2 | 0 |
169228 | 169228 | 2020-05-22 | Calhoun | West Virginia | 54013 | 2 | 0 |
172269 | 172269 | 2020-05-23 | Calhoun | West Virginia | 54013 | 2 | 0 |
175312 | 175312 | 2020-05-24 | Calhoun | West Virginia | 54013 | 2 | 0 |
178357 | 178357 | 2020-05-25 | Calhoun | West Virginia | 54013 | 2 | 0 |
181401 | 181401 | 2020-05-26 | Calhoun | West Virginia | 54013 | 2 | 0 |
184452 | 184452 | 2020-05-27 | Calhoun | West Virginia | 54013 | 2 | 0 |
187509 | 187509 | 2020-05-28 | Calhoun | West Virginia | 54013 | 2 | 0 |
190573 | 190573 | 2020-05-29 | Calhoun | West Virginia | 54013 | 2 | 0 |
193639 | 193639 | 2020-05-30 | Calhoun | West Virginia | 54013 | 2 | 0 |
196709 | 196709 | 2020-05-31 | Calhoun | West Virginia | 54013 | 2 | 0 |
199782 | 199782 | 2020-06-01 | Calhoun | West Virginia | 54013 | 2 | 0 |
202858 | 202858 | 2020-06-02 | Calhoun | West Virginia | 54013 | 2 | 0 |
205937 | 205937 | 2020-06-03 | Calhoun | West Virginia | 54013 | 2 | 0 |
209019 | 209019 | 2020-06-04 | Calhoun | West Virginia | 54013 | 2 | 0 |
212104 | 212104 | 2020-06-05 | Calhoun | West Virginia | 54013 | 2 | 0 |
215191 | 215191 | 2020-06-06 | Calhoun | West Virginia | 54013 | 2 | 0 |
218281 | 218281 | 2020-06-07 | Calhoun | West Virginia | 54013 | 2 | 0 |
221373 | 221373 | 2020-06-08 | Calhoun | West Virginia | 54013 | 2 | 0 |
224469 | 224469 | 2020-06-09 | Calhoun | West Virginia | 54013 | 2 | 0 |
227569 | 227569 | 2020-06-10 | Calhoun | West Virginia | 54013 | 2 | 0 |
230673 | 230673 | 2020-06-11 | Calhoun | West Virginia | 54013 | 2 | 0 |
233778 | 233778 | 2020-06-12 | Calhoun | West Virginia | 54013 | 2 | 0 |
236885 | 236885 | 2020-06-13 | Calhoun | West Virginia | 54013 | 2 | 0 |
239993 | 239993 | 2020-06-14 | Calhoun | West Virginia | 54013 | 2 | 0 |
243104 | 243104 | 2020-06-15 | Calhoun | West Virginia | 54013 | 2 | 0 |
246217 | 246217 | 2020-06-16 | Calhoun | West Virginia | 54013 | 2 | 0 |
249329 | 249329 | 2020-06-17 | Calhoun | West Virginia | 54013 | 2 | 0 |
252444 | 252444 | 2020-06-18 | Calhoun | West Virginia | 54013 | 2 | 0 |
255563 | 255563 | 2020-06-19 | Calhoun | West Virginia | 54013 | 2 | 0 |
258690 | 258690 | 2020-06-20 | Calhoun | West Virginia | 54013 | 2 | 0 |
261817 | 261817 | 2020-06-21 | Calhoun | West Virginia | 54013 | 2 | 0 |
264946 | 264946 | 2020-06-22 | Calhoun | West Virginia | 54013 | 2 | 0 |
268075 | 268075 | 2020-06-23 | Calhoun | West Virginia | 54013 | 2 | 0 |
271209 | 271209 | 2020-06-24 | Calhoun | West Virginia | 54013 | 2 | 0 |
274349 | 274349 | 2020-06-25 | Calhoun | West Virginia | 54013 | 2 | 0 |
277497 | 277497 | 2020-06-26 | Calhoun | West Virginia | 54013 | 2 | 0 |
280645 | 280645 | 2020-06-27 | Calhoun | West Virginia | 54013 | 2 | 0 |
283791 | 283791 | 2020-06-28 | Calhoun | West Virginia | 54013 | 2 | 0 |
286937 | 286937 | 2020-06-29 | Calhoun | West Virginia | 54013 | 2 | 0 |
290087 | 290087 | 2020-06-30 | Calhoun | West Virginia | 54013 | 2 | 0 |
293240 | 293240 | 2020-07-01 | Calhoun | West Virginia | 54013 | 2 | 0 |
296395 | 296395 | 2020-07-02 | Calhoun | West Virginia | 54013 | 2 | 0 |
299557 | 299557 | 2020-07-03 | Calhoun | West Virginia | 54013 | 2 | 0 |
302721 | 302721 | 2020-07-04 | Calhoun | West Virginia | 54013 | 2 | 0 |
305885 | 305885 | 2020-07-05 | Calhoun | West Virginia | 54013 | 2 | 0 |
309053 | 309053 | 2020-07-06 | Calhoun | West Virginia | 54013 | 2 | 0 |
312222 | 312222 | 2020-07-07 | Calhoun | West Virginia | 54013 | 2 | 0 |
315397 | 315397 | 2020-07-08 | Calhoun | West Virginia | 54013 | 4 | 0 |
318570 | 318570 | 2020-07-09 | Calhoun | West Virginia | 54013 | 4 | 0 |
321749 | 321749 | 2020-07-10 | Calhoun | West Virginia | 54013 | 4 | 0 |
324930 | 324930 | 2020-07-11 | Calhoun | West Virginia | 54013 | 4 | 0 |
328116 | 328116 | 2020-07-12 | Calhoun | West Virginia | 54013 | 4 | 0 |
331302 | 331302 | 2020-07-13 | Calhoun | West Virginia | 54013 | 4 | 0 |
334495 | 334495 | 2020-07-14 | Calhoun | West Virginia | 54013 | 4 | 0 |
337690 | 337690 | 2020-07-15 | Calhoun | West Virginia | 54013 | 4 | 0 |
340886 | 340886 | 2020-07-16 | Calhoun | West Virginia | 54013 | 4 | 0 |
344085 | 344085 | 2020-07-17 | Calhoun | West Virginia | 54013 | 4 | 0 |
347285 | 347285 | 2020-07-18 | Calhoun | West Virginia | 54013 | 5 | 0 |
350486 | 350486 | 2020-07-19 | Calhoun | West Virginia | 54013 | 5 | 0 |
353688 | 353688 | 2020-07-20 | Calhoun | West Virginia | 54013 | 5 | 0 |
356891 | 356891 | 2020-07-21 | Calhoun | West Virginia | 54013 | 5 | 0 |
360096 | 360096 | 2020-07-22 | Calhoun | West Virginia | 54013 | 5 | 0 |
363302 | 363302 | 2020-07-23 | Calhoun | West Virginia | 54013 | 5 | 0 |
366509 | 366509 | 2020-07-24 | Calhoun | West Virginia | 54013 | 5 | 0 |
369718 | 369718 | 2020-07-25 | Calhoun | West Virginia | 54013 | 5 | 0 |
372930 | 372930 | 2020-07-26 | Calhoun | West Virginia | 54013 | 5 | 0 |
376144 | 376144 | 2020-07-27 | Calhoun | West Virginia | 54013 | 6 | 0 |
379360 | 379360 | 2020-07-28 | Calhoun | West Virginia | 54013 | 6 | 0 |
382577 | 382577 | 2020-07-29 | Calhoun | West Virginia | 54013 | 6 | 0 |
385795 | 385795 | 2020-07-30 | Calhoun | West Virginia | 54013 | 6 | 0 |
389012 | 389012 | 2020-07-31 | Calhoun | West Virginia | 54013 | 6 | 0 |
392229 | 392229 | 2020-08-01 | Calhoun | West Virginia | 54013 | 6 | 0 |
395445 | 395445 | 2020-08-02 | Calhoun | West Virginia | 54013 | 6 | 0 |
398661 | 398661 | 2020-08-03 | Calhoun | West Virginia | 54013 | 6 | 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);