ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where county = "Lawrence", deaths = 216 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1546034 | 1546034 | 2021-07-23 | Lawrence | Pennsylvania | 42073 | 7759 | 216 |
1542787 | 1542787 | 2021-07-22 | Lawrence | Pennsylvania | 42073 | 7756 | 216 |
1539539 | 1539539 | 2021-07-21 | Lawrence | Pennsylvania | 42073 | 7752 | 216 |
1536292 | 1536292 | 2021-07-20 | Lawrence | Pennsylvania | 42073 | 7746 | 216 |
1533044 | 1533044 | 2021-07-19 | Lawrence | Pennsylvania | 42073 | 7737 | 216 |
1529797 | 1529797 | 2021-07-18 | Lawrence | Pennsylvania | 42073 | 7735 | 216 |
1526550 | 1526550 | 2021-07-17 | Lawrence | Pennsylvania | 42073 | 7735 | 216 |
1523303 | 1523303 | 2021-07-16 | Lawrence | Pennsylvania | 42073 | 7728 | 216 |
1520055 | 1520055 | 2021-07-15 | Lawrence | Pennsylvania | 42073 | 7723 | 216 |
1516807 | 1516807 | 2021-07-14 | Lawrence | Pennsylvania | 42073 | 7719 | 216 |
1513560 | 1513560 | 2021-07-13 | Lawrence | Pennsylvania | 42073 | 7717 | 216 |
1510314 | 1510314 | 2021-07-12 | Lawrence | Pennsylvania | 42073 | 7712 | 216 |
1507067 | 1507067 | 2021-07-11 | Lawrence | Pennsylvania | 42073 | 7711 | 216 |
1503821 | 1503821 | 2021-07-10 | Lawrence | Pennsylvania | 42073 | 7711 | 216 |
1500575 | 1500575 | 2021-07-09 | Lawrence | Pennsylvania | 42073 | 7710 | 216 |
1497329 | 1497329 | 2021-07-08 | Lawrence | Pennsylvania | 42073 | 7708 | 216 |
1494082 | 1494082 | 2021-07-07 | Lawrence | Pennsylvania | 42073 | 7704 | 216 |
1490835 | 1490835 | 2021-07-06 | Lawrence | Pennsylvania | 42073 | 7703 | 216 |
1487588 | 1487588 | 2021-07-05 | Lawrence | Pennsylvania | 42073 | 7701 | 216 |
1484341 | 1484341 | 2021-07-04 | Lawrence | Pennsylvania | 42073 | 7700 | 216 |
1481095 | 1481095 | 2021-07-03 | Lawrence | Pennsylvania | 42073 | 7699 | 216 |
1477848 | 1477848 | 2021-07-02 | Lawrence | Pennsylvania | 42073 | 7695 | 216 |
1474602 | 1474602 | 2021-07-01 | Lawrence | Pennsylvania | 42073 | 7693 | 216 |
1471356 | 1471356 | 2021-06-30 | Lawrence | Pennsylvania | 42073 | 7691 | 216 |
1468111 | 1468111 | 2021-06-29 | Lawrence | Pennsylvania | 42073 | 7688 | 216 |
1464866 | 1464866 | 2021-06-28 | Lawrence | Pennsylvania | 42073 | 7682 | 216 |
1461621 | 1461621 | 2021-06-27 | Lawrence | Pennsylvania | 42073 | 7683 | 216 |
1458376 | 1458376 | 2021-06-26 | Lawrence | Pennsylvania | 42073 | 7680 | 216 |
1455131 | 1455131 | 2021-06-25 | Lawrence | Pennsylvania | 42073 | 7676 | 216 |
1451886 | 1451886 | 2021-06-24 | Lawrence | Pennsylvania | 42073 | 7673 | 216 |
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);