ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Raleigh" and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
638019 | 638019 | 2020-10-16 | Raleigh | West Virginia | 54081 | 638 | 8 |
634774 | 634774 | 2020-10-15 | Raleigh | West Virginia | 54081 | 629 | 8 |
631529 | 631529 | 2020-10-14 | Raleigh | West Virginia | 54081 | 623 | 8 |
628285 | 628285 | 2020-10-13 | Raleigh | West Virginia | 54081 | 616 | 8 |
625042 | 625042 | 2020-10-12 | Raleigh | West Virginia | 54081 | 612 | 8 |
621799 | 621799 | 2020-10-11 | Raleigh | West Virginia | 54081 | 608 | 8 |
618556 | 618556 | 2020-10-10 | Raleigh | West Virginia | 54081 | 604 | 8 |
615314 | 615314 | 2020-10-09 | Raleigh | West Virginia | 54081 | 596 | 8 |
612073 | 612073 | 2020-10-08 | Raleigh | West Virginia | 54081 | 581 | 8 |
608831 | 608831 | 2020-10-07 | Raleigh | West Virginia | 54081 | 571 | 8 |
605588 | 605588 | 2020-10-06 | Raleigh | West Virginia | 54081 | 567 | 8 |
602346 | 602346 | 2020-10-05 | Raleigh | West Virginia | 54081 | 563 | 8 |
599103 | 599103 | 2020-10-04 | Raleigh | West Virginia | 54081 | 559 | 8 |
595860 | 595860 | 2020-10-03 | Raleigh | West Virginia | 54081 | 550 | 8 |
592618 | 592618 | 2020-10-02 | Raleigh | West Virginia | 54081 | 546 | 8 |
589378 | 589378 | 2020-10-01 | Raleigh | West Virginia | 54081 | 538 | 8 |
586137 | 586137 | 2020-09-30 | Raleigh | West Virginia | 54081 | 528 | 8 |
582897 | 582897 | 2020-09-29 | Raleigh | West Virginia | 54081 | 526 | 8 |
579658 | 579658 | 2020-09-28 | Raleigh | West Virginia | 54081 | 521 | 8 |
576417 | 576417 | 2020-09-27 | Raleigh | West Virginia | 54081 | 520 | 8 |
573173 | 573173 | 2020-09-26 | Raleigh | West Virginia | 54081 | 510 | 8 |
569931 | 569931 | 2020-09-25 | Raleigh | West Virginia | 54081 | 501 | 8 |
566690 | 566690 | 2020-09-24 | Raleigh | West Virginia | 54081 | 497 | 8 |
563449 | 563449 | 2020-09-23 | Raleigh | West Virginia | 54081 | 487 | 8 |
560210 | 560210 | 2020-09-22 | Raleigh | West Virginia | 54081 | 479 | 8 |
556974 | 556974 | 2020-09-21 | Raleigh | West Virginia | 54081 | 473 | 8 |
553737 | 553737 | 2020-09-20 | Raleigh | West Virginia | 54081 | 472 | 8 |
550498 | 550498 | 2020-09-19 | Raleigh | West Virginia | 54081 | 471 | 8 |
547259 | 547259 | 2020-09-18 | Raleigh | West Virginia | 54081 | 470 | 6 |
544022 | 544022 | 2020-09-17 | Raleigh | West Virginia | 54081 | 449 | 6 |
540786 | 540786 | 2020-09-16 | Raleigh | West Virginia | 54081 | 449 | 6 |
537549 | 537549 | 2020-09-15 | Raleigh | West Virginia | 54081 | 443 | 6 |
534313 | 534313 | 2020-09-14 | Raleigh | West Virginia | 54081 | 423 | 5 |
531078 | 531078 | 2020-09-13 | Raleigh | West Virginia | 54081 | 415 | 5 |
527841 | 527841 | 2020-09-12 | Raleigh | West Virginia | 54081 | 412 | 5 |
524605 | 524605 | 2020-09-11 | Raleigh | West Virginia | 54081 | 403 | 5 |
521369 | 521369 | 2020-09-10 | Raleigh | West Virginia | 54081 | 399 | 4 |
518132 | 518132 | 2020-09-09 | Raleigh | West Virginia | 54081 | 397 | 4 |
514897 | 514897 | 2020-09-08 | Raleigh | West Virginia | 54081 | 393 | 4 |
511664 | 511664 | 2020-09-07 | Raleigh | West Virginia | 54081 | 391 | 4 |
508431 | 508431 | 2020-09-06 | Raleigh | West Virginia | 54081 | 390 | 4 |
505199 | 505199 | 2020-09-05 | Raleigh | West Virginia | 54081 | 389 | 4 |
501965 | 501965 | 2020-09-04 | Raleigh | West Virginia | 54081 | 386 | 4 |
498731 | 498731 | 2020-09-03 | Raleigh | West Virginia | 54081 | 377 | 4 |
495498 | 495498 | 2020-09-02 | Raleigh | West Virginia | 54081 | 372 | 4 |
492264 | 492264 | 2020-09-01 | Raleigh | West Virginia | 54081 | 366 | 4 |
489031 | 489031 | 2020-08-31 | Raleigh | West Virginia | 54081 | 363 | 4 |
485798 | 485798 | 2020-08-30 | Raleigh | West Virginia | 54081 | 356 | 3 |
482563 | 482563 | 2020-08-29 | Raleigh | West Virginia | 54081 | 346 | 3 |
479329 | 479329 | 2020-08-28 | Raleigh | West Virginia | 54081 | 340 | 3 |
476096 | 476096 | 2020-08-27 | Raleigh | West Virginia | 54081 | 332 | 3 |
472863 | 472863 | 2020-08-26 | Raleigh | West Virginia | 54081 | 331 | 3 |
469631 | 469631 | 2020-08-25 | Raleigh | West Virginia | 54081 | 328 | 3 |
466402 | 466402 | 2020-08-24 | Raleigh | West Virginia | 54081 | 325 | 3 |
463173 | 463173 | 2020-08-23 | Raleigh | West Virginia | 54081 | 324 | 3 |
459944 | 459944 | 2020-08-22 | Raleigh | West Virginia | 54081 | 320 | 3 |
456717 | 456717 | 2020-08-21 | Raleigh | West Virginia | 54081 | 319 | 3 |
453489 | 453489 | 2020-08-20 | Raleigh | West Virginia | 54081 | 314 | 3 |
450261 | 450261 | 2020-08-19 | Raleigh | West Virginia | 54081 | 310 | 2 |
447033 | 447033 | 2020-08-18 | Raleigh | West Virginia | 54081 | 306 | 2 |
443806 | 443806 | 2020-08-17 | Raleigh | West Virginia | 54081 | 304 | 1 |
440580 | 440580 | 2020-08-16 | Raleigh | West Virginia | 54081 | 297 | 1 |
437354 | 437354 | 2020-08-15 | Raleigh | West Virginia | 54081 | 292 | 1 |
434128 | 434128 | 2020-08-14 | Raleigh | West Virginia | 54081 | 282 | 1 |
430903 | 430903 | 2020-08-13 | Raleigh | West Virginia | 54081 | 276 | 1 |
427675 | 427675 | 2020-08-12 | Raleigh | West Virginia | 54081 | 267 | 1 |
424451 | 424451 | 2020-08-11 | Raleigh | West Virginia | 54081 | 259 | 1 |
421230 | 421230 | 2020-08-10 | Raleigh | West Virginia | 54081 | 255 | 1 |
418009 | 418009 | 2020-08-09 | Raleigh | West Virginia | 54081 | 253 | 1 |
414788 | 414788 | 2020-08-08 | Raleigh | West Virginia | 54081 | 227 | 1 |
411568 | 411568 | 2020-08-07 | Raleigh | West Virginia | 54081 | 215 | 1 |
408349 | 408349 | 2020-08-06 | Raleigh | West Virginia | 54081 | 210 | 1 |
405129 | 405129 | 2020-08-05 | Raleigh | West Virginia | 54081 | 207 | 1 |
401911 | 401911 | 2020-08-04 | Raleigh | West Virginia | 54081 | 198 | 1 |
398695 | 398695 | 2020-08-03 | Raleigh | West Virginia | 54081 | 196 | 1 |
395479 | 395479 | 2020-08-02 | Raleigh | West Virginia | 54081 | 189 | 1 |
392263 | 392263 | 2020-08-01 | Raleigh | West Virginia | 54081 | 182 | 1 |
389046 | 389046 | 2020-07-31 | Raleigh | West Virginia | 54081 | 172 | 1 |
385829 | 385829 | 2020-07-30 | Raleigh | West Virginia | 54081 | 156 | 0 |
382611 | 382611 | 2020-07-29 | Raleigh | West Virginia | 54081 | 153 | 0 |
379394 | 379394 | 2020-07-28 | Raleigh | West Virginia | 54081 | 142 | 0 |
376178 | 376178 | 2020-07-27 | Raleigh | West Virginia | 54081 | 136 | 0 |
372964 | 372964 | 2020-07-26 | Raleigh | West Virginia | 54081 | 134 | 0 |
369752 | 369752 | 2020-07-25 | Raleigh | West Virginia | 54081 | 130 | 0 |
366542 | 366542 | 2020-07-24 | Raleigh | West Virginia | 54081 | 123 | 0 |
363335 | 363335 | 2020-07-23 | Raleigh | West Virginia | 54081 | 120 | 0 |
360129 | 360129 | 2020-07-22 | Raleigh | West Virginia | 54081 | 118 | 0 |
356924 | 356924 | 2020-07-21 | Raleigh | West Virginia | 54081 | 111 | 0 |
353721 | 353721 | 2020-07-20 | Raleigh | West Virginia | 54081 | 108 | 0 |
350519 | 350519 | 2020-07-19 | Raleigh | West Virginia | 54081 | 95 | 0 |
347318 | 347318 | 2020-07-18 | Raleigh | West Virginia | 54081 | 95 | 0 |
344118 | 344118 | 2020-07-17 | Raleigh | West Virginia | 54081 | 95 | 0 |
340919 | 340919 | 2020-07-16 | Raleigh | West Virginia | 54081 | 88 | 0 |
337723 | 337723 | 2020-07-15 | Raleigh | West Virginia | 54081 | 86 | 0 |
334528 | 334528 | 2020-07-14 | Raleigh | West Virginia | 54081 | 84 | 0 |
331335 | 331335 | 2020-07-13 | Raleigh | West Virginia | 54081 | 83 | 0 |
328149 | 328149 | 2020-07-12 | Raleigh | West Virginia | 54081 | 80 | 0 |
324963 | 324963 | 2020-07-11 | Raleigh | West Virginia | 54081 | 76 | 0 |
321782 | 321782 | 2020-07-10 | Raleigh | West Virginia | 54081 | 71 | 0 |
318603 | 318603 | 2020-07-09 | Raleigh | West Virginia | 54081 | 68 | 0 |
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);