ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Cerro Gordo" and fips = 19033 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7458 | 7458 | 2020-03-22 | Cerro Gordo | Iowa | 19033 | 2 | 0 |
8616 | 8616 | 2020-03-23 | Cerro Gordo | Iowa | 19033 | 2 | 0 |
9894 | 9894 | 2020-03-24 | Cerro Gordo | Iowa | 19033 | 2 | 0 |
11291 | 11291 | 2020-03-25 | Cerro Gordo | Iowa | 19033 | 2 | 0 |
12853 | 12853 | 2020-03-26 | Cerro Gordo | Iowa | 19033 | 2 | 0 |
14541 | 14541 | 2020-03-27 | Cerro Gordo | Iowa | 19033 | 3 | 0 |
16345 | 16345 | 2020-03-28 | Cerro Gordo | Iowa | 19033 | 4 | 0 |
18250 | 18250 | 2020-03-29 | Cerro Gordo | Iowa | 19033 | 6 | 0 |
20257 | 20257 | 2020-03-30 | Cerro Gordo | Iowa | 19033 | 7 | 0 |
22352 | 22352 | 2020-03-31 | Cerro Gordo | Iowa | 19033 | 7 | 0 |
24524 | 24524 | 2020-04-01 | Cerro Gordo | Iowa | 19033 | 8 | 0 |
26765 | 26765 | 2020-04-02 | Cerro Gordo | Iowa | 19033 | 10 | 0 |
29076 | 29076 | 2020-04-03 | Cerro Gordo | Iowa | 19033 | 10 | 0 |
31444 | 31444 | 2020-04-04 | Cerro Gordo | Iowa | 19033 | 10 | 0 |
33855 | 33855 | 2020-04-05 | Cerro Gordo | Iowa | 19033 | 10 | 0 |
36308 | 36308 | 2020-04-06 | Cerro Gordo | Iowa | 19033 | 12 | 0 |
38807 | 38807 | 2020-04-07 | Cerro Gordo | Iowa | 19033 | 12 | 0 |
41353 | 41353 | 2020-04-08 | Cerro Gordo | Iowa | 19033 | 12 | 0 |
43929 | 43929 | 2020-04-09 | Cerro Gordo | Iowa | 19033 | 13 | 0 |
46534 | 46534 | 2020-04-10 | Cerro Gordo | Iowa | 19033 | 13 | 0 |
49168 | 49168 | 2020-04-11 | Cerro Gordo | Iowa | 19033 | 13 | 0 |
51832 | 51832 | 2020-04-12 | Cerro Gordo | Iowa | 19033 | 13 | 0 |
54514 | 54514 | 2020-04-13 | Cerro Gordo | Iowa | 19033 | 13 | 0 |
57207 | 57207 | 2020-04-14 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
59915 | 59915 | 2020-04-15 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
62636 | 62636 | 2020-04-16 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
65370 | 65370 | 2020-04-17 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
68119 | 68119 | 2020-04-18 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
70881 | 70881 | 2020-04-19 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
73652 | 73652 | 2020-04-20 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
76429 | 76429 | 2020-04-21 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
79213 | 79213 | 2020-04-22 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
82006 | 82006 | 2020-04-23 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
84806 | 84806 | 2020-04-24 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
87616 | 87616 | 2020-04-25 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
90432 | 90432 | 2020-04-26 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
93251 | 93251 | 2020-04-27 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
96083 | 96083 | 2020-04-28 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
98927 | 98927 | 2020-04-29 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
101778 | 101778 | 2020-04-30 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
104635 | 104635 | 2020-05-01 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
107500 | 107500 | 2020-05-02 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
110370 | 110370 | 2020-05-03 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
113245 | 113245 | 2020-05-04 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
116128 | 116128 | 2020-05-05 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
119088 | 119088 | 2020-05-06 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
122058 | 122058 | 2020-05-07 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
125038 | 125038 | 2020-05-08 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
128025 | 128025 | 2020-05-09 | Cerro Gordo | Iowa | 19033 | 15 | 0 |
131016 | 131016 | 2020-05-10 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
134006 | 134006 | 2020-05-11 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
136995 | 136995 | 2020-05-12 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
139987 | 139987 | 2020-05-13 | Cerro Gordo | Iowa | 19033 | 14 | 0 |
142983 | 142983 | 2020-05-14 | Cerro Gordo | Iowa | 19033 | 15 | 0 |
145983 | 145983 | 2020-05-15 | Cerro Gordo | Iowa | 19033 | 15 | 0 |
148987 | 148987 | 2020-05-16 | Cerro Gordo | Iowa | 19033 | 17 | 0 |
151997 | 151997 | 2020-05-17 | Cerro Gordo | Iowa | 19033 | 18 | 0 |
155009 | 155009 | 2020-05-18 | Cerro Gordo | Iowa | 19033 | 18 | 0 |
158025 | 158025 | 2020-05-19 | Cerro Gordo | Iowa | 19033 | 17 | 0 |
161051 | 161051 | 2020-05-20 | Cerro Gordo | Iowa | 19033 | 20 | 0 |
164079 | 164079 | 2020-05-21 | Cerro Gordo | Iowa | 19033 | 19 | 1 |
167112 | 167112 | 2020-05-22 | Cerro Gordo | Iowa | 19033 | 20 | 1 |
170149 | 170149 | 2020-05-23 | Cerro Gordo | Iowa | 19033 | 20 | 1 |
173190 | 173190 | 2020-05-24 | Cerro Gordo | Iowa | 19033 | 22 | 1 |
176234 | 176234 | 2020-05-25 | Cerro Gordo | Iowa | 19033 | 22 | 1 |
179278 | 179278 | 2020-05-26 | Cerro Gordo | Iowa | 19033 | 22 | 1 |
182322 | 182322 | 2020-05-27 | Cerro Gordo | Iowa | 19033 | 24 | 1 |
185376 | 185376 | 2020-05-28 | Cerro Gordo | Iowa | 19033 | 25 | 1 |
188434 | 188434 | 2020-05-29 | Cerro Gordo | Iowa | 19033 | 27 | 1 |
191499 | 191499 | 2020-05-30 | Cerro Gordo | Iowa | 19033 | 29 | 1 |
194566 | 194566 | 2020-05-31 | Cerro Gordo | Iowa | 19033 | 29 | 1 |
197636 | 197636 | 2020-06-01 | Cerro Gordo | Iowa | 19033 | 29 | 1 |
200709 | 200709 | 2020-06-02 | Cerro Gordo | Iowa | 19033 | 29 | 1 |
203785 | 203785 | 2020-06-03 | Cerro Gordo | Iowa | 19033 | 30 | 1 |
206865 | 206865 | 2020-06-04 | Cerro Gordo | Iowa | 19033 | 33 | 1 |
209946 | 209946 | 2020-06-05 | Cerro Gordo | Iowa | 19033 | 34 | 1 |
213031 | 213031 | 2020-06-06 | Cerro Gordo | Iowa | 19033 | 34 | 1 |
216118 | 216118 | 2020-06-07 | Cerro Gordo | Iowa | 19033 | 34 | 1 |
219210 | 219210 | 2020-06-08 | Cerro Gordo | Iowa | 19033 | 32 | 1 |
222305 | 222305 | 2020-06-09 | Cerro Gordo | Iowa | 19033 | 32 | 1 |
225400 | 225400 | 2020-06-10 | Cerro Gordo | Iowa | 19033 | 37 | 1 |
228502 | 228502 | 2020-06-11 | Cerro Gordo | Iowa | 19033 | 39 | 1 |
231605 | 231605 | 2020-06-12 | Cerro Gordo | Iowa | 19033 | 41 | 1 |
234711 | 234711 | 2020-06-13 | Cerro Gordo | Iowa | 19033 | 42 | 1 |
237818 | 237818 | 2020-06-14 | Cerro Gordo | Iowa | 19033 | 42 | 1 |
240926 | 240926 | 2020-06-15 | Cerro Gordo | Iowa | 19033 | 44 | 1 |
244037 | 244037 | 2020-06-16 | Cerro Gordo | Iowa | 19033 | 49 | 1 |
247150 | 247150 | 2020-06-17 | Cerro Gordo | Iowa | 19033 | 49 | 1 |
250262 | 250262 | 2020-06-18 | Cerro Gordo | Iowa | 19033 | 54 | 1 |
253377 | 253377 | 2020-06-19 | Cerro Gordo | Iowa | 19033 | 57 | 1 |
256497 | 256497 | 2020-06-20 | Cerro Gordo | Iowa | 19033 | 58 | 1 |
259623 | 259623 | 2020-06-21 | Cerro Gordo | Iowa | 19033 | 59 | 1 |
262750 | 262750 | 2020-06-22 | Cerro Gordo | Iowa | 19033 | 61 | 1 |
265878 | 265878 | 2020-06-23 | Cerro Gordo | Iowa | 19033 | 62 | 1 |
269008 | 269008 | 2020-06-24 | Cerro Gordo | Iowa | 19033 | 68 | 1 |
272145 | 272145 | 2020-06-25 | Cerro Gordo | Iowa | 19033 | 70 | 1 |
275287 | 275287 | 2020-06-26 | Cerro Gordo | Iowa | 19033 | 81 | 1 |
278435 | 278435 | 2020-06-27 | Cerro Gordo | Iowa | 19033 | 86 | 1 |
281583 | 281583 | 2020-06-28 | Cerro Gordo | Iowa | 19033 | 93 | 1 |
284728 | 284728 | 2020-06-29 | Cerro Gordo | Iowa | 19033 | 99 | 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);