ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
735 rows where fips = 51580 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502538 | 2502538 | 2022-05-13 | Covington city | Virginia | 51580 | 1299 | 26 |
2499280 | 2499280 | 2022-05-12 | Covington city | Virginia | 51580 | 1300 | 26 |
2496022 | 2496022 | 2022-05-11 | Covington city | Virginia | 51580 | 1300 | 26 |
2492764 | 2492764 | 2022-05-10 | Covington city | Virginia | 51580 | 1299 | 26 |
2489506 | 2489506 | 2022-05-09 | Covington city | Virginia | 51580 | 1296 | 26 |
2486249 | 2486249 | 2022-05-08 | Covington city | Virginia | 51580 | 1292 | 26 |
2482991 | 2482991 | 2022-05-07 | Covington city | Virginia | 51580 | 1292 | 26 |
2479733 | 2479733 | 2022-05-06 | Covington city | Virginia | 51580 | 1292 | 26 |
2476475 | 2476475 | 2022-05-05 | Covington city | Virginia | 51580 | 1290 | 26 |
2473217 | 2473217 | 2022-05-04 | Covington city | Virginia | 51580 | 1288 | 26 |
2469961 | 2469961 | 2022-05-03 | Covington city | Virginia | 51580 | 1285 | 26 |
2466705 | 2466705 | 2022-05-02 | Covington city | Virginia | 51580 | 1284 | 26 |
2463450 | 2463450 | 2022-05-01 | Covington city | Virginia | 51580 | 1280 | 26 |
2460194 | 2460194 | 2022-04-30 | Covington city | Virginia | 51580 | 1280 | 26 |
2456938 | 2456938 | 2022-04-29 | Covington city | Virginia | 51580 | 1280 | 26 |
2453682 | 2453682 | 2022-04-28 | Covington city | Virginia | 51580 | 1278 | 26 |
2450426 | 2450426 | 2022-04-27 | Covington city | Virginia | 51580 | 1275 | 26 |
2447169 | 2447169 | 2022-04-26 | Covington city | Virginia | 51580 | 1273 | 26 |
2443914 | 2443914 | 2022-04-25 | Covington city | Virginia | 51580 | 1271 | 26 |
2440658 | 2440658 | 2022-04-24 | Covington city | Virginia | 51580 | 1269 | 26 |
2437402 | 2437402 | 2022-04-23 | Covington city | Virginia | 51580 | 1269 | 26 |
2434146 | 2434146 | 2022-04-22 | Covington city | Virginia | 51580 | 1269 | 26 |
2430890 | 2430890 | 2022-04-21 | Covington city | Virginia | 51580 | 1266 | 26 |
2427634 | 2427634 | 2022-04-20 | Covington city | Virginia | 51580 | 1264 | 26 |
2424378 | 2424378 | 2022-04-19 | Covington city | Virginia | 51580 | 1262 | 26 |
2421122 | 2421122 | 2022-04-18 | Covington city | Virginia | 51580 | 1260 | 26 |
2417866 | 2417866 | 2022-04-17 | Covington city | Virginia | 51580 | 1257 | 26 |
2414610 | 2414610 | 2022-04-16 | Covington city | Virginia | 51580 | 1257 | 26 |
2411354 | 2411354 | 2022-04-15 | Covington city | Virginia | 51580 | 1257 | 26 |
2408098 | 2408098 | 2022-04-14 | Covington city | Virginia | 51580 | 1256 | 26 |
2404842 | 2404842 | 2022-04-13 | Covington city | Virginia | 51580 | 1254 | 26 |
2401587 | 2401587 | 2022-04-12 | Covington city | Virginia | 51580 | 1253 | 26 |
2398332 | 2398332 | 2022-04-11 | Covington city | Virginia | 51580 | 1251 | 26 |
2395077 | 2395077 | 2022-04-10 | Covington city | Virginia | 51580 | 1248 | 26 |
2391821 | 2391821 | 2022-04-09 | Covington city | Virginia | 51580 | 1248 | 26 |
2388565 | 2388565 | 2022-04-08 | Covington city | Virginia | 51580 | 1248 | 26 |
2385310 | 2385310 | 2022-04-07 | Covington city | Virginia | 51580 | 1244 | 26 |
2382055 | 2382055 | 2022-04-06 | Covington city | Virginia | 51580 | 1241 | 26 |
2378800 | 2378800 | 2022-04-05 | Covington city | Virginia | 51580 | 1241 | 26 |
2375546 | 2375546 | 2022-04-04 | Covington city | Virginia | 51580 | 1241 | 26 |
2372294 | 2372294 | 2022-04-03 | Covington city | Virginia | 51580 | 1229 | 26 |
2369041 | 2369041 | 2022-04-02 | Covington city | Virginia | 51580 | 1229 | 26 |
2365788 | 2365788 | 2022-04-01 | Covington city | Virginia | 51580 | 1229 | 26 |
2362535 | 2362535 | 2022-03-31 | Covington city | Virginia | 51580 | 1209 | 26 |
2359281 | 2359281 | 2022-03-30 | Covington city | Virginia | 51580 | 1188 | 26 |
2356027 | 2356027 | 2022-03-29 | Covington city | Virginia | 51580 | 1178 | 26 |
2352774 | 2352774 | 2022-03-28 | Covington city | Virginia | 51580 | 1161 | 26 |
2349522 | 2349522 | 2022-03-27 | Covington city | Virginia | 51580 | 1147 | 25 |
2346269 | 2346269 | 2022-03-26 | Covington city | Virginia | 51580 | 1147 | 25 |
2343016 | 2343016 | 2022-03-25 | Covington city | Virginia | 51580 | 1147 | 25 |
2339763 | 2339763 | 2022-03-24 | Covington city | Virginia | 51580 | 1134 | 25 |
2336509 | 2336509 | 2022-03-23 | Covington city | Virginia | 51580 | 1133 | 25 |
2333255 | 2333255 | 2022-03-22 | Covington city | Virginia | 51580 | 1121 | 25 |
2330002 | 2330002 | 2022-03-21 | Covington city | Virginia | 51580 | 1121 | 25 |
2326750 | 2326750 | 2022-03-20 | Covington city | Virginia | 51580 | 1117 | 25 |
2323497 | 2323497 | 2022-03-19 | Covington city | Virginia | 51580 | 1117 | 25 |
2320243 | 2320243 | 2022-03-18 | Covington city | Virginia | 51580 | 1117 | 25 |
2316989 | 2316989 | 2022-03-17 | Covington city | Virginia | 51580 | 1105 | 25 |
2313736 | 2313736 | 2022-03-16 | Covington city | Virginia | 51580 | 1101 | 25 |
2310483 | 2310483 | 2022-03-15 | Covington city | Virginia | 51580 | 1099 | 25 |
2307230 | 2307230 | 2022-03-14 | Covington city | Virginia | 51580 | 1096 | 25 |
2303979 | 2303979 | 2022-03-13 | Covington city | Virginia | 51580 | 1030 | 25 |
2300727 | 2300727 | 2022-03-12 | Covington city | Virginia | 51580 | 1030 | 25 |
2297475 | 2297475 | 2022-03-11 | Covington city | Virginia | 51580 | 1030 | 25 |
2294223 | 2294223 | 2022-03-10 | Covington city | Virginia | 51580 | 1009 | 24 |
2290971 | 2290971 | 2022-03-09 | Covington city | Virginia | 51580 | 1000 | 24 |
2287719 | 2287719 | 2022-03-08 | Covington city | Virginia | 51580 | 999 | 24 |
2284467 | 2284467 | 2022-03-07 | Covington city | Virginia | 51580 | 998 | 24 |
2281215 | 2281215 | 2022-03-06 | Covington city | Virginia | 51580 | 997 | 24 |
2277962 | 2277962 | 2022-03-05 | Covington city | Virginia | 51580 | 997 | 24 |
2274709 | 2274709 | 2022-03-04 | Covington city | Virginia | 51580 | 997 | 24 |
2271456 | 2271456 | 2022-03-03 | Covington city | Virginia | 51580 | 996 | 24 |
2268204 | 2268204 | 2022-03-02 | Covington city | Virginia | 51580 | 994 | 23 |
2264951 | 2264951 | 2022-03-01 | Covington city | Virginia | 51580 | 995 | 23 |
2261701 | 2261701 | 2022-02-28 | Covington city | Virginia | 51580 | 993 | 23 |
2258450 | 2258450 | 2022-02-27 | Covington city | Virginia | 51580 | 992 | 23 |
2255199 | 2255199 | 2022-02-26 | Covington city | Virginia | 51580 | 992 | 23 |
2251948 | 2251948 | 2022-02-25 | Covington city | Virginia | 51580 | 992 | 23 |
2248697 | 2248697 | 2022-02-24 | Covington city | Virginia | 51580 | 989 | 23 |
2245446 | 2245446 | 2022-02-23 | Covington city | Virginia | 51580 | 987 | 23 |
2242195 | 2242195 | 2022-02-22 | Covington city | Virginia | 51580 | 987 | 23 |
2238944 | 2238944 | 2022-02-21 | Covington city | Virginia | 51580 | 987 | 23 |
2235693 | 2235693 | 2022-02-20 | Covington city | Virginia | 51580 | 987 | 23 |
2232442 | 2232442 | 2022-02-19 | Covington city | Virginia | 51580 | 987 | 23 |
2229191 | 2229191 | 2022-02-18 | Covington city | Virginia | 51580 | 987 | 23 |
2225940 | 2225940 | 2022-02-17 | Covington city | Virginia | 51580 | 977 | 23 |
2222689 | 2222689 | 2022-02-16 | Covington city | Virginia | 51580 | 970 | 23 |
2219438 | 2219438 | 2022-02-15 | Covington city | Virginia | 51580 | 989 | 23 |
2216188 | 2216188 | 2022-02-14 | Covington city | Virginia | 51580 | 992 | 23 |
2212937 | 2212937 | 2022-02-13 | Covington city | Virginia | 51580 | 912 | 20 |
2209684 | 2209684 | 2022-02-12 | Covington city | Virginia | 51580 | 912 | 20 |
2206431 | 2206431 | 2022-02-11 | Covington city | Virginia | 51580 | 912 | 20 |
2203178 | 2203178 | 2022-02-10 | Covington city | Virginia | 51580 | 909 | 20 |
2199924 | 2199924 | 2022-02-09 | Covington city | Virginia | 51580 | 961 | 21 |
2196670 | 2196670 | 2022-02-08 | Covington city | Virginia | 51580 | 960 | 21 |
2193415 | 2193415 | 2022-02-07 | Covington city | Virginia | 51580 | 954 | 21 |
2190162 | 2190162 | 2022-02-06 | Covington city | Virginia | 51580 | 941 | 21 |
2186909 | 2186909 | 2022-02-05 | Covington city | Virginia | 51580 | 941 | 21 |
2183656 | 2183656 | 2022-02-04 | Covington city | Virginia | 51580 | 941 | 21 |
2180404 | 2180404 | 2022-02-03 | Covington city | Virginia | 51580 | 936 | 21 |
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);