ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where county = "Jefferson" and deaths = 19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 15
- Arkansas 14
- Mississippi 8
- Illinois 7
- Florida 4
- Georgia 4
- Wisconsin 4
- Washington 3
- West Virginia 3
- Idaho 2
- Indiana 2
- Montana 2
- Texas 2
- Missouri 1
- New York 1
- Tennessee 1
fips 15
county 1
- Jefferson · 58 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1996990 | 1996990 | 2021-12-09 | Jefferson | Montana | 30043 | 1917 | 19 |
1993739 | 1993739 | 2021-12-08 | Jefferson | Montana | 30043 | 1916 | 19 |
1972429 | 1972429 | 2021-12-01 | Jefferson | Washington | 53031 | 1240 | 19 |
1969179 | 1969179 | 2021-11-30 | Jefferson | Washington | 53031 | 1240 | 19 |
1965929 | 1965929 | 2021-11-29 | Jefferson | Washington | 53031 | 1236 | 19 |
966226 | 966226 | 2021-01-26 | Jefferson | Florida | 12065 | 1252 | 19 |
966454 | 966454 | 2021-01-26 | Jefferson | Idaho | 16051 | 2249 | 19 |
962981 | 962981 | 2021-01-25 | Jefferson | Florida | 12065 | 1250 | 19 |
963209 | 963209 | 2021-01-25 | Jefferson | Idaho | 16051 | 2236 | 19 |
959736 | 959736 | 2021-01-24 | Jefferson | Florida | 12065 | 1247 | 19 |
956490 | 956490 | 2021-01-23 | Jefferson | Florida | 12065 | 1241 | 19 |
947846 | 947846 | 2021-01-20 | Jefferson | Mississippi | 28063 | 554 | 19 |
944599 | 944599 | 2021-01-19 | Jefferson | Mississippi | 28063 | 549 | 19 |
941354 | 941354 | 2021-01-18 | Jefferson | Mississippi | 28063 | 543 | 19 |
938109 | 938109 | 2021-01-17 | Jefferson | Mississippi | 28063 | 538 | 19 |
934864 | 934864 | 2021-01-16 | Jefferson | Mississippi | 28063 | 534 | 19 |
931619 | 931619 | 2021-01-15 | Jefferson | Mississippi | 28063 | 530 | 19 |
928374 | 928374 | 2021-01-14 | Jefferson | Mississippi | 28063 | 520 | 19 |
928795 | 928795 | 2021-01-14 | Jefferson | New York | 36045 | 2841 | 19 |
925128 | 925128 | 2021-01-13 | Jefferson | Mississippi | 28063 | 514 | 19 |
835930 | 835930 | 2020-12-16 | Jefferson | West Virginia | 54037 | 1914 | 19 |
832684 | 832684 | 2020-12-15 | Jefferson | West Virginia | 54037 | 1874 | 19 |
829437 | 829437 | 2020-12-14 | Jefferson | West Virginia | 54037 | 1836 | 19 |
794608 | 794608 | 2020-12-04 | Jefferson | Indiana | 18077 | 1412 | 19 |
791363 | 791363 | 2020-12-03 | Jefferson | Indiana | 18077 | 1398 | 19 |
696457 | 696457 | 2020-11-03 | Jefferson | Wisconsin | 55055 | 3283 | 19 |
693215 | 693215 | 2020-11-02 | Jefferson | Wisconsin | 55055 | 3197 | 19 |
689971 | 689971 | 2020-11-01 | Jefferson | Wisconsin | 55055 | 3144 | 19 |
686726 | 686726 | 2020-10-31 | Jefferson | Wisconsin | 55055 | 3079 | 19 |
650438 | 650438 | 2020-10-20 | Jefferson | Tennessee | 47089 | 1466 | 19 |
502544 | 502544 | 2020-09-05 | Jefferson | Georgia | 13163 | 706 | 19 |
499310 | 499310 | 2020-09-04 | Jefferson | Georgia | 13163 | 700 | 19 |
496077 | 496077 | 2020-09-03 | Jefferson | Georgia | 13163 | 689 | 19 |
492843 | 492843 | 2020-09-02 | Jefferson | Georgia | 13163 | 675 | 19 |
421978 | 421978 | 2020-08-11 | Jefferson | Illinois | 17081 | 292 | 19 |
418755 | 418755 | 2020-08-10 | Jefferson | Illinois | 17081 | 290 | 19 |
415534 | 415534 | 2020-08-09 | Jefferson | Illinois | 17081 | 286 | 19 |
412314 | 412314 | 2020-08-08 | Jefferson | Illinois | 17081 | 282 | 19 |
409095 | 409095 | 2020-08-07 | Jefferson | Illinois | 17081 | 247 | 19 |
405875 | 405875 | 2020-08-06 | Jefferson | Illinois | 17081 | 218 | 19 |
402657 | 402657 | 2020-08-05 | Jefferson | Illinois | 17081 | 213 | 19 |
219918 | 219918 | 2020-06-08 | Jefferson | Missouri | 29099 | 407 | 19 |
154363 | 154363 | 2020-05-18 | Jefferson | Arkansas | 5069 | 491 | 19 |
151351 | 151351 | 2020-05-17 | Jefferson | Arkansas | 5069 | 491 | 19 |
148342 | 148342 | 2020-05-16 | Jefferson | Arkansas | 5069 | 362 | 19 |
145339 | 145339 | 2020-05-15 | Jefferson | Arkansas | 5069 | 310 | 19 |
142340 | 142340 | 2020-05-14 | Jefferson | Arkansas | 5069 | 300 | 19 |
139344 | 139344 | 2020-05-13 | Jefferson | Arkansas | 5069 | 280 | 19 |
136353 | 136353 | 2020-05-12 | Jefferson | Arkansas | 5069 | 273 | 19 |
133363 | 133363 | 2020-05-11 | Jefferson | Arkansas | 5069 | 238 | 19 |
130373 | 130373 | 2020-05-10 | Jefferson | Arkansas | 5069 | 234 | 19 |
127383 | 127383 | 2020-05-09 | Jefferson | Arkansas | 5069 | 226 | 19 |
124398 | 124398 | 2020-05-08 | Jefferson | Arkansas | 5069 | 226 | 19 |
121418 | 121418 | 2020-05-07 | Jefferson | Arkansas | 5069 | 222 | 19 |
118451 | 118451 | 2020-05-06 | Jefferson | Arkansas | 5069 | 217 | 19 |
115492 | 115492 | 2020-05-05 | Jefferson | Arkansas | 5069 | 199 | 19 |
100559 | 100559 | 2020-04-29 | Jefferson | Texas | 48245 | 298 | 19 |
97709 | 97709 | 2020-04-28 | Jefferson | Texas | 48245 | 288 | 19 |
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);