ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
206 rows where cases = 2296 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 18
- Kentucky 16
- Georgia 11
- Kansas 11
- Missouri 11
- Puerto Rico 10
- Tennessee 10
- Illinois 9
- Indiana 8
- Alabama 7
- Arkansas 7
- Oklahoma 7
- Michigan 6
- Mississippi 6
- Ohio 6
- Virginia 6
- Washington 6
- Wisconsin 6
- Louisiana 4
- Minnesota 4
- Nebraska 4
- Colorado 3
- Idaho 3
- Iowa 3
- Maine 3
- Pennsylvania 3
- North Carolina 2
- North Dakota 2
- West Virginia 2
- Wyoming 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495725 | 2495725 | 2022-05-11 | Castro | Texas | 48069 | 2296 | 47 |
2492467 | 2492467 | 2022-05-10 | Castro | Texas | 48069 | 2296 | 47 |
2489209 | 2489209 | 2022-05-09 | Castro | Texas | 48069 | 2296 | 47 |
2485952 | 2485952 | 2022-05-08 | Castro | Texas | 48069 | 2296 | 47 |
2480201 | 2480201 | 2022-05-07 | Scott | Arkansas | 5127 | 2296 | 43 |
2482694 | 2482694 | 2022-05-07 | Castro | Texas | 48069 | 2296 | 47 |
2479436 | 2479436 | 2022-05-06 | Castro | Texas | 48069 | 2296 | 47 |
2476178 | 2476178 | 2022-05-05 | Castro | Texas | 48069 | 2296 | 47 |
2469548 | 2469548 | 2022-05-03 | Clay | Tennessee | 47027 | 2296 | 50 |
2466292 | 2466292 | 2022-05-02 | Clay | Tennessee | 47027 | 2296 | 50 |
2463037 | 2463037 | 2022-05-01 | Clay | Tennessee | 47027 | 2296 | 50 |
2459781 | 2459781 | 2022-04-30 | Clay | Tennessee | 47027 | 2296 | 50 |
2456525 | 2456525 | 2022-04-29 | Clay | Tennessee | 47027 | 2296 | 50 |
2453269 | 2453269 | 2022-04-28 | Clay | Tennessee | 47027 | 2296 | 50 |
2450013 | 2450013 | 2022-04-27 | Clay | Tennessee | 47027 | 2296 | 50 |
2401456 | 2401456 | 2022-04-12 | Runnels | Texas | 48399 | 2296 | 66 |
2310331 | 2310331 | 2022-03-15 | Ochiltree | Texas | 48357 | 2296 | 48 |
2263066 | 2263066 | 2022-03-01 | Livingston | Kentucky | 21139 | 2296 | 58 |
2261509 | 2261509 | 2022-02-28 | La Salle | Texas | 48283 | 2296 | 45 |
2222981 | 2222981 | 2022-02-16 | Washakie | Wyoming | 56043 | 2296 | 42 |
2214624 | 2214624 | 2022-02-14 | Rock | Minnesota | 27133 | 2296 | 32 |
2192068 | 2192068 | 2022-02-07 | Wayne | Missouri | 29223 | 2296 | 43 |
2179966 | 2179966 | 2022-02-03 | Roberts | South Dakota | 46109 | 2296 | 47 |
2171860 | 2171860 | 2022-02-01 | Doniphan | Kansas | 20043 | 2296 | 32 |
2168607 | 2168607 | 2022-01-31 | Doniphan | Kansas | 20043 | 2296 | 32 |
2156201 | 2156201 | 2022-01-27 | Douglas | Missouri | 29067 | 2296 | 68 |
2102943 | 2102943 | 2022-01-11 | Unknown | Connecticut | 2296 | 3 | |
2097203 | 2097203 | 2022-01-09 | Martin | Kentucky | 21159 | 2296 | 39 |
2099086 | 2099086 | 2022-01-09 | Dickenson | Virginia | 51051 | 2296 | 38 |
2093951 | 2093951 | 2022-01-08 | Martin | Kentucky | 21159 | 2296 | 39 |
2095835 | 2095835 | 2022-01-08 | Dickenson | Virginia | 51051 | 2296 | 38 |
2090699 | 2090699 | 2022-01-07 | Martin | Kentucky | 21159 | 2296 | 39 |
2092583 | 2092583 | 2022-01-07 | Dickenson | Virginia | 51051 | 2296 | 38 |
2033805 | 2033805 | 2021-12-20 | Eastland | Texas | 48133 | 2296 | 87 |
2026735 | 2026735 | 2021-12-18 | Noble | Ohio | 39121 | 2296 | 50 |
1996316 | 1996316 | 2021-12-09 | Nemaha | Kansas | 20131 | 2296 | 56 |
1993065 | 1993065 | 2021-12-08 | Nemaha | Kansas | 20131 | 2296 | 56 |
1995184 | 1995184 | 2021-12-08 | Klickitat | Washington | 53039 | 2296 | 30 |
1995309 | 1995309 | 2021-12-08 | Price | Wisconsin | 55099 | 2296 | 16 |
1948972 | 1948972 | 2021-11-24 | Las Piedras | Puerto Rico | 72085 | 2296 | |
1945721 | 1945721 | 2021-11-23 | Las Piedras | Puerto Rico | 72085 | 2296 | |
1942470 | 1942470 | 2021-11-22 | Las Piedras | Puerto Rico | 72085 | 2296 | |
1937465 | 1937465 | 2021-11-21 | De Witt | Illinois | 17039 | 2296 | 37 |
1939220 | 1939220 | 2021-11-21 | Las Piedras | Puerto Rico | 72085 | 2296 | |
1934215 | 1934215 | 2021-11-20 | De Witt | Illinois | 17039 | 2296 | 37 |
1930964 | 1930964 | 2021-11-19 | De Witt | Illinois | 17039 | 2296 | 37 |
1915128 | 1915128 | 2021-11-14 | Estill | Kentucky | 21065 | 2296 | 14 |
1911878 | 1911878 | 2021-11-13 | Estill | Kentucky | 21065 | 2296 | 14 |
1908629 | 1908629 | 2021-11-12 | Estill | Kentucky | 21065 | 2296 | 14 |
1903137 | 1903137 | 2021-11-10 | Ramsey | North Dakota | 38071 | 2296 | 38 |
1882684 | 1882684 | 2021-11-04 | Monroe | Kentucky | 21171 | 2296 | 59 |
1881323 | 1881323 | 2021-11-03 | Giles | Virginia | 51071 | 2296 | 31 |
1864913 | 1864913 | 2021-10-29 | Pecos | Texas | 48371 | 2296 | 50 |
1859268 | 1859268 | 2021-10-28 | Charlton | Georgia | 13049 | 2296 | 55 |
1855642 | 1855642 | 2021-10-27 | Lamar | Alabama | 1075 | 2296 | 47 |
1848667 | 1848667 | 2021-10-24 | Pecos | Texas | 48371 | 2296 | 50 |
1801133 | 1801133 | 2021-10-10 | Parke | Indiana | 18121 | 2296 | 25 |
1801267 | 1801267 | 2021-10-10 | Atchison | Kansas | 20005 | 2296 | 24 |
1797884 | 1797884 | 2021-10-09 | Parke | Indiana | 18121 | 2296 | 25 |
1798018 | 1798018 | 2021-10-09 | Atchison | Kansas | 20005 | 2296 | 24 |
1794635 | 1794635 | 2021-10-08 | Parke | Indiana | 18121 | 2296 | 25 |
1794769 | 1794769 | 2021-10-08 | Atchison | Kansas | 20005 | 2296 | 24 |
1791521 | 1791521 | 2021-10-07 | Atchison | Kansas | 20005 | 2296 | 24 |
1788272 | 1788272 | 2021-10-06 | Atchison | Kansas | 20005 | 2296 | 24 |
1766862 | 1766862 | 2021-09-29 | Crook | Oregon | 41013 | 2296 | 39 |
1761636 | 1761636 | 2021-09-28 | Crowley | Colorado | 8025 | 2296 | 19 |
1762980 | 1762980 | 2021-09-28 | Ste. Genevieve | Missouri | 29186 | 2296 | 27 |
1741015 | 1741015 | 2021-09-21 | Manati | Puerto Rico | 72091 | 2296 | |
1741736 | 1741736 | 2021-09-21 | Barbour | West Virginia | 54001 | 2296 | 40 |
1737766 | 1737766 | 2021-09-20 | Manati | Puerto Rico | 72091 | 2296 | |
1715660 | 1715660 | 2021-09-13 | Nottoway | Virginia | 51135 | 2296 | 57 |
1700782 | 1700782 | 2021-09-09 | Bienville | Louisiana | 22013 | 2296 | 87 |
1667097 | 1667097 | 2021-08-29 | Iowa | Wisconsin | 55049 | 2296 | 14 |
1663849 | 1663849 | 2021-08-28 | Iowa | Wisconsin | 55049 | 2296 | 14 |
1660601 | 1660601 | 2021-08-27 | Iowa | Wisconsin | 55049 | 2296 | 14 |
1649879 | 1649879 | 2021-08-24 | McIntosh | Oklahoma | 40091 | 2296 | 63 |
1646630 | 1646630 | 2021-08-23 | McIntosh | Oklahoma | 40091 | 2296 | 63 |
1643381 | 1643381 | 2021-08-22 | McIntosh | Oklahoma | 40091 | 2296 | 63 |
1640131 | 1640131 | 2021-08-21 | McIntosh | Oklahoma | 40091 | 2296 | 63 |
1636881 | 1636881 | 2021-08-20 | McIntosh | Oklahoma | 40091 | 2296 | 63 |
1633631 | 1633631 | 2021-08-19 | McIntosh | Oklahoma | 40091 | 2296 | 63 |
1630384 | 1630384 | 2021-08-18 | McIntosh | Oklahoma | 40091 | 2296 | 63 |
1609130 | 1609130 | 2021-08-12 | Crisp | Georgia | 13081 | 2296 | 94 |
1600451 | 1600451 | 2021-08-09 | Andrew | Missouri | 29003 | 2296 | 22 |
1593977 | 1593977 | 2021-08-07 | Clinton | Missouri | 29049 | 2296 | 65 |
1589235 | 1589235 | 2021-08-06 | Fayette | Alabama | 1057 | 2296 | 65 |
1583815 | 1583815 | 2021-08-04 | Simpson | Kentucky | 21213 | 2296 | 44 |
1574441 | 1574441 | 2021-08-01 | Stone | Mississippi | 28131 | 2296 | 37 |
1571193 | 1571193 | 2021-07-31 | Stone | Mississippi | 28131 | 2296 | 37 |
1571320 | 1571320 | 2021-07-31 | Vernon | Missouri | 29217 | 2296 | 49 |
1567945 | 1567945 | 2021-07-30 | Stone | Mississippi | 28131 | 2296 | 37 |
1566333 | 1566333 | 2021-07-29 | Jackson | West Virginia | 54035 | 2296 | 62 |
1540060 | 1540060 | 2021-07-21 | Robertson | Texas | 48395 | 2296 | 47 |
1531942 | 1531942 | 2021-07-19 | Somerset | Maine | 23025 | 2296 | 33 |
1528695 | 1528695 | 2021-07-18 | Somerset | Maine | 23025 | 2296 | 33 |
1525448 | 1525448 | 2021-07-17 | Somerset | Maine | 23025 | 2296 | 33 |
1521009 | 1521009 | 2021-07-16 | Butler | Alabama | 1013 | 2296 | 71 |
1511381 | 1511381 | 2021-07-13 | Clark | Arkansas | 5019 | 2296 | 40 |
1512403 | 1512403 | 2021-07-13 | Grant | Louisiana | 22043 | 2296 | 58 |
1507171 | 1507171 | 2021-07-11 | Vega Alta | Puerto Rico | 72143 | 2296 |
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);