ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
539 rows where cases = 755 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- South Dakota 60
- Texas 46
- Georgia 24
- Kansas 24
- Arkansas 23
- Iowa 23
- Minnesota 23
- North Dakota 22
- Missouri 21
- Virginia 19
- Indiana 17
- Montana 16
- Tennessee 15
- Mississippi 14
- North Carolina 14
- Puerto Rico 13
- Michigan 12
- Kentucky 11
- Colorado 10
- Ohio 10
- Illinois 9
- Oregon 9
- Nebraska 8
- Alabama 7
- Louisiana 7
- Oklahoma 7
- Utah 7
- Idaho 6
- Pennsylvania 6
- South Carolina 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474507 | 2474507 | 2022-05-05 | Trego | Kansas | 20195 | 755 | 10 |
2471250 | 2471250 | 2022-05-04 | Trego | Kansas | 20195 | 755 | 10 |
2467994 | 2467994 | 2022-05-03 | Trego | Kansas | 20195 | 755 | 10 |
2464739 | 2464739 | 2022-05-02 | Trego | Kansas | 20195 | 755 | 10 |
2461483 | 2461483 | 2022-05-01 | Trego | Kansas | 20195 | 755 | 10 |
2458227 | 2458227 | 2022-04-30 | Trego | Kansas | 20195 | 755 | 10 |
2454971 | 2454971 | 2022-04-29 | Trego | Kansas | 20195 | 755 | 10 |
2325626 | 2325626 | 2022-03-20 | Mora | New Mexico | 35033 | 755 | 17 |
2309545 | 2309545 | 2022-03-15 | Eddy | North Dakota | 38027 | 755 | 6 |
2306292 | 2306292 | 2022-03-14 | Eddy | North Dakota | 38027 | 755 | 6 |
2303041 | 2303041 | 2022-03-13 | Eddy | North Dakota | 38027 | 755 | 6 |
2299789 | 2299789 | 2022-03-12 | Eddy | North Dakota | 38027 | 755 | 6 |
2296537 | 2296537 | 2022-03-11 | Eddy | North Dakota | 38027 | 755 | 6 |
2292631 | 2292631 | 2022-03-10 | Lake of the Woods | Minnesota | 27077 | 755 | 6 |
2293285 | 2293285 | 2022-03-10 | Eddy | North Dakota | 38027 | 755 | 6 |
2289379 | 2289379 | 2022-03-09 | Lake of the Woods | Minnesota | 27077 | 755 | 6 |
2290033 | 2290033 | 2022-03-09 | Eddy | North Dakota | 38027 | 755 | 6 |
2270536 | 2270536 | 2022-03-03 | Nelson | North Dakota | 38063 | 755 | 18 |
2267284 | 2267284 | 2022-03-02 | Nelson | North Dakota | 38063 | 755 | 18 |
2264014 | 2264014 | 2022-03-01 | Eddy | North Dakota | 38027 | 755 | 6 |
2264032 | 2264032 | 2022-03-01 | Nelson | North Dakota | 38063 | 755 | 18 |
2260781 | 2260781 | 2022-02-28 | Nelson | North Dakota | 38063 | 755 | 18 |
2257530 | 2257530 | 2022-02-27 | Nelson | North Dakota | 38063 | 755 | 18 |
2254279 | 2254279 | 2022-02-26 | Nelson | North Dakota | 38063 | 755 | 18 |
2251028 | 2251028 | 2022-02-25 | Nelson | North Dakota | 38063 | 755 | 18 |
2241275 | 2241275 | 2022-02-22 | Nelson | North Dakota | 38063 | 755 | 18 |
2224646 | 2224646 | 2022-02-17 | Sweet Grass | Montana | 30097 | 755 | 8 |
2221395 | 2221395 | 2022-02-16 | Sweet Grass | Montana | 30097 | 755 | 8 |
2218144 | 2218144 | 2022-02-15 | Sweet Grass | Montana | 30097 | 755 | 8 |
2214893 | 2214893 | 2022-02-14 | Sweet Grass | Montana | 30097 | 755 | 8 |
2215695 | 2215695 | 2022-02-14 | Aurora | South Dakota | 46003 | 755 | 17 |
2212444 | 2212444 | 2022-02-13 | Aurora | South Dakota | 46003 | 755 | 17 |
2209191 | 2209191 | 2022-02-12 | Aurora | South Dakota | 46003 | 755 | 17 |
2205938 | 2205938 | 2022-02-11 | Aurora | South Dakota | 46003 | 755 | 17 |
2202685 | 2202685 | 2022-02-10 | Aurora | South Dakota | 46003 | 755 | 17 |
2190706 | 2190706 | 2022-02-07 | Baca | Colorado | 8009 | 755 | 8 |
2183482 | 2183482 | 2022-02-04 | Mason | Texas | 48319 | 755 | 10 |
2179462 | 2179462 | 2022-02-03 | Cavalier | North Dakota | 38019 | 755 | 7 |
2171928 | 2171928 | 2022-02-01 | Sheridan | Kansas | 20179 | 755 | 18 |
2168675 | 2168675 | 2022-01-31 | Sheridan | Kansas | 20179 | 755 | 18 |
2151104 | 2151104 | 2022-01-25 | Bath | Virginia | 51017 | 755 | 15 |
2130418 | 2130418 | 2022-01-19 | Mineral | Nevada | 32021 | 755 | 14 |
2101150 | 2101150 | 2022-01-10 | Lincoln | Nevada | 32017 | 755 | 5 |
2097062 | 2097062 | 2022-01-09 | Haskell | Kansas | 20081 | 755 | 9 |
2097676 | 2097676 | 2022-01-09 | Knox | Missouri | 29103 | 755 | 8 |
2093810 | 2093810 | 2022-01-08 | Haskell | Kansas | 20081 | 755 | 9 |
2094424 | 2094424 | 2022-01-08 | Knox | Missouri | 29103 | 755 | 8 |
2090558 | 2090558 | 2022-01-07 | Haskell | Kansas | 20081 | 755 | 9 |
2089401 | 2089401 | 2022-01-06 | Rappahannock | Virginia | 51157 | 755 | 7 |
2076357 | 2076357 | 2022-01-02 | King and Queen | Virginia | 51097 | 755 | 9 |
2073106 | 2073106 | 2022-01-01 | King and Queen | Virginia | 51097 | 755 | 9 |
2069855 | 2069855 | 2021-12-31 | King and Queen | Virginia | 51097 | 755 | 9 |
2065950 | 2065950 | 2021-12-30 | Arroyo | Puerto Rico | 72015 | 755 | |
2035948 | 2035948 | 2021-12-21 | Putnam | Missouri | 29171 | 755 | 19 |
2026670 | 2026670 | 2021-12-18 | Wells | North Dakota | 38103 | 755 | 11 |
2023419 | 2023419 | 2021-12-17 | Wells | North Dakota | 38103 | 755 | 11 |
2023683 | 2023683 | 2021-12-17 | Sullivan | Pennsylvania | 42113 | 755 | 27 |
2013655 | 2013655 | 2021-12-14 | Sargent | North Dakota | 38081 | 755 | 9 |
2011068 | 2011068 | 2021-12-13 | Garza | Texas | 48169 | 755 | 24 |
2006751 | 2006751 | 2021-12-12 | Mineral | Montana | 30061 | 755 | 15 |
2007817 | 2007817 | 2021-12-12 | Garza | Texas | 48169 | 755 | 24 |
2003500 | 2003500 | 2021-12-11 | Mineral | Montana | 30061 | 755 | 15 |
2004566 | 2004566 | 2021-12-11 | Garza | Texas | 48169 | 755 | 23 |
2000250 | 2000250 | 2021-12-10 | Mineral | Montana | 30061 | 755 | 15 |
2001315 | 2001315 | 2021-12-10 | Garza | Texas | 48169 | 755 | 23 |
1996999 | 1996999 | 2021-12-09 | Mineral | Montana | 30061 | 755 | 14 |
1993748 | 1993748 | 2021-12-08 | Mineral | Montana | 30061 | 755 | 14 |
1989158 | 1989158 | 2021-12-07 | Washington | Colorado | 8121 | 755 | 24 |
1988551 | 1988551 | 2021-12-06 | Charles City | Virginia | 51036 | 755 | 21 |
1973559 | 1973559 | 2021-12-02 | Meade | Kansas | 20119 | 755 | 14 |
1975084 | 1975084 | 2021-12-02 | Deuel | South Dakota | 46039 | 755 | 11 |
1970309 | 1970309 | 2021-12-01 | Meade | Kansas | 20119 | 755 | 14 |
1945048 | 1945048 | 2021-11-23 | Furnas | Nebraska | 31065 | 755 | 5 |
1939333 | 1939333 | 2021-11-21 | Gregory | South Dakota | 46053 | 755 | 30 |
1936083 | 1936083 | 2021-11-20 | Gregory | South Dakota | 46053 | 755 | 30 |
1932833 | 1932833 | 2021-11-19 | Gregory | South Dakota | 46053 | 755 | 30 |
1924116 | 1924116 | 2021-11-17 | Huerfano | Colorado | 8055 | 755 | 21 |
1922266 | 1922266 | 2021-11-16 | Antelope | Nebraska | 31003 | 755 | 10 |
1886864 | 1886864 | 2021-11-05 | Dunn | North Dakota | 38025 | 755 | 7 |
1846848 | 1846848 | 2021-10-24 | Stevens | Kansas | 20189 | 755 | 12 |
1843598 | 1843598 | 2021-10-23 | Stevens | Kansas | 20189 | 755 | 12 |
1840348 | 1840348 | 2021-10-22 | Stevens | Kansas | 20189 | 755 | 12 |
1824072 | 1824072 | 2021-10-17 | Morris | Kansas | 20127 | 755 | 23 |
1820823 | 1820823 | 2021-10-16 | Morris | Kansas | 20127 | 755 | 23 |
1817574 | 1817574 | 2021-10-15 | Morris | Kansas | 20127 | 755 | 23 |
1814326 | 1814326 | 2021-10-14 | Morris | Kansas | 20127 | 755 | 23 |
1811077 | 1811077 | 2021-10-13 | Morris | Kansas | 20127 | 755 | 23 |
1811470 | 1811470 | 2021-10-13 | Grant | Minnesota | 27051 | 755 | 9 |
1812629 | 1812629 | 2021-10-13 | Moody | South Dakota | 46101 | 755 | 20 |
1808549 | 1808549 | 2021-10-12 | Burt | Nebraska | 31021 | 755 | 12 |
1788990 | 1788990 | 2021-10-06 | Broadwater | Montana | 30007 | 755 | 12 |
1765997 | 1765997 | 2021-09-29 | Mahnomen | Minnesota | 27087 | 755 | 9 |
1761360 | 1761360 | 2021-09-27 | Crook | Wyoming | 56011 | 755 | 16 |
1755513 | 1755513 | 2021-09-26 | Gallatin | Illinois | 17059 | 755 | 8 |
1752265 | 1752265 | 2021-09-25 | Gallatin | Illinois | 17059 | 755 | 8 |
1754026 | 1754026 | 2021-09-25 | Sabana Grande | Puerto Rico | 72121 | 755 | |
1749016 | 1749016 | 2021-09-24 | Gallatin | Illinois | 17059 | 755 | 8 |
1750778 | 1750778 | 2021-09-24 | Sabana Grande | Puerto Rico | 72121 | 755 | |
1747529 | 1747529 | 2021-09-23 | Sabana Grande | Puerto Rico | 72121 | 755 | |
1741030 | 1741030 | 2021-09-21 | Sabana Grande | Puerto Rico | 72121 | 755 |
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);