ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
458 rows where cases = 1008 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 38
- Missouri 28
- Puerto Rico 24
- Nebraska 22
- North Dakota 21
- Virginia 20
- Colorado 18
- Georgia 16
- Iowa 16
- Kentucky 16
- New Mexico 15
- Kansas 14
- Minnesota 14
- North Carolina 14
- Oklahoma 12
- Mississippi 11
- Tennessee 11
- Alabama 9
- Indiana 9
- Montana 9
- Wyoming 9
- California 8
- Louisiana 8
- South Dakota 8
- Washington 8
- Ohio 7
- Wisconsin 7
- Alaska 6
- Idaho 6
- Illinois 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500886 | 2500886 | 2022-05-13 | Ontonagon | Michigan | 26131 | 1008 | 38 |
2497628 | 2497628 | 2022-05-12 | Ontonagon | Michigan | 26131 | 1008 | 38 |
2494370 | 2494370 | 2022-05-11 | Ontonagon | Michigan | 26131 | 1008 | 38 |
2494909 | 2494909 | 2022-05-11 | Union | New Mexico | 35059 | 1008 | 16 |
2485136 | 2485136 | 2022-05-08 | Union | New Mexico | 35059 | 1008 | 16 |
2481878 | 2481878 | 2022-05-07 | Union | New Mexico | 35059 | 1008 | 16 |
2478620 | 2478620 | 2022-05-06 | Union | New Mexico | 35059 | 1008 | 16 |
2475362 | 2475362 | 2022-05-05 | Union | New Mexico | 35059 | 1008 | 16 |
2475545 | 2475545 | 2022-05-05 | LaMoure | North Dakota | 38045 | 1008 | 20 |
2472105 | 2472105 | 2022-05-04 | Union | New Mexico | 35059 | 1008 | 16 |
2472288 | 2472288 | 2022-05-04 | LaMoure | North Dakota | 38045 | 1008 | 20 |
2468849 | 2468849 | 2022-05-03 | Union | New Mexico | 35059 | 1008 | 16 |
2469032 | 2469032 | 2022-05-03 | LaMoure | North Dakota | 38045 | 1008 | 20 |
2465593 | 2465593 | 2022-05-02 | Union | New Mexico | 35059 | 1008 | 16 |
2465776 | 2465776 | 2022-05-02 | LaMoure | North Dakota | 38045 | 1008 | 20 |
2462338 | 2462338 | 2022-05-01 | Union | New Mexico | 35059 | 1008 | 16 |
2462521 | 2462521 | 2022-05-01 | LaMoure | North Dakota | 38045 | 1008 | 20 |
2459082 | 2459082 | 2022-04-30 | Union | New Mexico | 35059 | 1008 | 16 |
2459265 | 2459265 | 2022-04-30 | LaMoure | North Dakota | 38045 | 1008 | 20 |
2455826 | 2455826 | 2022-04-29 | Union | New Mexico | 35059 | 1008 | 16 |
2456009 | 2456009 | 2022-04-29 | LaMoure | North Dakota | 38045 | 1008 | 20 |
2452570 | 2452570 | 2022-04-28 | Union | New Mexico | 35059 | 1008 | 16 |
2439450 | 2439450 | 2022-04-24 | Sheridan | Nebraska | 31161 | 1008 | 23 |
2436194 | 2436194 | 2022-04-23 | Sheridan | Nebraska | 31161 | 1008 | 23 |
2432938 | 2432938 | 2022-04-22 | Sheridan | Nebraska | 31161 | 1008 | 23 |
2384399 | 2384399 | 2022-04-07 | Sargent | North Dakota | 38081 | 1008 | 9 |
2381144 | 2381144 | 2022-04-06 | Sargent | North Dakota | 38081 | 1008 | 9 |
2377889 | 2377889 | 2022-04-05 | Sargent | North Dakota | 38081 | 1008 | 9 |
2374636 | 2374636 | 2022-04-04 | Sargent | North Dakota | 38081 | 1008 | 9 |
2371384 | 2371384 | 2022-04-03 | Sargent | North Dakota | 38081 | 1008 | 9 |
2368131 | 2368131 | 2022-04-02 | Sargent | North Dakota | 38081 | 1008 | 9 |
2364878 | 2364878 | 2022-04-01 | Sargent | North Dakota | 38081 | 1008 | 9 |
2357727 | 2357727 | 2022-03-30 | Unknown | Minnesota | 1008 | 220 | |
2312825 | 2312825 | 2022-03-16 | Sargent | North Dakota | 38081 | 1008 | 9 |
2216549 | 2216549 | 2022-02-15 | Aleutians East Borough | Alaska | 2013 | 1008 | 3 |
2213298 | 2213298 | 2022-02-14 | Aleutians East Borough | Alaska | 2013 | 1008 | 3 |
2206147 | 2206147 | 2022-02-11 | Concho | Texas | 48095 | 1008 | 11 |
2195361 | 2195361 | 2022-02-08 | Phillips | Montana | 30071 | 1008 | 28 |
2188745 | 2188745 | 2022-02-06 | Holt | Missouri | 29087 | 1008 | 25 |
2190163 | 2190163 | 2022-02-06 | Craig | Virginia | 51045 | 1008 | 12 |
2186910 | 2186910 | 2022-02-05 | Craig | Virginia | 51045 | 1008 | 12 |
2183657 | 2183657 | 2022-02-04 | Craig | Virginia | 51045 | 1008 | 12 |
2179092 | 2179092 | 2022-02-03 | Mineral | Montana | 30061 | 1008 | 15 |
2180126 | 2180126 | 2022-02-03 | Crockett | Texas | 48105 | 1008 | 17 |
2172614 | 2172614 | 2022-02-01 | Antelope | Nebraska | 31003 | 1008 | 12 |
2173318 | 2173318 | 2022-02-01 | Las Marias | Puerto Rico | 72083 | 1008 | |
2173771 | 2173771 | 2022-02-01 | San Augustine | Texas | 48405 | 1008 | 38 |
2169361 | 2169361 | 2022-01-31 | Antelope | Nebraska | 31003 | 1008 | 12 |
2170066 | 2170066 | 2022-01-31 | Las Marias | Puerto Rico | 72083 | 1008 | |
2164974 | 2164974 | 2022-01-30 | Warren | Georgia | 13301 | 1008 | 27 |
2161719 | 2161719 | 2022-01-29 | Warren | Georgia | 13301 | 1008 | 27 |
2158463 | 2158463 | 2022-01-28 | Warren | Georgia | 13301 | 1008 | 27 |
2157548 | 2157548 | 2022-01-27 | Yoakum | Texas | 48501 | 1008 | 37 |
2151717 | 2151717 | 2022-01-26 | Saguache | Colorado | 8109 | 1008 | 10 |
2132934 | 2132934 | 2022-01-20 | Fulton | Kentucky | 21075 | 1008 | 23 |
2122656 | 2122656 | 2022-01-17 | Talbot | Georgia | 13263 | 1008 | 30 |
2110849 | 2110849 | 2022-01-13 | Kearney | Nebraska | 31099 | 1008 | 7 |
2108536 | 2108536 | 2022-01-12 | Carson | Texas | 48065 | 1008 | 30 |
2087870 | 2087870 | 2022-01-06 | Atchison | Missouri | 29005 | 1008 | 19 |
2083190 | 2083190 | 2022-01-05 | Dillingham Census Area | Alaska | 2070 | 1008 | 10 |
2079938 | 2079938 | 2022-01-04 | Dillingham Census Area | Alaska | 2070 | 1008 | 10 |
2080809 | 2080809 | 2022-01-04 | Kearny | Kansas | 20093 | 1008 | 17 |
2082379 | 2082379 | 2022-01-04 | Moody | South Dakota | 46101 | 1008 | 25 |
2076686 | 2076686 | 2022-01-03 | Dillingham Census Area | Alaska | 2070 | 1008 | 10 |
2077557 | 2077557 | 2022-01-03 | Kearny | Kansas | 20093 | 1008 | 17 |
2061693 | 2061693 | 2021-12-29 | Big Stone | Minnesota | 27011 | 1008 | 7 |
2059637 | 2059637 | 2021-12-28 | Walworth | South Dakota | 46129 | 1008 | 19 |
2055527 | 2055527 | 2021-12-27 | Toole | Montana | 30101 | 1008 | 21 |
2051199 | 2051199 | 2021-12-26 | Lemhi | Idaho | 16059 | 1008 | 23 |
2052277 | 2052277 | 2021-12-26 | Toole | Montana | 30101 | 1008 | 21 |
2053443 | 2053443 | 2021-12-26 | San Saba | Texas | 48411 | 1008 | 29 |
2047949 | 2047949 | 2021-12-25 | Lemhi | Idaho | 16059 | 1008 | 23 |
2049027 | 2049027 | 2021-12-25 | Toole | Montana | 30101 | 1008 | 21 |
2050193 | 2050193 | 2021-12-25 | San Saba | Texas | 48411 | 1008 | 29 |
2044699 | 2044699 | 2021-12-24 | Lemhi | Idaho | 16059 | 1008 | 23 |
2045777 | 2045777 | 2021-12-24 | Toole | Montana | 30101 | 1008 | 21 |
2046943 | 2046943 | 2021-12-24 | San Saba | Texas | 48411 | 1008 | 29 |
2041450 | 2041450 | 2021-12-23 | Lemhi | Idaho | 16059 | 1008 | 23 |
2042527 | 2042527 | 2021-12-23 | Toole | Montana | 30101 | 1008 | 21 |
2043693 | 2043693 | 2021-12-23 | San Saba | Texas | 48411 | 1008 | 29 |
2039278 | 2039278 | 2021-12-22 | Toole | Montana | 30101 | 1008 | 21 |
2014841 | 2014841 | 2021-12-14 | Crook | Wyoming | 56011 | 1008 | 22 |
2008115 | 2008115 | 2021-12-12 | Middlesex | Virginia | 51119 | 1008 | 33 |
2004864 | 2004864 | 2021-12-11 | Middlesex | Virginia | 51119 | 1008 | 33 |
2001613 | 2001613 | 2021-12-10 | Middlesex | Virginia | 51119 | 1008 | 33 |
1994848 | 1994848 | 2021-12-08 | Jack | Texas | 48237 | 1008 | 22 |
1994897 | 1994897 | 2021-12-08 | Mitchell | Texas | 48335 | 1008 | 43 |
1991646 | 1991646 | 2021-12-07 | Mitchell | Texas | 48335 | 1008 | 43 |
1982591 | 1982591 | 2021-12-05 | Trinity | California | 6105 | 1008 | 17 |
1979341 | 1979341 | 2021-12-04 | Trinity | California | 6105 | 1008 | 17 |
1976091 | 1976091 | 2021-12-03 | Trinity | California | 6105 | 1008 | 17 |
1978212 | 1978212 | 2021-12-03 | Florida | Puerto Rico | 72054 | 1008 | |
1972842 | 1972842 | 2021-12-02 | Trinity | California | 6105 | 1008 | 17 |
1961334 | 1961334 | 2021-11-28 | Nemaha | Nebraska | 31127 | 1008 | 16 |
1958083 | 1958083 | 2021-11-27 | Nemaha | Nebraska | 31127 | 1008 | 16 |
1958379 | 1958379 | 2021-11-27 | McHenry | North Dakota | 38049 | 1008 | 27 |
1954832 | 1954832 | 2021-11-26 | Nemaha | Nebraska | 31127 | 1008 | 16 |
1951581 | 1951581 | 2021-11-25 | Nemaha | Nebraska | 31127 | 1008 | 16 |
1948330 | 1948330 | 2021-11-24 | Nemaha | Nebraska | 31127 | 1008 | 16 |
1941838 | 1941838 | 2021-11-22 | Richardson | Nebraska | 31147 | 1008 | 24 |
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);