ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Jefferson" and state = "Iowa" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 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
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- 2020-04-28 1
- 2020-04-29 1
- 2020-04-30 1
- 2020-05-01 1
- …
state 1
- Iowa · 772 ✖
fips 1
- 19101 772
county 1
- Jefferson · 772 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
26783 | 26783 | 2020-04-02 | Jefferson | Iowa | 19101 | 1 | 0 |
29094 | 29094 | 2020-04-03 | Jefferson | Iowa | 19101 | 2 | 0 |
31464 | 31464 | 2020-04-04 | Jefferson | Iowa | 19101 | 3 | 0 |
33877 | 33877 | 2020-04-05 | Jefferson | Iowa | 19101 | 3 | 0 |
36332 | 36332 | 2020-04-06 | Jefferson | Iowa | 19101 | 3 | 0 |
38833 | 38833 | 2020-04-07 | Jefferson | Iowa | 19101 | 3 | 0 |
41379 | 41379 | 2020-04-08 | Jefferson | Iowa | 19101 | 3 | 0 |
43955 | 43955 | 2020-04-09 | Jefferson | Iowa | 19101 | 3 | 0 |
46560 | 46560 | 2020-04-10 | Jefferson | Iowa | 19101 | 3 | 0 |
49194 | 49194 | 2020-04-11 | Jefferson | Iowa | 19101 | 4 | 0 |
51858 | 51858 | 2020-04-12 | Jefferson | Iowa | 19101 | 4 | 0 |
54540 | 54540 | 2020-04-13 | Jefferson | Iowa | 19101 | 4 | 0 |
57233 | 57233 | 2020-04-14 | Jefferson | Iowa | 19101 | 4 | 0 |
59941 | 59941 | 2020-04-15 | Jefferson | Iowa | 19101 | 4 | 0 |
62662 | 62662 | 2020-04-16 | Jefferson | Iowa | 19101 | 4 | 0 |
65396 | 65396 | 2020-04-17 | Jefferson | Iowa | 19101 | 4 | 0 |
68145 | 68145 | 2020-04-18 | Jefferson | Iowa | 19101 | 4 | 0 |
70907 | 70907 | 2020-04-19 | Jefferson | Iowa | 19101 | 4 | 0 |
73678 | 73678 | 2020-04-20 | Jefferson | Iowa | 19101 | 6 | 0 |
76457 | 76457 | 2020-04-21 | Jefferson | Iowa | 19101 | 7 | 0 |
79241 | 79241 | 2020-04-22 | Jefferson | Iowa | 19101 | 7 | 0 |
82034 | 82034 | 2020-04-23 | Jefferson | Iowa | 19101 | 7 | 0 |
84834 | 84834 | 2020-04-24 | Jefferson | Iowa | 19101 | 6 | 0 |
87644 | 87644 | 2020-04-25 | Jefferson | Iowa | 19101 | 6 | 0 |
90460 | 90460 | 2020-04-26 | Jefferson | Iowa | 19101 | 6 | 0 |
93279 | 93279 | 2020-04-27 | Jefferson | Iowa | 19101 | 6 | 0 |
96111 | 96111 | 2020-04-28 | Jefferson | Iowa | 19101 | 6 | 0 |
98956 | 98956 | 2020-04-29 | Jefferson | Iowa | 19101 | 6 | 0 |
101807 | 101807 | 2020-04-30 | Jefferson | Iowa | 19101 | 6 | 0 |
104665 | 104665 | 2020-05-01 | Jefferson | Iowa | 19101 | 6 | 0 |
107530 | 107530 | 2020-05-02 | Jefferson | Iowa | 19101 | 6 | 0 |
110400 | 110400 | 2020-05-03 | Jefferson | Iowa | 19101 | 6 | 0 |
113275 | 113275 | 2020-05-04 | Jefferson | Iowa | 19101 | 6 | 0 |
116158 | 116158 | 2020-05-05 | Jefferson | Iowa | 19101 | 6 | 0 |
119118 | 119118 | 2020-05-06 | Jefferson | Iowa | 19101 | 6 | 0 |
122088 | 122088 | 2020-05-07 | Jefferson | Iowa | 19101 | 6 | 0 |
125069 | 125069 | 2020-05-08 | Jefferson | Iowa | 19101 | 6 | 0 |
128056 | 128056 | 2020-05-09 | Jefferson | Iowa | 19101 | 6 | 0 |
131047 | 131047 | 2020-05-10 | Jefferson | Iowa | 19101 | 6 | 0 |
134037 | 134037 | 2020-05-11 | Jefferson | Iowa | 19101 | 7 | 0 |
137027 | 137027 | 2020-05-12 | Jefferson | Iowa | 19101 | 8 | 0 |
140020 | 140020 | 2020-05-13 | Jefferson | Iowa | 19101 | 9 | 0 |
143016 | 143016 | 2020-05-14 | Jefferson | Iowa | 19101 | 9 | 0 |
146016 | 146016 | 2020-05-15 | Jefferson | Iowa | 19101 | 10 | 0 |
149020 | 149020 | 2020-05-16 | Jefferson | Iowa | 19101 | 12 | 0 |
152030 | 152030 | 2020-05-17 | Jefferson | Iowa | 19101 | 12 | 0 |
155042 | 155042 | 2020-05-18 | Jefferson | Iowa | 19101 | 12 | 0 |
158058 | 158058 | 2020-05-19 | Jefferson | Iowa | 19101 | 12 | 0 |
161084 | 161084 | 2020-05-20 | Jefferson | Iowa | 19101 | 13 | 0 |
164112 | 164112 | 2020-05-21 | Jefferson | Iowa | 19101 | 14 | 0 |
167145 | 167145 | 2020-05-22 | Jefferson | Iowa | 19101 | 14 | 0 |
170182 | 170182 | 2020-05-23 | Jefferson | Iowa | 19101 | 14 | 0 |
173223 | 173223 | 2020-05-24 | Jefferson | Iowa | 19101 | 15 | 0 |
176267 | 176267 | 2020-05-25 | Jefferson | Iowa | 19101 | 18 | 0 |
179311 | 179311 | 2020-05-26 | Jefferson | Iowa | 19101 | 18 | 0 |
182356 | 182356 | 2020-05-27 | Jefferson | Iowa | 19101 | 19 | 0 |
185410 | 185410 | 2020-05-28 | Jefferson | Iowa | 19101 | 20 | 0 |
188468 | 188468 | 2020-05-29 | Jefferson | Iowa | 19101 | 21 | 0 |
191533 | 191533 | 2020-05-30 | Jefferson | Iowa | 19101 | 26 | 0 |
194600 | 194600 | 2020-05-31 | Jefferson | Iowa | 19101 | 29 | 0 |
197670 | 197670 | 2020-06-01 | Jefferson | Iowa | 19101 | 30 | 0 |
200743 | 200743 | 2020-06-02 | Jefferson | Iowa | 19101 | 34 | 0 |
203819 | 203819 | 2020-06-03 | Jefferson | Iowa | 19101 | 33 | 0 |
206899 | 206899 | 2020-06-04 | Jefferson | Iowa | 19101 | 35 | 0 |
209980 | 209980 | 2020-06-05 | Jefferson | Iowa | 19101 | 36 | 0 |
213065 | 213065 | 2020-06-06 | Jefferson | Iowa | 19101 | 36 | 0 |
216152 | 216152 | 2020-06-07 | Jefferson | Iowa | 19101 | 37 | 0 |
219244 | 219244 | 2020-06-08 | Jefferson | Iowa | 19101 | 38 | 0 |
222339 | 222339 | 2020-06-09 | Jefferson | Iowa | 19101 | 40 | 0 |
225434 | 225434 | 2020-06-10 | Jefferson | Iowa | 19101 | 43 | 0 |
228536 | 228536 | 2020-06-11 | Jefferson | Iowa | 19101 | 43 | 0 |
231639 | 231639 | 2020-06-12 | Jefferson | Iowa | 19101 | 44 | 0 |
234745 | 234745 | 2020-06-13 | Jefferson | Iowa | 19101 | 45 | 0 |
237852 | 237852 | 2020-06-14 | Jefferson | Iowa | 19101 | 45 | 0 |
240960 | 240960 | 2020-06-15 | Jefferson | Iowa | 19101 | 48 | 0 |
244071 | 244071 | 2020-06-16 | Jefferson | Iowa | 19101 | 46 | 0 |
247184 | 247184 | 2020-06-17 | Jefferson | Iowa | 19101 | 46 | 0 |
250296 | 250296 | 2020-06-18 | Jefferson | Iowa | 19101 | 46 | 0 |
253411 | 253411 | 2020-06-19 | Jefferson | Iowa | 19101 | 46 | 0 |
256531 | 256531 | 2020-06-20 | Jefferson | Iowa | 19101 | 46 | 0 |
259657 | 259657 | 2020-06-21 | Jefferson | Iowa | 19101 | 47 | 0 |
262784 | 262784 | 2020-06-22 | Jefferson | Iowa | 19101 | 49 | 0 |
265912 | 265912 | 2020-06-23 | Jefferson | Iowa | 19101 | 49 | 0 |
269042 | 269042 | 2020-06-24 | Jefferson | Iowa | 19101 | 49 | 0 |
272179 | 272179 | 2020-06-25 | Jefferson | Iowa | 19101 | 50 | 0 |
275321 | 275321 | 2020-06-26 | Jefferson | Iowa | 19101 | 50 | 0 |
278469 | 278469 | 2020-06-27 | Jefferson | Iowa | 19101 | 50 | 0 |
281617 | 281617 | 2020-06-28 | Jefferson | Iowa | 19101 | 50 | 0 |
284762 | 284762 | 2020-06-29 | Jefferson | Iowa | 19101 | 52 | 0 |
287911 | 287911 | 2020-06-30 | Jefferson | Iowa | 19101 | 53 | 0 |
291061 | 291061 | 2020-07-01 | Jefferson | Iowa | 19101 | 55 | 0 |
294215 | 294215 | 2020-07-02 | Jefferson | Iowa | 19101 | 58 | 0 |
297373 | 297373 | 2020-07-03 | Jefferson | Iowa | 19101 | 59 | 0 |
300535 | 300535 | 2020-07-04 | Jefferson | Iowa | 19101 | 60 | 0 |
303699 | 303699 | 2020-07-05 | Jefferson | Iowa | 19101 | 64 | 0 |
306864 | 306864 | 2020-07-06 | Jefferson | Iowa | 19101 | 64 | 0 |
310032 | 310032 | 2020-07-07 | Jefferson | Iowa | 19101 | 62 | 0 |
313202 | 313202 | 2020-07-08 | Jefferson | Iowa | 19101 | 62 | 0 |
316376 | 316376 | 2020-07-09 | Jefferson | Iowa | 19101 | 62 | 0 |
319549 | 319549 | 2020-07-10 | Jefferson | Iowa | 19101 | 62 | 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);