ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "DeKalb" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
933851 | 933851 | 2021-01-16 | DeKalb | Georgia | 13089 | 45942 | 573 |
930606 | 930606 | 2021-01-15 | DeKalb | Georgia | 13089 | 45360 | 565 |
927361 | 927361 | 2021-01-14 | DeKalb | Georgia | 13089 | 44882 | 562 |
924115 | 924115 | 2021-01-13 | DeKalb | Georgia | 13089 | 44325 | 556 |
920870 | 920870 | 2021-01-12 | DeKalb | Georgia | 13089 | 43813 | 550 |
917625 | 917625 | 2021-01-11 | DeKalb | Georgia | 13089 | 43286 | 546 |
914380 | 914380 | 2021-01-10 | DeKalb | Georgia | 13089 | 42825 | 546 |
911135 | 911135 | 2021-01-09 | DeKalb | Georgia | 13089 | 42374 | 546 |
907890 | 907890 | 2021-01-08 | DeKalb | Georgia | 13089 | 41710 | 544 |
904644 | 904644 | 2021-01-07 | DeKalb | Georgia | 13089 | 41082 | 543 |
901399 | 901399 | 2021-01-06 | DeKalb | Georgia | 13089 | 40608 | 541 |
898154 | 898154 | 2021-01-05 | DeKalb | Georgia | 13089 | 40261 | 537 |
894909 | 894909 | 2021-01-04 | DeKalb | Georgia | 13089 | 39705 | 534 |
891662 | 891662 | 2021-01-03 | DeKalb | Georgia | 13089 | 39518 | 532 |
888415 | 888415 | 2021-01-02 | DeKalb | Georgia | 13089 | 39319 | 532 |
885170 | 885170 | 2021-01-01 | DeKalb | Georgia | 13089 | 38922 | 532 |
881925 | 881925 | 2020-12-31 | DeKalb | Georgia | 13089 | 38320 | 531 |
878680 | 878680 | 2020-12-30 | DeKalb | Georgia | 13089 | 37777 | 527 |
875435 | 875435 | 2020-12-29 | DeKalb | Georgia | 13089 | 37305 | 526 |
872190 | 872190 | 2020-12-28 | DeKalb | Georgia | 13089 | 36859 | 523 |
868945 | 868945 | 2020-12-27 | DeKalb | Georgia | 13089 | 36530 | 523 |
865700 | 865700 | 2020-12-26 | DeKalb | Georgia | 13089 | 36367 | 522 |
862455 | 862455 | 2020-12-25 | DeKalb | Georgia | 13089 | 36150 | 518 |
859210 | 859210 | 2020-12-24 | DeKalb | Georgia | 13089 | 35782 | 514 |
855965 | 855965 | 2020-12-23 | DeKalb | Georgia | 13089 | 35178 | 508 |
852720 | 852720 | 2020-12-22 | DeKalb | Georgia | 13089 | 34827 | 504 |
849475 | 849475 | 2020-12-21 | DeKalb | Georgia | 13089 | 34315 | 503 |
846230 | 846230 | 2020-12-20 | DeKalb | Georgia | 13089 | 34181 | 502 |
842984 | 842984 | 2020-12-19 | DeKalb | Georgia | 13089 | 33872 | 502 |
839739 | 839739 | 2020-12-18 | DeKalb | Georgia | 13089 | 33516 | 501 |
836494 | 836494 | 2020-12-17 | DeKalb | Georgia | 13089 | 33152 | 500 |
833248 | 833248 | 2020-12-16 | DeKalb | Georgia | 13089 | 32790 | 499 |
830001 | 830001 | 2020-12-15 | DeKalb | Georgia | 13089 | 32486 | 494 |
826755 | 826755 | 2020-12-14 | DeKalb | Georgia | 13089 | 32090 | 493 |
823508 | 823508 | 2020-12-13 | DeKalb | Georgia | 13089 | 31883 | 492 |
820262 | 820262 | 2020-12-12 | DeKalb | Georgia | 13089 | 31563 | 492 |
817016 | 817016 | 2020-12-11 | DeKalb | Georgia | 13089 | 31203 | 491 |
813770 | 813770 | 2020-12-10 | DeKalb | Georgia | 13089 | 30878 | 488 |
810526 | 810526 | 2020-12-09 | DeKalb | Georgia | 13089 | 30488 | 483 |
807281 | 807281 | 2020-12-08 | DeKalb | Georgia | 13089 | 30206 | 483 |
804036 | 804036 | 2020-12-07 | DeKalb | Georgia | 13089 | 29847 | 482 |
800791 | 800791 | 2020-12-06 | DeKalb | Georgia | 13089 | 29603 | 480 |
797546 | 797546 | 2020-12-05 | DeKalb | Georgia | 13089 | 29386 | 480 |
794301 | 794301 | 2020-12-04 | DeKalb | Georgia | 13089 | 29064 | 471 |
791056 | 791056 | 2020-12-03 | DeKalb | Georgia | 13089 | 28630 | 469 |
787811 | 787811 | 2020-12-02 | DeKalb | Georgia | 13089 | 28316 | 462 |
784567 | 784567 | 2020-12-01 | DeKalb | Georgia | 13089 | 27997 | 459 |
781322 | 781322 | 2020-11-30 | DeKalb | Georgia | 13089 | 27766 | 456 |
778076 | 778076 | 2020-11-29 | DeKalb | Georgia | 13089 | 27663 | 456 |
774831 | 774831 | 2020-11-28 | DeKalb | Georgia | 13089 | 27580 | 456 |
771586 | 771586 | 2020-11-27 | DeKalb | Georgia | 13089 | 27420 | 455 |
768341 | 768341 | 2020-11-26 | DeKalb | Georgia | 13089 | 27219 | 454 |
765095 | 765095 | 2020-11-25 | DeKalb | Georgia | 13089 | 27027 | 450 |
761850 | 761850 | 2020-11-24 | DeKalb | Georgia | 13089 | 26863 | 446 |
758605 | 758605 | 2020-11-23 | DeKalb | Georgia | 13089 | 26707 | 447 |
755358 | 755358 | 2020-11-22 | DeKalb | Georgia | 13089 | 26599 | 446 |
752112 | 752112 | 2020-11-21 | DeKalb | Georgia | 13089 | 26406 | 446 |
748866 | 748866 | 2020-11-20 | DeKalb | Georgia | 13089 | 26027 | 446 |
745620 | 745620 | 2020-11-19 | DeKalb | Georgia | 13089 | 25784 | 445 |
742373 | 742373 | 2020-11-18 | DeKalb | Georgia | 13089 | 25578 | 445 |
739126 | 739126 | 2020-11-17 | DeKalb | Georgia | 13089 | 25353 | 441 |
735882 | 735882 | 2020-11-16 | DeKalb | Georgia | 13089 | 25071 | 441 |
732636 | 732636 | 2020-11-15 | DeKalb | Georgia | 13089 | 25020 | 441 |
729391 | 729391 | 2020-11-14 | DeKalb | Georgia | 13089 | 24848 | 441 |
726148 | 726148 | 2020-11-13 | DeKalb | Georgia | 13089 | 24626 | 439 |
722905 | 722905 | 2020-11-12 | DeKalb | Georgia | 13089 | 24457 | 437 |
719662 | 719662 | 2020-11-11 | DeKalb | Georgia | 13089 | 24250 | 433 |
716419 | 716419 | 2020-11-10 | DeKalb | Georgia | 13089 | 24094 | 426 |
713175 | 713175 | 2020-11-09 | DeKalb | Georgia | 13089 | 23836 | 428 |
709931 | 709931 | 2020-11-08 | DeKalb | Georgia | 13089 | 23733 | 425 |
706687 | 706687 | 2020-11-07 | DeKalb | Georgia | 13089 | 23584 | 425 |
703444 | 703444 | 2020-11-06 | DeKalb | Georgia | 13089 | 23495 | 424 |
700201 | 700201 | 2020-11-05 | DeKalb | Georgia | 13089 | 23332 | 424 |
696957 | 696957 | 2020-11-04 | DeKalb | Georgia | 13089 | 23178 | 425 |
693715 | 693715 | 2020-11-03 | DeKalb | Georgia | 13089 | 22914 | 404 |
690472 | 690472 | 2020-11-02 | DeKalb | Georgia | 13089 | 22776 | 404 |
687227 | 687227 | 2020-11-01 | DeKalb | Georgia | 13089 | 22641 | 403 |
683983 | 683983 | 2020-10-31 | DeKalb | Georgia | 13089 | 22550 | 403 |
680740 | 680740 | 2020-10-30 | DeKalb | Georgia | 13089 | 22404 | 403 |
677497 | 677497 | 2020-10-29 | DeKalb | Georgia | 13089 | 22298 | 401 |
674254 | 674254 | 2020-10-28 | DeKalb | Georgia | 13089 | 22194 | 398 |
671012 | 671012 | 2020-10-27 | DeKalb | Georgia | 13089 | 22064 | 398 |
667769 | 667769 | 2020-10-26 | DeKalb | Georgia | 13089 | 22012 | 397 |
664524 | 664524 | 2020-10-25 | DeKalb | Georgia | 13089 | 21804 | 395 |
661280 | 661280 | 2020-10-24 | DeKalb | Georgia | 13089 | 21710 | 395 |
658036 | 658036 | 2020-10-23 | DeKalb | Georgia | 13089 | 21596 | 397 |
654791 | 654791 | 2020-10-22 | DeKalb | Georgia | 13089 | 21410 | 393 |
651546 | 651546 | 2020-10-21 | DeKalb | Georgia | 13089 | 21309 | 391 |
648302 | 648302 | 2020-10-20 | DeKalb | Georgia | 13089 | 21221 | 390 |
645057 | 645057 | 2020-10-19 | DeKalb | Georgia | 13089 | 21133 | 390 |
641809 | 641809 | 2020-10-18 | DeKalb | Georgia | 13089 | 21116 | 390 |
638562 | 638562 | 2020-10-17 | DeKalb | Georgia | 13089 | 21023 | 386 |
635317 | 635317 | 2020-10-16 | DeKalb | Georgia | 13089 | 20929 | 387 |
632071 | 632071 | 2020-10-15 | DeKalb | Georgia | 13089 | 20810 | 384 |
628827 | 628827 | 2020-10-14 | DeKalb | Georgia | 13089 | 20698 | 383 |
625584 | 625584 | 2020-10-13 | DeKalb | Georgia | 13089 | 20638 | 382 |
622341 | 622341 | 2020-10-12 | DeKalb | Georgia | 13089 | 20584 | 380 |
619098 | 619098 | 2020-10-11 | DeKalb | Georgia | 13089 | 20498 | 380 |
615856 | 615856 | 2020-10-10 | DeKalb | Georgia | 13089 | 20409 | 378 |
612615 | 612615 | 2020-10-09 | DeKalb | Georgia | 13089 | 20367 | 378 |
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);