ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
196 rows where deaths = 651 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Pennsylvania 29
- Florida 22
- Missouri 13
- Tennessee 11
- Alabama 9
- California 9
- Illinois 9
- Indiana 9
- New Jersey 9
- New York 9
- Iowa 7
- Louisiana 6
- Texas 6
- Georgia 5
- Maryland 5
- Ohio 5
- Utah 4
- Washington 4
- North Carolina 3
- South Carolina 3
- Virginia 3
- Arkansas 2
- Colorado 2
- Connecticut 2
- Massachusetts 2
- Nevada 2
- New Hampshire 2
- Arizona 1
- Mississippi 1
- Oklahoma 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499602 | 2499602 | 2022-05-13 | Etowah | Alabama | 1055 | 28779 | 651 |
2496344 | 2496344 | 2022-05-12 | Etowah | Alabama | 1055 | 28780 | 651 |
2497867 | 2497867 | 2022-05-12 | Jefferson | Missouri | 29099 | 54230 | 651 |
2493086 | 2493086 | 2022-05-11 | Etowah | Alabama | 1055 | 28777 | 651 |
2494609 | 2494609 | 2022-05-11 | Jefferson | Missouri | 29099 | 54230 | 651 |
2489828 | 2489828 | 2022-05-10 | Etowah | Alabama | 1055 | 28778 | 651 |
2491351 | 2491351 | 2022-05-10 | Jefferson | Missouri | 29099 | 54230 | 651 |
2486571 | 2486571 | 2022-05-09 | Etowah | Alabama | 1055 | 28778 | 651 |
2488093 | 2488093 | 2022-05-09 | Jefferson | Missouri | 29099 | 54230 | 651 |
2483313 | 2483313 | 2022-05-08 | Etowah | Alabama | 1055 | 28774 | 651 |
2484836 | 2484836 | 2022-05-08 | Jefferson | Missouri | 29099 | 54230 | 651 |
2480055 | 2480055 | 2022-05-07 | Etowah | Alabama | 1055 | 28774 | 651 |
2481578 | 2481578 | 2022-05-07 | Jefferson | Missouri | 29099 | 54230 | 651 |
2476797 | 2476797 | 2022-05-06 | Etowah | Alabama | 1055 | 28774 | 651 |
2478320 | 2478320 | 2022-05-06 | Jefferson | Missouri | 29099 | 54230 | 651 |
2475062 | 2475062 | 2022-05-05 | Jefferson | Missouri | 29099 | 54067 | 651 |
2444960 | 2444960 | 2022-04-26 | Madison | Indiana | 18095 | 32734 | 651 |
2441704 | 2441704 | 2022-04-25 | Madison | Indiana | 18095 | 32734 | 651 |
2438448 | 2438448 | 2022-04-24 | Madison | Indiana | 18095 | 32713 | 651 |
2435192 | 2435192 | 2022-04-23 | Madison | Indiana | 18095 | 32713 | 651 |
2431936 | 2431936 | 2022-04-22 | Madison | Indiana | 18095 | 32713 | 651 |
2433518 | 2433518 | 2022-04-22 | Washington | Pennsylvania | 42125 | 51039 | 651 |
2430262 | 2430262 | 2022-04-21 | Washington | Pennsylvania | 42125 | 51023 | 651 |
2427006 | 2427006 | 2022-04-20 | Washington | Pennsylvania | 42125 | 50997 | 651 |
2423750 | 2423750 | 2022-04-19 | Washington | Pennsylvania | 42125 | 50972 | 651 |
2420494 | 2420494 | 2022-04-18 | Washington | Pennsylvania | 42125 | 50955 | 651 |
2417238 | 2417238 | 2022-04-17 | Washington | Pennsylvania | 42125 | 50946 | 651 |
2413982 | 2413982 | 2022-04-16 | Washington | Pennsylvania | 42125 | 50942 | 651 |
2410726 | 2410726 | 2022-04-15 | Washington | Pennsylvania | 42125 | 50914 | 651 |
2407470 | 2407470 | 2022-04-14 | Washington | Pennsylvania | 42125 | 50903 | 651 |
2404214 | 2404214 | 2022-04-13 | Washington | Pennsylvania | 42125 | 50886 | 651 |
2400959 | 2400959 | 2022-04-12 | Washington | Pennsylvania | 42125 | 50872 | 651 |
2397704 | 2397704 | 2022-04-11 | Washington | Pennsylvania | 42125 | 50846 | 651 |
2394449 | 2394449 | 2022-04-10 | Washington | Pennsylvania | 42125 | 50834 | 651 |
2391193 | 2391193 | 2022-04-09 | Washington | Pennsylvania | 42125 | 50828 | 651 |
2387937 | 2387937 | 2022-04-08 | Washington | Pennsylvania | 42125 | 50821 | 651 |
2384682 | 2384682 | 2022-04-07 | Washington | Pennsylvania | 42125 | 50806 | 651 |
2381427 | 2381427 | 2022-04-06 | Washington | Pennsylvania | 42125 | 50796 | 651 |
2378172 | 2378172 | 2022-04-05 | Washington | Pennsylvania | 42125 | 50784 | 651 |
2356635 | 2356635 | 2022-03-30 | New London | Connecticut | 9011 | 54543 | 651 |
2353382 | 2353382 | 2022-03-29 | New London | Connecticut | 9011 | 54505 | 651 |
2353391 | 2353391 | 2022-03-29 | Alachua | Florida | 12001 | 67908 | 651 |
2350139 | 2350139 | 2022-03-28 | Alachua | Florida | 12001 | 67908 | 651 |
2346886 | 2346886 | 2022-03-27 | Alachua | Florida | 12001 | 67908 | 651 |
2343633 | 2343633 | 2022-03-26 | Alachua | Florida | 12001 | 67908 | 651 |
2340380 | 2340380 | 2022-03-25 | Alachua | Florida | 12001 | 67908 | 651 |
2337127 | 2337127 | 2022-03-24 | Alachua | Florida | 12001 | 67575 | 651 |
2307873 | 2307873 | 2022-03-15 | Highlands | Florida | 12055 | 23936 | 651 |
2309386 | 2309386 | 2022-03-15 | Dutchess | New York | 36027 | 63465 | 651 |
2304622 | 2304622 | 2022-03-14 | Highlands | Florida | 12055 | 23936 | 651 |
2305006 | 2305006 | 2022-03-14 | Hamilton | Indiana | 18057 | 81563 | 651 |
2306133 | 2306133 | 2022-03-14 | Dutchess | New York | 36027 | 63439 | 651 |
2301370 | 2301370 | 2022-03-13 | Highlands | Florida | 12055 | 23936 | 651 |
2302882 | 2302882 | 2022-03-13 | Dutchess | New York | 36027 | 63428 | 651 |
2298118 | 2298118 | 2022-03-12 | Highlands | Florida | 12055 | 23936 | 651 |
2299630 | 2299630 | 2022-03-12 | Dutchess | New York | 36027 | 63417 | 651 |
2294866 | 2294866 | 2022-03-11 | Highlands | Florida | 12055 | 23936 | 651 |
2296378 | 2296378 | 2022-03-11 | Dutchess | New York | 36027 | 63391 | 651 |
2291614 | 2291614 | 2022-03-10 | Highlands | Florida | 12055 | 23888 | 651 |
2288362 | 2288362 | 2022-03-09 | Highlands | Florida | 12055 | 23888 | 651 |
2287631 | 2287631 | 2022-03-08 | Wichita | Texas | 48485 | 33955 | 651 |
2281975 | 2281975 | 2022-03-07 | Henry | Georgia | 13151 | 57413 | 651 |
2264712 | 2264712 | 2022-03-01 | Gregg | Texas | 48183 | 23004 | 651 |
2245968 | 2245968 | 2022-02-24 | Santa Barbara | California | 6083 | 89491 | 651 |
2246126 | 2246126 | 2022-02-24 | Unknown | Florida | 22488 | 651 | |
2217710 | 2217710 | 2022-02-15 | Barnstable | Massachusetts | 25001 | 33918 | 651 |
2219175 | 2219175 | 2022-02-15 | Ector | Texas | 48135 | 36697 | 651 |
2199780 | 2199780 | 2022-02-09 | Potter | Texas | 48375 | 34743 | 651 |
2196526 | 2196526 | 2022-02-08 | Potter | Texas | 48375 | 34658 | 651 |
2165592 | 2165592 | 2022-01-30 | Ouachita | Louisiana | 22073 | 47267 | 651 |
2162337 | 2162337 | 2022-01-29 | Ouachita | Louisiana | 22073 | 47267 | 651 |
2159082 | 2159082 | 2022-01-28 | Ouachita | Louisiana | 22073 | 47267 | 651 |
2137425 | 2137425 | 2022-01-21 | Cambria | Pennsylvania | 42021 | 30753 | 651 |
2111420 | 2111420 | 2022-01-13 | Erie | Pennsylvania | 42049 | 48534 | 651 |
2099589 | 2099589 | 2022-01-10 | Monterey | California | 6053 | 59137 | 651 |
2065551 | 2065551 | 2021-12-30 | Gaston | North Carolina | 37071 | 45128 | 651 |
2062301 | 2062301 | 2021-12-29 | Gaston | North Carolina | 37071 | 44781 | 651 |
2059052 | 2059052 | 2021-12-28 | Gaston | North Carolina | 37071 | 44591 | 651 |
2053517 | 2053517 | 2021-12-26 | Utah | Utah | 49049 | 142317 | 651 |
2050267 | 2050267 | 2021-12-25 | Utah | Utah | 49049 | 142317 | 651 |
2047017 | 2047017 | 2021-12-24 | Utah | Utah | 49049 | 142317 | 651 |
2040925 | 2040925 | 2021-12-23 | Tuscaloosa | Alabama | 1125 | 36686 | 651 |
2043767 | 2043767 | 2021-12-23 | Utah | Utah | 49049 | 142317 | 651 |
2040712 | 2040712 | 2021-12-22 | Yakima | Washington | 53077 | 47667 | 651 |
2035803 | 2035803 | 2021-12-21 | Hinds | Mississippi | 28049 | 33488 | 651 |
2037462 | 2037462 | 2021-12-21 | Yakima | Washington | 53077 | 47639 | 651 |
2018812 | 2018812 | 2021-12-16 | Winnebago | Illinois | 17201 | 50938 | 651 |
2005220 | 2005220 | 2021-12-12 | Benton | Arkansas | 5007 | 44743 | 651 |
1980980 | 1980980 | 2021-12-04 | Oneida | New York | 36065 | 33993 | 651 |
1968389 | 1968389 | 2021-11-30 | Cumberland | Pennsylvania | 42041 | 31605 | 651 |
1937246 | 1937246 | 2021-11-21 | Bibb | Georgia | 13021 | 26011 | 651 |
1933996 | 1933996 | 2021-11-20 | Bibb | Georgia | 13021 | 26011 | 651 |
1930744 | 1930744 | 2021-11-19 | Bibb | Georgia | 13021 | 26011 | 651 |
1924621 | 1924621 | 2021-11-17 | St. Joseph | Indiana | 18141 | 47058 | 651 |
1921090 | 1921090 | 2021-11-16 | Muscogee | Georgia | 13215 | 24428 | 651 |
1921372 | 1921372 | 2021-11-16 | St. Joseph | Indiana | 18141 | 46899 | 651 |
1892034 | 1892034 | 2021-11-07 | St. Clair | Illinois | 17163 | 40798 | 651 |
1888784 | 1888784 | 2021-11-06 | St. Clair | Illinois | 17163 | 40798 | 651 |
1885534 | 1885534 | 2021-11-05 | St. Clair | Illinois | 17163 | 40798 | 651 |
1874136 | 1874136 | 2021-11-01 | Dauphin | Pennsylvania | 42043 | 34955 | 651 |
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);