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 226
- Washington 225
- Kentucky 223
- Louisiana 222
- Arkansas 219
- Tennessee 218
- Alabama 217
- West Virginia 214
- New York 213
- Wisconsin 211
- Missouri 207
- Montana 207
- Texas 207
- Idaho 206
- Kansas 205
- Ohio 205
- Mississippi 204
- Georgia 201
- Indiana 200
- Iowa 198
- Florida 196
- Illinois 194
- Oklahoma 194
- Pennsylvania 193
- Oregon 186
- Nebraska 174
fips 26
county 1
- Jefferson · 5,365 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635159 | 635159 | 2020-10-16 | Jefferson | Colorado | 8059 | 6991 | 298 |
635238 | 635238 | 2020-10-16 | Jefferson | Florida | 12065 | 611 | 9 |
635355 | 635355 | 2020-10-16 | Jefferson | Georgia | 13163 | 865 | 32 |
635465 | 635465 | 2020-10-16 | Jefferson | Idaho | 16051 | 828 | 3 |
635524 | 635524 | 2020-10-16 | Jefferson | Illinois | 17081 | 840 | 43 |
635625 | 635625 | 2020-10-16 | Jefferson | Indiana | 18077 | 322 | 4 |
635729 | 635729 | 2020-10-16 | Jefferson | Iowa | 19101 | 185 | 1 |
635822 | 635822 | 2020-10-16 | Jefferson | Kansas | 20087 | 248 | 4 |
635940 | 635940 | 2020-10-16 | Jefferson | Kentucky | 21111 | 20559 | 344 |
636030 | 636030 | 2020-10-16 | Jefferson | Louisiana | 22051 | 18252 | 580 |
636330 | 636330 | 2020-10-16 | Jefferson | Mississippi | 28063 | 259 | 10 |
636430 | 636430 | 2020-10-16 | Jefferson | Missouri | 29099 | 5474 | 69 |
636519 | 636519 | 2020-10-16 | Jefferson | Montana | 30043 | 119 | 0 |
636601 | 636601 | 2020-10-16 | Jefferson | Nebraska | 31095 | 62 | 0 |
636751 | 636751 | 2020-10-16 | Jefferson | New York | 36045 | 186 | 1 |
636984 | 636984 | 2020-10-16 | Jefferson | Ohio | 39081 | 432 | 4 |
637065 | 637065 | 2020-10-16 | Jefferson | Oklahoma | 40067 | 65 | 0 |
637125 | 637125 | 2020-10-16 | Jefferson | Oregon | 41031 | 593 | 9 |
637178 | 637178 | 2020-10-16 | Jefferson | Pennsylvania | 42065 | 143 | 3 |
637454 | 637454 | 2020-10-16 | Jefferson | Tennessee | 47089 | 1407 | 18 |
637627 | 637627 | 2020-10-16 | Jefferson | Texas | 48245 | 7980 | 145 |
637954 | 637954 | 2020-10-16 | Jefferson | Washington | 53031 | 80 | 0 |
637997 | 637997 | 2020-10-16 | Jefferson | West Virginia | 54037 | 513 | 4 |
638061 | 638061 | 2020-10-16 | Jefferson | Wisconsin | 55055 | 2209 | 9 |
631676 | 631676 | 2020-10-15 | Jefferson | Alabama | 1073 | 21897 | 364 |
631783 | 631783 | 2020-10-15 | Jefferson | Arkansas | 5069 | 3896 | 97 |
631913 | 631913 | 2020-10-15 | Jefferson | Colorado | 8059 | 6887 | 296 |
631992 | 631992 | 2020-10-15 | Jefferson | Florida | 12065 | 608 | 9 |
632109 | 632109 | 2020-10-15 | Jefferson | Georgia | 13163 | 863 | 31 |
632219 | 632219 | 2020-10-15 | Jefferson | Idaho | 16051 | 813 | 3 |
632278 | 632278 | 2020-10-15 | Jefferson | Illinois | 17081 | 834 | 41 |
632379 | 632379 | 2020-10-15 | Jefferson | Indiana | 18077 | 317 | 4 |
632483 | 632483 | 2020-10-15 | Jefferson | Iowa | 19101 | 183 | 1 |
632576 | 632576 | 2020-10-15 | Jefferson | Kansas | 20087 | 247 | 4 |
632694 | 632694 | 2020-10-15 | Jefferson | Kentucky | 21111 | 20303 | 342 |
632784 | 632784 | 2020-10-15 | Jefferson | Louisiana | 22051 | 18182 | 578 |
633084 | 633084 | 2020-10-15 | Jefferson | Mississippi | 28063 | 256 | 10 |
633184 | 633184 | 2020-10-15 | Jefferson | Missouri | 29099 | 5390 | 69 |
633273 | 633273 | 2020-10-15 | Jefferson | Montana | 30043 | 117 | 0 |
633355 | 633355 | 2020-10-15 | Jefferson | Nebraska | 31095 | 55 | 0 |
633505 | 633505 | 2020-10-15 | Jefferson | New York | 36045 | 186 | 1 |
633738 | 633738 | 2020-10-15 | Jefferson | Ohio | 39081 | 428 | 4 |
633819 | 633819 | 2020-10-15 | Jefferson | Oklahoma | 40067 | 63 | 0 |
633879 | 633879 | 2020-10-15 | Jefferson | Oregon | 41031 | 590 | 8 |
633932 | 633932 | 2020-10-15 | Jefferson | Pennsylvania | 42065 | 141 | 3 |
634208 | 634208 | 2020-10-15 | Jefferson | Tennessee | 47089 | 1393 | 18 |
634382 | 634382 | 2020-10-15 | Jefferson | Texas | 48245 | 7950 | 144 |
634709 | 634709 | 2020-10-15 | Jefferson | Washington | 53031 | 80 | 0 |
634752 | 634752 | 2020-10-15 | Jefferson | West Virginia | 54037 | 495 | 4 |
634816 | 634816 | 2020-10-15 | Jefferson | Wisconsin | 55055 | 2190 | 9 |
628432 | 628432 | 2020-10-14 | Jefferson | Alabama | 1073 | 21746 | 362 |
628539 | 628539 | 2020-10-14 | Jefferson | Arkansas | 5069 | 3863 | 97 |
628669 | 628669 | 2020-10-14 | Jefferson | Colorado | 8059 | 6806 | 296 |
628748 | 628748 | 2020-10-14 | Jefferson | Florida | 12065 | 603 | 9 |
628865 | 628865 | 2020-10-14 | Jefferson | Georgia | 13163 | 861 | 31 |
628975 | 628975 | 2020-10-14 | Jefferson | Idaho | 16051 | 802 | 3 |
629034 | 629034 | 2020-10-14 | Jefferson | Illinois | 17081 | 804 | 40 |
629135 | 629135 | 2020-10-14 | Jefferson | Indiana | 18077 | 315 | 4 |
629239 | 629239 | 2020-10-14 | Jefferson | Iowa | 19101 | 179 | 1 |
629332 | 629332 | 2020-10-14 | Jefferson | Kansas | 20087 | 238 | 4 |
629450 | 629450 | 2020-10-14 | Jefferson | Kentucky | 21111 | 20044 | 339 |
629540 | 629540 | 2020-10-14 | Jefferson | Louisiana | 22051 | 18116 | 578 |
629839 | 629839 | 2020-10-14 | Jefferson | Mississippi | 28063 | 255 | 10 |
629939 | 629939 | 2020-10-14 | Jefferson | Missouri | 29099 | 5339 | 71 |
630028 | 630028 | 2020-10-14 | Jefferson | Montana | 30043 | 112 | 0 |
630110 | 630110 | 2020-10-14 | Jefferson | Nebraska | 31095 | 46 | 0 |
630260 | 630260 | 2020-10-14 | Jefferson | New York | 36045 | 186 | 1 |
630493 | 630493 | 2020-10-14 | Jefferson | Ohio | 39081 | 412 | 4 |
630574 | 630574 | 2020-10-14 | Jefferson | Oklahoma | 40067 | 63 | 0 |
630634 | 630634 | 2020-10-14 | Jefferson | Oregon | 41031 | 591 | 8 |
630687 | 630687 | 2020-10-14 | Jefferson | Pennsylvania | 42065 | 138 | 3 |
630963 | 630963 | 2020-10-14 | Jefferson | Tennessee | 47089 | 1380 | 17 |
631137 | 631137 | 2020-10-14 | Jefferson | Texas | 48245 | 7871 | 144 |
631464 | 631464 | 2020-10-14 | Jefferson | Washington | 53031 | 80 | 0 |
631507 | 631507 | 2020-10-14 | Jefferson | West Virginia | 54037 | 488 | 4 |
631571 | 631571 | 2020-10-14 | Jefferson | Wisconsin | 55055 | 2128 | 9 |
625189 | 625189 | 2020-10-13 | Jefferson | Alabama | 1073 | 21652 | 362 |
625296 | 625296 | 2020-10-13 | Jefferson | Arkansas | 5069 | 3802 | 95 |
625426 | 625426 | 2020-10-13 | Jefferson | Colorado | 8059 | 6754 | 295 |
625505 | 625505 | 2020-10-13 | Jefferson | Florida | 12065 | 602 | 9 |
625622 | 625622 | 2020-10-13 | Jefferson | Georgia | 13163 | 861 | 31 |
625732 | 625732 | 2020-10-13 | Jefferson | Idaho | 16051 | 790 | 3 |
625791 | 625791 | 2020-10-13 | Jefferson | Illinois | 17081 | 796 | 39 |
625892 | 625892 | 2020-10-13 | Jefferson | Indiana | 18077 | 309 | 4 |
625996 | 625996 | 2020-10-13 | Jefferson | Iowa | 19101 | 177 | 1 |
626089 | 626089 | 2020-10-13 | Jefferson | Kansas | 20087 | 236 | 4 |
626206 | 626206 | 2020-10-13 | Jefferson | Kentucky | 21111 | 19795 | 338 |
626296 | 626296 | 2020-10-13 | Jefferson | Louisiana | 22051 | 18118 | 578 |
626595 | 626595 | 2020-10-13 | Jefferson | Mississippi | 28063 | 255 | 10 |
626695 | 626695 | 2020-10-13 | Jefferson | Missouri | 29099 | 5245 | 69 |
626784 | 626784 | 2020-10-13 | Jefferson | Montana | 30043 | 111 | 0 |
626866 | 626866 | 2020-10-13 | Jefferson | Nebraska | 31095 | 43 | 0 |
627016 | 627016 | 2020-10-13 | Jefferson | New York | 36045 | 186 | 1 |
627249 | 627249 | 2020-10-13 | Jefferson | Ohio | 39081 | 406 | 4 |
627330 | 627330 | 2020-10-13 | Jefferson | Oklahoma | 40067 | 62 | 0 |
627390 | 627390 | 2020-10-13 | Jefferson | Oregon | 41031 | 590 | 8 |
627443 | 627443 | 2020-10-13 | Jefferson | Pennsylvania | 42065 | 138 | 3 |
627719 | 627719 | 2020-10-13 | Jefferson | Tennessee | 47089 | 1368 | 17 |
627893 | 627893 | 2020-10-13 | Jefferson | Texas | 48245 | 7855 | 144 |
628220 | 628220 | 2020-10-13 | Jefferson | Washington | 53031 | 79 | 0 |
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);