ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 19191 and state = "Iowa" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- …
state 1
- Iowa · 787 ✖
fips 1
- 19191 · 787 ✖
county 1
- Winneshiek 787
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
3973 | 3973 | 2020-03-18 | Winneshiek | Iowa | 19191 | 1 | 0 |
4654 | 4654 | 2020-03-19 | Winneshiek | Iowa | 19191 | 1 | 0 |
5465 | 5465 | 2020-03-20 | Winneshiek | Iowa | 19191 | 1 | 0 |
6410 | 6410 | 2020-03-21 | Winneshiek | Iowa | 19191 | 1 | 0 |
7476 | 7476 | 2020-03-22 | Winneshiek | Iowa | 19191 | 1 | 0 |
8636 | 8636 | 2020-03-23 | Winneshiek | Iowa | 19191 | 1 | 0 |
9916 | 9916 | 2020-03-24 | Winneshiek | Iowa | 19191 | 1 | 0 |
11313 | 11313 | 2020-03-25 | Winneshiek | Iowa | 19191 | 1 | 0 |
12880 | 12880 | 2020-03-26 | Winneshiek | Iowa | 19191 | 1 | 0 |
14575 | 14575 | 2020-03-27 | Winneshiek | Iowa | 19191 | 2 | 0 |
16382 | 16382 | 2020-03-28 | Winneshiek | Iowa | 19191 | 2 | 0 |
18287 | 18287 | 2020-03-29 | Winneshiek | Iowa | 19191 | 3 | 0 |
20299 | 20299 | 2020-03-30 | Winneshiek | Iowa | 19191 | 3 | 0 |
22395 | 22395 | 2020-03-31 | Winneshiek | Iowa | 19191 | 3 | 0 |
24570 | 24570 | 2020-04-01 | Winneshiek | Iowa | 19191 | 3 | 0 |
26812 | 26812 | 2020-04-02 | Winneshiek | Iowa | 19191 | 4 | 0 |
29126 | 29126 | 2020-04-03 | Winneshiek | Iowa | 19191 | 4 | 0 |
31498 | 31498 | 2020-04-04 | Winneshiek | Iowa | 19191 | 4 | 0 |
33911 | 33911 | 2020-04-05 | Winneshiek | Iowa | 19191 | 4 | 0 |
36368 | 36368 | 2020-04-06 | Winneshiek | Iowa | 19191 | 4 | 0 |
38869 | 38869 | 2020-04-07 | Winneshiek | Iowa | 19191 | 4 | 0 |
41415 | 41415 | 2020-04-08 | Winneshiek | Iowa | 19191 | 4 | 0 |
43991 | 43991 | 2020-04-09 | Winneshiek | Iowa | 19191 | 5 | 0 |
46598 | 46598 | 2020-04-10 | Winneshiek | Iowa | 19191 | 5 | 0 |
49232 | 49232 | 2020-04-11 | Winneshiek | Iowa | 19191 | 5 | 0 |
51896 | 51896 | 2020-04-12 | Winneshiek | Iowa | 19191 | 5 | 0 |
54578 | 54578 | 2020-04-13 | Winneshiek | Iowa | 19191 | 5 | 0 |
57271 | 57271 | 2020-04-14 | Winneshiek | Iowa | 19191 | 5 | 0 |
59979 | 59979 | 2020-04-15 | Winneshiek | Iowa | 19191 | 5 | 0 |
62700 | 62700 | 2020-04-16 | Winneshiek | Iowa | 19191 | 5 | 0 |
65435 | 65435 | 2020-04-17 | Winneshiek | Iowa | 19191 | 5 | 0 |
68184 | 68184 | 2020-04-18 | Winneshiek | Iowa | 19191 | 5 | 0 |
70945 | 70945 | 2020-04-19 | Winneshiek | Iowa | 19191 | 6 | 0 |
73716 | 73716 | 2020-04-20 | Winneshiek | Iowa | 19191 | 6 | 0 |
76496 | 76496 | 2020-04-21 | Winneshiek | Iowa | 19191 | 7 | 0 |
79280 | 79280 | 2020-04-22 | Winneshiek | Iowa | 19191 | 8 | 0 |
82072 | 82072 | 2020-04-23 | Winneshiek | Iowa | 19191 | 9 | 0 |
84873 | 84873 | 2020-04-24 | Winneshiek | Iowa | 19191 | 11 | 0 |
87682 | 87682 | 2020-04-25 | Winneshiek | Iowa | 19191 | 12 | 0 |
90498 | 90498 | 2020-04-26 | Winneshiek | Iowa | 19191 | 24 | 0 |
93319 | 93319 | 2020-04-27 | Winneshiek | Iowa | 19191 | 24 | 0 |
96151 | 96151 | 2020-04-28 | Winneshiek | Iowa | 19191 | 15 | 0 |
98996 | 98996 | 2020-04-29 | Winneshiek | Iowa | 19191 | 15 | 0 |
101847 | 101847 | 2020-04-30 | Winneshiek | Iowa | 19191 | 15 | 0 |
104707 | 104707 | 2020-05-01 | Winneshiek | Iowa | 19191 | 17 | 0 |
107572 | 107572 | 2020-05-02 | Winneshiek | Iowa | 19191 | 17 | 0 |
110443 | 110443 | 2020-05-03 | Winneshiek | Iowa | 19191 | 18 | 0 |
113318 | 113318 | 2020-05-04 | Winneshiek | Iowa | 19191 | 18 | 0 |
116200 | 116200 | 2020-05-05 | Winneshiek | Iowa | 19191 | 18 | 0 |
119161 | 119161 | 2020-05-06 | Winneshiek | Iowa | 19191 | 18 | 0 |
122131 | 122131 | 2020-05-07 | Winneshiek | Iowa | 19191 | 18 | 0 |
125113 | 125113 | 2020-05-08 | Winneshiek | Iowa | 19191 | 18 | 0 |
128100 | 128100 | 2020-05-09 | Winneshiek | Iowa | 19191 | 18 | 0 |
131090 | 131090 | 2020-05-10 | Winneshiek | Iowa | 19191 | 18 | 0 |
134081 | 134081 | 2020-05-11 | Winneshiek | Iowa | 19191 | 18 | 0 |
137071 | 137071 | 2020-05-12 | Winneshiek | Iowa | 19191 | 18 | 0 |
140064 | 140064 | 2020-05-13 | Winneshiek | Iowa | 19191 | 18 | 0 |
143060 | 143060 | 2020-05-14 | Winneshiek | Iowa | 19191 | 18 | 0 |
146060 | 146060 | 2020-05-15 | Winneshiek | Iowa | 19191 | 18 | 0 |
149064 | 149064 | 2020-05-16 | Winneshiek | Iowa | 19191 | 18 | 0 |
152075 | 152075 | 2020-05-17 | Winneshiek | Iowa | 19191 | 18 | 0 |
155087 | 155087 | 2020-05-18 | Winneshiek | Iowa | 19191 | 20 | 0 |
158104 | 158104 | 2020-05-19 | Winneshiek | Iowa | 19191 | 21 | 0 |
161129 | 161129 | 2020-05-20 | Winneshiek | Iowa | 19191 | 21 | 0 |
164158 | 164158 | 2020-05-21 | Winneshiek | Iowa | 19191 | 21 | 0 |
167190 | 167190 | 2020-05-22 | Winneshiek | Iowa | 19191 | 21 | 0 |
170228 | 170228 | 2020-05-23 | Winneshiek | Iowa | 19191 | 21 | 0 |
173269 | 173269 | 2020-05-24 | Winneshiek | Iowa | 19191 | 22 | 0 |
176313 | 176313 | 2020-05-25 | Winneshiek | Iowa | 19191 | 23 | 0 |
179357 | 179357 | 2020-05-26 | Winneshiek | Iowa | 19191 | 23 | 0 |
182402 | 182402 | 2020-05-27 | Winneshiek | Iowa | 19191 | 23 | 0 |
185456 | 185456 | 2020-05-28 | Winneshiek | Iowa | 19191 | 23 | 0 |
188514 | 188514 | 2020-05-29 | Winneshiek | Iowa | 19191 | 23 | 0 |
191578 | 191578 | 2020-05-30 | Winneshiek | Iowa | 19191 | 24 | 0 |
194646 | 194646 | 2020-05-31 | Winneshiek | Iowa | 19191 | 24 | 0 |
197716 | 197716 | 2020-06-01 | Winneshiek | Iowa | 19191 | 24 | 0 |
200788 | 200788 | 2020-06-02 | Winneshiek | Iowa | 19191 | 24 | 0 |
203864 | 203864 | 2020-06-03 | Winneshiek | Iowa | 19191 | 24 | 0 |
206945 | 206945 | 2020-06-04 | Winneshiek | Iowa | 19191 | 24 | 0 |
210026 | 210026 | 2020-06-05 | Winneshiek | Iowa | 19191 | 24 | 0 |
213111 | 213111 | 2020-06-06 | Winneshiek | Iowa | 19191 | 24 | 0 |
216198 | 216198 | 2020-06-07 | Winneshiek | Iowa | 19191 | 24 | 0 |
219290 | 219290 | 2020-06-08 | Winneshiek | Iowa | 19191 | 24 | 0 |
222385 | 222385 | 2020-06-09 | Winneshiek | Iowa | 19191 | 24 | 0 |
225480 | 225480 | 2020-06-10 | Winneshiek | Iowa | 19191 | 25 | 0 |
228582 | 228582 | 2020-06-11 | Winneshiek | Iowa | 19191 | 24 | 0 |
231685 | 231685 | 2020-06-12 | Winneshiek | Iowa | 19191 | 24 | 0 |
234791 | 234791 | 2020-06-13 | Winneshiek | Iowa | 19191 | 24 | 0 |
237898 | 237898 | 2020-06-14 | Winneshiek | Iowa | 19191 | 24 | 0 |
241006 | 241006 | 2020-06-15 | Winneshiek | Iowa | 19191 | 24 | 0 |
244117 | 244117 | 2020-06-16 | Winneshiek | Iowa | 19191 | 24 | 0 |
247230 | 247230 | 2020-06-17 | Winneshiek | Iowa | 19191 | 24 | 0 |
250342 | 250342 | 2020-06-18 | Winneshiek | Iowa | 19191 | 24 | 0 |
253457 | 253457 | 2020-06-19 | Winneshiek | Iowa | 19191 | 24 | 0 |
256577 | 256577 | 2020-06-20 | Winneshiek | Iowa | 19191 | 24 | 0 |
259703 | 259703 | 2020-06-21 | Winneshiek | Iowa | 19191 | 24 | 0 |
262830 | 262830 | 2020-06-22 | Winneshiek | Iowa | 19191 | 24 | 0 |
265958 | 265958 | 2020-06-23 | Winneshiek | Iowa | 19191 | 24 | 0 |
269088 | 269088 | 2020-06-24 | Winneshiek | Iowa | 19191 | 25 | 0 |
272225 | 272225 | 2020-06-25 | Winneshiek | Iowa | 19191 | 24 | 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);