ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
239 rows where cases = 2328 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 34
- Kentucky 23
- Illinois 16
- Montana 14
- Texas 13
- Georgia 12
- Virginia 11
- Minnesota 9
- Indiana 8
- Iowa 8
- Mississippi 8
- Nebraska 8
- Alabama 7
- Wisconsin 6
- Kansas 5
- Missouri 5
- Washington 5
- Louisiana 4
- North Carolina 4
- North Dakota 4
- Ohio 4
- Puerto Rico 4
- New York 3
- Pennsylvania 3
- South Dakota 3
- West Virginia 3
- Colorado 2
- Idaho 2
- Maryland 2
- Wyoming 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2400367 | 2400367 | 2022-04-12 | Phelps | Nebraska | 31137 | 2328 | 12 |
2401228 | 2401228 | 2022-04-12 | Perry | Tennessee | 47135 | 2328 | 55 |
2397973 | 2397973 | 2022-04-11 | Perry | Tennessee | 47135 | 2328 | 55 |
2394718 | 2394718 | 2022-04-10 | Perry | Tennessee | 47135 | 2328 | 55 |
2391462 | 2391462 | 2022-04-09 | Perry | Tennessee | 47135 | 2328 | 55 |
2388206 | 2388206 | 2022-04-08 | Perry | Tennessee | 47135 | 2328 | 55 |
2384951 | 2384951 | 2022-04-07 | Perry | Tennessee | 47135 | 2328 | 55 |
2380489 | 2380489 | 2022-04-06 | Rock | Minnesota | 27133 | 2328 | 34 |
2381696 | 2381696 | 2022-04-06 | Perry | Tennessee | 47135 | 2328 | 55 |
2378441 | 2378441 | 2022-04-05 | Perry | Tennessee | 47135 | 2328 | 55 |
2375187 | 2375187 | 2022-04-04 | Perry | Tennessee | 47135 | 2328 | 55 |
2371935 | 2371935 | 2022-04-03 | Perry | Tennessee | 47135 | 2328 | 55 |
2368682 | 2368682 | 2022-04-02 | Perry | Tennessee | 47135 | 2328 | 55 |
2365429 | 2365429 | 2022-04-01 | Perry | Tennessee | 47135 | 2328 | 55 |
2361319 | 2361319 | 2022-03-31 | Red Willow | Nebraska | 31145 | 2328 | 20 |
2362176 | 2362176 | 2022-03-31 | Perry | Tennessee | 47135 | 2328 | 55 |
2358922 | 2358922 | 2022-03-30 | Perry | Tennessee | 47135 | 2328 | 55 |
2355668 | 2355668 | 2022-03-29 | Perry | Tennessee | 47135 | 2328 | 55 |
2351559 | 2351559 | 2022-03-28 | Red Willow | Nebraska | 31145 | 2328 | 20 |
2352415 | 2352415 | 2022-03-28 | Perry | Tennessee | 47135 | 2328 | 55 |
2349163 | 2349163 | 2022-03-27 | Perry | Tennessee | 47135 | 2328 | 55 |
2345910 | 2345910 | 2022-03-26 | Perry | Tennessee | 47135 | 2328 | 55 |
2342657 | 2342657 | 2022-03-25 | Perry | Tennessee | 47135 | 2328 | 55 |
2338430 | 2338430 | 2022-03-24 | Dawson | Montana | 30021 | 2328 | 56 |
2339404 | 2339404 | 2022-03-24 | Perry | Tennessee | 47135 | 2328 | 55 |
2335176 | 2335176 | 2022-03-23 | Dawson | Montana | 30021 | 2328 | 56 |
2336150 | 2336150 | 2022-03-23 | Perry | Tennessee | 47135 | 2328 | 55 |
2331922 | 2331922 | 2022-03-22 | Dawson | Montana | 30021 | 2328 | 56 |
2328669 | 2328669 | 2022-03-21 | Dawson | Montana | 30021 | 2328 | 56 |
2325417 | 2325417 | 2022-03-20 | Dawson | Montana | 30021 | 2328 | 56 |
2322163 | 2322163 | 2022-03-19 | Dawson | Montana | 30021 | 2328 | 56 |
2318909 | 2318909 | 2022-03-18 | Dawson | Montana | 30021 | 2328 | 56 |
2318961 | 2318961 | 2022-03-18 | Box Butte | Nebraska | 31013 | 2328 | 17 |
2315656 | 2315656 | 2022-03-17 | Dawson | Montana | 30021 | 2328 | 55 |
2315708 | 2315708 | 2022-03-17 | Box Butte | Nebraska | 31013 | 2328 | 17 |
2312403 | 2312403 | 2022-03-16 | Dawson | Montana | 30021 | 2328 | 55 |
2312455 | 2312455 | 2022-03-16 | Box Butte | Nebraska | 31013 | 2328 | 17 |
2309150 | 2309150 | 2022-03-15 | Dawson | Montana | 30021 | 2328 | 54 |
2290779 | 2290779 | 2022-03-09 | La Salle | Texas | 48283 | 2328 | 46 |
2284618 | 2284618 | 2022-03-07 | Clay | West Virginia | 54015 | 2328 | 36 |
2279328 | 2279328 | 2022-03-06 | Livingston | Kentucky | 21139 | 2328 | 58 |
2276075 | 2276075 | 2022-03-05 | Livingston | Kentucky | 21139 | 2328 | 58 |
2272822 | 2272822 | 2022-03-04 | Livingston | Kentucky | 21139 | 2328 | 58 |
2259345 | 2259345 | 2022-02-28 | Washington | Idaho | 16087 | 2328 | 56 |
2214858 | 2214858 | 2022-02-14 | Fergus | Montana | 30027 | 2328 | 52 |
2202581 | 2202581 | 2022-02-10 | Florida | Puerto Rico | 72054 | 2328 | |
2170741 | 2170741 | 2022-01-31 | Sussex | Virginia | 51183 | 2328 | 32 |
2166020 | 2166020 | 2022-01-30 | Ralls | Missouri | 29173 | 2328 | 19 |
2157559 | 2157559 | 2022-01-27 | Emery | Utah | 49015 | 2328 | 25 |
2132376 | 2132376 | 2022-01-20 | Long | Georgia | 13183 | 2328 | 29 |
2134839 | 2134839 | 2022-01-20 | Brunswick | Virginia | 51025 | 2328 | 37 |
2087788 | 2087788 | 2022-01-06 | Amite | Mississippi | 28005 | 2328 | 59 |
2061592 | 2061592 | 2021-12-29 | Dukes | Massachusetts | 25007 | 2328 | 0 |
2057610 | 2057610 | 2021-12-28 | Oglethorpe | Georgia | 13221 | 2328 | 43 |
2053202 | 2053202 | 2021-12-26 | Meigs | Tennessee | 47121 | 2328 | 43 |
2049952 | 2049952 | 2021-12-25 | Meigs | Tennessee | 47121 | 2328 | 43 |
2046702 | 2046702 | 2021-12-24 | Meigs | Tennessee | 47121 | 2328 | 43 |
2043452 | 2043452 | 2021-12-23 | Meigs | Tennessee | 47121 | 2328 | 43 |
2037894 | 2037894 | 2021-12-22 | Las Animas | Colorado | 8071 | 2328 | 30 |
2008143 | 2008143 | 2021-12-12 | Rockbridge | Virginia | 51163 | 2328 | 66 |
2004232 | 2004232 | 2021-12-11 | Las Piedras | Puerto Rico | 72085 | 2328 | |
2004892 | 2004892 | 2021-12-11 | Rockbridge | Virginia | 51163 | 2328 | 66 |
2000981 | 2000981 | 2021-12-10 | Las Piedras | Puerto Rico | 72085 | 2328 | |
2001641 | 2001641 | 2021-12-10 | Rockbridge | Virginia | 51163 | 2328 | 66 |
1990509 | 1990509 | 2021-12-07 | Roosevelt | Montana | 30085 | 2328 | 61 |
1983464 | 1983464 | 2021-12-05 | Trigg | Kentucky | 21221 | 2328 | 25 |
1980214 | 1980214 | 2021-12-04 | Trigg | Kentucky | 21221 | 2328 | 25 |
1976964 | 1976964 | 2021-12-03 | Trigg | Kentucky | 21221 | 2328 | 25 |
1972584 | 1972584 | 2021-12-01 | Converse | Wyoming | 56009 | 2328 | 42 |
1924424 | 1924424 | 2021-11-17 | Gooding | Idaho | 16047 | 2328 | 42 |
1922217 | 1922217 | 2021-11-16 | Custer | Montana | 30017 | 2328 | 37 |
1919385 | 1919385 | 2021-11-15 | Ramsey | North Dakota | 38071 | 2328 | 38 |
1920285 | 1920285 | 2021-11-15 | Bristol city | Virginia | 51520 | 2328 | 48 |
1916135 | 1916135 | 2021-11-14 | Ramsey | North Dakota | 38071 | 2328 | 38 |
1890390 | 1890390 | 2021-11-06 | Fulton | Pennsylvania | 42057 | 2328 | 32 |
1881492 | 1881492 | 2021-11-03 | Taylor | West Virginia | 54091 | 2328 | 38 |
1871235 | 1871235 | 2021-10-31 | Bandera | Texas | 48019 | 2328 | 54 |
1867986 | 1867986 | 2021-10-30 | Bandera | Texas | 48019 | 2328 | 54 |
1864737 | 1864737 | 2021-10-29 | Bandera | Texas | 48019 | 2328 | 54 |
1859970 | 1859970 | 2021-10-28 | Washington | Kentucky | 21229 | 2328 | 46 |
1860886 | 1860886 | 2021-10-28 | McKenzie | North Dakota | 38053 | 2328 | 21 |
1861488 | 1861488 | 2021-10-28 | Bandera | Texas | 48019 | 2328 | 54 |
1862019 | 1862019 | 2021-10-28 | Crawford | Wisconsin | 55023 | 2328 | 22 |
1847747 | 1847747 | 2021-10-24 | Schoharie | New York | 36095 | 2328 | 22 |
1827857 | 1827857 | 2021-10-18 | Yalobusha | Mississippi | 28161 | 2328 | 47 |
1816298 | 1816298 | 2021-10-14 | Appomattox | Virginia | 51011 | 2328 | 36 |
1804678 | 1804678 | 2021-10-11 | Knott | Kentucky | 21119 | 2328 | 36 |
1792223 | 1792223 | 2021-10-07 | Ste. Genevieve | Missouri | 29186 | 2328 | 29 |
1789885 | 1789885 | 2021-10-06 | Oglala Lakota | South Dakota | 46102 | 2328 | 52 |
1735897 | 1735897 | 2021-09-20 | Rabun | Georgia | 13241 | 2328 | 54 |
1735293 | 1735293 | 2021-09-19 | Adams | Wisconsin | 55001 | 2328 | 28 |
1732043 | 1732043 | 2021-09-18 | Adams | Wisconsin | 55001 | 2328 | 28 |
1728793 | 1728793 | 2021-09-17 | Adams | Wisconsin | 55001 | 2328 | 28 |
1723117 | 1723117 | 2021-09-16 | Franklin | Indiana | 18047 | 2328 | 38 |
1719533 | 1719533 | 2021-09-15 | Bacon | Georgia | 13005 | 2328 | 49 |
1688731 | 1688731 | 2021-09-05 | Carroll | Ohio | 39019 | 2328 | 49 |
1682541 | 1682541 | 2021-09-03 | Moca | Puerto Rico | 72099 | 2328 | |
1627036 | 1627036 | 2021-08-17 | Hocking | Ohio | 39073 | 2328 | 63 |
1606949 | 1606949 | 2021-08-11 | Andrew | Missouri | 29003 | 2328 | 22 |
1589018 | 1589018 | 2021-08-05 | Adams | Washington | 53001 | 2328 | 24 |
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);