ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
331 rows where deaths = 464 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 36
- Louisiana 25
- Texas 25
- Florida 21
- North Carolina 21
- Pennsylvania 15
- Michigan 13
- Alabama 11
- Tennessee 11
- Wisconsin 11
- California 10
- Indiana 10
- New Jersey 10
- New York 10
- Washington 10
- Connecticut 9
- Virginia 8
- South Carolina 7
- Idaho 6
- Minnesota 6
- Missouri 6
- Arkansas 5
- Oregon 5
- Colorado 4
- Maryland 4
- Massachusetts 4
- New Mexico 4
- Ohio 4
- Arizona 3
- Delaware 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442107 | 2442107 | 2022-04-25 | Livingston | Louisiana | 22063 | 37126 | 464 |
2438851 | 2438851 | 2022-04-24 | Livingston | Louisiana | 22063 | 37123 | 464 |
2435595 | 2435595 | 2022-04-23 | Livingston | Louisiana | 22063 | 37123 | 464 |
2432339 | 2432339 | 2022-04-22 | Livingston | Louisiana | 22063 | 37123 | 464 |
2396525 | 2396525 | 2022-04-11 | Livingston | Louisiana | 22063 | 37093 | 464 |
2393270 | 2393270 | 2022-04-10 | Livingston | Louisiana | 22063 | 37089 | 464 |
2390014 | 2390014 | 2022-04-09 | Livingston | Louisiana | 22063 | 37089 | 464 |
2386758 | 2386758 | 2022-04-08 | Livingston | Louisiana | 22063 | 37089 | 464 |
2383503 | 2383503 | 2022-04-07 | Livingston | Louisiana | 22063 | 37089 | 464 |
2380248 | 2380248 | 2022-04-06 | Livingston | Louisiana | 22063 | 37087 | 464 |
2376993 | 2376993 | 2022-04-05 | Livingston | Louisiana | 22063 | 37084 | 464 |
2375603 | 2375603 | 2022-04-04 | Norfolk city | Virginia | 51710 | 42027 | 464 |
2372351 | 2372351 | 2022-04-03 | Norfolk city | Virginia | 51710 | 41956 | 464 |
2369098 | 2369098 | 2022-04-02 | Norfolk city | Virginia | 51710 | 41956 | 464 |
2365845 | 2365845 | 2022-04-01 | Norfolk city | Virginia | 51710 | 41956 | 464 |
2362592 | 2362592 | 2022-03-31 | Norfolk city | Virginia | 51710 | 41947 | 464 |
2362642 | 2362642 | 2022-03-31 | Benton | Washington | 53005 | 52286 | 464 |
2359388 | 2359388 | 2022-03-30 | Benton | Washington | 53005 | 52286 | 464 |
2356134 | 2356134 | 2022-03-29 | Benton | Washington | 53005 | 52256 | 464 |
2352881 | 2352881 | 2022-03-28 | Benton | Washington | 53005 | 52256 | 464 |
2349629 | 2349629 | 2022-03-27 | Benton | Washington | 53005 | 52233 | 464 |
2346376 | 2346376 | 2022-03-26 | Benton | Washington | 53005 | 52233 | 464 |
2343123 | 2343123 | 2022-03-25 | Benton | Washington | 53005 | 52233 | 464 |
2331597 | 2331597 | 2022-03-22 | Monroe | Michigan | 26115 | 37800 | 464 |
2328345 | 2328345 | 2022-03-21 | Monroe | Michigan | 26115 | 37800 | 464 |
2325092 | 2325092 | 2022-03-20 | Monroe | Michigan | 26115 | 37768 | 464 |
2321838 | 2321838 | 2022-03-19 | Monroe | Michigan | 26115 | 37768 | 464 |
2318584 | 2318584 | 2022-03-18 | Monroe | Michigan | 26115 | 37768 | 464 |
2287388 | 2287388 | 2022-03-08 | Wilson | Tennessee | 47189 | 41368 | 464 |
2283321 | 2283321 | 2022-03-07 | Sussex | New Jersey | 34037 | 33517 | 464 |
2284136 | 2284136 | 2022-03-07 | Wilson | Tennessee | 47189 | 41368 | 464 |
2280068 | 2280068 | 2022-03-06 | Sussex | New Jersey | 34037 | 33498 | 464 |
2280884 | 2280884 | 2022-03-06 | Wilson | Tennessee | 47189 | 41368 | 464 |
2276815 | 2276815 | 2022-03-05 | Sussex | New Jersey | 34037 | 33488 | 464 |
2277631 | 2277631 | 2022-03-05 | Wilson | Tennessee | 47189 | 41368 | 464 |
2273562 | 2273562 | 2022-03-04 | Sussex | New Jersey | 34037 | 33476 | 464 |
2274378 | 2274378 | 2022-03-04 | Wilson | Tennessee | 47189 | 41368 | 464 |
2270310 | 2270310 | 2022-03-03 | Sussex | New Jersey | 34037 | 33463 | 464 |
2271125 | 2271125 | 2022-03-03 | Wilson | Tennessee | 47189 | 41368 | 464 |
2267057 | 2267057 | 2022-03-02 | Sussex | New Jersey | 34037 | 33443 | 464 |
2267873 | 2267873 | 2022-03-02 | Wilson | Tennessee | 47189 | 41368 | 464 |
2262423 | 2262423 | 2022-03-01 | Coweta | Georgia | 13077 | 32755 | 464 |
2263806 | 2263806 | 2022-03-01 | Sussex | New Jersey | 34037 | 33415 | 464 |
2264623 | 2264623 | 2022-03-01 | Angelina | Texas | 48005 | 15238 | 464 |
2259172 | 2259172 | 2022-02-28 | Coweta | Georgia | 13077 | 32739 | 464 |
2260555 | 2260555 | 2022-02-28 | Sussex | New Jersey | 34037 | 33398 | 464 |
2260994 | 2260994 | 2022-02-28 | Lane | Oregon | 41039 | 56178 | 464 |
2261373 | 2261373 | 2022-02-28 | Angelina | Texas | 48005 | 15235 | 464 |
2258122 | 2258122 | 2022-02-27 | Angelina | Texas | 48005 | 15235 | 464 |
2254871 | 2254871 | 2022-02-26 | Angelina | Texas | 48005 | 15235 | 464 |
2249127 | 2249127 | 2022-02-25 | Garland | Arkansas | 5051 | 22471 | 464 |
2251620 | 2251620 | 2022-02-25 | Angelina | Texas | 48005 | 15224 | 464 |
2247735 | 2247735 | 2022-02-24 | Union | North Carolina | 37179 | 60863 | 464 |
2248369 | 2248369 | 2022-02-24 | Angelina | Texas | 48005 | 15217 | 464 |
2242955 | 2242955 | 2022-02-23 | Houston | Georgia | 13153 | 39049 | 464 |
2244484 | 2244484 | 2022-02-23 | Union | North Carolina | 37179 | 60775 | 464 |
2244734 | 2244734 | 2022-02-23 | Jackson | Oregon | 41029 | 41782 | 464 |
2245118 | 2245118 | 2022-02-23 | Angelina | Texas | 48005 | 15216 | 464 |
2239550 | 2239550 | 2022-02-22 | Middlesex | Connecticut | 9007 | 27175 | 464 |
2242398 | 2242398 | 2022-02-22 | Brown | Wisconsin | 55009 | 83219 | 464 |
2236299 | 2236299 | 2022-02-21 | Middlesex | Connecticut | 9007 | 27167 | 464 |
2236424 | 2236424 | 2022-02-21 | Dougherty | Georgia | 13095 | 19344 | 464 |
2239147 | 2239147 | 2022-02-21 | Brown | Wisconsin | 55009 | 83169 | 464 |
2233048 | 2233048 | 2022-02-20 | Middlesex | Connecticut | 9007 | 27000 | 464 |
2235896 | 2235896 | 2022-02-20 | Brown | Wisconsin | 55009 | 83084 | 464 |
2229797 | 2229797 | 2022-02-19 | Middlesex | Connecticut | 9007 | 27000 | 464 |
2232645 | 2232645 | 2022-02-19 | Brown | Wisconsin | 55009 | 83084 | 464 |
2226546 | 2226546 | 2022-02-18 | Middlesex | Connecticut | 9007 | 27000 | 464 |
2229394 | 2229394 | 2022-02-18 | Brown | Wisconsin | 55009 | 83084 | 464 |
2223218 | 2223218 | 2022-02-17 | Sonoma | California | 6097 | 82541 | 464 |
2223295 | 2223295 | 2022-02-17 | Middlesex | Connecticut | 9007 | 26843 | 464 |
2225800 | 2225800 | 2022-02-17 | Randall | Texas | 48381 | 37383 | 464 |
2226143 | 2226143 | 2022-02-17 | Brown | Wisconsin | 55009 | 83029 | 464 |
2226175 | 2226175 | 2022-02-17 | Marathon | Wisconsin | 55073 | 38708 | 464 |
2220044 | 2220044 | 2022-02-16 | Middlesex | Connecticut | 9007 | 26834 | 464 |
2222924 | 2222924 | 2022-02-16 | Marathon | Wisconsin | 55073 | 38672 | 464 |
2216656 | 2216656 | 2022-02-15 | Sebastian | Arkansas | 5131 | 32162 | 464 |
2216928 | 2216928 | 2022-02-15 | Floyd | Georgia | 13115 | 26635 | 464 |
2219673 | 2219673 | 2022-02-15 | Marathon | Wisconsin | 55073 | 38624 | 464 |
2213677 | 2213677 | 2022-02-14 | Floyd | Georgia | 13115 | 26602 | 464 |
2202335 | 2202335 | 2022-02-10 | Medina | Ohio | 39103 | 39508 | 464 |
2199081 | 2199081 | 2022-02-09 | Medina | Ohio | 39103 | 39493 | 464 |
2195827 | 2195827 | 2022-02-08 | Medina | Ohio | 39103 | 39469 | 464 |
2196881 | 2196881 | 2022-02-08 | Dane | Wisconsin | 55025 | 118599 | 464 |
2193626 | 2193626 | 2022-02-07 | Dane | Wisconsin | 55025 | 118303 | 464 |
2176505 | 2176505 | 2022-02-02 | Mercer | Pennsylvania | 42085 | 22633 | 464 |
2169994 | 2169994 | 2022-01-31 | Lebanon | Pennsylvania | 42075 | 35374 | 464 |
2165688 | 2165688 | 2022-01-30 | Berrien | Michigan | 26021 | 32698 | 464 |
2162433 | 2162433 | 2022-01-29 | Berrien | Michigan | 26021 | 32698 | 464 |
2159178 | 2159178 | 2022-01-28 | Berrien | Michigan | 26021 | 32698 | 464 |
2150398 | 2150398 | 2022-01-25 | Clackamas | Oregon | 41005 | 51874 | 464 |
2146127 | 2146127 | 2022-01-24 | Frederick | Maryland | 24021 | 41823 | 464 |
2142872 | 2142872 | 2022-01-23 | Frederick | Maryland | 24021 | 41667 | 464 |
2139617 | 2139617 | 2022-01-22 | Frederick | Maryland | 24021 | 41534 | 464 |
2127372 | 2127372 | 2022-01-18 | Robeson | North Carolina | 37155 | 33120 | 464 |
2124120 | 2124120 | 2022-01-17 | Robeson | North Carolina | 37155 | 31439 | 464 |
2120868 | 2120868 | 2022-01-16 | Robeson | North Carolina | 37155 | 31439 | 464 |
2117616 | 2117616 | 2022-01-15 | Robeson | North Carolina | 37155 | 31439 | 464 |
2114365 | 2114365 | 2022-01-14 | Robeson | North Carolina | 37155 | 31439 | 464 |
2111113 | 2111113 | 2022-01-13 | Robeson | North Carolina | 37155 | 30820 | 464 |
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);