ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where cases = 329 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 89
- Georgia 49
- Texas 49
- Kansas 45
- Virginia 39
- Missouri 33
- California 30
- Puerto Rico 26
- Indiana 25
- Nebraska 25
- Oklahoma 25
- South Dakota 25
- Colorado 22
- Mississippi 21
- Iowa 18
- Kentucky 18
- Washington 17
- Montana 16
- Alabama 15
- Minnesota 15
- Illinois 14
- Arkansas 12
- North Carolina 12
- Tennessee 12
- Louisiana 11
- Ohio 11
- Wisconsin 10
- Florida 9
- Idaho 9
- South Carolina 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501618 | 2501618 | 2022-05-13 | Oliver | North Dakota | 38065 | 329 | 5 |
2498360 | 2498360 | 2022-05-12 | Oliver | North Dakota | 38065 | 329 | 5 |
2495102 | 2495102 | 2022-05-11 | Oliver | North Dakota | 38065 | 329 | 5 |
2491844 | 2491844 | 2022-05-10 | Oliver | North Dakota | 38065 | 329 | 5 |
2488586 | 2488586 | 2022-05-09 | Oliver | North Dakota | 38065 | 329 | 5 |
2485329 | 2485329 | 2022-05-08 | Oliver | North Dakota | 38065 | 329 | 5 |
2482071 | 2482071 | 2022-05-07 | Oliver | North Dakota | 38065 | 329 | 5 |
2478813 | 2478813 | 2022-05-06 | Oliver | North Dakota | 38065 | 329 | 5 |
2475555 | 2475555 | 2022-05-05 | Oliver | North Dakota | 38065 | 329 | 5 |
2472298 | 2472298 | 2022-05-04 | Oliver | North Dakota | 38065 | 329 | 5 |
2469042 | 2469042 | 2022-05-03 | Oliver | North Dakota | 38065 | 329 | 5 |
2465786 | 2465786 | 2022-05-02 | Oliver | North Dakota | 38065 | 329 | 5 |
2462531 | 2462531 | 2022-05-01 | Oliver | North Dakota | 38065 | 329 | 5 |
2459275 | 2459275 | 2022-04-30 | Oliver | North Dakota | 38065 | 329 | 5 |
2456019 | 2456019 | 2022-04-29 | Oliver | North Dakota | 38065 | 329 | 5 |
2452763 | 2452763 | 2022-04-28 | Oliver | North Dakota | 38065 | 329 | 5 |
2449507 | 2449507 | 2022-04-27 | Oliver | North Dakota | 38065 | 329 | 5 |
2446250 | 2446250 | 2022-04-26 | Oliver | North Dakota | 38065 | 329 | 5 |
2442995 | 2442995 | 2022-04-25 | Oliver | North Dakota | 38065 | 329 | 5 |
2439739 | 2439739 | 2022-04-24 | Oliver | North Dakota | 38065 | 329 | 5 |
2436483 | 2436483 | 2022-04-23 | Oliver | North Dakota | 38065 | 329 | 5 |
2433227 | 2433227 | 2022-04-22 | Oliver | North Dakota | 38065 | 329 | 5 |
2429971 | 2429971 | 2022-04-21 | Oliver | North Dakota | 38065 | 329 | 5 |
2426715 | 2426715 | 2022-04-20 | Oliver | North Dakota | 38065 | 329 | 5 |
2423459 | 2423459 | 2022-04-19 | Oliver | North Dakota | 38065 | 329 | 5 |
2420202 | 2420202 | 2022-04-18 | Oliver | North Dakota | 38065 | 329 | 5 |
2416947 | 2416947 | 2022-04-17 | Oliver | North Dakota | 38065 | 329 | 5 |
2413691 | 2413691 | 2022-04-16 | Oliver | North Dakota | 38065 | 329 | 5 |
2410435 | 2410435 | 2022-04-15 | Oliver | North Dakota | 38065 | 329 | 5 |
2407179 | 2407179 | 2022-04-14 | Oliver | North Dakota | 38065 | 329 | 5 |
2403923 | 2403923 | 2022-04-13 | Oliver | North Dakota | 38065 | 329 | 5 |
2400668 | 2400668 | 2022-04-12 | Oliver | North Dakota | 38065 | 329 | 5 |
2397413 | 2397413 | 2022-04-11 | Oliver | North Dakota | 38065 | 329 | 5 |
2394158 | 2394158 | 2022-04-10 | Oliver | North Dakota | 38065 | 329 | 5 |
2390902 | 2390902 | 2022-04-09 | Oliver | North Dakota | 38065 | 329 | 5 |
2387646 | 2387646 | 2022-04-08 | Oliver | North Dakota | 38065 | 329 | 5 |
2384391 | 2384391 | 2022-04-07 | Oliver | North Dakota | 38065 | 329 | 5 |
2381136 | 2381136 | 2022-04-06 | Oliver | North Dakota | 38065 | 329 | 5 |
2377881 | 2377881 | 2022-04-05 | Oliver | North Dakota | 38065 | 329 | 5 |
2374628 | 2374628 | 2022-04-04 | Oliver | North Dakota | 38065 | 329 | 5 |
2371376 | 2371376 | 2022-04-03 | Oliver | North Dakota | 38065 | 329 | 5 |
2368123 | 2368123 | 2022-04-02 | Oliver | North Dakota | 38065 | 329 | 5 |
2364870 | 2364870 | 2022-04-01 | Oliver | North Dakota | 38065 | 329 | 5 |
2361616 | 2361616 | 2022-03-31 | Oliver | North Dakota | 38065 | 329 | 5 |
2358362 | 2358362 | 2022-03-30 | Oliver | North Dakota | 38065 | 329 | 5 |
2355108 | 2355108 | 2022-03-29 | Oliver | North Dakota | 38065 | 329 | 5 |
2351855 | 2351855 | 2022-03-28 | Oliver | North Dakota | 38065 | 329 | 5 |
2348603 | 2348603 | 2022-03-27 | Oliver | North Dakota | 38065 | 329 | 5 |
2345350 | 2345350 | 2022-03-26 | Oliver | North Dakota | 38065 | 329 | 5 |
2342097 | 2342097 | 2022-03-25 | Oliver | North Dakota | 38065 | 329 | 5 |
2270151 | 2270151 | 2022-03-03 | Powder River | Montana | 30075 | 329 | 10 |
2222629 | 2222629 | 2022-02-16 | Rich | Utah | 49033 | 329 | 0 |
2199863 | 2199863 | 2022-02-09 | Rich | Utah | 49033 | 329 | 0 |
2196609 | 2196609 | 2022-02-08 | Rich | Utah | 49033 | 329 | 0 |
2193355 | 2193355 | 2022-02-07 | Rich | Utah | 49033 | 329 | 0 |
2178380 | 2178380 | 2022-02-03 | Greeley | Kansas | 20071 | 329 | 3 |
2175127 | 2175127 | 2022-02-02 | Greeley | Kansas | 20071 | 329 | 3 |
2172641 | 2172641 | 2022-02-01 | Dundy | Nebraska | 31057 | 329 | 6 |
2169357 | 2169357 | 2022-01-31 | Wheatland | Montana | 30107 | 329 | 13 |
2169388 | 2169388 | 2022-01-31 | Dundy | Nebraska | 31057 | 329 | 6 |
2164696 | 2164696 | 2022-01-30 | Dolores | Colorado | 8033 | 329 | 7 |
2167511 | 2167511 | 2022-01-30 | Garfield | Washington | 53023 | 329 | 7 |
2164256 | 2164256 | 2022-01-29 | Garfield | Washington | 53023 | 329 | 7 |
2158185 | 2158185 | 2022-01-28 | Dolores | Colorado | 8033 | 329 | 7 |
2161001 | 2161001 | 2022-01-28 | Garfield | Washington | 53023 | 329 | 7 |
2127031 | 2127031 | 2022-01-18 | McCone | Montana | 30055 | 329 | 9 |
2107584 | 2107584 | 2022-01-12 | Garfield | Nebraska | 31071 | 329 | 2 |
2087983 | 2087983 | 2022-01-06 | Worth | Missouri | 29227 | 329 | 3 |
2084731 | 2084731 | 2022-01-05 | Worth | Missouri | 29227 | 329 | 3 |
2040534 | 2040534 | 2021-12-22 | Unknown | Vermont | 329 | 0 | |
2030362 | 2030362 | 2021-12-19 | Jerauld | South Dakota | 46073 | 329 | 19 |
2027111 | 2027111 | 2021-12-18 | Jerauld | South Dakota | 46073 | 329 | 19 |
2023860 | 2023860 | 2021-12-17 | Jerauld | South Dakota | 46073 | 329 | 19 |
2016202 | 2016202 | 2021-12-15 | Cook | Minnesota | 27031 | 329 | 1 |
2016876 | 2016876 | 2021-12-15 | Divide | North Dakota | 38023 | 329 | 3 |
1996344 | 1996344 | 2021-12-09 | Stanton | Kansas | 20187 | 329 | 7 |
1996352 | 1996352 | 2021-12-09 | Wichita | Kansas | 20203 | 329 | 8 |
1993093 | 1993093 | 2021-12-08 | Stanton | Kansas | 20187 | 329 | 7 |
1993101 | 1993101 | 2021-12-08 | Wichita | Kansas | 20203 | 329 | 8 |
1990564 | 1990564 | 2021-12-07 | Harlan | Nebraska | 31083 | 329 | 2 |
1960513 | 1960513 | 2021-11-28 | Comanche | Kansas | 20033 | 329 | 13 |
1957262 | 1957262 | 2021-11-27 | Comanche | Kansas | 20033 | 329 | 13 |
1954011 | 1954011 | 2021-11-26 | Comanche | Kansas | 20033 | 329 | 13 |
1950760 | 1950760 | 2021-11-25 | Comanche | Kansas | 20033 | 329 | 13 |
1947509 | 1947509 | 2021-11-24 | Comanche | Kansas | 20033 | 329 | 13 |
1907039 | 1907039 | 2021-11-11 | Edwards | Texas | 48137 | 329 | 7 |
1903790 | 1903790 | 2021-11-10 | Edwards | Texas | 48137 | 329 | 7 |
1900010 | 1900010 | 2021-11-09 | Cimarron | Oklahoma | 40025 | 329 | 2 |
1900540 | 1900540 | 2021-11-09 | Edwards | Texas | 48137 | 329 | 7 |
1896625 | 1896625 | 2021-11-08 | Logan | North Dakota | 38047 | 329 | 11 |
1896760 | 1896760 | 2021-11-08 | Cimarron | Oklahoma | 40025 | 329 | 2 |
1893375 | 1893375 | 2021-11-07 | Logan | North Dakota | 38047 | 329 | 11 |
1893510 | 1893510 | 2021-11-07 | Cimarron | Oklahoma | 40025 | 329 | 2 |
1890125 | 1890125 | 2021-11-06 | Logan | North Dakota | 38047 | 329 | 11 |
1890260 | 1890260 | 2021-11-06 | Cimarron | Oklahoma | 40025 | 329 | 2 |
1886875 | 1886875 | 2021-11-05 | Logan | North Dakota | 38047 | 329 | 11 |
1887010 | 1887010 | 2021-11-05 | Cimarron | Oklahoma | 40025 | 329 | 2 |
1883760 | 1883760 | 2021-11-04 | Cimarron | Oklahoma | 40025 | 329 | 2 |
1880511 | 1880511 | 2021-11-03 | Cimarron | Oklahoma | 40025 | 329 | 2 |
1877262 | 1877262 | 2021-11-02 | Cimarron | Oklahoma | 40025 | 329 | 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);