ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,698 rows where deaths = 162 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 156
- Texas 114
- Ohio 110
- Indiana 103
- North Carolina 81
- Tennessee 81
- Arkansas 79
- Virginia 70
- Alabama 68
- Louisiana 66
- Michigan 65
- South Carolina 63
- Missouri 47
- New York 46
- Washington 46
- Kentucky 43
- Illinois 42
- Pennsylvania 37
- Wisconsin 37
- Florida 36
- Oklahoma 29
- New Jersey 28
- Minnesota 24
- Mississippi 23
- California 22
- Maryland 18
- Oregon 18
- Utah 17
- Iowa 16
- New Mexico 16
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499583 | 2499583 | 2022-05-13 | Chambers | Alabama | 1017 | 8508 | 162 |
2500684 | 2500684 | 2022-05-13 | Shelby | Kentucky | 21211 | 13410 | 162 |
2501045 | 2501045 | 2022-05-13 | Oktibbeha | Mississippi | 28105 | 11127 | 162 |
2502646 | 2502646 | 2022-05-13 | Chelan | Washington | 53007 | 20463 | 162 |
2496325 | 2496325 | 2022-05-12 | Chambers | Alabama | 1017 | 8506 | 162 |
2497426 | 2497426 | 2022-05-12 | Shelby | Kentucky | 21211 | 13410 | 162 |
2497787 | 2497787 | 2022-05-12 | Oktibbeha | Mississippi | 28105 | 11127 | 162 |
2499388 | 2499388 | 2022-05-12 | Chelan | Washington | 53007 | 20426 | 162 |
2493067 | 2493067 | 2022-05-11 | Chambers | Alabama | 1017 | 8505 | 162 |
2494168 | 2494168 | 2022-05-11 | Shelby | Kentucky | 21211 | 13410 | 162 |
2494529 | 2494529 | 2022-05-11 | Oktibbeha | Mississippi | 28105 | 11127 | 162 |
2496130 | 2496130 | 2022-05-11 | Chelan | Washington | 53007 | 20426 | 162 |
2489809 | 2489809 | 2022-05-10 | Chambers | Alabama | 1017 | 8503 | 162 |
2490910 | 2490910 | 2022-05-10 | Shelby | Kentucky | 21211 | 13410 | 162 |
2491271 | 2491271 | 2022-05-10 | Oktibbeha | Mississippi | 28105 | 11127 | 162 |
2492872 | 2492872 | 2022-05-10 | Chelan | Washington | 53007 | 20369 | 162 |
2486552 | 2486552 | 2022-05-09 | Chambers | Alabama | 1017 | 8495 | 162 |
2487653 | 2487653 | 2022-05-09 | Shelby | Kentucky | 21211 | 13410 | 162 |
2488014 | 2488014 | 2022-05-09 | Oktibbeha | Mississippi | 28105 | 11127 | 162 |
2489614 | 2489614 | 2022-05-09 | Chelan | Washington | 53007 | 20367 | 162 |
2483294 | 2483294 | 2022-05-08 | Chambers | Alabama | 1017 | 8492 | 162 |
2486357 | 2486357 | 2022-05-08 | Chelan | Washington | 53007 | 20321 | 162 |
2480036 | 2480036 | 2022-05-07 | Chambers | Alabama | 1017 | 8492 | 162 |
2483099 | 2483099 | 2022-05-07 | Chelan | Washington | 53007 | 20321 | 162 |
2476778 | 2476778 | 2022-05-06 | Chambers | Alabama | 1017 | 8492 | 162 |
2479841 | 2479841 | 2022-05-06 | Chelan | Washington | 53007 | 20321 | 162 |
2473520 | 2473520 | 2022-05-05 | Chambers | Alabama | 1017 | 8492 | 162 |
2476448 | 2476448 | 2022-05-05 | Albemarle | Virginia | 51003 | 18278 | 162 |
2476583 | 2476583 | 2022-05-05 | Chelan | Washington | 53007 | 20310 | 162 |
2470263 | 2470263 | 2022-05-04 | Chambers | Alabama | 1017 | 8490 | 162 |
2473190 | 2473190 | 2022-05-04 | Albemarle | Virginia | 51003 | 18228 | 162 |
2473325 | 2473325 | 2022-05-04 | Chelan | Washington | 53007 | 20308 | 162 |
2467007 | 2467007 | 2022-05-03 | Chambers | Alabama | 1017 | 8490 | 162 |
2468916 | 2468916 | 2022-05-03 | Beaufort | North Carolina | 37013 | 12609 | 162 |
2469934 | 2469934 | 2022-05-03 | Albemarle | Virginia | 51003 | 18160 | 162 |
2470069 | 2470069 | 2022-05-03 | Chelan | Washington | 53007 | 20277 | 162 |
2463752 | 2463752 | 2022-05-02 | Chambers | Alabama | 1017 | 8487 | 162 |
2465660 | 2465660 | 2022-05-02 | Beaufort | North Carolina | 37013 | 12609 | 162 |
2466199 | 2466199 | 2022-05-02 | Marion | South Carolina | 45067 | 8548 | 162 |
2466678 | 2466678 | 2022-05-02 | Albemarle | Virginia | 51003 | 18139 | 162 |
2466813 | 2466813 | 2022-05-02 | Chelan | Washington | 53007 | 20276 | 162 |
2460496 | 2460496 | 2022-05-01 | Chambers | Alabama | 1017 | 8486 | 162 |
2462405 | 2462405 | 2022-05-01 | Beaufort | North Carolina | 37013 | 12609 | 162 |
2462944 | 2462944 | 2022-05-01 | Marion | South Carolina | 45067 | 8548 | 162 |
2463423 | 2463423 | 2022-05-01 | Albemarle | Virginia | 51003 | 18081 | 162 |
2463558 | 2463558 | 2022-05-01 | Chelan | Washington | 53007 | 20247 | 162 |
2457240 | 2457240 | 2022-04-30 | Chambers | Alabama | 1017 | 8486 | 162 |
2459149 | 2459149 | 2022-04-30 | Beaufort | North Carolina | 37013 | 12609 | 162 |
2459688 | 2459688 | 2022-04-30 | Marion | South Carolina | 45067 | 8548 | 162 |
2460167 | 2460167 | 2022-04-30 | Albemarle | Virginia | 51003 | 18081 | 162 |
2460302 | 2460302 | 2022-04-30 | Chelan | Washington | 53007 | 20247 | 162 |
2453984 | 2453984 | 2022-04-29 | Chambers | Alabama | 1017 | 8486 | 162 |
2455893 | 2455893 | 2022-04-29 | Beaufort | North Carolina | 37013 | 12609 | 162 |
2456432 | 2456432 | 2022-04-29 | Marion | South Carolina | 45067 | 8548 | 162 |
2456911 | 2456911 | 2022-04-29 | Albemarle | Virginia | 51003 | 18081 | 162 |
2457046 | 2457046 | 2022-04-29 | Chelan | Washington | 53007 | 20247 | 162 |
2450728 | 2450728 | 2022-04-28 | Chambers | Alabama | 1017 | 8486 | 162 |
2452637 | 2452637 | 2022-04-28 | Beaufort | North Carolina | 37013 | 12609 | 162 |
2453176 | 2453176 | 2022-04-28 | Marion | South Carolina | 45067 | 8548 | 162 |
2453655 | 2453655 | 2022-04-28 | Albemarle | Virginia | 51003 | 18052 | 162 |
2453790 | 2453790 | 2022-04-28 | Chelan | Washington | 53007 | 20224 | 162 |
2447472 | 2447472 | 2022-04-27 | Chambers | Alabama | 1017 | 8484 | 162 |
2449381 | 2449381 | 2022-04-27 | Beaufort | North Carolina | 37013 | 12609 | 162 |
2449920 | 2449920 | 2022-04-27 | Marion | South Carolina | 45067 | 8544 | 162 |
2450399 | 2450399 | 2022-04-27 | Albemarle | Virginia | 51003 | 18020 | 162 |
2450534 | 2450534 | 2022-04-27 | Chelan | Washington | 53007 | 20222 | 162 |
2444216 | 2444216 | 2022-04-26 | Chambers | Alabama | 1017 | 8483 | 162 |
2444621 | 2444621 | 2022-04-26 | Catoosa | Georgia | 13047 | 14712 | 162 |
2446663 | 2446663 | 2022-04-26 | Marion | South Carolina | 45067 | 8544 | 162 |
2447142 | 2447142 | 2022-04-26 | Albemarle | Virginia | 51003 | 17979 | 162 |
2447278 | 2447278 | 2022-04-26 | Chelan | Washington | 53007 | 20195 | 162 |
2440960 | 2440960 | 2022-04-25 | Chambers | Alabama | 1017 | 8483 | 162 |
2441365 | 2441365 | 2022-04-25 | Catoosa | Georgia | 13047 | 14712 | 162 |
2443408 | 2443408 | 2022-04-25 | Marion | South Carolina | 45067 | 8544 | 162 |
2443887 | 2443887 | 2022-04-25 | Albemarle | Virginia | 51003 | 17933 | 162 |
2444022 | 2444022 | 2022-04-25 | Chelan | Washington | 53007 | 20195 | 162 |
2437704 | 2437704 | 2022-04-24 | Chambers | Alabama | 1017 | 8483 | 162 |
2438109 | 2438109 | 2022-04-24 | Catoosa | Georgia | 13047 | 14710 | 162 |
2440152 | 2440152 | 2022-04-24 | Marion | South Carolina | 45067 | 8544 | 162 |
2440631 | 2440631 | 2022-04-24 | Albemarle | Virginia | 51003 | 17890 | 162 |
2440766 | 2440766 | 2022-04-24 | Chelan | Washington | 53007 | 20175 | 162 |
2434448 | 2434448 | 2022-04-23 | Chambers | Alabama | 1017 | 8483 | 162 |
2434853 | 2434853 | 2022-04-23 | Catoosa | Georgia | 13047 | 14710 | 162 |
2436896 | 2436896 | 2022-04-23 | Marion | South Carolina | 45067 | 8544 | 162 |
2437375 | 2437375 | 2022-04-23 | Albemarle | Virginia | 51003 | 17890 | 162 |
2437510 | 2437510 | 2022-04-23 | Chelan | Washington | 53007 | 20175 | 162 |
2431192 | 2431192 | 2022-04-22 | Chambers | Alabama | 1017 | 8483 | 162 |
2431597 | 2431597 | 2022-04-22 | Catoosa | Georgia | 13047 | 14710 | 162 |
2433640 | 2433640 | 2022-04-22 | Marion | South Carolina | 45067 | 8544 | 162 |
2434119 | 2434119 | 2022-04-22 | Albemarle | Virginia | 51003 | 17890 | 162 |
2434254 | 2434254 | 2022-04-22 | Chelan | Washington | 53007 | 20175 | 162 |
2427936 | 2427936 | 2022-04-21 | Chambers | Alabama | 1017 | 8482 | 162 |
2428341 | 2428341 | 2022-04-21 | Catoosa | Georgia | 13047 | 14710 | 162 |
2430384 | 2430384 | 2022-04-21 | Marion | South Carolina | 45067 | 8544 | 162 |
2430863 | 2430863 | 2022-04-21 | Albemarle | Virginia | 51003 | 17869 | 162 |
2430998 | 2430998 | 2022-04-21 | Chelan | Washington | 53007 | 20154 | 162 |
2424680 | 2424680 | 2022-04-20 | Chambers | Alabama | 1017 | 8480 | 162 |
2425085 | 2425085 | 2022-04-20 | Catoosa | Georgia | 13047 | 14710 | 162 |
2427128 | 2427128 | 2022-04-20 | Marion | South Carolina | 45067 | 8544 | 162 |
2427607 | 2427607 | 2022-04-20 | Albemarle | Virginia | 51003 | 17850 | 162 |
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);