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)
Suggested facets: date (date)
county 1
- Lyon · 3,895 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500432 | 2500432 | 2022-05-13 | Lyon | Iowa | 19119 | 2747 | 50 |
2500528 | 2500528 | 2022-05-13 | Lyon | Kansas | 20111 | 10084 | 122 |
2500650 | 2500650 | 2022-05-13 | Lyon | Kentucky | 21143 | 2881 | 34 |
2500946 | 2500946 | 2022-05-13 | Lyon | Minnesota | 27083 | 7131 | 73 |
2501353 | 2501353 | 2022-05-13 | Lyon | Nevada | 32019 | 10135 | 175 |
2497174 | 2497174 | 2022-05-12 | Lyon | Iowa | 19119 | 2747 | 50 |
2497270 | 2497270 | 2022-05-12 | Lyon | Kansas | 20111 | 10005 | 122 |
2497392 | 2497392 | 2022-05-12 | Lyon | Kentucky | 21143 | 2881 | 34 |
2497688 | 2497688 | 2022-05-12 | Lyon | Minnesota | 27083 | 7123 | 73 |
2498095 | 2498095 | 2022-05-12 | Lyon | Nevada | 32019 | 10135 | 175 |
2493916 | 2493916 | 2022-05-11 | Lyon | Iowa | 19119 | 2747 | 50 |
2494012 | 2494012 | 2022-05-11 | Lyon | Kansas | 20111 | 10005 | 122 |
2494134 | 2494134 | 2022-05-11 | Lyon | Kentucky | 21143 | 2881 | 34 |
2494430 | 2494430 | 2022-05-11 | Lyon | Minnesota | 27083 | 7120 | 73 |
2494837 | 2494837 | 2022-05-11 | Lyon | Nevada | 32019 | 10135 | 175 |
2490658 | 2490658 | 2022-05-10 | Lyon | Iowa | 19119 | 2745 | 50 |
2490754 | 2490754 | 2022-05-10 | Lyon | Kansas | 20111 | 10005 | 122 |
2490876 | 2490876 | 2022-05-10 | Lyon | Kentucky | 21143 | 2881 | 34 |
2491172 | 2491172 | 2022-05-10 | Lyon | Minnesota | 27083 | 7117 | 73 |
2491579 | 2491579 | 2022-05-10 | Lyon | Nevada | 32019 | 10103 | 175 |
2487401 | 2487401 | 2022-05-09 | Lyon | Iowa | 19119 | 2745 | 50 |
2487497 | 2487497 | 2022-05-09 | Lyon | Kansas | 20111 | 10005 | 122 |
2487619 | 2487619 | 2022-05-09 | Lyon | Kentucky | 21143 | 2881 | 34 |
2487915 | 2487915 | 2022-05-09 | Lyon | Minnesota | 27083 | 7114 | 73 |
2488321 | 2488321 | 2022-05-09 | Lyon | Nevada | 32019 | 10103 | 175 |
2484143 | 2484143 | 2022-05-08 | Lyon | Iowa | 19119 | 2745 | 50 |
2484239 | 2484239 | 2022-05-08 | Lyon | Kansas | 20111 | 10005 | 122 |
2484361 | 2484361 | 2022-05-08 | Lyon | Kentucky | 21143 | 2874 | 34 |
2484657 | 2484657 | 2022-05-08 | Lyon | Minnesota | 27083 | 7110 | 73 |
2485064 | 2485064 | 2022-05-08 | Lyon | Nevada | 32019 | 10103 | 175 |
2480885 | 2480885 | 2022-05-07 | Lyon | Iowa | 19119 | 2745 | 50 |
2480981 | 2480981 | 2022-05-07 | Lyon | Kansas | 20111 | 10005 | 122 |
2481103 | 2481103 | 2022-05-07 | Lyon | Kentucky | 21143 | 2874 | 34 |
2481399 | 2481399 | 2022-05-07 | Lyon | Minnesota | 27083 | 7110 | 73 |
2481806 | 2481806 | 2022-05-07 | Lyon | Nevada | 32019 | 10103 | 175 |
2477627 | 2477627 | 2022-05-06 | Lyon | Iowa | 19119 | 2745 | 50 |
2477723 | 2477723 | 2022-05-06 | Lyon | Kansas | 20111 | 10005 | 122 |
2477845 | 2477845 | 2022-05-06 | Lyon | Kentucky | 21143 | 2874 | 34 |
2478141 | 2478141 | 2022-05-06 | Lyon | Minnesota | 27083 | 7110 | 73 |
2478548 | 2478548 | 2022-05-06 | Lyon | Nevada | 32019 | 10103 | 175 |
2474369 | 2474369 | 2022-05-05 | Lyon | Iowa | 19119 | 2745 | 50 |
2474465 | 2474465 | 2022-05-05 | Lyon | Kansas | 20111 | 9980 | 122 |
2474587 | 2474587 | 2022-05-05 | Lyon | Kentucky | 21143 | 2874 | 34 |
2474883 | 2474883 | 2022-05-05 | Lyon | Minnesota | 27083 | 7107 | 73 |
2475290 | 2475290 | 2022-05-05 | Lyon | Nevada | 32019 | 10103 | 175 |
2471112 | 2471112 | 2022-05-04 | Lyon | Iowa | 19119 | 2745 | 50 |
2471208 | 2471208 | 2022-05-04 | Lyon | Kansas | 20111 | 9980 | 122 |
2471330 | 2471330 | 2022-05-04 | Lyon | Kentucky | 21143 | 2874 | 34 |
2471626 | 2471626 | 2022-05-04 | Lyon | Minnesota | 27083 | 7105 | 73 |
2472033 | 2472033 | 2022-05-04 | Lyon | Nevada | 32019 | 10103 | 175 |
2467856 | 2467856 | 2022-05-03 | Lyon | Iowa | 19119 | 2742 | 50 |
2467952 | 2467952 | 2022-05-03 | Lyon | Kansas | 20111 | 9980 | 122 |
2468074 | 2468074 | 2022-05-03 | Lyon | Kentucky | 21143 | 2874 | 34 |
2468370 | 2468370 | 2022-05-03 | Lyon | Minnesota | 27083 | 7100 | 73 |
2468777 | 2468777 | 2022-05-03 | Lyon | Nevada | 32019 | 10081 | 175 |
2464601 | 2464601 | 2022-05-02 | Lyon | Iowa | 19119 | 2742 | 50 |
2464697 | 2464697 | 2022-05-02 | Lyon | Kansas | 20111 | 9980 | 122 |
2464819 | 2464819 | 2022-05-02 | Lyon | Kentucky | 21143 | 2874 | 34 |
2465115 | 2465115 | 2022-05-02 | Lyon | Minnesota | 27083 | 7091 | 73 |
2465521 | 2465521 | 2022-05-02 | Lyon | Nevada | 32019 | 10081 | 175 |
2461345 | 2461345 | 2022-05-01 | Lyon | Iowa | 19119 | 2742 | 50 |
2461441 | 2461441 | 2022-05-01 | Lyon | Kansas | 20111 | 9980 | 122 |
2461563 | 2461563 | 2022-05-01 | Lyon | Kentucky | 21143 | 2869 | 34 |
2461859 | 2461859 | 2022-05-01 | Lyon | Minnesota | 27083 | 7087 | 72 |
2462266 | 2462266 | 2022-05-01 | Lyon | Nevada | 32019 | 10081 | 175 |
2458089 | 2458089 | 2022-04-30 | Lyon | Iowa | 19119 | 2742 | 50 |
2458185 | 2458185 | 2022-04-30 | Lyon | Kansas | 20111 | 9980 | 122 |
2458307 | 2458307 | 2022-04-30 | Lyon | Kentucky | 21143 | 2869 | 34 |
2458603 | 2458603 | 2022-04-30 | Lyon | Minnesota | 27083 | 7087 | 72 |
2459010 | 2459010 | 2022-04-30 | Lyon | Nevada | 32019 | 10081 | 175 |
2454833 | 2454833 | 2022-04-29 | Lyon | Iowa | 19119 | 2742 | 50 |
2454929 | 2454929 | 2022-04-29 | Lyon | Kansas | 20111 | 9980 | 122 |
2455051 | 2455051 | 2022-04-29 | Lyon | Kentucky | 21143 | 2869 | 34 |
2455347 | 2455347 | 2022-04-29 | Lyon | Minnesota | 27083 | 7087 | 72 |
2455754 | 2455754 | 2022-04-29 | Lyon | Nevada | 32019 | 10081 | 175 |
2451577 | 2451577 | 2022-04-28 | Lyon | Iowa | 19119 | 2742 | 50 |
2451673 | 2451673 | 2022-04-28 | Lyon | Kansas | 20111 | 9972 | 122 |
2451795 | 2451795 | 2022-04-28 | Lyon | Kentucky | 21143 | 2869 | 34 |
2452091 | 2452091 | 2022-04-28 | Lyon | Minnesota | 27083 | 7081 | 72 |
2452498 | 2452498 | 2022-04-28 | Lyon | Nevada | 32019 | 10081 | 175 |
2448321 | 2448321 | 2022-04-27 | Lyon | Iowa | 19119 | 2742 | 50 |
2448417 | 2448417 | 2022-04-27 | Lyon | Kansas | 20111 | 9972 | 122 |
2448539 | 2448539 | 2022-04-27 | Lyon | Kentucky | 21143 | 2869 | 34 |
2448835 | 2448835 | 2022-04-27 | Lyon | Minnesota | 27083 | 7079 | 72 |
2449242 | 2449242 | 2022-04-27 | Lyon | Nevada | 32019 | 10081 | 175 |
2445065 | 2445065 | 2022-04-26 | Lyon | Iowa | 19119 | 2738 | 50 |
2445161 | 2445161 | 2022-04-26 | Lyon | Kansas | 20111 | 9972 | 121 |
2445283 | 2445283 | 2022-04-26 | Lyon | Kentucky | 21143 | 2869 | 34 |
2445579 | 2445579 | 2022-04-26 | Lyon | Minnesota | 27083 | 7071 | 72 |
2445985 | 2445985 | 2022-04-26 | Lyon | Nevada | 32019 | 10071 | 175 |
2441809 | 2441809 | 2022-04-25 | Lyon | Iowa | 19119 | 2738 | 50 |
2441905 | 2441905 | 2022-04-25 | Lyon | Kansas | 20111 | 9972 | 121 |
2442027 | 2442027 | 2022-04-25 | Lyon | Kentucky | 21143 | 2869 | 34 |
2442323 | 2442323 | 2022-04-25 | Lyon | Minnesota | 27083 | 7067 | 72 |
2442730 | 2442730 | 2022-04-25 | Lyon | Nevada | 32019 | 10071 | 175 |
2438553 | 2438553 | 2022-04-24 | Lyon | Iowa | 19119 | 2738 | 50 |
2438649 | 2438649 | 2022-04-24 | Lyon | Kansas | 20111 | 9972 | 121 |
2438771 | 2438771 | 2022-04-24 | Lyon | Kentucky | 21143 | 2864 | 33 |
2439067 | 2439067 | 2022-04-24 | Lyon | Minnesota | 27083 | 7066 | 72 |
2439474 | 2439474 | 2022-04-24 | Lyon | Nevada | 32019 | 10071 | 175 |
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);