ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Gwinnett" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
748890 | 748890 | 2020-11-20 | Gwinnett | Georgia | 13135 | 37267 | 505 |
745644 | 745644 | 2020-11-19 | Gwinnett | Georgia | 13135 | 37004 | 502 |
742397 | 742397 | 2020-11-18 | Gwinnett | Georgia | 13135 | 36744 | 500 |
739150 | 739150 | 2020-11-17 | Gwinnett | Georgia | 13135 | 36516 | 497 |
735906 | 735906 | 2020-11-16 | Gwinnett | Georgia | 13135 | 36118 | 495 |
732660 | 732660 | 2020-11-15 | Gwinnett | Georgia | 13135 | 36018 | 494 |
729415 | 729415 | 2020-11-14 | Gwinnett | Georgia | 13135 | 35835 | 494 |
726172 | 726172 | 2020-11-13 | Gwinnett | Georgia | 13135 | 35572 | 492 |
722929 | 722929 | 2020-11-12 | Gwinnett | Georgia | 13135 | 35339 | 492 |
719686 | 719686 | 2020-11-11 | Gwinnett | Georgia | 13135 | 35105 | 485 |
716443 | 716443 | 2020-11-10 | Gwinnett | Georgia | 13135 | 34903 | 481 |
713199 | 713199 | 2020-11-09 | Gwinnett | Georgia | 13135 | 34514 | 479 |
709955 | 709955 | 2020-11-08 | Gwinnett | Georgia | 13135 | 34402 | 479 |
706711 | 706711 | 2020-11-07 | Gwinnett | Georgia | 13135 | 34266 | 479 |
703468 | 703468 | 2020-11-06 | Gwinnett | Georgia | 13135 | 34131 | 478 |
700225 | 700225 | 2020-11-05 | Gwinnett | Georgia | 13135 | 33883 | 476 |
696981 | 696981 | 2020-11-04 | Gwinnett | Georgia | 13135 | 33740 | 473 |
693739 | 693739 | 2020-11-03 | Gwinnett | Georgia | 13135 | 33471 | 452 |
690496 | 690496 | 2020-11-02 | Gwinnett | Georgia | 13135 | 33346 | 452 |
687251 | 687251 | 2020-11-01 | Gwinnett | Georgia | 13135 | 33063 | 450 |
684007 | 684007 | 2020-10-31 | Gwinnett | Georgia | 13135 | 32947 | 450 |
680764 | 680764 | 2020-10-30 | Gwinnett | Georgia | 13135 | 32739 | 449 |
677521 | 677521 | 2020-10-29 | Gwinnett | Georgia | 13135 | 32591 | 447 |
674278 | 674278 | 2020-10-28 | Gwinnett | Georgia | 13135 | 32441 | 445 |
671036 | 671036 | 2020-10-27 | Gwinnett | Georgia | 13135 | 32334 | 443 |
667793 | 667793 | 2020-10-26 | Gwinnett | Georgia | 13135 | 32228 | 442 |
664548 | 664548 | 2020-10-25 | Gwinnett | Georgia | 13135 | 31979 | 440 |
661304 | 661304 | 2020-10-24 | Gwinnett | Georgia | 13135 | 31877 | 440 |
658060 | 658060 | 2020-10-23 | Gwinnett | Georgia | 13135 | 31782 | 438 |
654815 | 654815 | 2020-10-22 | Gwinnett | Georgia | 13135 | 31632 | 438 |
651570 | 651570 | 2020-10-21 | Gwinnett | Georgia | 13135 | 31589 | 436 |
648326 | 648326 | 2020-10-20 | Gwinnett | Georgia | 13135 | 31539 | 436 |
645081 | 645081 | 2020-10-19 | Gwinnett | Georgia | 13135 | 31421 | 434 |
641833 | 641833 | 2020-10-18 | Gwinnett | Georgia | 13135 | 31298 | 433 |
638586 | 638586 | 2020-10-17 | Gwinnett | Georgia | 13135 | 31167 | 431 |
635341 | 635341 | 2020-10-16 | Gwinnett | Georgia | 13135 | 31027 | 429 |
632095 | 632095 | 2020-10-15 | Gwinnett | Georgia | 13135 | 30904 | 428 |
628851 | 628851 | 2020-10-14 | Gwinnett | Georgia | 13135 | 30766 | 427 |
625608 | 625608 | 2020-10-13 | Gwinnett | Georgia | 13135 | 30624 | 425 |
622365 | 622365 | 2020-10-12 | Gwinnett | Georgia | 13135 | 30470 | 424 |
619122 | 619122 | 2020-10-11 | Gwinnett | Georgia | 13135 | 30242 | 424 |
615880 | 615880 | 2020-10-10 | Gwinnett | Georgia | 13135 | 30158 | 423 |
612639 | 612639 | 2020-10-09 | Gwinnett | Georgia | 13135 | 30039 | 422 |
609397 | 609397 | 2020-10-08 | Gwinnett | Georgia | 13135 | 29907 | 421 |
606154 | 606154 | 2020-10-07 | Gwinnett | Georgia | 13135 | 29774 | 419 |
602912 | 602912 | 2020-10-06 | Gwinnett | Georgia | 13135 | 29653 | 418 |
599669 | 599669 | 2020-10-05 | Gwinnett | Georgia | 13135 | 29575 | 417 |
596426 | 596426 | 2020-10-04 | Gwinnett | Georgia | 13135 | 28074 | 414 |
593184 | 593184 | 2020-10-03 | Gwinnett | Georgia | 13135 | 27986 | 414 |
589944 | 589944 | 2020-10-02 | Gwinnett | Georgia | 13135 | 27844 | 412 |
586703 | 586703 | 2020-10-01 | Gwinnett | Georgia | 13135 | 27733 | 409 |
583463 | 583463 | 2020-09-30 | Gwinnett | Georgia | 13135 | 27647 | 409 |
580224 | 580224 | 2020-09-29 | Gwinnett | Georgia | 13135 | 27519 | 407 |
576983 | 576983 | 2020-09-28 | Gwinnett | Georgia | 13135 | 27424 | 405 |
573740 | 573740 | 2020-09-27 | Gwinnett | Georgia | 13135 | 27358 | 404 |
570498 | 570498 | 2020-09-26 | Gwinnett | Georgia | 13135 | 27296 | 402 |
567256 | 567256 | 2020-09-25 | Gwinnett | Georgia | 13135 | 27187 | 401 |
564016 | 564016 | 2020-09-24 | Gwinnett | Georgia | 13135 | 27051 | 398 |
560776 | 560776 | 2020-09-23 | Gwinnett | Georgia | 13135 | 26931 | 398 |
557540 | 557540 | 2020-09-22 | Gwinnett | Georgia | 13135 | 26744 | 396 |
554303 | 554303 | 2020-09-21 | Gwinnett | Georgia | 13135 | 26678 | 391 |
551064 | 551064 | 2020-09-20 | Gwinnett | Georgia | 13135 | 26618 | 391 |
547825 | 547825 | 2020-09-19 | Gwinnett | Georgia | 13135 | 26550 | 391 |
544587 | 544587 | 2020-09-18 | Gwinnett | Georgia | 13135 | 26403 | 388 |
541351 | 541351 | 2020-09-17 | Gwinnett | Georgia | 13135 | 26280 | 386 |
538114 | 538114 | 2020-09-16 | Gwinnett | Georgia | 13135 | 26133 | 381 |
534878 | 534878 | 2020-09-15 | Gwinnett | Georgia | 13135 | 26019 | 380 |
531643 | 531643 | 2020-09-14 | Gwinnett | Georgia | 13135 | 25863 | 379 |
528406 | 528406 | 2020-09-13 | Gwinnett | Georgia | 13135 | 25806 | 375 |
525170 | 525170 | 2020-09-12 | Gwinnett | Georgia | 13135 | 25726 | 372 |
521934 | 521934 | 2020-09-11 | Gwinnett | Georgia | 13135 | 25611 | 369 |
518697 | 518697 | 2020-09-10 | Gwinnett | Georgia | 13135 | 25495 | 366 |
515462 | 515462 | 2020-09-09 | Gwinnett | Georgia | 13135 | 25376 | 361 |
512229 | 512229 | 2020-09-08 | Gwinnett | Georgia | 13135 | 25215 | 359 |
508996 | 508996 | 2020-09-07 | Gwinnett | Georgia | 13135 | 25127 | 359 |
505764 | 505764 | 2020-09-06 | Gwinnett | Georgia | 13135 | 25107 | 359 |
502530 | 502530 | 2020-09-05 | Gwinnett | Georgia | 13135 | 25019 | 356 |
499296 | 499296 | 2020-09-04 | Gwinnett | Georgia | 13135 | 24870 | 351 |
496063 | 496063 | 2020-09-03 | Gwinnett | Georgia | 13135 | 24763 | 346 |
492829 | 492829 | 2020-09-02 | Gwinnett | Georgia | 13135 | 24608 | 343 |
489596 | 489596 | 2020-09-01 | Gwinnett | Georgia | 13135 | 24477 | 341 |
486363 | 486363 | 2020-08-31 | Gwinnett | Georgia | 13135 | 24252 | 336 |
483128 | 483128 | 2020-08-30 | Gwinnett | Georgia | 13135 | 24182 | 333 |
479894 | 479894 | 2020-08-29 | Gwinnett | Georgia | 13135 | 24137 | 330 |
476661 | 476661 | 2020-08-28 | Gwinnett | Georgia | 13135 | 23972 | 324 |
473428 | 473428 | 2020-08-27 | Gwinnett | Georgia | 13135 | 23812 | 322 |
470196 | 470196 | 2020-08-26 | Gwinnett | Georgia | 13135 | 23636 | 314 |
466967 | 466967 | 2020-08-25 | Gwinnett | Georgia | 13135 | 23411 | 309 |
463738 | 463738 | 2020-08-24 | Gwinnett | Georgia | 13135 | 23178 | 306 |
460509 | 460509 | 2020-08-23 | Gwinnett | Georgia | 13135 | 23096 | 306 |
457282 | 457282 | 2020-08-22 | Gwinnett | Georgia | 13135 | 22991 | 304 |
454054 | 454054 | 2020-08-21 | Gwinnett | Georgia | 13135 | 22786 | 302 |
450826 | 450826 | 2020-08-20 | Gwinnett | Georgia | 13135 | 22455 | 295 |
447598 | 447598 | 2020-08-19 | Gwinnett | Georgia | 13135 | 22196 | 295 |
444371 | 444371 | 2020-08-18 | Gwinnett | Georgia | 13135 | 21936 | 293 |
441145 | 441145 | 2020-08-17 | Gwinnett | Georgia | 13135 | 21655 | 290 |
437919 | 437919 | 2020-08-16 | Gwinnett | Georgia | 13135 | 21534 | 289 |
434693 | 434693 | 2020-08-15 | Gwinnett | Georgia | 13135 | 21411 | 287 |
431468 | 431468 | 2020-08-14 | Gwinnett | Georgia | 13135 | 21175 | 283 |
428240 | 428240 | 2020-08-13 | Gwinnett | Georgia | 13135 | 20900 | 282 |
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);