ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
76 rows where cases = 6273 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Oklahoma 14
- Minnesota 8
- Tennessee 8
- Virginia 5
- Idaho 4
- Texas 4
- Louisiana 3
- Michigan 3
- North Carolina 3
- Alabama 2
- Arkansas 2
- Indiana 2
- Missouri 2
- New York 2
- Pennsylvania 2
- California 1
- Colorado 1
- Georgia 1
- Kentucky 1
- Mississippi 1
- Ohio 1
- Oregon 1
- South Carolina 1
- Vermont 1
- Washington 1
- West Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2422578 | 2422578 | 2022-04-19 | Pointe Coupee | Louisiana | 22077 | 6273 | 93 |
2419322 | 2419322 | 2022-04-18 | Pointe Coupee | Louisiana | 22077 | 6273 | 93 |
2385273 | 2385273 | 2022-04-07 | Orleans | Vermont | 50019 | 6273 | 37 |
2217645 | 2217645 | 2022-02-15 | Sabine | Louisiana | 22085 | 6273 | 108 |
2188500 | 2188500 | 2022-02-06 | Mason | Michigan | 26105 | 6273 | 80 |
2185247 | 2185247 | 2022-02-05 | Mason | Michigan | 26105 | 6273 | 80 |
2181995 | 2181995 | 2022-02-04 | Mason | Michigan | 26105 | 6273 | 80 |
2167421 | 2167421 | 2022-01-30 | Halifax | Virginia | 51083 | 6273 | 128 |
2164166 | 2164166 | 2022-01-29 | Halifax | Virginia | 51083 | 6273 | 128 |
2160911 | 2160911 | 2022-01-28 | Halifax | Virginia | 51083 | 6273 | 128 |
2151603 | 2151603 | 2022-01-26 | Yell | Arkansas | 5149 | 6273 | 93 |
2127972 | 2127972 | 2022-01-18 | Macon | Tennessee | 47111 | 6273 | 120 |
2124720 | 2124720 | 2022-01-17 | Macon | Tennessee | 47111 | 6273 | 120 |
2121468 | 2121468 | 2022-01-16 | Macon | Tennessee | 47111 | 6273 | 120 |
2118216 | 2118216 | 2022-01-15 | Macon | Tennessee | 47111 | 6273 | 120 |
2114965 | 2114965 | 2022-01-14 | Macon | Tennessee | 47111 | 6273 | 120 |
2111713 | 2111713 | 2022-01-13 | Macon | Tennessee | 47111 | 6273 | 120 |
2108461 | 2108461 | 2022-01-12 | Macon | Tennessee | 47111 | 6273 | 120 |
2079861 | 2079861 | 2022-01-03 | Teton | Wyoming | 56039 | 6273 | 14 |
2052475 | 2052475 | 2021-12-26 | Franklin | New York | 36033 | 6273 | 29 |
1968296 | 1968296 | 2021-11-30 | Logan | Oklahoma | 40083 | 6273 | 115 |
1965045 | 1965045 | 2021-11-29 | Logan | Oklahoma | 40083 | 6273 | 115 |
1961793 | 1961793 | 2021-11-28 | Logan | Oklahoma | 40083 | 6273 | 115 |
1958542 | 1958542 | 2021-11-27 | Logan | Oklahoma | 40083 | 6273 | 115 |
1955291 | 1955291 | 2021-11-26 | Logan | Oklahoma | 40083 | 6273 | 115 |
1952040 | 1952040 | 2021-11-25 | Logan | Oklahoma | 40083 | 6273 | 115 |
1948789 | 1948789 | 2021-11-24 | Logan | Oklahoma | 40083 | 6273 | 115 |
1914686 | 1914686 | 2021-11-14 | Nez Perce | Idaho | 16069 | 6273 | 102 |
1915470 | 1915470 | 2021-11-14 | Morrison | Minnesota | 27097 | 6273 | 74 |
1911436 | 1911436 | 2021-11-13 | Nez Perce | Idaho | 16069 | 6273 | 102 |
1912220 | 1912220 | 2021-11-13 | Morrison | Minnesota | 27097 | 6273 | 74 |
1908187 | 1908187 | 2021-11-12 | Nez Perce | Idaho | 16069 | 6273 | 102 |
1908970 | 1908970 | 2021-11-12 | Morrison | Minnesota | 27097 | 6273 | 74 |
1884961 | 1884961 | 2021-11-05 | Boone | Arkansas | 5009 | 6273 | 128 |
1881307 | 1881307 | 2021-11-03 | Danville city | Virginia | 51590 | 6273 | 194 |
1881456 | 1881456 | 2021-11-03 | Fayette | West Virginia | 54019 | 6273 | 128 |
1830015 | 1830015 | 2021-10-19 | Bryan | Georgia | 13029 | 6273 | 66 |
1821932 | 1821932 | 2021-10-16 | Brown | Ohio | 39015 | 6273 | 82 |
1742924 | 1742924 | 2021-09-22 | Franklin | Kentucky | 21073 | 6273 | 68 |
1710730 | 1710730 | 2021-09-12 | Benton | Minnesota | 27009 | 6273 | 98 |
1707483 | 1707483 | 2021-09-11 | Benton | Minnesota | 27009 | 6273 | 98 |
1704236 | 1704236 | 2021-09-10 | Benton | Minnesota | 27009 | 6273 | 98 |
1695328 | 1695328 | 2021-09-07 | Delaware | Oklahoma | 40041 | 6273 | 111 |
1692080 | 1692080 | 2021-09-06 | Delaware | Oklahoma | 40041 | 6273 | 111 |
1688831 | 1688831 | 2021-09-05 | Delaware | Oklahoma | 40041 | 6273 | 111 |
1685581 | 1685581 | 2021-09-04 | Delaware | Oklahoma | 40041 | 6273 | 111 |
1682330 | 1682330 | 2021-09-03 | Delaware | Oklahoma | 40041 | 6273 | 111 |
1679080 | 1679080 | 2021-09-02 | Delaware | Oklahoma | 40041 | 6273 | 111 |
1675832 | 1675832 | 2021-09-01 | Delaware | Oklahoma | 40041 | 6273 | 111 |
1643506 | 1643506 | 2021-08-22 | Union | Pennsylvania | 42119 | 6273 | 90 |
1601578 | 1601578 | 2021-08-09 | Anderson | Texas | 48001 | 6273 | 134 |
1598330 | 1598330 | 2021-08-08 | Anderson | Texas | 48001 | 6273 | 134 |
1595081 | 1595081 | 2021-08-07 | Anderson | Texas | 48001 | 6273 | 134 |
1591832 | 1591832 | 2021-08-06 | Anderson | Texas | 48001 | 6273 | 134 |
1563057 | 1563057 | 2021-07-28 | Skagit | Washington | 53057 | 6273 | 79 |
1533324 | 1533324 | 2021-07-19 | Loudon | Tennessee | 47105 | 6273 | 71 |
1316768 | 1316768 | 2021-05-14 | Fremont | Colorado | 8043 | 6273 | 57 |
1261325 | 1261325 | 2021-04-27 | Colbert | Alabama | 1033 | 6273 | 134 |
1250212 | 1250212 | 2021-04-23 | St. Lawrence | New York | 36089 | 6273 | 95 |
1230197 | 1230197 | 2021-04-17 | Kandiyohi | Minnesota | 27067 | 6273 | 80 |
1052541 | 1052541 | 2021-02-21 | Crawford | Pennsylvania | 42039 | 6273 | 136 |
1011377 | 1011377 | 2021-02-09 | Walker | Alabama | 1127 | 6273 | 210 |
990576 | 990576 | 2021-02-02 | Rutherford | North Carolina | 37161 | 6273 | 174 |
970508 | 970508 | 2021-01-27 | Rice | Minnesota | 27131 | 6273 | 75 |
875561 | 875561 | 2020-12-29 | Bannock | Idaho | 16005 | 6273 | 62 |
863620 | 863620 | 2020-12-25 | St. Francois | Missouri | 29187 | 6273 | 68 |
785639 | 785639 | 2020-12-01 | Buchanan | Missouri | 29021 | 6273 | 83 |
773567 | 773567 | 2020-11-27 | Aiken | South Carolina | 45003 | 6273 | 98 |
701760 | 701760 | 2020-11-05 | Union | North Carolina | 37179 | 6273 | 66 |
674605 | 674605 | 2020-10-28 | Vanderburgh | Indiana | 18163 | 6273 | 70 |
570745 | 570745 | 2020-09-26 | Allen | Indiana | 18003 | 6273 | 213 |
517989 | 517989 | 2020-09-09 | Loudoun | Virginia | 51107 | 6273 | 118 |
507550 | 507550 | 2020-09-06 | Multnomah | Oregon | 41051 | 6273 | 126 |
461487 | 461487 | 2020-08-23 | Hinds | Mississippi | 28049 | 6273 | 132 |
426481 | 426481 | 2020-08-12 | Durham | North Carolina | 37063 | 6273 | 80 |
386166 | 386166 | 2020-07-31 | Santa Barbara | California | 6083 | 6273 | 60 |
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);