ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where county = "Grant" 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 |
---|---|---|---|---|---|---|---|
537520 | 537520 | 2020-09-15 | Grant | West Virginia | 54023 | 147 | 7 |
534284 | 534284 | 2020-09-14 | Grant | West Virginia | 54023 | 147 | 7 |
531049 | 531049 | 2020-09-13 | Grant | West Virginia | 54023 | 147 | 6 |
527812 | 527812 | 2020-09-12 | Grant | West Virginia | 54023 | 147 | 6 |
524576 | 524576 | 2020-09-11 | Grant | West Virginia | 54023 | 147 | 6 |
521340 | 521340 | 2020-09-10 | Grant | West Virginia | 54023 | 145 | 6 |
518103 | 518103 | 2020-09-09 | Grant | West Virginia | 54023 | 144 | 6 |
514868 | 514868 | 2020-09-08 | Grant | West Virginia | 54023 | 144 | 6 |
511635 | 511635 | 2020-09-07 | Grant | West Virginia | 54023 | 144 | 6 |
508402 | 508402 | 2020-09-06 | Grant | West Virginia | 54023 | 144 | 6 |
505170 | 505170 | 2020-09-05 | Grant | West Virginia | 54023 | 143 | 6 |
501936 | 501936 | 2020-09-04 | Grant | West Virginia | 54023 | 143 | 6 |
498702 | 498702 | 2020-09-03 | Grant | West Virginia | 54023 | 142 | 6 |
495469 | 495469 | 2020-09-02 | Grant | West Virginia | 54023 | 141 | 6 |
492235 | 492235 | 2020-09-01 | Grant | West Virginia | 54023 | 141 | 6 |
489002 | 489002 | 2020-08-31 | Grant | West Virginia | 54023 | 141 | 6 |
485769 | 485769 | 2020-08-30 | Grant | West Virginia | 54023 | 139 | 6 |
482534 | 482534 | 2020-08-29 | Grant | West Virginia | 54023 | 139 | 6 |
479300 | 479300 | 2020-08-28 | Grant | West Virginia | 54023 | 140 | 5 |
476067 | 476067 | 2020-08-27 | Grant | West Virginia | 54023 | 139 | 5 |
472834 | 472834 | 2020-08-26 | Grant | West Virginia | 54023 | 138 | 5 |
469602 | 469602 | 2020-08-25 | Grant | West Virginia | 54023 | 134 | 5 |
466373 | 466373 | 2020-08-24 | Grant | West Virginia | 54023 | 133 | 4 |
463144 | 463144 | 2020-08-23 | Grant | West Virginia | 54023 | 133 | 4 |
459915 | 459915 | 2020-08-22 | Grant | West Virginia | 54023 | 133 | 4 |
456688 | 456688 | 2020-08-21 | Grant | West Virginia | 54023 | 131 | 4 |
453460 | 453460 | 2020-08-20 | Grant | West Virginia | 54023 | 131 | 5 |
450232 | 450232 | 2020-08-19 | Grant | West Virginia | 54023 | 131 | 5 |
447004 | 447004 | 2020-08-18 | Grant | West Virginia | 54023 | 131 | 4 |
443777 | 443777 | 2020-08-17 | Grant | West Virginia | 54023 | 131 | 4 |
440551 | 440551 | 2020-08-16 | Grant | West Virginia | 54023 | 131 | 4 |
437325 | 437325 | 2020-08-15 | Grant | West Virginia | 54023 | 131 | 4 |
434099 | 434099 | 2020-08-14 | Grant | West Virginia | 54023 | 131 | 4 |
430874 | 430874 | 2020-08-13 | Grant | West Virginia | 54023 | 131 | 4 |
427646 | 427646 | 2020-08-12 | Grant | West Virginia | 54023 | 129 | 4 |
424422 | 424422 | 2020-08-11 | Grant | West Virginia | 54023 | 121 | 3 |
421201 | 421201 | 2020-08-10 | Grant | West Virginia | 54023 | 121 | 1 |
417980 | 417980 | 2020-08-09 | Grant | West Virginia | 54023 | 121 | 1 |
414759 | 414759 | 2020-08-08 | Grant | West Virginia | 54023 | 119 | 1 |
411539 | 411539 | 2020-08-07 | Grant | West Virginia | 54023 | 117 | 1 |
408320 | 408320 | 2020-08-06 | Grant | West Virginia | 54023 | 97 | 1 |
405100 | 405100 | 2020-08-05 | Grant | West Virginia | 54023 | 89 | 1 |
401882 | 401882 | 2020-08-04 | Grant | West Virginia | 54023 | 81 | 1 |
398666 | 398666 | 2020-08-03 | Grant | West Virginia | 54023 | 81 | 0 |
395450 | 395450 | 2020-08-02 | Grant | West Virginia | 54023 | 77 | 0 |
392234 | 392234 | 2020-08-01 | Grant | West Virginia | 54023 | 73 | 0 |
389017 | 389017 | 2020-07-31 | Grant | West Virginia | 54023 | 68 | 0 |
385800 | 385800 | 2020-07-30 | Grant | West Virginia | 54023 | 66 | 0 |
382582 | 382582 | 2020-07-29 | Grant | West Virginia | 54023 | 66 | 0 |
379365 | 379365 | 2020-07-28 | Grant | West Virginia | 54023 | 47 | 0 |
376149 | 376149 | 2020-07-27 | Grant | West Virginia | 54023 | 43 | 0 |
372935 | 372935 | 2020-07-26 | Grant | West Virginia | 54023 | 42 | 0 |
369723 | 369723 | 2020-07-25 | Grant | West Virginia | 54023 | 39 | 0 |
366513 | 366513 | 2020-07-24 | Grant | West Virginia | 54023 | 38 | 0 |
363306 | 363306 | 2020-07-23 | Grant | West Virginia | 54023 | 38 | 0 |
360100 | 360100 | 2020-07-22 | Grant | West Virginia | 54023 | 35 | 0 |
356895 | 356895 | 2020-07-21 | Grant | West Virginia | 54023 | 26 | 0 |
353692 | 353692 | 2020-07-20 | Grant | West Virginia | 54023 | 26 | 0 |
350490 | 350490 | 2020-07-19 | Grant | West Virginia | 54023 | 22 | 0 |
347289 | 347289 | 2020-07-18 | Grant | West Virginia | 54023 | 22 | 0 |
344089 | 344089 | 2020-07-17 | Grant | West Virginia | 54023 | 22 | 0 |
340890 | 340890 | 2020-07-16 | Grant | West Virginia | 54023 | 22 | 0 |
337694 | 337694 | 2020-07-15 | Grant | West Virginia | 54023 | 21 | 0 |
334499 | 334499 | 2020-07-14 | Grant | West Virginia | 54023 | 21 | 0 |
331306 | 331306 | 2020-07-13 | Grant | West Virginia | 54023 | 22 | 0 |
328120 | 328120 | 2020-07-12 | Grant | West Virginia | 54023 | 20 | 0 |
324934 | 324934 | 2020-07-11 | Grant | West Virginia | 54023 | 19 | 0 |
321753 | 321753 | 2020-07-10 | Grant | West Virginia | 54023 | 19 | 0 |
318574 | 318574 | 2020-07-09 | Grant | West Virginia | 54023 | 16 | 0 |
315401 | 315401 | 2020-07-08 | Grant | West Virginia | 54023 | 16 | 0 |
312226 | 312226 | 2020-07-07 | Grant | West Virginia | 54023 | 16 | 0 |
309057 | 309057 | 2020-07-06 | Grant | West Virginia | 54023 | 16 | 0 |
305889 | 305889 | 2020-07-05 | Grant | West Virginia | 54023 | 16 | 0 |
302725 | 302725 | 2020-07-04 | Grant | West Virginia | 54023 | 16 | 0 |
299561 | 299561 | 2020-07-03 | Grant | West Virginia | 54023 | 16 | 0 |
296399 | 296399 | 2020-07-02 | Grant | West Virginia | 54023 | 16 | 0 |
293244 | 293244 | 2020-07-01 | Grant | West Virginia | 54023 | 16 | 0 |
290091 | 290091 | 2020-06-30 | Grant | West Virginia | 54023 | 16 | 0 |
286941 | 286941 | 2020-06-29 | Grant | West Virginia | 54023 | 16 | 0 |
283795 | 283795 | 2020-06-28 | Grant | West Virginia | 54023 | 16 | 0 |
280649 | 280649 | 2020-06-27 | Grant | West Virginia | 54023 | 16 | 0 |
277501 | 277501 | 2020-06-26 | Grant | West Virginia | 54023 | 16 | 0 |
274353 | 274353 | 2020-06-25 | Grant | West Virginia | 54023 | 16 | 0 |
271213 | 271213 | 2020-06-24 | Grant | West Virginia | 54023 | 16 | 0 |
268079 | 268079 | 2020-06-23 | Grant | West Virginia | 54023 | 16 | 0 |
264950 | 264950 | 2020-06-22 | Grant | West Virginia | 54023 | 16 | 0 |
261821 | 261821 | 2020-06-21 | Grant | West Virginia | 54023 | 16 | 0 |
258694 | 258694 | 2020-06-20 | Grant | West Virginia | 54023 | 16 | 0 |
255567 | 255567 | 2020-06-19 | Grant | West Virginia | 54023 | 16 | 0 |
252448 | 252448 | 2020-06-18 | Grant | West Virginia | 54023 | 16 | 0 |
249333 | 249333 | 2020-06-17 | Grant | West Virginia | 54023 | 16 | 0 |
246221 | 246221 | 2020-06-16 | Grant | West Virginia | 54023 | 16 | 0 |
243108 | 243108 | 2020-06-15 | Grant | West Virginia | 54023 | 16 | 0 |
239997 | 239997 | 2020-06-14 | Grant | West Virginia | 54023 | 16 | 0 |
236889 | 236889 | 2020-06-13 | Grant | West Virginia | 54023 | 16 | 0 |
233782 | 233782 | 2020-06-12 | Grant | West Virginia | 54023 | 16 | 0 |
230677 | 230677 | 2020-06-11 | Grant | West Virginia | 54023 | 16 | 0 |
227573 | 227573 | 2020-06-10 | Grant | West Virginia | 54023 | 14 | 0 |
224473 | 224473 | 2020-06-09 | Grant | West Virginia | 54023 | 14 | 0 |
221377 | 221377 | 2020-06-08 | Grant | West Virginia | 54023 | 14 | 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);