ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Appanoose" and state = "Iowa" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12847 | 12847 | 2020-03-26 | Appanoose | Iowa | 19007 | 1 | 0 |
14534 | 14534 | 2020-03-27 | Appanoose | Iowa | 19007 | 1 | 0 |
16337 | 16337 | 2020-03-28 | Appanoose | Iowa | 19007 | 1 | 0 |
18242 | 18242 | 2020-03-29 | Appanoose | Iowa | 19007 | 1 | 0 |
20248 | 20248 | 2020-03-30 | Appanoose | Iowa | 19007 | 1 | 0 |
22343 | 22343 | 2020-03-31 | Appanoose | Iowa | 19007 | 1 | 0 |
24515 | 24515 | 2020-04-01 | Appanoose | Iowa | 19007 | 1 | 0 |
26755 | 26755 | 2020-04-02 | Appanoose | Iowa | 19007 | 1 | 0 |
29066 | 29066 | 2020-04-03 | Appanoose | Iowa | 19007 | 1 | 0 |
31434 | 31434 | 2020-04-04 | Appanoose | Iowa | 19007 | 1 | 0 |
33845 | 33845 | 2020-04-05 | Appanoose | Iowa | 19007 | 1 | 1 |
36298 | 36298 | 2020-04-06 | Appanoose | Iowa | 19007 | 1 | 1 |
38796 | 38796 | 2020-04-07 | Appanoose | Iowa | 19007 | 1 | 1 |
41342 | 41342 | 2020-04-08 | Appanoose | Iowa | 19007 | 1 | 1 |
43918 | 43918 | 2020-04-09 | Appanoose | Iowa | 19007 | 1 | 1 |
46523 | 46523 | 2020-04-10 | Appanoose | Iowa | 19007 | 1 | 1 |
49157 | 49157 | 2020-04-11 | Appanoose | Iowa | 19007 | 1 | 1 |
51821 | 51821 | 2020-04-12 | Appanoose | Iowa | 19007 | 1 | 1 |
54502 | 54502 | 2020-04-13 | Appanoose | Iowa | 19007 | 1 | 1 |
57195 | 57195 | 2020-04-14 | Appanoose | Iowa | 19007 | 1 | 1 |
59903 | 59903 | 2020-04-15 | Appanoose | Iowa | 19007 | 1 | 1 |
62624 | 62624 | 2020-04-16 | Appanoose | Iowa | 19007 | 2 | 1 |
65358 | 65358 | 2020-04-17 | Appanoose | Iowa | 19007 | 2 | 1 |
68107 | 68107 | 2020-04-18 | Appanoose | Iowa | 19007 | 2 | 2 |
70869 | 70869 | 2020-04-19 | Appanoose | Iowa | 19007 | 2 | 2 |
73640 | 73640 | 2020-04-20 | Appanoose | Iowa | 19007 | 2 | 2 |
76417 | 76417 | 2020-04-21 | Appanoose | Iowa | 19007 | 2 | 2 |
79201 | 79201 | 2020-04-22 | Appanoose | Iowa | 19007 | 2 | 2 |
81994 | 81994 | 2020-04-23 | Appanoose | Iowa | 19007 | 2 | 2 |
84794 | 84794 | 2020-04-24 | Appanoose | Iowa | 19007 | 2 | 2 |
87604 | 87604 | 2020-04-25 | Appanoose | Iowa | 19007 | 2 | 2 |
90420 | 90420 | 2020-04-26 | Appanoose | Iowa | 19007 | 2 | 2 |
93239 | 93239 | 2020-04-27 | Appanoose | Iowa | 19007 | 2 | 2 |
96071 | 96071 | 2020-04-28 | Appanoose | Iowa | 19007 | 2 | 2 |
98915 | 98915 | 2020-04-29 | Appanoose | Iowa | 19007 | 2 | 2 |
101766 | 101766 | 2020-04-30 | Appanoose | Iowa | 19007 | 2 | 2 |
104622 | 104622 | 2020-05-01 | Appanoose | Iowa | 19007 | 3 | 2 |
107487 | 107487 | 2020-05-02 | Appanoose | Iowa | 19007 | 3 | 2 |
110357 | 110357 | 2020-05-03 | Appanoose | Iowa | 19007 | 3 | 2 |
113232 | 113232 | 2020-05-04 | Appanoose | Iowa | 19007 | 4 | 3 |
116115 | 116115 | 2020-05-05 | Appanoose | Iowa | 19007 | 4 | 3 |
119075 | 119075 | 2020-05-06 | Appanoose | Iowa | 19007 | 4 | 3 |
122045 | 122045 | 2020-05-07 | Appanoose | Iowa | 19007 | 6 | 3 |
125025 | 125025 | 2020-05-08 | Appanoose | Iowa | 19007 | 6 | 3 |
128012 | 128012 | 2020-05-09 | Appanoose | Iowa | 19007 | 6 | 3 |
131003 | 131003 | 2020-05-10 | Appanoose | Iowa | 19007 | 6 | 3 |
133993 | 133993 | 2020-05-11 | Appanoose | Iowa | 19007 | 6 | 3 |
136982 | 136982 | 2020-05-12 | Appanoose | Iowa | 19007 | 7 | 3 |
139974 | 139974 | 2020-05-13 | Appanoose | Iowa | 19007 | 7 | 3 |
142970 | 142970 | 2020-05-14 | Appanoose | Iowa | 19007 | 7 | 3 |
145970 | 145970 | 2020-05-15 | Appanoose | Iowa | 19007 | 7 | 3 |
148974 | 148974 | 2020-05-16 | Appanoose | Iowa | 19007 | 7 | 3 |
151984 | 151984 | 2020-05-17 | Appanoose | Iowa | 19007 | 8 | 3 |
154996 | 154996 | 2020-05-18 | Appanoose | Iowa | 19007 | 8 | 3 |
158012 | 158012 | 2020-05-19 | Appanoose | Iowa | 19007 | 8 | 3 |
161038 | 161038 | 2020-05-20 | Appanoose | Iowa | 19007 | 8 | 3 |
164066 | 164066 | 2020-05-21 | Appanoose | Iowa | 19007 | 8 | 3 |
167099 | 167099 | 2020-05-22 | Appanoose | Iowa | 19007 | 8 | 3 |
170136 | 170136 | 2020-05-23 | Appanoose | Iowa | 19007 | 8 | 3 |
173177 | 173177 | 2020-05-24 | Appanoose | Iowa | 19007 | 12 | 3 |
176221 | 176221 | 2020-05-25 | Appanoose | Iowa | 19007 | 12 | 3 |
179265 | 179265 | 2020-05-26 | Appanoose | Iowa | 19007 | 13 | 3 |
182309 | 182309 | 2020-05-27 | Appanoose | Iowa | 19007 | 13 | 3 |
185363 | 185363 | 2020-05-28 | Appanoose | Iowa | 19007 | 14 | 3 |
188421 | 188421 | 2020-05-29 | Appanoose | Iowa | 19007 | 14 | 3 |
191486 | 191486 | 2020-05-30 | Appanoose | Iowa | 19007 | 15 | 3 |
194553 | 194553 | 2020-05-31 | Appanoose | Iowa | 19007 | 15 | 3 |
197623 | 197623 | 2020-06-01 | Appanoose | Iowa | 19007 | 14 | 3 |
200696 | 200696 | 2020-06-02 | Appanoose | Iowa | 19007 | 14 | 3 |
203772 | 203772 | 2020-06-03 | Appanoose | Iowa | 19007 | 14 | 3 |
206852 | 206852 | 2020-06-04 | Appanoose | Iowa | 19007 | 17 | 3 |
209933 | 209933 | 2020-06-05 | Appanoose | Iowa | 19007 | 17 | 3 |
213018 | 213018 | 2020-06-06 | Appanoose | Iowa | 19007 | 17 | 3 |
216105 | 216105 | 2020-06-07 | Appanoose | Iowa | 19007 | 17 | 3 |
219197 | 219197 | 2020-06-08 | Appanoose | Iowa | 19007 | 16 | 3 |
222292 | 222292 | 2020-06-09 | Appanoose | Iowa | 19007 | 16 | 3 |
225387 | 225387 | 2020-06-10 | Appanoose | Iowa | 19007 | 16 | 3 |
228489 | 228489 | 2020-06-11 | Appanoose | Iowa | 19007 | 16 | 3 |
231592 | 231592 | 2020-06-12 | Appanoose | Iowa | 19007 | 16 | 3 |
234698 | 234698 | 2020-06-13 | Appanoose | Iowa | 19007 | 16 | 3 |
237805 | 237805 | 2020-06-14 | Appanoose | Iowa | 19007 | 17 | 3 |
240913 | 240913 | 2020-06-15 | Appanoose | Iowa | 19007 | 17 | 3 |
244024 | 244024 | 2020-06-16 | Appanoose | Iowa | 19007 | 17 | 3 |
247137 | 247137 | 2020-06-17 | Appanoose | Iowa | 19007 | 17 | 3 |
250249 | 250249 | 2020-06-18 | Appanoose | Iowa | 19007 | 18 | 3 |
253364 | 253364 | 2020-06-19 | Appanoose | Iowa | 19007 | 18 | 3 |
256484 | 256484 | 2020-06-20 | Appanoose | Iowa | 19007 | 18 | 3 |
259610 | 259610 | 2020-06-21 | Appanoose | Iowa | 19007 | 20 | 3 |
262737 | 262737 | 2020-06-22 | Appanoose | Iowa | 19007 | 20 | 3 |
265865 | 265865 | 2020-06-23 | Appanoose | Iowa | 19007 | 20 | 3 |
268995 | 268995 | 2020-06-24 | Appanoose | Iowa | 19007 | 20 | 3 |
272132 | 272132 | 2020-06-25 | Appanoose | Iowa | 19007 | 20 | 3 |
275274 | 275274 | 2020-06-26 | Appanoose | Iowa | 19007 | 20 | 3 |
278422 | 278422 | 2020-06-27 | Appanoose | Iowa | 19007 | 20 | 3 |
281570 | 281570 | 2020-06-28 | Appanoose | Iowa | 19007 | 20 | 3 |
284715 | 284715 | 2020-06-29 | Appanoose | Iowa | 19007 | 20 | 3 |
287864 | 287864 | 2020-06-30 | Appanoose | Iowa | 19007 | 20 | 3 |
291014 | 291014 | 2020-07-01 | Appanoose | Iowa | 19007 | 20 | 3 |
294168 | 294168 | 2020-07-02 | Appanoose | Iowa | 19007 | 20 | 3 |
297326 | 297326 | 2020-07-03 | Appanoose | Iowa | 19007 | 20 | 3 |
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);