ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
320 rows where deaths = 493 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 35
- Tennessee 30
- Pennsylvania 28
- Delaware 26
- Texas 26
- New Mexico 20
- Georgia 18
- Louisiana 14
- Michigan 13
- Illinois 12
- New York 11
- Arkansas 8
- South Carolina 8
- Indiana 7
- Alabama 5
- Florida 5
- Idaho 5
- North Carolina 5
- Washington 5
- Colorado 4
- Connecticut 4
- Maryland 4
- South Dakota 4
- Wisconsin 4
- California 3
- Minnesota 3
- New Jersey 3
- Arizona 2
- Mississippi 2
- New Hampshire 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497448 | 2497448 | 2022-05-12 | Bossier | Louisiana | 22015 | 37678 | 493 |
2494190 | 2494190 | 2022-05-11 | Bossier | Louisiana | 22015 | 37665 | 493 |
2490932 | 2490932 | 2022-05-10 | Bossier | Louisiana | 22015 | 37653 | 493 |
2492427 | 2492427 | 2022-05-10 | Washington | Tennessee | 47179 | 38741 | 493 |
2487675 | 2487675 | 2022-05-09 | Bossier | Louisiana | 22015 | 37638 | 493 |
2489169 | 2489169 | 2022-05-09 | Washington | Tennessee | 47179 | 38741 | 493 |
2485912 | 2485912 | 2022-05-08 | Washington | Tennessee | 47179 | 38741 | 493 |
2482654 | 2482654 | 2022-05-07 | Washington | Tennessee | 47179 | 38741 | 493 |
2479396 | 2479396 | 2022-05-06 | Washington | Tennessee | 47179 | 38741 | 493 |
2476138 | 2476138 | 2022-05-05 | Washington | Tennessee | 47179 | 38741 | 493 |
2472881 | 2472881 | 2022-05-04 | Washington | Tennessee | 47179 | 38741 | 493 |
2469625 | 2469625 | 2022-05-03 | Washington | Tennessee | 47179 | 38679 | 493 |
2466369 | 2466369 | 2022-05-02 | Washington | Tennessee | 47179 | 38679 | 493 |
2463114 | 2463114 | 2022-05-01 | Washington | Tennessee | 47179 | 38679 | 493 |
2459858 | 2459858 | 2022-04-30 | Washington | Tennessee | 47179 | 38679 | 493 |
2456602 | 2456602 | 2022-04-29 | Washington | Tennessee | 47179 | 38679 | 493 |
2453346 | 2453346 | 2022-04-28 | Washington | Tennessee | 47179 | 38679 | 493 |
2450090 | 2450090 | 2022-04-27 | Washington | Tennessee | 47179 | 38679 | 493 |
2446833 | 2446833 | 2022-04-26 | Washington | Tennessee | 47179 | 38629 | 493 |
2443578 | 2443578 | 2022-04-25 | Washington | Tennessee | 47179 | 38629 | 493 |
2440322 | 2440322 | 2022-04-24 | Washington | Tennessee | 47179 | 38629 | 493 |
2437066 | 2437066 | 2022-04-23 | Washington | Tennessee | 47179 | 38629 | 493 |
2433810 | 2433810 | 2022-04-22 | Washington | Tennessee | 47179 | 38629 | 493 |
2430554 | 2430554 | 2022-04-21 | Washington | Tennessee | 47179 | 38629 | 493 |
2427298 | 2427298 | 2022-04-20 | Washington | Tennessee | 47179 | 38629 | 493 |
2421882 | 2421882 | 2022-04-19 | Houston | Georgia | 13153 | 39363 | 493 |
2424042 | 2424042 | 2022-04-19 | Washington | Tennessee | 47179 | 38557 | 493 |
2418626 | 2418626 | 2022-04-18 | Houston | Georgia | 13153 | 39363 | 493 |
2420786 | 2420786 | 2022-04-18 | Washington | Tennessee | 47179 | 38557 | 493 |
2415370 | 2415370 | 2022-04-17 | Houston | Georgia | 13153 | 39362 | 493 |
2417530 | 2417530 | 2022-04-17 | Washington | Tennessee | 47179 | 38557 | 493 |
2412114 | 2412114 | 2022-04-16 | Houston | Georgia | 13153 | 39362 | 493 |
2414274 | 2414274 | 2022-04-16 | Washington | Tennessee | 47179 | 38557 | 493 |
2408858 | 2408858 | 2022-04-15 | Houston | Georgia | 13153 | 39362 | 493 |
2411018 | 2411018 | 2022-04-15 | Washington | Tennessee | 47179 | 38557 | 493 |
2407762 | 2407762 | 2022-04-14 | Washington | Tennessee | 47179 | 38557 | 493 |
2404506 | 2404506 | 2022-04-13 | Washington | Tennessee | 47179 | 38557 | 493 |
2381240 | 2381240 | 2022-04-06 | Tuscarawas | Ohio | 39157 | 20574 | 493 |
2377985 | 2377985 | 2022-04-05 | Tuscarawas | Ohio | 39157 | 20574 | 493 |
2374731 | 2374731 | 2022-04-04 | Tuscarawas | Ohio | 39157 | 20574 | 493 |
2371479 | 2371479 | 2022-04-03 | Tuscarawas | Ohio | 39157 | 20574 | 493 |
2368226 | 2368226 | 2022-04-02 | Tuscarawas | Ohio | 39157 | 20574 | 493 |
2364973 | 2364973 | 2022-04-01 | Tuscarawas | Ohio | 39157 | 20574 | 493 |
2361720 | 2361720 | 2022-03-31 | Tuscarawas | Ohio | 39157 | 20574 | 493 |
2350966 | 2350966 | 2022-03-28 | Lafayette | Louisiana | 22055 | 62270 | 493 |
2347713 | 2347713 | 2022-03-27 | Lafayette | Louisiana | 22055 | 62266 | 493 |
2344460 | 2344460 | 2022-03-26 | Lafayette | Louisiana | 22055 | 62266 | 493 |
2341207 | 2341207 | 2022-03-25 | Lafayette | Louisiana | 22055 | 62266 | 493 |
2337954 | 2337954 | 2022-03-24 | Lafayette | Louisiana | 22055 | 62222 | 493 |
2323825 | 2323825 | 2022-03-20 | Houston | Alabama | 1069 | 24991 | 493 |
2320571 | 2320571 | 2022-03-19 | Houston | Alabama | 1069 | 24991 | 493 |
2317317 | 2317317 | 2022-03-18 | Houston | Alabama | 1069 | 24991 | 493 |
2307660 | 2307660 | 2022-03-15 | Garland | Arkansas | 5051 | 23017 | 493 |
2310694 | 2310694 | 2022-03-15 | Dane | Wisconsin | 55025 | 122997 | 493 |
2304409 | 2304409 | 2022-03-14 | Garland | Arkansas | 5051 | 22969 | 493 |
2306582 | 2306582 | 2022-03-14 | Mercer | Pennsylvania | 42085 | 23238 | 493 |
2301157 | 2301157 | 2022-03-13 | Garland | Arkansas | 5051 | 22960 | 493 |
2303331 | 2303331 | 2022-03-13 | Mercer | Pennsylvania | 42085 | 23238 | 493 |
2300079 | 2300079 | 2022-03-12 | Mercer | Pennsylvania | 42085 | 23236 | 493 |
2288704 | 2288704 | 2022-03-09 | Tazewell | Illinois | 17179 | 36351 | 493 |
2287922 | 2287922 | 2022-03-08 | Brown | Wisconsin | 55009 | 83575 | 493 |
2282174 | 2282174 | 2022-03-07 | McHenry | Illinois | 17111 | 75084 | 493 |
2259191 | 2259191 | 2022-02-28 | Floyd | Georgia | 13115 | 26973 | 493 |
2241542 | 2241542 | 2022-02-22 | Lebanon | Pennsylvania | 42075 | 36241 | 493 |
2238291 | 2238291 | 2022-02-21 | Lebanon | Pennsylvania | 42075 | 36209 | 493 |
2238500 | 2238500 | 2022-02-21 | Minnehaha | South Dakota | 46099 | 56639 | 493 |
2235040 | 2235040 | 2022-02-20 | Lebanon | Pennsylvania | 42075 | 36209 | 493 |
2235249 | 2235249 | 2022-02-20 | Minnehaha | South Dakota | 46099 | 56639 | 493 |
2231998 | 2231998 | 2022-02-19 | Minnehaha | South Dakota | 46099 | 56639 | 493 |
2228747 | 2228747 | 2022-02-18 | Minnehaha | South Dakota | 46099 | 56639 | 493 |
2224772 | 2224772 | 2022-02-17 | Rockingham | New Hampshire | 33015 | 64495 | 493 |
2221521 | 2221521 | 2022-02-16 | Rockingham | New Hampshire | 33015 | 64302 | 493 |
2215537 | 2215537 | 2022-02-14 | Lycoming | Pennsylvania | 42081 | 27923 | 493 |
2212286 | 2212286 | 2022-02-13 | Lycoming | Pennsylvania | 42081 | 27888 | 493 |
2208574 | 2208574 | 2022-02-12 | Albany | New York | 36001 | 57236 | 493 |
2209033 | 2209033 | 2022-02-12 | Lycoming | Pennsylvania | 42081 | 27859 | 493 |
2205321 | 2205321 | 2022-02-11 | Albany | New York | 36001 | 57166 | 493 |
2202531 | 2202531 | 2022-02-10 | Monroe | Pennsylvania | 42089 | 36195 | 493 |
2191139 | 2191139 | 2022-02-07 | Rock Island | Illinois | 17161 | 32101 | 493 |
2189187 | 2189187 | 2022-02-06 | Robeson | North Carolina | 37155 | 38406 | 493 |
2185934 | 2185934 | 2022-02-05 | Robeson | North Carolina | 37155 | 38406 | 493 |
2182682 | 2182682 | 2022-02-04 | Robeson | North Carolina | 37155 | 38406 | 493 |
2179430 | 2179430 | 2022-02-03 | Robeson | North Carolina | 37155 | 38197 | 493 |
2175627 | 2175627 | 2022-02-02 | DeSoto | Mississippi | 28033 | 46974 | 493 |
2176046 | 2176046 | 2022-02-02 | Broome | New York | 36007 | 42592 | 493 |
2160241 | 2160241 | 2022-01-28 | Northumberland | Pennsylvania | 42097 | 21418 | 493 |
2156817 | 2156817 | 2022-01-27 | Warren | Ohio | 39165 | 54489 | 493 |
2151701 | 2151701 | 2022-01-26 | Mesa | Colorado | 8077 | 37109 | 493 |
2152153 | 2152153 | 2022-01-26 | Hendricks | Indiana | 18063 | 38282 | 493 |
2153564 | 2153564 | 2022-01-26 | Warren | Ohio | 39165 | 54195 | 493 |
2154089 | 2154089 | 2022-01-26 | Comal | Texas | 48091 | 28933 | 493 |
2150312 | 2150312 | 2022-01-25 | Warren | Ohio | 39165 | 53550 | 493 |
2133056 | 2133056 | 2022-01-20 | Rapides | Louisiana | 22079 | 27942 | 493 |
2126669 | 2126669 | 2022-01-18 | Jackson | Michigan | 26075 | 37980 | 493 |
2123417 | 2123417 | 2022-01-17 | Jackson | Michigan | 26075 | 37980 | 493 |
2120165 | 2120165 | 2022-01-16 | Jackson | Michigan | 26075 | 37980 | 493 |
2116913 | 2116913 | 2022-01-15 | Jackson | Michigan | 26075 | 37980 | 493 |
2113662 | 2113662 | 2022-01-14 | Jackson | Michigan | 26075 | 37980 | 493 |
2107755 | 2107755 | 2022-01-12 | Niagara | New York | 36063 | 40675 | 493 |
2103879 | 2103879 | 2022-01-11 | Bay | Michigan | 26017 | 20808 | 493 |
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);