ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
579 rows where deaths = 308 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 54
- Texas 48
- California 42
- Georgia 39
- Michigan 34
- Florida 28
- Alabama 25
- Illinois 23
- Pennsylvania 23
- Indiana 20
- Missouri 19
- Ohio 19
- Virginia 17
- Iowa 16
- Washington 16
- Oklahoma 14
- Louisiana 13
- Mississippi 12
- Maine 10
- New Mexico 10
- Oregon 10
- South Carolina 10
- New Jersey 9
- Arizona 7
- Minnesota 7
- Colorado 6
- Tennessee 6
- Utah 6
- Arkansas 5
- Montana 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501499 | 2501499 | 2022-05-13 | Caldwell | North Carolina | 37027 | 22411 | 308 |
2498241 | 2498241 | 2022-05-12 | Caldwell | North Carolina | 37027 | 22411 | 308 |
2494983 | 2494983 | 2022-05-11 | Caldwell | North Carolina | 37027 | 22411 | 308 |
2491725 | 2491725 | 2022-05-10 | Caldwell | North Carolina | 37027 | 22355 | 308 |
2488467 | 2488467 | 2022-05-09 | Caldwell | North Carolina | 37027 | 22355 | 308 |
2485210 | 2485210 | 2022-05-08 | Caldwell | North Carolina | 37027 | 22355 | 308 |
2481952 | 2481952 | 2022-05-07 | Caldwell | North Carolina | 37027 | 22355 | 308 |
2478694 | 2478694 | 2022-05-06 | Caldwell | North Carolina | 37027 | 22355 | 308 |
2475436 | 2475436 | 2022-05-05 | Caldwell | North Carolina | 37027 | 22355 | 308 |
2472179 | 2472179 | 2022-05-04 | Caldwell | North Carolina | 37027 | 22355 | 308 |
2351362 | 2351362 | 2022-03-28 | Jasper | Missouri | 29097 | 20842 | 308 |
2348110 | 2348110 | 2022-03-27 | Jasper | Missouri | 29097 | 20827 | 308 |
2344857 | 2344857 | 2022-03-26 | Jasper | Missouri | 29097 | 20827 | 308 |
2341604 | 2341604 | 2022-03-25 | Jasper | Missouri | 29097 | 20827 | 308 |
2337047 | 2337047 | 2022-03-24 | Yolo | California | 6113 | 39374 | 308 |
2338351 | 2338351 | 2022-03-24 | Jasper | Missouri | 29097 | 20826 | 308 |
2338623 | 2338623 | 2022-03-24 | Chaves | New Mexico | 35005 | 21687 | 308 |
2333793 | 2333793 | 2022-03-23 | Yolo | California | 6113 | 39349 | 308 |
2335097 | 2335097 | 2022-03-23 | Jasper | Missouri | 29097 | 20817 | 308 |
2335369 | 2335369 | 2022-03-23 | Chaves | New Mexico | 35005 | 21688 | 308 |
2331843 | 2331843 | 2022-03-22 | Jasper | Missouri | 29097 | 20815 | 308 |
2332115 | 2332115 | 2022-03-22 | Chaves | New Mexico | 35005 | 21685 | 308 |
2327287 | 2327287 | 2022-03-21 | Yolo | California | 6113 | 39300 | 308 |
2328590 | 2328590 | 2022-03-21 | Jasper | Missouri | 29097 | 20809 | 308 |
2328862 | 2328862 | 2022-03-21 | Chaves | New Mexico | 35005 | 21685 | 308 |
2324034 | 2324034 | 2022-03-20 | Yolo | California | 6113 | 39251 | 308 |
2325338 | 2325338 | 2022-03-20 | Jasper | Missouri | 29097 | 20805 | 308 |
2325708 | 2325708 | 2022-03-20 | Brunswick | North Carolina | 37019 | 29637 | 308 |
2325710 | 2325710 | 2022-03-20 | Burke | North Carolina | 37023 | 24961 | 308 |
2320780 | 2320780 | 2022-03-19 | Yolo | California | 6113 | 39251 | 308 |
2322084 | 2322084 | 2022-03-19 | Jasper | Missouri | 29097 | 20805 | 308 |
2322455 | 2322455 | 2022-03-19 | Brunswick | North Carolina | 37019 | 29637 | 308 |
2322457 | 2322457 | 2022-03-19 | Burke | North Carolina | 37023 | 24961 | 308 |
2317526 | 2317526 | 2022-03-18 | Yolo | California | 6113 | 39251 | 308 |
2318830 | 2318830 | 2022-03-18 | Jasper | Missouri | 29097 | 20805 | 308 |
2319201 | 2319201 | 2022-03-18 | Brunswick | North Carolina | 37019 | 29637 | 308 |
2319203 | 2319203 | 2022-03-18 | Burke | North Carolina | 37023 | 24961 | 308 |
2314273 | 2314273 | 2022-03-17 | Yolo | California | 6113 | 39244 | 308 |
2315577 | 2315577 | 2022-03-17 | Jasper | Missouri | 29097 | 20805 | 308 |
2315947 | 2315947 | 2022-03-17 | Brunswick | North Carolina | 37019 | 29619 | 308 |
2311020 | 2311020 | 2022-03-16 | Yolo | California | 6113 | 39230 | 308 |
2312324 | 2312324 | 2022-03-16 | Jasper | Missouri | 29097 | 20802 | 308 |
2312694 | 2312694 | 2022-03-16 | Brunswick | North Carolina | 37019 | 29603 | 308 |
2307767 | 2307767 | 2022-03-15 | Yolo | California | 6113 | 39210 | 308 |
2308218 | 2308218 | 2022-03-15 | Vermilion | Illinois | 17183 | 27829 | 308 |
2309071 | 2309071 | 2022-03-15 | Jasper | Missouri | 29097 | 20801 | 308 |
2304516 | 2304516 | 2022-03-14 | Yolo | California | 6113 | 39170 | 308 |
2304967 | 2304967 | 2022-03-14 | Vermilion | Illinois | 17183 | 27833 | 308 |
2306190 | 2306190 | 2022-03-14 | Burke | North Carolina | 37023 | 24915 | 308 |
2301264 | 2301264 | 2022-03-13 | Yolo | California | 6113 | 39133 | 308 |
2297902 | 2297902 | 2022-03-12 | Faulkner | Arkansas | 5045 | 34882 | 308 |
2298012 | 2298012 | 2022-03-12 | Yolo | California | 6113 | 39133 | 308 |
2294760 | 2294760 | 2022-03-11 | Yolo | California | 6113 | 39133 | 308 |
2291508 | 2291508 | 2022-03-10 | Yolo | California | 6113 | 39124 | 308 |
2287984 | 2287984 | 2022-03-08 | Washington | Wisconsin | 55131 | 37782 | 308 |
2284732 | 2284732 | 2022-03-07 | Washington | Wisconsin | 55131 | 37775 | 308 |
2281283 | 2281283 | 2022-03-06 | Portsmouth city | Virginia | 51740 | 20613 | 308 |
2278030 | 2278030 | 2022-03-05 | Portsmouth city | Virginia | 51740 | 20613 | 308 |
2274777 | 2274777 | 2022-03-04 | Portsmouth city | Virginia | 51740 | 20613 | 308 |
2269011 | 2269011 | 2022-03-03 | Rockdale | Georgia | 13247 | 18248 | 308 |
2269695 | 2269695 | 2022-03-03 | Penobscot | Maine | 23019 | 26537 | 308 |
2271668 | 2271668 | 2022-03-03 | Dodge | Wisconsin | 55027 | 26896 | 308 |
2266442 | 2266442 | 2022-03-02 | Penobscot | Maine | 23019 | 26373 | 308 |
2267533 | 2267533 | 2022-03-02 | Crawford | Pennsylvania | 42039 | 19649 | 308 |
2262167 | 2262167 | 2022-03-01 | Saline | Arkansas | 5125 | 30464 | 308 |
2263191 | 2263191 | 2022-03-01 | Penobscot | Maine | 23019 | 26162 | 308 |
2258916 | 2258916 | 2022-02-28 | Saline | Arkansas | 5125 | 30447 | 308 |
2259940 | 2259940 | 2022-02-28 | Penobscot | Maine | 23019 | 25983 | 308 |
2261885 | 2261885 | 2022-02-28 | Raleigh | West Virginia | 54081 | 22258 | 308 |
2261913 | 2261913 | 2022-02-28 | Dodge | Wisconsin | 55027 | 26869 | 308 |
2256689 | 2256689 | 2022-02-27 | Penobscot | Maine | 23019 | 25982 | 308 |
2253438 | 2253438 | 2022-02-26 | Penobscot | Maine | 23019 | 25978 | 308 |
2249015 | 2249015 | 2022-02-25 | DeKalb | Alabama | 1049 | 18534 | 308 |
2249031 | 2249031 | 2022-02-25 | Lee | Alabama | 1081 | 37497 | 308 |
2249117 | 2249117 | 2022-02-25 | Craighead | Arkansas | 5031 | 36417 | 308 |
2250187 | 2250187 | 2022-02-25 | Penobscot | Maine | 23019 | 25862 | 308 |
2245764 | 2245764 | 2022-02-24 | DeKalb | Alabama | 1049 | 18518 | 308 |
2238923 | 2238923 | 2022-02-21 | Arlington | Virginia | 51013 | 39923 | 308 |
2225438 | 2225438 | 2022-02-17 | Oconee | South Carolina | 45073 | 23833 | 308 |
2221353 | 2221353 | 2022-02-16 | Cascade | Montana | 30013 | 23200 | 308 |
2217032 | 2217032 | 2022-02-15 | Unknown | Guam | 41249 | 308 | |
2213781 | 2213781 | 2022-02-14 | Unknown | Guam | 41249 | 308 | |
2214419 | 2214419 | 2022-02-14 | Cumberland | Maine | 23005 | 39052 | 308 |
2215477 | 2215477 | 2022-02-14 | Josephine | Oregon | 41033 | 15571 | 308 |
2211167 | 2211167 | 2022-02-13 | Cumberland | Maine | 23005 | 39052 | 308 |
2211806 | 2211806 | 2022-02-13 | Lea | New Mexico | 35025 | 19846 | 308 |
2212226 | 2212226 | 2022-02-13 | Josephine | Oregon | 41033 | 15461 | 308 |
2207914 | 2207914 | 2022-02-12 | Cumberland | Maine | 23005 | 39052 | 308 |
2208553 | 2208553 | 2022-02-12 | Lea | New Mexico | 35025 | 19846 | 308 |
2208973 | 2208973 | 2022-02-12 | Josephine | Oregon | 41033 | 15461 | 308 |
2205300 | 2205300 | 2022-02-11 | Lea | New Mexico | 35025 | 19846 | 308 |
2205720 | 2205720 | 2022-02-11 | Josephine | Oregon | 41033 | 15461 | 308 |
2202047 | 2202047 | 2022-02-10 | Lea | New Mexico | 35025 | 19834 | 308 |
2202467 | 2202467 | 2022-02-10 | Josephine | Oregon | 41033 | 15311 | 308 |
2202503 | 2202503 | 2022-02-10 | Clearfield | Pennsylvania | 42033 | 18572 | 308 |
2203257 | 2203257 | 2022-02-10 | Roanoke city | Virginia | 51770 | 20319 | 308 |
2198793 | 2198793 | 2022-02-09 | Lea | New Mexico | 35025 | 19813 | 308 |
2199213 | 2199213 | 2022-02-09 | Josephine | Oregon | 41033 | 15214 | 308 |
2199249 | 2199249 | 2022-02-09 | Clearfield | Pennsylvania | 42033 | 18527 | 308 |
2170967 | 2170967 | 2022-02-01 | Elmore | Alabama | 1051 | 22136 | 308 |
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);