ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where deaths = 42, fips = 24039 and state = "Maryland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1635903 | 1635903 | 2021-08-20 | Somerset | Maryland | 24039 | 2725 | 42 |
1632653 | 1632653 | 2021-08-19 | Somerset | Maryland | 24039 | 2723 | 42 |
1629406 | 1629406 | 2021-08-18 | Somerset | Maryland | 24039 | 2721 | 42 |
1626159 | 1626159 | 2021-08-17 | Somerset | Maryland | 24039 | 2718 | 42 |
1622912 | 1622912 | 2021-08-16 | Somerset | Maryland | 24039 | 2714 | 42 |
1619665 | 1619665 | 2021-08-15 | Somerset | Maryland | 24039 | 2711 | 42 |
1616417 | 1616417 | 2021-08-14 | Somerset | Maryland | 24039 | 2710 | 42 |
1613169 | 1613169 | 2021-08-13 | Somerset | Maryland | 24039 | 2704 | 42 |
1609920 | 1609920 | 2021-08-12 | Somerset | Maryland | 24039 | 2691 | 42 |
1606672 | 1606672 | 2021-08-11 | Somerset | Maryland | 24039 | 2688 | 42 |
1603423 | 1603423 | 2021-08-10 | Somerset | Maryland | 24039 | 2681 | 42 |
1600174 | 1600174 | 2021-08-09 | Somerset | Maryland | 24039 | 2669 | 42 |
1596926 | 1596926 | 2021-08-08 | Somerset | Maryland | 24039 | 2666 | 42 |
1593677 | 1593677 | 2021-08-07 | Somerset | Maryland | 24039 | 2665 | 42 |
1590428 | 1590428 | 2021-08-06 | Somerset | Maryland | 24039 | 2661 | 42 |
1587179 | 1587179 | 2021-08-05 | Somerset | Maryland | 24039 | 2655 | 42 |
1583928 | 1583928 | 2021-08-04 | Somerset | Maryland | 24039 | 2652 | 42 |
1580679 | 1580679 | 2021-08-03 | Somerset | Maryland | 24039 | 2646 | 42 |
1577430 | 1577430 | 2021-08-02 | Somerset | Maryland | 24039 | 2644 | 42 |
1574182 | 1574182 | 2021-08-01 | Somerset | Maryland | 24039 | 2641 | 42 |
1570934 | 1570934 | 2021-07-31 | Somerset | Maryland | 24039 | 2639 | 42 |
1567686 | 1567686 | 2021-07-30 | Somerset | Maryland | 24039 | 2637 | 42 |
1564438 | 1564438 | 2021-07-29 | Somerset | Maryland | 24039 | 2638 | 42 |
1561190 | 1561190 | 2021-07-28 | Somerset | Maryland | 24039 | 2634 | 42 |
1557942 | 1557942 | 2021-07-27 | Somerset | Maryland | 24039 | 2634 | 42 |
1554695 | 1554695 | 2021-07-26 | Somerset | Maryland | 24039 | 2633 | 42 |
1551448 | 1551448 | 2021-07-25 | Somerset | Maryland | 24039 | 2633 | 42 |
1548201 | 1548201 | 2021-07-24 | Somerset | Maryland | 24039 | 2633 | 42 |
1544954 | 1544954 | 2021-07-23 | Somerset | Maryland | 24039 | 2633 | 42 |
1541706 | 1541706 | 2021-07-22 | Somerset | Maryland | 24039 | 2632 | 42 |
1538459 | 1538459 | 2021-07-21 | Somerset | Maryland | 24039 | 2631 | 42 |
1535212 | 1535212 | 2021-07-20 | Somerset | Maryland | 24039 | 2630 | 42 |
1531964 | 1531964 | 2021-07-19 | Somerset | Maryland | 24039 | 2630 | 42 |
1528717 | 1528717 | 2021-07-18 | Somerset | Maryland | 24039 | 2628 | 42 |
1525470 | 1525470 | 2021-07-17 | Somerset | Maryland | 24039 | 2628 | 42 |
1522223 | 1522223 | 2021-07-16 | Somerset | Maryland | 24039 | 2628 | 42 |
1518974 | 1518974 | 2021-07-15 | Somerset | Maryland | 24039 | 2627 | 42 |
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);