ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where deaths = 902 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Arizona 17
- Texas 17
- Tennessee 12
- Iowa 7
- Rhode Island 7
- New Jersey 6
- Florida 5
- Michigan 5
- Ohio 5
- Oregon 5
- Arkansas 4
- Georgia 3
- Maryland 3
- Minnesota 3
- Pennsylvania 3
- Washington 3
- California 2
- Colorado 2
- Massachusetts 2
- South Carolina 2
- District of Columbia 1
- Hawaii 1
- Illinois 1
- Kentucky 1
- Louisiana 1
- New York 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502367 | 2502367 | 2022-05-13 | McLennan | Texas | 48309 | 60473 | 902 |
2499109 | 2499109 | 2022-05-12 | McLennan | Texas | 48309 | 60372 | 902 |
2495851 | 2495851 | 2022-05-11 | McLennan | Texas | 48309 | 60280 | 902 |
2492411 | 2492411 | 2022-05-10 | Rutherford | Tennessee | 47149 | 96100 | 902 |
2492593 | 2492593 | 2022-05-10 | McLennan | Texas | 48309 | 60250 | 902 |
2489153 | 2489153 | 2022-05-09 | Rutherford | Tennessee | 47149 | 96100 | 902 |
2489335 | 2489335 | 2022-05-09 | McLennan | Texas | 48309 | 60196 | 902 |
2485896 | 2485896 | 2022-05-08 | Rutherford | Tennessee | 47149 | 96100 | 902 |
2486078 | 2486078 | 2022-05-08 | McLennan | Texas | 48309 | 60189 | 902 |
2482638 | 2482638 | 2022-05-07 | Rutherford | Tennessee | 47149 | 96100 | 902 |
2482820 | 2482820 | 2022-05-07 | McLennan | Texas | 48309 | 60178 | 902 |
2479380 | 2479380 | 2022-05-06 | Rutherford | Tennessee | 47149 | 96100 | 902 |
2479562 | 2479562 | 2022-05-06 | McLennan | Texas | 48309 | 60104 | 902 |
2476122 | 2476122 | 2022-05-05 | Rutherford | Tennessee | 47149 | 96100 | 902 |
2476304 | 2476304 | 2022-05-05 | McLennan | Texas | 48309 | 60023 | 902 |
2472865 | 2472865 | 2022-05-04 | Rutherford | Tennessee | 47149 | 96100 | 902 |
2473047 | 2473047 | 2022-05-04 | McLennan | Texas | 48309 | 59908 | 902 |
2467104 | 2467104 | 2022-05-03 | Navajo | Arizona | 4017 | 38236 | 902 |
2469791 | 2469791 | 2022-05-03 | McLennan | Texas | 48309 | 59780 | 902 |
2463849 | 2463849 | 2022-05-02 | Navajo | Arizona | 4017 | 38236 | 902 |
2466535 | 2466535 | 2022-05-02 | McLennan | Texas | 48309 | 59742 | 902 |
2460593 | 2460593 | 2022-05-01 | Navajo | Arizona | 4017 | 38236 | 902 |
2463280 | 2463280 | 2022-05-01 | McLennan | Texas | 48309 | 59731 | 902 |
2457337 | 2457337 | 2022-04-30 | Navajo | Arizona | 4017 | 38236 | 902 |
2460024 | 2460024 | 2022-04-30 | McLennan | Texas | 48309 | 59715 | 902 |
2454081 | 2454081 | 2022-04-29 | Navajo | Arizona | 4017 | 38236 | 902 |
2456768 | 2456768 | 2022-04-29 | McLennan | Texas | 48309 | 59638 | 902 |
2450825 | 2450825 | 2022-04-28 | Navajo | Arizona | 4017 | 38236 | 902 |
2447569 | 2447569 | 2022-04-27 | Navajo | Arizona | 4017 | 38236 | 902 |
2444313 | 2444313 | 2022-04-26 | Navajo | Arizona | 4017 | 38200 | 902 |
2441057 | 2441057 | 2022-04-25 | Navajo | Arizona | 4017 | 38200 | 902 |
2437801 | 2437801 | 2022-04-24 | Navajo | Arizona | 4017 | 38200 | 902 |
2434545 | 2434545 | 2022-04-23 | Navajo | Arizona | 4017 | 38200 | 902 |
2431289 | 2431289 | 2022-04-22 | Navajo | Arizona | 4017 | 38200 | 902 |
2428033 | 2428033 | 2022-04-21 | Navajo | Arizona | 4017 | 38200 | 902 |
2424777 | 2424777 | 2022-04-20 | Navajo | Arizona | 4017 | 38200 | 902 |
2268920 | 2268920 | 2022-03-03 | Clayton | Georgia | 13063 | 63210 | 902 |
2195511 | 2195511 | 2022-02-08 | Gloucester | New Jersey | 34015 | 67968 | 902 |
2184504 | 2184504 | 2022-02-05 | Honolulu | Hawaii | 15003 | 157456 | 902 |
2126261 | 2126261 | 2022-01-18 | Polk | Iowa | 19153 | 99504 | 902 |
2123009 | 2123009 | 2022-01-17 | Polk | Iowa | 19153 | 99504 | 902 |
2119757 | 2119757 | 2022-01-16 | Polk | Iowa | 19153 | 99504 | 902 |
2116505 | 2116505 | 2022-01-15 | Polk | Iowa | 19153 | 99504 | 902 |
2113254 | 2113254 | 2022-01-14 | Polk | Iowa | 19153 | 99504 | 902 |
2110002 | 2110002 | 2022-01-13 | Polk | Iowa | 19153 | 99504 | 902 |
2106751 | 2106751 | 2022-01-12 | Polk | Iowa | 19153 | 99504 | 902 |
2094752 | 2094752 | 2022-01-08 | Onondaga | New York | 36067 | 82087 | 902 |
2079176 | 2079176 | 2022-01-03 | Hamilton | Tennessee | 47065 | 72027 | 902 |
2075618 | 2075618 | 2022-01-02 | Multnomah | Oregon | 41051 | 65814 | 902 |
2072367 | 2072367 | 2022-01-01 | Multnomah | Oregon | 41051 | 65814 | 902 |
2069116 | 2069116 | 2021-12-31 | Multnomah | Oregon | 41051 | 65814 | 902 |
2065865 | 2065865 | 2021-12-30 | Multnomah | Oregon | 41051 | 65814 | 902 |
2062615 | 2062615 | 2021-12-29 | Multnomah | Oregon | 41051 | 65174 | 902 |
2049172 | 2049172 | 2021-12-25 | Somerset | New Jersey | 34035 | 42274 | 902 |
2045922 | 2045922 | 2021-12-24 | Somerset | New Jersey | 34035 | 41559 | 902 |
2042672 | 2042672 | 2021-12-23 | Somerset | New Jersey | 34035 | 40858 | 902 |
2039423 | 2039423 | 2021-12-22 | Somerset | New Jersey | 34035 | 40094 | 902 |
2021469 | 2021469 | 2021-12-17 | Yavapai | Arizona | 4025 | 35117 | 902 |
1952290 | 1952290 | 2021-11-25 | Horry | South Carolina | 45051 | 63402 | 902 |
1948876 | 1948876 | 2021-11-24 | Chester | Pennsylvania | 42029 | 54518 | 902 |
1949039 | 1949039 | 2021-11-24 | Horry | South Carolina | 45051 | 63402 | 902 |
1945625 | 1945625 | 2021-11-23 | Chester | Pennsylvania | 42029 | 54377 | 902 |
1907432 | 1907432 | 2021-11-11 | Pierce | Washington | 53053 | 95364 | 902 |
1904183 | 1904183 | 2021-11-10 | Pierce | Washington | 53053 | 95364 | 902 |
1900933 | 1900933 | 2021-11-09 | Pierce | Washington | 53053 | 95089 | 902 |
1878593 | 1878593 | 2021-11-03 | Adams | Colorado | 8001 | 78698 | 902 |
1875344 | 1875344 | 2021-11-02 | Adams | Colorado | 8001 | 78698 | 902 |
1867681 | 1867681 | 2021-10-30 | Westmoreland | Pennsylvania | 42129 | 45178 | 902 |
1849277 | 1849277 | 2021-10-25 | Pulaski | Arkansas | 5119 | 58595 | 902 |
1846027 | 1846027 | 2021-10-24 | Pulaski | Arkansas | 5119 | 58567 | 902 |
1842777 | 1842777 | 2021-10-23 | Pulaski | Arkansas | 5119 | 58544 | 902 |
1839527 | 1839527 | 2021-10-22 | Pulaski | Arkansas | 5119 | 58503 | 902 |
1757675 | 1757675 | 2021-09-26 | Montgomery | Texas | 48339 | 83949 | 902 |
1742532 | 1742532 | 2021-09-22 | Kane | Illinois | 17089 | 65888 | 902 |
1710682 | 1710682 | 2021-09-12 | Kent | Michigan | 26081 | 80214 | 902 |
1707435 | 1707435 | 2021-09-11 | Kent | Michigan | 26081 | 80214 | 902 |
1704188 | 1704188 | 2021-09-10 | Kent | Michigan | 26081 | 80214 | 902 |
1699847 | 1699847 | 2021-09-09 | Contra Costa | California | 6013 | 93351 | 902 |
1675456 | 1675456 | 2021-09-01 | Burlington | New Jersey | 34005 | 48534 | 902 |
1467200 | 1467200 | 2021-06-29 | Ramsey | Minnesota | 27123 | 52559 | 902 |
1463955 | 1463955 | 2021-06-28 | Ramsey | Minnesota | 27123 | 52553 | 902 |
1460710 | 1460710 | 2021-06-27 | Ramsey | Minnesota | 27123 | 52546 | 902 |
1443204 | 1443204 | 2021-06-22 | Pinal | Arizona | 4021 | 53671 | 902 |
1421520 | 1421520 | 2021-06-15 | Jefferson | Louisiana | 22051 | 47257 | 902 |
1388027 | 1388027 | 2021-06-05 | Pinal | Arizona | 4021 | 53103 | 902 |
1359036 | 1359036 | 2021-05-27 | Brevard | Florida | 12009 | 42818 | 902 |
1260197 | 1260197 | 2021-04-26 | Stark | Ohio | 39151 | 31775 | 902 |
1256950 | 1256950 | 2021-04-25 | Stark | Ohio | 39151 | 31738 | 902 |
1253703 | 1253703 | 2021-04-24 | Stark | Ohio | 39151 | 31712 | 902 |
1250456 | 1250456 | 2021-04-23 | Stark | Ohio | 39151 | 31670 | 902 |
1189157 | 1189157 | 2021-04-04 | Davidson | Tennessee | 47037 | 94741 | 902 |
1185910 | 1185910 | 2021-04-03 | Davidson | Tennessee | 47037 | 94741 | 902 |
1182663 | 1182663 | 2021-04-02 | Davidson | Tennessee | 47037 | 94741 | 902 |
1179416 | 1179416 | 2021-04-01 | Davidson | Tennessee | 47037 | 94557 | 902 |
1135090 | 1135090 | 2021-03-19 | DeKalb | Georgia | 13089 | 60046 | 902 |
1131773 | 1131773 | 2021-03-18 | Marion | Florida | 12083 | 28513 | 902 |
1111533 | 1111533 | 2021-03-11 | Travis | Texas | 48453 | 77231 | 902 |
1106644 | 1106644 | 2021-03-10 | Baltimore city | Maryland | 24510 | 41214 | 902 |
1079670 | 1079670 | 2021-03-02 | Kern | California | 6029 | 103622 | 902 |
1063665 | 1063665 | 2021-02-25 | Cobb | Georgia | 13067 | 69152 | 902 |
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);