ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 10004 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- North Carolina 8
- Kentucky 7
- Illinois 5
- Pennsylvania 4
- Texas 4
- New York 3
- Minnesota 2
- Virginia 2
- Alabama 1
- Arkansas 1
- Colorado 1
- Louisiana 1
- Maryland 1
- Michigan 1
- Mississippi 1
- Ohio 1
- Puerto Rico 1
- Tennessee 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490105 | 2490105 | 2022-05-10 | Summit | Colorado | 8117 | 10004 | 14 |
2311407 | 2311407 | 2022-03-16 | Fulton | Illinois | 17057 | 10004 | 135 |
2274082 | 2274082 | 2022-03-04 | Wayne | Pennsylvania | 42127 | 10004 | 166 |
2195795 | 2195795 | 2022-02-08 | Defiance | Ohio | 39039 | 10004 | 152 |
2192316 | 2192316 | 2022-02-07 | Cortland | New York | 36023 | 10004 | 110 |
2170952 | 2170952 | 2022-02-01 | Chilton | Alabama | 1021 | 10004 | 183 |
2110481 | 2110481 | 2022-01-13 | Goodhue | Minnesota | 27049 | 10004 | 112 |
2095600 | 2095600 | 2022-01-08 | Harrison | Texas | 48203 | 10004 | 192 |
2074035 | 2074035 | 2022-01-02 | Ogle | Illinois | 17141 | 10004 | 118 |
2074469 | 2074469 | 2022-01-02 | Scott | Kentucky | 21209 | 10004 | 75 |
2070784 | 2070784 | 2022-01-01 | Ogle | Illinois | 17141 | 10004 | 118 |
2071218 | 2071218 | 2022-01-01 | Scott | Kentucky | 21209 | 10004 | 75 |
2067533 | 2067533 | 2021-12-31 | Ogle | Illinois | 17141 | 10004 | 118 |
2067967 | 2067967 | 2021-12-31 | Scott | Kentucky | 21209 | 10004 | 75 |
2064282 | 2064282 | 2021-12-30 | Ogle | Illinois | 17141 | 10004 | 118 |
2064716 | 2064716 | 2021-12-30 | Scott | Kentucky | 21209 | 10004 | 75 |
2061466 | 2061466 | 2021-12-29 | Scott | Kentucky | 21209 | 10004 | 75 |
2055821 | 2055821 | 2021-12-27 | Lenoir | North Carolina | 37107 | 10004 | 179 |
2052571 | 2052571 | 2021-12-26 | Lenoir | North Carolina | 37107 | 10004 | 179 |
2049321 | 2049321 | 2021-12-25 | Lenoir | North Carolina | 37107 | 10004 | 179 |
2046071 | 2046071 | 2021-12-24 | Lenoir | North Carolina | 37107 | 10004 | 179 |
2042821 | 2042821 | 2021-12-23 | Lenoir | North Carolina | 37107 | 10004 | 179 |
2039572 | 2039572 | 2021-12-22 | Lenoir | North Carolina | 37107 | 10004 | 179 |
1995141 | 1995141 | 2021-12-08 | Rockingham | Virginia | 51165 | 10004 | 174 |
1889976 | 1889976 | 2021-11-06 | Ontario | New York | 36069 | 10004 | 111 |
1880284 | 1880284 | 2021-11-03 | Duplin | North Carolina | 37061 | 10004 | 188 |
1873073 | 1873073 | 2021-11-01 | St. Mary's | Maryland | 24037 | 10004 | 164 |
1858206 | 1858206 | 2021-10-27 | Roane | Tennessee | 47145 | 10004 | 152 |
1816300 | 1816300 | 2021-10-14 | Augusta | Virginia | 51015 | 10004 | 116 |
1804642 | 1804642 | 2021-10-11 | Christian | Kentucky | 21047 | 10004 | 125 |
1805938 | 1805938 | 2021-10-11 | Somerset | Pennsylvania | 42111 | 10004 | 235 |
1641350 | 1641350 | 2021-08-22 | Pope | Arkansas | 5115 | 10004 | 122 |
1610666 | 1610666 | 2021-08-12 | Moore | North Carolina | 37125 | 10004 | 197 |
1564386 | 1564386 | 2021-07-29 | St. Landry | Louisiana | 22097 | 10004 | 267 |
1470105 | 1470105 | 2021-06-30 | Hardin | Kentucky | 21093 | 10004 | 170 |
1350425 | 1350425 | 2021-05-24 | Lee | Mississippi | 28081 | 10004 | 175 |
1333998 | 1333998 | 2021-05-19 | Eaton | Michigan | 26045 | 10004 | 203 |
1175508 | 1175508 | 2021-03-31 | Rensselaer | New York | 36083 | 10004 | 133 |
1042860 | 1042860 | 2021-02-18 | Bayamon | Puerto Rico | 72021 | 10004 | |
929203 | 929203 | 2021-01-14 | Centre | Pennsylvania | 42027 | 10004 | 166 |
915328 | 915328 | 2021-01-10 | Olmsted | Minnesota | 27109 | 10004 | 68 |
702632 | 702632 | 2020-11-05 | Williamson | Texas | 48491 | 10004 | 159 |
520875 | 520875 | 2020-09-10 | Brazoria | Texas | 48039 | 10004 | 148 |
517639 | 517639 | 2020-09-09 | Brazoria | Texas | 48039 | 10004 | 148 |
471992 | 471992 | 2020-08-26 | Allegheny | Pennsylvania | 42003 | 10004 | 317 |
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);