ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 51013 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280476 | 1280476 | 2021-05-02 | Arlington | Virginia | 51013 | 15121 | 252 |
1277229 | 1277229 | 2021-05-01 | Arlington | Virginia | 51013 | 15111 | 252 |
1273982 | 1273982 | 2021-04-30 | Arlington | Virginia | 51013 | 15089 | 252 |
1270735 | 1270735 | 2021-04-29 | Arlington | Virginia | 51013 | 15057 | 252 |
1267488 | 1267488 | 2021-04-28 | Arlington | Virginia | 51013 | 15045 | 252 |
1264241 | 1264241 | 2021-04-27 | Arlington | Virginia | 51013 | 15020 | 252 |
1260994 | 1260994 | 2021-04-26 | Arlington | Virginia | 51013 | 15007 | 252 |
1257747 | 1257747 | 2021-04-25 | Arlington | Virginia | 51013 | 14982 | 251 |
1254500 | 1254500 | 2021-04-24 | Arlington | Virginia | 51013 | 14969 | 251 |
1251253 | 1251253 | 2021-04-23 | Arlington | Virginia | 51013 | 14944 | 251 |
1248006 | 1248006 | 2021-04-22 | Arlington | Virginia | 51013 | 14903 | 250 |
1244759 | 1244759 | 2021-04-21 | Arlington | Virginia | 51013 | 14884 | 250 |
1241512 | 1241512 | 2021-04-20 | Arlington | Virginia | 51013 | 14861 | 249 |
1238265 | 1238265 | 2021-04-19 | Arlington | Virginia | 51013 | 14846 | 249 |
1235018 | 1235018 | 2021-04-18 | Arlington | Virginia | 51013 | 14835 | 249 |
1231770 | 1231770 | 2021-04-17 | Arlington | Virginia | 51013 | 14807 | 249 |
1228522 | 1228522 | 2021-04-16 | Arlington | Virginia | 51013 | 14774 | 249 |
1225274 | 1225274 | 2021-04-15 | Arlington | Virginia | 51013 | 14742 | 249 |
1222027 | 1222027 | 2021-04-14 | Arlington | Virginia | 51013 | 14718 | 249 |
1218779 | 1218779 | 2021-04-13 | Arlington | Virginia | 51013 | 14697 | 249 |
1215531 | 1215531 | 2021-04-12 | Arlington | Virginia | 51013 | 14679 | 249 |
1212284 | 1212284 | 2021-04-11 | Arlington | Virginia | 51013 | 14646 | 249 |
1209035 | 1209035 | 2021-04-10 | Arlington | Virginia | 51013 | 14631 | 249 |
1205787 | 1205787 | 2021-04-09 | Arlington | Virginia | 51013 | 14593 | 249 |
1202539 | 1202539 | 2021-04-08 | Arlington | Virginia | 51013 | 14536 | 249 |
1199291 | 1199291 | 2021-04-07 | Arlington | Virginia | 51013 | 14490 | 249 |
1196042 | 1196042 | 2021-04-06 | Arlington | Virginia | 51013 | 14464 | 249 |
1192794 | 1192794 | 2021-04-05 | Arlington | Virginia | 51013 | 14436 | 247 |
1189544 | 1189544 | 2021-04-04 | Arlington | Virginia | 51013 | 14412 | 246 |
1186297 | 1186297 | 2021-04-03 | Arlington | Virginia | 51013 | 14364 | 246 |
1183050 | 1183050 | 2021-04-02 | Arlington | Virginia | 51013 | 14319 | 246 |
1179803 | 1179803 | 2021-04-01 | Arlington | Virginia | 51013 | 14273 | 246 |
1176556 | 1176556 | 2021-03-31 | Arlington | Virginia | 51013 | 14227 | 246 |
1173309 | 1173309 | 2021-03-30 | Arlington | Virginia | 51013 | 14188 | 245 |
1170062 | 1170062 | 2021-03-29 | Arlington | Virginia | 51013 | 14156 | 245 |
1166814 | 1166814 | 2021-03-28 | Arlington | Virginia | 51013 | 14126 | 245 |
1163566 | 1163566 | 2021-03-27 | Arlington | Virginia | 51013 | 14081 | 245 |
1160318 | 1160318 | 2021-03-26 | Arlington | Virginia | 51013 | 14042 | 244 |
1157070 | 1157070 | 2021-03-25 | Arlington | Virginia | 51013 | 13997 | 244 |
1153823 | 1153823 | 2021-03-24 | Arlington | Virginia | 51013 | 13952 | 244 |
1150576 | 1150576 | 2021-03-23 | Arlington | Virginia | 51013 | 13915 | 243 |
1147329 | 1147329 | 2021-03-22 | Arlington | Virginia | 51013 | 13897 | 243 |
1144082 | 1144082 | 2021-03-21 | Arlington | Virginia | 51013 | 13882 | 242 |
1140835 | 1140835 | 2021-03-20 | Arlington | Virginia | 51013 | 13856 | 242 |
1137589 | 1137589 | 2021-03-19 | Arlington | Virginia | 51013 | 13811 | 242 |
1134343 | 1134343 | 2021-03-18 | Arlington | Virginia | 51013 | 13770 | 243 |
1131095 | 1131095 | 2021-03-17 | Arlington | Virginia | 51013 | 13729 | 243 |
1127848 | 1127848 | 2021-03-16 | Arlington | Virginia | 51013 | 13683 | 242 |
1124602 | 1124602 | 2021-03-15 | Arlington | Virginia | 51013 | 13655 | 242 |
1121356 | 1121356 | 2021-03-14 | Arlington | Virginia | 51013 | 13638 | 242 |
1118109 | 1118109 | 2021-03-13 | Arlington | Virginia | 51013 | 13603 | 242 |
1114862 | 1114862 | 2021-03-12 | Arlington | Virginia | 51013 | 13559 | 242 |
1111616 | 1111616 | 2021-03-11 | Arlington | Virginia | 51013 | 13526 | 241 |
1108370 | 1108370 | 2021-03-10 | Arlington | Virginia | 51013 | 13501 | 240 |
1105124 | 1105124 | 2021-03-09 | Arlington | Virginia | 51013 | 13481 | 240 |
1101878 | 1101878 | 2021-03-08 | Arlington | Virginia | 51013 | 13456 | 239 |
1098632 | 1098632 | 2021-03-07 | Arlington | Virginia | 51013 | 13433 | 237 |
1095384 | 1095384 | 2021-03-06 | Arlington | Virginia | 51013 | 13391 | 237 |
1092138 | 1092138 | 2021-03-05 | Arlington | Virginia | 51013 | 13342 | 236 |
1088892 | 1088892 | 2021-03-04 | Arlington | Virginia | 51013 | 13294 | 235 |
1085647 | 1085647 | 2021-03-03 | Arlington | Virginia | 51013 | 13255 | 235 |
1082401 | 1082401 | 2021-03-02 | Arlington | Virginia | 51013 | 13215 | 232 |
1079155 | 1079155 | 2021-03-01 | Arlington | Virginia | 51013 | 13182 | 229 |
1075910 | 1075910 | 2021-02-28 | Arlington | Virginia | 51013 | 13151 | 227 |
1072664 | 1072664 | 2021-02-27 | Arlington | Virginia | 51013 | 13112 | 223 |
1069418 | 1069418 | 2021-02-26 | Arlington | Virginia | 51013 | 13060 | 221 |
1066173 | 1066173 | 2021-02-25 | Arlington | Virginia | 51013 | 13020 | 219 |
1062928 | 1062928 | 2021-02-24 | Arlington | Virginia | 51013 | 12974 | 217 |
1059683 | 1059683 | 2021-02-23 | Arlington | Virginia | 51013 | 12922 | 217 |
1056437 | 1056437 | 2021-02-22 | Arlington | Virginia | 51013 | 12894 | 214 |
1053191 | 1053191 | 2021-02-21 | Arlington | Virginia | 51013 | 12870 | 213 |
1049944 | 1049944 | 2021-02-20 | Arlington | Virginia | 51013 | 12805 | 212 |
1046697 | 1046697 | 2021-02-19 | Arlington | Virginia | 51013 | 12768 | 212 |
1043452 | 1043452 | 2021-02-18 | Arlington | Virginia | 51013 | 12726 | 211 |
1040207 | 1040207 | 2021-02-17 | Arlington | Virginia | 51013 | 12684 | 210 |
1036962 | 1036962 | 2021-02-16 | Arlington | Virginia | 51013 | 12653 | 210 |
1033717 | 1033717 | 2021-02-15 | Arlington | Virginia | 51013 | 12611 | 209 |
1030471 | 1030471 | 2021-02-14 | Arlington | Virginia | 51013 | 12589 | 209 |
1027224 | 1027224 | 2021-02-13 | Arlington | Virginia | 51013 | 12550 | 209 |
1023979 | 1023979 | 2021-02-12 | Arlington | Virginia | 51013 | 12504 | 209 |
1020734 | 1020734 | 2021-02-11 | Arlington | Virginia | 51013 | 12440 | 209 |
1017489 | 1017489 | 2021-02-10 | Arlington | Virginia | 51013 | 12364 | 209 |
1014244 | 1014244 | 2021-02-09 | Arlington | Virginia | 51013 | 12306 | 208 |
1010999 | 1010999 | 2021-02-08 | Arlington | Virginia | 51013 | 12262 | 207 |
1007753 | 1007753 | 2021-02-07 | Arlington | Virginia | 51013 | 12221 | 206 |
1004507 | 1004507 | 2021-02-06 | Arlington | Virginia | 51013 | 12150 | 205 |
1001261 | 1001261 | 2021-02-05 | Arlington | Virginia | 51013 | 12034 | 205 |
998015 | 998015 | 2021-02-04 | Arlington | Virginia | 51013 | 11928 | 204 |
994769 | 994769 | 2021-02-03 | Arlington | Virginia | 51013 | 11867 | 203 |
991523 | 991523 | 2021-02-02 | Arlington | Virginia | 51013 | 11806 | 203 |
988277 | 988277 | 2021-02-01 | Arlington | Virginia | 51013 | 11769 | 201 |
985030 | 985030 | 2021-01-31 | Arlington | Virginia | 51013 | 11691 | 201 |
981783 | 981783 | 2021-01-30 | Arlington | Virginia | 51013 | 11648 | 201 |
978537 | 978537 | 2021-01-29 | Arlington | Virginia | 51013 | 11555 | 200 |
975292 | 975292 | 2021-01-28 | Arlington | Virginia | 51013 | 11487 | 199 |
972047 | 972047 | 2021-01-27 | Arlington | Virginia | 51013 | 11414 | 197 |
968802 | 968802 | 2021-01-26 | Arlington | Virginia | 51013 | 11341 | 197 |
965558 | 965558 | 2021-01-25 | Arlington | Virginia | 51013 | 11269 | 197 |
962313 | 962313 | 2021-01-24 | Arlington | Virginia | 51013 | 11149 | 197 |
959068 | 959068 | 2021-01-23 | Arlington | Virginia | 51013 | 11093 | 196 |
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);