ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Wapello" and state = "Iowa" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
8634 | 8634 | 2020-03-23 | Wapello | Iowa | 19179 | 1 | 0 |
9913 | 9913 | 2020-03-24 | Wapello | Iowa | 19179 | 1 | 0 |
11310 | 11310 | 2020-03-25 | Wapello | Iowa | 19179 | 1 | 0 |
12877 | 12877 | 2020-03-26 | Wapello | Iowa | 19179 | 1 | 0 |
14571 | 14571 | 2020-03-27 | Wapello | Iowa | 19179 | 1 | 0 |
16378 | 16378 | 2020-03-28 | Wapello | Iowa | 19179 | 1 | 0 |
18283 | 18283 | 2020-03-29 | Wapello | Iowa | 19179 | 1 | 0 |
20295 | 20295 | 2020-03-30 | Wapello | Iowa | 19179 | 1 | 0 |
22391 | 22391 | 2020-03-31 | Wapello | Iowa | 19179 | 1 | 0 |
24566 | 24566 | 2020-04-01 | Wapello | Iowa | 19179 | 1 | 0 |
26808 | 26808 | 2020-04-02 | Wapello | Iowa | 19179 | 1 | 0 |
29122 | 29122 | 2020-04-03 | Wapello | Iowa | 19179 | 1 | 0 |
31494 | 31494 | 2020-04-04 | Wapello | Iowa | 19179 | 1 | 0 |
33907 | 33907 | 2020-04-05 | Wapello | Iowa | 19179 | 1 | 0 |
36363 | 36363 | 2020-04-06 | Wapello | Iowa | 19179 | 2 | 0 |
38864 | 38864 | 2020-04-07 | Wapello | Iowa | 19179 | 2 | 0 |
41410 | 41410 | 2020-04-08 | Wapello | Iowa | 19179 | 2 | 0 |
43986 | 43986 | 2020-04-09 | Wapello | Iowa | 19179 | 2 | 0 |
46593 | 46593 | 2020-04-10 | Wapello | Iowa | 19179 | 3 | 0 |
49227 | 49227 | 2020-04-11 | Wapello | Iowa | 19179 | 4 | 0 |
51891 | 51891 | 2020-04-12 | Wapello | Iowa | 19179 | 4 | 0 |
54573 | 54573 | 2020-04-13 | Wapello | Iowa | 19179 | 6 | 0 |
57266 | 57266 | 2020-04-14 | Wapello | Iowa | 19179 | 7 | 0 |
59974 | 59974 | 2020-04-15 | Wapello | Iowa | 19179 | 7 | 0 |
62695 | 62695 | 2020-04-16 | Wapello | Iowa | 19179 | 6 | 0 |
65430 | 65430 | 2020-04-17 | Wapello | Iowa | 19179 | 6 | 0 |
68179 | 68179 | 2020-04-18 | Wapello | Iowa | 19179 | 7 | 0 |
70940 | 70940 | 2020-04-19 | Wapello | Iowa | 19179 | 7 | 0 |
73711 | 73711 | 2020-04-20 | Wapello | Iowa | 19179 | 7 | 0 |
76491 | 76491 | 2020-04-21 | Wapello | Iowa | 19179 | 7 | 0 |
79275 | 79275 | 2020-04-22 | Wapello | Iowa | 19179 | 7 | 0 |
82067 | 82067 | 2020-04-23 | Wapello | Iowa | 19179 | 7 | 0 |
84868 | 84868 | 2020-04-24 | Wapello | Iowa | 19179 | 8 | 0 |
87677 | 87677 | 2020-04-25 | Wapello | Iowa | 19179 | 8 | 0 |
90493 | 90493 | 2020-04-26 | Wapello | Iowa | 19179 | 10 | 0 |
93314 | 93314 | 2020-04-27 | Wapello | Iowa | 19179 | 10 | 0 |
96146 | 96146 | 2020-04-28 | Wapello | Iowa | 19179 | 10 | 0 |
98991 | 98991 | 2020-04-29 | Wapello | Iowa | 19179 | 10 | 0 |
101842 | 101842 | 2020-04-30 | Wapello | Iowa | 19179 | 10 | 0 |
104701 | 104701 | 2020-05-01 | Wapello | Iowa | 19179 | 17 | 0 |
107566 | 107566 | 2020-05-02 | Wapello | Iowa | 19179 | 27 | 0 |
110437 | 110437 | 2020-05-03 | Wapello | Iowa | 19179 | 61 | 0 |
113312 | 113312 | 2020-05-04 | Wapello | Iowa | 19179 | 94 | 0 |
116194 | 116194 | 2020-05-05 | Wapello | Iowa | 19179 | 108 | 0 |
119155 | 119155 | 2020-05-06 | Wapello | Iowa | 19179 | 125 | 0 |
122125 | 122125 | 2020-05-07 | Wapello | Iowa | 19179 | 165 | 0 |
125107 | 125107 | 2020-05-08 | Wapello | Iowa | 19179 | 192 | 0 |
128094 | 128094 | 2020-05-09 | Wapello | Iowa | 19179 | 212 | 0 |
131084 | 131084 | 2020-05-10 | Wapello | Iowa | 19179 | 218 | 0 |
134075 | 134075 | 2020-05-11 | Wapello | Iowa | 19179 | 259 | 0 |
137065 | 137065 | 2020-05-12 | Wapello | Iowa | 19179 | 283 | 0 |
140058 | 140058 | 2020-05-13 | Wapello | Iowa | 19179 | 306 | 2 |
143054 | 143054 | 2020-05-14 | Wapello | Iowa | 19179 | 328 | 2 |
146054 | 146054 | 2020-05-15 | Wapello | Iowa | 19179 | 350 | 2 |
149058 | 149058 | 2020-05-16 | Wapello | Iowa | 19179 | 360 | 2 |
152069 | 152069 | 2020-05-17 | Wapello | Iowa | 19179 | 379 | 2 |
155081 | 155081 | 2020-05-18 | Wapello | Iowa | 19179 | 396 | 2 |
158098 | 158098 | 2020-05-19 | Wapello | Iowa | 19179 | 405 | 2 |
161123 | 161123 | 2020-05-20 | Wapello | Iowa | 19179 | 420 | 3 |
164152 | 164152 | 2020-05-21 | Wapello | Iowa | 19179 | 450 | 3 |
167184 | 167184 | 2020-05-22 | Wapello | Iowa | 19179 | 462 | 3 |
170222 | 170222 | 2020-05-23 | Wapello | Iowa | 19179 | 462 | 3 |
173263 | 173263 | 2020-05-24 | Wapello | Iowa | 19179 | 511 | 4 |
176307 | 176307 | 2020-05-25 | Wapello | Iowa | 19179 | 514 | 4 |
179351 | 179351 | 2020-05-26 | Wapello | Iowa | 19179 | 517 | 4 |
182396 | 182396 | 2020-05-27 | Wapello | Iowa | 19179 | 540 | 4 |
185450 | 185450 | 2020-05-28 | Wapello | Iowa | 19179 | 548 | 7 |
188508 | 188508 | 2020-05-29 | Wapello | Iowa | 19179 | 556 | 8 |
191572 | 191572 | 2020-05-30 | Wapello | Iowa | 19179 | 577 | 9 |
194640 | 194640 | 2020-05-31 | Wapello | Iowa | 19179 | 595 | 10 |
197710 | 197710 | 2020-06-01 | Wapello | Iowa | 19179 | 600 | 12 |
200782 | 200782 | 2020-06-02 | Wapello | Iowa | 19179 | 610 | 13 |
203858 | 203858 | 2020-06-03 | Wapello | Iowa | 19179 | 615 | 14 |
206939 | 206939 | 2020-06-04 | Wapello | Iowa | 19179 | 630 | 14 |
210020 | 210020 | 2020-06-05 | Wapello | Iowa | 19179 | 640 | 15 |
213105 | 213105 | 2020-06-06 | Wapello | Iowa | 19179 | 641 | 16 |
216192 | 216192 | 2020-06-07 | Wapello | Iowa | 19179 | 648 | 18 |
219284 | 219284 | 2020-06-08 | Wapello | Iowa | 19179 | 654 | 21 |
222379 | 222379 | 2020-06-09 | Wapello | Iowa | 19179 | 658 | 21 |
225474 | 225474 | 2020-06-10 | Wapello | Iowa | 19179 | 660 | 23 |
228576 | 228576 | 2020-06-11 | Wapello | Iowa | 19179 | 668 | 24 |
231679 | 231679 | 2020-06-12 | Wapello | Iowa | 19179 | 672 | 26 |
234785 | 234785 | 2020-06-13 | Wapello | Iowa | 19179 | 674 | 26 |
237892 | 237892 | 2020-06-14 | Wapello | Iowa | 19179 | 675 | 26 |
241000 | 241000 | 2020-06-15 | Wapello | Iowa | 19179 | 675 | 26 |
244111 | 244111 | 2020-06-16 | Wapello | Iowa | 19179 | 677 | 26 |
247224 | 247224 | 2020-06-17 | Wapello | Iowa | 19179 | 679 | 26 |
250336 | 250336 | 2020-06-18 | Wapello | Iowa | 19179 | 681 | 26 |
253451 | 253451 | 2020-06-19 | Wapello | Iowa | 19179 | 681 | 27 |
256571 | 256571 | 2020-06-20 | Wapello | Iowa | 19179 | 682 | 27 |
259697 | 259697 | 2020-06-21 | Wapello | Iowa | 19179 | 689 | 27 |
262824 | 262824 | 2020-06-22 | Wapello | Iowa | 19179 | 689 | 27 |
265952 | 265952 | 2020-06-23 | Wapello | Iowa | 19179 | 689 | 28 |
269082 | 269082 | 2020-06-24 | Wapello | Iowa | 19179 | 692 | 28 |
272219 | 272219 | 2020-06-25 | Wapello | Iowa | 19179 | 692 | 28 |
275361 | 275361 | 2020-06-26 | Wapello | Iowa | 19179 | 694 | 29 |
278509 | 278509 | 2020-06-27 | Wapello | Iowa | 19179 | 694 | 29 |
281657 | 281657 | 2020-06-28 | Wapello | Iowa | 19179 | 696 | 29 |
284802 | 284802 | 2020-06-29 | Wapello | Iowa | 19179 | 699 | 30 |
287951 | 287951 | 2020-06-30 | Wapello | Iowa | 19179 | 700 | 30 |
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);