ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Clay", fips = 19041 and state = "Iowa" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
22353 | 22353 | 2020-03-31 | Clay | Iowa | 19041 | 1 | 0 |
24525 | 24525 | 2020-04-01 | Clay | Iowa | 19041 | 1 | 0 |
26766 | 26766 | 2020-04-02 | Clay | Iowa | 19041 | 2 | 0 |
29077 | 29077 | 2020-04-03 | Clay | Iowa | 19041 | 2 | 0 |
31445 | 31445 | 2020-04-04 | Clay | Iowa | 19041 | 2 | 0 |
33857 | 33857 | 2020-04-05 | Clay | Iowa | 19041 | 2 | 0 |
36311 | 36311 | 2020-04-06 | Clay | Iowa | 19041 | 2 | 0 |
38810 | 38810 | 2020-04-07 | Clay | Iowa | 19041 | 2 | 0 |
41356 | 41356 | 2020-04-08 | Clay | Iowa | 19041 | 2 | 0 |
43932 | 43932 | 2020-04-09 | Clay | Iowa | 19041 | 2 | 0 |
46537 | 46537 | 2020-04-10 | Clay | Iowa | 19041 | 2 | 0 |
49171 | 49171 | 2020-04-11 | Clay | Iowa | 19041 | 2 | 0 |
51835 | 51835 | 2020-04-12 | Clay | Iowa | 19041 | 2 | 0 |
54517 | 54517 | 2020-04-13 | Clay | Iowa | 19041 | 2 | 0 |
57210 | 57210 | 2020-04-14 | Clay | Iowa | 19041 | 2 | 0 |
59918 | 59918 | 2020-04-15 | Clay | Iowa | 19041 | 2 | 0 |
62639 | 62639 | 2020-04-16 | Clay | Iowa | 19041 | 2 | 0 |
65373 | 65373 | 2020-04-17 | Clay | Iowa | 19041 | 2 | 0 |
68122 | 68122 | 2020-04-18 | Clay | Iowa | 19041 | 3 | 0 |
70884 | 70884 | 2020-04-19 | Clay | Iowa | 19041 | 3 | 0 |
73655 | 73655 | 2020-04-20 | Clay | Iowa | 19041 | 3 | 0 |
76433 | 76433 | 2020-04-21 | Clay | Iowa | 19041 | 3 | 0 |
79217 | 79217 | 2020-04-22 | Clay | Iowa | 19041 | 3 | 0 |
82010 | 82010 | 2020-04-23 | Clay | Iowa | 19041 | 3 | 0 |
84810 | 84810 | 2020-04-24 | Clay | Iowa | 19041 | 3 | 0 |
87620 | 87620 | 2020-04-25 | Clay | Iowa | 19041 | 3 | 0 |
90436 | 90436 | 2020-04-26 | Clay | Iowa | 19041 | 3 | 0 |
93255 | 93255 | 2020-04-27 | Clay | Iowa | 19041 | 3 | 0 |
96087 | 96087 | 2020-04-28 | Clay | Iowa | 19041 | 3 | 0 |
98931 | 98931 | 2020-04-29 | Clay | Iowa | 19041 | 3 | 0 |
101782 | 101782 | 2020-04-30 | Clay | Iowa | 19041 | 4 | 0 |
104639 | 104639 | 2020-05-01 | Clay | Iowa | 19041 | 4 | 0 |
107504 | 107504 | 2020-05-02 | Clay | Iowa | 19041 | 4 | 0 |
110374 | 110374 | 2020-05-03 | Clay | Iowa | 19041 | 5 | 0 |
113249 | 113249 | 2020-05-04 | Clay | Iowa | 19041 | 6 | 0 |
116132 | 116132 | 2020-05-05 | Clay | Iowa | 19041 | 7 | 0 |
119092 | 119092 | 2020-05-06 | Clay | Iowa | 19041 | 7 | 0 |
122062 | 122062 | 2020-05-07 | Clay | Iowa | 19041 | 8 | 0 |
125042 | 125042 | 2020-05-08 | Clay | Iowa | 19041 | 9 | 0 |
128029 | 128029 | 2020-05-09 | Clay | Iowa | 19041 | 9 | 0 |
131020 | 131020 | 2020-05-10 | Clay | Iowa | 19041 | 9 | 0 |
134010 | 134010 | 2020-05-11 | Clay | Iowa | 19041 | 9 | 0 |
136999 | 136999 | 2020-05-12 | Clay | Iowa | 19041 | 9 | 0 |
139991 | 139991 | 2020-05-13 | Clay | Iowa | 19041 | 9 | 0 |
142987 | 142987 | 2020-05-14 | Clay | Iowa | 19041 | 9 | 0 |
152001 | 152001 | 2020-05-17 | Clay | Iowa | 19041 | 9 | 0 |
155013 | 155013 | 2020-05-18 | Clay | Iowa | 19041 | 9 | 0 |
158029 | 158029 | 2020-05-19 | Clay | Iowa | 19041 | 9 | 0 |
161055 | 161055 | 2020-05-20 | Clay | Iowa | 19041 | 9 | 0 |
164083 | 164083 | 2020-05-21 | Clay | Iowa | 19041 | 9 | 0 |
167116 | 167116 | 2020-05-22 | Clay | Iowa | 19041 | 9 | 0 |
170153 | 170153 | 2020-05-23 | Clay | Iowa | 19041 | 9 | 0 |
145987 | 145987 | 2020-05-15 | Clay | Iowa | 19041 | 10 | 0 |
148991 | 148991 | 2020-05-16 | Clay | Iowa | 19041 | 10 | 0 |
173194 | 173194 | 2020-05-24 | Clay | Iowa | 19041 | 10 | 0 |
176238 | 176238 | 2020-05-25 | Clay | Iowa | 19041 | 10 | 0 |
179282 | 179282 | 2020-05-26 | Clay | Iowa | 19041 | 12 | 0 |
182326 | 182326 | 2020-05-27 | Clay | Iowa | 19041 | 13 | 0 |
185380 | 185380 | 2020-05-28 | Clay | Iowa | 19041 | 13 | 0 |
188438 | 188438 | 2020-05-29 | Clay | Iowa | 19041 | 13 | 0 |
191503 | 191503 | 2020-05-30 | Clay | Iowa | 19041 | 15 | 0 |
194570 | 194570 | 2020-05-31 | Clay | Iowa | 19041 | 16 | 0 |
197640 | 197640 | 2020-06-01 | Clay | Iowa | 19041 | 18 | 0 |
200713 | 200713 | 2020-06-02 | Clay | Iowa | 19041 | 18 | 0 |
203789 | 203789 | 2020-06-03 | Clay | Iowa | 19041 | 21 | 0 |
206869 | 206869 | 2020-06-04 | Clay | Iowa | 19041 | 27 | 0 |
209950 | 209950 | 2020-06-05 | Clay | Iowa | 19041 | 29 | 0 |
213035 | 213035 | 2020-06-06 | Clay | Iowa | 19041 | 30 | 0 |
216122 | 216122 | 2020-06-07 | Clay | Iowa | 19041 | 34 | 0 |
219214 | 219214 | 2020-06-08 | Clay | Iowa | 19041 | 35 | 0 |
222309 | 222309 | 2020-06-09 | Clay | Iowa | 19041 | 36 | 0 |
225404 | 225404 | 2020-06-10 | Clay | Iowa | 19041 | 39 | 0 |
228506 | 228506 | 2020-06-11 | Clay | Iowa | 19041 | 55 | 0 |
231609 | 231609 | 2020-06-12 | Clay | Iowa | 19041 | 62 | 0 |
234715 | 234715 | 2020-06-13 | Clay | Iowa | 19041 | 66 | 0 |
237822 | 237822 | 2020-06-14 | Clay | Iowa | 19041 | 73 | 0 |
240930 | 240930 | 2020-06-15 | Clay | Iowa | 19041 | 77 | 0 |
244041 | 244041 | 2020-06-16 | Clay | Iowa | 19041 | 83 | 0 |
247154 | 247154 | 2020-06-17 | Clay | Iowa | 19041 | 86 | 0 |
250266 | 250266 | 2020-06-18 | Clay | Iowa | 19041 | 93 | 0 |
253381 | 253381 | 2020-06-19 | Clay | Iowa | 19041 | 102 | 0 |
256501 | 256501 | 2020-06-20 | Clay | Iowa | 19041 | 104 | 0 |
259627 | 259627 | 2020-06-21 | Clay | Iowa | 19041 | 106 | 0 |
262754 | 262754 | 2020-06-22 | Clay | Iowa | 19041 | 106 | 0 |
265882 | 265882 | 2020-06-23 | Clay | Iowa | 19041 | 109 | 0 |
269012 | 269012 | 2020-06-24 | Clay | Iowa | 19041 | 111 | 0 |
272149 | 272149 | 2020-06-25 | Clay | Iowa | 19041 | 113 | 0 |
275291 | 275291 | 2020-06-26 | Clay | Iowa | 19041 | 115 | 0 |
278439 | 278439 | 2020-06-27 | Clay | Iowa | 19041 | 117 | 0 |
281587 | 281587 | 2020-06-28 | Clay | Iowa | 19041 | 119 | 0 |
284732 | 284732 | 2020-06-29 | Clay | Iowa | 19041 | 120 | 0 |
287881 | 287881 | 2020-06-30 | Clay | Iowa | 19041 | 123 | 0 |
291031 | 291031 | 2020-07-01 | Clay | Iowa | 19041 | 126 | 0 |
294185 | 294185 | 2020-07-02 | Clay | Iowa | 19041 | 127 | 0 |
297343 | 297343 | 2020-07-03 | Clay | Iowa | 19041 | 129 | 0 |
300505 | 300505 | 2020-07-04 | Clay | Iowa | 19041 | 133 | 0 |
303669 | 303669 | 2020-07-05 | Clay | Iowa | 19041 | 134 | 0 |
306834 | 306834 | 2020-07-06 | Clay | Iowa | 19041 | 134 | 0 |
310002 | 310002 | 2020-07-07 | Clay | Iowa | 19041 | 137 | 0 |
313172 | 313172 | 2020-07-08 | Clay | Iowa | 19041 | 142 | 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);