ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
397 rows where cases = 1200 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 36
- Virginia 35
- Iowa 24
- Georgia 22
- Kentucky 20
- Missouri 18
- Puerto Rico 17
- Nebraska 15
- Minnesota 13
- Kansas 11
- Mississippi 11
- North Carolina 11
- Oklahoma 11
- Wisconsin 11
- Tennessee 10
- West Virginia 10
- Louisiana 8
- Utah 8
- Colorado 7
- Illinois 7
- Montana 7
- Wyoming 7
- Alabama 6
- Arkansas 6
- Indiana 6
- Michigan 6
- Idaho 5
- New Jersey 5
- Alaska 4
- New York 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493359 | 2493359 | 2022-05-11 | Saguache | Colorado | 8109 | 1200 | 12 |
2490101 | 2490101 | 2022-05-10 | Saguache | Colorado | 8109 | 1200 | 12 |
2491500 | 2491500 | 2022-05-10 | Dixon | Nebraska | 31051 | 1200 | 11 |
2486844 | 2486844 | 2022-05-09 | Saguache | Colorado | 8109 | 1200 | 12 |
2488242 | 2488242 | 2022-05-09 | Dixon | Nebraska | 31051 | 1200 | 11 |
2484985 | 2484985 | 2022-05-08 | Dixon | Nebraska | 31051 | 1200 | 11 |
2481727 | 2481727 | 2022-05-07 | Dixon | Nebraska | 31051 | 1200 | 11 |
2478469 | 2478469 | 2022-05-06 | Dixon | Nebraska | 31051 | 1200 | 11 |
2475211 | 2475211 | 2022-05-05 | Dixon | Nebraska | 31051 | 1200 | 11 |
2465442 | 2465442 | 2022-05-02 | Dixon | Nebraska | 31051 | 1200 | 11 |
2439395 | 2439395 | 2022-04-24 | Dixon | Nebraska | 31051 | 1200 | 11 |
2436139 | 2436139 | 2022-04-23 | Dixon | Nebraska | 31051 | 1200 | 11 |
2432883 | 2432883 | 2022-04-22 | Dixon | Nebraska | 31051 | 1200 | 11 |
2427459 | 2427459 | 2022-04-20 | Martin | Texas | 48317 | 1200 | 26 |
2424203 | 2424203 | 2022-04-19 | Martin | Texas | 48317 | 1200 | 26 |
2420947 | 2420947 | 2022-04-18 | Martin | Texas | 48317 | 1200 | 26 |
2417623 | 2417623 | 2022-04-17 | Goliad | Texas | 48175 | 1200 | 32 |
2417691 | 2417691 | 2022-04-17 | Martin | Texas | 48317 | 1200 | 26 |
2414367 | 2414367 | 2022-04-16 | Goliad | Texas | 48175 | 1200 | 32 |
2414435 | 2414435 | 2022-04-16 | Martin | Texas | 48317 | 1200 | 26 |
2411111 | 2411111 | 2022-04-15 | Goliad | Texas | 48175 | 1200 | 32 |
2411179 | 2411179 | 2022-04-15 | Martin | Texas | 48317 | 1200 | 26 |
2407855 | 2407855 | 2022-04-14 | Goliad | Texas | 48175 | 1200 | 32 |
2407923 | 2407923 | 2022-04-14 | Martin | Texas | 48317 | 1200 | 26 |
2404599 | 2404599 | 2022-04-13 | Goliad | Texas | 48175 | 1200 | 32 |
2401344 | 2401344 | 2022-04-12 | Goliad | Texas | 48175 | 1200 | 32 |
2398089 | 2398089 | 2022-04-11 | Goliad | Texas | 48175 | 1200 | 32 |
2394834 | 2394834 | 2022-04-10 | Goliad | Texas | 48175 | 1200 | 32 |
2391578 | 2391578 | 2022-04-09 | Goliad | Texas | 48175 | 1200 | 32 |
2388322 | 2388322 | 2022-04-08 | Goliad | Texas | 48175 | 1200 | 32 |
2215492 | 2215492 | 2022-02-14 | Wallowa | Oregon | 41063 | 1200 | 14 |
2212241 | 2212241 | 2022-02-13 | Wallowa | Oregon | 41063 | 1200 | 14 |
2208988 | 2208988 | 2022-02-12 | Wallowa | Oregon | 41063 | 1200 | 14 |
2205735 | 2205735 | 2022-02-11 | Wallowa | Oregon | 41063 | 1200 | 14 |
2183527 | 2183527 | 2022-02-04 | Sabine | Texas | 48403 | 1200 | 78 |
2165037 | 2165037 | 2022-01-30 | Alexander | Illinois | 17003 | 1200 | 13 |
2161782 | 2161782 | 2022-01-29 | Alexander | Illinois | 17003 | 1200 | 13 |
2158527 | 2158527 | 2022-01-28 | Alexander | Illinois | 17003 | 1200 | 13 |
2154311 | 2154311 | 2022-01-26 | Kane | Utah | 49025 | 1200 | 13 |
2131156 | 2131156 | 2022-01-19 | Moody | South Dakota | 46101 | 1200 | 25 |
2124498 | 2124498 | 2022-01-17 | Guanica | Puerto Rico | 72055 | 1200 | |
2085134 | 2085134 | 2022-01-05 | Dickey | North Dakota | 38021 | 1200 | 38 |
2076744 | 2076744 | 2022-01-03 | Dallas | Arkansas | 5039 | 1200 | 21 |
2033836 | 2033836 | 2021-12-20 | Hansford | Texas | 48195 | 1200 | 27 |
2030586 | 2030586 | 2021-12-19 | Hansford | Texas | 48195 | 1200 | 27 |
2027335 | 2027335 | 2021-12-18 | Hansford | Texas | 48195 | 1200 | 27 |
2021112 | 2021112 | 2021-12-16 | Madison | Virginia | 51113 | 1200 | 23 |
2016637 | 2016637 | 2021-12-15 | Pershing | Nevada | 32027 | 1200 | 28 |
2005383 | 2005383 | 2021-12-12 | Kit Carson | Colorado | 8063 | 1200 | 24 |
2002132 | 2002132 | 2021-12-11 | Kit Carson | Colorado | 8063 | 1200 | 24 |
2003375 | 2003375 | 2021-12-11 | Clark | Missouri | 29045 | 1200 | 27 |
2004636 | 2004636 | 2021-12-11 | Marion | Texas | 48315 | 1200 | 53 |
1998882 | 1998882 | 2021-12-10 | Kit Carson | Colorado | 8063 | 1200 | 24 |
2000125 | 2000125 | 2021-12-10 | Clark | Missouri | 29045 | 1200 | 27 |
2001385 | 2001385 | 2021-12-10 | Marion | Texas | 48315 | 1200 | 53 |
1998369 | 1998369 | 2021-12-09 | Northampton | Virginia | 51131 | 1200 | 47 |
1960964 | 1960964 | 2021-11-28 | Lac qui Parle | Minnesota | 27073 | 1200 | 25 |
1962601 | 1962601 | 2021-11-28 | Lunenburg | Virginia | 51111 | 1200 | 22 |
1957713 | 1957713 | 2021-11-27 | Lac qui Parle | Minnesota | 27073 | 1200 | 25 |
1959350 | 1959350 | 2021-11-27 | Lunenburg | Virginia | 51111 | 1200 | 22 |
1954462 | 1954462 | 2021-11-26 | Lac qui Parle | Minnesota | 27073 | 1200 | 25 |
1956099 | 1956099 | 2021-11-26 | Lunenburg | Virginia | 51111 | 1200 | 22 |
1952848 | 1952848 | 2021-11-25 | Lunenburg | Virginia | 51111 | 1200 | 22 |
1949597 | 1949597 | 2021-11-24 | Lunenburg | Virginia | 51111 | 1200 | 22 |
1941604 | 1941604 | 2021-11-22 | Caldwell | Missouri | 29025 | 1200 | 25 |
1942014 | 1942014 | 2021-11-22 | Camden | North Carolina | 37029 | 1200 | 8 |
1938354 | 1938354 | 2021-11-21 | Caldwell | Missouri | 29025 | 1200 | 25 |
1935104 | 1935104 | 2021-11-20 | Caldwell | Missouri | 29025 | 1200 | 25 |
1927251 | 1927251 | 2021-11-18 | Monroe | Arkansas | 5095 | 1200 | 25 |
1925383 | 1925383 | 2021-11-17 | Hickory | Missouri | 29085 | 1200 | 21 |
1921449 | 1921449 | 2021-11-16 | Lucas | Iowa | 19117 | 1200 | 24 |
1918199 | 1918199 | 2021-11-15 | Lucas | Iowa | 19117 | 1200 | 24 |
1920481 | 1920481 | 2021-11-15 | Pocahontas | West Virginia | 54075 | 1200 | 18 |
1914949 | 1914949 | 2021-11-14 | Lucas | Iowa | 19117 | 1200 | 24 |
1917240 | 1917240 | 2021-11-14 | Tucker | West Virginia | 54093 | 1200 | 30 |
1911699 | 1911699 | 2021-11-13 | Lucas | Iowa | 19117 | 1200 | 24 |
1908450 | 1908450 | 2021-11-12 | Lucas | Iowa | 19117 | 1200 | 24 |
1909935 | 1909935 | 2021-11-12 | Barceloneta | Puerto Rico | 72017 | 1200 | |
1904826 | 1904826 | 2021-11-11 | Lincoln | Georgia | 13181 | 1200 | 33 |
1905201 | 1905201 | 2021-11-11 | Lucas | Iowa | 19117 | 1200 | 24 |
1906686 | 1906686 | 2021-11-11 | Barceloneta | Puerto Rico | 72017 | 1200 | |
1907166 | 1907166 | 2021-11-11 | Refugio | Texas | 48391 | 1200 | 31 |
1901576 | 1901576 | 2021-11-10 | Lincoln | Georgia | 13181 | 1200 | 33 |
1901951 | 1901951 | 2021-11-10 | Lucas | Iowa | 19117 | 1200 | 24 |
1903437 | 1903437 | 2021-11-10 | Barceloneta | Puerto Rico | 72017 | 1200 | |
1903917 | 1903917 | 2021-11-10 | Refugio | Texas | 48391 | 1200 | 31 |
1900187 | 1900187 | 2021-11-09 | Barceloneta | Puerto Rico | 72017 | 1200 | |
1900667 | 1900667 | 2021-11-09 | Refugio | Texas | 48391 | 1200 | 31 |
1896937 | 1896937 | 2021-11-08 | Barceloneta | Puerto Rico | 72017 | 1200 | |
1887996 | 1887996 | 2021-11-05 | Webster | West Virginia | 54101 | 1200 | 18 |
1884746 | 1884746 | 2021-11-04 | Webster | West Virginia | 54101 | 1200 | 18 |
1884797 | 1884797 | 2021-11-04 | Pepin | Wisconsin | 55091 | 1200 | 10 |
1845479 | 1845479 | 2021-10-23 | Winkler | Texas | 48495 | 1200 | 28 |
1840962 | 1840962 | 2021-10-22 | Sullivan | Missouri | 29211 | 1200 | 14 |
1842464 | 1842464 | 2021-10-22 | Doddridge | West Virginia | 54017 | 1200 | 10 |
1837542 | 1837542 | 2021-10-21 | Franklin | Mississippi | 28037 | 1200 | 28 |
1828052 | 1828052 | 2021-10-18 | Custer | Nebraska | 31041 | 1200 | 21 |
1811878 | 1811878 | 2021-10-13 | Wayne | Nebraska | 31179 | 1200 | 8 |
1804142 | 1804142 | 2021-10-11 | Terrell | Georgia | 13273 | 1200 | 56 |
1800893 | 1800893 | 2021-10-10 | Terrell | Georgia | 13273 | 1200 | 56 |
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);