ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Augusta" 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 |
---|---|---|---|---|---|---|---|
2502518 | 2502518 | 2022-05-13 | Augusta | Virginia | 51015 | 18922 | 206 |
2499260 | 2499260 | 2022-05-12 | Augusta | Virginia | 51015 | 18893 | 206 |
2496002 | 2496002 | 2022-05-11 | Augusta | Virginia | 51015 | 18790 | 205 |
2492744 | 2492744 | 2022-05-10 | Augusta | Virginia | 51015 | 18773 | 205 |
2489486 | 2489486 | 2022-05-09 | Augusta | Virginia | 51015 | 18817 | 206 |
2486229 | 2486229 | 2022-05-08 | Augusta | Virginia | 51015 | 18696 | 203 |
2482971 | 2482971 | 2022-05-07 | Augusta | Virginia | 51015 | 18696 | 203 |
2479713 | 2479713 | 2022-05-06 | Augusta | Virginia | 51015 | 18696 | 203 |
2476455 | 2476455 | 2022-05-05 | Augusta | Virginia | 51015 | 18688 | 203 |
2473197 | 2473197 | 2022-05-04 | Augusta | Virginia | 51015 | 18650 | 202 |
2469941 | 2469941 | 2022-05-03 | Augusta | Virginia | 51015 | 18611 | 203 |
2466685 | 2466685 | 2022-05-02 | Augusta | Virginia | 51015 | 18589 | 202 |
2463430 | 2463430 | 2022-05-01 | Augusta | Virginia | 51015 | 18561 | 202 |
2460174 | 2460174 | 2022-04-30 | Augusta | Virginia | 51015 | 18561 | 202 |
2456918 | 2456918 | 2022-04-29 | Augusta | Virginia | 51015 | 18561 | 202 |
2453662 | 2453662 | 2022-04-28 | Augusta | Virginia | 51015 | 18551 | 202 |
2450406 | 2450406 | 2022-04-27 | Augusta | Virginia | 51015 | 18527 | 202 |
2447149 | 2447149 | 2022-04-26 | Augusta | Virginia | 51015 | 18517 | 205 |
2443894 | 2443894 | 2022-04-25 | Augusta | Virginia | 51015 | 18495 | 207 |
2440638 | 2440638 | 2022-04-24 | Augusta | Virginia | 51015 | 18764 | 213 |
2437382 | 2437382 | 2022-04-23 | Augusta | Virginia | 51015 | 18764 | 213 |
2434126 | 2434126 | 2022-04-22 | Augusta | Virginia | 51015 | 18764 | 213 |
2430870 | 2430870 | 2022-04-21 | Augusta | Virginia | 51015 | 18778 | 212 |
2427614 | 2427614 | 2022-04-20 | Augusta | Virginia | 51015 | 18988 | 215 |
2424358 | 2424358 | 2022-04-19 | Augusta | Virginia | 51015 | 19073 | 216 |
2421102 | 2421102 | 2022-04-18 | Augusta | Virginia | 51015 | 19059 | 215 |
2417846 | 2417846 | 2022-04-17 | Augusta | Virginia | 51015 | 19035 | 214 |
2414590 | 2414590 | 2022-04-16 | Augusta | Virginia | 51015 | 19035 | 214 |
2411334 | 2411334 | 2022-04-15 | Augusta | Virginia | 51015 | 19035 | 214 |
2408078 | 2408078 | 2022-04-14 | Augusta | Virginia | 51015 | 19024 | 214 |
2404822 | 2404822 | 2022-04-13 | Augusta | Virginia | 51015 | 19007 | 214 |
2401567 | 2401567 | 2022-04-12 | Augusta | Virginia | 51015 | 18981 | 213 |
2398312 | 2398312 | 2022-04-11 | Augusta | Virginia | 51015 | 18973 | 213 |
2395057 | 2395057 | 2022-04-10 | Augusta | Virginia | 51015 | 18958 | 211 |
2391801 | 2391801 | 2022-04-09 | Augusta | Virginia | 51015 | 18958 | 211 |
2388545 | 2388545 | 2022-04-08 | Augusta | Virginia | 51015 | 18958 | 211 |
2385290 | 2385290 | 2022-04-07 | Augusta | Virginia | 51015 | 18951 | 211 |
2382035 | 2382035 | 2022-04-06 | Augusta | Virginia | 51015 | 18949 | 211 |
2378780 | 2378780 | 2022-04-05 | Augusta | Virginia | 51015 | 18942 | 211 |
2375526 | 2375526 | 2022-04-04 | Augusta | Virginia | 51015 | 18939 | 211 |
2372274 | 2372274 | 2022-04-03 | Augusta | Virginia | 51015 | 18932 | 211 |
2369021 | 2369021 | 2022-04-02 | Augusta | Virginia | 51015 | 18932 | 211 |
2365768 | 2365768 | 2022-04-01 | Augusta | Virginia | 51015 | 18932 | 211 |
2362515 | 2362515 | 2022-03-31 | Augusta | Virginia | 51015 | 18935 | 211 |
2359261 | 2359261 | 2022-03-30 | Augusta | Virginia | 51015 | 18929 | 211 |
2356007 | 2356007 | 2022-03-29 | Augusta | Virginia | 51015 | 18936 | 211 |
2352754 | 2352754 | 2022-03-28 | Augusta | Virginia | 51015 | 18950 | 210 |
2349502 | 2349502 | 2022-03-27 | Augusta | Virginia | 51015 | 18945 | 209 |
2346249 | 2346249 | 2022-03-26 | Augusta | Virginia | 51015 | 18945 | 209 |
2342996 | 2342996 | 2022-03-25 | Augusta | Virginia | 51015 | 18945 | 209 |
2339743 | 2339743 | 2022-03-24 | Augusta | Virginia | 51015 | 18939 | 209 |
2336489 | 2336489 | 2022-03-23 | Augusta | Virginia | 51015 | 18926 | 209 |
2333235 | 2333235 | 2022-03-22 | Augusta | Virginia | 51015 | 18909 | 207 |
2329982 | 2329982 | 2022-03-21 | Augusta | Virginia | 51015 | 18909 | 207 |
2326730 | 2326730 | 2022-03-20 | Augusta | Virginia | 51015 | 18896 | 206 |
2323477 | 2323477 | 2022-03-19 | Augusta | Virginia | 51015 | 18896 | 206 |
2320223 | 2320223 | 2022-03-18 | Augusta | Virginia | 51015 | 18896 | 206 |
2316969 | 2316969 | 2022-03-17 | Augusta | Virginia | 51015 | 18891 | 205 |
2313716 | 2313716 | 2022-03-16 | Augusta | Virginia | 51015 | 18889 | 204 |
2310463 | 2310463 | 2022-03-15 | Augusta | Virginia | 51015 | 18871 | 203 |
2307210 | 2307210 | 2022-03-14 | Augusta | Virginia | 51015 | 18858 | 203 |
2303959 | 2303959 | 2022-03-13 | Augusta | Virginia | 51015 | 18854 | 203 |
2300707 | 2300707 | 2022-03-12 | Augusta | Virginia | 51015 | 18854 | 203 |
2297455 | 2297455 | 2022-03-11 | Augusta | Virginia | 51015 | 18854 | 203 |
2294203 | 2294203 | 2022-03-10 | Augusta | Virginia | 51015 | 18852 | 203 |
2290951 | 2290951 | 2022-03-09 | Augusta | Virginia | 51015 | 18839 | 201 |
2287699 | 2287699 | 2022-03-08 | Augusta | Virginia | 51015 | 18821 | 201 |
2284447 | 2284447 | 2022-03-07 | Augusta | Virginia | 51015 | 18805 | 201 |
2281195 | 2281195 | 2022-03-06 | Augusta | Virginia | 51015 | 18767 | 200 |
2277942 | 2277942 | 2022-03-05 | Augusta | Virginia | 51015 | 18767 | 200 |
2274689 | 2274689 | 2022-03-04 | Augusta | Virginia | 51015 | 18767 | 200 |
2271436 | 2271436 | 2022-03-03 | Augusta | Virginia | 51015 | 18754 | 200 |
2268184 | 2268184 | 2022-03-02 | Augusta | Virginia | 51015 | 18741 | 199 |
2264931 | 2264931 | 2022-03-01 | Augusta | Virginia | 51015 | 18719 | 197 |
2261681 | 2261681 | 2022-02-28 | Augusta | Virginia | 51015 | 18702 | 197 |
2258430 | 2258430 | 2022-02-27 | Augusta | Virginia | 51015 | 18663 | 196 |
2255179 | 2255179 | 2022-02-26 | Augusta | Virginia | 51015 | 18663 | 196 |
2251928 | 2251928 | 2022-02-25 | Augusta | Virginia | 51015 | 18663 | 196 |
2248677 | 2248677 | 2022-02-24 | Augusta | Virginia | 51015 | 18640 | 195 |
2245426 | 2245426 | 2022-02-23 | Augusta | Virginia | 51015 | 18623 | 194 |
2242175 | 2242175 | 2022-02-22 | Augusta | Virginia | 51015 | 18597 | 187 |
2238924 | 2238924 | 2022-02-21 | Augusta | Virginia | 51015 | 18573 | 185 |
2235673 | 2235673 | 2022-02-20 | Augusta | Virginia | 51015 | 18494 | 184 |
2232422 | 2232422 | 2022-02-19 | Augusta | Virginia | 51015 | 18494 | 184 |
2229171 | 2229171 | 2022-02-18 | Augusta | Virginia | 51015 | 18494 | 184 |
2225920 | 2225920 | 2022-02-17 | Augusta | Virginia | 51015 | 18444 | 181 |
2222669 | 2222669 | 2022-02-16 | Augusta | Virginia | 51015 | 18405 | 179 |
2219418 | 2219418 | 2022-02-15 | Augusta | Virginia | 51015 | 18362 | 179 |
2216168 | 2216168 | 2022-02-14 | Augusta | Virginia | 51015 | 18325 | 178 |
2212917 | 2212917 | 2022-02-13 | Augusta | Virginia | 51015 | 18211 | 176 |
2209664 | 2209664 | 2022-02-12 | Augusta | Virginia | 51015 | 18211 | 176 |
2206411 | 2206411 | 2022-02-11 | Augusta | Virginia | 51015 | 18211 | 176 |
2203158 | 2203158 | 2022-02-10 | Augusta | Virginia | 51015 | 18142 | 175 |
2199904 | 2199904 | 2022-02-09 | Augusta | Virginia | 51015 | 18029 | 174 |
2196650 | 2196650 | 2022-02-08 | Augusta | Virginia | 51015 | 17965 | 174 |
2193395 | 2193395 | 2022-02-07 | Augusta | Virginia | 51015 | 17909 | 170 |
2190142 | 2190142 | 2022-02-06 | Augusta | Virginia | 51015 | 17662 | 163 |
2186889 | 2186889 | 2022-02-05 | Augusta | Virginia | 51015 | 17662 | 163 |
2183636 | 2183636 | 2022-02-04 | Augusta | Virginia | 51015 | 17662 | 163 |
2180384 | 2180384 | 2022-02-03 | Augusta | Virginia | 51015 | 17544 | 160 |
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);