ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where cases = 7408 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Illinois 10
- New York 8
- Texas 4
- Wyoming 4
- Georgia 3
- Maine 3
- Missouri 3
- Nebraska 3
- Ohio 3
- Pennsylvania 3
- Minnesota 2
- Mississippi 2
- New Jersey 2
- North Carolina 2
- Alaska 1
- Arkansas 1
- California 1
- Colorado 1
- Indiana 1
- Kentucky 1
- Louisiana 1
- Puerto Rico 1
- South Carolina 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466076 | 2466076 | 2022-05-02 | Warren | Pennsylvania | 42123 | 7408 | 210 |
2462821 | 2462821 | 2022-05-01 | Warren | Pennsylvania | 42123 | 7408 | 210 |
2459565 | 2459565 | 2022-04-30 | Warren | Pennsylvania | 42123 | 7408 | 210 |
2356554 | 2356554 | 2022-03-30 | Siskiyou | California | 6093 | 7408 | 105 |
2351348 | 2351348 | 2022-03-28 | Dunklin | Missouri | 29069 | 7408 | 117 |
2291939 | 2291939 | 2022-03-10 | Perry | Illinois | 17145 | 7408 | 106 |
2280348 | 2280348 | 2022-03-06 | Gallia | Ohio | 39053 | 7408 | 116 |
2277095 | 2277095 | 2022-03-05 | Gallia | Ohio | 39053 | 7408 | 116 |
2223701 | 2223701 | 2022-02-17 | Daviess | Indiana | 18027 | 7408 | 144 |
2225352 | 2225352 | 2022-02-17 | Humacao | Puerto Rico | 72069 | 7408 | |
2202079 | 2202079 | 2022-02-10 | Delaware | New York | 36025 | 7408 | 68 |
2194755 | 2194755 | 2022-02-08 | Grayson | Kentucky | 21085 | 7408 | 114 |
2097980 | 2097980 | 2022-01-09 | Chenango | New York | 36017 | 7408 | 103 |
2055335 | 2055335 | 2021-12-27 | Pontotoc | Mississippi | 28115 | 7408 | 111 |
1995980 | 1995980 | 2021-12-09 | Effingham | Illinois | 17049 | 7408 | 123 |
1960259 | 1960259 | 2021-11-28 | Marion | Illinois | 17121 | 7408 | 157 |
1957008 | 1957008 | 2021-11-27 | Marion | Illinois | 17121 | 7408 | 157 |
1953757 | 1953757 | 2021-11-26 | Marion | Illinois | 17121 | 7408 | 157 |
1950506 | 1950506 | 2021-11-25 | Marion | Illinois | 17121 | 7408 | 157 |
1947255 | 1947255 | 2021-11-24 | Marion | Illinois | 17121 | 7408 | 157 |
1923539 | 1923539 | 2021-11-16 | Campbell | Virginia | 51031 | 7408 | 144 |
1877750 | 1877750 | 2021-11-02 | Burnet | Texas | 48053 | 7408 | 126 |
1874501 | 1874501 | 2021-11-01 | Burnet | Texas | 48053 | 7408 | 126 |
1851056 | 1851056 | 2021-10-25 | Haywood | North Carolina | 37087 | 7408 | 138 |
1790890 | 1790890 | 2021-10-07 | Garfield | Colorado | 8045 | 7408 | 60 |
1791294 | 1791294 | 2021-10-07 | Ogle | Illinois | 17141 | 7408 | 95 |
1792754 | 1792754 | 2021-10-07 | Sandusky | Ohio | 39143 | 7408 | 140 |
1787513 | 1787513 | 2021-10-06 | Hot Spring | Arkansas | 5059 | 7408 | 105 |
1758113 | 1758113 | 2021-09-26 | Fremont | Wyoming | 56013 | 7408 | 106 |
1754865 | 1754865 | 2021-09-25 | Fremont | Wyoming | 56013 | 7408 | 106 |
1751617 | 1751617 | 2021-09-24 | Fremont | Wyoming | 56013 | 7408 | 106 |
1713070 | 1713070 | 2021-09-13 | Coffee | Georgia | 13069 | 7408 | 195 |
1676460 | 1676460 | 2021-09-01 | Navarro | Texas | 48349 | 7408 | 154 |
1668362 | 1668362 | 2021-08-30 | Penobscot | Maine | 23019 | 7408 | 112 |
1665115 | 1665115 | 2021-08-29 | Penobscot | Maine | 23019 | 7408 | 112 |
1661867 | 1661867 | 2021-08-28 | Penobscot | Maine | 23019 | 7408 | 112 |
1599652 | 1599652 | 2021-08-09 | Whiteside | Illinois | 17195 | 7408 | 216 |
1583113 | 1583113 | 2021-08-04 | Bulloch | Georgia | 13031 | 7408 | 123 |
1470201 | 1470201 | 2021-06-30 | Iberia | Louisiana | 22045 | 7408 | 161 |
1444974 | 1444974 | 2021-06-22 | Ontario | New York | 36069 | 7408 | 93 |
1441729 | 1441729 | 2021-06-21 | Ontario | New York | 36069 | 7408 | 93 |
1438484 | 1438484 | 2021-06-20 | Ontario | New York | 36069 | 7408 | 93 |
1435237 | 1435237 | 2021-06-19 | Ontario | New York | 36069 | 7408 | 93 |
1431990 | 1431990 | 2021-06-18 | Ontario | New York | 36069 | 7408 | 93 |
1380167 | 1380167 | 2021-06-02 | Rutherford | North Carolina | 37161 | 7408 | 213 |
1318946 | 1318946 | 2021-05-14 | Laurens | South Carolina | 45059 | 7408 | 172 |
1285889 | 1285889 | 2021-05-04 | Chemung | New York | 36015 | 7408 | 134 |
1261383 | 1261383 | 2021-04-27 | Fairbanks North Star Borough | Alaska | 2090 | 7408 | 37 |
1248851 | 1248851 | 2021-04-23 | Troup | Georgia | 13285 | 7408 | 221 |
1207494 | 1207494 | 2021-04-10 | Rice | Minnesota | 27131 | 7408 | 100 |
1173145 | 1173145 | 2021-03-30 | Liberty | Texas | 48291 | 7408 | 170 |
1126348 | 1126348 | 2021-03-16 | Forrest | Mississippi | 28035 | 7408 | 142 |
1120132 | 1120132 | 2021-03-14 | Hall | Nebraska | 31079 | 7408 | 112 |
1116885 | 1116885 | 2021-03-13 | Hall | Nebraska | 31079 | 7408 | 112 |
1113639 | 1113639 | 2021-03-12 | Hall | Nebraska | 31079 | 7408 | 112 |
969106 | 969106 | 2021-01-26 | Natrona | Wyoming | 56025 | 7408 | 117 |
870024 | 870024 | 2020-12-27 | Cape Girardeau | Missouri | 29031 | 7408 | 105 |
866779 | 866779 | 2020-12-26 | Cape Girardeau | Missouri | 29031 | 7408 | 105 |
759569 | 759569 | 2020-11-23 | St. Louis | Minnesota | 27137 | 7408 | 97 |
749096 | 749096 | 2020-11-20 | McLean | Illinois | 17113 | 7408 | 48 |
607490 | 607490 | 2020-10-07 | Burlington | New Jersey | 34005 | 7408 | 502 |
155897 | 155897 | 2020-05-18 | Monmouth | New Jersey | 34025 | 7408 | 513 |
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);