ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where cases = 4983 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Alabama 19
- Nebraska 9
- Iowa 8
- Texas 8
- Virginia 8
- Alaska 7
- Missouri 6
- North Carolina 6
- Georgia 5
- Indiana 5
- Ohio 5
- Minnesota 4
- Mississippi 4
- Illinois 3
- Michigan 3
- New Mexico 3
- Arkansas 2
- New York 2
- Pennsylvania 2
- South Carolina 2
- Utah 2
- Kentucky 1
- Louisiana 1
- Maryland 1
- North Dakota 1
- Oregon 1
- Puerto Rico 1
- Tennessee 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502415 | 2502415 | 2022-05-13 | Scurry | Texas | 48415 | 4983 | 104 |
2496345 | 2496345 | 2022-05-12 | Fayette | Alabama | 1057 | 4983 | 96 |
2493087 | 2493087 | 2022-05-11 | Fayette | Alabama | 1057 | 4983 | 96 |
2489829 | 2489829 | 2022-05-10 | Fayette | Alabama | 1057 | 4983 | 96 |
2489880 | 2489880 | 2022-05-10 | Kodiak Island Borough | Alaska | 2150 | 4983 | 12 |
2486572 | 2486572 | 2022-05-09 | Fayette | Alabama | 1057 | 4983 | 96 |
2486623 | 2486623 | 2022-05-09 | Kodiak Island Borough | Alaska | 2150 | 4983 | 12 |
2483314 | 2483314 | 2022-05-08 | Fayette | Alabama | 1057 | 4983 | 96 |
2483365 | 2483365 | 2022-05-08 | Kodiak Island Borough | Alaska | 2150 | 4983 | 12 |
2480056 | 2480056 | 2022-05-07 | Fayette | Alabama | 1057 | 4983 | 96 |
2480107 | 2480107 | 2022-05-07 | Kodiak Island Borough | Alaska | 2150 | 4983 | 12 |
2476798 | 2476798 | 2022-05-06 | Fayette | Alabama | 1057 | 4983 | 96 |
2476849 | 2476849 | 2022-05-06 | Kodiak Island Borough | Alaska | 2150 | 4983 | 12 |
2473540 | 2473540 | 2022-05-05 | Fayette | Alabama | 1057 | 4983 | 96 |
2473591 | 2473591 | 2022-05-05 | Kodiak Island Borough | Alaska | 2150 | 4983 | 12 |
2470283 | 2470283 | 2022-05-04 | Fayette | Alabama | 1057 | 4983 | 96 |
2470334 | 2470334 | 2022-05-04 | Kodiak Island Borough | Alaska | 2150 | 4983 | 12 |
2467027 | 2467027 | 2022-05-03 | Fayette | Alabama | 1057 | 4983 | 96 |
2437724 | 2437724 | 2022-04-24 | Fayette | Alabama | 1057 | 4983 | 96 |
2434468 | 2434468 | 2022-04-23 | Fayette | Alabama | 1057 | 4983 | 96 |
2431212 | 2431212 | 2022-04-22 | Fayette | Alabama | 1057 | 4983 | 96 |
2427956 | 2427956 | 2022-04-21 | Fayette | Alabama | 1057 | 4983 | 96 |
2424700 | 2424700 | 2022-04-20 | Fayette | Alabama | 1057 | 4983 | 96 |
2421444 | 2421444 | 2022-04-19 | Fayette | Alabama | 1057 | 4983 | 96 |
2377775 | 2377775 | 2022-04-05 | Currituck | North Carolina | 37053 | 4983 | 32 |
2342404 | 2342404 | 2022-03-25 | Cabo Rojo | Puerto Rico | 72023 | 4983 | |
2326786 | 2326786 | 2022-03-20 | King George | Virginia | 51099 | 4983 | 38 |
2322376 | 2322376 | 2022-03-19 | Roosevelt | New Mexico | 35041 | 4983 | 92 |
2323533 | 2323533 | 2022-03-19 | King George | Virginia | 51099 | 4983 | 38 |
2319122 | 2319122 | 2022-03-18 | Roosevelt | New Mexico | 35041 | 4983 | 92 |
2320279 | 2320279 | 2022-03-18 | King George | Virginia | 51099 | 4983 | 38 |
2315869 | 2315869 | 2022-03-17 | Roosevelt | New Mexico | 35041 | 4983 | 92 |
2317025 | 2317025 | 2022-03-17 | King George | Virginia | 51099 | 4983 | 38 |
2248001 | 2248001 | 2022-02-24 | Union | Oregon | 41061 | 4983 | 73 |
2221340 | 2221340 | 2022-02-16 | Vernon | Missouri | 29217 | 4983 | 99 |
2213717 | 2213717 | 2022-02-14 | McDuffie | Georgia | 13189 | 4983 | 89 |
2209499 | 2209499 | 2022-02-12 | Limestone | Texas | 48293 | 4983 | 117 |
2197019 | 2197019 | 2022-02-09 | Randolph | Alabama | 1111 | 4983 | 71 |
2180410 | 2180410 | 2022-02-03 | Dinwiddie | Virginia | 51053 | 4983 | 64 |
2164869 | 2164869 | 2022-01-30 | Dodge | Georgia | 13091 | 4983 | 138 |
2161614 | 2161614 | 2022-01-29 | Dodge | Georgia | 13091 | 4983 | 138 |
2158358 | 2158358 | 2022-01-28 | Dodge | Georgia | 13091 | 4983 | 138 |
2152764 | 2152764 | 2022-01-26 | Dodge | Minnesota | 27039 | 4983 | 14 |
2103270 | 2103270 | 2022-01-11 | Jersey | Illinois | 17083 | 4983 | 77 |
2073428 | 2073428 | 2022-01-02 | Winston | Alabama | 1133 | 4983 | 111 |
2074840 | 2074840 | 2022-01-02 | Scott | Mississippi | 28123 | 4983 | 99 |
2071589 | 2071589 | 2022-01-01 | Scott | Mississippi | 28123 | 4983 | 99 |
2068338 | 2068338 | 2021-12-31 | Scott | Mississippi | 28123 | 4983 | 99 |
2065087 | 2065087 | 2021-12-30 | Scott | Mississippi | 28123 | 4983 | 99 |
2057855 | 2057855 | 2021-12-28 | Jennings | Indiana | 18079 | 4983 | 75 |
2040074 | 2040074 | 2021-12-22 | Union | South Carolina | 45087 | 4983 | 113 |
2035628 | 2035628 | 2021-12-21 | Dickinson | Michigan | 26043 | 4983 | 92 |
2032378 | 2032378 | 2021-12-20 | Dickinson | Michigan | 26043 | 4983 | 92 |
1921401 | 1921401 | 2021-11-16 | Buena Vista | Iowa | 19021 | 4983 | 48 |
1918151 | 1918151 | 2021-11-15 | Buena Vista | Iowa | 19021 | 4983 | 48 |
1914901 | 1914901 | 2021-11-14 | Buena Vista | Iowa | 19021 | 4983 | 48 |
1915978 | 1915978 | 2021-11-14 | Otsego | New York | 36077 | 4983 | 57 |
1911651 | 1911651 | 2021-11-13 | Buena Vista | Iowa | 19021 | 4983 | 48 |
1908402 | 1908402 | 2021-11-12 | Buena Vista | Iowa | 19021 | 4983 | 48 |
1904512 | 1904512 | 2021-11-11 | Poinsett | Arkansas | 5111 | 4983 | 101 |
1905153 | 1905153 | 2021-11-11 | Buena Vista | Iowa | 19021 | 4983 | 48 |
1901903 | 1901903 | 2021-11-10 | Buena Vista | Iowa | 19021 | 4983 | 48 |
1858303 | 1858303 | 2021-10-27 | Fannin | Texas | 48147 | 4983 | 149 |
1855054 | 1855054 | 2021-10-26 | Fannin | Texas | 48147 | 4983 | 149 |
1815437 | 1815437 | 2021-10-14 | Champaign | Ohio | 39021 | 4983 | 70 |
1811504 | 1811504 | 2021-10-13 | Polk | Minnesota | 27119 | 4983 | 76 |
1809871 | 1809871 | 2021-10-12 | Manassas city | Virginia | 51683 | 4983 | 51 |
1763104 | 1763104 | 2021-09-28 | Lincoln | Nebraska | 31111 | 4983 | 80 |
1764276 | 1764276 | 2021-09-28 | Sanpete | Utah | 49039 | 4983 | 31 |
1759712 | 1759712 | 2021-09-27 | Polk | Missouri | 29167 | 4983 | 52 |
1756464 | 1756464 | 2021-09-26 | Polk | Missouri | 29167 | 4983 | 52 |
1753216 | 1753216 | 2021-09-25 | Polk | Missouri | 29167 | 4983 | 52 |
1746689 | 1746689 | 2021-09-23 | Lawrence | Missouri | 29109 | 4983 | 102 |
1723762 | 1723762 | 2021-09-16 | McLeod | Minnesota | 27085 | 4983 | 62 |
1723790 | 1723790 | 2021-09-16 | Steele | Minnesota | 27147 | 4983 | 21 |
1697161 | 1697161 | 2021-09-08 | Miami | Indiana | 18103 | 4983 | 81 |
1680337 | 1680337 | 2021-09-03 | Union | Arkansas | 5139 | 4983 | 120 |
1674342 | 1674342 | 2021-09-01 | Randolph | Illinois | 17157 | 4983 | 97 |
1657133 | 1657133 | 2021-08-26 | Danville city | Virginia | 51590 | 4983 | 150 |
1646864 | 1646864 | 2021-08-23 | Dillon | South Carolina | 45033 | 4983 | 89 |
1630779 | 1630779 | 2021-08-18 | Obion | Tennessee | 47131 | 4983 | 98 |
1625668 | 1625668 | 2021-08-17 | Gibson | Indiana | 18051 | 4983 | 100 |
1609389 | 1609389 | 2021-08-12 | Stephenson | Illinois | 17177 | 4983 | 106 |
1610207 | 1610207 | 2021-08-12 | Butler | Missouri | 29023 | 4983 | 55 |
1601811 | 1601811 | 2021-08-09 | Van Zandt | Texas | 48467 | 4983 | 133 |
1598563 | 1598563 | 2021-08-08 | Van Zandt | Texas | 48467 | 4983 | 133 |
1595314 | 1595314 | 2021-08-07 | Van Zandt | Texas | 48467 | 4983 | 130 |
1592065 | 1592065 | 2021-08-06 | Van Zandt | Texas | 48467 | 4983 | 130 |
1577315 | 1577315 | 2021-08-02 | Shelby | Kentucky | 21211 | 4983 | 79 |
1519803 | 1519803 | 2021-07-15 | Stark | North Dakota | 38089 | 4983 | 52 |
1490231 | 1490231 | 2021-07-06 | Dodge | Nebraska | 31053 | 4983 | 80 |
1486984 | 1486984 | 2021-07-05 | Dodge | Nebraska | 31053 | 4983 | 80 |
1483738 | 1483738 | 2021-07-04 | Dodge | Nebraska | 31053 | 4983 | 80 |
1480492 | 1480492 | 2021-07-03 | Dodge | Nebraska | 31053 | 4983 | 80 |
1477245 | 1477245 | 2021-07-02 | Dodge | Nebraska | 31053 | 4983 | 80 |
1473999 | 1473999 | 2021-07-01 | Dodge | Nebraska | 31053 | 4983 | 80 |
1475246 | 1475246 | 2021-07-01 | Campbell | Virginia | 51031 | 4983 | 100 |
1470753 | 1470753 | 2021-06-30 | Dodge | Nebraska | 31053 | 4983 | 80 |
1467508 | 1467508 | 2021-06-29 | Dodge | Nebraska | 31053 | 4983 | 80 |
1448339 | 1448339 | 2021-06-23 | Watauga | North Carolina | 37189 | 4983 | 33 |
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);