ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,895 rows where county = "Lyon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Lyon · 3,795 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2435297 | 2435297 | 2022-04-23 | Lyon | Iowa | 19119 | 2738 | 50 |
2435393 | 2435393 | 2022-04-23 | Lyon | Kansas | 20111 | 9972 | 121 |
2435515 | 2435515 | 2022-04-23 | Lyon | Kentucky | 21143 | 2864 | 33 |
2435811 | 2435811 | 2022-04-23 | Lyon | Minnesota | 27083 | 7066 | 72 |
2436218 | 2436218 | 2022-04-23 | Lyon | Nevada | 32019 | 10071 | 175 |
2432041 | 2432041 | 2022-04-22 | Lyon | Iowa | 19119 | 2738 | 50 |
2432137 | 2432137 | 2022-04-22 | Lyon | Kansas | 20111 | 9972 | 121 |
2432259 | 2432259 | 2022-04-22 | Lyon | Kentucky | 21143 | 2864 | 33 |
2432555 | 2432555 | 2022-04-22 | Lyon | Minnesota | 27083 | 7066 | 72 |
2432962 | 2432962 | 2022-04-22 | Lyon | Nevada | 32019 | 10071 | 175 |
2428785 | 2428785 | 2022-04-21 | Lyon | Iowa | 19119 | 2738 | 50 |
2428881 | 2428881 | 2022-04-21 | Lyon | Kansas | 20111 | 9965 | 121 |
2429003 | 2429003 | 2022-04-21 | Lyon | Kentucky | 21143 | 2864 | 33 |
2429299 | 2429299 | 2022-04-21 | Lyon | Minnesota | 27083 | 7062 | 72 |
2429706 | 2429706 | 2022-04-21 | Lyon | Nevada | 32019 | 10071 | 175 |
2425529 | 2425529 | 2022-04-20 | Lyon | Iowa | 19119 | 2738 | 50 |
2425625 | 2425625 | 2022-04-20 | Lyon | Kansas | 20111 | 9965 | 121 |
2425747 | 2425747 | 2022-04-20 | Lyon | Kentucky | 21143 | 2864 | 33 |
2426043 | 2426043 | 2022-04-20 | Lyon | Minnesota | 27083 | 7055 | 72 |
2426450 | 2426450 | 2022-04-20 | Lyon | Nevada | 32019 | 10071 | 175 |
2422273 | 2422273 | 2022-04-19 | Lyon | Iowa | 19119 | 2733 | 50 |
2422369 | 2422369 | 2022-04-19 | Lyon | Kansas | 20111 | 9965 | 120 |
2422491 | 2422491 | 2022-04-19 | Lyon | Kentucky | 21143 | 2864 | 33 |
2422787 | 2422787 | 2022-04-19 | Lyon | Minnesota | 27083 | 7051 | 72 |
2423194 | 2423194 | 2022-04-19 | Lyon | Nevada | 32019 | 10056 | 171 |
2419017 | 2419017 | 2022-04-18 | Lyon | Iowa | 19119 | 2733 | 50 |
2419113 | 2419113 | 2022-04-18 | Lyon | Kansas | 20111 | 9965 | 120 |
2419235 | 2419235 | 2022-04-18 | Lyon | Kentucky | 21143 | 2864 | 33 |
2419531 | 2419531 | 2022-04-18 | Lyon | Minnesota | 27083 | 7048 | 72 |
2419937 | 2419937 | 2022-04-18 | Lyon | Nevada | 32019 | 10056 | 171 |
2415761 | 2415761 | 2022-04-17 | Lyon | Iowa | 19119 | 2733 | 50 |
2415857 | 2415857 | 2022-04-17 | Lyon | Kansas | 20111 | 9965 | 120 |
2415979 | 2415979 | 2022-04-17 | Lyon | Kentucky | 21143 | 2862 | 33 |
2416275 | 2416275 | 2022-04-17 | Lyon | Minnesota | 27083 | 7045 | 72 |
2416682 | 2416682 | 2022-04-17 | Lyon | Nevada | 32019 | 10056 | 171 |
2412505 | 2412505 | 2022-04-16 | Lyon | Iowa | 19119 | 2733 | 50 |
2412601 | 2412601 | 2022-04-16 | Lyon | Kansas | 20111 | 9965 | 120 |
2412723 | 2412723 | 2022-04-16 | Lyon | Kentucky | 21143 | 2862 | 33 |
2413019 | 2413019 | 2022-04-16 | Lyon | Minnesota | 27083 | 7045 | 72 |
2413426 | 2413426 | 2022-04-16 | Lyon | Nevada | 32019 | 10056 | 171 |
2409249 | 2409249 | 2022-04-15 | Lyon | Iowa | 19119 | 2733 | 50 |
2409345 | 2409345 | 2022-04-15 | Lyon | Kansas | 20111 | 9965 | 120 |
2409467 | 2409467 | 2022-04-15 | Lyon | Kentucky | 21143 | 2862 | 33 |
2409763 | 2409763 | 2022-04-15 | Lyon | Minnesota | 27083 | 7045 | 72 |
2410170 | 2410170 | 2022-04-15 | Lyon | Nevada | 32019 | 10056 | 171 |
2405993 | 2405993 | 2022-04-14 | Lyon | Iowa | 19119 | 2733 | 50 |
2406089 | 2406089 | 2022-04-14 | Lyon | Kansas | 20111 | 9961 | 120 |
2406211 | 2406211 | 2022-04-14 | Lyon | Kentucky | 21143 | 2862 | 33 |
2406507 | 2406507 | 2022-04-14 | Lyon | Minnesota | 27083 | 7043 | 72 |
2406914 | 2406914 | 2022-04-14 | Lyon | Nevada | 32019 | 10056 | 171 |
2402737 | 2402737 | 2022-04-13 | Lyon | Iowa | 19119 | 2733 | 50 |
2402833 | 2402833 | 2022-04-13 | Lyon | Kansas | 20111 | 9961 | 120 |
2402955 | 2402955 | 2022-04-13 | Lyon | Kentucky | 21143 | 2862 | 33 |
2403251 | 2403251 | 2022-04-13 | Lyon | Minnesota | 27083 | 7043 | 72 |
2403658 | 2403658 | 2022-04-13 | Lyon | Nevada | 32019 | 10056 | 171 |
2399483 | 2399483 | 2022-04-12 | Lyon | Iowa | 19119 | 2727 | 50 |
2399579 | 2399579 | 2022-04-12 | Lyon | Kansas | 20111 | 9961 | 120 |
2399701 | 2399701 | 2022-04-12 | Lyon | Kentucky | 21143 | 2862 | 33 |
2399997 | 2399997 | 2022-04-12 | Lyon | Minnesota | 27083 | 7042 | 72 |
2400403 | 2400403 | 2022-04-12 | Lyon | Nevada | 32019 | 10026 | 170 |
2396227 | 2396227 | 2022-04-11 | Lyon | Iowa | 19119 | 2727 | 50 |
2396323 | 2396323 | 2022-04-11 | Lyon | Kansas | 20111 | 9961 | 120 |
2396445 | 2396445 | 2022-04-11 | Lyon | Kentucky | 21143 | 2862 | 33 |
2396741 | 2396741 | 2022-04-11 | Lyon | Minnesota | 27083 | 7041 | 72 |
2397148 | 2397148 | 2022-04-11 | Lyon | Nevada | 32019 | 10026 | 170 |
2392972 | 2392972 | 2022-04-10 | Lyon | Iowa | 19119 | 2727 | 50 |
2393068 | 2393068 | 2022-04-10 | Lyon | Kansas | 20111 | 9961 | 120 |
2393190 | 2393190 | 2022-04-10 | Lyon | Kentucky | 21143 | 2868 | 33 |
2393486 | 2393486 | 2022-04-10 | Lyon | Minnesota | 27083 | 7040 | 72 |
2393893 | 2393893 | 2022-04-10 | Lyon | Nevada | 32019 | 10026 | 170 |
2389716 | 2389716 | 2022-04-09 | Lyon | Iowa | 19119 | 2727 | 50 |
2389812 | 2389812 | 2022-04-09 | Lyon | Kansas | 20111 | 9961 | 120 |
2389934 | 2389934 | 2022-04-09 | Lyon | Kentucky | 21143 | 2868 | 33 |
2390230 | 2390230 | 2022-04-09 | Lyon | Minnesota | 27083 | 7040 | 72 |
2390637 | 2390637 | 2022-04-09 | Lyon | Nevada | 32019 | 10026 | 170 |
2386460 | 2386460 | 2022-04-08 | Lyon | Iowa | 19119 | 2727 | 50 |
2386556 | 2386556 | 2022-04-08 | Lyon | Kansas | 20111 | 9961 | 120 |
2386678 | 2386678 | 2022-04-08 | Lyon | Kentucky | 21143 | 2868 | 33 |
2386974 | 2386974 | 2022-04-08 | Lyon | Minnesota | 27083 | 7040 | 72 |
2387381 | 2387381 | 2022-04-08 | Lyon | Nevada | 32019 | 10026 | 170 |
2383206 | 2383206 | 2022-04-07 | Lyon | Iowa | 19119 | 2727 | 50 |
2383302 | 2383302 | 2022-04-07 | Lyon | Kansas | 20111 | 9955 | 120 |
2383423 | 2383423 | 2022-04-07 | Lyon | Kentucky | 21143 | 2868 | 33 |
2383719 | 2383719 | 2022-04-07 | Lyon | Minnesota | 27083 | 7040 | 72 |
2384126 | 2384126 | 2022-04-07 | Lyon | Nevada | 32019 | 10026 | 170 |
2379951 | 2379951 | 2022-04-06 | Lyon | Iowa | 19119 | 2727 | 50 |
2380047 | 2380047 | 2022-04-06 | Lyon | Kansas | 20111 | 9955 | 120 |
2380168 | 2380168 | 2022-04-06 | Lyon | Kentucky | 21143 | 2868 | 33 |
2380464 | 2380464 | 2022-04-06 | Lyon | Minnesota | 27083 | 7039 | 72 |
2380871 | 2380871 | 2022-04-06 | Lyon | Nevada | 32019 | 10026 | 170 |
2376696 | 2376696 | 2022-04-05 | Lyon | Iowa | 19119 | 2725 | 50 |
2376792 | 2376792 | 2022-04-05 | Lyon | Kansas | 20111 | 9955 | 120 |
2376913 | 2376913 | 2022-04-05 | Lyon | Kentucky | 21143 | 2868 | 33 |
2377209 | 2377209 | 2022-04-05 | Lyon | Minnesota | 27083 | 7038 | 72 |
2377616 | 2377616 | 2022-04-05 | Lyon | Nevada | 32019 | 9996 | 170 |
2373444 | 2373444 | 2022-04-04 | Lyon | Iowa | 19119 | 2725 | 50 |
2373540 | 2373540 | 2022-04-04 | Lyon | Kansas | 20111 | 9955 | 120 |
2373661 | 2373661 | 2022-04-04 | Lyon | Kentucky | 21143 | 2868 | 33 |
2373957 | 2373957 | 2022-04-04 | Lyon | Minnesota | 27083 | 7038 | 72 |
2374363 | 2374363 | 2022-04-04 | Lyon | Nevada | 32019 | 9996 | 170 |
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);