ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 38053 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 |
---|---|---|---|---|---|---|---|
2176228 | 2176228 | 2022-02-02 | McKenzie | North Dakota | 38053 | 3120 | 24 |
2172975 | 2172975 | 2022-02-01 | McKenzie | North Dakota | 38053 | 3101 | 23 |
2169722 | 2169722 | 2022-01-31 | McKenzie | North Dakota | 38053 | 3090 | 23 |
2166467 | 2166467 | 2022-01-30 | McKenzie | North Dakota | 38053 | 3089 | 23 |
2163212 | 2163212 | 2022-01-29 | McKenzie | North Dakota | 38053 | 3081 | 23 |
2159957 | 2159957 | 2022-01-28 | McKenzie | North Dakota | 38053 | 3064 | 23 |
2156702 | 2156702 | 2022-01-27 | McKenzie | North Dakota | 38053 | 3048 | 23 |
2153449 | 2153449 | 2022-01-26 | McKenzie | North Dakota | 38053 | 3035 | 23 |
2150197 | 2150197 | 2022-01-25 | McKenzie | North Dakota | 38053 | 3005 | 23 |
2146945 | 2146945 | 2022-01-24 | McKenzie | North Dakota | 38053 | 2987 | 23 |
2143691 | 2143691 | 2022-01-23 | McKenzie | North Dakota | 38053 | 2987 | 23 |
2140436 | 2140436 | 2022-01-22 | McKenzie | North Dakota | 38053 | 2985 | 23 |
2137180 | 2137180 | 2022-01-21 | McKenzie | North Dakota | 38053 | 2966 | 23 |
2133927 | 2133927 | 2022-01-20 | McKenzie | North Dakota | 38053 | 2959 | 23 |
2130675 | 2130675 | 2022-01-19 | McKenzie | North Dakota | 38053 | 2934 | 23 |
2127421 | 2127421 | 2022-01-18 | McKenzie | North Dakota | 38053 | 2918 | 23 |
2124169 | 2124169 | 2022-01-17 | McKenzie | North Dakota | 38053 | 2886 | 23 |
2120917 | 2120917 | 2022-01-16 | McKenzie | North Dakota | 38053 | 2884 | 23 |
2117665 | 2117665 | 2022-01-15 | McKenzie | North Dakota | 38053 | 2881 | 23 |
2114414 | 2114414 | 2022-01-14 | McKenzie | North Dakota | 38053 | 2858 | 23 |
2111162 | 2111162 | 2022-01-13 | McKenzie | North Dakota | 38053 | 2847 | 23 |
2107910 | 2107910 | 2022-01-12 | McKenzie | North Dakota | 38053 | 2834 | 23 |
2104659 | 2104659 | 2022-01-11 | McKenzie | North Dakota | 38053 | 2806 | 23 |
2101408 | 2101408 | 2022-01-10 | McKenzie | North Dakota | 38053 | 2785 | 23 |
2098157 | 2098157 | 2022-01-09 | McKenzie | North Dakota | 38053 | 2781 | 23 |
2094905 | 2094905 | 2022-01-08 | McKenzie | North Dakota | 38053 | 2772 | 23 |
2091653 | 2091653 | 2022-01-07 | McKenzie | North Dakota | 38053 | 2765 | 23 |
2088402 | 2088402 | 2022-01-06 | McKenzie | North Dakota | 38053 | 2749 | 23 |
2085150 | 2085150 | 2022-01-05 | McKenzie | North Dakota | 38053 | 2733 | 23 |
2081898 | 2081898 | 2022-01-04 | McKenzie | North Dakota | 38053 | 2718 | 23 |
2078646 | 2078646 | 2022-01-03 | McKenzie | North Dakota | 38053 | 2701 | 23 |
2075395 | 2075395 | 2022-01-02 | McKenzie | North Dakota | 38053 | 2691 | 23 |
2072144 | 2072144 | 2022-01-01 | McKenzie | North Dakota | 38053 | 2688 | 23 |
2068893 | 2068893 | 2021-12-31 | McKenzie | North Dakota | 38053 | 2681 | 23 |
2065642 | 2065642 | 2021-12-30 | McKenzie | North Dakota | 38053 | 2675 | 23 |
2062392 | 2062392 | 2021-12-29 | McKenzie | North Dakota | 38053 | 2668 | 23 |
2059143 | 2059143 | 2021-12-28 | McKenzie | North Dakota | 38053 | 2660 | 23 |
2055894 | 2055894 | 2021-12-27 | McKenzie | North Dakota | 38053 | 2650 | 23 |
2052644 | 2052644 | 2021-12-26 | McKenzie | North Dakota | 38053 | 2647 | 23 |
2049394 | 2049394 | 2021-12-25 | McKenzie | North Dakota | 38053 | 2647 | 23 |
2046144 | 2046144 | 2021-12-24 | McKenzie | North Dakota | 38053 | 2647 | 23 |
2042894 | 2042894 | 2021-12-23 | McKenzie | North Dakota | 38053 | 2643 | 23 |
2039645 | 2039645 | 2021-12-22 | McKenzie | North Dakota | 38053 | 2640 | 23 |
2036395 | 2036395 | 2021-12-21 | McKenzie | North Dakota | 38053 | 2631 | 23 |
2033145 | 2033145 | 2021-12-20 | McKenzie | North Dakota | 38053 | 2625 | 23 |
2029895 | 2029895 | 2021-12-19 | McKenzie | North Dakota | 38053 | 2624 | 23 |
2026644 | 2026644 | 2021-12-18 | McKenzie | North Dakota | 38053 | 2618 | 23 |
2023393 | 2023393 | 2021-12-17 | McKenzie | North Dakota | 38053 | 2615 | 23 |
2020142 | 2020142 | 2021-12-16 | McKenzie | North Dakota | 38053 | 2608 | 23 |
2016891 | 2016891 | 2021-12-15 | McKenzie | North Dakota | 38053 | 2603 | 23 |
2013641 | 2013641 | 2021-12-14 | McKenzie | North Dakota | 38053 | 2594 | 23 |
2010390 | 2010390 | 2021-12-13 | McKenzie | North Dakota | 38053 | 2584 | 23 |
2007139 | 2007139 | 2021-12-12 | McKenzie | North Dakota | 38053 | 2584 | 23 |
2003888 | 2003888 | 2021-12-11 | McKenzie | North Dakota | 38053 | 2571 | 23 |
2000637 | 2000637 | 2021-12-10 | McKenzie | North Dakota | 38053 | 2568 | 23 |
1997387 | 1997387 | 2021-12-09 | McKenzie | North Dakota | 38053 | 2562 | 23 |
1994136 | 1994136 | 2021-12-08 | McKenzie | North Dakota | 38053 | 2557 | 23 |
1990885 | 1990885 | 2021-12-07 | McKenzie | North Dakota | 38053 | 2545 | 22 |
1987634 | 1987634 | 2021-12-06 | McKenzie | North Dakota | 38053 | 2528 | 22 |
1984384 | 1984384 | 2021-12-05 | McKenzie | North Dakota | 38053 | 2525 | 22 |
1981134 | 1981134 | 2021-12-04 | McKenzie | North Dakota | 38053 | 2523 | 22 |
1977884 | 1977884 | 2021-12-03 | McKenzie | North Dakota | 38053 | 2516 | 22 |
1974634 | 1974634 | 2021-12-02 | McKenzie | North Dakota | 38053 | 2511 | 22 |
1971385 | 1971385 | 2021-12-01 | McKenzie | North Dakota | 38053 | 2501 | 22 |
1968135 | 1968135 | 2021-11-30 | McKenzie | North Dakota | 38053 | 2491 | 22 |
1964884 | 1964884 | 2021-11-29 | McKenzie | North Dakota | 38053 | 2476 | 22 |
1961632 | 1961632 | 2021-11-28 | McKenzie | North Dakota | 38053 | 2473 | 22 |
1958381 | 1958381 | 2021-11-27 | McKenzie | North Dakota | 38053 | 2472 | 22 |
1955130 | 1955130 | 2021-11-26 | McKenzie | North Dakota | 38053 | 2468 | 22 |
1951879 | 1951879 | 2021-11-25 | McKenzie | North Dakota | 38053 | 2468 | 22 |
1948628 | 1948628 | 2021-11-24 | McKenzie | North Dakota | 38053 | 2464 | 21 |
1945377 | 1945377 | 2021-11-23 | McKenzie | North Dakota | 38053 | 2455 | 21 |
1942126 | 1942126 | 2021-11-22 | McKenzie | North Dakota | 38053 | 2445 | 21 |
1938876 | 1938876 | 2021-11-21 | McKenzie | North Dakota | 38053 | 2441 | 21 |
1935626 | 1935626 | 2021-11-20 | McKenzie | North Dakota | 38053 | 2441 | 21 |
1932376 | 1932376 | 2021-11-19 | McKenzie | North Dakota | 38053 | 2436 | 21 |
1929125 | 1929125 | 2021-11-18 | McKenzie | North Dakota | 38053 | 2434 | 21 |
1925875 | 1925875 | 2021-11-17 | McKenzie | North Dakota | 38053 | 2430 | 21 |
1922626 | 1922626 | 2021-11-16 | McKenzie | North Dakota | 38053 | 2429 | 21 |
1919376 | 1919376 | 2021-11-15 | McKenzie | North Dakota | 38053 | 2419 | 21 |
1916126 | 1916126 | 2021-11-14 | McKenzie | North Dakota | 38053 | 2417 | 21 |
1912876 | 1912876 | 2021-11-13 | McKenzie | North Dakota | 38053 | 2416 | 21 |
1909626 | 1909626 | 2021-11-12 | McKenzie | North Dakota | 38053 | 2412 | 21 |
1906377 | 1906377 | 2021-11-11 | McKenzie | North Dakota | 38053 | 2406 | 21 |
1903128 | 1903128 | 2021-11-10 | McKenzie | North Dakota | 38053 | 2396 | 21 |
1899878 | 1899878 | 2021-11-09 | McKenzie | North Dakota | 38053 | 2386 | 21 |
1896628 | 1896628 | 2021-11-08 | McKenzie | North Dakota | 38053 | 2381 | 21 |
1893378 | 1893378 | 2021-11-07 | McKenzie | North Dakota | 38053 | 2381 | 21 |
1890128 | 1890128 | 2021-11-06 | McKenzie | North Dakota | 38053 | 2379 | 21 |
1886878 | 1886878 | 2021-11-05 | McKenzie | North Dakota | 38053 | 2377 | 21 |
1883629 | 1883629 | 2021-11-04 | McKenzie | North Dakota | 38053 | 2374 | 21 |
1880380 | 1880380 | 2021-11-03 | McKenzie | North Dakota | 38053 | 2367 | 21 |
1877131 | 1877131 | 2021-11-02 | McKenzie | North Dakota | 38053 | 2360 | 21 |
1873882 | 1873882 | 2021-11-01 | McKenzie | North Dakota | 38053 | 2350 | 21 |
1870633 | 1870633 | 2021-10-31 | McKenzie | North Dakota | 38053 | 2345 | 21 |
1867384 | 1867384 | 2021-10-30 | McKenzie | North Dakota | 38053 | 2340 | 21 |
1864135 | 1864135 | 2021-10-29 | McKenzie | North Dakota | 38053 | 2336 | 21 |
1860886 | 1860886 | 2021-10-28 | McKenzie | North Dakota | 38053 | 2328 | 21 |
1857637 | 1857637 | 2021-10-27 | McKenzie | North Dakota | 38053 | 2318 | 21 |
1854388 | 1854388 | 2021-10-26 | McKenzie | North Dakota | 38053 | 2309 | 20 |
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);