ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
404 rows where deaths = 469 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- New York 40
- Texas 36
- Ohio 30
- Massachusetts 29
- Louisiana 24
- California 19
- Georgia 16
- North Carolina 15
- Arizona 14
- Pennsylvania 13
- Minnesota 11
- Washington 11
- Alabama 10
- Michigan 10
- New Jersey 10
- Kansas 9
- Delaware 8
- Florida 8
- Illinois 8
- Alaska 7
- Iowa 7
- Rhode Island 7
- Virginia 7
- Colorado 6
- New Mexico 6
- Indiana 5
- Missouri 5
- South Carolina 5
- Wisconsin 5
- Arkansas 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502365 | 2502365 | 2022-05-13 | Maverick | Texas | 48323 | 20872 | 469 |
2499107 | 2499107 | 2022-05-12 | Maverick | Texas | 48323 | 20862 | 469 |
2494820 | 2494820 | 2022-05-11 | Unknown | Nebraska | 6991 | 469 | |
2495849 | 2495849 | 2022-05-11 | Maverick | Texas | 48323 | 20861 | 469 |
2492591 | 2492591 | 2022-05-10 | Maverick | Texas | 48323 | 20860 | 469 |
2470068 | 2470068 | 2022-05-03 | Benton | Washington | 53005 | 52834 | 469 |
2466812 | 2466812 | 2022-05-02 | Benton | Washington | 53005 | 52834 | 469 |
2463557 | 2463557 | 2022-05-01 | Benton | Washington | 53005 | 52716 | 469 |
2460301 | 2460301 | 2022-04-30 | Benton | Washington | 53005 | 52716 | 469 |
2457045 | 2457045 | 2022-04-29 | Benton | Washington | 53005 | 52716 | 469 |
2400548 | 2400548 | 2022-04-12 | Cabarrus | North Carolina | 37025 | 55554 | 469 |
2397293 | 2397293 | 2022-04-11 | Cabarrus | North Carolina | 37025 | 55554 | 469 |
2394038 | 2394038 | 2022-04-10 | Cabarrus | North Carolina | 37025 | 55554 | 469 |
2390782 | 2390782 | 2022-04-09 | Cabarrus | North Carolina | 37025 | 55554 | 469 |
2387526 | 2387526 | 2022-04-08 | Cabarrus | North Carolina | 37025 | 55554 | 469 |
2384271 | 2384271 | 2022-04-07 | Cabarrus | North Carolina | 37025 | 55554 | 469 |
2381016 | 2381016 | 2022-04-06 | Cabarrus | North Carolina | 37025 | 55554 | 469 |
2375938 | 2375938 | 2022-04-05 | Coconino | Arizona | 4005 | 43404 | 469 |
2376643 | 2376643 | 2022-04-05 | Black Hawk | Iowa | 19013 | 32692 | 469 |
2372686 | 2372686 | 2022-04-04 | Coconino | Arizona | 4005 | 43404 | 469 |
2373391 | 2373391 | 2022-04-04 | Black Hawk | Iowa | 19013 | 32692 | 469 |
2369433 | 2369433 | 2022-04-03 | Coconino | Arizona | 4005 | 43404 | 469 |
2370138 | 2370138 | 2022-04-03 | Black Hawk | Iowa | 19013 | 32692 | 469 |
2366180 | 2366180 | 2022-04-02 | Coconino | Arizona | 4005 | 43404 | 469 |
2366885 | 2366885 | 2022-04-02 | Black Hawk | Iowa | 19013 | 32692 | 469 |
2362927 | 2362927 | 2022-04-01 | Coconino | Arizona | 4005 | 43404 | 469 |
2363632 | 2363632 | 2022-04-01 | Black Hawk | Iowa | 19013 | 32692 | 469 |
2359673 | 2359673 | 2022-03-31 | Coconino | Arizona | 4005 | 43404 | 469 |
2360378 | 2360378 | 2022-03-31 | Black Hawk | Iowa | 19013 | 32692 | 469 |
2356419 | 2356419 | 2022-03-30 | Coconino | Arizona | 4005 | 43404 | 469 |
2357124 | 2357124 | 2022-03-30 | Black Hawk | Iowa | 19013 | 32692 | 469 |
2346789 | 2346789 | 2022-03-27 | San Luis Obispo | California | 6079 | 56136 | 469 |
2343536 | 2343536 | 2022-03-26 | San Luis Obispo | California | 6079 | 56136 | 469 |
2340283 | 2340283 | 2022-03-25 | San Luis Obispo | California | 6079 | 56136 | 469 |
2337030 | 2337030 | 2022-03-24 | San Luis Obispo | California | 6079 | 56111 | 469 |
2319096 | 2319096 | 2022-03-18 | Sussex | New Jersey | 34037 | 33626 | 469 |
2314458 | 2314458 | 2022-03-17 | Coweta | Georgia | 13077 | 32829 | 469 |
2315843 | 2315843 | 2022-03-17 | Sussex | New Jersey | 34037 | 33609 | 469 |
2312590 | 2312590 | 2022-03-16 | Sussex | New Jersey | 34037 | 33593 | 469 |
2312844 | 2312844 | 2022-03-16 | Allen | Ohio | 39003 | 27363 | 469 |
2309337 | 2309337 | 2022-03-15 | Sussex | New Jersey | 34037 | 33582 | 469 |
2309591 | 2309591 | 2022-03-15 | Allen | Ohio | 39003 | 27363 | 469 |
2306338 | 2306338 | 2022-03-14 | Allen | Ohio | 39003 | 27363 | 469 |
2303087 | 2303087 | 2022-03-13 | Allen | Ohio | 39003 | 27363 | 469 |
2299835 | 2299835 | 2022-03-12 | Allen | Ohio | 39003 | 27361 | 469 |
2296583 | 2296583 | 2022-03-11 | Allen | Ohio | 39003 | 27359 | 469 |
2293331 | 2293331 | 2022-03-10 | Allen | Ohio | 39003 | 27359 | 469 |
2290079 | 2290079 | 2022-03-09 | Allen | Ohio | 39003 | 27358 | 469 |
2286827 | 2286827 | 2022-03-08 | Allen | Ohio | 39003 | 27355 | 469 |
2282639 | 2282639 | 2022-03-07 | Bossier | Louisiana | 22015 | 37373 | 469 |
2282920 | 2282920 | 2022-03-07 | Washington | Minnesota | 27163 | 65943 | 469 |
2283628 | 2283628 | 2022-03-07 | Miami | Ohio | 39109 | 25652 | 469 |
2279386 | 2279386 | 2022-03-06 | Bossier | Louisiana | 22015 | 37351 | 469 |
2279667 | 2279667 | 2022-03-06 | Washington | Minnesota | 27163 | 65913 | 469 |
2280376 | 2280376 | 2022-03-06 | Miami | Ohio | 39109 | 25649 | 469 |
2276133 | 2276133 | 2022-03-05 | Bossier | Louisiana | 22015 | 37351 | 469 |
2276414 | 2276414 | 2022-03-05 | Washington | Minnesota | 27163 | 65913 | 469 |
2277123 | 2277123 | 2022-03-05 | Miami | Ohio | 39109 | 25646 | 469 |
2272880 | 2272880 | 2022-03-04 | Bossier | Louisiana | 22015 | 37351 | 469 |
2273161 | 2273161 | 2022-03-04 | Washington | Minnesota | 27163 | 65913 | 469 |
2273870 | 2273870 | 2022-03-04 | Miami | Ohio | 39109 | 25641 | 469 |
2268811 | 2268811 | 2022-03-03 | Middlesex | Connecticut | 9007 | 27426 | 469 |
2269909 | 2269909 | 2022-03-03 | Washington | Minnesota | 27163 | 65855 | 469 |
2271128 | 2271128 | 2022-03-03 | Angelina | Texas | 48005 | 15238 | 469 |
2265558 | 2265558 | 2022-03-02 | Middlesex | Connecticut | 9007 | 27395 | 469 |
2262461 | 2262461 | 2022-03-01 | Houston | Georgia | 13153 | 39119 | 469 |
2261561 | 2261561 | 2022-02-28 | Randall | Texas | 48381 | 37487 | 469 |
2258310 | 2258310 | 2022-02-27 | Randall | Texas | 48381 | 37478 | 469 |
2258685 | 2258685 | 2022-02-27 | Marathon | Wisconsin | 55073 | 38891 | 469 |
2255059 | 2255059 | 2022-02-26 | Randall | Texas | 48381 | 37478 | 469 |
2255434 | 2255434 | 2022-02-26 | Marathon | Wisconsin | 55073 | 38891 | 469 |
2249025 | 2249025 | 2022-02-25 | Houston | Alabama | 1069 | 24857 | 469 |
2252183 | 2252183 | 2022-02-25 | Marathon | Wisconsin | 55073 | 38891 | 469 |
2245774 | 2245774 | 2022-02-24 | Houston | Alabama | 1069 | 24833 | 469 |
2246177 | 2246177 | 2022-02-24 | Dougherty | Georgia | 13095 | 19403 | 469 |
2247216 | 2247216 | 2022-02-24 | Rankin | Mississippi | 28121 | 36251 | 469 |
2247818 | 2247818 | 2022-02-24 | Columbiana | Ohio | 39029 | 24193 | 469 |
2248932 | 2248932 | 2022-02-24 | Marathon | Wisconsin | 55073 | 38867 | 469 |
2242523 | 2242523 | 2022-02-23 | Houston | Alabama | 1069 | 24787 | 469 |
2242926 | 2242926 | 2022-02-23 | Dougherty | Georgia | 13095 | 19371 | 469 |
2243965 | 2243965 | 2022-02-23 | Rankin | Mississippi | 28121 | 36232 | 469 |
2244567 | 2244567 | 2022-02-23 | Columbiana | Ohio | 39029 | 24172 | 469 |
2239473 | 2239473 | 2022-02-22 | Sonoma | California | 6097 | 83260 | 469 |
2241316 | 2241316 | 2022-02-22 | Columbiana | Ohio | 39029 | 24163 | 469 |
2236222 | 2236222 | 2022-02-21 | Sonoma | California | 6097 | 82742 | 469 |
2236988 | 2236988 | 2022-02-21 | Wyandotte | Kansas | 20209 | 46254 | 469 |
2232971 | 2232971 | 2022-02-20 | Sonoma | California | 6097 | 82742 | 469 |
2233737 | 2233737 | 2022-02-20 | Wyandotte | Kansas | 20209 | 46196 | 469 |
2229720 | 2229720 | 2022-02-19 | Sonoma | California | 6097 | 82742 | 469 |
2230486 | 2230486 | 2022-02-19 | Wyandotte | Kansas | 20209 | 46196 | 469 |
2226469 | 2226469 | 2022-02-18 | Sonoma | California | 6097 | 82742 | 469 |
2227235 | 2227235 | 2022-02-18 | Wyandotte | Kansas | 20209 | 46196 | 469 |
2223984 | 2223984 | 2022-02-17 | Wyandotte | Kansas | 20209 | 46077 | 469 |
2225075 | 2225075 | 2022-02-17 | Greene | Ohio | 39057 | 36833 | 469 |
2225714 | 2225714 | 2022-02-17 | Hays | Texas | 48209 | 58060 | 469 |
2219907 | 2219907 | 2022-02-16 | Sebastian | Arkansas | 5131 | 32190 | 469 |
2220733 | 2220733 | 2022-02-16 | Wyandotte | Kansas | 20209 | 46077 | 469 |
2220882 | 2220882 | 2022-02-16 | Lafayette | Louisiana | 22055 | 61320 | 469 |
2221824 | 2221824 | 2022-02-16 | Greene | Ohio | 39057 | 36773 | 469 |
2222463 | 2222463 | 2022-02-16 | Hays | Texas | 48209 | 58060 | 469 |
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);