ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
478 rows where cases = 1038 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 41
- Kentucky 34
- Minnesota 31
- Kansas 27
- North Dakota 26
- Texas 24
- Georgia 22
- Oklahoma 19
- Virginia 18
- Puerto Rico 15
- South Dakota 15
- Iowa 14
- Montana 14
- Illinois 13
- Nebraska 13
- Indiana 12
- Mississippi 11
- Wyoming 11
- Arkansas 9
- Tennessee 9
- Colorado 8
- Oregon 8
- Alabama 7
- Florida 7
- Idaho 7
- Louisiana 7
- Pennsylvania 7
- Wisconsin 6
- Alaska 4
- Maine 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469487 | 2469487 | 2022-05-03 | Deuel | South Dakota | 46039 | 1038 | 12 |
2466231 | 2466231 | 2022-05-02 | Deuel | South Dakota | 46039 | 1038 | 12 |
2462976 | 2462976 | 2022-05-01 | Deuel | South Dakota | 46039 | 1038 | 12 |
2459720 | 2459720 | 2022-04-30 | Deuel | South Dakota | 46039 | 1038 | 12 |
2456464 | 2456464 | 2022-04-29 | Deuel | South Dakota | 46039 | 1038 | 12 |
2453208 | 2453208 | 2022-04-28 | Deuel | South Dakota | 46039 | 1038 | 12 |
2449952 | 2449952 | 2022-04-27 | Deuel | South Dakota | 46039 | 1038 | 12 |
2450501 | 2450501 | 2022-04-27 | Rappahannock | Virginia | 51157 | 1038 | 10 |
2447244 | 2447244 | 2022-04-26 | Rappahannock | Virginia | 51157 | 1038 | 10 |
2429951 | 2429951 | 2022-04-21 | Dunn | North Dakota | 38025 | 1038 | 8 |
2426695 | 2426695 | 2022-04-20 | Dunn | North Dakota | 38025 | 1038 | 8 |
2423439 | 2423439 | 2022-04-19 | Dunn | North Dakota | 38025 | 1038 | 8 |
2420182 | 2420182 | 2022-04-18 | Dunn | North Dakota | 38025 | 1038 | 8 |
2416312 | 2416312 | 2022-04-17 | Unknown | Minnesota | 1038 | 250 | |
2416927 | 2416927 | 2022-04-17 | Dunn | North Dakota | 38025 | 1038 | 8 |
2413056 | 2413056 | 2022-04-16 | Unknown | Minnesota | 1038 | 250 | |
2413671 | 2413671 | 2022-04-16 | Dunn | North Dakota | 38025 | 1038 | 8 |
2409800 | 2409800 | 2022-04-15 | Unknown | Minnesota | 1038 | 250 | |
2410415 | 2410415 | 2022-04-15 | Dunn | North Dakota | 38025 | 1038 | 8 |
2406037 | 2406037 | 2022-04-14 | Barber | Kansas | 20007 | 1038 | 8 |
2407159 | 2407159 | 2022-04-14 | Dunn | North Dakota | 38025 | 1038 | 8 |
2402781 | 2402781 | 2022-04-13 | Barber | Kansas | 20007 | 1038 | 8 |
2403903 | 2403903 | 2022-04-13 | Dunn | North Dakota | 38025 | 1038 | 8 |
2399527 | 2399527 | 2022-04-12 | Barber | Kansas | 20007 | 1038 | 8 |
2400648 | 2400648 | 2022-04-12 | Dunn | North Dakota | 38025 | 1038 | 8 |
2396271 | 2396271 | 2022-04-11 | Barber | Kansas | 20007 | 1038 | 8 |
2397393 | 2397393 | 2022-04-11 | Dunn | North Dakota | 38025 | 1038 | 8 |
2393016 | 2393016 | 2022-04-10 | Barber | Kansas | 20007 | 1038 | 8 |
2394138 | 2394138 | 2022-04-10 | Dunn | North Dakota | 38025 | 1038 | 8 |
2389760 | 2389760 | 2022-04-09 | Barber | Kansas | 20007 | 1038 | 8 |
2390882 | 2390882 | 2022-04-09 | Dunn | North Dakota | 38025 | 1038 | 8 |
2386504 | 2386504 | 2022-04-08 | Barber | Kansas | 20007 | 1038 | 8 |
2387626 | 2387626 | 2022-04-08 | Dunn | North Dakota | 38025 | 1038 | 8 |
2383250 | 2383250 | 2022-04-07 | Barber | Kansas | 20007 | 1038 | 8 |
2384371 | 2384371 | 2022-04-07 | Dunn | North Dakota | 38025 | 1038 | 8 |
2379995 | 2379995 | 2022-04-06 | Barber | Kansas | 20007 | 1038 | 8 |
2380457 | 2380457 | 2022-04-06 | Kittson | Minnesota | 27069 | 1038 | 27 |
2381116 | 2381116 | 2022-04-06 | Dunn | North Dakota | 38025 | 1038 | 8 |
2376740 | 2376740 | 2022-04-05 | Barber | Kansas | 20007 | 1038 | 8 |
2377202 | 2377202 | 2022-04-05 | Kittson | Minnesota | 27069 | 1038 | 27 |
2377861 | 2377861 | 2022-04-05 | Dunn | North Dakota | 38025 | 1038 | 8 |
2373488 | 2373488 | 2022-04-04 | Barber | Kansas | 20007 | 1038 | 8 |
2374608 | 2374608 | 2022-04-04 | Dunn | North Dakota | 38025 | 1038 | 8 |
2375268 | 2375268 | 2022-04-04 | Crockett | Texas | 48105 | 1038 | 19 |
2370235 | 2370235 | 2022-04-03 | Barber | Kansas | 20007 | 1038 | 8 |
2371356 | 2371356 | 2022-04-03 | Dunn | North Dakota | 38025 | 1038 | 8 |
2372016 | 2372016 | 2022-04-03 | Crockett | Texas | 48105 | 1038 | 19 |
2366982 | 2366982 | 2022-04-02 | Barber | Kansas | 20007 | 1038 | 8 |
2368103 | 2368103 | 2022-04-02 | Dunn | North Dakota | 38025 | 1038 | 8 |
2368763 | 2368763 | 2022-04-02 | Crockett | Texas | 48105 | 1038 | 19 |
2363729 | 2363729 | 2022-04-01 | Barber | Kansas | 20007 | 1038 | 8 |
2364850 | 2364850 | 2022-04-01 | Dunn | North Dakota | 38025 | 1038 | 8 |
2365510 | 2365510 | 2022-04-01 | Crockett | Texas | 48105 | 1038 | 19 |
2360475 | 2360475 | 2022-03-31 | Barber | Kansas | 20007 | 1038 | 8 |
2357221 | 2357221 | 2022-03-30 | Barber | Kansas | 20007 | 1038 | 8 |
2292165 | 2292165 | 2022-03-10 | Barber | Kansas | 20007 | 1038 | 8 |
2288319 | 2288319 | 2022-03-09 | Washington | Colorado | 8121 | 1038 | 27 |
2288913 | 2288913 | 2022-03-09 | Barber | Kansas | 20007 | 1038 | 8 |
2285662 | 2285662 | 2022-03-08 | Barber | Kansas | 20007 | 1038 | 8 |
2282410 | 2282410 | 2022-03-07 | Barber | Kansas | 20007 | 1038 | 8 |
2260394 | 2260394 | 2022-02-28 | Phillips | Montana | 30071 | 1038 | 28 |
2257143 | 2257143 | 2022-02-27 | Phillips | Montana | 30071 | 1038 | 28 |
2253892 | 2253892 | 2022-02-26 | Phillips | Montana | 30071 | 1038 | 28 |
2250641 | 2250641 | 2022-02-25 | Phillips | Montana | 30071 | 1038 | 28 |
2251314 | 2251314 | 2022-02-25 | Sullivan | Pennsylvania | 42113 | 1038 | 36 |
2247390 | 2247390 | 2022-02-24 | Phillips | Montana | 30071 | 1038 | 28 |
2248063 | 2248063 | 2022-02-24 | Sullivan | Pennsylvania | 42113 | 1038 | 36 |
2244812 | 2244812 | 2022-02-23 | Sullivan | Pennsylvania | 42113 | 1038 | 36 |
2241561 | 2241561 | 2022-02-22 | Sullivan | Pennsylvania | 42113 | 1038 | 35 |
2238816 | 2238816 | 2022-02-21 | San Augustine | Texas | 48405 | 1038 | 40 |
2235565 | 2235565 | 2022-02-20 | San Augustine | Texas | 48405 | 1038 | 40 |
2228882 | 2228882 | 2022-02-18 | Brewster | Texas | 48043 | 1038 | 25 |
2225631 | 2225631 | 2022-02-17 | Brewster | Texas | 48043 | 1038 | 25 |
2220368 | 2220368 | 2022-02-16 | Hardin | Illinois | 17069 | 1038 | 19 |
2214906 | 2214906 | 2022-02-14 | Boone | Nebraska | 31011 | 1038 | 4 |
2211654 | 2211654 | 2022-02-13 | Boone | Nebraska | 31011 | 1038 | 4 |
2208401 | 2208401 | 2022-02-12 | Boone | Nebraska | 31011 | 1038 | 4 |
2205148 | 2205148 | 2022-02-11 | Boone | Nebraska | 31011 | 1038 | 4 |
2167674 | 2167674 | 2022-01-30 | Hot Springs | Wyoming | 56017 | 1038 | 14 |
2164419 | 2164419 | 2022-01-29 | Hot Springs | Wyoming | 56017 | 1038 | 14 |
2161164 | 2161164 | 2022-01-28 | Hot Springs | Wyoming | 56017 | 1038 | 14 |
2157689 | 2157689 | 2022-01-27 | Norton city | Virginia | 51720 | 1038 | 20 |
2150427 | 2150427 | 2022-01-25 | Wallowa | Oregon | 41063 | 1038 | 13 |
2128461 | 2128461 | 2022-01-18 | Ferry | Washington | 53019 | 1038 | 19 |
2086351 | 2086351 | 2022-01-05 | Crook | Wyoming | 56011 | 1038 | 22 |
2020140 | 2020140 | 2021-12-16 | McHenry | North Dakota | 38049 | 1038 | 28 |
1983448 | 1983448 | 2021-12-05 | Owsley | Kentucky | 21189 | 1038 | 21 |
1980198 | 1980198 | 2021-12-04 | Owsley | Kentucky | 21189 | 1038 | 21 |
1976948 | 1976948 | 2021-12-03 | Owsley | Kentucky | 21189 | 1038 | 21 |
1978261 | 1978261 | 2021-12-03 | Villalba | Puerto Rico | 72149 | 1038 | |
1960981 | 1960981 | 2021-11-28 | Norman | Minnesota | 27107 | 1038 | 9 |
1962279 | 1962279 | 2021-11-28 | Crosby | Texas | 48107 | 1038 | 37 |
1957730 | 1957730 | 2021-11-27 | Norman | Minnesota | 27107 | 1038 | 9 |
1959028 | 1959028 | 2021-11-27 | Crosby | Texas | 48107 | 1038 | 37 |
1954479 | 1954479 | 2021-11-26 | Norman | Minnesota | 27107 | 1038 | 9 |
1955777 | 1955777 | 2021-11-26 | Crosby | Texas | 48107 | 1038 | 37 |
1952526 | 1952526 | 2021-11-25 | Crosby | Texas | 48107 | 1038 | 37 |
1949275 | 1949275 | 2021-11-24 | Crosby | Texas | 48107 | 1038 | 37 |
1946024 | 1946024 | 2021-11-23 | Crosby | Texas | 48107 | 1038 | 37 |
1933451 | 1933451 | 2021-11-19 | Calhoun | West Virginia | 54013 | 1038 | 5 |
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);