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 322
- Washington 322
- Kentucky 319
- Louisiana 318
- Arkansas 316
- Alabama 314
- Tennessee 314
- West Virginia 311
- New York 309
- Wisconsin 308
- Texas 304
- Missouri 303
- Montana 303
- Idaho 302
- Kansas 301
- Ohio 301
- Mississippi 300
- Georgia 297
- Indiana 296
- Iowa 294
- Florida 292
- Illinois 290
- Oklahoma 290
- Pennsylvania 289
- Oregon 282
- Nebraska 270
fips 26
county 1
- Jefferson · 7,867 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
952390 | 952390 | 2021-01-21 | Jefferson | Texas | 48245 | 16348 | 275 |
952718 | 952718 | 2021-01-21 | Jefferson | Washington | 53031 | 277 | 2 |
952760 | 952760 | 2021-01-21 | Jefferson | West Virginia | 54037 | 3072 | 31 |
952824 | 952824 | 2021-01-21 | Jefferson | Wisconsin | 55055 | 8140 | 69 |
946437 | 946437 | 2021-01-20 | Jefferson | Alabama | 1073 | 63040 | 956 |
946545 | 946545 | 2021-01-20 | Jefferson | Arkansas | 5069 | 7585 | 143 |
946675 | 946675 | 2021-01-20 | Jefferson | Colorado | 8059 | 33216 | 671 |
946754 | 946754 | 2021-01-20 | Jefferson | Florida | 12065 | 1210 | 18 |
946871 | 946871 | 2021-01-20 | Jefferson | Georgia | 13163 | 1604 | 47 |
946982 | 946982 | 2021-01-20 | Jefferson | Idaho | 16051 | 2212 | 15 |
947041 | 947041 | 2021-01-20 | Jefferson | Illinois | 17081 | 3470 | 104 |
947141 | 947141 | 2021-01-20 | Jefferson | Indiana | 18077 | 2562 | 42 |
947245 | 947245 | 2021-01-20 | Jefferson | Iowa | 19101 | 1213 | 25 |
947338 | 947338 | 2021-01-20 | Jefferson | Kansas | 20087 | 1458 | 24 |
947456 | 947456 | 2021-01-20 | Jefferson | Kentucky | 21111 | 62534 | 752 |
947546 | 947546 | 2021-01-20 | Jefferson | Louisiana | 22051 | 38283 | 738 |
947846 | 947846 | 2021-01-20 | Jefferson | Mississippi | 28063 | 554 | 19 |
947946 | 947946 | 2021-01-20 | Jefferson | Missouri | 29099 | 19495 | 164 |
948035 | 948035 | 2021-01-20 | Jefferson | Montana | 30043 | 901 | 7 |
948117 | 948117 | 2021-01-20 | Jefferson | Nebraska | 31095 | 599 | 1 |
948268 | 948268 | 2021-01-20 | Jefferson | New York | 36045 | 3272 | 24 |
948501 | 948501 | 2021-01-20 | Jefferson | Ohio | 39081 | 4120 | 67 |
948582 | 948582 | 2021-01-20 | Jefferson | Oklahoma | 40067 | 588 | 4 |
948642 | 948642 | 2021-01-20 | Jefferson | Oregon | 41031 | 1712 | 25 |
948695 | 948695 | 2021-01-20 | Jefferson | Pennsylvania | 42065 | 2331 | 65 |
948971 | 948971 | 2021-01-20 | Jefferson | Tennessee | 47089 | 4838 | 76 |
949145 | 949145 | 2021-01-20 | Jefferson | Texas | 48245 | 16211 | 269 |
949473 | 949473 | 2021-01-20 | Jefferson | Washington | 53031 | 276 | 2 |
949515 | 949515 | 2021-01-20 | Jefferson | West Virginia | 54037 | 3059 | 31 |
949579 | 949579 | 2021-01-20 | Jefferson | Wisconsin | 55055 | 8100 | 69 |
943190 | 943190 | 2021-01-19 | Jefferson | Alabama | 1073 | 62752 | 920 |
943298 | 943298 | 2021-01-19 | Jefferson | Arkansas | 5069 | 7535 | 140 |
943428 | 943428 | 2021-01-19 | Jefferson | Colorado | 8059 | 33123 | 660 |
943507 | 943507 | 2021-01-19 | Jefferson | Florida | 12065 | 1199 | 18 |
943624 | 943624 | 2021-01-19 | Jefferson | Georgia | 13163 | 1595 | 46 |
943735 | 943735 | 2021-01-19 | Jefferson | Idaho | 16051 | 2207 | 15 |
943794 | 943794 | 2021-01-19 | Jefferson | Illinois | 17081 | 3435 | 104 |
943894 | 943894 | 2021-01-19 | Jefferson | Indiana | 18077 | 2542 | 42 |
943998 | 943998 | 2021-01-19 | Jefferson | Iowa | 19101 | 1207 | 24 |
944091 | 944091 | 2021-01-19 | Jefferson | Kansas | 20087 | 1447 | 24 |
944209 | 944209 | 2021-01-19 | Jefferson | Kentucky | 21111 | 62115 | 747 |
944299 | 944299 | 2021-01-19 | Jefferson | Louisiana | 22051 | 38037 | 737 |
944599 | 944599 | 2021-01-19 | Jefferson | Mississippi | 28063 | 549 | 19 |
944699 | 944699 | 2021-01-19 | Jefferson | Missouri | 29099 | 19352 | 153 |
944788 | 944788 | 2021-01-19 | Jefferson | Montana | 30043 | 891 | 7 |
944870 | 944870 | 2021-01-19 | Jefferson | Nebraska | 31095 | 590 | 1 |
945021 | 945021 | 2021-01-19 | Jefferson | New York | 36045 | 3214 | 23 |
945255 | 945255 | 2021-01-19 | Jefferson | Ohio | 39081 | 4090 | 66 |
945336 | 945336 | 2021-01-19 | Jefferson | Oklahoma | 40067 | 583 | 4 |
945396 | 945396 | 2021-01-19 | Jefferson | Oregon | 41031 | 1707 | 25 |
945449 | 945449 | 2021-01-19 | Jefferson | Pennsylvania | 42065 | 2312 | 63 |
945725 | 945725 | 2021-01-19 | Jefferson | Tennessee | 47089 | 4808 | 75 |
945899 | 945899 | 2021-01-19 | Jefferson | Texas | 48245 | 15937 | 263 |
946227 | 946227 | 2021-01-19 | Jefferson | Washington | 53031 | 273 | 2 |
946269 | 946269 | 2021-01-19 | Jefferson | West Virginia | 54037 | 3044 | 31 |
946333 | 946333 | 2021-01-19 | Jefferson | Wisconsin | 55055 | 8071 | 69 |
939945 | 939945 | 2021-01-18 | Jefferson | Alabama | 1073 | 62258 | 921 |
940053 | 940053 | 2021-01-18 | Jefferson | Arkansas | 5069 | 7493 | 139 |
940183 | 940183 | 2021-01-18 | Jefferson | Colorado | 8059 | 32952 | 661 |
940262 | 940262 | 2021-01-18 | Jefferson | Florida | 12065 | 1193 | 18 |
940379 | 940379 | 2021-01-18 | Jefferson | Georgia | 13163 | 1586 | 44 |
940490 | 940490 | 2021-01-18 | Jefferson | Idaho | 16051 | 2196 | 15 |
940549 | 940549 | 2021-01-18 | Jefferson | Illinois | 17081 | 3421 | 104 |
940649 | 940649 | 2021-01-18 | Jefferson | Indiana | 18077 | 2535 | 42 |
940753 | 940753 | 2021-01-18 | Jefferson | Iowa | 19101 | 1201 | 24 |
940846 | 940846 | 2021-01-18 | Jefferson | Kansas | 20087 | 1447 | 24 |
940964 | 940964 | 2021-01-18 | Jefferson | Kentucky | 21111 | 61778 | 746 |
941054 | 941054 | 2021-01-18 | Jefferson | Louisiana | 22051 | 37813 | 734 |
941354 | 941354 | 2021-01-18 | Jefferson | Mississippi | 28063 | 543 | 19 |
941454 | 941454 | 2021-01-18 | Jefferson | Missouri | 29099 | 19041 | 153 |
941543 | 941543 | 2021-01-18 | Jefferson | Montana | 30043 | 891 | 7 |
941625 | 941625 | 2021-01-18 | Jefferson | Nebraska | 31095 | 590 | 1 |
941775 | 941775 | 2021-01-18 | Jefferson | New York | 36045 | 3145 | 22 |
942008 | 942008 | 2021-01-18 | Jefferson | Ohio | 39081 | 4045 | 66 |
942089 | 942089 | 2021-01-18 | Jefferson | Oklahoma | 40067 | 582 | 4 |
942149 | 942149 | 2021-01-18 | Jefferson | Oregon | 41031 | 1705 | 25 |
942202 | 942202 | 2021-01-18 | Jefferson | Pennsylvania | 42065 | 2294 | 62 |
942478 | 942478 | 2021-01-18 | Jefferson | Tennessee | 47089 | 4779 | 75 |
942652 | 942652 | 2021-01-18 | Jefferson | Texas | 48245 | 15897 | 261 |
942980 | 942980 | 2021-01-18 | Jefferson | Washington | 53031 | 273 | 2 |
943022 | 943022 | 2021-01-18 | Jefferson | West Virginia | 54037 | 3019 | 29 |
943086 | 943086 | 2021-01-18 | Jefferson | Wisconsin | 55055 | 8041 | 68 |
936700 | 936700 | 2021-01-17 | Jefferson | Alabama | 1073 | 62039 | 921 |
936808 | 936808 | 2021-01-17 | Jefferson | Arkansas | 5069 | 7440 | 139 |
936938 | 936938 | 2021-01-17 | Jefferson | Colorado | 8059 | 32832 | 660 |
937017 | 937017 | 2021-01-17 | Jefferson | Florida | 12065 | 1191 | 18 |
937134 | 937134 | 2021-01-17 | Jefferson | Georgia | 13163 | 1570 | 44 |
937245 | 937245 | 2021-01-17 | Jefferson | Idaho | 16051 | 2196 | 15 |
937304 | 937304 | 2021-01-17 | Jefferson | Illinois | 17081 | 3409 | 104 |
937404 | 937404 | 2021-01-17 | Jefferson | Indiana | 18077 | 2511 | 42 |
937508 | 937508 | 2021-01-17 | Jefferson | Iowa | 19101 | 1195 | 24 |
937601 | 937601 | 2021-01-17 | Jefferson | Kansas | 20087 | 1425 | 24 |
937719 | 937719 | 2021-01-17 | Jefferson | Kentucky | 21111 | 61424 | 746 |
937809 | 937809 | 2021-01-17 | Jefferson | Louisiana | 22051 | 37684 | 733 |
938109 | 938109 | 2021-01-17 | Jefferson | Mississippi | 28063 | 538 | 19 |
938209 | 938209 | 2021-01-17 | Jefferson | Missouri | 29099 | 19041 | 154 |
938298 | 938298 | 2021-01-17 | Jefferson | Montana | 30043 | 883 | 7 |
938380 | 938380 | 2021-01-17 | Jefferson | Nebraska | 31095 | 588 | 1 |
938530 | 938530 | 2021-01-17 | Jefferson | New York | 36045 | 3094 | 21 |
938763 | 938763 | 2021-01-17 | Jefferson | Ohio | 39081 | 4033 | 66 |
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);