ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Carroll" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637826 | 637826 | 2020-10-16 | Carroll | Virginia | 51035 | 547 | 25 |
634581 | 634581 | 2020-10-15 | Carroll | Virginia | 51035 | 535 | 25 |
631336 | 631336 | 2020-10-14 | Carroll | Virginia | 51035 | 534 | 25 |
628092 | 628092 | 2020-10-13 | Carroll | Virginia | 51035 | 534 | 25 |
624849 | 624849 | 2020-10-12 | Carroll | Virginia | 51035 | 525 | 25 |
621606 | 621606 | 2020-10-11 | Carroll | Virginia | 51035 | 525 | 25 |
618363 | 618363 | 2020-10-10 | Carroll | Virginia | 51035 | 523 | 25 |
615121 | 615121 | 2020-10-09 | Carroll | Virginia | 51035 | 523 | 25 |
611880 | 611880 | 2020-10-08 | Carroll | Virginia | 51035 | 522 | 25 |
608638 | 608638 | 2020-10-07 | Carroll | Virginia | 51035 | 517 | 25 |
605395 | 605395 | 2020-10-06 | Carroll | Virginia | 51035 | 516 | 24 |
602153 | 602153 | 2020-10-05 | Carroll | Virginia | 51035 | 514 | 24 |
598910 | 598910 | 2020-10-04 | Carroll | Virginia | 51035 | 511 | 24 |
595667 | 595667 | 2020-10-03 | Carroll | Virginia | 51035 | 510 | 24 |
592425 | 592425 | 2020-10-02 | Carroll | Virginia | 51035 | 507 | 24 |
589185 | 589185 | 2020-10-01 | Carroll | Virginia | 51035 | 505 | 24 |
585944 | 585944 | 2020-09-30 | Carroll | Virginia | 51035 | 505 | 24 |
582704 | 582704 | 2020-09-29 | Carroll | Virginia | 51035 | 505 | 24 |
579465 | 579465 | 2020-09-28 | Carroll | Virginia | 51035 | 502 | 24 |
576224 | 576224 | 2020-09-27 | Carroll | Virginia | 51035 | 500 | 24 |
572980 | 572980 | 2020-09-26 | Carroll | Virginia | 51035 | 499 | 24 |
569738 | 569738 | 2020-09-25 | Carroll | Virginia | 51035 | 492 | 24 |
566497 | 566497 | 2020-09-24 | Carroll | Virginia | 51035 | 489 | 24 |
563256 | 563256 | 2020-09-23 | Carroll | Virginia | 51035 | 488 | 23 |
560017 | 560017 | 2020-09-22 | Carroll | Virginia | 51035 | 486 | 23 |
556781 | 556781 | 2020-09-21 | Carroll | Virginia | 51035 | 481 | 23 |
553544 | 553544 | 2020-09-20 | Carroll | Virginia | 51035 | 480 | 23 |
550305 | 550305 | 2020-09-19 | Carroll | Virginia | 51035 | 474 | 22 |
547066 | 547066 | 2020-09-18 | Carroll | Virginia | 51035 | 468 | 21 |
543829 | 543829 | 2020-09-17 | Carroll | Virginia | 51035 | 465 | 21 |
540593 | 540593 | 2020-09-16 | Carroll | Virginia | 51035 | 465 | 21 |
537356 | 537356 | 2020-09-15 | Carroll | Virginia | 51035 | 463 | 21 |
534120 | 534120 | 2020-09-14 | Carroll | Virginia | 51035 | 461 | 20 |
530885 | 530885 | 2020-09-13 | Carroll | Virginia | 51035 | 460 | 19 |
527648 | 527648 | 2020-09-12 | Carroll | Virginia | 51035 | 457 | 19 |
524412 | 524412 | 2020-09-11 | Carroll | Virginia | 51035 | 452 | 19 |
521176 | 521176 | 2020-09-10 | Carroll | Virginia | 51035 | 450 | 19 |
517939 | 517939 | 2020-09-09 | Carroll | Virginia | 51035 | 448 | 19 |
514704 | 514704 | 2020-09-08 | Carroll | Virginia | 51035 | 446 | 19 |
511471 | 511471 | 2020-09-07 | Carroll | Virginia | 51035 | 443 | 19 |
508238 | 508238 | 2020-09-06 | Carroll | Virginia | 51035 | 439 | 19 |
505006 | 505006 | 2020-09-05 | Carroll | Virginia | 51035 | 436 | 19 |
501772 | 501772 | 2020-09-04 | Carroll | Virginia | 51035 | 421 | 19 |
498538 | 498538 | 2020-09-03 | Carroll | Virginia | 51035 | 413 | 19 |
495305 | 495305 | 2020-09-02 | Carroll | Virginia | 51035 | 411 | 19 |
492071 | 492071 | 2020-09-01 | Carroll | Virginia | 51035 | 410 | 19 |
488838 | 488838 | 2020-08-31 | Carroll | Virginia | 51035 | 396 | 19 |
485605 | 485605 | 2020-08-30 | Carroll | Virginia | 51035 | 395 | 19 |
482370 | 482370 | 2020-08-29 | Carroll | Virginia | 51035 | 394 | 19 |
479136 | 479136 | 2020-08-28 | Carroll | Virginia | 51035 | 388 | 19 |
475903 | 475903 | 2020-08-27 | Carroll | Virginia | 51035 | 385 | 19 |
472670 | 472670 | 2020-08-26 | Carroll | Virginia | 51035 | 384 | 19 |
469438 | 469438 | 2020-08-25 | Carroll | Virginia | 51035 | 382 | 19 |
466209 | 466209 | 2020-08-24 | Carroll | Virginia | 51035 | 378 | 16 |
462980 | 462980 | 2020-08-23 | Carroll | Virginia | 51035 | 374 | 16 |
459751 | 459751 | 2020-08-22 | Carroll | Virginia | 51035 | 372 | 16 |
456524 | 456524 | 2020-08-21 | Carroll | Virginia | 51035 | 363 | 16 |
453296 | 453296 | 2020-08-20 | Carroll | Virginia | 51035 | 358 | 16 |
450068 | 450068 | 2020-08-19 | Carroll | Virginia | 51035 | 354 | 15 |
446840 | 446840 | 2020-08-18 | Carroll | Virginia | 51035 | 349 | 15 |
443613 | 443613 | 2020-08-17 | Carroll | Virginia | 51035 | 344 | 14 |
440387 | 440387 | 2020-08-16 | Carroll | Virginia | 51035 | 341 | 14 |
437161 | 437161 | 2020-08-15 | Carroll | Virginia | 51035 | 340 | 14 |
433935 | 433935 | 2020-08-14 | Carroll | Virginia | 51035 | 339 | 14 |
430710 | 430710 | 2020-08-13 | Carroll | Virginia | 51035 | 335 | 14 |
427482 | 427482 | 2020-08-12 | Carroll | Virginia | 51035 | 333 | 14 |
424258 | 424258 | 2020-08-11 | Carroll | Virginia | 51035 | 332 | 14 |
421037 | 421037 | 2020-08-10 | Carroll | Virginia | 51035 | 334 | 13 |
417816 | 417816 | 2020-08-09 | Carroll | Virginia | 51035 | 334 | 13 |
414595 | 414595 | 2020-08-08 | Carroll | Virginia | 51035 | 327 | 13 |
411375 | 411375 | 2020-08-07 | Carroll | Virginia | 51035 | 321 | 12 |
408156 | 408156 | 2020-08-06 | Carroll | Virginia | 51035 | 309 | 12 |
404936 | 404936 | 2020-08-05 | Carroll | Virginia | 51035 | 305 | 12 |
401718 | 401718 | 2020-08-04 | Carroll | Virginia | 51035 | 304 | 12 |
398502 | 398502 | 2020-08-03 | Carroll | Virginia | 51035 | 314 | 14 |
395286 | 395286 | 2020-08-02 | Carroll | Virginia | 51035 | 311 | 14 |
392070 | 392070 | 2020-08-01 | Carroll | Virginia | 51035 | 308 | 14 |
388853 | 388853 | 2020-07-31 | Carroll | Virginia | 51035 | 307 | 14 |
385636 | 385636 | 2020-07-30 | Carroll | Virginia | 51035 | 305 | 11 |
382418 | 382418 | 2020-07-29 | Carroll | Virginia | 51035 | 303 | 11 |
379201 | 379201 | 2020-07-28 | Carroll | Virginia | 51035 | 300 | 11 |
375985 | 375985 | 2020-07-27 | Carroll | Virginia | 51035 | 299 | 10 |
372771 | 372771 | 2020-07-26 | Carroll | Virginia | 51035 | 299 | 10 |
369559 | 369559 | 2020-07-25 | Carroll | Virginia | 51035 | 295 | 10 |
366350 | 366350 | 2020-07-24 | Carroll | Virginia | 51035 | 290 | 10 |
363144 | 363144 | 2020-07-23 | Carroll | Virginia | 51035 | 284 | 10 |
359938 | 359938 | 2020-07-22 | Carroll | Virginia | 51035 | 281 | 10 |
356733 | 356733 | 2020-07-21 | Carroll | Virginia | 51035 | 280 | 10 |
353530 | 353530 | 2020-07-20 | Carroll | Virginia | 51035 | 279 | 10 |
350328 | 350328 | 2020-07-19 | Carroll | Virginia | 51035 | 279 | 10 |
347127 | 347127 | 2020-07-18 | Carroll | Virginia | 51035 | 275 | 10 |
343927 | 343927 | 2020-07-17 | Carroll | Virginia | 51035 | 268 | 10 |
340728 | 340728 | 2020-07-16 | Carroll | Virginia | 51035 | 267 | 10 |
337532 | 337532 | 2020-07-15 | Carroll | Virginia | 51035 | 263 | 10 |
334337 | 334337 | 2020-07-14 | Carroll | Virginia | 51035 | 255 | 10 |
331144 | 331144 | 2020-07-13 | Carroll | Virginia | 51035 | 251 | 9 |
327958 | 327958 | 2020-07-12 | Carroll | Virginia | 51035 | 249 | 9 |
324773 | 324773 | 2020-07-11 | Carroll | Virginia | 51035 | 245 | 9 |
321592 | 321592 | 2020-07-10 | Carroll | Virginia | 51035 | 244 | 9 |
318413 | 318413 | 2020-07-09 | Carroll | Virginia | 51035 | 241 | 9 |
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);