ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,566 rows where deaths = 195 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 112
- Texas 109
- Virginia 90
- Ohio 86
- North Carolina 74
- Kentucky 72
- Louisiana 72
- Georgia 70
- Michigan 70
- Indiana 66
- Tennessee 65
- Alabama 62
- Connecticut 62
- Washington 44
- Mississippi 36
- South Carolina 34
- Arkansas 32
- New Jersey 32
- Pennsylvania 31
- Illinois 27
- West Virginia 25
- Wisconsin 25
- Florida 24
- Missouri 24
- New York 23
- Maine 18
- Oregon 18
- New Mexico 16
- Arizona 14
- California 14
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502034 | 2502034 | 2022-05-13 | Newberry | South Carolina | 45071 | 13355 | 195 |
2502176 | 2502176 | 2022-05-13 | Obion | Tennessee | 47131 | 10786 | 195 |
2498776 | 2498776 | 2022-05-12 | Newberry | South Carolina | 45071 | 13355 | 195 |
2498918 | 2498918 | 2022-05-12 | Obion | Tennessee | 47131 | 10786 | 195 |
2495518 | 2495518 | 2022-05-11 | Newberry | South Carolina | 45071 | 13355 | 195 |
2495660 | 2495660 | 2022-05-11 | Obion | Tennessee | 47131 | 10786 | 195 |
2492402 | 2492402 | 2022-05-10 | Obion | Tennessee | 47131 | 10780 | 195 |
2489144 | 2489144 | 2022-05-09 | Obion | Tennessee | 47131 | 10780 | 195 |
2484407 | 2484407 | 2022-05-08 | Whitley | Kentucky | 21235 | 14404 | 195 |
2485887 | 2485887 | 2022-05-08 | Obion | Tennessee | 47131 | 10780 | 195 |
2481149 | 2481149 | 2022-05-07 | Whitley | Kentucky | 21235 | 14404 | 195 |
2482629 | 2482629 | 2022-05-07 | Obion | Tennessee | 47131 | 10780 | 195 |
2477891 | 2477891 | 2022-05-06 | Whitley | Kentucky | 21235 | 14404 | 195 |
2479371 | 2479371 | 2022-05-06 | Obion | Tennessee | 47131 | 10780 | 195 |
2474633 | 2474633 | 2022-05-05 | Whitley | Kentucky | 21235 | 14404 | 195 |
2476113 | 2476113 | 2022-05-05 | Obion | Tennessee | 47131 | 10780 | 195 |
2471376 | 2471376 | 2022-05-04 | Whitley | Kentucky | 21235 | 14404 | 195 |
2472856 | 2472856 | 2022-05-04 | Obion | Tennessee | 47131 | 10780 | 195 |
2468120 | 2468120 | 2022-05-03 | Whitley | Kentucky | 21235 | 14404 | 195 |
2469600 | 2469600 | 2022-05-03 | Obion | Tennessee | 47131 | 10770 | 195 |
2464865 | 2464865 | 2022-05-02 | Whitley | Kentucky | 21235 | 14404 | 195 |
2466344 | 2466344 | 2022-05-02 | Obion | Tennessee | 47131 | 10770 | 195 |
2463089 | 2463089 | 2022-05-01 | Obion | Tennessee | 47131 | 10770 | 195 |
2459833 | 2459833 | 2022-04-30 | Obion | Tennessee | 47131 | 10770 | 195 |
2456577 | 2456577 | 2022-04-29 | Obion | Tennessee | 47131 | 10770 | 195 |
2453321 | 2453321 | 2022-04-28 | Obion | Tennessee | 47131 | 10770 | 195 |
2450065 | 2450065 | 2022-04-27 | Obion | Tennessee | 47131 | 10770 | 195 |
2446142 | 2446142 | 2022-04-26 | Craven | North Carolina | 37049 | 24325 | 195 |
2442887 | 2442887 | 2022-04-25 | Craven | North Carolina | 37049 | 24325 | 195 |
2439631 | 2439631 | 2022-04-24 | Craven | North Carolina | 37049 | 24325 | 195 |
2440673 | 2440673 | 2022-04-24 | Franklin | Virginia | 51067 | 10813 | 195 |
2436375 | 2436375 | 2022-04-23 | Craven | North Carolina | 37049 | 24325 | 195 |
2437417 | 2437417 | 2022-04-23 | Franklin | Virginia | 51067 | 10813 | 195 |
2433119 | 2433119 | 2022-04-22 | Craven | North Carolina | 37049 | 24325 | 195 |
2434161 | 2434161 | 2022-04-22 | Franklin | Virginia | 51067 | 10813 | 195 |
2429863 | 2429863 | 2022-04-21 | Craven | North Carolina | 37049 | 24325 | 195 |
2430905 | 2430905 | 2022-04-21 | Franklin | Virginia | 51067 | 10807 | 195 |
2426607 | 2426607 | 2022-04-20 | Craven | North Carolina | 37049 | 24325 | 195 |
2427649 | 2427649 | 2022-04-20 | Franklin | Virginia | 51067 | 10801 | 195 |
2423351 | 2423351 | 2022-04-19 | Craven | North Carolina | 37049 | 24277 | 195 |
2420094 | 2420094 | 2022-04-18 | Craven | North Carolina | 37049 | 24277 | 195 |
2416839 | 2416839 | 2022-04-17 | Craven | North Carolina | 37049 | 24277 | 195 |
2413583 | 2413583 | 2022-04-16 | Craven | North Carolina | 37049 | 24277 | 195 |
2410327 | 2410327 | 2022-04-15 | Craven | North Carolina | 37049 | 24277 | 195 |
2407071 | 2407071 | 2022-04-14 | Craven | North Carolina | 37049 | 24277 | 195 |
2408216 | 2408216 | 2022-04-14 | Grays Harbor | Washington | 53027 | 16188 | 195 |
2403815 | 2403815 | 2022-04-13 | Craven | North Carolina | 37049 | 24277 | 195 |
2404944 | 2404944 | 2022-04-13 | Wise | Virginia | 51195 | 10248 | 195 |
2404960 | 2404960 | 2022-04-13 | Grays Harbor | Washington | 53027 | 16188 | 195 |
2399380 | 2399380 | 2022-04-12 | Marshall | Indiana | 18099 | 12319 | 195 |
2400560 | 2400560 | 2022-04-12 | Craven | North Carolina | 37049 | 24189 | 195 |
2401210 | 2401210 | 2022-04-12 | Lawrence | Tennessee | 47099 | 14264 | 195 |
2401653 | 2401653 | 2022-04-12 | Pittsylvania | Virginia | 51143 | 14020 | 195 |
2401689 | 2401689 | 2022-04-12 | Wise | Virginia | 51195 | 10248 | 195 |
2401705 | 2401705 | 2022-04-12 | Grays Harbor | Washington | 53027 | 16172 | 195 |
2396125 | 2396125 | 2022-04-11 | Marshall | Indiana | 18099 | 12319 | 195 |
2397305 | 2397305 | 2022-04-11 | Craven | North Carolina | 37049 | 24189 | 195 |
2397955 | 2397955 | 2022-04-11 | Lawrence | Tennessee | 47099 | 14264 | 195 |
2398398 | 2398398 | 2022-04-11 | Pittsylvania | Virginia | 51143 | 14025 | 195 |
2398434 | 2398434 | 2022-04-11 | Wise | Virginia | 51195 | 10248 | 195 |
2398450 | 2398450 | 2022-04-11 | Grays Harbor | Washington | 53027 | 16172 | 195 |
2392869 | 2392869 | 2022-04-10 | Marshall | Indiana | 18099 | 12319 | 195 |
2394050 | 2394050 | 2022-04-10 | Craven | North Carolina | 37049 | 24189 | 195 |
2394700 | 2394700 | 2022-04-10 | Lawrence | Tennessee | 47099 | 14264 | 195 |
2395143 | 2395143 | 2022-04-10 | Pittsylvania | Virginia | 51143 | 14021 | 195 |
2395195 | 2395195 | 2022-04-10 | Grays Harbor | Washington | 53027 | 16172 | 195 |
2389613 | 2389613 | 2022-04-09 | Marshall | Indiana | 18099 | 12319 | 195 |
2390794 | 2390794 | 2022-04-09 | Craven | North Carolina | 37049 | 24189 | 195 |
2391444 | 2391444 | 2022-04-09 | Lawrence | Tennessee | 47099 | 14264 | 195 |
2391887 | 2391887 | 2022-04-09 | Pittsylvania | Virginia | 51143 | 14021 | 195 |
2391939 | 2391939 | 2022-04-09 | Grays Harbor | Washington | 53027 | 16172 | 195 |
2386358 | 2386358 | 2022-04-08 | Marshall | Indiana | 18099 | 12319 | 195 |
2387538 | 2387538 | 2022-04-08 | Craven | North Carolina | 37049 | 24189 | 195 |
2388188 | 2388188 | 2022-04-08 | Lawrence | Tennessee | 47099 | 14264 | 195 |
2388631 | 2388631 | 2022-04-08 | Pittsylvania | Virginia | 51143 | 14021 | 195 |
2388683 | 2388683 | 2022-04-08 | Grays Harbor | Washington | 53027 | 16172 | 195 |
2383103 | 2383103 | 2022-04-07 | Marshall | Indiana | 18099 | 12319 | 195 |
2384283 | 2384283 | 2022-04-07 | Craven | North Carolina | 37049 | 24189 | 195 |
2384933 | 2384933 | 2022-04-07 | Lawrence | Tennessee | 47099 | 14264 | 195 |
2385376 | 2385376 | 2022-04-07 | Pittsylvania | Virginia | 51143 | 14002 | 195 |
2385428 | 2385428 | 2022-04-07 | Grays Harbor | Washington | 53027 | 16163 | 195 |
2379848 | 2379848 | 2022-04-06 | Marshall | Indiana | 18099 | 12319 | 195 |
2381028 | 2381028 | 2022-04-06 | Craven | North Carolina | 37049 | 24189 | 195 |
2381678 | 2381678 | 2022-04-06 | Lawrence | Tennessee | 47099 | 14264 | 195 |
2382121 | 2382121 | 2022-04-06 | Pittsylvania | Virginia | 51143 | 13981 | 195 |
2382173 | 2382173 | 2022-04-06 | Grays Harbor | Washington | 53027 | 16163 | 195 |
2376594 | 2376594 | 2022-04-05 | Marshall | Indiana | 18099 | 12317 | 195 |
2377773 | 2377773 | 2022-04-05 | Craven | North Carolina | 37049 | 24152 | 195 |
2378918 | 2378918 | 2022-04-05 | Grays Harbor | Washington | 53027 | 16159 | 195 |
2378974 | 2378974 | 2022-04-05 | Monongalia | West Virginia | 54061 | 24603 | 195 |
2373342 | 2373342 | 2022-04-04 | Marshall | Indiana | 18099 | 12317 | 195 |
2374520 | 2374520 | 2022-04-04 | Craven | North Carolina | 37049 | 24151 | 195 |
2375664 | 2375664 | 2022-04-04 | Grays Harbor | Washington | 53027 | 16159 | 195 |
2370089 | 2370089 | 2022-04-03 | Marshall | Indiana | 18099 | 12316 | 195 |
2371268 | 2371268 | 2022-04-03 | Craven | North Carolina | 37049 | 24140 | 195 |
2372412 | 2372412 | 2022-04-03 | Grays Harbor | Washington | 53027 | 16154 | 195 |
2366836 | 2366836 | 2022-04-02 | Marshall | Indiana | 18099 | 12316 | 195 |
2368015 | 2368015 | 2022-04-02 | Craven | North Carolina | 37049 | 24140 | 195 |
2369159 | 2369159 | 2022-04-02 | Grays Harbor | Washington | 53027 | 16154 | 195 |
2363583 | 2363583 | 2022-04-01 | Marshall | Indiana | 18099 | 12316 | 195 |
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);