ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
726 rows where fips = 20135 and state = "Kansas" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
155146 | 155146 | 2020-05-18 | Ness | Kansas | 20135 | 1 | 0 |
158163 | 158163 | 2020-05-19 | Ness | Kansas | 20135 | 1 | 0 |
161188 | 161188 | 2020-05-20 | Ness | Kansas | 20135 | 1 | 0 |
164217 | 164217 | 2020-05-21 | Ness | Kansas | 20135 | 1 | 0 |
167252 | 167252 | 2020-05-22 | Ness | Kansas | 20135 | 1 | 0 |
170290 | 170290 | 2020-05-23 | Ness | Kansas | 20135 | 1 | 0 |
173331 | 173331 | 2020-05-24 | Ness | Kansas | 20135 | 1 | 0 |
176375 | 176375 | 2020-05-25 | Ness | Kansas | 20135 | 1 | 0 |
179419 | 179419 | 2020-05-26 | Ness | Kansas | 20135 | 1 | 0 |
182464 | 182464 | 2020-05-27 | Ness | Kansas | 20135 | 1 | 0 |
185518 | 185518 | 2020-05-28 | Ness | Kansas | 20135 | 1 | 0 |
188576 | 188576 | 2020-05-29 | Ness | Kansas | 20135 | 1 | 0 |
191640 | 191640 | 2020-05-30 | Ness | Kansas | 20135 | 1 | 0 |
194708 | 194708 | 2020-05-31 | Ness | Kansas | 20135 | 1 | 0 |
197778 | 197778 | 2020-06-01 | Ness | Kansas | 20135 | 3 | 0 |
200850 | 200850 | 2020-06-02 | Ness | Kansas | 20135 | 3 | 0 |
203926 | 203926 | 2020-06-03 | Ness | Kansas | 20135 | 3 | 0 |
207007 | 207007 | 2020-06-04 | Ness | Kansas | 20135 | 3 | 0 |
210088 | 210088 | 2020-06-05 | Ness | Kansas | 20135 | 4 | 0 |
213173 | 213173 | 2020-06-06 | Ness | Kansas | 20135 | 4 | 0 |
216260 | 216260 | 2020-06-07 | Ness | Kansas | 20135 | 4 | 0 |
219352 | 219352 | 2020-06-08 | Ness | Kansas | 20135 | 4 | 0 |
222447 | 222447 | 2020-06-09 | Ness | Kansas | 20135 | 4 | 0 |
225542 | 225542 | 2020-06-10 | Ness | Kansas | 20135 | 4 | 0 |
228644 | 228644 | 2020-06-11 | Ness | Kansas | 20135 | 4 | 0 |
231747 | 231747 | 2020-06-12 | Ness | Kansas | 20135 | 4 | 0 |
234853 | 234853 | 2020-06-13 | Ness | Kansas | 20135 | 4 | 0 |
237960 | 237960 | 2020-06-14 | Ness | Kansas | 20135 | 4 | 0 |
241069 | 241069 | 2020-06-15 | Ness | Kansas | 20135 | 4 | 0 |
244180 | 244180 | 2020-06-16 | Ness | Kansas | 20135 | 4 | 0 |
247293 | 247293 | 2020-06-17 | Ness | Kansas | 20135 | 4 | 0 |
250405 | 250405 | 2020-06-18 | Ness | Kansas | 20135 | 4 | 0 |
253520 | 253520 | 2020-06-19 | Ness | Kansas | 20135 | 4 | 0 |
256640 | 256640 | 2020-06-20 | Ness | Kansas | 20135 | 4 | 0 |
259766 | 259766 | 2020-06-21 | Ness | Kansas | 20135 | 4 | 0 |
262893 | 262893 | 2020-06-22 | Ness | Kansas | 20135 | 4 | 0 |
266021 | 266021 | 2020-06-23 | Ness | Kansas | 20135 | 4 | 0 |
269153 | 269153 | 2020-06-24 | Ness | Kansas | 20135 | 4 | 0 |
272290 | 272290 | 2020-06-25 | Ness | Kansas | 20135 | 4 | 0 |
275433 | 275433 | 2020-06-26 | Ness | Kansas | 20135 | 4 | 0 |
278581 | 278581 | 2020-06-27 | Ness | Kansas | 20135 | 4 | 0 |
281729 | 281729 | 2020-06-28 | Ness | Kansas | 20135 | 4 | 0 |
284874 | 284874 | 2020-06-29 | Ness | Kansas | 20135 | 4 | 0 |
288023 | 288023 | 2020-06-30 | Ness | Kansas | 20135 | 4 | 0 |
291173 | 291173 | 2020-07-01 | Ness | Kansas | 20135 | 4 | 0 |
294327 | 294327 | 2020-07-02 | Ness | Kansas | 20135 | 4 | 0 |
297485 | 297485 | 2020-07-03 | Ness | Kansas | 20135 | 4 | 0 |
300647 | 300647 | 2020-07-04 | Ness | Kansas | 20135 | 4 | 0 |
303811 | 303811 | 2020-07-05 | Ness | Kansas | 20135 | 4 | 0 |
306978 | 306978 | 2020-07-06 | Ness | Kansas | 20135 | 4 | 0 |
310146 | 310146 | 2020-07-07 | Ness | Kansas | 20135 | 4 | 0 |
313316 | 313316 | 2020-07-08 | Ness | Kansas | 20135 | 4 | 0 |
316490 | 316490 | 2020-07-09 | Ness | Kansas | 20135 | 4 | 0 |
319664 | 319664 | 2020-07-10 | Ness | Kansas | 20135 | 4 | 0 |
322843 | 322843 | 2020-07-11 | Ness | Kansas | 20135 | 4 | 0 |
326026 | 326026 | 2020-07-12 | Ness | Kansas | 20135 | 4 | 0 |
329212 | 329212 | 2020-07-13 | Ness | Kansas | 20135 | 4 | 0 |
332399 | 332399 | 2020-07-14 | Ness | Kansas | 20135 | 4 | 0 |
335592 | 335592 | 2020-07-15 | Ness | Kansas | 20135 | 5 | 0 |
338788 | 338788 | 2020-07-16 | Ness | Kansas | 20135 | 5 | 0 |
341984 | 341984 | 2020-07-17 | Ness | Kansas | 20135 | 5 | 0 |
345184 | 345184 | 2020-07-18 | Ness | Kansas | 20135 | 5 | 0 |
348385 | 348385 | 2020-07-19 | Ness | Kansas | 20135 | 5 | 0 |
351585 | 351585 | 2020-07-20 | Ness | Kansas | 20135 | 5 | 0 |
354787 | 354787 | 2020-07-21 | Ness | Kansas | 20135 | 5 | 0 |
357989 | 357989 | 2020-07-22 | Ness | Kansas | 20135 | 5 | 0 |
361194 | 361194 | 2020-07-23 | Ness | Kansas | 20135 | 5 | 0 |
364401 | 364401 | 2020-07-24 | Ness | Kansas | 20135 | 5 | 0 |
367608 | 367608 | 2020-07-25 | Ness | Kansas | 20135 | 5 | 0 |
370818 | 370818 | 2020-07-26 | Ness | Kansas | 20135 | 5 | 0 |
374030 | 374030 | 2020-07-27 | Ness | Kansas | 20135 | 5 | 0 |
377245 | 377245 | 2020-07-28 | Ness | Kansas | 20135 | 5 | 0 |
380462 | 380462 | 2020-07-29 | Ness | Kansas | 20135 | 5 | 0 |
383679 | 383679 | 2020-07-30 | Ness | Kansas | 20135 | 5 | 0 |
386897 | 386897 | 2020-07-31 | Ness | Kansas | 20135 | 5 | 0 |
390114 | 390114 | 2020-08-01 | Ness | Kansas | 20135 | 5 | 0 |
393331 | 393331 | 2020-08-02 | Ness | Kansas | 20135 | 5 | 0 |
396547 | 396547 | 2020-08-03 | Ness | Kansas | 20135 | 6 | 0 |
399762 | 399762 | 2020-08-04 | Ness | Kansas | 20135 | 6 | 0 |
402979 | 402979 | 2020-08-05 | Ness | Kansas | 20135 | 7 | 0 |
406197 | 406197 | 2020-08-06 | Ness | Kansas | 20135 | 7 | 0 |
409416 | 409416 | 2020-08-07 | Ness | Kansas | 20135 | 7 | 0 |
412636 | 412636 | 2020-08-08 | Ness | Kansas | 20135 | 7 | 0 |
415856 | 415856 | 2020-08-09 | Ness | Kansas | 20135 | 7 | 0 |
419077 | 419077 | 2020-08-10 | Ness | Kansas | 20135 | 7 | 0 |
422300 | 422300 | 2020-08-11 | Ness | Kansas | 20135 | 7 | 0 |
425521 | 425521 | 2020-08-12 | Ness | Kansas | 20135 | 7 | 0 |
428745 | 428745 | 2020-08-13 | Ness | Kansas | 20135 | 7 | 0 |
431973 | 431973 | 2020-08-14 | Ness | Kansas | 20135 | 7 | 0 |
435198 | 435198 | 2020-08-15 | Ness | Kansas | 20135 | 7 | 0 |
438423 | 438423 | 2020-08-16 | Ness | Kansas | 20135 | 7 | 0 |
441650 | 441650 | 2020-08-17 | Ness | Kansas | 20135 | 8 | 0 |
444876 | 444876 | 2020-08-18 | Ness | Kansas | 20135 | 8 | 0 |
448103 | 448103 | 2020-08-19 | Ness | Kansas | 20135 | 9 | 0 |
451331 | 451331 | 2020-08-20 | Ness | Kansas | 20135 | 9 | 0 |
454559 | 454559 | 2020-08-21 | Ness | Kansas | 20135 | 14 | 0 |
457787 | 457787 | 2020-08-22 | Ness | Kansas | 20135 | 14 | 0 |
461014 | 461014 | 2020-08-23 | Ness | Kansas | 20135 | 14 | 0 |
464243 | 464243 | 2020-08-24 | Ness | Kansas | 20135 | 19 | 0 |
467472 | 467472 | 2020-08-25 | Ness | Kansas | 20135 | 19 | 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);