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 |
---|---|---|---|---|---|---|---|
1278054 | 1278054 | 2021-05-02 | Richmond | Georgia | 13245 | 24475 | 502 |
1274807 | 1274807 | 2021-05-01 | Richmond | Georgia | 13245 | 24458 | 502 |
1271560 | 1271560 | 2021-04-30 | Richmond | Georgia | 13245 | 24409 | 502 |
1268313 | 1268313 | 2021-04-29 | Richmond | Georgia | 13245 | 24368 | 502 |
1265066 | 1265066 | 2021-04-28 | Richmond | Georgia | 13245 | 24332 | 499 |
1261819 | 1261819 | 2021-04-27 | Richmond | Georgia | 13245 | 24290 | 495 |
1258572 | 1258572 | 2021-04-26 | Richmond | Georgia | 13245 | 24258 | 495 |
1255325 | 1255325 | 2021-04-25 | Richmond | Georgia | 13245 | 24247 | 495 |
1252078 | 1252078 | 2021-04-24 | Richmond | Georgia | 13245 | 24222 | 494 |
1248831 | 1248831 | 2021-04-23 | Richmond | Georgia | 13245 | 24181 | 494 |
1245584 | 1245584 | 2021-04-22 | Richmond | Georgia | 13245 | 24147 | 492 |
1242337 | 1242337 | 2021-04-21 | Richmond | Georgia | 13245 | 24115 | 492 |
1239090 | 1239090 | 2021-04-20 | Richmond | Georgia | 13245 | 24090 | 491 |
1235843 | 1235843 | 2021-04-19 | Richmond | Georgia | 13245 | 24059 | 491 |
1232596 | 1232596 | 2021-04-18 | Richmond | Georgia | 13245 | 24037 | 490 |
1229347 | 1229347 | 2021-04-17 | Richmond | Georgia | 13245 | 24022 | 490 |
1226099 | 1226099 | 2021-04-16 | Richmond | Georgia | 13245 | 23973 | 490 |
1222852 | 1222852 | 2021-04-15 | Richmond | Georgia | 13245 | 23950 | 489 |
1219604 | 1219604 | 2021-04-14 | Richmond | Georgia | 13245 | 23913 | 485 |
1216356 | 1216356 | 2021-04-13 | Richmond | Georgia | 13245 | 23885 | 482 |
1213109 | 1213109 | 2021-04-12 | Richmond | Georgia | 13245 | 23849 | 482 |
1209861 | 1209861 | 2021-04-11 | Richmond | Georgia | 13245 | 23831 | 481 |
1206612 | 1206612 | 2021-04-10 | Richmond | Georgia | 13245 | 23812 | 481 |
1203364 | 1203364 | 2021-04-09 | Richmond | Georgia | 13245 | 23785 | 480 |
1200116 | 1200116 | 2021-04-08 | Richmond | Georgia | 13245 | 23751 | 480 |
1196867 | 1196867 | 2021-04-07 | Richmond | Georgia | 13245 | 23721 | 477 |
1193619 | 1193619 | 2021-04-06 | Richmond | Georgia | 13245 | 23694 | 476 |
1190369 | 1190369 | 2021-04-05 | Richmond | Georgia | 13245 | 23676 | 476 |
1187122 | 1187122 | 2021-04-04 | Richmond | Georgia | 13245 | 23666 | 476 |
1183875 | 1183875 | 2021-04-03 | Richmond | Georgia | 13245 | 23650 | 475 |
1180628 | 1180628 | 2021-04-02 | Richmond | Georgia | 13245 | 23597 | 474 |
1177381 | 1177381 | 2021-04-01 | Richmond | Georgia | 13245 | 23575 | 474 |
1174134 | 1174134 | 2021-03-31 | Richmond | Georgia | 13245 | 23543 | 472 |
1170887 | 1170887 | 2021-03-30 | Richmond | Georgia | 13245 | 23525 | 469 |
1167639 | 1167639 | 2021-03-29 | Richmond | Georgia | 13245 | 23510 | 469 |
1164391 | 1164391 | 2021-03-28 | Richmond | Georgia | 13245 | 23497 | 468 |
1161143 | 1161143 | 2021-03-27 | Richmond | Georgia | 13245 | 23475 | 468 |
1157895 | 1157895 | 2021-03-26 | Richmond | Georgia | 13245 | 23452 | 468 |
1154648 | 1154648 | 2021-03-25 | Richmond | Georgia | 13245 | 23428 | 462 |
1151401 | 1151401 | 2021-03-24 | Richmond | Georgia | 13245 | 23399 | 461 |
1148154 | 1148154 | 2021-03-23 | Richmond | Georgia | 13245 | 23365 | 458 |
1144907 | 1144907 | 2021-03-22 | Richmond | Georgia | 13245 | 23339 | 458 |
1141660 | 1141660 | 2021-03-21 | Richmond | Georgia | 13245 | 23331 | 458 |
1138414 | 1138414 | 2021-03-20 | Richmond | Georgia | 13245 | 23320 | 458 |
1135168 | 1135168 | 2021-03-19 | Richmond | Georgia | 13245 | 23296 | 456 |
1131921 | 1131921 | 2021-03-18 | Richmond | Georgia | 13245 | 23273 | 455 |
1128673 | 1128673 | 2021-03-17 | Richmond | Georgia | 13245 | 23249 | 453 |
1125427 | 1125427 | 2021-03-16 | Richmond | Georgia | 13245 | 23234 | 452 |
1122181 | 1122181 | 2021-03-15 | Richmond | Georgia | 13245 | 23214 | 452 |
1118934 | 1118934 | 2021-03-14 | Richmond | Georgia | 13245 | 23196 | 452 |
1115687 | 1115687 | 2021-03-13 | Richmond | Georgia | 13245 | 23184 | 452 |
1112441 | 1112441 | 2021-03-12 | Richmond | Georgia | 13245 | 23169 | 451 |
1109195 | 1109195 | 2021-03-11 | Richmond | Georgia | 13245 | 23147 | 451 |
1105949 | 1105949 | 2021-03-10 | Richmond | Georgia | 13245 | 23119 | 447 |
1102703 | 1102703 | 2021-03-09 | Richmond | Georgia | 13245 | 23092 | 446 |
1099457 | 1099457 | 2021-03-08 | Richmond | Georgia | 13245 | 23074 | 444 |
1096209 | 1096209 | 2021-03-07 | Richmond | Georgia | 13245 | 23055 | 443 |
1092963 | 1092963 | 2021-03-06 | Richmond | Georgia | 13245 | 23033 | 443 |
1089717 | 1089717 | 2021-03-05 | Richmond | Georgia | 13245 | 23011 | 440 |
1086472 | 1086472 | 2021-03-04 | Richmond | Georgia | 13245 | 22967 | 438 |
1083226 | 1083226 | 2021-03-03 | Richmond | Georgia | 13245 | 22937 | 435 |
1079980 | 1079980 | 2021-03-02 | Richmond | Georgia | 13245 | 22911 | 431 |
1076735 | 1076735 | 2021-03-01 | Richmond | Georgia | 13245 | 22852 | 429 |
1073489 | 1073489 | 2021-02-28 | Richmond | Georgia | 13245 | 22833 | 425 |
1070243 | 1070243 | 2021-02-27 | Richmond | Georgia | 13245 | 22767 | 425 |
1066998 | 1066998 | 2021-02-26 | Richmond | Georgia | 13245 | 22719 | 425 |
1063753 | 1063753 | 2021-02-25 | Richmond | Georgia | 13245 | 22666 | 425 |
1060508 | 1060508 | 2021-02-24 | Richmond | Georgia | 13245 | 22604 | 418 |
1057262 | 1057262 | 2021-02-23 | Richmond | Georgia | 13245 | 22572 | 416 |
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 |
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);