ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
82 rows where deaths = 946 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Tennessee 17
- New Jersey 11
- Florida 10
- Alabama 7
- Delaware 5
- North Carolina 4
- California 3
- Missouri 3
- Ohio 3
- Pennsylvania 3
- Colorado 2
- Illinois 2
- Kentucky 2
- Texas 2
- Arizona 1
- Connecticut 1
- Georgia 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- Minnesota 1
- New York 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444258 | 2444258 | 2022-04-26 | Montgomery | Alabama | 1101 | 55058 | 946 |
2441002 | 2441002 | 2022-04-25 | Montgomery | Alabama | 1101 | 55049 | 946 |
2437746 | 2437746 | 2022-04-24 | Montgomery | Alabama | 1101 | 54906 | 946 |
2434490 | 2434490 | 2022-04-23 | Montgomery | Alabama | 1101 | 54906 | 946 |
2431234 | 2431234 | 2022-04-22 | Montgomery | Alabama | 1101 | 54906 | 946 |
2427978 | 2427978 | 2022-04-21 | Montgomery | Alabama | 1101 | 54895 | 946 |
2424722 | 2424722 | 2022-04-20 | Montgomery | Alabama | 1101 | 54882 | 946 |
2359996 | 2359996 | 2022-03-31 | Clayton | Georgia | 13063 | 63869 | 946 |
2328845 | 2328845 | 2022-03-21 | Gloucester | New Jersey | 34015 | 69432 | 946 |
2325593 | 2325593 | 2022-03-20 | Gloucester | New Jersey | 34015 | 69427 | 946 |
2322339 | 2322339 | 2022-03-19 | Gloucester | New Jersey | 34015 | 69421 | 946 |
2319085 | 2319085 | 2022-03-18 | Gloucester | New Jersey | 34015 | 69390 | 946 |
2315832 | 2315832 | 2022-03-17 | Gloucester | New Jersey | 34015 | 69378 | 946 |
2312579 | 2312579 | 2022-03-16 | Gloucester | New Jersey | 34015 | 69348 | 946 |
2257029 | 2257029 | 2022-02-27 | Greene | Missouri | 29077 | 70451 | 946 |
2253778 | 2253778 | 2022-02-26 | Greene | Missouri | 29077 | 70451 | 946 |
2250527 | 2250527 | 2022-02-25 | Greene | Missouri | 29077 | 70451 | 946 |
2216814 | 2216814 | 2022-02-15 | Collier | Florida | 12021 | 81561 | 946 |
2213563 | 2213563 | 2022-02-14 | Collier | Florida | 12021 | 81561 | 946 |
2215876 | 2215876 | 2022-02-14 | Brazoria | Texas | 48039 | 91805 | 946 |
2210311 | 2210311 | 2022-02-13 | Collier | Florida | 12021 | 81561 | 946 |
2212625 | 2212625 | 2022-02-13 | Brazoria | Texas | 48039 | 91700 | 946 |
2207058 | 2207058 | 2022-02-12 | Collier | Florida | 12021 | 81561 | 946 |
2203805 | 2203805 | 2022-02-11 | Collier | Florida | 12021 | 81561 | 946 |
2200552 | 2200552 | 2022-02-10 | Collier | Florida | 12021 | 80296 | 946 |
2197298 | 2197298 | 2022-02-09 | Collier | Florida | 12021 | 80296 | 946 |
2182509 | 2182509 | 2022-02-04 | Somerset | New Jersey | 34035 | 65123 | 946 |
2143656 | 2143656 | 2022-01-23 | Wake | North Carolina | 37183 | 240220 | 946 |
2140401 | 2140401 | 2022-01-22 | Wake | North Carolina | 37183 | 240220 | 946 |
2137145 | 2137145 | 2022-01-21 | Wake | North Carolina | 37183 | 240220 | 946 |
2131205 | 2131205 | 2022-01-19 | Hamilton | Tennessee | 47065 | 82227 | 946 |
1962176 | 1962176 | 2021-11-28 | Knox | Tennessee | 47093 | 80429 | 946 |
1958925 | 1958925 | 2021-11-27 | Knox | Tennessee | 47093 | 80429 | 946 |
1955674 | 1955674 | 2021-11-26 | Knox | Tennessee | 47093 | 80429 | 946 |
1952423 | 1952423 | 2021-11-25 | Knox | Tennessee | 47093 | 80429 | 946 |
1949172 | 1949172 | 2021-11-24 | Knox | Tennessee | 47093 | 80429 | 946 |
1945921 | 1945921 | 2021-11-23 | Knox | Tennessee | 47093 | 80394 | 946 |
1942670 | 1942670 | 2021-11-22 | Knox | Tennessee | 47093 | 80290 | 946 |
1939420 | 1939420 | 2021-11-21 | Knox | Tennessee | 47093 | 80093 | 946 |
1936170 | 1936170 | 2021-11-20 | Knox | Tennessee | 47093 | 80093 | 946 |
1932920 | 1932920 | 2021-11-19 | Knox | Tennessee | 47093 | 80093 | 946 |
1901371 | 1901371 | 2021-11-10 | Jefferson | Colorado | 8059 | 67092 | 946 |
1893650 | 1893650 | 2021-11-07 | Lehigh | Pennsylvania | 42077 | 49157 | 946 |
1890400 | 1890400 | 2021-11-06 | Lehigh | Pennsylvania | 42077 | 49078 | 946 |
1887151 | 1887151 | 2021-11-05 | Luzerne | Pennsylvania | 42079 | 41718 | 946 |
1878609 | 1878609 | 2021-11-03 | Denver | Colorado | 8031 | 93464 | 946 |
1712965 | 1712965 | 2021-09-13 | New Castle | Delaware | 10003 | 72781 | 946 |
1709718 | 1709718 | 2021-09-12 | New Castle | Delaware | 10003 | 72576 | 946 |
1706471 | 1706471 | 2021-09-11 | New Castle | Delaware | 10003 | 72267 | 946 |
1703223 | 1703223 | 2021-09-10 | New Castle | Delaware | 10003 | 71938 | 946 |
1699973 | 1699973 | 2021-09-09 | New Castle | Delaware | 10003 | 71594 | 946 |
1426166 | 1426166 | 2021-06-16 | Davidson | Tennessee | 47037 | 99519 | 946 |
1422919 | 1422919 | 2021-06-15 | Davidson | Tennessee | 47037 | 99497 | 946 |
1376205 | 1376205 | 2021-06-01 | Genesee | Michigan | 26049 | 41593 | 946 |
1347526 | 1347526 | 2021-05-23 | Mercer | New Jersey | 34021 | 33841 | 946 |
1348270 | 1348270 | 2021-05-23 | Davidson | Tennessee | 47037 | 99058 | 946 |
1344278 | 1344278 | 2021-05-22 | Mercer | New Jersey | 34021 | 33820 | 946 |
1345022 | 1345022 | 2021-05-22 | Davidson | Tennessee | 47037 | 99058 | 946 |
1341774 | 1341774 | 2021-05-21 | Davidson | Tennessee | 47037 | 99058 | 946 |
1338526 | 1338526 | 2021-05-20 | Davidson | Tennessee | 47037 | 99033 | 946 |
1315390 | 1315390 | 2021-05-13 | Summit | Ohio | 39153 | 47425 | 946 |
1312144 | 1312144 | 2021-05-12 | Summit | Ohio | 39153 | 47375 | 946 |
1308897 | 1308897 | 2021-05-11 | Summit | Ohio | 39153 | 47292 | 946 |
1292492 | 1292492 | 2021-05-06 | Mecklenburg | North Carolina | 37119 | 110982 | 946 |
1242183 | 1242183 | 2021-04-21 | Lee | Florida | 12071 | 67152 | 946 |
1100003 | 1100003 | 2021-03-08 | Jefferson | Kentucky | 21111 | 75200 | 946 |
1096755 | 1096755 | 2021-03-07 | Jefferson | Kentucky | 21111 | 75148 | 946 |
1073214 | 1073214 | 2021-02-28 | Stanislaus | California | 6099 | 56132 | 946 |
1069968 | 1069968 | 2021-02-27 | Stanislaus | California | 6099 | 56024 | 946 |
1066723 | 1066723 | 2021-02-26 | Stanislaus | California | 6099 | 55887 | 946 |
1031485 | 1031485 | 2021-02-15 | Will | Illinois | 17197 | 63481 | 946 |
1019674 | 1019674 | 2021-02-11 | Monroe | New York | 36055 | 50081 | 946 |
995420 | 995420 | 2021-02-04 | Duval | Florida | 12031 | 83166 | 946 |
989241 | 989241 | 2021-02-02 | Lake | Illinois | 17097 | 56271 | 946 |
889188 | 889188 | 2021-01-02 | Baltimore | Maryland | 24005 | 39380 | 946 |
855638 | 855638 | 2020-12-23 | Pima | Arizona | 4019 | 62159 | 946 |
837300 | 837300 | 2020-12-17 | Plymouth | Massachusetts | 25023 | 19731 | 946 |
607050 | 607050 | 2020-10-07 | Hennepin | Minnesota | 27053 | 29207 | 946 |
285672 | 285672 | 2020-06-29 | Ocean | New Jersey | 34029 | 9643 | 946 |
274848 | 274848 | 2020-06-26 | Miami-Dade | Florida | 12086 | 30195 | 946 |
184891 | 184891 | 2020-05-28 | New Haven | Connecticut | 9009 | 11198 | 946 |
149878 | 149878 | 2020-05-16 | Union | New Jersey | 34039 | 14569 | 946 |
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);