ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
477 rows where cases = 764 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 42
- Texas 34
- Kansas 33
- Georgia 24
- Iowa 21
- Missouri 21
- South Dakota 20
- Puerto Rico 18
- Mississippi 17
- Montana 16
- Nebraska 16
- Illinois 14
- Indiana 14
- Kentucky 13
- North Carolina 13
- Tennessee 13
- Alaska 12
- Minnesota 12
- North Dakota 12
- New Mexico 10
- Michigan 8
- West Virginia 8
- Alabama 6
- Colorado 6
- Florida 6
- Idaho 6
- Oklahoma 5
- Oregon 5
- Arkansas 4
- California 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467084 | 2467084 | 2022-05-03 | Petersburg Borough | Alaska | 2195 | 764 | 4 |
2463829 | 2463829 | 2022-05-02 | Petersburg Borough | Alaska | 2195 | 764 | 4 |
2460573 | 2460573 | 2022-05-01 | Petersburg Borough | Alaska | 2195 | 764 | 4 |
2457317 | 2457317 | 2022-04-30 | Petersburg Borough | Alaska | 2195 | 764 | 4 |
2454061 | 2454061 | 2022-04-29 | Petersburg Borough | Alaska | 2195 | 764 | 4 |
2450805 | 2450805 | 2022-04-28 | Petersburg Borough | Alaska | 2195 | 764 | 4 |
2447549 | 2447549 | 2022-04-27 | Petersburg Borough | Alaska | 2195 | 764 | 4 |
2449301 | 2449301 | 2022-04-27 | Mora | New Mexico | 35033 | 764 | 17 |
2446044 | 2446044 | 2022-04-26 | Mora | New Mexico | 35033 | 764 | 17 |
2442789 | 2442789 | 2022-04-25 | Mora | New Mexico | 35033 | 764 | 17 |
2439533 | 2439533 | 2022-04-24 | Mora | New Mexico | 35033 | 764 | 17 |
2436277 | 2436277 | 2022-04-23 | Mora | New Mexico | 35033 | 764 | 17 |
2433021 | 2433021 | 2022-04-22 | Mora | New Mexico | 35033 | 764 | 17 |
2429765 | 2429765 | 2022-04-21 | Mora | New Mexico | 35033 | 764 | 17 |
2426509 | 2426509 | 2022-04-20 | Mora | New Mexico | 35033 | 764 | 17 |
2406504 | 2406504 | 2022-04-14 | Lake of the Woods | Minnesota | 27077 | 764 | 6 |
2403248 | 2403248 | 2022-04-13 | Lake of the Woods | Minnesota | 27077 | 764 | 6 |
2399994 | 2399994 | 2022-04-12 | Lake of the Woods | Minnesota | 27077 | 764 | 6 |
2257958 | 2257958 | 2022-02-27 | Aurora | South Dakota | 46003 | 764 | 17 |
2254707 | 2254707 | 2022-02-26 | Aurora | South Dakota | 46003 | 764 | 17 |
2251456 | 2251456 | 2022-02-25 | Aurora | South Dakota | 46003 | 764 | 17 |
2248205 | 2248205 | 2022-02-24 | Aurora | South Dakota | 46003 | 764 | 17 |
2244954 | 2244954 | 2022-02-23 | Aurora | South Dakota | 46003 | 764 | 17 |
2206256 | 2206256 | 2022-02-11 | Mason | Texas | 48319 | 764 | 11 |
2192934 | 2192934 | 2022-02-07 | Clark | South Dakota | 46025 | 764 | 6 |
2188171 | 2188171 | 2022-02-06 | Osborne | Kansas | 20141 | 764 | 16 |
2188204 | 2188204 | 2022-02-06 | Woodson | Kansas | 20207 | 764 | 12 |
2189219 | 2189219 | 2022-02-06 | Cavalier | North Dakota | 38019 | 764 | 7 |
2184918 | 2184918 | 2022-02-05 | Osborne | Kansas | 20141 | 764 | 16 |
2184951 | 2184951 | 2022-02-05 | Woodson | Kansas | 20207 | 764 | 12 |
2185966 | 2185966 | 2022-02-05 | Cavalier | North Dakota | 38019 | 764 | 7 |
2181666 | 2181666 | 2022-02-04 | Osborne | Kansas | 20141 | 764 | 16 |
2181699 | 2181699 | 2022-02-04 | Woodson | Kansas | 20207 | 764 | 12 |
2165413 | 2165413 | 2022-01-30 | Rush | Kansas | 20165 | 764 | 17 |
2162158 | 2162158 | 2022-01-29 | Rush | Kansas | 20165 | 764 | 17 |
2158903 | 2158903 | 2022-01-28 | Rush | Kansas | 20165 | 764 | 17 |
2160564 | 2160564 | 2022-01-28 | Baylor | Texas | 48023 | 764 | 28 |
2154357 | 2154357 | 2022-01-26 | Bath | Virginia | 51017 | 764 | 15 |
2108766 | 2108766 | 2022-01-12 | Garfield | Utah | 49017 | 764 | 12 |
2105515 | 2105515 | 2022-01-11 | Garfield | Utah | 49017 | 764 | 12 |
2094894 | 2094894 | 2022-01-08 | Foster | North Dakota | 38031 | 764 | 19 |
2095539 | 2095539 | 2022-01-08 | Coke | Texas | 48081 | 764 | 18 |
2078259 | 2078259 | 2022-01-03 | Mineral | Montana | 30061 | 764 | 14 |
2074769 | 2074769 | 2022-01-02 | Unknown | Minnesota | 764 | 140 | |
2075008 | 2075008 | 2022-01-02 | Mineral | Montana | 30061 | 764 | 14 |
2071518 | 2071518 | 2022-01-01 | Unknown | Minnesota | 764 | 140 | |
2071757 | 2071757 | 2022-01-01 | Mineral | Montana | 30061 | 764 | 14 |
2068267 | 2068267 | 2021-12-31 | Unknown | Minnesota | 764 | 140 | |
2068506 | 2068506 | 2021-12-31 | Mineral | Montana | 30061 | 764 | 14 |
2065016 | 2065016 | 2021-12-30 | Unknown | Minnesota | 764 | 140 | |
2065255 | 2065255 | 2021-12-30 | Mineral | Montana | 30061 | 764 | 14 |
2039671 | 2039671 | 2021-12-22 | Wells | North Dakota | 38103 | 764 | 11 |
2032760 | 2032760 | 2021-12-20 | Musselshell | Montana | 30065 | 764 | 26 |
2023389 | 2023389 | 2021-12-17 | LaMoure | North Dakota | 38045 | 764 | 17 |
2020138 | 2020138 | 2021-12-16 | LaMoure | North Dakota | 38045 | 764 | 17 |
2020156 | 2020156 | 2021-12-16 | Sargent | North Dakota | 38081 | 764 | 9 |
2018032 | 2018032 | 2021-12-15 | Florence | Wisconsin | 55037 | 764 | 14 |
2008946 | 2008946 | 2021-12-13 | Lincoln | Idaho | 16063 | 764 | 14 |
2008056 | 2008056 | 2021-12-12 | Charles City | Virginia | 51036 | 764 | 21 |
2004805 | 2004805 | 2021-12-11 | Charles City | Virginia | 51036 | 764 | 21 |
2001554 | 2001554 | 2021-12-10 | Charles City | Virginia | 51036 | 764 | 21 |
1998304 | 1998304 | 2021-12-09 | Charles City | Virginia | 51036 | 764 | 21 |
1993803 | 1993803 | 2021-12-08 | Fillmore | Nebraska | 31059 | 764 | 13 |
1989808 | 1989808 | 2021-12-07 | Meade | Kansas | 20119 | 764 | 14 |
1989857 | 1989857 | 2021-12-07 | Ballard | Kentucky | 21007 | 764 | 25 |
1986558 | 1986558 | 2021-12-06 | Meade | Kansas | 20119 | 764 | 14 |
1983341 | 1983341 | 2021-12-05 | Stafford | Kansas | 20185 | 764 | 19 |
1980091 | 1980091 | 2021-12-04 | Stafford | Kansas | 20185 | 764 | 19 |
1976841 | 1976841 | 2021-12-03 | Stafford | Kansas | 20185 | 764 | 19 |
1962089 | 1962089 | 2021-11-28 | Gregory | South Dakota | 46053 | 764 | 31 |
1958838 | 1958838 | 2021-11-27 | Gregory | South Dakota | 46053 | 764 | 31 |
1955587 | 1955587 | 2021-11-26 | Gregory | South Dakota | 46053 | 764 | 31 |
1952336 | 1952336 | 2021-11-25 | Gregory | South Dakota | 46053 | 764 | 31 |
1949085 | 1949085 | 2021-11-24 | Gregory | South Dakota | 46053 | 764 | 31 |
1944967 | 1944967 | 2021-11-23 | Chouteau | Montana | 30015 | 764 | 8 |
1920211 | 1920211 | 2021-11-15 | Wheeler | Texas | 48483 | 764 | 14 |
1916961 | 1916961 | 2021-11-14 | Wheeler | Texas | 48483 | 764 | 14 |
1917050 | 1917050 | 2021-11-14 | Covington city | Virginia | 51580 | 764 | 16 |
1913711 | 1913711 | 2021-11-13 | Wheeler | Texas | 48483 | 764 | 14 |
1913800 | 1913800 | 2021-11-13 | Covington city | Virginia | 51580 | 764 | 16 |
1910550 | 1910550 | 2021-11-12 | Covington city | Virginia | 51580 | 764 | 16 |
1907301 | 1907301 | 2021-11-11 | Covington city | Virginia | 51580 | 764 | 16 |
1904052 | 1904052 | 2021-11-10 | Covington city | Virginia | 51580 | 764 | 16 |
1899864 | 1899864 | 2021-11-09 | Dunn | North Dakota | 38025 | 764 | 7 |
1891949 | 1891949 | 2021-11-07 | Alexander | Illinois | 17003 | 764 | 13 |
1892314 | 1892314 | 2021-11-07 | Ottawa | Kansas | 20143 | 764 | 14 |
1894312 | 1894312 | 2021-11-07 | Fairfax city | Virginia | 51600 | 764 | 27 |
1888699 | 1888699 | 2021-11-06 | Alexander | Illinois | 17003 | 764 | 13 |
1889064 | 1889064 | 2021-11-06 | Ottawa | Kansas | 20143 | 764 | 14 |
1891062 | 1891062 | 2021-11-06 | Fairfax city | Virginia | 51600 | 764 | 27 |
1885449 | 1885449 | 2021-11-05 | Alexander | Illinois | 17003 | 764 | 13 |
1885814 | 1885814 | 2021-11-05 | Ottawa | Kansas | 20143 | 764 | 14 |
1887812 | 1887812 | 2021-11-05 | Fairfax city | Virginia | 51600 | 764 | 27 |
1882200 | 1882200 | 2021-11-04 | Alexander | Illinois | 17003 | 764 | 13 |
1867103 | 1867103 | 2021-10-30 | Sheridan | Nebraska | 31161 | 764 | 23 |
1863854 | 1863854 | 2021-10-29 | Sheridan | Nebraska | 31161 | 764 | 23 |
1859394 | 1859394 | 2021-10-28 | Warren | Georgia | 13301 | 764 | 25 |
1856145 | 1856145 | 2021-10-27 | Warren | Georgia | 13301 | 764 | 25 |
1852896 | 1852896 | 2021-10-26 | Warren | Georgia | 13301 | 764 | 24 |
1849647 | 1849647 | 2021-10-25 | Warren | Georgia | 13301 | 764 | 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);