ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Warren" and fips = 19181 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
9914 | 9914 | 2020-03-24 | Warren | Iowa | 19181 | 1 | 0 |
11311 | 11311 | 2020-03-25 | Warren | Iowa | 19181 | 1 | 0 |
12878 | 12878 | 2020-03-26 | Warren | Iowa | 19181 | 1 | 0 |
14572 | 14572 | 2020-03-27 | Warren | Iowa | 19181 | 1 | 0 |
16379 | 16379 | 2020-03-28 | Warren | Iowa | 19181 | 1 | 0 |
18284 | 18284 | 2020-03-29 | Warren | Iowa | 19181 | 1 | 0 |
20296 | 20296 | 2020-03-30 | Warren | Iowa | 19181 | 1 | 0 |
22392 | 22392 | 2020-03-31 | Warren | Iowa | 19181 | 3 | 0 |
24567 | 24567 | 2020-04-01 | Warren | Iowa | 19181 | 4 | 0 |
26809 | 26809 | 2020-04-02 | Warren | Iowa | 19181 | 6 | 0 |
29123 | 29123 | 2020-04-03 | Warren | Iowa | 19181 | 8 | 0 |
31495 | 31495 | 2020-04-04 | Warren | Iowa | 19181 | 9 | 0 |
33908 | 33908 | 2020-04-05 | Warren | Iowa | 19181 | 10 | 0 |
36364 | 36364 | 2020-04-06 | Warren | Iowa | 19181 | 11 | 0 |
38865 | 38865 | 2020-04-07 | Warren | Iowa | 19181 | 12 | 0 |
41411 | 41411 | 2020-04-08 | Warren | Iowa | 19181 | 13 | 0 |
43987 | 43987 | 2020-04-09 | Warren | Iowa | 19181 | 13 | 0 |
46594 | 46594 | 2020-04-10 | Warren | Iowa | 19181 | 15 | 0 |
49228 | 49228 | 2020-04-11 | Warren | Iowa | 19181 | 15 | 0 |
51892 | 51892 | 2020-04-12 | Warren | Iowa | 19181 | 16 | 0 |
54574 | 54574 | 2020-04-13 | Warren | Iowa | 19181 | 14 | 0 |
57267 | 57267 | 2020-04-14 | Warren | Iowa | 19181 | 15 | 0 |
59975 | 59975 | 2020-04-15 | Warren | Iowa | 19181 | 16 | 0 |
62696 | 62696 | 2020-04-16 | Warren | Iowa | 19181 | 17 | 0 |
65431 | 65431 | 2020-04-17 | Warren | Iowa | 19181 | 17 | 0 |
68180 | 68180 | 2020-04-18 | Warren | Iowa | 19181 | 18 | 0 |
70941 | 70941 | 2020-04-19 | Warren | Iowa | 19181 | 19 | 0 |
73712 | 73712 | 2020-04-20 | Warren | Iowa | 19181 | 20 | 0 |
76492 | 76492 | 2020-04-21 | Warren | Iowa | 19181 | 20 | 0 |
79276 | 79276 | 2020-04-22 | Warren | Iowa | 19181 | 18 | 0 |
82068 | 82068 | 2020-04-23 | Warren | Iowa | 19181 | 18 | 0 |
84869 | 84869 | 2020-04-24 | Warren | Iowa | 19181 | 19 | 0 |
87678 | 87678 | 2020-04-25 | Warren | Iowa | 19181 | 20 | 0 |
90494 | 90494 | 2020-04-26 | Warren | Iowa | 19181 | 20 | 0 |
93315 | 93315 | 2020-04-27 | Warren | Iowa | 19181 | 20 | 0 |
96147 | 96147 | 2020-04-28 | Warren | Iowa | 19181 | 20 | 0 |
98992 | 98992 | 2020-04-29 | Warren | Iowa | 19181 | 21 | 0 |
101843 | 101843 | 2020-04-30 | Warren | Iowa | 19181 | 22 | 0 |
104702 | 104702 | 2020-05-01 | Warren | Iowa | 19181 | 25 | 0 |
107567 | 107567 | 2020-05-02 | Warren | Iowa | 19181 | 25 | 0 |
110438 | 110438 | 2020-05-03 | Warren | Iowa | 19181 | 26 | 0 |
113313 | 113313 | 2020-05-04 | Warren | Iowa | 19181 | 27 | 0 |
116195 | 116195 | 2020-05-05 | Warren | Iowa | 19181 | 28 | 0 |
119156 | 119156 | 2020-05-06 | Warren | Iowa | 19181 | 34 | 0 |
122126 | 122126 | 2020-05-07 | Warren | Iowa | 19181 | 35 | 0 |
125108 | 125108 | 2020-05-08 | Warren | Iowa | 19181 | 39 | 0 |
128095 | 128095 | 2020-05-09 | Warren | Iowa | 19181 | 42 | 0 |
131085 | 131085 | 2020-05-10 | Warren | Iowa | 19181 | 42 | 0 |
134076 | 134076 | 2020-05-11 | Warren | Iowa | 19181 | 44 | 0 |
137066 | 137066 | 2020-05-12 | Warren | Iowa | 19181 | 49 | 0 |
140059 | 140059 | 2020-05-13 | Warren | Iowa | 19181 | 52 | 0 |
143055 | 143055 | 2020-05-14 | Warren | Iowa | 19181 | 53 | 0 |
146055 | 146055 | 2020-05-15 | Warren | Iowa | 19181 | 63 | 0 |
149059 | 149059 | 2020-05-16 | Warren | Iowa | 19181 | 66 | 0 |
152070 | 152070 | 2020-05-17 | Warren | Iowa | 19181 | 72 | 0 |
155082 | 155082 | 2020-05-18 | Warren | Iowa | 19181 | 77 | 0 |
158099 | 158099 | 2020-05-19 | Warren | Iowa | 19181 | 87 | 0 |
161124 | 161124 | 2020-05-20 | Warren | Iowa | 19181 | 89 | 0 |
164153 | 164153 | 2020-05-21 | Warren | Iowa | 19181 | 90 | 0 |
167185 | 167185 | 2020-05-22 | Warren | Iowa | 19181 | 99 | 0 |
170223 | 170223 | 2020-05-23 | Warren | Iowa | 19181 | 99 | 0 |
173264 | 173264 | 2020-05-24 | Warren | Iowa | 19181 | 108 | 0 |
176308 | 176308 | 2020-05-25 | Warren | Iowa | 19181 | 112 | 0 |
179352 | 179352 | 2020-05-26 | Warren | Iowa | 19181 | 112 | 0 |
182397 | 182397 | 2020-05-27 | Warren | Iowa | 19181 | 115 | 0 |
185451 | 185451 | 2020-05-28 | Warren | Iowa | 19181 | 118 | 0 |
188509 | 188509 | 2020-05-29 | Warren | Iowa | 19181 | 121 | 0 |
191573 | 191573 | 2020-05-30 | Warren | Iowa | 19181 | 130 | 0 |
194641 | 194641 | 2020-05-31 | Warren | Iowa | 19181 | 133 | 0 |
197711 | 197711 | 2020-06-01 | Warren | Iowa | 19181 | 139 | 0 |
200783 | 200783 | 2020-06-02 | Warren | Iowa | 19181 | 144 | 0 |
203859 | 203859 | 2020-06-03 | Warren | Iowa | 19181 | 155 | 0 |
206940 | 206940 | 2020-06-04 | Warren | Iowa | 19181 | 167 | 1 |
210021 | 210021 | 2020-06-05 | Warren | Iowa | 19181 | 171 | 1 |
213106 | 213106 | 2020-06-06 | Warren | Iowa | 19181 | 174 | 1 |
216193 | 216193 | 2020-06-07 | Warren | Iowa | 19181 | 174 | 1 |
219285 | 219285 | 2020-06-08 | Warren | Iowa | 19181 | 174 | 1 |
222380 | 222380 | 2020-06-09 | Warren | Iowa | 19181 | 177 | 1 |
225475 | 225475 | 2020-06-10 | Warren | Iowa | 19181 | 184 | 1 |
228577 | 228577 | 2020-06-11 | Warren | Iowa | 19181 | 189 | 1 |
231680 | 231680 | 2020-06-12 | Warren | Iowa | 19181 | 191 | 1 |
234786 | 234786 | 2020-06-13 | Warren | Iowa | 19181 | 193 | 1 |
237893 | 237893 | 2020-06-14 | Warren | Iowa | 19181 | 197 | 1 |
241001 | 241001 | 2020-06-15 | Warren | Iowa | 19181 | 197 | 1 |
244112 | 244112 | 2020-06-16 | Warren | Iowa | 19181 | 198 | 1 |
247225 | 247225 | 2020-06-17 | Warren | Iowa | 19181 | 201 | 1 |
291102 | 291102 | 2020-07-01 | Warren | Iowa | 19181 | 252 | 1 |
294256 | 294256 | 2020-07-02 | Warren | Iowa | 19181 | 258 | 1 |
297414 | 297414 | 2020-07-03 | Warren | Iowa | 19181 | 267 | 1 |
300576 | 300576 | 2020-07-04 | Warren | Iowa | 19181 | 277 | 1 |
303740 | 303740 | 2020-07-05 | Warren | Iowa | 19181 | 290 | 1 |
306905 | 306905 | 2020-07-06 | Warren | Iowa | 19181 | 290 | 1 |
310073 | 310073 | 2020-07-07 | Warren | Iowa | 19181 | 291 | 1 |
313243 | 313243 | 2020-07-08 | Warren | Iowa | 19181 | 298 | 1 |
316417 | 316417 | 2020-07-09 | Warren | Iowa | 19181 | 300 | 1 |
319590 | 319590 | 2020-07-10 | Warren | Iowa | 19181 | 312 | 1 |
322769 | 322769 | 2020-07-11 | Warren | Iowa | 19181 | 319 | 1 |
325950 | 325950 | 2020-07-12 | Warren | Iowa | 19181 | 333 | 1 |
329136 | 329136 | 2020-07-13 | Warren | Iowa | 19181 | 337 | 1 |
332323 | 332323 | 2020-07-14 | Warren | Iowa | 19181 | 337 | 1 |
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);