ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

58 rows where deaths = 51 and fips = 28039 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

fips 1

  • 28039 · 58 ✖

county 1

Link rowid date ▲ county state fips cases deaths
1587392 1587392 2021-08-05 George Mississippi 28039 2894 51
1584141 1584141 2021-08-04 George Mississippi 28039 2858 51
1580892 1580892 2021-08-03 George Mississippi 28039 2773 51
1577643 1577643 2021-08-02 George Mississippi 28039 2767 51
1574395 1574395 2021-08-01 George Mississippi 28039 2722 51
1571147 1571147 2021-07-31 George Mississippi 28039 2722 51
1567899 1567899 2021-07-30 George Mississippi 28039 2722 51
1564651 1564651 2021-07-29 George Mississippi 28039 2705 51
1561403 1561403 2021-07-28 George Mississippi 28039 2676 51
1558155 1558155 2021-07-27 George Mississippi 28039 2662 51
1554908 1554908 2021-07-26 George Mississippi 28039 2650 51
1551661 1551661 2021-07-25 George Mississippi 28039 2616 51
1548414 1548414 2021-07-24 George Mississippi 28039 2616 51
1545167 1545167 2021-07-23 George Mississippi 28039 2616 51
1541919 1541919 2021-07-22 George Mississippi 28039 2598 51
1538672 1538672 2021-07-21 George Mississippi 28039 2586 51
1535425 1535425 2021-07-20 George Mississippi 28039 2580 51
1532177 1532177 2021-07-19 George Mississippi 28039 2577 51
1528930 1528930 2021-07-18 George Mississippi 28039 2560 51
1525683 1525683 2021-07-17 George Mississippi 28039 2560 51
1522436 1522436 2021-07-16 George Mississippi 28039 2560 51
1519187 1519187 2021-07-15 George Mississippi 28039 2560 51
1515940 1515940 2021-07-14 George Mississippi 28039 2551 51
1512694 1512694 2021-07-13 George Mississippi 28039 2550 51
1509447 1509447 2021-07-12 George Mississippi 28039 2550 51
1506201 1506201 2021-07-11 George Mississippi 28039 2543 51
1502955 1502955 2021-07-10 George Mississippi 28039 2543 51
1499709 1499709 2021-07-09 George Mississippi 28039 2543 51
1496463 1496463 2021-07-08 George Mississippi 28039 2541 51
1493216 1493216 2021-07-07 George Mississippi 28039 2541 51
1489969 1489969 2021-07-06 George Mississippi 28039 2540 51
1486722 1486722 2021-07-05 George Mississippi 28039 2535 51
1483476 1483476 2021-07-04 George Mississippi 28039 2535 51
1480230 1480230 2021-07-03 George Mississippi 28039 2535 51
1476983 1476983 2021-07-02 George Mississippi 28039 2535 51
1473737 1473737 2021-07-01 George Mississippi 28039 2534 51
1470491 1470491 2021-06-30 George Mississippi 28039 2533 51
1467246 1467246 2021-06-29 George Mississippi 28039 2533 51
1464001 1464001 2021-06-28 George Mississippi 28039 2533 51
1460756 1460756 2021-06-27 George Mississippi 28039 2531 51
1457511 1457511 2021-06-26 George Mississippi 28039 2531 51
1454266 1454266 2021-06-25 George Mississippi 28039 2531 51
1451021 1451021 2021-06-24 George Mississippi 28039 2528 51
1447775 1447775 2021-06-23 George Mississippi 28039 2524 51
1444530 1444530 2021-06-22 George Mississippi 28039 2524 51
1441285 1441285 2021-06-21 George Mississippi 28039 2522 51
1438039 1438039 2021-06-20 George Mississippi 28039 2522 51
1434792 1434792 2021-06-19 George Mississippi 28039 2522 51
1431545 1431545 2021-06-18 George Mississippi 28039 2522 51
1428300 1428300 2021-06-17 George Mississippi 28039 2520 51
1425055 1425055 2021-06-16 George Mississippi 28039 2520 51
1421807 1421807 2021-06-15 George Mississippi 28039 2519 51
1418562 1418562 2021-06-14 George Mississippi 28039 2519 51
1415317 1415317 2021-06-13 George Mississippi 28039 2518 51
1412071 1412071 2021-06-12 George Mississippi 28039 2518 51
1408826 1408826 2021-06-11 George Mississippi 28039 2518 51
1405581 1405581 2021-06-10 George Mississippi 28039 2517 51
1402335 1402335 2021-06-09 George Mississippi 28039 2517 51

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);