ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,019 rows where deaths = 256 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 95
- Virginia 85
- Georgia 58
- South Carolina 51
- California 48
- Ohio 48
- North Carolina 47
- Missouri 46
- Louisiana 40
- Washington 38
- Pennsylvania 37
- Wisconsin 34
- Indiana 33
- Oklahoma 31
- Illinois 25
- Arkansas 24
- New Jersey 24
- Florida 22
- New York 21
- Maryland 20
- Tennessee 16
- Alabama 15
- Mississippi 15
- Wyoming 14
- Colorado 12
- Kentucky 12
- Oregon 12
- Iowa 11
- Michigan 11
- New Mexico 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499972 | 2499972 | 2022-05-13 | Barrow | Georgia | 13013 | 21998 | 256 |
2501687 | 2501687 | 2022-05-13 | Lawrence | Ohio | 39087 | 18071 | 256 |
2502346 | 2502346 | 2022-05-13 | Lamar | Texas | 48277 | 12500 | 256 |
2496714 | 2496714 | 2022-05-12 | Barrow | Georgia | 13013 | 21998 | 256 |
2498429 | 2498429 | 2022-05-12 | Lawrence | Ohio | 39087 | 18071 | 256 |
2499088 | 2499088 | 2022-05-12 | Lamar | Texas | 48277 | 12500 | 256 |
2493456 | 2493456 | 2022-05-11 | Barrow | Georgia | 13013 | 21998 | 256 |
2495830 | 2495830 | 2022-05-11 | Lamar | Texas | 48277 | 12500 | 256 |
2491692 | 2491692 | 2022-05-10 | Rensselaer | New York | 36083 | 33625 | 256 |
2492572 | 2492572 | 2022-05-10 | Lamar | Texas | 48277 | 12500 | 256 |
2488434 | 2488434 | 2022-05-09 | Rensselaer | New York | 36083 | 33567 | 256 |
2489314 | 2489314 | 2022-05-09 | Lamar | Texas | 48277 | 12500 | 256 |
2485177 | 2485177 | 2022-05-08 | Rensselaer | New York | 36083 | 33522 | 256 |
2486057 | 2486057 | 2022-05-08 | Lamar | Texas | 48277 | 12491 | 256 |
2481919 | 2481919 | 2022-05-07 | Rensselaer | New York | 36083 | 33414 | 256 |
2482799 | 2482799 | 2022-05-07 | Lamar | Texas | 48277 | 12491 | 256 |
2478661 | 2478661 | 2022-05-06 | Rensselaer | New York | 36083 | 33325 | 256 |
2479541 | 2479541 | 2022-05-06 | Lamar | Texas | 48277 | 12491 | 256 |
2475403 | 2475403 | 2022-05-05 | Rensselaer | New York | 36083 | 33241 | 256 |
2476283 | 2476283 | 2022-05-05 | Lamar | Texas | 48277 | 12491 | 256 |
2471777 | 2471777 | 2022-05-04 | Christian | Missouri | 29043 | 20868 | 256 |
2473026 | 2473026 | 2022-05-04 | Lamar | Texas | 48277 | 12491 | 256 |
2467396 | 2467396 | 2022-05-03 | Barrow | Georgia | 13013 | 21944 | 256 |
2468521 | 2468521 | 2022-05-03 | Christian | Missouri | 29043 | 20868 | 256 |
2469770 | 2469770 | 2022-05-03 | Lamar | Texas | 48277 | 12491 | 256 |
2464141 | 2464141 | 2022-05-02 | Barrow | Georgia | 13013 | 21944 | 256 |
2465265 | 2465265 | 2022-05-02 | Christian | Missouri | 29043 | 20868 | 256 |
2466194 | 2466194 | 2022-05-02 | Kershaw | South Carolina | 45055 | 21516 | 256 |
2466514 | 2466514 | 2022-05-02 | Lamar | Texas | 48277 | 12491 | 256 |
2460885 | 2460885 | 2022-05-01 | Barrow | Georgia | 13013 | 21944 | 256 |
2462010 | 2462010 | 2022-05-01 | Christian | Missouri | 29043 | 20868 | 256 |
2462939 | 2462939 | 2022-05-01 | Kershaw | South Carolina | 45055 | 21516 | 256 |
2463259 | 2463259 | 2022-05-01 | Lamar | Texas | 48277 | 12488 | 256 |
2457629 | 2457629 | 2022-04-30 | Barrow | Georgia | 13013 | 21944 | 256 |
2458754 | 2458754 | 2022-04-30 | Christian | Missouri | 29043 | 20868 | 256 |
2459683 | 2459683 | 2022-04-30 | Kershaw | South Carolina | 45055 | 21516 | 256 |
2460003 | 2460003 | 2022-04-30 | Lamar | Texas | 48277 | 12488 | 256 |
2454373 | 2454373 | 2022-04-29 | Barrow | Georgia | 13013 | 21944 | 256 |
2455498 | 2455498 | 2022-04-29 | Christian | Missouri | 29043 | 20868 | 256 |
2456427 | 2456427 | 2022-04-29 | Kershaw | South Carolina | 45055 | 21516 | 256 |
2456747 | 2456747 | 2022-04-29 | Lamar | Texas | 48277 | 12488 | 256 |
2451117 | 2451117 | 2022-04-28 | Barrow | Georgia | 13013 | 21944 | 256 |
2452242 | 2452242 | 2022-04-28 | Christian | Missouri | 29043 | 20868 | 256 |
2453171 | 2453171 | 2022-04-28 | Kershaw | South Carolina | 45055 | 21516 | 256 |
2453343 | 2453343 | 2022-04-28 | Unknown | Tennessee | 18853 | 256 | |
2447861 | 2447861 | 2022-04-27 | Barrow | Georgia | 13013 | 21944 | 256 |
2448986 | 2448986 | 2022-04-27 | Christian | Missouri | 29043 | 20868 | 256 |
2445729 | 2445729 | 2022-04-26 | Christian | Missouri | 29043 | 20868 | 256 |
2442474 | 2442474 | 2022-04-25 | Christian | Missouri | 29043 | 20868 | 256 |
2439218 | 2439218 | 2022-04-24 | Christian | Missouri | 29043 | 20868 | 256 |
2435962 | 2435962 | 2022-04-23 | Christian | Missouri | 29043 | 20868 | 256 |
2432706 | 2432706 | 2022-04-22 | Christian | Missouri | 29043 | 20868 | 256 |
2429450 | 2429450 | 2022-04-21 | Christian | Missouri | 29043 | 20868 | 256 |
2426194 | 2426194 | 2022-04-20 | Christian | Missouri | 29043 | 20868 | 256 |
2422938 | 2422938 | 2022-04-19 | Christian | Missouri | 29043 | 20868 | 256 |
2419681 | 2419681 | 2022-04-18 | Christian | Missouri | 29043 | 20868 | 256 |
2416426 | 2416426 | 2022-04-17 | Christian | Missouri | 29043 | 20868 | 256 |
2417675 | 2417675 | 2022-04-17 | Lamar | Texas | 48277 | 12484 | 256 |
2413170 | 2413170 | 2022-04-16 | Christian | Missouri | 29043 | 20868 | 256 |
2414419 | 2414419 | 2022-04-16 | Lamar | Texas | 48277 | 12484 | 256 |
2409914 | 2409914 | 2022-04-15 | Christian | Missouri | 29043 | 20868 | 256 |
2411163 | 2411163 | 2022-04-15 | Lamar | Texas | 48277 | 12484 | 256 |
2406658 | 2406658 | 2022-04-14 | Christian | Missouri | 29043 | 20868 | 256 |
2407907 | 2407907 | 2022-04-14 | Lamar | Texas | 48277 | 12484 | 256 |
2403402 | 2403402 | 2022-04-13 | Christian | Missouri | 29043 | 20868 | 256 |
2404112 | 2404112 | 2022-04-13 | Washington | Oklahoma | 40147 | 12669 | 256 |
2404651 | 2404651 | 2022-04-13 | Lamar | Texas | 48277 | 12484 | 256 |
2400147 | 2400147 | 2022-04-12 | Christian | Missouri | 29043 | 20868 | 256 |
2400632 | 2400632 | 2022-04-12 | Wilkes | North Carolina | 37193 | 17514 | 256 |
2400857 | 2400857 | 2022-04-12 | Washington | Oklahoma | 40147 | 12669 | 256 |
2401187 | 2401187 | 2022-04-12 | Gibson | Tennessee | 47053 | 17380 | 256 |
2401396 | 2401396 | 2022-04-12 | Lamar | Texas | 48277 | 12484 | 256 |
2396892 | 2396892 | 2022-04-11 | Christian | Missouri | 29043 | 20868 | 256 |
2397377 | 2397377 | 2022-04-11 | Wilkes | North Carolina | 37193 | 17514 | 256 |
2397602 | 2397602 | 2022-04-11 | Washington | Oklahoma | 40147 | 12669 | 256 |
2397932 | 2397932 | 2022-04-11 | Gibson | Tennessee | 47053 | 17380 | 256 |
2398141 | 2398141 | 2022-04-11 | Lamar | Texas | 48277 | 12484 | 256 |
2393637 | 2393637 | 2022-04-10 | Christian | Missouri | 29043 | 20868 | 256 |
2394122 | 2394122 | 2022-04-10 | Wilkes | North Carolina | 37193 | 17514 | 256 |
2394347 | 2394347 | 2022-04-10 | Washington | Oklahoma | 40147 | 12669 | 256 |
2394677 | 2394677 | 2022-04-10 | Gibson | Tennessee | 47053 | 17380 | 256 |
2394886 | 2394886 | 2022-04-10 | Lamar | Texas | 48277 | 12483 | 256 |
2390381 | 2390381 | 2022-04-09 | Christian | Missouri | 29043 | 20868 | 256 |
2390866 | 2390866 | 2022-04-09 | Wilkes | North Carolina | 37193 | 17514 | 256 |
2391091 | 2391091 | 2022-04-09 | Washington | Oklahoma | 40147 | 12669 | 256 |
2391421 | 2391421 | 2022-04-09 | Gibson | Tennessee | 47053 | 17380 | 256 |
2391630 | 2391630 | 2022-04-09 | Lamar | Texas | 48277 | 12483 | 256 |
2387125 | 2387125 | 2022-04-08 | Christian | Missouri | 29043 | 20868 | 256 |
2387610 | 2387610 | 2022-04-08 | Wilkes | North Carolina | 37193 | 17514 | 256 |
2387835 | 2387835 | 2022-04-08 | Washington | Oklahoma | 40147 | 12669 | 256 |
2388165 | 2388165 | 2022-04-08 | Gibson | Tennessee | 47053 | 17380 | 256 |
2388374 | 2388374 | 2022-04-08 | Lamar | Texas | 48277 | 12483 | 256 |
2383870 | 2383870 | 2022-04-07 | Christian | Missouri | 29043 | 20868 | 256 |
2384355 | 2384355 | 2022-04-07 | Wilkes | North Carolina | 37193 | 17514 | 256 |
2384580 | 2384580 | 2022-04-07 | Washington | Oklahoma | 40147 | 12669 | 256 |
2384910 | 2384910 | 2022-04-07 | Gibson | Tennessee | 47053 | 17380 | 256 |
2385119 | 2385119 | 2022-04-07 | Lamar | Texas | 48277 | 12483 | 256 |
2380615 | 2380615 | 2022-04-06 | Christian | Missouri | 29043 | 20868 | 256 |
2381100 | 2381100 | 2022-04-06 | Wilkes | North Carolina | 37193 | 17514 | 256 |
2381325 | 2381325 | 2022-04-06 | Washington | Oklahoma | 40147 | 12658 | 256 |
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);