ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where deaths = 852 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Texas 18
- Arizona 12
- Colorado 11
- California 8
- Pennsylvania 8
- Georgia 4
- Florida 3
- Illinois 3
- Indiana 3
- Maryland 3
- North Carolina 3
- New Jersey 2
- Alabama 1
- Arkansas 1
- Massachusetts 1
- Michigan 1
- Missouri 1
- Nebraska 1
- New Hampshire 1
- New York 1
- South Carolina 1
- Tennessee 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489258 | 2489258 | 2022-05-09 | Galveston | Texas | 48167 | 96436 | 852 |
2486001 | 2486001 | 2022-05-08 | Galveston | Texas | 48167 | 96405 | 852 |
2482743 | 2482743 | 2022-05-07 | Galveston | Texas | 48167 | 96373 | 852 |
2479485 | 2479485 | 2022-05-06 | Galveston | Texas | 48167 | 96340 | 852 |
2476227 | 2476227 | 2022-05-05 | Galveston | Texas | 48167 | 96302 | 852 |
2472970 | 2472970 | 2022-05-04 | Galveston | Texas | 48167 | 96270 | 852 |
2469714 | 2469714 | 2022-05-03 | Galveston | Texas | 48167 | 96244 | 852 |
2466458 | 2466458 | 2022-05-02 | Galveston | Texas | 48167 | 96226 | 852 |
2463203 | 2463203 | 2022-05-01 | Galveston | Texas | 48167 | 96204 | 852 |
2459947 | 2459947 | 2022-04-30 | Galveston | Texas | 48167 | 96178 | 852 |
2324206 | 2324206 | 2022-03-20 | Chatham | Georgia | 13051 | 63101 | 852 |
2320952 | 2320952 | 2022-03-19 | Chatham | Georgia | 13051 | 63101 | 852 |
2317698 | 2317698 | 2022-03-18 | Chatham | Georgia | 13051 | 63101 | 852 |
2304784 | 2304784 | 2022-03-14 | Richmond | Georgia | 13245 | 49802 | 852 |
2288671 | 2288671 | 2022-03-09 | Madison | Illinois | 17119 | 69888 | 852 |
2279035 | 2279035 | 2022-03-06 | St. Joseph | Indiana | 18141 | 70280 | 852 |
2275782 | 2275782 | 2022-03-05 | St. Joseph | Indiana | 18141 | 70280 | 852 |
2272529 | 2272529 | 2022-03-04 | St. Joseph | Indiana | 18141 | 70280 | 852 |
2258365 | 2258365 | 2022-02-27 | Williamson | Texas | 48491 | 130903 | 852 |
2255114 | 2255114 | 2022-02-26 | Williamson | Texas | 48491 | 130903 | 852 |
2251631 | 2251631 | 2022-02-25 | Bell | Texas | 48027 | 65996 | 852 |
2251863 | 2251863 | 2022-02-25 | Williamson | Texas | 48491 | 130903 | 852 |
2232272 | 2232272 | 2022-02-19 | McLennan | Texas | 48309 | 55820 | 852 |
2223027 | 2223027 | 2022-02-17 | Madison | Alabama | 1089 | 87330 | 852 |
2202006 | 2202006 | 2022-02-10 | Hillsborough | New Hampshire | 33011 | 92642 | 852 |
2193909 | 2193909 | 2022-02-08 | Imperial | California | 6025 | 62167 | 852 |
2190656 | 2190656 | 2022-02-07 | Imperial | California | 6025 | 61874 | 852 |
2187403 | 2187403 | 2022-02-06 | Imperial | California | 6025 | 61631 | 852 |
2184150 | 2184150 | 2022-02-05 | Imperial | California | 6025 | 61631 | 852 |
2180898 | 2180898 | 2022-02-04 | Imperial | California | 6025 | 61631 | 852 |
2177647 | 2177647 | 2022-02-03 | Imperial | California | 6025 | 61353 | 852 |
2140291 | 2140291 | 2022-01-22 | Rockland | New York | 36087 | 87911 | 852 |
2134732 | 2134732 | 2022-01-20 | Smith | Texas | 48423 | 39195 | 852 |
2112352 | 2112352 | 2022-01-13 | Waukesha | Wisconsin | 55133 | 83829 | 852 |
2033426 | 2033426 | 2021-12-20 | Northampton | Pennsylvania | 42095 | 54047 | 852 |
2030176 | 2030176 | 2021-12-19 | Northampton | Pennsylvania | 42095 | 53806 | 852 |
2026925 | 2026925 | 2021-12-18 | Northampton | Pennsylvania | 42095 | 53535 | 852 |
2013153 | 2013153 | 2021-12-14 | Jackson | Missouri | 29095 | 62512 | 852 |
1938542 | 1938542 | 2021-11-21 | Douglas | Nebraska | 31055 | 91182 | 852 |
1787618 | 1787618 | 2021-10-06 | Adams | Colorado | 8001 | 72765 | 852 |
1784369 | 1784369 | 2021-10-05 | Adams | Colorado | 8001 | 72628 | 852 |
1786403 | 1786403 | 2021-10-05 | Chester | Pennsylvania | 42029 | 48201 | 852 |
1779623 | 1779623 | 2021-10-03 | Wake | North Carolina | 37183 | 125335 | 852 |
1776373 | 1776373 | 2021-10-02 | Wake | North Carolina | 37183 | 125335 | 852 |
1773123 | 1773123 | 2021-10-01 | Wake | North Carolina | 37183 | 125335 | 852 |
1770451 | 1770451 | 2021-09-30 | Knox | Tennessee | 47093 | 74809 | 852 |
1732413 | 1732413 | 2021-09-19 | Jefferson | Colorado | 8059 | 56198 | 852 |
1729163 | 1729163 | 2021-09-18 | Jefferson | Colorado | 8059 | 56198 | 852 |
1725808 | 1725808 | 2021-09-17 | Pulaski | Arkansas | 5119 | 56368 | 852 |
1725913 | 1725913 | 2021-09-17 | Jefferson | Colorado | 8059 | 56198 | 852 |
1714948 | 1714948 | 2021-09-13 | Luzerne | Pennsylvania | 42079 | 35162 | 852 |
1679240 | 1679240 | 2021-09-02 | York | Pennsylvania | 42133 | 50727 | 852 |
1586218 | 1586218 | 2021-08-05 | Denver | Colorado | 8031 | 76835 | 852 |
1582968 | 1582968 | 2021-08-04 | Denver | Colorado | 8031 | 76646 | 852 |
1576319 | 1576319 | 2021-08-02 | Yuma | Arizona | 4027 | 37640 | 852 |
1576470 | 1576470 | 2021-08-02 | Denver | Colorado | 8031 | 76393 | 852 |
1573071 | 1573071 | 2021-08-01 | Yuma | Arizona | 4027 | 37634 | 852 |
1573222 | 1573222 | 2021-08-01 | Denver | Colorado | 8031 | 76110 | 852 |
1569823 | 1569823 | 2021-07-31 | Yuma | Arizona | 4027 | 37605 | 852 |
1569974 | 1569974 | 2021-07-31 | Denver | Colorado | 8031 | 76110 | 852 |
1566575 | 1566575 | 2021-07-30 | Yuma | Arizona | 4027 | 37533 | 852 |
1566726 | 1566726 | 2021-07-30 | Denver | Colorado | 8031 | 76110 | 852 |
1563327 | 1563327 | 2021-07-29 | Yuma | Arizona | 4027 | 37509 | 852 |
1560079 | 1560079 | 2021-07-28 | Yuma | Arizona | 4027 | 37482 | 852 |
1556832 | 1556832 | 2021-07-27 | Yuma | Arizona | 4027 | 37478 | 852 |
1553585 | 1553585 | 2021-07-26 | Yuma | Arizona | 4027 | 37468 | 852 |
1550338 | 1550338 | 2021-07-25 | Yuma | Arizona | 4027 | 37453 | 852 |
1547091 | 1547091 | 2021-07-24 | Yuma | Arizona | 4027 | 37440 | 852 |
1469298 | 1469298 | 2021-06-30 | Tulare | California | 6107 | 49896 | 852 |
1418411 | 1418411 | 2021-06-14 | Kent | Michigan | 26081 | 73214 | 852 |
1404792 | 1404792 | 2021-06-10 | Kane | Illinois | 17089 | 59351 | 852 |
1401547 | 1401547 | 2021-06-09 | Kane | Illinois | 17089 | 59338 | 852 |
1255141 | 1255141 | 2021-04-25 | Brevard | Florida | 12009 | 40323 | 852 |
1251894 | 1251894 | 2021-04-24 | Brevard | Florida | 12009 | 40186 | 852 |
1176977 | 1176977 | 2021-04-01 | Pinal | Arizona | 4021 | 49540 | 852 |
1173730 | 1173730 | 2021-03-31 | Pinal | Arizona | 4021 | 49475 | 852 |
1092815 | 1092815 | 2021-03-06 | Marion | Florida | 12083 | 28026 | 852 |
1076466 | 1076466 | 2021-03-01 | Ventura | California | 6111 | 77749 | 852 |
1079072 | 1079072 | 2021-03-01 | Travis | Texas | 48453 | 75901 | 852 |
1075827 | 1075827 | 2021-02-28 | Travis | Texas | 48453 | 75636 | 852 |
1065678 | 1065678 | 2021-02-25 | Greenville | South Carolina | 45045 | 63241 | 852 |
1022254 | 1022254 | 2021-02-12 | Baltimore city | Maryland | 24510 | 39274 | 852 |
789661 | 789661 | 2020-12-02 | Delaware | Pennsylvania | 42045 | 20762 | 852 |
786416 | 786416 | 2020-12-01 | Delaware | Pennsylvania | 42045 | 20364 | 852 |
743744 | 743744 | 2020-11-18 | Morris | New Jersey | 34027 | 11744 | 852 |
655577 | 655577 | 2020-10-22 | Prince George's | Maryland | 24033 | 32216 | 852 |
610157 | 610157 | 2020-10-08 | Montgomery | Maryland | 24031 | 23333 | 852 |
185785 | 185785 | 2020-05-28 | Suffolk | Massachusetts | 25025 | 17698 | 852 |
128909 | 128909 | 2020-05-09 | Union | New Jersey | 34039 | 13984 | 852 |
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);