ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
331 rows where cases = 1526 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 33
- Illinois 30
- Missouri 20
- Puerto Rico 17
- Virginia 14
- Georgia 13
- Montana 12
- Oklahoma 12
- Alabama 11
- Kentucky 11
- Louisiana 11
- Mississippi 10
- Kansas 9
- North Carolina 9
- Tennessee 9
- Iowa 8
- Minnesota 8
- West Virginia 8
- Nebraska 7
- Florida 6
- Oregon 6
- Wisconsin 6
- Ohio 5
- Arkansas 4
- California 4
- Colorado 4
- Indiana 4
- Michigan 4
- Pennsylvania 4
- South Carolina 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484973 | 2484973 | 2022-05-08 | Cedar | Nebraska | 31027 | 1526 | 14 |
2481715 | 2481715 | 2022-05-07 | Cedar | Nebraska | 31027 | 1526 | 14 |
2478457 | 2478457 | 2022-05-06 | Cedar | Nebraska | 31027 | 1526 | 14 |
2474895 | 2474895 | 2022-05-05 | Norman | Minnesota | 27107 | 1526 | 13 |
2475199 | 2475199 | 2022-05-05 | Cedar | Nebraska | 31027 | 1526 | 14 |
2471942 | 2471942 | 2022-05-04 | Cedar | Nebraska | 31027 | 1526 | 14 |
2467607 | 2467607 | 2022-05-03 | Calhoun | Illinois | 17013 | 1526 | 8 |
2464352 | 2464352 | 2022-05-02 | Calhoun | Illinois | 17013 | 1526 | 8 |
2461096 | 2461096 | 2022-05-01 | Calhoun | Illinois | 17013 | 1526 | 8 |
2457840 | 2457840 | 2022-04-30 | Calhoun | Illinois | 17013 | 1526 | 8 |
2454584 | 2454584 | 2022-04-29 | Calhoun | Illinois | 17013 | 1526 | 8 |
2451328 | 2451328 | 2022-04-28 | Calhoun | Illinois | 17013 | 1526 | 8 |
2448072 | 2448072 | 2022-04-27 | Calhoun | Illinois | 17013 | 1526 | 8 |
2449692 | 2449692 | 2022-04-27 | Tillman | Oklahoma | 40141 | 1526 | 34 |
2444816 | 2444816 | 2022-04-26 | Calhoun | Illinois | 17013 | 1526 | 8 |
2446435 | 2446435 | 2022-04-26 | Tillman | Oklahoma | 40141 | 1526 | 34 |
2443180 | 2443180 | 2022-04-25 | Tillman | Oklahoma | 40141 | 1526 | 34 |
2439924 | 2439924 | 2022-04-24 | Tillman | Oklahoma | 40141 | 1526 | 34 |
2436668 | 2436668 | 2022-04-23 | Tillman | Oklahoma | 40141 | 1526 | 34 |
2433412 | 2433412 | 2022-04-22 | Tillman | Oklahoma | 40141 | 1526 | 34 |
2430156 | 2430156 | 2022-04-21 | Tillman | Oklahoma | 40141 | 1526 | 34 |
2370998 | 2370998 | 2022-04-03 | Stillwater | Montana | 30095 | 1526 | 29 |
2367745 | 2367745 | 2022-04-02 | Stillwater | Montana | 30095 | 1526 | 29 |
2364492 | 2364492 | 2022-04-01 | Stillwater | Montana | 30095 | 1526 | 29 |
2365490 | 2365490 | 2022-04-01 | Carson | Texas | 48065 | 1526 | 34 |
2361238 | 2361238 | 2022-03-31 | Stillwater | Montana | 30095 | 1526 | 29 |
2357984 | 2357984 | 2022-03-30 | Stillwater | Montana | 30095 | 1526 | 29 |
2354731 | 2354731 | 2022-03-29 | Stillwater | Montana | 30095 | 1526 | 29 |
2350071 | 2350071 | 2022-03-28 | Clear Creek | Colorado | 8019 | 1526 | 12 |
2335147 | 2335147 | 2022-03-23 | Shelby | Missouri | 29205 | 1526 | 15 |
2263716 | 2263716 | 2022-03-01 | Keith | Nebraska | 31101 | 1526 | 17 |
2202462 | 2202462 | 2022-02-10 | Grant | Oregon | 41023 | 1526 | 18 |
2182219 | 2182219 | 2022-02-04 | Clark | Missouri | 29045 | 1526 | 28 |
2178967 | 2178967 | 2022-02-03 | Clark | Missouri | 29045 | 1526 | 28 |
2175756 | 2175756 | 2022-02-02 | Maries | Missouri | 29125 | 1526 | 28 |
2165962 | 2165962 | 2022-01-30 | Daviess | Missouri | 29061 | 1526 | 24 |
2131366 | 2131366 | 2022-01-19 | Hansford | Texas | 48195 | 1526 | 27 |
2118448 | 2118448 | 2022-01-15 | Rains | Texas | 48379 | 1526 | 49 |
2103537 | 2103537 | 2022-01-11 | Clay | Kansas | 20027 | 1526 | 31 |
2100286 | 2100286 | 2022-01-10 | Clay | Kansas | 20027 | 1526 | 31 |
2085882 | 2085882 | 2022-01-05 | La Salle | Texas | 48283 | 1526 | 41 |
2086320 | 2086320 | 2022-01-05 | Pepin | Wisconsin | 55091 | 1526 | 15 |
2064032 | 2064032 | 2021-12-30 | Clinch | Georgia | 13065 | 1526 | 36 |
2026997 | 2026997 | 2021-12-18 | Naguabo | Puerto Rico | 72103 | 1526 | |
2010072 | 2010072 | 2021-12-13 | Holt | Nebraska | 31089 | 1526 | 16 |
1962856 | 1962856 | 2021-11-29 | Bullock | Alabama | 1011 | 1526 | 45 |
1959605 | 1959605 | 2021-11-28 | Bullock | Alabama | 1011 | 1526 | 45 |
1961020 | 1961020 | 2021-11-28 | Benton | Mississippi | 28009 | 1526 | 39 |
1956354 | 1956354 | 2021-11-27 | Bullock | Alabama | 1011 | 1526 | 45 |
1957769 | 1957769 | 2021-11-27 | Benton | Mississippi | 28009 | 1526 | 39 |
1954518 | 1954518 | 2021-11-26 | Benton | Mississippi | 28009 | 1526 | 39 |
1951267 | 1951267 | 2021-11-25 | Benton | Mississippi | 28009 | 1526 | 39 |
1948016 | 1948016 | 2021-11-24 | Benton | Mississippi | 28009 | 1526 | 39 |
1943237 | 1943237 | 2021-11-22 | Ritchie | West Virginia | 54085 | 1526 | 21 |
1904852 | 1904852 | 2021-11-11 | Pulaski | Georgia | 13235 | 1526 | 61 |
1901602 | 1901602 | 2021-11-10 | Pulaski | Georgia | 13235 | 1526 | 61 |
1881760 | 1881760 | 2021-11-04 | Perry | Arkansas | 5105 | 1526 | 22 |
1875104 | 1875104 | 2021-11-02 | Bullock | Alabama | 1011 | 1526 | 44 |
1871855 | 1871855 | 2021-11-01 | Bullock | Alabama | 1011 | 1526 | 44 |
1868606 | 1868606 | 2021-10-31 | Bullock | Alabama | 1011 | 1526 | 44 |
1865357 | 1865357 | 2021-10-30 | Bullock | Alabama | 1011 | 1526 | 44 |
1862028 | 1862028 | 2021-10-28 | Forest | Wisconsin | 55041 | 1526 | 31 |
1855610 | 1855610 | 2021-10-27 | Bullock | Alabama | 1011 | 1526 | 43 |
1858491 | 1858491 | 2021-10-27 | Emery | Utah | 49015 | 1526 | 17 |
1851916 | 1851916 | 2021-10-25 | Parmer | Texas | 48369 | 1526 | 35 |
1848666 | 1848666 | 2021-10-24 | Parmer | Texas | 48369 | 1526 | 35 |
1845416 | 1845416 | 2021-10-23 | Parmer | Texas | 48369 | 1526 | 35 |
1834445 | 1834445 | 2021-10-20 | Ralls | Missouri | 29173 | 1526 | 14 |
1835522 | 1835522 | 2021-10-20 | Clay | Texas | 48077 | 1526 | 23 |
1810711 | 1810711 | 2021-10-13 | Owyhee | Idaho | 16073 | 1526 | 39 |
1808262 | 1808262 | 2021-10-12 | Rock | Minnesota | 27133 | 1526 | 19 |
1809530 | 1809530 | 2021-10-12 | Childress | Texas | 48075 | 1526 | 20 |
1806280 | 1806280 | 2021-10-11 | Childress | Texas | 48075 | 1526 | 20 |
1803030 | 1803030 | 2021-10-10 | Childress | Texas | 48075 | 1526 | 20 |
1799781 | 1799781 | 2021-10-09 | Childress | Texas | 48075 | 1526 | 20 |
1786625 | 1786625 | 2021-10-05 | Lake | South Dakota | 46079 | 1526 | 20 |
1781473 | 1781473 | 2021-10-04 | Teton | Idaho | 16081 | 1526 | 5 |
1775912 | 1775912 | 2021-10-02 | Grundy | Missouri | 29079 | 1526 | 47 |
1763695 | 1763695 | 2021-09-28 | Potter | Pennsylvania | 42105 | 1526 | 29 |
1722562 | 1722562 | 2021-09-16 | Scott | Arkansas | 5127 | 1526 | 23 |
1720671 | 1720671 | 2021-09-15 | Douglas | Missouri | 29067 | 1526 | 40 |
1699536 | 1699536 | 2021-09-08 | Morgan | West Virginia | 54065 | 1526 | 26 |
1695981 | 1695981 | 2021-09-07 | Runnels | Texas | 48399 | 1526 | 48 |
1692145 | 1692145 | 2021-09-06 | Curry | Oregon | 41015 | 1526 | 16 |
1692733 | 1692733 | 2021-09-06 | Runnels | Texas | 48399 | 1526 | 48 |
1688896 | 1688896 | 2021-09-05 | Curry | Oregon | 41015 | 1526 | 16 |
1689484 | 1689484 | 2021-09-05 | Runnels | Texas | 48399 | 1526 | 48 |
1685646 | 1685646 | 2021-09-04 | Curry | Oregon | 41015 | 1526 | 16 |
1686234 | 1686234 | 2021-09-04 | Runnels | Texas | 48399 | 1526 | 48 |
1682395 | 1682395 | 2021-09-03 | Curry | Oregon | 41015 | 1526 | 16 |
1683077 | 1683077 | 2021-09-03 | Orleans | Vermont | 50019 | 1526 | 13 |
1671683 | 1671683 | 2021-08-31 | Gogebic | Michigan | 26053 | 1526 | 53 |
1668436 | 1668436 | 2021-08-30 | Gogebic | Michigan | 26053 | 1526 | 53 |
1662707 | 1662707 | 2021-08-28 | Mountrail | North Dakota | 38061 | 1526 | 19 |
1657624 | 1657624 | 2021-08-27 | Inyo | California | 6027 | 1526 | 39 |
1657064 | 1657064 | 2021-08-26 | Juab | Utah | 49023 | 1526 | 14 |
1653262 | 1653262 | 2021-08-25 | Aguas Buenas | Puerto Rico | 72007 | 1526 | |
1650015 | 1650015 | 2021-08-24 | Aguas Buenas | Puerto Rico | 72007 | 1526 | |
1645518 | 1645518 | 2021-08-23 | Monroe | Kentucky | 21171 | 1526 | 46 |
1646766 | 1646766 | 2021-08-23 | Aguas Buenas | Puerto Rico | 72007 | 1526 |
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);