ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 20149 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635853 | 635853 | 2020-10-16 | Pottawatomie | Kansas | 20149 | 347 | 0 |
632607 | 632607 | 2020-10-15 | Pottawatomie | Kansas | 20149 | 335 | 0 |
629363 | 629363 | 2020-10-14 | Pottawatomie | Kansas | 20149 | 335 | 0 |
626120 | 626120 | 2020-10-13 | Pottawatomie | Kansas | 20149 | 327 | 0 |
622878 | 622878 | 2020-10-12 | Pottawatomie | Kansas | 20149 | 327 | 0 |
619634 | 619634 | 2020-10-11 | Pottawatomie | Kansas | 20149 | 316 | 0 |
616392 | 616392 | 2020-10-10 | Pottawatomie | Kansas | 20149 | 316 | 0 |
613151 | 613151 | 2020-10-09 | Pottawatomie | Kansas | 20149 | 316 | 0 |
609909 | 609909 | 2020-10-08 | Pottawatomie | Kansas | 20149 | 308 | 0 |
606666 | 606666 | 2020-10-07 | Pottawatomie | Kansas | 20149 | 308 | 0 |
603424 | 603424 | 2020-10-06 | Pottawatomie | Kansas | 20149 | 296 | 0 |
600181 | 600181 | 2020-10-05 | Pottawatomie | Kansas | 20149 | 296 | 0 |
596939 | 596939 | 2020-10-04 | Pottawatomie | Kansas | 20149 | 288 | 0 |
593697 | 593697 | 2020-10-03 | Pottawatomie | Kansas | 20149 | 288 | 0 |
590456 | 590456 | 2020-10-02 | Pottawatomie | Kansas | 20149 | 288 | 0 |
587215 | 587215 | 2020-10-01 | Pottawatomie | Kansas | 20149 | 278 | 0 |
583975 | 583975 | 2020-09-30 | Pottawatomie | Kansas | 20149 | 278 | 0 |
580736 | 580736 | 2020-09-29 | Pottawatomie | Kansas | 20149 | 265 | 0 |
577495 | 577495 | 2020-09-28 | Pottawatomie | Kansas | 20149 | 265 | 0 |
574253 | 574253 | 2020-09-27 | Pottawatomie | Kansas | 20149 | 249 | 0 |
571010 | 571010 | 2020-09-26 | Pottawatomie | Kansas | 20149 | 249 | 0 |
567768 | 567768 | 2020-09-25 | Pottawatomie | Kansas | 20149 | 249 | 0 |
564528 | 564528 | 2020-09-24 | Pottawatomie | Kansas | 20149 | 238 | 0 |
561288 | 561288 | 2020-09-23 | Pottawatomie | Kansas | 20149 | 235 | 0 |
558052 | 558052 | 2020-09-22 | Pottawatomie | Kansas | 20149 | 226 | 0 |
554815 | 554815 | 2020-09-21 | Pottawatomie | Kansas | 20149 | 226 | 0 |
551576 | 551576 | 2020-09-20 | Pottawatomie | Kansas | 20149 | 212 | 0 |
548337 | 548337 | 2020-09-19 | Pottawatomie | Kansas | 20149 | 212 | 0 |
545099 | 545099 | 2020-09-18 | Pottawatomie | Kansas | 20149 | 212 | 0 |
541863 | 541863 | 2020-09-17 | Pottawatomie | Kansas | 20149 | 194 | 0 |
538626 | 538626 | 2020-09-16 | Pottawatomie | Kansas | 20149 | 194 | 0 |
535390 | 535390 | 2020-09-15 | Pottawatomie | Kansas | 20149 | 187 | 0 |
532155 | 532155 | 2020-09-14 | Pottawatomie | Kansas | 20149 | 187 | 0 |
528918 | 528918 | 2020-09-13 | Pottawatomie | Kansas | 20149 | 183 | 0 |
525682 | 525682 | 2020-09-12 | Pottawatomie | Kansas | 20149 | 183 | 0 |
522446 | 522446 | 2020-09-11 | Pottawatomie | Kansas | 20149 | 183 | 0 |
519209 | 519209 | 2020-09-10 | Pottawatomie | Kansas | 20149 | 178 | 0 |
515974 | 515974 | 2020-09-09 | Pottawatomie | Kansas | 20149 | 178 | 0 |
512741 | 512741 | 2020-09-08 | Pottawatomie | Kansas | 20149 | 177 | 0 |
509508 | 509508 | 2020-09-07 | Pottawatomie | Kansas | 20149 | 177 | 0 |
506276 | 506276 | 2020-09-06 | Pottawatomie | Kansas | 20149 | 171 | 0 |
503042 | 503042 | 2020-09-05 | Pottawatomie | Kansas | 20149 | 171 | 0 |
499808 | 499808 | 2020-09-04 | Pottawatomie | Kansas | 20149 | 171 | 0 |
496575 | 496575 | 2020-09-03 | Pottawatomie | Kansas | 20149 | 163 | 0 |
493341 | 493341 | 2020-09-02 | Pottawatomie | Kansas | 20149 | 163 | 0 |
490108 | 490108 | 2020-09-01 | Pottawatomie | Kansas | 20149 | 156 | 0 |
486875 | 486875 | 2020-08-31 | Pottawatomie | Kansas | 20149 | 156 | 0 |
483640 | 483640 | 2020-08-30 | Pottawatomie | Kansas | 20149 | 151 | 0 |
480406 | 480406 | 2020-08-29 | Pottawatomie | Kansas | 20149 | 151 | 0 |
477173 | 477173 | 2020-08-28 | Pottawatomie | Kansas | 20149 | 151 | 0 |
473940 | 473940 | 2020-08-27 | Pottawatomie | Kansas | 20149 | 144 | 0 |
470708 | 470708 | 2020-08-26 | Pottawatomie | Kansas | 20149 | 144 | 0 |
467479 | 467479 | 2020-08-25 | Pottawatomie | Kansas | 20149 | 142 | 0 |
464250 | 464250 | 2020-08-24 | Pottawatomie | Kansas | 20149 | 142 | 0 |
461021 | 461021 | 2020-08-23 | Pottawatomie | Kansas | 20149 | 132 | 0 |
457794 | 457794 | 2020-08-22 | Pottawatomie | Kansas | 20149 | 132 | 0 |
454566 | 454566 | 2020-08-21 | Pottawatomie | Kansas | 20149 | 132 | 0 |
451338 | 451338 | 2020-08-20 | Pottawatomie | Kansas | 20149 | 132 | 0 |
448110 | 448110 | 2020-08-19 | Pottawatomie | Kansas | 20149 | 132 | 0 |
444883 | 444883 | 2020-08-18 | Pottawatomie | Kansas | 20149 | 123 | 0 |
441657 | 441657 | 2020-08-17 | Pottawatomie | Kansas | 20149 | 123 | 0 |
438430 | 438430 | 2020-08-16 | Pottawatomie | Kansas | 20149 | 119 | 0 |
435205 | 435205 | 2020-08-15 | Pottawatomie | Kansas | 20149 | 119 | 0 |
431980 | 431980 | 2020-08-14 | Pottawatomie | Kansas | 20149 | 119 | 0 |
428752 | 428752 | 2020-08-13 | Pottawatomie | Kansas | 20149 | 117 | 0 |
425528 | 425528 | 2020-08-12 | Pottawatomie | Kansas | 20149 | 117 | 0 |
422307 | 422307 | 2020-08-11 | Pottawatomie | Kansas | 20149 | 116 | 0 |
419084 | 419084 | 2020-08-10 | Pottawatomie | Kansas | 20149 | 116 | 0 |
415863 | 415863 | 2020-08-09 | Pottawatomie | Kansas | 20149 | 114 | 0 |
412643 | 412643 | 2020-08-08 | Pottawatomie | Kansas | 20149 | 114 | 0 |
409423 | 409423 | 2020-08-07 | Pottawatomie | Kansas | 20149 | 114 | 0 |
406204 | 406204 | 2020-08-06 | Pottawatomie | Kansas | 20149 | 114 | 0 |
402986 | 402986 | 2020-08-05 | Pottawatomie | Kansas | 20149 | 114 | 0 |
399769 | 399769 | 2020-08-04 | Pottawatomie | Kansas | 20149 | 112 | 0 |
396554 | 396554 | 2020-08-03 | Pottawatomie | Kansas | 20149 | 112 | 0 |
393338 | 393338 | 2020-08-02 | Pottawatomie | Kansas | 20149 | 109 | 0 |
390121 | 390121 | 2020-08-01 | Pottawatomie | Kansas | 20149 | 109 | 0 |
386904 | 386904 | 2020-07-31 | Pottawatomie | Kansas | 20149 | 109 | 0 |
383686 | 383686 | 2020-07-30 | Pottawatomie | Kansas | 20149 | 107 | 0 |
380469 | 380469 | 2020-07-29 | Pottawatomie | Kansas | 20149 | 107 | 0 |
377252 | 377252 | 2020-07-28 | Pottawatomie | Kansas | 20149 | 107 | 0 |
374037 | 374037 | 2020-07-27 | Pottawatomie | Kansas | 20149 | 107 | 0 |
370825 | 370825 | 2020-07-26 | Pottawatomie | Kansas | 20149 | 105 | 0 |
367615 | 367615 | 2020-07-25 | Pottawatomie | Kansas | 20149 | 105 | 0 |
364408 | 364408 | 2020-07-24 | Pottawatomie | Kansas | 20149 | 105 | 0 |
361201 | 361201 | 2020-07-23 | Pottawatomie | Kansas | 20149 | 103 | 0 |
357996 | 357996 | 2020-07-22 | Pottawatomie | Kansas | 20149 | 103 | 0 |
354794 | 354794 | 2020-07-21 | Pottawatomie | Kansas | 20149 | 102 | 0 |
351592 | 351592 | 2020-07-20 | Pottawatomie | Kansas | 20149 | 102 | 0 |
348392 | 348392 | 2020-07-19 | Pottawatomie | Kansas | 20149 | 98 | 0 |
345191 | 345191 | 2020-07-18 | Pottawatomie | Kansas | 20149 | 98 | 0 |
341991 | 341991 | 2020-07-17 | Pottawatomie | Kansas | 20149 | 98 | 0 |
338795 | 338795 | 2020-07-16 | Pottawatomie | Kansas | 20149 | 96 | 0 |
335599 | 335599 | 2020-07-15 | Pottawatomie | Kansas | 20149 | 96 | 0 |
332406 | 332406 | 2020-07-14 | Pottawatomie | Kansas | 20149 | 93 | 0 |
329219 | 329219 | 2020-07-13 | Pottawatomie | Kansas | 20149 | 93 | 0 |
326033 | 326033 | 2020-07-12 | Pottawatomie | Kansas | 20149 | 89 | 0 |
322850 | 322850 | 2020-07-11 | Pottawatomie | Kansas | 20149 | 89 | 0 |
319671 | 319671 | 2020-07-10 | Pottawatomie | Kansas | 20149 | 89 | 0 |
316497 | 316497 | 2020-07-09 | Pottawatomie | Kansas | 20149 | 83 | 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);