ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,028 rows where state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Virginia · 323 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
17995 | 17995 | 2021-01-23 | Virginia | 51 | 468655 | 6079 |
17940 | 17940 | 2021-01-22 | Virginia | 51 | 463751 | 6002 |
17885 | 17885 | 2021-01-21 | Virginia | 51 | 459604 | 5940 |
17830 | 17830 | 2021-01-20 | Virginia | 51 | 455591 | 5861 |
17775 | 17775 | 2021-01-19 | Virginia | 51 | 451076 | 5798 |
17720 | 17720 | 2021-01-18 | Virginia | 51 | 446550 | 5739 |
17665 | 17665 | 2021-01-17 | Virginia | 51 | 439305 | 5729 |
17610 | 17610 | 2021-01-16 | Virginia | 51 | 429391 | 5706 |
17555 | 17555 | 2021-01-15 | Virginia | 51 | 422634 | 5656 |
17500 | 17500 | 2021-01-14 | Virginia | 51 | 417839 | 5626 |
17445 | 17445 | 2021-01-13 | Virginia | 51 | 412545 | 5552 |
17390 | 17390 | 2021-01-12 | Virginia | 51 | 407947 | 5477 |
17335 | 17335 | 2021-01-11 | Virginia | 51 | 403386 | 5393 |
17280 | 17280 | 2021-01-10 | Virginia | 51 | 398856 | 5383 |
17225 | 17225 | 2021-01-09 | Virginia | 51 | 393715 | 5381 |
17170 | 17170 | 2021-01-08 | Virginia | 51 | 387917 | 5312 |
17115 | 17115 | 2021-01-07 | Virginia | 51 | 382679 | 5275 |
17060 | 17060 | 2021-01-06 | Virginia | 51 | 377300 | 5226 |
17005 | 17005 | 2021-01-05 | Virginia | 51 | 371913 | 5191 |
16950 | 16950 | 2021-01-04 | Virginia | 51 | 367536 | 5132 |
16895 | 16895 | 2021-01-03 | Virginia | 51 | 363765 | 5124 |
16840 | 16840 | 2021-01-02 | Virginia | 51 | 358755 | 5117 |
16785 | 16785 | 2021-01-01 | Virginia | 51 | 354766 | 5081 |
16730 | 16730 | 2020-12-31 | Virginia | 51 | 349584 | 5032 |
16675 | 16675 | 2020-12-30 | Virginia | 51 | 344345 | 4984 |
16620 | 16620 | 2020-12-29 | Virginia | 51 | 340297 | 4920 |
16565 | 16565 | 2020-12-28 | Virginia | 51 | 336175 | 4861 |
16510 | 16510 | 2020-12-27 | Virginia | 51 | 333576 | 4854 |
16455 | 16455 | 2020-12-26 | Virginia | 51 | 329577 | 4840 |
16400 | 16400 | 2020-12-25 | Virginia | 51 | 327993 | 4820 |
16345 | 16345 | 2020-12-24 | Virginia | 51 | 323915 | 4791 |
16290 | 16290 | 2020-12-23 | Virginia | 51 | 319133 | 4760 |
16235 | 16235 | 2020-12-22 | Virginia | 51 | 314481 | 4705 |
16180 | 16180 | 2020-12-21 | Virginia | 51 | 310890 | 4654 |
16125 | 16125 | 2020-12-20 | Virginia | 51 | 306848 | 4650 |
16070 | 16070 | 2020-12-19 | Virginia | 51 | 302972 | 4643 |
16015 | 16015 | 2020-12-18 | Virginia | 51 | 299388 | 4598 |
15960 | 15960 | 2020-12-17 | Virginia | 51 | 296093 | 4553 |
15905 | 15905 | 2020-12-16 | Virginia | 51 | 292240 | 4508 |
15850 | 15850 | 2020-12-15 | Virginia | 51 | 288309 | 4470 |
15795 | 15795 | 2020-12-14 | Virginia | 51 | 285149 | 4414 |
15740 | 15740 | 2020-12-13 | Virginia | 51 | 281909 | 4411 |
15685 | 15685 | 2020-12-12 | Virginia | 51 | 278615 | 4409 |
15630 | 15630 | 2020-12-11 | Virginia | 51 | 274438 | 4370 |
15575 | 15575 | 2020-12-10 | Virginia | 51 | 271043 | 4335 |
15520 | 15520 | 2020-12-09 | Virginia | 51 | 267128 | 4281 |
15465 | 15465 | 2020-12-08 | Virginia | 51 | 262730 | 4260 |
15410 | 15410 | 2020-12-07 | Virginia | 51 | 258870 | 4208 |
15355 | 15355 | 2020-12-06 | Virginia | 51 | 255053 | 4200 |
15300 | 15300 | 2020-12-05 | Virginia | 51 | 251173 | 4197 |
15245 | 15245 | 2020-12-04 | Virginia | 51 | 247380 | 4160 |
15190 | 15190 | 2020-12-03 | Virginia | 51 | 244503 | 4147 |
15135 | 15135 | 2020-12-02 | Virginia | 51 | 242480 | 4113 |
15080 | 15080 | 2020-12-01 | Virginia | 51 | 240063 | 4093 |
15025 | 15025 | 2020-11-30 | Virginia | 51 | 237835 | 4062 |
14970 | 14970 | 2020-11-29 | Virginia | 51 | 235942 | 4058 |
14915 | 14915 | 2020-11-28 | Virginia | 51 | 233617 | 4054 |
14860 | 14860 | 2020-11-27 | Virginia | 51 | 230444 | 4044 |
14805 | 14805 | 2020-11-26 | Virginia | 51 | 228900 | 4029 |
14750 | 14750 | 2020-11-25 | Virginia | 51 | 226300 | 4008 |
14695 | 14695 | 2020-11-24 | Virginia | 51 | 223582 | 3979 |
14640 | 14640 | 2020-11-23 | Virginia | 51 | 221038 | 3942 |
14585 | 14585 | 2020-11-22 | Virginia | 51 | 217796 | 3938 |
14530 | 14530 | 2020-11-21 | Virginia | 51 | 215679 | 3938 |
14475 | 14475 | 2020-11-20 | Virginia | 51 | 213331 | 3912 |
14420 | 14420 | 2020-11-19 | Virginia | 51 | 210787 | 3896 |
14365 | 14365 | 2020-11-18 | Virginia | 51 | 208833 | 3860 |
14310 | 14310 | 2020-11-17 | Virginia | 51 | 206762 | 3835 |
14255 | 14255 | 2020-11-16 | Virginia | 51 | 204637 | 3806 |
14200 | 14200 | 2020-11-15 | Virginia | 51 | 201960 | 3800 |
14145 | 14145 | 2020-11-14 | Virginia | 51 | 200799 | 3799 |
14090 | 14090 | 2020-11-13 | Virginia | 51 | 199262 | 3785 |
14035 | 14035 | 2020-11-12 | Virginia | 51 | 198027 | 3758 |
13980 | 13980 | 2020-11-11 | Virginia | 51 | 196506 | 3741 |
13925 | 13925 | 2020-11-10 | Virginia | 51 | 194912 | 3726 |
13870 | 13870 | 2020-11-09 | Virginia | 51 | 193477 | 3713 |
13815 | 13815 | 2020-11-08 | Virginia | 51 | 192175 | 3707 |
13760 | 13760 | 2020-11-07 | Virginia | 51 | 190873 | 3704 |
13705 | 13705 | 2020-11-06 | Virginia | 51 | 188770 | 3682 |
13650 | 13650 | 2020-11-05 | Virginia | 51 | 187202 | 3688 |
13595 | 13595 | 2020-11-04 | Virginia | 51 | 185836 | 3677 |
13540 | 13540 | 2020-11-03 | Virginia | 51 | 184679 | 3666 |
13485 | 13485 | 2020-11-02 | Virginia | 51 | 183418 | 3658 |
13430 | 13430 | 2020-11-01 | Virginia | 51 | 182392 | 3655 |
13375 | 13375 | 2020-10-31 | Virginia | 51 | 181190 | 3654 |
13320 | 13320 | 2020-10-30 | Virginia | 51 | 179639 | 3643 |
13265 | 13265 | 2020-10-29 | Virginia | 51 | 178183 | 3636 |
13210 | 13210 | 2020-10-28 | Virginia | 51 | 176754 | 3616 |
13155 | 13155 | 2020-10-27 | Virginia | 51 | 175409 | 3600 |
13100 | 13100 | 2020-10-26 | Virginia | 51 | 174275 | 3581 |
13045 | 13045 | 2020-10-25 | Virginia | 51 | 173371 | 3579 |
12990 | 12990 | 2020-10-24 | Virginia | 51 | 172372 | 3578 |
12935 | 12935 | 2020-10-23 | Virginia | 51 | 171284 | 3539 |
12880 | 12880 | 2020-10-22 | Virginia | 51 | 170104 | 3524 |
12825 | 12825 | 2020-10-21 | Virginia | 51 | 168772 | 3515 |
12770 | 12770 | 2020-10-20 | Virginia | 51 | 167754 | 3485 |
12715 | 12715 | 2020-10-19 | Virginia | 51 | 166828 | 3457 |
12660 | 12660 | 2020-10-18 | Virginia | 51 | 166138 | 3433 |
12605 | 12605 | 2020-10-17 | Virginia | 51 | 165238 | 3422 |
12550 | 12550 | 2020-10-16 | Virginia | 51 | 164124 | 3408 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );