ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,863 rows where deaths = 117 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 249
- Texas 242
- Missouri 227
- Georgia 223
- Illinois 212
- Tennessee 180
- Louisiana 160
- Mississippi 159
- Alabama 145
- Minnesota 138
- Ohio 134
- Virginia 125
- California 122
- Wisconsin 120
- Kentucky 113
- Indiana 112
- Oklahoma 97
- Kansas 96
- New York 90
- Florida 88
- Iowa 79
- Michigan 79
- Pennsylvania 78
- West Virginia 77
- Washington 66
- Maryland 61
- Arkansas 51
- South Carolina 49
- New Mexico 32
- Wyoming 28
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500066 | 2500066 | 2022-05-13 | Mitchell | Georgia | 13205 | 5255 | 117 |
2500914 | 2500914 | 2022-05-13 | Carver | Minnesota | 27019 | 27480 | 117 |
2500925 | 2500925 | 2022-05-13 | Douglas | Minnesota | 27041 | 11106 | 117 |
2500934 | 2500934 | 2022-05-13 | Isanti | Minnesota | 27059 | 10263 | 117 |
2501110 | 2501110 | 2022-05-13 | Dunklin | Missouri | 29069 | 7824 | 117 |
2501462 | 2501462 | 2022-05-13 | Orleans | New York | 36073 | 9116 | 117 |
2502186 | 2502186 | 2022-05-13 | Scott | Tennessee | 47151 | 9097 | 117 |
2496808 | 2496808 | 2022-05-12 | Mitchell | Georgia | 13205 | 5255 | 117 |
2497656 | 2497656 | 2022-05-12 | Carver | Minnesota | 27019 | 27427 | 117 |
2497676 | 2497676 | 2022-05-12 | Isanti | Minnesota | 27059 | 10246 | 117 |
2497852 | 2497852 | 2022-05-12 | Dunklin | Missouri | 29069 | 7763 | 117 |
2498928 | 2498928 | 2022-05-12 | Scott | Tennessee | 47151 | 9097 | 117 |
2493550 | 2493550 | 2022-05-11 | Mitchell | Georgia | 13205 | 5255 | 117 |
2494398 | 2494398 | 2022-05-11 | Carver | Minnesota | 27019 | 27382 | 117 |
2494418 | 2494418 | 2022-05-11 | Isanti | Minnesota | 27059 | 10237 | 117 |
2494594 | 2494594 | 2022-05-11 | Dunklin | Missouri | 29069 | 7763 | 117 |
2495670 | 2495670 | 2022-05-11 | Scott | Tennessee | 47151 | 9097 | 117 |
2490292 | 2490292 | 2022-05-10 | Mitchell | Georgia | 13205 | 5253 | 117 |
2491140 | 2491140 | 2022-05-10 | Carver | Minnesota | 27019 | 27353 | 117 |
2491160 | 2491160 | 2022-05-10 | Isanti | Minnesota | 27059 | 10230 | 117 |
2491336 | 2491336 | 2022-05-10 | Dunklin | Missouri | 29069 | 7763 | 117 |
2492412 | 2492412 | 2022-05-10 | Scott | Tennessee | 47151 | 9078 | 117 |
2487035 | 2487035 | 2022-05-09 | Mitchell | Georgia | 13205 | 5253 | 117 |
2487883 | 2487883 | 2022-05-09 | Carver | Minnesota | 27019 | 27244 | 117 |
2487903 | 2487903 | 2022-05-09 | Isanti | Minnesota | 27059 | 10195 | 117 |
2488078 | 2488078 | 2022-05-09 | Dunklin | Missouri | 29069 | 7763 | 117 |
2489154 | 2489154 | 2022-05-09 | Scott | Tennessee | 47151 | 9078 | 117 |
2483777 | 2483777 | 2022-05-08 | Mitchell | Georgia | 13205 | 5253 | 117 |
2484347 | 2484347 | 2022-05-08 | Johnson | Kentucky | 21115 | 6153 | 117 |
2484625 | 2484625 | 2022-05-08 | Carver | Minnesota | 27019 | 27200 | 117 |
2484645 | 2484645 | 2022-05-08 | Isanti | Minnesota | 27059 | 10182 | 117 |
2484821 | 2484821 | 2022-05-08 | Dunklin | Missouri | 29069 | 7763 | 117 |
2485897 | 2485897 | 2022-05-08 | Scott | Tennessee | 47151 | 9078 | 117 |
2480519 | 2480519 | 2022-05-07 | Mitchell | Georgia | 13205 | 5253 | 117 |
2481089 | 2481089 | 2022-05-07 | Johnson | Kentucky | 21115 | 6153 | 117 |
2481367 | 2481367 | 2022-05-07 | Carver | Minnesota | 27019 | 27200 | 117 |
2481387 | 2481387 | 2022-05-07 | Isanti | Minnesota | 27059 | 10182 | 117 |
2481563 | 2481563 | 2022-05-07 | Dunklin | Missouri | 29069 | 7763 | 117 |
2482639 | 2482639 | 2022-05-07 | Scott | Tennessee | 47151 | 9078 | 117 |
2477261 | 2477261 | 2022-05-06 | Mitchell | Georgia | 13205 | 5253 | 117 |
2477831 | 2477831 | 2022-05-06 | Johnson | Kentucky | 21115 | 6153 | 117 |
2478109 | 2478109 | 2022-05-06 | Carver | Minnesota | 27019 | 27200 | 117 |
2478129 | 2478129 | 2022-05-06 | Isanti | Minnesota | 27059 | 10182 | 117 |
2478305 | 2478305 | 2022-05-06 | Dunklin | Missouri | 29069 | 7763 | 117 |
2479381 | 2479381 | 2022-05-06 | Scott | Tennessee | 47151 | 9078 | 117 |
2474003 | 2474003 | 2022-05-05 | Mitchell | Georgia | 13205 | 5253 | 117 |
2474573 | 2474573 | 2022-05-05 | Johnson | Kentucky | 21115 | 6153 | 117 |
2474851 | 2474851 | 2022-05-05 | Carver | Minnesota | 27019 | 27165 | 117 |
2474871 | 2474871 | 2022-05-05 | Isanti | Minnesota | 27059 | 10173 | 117 |
2475047 | 2475047 | 2022-05-05 | Dunklin | Missouri | 29069 | 7691 | 117 |
2476123 | 2476123 | 2022-05-05 | Scott | Tennessee | 47151 | 9078 | 117 |
2470746 | 2470746 | 2022-05-04 | Mitchell | Georgia | 13205 | 5253 | 117 |
2471316 | 2471316 | 2022-05-04 | Johnson | Kentucky | 21115 | 6153 | 117 |
2471594 | 2471594 | 2022-05-04 | Carver | Minnesota | 27019 | 27129 | 117 |
2471614 | 2471614 | 2022-05-04 | Isanti | Minnesota | 27059 | 10164 | 117 |
2471780 | 2471780 | 2022-05-04 | Clinton | Missouri | 29049 | 4804 | 117 |
2471790 | 2471790 | 2022-05-04 | Dunklin | Missouri | 29069 | 7456 | 117 |
2472131 | 2472131 | 2022-05-04 | Livingston | New York | 36051 | 12118 | 117 |
2472866 | 2472866 | 2022-05-04 | Scott | Tennessee | 47151 | 9078 | 117 |
2473251 | 2473251 | 2022-05-04 | Isle of Wight | Virginia | 51093 | 7354 | 117 |
2467490 | 2467490 | 2022-05-03 | Mitchell | Georgia | 13205 | 5250 | 117 |
2468060 | 2468060 | 2022-05-03 | Johnson | Kentucky | 21115 | 6153 | 117 |
2468338 | 2468338 | 2022-05-03 | Carver | Minnesota | 27019 | 27065 | 117 |
2468358 | 2468358 | 2022-05-03 | Isanti | Minnesota | 27059 | 10158 | 117 |
2468524 | 2468524 | 2022-05-03 | Clinton | Missouri | 29049 | 4804 | 117 |
2468534 | 2468534 | 2022-05-03 | Dunklin | Missouri | 29069 | 7456 | 117 |
2468875 | 2468875 | 2022-05-03 | Livingston | New York | 36051 | 12098 | 117 |
2468925 | 2468925 | 2022-05-03 | Carteret | North Carolina | 37031 | 14138 | 117 |
2468965 | 2468965 | 2022-05-03 | Macon | North Carolina | 37113 | 7940 | 117 |
2469610 | 2469610 | 2022-05-03 | Scott | Tennessee | 47151 | 9057 | 117 |
2469995 | 2469995 | 2022-05-03 | Isle of Wight | Virginia | 51093 | 7352 | 117 |
2470051 | 2470051 | 2022-05-03 | Staunton city | Virginia | 51790 | 5725 | 117 |
2464235 | 2464235 | 2022-05-02 | Mitchell | Georgia | 13205 | 5250 | 117 |
2464805 | 2464805 | 2022-05-02 | Johnson | Kentucky | 21115 | 6153 | 117 |
2465083 | 2465083 | 2022-05-02 | Carver | Minnesota | 27019 | 27010 | 117 |
2465103 | 2465103 | 2022-05-02 | Isanti | Minnesota | 27059 | 10152 | 117 |
2465268 | 2465268 | 2022-05-02 | Clinton | Missouri | 29049 | 4804 | 117 |
2465278 | 2465278 | 2022-05-02 | Dunklin | Missouri | 29069 | 7456 | 117 |
2465669 | 2465669 | 2022-05-02 | Carteret | North Carolina | 37031 | 14138 | 117 |
2465709 | 2465709 | 2022-05-02 | Macon | North Carolina | 37113 | 7940 | 117 |
2466354 | 2466354 | 2022-05-02 | Scott | Tennessee | 47151 | 9057 | 117 |
2460979 | 2460979 | 2022-05-01 | Mitchell | Georgia | 13205 | 5249 | 117 |
2461127 | 2461127 | 2022-05-01 | Iroquois | Illinois | 17075 | 7230 | 117 |
2461827 | 2461827 | 2022-05-01 | Carver | Minnesota | 27019 | 26982 | 117 |
2461847 | 2461847 | 2022-05-01 | Isanti | Minnesota | 27059 | 10147 | 117 |
2462013 | 2462013 | 2022-05-01 | Clinton | Missouri | 29049 | 4804 | 117 |
2462023 | 2462023 | 2022-05-01 | Dunklin | Missouri | 29069 | 7456 | 117 |
2462414 | 2462414 | 2022-05-01 | Carteret | North Carolina | 37031 | 14138 | 117 |
2462454 | 2462454 | 2022-05-01 | Macon | North Carolina | 37113 | 7940 | 117 |
2463099 | 2463099 | 2022-05-01 | Scott | Tennessee | 47151 | 9057 | 117 |
2457723 | 2457723 | 2022-04-30 | Mitchell | Georgia | 13205 | 5249 | 117 |
2457871 | 2457871 | 2022-04-30 | Iroquois | Illinois | 17075 | 7230 | 117 |
2458571 | 2458571 | 2022-04-30 | Carver | Minnesota | 27019 | 26982 | 117 |
2458591 | 2458591 | 2022-04-30 | Isanti | Minnesota | 27059 | 10147 | 117 |
2458757 | 2458757 | 2022-04-30 | Clinton | Missouri | 29049 | 4804 | 117 |
2458767 | 2458767 | 2022-04-30 | Dunklin | Missouri | 29069 | 7456 | 117 |
2459158 | 2459158 | 2022-04-30 | Carteret | North Carolina | 37031 | 14138 | 117 |
2459198 | 2459198 | 2022-04-30 | Macon | North Carolina | 37113 | 7940 | 117 |
2459843 | 2459843 | 2022-04-30 | Scott | Tennessee | 47151 | 9057 | 117 |
2454467 | 2454467 | 2022-04-29 | Mitchell | Georgia | 13205 | 5249 | 117 |
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);