ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where county = "Caroline", deaths = 30 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 |
---|---|---|---|---|---|---|---|
1603410 | 1603410 | 2021-08-10 | Caroline | Maryland | 24011 | 2404 | 30 |
1600161 | 1600161 | 2021-08-09 | Caroline | Maryland | 24011 | 2404 | 30 |
1596913 | 1596913 | 2021-08-08 | Caroline | Maryland | 24011 | 2403 | 30 |
1593664 | 1593664 | 2021-08-07 | Caroline | Maryland | 24011 | 2395 | 30 |
1590415 | 1590415 | 2021-08-06 | Caroline | Maryland | 24011 | 2393 | 30 |
1587166 | 1587166 | 2021-08-05 | Caroline | Maryland | 24011 | 2388 | 30 |
1583915 | 1583915 | 2021-08-04 | Caroline | Maryland | 24011 | 2386 | 30 |
1580666 | 1580666 | 2021-08-03 | Caroline | Maryland | 24011 | 2384 | 30 |
1577417 | 1577417 | 2021-08-02 | Caroline | Maryland | 24011 | 2384 | 30 |
1574169 | 1574169 | 2021-08-01 | Caroline | Maryland | 24011 | 2378 | 30 |
1570921 | 1570921 | 2021-07-31 | Caroline | Maryland | 24011 | 2377 | 30 |
1567673 | 1567673 | 2021-07-30 | Caroline | Maryland | 24011 | 2376 | 30 |
1564425 | 1564425 | 2021-07-29 | Caroline | Maryland | 24011 | 2373 | 30 |
1561177 | 1561177 | 2021-07-28 | Caroline | Maryland | 24011 | 2367 | 30 |
1557929 | 1557929 | 2021-07-27 | Caroline | Maryland | 24011 | 2365 | 30 |
1554682 | 1554682 | 2021-07-26 | Caroline | Maryland | 24011 | 2365 | 30 |
1551435 | 1551435 | 2021-07-25 | Caroline | Maryland | 24011 | 2365 | 30 |
1548188 | 1548188 | 2021-07-24 | Caroline | Maryland | 24011 | 2363 | 30 |
1544941 | 1544941 | 2021-07-23 | Caroline | Maryland | 24011 | 2363 | 30 |
1541693 | 1541693 | 2021-07-22 | Caroline | Maryland | 24011 | 2363 | 30 |
1538446 | 1538446 | 2021-07-21 | Caroline | Maryland | 24011 | 2361 | 30 |
1535199 | 1535199 | 2021-07-20 | Caroline | Maryland | 24011 | 2360 | 30 |
1531951 | 1531951 | 2021-07-19 | Caroline | Maryland | 24011 | 2360 | 30 |
1528704 | 1528704 | 2021-07-18 | Caroline | Maryland | 24011 | 2359 | 30 |
1525457 | 1525457 | 2021-07-17 | Caroline | Maryland | 24011 | 2359 | 30 |
1522210 | 1522210 | 2021-07-16 | Caroline | Maryland | 24011 | 2359 | 30 |
1518961 | 1518961 | 2021-07-15 | Caroline | Maryland | 24011 | 2358 | 30 |
1515714 | 1515714 | 2021-07-14 | Caroline | Maryland | 24011 | 2357 | 30 |
1512468 | 1512468 | 2021-07-13 | Caroline | Maryland | 24011 | 2356 | 30 |
1509221 | 1509221 | 2021-07-12 | Caroline | Maryland | 24011 | 2354 | 30 |
1505975 | 1505975 | 2021-07-11 | Caroline | Maryland | 24011 | 2354 | 30 |
1502729 | 1502729 | 2021-07-10 | Caroline | Maryland | 24011 | 2353 | 30 |
1499483 | 1499483 | 2021-07-09 | Caroline | Maryland | 24011 | 2353 | 30 |
1496237 | 1496237 | 2021-07-08 | Caroline | Maryland | 24011 | 2352 | 30 |
1492990 | 1492990 | 2021-07-07 | Caroline | Maryland | 24011 | 2352 | 30 |
1489743 | 1489743 | 2021-07-06 | Caroline | Maryland | 24011 | 2352 | 30 |
1486496 | 1486496 | 2021-07-05 | Caroline | Maryland | 24011 | 2352 | 30 |
1483250 | 1483250 | 2021-07-04 | Caroline | Maryland | 24011 | 2352 | 30 |
1480004 | 1480004 | 2021-07-03 | Caroline | Maryland | 24011 | 2352 | 30 |
1476757 | 1476757 | 2021-07-02 | Caroline | Maryland | 24011 | 2352 | 30 |
1473511 | 1473511 | 2021-07-01 | Caroline | Maryland | 24011 | 2352 | 30 |
1470265 | 1470265 | 2021-06-30 | Caroline | Maryland | 24011 | 2352 | 30 |
1467020 | 1467020 | 2021-06-29 | Caroline | Maryland | 24011 | 2352 | 30 |
1463775 | 1463775 | 2021-06-28 | Caroline | Maryland | 24011 | 2352 | 30 |
1460530 | 1460530 | 2021-06-27 | Caroline | Maryland | 24011 | 2351 | 30 |
1457285 | 1457285 | 2021-06-26 | Caroline | Maryland | 24011 | 2351 | 30 |
1454040 | 1454040 | 2021-06-25 | Caroline | Maryland | 24011 | 2350 | 30 |
1450795 | 1450795 | 2021-06-24 | Caroline | Maryland | 24011 | 2350 | 30 |
1447549 | 1447549 | 2021-06-23 | Caroline | Maryland | 24011 | 2350 | 30 |
1444304 | 1444304 | 2021-06-22 | Caroline | Maryland | 24011 | 2350 | 30 |
1441059 | 1441059 | 2021-06-21 | Caroline | Maryland | 24011 | 2350 | 30 |
1437813 | 1437813 | 2021-06-20 | Caroline | Maryland | 24011 | 2350 | 30 |
1434566 | 1434566 | 2021-06-19 | Caroline | Maryland | 24011 | 2350 | 30 |
1431319 | 1431319 | 2021-06-18 | Caroline | Maryland | 24011 | 2350 | 30 |
1428074 | 1428074 | 2021-06-17 | Caroline | Maryland | 24011 | 2350 | 30 |
1424829 | 1424829 | 2021-06-16 | Caroline | Maryland | 24011 | 2350 | 30 |
1421581 | 1421581 | 2021-06-15 | Caroline | Maryland | 24011 | 2349 | 30 |
1418336 | 1418336 | 2021-06-14 | Caroline | Maryland | 24011 | 2349 | 30 |
1415091 | 1415091 | 2021-06-13 | Caroline | Maryland | 24011 | 2349 | 30 |
1411845 | 1411845 | 2021-06-12 | Caroline | Maryland | 24011 | 2349 | 30 |
1408600 | 1408600 | 2021-06-11 | Caroline | Maryland | 24011 | 2348 | 30 |
1405355 | 1405355 | 2021-06-10 | Caroline | Maryland | 24011 | 2348 | 30 |
1402109 | 1402109 | 2021-06-09 | Caroline | Maryland | 24011 | 2347 | 30 |
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);