ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Russell" and state = "Virginia" 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 |
---|---|---|---|---|---|---|---|
2502620 | 2502620 | 2022-05-13 | Russell | Virginia | 51167 | 6877 | 114 |
2499362 | 2499362 | 2022-05-12 | Russell | Virginia | 51167 | 6869 | 114 |
2496104 | 2496104 | 2022-05-11 | Russell | Virginia | 51167 | 6865 | 114 |
2492846 | 2492846 | 2022-05-10 | Russell | Virginia | 51167 | 6861 | 114 |
2489588 | 2489588 | 2022-05-09 | Russell | Virginia | 51167 | 6860 | 114 |
2486331 | 2486331 | 2022-05-08 | Russell | Virginia | 51167 | 6856 | 113 |
2483073 | 2483073 | 2022-05-07 | Russell | Virginia | 51167 | 6856 | 113 |
2479815 | 2479815 | 2022-05-06 | Russell | Virginia | 51167 | 6856 | 113 |
2476557 | 2476557 | 2022-05-05 | Russell | Virginia | 51167 | 6855 | 113 |
2473299 | 2473299 | 2022-05-04 | Russell | Virginia | 51167 | 6853 | 113 |
2470043 | 2470043 | 2022-05-03 | Russell | Virginia | 51167 | 6854 | 114 |
2466787 | 2466787 | 2022-05-02 | Russell | Virginia | 51167 | 6868 | 114 |
2463532 | 2463532 | 2022-05-01 | Russell | Virginia | 51167 | 6868 | 114 |
2460276 | 2460276 | 2022-04-30 | Russell | Virginia | 51167 | 6868 | 114 |
2457020 | 2457020 | 2022-04-29 | Russell | Virginia | 51167 | 6868 | 114 |
2453764 | 2453764 | 2022-04-28 | Russell | Virginia | 51167 | 6868 | 114 |
2450508 | 2450508 | 2022-04-27 | Russell | Virginia | 51167 | 6868 | 114 |
2447251 | 2447251 | 2022-04-26 | Russell | Virginia | 51167 | 6867 | 114 |
2443996 | 2443996 | 2022-04-25 | Russell | Virginia | 51167 | 6864 | 114 |
2440740 | 2440740 | 2022-04-24 | Russell | Virginia | 51167 | 6857 | 114 |
2437484 | 2437484 | 2022-04-23 | Russell | Virginia | 51167 | 6857 | 114 |
2434228 | 2434228 | 2022-04-22 | Russell | Virginia | 51167 | 6857 | 114 |
2430972 | 2430972 | 2022-04-21 | Russell | Virginia | 51167 | 6852 | 113 |
2427716 | 2427716 | 2022-04-20 | Russell | Virginia | 51167 | 6850 | 113 |
2424460 | 2424460 | 2022-04-19 | Russell | Virginia | 51167 | 6849 | 113 |
2421204 | 2421204 | 2022-04-18 | Russell | Virginia | 51167 | 6846 | 112 |
2417948 | 2417948 | 2022-04-17 | Russell | Virginia | 51167 | 6839 | 111 |
2414692 | 2414692 | 2022-04-16 | Russell | Virginia | 51167 | 6839 | 111 |
2411436 | 2411436 | 2022-04-15 | Russell | Virginia | 51167 | 6839 | 111 |
2408180 | 2408180 | 2022-04-14 | Russell | Virginia | 51167 | 6831 | 111 |
2404924 | 2404924 | 2022-04-13 | Russell | Virginia | 51167 | 6830 | 111 |
2401669 | 2401669 | 2022-04-12 | Russell | Virginia | 51167 | 6826 | 111 |
2398414 | 2398414 | 2022-04-11 | Russell | Virginia | 51167 | 6826 | 111 |
2395159 | 2395159 | 2022-04-10 | Russell | Virginia | 51167 | 6823 | 111 |
2391903 | 2391903 | 2022-04-09 | Russell | Virginia | 51167 | 6823 | 111 |
2388647 | 2388647 | 2022-04-08 | Russell | Virginia | 51167 | 6823 | 111 |
2385392 | 2385392 | 2022-04-07 | Russell | Virginia | 51167 | 6823 | 111 |
2382137 | 2382137 | 2022-04-06 | Russell | Virginia | 51167 | 6820 | 111 |
2378882 | 2378882 | 2022-04-05 | Russell | Virginia | 51167 | 6819 | 110 |
2375628 | 2375628 | 2022-04-04 | Russell | Virginia | 51167 | 6820 | 110 |
2372376 | 2372376 | 2022-04-03 | Russell | Virginia | 51167 | 6815 | 109 |
2369123 | 2369123 | 2022-04-02 | Russell | Virginia | 51167 | 6815 | 109 |
2365870 | 2365870 | 2022-04-01 | Russell | Virginia | 51167 | 6815 | 109 |
2362617 | 2362617 | 2022-03-31 | Russell | Virginia | 51167 | 6815 | 109 |
2359363 | 2359363 | 2022-03-30 | Russell | Virginia | 51167 | 6815 | 109 |
2356109 | 2356109 | 2022-03-29 | Russell | Virginia | 51167 | 6812 | 108 |
2352856 | 2352856 | 2022-03-28 | Russell | Virginia | 51167 | 6809 | 108 |
2349604 | 2349604 | 2022-03-27 | Russell | Virginia | 51167 | 6801 | 107 |
2346351 | 2346351 | 2022-03-26 | Russell | Virginia | 51167 | 6801 | 107 |
2343098 | 2343098 | 2022-03-25 | Russell | Virginia | 51167 | 6801 | 107 |
2339845 | 2339845 | 2022-03-24 | Russell | Virginia | 51167 | 6800 | 106 |
2336591 | 2336591 | 2022-03-23 | Russell | Virginia | 51167 | 6799 | 106 |
2333337 | 2333337 | 2022-03-22 | Russell | Virginia | 51167 | 6795 | 104 |
2330084 | 2330084 | 2022-03-21 | Russell | Virginia | 51167 | 6795 | 104 |
2326832 | 2326832 | 2022-03-20 | Russell | Virginia | 51167 | 6772 | 104 |
2323579 | 2323579 | 2022-03-19 | Russell | Virginia | 51167 | 6772 | 104 |
2320325 | 2320325 | 2022-03-18 | Russell | Virginia | 51167 | 6772 | 104 |
2317071 | 2317071 | 2022-03-17 | Russell | Virginia | 51167 | 6776 | 104 |
2313818 | 2313818 | 2022-03-16 | Russell | Virginia | 51167 | 6775 | 104 |
2310565 | 2310565 | 2022-03-15 | Russell | Virginia | 51167 | 6771 | 104 |
2307312 | 2307312 | 2022-03-14 | Russell | Virginia | 51167 | 6795 | 103 |
2304061 | 2304061 | 2022-03-13 | Russell | Virginia | 51167 | 6792 | 102 |
2300809 | 2300809 | 2022-03-12 | Russell | Virginia | 51167 | 6792 | 102 |
2297557 | 2297557 | 2022-03-11 | Russell | Virginia | 51167 | 6792 | 102 |
2294305 | 2294305 | 2022-03-10 | Russell | Virginia | 51167 | 6794 | 101 |
2291053 | 2291053 | 2022-03-09 | Russell | Virginia | 51167 | 6790 | 101 |
2287801 | 2287801 | 2022-03-08 | Russell | Virginia | 51167 | 6789 | 101 |
2284549 | 2284549 | 2022-03-07 | Russell | Virginia | 51167 | 6780 | 101 |
2281297 | 2281297 | 2022-03-06 | Russell | Virginia | 51167 | 6769 | 99 |
2278044 | 2278044 | 2022-03-05 | Russell | Virginia | 51167 | 6769 | 99 |
2274791 | 2274791 | 2022-03-04 | Russell | Virginia | 51167 | 6769 | 99 |
2271538 | 2271538 | 2022-03-03 | Russell | Virginia | 51167 | 6759 | 98 |
2268286 | 2268286 | 2022-03-02 | Russell | Virginia | 51167 | 6751 | 97 |
2265033 | 2265033 | 2022-03-01 | Russell | Virginia | 51167 | 6735 | 97 |
2261783 | 2261783 | 2022-02-28 | Russell | Virginia | 51167 | 6728 | 97 |
2258532 | 2258532 | 2022-02-27 | Russell | Virginia | 51167 | 6709 | 97 |
2255281 | 2255281 | 2022-02-26 | Russell | Virginia | 51167 | 6709 | 97 |
2252030 | 2252030 | 2022-02-25 | Russell | Virginia | 51167 | 6709 | 97 |
2248779 | 2248779 | 2022-02-24 | Russell | Virginia | 51167 | 6693 | 96 |
2245528 | 2245528 | 2022-02-23 | Russell | Virginia | 51167 | 6671 | 96 |
2242277 | 2242277 | 2022-02-22 | Russell | Virginia | 51167 | 6651 | 96 |
2239026 | 2239026 | 2022-02-21 | Russell | Virginia | 51167 | 6633 | 95 |
2235775 | 2235775 | 2022-02-20 | Russell | Virginia | 51167 | 6580 | 95 |
2232524 | 2232524 | 2022-02-19 | Russell | Virginia | 51167 | 6580 | 95 |
2229273 | 2229273 | 2022-02-18 | Russell | Virginia | 51167 | 6580 | 95 |
2226022 | 2226022 | 2022-02-17 | Russell | Virginia | 51167 | 6552 | 95 |
2222771 | 2222771 | 2022-02-16 | Russell | Virginia | 51167 | 6524 | 94 |
2219520 | 2219520 | 2022-02-15 | Russell | Virginia | 51167 | 6485 | 94 |
2216270 | 2216270 | 2022-02-14 | Russell | Virginia | 51167 | 6452 | 94 |
2213019 | 2213019 | 2022-02-13 | Russell | Virginia | 51167 | 6393 | 94 |
2209766 | 2209766 | 2022-02-12 | Russell | Virginia | 51167 | 6393 | 94 |
2206513 | 2206513 | 2022-02-11 | Russell | Virginia | 51167 | 6393 | 94 |
2203260 | 2203260 | 2022-02-10 | Russell | Virginia | 51167 | 6348 | 93 |
2200006 | 2200006 | 2022-02-09 | Russell | Virginia | 51167 | 6299 | 92 |
2196752 | 2196752 | 2022-02-08 | Russell | Virginia | 51167 | 6254 | 91 |
2193497 | 2193497 | 2022-02-07 | Russell | Virginia | 51167 | 6223 | 91 |
2190244 | 2190244 | 2022-02-06 | Russell | Virginia | 51167 | 6124 | 86 |
2186991 | 2186991 | 2022-02-05 | Russell | Virginia | 51167 | 6124 | 86 |
2183738 | 2183738 | 2022-02-04 | Russell | Virginia | 51167 | 6124 | 86 |
2180486 | 2180486 | 2022-02-03 | Russell | Virginia | 51167 | 6070 | 85 |
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);