ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
494 rows where cases = 727 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 50
- Georgia 44
- Texas 31
- Missouri 29
- Virginia 25
- Nebraska 22
- Montana 19
- Kansas 17
- Kentucky 17
- South Dakota 17
- Puerto Rico 14
- Arkansas 13
- Minnesota 13
- Oklahoma 13
- Iowa 12
- Michigan 12
- California 11
- Indiana 11
- New Mexico 11
- Tennessee 10
- Illinois 9
- Mississippi 9
- North Carolina 9
- West Virginia 9
- Colorado 8
- Florida 8
- Alaska 6
- Idaho 6
- Ohio 6
- Louisiana 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2452745 | 2452745 | 2022-04-28 | Emmons | North Dakota | 38029 | 727 | 18 |
2449489 | 2449489 | 2022-04-27 | Emmons | North Dakota | 38029 | 727 | 18 |
2446232 | 2446232 | 2022-04-26 | Emmons | North Dakota | 38029 | 727 | 18 |
2442977 | 2442977 | 2022-04-25 | Emmons | North Dakota | 38029 | 727 | 18 |
2439721 | 2439721 | 2022-04-24 | Emmons | North Dakota | 38029 | 727 | 18 |
2436465 | 2436465 | 2022-04-23 | Emmons | North Dakota | 38029 | 727 | 18 |
2433209 | 2433209 | 2022-04-22 | Emmons | North Dakota | 38029 | 727 | 18 |
2429953 | 2429953 | 2022-04-21 | Emmons | North Dakota | 38029 | 727 | 18 |
2426697 | 2426697 | 2022-04-20 | Emmons | North Dakota | 38029 | 727 | 18 |
2423441 | 2423441 | 2022-04-19 | Emmons | North Dakota | 38029 | 727 | 18 |
2420184 | 2420184 | 2022-04-18 | Emmons | North Dakota | 38029 | 727 | 18 |
2416929 | 2416929 | 2022-04-17 | Emmons | North Dakota | 38029 | 727 | 18 |
2413673 | 2413673 | 2022-04-16 | Emmons | North Dakota | 38029 | 727 | 18 |
2410417 | 2410417 | 2022-04-15 | Emmons | North Dakota | 38029 | 727 | 18 |
2407161 | 2407161 | 2022-04-14 | Emmons | North Dakota | 38029 | 727 | 18 |
2403905 | 2403905 | 2022-04-13 | Emmons | North Dakota | 38029 | 727 | 18 |
2400650 | 2400650 | 2022-04-12 | Emmons | North Dakota | 38029 | 727 | 18 |
2397395 | 2397395 | 2022-04-11 | Emmons | North Dakota | 38029 | 727 | 18 |
2394140 | 2394140 | 2022-04-10 | Emmons | North Dakota | 38029 | 727 | 18 |
2390884 | 2390884 | 2022-04-09 | Emmons | North Dakota | 38029 | 727 | 18 |
2387628 | 2387628 | 2022-04-08 | Emmons | North Dakota | 38029 | 727 | 18 |
2331889 | 2331889 | 2022-03-22 | Schuyler | Missouri | 29197 | 727 | 26 |
2312799 | 2312799 | 2022-03-16 | Emmons | North Dakota | 38029 | 727 | 18 |
2309546 | 2309546 | 2022-03-15 | Emmons | North Dakota | 38029 | 727 | 18 |
2306293 | 2306293 | 2022-03-14 | Emmons | North Dakota | 38029 | 727 | 18 |
2303042 | 2303042 | 2022-03-13 | Emmons | North Dakota | 38029 | 727 | 18 |
2299790 | 2299790 | 2022-03-12 | Emmons | North Dakota | 38029 | 727 | 18 |
2286782 | 2286782 | 2022-03-08 | Emmons | North Dakota | 38029 | 727 | 18 |
2283530 | 2283530 | 2022-03-07 | Emmons | North Dakota | 38029 | 727 | 18 |
2280278 | 2280278 | 2022-03-06 | Emmons | North Dakota | 38029 | 727 | 18 |
2277025 | 2277025 | 2022-03-05 | Emmons | North Dakota | 38029 | 727 | 18 |
2273772 | 2273772 | 2022-03-04 | Emmons | North Dakota | 38029 | 727 | 18 |
2211344 | 2211344 | 2022-02-13 | Lake of the Woods | Minnesota | 27077 | 727 | 5 |
2208091 | 2208091 | 2022-02-12 | Lake of the Woods | Minnesota | 27077 | 727 | 5 |
2204838 | 2204838 | 2022-02-11 | Lake of the Woods | Minnesota | 27077 | 727 | 5 |
2201585 | 2201585 | 2022-02-10 | Lake of the Woods | Minnesota | 27077 | 727 | 5 |
2150641 | 2150641 | 2022-01-25 | Clark | South Dakota | 46025 | 727 | 6 |
2137786 | 2137786 | 2022-01-21 | Baylor | Texas | 48023 | 727 | 26 |
2133906 | 2133906 | 2022-01-20 | Bowman | North Dakota | 38011 | 727 | 9 |
2076935 | 2076935 | 2022-01-03 | Unknown | Delaware | 727 | 0 | |
2079280 | 2079280 | 2022-01-03 | Coke | Texas | 48081 | 727 | 18 |
2068882 | 2068882 | 2021-12-31 | Foster | North Dakota | 38031 | 727 | 19 |
2065631 | 2065631 | 2021-12-30 | Foster | North Dakota | 38031 | 727 | 19 |
2062381 | 2062381 | 2021-12-29 | Foster | North Dakota | 38031 | 727 | 19 |
2063050 | 2063050 | 2021-12-29 | Donley | Texas | 48129 | 727 | 18 |
2059132 | 2059132 | 2021-12-28 | Foster | North Dakota | 38031 | 727 | 19 |
2031749 | 2031749 | 2021-12-20 | Hardin | Illinois | 17069 | 727 | 16 |
2029171 | 2029171 | 2021-12-19 | Ontonagon | Michigan | 26131 | 727 | 26 |
2025920 | 2025920 | 2021-12-18 | Ontonagon | Michigan | 26131 | 727 | 26 |
2022669 | 2022669 | 2021-12-17 | Ontonagon | Michigan | 26131 | 727 | 26 |
1991331 | 1991331 | 2021-12-07 | Corson | South Dakota | 46031 | 727 | 14 |
1944031 | 1944031 | 2021-11-23 | Scott | Illinois | 17171 | 727 | 7 |
1946295 | 1946295 | 2021-11-23 | Charles City | Virginia | 51036 | 727 | 21 |
1940656 | 1940656 | 2021-11-22 | Bear Lake | Idaho | 16007 | 727 | 14 |
1941100 | 1941100 | 2021-11-22 | Ballard | Kentucky | 21007 | 727 | 21 |
1928793 | 1928793 | 2021-11-18 | Fillmore | Nebraska | 31059 | 727 | 13 |
1928812 | 1928812 | 2021-11-18 | Johnson | Nebraska | 31097 | 727 | 10 |
1915594 | 1915594 | 2021-11-14 | Atchison | Missouri | 29005 | 727 | 7 |
1915739 | 1915739 | 2021-11-14 | Mineral | Montana | 30061 | 727 | 13 |
1917053 | 1917053 | 2021-11-14 | Cumberland | Virginia | 51049 | 727 | 18 |
1912344 | 1912344 | 2021-11-13 | Atchison | Missouri | 29005 | 727 | 7 |
1912489 | 1912489 | 2021-11-13 | Mineral | Montana | 30061 | 727 | 13 |
1913803 | 1913803 | 2021-11-13 | Cumberland | Virginia | 51049 | 727 | 18 |
1909239 | 1909239 | 2021-11-12 | Mineral | Montana | 30061 | 727 | 13 |
1910553 | 1910553 | 2021-11-12 | Cumberland | Virginia | 51049 | 727 | 18 |
1905990 | 1905990 | 2021-11-11 | Mineral | Montana | 30061 | 727 | 13 |
1902741 | 1902741 | 2021-11-10 | Mineral | Montana | 30061 | 727 | 13 |
1893835 | 1893835 | 2021-11-07 | Gregory | South Dakota | 46053 | 727 | 30 |
1890585 | 1890585 | 2021-11-06 | Gregory | South Dakota | 46053 | 727 | 30 |
1887335 | 1887335 | 2021-11-05 | Gregory | South Dakota | 46053 | 727 | 30 |
1858109 | 1858109 | 2021-10-27 | Lyman | South Dakota | 46085 | 727 | 11 |
1823632 | 1823632 | 2021-10-17 | Talbot | Georgia | 13263 | 727 | 25 |
1820383 | 1820383 | 2021-10-16 | Talbot | Georgia | 13263 | 727 | 25 |
1817134 | 1817134 | 2021-10-15 | Talbot | Georgia | 13263 | 727 | 25 |
1792661 | 1792661 | 2021-10-07 | Pierce | North Dakota | 38069 | 727 | 27 |
1782615 | 1782615 | 2021-10-04 | Pierce | Nebraska | 31139 | 727 | 21 |
1764244 | 1764244 | 2021-09-28 | Wheeler | Texas | 48483 | 727 | 12 |
1738648 | 1738648 | 2021-09-21 | Choctaw | Alabama | 1023 | 727 | 25 |
1738876 | 1738876 | 2021-09-21 | Trinity | California | 6105 | 727 | 7 |
1740450 | 1740450 | 2021-09-21 | Unknown | New Jersey | 727 | 0 | |
1737900 | 1737900 | 2021-09-20 | Moody | South Dakota | 46101 | 727 | 20 |
1733098 | 1733098 | 2021-09-19 | Morris | Kansas | 20127 | 727 | 23 |
1729848 | 1729848 | 2021-09-18 | Morris | Kansas | 20127 | 727 | 23 |
1726598 | 1726598 | 2021-09-17 | Morris | Kansas | 20127 | 727 | 23 |
1724181 | 1724181 | 2021-09-16 | Unknown | New Hampshire | 727 | 1 | |
1711446 | 1711446 | 2021-09-12 | Sioux | North Dakota | 38085 | 727 | 14 |
1712075 | 1712075 | 2021-09-12 | Crockett | Texas | 48105 | 727 | 15 |
1695199 | 1695199 | 2021-09-07 | Ransom | North Dakota | 38073 | 727 | 17 |
1680016 | 1680016 | 2021-09-02 | Doddridge | West Virginia | 54017 | 727 | 6 |
1667314 | 1667314 | 2021-08-30 | Lafayette | Arkansas | 5073 | 727 | 11 |
1669646 | 1669646 | 2021-08-30 | Day | South Dakota | 46037 | 727 | 30 |
1646900 | 1646900 | 2021-08-23 | Brule | South Dakota | 46015 | 727 | 11 |
1643651 | 1643651 | 2021-08-22 | Brule | South Dakota | 46015 | 727 | 11 |
1640401 | 1640401 | 2021-08-21 | Brule | South Dakota | 46015 | 727 | 11 |
1637151 | 1637151 | 2021-08-20 | Brule | South Dakota | 46015 | 727 | 11 |
1628810 | 1628810 | 2021-08-18 | Edwards | Illinois | 17047 | 727 | 14 |
1623349 | 1623349 | 2021-08-16 | Sanders | Montana | 30089 | 727 | 15 |
1624470 | 1624470 | 2021-08-16 | Marion | Texas | 48315 | 727 | 34 |
1621223 | 1621223 | 2021-08-15 | Marion | Texas | 48315 | 727 | 34 |
1596214 | 1596214 | 2021-08-08 | Randolph | Georgia | 13243 | 727 | 34 |
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);