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 314
- Washington 313
- Kentucky 311
- Louisiana 310
- Arkansas 307
- Tennessee 306
- Alabama 305
- West Virginia 302
- New York 301
- Wisconsin 299
- Missouri 295
- Montana 295
- Texas 295
- Idaho 294
- Kansas 293
- Ohio 293
- Mississippi 292
- Georgia 289
- Indiana 288
- Iowa 286
- Florida 284
- Illinois 282
- Oklahoma 282
- Pennsylvania 281
- Oregon 274
- Nebraska 262
fips 26
county 1
- Jefferson · 7,653 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920712 | 920712 | 2021-01-12 | Jefferson | Colorado | 8059 | 31950 | 651 |
920791 | 920791 | 2021-01-12 | Jefferson | Florida | 12065 | 1141 | 18 |
920908 | 920908 | 2021-01-12 | Jefferson | Georgia | 13163 | 1493 | 41 |
921019 | 921019 | 2021-01-12 | Jefferson | Idaho | 16051 | 2165 | 15 |
921078 | 921078 | 2021-01-12 | Jefferson | Illinois | 17081 | 3258 | 97 |
921178 | 921178 | 2021-01-12 | Jefferson | Indiana | 18077 | 2391 | 42 |
921282 | 921282 | 2021-01-12 | Jefferson | Iowa | 19101 | 1172 | 23 |
921375 | 921375 | 2021-01-12 | Jefferson | Kansas | 20087 | 1345 | 22 |
921493 | 921493 | 2021-01-12 | Jefferson | Kentucky | 21111 | 58666 | 726 |
921583 | 921583 | 2021-01-12 | Jefferson | Louisiana | 22051 | 35823 | 709 |
921883 | 921883 | 2021-01-12 | Jefferson | Mississippi | 28063 | 512 | 18 |
921983 | 921983 | 2021-01-12 | Jefferson | Missouri | 29099 | 18737 | 153 |
922072 | 922072 | 2021-01-12 | Jefferson | Montana | 30043 | 855 | 5 |
922154 | 922154 | 2021-01-12 | Jefferson | Nebraska | 31095 | 576 | 1 |
922304 | 922304 | 2021-01-12 | Jefferson | New York | 36045 | 2652 | 16 |
922537 | 922537 | 2021-01-12 | Jefferson | Ohio | 39081 | 3846 | 65 |
922618 | 922618 | 2021-01-12 | Jefferson | Oklahoma | 40067 | 548 | 4 |
922678 | 922678 | 2021-01-12 | Jefferson | Oregon | 41031 | 1627 | 23 |
922731 | 922731 | 2021-01-12 | Jefferson | Pennsylvania | 42065 | 2171 | 55 |
923007 | 923007 | 2021-01-12 | Jefferson | Tennessee | 47089 | 4495 | 75 |
923181 | 923181 | 2021-01-12 | Jefferson | Texas | 48245 | 15188 | 253 |
923509 | 923509 | 2021-01-12 | Jefferson | Washington | 53031 | 258 | 2 |
923551 | 923551 | 2021-01-12 | Jefferson | West Virginia | 54037 | 2828 | 28 |
923615 | 923615 | 2021-01-12 | Jefferson | Wisconsin | 55055 | 7813 | 66 |
917229 | 917229 | 2021-01-11 | Jefferson | Alabama | 1073 | 59248 | 784 |
917337 | 917337 | 2021-01-11 | Jefferson | Arkansas | 5069 | 7190 | 134 |
917467 | 917467 | 2021-01-11 | Jefferson | Colorado | 8059 | 31837 | 648 |
917546 | 917546 | 2021-01-11 | Jefferson | Florida | 12065 | 1127 | 18 |
917663 | 917663 | 2021-01-11 | Jefferson | Georgia | 13163 | 1480 | 41 |
917774 | 917774 | 2021-01-11 | Jefferson | Idaho | 16051 | 2157 | 15 |
917833 | 917833 | 2021-01-11 | Jefferson | Illinois | 17081 | 3243 | 96 |
917933 | 917933 | 2021-01-11 | Jefferson | Indiana | 18077 | 2380 | 42 |
918037 | 918037 | 2021-01-11 | Jefferson | Iowa | 19101 | 1163 | 23 |
918130 | 918130 | 2021-01-11 | Jefferson | Kansas | 20087 | 1345 | 21 |
918248 | 918248 | 2021-01-11 | Jefferson | Kentucky | 21111 | 58281 | 719 |
918338 | 918338 | 2021-01-11 | Jefferson | Louisiana | 22051 | 35379 | 708 |
918638 | 918638 | 2021-01-11 | Jefferson | Mississippi | 28063 | 511 | 18 |
918738 | 918738 | 2021-01-11 | Jefferson | Missouri | 29099 | 18615 | 150 |
918827 | 918827 | 2021-01-11 | Jefferson | Montana | 30043 | 851 | 4 |
918909 | 918909 | 2021-01-11 | Jefferson | Nebraska | 31095 | 574 | 1 |
919059 | 919059 | 2021-01-11 | Jefferson | New York | 36045 | 2572 | 16 |
919292 | 919292 | 2021-01-11 | Jefferson | Ohio | 39081 | 3805 | 64 |
919373 | 919373 | 2021-01-11 | Jefferson | Oklahoma | 40067 | 546 | 4 |
919433 | 919433 | 2021-01-11 | Jefferson | Oregon | 41031 | 1608 | 21 |
919486 | 919486 | 2021-01-11 | Jefferson | Pennsylvania | 42065 | 2156 | 55 |
919762 | 919762 | 2021-01-11 | Jefferson | Tennessee | 47089 | 4436 | 74 |
919936 | 919936 | 2021-01-11 | Jefferson | Texas | 48245 | 15008 | 249 |
920264 | 920264 | 2021-01-11 | Jefferson | Washington | 53031 | 256 | 2 |
920306 | 920306 | 2021-01-11 | Jefferson | West Virginia | 54037 | 2795 | 27 |
920370 | 920370 | 2021-01-11 | Jefferson | Wisconsin | 55055 | 7784 | 65 |
913984 | 913984 | 2021-01-10 | Jefferson | Alabama | 1073 | 58896 | 784 |
914092 | 914092 | 2021-01-10 | Jefferson | Arkansas | 5069 | 7173 | 134 |
914222 | 914222 | 2021-01-10 | Jefferson | Colorado | 8059 | 31685 | 648 |
914301 | 914301 | 2021-01-10 | Jefferson | Florida | 12065 | 1126 | 18 |
914418 | 914418 | 2021-01-10 | Jefferson | Georgia | 13163 | 1449 | 41 |
914529 | 914529 | 2021-01-10 | Jefferson | Idaho | 16051 | 2157 | 15 |
914588 | 914588 | 2021-01-10 | Jefferson | Illinois | 17081 | 3209 | 95 |
914688 | 914688 | 2021-01-10 | Jefferson | Indiana | 18077 | 2366 | 42 |
914792 | 914792 | 2021-01-10 | Jefferson | Iowa | 19101 | 1155 | 23 |
914885 | 914885 | 2021-01-10 | Jefferson | Kansas | 20087 | 1295 | 21 |
915003 | 915003 | 2021-01-10 | Jefferson | Kentucky | 21111 | 57745 | 715 |
915093 | 915093 | 2021-01-10 | Jefferson | Louisiana | 22051 | 35137 | 708 |
915393 | 915393 | 2021-01-10 | Jefferson | Mississippi | 28063 | 508 | 17 |
915493 | 915493 | 2021-01-10 | Jefferson | Missouri | 29099 | 18171 | 150 |
915582 | 915582 | 2021-01-10 | Jefferson | Montana | 30043 | 850 | 4 |
915664 | 915664 | 2021-01-10 | Jefferson | Nebraska | 31095 | 574 | 1 |
915814 | 915814 | 2021-01-10 | Jefferson | New York | 36045 | 2493 | 16 |
916047 | 916047 | 2021-01-10 | Jefferson | Ohio | 39081 | 3784 | 64 |
916128 | 916128 | 2021-01-10 | Jefferson | Oklahoma | 40067 | 533 | 4 |
916188 | 916188 | 2021-01-10 | Jefferson | Oregon | 41031 | 1603 | 20 |
916241 | 916241 | 2021-01-10 | Jefferson | Pennsylvania | 42065 | 2145 | 54 |
916517 | 916517 | 2021-01-10 | Jefferson | Tennessee | 47089 | 4406 | 73 |
916691 | 916691 | 2021-01-10 | Jefferson | Texas | 48245 | 15008 | 249 |
917019 | 917019 | 2021-01-10 | Jefferson | Washington | 53031 | 254 | 2 |
917061 | 917061 | 2021-01-10 | Jefferson | West Virginia | 54037 | 2766 | 27 |
917125 | 917125 | 2021-01-10 | Jefferson | Wisconsin | 55055 | 7750 | 65 |
910739 | 910739 | 2021-01-09 | Jefferson | Alabama | 1073 | 58394 | 784 |
910847 | 910847 | 2021-01-09 | Jefferson | Arkansas | 5069 | 7144 | 133 |
910977 | 910977 | 2021-01-09 | Jefferson | Colorado | 8059 | 31516 | 646 |
911056 | 911056 | 2021-01-09 | Jefferson | Florida | 12065 | 1111 | 18 |
911173 | 911173 | 2021-01-09 | Jefferson | Georgia | 13163 | 1432 | 41 |
911284 | 911284 | 2021-01-09 | Jefferson | Idaho | 16051 | 2145 | 15 |
911343 | 911343 | 2021-01-09 | Jefferson | Illinois | 17081 | 3167 | 95 |
911443 | 911443 | 2021-01-09 | Jefferson | Indiana | 18077 | 2345 | 42 |
911547 | 911547 | 2021-01-09 | Jefferson | Iowa | 19101 | 1149 | 23 |
911640 | 911640 | 2021-01-09 | Jefferson | Kansas | 20087 | 1295 | 21 |
911758 | 911758 | 2021-01-09 | Jefferson | Kentucky | 21111 | 57201 | 715 |
911848 | 911848 | 2021-01-09 | Jefferson | Louisiana | 22051 | 34491 | 705 |
912148 | 912148 | 2021-01-09 | Jefferson | Mississippi | 28063 | 504 | 17 |
912248 | 912248 | 2021-01-09 | Jefferson | Missouri | 29099 | 18171 | 150 |
912337 | 912337 | 2021-01-09 | Jefferson | Montana | 30043 | 851 | 4 |
912419 | 912419 | 2021-01-09 | Jefferson | Nebraska | 31095 | 572 | 1 |
912569 | 912569 | 2021-01-09 | Jefferson | New York | 36045 | 2423 | 16 |
912802 | 912802 | 2021-01-09 | Jefferson | Ohio | 39081 | 3742 | 64 |
912883 | 912883 | 2021-01-09 | Jefferson | Oklahoma | 40067 | 520 | 4 |
912943 | 912943 | 2021-01-09 | Jefferson | Oregon | 41031 | 1592 | 20 |
912996 | 912996 | 2021-01-09 | Jefferson | Pennsylvania | 42065 | 2124 | 54 |
913272 | 913272 | 2021-01-09 | Jefferson | Tennessee | 47089 | 4353 | 71 |
913446 | 913446 | 2021-01-09 | Jefferson | Texas | 48245 | 15008 | 244 |
913774 | 913774 | 2021-01-09 | Jefferson | Washington | 53031 | 254 | 2 |
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);