ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
316 rows where cases = 2119 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 27
- Texas 26
- Kansas 22
- Virginia 21
- Arkansas 16
- South Dakota 16
- Tennessee 16
- Kentucky 15
- Missouri 12
- Iowa 10
- Mississippi 10
- Illinois 9
- Minnesota 9
- North Carolina 9
- Oklahoma 8
- Alabama 7
- Indiana 7
- Michigan 7
- Utah 7
- Colorado 5
- Maine 5
- Montana 5
- West Virginia 5
- Wisconsin 4
- California 3
- Massachusetts 3
- Nebraska 3
- New York 3
- North Dakota 3
- Ohio 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2454150 | 2454150 | 2022-04-29 | Searcy | Arkansas | 5129 | 2119 | 48 |
2450894 | 2450894 | 2022-04-28 | Searcy | Arkansas | 5129 | 2119 | 48 |
2447638 | 2447638 | 2022-04-27 | Searcy | Arkansas | 5129 | 2119 | 48 |
2428827 | 2428827 | 2022-04-21 | Anderson | Kansas | 20003 | 2119 | 29 |
2425571 | 2425571 | 2022-04-20 | Anderson | Kansas | 20003 | 2119 | 29 |
2422315 | 2422315 | 2022-04-19 | Anderson | Kansas | 20003 | 2119 | 29 |
2419059 | 2419059 | 2022-04-18 | Anderson | Kansas | 20003 | 2119 | 29 |
2415803 | 2415803 | 2022-04-17 | Anderson | Kansas | 20003 | 2119 | 29 |
2412547 | 2412547 | 2022-04-16 | Anderson | Kansas | 20003 | 2119 | 29 |
2409291 | 2409291 | 2022-04-15 | Anderson | Kansas | 20003 | 2119 | 29 |
2356743 | 2356743 | 2022-03-30 | Clinch | Georgia | 13065 | 2119 | 42 |
2353490 | 2353490 | 2022-03-29 | Clinch | Georgia | 13065 | 2119 | 42 |
2350238 | 2350238 | 2022-03-28 | Clinch | Georgia | 13065 | 2119 | 41 |
2346985 | 2346985 | 2022-03-27 | Clinch | Georgia | 13065 | 2119 | 41 |
2343732 | 2343732 | 2022-03-26 | Clinch | Georgia | 13065 | 2119 | 41 |
2340479 | 2340479 | 2022-03-25 | Clinch | Georgia | 13065 | 2119 | 41 |
2337226 | 2337226 | 2022-03-24 | Clinch | Georgia | 13065 | 2119 | 41 |
2333972 | 2333972 | 2022-03-23 | Clinch | Georgia | 13065 | 2119 | 41 |
2330718 | 2330718 | 2022-03-22 | Clinch | Georgia | 13065 | 2119 | 41 |
2329676 | 2329676 | 2022-03-21 | Archer | Texas | 48009 | 2119 | 28 |
2324213 | 2324213 | 2022-03-20 | Clinch | Georgia | 13065 | 2119 | 40 |
2324760 | 2324760 | 2022-03-20 | Pawnee | Kansas | 20145 | 2119 | 24 |
2326424 | 2326424 | 2022-03-20 | Archer | Texas | 48009 | 2119 | 28 |
2320959 | 2320959 | 2022-03-19 | Clinch | Georgia | 13065 | 2119 | 40 |
2321506 | 2321506 | 2022-03-19 | Pawnee | Kansas | 20145 | 2119 | 24 |
2323171 | 2323171 | 2022-03-19 | Archer | Texas | 48009 | 2119 | 28 |
2317705 | 2317705 | 2022-03-18 | Clinch | Georgia | 13065 | 2119 | 40 |
2318252 | 2318252 | 2022-03-18 | Pawnee | Kansas | 20145 | 2119 | 24 |
2319917 | 2319917 | 2022-03-18 | Archer | Texas | 48009 | 2119 | 28 |
2316663 | 2316663 | 2022-03-17 | Archer | Texas | 48009 | 2119 | 28 |
2313410 | 2313410 | 2022-03-16 | Archer | Texas | 48009 | 2119 | 28 |
2310157 | 2310157 | 2022-03-15 | Archer | Texas | 48009 | 2119 | 28 |
2305888 | 2305888 | 2022-03-14 | Beaverhead | Montana | 30001 | 2119 | 28 |
2292234 | 2292234 | 2022-03-10 | Pawnee | Kansas | 20145 | 2119 | 23 |
2288982 | 2288982 | 2022-03-09 | Pawnee | Kansas | 20145 | 2119 | 23 |
2278741 | 2278741 | 2022-03-06 | Macon | Georgia | 13193 | 2119 | 48 |
2275488 | 2275488 | 2022-03-05 | Macon | Georgia | 13193 | 2119 | 48 |
2272235 | 2272235 | 2022-03-04 | Macon | Georgia | 13193 | 2119 | 48 |
2268983 | 2268983 | 2022-03-03 | Macon | Georgia | 13193 | 2119 | 48 |
2251796 | 2251796 | 2022-02-25 | Ochiltree | Texas | 48357 | 2119 | 46 |
2240597 | 2240597 | 2022-02-22 | Jackson | Minnesota | 27063 | 2119 | 17 |
2225758 | 2225758 | 2022-02-17 | Live Oak | Texas | 48297 | 2119 | 40 |
2219496 | 2219496 | 2022-02-15 | Northampton | Virginia | 51131 | 2119 | 54 |
2214774 | 2214774 | 2022-02-14 | Iron | Missouri | 29093 | 2119 | 35 |
2216247 | 2216247 | 2022-02-14 | Northumberland | Virginia | 51133 | 2119 | 42 |
2210612 | 2210612 | 2022-02-13 | Hamilton | Illinois | 17065 | 2119 | 31 |
2211520 | 2211520 | 2022-02-13 | Howard | Missouri | 29089 | 2119 | 23 |
2207359 | 2207359 | 2022-02-12 | Hamilton | Illinois | 17065 | 2119 | 31 |
2208267 | 2208267 | 2022-02-12 | Howard | Missouri | 29089 | 2119 | 23 |
2204106 | 2204106 | 2022-02-11 | Hamilton | Illinois | 17065 | 2119 | 31 |
2205014 | 2205014 | 2022-02-11 | Howard | Missouri | 29089 | 2119 | 23 |
2200853 | 2200853 | 2022-02-10 | Hamilton | Illinois | 17065 | 2119 | 31 |
2201761 | 2201761 | 2022-02-10 | Howard | Missouri | 29089 | 2119 | 23 |
2198923 | 2198923 | 2022-02-09 | Jones | North Carolina | 37103 | 2119 | 38 |
2178023 | 2178023 | 2022-02-03 | Clearwater | Idaho | 16035 | 2119 | 31 |
2177304 | 2177304 | 2022-02-02 | Clay | West Virginia | 54015 | 2119 | 31 |
2156296 | 2156296 | 2022-01-27 | Deer Lodge | Montana | 30023 | 2119 | 29 |
2157481 | 2157481 | 2022-01-27 | Parmer | Texas | 48369 | 2119 | 46 |
2154243 | 2154243 | 2022-01-26 | Runnels | Texas | 48399 | 2119 | 59 |
2125141 | 2125141 | 2022-01-17 | Manassas Park city | Virginia | 51685 | 2119 | 16 |
2110128 | 2110128 | 2022-01-13 | Wilson | Kansas | 20205 | 2119 | 35 |
2106877 | 2106877 | 2022-01-12 | Wilson | Kansas | 20205 | 2119 | 35 |
2086012 | 2086012 | 2022-01-05 | Morgan | Utah | 49029 | 2119 | 13 |
2082760 | 2082760 | 2022-01-04 | Morgan | Utah | 49029 | 2119 | 14 |
2061495 | 2061495 | 2021-12-29 | Claiborne | Louisiana | 22027 | 2119 | 66 |
2063277 | 2063277 | 2021-12-29 | Lamoille | Vermont | 50015 | 2119 | 11 |
2058604 | 2058604 | 2021-12-28 | Webster | Mississippi | 28155 | 2119 | 49 |
2016277 | 2016277 | 2021-12-15 | Amite | Mississippi | 28005 | 2119 | 57 |
1986221 | 1986221 | 2021-12-06 | Cumberland | Illinois | 17035 | 2119 | 39 |
1975175 | 1975175 | 2021-12-02 | Jackson | Tennessee | 47087 | 2119 | 41 |
1975493 | 1975493 | 2021-12-02 | Juab | Utah | 49023 | 2119 | 19 |
1965095 | 1965095 | 2021-11-29 | Hood River | Oregon | 41027 | 2119 | 37 |
1960794 | 1960794 | 2021-11-28 | Lincoln | Maine | 23015 | 2119 | 9 |
1957543 | 1957543 | 2021-11-27 | Lincoln | Maine | 23015 | 2119 | 9 |
1954292 | 1954292 | 2021-11-26 | Lincoln | Maine | 23015 | 2119 | 9 |
1951041 | 1951041 | 2021-11-25 | Lincoln | Maine | 23015 | 2119 | 9 |
1941422 | 1941422 | 2021-11-22 | Aitkin | Minnesota | 27001 | 2119 | 48 |
1937131 | 1937131 | 2021-11-21 | Moffat | Colorado | 8081 | 2119 | 47 |
1933881 | 1933881 | 2021-11-20 | Moffat | Colorado | 8081 | 2119 | 47 |
1930629 | 1930629 | 2021-11-19 | Moffat | Colorado | 8081 | 2119 | 47 |
1925809 | 1925809 | 2021-11-17 | Mitchell | North Carolina | 37121 | 2119 | 21 |
1926101 | 1926101 | 2021-11-17 | Tillamook | Oregon | 41057 | 2119 | 42 |
1921560 | 1921560 | 2021-11-16 | Osage | Kansas | 20139 | 2119 | 39 |
1922823 | 1922823 | 2021-11-16 | Baker | Oregon | 41001 | 2119 | 30 |
1918310 | 1918310 | 2021-11-15 | Osage | Kansas | 20139 | 2119 | 39 |
1907350 | 1907350 | 2021-11-11 | Martinsville city | Virginia | 51690 | 2119 | 89 |
1894676 | 1894676 | 2021-11-08 | Kusilvak Census Area | Alaska | 2158 | 2119 | 8 |
1871732 | 1871732 | 2021-10-31 | Morgan | West Virginia | 54065 | 2119 | 44 |
1855542 | 1855542 | 2021-10-26 | Lafayette | Wisconsin | 55065 | 2119 | 12 |
1848959 | 1848959 | 2021-10-24 | Braxton | West Virginia | 54007 | 2119 | 18 |
1836577 | 1836577 | 2021-10-21 | Jasper | Georgia | 13159 | 2119 | 58 |
1829765 | 1829765 | 2021-10-19 | Marion | Arkansas | 5089 | 2119 | 57 |
1830307 | 1830307 | 2021-10-19 | Washington | Illinois | 17189 | 2119 | 34 |
1831064 | 1831064 | 2021-10-19 | Lawrence | Mississippi | 28077 | 2119 | 40 |
1832219 | 1832219 | 2021-10-19 | Stewart | Tennessee | 47161 | 2119 | 34 |
1828970 | 1828970 | 2021-10-18 | Stewart | Tennessee | 47161 | 2119 | 34 |
1808217 | 1808217 | 2021-10-12 | Faribault | Minnesota | 27043 | 2119 | 27 |
1793596 | 1793596 | 2021-10-07 | Giles | Virginia | 51071 | 2119 | 28 |
1784768 | 1784768 | 2021-10-05 | Jo Daviess | Illinois | 17085 | 2119 | 30 |
1786156 | 1786156 | 2021-10-05 | McKenzie | North Dakota | 38053 | 2119 | 17 |
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);