ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Cerro Gordo" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 98 ✖
- 0 60
- 1 55
- 97 35
- 98 28
- 169 28
- 89 27
- 85 25
- 21 22
- 20 21
- 23 21
- 100 21
- 17 15
- 86 15
- 107 14
- 133 14
- 146 14
- 157 14
- 167 14
- 79 11
- 90 11
- 93 10
- 27 9
- 72 9
- 87 9
- 16 7
- 59 7
- 83 7
- 102 7
- 105 7
- 106 7
- 110 7
- 113 7
- 117 7
- 118 7
- 121 7
- 123 7
- 125 7
- 128 7
- 137 7
- 142 7
- 150 7
- 153 7
- 156 7
- 159 7
- 161 7
- 166 7
- 168 7
- 52 6
- 76 6
- 31 5
- 44 5
- 49 5
- 19 4
- 25 4
- 62 4
- 63 4
- 64 4
- 68 4
- 80 4
- 81 4
- 12 3
- 41 3
- 55 3
- 74 3
- 170 3
- 29 2
- 30 2
- 32 2
- 38 2
- 48 2
- 56 2
- 61 2
- 65 2
- 66 2
- 77 2
- 82 2
- 88 2
- 95 2
- 9 1
- 11 1
- 13 1
- 14 1
- 18 1
- 22 1
- 26 1
- 33 1
- 35 1
- 37 1
- 42 1
- 43 1
- 46 1
- 47 1
- 51 1
- 71 1
- 73 1
- 84 1
- 91 1
- 96 1
state 1
- Iowa 783
fips 1
- 19033 783
county 1
- Cerro Gordo · 783 ✖
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);