ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,693 rows where county = "DeKalb" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- DeKalb · 2,063 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1076844 | 1076844 | 2021-03-01 | DeKalb | Illinois | 17037 | 8409 | 117 |
1076942 | 1076942 | 2021-03-01 | DeKalb | Indiana | 18033 | 3857 | 82 |
1077752 | 1077752 | 2021-03-01 | DeKalb | Missouri | 29063 | 921 | 27 |
1078769 | 1078769 | 2021-03-01 | DeKalb | Tennessee | 47041 | 2647 | 49 |
1073003 | 1073003 | 2021-02-28 | DeKalb | Alabama | 1049 | 8446 | 175 |
1073411 | 1073411 | 2021-02-28 | DeKalb | Georgia | 13089 | 57268 | 830 |
1073598 | 1073598 | 2021-02-28 | DeKalb | Illinois | 17037 | 8409 | 117 |
1073696 | 1073696 | 2021-02-28 | DeKalb | Indiana | 18033 | 3856 | 82 |
1074506 | 1074506 | 2021-02-28 | DeKalb | Missouri | 29063 | 920 | 27 |
1075524 | 1075524 | 2021-02-28 | DeKalb | Tennessee | 47041 | 2643 | 49 |
1069757 | 1069757 | 2021-02-27 | DeKalb | Alabama | 1049 | 8441 | 175 |
1070165 | 1070165 | 2021-02-27 | DeKalb | Georgia | 13089 | 57132 | 830 |
1070352 | 1070352 | 2021-02-27 | DeKalb | Illinois | 17037 | 8409 | 117 |
1070450 | 1070450 | 2021-02-27 | DeKalb | Indiana | 18033 | 3851 | 82 |
1071260 | 1071260 | 2021-02-27 | DeKalb | Missouri | 29063 | 920 | 27 |
1072278 | 1072278 | 2021-02-27 | DeKalb | Tennessee | 47041 | 2641 | 49 |
1066512 | 1066512 | 2021-02-26 | DeKalb | Alabama | 1049 | 8436 | 174 |
1066920 | 1066920 | 2021-02-26 | DeKalb | Georgia | 13089 | 56961 | 821 |
1067107 | 1067107 | 2021-02-26 | DeKalb | Illinois | 17037 | 8409 | 117 |
1067205 | 1067205 | 2021-02-26 | DeKalb | Indiana | 18033 | 3848 | 82 |
1068015 | 1068015 | 2021-02-26 | DeKalb | Missouri | 29063 | 920 | 27 |
1069032 | 1069032 | 2021-02-26 | DeKalb | Tennessee | 47041 | 2620 | 49 |
1063267 | 1063267 | 2021-02-25 | DeKalb | Alabama | 1049 | 8429 | 174 |
1063675 | 1063675 | 2021-02-25 | DeKalb | Georgia | 13089 | 56776 | 819 |
1063862 | 1063862 | 2021-02-25 | DeKalb | Illinois | 17037 | 8386 | 117 |
1063960 | 1063960 | 2021-02-25 | DeKalb | Indiana | 18033 | 3845 | 82 |
1064770 | 1064770 | 2021-02-25 | DeKalb | Missouri | 29063 | 920 | 27 |
1065787 | 1065787 | 2021-02-25 | DeKalb | Tennessee | 47041 | 2618 | 49 |
1060022 | 1060022 | 2021-02-24 | DeKalb | Alabama | 1049 | 8419 | 173 |
1060430 | 1060430 | 2021-02-24 | DeKalb | Georgia | 13089 | 56549 | 810 |
1060617 | 1060617 | 2021-02-24 | DeKalb | Illinois | 17037 | 8376 | 116 |
1060715 | 1060715 | 2021-02-24 | DeKalb | Indiana | 18033 | 3833 | 82 |
1061526 | 1061526 | 2021-02-24 | DeKalb | Missouri | 29063 | 918 | 27 |
1062542 | 1062542 | 2021-02-24 | DeKalb | Tennessee | 47041 | 2615 | 48 |
1056776 | 1056776 | 2021-02-23 | DeKalb | Alabama | 1049 | 8419 | 173 |
1057184 | 1057184 | 2021-02-23 | DeKalb | Georgia | 13089 | 56332 | 802 |
1057371 | 1057371 | 2021-02-23 | DeKalb | Illinois | 17037 | 8339 | 116 |
1057469 | 1057469 | 2021-02-23 | DeKalb | Indiana | 18033 | 3825 | 82 |
1058280 | 1058280 | 2021-02-23 | DeKalb | Missouri | 29063 | 919 | 27 |
1059297 | 1059297 | 2021-02-23 | DeKalb | Tennessee | 47041 | 2615 | 47 |
1053530 | 1053530 | 2021-02-22 | DeKalb | Alabama | 1049 | 8409 | 173 |
1053938 | 1053938 | 2021-02-22 | DeKalb | Georgia | 13089 | 56076 | 797 |
1054125 | 1054125 | 2021-02-22 | DeKalb | Illinois | 17037 | 8321 | 116 |
1054223 | 1054223 | 2021-02-22 | DeKalb | Indiana | 18033 | 3819 | 81 |
1055034 | 1055034 | 2021-02-22 | DeKalb | Missouri | 29063 | 919 | 26 |
1056051 | 1056051 | 2021-02-22 | DeKalb | Tennessee | 47041 | 2610 | 47 |
1050283 | 1050283 | 2021-02-21 | DeKalb | Alabama | 1049 | 8405 | 173 |
1050691 | 1050691 | 2021-02-21 | DeKalb | Georgia | 13089 | 55963 | 790 |
1050878 | 1050878 | 2021-02-21 | DeKalb | Illinois | 17037 | 8297 | 116 |
1050976 | 1050976 | 2021-02-21 | DeKalb | Indiana | 18033 | 3816 | 81 |
1051787 | 1051787 | 2021-02-21 | DeKalb | Missouri | 29063 | 917 | 26 |
1052805 | 1052805 | 2021-02-21 | DeKalb | Tennessee | 47041 | 2609 | 47 |
1047036 | 1047036 | 2021-02-20 | DeKalb | Alabama | 1049 | 8399 | 173 |
1047444 | 1047444 | 2021-02-20 | DeKalb | Georgia | 13089 | 55808 | 790 |
1047631 | 1047631 | 2021-02-20 | DeKalb | Illinois | 17037 | 8297 | 116 |
1047729 | 1047729 | 2021-02-20 | DeKalb | Indiana | 18033 | 3815 | 81 |
1048540 | 1048540 | 2021-02-20 | DeKalb | Missouri | 29063 | 916 | 26 |
1049558 | 1049558 | 2021-02-20 | DeKalb | Tennessee | 47041 | 2607 | 47 |
1043791 | 1043791 | 2021-02-19 | DeKalb | Alabama | 1049 | 8394 | 172 |
1044199 | 1044199 | 2021-02-19 | DeKalb | Georgia | 13089 | 55610 | 785 |
1044386 | 1044386 | 2021-02-19 | DeKalb | Illinois | 17037 | 8297 | 116 |
1044484 | 1044484 | 2021-02-19 | DeKalb | Indiana | 18033 | 3807 | 81 |
1045294 | 1045294 | 2021-02-19 | DeKalb | Missouri | 29063 | 916 | 26 |
1046311 | 1046311 | 2021-02-19 | DeKalb | Tennessee | 47041 | 2605 | 47 |
1040546 | 1040546 | 2021-02-18 | DeKalb | Alabama | 1049 | 8378 | 170 |
1040954 | 1040954 | 2021-02-18 | DeKalb | Georgia | 13089 | 55415 | 771 |
1041141 | 1041141 | 2021-02-18 | DeKalb | Illinois | 17037 | 8280 | 116 |
1041239 | 1041239 | 2021-02-18 | DeKalb | Indiana | 18033 | 3792 | 81 |
1042049 | 1042049 | 2021-02-18 | DeKalb | Missouri | 29063 | 915 | 26 |
1043066 | 1043066 | 2021-02-18 | DeKalb | Tennessee | 47041 | 2604 | 47 |
1037301 | 1037301 | 2021-02-17 | DeKalb | Alabama | 1049 | 8373 | 170 |
1037709 | 1037709 | 2021-02-17 | DeKalb | Georgia | 13089 | 55217 | 764 |
1037896 | 1037896 | 2021-02-17 | DeKalb | Illinois | 17037 | 8252 | 114 |
1037994 | 1037994 | 2021-02-17 | DeKalb | Indiana | 18033 | 3790 | 81 |
1038804 | 1038804 | 2021-02-17 | DeKalb | Missouri | 29063 | 914 | 26 |
1039821 | 1039821 | 2021-02-17 | DeKalb | Tennessee | 47041 | 2608 | 47 |
1034056 | 1034056 | 2021-02-16 | DeKalb | Alabama | 1049 | 8363 | 167 |
1034464 | 1034464 | 2021-02-16 | DeKalb | Georgia | 13089 | 54995 | 754 |
1034651 | 1034651 | 2021-02-16 | DeKalb | Illinois | 17037 | 8236 | 114 |
1034749 | 1034749 | 2021-02-16 | DeKalb | Indiana | 18033 | 3774 | 81 |
1035559 | 1035559 | 2021-02-16 | DeKalb | Missouri | 29063 | 913 | 26 |
1036576 | 1036576 | 2021-02-16 | DeKalb | Tennessee | 47041 | 2606 | 47 |
1030810 | 1030810 | 2021-02-15 | DeKalb | Alabama | 1049 | 8355 | 167 |
1031218 | 1031218 | 2021-02-15 | DeKalb | Georgia | 13089 | 54889 | 741 |
1031405 | 1031405 | 2021-02-15 | DeKalb | Illinois | 17037 | 8197 | 114 |
1031503 | 1031503 | 2021-02-15 | DeKalb | Indiana | 18033 | 3768 | 81 |
1032314 | 1032314 | 2021-02-15 | DeKalb | Missouri | 29063 | 910 | 26 |
1033331 | 1033331 | 2021-02-15 | DeKalb | Tennessee | 47041 | 2603 | 47 |
1027563 | 1027563 | 2021-02-14 | DeKalb | Alabama | 1049 | 8352 | 167 |
1027971 | 1027971 | 2021-02-14 | DeKalb | Georgia | 13089 | 54796 | 737 |
1028158 | 1028158 | 2021-02-14 | DeKalb | Illinois | 17037 | 8197 | 114 |
1028256 | 1028256 | 2021-02-14 | DeKalb | Indiana | 18033 | 3760 | 81 |
1029067 | 1029067 | 2021-02-14 | DeKalb | Missouri | 29063 | 910 | 26 |
1030085 | 1030085 | 2021-02-14 | DeKalb | Tennessee | 47041 | 2600 | 47 |
1024318 | 1024318 | 2021-02-13 | DeKalb | Alabama | 1049 | 8343 | 167 |
1024726 | 1024726 | 2021-02-13 | DeKalb | Georgia | 13089 | 54663 | 736 |
1024913 | 1024913 | 2021-02-13 | DeKalb | Illinois | 17037 | 8197 | 113 |
1025011 | 1025011 | 2021-02-13 | DeKalb | Indiana | 18033 | 3745 | 81 |
1025821 | 1025821 | 2021-02-13 | DeKalb | Missouri | 29063 | 909 | 26 |
1026838 | 1026838 | 2021-02-13 | DeKalb | Tennessee | 47041 | 2595 | 46 |
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);