ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Richmond" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054016 | 1054016 | 2021-02-22 | Richmond | Georgia | 13245 | 22444 | 414 |
1050769 | 1050769 | 2021-02-21 | Richmond | Georgia | 13245 | 22412 | 412 |
1047522 | 1047522 | 2021-02-20 | Richmond | Georgia | 13245 | 22368 | 412 |
1044277 | 1044277 | 2021-02-19 | Richmond | Georgia | 13245 | 22301 | 408 |
1041032 | 1041032 | 2021-02-18 | Richmond | Georgia | 13245 | 22239 | 403 |
1037787 | 1037787 | 2021-02-17 | Richmond | Georgia | 13245 | 22168 | 399 |
1034542 | 1034542 | 2021-02-16 | Richmond | Georgia | 13245 | 22080 | 395 |
1031296 | 1031296 | 2021-02-15 | Richmond | Georgia | 13245 | 22057 | 384 |
1028049 | 1028049 | 2021-02-14 | Richmond | Georgia | 13245 | 21992 | 384 |
1024804 | 1024804 | 2021-02-13 | Richmond | Georgia | 13245 | 21908 | 384 |
1021559 | 1021559 | 2021-02-12 | Richmond | Georgia | 13245 | 21767 | 377 |
1018314 | 1018314 | 2021-02-11 | Richmond | Georgia | 13245 | 21708 | 374 |
1015069 | 1015069 | 2021-02-10 | Richmond | Georgia | 13245 | 21566 | 374 |
1011824 | 1011824 | 2021-02-09 | Richmond | Georgia | 13245 | 21506 | 369 |
1008578 | 1008578 | 2021-02-08 | Richmond | Georgia | 13245 | 21437 | 366 |
1005332 | 1005332 | 2021-02-07 | Richmond | Georgia | 13245 | 21305 | 366 |
1002086 | 1002086 | 2021-02-06 | Richmond | Georgia | 13245 | 21275 | 366 |
998840 | 998840 | 2021-02-05 | Richmond | Georgia | 13245 | 21182 | 365 |
995594 | 995594 | 2021-02-04 | Richmond | Georgia | 13245 | 21048 | 364 |
992348 | 992348 | 2021-02-03 | Richmond | Georgia | 13245 | 20885 | 359 |
989102 | 989102 | 2021-02-02 | Richmond | Georgia | 13245 | 20796 | 355 |
985855 | 985855 | 2021-02-01 | Richmond | Georgia | 13245 | 20718 | 348 |
982608 | 982608 | 2021-01-31 | Richmond | Georgia | 13245 | 20530 | 345 |
979362 | 979362 | 2021-01-30 | Richmond | Georgia | 13245 | 20423 | 345 |
976117 | 976117 | 2021-01-29 | Richmond | Georgia | 13245 | 20317 | 334 |
972872 | 972872 | 2021-01-28 | Richmond | Georgia | 13245 | 20184 | 332 |
969627 | 969627 | 2021-01-27 | Richmond | Georgia | 13245 | 19951 | 328 |
966383 | 966383 | 2021-01-26 | Richmond | Georgia | 13245 | 19832 | 327 |
963138 | 963138 | 2021-01-25 | Richmond | Georgia | 13245 | 19700 | 321 |
959893 | 959893 | 2021-01-24 | Richmond | Georgia | 13245 | 19584 | 321 |
956647 | 956647 | 2021-01-23 | Richmond | Georgia | 13245 | 19443 | 321 |
953402 | 953402 | 2021-01-22 | Richmond | Georgia | 13245 | 19281 | 313 |
950157 | 950157 | 2021-01-21 | Richmond | Georgia | 13245 | 19058 | 311 |
946911 | 946911 | 2021-01-20 | Richmond | Georgia | 13245 | 18832 | 308 |
943664 | 943664 | 2021-01-19 | Richmond | Georgia | 13245 | 18638 | 303 |
940419 | 940419 | 2021-01-18 | Richmond | Georgia | 13245 | 18523 | 297 |
937174 | 937174 | 2021-01-17 | Richmond | Georgia | 13245 | 18358 | 292 |
933929 | 933929 | 2021-01-16 | Richmond | Georgia | 13245 | 18124 | 292 |
930684 | 930684 | 2021-01-15 | Richmond | Georgia | 13245 | 17907 | 286 |
927439 | 927439 | 2021-01-14 | Richmond | Georgia | 13245 | 17681 | 284 |
924193 | 924193 | 2021-01-13 | Richmond | Georgia | 13245 | 17406 | 280 |
920948 | 920948 | 2021-01-12 | Richmond | Georgia | 13245 | 17168 | 279 |
917703 | 917703 | 2021-01-11 | Richmond | Georgia | 13245 | 17019 | 278 |
914458 | 914458 | 2021-01-10 | Richmond | Georgia | 13245 | 16786 | 278 |
911213 | 911213 | 2021-01-09 | Richmond | Georgia | 13245 | 16477 | 278 |
907968 | 907968 | 2021-01-08 | Richmond | Georgia | 13245 | 16313 | 268 |
904722 | 904722 | 2021-01-07 | Richmond | Georgia | 13245 | 16032 | 264 |
901477 | 901477 | 2021-01-06 | Richmond | Georgia | 13245 | 15872 | 263 |
898232 | 898232 | 2021-01-05 | Richmond | Georgia | 13245 | 15710 | 259 |
894987 | 894987 | 2021-01-04 | Richmond | Georgia | 13245 | 15415 | 255 |
891740 | 891740 | 2021-01-03 | Richmond | Georgia | 13245 | 15263 | 255 |
888493 | 888493 | 2021-01-02 | Richmond | Georgia | 13245 | 15193 | 253 |
885248 | 885248 | 2021-01-01 | Richmond | Georgia | 13245 | 15055 | 253 |
882003 | 882003 | 2020-12-31 | Richmond | Georgia | 13245 | 14739 | 253 |
878758 | 878758 | 2020-12-30 | Richmond | Georgia | 13245 | 14481 | 252 |
875513 | 875513 | 2020-12-29 | Richmond | Georgia | 13245 | 14262 | 252 |
872268 | 872268 | 2020-12-28 | Richmond | Georgia | 13245 | 14094 | 250 |
869023 | 869023 | 2020-12-27 | Richmond | Georgia | 13245 | 14004 | 250 |
865778 | 865778 | 2020-12-26 | Richmond | Georgia | 13245 | 13968 | 250 |
862533 | 862533 | 2020-12-25 | Richmond | Georgia | 13245 | 13903 | 249 |
859288 | 859288 | 2020-12-24 | Richmond | Georgia | 13245 | 13796 | 246 |
856043 | 856043 | 2020-12-23 | Richmond | Georgia | 13245 | 13592 | 245 |
852798 | 852798 | 2020-12-22 | Richmond | Georgia | 13245 | 13450 | 245 |
849553 | 849553 | 2020-12-21 | Richmond | Georgia | 13245 | 13222 | 245 |
846308 | 846308 | 2020-12-20 | Richmond | Georgia | 13245 | 13196 | 245 |
843062 | 843062 | 2020-12-19 | Richmond | Georgia | 13245 | 13094 | 245 |
839817 | 839817 | 2020-12-18 | Richmond | Georgia | 13245 | 12924 | 242 |
836572 | 836572 | 2020-12-17 | Richmond | Georgia | 13245 | 12742 | 242 |
833326 | 833326 | 2020-12-16 | Richmond | Georgia | 13245 | 12537 | 241 |
830079 | 830079 | 2020-12-15 | Richmond | Georgia | 13245 | 12424 | 239 |
826833 | 826833 | 2020-12-14 | Richmond | Georgia | 13245 | 12287 | 235 |
823586 | 823586 | 2020-12-13 | Richmond | Georgia | 13245 | 12154 | 234 |
820340 | 820340 | 2020-12-12 | Richmond | Georgia | 13245 | 12000 | 234 |
817094 | 817094 | 2020-12-11 | Richmond | Georgia | 13245 | 11854 | 233 |
813848 | 813848 | 2020-12-10 | Richmond | Georgia | 13245 | 11692 | 231 |
810604 | 810604 | 2020-12-09 | Richmond | Georgia | 13245 | 11514 | 231 |
807359 | 807359 | 2020-12-08 | Richmond | Georgia | 13245 | 11420 | 230 |
804114 | 804114 | 2020-12-07 | Richmond | Georgia | 13245 | 11370 | 229 |
800869 | 800869 | 2020-12-06 | Richmond | Georgia | 13245 | 11107 | 227 |
797624 | 797624 | 2020-12-05 | Richmond | Georgia | 13245 | 11084 | 227 |
794379 | 794379 | 2020-12-04 | Richmond | Georgia | 13245 | 10950 | 222 |
791134 | 791134 | 2020-12-03 | Richmond | Georgia | 13245 | 10779 | 222 |
787889 | 787889 | 2020-12-02 | Richmond | Georgia | 13245 | 10592 | 221 |
784645 | 784645 | 2020-12-01 | Richmond | Georgia | 13245 | 10460 | 220 |
781400 | 781400 | 2020-11-30 | Richmond | Georgia | 13245 | 10387 | 220 |
778154 | 778154 | 2020-11-29 | Richmond | Georgia | 13245 | 10332 | 219 |
774909 | 774909 | 2020-11-28 | Richmond | Georgia | 13245 | 10293 | 219 |
771664 | 771664 | 2020-11-27 | Richmond | Georgia | 13245 | 10237 | 218 |
768419 | 768419 | 2020-11-26 | Richmond | Georgia | 13245 | 10142 | 218 |
765173 | 765173 | 2020-11-25 | Richmond | Georgia | 13245 | 10059 | 218 |
761928 | 761928 | 2020-11-24 | Richmond | Georgia | 13245 | 9980 | 215 |
758683 | 758683 | 2020-11-23 | Richmond | Georgia | 13245 | 9915 | 215 |
755436 | 755436 | 2020-11-22 | Richmond | Georgia | 13245 | 9882 | 213 |
752190 | 752190 | 2020-11-21 | Richmond | Georgia | 13245 | 9820 | 211 |
748944 | 748944 | 2020-11-20 | Richmond | Georgia | 13245 | 9744 | 211 |
745698 | 745698 | 2020-11-19 | Richmond | Georgia | 13245 | 9652 | 211 |
742451 | 742451 | 2020-11-18 | Richmond | Georgia | 13245 | 9521 | 212 |
739204 | 739204 | 2020-11-17 | Richmond | Georgia | 13245 | 9475 | 212 |
735960 | 735960 | 2020-11-16 | Richmond | Georgia | 13245 | 9423 | 212 |
732714 | 732714 | 2020-11-15 | Richmond | Georgia | 13245 | 9373 | 212 |
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);