ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,413 rows where deaths = 127 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 211
- Illinois 210
- Missouri 207
- Georgia 203
- North Carolina 181
- Tennessee 159
- Florida 158
- Oklahoma 150
- Louisiana 146
- Alabama 121
- Michigan 112
- Ohio 112
- Indiana 110
- Virginia 110
- New York 97
- Wisconsin 92
- Kentucky 89
- California 86
- Mississippi 82
- Arkansas 70
- Pennsylvania 70
- Oregon 61
- Minnesota 59
- South Carolina 59
- Idaho 53
- Kansas 43
- Nevada 38
- Washington 33
- Colorado 32
- New Mexico 28
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499741 | 2499741 | 2022-05-13 | Poinsett | Arkansas | 5111 | 8052 | 127 |
2499790 | 2499790 | 2022-05-13 | Nevada | California | 6057 | 17503 | 127 |
2500291 | 2500291 | 2022-05-13 | Clinton | Indiana | 18023 | 9259 | 127 |
2501452 | 2501452 | 2022-05-13 | Madison | New York | 36053 | 14319 | 127 |
2501494 | 2501494 | 2022-05-13 | Bladen | North Carolina | 37017 | 9365 | 127 |
2501670 | 2501670 | 2022-05-13 | Gallia | Ohio | 39053 | 7565 | 127 |
2501790 | 2501790 | 2022-05-13 | Ottawa | Oklahoma | 40115 | 9204 | 127 |
2501864 | 2501864 | 2022-05-13 | Clinton | Pennsylvania | 42035 | 9157 | 127 |
2502775 | 2502775 | 2022-05-13 | Marinette | Wisconsin | 55075 | 11760 | 127 |
2496483 | 2496483 | 2022-05-12 | Poinsett | Arkansas | 5111 | 8051 | 127 |
2496532 | 2496532 | 2022-05-12 | Nevada | California | 6057 | 17475 | 127 |
2497033 | 2497033 | 2022-05-12 | Clinton | Indiana | 18023 | 9247 | 127 |
2498194 | 2498194 | 2022-05-12 | Madison | New York | 36053 | 14319 | 127 |
2498236 | 2498236 | 2022-05-12 | Bladen | North Carolina | 37017 | 9365 | 127 |
2498412 | 2498412 | 2022-05-12 | Gallia | Ohio | 39053 | 7565 | 127 |
2498532 | 2498532 | 2022-05-12 | Ottawa | Oklahoma | 40115 | 9204 | 127 |
2498606 | 2498606 | 2022-05-12 | Clinton | Pennsylvania | 42035 | 9157 | 127 |
2499517 | 2499517 | 2022-05-12 | Marinette | Wisconsin | 55075 | 11750 | 127 |
2493225 | 2493225 | 2022-05-11 | Poinsett | Arkansas | 5111 | 8051 | 127 |
2493274 | 2493274 | 2022-05-11 | Nevada | California | 6057 | 17475 | 127 |
2493775 | 2493775 | 2022-05-11 | Clinton | Indiana | 18023 | 9247 | 127 |
2494936 | 2494936 | 2022-05-11 | Madison | New York | 36053 | 14290 | 127 |
2494978 | 2494978 | 2022-05-11 | Bladen | North Carolina | 37017 | 9365 | 127 |
2495274 | 2495274 | 2022-05-11 | Ottawa | Oklahoma | 40115 | 9199 | 127 |
2495348 | 2495348 | 2022-05-11 | Clinton | Pennsylvania | 42035 | 9157 | 127 |
2496232 | 2496232 | 2022-05-11 | Columbia | Wisconsin | 55021 | 15753 | 127 |
2489967 | 2489967 | 2022-05-10 | Poinsett | Arkansas | 5111 | 8050 | 127 |
2490016 | 2490016 | 2022-05-10 | Nevada | California | 6057 | 17475 | 127 |
2490192 | 2490192 | 2022-05-10 | Appling | Georgia | 13001 | 4829 | 127 |
2490517 | 2490517 | 2022-05-10 | Clinton | Indiana | 18023 | 9245 | 127 |
2491678 | 2491678 | 2022-05-10 | Madison | New York | 36053 | 14264 | 127 |
2491720 | 2491720 | 2022-05-10 | Bladen | North Carolina | 37017 | 9340 | 127 |
2492016 | 2492016 | 2022-05-10 | Ottawa | Oklahoma | 40115 | 9199 | 127 |
2492090 | 2492090 | 2022-05-10 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2486710 | 2486710 | 2022-05-09 | Poinsett | Arkansas | 5111 | 8049 | 127 |
2486759 | 2486759 | 2022-05-09 | Nevada | California | 6057 | 17416 | 127 |
2486935 | 2486935 | 2022-05-09 | Appling | Georgia | 13001 | 4829 | 127 |
2487260 | 2487260 | 2022-05-09 | Clinton | Indiana | 18023 | 9245 | 127 |
2488420 | 2488420 | 2022-05-09 | Madison | New York | 36053 | 14245 | 127 |
2488462 | 2488462 | 2022-05-09 | Bladen | North Carolina | 37017 | 9340 | 127 |
2488758 | 2488758 | 2022-05-09 | Ottawa | Oklahoma | 40115 | 9199 | 127 |
2488832 | 2488832 | 2022-05-09 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2483452 | 2483452 | 2022-05-08 | Poinsett | Arkansas | 5111 | 8048 | 127 |
2483501 | 2483501 | 2022-05-08 | Nevada | California | 6057 | 17416 | 127 |
2483672 | 2483672 | 2022-05-08 | Unknown | Florida | 5510 | 127 | |
2483677 | 2483677 | 2022-05-08 | Appling | Georgia | 13001 | 4828 | 127 |
2485163 | 2485163 | 2022-05-08 | Madison | New York | 36053 | 14234 | 127 |
2485205 | 2485205 | 2022-05-08 | Bladen | North Carolina | 37017 | 9340 | 127 |
2485501 | 2485501 | 2022-05-08 | Ottawa | Oklahoma | 40115 | 9199 | 127 |
2485575 | 2485575 | 2022-05-08 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2480194 | 2480194 | 2022-05-07 | Poinsett | Arkansas | 5111 | 8048 | 127 |
2480243 | 2480243 | 2022-05-07 | Nevada | California | 6057 | 17416 | 127 |
2480414 | 2480414 | 2022-05-07 | Unknown | Florida | 5510 | 127 | |
2480419 | 2480419 | 2022-05-07 | Appling | Georgia | 13001 | 4828 | 127 |
2481905 | 2481905 | 2022-05-07 | Madison | New York | 36053 | 14213 | 127 |
2481947 | 2481947 | 2022-05-07 | Bladen | North Carolina | 37017 | 9340 | 127 |
2482243 | 2482243 | 2022-05-07 | Ottawa | Oklahoma | 40115 | 9199 | 127 |
2482317 | 2482317 | 2022-05-07 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2476936 | 2476936 | 2022-05-06 | Poinsett | Arkansas | 5111 | 8047 | 127 |
2476985 | 2476985 | 2022-05-06 | Nevada | California | 6057 | 17416 | 127 |
2477161 | 2477161 | 2022-05-06 | Appling | Georgia | 13001 | 4828 | 127 |
2478647 | 2478647 | 2022-05-06 | Madison | New York | 36053 | 14175 | 127 |
2478689 | 2478689 | 2022-05-06 | Bladen | North Carolina | 37017 | 9340 | 127 |
2478985 | 2478985 | 2022-05-06 | Ottawa | Oklahoma | 40115 | 9199 | 127 |
2479059 | 2479059 | 2022-05-06 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2473678 | 2473678 | 2022-05-05 | Poinsett | Arkansas | 5111 | 8044 | 127 |
2473727 | 2473727 | 2022-05-05 | Nevada | California | 6057 | 17369 | 127 |
2473903 | 2473903 | 2022-05-05 | Appling | Georgia | 13001 | 4828 | 127 |
2475389 | 2475389 | 2022-05-05 | Madison | New York | 36053 | 14148 | 127 |
2475431 | 2475431 | 2022-05-05 | Bladen | North Carolina | 37017 | 9340 | 127 |
2475727 | 2475727 | 2022-05-05 | Ottawa | Oklahoma | 40115 | 9199 | 127 |
2475801 | 2475801 | 2022-05-05 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2470421 | 2470421 | 2022-05-04 | Poinsett | Arkansas | 5111 | 8041 | 127 |
2470470 | 2470470 | 2022-05-04 | Nevada | California | 6057 | 17369 | 127 |
2470646 | 2470646 | 2022-05-04 | Appling | Georgia | 13001 | 4828 | 127 |
2471760 | 2471760 | 2022-05-04 | Barry | Missouri | 29009 | 6625 | 127 |
2471769 | 2471769 | 2022-05-04 | Callaway | Missouri | 29027 | 12072 | 127 |
2472132 | 2472132 | 2022-05-04 | Madison | New York | 36053 | 14103 | 127 |
2472174 | 2472174 | 2022-05-04 | Bladen | North Carolina | 37017 | 9340 | 127 |
2472470 | 2472470 | 2022-05-04 | Ottawa | Oklahoma | 40115 | 9191 | 127 |
2472544 | 2472544 | 2022-05-04 | Clinton | Pennsylvania | 42035 | 9096 | 127 |
2467165 | 2467165 | 2022-05-03 | Poinsett | Arkansas | 5111 | 8041 | 127 |
2467214 | 2467214 | 2022-05-03 | Nevada | California | 6057 | 17369 | 127 |
2468504 | 2468504 | 2022-05-03 | Barry | Missouri | 29009 | 6625 | 127 |
2468513 | 2468513 | 2022-05-03 | Callaway | Missouri | 29027 | 12072 | 127 |
2468876 | 2468876 | 2022-05-03 | Madison | New York | 36053 | 14067 | 127 |
2469214 | 2469214 | 2022-05-03 | Ottawa | Oklahoma | 40115 | 9191 | 127 |
2470170 | 2470170 | 2022-05-03 | Columbia | Wisconsin | 55021 | 15544 | 127 |
2463959 | 2463959 | 2022-05-02 | Nevada | California | 6057 | 17333 | 127 |
2464034 | 2464034 | 2022-05-02 | Otero | Colorado | 8089 | 4299 | 127 |
2464412 | 2464412 | 2022-05-02 | Monroe | Illinois | 17133 | 9558 | 127 |
2465248 | 2465248 | 2022-05-02 | Barry | Missouri | 29009 | 6625 | 127 |
2465257 | 2465257 | 2022-05-02 | Callaway | Missouri | 29027 | 12072 | 127 |
2465620 | 2465620 | 2022-05-02 | Madison | New York | 36053 | 14039 | 127 |
2465958 | 2465958 | 2022-05-02 | Ottawa | Oklahoma | 40115 | 9191 | 127 |
2466914 | 2466914 | 2022-05-02 | Columbia | Wisconsin | 55021 | 15530 | 127 |
2460703 | 2460703 | 2022-05-01 | Nevada | California | 6057 | 17333 | 127 |
2460778 | 2460778 | 2022-05-01 | Otero | Colorado | 8089 | 4299 | 127 |
2461156 | 2461156 | 2022-05-01 | Monroe | Illinois | 17133 | 9545 | 127 |
2461993 | 2461993 | 2022-05-01 | Barry | Missouri | 29009 | 6625 | 127 |
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);