ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where deaths = 311 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 87
- Ohio 59
- Georgia 53
- Texas 42
- Virginia 42
- Pennsylvania 40
- California 39
- Illinois 38
- Michigan 36
- Wisconsin 35
- Florida 34
- Oklahoma 31
- Alabama 29
- Tennessee 28
- South Carolina 20
- Indiana 19
- Arizona 12
- Minnesota 12
- Utah 12
- New Mexico 10
- Louisiana 9
- Maryland 9
- South Dakota 8
- Washington 8
- Arkansas 7
- Idaho 7
- New Hampshire 7
- New Jersey 5
- New York 5
- Connecticut 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502014 | 2502014 | 2022-05-13 | Darlington | South Carolina | 45031 | 18939 | 311 |
2498756 | 2498756 | 2022-05-12 | Darlington | South Carolina | 45031 | 18939 | 311 |
2495498 | 2495498 | 2022-05-11 | Darlington | South Carolina | 45031 | 18939 | 311 |
2428171 | 2428171 | 2022-04-21 | Yolo | California | 6113 | 40000 | 311 |
2424915 | 2424915 | 2022-04-20 | Yolo | California | 6113 | 40000 | 311 |
2421659 | 2421659 | 2022-04-19 | Yolo | California | 6113 | 40000 | 311 |
2392809 | 2392809 | 2022-04-10 | Vermilion | Illinois | 17183 | 27891 | 311 |
2389553 | 2389553 | 2022-04-09 | Vermilion | Illinois | 17183 | 27891 | 311 |
2386298 | 2386298 | 2022-04-08 | Vermilion | Illinois | 17183 | 27891 | 311 |
2383043 | 2383043 | 2022-04-07 | Vermilion | Illinois | 17183 | 27885 | 311 |
2379788 | 2379788 | 2022-04-06 | Vermilion | Illinois | 17183 | 27882 | 311 |
2376534 | 2376534 | 2022-04-05 | Vermilion | Illinois | 17183 | 27873 | 311 |
2373282 | 2373282 | 2022-04-04 | Vermilion | Illinois | 17183 | 27870 | 311 |
2375803 | 2375803 | 2022-04-04 | Sheboygan | Wisconsin | 55117 | 32406 | 311 |
2370029 | 2370029 | 2022-04-03 | Vermilion | Illinois | 17183 | 27861 | 311 |
2372551 | 2372551 | 2022-04-03 | Sheboygan | Wisconsin | 55117 | 32392 | 311 |
2366776 | 2366776 | 2022-04-02 | Vermilion | Illinois | 17183 | 27861 | 311 |
2369298 | 2369298 | 2022-04-02 | Sheboygan | Wisconsin | 55117 | 32392 | 311 |
2363523 | 2363523 | 2022-04-01 | Vermilion | Illinois | 17183 | 27861 | 311 |
2366045 | 2366045 | 2022-04-01 | Sheboygan | Wisconsin | 55117 | 32392 | 311 |
2360269 | 2360269 | 2022-03-31 | Vermilion | Illinois | 17183 | 27856 | 311 |
2362792 | 2362792 | 2022-03-31 | Sheboygan | Wisconsin | 55117 | 32389 | 311 |
2357015 | 2357015 | 2022-03-30 | Vermilion | Illinois | 17183 | 27849 | 311 |
2359538 | 2359538 | 2022-03-30 | Sheboygan | Wisconsin | 55117 | 32377 | 311 |
2353514 | 2353514 | 2022-03-29 | Fayette | Georgia | 13113 | 22221 | 311 |
2353762 | 2353762 | 2022-03-29 | Vermilion | Illinois | 17183 | 27848 | 311 |
2356284 | 2356284 | 2022-03-29 | Sheboygan | Wisconsin | 55117 | 32372 | 311 |
2350262 | 2350262 | 2022-03-28 | Fayette | Georgia | 13113 | 22206 | 311 |
2350510 | 2350510 | 2022-03-28 | Vermilion | Illinois | 17183 | 27840 | 311 |
2353031 | 2353031 | 2022-03-28 | Sheboygan | Wisconsin | 55117 | 32366 | 311 |
2346806 | 2346806 | 2022-03-27 | Yolo | California | 6113 | 39411 | 311 |
2347257 | 2347257 | 2022-03-27 | Vermilion | Illinois | 17183 | 27841 | 311 |
2343553 | 2343553 | 2022-03-26 | Yolo | California | 6113 | 39411 | 311 |
2344004 | 2344004 | 2022-03-26 | Vermilion | Illinois | 17183 | 27841 | 311 |
2340300 | 2340300 | 2022-03-25 | Yolo | California | 6113 | 39411 | 311 |
2340751 | 2340751 | 2022-03-25 | Vermilion | Illinois | 17183 | 27841 | 311 |
2332215 | 2332215 | 2022-03-22 | Burke | North Carolina | 37023 | 24982 | 311 |
2332584 | 2332584 | 2022-03-22 | Crawford | Pennsylvania | 42039 | 19723 | 311 |
2328962 | 2328962 | 2022-03-21 | Burke | North Carolina | 37023 | 24982 | 311 |
2329331 | 2329331 | 2022-03-21 | Crawford | Pennsylvania | 42039 | 19720 | 311 |
2326079 | 2326079 | 2022-03-20 | Crawford | Pennsylvania | 42039 | 19717 | 311 |
2322826 | 2322826 | 2022-03-19 | Crawford | Pennsylvania | 42039 | 19716 | 311 |
2317416 | 2317416 | 2022-03-18 | Faulkner | Arkansas | 5045 | 34941 | 311 |
2319572 | 2319572 | 2022-03-18 | Crawford | Pennsylvania | 42039 | 19714 | 311 |
2316318 | 2316318 | 2022-03-17 | Crawford | Pennsylvania | 42039 | 19712 | 311 |
2312883 | 2312883 | 2022-03-16 | Jefferson | Ohio | 39081 | 14643 | 311 |
2313065 | 2313065 | 2022-03-16 | Crawford | Pennsylvania | 42039 | 19709 | 311 |
2309630 | 2309630 | 2022-03-15 | Jefferson | Ohio | 39081 | 14643 | 311 |
2309812 | 2309812 | 2022-03-15 | Crawford | Pennsylvania | 42039 | 19706 | 311 |
2306377 | 2306377 | 2022-03-14 | Jefferson | Ohio | 39081 | 14643 | 311 |
2306702 | 2306702 | 2022-03-14 | Cherokee | South Carolina | 45021 | 14515 | 311 |
2303126 | 2303126 | 2022-03-13 | Jefferson | Ohio | 39081 | 14643 | 311 |
2303451 | 2303451 | 2022-03-13 | Cherokee | South Carolina | 45021 | 14515 | 311 |
2299874 | 2299874 | 2022-03-12 | Jefferson | Ohio | 39081 | 14640 | 311 |
2300199 | 2300199 | 2022-03-12 | Cherokee | South Carolina | 45021 | 14515 | 311 |
2296622 | 2296622 | 2022-03-11 | Jefferson | Ohio | 39081 | 14636 | 311 |
2296947 | 2296947 | 2022-03-11 | Cherokee | South Carolina | 45021 | 14515 | 311 |
2293552 | 2293552 | 2022-03-10 | Crawford | Pennsylvania | 42039 | 19690 | 311 |
2293695 | 2293695 | 2022-03-10 | Cherokee | South Carolina | 45021 | 14505 | 311 |
2294291 | 2294291 | 2022-03-10 | Portsmouth city | Virginia | 51740 | 20650 | 311 |
2294488 | 2294488 | 2022-03-10 | Washington | Wisconsin | 55131 | 37790 | 311 |
2290300 | 2290300 | 2022-03-09 | Crawford | Pennsylvania | 42039 | 19684 | 311 |
2290443 | 2290443 | 2022-03-09 | Cherokee | South Carolina | 45021 | 14500 | 311 |
2291039 | 2291039 | 2022-03-09 | Portsmouth city | Virginia | 51740 | 20649 | 311 |
2287048 | 2287048 | 2022-03-08 | Crawford | Pennsylvania | 42039 | 19678 | 311 |
2287191 | 2287191 | 2022-03-08 | Cherokee | South Carolina | 45021 | 14492 | 311 |
2287302 | 2287302 | 2022-03-08 | Carter | Tennessee | 47019 | 16302 | 311 |
2287787 | 2287787 | 2022-03-08 | Portsmouth city | Virginia | 51740 | 20640 | 311 |
2287931 | 2287931 | 2022-03-08 | Dodge | Wisconsin | 55027 | 26924 | 311 |
2281682 | 2281682 | 2022-03-07 | Saline | Arkansas | 5125 | 30572 | 311 |
2283939 | 2283939 | 2022-03-07 | Cherokee | South Carolina | 45021 | 14491 | 311 |
2284050 | 2284050 | 2022-03-07 | Carter | Tennessee | 47019 | 16302 | 311 |
2284535 | 2284535 | 2022-03-07 | Portsmouth city | Virginia | 51740 | 20630 | 311 |
2278429 | 2278429 | 2022-03-06 | Saline | Arkansas | 5125 | 30566 | 311 |
2280798 | 2280798 | 2022-03-06 | Carter | Tennessee | 47019 | 16302 | 311 |
2275176 | 2275176 | 2022-03-05 | Saline | Arkansas | 5125 | 30547 | 311 |
2277545 | 2277545 | 2022-03-05 | Carter | Tennessee | 47019 | 16302 | 311 |
2271923 | 2271923 | 2022-03-04 | Saline | Arkansas | 5125 | 30519 | 311 |
2272947 | 2272947 | 2022-03-04 | Penobscot | Maine | 23019 | 26648 | 311 |
2274292 | 2274292 | 2022-03-04 | Carter | Tennessee | 47019 | 16302 | 311 |
2270447 | 2270447 | 2022-03-03 | Harnett | North Carolina | 37085 | 32013 | 311 |
2271039 | 2271039 | 2022-03-03 | Carter | Tennessee | 47019 | 16302 | 311 |
2267215 | 2267215 | 2022-03-02 | Moore | North Carolina | 37125 | 23938 | 311 |
2267787 | 2267787 | 2022-03-02 | Carter | Tennessee | 47019 | 16302 | 311 |
2262334 | 2262334 | 2022-03-01 | Flagler | Florida | 12035 | 22066 | 311 |
2263963 | 2263963 | 2022-03-01 | Moore | North Carolina | 37125 | 23920 | 311 |
2259083 | 2259083 | 2022-02-28 | Flagler | Florida | 12035 | 22066 | 311 |
2260712 | 2260712 | 2022-02-28 | Moore | North Carolina | 37125 | 23913 | 311 |
2255832 | 2255832 | 2022-02-27 | Flagler | Florida | 12035 | 22066 | 311 |
2252581 | 2252581 | 2022-02-26 | Flagler | Florida | 12035 | 22066 | 311 |
2249330 | 2249330 | 2022-02-25 | Flagler | Florida | 12035 | 22066 | 311 |
2246079 | 2246079 | 2022-02-24 | Flagler | Florida | 12035 | 21957 | 311 |
2247361 | 2247361 | 2022-02-24 | Cascade | Montana | 30013 | 24053 | 311 |
2242828 | 2242828 | 2022-02-23 | Flagler | Florida | 12035 | 21957 | 311 |
2244317 | 2244317 | 2022-02-23 | Lea | New Mexico | 35025 | 19986 | 311 |
2240527 | 2240527 | 2022-02-22 | Lenawee | Michigan | 26091 | 25553 | 311 |
2237276 | 2237276 | 2022-02-21 | Lenawee | Michigan | 26091 | 25553 | 311 |
2234025 | 2234025 | 2022-02-20 | Lenawee | Michigan | 26091 | 25553 | 311 |
2230774 | 2230774 | 2022-02-19 | Lenawee | Michigan | 26091 | 25502 | 311 |
2227523 | 2227523 | 2022-02-18 | Lenawee | Michigan | 26091 | 25502 | 311 |
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);