ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
365 rows where cases = 1416 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 38
- Iowa 25
- Virginia 21
- Michigan 18
- Puerto Rico 18
- Indiana 17
- Kansas 17
- Georgia 14
- Minnesota 14
- Missouri 13
- Kentucky 11
- Alabama 10
- South Dakota 10
- Illinois 8
- Mississippi 8
- Nebraska 7
- New York 7
- North Dakota 7
- Florida 6
- Nevada 6
- Pennsylvania 6
- Tennessee 6
- West Virginia 6
- Wisconsin 6
- Colorado 5
- Idaho 5
- Louisiana 5
- Maryland 5
- North Carolina 5
- Ohio 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492327 | 2492327 | 2022-05-10 | Spink | South Dakota | 46115 | 1416 | 36 |
2489069 | 2489069 | 2022-05-09 | Spink | South Dakota | 46115 | 1416 | 36 |
2485812 | 2485812 | 2022-05-08 | Spink | South Dakota | 46115 | 1416 | 36 |
2482554 | 2482554 | 2022-05-07 | Spink | South Dakota | 46115 | 1416 | 36 |
2479296 | 2479296 | 2022-05-06 | Spink | South Dakota | 46115 | 1416 | 36 |
2476038 | 2476038 | 2022-05-05 | Spink | South Dakota | 46115 | 1416 | 36 |
2472781 | 2472781 | 2022-05-04 | Spink | South Dakota | 46115 | 1416 | 36 |
2420389 | 2420389 | 2022-04-18 | Unknown | Oklahoma | 1416 | 0 | |
2417134 | 2417134 | 2022-04-17 | Unknown | Oklahoma | 1416 | 0 | |
2413878 | 2413878 | 2022-04-16 | Unknown | Oklahoma | 1416 | 0 | |
2309303 | 2309303 | 2022-03-15 | Pershing | Nevada | 32027 | 1416 | 29 |
2306051 | 2306051 | 2022-03-14 | Pershing | Nevada | 32027 | 1416 | 29 |
2302800 | 2302800 | 2022-03-13 | Pershing | Nevada | 32027 | 1416 | 29 |
2299548 | 2299548 | 2022-03-12 | Pershing | Nevada | 32027 | 1416 | 29 |
2296296 | 2296296 | 2022-03-11 | Pershing | Nevada | 32027 | 1416 | 29 |
2293044 | 2293044 | 2022-03-10 | Pershing | Nevada | 32027 | 1416 | 29 |
2279783 | 2279783 | 2022-03-06 | Dade | Missouri | 29057 | 1416 | 40 |
2276530 | 2276530 | 2022-03-05 | Dade | Missouri | 29057 | 1416 | 40 |
2273277 | 2273277 | 2022-03-04 | Dade | Missouri | 29057 | 1416 | 40 |
2267609 | 2267609 | 2022-03-02 | Guanica | Puerto Rico | 72055 | 1416 | |
2246824 | 2246824 | 2022-02-24 | Menifee | Kentucky | 21165 | 1416 | 30 |
2243573 | 2243573 | 2022-02-23 | Menifee | Kentucky | 21165 | 1416 | 30 |
2230796 | 2230796 | 2022-02-19 | Oscoda | Michigan | 26135 | 1416 | 53 |
2227545 | 2227545 | 2022-02-18 | Oscoda | Michigan | 26135 | 1416 | 53 |
2223941 | 2223941 | 2022-02-17 | Mitchell | Kansas | 20123 | 1416 | 19 |
2224294 | 2224294 | 2022-02-17 | Oscoda | Michigan | 26135 | 1416 | 53 |
2220690 | 2220690 | 2022-02-16 | Mitchell | Kansas | 20123 | 1416 | 19 |
2221043 | 2221043 | 2022-02-16 | Oscoda | Michigan | 26135 | 1416 | 53 |
2197727 | 2197727 | 2022-02-09 | Ohio | Indiana | 18115 | 1416 | 17 |
2194473 | 2194473 | 2022-02-08 | Ohio | Indiana | 18115 | 1416 | 17 |
2193117 | 2193117 | 2022-02-07 | Carson | Texas | 48065 | 1416 | 31 |
2179131 | 2179131 | 2022-02-03 | Cedar | Nebraska | 31027 | 1416 | 11 |
2180240 | 2180240 | 2022-02-03 | Mills | Texas | 48333 | 1416 | 30 |
2171514 | 2171514 | 2022-02-01 | Caribou | Idaho | 16029 | 1416 | 25 |
2172959 | 2172959 | 2022-02-01 | Dickey | North Dakota | 38021 | 1416 | 38 |
2173687 | 2173687 | 2022-02-01 | Jack | Texas | 48237 | 1416 | 23 |
2166678 | 2166678 | 2022-01-30 | Harney | Oregon | 41025 | 1416 | 35 |
2163423 | 2163423 | 2022-01-29 | Harney | Oregon | 41025 | 1416 | 35 |
2160168 | 2160168 | 2022-01-28 | Harney | Oregon | 41025 | 1416 | 35 |
2151889 | 2151889 | 2022-01-26 | Jenkins | Georgia | 13165 | 1416 | 64 |
2153909 | 2153909 | 2022-01-26 | Hamlin | South Dakota | 46057 | 1416 | 40 |
2130160 | 2130160 | 2022-01-19 | Chariton | Missouri | 29041 | 1416 | 32 |
2123741 | 2123741 | 2022-01-17 | Sullivan | Missouri | 29211 | 1416 | 20 |
2120489 | 2120489 | 2022-01-16 | Sullivan | Missouri | 29211 | 1416 | 20 |
2117237 | 2117237 | 2022-01-15 | Sullivan | Missouri | 29211 | 1416 | 20 |
2102078 | 2102078 | 2022-01-10 | Floyd | Texas | 48153 | 1416 | 41 |
2099260 | 2099260 | 2022-01-09 | Pendleton | West Virginia | 54071 | 1416 | 16 |
2091161 | 2091161 | 2022-01-07 | Hickory | Missouri | 29085 | 1416 | 45 |
2083004 | 2083004 | 2022-01-04 | Pocahontas | West Virginia | 54075 | 1416 | 22 |
2057954 | 2057954 | 2021-12-28 | Ida | Iowa | 19093 | 1416 | 42 |
2054705 | 2054705 | 2021-12-27 | Ida | Iowa | 19093 | 1416 | 42 |
2051455 | 2051455 | 2021-12-26 | Ida | Iowa | 19093 | 1416 | 42 |
2048205 | 2048205 | 2021-12-25 | Ida | Iowa | 19093 | 1416 | 42 |
2044955 | 2044955 | 2021-12-24 | Ida | Iowa | 19093 | 1416 | 42 |
2040922 | 2040922 | 2021-12-23 | Sumter | Alabama | 1119 | 1416 | 42 |
2041706 | 2041706 | 2021-12-23 | Ida | Iowa | 19093 | 1416 | 42 |
2038456 | 2038456 | 2021-12-22 | Ida | Iowa | 19093 | 1416 | 42 |
2028144 | 2028144 | 2021-12-19 | Lincoln | Colorado | 8073 | 1416 | 8 |
2024893 | 2024893 | 2021-12-18 | Lincoln | Colorado | 8073 | 1416 | 8 |
2021642 | 2021642 | 2021-12-17 | Lincoln | Colorado | 8073 | 1416 | 8 |
2022898 | 2022898 | 2021-12-17 | Harrison | Missouri | 29081 | 1416 | 21 |
2010047 | 2010047 | 2021-12-13 | Cuming | Nebraska | 31039 | 1416 | 15 |
2006796 | 2006796 | 2021-12-12 | Cuming | Nebraska | 31039 | 1416 | 15 |
2003545 | 2003545 | 2021-12-11 | Cuming | Nebraska | 31039 | 1416 | 15 |
2000295 | 2000295 | 2021-12-10 | Cuming | Nebraska | 31039 | 1416 | 15 |
1952221 | 1952221 | 2021-11-25 | Lares | Puerto Rico | 72081 | 1416 | |
1923895 | 1923895 | 2021-11-17 | Perry | Alabama | 1105 | 1416 | 40 |
1926853 | 1926853 | 2021-11-17 | Nelson | Virginia | 51125 | 1416 | 19 |
1920646 | 1920646 | 2021-11-16 | Perry | Alabama | 1105 | 1416 | 40 |
1923072 | 1923072 | 2021-11-16 | Custer | South Dakota | 46033 | 1416 | 18 |
1915189 | 1915189 | 2021-11-14 | Owen | Kentucky | 21187 | 1416 | 26 |
1915747 | 1915747 | 2021-11-14 | Powell | Montana | 30077 | 1416 | 21 |
1911939 | 1911939 | 2021-11-13 | Owen | Kentucky | 21187 | 1416 | 26 |
1912497 | 1912497 | 2021-11-13 | Powell | Montana | 30077 | 1416 | 21 |
1908690 | 1908690 | 2021-11-12 | Owen | Kentucky | 21187 | 1416 | 26 |
1909247 | 1909247 | 2021-11-12 | Powell | Montana | 30077 | 1416 | 21 |
1901148 | 1901148 | 2021-11-10 | Perry | Alabama | 1105 | 1416 | 40 |
1904206 | 1904206 | 2021-11-10 | Gilmer | West Virginia | 54021 | 1416 | 14 |
1900956 | 1900956 | 2021-11-09 | Gilmer | West Virginia | 54021 | 1416 | 13 |
1895643 | 1895643 | 2021-11-08 | Hancock | Kentucky | 21091 | 1416 | 18 |
1875854 | 1875854 | 2021-11-02 | Martin | Indiana | 18101 | 1416 | 20 |
1873192 | 1873192 | 2021-11-01 | Clearwater | Minnesota | 27029 | 1416 | 18 |
1852648 | 1852648 | 2021-10-26 | Park | Colorado | 8093 | 1416 | 9 |
1855287 | 1855287 | 2021-10-26 | Amelia | Virginia | 51007 | 1416 | 40 |
1848210 | 1848210 | 2021-10-24 | Coamo | Puerto Rico | 72043 | 1416 | |
1844960 | 1844960 | 2021-10-23 | Coamo | Puerto Rico | 72043 | 1416 | |
1809460 | 1809460 | 2021-10-12 | Moore | Tennessee | 47127 | 1416 | 20 |
1802705 | 1802705 | 2021-10-10 | Anasco | Puerto Rico | 72011 | 1416 | |
1799456 | 1799456 | 2021-10-09 | Anasco | Puerto Rico | 72011 | 1416 | |
1795761 | 1795761 | 2021-10-08 | Schuyler | New York | 36097 | 1416 | 16 |
1796207 | 1796207 | 2021-10-08 | Anasco | Puerto Rico | 72011 | 1416 | |
1793458 | 1793458 | 2021-10-07 | Somervell | Texas | 48425 | 1416 | 21 |
1790209 | 1790209 | 2021-10-06 | Somervell | Texas | 48425 | 1416 | 21 |
1785512 | 1785512 | 2021-10-05 | Pope | Minnesota | 27121 | 1416 | 8 |
1786961 | 1786961 | 2021-10-05 | Somervell | Texas | 48425 | 1416 | 21 |
1762193 | 1762193 | 2021-09-28 | Chickasaw | Iowa | 19037 | 1416 | 18 |
1758648 | 1758648 | 2021-09-27 | Stewart | Georgia | 13259 | 1416 | 27 |
1758945 | 1758945 | 2021-09-27 | Chickasaw | Iowa | 19037 | 1416 | 18 |
1761103 | 1761103 | 2021-09-27 | Galax city | Virginia | 51640 | 1416 | 57 |
1755697 | 1755697 | 2021-09-26 | Chickasaw | Iowa | 19037 | 1416 | 18 |
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);