ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 9046 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Michigan 5
- North Carolina 4
- South Dakota 3
- Utah 3
- Virginia 3
- Georgia 2
- Missouri 2
- New York 2
- Ohio 2
- Pennsylvania 2
- Puerto Rico 2
- Alabama 1
- Kentucky 1
- Louisiana 1
- Minnesota 1
- New Mexico 1
- Oklahoma 1
- Oregon 1
- South Carolina 1
- Texas 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2336557 | 2336557 | 2022-03-23 | Manassas city | Virginia | 51683 | 9046 | 70 |
2312153 | 2312153 | 2022-03-16 | Morrison | Minnesota | 27097 | 9046 | 103 |
2202134 | 2202134 | 2022-02-10 | Bladen | North Carolina | 37017 | 9046 | 113 |
2190475 | 2190475 | 2022-02-07 | Covington | Alabama | 1039 | 9046 | 211 |
2173325 | 2173325 | 2022-02-01 | Mayaguez | Puerto Rico | 72097 | 9046 | |
2146493 | 2146493 | 2022-01-24 | Phelps | Missouri | 29161 | 9046 | 212 |
2140808 | 2140808 | 2022-01-22 | Trujillo Alto | Puerto Rico | 72139 | 9046 | |
2130972 | 2130972 | 2022-01-19 | Wayne | Pennsylvania | 42127 | 9046 | 147 |
2074620 | 2074620 | 2022-01-02 | Cass | Michigan | 26027 | 9046 | 111 |
2071369 | 2071369 | 2022-01-01 | Cass | Michigan | 26027 | 9046 | 111 |
2068118 | 2068118 | 2021-12-31 | Cass | Michigan | 26027 | 9046 | 111 |
2064867 | 2064867 | 2021-12-30 | Cass | Michigan | 26027 | 9046 | 111 |
2061617 | 2061617 | 2021-12-29 | Cass | Michigan | 26027 | 9046 | 111 |
2026468 | 2026468 | 2021-12-18 | Clinton | New York | 36019 | 9046 | 53 |
2019167 | 2019167 | 2021-12-16 | Jessamine | Kentucky | 21113 | 9046 | 110 |
1916197 | 1916197 | 2021-11-14 | Jefferson | Ohio | 39081 | 9046 | 216 |
1848746 | 1848746 | 2021-10-24 | Iron | Utah | 49021 | 9046 | 55 |
1845496 | 1845496 | 2021-10-23 | Iron | Utah | 49021 | 9046 | 55 |
1842246 | 1842246 | 2021-10-22 | Iron | Utah | 49021 | 9046 | 55 |
1792468 | 1792468 | 2021-10-07 | Valencia | New Mexico | 35061 | 9046 | 138 |
1666422 | 1666422 | 2021-08-29 | Lincoln | South Dakota | 46083 | 9046 | 78 |
1663174 | 1663174 | 2021-08-28 | Lincoln | South Dakota | 46083 | 9046 | 78 |
1659926 | 1659926 | 2021-08-27 | Lincoln | South Dakota | 46083 | 9046 | 78 |
1591059 | 1591059 | 2021-08-06 | Chautauqua | New York | 36013 | 9046 | 146 |
1512858 | 1512858 | 2021-07-13 | St. Francois | Missouri | 29187 | 9046 | 116 |
1464533 | 1464533 | 2021-06-28 | Moore | North Carolina | 37125 | 9046 | 192 |
1464641 | 1464641 | 2021-06-28 | Columbiana | Ohio | 39029 | 9046 | 233 |
1318737 | 1318737 | 2021-05-14 | Deschutes | Oregon | 41017 | 9046 | 74 |
1282704 | 1282704 | 2021-05-03 | Brunswick | North Carolina | 37019 | 9046 | 152 |
1253873 | 1253873 | 2021-04-24 | Mercer | Pennsylvania | 42085 | 9046 | 253 |
1195560 | 1195560 | 2021-04-06 | Oconee | South Carolina | 45073 | 9046 | 131 |
1066955 | 1066955 | 2021-02-26 | Jackson | Georgia | 13157 | 9046 | 131 |
1055704 | 1055704 | 2021-02-22 | Muskogee | Oklahoma | 40101 | 9046 | 95 |
1015734 | 1015734 | 2021-02-10 | Terrebonne | Louisiana | 22109 | 9046 | 189 |
953303 | 953303 | 2021-01-22 | Carroll | Georgia | 13045 | 9046 | 153 |
881276 | 881276 | 2020-12-30 | Richmond city | Virginia | 51760 | 9046 | 94 |
831490 | 831490 | 2020-12-15 | Catawba | North Carolina | 37035 | 9046 | 117 |
767871 | 767871 | 2020-11-25 | Sheboygan | Wisconsin | 55117 | 9046 | 54 |
748181 | 748181 | 2020-11-19 | Loudoun | Virginia | 51107 | 9046 | 138 |
498386 | 498386 | 2020-09-03 | Montgomery | Texas | 48339 | 9046 | 132 |
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);