ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,558 rows where county = "Iowa" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14553 | 14553 | 2020-03-27 | Iowa | Iowa | 19095 | 1 | 0 |
16357 | 16357 | 2020-03-28 | Iowa | Iowa | 19095 | 1 | 0 |
18262 | 18262 | 2020-03-29 | Iowa | Iowa | 19095 | 2 | 0 |
20271 | 20271 | 2020-03-30 | Iowa | Iowa | 19095 | 3 | 0 |
22367 | 22367 | 2020-03-31 | Iowa | Iowa | 19095 | 4 | 0 |
24539 | 24539 | 2020-04-01 | Iowa | Iowa | 19095 | 5 | 0 |
26780 | 26780 | 2020-04-02 | Iowa | Iowa | 19095 | 5 | 0 |
29091 | 29091 | 2020-04-03 | Iowa | Iowa | 19095 | 5 | 0 |
31461 | 31461 | 2020-04-04 | Iowa | Iowa | 19095 | 6 | 0 |
33874 | 33874 | 2020-04-05 | Iowa | Iowa | 19095 | 6 | 0 |
36329 | 36329 | 2020-04-06 | Iowa | Iowa | 19095 | 6 | 0 |
38830 | 38830 | 2020-04-07 | Iowa | Iowa | 19095 | 6 | 0 |
41376 | 41376 | 2020-04-08 | Iowa | Iowa | 19095 | 6 | 0 |
43952 | 43952 | 2020-04-09 | Iowa | Iowa | 19095 | 7 | 0 |
46557 | 46557 | 2020-04-10 | Iowa | Iowa | 19095 | 7 | 0 |
49191 | 49191 | 2020-04-11 | Iowa | Iowa | 19095 | 7 | 0 |
51855 | 51855 | 2020-04-12 | Iowa | Iowa | 19095 | 7 | 0 |
54537 | 54537 | 2020-04-13 | Iowa | Iowa | 19095 | 7 | 0 |
57230 | 57230 | 2020-04-14 | Iowa | Iowa | 19095 | 7 | 0 |
59938 | 59938 | 2020-04-15 | Iowa | Iowa | 19095 | 7 | 0 |
62659 | 62659 | 2020-04-16 | Iowa | Iowa | 19095 | 8 | 0 |
65393 | 65393 | 2020-04-17 | Iowa | Iowa | 19095 | 8 | 0 |
68142 | 68142 | 2020-04-18 | Iowa | Iowa | 19095 | 10 | 0 |
70904 | 70904 | 2020-04-19 | Iowa | Iowa | 19095 | 12 | 0 |
73675 | 73675 | 2020-04-20 | Iowa | Iowa | 19095 | 13 | 0 |
76454 | 76454 | 2020-04-21 | Iowa | Iowa | 19095 | 13 | 0 |
79238 | 79238 | 2020-04-22 | Iowa | Iowa | 19095 | 13 | 0 |
82031 | 82031 | 2020-04-23 | Iowa | Iowa | 19095 | 13 | 0 |
84831 | 84831 | 2020-04-24 | Iowa | Iowa | 19095 | 14 | 0 |
87641 | 87641 | 2020-04-25 | Iowa | Iowa | 19095 | 16 | 0 |
90457 | 90457 | 2020-04-26 | Iowa | Iowa | 19095 | 17 | 0 |
93276 | 93276 | 2020-04-27 | Iowa | Iowa | 19095 | 18 | 0 |
96108 | 96108 | 2020-04-28 | Iowa | Iowa | 19095 | 19 | 0 |
98953 | 98953 | 2020-04-29 | Iowa | Iowa | 19095 | 19 | 0 |
101804 | 101804 | 2020-04-30 | Iowa | Iowa | 19095 | 19 | 0 |
104662 | 104662 | 2020-05-01 | Iowa | Iowa | 19095 | 20 | 0 |
107527 | 107527 | 2020-05-02 | Iowa | Iowa | 19095 | 20 | 0 |
110397 | 110397 | 2020-05-03 | Iowa | Iowa | 19095 | 21 | 0 |
113272 | 113272 | 2020-05-04 | Iowa | Iowa | 19095 | 22 | 0 |
116155 | 116155 | 2020-05-05 | Iowa | Iowa | 19095 | 22 | 0 |
119115 | 119115 | 2020-05-06 | Iowa | Iowa | 19095 | 24 | 0 |
122085 | 122085 | 2020-05-07 | Iowa | Iowa | 19095 | 26 | 0 |
125066 | 125066 | 2020-05-08 | Iowa | Iowa | 19095 | 27 | 0 |
128053 | 128053 | 2020-05-09 | Iowa | Iowa | 19095 | 27 | 0 |
131044 | 131044 | 2020-05-10 | Iowa | Iowa | 19095 | 24 | 0 |
134034 | 134034 | 2020-05-11 | Iowa | Iowa | 19095 | 27 | 0 |
137024 | 137024 | 2020-05-12 | Iowa | Iowa | 19095 | 26 | 0 |
140017 | 140017 | 2020-05-13 | Iowa | Iowa | 19095 | 26 | 0 |
143013 | 143013 | 2020-05-14 | Iowa | Iowa | 19095 | 28 | 0 |
146013 | 146013 | 2020-05-15 | Iowa | Iowa | 19095 | 27 | 0 |
149017 | 149017 | 2020-05-16 | Iowa | Iowa | 19095 | 28 | 0 |
152027 | 152027 | 2020-05-17 | Iowa | Iowa | 19095 | 29 | 0 |
155039 | 155039 | 2020-05-18 | Iowa | Iowa | 19095 | 29 | 0 |
158055 | 158055 | 2020-05-19 | Iowa | Iowa | 19095 | 30 | 0 |
161081 | 161081 | 2020-05-20 | Iowa | Iowa | 19095 | 32 | 0 |
164109 | 164109 | 2020-05-21 | Iowa | Iowa | 19095 | 32 | 0 |
167142 | 167142 | 2020-05-22 | Iowa | Iowa | 19095 | 32 | 0 |
170179 | 170179 | 2020-05-23 | Iowa | Iowa | 19095 | 32 | 0 |
173220 | 173220 | 2020-05-24 | Iowa | Iowa | 19095 | 33 | 0 |
176264 | 176264 | 2020-05-25 | Iowa | Iowa | 19095 | 33 | 0 |
179308 | 179308 | 2020-05-26 | Iowa | Iowa | 19095 | 33 | 0 |
182353 | 182353 | 2020-05-27 | Iowa | Iowa | 19095 | 35 | 0 |
185407 | 185407 | 2020-05-28 | Iowa | Iowa | 19095 | 33 | 0 |
188465 | 188465 | 2020-05-29 | Iowa | Iowa | 19095 | 33 | 0 |
191530 | 191530 | 2020-05-30 | Iowa | Iowa | 19095 | 33 | 0 |
194597 | 194597 | 2020-05-31 | Iowa | Iowa | 19095 | 33 | 0 |
197667 | 197667 | 2020-06-01 | Iowa | Iowa | 19095 | 33 | 0 |
200740 | 200740 | 2020-06-02 | Iowa | Iowa | 19095 | 33 | 0 |
203816 | 203816 | 2020-06-03 | Iowa | Iowa | 19095 | 33 | 0 |
206896 | 206896 | 2020-06-04 | Iowa | Iowa | 19095 | 33 | 0 |
209977 | 209977 | 2020-06-05 | Iowa | Iowa | 19095 | 33 | 0 |
213062 | 213062 | 2020-06-06 | Iowa | Iowa | 19095 | 33 | 0 |
216149 | 216149 | 2020-06-07 | Iowa | Iowa | 19095 | 33 | 0 |
219241 | 219241 | 2020-06-08 | Iowa | Iowa | 19095 | 33 | 0 |
222336 | 222336 | 2020-06-09 | Iowa | Iowa | 19095 | 33 | 0 |
225431 | 225431 | 2020-06-10 | Iowa | Iowa | 19095 | 34 | 0 |
228533 | 228533 | 2020-06-11 | Iowa | Iowa | 19095 | 34 | 0 |
231636 | 231636 | 2020-06-12 | Iowa | Iowa | 19095 | 34 | 0 |
234742 | 234742 | 2020-06-13 | Iowa | Iowa | 19095 | 34 | 0 |
237849 | 237849 | 2020-06-14 | Iowa | Iowa | 19095 | 34 | 0 |
240957 | 240957 | 2020-06-15 | Iowa | Iowa | 19095 | 34 | 0 |
244068 | 244068 | 2020-06-16 | Iowa | Iowa | 19095 | 34 | 0 |
247181 | 247181 | 2020-06-17 | Iowa | Iowa | 19095 | 35 | 0 |
250293 | 250293 | 2020-06-18 | Iowa | Iowa | 19095 | 35 | 0 |
253408 | 253408 | 2020-06-19 | Iowa | Iowa | 19095 | 35 | 0 |
256528 | 256528 | 2020-06-20 | Iowa | Iowa | 19095 | 35 | 0 |
259654 | 259654 | 2020-06-21 | Iowa | Iowa | 19095 | 39 | 0 |
262781 | 262781 | 2020-06-22 | Iowa | Iowa | 19095 | 40 | 0 |
265909 | 265909 | 2020-06-23 | Iowa | Iowa | 19095 | 40 | 0 |
269039 | 269039 | 2020-06-24 | Iowa | Iowa | 19095 | 40 | 0 |
272176 | 272176 | 2020-06-25 | Iowa | Iowa | 19095 | 41 | 0 |
275318 | 275318 | 2020-06-26 | Iowa | Iowa | 19095 | 47 | 0 |
278466 | 278466 | 2020-06-27 | Iowa | Iowa | 19095 | 47 | 0 |
281614 | 281614 | 2020-06-28 | Iowa | Iowa | 19095 | 47 | 0 |
284759 | 284759 | 2020-06-29 | Iowa | Iowa | 19095 | 47 | 0 |
287908 | 287908 | 2020-06-30 | Iowa | Iowa | 19095 | 48 | 0 |
291058 | 291058 | 2020-07-01 | Iowa | Iowa | 19095 | 50 | 0 |
294212 | 294212 | 2020-07-02 | Iowa | Iowa | 19095 | 51 | 0 |
297370 | 297370 | 2020-07-03 | Iowa | Iowa | 19095 | 51 | 0 |
300532 | 300532 | 2020-07-04 | Iowa | Iowa | 19095 | 51 | 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);