ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,102 rows where deaths = 132 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 283
- Texas 213
- Mississippi 160
- Indiana 157
- Ohio 155
- Oklahoma 152
- Tennessee 146
- South Carolina 129
- Virginia 123
- Missouri 122
- Alabama 107
- New York 92
- Wisconsin 92
- Louisiana 90
- North Carolina 87
- West Virginia 85
- Maryland 81
- Michigan 75
- Kentucky 72
- Pennsylvania 72
- Idaho 60
- Nebraska 52
- Florida 50
- Minnesota 50
- Illinois 48
- Arkansas 37
- New Mexico 33
- Colorado 29
- Massachusetts 28
- Iowa 26
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500058 | 2500058 | 2022-05-13 | Lumpkin | Georgia | 13187 | 7258 | 132 |
2500255 | 2500255 | 2022-05-13 | Randolph | Illinois | 17157 | 10567 | 132 |
2500370 | 2500370 | 2022-05-13 | Wells | Indiana | 18179 | 6511 | 132 |
2500589 | 2500589 | 2022-05-13 | Boyle | Kentucky | 21021 | 8473 | 132 |
2501080 | 2501080 | 2022-05-13 | Barry | Missouri | 29009 | 6648 | 132 |
2501568 | 2501568 | 2022-05-13 | Scotland | North Carolina | 37165 | 10125 | 132 |
2502166 | 2502166 | 2022-05-13 | Marion | Tennessee | 47115 | 8870 | 132 |
2502700 | 2502700 | 2022-05-13 | Jackson | West Virginia | 54035 | 6926 | 132 |
2502701 | 2502701 | 2022-05-13 | Jefferson | West Virginia | 54037 | 14513 | 132 |
2496800 | 2496800 | 2022-05-12 | Lumpkin | Georgia | 13187 | 7258 | 132 |
2496997 | 2496997 | 2022-05-12 | Randolph | Illinois | 17157 | 10555 | 132 |
2497112 | 2497112 | 2022-05-12 | Wells | Indiana | 18179 | 6509 | 132 |
2497331 | 2497331 | 2022-05-12 | Boyle | Kentucky | 21021 | 8473 | 132 |
2498310 | 2498310 | 2022-05-12 | Scotland | North Carolina | 37165 | 10125 | 132 |
2498908 | 2498908 | 2022-05-12 | Marion | Tennessee | 47115 | 8870 | 132 |
2499442 | 2499442 | 2022-05-12 | Jackson | West Virginia | 54035 | 6920 | 132 |
2499443 | 2499443 | 2022-05-12 | Jefferson | West Virginia | 54037 | 14491 | 132 |
2493542 | 2493542 | 2022-05-11 | Lumpkin | Georgia | 13187 | 7258 | 132 |
2493739 | 2493739 | 2022-05-11 | Randolph | Illinois | 17157 | 10554 | 132 |
2493854 | 2493854 | 2022-05-11 | Wells | Indiana | 18179 | 6509 | 132 |
2494073 | 2494073 | 2022-05-11 | Boyle | Kentucky | 21021 | 8473 | 132 |
2495052 | 2495052 | 2022-05-11 | Scotland | North Carolina | 37165 | 10125 | 132 |
2495650 | 2495650 | 2022-05-11 | Marion | Tennessee | 47115 | 8870 | 132 |
2496184 | 2496184 | 2022-05-11 | Jackson | West Virginia | 54035 | 6918 | 132 |
2490284 | 2490284 | 2022-05-10 | Lumpkin | Georgia | 13187 | 7251 | 132 |
2490481 | 2490481 | 2022-05-10 | Randolph | Illinois | 17157 | 10551 | 132 |
2490596 | 2490596 | 2022-05-10 | Wells | Indiana | 18179 | 6508 | 132 |
2490815 | 2490815 | 2022-05-10 | Boyle | Kentucky | 21021 | 8473 | 132 |
2491794 | 2491794 | 2022-05-10 | Scotland | North Carolina | 37165 | 10067 | 132 |
2492392 | 2492392 | 2022-05-10 | Marion | Tennessee | 47115 | 8863 | 132 |
2492926 | 2492926 | 2022-05-10 | Jackson | West Virginia | 54035 | 6910 | 132 |
2487027 | 2487027 | 2022-05-09 | Lumpkin | Georgia | 13187 | 7251 | 132 |
2487224 | 2487224 | 2022-05-09 | Randolph | Illinois | 17157 | 10547 | 132 |
2487339 | 2487339 | 2022-05-09 | Wells | Indiana | 18179 | 6508 | 132 |
2487558 | 2487558 | 2022-05-09 | Boyle | Kentucky | 21021 | 8473 | 132 |
2488536 | 2488536 | 2022-05-09 | Scotland | North Carolina | 37165 | 10067 | 132 |
2489134 | 2489134 | 2022-05-09 | Marion | Tennessee | 47115 | 8863 | 132 |
2489668 | 2489668 | 2022-05-09 | Jackson | West Virginia | 54035 | 6910 | 132 |
2483769 | 2483769 | 2022-05-08 | Lumpkin | Georgia | 13187 | 7250 | 132 |
2483966 | 2483966 | 2022-05-08 | Randolph | Illinois | 17157 | 10540 | 132 |
2484081 | 2484081 | 2022-05-08 | Wells | Indiana | 18179 | 6507 | 132 |
2485279 | 2485279 | 2022-05-08 | Scotland | North Carolina | 37165 | 10067 | 132 |
2485877 | 2485877 | 2022-05-08 | Marion | Tennessee | 47115 | 8863 | 132 |
2486411 | 2486411 | 2022-05-08 | Jackson | West Virginia | 54035 | 6902 | 132 |
2480511 | 2480511 | 2022-05-07 | Lumpkin | Georgia | 13187 | 7250 | 132 |
2480708 | 2480708 | 2022-05-07 | Randolph | Illinois | 17157 | 10540 | 132 |
2480823 | 2480823 | 2022-05-07 | Wells | Indiana | 18179 | 6507 | 132 |
2482021 | 2482021 | 2022-05-07 | Scotland | North Carolina | 37165 | 10067 | 132 |
2482619 | 2482619 | 2022-05-07 | Marion | Tennessee | 47115 | 8863 | 132 |
2483153 | 2483153 | 2022-05-07 | Jackson | West Virginia | 54035 | 6902 | 132 |
2477253 | 2477253 | 2022-05-06 | Lumpkin | Georgia | 13187 | 7250 | 132 |
2477450 | 2477450 | 2022-05-06 | Randolph | Illinois | 17157 | 10540 | 132 |
2477565 | 2477565 | 2022-05-06 | Wells | Indiana | 18179 | 6507 | 132 |
2478763 | 2478763 | 2022-05-06 | Scotland | North Carolina | 37165 | 10067 | 132 |
2479361 | 2479361 | 2022-05-06 | Marion | Tennessee | 47115 | 8863 | 132 |
2479895 | 2479895 | 2022-05-06 | Jackson | West Virginia | 54035 | 6902 | 132 |
2473995 | 2473995 | 2022-05-05 | Lumpkin | Georgia | 13187 | 7250 | 132 |
2474192 | 2474192 | 2022-05-05 | Randolph | Illinois | 17157 | 10533 | 132 |
2474307 | 2474307 | 2022-05-05 | Wells | Indiana | 18179 | 6507 | 132 |
2475505 | 2475505 | 2022-05-05 | Scotland | North Carolina | 37165 | 10067 | 132 |
2476103 | 2476103 | 2022-05-05 | Marion | Tennessee | 47115 | 8863 | 132 |
2476637 | 2476637 | 2022-05-05 | Jackson | West Virginia | 54035 | 6900 | 132 |
2470738 | 2470738 | 2022-05-04 | Lumpkin | Georgia | 13187 | 7250 | 132 |
2470935 | 2470935 | 2022-05-04 | Randolph | Illinois | 17157 | 10522 | 132 |
2471050 | 2471050 | 2022-05-04 | Wells | Indiana | 18179 | 6507 | 132 |
2472248 | 2472248 | 2022-05-04 | Scotland | North Carolina | 37165 | 10067 | 132 |
2472846 | 2472846 | 2022-05-04 | Marion | Tennessee | 47115 | 8863 | 132 |
2473379 | 2473379 | 2022-05-04 | Jackson | West Virginia | 54035 | 6898 | 132 |
2467482 | 2467482 | 2022-05-03 | Lumpkin | Georgia | 13187 | 7248 | 132 |
2467794 | 2467794 | 2022-05-03 | Wells | Indiana | 18179 | 6506 | 132 |
2469590 | 2469590 | 2022-05-03 | Marion | Tennessee | 47115 | 8862 | 132 |
2470122 | 2470122 | 2022-05-03 | Jackson | West Virginia | 54035 | 6897 | 132 |
2464227 | 2464227 | 2022-05-02 | Lumpkin | Georgia | 13187 | 7248 | 132 |
2464539 | 2464539 | 2022-05-02 | Wells | Indiana | 18179 | 6506 | 132 |
2466334 | 2466334 | 2022-05-02 | Marion | Tennessee | 47115 | 8862 | 132 |
2466866 | 2466866 | 2022-05-02 | Jackson | West Virginia | 54035 | 6894 | 132 |
2460971 | 2460971 | 2022-05-01 | Lumpkin | Georgia | 13187 | 7246 | 132 |
2461283 | 2461283 | 2022-05-01 | Wells | Indiana | 18179 | 6506 | 132 |
2463079 | 2463079 | 2022-05-01 | Marion | Tennessee | 47115 | 8862 | 132 |
2463611 | 2463611 | 2022-05-01 | Jackson | West Virginia | 54035 | 6889 | 132 |
2457715 | 2457715 | 2022-04-30 | Lumpkin | Georgia | 13187 | 7246 | 132 |
2458027 | 2458027 | 2022-04-30 | Wells | Indiana | 18179 | 6506 | 132 |
2459823 | 2459823 | 2022-04-30 | Marion | Tennessee | 47115 | 8862 | 132 |
2460355 | 2460355 | 2022-04-30 | Jackson | West Virginia | 54035 | 6889 | 132 |
2454459 | 2454459 | 2022-04-29 | Lumpkin | Georgia | 13187 | 7246 | 132 |
2454771 | 2454771 | 2022-04-29 | Wells | Indiana | 18179 | 6506 | 132 |
2456567 | 2456567 | 2022-04-29 | Marion | Tennessee | 47115 | 8862 | 132 |
2457099 | 2457099 | 2022-04-29 | Jackson | West Virginia | 54035 | 6889 | 132 |
2451203 | 2451203 | 2022-04-28 | Lumpkin | Georgia | 13187 | 7246 | 132 |
2451515 | 2451515 | 2022-04-28 | Wells | Indiana | 18179 | 6503 | 132 |
2453311 | 2453311 | 2022-04-28 | Marion | Tennessee | 47115 | 8862 | 132 |
2453843 | 2453843 | 2022-04-28 | Jackson | West Virginia | 54035 | 6888 | 132 |
2447947 | 2447947 | 2022-04-27 | Lumpkin | Georgia | 13187 | 7246 | 132 |
2448259 | 2448259 | 2022-04-27 | Wells | Indiana | 18179 | 6503 | 132 |
2449581 | 2449581 | 2022-04-27 | Madison | Ohio | 39097 | 9691 | 132 |
2450055 | 2450055 | 2022-04-27 | Marion | Tennessee | 47115 | 8862 | 132 |
2450587 | 2450587 | 2022-04-27 | Jackson | West Virginia | 54035 | 6888 | 132 |
2444625 | 2444625 | 2022-04-26 | Chattooga | Georgia | 13055 | 6670 | 132 |
2444691 | 2444691 | 2022-04-26 | Lumpkin | Georgia | 13187 | 7235 | 132 |
2445003 | 2445003 | 2022-04-26 | Wells | Indiana | 18179 | 6501 | 132 |
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);