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

13 rows where cases = 948 and state = "Virginia" sorted by date descending

✎ View and edit SQL

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

fips 12

state 1

  • Virginia · 13 ✖
Link rowid date ▲ county state fips cases deaths
2378875 2378875 2022-04-05 Rappahannock Virginia 51157 948 9
1881355 1881355 2021-11-03 Middlesex Virginia 51119 948 33
1878106 1878106 2021-11-02 Middlesex Virginia 51119 948 33
1605171 1605171 2021-08-10 Floyd Virginia 51063 948 22
1043489 1043489 2021-02-18 Franklin city Virginia 51620 948 25
998056 998056 2021-02-04 Giles Virginia 51071 948 7
939651 939651 2021-01-17 King George Virginia 51099 948 10
907233 907233 2021-01-07 Powhatan Virginia 51145 948 6
829299 829299 2020-12-14 Greensville Virginia 51081 948 16
816373 816373 2020-12-10 Scott Virginia 51169 948 20
683321 683321 2020-10-30 Petersburg city Virginia 51730 948 30
624839 624839 2020-10-12 Bedford Virginia 51019 948 15
376084 376084 2020-07-27 Suffolk city Virginia 51800 948 45

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