ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
530 rows where cases = 598 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 68
- Texas 51
- Virginia 31
- Georgia 22
- Kansas 21
- Minnesota 20
- Mississippi 20
- Nebraska 19
- South Dakota 18
- Puerto Rico 16
- Idaho 15
- Alabama 14
- Missouri 14
- Kentucky 13
- Oklahoma 13
- Tennessee 13
- Iowa 12
- Illinois 11
- Michigan 11
- Arkansas 9
- Indiana 9
- Louisiana 8
- Montana 8
- Ohio 8
- Colorado 7
- Florida 6
- Pennsylvania 6
- Wisconsin 6
- Wyoming 6
- California 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501586 | 2501586 | 2022-05-13 | Adams | North Dakota | 38001 | 598 | 10 |
2498328 | 2498328 | 2022-05-12 | Adams | North Dakota | 38001 | 598 | 10 |
2495070 | 2495070 | 2022-05-11 | Adams | North Dakota | 38001 | 598 | 10 |
2491812 | 2491812 | 2022-05-10 | Adams | North Dakota | 38001 | 598 | 10 |
2488554 | 2488554 | 2022-05-09 | Adams | North Dakota | 38001 | 598 | 10 |
2485297 | 2485297 | 2022-05-08 | Adams | North Dakota | 38001 | 598 | 10 |
2482039 | 2482039 | 2022-05-07 | Adams | North Dakota | 38001 | 598 | 10 |
2478781 | 2478781 | 2022-05-06 | Adams | North Dakota | 38001 | 598 | 10 |
2475523 | 2475523 | 2022-05-05 | Adams | North Dakota | 38001 | 598 | 10 |
2472266 | 2472266 | 2022-05-04 | Adams | North Dakota | 38001 | 598 | 10 |
2469010 | 2469010 | 2022-05-03 | Adams | North Dakota | 38001 | 598 | 10 |
2465754 | 2465754 | 2022-05-02 | Adams | North Dakota | 38001 | 598 | 10 |
2462499 | 2462499 | 2022-05-01 | Adams | North Dakota | 38001 | 598 | 10 |
2459243 | 2459243 | 2022-04-30 | Adams | North Dakota | 38001 | 598 | 10 |
2459618 | 2459618 | 2022-04-30 | Maricao | Puerto Rico | 72093 | 598 | |
2455987 | 2455987 | 2022-04-29 | Adams | North Dakota | 38001 | 598 | 10 |
2452731 | 2452731 | 2022-04-28 | Adams | North Dakota | 38001 | 598 | 10 |
2449475 | 2449475 | 2022-04-27 | Adams | North Dakota | 38001 | 598 | 10 |
2446218 | 2446218 | 2022-04-26 | Adams | North Dakota | 38001 | 598 | 10 |
2442963 | 2442963 | 2022-04-25 | Adams | North Dakota | 38001 | 598 | 10 |
2439707 | 2439707 | 2022-04-24 | Adams | North Dakota | 38001 | 598 | 10 |
2436451 | 2436451 | 2022-04-23 | Adams | North Dakota | 38001 | 598 | 10 |
2433195 | 2433195 | 2022-04-22 | Adams | North Dakota | 38001 | 598 | 10 |
2429939 | 2429939 | 2022-04-21 | Adams | North Dakota | 38001 | 598 | 10 |
2426683 | 2426683 | 2022-04-20 | Adams | North Dakota | 38001 | 598 | 10 |
2423427 | 2423427 | 2022-04-19 | Adams | North Dakota | 38001 | 598 | 10 |
2420170 | 2420170 | 2022-04-18 | Adams | North Dakota | 38001 | 598 | 10 |
2416915 | 2416915 | 2022-04-17 | Adams | North Dakota | 38001 | 598 | 10 |
2413659 | 2413659 | 2022-04-16 | Adams | North Dakota | 38001 | 598 | 10 |
2410403 | 2410403 | 2022-04-15 | Adams | North Dakota | 38001 | 598 | 10 |
2407147 | 2407147 | 2022-04-14 | Adams | North Dakota | 38001 | 598 | 10 |
2403891 | 2403891 | 2022-04-13 | Adams | North Dakota | 38001 | 598 | 10 |
2400636 | 2400636 | 2022-04-12 | Adams | North Dakota | 38001 | 598 | 10 |
2397381 | 2397381 | 2022-04-11 | Adams | North Dakota | 38001 | 598 | 10 |
2394126 | 2394126 | 2022-04-10 | Adams | North Dakota | 38001 | 598 | 10 |
2390870 | 2390870 | 2022-04-09 | Adams | North Dakota | 38001 | 598 | 10 |
2387614 | 2387614 | 2022-04-08 | Adams | North Dakota | 38001 | 598 | 10 |
2384359 | 2384359 | 2022-04-07 | Adams | North Dakota | 38001 | 598 | 10 |
2381104 | 2381104 | 2022-04-06 | Adams | North Dakota | 38001 | 598 | 10 |
2377849 | 2377849 | 2022-04-05 | Adams | North Dakota | 38001 | 598 | 10 |
2374596 | 2374596 | 2022-04-04 | Adams | North Dakota | 38001 | 598 | 10 |
2371344 | 2371344 | 2022-04-03 | Adams | North Dakota | 38001 | 598 | 10 |
2368091 | 2368091 | 2022-04-02 | Adams | North Dakota | 38001 | 598 | 10 |
2364838 | 2364838 | 2022-04-01 | Adams | North Dakota | 38001 | 598 | 10 |
2361584 | 2361584 | 2022-03-31 | Adams | North Dakota | 38001 | 598 | 10 |
2358330 | 2358330 | 2022-03-30 | Adams | North Dakota | 38001 | 598 | 10 |
2355076 | 2355076 | 2022-03-29 | Adams | North Dakota | 38001 | 598 | 10 |
2351823 | 2351823 | 2022-03-28 | Adams | North Dakota | 38001 | 598 | 10 |
2348571 | 2348571 | 2022-03-27 | Adams | North Dakota | 38001 | 598 | 10 |
2345318 | 2345318 | 2022-03-26 | Adams | North Dakota | 38001 | 598 | 10 |
2342065 | 2342065 | 2022-03-25 | Adams | North Dakota | 38001 | 598 | 10 |
2316038 | 2316038 | 2022-03-17 | Adams | North Dakota | 38001 | 598 | 10 |
2312785 | 2312785 | 2022-03-16 | Adams | North Dakota | 38001 | 598 | 10 |
2309532 | 2309532 | 2022-03-15 | Adams | North Dakota | 38001 | 598 | 10 |
2306279 | 2306279 | 2022-03-14 | Adams | North Dakota | 38001 | 598 | 10 |
2303028 | 2303028 | 2022-03-13 | Adams | North Dakota | 38001 | 598 | 10 |
2222434 | 2222434 | 2022-02-16 | Fisher | Texas | 48151 | 598 | 22 |
2219183 | 2219183 | 2022-02-15 | Fisher | Texas | 48151 | 598 | 22 |
2178364 | 2178364 | 2022-02-03 | Decatur | Kansas | 20039 | 598 | 17 |
2179500 | 2179500 | 2022-02-03 | Towner | North Dakota | 38095 | 598 | 12 |
2175111 | 2175111 | 2022-02-02 | Decatur | Kansas | 20039 | 598 | 17 |
2176970 | 2176970 | 2022-02-02 | Lipscomb | Texas | 48295 | 598 | 12 |
2171199 | 2171199 | 2022-02-01 | Costilla | Colorado | 8023 | 598 | 14 |
2171891 | 2171891 | 2022-02-01 | Lincoln | Kansas | 20105 | 598 | 8 |
2168638 | 2168638 | 2022-01-31 | Lincoln | Kansas | 20105 | 598 | 8 |
2170162 | 2170162 | 2022-01-31 | Buffalo | South Dakota | 46017 | 598 | 17 |
2156701 | 2156701 | 2022-01-27 | McIntosh | North Dakota | 38051 | 598 | 9 |
2097098 | 2097098 | 2022-01-09 | Rawlins | Kansas | 20153 | 598 | 8 |
2093846 | 2093846 | 2022-01-08 | Rawlins | Kansas | 20153 | 598 | 8 |
2090594 | 2090594 | 2022-01-07 | Rawlins | Kansas | 20153 | 598 | 8 |
2086619 | 2086619 | 2022-01-06 | Baca | Colorado | 8009 | 598 | 7 |
2080833 | 2080833 | 2022-01-04 | Osborne | Kansas | 20141 | 598 | 15 |
2077581 | 2077581 | 2022-01-03 | Osborne | Kansas | 20141 | 598 | 15 |
2035349 | 2035349 | 2021-12-21 | Sheridan | Kansas | 20179 | 598 | 16 |
2035417 | 2035417 | 2021-12-21 | Hickman | Kentucky | 21105 | 598 | 22 |
2032099 | 2032099 | 2021-12-20 | Sheridan | Kansas | 20179 | 598 | 16 |
2015152 | 2015152 | 2021-12-15 | Phillips | Colorado | 8095 | 598 | 15 |
2012201 | 2012201 | 2021-12-14 | Oneida | Idaho | 16071 | 598 | 10 |
2008950 | 2008950 | 2021-12-13 | Oneida | Idaho | 16071 | 598 | 10 |
2010020 | 2010020 | 2021-12-13 | Sweet Grass | Montana | 30097 | 598 | 8 |
2010995 | 2010995 | 2021-12-13 | Baylor | Texas | 48023 | 598 | 24 |
2005699 | 2005699 | 2021-12-12 | Oneida | Idaho | 16071 | 598 | 10 |
2007127 | 2007127 | 2021-12-12 | Emmons | North Dakota | 38029 | 598 | 16 |
2007744 | 2007744 | 2021-12-12 | Baylor | Texas | 48023 | 598 | 24 |
2002448 | 2002448 | 2021-12-11 | Oneida | Idaho | 16071 | 598 | 10 |
2003876 | 2003876 | 2021-12-11 | Emmons | North Dakota | 38029 | 598 | 16 |
2004493 | 2004493 | 2021-12-11 | Baylor | Texas | 48023 | 598 | 24 |
1999198 | 1999198 | 2021-12-10 | Oneida | Idaho | 16071 | 598 | 10 |
1995947 | 1995947 | 2021-12-09 | Oneida | Idaho | 16071 | 598 | 10 |
1997017 | 1997017 | 2021-12-09 | Sweet Grass | Montana | 30097 | 598 | 8 |
1993766 | 1993766 | 2021-12-08 | Sweet Grass | Montana | 30097 | 598 | 8 |
1987325 | 1987325 | 2021-12-06 | Kimball | Nebraska | 31105 | 598 | 9 |
1973280 | 1973280 | 2021-12-02 | Pope | Illinois | 17151 | 598 | 6 |
1951252 | 1951252 | 2021-11-25 | Traverse | Minnesota | 27155 | 598 | 6 |
1948001 | 1948001 | 2021-11-24 | Traverse | Minnesota | 27155 | 598 | 6 |
1900877 | 1900877 | 2021-11-09 | Rappahannock | Virginia | 51157 | 598 | 5 |
1897627 | 1897627 | 2021-11-08 | Rappahannock | Virginia | 51157 | 598 | 5 |
1864919 | 1864919 | 2021-10-29 | Reagan | Texas | 48383 | 598 | 10 |
1860865 | 1860865 | 2021-10-28 | Bowman | North Dakota | 38011 | 598 | 7 |
1861670 | 1861670 | 2021-10-28 | Reagan | Texas | 48383 | 598 | 10 |
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);