ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
743 rows where county = "Calhoun" and state = "Iowa" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
104631 | 104631 | 2020-05-01 | Calhoun | Iowa | 19025 | 1 | 0 |
107496 | 107496 | 2020-05-02 | Calhoun | Iowa | 19025 | 1 | 0 |
110366 | 110366 | 2020-05-03 | Calhoun | Iowa | 19025 | 1 | 0 |
113241 | 113241 | 2020-05-04 | Calhoun | Iowa | 19025 | 1 | 0 |
116124 | 116124 | 2020-05-05 | Calhoun | Iowa | 19025 | 1 | 0 |
119084 | 119084 | 2020-05-06 | Calhoun | Iowa | 19025 | 1 | 0 |
122054 | 122054 | 2020-05-07 | Calhoun | Iowa | 19025 | 1 | 0 |
125034 | 125034 | 2020-05-08 | Calhoun | Iowa | 19025 | 1 | 0 |
128021 | 128021 | 2020-05-09 | Calhoun | Iowa | 19025 | 1 | 0 |
131012 | 131012 | 2020-05-10 | Calhoun | Iowa | 19025 | 1 | 0 |
134002 | 134002 | 2020-05-11 | Calhoun | Iowa | 19025 | 1 | 0 |
136991 | 136991 | 2020-05-12 | Calhoun | Iowa | 19025 | 1 | 0 |
139983 | 139983 | 2020-05-13 | Calhoun | Iowa | 19025 | 1 | 0 |
142979 | 142979 | 2020-05-14 | Calhoun | Iowa | 19025 | 1 | 0 |
145979 | 145979 | 2020-05-15 | Calhoun | Iowa | 19025 | 1 | 0 |
148983 | 148983 | 2020-05-16 | Calhoun | Iowa | 19025 | 1 | 0 |
151993 | 151993 | 2020-05-17 | Calhoun | Iowa | 19025 | 1 | 0 |
155005 | 155005 | 2020-05-18 | Calhoun | Iowa | 19025 | 1 | 0 |
158021 | 158021 | 2020-05-19 | Calhoun | Iowa | 19025 | 2 | 0 |
161047 | 161047 | 2020-05-20 | Calhoun | Iowa | 19025 | 2 | 0 |
164075 | 164075 | 2020-05-21 | Calhoun | Iowa | 19025 | 2 | 0 |
167108 | 167108 | 2020-05-22 | Calhoun | Iowa | 19025 | 2 | 0 |
170145 | 170145 | 2020-05-23 | Calhoun | Iowa | 19025 | 2 | 0 |
173186 | 173186 | 2020-05-24 | Calhoun | Iowa | 19025 | 2 | 0 |
176230 | 176230 | 2020-05-25 | Calhoun | Iowa | 19025 | 3 | 0 |
179274 | 179274 | 2020-05-26 | Calhoun | Iowa | 19025 | 2 | 0 |
182318 | 182318 | 2020-05-27 | Calhoun | Iowa | 19025 | 2 | 0 |
185372 | 185372 | 2020-05-28 | Calhoun | Iowa | 19025 | 2 | 0 |
188430 | 188430 | 2020-05-29 | Calhoun | Iowa | 19025 | 2 | 0 |
191495 | 191495 | 2020-05-30 | Calhoun | Iowa | 19025 | 2 | 0 |
194562 | 194562 | 2020-05-31 | Calhoun | Iowa | 19025 | 2 | 0 |
197632 | 197632 | 2020-06-01 | Calhoun | Iowa | 19025 | 2 | 0 |
200705 | 200705 | 2020-06-02 | Calhoun | Iowa | 19025 | 3 | 0 |
203781 | 203781 | 2020-06-03 | Calhoun | Iowa | 19025 | 5 | 0 |
206861 | 206861 | 2020-06-04 | Calhoun | Iowa | 19025 | 8 | 0 |
209942 | 209942 | 2020-06-05 | Calhoun | Iowa | 19025 | 11 | 0 |
213027 | 213027 | 2020-06-06 | Calhoun | Iowa | 19025 | 12 | 0 |
216114 | 216114 | 2020-06-07 | Calhoun | Iowa | 19025 | 14 | 0 |
219206 | 219206 | 2020-06-08 | Calhoun | Iowa | 19025 | 13 | 0 |
222301 | 222301 | 2020-06-09 | Calhoun | Iowa | 19025 | 14 | 0 |
225396 | 225396 | 2020-06-10 | Calhoun | Iowa | 19025 | 16 | 0 |
228498 | 228498 | 2020-06-11 | Calhoun | Iowa | 19025 | 17 | 0 |
231601 | 231601 | 2020-06-12 | Calhoun | Iowa | 19025 | 19 | 0 |
234707 | 234707 | 2020-06-13 | Calhoun | Iowa | 19025 | 20 | 0 |
237814 | 237814 | 2020-06-14 | Calhoun | Iowa | 19025 | 23 | 0 |
240922 | 240922 | 2020-06-15 | Calhoun | Iowa | 19025 | 24 | 0 |
244033 | 244033 | 2020-06-16 | Calhoun | Iowa | 19025 | 24 | 0 |
247146 | 247146 | 2020-06-17 | Calhoun | Iowa | 19025 | 25 | 0 |
250258 | 250258 | 2020-06-18 | Calhoun | Iowa | 19025 | 25 | 0 |
253373 | 253373 | 2020-06-19 | Calhoun | Iowa | 19025 | 25 | 0 |
256493 | 256493 | 2020-06-20 | Calhoun | Iowa | 19025 | 25 | 0 |
259619 | 259619 | 2020-06-21 | Calhoun | Iowa | 19025 | 25 | 0 |
262746 | 262746 | 2020-06-22 | Calhoun | Iowa | 19025 | 25 | 0 |
265874 | 265874 | 2020-06-23 | Calhoun | Iowa | 19025 | 26 | 0 |
269004 | 269004 | 2020-06-24 | Calhoun | Iowa | 19025 | 29 | 0 |
272141 | 272141 | 2020-06-25 | Calhoun | Iowa | 19025 | 30 | 0 |
275283 | 275283 | 2020-06-26 | Calhoun | Iowa | 19025 | 35 | 0 |
278431 | 278431 | 2020-06-27 | Calhoun | Iowa | 19025 | 39 | 0 |
281579 | 281579 | 2020-06-28 | Calhoun | Iowa | 19025 | 41 | 0 |
284724 | 284724 | 2020-06-29 | Calhoun | Iowa | 19025 | 44 | 1 |
287873 | 287873 | 2020-06-30 | Calhoun | Iowa | 19025 | 45 | 2 |
291023 | 291023 | 2020-07-01 | Calhoun | Iowa | 19025 | 47 | 2 |
294177 | 294177 | 2020-07-02 | Calhoun | Iowa | 19025 | 48 | 2 |
297335 | 297335 | 2020-07-03 | Calhoun | Iowa | 19025 | 48 | 2 |
300497 | 300497 | 2020-07-04 | Calhoun | Iowa | 19025 | 49 | 2 |
303661 | 303661 | 2020-07-05 | Calhoun | Iowa | 19025 | 50 | 2 |
306826 | 306826 | 2020-07-06 | Calhoun | Iowa | 19025 | 53 | 2 |
309994 | 309994 | 2020-07-07 | Calhoun | Iowa | 19025 | 54 | 2 |
313164 | 313164 | 2020-07-08 | Calhoun | Iowa | 19025 | 56 | 2 |
316338 | 316338 | 2020-07-09 | Calhoun | Iowa | 19025 | 58 | 2 |
319511 | 319511 | 2020-07-10 | Calhoun | Iowa | 19025 | 61 | 2 |
322690 | 322690 | 2020-07-11 | Calhoun | Iowa | 19025 | 63 | 2 |
325871 | 325871 | 2020-07-12 | Calhoun | Iowa | 19025 | 65 | 2 |
329057 | 329057 | 2020-07-13 | Calhoun | Iowa | 19025 | 65 | 2 |
332244 | 332244 | 2020-07-14 | Calhoun | Iowa | 19025 | 66 | 2 |
335437 | 335437 | 2020-07-15 | Calhoun | Iowa | 19025 | 66 | 2 |
338633 | 338633 | 2020-07-16 | Calhoun | Iowa | 19025 | 67 | 2 |
341829 | 341829 | 2020-07-17 | Calhoun | Iowa | 19025 | 68 | 2 |
345029 | 345029 | 2020-07-18 | Calhoun | Iowa | 19025 | 68 | 2 |
348230 | 348230 | 2020-07-19 | Calhoun | Iowa | 19025 | 68 | 2 |
351430 | 351430 | 2020-07-20 | Calhoun | Iowa | 19025 | 70 | 2 |
354632 | 354632 | 2020-07-21 | Calhoun | Iowa | 19025 | 71 | 2 |
357834 | 357834 | 2020-07-22 | Calhoun | Iowa | 19025 | 71 | 2 |
361039 | 361039 | 2020-07-23 | Calhoun | Iowa | 19025 | 72 | 2 |
364246 | 364246 | 2020-07-24 | Calhoun | Iowa | 19025 | 72 | 2 |
367453 | 367453 | 2020-07-25 | Calhoun | Iowa | 19025 | 72 | 2 |
370663 | 370663 | 2020-07-26 | Calhoun | Iowa | 19025 | 73 | 2 |
373875 | 373875 | 2020-07-27 | Calhoun | Iowa | 19025 | 75 | 2 |
377090 | 377090 | 2020-07-28 | Calhoun | Iowa | 19025 | 76 | 2 |
380307 | 380307 | 2020-07-29 | Calhoun | Iowa | 19025 | 78 | 2 |
383524 | 383524 | 2020-07-30 | Calhoun | Iowa | 19025 | 81 | 2 |
386742 | 386742 | 2020-07-31 | Calhoun | Iowa | 19025 | 81 | 2 |
389959 | 389959 | 2020-08-01 | Calhoun | Iowa | 19025 | 81 | 2 |
393176 | 393176 | 2020-08-02 | Calhoun | Iowa | 19025 | 81 | 2 |
396392 | 396392 | 2020-08-03 | Calhoun | Iowa | 19025 | 82 | 2 |
399608 | 399608 | 2020-08-04 | Calhoun | Iowa | 19025 | 82 | 2 |
402824 | 402824 | 2020-08-05 | Calhoun | Iowa | 19025 | 82 | 2 |
406042 | 406042 | 2020-08-06 | Calhoun | Iowa | 19025 | 83 | 2 |
409262 | 409262 | 2020-08-07 | Calhoun | Iowa | 19025 | 83 | 2 |
412481 | 412481 | 2020-08-08 | Calhoun | Iowa | 19025 | 83 | 2 |
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);