ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Wabaunsee" and state = "Kansas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
33963 | 33963 | 2020-04-05 | Wabaunsee | Kansas | 20197 | 1 | 0 |
36421 | 36421 | 2020-04-06 | Wabaunsee | Kansas | 20197 | 1 | 0 |
38926 | 38926 | 2020-04-07 | Wabaunsee | Kansas | 20197 | 1 | 0 |
41474 | 41474 | 2020-04-08 | Wabaunsee | Kansas | 20197 | 1 | 0 |
44049 | 44049 | 2020-04-09 | Wabaunsee | Kansas | 20197 | 1 | 0 |
46657 | 46657 | 2020-04-10 | Wabaunsee | Kansas | 20197 | 1 | 0 |
49294 | 49294 | 2020-04-11 | Wabaunsee | Kansas | 20197 | 1 | 0 |
51960 | 51960 | 2020-04-12 | Wabaunsee | Kansas | 20197 | 1 | 0 |
54641 | 54641 | 2020-04-13 | Wabaunsee | Kansas | 20197 | 1 | 0 |
57336 | 57336 | 2020-04-14 | Wabaunsee | Kansas | 20197 | 1 | 0 |
60045 | 60045 | 2020-04-15 | Wabaunsee | Kansas | 20197 | 1 | 0 |
62765 | 62765 | 2020-04-16 | Wabaunsee | Kansas | 20197 | 1 | 0 |
65503 | 65503 | 2020-04-17 | Wabaunsee | Kansas | 20197 | 1 | 0 |
68252 | 68252 | 2020-04-18 | Wabaunsee | Kansas | 20197 | 1 | 0 |
71013 | 71013 | 2020-04-19 | Wabaunsee | Kansas | 20197 | 1 | 0 |
73785 | 73785 | 2020-04-20 | Wabaunsee | Kansas | 20197 | 1 | 0 |
76565 | 76565 | 2020-04-21 | Wabaunsee | Kansas | 20197 | 1 | 0 |
79350 | 79350 | 2020-04-22 | Wabaunsee | Kansas | 20197 | 3 | 0 |
82146 | 82146 | 2020-04-23 | Wabaunsee | Kansas | 20197 | 6 | 0 |
84949 | 84949 | 2020-04-24 | Wabaunsee | Kansas | 20197 | 6 | 0 |
87758 | 87758 | 2020-04-25 | Wabaunsee | Kansas | 20197 | 10 | 0 |
90574 | 90574 | 2020-04-26 | Wabaunsee | Kansas | 20197 | 13 | 0 |
93395 | 93395 | 2020-04-27 | Wabaunsee | Kansas | 20197 | 15 | 0 |
96228 | 96228 | 2020-04-28 | Wabaunsee | Kansas | 20197 | 15 | 0 |
99074 | 99074 | 2020-04-29 | Wabaunsee | Kansas | 20197 | 18 | 0 |
101926 | 101926 | 2020-04-30 | Wabaunsee | Kansas | 20197 | 21 | 0 |
104787 | 104787 | 2020-05-01 | Wabaunsee | Kansas | 20197 | 22 | 0 |
107652 | 107652 | 2020-05-02 | Wabaunsee | Kansas | 20197 | 23 | 0 |
110523 | 110523 | 2020-05-03 | Wabaunsee | Kansas | 20197 | 24 | 0 |
113400 | 113400 | 2020-05-04 | Wabaunsee | Kansas | 20197 | 25 | 0 |
116282 | 116282 | 2020-05-05 | Wabaunsee | Kansas | 20197 | 26 | 0 |
119243 | 119243 | 2020-05-06 | Wabaunsee | Kansas | 20197 | 27 | 0 |
122213 | 122213 | 2020-05-07 | Wabaunsee | Kansas | 20197 | 27 | 0 |
125195 | 125195 | 2020-05-08 | Wabaunsee | Kansas | 20197 | 27 | 0 |
128183 | 128183 | 2020-05-09 | Wabaunsee | Kansas | 20197 | 27 | 0 |
131173 | 131173 | 2020-05-10 | Wabaunsee | Kansas | 20197 | 27 | 0 |
134164 | 134164 | 2020-05-11 | Wabaunsee | Kansas | 20197 | 27 | 0 |
137154 | 137154 | 2020-05-12 | Wabaunsee | Kansas | 20197 | 27 | 0 |
140147 | 140147 | 2020-05-13 | Wabaunsee | Kansas | 20197 | 27 | 0 |
143143 | 143143 | 2020-05-14 | Wabaunsee | Kansas | 20197 | 27 | 0 |
146143 | 146143 | 2020-05-15 | Wabaunsee | Kansas | 20197 | 28 | 0 |
149147 | 149147 | 2020-05-16 | Wabaunsee | Kansas | 20197 | 28 | 0 |
152158 | 152158 | 2020-05-17 | Wabaunsee | Kansas | 20197 | 28 | 0 |
155171 | 155171 | 2020-05-18 | Wabaunsee | Kansas | 20197 | 28 | 0 |
158188 | 158188 | 2020-05-19 | Wabaunsee | Kansas | 20197 | 28 | 0 |
161213 | 161213 | 2020-05-20 | Wabaunsee | Kansas | 20197 | 29 | 0 |
164242 | 164242 | 2020-05-21 | Wabaunsee | Kansas | 20197 | 29 | 0 |
167278 | 167278 | 2020-05-22 | Wabaunsee | Kansas | 20197 | 29 | 0 |
170316 | 170316 | 2020-05-23 | Wabaunsee | Kansas | 20197 | 29 | 0 |
173357 | 173357 | 2020-05-24 | Wabaunsee | Kansas | 20197 | 29 | 0 |
176401 | 176401 | 2020-05-25 | Wabaunsee | Kansas | 20197 | 30 | 0 |
179445 | 179445 | 2020-05-26 | Wabaunsee | Kansas | 20197 | 30 | 0 |
182490 | 182490 | 2020-05-27 | Wabaunsee | Kansas | 20197 | 31 | 0 |
185544 | 185544 | 2020-05-28 | Wabaunsee | Kansas | 20197 | 31 | 0 |
188602 | 188602 | 2020-05-29 | Wabaunsee | Kansas | 20197 | 31 | 0 |
191666 | 191666 | 2020-05-30 | Wabaunsee | Kansas | 20197 | 31 | 0 |
194734 | 194734 | 2020-05-31 | Wabaunsee | Kansas | 20197 | 31 | 0 |
197805 | 197805 | 2020-06-01 | Wabaunsee | Kansas | 20197 | 31 | 0 |
200876 | 200876 | 2020-06-02 | Wabaunsee | Kansas | 20197 | 31 | 0 |
203953 | 203953 | 2020-06-03 | Wabaunsee | Kansas | 20197 | 31 | 0 |
207034 | 207034 | 2020-06-04 | Wabaunsee | Kansas | 20197 | 31 | 0 |
210115 | 210115 | 2020-06-05 | Wabaunsee | Kansas | 20197 | 31 | 0 |
213200 | 213200 | 2020-06-06 | Wabaunsee | Kansas | 20197 | 31 | 0 |
216287 | 216287 | 2020-06-07 | Wabaunsee | Kansas | 20197 | 31 | 0 |
219379 | 219379 | 2020-06-08 | Wabaunsee | Kansas | 20197 | 31 | 0 |
222474 | 222474 | 2020-06-09 | Wabaunsee | Kansas | 20197 | 31 | 0 |
225569 | 225569 | 2020-06-10 | Wabaunsee | Kansas | 20197 | 31 | 0 |
228671 | 228671 | 2020-06-11 | Wabaunsee | Kansas | 20197 | 31 | 0 |
231775 | 231775 | 2020-06-12 | Wabaunsee | Kansas | 20197 | 31 | 0 |
234880 | 234880 | 2020-06-13 | Wabaunsee | Kansas | 20197 | 31 | 0 |
237987 | 237987 | 2020-06-14 | Wabaunsee | Kansas | 20197 | 31 | 0 |
241096 | 241096 | 2020-06-15 | Wabaunsee | Kansas | 20197 | 31 | 0 |
244207 | 244207 | 2020-06-16 | Wabaunsee | Kansas | 20197 | 31 | 0 |
247320 | 247320 | 2020-06-17 | Wabaunsee | Kansas | 20197 | 32 | 0 |
250432 | 250432 | 2020-06-18 | Wabaunsee | Kansas | 20197 | 32 | 0 |
253547 | 253547 | 2020-06-19 | Wabaunsee | Kansas | 20197 | 32 | 0 |
256667 | 256667 | 2020-06-20 | Wabaunsee | Kansas | 20197 | 32 | 0 |
259793 | 259793 | 2020-06-21 | Wabaunsee | Kansas | 20197 | 32 | 0 |
262922 | 262922 | 2020-06-22 | Wabaunsee | Kansas | 20197 | 32 | 0 |
266049 | 266049 | 2020-06-23 | Wabaunsee | Kansas | 20197 | 32 | 0 |
269182 | 269182 | 2020-06-24 | Wabaunsee | Kansas | 20197 | 33 | 0 |
272318 | 272318 | 2020-06-25 | Wabaunsee | Kansas | 20197 | 33 | 0 |
275461 | 275461 | 2020-06-26 | Wabaunsee | Kansas | 20197 | 34 | 0 |
278609 | 278609 | 2020-06-27 | Wabaunsee | Kansas | 20197 | 34 | 0 |
281757 | 281757 | 2020-06-28 | Wabaunsee | Kansas | 20197 | 34 | 0 |
284903 | 284903 | 2020-06-29 | Wabaunsee | Kansas | 20197 | 35 | 0 |
288052 | 288052 | 2020-06-30 | Wabaunsee | Kansas | 20197 | 35 | 0 |
291202 | 291202 | 2020-07-01 | Wabaunsee | Kansas | 20197 | 35 | 0 |
294356 | 294356 | 2020-07-02 | Wabaunsee | Kansas | 20197 | 35 | 0 |
297514 | 297514 | 2020-07-03 | Wabaunsee | Kansas | 20197 | 36 | 0 |
300676 | 300676 | 2020-07-04 | Wabaunsee | Kansas | 20197 | 36 | 0 |
303840 | 303840 | 2020-07-05 | Wabaunsee | Kansas | 20197 | 36 | 0 |
307007 | 307007 | 2020-07-06 | Wabaunsee | Kansas | 20197 | 36 | 0 |
310175 | 310175 | 2020-07-07 | Wabaunsee | Kansas | 20197 | 36 | 0 |
313345 | 313345 | 2020-07-08 | Wabaunsee | Kansas | 20197 | 38 | 0 |
316519 | 316519 | 2020-07-09 | Wabaunsee | Kansas | 20197 | 38 | 0 |
319694 | 319694 | 2020-07-10 | Wabaunsee | Kansas | 20197 | 38 | 0 |
322873 | 322873 | 2020-07-11 | Wabaunsee | Kansas | 20197 | 38 | 0 |
326056 | 326056 | 2020-07-12 | Wabaunsee | Kansas | 20197 | 38 | 0 |
329242 | 329242 | 2020-07-13 | Wabaunsee | Kansas | 20197 | 38 | 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);