ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 19173 and state = "Iowa" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
16377 | 16377 | 2020-03-28 | Taylor | Iowa | 19173 | 1 | 0 |
18282 | 18282 | 2020-03-29 | Taylor | Iowa | 19173 | 1 | 0 |
20293 | 20293 | 2020-03-30 | Taylor | Iowa | 19173 | 1 | 0 |
22389 | 22389 | 2020-03-31 | Taylor | Iowa | 19173 | 1 | 0 |
24563 | 24563 | 2020-04-01 | Taylor | Iowa | 19173 | 1 | 0 |
26806 | 26806 | 2020-04-02 | Taylor | Iowa | 19173 | 1 | 0 |
29120 | 29120 | 2020-04-03 | Taylor | Iowa | 19173 | 1 | 0 |
31492 | 31492 | 2020-04-04 | Taylor | Iowa | 19173 | 1 | 0 |
33905 | 33905 | 2020-04-05 | Taylor | Iowa | 19173 | 1 | 0 |
36361 | 36361 | 2020-04-06 | Taylor | Iowa | 19173 | 1 | 0 |
38862 | 38862 | 2020-04-07 | Taylor | Iowa | 19173 | 1 | 0 |
41408 | 41408 | 2020-04-08 | Taylor | Iowa | 19173 | 1 | 0 |
43984 | 43984 | 2020-04-09 | Taylor | Iowa | 19173 | 1 | 0 |
46590 | 46590 | 2020-04-10 | Taylor | Iowa | 19173 | 1 | 0 |
49224 | 49224 | 2020-04-11 | Taylor | Iowa | 19173 | 1 | 0 |
51888 | 51888 | 2020-04-12 | Taylor | Iowa | 19173 | 1 | 0 |
54570 | 54570 | 2020-04-13 | Taylor | Iowa | 19173 | 1 | 0 |
57263 | 57263 | 2020-04-14 | Taylor | Iowa | 19173 | 1 | 0 |
59971 | 59971 | 2020-04-15 | Taylor | Iowa | 19173 | 1 | 0 |
62692 | 62692 | 2020-04-16 | Taylor | Iowa | 19173 | 1 | 0 |
65426 | 65426 | 2020-04-17 | Taylor | Iowa | 19173 | 1 | 0 |
68175 | 68175 | 2020-04-18 | Taylor | Iowa | 19173 | 1 | 0 |
70937 | 70937 | 2020-04-19 | Taylor | Iowa | 19173 | 1 | 0 |
73708 | 73708 | 2020-04-20 | Taylor | Iowa | 19173 | 1 | 0 |
76487 | 76487 | 2020-04-21 | Taylor | Iowa | 19173 | 1 | 0 |
79271 | 79271 | 2020-04-22 | Taylor | Iowa | 19173 | 1 | 0 |
82064 | 82064 | 2020-04-23 | Taylor | Iowa | 19173 | 1 | 0 |
84864 | 84864 | 2020-04-24 | Taylor | Iowa | 19173 | 1 | 0 |
87674 | 87674 | 2020-04-25 | Taylor | Iowa | 19173 | 1 | 0 |
90490 | 90490 | 2020-04-26 | Taylor | Iowa | 19173 | 1 | 0 |
93310 | 93310 | 2020-04-27 | Taylor | Iowa | 19173 | 1 | 0 |
96142 | 96142 | 2020-04-28 | Taylor | Iowa | 19173 | 1 | 0 |
98987 | 98987 | 2020-04-29 | Taylor | Iowa | 19173 | 1 | 0 |
101838 | 101838 | 2020-04-30 | Taylor | Iowa | 19173 | 1 | 0 |
104697 | 104697 | 2020-05-01 | Taylor | Iowa | 19173 | 1 | 0 |
107562 | 107562 | 2020-05-02 | Taylor | Iowa | 19173 | 1 | 0 |
110433 | 110433 | 2020-05-03 | Taylor | Iowa | 19173 | 1 | 0 |
113308 | 113308 | 2020-05-04 | Taylor | Iowa | 19173 | 1 | 0 |
116191 | 116191 | 2020-05-05 | Taylor | Iowa | 19173 | 1 | 0 |
119151 | 119151 | 2020-05-06 | Taylor | Iowa | 19173 | 1 | 0 |
122121 | 122121 | 2020-05-07 | Taylor | Iowa | 19173 | 1 | 0 |
125103 | 125103 | 2020-05-08 | Taylor | Iowa | 19173 | 1 | 0 |
128090 | 128090 | 2020-05-09 | Taylor | Iowa | 19173 | 1 | 0 |
131081 | 131081 | 2020-05-10 | Taylor | Iowa | 19173 | 1 | 0 |
134071 | 134071 | 2020-05-11 | Taylor | Iowa | 19173 | 1 | 0 |
137061 | 137061 | 2020-05-12 | Taylor | Iowa | 19173 | 1 | 0 |
140054 | 140054 | 2020-05-13 | Taylor | Iowa | 19173 | 1 | 0 |
143050 | 143050 | 2020-05-14 | Taylor | Iowa | 19173 | 1 | 0 |
146050 | 146050 | 2020-05-15 | Taylor | Iowa | 19173 | 1 | 0 |
149054 | 149054 | 2020-05-16 | Taylor | Iowa | 19173 | 1 | 0 |
152065 | 152065 | 2020-05-17 | Taylor | Iowa | 19173 | 2 | 0 |
155077 | 155077 | 2020-05-18 | Taylor | Iowa | 19173 | 2 | 0 |
158094 | 158094 | 2020-05-19 | Taylor | Iowa | 19173 | 3 | 0 |
161120 | 161120 | 2020-05-20 | Taylor | Iowa | 19173 | 5 | 0 |
164148 | 164148 | 2020-05-21 | Taylor | Iowa | 19173 | 5 | 0 |
167181 | 167181 | 2020-05-22 | Taylor | Iowa | 19173 | 7 | 0 |
170218 | 170218 | 2020-05-23 | Taylor | Iowa | 19173 | 7 | 0 |
173259 | 173259 | 2020-05-24 | Taylor | Iowa | 19173 | 37 | 0 |
176303 | 176303 | 2020-05-25 | Taylor | Iowa | 19173 | 39 | 0 |
179347 | 179347 | 2020-05-26 | Taylor | Iowa | 19173 | 41 | 0 |
182392 | 182392 | 2020-05-27 | Taylor | Iowa | 19173 | 49 | 0 |
185446 | 185446 | 2020-05-28 | Taylor | Iowa | 19173 | 49 | 0 |
188504 | 188504 | 2020-05-29 | Taylor | Iowa | 19173 | 51 | 0 |
191569 | 191569 | 2020-05-30 | Taylor | Iowa | 19173 | 54 | 0 |
194636 | 194636 | 2020-05-31 | Taylor | Iowa | 19173 | 56 | 0 |
197706 | 197706 | 2020-06-01 | Taylor | Iowa | 19173 | 56 | 0 |
200779 | 200779 | 2020-06-02 | Taylor | Iowa | 19173 | 58 | 0 |
203855 | 203855 | 2020-06-03 | Taylor | Iowa | 19173 | 59 | 0 |
206935 | 206935 | 2020-06-04 | Taylor | Iowa | 19173 | 64 | 0 |
210016 | 210016 | 2020-06-05 | Taylor | Iowa | 19173 | 66 | 0 |
213101 | 213101 | 2020-06-06 | Taylor | Iowa | 19173 | 66 | 0 |
216188 | 216188 | 2020-06-07 | Taylor | Iowa | 19173 | 68 | 0 |
219280 | 219280 | 2020-06-08 | Taylor | Iowa | 19173 | 68 | 0 |
222375 | 222375 | 2020-06-09 | Taylor | Iowa | 19173 | 68 | 0 |
225470 | 225470 | 2020-06-10 | Taylor | Iowa | 19173 | 70 | 0 |
228572 | 228572 | 2020-06-11 | Taylor | Iowa | 19173 | 71 | 0 |
231675 | 231675 | 2020-06-12 | Taylor | Iowa | 19173 | 72 | 0 |
234781 | 234781 | 2020-06-13 | Taylor | Iowa | 19173 | 73 | 0 |
237888 | 237888 | 2020-06-14 | Taylor | Iowa | 19173 | 73 | 0 |
240996 | 240996 | 2020-06-15 | Taylor | Iowa | 19173 | 74 | 0 |
244107 | 244107 | 2020-06-16 | Taylor | Iowa | 19173 | 74 | 0 |
247220 | 247220 | 2020-06-17 | Taylor | Iowa | 19173 | 74 | 0 |
250332 | 250332 | 2020-06-18 | Taylor | Iowa | 19173 | 75 | 0 |
253447 | 253447 | 2020-06-19 | Taylor | Iowa | 19173 | 75 | 0 |
256567 | 256567 | 2020-06-20 | Taylor | Iowa | 19173 | 75 | 0 |
259693 | 259693 | 2020-06-21 | Taylor | Iowa | 19173 | 76 | 0 |
262820 | 262820 | 2020-06-22 | Taylor | Iowa | 19173 | 76 | 0 |
265948 | 265948 | 2020-06-23 | Taylor | Iowa | 19173 | 76 | 0 |
269078 | 269078 | 2020-06-24 | Taylor | Iowa | 19173 | 76 | 0 |
272215 | 272215 | 2020-06-25 | Taylor | Iowa | 19173 | 77 | 0 |
275357 | 275357 | 2020-06-26 | Taylor | Iowa | 19173 | 77 | 0 |
278505 | 278505 | 2020-06-27 | Taylor | Iowa | 19173 | 77 | 0 |
281653 | 281653 | 2020-06-28 | Taylor | Iowa | 19173 | 77 | 0 |
284798 | 284798 | 2020-06-29 | Taylor | Iowa | 19173 | 78 | 0 |
287947 | 287947 | 2020-06-30 | Taylor | Iowa | 19173 | 79 | 0 |
291097 | 291097 | 2020-07-01 | Taylor | Iowa | 19173 | 79 | 0 |
294251 | 294251 | 2020-07-02 | Taylor | Iowa | 19173 | 79 | 0 |
297409 | 297409 | 2020-07-03 | Taylor | Iowa | 19173 | 79 | 0 |
300571 | 300571 | 2020-07-04 | Taylor | Iowa | 19173 | 79 | 0 |
303735 | 303735 | 2020-07-05 | Taylor | Iowa | 19173 | 79 | 0 |
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);