ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Greene" and fips = 19073 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
38821 | 38821 | 2020-04-07 | Greene | Iowa | 19073 | 1 | 0 |
41367 | 41367 | 2020-04-08 | Greene | Iowa | 19073 | 1 | 0 |
43943 | 43943 | 2020-04-09 | Greene | Iowa | 19073 | 1 | 0 |
46548 | 46548 | 2020-04-10 | Greene | Iowa | 19073 | 1 | 0 |
49182 | 49182 | 2020-04-11 | Greene | Iowa | 19073 | 1 | 0 |
51846 | 51846 | 2020-04-12 | Greene | Iowa | 19073 | 1 | 0 |
54528 | 54528 | 2020-04-13 | Greene | Iowa | 19073 | 1 | 0 |
57221 | 57221 | 2020-04-14 | Greene | Iowa | 19073 | 1 | 0 |
59929 | 59929 | 2020-04-15 | Greene | Iowa | 19073 | 1 | 0 |
62650 | 62650 | 2020-04-16 | Greene | Iowa | 19073 | 1 | 0 |
65384 | 65384 | 2020-04-17 | Greene | Iowa | 19073 | 1 | 0 |
68133 | 68133 | 2020-04-18 | Greene | Iowa | 19073 | 1 | 0 |
70895 | 70895 | 2020-04-19 | Greene | Iowa | 19073 | 1 | 0 |
73666 | 73666 | 2020-04-20 | Greene | Iowa | 19073 | 1 | 0 |
76444 | 76444 | 2020-04-21 | Greene | Iowa | 19073 | 1 | 0 |
79228 | 79228 | 2020-04-22 | Greene | Iowa | 19073 | 1 | 0 |
82021 | 82021 | 2020-04-23 | Greene | Iowa | 19073 | 1 | 0 |
84821 | 84821 | 2020-04-24 | Greene | Iowa | 19073 | 1 | 0 |
87631 | 87631 | 2020-04-25 | Greene | Iowa | 19073 | 1 | 0 |
90447 | 90447 | 2020-04-26 | Greene | Iowa | 19073 | 1 | 0 |
93266 | 93266 | 2020-04-27 | Greene | Iowa | 19073 | 2 | 0 |
96098 | 96098 | 2020-04-28 | Greene | Iowa | 19073 | 2 | 0 |
98943 | 98943 | 2020-04-29 | Greene | Iowa | 19073 | 2 | 0 |
101794 | 101794 | 2020-04-30 | Greene | Iowa | 19073 | 5 | 0 |
104652 | 104652 | 2020-05-01 | Greene | Iowa | 19073 | 7 | 0 |
107517 | 107517 | 2020-05-02 | Greene | Iowa | 19073 | 10 | 0 |
110387 | 110387 | 2020-05-03 | Greene | Iowa | 19073 | 11 | 0 |
113262 | 113262 | 2020-05-04 | Greene | Iowa | 19073 | 11 | 0 |
116145 | 116145 | 2020-05-05 | Greene | Iowa | 19073 | 11 | 0 |
119105 | 119105 | 2020-05-06 | Greene | Iowa | 19073 | 11 | 0 |
122075 | 122075 | 2020-05-07 | Greene | Iowa | 19073 | 13 | 0 |
125056 | 125056 | 2020-05-08 | Greene | Iowa | 19073 | 13 | 0 |
128043 | 128043 | 2020-05-09 | Greene | Iowa | 19073 | 13 | 0 |
131034 | 131034 | 2020-05-10 | Greene | Iowa | 19073 | 13 | 0 |
134024 | 134024 | 2020-05-11 | Greene | Iowa | 19073 | 13 | 0 |
137013 | 137013 | 2020-05-12 | Greene | Iowa | 19073 | 13 | 0 |
140006 | 140006 | 2020-05-13 | Greene | Iowa | 19073 | 13 | 0 |
143002 | 143002 | 2020-05-14 | Greene | Iowa | 19073 | 14 | 0 |
146002 | 146002 | 2020-05-15 | Greene | Iowa | 19073 | 13 | 0 |
149006 | 149006 | 2020-05-16 | Greene | Iowa | 19073 | 13 | 0 |
152016 | 152016 | 2020-05-17 | Greene | Iowa | 19073 | 13 | 0 |
155028 | 155028 | 2020-05-18 | Greene | Iowa | 19073 | 13 | 0 |
158044 | 158044 | 2020-05-19 | Greene | Iowa | 19073 | 13 | 0 |
161070 | 161070 | 2020-05-20 | Greene | Iowa | 19073 | 13 | 0 |
164098 | 164098 | 2020-05-21 | Greene | Iowa | 19073 | 13 | 0 |
167131 | 167131 | 2020-05-22 | Greene | Iowa | 19073 | 13 | 0 |
170168 | 170168 | 2020-05-23 | Greene | Iowa | 19073 | 13 | 0 |
173209 | 173209 | 2020-05-24 | Greene | Iowa | 19073 | 13 | 0 |
176253 | 176253 | 2020-05-25 | Greene | Iowa | 19073 | 13 | 0 |
179297 | 179297 | 2020-05-26 | Greene | Iowa | 19073 | 13 | 0 |
182342 | 182342 | 2020-05-27 | Greene | Iowa | 19073 | 13 | 0 |
185396 | 185396 | 2020-05-28 | Greene | Iowa | 19073 | 13 | 0 |
188454 | 188454 | 2020-05-29 | Greene | Iowa | 19073 | 13 | 0 |
191519 | 191519 | 2020-05-30 | Greene | Iowa | 19073 | 13 | 0 |
194586 | 194586 | 2020-05-31 | Greene | Iowa | 19073 | 13 | 0 |
197656 | 197656 | 2020-06-01 | Greene | Iowa | 19073 | 13 | 0 |
200729 | 200729 | 2020-06-02 | Greene | Iowa | 19073 | 13 | 0 |
203805 | 203805 | 2020-06-03 | Greene | Iowa | 19073 | 13 | 0 |
206885 | 206885 | 2020-06-04 | Greene | Iowa | 19073 | 15 | 0 |
209966 | 209966 | 2020-06-05 | Greene | Iowa | 19073 | 15 | 0 |
213051 | 213051 | 2020-06-06 | Greene | Iowa | 19073 | 14 | 0 |
216138 | 216138 | 2020-06-07 | Greene | Iowa | 19073 | 14 | 0 |
219230 | 219230 | 2020-06-08 | Greene | Iowa | 19073 | 14 | 0 |
222325 | 222325 | 2020-06-09 | Greene | Iowa | 19073 | 14 | 0 |
225420 | 225420 | 2020-06-10 | Greene | Iowa | 19073 | 16 | 0 |
228522 | 228522 | 2020-06-11 | Greene | Iowa | 19073 | 16 | 0 |
231625 | 231625 | 2020-06-12 | Greene | Iowa | 19073 | 20 | 0 |
234731 | 234731 | 2020-06-13 | Greene | Iowa | 19073 | 21 | 0 |
237838 | 237838 | 2020-06-14 | Greene | Iowa | 19073 | 21 | 0 |
240946 | 240946 | 2020-06-15 | Greene | Iowa | 19073 | 21 | 0 |
244057 | 244057 | 2020-06-16 | Greene | Iowa | 19073 | 21 | 0 |
247170 | 247170 | 2020-06-17 | Greene | Iowa | 19073 | 25 | 0 |
250282 | 250282 | 2020-06-18 | Greene | Iowa | 19073 | 26 | 0 |
253397 | 253397 | 2020-06-19 | Greene | Iowa | 19073 | 27 | 0 |
256517 | 256517 | 2020-06-20 | Greene | Iowa | 19073 | 27 | 0 |
259643 | 259643 | 2020-06-21 | Greene | Iowa | 19073 | 28 | 0 |
262770 | 262770 | 2020-06-22 | Greene | Iowa | 19073 | 28 | 0 |
265898 | 265898 | 2020-06-23 | Greene | Iowa | 19073 | 28 | 0 |
269028 | 269028 | 2020-06-24 | Greene | Iowa | 19073 | 28 | 0 |
272165 | 272165 | 2020-06-25 | Greene | Iowa | 19073 | 28 | 0 |
275307 | 275307 | 2020-06-26 | Greene | Iowa | 19073 | 28 | 0 |
278455 | 278455 | 2020-06-27 | Greene | Iowa | 19073 | 28 | 0 |
281603 | 281603 | 2020-06-28 | Greene | Iowa | 19073 | 28 | 0 |
284748 | 284748 | 2020-06-29 | Greene | Iowa | 19073 | 28 | 0 |
287897 | 287897 | 2020-06-30 | Greene | Iowa | 19073 | 28 | 0 |
291047 | 291047 | 2020-07-01 | Greene | Iowa | 19073 | 28 | 0 |
294201 | 294201 | 2020-07-02 | Greene | Iowa | 19073 | 28 | 0 |
297359 | 297359 | 2020-07-03 | Greene | Iowa | 19073 | 29 | 0 |
300521 | 300521 | 2020-07-04 | Greene | Iowa | 19073 | 29 | 0 |
303685 | 303685 | 2020-07-05 | Greene | Iowa | 19073 | 29 | 0 |
306850 | 306850 | 2020-07-06 | Greene | Iowa | 19073 | 30 | 0 |
310018 | 310018 | 2020-07-07 | Greene | Iowa | 19073 | 29 | 0 |
313188 | 313188 | 2020-07-08 | Greene | Iowa | 19073 | 29 | 0 |
316362 | 316362 | 2020-07-09 | Greene | Iowa | 19073 | 29 | 0 |
319535 | 319535 | 2020-07-10 | Greene | Iowa | 19073 | 30 | 0 |
322714 | 322714 | 2020-07-11 | Greene | Iowa | 19073 | 30 | 0 |
325895 | 325895 | 2020-07-12 | Greene | Iowa | 19073 | 31 | 0 |
329081 | 329081 | 2020-07-13 | Greene | Iowa | 19073 | 31 | 0 |
332268 | 332268 | 2020-07-14 | Greene | Iowa | 19073 | 31 | 0 |
335461 | 335461 | 2020-07-15 | Greene | Iowa | 19073 | 31 | 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);