ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,447 rows where county = "Bath" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500584 | 2500584 | 2022-05-13 | Bath | Kentucky | 21011 | 3210 | 48 |
2502519 | 2502519 | 2022-05-13 | Bath | Virginia | 51017 | 906 | 20 |
2497326 | 2497326 | 2022-05-12 | Bath | Kentucky | 21011 | 3210 | 48 |
2499261 | 2499261 | 2022-05-12 | Bath | Virginia | 51017 | 905 | 20 |
2494068 | 2494068 | 2022-05-11 | Bath | Kentucky | 21011 | 3210 | 48 |
2496003 | 2496003 | 2022-05-11 | Bath | Virginia | 51017 | 903 | 20 |
2490810 | 2490810 | 2022-05-10 | Bath | Kentucky | 21011 | 3210 | 48 |
2492745 | 2492745 | 2022-05-10 | Bath | Virginia | 51017 | 902 | 20 |
2487553 | 2487553 | 2022-05-09 | Bath | Kentucky | 21011 | 3210 | 48 |
2489487 | 2489487 | 2022-05-09 | Bath | Virginia | 51017 | 902 | 20 |
2484295 | 2484295 | 2022-05-08 | Bath | Kentucky | 21011 | 3199 | 45 |
2486230 | 2486230 | 2022-05-08 | Bath | Virginia | 51017 | 901 | 20 |
2481037 | 2481037 | 2022-05-07 | Bath | Kentucky | 21011 | 3199 | 45 |
2482972 | 2482972 | 2022-05-07 | Bath | Virginia | 51017 | 901 | 20 |
2477779 | 2477779 | 2022-05-06 | Bath | Kentucky | 21011 | 3199 | 45 |
2479714 | 2479714 | 2022-05-06 | Bath | Virginia | 51017 | 901 | 20 |
2474521 | 2474521 | 2022-05-05 | Bath | Kentucky | 21011 | 3199 | 45 |
2476456 | 2476456 | 2022-05-05 | Bath | Virginia | 51017 | 898 | 20 |
2471264 | 2471264 | 2022-05-04 | Bath | Kentucky | 21011 | 3199 | 45 |
2473198 | 2473198 | 2022-05-04 | Bath | Virginia | 51017 | 898 | 20 |
2468008 | 2468008 | 2022-05-03 | Bath | Kentucky | 21011 | 3199 | 45 |
2469942 | 2469942 | 2022-05-03 | Bath | Virginia | 51017 | 898 | 20 |
2464753 | 2464753 | 2022-05-02 | Bath | Kentucky | 21011 | 3199 | 45 |
2466686 | 2466686 | 2022-05-02 | Bath | Virginia | 51017 | 898 | 20 |
2461497 | 2461497 | 2022-05-01 | Bath | Kentucky | 21011 | 3198 | 44 |
2463431 | 2463431 | 2022-05-01 | Bath | Virginia | 51017 | 898 | 20 |
2458241 | 2458241 | 2022-04-30 | Bath | Kentucky | 21011 | 3198 | 44 |
2460175 | 2460175 | 2022-04-30 | Bath | Virginia | 51017 | 898 | 20 |
2454985 | 2454985 | 2022-04-29 | Bath | Kentucky | 21011 | 3198 | 44 |
2456919 | 2456919 | 2022-04-29 | Bath | Virginia | 51017 | 898 | 20 |
2451729 | 2451729 | 2022-04-28 | Bath | Kentucky | 21011 | 3198 | 44 |
2453663 | 2453663 | 2022-04-28 | Bath | Virginia | 51017 | 898 | 20 |
2448473 | 2448473 | 2022-04-27 | Bath | Kentucky | 21011 | 3198 | 44 |
2450407 | 2450407 | 2022-04-27 | Bath | Virginia | 51017 | 896 | 20 |
2445217 | 2445217 | 2022-04-26 | Bath | Kentucky | 21011 | 3198 | 44 |
2447150 | 2447150 | 2022-04-26 | Bath | Virginia | 51017 | 894 | 20 |
2441961 | 2441961 | 2022-04-25 | Bath | Kentucky | 21011 | 3198 | 44 |
2443895 | 2443895 | 2022-04-25 | Bath | Virginia | 51017 | 894 | 20 |
2438705 | 2438705 | 2022-04-24 | Bath | Kentucky | 21011 | 3176 | 44 |
2440639 | 2440639 | 2022-04-24 | Bath | Virginia | 51017 | 893 | 20 |
2435449 | 2435449 | 2022-04-23 | Bath | Kentucky | 21011 | 3176 | 44 |
2437383 | 2437383 | 2022-04-23 | Bath | Virginia | 51017 | 893 | 20 |
2432193 | 2432193 | 2022-04-22 | Bath | Kentucky | 21011 | 3176 | 44 |
2434127 | 2434127 | 2022-04-22 | Bath | Virginia | 51017 | 893 | 20 |
2428937 | 2428937 | 2022-04-21 | Bath | Kentucky | 21011 | 3176 | 44 |
2430871 | 2430871 | 2022-04-21 | Bath | Virginia | 51017 | 893 | 20 |
2425681 | 2425681 | 2022-04-20 | Bath | Kentucky | 21011 | 3176 | 44 |
2427615 | 2427615 | 2022-04-20 | Bath | Virginia | 51017 | 893 | 20 |
2422425 | 2422425 | 2022-04-19 | Bath | Kentucky | 21011 | 3176 | 44 |
2424359 | 2424359 | 2022-04-19 | Bath | Virginia | 51017 | 894 | 20 |
2419169 | 2419169 | 2022-04-18 | Bath | Kentucky | 21011 | 3176 | 44 |
2421103 | 2421103 | 2022-04-18 | Bath | Virginia | 51017 | 894 | 20 |
2415913 | 2415913 | 2022-04-17 | Bath | Kentucky | 21011 | 3139 | 43 |
2417847 | 2417847 | 2022-04-17 | Bath | Virginia | 51017 | 894 | 20 |
2412657 | 2412657 | 2022-04-16 | Bath | Kentucky | 21011 | 3139 | 43 |
2414591 | 2414591 | 2022-04-16 | Bath | Virginia | 51017 | 894 | 20 |
2409401 | 2409401 | 2022-04-15 | Bath | Kentucky | 21011 | 3139 | 43 |
2411335 | 2411335 | 2022-04-15 | Bath | Virginia | 51017 | 894 | 20 |
2406145 | 2406145 | 2022-04-14 | Bath | Kentucky | 21011 | 3139 | 43 |
2408079 | 2408079 | 2022-04-14 | Bath | Virginia | 51017 | 894 | 20 |
2402889 | 2402889 | 2022-04-13 | Bath | Kentucky | 21011 | 3139 | 43 |
2404823 | 2404823 | 2022-04-13 | Bath | Virginia | 51017 | 894 | 20 |
2399635 | 2399635 | 2022-04-12 | Bath | Kentucky | 21011 | 3139 | 43 |
2401568 | 2401568 | 2022-04-12 | Bath | Virginia | 51017 | 894 | 20 |
2396379 | 2396379 | 2022-04-11 | Bath | Kentucky | 21011 | 3139 | 43 |
2398313 | 2398313 | 2022-04-11 | Bath | Virginia | 51017 | 894 | 20 |
2393124 | 2393124 | 2022-04-10 | Bath | Kentucky | 21011 | 3081 | 43 |
2395058 | 2395058 | 2022-04-10 | Bath | Virginia | 51017 | 893 | 20 |
2389868 | 2389868 | 2022-04-09 | Bath | Kentucky | 21011 | 3081 | 43 |
2391802 | 2391802 | 2022-04-09 | Bath | Virginia | 51017 | 893 | 20 |
2386612 | 2386612 | 2022-04-08 | Bath | Kentucky | 21011 | 3081 | 43 |
2388546 | 2388546 | 2022-04-08 | Bath | Virginia | 51017 | 893 | 20 |
2383357 | 2383357 | 2022-04-07 | Bath | Kentucky | 21011 | 3081 | 43 |
2385291 | 2385291 | 2022-04-07 | Bath | Virginia | 51017 | 893 | 20 |
2380102 | 2380102 | 2022-04-06 | Bath | Kentucky | 21011 | 3081 | 43 |
2382036 | 2382036 | 2022-04-06 | Bath | Virginia | 51017 | 893 | 20 |
2376847 | 2376847 | 2022-04-05 | Bath | Kentucky | 21011 | 3081 | 43 |
2378781 | 2378781 | 2022-04-05 | Bath | Virginia | 51017 | 893 | 20 |
2373595 | 2373595 | 2022-04-04 | Bath | Kentucky | 21011 | 3081 | 43 |
2375527 | 2375527 | 2022-04-04 | Bath | Virginia | 51017 | 893 | 20 |
2370342 | 2370342 | 2022-04-03 | Bath | Kentucky | 21011 | 3055 | 42 |
2372275 | 2372275 | 2022-04-03 | Bath | Virginia | 51017 | 892 | 20 |
2367089 | 2367089 | 2022-04-02 | Bath | Kentucky | 21011 | 3055 | 42 |
2369022 | 2369022 | 2022-04-02 | Bath | Virginia | 51017 | 892 | 20 |
2363836 | 2363836 | 2022-04-01 | Bath | Kentucky | 21011 | 3055 | 42 |
2365769 | 2365769 | 2022-04-01 | Bath | Virginia | 51017 | 892 | 20 |
2360582 | 2360582 | 2022-03-31 | Bath | Kentucky | 21011 | 3055 | 42 |
2362516 | 2362516 | 2022-03-31 | Bath | Virginia | 51017 | 891 | 20 |
2357328 | 2357328 | 2022-03-30 | Bath | Kentucky | 21011 | 3055 | 42 |
2359262 | 2359262 | 2022-03-30 | Bath | Virginia | 51017 | 891 | 20 |
2354075 | 2354075 | 2022-03-29 | Bath | Kentucky | 21011 | 3055 | 42 |
2356008 | 2356008 | 2022-03-29 | Bath | Virginia | 51017 | 892 | 20 |
2350823 | 2350823 | 2022-03-28 | Bath | Kentucky | 21011 | 3055 | 42 |
2352755 | 2352755 | 2022-03-28 | Bath | Virginia | 51017 | 892 | 20 |
2347570 | 2347570 | 2022-03-27 | Bath | Kentucky | 21011 | 3012 | 40 |
2349503 | 2349503 | 2022-03-27 | Bath | Virginia | 51017 | 891 | 20 |
2344317 | 2344317 | 2022-03-26 | Bath | Kentucky | 21011 | 3012 | 40 |
2346250 | 2346250 | 2022-03-26 | Bath | Virginia | 51017 | 891 | 20 |
2341064 | 2341064 | 2022-03-25 | Bath | Kentucky | 21011 | 3012 | 40 |
2342997 | 2342997 | 2022-03-25 | Bath | Virginia | 51017 | 891 | 20 |
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);