ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
126 rows where county = "Logan", deaths = 11 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 |
---|---|---|---|---|---|---|---|
2225012 | 2225012 | 2022-02-17 | Logan | North Dakota | 38047 | 426 | 11 |
2221761 | 2221761 | 2022-02-16 | Logan | North Dakota | 38047 | 426 | 11 |
2218510 | 2218510 | 2022-02-15 | Logan | North Dakota | 38047 | 426 | 11 |
2215259 | 2215259 | 2022-02-14 | Logan | North Dakota | 38047 | 425 | 11 |
2212008 | 2212008 | 2022-02-13 | Logan | North Dakota | 38047 | 425 | 11 |
2208755 | 2208755 | 2022-02-12 | Logan | North Dakota | 38047 | 425 | 11 |
2205502 | 2205502 | 2022-02-11 | Logan | North Dakota | 38047 | 425 | 11 |
2202249 | 2202249 | 2022-02-10 | Logan | North Dakota | 38047 | 423 | 11 |
2198995 | 2198995 | 2022-02-09 | Logan | North Dakota | 38047 | 422 | 11 |
2195741 | 2195741 | 2022-02-08 | Logan | North Dakota | 38047 | 422 | 11 |
2192487 | 2192487 | 2022-02-07 | Logan | North Dakota | 38047 | 423 | 11 |
2189233 | 2189233 | 2022-02-06 | Logan | North Dakota | 38047 | 423 | 11 |
2185980 | 2185980 | 2022-02-05 | Logan | North Dakota | 38047 | 423 | 11 |
2182728 | 2182728 | 2022-02-04 | Logan | North Dakota | 38047 | 420 | 11 |
2179476 | 2179476 | 2022-02-03 | Logan | North Dakota | 38047 | 418 | 11 |
2176225 | 2176225 | 2022-02-02 | Logan | North Dakota | 38047 | 418 | 11 |
2172972 | 2172972 | 2022-02-01 | Logan | North Dakota | 38047 | 418 | 11 |
2169719 | 2169719 | 2022-01-31 | Logan | North Dakota | 38047 | 413 | 11 |
2166464 | 2166464 | 2022-01-30 | Logan | North Dakota | 38047 | 413 | 11 |
2163209 | 2163209 | 2022-01-29 | Logan | North Dakota | 38047 | 412 | 11 |
2159954 | 2159954 | 2022-01-28 | Logan | North Dakota | 38047 | 411 | 11 |
2156699 | 2156699 | 2022-01-27 | Logan | North Dakota | 38047 | 402 | 11 |
2153446 | 2153446 | 2022-01-26 | Logan | North Dakota | 38047 | 402 | 11 |
2150194 | 2150194 | 2022-01-25 | Logan | North Dakota | 38047 | 397 | 11 |
2146942 | 2146942 | 2022-01-24 | Logan | North Dakota | 38047 | 393 | 11 |
2143688 | 2143688 | 2022-01-23 | Logan | North Dakota | 38047 | 393 | 11 |
2140433 | 2140433 | 2022-01-22 | Logan | North Dakota | 38047 | 392 | 11 |
2137177 | 2137177 | 2022-01-21 | Logan | North Dakota | 38047 | 391 | 11 |
2133924 | 2133924 | 2022-01-20 | Logan | North Dakota | 38047 | 387 | 11 |
2130672 | 2130672 | 2022-01-19 | Logan | North Dakota | 38047 | 382 | 11 |
2127418 | 2127418 | 2022-01-18 | Logan | North Dakota | 38047 | 380 | 11 |
2124166 | 2124166 | 2022-01-17 | Logan | North Dakota | 38047 | 379 | 11 |
2120914 | 2120914 | 2022-01-16 | Logan | North Dakota | 38047 | 376 | 11 |
2117662 | 2117662 | 2022-01-15 | Logan | North Dakota | 38047 | 374 | 11 |
2114411 | 2114411 | 2022-01-14 | Logan | North Dakota | 38047 | 371 | 11 |
2111159 | 2111159 | 2022-01-13 | Logan | North Dakota | 38047 | 370 | 11 |
2107907 | 2107907 | 2022-01-12 | Logan | North Dakota | 38047 | 368 | 11 |
2104656 | 2104656 | 2022-01-11 | Logan | North Dakota | 38047 | 367 | 11 |
2101405 | 2101405 | 2022-01-10 | Logan | North Dakota | 38047 | 365 | 11 |
2098154 | 2098154 | 2022-01-09 | Logan | North Dakota | 38047 | 363 | 11 |
2094902 | 2094902 | 2022-01-08 | Logan | North Dakota | 38047 | 363 | 11 |
2091650 | 2091650 | 2022-01-07 | Logan | North Dakota | 38047 | 361 | 11 |
2088399 | 2088399 | 2022-01-06 | Logan | North Dakota | 38047 | 361 | 11 |
2085147 | 2085147 | 2022-01-05 | Logan | North Dakota | 38047 | 358 | 11 |
2081895 | 2081895 | 2022-01-04 | Logan | North Dakota | 38047 | 356 | 11 |
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 |
2068890 | 2068890 | 2021-12-31 | Logan | North Dakota | 38047 | 353 | 11 |
2065639 | 2065639 | 2021-12-30 | Logan | North Dakota | 38047 | 352 | 11 |
2062389 | 2062389 | 2021-12-29 | Logan | North Dakota | 38047 | 352 | 11 |
2059140 | 2059140 | 2021-12-28 | Logan | North Dakota | 38047 | 352 | 11 |
2055891 | 2055891 | 2021-12-27 | Logan | North Dakota | 38047 | 351 | 11 |
2052641 | 2052641 | 2021-12-26 | Logan | North Dakota | 38047 | 351 | 11 |
2049391 | 2049391 | 2021-12-25 | Logan | North Dakota | 38047 | 351 | 11 |
2046141 | 2046141 | 2021-12-24 | Logan | North Dakota | 38047 | 351 | 11 |
2042891 | 2042891 | 2021-12-23 | Logan | North Dakota | 38047 | 350 | 11 |
2039642 | 2039642 | 2021-12-22 | Logan | North Dakota | 38047 | 347 | 11 |
2036392 | 2036392 | 2021-12-21 | Logan | North Dakota | 38047 | 347 | 11 |
2033142 | 2033142 | 2021-12-20 | Logan | North Dakota | 38047 | 347 | 11 |
2029892 | 2029892 | 2021-12-19 | Logan | North Dakota | 38047 | 347 | 11 |
2026641 | 2026641 | 2021-12-18 | Logan | North Dakota | 38047 | 346 | 11 |
2023390 | 2023390 | 2021-12-17 | Logan | North Dakota | 38047 | 346 | 11 |
2020139 | 2020139 | 2021-12-16 | Logan | North Dakota | 38047 | 344 | 11 |
2016888 | 2016888 | 2021-12-15 | Logan | North Dakota | 38047 | 343 | 11 |
2013638 | 2013638 | 2021-12-14 | Logan | North Dakota | 38047 | 343 | 11 |
2010387 | 2010387 | 2021-12-13 | Logan | North Dakota | 38047 | 343 | 11 |
2007136 | 2007136 | 2021-12-12 | Logan | North Dakota | 38047 | 343 | 11 |
2003885 | 2003885 | 2021-12-11 | Logan | North Dakota | 38047 | 343 | 11 |
2000634 | 2000634 | 2021-12-10 | Logan | North Dakota | 38047 | 342 | 11 |
1997384 | 1997384 | 2021-12-09 | Logan | North Dakota | 38047 | 343 | 11 |
1994133 | 1994133 | 2021-12-08 | Logan | North Dakota | 38047 | 341 | 11 |
1990882 | 1990882 | 2021-12-07 | Logan | North Dakota | 38047 | 341 | 11 |
1987631 | 1987631 | 2021-12-06 | Logan | North Dakota | 38047 | 341 | 11 |
1984381 | 1984381 | 2021-12-05 | Logan | North Dakota | 38047 | 341 | 11 |
1981131 | 1981131 | 2021-12-04 | Logan | North Dakota | 38047 | 341 | 11 |
1977881 | 1977881 | 2021-12-03 | Logan | North Dakota | 38047 | 341 | 11 |
1974631 | 1974631 | 2021-12-02 | Logan | North Dakota | 38047 | 342 | 11 |
1971382 | 1971382 | 2021-12-01 | Logan | North Dakota | 38047 | 341 | 11 |
1968132 | 1968132 | 2021-11-30 | Logan | North Dakota | 38047 | 340 | 11 |
1964881 | 1964881 | 2021-11-29 | Logan | North Dakota | 38047 | 337 | 11 |
1961629 | 1961629 | 2021-11-28 | Logan | North Dakota | 38047 | 337 | 11 |
1958378 | 1958378 | 2021-11-27 | Logan | North Dakota | 38047 | 337 | 11 |
1955127 | 1955127 | 2021-11-26 | Logan | North Dakota | 38047 | 337 | 11 |
1951876 | 1951876 | 2021-11-25 | Logan | North Dakota | 38047 | 337 | 11 |
1948625 | 1948625 | 2021-11-24 | Logan | North Dakota | 38047 | 337 | 11 |
1945374 | 1945374 | 2021-11-23 | Logan | North Dakota | 38047 | 337 | 11 |
1942123 | 1942123 | 2021-11-22 | Logan | North Dakota | 38047 | 337 | 11 |
1938873 | 1938873 | 2021-11-21 | Logan | North Dakota | 38047 | 337 | 11 |
1935623 | 1935623 | 2021-11-20 | Logan | North Dakota | 38047 | 337 | 11 |
1932373 | 1932373 | 2021-11-19 | Logan | North Dakota | 38047 | 337 | 11 |
1929122 | 1929122 | 2021-11-18 | Logan | North Dakota | 38047 | 334 | 11 |
1925872 | 1925872 | 2021-11-17 | Logan | North Dakota | 38047 | 334 | 11 |
1922623 | 1922623 | 2021-11-16 | Logan | North Dakota | 38047 | 331 | 11 |
1919373 | 1919373 | 2021-11-15 | Logan | North Dakota | 38047 | 331 | 11 |
1916123 | 1916123 | 2021-11-14 | Logan | North Dakota | 38047 | 331 | 11 |
1912873 | 1912873 | 2021-11-13 | Logan | North Dakota | 38047 | 330 | 11 |
1909623 | 1909623 | 2021-11-12 | Logan | North Dakota | 38047 | 330 | 11 |
1906374 | 1906374 | 2021-11-11 | Logan | North Dakota | 38047 | 330 | 11 |
1903125 | 1903125 | 2021-11-10 | Logan | North Dakota | 38047 | 330 | 11 |
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);