ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where county = "Lawrence", deaths = 8, fips = 17101 and state = "Illinois" 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 |
---|---|---|---|---|---|---|---|
742590 | 742590 | 2020-11-18 | Lawrence | Illinois | 17101 | 665 | 8 |
739343 | 739343 | 2020-11-17 | Lawrence | Illinois | 17101 | 634 | 8 |
736099 | 736099 | 2020-11-16 | Lawrence | Illinois | 17101 | 608 | 8 |
732853 | 732853 | 2020-11-15 | Lawrence | Illinois | 17101 | 586 | 8 |
729608 | 729608 | 2020-11-14 | Lawrence | Illinois | 17101 | 577 | 8 |
726365 | 726365 | 2020-11-13 | Lawrence | Illinois | 17101 | 563 | 8 |
723122 | 723122 | 2020-11-12 | Lawrence | Illinois | 17101 | 534 | 8 |
719879 | 719879 | 2020-11-11 | Lawrence | Illinois | 17101 | 530 | 8 |
716636 | 716636 | 2020-11-10 | Lawrence | Illinois | 17101 | 501 | 8 |
713392 | 713392 | 2020-11-09 | Lawrence | Illinois | 17101 | 458 | 8 |
710148 | 710148 | 2020-11-08 | Lawrence | Illinois | 17101 | 454 | 8 |
706904 | 706904 | 2020-11-07 | Lawrence | Illinois | 17101 | 437 | 8 |
703661 | 703661 | 2020-11-06 | Lawrence | Illinois | 17101 | 418 | 8 |
700418 | 700418 | 2020-11-05 | Lawrence | Illinois | 17101 | 403 | 8 |
697174 | 697174 | 2020-11-04 | Lawrence | Illinois | 17101 | 393 | 8 |
693932 | 693932 | 2020-11-03 | Lawrence | Illinois | 17101 | 385 | 8 |
690689 | 690689 | 2020-11-02 | Lawrence | Illinois | 17101 | 381 | 8 |
687444 | 687444 | 2020-11-01 | Lawrence | Illinois | 17101 | 379 | 8 |
684200 | 684200 | 2020-10-31 | Lawrence | Illinois | 17101 | 362 | 8 |
680957 | 680957 | 2020-10-30 | Lawrence | Illinois | 17101 | 362 | 8 |
677714 | 677714 | 2020-10-29 | Lawrence | Illinois | 17101 | 355 | 8 |
674471 | 674471 | 2020-10-28 | Lawrence | Illinois | 17101 | 351 | 8 |
671229 | 671229 | 2020-10-27 | Lawrence | Illinois | 17101 | 338 | 8 |
667986 | 667986 | 2020-10-26 | Lawrence | Illinois | 17101 | 336 | 8 |
664742 | 664742 | 2020-10-25 | Lawrence | Illinois | 17101 | 333 | 8 |
661497 | 661497 | 2020-10-24 | Lawrence | Illinois | 17101 | 332 | 8 |
658253 | 658253 | 2020-10-23 | Lawrence | Illinois | 17101 | 324 | 8 |
655008 | 655008 | 2020-10-22 | Lawrence | Illinois | 17101 | 323 | 8 |
651763 | 651763 | 2020-10-21 | Lawrence | Illinois | 17101 | 317 | 8 |
648519 | 648519 | 2020-10-20 | Lawrence | Illinois | 17101 | 306 | 8 |
645274 | 645274 | 2020-10-19 | Lawrence | Illinois | 17101 | 306 | 8 |
642027 | 642027 | 2020-10-18 | Lawrence | Illinois | 17101 | 306 | 8 |
638780 | 638780 | 2020-10-17 | Lawrence | Illinois | 17101 | 304 | 8 |
635534 | 635534 | 2020-10-16 | Lawrence | Illinois | 17101 | 302 | 8 |
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);