ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,292 rows where deaths = 197 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 43
- Ohio 114
- Texas 110
- Georgia 87
- North Carolina 76
- Indiana 69
- Virginia 62
- New Jersey 59
- Alabama 57
- South Carolina 54
- Illinois 46
- Pennsylvania 44
- Connecticut 36
- Mississippi 35
- Oklahoma 35
- Michigan 32
- New York 30
- Florida 29
- Missouri 29
- Tennessee 27
- Louisiana 24
- Kentucky 23
- Wisconsin 21
- California 18
- Iowa 18
- Maine 18
- New Mexico 15
- Maryland 13
- Washington 13
- Arkansas 11
- Montana 11
- Colorado 10
- Delaware 10
- Idaho 10
- North Dakota 10
- West Virginia 7
- Massachusetts 6
- Minnesota 5
- Nevada 5
- South Dakota 4
- Arizona 3
- Oregon 3
- Utah 2
- Nebraska 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500329 | 2500329 | 2022-05-13 | Marshall | Indiana | 18099 | 12437 | 197 |
2502240 | 2502240 | 2022-05-13 | Cass | Texas | 48067 | 7260 | 197 |
2497071 | 2497071 | 2022-05-12 | Marshall | Indiana | 18099 | 12427 | 197 |
2498982 | 2498982 | 2022-05-12 | Cass | Texas | 48067 | 7258 | 197 |
2493813 | 2493813 | 2022-05-11 | Marshall | Indiana | 18099 | 12427 | 197 |
2494883 | 2494883 | 2022-05-11 | Curry | New Mexico | 35009 | 12782 | 197 |
2490555 | 2490555 | 2022-05-10 | Marshall | Indiana | 18099 | 12415 | 197 |
2491625 | 2491625 | 2022-05-10 | Curry | New Mexico | 35009 | 12780 | 197 |
2487298 | 2487298 | 2022-05-09 | Marshall | Indiana | 18099 | 12415 | 197 |
2484040 | 2484040 | 2022-05-08 | Marshall | Indiana | 18099 | 12400 | 197 |
2480782 | 2480782 | 2022-05-07 | Marshall | Indiana | 18099 | 12400 | 197 |
2477524 | 2477524 | 2022-05-06 | Marshall | Indiana | 18099 | 12400 | 197 |
2474266 | 2474266 | 2022-05-05 | Marshall | Indiana | 18099 | 12400 | 197 |
2471009 | 2471009 | 2022-05-04 | Marshall | Indiana | 18099 | 12400 | 197 |
2473232 | 2473232 | 2022-05-04 | Franklin | Virginia | 51067 | 10883 | 197 |
2467753 | 2467753 | 2022-05-03 | Marshall | Indiana | 18099 | 12395 | 197 |
2469976 | 2469976 | 2022-05-03 | Franklin | Virginia | 51067 | 10871 | 197 |
2464498 | 2464498 | 2022-05-02 | Marshall | Indiana | 18099 | 12395 | 197 |
2466720 | 2466720 | 2022-05-02 | Franklin | Virginia | 51067 | 10869 | 197 |
2466807 | 2466807 | 2022-05-02 | Wise | Virginia | 51195 | 10271 | 197 |
2461242 | 2461242 | 2022-05-01 | Marshall | Indiana | 18099 | 12394 | 197 |
2463465 | 2463465 | 2022-05-01 | Franklin | Virginia | 51067 | 10856 | 197 |
2463552 | 2463552 | 2022-05-01 | Wise | Virginia | 51195 | 10268 | 197 |
2457986 | 2457986 | 2022-04-30 | Marshall | Indiana | 18099 | 12394 | 197 |
2460209 | 2460209 | 2022-04-30 | Franklin | Virginia | 51067 | 10856 | 197 |
2460296 | 2460296 | 2022-04-30 | Wise | Virginia | 51195 | 10268 | 197 |
2454730 | 2454730 | 2022-04-29 | Marshall | Indiana | 18099 | 12394 | 197 |
2456953 | 2456953 | 2022-04-29 | Franklin | Virginia | 51067 | 10856 | 197 |
2457040 | 2457040 | 2022-04-29 | Wise | Virginia | 51195 | 10268 | 197 |
2451474 | 2451474 | 2022-04-28 | Marshall | Indiana | 18099 | 12386 | 197 |
2453514 | 2453514 | 2022-04-28 | Medina | Texas | 48325 | 10236 | 197 |
2453697 | 2453697 | 2022-04-28 | Franklin | Virginia | 51067 | 10843 | 197 |
2453784 | 2453784 | 2022-04-28 | Wise | Virginia | 51195 | 10269 | 197 |
2448218 | 2448218 | 2022-04-27 | Marshall | Indiana | 18099 | 12386 | 197 |
2449600 | 2449600 | 2022-04-27 | Preble | Ohio | 39135 | 9459 | 197 |
2450258 | 2450258 | 2022-04-27 | Medina | Texas | 48325 | 10232 | 197 |
2450441 | 2450441 | 2022-04-27 | Franklin | Virginia | 51067 | 10835 | 197 |
2450528 | 2450528 | 2022-04-27 | Wise | Virginia | 51195 | 10267 | 197 |
2444962 | 2444962 | 2022-04-26 | Marshall | Indiana | 18099 | 12381 | 197 |
2446343 | 2446343 | 2022-04-26 | Preble | Ohio | 39135 | 9459 | 197 |
2447001 | 2447001 | 2022-04-26 | Medina | Texas | 48325 | 10231 | 197 |
2447272 | 2447272 | 2022-04-26 | Wise | Virginia | 51195 | 10269 | 197 |
2441706 | 2441706 | 2022-04-25 | Marshall | Indiana | 18099 | 12381 | 197 |
2443088 | 2443088 | 2022-04-25 | Preble | Ohio | 39135 | 9459 | 197 |
2443746 | 2443746 | 2022-04-25 | Medina | Texas | 48325 | 10231 | 197 |
2444016 | 2444016 | 2022-04-25 | Wise | Virginia | 51195 | 10264 | 197 |
2438450 | 2438450 | 2022-04-24 | Marshall | Indiana | 18099 | 12370 | 197 |
2439832 | 2439832 | 2022-04-24 | Preble | Ohio | 39135 | 9459 | 197 |
2440490 | 2440490 | 2022-04-24 | Medina | Texas | 48325 | 10229 | 197 |
2440760 | 2440760 | 2022-04-24 | Wise | Virginia | 51195 | 10264 | 197 |
2435194 | 2435194 | 2022-04-23 | Marshall | Indiana | 18099 | 12370 | 197 |
2436576 | 2436576 | 2022-04-23 | Preble | Ohio | 39135 | 9459 | 197 |
2437234 | 2437234 | 2022-04-23 | Medina | Texas | 48325 | 10229 | 197 |
2437504 | 2437504 | 2022-04-23 | Wise | Virginia | 51195 | 10264 | 197 |
2431938 | 2431938 | 2022-04-22 | Marshall | Indiana | 18099 | 12370 | 197 |
2433320 | 2433320 | 2022-04-22 | Preble | Ohio | 39135 | 9459 | 197 |
2433978 | 2433978 | 2022-04-22 | Medina | Texas | 48325 | 10229 | 197 |
2434248 | 2434248 | 2022-04-22 | Wise | Virginia | 51195 | 10264 | 197 |
2428682 | 2428682 | 2022-04-21 | Marshall | Indiana | 18099 | 12355 | 197 |
2430064 | 2430064 | 2022-04-21 | Preble | Ohio | 39135 | 9459 | 197 |
2430722 | 2430722 | 2022-04-21 | Medina | Texas | 48325 | 10224 | 197 |
2430992 | 2430992 | 2022-04-21 | Wise | Virginia | 51195 | 10262 | 197 |
2425426 | 2425426 | 2022-04-20 | Marshall | Indiana | 18099 | 12355 | 197 |
2426808 | 2426808 | 2022-04-20 | Preble | Ohio | 39135 | 9455 | 197 |
2427466 | 2427466 | 2022-04-20 | Medina | Texas | 48325 | 10223 | 197 |
2427736 | 2427736 | 2022-04-20 | Wise | Virginia | 51195 | 10262 | 197 |
2423552 | 2423552 | 2022-04-19 | Preble | Ohio | 39135 | 9455 | 197 |
2424210 | 2424210 | 2022-04-19 | Medina | Texas | 48325 | 10222 | 197 |
2420295 | 2420295 | 2022-04-18 | Preble | Ohio | 39135 | 9455 | 197 |
2420954 | 2420954 | 2022-04-18 | Medina | Texas | 48325 | 10221 | 197 |
2417040 | 2417040 | 2022-04-17 | Preble | Ohio | 39135 | 9455 | 197 |
2417698 | 2417698 | 2022-04-17 | Medina | Texas | 48325 | 10217 | 197 |
2413784 | 2413784 | 2022-04-16 | Preble | Ohio | 39135 | 9455 | 197 |
2414442 | 2414442 | 2022-04-16 | Medina | Texas | 48325 | 10217 | 197 |
2410528 | 2410528 | 2022-04-15 | Preble | Ohio | 39135 | 9455 | 197 |
2411186 | 2411186 | 2022-04-15 | Medina | Texas | 48325 | 10217 | 197 |
2407272 | 2407272 | 2022-04-14 | Preble | Ohio | 39135 | 9455 | 197 |
2407930 | 2407930 | 2022-04-14 | Medina | Texas | 48325 | 10217 | 197 |
2408200 | 2408200 | 2022-04-14 | Wise | Virginia | 51195 | 10248 | 197 |
2404016 | 2404016 | 2022-04-13 | Preble | Ohio | 39135 | 9453 | 197 |
2404674 | 2404674 | 2022-04-13 | Medina | Texas | 48325 | 10214 | 197 |
2400761 | 2400761 | 2022-04-12 | Preble | Ohio | 39135 | 9453 | 197 |
2401419 | 2401419 | 2022-04-12 | Medina | Texas | 48325 | 10213 | 197 |
2396864 | 2396864 | 2022-04-11 | Washington | Mississippi | 28151 | 10376 | 197 |
2397506 | 2397506 | 2022-04-11 | Preble | Ohio | 39135 | 9453 | 197 |
2398164 | 2398164 | 2022-04-11 | Medina | Texas | 48325 | 10211 | 197 |
2393609 | 2393609 | 2022-04-10 | Washington | Mississippi | 28151 | 10376 | 197 |
2394251 | 2394251 | 2022-04-10 | Preble | Ohio | 39135 | 9453 | 197 |
2394909 | 2394909 | 2022-04-10 | Medina | Texas | 48325 | 10211 | 197 |
2390353 | 2390353 | 2022-04-09 | Washington | Mississippi | 28151 | 10376 | 197 |
2390995 | 2390995 | 2022-04-09 | Preble | Ohio | 39135 | 9453 | 197 |
2391653 | 2391653 | 2022-04-09 | Medina | Texas | 48325 | 10210 | 197 |
2387097 | 2387097 | 2022-04-08 | Washington | Mississippi | 28151 | 10376 | 197 |
2387739 | 2387739 | 2022-04-08 | Preble | Ohio | 39135 | 9453 | 197 |
2388397 | 2388397 | 2022-04-08 | Medina | Texas | 48325 | 10199 | 197 |
2383842 | 2383842 | 2022-04-07 | Washington | Mississippi | 28151 | 10376 | 197 |
2384484 | 2384484 | 2022-04-07 | Preble | Ohio | 39135 | 9453 | 197 |
2385142 | 2385142 | 2022-04-07 | Medina | Texas | 48325 | 10197 | 197 |
2380587 | 2380587 | 2022-04-06 | Washington | Mississippi | 28151 | 10376 | 197 |
2381887 | 2381887 | 2022-04-06 | Medina | Texas | 48325 | 10197 | 197 |
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);