ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 121 and state = "North Dakota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2101385 | 2101385 | 2022-01-10 | Billings | North Dakota | 38007 | 121 | 1 |
2098134 | 2098134 | 2022-01-09 | Billings | North Dakota | 38007 | 121 | 1 |
2094882 | 2094882 | 2022-01-08 | Billings | North Dakota | 38007 | 121 | 1 |
2091630 | 2091630 | 2022-01-07 | Billings | North Dakota | 38007 | 121 | 1 |
2088379 | 2088379 | 2022-01-06 | Billings | North Dakota | 38007 | 121 | 1 |
2085127 | 2085127 | 2022-01-05 | Billings | North Dakota | 38007 | 121 | 1 |
2081875 | 2081875 | 2022-01-04 | Billings | North Dakota | 38007 | 121 | 1 |
2078623 | 2078623 | 2022-01-03 | Billings | North Dakota | 38007 | 121 | 1 |
2075372 | 2075372 | 2022-01-02 | Billings | North Dakota | 38007 | 121 | 1 |
2072121 | 2072121 | 2022-01-01 | Billings | North Dakota | 38007 | 121 | 1 |
1338026 | 1338026 | 2021-05-20 | Sheridan | North Dakota | 38083 | 121 | 2 |
1334779 | 1334779 | 2021-05-19 | Sheridan | North Dakota | 38083 | 121 | 2 |
1331532 | 1331532 | 2021-05-18 | Sheridan | North Dakota | 38083 | 121 | 2 |
1328285 | 1328285 | 2021-05-17 | Sheridan | North Dakota | 38083 | 121 | 2 |
1325039 | 1325039 | 2021-05-16 | Sheridan | North Dakota | 38083 | 121 | 2 |
1321793 | 1321793 | 2021-05-15 | Sheridan | North Dakota | 38083 | 121 | 2 |
1318547 | 1318547 | 2021-05-14 | Sheridan | North Dakota | 38083 | 121 | 2 |
1315299 | 1315299 | 2021-05-13 | Sheridan | North Dakota | 38083 | 121 | 2 |
1312053 | 1312053 | 2021-05-12 | Sheridan | North Dakota | 38083 | 121 | 2 |
1308806 | 1308806 | 2021-05-11 | Sheridan | North Dakota | 38083 | 121 | 2 |
1305560 | 1305560 | 2021-05-10 | Sheridan | North Dakota | 38083 | 121 | 2 |
1302314 | 1302314 | 2021-05-09 | Sheridan | North Dakota | 38083 | 121 | 2 |
1299066 | 1299066 | 2021-05-08 | Sheridan | North Dakota | 38083 | 121 | 2 |
1295820 | 1295820 | 2021-05-07 | Sheridan | North Dakota | 38083 | 121 | 2 |
773167 | 773167 | 2020-11-27 | Divide | North Dakota | 38023 | 121 | 1 |
769922 | 769922 | 2020-11-26 | Divide | North Dakota | 38023 | 121 | 1 |
766710 | 766710 | 2020-11-25 | Steele | North Dakota | 38091 | 121 | 1 |
701792 | 701792 | 2020-11-05 | Kidder | North Dakota | 38043 | 121 | 3 |
688814 | 688814 | 2020-11-01 | Golden Valley | North Dakota | 38033 | 121 | 0 |
656402 | 656402 | 2020-10-22 | Sargent | North Dakota | 38081 | 121 | 2 |
653140 | 653140 | 2020-10-21 | Logan | North Dakota | 38047 | 121 | 0 |
633657 | 633657 | 2020-10-15 | Foster | North Dakota | 38031 | 121 | 1 |
610947 | 610947 | 2020-10-08 | Bottineau | North Dakota | 38009 | 121 | 9 |
491177 | 491177 | 2020-09-01 | Sioux | North Dakota | 38085 | 121 | 2 |
487937 | 487937 | 2020-08-31 | Ramsey | North Dakota | 38071 | 121 | 2 |
487944 | 487944 | 2020-08-31 | Sioux | North Dakota | 38085 | 121 | 2 |
458844 | 458844 | 2020-08-22 | McLean | North Dakota | 38055 | 121 | 1 |
458855 | 458855 | 2020-08-22 | Richland | North Dakota | 38077 | 121 | 1 |
455627 | 455627 | 2020-08-21 | Richland | North Dakota | 38077 | 121 | 1 |
404050 | 404050 | 2020-08-05 | Stutsman | North Dakota | 38093 | 121 | 2 |
400832 | 400832 | 2020-08-04 | Stutsman | North Dakota | 38093 | 121 | 2 |
352644 | 352644 | 2020-07-20 | Stark | North Dakota | 38089 | 121 | 3 |
346240 | 346240 | 2020-07-18 | Stark | North Dakota | 38089 | 121 | 3 |
317518 | 317518 | 2020-07-09 | Morton | North Dakota | 38059 | 121 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
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);