ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
96 rows where deaths = 7, fips = 51600 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
566515 | 566515 | 2020-09-24 | Fairfax city | Virginia | 51600 | 136 | 7 |
563274 | 563274 | 2020-09-23 | Fairfax city | Virginia | 51600 | 134 | 7 |
560035 | 560035 | 2020-09-22 | Fairfax city | Virginia | 51600 | 135 | 7 |
556799 | 556799 | 2020-09-21 | Fairfax city | Virginia | 51600 | 134 | 7 |
553562 | 553562 | 2020-09-20 | Fairfax city | Virginia | 51600 | 134 | 7 |
550323 | 550323 | 2020-09-19 | Fairfax city | Virginia | 51600 | 134 | 7 |
547084 | 547084 | 2020-09-18 | Fairfax city | Virginia | 51600 | 133 | 7 |
543847 | 543847 | 2020-09-17 | Fairfax city | Virginia | 51600 | 133 | 7 |
540611 | 540611 | 2020-09-16 | Fairfax city | Virginia | 51600 | 132 | 7 |
537374 | 537374 | 2020-09-15 | Fairfax city | Virginia | 51600 | 131 | 7 |
534138 | 534138 | 2020-09-14 | Fairfax city | Virginia | 51600 | 129 | 7 |
530903 | 530903 | 2020-09-13 | Fairfax city | Virginia | 51600 | 128 | 7 |
527666 | 527666 | 2020-09-12 | Fairfax city | Virginia | 51600 | 127 | 7 |
524430 | 524430 | 2020-09-11 | Fairfax city | Virginia | 51600 | 127 | 7 |
521194 | 521194 | 2020-09-10 | Fairfax city | Virginia | 51600 | 126 | 7 |
517957 | 517957 | 2020-09-09 | Fairfax city | Virginia | 51600 | 126 | 7 |
514722 | 514722 | 2020-09-08 | Fairfax city | Virginia | 51600 | 125 | 7 |
511489 | 511489 | 2020-09-07 | Fairfax city | Virginia | 51600 | 125 | 7 |
508256 | 508256 | 2020-09-06 | Fairfax city | Virginia | 51600 | 125 | 7 |
505024 | 505024 | 2020-09-05 | Fairfax city | Virginia | 51600 | 126 | 7 |
501790 | 501790 | 2020-09-04 | Fairfax city | Virginia | 51600 | 124 | 7 |
498556 | 498556 | 2020-09-03 | Fairfax city | Virginia | 51600 | 121 | 7 |
495323 | 495323 | 2020-09-02 | Fairfax city | Virginia | 51600 | 121 | 7 |
492089 | 492089 | 2020-09-01 | Fairfax city | Virginia | 51600 | 122 | 7 |
488856 | 488856 | 2020-08-31 | Fairfax city | Virginia | 51600 | 120 | 7 |
485623 | 485623 | 2020-08-30 | Fairfax city | Virginia | 51600 | 120 | 7 |
482388 | 482388 | 2020-08-29 | Fairfax city | Virginia | 51600 | 120 | 7 |
479154 | 479154 | 2020-08-28 | Fairfax city | Virginia | 51600 | 110 | 7 |
475921 | 475921 | 2020-08-27 | Fairfax city | Virginia | 51600 | 109 | 7 |
472688 | 472688 | 2020-08-26 | Fairfax city | Virginia | 51600 | 109 | 7 |
469456 | 469456 | 2020-08-25 | Fairfax city | Virginia | 51600 | 106 | 7 |
466227 | 466227 | 2020-08-24 | Fairfax city | Virginia | 51600 | 106 | 7 |
462998 | 462998 | 2020-08-23 | Fairfax city | Virginia | 51600 | 106 | 7 |
459769 | 459769 | 2020-08-22 | Fairfax city | Virginia | 51600 | 106 | 7 |
456542 | 456542 | 2020-08-21 | Fairfax city | Virginia | 51600 | 106 | 7 |
453314 | 453314 | 2020-08-20 | Fairfax city | Virginia | 51600 | 105 | 7 |
450086 | 450086 | 2020-08-19 | Fairfax city | Virginia | 51600 | 103 | 7 |
446858 | 446858 | 2020-08-18 | Fairfax city | Virginia | 51600 | 102 | 7 |
443631 | 443631 | 2020-08-17 | Fairfax city | Virginia | 51600 | 103 | 7 |
440405 | 440405 | 2020-08-16 | Fairfax city | Virginia | 51600 | 103 | 7 |
437179 | 437179 | 2020-08-15 | Fairfax city | Virginia | 51600 | 98 | 7 |
433953 | 433953 | 2020-08-14 | Fairfax city | Virginia | 51600 | 93 | 7 |
430728 | 430728 | 2020-08-13 | Fairfax city | Virginia | 51600 | 92 | 7 |
427500 | 427500 | 2020-08-12 | Fairfax city | Virginia | 51600 | 92 | 7 |
424276 | 424276 | 2020-08-11 | Fairfax city | Virginia | 51600 | 91 | 7 |
421055 | 421055 | 2020-08-10 | Fairfax city | Virginia | 51600 | 90 | 7 |
417834 | 417834 | 2020-08-09 | Fairfax city | Virginia | 51600 | 88 | 7 |
414613 | 414613 | 2020-08-08 | Fairfax city | Virginia | 51600 | 85 | 7 |
411393 | 411393 | 2020-08-07 | Fairfax city | Virginia | 51600 | 84 | 7 |
408174 | 408174 | 2020-08-06 | Fairfax city | Virginia | 51600 | 81 | 7 |
404954 | 404954 | 2020-08-05 | Fairfax city | Virginia | 51600 | 82 | 7 |
401736 | 401736 | 2020-08-04 | Fairfax city | Virginia | 51600 | 82 | 7 |
398520 | 398520 | 2020-08-03 | Fairfax city | Virginia | 51600 | 82 | 7 |
395304 | 395304 | 2020-08-02 | Fairfax city | Virginia | 51600 | 81 | 7 |
392088 | 392088 | 2020-08-01 | Fairfax city | Virginia | 51600 | 80 | 7 |
388871 | 388871 | 2020-07-31 | Fairfax city | Virginia | 51600 | 79 | 7 |
385654 | 385654 | 2020-07-30 | Fairfax city | Virginia | 51600 | 81 | 7 |
382436 | 382436 | 2020-07-29 | Fairfax city | Virginia | 51600 | 79 | 7 |
379219 | 379219 | 2020-07-28 | Fairfax city | Virginia | 51600 | 77 | 7 |
376003 | 376003 | 2020-07-27 | Fairfax city | Virginia | 51600 | 76 | 7 |
372789 | 372789 | 2020-07-26 | Fairfax city | Virginia | 51600 | 74 | 7 |
369577 | 369577 | 2020-07-25 | Fairfax city | Virginia | 51600 | 74 | 7 |
366368 | 366368 | 2020-07-24 | Fairfax city | Virginia | 51600 | 73 | 7 |
363162 | 363162 | 2020-07-23 | Fairfax city | Virginia | 51600 | 74 | 7 |
359956 | 359956 | 2020-07-22 | Fairfax city | Virginia | 51600 | 74 | 7 |
356751 | 356751 | 2020-07-21 | Fairfax city | Virginia | 51600 | 73 | 7 |
353548 | 353548 | 2020-07-20 | Fairfax city | Virginia | 51600 | 73 | 7 |
350346 | 350346 | 2020-07-19 | Fairfax city | Virginia | 51600 | 73 | 7 |
347145 | 347145 | 2020-07-18 | Fairfax city | Virginia | 51600 | 73 | 7 |
343945 | 343945 | 2020-07-17 | Fairfax city | Virginia | 51600 | 73 | 7 |
340746 | 340746 | 2020-07-16 | Fairfax city | Virginia | 51600 | 74 | 7 |
337550 | 337550 | 2020-07-15 | Fairfax city | Virginia | 51600 | 74 | 7 |
334355 | 334355 | 2020-07-14 | Fairfax city | Virginia | 51600 | 74 | 7 |
331162 | 331162 | 2020-07-13 | Fairfax city | Virginia | 51600 | 73 | 7 |
327976 | 327976 | 2020-07-12 | Fairfax city | Virginia | 51600 | 72 | 7 |
324791 | 324791 | 2020-07-11 | Fairfax city | Virginia | 51600 | 72 | 7 |
321610 | 321610 | 2020-07-10 | Fairfax city | Virginia | 51600 | 72 | 7 |
318431 | 318431 | 2020-07-09 | Fairfax city | Virginia | 51600 | 72 | 7 |
315258 | 315258 | 2020-07-08 | Fairfax city | Virginia | 51600 | 72 | 7 |
312083 | 312083 | 2020-07-07 | Fairfax city | Virginia | 51600 | 72 | 7 |
308914 | 308914 | 2020-07-06 | Fairfax city | Virginia | 51600 | 71 | 7 |
305746 | 305746 | 2020-07-05 | Fairfax city | Virginia | 51600 | 71 | 7 |
302582 | 302582 | 2020-07-04 | Fairfax city | Virginia | 51600 | 71 | 7 |
299418 | 299418 | 2020-07-03 | Fairfax city | Virginia | 51600 | 70 | 7 |
296256 | 296256 | 2020-07-02 | Fairfax city | Virginia | 51600 | 71 | 7 |
293101 | 293101 | 2020-07-01 | Fairfax city | Virginia | 51600 | 70 | 7 |
289948 | 289948 | 2020-06-30 | Fairfax city | Virginia | 51600 | 70 | 7 |
286798 | 286798 | 2020-06-29 | Fairfax city | Virginia | 51600 | 70 | 7 |
283652 | 283652 | 2020-06-28 | Fairfax city | Virginia | 51600 | 70 | 7 |
280506 | 280506 | 2020-06-27 | Fairfax city | Virginia | 51600 | 70 | 7 |
277358 | 277358 | 2020-06-26 | Fairfax city | Virginia | 51600 | 69 | 7 |
274210 | 274210 | 2020-06-25 | Fairfax city | Virginia | 51600 | 69 | 7 |
271070 | 271070 | 2020-06-24 | Fairfax city | Virginia | 51600 | 69 | 7 |
267936 | 267936 | 2020-06-23 | Fairfax city | Virginia | 51600 | 68 | 7 |
264807 | 264807 | 2020-06-22 | Fairfax city | Virginia | 51600 | 68 | 7 |
249190 | 249190 | 2020-06-17 | Fairfax city | Virginia | 51600 | 68 | 7 |
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);