ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Virginia Beach city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388956 | 388956 | 2020-07-31 | Virginia Beach city | Virginia | 51810 | 4055 | 45 |
385739 | 385739 | 2020-07-30 | Virginia Beach city | Virginia | 51810 | 3979 | 43 |
382521 | 382521 | 2020-07-29 | Virginia Beach city | Virginia | 51810 | 3908 | 43 |
379304 | 379304 | 2020-07-28 | Virginia Beach city | Virginia | 51810 | 3788 | 43 |
376088 | 376088 | 2020-07-27 | Virginia Beach city | Virginia | 51810 | 3742 | 43 |
372874 | 372874 | 2020-07-26 | Virginia Beach city | Virginia | 51810 | 3548 | 43 |
369662 | 369662 | 2020-07-25 | Virginia Beach city | Virginia | 51810 | 3448 | 43 |
366453 | 366453 | 2020-07-24 | Virginia Beach city | Virginia | 51810 | 3119 | 41 |
363247 | 363247 | 2020-07-23 | Virginia Beach city | Virginia | 51810 | 3030 | 39 |
360041 | 360041 | 2020-07-22 | Virginia Beach city | Virginia | 51810 | 2968 | 39 |
356836 | 356836 | 2020-07-21 | Virginia Beach city | Virginia | 51810 | 2829 | 38 |
353633 | 353633 | 2020-07-20 | Virginia Beach city | Virginia | 51810 | 2720 | 37 |
350431 | 350431 | 2020-07-19 | Virginia Beach city | Virginia | 51810 | 2610 | 37 |
347230 | 347230 | 2020-07-18 | Virginia Beach city | Virginia | 51810 | 2464 | 36 |
344030 | 344030 | 2020-07-17 | Virginia Beach city | Virginia | 51810 | 2396 | 34 |
340831 | 340831 | 2020-07-16 | Virginia Beach city | Virginia | 51810 | 2272 | 34 |
337635 | 337635 | 2020-07-15 | Virginia Beach city | Virginia | 51810 | 2137 | 34 |
334440 | 334440 | 2020-07-14 | Virginia Beach city | Virginia | 51810 | 1993 | 32 |
331247 | 331247 | 2020-07-13 | Virginia Beach city | Virginia | 51810 | 1978 | 32 |
328061 | 328061 | 2020-07-12 | Virginia Beach city | Virginia | 51810 | 1821 | 30 |
324876 | 324876 | 2020-07-11 | Virginia Beach city | Virginia | 51810 | 1759 | 30 |
321695 | 321695 | 2020-07-10 | Virginia Beach city | Virginia | 51810 | 1663 | 30 |
318516 | 318516 | 2020-07-09 | Virginia Beach city | Virginia | 51810 | 1547 | 30 |
315343 | 315343 | 2020-07-08 | Virginia Beach city | Virginia | 51810 | 1520 | 30 |
312168 | 312168 | 2020-07-07 | Virginia Beach city | Virginia | 51810 | 1455 | 30 |
308999 | 308999 | 2020-07-06 | Virginia Beach city | Virginia | 51810 | 1392 | 30 |
305831 | 305831 | 2020-07-05 | Virginia Beach city | Virginia | 51810 | 1350 | 30 |
302667 | 302667 | 2020-07-04 | Virginia Beach city | Virginia | 51810 | 1300 | 30 |
299503 | 299503 | 2020-07-03 | Virginia Beach city | Virginia | 51810 | 1254 | 30 |
296341 | 296341 | 2020-07-02 | Virginia Beach city | Virginia | 51810 | 1225 | 30 |
293186 | 293186 | 2020-07-01 | Virginia Beach city | Virginia | 51810 | 1203 | 29 |
290033 | 290033 | 2020-06-30 | Virginia Beach city | Virginia | 51810 | 1176 | 29 |
286883 | 286883 | 2020-06-29 | Virginia Beach city | Virginia | 51810 | 1145 | 29 |
283737 | 283737 | 2020-06-28 | Virginia Beach city | Virginia | 51810 | 1123 | 29 |
280591 | 280591 | 2020-06-27 | Virginia Beach city | Virginia | 51810 | 1092 | 29 |
277443 | 277443 | 2020-06-26 | Virginia Beach city | Virginia | 51810 | 1082 | 28 |
274295 | 274295 | 2020-06-25 | Virginia Beach city | Virginia | 51810 | 1053 | 27 |
271155 | 271155 | 2020-06-24 | Virginia Beach city | Virginia | 51810 | 1038 | 27 |
268021 | 268021 | 2020-06-23 | Virginia Beach city | Virginia | 51810 | 1020 | 27 |
264892 | 264892 | 2020-06-22 | Virginia Beach city | Virginia | 51810 | 1006 | 27 |
261763 | 261763 | 2020-06-21 | Virginia Beach city | Virginia | 51810 | 988 | 27 |
258636 | 258636 | 2020-06-20 | Virginia Beach city | Virginia | 51810 | 956 | 27 |
255509 | 255509 | 2020-06-19 | Virginia Beach city | Virginia | 51810 | 950 | 27 |
252390 | 252390 | 2020-06-18 | Virginia Beach city | Virginia | 51810 | 936 | 27 |
249275 | 249275 | 2020-06-17 | Virginia Beach city | Virginia | 51810 | 923 | 28 |
246163 | 246163 | 2020-06-16 | Virginia Beach city | Virginia | 51810 | 909 | 27 |
243050 | 243050 | 2020-06-15 | Virginia Beach city | Virginia | 51810 | 899 | 27 |
239939 | 239939 | 2020-06-14 | Virginia Beach city | Virginia | 51810 | 890 | 27 |
236831 | 236831 | 2020-06-13 | Virginia Beach city | Virginia | 51810 | 869 | 27 |
233724 | 233724 | 2020-06-12 | Virginia Beach city | Virginia | 51810 | 847 | 27 |
230619 | 230619 | 2020-06-11 | Virginia Beach city | Virginia | 51810 | 832 | 27 |
227515 | 227515 | 2020-06-10 | Virginia Beach city | Virginia | 51810 | 823 | 27 |
224415 | 224415 | 2020-06-09 | Virginia Beach city | Virginia | 51810 | 815 | 27 |
221319 | 221319 | 2020-06-08 | Virginia Beach city | Virginia | 51810 | 810 | 25 |
218227 | 218227 | 2020-06-07 | Virginia Beach city | Virginia | 51810 | 801 | 25 |
215137 | 215137 | 2020-06-06 | Virginia Beach city | Virginia | 51810 | 798 | 25 |
212050 | 212050 | 2020-06-05 | Virginia Beach city | Virginia | 51810 | 784 | 25 |
208965 | 208965 | 2020-06-04 | Virginia Beach city | Virginia | 51810 | 770 | 24 |
205883 | 205883 | 2020-06-03 | Virginia Beach city | Virginia | 51810 | 752 | 23 |
202804 | 202804 | 2020-06-02 | Virginia Beach city | Virginia | 51810 | 752 | 23 |
199728 | 199728 | 2020-06-01 | Virginia Beach city | Virginia | 51810 | 745 | 23 |
196655 | 196655 | 2020-05-31 | Virginia Beach city | Virginia | 51810 | 708 | 23 |
193585 | 193585 | 2020-05-30 | Virginia Beach city | Virginia | 51810 | 699 | 23 |
190519 | 190519 | 2020-05-29 | Virginia Beach city | Virginia | 51810 | 680 | 23 |
187455 | 187455 | 2020-05-28 | Virginia Beach city | Virginia | 51810 | 662 | 22 |
184398 | 184398 | 2020-05-27 | Virginia Beach city | Virginia | 51810 | 646 | 22 |
181347 | 181347 | 2020-05-26 | Virginia Beach city | Virginia | 51810 | 638 | 23 |
178303 | 178303 | 2020-05-25 | Virginia Beach city | Virginia | 51810 | 618 | 20 |
175258 | 175258 | 2020-05-24 | Virginia Beach city | Virginia | 51810 | 603 | 19 |
172215 | 172215 | 2020-05-23 | Virginia Beach city | Virginia | 51810 | 598 | 19 |
169174 | 169174 | 2020-05-22 | Virginia Beach city | Virginia | 51810 | 591 | 19 |
166138 | 166138 | 2020-05-21 | Virginia Beach city | Virginia | 51810 | 584 | 19 |
163109 | 163109 | 2020-05-20 | Virginia Beach city | Virginia | 51810 | 564 | 19 |
160081 | 160081 | 2020-05-19 | Virginia Beach city | Virginia | 51810 | 559 | 19 |
157057 | 157057 | 2020-05-18 | Virginia Beach city | Virginia | 51810 | 557 | 19 |
154040 | 154040 | 2020-05-17 | Virginia Beach city | Virginia | 51810 | 548 | 19 |
151029 | 151029 | 2020-05-16 | Virginia Beach city | Virginia | 51810 | 539 | 19 |
148020 | 148020 | 2020-05-15 | Virginia Beach city | Virginia | 51810 | 535 | 19 |
145017 | 145017 | 2020-05-14 | Virginia Beach city | Virginia | 51810 | 528 | 19 |
142020 | 142020 | 2020-05-13 | Virginia Beach city | Virginia | 51810 | 519 | 18 |
139024 | 139024 | 2020-05-12 | Virginia Beach city | Virginia | 51810 | 509 | 18 |
136033 | 136033 | 2020-05-11 | Virginia Beach city | Virginia | 51810 | 505 | 17 |
133043 | 133043 | 2020-05-10 | Virginia Beach city | Virginia | 51810 | 491 | 17 |
130053 | 130053 | 2020-05-09 | Virginia Beach city | Virginia | 51810 | 478 | 17 |
127063 | 127063 | 2020-05-08 | Virginia Beach city | Virginia | 51810 | 469 | 17 |
124078 | 124078 | 2020-05-07 | Virginia Beach city | Virginia | 51810 | 454 | 17 |
121098 | 121098 | 2020-05-06 | Virginia Beach city | Virginia | 51810 | 445 | 15 |
118134 | 118134 | 2020-05-05 | Virginia Beach city | Virginia | 51810 | 445 | 15 |
115175 | 115175 | 2020-05-04 | Virginia Beach city | Virginia | 51810 | 439 | 15 |
112292 | 112292 | 2020-05-03 | Virginia Beach city | Virginia | 51810 | 413 | 15 |
109418 | 109418 | 2020-05-02 | Virginia Beach city | Virginia | 51810 | 413 | 15 |
106549 | 106549 | 2020-05-01 | Virginia Beach city | Virginia | 51810 | 396 | 14 |
103685 | 103685 | 2020-04-30 | Virginia Beach city | Virginia | 51810 | 385 | 14 |
100830 | 100830 | 2020-04-29 | Virginia Beach city | Virginia | 51810 | 365 | 12 |
97980 | 97980 | 2020-04-28 | Virginia Beach city | Virginia | 51810 | 359 | 12 |
95135 | 95135 | 2020-04-27 | Virginia Beach city | Virginia | 51810 | 355 | 10 |
92306 | 92306 | 2020-04-26 | Virginia Beach city | Virginia | 51810 | 345 | 10 |
89489 | 89489 | 2020-04-25 | Virginia Beach city | Virginia | 51810 | 335 | 10 |
86674 | 86674 | 2020-04-24 | Virginia Beach city | Virginia | 51810 | 331 | 10 |
83867 | 83867 | 2020-04-23 | Virginia Beach city | Virginia | 51810 | 328 | 8 |
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);