ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,455 rows where county = "Sedgwick" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
4664 | 4664 | 2020-03-19 | Sedgwick | Kansas | 20173 | 1 | 0 |
5477 | 5477 | 2020-03-20 | Sedgwick | Kansas | 20173 | 1 | 0 |
6422 | 6422 | 2020-03-21 | Sedgwick | Kansas | 20173 | 2 | 0 |
7491 | 7491 | 2020-03-22 | Sedgwick | Kansas | 20173 | 2 | 0 |
8653 | 8653 | 2020-03-23 | Sedgwick | Kansas | 20173 | 2 | 0 |
9935 | 9935 | 2020-03-24 | Sedgwick | Kansas | 20173 | 7 | 0 |
11334 | 11334 | 2020-03-25 | Sedgwick | Kansas | 20173 | 11 | 0 |
12902 | 12902 | 2020-03-26 | Sedgwick | Kansas | 20173 | 16 | 0 |
14605 | 14605 | 2020-03-27 | Sedgwick | Kansas | 20173 | 20 | 0 |
16413 | 16413 | 2020-03-28 | Sedgwick | Kansas | 20173 | 33 | 0 |
18320 | 18320 | 2020-03-29 | Sedgwick | Kansas | 20173 | 42 | 0 |
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 |
20334 | 20334 | 2020-03-30 | Sedgwick | Kansas | 20173 | 49 | 1 |
22433 | 22433 | 2020-03-31 | Sedgwick | Kansas | 20173 | 58 | 1 |
24609 | 24609 | 2020-04-01 | Sedgwick | Kansas | 20173 | 64 | 1 |
26853 | 26853 | 2020-04-02 | Sedgwick | Kansas | 20173 | 79 | 1 |
29169 | 29169 | 2020-04-03 | Sedgwick | Kansas | 20173 | 85 | 1 |
31543 | 31543 | 2020-04-04 | Sedgwick | Kansas | 20173 | 97 | 1 |
33958 | 33958 | 2020-04-05 | Sedgwick | Kansas | 20173 | 108 | 1 |
36416 | 36416 | 2020-04-06 | Sedgwick | Kansas | 20173 | 124 | 1 |
38920 | 38920 | 2020-04-07 | Sedgwick | Kansas | 20173 | 134 | 1 |
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 |
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);