ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
212 rows where cases = 2181 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 27
- Texas 19
- Illinois 13
- Iowa 11
- Virginia 11
- Tennessee 9
- Alabama 8
- Missouri 8
- North Carolina 7
- Kentucky 6
- Puerto Rico 6
- Utah 6
- Mississippi 5
- South Carolina 5
- Indiana 4
- Kansas 4
- Louisiana 4
- Michigan 4
- Washington 4
- Alaska 3
- Arkansas 3
- California 3
- Colorado 3
- Florida 3
- Maryland 3
- North Dakota 3
- Ohio 3
- Pennsylvania 3
- Wisconsin 3
- Maine 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500039 | 2500039 | 2022-05-13 | Heard | Georgia | 13149 | 2181 | 54 |
2500209 | 2500209 | 2022-05-13 | Hamilton | Illinois | 17065 | 2181 | 34 |
2496781 | 2496781 | 2022-05-12 | Heard | Georgia | 13149 | 2181 | 54 |
2496951 | 2496951 | 2022-05-12 | Hamilton | Illinois | 17065 | 2181 | 34 |
2493523 | 2493523 | 2022-05-11 | Heard | Georgia | 13149 | 2181 | 54 |
2493693 | 2493693 | 2022-05-11 | Hamilton | Illinois | 17065 | 2181 | 34 |
2492822 | 2492822 | 2022-05-10 | Northampton | Virginia | 51131 | 2181 | 64 |
2487178 | 2487178 | 2022-05-09 | Hamilton | Illinois | 17065 | 2181 | 34 |
2489564 | 2489564 | 2022-05-09 | Northampton | Virginia | 51131 | 2181 | 64 |
2474146 | 2474146 | 2022-05-05 | Hamilton | Illinois | 17065 | 2181 | 34 |
2441234 | 2441234 | 2022-04-25 | Lincoln | Colorado | 8073 | 2181 | 9 |
2415315 | 2415315 | 2022-04-17 | Candler | Georgia | 13043 | 2181 | 94 |
2412059 | 2412059 | 2022-04-16 | Candler | Georgia | 13043 | 2181 | 94 |
2408803 | 2408803 | 2022-04-15 | Candler | Georgia | 13043 | 2181 | 94 |
2405547 | 2405547 | 2022-04-14 | Candler | Georgia | 13043 | 2181 | 94 |
2402292 | 2402292 | 2022-04-13 | Candler | Georgia | 13043 | 2181 | 94 |
2399037 | 2399037 | 2022-04-12 | Candler | Georgia | 13043 | 2181 | 94 |
2395782 | 2395782 | 2022-04-11 | Candler | Georgia | 13043 | 2181 | 94 |
2392526 | 2392526 | 2022-04-10 | Candler | Georgia | 13043 | 2181 | 94 |
2389270 | 2389270 | 2022-04-09 | Candler | Georgia | 13043 | 2181 | 94 |
2386015 | 2386015 | 2022-04-08 | Candler | Georgia | 13043 | 2181 | 94 |
2268052 | 2268052 | 2022-03-02 | Ochiltree | Texas | 48357 | 2181 | 47 |
2264799 | 2264799 | 2022-03-01 | Ochiltree | Texas | 48357 | 2181 | 46 |
2255580 | 2255580 | 2022-02-27 | Sitka City and Borough | Alaska | 2220 | 2181 | 5 |
2252329 | 2252329 | 2022-02-26 | Sitka City and Borough | Alaska | 2220 | 2181 | 5 |
2249078 | 2249078 | 2022-02-25 | Sitka City and Borough | Alaska | 2220 | 2181 | 5 |
2241628 | 2241628 | 2022-02-22 | Penuelas | Puerto Rico | 72111 | 2181 | |
2238377 | 2238377 | 2022-02-21 | Penuelas | Puerto Rico | 72111 | 2181 | |
2235126 | 2235126 | 2022-02-20 | Penuelas | Puerto Rico | 72111 | 2181 | |
2209546 | 2209546 | 2022-02-12 | Red River | Texas | 48387 | 2181 | 63 |
2198723 | 2198723 | 2022-02-09 | Unknown | Nebraska | 2181 | 375 | |
2162716 | 2162716 | 2022-01-29 | Grundy | Missouri | 29079 | 2181 | 61 |
2134829 | 2134829 | 2022-01-20 | Amelia | Virginia | 51007 | 2181 | 44 |
2128052 | 2128052 | 2022-01-18 | Childress | Texas | 48075 | 2181 | 25 |
2081456 | 2081456 | 2022-01-04 | Ripley | Missouri | 29181 | 2181 | 52 |
2056518 | 2056518 | 2021-12-27 | Camp | Texas | 48063 | 2181 | 68 |
2007143 | 2007143 | 2021-12-12 | Mountrail | North Dakota | 38061 | 2181 | 31 |
1992700 | 1992700 | 2021-12-08 | Shoshone | Idaho | 16079 | 2181 | 66 |
1984774 | 1984774 | 2021-12-05 | Bamberg | South Carolina | 45009 | 2181 | 63 |
1981524 | 1981524 | 2021-12-04 | Bamberg | South Carolina | 45009 | 2181 | 63 |
1978274 | 1978274 | 2021-12-03 | Bamberg | South Carolina | 45009 | 2181 | 63 |
1975024 | 1975024 | 2021-12-02 | Bamberg | South Carolina | 45009 | 2181 | 63 |
1971775 | 1971775 | 2021-12-01 | Bamberg | South Carolina | 45009 | 2181 | 63 |
1942704 | 1942704 | 2021-11-22 | Stewart | Tennessee | 47161 | 2181 | 35 |
1928437 | 1928437 | 2021-11-18 | Cottonwood | Minnesota | 27033 | 2181 | 32 |
1921291 | 1921291 | 2021-11-16 | Washington | Illinois | 17189 | 2181 | 36 |
1905285 | 1905285 | 2021-11-11 | Jackson | Kansas | 20085 | 2181 | 20 |
1902035 | 1902035 | 2021-11-10 | Jackson | Kansas | 20085 | 2181 | 20 |
1893705 | 1893705 | 2021-11-07 | Fajardo | Puerto Rico | 72053 | 2181 | |
1881867 | 1881867 | 2021-11-04 | Grand | Colorado | 8049 | 2181 | 16 |
1882709 | 1882709 | 2021-11-04 | Trigg | Kentucky | 21221 | 2181 | 23 |
1875530 | 1875530 | 2021-11-02 | Dade | Georgia | 13083 | 2181 | 21 |
1874439 | 1874439 | 2021-11-01 | Meigs | Tennessee | 47121 | 2181 | 28 |
1869296 | 1869296 | 2021-10-31 | Wabash | Illinois | 17185 | 2181 | 22 |
1871190 | 1871190 | 2021-10-31 | Meigs | Tennessee | 47121 | 2181 | 28 |
1866047 | 1866047 | 2021-10-30 | Wabash | Illinois | 17185 | 2181 | 22 |
1867941 | 1867941 | 2021-10-30 | Meigs | Tennessee | 47121 | 2181 | 28 |
1862285 | 1862285 | 2021-10-29 | Van Buren | Arkansas | 5141 | 2181 | 42 |
1862798 | 1862798 | 2021-10-29 | Wabash | Illinois | 17185 | 2181 | 22 |
1864692 | 1864692 | 2021-10-29 | Meigs | Tennessee | 47121 | 2181 | 28 |
1853018 | 1853018 | 2021-10-26 | Massac | Illinois | 17127 | 2181 | 54 |
1826398 | 1826398 | 2021-10-18 | Lamar | Alabama | 1075 | 2181 | 46 |
1779516 | 1779516 | 2021-10-03 | Schoharie | New York | 36095 | 2181 | 21 |
1769802 | 1769802 | 2021-09-30 | Chowan | North Carolina | 37041 | 2181 | 40 |
1765041 | 1765041 | 2021-09-29 | Charlton | Georgia | 13049 | 2181 | 52 |
1746251 | 1746251 | 2021-09-23 | Washington | Kentucky | 21229 | 2181 | 42 |
1737386 | 1737386 | 2021-09-20 | Warren | North Carolina | 37185 | 2181 | 24 |
1716761 | 1716761 | 2021-09-14 | Page | Iowa | 19145 | 2181 | 23 |
1713515 | 1713515 | 2021-09-13 | Page | Iowa | 19145 | 2181 | 23 |
1709801 | 1709801 | 2021-09-12 | Bleckley | Georgia | 13023 | 2181 | 56 |
1710268 | 1710268 | 2021-09-12 | Page | Iowa | 19145 | 2181 | 23 |
1706554 | 1706554 | 2021-09-11 | Bleckley | Georgia | 13023 | 2181 | 56 |
1707021 | 1707021 | 2021-09-11 | Page | Iowa | 19145 | 2181 | 23 |
1703306 | 1703306 | 2021-09-10 | Bleckley | Georgia | 13023 | 2181 | 56 |
1703773 | 1703773 | 2021-09-10 | Page | Iowa | 19145 | 2181 | 23 |
1700523 | 1700523 | 2021-09-09 | Page | Iowa | 19145 | 2181 | 23 |
1697274 | 1697274 | 2021-09-08 | Page | Iowa | 19145 | 2181 | 23 |
1695670 | 1695670 | 2021-09-07 | Oglala Lakota | South Dakota | 46102 | 2181 | 51 |
1679422 | 1679422 | 2021-09-02 | Oglala Lakota | South Dakota | 46102 | 2181 | 51 |
1654319 | 1654319 | 2021-08-26 | Izard | Arkansas | 5065 | 2181 | 50 |
1645129 | 1645129 | 2021-08-23 | Wayne | Illinois | 17191 | 2181 | 55 |
1642396 | 1642396 | 2021-08-22 | Garrett | Maryland | 24023 | 2181 | 66 |
1639512 | 1639512 | 2021-08-21 | Pike | Missouri | 29163 | 2181 | 29 |
1637064 | 1637064 | 2021-08-20 | Moca | Puerto Rico | 72099 | 2181 | |
1631095 | 1631095 | 2021-08-18 | Bennington | Vermont | 50003 | 2181 | 15 |
1624995 | 1624995 | 2021-08-17 | Randolph | Alabama | 1111 | 2181 | 53 |
1611313 | 1611313 | 2021-08-12 | Unicoi | Tennessee | 47171 | 2181 | 51 |
1611396 | 1611396 | 2021-08-12 | Falls | Texas | 48145 | 2181 | 33 |
1571300 | 1571300 | 2021-07-31 | Ray | Missouri | 29177 | 2181 | 35 |
1554972 | 1554972 | 2021-07-26 | Andrew | Missouri | 29003 | 2181 | 22 |
1555384 | 1555384 | 2021-07-26 | Avery | North Carolina | 37011 | 2181 | 21 |
1550769 | 1550769 | 2021-07-25 | Washington | Georgia | 13303 | 2181 | 90 |
1547522 | 1547522 | 2021-07-24 | Washington | Georgia | 13303 | 2181 | 90 |
1544275 | 1544275 | 2021-07-23 | Washington | Georgia | 13303 | 2181 | 90 |
1541027 | 1541027 | 2021-07-22 | Washington | Georgia | 13303 | 2181 | 90 |
1538776 | 1538776 | 2021-07-21 | Henry | Missouri | 29083 | 2181 | 40 |
1518861 | 1518861 | 2021-07-15 | Simpson | Kentucky | 21213 | 2181 | 42 |
1492903 | 1492903 | 2021-07-07 | Woodford | Kentucky | 21239 | 2181 | 22 |
1491563 | 1491563 | 2021-07-06 | Radford city | Virginia | 51750 | 2181 | 19 |
1455064 | 1455064 | 2021-06-25 | Coos | Oregon | 41011 | 2181 | 37 |
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);