ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
529 rows where deaths = 393 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 56
- Texas 55
- Florida 39
- Michigan 39
- South Carolina 38
- Georgia 28
- Tennessee 28
- Illinois 23
- Pennsylvania 18
- Mississippi 17
- Virginia 16
- Alabama 15
- Ohio 14
- Indiana 12
- Arkansas 11
- California 11
- Washington 10
- Iowa 8
- Oklahoma 8
- Oregon 8
- Louisiana 7
- South Dakota 7
- Alaska 6
- Arizona 6
- Delaware 6
- Colorado 5
- Kansas 5
- Utah 5
- Connecticut 4
- Maryland 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493106 | 2493106 | 2022-05-11 | Marshall | Alabama | 1095 | 27418 | 393 |
2495304 | 2495304 | 2022-05-11 | Douglas | Oregon | 41019 | 19977 | 393 |
2489848 | 2489848 | 2022-05-10 | Marshall | Alabama | 1095 | 27414 | 393 |
2491776 | 2491776 | 2022-05-10 | New Hanover | North Carolina | 37129 | 51157 | 393 |
2492267 | 2492267 | 2022-05-10 | Sumter | South Carolina | 45085 | 27967 | 393 |
2486591 | 2486591 | 2022-05-09 | Marshall | Alabama | 1095 | 27405 | 393 |
2488518 | 2488518 | 2022-05-09 | New Hanover | North Carolina | 37129 | 51157 | 393 |
2489009 | 2489009 | 2022-05-09 | Sumter | South Carolina | 45085 | 27967 | 393 |
2483333 | 2483333 | 2022-05-08 | Marshall | Alabama | 1095 | 27399 | 393 |
2485261 | 2485261 | 2022-05-08 | New Hanover | North Carolina | 37129 | 51157 | 393 |
2485752 | 2485752 | 2022-05-08 | Sumter | South Carolina | 45085 | 27967 | 393 |
2480075 | 2480075 | 2022-05-07 | Marshall | Alabama | 1095 | 27399 | 393 |
2482003 | 2482003 | 2022-05-07 | New Hanover | North Carolina | 37129 | 51157 | 393 |
2482494 | 2482494 | 2022-05-07 | Sumter | South Carolina | 45085 | 27967 | 393 |
2476817 | 2476817 | 2022-05-06 | Marshall | Alabama | 1095 | 27399 | 393 |
2478745 | 2478745 | 2022-05-06 | New Hanover | North Carolina | 37129 | 51157 | 393 |
2479236 | 2479236 | 2022-05-06 | Sumter | South Carolina | 45085 | 27967 | 393 |
2473559 | 2473559 | 2022-05-05 | Marshall | Alabama | 1095 | 27398 | 393 |
2475487 | 2475487 | 2022-05-05 | New Hanover | North Carolina | 37129 | 51157 | 393 |
2475978 | 2475978 | 2022-05-05 | Sumter | South Carolina | 45085 | 27967 | 393 |
2470302 | 2470302 | 2022-05-04 | Marshall | Alabama | 1095 | 27396 | 393 |
2472230 | 2472230 | 2022-05-04 | New Hanover | North Carolina | 37129 | 51157 | 393 |
2472721 | 2472721 | 2022-05-04 | Sumter | South Carolina | 45085 | 27967 | 393 |
2467046 | 2467046 | 2022-05-03 | Marshall | Alabama | 1095 | 27388 | 393 |
2469465 | 2469465 | 2022-05-03 | Sumter | South Carolina | 45085 | 27967 | 393 |
2444246 | 2444246 | 2022-04-26 | Lauderdale | Alabama | 1077 | 24129 | 393 |
2445087 | 2445087 | 2022-04-26 | Scott | Iowa | 19163 | 41103 | 393 |
2440990 | 2440990 | 2022-04-25 | Lauderdale | Alabama | 1077 | 24128 | 393 |
2441831 | 2441831 | 2022-04-25 | Scott | Iowa | 19163 | 41103 | 393 |
2437734 | 2437734 | 2022-04-24 | Lauderdale | Alabama | 1077 | 24118 | 393 |
2438575 | 2438575 | 2022-04-24 | Scott | Iowa | 19163 | 41103 | 393 |
2434478 | 2434478 | 2022-04-23 | Lauderdale | Alabama | 1077 | 24118 | 393 |
2435319 | 2435319 | 2022-04-23 | Scott | Iowa | 19163 | 41103 | 393 |
2431222 | 2431222 | 2022-04-22 | Lauderdale | Alabama | 1077 | 24118 | 393 |
2432063 | 2432063 | 2022-04-22 | Scott | Iowa | 19163 | 41103 | 393 |
2427966 | 2427966 | 2022-04-21 | Lauderdale | Alabama | 1077 | 24116 | 393 |
2428807 | 2428807 | 2022-04-21 | Scott | Iowa | 19163 | 41103 | 393 |
2425551 | 2425551 | 2022-04-20 | Scott | Iowa | 19163 | 41103 | 393 |
2421750 | 2421750 | 2022-04-19 | Columbia | Florida | 12023 | 21140 | 393 |
2421864 | 2421864 | 2022-04-19 | Forsyth | Georgia | 13117 | 55551 | 393 |
2423355 | 2423355 | 2022-04-19 | Davidson | North Carolina | 37057 | 43058 | 393 |
2418494 | 2418494 | 2022-04-18 | Columbia | Florida | 12023 | 21140 | 393 |
2418608 | 2418608 | 2022-04-18 | Forsyth | Georgia | 13117 | 55551 | 393 |
2420098 | 2420098 | 2022-04-18 | Davidson | North Carolina | 37057 | 43058 | 393 |
2415238 | 2415238 | 2022-04-17 | Columbia | Florida | 12023 | 21140 | 393 |
2415352 | 2415352 | 2022-04-17 | Forsyth | Georgia | 13117 | 55452 | 393 |
2416843 | 2416843 | 2022-04-17 | Davidson | North Carolina | 37057 | 43058 | 393 |
2411982 | 2411982 | 2022-04-16 | Columbia | Florida | 12023 | 21140 | 393 |
2412096 | 2412096 | 2022-04-16 | Forsyth | Georgia | 13117 | 55452 | 393 |
2413587 | 2413587 | 2022-04-16 | Davidson | North Carolina | 37057 | 43058 | 393 |
2408726 | 2408726 | 2022-04-15 | Columbia | Florida | 12023 | 21140 | 393 |
2408840 | 2408840 | 2022-04-15 | Forsyth | Georgia | 13117 | 55452 | 393 |
2410331 | 2410331 | 2022-04-15 | Davidson | North Carolina | 37057 | 43058 | 393 |
2405470 | 2405470 | 2022-04-14 | Columbia | Florida | 12023 | 21140 | 393 |
2405584 | 2405584 | 2022-04-14 | Forsyth | Georgia | 13117 | 55489 | 393 |
2407075 | 2407075 | 2022-04-14 | Davidson | North Carolina | 37057 | 43058 | 393 |
2402215 | 2402215 | 2022-04-13 | Columbia | Florida | 12023 | 21140 | 393 |
2402329 | 2402329 | 2022-04-13 | Forsyth | Georgia | 13117 | 55495 | 393 |
2403819 | 2403819 | 2022-04-13 | Davidson | North Carolina | 37057 | 43058 | 393 |
2400564 | 2400564 | 2022-04-12 | Davidson | North Carolina | 37057 | 43010 | 393 |
2401643 | 2401643 | 2022-04-12 | Newport News city | Virginia | 51700 | 36240 | 393 |
2397309 | 2397309 | 2022-04-11 | Davidson | North Carolina | 37057 | 43010 | 393 |
2398388 | 2398388 | 2022-04-11 | Newport News city | Virginia | 51700 | 36232 | 393 |
2394054 | 2394054 | 2022-04-10 | Davidson | North Carolina | 37057 | 43010 | 393 |
2395133 | 2395133 | 2022-04-10 | Newport News city | Virginia | 51700 | 36202 | 393 |
2390798 | 2390798 | 2022-04-09 | Davidson | North Carolina | 37057 | 43010 | 393 |
2391877 | 2391877 | 2022-04-09 | Newport News city | Virginia | 51700 | 36202 | 393 |
2387542 | 2387542 | 2022-04-08 | Davidson | North Carolina | 37057 | 43010 | 393 |
2388621 | 2388621 | 2022-04-08 | Newport News city | Virginia | 51700 | 36202 | 393 |
2384287 | 2384287 | 2022-04-07 | Davidson | North Carolina | 37057 | 43010 | 393 |
2385366 | 2385366 | 2022-04-07 | Newport News city | Virginia | 51700 | 36191 | 393 |
2379532 | 2379532 | 2022-04-06 | Douglas | Georgia | 13097 | 34852 | 393 |
2381032 | 2381032 | 2022-04-06 | Davidson | North Carolina | 37057 | 43010 | 393 |
2376278 | 2376278 | 2022-04-05 | Douglas | Georgia | 13097 | 34845 | 393 |
2377777 | 2377777 | 2022-04-05 | Davidson | North Carolina | 37057 | 42994 | 393 |
2378461 | 2378461 | 2022-04-05 | Unknown | Tennessee | 19273 | 393 | |
2373026 | 2373026 | 2022-04-04 | Douglas | Georgia | 13097 | 34844 | 393 |
2374524 | 2374524 | 2022-04-04 | Davidson | North Carolina | 37057 | 42991 | 393 |
2371272 | 2371272 | 2022-04-03 | Davidson | North Carolina | 37057 | 42980 | 393 |
2368019 | 2368019 | 2022-04-02 | Davidson | North Carolina | 37057 | 42980 | 393 |
2364766 | 2364766 | 2022-04-01 | Davidson | North Carolina | 37057 | 42980 | 393 |
2360841 | 2360841 | 2022-03-31 | Eaton | Michigan | 26045 | 26724 | 393 |
2361512 | 2361512 | 2022-03-31 | Davidson | North Carolina | 37057 | 42973 | 393 |
2357587 | 2357587 | 2022-03-30 | Eaton | Michigan | 26045 | 26724 | 393 |
2358258 | 2358258 | 2022-03-30 | Davidson | North Carolina | 37057 | 42969 | 393 |
2355004 | 2355004 | 2022-03-29 | Davidson | North Carolina | 37057 | 42960 | 393 |
2351751 | 2351751 | 2022-03-28 | Davidson | North Carolina | 37057 | 42954 | 393 |
2347277 | 2347277 | 2022-03-27 | Clark | Indiana | 18019 | 31043 | 393 |
2347829 | 2347829 | 2022-03-27 | Eaton | Michigan | 26045 | 26689 | 393 |
2348499 | 2348499 | 2022-03-27 | Davidson | North Carolina | 37057 | 42955 | 393 |
2344024 | 2344024 | 2022-03-26 | Clark | Indiana | 18019 | 31043 | 393 |
2344576 | 2344576 | 2022-03-26 | Eaton | Michigan | 26045 | 26689 | 393 |
2345246 | 2345246 | 2022-03-26 | Davidson | North Carolina | 37057 | 42955 | 393 |
2340771 | 2340771 | 2022-03-25 | Clark | Indiana | 18019 | 31043 | 393 |
2341323 | 2341323 | 2022-03-25 | Eaton | Michigan | 26045 | 26689 | 393 |
2341993 | 2341993 | 2022-03-25 | Davidson | North Carolina | 37057 | 42955 | 393 |
2338070 | 2338070 | 2022-03-24 | Eaton | Michigan | 26045 | 26671 | 393 |
2338740 | 2338740 | 2022-03-24 | Davidson | North Carolina | 37057 | 42947 | 393 |
2334816 | 2334816 | 2022-03-23 | Eaton | Michigan | 26045 | 26671 | 393 |
2335392 | 2335392 | 2022-03-23 | Sandoval | New Mexico | 35043 | 33329 | 393 |
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);