ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Effingham" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193549 | 1193549 | 2021-04-06 | Effingham | Georgia | 13103 | 4436 | 65 |
1190299 | 1190299 | 2021-04-05 | Effingham | Georgia | 13103 | 4431 | 65 |
1187052 | 1187052 | 2021-04-04 | Effingham | Georgia | 13103 | 4435 | 65 |
1183805 | 1183805 | 2021-04-03 | Effingham | Georgia | 13103 | 4427 | 65 |
1180558 | 1180558 | 2021-04-02 | Effingham | Georgia | 13103 | 4420 | 65 |
1177311 | 1177311 | 2021-04-01 | Effingham | Georgia | 13103 | 4408 | 65 |
1174064 | 1174064 | 2021-03-31 | Effingham | Georgia | 13103 | 4408 | 65 |
1170817 | 1170817 | 2021-03-30 | Effingham | Georgia | 13103 | 4407 | 65 |
1167569 | 1167569 | 2021-03-29 | Effingham | Georgia | 13103 | 4401 | 65 |
1164321 | 1164321 | 2021-03-28 | Effingham | Georgia | 13103 | 4399 | 65 |
1161073 | 1161073 | 2021-03-27 | Effingham | Georgia | 13103 | 4393 | 65 |
1157825 | 1157825 | 2021-03-26 | Effingham | Georgia | 13103 | 4384 | 65 |
1154578 | 1154578 | 2021-03-25 | Effingham | Georgia | 13103 | 4378 | 64 |
1151331 | 1151331 | 2021-03-24 | Effingham | Georgia | 13103 | 4370 | 63 |
1148084 | 1148084 | 2021-03-23 | Effingham | Georgia | 13103 | 4360 | 62 |
1144837 | 1144837 | 2021-03-22 | Effingham | Georgia | 13103 | 4349 | 62 |
1141590 | 1141590 | 2021-03-21 | Effingham | Georgia | 13103 | 4343 | 62 |
1138344 | 1138344 | 2021-03-20 | Effingham | Georgia | 13103 | 4339 | 62 |
1135098 | 1135098 | 2021-03-19 | Effingham | Georgia | 13103 | 4312 | 62 |
1131851 | 1131851 | 2021-03-18 | Effingham | Georgia | 13103 | 4311 | 62 |
1128603 | 1128603 | 2021-03-17 | Effingham | Georgia | 13103 | 4298 | 61 |
1125357 | 1125357 | 2021-03-16 | Effingham | Georgia | 13103 | 4369 | 63 |
1122111 | 1122111 | 2021-03-15 | Effingham | Georgia | 13103 | 4367 | 64 |
1118864 | 1118864 | 2021-03-14 | Effingham | Georgia | 13103 | 4366 | 63 |
1115617 | 1115617 | 2021-03-13 | Effingham | Georgia | 13103 | 4352 | 63 |
1112371 | 1112371 | 2021-03-12 | Effingham | Georgia | 13103 | 4330 | 63 |
1109125 | 1109125 | 2021-03-11 | Effingham | Georgia | 13103 | 4321 | 63 |
1105879 | 1105879 | 2021-03-10 | Effingham | Georgia | 13103 | 4312 | 63 |
1102633 | 1102633 | 2021-03-09 | Effingham | Georgia | 13103 | 4303 | 63 |
1099387 | 1099387 | 2021-03-08 | Effingham | Georgia | 13103 | 4299 | 63 |
1096139 | 1096139 | 2021-03-07 | Effingham | Georgia | 13103 | 4306 | 63 |
1092893 | 1092893 | 2021-03-06 | Effingham | Georgia | 13103 | 4301 | 63 |
1089647 | 1089647 | 2021-03-05 | Effingham | Georgia | 13103 | 4300 | 62 |
1086402 | 1086402 | 2021-03-04 | Effingham | Georgia | 13103 | 4275 | 61 |
1083156 | 1083156 | 2021-03-03 | Effingham | Georgia | 13103 | 4258 | 61 |
1079910 | 1079910 | 2021-03-02 | Effingham | Georgia | 13103 | 4245 | 61 |
1076665 | 1076665 | 2021-03-01 | Effingham | Georgia | 13103 | 4235 | 60 |
1073419 | 1073419 | 2021-02-28 | Effingham | Georgia | 13103 | 4225 | 60 |
1070173 | 1070173 | 2021-02-27 | Effingham | Georgia | 13103 | 4210 | 60 |
1066928 | 1066928 | 2021-02-26 | Effingham | Georgia | 13103 | 4194 | 60 |
1063683 | 1063683 | 2021-02-25 | Effingham | Georgia | 13103 | 4170 | 60 |
1060438 | 1060438 | 2021-02-24 | Effingham | Georgia | 13103 | 4148 | 58 |
1057192 | 1057192 | 2021-02-23 | Effingham | Georgia | 13103 | 4123 | 57 |
1053946 | 1053946 | 2021-02-22 | Effingham | Georgia | 13103 | 4107 | 56 |
1050699 | 1050699 | 2021-02-21 | Effingham | Georgia | 13103 | 4101 | 56 |
1047452 | 1047452 | 2021-02-20 | Effingham | Georgia | 13103 | 4087 | 56 |
1044207 | 1044207 | 2021-02-19 | Effingham | Georgia | 13103 | 4058 | 56 |
1040962 | 1040962 | 2021-02-18 | Effingham | Georgia | 13103 | 4048 | 56 |
1037717 | 1037717 | 2021-02-17 | Effingham | Georgia | 13103 | 4021 | 55 |
1034472 | 1034472 | 2021-02-16 | Effingham | Georgia | 13103 | 3988 | 54 |
1031226 | 1031226 | 2021-02-15 | Effingham | Georgia | 13103 | 3968 | 54 |
1027979 | 1027979 | 2021-02-14 | Effingham | Georgia | 13103 | 3962 | 54 |
1024734 | 1024734 | 2021-02-13 | Effingham | Georgia | 13103 | 3952 | 54 |
1021489 | 1021489 | 2021-02-12 | Effingham | Georgia | 13103 | 3929 | 54 |
1018244 | 1018244 | 2021-02-11 | Effingham | Georgia | 13103 | 3905 | 54 |
1014999 | 1014999 | 2021-02-10 | Effingham | Georgia | 13103 | 3882 | 52 |
1011754 | 1011754 | 2021-02-09 | Effingham | Georgia | 13103 | 3842 | 52 |
1008508 | 1008508 | 2021-02-08 | Effingham | Georgia | 13103 | 3805 | 51 |
1005262 | 1005262 | 2021-02-07 | Effingham | Georgia | 13103 | 3804 | 50 |
1002016 | 1002016 | 2021-02-06 | Effingham | Georgia | 13103 | 3775 | 50 |
998770 | 998770 | 2021-02-05 | Effingham | Georgia | 13103 | 3745 | 49 |
995524 | 995524 | 2021-02-04 | Effingham | Georgia | 13103 | 3724 | 49 |
992278 | 992278 | 2021-02-03 | Effingham | Georgia | 13103 | 3691 | 48 |
989032 | 989032 | 2021-02-02 | Effingham | Georgia | 13103 | 3650 | 48 |
985785 | 985785 | 2021-02-01 | Effingham | Georgia | 13103 | 3633 | 48 |
982538 | 982538 | 2021-01-31 | Effingham | Georgia | 13103 | 3629 | 48 |
979292 | 979292 | 2021-01-30 | Effingham | Georgia | 13103 | 3606 | 48 |
976047 | 976047 | 2021-01-29 | Effingham | Georgia | 13103 | 3566 | 48 |
972802 | 972802 | 2021-01-28 | Effingham | Georgia | 13103 | 3522 | 47 |
969557 | 969557 | 2021-01-27 | Effingham | Georgia | 13103 | 3471 | 46 |
966313 | 966313 | 2021-01-26 | Effingham | Georgia | 13103 | 3438 | 46 |
963068 | 963068 | 2021-01-25 | Effingham | Georgia | 13103 | 3400 | 45 |
959823 | 959823 | 2021-01-24 | Effingham | Georgia | 13103 | 3390 | 45 |
956577 | 956577 | 2021-01-23 | Effingham | Georgia | 13103 | 3371 | 45 |
953332 | 953332 | 2021-01-22 | Effingham | Georgia | 13103 | 3344 | 44 |
950087 | 950087 | 2021-01-21 | Effingham | Georgia | 13103 | 3306 | 42 |
946841 | 946841 | 2021-01-20 | Effingham | Georgia | 13103 | 3270 | 40 |
943594 | 943594 | 2021-01-19 | Effingham | Georgia | 13103 | 3219 | 40 |
940349 | 940349 | 2021-01-18 | Effingham | Georgia | 13103 | 3187 | 38 |
937104 | 937104 | 2021-01-17 | Effingham | Georgia | 13103 | 3176 | 38 |
933859 | 933859 | 2021-01-16 | Effingham | Georgia | 13103 | 3156 | 38 |
930614 | 930614 | 2021-01-15 | Effingham | Georgia | 13103 | 3101 | 38 |
927369 | 927369 | 2021-01-14 | Effingham | Georgia | 13103 | 3050 | 37 |
924123 | 924123 | 2021-01-13 | Effingham | Georgia | 13103 | 3027 | 37 |
920878 | 920878 | 2021-01-12 | Effingham | Georgia | 13103 | 2994 | 37 |
917633 | 917633 | 2021-01-11 | Effingham | Georgia | 13103 | 2967 | 37 |
914388 | 914388 | 2021-01-10 | Effingham | Georgia | 13103 | 2950 | 37 |
911143 | 911143 | 2021-01-09 | Effingham | Georgia | 13103 | 2931 | 37 |
907898 | 907898 | 2021-01-08 | Effingham | Georgia | 13103 | 2903 | 37 |
904652 | 904652 | 2021-01-07 | Effingham | Georgia | 13103 | 2851 | 37 |
901407 | 901407 | 2021-01-06 | Effingham | Georgia | 13103 | 2829 | 37 |
898162 | 898162 | 2021-01-05 | Effingham | Georgia | 13103 | 2800 | 36 |
894917 | 894917 | 2021-01-04 | Effingham | Georgia | 13103 | 2784 | 36 |
891670 | 891670 | 2021-01-03 | Effingham | Georgia | 13103 | 2765 | 35 |
888423 | 888423 | 2021-01-02 | Effingham | Georgia | 13103 | 2743 | 35 |
885178 | 885178 | 2021-01-01 | Effingham | Georgia | 13103 | 2722 | 35 |
881933 | 881933 | 2020-12-31 | Effingham | Georgia | 13103 | 2702 | 35 |
878688 | 878688 | 2020-12-30 | Effingham | Georgia | 13103 | 2659 | 35 |
875443 | 875443 | 2020-12-29 | Effingham | Georgia | 13103 | 2622 | 35 |
872198 | 872198 | 2020-12-28 | Effingham | Georgia | 13103 | 2598 | 35 |
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);