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 rowid
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 |
250337 | 250337 | 2020-06-18 | Warren | Iowa | 19181 | 201 | 2 |
253452 | 253452 | 2020-06-19 | Warren | Iowa | 19181 | 207 | 2 |
256572 | 256572 | 2020-06-20 | Warren | Iowa | 19181 | 209 | 2 |
259698 | 259698 | 2020-06-21 | Warren | Iowa | 19181 | 211 | 2 |
262825 | 262825 | 2020-06-22 | Warren | Iowa | 19181 | 214 | 2 |
265953 | 265953 | 2020-06-23 | Warren | Iowa | 19181 | 214 | 2 |
269083 | 269083 | 2020-06-24 | Warren | Iowa | 19181 | 215 | 2 |
272220 | 272220 | 2020-06-25 | Warren | Iowa | 19181 | 221 | 2 |
275362 | 275362 | 2020-06-26 | Warren | Iowa | 19181 | 224 | 2 |
278510 | 278510 | 2020-06-27 | Warren | Iowa | 19181 | 231 | 2 |
281658 | 281658 | 2020-06-28 | Warren | Iowa | 19181 | 237 | 2 |
284803 | 284803 | 2020-06-29 | Warren | Iowa | 19181 | 243 | 2 |
287952 | 287952 | 2020-06-30 | Warren | Iowa | 19181 | 245 | 2 |
291102 | 291102 | 2020-07-01 | Warren | Iowa | 19181 | 252 | 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);