ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
494 rows where cases = 739 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 62
- Michigan 36
- Georgia 34
- Nebraska 26
- Missouri 22
- Kansas 21
- Kentucky 19
- Virginia 19
- Arkansas 18
- Iowa 17
- Mississippi 17
- North Carolina 14
- Oklahoma 14
- South Dakota 13
- Illinois 12
- Puerto Rico 12
- Colorado 11
- Louisiana 11
- Minnesota 11
- Utah 10
- Idaho 9
- West Virginia 9
- Indiana 7
- Ohio 7
- South Carolina 7
- Tennessee 7
- New York 5
- Wyoming 5
- Alabama 4
- Florida 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497912 | 2497912 | 2022-05-12 | Schuyler | Missouri | 29197 | 739 | 26 |
2494654 | 2494654 | 2022-05-11 | Schuyler | Missouri | 29197 | 739 | 26 |
2491396 | 2491396 | 2022-05-10 | Schuyler | Missouri | 29197 | 739 | 26 |
2488138 | 2488138 | 2022-05-09 | Schuyler | Missouri | 29197 | 739 | 26 |
2484881 | 2484881 | 2022-05-08 | Schuyler | Missouri | 29197 | 739 | 26 |
2481623 | 2481623 | 2022-05-07 | Schuyler | Missouri | 29197 | 739 | 26 |
2478365 | 2478365 | 2022-05-06 | Schuyler | Missouri | 29197 | 739 | 26 |
2391626 | 2391626 | 2022-04-09 | Kinney | Texas | 48271 | 739 | 10 |
2388370 | 2388370 | 2022-04-08 | Kinney | Texas | 48271 | 739 | 10 |
2309210 | 2309210 | 2022-03-15 | Chase | Nebraska | 31029 | 739 | 6 |
2283195 | 2283195 | 2022-03-07 | Chase | Nebraska | 31029 | 739 | 6 |
2279942 | 2279942 | 2022-03-06 | Chase | Nebraska | 31029 | 739 | 6 |
2276689 | 2276689 | 2022-03-05 | Chase | Nebraska | 31029 | 739 | 6 |
2273436 | 2273436 | 2022-03-04 | Chase | Nebraska | 31029 | 739 | 6 |
2237353 | 2237353 | 2022-02-21 | Lake of the Woods | Minnesota | 27077 | 739 | 5 |
2234102 | 2234102 | 2022-02-20 | Lake of the Woods | Minnesota | 27077 | 739 | 5 |
2230851 | 2230851 | 2022-02-19 | Lake of the Woods | Minnesota | 27077 | 739 | 5 |
2227600 | 2227600 | 2022-02-18 | Lake of the Woods | Minnesota | 27077 | 739 | 5 |
2171013 | 2171013 | 2022-02-01 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 739 | 1 |
2171740 | 2171740 | 2022-02-01 | Adams | Iowa | 19003 | 739 | 12 |
2167760 | 2167760 | 2022-01-31 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 739 | 1 |
2168487 | 2168487 | 2022-01-31 | Adams | Iowa | 19003 | 739 | 12 |
2165232 | 2165232 | 2022-01-30 | Adams | Iowa | 19003 | 739 | 12 |
2161977 | 2161977 | 2022-01-29 | Adams | Iowa | 19003 | 739 | 12 |
2158722 | 2158722 | 2022-01-28 | Adams | Iowa | 19003 | 739 | 12 |
2155468 | 2155468 | 2022-01-27 | Adams | Iowa | 19003 | 739 | 12 |
2152215 | 2152215 | 2022-01-26 | Adams | Iowa | 19003 | 739 | 12 |
2140415 | 2140415 | 2022-01-22 | Bowman | North Dakota | 38011 | 739 | 9 |
2122253 | 2122253 | 2022-01-17 | Calhoun | Arkansas | 5013 | 739 | 9 |
2079304 | 2079304 | 2022-01-03 | Donley | Texas | 48129 | 739 | 18 |
2066498 | 2066498 | 2021-12-30 | Garfield | Utah | 49017 | 739 | 12 |
2063248 | 2063248 | 2021-12-29 | Garfield | Utah | 49017 | 739 | 12 |
2058957 | 2058957 | 2021-12-28 | Union | New Mexico | 35059 | 739 | 12 |
2060126 | 2060126 | 2021-12-28 | Norton city | Virginia | 51720 | 739 | 20 |
2054302 | 2054302 | 2021-12-27 | Echols | Georgia | 13101 | 739 | 11 |
2051052 | 2051052 | 2021-12-26 | Echols | Georgia | 13101 | 739 | 11 |
2047802 | 2047802 | 2021-12-25 | Echols | Georgia | 13101 | 739 | 11 |
2044552 | 2044552 | 2021-12-24 | Echols | Georgia | 13101 | 739 | 11 |
2041303 | 2041303 | 2021-12-23 | Echols | Georgia | 13101 | 739 | 11 |
2035042 | 2035042 | 2021-12-21 | Putnam | Illinois | 17155 | 739 | 6 |
2020841 | 2020841 | 2021-12-16 | Hemphill | Texas | 48211 | 739 | 3 |
1986163 | 1986163 | 2021-12-06 | Bear Lake | Idaho | 16007 | 739 | 15 |
1982913 | 1982913 | 2021-12-05 | Bear Lake | Idaho | 16007 | 739 | 14 |
1979663 | 1979663 | 2021-12-04 | Bear Lake | Idaho | 16007 | 739 | 14 |
1976413 | 1976413 | 2021-12-03 | Bear Lake | Idaho | 16007 | 739 | 14 |
1973164 | 1973164 | 2021-12-02 | Bear Lake | Idaho | 16007 | 739 | 14 |
1974249 | 1974249 | 2021-12-02 | Musselshell | Montana | 30065 | 739 | 22 |
1971072 | 1971072 | 2021-12-01 | Johnson | Nebraska | 31097 | 739 | 10 |
1968131 | 1968131 | 2021-11-30 | LaMoure | North Dakota | 38045 | 739 | 17 |
1941849 | 1941849 | 2021-11-22 | Thayer | Nebraska | 31169 | 739 | 8 |
1895116 | 1895116 | 2021-11-08 | Talbot | Georgia | 13263 | 739 | 27 |
1891866 | 1891866 | 2021-11-07 | Talbot | Georgia | 13263 | 739 | 27 |
1888616 | 1888616 | 2021-11-06 | Talbot | Georgia | 13263 | 739 | 27 |
1885366 | 1885366 | 2021-11-05 | Talbot | Georgia | 13263 | 739 | 27 |
1882117 | 1882117 | 2021-11-04 | Talbot | Georgia | 13263 | 739 | 27 |
1878868 | 1878868 | 2021-11-03 | Talbot | Georgia | 13263 | 739 | 27 |
1875619 | 1875619 | 2021-11-02 | Talbot | Georgia | 13263 | 739 | 27 |
1872370 | 1872370 | 2021-11-01 | Talbot | Georgia | 13263 | 739 | 27 |
1867084 | 1867084 | 2021-10-30 | Morrill | Nebraska | 31123 | 739 | 16 |
1863835 | 1863835 | 2021-10-29 | Morrill | Nebraska | 31123 | 739 | 16 |
1854052 | 1854052 | 2021-10-26 | Dixon | Nebraska | 31051 | 739 | 11 |
1850146 | 1850146 | 2021-10-25 | Fulton | Kentucky | 21075 | 739 | 16 |
1850803 | 1850803 | 2021-10-25 | Dixon | Nebraska | 31051 | 739 | 11 |
1847553 | 1847553 | 2021-10-24 | Dixon | Nebraska | 31051 | 739 | 10 |
1844303 | 1844303 | 2021-10-23 | Dixon | Nebraska | 31051 | 739 | 10 |
1841053 | 1841053 | 2021-10-22 | Dixon | Nebraska | 31051 | 739 | 10 |
1837804 | 1837804 | 2021-10-21 | Dixon | Nebraska | 31051 | 739 | 10 |
1831788 | 1831788 | 2021-10-19 | Greer | Oklahoma | 40055 | 739 | 23 |
1828539 | 1828539 | 2021-10-18 | Greer | Oklahoma | 40055 | 739 | 23 |
1825290 | 1825290 | 2021-10-17 | Greer | Oklahoma | 40055 | 739 | 23 |
1822041 | 1822041 | 2021-10-16 | Greer | Oklahoma | 40055 | 739 | 23 |
1818792 | 1818792 | 2021-10-15 | Greer | Oklahoma | 40055 | 739 | 23 |
1815543 | 1815543 | 2021-10-14 | Greer | Oklahoma | 40055 | 739 | 23 |
1812295 | 1812295 | 2021-10-13 | Greer | Oklahoma | 40055 | 739 | 23 |
1813072 | 1813072 | 2021-10-13 | Covington city | Virginia | 51580 | 739 | 15 |
1807123 | 1807123 | 2021-10-12 | Clear Creek | Colorado | 8019 | 739 | 5 |
1807865 | 1807865 | 2021-10-12 | Washington | Kansas | 20201 | 739 | 15 |
1804614 | 1804614 | 2021-10-11 | Washington | Kansas | 20201 | 739 | 15 |
1805359 | 1805359 | 2021-10-11 | Polk | Nebraska | 31143 | 739 | 18 |
1802110 | 1802110 | 2021-10-10 | Polk | Nebraska | 31143 | 739 | 18 |
1798861 | 1798861 | 2021-10-09 | Polk | Nebraska | 31143 | 739 | 18 |
1795612 | 1795612 | 2021-10-08 | Polk | Nebraska | 31143 | 739 | 18 |
1783741 | 1783741 | 2021-10-04 | Wheeler | Texas | 48483 | 739 | 12 |
1780492 | 1780492 | 2021-10-03 | Wheeler | Texas | 48483 | 739 | 12 |
1777242 | 1777242 | 2021-10-02 | Wheeler | Texas | 48483 | 739 | 12 |
1766308 | 1766308 | 2021-09-29 | Burt | Nebraska | 31021 | 739 | 12 |
1762338 | 1762338 | 2021-09-28 | Morris | Kansas | 20127 | 739 | 24 |
1763059 | 1763059 | 2021-09-28 | Burt | Nebraska | 31021 | 739 | 12 |
1758670 | 1758670 | 2021-09-27 | Warren | Georgia | 13301 | 739 | 23 |
1759090 | 1759090 | 2021-09-27 | Morris | Kansas | 20127 | 739 | 24 |
1755842 | 1755842 | 2021-09-26 | Morris | Kansas | 20127 | 739 | 24 |
1752594 | 1752594 | 2021-09-25 | Morris | Kansas | 20127 | 739 | 24 |
1749345 | 1749345 | 2021-09-24 | Morris | Kansas | 20127 | 739 | 24 |
1743475 | 1743475 | 2021-09-22 | Reynolds | Missouri | 29179 | 739 | 6 |
1739268 | 1739268 | 2021-09-21 | Gallatin | Illinois | 17059 | 739 | 6 |
1739615 | 1739615 | 2021-09-21 | Rooks | Kansas | 20163 | 739 | 11 |
1740226 | 1740226 | 2021-09-21 | Reynolds | Missouri | 29179 | 739 | 6 |
1736366 | 1736366 | 2021-09-20 | Rooks | Kansas | 20163 | 739 | 11 |
1736977 | 1736977 | 2021-09-20 | Reynolds | Missouri | 29179 | 739 | 6 |
1737418 | 1737418 | 2021-09-20 | McHenry | North Dakota | 38049 | 739 | 23 |
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);