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 318
- Washington 318
- Kentucky 315
- Louisiana 314
- Arkansas 312
- Tennessee 311
- Alabama 310
- West Virginia 307
- New York 305
- Wisconsin 304
- Texas 300
- Missouri 299
- Montana 299
- Idaho 298
- Kansas 297
- Ohio 297
- Mississippi 296
- Georgia 293
- Indiana 292
- Iowa 290
- Florida 288
- Oklahoma 287
- Illinois 286
- Pennsylvania 286
- Oregon 279
- Nebraska 266
fips 26
county 1
- Jefferson · 7,767 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
938844 | 938844 | 2021-01-17 | Jefferson | Oklahoma | 40067 | 581 | 4 |
938904 | 938904 | 2021-01-17 | Jefferson | Oregon | 41031 | 1702 | 25 |
938957 | 938957 | 2021-01-17 | Jefferson | Pennsylvania | 42065 | 2272 | 61 |
939233 | 939233 | 2021-01-17 | Jefferson | Tennessee | 47089 | 4749 | 75 |
939407 | 939407 | 2021-01-17 | Jefferson | Texas | 48245 | 15897 | 261 |
939735 | 939735 | 2021-01-17 | Jefferson | Washington | 53031 | 273 | 2 |
939777 | 939777 | 2021-01-17 | Jefferson | West Virginia | 54037 | 2981 | 29 |
939841 | 939841 | 2021-01-17 | Jefferson | Wisconsin | 55055 | 7996 | 68 |
933455 | 933455 | 2021-01-16 | Jefferson | Alabama | 1073 | 61755 | 921 |
933563 | 933563 | 2021-01-16 | Jefferson | Arkansas | 5069 | 7428 | 139 |
933693 | 933693 | 2021-01-16 | Jefferson | Colorado | 8059 | 32728 | 659 |
933772 | 933772 | 2021-01-16 | Jefferson | Florida | 12065 | 1176 | 18 |
933889 | 933889 | 2021-01-16 | Jefferson | Georgia | 13163 | 1554 | 44 |
934000 | 934000 | 2021-01-16 | Jefferson | Idaho | 16051 | 2196 | 15 |
934059 | 934059 | 2021-01-16 | Jefferson | Illinois | 17081 | 3392 | 104 |
934159 | 934159 | 2021-01-16 | Jefferson | Indiana | 18077 | 2489 | 42 |
934263 | 934263 | 2021-01-16 | Jefferson | Iowa | 19101 | 1195 | 24 |
934356 | 934356 | 2021-01-16 | Jefferson | Kansas | 20087 | 1425 | 24 |
934474 | 934474 | 2021-01-16 | Jefferson | Kentucky | 21111 | 61065 | 745 |
934564 | 934564 | 2021-01-16 | Jefferson | Louisiana | 22051 | 37200 | 715 |
934864 | 934864 | 2021-01-16 | Jefferson | Mississippi | 28063 | 534 | 19 |
934964 | 934964 | 2021-01-16 | Jefferson | Missouri | 29099 | 19041 | 154 |
935053 | 935053 | 2021-01-16 | Jefferson | Montana | 30043 | 882 | 7 |
935135 | 935135 | 2021-01-16 | Jefferson | Nebraska | 31095 | 587 | 1 |
935285 | 935285 | 2021-01-16 | Jefferson | New York | 36045 | 3031 | 21 |
935518 | 935518 | 2021-01-16 | Jefferson | Ohio | 39081 | 4004 | 66 |
935599 | 935599 | 2021-01-16 | Jefferson | Oklahoma | 40067 | 572 | 4 |
935659 | 935659 | 2021-01-16 | Jefferson | Oregon | 41031 | 1687 | 25 |
935712 | 935712 | 2021-01-16 | Jefferson | Pennsylvania | 42065 | 2261 | 60 |
935988 | 935988 | 2021-01-16 | Jefferson | Tennessee | 47089 | 4705 | 75 |
936162 | 936162 | 2021-01-16 | Jefferson | Texas | 48245 | 15872 | 259 |
936490 | 936490 | 2021-01-16 | Jefferson | Washington | 53031 | 267 | 2 |
936532 | 936532 | 2021-01-16 | Jefferson | West Virginia | 54037 | 2964 | 29 |
936596 | 936596 | 2021-01-16 | Jefferson | Wisconsin | 55055 | 7985 | 68 |
930210 | 930210 | 2021-01-15 | Jefferson | Alabama | 1073 | 61313 | 888 |
930318 | 930318 | 2021-01-15 | Jefferson | Arkansas | 5069 | 7377 | 137 |
930448 | 930448 | 2021-01-15 | Jefferson | Colorado | 8059 | 32613 | 660 |
930527 | 930527 | 2021-01-15 | Jefferson | Florida | 12065 | 1170 | 18 |
930644 | 930644 | 2021-01-15 | Jefferson | Georgia | 13163 | 1535 | 41 |
930755 | 930755 | 2021-01-15 | Jefferson | Idaho | 16051 | 2189 | 15 |
930814 | 930814 | 2021-01-15 | Jefferson | Illinois | 17081 | 3356 | 102 |
930914 | 930914 | 2021-01-15 | Jefferson | Indiana | 18077 | 2451 | 42 |
931018 | 931018 | 2021-01-15 | Jefferson | Iowa | 19101 | 1191 | 23 |
931111 | 931111 | 2021-01-15 | Jefferson | Kansas | 20087 | 1425 | 24 |
931229 | 931229 | 2021-01-15 | Jefferson | Kentucky | 21111 | 60457 | 740 |
931319 | 931319 | 2021-01-15 | Jefferson | Louisiana | 22051 | 37200 | 715 |
931619 | 931619 | 2021-01-15 | Jefferson | Mississippi | 28063 | 530 | 19 |
931719 | 931719 | 2021-01-15 | Jefferson | Missouri | 29099 | 19041 | 154 |
931808 | 931808 | 2021-01-15 | Jefferson | Montana | 30043 | 871 | 7 |
931890 | 931890 | 2021-01-15 | Jefferson | Nebraska | 31095 | 587 | 1 |
932040 | 932040 | 2021-01-15 | Jefferson | New York | 36045 | 2942 | 20 |
932273 | 932273 | 2021-01-15 | Jefferson | Ohio | 39081 | 3948 | 65 |
932354 | 932354 | 2021-01-15 | Jefferson | Oklahoma | 40067 | 564 | 4 |
932414 | 932414 | 2021-01-15 | Jefferson | Oregon | 41031 | 1675 | 25 |
932467 | 932467 | 2021-01-15 | Jefferson | Pennsylvania | 42065 | 2228 | 58 |
932743 | 932743 | 2021-01-15 | Jefferson | Tennessee | 47089 | 4649 | 75 |
932917 | 932917 | 2021-01-15 | Jefferson | Texas | 48245 | 15788 | 257 |
933245 | 933245 | 2021-01-15 | Jefferson | Washington | 53031 | 267 | 2 |
933287 | 933287 | 2021-01-15 | Jefferson | West Virginia | 54037 | 2937 | 29 |
933351 | 933351 | 2021-01-15 | Jefferson | Wisconsin | 55055 | 7947 | 67 |
926965 | 926965 | 2021-01-14 | Jefferson | Alabama | 1073 | 60842 | 887 |
927073 | 927073 | 2021-01-14 | Jefferson | Arkansas | 5069 | 7311 | 137 |
927203 | 927203 | 2021-01-14 | Jefferson | Colorado | 8059 | 32441 | 658 |
927282 | 927282 | 2021-01-14 | Jefferson | Florida | 12065 | 1160 | 18 |
927399 | 927399 | 2021-01-14 | Jefferson | Georgia | 13163 | 1521 | 41 |
927510 | 927510 | 2021-01-14 | Jefferson | Idaho | 16051 | 2185 | 15 |
927569 | 927569 | 2021-01-14 | Jefferson | Illinois | 17081 | 3329 | 100 |
927669 | 927669 | 2021-01-14 | Jefferson | Indiana | 18077 | 2431 | 42 |
927773 | 927773 | 2021-01-14 | Jefferson | Iowa | 19101 | 1186 | 23 |
927866 | 927866 | 2021-01-14 | Jefferson | Kansas | 20087 | 1394 | 23 |
927984 | 927984 | 2021-01-14 | Jefferson | Kentucky | 21111 | 59780 | 732 |
928074 | 928074 | 2021-01-14 | Jefferson | Louisiana | 22051 | 36677 | 715 |
928374 | 928374 | 2021-01-14 | Jefferson | Mississippi | 28063 | 520 | 19 |
928474 | 928474 | 2021-01-14 | Jefferson | Missouri | 29099 | 18952 | 153 |
928563 | 928563 | 2021-01-14 | Jefferson | Montana | 30043 | 866 | 7 |
928645 | 928645 | 2021-01-14 | Jefferson | Nebraska | 31095 | 585 | 1 |
928795 | 928795 | 2021-01-14 | Jefferson | New York | 36045 | 2841 | 19 |
929028 | 929028 | 2021-01-14 | Jefferson | Ohio | 39081 | 3915 | 65 |
929109 | 929109 | 2021-01-14 | Jefferson | Oklahoma | 40067 | 563 | 4 |
929169 | 929169 | 2021-01-14 | Jefferson | Oregon | 41031 | 1661 | 25 |
929222 | 929222 | 2021-01-14 | Jefferson | Pennsylvania | 42065 | 2206 | 57 |
929498 | 929498 | 2021-01-14 | Jefferson | Tennessee | 47089 | 4609 | 75 |
929672 | 929672 | 2021-01-14 | Jefferson | Texas | 48245 | 15642 | 255 |
930000 | 930000 | 2021-01-14 | Jefferson | Washington | 53031 | 261 | 2 |
930042 | 930042 | 2021-01-14 | Jefferson | West Virginia | 54037 | 2893 | 29 |
930106 | 930106 | 2021-01-14 | Jefferson | Wisconsin | 55055 | 7905 | 66 |
923719 | 923719 | 2021-01-13 | Jefferson | Alabama | 1073 | 60269 | 872 |
923827 | 923827 | 2021-01-13 | Jefferson | Arkansas | 5069 | 7283 | 136 |
923957 | 923957 | 2021-01-13 | Jefferson | Colorado | 8059 | 32191 | 655 |
924036 | 924036 | 2021-01-13 | Jefferson | Florida | 12065 | 1151 | 18 |
924153 | 924153 | 2021-01-13 | Jefferson | Georgia | 13163 | 1510 | 41 |
924264 | 924264 | 2021-01-13 | Jefferson | Idaho | 16051 | 2176 | 15 |
924323 | 924323 | 2021-01-13 | Jefferson | Illinois | 17081 | 3303 | 99 |
924423 | 924423 | 2021-01-13 | Jefferson | Indiana | 18077 | 2410 | 42 |
924527 | 924527 | 2021-01-13 | Jefferson | Iowa | 19101 | 1183 | 23 |
924620 | 924620 | 2021-01-13 | Jefferson | Kansas | 20087 | 1394 | 23 |
924738 | 924738 | 2021-01-13 | Jefferson | Kentucky | 21111 | 59234 | 729 |
924828 | 924828 | 2021-01-13 | Jefferson | Louisiana | 22051 | 36149 | 712 |
925128 | 925128 | 2021-01-13 | Jefferson | Mississippi | 28063 | 514 | 19 |
925228 | 925228 | 2021-01-13 | Jefferson | Missouri | 29099 | 18737 | 153 |
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);