ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,007 rows where deaths = 169 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 179
- Texas 145
- Georgia 134
- Pennsylvania 97
- North Carolina 81
- Florida 77
- Tennessee 77
- Wisconsin 77
- Missouri 68
- New York 67
- Rhode Island 65
- Virginia 60
- New Mexico 57
- Ohio 56
- Illinois 55
- Michigan 53
- Alabama 47
- Arkansas 41
- Louisiana 38
- Oklahoma 38
- Indiana 36
- Minnesota 35
- South Carolina 35
- Iowa 33
- Montana 32
- Oregon 29
- California 28
- Idaho 27
- New Jersey 23
- Nevada 22
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499934 | 2499934 | 2022-05-13 | Levy | Florida | 12075 | 10284 | 169 |
2500828 | 2500828 | 2022-05-13 | Barry | Michigan | 26015 | 14514 | 169 |
2501034 | 2501034 | 2022-05-13 | Leflore | Mississippi | 28083 | 7326 | 169 |
2501046 | 2501046 | 2022-05-13 | Panola | Mississippi | 28107 | 10566 | 169 |
2501087 | 2501087 | 2022-05-13 | Butler | Missouri | 29023 | 10206 | 169 |
2501444 | 2501444 | 2022-05-13 | Fulton | New York | 36035 | 13428 | 169 |
2501752 | 2501752 | 2022-05-13 | Custer | Oklahoma | 40039 | 7935 | 169 |
2501993 | 2501993 | 2022-05-13 | Bristol | Rhode Island | 44001 | 14360 | 169 |
2502117 | 2502117 | 2022-05-13 | Campbell | Tennessee | 47013 | 12310 | 169 |
2496676 | 2496676 | 2022-05-12 | Levy | Florida | 12075 | 10284 | 169 |
2497570 | 2497570 | 2022-05-12 | Barry | Michigan | 26015 | 14514 | 169 |
2497776 | 2497776 | 2022-05-12 | Leflore | Mississippi | 28083 | 7326 | 169 |
2497788 | 2497788 | 2022-05-12 | Panola | Mississippi | 28107 | 10566 | 169 |
2497829 | 2497829 | 2022-05-12 | Butler | Missouri | 29023 | 10177 | 169 |
2498186 | 2498186 | 2022-05-12 | Fulton | New York | 36035 | 13428 | 169 |
2498494 | 2498494 | 2022-05-12 | Custer | Oklahoma | 40039 | 7935 | 169 |
2498735 | 2498735 | 2022-05-12 | Bristol | Rhode Island | 44001 | 14360 | 169 |
2498859 | 2498859 | 2022-05-12 | Campbell | Tennessee | 47013 | 12310 | 169 |
2493418 | 2493418 | 2022-05-11 | Levy | Florida | 12075 | 10284 | 169 |
2494312 | 2494312 | 2022-05-11 | Barry | Michigan | 26015 | 14514 | 169 |
2494518 | 2494518 | 2022-05-11 | Leflore | Mississippi | 28083 | 7326 | 169 |
2494530 | 2494530 | 2022-05-11 | Panola | Mississippi | 28107 | 10566 | 169 |
2494571 | 2494571 | 2022-05-11 | Butler | Missouri | 29023 | 10177 | 169 |
2494928 | 2494928 | 2022-05-11 | Fulton | New York | 36035 | 13402 | 169 |
2495236 | 2495236 | 2022-05-11 | Custer | Oklahoma | 40039 | 7920 | 169 |
2495477 | 2495477 | 2022-05-11 | Bristol | Rhode Island | 44001 | 14360 | 169 |
2495601 | 2495601 | 2022-05-11 | Campbell | Tennessee | 47013 | 12310 | 169 |
2490160 | 2490160 | 2022-05-10 | Levy | Florida | 12075 | 10284 | 169 |
2490320 | 2490320 | 2022-05-10 | Sumter | Georgia | 13261 | 6845 | 169 |
2490615 | 2490615 | 2022-05-10 | Cerro Gordo | Iowa | 19033 | 11140 | 169 |
2491054 | 2491054 | 2022-05-10 | Barry | Michigan | 26015 | 14443 | 169 |
2491260 | 2491260 | 2022-05-10 | Leflore | Mississippi | 28083 | 7326 | 169 |
2491272 | 2491272 | 2022-05-10 | Panola | Mississippi | 28107 | 10566 | 169 |
2491313 | 2491313 | 2022-05-10 | Butler | Missouri | 29023 | 10177 | 169 |
2491670 | 2491670 | 2022-05-10 | Fulton | New York | 36035 | 13385 | 169 |
2491978 | 2491978 | 2022-05-10 | Custer | Oklahoma | 40039 | 7920 | 169 |
2492219 | 2492219 | 2022-05-10 | Bristol | Rhode Island | 44001 | 14076 | 169 |
2492343 | 2492343 | 2022-05-10 | Campbell | Tennessee | 47013 | 12293 | 169 |
2486903 | 2486903 | 2022-05-09 | Levy | Florida | 12075 | 10284 | 169 |
2487063 | 2487063 | 2022-05-09 | Sumter | Georgia | 13261 | 6845 | 169 |
2487358 | 2487358 | 2022-05-09 | Cerro Gordo | Iowa | 19033 | 11140 | 169 |
2487797 | 2487797 | 2022-05-09 | Barry | Michigan | 26015 | 14443 | 169 |
2488003 | 2488003 | 2022-05-09 | Leflore | Mississippi | 28083 | 7326 | 169 |
2488015 | 2488015 | 2022-05-09 | Panola | Mississippi | 28107 | 10566 | 169 |
2488055 | 2488055 | 2022-05-09 | Butler | Missouri | 29023 | 10177 | 169 |
2488412 | 2488412 | 2022-05-09 | Fulton | New York | 36035 | 13362 | 169 |
2488720 | 2488720 | 2022-05-09 | Custer | Oklahoma | 40039 | 7920 | 169 |
2488961 | 2488961 | 2022-05-09 | Bristol | Rhode Island | 44001 | 14076 | 169 |
2489085 | 2489085 | 2022-05-09 | Campbell | Tennessee | 47013 | 12293 | 169 |
2483645 | 2483645 | 2022-05-08 | Levy | Florida | 12075 | 10284 | 169 |
2483805 | 2483805 | 2022-05-08 | Sumter | Georgia | 13261 | 6844 | 169 |
2484100 | 2484100 | 2022-05-08 | Cerro Gordo | Iowa | 19033 | 11140 | 169 |
2484539 | 2484539 | 2022-05-08 | Barry | Michigan | 26015 | 14443 | 169 |
2484745 | 2484745 | 2022-05-08 | Leflore | Mississippi | 28083 | 7312 | 169 |
2484757 | 2484757 | 2022-05-08 | Panola | Mississippi | 28107 | 10539 | 169 |
2484798 | 2484798 | 2022-05-08 | Butler | Missouri | 29023 | 10177 | 169 |
2485155 | 2485155 | 2022-05-08 | Fulton | New York | 36035 | 13344 | 169 |
2485463 | 2485463 | 2022-05-08 | Custer | Oklahoma | 40039 | 7920 | 169 |
2485704 | 2485704 | 2022-05-08 | Bristol | Rhode Island | 44001 | 14076 | 169 |
2485828 | 2485828 | 2022-05-08 | Campbell | Tennessee | 47013 | 12293 | 169 |
2480387 | 2480387 | 2022-05-07 | Levy | Florida | 12075 | 10284 | 169 |
2480547 | 2480547 | 2022-05-07 | Sumter | Georgia | 13261 | 6844 | 169 |
2480842 | 2480842 | 2022-05-07 | Cerro Gordo | Iowa | 19033 | 11140 | 169 |
2481281 | 2481281 | 2022-05-07 | Barry | Michigan | 26015 | 14443 | 169 |
2481487 | 2481487 | 2022-05-07 | Leflore | Mississippi | 28083 | 7312 | 169 |
2481499 | 2481499 | 2022-05-07 | Panola | Mississippi | 28107 | 10539 | 169 |
2481540 | 2481540 | 2022-05-07 | Butler | Missouri | 29023 | 10177 | 169 |
2481897 | 2481897 | 2022-05-07 | Fulton | New York | 36035 | 13311 | 169 |
2482205 | 2482205 | 2022-05-07 | Custer | Oklahoma | 40039 | 7920 | 169 |
2482446 | 2482446 | 2022-05-07 | Bristol | Rhode Island | 44001 | 14076 | 169 |
2482570 | 2482570 | 2022-05-07 | Campbell | Tennessee | 47013 | 12293 | 169 |
2477129 | 2477129 | 2022-05-06 | Levy | Florida | 12075 | 10284 | 169 |
2477289 | 2477289 | 2022-05-06 | Sumter | Georgia | 13261 | 6844 | 169 |
2477584 | 2477584 | 2022-05-06 | Cerro Gordo | Iowa | 19033 | 11140 | 169 |
2478023 | 2478023 | 2022-05-06 | Barry | Michigan | 26015 | 14443 | 169 |
2478229 | 2478229 | 2022-05-06 | Leflore | Mississippi | 28083 | 7312 | 169 |
2478241 | 2478241 | 2022-05-06 | Panola | Mississippi | 28107 | 10539 | 169 |
2478282 | 2478282 | 2022-05-06 | Butler | Missouri | 29023 | 10177 | 169 |
2478639 | 2478639 | 2022-05-06 | Fulton | New York | 36035 | 13288 | 169 |
2478947 | 2478947 | 2022-05-06 | Custer | Oklahoma | 40039 | 7920 | 169 |
2479188 | 2479188 | 2022-05-06 | Bristol | Rhode Island | 44001 | 14076 | 169 |
2479312 | 2479312 | 2022-05-06 | Campbell | Tennessee | 47013 | 12293 | 169 |
2473871 | 2473871 | 2022-05-05 | Levy | Florida | 12075 | 10260 | 169 |
2474031 | 2474031 | 2022-05-05 | Sumter | Georgia | 13261 | 6844 | 169 |
2474326 | 2474326 | 2022-05-05 | Cerro Gordo | Iowa | 19033 | 11140 | 169 |
2474765 | 2474765 | 2022-05-05 | Barry | Michigan | 26015 | 14443 | 169 |
2474971 | 2474971 | 2022-05-05 | Leflore | Mississippi | 28083 | 7312 | 169 |
2474983 | 2474983 | 2022-05-05 | Panola | Mississippi | 28107 | 10539 | 169 |
2475024 | 2475024 | 2022-05-05 | Butler | Missouri | 29023 | 10153 | 169 |
2475381 | 2475381 | 2022-05-05 | Fulton | New York | 36035 | 13261 | 169 |
2475689 | 2475689 | 2022-05-05 | Custer | Oklahoma | 40039 | 7920 | 169 |
2475930 | 2475930 | 2022-05-05 | Bristol | Rhode Island | 44001 | 14076 | 169 |
2476054 | 2476054 | 2022-05-05 | Campbell | Tennessee | 47013 | 12293 | 169 |
2470614 | 2470614 | 2022-05-04 | Levy | Florida | 12075 | 10260 | 169 |
2470774 | 2470774 | 2022-05-04 | Sumter | Georgia | 13261 | 6844 | 169 |
2471069 | 2471069 | 2022-05-04 | Cerro Gordo | Iowa | 19033 | 11140 | 169 |
2471508 | 2471508 | 2022-05-04 | Barry | Michigan | 26015 | 14443 | 169 |
2471714 | 2471714 | 2022-05-04 | Leflore | Mississippi | 28083 | 7312 | 169 |
2471726 | 2471726 | 2022-05-04 | Panola | Mississippi | 28107 | 10539 | 169 |
2472124 | 2472124 | 2022-05-04 | Fulton | New York | 36035 | 13234 | 169 |
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);