ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where deaths = 280 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 90
- Virginia 50
- North Carolina 47
- Alabama 45
- Ohio 45
- Florida 42
- Indiana 42
- Kentucky 34
- Wisconsin 29
- Georgia 28
- Pennsylvania 24
- Louisiana 22
- Illinois 21
- New Mexico 20
- South Carolina 19
- Michigan 17
- Mississippi 16
- Tennessee 15
- Oklahoma 14
- Arizona 13
- Minnesota 13
- Maryland 12
- Missouri 12
- New York 12
- Washington 12
- Colorado 10
- Iowa 10
- Montana 9
- Oregon 9
- Nebraska 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499928 | 2499928 | 2022-05-13 | Jackson | Florida | 12063 | 14854 | 280 |
2500114 | 2500114 | 2022-05-13 | Ware | Georgia | 13299 | 10121 | 280 |
2500651 | 2500651 | 2022-05-13 | Madison | Kentucky | 21151 | 27833 | 280 |
2502441 | 2502441 | 2022-05-13 | Van Zandt | Texas | 48467 | 10399 | 280 |
2496670 | 2496670 | 2022-05-12 | Jackson | Florida | 12063 | 14854 | 280 |
2496856 | 2496856 | 2022-05-12 | Ware | Georgia | 13299 | 10121 | 280 |
2497074 | 2497074 | 2022-05-12 | Monroe | Indiana | 18105 | 28724 | 280 |
2497393 | 2497393 | 2022-05-12 | Madison | Kentucky | 21151 | 27833 | 280 |
2499183 | 2499183 | 2022-05-12 | Van Zandt | Texas | 48467 | 10395 | 280 |
2493412 | 2493412 | 2022-05-11 | Jackson | Florida | 12063 | 14854 | 280 |
2493598 | 2493598 | 2022-05-11 | Ware | Georgia | 13299 | 10121 | 280 |
2493816 | 2493816 | 2022-05-11 | Monroe | Indiana | 18105 | 28724 | 280 |
2494135 | 2494135 | 2022-05-11 | Madison | Kentucky | 21151 | 27833 | 280 |
2495925 | 2495925 | 2022-05-11 | Van Zandt | Texas | 48467 | 10395 | 280 |
2496286 | 2496286 | 2022-05-11 | Walworth | Wisconsin | 55127 | 27254 | 280 |
2490154 | 2490154 | 2022-05-10 | Jackson | Florida | 12063 | 14854 | 280 |
2490558 | 2490558 | 2022-05-10 | Monroe | Indiana | 18105 | 28636 | 280 |
2490877 | 2490877 | 2022-05-10 | Madison | Kentucky | 21151 | 27833 | 280 |
2491209 | 2491209 | 2022-05-10 | Unknown | Minnesota | 1187 | 280 | |
2492667 | 2492667 | 2022-05-10 | Van Zandt | Texas | 48467 | 10394 | 280 |
2493028 | 2493028 | 2022-05-10 | Walworth | Wisconsin | 55127 | 27224 | 280 |
2486897 | 2486897 | 2022-05-09 | Jackson | Florida | 12063 | 14854 | 280 |
2487301 | 2487301 | 2022-05-09 | Monroe | Indiana | 18105 | 28636 | 280 |
2487620 | 2487620 | 2022-05-09 | Madison | Kentucky | 21151 | 27833 | 280 |
2487952 | 2487952 | 2022-05-09 | Unknown | Minnesota | 1098 | 280 | |
2488370 | 2488370 | 2022-05-09 | Eddy | New Mexico | 35015 | 17051 | 280 |
2488388 | 2488388 | 2022-05-09 | Santa Fe | New Mexico | 35049 | 29314 | 280 |
2489409 | 2489409 | 2022-05-09 | Van Zandt | Texas | 48467 | 10391 | 280 |
2489770 | 2489770 | 2022-05-09 | Walworth | Wisconsin | 55127 | 27186 | 280 |
2483639 | 2483639 | 2022-05-08 | Jackson | Florida | 12063 | 14854 | 280 |
2484043 | 2484043 | 2022-05-08 | Monroe | Indiana | 18105 | 28457 | 280 |
2484362 | 2484362 | 2022-05-08 | Madison | Kentucky | 21151 | 27759 | 280 |
2484694 | 2484694 | 2022-05-08 | Unknown | Minnesota | 1092 | 280 | |
2485113 | 2485113 | 2022-05-08 | Eddy | New Mexico | 35015 | 17050 | 280 |
2486151 | 2486151 | 2022-05-08 | Van Zandt | Texas | 48467 | 10390 | 280 |
2486513 | 2486513 | 2022-05-08 | Walworth | Wisconsin | 55127 | 27126 | 280 |
2480381 | 2480381 | 2022-05-07 | Jackson | Florida | 12063 | 14854 | 280 |
2480785 | 2480785 | 2022-05-07 | Monroe | Indiana | 18105 | 28457 | 280 |
2481104 | 2481104 | 2022-05-07 | Madison | Kentucky | 21151 | 27759 | 280 |
2481436 | 2481436 | 2022-05-07 | Unknown | Minnesota | 1092 | 280 | |
2481855 | 2481855 | 2022-05-07 | Eddy | New Mexico | 35015 | 17050 | 280 |
2482893 | 2482893 | 2022-05-07 | Van Zandt | Texas | 48467 | 10387 | 280 |
2483255 | 2483255 | 2022-05-07 | Walworth | Wisconsin | 55127 | 27126 | 280 |
2477123 | 2477123 | 2022-05-06 | Jackson | Florida | 12063 | 14854 | 280 |
2477527 | 2477527 | 2022-05-06 | Monroe | Indiana | 18105 | 28457 | 280 |
2477846 | 2477846 | 2022-05-06 | Madison | Kentucky | 21151 | 27759 | 280 |
2478178 | 2478178 | 2022-05-06 | Unknown | Minnesota | 1092 | 280 | |
2478597 | 2478597 | 2022-05-06 | Eddy | New Mexico | 35015 | 17050 | 280 |
2479635 | 2479635 | 2022-05-06 | Van Zandt | Texas | 48467 | 10385 | 280 |
2479997 | 2479997 | 2022-05-06 | Walworth | Wisconsin | 55127 | 27126 | 280 |
2473865 | 2473865 | 2022-05-05 | Jackson | Florida | 12063 | 14805 | 280 |
2474269 | 2474269 | 2022-05-05 | Monroe | Indiana | 18105 | 28457 | 280 |
2474588 | 2474588 | 2022-05-05 | Madison | Kentucky | 21151 | 27759 | 280 |
2474920 | 2474920 | 2022-05-05 | Unknown | Minnesota | 1089 | 280 | |
2476377 | 2476377 | 2022-05-05 | Van Zandt | Texas | 48467 | 10385 | 280 |
2476739 | 2476739 | 2022-05-05 | Walworth | Wisconsin | 55127 | 27087 | 280 |
2470608 | 2470608 | 2022-05-04 | Jackson | Florida | 12063 | 14805 | 280 |
2471012 | 2471012 | 2022-05-04 | Monroe | Indiana | 18105 | 28457 | 280 |
2471331 | 2471331 | 2022-05-04 | Madison | Kentucky | 21151 | 27759 | 280 |
2471663 | 2471663 | 2022-05-04 | Unknown | Minnesota | 1083 | 280 | |
2473120 | 2473120 | 2022-05-04 | Van Zandt | Texas | 48467 | 10383 | 280 |
2473481 | 2473481 | 2022-05-04 | Walworth | Wisconsin | 55127 | 27058 | 280 |
2467352 | 2467352 | 2022-05-03 | Jackson | Florida | 12063 | 14805 | 280 |
2467756 | 2467756 | 2022-05-03 | Monroe | Indiana | 18105 | 28373 | 280 |
2468075 | 2468075 | 2022-05-03 | Madison | Kentucky | 21151 | 27759 | 280 |
2469864 | 2469864 | 2022-05-03 | Van Zandt | Texas | 48467 | 10382 | 280 |
2470224 | 2470224 | 2022-05-03 | Walworth | Wisconsin | 55127 | 27045 | 280 |
2464097 | 2464097 | 2022-05-02 | Jackson | Florida | 12063 | 14805 | 280 |
2464501 | 2464501 | 2022-05-02 | Monroe | Indiana | 18105 | 28373 | 280 |
2464820 | 2464820 | 2022-05-02 | Madison | Kentucky | 21151 | 27759 | 280 |
2466608 | 2466608 | 2022-05-02 | Van Zandt | Texas | 48467 | 10382 | 280 |
2466968 | 2466968 | 2022-05-02 | Walworth | Wisconsin | 55127 | 27045 | 280 |
2460841 | 2460841 | 2022-05-01 | Jackson | Florida | 12063 | 14805 | 280 |
2461245 | 2461245 | 2022-05-01 | Monroe | Indiana | 18105 | 28305 | 280 |
2463353 | 2463353 | 2022-05-01 | Van Zandt | Texas | 48467 | 10379 | 280 |
2463713 | 2463713 | 2022-05-01 | Walworth | Wisconsin | 55127 | 27045 | 280 |
2457585 | 2457585 | 2022-04-30 | Jackson | Florida | 12063 | 14805 | 280 |
2457989 | 2457989 | 2022-04-30 | Monroe | Indiana | 18105 | 28305 | 280 |
2460097 | 2460097 | 2022-04-30 | Van Zandt | Texas | 48467 | 10378 | 280 |
2460457 | 2460457 | 2022-04-30 | Walworth | Wisconsin | 55127 | 27045 | 280 |
2454329 | 2454329 | 2022-04-29 | Jackson | Florida | 12063 | 14805 | 280 |
2454733 | 2454733 | 2022-04-29 | Monroe | Indiana | 18105 | 28305 | 280 |
2456841 | 2456841 | 2022-04-29 | Van Zandt | Texas | 48467 | 10378 | 280 |
2457201 | 2457201 | 2022-04-29 | Walworth | Wisconsin | 55127 | 27045 | 280 |
2451073 | 2451073 | 2022-04-28 | Jackson | Florida | 12063 | 14805 | 280 |
2451477 | 2451477 | 2022-04-28 | Monroe | Indiana | 18105 | 28217 | 280 |
2453585 | 2453585 | 2022-04-28 | Van Zandt | Texas | 48467 | 10377 | 280 |
2453945 | 2453945 | 2022-04-28 | Walworth | Wisconsin | 55127 | 27045 | 280 |
2447817 | 2447817 | 2022-04-27 | Jackson | Florida | 12063 | 14805 | 280 |
2448221 | 2448221 | 2022-04-27 | Monroe | Indiana | 18105 | 28217 | 280 |
2450329 | 2450329 | 2022-04-27 | Van Zandt | Texas | 48467 | 10374 | 280 |
2450689 | 2450689 | 2022-04-27 | Walworth | Wisconsin | 55127 | 27045 | 280 |
2444561 | 2444561 | 2022-04-26 | Jackson | Florida | 12063 | 14805 | 280 |
2444965 | 2444965 | 2022-04-26 | Monroe | Indiana | 18105 | 28133 | 280 |
2447072 | 2447072 | 2022-04-26 | Van Zandt | Texas | 48467 | 10373 | 280 |
2447433 | 2447433 | 2022-04-26 | Walworth | Wisconsin | 55127 | 27045 | 280 |
2441305 | 2441305 | 2022-04-25 | Jackson | Florida | 12063 | 14805 | 280 |
2441709 | 2441709 | 2022-04-25 | Monroe | Indiana | 18105 | 28133 | 280 |
2443817 | 2443817 | 2022-04-25 | Van Zandt | Texas | 48467 | 10373 | 280 |
2444177 | 2444177 | 2022-04-25 | Walworth | Wisconsin | 55127 | 27045 | 280 |
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);