ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where deaths = 1029 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Ohio 10
- Hawaii 7
- Tennessee 5
- Texas 5
- Louisiana 4
- New Jersey 4
- New York 4
- California 3
- Delaware 3
- Florida 3
- Maryland 3
- Minnesota 3
- Colorado 2
- Massachusetts 2
- Georgia 1
- Illinois 1
- Indiana 1
- Michigan 1
- Pennsylvania 1
- South Carolina 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2421969 | 2421969 | 2022-04-19 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2418713 | 2418713 | 2022-04-18 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2415457 | 2415457 | 2022-04-17 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2412201 | 2412201 | 2022-04-16 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2408945 | 2408945 | 2022-04-15 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2405689 | 2405689 | 2022-04-14 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2402434 | 2402434 | 2022-04-13 | Honolulu | Hawaii | 15003 | 168444 | 1029 |
2362444 | 2362444 | 2022-03-31 | Webb | Texas | 48479 | 92973 | 1029 |
2267126 | 2267126 | 2022-03-02 | Onondaga | New York | 36067 | 107268 | 1029 |
2263874 | 2263874 | 2022-03-01 | Onondaga | New York | 36067 | 107100 | 1029 |
2260623 | 2260623 | 2022-02-28 | Onondaga | New York | 36067 | 107001 | 1029 |
2237192 | 2237192 | 2022-02-21 | Anne Arundel | Maryland | 24003 | 87823 | 1029 |
2233941 | 2233941 | 2022-02-20 | Anne Arundel | Maryland | 24003 | 87823 | 1029 |
2230690 | 2230690 | 2022-02-19 | Anne Arundel | Maryland | 24003 | 87757 | 1029 |
2215302 | 2215302 | 2022-02-14 | Butler | Ohio | 39017 | 89299 | 1029 |
2212051 | 2212051 | 2022-02-13 | Butler | Ohio | 39017 | 89245 | 1029 |
2208798 | 2208798 | 2022-02-12 | Butler | Ohio | 39017 | 89175 | 1029 |
2205545 | 2205545 | 2022-02-11 | Butler | Ohio | 39017 | 89108 | 1029 |
2165564 | 2165564 | 2022-01-30 | Caddo | Louisiana | 22017 | 63932 | 1029 |
2162309 | 2162309 | 2022-01-29 | Caddo | Louisiana | 22017 | 63932 | 1029 |
2159054 | 2159054 | 2022-01-28 | Caddo | Louisiana | 22017 | 63932 | 1029 |
2133052 | 2133052 | 2022-01-20 | Orleans | Louisiana | 22071 | 76214 | 1029 |
2091416 | 2091416 | 2022-01-07 | Burlington | New Jersey | 34005 | 80490 | 1029 |
2043166 | 2043166 | 2021-12-23 | Lehigh | Pennsylvania | 42077 | 59662 | 1029 |
2008602 | 2008602 | 2021-12-13 | Adams | Colorado | 8001 | 89314 | 1029 |
1985863 | 1985863 | 2021-12-06 | Denver | Colorado | 8031 | 103523 | 1029 |
1954901 | 1954901 | 2021-11-26 | Mercer | New Jersey | 34021 | 41359 | 1029 |
1951650 | 1951650 | 2021-11-25 | Mercer | New Jersey | 34021 | 41270 | 1029 |
1948399 | 1948399 | 2021-11-24 | Mercer | New Jersey | 34021 | 41106 | 1029 |
1938233 | 1938233 | 2021-11-21 | Ramsey | Minnesota | 27123 | 70528 | 1029 |
1934983 | 1934983 | 2021-11-20 | Ramsey | Minnesota | 27123 | 70528 | 1029 |
1931733 | 1931733 | 2021-11-19 | Ramsey | Minnesota | 27123 | 70528 | 1029 |
1910371 | 1910371 | 2021-11-12 | Lubbock | Texas | 48303 | 66514 | 1029 |
1894915 | 1894915 | 2021-11-08 | New Castle | Delaware | 10003 | 83071 | 1029 |
1891665 | 1891665 | 2021-11-07 | New Castle | Delaware | 10003 | 82929 | 1029 |
1888415 | 1888415 | 2021-11-06 | New Castle | Delaware | 10003 | 82779 | 1029 |
1711945 | 1711945 | 2021-09-12 | Davidson | Tennessee | 47037 | 119511 | 1029 |
1708698 | 1708698 | 2021-09-11 | Davidson | Tennessee | 47037 | 119511 | 1029 |
1705451 | 1705451 | 2021-09-10 | Davidson | Tennessee | 47037 | 119511 | 1029 |
1702201 | 1702201 | 2021-09-09 | Davidson | Tennessee | 47037 | 118920 | 1029 |
1669304 | 1669304 | 2021-08-30 | Summit | Ohio | 39153 | 51930 | 1029 |
1666057 | 1666057 | 2021-08-29 | Summit | Ohio | 39153 | 51791 | 1029 |
1662809 | 1662809 | 2021-08-28 | Summit | Ohio | 39153 | 51666 | 1029 |
1659561 | 1659561 | 2021-08-27 | Summit | Ohio | 39153 | 51483 | 1029 |
1427109 | 1427109 | 2021-06-17 | Ventura | California | 6111 | 81609 | 1029 |
1423864 | 1423864 | 2021-06-16 | Ventura | California | 6111 | 81609 | 1029 |
1416320 | 1416320 | 2021-06-13 | Greenville | South Carolina | 45045 | 75401 | 1029 |
1403750 | 1403750 | 2021-06-09 | Travis | Texas | 48453 | 84047 | 1029 |
1400505 | 1400505 | 2021-06-08 | Travis | Texas | 48453 | 83962 | 1029 |
1383545 | 1383545 | 2021-06-03 | Montgomery | Ohio | 39113 | 52297 | 1029 |
1380299 | 1380299 | 2021-06-02 | Montgomery | Ohio | 39113 | 52281 | 1029 |
1336730 | 1336730 | 2021-05-20 | Lake | Indiana | 18089 | 54531 | 1029 |
1248743 | 1248743 | 2021-04-23 | Cobb | Georgia | 13067 | 77293 | 1029 |
1200255 | 1200255 | 2021-04-08 | Lake | Illinois | 17097 | 63288 | 1029 |
1121386 | 1121386 | 2021-03-14 | Fairfax | Virginia | 51059 | 68641 | 1029 |
1031155 | 1031155 | 2021-02-15 | Orange | Florida | 12095 | 109649 | 1029 |
1011688 | 1011688 | 2021-02-09 | Polk | Florida | 12105 | 53005 | 1029 |
933364 | 933364 | 2021-01-15 | Milwaukee | Wisconsin | 55079 | 98795 | 1029 |
927157 | 927157 | 2021-01-14 | Santa Clara | California | 6085 | 88379 | 1029 |
916551 | 916551 | 2021-01-10 | Shelby | Tennessee | 47157 | 73817 | 1029 |
868886 | 868886 | 2020-12-27 | Pinellas | Florida | 12103 | 43210 | 1029 |
841165 | 841165 | 2020-12-18 | Erie | New York | 36029 | 35507 | 1029 |
601863 | 601863 | 2020-10-05 | Cameron | Texas | 48061 | 23029 | 1029 |
584298 | 584298 | 2020-09-30 | Macomb | Michigan | 26099 | 15063 | 1029 |
522714 | 522714 | 2020-09-11 | Norfolk | Massachusetts | 25021 | 9780 | 1029 |
519477 | 519477 | 2020-09-10 | Norfolk | Massachusetts | 25021 | 9745 | 1029 |
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);