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

27 rows where county = "Unknown" and date = "2020-10-02" sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases, deaths, date (date)

fips 1

  • - 27

county 1

  • Unknown · 27 ✖
Link rowid date ▲ county state fips cases deaths
589578 589578 2020-10-02 Unknown Alaska   36 0
589668 589668 2020-10-02 Unknown Arkansas   2049 0
589803 589803 2020-10-02 Unknown Connecticut   132 0
589808 589808 2020-10-02 Unknown Delaware   90 0
589873 589873 2020-10-02 Unknown Florida   1754 0
590022 590022 2020-10-02 Unknown Georgia   2219 6
590038 590038 2020-10-02 Unknown Guam   3586 51
590178 590178 2020-10-02 Unknown Illinois   2661 245
590370 590370 2020-10-02 Unknown Iowa   5 0
590480 590480 2020-10-02 Unknown Kansas   0 12
590664 590664 2020-10-02 Unknown Louisiana   1624 190
590686 590686 2020-10-02 Unknown Maine   2 1
590711 590711 2020-10-02 Unknown Maryland   0 5
590728 590728 2020-10-02 Unknown Massachusetts   2719 5
590809 590809 2020-10-02 Unknown Michigan   176 6
590892 590892 2020-10-02 Unknown Minnesota   225 53
591242 591242 2020-10-02 Unknown Nebraska   212 0
591275 591275 2020-10-02 Unknown New Hampshire   2 0
591296 591296 2020-10-02 Unknown New Jersey   342 0
591538 591538 2020-10-02 Unknown North Dakota   3 3
591705 591705 2020-10-02 Unknown Oklahoma   16 0
591884 591884 2020-10-02 Unknown Puerto Rico   1343 673
591896 591896 2020-10-02 Unknown Rhode Island   2383 17
592381 592381 2020-10-02 Unknown Utah   24 1
592398 592398 2020-10-02 Unknown Vermont   8 0
592572 592572 2020-10-02 Unknown Washington   2 2
592695 592695 2020-10-02 Unknown Wisconsin   0 10

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