ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
707 rows where cases = 549 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 81
- North Dakota 54
- Kentucky 41
- Kansas 38
- Texas 38
- Nevada 33
- Puerto Rico 32
- Georgia 31
- Minnesota 26
- Missouri 25
- Virginia 25
- North Carolina 19
- Nebraska 18
- West Virginia 18
- Louisiana 17
- Iowa 16
- Illinois 15
- South Dakota 15
- Tennessee 14
- Michigan 12
- Mississippi 12
- New York 11
- Alabama 10
- Alaska 8
- Florida 8
- South Carolina 8
- Colorado 7
- Washington 7
- Arkansas 6
- Idaho 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489894 | 2489894 | 2022-05-10 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 549 | 5 |
2486637 | 2486637 | 2022-05-09 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 549 | 5 |
2483379 | 2483379 | 2022-05-08 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 549 | 5 |
2480121 | 2480121 | 2022-05-07 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 549 | 5 |
2476863 | 2476863 | 2022-05-06 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 549 | 5 |
2473605 | 2473605 | 2022-05-05 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 549 | 5 |
2470348 | 2470348 | 2022-05-04 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 549 | 5 |
2429976 | 2429976 | 2022-04-21 | Renville | North Dakota | 38075 | 549 | 15 |
2426720 | 2426720 | 2022-04-20 | Renville | North Dakota | 38075 | 549 | 15 |
2423193 | 2423193 | 2022-04-19 | Lincoln | Nevada | 32017 | 549 | 7 |
2423464 | 2423464 | 2022-04-19 | Renville | North Dakota | 38075 | 549 | 15 |
2419936 | 2419936 | 2022-04-18 | Lincoln | Nevada | 32017 | 549 | 7 |
2420207 | 2420207 | 2022-04-18 | Renville | North Dakota | 38075 | 549 | 15 |
2416681 | 2416681 | 2022-04-17 | Lincoln | Nevada | 32017 | 549 | 7 |
2416952 | 2416952 | 2022-04-17 | Renville | North Dakota | 38075 | 549 | 15 |
2413425 | 2413425 | 2022-04-16 | Lincoln | Nevada | 32017 | 549 | 7 |
2413696 | 2413696 | 2022-04-16 | Renville | North Dakota | 38075 | 549 | 15 |
2410169 | 2410169 | 2022-04-15 | Lincoln | Nevada | 32017 | 549 | 7 |
2410440 | 2410440 | 2022-04-15 | Renville | North Dakota | 38075 | 549 | 15 |
2406913 | 2406913 | 2022-04-14 | Lincoln | Nevada | 32017 | 549 | 7 |
2407184 | 2407184 | 2022-04-14 | Renville | North Dakota | 38075 | 549 | 15 |
2403657 | 2403657 | 2022-04-13 | Lincoln | Nevada | 32017 | 549 | 7 |
2403928 | 2403928 | 2022-04-13 | Renville | North Dakota | 38075 | 549 | 15 |
2400673 | 2400673 | 2022-04-12 | Renville | North Dakota | 38075 | 549 | 15 |
2397418 | 2397418 | 2022-04-11 | Renville | North Dakota | 38075 | 549 | 15 |
2394163 | 2394163 | 2022-04-10 | Renville | North Dakota | 38075 | 549 | 15 |
2390907 | 2390907 | 2022-04-09 | Renville | North Dakota | 38075 | 549 | 15 |
2387651 | 2387651 | 2022-04-08 | Renville | North Dakota | 38075 | 549 | 15 |
2384396 | 2384396 | 2022-04-07 | Renville | North Dakota | 38075 | 549 | 15 |
2381141 | 2381141 | 2022-04-06 | Renville | North Dakota | 38075 | 549 | 15 |
2377886 | 2377886 | 2022-04-05 | Renville | North Dakota | 38075 | 549 | 15 |
2374633 | 2374633 | 2022-04-04 | Renville | North Dakota | 38075 | 549 | 15 |
2371381 | 2371381 | 2022-04-03 | Renville | North Dakota | 38075 | 549 | 15 |
2368128 | 2368128 | 2022-04-02 | Renville | North Dakota | 38075 | 549 | 15 |
2364875 | 2364875 | 2022-04-01 | Renville | North Dakota | 38075 | 549 | 15 |
2342440 | 2342440 | 2022-03-25 | Maricao | Puerto Rico | 72093 | 549 | |
2339187 | 2339187 | 2022-03-24 | Maricao | Puerto Rico | 72093 | 549 | |
2335933 | 2335933 | 2022-03-23 | Maricao | Puerto Rico | 72093 | 549 | |
2331639 | 2331639 | 2022-03-22 | Cook | Minnesota | 27031 | 549 | 4 |
2332071 | 2332071 | 2022-03-22 | Lincoln | Nevada | 32017 | 549 | 7 |
2332679 | 2332679 | 2022-03-22 | Maricao | Puerto Rico | 72093 | 549 | |
2328818 | 2328818 | 2022-03-21 | Lincoln | Nevada | 32017 | 549 | 7 |
2329426 | 2329426 | 2022-03-21 | Maricao | Puerto Rico | 72093 | 549 | |
2325566 | 2325566 | 2022-03-20 | Lincoln | Nevada | 32017 | 549 | 7 |
2326174 | 2326174 | 2022-03-20 | Maricao | Puerto Rico | 72093 | 549 | |
2322312 | 2322312 | 2022-03-19 | Lincoln | Nevada | 32017 | 549 | 7 |
2322921 | 2322921 | 2022-03-19 | Maricao | Puerto Rico | 72093 | 549 | |
2319058 | 2319058 | 2022-03-18 | Lincoln | Nevada | 32017 | 549 | 7 |
2319667 | 2319667 | 2022-03-18 | Maricao | Puerto Rico | 72093 | 549 | |
2315805 | 2315805 | 2022-03-17 | Lincoln | Nevada | 32017 | 549 | 7 |
2316075 | 2316075 | 2022-03-17 | Renville | North Dakota | 38075 | 549 | 15 |
2316413 | 2316413 | 2022-03-17 | Maricao | Puerto Rico | 72093 | 549 | |
2312552 | 2312552 | 2022-03-16 | Lincoln | Nevada | 32017 | 549 | 7 |
2312822 | 2312822 | 2022-03-16 | Renville | North Dakota | 38075 | 549 | 15 |
2313160 | 2313160 | 2022-03-16 | Maricao | Puerto Rico | 72093 | 549 | |
2309569 | 2309569 | 2022-03-15 | Renville | North Dakota | 38075 | 549 | 15 |
2309907 | 2309907 | 2022-03-15 | Maricao | Puerto Rico | 72093 | 549 | |
2306316 | 2306316 | 2022-03-14 | Renville | North Dakota | 38075 | 549 | 15 |
2306654 | 2306654 | 2022-03-14 | Maricao | Puerto Rico | 72093 | 549 | |
2307079 | 2307079 | 2022-03-14 | Oldham | Texas | 48359 | 549 | 6 |
2302364 | 2302364 | 2022-03-13 | Cook | Minnesota | 27031 | 549 | 4 |
2303065 | 2303065 | 2022-03-13 | Renville | North Dakota | 38075 | 549 | 15 |
2303403 | 2303403 | 2022-03-13 | Maricao | Puerto Rico | 72093 | 549 | |
2303828 | 2303828 | 2022-03-13 | Oldham | Texas | 48359 | 549 | 6 |
2299112 | 2299112 | 2022-03-12 | Cook | Minnesota | 27031 | 549 | 4 |
2300151 | 2300151 | 2022-03-12 | Maricao | Puerto Rico | 72093 | 549 | |
2300576 | 2300576 | 2022-03-12 | Oldham | Texas | 48359 | 549 | 6 |
2295860 | 2295860 | 2022-03-11 | Cook | Minnesota | 27031 | 549 | 4 |
2296899 | 2296899 | 2022-03-11 | Maricao | Puerto Rico | 72093 | 549 | |
2293647 | 2293647 | 2022-03-10 | Maricao | Puerto Rico | 72093 | 549 | |
2225471 | 2225471 | 2022-02-17 | Faulk | South Dakota | 46049 | 549 | 16 |
2202040 | 2202040 | 2022-02-10 | De Baca | New Mexico | 35011 | 549 | 5 |
2188956 | 2188956 | 2022-02-06 | Sherman | Nebraska | 31163 | 549 | 4 |
2189697 | 2189697 | 2022-02-06 | Hand | South Dakota | 46059 | 549 | 8 |
2185703 | 2185703 | 2022-02-05 | Sherman | Nebraska | 31163 | 549 | 4 |
2186444 | 2186444 | 2022-02-05 | Hand | South Dakota | 46059 | 549 | 8 |
2186676 | 2186676 | 2022-02-05 | Hardeman | Texas | 48197 | 549 | 14 |
2182451 | 2182451 | 2022-02-04 | Sherman | Nebraska | 31163 | 549 | 4 |
2183192 | 2183192 | 2022-02-04 | Hand | South Dakota | 46059 | 549 | 8 |
2173462 | 2173462 | 2022-02-01 | Sanborn | South Dakota | 46111 | 549 | 5 |
2169715 | 2169715 | 2022-01-31 | Griggs | North Dakota | 38039 | 549 | 2 |
2163186 | 2163186 | 2022-01-29 | Adams | North Dakota | 38001 | 549 | 9 |
2146966 | 2146966 | 2022-01-24 | Towner | North Dakota | 38095 | 549 | 11 |
2143712 | 2143712 | 2022-01-23 | Towner | North Dakota | 38095 | 549 | 11 |
2134654 | 2134654 | 2022-01-20 | Kimble | Texas | 48267 | 549 | 12 |
2130705 | 2130705 | 2022-01-19 | Unknown | Northern Mariana Islands | 549 | 3 | |
2131402 | 2131402 | 2022-01-19 | Kimble | Texas | 48267 | 549 | 12 |
2110722 | 2110722 | 2022-01-13 | Scotland | Missouri | 29199 | 549 | 17 |
2085149 | 2085149 | 2022-01-05 | McIntosh | North Dakota | 38051 | 549 | 9 |
2041154 | 2041154 | 2021-12-23 | Ouray | Colorado | 8091 | 549 | 6 |
2013790 | 2013790 | 2021-12-14 | Harper | Oklahoma | 40059 | 549 | 10 |
2010539 | 2010539 | 2021-12-13 | Harper | Oklahoma | 40059 | 549 | 10 |
2007288 | 2007288 | 2021-12-12 | Harper | Oklahoma | 40059 | 549 | 10 |
2004037 | 2004037 | 2021-12-11 | Harper | Oklahoma | 40059 | 549 | 10 |
2000786 | 2000786 | 2021-12-10 | Harper | Oklahoma | 40059 | 549 | 10 |
2001439 | 2001439 | 2021-12-10 | Shackelford | Texas | 48417 | 549 | 7 |
1997381 | 1997381 | 2021-12-09 | Hettinger | North Dakota | 38041 | 549 | 7 |
1997536 | 1997536 | 2021-12-09 | Harper | Oklahoma | 40059 | 549 | 10 |
1994285 | 1994285 | 2021-12-08 | Harper | Oklahoma | 40059 | 549 | 10 |
1966662 | 1966662 | 2021-11-30 | Adams | Idaho | 16003 | 549 | 14 |
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);