ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
181 rows where deaths = 732 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Pennsylvania 32
- North Carolina 19
- Ohio 15
- California 12
- Missouri 11
- Texas 11
- Alabama 7
- Virginia 7
- Colorado 6
- Indiana 6
- Louisiana 6
- Massachusetts 6
- Georgia 5
- Illinois 5
- Florida 4
- New Mexico 4
- South Carolina 4
- Hawaii 3
- Maryland 3
- Delaware 2
- Michigan 2
- Nebraska 2
- New Jersey 2
- Washington 2
- Arizona 1
- Arkansas 1
- Kentucky 1
- Minnesota 1
- Oregon 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501857 | 2501857 | 2022-05-13 | Cambria | Pennsylvania | 42021 | 34936 | 732 |
2498599 | 2498599 | 2022-05-12 | Cambria | Pennsylvania | 42021 | 34936 | 732 |
2495341 | 2495341 | 2022-05-11 | Cambria | Pennsylvania | 42021 | 34936 | 732 |
2492083 | 2492083 | 2022-05-10 | Cambria | Pennsylvania | 42021 | 34801 | 732 |
2488825 | 2488825 | 2022-05-09 | Cambria | Pennsylvania | 42021 | 34801 | 732 |
2485568 | 2485568 | 2022-05-08 | Cambria | Pennsylvania | 42021 | 34801 | 732 |
2482310 | 2482310 | 2022-05-07 | Cambria | Pennsylvania | 42021 | 34801 | 732 |
2479052 | 2479052 | 2022-05-06 | Cambria | Pennsylvania | 42021 | 34801 | 732 |
2475794 | 2475794 | 2022-05-05 | Cambria | Pennsylvania | 42021 | 34801 | 732 |
2472537 | 2472537 | 2022-05-04 | Cambria | Pennsylvania | 42021 | 34801 | 732 |
2469281 | 2469281 | 2022-05-03 | Cambria | Pennsylvania | 42021 | 34782 | 732 |
2466025 | 2466025 | 2022-05-02 | Cambria | Pennsylvania | 42021 | 34761 | 732 |
2462770 | 2462770 | 2022-05-01 | Cambria | Pennsylvania | 42021 | 34756 | 732 |
2459514 | 2459514 | 2022-04-30 | Cambria | Pennsylvania | 42021 | 34750 | 732 |
2456258 | 2456258 | 2022-04-29 | Cambria | Pennsylvania | 42021 | 34725 | 732 |
2451444 | 2451444 | 2022-04-28 | Elkhart | Indiana | 18039 | 54178 | 732 |
2448188 | 2448188 | 2022-04-27 | Elkhart | Indiana | 18039 | 54178 | 732 |
2403991 | 2403991 | 2022-04-13 | Lake | Ohio | 39085 | 48894 | 732 |
2404161 | 2404161 | 2022-04-13 | Butler | Pennsylvania | 42019 | 44498 | 732 |
2400736 | 2400736 | 2022-04-12 | Lake | Ohio | 39085 | 48894 | 732 |
2400906 | 2400906 | 2022-04-12 | Butler | Pennsylvania | 42019 | 44473 | 732 |
2397481 | 2397481 | 2022-04-11 | Lake | Ohio | 39085 | 48894 | 732 |
2394226 | 2394226 | 2022-04-10 | Lake | Ohio | 39085 | 48894 | 732 |
2390970 | 2390970 | 2022-04-09 | Lake | Ohio | 39085 | 48894 | 732 |
2387714 | 2387714 | 2022-04-08 | Lake | Ohio | 39085 | 48894 | 732 |
2388360 | 2388360 | 2022-04-08 | Johnson | Texas | 48251 | 43222 | 732 |
2384459 | 2384459 | 2022-04-07 | Lake | Ohio | 39085 | 48894 | 732 |
2385105 | 2385105 | 2022-04-07 | Johnson | Texas | 48251 | 43204 | 732 |
2381204 | 2381204 | 2022-04-06 | Lake | Ohio | 39085 | 48829 | 732 |
2381850 | 2381850 | 2022-04-06 | Johnson | Texas | 48251 | 43179 | 732 |
2377949 | 2377949 | 2022-04-05 | Lake | Ohio | 39085 | 48829 | 732 |
2378595 | 2378595 | 2022-04-05 | Johnson | Texas | 48251 | 43149 | 732 |
2374695 | 2374695 | 2022-04-04 | Lake | Ohio | 39085 | 48829 | 732 |
2374859 | 2374859 | 2022-04-04 | Beaver | Pennsylvania | 42007 | 40095 | 732 |
2375341 | 2375341 | 2022-04-04 | Johnson | Texas | 48251 | 43098 | 732 |
2369548 | 2369548 | 2022-04-03 | Monterey | California | 6053 | 92730 | 732 |
2371443 | 2371443 | 2022-04-03 | Lake | Ohio | 39085 | 48829 | 732 |
2371607 | 2371607 | 2022-04-03 | Beaver | Pennsylvania | 42007 | 40090 | 732 |
2372089 | 2372089 | 2022-04-03 | Johnson | Texas | 48251 | 43096 | 732 |
2366295 | 2366295 | 2022-04-02 | Monterey | California | 6053 | 92730 | 732 |
2368190 | 2368190 | 2022-04-02 | Lake | Ohio | 39085 | 48829 | 732 |
2368354 | 2368354 | 2022-04-02 | Beaver | Pennsylvania | 42007 | 40090 | 732 |
2368836 | 2368836 | 2022-04-02 | Johnson | Texas | 48251 | 43091 | 732 |
2363042 | 2363042 | 2022-04-01 | Monterey | California | 6053 | 92730 | 732 |
2364937 | 2364937 | 2022-04-01 | Lake | Ohio | 39085 | 48829 | 732 |
2365101 | 2365101 | 2022-04-01 | Beaver | Pennsylvania | 42007 | 40081 | 732 |
2359788 | 2359788 | 2022-03-31 | Monterey | California | 6053 | 92677 | 732 |
2361684 | 2361684 | 2022-03-31 | Lake | Ohio | 39085 | 48829 | 732 |
2361848 | 2361848 | 2022-03-31 | Beaver | Pennsylvania | 42007 | 40078 | 732 |
2358594 | 2358594 | 2022-03-30 | Beaver | Pennsylvania | 42007 | 40072 | 732 |
2354892 | 2354892 | 2022-03-29 | Doña Ana | New Mexico | 35013 | 63094 | 732 |
2355340 | 2355340 | 2022-03-29 | Beaver | Pennsylvania | 42007 | 40066 | 732 |
2351639 | 2351639 | 2022-03-28 | Doña Ana | New Mexico | 35013 | 63091 | 732 |
2317669 | 2317669 | 2022-03-18 | Unknown | Florida | 8007 | 732 | |
2309364 | 2309364 | 2022-03-15 | San Juan | New Mexico | 35045 | 40461 | 732 |
2306111 | 2306111 | 2022-03-14 | San Juan | New Mexico | 35045 | 40455 | 732 |
2287716 | 2287716 | 2022-03-08 | Chesterfield | Virginia | 51041 | 71079 | 732 |
2284464 | 2284464 | 2022-03-07 | Chesterfield | Virginia | 51041 | 70998 | 732 |
2277306 | 2277306 | 2022-03-05 | Lackawanna | Pennsylvania | 42069 | 42943 | 732 |
2274053 | 2274053 | 2022-03-04 | Lackawanna | Pennsylvania | 42069 | 42926 | 732 |
2268560 | 2268560 | 2022-03-03 | Tuscaloosa | Alabama | 1125 | 54844 | 732 |
2239639 | 2239639 | 2022-02-22 | Bibb | Georgia | 13021 | 36624 | 732 |
2231086 | 2231086 | 2022-02-19 | St. Louis city | Missouri | 29510 | 55296 | 732 |
2227835 | 2227835 | 2022-02-18 | St. Louis city | Missouri | 29510 | 55296 | 732 |
2224584 | 2224584 | 2022-02-17 | St. Louis city | Missouri | 29510 | 55182 | 732 |
2215169 | 2215169 | 2022-02-14 | Forsyth | North Carolina | 37067 | 89911 | 732 |
2215171 | 2215171 | 2022-02-14 | Gaston | North Carolina | 37071 | 63583 | 732 |
2184065 | 2184065 | 2022-02-05 | Benton | Arkansas | 5007 | 63829 | 732 |
2174491 | 2174491 | 2022-02-02 | Pueblo | Colorado | 8101 | 42073 | 732 |
2165122 | 2165122 | 2022-01-30 | St. Clair | Illinois | 17163 | 65480 | 732 |
2161867 | 2161867 | 2022-01-29 | St. Clair | Illinois | 17163 | 65480 | 732 |
2158612 | 2158612 | 2022-01-28 | St. Clair | Illinois | 17163 | 65480 | 732 |
2132105 | 2132105 | 2022-01-20 | Merced | California | 6047 | 57327 | 732 |
2128962 | 2128962 | 2022-01-19 | Sussex | Delaware | 10005 | 54531 | 732 |
2041278 | 2041278 | 2021-12-23 | Chatham | Georgia | 13051 | 39853 | 732 |
2038028 | 2038028 | 2021-12-22 | Chatham | Georgia | 13051 | 39794 | 732 |
2034778 | 2034778 | 2021-12-21 | Chatham | Georgia | 13051 | 39734 | 732 |
2032710 | 2032710 | 2021-12-20 | St. Charles | Missouri | 29183 | 69059 | 732 |
2029459 | 2029459 | 2021-12-19 | St. Charles | Missouri | 29183 | 68551 | 732 |
2026208 | 2026208 | 2021-12-18 | St. Charles | Missouri | 29183 | 68551 | 732 |
2022957 | 2022957 | 2021-12-17 | St. Charles | Missouri | 29183 | 68551 | 732 |
2019706 | 2019706 | 2021-12-16 | St. Charles | Missouri | 29183 | 68263 | 732 |
2016456 | 2016456 | 2021-12-15 | St. Charles | Missouri | 29183 | 68052 | 732 |
2017607 | 2017607 | 2021-12-15 | Jefferson | Texas | 48245 | 32321 | 732 |
2013205 | 2013205 | 2021-12-14 | St. Charles | Missouri | 29183 | 67817 | 732 |
1966147 | 1966147 | 2021-11-30 | Madison | Alabama | 1089 | 53315 | 732 |
1962895 | 1962895 | 2021-11-29 | Madison | Alabama | 1089 | 53307 | 732 |
1959644 | 1959644 | 2021-11-28 | Madison | Alabama | 1089 | 53291 | 732 |
1956393 | 1956393 | 2021-11-27 | Madison | Alabama | 1089 | 53279 | 732 |
1953142 | 1953142 | 2021-11-26 | Madison | Alabama | 1089 | 53255 | 732 |
1949891 | 1949891 | 2021-11-25 | Madison | Alabama | 1089 | 53255 | 732 |
1945772 | 1945772 | 2021-11-23 | Charleston | South Carolina | 45019 | 66361 | 732 |
1946332 | 1946332 | 2021-11-23 | Henrico | Virginia | 51087 | 35464 | 732 |
1942521 | 1942521 | 2021-11-22 | Charleston | South Carolina | 45019 | 66340 | 732 |
1943081 | 1943081 | 2021-11-22 | Henrico | Virginia | 51087 | 35414 | 732 |
1928266 | 1928266 | 2021-11-18 | St. Tammany | Louisiana | 22103 | 44049 | 732 |
1921147 | 1921147 | 2021-11-16 | Honolulu | Hawaii | 15003 | 58684 | 732 |
1917897 | 1917897 | 2021-11-15 | Honolulu | Hawaii | 15003 | 58651 | 732 |
1914647 | 1914647 | 2021-11-14 | Honolulu | Hawaii | 15003 | 58618 | 732 |
1880602 | 1880602 | 2021-11-03 | Multnomah | Oregon | 41051 | 57399 | 732 |
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);