ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Arlington" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420060 | 1420060 | 2021-06-14 | Arlington | Virginia | 51013 | 15293 | 257 |
1416815 | 1416815 | 2021-06-13 | Arlington | Virginia | 51013 | 15292 | 257 |
1413569 | 1413569 | 2021-06-12 | Arlington | Virginia | 51013 | 15288 | 257 |
1410324 | 1410324 | 2021-06-11 | Arlington | Virginia | 51013 | 15287 | 257 |
1407079 | 1407079 | 2021-06-10 | Arlington | Virginia | 51013 | 15288 | 257 |
1403833 | 1403833 | 2021-06-09 | Arlington | Virginia | 51013 | 15290 | 257 |
1400588 | 1400588 | 2021-06-08 | Arlington | Virginia | 51013 | 15295 | 257 |
1397343 | 1397343 | 2021-06-07 | Arlington | Virginia | 51013 | 15296 | 257 |
1394096 | 1394096 | 2021-06-06 | Arlington | Virginia | 51013 | 15293 | 256 |
1390851 | 1390851 | 2021-06-05 | Arlington | Virginia | 51013 | 15293 | 256 |
1387606 | 1387606 | 2021-06-04 | Arlington | Virginia | 51013 | 15293 | 256 |
1384361 | 1384361 | 2021-06-03 | Arlington | Virginia | 51013 | 15294 | 256 |
1381115 | 1381115 | 2021-06-02 | Arlington | Virginia | 51013 | 15291 | 256 |
1377870 | 1377870 | 2021-06-01 | Arlington | Virginia | 51013 | 15292 | 256 |
1374624 | 1374624 | 2021-05-31 | Arlington | Virginia | 51013 | 15291 | 256 |
1371379 | 1371379 | 2021-05-30 | Arlington | Virginia | 51013 | 15293 | 256 |
1368133 | 1368133 | 2021-05-29 | Arlington | Virginia | 51013 | 15290 | 256 |
1364887 | 1364887 | 2021-05-28 | Arlington | Virginia | 51013 | 15288 | 256 |
1361641 | 1361641 | 2021-05-27 | Arlington | Virginia | 51013 | 15282 | 256 |
1358395 | 1358395 | 2021-05-26 | Arlington | Virginia | 51013 | 15284 | 256 |
1355149 | 1355149 | 2021-05-25 | Arlington | Virginia | 51013 | 15287 | 256 |
1351903 | 1351903 | 2021-05-24 | Arlington | Virginia | 51013 | 15287 | 256 |
1348657 | 1348657 | 2021-05-23 | Arlington | Virginia | 51013 | 15289 | 256 |
1345409 | 1345409 | 2021-05-22 | Arlington | Virginia | 51013 | 15289 | 256 |
1342161 | 1342161 | 2021-05-21 | Arlington | Virginia | 51013 | 15285 | 256 |
1338913 | 1338913 | 2021-05-20 | Arlington | Virginia | 51013 | 15284 | 256 |
1335666 | 1335666 | 2021-05-19 | Arlington | Virginia | 51013 | 15279 | 256 |
1332419 | 1332419 | 2021-05-18 | Arlington | Virginia | 51013 | 15272 | 255 |
1329172 | 1329172 | 2021-05-17 | Arlington | Virginia | 51013 | 15272 | 255 |
1325926 | 1325926 | 2021-05-16 | Arlington | Virginia | 51013 | 15266 | 255 |
1322680 | 1322680 | 2021-05-15 | Arlington | Virginia | 51013 | 15258 | 255 |
1319434 | 1319434 | 2021-05-14 | Arlington | Virginia | 51013 | 15252 | 255 |
1316186 | 1316186 | 2021-05-13 | Arlington | Virginia | 51013 | 15246 | 255 |
1312940 | 1312940 | 2021-05-12 | Arlington | Virginia | 51013 | 15242 | 255 |
1309693 | 1309693 | 2021-05-11 | Arlington | Virginia | 51013 | 15239 | 254 |
1306447 | 1306447 | 2021-05-10 | Arlington | Virginia | 51013 | 15231 | 254 |
1303201 | 1303201 | 2021-05-09 | Arlington | Virginia | 51013 | 15226 | 254 |
1299954 | 1299954 | 2021-05-08 | Arlington | Virginia | 51013 | 15214 | 254 |
1296707 | 1296707 | 2021-05-07 | Arlington | Virginia | 51013 | 15198 | 254 |
1293461 | 1293461 | 2021-05-06 | Arlington | Virginia | 51013 | 15171 | 254 |
1290215 | 1290215 | 2021-05-05 | Arlington | Virginia | 51013 | 15156 | 254 |
1286969 | 1286969 | 2021-05-04 | Arlington | Virginia | 51013 | 15135 | 254 |
1283723 | 1283723 | 2021-05-03 | Arlington | Virginia | 51013 | 15130 | 253 |
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 |
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);