⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

7,967 rows where county = "Jefferson" sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

county

  • Jefferson · 7,967
Link rowid date ▲ county state fips cases deaths
959499 2021-01-24 Jefferson Alabama 1073 64681 1007
959607 2021-01-24 Jefferson Arkansas 5069 7742 144
959737 2021-01-24 Jefferson Colorado 8059 33760 676
959816 2021-01-24 Jefferson Florida 12065 1247 19
959933 2021-01-24 Jefferson Georgia 13163 1664 48
960044 2021-01-24 Jefferson Idaho 16051 2234 18
960103 2021-01-24 Jefferson Illinois 17081 3557 105
960203 2021-01-24 Jefferson Indiana 18077 2651 42
960307 2021-01-24 Jefferson Iowa 19101 1221 25
960400 2021-01-24 Jefferson Kansas 20087 1482 24
960518 2021-01-24 Jefferson Kentucky 21111 64386 773
960608 2021-01-24 Jefferson Louisiana 22051 39268 766
960908 2021-01-24 Jefferson Mississippi 28063 568 21
961008 2021-01-24 Jefferson Missouri 29099 19784 165
961097 2021-01-24 Jefferson Montana 30043 918 7
961179 2021-01-24 Jefferson Nebraska 31095 607 1
961329 2021-01-24 Jefferson New York 36045 3562 30
961562 2021-01-24 Jefferson Ohio 39081 4205 69
961643 2021-01-24 Jefferson Oklahoma 40067 611 7
961703 2021-01-24 Jefferson Oregon 41031 1738 25
961756 2021-01-24 Jefferson Pennsylvania 42065 2415 69
962032 2021-01-24 Jefferson Tennessee 47089 4960 78
962206 2021-01-24 Jefferson Texas 48245 16406 285
962534 2021-01-24 Jefferson Washington 53031 281 2
962576 2021-01-24 Jefferson West Virginia 54037 3170 31
962640 2021-01-24 Jefferson Wisconsin 55055 8233 71
956253 2021-01-23 Jefferson Alabama 1073 64437 1007
956361 2021-01-23 Jefferson Arkansas 5069 7708 143
956491 2021-01-23 Jefferson Colorado 8059 33640 675
956570 2021-01-23 Jefferson Florida 12065 1241 19
956687 2021-01-23 Jefferson Georgia 13163 1658 48
956798 2021-01-23 Jefferson Idaho 16051 2232 18
956857 2021-01-23 Jefferson Illinois 17081 3545 104
956957 2021-01-23 Jefferson Indiana 18077 2637 42
957061 2021-01-23 Jefferson Iowa 19101 1221 25
957154 2021-01-23 Jefferson Kansas 20087 1482 24
957272 2021-01-23 Jefferson Kentucky 21111 64311 770
957362 2021-01-23 Jefferson Louisiana 22051 38873 743
957662 2021-01-23 Jefferson Mississippi 28063 568 21
957762 2021-01-23 Jefferson Missouri 29099 19784 165
957851 2021-01-23 Jefferson Montana 30043 918 7
957933 2021-01-23 Jefferson Nebraska 31095 605 1
958084 2021-01-23 Jefferson New York 36045 3476 29
958317 2021-01-23 Jefferson Ohio 39081 4192 69
958398 2021-01-23 Jefferson Oklahoma 40067 605 6
958458 2021-01-23 Jefferson Oregon 41031 1734 25
958511 2021-01-23 Jefferson Pennsylvania 42065 2398 69
958787 2021-01-23 Jefferson Tennessee 47089 4933 78
958961 2021-01-23 Jefferson Texas 48245 16376 280
959289 2021-01-23 Jefferson Washington 53031 281 2
959331 2021-01-23 Jefferson West Virginia 54037 3139 31
959395 2021-01-23 Jefferson Wisconsin 55055 8209 71
953008 2021-01-22 Jefferson Alabama 1073 63969 994
953116 2021-01-22 Jefferson Arkansas 5069 7681 143
953246 2021-01-22 Jefferson Colorado 8059 33489 676
953325 2021-01-22 Jefferson Florida 12065 1233 18
953442 2021-01-22 Jefferson Georgia 13163 1652 47
953553 2021-01-22 Jefferson Idaho 16051 2228 18
953612 2021-01-22 Jefferson Illinois 17081 3521 104
953712 2021-01-22 Jefferson Indiana 18077 2629 42
953816 2021-01-22 Jefferson Iowa 19101 1220 25
953909 2021-01-22 Jefferson Kansas 20087 1482 24
954027 2021-01-22 Jefferson Kentucky 21111 63750 758
954117 2021-01-22 Jefferson Louisiana 22051 38873 743
954417 2021-01-22 Jefferson Mississippi 28063 565 20
954517 2021-01-22 Jefferson Missouri 29099 19784 165
954606 2021-01-22 Jefferson Montana 30043 916 7
954688 2021-01-22 Jefferson Nebraska 31095 604 1
954838 2021-01-22 Jefferson New York 36045 3388 27
955071 2021-01-22 Jefferson Ohio 39081 4167 69
955152 2021-01-22 Jefferson Oklahoma 40067 601 6
955212 2021-01-22 Jefferson Oregon 41031 1727 25
955265 2021-01-22 Jefferson Pennsylvania 42065 2377 69
955541 2021-01-22 Jefferson Tennessee 47089 4901 78
955715 2021-01-22 Jefferson Texas 48245 16393 279
956043 2021-01-22 Jefferson Washington 53031 279 2
956085 2021-01-22 Jefferson West Virginia 54037 3112 31
956149 2021-01-22 Jefferson Wisconsin 55055 8170 69
949763 2021-01-21 Jefferson Alabama 1073 63523 957
949871 2021-01-21 Jefferson Arkansas 5069 7630 143
950001 2021-01-21 Jefferson Colorado 8059 33321 672
950080 2021-01-21 Jefferson Florida 12065 1220 18
950197 2021-01-21 Jefferson Georgia 13163 1639 47
950308 2021-01-21 Jefferson Idaho 16051 2223 16
950367 2021-01-21 Jefferson Illinois 17081 3493 104
950467 2021-01-21 Jefferson Indiana 18077 2583 42
950571 2021-01-21 Jefferson Iowa 19101 1216 25
950664 2021-01-21 Jefferson Kansas 20087 1458 24
950782 2021-01-21 Jefferson Kentucky 21111 63192 754
950872 2021-01-21 Jefferson Louisiana 22051 38677 742
951172 2021-01-21 Jefferson Mississippi 28063 559 20
951272 2021-01-21 Jefferson Missouri 29099 19592 165
951361 2021-01-21 Jefferson Montana 30043 907 7
951443 2021-01-21 Jefferson Nebraska 31095 603 1
951593 2021-01-21 Jefferson New York 36045 3331 25
951826 2021-01-21 Jefferson Ohio 39081 4154 69
951907 2021-01-21 Jefferson Oklahoma 40067 592 6
951967 2021-01-21 Jefferson Oregon 41031 1718 25
952020 2021-01-21 Jefferson Pennsylvania 42065 2359 66
952296 2021-01-21 Jefferson Tennessee 47089 4871 78

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);