ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 51760 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280574 | 1280574 | 2021-05-02 | Richmond city | Virginia | 51760 | 16823 | 257 |
1277327 | 1277327 | 2021-05-01 | Richmond city | Virginia | 51760 | 16804 | 257 |
1274080 | 1274080 | 2021-04-30 | Richmond city | Virginia | 51760 | 16777 | 257 |
1270833 | 1270833 | 2021-04-29 | Richmond city | Virginia | 51760 | 16746 | 257 |
1267586 | 1267586 | 2021-04-28 | Richmond city | Virginia | 51760 | 16717 | 257 |
1264339 | 1264339 | 2021-04-27 | Richmond city | Virginia | 51760 | 16692 | 257 |
1261092 | 1261092 | 2021-04-26 | Richmond city | Virginia | 51760 | 16665 | 257 |
1257845 | 1257845 | 2021-04-25 | Richmond city | Virginia | 51760 | 16649 | 257 |
1254598 | 1254598 | 2021-04-24 | Richmond city | Virginia | 51760 | 16638 | 256 |
1251351 | 1251351 | 2021-04-23 | Richmond city | Virginia | 51760 | 16626 | 256 |
1248104 | 1248104 | 2021-04-22 | Richmond city | Virginia | 51760 | 16592 | 256 |
1244857 | 1244857 | 2021-04-21 | Richmond city | Virginia | 51760 | 16549 | 256 |
1241610 | 1241610 | 2021-04-20 | Richmond city | Virginia | 51760 | 16526 | 258 |
1238363 | 1238363 | 2021-04-19 | Richmond city | Virginia | 51760 | 16504 | 256 |
1235116 | 1235116 | 2021-04-18 | Richmond city | Virginia | 51760 | 16466 | 256 |
1231868 | 1231868 | 2021-04-17 | Richmond city | Virginia | 51760 | 16437 | 255 |
1228620 | 1228620 | 2021-04-16 | Richmond city | Virginia | 51760 | 16394 | 255 |
1225372 | 1225372 | 2021-04-15 | Richmond city | Virginia | 51760 | 16354 | 254 |
1222125 | 1222125 | 2021-04-14 | Richmond city | Virginia | 51760 | 16313 | 255 |
1218877 | 1218877 | 2021-04-13 | Richmond city | Virginia | 51760 | 16271 | 255 |
1215629 | 1215629 | 2021-04-12 | Richmond city | Virginia | 51760 | 16232 | 255 |
1212382 | 1212382 | 2021-04-11 | Richmond city | Virginia | 51760 | 16202 | 255 |
1209133 | 1209133 | 2021-04-10 | Richmond city | Virginia | 51760 | 16159 | 255 |
1205885 | 1205885 | 2021-04-09 | Richmond city | Virginia | 51760 | 16123 | 254 |
1202637 | 1202637 | 2021-04-08 | Richmond city | Virginia | 51760 | 16096 | 255 |
1199389 | 1199389 | 2021-04-07 | Richmond city | Virginia | 51760 | 16026 | 253 |
1196140 | 1196140 | 2021-04-06 | Richmond city | Virginia | 51760 | 15991 | 253 |
1192892 | 1192892 | 2021-04-05 | Richmond city | Virginia | 51760 | 15960 | 251 |
1189642 | 1189642 | 2021-04-04 | Richmond city | Virginia | 51760 | 15918 | 248 |
1186395 | 1186395 | 2021-04-03 | Richmond city | Virginia | 51760 | 15897 | 244 |
1183148 | 1183148 | 2021-04-02 | Richmond city | Virginia | 51760 | 15848 | 244 |
1179901 | 1179901 | 2021-04-01 | Richmond city | Virginia | 51760 | 15812 | 243 |
1176654 | 1176654 | 2021-03-31 | Richmond city | Virginia | 51760 | 15773 | 243 |
1173407 | 1173407 | 2021-03-30 | Richmond city | Virginia | 51760 | 15696 | 242 |
1170160 | 1170160 | 2021-03-29 | Richmond city | Virginia | 51760 | 15655 | 243 |
1166912 | 1166912 | 2021-03-28 | Richmond city | Virginia | 51760 | 15623 | 242 |
1163664 | 1163664 | 2021-03-27 | Richmond city | Virginia | 51760 | 15581 | 241 |
1160416 | 1160416 | 2021-03-26 | Richmond city | Virginia | 51760 | 15515 | 241 |
1157168 | 1157168 | 2021-03-25 | Richmond city | Virginia | 51760 | 15478 | 241 |
1153921 | 1153921 | 2021-03-24 | Richmond city | Virginia | 51760 | 15453 | 239 |
1150674 | 1150674 | 2021-03-23 | Richmond city | Virginia | 51760 | 15420 | 239 |
1147427 | 1147427 | 2021-03-22 | Richmond city | Virginia | 51760 | 15405 | 236 |
1144180 | 1144180 | 2021-03-21 | Richmond city | Virginia | 51760 | 15386 | 235 |
1140933 | 1140933 | 2021-03-20 | Richmond city | Virginia | 51760 | 15367 | 234 |
1137687 | 1137687 | 2021-03-19 | Richmond city | Virginia | 51760 | 15340 | 234 |
1134441 | 1134441 | 2021-03-18 | Richmond city | Virginia | 51760 | 15323 | 235 |
1131193 | 1131193 | 2021-03-17 | Richmond city | Virginia | 51760 | 15269 | 234 |
1127946 | 1127946 | 2021-03-16 | Richmond city | Virginia | 51760 | 15250 | 232 |
1124700 | 1124700 | 2021-03-15 | Richmond city | Virginia | 51760 | 15217 | 230 |
1121454 | 1121454 | 2021-03-14 | Richmond city | Virginia | 51760 | 15200 | 227 |
1118207 | 1118207 | 2021-03-13 | Richmond city | Virginia | 51760 | 15165 | 225 |
1114960 | 1114960 | 2021-03-12 | Richmond city | Virginia | 51760 | 15146 | 225 |
1111714 | 1111714 | 2021-03-11 | Richmond city | Virginia | 51760 | 15126 | 224 |
1108468 | 1108468 | 2021-03-10 | Richmond city | Virginia | 51760 | 15110 | 220 |
1105222 | 1105222 | 2021-03-09 | Richmond city | Virginia | 51760 | 15084 | 218 |
1101976 | 1101976 | 2021-03-08 | Richmond city | Virginia | 51760 | 15041 | 218 |
1098730 | 1098730 | 2021-03-07 | Richmond city | Virginia | 51760 | 15021 | 216 |
1095482 | 1095482 | 2021-03-06 | Richmond city | Virginia | 51760 | 14990 | 215 |
1092236 | 1092236 | 2021-03-05 | Richmond city | Virginia | 51760 | 14971 | 214 |
1088990 | 1088990 | 2021-03-04 | Richmond city | Virginia | 51760 | 14938 | 214 |
1085745 | 1085745 | 2021-03-03 | Richmond city | Virginia | 51760 | 14914 | 213 |
1082499 | 1082499 | 2021-03-02 | Richmond city | Virginia | 51760 | 14897 | 203 |
1079253 | 1079253 | 2021-03-01 | Richmond city | Virginia | 51760 | 14849 | 197 |
1076008 | 1076008 | 2021-02-28 | Richmond city | Virginia | 51760 | 14829 | 191 |
1072762 | 1072762 | 2021-02-27 | Richmond city | Virginia | 51760 | 14794 | 186 |
1069516 | 1069516 | 2021-02-26 | Richmond city | Virginia | 51760 | 14747 | 179 |
1066271 | 1066271 | 2021-02-25 | Richmond city | Virginia | 51760 | 14678 | 174 |
1063026 | 1063026 | 2021-02-24 | Richmond city | Virginia | 51760 | 14647 | 171 |
1059781 | 1059781 | 2021-02-23 | Richmond city | Virginia | 51760 | 14577 | 164 |
1056535 | 1056535 | 2021-02-22 | Richmond city | Virginia | 51760 | 14499 | 161 |
1053289 | 1053289 | 2021-02-21 | Richmond city | Virginia | 51760 | 14435 | 152 |
1050042 | 1050042 | 2021-02-20 | Richmond city | Virginia | 51760 | 14380 | 151 |
1046795 | 1046795 | 2021-02-19 | Richmond city | Virginia | 51760 | 14297 | 148 |
1043550 | 1043550 | 2021-02-18 | Richmond city | Virginia | 51760 | 14236 | 148 |
1040305 | 1040305 | 2021-02-17 | Richmond city | Virginia | 51760 | 14159 | 148 |
1037060 | 1037060 | 2021-02-16 | Richmond city | Virginia | 51760 | 14098 | 148 |
1033815 | 1033815 | 2021-02-15 | Richmond city | Virginia | 51760 | 14057 | 148 |
1030569 | 1030569 | 2021-02-14 | Richmond city | Virginia | 51760 | 14023 | 147 |
1027322 | 1027322 | 2021-02-13 | Richmond city | Virginia | 51760 | 13922 | 145 |
1024077 | 1024077 | 2021-02-12 | Richmond city | Virginia | 51760 | 13825 | 145 |
1020832 | 1020832 | 2021-02-11 | Richmond city | Virginia | 51760 | 13723 | 144 |
1017587 | 1017587 | 2021-02-10 | Richmond city | Virginia | 51760 | 13632 | 144 |
1014342 | 1014342 | 2021-02-09 | Richmond city | Virginia | 51760 | 13563 | 143 |
1011097 | 1011097 | 2021-02-08 | Richmond city | Virginia | 51760 | 13478 | 142 |
1007851 | 1007851 | 2021-02-07 | Richmond city | Virginia | 51760 | 13439 | 142 |
1004605 | 1004605 | 2021-02-06 | Richmond city | Virginia | 51760 | 13380 | 143 |
1001359 | 1001359 | 2021-02-05 | Richmond city | Virginia | 51760 | 13252 | 140 |
998113 | 998113 | 2021-02-04 | Richmond city | Virginia | 51760 | 13130 | 139 |
994867 | 994867 | 2021-02-03 | Richmond city | Virginia | 51760 | 13032 | 135 |
991621 | 991621 | 2021-02-02 | Richmond city | Virginia | 51760 | 12942 | 132 |
988375 | 988375 | 2021-02-01 | Richmond city | Virginia | 51760 | 12862 | 132 |
985128 | 985128 | 2021-01-31 | Richmond city | Virginia | 51760 | 12757 | 132 |
981881 | 981881 | 2021-01-30 | Richmond city | Virginia | 51760 | 12685 | 132 |
978635 | 978635 | 2021-01-29 | Richmond city | Virginia | 51760 | 12588 | 131 |
975390 | 975390 | 2021-01-28 | Richmond city | Virginia | 51760 | 12470 | 127 |
972145 | 972145 | 2021-01-27 | Richmond city | Virginia | 51760 | 12321 | 124 |
968900 | 968900 | 2021-01-26 | Richmond city | Virginia | 51760 | 12213 | 123 |
965656 | 965656 | 2021-01-25 | Richmond city | Virginia | 51760 | 12109 | 119 |
962411 | 962411 | 2021-01-24 | Richmond city | Virginia | 51760 | 11978 | 119 |
959166 | 959166 | 2021-01-23 | Richmond city | Virginia | 51760 | 11884 | 119 |
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);