ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where cases = 5759 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Texas 14
- Georgia 9
- North Carolina 6
- South Carolina 5
- Illinois 3
- Missouri 3
- New York 3
- Indiana 2
- Mississippi 2
- New Jersey 2
- Tennessee 2
- Wisconsin 2
- Alaska 1
- Arkansas 1
- California 1
- Delaware 1
- Florida 1
- Iowa 1
- Michigan 1
- Nebraska 1
- Ohio 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495754 | 2495754 | 2022-05-11 | Dimmit | Texas | 48127 | 5759 | 51 |
2492496 | 2492496 | 2022-05-10 | Dimmit | Texas | 48127 | 5759 | 51 |
2489238 | 2489238 | 2022-05-09 | Dimmit | Texas | 48127 | 5759 | 51 |
2485981 | 2485981 | 2022-05-08 | Dimmit | Texas | 48127 | 5759 | 51 |
2482723 | 2482723 | 2022-05-07 | Dimmit | Texas | 48127 | 5759 | 51 |
2393982 | 2393982 | 2022-04-10 | Essex | New York | 36031 | 5759 | 59 |
2342443 | 2342443 | 2022-03-25 | Moca | Puerto Rico | 72099 | 5759 | |
2302967 | 2302967 | 2022-03-13 | Greene | North Carolina | 37079 | 5759 | 56 |
2299715 | 2299715 | 2022-03-12 | Greene | North Carolina | 37079 | 5759 | 56 |
2296463 | 2296463 | 2022-03-11 | Greene | North Carolina | 37079 | 5759 | 56 |
2238411 | 2238411 | 2022-02-21 | Barnwell | South Carolina | 45011 | 5759 | 93 |
2235160 | 2235160 | 2022-02-20 | Barnwell | South Carolina | 45011 | 5759 | 93 |
2231909 | 2231909 | 2022-02-19 | Barnwell | South Carolina | 45011 | 5759 | 93 |
2228658 | 2228658 | 2022-02-18 | Barnwell | South Carolina | 45011 | 5759 | 93 |
2196899 | 2196899 | 2022-02-08 | Kewaunee | Wisconsin | 55061 | 5759 | 55 |
2164935 | 2164935 | 2022-01-30 | Peach | Georgia | 13225 | 5759 | 116 |
2161680 | 2161680 | 2022-01-29 | Peach | Georgia | 13225 | 5759 | 116 |
2158424 | 2158424 | 2022-01-28 | Peach | Georgia | 13225 | 5759 | 116 |
2142092 | 2142092 | 2022-01-23 | Decatur | Georgia | 13087 | 5759 | 113 |
2138837 | 2138837 | 2022-01-22 | Decatur | Georgia | 13087 | 5759 | 113 |
2135581 | 2135581 | 2022-01-21 | Decatur | Georgia | 13087 | 5759 | 113 |
2061913 | 2061913 | 2021-12-29 | Lafayette | Missouri | 29107 | 5759 | 91 |
2060222 | 2060222 | 2021-12-28 | Greenbrier | West Virginia | 54025 | 5759 | 118 |
2020024 | 2020024 | 2021-12-16 | Bladen | North Carolina | 37017 | 5759 | 95 |
2020572 | 2020572 | 2021-12-16 | Williamsburg | South Carolina | 45089 | 5759 | 129 |
1997679 | 1997679 | 2021-12-09 | Tioga | Pennsylvania | 42117 | 5759 | 158 |
1984234 | 1984234 | 2021-12-05 | Orleans | New York | 36073 | 5759 | 96 |
1921335 | 1921335 | 2021-11-16 | Jasper | Indiana | 18073 | 5759 | 93 |
1899263 | 1899263 | 2021-11-09 | Alcorn | Mississippi | 28003 | 5759 | 104 |
1899801 | 1899801 | 2021-11-09 | Jackson | North Carolina | 37099 | 5759 | 72 |
1883827 | 1883827 | 2021-11-04 | Benton | Oregon | 41003 | 5759 | 31 |
1881397 | 1881397 | 2021-11-03 | Tazewell | Virginia | 51185 | 5759 | 107 |
1876711 | 1876711 | 2021-11-02 | Webster | Missouri | 29225 | 5759 | 92 |
1861592 | 1861592 | 2021-10-28 | Howard | Texas | 48227 | 5759 | 133 |
1857734 | 1857734 | 2021-10-27 | Preble | Ohio | 39135 | 5759 | 125 |
1830314 | 1830314 | 2021-10-19 | Woodford | Illinois | 17203 | 5759 | 105 |
1828058 | 1828058 | 2021-10-18 | Dodge | Nebraska | 31053 | 5759 | 83 |
1697878 | 1697878 | 2021-09-08 | Pontotoc | Mississippi | 28115 | 5759 | 88 |
1631858 | 1631858 | 2021-08-19 | Colquitt | Georgia | 13071 | 5759 | 135 |
1627589 | 1627589 | 2021-08-17 | Burnet | Texas | 48053 | 5759 | 78 |
1495534 | 1495534 | 2021-07-08 | Polk | Georgia | 13233 | 5759 | 100 |
1472230 | 1472230 | 2021-06-30 | Grant | Wisconsin | 55043 | 5759 | 94 |
1463821 | 1463821 | 2021-06-28 | Branch | Michigan | 26023 | 5759 | 120 |
1455482 | 1455482 | 2021-06-25 | Caldwell | Texas | 48055 | 5759 | 100 |
1452237 | 1452237 | 2021-06-24 | Caldwell | Texas | 48055 | 5759 | 100 |
1448991 | 1448991 | 2021-06-23 | Caldwell | Texas | 48055 | 5759 | 100 |
1411253 | 1411253 | 2021-06-12 | Coles | Illinois | 17029 | 5759 | 102 |
1408008 | 1408008 | 2021-06-11 | Coles | Illinois | 17029 | 5759 | 102 |
1307648 | 1307648 | 2021-05-11 | Warren | Iowa | 19181 | 5759 | 88 |
1275851 | 1275851 | 2021-05-01 | Lincoln | Missouri | 29113 | 5759 | 41 |
1264106 | 1264106 | 2021-04-27 | Navarro | Texas | 48349 | 5759 | 154 |
1133349 | 1133349 | 2021-03-18 | Franklin | North Carolina | 37069 | 5759 | 46 |
1110575 | 1110575 | 2021-03-11 | St. Lawrence | New York | 36089 | 5759 | 92 |
1069953 | 1069953 | 2021-02-27 | San Benito | California | 6069 | 5759 | 59 |
1049611 | 1049611 | 2021-02-20 | Roane | Tennessee | 47145 | 5759 | 95 |
1005174 | 1005174 | 2021-02-07 | Jackson | Florida | 12063 | 5759 | 134 |
1002297 | 1002297 | 2021-02-06 | Dubois | Indiana | 18037 | 5759 | 101 |
991324 | 991324 | 2021-02-02 | Hood | Texas | 48221 | 5759 | 99 |
965947 | 965947 | 2021-01-26 | Fairbanks North Star Borough | Alaska | 2090 | 5759 | 25 |
927112 | 927112 | 2021-01-14 | White | Arkansas | 5145 | 5759 | 75 |
881103 | 881103 | 2020-12-30 | Victoria | Texas | 48469 | 5759 | 118 |
744529 | 744529 | 2020-11-18 | Montgomery | Tennessee | 47125 | 5759 | 77 |
709099 | 709099 | 2020-11-07 | Tom Green | Texas | 48451 | 5759 | 87 |
549171 | 549171 | 2020-09-19 | Somerset | New Jersey | 34035 | 5759 | 569 |
402478 | 402478 | 2020-08-05 | Hall | Georgia | 13139 | 5759 | 86 |
325386 | 325386 | 2020-07-12 | New Castle | Delaware | 10003 | 5759 | 249 |
94095 | 94095 | 2020-04-27 | Monmouth | New Jersey | 34025 | 5759 | 302 |
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);