ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
691 rows where county = "Thomas" and state = "Kansas" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
262919 | 262919 | 2020-06-22 | Thomas | Kansas | 20193 | 10 | 0 |
266047 | 266047 | 2020-06-23 | Thomas | Kansas | 20193 | 10 | 0 |
269179 | 269179 | 2020-06-24 | Thomas | Kansas | 20193 | 14 | 0 |
272316 | 272316 | 2020-06-25 | Thomas | Kansas | 20193 | 14 | 0 |
275459 | 275459 | 2020-06-26 | Thomas | Kansas | 20193 | 15 | 0 |
278607 | 278607 | 2020-06-27 | Thomas | Kansas | 20193 | 15 | 0 |
281755 | 281755 | 2020-06-28 | Thomas | Kansas | 20193 | 15 | 0 |
284901 | 284901 | 2020-06-29 | Thomas | Kansas | 20193 | 15 | 0 |
288050 | 288050 | 2020-06-30 | Thomas | Kansas | 20193 | 15 | 0 |
291200 | 291200 | 2020-07-01 | Thomas | Kansas | 20193 | 15 | 0 |
294354 | 294354 | 2020-07-02 | Thomas | Kansas | 20193 | 15 | 0 |
297512 | 297512 | 2020-07-03 | Thomas | Kansas | 20193 | 15 | 0 |
300674 | 300674 | 2020-07-04 | Thomas | Kansas | 20193 | 15 | 0 |
303838 | 303838 | 2020-07-05 | Thomas | Kansas | 20193 | 15 | 0 |
307005 | 307005 | 2020-07-06 | Thomas | Kansas | 20193 | 16 | 0 |
310173 | 310173 | 2020-07-07 | Thomas | Kansas | 20193 | 16 | 0 |
313343 | 313343 | 2020-07-08 | Thomas | Kansas | 20193 | 17 | 0 |
316517 | 316517 | 2020-07-09 | Thomas | Kansas | 20193 | 17 | 0 |
319692 | 319692 | 2020-07-10 | Thomas | Kansas | 20193 | 17 | 0 |
322871 | 322871 | 2020-07-11 | Thomas | Kansas | 20193 | 17 | 0 |
326054 | 326054 | 2020-07-12 | Thomas | Kansas | 20193 | 18 | 0 |
329240 | 329240 | 2020-07-13 | Thomas | Kansas | 20193 | 18 | 0 |
332427 | 332427 | 2020-07-14 | Thomas | Kansas | 20193 | 18 | 0 |
335620 | 335620 | 2020-07-15 | Thomas | Kansas | 20193 | 19 | 0 |
338816 | 338816 | 2020-07-16 | Thomas | Kansas | 20193 | 19 | 0 |
342012 | 342012 | 2020-07-17 | Thomas | Kansas | 20193 | 20 | 0 |
345212 | 345212 | 2020-07-18 | Thomas | Kansas | 20193 | 20 | 0 |
348413 | 348413 | 2020-07-19 | Thomas | Kansas | 20193 | 20 | 0 |
351613 | 351613 | 2020-07-20 | Thomas | Kansas | 20193 | 24 | 0 |
354815 | 354815 | 2020-07-21 | Thomas | Kansas | 20193 | 24 | 0 |
358017 | 358017 | 2020-07-22 | Thomas | Kansas | 20193 | 23 | 0 |
361222 | 361222 | 2020-07-23 | Thomas | Kansas | 20193 | 23 | 0 |
364429 | 364429 | 2020-07-24 | Thomas | Kansas | 20193 | 25 | 0 |
367636 | 367636 | 2020-07-25 | Thomas | Kansas | 20193 | 25 | 0 |
370846 | 370846 | 2020-07-26 | Thomas | Kansas | 20193 | 25 | 0 |
374058 | 374058 | 2020-07-27 | Thomas | Kansas | 20193 | 26 | 0 |
377273 | 377273 | 2020-07-28 | Thomas | Kansas | 20193 | 31 | 0 |
380490 | 380490 | 2020-07-29 | Thomas | Kansas | 20193 | 31 | 0 |
383707 | 383707 | 2020-07-30 | Thomas | Kansas | 20193 | 31 | 0 |
386925 | 386925 | 2020-07-31 | Thomas | Kansas | 20193 | 32 | 0 |
390142 | 390142 | 2020-08-01 | Thomas | Kansas | 20193 | 32 | 0 |
393359 | 393359 | 2020-08-02 | Thomas | Kansas | 20193 | 32 | 0 |
396575 | 396575 | 2020-08-03 | Thomas | Kansas | 20193 | 32 | 0 |
399790 | 399790 | 2020-08-04 | Thomas | Kansas | 20193 | 32 | 0 |
403007 | 403007 | 2020-08-05 | Thomas | Kansas | 20193 | 34 | 0 |
406225 | 406225 | 2020-08-06 | Thomas | Kansas | 20193 | 34 | 0 |
409444 | 409444 | 2020-08-07 | Thomas | Kansas | 20193 | 35 | 0 |
412664 | 412664 | 2020-08-08 | Thomas | Kansas | 20193 | 35 | 0 |
415884 | 415884 | 2020-08-09 | Thomas | Kansas | 20193 | 38 | 0 |
419105 | 419105 | 2020-08-10 | Thomas | Kansas | 20193 | 38 | 0 |
422328 | 422328 | 2020-08-11 | Thomas | Kansas | 20193 | 40 | 0 |
425549 | 425549 | 2020-08-12 | Thomas | Kansas | 20193 | 43 | 0 |
428773 | 428773 | 2020-08-13 | Thomas | Kansas | 20193 | 43 | 0 |
432001 | 432001 | 2020-08-14 | Thomas | Kansas | 20193 | 45 | 0 |
435226 | 435226 | 2020-08-15 | Thomas | Kansas | 20193 | 47 | 0 |
438451 | 438451 | 2020-08-16 | Thomas | Kansas | 20193 | 47 | 0 |
441678 | 441678 | 2020-08-17 | Thomas | Kansas | 20193 | 49 | 0 |
444904 | 444904 | 2020-08-18 | Thomas | Kansas | 20193 | 49 | 0 |
448131 | 448131 | 2020-08-19 | Thomas | Kansas | 20193 | 49 | 0 |
451359 | 451359 | 2020-08-20 | Thomas | Kansas | 20193 | 49 | 0 |
454587 | 454587 | 2020-08-21 | Thomas | Kansas | 20193 | 50 | 0 |
457815 | 457815 | 2020-08-22 | Thomas | Kansas | 20193 | 51 | 0 |
461042 | 461042 | 2020-08-23 | Thomas | Kansas | 20193 | 51 | 0 |
464272 | 464272 | 2020-08-24 | Thomas | Kansas | 20193 | 51 | 0 |
467501 | 467501 | 2020-08-25 | Thomas | Kansas | 20193 | 51 | 0 |
470730 | 470730 | 2020-08-26 | Thomas | Kansas | 20193 | 51 | 0 |
473962 | 473962 | 2020-08-27 | Thomas | Kansas | 20193 | 51 | 0 |
477195 | 477195 | 2020-08-28 | Thomas | Kansas | 20193 | 52 | 0 |
480428 | 480428 | 2020-08-29 | Thomas | Kansas | 20193 | 52 | 0 |
483662 | 483662 | 2020-08-30 | Thomas | Kansas | 20193 | 52 | 0 |
486897 | 486897 | 2020-08-31 | Thomas | Kansas | 20193 | 51 | 0 |
490130 | 490130 | 2020-09-01 | Thomas | Kansas | 20193 | 52 | 0 |
493363 | 493363 | 2020-09-02 | Thomas | Kansas | 20193 | 52 | 0 |
496597 | 496597 | 2020-09-03 | Thomas | Kansas | 20193 | 52 | 0 |
499830 | 499830 | 2020-09-04 | Thomas | Kansas | 20193 | 60 | 0 |
503064 | 503064 | 2020-09-05 | Thomas | Kansas | 20193 | 60 | 0 |
506298 | 506298 | 2020-09-06 | Thomas | Kansas | 20193 | 64 | 0 |
509530 | 509530 | 2020-09-07 | Thomas | Kansas | 20193 | 64 | 0 |
512763 | 512763 | 2020-09-08 | Thomas | Kansas | 20193 | 71 | 0 |
515996 | 515996 | 2020-09-09 | Thomas | Kansas | 20193 | 71 | 0 |
519231 | 519231 | 2020-09-10 | Thomas | Kansas | 20193 | 71 | 0 |
522468 | 522468 | 2020-09-11 | Thomas | Kansas | 20193 | 82 | 0 |
525704 | 525704 | 2020-09-12 | Thomas | Kansas | 20193 | 85 | 0 |
528940 | 528940 | 2020-09-13 | Thomas | Kansas | 20193 | 90 | 0 |
532177 | 532177 | 2020-09-14 | Thomas | Kansas | 20193 | 90 | 0 |
535412 | 535412 | 2020-09-15 | Thomas | Kansas | 20193 | 99 | 0 |
538648 | 538648 | 2020-09-16 | Thomas | Kansas | 20193 | 99 | 0 |
541885 | 541885 | 2020-09-17 | Thomas | Kansas | 20193 | 99 | 0 |
545121 | 545121 | 2020-09-18 | Thomas | Kansas | 20193 | 109 | 0 |
548359 | 548359 | 2020-09-19 | Thomas | Kansas | 20193 | 124 | 0 |
551598 | 551598 | 2020-09-20 | Thomas | Kansas | 20193 | 124 | 0 |
554837 | 554837 | 2020-09-21 | Thomas | Kansas | 20193 | 128 | 0 |
558074 | 558074 | 2020-09-22 | Thomas | Kansas | 20193 | 131 | 0 |
561310 | 561310 | 2020-09-23 | Thomas | Kansas | 20193 | 131 | 0 |
564550 | 564550 | 2020-09-24 | Thomas | Kansas | 20193 | 131 | 0 |
567790 | 567790 | 2020-09-25 | Thomas | Kansas | 20193 | 131 | 0 |
571032 | 571032 | 2020-09-26 | Thomas | Kansas | 20193 | 131 | 0 |
574275 | 574275 | 2020-09-27 | Thomas | Kansas | 20193 | 159 | 0 |
577517 | 577517 | 2020-09-28 | Thomas | Kansas | 20193 | 163 | 0 |
580758 | 580758 | 2020-09-29 | Thomas | Kansas | 20193 | 165 | 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);