ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
896 rows where cases = 223 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 104
- Kansas 56
- Georgia 52
- Virginia 50
- Missouri 38
- Puerto Rico 31
- Nebraska 29
- Kentucky 27
- Ohio 26
- Illinois 23
- Indiana 23
- Mississippi 23
- Iowa 22
- Michigan 20
- Washington 20
- North Carolina 19
- Arkansas 18
- New York 18
- South Dakota 18
- Oregon 17
- Tennessee 17
- West Virginia 17
- Colorado 16
- Minnesota 15
- Oklahoma 15
- Alaska 14
- Montana 14
- North Dakota 13
- Pennsylvania 13
- Florida 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492554 | 2492554 | 2022-05-10 | Jeff Davis | Texas | 48243 | 223 | 9 |
2489296 | 2489296 | 2022-05-09 | Jeff Davis | Texas | 48243 | 223 | 9 |
2486039 | 2486039 | 2022-05-08 | Jeff Davis | Texas | 48243 | 223 | 9 |
2482781 | 2482781 | 2022-05-07 | Jeff Davis | Texas | 48243 | 223 | 9 |
2479523 | 2479523 | 2022-05-06 | Jeff Davis | Texas | 48243 | 223 | 9 |
2476265 | 2476265 | 2022-05-05 | Jeff Davis | Texas | 48243 | 223 | 9 |
2473008 | 2473008 | 2022-05-04 | Jeff Davis | Texas | 48243 | 223 | 9 |
2468639 | 2468639 | 2022-05-03 | Judith Basin | Montana | 30045 | 223 | 1 |
2469752 | 2469752 | 2022-05-03 | Jeff Davis | Texas | 48243 | 223 | 9 |
2465383 | 2465383 | 2022-05-02 | Judith Basin | Montana | 30045 | 223 | 1 |
2466496 | 2466496 | 2022-05-02 | Jeff Davis | Texas | 48243 | 223 | 9 |
2463241 | 2463241 | 2022-05-01 | Jeff Davis | Texas | 48243 | 223 | 9 |
2459985 | 2459985 | 2022-04-30 | Jeff Davis | Texas | 48243 | 223 | 9 |
2456729 | 2456729 | 2022-04-29 | Jeff Davis | Texas | 48243 | 223 | 9 |
2453473 | 2453473 | 2022-04-28 | Jeff Davis | Texas | 48243 | 223 | 9 |
2450217 | 2450217 | 2022-04-27 | Jeff Davis | Texas | 48243 | 223 | 9 |
2446960 | 2446960 | 2022-04-26 | Jeff Davis | Texas | 48243 | 223 | 9 |
2443705 | 2443705 | 2022-04-25 | Jeff Davis | Texas | 48243 | 223 | 9 |
2440449 | 2440449 | 2022-04-24 | Jeff Davis | Texas | 48243 | 223 | 9 |
2437193 | 2437193 | 2022-04-23 | Jeff Davis | Texas | 48243 | 223 | 9 |
2433937 | 2433937 | 2022-04-22 | Jeff Davis | Texas | 48243 | 223 | 9 |
2430681 | 2430681 | 2022-04-21 | Jeff Davis | Texas | 48243 | 223 | 9 |
2427425 | 2427425 | 2022-04-20 | Jeff Davis | Texas | 48243 | 223 | 9 |
2424169 | 2424169 | 2022-04-19 | Jeff Davis | Texas | 48243 | 223 | 9 |
2420913 | 2420913 | 2022-04-18 | Jeff Davis | Texas | 48243 | 223 | 9 |
2417657 | 2417657 | 2022-04-17 | Jeff Davis | Texas | 48243 | 223 | 9 |
2414401 | 2414401 | 2022-04-16 | Jeff Davis | Texas | 48243 | 223 | 9 |
2411145 | 2411145 | 2022-04-15 | Jeff Davis | Texas | 48243 | 223 | 9 |
2407889 | 2407889 | 2022-04-14 | Jeff Davis | Texas | 48243 | 223 | 9 |
2404633 | 2404633 | 2022-04-13 | Jeff Davis | Texas | 48243 | 223 | 9 |
2401378 | 2401378 | 2022-04-12 | Jeff Davis | Texas | 48243 | 223 | 9 |
2398123 | 2398123 | 2022-04-11 | Jeff Davis | Texas | 48243 | 223 | 9 |
2394868 | 2394868 | 2022-04-10 | Jeff Davis | Texas | 48243 | 223 | 9 |
2391612 | 2391612 | 2022-04-09 | Jeff Davis | Texas | 48243 | 223 | 9 |
2388356 | 2388356 | 2022-04-08 | Jeff Davis | Texas | 48243 | 223 | 9 |
2385101 | 2385101 | 2022-04-07 | Jeff Davis | Texas | 48243 | 223 | 9 |
2381846 | 2381846 | 2022-04-06 | Jeff Davis | Texas | 48243 | 223 | 9 |
2378591 | 2378591 | 2022-04-05 | Jeff Davis | Texas | 48243 | 223 | 9 |
2375337 | 2375337 | 2022-04-04 | Jeff Davis | Texas | 48243 | 223 | 9 |
2372085 | 2372085 | 2022-04-03 | Jeff Davis | Texas | 48243 | 223 | 9 |
2368832 | 2368832 | 2022-04-02 | Jeff Davis | Texas | 48243 | 223 | 9 |
2365579 | 2365579 | 2022-04-01 | Jeff Davis | Texas | 48243 | 223 | 9 |
2362326 | 2362326 | 2022-03-31 | Jeff Davis | Texas | 48243 | 223 | 9 |
2359072 | 2359072 | 2022-03-30 | Jeff Davis | Texas | 48243 | 223 | 9 |
2355818 | 2355818 | 2022-03-29 | Jeff Davis | Texas | 48243 | 223 | 9 |
2352565 | 2352565 | 2022-03-28 | Jeff Davis | Texas | 48243 | 223 | 9 |
2349313 | 2349313 | 2022-03-27 | Jeff Davis | Texas | 48243 | 223 | 9 |
2346060 | 2346060 | 2022-03-26 | Jeff Davis | Texas | 48243 | 223 | 9 |
2342807 | 2342807 | 2022-03-25 | Jeff Davis | Texas | 48243 | 223 | 9 |
2339554 | 2339554 | 2022-03-24 | Jeff Davis | Texas | 48243 | 223 | 9 |
2283141 | 2283141 | 2022-03-07 | Garfield | Montana | 30033 | 223 | 3 |
2279888 | 2279888 | 2022-03-06 | Garfield | Montana | 30033 | 223 | 3 |
2276635 | 2276635 | 2022-03-05 | Garfield | Montana | 30033 | 223 | 3 |
2273382 | 2273382 | 2022-03-04 | Garfield | Montana | 30033 | 223 | 3 |
2124659 | 2124659 | 2022-01-17 | Sully | South Dakota | 46119 | 223 | 3 |
2121407 | 2121407 | 2022-01-16 | Sully | South Dakota | 46119 | 223 | 3 |
2118155 | 2118155 | 2022-01-15 | Sully | South Dakota | 46119 | 223 | 3 |
2114904 | 2114904 | 2022-01-14 | Sully | South Dakota | 46119 | 223 | 3 |
2108135 | 2108135 | 2022-01-12 | Sherman | Oregon | 41055 | 223 | 3 |
2108351 | 2108351 | 2022-01-12 | Campbell | South Dakota | 46021 | 223 | 6 |
2083209 | 2083209 | 2022-01-05 | Wrangell City and Borough | Alaska | 2275 | 223 | 1 |
2079957 | 2079957 | 2022-01-04 | Wrangell City and Borough | Alaska | 2275 | 223 | 1 |
2076705 | 2076705 | 2022-01-03 | Wrangell City and Borough | Alaska | 2275 | 223 | 1 |
2043850 | 2043850 | 2021-12-23 | Highland | Virginia | 51091 | 223 | 4 |
2033610 | 2033610 | 2021-12-20 | Hyde | South Dakota | 46069 | 223 | 5 |
1937099 | 1937099 | 2021-11-21 | Cheyenne | Colorado | 8017 | 223 | 7 |
1933849 | 1933849 | 2021-11-20 | Cheyenne | Colorado | 8017 | 223 | 7 |
1930597 | 1930597 | 2021-11-19 | Cheyenne | Colorado | 8017 | 223 | 7 |
1928872 | 1928872 | 2021-11-18 | Storey | Nevada | 32029 | 223 | 5 |
1922373 | 1922373 | 2021-11-16 | Storey | Nevada | 32029 | 223 | 5 |
1919123 | 1919123 | 2021-11-15 | Storey | Nevada | 32029 | 223 | 5 |
1873666 | 1873666 | 2021-11-01 | Catron | New Mexico | 35003 | 223 | 7 |
1866965 | 1866965 | 2021-10-30 | Worth | Missouri | 29227 | 223 | 2 |
1863716 | 1863716 | 2021-10-29 | Worth | Missouri | 29227 | 223 | 2 |
1858929 | 1858929 | 2021-10-28 | Haines Borough | Alaska | 2100 | 223 | 1 |
1860467 | 1860467 | 2021-10-28 | Worth | Missouri | 29227 | 223 | 2 |
1855680 | 1855680 | 2021-10-27 | Haines Borough | Alaska | 2100 | 223 | 0 |
1855881 | 1855881 | 2021-10-27 | Kiowa | Colorado | 8061 | 223 | 4 |
1857218 | 1857218 | 2021-10-27 | Worth | Missouri | 29227 | 223 | 2 |
1852431 | 1852431 | 2021-10-26 | Haines Borough | Alaska | 2100 | 223 | 0 |
1853969 | 1853969 | 2021-10-26 | Worth | Missouri | 29227 | 223 | 2 |
1849181 | 1849181 | 2021-10-25 | Haines Borough | Alaska | 2100 | 223 | 0 |
1850720 | 1850720 | 2021-10-25 | Worth | Missouri | 29227 | 223 | 2 |
1847470 | 1847470 | 2021-10-24 | Worth | Missouri | 29227 | 223 | 2 |
1844220 | 1844220 | 2021-10-23 | Worth | Missouri | 29227 | 223 | 2 |
1809939 | 1809939 | 2021-10-12 | Garfield | Washington | 53023 | 223 | 7 |
1805295 | 1805295 | 2021-10-11 | Boyd | Nebraska | 31015 | 223 | 3 |
1802046 | 1802046 | 2021-10-10 | Boyd | Nebraska | 31015 | 223 | 3 |
1798797 | 1798797 | 2021-10-09 | Boyd | Nebraska | 31015 | 223 | 3 |
1795548 | 1795548 | 2021-10-08 | Boyd | Nebraska | 31015 | 223 | 3 |
1791906 | 1791906 | 2021-10-07 | Keweenaw | Michigan | 26083 | 223 | 4 |
1792299 | 1792299 | 2021-10-07 | Boyd | Nebraska | 31015 | 223 | 3 |
1792442 | 1792442 | 2021-10-07 | De Baca | New Mexico | 35011 | 223 | 3 |
1788657 | 1788657 | 2021-10-06 | Keweenaw | Michigan | 26083 | 223 | 4 |
1789050 | 1789050 | 2021-10-06 | Boyd | Nebraska | 31015 | 223 | 3 |
1789193 | 1789193 | 2021-10-06 | De Baca | New Mexico | 35011 | 223 | 3 |
1785467 | 1785467 | 2021-10-05 | Cook | Minnesota | 27031 | 223 | 0 |
1785802 | 1785802 | 2021-10-05 | Boyd | Nebraska | 31015 | 223 | 3 |
1785831 | 1785831 | 2021-10-05 | Gosper | Nebraska | 31073 | 223 | 5 |
1782553 | 1782553 | 2021-10-04 | Boyd | Nebraska | 31015 | 223 | 3 |
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);