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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 26
- Colorado 800
- Washington 799
- Kentucky 797
- Louisiana 796
- Arkansas 794
- Tennessee 792
- West Virginia 788
- New York 787
- Wisconsin 785
- Missouri 781
- Montana 781
- Texas 781
- Idaho 780
- Kansas 779
- Ohio 779
- Mississippi 778
- Georgia 775
- Indiana 774
- Iowa 772
- Florida 770
- Illinois 768
- Oklahoma 768
- Pennsylvania 767
- Oregon 760
- Nebraska 748
- Alabama 692
fips 26
county 1
- Jefferson · 20,191 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
258869 | 258869 | 2020-06-21 | Jefferson | Alabama | 1073 | 2987 | 126 |
261996 | 261996 | 2020-06-22 | Jefferson | Alabama | 1073 | 3069 | 126 |
265125 | 265125 | 2020-06-23 | Jefferson | Alabama | 1073 | 3144 | 127 |
268254 | 268254 | 2020-06-24 | Jefferson | Alabama | 1073 | 3232 | 130 |
271388 | 271388 | 2020-06-25 | Jefferson | Alabama | 1073 | 3378 | 131 |
274528 | 274528 | 2020-06-26 | Jefferson | Alabama | 1073 | 3528 | 131 |
277676 | 277676 | 2020-06-27 | Jefferson | Alabama | 1073 | 3651 | 135 |
280824 | 280824 | 2020-06-28 | Jefferson | Alabama | 1073 | 3729 | 135 |
283970 | 283970 | 2020-06-29 | Jefferson | Alabama | 1073 | 4099 | 136 |
287116 | 287116 | 2020-06-30 | Jefferson | Alabama | 1073 | 4258 | 142 |
290266 | 290266 | 2020-07-01 | Jefferson | Alabama | 1073 | 4436 | 144 |
293419 | 293419 | 2020-07-02 | Jefferson | Alabama | 1073 | 4581 | 145 |
296574 | 296574 | 2020-07-03 | Jefferson | Alabama | 1073 | 4853 | 154 |
299736 | 299736 | 2020-07-04 | Jefferson | Alabama | 1073 | 4995 | 154 |
302900 | 302900 | 2020-07-05 | Jefferson | Alabama | 1073 | 5272 | 154 |
306064 | 306064 | 2020-07-06 | Jefferson | Alabama | 1073 | 5461 | 154 |
309233 | 309233 | 2020-07-07 | Jefferson | Alabama | 1073 | 5538 | 157 |
312402 | 312402 | 2020-07-08 | Jefferson | Alabama | 1073 | 5741 | 163 |
315577 | 315577 | 2020-07-09 | Jefferson | Alabama | 1073 | 6092 | 164 |
318750 | 318750 | 2020-07-10 | Jefferson | Alabama | 1073 | 6283 | 169 |
321929 | 321929 | 2020-07-11 | Jefferson | Alabama | 1073 | 6504 | 172 |
325110 | 325110 | 2020-07-12 | Jefferson | Alabama | 1073 | 6823 | 172 |
328296 | 328296 | 2020-07-13 | Jefferson | Alabama | 1073 | 7091 | 172 |
331482 | 331482 | 2020-07-14 | Jefferson | Alabama | 1073 | 7265 | 176 |
334675 | 334675 | 2020-07-15 | Jefferson | Alabama | 1073 | 7540 | 178 |
337870 | 337870 | 2020-07-16 | Jefferson | Alabama | 1073 | 7900 | 183 |
341066 | 341066 | 2020-07-17 | Jefferson | Alabama | 1073 | 8201 | 184 |
344265 | 344265 | 2020-07-18 | Jefferson | Alabama | 1073 | 8499 | 185 |
347465 | 347465 | 2020-07-19 | Jefferson | Alabama | 1073 | 8742 | 185 |
350666 | 350666 | 2020-07-20 | Jefferson | Alabama | 1073 | 9003 | 187 |
353868 | 353868 | 2020-07-21 | Jefferson | Alabama | 1073 | 9190 | 190 |
357071 | 357071 | 2020-07-22 | Jefferson | Alabama | 1073 | 9400 | 192 |
360276 | 360276 | 2020-07-23 | Jefferson | Alabama | 1073 | 9676 | 199 |
363482 | 363482 | 2020-07-24 | Jefferson | Alabama | 1073 | 9940 | 199 |
366689 | 366689 | 2020-07-25 | Jefferson | Alabama | 1073 | 10236 | 202 |
369899 | 369899 | 2020-07-26 | Jefferson | Alabama | 1073 | 10405 | 204 |
373111 | 373111 | 2020-07-27 | Jefferson | Alabama | 1073 | 10567 | 205 |
376325 | 376325 | 2020-07-28 | Jefferson | Alabama | 1073 | 10715 | 205 |
379541 | 379541 | 2020-07-29 | Jefferson | Alabama | 1073 | 10847 | 210 |
382758 | 382758 | 2020-07-30 | Jefferson | Alabama | 1073 | 11111 | 222 |
385976 | 385976 | 2020-07-31 | Jefferson | Alabama | 1073 | 11382 | 225 |
389193 | 389193 | 2020-08-01 | Jefferson | Alabama | 1073 | 11680 | 227 |
392410 | 392410 | 2020-08-02 | Jefferson | Alabama | 1073 | 11866 | 227 |
395626 | 395626 | 2020-08-03 | Jefferson | Alabama | 1073 | 12076 | 227 |
398842 | 398842 | 2020-08-04 | Jefferson | Alabama | 1073 | 12259 | 230 |
402058 | 402058 | 2020-08-05 | Jefferson | Alabama | 1073 | 12408 | 232 |
405276 | 405276 | 2020-08-06 | Jefferson | Alabama | 1073 | 12730 | 234 |
408496 | 408496 | 2020-08-07 | Jefferson | Alabama | 1073 | 13005 | 244 |
411715 | 411715 | 2020-08-08 | Jefferson | Alabama | 1073 | 13232 | 245 |
414935 | 414935 | 2020-08-09 | Jefferson | Alabama | 1073 | 13373 | 245 |
418156 | 418156 | 2020-08-10 | Jefferson | Alabama | 1073 | 13530 | 246 |
421377 | 421377 | 2020-08-11 | Jefferson | Alabama | 1073 | 13653 | 248 |
424598 | 424598 | 2020-08-12 | Jefferson | Alabama | 1073 | 13751 | 263 |
427822 | 427822 | 2020-08-13 | Jefferson | Alabama | 1073 | 13872 | 264 |
431050 | 431050 | 2020-08-14 | Jefferson | Alabama | 1073 | 13979 | 264 |
434275 | 434275 | 2020-08-15 | Jefferson | Alabama | 1073 | 14206 | 264 |
437501 | 437501 | 2020-08-16 | Jefferson | Alabama | 1073 | 14307 | 264 |
440727 | 440727 | 2020-08-17 | Jefferson | Alabama | 1073 | 14379 | 264 |
443953 | 443953 | 2020-08-18 | Jefferson | Alabama | 1073 | 14525 | 266 |
447180 | 447180 | 2020-08-19 | Jefferson | Alabama | 1073 | 14666 | 274 |
450408 | 450408 | 2020-08-20 | Jefferson | Alabama | 1073 | 14782 | 278 |
453636 | 453636 | 2020-08-21 | Jefferson | Alabama | 1073 | 14901 | 281 |
456864 | 456864 | 2020-08-22 | Jefferson | Alabama | 1073 | 14942 | 287 |
460091 | 460091 | 2020-08-23 | Jefferson | Alabama | 1073 | 14984 | 287 |
463320 | 463320 | 2020-08-24 | Jefferson | Alabama | 1073 | 15084 | 288 |
466549 | 466549 | 2020-08-25 | Jefferson | Alabama | 1073 | 15143 | 288 |
469778 | 469778 | 2020-08-26 | Jefferson | Alabama | 1073 | 15550 | 288 |
473010 | 473010 | 2020-08-27 | Jefferson | Alabama | 1073 | 15713 | 289 |
476243 | 476243 | 2020-08-28 | Jefferson | Alabama | 1073 | 15870 | 289 |
479476 | 479476 | 2020-08-29 | Jefferson | Alabama | 1073 | 16133 | 303 |
482710 | 482710 | 2020-08-30 | Jefferson | Alabama | 1073 | 16278 | 303 |
485945 | 485945 | 2020-08-31 | Jefferson | Alabama | 1073 | 16426 | 303 |
489178 | 489178 | 2020-09-01 | Jefferson | Alabama | 1073 | 16679 | 303 |
492411 | 492411 | 2020-09-02 | Jefferson | Alabama | 1073 | 16801 | 303 |
495645 | 495645 | 2020-09-03 | Jefferson | Alabama | 1073 | 16894 | 310 |
498878 | 498878 | 2020-09-04 | Jefferson | Alabama | 1073 | 17024 | 312 |
502112 | 502112 | 2020-09-05 | Jefferson | Alabama | 1073 | 17171 | 312 |
505346 | 505346 | 2020-09-06 | Jefferson | Alabama | 1073 | 17276 | 312 |
508578 | 508578 | 2020-09-07 | Jefferson | Alabama | 1073 | 17389 | 312 |
511811 | 511811 | 2020-09-08 | Jefferson | Alabama | 1073 | 17493 | 312 |
515044 | 515044 | 2020-09-09 | Jefferson | Alabama | 1073 | 17591 | 312 |
518279 | 518279 | 2020-09-10 | Jefferson | Alabama | 1073 | 17736 | 312 |
521516 | 521516 | 2020-09-11 | Jefferson | Alabama | 1073 | 17908 | 318 |
524752 | 524752 | 2020-09-12 | Jefferson | Alabama | 1073 | 18039 | 318 |
527988 | 527988 | 2020-09-13 | Jefferson | Alabama | 1073 | 18169 | 318 |
531225 | 531225 | 2020-09-14 | Jefferson | Alabama | 1073 | 18253 | 318 |
534460 | 534460 | 2020-09-15 | Jefferson | Alabama | 1073 | 18381 | 328 |
537696 | 537696 | 2020-09-16 | Jefferson | Alabama | 1073 | 18531 | 332 |
540933 | 540933 | 2020-09-17 | Jefferson | Alabama | 1073 | 18648 | 332 |
544169 | 544169 | 2020-09-18 | Jefferson | Alabama | 1073 | 18772 | 333 |
547406 | 547406 | 2020-09-19 | Jefferson | Alabama | 1073 | 18911 | 337 |
550645 | 550645 | 2020-09-20 | Jefferson | Alabama | 1073 | 19015 | 337 |
553884 | 553884 | 2020-09-21 | Jefferson | Alabama | 1073 | 19123 | 337 |
557121 | 557121 | 2020-09-22 | Jefferson | Alabama | 1073 | 19230 | 342 |
560357 | 560357 | 2020-09-23 | Jefferson | Alabama | 1073 | 19306 | 349 |
563596 | 563596 | 2020-09-24 | Jefferson | Alabama | 1073 | 19441 | 349 |
566837 | 566837 | 2020-09-25 | Jefferson | Alabama | 1073 | 19572 | 348 |
570078 | 570078 | 2020-09-26 | Jefferson | Alabama | 1073 | 19676 | 351 |
573320 | 573320 | 2020-09-27 | Jefferson | Alabama | 1073 | 19752 | 351 |
576564 | 576564 | 2020-09-28 | Jefferson | Alabama | 1073 | 19833 | 350 |
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);