ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
518 rows where cases = 771 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 62
- Georgia 38
- Iowa 29
- Virginia 26
- Nebraska 25
- Kansas 23
- Missouri 20
- Kentucky 18
- North Carolina 16
- South Dakota 16
- Oklahoma 15
- Puerto Rico 15
- Illinois 14
- Michigan 14
- Mississippi 13
- Montana 13
- Ohio 13
- Arkansas 11
- Minnesota 10
- North Dakota 10
- Oregon 10
- Alabama 9
- Louisiana 9
- Colorado 8
- Idaho 8
- Indiana 8
- Virgin Islands 7
- Wyoming 7
- Tennessee 6
- Wisconsin 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491638 | 2491638 | 2022-05-10 | Mora | New Mexico | 35033 | 771 | 18 |
2488380 | 2488380 | 2022-05-09 | Mora | New Mexico | 35033 | 771 | 18 |
2472435 | 2472435 | 2022-05-04 | Ellis | Oklahoma | 40045 | 771 | 8 |
2469179 | 2469179 | 2022-05-03 | Ellis | Oklahoma | 40045 | 771 | 8 |
2465923 | 2465923 | 2022-05-02 | Ellis | Oklahoma | 40045 | 771 | 8 |
2462668 | 2462668 | 2022-05-01 | Ellis | Oklahoma | 40045 | 771 | 8 |
2459412 | 2459412 | 2022-04-30 | Ellis | Oklahoma | 40045 | 771 | 8 |
2456156 | 2456156 | 2022-04-29 | Ellis | Oklahoma | 40045 | 771 | 8 |
2452900 | 2452900 | 2022-04-28 | Ellis | Oklahoma | 40045 | 771 | 8 |
2338468 | 2338468 | 2022-03-24 | Sweet Grass | Montana | 30097 | 771 | 11 |
2335214 | 2335214 | 2022-03-23 | Sweet Grass | Montana | 30097 | 771 | 11 |
2331960 | 2331960 | 2022-03-22 | Sweet Grass | Montana | 30097 | 771 | 11 |
2328707 | 2328707 | 2022-03-21 | Sweet Grass | Montana | 30097 | 771 | 11 |
2325455 | 2325455 | 2022-03-20 | Sweet Grass | Montana | 30097 | 771 | 11 |
2322201 | 2322201 | 2022-03-19 | Sweet Grass | Montana | 30097 | 771 | 11 |
2318947 | 2318947 | 2022-03-18 | Sweet Grass | Montana | 30097 | 771 | 11 |
2315694 | 2315694 | 2022-03-17 | Sweet Grass | Montana | 30097 | 771 | 11 |
2312441 | 2312441 | 2022-03-16 | Sweet Grass | Montana | 30097 | 771 | 11 |
2307200 | 2307200 | 2022-03-14 | St. John | Virgin Islands | 78020 | 771 | 5 |
2303949 | 2303949 | 2022-03-13 | St. John | Virgin Islands | 78020 | 771 | 5 |
2300697 | 2300697 | 2022-03-12 | St. John | Virgin Islands | 78020 | 771 | 5 |
2297445 | 2297445 | 2022-03-11 | St. John | Virgin Islands | 78020 | 771 | 5 |
2238770 | 2238770 | 2022-02-21 | Mason | Texas | 48319 | 771 | 11 |
2235519 | 2235519 | 2022-02-20 | Mason | Texas | 48319 | 771 | 11 |
2232268 | 2232268 | 2022-02-19 | Mason | Texas | 48319 | 771 | 11 |
2229017 | 2229017 | 2022-02-18 | Mason | Texas | 48319 | 771 | 11 |
2194675 | 2194675 | 2022-02-08 | Ness | Kansas | 20135 | 771 | 18 |
2191421 | 2191421 | 2022-02-07 | Ness | Kansas | 20135 | 771 | 18 |
2188132 | 2188132 | 2022-02-06 | Gove | Kansas | 20063 | 771 | 23 |
2188190 | 2188190 | 2022-02-06 | Sheridan | Kansas | 20179 | 771 | 18 |
2184879 | 2184879 | 2022-02-05 | Gove | Kansas | 20063 | 771 | 23 |
2184937 | 2184937 | 2022-02-05 | Sheridan | Kansas | 20179 | 771 | 18 |
2181627 | 2181627 | 2022-02-04 | Gove | Kansas | 20063 | 771 | 23 |
2181685 | 2181685 | 2022-02-04 | Sheridan | Kansas | 20179 | 771 | 18 |
2171032 | 2171032 | 2022-02-01 | Unknown | Alaska | 771 | 1 | |
2173800 | 2173800 | 2022-02-01 | Upton | Texas | 48461 | 771 | 17 |
2167779 | 2167779 | 2022-01-31 | Unknown | Alaska | 771 | 1 | |
2150983 | 2150983 | 2022-01-25 | Reagan | Texas | 48383 | 771 | 11 |
2084765 | 2084765 | 2022-01-05 | Musselshell | Montana | 30065 | 771 | 26 |
2080887 | 2080887 | 2022-01-04 | Carlisle | Kentucky | 21039 | 771 | 14 |
2081513 | 2081513 | 2022-01-04 | Musselshell | Montana | 30065 | 771 | 26 |
2082344 | 2082344 | 2022-01-04 | Corson | South Dakota | 46031 | 771 | 15 |
2077635 | 2077635 | 2022-01-03 | Carlisle | Kentucky | 21039 | 771 | 14 |
2079572 | 2079572 | 2022-01-03 | Craig | Virginia | 51045 | 771 | 11 |
2055908 | 2055908 | 2021-12-27 | Sargent | North Dakota | 38081 | 771 | 9 |
2052658 | 2052658 | 2021-12-26 | Sargent | North Dakota | 38081 | 771 | 9 |
2053285 | 2053285 | 2021-12-26 | Concho | Texas | 48095 | 771 | 10 |
2049390 | 2049390 | 2021-12-25 | LaMoure | North Dakota | 38045 | 771 | 18 |
2049408 | 2049408 | 2021-12-25 | Sargent | North Dakota | 38081 | 771 | 9 |
2050035 | 2050035 | 2021-12-25 | Concho | Texas | 48095 | 771 | 10 |
2046140 | 2046140 | 2021-12-24 | LaMoure | North Dakota | 38045 | 771 | 18 |
2046158 | 2046158 | 2021-12-24 | Sargent | North Dakota | 38081 | 771 | 9 |
2046445 | 2046445 | 2021-12-24 | Adjuntas | Puerto Rico | 72001 | 771 | |
2046785 | 2046785 | 2021-12-24 | Concho | Texas | 48095 | 771 | 10 |
2043195 | 2043195 | 2021-12-23 | Adjuntas | Puerto Rico | 72001 | 771 | |
2043535 | 2043535 | 2021-12-23 | Concho | Texas | 48095 | 771 | 10 |
2039659 | 2039659 | 2021-12-22 | Sargent | North Dakota | 38081 | 771 | 9 |
2036409 | 2036409 | 2021-12-21 | Sargent | North Dakota | 38081 | 771 | 9 |
2033374 | 2033374 | 2021-12-20 | Wallowa | Oregon | 41063 | 771 | 13 |
2030124 | 2030124 | 2021-12-19 | Wallowa | Oregon | 41063 | 771 | 13 |
2026873 | 2026873 | 2021-12-18 | Wallowa | Oregon | 41063 | 771 | 13 |
2023622 | 2023622 | 2021-12-17 | Wallowa | Oregon | 41063 | 771 | 13 |
1974357 | 1974357 | 2021-12-02 | Thayer | Nebraska | 31169 | 771 | 8 |
1961272 | 1961272 | 2021-11-28 | Antelope | Nebraska | 31003 | 771 | 10 |
1958021 | 1958021 | 2021-11-27 | Antelope | Nebraska | 31003 | 771 | 10 |
1954770 | 1954770 | 2021-11-26 | Antelope | Nebraska | 31003 | 771 | 10 |
1951519 | 1951519 | 2021-11-25 | Antelope | Nebraska | 31003 | 771 | 10 |
1948268 | 1948268 | 2021-11-24 | Antelope | Nebraska | 31003 | 771 | 10 |
1945017 | 1945017 | 2021-11-23 | Antelope | Nebraska | 31003 | 771 | 10 |
1942961 | 1942961 | 2021-11-22 | Wheeler | Texas | 48483 | 771 | 14 |
1937385 | 1937385 | 2021-11-21 | Warren | Georgia | 13301 | 771 | 26 |
1939711 | 1939711 | 2021-11-21 | Wheeler | Texas | 48483 | 771 | 14 |
1934135 | 1934135 | 2021-11-20 | Warren | Georgia | 13301 | 771 | 26 |
1935094 | 1935094 | 2021-11-20 | Atchison | Missouri | 29005 | 771 | 16 |
1936461 | 1936461 | 2021-11-20 | Wheeler | Texas | 48483 | 771 | 14 |
1930883 | 1930883 | 2021-11-19 | Warren | Georgia | 13301 | 771 | 26 |
1931844 | 1931844 | 2021-11-19 | Atchison | Missouri | 29005 | 771 | 16 |
1933211 | 1933211 | 2021-11-19 | Wheeler | Texas | 48483 | 771 | 14 |
1928593 | 1928593 | 2021-11-18 | Atchison | Missouri | 29005 | 771 | 16 |
1930049 | 1930049 | 2021-11-18 | Covington city | Virginia | 51580 | 771 | 18 |
1919849 | 1919849 | 2021-11-15 | Lyman | South Dakota | 46085 | 771 | 11 |
1904440 | 1904440 | 2021-11-11 | Yukon-Koyukuk Census Area | Alaska | 2290 | 771 | 7 |
1901190 | 1901190 | 2021-11-10 | Yukon-Koyukuk Census Area | Alaska | 2290 | 771 | 7 |
1890490 | 1890490 | 2021-11-06 | Sabana Grande | Puerto Rico | 72121 | 771 | |
1887240 | 1887240 | 2021-11-05 | Sabana Grande | Puerto Rico | 72121 | 771 | |
1869640 | 1869640 | 2021-10-31 | Fulton | Kentucky | 21075 | 771 | 16 |
1866391 | 1866391 | 2021-10-30 | Fulton | Kentucky | 21075 | 771 | 16 |
1863142 | 1863142 | 2021-10-29 | Fulton | Kentucky | 21075 | 771 | 16 |
1853314 | 1853314 | 2021-10-26 | Mitchell | Kansas | 20123 | 771 | 16 |
1850065 | 1850065 | 2021-10-25 | Mitchell | Kansas | 20123 | 771 | 16 |
1835516 | 1835516 | 2021-10-20 | Carson | Texas | 48065 | 771 | 24 |
1824099 | 1824099 | 2021-10-17 | Sherman | Kansas | 20181 | 771 | 13 |
1824109 | 1824109 | 2021-10-17 | Washington | Kansas | 20201 | 771 | 15 |
1824885 | 1824885 | 2021-10-17 | Lander | Nevada | 32015 | 771 | 14 |
1820850 | 1820850 | 2021-10-16 | Sherman | Kansas | 20181 | 771 | 13 |
1820860 | 1820860 | 2021-10-16 | Washington | Kansas | 20201 | 771 | 15 |
1821636 | 1821636 | 2021-10-16 | Lander | Nevada | 32015 | 771 | 14 |
1817601 | 1817601 | 2021-10-15 | Sherman | Kansas | 20181 | 771 | 13 |
1817611 | 1817611 | 2021-10-15 | Washington | Kansas | 20201 | 771 | 15 |
1818387 | 1818387 | 2021-10-15 | Lander | Nevada | 32015 | 771 | 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);