ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,953 rows where deaths = 170 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 142
- Texas 142
- Georgia 133
- Louisiana 116
- North Carolina 114
- Tennessee 104
- Illinois 97
- Alabama 93
- Arkansas 73
- New York 65
- Pennsylvania 57
- South Carolina 57
- Ohio 56
- Virginia 55
- Missouri 52
- Oklahoma 51
- Kentucky 46
- Michigan 45
- Indiana 39
- Mississippi 37
- California 34
- Minnesota 34
- West Virginia 33
- New Jersey 28
- New Mexico 28
- Nevada 21
- Wisconsin 20
- Idaho 18
- Utah 17
- Maryland 15
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500094 | 2500094 | 2022-05-13 | Sumter | Georgia | 13261 | 6845 | 170 |
2500389 | 2500389 | 2022-05-13 | Cerro Gordo | Iowa | 19033 | 11156 | 170 |
2500717 | 2500717 | 2022-05-13 | East Feliciana | Louisiana | 22037 | 7324 | 170 |
2500922 | 2500922 | 2022-05-13 | Crow Wing | Minnesota | 27035 | 16266 | 170 |
2502162 | 2502162 | 2022-05-13 | Lincoln | Tennessee | 47103 | 10003 | 170 |
2496836 | 2496836 | 2022-05-12 | Sumter | Georgia | 13261 | 6845 | 170 |
2497131 | 2497131 | 2022-05-12 | Cerro Gordo | Iowa | 19033 | 11156 | 170 |
2497459 | 2497459 | 2022-05-12 | East Feliciana | Louisiana | 22037 | 7324 | 170 |
2497664 | 2497664 | 2022-05-12 | Crow Wing | Minnesota | 27035 | 16238 | 170 |
2498904 | 2498904 | 2022-05-12 | Lincoln | Tennessee | 47103 | 10003 | 170 |
2498975 | 2498975 | 2022-05-12 | Burnet | Texas | 48053 | 11091 | 170 |
2493085 | 2493085 | 2022-05-11 | Escambia | Alabama | 1053 | 10072 | 170 |
2493578 | 2493578 | 2022-05-11 | Sumter | Georgia | 13261 | 6845 | 170 |
2493873 | 2493873 | 2022-05-11 | Cerro Gordo | Iowa | 19033 | 11156 | 170 |
2494201 | 2494201 | 2022-05-11 | East Feliciana | Louisiana | 22037 | 7324 | 170 |
2494406 | 2494406 | 2022-05-11 | Crow Wing | Minnesota | 27035 | 16202 | 170 |
2495646 | 2495646 | 2022-05-11 | Lincoln | Tennessee | 47103 | 10003 | 170 |
2495717 | 2495717 | 2022-05-11 | Burnet | Texas | 48053 | 11086 | 170 |
2489827 | 2489827 | 2022-05-10 | Escambia | Alabama | 1053 | 10069 | 170 |
2490449 | 2490449 | 2022-05-10 | Kendall | Illinois | 17093 | 32269 | 170 |
2490943 | 2490943 | 2022-05-10 | East Feliciana | Louisiana | 22037 | 7322 | 170 |
2491148 | 2491148 | 2022-05-10 | Crow Wing | Minnesota | 27035 | 16187 | 170 |
2492388 | 2492388 | 2022-05-10 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2492459 | 2492459 | 2022-05-10 | Burnet | Texas | 48053 | 11085 | 170 |
2486570 | 2486570 | 2022-05-09 | Escambia | Alabama | 1053 | 10065 | 170 |
2487192 | 2487192 | 2022-05-09 | Kendall | Illinois | 17093 | 32197 | 170 |
2487686 | 2487686 | 2022-05-09 | East Feliciana | Louisiana | 22037 | 7321 | 170 |
2487891 | 2487891 | 2022-05-09 | Crow Wing | Minnesota | 27035 | 16155 | 170 |
2489130 | 2489130 | 2022-05-09 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2489201 | 2489201 | 2022-05-09 | Burnet | Texas | 48053 | 11084 | 170 |
2483312 | 2483312 | 2022-05-08 | Escambia | Alabama | 1053 | 10060 | 170 |
2483934 | 2483934 | 2022-05-08 | Kendall | Illinois | 17093 | 31968 | 170 |
2484428 | 2484428 | 2022-05-08 | East Feliciana | Louisiana | 22037 | 7320 | 170 |
2484633 | 2484633 | 2022-05-08 | Crow Wing | Minnesota | 27035 | 16132 | 170 |
2485873 | 2485873 | 2022-05-08 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2485944 | 2485944 | 2022-05-08 | Burnet | Texas | 48053 | 11075 | 170 |
2480054 | 2480054 | 2022-05-07 | Escambia | Alabama | 1053 | 10060 | 170 |
2480676 | 2480676 | 2022-05-07 | Kendall | Illinois | 17093 | 31968 | 170 |
2481170 | 2481170 | 2022-05-07 | East Feliciana | Louisiana | 22037 | 7320 | 170 |
2481375 | 2481375 | 2022-05-07 | Crow Wing | Minnesota | 27035 | 16132 | 170 |
2482615 | 2482615 | 2022-05-07 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2482686 | 2482686 | 2022-05-07 | Burnet | Texas | 48053 | 11073 | 170 |
2476796 | 2476796 | 2022-05-06 | Escambia | Alabama | 1053 | 10060 | 170 |
2477418 | 2477418 | 2022-05-06 | Kendall | Illinois | 17093 | 31968 | 170 |
2477912 | 2477912 | 2022-05-06 | East Feliciana | Louisiana | 22037 | 7320 | 170 |
2478117 | 2478117 | 2022-05-06 | Crow Wing | Minnesota | 27035 | 16132 | 170 |
2479357 | 2479357 | 2022-05-06 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2479428 | 2479428 | 2022-05-06 | Burnet | Texas | 48053 | 11070 | 170 |
2473538 | 2473538 | 2022-05-05 | Escambia | Alabama | 1053 | 10060 | 170 |
2474160 | 2474160 | 2022-05-05 | Kendall | Illinois | 17093 | 31874 | 170 |
2474654 | 2474654 | 2022-05-05 | East Feliciana | Louisiana | 22037 | 7319 | 170 |
2474859 | 2474859 | 2022-05-05 | Crow Wing | Minnesota | 27035 | 16115 | 170 |
2476099 | 2476099 | 2022-05-05 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2476170 | 2476170 | 2022-05-05 | Burnet | Texas | 48053 | 11068 | 170 |
2470281 | 2470281 | 2022-05-04 | Escambia | Alabama | 1053 | 10059 | 170 |
2470903 | 2470903 | 2022-05-04 | Kendall | Illinois | 17093 | 31827 | 170 |
2471397 | 2471397 | 2022-05-04 | East Feliciana | Louisiana | 22037 | 7318 | 170 |
2471602 | 2471602 | 2022-05-04 | Crow Wing | Minnesota | 27035 | 16099 | 170 |
2472842 | 2472842 | 2022-05-04 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2467025 | 2467025 | 2022-05-03 | Escambia | Alabama | 1053 | 10022 | 170 |
2467647 | 2467647 | 2022-05-03 | Kendall | Illinois | 17093 | 31774 | 170 |
2468141 | 2468141 | 2022-05-03 | East Feliciana | Louisiana | 22037 | 7318 | 170 |
2468346 | 2468346 | 2022-05-03 | Crow Wing | Minnesota | 27035 | 16085 | 170 |
2468968 | 2468968 | 2022-05-03 | McDowell | North Carolina | 37111 | 13778 | 170 |
2469586 | 2469586 | 2022-05-03 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2463770 | 2463770 | 2022-05-02 | Escambia | Alabama | 1053 | 10023 | 170 |
2464392 | 2464392 | 2022-05-02 | Kendall | Illinois | 17093 | 31719 | 170 |
2464886 | 2464886 | 2022-05-02 | East Feliciana | Louisiana | 22037 | 7315 | 170 |
2465712 | 2465712 | 2022-05-02 | McDowell | North Carolina | 37111 | 13778 | 170 |
2466330 | 2466330 | 2022-05-02 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2460514 | 2460514 | 2022-05-01 | Escambia | Alabama | 1053 | 10019 | 170 |
2461136 | 2461136 | 2022-05-01 | Kendall | Illinois | 17093 | 31600 | 170 |
2461630 | 2461630 | 2022-05-01 | East Feliciana | Louisiana | 22037 | 7314 | 170 |
2462457 | 2462457 | 2022-05-01 | McDowell | North Carolina | 37111 | 13778 | 170 |
2463075 | 2463075 | 2022-05-01 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2457258 | 2457258 | 2022-04-30 | Escambia | Alabama | 1053 | 10019 | 170 |
2457880 | 2457880 | 2022-04-30 | Kendall | Illinois | 17093 | 31600 | 170 |
2458374 | 2458374 | 2022-04-30 | East Feliciana | Louisiana | 22037 | 7314 | 170 |
2459201 | 2459201 | 2022-04-30 | McDowell | North Carolina | 37111 | 13778 | 170 |
2459819 | 2459819 | 2022-04-30 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2454002 | 2454002 | 2022-04-29 | Escambia | Alabama | 1053 | 10019 | 170 |
2454624 | 2454624 | 2022-04-29 | Kendall | Illinois | 17093 | 31600 | 170 |
2455118 | 2455118 | 2022-04-29 | East Feliciana | Louisiana | 22037 | 7314 | 170 |
2455945 | 2455945 | 2022-04-29 | McDowell | North Carolina | 37111 | 13778 | 170 |
2456563 | 2456563 | 2022-04-29 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2450746 | 2450746 | 2022-04-28 | Escambia | Alabama | 1053 | 10019 | 170 |
2451368 | 2451368 | 2022-04-28 | Kendall | Illinois | 17093 | 31560 | 170 |
2451862 | 2451862 | 2022-04-28 | East Feliciana | Louisiana | 22037 | 7312 | 170 |
2452689 | 2452689 | 2022-04-28 | McDowell | North Carolina | 37111 | 13778 | 170 |
2453055 | 2453055 | 2022-04-28 | Wayne | Pennsylvania | 42127 | 10287 | 170 |
2453307 | 2453307 | 2022-04-28 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2447490 | 2447490 | 2022-04-27 | Escambia | Alabama | 1053 | 10018 | 170 |
2448112 | 2448112 | 2022-04-27 | Kendall | Illinois | 17093 | 31502 | 170 |
2448606 | 2448606 | 2022-04-27 | East Feliciana | Louisiana | 22037 | 7309 | 170 |
2449433 | 2449433 | 2022-04-27 | McDowell | North Carolina | 37111 | 13778 | 170 |
2449799 | 2449799 | 2022-04-27 | Wayne | Pennsylvania | 42127 | 10276 | 170 |
2450051 | 2450051 | 2022-04-27 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2444234 | 2444234 | 2022-04-26 | Escambia | Alabama | 1053 | 10018 | 170 |
2444856 | 2444856 | 2022-04-26 | Kendall | Illinois | 17093 | 31468 | 170 |
2445350 | 2445350 | 2022-04-26 | East Feliciana | Louisiana | 22037 | 7308 | 170 |
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);