ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
176 rows where cases = 3341 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 14
- Georgia 13
- Kentucky 11
- Alabama 10
- Virginia 8
- Washington 8
- Colorado 7
- Michigan 7
- Missouri 7
- North Carolina 6
- Tennessee 6
- Indiana 5
- Minnesota 5
- Texas 5
- Wisconsin 5
- Arkansas 4
- Idaho 4
- Massachusetts 4
- Ohio 4
- California 3
- Mississippi 3
- Nebraska 3
- Nevada 3
- New Mexico 3
- Pennsylvania 3
- Utah 3
- Florida 2
- Hawaii 2
- Iowa 2
- Louisiana 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502563 | 2502563 | 2022-05-13 | Greensville | Virginia | 51081 | 3341 | 40 |
2499305 | 2499305 | 2022-05-12 | Greensville | Virginia | 51081 | 3341 | 40 |
2483544 | 2483544 | 2022-05-08 | Crowley | Colorado | 8025 | 3341 | 30 |
2480286 | 2480286 | 2022-05-07 | Crowley | Colorado | 8025 | 3341 | 30 |
2477028 | 2477028 | 2022-05-06 | Crowley | Colorado | 8025 | 3341 | 30 |
2473770 | 2473770 | 2022-05-05 | Crowley | Colorado | 8025 | 3341 | 30 |
2415306 | 2415306 | 2022-04-17 | Bleckley | Georgia | 13023 | 3341 | 96 |
2412050 | 2412050 | 2022-04-16 | Bleckley | Georgia | 13023 | 3341 | 96 |
2408794 | 2408794 | 2022-04-15 | Bleckley | Georgia | 13023 | 3341 | 96 |
2405538 | 2405538 | 2022-04-14 | Bleckley | Georgia | 13023 | 3341 | 96 |
2402283 | 2402283 | 2022-04-13 | Bleckley | Georgia | 13023 | 3341 | 96 |
2404929 | 2404929 | 2022-04-13 | Southampton | Virginia | 51175 | 3341 | 90 |
2399028 | 2399028 | 2022-04-12 | Bleckley | Georgia | 13023 | 3341 | 96 |
2401636 | 2401636 | 2022-04-12 | Martinsville city | Virginia | 51690 | 3341 | 117 |
2401674 | 2401674 | 2022-04-12 | Southampton | Virginia | 51175 | 3341 | 89 |
2398419 | 2398419 | 2022-04-11 | Southampton | Virginia | 51175 | 3341 | 89 |
2392517 | 2392517 | 2022-04-10 | Bleckley | Georgia | 13023 | 3341 | 95 |
2389261 | 2389261 | 2022-04-09 | Bleckley | Georgia | 13023 | 3341 | 95 |
2386006 | 2386006 | 2022-04-08 | Bleckley | Georgia | 13023 | 3341 | 95 |
2382751 | 2382751 | 2022-04-07 | Bleckley | Georgia | 13023 | 3341 | 95 |
2379496 | 2379496 | 2022-04-06 | Bleckley | Georgia | 13023 | 3341 | 95 |
2374827 | 2374827 | 2022-04-04 | Curry | Oregon | 41015 | 3341 | 52 |
2353687 | 2353687 | 2022-03-29 | Cumberland | Illinois | 17035 | 3341 | 49 |
2350435 | 2350435 | 2022-03-28 | Cumberland | Illinois | 17035 | 3341 | 49 |
2347182 | 2347182 | 2022-03-27 | Cumberland | Illinois | 17035 | 3341 | 49 |
2348300 | 2348300 | 2022-03-27 | Otoe | Nebraska | 31131 | 3341 | 17 |
2343929 | 2343929 | 2022-03-26 | Cumberland | Illinois | 17035 | 3341 | 49 |
2345047 | 2345047 | 2022-03-26 | Otoe | Nebraska | 31131 | 3341 | 17 |
2340676 | 2340676 | 2022-03-25 | Cumberland | Illinois | 17035 | 3341 | 49 |
2341794 | 2341794 | 2022-03-25 | Otoe | Nebraska | 31131 | 3341 | 17 |
2337423 | 2337423 | 2022-03-24 | Cumberland | Illinois | 17035 | 3341 | 49 |
2334169 | 2334169 | 2022-03-23 | Cumberland | Illinois | 17035 | 3341 | 49 |
2297924 | 2297924 | 2022-03-12 | Marion | Arkansas | 5089 | 3341 | 85 |
2294672 | 2294672 | 2022-03-11 | Marion | Arkansas | 5089 | 3341 | 85 |
2291420 | 2291420 | 2022-03-10 | Marion | Arkansas | 5089 | 3341 | 85 |
2243727 | 2243727 | 2022-02-23 | Nantucket | Massachusetts | 25019 | 3341 | 0 |
2240476 | 2240476 | 2022-02-22 | Nantucket | Massachusetts | 25019 | 3341 | 0 |
2212858 | 2212858 | 2022-02-13 | Zapata | Texas | 48505 | 3341 | 49 |
2194943 | 2194943 | 2022-02-08 | Dukes | Massachusetts | 25007 | 3341 | 0 |
2178484 | 2178484 | 2022-02-03 | Fleming | Kentucky | 21069 | 3341 | 44 |
2175270 | 2175270 | 2022-02-02 | Magoffin | Kentucky | 21153 | 3341 | 37 |
2172230 | 2172230 | 2022-02-01 | Leelanau | Michigan | 26089 | 3341 | 44 |
2168977 | 2168977 | 2022-01-31 | Leelanau | Michigan | 26089 | 3341 | 44 |
2153260 | 2153260 | 2022-01-26 | Socorro | New Mexico | 35053 | 3341 | 75 |
2136651 | 2136651 | 2022-01-21 | Bates | Missouri | 29013 | 3341 | 70 |
2115286 | 2115286 | 2022-01-14 | Unknown | Utah | 3341 | 58 | |
2106124 | 2106124 | 2022-01-12 | Alamosa | Colorado | 8003 | 3341 | 57 |
2097897 | 2097897 | 2022-01-09 | Humboldt | Nevada | 32013 | 3341 | 44 |
2094645 | 2094645 | 2022-01-08 | Humboldt | Nevada | 32013 | 3341 | 44 |
2091145 | 2091145 | 2022-01-07 | Cooper | Missouri | 29053 | 3341 | 63 |
2091393 | 2091393 | 2022-01-07 | Humboldt | Nevada | 32013 | 3341 | 44 |
2087411 | 2087411 | 2022-01-06 | Garrard | Kentucky | 21079 | 3341 | 60 |
2089198 | 2089198 | 2022-01-06 | San Jacinto | Texas | 48407 | 3341 | 84 |
2034987 | 2034987 | 2021-12-21 | Edgar | Illinois | 17045 | 3341 | 71 |
2035564 | 2035564 | 2021-12-21 | Waldo | Maine | 23027 | 3341 | 37 |
2028054 | 2028054 | 2021-12-19 | Colusa | California | 6011 | 3341 | 21 |
2030478 | 2030478 | 2021-12-19 | Unicoi | Tennessee | 47171 | 3341 | 71 |
2024803 | 2024803 | 2021-12-18 | Colusa | California | 6011 | 3341 | 21 |
2025166 | 2025166 | 2021-12-18 | Kauai | Hawaii | 15007 | 3341 | 13 |
2027227 | 2027227 | 2021-12-18 | Unicoi | Tennessee | 47171 | 3341 | 71 |
2021552 | 2021552 | 2021-12-17 | Colusa | California | 6011 | 3341 | 21 |
2023976 | 2023976 | 2021-12-17 | Unicoi | Tennessee | 47171 | 3341 | 71 |
2001883 | 2001883 | 2021-12-11 | Fayette | Alabama | 1057 | 3341 | 85 |
1987995 | 1987995 | 2021-12-06 | Rio Grande | Puerto Rico | 72119 | 3341 | |
1962662 | 1962662 | 2021-11-28 | Adams | Washington | 53001 | 3341 | 34 |
1959411 | 1959411 | 2021-11-27 | Adams | Washington | 53001 | 3341 | 34 |
1956160 | 1956160 | 2021-11-26 | Adams | Washington | 53001 | 3341 | 34 |
1952909 | 1952909 | 2021-11-25 | Adams | Washington | 53001 | 3341 | 34 |
1949658 | 1949658 | 2021-11-24 | Adams | Washington | 53001 | 3341 | 34 |
1940150 | 1940150 | 2021-11-22 | Randolph | Alabama | 1111 | 3341 | 67 |
1936965 | 1936965 | 2021-11-21 | Clark | Arkansas | 5019 | 3341 | 60 |
1921358 | 1921358 | 2021-11-16 | Owen | Indiana | 18119 | 3341 | 77 |
1921950 | 1921950 | 2021-11-16 | Hubbard | Minnesota | 27057 | 3341 | 47 |
1899791 | 1899791 | 2021-11-09 | Greene | North Carolina | 37079 | 3341 | 56 |
1894645 | 1894645 | 2021-11-08 | Monroe | Alabama | 1099 | 3341 | 66 |
1896541 | 1896541 | 2021-11-08 | Greene | North Carolina | 37079 | 3341 | 56 |
1891395 | 1891395 | 2021-11-07 | Monroe | Alabama | 1099 | 3341 | 66 |
1892642 | 1892642 | 2021-11-07 | Mason | Michigan | 26105 | 3341 | 47 |
1888145 | 1888145 | 2021-11-06 | Monroe | Alabama | 1099 | 3341 | 66 |
1889392 | 1889392 | 2021-11-06 | Mason | Michigan | 26105 | 3341 | 47 |
1886142 | 1886142 | 2021-11-05 | Mason | Michigan | 26105 | 3341 | 47 |
1879129 | 1879129 | 2021-11-03 | Sullivan | Indiana | 18153 | 3341 | 54 |
1879398 | 1879398 | 2021-11-03 | Harrison | Kentucky | 21097 | 3341 | 39 |
1870010 | 1870010 | 2021-10-31 | Waseca | Minnesota | 27161 | 3341 | 31 |
1866761 | 1866761 | 2021-10-30 | Waseca | Minnesota | 27161 | 3341 | 31 |
1863512 | 1863512 | 2021-10-29 | Waseca | Minnesota | 27161 | 3341 | 31 |
1860076 | 1860076 | 2021-10-28 | Somerset | Maryland | 24039 | 3341 | 54 |
1849406 | 1849406 | 2021-10-25 | Routt | Colorado | 8107 | 3341 | 23 |
1835404 | 1835404 | 2021-10-20 | Crockett | Tennessee | 47033 | 3341 | 62 |
1829655 | 1829655 | 2021-10-19 | Marengo | Alabama | 1091 | 3341 | 89 |
1832616 | 1832616 | 2021-10-19 | Mecklenburg | Virginia | 51117 | 3341 | 81 |
1826406 | 1826406 | 2021-10-18 | Marengo | Alabama | 1091 | 3341 | 89 |
1804304 | 1804304 | 2021-10-11 | Shelby | Illinois | 17173 | 3341 | 48 |
1801055 | 1801055 | 2021-10-10 | Shelby | Illinois | 17173 | 3341 | 48 |
1797806 | 1797806 | 2021-10-09 | Shelby | Illinois | 17173 | 3341 | 48 |
1794557 | 1794557 | 2021-10-08 | Shelby | Illinois | 17173 | 3341 | 48 |
1778676 | 1778676 | 2021-10-03 | Hart | Kentucky | 21099 | 3341 | 60 |
1775426 | 1775426 | 2021-10-02 | Hart | Kentucky | 21099 | 3341 | 60 |
1772176 | 1772176 | 2021-10-01 | Hart | Kentucky | 21099 | 3341 | 60 |
1770775 | 1770775 | 2021-09-30 | Sevier | Utah | 49041 | 3341 | 16 |
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);