ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,310 rows where county = "Dickinson" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
county 1
- Dickinson · 2,310 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14546 | 14546 | 2020-03-27 | Dickinson | Iowa | 19059 | 1 | 0 |
16350 | 16350 | 2020-03-28 | Dickinson | Iowa | 19059 | 1 | 0 |
18255 | 18255 | 2020-03-29 | Dickinson | Iowa | 19059 | 1 | 0 |
20263 | 20263 | 2020-03-30 | Dickinson | Iowa | 19059 | 1 | 0 |
22359 | 22359 | 2020-03-31 | Dickinson | Iowa | 19059 | 1 | 0 |
24531 | 24531 | 2020-04-01 | Dickinson | Iowa | 19059 | 1 | 0 |
26772 | 26772 | 2020-04-02 | Dickinson | Iowa | 19059 | 1 | 0 |
27067 | 27067 | 2020-04-02 | Dickinson | Michigan | 26043 | 1 | 0 |
29083 | 29083 | 2020-04-03 | Dickinson | Iowa | 19059 | 1 | 0 |
29385 | 29385 | 2020-04-03 | Dickinson | Michigan | 26043 | 1 | 1 |
31451 | 31451 | 2020-04-04 | Dickinson | Iowa | 19059 | 1 | 0 |
31763 | 31763 | 2020-04-04 | Dickinson | Michigan | 26043 | 1 | 1 |
33863 | 33863 | 2020-04-05 | Dickinson | Iowa | 19059 | 1 | 0 |
34188 | 34188 | 2020-04-05 | Dickinson | Michigan | 26043 | 1 | 1 |
36317 | 36317 | 2020-04-06 | Dickinson | Iowa | 19059 | 1 | 0 |
36647 | 36647 | 2020-04-06 | Dickinson | Michigan | 26043 | 2 | 1 |
38817 | 38817 | 2020-04-07 | Dickinson | Iowa | 19059 | 1 | 0 |
39155 | 39155 | 2020-04-07 | Dickinson | Michigan | 26043 | 2 | 1 |
41363 | 41363 | 2020-04-08 | Dickinson | Iowa | 19059 | 1 | 0 |
41707 | 41707 | 2020-04-08 | Dickinson | Michigan | 26043 | 2 | 1 |
43939 | 43939 | 2020-04-09 | Dickinson | Iowa | 19059 | 1 | 0 |
44283 | 44283 | 2020-04-09 | Dickinson | Michigan | 26043 | 3 | 1 |
46544 | 46544 | 2020-04-10 | Dickinson | Iowa | 19059 | 1 | 0 |
46891 | 46891 | 2020-04-10 | Dickinson | Michigan | 26043 | 3 | 1 |
49178 | 49178 | 2020-04-11 | Dickinson | Iowa | 19059 | 1 | 0 |
49534 | 49534 | 2020-04-11 | Dickinson | Michigan | 26043 | 3 | 2 |
51842 | 51842 | 2020-04-12 | Dickinson | Iowa | 19059 | 1 | 0 |
52204 | 52204 | 2020-04-12 | Dickinson | Michigan | 26043 | 3 | 2 |
54524 | 54524 | 2020-04-13 | Dickinson | Iowa | 19059 | 1 | 0 |
54885 | 54885 | 2020-04-13 | Dickinson | Michigan | 26043 | 3 | 2 |
57217 | 57217 | 2020-04-14 | Dickinson | Iowa | 19059 | 1 | 0 |
57287 | 57287 | 2020-04-14 | Dickinson | Kansas | 20041 | 1 | 0 |
57583 | 57583 | 2020-04-14 | Dickinson | Michigan | 26043 | 3 | 2 |
59925 | 59925 | 2020-04-15 | Dickinson | Iowa | 19059 | 1 | 0 |
59995 | 59995 | 2020-04-15 | Dickinson | Kansas | 20041 | 1 | 0 |
60293 | 60293 | 2020-04-15 | Dickinson | Michigan | 26043 | 3 | 2 |
62646 | 62646 | 2020-04-16 | Dickinson | Iowa | 19059 | 1 | 0 |
62716 | 62716 | 2020-04-16 | Dickinson | Kansas | 20041 | 1 | 0 |
63015 | 63015 | 2020-04-16 | Dickinson | Michigan | 26043 | 3 | 2 |
65380 | 65380 | 2020-04-17 | Dickinson | Iowa | 19059 | 1 | 0 |
65452 | 65452 | 2020-04-17 | Dickinson | Kansas | 20041 | 1 | 0 |
65753 | 65753 | 2020-04-17 | Dickinson | Michigan | 26043 | 3 | 2 |
68129 | 68129 | 2020-04-18 | Dickinson | Iowa | 19059 | 1 | 0 |
68201 | 68201 | 2020-04-18 | Dickinson | Kansas | 20041 | 1 | 0 |
68504 | 68504 | 2020-04-18 | Dickinson | Michigan | 26043 | 3 | 2 |
70891 | 70891 | 2020-04-19 | Dickinson | Iowa | 19059 | 1 | 0 |
70962 | 70962 | 2020-04-19 | Dickinson | Kansas | 20041 | 1 | 0 |
71268 | 71268 | 2020-04-19 | Dickinson | Michigan | 26043 | 3 | 2 |
73662 | 73662 | 2020-04-20 | Dickinson | Iowa | 19059 | 1 | 0 |
73733 | 73733 | 2020-04-20 | Dickinson | Kansas | 20041 | 1 | 0 |
74040 | 74040 | 2020-04-20 | Dickinson | Michigan | 26043 | 3 | 2 |
76440 | 76440 | 2020-04-21 | Dickinson | Iowa | 19059 | 2 | 0 |
76513 | 76513 | 2020-04-21 | Dickinson | Kansas | 20041 | 1 | 0 |
76820 | 76820 | 2020-04-21 | Dickinson | Michigan | 26043 | 3 | 2 |
79224 | 79224 | 2020-04-22 | Dickinson | Iowa | 19059 | 3 | 0 |
79297 | 79297 | 2020-04-22 | Dickinson | Kansas | 20041 | 1 | 0 |
79606 | 79606 | 2020-04-22 | Dickinson | Michigan | 26043 | 3 | 2 |
82017 | 82017 | 2020-04-23 | Dickinson | Iowa | 19059 | 3 | 0 |
82090 | 82090 | 2020-04-23 | Dickinson | Kansas | 20041 | 1 | 0 |
82401 | 82401 | 2020-04-23 | Dickinson | Michigan | 26043 | 3 | 2 |
84817 | 84817 | 2020-04-24 | Dickinson | Iowa | 19059 | 4 | 0 |
84891 | 84891 | 2020-04-24 | Dickinson | Kansas | 20041 | 1 | 0 |
85205 | 85205 | 2020-04-24 | Dickinson | Michigan | 26043 | 3 | 2 |
87627 | 87627 | 2020-04-25 | Dickinson | Iowa | 19059 | 5 | 0 |
87700 | 87700 | 2020-04-25 | Dickinson | Kansas | 20041 | 1 | 0 |
88015 | 88015 | 2020-04-25 | Dickinson | Michigan | 26043 | 3 | 2 |
90443 | 90443 | 2020-04-26 | Dickinson | Iowa | 19059 | 5 | 0 |
90516 | 90516 | 2020-04-26 | Dickinson | Kansas | 20041 | 2 | 0 |
90831 | 90831 | 2020-04-26 | Dickinson | Michigan | 26043 | 3 | 2 |
93262 | 93262 | 2020-04-27 | Dickinson | Iowa | 19059 | 5 | 0 |
93337 | 93337 | 2020-04-27 | Dickinson | Kansas | 20041 | 2 | 0 |
93652 | 93652 | 2020-04-27 | Dickinson | Michigan | 26043 | 3 | 2 |
96094 | 96094 | 2020-04-28 | Dickinson | Iowa | 19059 | 6 | 0 |
96169 | 96169 | 2020-04-28 | Dickinson | Kansas | 20041 | 2 | 0 |
96487 | 96487 | 2020-04-28 | Dickinson | Michigan | 26043 | 3 | 2 |
98939 | 98939 | 2020-04-29 | Dickinson | Iowa | 19059 | 6 | 0 |
99015 | 99015 | 2020-04-29 | Dickinson | Kansas | 20041 | 2 | 0 |
99333 | 99333 | 2020-04-29 | Dickinson | Michigan | 26043 | 3 | 2 |
101790 | 101790 | 2020-04-30 | Dickinson | Iowa | 19059 | 6 | 0 |
101866 | 101866 | 2020-04-30 | Dickinson | Kansas | 20041 | 2 | 0 |
102185 | 102185 | 2020-04-30 | Dickinson | Michigan | 26043 | 3 | 2 |
104647 | 104647 | 2020-05-01 | Dickinson | Iowa | 19059 | 6 | 0 |
104726 | 104726 | 2020-05-01 | Dickinson | Kansas | 20041 | 2 | 0 |
105045 | 105045 | 2020-05-01 | Dickinson | Michigan | 26043 | 3 | 2 |
107512 | 107512 | 2020-05-02 | Dickinson | Iowa | 19059 | 6 | 0 |
107591 | 107591 | 2020-05-02 | Dickinson | Kansas | 20041 | 2 | 0 |
107909 | 107909 | 2020-05-02 | Dickinson | Michigan | 26043 | 3 | 2 |
110382 | 110382 | 2020-05-03 | Dickinson | Iowa | 19059 | 6 | 0 |
110462 | 110462 | 2020-05-03 | Dickinson | Kansas | 20041 | 2 | 0 |
110781 | 110781 | 2020-05-03 | Dickinson | Michigan | 26043 | 4 | 2 |
113257 | 113257 | 2020-05-04 | Dickinson | Iowa | 19059 | 6 | 0 |
113338 | 113338 | 2020-05-04 | Dickinson | Kansas | 20041 | 2 | 0 |
113659 | 113659 | 2020-05-04 | Dickinson | Michigan | 26043 | 3 | 2 |
116140 | 116140 | 2020-05-05 | Dickinson | Iowa | 19059 | 6 | 0 |
116220 | 116220 | 2020-05-05 | Dickinson | Kansas | 20041 | 2 | 0 |
116540 | 116540 | 2020-05-05 | Dickinson | Michigan | 26043 | 3 | 2 |
119100 | 119100 | 2020-05-06 | Dickinson | Iowa | 19059 | 6 | 0 |
119181 | 119181 | 2020-05-06 | Dickinson | Kansas | 20041 | 2 | 0 |
119501 | 119501 | 2020-05-06 | Dickinson | Michigan | 26043 | 4 | 2 |
122070 | 122070 | 2020-05-07 | Dickinson | Iowa | 19059 | 6 | 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);