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

25 rows where county = "Unknown" and "date" is on date 2020-10-30 sorted by date descending

✎ View and edit SQL

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

fips 1

  • - 25

county 1

  • Unknown · 25 ✖
Link rowid date ▲ county state fips cases deaths
680398 680398 2020-10-30 Unknown Alaska   64 0
680488 680488 2020-10-30 Unknown Arkansas   2115 0
680623 680623 2020-10-30 Unknown Connecticut   141 0
680628 680628 2020-10-30 Unknown Delaware   91 0
680693 680693 2020-10-30 Unknown Florida   1786 0
680842 680842 2020-10-30 Unknown Georgia   2177 6
680858 680858 2020-10-30 Unknown Guam   5597 80
680998 680998 2020-10-30 Unknown Illinois   6061 278
681190 681190 2020-10-30 Unknown Iowa   9 0
681300 681300 2020-10-30 Unknown Kansas   0 10
681484 681484 2020-10-30 Unknown Louisiana   4700 214
681506 681506 2020-10-30 Unknown Maine   4 0
681531 681531 2020-10-30 Unknown Maryland   0 15
681548 681548 2020-10-30 Unknown Massachusetts   4238 6
681629 681629 2020-10-30 Unknown Michigan   1442 4
681712 681712 2020-10-30 Unknown Minnesota   257 54
682096 682096 2020-10-30 Unknown New Hampshire   20 0
682117 682117 2020-10-30 Unknown New Jersey   522 0
682359 682359 2020-10-30 Unknown North Dakota   5 5
682526 682526 2020-10-30 Unknown Oklahoma   5 0
682706 682706 2020-10-30 Unknown Puerto Rico   2089 820
682718 682718 2020-10-30 Unknown Rhode Island   4417 26
683204 683204 2020-10-30 Unknown Utah   76 6
683221 683221 2020-10-30 Unknown Vermont   8 0
683395 683395 2020-10-30 Unknown Washington   2 2

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