ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Ford" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635807 | 635807 | 2020-10-16 | Ford | Kansas | 20057 | 3240 | 10 |
632561 | 632561 | 2020-10-15 | Ford | Kansas | 20057 | 3203 | 10 |
629317 | 629317 | 2020-10-14 | Ford | Kansas | 20057 | 3203 | 10 |
626074 | 626074 | 2020-10-13 | Ford | Kansas | 20057 | 3174 | 10 |
622832 | 622832 | 2020-10-12 | Ford | Kansas | 20057 | 3174 | 10 |
619588 | 619588 | 2020-10-11 | Ford | Kansas | 20057 | 3094 | 10 |
616346 | 616346 | 2020-10-10 | Ford | Kansas | 20057 | 3094 | 10 |
613105 | 613105 | 2020-10-09 | Ford | Kansas | 20057 | 3094 | 10 |
609863 | 609863 | 2020-10-08 | Ford | Kansas | 20057 | 3034 | 10 |
606620 | 606620 | 2020-10-07 | Ford | Kansas | 20057 | 3034 | 10 |
603378 | 603378 | 2020-10-06 | Ford | Kansas | 20057 | 2986 | 10 |
600135 | 600135 | 2020-10-05 | Ford | Kansas | 20057 | 2986 | 10 |
596893 | 596893 | 2020-10-04 | Ford | Kansas | 20057 | 2942 | 10 |
593651 | 593651 | 2020-10-03 | Ford | Kansas | 20057 | 2942 | 10 |
590410 | 590410 | 2020-10-02 | Ford | Kansas | 20057 | 2942 | 10 |
587169 | 587169 | 2020-10-01 | Ford | Kansas | 20057 | 2902 | 10 |
583929 | 583929 | 2020-09-30 | Ford | Kansas | 20057 | 2902 | 10 |
580690 | 580690 | 2020-09-29 | Ford | Kansas | 20057 | 2859 | 10 |
577449 | 577449 | 2020-09-28 | Ford | Kansas | 20057 | 2859 | 10 |
574207 | 574207 | 2020-09-27 | Ford | Kansas | 20057 | 2800 | 10 |
570964 | 570964 | 2020-09-26 | Ford | Kansas | 20057 | 2800 | 10 |
567722 | 567722 | 2020-09-25 | Ford | Kansas | 20057 | 2800 | 10 |
564482 | 564482 | 2020-09-24 | Ford | Kansas | 20057 | 2756 | 10 |
561242 | 561242 | 2020-09-23 | Ford | Kansas | 20057 | 2756 | 10 |
558006 | 558006 | 2020-09-22 | Ford | Kansas | 20057 | 2691 | 10 |
554769 | 554769 | 2020-09-21 | Ford | Kansas | 20057 | 2691 | 10 |
551530 | 551530 | 2020-09-20 | Ford | Kansas | 20057 | 2627 | 10 |
548291 | 548291 | 2020-09-19 | Ford | Kansas | 20057 | 2627 | 10 |
545053 | 545053 | 2020-09-18 | Ford | Kansas | 20057 | 2627 | 10 |
541817 | 541817 | 2020-09-17 | Ford | Kansas | 20057 | 2571 | 10 |
538580 | 538580 | 2020-09-16 | Ford | Kansas | 20057 | 2571 | 10 |
535344 | 535344 | 2020-09-15 | Ford | Kansas | 20057 | 2534 | 10 |
532109 | 532109 | 2020-09-14 | Ford | Kansas | 20057 | 2534 | 10 |
528872 | 528872 | 2020-09-13 | Ford | Kansas | 20057 | 2486 | 10 |
525636 | 525636 | 2020-09-12 | Ford | Kansas | 20057 | 2486 | 10 |
522400 | 522400 | 2020-09-11 | Ford | Kansas | 20057 | 2486 | 10 |
519163 | 519163 | 2020-09-10 | Ford | Kansas | 20057 | 2448 | 10 |
515928 | 515928 | 2020-09-09 | Ford | Kansas | 20057 | 2448 | 10 |
512695 | 512695 | 2020-09-08 | Ford | Kansas | 20057 | 2423 | 10 |
509462 | 509462 | 2020-09-07 | Ford | Kansas | 20057 | 2423 | 10 |
506230 | 506230 | 2020-09-06 | Ford | Kansas | 20057 | 2395 | 10 |
502996 | 502996 | 2020-09-05 | Ford | Kansas | 20057 | 2395 | 10 |
499762 | 499762 | 2020-09-04 | Ford | Kansas | 20057 | 2395 | 10 |
496529 | 496529 | 2020-09-03 | Ford | Kansas | 20057 | 2373 | 10 |
493295 | 493295 | 2020-09-02 | Ford | Kansas | 20057 | 2373 | 10 |
490062 | 490062 | 2020-09-01 | Ford | Kansas | 20057 | 2333 | 10 |
486829 | 486829 | 2020-08-31 | Ford | Kansas | 20057 | 2333 | 10 |
483594 | 483594 | 2020-08-30 | Ford | Kansas | 20057 | 2309 | 10 |
480360 | 480360 | 2020-08-29 | Ford | Kansas | 20057 | 2309 | 10 |
477127 | 477127 | 2020-08-28 | Ford | Kansas | 20057 | 2309 | 10 |
473894 | 473894 | 2020-08-27 | Ford | Kansas | 20057 | 2282 | 10 |
470662 | 470662 | 2020-08-26 | Ford | Kansas | 20057 | 2282 | 10 |
467433 | 467433 | 2020-08-25 | Ford | Kansas | 20057 | 2257 | 10 |
464204 | 464204 | 2020-08-24 | Ford | Kansas | 20057 | 2257 | 10 |
460975 | 460975 | 2020-08-23 | Ford | Kansas | 20057 | 2241 | 10 |
457748 | 457748 | 2020-08-22 | Ford | Kansas | 20057 | 2241 | 10 |
454520 | 454520 | 2020-08-21 | Ford | Kansas | 20057 | 2241 | 10 |
451292 | 451292 | 2020-08-20 | Ford | Kansas | 20057 | 2237 | 10 |
448064 | 448064 | 2020-08-19 | Ford | Kansas | 20057 | 2237 | 10 |
444837 | 444837 | 2020-08-18 | Ford | Kansas | 20057 | 2219 | 10 |
441611 | 441611 | 2020-08-17 | Ford | Kansas | 20057 | 2219 | 10 |
438384 | 438384 | 2020-08-16 | Ford | Kansas | 20057 | 2206 | 10 |
435159 | 435159 | 2020-08-15 | Ford | Kansas | 20057 | 2206 | 10 |
431934 | 431934 | 2020-08-14 | Ford | Kansas | 20057 | 2206 | 10 |
428706 | 428706 | 2020-08-13 | Ford | Kansas | 20057 | 2191 | 10 |
425482 | 425482 | 2020-08-12 | Ford | Kansas | 20057 | 2191 | 10 |
422261 | 422261 | 2020-08-11 | Ford | Kansas | 20057 | 2184 | 10 |
419038 | 419038 | 2020-08-10 | Ford | Kansas | 20057 | 2184 | 10 |
415817 | 415817 | 2020-08-09 | Ford | Kansas | 20057 | 2161 | 10 |
412597 | 412597 | 2020-08-08 | Ford | Kansas | 20057 | 2161 | 10 |
409377 | 409377 | 2020-08-07 | Ford | Kansas | 20057 | 2161 | 10 |
406158 | 406158 | 2020-08-06 | Ford | Kansas | 20057 | 2147 | 10 |
402940 | 402940 | 2020-08-05 | Ford | Kansas | 20057 | 2147 | 10 |
399723 | 399723 | 2020-08-04 | Ford | Kansas | 20057 | 2121 | 10 |
396508 | 396508 | 2020-08-03 | Ford | Kansas | 20057 | 2121 | 10 |
393292 | 393292 | 2020-08-02 | Ford | Kansas | 20057 | 2106 | 10 |
390075 | 390075 | 2020-08-01 | Ford | Kansas | 20057 | 2106 | 10 |
386858 | 386858 | 2020-07-31 | Ford | Kansas | 20057 | 2106 | 10 |
383640 | 383640 | 2020-07-30 | Ford | Kansas | 20057 | 2087 | 10 |
380423 | 380423 | 2020-07-29 | Ford | Kansas | 20057 | 2087 | 10 |
377206 | 377206 | 2020-07-28 | Ford | Kansas | 20057 | 2075 | 10 |
373991 | 373991 | 2020-07-27 | Ford | Kansas | 20057 | 2075 | 10 |
370779 | 370779 | 2020-07-26 | Ford | Kansas | 20057 | 2069 | 10 |
367569 | 367569 | 2020-07-25 | Ford | Kansas | 20057 | 2069 | 10 |
364362 | 364362 | 2020-07-24 | Ford | Kansas | 20057 | 2069 | 10 |
361155 | 361155 | 2020-07-23 | Ford | Kansas | 20057 | 2065 | 10 |
357950 | 357950 | 2020-07-22 | Ford | Kansas | 20057 | 2065 | 10 |
354748 | 354748 | 2020-07-21 | Ford | Kansas | 20057 | 2061 | 10 |
351546 | 351546 | 2020-07-20 | Ford | Kansas | 20057 | 2061 | 10 |
348346 | 348346 | 2020-07-19 | Ford | Kansas | 20057 | 2053 | 10 |
345145 | 345145 | 2020-07-18 | Ford | Kansas | 20057 | 2053 | 10 |
341945 | 341945 | 2020-07-17 | Ford | Kansas | 20057 | 2053 | 10 |
338749 | 338749 | 2020-07-16 | Ford | Kansas | 20057 | 2046 | 10 |
335553 | 335553 | 2020-07-15 | Ford | Kansas | 20057 | 2046 | 10 |
332360 | 332360 | 2020-07-14 | Ford | Kansas | 20057 | 2039 | 10 |
329173 | 329173 | 2020-07-13 | Ford | Kansas | 20057 | 2039 | 10 |
325987 | 325987 | 2020-07-12 | Ford | Kansas | 20057 | 2028 | 10 |
322805 | 322805 | 2020-07-11 | Ford | Kansas | 20057 | 2028 | 10 |
319626 | 319626 | 2020-07-10 | Ford | Kansas | 20057 | 2028 | 10 |
316453 | 316453 | 2020-07-09 | Ford | Kansas | 20057 | 2021 | 10 |
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);