ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
202 rows where cases = 3006 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 45
- Georgia 16
- Texas 14
- Tennessee 11
- Indiana 9
- Oklahoma 9
- Kentucky 8
- Maine 7
- West Virginia 7
- Arkansas 6
- Minnesota 6
- North Carolina 6
- Mississippi 5
- Colorado 4
- Ohio 4
- Puerto Rico 4
- Idaho 3
- Illinois 3
- Iowa 3
- Louisiana 3
- Maryland 3
- Virginia 3
- Wisconsin 3
- Kansas 2
- Michigan 2
- Nebraska 2
- New York 2
- Oregon 2
- Pennsylvania 2
- Alabama 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471835 | 2471835 | 2022-05-04 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2468579 | 2468579 | 2022-05-03 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2465323 | 2465323 | 2022-05-02 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2462068 | 2462068 | 2022-05-01 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2458812 | 2458812 | 2022-04-30 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2455556 | 2455556 | 2022-04-29 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2452300 | 2452300 | 2022-04-28 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2449044 | 2449044 | 2022-04-27 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2445787 | 2445787 | 2022-04-26 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2442151 | 2442151 | 2022-04-25 | Piscataquis | Maine | 23021 | 3006 | 31 |
2442532 | 2442532 | 2022-04-25 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2438895 | 2438895 | 2022-04-24 | Piscataquis | Maine | 23021 | 3006 | 31 |
2439276 | 2439276 | 2022-04-24 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2435639 | 2435639 | 2022-04-23 | Piscataquis | Maine | 23021 | 3006 | 31 |
2436020 | 2436020 | 2022-04-23 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2432764 | 2432764 | 2022-04-22 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2429508 | 2429508 | 2022-04-21 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2426252 | 2426252 | 2022-04-20 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2422996 | 2422996 | 2022-04-19 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2419739 | 2419739 | 2022-04-18 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2416484 | 2416484 | 2022-04-17 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2413228 | 2413228 | 2022-04-16 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2409972 | 2409972 | 2022-04-15 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2406716 | 2406716 | 2022-04-14 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2403460 | 2403460 | 2022-04-13 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2400205 | 2400205 | 2022-04-12 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2396950 | 2396950 | 2022-04-11 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2393695 | 2393695 | 2022-04-10 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2390439 | 2390439 | 2022-04-09 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2387183 | 2387183 | 2022-04-08 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2383928 | 2383928 | 2022-04-07 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2380673 | 2380673 | 2022-04-06 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2377418 | 2377418 | 2022-04-05 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2374165 | 2374165 | 2022-04-04 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2370913 | 2370913 | 2022-04-03 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2367660 | 2367660 | 2022-04-02 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2364407 | 2364407 | 2022-04-01 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2361153 | 2361153 | 2022-03-31 | Pemiscot | Missouri | 29155 | 3006 | 74 |
2316031 | 2316031 | 2022-03-17 | Washington | North Carolina | 37187 | 3006 | 50 |
2312778 | 2312778 | 2022-03-16 | Washington | North Carolina | 37187 | 3006 | 50 |
2227452 | 2227452 | 2022-02-18 | Kent | Maryland | 24029 | 3006 | 64 |
2219625 | 2219625 | 2022-02-15 | Roane | West Virginia | 54087 | 3006 | 34 |
2214701 | 2214701 | 2022-02-14 | Perry | Mississippi | 28111 | 3006 | 63 |
2146115 | 2146115 | 2022-01-24 | Washington | Maine | 23029 | 3006 | 44 |
2142721 | 2142721 | 2022-01-23 | Larue | Kentucky | 21123 | 3006 | 60 |
2142860 | 2142860 | 2022-01-23 | Washington | Maine | 23029 | 3006 | 44 |
2139466 | 2139466 | 2022-01-22 | Larue | Kentucky | 21123 | 3006 | 60 |
2139605 | 2139605 | 2022-01-22 | Washington | Maine | 23029 | 3006 | 44 |
2136210 | 2136210 | 2022-01-21 | Larue | Kentucky | 21123 | 3006 | 60 |
2128824 | 2128824 | 2022-01-19 | Van Buren | Arkansas | 5141 | 3006 | 46 |
2104553 | 2104553 | 2022-01-11 | Chowan | North Carolina | 37041 | 3006 | 45 |
2076101 | 2076101 | 2022-01-02 | Houston | Texas | 48225 | 3006 | 90 |
2072850 | 2072850 | 2022-01-01 | Houston | Texas | 48225 | 3006 | 90 |
2069599 | 2069599 | 2021-12-31 | Houston | Texas | 48225 | 3006 | 90 |
2066348 | 2066348 | 2021-12-30 | Houston | Texas | 48225 | 3006 | 90 |
2027447 | 2027447 | 2021-12-18 | Shelby | Texas | 48419 | 3006 | 113 |
2012632 | 2012632 | 2021-12-14 | Casey | Kentucky | 21045 | 3006 | 63 |
2000186 | 2000186 | 2021-12-10 | Pike | Missouri | 29163 | 3006 | 51 |
2001374 | 2001374 | 2021-12-10 | Lee | Texas | 48287 | 3006 | 54 |
1990696 | 1990696 | 2021-12-07 | Taos | New Mexico | 35055 | 3006 | 71 |
1956488 | 1956488 | 2021-11-27 | Hempstead | Arkansas | 5057 | 3006 | 41 |
1953237 | 1953237 | 2021-11-26 | Hempstead | Arkansas | 5057 | 3006 | 41 |
1943900 | 1943900 | 2021-11-23 | Kauai | Hawaii | 15007 | 3006 | 13 |
1937334 | 1937334 | 2021-11-21 | Meriwether | Georgia | 13199 | 3006 | 118 |
1938343 | 1938343 | 2021-11-21 | Andrew | Missouri | 29003 | 3006 | 38 |
1934084 | 1934084 | 2021-11-20 | Meriwether | Georgia | 13199 | 3006 | 118 |
1930832 | 1930832 | 2021-11-19 | Meriwether | Georgia | 13199 | 3006 | 118 |
1909966 | 1909966 | 2021-11-12 | Juncos | Puerto Rico | 72077 | 3006 | |
1903862 | 1903862 | 2021-11-10 | Lamb | Texas | 48279 | 3006 | 89 |
1900612 | 1900612 | 2021-11-09 | Lamb | Texas | 48279 | 3006 | 89 |
1891651 | 1891651 | 2021-11-07 | Teller | Colorado | 8119 | 3006 | 36 |
1888401 | 1888401 | 2021-11-06 | Teller | Colorado | 8119 | 3006 | 36 |
1885151 | 1885151 | 2021-11-05 | Teller | Colorado | 8119 | 3006 | 36 |
1886434 | 1886434 | 2021-11-05 | Ray | Missouri | 29177 | 3006 | 50 |
1861089 | 1861089 | 2021-10-28 | Crook | Oregon | 41013 | 3006 | 46 |
1852920 | 1852920 | 2021-10-26 | Blaine | Idaho | 16013 | 3006 | 26 |
1855475 | 1855475 | 2021-10-26 | Lewis | West Virginia | 54041 | 3006 | 52 |
1852321 | 1852321 | 2021-10-25 | Taylor | Wisconsin | 55119 | 3006 | 46 |
1838179 | 1838179 | 2021-10-21 | Carroll | Ohio | 39019 | 3006 | 59 |
1830857 | 1830857 | 2021-10-19 | Alpena | Michigan | 26007 | 3006 | 69 |
1827608 | 1827608 | 2021-10-18 | Alpena | Michigan | 26007 | 3006 | 69 |
1767198 | 1767198 | 2021-09-29 | Humphreys | Tennessee | 47085 | 3006 | 44 |
1763992 | 1763992 | 2021-09-28 | Unicoi | Tennessee | 47171 | 3006 | 58 |
1745188 | 1745188 | 2021-09-23 | Pickens | Alabama | 1107 | 3006 | 73 |
1725763 | 1725763 | 2021-09-17 | Conway | Arkansas | 5029 | 3006 | 41 |
1722537 | 1722537 | 2021-09-16 | Lawrence | Arkansas | 5075 | 3006 | 49 |
1718214 | 1718214 | 2021-09-14 | Susquehanna | Pennsylvania | 42115 | 3006 | 62 |
1693556 | 1693556 | 2021-09-07 | Ben Hill | Georgia | 13017 | 3006 | 87 |
1695697 | 1695697 | 2021-09-07 | Chester | Tennessee | 47023 | 3006 | 57 |
1677701 | 1677701 | 2021-09-02 | Washington | Indiana | 18175 | 3006 | 43 |
1672806 | 1672806 | 2021-08-31 | Rio Grande | Puerto Rico | 72119 | 3006 | |
1649835 | 1649835 | 2021-08-24 | Beckham | Oklahoma | 40009 | 3006 | 58 |
1646586 | 1646586 | 2021-08-23 | Beckham | Oklahoma | 40009 | 3006 | 58 |
1643337 | 1643337 | 2021-08-22 | Beckham | Oklahoma | 40009 | 3006 | 58 |
1640087 | 1640087 | 2021-08-21 | Beckham | Oklahoma | 40009 | 3006 | 58 |
1636837 | 1636837 | 2021-08-20 | Beckham | Oklahoma | 40009 | 3006 | 58 |
1633587 | 1633587 | 2021-08-19 | Beckham | Oklahoma | 40009 | 3006 | 58 |
1630340 | 1630340 | 2021-08-18 | Beckham | Oklahoma | 40009 | 3006 | 58 |
1631296 | 1631296 | 2021-08-18 | Greenbrier | West Virginia | 54025 | 3006 | 66 |
1621502 | 1621502 | 2021-08-15 | Wythe | Virginia | 51197 | 3006 | 82 |
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);