ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,399 rows where cases = 45 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 195
- Georgia 131
- Nebraska 108
- Illinois 100
- Kentucky 96
- Missouri 96
- Kansas 95
- Virginia 93
- Ohio 82
- Puerto Rico 80
- Oklahoma 75
- Minnesota 74
- West Virginia 71
- Tennessee 64
- North Dakota 59
- Colorado 58
- Wisconsin 57
- Indiana 55
- North Carolina 55
- Iowa 53
- Michigan 52
- Arkansas 46
- Mississippi 46
- Oregon 44
- Alabama 38
- South Dakota 38
- Vermont 35
- New York 33
- Idaho 32
- Montana 32
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2378604 | 2378604 | 2022-04-05 | King | Texas | 48269 | 45 | 0 |
2124192 | 2124192 | 2022-01-17 | Unknown | North Dakota | 45 | 45 | |
2120940 | 2120940 | 2022-01-16 | Unknown | North Dakota | 45 | 45 | |
2117688 | 2117688 | 2022-01-15 | Unknown | North Dakota | 45 | 45 | |
2114437 | 2114437 | 2022-01-14 | Unknown | North Dakota | 45 | 45 | |
2111185 | 2111185 | 2022-01-13 | Unknown | North Dakota | 45 | 45 | |
2107933 | 2107933 | 2022-01-12 | Unknown | North Dakota | 45 | 45 | |
2104682 | 2104682 | 2022-01-11 | Unknown | North Dakota | 45 | 45 | |
2101431 | 2101431 | 2022-01-10 | Unknown | North Dakota | 45 | 45 | |
2098180 | 2098180 | 2022-01-09 | Unknown | North Dakota | 45 | 45 | |
2094928 | 2094928 | 2022-01-08 | Unknown | North Dakota | 45 | 45 | |
2091676 | 2091676 | 2022-01-07 | Unknown | North Dakota | 45 | 45 | |
2088425 | 2088425 | 2022-01-06 | Unknown | North Dakota | 45 | 45 | |
2085173 | 2085173 | 2022-01-05 | Unknown | North Dakota | 45 | 45 | |
2081921 | 2081921 | 2022-01-04 | Unknown | North Dakota | 45 | 45 | |
2078669 | 2078669 | 2022-01-03 | Unknown | North Dakota | 45 | 45 | |
2075418 | 2075418 | 2022-01-02 | Unknown | North Dakota | 45 | 45 | |
2072167 | 2072167 | 2022-01-01 | Unknown | North Dakota | 45 | 45 | |
2068916 | 2068916 | 2021-12-31 | Unknown | North Dakota | 45 | 45 | |
2065665 | 2065665 | 2021-12-30 | Unknown | North Dakota | 45 | 45 | |
2062415 | 2062415 | 2021-12-29 | Unknown | North Dakota | 45 | 45 | |
2063002 | 2063002 | 2021-12-29 | Borden | Texas | 48033 | 45 | 2 |
2059166 | 2059166 | 2021-12-28 | Unknown | North Dakota | 45 | 45 | |
2059752 | 2059752 | 2021-12-28 | Borden | Texas | 48033 | 45 | 2 |
2056503 | 2056503 | 2021-12-27 | Borden | Texas | 48033 | 45 | 2 |
2051497 | 2051497 | 2021-12-26 | Unknown | Iowa | 45 | 0 | |
2048247 | 2048247 | 2021-12-25 | Unknown | Iowa | 45 | 0 | |
2044997 | 2044997 | 2021-12-24 | Unknown | Iowa | 45 | 0 | |
2041748 | 2041748 | 2021-12-23 | Unknown | Iowa | 45 | 0 | |
2038498 | 2038498 | 2021-12-22 | Unknown | Iowa | 45 | 0 | |
1987277 | 1987277 | 2021-12-06 | Blaine | Nebraska | 31009 | 45 | 1 |
1984027 | 1984027 | 2021-12-05 | Blaine | Nebraska | 31009 | 45 | 1 |
1980777 | 1980777 | 2021-12-04 | Blaine | Nebraska | 31009 | 45 | 1 |
1977527 | 1977527 | 2021-12-03 | Blaine | Nebraska | 31009 | 45 | 1 |
1974277 | 1974277 | 2021-12-02 | Blaine | Nebraska | 31009 | 45 | 1 |
1971028 | 1971028 | 2021-12-01 | Blaine | Nebraska | 31009 | 45 | 1 |
1891017 | 1891017 | 2021-11-06 | Unknown | Vermont | 45 | 0 | |
1860903 | 1860903 | 2021-10-28 | Slope | North Dakota | 38087 | 45 | 0 |
1789102 | 1789102 | 2021-10-06 | McPherson | Nebraska | 31117 | 45 | 1 |
1785854 | 1785854 | 2021-10-05 | McPherson | Nebraska | 31117 | 45 | 1 |
1782605 | 1782605 | 2021-10-04 | McPherson | Nebraska | 31117 | 45 | 1 |
1779299 | 1779299 | 2021-10-03 | Banner | Nebraska | 31007 | 45 | 0 |
1779355 | 1779355 | 2021-10-03 | McPherson | Nebraska | 31117 | 45 | 1 |
1776049 | 1776049 | 2021-10-02 | Banner | Nebraska | 31007 | 45 | 0 |
1776105 | 1776105 | 2021-10-02 | McPherson | Nebraska | 31117 | 45 | 1 |
1772799 | 1772799 | 2021-10-01 | Banner | Nebraska | 31007 | 45 | 0 |
1772855 | 1772855 | 2021-10-01 | McPherson | Nebraska | 31117 | 45 | 1 |
1763052 | 1763052 | 2021-09-28 | Banner | Nebraska | 31007 | 45 | 0 |
1743614 | 1743614 | 2021-09-22 | Loup | Nebraska | 31115 | 45 | 0 |
1737141 | 1737141 | 2021-09-20 | Sioux | Nebraska | 31165 | 45 | 1 |
1714414 | 1714414 | 2021-09-13 | Esmeralda | Nevada | 32009 | 45 | 0 |
1711168 | 1711168 | 2021-09-12 | Esmeralda | Nevada | 32009 | 45 | 0 |
1707921 | 1707921 | 2021-09-11 | Esmeralda | Nevada | 32009 | 45 | 0 |
1704674 | 1704674 | 2021-09-10 | Esmeralda | Nevada | 32009 | 45 | 0 |
1654448 | 1654448 | 2021-08-26 | Hinsdale | Colorado | 8053 | 45 | 0 |
1647769 | 1647769 | 2021-08-24 | Skagway Municipality | Alaska | 2230 | 45 | 0 |
1644520 | 1644520 | 2021-08-23 | Skagway Municipality | Alaska | 2230 | 45 | 0 |
1630541 | 1630541 | 2021-08-18 | Culebra | Puerto Rico | 72049 | 45 | |
1630940 | 1630940 | 2021-08-18 | Kenedy | Texas | 48261 | 45 | 2 |
1627294 | 1627294 | 2021-08-17 | Culebra | Puerto Rico | 72049 | 45 | |
1627693 | 1627693 | 2021-08-17 | Kenedy | Texas | 48261 | 45 | 2 |
1624047 | 1624047 | 2021-08-16 | Culebra | Puerto Rico | 72049 | 45 | |
1620800 | 1620800 | 2021-08-15 | Culebra | Puerto Rico | 72049 | 45 | |
1617552 | 1617552 | 2021-08-14 | Culebra | Puerto Rico | 72049 | 45 | |
1614304 | 1614304 | 2021-08-13 | Culebra | Puerto Rico | 72049 | 45 | |
1611055 | 1611055 | 2021-08-12 | Culebra | Puerto Rico | 72049 | 45 | |
1607807 | 1607807 | 2021-08-11 | Culebra | Puerto Rico | 72049 | 45 | |
1604558 | 1604558 | 2021-08-10 | Culebra | Puerto Rico | 72049 | 45 | |
1601309 | 1601309 | 2021-08-09 | Culebra | Puerto Rico | 72049 | 45 | |
1598061 | 1598061 | 2021-08-08 | Culebra | Puerto Rico | 72049 | 45 | |
1594812 | 1594812 | 2021-08-07 | Culebra | Puerto Rico | 72049 | 45 | |
1578472 | 1578472 | 2021-08-02 | Wheeler | Oregon | 41069 | 45 | 1 |
1307062 | 1307062 | 2021-05-11 | San Juan | Colorado | 8111 | 45 | 0 |
1303816 | 1303816 | 2021-05-10 | San Juan | Colorado | 8111 | 45 | 0 |
1300569 | 1300569 | 2021-05-09 | San Juan | Colorado | 8111 | 45 | 0 |
1297322 | 1297322 | 2021-05-08 | San Juan | Colorado | 8111 | 45 | 0 |
1294076 | 1294076 | 2021-05-07 | San Juan | Colorado | 8111 | 45 | 0 |
1190159 | 1190159 | 2021-04-05 | San Juan | Colorado | 8111 | 45 | 0 |
1186912 | 1186912 | 2021-04-04 | San Juan | Colorado | 8111 | 45 | 0 |
1183665 | 1183665 | 2021-04-03 | San Juan | Colorado | 8111 | 45 | 0 |
1180418 | 1180418 | 2021-04-02 | San Juan | Colorado | 8111 | 45 | 0 |
1177171 | 1177171 | 2021-04-01 | San Juan | Colorado | 8111 | 45 | 0 |
1024525 | 1024525 | 2021-02-13 | Sierra | California | 6091 | 45 | 0 |
1021280 | 1021280 | 2021-02-12 | Sierra | California | 6091 | 45 | 0 |
1018035 | 1018035 | 2021-02-11 | Sierra | California | 6091 | 45 | 0 |
1014644 | 1014644 | 2021-02-10 | Petersburg Borough | Alaska | 2195 | 45 | 0 |
1011399 | 1011399 | 2021-02-09 | Petersburg Borough | Alaska | 2195 | 45 | 0 |
1008153 | 1008153 | 2021-02-08 | Petersburg Borough | Alaska | 2195 | 45 | 0 |
1004907 | 1004907 | 2021-02-07 | Petersburg Borough | Alaska | 2195 | 45 | 0 |
1005095 | 1005095 | 2021-02-07 | Jackson | Colorado | 8057 | 45 | 0 |
1001661 | 1001661 | 2021-02-06 | Petersburg Borough | Alaska | 2195 | 45 | 0 |
1001849 | 1001849 | 2021-02-06 | Jackson | Colorado | 8057 | 45 | 0 |
998415 | 998415 | 2021-02-05 | Petersburg Borough | Alaska | 2195 | 45 | 0 |
998603 | 998603 | 2021-02-05 | Jackson | Colorado | 8057 | 45 | 0 |
995169 | 995169 | 2021-02-04 | Petersburg Borough | Alaska | 2195 | 45 | 0 |
995357 | 995357 | 2021-02-04 | Jackson | Colorado | 8057 | 45 | 0 |
992111 | 992111 | 2021-02-03 | Jackson | Colorado | 8057 | 45 | 0 |
988865 | 988865 | 2021-02-02 | Jackson | Colorado | 8057 | 45 | 0 |
985618 | 985618 | 2021-02-01 | Jackson | Colorado | 8057 | 45 | 0 |
982371 | 982371 | 2021-01-31 | Jackson | Colorado | 8057 | 45 | 0 |
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);