ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where cases = 7458 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Colorado 8
- Ohio 8
- Illinois 4
- Missouri 3
- Vermont 3
- North Carolina 2
- Pennsylvania 2
- Texas 2
- Alabama 1
- Florida 1
- Minnesota 1
- Mississippi 1
- Montana 1
- New Mexico 1
- North Dakota 1
- Oregon 1
- South Dakota 1
- Tennessee 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483569 | 2483569 | 2022-05-08 | Logan | Colorado | 8075 | 7458 | 109 |
2480311 | 2480311 | 2022-05-07 | Logan | Colorado | 8075 | 7458 | 109 |
2477053 | 2477053 | 2022-05-06 | Logan | Colorado | 8075 | 7458 | 109 |
2460771 | 2460771 | 2022-05-01 | Logan | Colorado | 8075 | 7458 | 109 |
2457515 | 2457515 | 2022-04-30 | Logan | Colorado | 8075 | 7458 | 109 |
2454259 | 2454259 | 2022-04-29 | Logan | Colorado | 8075 | 7458 | 109 |
2451003 | 2451003 | 2022-04-28 | Logan | Colorado | 8075 | 7458 | 109 |
2426806 | 2426806 | 2022-04-20 | Pike | Ohio | 39131 | 7458 | 120 |
2423550 | 2423550 | 2022-04-19 | Pike | Ohio | 39131 | 7458 | 120 |
2420293 | 2420293 | 2022-04-18 | Pike | Ohio | 39131 | 7458 | 120 |
2417038 | 2417038 | 2022-04-17 | Pike | Ohio | 39131 | 7458 | 120 |
2413782 | 2413782 | 2022-04-16 | Pike | Ohio | 39131 | 7458 | 120 |
2410526 | 2410526 | 2022-04-15 | Pike | Ohio | 39131 | 7458 | 120 |
2407270 | 2407270 | 2022-04-14 | Pike | Ohio | 39131 | 7458 | 120 |
2379768 | 2379768 | 2022-04-06 | Perry | Illinois | 17145 | 7458 | 106 |
2150473 | 2150473 | 2022-01-25 | McKean | Pennsylvania | 42083 | 7458 | 122 |
2147837 | 2147837 | 2022-01-24 | Washington | Vermont | 50023 | 7458 | 40 |
2142265 | 2142265 | 2022-01-23 | Bureau | Illinois | 17011 | 7458 | 129 |
2139010 | 2139010 | 2022-01-22 | Bureau | Illinois | 17011 | 7458 | 129 |
2135754 | 2135754 | 2022-01-21 | Bureau | Illinois | 17011 | 7458 | 129 |
2138061 | 2138061 | 2022-01-21 | Bennington | Vermont | 50003 | 7458 | 54 |
2010428 | 2010428 | 2021-12-13 | Brown | Ohio | 39015 | 7458 | 121 |
1968015 | 1968015 | 2021-11-30 | Beaufort | North Carolina | 37013 | 7458 | 132 |
1944703 | 1944703 | 2021-11-23 | Itasca | Minnesota | 27061 | 7458 | 93 |
1919996 | 1919996 | 2021-11-15 | Burnet | Texas | 48053 | 7458 | 130 |
1916746 | 1916746 | 2021-11-14 | Burnet | Texas | 48053 | 7458 | 129 |
1880168 | 1880168 | 2021-11-03 | Curry | New Mexico | 35009 | 7458 | 121 |
1853847 | 1853847 | 2021-10-26 | Washington | Mississippi | 28151 | 7458 | 161 |
1831660 | 1831660 | 2021-10-19 | Stark | North Dakota | 38089 | 7458 | 61 |
1790536 | 1790536 | 2021-10-06 | Columbia | Wisconsin | 55021 | 7458 | 78 |
1629823 | 1629823 | 2021-08-18 | Lewis and Clark | Montana | 30049 | 7458 | 94 |
1607390 | 1607390 | 2021-08-11 | Franklin | North Carolina | 37069 | 7458 | 55 |
1329150 | 1329150 | 2021-05-17 | Chittenden | Vermont | 50007 | 7458 | 102 |
1235084 | 1235084 | 2021-04-18 | Lynchburg city | Virginia | 51680 | 7458 | 144 |
1180021 | 1180021 | 2021-04-01 | Wood | West Virginia | 54107 | 7458 | 164 |
1115021 | 1115021 | 2021-03-12 | Thurston | Washington | 53067 | 7458 | 78 |
1029795 | 1029795 | 2021-02-14 | Umatilla | Oregon | 41059 | 7458 | 79 |
1009666 | 1009666 | 2021-02-08 | St. Francois | Missouri | 29187 | 7458 | 92 |
991149 | 991149 | 2021-02-02 | Hamblen | Tennessee | 47063 | 7458 | 143 |
987846 | 987846 | 2021-02-01 | Lincoln | South Dakota | 46083 | 7458 | 74 |
920462 | 920462 | 2021-01-12 | DeKalb | Alabama | 1049 | 7458 | 68 |
873279 | 873279 | 2020-12-28 | Cole | Missouri | 29051 | 7458 | 89 |
700075 | 700075 | 2020-11-05 | Weld | Colorado | 8123 | 7458 | 161 |
613781 | 613781 | 2020-10-09 | St. Louis city | Missouri | 29510 | 7458 | 217 |
446170 | 446170 | 2020-08-18 | Bucks | Pennsylvania | 42017 | 7458 | 584 |
54098 | 54098 | 2020-04-13 | Miami-Dade | Florida | 12086 | 7458 | 109 |
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);