ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Kossuth" and state = "Iowa" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
7465 | 7465 | 2020-03-22 | Kossuth | Iowa | 19109 | 1 | 0 |
8624 | 8624 | 2020-03-23 | Kossuth | Iowa | 19109 | 1 | 0 |
9903 | 9903 | 2020-03-24 | Kossuth | Iowa | 19109 | 1 | 0 |
11300 | 11300 | 2020-03-25 | Kossuth | Iowa | 19109 | 1 | 0 |
12864 | 12864 | 2020-03-26 | Kossuth | Iowa | 19109 | 1 | 0 |
14556 | 14556 | 2020-03-27 | Kossuth | Iowa | 19109 | 1 | 0 |
16361 | 16361 | 2020-03-28 | Kossuth | Iowa | 19109 | 1 | 0 |
18266 | 18266 | 2020-03-29 | Kossuth | Iowa | 19109 | 1 | 0 |
20277 | 20277 | 2020-03-30 | Kossuth | Iowa | 19109 | 1 | 0 |
22373 | 22373 | 2020-03-31 | Kossuth | Iowa | 19109 | 1 | 0 |
24545 | 24545 | 2020-04-01 | Kossuth | Iowa | 19109 | 1 | 0 |
26787 | 26787 | 2020-04-02 | Kossuth | Iowa | 19109 | 1 | 0 |
29098 | 29098 | 2020-04-03 | Kossuth | Iowa | 19109 | 1 | 0 |
31468 | 31468 | 2020-04-04 | Kossuth | Iowa | 19109 | 1 | 0 |
33881 | 33881 | 2020-04-05 | Kossuth | Iowa | 19109 | 1 | 0 |
36336 | 36336 | 2020-04-06 | Kossuth | Iowa | 19109 | 1 | 0 |
38837 | 38837 | 2020-04-07 | Kossuth | Iowa | 19109 | 1 | 0 |
41383 | 41383 | 2020-04-08 | Kossuth | Iowa | 19109 | 1 | 0 |
43959 | 43959 | 2020-04-09 | Kossuth | Iowa | 19109 | 1 | 0 |
46564 | 46564 | 2020-04-10 | Kossuth | Iowa | 19109 | 1 | 0 |
49198 | 49198 | 2020-04-11 | Kossuth | Iowa | 19109 | 1 | 0 |
51862 | 51862 | 2020-04-12 | Kossuth | Iowa | 19109 | 1 | 0 |
54544 | 54544 | 2020-04-13 | Kossuth | Iowa | 19109 | 1 | 0 |
57237 | 57237 | 2020-04-14 | Kossuth | Iowa | 19109 | 1 | 0 |
59945 | 59945 | 2020-04-15 | Kossuth | Iowa | 19109 | 1 | 0 |
62666 | 62666 | 2020-04-16 | Kossuth | Iowa | 19109 | 1 | 0 |
65400 | 65400 | 2020-04-17 | Kossuth | Iowa | 19109 | 1 | 0 |
68149 | 68149 | 2020-04-18 | Kossuth | Iowa | 19109 | 1 | 0 |
70911 | 70911 | 2020-04-19 | Kossuth | Iowa | 19109 | 1 | 0 |
73682 | 73682 | 2020-04-20 | Kossuth | Iowa | 19109 | 1 | 0 |
76461 | 76461 | 2020-04-21 | Kossuth | Iowa | 19109 | 1 | 0 |
79245 | 79245 | 2020-04-22 | Kossuth | Iowa | 19109 | 1 | 0 |
82038 | 82038 | 2020-04-23 | Kossuth | Iowa | 19109 | 1 | 0 |
84838 | 84838 | 2020-04-24 | Kossuth | Iowa | 19109 | 1 | 0 |
87648 | 87648 | 2020-04-25 | Kossuth | Iowa | 19109 | 1 | 0 |
90464 | 90464 | 2020-04-26 | Kossuth | Iowa | 19109 | 1 | 0 |
93283 | 93283 | 2020-04-27 | Kossuth | Iowa | 19109 | 1 | 0 |
96115 | 96115 | 2020-04-28 | Kossuth | Iowa | 19109 | 1 | 0 |
98960 | 98960 | 2020-04-29 | Kossuth | Iowa | 19109 | 1 | 0 |
101811 | 101811 | 2020-04-30 | Kossuth | Iowa | 19109 | 2 | 0 |
104669 | 104669 | 2020-05-01 | Kossuth | Iowa | 19109 | 2 | 0 |
107534 | 107534 | 2020-05-02 | Kossuth | Iowa | 19109 | 2 | 0 |
110404 | 110404 | 2020-05-03 | Kossuth | Iowa | 19109 | 2 | 0 |
113279 | 113279 | 2020-05-04 | Kossuth | Iowa | 19109 | 2 | 0 |
116162 | 116162 | 2020-05-05 | Kossuth | Iowa | 19109 | 2 | 0 |
119122 | 119122 | 2020-05-06 | Kossuth | Iowa | 19109 | 2 | 0 |
122092 | 122092 | 2020-05-07 | Kossuth | Iowa | 19109 | 2 | 0 |
125073 | 125073 | 2020-05-08 | Kossuth | Iowa | 19109 | 2 | 0 |
128060 | 128060 | 2020-05-09 | Kossuth | Iowa | 19109 | 2 | 0 |
131051 | 131051 | 2020-05-10 | Kossuth | Iowa | 19109 | 2 | 0 |
134041 | 134041 | 2020-05-11 | Kossuth | Iowa | 19109 | 2 | 0 |
137031 | 137031 | 2020-05-12 | Kossuth | Iowa | 19109 | 2 | 0 |
140024 | 140024 | 2020-05-13 | Kossuth | Iowa | 19109 | 2 | 0 |
143020 | 143020 | 2020-05-14 | Kossuth | Iowa | 19109 | 2 | 0 |
146020 | 146020 | 2020-05-15 | Kossuth | Iowa | 19109 | 2 | 0 |
149024 | 149024 | 2020-05-16 | Kossuth | Iowa | 19109 | 2 | 0 |
152034 | 152034 | 2020-05-17 | Kossuth | Iowa | 19109 | 3 | 0 |
155046 | 155046 | 2020-05-18 | Kossuth | Iowa | 19109 | 5 | 0 |
158062 | 158062 | 2020-05-19 | Kossuth | Iowa | 19109 | 4 | 0 |
161088 | 161088 | 2020-05-20 | Kossuth | Iowa | 19109 | 7 | 0 |
164116 | 164116 | 2020-05-21 | Kossuth | Iowa | 19109 | 7 | 0 |
167149 | 167149 | 2020-05-22 | Kossuth | Iowa | 19109 | 7 | 0 |
170186 | 170186 | 2020-05-23 | Kossuth | Iowa | 19109 | 7 | 0 |
173227 | 173227 | 2020-05-24 | Kossuth | Iowa | 19109 | 7 | 0 |
176271 | 176271 | 2020-05-25 | Kossuth | Iowa | 19109 | 7 | 0 |
179315 | 179315 | 2020-05-26 | Kossuth | Iowa | 19109 | 8 | 0 |
182360 | 182360 | 2020-05-27 | Kossuth | Iowa | 19109 | 9 | 0 |
185414 | 185414 | 2020-05-28 | Kossuth | Iowa | 19109 | 9 | 0 |
188472 | 188472 | 2020-05-29 | Kossuth | Iowa | 19109 | 9 | 0 |
191537 | 191537 | 2020-05-30 | Kossuth | Iowa | 19109 | 9 | 0 |
194604 | 194604 | 2020-05-31 | Kossuth | Iowa | 19109 | 10 | 0 |
197674 | 197674 | 2020-06-01 | Kossuth | Iowa | 19109 | 11 | 0 |
200747 | 200747 | 2020-06-02 | Kossuth | Iowa | 19109 | 12 | 0 |
203823 | 203823 | 2020-06-03 | Kossuth | Iowa | 19109 | 13 | 0 |
206903 | 206903 | 2020-06-04 | Kossuth | Iowa | 19109 | 15 | 0 |
209984 | 209984 | 2020-06-05 | Kossuth | Iowa | 19109 | 16 | 0 |
213069 | 213069 | 2020-06-06 | Kossuth | Iowa | 19109 | 16 | 0 |
216156 | 216156 | 2020-06-07 | Kossuth | Iowa | 19109 | 16 | 0 |
219248 | 219248 | 2020-06-08 | Kossuth | Iowa | 19109 | 16 | 0 |
222343 | 222343 | 2020-06-09 | Kossuth | Iowa | 19109 | 16 | 0 |
225438 | 225438 | 2020-06-10 | Kossuth | Iowa | 19109 | 16 | 0 |
228540 | 228540 | 2020-06-11 | Kossuth | Iowa | 19109 | 16 | 0 |
231643 | 231643 | 2020-06-12 | Kossuth | Iowa | 19109 | 16 | 0 |
234749 | 234749 | 2020-06-13 | Kossuth | Iowa | 19109 | 17 | 0 |
237856 | 237856 | 2020-06-14 | Kossuth | Iowa | 19109 | 17 | 0 |
240964 | 240964 | 2020-06-15 | Kossuth | Iowa | 19109 | 19 | 0 |
244075 | 244075 | 2020-06-16 | Kossuth | Iowa | 19109 | 20 | 0 |
247188 | 247188 | 2020-06-17 | Kossuth | Iowa | 19109 | 20 | 0 |
250300 | 250300 | 2020-06-18 | Kossuth | Iowa | 19109 | 23 | 0 |
253415 | 253415 | 2020-06-19 | Kossuth | Iowa | 19109 | 22 | 0 |
256535 | 256535 | 2020-06-20 | Kossuth | Iowa | 19109 | 22 | 0 |
259661 | 259661 | 2020-06-21 | Kossuth | Iowa | 19109 | 24 | 0 |
262788 | 262788 | 2020-06-22 | Kossuth | Iowa | 19109 | 25 | 0 |
265916 | 265916 | 2020-06-23 | Kossuth | Iowa | 19109 | 27 | 0 |
269046 | 269046 | 2020-06-24 | Kossuth | Iowa | 19109 | 31 | 0 |
272183 | 272183 | 2020-06-25 | Kossuth | Iowa | 19109 | 29 | 0 |
275325 | 275325 | 2020-06-26 | Kossuth | Iowa | 19109 | 32 | 0 |
278473 | 278473 | 2020-06-27 | Kossuth | Iowa | 19109 | 32 | 0 |
281621 | 281621 | 2020-06-28 | Kossuth | Iowa | 19109 | 32 | 0 |
284766 | 284766 | 2020-06-29 | Kossuth | Iowa | 19109 | 32 | 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);