ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
669 rows where county = "Sedgwick" and fips = 8115 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 |
---|---|---|---|---|---|---|---|
331743 | 331743 | 2020-07-14 | Sedgwick | Colorado | 8115 | 2 | 0 |
334936 | 334936 | 2020-07-15 | Sedgwick | Colorado | 8115 | 3 | 0 |
338131 | 338131 | 2020-07-16 | Sedgwick | Colorado | 8115 | 4 | 0 |
341328 | 341328 | 2020-07-17 | Sedgwick | Colorado | 8115 | 5 | 0 |
344527 | 344527 | 2020-07-18 | Sedgwick | Colorado | 8115 | 5 | 0 |
347727 | 347727 | 2020-07-19 | Sedgwick | Colorado | 8115 | 8 | 0 |
350928 | 350928 | 2020-07-20 | Sedgwick | Colorado | 8115 | 10 | 0 |
354130 | 354130 | 2020-07-21 | Sedgwick | Colorado | 8115 | 11 | 0 |
357333 | 357333 | 2020-07-22 | Sedgwick | Colorado | 8115 | 11 | 0 |
360538 | 360538 | 2020-07-23 | Sedgwick | Colorado | 8115 | 11 | 0 |
363745 | 363745 | 2020-07-24 | Sedgwick | Colorado | 8115 | 11 | 0 |
366952 | 366952 | 2020-07-25 | Sedgwick | Colorado | 8115 | 11 | 0 |
370162 | 370162 | 2020-07-26 | Sedgwick | Colorado | 8115 | 11 | 0 |
373374 | 373374 | 2020-07-27 | Sedgwick | Colorado | 8115 | 11 | 0 |
376588 | 376588 | 2020-07-28 | Sedgwick | Colorado | 8115 | 11 | 0 |
379805 | 379805 | 2020-07-29 | Sedgwick | Colorado | 8115 | 11 | 1 |
383022 | 383022 | 2020-07-30 | Sedgwick | Colorado | 8115 | 11 | 1 |
386240 | 386240 | 2020-07-31 | Sedgwick | Colorado | 8115 | 11 | 1 |
389457 | 389457 | 2020-08-01 | Sedgwick | Colorado | 8115 | 11 | 1 |
392674 | 392674 | 2020-08-02 | Sedgwick | Colorado | 8115 | 11 | 1 |
395890 | 395890 | 2020-08-03 | Sedgwick | Colorado | 8115 | 11 | 1 |
399106 | 399106 | 2020-08-04 | Sedgwick | Colorado | 8115 | 11 | 1 |
402322 | 402322 | 2020-08-05 | Sedgwick | Colorado | 8115 | 11 | 1 |
405540 | 405540 | 2020-08-06 | Sedgwick | Colorado | 8115 | 11 | 1 |
408760 | 408760 | 2020-08-07 | Sedgwick | Colorado | 8115 | 11 | 1 |
411979 | 411979 | 2020-08-08 | Sedgwick | Colorado | 8115 | 11 | 1 |
415199 | 415199 | 2020-08-09 | Sedgwick | Colorado | 8115 | 11 | 1 |
418420 | 418420 | 2020-08-10 | Sedgwick | Colorado | 8115 | 11 | 1 |
421641 | 421641 | 2020-08-11 | Sedgwick | Colorado | 8115 | 11 | 1 |
424862 | 424862 | 2020-08-12 | Sedgwick | Colorado | 8115 | 11 | 1 |
428086 | 428086 | 2020-08-13 | Sedgwick | Colorado | 8115 | 11 | 1 |
431314 | 431314 | 2020-08-14 | Sedgwick | Colorado | 8115 | 11 | 1 |
434539 | 434539 | 2020-08-15 | Sedgwick | Colorado | 8115 | 11 | 1 |
437765 | 437765 | 2020-08-16 | Sedgwick | Colorado | 8115 | 11 | 1 |
440991 | 440991 | 2020-08-17 | Sedgwick | Colorado | 8115 | 11 | 1 |
444217 | 444217 | 2020-08-18 | Sedgwick | Colorado | 8115 | 11 | 1 |
447444 | 447444 | 2020-08-19 | Sedgwick | Colorado | 8115 | 11 | 1 |
450672 | 450672 | 2020-08-20 | Sedgwick | Colorado | 8115 | 11 | 1 |
453900 | 453900 | 2020-08-21 | Sedgwick | Colorado | 8115 | 12 | 1 |
457128 | 457128 | 2020-08-22 | Sedgwick | Colorado | 8115 | 12 | 1 |
460355 | 460355 | 2020-08-23 | Sedgwick | Colorado | 8115 | 12 | 1 |
463584 | 463584 | 2020-08-24 | Sedgwick | Colorado | 8115 | 12 | 1 |
466813 | 466813 | 2020-08-25 | Sedgwick | Colorado | 8115 | 12 | 1 |
470042 | 470042 | 2020-08-26 | Sedgwick | Colorado | 8115 | 12 | 1 |
473274 | 473274 | 2020-08-27 | Sedgwick | Colorado | 8115 | 12 | 1 |
476507 | 476507 | 2020-08-28 | Sedgwick | Colorado | 8115 | 12 | 1 |
479740 | 479740 | 2020-08-29 | Sedgwick | Colorado | 8115 | 12 | 1 |
482974 | 482974 | 2020-08-30 | Sedgwick | Colorado | 8115 | 12 | 1 |
486209 | 486209 | 2020-08-31 | Sedgwick | Colorado | 8115 | 12 | 1 |
489442 | 489442 | 2020-09-01 | Sedgwick | Colorado | 8115 | 12 | 1 |
492675 | 492675 | 2020-09-02 | Sedgwick | Colorado | 8115 | 12 | 1 |
495909 | 495909 | 2020-09-03 | Sedgwick | Colorado | 8115 | 12 | 1 |
499142 | 499142 | 2020-09-04 | Sedgwick | Colorado | 8115 | 12 | 1 |
502376 | 502376 | 2020-09-05 | Sedgwick | Colorado | 8115 | 12 | 1 |
505610 | 505610 | 2020-09-06 | Sedgwick | Colorado | 8115 | 12 | 1 |
508842 | 508842 | 2020-09-07 | Sedgwick | Colorado | 8115 | 12 | 1 |
512075 | 512075 | 2020-09-08 | Sedgwick | Colorado | 8115 | 12 | 1 |
515308 | 515308 | 2020-09-09 | Sedgwick | Colorado | 8115 | 12 | 1 |
518543 | 518543 | 2020-09-10 | Sedgwick | Colorado | 8115 | 12 | 1 |
521780 | 521780 | 2020-09-11 | Sedgwick | Colorado | 8115 | 12 | 1 |
525016 | 525016 | 2020-09-12 | Sedgwick | Colorado | 8115 | 12 | 1 |
528252 | 528252 | 2020-09-13 | Sedgwick | Colorado | 8115 | 12 | 1 |
531489 | 531489 | 2020-09-14 | Sedgwick | Colorado | 8115 | 12 | 1 |
534724 | 534724 | 2020-09-15 | Sedgwick | Colorado | 8115 | 12 | 1 |
537960 | 537960 | 2020-09-16 | Sedgwick | Colorado | 8115 | 12 | 1 |
541197 | 541197 | 2020-09-17 | Sedgwick | Colorado | 8115 | 12 | 1 |
544433 | 544433 | 2020-09-18 | Sedgwick | Colorado | 8115 | 12 | 1 |
547671 | 547671 | 2020-09-19 | Sedgwick | Colorado | 8115 | 12 | 1 |
550910 | 550910 | 2020-09-20 | Sedgwick | Colorado | 8115 | 12 | 1 |
554149 | 554149 | 2020-09-21 | Sedgwick | Colorado | 8115 | 12 | 1 |
557386 | 557386 | 2020-09-22 | Sedgwick | Colorado | 8115 | 12 | 1 |
560622 | 560622 | 2020-09-23 | Sedgwick | Colorado | 8115 | 14 | 1 |
563862 | 563862 | 2020-09-24 | Sedgwick | Colorado | 8115 | 14 | 1 |
567102 | 567102 | 2020-09-25 | Sedgwick | Colorado | 8115 | 15 | 1 |
570344 | 570344 | 2020-09-26 | Sedgwick | Colorado | 8115 | 15 | 1 |
573586 | 573586 | 2020-09-27 | Sedgwick | Colorado | 8115 | 15 | 1 |
576829 | 576829 | 2020-09-28 | Sedgwick | Colorado | 8115 | 15 | 1 |
580070 | 580070 | 2020-09-29 | Sedgwick | Colorado | 8115 | 15 | 1 |
583309 | 583309 | 2020-09-30 | Sedgwick | Colorado | 8115 | 15 | 1 |
586549 | 586549 | 2020-10-01 | Sedgwick | Colorado | 8115 | 15 | 1 |
589790 | 589790 | 2020-10-02 | Sedgwick | Colorado | 8115 | 15 | 1 |
593030 | 593030 | 2020-10-03 | Sedgwick | Colorado | 8115 | 15 | 1 |
596272 | 596272 | 2020-10-04 | Sedgwick | Colorado | 8115 | 15 | 1 |
599515 | 599515 | 2020-10-05 | Sedgwick | Colorado | 8115 | 15 | 1 |
602758 | 602758 | 2020-10-06 | Sedgwick | Colorado | 8115 | 15 | 1 |
606000 | 606000 | 2020-10-07 | Sedgwick | Colorado | 8115 | 15 | 1 |
609243 | 609243 | 2020-10-08 | Sedgwick | Colorado | 8115 | 15 | 1 |
612485 | 612485 | 2020-10-09 | Sedgwick | Colorado | 8115 | 15 | 1 |
615726 | 615726 | 2020-10-10 | Sedgwick | Colorado | 8115 | 15 | 1 |
618968 | 618968 | 2020-10-11 | Sedgwick | Colorado | 8115 | 15 | 1 |
622211 | 622211 | 2020-10-12 | Sedgwick | Colorado | 8115 | 16 | 1 |
625454 | 625454 | 2020-10-13 | Sedgwick | Colorado | 8115 | 16 | 1 |
628697 | 628697 | 2020-10-14 | Sedgwick | Colorado | 8115 | 16 | 1 |
631941 | 631941 | 2020-10-15 | Sedgwick | Colorado | 8115 | 16 | 1 |
635187 | 635187 | 2020-10-16 | Sedgwick | Colorado | 8115 | 16 | 1 |
638432 | 638432 | 2020-10-17 | Sedgwick | Colorado | 8115 | 22 | 1 |
641679 | 641679 | 2020-10-18 | Sedgwick | Colorado | 8115 | 25 | 1 |
644927 | 644927 | 2020-10-19 | Sedgwick | Colorado | 8115 | 26 | 1 |
648172 | 648172 | 2020-10-20 | Sedgwick | Colorado | 8115 | 33 | 1 |
651416 | 651416 | 2020-10-21 | Sedgwick | Colorado | 8115 | 34 | 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);