ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
397 rows where cases = 1364 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 41
- Georgia 33
- Ohio 25
- Virginia 25
- Missouri 23
- Kentucky 18
- Illinois 17
- Michigan 16
- Puerto Rico 13
- Wisconsin 12
- Indiana 11
- Iowa 10
- Minnesota 10
- Mississippi 10
- West Virginia 10
- North Carolina 9
- Kansas 8
- Maryland 8
- Arkansas 7
- South Dakota 7
- Alabama 6
- Pennsylvania 6
- Idaho 5
- Louisiana 5
- Montana 5
- Nebraska 5
- New York 5
- Wyoming 5
- Florida 4
- New Mexico 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499984 | 2499984 | 2022-05-13 | Calhoun | Georgia | 13037 | 1364 | 22 |
2502309 | 2502309 | 2022-05-13 | Hartley | Texas | 48205 | 1364 | 3 |
2496726 | 2496726 | 2022-05-12 | Calhoun | Georgia | 13037 | 1364 | 22 |
2499051 | 2499051 | 2022-05-12 | Hartley | Texas | 48205 | 1364 | 3 |
2499283 | 2499283 | 2022-05-12 | Cumberland | Virginia | 51049 | 1364 | 27 |
2493468 | 2493468 | 2022-05-11 | Calhoun | Georgia | 13037 | 1364 | 22 |
2495793 | 2495793 | 2022-05-11 | Hartley | Texas | 48205 | 1364 | 3 |
2492535 | 2492535 | 2022-05-10 | Hartley | Texas | 48205 | 1364 | 3 |
2489277 | 2489277 | 2022-05-09 | Hartley | Texas | 48205 | 1364 | 3 |
2486020 | 2486020 | 2022-05-08 | Hartley | Texas | 48205 | 1364 | 3 |
2482762 | 2482762 | 2022-05-07 | Hartley | Texas | 48205 | 1364 | 3 |
2479504 | 2479504 | 2022-05-06 | Hartley | Texas | 48205 | 1364 | 3 |
2476246 | 2476246 | 2022-05-05 | Hartley | Texas | 48205 | 1364 | 3 |
2472989 | 2472989 | 2022-05-04 | Hartley | Texas | 48205 | 1364 | 3 |
2469733 | 2469733 | 2022-05-03 | Hartley | Texas | 48205 | 1364 | 3 |
2466477 | 2466477 | 2022-05-02 | Hartley | Texas | 48205 | 1364 | 3 |
2463222 | 2463222 | 2022-05-01 | Hartley | Texas | 48205 | 1364 | 3 |
2459966 | 2459966 | 2022-04-30 | Hartley | Texas | 48205 | 1364 | 3 |
2456710 | 2456710 | 2022-04-29 | Hartley | Texas | 48205 | 1364 | 3 |
2453454 | 2453454 | 2022-04-28 | Hartley | Texas | 48205 | 1364 | 3 |
2450198 | 2450198 | 2022-04-27 | Hartley | Texas | 48205 | 1364 | 3 |
2446941 | 2446941 | 2022-04-26 | Hartley | Texas | 48205 | 1364 | 3 |
2443686 | 2443686 | 2022-04-25 | Hartley | Texas | 48205 | 1364 | 3 |
2438105 | 2438105 | 2022-04-24 | Calhoun | Georgia | 13037 | 1364 | 22 |
2440430 | 2440430 | 2022-04-24 | Hartley | Texas | 48205 | 1364 | 3 |
2434849 | 2434849 | 2022-04-23 | Calhoun | Georgia | 13037 | 1364 | 22 |
2437174 | 2437174 | 2022-04-23 | Hartley | Texas | 48205 | 1364 | 3 |
2431593 | 2431593 | 2022-04-22 | Calhoun | Georgia | 13037 | 1364 | 22 |
2428337 | 2428337 | 2022-04-21 | Calhoun | Georgia | 13037 | 1364 | 22 |
2425081 | 2425081 | 2022-04-20 | Calhoun | Georgia | 13037 | 1364 | 22 |
2426368 | 2426368 | 2022-04-20 | Dawes | Nebraska | 31045 | 1364 | 21 |
2423112 | 2423112 | 2022-04-19 | Dawes | Nebraska | 31045 | 1364 | 21 |
2368466 | 2368466 | 2022-04-02 | Maunabo | Puerto Rico | 72095 | 1364 | |
2365213 | 2365213 | 2022-04-01 | Maunabo | Puerto Rico | 72095 | 1364 | |
2342861 | 2342861 | 2022-03-25 | Newton | Texas | 48351 | 1364 | 61 |
2292243 | 2292243 | 2022-03-10 | Rooks | Kansas | 20163 | 1364 | 20 |
2288991 | 2288991 | 2022-03-09 | Rooks | Kansas | 20163 | 1364 | 20 |
2285740 | 2285740 | 2022-03-08 | Rooks | Kansas | 20163 | 1364 | 20 |
2282488 | 2282488 | 2022-03-07 | Rooks | Kansas | 20163 | 1364 | 20 |
2265655 | 2265655 | 2022-03-02 | Calhoun | Georgia | 13037 | 1364 | 22 |
2219006 | 2219006 | 2022-02-15 | Tripp | South Dakota | 46123 | 1364 | 23 |
2212493 | 2212493 | 2022-02-13 | Moody | South Dakota | 46101 | 1364 | 27 |
2209240 | 2209240 | 2022-02-12 | Moody | South Dakota | 46101 | 1364 | 27 |
2205987 | 2205987 | 2022-02-11 | Moody | South Dakota | 46101 | 1364 | 27 |
2187105 | 2187105 | 2022-02-05 | Wirt | West Virginia | 54105 | 1364 | 19 |
2155180 | 2155180 | 2022-01-27 | Randolph | Georgia | 13243 | 1364 | 45 |
2110124 | 2110124 | 2022-01-13 | Wabaunsee | Kansas | 20197 | 1364 | 19 |
2112138 | 2112138 | 2022-01-13 | Middlesex | Virginia | 51119 | 1364 | 34 |
2106873 | 2106873 | 2022-01-12 | Wabaunsee | Kansas | 20197 | 1364 | 19 |
2103087 | 2103087 | 2022-01-11 | Hancock | Georgia | 13141 | 1364 | 83 |
2096650 | 2096650 | 2022-01-09 | Terrell | Georgia | 13273 | 1364 | 58 |
2093398 | 2093398 | 2022-01-08 | Terrell | Georgia | 13273 | 1364 | 58 |
2090146 | 2090146 | 2022-01-07 | Terrell | Georgia | 13273 | 1364 | 58 |
2086895 | 2086895 | 2022-01-06 | Terrell | Georgia | 13273 | 1364 | 58 |
2089370 | 2089370 | 2022-01-06 | Lunenburg | Virginia | 51111 | 1364 | 23 |
2083643 | 2083643 | 2022-01-05 | Terrell | Georgia | 13273 | 1364 | 58 |
2086175 | 2086175 | 2022-01-05 | Williamsburg city | Virginia | 51830 | 1364 | 13 |
2078190 | 2078190 | 2022-01-03 | Ozark | Missouri | 29153 | 1364 | 46 |
2076500 | 2076500 | 2022-01-02 | Pocahontas | West Virginia | 54075 | 1364 | 22 |
2073249 | 2073249 | 2022-01-01 | Pocahontas | West Virginia | 54075 | 1364 | 22 |
2069998 | 2069998 | 2021-12-31 | Pocahontas | West Virginia | 54075 | 1364 | 22 |
2066747 | 2066747 | 2021-12-30 | Pocahontas | West Virginia | 54075 | 1364 | 22 |
2037085 | 2037085 | 2021-12-21 | Hamilton | Texas | 48193 | 1364 | 29 |
2033835 | 2033835 | 2021-12-20 | Hamilton | Texas | 48193 | 1364 | 29 |
2030585 | 2030585 | 2021-12-19 | Hamilton | Texas | 48193 | 1364 | 29 |
2017735 | 2017735 | 2021-12-15 | Yoakum | Texas | 48501 | 1364 | 35 |
2011322 | 2011322 | 2021-12-13 | Essex | Virginia | 51057 | 1364 | 20 |
2001478 | 2001478 | 2021-12-10 | Winkler | Texas | 48495 | 1364 | 32 |
1996719 | 1996719 | 2021-12-09 | Lake | Minnesota | 27075 | 1364 | 25 |
1987363 | 1987363 | 2021-12-06 | Wayne | Nebraska | 31179 | 1364 | 8 |
1988838 | 1988838 | 2021-12-06 | Johnson | Wyoming | 56019 | 1364 | 16 |
1985588 | 1985588 | 2021-12-05 | Johnson | Wyoming | 56019 | 1364 | 16 |
1982338 | 1982338 | 2021-12-04 | Johnson | Wyoming | 56019 | 1364 | 16 |
1979088 | 1979088 | 2021-12-03 | Johnson | Wyoming | 56019 | 1364 | 16 |
1975838 | 1975838 | 2021-12-02 | Johnson | Wyoming | 56019 | 1364 | 16 |
1948635 | 1948635 | 2021-11-24 | Pembina | North Dakota | 38067 | 1364 | 14 |
1944770 | 1944770 | 2021-11-23 | Choctaw | Mississippi | 28019 | 1364 | 27 |
1941519 | 1941519 | 2021-11-22 | Choctaw | Mississippi | 28019 | 1364 | 27 |
1942754 | 1942754 | 2021-11-22 | Castro | Texas | 48069 | 1364 | 38 |
1938269 | 1938269 | 2021-11-21 | Choctaw | Mississippi | 28019 | 1364 | 27 |
1939504 | 1939504 | 2021-11-21 | Castro | Texas | 48069 | 1364 | 38 |
1935019 | 1935019 | 2021-11-20 | Choctaw | Mississippi | 28019 | 1364 | 27 |
1936254 | 1936254 | 2021-11-20 | Castro | Texas | 48069 | 1364 | 38 |
1931769 | 1931769 | 2021-11-19 | Choctaw | Mississippi | 28019 | 1364 | 27 |
1913206 | 1913206 | 2021-11-13 | Guayama | Puerto Rico | 72057 | 1364 | |
1902783 | 1902783 | 2021-11-10 | Cheyenne | Nebraska | 31033 | 1364 | 19 |
1891980 | 1891980 | 2021-11-07 | Hamilton | Illinois | 17065 | 1364 | 25 |
1888730 | 1888730 | 2021-11-06 | Hamilton | Illinois | 17065 | 1364 | 25 |
1885480 | 1885480 | 2021-11-05 | Hamilton | Illinois | 17065 | 1364 | 25 |
1882231 | 1882231 | 2021-11-04 | Hamilton | Illinois | 17065 | 1364 | 25 |
1881301 | 1881301 | 2021-11-03 | Clarke | Virginia | 51043 | 1364 | 25 |
1881494 | 1881494 | 2021-11-03 | Tyler | West Virginia | 54095 | 1364 | 19 |
1839517 | 1839517 | 2021-10-22 | Nevada | Arkansas | 5099 | 1364 | 38 |
1811631 | 1811631 | 2021-10-13 | Carroll | Missouri | 29033 | 1364 | 26 |
1808382 | 1808382 | 2021-10-12 | Carroll | Missouri | 29033 | 1364 | 26 |
1801123 | 1801123 | 2021-10-10 | Martin | Indiana | 18101 | 1364 | 19 |
1797874 | 1797874 | 2021-10-09 | Martin | Indiana | 18101 | 1364 | 19 |
1794625 | 1794625 | 2021-10-08 | Martin | Indiana | 18101 | 1364 | 19 |
1779167 | 1779167 | 2021-10-03 | Howard | Missouri | 29089 | 1364 | 12 |
1765287 | 1765287 | 2021-09-29 | Marshall | Illinois | 17123 | 1364 | 23 |
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);