ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
285 rows where deaths = 663 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Florida 126
- Mississippi 22
- Georgia 15
- Illinois 13
- Ohio 10
- Washington 9
- Arkansas 8
- Michigan 8
- Pennsylvania 8
- New York 7
- Texas 7
- Louisiana 6
- Massachusetts 6
- New Jersey 5
- Arizona 4
- California 4
- New Hampshire 4
- Tennessee 4
- Indiana 3
- New Mexico 3
- South Carolina 3
- Maryland 2
- Missouri 2
- Idaho 1
- Minnesota 1
- Nevada 1
- Utah 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499933 | 2499933 | 2022-05-13 | Leon | Florida | 12073 | 85724 | 663 |
2496675 | 2496675 | 2022-05-12 | Leon | Florida | 12073 | 85724 | 663 |
2493417 | 2493417 | 2022-05-11 | Leon | Florida | 12073 | 85724 | 663 |
2467322 | 2467322 | 2022-05-03 | Alachua | Florida | 12001 | 68467 | 663 |
2464067 | 2464067 | 2022-05-02 | Alachua | Florida | 12001 | 68467 | 663 |
2460811 | 2460811 | 2022-05-01 | Alachua | Florida | 12001 | 68467 | 663 |
2457555 | 2457555 | 2022-04-30 | Alachua | Florida | 12001 | 68467 | 663 |
2454299 | 2454299 | 2022-04-29 | Alachua | Florida | 12001 | 68467 | 663 |
2451043 | 2451043 | 2022-04-28 | Alachua | Florida | 12001 | 68467 | 663 |
2447787 | 2447787 | 2022-04-27 | Alachua | Florida | 12001 | 68467 | 663 |
2444531 | 2444531 | 2022-04-26 | Alachua | Florida | 12001 | 68467 | 663 |
2441275 | 2441275 | 2022-04-25 | Alachua | Florida | 12001 | 68467 | 663 |
2442393 | 2442393 | 2022-04-25 | Harrison | Mississippi | 28047 | 53649 | 663 |
2438019 | 2438019 | 2022-04-24 | Alachua | Florida | 12001 | 68467 | 663 |
2439137 | 2439137 | 2022-04-24 | Harrison | Mississippi | 28047 | 53649 | 663 |
2434763 | 2434763 | 2022-04-23 | Alachua | Florida | 12001 | 68467 | 663 |
2435881 | 2435881 | 2022-04-23 | Harrison | Mississippi | 28047 | 53649 | 663 |
2431507 | 2431507 | 2022-04-22 | Alachua | Florida | 12001 | 68467 | 663 |
2432625 | 2432625 | 2022-04-22 | Harrison | Mississippi | 28047 | 53649 | 663 |
2428251 | 2428251 | 2022-04-21 | Alachua | Florida | 12001 | 68136 | 663 |
2429369 | 2429369 | 2022-04-21 | Harrison | Mississippi | 28047 | 53649 | 663 |
2424995 | 2424995 | 2022-04-20 | Alachua | Florida | 12001 | 68136 | 663 |
2426113 | 2426113 | 2022-04-20 | Harrison | Mississippi | 28047 | 53649 | 663 |
2422857 | 2422857 | 2022-04-19 | Harrison | Mississippi | 28047 | 53649 | 663 |
2419601 | 2419601 | 2022-04-18 | Harrison | Mississippi | 28047 | 53649 | 663 |
2416345 | 2416345 | 2022-04-17 | Harrison | Mississippi | 28047 | 53623 | 663 |
2413089 | 2413089 | 2022-04-16 | Harrison | Mississippi | 28047 | 53623 | 663 |
2409833 | 2409833 | 2022-04-15 | Harrison | Mississippi | 28047 | 53623 | 663 |
2406577 | 2406577 | 2022-04-14 | Harrison | Mississippi | 28047 | 53623 | 663 |
2403321 | 2403321 | 2022-04-13 | Harrison | Mississippi | 28047 | 53623 | 663 |
2400067 | 2400067 | 2022-04-12 | Harrison | Mississippi | 28047 | 53623 | 663 |
2396811 | 2396811 | 2022-04-11 | Harrison | Mississippi | 28047 | 53577 | 663 |
2393556 | 2393556 | 2022-04-10 | Harrison | Mississippi | 28047 | 53577 | 663 |
2390300 | 2390300 | 2022-04-09 | Harrison | Mississippi | 28047 | 53577 | 663 |
2387044 | 2387044 | 2022-04-08 | Harrison | Mississippi | 28047 | 53577 | 663 |
2383789 | 2383789 | 2022-04-07 | Harrison | Mississippi | 28047 | 53577 | 663 |
2380534 | 2380534 | 2022-04-06 | Harrison | Mississippi | 28047 | 53577 | 663 |
2377279 | 2377279 | 2022-04-05 | Harrison | Mississippi | 28047 | 53577 | 663 |
2374027 | 2374027 | 2022-04-04 | Harrison | Mississippi | 28047 | 53577 | 663 |
2339098 | 2339098 | 2022-03-24 | Fayette | Pennsylvania | 42051 | 30945 | 663 |
2320155 | 2320155 | 2022-03-18 | Wichita | Texas | 48485 | 33973 | 663 |
2310244 | 2310244 | 2022-03-15 | Gregg | Texas | 48183 | 23082 | 663 |
2245609 | 2245609 | 2022-02-23 | Kanawha | West Virginia | 54039 | 46305 | 663 |
2202972 | 2202972 | 2022-02-10 | Johnson | Texas | 48251 | 40989 | 663 |
2188335 | 2188335 | 2022-02-06 | Calcasieu | Louisiana | 22019 | 53008 | 663 |
2185082 | 2185082 | 2022-02-05 | Calcasieu | Louisiana | 22019 | 53008 | 663 |
2181830 | 2181830 | 2022-02-04 | Calcasieu | Louisiana | 22019 | 53008 | 663 |
2178579 | 2178579 | 2022-02-03 | Calcasieu | Louisiana | 22019 | 51013 | 663 |
2166256 | 2166256 | 2022-01-30 | Doña Ana | New Mexico | 35013 | 56964 | 663 |
2163001 | 2163001 | 2022-01-29 | Doña Ana | New Mexico | 35013 | 56964 | 663 |
2159746 | 2159746 | 2022-01-28 | Doña Ana | New Mexico | 35013 | 56964 | 663 |
2155946 | 2155946 | 2022-01-27 | Ingham | Michigan | 26065 | 58715 | 663 |
2156947 | 2156947 | 2022-01-27 | Cambria | Pennsylvania | 42021 | 32047 | 663 |
2152693 | 2152693 | 2022-01-26 | Ingham | Michigan | 26065 | 58715 | 663 |
2153687 | 2153687 | 2022-01-26 | Beaver | Pennsylvania | 42007 | 36741 | 663 |
2153693 | 2153693 | 2022-01-26 | Butler | Pennsylvania | 42019 | 41416 | 663 |
2086023 | 2086023 | 2022-01-05 | Utah | Utah | 49049 | 148936 | 663 |
2074683 | 2074683 | 2022-01-02 | St. Clair | Michigan | 26147 | 31456 | 663 |
2071432 | 2071432 | 2022-01-01 | St. Clair | Michigan | 26147 | 31062 | 663 |
2068181 | 2068181 | 2021-12-31 | St. Clair | Michigan | 26147 | 31062 | 663 |
2064930 | 2064930 | 2021-12-30 | St. Clair | Michigan | 26147 | 30888 | 663 |
2061680 | 2061680 | 2021-12-29 | St. Clair | Michigan | 26147 | 30663 | 663 |
2031514 | 2031514 | 2021-12-20 | Bibb | Georgia | 13021 | 26372 | 663 |
2027976 | 2027976 | 2021-12-19 | Benton | Arkansas | 5007 | 45190 | 663 |
2028263 | 2028263 | 2021-12-19 | Bibb | Georgia | 13021 | 26310 | 663 |
2025012 | 2025012 | 2021-12-18 | Bibb | Georgia | 13021 | 26310 | 663 |
2021761 | 2021761 | 2021-12-17 | Bibb | Georgia | 13021 | 26310 | 663 |
2018510 | 2018510 | 2021-12-16 | Bibb | Georgia | 13021 | 26294 | 663 |
2015260 | 2015260 | 2021-12-15 | Bibb | Georgia | 13021 | 26289 | 663 |
1997233 | 1997233 | 2021-12-09 | Oneida | New York | 36065 | 34814 | 663 |
1989540 | 1989540 | 2021-12-07 | St. Clair | Illinois | 17163 | 43374 | 663 |
1986290 | 1986290 | 2021-12-06 | St. Clair | Illinois | 17163 | 43374 | 663 |
1983040 | 1983040 | 2021-12-05 | St. Clair | Illinois | 17163 | 42995 | 663 |
1979790 | 1979790 | 2021-12-04 | St. Clair | Illinois | 17163 | 42995 | 663 |
1976540 | 1976540 | 2021-12-03 | St. Clair | Illinois | 17163 | 42995 | 663 |
1978138 | 1978138 | 2021-12-03 | Cumberland | Pennsylvania | 42041 | 32023 | 663 |
1973291 | 1973291 | 2021-12-02 | St. Clair | Illinois | 17163 | 42836 | 663 |
1970041 | 1970041 | 2021-12-01 | St. Clair | Illinois | 17163 | 42651 | 663 |
1940200 | 1940200 | 2021-11-22 | Navajo | Arizona | 4017 | 23939 | 663 |
1936950 | 1936950 | 2021-11-21 | Navajo | Arizona | 4017 | 23865 | 663 |
1937304 | 1937304 | 2021-11-21 | Hall | Georgia | 13139 | 38984 | 663 |
1933700 | 1933700 | 2021-11-20 | Navajo | Arizona | 4017 | 23770 | 663 |
1934054 | 1934054 | 2021-11-20 | Hall | Georgia | 13139 | 38984 | 663 |
1930802 | 1930802 | 2021-11-19 | Hall | Georgia | 13139 | 38984 | 663 |
1927552 | 1927552 | 2021-11-18 | Hall | Georgia | 13139 | 38937 | 663 |
1919906 | 1919906 | 2021-11-15 | Hamilton | Tennessee | 47065 | 64741 | 663 |
1881821 | 1881821 | 2021-11-04 | San Francisco | California | 6075 | 55203 | 663 |
1878572 | 1878572 | 2021-11-03 | San Francisco | California | 6075 | 55104 | 663 |
1830025 | 1830025 | 2021-10-19 | Chatham | Georgia | 13051 | 38420 | 663 |
1826776 | 1826776 | 2021-10-18 | Chatham | Georgia | 13051 | 38401 | 663 |
1823770 | 1823770 | 2021-10-17 | Madison | Illinois | 17119 | 39883 | 663 |
1820521 | 1820521 | 2021-10-16 | Madison | Illinois | 17119 | 39883 | 663 |
1817272 | 1817272 | 2021-10-15 | Madison | Illinois | 17119 | 39883 | 663 |
1814024 | 1814024 | 2021-10-14 | Madison | Illinois | 17119 | 39811 | 663 |
1808413 | 1808413 | 2021-10-12 | Jackson | Missouri | 29095 | 54832 | 663 |
1805729 | 1805729 | 2021-10-11 | Mahoning | Ohio | 39099 | 29532 | 663 |
1802479 | 1802479 | 2021-10-10 | Mahoning | Ohio | 39099 | 29465 | 663 |
1799230 | 1799230 | 2021-10-09 | Mahoning | Ohio | 39099 | 29316 | 663 |
1795981 | 1795981 | 2021-10-08 | Mahoning | Ohio | 39099 | 29247 | 663 |
1796508 | 1796508 | 2021-10-08 | Bell | Texas | 48027 | 37569 | 663 |
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);