⚠️ 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

8,955 rows where county = "Jefferson" sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

county

  • Jefferson · 8,955
Link rowid date ▲ county state fips cases deaths
1082752 2021-03-03 Jefferson Alabama 1073 71400 1387
1082860 2021-03-03 Jefferson Arkansas 5069 8628 160
1082990 2021-03-03 Jefferson Colorado 8059 37452 727
1083069 2021-03-03 Jefferson Florida 12065 1407 24
1083186 2021-03-03 Jefferson Georgia 13163 1868 59
1083297 2021-03-03 Jefferson Idaho 16051 2474 22
1083356 2021-03-03 Jefferson Illinois 17081 3991 117
1083457 2021-03-03 Jefferson Indiana 18077 2954 74
1083561 2021-03-03 Jefferson Iowa 19101 1267 34
1083654 2021-03-03 Jefferson Kansas 20087 1620 32
1083772 2021-03-03 Jefferson Kentucky 21111 74543 928
1083862 2021-03-03 Jefferson Louisiana 22051 44057 848
1084162 2021-03-03 Jefferson Mississippi 28063 627 27
1084262 2021-03-03 Jefferson Missouri 29099 21701 223
1084351 2021-03-03 Jefferson Montana 30043 1010 8
1084433 2021-03-03 Jefferson Nebraska 31095 628 1
1084583 2021-03-03 Jefferson New York 36045 4836 63
1084816 2021-03-03 Jefferson Ohio 39081 4806 107
1084897 2021-03-03 Jefferson Oklahoma 40067 672 12
1084957 2021-03-03 Jefferson Oregon 41031 1966 28
1085010 2021-03-03 Jefferson Pennsylvania 42065 2814 90
1085286 2021-03-03 Jefferson Tennessee 47089 5677 119
1085460 2021-03-03 Jefferson Texas 48245 18267 351
1085788 2021-03-03 Jefferson Washington 53031 337 2
1085830 2021-03-03 Jefferson West Virginia 54037 3649 37
1085894 2021-03-03 Jefferson Wisconsin 55055 8834 125
1079506 2021-03-02 Jefferson Alabama 1073 71145 1374
1079614 2021-03-02 Jefferson Arkansas 5069 8622 159
1079744 2021-03-02 Jefferson Colorado 8059 37380 725
1079823 2021-03-02 Jefferson Florida 12065 1406 24
1079940 2021-03-02 Jefferson Georgia 13163 1867 58
1080051 2021-03-02 Jefferson Idaho 16051 2467 22
1080110 2021-03-02 Jefferson Illinois 17081 3980 117
1080211 2021-03-02 Jefferson Indiana 18077 2950 74
1080315 2021-03-02 Jefferson Iowa 19101 1267 34
1080408 2021-03-02 Jefferson Kansas 20087 1618 32
1080526 2021-03-02 Jefferson Kentucky 21111 74391 924
1080616 2021-03-02 Jefferson Louisiana 22051 44014 847
1080916 2021-03-02 Jefferson Mississippi 28063 627 27
1081016 2021-03-02 Jefferson Missouri 29099 21608 210
1081105 2021-03-02 Jefferson Montana 30043 1007 8
1081187 2021-03-02 Jefferson Nebraska 31095 628 1
1081337 2021-03-02 Jefferson New York 36045 4816 63
1081570 2021-03-02 Jefferson Ohio 39081 4795 107
1081651 2021-03-02 Jefferson Oklahoma 40067 672 12
1081711 2021-03-02 Jefferson Oregon 41031 1962 28
1081764 2021-03-02 Jefferson Pennsylvania 42065 2789 90
1082040 2021-03-02 Jefferson Tennessee 47089 5659 119
1082214 2021-03-02 Jefferson Texas 48245 18174 345
1082542 2021-03-02 Jefferson Washington 53031 337 2
1082584 2021-03-02 Jefferson West Virginia 54037 3638 37
1082648 2021-03-02 Jefferson Wisconsin 55055 8834 125
1076261 2021-03-01 Jefferson Alabama 1073 71073 1374
1076369 2021-03-01 Jefferson Arkansas 5069 8606 159
1076499 2021-03-01 Jefferson Colorado 8059 37323 720
1076578 2021-03-01 Jefferson Florida 12065 1404 24
1076695 2021-03-01 Jefferson Georgia 13163 1865 58
1076806 2021-03-01 Jefferson Idaho 16051 2455 22
1076865 2021-03-01 Jefferson Illinois 17081 3980 116
1076966 2021-03-01 Jefferson Indiana 18077 2949 73
1077070 2021-03-01 Jefferson Iowa 19101 1267 32
1077163 2021-03-01 Jefferson Kansas 20087 1618 32
1077281 2021-03-01 Jefferson Kentucky 21111 74287 918
1077371 2021-03-01 Jefferson Louisiana 22051 43936 844
1077670 2021-03-01 Jefferson Mississippi 28063 625 27
1077770 2021-03-01 Jefferson Missouri 29099 21608 210
1077859 2021-03-01 Jefferson Montana 30043 1004 8
1077941 2021-03-01 Jefferson Nebraska 31095 628 1
1078091 2021-03-01 Jefferson New York 36045 4806 63
1078324 2021-03-01 Jefferson Ohio 39081 4790 108
1078405 2021-03-01 Jefferson Oklahoma 40067 672 11
1078465 2021-03-01 Jefferson Oregon 41031 1960 28
1078518 2021-03-01 Jefferson Pennsylvania 42065 2786 90
1078794 2021-03-01 Jefferson Tennessee 47089 5650 118
1078968 2021-03-01 Jefferson Texas 48245 18159 343
1079296 2021-03-01 Jefferson Washington 53031 337 2
1079338 2021-03-01 Jefferson West Virginia 54037 3634 37
1079402 2021-03-01 Jefferson Wisconsin 55055 8826 125
1073015 2021-02-28 Jefferson Alabama 1073 70986 1374
1073123 2021-02-28 Jefferson Arkansas 5069 8604 159
1073253 2021-02-28 Jefferson Colorado 8059 37202 720
1073332 2021-02-28 Jefferson Florida 12065 1404 24
1073449 2021-02-28 Jefferson Georgia 13163 1865 58
1073560 2021-02-28 Jefferson Idaho 16051 2447 22
1073619 2021-02-28 Jefferson Illinois 17081 3976 116
1073720 2021-02-28 Jefferson Indiana 18077 2948 73
1073824 2021-02-28 Jefferson Iowa 19101 1267 32
1073917 2021-02-28 Jefferson Kansas 20087 1611 32
1074035 2021-02-28 Jefferson Kentucky 21111 74241 918
1074125 2021-02-28 Jefferson Louisiana 22051 43898 844
1074424 2021-02-28 Jefferson Mississippi 28063 623 27
1074524 2021-02-28 Jefferson Missouri 29099 21608 210
1074613 2021-02-28 Jefferson Montana 30043 1004 8
1074695 2021-02-28 Jefferson Nebraska 31095 629 1
1074846 2021-02-28 Jefferson New York 36045 4784 63
1075079 2021-02-28 Jefferson Ohio 39081 4781 108
1075160 2021-02-28 Jefferson Oklahoma 40067 672 11
1075220 2021-02-28 Jefferson Oregon 41031 1958 28
1075273 2021-02-28 Jefferson Pennsylvania 42065 2785 90
1075549 2021-02-28 Jefferson Tennessee 47089 5642 118

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]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);