ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
379 rows where deaths = 491 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 42
- Georgia 30
- Pennsylvania 30
- Louisiana 29
- South Carolina 29
- Ohio 20
- Kansas 15
- Illinois 13
- New Mexico 13
- Wisconsin 13
- Alabama 12
- Michigan 12
- California 10
- Idaho 10
- North Carolina 10
- Tennessee 10
- Arizona 9
- Arkansas 9
- New Jersey 9
- Indiana 8
- Minnesota 7
- Rhode Island 7
- Colorado 5
- New York 5
- Oregon 5
- Virginia 4
- Florida 2
- Maryland 2
- District of Columbia 1
- Hawaii 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500003 | 2500003 | 2022-05-13 | Coweta | Georgia | 13077 | 33335 | 491 |
2502774 | 2502774 | 2022-05-13 | Marathon | Wisconsin | 55073 | 40330 | 491 |
2496745 | 2496745 | 2022-05-12 | Coweta | Georgia | 13077 | 33335 | 491 |
2499516 | 2499516 | 2022-05-12 | Marathon | Wisconsin | 55073 | 40243 | 491 |
2493487 | 2493487 | 2022-05-11 | Coweta | Georgia | 13077 | 33335 | 491 |
2496258 | 2496258 | 2022-05-11 | Marathon | Wisconsin | 55073 | 40201 | 491 |
2461619 | 2461619 | 2022-05-01 | Bossier | Louisiana | 22015 | 37547 | 491 |
2458363 | 2458363 | 2022-04-30 | Bossier | Louisiana | 22015 | 37547 | 491 |
2455107 | 2455107 | 2022-04-29 | Bossier | Louisiana | 22015 | 37547 | 491 |
2451851 | 2451851 | 2022-04-28 | Bossier | Louisiana | 22015 | 37542 | 491 |
2448595 | 2448595 | 2022-04-27 | Bossier | Louisiana | 22015 | 37537 | 491 |
2449905 | 2449905 | 2022-04-27 | Dorchester | South Carolina | 45035 | 55962 | 491 |
2446648 | 2446648 | 2022-04-26 | Dorchester | South Carolina | 45035 | 55962 | 491 |
2443393 | 2443393 | 2022-04-25 | Dorchester | South Carolina | 45035 | 55962 | 491 |
2440137 | 2440137 | 2022-04-24 | Dorchester | South Carolina | 45035 | 55962 | 491 |
2436881 | 2436881 | 2022-04-23 | Dorchester | South Carolina | 45035 | 55962 | 491 |
2433625 | 2433625 | 2022-04-22 | Dorchester | South Carolina | 45035 | 55962 | 491 |
2430369 | 2430369 | 2022-04-21 | Dorchester | South Carolina | 45035 | 55962 | 491 |
2427113 | 2427113 | 2022-04-20 | Dorchester | South Carolina | 45035 | 55962 | 491 |
2423857 | 2423857 | 2022-04-19 | Dorchester | South Carolina | 45035 | 55962 | 491 |
2419291 | 2419291 | 2022-04-18 | Bossier | Louisiana | 22015 | 37507 | 491 |
2420601 | 2420601 | 2022-04-18 | Dorchester | South Carolina | 45035 | 55906 | 491 |
2421118 | 2421118 | 2022-04-18 | Chesapeake city | Virginia | 51550 | 50129 | 491 |
2416035 | 2416035 | 2022-04-17 | Bossier | Louisiana | 22015 | 37499 | 491 |
2417345 | 2417345 | 2022-04-17 | Dorchester | South Carolina | 45035 | 55906 | 491 |
2412779 | 2412779 | 2022-04-16 | Bossier | Louisiana | 22015 | 37499 | 491 |
2414089 | 2414089 | 2022-04-16 | Dorchester | South Carolina | 45035 | 55906 | 491 |
2409523 | 2409523 | 2022-04-15 | Bossier | Louisiana | 22015 | 37499 | 491 |
2410833 | 2410833 | 2022-04-15 | Dorchester | South Carolina | 45035 | 55906 | 491 |
2405602 | 2405602 | 2022-04-14 | Houston | Georgia | 13153 | 39353 | 491 |
2406267 | 2406267 | 2022-04-14 | Bossier | Louisiana | 22015 | 37499 | 491 |
2407577 | 2407577 | 2022-04-14 | Dorchester | South Carolina | 45035 | 55906 | 491 |
2402318 | 2402318 | 2022-04-13 | Dougherty | Georgia | 13095 | 19588 | 491 |
2402347 | 2402347 | 2022-04-13 | Houston | Georgia | 13153 | 39349 | 491 |
2403011 | 2403011 | 2022-04-13 | Bossier | Louisiana | 22015 | 37495 | 491 |
2404321 | 2404321 | 2022-04-13 | Dorchester | South Carolina | 45035 | 55906 | 491 |
2399063 | 2399063 | 2022-04-12 | Dougherty | Georgia | 13095 | 19574 | 491 |
2399092 | 2399092 | 2022-04-12 | Houston | Georgia | 13153 | 39341 | 491 |
2399757 | 2399757 | 2022-04-12 | Bossier | Louisiana | 22015 | 37492 | 491 |
2401066 | 2401066 | 2022-04-12 | Dorchester | South Carolina | 45035 | 55906 | 491 |
2395837 | 2395837 | 2022-04-11 | Houston | Georgia | 13153 | 39330 | 491 |
2396501 | 2396501 | 2022-04-11 | Bossier | Louisiana | 22015 | 37490 | 491 |
2392581 | 2392581 | 2022-04-10 | Houston | Georgia | 13153 | 39323 | 491 |
2393246 | 2393246 | 2022-04-10 | Bossier | Louisiana | 22015 | 37486 | 491 |
2389325 | 2389325 | 2022-04-09 | Houston | Georgia | 13153 | 39323 | 491 |
2389990 | 2389990 | 2022-04-09 | Bossier | Louisiana | 22015 | 37486 | 491 |
2386070 | 2386070 | 2022-04-08 | Houston | Georgia | 13153 | 39323 | 491 |
2386734 | 2386734 | 2022-04-08 | Bossier | Louisiana | 22015 | 37486 | 491 |
2382815 | 2382815 | 2022-04-07 | Houston | Georgia | 13153 | 39322 | 491 |
2383479 | 2383479 | 2022-04-07 | Bossier | Louisiana | 22015 | 37484 | 491 |
2380224 | 2380224 | 2022-04-06 | Bossier | Louisiana | 22015 | 37483 | 491 |
2376969 | 2376969 | 2022-04-05 | Bossier | Louisiana | 22015 | 37476 | 491 |
2370336 | 2370336 | 2022-04-03 | Wyandotte | Kansas | 20209 | 46780 | 491 |
2372154 | 2372154 | 2022-04-03 | Randall | Texas | 48381 | 38126 | 491 |
2367083 | 2367083 | 2022-04-02 | Wyandotte | Kansas | 20209 | 46780 | 491 |
2368901 | 2368901 | 2022-04-02 | Randall | Texas | 48381 | 38126 | 491 |
2363830 | 2363830 | 2022-04-01 | Wyandotte | Kansas | 20209 | 46780 | 491 |
2365648 | 2365648 | 2022-04-01 | Randall | Texas | 48381 | 38126 | 491 |
2360576 | 2360576 | 2022-03-31 | Wyandotte | Kansas | 20209 | 46773 | 491 |
2362395 | 2362395 | 2022-03-31 | Randall | Texas | 48381 | 38124 | 491 |
2357322 | 2357322 | 2022-03-30 | Wyandotte | Kansas | 20209 | 46773 | 491 |
2358466 | 2358466 | 2022-03-30 | Tuscarawas | Ohio | 39157 | 20563 | 491 |
2354069 | 2354069 | 2022-03-29 | Wyandotte | Kansas | 20209 | 46762 | 491 |
2355212 | 2355212 | 2022-03-29 | Tuscarawas | Ohio | 39157 | 20563 | 491 |
2350817 | 2350817 | 2022-03-28 | Wyandotte | Kansas | 20209 | 46762 | 491 |
2351959 | 2351959 | 2022-03-28 | Tuscarawas | Ohio | 39157 | 20563 | 491 |
2347564 | 2347564 | 2022-03-27 | Wyandotte | Kansas | 20209 | 46750 | 491 |
2348707 | 2348707 | 2022-03-27 | Tuscarawas | Ohio | 39157 | 20563 | 491 |
2344311 | 2344311 | 2022-03-26 | Wyandotte | Kansas | 20209 | 46750 | 491 |
2345454 | 2345454 | 2022-03-26 | Tuscarawas | Ohio | 39157 | 20563 | 491 |
2341058 | 2341058 | 2022-03-25 | Wyandotte | Kansas | 20209 | 46750 | 491 |
2342201 | 2342201 | 2022-03-25 | Tuscarawas | Ohio | 39157 | 20563 | 491 |
2338948 | 2338948 | 2022-03-24 | Tuscarawas | Ohio | 39157 | 20563 | 491 |
2334700 | 2334700 | 2022-03-23 | Lafayette | Louisiana | 22055 | 62210 | 491 |
2331446 | 2331446 | 2022-03-22 | Lafayette | Louisiana | 22055 | 62204 | 491 |
2328194 | 2328194 | 2022-03-21 | Lafayette | Louisiana | 22055 | 62201 | 491 |
2313570 | 2313570 | 2022-03-16 | Midland | Texas | 48329 | 38620 | 491 |
2310317 | 2310317 | 2022-03-15 | Midland | Texas | 48329 | 38411 | 491 |
2307064 | 2307064 | 2022-03-14 | Midland | Texas | 48329 | 38217 | 491 |
2307441 | 2307441 | 2022-03-14 | Dane | Wisconsin | 55025 | 122935 | 491 |
2303813 | 2303813 | 2022-03-13 | Midland | Texas | 48329 | 38217 | 491 |
2300561 | 2300561 | 2022-03-12 | Midland | Texas | 48329 | 38217 | 491 |
2297309 | 2297309 | 2022-03-11 | Midland | Texas | 48329 | 38042 | 491 |
2293575 | 2293575 | 2022-03-10 | Mercer | Pennsylvania | 42085 | 23224 | 491 |
2294057 | 2294057 | 2022-03-10 | Midland | Texas | 48329 | 37790 | 491 |
2294434 | 2294434 | 2022-03-10 | Dane | Wisconsin | 55025 | 122746 | 491 |
2291182 | 2291182 | 2022-03-09 | Dane | Wisconsin | 55025 | 122671 | 491 |
2285453 | 2285453 | 2022-03-08 | Tazewell | Illinois | 17179 | 36337 | 491 |
2287176 | 2287176 | 2022-03-08 | Kent | Rhode Island | 44003 | 47311 | 491 |
2282201 | 2282201 | 2022-03-07 | Tazewell | Illinois | 17179 | 36330 | 491 |
2283924 | 2283924 | 2022-03-07 | Kent | Rhode Island | 44003 | 47311 | 491 |
2278948 | 2278948 | 2022-03-06 | Tazewell | Illinois | 17179 | 36311 | 491 |
2280672 | 2280672 | 2022-03-06 | Kent | Rhode Island | 44003 | 47311 | 491 |
2280989 | 2280989 | 2022-03-06 | Hays | Texas | 48209 | 59631 | 491 |
2275695 | 2275695 | 2022-03-05 | Tazewell | Illinois | 17179 | 36311 | 491 |
2277419 | 2277419 | 2022-03-05 | Kent | Rhode Island | 44003 | 47311 | 491 |
2277736 | 2277736 | 2022-03-05 | Hays | Texas | 48209 | 59631 | 491 |
2272442 | 2272442 | 2022-03-04 | Tazewell | Illinois | 17179 | 36311 | 491 |
2274166 | 2274166 | 2022-03-04 | Kent | Rhode Island | 44003 | 47311 | 491 |
2274483 | 2274483 | 2022-03-04 | Hays | Texas | 48209 | 59631 | 491 |
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);