ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 19021 and state = "Iowa" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
38803 | 38803 | 2020-04-07 | Buena Vista | Iowa | 19021 | 1 | 0 |
41349 | 41349 | 2020-04-08 | Buena Vista | Iowa | 19021 | 1 | 0 |
43925 | 43925 | 2020-04-09 | Buena Vista | Iowa | 19021 | 1 | 0 |
46530 | 46530 | 2020-04-10 | Buena Vista | Iowa | 19021 | 1 | 0 |
49164 | 49164 | 2020-04-11 | Buena Vista | Iowa | 19021 | 2 | 0 |
51828 | 51828 | 2020-04-12 | Buena Vista | Iowa | 19021 | 2 | 0 |
54509 | 54509 | 2020-04-13 | Buena Vista | Iowa | 19021 | 2 | 0 |
57202 | 57202 | 2020-04-14 | Buena Vista | Iowa | 19021 | 2 | 0 |
59910 | 59910 | 2020-04-15 | Buena Vista | Iowa | 19021 | 2 | 0 |
62631 | 62631 | 2020-04-16 | Buena Vista | Iowa | 19021 | 2 | 0 |
65365 | 65365 | 2020-04-17 | Buena Vista | Iowa | 19021 | 2 | 0 |
68114 | 68114 | 2020-04-18 | Buena Vista | Iowa | 19021 | 2 | 0 |
70876 | 70876 | 2020-04-19 | Buena Vista | Iowa | 19021 | 2 | 0 |
73647 | 73647 | 2020-04-20 | Buena Vista | Iowa | 19021 | 2 | 0 |
76424 | 76424 | 2020-04-21 | Buena Vista | Iowa | 19021 | 2 | 0 |
79208 | 79208 | 2020-04-22 | Buena Vista | Iowa | 19021 | 2 | 0 |
82001 | 82001 | 2020-04-23 | Buena Vista | Iowa | 19021 | 3 | 0 |
84801 | 84801 | 2020-04-24 | Buena Vista | Iowa | 19021 | 3 | 0 |
87611 | 87611 | 2020-04-25 | Buena Vista | Iowa | 19021 | 3 | 0 |
90427 | 90427 | 2020-04-26 | Buena Vista | Iowa | 19021 | 4 | 0 |
93246 | 93246 | 2020-04-27 | Buena Vista | Iowa | 19021 | 4 | 0 |
96078 | 96078 | 2020-04-28 | Buena Vista | Iowa | 19021 | 4 | 0 |
98922 | 98922 | 2020-04-29 | Buena Vista | Iowa | 19021 | 4 | 0 |
101773 | 101773 | 2020-04-30 | Buena Vista | Iowa | 19021 | 4 | 0 |
104629 | 104629 | 2020-05-01 | Buena Vista | Iowa | 19021 | 6 | 0 |
107494 | 107494 | 2020-05-02 | Buena Vista | Iowa | 19021 | 5 | 0 |
110364 | 110364 | 2020-05-03 | Buena Vista | Iowa | 19021 | 8 | 0 |
113239 | 113239 | 2020-05-04 | Buena Vista | Iowa | 19021 | 11 | 0 |
116122 | 116122 | 2020-05-05 | Buena Vista | Iowa | 19021 | 15 | 0 |
119082 | 119082 | 2020-05-06 | Buena Vista | Iowa | 19021 | 16 | 0 |
122052 | 122052 | 2020-05-07 | Buena Vista | Iowa | 19021 | 18 | 0 |
125032 | 125032 | 2020-05-08 | Buena Vista | Iowa | 19021 | 32 | 0 |
128019 | 128019 | 2020-05-09 | Buena Vista | Iowa | 19021 | 30 | 0 |
131010 | 131010 | 2020-05-10 | Buena Vista | Iowa | 19021 | 31 | 0 |
134000 | 134000 | 2020-05-11 | Buena Vista | Iowa | 19021 | 39 | 0 |
136989 | 136989 | 2020-05-12 | Buena Vista | Iowa | 19021 | 41 | 0 |
139981 | 139981 | 2020-05-13 | Buena Vista | Iowa | 19021 | 45 | 0 |
142977 | 142977 | 2020-05-14 | Buena Vista | Iowa | 19021 | 74 | 0 |
145977 | 145977 | 2020-05-15 | Buena Vista | Iowa | 19021 | 83 | 0 |
148981 | 148981 | 2020-05-16 | Buena Vista | Iowa | 19021 | 82 | 0 |
151991 | 151991 | 2020-05-17 | Buena Vista | Iowa | 19021 | 102 | 0 |
155003 | 155003 | 2020-05-18 | Buena Vista | Iowa | 19021 | 113 | 0 |
158019 | 158019 | 2020-05-19 | Buena Vista | Iowa | 19021 | 117 | 0 |
161045 | 161045 | 2020-05-20 | Buena Vista | Iowa | 19021 | 130 | 0 |
164073 | 164073 | 2020-05-21 | Buena Vista | Iowa | 19021 | 134 | 0 |
167106 | 167106 | 2020-05-22 | Buena Vista | Iowa | 19021 | 140 | 0 |
170143 | 170143 | 2020-05-23 | Buena Vista | Iowa | 19021 | 140 | 0 |
173184 | 173184 | 2020-05-24 | Buena Vista | Iowa | 19021 | 239 | 0 |
176228 | 176228 | 2020-05-25 | Buena Vista | Iowa | 19021 | 246 | 0 |
179272 | 179272 | 2020-05-26 | Buena Vista | Iowa | 19021 | 496 | 0 |
182316 | 182316 | 2020-05-27 | Buena Vista | Iowa | 19021 | 688 | 0 |
185370 | 185370 | 2020-05-28 | Buena Vista | Iowa | 19021 | 707 | 0 |
188428 | 188428 | 2020-05-29 | Buena Vista | Iowa | 19021 | 724 | 0 |
191493 | 191493 | 2020-05-30 | Buena Vista | Iowa | 19021 | 743 | 0 |
194560 | 194560 | 2020-05-31 | Buena Vista | Iowa | 19021 | 793 | 0 |
197630 | 197630 | 2020-06-01 | Buena Vista | Iowa | 19021 | 814 | 1 |
200703 | 200703 | 2020-06-02 | Buena Vista | Iowa | 19021 | 854 | 1 |
203779 | 203779 | 2020-06-03 | Buena Vista | Iowa | 19021 | 951 | 1 |
206859 | 206859 | 2020-06-04 | Buena Vista | Iowa | 19021 | 1024 | 2 |
209940 | 209940 | 2020-06-05 | Buena Vista | Iowa | 19021 | 1091 | 2 |
213025 | 213025 | 2020-06-06 | Buena Vista | Iowa | 19021 | 1115 | 2 |
216112 | 216112 | 2020-06-07 | Buena Vista | Iowa | 19021 | 1154 | 2 |
219204 | 219204 | 2020-06-08 | Buena Vista | Iowa | 19021 | 1221 | 4 |
222299 | 222299 | 2020-06-09 | Buena Vista | Iowa | 19021 | 1261 | 4 |
225394 | 225394 | 2020-06-10 | Buena Vista | Iowa | 19021 | 1359 | 4 |
228496 | 228496 | 2020-06-11 | Buena Vista | Iowa | 19021 | 1430 | 4 |
231599 | 231599 | 2020-06-12 | Buena Vista | Iowa | 19021 | 1488 | 6 |
234705 | 234705 | 2020-06-13 | Buena Vista | Iowa | 19021 | 1567 | 6 |
237812 | 237812 | 2020-06-14 | Buena Vista | Iowa | 19021 | 1588 | 6 |
240920 | 240920 | 2020-06-15 | Buena Vista | Iowa | 19021 | 1595 | 7 |
244031 | 244031 | 2020-06-16 | Buena Vista | Iowa | 19021 | 1602 | 10 |
247144 | 247144 | 2020-06-17 | Buena Vista | Iowa | 19021 | 1620 | 10 |
250256 | 250256 | 2020-06-18 | Buena Vista | Iowa | 19021 | 1627 | 10 |
253371 | 253371 | 2020-06-19 | Buena Vista | Iowa | 19021 | 1640 | 10 |
256491 | 256491 | 2020-06-20 | Buena Vista | Iowa | 19021 | 1649 | 10 |
259617 | 259617 | 2020-06-21 | Buena Vista | Iowa | 19021 | 1667 | 10 |
262744 | 262744 | 2020-06-22 | Buena Vista | Iowa | 19021 | 1669 | 10 |
265872 | 265872 | 2020-06-23 | Buena Vista | Iowa | 19021 | 1670 | 10 |
269002 | 269002 | 2020-06-24 | Buena Vista | Iowa | 19021 | 1675 | 10 |
272139 | 272139 | 2020-06-25 | Buena Vista | Iowa | 19021 | 1677 | 11 |
275281 | 275281 | 2020-06-26 | Buena Vista | Iowa | 19021 | 1687 | 11 |
278429 | 278429 | 2020-06-27 | Buena Vista | Iowa | 19021 | 1689 | 11 |
281577 | 281577 | 2020-06-28 | Buena Vista | Iowa | 19021 | 1692 | 11 |
284722 | 284722 | 2020-06-29 | Buena Vista | Iowa | 19021 | 1694 | 11 |
287871 | 287871 | 2020-06-30 | Buena Vista | Iowa | 19021 | 1695 | 11 |
291021 | 291021 | 2020-07-01 | Buena Vista | Iowa | 19021 | 1699 | 11 |
294175 | 294175 | 2020-07-02 | Buena Vista | Iowa | 19021 | 1705 | 11 |
297333 | 297333 | 2020-07-03 | Buena Vista | Iowa | 19021 | 1709 | 11 |
300495 | 300495 | 2020-07-04 | Buena Vista | Iowa | 19021 | 1711 | 11 |
303659 | 303659 | 2020-07-05 | Buena Vista | Iowa | 19021 | 1712 | 11 |
306824 | 306824 | 2020-07-06 | Buena Vista | Iowa | 19021 | 1714 | 11 |
309992 | 309992 | 2020-07-07 | Buena Vista | Iowa | 19021 | 1719 | 11 |
313162 | 313162 | 2020-07-08 | Buena Vista | Iowa | 19021 | 1724 | 11 |
316336 | 316336 | 2020-07-09 | Buena Vista | Iowa | 19021 | 1727 | 11 |
319509 | 319509 | 2020-07-10 | Buena Vista | Iowa | 19021 | 1733 | 11 |
322688 | 322688 | 2020-07-11 | Buena Vista | Iowa | 19021 | 1737 | 11 |
325869 | 325869 | 2020-07-12 | Buena Vista | Iowa | 19021 | 1738 | 11 |
329055 | 329055 | 2020-07-13 | Buena Vista | Iowa | 19021 | 1738 | 11 |
332242 | 332242 | 2020-07-14 | Buena Vista | Iowa | 19021 | 1738 | 11 |
335435 | 335435 | 2020-07-15 | Buena Vista | Iowa | 19021 | 1741 | 12 |
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);