ny_times_us_counties

12 rows where cases = 1, "date" is on date 2020-03-30 and deaths = 1

View and edit SQL

Suggested facets: state, date (date)

Link rowid ▼ date county state fips cases deaths
19907 2020-03-30 Crowley Colorado 8025 1 1
20015 2020-03-30 Baker Georgia 13007 1 1
20075 2020-03-30 Heard Georgia 13149 1 1
20177 2020-03-30 Carroll Illinois 17015 1 1
20286 2020-03-30 Scott Indiana 18143 1 1
20590 2020-03-30 Gogebic Michigan 26053 1 1
20613 2020-03-30 Missaukee Michigan 26113 1 1
20784 2020-03-30 Henry Missouri 29083 1 1
21063 2020-03-30 McHenry North Dakota 38049 1 1
21102 2020-03-30 Gallia Ohio 39053 1 1
21756 2020-03-30 Iron Wisconsin 55051 1 1
21782 2020-03-30 Waupaca Wisconsin 55135 1 1

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
);
Powered by Datasette · Query took 308.919ms