ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 51710 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280554 | 1280554 | 2021-05-02 | Norfolk city | Virginia | 51710 | 17401 | 254 |
1277307 | 1277307 | 2021-05-01 | Norfolk city | Virginia | 51710 | 17380 | 252 |
1274060 | 1274060 | 2021-04-30 | Norfolk city | Virginia | 51710 | 17348 | 252 |
1270813 | 1270813 | 2021-04-29 | Norfolk city | Virginia | 51710 | 17317 | 252 |
1267566 | 1267566 | 2021-04-28 | Norfolk city | Virginia | 51710 | 17291 | 252 |
1264319 | 1264319 | 2021-04-27 | Norfolk city | Virginia | 51710 | 17253 | 252 |
1261072 | 1261072 | 2021-04-26 | Norfolk city | Virginia | 51710 | 17215 | 252 |
1257825 | 1257825 | 2021-04-25 | Norfolk city | Virginia | 51710 | 17196 | 250 |
1254578 | 1254578 | 2021-04-24 | Norfolk city | Virginia | 51710 | 17167 | 248 |
1251331 | 1251331 | 2021-04-23 | Norfolk city | Virginia | 51710 | 17142 | 248 |
1248084 | 1248084 | 2021-04-22 | Norfolk city | Virginia | 51710 | 17107 | 247 |
1244837 | 1244837 | 2021-04-21 | Norfolk city | Virginia | 51710 | 17056 | 245 |
1241590 | 1241590 | 2021-04-20 | Norfolk city | Virginia | 51710 | 17039 | 244 |
1238343 | 1238343 | 2021-04-19 | Norfolk city | Virginia | 51710 | 17019 | 242 |
1235096 | 1235096 | 2021-04-18 | Norfolk city | Virginia | 51710 | 16998 | 242 |
1231848 | 1231848 | 2021-04-17 | Norfolk city | Virginia | 51710 | 16961 | 241 |
1228600 | 1228600 | 2021-04-16 | Norfolk city | Virginia | 51710 | 16920 | 241 |
1225352 | 1225352 | 2021-04-15 | Norfolk city | Virginia | 51710 | 16849 | 241 |
1222105 | 1222105 | 2021-04-14 | Norfolk city | Virginia | 51710 | 16810 | 240 |
1218857 | 1218857 | 2021-04-13 | Norfolk city | Virginia | 51710 | 16764 | 240 |
1215609 | 1215609 | 2021-04-12 | Norfolk city | Virginia | 51710 | 16714 | 240 |
1212362 | 1212362 | 2021-04-11 | Norfolk city | Virginia | 51710 | 16676 | 239 |
1209113 | 1209113 | 2021-04-10 | Norfolk city | Virginia | 51710 | 16632 | 239 |
1205865 | 1205865 | 2021-04-09 | Norfolk city | Virginia | 51710 | 16598 | 239 |
1202617 | 1202617 | 2021-04-08 | Norfolk city | Virginia | 51710 | 16530 | 239 |
1199369 | 1199369 | 2021-04-07 | Norfolk city | Virginia | 51710 | 16470 | 239 |
1196120 | 1196120 | 2021-04-06 | Norfolk city | Virginia | 51710 | 16406 | 239 |
1192872 | 1192872 | 2021-04-05 | Norfolk city | Virginia | 51710 | 16351 | 236 |
1189622 | 1189622 | 2021-04-04 | Norfolk city | Virginia | 51710 | 16320 | 235 |
1186375 | 1186375 | 2021-04-03 | Norfolk city | Virginia | 51710 | 16287 | 235 |
1183128 | 1183128 | 2021-04-02 | Norfolk city | Virginia | 51710 | 16245 | 235 |
1179881 | 1179881 | 2021-04-01 | Norfolk city | Virginia | 51710 | 16208 | 235 |
1176634 | 1176634 | 2021-03-31 | Norfolk city | Virginia | 51710 | 16133 | 235 |
1173387 | 1173387 | 2021-03-30 | Norfolk city | Virginia | 51710 | 16111 | 235 |
1170140 | 1170140 | 2021-03-29 | Norfolk city | Virginia | 51710 | 16059 | 235 |
1166892 | 1166892 | 2021-03-28 | Norfolk city | Virginia | 51710 | 16018 | 235 |
1163644 | 1163644 | 2021-03-27 | Norfolk city | Virginia | 51710 | 15978 | 235 |
1160396 | 1160396 | 2021-03-26 | Norfolk city | Virginia | 51710 | 15911 | 235 |
1157148 | 1157148 | 2021-03-25 | Norfolk city | Virginia | 51710 | 15870 | 234 |
1153901 | 1153901 | 2021-03-24 | Norfolk city | Virginia | 51710 | 15829 | 233 |
1150654 | 1150654 | 2021-03-23 | Norfolk city | Virginia | 51710 | 15781 | 233 |
1147407 | 1147407 | 2021-03-22 | Norfolk city | Virginia | 51710 | 15738 | 231 |
1144160 | 1144160 | 2021-03-21 | Norfolk city | Virginia | 51710 | 15702 | 230 |
1140913 | 1140913 | 2021-03-20 | Norfolk city | Virginia | 51710 | 15657 | 229 |
1137667 | 1137667 | 2021-03-19 | Norfolk city | Virginia | 51710 | 15616 | 228 |
1134421 | 1134421 | 2021-03-18 | Norfolk city | Virginia | 51710 | 15558 | 229 |
1131173 | 1131173 | 2021-03-17 | Norfolk city | Virginia | 51710 | 15503 | 229 |
1127926 | 1127926 | 2021-03-16 | Norfolk city | Virginia | 51710 | 15467 | 228 |
1124680 | 1124680 | 2021-03-15 | Norfolk city | Virginia | 51710 | 15438 | 227 |
1121434 | 1121434 | 2021-03-14 | Norfolk city | Virginia | 51710 | 15407 | 227 |
1118187 | 1118187 | 2021-03-13 | Norfolk city | Virginia | 51710 | 15384 | 227 |
1114940 | 1114940 | 2021-03-12 | Norfolk city | Virginia | 51710 | 15340 | 225 |
1111694 | 1111694 | 2021-03-11 | Norfolk city | Virginia | 51710 | 15288 | 222 |
1108448 | 1108448 | 2021-03-10 | Norfolk city | Virginia | 51710 | 15250 | 221 |
1105202 | 1105202 | 2021-03-09 | Norfolk city | Virginia | 51710 | 15218 | 221 |
1101956 | 1101956 | 2021-03-08 | Norfolk city | Virginia | 51710 | 15178 | 220 |
1098710 | 1098710 | 2021-03-07 | Norfolk city | Virginia | 51710 | 15155 | 217 |
1095462 | 1095462 | 2021-03-06 | Norfolk city | Virginia | 51710 | 15125 | 214 |
1092216 | 1092216 | 2021-03-05 | Norfolk city | Virginia | 51710 | 15079 | 209 |
1088970 | 1088970 | 2021-03-04 | Norfolk city | Virginia | 51710 | 15049 | 205 |
1085725 | 1085725 | 2021-03-03 | Norfolk city | Virginia | 51710 | 15019 | 205 |
1082479 | 1082479 | 2021-03-02 | Norfolk city | Virginia | 51710 | 14970 | 196 |
1079233 | 1079233 | 2021-03-01 | Norfolk city | Virginia | 51710 | 14935 | 195 |
1075988 | 1075988 | 2021-02-28 | Norfolk city | Virginia | 51710 | 14898 | 189 |
1072742 | 1072742 | 2021-02-27 | Norfolk city | Virginia | 51710 | 14838 | 189 |
1069496 | 1069496 | 2021-02-26 | Norfolk city | Virginia | 51710 | 14780 | 183 |
1066251 | 1066251 | 2021-02-25 | Norfolk city | Virginia | 51710 | 14742 | 175 |
1063006 | 1063006 | 2021-02-24 | Norfolk city | Virginia | 51710 | 14686 | 168 |
1059761 | 1059761 | 2021-02-23 | Norfolk city | Virginia | 51710 | 14605 | 166 |
1056515 | 1056515 | 2021-02-22 | Norfolk city | Virginia | 51710 | 14564 | 164 |
1053269 | 1053269 | 2021-02-21 | Norfolk city | Virginia | 51710 | 14532 | 162 |
1050022 | 1050022 | 2021-02-20 | Norfolk city | Virginia | 51710 | 14456 | 160 |
1046775 | 1046775 | 2021-02-19 | Norfolk city | Virginia | 51710 | 14394 | 158 |
1043530 | 1043530 | 2021-02-18 | Norfolk city | Virginia | 51710 | 14311 | 153 |
1040285 | 1040285 | 2021-02-17 | Norfolk city | Virginia | 51710 | 14233 | 153 |
1037040 | 1037040 | 2021-02-16 | Norfolk city | Virginia | 51710 | 14174 | 153 |
1033795 | 1033795 | 2021-02-15 | Norfolk city | Virginia | 51710 | 14130 | 153 |
1030549 | 1030549 | 2021-02-14 | Norfolk city | Virginia | 51710 | 14081 | 153 |
1027302 | 1027302 | 2021-02-13 | Norfolk city | Virginia | 51710 | 13959 | 153 |
1024057 | 1024057 | 2021-02-12 | Norfolk city | Virginia | 51710 | 13878 | 149 |
1020812 | 1020812 | 2021-02-11 | Norfolk city | Virginia | 51710 | 13774 | 149 |
1017567 | 1017567 | 2021-02-10 | Norfolk city | Virginia | 51710 | 13693 | 149 |
1014322 | 1014322 | 2021-02-09 | Norfolk city | Virginia | 51710 | 13623 | 149 |
1011077 | 1011077 | 2021-02-08 | Norfolk city | Virginia | 51710 | 13564 | 149 |
1007831 | 1007831 | 2021-02-07 | Norfolk city | Virginia | 51710 | 13495 | 149 |
1004585 | 1004585 | 2021-02-06 | Norfolk city | Virginia | 51710 | 13437 | 149 |
1001339 | 1001339 | 2021-02-05 | Norfolk city | Virginia | 51710 | 13297 | 148 |
998093 | 998093 | 2021-02-04 | Norfolk city | Virginia | 51710 | 13145 | 147 |
994847 | 994847 | 2021-02-03 | Norfolk city | Virginia | 51710 | 13057 | 145 |
991601 | 991601 | 2021-02-02 | Norfolk city | Virginia | 51710 | 12960 | 142 |
988355 | 988355 | 2021-02-01 | Norfolk city | Virginia | 51710 | 12906 | 142 |
985108 | 985108 | 2021-01-31 | Norfolk city | Virginia | 51710 | 12850 | 142 |
981861 | 981861 | 2021-01-30 | Norfolk city | Virginia | 51710 | 12775 | 142 |
978615 | 978615 | 2021-01-29 | Norfolk city | Virginia | 51710 | 12667 | 141 |
975370 | 975370 | 2021-01-28 | Norfolk city | Virginia | 51710 | 12549 | 141 |
972125 | 972125 | 2021-01-27 | Norfolk city | Virginia | 51710 | 12400 | 139 |
968880 | 968880 | 2021-01-26 | Norfolk city | Virginia | 51710 | 12268 | 136 |
965636 | 965636 | 2021-01-25 | Norfolk city | Virginia | 51710 | 12117 | 136 |
962391 | 962391 | 2021-01-24 | Norfolk city | Virginia | 51710 | 11980 | 136 |
959146 | 959146 | 2021-01-23 | Norfolk city | Virginia | 51710 | 11895 | 136 |
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);