ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,350 rows where county = "Pickens" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 3
- Georgia 785
- South Carolina 785
- Alabama 680
county 1
- Pickens · 2,250 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
296591 | 296591 | 2020-07-03 | Pickens | Alabama | 1107 | 223 | 6 |
299753 | 299753 | 2020-07-04 | Pickens | Alabama | 1107 | 228 | 6 |
302917 | 302917 | 2020-07-05 | Pickens | Alabama | 1107 | 236 | 6 |
306081 | 306081 | 2020-07-06 | Pickens | Alabama | 1107 | 237 | 6 |
309250 | 309250 | 2020-07-07 | Pickens | Alabama | 1107 | 241 | 6 |
312419 | 312419 | 2020-07-08 | Pickens | Alabama | 1107 | 247 | 6 |
315594 | 315594 | 2020-07-09 | Pickens | Alabama | 1107 | 258 | 6 |
318767 | 318767 | 2020-07-10 | Pickens | Alabama | 1107 | 265 | 6 |
321946 | 321946 | 2020-07-11 | Pickens | Alabama | 1107 | 272 | 6 |
325127 | 325127 | 2020-07-12 | Pickens | Alabama | 1107 | 277 | 6 |
328313 | 328313 | 2020-07-13 | Pickens | Alabama | 1107 | 281 | 6 |
331499 | 331499 | 2020-07-14 | Pickens | Alabama | 1107 | 283 | 6 |
334692 | 334692 | 2020-07-15 | Pickens | Alabama | 1107 | 285 | 7 |
337887 | 337887 | 2020-07-16 | Pickens | Alabama | 1107 | 289 | 7 |
341083 | 341083 | 2020-07-17 | Pickens | Alabama | 1107 | 296 | 7 |
344282 | 344282 | 2020-07-18 | Pickens | Alabama | 1107 | 302 | 7 |
347482 | 347482 | 2020-07-19 | Pickens | Alabama | 1107 | 305 | 7 |
350683 | 350683 | 2020-07-20 | Pickens | Alabama | 1107 | 311 | 7 |
353885 | 353885 | 2020-07-21 | Pickens | Alabama | 1107 | 313 | 7 |
357088 | 357088 | 2020-07-22 | Pickens | Alabama | 1107 | 315 | 9 |
360293 | 360293 | 2020-07-23 | Pickens | Alabama | 1107 | 317 | 9 |
363499 | 363499 | 2020-07-24 | Pickens | Alabama | 1107 | 326 | 9 |
366706 | 366706 | 2020-07-25 | Pickens | Alabama | 1107 | 333 | 9 |
369916 | 369916 | 2020-07-26 | Pickens | Alabama | 1107 | 336 | 9 |
373128 | 373128 | 2020-07-27 | Pickens | Alabama | 1107 | 342 | 9 |
376342 | 376342 | 2020-07-28 | Pickens | Alabama | 1107 | 344 | 9 |
379558 | 379558 | 2020-07-29 | Pickens | Alabama | 1107 | 346 | 10 |
382775 | 382775 | 2020-07-30 | Pickens | Alabama | 1107 | 353 | 10 |
385993 | 385993 | 2020-07-31 | Pickens | Alabama | 1107 | 361 | 10 |
389210 | 389210 | 2020-08-01 | Pickens | Alabama | 1107 | 366 | 10 |
392427 | 392427 | 2020-08-02 | Pickens | Alabama | 1107 | 370 | 10 |
395643 | 395643 | 2020-08-03 | Pickens | Alabama | 1107 | 374 | 10 |
398859 | 398859 | 2020-08-04 | Pickens | Alabama | 1107 | 378 | 10 |
402075 | 402075 | 2020-08-05 | Pickens | Alabama | 1107 | 383 | 10 |
405293 | 405293 | 2020-08-06 | Pickens | Alabama | 1107 | 385 | 10 |
408513 | 408513 | 2020-08-07 | Pickens | Alabama | 1107 | 392 | 10 |
411732 | 411732 | 2020-08-08 | Pickens | Alabama | 1107 | 400 | 10 |
414952 | 414952 | 2020-08-09 | Pickens | Alabama | 1107 | 411 | 10 |
418173 | 418173 | 2020-08-10 | Pickens | Alabama | 1107 | 415 | 10 |
421394 | 421394 | 2020-08-11 | Pickens | Alabama | 1107 | 419 | 10 |
424615 | 424615 | 2020-08-12 | Pickens | Alabama | 1107 | 422 | 11 |
427839 | 427839 | 2020-08-13 | Pickens | Alabama | 1107 | 427 | 11 |
431067 | 431067 | 2020-08-14 | Pickens | Alabama | 1107 | 434 | 11 |
434292 | 434292 | 2020-08-15 | Pickens | Alabama | 1107 | 449 | 11 |
437518 | 437518 | 2020-08-16 | Pickens | Alabama | 1107 | 451 | 11 |
440744 | 440744 | 2020-08-17 | Pickens | Alabama | 1107 | 457 | 11 |
443970 | 443970 | 2020-08-18 | Pickens | Alabama | 1107 | 463 | 11 |
447197 | 447197 | 2020-08-19 | Pickens | Alabama | 1107 | 479 | 11 |
450425 | 450425 | 2020-08-20 | Pickens | Alabama | 1107 | 485 | 11 |
453653 | 453653 | 2020-08-21 | Pickens | Alabama | 1107 | 487 | 11 |
456881 | 456881 | 2020-08-22 | Pickens | Alabama | 1107 | 516 | 11 |
460108 | 460108 | 2020-08-23 | Pickens | Alabama | 1107 | 521 | 11 |
463337 | 463337 | 2020-08-24 | Pickens | Alabama | 1107 | 529 | 11 |
466566 | 466566 | 2020-08-25 | Pickens | Alabama | 1107 | 528 | 11 |
469795 | 469795 | 2020-08-26 | Pickens | Alabama | 1107 | 536 | 11 |
473027 | 473027 | 2020-08-27 | Pickens | Alabama | 1107 | 539 | 11 |
476260 | 476260 | 2020-08-28 | Pickens | Alabama | 1107 | 543 | 11 |
479493 | 479493 | 2020-08-29 | Pickens | Alabama | 1107 | 555 | 11 |
482727 | 482727 | 2020-08-30 | Pickens | Alabama | 1107 | 560 | 11 |
485962 | 485962 | 2020-08-31 | Pickens | Alabama | 1107 | 563 | 11 |
489195 | 489195 | 2020-09-01 | Pickens | Alabama | 1107 | 564 | 12 |
492428 | 492428 | 2020-09-02 | Pickens | Alabama | 1107 | 567 | 12 |
495662 | 495662 | 2020-09-03 | Pickens | Alabama | 1107 | 571 | 12 |
498895 | 498895 | 2020-09-04 | Pickens | Alabama | 1107 | 575 | 12 |
502129 | 502129 | 2020-09-05 | Pickens | Alabama | 1107 | 576 | 12 |
505363 | 505363 | 2020-09-06 | Pickens | Alabama | 1107 | 580 | 12 |
508595 | 508595 | 2020-09-07 | Pickens | Alabama | 1107 | 579 | 12 |
511828 | 511828 | 2020-09-08 | Pickens | Alabama | 1107 | 583 | 12 |
515061 | 515061 | 2020-09-09 | Pickens | Alabama | 1107 | 589 | 12 |
518296 | 518296 | 2020-09-10 | Pickens | Alabama | 1107 | 593 | 13 |
521533 | 521533 | 2020-09-11 | Pickens | Alabama | 1107 | 601 | 13 |
524769 | 524769 | 2020-09-12 | Pickens | Alabama | 1107 | 605 | 13 |
528005 | 528005 | 2020-09-13 | Pickens | Alabama | 1107 | 608 | 13 |
531242 | 531242 | 2020-09-14 | Pickens | Alabama | 1107 | 613 | 13 |
534477 | 534477 | 2020-09-15 | Pickens | Alabama | 1107 | 613 | 14 |
537713 | 537713 | 2020-09-16 | Pickens | Alabama | 1107 | 615 | 14 |
540950 | 540950 | 2020-09-17 | Pickens | Alabama | 1107 | 622 | 14 |
544186 | 544186 | 2020-09-18 | Pickens | Alabama | 1107 | 628 | 14 |
547423 | 547423 | 2020-09-19 | Pickens | Alabama | 1107 | 631 | 14 |
550662 | 550662 | 2020-09-20 | Pickens | Alabama | 1107 | 635 | 14 |
553901 | 553901 | 2020-09-21 | Pickens | Alabama | 1107 | 638 | 14 |
557138 | 557138 | 2020-09-22 | Pickens | Alabama | 1107 | 639 | 14 |
560374 | 560374 | 2020-09-23 | Pickens | Alabama | 1107 | 645 | 14 |
563613 | 563613 | 2020-09-24 | Pickens | Alabama | 1107 | 651 | 14 |
566854 | 566854 | 2020-09-25 | Pickens | Alabama | 1107 | 656 | 14 |
570095 | 570095 | 2020-09-26 | Pickens | Alabama | 1107 | 662 | 14 |
573337 | 573337 | 2020-09-27 | Pickens | Alabama | 1107 | 666 | 14 |
576581 | 576581 | 2020-09-28 | Pickens | Alabama | 1107 | 668 | 14 |
579822 | 579822 | 2020-09-29 | Pickens | Alabama | 1107 | 670 | 14 |
583061 | 583061 | 2020-09-30 | Pickens | Alabama | 1107 | 672 | 15 |
586301 | 586301 | 2020-10-01 | Pickens | Alabama | 1107 | 674 | 15 |
589542 | 589542 | 2020-10-02 | Pickens | Alabama | 1107 | 676 | 15 |
592782 | 592782 | 2020-10-03 | Pickens | Alabama | 1107 | 679 | 15 |
596024 | 596024 | 2020-10-04 | Pickens | Alabama | 1107 | 684 | 15 |
599267 | 599267 | 2020-10-05 | Pickens | Alabama | 1107 | 684 | 15 |
602510 | 602510 | 2020-10-06 | Pickens | Alabama | 1107 | 687 | 15 |
605752 | 605752 | 2020-10-07 | Pickens | Alabama | 1107 | 688 | 15 |
608995 | 608995 | 2020-10-08 | Pickens | Alabama | 1107 | 697 | 15 |
612237 | 612237 | 2020-10-09 | Pickens | Alabama | 1107 | 703 | 15 |
615478 | 615478 | 2020-10-10 | Pickens | Alabama | 1107 | 712 | 15 |
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);