ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
353 rows where cases = 1477 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 30
- Oklahoma 21
- Nebraska 20
- North Carolina 18
- Texas 16
- Virginia 15
- Missouri 14
- Kentucky 13
- Iowa 12
- Illinois 11
- Puerto Rico 11
- Tennessee 11
- Colorado 10
- Indiana 10
- Arkansas 9
- Maine 9
- Minnesota 9
- West Virginia 9
- Utah 7
- Wisconsin 7
- Alabama 6
- California 6
- New Mexico 6
- South Dakota 6
- Washington 6
- Montana 5
- Ohio 5
- Connecticut 4
- Kansas 4
- Michigan 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486783 | 2486783 | 2022-05-09 | Trinity | California | 6105 | 1477 | 20 |
2483525 | 2483525 | 2022-05-08 | Trinity | California | 6105 | 1477 | 20 |
2480267 | 2480267 | 2022-05-07 | Trinity | California | 6105 | 1477 | 20 |
2477009 | 2477009 | 2022-05-06 | Trinity | California | 6105 | 1477 | 20 |
2393944 | 2393944 | 2022-04-10 | Guadalupe | New Mexico | 35019 | 1477 | 17 |
2390688 | 2390688 | 2022-04-09 | Guadalupe | New Mexico | 35019 | 1477 | 17 |
2387432 | 2387432 | 2022-04-08 | Guadalupe | New Mexico | 35019 | 1477 | 17 |
2384177 | 2384177 | 2022-04-07 | Guadalupe | New Mexico | 35019 | 1477 | 17 |
2347073 | 2347073 | 2022-03-27 | Randolph | Georgia | 13243 | 1477 | 48 |
2343820 | 2343820 | 2022-03-26 | Randolph | Georgia | 13243 | 1477 | 48 |
2340567 | 2340567 | 2022-03-25 | Randolph | Georgia | 13243 | 1477 | 48 |
2337314 | 2337314 | 2022-03-24 | Randolph | Georgia | 13243 | 1477 | 48 |
2334060 | 2334060 | 2022-03-23 | Randolph | Georgia | 13243 | 1477 | 48 |
2330806 | 2330806 | 2022-03-22 | Randolph | Georgia | 13243 | 1477 | 48 |
2327554 | 2327554 | 2022-03-21 | Randolph | Georgia | 13243 | 1477 | 48 |
2314540 | 2314540 | 2022-03-17 | Randolph | Georgia | 13243 | 1477 | 48 |
2311287 | 2311287 | 2022-03-16 | Randolph | Georgia | 13243 | 1477 | 48 |
2308034 | 2308034 | 2022-03-15 | Randolph | Georgia | 13243 | 1477 | 47 |
2310617 | 2310617 | 2022-03-15 | Skamania | Washington | 53059 | 1477 | 12 |
2304783 | 2304783 | 2022-03-14 | Randolph | Georgia | 13243 | 1477 | 47 |
2307364 | 2307364 | 2022-03-14 | Skamania | Washington | 53059 | 1477 | 12 |
2248485 | 2248485 | 2022-02-24 | Jack | Texas | 48237 | 1477 | 27 |
2243085 | 2243085 | 2022-02-23 | Power | Idaho | 16077 | 1477 | 20 |
2224498 | 2224498 | 2022-02-17 | Carter | Missouri | 29035 | 1477 | 19 |
2219891 | 2219891 | 2022-02-16 | Montgomery | Arkansas | 5097 | 1477 | 54 |
2221247 | 2221247 | 2022-02-16 | Carter | Missouri | 29035 | 1477 | 19 |
2216640 | 2216640 | 2022-02-15 | Montgomery | Arkansas | 5097 | 1477 | 54 |
2210051 | 2210051 | 2022-02-13 | Dillingham Census Area | Alaska | 2070 | 1477 | 11 |
2206798 | 2206798 | 2022-02-12 | Dillingham Census Area | Alaska | 2070 | 1477 | 11 |
2203545 | 2203545 | 2022-02-11 | Dillingham Census Area | Alaska | 2070 | 1477 | 11 |
2200691 | 2200691 | 2022-02-10 | Jenkins | Georgia | 13165 | 1477 | 64 |
2200705 | 2200705 | 2022-02-10 | Marion | Georgia | 13197 | 1477 | 44 |
2167086 | 2167086 | 2022-01-30 | Brooks | Texas | 48047 | 1477 | 49 |
2148625 | 2148625 | 2022-01-25 | Hancock | Georgia | 13141 | 1477 | 85 |
2131310 | 2131310 | 2022-01-19 | Coleman | Texas | 48083 | 1477 | 61 |
2125878 | 2125878 | 2022-01-18 | Miller | Georgia | 13201 | 1477 | 25 |
2110415 | 2110415 | 2022-01-13 | Lake | Michigan | 26085 | 1477 | 32 |
2110746 | 2110746 | 2022-01-13 | Blaine | Montana | 30005 | 1477 | 28 |
2107164 | 2107164 | 2022-01-12 | Lake | Michigan | 26085 | 1477 | 32 |
2105764 | 2105764 | 2022-01-11 | Pocahontas | West Virginia | 54075 | 1477 | 23 |
2097815 | 2097815 | 2022-01-09 | Cuming | Nebraska | 31039 | 1477 | 15 |
2094563 | 2094563 | 2022-01-08 | Cuming | Nebraska | 31039 | 1477 | 15 |
2091311 | 2091311 | 2022-01-07 | Cuming | Nebraska | 31039 | 1477 | 15 |
2086039 | 2086039 | 2022-01-05 | Unknown | Vermont | 1477 | 0 | |
2081519 | 2081519 | 2022-01-04 | Powell | Montana | 30077 | 1477 | 26 |
2081823 | 2081823 | 2022-01-04 | Jones | North Carolina | 37103 | 1477 | 38 |
2077979 | 2077979 | 2022-01-03 | Lake | Minnesota | 27075 | 1477 | 26 |
2057413 | 2057413 | 2021-12-28 | San Miguel | Colorado | 8113 | 1477 | 7 |
2057578 | 2057578 | 2021-12-28 | Irwin | Georgia | 13155 | 1477 | 42 |
2055704 | 2055704 | 2021-12-27 | Sierra | New Mexico | 35051 | 1477 | 63 |
2056266 | 2056266 | 2021-12-27 | Utuado | Puerto Rico | 72141 | 1477 | |
2053017 | 2053017 | 2021-12-26 | Utuado | Puerto Rico | 72141 | 1477 | |
2037308 | 2037308 | 2021-12-21 | Buena Vista city | Virginia | 51530 | 1477 | 32 |
2031236 | 2031236 | 2021-12-20 | Cleveland | Arkansas | 5025 | 1477 | 33 |
2028496 | 2028496 | 2021-12-19 | Hamilton | Illinois | 17065 | 1477 | 26 |
2025245 | 2025245 | 2021-12-18 | Hamilton | Illinois | 17065 | 1477 | 26 |
2021994 | 2021994 | 2021-12-17 | Hamilton | Illinois | 17065 | 1477 | 26 |
2023756 | 2023756 | 2021-12-17 | Salinas | Puerto Rico | 72123 | 1477 | |
2010837 | 2010837 | 2021-12-13 | Custer | South Dakota | 46033 | 1477 | 19 |
2010951 | 2010951 | 2021-12-13 | Moore | Tennessee | 47127 | 1477 | 25 |
1983134 | 1983134 | 2021-12-05 | Switzerland | Indiana | 18155 | 1477 | 12 |
1979884 | 1979884 | 2021-12-04 | Switzerland | Indiana | 18155 | 1477 | 12 |
1976634 | 1976634 | 2021-12-03 | Switzerland | Indiana | 18155 | 1477 | 12 |
1978962 | 1978962 | 2021-12-03 | Gilmer | West Virginia | 54021 | 1477 | 14 |
1972489 | 1972489 | 2021-12-01 | Pleasants | West Virginia | 54073 | 1477 | 31 |
1969239 | 1969239 | 2021-11-30 | Pleasants | West Virginia | 54073 | 1477 | 30 |
1951233 | 1951233 | 2021-11-25 | Pipestone | Minnesota | 27117 | 1477 | 29 |
1947982 | 1947982 | 2021-11-24 | Pipestone | Minnesota | 27117 | 1477 | 29 |
1937505 | 1937505 | 2021-11-21 | Marshall | Illinois | 17123 | 1477 | 25 |
1934255 | 1934255 | 2021-11-20 | Marshall | Illinois | 17123 | 1477 | 25 |
1931004 | 1931004 | 2021-11-19 | Marshall | Illinois | 17123 | 1477 | 25 |
1929504 | 1929504 | 2021-11-18 | Yauco | Puerto Rico | 72153 | 1477 | |
1926254 | 1926254 | 2021-11-17 | Yauco | Puerto Rico | 72153 | 1477 | |
1917063 | 1917063 | 2021-11-14 | Floyd | Virginia | 51063 | 1477 | 31 |
1913813 | 1913813 | 2021-11-13 | Floyd | Virginia | 51063 | 1477 | 31 |
1910563 | 1910563 | 2021-11-12 | Floyd | Virginia | 51063 | 1477 | 31 |
1904822 | 1904822 | 2021-11-11 | Lanier | Georgia | 13173 | 1477 | 17 |
1907489 | 1907489 | 2021-11-11 | Summers | West Virginia | 54089 | 1477 | 30 |
1901572 | 1901572 | 2021-11-10 | Lanier | Georgia | 13173 | 1477 | 17 |
1904028 | 1904028 | 2021-11-10 | Amelia | Virginia | 51007 | 1477 | 40 |
1898322 | 1898322 | 2021-11-09 | Lanier | Georgia | 13173 | 1477 | 17 |
1897485 | 1897485 | 2021-11-08 | Grand | Utah | 49019 | 1477 | 4 |
1894235 | 1894235 | 2021-11-07 | Grand | Utah | 49019 | 1477 | 4 |
1890985 | 1890985 | 2021-11-06 | Grand | Utah | 49019 | 1477 | 4 |
1876075 | 1876075 | 2021-11-02 | Rice | Kansas | 20159 | 1477 | 15 |
1877288 | 1877288 | 2021-11-02 | Latimer | Oklahoma | 40077 | 1477 | 21 |
1872826 | 1872826 | 2021-11-01 | Rice | Kansas | 20159 | 1477 | 15 |
1873379 | 1873379 | 2021-11-01 | DeKalb | Missouri | 29063 | 1477 | 33 |
1874039 | 1874039 | 2021-11-01 | Latimer | Oklahoma | 40077 | 1477 | 21 |
1870216 | 1870216 | 2021-10-31 | Beaverhead | Montana | 30001 | 1477 | 17 |
1870790 | 1870790 | 2021-10-31 | Latimer | Oklahoma | 40077 | 1477 | 21 |
1866967 | 1866967 | 2021-10-30 | Beaverhead | Montana | 30001 | 1477 | 17 |
1867541 | 1867541 | 2021-10-30 | Latimer | Oklahoma | 40077 | 1477 | 21 |
1863718 | 1863718 | 2021-10-29 | Beaverhead | Montana | 30001 | 1477 | 17 |
1864292 | 1864292 | 2021-10-29 | Latimer | Oklahoma | 40077 | 1477 | 21 |
1861043 | 1861043 | 2021-10-28 | Latimer | Oklahoma | 40077 | 1477 | 21 |
1857794 | 1857794 | 2021-10-27 | Latimer | Oklahoma | 40077 | 1477 | 21 |
1851950 | 1851950 | 2021-10-25 | Swisher | Texas | 48437 | 1477 | 22 |
1846155 | 1846155 | 2021-10-24 | Rio Grande | Colorado | 8105 | 1477 | 22 |
1848700 | 1848700 | 2021-10-24 | Swisher | Texas | 48437 | 1477 | 22 |
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);