ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 51041 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280494 | 1280494 | 2021-05-02 | Chesterfield | Virginia | 51041 | 27290 | 423 |
1277247 | 1277247 | 2021-05-01 | Chesterfield | Virginia | 51041 | 27248 | 421 |
1274000 | 1274000 | 2021-04-30 | Chesterfield | Virginia | 51041 | 27202 | 421 |
1270753 | 1270753 | 2021-04-29 | Chesterfield | Virginia | 51041 | 27138 | 419 |
1267506 | 1267506 | 2021-04-28 | Chesterfield | Virginia | 51041 | 27080 | 416 |
1264259 | 1264259 | 2021-04-27 | Chesterfield | Virginia | 51041 | 27027 | 416 |
1261012 | 1261012 | 2021-04-26 | Chesterfield | Virginia | 51041 | 26975 | 413 |
1257765 | 1257765 | 2021-04-25 | Chesterfield | Virginia | 51041 | 26942 | 413 |
1254518 | 1254518 | 2021-04-24 | Chesterfield | Virginia | 51041 | 26892 | 413 |
1251271 | 1251271 | 2021-04-23 | Chesterfield | Virginia | 51041 | 26847 | 413 |
1248024 | 1248024 | 2021-04-22 | Chesterfield | Virginia | 51041 | 26790 | 413 |
1244777 | 1244777 | 2021-04-21 | Chesterfield | Virginia | 51041 | 26735 | 413 |
1241530 | 1241530 | 2021-04-20 | Chesterfield | Virginia | 51041 | 26692 | 411 |
1238283 | 1238283 | 2021-04-19 | Chesterfield | Virginia | 51041 | 26616 | 411 |
1235036 | 1235036 | 2021-04-18 | Chesterfield | Virginia | 51041 | 26566 | 411 |
1231788 | 1231788 | 2021-04-17 | Chesterfield | Virginia | 51041 | 26520 | 411 |
1228540 | 1228540 | 2021-04-16 | Chesterfield | Virginia | 51041 | 26458 | 410 |
1225292 | 1225292 | 2021-04-15 | Chesterfield | Virginia | 51041 | 26390 | 407 |
1222045 | 1222045 | 2021-04-14 | Chesterfield | Virginia | 51041 | 26323 | 406 |
1218797 | 1218797 | 2021-04-13 | Chesterfield | Virginia | 51041 | 26266 | 406 |
1215549 | 1215549 | 2021-04-12 | Chesterfield | Virginia | 51041 | 26150 | 406 |
1212302 | 1212302 | 2021-04-11 | Chesterfield | Virginia | 51041 | 26093 | 405 |
1209053 | 1209053 | 2021-04-10 | Chesterfield | Virginia | 51041 | 26046 | 404 |
1205805 | 1205805 | 2021-04-09 | Chesterfield | Virginia | 51041 | 25979 | 404 |
1202557 | 1202557 | 2021-04-08 | Chesterfield | Virginia | 51041 | 25916 | 404 |
1199309 | 1199309 | 2021-04-07 | Chesterfield | Virginia | 51041 | 25849 | 404 |
1196060 | 1196060 | 2021-04-06 | Chesterfield | Virginia | 51041 | 25795 | 403 |
1192812 | 1192812 | 2021-04-05 | Chesterfield | Virginia | 51041 | 25714 | 400 |
1189562 | 1189562 | 2021-04-04 | Chesterfield | Virginia | 51041 | 25663 | 399 |
1186315 | 1186315 | 2021-04-03 | Chesterfield | Virginia | 51041 | 25603 | 397 |
1183068 | 1183068 | 2021-04-02 | Chesterfield | Virginia | 51041 | 25526 | 397 |
1179821 | 1179821 | 2021-04-01 | Chesterfield | Virginia | 51041 | 25457 | 397 |
1176574 | 1176574 | 2021-03-31 | Chesterfield | Virginia | 51041 | 25404 | 396 |
1173327 | 1173327 | 2021-03-30 | Chesterfield | Virginia | 51041 | 25379 | 396 |
1170080 | 1170080 | 2021-03-29 | Chesterfield | Virginia | 51041 | 25310 | 394 |
1166832 | 1166832 | 2021-03-28 | Chesterfield | Virginia | 51041 | 25271 | 393 |
1163584 | 1163584 | 2021-03-27 | Chesterfield | Virginia | 51041 | 25199 | 390 |
1160336 | 1160336 | 2021-03-26 | Chesterfield | Virginia | 51041 | 25116 | 388 |
1157088 | 1157088 | 2021-03-25 | Chesterfield | Virginia | 51041 | 25047 | 388 |
1153841 | 1153841 | 2021-03-24 | Chesterfield | Virginia | 51041 | 24999 | 388 |
1150594 | 1150594 | 2021-03-23 | Chesterfield | Virginia | 51041 | 24948 | 386 |
1147347 | 1147347 | 2021-03-22 | Chesterfield | Virginia | 51041 | 24892 | 386 |
1144100 | 1144100 | 2021-03-21 | Chesterfield | Virginia | 51041 | 24849 | 385 |
1140853 | 1140853 | 2021-03-20 | Chesterfield | Virginia | 51041 | 24806 | 385 |
1137607 | 1137607 | 2021-03-19 | Chesterfield | Virginia | 51041 | 24731 | 384 |
1134361 | 1134361 | 2021-03-18 | Chesterfield | Virginia | 51041 | 24659 | 383 |
1131113 | 1131113 | 2021-03-17 | Chesterfield | Virginia | 51041 | 24569 | 381 |
1127866 | 1127866 | 2021-03-16 | Chesterfield | Virginia | 51041 | 24494 | 380 |
1124620 | 1124620 | 2021-03-15 | Chesterfield | Virginia | 51041 | 24431 | 379 |
1121374 | 1121374 | 2021-03-14 | Chesterfield | Virginia | 51041 | 24385 | 378 |
1118127 | 1118127 | 2021-03-13 | Chesterfield | Virginia | 51041 | 24323 | 377 |
1114880 | 1114880 | 2021-03-12 | Chesterfield | Virginia | 51041 | 24254 | 376 |
1111634 | 1111634 | 2021-03-11 | Chesterfield | Virginia | 51041 | 24195 | 371 |
1108388 | 1108388 | 2021-03-10 | Chesterfield | Virginia | 51041 | 24137 | 366 |
1105142 | 1105142 | 2021-03-09 | Chesterfield | Virginia | 51041 | 24087 | 365 |
1101896 | 1101896 | 2021-03-08 | Chesterfield | Virginia | 51041 | 23997 | 365 |
1098650 | 1098650 | 2021-03-07 | Chesterfield | Virginia | 51041 | 23960 | 362 |
1095402 | 1095402 | 2021-03-06 | Chesterfield | Virginia | 51041 | 23881 | 359 |
1092156 | 1092156 | 2021-03-05 | Chesterfield | Virginia | 51041 | 23812 | 356 |
1088910 | 1088910 | 2021-03-04 | Chesterfield | Virginia | 51041 | 23757 | 353 |
1085665 | 1085665 | 2021-03-03 | Chesterfield | Virginia | 51041 | 23727 | 352 |
1082419 | 1082419 | 2021-03-02 | Chesterfield | Virginia | 51041 | 23654 | 324 |
1079173 | 1079173 | 2021-03-01 | Chesterfield | Virginia | 51041 | 23594 | 306 |
1075928 | 1075928 | 2021-02-28 | Chesterfield | Virginia | 51041 | 23546 | 298 |
1072682 | 1072682 | 2021-02-27 | Chesterfield | Virginia | 51041 | 23488 | 291 |
1069436 | 1069436 | 2021-02-26 | Chesterfield | Virginia | 51041 | 23402 | 287 |
1066191 | 1066191 | 2021-02-25 | Chesterfield | Virginia | 51041 | 23312 | 269 |
1062946 | 1062946 | 2021-02-24 | Chesterfield | Virginia | 51041 | 23245 | 263 |
1059701 | 1059701 | 2021-02-23 | Chesterfield | Virginia | 51041 | 23172 | 260 |
1056455 | 1056455 | 2021-02-22 | Chesterfield | Virginia | 51041 | 23077 | 246 |
1053209 | 1053209 | 2021-02-21 | Chesterfield | Virginia | 51041 | 23009 | 231 |
1049962 | 1049962 | 2021-02-20 | Chesterfield | Virginia | 51041 | 22919 | 222 |
1046715 | 1046715 | 2021-02-19 | Chesterfield | Virginia | 51041 | 22835 | 216 |
1043470 | 1043470 | 2021-02-18 | Chesterfield | Virginia | 51041 | 22708 | 216 |
1040225 | 1040225 | 2021-02-17 | Chesterfield | Virginia | 51041 | 22643 | 217 |
1036980 | 1036980 | 2021-02-16 | Chesterfield | Virginia | 51041 | 22541 | 216 |
1033735 | 1033735 | 2021-02-15 | Chesterfield | Virginia | 51041 | 22412 | 215 |
1030489 | 1030489 | 2021-02-14 | Chesterfield | Virginia | 51041 | 22270 | 215 |
1027242 | 1027242 | 2021-02-13 | Chesterfield | Virginia | 51041 | 22019 | 216 |
1023997 | 1023997 | 2021-02-12 | Chesterfield | Virginia | 51041 | 21701 | 216 |
1020752 | 1020752 | 2021-02-11 | Chesterfield | Virginia | 51041 | 21469 | 216 |
1017507 | 1017507 | 2021-02-10 | Chesterfield | Virginia | 51041 | 21131 | 216 |
1014262 | 1014262 | 2021-02-09 | Chesterfield | Virginia | 51041 | 20876 | 216 |
1011017 | 1011017 | 2021-02-08 | Chesterfield | Virginia | 51041 | 20654 | 214 |
1007771 | 1007771 | 2021-02-07 | Chesterfield | Virginia | 51041 | 20435 | 214 |
1004525 | 1004525 | 2021-02-06 | Chesterfield | Virginia | 51041 | 20141 | 214 |
1001279 | 1001279 | 2021-02-05 | Chesterfield | Virginia | 51041 | 19944 | 212 |
998033 | 998033 | 2021-02-04 | Chesterfield | Virginia | 51041 | 19697 | 209 |
994787 | 994787 | 2021-02-03 | Chesterfield | Virginia | 51041 | 19563 | 207 |
991541 | 991541 | 2021-02-02 | Chesterfield | Virginia | 51041 | 19449 | 206 |
988295 | 988295 | 2021-02-01 | Chesterfield | Virginia | 51041 | 19294 | 204 |
985048 | 985048 | 2021-01-31 | Chesterfield | Virginia | 51041 | 19150 | 203 |
981801 | 981801 | 2021-01-30 | Chesterfield | Virginia | 51041 | 18969 | 203 |
978555 | 978555 | 2021-01-29 | Chesterfield | Virginia | 51041 | 18802 | 202 |
975310 | 975310 | 2021-01-28 | Chesterfield | Virginia | 51041 | 18648 | 201 |
972065 | 972065 | 2021-01-27 | Chesterfield | Virginia | 51041 | 18451 | 201 |
968820 | 968820 | 2021-01-26 | Chesterfield | Virginia | 51041 | 18235 | 199 |
965576 | 965576 | 2021-01-25 | Chesterfield | Virginia | 51041 | 18005 | 198 |
962331 | 962331 | 2021-01-24 | Chesterfield | Virginia | 51041 | 17706 | 198 |
959086 | 959086 | 2021-01-23 | Chesterfield | Virginia | 51041 | 17542 | 198 |
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);