ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Lexington city" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502579 | 2502579 | 2022-05-13 | Lexington city | Virginia | 51678 | 2857 | 40 |
2499321 | 2499321 | 2022-05-12 | Lexington city | Virginia | 51678 | 2855 | 40 |
2496063 | 2496063 | 2022-05-11 | Lexington city | Virginia | 51678 | 2849 | 40 |
2492805 | 2492805 | 2022-05-10 | Lexington city | Virginia | 51678 | 2848 | 40 |
2489547 | 2489547 | 2022-05-09 | Lexington city | Virginia | 51678 | 2849 | 40 |
2486290 | 2486290 | 2022-05-08 | Lexington city | Virginia | 51678 | 2847 | 40 |
2483032 | 2483032 | 2022-05-07 | Lexington city | Virginia | 51678 | 2847 | 40 |
2479774 | 2479774 | 2022-05-06 | Lexington city | Virginia | 51678 | 2847 | 40 |
2476516 | 2476516 | 2022-05-05 | Lexington city | Virginia | 51678 | 2847 | 40 |
2473258 | 2473258 | 2022-05-04 | Lexington city | Virginia | 51678 | 2843 | 40 |
2470002 | 2470002 | 2022-05-03 | Lexington city | Virginia | 51678 | 2842 | 40 |
2466746 | 2466746 | 2022-05-02 | Lexington city | Virginia | 51678 | 2841 | 40 |
2463491 | 2463491 | 2022-05-01 | Lexington city | Virginia | 51678 | 2839 | 40 |
2460235 | 2460235 | 2022-04-30 | Lexington city | Virginia | 51678 | 2839 | 40 |
2456979 | 2456979 | 2022-04-29 | Lexington city | Virginia | 51678 | 2839 | 40 |
2453723 | 2453723 | 2022-04-28 | Lexington city | Virginia | 51678 | 2840 | 40 |
2450467 | 2450467 | 2022-04-27 | Lexington city | Virginia | 51678 | 2838 | 40 |
2447210 | 2447210 | 2022-04-26 | Lexington city | Virginia | 51678 | 2835 | 40 |
2443955 | 2443955 | 2022-04-25 | Lexington city | Virginia | 51678 | 2837 | 40 |
2440699 | 2440699 | 2022-04-24 | Lexington city | Virginia | 51678 | 2837 | 40 |
2437443 | 2437443 | 2022-04-23 | Lexington city | Virginia | 51678 | 2837 | 40 |
2434187 | 2434187 | 2022-04-22 | Lexington city | Virginia | 51678 | 2837 | 40 |
2430931 | 2430931 | 2022-04-21 | Lexington city | Virginia | 51678 | 2836 | 40 |
2427675 | 2427675 | 2022-04-20 | Lexington city | Virginia | 51678 | 2832 | 40 |
2424419 | 2424419 | 2022-04-19 | Lexington city | Virginia | 51678 | 2831 | 40 |
2421163 | 2421163 | 2022-04-18 | Lexington city | Virginia | 51678 | 2832 | 40 |
2417907 | 2417907 | 2022-04-17 | Lexington city | Virginia | 51678 | 2829 | 40 |
2414651 | 2414651 | 2022-04-16 | Lexington city | Virginia | 51678 | 2829 | 40 |
2411395 | 2411395 | 2022-04-15 | Lexington city | Virginia | 51678 | 2829 | 40 |
2408139 | 2408139 | 2022-04-14 | Lexington city | Virginia | 51678 | 2828 | 40 |
2404883 | 2404883 | 2022-04-13 | Lexington city | Virginia | 51678 | 2828 | 40 |
2401628 | 2401628 | 2022-04-12 | Lexington city | Virginia | 51678 | 2828 | 40 |
2398373 | 2398373 | 2022-04-11 | Lexington city | Virginia | 51678 | 2828 | 40 |
2395118 | 2395118 | 2022-04-10 | Lexington city | Virginia | 51678 | 2827 | 40 |
2391862 | 2391862 | 2022-04-09 | Lexington city | Virginia | 51678 | 2827 | 40 |
2388606 | 2388606 | 2022-04-08 | Lexington city | Virginia | 51678 | 2827 | 40 |
2385351 | 2385351 | 2022-04-07 | Lexington city | Virginia | 51678 | 2827 | 40 |
2382096 | 2382096 | 2022-04-06 | Lexington city | Virginia | 51678 | 2826 | 40 |
2378841 | 2378841 | 2022-04-05 | Lexington city | Virginia | 51678 | 2826 | 40 |
2375587 | 2375587 | 2022-04-04 | Lexington city | Virginia | 51678 | 2826 | 40 |
2372335 | 2372335 | 2022-04-03 | Lexington city | Virginia | 51678 | 2826 | 40 |
2369082 | 2369082 | 2022-04-02 | Lexington city | Virginia | 51678 | 2826 | 40 |
2365829 | 2365829 | 2022-04-01 | Lexington city | Virginia | 51678 | 2826 | 40 |
2362576 | 2362576 | 2022-03-31 | Lexington city | Virginia | 51678 | 2825 | 40 |
2359322 | 2359322 | 2022-03-30 | Lexington city | Virginia | 51678 | 2826 | 40 |
2356068 | 2356068 | 2022-03-29 | Lexington city | Virginia | 51678 | 2826 | 40 |
2352815 | 2352815 | 2022-03-28 | Lexington city | Virginia | 51678 | 2827 | 40 |
2349563 | 2349563 | 2022-03-27 | Lexington city | Virginia | 51678 | 2829 | 40 |
2346310 | 2346310 | 2022-03-26 | Lexington city | Virginia | 51678 | 2829 | 40 |
2343057 | 2343057 | 2022-03-25 | Lexington city | Virginia | 51678 | 2829 | 40 |
2339804 | 2339804 | 2022-03-24 | Lexington city | Virginia | 51678 | 2829 | 40 |
2336550 | 2336550 | 2022-03-23 | Lexington city | Virginia | 51678 | 2826 | 40 |
2333296 | 2333296 | 2022-03-22 | Lexington city | Virginia | 51678 | 2824 | 40 |
2330043 | 2330043 | 2022-03-21 | Lexington city | Virginia | 51678 | 2824 | 40 |
2326791 | 2326791 | 2022-03-20 | Lexington city | Virginia | 51678 | 2824 | 39 |
2323538 | 2323538 | 2022-03-19 | Lexington city | Virginia | 51678 | 2824 | 39 |
2320284 | 2320284 | 2022-03-18 | Lexington city | Virginia | 51678 | 2824 | 39 |
2317030 | 2317030 | 2022-03-17 | Lexington city | Virginia | 51678 | 2819 | 39 |
2313777 | 2313777 | 2022-03-16 | Lexington city | Virginia | 51678 | 2818 | 39 |
2310524 | 2310524 | 2022-03-15 | Lexington city | Virginia | 51678 | 2818 | 39 |
2307271 | 2307271 | 2022-03-14 | Lexington city | Virginia | 51678 | 2818 | 39 |
2304020 | 2304020 | 2022-03-13 | Lexington city | Virginia | 51678 | 2828 | 39 |
2300768 | 2300768 | 2022-03-12 | Lexington city | Virginia | 51678 | 2828 | 39 |
2297516 | 2297516 | 2022-03-11 | Lexington city | Virginia | 51678 | 2828 | 39 |
2294264 | 2294264 | 2022-03-10 | Lexington city | Virginia | 51678 | 2827 | 39 |
2291012 | 2291012 | 2022-03-09 | Lexington city | Virginia | 51678 | 2825 | 39 |
2287760 | 2287760 | 2022-03-08 | Lexington city | Virginia | 51678 | 2821 | 39 |
2284508 | 2284508 | 2022-03-07 | Lexington city | Virginia | 51678 | 2820 | 39 |
2281256 | 2281256 | 2022-03-06 | Lexington city | Virginia | 51678 | 2816 | 39 |
2278003 | 2278003 | 2022-03-05 | Lexington city | Virginia | 51678 | 2816 | 39 |
2274750 | 2274750 | 2022-03-04 | Lexington city | Virginia | 51678 | 2816 | 39 |
2271497 | 2271497 | 2022-03-03 | Lexington city | Virginia | 51678 | 2814 | 39 |
2268245 | 2268245 | 2022-03-02 | Lexington city | Virginia | 51678 | 2809 | 39 |
2264992 | 2264992 | 2022-03-01 | Lexington city | Virginia | 51678 | 2808 | 39 |
2261742 | 2261742 | 2022-02-28 | Lexington city | Virginia | 51678 | 2807 | 39 |
2258491 | 2258491 | 2022-02-27 | Lexington city | Virginia | 51678 | 2801 | 39 |
2255240 | 2255240 | 2022-02-26 | Lexington city | Virginia | 51678 | 2801 | 39 |
2251989 | 2251989 | 2022-02-25 | Lexington city | Virginia | 51678 | 2801 | 39 |
2248738 | 2248738 | 2022-02-24 | Lexington city | Virginia | 51678 | 2795 | 39 |
2245487 | 2245487 | 2022-02-23 | Lexington city | Virginia | 51678 | 2792 | 39 |
2242236 | 2242236 | 2022-02-22 | Lexington city | Virginia | 51678 | 2787 | 39 |
2238985 | 2238985 | 2022-02-21 | Lexington city | Virginia | 51678 | 2787 | 39 |
2235734 | 2235734 | 2022-02-20 | Lexington city | Virginia | 51678 | 2769 | 39 |
2232483 | 2232483 | 2022-02-19 | Lexington city | Virginia | 51678 | 2769 | 39 |
2229232 | 2229232 | 2022-02-18 | Lexington city | Virginia | 51678 | 2769 | 39 |
2225981 | 2225981 | 2022-02-17 | Lexington city | Virginia | 51678 | 2767 | 39 |
2222730 | 2222730 | 2022-02-16 | Lexington city | Virginia | 51678 | 2760 | 39 |
2219479 | 2219479 | 2022-02-15 | Lexington city | Virginia | 51678 | 2753 | 39 |
2216229 | 2216229 | 2022-02-14 | Lexington city | Virginia | 51678 | 2743 | 39 |
2212978 | 2212978 | 2022-02-13 | Lexington city | Virginia | 51678 | 2738 | 39 |
2209725 | 2209725 | 2022-02-12 | Lexington city | Virginia | 51678 | 2738 | 39 |
2206472 | 2206472 | 2022-02-11 | Lexington city | Virginia | 51678 | 2738 | 39 |
2203219 | 2203219 | 2022-02-10 | Lexington city | Virginia | 51678 | 2721 | 39 |
2199965 | 2199965 | 2022-02-09 | Lexington city | Virginia | 51678 | 2703 | 39 |
2196711 | 2196711 | 2022-02-08 | Lexington city | Virginia | 51678 | 2694 | 39 |
2193456 | 2193456 | 2022-02-07 | Lexington city | Virginia | 51678 | 2684 | 39 |
2190203 | 2190203 | 2022-02-06 | Lexington city | Virginia | 51678 | 2637 | 38 |
2186950 | 2186950 | 2022-02-05 | Lexington city | Virginia | 51678 | 2637 | 38 |
2183697 | 2183697 | 2022-02-04 | Lexington city | Virginia | 51678 | 2637 | 38 |
2180445 | 2180445 | 2022-02-03 | Lexington city | Virginia | 51678 | 2616 | 38 |
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);