ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where county = "Cass" and state = "Iowa" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
54512 | 54512 | 2020-04-13 | Cass | Iowa | 19029 | 1 | 0 |
57205 | 57205 | 2020-04-14 | Cass | Iowa | 19029 | 1 | 0 |
59913 | 59913 | 2020-04-15 | Cass | Iowa | 19029 | 1 | 0 |
62634 | 62634 | 2020-04-16 | Cass | Iowa | 19029 | 1 | 0 |
65368 | 65368 | 2020-04-17 | Cass | Iowa | 19029 | 1 | 0 |
68117 | 68117 | 2020-04-18 | Cass | Iowa | 19029 | 1 | 0 |
70879 | 70879 | 2020-04-19 | Cass | Iowa | 19029 | 1 | 0 |
73650 | 73650 | 2020-04-20 | Cass | Iowa | 19029 | 1 | 0 |
76427 | 76427 | 2020-04-21 | Cass | Iowa | 19029 | 1 | 0 |
79211 | 79211 | 2020-04-22 | Cass | Iowa | 19029 | 1 | 0 |
82004 | 82004 | 2020-04-23 | Cass | Iowa | 19029 | 1 | 0 |
84804 | 84804 | 2020-04-24 | Cass | Iowa | 19029 | 1 | 0 |
87614 | 87614 | 2020-04-25 | Cass | Iowa | 19029 | 1 | 0 |
90430 | 90430 | 2020-04-26 | Cass | Iowa | 19029 | 1 | 0 |
93249 | 93249 | 2020-04-27 | Cass | Iowa | 19029 | 1 | 0 |
96081 | 96081 | 2020-04-28 | Cass | Iowa | 19029 | 1 | 0 |
98925 | 98925 | 2020-04-29 | Cass | Iowa | 19029 | 1 | 0 |
101776 | 101776 | 2020-04-30 | Cass | Iowa | 19029 | 1 | 0 |
104633 | 104633 | 2020-05-01 | Cass | Iowa | 19029 | 1 | 0 |
107498 | 107498 | 2020-05-02 | Cass | Iowa | 19029 | 1 | 0 |
110368 | 110368 | 2020-05-03 | Cass | Iowa | 19029 | 1 | 0 |
113243 | 113243 | 2020-05-04 | Cass | Iowa | 19029 | 1 | 0 |
116126 | 116126 | 2020-05-05 | Cass | Iowa | 19029 | 1 | 0 |
119086 | 119086 | 2020-05-06 | Cass | Iowa | 19029 | 1 | 0 |
122056 | 122056 | 2020-05-07 | Cass | Iowa | 19029 | 1 | 0 |
125036 | 125036 | 2020-05-08 | Cass | Iowa | 19029 | 1 | 0 |
128023 | 128023 | 2020-05-09 | Cass | Iowa | 19029 | 1 | 0 |
131014 | 131014 | 2020-05-10 | Cass | Iowa | 19029 | 1 | 0 |
134004 | 134004 | 2020-05-11 | Cass | Iowa | 19029 | 1 | 0 |
136993 | 136993 | 2020-05-12 | Cass | Iowa | 19029 | 1 | 0 |
139985 | 139985 | 2020-05-13 | Cass | Iowa | 19029 | 1 | 0 |
142981 | 142981 | 2020-05-14 | Cass | Iowa | 19029 | 1 | 0 |
145981 | 145981 | 2020-05-15 | Cass | Iowa | 19029 | 1 | 0 |
148985 | 148985 | 2020-05-16 | Cass | Iowa | 19029 | 1 | 0 |
151995 | 151995 | 2020-05-17 | Cass | Iowa | 19029 | 2 | 0 |
155007 | 155007 | 2020-05-18 | Cass | Iowa | 19029 | 2 | 0 |
158023 | 158023 | 2020-05-19 | Cass | Iowa | 19029 | 2 | 0 |
161049 | 161049 | 2020-05-20 | Cass | Iowa | 19029 | 4 | 0 |
164077 | 164077 | 2020-05-21 | Cass | Iowa | 19029 | 6 | 0 |
167110 | 167110 | 2020-05-22 | Cass | Iowa | 19029 | 6 | 0 |
170147 | 170147 | 2020-05-23 | Cass | Iowa | 19029 | 6 | 0 |
173188 | 173188 | 2020-05-24 | Cass | Iowa | 19029 | 11 | 0 |
176232 | 176232 | 2020-05-25 | Cass | Iowa | 19029 | 11 | 0 |
179276 | 179276 | 2020-05-26 | Cass | Iowa | 19029 | 11 | 0 |
182320 | 182320 | 2020-05-27 | Cass | Iowa | 19029 | 11 | 0 |
185374 | 185374 | 2020-05-28 | Cass | Iowa | 19029 | 11 | 0 |
188432 | 188432 | 2020-05-29 | Cass | Iowa | 19029 | 12 | 0 |
191497 | 191497 | 2020-05-30 | Cass | Iowa | 19029 | 12 | 0 |
194564 | 194564 | 2020-05-31 | Cass | Iowa | 19029 | 12 | 0 |
197634 | 197634 | 2020-06-01 | Cass | Iowa | 19029 | 12 | 0 |
200707 | 200707 | 2020-06-02 | Cass | Iowa | 19029 | 12 | 0 |
203783 | 203783 | 2020-06-03 | Cass | Iowa | 19029 | 12 | 0 |
206863 | 206863 | 2020-06-04 | Cass | Iowa | 19029 | 12 | 0 |
209944 | 209944 | 2020-06-05 | Cass | Iowa | 19029 | 13 | 0 |
213029 | 213029 | 2020-06-06 | Cass | Iowa | 19029 | 13 | 0 |
216116 | 216116 | 2020-06-07 | Cass | Iowa | 19029 | 13 | 0 |
219208 | 219208 | 2020-06-08 | Cass | Iowa | 19029 | 13 | 0 |
222303 | 222303 | 2020-06-09 | Cass | Iowa | 19029 | 13 | 0 |
225398 | 225398 | 2020-06-10 | Cass | Iowa | 19029 | 13 | 0 |
228500 | 228500 | 2020-06-11 | Cass | Iowa | 19029 | 13 | 0 |
231603 | 231603 | 2020-06-12 | Cass | Iowa | 19029 | 13 | 0 |
234709 | 234709 | 2020-06-13 | Cass | Iowa | 19029 | 14 | 0 |
237816 | 237816 | 2020-06-14 | Cass | Iowa | 19029 | 14 | 0 |
240924 | 240924 | 2020-06-15 | Cass | Iowa | 19029 | 14 | 0 |
244035 | 244035 | 2020-06-16 | Cass | Iowa | 19029 | 14 | 0 |
247148 | 247148 | 2020-06-17 | Cass | Iowa | 19029 | 14 | 0 |
250260 | 250260 | 2020-06-18 | Cass | Iowa | 19029 | 16 | 0 |
253375 | 253375 | 2020-06-19 | Cass | Iowa | 19029 | 16 | 0 |
256495 | 256495 | 2020-06-20 | Cass | Iowa | 19029 | 16 | 0 |
259621 | 259621 | 2020-06-21 | Cass | Iowa | 19029 | 16 | 0 |
262748 | 262748 | 2020-06-22 | Cass | Iowa | 19029 | 16 | 0 |
265876 | 265876 | 2020-06-23 | Cass | Iowa | 19029 | 16 | 0 |
269006 | 269006 | 2020-06-24 | Cass | Iowa | 19029 | 16 | 0 |
272143 | 272143 | 2020-06-25 | Cass | Iowa | 19029 | 16 | 0 |
275285 | 275285 | 2020-06-26 | Cass | Iowa | 19029 | 16 | 0 |
278433 | 278433 | 2020-06-27 | Cass | Iowa | 19029 | 17 | 0 |
281581 | 281581 | 2020-06-28 | Cass | Iowa | 19029 | 17 | 0 |
284726 | 284726 | 2020-06-29 | Cass | Iowa | 19029 | 17 | 0 |
287875 | 287875 | 2020-06-30 | Cass | Iowa | 19029 | 17 | 0 |
291025 | 291025 | 2020-07-01 | Cass | Iowa | 19029 | 17 | 0 |
294179 | 294179 | 2020-07-02 | Cass | Iowa | 19029 | 21 | 0 |
297337 | 297337 | 2020-07-03 | Cass | Iowa | 19029 | 21 | 0 |
300499 | 300499 | 2020-07-04 | Cass | Iowa | 19029 | 22 | 0 |
303663 | 303663 | 2020-07-05 | Cass | Iowa | 19029 | 22 | 0 |
306828 | 306828 | 2020-07-06 | Cass | Iowa | 19029 | 23 | 0 |
309996 | 309996 | 2020-07-07 | Cass | Iowa | 19029 | 24 | 0 |
313166 | 313166 | 2020-07-08 | Cass | Iowa | 19029 | 24 | 0 |
316340 | 316340 | 2020-07-09 | Cass | Iowa | 19029 | 27 | 0 |
319513 | 319513 | 2020-07-10 | Cass | Iowa | 19029 | 27 | 0 |
322692 | 322692 | 2020-07-11 | Cass | Iowa | 19029 | 28 | 0 |
325873 | 325873 | 2020-07-12 | Cass | Iowa | 19029 | 30 | 0 |
329059 | 329059 | 2020-07-13 | Cass | Iowa | 19029 | 30 | 0 |
332246 | 332246 | 2020-07-14 | Cass | Iowa | 19029 | 29 | 0 |
335439 | 335439 | 2020-07-15 | Cass | Iowa | 19029 | 29 | 0 |
338635 | 338635 | 2020-07-16 | Cass | Iowa | 19029 | 29 | 0 |
341831 | 341831 | 2020-07-17 | Cass | Iowa | 19029 | 29 | 0 |
345031 | 345031 | 2020-07-18 | Cass | Iowa | 19029 | 29 | 0 |
348232 | 348232 | 2020-07-19 | Cass | Iowa | 19029 | 30 | 0 |
351432 | 351432 | 2020-07-20 | Cass | Iowa | 19029 | 30 | 0 |
354634 | 354634 | 2020-07-21 | Cass | Iowa | 19029 | 30 | 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);