ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,809 rows where deaths = 97 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 324
- Texas 313
- Tennessee 257
- Louisiana 242
- North Carolina 234
- Indiana 229
- Florida 203
- Virginia 191
- Ohio 181
- Illinois 180
- Minnesota 173
- Mississippi 173
- Kentucky 160
- Missouri 156
- New York 148
- Wisconsin 147
- Arkansas 140
- Iowa 131
- Oklahoma 122
- Pennsylvania 122
- Michigan 121
- West Virginia 107
- Alabama 93
- North Dakota 80
- Kansas 63
- California 62
- South Carolina 59
- Washington 53
- New Mexico 43
- Colorado 38
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499936 | 2499936 | 2022-05-13 | Madison | Florida | 12079 | 5849 | 97 |
2500371 | 2500371 | 2022-05-13 | White | Indiana | 18181 | 6934 | 97 |
2500740 | 2500740 | 2022-05-13 | Richland | Louisiana | 22083 | 6732 | 97 |
2500913 | 2500913 | 2022-05-13 | Carlton | Minnesota | 27017 | 9257 | 97 |
2501136 | 2501136 | 2022-05-13 | Livingston | Missouri | 29117 | 3748 | 97 |
2501416 | 2501416 | 2022-05-13 | Roosevelt | New Mexico | 35041 | 5023 | 97 |
2501632 | 2501632 | 2022-05-13 | Stutsman | North Dakota | 38093 | 7113 | 97 |
2502356 | 2502356 | 2022-05-13 | Llano | Texas | 48299 | 3933 | 97 |
2502537 | 2502537 | 2022-05-13 | Colonial Heights city | Virginia | 51570 | 4958 | 97 |
2502621 | 2502621 | 2022-05-13 | Salem city | Virginia | 51775 | 5745 | 97 |
2502716 | 2502716 | 2022-05-13 | Nicholas | West Virginia | 54067 | 7378 | 97 |
2496678 | 2496678 | 2022-05-12 | Madison | Florida | 12079 | 5849 | 97 |
2497482 | 2497482 | 2022-05-12 | Richland | Louisiana | 22083 | 6730 | 97 |
2497655 | 2497655 | 2022-05-12 | Carlton | Minnesota | 27017 | 9236 | 97 |
2498158 | 2498158 | 2022-05-12 | Roosevelt | New Mexico | 35041 | 5023 | 97 |
2498374 | 2498374 | 2022-05-12 | Stutsman | North Dakota | 38093 | 7100 | 97 |
2499098 | 2499098 | 2022-05-12 | Llano | Texas | 48299 | 3933 | 97 |
2499279 | 2499279 | 2022-05-12 | Colonial Heights city | Virginia | 51570 | 4956 | 97 |
2499363 | 2499363 | 2022-05-12 | Salem city | Virginia | 51775 | 5746 | 97 |
2499458 | 2499458 | 2022-05-12 | Nicholas | West Virginia | 54067 | 7376 | 97 |
2493420 | 2493420 | 2022-05-11 | Madison | Florida | 12079 | 5849 | 97 |
2494224 | 2494224 | 2022-05-11 | Richland | Louisiana | 22083 | 6729 | 97 |
2494397 | 2494397 | 2022-05-11 | Carlton | Minnesota | 27017 | 9213 | 97 |
2494900 | 2494900 | 2022-05-11 | Roosevelt | New Mexico | 35041 | 5023 | 97 |
2495116 | 2495116 | 2022-05-11 | Stutsman | North Dakota | 38093 | 7100 | 97 |
2495840 | 2495840 | 2022-05-11 | Llano | Texas | 48299 | 3930 | 97 |
2496021 | 2496021 | 2022-05-11 | Colonial Heights city | Virginia | 51570 | 4951 | 97 |
2496105 | 2496105 | 2022-05-11 | Salem city | Virginia | 51775 | 5745 | 97 |
2496200 | 2496200 | 2022-05-11 | Nicholas | West Virginia | 54067 | 7371 | 97 |
2490162 | 2490162 | 2022-05-10 | Madison | Florida | 12079 | 5849 | 97 |
2490966 | 2490966 | 2022-05-10 | Richland | Louisiana | 22083 | 6729 | 97 |
2491139 | 2491139 | 2022-05-10 | Carlton | Minnesota | 27017 | 9150 | 97 |
2491642 | 2491642 | 2022-05-10 | Roosevelt | New Mexico | 35041 | 5022 | 97 |
2491858 | 2491858 | 2022-05-10 | Stutsman | North Dakota | 38093 | 7100 | 97 |
2492348 | 2492348 | 2022-05-10 | Chester | Tennessee | 47023 | 5863 | 97 |
2492582 | 2492582 | 2022-05-10 | Llano | Texas | 48299 | 3928 | 97 |
2492763 | 2492763 | 2022-05-10 | Colonial Heights city | Virginia | 51570 | 4945 | 97 |
2492847 | 2492847 | 2022-05-10 | Salem city | Virginia | 51775 | 5738 | 97 |
2492942 | 2492942 | 2022-05-10 | Nicholas | West Virginia | 54067 | 7364 | 97 |
2486905 | 2486905 | 2022-05-09 | Madison | Florida | 12079 | 5849 | 97 |
2487709 | 2487709 | 2022-05-09 | Richland | Louisiana | 22083 | 6727 | 97 |
2487882 | 2487882 | 2022-05-09 | Carlton | Minnesota | 27017 | 9114 | 97 |
2488384 | 2488384 | 2022-05-09 | Roosevelt | New Mexico | 35041 | 5019 | 97 |
2488600 | 2488600 | 2022-05-09 | Stutsman | North Dakota | 38093 | 7100 | 97 |
2489090 | 2489090 | 2022-05-09 | Chester | Tennessee | 47023 | 5863 | 97 |
2489324 | 2489324 | 2022-05-09 | Llano | Texas | 48299 | 3926 | 97 |
2489505 | 2489505 | 2022-05-09 | Colonial Heights city | Virginia | 51570 | 4942 | 97 |
2489589 | 2489589 | 2022-05-09 | Salem city | Virginia | 51775 | 5737 | 97 |
2489684 | 2489684 | 2022-05-09 | Nicholas | West Virginia | 54067 | 7364 | 97 |
2483647 | 2483647 | 2022-05-08 | Madison | Florida | 12079 | 5849 | 97 |
2484451 | 2484451 | 2022-05-08 | Richland | Louisiana | 22083 | 6725 | 97 |
2484624 | 2484624 | 2022-05-08 | Carlton | Minnesota | 27017 | 9091 | 97 |
2485127 | 2485127 | 2022-05-08 | Roosevelt | New Mexico | 35041 | 5018 | 97 |
2485343 | 2485343 | 2022-05-08 | Stutsman | North Dakota | 38093 | 7100 | 97 |
2485833 | 2485833 | 2022-05-08 | Chester | Tennessee | 47023 | 5863 | 97 |
2486067 | 2486067 | 2022-05-08 | Llano | Texas | 48299 | 3926 | 97 |
2486248 | 2486248 | 2022-05-08 | Colonial Heights city | Virginia | 51570 | 4933 | 97 |
2486332 | 2486332 | 2022-05-08 | Salem city | Virginia | 51775 | 5725 | 97 |
2486427 | 2486427 | 2022-05-08 | Nicholas | West Virginia | 54067 | 7344 | 97 |
2486511 | 2486511 | 2022-05-08 | Vernon | Wisconsin | 55123 | 6183 | 97 |
2480389 | 2480389 | 2022-05-07 | Madison | Florida | 12079 | 5849 | 97 |
2481193 | 2481193 | 2022-05-07 | Richland | Louisiana | 22083 | 6725 | 97 |
2481366 | 2481366 | 2022-05-07 | Carlton | Minnesota | 27017 | 9091 | 97 |
2481869 | 2481869 | 2022-05-07 | Roosevelt | New Mexico | 35041 | 5018 | 97 |
2482085 | 2482085 | 2022-05-07 | Stutsman | North Dakota | 38093 | 7100 | 97 |
2482575 | 2482575 | 2022-05-07 | Chester | Tennessee | 47023 | 5863 | 97 |
2482809 | 2482809 | 2022-05-07 | Llano | Texas | 48299 | 3922 | 97 |
2482990 | 2482990 | 2022-05-07 | Colonial Heights city | Virginia | 51570 | 4933 | 97 |
2483074 | 2483074 | 2022-05-07 | Salem city | Virginia | 51775 | 5725 | 97 |
2483169 | 2483169 | 2022-05-07 | Nicholas | West Virginia | 54067 | 7344 | 97 |
2483253 | 2483253 | 2022-05-07 | Vernon | Wisconsin | 55123 | 6183 | 97 |
2477131 | 2477131 | 2022-05-06 | Madison | Florida | 12079 | 5849 | 97 |
2477935 | 2477935 | 2022-05-06 | Richland | Louisiana | 22083 | 6725 | 97 |
2478108 | 2478108 | 2022-05-06 | Carlton | Minnesota | 27017 | 9091 | 97 |
2478611 | 2478611 | 2022-05-06 | Roosevelt | New Mexico | 35041 | 5018 | 97 |
2478827 | 2478827 | 2022-05-06 | Stutsman | North Dakota | 38093 | 7100 | 97 |
2479317 | 2479317 | 2022-05-06 | Chester | Tennessee | 47023 | 5863 | 97 |
2479551 | 2479551 | 2022-05-06 | Llano | Texas | 48299 | 3916 | 97 |
2479732 | 2479732 | 2022-05-06 | Colonial Heights city | Virginia | 51570 | 4933 | 97 |
2479816 | 2479816 | 2022-05-06 | Salem city | Virginia | 51775 | 5725 | 97 |
2479911 | 2479911 | 2022-05-06 | Nicholas | West Virginia | 54067 | 7344 | 97 |
2479995 | 2479995 | 2022-05-06 | Vernon | Wisconsin | 55123 | 6183 | 97 |
2473873 | 2473873 | 2022-05-05 | Madison | Florida | 12079 | 5838 | 97 |
2474677 | 2474677 | 2022-05-05 | Richland | Louisiana | 22083 | 6725 | 97 |
2475569 | 2475569 | 2022-05-05 | Stutsman | North Dakota | 38093 | 7089 | 97 |
2476059 | 2476059 | 2022-05-05 | Chester | Tennessee | 47023 | 5863 | 97 |
2476293 | 2476293 | 2022-05-05 | Llano | Texas | 48299 | 3915 | 97 |
2476474 | 2476474 | 2022-05-05 | Colonial Heights city | Virginia | 51570 | 4926 | 97 |
2476558 | 2476558 | 2022-05-05 | Salem city | Virginia | 51775 | 5712 | 97 |
2476653 | 2476653 | 2022-05-05 | Nicholas | West Virginia | 54067 | 7339 | 97 |
2476737 | 2476737 | 2022-05-05 | Vernon | Wisconsin | 55123 | 6173 | 97 |
2470616 | 2470616 | 2022-05-04 | Madison | Florida | 12079 | 5838 | 97 |
2471420 | 2471420 | 2022-05-04 | Richland | Louisiana | 22083 | 6725 | 97 |
2472312 | 2472312 | 2022-05-04 | Stutsman | North Dakota | 38093 | 7089 | 97 |
2472802 | 2472802 | 2022-05-04 | Chester | Tennessee | 47023 | 5863 | 97 |
2473036 | 2473036 | 2022-05-04 | Llano | Texas | 48299 | 3914 | 97 |
2473216 | 2473216 | 2022-05-04 | Colonial Heights city | Virginia | 51570 | 4921 | 97 |
2473300 | 2473300 | 2022-05-04 | Salem city | Virginia | 51775 | 5709 | 97 |
2473395 | 2473395 | 2022-05-04 | Nicholas | West Virginia | 54067 | 7334 | 97 |
2473479 | 2473479 | 2022-05-04 | Vernon | Wisconsin | 55123 | 6152 | 97 |
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);