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

30 rows where cases = 355 and state = "North Dakota" sorted by date descending

✎ View and edit SQL

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

fips 17

state 1

  • North Dakota · 30 ✖
Link rowid date ▲ county state fips cases deaths
2107895 2107895 2022-01-12 Divide North Dakota 38023 355 3
2078643 2078643 2022-01-03 Logan North Dakota 38047 355 11
2075392 2075392 2022-01-02 Logan North Dakota 38047 355 11
2072141 2072141 2022-01-01 Logan North Dakota 38047 355 11
1994128 1994128 2021-12-08 Grant North Dakota 38037 355 8
1990877 1990877 2021-12-07 Grant North Dakota 38037 355 8
1838135 1838135 2021-10-21 Kidder North Dakota 38043 355 11
1834886 1834886 2021-10-20 Kidder North Dakota 38043 355 11
1786167 1786167 2021-10-05 Renville North Dakota 38075 355 14
1782918 1782918 2021-10-04 Renville North Dakota 38075 355 14
1779669 1779669 2021-10-03 Renville North Dakota 38075 355 14
1776419 1776419 2021-10-02 Renville North Dakota 38075 355 14
1773169 1773169 2021-10-01 Renville North Dakota 38075 355 14
1769901 1769901 2021-09-30 Griggs North Dakota 38039 355 2
1766652 1766652 2021-09-29 Griggs North Dakota 38039 355 2
1766670 1766670 2021-09-29 Renville North Dakota 38075 355 14
1682184 1682184 2021-09-03 Hettinger North Dakota 38041 355 4
1610729 1610729 2021-08-12 McIntosh North Dakota 38051 355 7
886753 886753 2021-01-01 Dunn North Dakota 38025 355 7
883508 883508 2020-12-31 Dunn North Dakota 38025 355 7
880263 880263 2020-12-30 Dunn North Dakota 38025 355 7
815355 815355 2020-12-10 Emmons North Dakota 38029 355 10
808891 808891 2020-12-08 Sargent North Dakota 38081 355 5
805646 805646 2020-12-07 Sargent North Dakota 38081 355 5
776432 776432 2020-11-28 Nelson North Dakota 38063 355 10
763442 763442 2020-11-24 LaMoure North Dakota 38045 355 14
737467 737467 2020-11-16 Foster North Dakota 38031 355 2
737488 737488 2020-11-16 Ransom North Dakota 38073 355 5
620694 620694 2020-10-11 McKenzie North Dakota 38053 355 3
513814 513814 2020-09-08 Stutsman North Dakota 38093 355 3

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