ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
127 rows where deaths = 703 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Florida 34
- Texas 23
- Pennsylvania 9
- Louisiana 7
- Alabama 5
- Virginia 5
- Georgia 4
- Missouri 4
- Arkansas 3
- Colorado 3
- Maryland 3
- Massachusetts 3
- Michigan 3
- North Carolina 3
- South Carolina 3
- Washington 3
- California 2
- New Jersey 2
- New Mexico 2
- New York 2
- Illinois 1
- Minnesota 1
- Tennessee 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499882 | 2499882 | 2022-05-13 | Weld | Colorado | 8123 | 85893 | 703 |
2502274 | 2502274 | 2022-05-13 | Ector | Texas | 48135 | 37544 | 703 |
2496624 | 2496624 | 2022-05-12 | Weld | Colorado | 8123 | 85569 | 703 |
2499016 | 2499016 | 2022-05-12 | Ector | Texas | 48135 | 37540 | 703 |
2493366 | 2493366 | 2022-05-11 | Weld | Colorado | 8123 | 85522 | 703 |
2495758 | 2495758 | 2022-05-11 | Ector | Texas | 48135 | 37539 | 703 |
2492500 | 2492500 | 2022-05-10 | Ector | Texas | 48135 | 37536 | 703 |
2489242 | 2489242 | 2022-05-09 | Ector | Texas | 48135 | 37529 | 703 |
2485985 | 2485985 | 2022-05-08 | Ector | Texas | 48135 | 37524 | 703 |
2482727 | 2482727 | 2022-05-07 | Ector | Texas | 48135 | 37523 | 703 |
2479469 | 2479469 | 2022-05-06 | Ector | Texas | 48135 | 37521 | 703 |
2476211 | 2476211 | 2022-05-05 | Ector | Texas | 48135 | 37519 | 703 |
2472954 | 2472954 | 2022-05-04 | Ector | Texas | 48135 | 37518 | 703 |
2469698 | 2469698 | 2022-05-03 | Ector | Texas | 48135 | 37516 | 703 |
2466442 | 2466442 | 2022-05-02 | Ector | Texas | 48135 | 37502 | 703 |
2463187 | 2463187 | 2022-05-01 | Ector | Texas | 48135 | 37500 | 703 |
2459931 | 2459931 | 2022-04-30 | Ector | Texas | 48135 | 37498 | 703 |
2456675 | 2456675 | 2022-04-29 | Ector | Texas | 48135 | 37497 | 703 |
2380226 | 2380226 | 2022-04-06 | Calcasieu | Louisiana | 22019 | 54628 | 703 |
2376971 | 2376971 | 2022-04-05 | Calcasieu | Louisiana | 22019 | 54618 | 703 |
2352631 | 2352631 | 2022-03-28 | Potter | Texas | 48375 | 35659 | 703 |
2349379 | 2349379 | 2022-03-27 | Potter | Texas | 48375 | 35658 | 703 |
2346126 | 2346126 | 2022-03-26 | Potter | Texas | 48375 | 35658 | 703 |
2342873 | 2342873 | 2022-03-25 | Potter | Texas | 48375 | 35658 | 703 |
2268094 | 2268094 | 2022-03-02 | Taylor | Texas | 48441 | 33466 | 703 |
2251268 | 2251268 | 2022-02-25 | Cambria | Pennsylvania | 42021 | 34228 | 703 |
2247562 | 2247562 | 2022-02-24 | Doña Ana | New Mexico | 35013 | 62425 | 703 |
2245443 | 2245443 | 2022-02-23 | Chesterfield | Virginia | 51041 | 70237 | 703 |
2241856 | 2241856 | 2022-02-22 | Unknown | Tennessee | 35300 | 703 | |
2198803 | 2198803 | 2022-02-09 | San Juan | New Mexico | 35045 | 38934 | 703 |
2200019 | 2200019 | 2022-02-09 | Virginia Beach city | Virginia | 51810 | 87077 | 703 |
2168185 | 2168185 | 2022-01-31 | Muscogee | Georgia | 13215 | 36136 | 703 |
2169290 | 2169290 | 2022-01-31 | St. Louis city | Missouri | 29510 | 53792 | 703 |
2166035 | 2166035 | 2022-01-30 | St. Louis city | Missouri | 29510 | 53689 | 703 |
2151641 | 2151641 | 2022-01-26 | San Francisco | California | 6075 | 115878 | 703 |
2148389 | 2148389 | 2022-01-25 | San Francisco | California | 6075 | 115042 | 703 |
2149511 | 2149511 | 2022-01-25 | Dakota | Minnesota | 27037 | 96143 | 703 |
2133208 | 2133208 | 2022-01-20 | Ottawa | Michigan | 26139 | 65259 | 703 |
2129955 | 2129955 | 2022-01-19 | Ottawa | Michigan | 26139 | 65259 | 703 |
2105992 | 2105992 | 2022-01-12 | Benton | Arkansas | 5007 | 51410 | 703 |
2102741 | 2102741 | 2022-01-11 | Benton | Arkansas | 5007 | 50709 | 703 |
2080198 | 2080198 | 2022-01-04 | Clay | Florida | 12019 | 35827 | 703 |
2076946 | 2076946 | 2022-01-03 | Clay | Florida | 12019 | 35827 | 703 |
2073695 | 2073695 | 2022-01-02 | Clay | Florida | 12019 | 35827 | 703 |
2070444 | 2070444 | 2022-01-01 | Clay | Florida | 12019 | 35827 | 703 |
2067193 | 2067193 | 2021-12-31 | Clay | Florida | 12019 | 35827 | 703 |
2063942 | 2063942 | 2021-12-30 | Clay | Florida | 12019 | 34622 | 703 |
2060692 | 2060692 | 2021-12-29 | Clay | Florida | 12019 | 34622 | 703 |
2057436 | 2057436 | 2021-12-28 | Bay | Florida | 12005 | 32283 | 703 |
2057443 | 2057443 | 2021-12-28 | Clay | Florida | 12019 | 34622 | 703 |
2054187 | 2054187 | 2021-12-27 | Bay | Florida | 12005 | 32283 | 703 |
2054194 | 2054194 | 2021-12-27 | Clay | Florida | 12019 | 34622 | 703 |
2050937 | 2050937 | 2021-12-26 | Bay | Florida | 12005 | 32283 | 703 |
2050944 | 2050944 | 2021-12-26 | Clay | Florida | 12019 | 34622 | 703 |
2047687 | 2047687 | 2021-12-25 | Bay | Florida | 12005 | 32283 | 703 |
2047694 | 2047694 | 2021-12-25 | Clay | Florida | 12019 | 34622 | 703 |
2044437 | 2044437 | 2021-12-24 | Bay | Florida | 12005 | 32283 | 703 |
2044444 | 2044444 | 2021-12-24 | Clay | Florida | 12019 | 34622 | 703 |
2041188 | 2041188 | 2021-12-23 | Bay | Florida | 12005 | 32114 | 703 |
2041195 | 2041195 | 2021-12-23 | Clay | Florida | 12019 | 34315 | 703 |
2037938 | 2037938 | 2021-12-22 | Bay | Florida | 12005 | 32114 | 703 |
2037945 | 2037945 | 2021-12-22 | Clay | Florida | 12019 | 34315 | 703 |
2039899 | 2039899 | 2021-12-22 | Cumberland | Pennsylvania | 42041 | 34977 | 703 |
2034695 | 2034695 | 2021-12-21 | Clay | Florida | 12019 | 34315 | 703 |
2031445 | 2031445 | 2021-12-20 | Clay | Florida | 12019 | 34315 | 703 |
2028194 | 2028194 | 2021-12-19 | Clay | Florida | 12019 | 34315 | 703 |
2024943 | 2024943 | 2021-12-18 | Clay | Florida | 12019 | 34315 | 703 |
2021692 | 2021692 | 2021-12-17 | Clay | Florida | 12019 | 34315 | 703 |
2018441 | 2018441 | 2021-12-16 | Clay | Florida | 12019 | 34204 | 703 |
2015191 | 2015191 | 2021-12-15 | Clay | Florida | 12019 | 34204 | 703 |
2011940 | 2011940 | 2021-12-14 | Clay | Florida | 12019 | 34204 | 703 |
1904761 | 1904761 | 2021-11-11 | Chatham | Georgia | 13051 | 38886 | 703 |
1907054 | 1907054 | 2021-11-11 | Galveston | Texas | 48167 | 64642 | 703 |
1901511 | 1901511 | 2021-11-10 | Chatham | Georgia | 13051 | 38886 | 703 |
1854782 | 1854782 | 2021-10-26 | Charleston | South Carolina | 45019 | 65048 | 703 |
1851533 | 1851533 | 2021-10-25 | Charleston | South Carolina | 45019 | 65026 | 703 |
1826097 | 1826097 | 2021-10-17 | Henrico | Virginia | 51087 | 33701 | 703 |
1822848 | 1822848 | 2021-10-16 | Henrico | Virginia | 51087 | 33701 | 703 |
1819599 | 1819599 | 2021-10-15 | Henrico | Virginia | 51087 | 33701 | 703 |
1806918 | 1806918 | 2021-10-12 | Montgomery | Alabama | 1101 | 33815 | 703 |
1803667 | 1803667 | 2021-10-11 | Montgomery | Alabama | 1101 | 33771 | 703 |
1804790 | 1804790 | 2021-10-11 | St. Tammany | Louisiana | 22103 | 43076 | 703 |
1806840 | 1806840 | 2021-10-11 | Waukesha | Wisconsin | 55133 | 60447 | 703 |
1800418 | 1800418 | 2021-10-10 | Montgomery | Alabama | 1101 | 33758 | 703 |
1801541 | 1801541 | 2021-10-10 | St. Tammany | Louisiana | 22103 | 42999 | 703 |
1797169 | 1797169 | 2021-10-09 | Montgomery | Alabama | 1101 | 33743 | 703 |
1798292 | 1798292 | 2021-10-09 | St. Tammany | Louisiana | 22103 | 42999 | 703 |
1795043 | 1795043 | 2021-10-08 | St. Tammany | Louisiana | 22103 | 42999 | 703 |
1783965 | 1783965 | 2021-10-04 | Snohomish | Washington | 53061 | 59991 | 703 |
1741093 | 1741093 | 2021-09-21 | Richland | South Carolina | 45079 | 64918 | 703 |
1724268 | 1724268 | 2021-09-16 | Onondaga | New York | 36067 | 44884 | 703 |
1688208 | 1688208 | 2021-09-05 | Kansas City | Missouri | 57585 | 703 | |
1684958 | 1684958 | 2021-09-04 | Kansas City | Missouri | 57461 | 703 | |
1649472 | 1649472 | 2021-08-24 | Atlantic | New Jersey | 34001 | 33683 | 703 |
1608543 | 1608543 | 2021-08-11 | Spokane | Washington | 53063 | 51306 | 703 |
1605294 | 1605294 | 2021-08-10 | Spokane | Washington | 53063 | 51088 | 703 |
1560139 | 1560139 | 2021-07-28 | Pulaski | Arkansas | 5119 | 46056 | 703 |
1331431 | 1331431 | 2021-05-18 | Guilford | North Carolina | 37081 | 47783 | 703 |
1328184 | 1328184 | 2021-05-17 | Guilford | North Carolina | 37081 | 47744 | 703 |
1318812 | 1318812 | 2021-05-14 | Northampton | Pennsylvania | 42095 | 35282 | 703 |
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);