ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 20037 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635797 | 635797 | 2020-10-16 | Crawford | Kansas | 20037 | 1326 | 8 |
632551 | 632551 | 2020-10-15 | Crawford | Kansas | 20037 | 1294 | 8 |
629307 | 629307 | 2020-10-14 | Crawford | Kansas | 20037 | 1294 | 8 |
626064 | 626064 | 2020-10-13 | Crawford | Kansas | 20037 | 1256 | 8 |
622822 | 622822 | 2020-10-12 | Crawford | Kansas | 20037 | 1256 | 8 |
619578 | 619578 | 2020-10-11 | Crawford | Kansas | 20037 | 1223 | 8 |
616336 | 616336 | 2020-10-10 | Crawford | Kansas | 20037 | 1223 | 8 |
613095 | 613095 | 2020-10-09 | Crawford | Kansas | 20037 | 1223 | 8 |
609853 | 609853 | 2020-10-08 | Crawford | Kansas | 20037 | 1191 | 8 |
606610 | 606610 | 2020-10-07 | Crawford | Kansas | 20037 | 1191 | 8 |
603368 | 603368 | 2020-10-06 | Crawford | Kansas | 20037 | 1163 | 8 |
600125 | 600125 | 2020-10-05 | Crawford | Kansas | 20037 | 1163 | 8 |
596883 | 596883 | 2020-10-04 | Crawford | Kansas | 20037 | 1128 | 8 |
593641 | 593641 | 2020-10-03 | Crawford | Kansas | 20037 | 1128 | 8 |
590400 | 590400 | 2020-10-02 | Crawford | Kansas | 20037 | 1128 | 8 |
587159 | 587159 | 2020-10-01 | Crawford | Kansas | 20037 | 1098 | 8 |
583919 | 583919 | 2020-09-30 | Crawford | Kansas | 20037 | 1098 | 8 |
580680 | 580680 | 2020-09-29 | Crawford | Kansas | 20037 | 1070 | 8 |
577439 | 577439 | 2020-09-28 | Crawford | Kansas | 20037 | 1070 | 8 |
574197 | 574197 | 2020-09-27 | Crawford | Kansas | 20037 | 1038 | 8 |
570954 | 570954 | 2020-09-26 | Crawford | Kansas | 20037 | 1038 | 6 |
567712 | 567712 | 2020-09-25 | Crawford | Kansas | 20037 | 1038 | 6 |
564472 | 564472 | 2020-09-24 | Crawford | Kansas | 20037 | 1011 | 6 |
561232 | 561232 | 2020-09-23 | Crawford | Kansas | 20037 | 1011 | 6 |
557996 | 557996 | 2020-09-22 | Crawford | Kansas | 20037 | 975 | 6 |
554759 | 554759 | 2020-09-21 | Crawford | Kansas | 20037 | 975 | 6 |
551520 | 551520 | 2020-09-20 | Crawford | Kansas | 20037 | 948 | 6 |
548281 | 548281 | 2020-09-19 | Crawford | Kansas | 20037 | 948 | 6 |
545043 | 545043 | 2020-09-18 | Crawford | Kansas | 20037 | 948 | 6 |
541807 | 541807 | 2020-09-17 | Crawford | Kansas | 20037 | 912 | 5 |
538570 | 538570 | 2020-09-16 | Crawford | Kansas | 20037 | 912 | 5 |
535334 | 535334 | 2020-09-15 | Crawford | Kansas | 20037 | 891 | 5 |
532099 | 532099 | 2020-09-14 | Crawford | Kansas | 20037 | 891 | 5 |
528862 | 528862 | 2020-09-13 | Crawford | Kansas | 20037 | 855 | 5 |
525626 | 525626 | 2020-09-12 | Crawford | Kansas | 20037 | 855 | 5 |
522390 | 522390 | 2020-09-11 | Crawford | Kansas | 20037 | 855 | 5 |
519153 | 519153 | 2020-09-10 | Crawford | Kansas | 20037 | 816 | 4 |
515918 | 515918 | 2020-09-09 | Crawford | Kansas | 20037 | 816 | 4 |
512685 | 512685 | 2020-09-08 | Crawford | Kansas | 20037 | 800 | 4 |
509452 | 509452 | 2020-09-07 | Crawford | Kansas | 20037 | 800 | 4 |
506220 | 506220 | 2020-09-06 | Crawford | Kansas | 20037 | 766 | 4 |
502986 | 502986 | 2020-09-05 | Crawford | Kansas | 20037 | 766 | 4 |
499752 | 499752 | 2020-09-04 | Crawford | Kansas | 20037 | 766 | 1 |
496519 | 496519 | 2020-09-03 | Crawford | Kansas | 20037 | 686 | 1 |
493285 | 493285 | 2020-09-02 | Crawford | Kansas | 20037 | 686 | 1 |
490052 | 490052 | 2020-09-01 | Crawford | Kansas | 20037 | 599 | 1 |
486819 | 486819 | 2020-08-31 | Crawford | Kansas | 20037 | 599 | 1 |
483584 | 483584 | 2020-08-30 | Crawford | Kansas | 20037 | 515 | 1 |
480350 | 480350 | 2020-08-29 | Crawford | Kansas | 20037 | 515 | 1 |
477117 | 477117 | 2020-08-28 | Crawford | Kansas | 20037 | 515 | 1 |
473884 | 473884 | 2020-08-27 | Crawford | Kansas | 20037 | 478 | 1 |
470652 | 470652 | 2020-08-26 | Crawford | Kansas | 20037 | 478 | 1 |
467423 | 467423 | 2020-08-25 | Crawford | Kansas | 20037 | 443 | 1 |
464194 | 464194 | 2020-08-24 | Crawford | Kansas | 20037 | 443 | 1 |
460965 | 460965 | 2020-08-23 | Crawford | Kansas | 20037 | 431 | 1 |
457738 | 457738 | 2020-08-22 | Crawford | Kansas | 20037 | 431 | 1 |
454510 | 454510 | 2020-08-21 | Crawford | Kansas | 20037 | 431 | 1 |
451282 | 451282 | 2020-08-20 | Crawford | Kansas | 20037 | 423 | 1 |
448054 | 448054 | 2020-08-19 | Crawford | Kansas | 20037 | 423 | 1 |
444827 | 444827 | 2020-08-18 | Crawford | Kansas | 20037 | 418 | 1 |
441601 | 441601 | 2020-08-17 | Crawford | Kansas | 20037 | 418 | 1 |
438374 | 438374 | 2020-08-16 | Crawford | Kansas | 20037 | 415 | 1 |
435149 | 435149 | 2020-08-15 | Crawford | Kansas | 20037 | 415 | 1 |
431924 | 431924 | 2020-08-14 | Crawford | Kansas | 20037 | 415 | 1 |
428696 | 428696 | 2020-08-13 | Crawford | Kansas | 20037 | 405 | 1 |
425472 | 425472 | 2020-08-12 | Crawford | Kansas | 20037 | 405 | 1 |
422251 | 422251 | 2020-08-11 | Crawford | Kansas | 20037 | 401 | 1 |
419028 | 419028 | 2020-08-10 | Crawford | Kansas | 20037 | 401 | 1 |
415807 | 415807 | 2020-08-09 | Crawford | Kansas | 20037 | 395 | 1 |
412587 | 412587 | 2020-08-08 | Crawford | Kansas | 20037 | 395 | 1 |
409367 | 409367 | 2020-08-07 | Crawford | Kansas | 20037 | 395 | 1 |
406148 | 406148 | 2020-08-06 | Crawford | Kansas | 20037 | 392 | 1 |
402930 | 402930 | 2020-08-05 | Crawford | Kansas | 20037 | 392 | 1 |
399713 | 399713 | 2020-08-04 | Crawford | Kansas | 20037 | 391 | 1 |
396498 | 396498 | 2020-08-03 | Crawford | Kansas | 20037 | 391 | 1 |
393282 | 393282 | 2020-08-02 | Crawford | Kansas | 20037 | 380 | 1 |
390065 | 390065 | 2020-08-01 | Crawford | Kansas | 20037 | 380 | 1 |
386848 | 386848 | 2020-07-31 | Crawford | Kansas | 20037 | 380 | 1 |
383630 | 383630 | 2020-07-30 | Crawford | Kansas | 20037 | 375 | 1 |
380413 | 380413 | 2020-07-29 | Crawford | Kansas | 20037 | 375 | 1 |
377196 | 377196 | 2020-07-28 | Crawford | Kansas | 20037 | 373 | 1 |
373981 | 373981 | 2020-07-27 | Crawford | Kansas | 20037 | 373 | 1 |
370769 | 370769 | 2020-07-26 | Crawford | Kansas | 20037 | 367 | 1 |
367559 | 367559 | 2020-07-25 | Crawford | Kansas | 20037 | 367 | 1 |
364352 | 364352 | 2020-07-24 | Crawford | Kansas | 20037 | 367 | 1 |
361145 | 361145 | 2020-07-23 | Crawford | Kansas | 20037 | 360 | 1 |
357940 | 357940 | 2020-07-22 | Crawford | Kansas | 20037 | 360 | 1 |
354738 | 354738 | 2020-07-21 | Crawford | Kansas | 20037 | 351 | 1 |
351536 | 351536 | 2020-07-20 | Crawford | Kansas | 20037 | 351 | 1 |
348336 | 348336 | 2020-07-19 | Crawford | Kansas | 20037 | 332 | 1 |
345135 | 345135 | 2020-07-18 | Crawford | Kansas | 20037 | 332 | 1 |
341935 | 341935 | 2020-07-17 | Crawford | Kansas | 20037 | 332 | 1 |
338739 | 338739 | 2020-07-16 | Crawford | Kansas | 20037 | 328 | 1 |
335543 | 335543 | 2020-07-15 | Crawford | Kansas | 20037 | 328 | 1 |
332350 | 332350 | 2020-07-14 | Crawford | Kansas | 20037 | 316 | 1 |
329163 | 329163 | 2020-07-13 | Crawford | Kansas | 20037 | 316 | 1 |
325977 | 325977 | 2020-07-12 | Crawford | Kansas | 20037 | 301 | 1 |
322796 | 322796 | 2020-07-11 | Crawford | Kansas | 20037 | 301 | 1 |
319617 | 319617 | 2020-07-10 | Crawford | Kansas | 20037 | 301 | 1 |
316444 | 316444 | 2020-07-09 | Crawford | Kansas | 20037 | 294 | 1 |
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);