ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,395 rows where deaths = 231 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 151
- Alabama 127
- Georgia 93
- North Carolina 92
- Ohio 69
- Indiana 67
- Oklahoma 59
- Illinois 57
- Tennessee 57
- Pennsylvania 53
- Louisiana 48
- Michigan 47
- Kentucky 34
- California 32
- Arkansas 31
- Oregon 27
- Arizona 23
- Iowa 23
- Colorado 22
- Washington 22
- Alaska 21
- Missouri 21
- South Carolina 21
- Virginia 21
- Wisconsin 21
- New York 20
- Maryland 18
- Wyoming 14
- Mississippi 13
- New Mexico 13
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499590 | 2499590 | 2022-05-13 | Coffee | Alabama | 1031 | 13643 | 231 |
2499597 | 2499597 | 2022-05-13 | Dale | Alabama | 1045 | 12947 | 231 |
2500312 | 2500312 | 2022-05-13 | Henry | Indiana | 18065 | 13055 | 231 |
2502213 | 2502213 | 2022-05-13 | Atascosa | Texas | 48013 | 13647 | 231 |
2496332 | 2496332 | 2022-05-12 | Coffee | Alabama | 1031 | 13638 | 231 |
2496339 | 2496339 | 2022-05-12 | Dale | Alabama | 1045 | 12939 | 231 |
2497054 | 2497054 | 2022-05-12 | Henry | Indiana | 18065 | 13044 | 231 |
2498955 | 2498955 | 2022-05-12 | Atascosa | Texas | 48013 | 13647 | 231 |
2493074 | 2493074 | 2022-05-11 | Coffee | Alabama | 1031 | 13632 | 231 |
2493081 | 2493081 | 2022-05-11 | Dale | Alabama | 1045 | 12930 | 231 |
2493796 | 2493796 | 2022-05-11 | Henry | Indiana | 18065 | 13044 | 231 |
2495697 | 2495697 | 2022-05-11 | Atascosa | Texas | 48013 | 13645 | 231 |
2489816 | 2489816 | 2022-05-10 | Coffee | Alabama | 1031 | 13632 | 231 |
2489823 | 2489823 | 2022-05-10 | Dale | Alabama | 1045 | 12927 | 231 |
2490538 | 2490538 | 2022-05-10 | Henry | Indiana | 18065 | 13037 | 231 |
2491122 | 2491122 | 2022-05-10 | Shiawassee | Michigan | 26155 | 17988 | 231 |
2492439 | 2492439 | 2022-05-10 | Atascosa | Texas | 48013 | 13640 | 231 |
2486559 | 2486559 | 2022-05-09 | Coffee | Alabama | 1031 | 13628 | 231 |
2486566 | 2486566 | 2022-05-09 | Dale | Alabama | 1045 | 12923 | 231 |
2487281 | 2487281 | 2022-05-09 | Henry | Indiana | 18065 | 13037 | 231 |
2487865 | 2487865 | 2022-05-09 | Shiawassee | Michigan | 26155 | 17988 | 231 |
2489181 | 2489181 | 2022-05-09 | Atascosa | Texas | 48013 | 13636 | 231 |
2483301 | 2483301 | 2022-05-08 | Coffee | Alabama | 1031 | 13615 | 231 |
2483308 | 2483308 | 2022-05-08 | Dale | Alabama | 1045 | 12920 | 231 |
2484023 | 2484023 | 2022-05-08 | Henry | Indiana | 18065 | 13020 | 231 |
2484607 | 2484607 | 2022-05-08 | Shiawassee | Michigan | 26155 | 17988 | 231 |
2485924 | 2485924 | 2022-05-08 | Atascosa | Texas | 48013 | 13632 | 231 |
2480043 | 2480043 | 2022-05-07 | Coffee | Alabama | 1031 | 13615 | 231 |
2480050 | 2480050 | 2022-05-07 | Dale | Alabama | 1045 | 12920 | 231 |
2480765 | 2480765 | 2022-05-07 | Henry | Indiana | 18065 | 13020 | 231 |
2481349 | 2481349 | 2022-05-07 | Shiawassee | Michigan | 26155 | 17988 | 231 |
2482666 | 2482666 | 2022-05-07 | Atascosa | Texas | 48013 | 13632 | 231 |
2476785 | 2476785 | 2022-05-06 | Coffee | Alabama | 1031 | 13615 | 231 |
2476792 | 2476792 | 2022-05-06 | Dale | Alabama | 1045 | 12920 | 231 |
2477507 | 2477507 | 2022-05-06 | Henry | Indiana | 18065 | 13020 | 231 |
2478091 | 2478091 | 2022-05-06 | Shiawassee | Michigan | 26155 | 17988 | 231 |
2479408 | 2479408 | 2022-05-06 | Atascosa | Texas | 48013 | 13631 | 231 |
2473527 | 2473527 | 2022-05-05 | Coffee | Alabama | 1031 | 13614 | 231 |
2473534 | 2473534 | 2022-05-05 | Dale | Alabama | 1045 | 12915 | 231 |
2474249 | 2474249 | 2022-05-05 | Henry | Indiana | 18065 | 13020 | 231 |
2474833 | 2474833 | 2022-05-05 | Shiawassee | Michigan | 26155 | 17988 | 231 |
2476150 | 2476150 | 2022-05-05 | Atascosa | Texas | 48013 | 13630 | 231 |
2476746 | 2476746 | 2022-05-05 | Wood | Wisconsin | 55141 | 21247 | 231 |
2470270 | 2470270 | 2022-05-04 | Coffee | Alabama | 1031 | 13608 | 231 |
2470277 | 2470277 | 2022-05-04 | Dale | Alabama | 1045 | 12915 | 231 |
2470992 | 2470992 | 2022-05-04 | Henry | Indiana | 18065 | 13020 | 231 |
2471576 | 2471576 | 2022-05-04 | Shiawassee | Michigan | 26155 | 17988 | 231 |
2472893 | 2472893 | 2022-05-04 | Atascosa | Texas | 48013 | 13585 | 231 |
2473488 | 2473488 | 2022-05-04 | Wood | Wisconsin | 55141 | 21218 | 231 |
2467014 | 2467014 | 2022-05-03 | Coffee | Alabama | 1031 | 13608 | 231 |
2467021 | 2467021 | 2022-05-03 | Dale | Alabama | 1045 | 12910 | 231 |
2467418 | 2467418 | 2022-05-03 | Clarke | Georgia | 13059 | 29740 | 231 |
2467736 | 2467736 | 2022-05-03 | Henry | Indiana | 18065 | 13013 | 231 |
2468320 | 2468320 | 2022-05-03 | Shiawassee | Michigan | 26155 | 17880 | 231 |
2469637 | 2469637 | 2022-05-03 | Atascosa | Texas | 48013 | 13577 | 231 |
2463759 | 2463759 | 2022-05-02 | Coffee | Alabama | 1031 | 13603 | 231 |
2463766 | 2463766 | 2022-05-02 | Dale | Alabama | 1045 | 12907 | 231 |
2464163 | 2464163 | 2022-05-02 | Clarke | Georgia | 13059 | 29740 | 231 |
2464481 | 2464481 | 2022-05-02 | Henry | Indiana | 18065 | 13013 | 231 |
2465065 | 2465065 | 2022-05-02 | Shiawassee | Michigan | 26155 | 17880 | 231 |
2466381 | 2466381 | 2022-05-02 | Atascosa | Texas | 48013 | 13576 | 231 |
2460503 | 2460503 | 2022-05-01 | Coffee | Alabama | 1031 | 13599 | 231 |
2460510 | 2460510 | 2022-05-01 | Dale | Alabama | 1045 | 12898 | 231 |
2460907 | 2460907 | 2022-05-01 | Clarke | Georgia | 13059 | 29740 | 231 |
2461225 | 2461225 | 2022-05-01 | Henry | Indiana | 18065 | 13008 | 231 |
2461809 | 2461809 | 2022-05-01 | Shiawassee | Michigan | 26155 | 17880 | 231 |
2463126 | 2463126 | 2022-05-01 | Atascosa | Texas | 48013 | 13576 | 231 |
2457247 | 2457247 | 2022-04-30 | Coffee | Alabama | 1031 | 13599 | 231 |
2457254 | 2457254 | 2022-04-30 | Dale | Alabama | 1045 | 12898 | 231 |
2457651 | 2457651 | 2022-04-30 | Clarke | Georgia | 13059 | 29740 | 231 |
2457969 | 2457969 | 2022-04-30 | Henry | Indiana | 18065 | 13008 | 231 |
2458553 | 2458553 | 2022-04-30 | Shiawassee | Michigan | 26155 | 17880 | 231 |
2459091 | 2459091 | 2022-04-30 | Chemung | New York | 36015 | 22098 | 231 |
2459870 | 2459870 | 2022-04-30 | Atascosa | Texas | 48013 | 13573 | 231 |
2453991 | 2453991 | 2022-04-29 | Coffee | Alabama | 1031 | 13599 | 231 |
2453998 | 2453998 | 2022-04-29 | Dale | Alabama | 1045 | 12898 | 231 |
2454395 | 2454395 | 2022-04-29 | Clarke | Georgia | 13059 | 29740 | 231 |
2454713 | 2454713 | 2022-04-29 | Henry | Indiana | 18065 | 13008 | 231 |
2455297 | 2455297 | 2022-04-29 | Shiawassee | Michigan | 26155 | 17880 | 231 |
2455835 | 2455835 | 2022-04-29 | Chemung | New York | 36015 | 22048 | 231 |
2456614 | 2456614 | 2022-04-29 | Atascosa | Texas | 48013 | 13572 | 231 |
2450735 | 2450735 | 2022-04-28 | Coffee | Alabama | 1031 | 13596 | 231 |
2450742 | 2450742 | 2022-04-28 | Dale | Alabama | 1045 | 12895 | 231 |
2451139 | 2451139 | 2022-04-28 | Clarke | Georgia | 13059 | 29740 | 231 |
2451457 | 2451457 | 2022-04-28 | Henry | Indiana | 18065 | 13003 | 231 |
2452041 | 2452041 | 2022-04-28 | Shiawassee | Michigan | 26155 | 17880 | 231 |
2452579 | 2452579 | 2022-04-28 | Chemung | New York | 36015 | 21998 | 231 |
2453358 | 2453358 | 2022-04-28 | Atascosa | Texas | 48013 | 13570 | 231 |
2447479 | 2447479 | 2022-04-27 | Coffee | Alabama | 1031 | 13593 | 231 |
2447486 | 2447486 | 2022-04-27 | Dale | Alabama | 1045 | 12894 | 231 |
2447883 | 2447883 | 2022-04-27 | Clarke | Georgia | 13059 | 29740 | 231 |
2448201 | 2448201 | 2022-04-27 | Henry | Indiana | 18065 | 13003 | 231 |
2448785 | 2448785 | 2022-04-27 | Shiawassee | Michigan | 26155 | 17880 | 231 |
2449323 | 2449323 | 2022-04-27 | Chemung | New York | 36015 | 21934 | 231 |
2450102 | 2450102 | 2022-04-27 | Atascosa | Texas | 48013 | 13568 | 231 |
2444223 | 2444223 | 2022-04-26 | Coffee | Alabama | 1031 | 13591 | 231 |
2444230 | 2444230 | 2022-04-26 | Dale | Alabama | 1045 | 12892 | 231 |
2444945 | 2444945 | 2022-04-26 | Henry | Indiana | 18065 | 12992 | 231 |
2446066 | 2446066 | 2022-04-26 | Chemung | New York | 36015 | 21884 | 231 |
2446845 | 2446845 | 2022-04-26 | Atascosa | Texas | 48013 | 13566 | 231 |
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);