ny_times_us_counties

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

2,949 rows where county = "Jefferson" sorted by date descending

View and edit SQL

state

fips

county

  • Jefferson · 2,949
Link rowid date ▲ county state fips cases deaths
334412 2020-07-15 Jefferson Alabama 1073 7540 178
334519 2020-07-15 Jefferson Arkansas 5069 917 29
334647 2020-07-15 Jefferson Colorado 8059 3118 217
334725 2020-07-15 Jefferson Florida 12065 100 4
334842 2020-07-15 Jefferson Georgia 13163 246 2
334950 2020-07-15 Jefferson Idaho 16051 39 0
335008 2020-07-15 Jefferson Illinois 17081 123 17
335109 2020-07-15 Jefferson Indiana 18077 99 2
335213 2020-07-15 Jefferson Iowa 19101 64 0
335306 2020-07-15 Jefferson Kansas 20087 39 0
335420 2020-07-15 Jefferson Kentucky 21111 4709 227
335510 2020-07-15 Jefferson Louisiana 22051 11614 495
335809 2020-07-15 Jefferson Mississippi 28063 135 3
335909 2020-07-15 Jefferson Missouri 29099 834 23
335994 2020-07-15 Jefferson Montana 30043 12 0
336062 2020-07-15 Jefferson Nebraska 31095 11 0
336205 2020-07-15 Jefferson New York 36045 100 0
336437 2020-07-15 Jefferson Ohio 39081 135 2
336518 2020-07-15 Jefferson Oklahoma 40067 19 0
336576 2020-07-15 Jefferson Oregon 41031 171 0
336628 2020-07-15 Jefferson Pennsylvania 42065 41 1
336902 2020-07-15 Jefferson Tennessee 47089 219 1
337075 2020-07-15 Jefferson Texas 48245 3868 43
337395 2020-07-15 Jefferson Washington 53031 50 0
337436 2020-07-15 Jefferson West Virginia 54037 261 4
337500 2020-07-15 Jefferson Wisconsin 55055 384 4
331221 2020-07-14 Jefferson Alabama 1073 7265 176
331328 2020-07-14 Jefferson Arkansas 5069 900 29
331456 2020-07-14 Jefferson Colorado 8059 3089 217
331534 2020-07-14 Jefferson Florida 12065 93 4
331651 2020-07-14 Jefferson Georgia 13163 229 2
331759 2020-07-14 Jefferson Idaho 16051 39 0
331817 2020-07-14 Jefferson Illinois 17081 117 17
331918 2020-07-14 Jefferson Indiana 18077 94 2
332022 2020-07-14 Jefferson Iowa 19101 63 0
332115 2020-07-14 Jefferson Kansas 20087 38 0
332229 2020-07-14 Jefferson Kentucky 21111 4661 227
332319 2020-07-14 Jefferson Louisiana 22051 11450 495
332618 2020-07-14 Jefferson Mississippi 28063 135 3
332718 2020-07-14 Jefferson Missouri 29099 814 23
332803 2020-07-14 Jefferson Montana 30043 12 0
332870 2020-07-14 Jefferson Nebraska 31095 11 0
333013 2020-07-14 Jefferson New York 36045 100 0
333245 2020-07-14 Jefferson Ohio 39081 132 2
333326 2020-07-14 Jefferson Oklahoma 40067 18 0
333384 2020-07-14 Jefferson Oregon 41031 169 0
333436 2020-07-14 Jefferson Pennsylvania 42065 41 1
333710 2020-07-14 Jefferson Tennessee 47089 196 1
333882 2020-07-14 Jefferson Texas 48245 3665 42
334202 2020-07-14 Jefferson Washington 53031 44 0
334243 2020-07-14 Jefferson West Virginia 54037 258 4
334307 2020-07-14 Jefferson Wisconsin 55055 369 4
328037 2020-07-13 Jefferson Alabama 1073 7091 172
328144 2020-07-13 Jefferson Arkansas 5069 884 29
328272 2020-07-13 Jefferson Colorado 8059 3055 216
328349 2020-07-13 Jefferson Florida 12065 87 4
328466 2020-07-13 Jefferson Georgia 13163 215 2
328574 2020-07-13 Jefferson Idaho 16051 36 0
328632 2020-07-13 Jefferson Illinois 17081 115 17
328733 2020-07-13 Jefferson Indiana 18077 88 2
328837 2020-07-13 Jefferson Iowa 19101 63 0
328930 2020-07-13 Jefferson Kansas 20087 37 0
329044 2020-07-13 Jefferson Kentucky 21111 4588 224
329134 2020-07-13 Jefferson Louisiana 22051 11256 495
329433 2020-07-13 Jefferson Mississippi 28063 137 3
329533 2020-07-13 Jefferson Missouri 29099 769 23
329618 2020-07-13 Jefferson Montana 30043 10 0
329682 2020-07-13 Jefferson Nebraska 31095 11 0
329825 2020-07-13 Jefferson New York 36045 99 0
330055 2020-07-13 Jefferson Ohio 39081 127 2
330136 2020-07-13 Jefferson Oklahoma 40067 17 0
330194 2020-07-13 Jefferson Oregon 41031 168 0
330246 2020-07-13 Jefferson Pennsylvania 42065 39 1
330520 2020-07-13 Jefferson Tennessee 47089 193 1
330693 2020-07-13 Jefferson Texas 48245 3548 39
331011 2020-07-13 Jefferson Washington 53031 43 0
331052 2020-07-13 Jefferson West Virginia 54037 258 4
331116 2020-07-13 Jefferson Wisconsin 55055 361 4
324853 2020-07-12 Jefferson Alabama 1073 6823 172
324960 2020-07-12 Jefferson Arkansas 5069 861 29
325088 2020-07-12 Jefferson Colorado 8059 3026 215
325165 2020-07-12 Jefferson Florida 12065 81 4
325282 2020-07-12 Jefferson Georgia 13163 204 2
325390 2020-07-12 Jefferson Idaho 16051 32 0
325448 2020-07-12 Jefferson Illinois 17081 114 17
325549 2020-07-12 Jefferson Indiana 18077 88 2
325653 2020-07-12 Jefferson Iowa 19101 63 0
325746 2020-07-12 Jefferson Kansas 20087 38 0
325860 2020-07-12 Jefferson Kentucky 21111 4561 222
325950 2020-07-12 Jefferson Louisiana 22051 11100 493
326249 2020-07-12 Jefferson Mississippi 28063 128 3
326349 2020-07-12 Jefferson Missouri 29099 743 23
326433 2020-07-12 Jefferson Montana 30043 10 0
326497 2020-07-12 Jefferson Nebraska 31095 11 0
326640 2020-07-12 Jefferson New York 36045 97 0
326870 2020-07-12 Jefferson Ohio 39081 115 2
326951 2020-07-12 Jefferson Oklahoma 40067 16 0
327010 2020-07-12 Jefferson Oregon 41031 168 0
327062 2020-07-12 Jefferson Pennsylvania 42065 37 1
327336 2020-07-12 Jefferson Tennessee 47089 187 1

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
);
Powered by Datasette · Query took 1091.237ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette