ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
183 rows where cases = 3477 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 37
- Indiana 11
- Minnesota 11
- Ohio 11
- Georgia 10
- Missouri 10
- Texas 9
- Illinois 7
- Colorado 6
- Kentucky 6
- Tennessee 6
- Louisiana 5
- Massachusetts 5
- Virginia 5
- West Virginia 5
- Arkansas 4
- New York 4
- Puerto Rico 4
- Alabama 3
- Kansas 3
- Mississippi 3
- Alaska 2
- California 2
- Oregon 2
- South Carolina 2
- South Dakota 2
- Washington 2
- Maryland 1
- New Jersey 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497557 | 2497557 | 2022-05-12 | Nantucket | Massachusetts | 25019 | 3477 | 0 |
2490638 | 2490638 | 2022-05-10 | Hamilton | Iowa | 19079 | 3477 | 72 |
2487381 | 2487381 | 2022-05-09 | Hamilton | Iowa | 19079 | 3477 | 72 |
2484123 | 2484123 | 2022-05-08 | Hamilton | Iowa | 19079 | 3477 | 72 |
2480865 | 2480865 | 2022-05-07 | Hamilton | Iowa | 19079 | 3477 | 72 |
2477607 | 2477607 | 2022-05-06 | Hamilton | Iowa | 19079 | 3477 | 72 |
2474349 | 2474349 | 2022-05-05 | Hamilton | Iowa | 19079 | 3477 | 72 |
2471092 | 2471092 | 2022-05-04 | Hamilton | Iowa | 19079 | 3477 | 72 |
2449588 | 2449588 | 2022-04-27 | Monroe | Ohio | 39111 | 3477 | 82 |
2445027 | 2445027 | 2022-04-26 | Clayton | Iowa | 19043 | 3477 | 72 |
2445045 | 2445045 | 2022-04-26 | Hamilton | Iowa | 19079 | 3477 | 72 |
2446331 | 2446331 | 2022-04-26 | Monroe | Ohio | 39111 | 3477 | 82 |
2441771 | 2441771 | 2022-04-25 | Clayton | Iowa | 19043 | 3477 | 72 |
2441789 | 2441789 | 2022-04-25 | Hamilton | Iowa | 19079 | 3477 | 72 |
2443076 | 2443076 | 2022-04-25 | Monroe | Ohio | 39111 | 3477 | 82 |
2438515 | 2438515 | 2022-04-24 | Clayton | Iowa | 19043 | 3477 | 72 |
2438533 | 2438533 | 2022-04-24 | Hamilton | Iowa | 19079 | 3477 | 72 |
2438930 | 2438930 | 2022-04-24 | Dukes | Massachusetts | 25007 | 3477 | 0 |
2439820 | 2439820 | 2022-04-24 | Monroe | Ohio | 39111 | 3477 | 82 |
2435259 | 2435259 | 2022-04-23 | Clayton | Iowa | 19043 | 3477 | 72 |
2435277 | 2435277 | 2022-04-23 | Hamilton | Iowa | 19079 | 3477 | 72 |
2435674 | 2435674 | 2022-04-23 | Dukes | Massachusetts | 25007 | 3477 | 0 |
2436564 | 2436564 | 2022-04-23 | Monroe | Ohio | 39111 | 3477 | 82 |
2436831 | 2436831 | 2022-04-23 | Naguabo | Puerto Rico | 72103 | 3477 | |
2432003 | 2432003 | 2022-04-22 | Clayton | Iowa | 19043 | 3477 | 72 |
2432021 | 2432021 | 2022-04-22 | Hamilton | Iowa | 19079 | 3477 | 72 |
2432418 | 2432418 | 2022-04-22 | Dukes | Massachusetts | 25007 | 3477 | 0 |
2433308 | 2433308 | 2022-04-22 | Monroe | Ohio | 39111 | 3477 | 82 |
2428747 | 2428747 | 2022-04-21 | Clayton | Iowa | 19043 | 3477 | 72 |
2428765 | 2428765 | 2022-04-21 | Hamilton | Iowa | 19079 | 3477 | 72 |
2430052 | 2430052 | 2022-04-21 | Monroe | Ohio | 39111 | 3477 | 82 |
2425491 | 2425491 | 2022-04-20 | Clayton | Iowa | 19043 | 3477 | 72 |
2425509 | 2425509 | 2022-04-20 | Hamilton | Iowa | 19079 | 3477 | 72 |
2376676 | 2376676 | 2022-04-05 | Hamilton | Iowa | 19079 | 3477 | 72 |
2373424 | 2373424 | 2022-04-04 | Hamilton | Iowa | 19079 | 3477 | 72 |
2370171 | 2370171 | 2022-04-03 | Hamilton | Iowa | 19079 | 3477 | 72 |
2366918 | 2366918 | 2022-04-02 | Hamilton | Iowa | 19079 | 3477 | 72 |
2363665 | 2363665 | 2022-04-01 | Hamilton | Iowa | 19079 | 3477 | 72 |
2360411 | 2360411 | 2022-03-31 | Hamilton | Iowa | 19079 | 3477 | 72 |
2357157 | 2357157 | 2022-03-30 | Hamilton | Iowa | 19079 | 3477 | 72 |
2357681 | 2357681 | 2022-03-30 | Kanabec | Minnesota | 27065 | 3477 | 55 |
2354428 | 2354428 | 2022-03-29 | Kanabec | Minnesota | 27065 | 3477 | 55 |
2351176 | 2351176 | 2022-03-28 | Kanabec | Minnesota | 27065 | 3477 | 55 |
2347923 | 2347923 | 2022-03-27 | Kanabec | Minnesota | 27065 | 3477 | 55 |
2344670 | 2344670 | 2022-03-26 | Kanabec | Minnesota | 27065 | 3477 | 55 |
2341417 | 2341417 | 2022-03-25 | Kanabec | Minnesota | 27065 | 3477 | 55 |
2334910 | 2334910 | 2022-03-23 | Kanabec | Minnesota | 27065 | 3477 | 55 |
2265912 | 2265912 | 2022-03-02 | Menard | Illinois | 17129 | 3477 | 23 |
2267724 | 2267724 | 2022-03-02 | Clay | South Dakota | 46027 | 3477 | 20 |
2264471 | 2264471 | 2022-03-01 | Clay | South Dakota | 46027 | 3477 | 20 |
2239008 | 2239008 | 2022-02-21 | Patrick | Virginia | 51141 | 3477 | 83 |
2219117 | 2219117 | 2022-02-15 | Bandera | Texas | 48019 | 3477 | 72 |
2210762 | 2210762 | 2022-02-13 | Tipton | Indiana | 18159 | 3477 | 82 |
2207509 | 2207509 | 2022-02-12 | Tipton | Indiana | 18159 | 3477 | 82 |
2204256 | 2204256 | 2022-02-11 | Tipton | Indiana | 18159 | 3477 | 82 |
2198052 | 2198052 | 2022-02-09 | Monroe | Kentucky | 21171 | 3477 | 70 |
2198525 | 2198525 | 2022-02-09 | Madison | Missouri | 29123 | 3477 | 47 |
2177190 | 2177190 | 2022-02-02 | King William | Virginia | 51101 | 3477 | 27 |
2168198 | 2168198 | 2022-01-31 | Rabun | Georgia | 13241 | 3477 | 84 |
2168321 | 2168321 | 2022-01-31 | Greene | Illinois | 17061 | 3477 | 55 |
2169247 | 2169247 | 2022-01-31 | Livingston | Missouri | 29117 | 3477 | 86 |
2164295 | 2164295 | 2022-01-29 | Grant | West Virginia | 54023 | 3477 | 51 |
2149779 | 2149779 | 2022-01-25 | Wright | Missouri | 29229 | 3477 | 71 |
2098484 | 2098484 | 2022-01-09 | Fajardo | Puerto Rico | 72053 | 3477 | |
2083384 | 2083384 | 2022-01-05 | Elbert | Colorado | 8039 | 3477 | 31 |
2085471 | 2085471 | 2022-01-05 | Cidra | Puerto Rico | 72041 | 3477 | |
2059682 | 2059682 | 2021-12-28 | Humphreys | Tennessee | 47085 | 3477 | 59 |
2060231 | 2060231 | 2021-12-28 | Lincoln | West Virginia | 54043 | 3477 | 56 |
2029988 | 2029988 | 2021-12-19 | Paulding | Ohio | 39125 | 3477 | 57 |
2016447 | 2016447 | 2021-12-15 | Ray | Missouri | 29177 | 3477 | 64 |
2001709 | 2001709 | 2021-12-10 | Brooke | West Virginia | 54009 | 3477 | 81 |
1972765 | 1972765 | 2021-12-02 | Ouachita | Arkansas | 5103 | 3477 | 86 |
1975564 | 1975564 | 2021-12-02 | Dinwiddie | Virginia | 51053 | 3477 | 59 |
1960075 | 1960075 | 2021-11-28 | Lamar | Georgia | 13171 | 3477 | 98 |
1956824 | 1956824 | 2021-11-27 | Lamar | Georgia | 13171 | 3477 | 98 |
1953573 | 1953573 | 2021-11-26 | Lamar | Georgia | 13171 | 3477 | 98 |
1950322 | 1950322 | 2021-11-25 | Lamar | Georgia | 13171 | 3477 | 98 |
1952847 | 1952847 | 2021-11-25 | Louisa | Virginia | 51109 | 3477 | 53 |
1947071 | 1947071 | 2021-11-24 | Lamar | Georgia | 13171 | 3477 | 98 |
1918394 | 1918394 | 2021-11-15 | Harrison | Kentucky | 21097 | 3477 | 40 |
1891633 | 1891633 | 2021-11-07 | Montezuma | Colorado | 8083 | 3477 | 37 |
1888383 | 1888383 | 2021-11-06 | Montezuma | Colorado | 8083 | 3477 | 37 |
1885133 | 1885133 | 2021-11-05 | Montezuma | Colorado | 8083 | 3477 | 37 |
1833546 | 1833546 | 2021-10-20 | Shelby | Illinois | 17173 | 3477 | 51 |
1835391 | 1835391 | 2021-10-20 | Bledsoe | Tennessee | 47007 | 3477 | 17 |
1829180 | 1829180 | 2021-10-18 | Reeves | Texas | 48389 | 3477 | 52 |
1825931 | 1825931 | 2021-10-17 | Reeves | Texas | 48389 | 3477 | 52 |
1806944 | 1806944 | 2021-10-12 | Juneau City and Borough | Alaska | 2110 | 3477 | 7 |
1807673 | 1807673 | 2021-10-12 | Bremer | Iowa | 19017 | 3477 | 66 |
1804422 | 1804422 | 2021-10-11 | Bremer | Iowa | 19017 | 3477 | 66 |
1801173 | 1801173 | 2021-10-10 | Bremer | Iowa | 19017 | 3477 | 66 |
1797924 | 1797924 | 2021-10-09 | Bremer | Iowa | 19017 | 3477 | 66 |
1794675 | 1794675 | 2021-10-08 | Bremer | Iowa | 19017 | 3477 | 66 |
1791427 | 1791427 | 2021-10-07 | Bremer | Iowa | 19017 | 3477 | 66 |
1788178 | 1788178 | 2021-10-06 | Bremer | Iowa | 19017 | 3477 | 66 |
1786677 | 1786677 | 2021-10-05 | Fentress | Tennessee | 47049 | 3477 | 60 |
1772712 | 1772712 | 2021-10-01 | Randolph | Missouri | 29175 | 3477 | 36 |
1738501 | 1738501 | 2021-09-20 | Hancock | West Virginia | 54029 | 3477 | 96 |
1711483 | 1711483 | 2021-09-12 | Fayette | Ohio | 39047 | 3477 | 51 |
1704117 | 1704117 | 2021-09-10 | Dorchester | Maryland | 24019 | 3477 | 69 |
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);