ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,929 rows where deaths = 134 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 237
- Louisiana 182
- Virginia 170
- Ohio 162
- Georgia 149
- Mississippi 149
- North Carolina 115
- Illinois 109
- Alabama 107
- Tennessee 99
- Oklahoma 93
- Michigan 90
- Kentucky 82
- Indiana 79
- Kansas 76
- Iowa 74
- Pennsylvania 74
- South Carolina 74
- Missouri 73
- Colorado 72
- California 61
- West Virginia 52
- Wisconsin 47
- Arkansas 43
- Florida 43
- New York 39
- Minnesota 36
- Washington 36
- Maine 33
- Arizona 31
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499629 | 2499629 | 2022-05-13 | Pike | Alabama | 1109 | 7590 | 134 |
2499992 | 2499992 | 2022-05-13 | Chattooga | Georgia | 13055 | 6687 | 134 |
2500464 | 2500464 | 2022-05-13 | Warren | Iowa | 19181 | 12591 | 134 |
2500621 | 2500621 | 2022-05-13 | Grayson | Kentucky | 21085 | 8014 | 134 |
2500732 | 2500732 | 2022-05-13 | Morehouse | Louisiana | 22067 | 6871 | 134 |
2501131 | 2501131 | 2022-05-13 | Lafayette | Missouri | 29107 | 7832 | 134 |
2501553 | 2501553 | 2022-05-13 | Orange | North Carolina | 37135 | 28209 | 134 |
2501837 | 2501837 | 2022-05-13 | Polk | Oregon | 41053 | 15778 | 134 |
2502255 | 2502255 | 2022-05-13 | Cooke | Texas | 48097 | 7409 | 134 |
2502417 | 2502417 | 2022-05-13 | Shelby | Texas | 48419 | 4491 | 134 |
2496371 | 2496371 | 2022-05-12 | Pike | Alabama | 1109 | 7587 | 134 |
2496734 | 2496734 | 2022-05-12 | Chattooga | Georgia | 13055 | 6687 | 134 |
2497206 | 2497206 | 2022-05-12 | Warren | Iowa | 19181 | 12591 | 134 |
2497363 | 2497363 | 2022-05-12 | Grayson | Kentucky | 21085 | 8014 | 134 |
2497474 | 2497474 | 2022-05-12 | Morehouse | Louisiana | 22067 | 6871 | 134 |
2498295 | 2498295 | 2022-05-12 | Orange | North Carolina | 37135 | 28209 | 134 |
2498579 | 2498579 | 2022-05-12 | Polk | Oregon | 41053 | 15749 | 134 |
2498997 | 2498997 | 2022-05-12 | Cooke | Texas | 48097 | 7404 | 134 |
2499159 | 2499159 | 2022-05-12 | Shelby | Texas | 48419 | 4488 | 134 |
2493113 | 2493113 | 2022-05-11 | Pike | Alabama | 1109 | 7583 | 134 |
2493476 | 2493476 | 2022-05-11 | Chattooga | Georgia | 13055 | 6687 | 134 |
2493948 | 2493948 | 2022-05-11 | Warren | Iowa | 19181 | 12591 | 134 |
2494105 | 2494105 | 2022-05-11 | Grayson | Kentucky | 21085 | 8014 | 134 |
2494216 | 2494216 | 2022-05-11 | Morehouse | Louisiana | 22067 | 6871 | 134 |
2495037 | 2495037 | 2022-05-11 | Orange | North Carolina | 37135 | 28209 | 134 |
2495176 | 2495176 | 2022-05-11 | Madison | Ohio | 39097 | 9728 | 134 |
2495263 | 2495263 | 2022-05-11 | McClain | Oklahoma | 40087 | 11757 | 134 |
2495321 | 2495321 | 2022-05-11 | Polk | Oregon | 41053 | 15719 | 134 |
2495739 | 2495739 | 2022-05-11 | Cooke | Texas | 48097 | 7401 | 134 |
2495901 | 2495901 | 2022-05-11 | Shelby | Texas | 48419 | 4486 | 134 |
2489855 | 2489855 | 2022-05-10 | Pike | Alabama | 1109 | 7582 | 134 |
2490218 | 2490218 | 2022-05-10 | Chattooga | Georgia | 13055 | 6680 | 134 |
2490690 | 2490690 | 2022-05-10 | Warren | Iowa | 19181 | 12547 | 134 |
2490847 | 2490847 | 2022-05-10 | Grayson | Kentucky | 21085 | 8014 | 134 |
2490958 | 2490958 | 2022-05-10 | Morehouse | Louisiana | 22067 | 6866 | 134 |
2491779 | 2491779 | 2022-05-10 | Orange | North Carolina | 37135 | 27771 | 134 |
2491918 | 2491918 | 2022-05-10 | Madison | Ohio | 39097 | 9728 | 134 |
2492005 | 2492005 | 2022-05-10 | McClain | Oklahoma | 40087 | 11757 | 134 |
2492063 | 2492063 | 2022-05-10 | Polk | Oregon | 41053 | 15706 | 134 |
2492481 | 2492481 | 2022-05-10 | Cooke | Texas | 48097 | 7400 | 134 |
2492643 | 2492643 | 2022-05-10 | Shelby | Texas | 48419 | 4485 | 134 |
2486598 | 2486598 | 2022-05-09 | Pike | Alabama | 1109 | 7580 | 134 |
2486961 | 2486961 | 2022-05-09 | Chattooga | Georgia | 13055 | 6680 | 134 |
2487433 | 2487433 | 2022-05-09 | Warren | Iowa | 19181 | 12547 | 134 |
2487590 | 2487590 | 2022-05-09 | Grayson | Kentucky | 21085 | 8014 | 134 |
2487701 | 2487701 | 2022-05-09 | Morehouse | Louisiana | 22067 | 6863 | 134 |
2488521 | 2488521 | 2022-05-09 | Orange | North Carolina | 37135 | 27771 | 134 |
2488660 | 2488660 | 2022-05-09 | Madison | Ohio | 39097 | 9728 | 134 |
2488747 | 2488747 | 2022-05-09 | McClain | Oklahoma | 40087 | 11757 | 134 |
2488805 | 2488805 | 2022-05-09 | Polk | Oregon | 41053 | 15663 | 134 |
2489223 | 2489223 | 2022-05-09 | Cooke | Texas | 48097 | 7396 | 134 |
2489385 | 2489385 | 2022-05-09 | Shelby | Texas | 48419 | 4485 | 134 |
2483340 | 2483340 | 2022-05-08 | Pike | Alabama | 1109 | 7580 | 134 |
2483703 | 2483703 | 2022-05-08 | Chattooga | Georgia | 13055 | 6680 | 134 |
2484175 | 2484175 | 2022-05-08 | Warren | Iowa | 19181 | 12547 | 134 |
2484443 | 2484443 | 2022-05-08 | Morehouse | Louisiana | 22067 | 6863 | 134 |
2485264 | 2485264 | 2022-05-08 | Orange | North Carolina | 37135 | 27771 | 134 |
2485403 | 2485403 | 2022-05-08 | Madison | Ohio | 39097 | 9728 | 134 |
2485490 | 2485490 | 2022-05-08 | McClain | Oklahoma | 40087 | 11757 | 134 |
2485548 | 2485548 | 2022-05-08 | Polk | Oregon | 41053 | 15628 | 134 |
2485966 | 2485966 | 2022-05-08 | Cooke | Texas | 48097 | 7395 | 134 |
2486127 | 2486127 | 2022-05-08 | Shelby | Texas | 48419 | 4485 | 134 |
2486504 | 2486504 | 2022-05-08 | Sauk | Wisconsin | 55111 | 16255 | 134 |
2480082 | 2480082 | 2022-05-07 | Pike | Alabama | 1109 | 7580 | 134 |
2480445 | 2480445 | 2022-05-07 | Chattooga | Georgia | 13055 | 6680 | 134 |
2480917 | 2480917 | 2022-05-07 | Warren | Iowa | 19181 | 12547 | 134 |
2481185 | 2481185 | 2022-05-07 | Morehouse | Louisiana | 22067 | 6863 | 134 |
2482006 | 2482006 | 2022-05-07 | Orange | North Carolina | 37135 | 27771 | 134 |
2482145 | 2482145 | 2022-05-07 | Madison | Ohio | 39097 | 9728 | 134 |
2482232 | 2482232 | 2022-05-07 | McClain | Oklahoma | 40087 | 11757 | 134 |
2482290 | 2482290 | 2022-05-07 | Polk | Oregon | 41053 | 15628 | 134 |
2482708 | 2482708 | 2022-05-07 | Cooke | Texas | 48097 | 7395 | 134 |
2482869 | 2482869 | 2022-05-07 | Shelby | Texas | 48419 | 4485 | 134 |
2483246 | 2483246 | 2022-05-07 | Sauk | Wisconsin | 55111 | 16255 | 134 |
2476824 | 2476824 | 2022-05-06 | Pike | Alabama | 1109 | 7580 | 134 |
2477187 | 2477187 | 2022-05-06 | Chattooga | Georgia | 13055 | 6680 | 134 |
2477659 | 2477659 | 2022-05-06 | Warren | Iowa | 19181 | 12547 | 134 |
2477927 | 2477927 | 2022-05-06 | Morehouse | Louisiana | 22067 | 6863 | 134 |
2478748 | 2478748 | 2022-05-06 | Orange | North Carolina | 37135 | 27771 | 134 |
2478887 | 2478887 | 2022-05-06 | Madison | Ohio | 39097 | 9728 | 134 |
2478974 | 2478974 | 2022-05-06 | McClain | Oklahoma | 40087 | 11757 | 134 |
2479032 | 2479032 | 2022-05-06 | Polk | Oregon | 41053 | 15628 | 134 |
2479450 | 2479450 | 2022-05-06 | Cooke | Texas | 48097 | 7393 | 134 |
2479611 | 2479611 | 2022-05-06 | Shelby | Texas | 48419 | 4485 | 134 |
2479988 | 2479988 | 2022-05-06 | Sauk | Wisconsin | 55111 | 16255 | 134 |
2473566 | 2473566 | 2022-05-05 | Pike | Alabama | 1109 | 7580 | 134 |
2473929 | 2473929 | 2022-05-05 | Chattooga | Georgia | 13055 | 6680 | 134 |
2474401 | 2474401 | 2022-05-05 | Warren | Iowa | 19181 | 12547 | 134 |
2474669 | 2474669 | 2022-05-05 | Morehouse | Louisiana | 22067 | 6862 | 134 |
2474691 | 2474691 | 2022-05-05 | Union | Louisiana | 22111 | 6922 | 134 |
2475490 | 2475490 | 2022-05-05 | Orange | North Carolina | 37135 | 27771 | 134 |
2475629 | 2475629 | 2022-05-05 | Madison | Ohio | 39097 | 9728 | 134 |
2475716 | 2475716 | 2022-05-05 | McClain | Oklahoma | 40087 | 11757 | 134 |
2475774 | 2475774 | 2022-05-05 | Polk | Oregon | 41053 | 15609 | 134 |
2476192 | 2476192 | 2022-05-05 | Cooke | Texas | 48097 | 7393 | 134 |
2476353 | 2476353 | 2022-05-05 | Shelby | Texas | 48419 | 4483 | 134 |
2470309 | 2470309 | 2022-05-04 | Pike | Alabama | 1109 | 7580 | 134 |
2470672 | 2470672 | 2022-05-04 | Chattooga | Georgia | 13055 | 6680 | 134 |
2471144 | 2471144 | 2022-05-04 | Warren | Iowa | 19181 | 12547 | 134 |
2471412 | 2471412 | 2022-05-04 | Morehouse | Louisiana | 22067 | 6860 | 134 |
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);