ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
417 rows where deaths = 385 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 34
- Florida 31
- California 28
- North Carolina 28
- Oklahoma 28
- Kentucky 23
- Pennsylvania 22
- Indiana 20
- Ohio 20
- Louisiana 19
- South Carolina 18
- Georgia 16
- Michigan 16
- Colorado 14
- Illinois 13
- Kansas 12
- Alabama 9
- Arkansas 8
- New York 8
- Wisconsin 8
- Virginia 5
- Arizona 4
- Maryland 4
- New Mexico 4
- Oregon 4
- South Dakota 3
- Delaware 2
- Iowa 2
- Massachusetts 2
- Mississippi 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472478 | 2472478 | 2022-05-04 | Rogers | Oklahoma | 40131 | 25427 | 385 |
2469222 | 2469222 | 2022-05-03 | Rogers | Oklahoma | 40131 | 25427 | 385 |
2465966 | 2465966 | 2022-05-02 | Rogers | Oklahoma | 40131 | 25427 | 385 |
2461521 | 2461521 | 2022-05-01 | Daviess | Kentucky | 21059 | 31104 | 385 |
2462711 | 2462711 | 2022-05-01 | Rogers | Oklahoma | 40131 | 25427 | 385 |
2458265 | 2458265 | 2022-04-30 | Daviess | Kentucky | 21059 | 31104 | 385 |
2459455 | 2459455 | 2022-04-30 | Rogers | Oklahoma | 40131 | 25427 | 385 |
2455009 | 2455009 | 2022-04-29 | Daviess | Kentucky | 21059 | 31104 | 385 |
2456199 | 2456199 | 2022-04-29 | Rogers | Oklahoma | 40131 | 25427 | 385 |
2451753 | 2451753 | 2022-04-28 | Daviess | Kentucky | 21059 | 31104 | 385 |
2452943 | 2452943 | 2022-04-28 | Rogers | Oklahoma | 40131 | 25427 | 385 |
2448497 | 2448497 | 2022-04-27 | Daviess | Kentucky | 21059 | 31104 | 385 |
2445241 | 2445241 | 2022-04-26 | Daviess | Kentucky | 21059 | 31104 | 385 |
2441985 | 2441985 | 2022-04-25 | Daviess | Kentucky | 21059 | 31104 | 385 |
2438729 | 2438729 | 2022-04-24 | Daviess | Kentucky | 21059 | 31104 | 385 |
2435473 | 2435473 | 2022-04-23 | Daviess | Kentucky | 21059 | 31104 | 385 |
2432217 | 2432217 | 2022-04-22 | Daviess | Kentucky | 21059 | 31104 | 385 |
2428961 | 2428961 | 2022-04-21 | Daviess | Kentucky | 21059 | 31104 | 385 |
2425705 | 2425705 | 2022-04-20 | Daviess | Kentucky | 21059 | 31104 | 385 |
2422449 | 2422449 | 2022-04-19 | Daviess | Kentucky | 21059 | 31104 | 385 |
2419193 | 2419193 | 2022-04-18 | Daviess | Kentucky | 21059 | 31104 | 385 |
2404046 | 2404046 | 2022-04-13 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2404125 | 2404125 | 2022-04-13 | Douglas | Oregon | 41019 | 19757 | 385 |
2400600 | 2400600 | 2022-04-12 | New Hanover | North Carolina | 37129 | 50497 | 385 |
2400791 | 2400791 | 2022-04-12 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2400870 | 2400870 | 2022-04-12 | Douglas | Oregon | 41019 | 19754 | 385 |
2397345 | 2397345 | 2022-04-11 | New Hanover | North Carolina | 37129 | 50497 | 385 |
2397536 | 2397536 | 2022-04-11 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2397615 | 2397615 | 2022-04-11 | Douglas | Oregon | 41019 | 19752 | 385 |
2394090 | 2394090 | 2022-04-10 | New Hanover | North Carolina | 37129 | 50497 | 385 |
2394281 | 2394281 | 2022-04-10 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2390834 | 2390834 | 2022-04-09 | New Hanover | North Carolina | 37129 | 50497 | 385 |
2391025 | 2391025 | 2022-04-09 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2387578 | 2387578 | 2022-04-08 | New Hanover | North Carolina | 37129 | 50497 | 385 |
2387769 | 2387769 | 2022-04-08 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2384323 | 2384323 | 2022-04-07 | New Hanover | North Carolina | 37129 | 50497 | 385 |
2384514 | 2384514 | 2022-04-07 | Canadian | Oklahoma | 40017 | 39383 | 385 |
2381068 | 2381068 | 2022-04-06 | New Hanover | North Carolina | 37129 | 50497 | 385 |
2381266 | 2381266 | 2022-04-06 | Comanche | Oklahoma | 40031 | 32948 | 385 |
2377813 | 2377813 | 2022-04-05 | New Hanover | North Carolina | 37129 | 50485 | 385 |
2378011 | 2378011 | 2022-04-05 | Comanche | Oklahoma | 40031 | 32948 | 385 |
2374560 | 2374560 | 2022-04-04 | New Hanover | North Carolina | 37129 | 50476 | 385 |
2374757 | 2374757 | 2022-04-04 | Comanche | Oklahoma | 40031 | 32948 | 385 |
2371308 | 2371308 | 2022-04-03 | New Hanover | North Carolina | 37129 | 50420 | 385 |
2371505 | 2371505 | 2022-04-03 | Comanche | Oklahoma | 40031 | 32948 | 385 |
2368055 | 2368055 | 2022-04-02 | New Hanover | North Carolina | 37129 | 50420 | 385 |
2368252 | 2368252 | 2022-04-02 | Comanche | Oklahoma | 40031 | 32948 | 385 |
2364802 | 2364802 | 2022-04-01 | New Hanover | North Carolina | 37129 | 50420 | 385 |
2364999 | 2364999 | 2022-04-01 | Comanche | Oklahoma | 40031 | 32948 | 385 |
2360023 | 2360023 | 2022-03-31 | Forsyth | Georgia | 13117 | 55351 | 385 |
2361548 | 2361548 | 2022-03-31 | New Hanover | North Carolina | 37129 | 50356 | 385 |
2361746 | 2361746 | 2022-03-31 | Comanche | Oklahoma | 40031 | 32948 | 385 |
2356769 | 2356769 | 2022-03-30 | Forsyth | Georgia | 13117 | 55335 | 385 |
2358294 | 2358294 | 2022-03-30 | New Hanover | North Carolina | 37129 | 50299 | 385 |
2359533 | 2359533 | 2022-03-30 | Rock | Wisconsin | 55105 | 42751 | 385 |
2355040 | 2355040 | 2022-03-29 | New Hanover | North Carolina | 37129 | 50222 | 385 |
2355071 | 2355071 | 2022-03-29 | Wayne | North Carolina | 37191 | 29931 | 385 |
2356279 | 2356279 | 2022-03-29 | Rock | Wisconsin | 55105 | 42727 | 385 |
2350298 | 2350298 | 2022-03-28 | Lowndes | Georgia | 13185 | 30919 | 385 |
2353026 | 2353026 | 2022-03-28 | Rock | Wisconsin | 55105 | 42706 | 385 |
2347045 | 2347045 | 2022-03-27 | Lowndes | Georgia | 13185 | 30907 | 385 |
2347623 | 2347623 | 2022-03-27 | Kenton | Kentucky | 21117 | 45444 | 385 |
2343792 | 2343792 | 2022-03-26 | Lowndes | Georgia | 13185 | 30907 | 385 |
2344370 | 2344370 | 2022-03-26 | Kenton | Kentucky | 21117 | 45444 | 385 |
2340539 | 2340539 | 2022-03-25 | Lowndes | Georgia | 13185 | 30907 | 385 |
2341117 | 2341117 | 2022-03-25 | Kenton | Kentucky | 21117 | 45444 | 385 |
2337864 | 2337864 | 2022-03-24 | Kenton | Kentucky | 21117 | 45306 | 385 |
2338776 | 2338776 | 2022-03-24 | New Hanover | North Carolina | 37129 | 50044 | 385 |
2334610 | 2334610 | 2022-03-23 | Kenton | Kentucky | 21117 | 45306 | 385 |
2335522 | 2335522 | 2022-03-23 | New Hanover | North Carolina | 37129 | 49989 | 385 |
2330334 | 2330334 | 2022-03-22 | Lauderdale | Alabama | 1077 | 24042 | 385 |
2330486 | 2330486 | 2022-03-22 | Butte | California | 6007 | 39522 | 385 |
2330547 | 2330547 | 2022-03-22 | Boulder | Colorado | 8013 | 62452 | 385 |
2331356 | 2331356 | 2022-03-22 | Kenton | Kentucky | 21117 | 45306 | 385 |
2333311 | 2333311 | 2022-03-22 | Newport News city | Virginia | 51700 | 36051 | 385 |
2327234 | 2327234 | 2022-03-21 | Butte | California | 6007 | 39519 | 385 |
2327295 | 2327295 | 2022-03-21 | Boulder | Colorado | 8013 | 62343 | 385 |
2327482 | 2327482 | 2022-03-21 | Douglas | Georgia | 13097 | 34712 | 385 |
2328104 | 2328104 | 2022-03-21 | Kenton | Kentucky | 21117 | 45306 | 385 |
2330058 | 2330058 | 2022-03-21 | Newport News city | Virginia | 51700 | 36051 | 385 |
2323838 | 2323838 | 2022-03-20 | Marshall | Alabama | 1095 | 27303 | 385 |
2323981 | 2323981 | 2022-03-20 | Butte | California | 6007 | 39483 | 385 |
2324042 | 2324042 | 2022-03-20 | Boulder | Colorado | 8013 | 62035 | 385 |
2324229 | 2324229 | 2022-03-20 | Douglas | Georgia | 13097 | 34710 | 385 |
2320584 | 2320584 | 2022-03-19 | Marshall | Alabama | 1095 | 27303 | 385 |
2320727 | 2320727 | 2022-03-19 | Butte | California | 6007 | 39483 | 385 |
2320788 | 2320788 | 2022-03-19 | Boulder | Colorado | 8013 | 62035 | 385 |
2320975 | 2320975 | 2022-03-19 | Douglas | Georgia | 13097 | 34710 | 385 |
2317330 | 2317330 | 2022-03-18 | Marshall | Alabama | 1095 | 27303 | 385 |
2317473 | 2317473 | 2022-03-18 | Butte | California | 6007 | 39483 | 385 |
2317534 | 2317534 | 2022-03-18 | Boulder | Colorado | 8013 | 62035 | 385 |
2317721 | 2317721 | 2022-03-18 | Douglas | Georgia | 13097 | 34710 | 385 |
2314220 | 2314220 | 2022-03-17 | Butte | California | 6007 | 39464 | 385 |
2314281 | 2314281 | 2022-03-17 | Boulder | Colorado | 8013 | 62035 | 385 |
2314468 | 2314468 | 2022-03-17 | Douglas | Georgia | 13097 | 34705 | 385 |
2310967 | 2310967 | 2022-03-16 | Butte | California | 6007 | 39444 | 385 |
2307714 | 2307714 | 2022-03-15 | Butte | California | 6007 | 39434 | 385 |
2286602 | 2286602 | 2022-03-08 | Sandoval | New Mexico | 35043 | 33102 | 385 |
2287857 | 2287857 | 2022-03-08 | Thurston | Washington | 53067 | 45890 | 385 |
2284605 | 2284605 | 2022-03-07 | Thurston | Washington | 53067 | 45890 | 385 |
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);