ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 8406 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Kentucky 6
- Pennsylvania 3
- Kansas 2
- North Carolina 2
- Ohio 2
- Alabama 1
- Arkansas 1
- District of Columbia 1
- Florida 1
- Idaho 1
- Illinois 1
- Indiana 1
- Louisiana 1
- Missouri 1
- New York 1
- Tennessee 1
- Texas 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2313075 | 2313075 | 2022-03-16 | Greene | Pennsylvania | 42059 | 8406 | 100 |
2262561 | 2262561 | 2022-03-01 | Bonner | Idaho | 16017 | 8406 | 176 |
2229493 | 2229493 | 2022-02-19 | Chambers | Alabama | 1017 | 8406 | 150 |
2179296 | 2179296 | 2022-02-03 | Allegany | New York | 36003 | 8406 | 144 |
2148908 | 2148908 | 2022-01-25 | Jefferson | Indiana | 18077 | 8406 | 132 |
2134683 | 2134683 | 2022-01-20 | Medina | Texas | 48325 | 8406 | 177 |
1984661 | 1984661 | 2021-12-05 | Mifflin | Pennsylvania | 42087 | 8406 | 226 |
1860025 | 1860025 | 2021-10-28 | St. Martin | Louisiana | 22099 | 8406 | 160 |
1850213 | 1850213 | 2021-10-25 | Scott | Kentucky | 21209 | 8406 | 49 |
1668772 | 1668772 | 2021-08-30 | Taney | Missouri | 29213 | 8406 | 129 |
1656494 | 1656494 | 2021-08-26 | Somerset | Pennsylvania | 42111 | 8406 | 219 |
1534159 | 1534159 | 2021-07-20 | Pope | Arkansas | 5115 | 8406 | 112 |
1300635 | 1300635 | 2021-05-09 | Nassau | Florida | 12089 | 8406 | 126 |
1250459 | 1250459 | 2021-04-23 | Tuscarawas | Ohio | 39157 | 8406 | 240 |
1223314 | 1223314 | 2021-04-15 | Reno | Kansas | 20155 | 8406 | 137 |
1220066 | 1220066 | 2021-04-14 | Reno | Kansas | 20155 | 8406 | 137 |
1176726 | 1176726 | 2021-03-31 | Cabell | West Virginia | 54011 | 8406 | 175 |
980767 | 980767 | 2021-01-30 | Burke | North Carolina | 37023 | 8406 | 106 |
977521 | 977521 | 2021-01-29 | Burke | North Carolina | 37023 | 8406 | 106 |
911357 | 911357 | 2021-01-09 | Macon | Illinois | 17115 | 8406 | 175 |
869571 | 869571 | 2020-12-27 | Kenton | Kentucky | 21117 | 8406 | 79 |
866326 | 866326 | 2020-12-26 | Kenton | Kentucky | 21117 | 8406 | 79 |
863081 | 863081 | 2020-12-25 | Kenton | Kentucky | 21117 | 8406 | 79 |
859836 | 859836 | 2020-12-24 | Kenton | Kentucky | 21117 | 8406 | 79 |
856591 | 856591 | 2020-12-23 | Kenton | Kentucky | 21117 | 8406 | 79 |
858063 | 858063 | 2020-12-23 | Bradley | Tennessee | 47011 | 8406 | 63 |
841394 | 841394 | 2020-12-18 | Greene | Ohio | 39057 | 8406 | 101 |
181846 | 181846 | 2020-05-27 | District of Columbia | District of Columbia | 11001 | 8406 | 445 |
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);