ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26,426 rows where deaths = 14 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 2,443
- Kansas 2,039
- Missouri 1,657
- Georgia 1,438
- South Dakota 1,245
- Kentucky 1,163
- Virginia 1,109
- Idaho 870
- Colorado 839
- Minnesota 752
- Montana 733
- Oklahoma 699
- Mississippi 663
- Indiana 659
- Nebraska 623
- Michigan 614
- Arkansas 608
- Iowa 564
- Wisconsin 526
- North Dakota 522
- Tennessee 476
- Ohio 470
- New York 465
- North Carolina 416
- Wyoming 408
- Utah 391
- Alabama 353
- Florida 345
- Illinois 308
- Oregon 307
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499655 | 2499655 | 2022-05-13 | Kusilvak Census Area | Alaska | 2158 | 4084 | 14 |
2499846 | 2499846 | 2022-05-13 | Gunnison | Colorado | 8051 | 3407 | 14 |
2499879 | 2499879 | 2022-05-13 | Summit | Colorado | 8117 | 10087 | 14 |
2500140 | 2500140 | 2022-05-13 | Boise | Idaho | 16015 | 1094 | 14 |
2500374 | 2500374 | 2022-05-13 | Adams | Iowa | 19003 | 820 | 14 |
2500484 | 2500484 | 2022-05-13 | Cheyenne | Kansas | 20023 | 652 | 14 |
2500862 | 2500862 | 2022-05-13 | Keweenaw | Michigan | 26083 | 523 | 14 |
2500868 | 2500868 | 2022-05-13 | Luce | Michigan | 26095 | 2306 | 14 |
2500958 | 2500958 | 2022-05-13 | Norman | Minnesota | 27107 | 1535 | 14 |
2501129 | 2501129 | 2022-05-13 | Knox | Missouri | 29103 | 990 | 14 |
2501142 | 2501142 | 2022-05-13 | Mercer | Missouri | 29129 | 704 | 14 |
2501200 | 2501200 | 2022-05-13 | Chouteau | Montana | 30015 | 991 | 14 |
2501246 | 2501246 | 2022-05-13 | Wheatland | Montana | 30107 | 386 | 14 |
2501250 | 2501250 | 2022-05-13 | Antelope | Nebraska | 31003 | 1081 | 14 |
2501262 | 2501262 | 2022-05-13 | Cedar | Nebraska | 31027 | 1485 | 14 |
2501317 | 2501317 | 2022-05-13 | Phelps | Nebraska | 31137 | 2310 | 14 |
2501395 | 2501395 | 2022-05-13 | Catron | New Mexico | 35003 | 420 | 14 |
2502047 | 2502047 | 2022-05-13 | Bennett | South Dakota | 46007 | 789 | 14 |
2502261 | 2502261 | 2022-05-13 | Culberson | Texas | 48109 | 514 | 14 |
2502399 | 2502399 | 2022-05-13 | Reagan | Texas | 48383 | 859 | 14 |
2502500 | 2502500 | 2022-05-13 | Orange | Vermont | 50017 | 4420 | 14 |
2502777 | 2502777 | 2022-05-13 | Menominee | Wisconsin | 55078 | 1987 | 14 |
2496397 | 2496397 | 2022-05-12 | Kusilvak Census Area | Alaska | 2158 | 4084 | 14 |
2496588 | 2496588 | 2022-05-12 | Gunnison | Colorado | 8051 | 3406 | 14 |
2496621 | 2496621 | 2022-05-12 | Summit | Colorado | 8117 | 10081 | 14 |
2496882 | 2496882 | 2022-05-12 | Boise | Idaho | 16015 | 1093 | 14 |
2497116 | 2497116 | 2022-05-12 | Adams | Iowa | 19003 | 820 | 14 |
2497226 | 2497226 | 2022-05-12 | Cheyenne | Kansas | 20023 | 652 | 14 |
2497604 | 2497604 | 2022-05-12 | Keweenaw | Michigan | 26083 | 523 | 14 |
2497610 | 2497610 | 2022-05-12 | Luce | Michigan | 26095 | 2306 | 14 |
2497700 | 2497700 | 2022-05-12 | Norman | Minnesota | 27107 | 1533 | 14 |
2497871 | 2497871 | 2022-05-12 | Knox | Missouri | 29103 | 989 | 14 |
2497884 | 2497884 | 2022-05-12 | Mercer | Missouri | 29129 | 704 | 14 |
2497942 | 2497942 | 2022-05-12 | Chouteau | Montana | 30015 | 991 | 14 |
2497988 | 2497988 | 2022-05-12 | Wheatland | Montana | 30107 | 386 | 14 |
2497992 | 2497992 | 2022-05-12 | Antelope | Nebraska | 31003 | 1082 | 14 |
2498004 | 2498004 | 2022-05-12 | Cedar | Nebraska | 31027 | 1485 | 14 |
2498059 | 2498059 | 2022-05-12 | Phelps | Nebraska | 31137 | 2310 | 14 |
2498137 | 2498137 | 2022-05-12 | Catron | New Mexico | 35003 | 420 | 14 |
2498789 | 2498789 | 2022-05-12 | Bennett | South Dakota | 46007 | 789 | 14 |
2499003 | 2499003 | 2022-05-12 | Culberson | Texas | 48109 | 514 | 14 |
2499141 | 2499141 | 2022-05-12 | Reagan | Texas | 48383 | 859 | 14 |
2499242 | 2499242 | 2022-05-12 | Orange | Vermont | 50017 | 4410 | 14 |
2499519 | 2499519 | 2022-05-12 | Menominee | Wisconsin | 55078 | 1980 | 14 |
2493139 | 2493139 | 2022-05-11 | Kusilvak Census Area | Alaska | 2158 | 4084 | 14 |
2493330 | 2493330 | 2022-05-11 | Gunnison | Colorado | 8051 | 3401 | 14 |
2493363 | 2493363 | 2022-05-11 | Summit | Colorado | 8117 | 10003 | 14 |
2493624 | 2493624 | 2022-05-11 | Boise | Idaho | 16015 | 1093 | 14 |
2493858 | 2493858 | 2022-05-11 | Adams | Iowa | 19003 | 820 | 14 |
2493968 | 2493968 | 2022-05-11 | Cheyenne | Kansas | 20023 | 652 | 14 |
2494346 | 2494346 | 2022-05-11 | Keweenaw | Michigan | 26083 | 523 | 14 |
2494352 | 2494352 | 2022-05-11 | Luce | Michigan | 26095 | 2306 | 14 |
2494613 | 2494613 | 2022-05-11 | Knox | Missouri | 29103 | 989 | 14 |
2494626 | 2494626 | 2022-05-11 | Mercer | Missouri | 29129 | 704 | 14 |
2494684 | 2494684 | 2022-05-11 | Chouteau | Montana | 30015 | 991 | 14 |
2494730 | 2494730 | 2022-05-11 | Wheatland | Montana | 30107 | 386 | 14 |
2494734 | 2494734 | 2022-05-11 | Antelope | Nebraska | 31003 | 1082 | 14 |
2494746 | 2494746 | 2022-05-11 | Cedar | Nebraska | 31027 | 1485 | 14 |
2494801 | 2494801 | 2022-05-11 | Phelps | Nebraska | 31137 | 2310 | 14 |
2494879 | 2494879 | 2022-05-11 | Catron | New Mexico | 35003 | 420 | 14 |
2495531 | 2495531 | 2022-05-11 | Bennett | South Dakota | 46007 | 789 | 14 |
2495745 | 2495745 | 2022-05-11 | Culberson | Texas | 48109 | 514 | 14 |
2495883 | 2495883 | 2022-05-11 | Reagan | Texas | 48383 | 859 | 14 |
2495984 | 2495984 | 2022-05-11 | Orange | Vermont | 50017 | 4388 | 14 |
2496261 | 2496261 | 2022-05-11 | Menominee | Wisconsin | 55078 | 1976 | 14 |
2490072 | 2490072 | 2022-05-10 | Gunnison | Colorado | 8051 | 3402 | 14 |
2490105 | 2490105 | 2022-05-10 | Summit | Colorado | 8117 | 10004 | 14 |
2490366 | 2490366 | 2022-05-10 | Boise | Idaho | 16015 | 1093 | 14 |
2490710 | 2490710 | 2022-05-10 | Cheyenne | Kansas | 20023 | 652 | 14 |
2491088 | 2491088 | 2022-05-10 | Keweenaw | Michigan | 26083 | 520 | 14 |
2491094 | 2491094 | 2022-05-10 | Luce | Michigan | 26095 | 2298 | 14 |
2491355 | 2491355 | 2022-05-10 | Knox | Missouri | 29103 | 989 | 14 |
2491368 | 2491368 | 2022-05-10 | Mercer | Missouri | 29129 | 704 | 14 |
2491426 | 2491426 | 2022-05-10 | Chouteau | Montana | 30015 | 991 | 14 |
2491472 | 2491472 | 2022-05-10 | Wheatland | Montana | 30107 | 386 | 14 |
2491476 | 2491476 | 2022-05-10 | Antelope | Nebraska | 31003 | 1119 | 14 |
2491488 | 2491488 | 2022-05-10 | Cedar | Nebraska | 31027 | 1528 | 14 |
2491543 | 2491543 | 2022-05-10 | Phelps | Nebraska | 31137 | 2353 | 14 |
2491621 | 2491621 | 2022-05-10 | Catron | New Mexico | 35003 | 420 | 14 |
2492273 | 2492273 | 2022-05-10 | Bennett | South Dakota | 46007 | 788 | 14 |
2492487 | 2492487 | 2022-05-10 | Culberson | Texas | 48109 | 513 | 14 |
2492625 | 2492625 | 2022-05-10 | Reagan | Texas | 48383 | 859 | 14 |
2492726 | 2492726 | 2022-05-10 | Orange | Vermont | 50017 | 4376 | 14 |
2493003 | 2493003 | 2022-05-10 | Menominee | Wisconsin | 55078 | 1973 | 14 |
2486815 | 2486815 | 2022-05-09 | Gunnison | Colorado | 8051 | 3402 | 14 |
2486848 | 2486848 | 2022-05-09 | Summit | Colorado | 8117 | 9998 | 14 |
2487109 | 2487109 | 2022-05-09 | Boise | Idaho | 16015 | 1093 | 14 |
2487453 | 2487453 | 2022-05-09 | Cheyenne | Kansas | 20023 | 652 | 14 |
2487831 | 2487831 | 2022-05-09 | Keweenaw | Michigan | 26083 | 520 | 14 |
2487837 | 2487837 | 2022-05-09 | Luce | Michigan | 26095 | 2298 | 14 |
2488097 | 2488097 | 2022-05-09 | Knox | Missouri | 29103 | 989 | 14 |
2488110 | 2488110 | 2022-05-09 | Mercer | Missouri | 29129 | 704 | 14 |
2488168 | 2488168 | 2022-05-09 | Chouteau | Montana | 30015 | 991 | 14 |
2488214 | 2488214 | 2022-05-09 | Wheatland | Montana | 30107 | 386 | 14 |
2488218 | 2488218 | 2022-05-09 | Antelope | Nebraska | 31003 | 1119 | 14 |
2488230 | 2488230 | 2022-05-09 | Cedar | Nebraska | 31027 | 1528 | 14 |
2488285 | 2488285 | 2022-05-09 | Phelps | Nebraska | 31137 | 2353 | 14 |
2488363 | 2488363 | 2022-05-09 | Catron | New Mexico | 35003 | 420 | 14 |
2489015 | 2489015 | 2022-05-09 | Bennett | South Dakota | 46007 | 788 | 14 |
2489229 | 2489229 | 2022-05-09 | Culberson | Texas | 48109 | 513 | 14 |
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);