ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,878 rows where deaths = 135 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 219
- Ohio 213
- Mississippi 182
- Georgia 175
- Louisiana 170
- Pennsylvania 140
- Virginia 126
- Tennessee 116
- Indiana 102
- New York 100
- Kentucky 98
- Oklahoma 94
- Wisconsin 85
- West Virginia 78
- South Carolina 77
- Missouri 74
- Michigan 69
- Illinois 60
- Florida 59
- North Carolina 54
- Alabama 52
- Minnesota 51
- New Mexico 48
- Iowa 47
- Arkansas 43
- Colorado 42
- Washington 42
- Wyoming 41
- California 38
- Nevada 35
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500205 | 2500205 | 2022-05-13 | Fulton | Illinois | 17057 | 10257 | 135 |
2500714 | 2500714 | 2022-05-13 | De Soto | Louisiana | 22031 | 7362 | 135 |
2500754 | 2500754 | 2022-05-13 | Union | Louisiana | 22111 | 6928 | 135 |
2501038 | 2501038 | 2022-05-13 | Marion | Mississippi | 28091 | 6974 | 135 |
2501415 | 2501415 | 2022-05-13 | Rio Arriba | New Mexico | 35039 | 10047 | 135 |
2501799 | 2501799 | 2022-05-13 | Seminole | Oklahoma | 40133 | 6142 | 135 |
2502323 | 2502323 | 2022-05-13 | Hutchinson | Texas | 48233 | 6755 | 135 |
2496947 | 2496947 | 2022-05-12 | Fulton | Illinois | 17057 | 10230 | 135 |
2497456 | 2497456 | 2022-05-12 | De Soto | Louisiana | 22031 | 7361 | 135 |
2497496 | 2497496 | 2022-05-12 | Union | Louisiana | 22111 | 6928 | 135 |
2497780 | 2497780 | 2022-05-12 | Marion | Mississippi | 28091 | 6974 | 135 |
2498157 | 2498157 | 2022-05-12 | Rio Arriba | New Mexico | 35039 | 10028 | 135 |
2498541 | 2498541 | 2022-05-12 | Seminole | Oklahoma | 40133 | 6142 | 135 |
2499065 | 2499065 | 2022-05-12 | Hutchinson | Texas | 48233 | 6755 | 135 |
2493689 | 2493689 | 2022-05-11 | Fulton | Illinois | 17057 | 10227 | 135 |
2494198 | 2494198 | 2022-05-11 | De Soto | Louisiana | 22031 | 7359 | 135 |
2494238 | 2494238 | 2022-05-11 | Union | Louisiana | 22111 | 6925 | 135 |
2494522 | 2494522 | 2022-05-11 | Marion | Mississippi | 28091 | 6974 | 135 |
2494899 | 2494899 | 2022-05-11 | Rio Arriba | New Mexico | 35039 | 9956 | 135 |
2495283 | 2495283 | 2022-05-11 | Seminole | Oklahoma | 40133 | 6136 | 135 |
2495807 | 2495807 | 2022-05-11 | Hutchinson | Texas | 48233 | 6755 | 135 |
2490431 | 2490431 | 2022-05-10 | Fulton | Illinois | 17057 | 10218 | 135 |
2490940 | 2490940 | 2022-05-10 | De Soto | Louisiana | 22031 | 7355 | 135 |
2490980 | 2490980 | 2022-05-10 | Union | Louisiana | 22111 | 6925 | 135 |
2491264 | 2491264 | 2022-05-10 | Marion | Mississippi | 28091 | 6974 | 135 |
2491641 | 2491641 | 2022-05-10 | Rio Arriba | New Mexico | 35039 | 9947 | 135 |
2492025 | 2492025 | 2022-05-10 | Seminole | Oklahoma | 40133 | 6136 | 135 |
2492549 | 2492549 | 2022-05-10 | Hutchinson | Texas | 48233 | 6755 | 135 |
2487174 | 2487174 | 2022-05-09 | Fulton | Illinois | 17057 | 10204 | 135 |
2487683 | 2487683 | 2022-05-09 | De Soto | Louisiana | 22031 | 7353 | 135 |
2487723 | 2487723 | 2022-05-09 | Union | Louisiana | 22111 | 6925 | 135 |
2487898 | 2487898 | 2022-05-09 | Goodhue | Minnesota | 27049 | 13506 | 135 |
2488007 | 2488007 | 2022-05-09 | Marion | Mississippi | 28091 | 6974 | 135 |
2488383 | 2488383 | 2022-05-09 | Rio Arriba | New Mexico | 35039 | 9939 | 135 |
2488767 | 2488767 | 2022-05-09 | Seminole | Oklahoma | 40133 | 6136 | 135 |
2489291 | 2489291 | 2022-05-09 | Hutchinson | Texas | 48233 | 6755 | 135 |
2483916 | 2483916 | 2022-05-08 | Fulton | Illinois | 17057 | 10183 | 135 |
2484358 | 2484358 | 2022-05-08 | Lincoln | Kentucky | 21137 | 6474 | 135 |
2484425 | 2484425 | 2022-05-08 | De Soto | Louisiana | 22031 | 7350 | 135 |
2484465 | 2484465 | 2022-05-08 | Union | Louisiana | 22111 | 6924 | 135 |
2484640 | 2484640 | 2022-05-08 | Goodhue | Minnesota | 27049 | 13483 | 135 |
2484749 | 2484749 | 2022-05-08 | Marion | Mississippi | 28091 | 6965 | 135 |
2485126 | 2485126 | 2022-05-08 | Rio Arriba | New Mexico | 35039 | 9921 | 135 |
2485510 | 2485510 | 2022-05-08 | Seminole | Oklahoma | 40133 | 6136 | 135 |
2486034 | 2486034 | 2022-05-08 | Hutchinson | Texas | 48233 | 6755 | 135 |
2480658 | 2480658 | 2022-05-07 | Fulton | Illinois | 17057 | 10183 | 135 |
2481100 | 2481100 | 2022-05-07 | Lincoln | Kentucky | 21137 | 6474 | 135 |
2481167 | 2481167 | 2022-05-07 | De Soto | Louisiana | 22031 | 7350 | 135 |
2481207 | 2481207 | 2022-05-07 | Union | Louisiana | 22111 | 6924 | 135 |
2481382 | 2481382 | 2022-05-07 | Goodhue | Minnesota | 27049 | 13483 | 135 |
2481491 | 2481491 | 2022-05-07 | Marion | Mississippi | 28091 | 6965 | 135 |
2481868 | 2481868 | 2022-05-07 | Rio Arriba | New Mexico | 35039 | 9921 | 135 |
2482252 | 2482252 | 2022-05-07 | Seminole | Oklahoma | 40133 | 6136 | 135 |
2482776 | 2482776 | 2022-05-07 | Hutchinson | Texas | 48233 | 6755 | 135 |
2476910 | 2476910 | 2022-05-06 | Hot Spring | Arkansas | 5059 | 11215 | 135 |
2477400 | 2477400 | 2022-05-06 | Fulton | Illinois | 17057 | 10183 | 135 |
2477842 | 2477842 | 2022-05-06 | Lincoln | Kentucky | 21137 | 6474 | 135 |
2477909 | 2477909 | 2022-05-06 | De Soto | Louisiana | 22031 | 7350 | 135 |
2477949 | 2477949 | 2022-05-06 | Union | Louisiana | 22111 | 6924 | 135 |
2478124 | 2478124 | 2022-05-06 | Goodhue | Minnesota | 27049 | 13483 | 135 |
2478233 | 2478233 | 2022-05-06 | Marion | Mississippi | 28091 | 6965 | 135 |
2478610 | 2478610 | 2022-05-06 | Rio Arriba | New Mexico | 35039 | 9921 | 135 |
2478994 | 2478994 | 2022-05-06 | Seminole | Oklahoma | 40133 | 6136 | 135 |
2479518 | 2479518 | 2022-05-06 | Hutchinson | Texas | 48233 | 6755 | 135 |
2473652 | 2473652 | 2022-05-05 | Hot Spring | Arkansas | 5059 | 11213 | 135 |
2474142 | 2474142 | 2022-05-05 | Fulton | Illinois | 17057 | 10172 | 135 |
2474584 | 2474584 | 2022-05-05 | Lincoln | Kentucky | 21137 | 6474 | 135 |
2474651 | 2474651 | 2022-05-05 | De Soto | Louisiana | 22031 | 7346 | 135 |
2474866 | 2474866 | 2022-05-05 | Goodhue | Minnesota | 27049 | 13462 | 135 |
2474975 | 2474975 | 2022-05-05 | Marion | Mississippi | 28091 | 6965 | 135 |
2475352 | 2475352 | 2022-05-05 | Rio Arriba | New Mexico | 35039 | 9912 | 135 |
2475736 | 2475736 | 2022-05-05 | Seminole | Oklahoma | 40133 | 6136 | 135 |
2476260 | 2476260 | 2022-05-05 | Hutchinson | Texas | 48233 | 6755 | 135 |
2470395 | 2470395 | 2022-05-04 | Hot Spring | Arkansas | 5059 | 11212 | 135 |
2470885 | 2470885 | 2022-05-04 | Fulton | Illinois | 17057 | 10165 | 135 |
2471327 | 2471327 | 2022-05-04 | Lincoln | Kentucky | 21137 | 6474 | 135 |
2471394 | 2471394 | 2022-05-04 | De Soto | Louisiana | 22031 | 7344 | 135 |
2471718 | 2471718 | 2022-05-04 | Marion | Mississippi | 28091 | 6965 | 135 |
2472419 | 2472419 | 2022-05-04 | Bryan | Oklahoma | 40013 | 13584 | 135 |
2472479 | 2472479 | 2022-05-04 | Seminole | Oklahoma | 40133 | 6132 | 135 |
2467139 | 2467139 | 2022-05-03 | Hot Spring | Arkansas | 5059 | 11196 | 135 |
2467629 | 2467629 | 2022-05-03 | Fulton | Illinois | 17057 | 10160 | 135 |
2468071 | 2468071 | 2022-05-03 | Lincoln | Kentucky | 21137 | 6474 | 135 |
2468138 | 2468138 | 2022-05-03 | De Soto | Louisiana | 22031 | 7343 | 135 |
2468462 | 2468462 | 2022-05-03 | Marion | Mississippi | 28091 | 6965 | 135 |
2469163 | 2469163 | 2022-05-03 | Bryan | Oklahoma | 40013 | 13584 | 135 |
2469223 | 2469223 | 2022-05-03 | Seminole | Oklahoma | 40133 | 6132 | 135 |
2463884 | 2463884 | 2022-05-02 | Hot Spring | Arkansas | 5059 | 11194 | 135 |
2464374 | 2464374 | 2022-05-02 | Fulton | Illinois | 17057 | 10154 | 135 |
2464816 | 2464816 | 2022-05-02 | Lincoln | Kentucky | 21137 | 6474 | 135 |
2464883 | 2464883 | 2022-05-02 | De Soto | Louisiana | 22031 | 7343 | 135 |
2465207 | 2465207 | 2022-05-02 | Marion | Mississippi | 28091 | 6965 | 135 |
2465907 | 2465907 | 2022-05-02 | Bryan | Oklahoma | 40013 | 13584 | 135 |
2465967 | 2465967 | 2022-05-02 | Seminole | Oklahoma | 40133 | 6132 | 135 |
2460628 | 2460628 | 2022-05-01 | Hot Spring | Arkansas | 5059 | 11194 | 135 |
2461118 | 2461118 | 2022-05-01 | Fulton | Illinois | 17057 | 10139 | 135 |
2461627 | 2461627 | 2022-05-01 | De Soto | Louisiana | 22031 | 7341 | 135 |
2461951 | 2461951 | 2022-05-01 | Marion | Mississippi | 28091 | 6962 | 135 |
2462652 | 2462652 | 2022-05-01 | Bryan | Oklahoma | 40013 | 13584 | 135 |
2462712 | 2462712 | 2022-05-01 | Seminole | Oklahoma | 40133 | 6132 | 135 |
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);