ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,554 rows where county = "Chautauqua" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
22402 | 22402 | 2020-03-31 | Chautauqua | Kansas | 20019 | 1 | 0 |
24577 | 24577 | 2020-04-01 | Chautauqua | Kansas | 20019 | 1 | 0 |
26819 | 26819 | 2020-04-02 | Chautauqua | Kansas | 20019 | 1 | 0 |
29133 | 29133 | 2020-04-03 | Chautauqua | Kansas | 20019 | 2 | 0 |
31505 | 31505 | 2020-04-04 | Chautauqua | Kansas | 20019 | 3 | 0 |
33918 | 33918 | 2020-04-05 | Chautauqua | Kansas | 20019 | 3 | 0 |
36375 | 36375 | 2020-04-06 | Chautauqua | Kansas | 20019 | 3 | 0 |
38877 | 38877 | 2020-04-07 | Chautauqua | Kansas | 20019 | 3 | 0 |
41424 | 41424 | 2020-04-08 | Chautauqua | Kansas | 20019 | 3 | 0 |
44000 | 44000 | 2020-04-09 | Chautauqua | Kansas | 20019 | 3 | 0 |
46607 | 46607 | 2020-04-10 | Chautauqua | Kansas | 20019 | 3 | 0 |
49241 | 49241 | 2020-04-11 | Chautauqua | Kansas | 20019 | 3 | 0 |
51905 | 51905 | 2020-04-12 | Chautauqua | Kansas | 20019 | 3 | 0 |
54587 | 54587 | 2020-04-13 | Chautauqua | Kansas | 20019 | 3 | 0 |
57280 | 57280 | 2020-04-14 | Chautauqua | Kansas | 20019 | 3 | 0 |
59988 | 59988 | 2020-04-15 | Chautauqua | Kansas | 20019 | 3 | 0 |
62709 | 62709 | 2020-04-16 | Chautauqua | Kansas | 20019 | 3 | 0 |
65445 | 65445 | 2020-04-17 | Chautauqua | Kansas | 20019 | 3 | 0 |
68194 | 68194 | 2020-04-18 | Chautauqua | Kansas | 20019 | 3 | 0 |
70955 | 70955 | 2020-04-19 | Chautauqua | Kansas | 20019 | 3 | 0 |
73726 | 73726 | 2020-04-20 | Chautauqua | Kansas | 20019 | 3 | 0 |
76506 | 76506 | 2020-04-21 | Chautauqua | Kansas | 20019 | 3 | 0 |
79290 | 79290 | 2020-04-22 | Chautauqua | Kansas | 20019 | 3 | 0 |
82082 | 82082 | 2020-04-23 | Chautauqua | Kansas | 20019 | 3 | 0 |
84883 | 84883 | 2020-04-24 | Chautauqua | Kansas | 20019 | 3 | 0 |
87692 | 87692 | 2020-04-25 | Chautauqua | Kansas | 20019 | 3 | 0 |
90508 | 90508 | 2020-04-26 | Chautauqua | Kansas | 20019 | 3 | 0 |
93329 | 93329 | 2020-04-27 | Chautauqua | Kansas | 20019 | 3 | 0 |
96161 | 96161 | 2020-04-28 | Chautauqua | Kansas | 20019 | 4 | 0 |
99006 | 99006 | 2020-04-29 | Chautauqua | Kansas | 20019 | 4 | 0 |
101857 | 101857 | 2020-04-30 | Chautauqua | Kansas | 20019 | 4 | 0 |
104717 | 104717 | 2020-05-01 | Chautauqua | Kansas | 20019 | 4 | 0 |
107582 | 107582 | 2020-05-02 | Chautauqua | Kansas | 20019 | 4 | 0 |
110453 | 110453 | 2020-05-03 | Chautauqua | Kansas | 20019 | 4 | 0 |
113329 | 113329 | 2020-05-04 | Chautauqua | Kansas | 20019 | 4 | 0 |
116211 | 116211 | 2020-05-05 | Chautauqua | Kansas | 20019 | 4 | 0 |
119172 | 119172 | 2020-05-06 | Chautauqua | Kansas | 20019 | 4 | 0 |
122142 | 122142 | 2020-05-07 | Chautauqua | Kansas | 20019 | 4 | 0 |
125124 | 125124 | 2020-05-08 | Chautauqua | Kansas | 20019 | 4 | 0 |
128112 | 128112 | 2020-05-09 | Chautauqua | Kansas | 20019 | 4 | 0 |
131102 | 131102 | 2020-05-10 | Chautauqua | Kansas | 20019 | 4 | 0 |
134093 | 134093 | 2020-05-11 | Chautauqua | Kansas | 20019 | 4 | 0 |
137083 | 137083 | 2020-05-12 | Chautauqua | Kansas | 20019 | 4 | 0 |
140076 | 140076 | 2020-05-13 | Chautauqua | Kansas | 20019 | 4 | 0 |
143072 | 143072 | 2020-05-14 | Chautauqua | Kansas | 20019 | 4 | 0 |
146072 | 146072 | 2020-05-15 | Chautauqua | Kansas | 20019 | 4 | 0 |
149076 | 149076 | 2020-05-16 | Chautauqua | Kansas | 20019 | 4 | 0 |
152087 | 152087 | 2020-05-17 | Chautauqua | Kansas | 20019 | 4 | 0 |
155099 | 155099 | 2020-05-18 | Chautauqua | Kansas | 20019 | 4 | 0 |
158116 | 158116 | 2020-05-19 | Chautauqua | Kansas | 20019 | 4 | 0 |
161141 | 161141 | 2020-05-20 | Chautauqua | Kansas | 20019 | 4 | 0 |
164170 | 164170 | 2020-05-21 | Chautauqua | Kansas | 20019 | 4 | 0 |
167202 | 167202 | 2020-05-22 | Chautauqua | Kansas | 20019 | 4 | 0 |
170240 | 170240 | 2020-05-23 | Chautauqua | Kansas | 20019 | 4 | 0 |
173281 | 173281 | 2020-05-24 | Chautauqua | Kansas | 20019 | 4 | 0 |
176325 | 176325 | 2020-05-25 | Chautauqua | Kansas | 20019 | 4 | 0 |
179369 | 179369 | 2020-05-26 | Chautauqua | Kansas | 20019 | 4 | 0 |
182414 | 182414 | 2020-05-27 | Chautauqua | Kansas | 20019 | 4 | 0 |
185468 | 185468 | 2020-05-28 | Chautauqua | Kansas | 20019 | 4 | 0 |
188526 | 188526 | 2020-05-29 | Chautauqua | Kansas | 20019 | 4 | 0 |
191590 | 191590 | 2020-05-30 | Chautauqua | Kansas | 20019 | 4 | 0 |
194658 | 194658 | 2020-05-31 | Chautauqua | Kansas | 20019 | 4 | 0 |
197728 | 197728 | 2020-06-01 | Chautauqua | Kansas | 20019 | 4 | 0 |
200800 | 200800 | 2020-06-02 | Chautauqua | Kansas | 20019 | 4 | 0 |
203876 | 203876 | 2020-06-03 | Chautauqua | Kansas | 20019 | 4 | 0 |
206957 | 206957 | 2020-06-04 | Chautauqua | Kansas | 20019 | 4 | 0 |
210038 | 210038 | 2020-06-05 | Chautauqua | Kansas | 20019 | 4 | 0 |
213123 | 213123 | 2020-06-06 | Chautauqua | Kansas | 20019 | 4 | 0 |
216210 | 216210 | 2020-06-07 | Chautauqua | Kansas | 20019 | 4 | 0 |
219302 | 219302 | 2020-06-08 | Chautauqua | Kansas | 20019 | 4 | 0 |
222397 | 222397 | 2020-06-09 | Chautauqua | Kansas | 20019 | 4 | 0 |
225492 | 225492 | 2020-06-10 | Chautauqua | Kansas | 20019 | 4 | 0 |
228594 | 228594 | 2020-06-11 | Chautauqua | Kansas | 20019 | 4 | 0 |
231697 | 231697 | 2020-06-12 | Chautauqua | Kansas | 20019 | 4 | 0 |
234803 | 234803 | 2020-06-13 | Chautauqua | Kansas | 20019 | 4 | 0 |
237910 | 237910 | 2020-06-14 | Chautauqua | Kansas | 20019 | 4 | 0 |
241019 | 241019 | 2020-06-15 | Chautauqua | Kansas | 20019 | 4 | 0 |
244130 | 244130 | 2020-06-16 | Chautauqua | Kansas | 20019 | 4 | 0 |
247243 | 247243 | 2020-06-17 | Chautauqua | Kansas | 20019 | 4 | 0 |
250355 | 250355 | 2020-06-18 | Chautauqua | Kansas | 20019 | 4 | 0 |
253470 | 253470 | 2020-06-19 | Chautauqua | Kansas | 20019 | 4 | 0 |
256590 | 256590 | 2020-06-20 | Chautauqua | Kansas | 20019 | 4 | 0 |
259716 | 259716 | 2020-06-21 | Chautauqua | Kansas | 20019 | 4 | 0 |
262843 | 262843 | 2020-06-22 | Chautauqua | Kansas | 20019 | 4 | 0 |
265971 | 265971 | 2020-06-23 | Chautauqua | Kansas | 20019 | 4 | 0 |
269101 | 269101 | 2020-06-24 | Chautauqua | Kansas | 20019 | 4 | 0 |
272238 | 272238 | 2020-06-25 | Chautauqua | Kansas | 20019 | 4 | 0 |
275380 | 275380 | 2020-06-26 | Chautauqua | Kansas | 20019 | 4 | 0 |
278528 | 278528 | 2020-06-27 | Chautauqua | Kansas | 20019 | 4 | 0 |
281676 | 281676 | 2020-06-28 | Chautauqua | Kansas | 20019 | 4 | 0 |
284821 | 284821 | 2020-06-29 | Chautauqua | Kansas | 20019 | 4 | 0 |
287970 | 287970 | 2020-06-30 | Chautauqua | Kansas | 20019 | 4 | 0 |
291120 | 291120 | 2020-07-01 | Chautauqua | Kansas | 20019 | 4 | 0 |
294274 | 294274 | 2020-07-02 | Chautauqua | Kansas | 20019 | 4 | 0 |
297432 | 297432 | 2020-07-03 | Chautauqua | Kansas | 20019 | 4 | 0 |
300594 | 300594 | 2020-07-04 | Chautauqua | Kansas | 20019 | 4 | 0 |
303758 | 303758 | 2020-07-05 | Chautauqua | Kansas | 20019 | 4 | 0 |
306923 | 306923 | 2020-07-06 | Chautauqua | Kansas | 20019 | 4 | 0 |
310091 | 310091 | 2020-07-07 | Chautauqua | Kansas | 20019 | 4 | 0 |
313261 | 313261 | 2020-07-08 | Chautauqua | Kansas | 20019 | 5 | 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);