ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,552 rows where county = "Green" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
38961 | 38961 | 2020-04-07 | Green | Kentucky | 21087 | 1 | 0 |
41510 | 41510 | 2020-04-08 | Green | Kentucky | 21087 | 2 | 0 |
44085 | 44085 | 2020-04-09 | Green | Kentucky | 21087 | 2 | 0 |
46693 | 46693 | 2020-04-10 | Green | Kentucky | 21087 | 2 | 0 |
49332 | 49332 | 2020-04-11 | Green | Kentucky | 21087 | 2 | 0 |
51998 | 51998 | 2020-04-12 | Green | Kentucky | 21087 | 1 | 0 |
54679 | 54679 | 2020-04-13 | Green | Kentucky | 21087 | 1 | 0 |
57376 | 57376 | 2020-04-14 | Green | Kentucky | 21087 | 1 | 0 |
60085 | 60085 | 2020-04-15 | Green | Kentucky | 21087 | 1 | 0 |
62805 | 62805 | 2020-04-16 | Green | Kentucky | 21087 | 1 | 0 |
65544 | 65544 | 2020-04-17 | Green | Kentucky | 21087 | 1 | 0 |
68293 | 68293 | 2020-04-18 | Green | Kentucky | 21087 | 1 | 0 |
71056 | 71056 | 2020-04-19 | Green | Kentucky | 21087 | 1 | 0 |
73828 | 73828 | 2020-04-20 | Green | Kentucky | 21087 | 1 | 0 |
76608 | 76608 | 2020-04-21 | Green | Kentucky | 21087 | 1 | 0 |
79393 | 79393 | 2020-04-22 | Green | Kentucky | 21087 | 1 | 0 |
82190 | 82190 | 2020-04-23 | Green | Kentucky | 21087 | 1 | 0 |
84993 | 84993 | 2020-04-24 | Green | Kentucky | 21087 | 1 | 0 |
87802 | 87802 | 2020-04-25 | Green | Kentucky | 21087 | 1 | 0 |
90618 | 90618 | 2020-04-26 | Green | Kentucky | 21087 | 1 | 0 |
93439 | 93439 | 2020-04-27 | Green | Kentucky | 21087 | 1 | 0 |
96272 | 96272 | 2020-04-28 | Green | Kentucky | 21087 | 1 | 0 |
99118 | 99118 | 2020-04-29 | Green | Kentucky | 21087 | 1 | 0 |
101970 | 101970 | 2020-04-30 | Green | Kentucky | 21087 | 1 | 0 |
104831 | 104831 | 2020-05-01 | Green | Kentucky | 21087 | 1 | 0 |
107696 | 107696 | 2020-05-02 | Green | Kentucky | 21087 | 1 | 0 |
110567 | 110567 | 2020-05-03 | Green | Kentucky | 21087 | 1 | 0 |
113444 | 113444 | 2020-05-04 | Green | Kentucky | 21087 | 1 | 0 |
116326 | 116326 | 2020-05-05 | Green | Kentucky | 21087 | 1 | 0 |
119287 | 119287 | 2020-05-06 | Green | Kentucky | 21087 | 1 | 0 |
122257 | 122257 | 2020-05-07 | Green | Kentucky | 21087 | 1 | 0 |
125239 | 125239 | 2020-05-08 | Green | Kentucky | 21087 | 1 | 0 |
128227 | 128227 | 2020-05-09 | Green | Kentucky | 21087 | 1 | 0 |
131217 | 131217 | 2020-05-10 | Green | Kentucky | 21087 | 1 | 0 |
134208 | 134208 | 2020-05-11 | Green | Kentucky | 21087 | 1 | 0 |
137198 | 137198 | 2020-05-12 | Green | Kentucky | 21087 | 1 | 0 |
140191 | 140191 | 2020-05-13 | Green | Kentucky | 21087 | 1 | 0 |
143187 | 143187 | 2020-05-14 | Green | Kentucky | 21087 | 1 | 0 |
146187 | 146187 | 2020-05-15 | Green | Kentucky | 21087 | 1 | 0 |
149191 | 149191 | 2020-05-16 | Green | Kentucky | 21087 | 1 | 0 |
152202 | 152202 | 2020-05-17 | Green | Kentucky | 21087 | 1 | 0 |
155216 | 155216 | 2020-05-18 | Green | Kentucky | 21087 | 1 | 0 |
158233 | 158233 | 2020-05-19 | Green | Kentucky | 21087 | 1 | 0 |
161259 | 161259 | 2020-05-20 | Green | Kentucky | 21087 | 1 | 0 |
164288 | 164288 | 2020-05-21 | Green | Kentucky | 21087 | 1 | 0 |
167324 | 167324 | 2020-05-22 | Green | Kentucky | 21087 | 1 | 0 |
170362 | 170362 | 2020-05-23 | Green | Kentucky | 21087 | 1 | 0 |
173403 | 173403 | 2020-05-24 | Green | Kentucky | 21087 | 1 | 0 |
176447 | 176447 | 2020-05-25 | Green | Kentucky | 21087 | 1 | 0 |
179491 | 179491 | 2020-05-26 | Green | Kentucky | 21087 | 1 | 0 |
182536 | 182536 | 2020-05-27 | Green | Kentucky | 21087 | 1 | 0 |
185590 | 185590 | 2020-05-28 | Green | Kentucky | 21087 | 1 | 0 |
188648 | 188648 | 2020-05-29 | Green | Kentucky | 21087 | 1 | 0 |
191712 | 191712 | 2020-05-30 | Green | Kentucky | 21087 | 1 | 0 |
194780 | 194780 | 2020-05-31 | Green | Kentucky | 21087 | 1 | 0 |
197851 | 197851 | 2020-06-01 | Green | Kentucky | 21087 | 1 | 0 |
200923 | 200923 | 2020-06-02 | Green | Kentucky | 21087 | 1 | 0 |
204000 | 204000 | 2020-06-03 | Green | Kentucky | 21087 | 1 | 0 |
207081 | 207081 | 2020-06-04 | Green | Kentucky | 21087 | 2 | 0 |
210162 | 210162 | 2020-06-05 | Green | Kentucky | 21087 | 2 | 0 |
213247 | 213247 | 2020-06-06 | Green | Kentucky | 21087 | 2 | 0 |
216334 | 216334 | 2020-06-07 | Green | Kentucky | 21087 | 2 | 0 |
219426 | 219426 | 2020-06-08 | Green | Kentucky | 21087 | 2 | 0 |
222521 | 222521 | 2020-06-09 | Green | Kentucky | 21087 | 2 | 0 |
225617 | 225617 | 2020-06-10 | Green | Kentucky | 21087 | 2 | 0 |
228719 | 228719 | 2020-06-11 | Green | Kentucky | 21087 | 2 | 0 |
231823 | 231823 | 2020-06-12 | Green | Kentucky | 21087 | 2 | 0 |
234928 | 234928 | 2020-06-13 | Green | Kentucky | 21087 | 3 | 0 |
238035 | 238035 | 2020-06-14 | Green | Kentucky | 21087 | 3 | 0 |
241144 | 241144 | 2020-06-15 | Green | Kentucky | 21087 | 3 | 0 |
244255 | 244255 | 2020-06-16 | Green | Kentucky | 21087 | 3 | 0 |
247368 | 247368 | 2020-06-17 | Green | Kentucky | 21087 | 3 | 1 |
250480 | 250480 | 2020-06-18 | Green | Kentucky | 21087 | 3 | 1 |
253595 | 253595 | 2020-06-19 | Green | Kentucky | 21087 | 4 | 1 |
256715 | 256715 | 2020-06-20 | Green | Kentucky | 21087 | 6 | 1 |
259841 | 259841 | 2020-06-21 | Green | Kentucky | 21087 | 6 | 1 |
262970 | 262970 | 2020-06-22 | Green | Kentucky | 21087 | 6 | 1 |
266097 | 266097 | 2020-06-23 | Green | Kentucky | 21087 | 4 | 1 |
269230 | 269230 | 2020-06-24 | Green | Kentucky | 21087 | 4 | 1 |
272366 | 272366 | 2020-06-25 | Green | Kentucky | 21087 | 4 | 1 |
275509 | 275509 | 2020-06-26 | Green | Kentucky | 21087 | 4 | 1 |
278657 | 278657 | 2020-06-27 | Green | Kentucky | 21087 | 4 | 1 |
281805 | 281805 | 2020-06-28 | Green | Kentucky | 21087 | 4 | 1 |
284951 | 284951 | 2020-06-29 | Green | Kentucky | 21087 | 4 | 1 |
288100 | 288100 | 2020-06-30 | Green | Kentucky | 21087 | 4 | 1 |
291250 | 291250 | 2020-07-01 | Green | Kentucky | 21087 | 5 | 1 |
294404 | 294404 | 2020-07-02 | Green | Kentucky | 21087 | 5 | 1 |
297562 | 297562 | 2020-07-03 | Green | Kentucky | 21087 | 5 | 1 |
300724 | 300724 | 2020-07-04 | Green | Kentucky | 21087 | 5 | 1 |
303888 | 303888 | 2020-07-05 | Green | Kentucky | 21087 | 5 | 1 |
307055 | 307055 | 2020-07-06 | Green | Kentucky | 21087 | 8 | 1 |
310223 | 310223 | 2020-07-07 | Green | Kentucky | 21087 | 9 | 1 |
313393 | 313393 | 2020-07-08 | Green | Kentucky | 21087 | 10 | 1 |
316567 | 316567 | 2020-07-09 | Green | Kentucky | 21087 | 11 | 1 |
319742 | 319742 | 2020-07-10 | Green | Kentucky | 21087 | 11 | 1 |
322921 | 322921 | 2020-07-11 | Green | Kentucky | 21087 | 13 | 1 |
326104 | 326104 | 2020-07-12 | Green | Kentucky | 21087 | 14 | 1 |
329290 | 329290 | 2020-07-13 | Green | Kentucky | 21087 | 14 | 1 |
332477 | 332477 | 2020-07-14 | Green | Kentucky | 21087 | 20 | 1 |
335670 | 335670 | 2020-07-15 | Green | Kentucky | 21087 | 21 | 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);