ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
353 rows where deaths = 465 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 39
- Alabama 31
- Minnesota 24
- Florida 23
- North Carolina 17
- Louisiana 16
- Georgia 15
- Tennessee 15
- Ohio 14
- Pennsylvania 14
- California 13
- Iowa 12
- Michigan 12
- Oregon 11
- New Mexico 9
- New York 9
- Delaware 8
- Illinois 7
- Oklahoma 7
- Virginia 7
- Wisconsin 7
- Arizona 5
- Mississippi 5
- South Carolina 5
- Washington 5
- Massachusetts 4
- Utah 4
- Maryland 3
- New Jersey 3
- Indiana 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501336 | 2501336 | 2022-05-13 | Unknown | Nebraska | 6856 | 465 | |
2491760 | 2491760 | 2022-05-10 | Iredell | North Carolina | 37097 | 48772 | 465 |
2488502 | 2488502 | 2022-05-09 | Iredell | North Carolina | 37097 | 48772 | 465 |
2485245 | 2485245 | 2022-05-08 | Iredell | North Carolina | 37097 | 48772 | 465 |
2481987 | 2481987 | 2022-05-07 | Iredell | North Carolina | 37097 | 48772 | 465 |
2478729 | 2478729 | 2022-05-06 | Iredell | North Carolina | 37097 | 48772 | 465 |
2475471 | 2475471 | 2022-05-05 | Iredell | North Carolina | 37097 | 48772 | 465 |
2472214 | 2472214 | 2022-05-04 | Iredell | North Carolina | 37097 | 48772 | 465 |
2448619 | 2448619 | 2022-04-27 | Livingston | Louisiana | 22063 | 37129 | 465 |
2445363 | 2445363 | 2022-04-26 | Livingston | Louisiana | 22063 | 37126 | 465 |
2433974 | 2433974 | 2022-04-22 | Maverick | Texas | 48323 | 20821 | 465 |
2430718 | 2430718 | 2022-04-21 | Maverick | Texas | 48323 | 20821 | 465 |
2427462 | 2427462 | 2022-04-20 | Maverick | Texas | 48323 | 20821 | 465 |
2424206 | 2424206 | 2022-04-19 | Maverick | Texas | 48323 | 20817 | 465 |
2420950 | 2420950 | 2022-04-18 | Maverick | Texas | 48323 | 20816 | 465 |
2354369 | 2354369 | 2022-03-29 | Monroe | Michigan | 26115 | 37870 | 465 |
2351117 | 2351117 | 2022-03-28 | Monroe | Michigan | 26115 | 37870 | 465 |
2333776 | 2333776 | 2022-03-23 | San Luis Obispo | California | 6079 | 55991 | 465 |
2331099 | 2331099 | 2022-03-22 | Black Hawk | Iowa | 19013 | 32608 | 465 |
2327847 | 2327847 | 2022-03-21 | Black Hawk | Iowa | 19013 | 32608 | 465 |
2324594 | 2324594 | 2022-03-20 | Black Hawk | Iowa | 19013 | 32608 | 465 |
2321340 | 2321340 | 2022-03-19 | Black Hawk | Iowa | 19013 | 32608 | 465 |
2318086 | 2318086 | 2022-03-18 | Black Hawk | Iowa | 19013 | 32608 | 465 |
2314833 | 2314833 | 2022-03-17 | Black Hawk | Iowa | 19013 | 32608 | 465 |
2315950 | 2315950 | 2022-03-17 | Cabarrus | North Carolina | 37025 | 55249 | 465 |
2311580 | 2311580 | 2022-03-16 | Black Hawk | Iowa | 19013 | 32608 | 465 |
2312697 | 2312697 | 2022-03-16 | Cabarrus | North Carolina | 37025 | 55220 | 465 |
2309444 | 2309444 | 2022-03-15 | Cabarrus | North Carolina | 37025 | 55176 | 465 |
2310152 | 2310152 | 2022-03-15 | Wilson | Tennessee | 47189 | 41449 | 465 |
2306191 | 2306191 | 2022-03-14 | Cabarrus | North Carolina | 37025 | 55169 | 465 |
2306899 | 2306899 | 2022-03-14 | Wilson | Tennessee | 47189 | 41449 | 465 |
2302940 | 2302940 | 2022-03-13 | Cabarrus | North Carolina | 37025 | 55133 | 465 |
2303648 | 2303648 | 2022-03-13 | Wilson | Tennessee | 47189 | 41449 | 465 |
2299688 | 2299688 | 2022-03-12 | Cabarrus | North Carolina | 37025 | 55133 | 465 |
2300396 | 2300396 | 2022-03-12 | Wilson | Tennessee | 47189 | 41449 | 465 |
2296436 | 2296436 | 2022-03-11 | Cabarrus | North Carolina | 37025 | 55133 | 465 |
2297144 | 2297144 | 2022-03-11 | Wilson | Tennessee | 47189 | 41449 | 465 |
2293892 | 2293892 | 2022-03-10 | Wilson | Tennessee | 47189 | 41449 | 465 |
2290640 | 2290640 | 2022-03-09 | Wilson | Tennessee | 47189 | 41449 | 465 |
2281938 | 2281938 | 2022-03-07 | Coweta | Georgia | 13077 | 32791 | 465 |
2278685 | 2278685 | 2022-03-06 | Coweta | Georgia | 13077 | 32775 | 465 |
2281211 | 2281211 | 2022-03-06 | Chesapeake city | Virginia | 51550 | 49397 | 465 |
2275432 | 2275432 | 2022-03-05 | Coweta | Georgia | 13077 | 32775 | 465 |
2277958 | 2277958 | 2022-03-05 | Chesapeake city | Virginia | 51550 | 49397 | 465 |
2272179 | 2272179 | 2022-03-04 | Coweta | Georgia | 13077 | 32775 | 465 |
2274705 | 2274705 | 2022-03-04 | Chesapeake city | Virginia | 51550 | 49397 | 465 |
2268927 | 2268927 | 2022-03-03 | Coweta | Georgia | 13077 | 32765 | 465 |
2270617 | 2270617 | 2022-03-03 | Miami | Ohio | 39109 | 25632 | 465 |
2265674 | 2265674 | 2022-03-02 | Coweta | Georgia | 13077 | 32760 | 465 |
2267365 | 2267365 | 2022-03-02 | Miami | Ohio | 39109 | 25626 | 465 |
2267497 | 2267497 | 2022-03-02 | Lane | Oregon | 41039 | 56307 | 465 |
2264112 | 2264112 | 2022-03-01 | Miami | Ohio | 39109 | 25620 | 465 |
2264244 | 2264244 | 2022-03-01 | Lane | Oregon | 41039 | 56239 | 465 |
2257738 | 2257738 | 2022-02-27 | Jackson | Oregon | 41029 | 41904 | 465 |
2254487 | 2254487 | 2022-02-26 | Jackson | Oregon | 41029 | 41904 | 465 |
2251236 | 2251236 | 2022-02-25 | Jackson | Oregon | 41029 | 41904 | 465 |
2246052 | 2246052 | 2022-02-24 | Middlesex | Connecticut | 9007 | 27283 | 465 |
2246206 | 2246206 | 2022-02-24 | Houston | Georgia | 13153 | 39071 | 465 |
2247985 | 2247985 | 2022-02-24 | Jackson | Oregon | 41029 | 41841 | 465 |
2240648 | 2240648 | 2022-02-22 | Washington | Minnesota | 27163 | 65449 | 465 |
2240714 | 2240714 | 2022-02-22 | Rankin | Mississippi | 28121 | 36205 | 465 |
2237463 | 2237463 | 2022-02-21 | Rankin | Mississippi | 28121 | 36141 | 465 |
2239179 | 2239179 | 2022-02-21 | Marathon | Wisconsin | 55073 | 38789 | 465 |
2234212 | 2234212 | 2022-02-20 | Rankin | Mississippi | 28121 | 36141 | 465 |
2235928 | 2235928 | 2022-02-20 | Marathon | Wisconsin | 55073 | 38725 | 465 |
2230961 | 2230961 | 2022-02-19 | Rankin | Mississippi | 28121 | 36141 | 465 |
2232677 | 2232677 | 2022-02-19 | Marathon | Wisconsin | 55073 | 38725 | 465 |
2227710 | 2227710 | 2022-02-18 | Rankin | Mississippi | 28121 | 36141 | 465 |
2229426 | 2229426 | 2022-02-18 | Marathon | Wisconsin | 55073 | 38725 | 465 |
2213894 | 2213894 | 2022-02-14 | McHenry | Illinois | 17111 | 73948 | 465 |
2200135 | 2200135 | 2022-02-09 | Dane | Wisconsin | 55025 | 119004 | 465 |
2179756 | 2179756 | 2022-02-03 | Mercer | Pennsylvania | 42085 | 22681 | 465 |
2147177 | 2147177 | 2022-01-24 | Washington | Oregon | 41067 | 71639 | 465 |
2127237 | 2127237 | 2022-01-18 | Albany | New York | 36001 | 52146 | 465 |
2113597 | 2113597 | 2022-01-14 | Harford | Maryland | 24025 | 33269 | 465 |
2111276 | 2111276 | 2022-01-13 | Warren | Ohio | 39165 | 46009 | 465 |
2108024 | 2108024 | 2022-01-12 | Warren | Ohio | 39165 | 45399 | 465 |
2104773 | 2104773 | 2022-01-11 | Warren | Ohio | 39165 | 45004 | 465 |
2060457 | 2060457 | 2021-12-29 | Cochise | Arizona | 4003 | 19909 | 465 |
2030475 | 2030475 | 2021-12-19 | Sumner | Tennessee | 47165 | 36119 | 465 |
2027224 | 2027224 | 2021-12-18 | Sumner | Tennessee | 47165 | 36119 | 465 |
2023973 | 2023973 | 2021-12-17 | Sumner | Tennessee | 47165 | 36119 | 465 |
2016529 | 2016529 | 2021-12-15 | Yellowstone | Montana | 30111 | 31735 | 465 |
2004184 | 2004184 | 2021-12-11 | Washington | Pennsylvania | 42125 | 31916 | 465 |
1992334 | 1992334 | 2021-12-08 | Shasta | California | 6089 | 26397 | 465 |
1989083 | 1989083 | 2021-12-07 | Shasta | California | 6089 | 26359 | 465 |
1962271 | 1962271 | 2021-11-28 | Comal | Texas | 48091 | 20177 | 465 |
1959020 | 1959020 | 2021-11-27 | Comal | Texas | 48091 | 20177 | 465 |
1955769 | 1955769 | 2021-11-26 | Comal | Texas | 48091 | 20177 | 465 |
1952518 | 1952518 | 2021-11-25 | Comal | Texas | 48091 | 20177 | 465 |
1949267 | 1949267 | 2021-11-24 | Comal | Texas | 48091 | 20152 | 465 |
1943562 | 1943562 | 2021-11-23 | Placer | California | 6061 | 41836 | 465 |
1943663 | 1943663 | 2021-11-23 | Kent | Delaware | 10001 | 27633 | 465 |
1940312 | 1940312 | 2021-11-22 | Placer | California | 6061 | 41809 | 465 |
1940413 | 1940413 | 2021-11-22 | Kent | Delaware | 10001 | 27584 | 465 |
1937163 | 1937163 | 2021-11-21 | Kent | Delaware | 10001 | 27536 | 465 |
1933913 | 1933913 | 2021-11-20 | Kent | Delaware | 10001 | 27437 | 465 |
1914474 | 1914474 | 2021-11-14 | St. Johns | Florida | 12109 | 40955 | 465 |
1914476 | 1914476 | 2021-11-14 | Sumter | Florida | 12119 | 14652 | 465 |
1911224 | 1911224 | 2021-11-13 | St. Johns | Florida | 12109 | 40955 | 465 |
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);