ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Franklin city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499296 | 2499296 | 2022-05-12 | Franklin city | Virginia | 51620 | 2396 | 52 |
2496038 | 2496038 | 2022-05-11 | Franklin city | Virginia | 51620 | 2398 | 52 |
2492780 | 2492780 | 2022-05-10 | Franklin city | Virginia | 51620 | 2398 | 52 |
2489522 | 2489522 | 2022-05-09 | Franklin city | Virginia | 51620 | 2399 | 52 |
2486265 | 2486265 | 2022-05-08 | Franklin city | Virginia | 51620 | 2399 | 52 |
2483007 | 2483007 | 2022-05-07 | Franklin city | Virginia | 51620 | 2399 | 52 |
2479749 | 2479749 | 2022-05-06 | Franklin city | Virginia | 51620 | 2399 | 52 |
2476491 | 2476491 | 2022-05-05 | Franklin city | Virginia | 51620 | 2399 | 52 |
2473233 | 2473233 | 2022-05-04 | Franklin city | Virginia | 51620 | 2399 | 52 |
2469977 | 2469977 | 2022-05-03 | Franklin city | Virginia | 51620 | 2399 | 52 |
2466721 | 2466721 | 2022-05-02 | Franklin city | Virginia | 51620 | 2397 | 52 |
2463466 | 2463466 | 2022-05-01 | Franklin city | Virginia | 51620 | 2397 | 52 |
2460210 | 2460210 | 2022-04-30 | Franklin city | Virginia | 51620 | 2397 | 52 |
2456954 | 2456954 | 2022-04-29 | Franklin city | Virginia | 51620 | 2397 | 52 |
2453698 | 2453698 | 2022-04-28 | Franklin city | Virginia | 51620 | 2407 | 52 |
2450442 | 2450442 | 2022-04-27 | Franklin city | Virginia | 51620 | 2415 | 52 |
2447185 | 2447185 | 2022-04-26 | Franklin city | Virginia | 51620 | 2427 | 53 |
2443930 | 2443930 | 2022-04-25 | Franklin city | Virginia | 51620 | 2432 | 53 |
2440674 | 2440674 | 2022-04-24 | Franklin city | Virginia | 51620 | 2447 | 53 |
2437418 | 2437418 | 2022-04-23 | Franklin city | Virginia | 51620 | 2447 | 53 |
2434162 | 2434162 | 2022-04-22 | Franklin city | Virginia | 51620 | 2447 | 53 |
2430906 | 2430906 | 2022-04-21 | Franklin city | Virginia | 51620 | 2451 | 53 |
2427650 | 2427650 | 2022-04-20 | Franklin city | Virginia | 51620 | 2457 | 53 |
2424394 | 2424394 | 2022-04-19 | Franklin city | Virginia | 51620 | 2457 | 53 |
2421138 | 2421138 | 2022-04-18 | Franklin city | Virginia | 51620 | 2470 | 54 |
2417882 | 2417882 | 2022-04-17 | Franklin city | Virginia | 51620 | 2466 | 54 |
2414626 | 2414626 | 2022-04-16 | Franklin city | Virginia | 51620 | 2466 | 54 |
2411370 | 2411370 | 2022-04-15 | Franklin city | Virginia | 51620 | 2466 | 54 |
2408114 | 2408114 | 2022-04-14 | Franklin city | Virginia | 51620 | 2465 | 54 |
2404858 | 2404858 | 2022-04-13 | Franklin city | Virginia | 51620 | 2467 | 54 |
2401603 | 2401603 | 2022-04-12 | Franklin city | Virginia | 51620 | 2466 | 53 |
2398348 | 2398348 | 2022-04-11 | Franklin city | Virginia | 51620 | 2466 | 52 |
2395093 | 2395093 | 2022-04-10 | Franklin city | Virginia | 51620 | 2466 | 52 |
2391837 | 2391837 | 2022-04-09 | Franklin city | Virginia | 51620 | 2466 | 52 |
2388581 | 2388581 | 2022-04-08 | Franklin city | Virginia | 51620 | 2466 | 52 |
2385326 | 2385326 | 2022-04-07 | Franklin city | Virginia | 51620 | 2462 | 52 |
2382071 | 2382071 | 2022-04-06 | Franklin city | Virginia | 51620 | 2462 | 52 |
2378816 | 2378816 | 2022-04-05 | Franklin city | Virginia | 51620 | 2462 | 52 |
2375562 | 2375562 | 2022-04-04 | Franklin city | Virginia | 51620 | 2464 | 52 |
2372310 | 2372310 | 2022-04-03 | Franklin city | Virginia | 51620 | 2465 | 52 |
2369057 | 2369057 | 2022-04-02 | Franklin city | Virginia | 51620 | 2465 | 52 |
2365804 | 2365804 | 2022-04-01 | Franklin city | Virginia | 51620 | 2465 | 52 |
2362551 | 2362551 | 2022-03-31 | Franklin city | Virginia | 51620 | 2465 | 52 |
2359297 | 2359297 | 2022-03-30 | Franklin city | Virginia | 51620 | 2464 | 52 |
2356043 | 2356043 | 2022-03-29 | Franklin city | Virginia | 51620 | 2463 | 52 |
2352790 | 2352790 | 2022-03-28 | Franklin city | Virginia | 51620 | 2463 | 52 |
2349538 | 2349538 | 2022-03-27 | Franklin city | Virginia | 51620 | 2460 | 52 |
2346285 | 2346285 | 2022-03-26 | Franklin city | Virginia | 51620 | 2460 | 52 |
2343032 | 2343032 | 2022-03-25 | Franklin city | Virginia | 51620 | 2460 | 52 |
2339779 | 2339779 | 2022-03-24 | Franklin city | Virginia | 51620 | 2459 | 52 |
2336525 | 2336525 | 2022-03-23 | Franklin city | Virginia | 51620 | 2457 | 52 |
2333271 | 2333271 | 2022-03-22 | Franklin city | Virginia | 51620 | 2454 | 51 |
2330018 | 2330018 | 2022-03-21 | Franklin city | Virginia | 51620 | 2454 | 51 |
2326766 | 2326766 | 2022-03-20 | Franklin city | Virginia | 51620 | 2455 | 51 |
2323513 | 2323513 | 2022-03-19 | Franklin city | Virginia | 51620 | 2455 | 51 |
2320259 | 2320259 | 2022-03-18 | Franklin city | Virginia | 51620 | 2455 | 51 |
2317005 | 2317005 | 2022-03-17 | Franklin city | Virginia | 51620 | 2455 | 51 |
2313752 | 2313752 | 2022-03-16 | Franklin city | Virginia | 51620 | 2455 | 51 |
2310499 | 2310499 | 2022-03-15 | Franklin city | Virginia | 51620 | 2456 | 51 |
2307246 | 2307246 | 2022-03-14 | Franklin city | Virginia | 51620 | 2456 | 51 |
2303995 | 2303995 | 2022-03-13 | Franklin city | Virginia | 51620 | 2457 | 50 |
2300743 | 2300743 | 2022-03-12 | Franklin city | Virginia | 51620 | 2457 | 50 |
2297491 | 2297491 | 2022-03-11 | Franklin city | Virginia | 51620 | 2457 | 50 |
2294239 | 2294239 | 2022-03-10 | Franklin city | Virginia | 51620 | 2457 | 50 |
2290987 | 2290987 | 2022-03-09 | Franklin city | Virginia | 51620 | 2458 | 50 |
2287735 | 2287735 | 2022-03-08 | Franklin city | Virginia | 51620 | 2457 | 50 |
2284483 | 2284483 | 2022-03-07 | Franklin city | Virginia | 51620 | 2457 | 50 |
2281231 | 2281231 | 2022-03-06 | Franklin city | Virginia | 51620 | 2457 | 50 |
2277978 | 2277978 | 2022-03-05 | Franklin city | Virginia | 51620 | 2457 | 50 |
2274725 | 2274725 | 2022-03-04 | Franklin city | Virginia | 51620 | 2457 | 50 |
2271472 | 2271472 | 2022-03-03 | Franklin city | Virginia | 51620 | 2457 | 49 |
2268220 | 2268220 | 2022-03-02 | Franklin city | Virginia | 51620 | 2457 | 48 |
2264967 | 2264967 | 2022-03-01 | Franklin city | Virginia | 51620 | 2457 | 48 |
2261717 | 2261717 | 2022-02-28 | Franklin city | Virginia | 51620 | 2457 | 48 |
2258466 | 2258466 | 2022-02-27 | Franklin city | Virginia | 51620 | 2455 | 48 |
2255215 | 2255215 | 2022-02-26 | Franklin city | Virginia | 51620 | 2455 | 48 |
2251964 | 2251964 | 2022-02-25 | Franklin city | Virginia | 51620 | 2455 | 48 |
2248713 | 2248713 | 2022-02-24 | Franklin city | Virginia | 51620 | 2452 | 46 |
2245462 | 2245462 | 2022-02-23 | Franklin city | Virginia | 51620 | 2451 | 46 |
2242211 | 2242211 | 2022-02-22 | Franklin city | Virginia | 51620 | 2450 | 46 |
2238960 | 2238960 | 2022-02-21 | Franklin city | Virginia | 51620 | 2448 | 45 |
2235709 | 2235709 | 2022-02-20 | Franklin city | Virginia | 51620 | 2443 | 45 |
2232458 | 2232458 | 2022-02-19 | Franklin city | Virginia | 51620 | 2443 | 45 |
2229207 | 2229207 | 2022-02-18 | Franklin city | Virginia | 51620 | 2443 | 45 |
2225956 | 2225956 | 2022-02-17 | Franklin city | Virginia | 51620 | 2443 | 45 |
2222705 | 2222705 | 2022-02-16 | Franklin city | Virginia | 51620 | 2437 | 45 |
2219454 | 2219454 | 2022-02-15 | Franklin city | Virginia | 51620 | 2439 | 44 |
2216204 | 2216204 | 2022-02-14 | Franklin city | Virginia | 51620 | 2439 | 44 |
2212953 | 2212953 | 2022-02-13 | Franklin city | Virginia | 51620 | 2437 | 44 |
2209700 | 2209700 | 2022-02-12 | Franklin city | Virginia | 51620 | 2437 | 44 |
2206447 | 2206447 | 2022-02-11 | Franklin city | Virginia | 51620 | 2437 | 44 |
2203194 | 2203194 | 2022-02-10 | Franklin city | Virginia | 51620 | 2435 | 44 |
2199940 | 2199940 | 2022-02-09 | Franklin city | Virginia | 51620 | 2432 | 44 |
2196686 | 2196686 | 2022-02-08 | Franklin city | Virginia | 51620 | 2430 | 44 |
2193431 | 2193431 | 2022-02-07 | Franklin city | Virginia | 51620 | 2426 | 44 |
2190178 | 2190178 | 2022-02-06 | Franklin city | Virginia | 51620 | 2416 | 43 |
2186925 | 2186925 | 2022-02-05 | Franklin city | Virginia | 51620 | 2416 | 43 |
2183672 | 2183672 | 2022-02-04 | Franklin city | Virginia | 51620 | 2416 | 43 |
2180420 | 2180420 | 2022-02-03 | Franklin city | Virginia | 51620 | 2411 | 43 |
2177169 | 2177169 | 2022-02-02 | Franklin city | Virginia | 51620 | 2403 | 43 |
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);