ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Rappahannock" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502613 | 2502613 | 2022-05-13 | Rappahannock | Virginia | 51157 | 1051 | 10 |
2499355 | 2499355 | 2022-05-12 | Rappahannock | Virginia | 51157 | 1051 | 10 |
2496097 | 2496097 | 2022-05-11 | Rappahannock | Virginia | 51157 | 1046 | 10 |
2492839 | 2492839 | 2022-05-10 | Rappahannock | Virginia | 51157 | 1048 | 10 |
2489581 | 2489581 | 2022-05-09 | Rappahannock | Virginia | 51157 | 1047 | 10 |
2486324 | 2486324 | 2022-05-08 | Rappahannock | Virginia | 51157 | 1045 | 10 |
2483066 | 2483066 | 2022-05-07 | Rappahannock | Virginia | 51157 | 1045 | 10 |
2479808 | 2479808 | 2022-05-06 | Rappahannock | Virginia | 51157 | 1045 | 10 |
2476550 | 2476550 | 2022-05-05 | Rappahannock | Virginia | 51157 | 1045 | 10 |
2473292 | 2473292 | 2022-05-04 | Rappahannock | Virginia | 51157 | 1045 | 10 |
2470036 | 2470036 | 2022-05-03 | Rappahannock | Virginia | 51157 | 1043 | 10 |
2466780 | 2466780 | 2022-05-02 | Rappahannock | Virginia | 51157 | 1043 | 10 |
2463525 | 2463525 | 2022-05-01 | Rappahannock | Virginia | 51157 | 1042 | 10 |
2460269 | 2460269 | 2022-04-30 | Rappahannock | Virginia | 51157 | 1042 | 10 |
2457013 | 2457013 | 2022-04-29 | Rappahannock | Virginia | 51157 | 1042 | 10 |
2453757 | 2453757 | 2022-04-28 | Rappahannock | Virginia | 51157 | 1039 | 10 |
2450501 | 2450501 | 2022-04-27 | Rappahannock | Virginia | 51157 | 1038 | 10 |
2447244 | 2447244 | 2022-04-26 | Rappahannock | Virginia | 51157 | 1038 | 10 |
2443989 | 2443989 | 2022-04-25 | Rappahannock | Virginia | 51157 | 1031 | 10 |
2440733 | 2440733 | 2022-04-24 | Rappahannock | Virginia | 51157 | 1030 | 10 |
2437477 | 2437477 | 2022-04-23 | Rappahannock | Virginia | 51157 | 1030 | 10 |
2434221 | 2434221 | 2022-04-22 | Rappahannock | Virginia | 51157 | 1030 | 10 |
2430965 | 2430965 | 2022-04-21 | Rappahannock | Virginia | 51157 | 1022 | 10 |
2427709 | 2427709 | 2022-04-20 | Rappahannock | Virginia | 51157 | 1023 | 10 |
2424453 | 2424453 | 2022-04-19 | Rappahannock | Virginia | 51157 | 1022 | 10 |
2421197 | 2421197 | 2022-04-18 | Rappahannock | Virginia | 51157 | 1012 | 10 |
2417941 | 2417941 | 2022-04-17 | Rappahannock | Virginia | 51157 | 1009 | 10 |
2414685 | 2414685 | 2022-04-16 | Rappahannock | Virginia | 51157 | 1009 | 10 |
2411429 | 2411429 | 2022-04-15 | Rappahannock | Virginia | 51157 | 1009 | 10 |
2408173 | 2408173 | 2022-04-14 | Rappahannock | Virginia | 51157 | 1000 | 10 |
2404917 | 2404917 | 2022-04-13 | Rappahannock | Virginia | 51157 | 996 | 10 |
2401662 | 2401662 | 2022-04-12 | Rappahannock | Virginia | 51157 | 1000 | 10 |
2398407 | 2398407 | 2022-04-11 | Rappahannock | Virginia | 51157 | 999 | 10 |
2395152 | 2395152 | 2022-04-10 | Rappahannock | Virginia | 51157 | 998 | 10 |
2391896 | 2391896 | 2022-04-09 | Rappahannock | Virginia | 51157 | 998 | 10 |
2388640 | 2388640 | 2022-04-08 | Rappahannock | Virginia | 51157 | 998 | 10 |
2385385 | 2385385 | 2022-04-07 | Rappahannock | Virginia | 51157 | 995 | 9 |
2382130 | 2382130 | 2022-04-06 | Rappahannock | Virginia | 51157 | 968 | 9 |
2378875 | 2378875 | 2022-04-05 | Rappahannock | Virginia | 51157 | 948 | 9 |
2375621 | 2375621 | 2022-04-04 | Rappahannock | Virginia | 51157 | 944 | 9 |
2372369 | 2372369 | 2022-04-03 | Rappahannock | Virginia | 51157 | 944 | 9 |
2369116 | 2369116 | 2022-04-02 | Rappahannock | Virginia | 51157 | 944 | 9 |
2365863 | 2365863 | 2022-04-01 | Rappahannock | Virginia | 51157 | 944 | 9 |
2362610 | 2362610 | 2022-03-31 | Rappahannock | Virginia | 51157 | 944 | 9 |
2359356 | 2359356 | 2022-03-30 | Rappahannock | Virginia | 51157 | 940 | 9 |
2356102 | 2356102 | 2022-03-29 | Rappahannock | Virginia | 51157 | 935 | 9 |
2352849 | 2352849 | 2022-03-28 | Rappahannock | Virginia | 51157 | 933 | 9 |
2349597 | 2349597 | 2022-03-27 | Rappahannock | Virginia | 51157 | 932 | 9 |
2346344 | 2346344 | 2022-03-26 | Rappahannock | Virginia | 51157 | 932 | 9 |
2343091 | 2343091 | 2022-03-25 | Rappahannock | Virginia | 51157 | 932 | 9 |
2339838 | 2339838 | 2022-03-24 | Rappahannock | Virginia | 51157 | 926 | 9 |
2336584 | 2336584 | 2022-03-23 | Rappahannock | Virginia | 51157 | 927 | 9 |
2333330 | 2333330 | 2022-03-22 | Rappahannock | Virginia | 51157 | 926 | 9 |
2330077 | 2330077 | 2022-03-21 | Rappahannock | Virginia | 51157 | 926 | 9 |
2326825 | 2326825 | 2022-03-20 | Rappahannock | Virginia | 51157 | 923 | 9 |
2323572 | 2323572 | 2022-03-19 | Rappahannock | Virginia | 51157 | 923 | 9 |
2320318 | 2320318 | 2022-03-18 | Rappahannock | Virginia | 51157 | 923 | 9 |
2317064 | 2317064 | 2022-03-17 | Rappahannock | Virginia | 51157 | 918 | 9 |
2313811 | 2313811 | 2022-03-16 | Rappahannock | Virginia | 51157 | 916 | 9 |
2310558 | 2310558 | 2022-03-15 | Rappahannock | Virginia | 51157 | 915 | 9 |
2307305 | 2307305 | 2022-03-14 | Rappahannock | Virginia | 51157 | 913 | 9 |
2304054 | 2304054 | 2022-03-13 | Rappahannock | Virginia | 51157 | 911 | 9 |
2300802 | 2300802 | 2022-03-12 | Rappahannock | Virginia | 51157 | 911 | 9 |
2297550 | 2297550 | 2022-03-11 | Rappahannock | Virginia | 51157 | 911 | 9 |
2294298 | 2294298 | 2022-03-10 | Rappahannock | Virginia | 51157 | 905 | 9 |
2291046 | 2291046 | 2022-03-09 | Rappahannock | Virginia | 51157 | 897 | 9 |
2287794 | 2287794 | 2022-03-08 | Rappahannock | Virginia | 51157 | 897 | 9 |
2284542 | 2284542 | 2022-03-07 | Rappahannock | Virginia | 51157 | 895 | 9 |
2281290 | 2281290 | 2022-03-06 | Rappahannock | Virginia | 51157 | 896 | 9 |
2278037 | 2278037 | 2022-03-05 | Rappahannock | Virginia | 51157 | 896 | 9 |
2274784 | 2274784 | 2022-03-04 | Rappahannock | Virginia | 51157 | 896 | 9 |
2271531 | 2271531 | 2022-03-03 | Rappahannock | Virginia | 51157 | 896 | 9 |
2268279 | 2268279 | 2022-03-02 | Rappahannock | Virginia | 51157 | 897 | 9 |
2265026 | 2265026 | 2022-03-01 | Rappahannock | Virginia | 51157 | 893 | 9 |
2261776 | 2261776 | 2022-02-28 | Rappahannock | Virginia | 51157 | 892 | 9 |
2258525 | 2258525 | 2022-02-27 | Rappahannock | Virginia | 51157 | 895 | 9 |
2255274 | 2255274 | 2022-02-26 | Rappahannock | Virginia | 51157 | 895 | 9 |
2252023 | 2252023 | 2022-02-25 | Rappahannock | Virginia | 51157 | 895 | 9 |
2248772 | 2248772 | 2022-02-24 | Rappahannock | Virginia | 51157 | 912 | 10 |
2245521 | 2245521 | 2022-02-23 | Rappahannock | Virginia | 51157 | 916 | 10 |
2242270 | 2242270 | 2022-02-22 | Rappahannock | Virginia | 51157 | 916 | 10 |
2239019 | 2239019 | 2022-02-21 | Rappahannock | Virginia | 51157 | 916 | 10 |
2235768 | 2235768 | 2022-02-20 | Rappahannock | Virginia | 51157 | 914 | 10 |
2232517 | 2232517 | 2022-02-19 | Rappahannock | Virginia | 51157 | 914 | 10 |
2229266 | 2229266 | 2022-02-18 | Rappahannock | Virginia | 51157 | 914 | 10 |
2226015 | 2226015 | 2022-02-17 | Rappahannock | Virginia | 51157 | 912 | 10 |
2222764 | 2222764 | 2022-02-16 | Rappahannock | Virginia | 51157 | 911 | 10 |
2219513 | 2219513 | 2022-02-15 | Rappahannock | Virginia | 51157 | 909 | 10 |
2216263 | 2216263 | 2022-02-14 | Rappahannock | Virginia | 51157 | 907 | 10 |
2213012 | 2213012 | 2022-02-13 | Rappahannock | Virginia | 51157 | 906 | 10 |
2209759 | 2209759 | 2022-02-12 | Rappahannock | Virginia | 51157 | 906 | 10 |
2206506 | 2206506 | 2022-02-11 | Rappahannock | Virginia | 51157 | 906 | 10 |
2203253 | 2203253 | 2022-02-10 | Rappahannock | Virginia | 51157 | 904 | 9 |
2199999 | 2199999 | 2022-02-09 | Rappahannock | Virginia | 51157 | 904 | 9 |
2196745 | 2196745 | 2022-02-08 | Rappahannock | Virginia | 51157 | 902 | 9 |
2193490 | 2193490 | 2022-02-07 | Rappahannock | Virginia | 51157 | 900 | 9 |
2190237 | 2190237 | 2022-02-06 | Rappahannock | Virginia | 51157 | 894 | 8 |
2186984 | 2186984 | 2022-02-05 | Rappahannock | Virginia | 51157 | 894 | 8 |
2183731 | 2183731 | 2022-02-04 | Rappahannock | Virginia | 51157 | 894 | 8 |
2180479 | 2180479 | 2022-02-03 | Rappahannock | Virginia | 51157 | 890 | 8 |
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);