ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where county = "Lincoln", deaths = 1 and fips = 56023 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
625141 | 625141 | 2020-10-12 | Lincoln | Wyoming | 56023 | 282 | 1 |
621898 | 621898 | 2020-10-11 | Lincoln | Wyoming | 56023 | 274 | 1 |
618655 | 618655 | 2020-10-10 | Lincoln | Wyoming | 56023 | 262 | 1 |
615413 | 615413 | 2020-10-09 | Lincoln | Wyoming | 56023 | 260 | 1 |
612172 | 612172 | 2020-10-08 | Lincoln | Wyoming | 56023 | 254 | 1 |
608930 | 608930 | 2020-10-07 | Lincoln | Wyoming | 56023 | 246 | 1 |
605687 | 605687 | 2020-10-06 | Lincoln | Wyoming | 56023 | 242 | 1 |
602445 | 602445 | 2020-10-05 | Lincoln | Wyoming | 56023 | 233 | 1 |
599202 | 599202 | 2020-10-04 | Lincoln | Wyoming | 56023 | 229 | 1 |
595959 | 595959 | 2020-10-03 | Lincoln | Wyoming | 56023 | 226 | 1 |
592717 | 592717 | 2020-10-02 | Lincoln | Wyoming | 56023 | 222 | 1 |
589477 | 589477 | 2020-10-01 | Lincoln | Wyoming | 56023 | 216 | 1 |
586236 | 586236 | 2020-09-30 | Lincoln | Wyoming | 56023 | 208 | 1 |
582996 | 582996 | 2020-09-29 | Lincoln | Wyoming | 56023 | 196 | 1 |
579757 | 579757 | 2020-09-28 | Lincoln | Wyoming | 56023 | 187 | 1 |
576516 | 576516 | 2020-09-27 | Lincoln | Wyoming | 56023 | 177 | 1 |
573272 | 573272 | 2020-09-26 | Lincoln | Wyoming | 56023 | 170 | 1 |
570030 | 570030 | 2020-09-25 | Lincoln | Wyoming | 56023 | 170 | 1 |
566789 | 566789 | 2020-09-24 | Lincoln | Wyoming | 56023 | 166 | 1 |
563548 | 563548 | 2020-09-23 | Lincoln | Wyoming | 56023 | 160 | 1 |
560309 | 560309 | 2020-09-22 | Lincoln | Wyoming | 56023 | 144 | 1 |
557073 | 557073 | 2020-09-21 | Lincoln | Wyoming | 56023 | 142 | 1 |
553836 | 553836 | 2020-09-20 | Lincoln | Wyoming | 56023 | 142 | 1 |
550597 | 550597 | 2020-09-19 | Lincoln | Wyoming | 56023 | 136 | 1 |
547358 | 547358 | 2020-09-18 | Lincoln | Wyoming | 56023 | 135 | 1 |
544121 | 544121 | 2020-09-17 | Lincoln | Wyoming | 56023 | 131 | 1 |
540885 | 540885 | 2020-09-16 | Lincoln | Wyoming | 56023 | 127 | 1 |
537648 | 537648 | 2020-09-15 | Lincoln | Wyoming | 56023 | 124 | 1 |
534412 | 534412 | 2020-09-14 | Lincoln | Wyoming | 56023 | 123 | 1 |
531177 | 531177 | 2020-09-13 | Lincoln | Wyoming | 56023 | 124 | 1 |
527940 | 527940 | 2020-09-12 | Lincoln | Wyoming | 56023 | 123 | 1 |
524704 | 524704 | 2020-09-11 | Lincoln | Wyoming | 56023 | 123 | 1 |
521468 | 521468 | 2020-09-10 | Lincoln | Wyoming | 56023 | 121 | 1 |
518231 | 518231 | 2020-09-09 | Lincoln | Wyoming | 56023 | 120 | 1 |
514996 | 514996 | 2020-09-08 | Lincoln | Wyoming | 56023 | 118 | 1 |
511763 | 511763 | 2020-09-07 | Lincoln | Wyoming | 56023 | 117 | 1 |
508530 | 508530 | 2020-09-06 | Lincoln | Wyoming | 56023 | 117 | 1 |
505298 | 505298 | 2020-09-05 | Lincoln | Wyoming | 56023 | 116 | 1 |
502064 | 502064 | 2020-09-04 | Lincoln | Wyoming | 56023 | 116 | 1 |
498830 | 498830 | 2020-09-03 | Lincoln | Wyoming | 56023 | 115 | 1 |
495597 | 495597 | 2020-09-02 | Lincoln | Wyoming | 56023 | 114 | 1 |
492363 | 492363 | 2020-09-01 | Lincoln | Wyoming | 56023 | 114 | 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);