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
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 |
---|---|---|---|---|---|---|---|
3409 | 3409 | 2020-03-17 | Lyon | Kentucky | 21143 | 1 | 0 |
3988 | 3988 | 2020-03-18 | Lyon | Kentucky | 21143 | 1 | 0 |
4676 | 4676 | 2020-03-19 | Lyon | Kentucky | 21143 | 1 | 0 |
5490 | 5490 | 2020-03-20 | Lyon | Kentucky | 21143 | 1 | 0 |
6436 | 6436 | 2020-03-21 | Lyon | Kentucky | 21143 | 1 | 0 |
7509 | 7509 | 2020-03-22 | Lyon | Kentucky | 21143 | 1 | 0 |
8648 | 8648 | 2020-03-23 | Lyon | Kansas | 20111 | 2 | 0 |
8672 | 8672 | 2020-03-23 | Lyon | Kentucky | 21143 | 1 | 0 |
9929 | 9929 | 2020-03-24 | Lyon | Kansas | 20111 | 2 | 0 |
9955 | 9955 | 2020-03-24 | Lyon | Kentucky | 21143 | 1 | 0 |
11327 | 11327 | 2020-03-25 | Lyon | Kansas | 20111 | 2 | 0 |
11357 | 11357 | 2020-03-25 | Lyon | Kentucky | 21143 | 1 | 0 |
11683 | 11683 | 2020-03-25 | Lyon | Nevada | 32019 | 1 | 0 |
12895 | 12895 | 2020-03-26 | Lyon | Kansas | 20111 | 3 | 0 |
12928 | 12928 | 2020-03-26 | Lyon | Kentucky | 21143 | 1 | 0 |
13286 | 13286 | 2020-03-26 | Lyon | Nevada | 32019 | 1 | 0 |
14595 | 14595 | 2020-03-27 | Lyon | Kansas | 20111 | 5 | 0 |
14634 | 14634 | 2020-03-27 | Lyon | Kentucky | 21143 | 1 | 0 |
15018 | 15018 | 2020-03-27 | Lyon | Nevada | 32019 | 1 | 0 |
16402 | 16402 | 2020-03-28 | Lyon | Kansas | 20111 | 5 | 0 |
16449 | 16449 | 2020-03-28 | Lyon | Kentucky | 21143 | 1 | 0 |
16847 | 16847 | 2020-03-28 | Lyon | Nevada | 32019 | 1 | 0 |
18308 | 18308 | 2020-03-29 | Lyon | Kansas | 20111 | 7 | 0 |
18360 | 18360 | 2020-03-29 | Lyon | Kentucky | 21143 | 1 | 0 |
18771 | 18771 | 2020-03-29 | Lyon | Nevada | 32019 | 1 | 0 |
20321 | 20321 | 2020-03-30 | Lyon | Kansas | 20111 | 9 | 0 |
20374 | 20374 | 2020-03-30 | Lyon | Kentucky | 21143 | 1 | 0 |
20809 | 20809 | 2020-03-30 | Lyon | Nevada | 32019 | 1 | 0 |
22420 | 22420 | 2020-03-31 | Lyon | Kansas | 20111 | 10 | 0 |
22479 | 22479 | 2020-03-31 | Lyon | Kentucky | 21143 | 1 | 0 |
22714 | 22714 | 2020-03-31 | Lyon | Minnesota | 27083 | 1 | 0 |
22932 | 22932 | 2020-03-31 | Lyon | Nevada | 32019 | 1 | 0 |
24595 | 24595 | 2020-04-01 | Lyon | Kansas | 20111 | 12 | 0 |
24655 | 24655 | 2020-04-01 | Lyon | Kentucky | 21143 | 2 | 0 |
24896 | 24896 | 2020-04-01 | Lyon | Minnesota | 27083 | 2 | 0 |
25123 | 25123 | 2020-04-01 | Lyon | Nevada | 32019 | 1 | 0 |
26839 | 26839 | 2020-04-02 | Lyon | Kansas | 20111 | 16 | 0 |
26903 | 26903 | 2020-04-02 | Lyon | Kentucky | 21143 | 2 | 0 |
27150 | 27150 | 2020-04-02 | Lyon | Minnesota | 27083 | 3 | 0 |
27383 | 27383 | 2020-04-02 | Lyon | Nevada | 32019 | 2 | 0 |
29101 | 29101 | 2020-04-03 | Lyon | Iowa | 19119 | 1 | 0 |
29153 | 29153 | 2020-04-03 | Lyon | Kansas | 20111 | 17 | 0 |
29219 | 29219 | 2020-04-03 | Lyon | Kentucky | 21143 | 2 | 0 |
29469 | 29469 | 2020-04-03 | Lyon | Minnesota | 27083 | 3 | 0 |
29706 | 29706 | 2020-04-03 | Lyon | Nevada | 32019 | 2 | 0 |
31472 | 31472 | 2020-04-04 | Lyon | Iowa | 19119 | 2 | 0 |
31527 | 31527 | 2020-04-04 | Lyon | Kansas | 20111 | 19 | 0 |
31595 | 31595 | 2020-04-04 | Lyon | Kentucky | 21143 | 4 | 0 |
31847 | 31847 | 2020-04-04 | Lyon | Minnesota | 27083 | 3 | 0 |
32089 | 32089 | 2020-04-04 | Lyon | Nevada | 32019 | 3 | 0 |
33885 | 33885 | 2020-04-05 | Lyon | Iowa | 19119 | 2 | 0 |
33941 | 33941 | 2020-04-05 | Lyon | Kansas | 20111 | 23 | 0 |
34017 | 34017 | 2020-04-05 | Lyon | Kentucky | 21143 | 4 | 0 |
34273 | 34273 | 2020-04-05 | Lyon | Minnesota | 27083 | 3 | 0 |
34520 | 34520 | 2020-04-05 | Lyon | Nevada | 32019 | 3 | 0 |
36340 | 36340 | 2020-04-06 | Lyon | Iowa | 19119 | 2 | 0 |
36398 | 36398 | 2020-04-06 | Lyon | Kansas | 20111 | 23 | 0 |
36475 | 36475 | 2020-04-06 | Lyon | Kentucky | 21143 | 4 | 0 |
36733 | 36733 | 2020-04-06 | Lyon | Minnesota | 27083 | 4 | 0 |
36990 | 36990 | 2020-04-06 | Lyon | Nevada | 32019 | 4 | 0 |
38841 | 38841 | 2020-04-07 | Lyon | Iowa | 19119 | 2 | 0 |
38900 | 38900 | 2020-04-07 | Lyon | Kansas | 20111 | 24 | 0 |
38982 | 38982 | 2020-04-07 | Lyon | Kentucky | 21143 | 4 | 2 |
39242 | 39242 | 2020-04-07 | Lyon | Minnesota | 27083 | 4 | 0 |
39506 | 39506 | 2020-04-07 | Lyon | Nevada | 32019 | 4 | 0 |
41387 | 41387 | 2020-04-08 | Lyon | Iowa | 19119 | 2 | 0 |
41447 | 41447 | 2020-04-08 | Lyon | Kansas | 20111 | 26 | 0 |
41532 | 41532 | 2020-04-08 | Lyon | Kentucky | 21143 | 6 | 2 |
41795 | 41795 | 2020-04-08 | Lyon | Minnesota | 27083 | 4 | 0 |
42062 | 42062 | 2020-04-08 | Lyon | Nevada | 32019 | 4 | 0 |
43963 | 43963 | 2020-04-09 | Lyon | Iowa | 19119 | 2 | 0 |
44023 | 44023 | 2020-04-09 | Lyon | Kansas | 20111 | 26 | 0 |
44108 | 44108 | 2020-04-09 | Lyon | Kentucky | 21143 | 6 | 2 |
44371 | 44371 | 2020-04-09 | Lyon | Minnesota | 27083 | 5 | 0 |
44644 | 44644 | 2020-04-09 | Lyon | Nevada | 32019 | 4 | 0 |
46568 | 46568 | 2020-04-10 | Lyon | Iowa | 19119 | 2 | 0 |
46630 | 46630 | 2020-04-10 | Lyon | Kansas | 20111 | 26 | 0 |
46716 | 46716 | 2020-04-10 | Lyon | Kentucky | 21143 | 11 | 2 |
46980 | 46980 | 2020-04-10 | Lyon | Minnesota | 27083 | 5 | 0 |
47257 | 47257 | 2020-04-10 | Lyon | Nevada | 32019 | 7 | 0 |
49202 | 49202 | 2020-04-11 | Lyon | Iowa | 19119 | 2 | 0 |
49266 | 49266 | 2020-04-11 | Lyon | Kansas | 20111 | 27 | 0 |
49356 | 49356 | 2020-04-11 | Lyon | Kentucky | 21143 | 12 | 2 |
49625 | 49625 | 2020-04-11 | Lyon | Minnesota | 27083 | 5 | 0 |
49909 | 49909 | 2020-04-11 | Lyon | Nevada | 32019 | 7 | 0 |
51866 | 51866 | 2020-04-12 | Lyon | Iowa | 19119 | 3 | 0 |
51931 | 51931 | 2020-04-12 | Lyon | Kansas | 20111 | 29 | 0 |
52022 | 52022 | 2020-04-12 | Lyon | Kentucky | 21143 | 12 | 2 |
52295 | 52295 | 2020-04-12 | Lyon | Minnesota | 27083 | 5 | 0 |
52583 | 52583 | 2020-04-12 | Lyon | Nevada | 32019 | 7 | 0 |
54548 | 54548 | 2020-04-13 | Lyon | Iowa | 19119 | 4 | 0 |
54613 | 54613 | 2020-04-13 | Lyon | Kansas | 20111 | 29 | 0 |
54703 | 54703 | 2020-04-13 | Lyon | Kentucky | 21143 | 12 | 2 |
54977 | 54977 | 2020-04-13 | Lyon | Minnesota | 27083 | 5 | 0 |
55266 | 55266 | 2020-04-13 | Lyon | Nevada | 32019 | 10 | 0 |
57241 | 57241 | 2020-04-14 | Lyon | Iowa | 19119 | 4 | 0 |
57307 | 57307 | 2020-04-14 | Lyon | Kansas | 20111 | 32 | 0 |
57401 | 57401 | 2020-04-14 | Lyon | Kentucky | 21143 | 13 | 2 |
57675 | 57675 | 2020-04-14 | Lyon | Minnesota | 27083 | 5 | 0 |
57965 | 57965 | 2020-04-14 | Lyon | Nevada | 32019 | 10 | 0 |
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);