ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
181 rows where county = "Monongalia", deaths = 5 and fips = 54061 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 |
---|---|---|---|---|---|---|---|
680188 | 680188 | 2020-10-29 | Monongalia | West Virginia | 54061 | 2316 | 5 |
676945 | 676945 | 2020-10-28 | Monongalia | West Virginia | 54061 | 2307 | 5 |
673702 | 673702 | 2020-10-27 | Monongalia | West Virginia | 54061 | 2298 | 5 |
670460 | 670460 | 2020-10-26 | Monongalia | West Virginia | 54061 | 2290 | 5 |
667217 | 667217 | 2020-10-25 | Monongalia | West Virginia | 54061 | 2277 | 5 |
663972 | 663972 | 2020-10-24 | Monongalia | West Virginia | 54061 | 2269 | 5 |
660728 | 660728 | 2020-10-23 | Monongalia | West Virginia | 54061 | 2259 | 5 |
657484 | 657484 | 2020-10-22 | Monongalia | West Virginia | 54061 | 2248 | 5 |
654239 | 654239 | 2020-10-21 | Monongalia | West Virginia | 54061 | 2239 | 5 |
650994 | 650994 | 2020-10-20 | Monongalia | West Virginia | 54061 | 2236 | 5 |
647750 | 647750 | 2020-10-19 | Monongalia | West Virginia | 54061 | 2228 | 5 |
644504 | 644504 | 2020-10-18 | Monongalia | West Virginia | 54061 | 2224 | 5 |
641256 | 641256 | 2020-10-17 | Monongalia | West Virginia | 54061 | 2214 | 5 |
638009 | 638009 | 2020-10-16 | Monongalia | West Virginia | 54061 | 2205 | 5 |
634764 | 634764 | 2020-10-15 | Monongalia | West Virginia | 54061 | 2190 | 5 |
631519 | 631519 | 2020-10-14 | Monongalia | West Virginia | 54061 | 2183 | 5 |
628275 | 628275 | 2020-10-13 | Monongalia | West Virginia | 54061 | 2169 | 5 |
625032 | 625032 | 2020-10-12 | Monongalia | West Virginia | 54061 | 2166 | 5 |
621789 | 621789 | 2020-10-11 | Monongalia | West Virginia | 54061 | 2157 | 5 |
618546 | 618546 | 2020-10-10 | Monongalia | West Virginia | 54061 | 2142 | 5 |
615304 | 615304 | 2020-10-09 | Monongalia | West Virginia | 54061 | 2135 | 5 |
612063 | 612063 | 2020-10-08 | Monongalia | West Virginia | 54061 | 2124 | 5 |
608821 | 608821 | 2020-10-07 | Monongalia | West Virginia | 54061 | 2119 | 5 |
605578 | 605578 | 2020-10-06 | Monongalia | West Virginia | 54061 | 2115 | 5 |
602336 | 602336 | 2020-10-05 | Monongalia | West Virginia | 54061 | 2108 | 5 |
599093 | 599093 | 2020-10-04 | Monongalia | West Virginia | 54061 | 2099 | 5 |
595850 | 595850 | 2020-10-03 | Monongalia | West Virginia | 54061 | 2079 | 5 |
592608 | 592608 | 2020-10-02 | Monongalia | West Virginia | 54061 | 2072 | 5 |
589368 | 589368 | 2020-10-01 | Monongalia | West Virginia | 54061 | 2059 | 5 |
586127 | 586127 | 2020-09-30 | Monongalia | West Virginia | 54061 | 2049 | 5 |
582887 | 582887 | 2020-09-29 | Monongalia | West Virginia | 54061 | 2035 | 5 |
579648 | 579648 | 2020-09-28 | Monongalia | West Virginia | 54061 | 2021 | 5 |
576407 | 576407 | 2020-09-27 | Monongalia | West Virginia | 54061 | 1999 | 5 |
573163 | 573163 | 2020-09-26 | Monongalia | West Virginia | 54061 | 1992 | 5 |
569921 | 569921 | 2020-09-25 | Monongalia | West Virginia | 54061 | 1980 | 5 |
566680 | 566680 | 2020-09-24 | Monongalia | West Virginia | 54061 | 1959 | 5 |
563439 | 563439 | 2020-09-23 | Monongalia | West Virginia | 54061 | 1948 | 5 |
560200 | 560200 | 2020-09-22 | Monongalia | West Virginia | 54061 | 1936 | 5 |
556964 | 556964 | 2020-09-21 | Monongalia | West Virginia | 54061 | 1902 | 5 |
553727 | 553727 | 2020-09-20 | Monongalia | West Virginia | 54061 | 1876 | 5 |
550488 | 550488 | 2020-09-19 | Monongalia | West Virginia | 54061 | 1867 | 5 |
547249 | 547249 | 2020-09-18 | Monongalia | West Virginia | 54061 | 1836 | 5 |
544012 | 544012 | 2020-09-17 | Monongalia | West Virginia | 54061 | 1791 | 5 |
540776 | 540776 | 2020-09-16 | Monongalia | West Virginia | 54061 | 1768 | 5 |
537539 | 537539 | 2020-09-15 | Monongalia | West Virginia | 54061 | 1745 | 5 |
534303 | 534303 | 2020-09-14 | Monongalia | West Virginia | 54061 | 1715 | 5 |
531068 | 531068 | 2020-09-13 | Monongalia | West Virginia | 54061 | 1691 | 5 |
527831 | 527831 | 2020-09-12 | Monongalia | West Virginia | 54061 | 1661 | 5 |
524595 | 524595 | 2020-09-11 | Monongalia | West Virginia | 54061 | 1581 | 5 |
521359 | 521359 | 2020-09-10 | Monongalia | West Virginia | 54061 | 1547 | 5 |
518122 | 518122 | 2020-09-09 | Monongalia | West Virginia | 54061 | 1504 | 5 |
514887 | 514887 | 2020-09-08 | Monongalia | West Virginia | 54061 | 1433 | 5 |
511654 | 511654 | 2020-09-07 | Monongalia | West Virginia | 54061 | 1401 | 5 |
508421 | 508421 | 2020-09-06 | Monongalia | West Virginia | 54061 | 1371 | 5 |
505189 | 505189 | 2020-09-05 | Monongalia | West Virginia | 54061 | 1342 | 5 |
501955 | 501955 | 2020-09-04 | Monongalia | West Virginia | 54061 | 1294 | 5 |
498721 | 498721 | 2020-09-03 | Monongalia | West Virginia | 54061 | 1259 | 5 |
495488 | 495488 | 2020-09-02 | Monongalia | West Virginia | 54061 | 1209 | 5 |
492254 | 492254 | 2020-09-01 | Monongalia | West Virginia | 54061 | 1170 | 5 |
489021 | 489021 | 2020-08-31 | Monongalia | West Virginia | 54061 | 1126 | 5 |
485788 | 485788 | 2020-08-30 | Monongalia | West Virginia | 54061 | 1113 | 5 |
482553 | 482553 | 2020-08-29 | Monongalia | West Virginia | 54061 | 1093 | 5 |
479319 | 479319 | 2020-08-28 | Monongalia | West Virginia | 54061 | 1083 | 5 |
476086 | 476086 | 2020-08-27 | Monongalia | West Virginia | 54061 | 1075 | 5 |
472853 | 472853 | 2020-08-26 | Monongalia | West Virginia | 54061 | 1072 | 5 |
469621 | 469621 | 2020-08-25 | Monongalia | West Virginia | 54061 | 1059 | 5 |
466392 | 466392 | 2020-08-24 | Monongalia | West Virginia | 54061 | 1060 | 5 |
463163 | 463163 | 2020-08-23 | Monongalia | West Virginia | 54061 | 1053 | 5 |
459934 | 459934 | 2020-08-22 | Monongalia | West Virginia | 54061 | 1040 | 5 |
456707 | 456707 | 2020-08-21 | Monongalia | West Virginia | 54061 | 1030 | 5 |
453479 | 453479 | 2020-08-20 | Monongalia | West Virginia | 54061 | 1014 | 5 |
450251 | 450251 | 2020-08-19 | Monongalia | West Virginia | 54061 | 1003 | 5 |
447023 | 447023 | 2020-08-18 | Monongalia | West Virginia | 54061 | 1001 | 5 |
443796 | 443796 | 2020-08-17 | Monongalia | West Virginia | 54061 | 992 | 5 |
440570 | 440570 | 2020-08-16 | Monongalia | West Virginia | 54061 | 989 | 5 |
437344 | 437344 | 2020-08-15 | Monongalia | West Virginia | 54061 | 986 | 5 |
434118 | 434118 | 2020-08-14 | Monongalia | West Virginia | 54061 | 973 | 5 |
430893 | 430893 | 2020-08-13 | Monongalia | West Virginia | 54061 | 962 | 5 |
427665 | 427665 | 2020-08-12 | Monongalia | West Virginia | 54061 | 953 | 5 |
424441 | 424441 | 2020-08-11 | Monongalia | West Virginia | 54061 | 950 | 5 |
421220 | 421220 | 2020-08-10 | Monongalia | West Virginia | 54061 | 945 | 5 |
417999 | 417999 | 2020-08-09 | Monongalia | West Virginia | 54061 | 939 | 5 |
414778 | 414778 | 2020-08-08 | Monongalia | West Virginia | 54061 | 938 | 5 |
411558 | 411558 | 2020-08-07 | Monongalia | West Virginia | 54061 | 935 | 5 |
408339 | 408339 | 2020-08-06 | Monongalia | West Virginia | 54061 | 929 | 5 |
405119 | 405119 | 2020-08-05 | Monongalia | West Virginia | 54061 | 929 | 5 |
401901 | 401901 | 2020-08-04 | Monongalia | West Virginia | 54061 | 929 | 5 |
398685 | 398685 | 2020-08-03 | Monongalia | West Virginia | 54061 | 925 | 5 |
395469 | 395469 | 2020-08-02 | Monongalia | West Virginia | 54061 | 916 | 5 |
392253 | 392253 | 2020-08-01 | Monongalia | West Virginia | 54061 | 909 | 5 |
389036 | 389036 | 2020-07-31 | Monongalia | West Virginia | 54061 | 896 | 5 |
385819 | 385819 | 2020-07-30 | Monongalia | West Virginia | 54061 | 869 | 5 |
382601 | 382601 | 2020-07-29 | Monongalia | West Virginia | 54061 | 866 | 5 |
379384 | 379384 | 2020-07-28 | Monongalia | West Virginia | 54061 | 845 | 5 |
376168 | 376168 | 2020-07-27 | Monongalia | West Virginia | 54061 | 838 | 5 |
372954 | 372954 | 2020-07-26 | Monongalia | West Virginia | 54061 | 827 | 5 |
369742 | 369742 | 2020-07-25 | Monongalia | West Virginia | 54061 | 816 | 5 |
366532 | 366532 | 2020-07-24 | Monongalia | West Virginia | 54061 | 812 | 5 |
363325 | 363325 | 2020-07-23 | Monongalia | West Virginia | 54061 | 806 | 5 |
360119 | 360119 | 2020-07-22 | Monongalia | West Virginia | 54061 | 790 | 5 |
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);