ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20,291 rows where county = "Jefferson" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 26
- Colorado 355
- Washington 354
- Kentucky 352
- Louisiana 351
- Arkansas 349
- Tennessee 347
- Alabama 346
- West Virginia 343
- New York 342
- Wisconsin 340
- Missouri 336
- Montana 336
- Texas 336
- Idaho 335
- Kansas 334
- Ohio 334
- Mississippi 333
- Georgia 330
- Indiana 329
- Iowa 327
- Florida 325
- Illinois 323
- Oklahoma 323
- Pennsylvania 322
- Oregon 315
- Nebraska 303
fips 26
county 1
- Jefferson · 8,720 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053650 | 1053650 | 2021-02-22 | Jefferson | Arkansas | 5069 | 8532 | 164 |
1053780 | 1053780 | 2021-02-22 | Jefferson | Colorado | 8059 | 36588 | 706 |
1053859 | 1053859 | 2021-02-22 | Jefferson | Florida | 12065 | 1392 | 23 |
1053976 | 1053976 | 2021-02-22 | Jefferson | Georgia | 13163 | 1845 | 54 |
1054087 | 1054087 | 2021-02-22 | Jefferson | Idaho | 16051 | 2406 | 21 |
1054146 | 1054146 | 2021-02-22 | Jefferson | Illinois | 17081 | 3947 | 116 |
1054247 | 1054247 | 2021-02-22 | Jefferson | Indiana | 18077 | 2928 | 73 |
1054351 | 1054351 | 2021-02-22 | Jefferson | Iowa | 19101 | 1267 | 32 |
1054444 | 1054444 | 2021-02-22 | Jefferson | Kansas | 20087 | 1605 | 30 |
1054562 | 1054562 | 2021-02-22 | Jefferson | Kentucky | 21111 | 73173 | 888 |
1054652 | 1054652 | 2021-02-22 | Jefferson | Louisiana | 22051 | 43419 | 834 |
1054952 | 1054952 | 2021-02-22 | Jefferson | Mississippi | 28063 | 607 | 27 |
1055052 | 1055052 | 2021-02-22 | Jefferson | Missouri | 29099 | 21486 | 204 |
1055141 | 1055141 | 2021-02-22 | Jefferson | Montana | 30043 | 995 | 8 |
1055223 | 1055223 | 2021-02-22 | Jefferson | Nebraska | 31095 | 626 | 1 |
1055373 | 1055373 | 2021-02-22 | Jefferson | New York | 36045 | 4641 | 63 |
1055606 | 1055606 | 2021-02-22 | Jefferson | Ohio | 39081 | 4689 | 105 |
1055687 | 1055687 | 2021-02-22 | Jefferson | Oklahoma | 40067 | 670 | 8 |
1055747 | 1055747 | 2021-02-22 | Jefferson | Oregon | 41031 | 1925 | 27 |
1055800 | 1055800 | 2021-02-22 | Jefferson | Pennsylvania | 42065 | 2757 | 86 |
1056076 | 1056076 | 2021-02-22 | Jefferson | Tennessee | 47089 | 5557 | 116 |
1056250 | 1056250 | 2021-02-22 | Jefferson | Texas | 48245 | 17862 | 335 |
1056578 | 1056578 | 2021-02-22 | Jefferson | Washington | 53031 | 333 | 2 |
1056620 | 1056620 | 2021-02-22 | Jefferson | West Virginia | 54037 | 3579 | 37 |
1056684 | 1056684 | 2021-02-22 | Jefferson | Wisconsin | 55055 | 8774 | 84 |
1050295 | 1050295 | 2021-02-21 | Jefferson | Alabama | 1073 | 70177 | 1334 |
1050403 | 1050403 | 2021-02-21 | Jefferson | Arkansas | 5069 | 8522 | 164 |
1050533 | 1050533 | 2021-02-21 | Jefferson | Colorado | 8059 | 36523 | 706 |
1050612 | 1050612 | 2021-02-21 | Jefferson | Florida | 12065 | 1390 | 22 |
1050729 | 1050729 | 2021-02-21 | Jefferson | Georgia | 13163 | 1841 | 54 |
1050840 | 1050840 | 2021-02-21 | Jefferson | Idaho | 16051 | 2395 | 21 |
1050899 | 1050899 | 2021-02-21 | Jefferson | Illinois | 17081 | 3944 | 116 |
1051000 | 1051000 | 2021-02-21 | Jefferson | Indiana | 18077 | 2921 | 73 |
1051104 | 1051104 | 2021-02-21 | Jefferson | Iowa | 19101 | 1267 | 32 |
1051197 | 1051197 | 2021-02-21 | Jefferson | Kansas | 20087 | 1603 | 30 |
1051315 | 1051315 | 2021-02-21 | Jefferson | Kentucky | 21111 | 73060 | 886 |
1051405 | 1051405 | 2021-02-21 | Jefferson | Louisiana | 22051 | 43375 | 834 |
1051705 | 1051705 | 2021-02-21 | Jefferson | Mississippi | 28063 | 607 | 27 |
1051805 | 1051805 | 2021-02-21 | Jefferson | Missouri | 29099 | 21405 | 204 |
1051894 | 1051894 | 2021-02-21 | Jefferson | Montana | 30043 | 993 | 8 |
1051976 | 1051976 | 2021-02-21 | Jefferson | Nebraska | 31095 | 625 | 1 |
1052127 | 1052127 | 2021-02-21 | Jefferson | New York | 36045 | 4622 | 63 |
1052360 | 1052360 | 2021-02-21 | Jefferson | Ohio | 39081 | 4682 | 105 |
1052441 | 1052441 | 2021-02-21 | Jefferson | Oklahoma | 40067 | 670 | 8 |
1052501 | 1052501 | 2021-02-21 | Jefferson | Oregon | 41031 | 1921 | 27 |
1052554 | 1052554 | 2021-02-21 | Jefferson | Pennsylvania | 42065 | 2755 | 86 |
1052830 | 1052830 | 2021-02-21 | Jefferson | Tennessee | 47089 | 5546 | 115 |
1053004 | 1053004 | 2021-02-21 | Jefferson | Texas | 48245 | 17862 | 335 |
1053332 | 1053332 | 2021-02-21 | Jefferson | Washington | 53031 | 333 | 2 |
1053374 | 1053374 | 2021-02-21 | Jefferson | West Virginia | 54037 | 3575 | 37 |
1053438 | 1053438 | 2021-02-21 | Jefferson | Wisconsin | 55055 | 8770 | 84 |
1047048 | 1047048 | 2021-02-20 | Jefferson | Alabama | 1073 | 70078 | 1334 |
1047156 | 1047156 | 2021-02-20 | Jefferson | Arkansas | 5069 | 8514 | 163 |
1047286 | 1047286 | 2021-02-20 | Jefferson | Colorado | 8059 | 36435 | 705 |
1047365 | 1047365 | 2021-02-20 | Jefferson | Florida | 12065 | 1390 | 22 |
1047482 | 1047482 | 2021-02-20 | Jefferson | Georgia | 13163 | 1838 | 54 |
1047593 | 1047593 | 2021-02-20 | Jefferson | Idaho | 16051 | 2395 | 21 |
1047652 | 1047652 | 2021-02-20 | Jefferson | Illinois | 17081 | 3941 | 115 |
1047753 | 1047753 | 2021-02-20 | Jefferson | Indiana | 18077 | 2918 | 73 |
1047857 | 1047857 | 2021-02-20 | Jefferson | Iowa | 19101 | 1267 | 32 |
1047950 | 1047950 | 2021-02-20 | Jefferson | Kansas | 20087 | 1603 | 30 |
1048068 | 1048068 | 2021-02-20 | Jefferson | Kentucky | 21111 | 72916 | 884 |
1048158 | 1048158 | 2021-02-20 | Jefferson | Louisiana | 22051 | 43233 | 834 |
1048458 | 1048458 | 2021-02-20 | Jefferson | Mississippi | 28063 | 607 | 27 |
1048558 | 1048558 | 2021-02-20 | Jefferson | Missouri | 29099 | 21405 | 204 |
1048647 | 1048647 | 2021-02-20 | Jefferson | Montana | 30043 | 993 | 8 |
1048729 | 1048729 | 2021-02-20 | Jefferson | Nebraska | 31095 | 625 | 1 |
1048880 | 1048880 | 2021-02-20 | Jefferson | New York | 36045 | 4582 | 63 |
1049113 | 1049113 | 2021-02-20 | Jefferson | Ohio | 39081 | 4667 | 105 |
1049194 | 1049194 | 2021-02-20 | Jefferson | Oklahoma | 40067 | 668 | 8 |
1049254 | 1049254 | 2021-02-20 | Jefferson | Oregon | 41031 | 1918 | 27 |
1049307 | 1049307 | 2021-02-20 | Jefferson | Pennsylvania | 42065 | 2745 | 86 |
1049583 | 1049583 | 2021-02-20 | Jefferson | Tennessee | 47089 | 5534 | 115 |
1049757 | 1049757 | 2021-02-20 | Jefferson | Texas | 48245 | 17862 | 334 |
1050085 | 1050085 | 2021-02-20 | Jefferson | Washington | 53031 | 333 | 2 |
1050127 | 1050127 | 2021-02-20 | Jefferson | West Virginia | 54037 | 3561 | 37 |
1050191 | 1050191 | 2021-02-20 | Jefferson | Wisconsin | 55055 | 8759 | 84 |
1043803 | 1043803 | 2021-02-19 | Jefferson | Alabama | 1073 | 69995 | 1333 |
1043911 | 1043911 | 2021-02-19 | Jefferson | Arkansas | 5069 | 8503 | 163 |
1044041 | 1044041 | 2021-02-19 | Jefferson | Colorado | 8059 | 36348 | 702 |
1044120 | 1044120 | 2021-02-19 | Jefferson | Florida | 12065 | 1385 | 22 |
1044237 | 1044237 | 2021-02-19 | Jefferson | Georgia | 13163 | 1835 | 54 |
1044348 | 1044348 | 2021-02-19 | Jefferson | Idaho | 16051 | 2390 | 21 |
1044407 | 1044407 | 2021-02-19 | Jefferson | Illinois | 17081 | 3912 | 115 |
1044508 | 1044508 | 2021-02-19 | Jefferson | Indiana | 18077 | 2914 | 73 |
1044612 | 1044612 | 2021-02-19 | Jefferson | Iowa | 19101 | 1267 | 32 |
1044705 | 1044705 | 2021-02-19 | Jefferson | Kansas | 20087 | 1603 | 30 |
1044823 | 1044823 | 2021-02-19 | Jefferson | Kentucky | 21111 | 72692 | 883 |
1044913 | 1044913 | 2021-02-19 | Jefferson | Louisiana | 22051 | 43233 | 834 |
1045212 | 1045212 | 2021-02-19 | Jefferson | Mississippi | 28063 | 607 | 27 |
1045312 | 1045312 | 2021-02-19 | Jefferson | Missouri | 29099 | 21405 | 204 |
1045401 | 1045401 | 2021-02-19 | Jefferson | Montana | 30043 | 991 | 8 |
1045483 | 1045483 | 2021-02-19 | Jefferson | Nebraska | 31095 | 622 | 1 |
1045633 | 1045633 | 2021-02-19 | Jefferson | New York | 36045 | 4562 | 63 |
1045866 | 1045866 | 2021-02-19 | Jefferson | Ohio | 39081 | 4644 | 105 |
1045947 | 1045947 | 2021-02-19 | Jefferson | Oklahoma | 40067 | 668 | 8 |
1046007 | 1046007 | 2021-02-19 | Jefferson | Oregon | 41031 | 1917 | 27 |
1046060 | 1046060 | 2021-02-19 | Jefferson | Pennsylvania | 42065 | 2740 | 85 |
1046336 | 1046336 | 2021-02-19 | Jefferson | Tennessee | 47089 | 5516 | 115 |
1046510 | 1046510 | 2021-02-19 | Jefferson | Texas | 48245 | 17837 | 334 |
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);