ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "San Luis Obispo" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
729184 | 729184 | 2020-11-14 | San Luis Obispo | California | 6079 | 5038 | 33 |
725941 | 725941 | 2020-11-13 | San Luis Obispo | California | 6079 | 5038 | 33 |
722698 | 722698 | 2020-11-12 | San Luis Obispo | California | 6079 | 4972 | 33 |
719455 | 719455 | 2020-11-11 | San Luis Obispo | California | 6079 | 4846 | 33 |
716212 | 716212 | 2020-11-10 | San Luis Obispo | California | 6079 | 4846 | 33 |
712968 | 712968 | 2020-11-09 | San Luis Obispo | California | 6079 | 4794 | 33 |
709724 | 709724 | 2020-11-08 | San Luis Obispo | California | 6079 | 4645 | 33 |
706480 | 706480 | 2020-11-07 | San Luis Obispo | California | 6079 | 4568 | 33 |
703237 | 703237 | 2020-11-06 | San Luis Obispo | California | 6079 | 4568 | 33 |
699994 | 699994 | 2020-11-05 | San Luis Obispo | California | 6079 | 4496 | 33 |
696750 | 696750 | 2020-11-04 | San Luis Obispo | California | 6079 | 4422 | 33 |
693508 | 693508 | 2020-11-03 | San Luis Obispo | California | 6079 | 4380 | 33 |
690265 | 690265 | 2020-11-02 | San Luis Obispo | California | 6079 | 4342 | 33 |
687020 | 687020 | 2020-11-01 | San Luis Obispo | California | 6079 | 4298 | 32 |
683776 | 683776 | 2020-10-31 | San Luis Obispo | California | 6079 | 4298 | 32 |
680533 | 680533 | 2020-10-30 | San Luis Obispo | California | 6079 | 4298 | 32 |
677290 | 677290 | 2020-10-29 | San Luis Obispo | California | 6079 | 4265 | 32 |
674047 | 674047 | 2020-10-28 | San Luis Obispo | California | 6079 | 4240 | 32 |
670805 | 670805 | 2020-10-27 | San Luis Obispo | California | 6079 | 4191 | 32 |
667562 | 667562 | 2020-10-26 | San Luis Obispo | California | 6079 | 4174 | 32 |
664317 | 664317 | 2020-10-25 | San Luis Obispo | California | 6079 | 4141 | 32 |
661073 | 661073 | 2020-10-24 | San Luis Obispo | California | 6079 | 4141 | 32 |
657829 | 657829 | 2020-10-23 | San Luis Obispo | California | 6079 | 4141 | 32 |
654584 | 654584 | 2020-10-22 | San Luis Obispo | California | 6079 | 4121 | 32 |
651339 | 651339 | 2020-10-21 | San Luis Obispo | California | 6079 | 4092 | 32 |
648095 | 648095 | 2020-10-20 | San Luis Obispo | California | 6079 | 4080 | 32 |
644850 | 644850 | 2020-10-19 | San Luis Obispo | California | 6079 | 4049 | 32 |
641602 | 641602 | 2020-10-18 | San Luis Obispo | California | 6079 | 3985 | 32 |
638355 | 638355 | 2020-10-17 | San Luis Obispo | California | 6079 | 3985 | 32 |
635110 | 635110 | 2020-10-16 | San Luis Obispo | California | 6079 | 3985 | 32 |
631864 | 631864 | 2020-10-15 | San Luis Obispo | California | 6079 | 3969 | 32 |
628620 | 628620 | 2020-10-14 | San Luis Obispo | California | 6079 | 3933 | 32 |
625377 | 625377 | 2020-10-13 | San Luis Obispo | California | 6079 | 3924 | 32 |
622134 | 622134 | 2020-10-12 | San Luis Obispo | California | 6079 | 3874 | 31 |
618891 | 618891 | 2020-10-11 | San Luis Obispo | California | 6079 | 3842 | 31 |
615649 | 615649 | 2020-10-10 | San Luis Obispo | California | 6079 | 3842 | 31 |
612408 | 612408 | 2020-10-09 | San Luis Obispo | California | 6079 | 3842 | 31 |
609166 | 609166 | 2020-10-08 | San Luis Obispo | California | 6079 | 3815 | 31 |
605923 | 605923 | 2020-10-07 | San Luis Obispo | California | 6079 | 3779 | 31 |
602681 | 602681 | 2020-10-06 | San Luis Obispo | California | 6079 | 3755 | 31 |
599438 | 599438 | 2020-10-05 | San Luis Obispo | California | 6079 | 3742 | 31 |
596195 | 596195 | 2020-10-04 | San Luis Obispo | California | 6079 | 3685 | 31 |
592953 | 592953 | 2020-10-03 | San Luis Obispo | California | 6079 | 3685 | 31 |
589713 | 589713 | 2020-10-02 | San Luis Obispo | California | 6079 | 3685 | 31 |
586472 | 586472 | 2020-10-01 | San Luis Obispo | California | 6079 | 3649 | 31 |
583232 | 583232 | 2020-09-30 | San Luis Obispo | California | 6079 | 3629 | 31 |
579993 | 579993 | 2020-09-29 | San Luis Obispo | California | 6079 | 3612 | 31 |
576752 | 576752 | 2020-09-28 | San Luis Obispo | California | 6079 | 3597 | 29 |
573509 | 573509 | 2020-09-27 | San Luis Obispo | California | 6079 | 3546 | 29 |
570267 | 570267 | 2020-09-26 | San Luis Obispo | California | 6079 | 3544 | 29 |
567025 | 567025 | 2020-09-25 | San Luis Obispo | California | 6079 | 3544 | 29 |
563785 | 563785 | 2020-09-24 | San Luis Obispo | California | 6079 | 3510 | 29 |
560546 | 560546 | 2020-09-23 | San Luis Obispo | California | 6079 | 3479 | 29 |
557310 | 557310 | 2020-09-22 | San Luis Obispo | California | 6079 | 3453 | 27 |
554073 | 554073 | 2020-09-21 | San Luis Obispo | California | 6079 | 3438 | 27 |
550834 | 550834 | 2020-09-20 | San Luis Obispo | California | 6079 | 3369 | 27 |
547595 | 547595 | 2020-09-19 | San Luis Obispo | California | 6079 | 3360 | 27 |
544357 | 544357 | 2020-09-18 | San Luis Obispo | California | 6079 | 3360 | 27 |
541121 | 541121 | 2020-09-17 | San Luis Obispo | California | 6079 | 3332 | 27 |
537884 | 537884 | 2020-09-16 | San Luis Obispo | California | 6079 | 3316 | 27 |
534648 | 534648 | 2020-09-15 | San Luis Obispo | California | 6079 | 3293 | 26 |
531413 | 531413 | 2020-09-14 | San Luis Obispo | California | 6079 | 3278 | 26 |
528176 | 528176 | 2020-09-13 | San Luis Obispo | California | 6079 | 3222 | 23 |
524940 | 524940 | 2020-09-12 | San Luis Obispo | California | 6079 | 3222 | 23 |
521704 | 521704 | 2020-09-11 | San Luis Obispo | California | 6079 | 3222 | 23 |
518467 | 518467 | 2020-09-10 | San Luis Obispo | California | 6079 | 3194 | 23 |
515232 | 515232 | 2020-09-09 | San Luis Obispo | California | 6079 | 3171 | 22 |
511999 | 511999 | 2020-09-08 | San Luis Obispo | California | 6079 | 3145 | 22 |
508766 | 508766 | 2020-09-07 | San Luis Obispo | California | 6079 | 3101 | 22 |
505534 | 505534 | 2020-09-06 | San Luis Obispo | California | 6079 | 3083 | 22 |
502300 | 502300 | 2020-09-05 | San Luis Obispo | California | 6079 | 3074 | 22 |
499066 | 499066 | 2020-09-04 | San Luis Obispo | California | 6079 | 3074 | 22 |
495833 | 495833 | 2020-09-03 | San Luis Obispo | California | 6079 | 3047 | 20 |
492599 | 492599 | 2020-09-02 | San Luis Obispo | California | 6079 | 3035 | 20 |
489366 | 489366 | 2020-09-01 | San Luis Obispo | California | 6079 | 3006 | 20 |
486133 | 486133 | 2020-08-31 | San Luis Obispo | California | 6079 | 2981 | 21 |
482898 | 482898 | 2020-08-30 | San Luis Obispo | California | 6079 | 2917 | 21 |
479664 | 479664 | 2020-08-29 | San Luis Obispo | California | 6079 | 2882 | 21 |
476431 | 476431 | 2020-08-28 | San Luis Obispo | California | 6079 | 2882 | 21 |
473198 | 473198 | 2020-08-27 | San Luis Obispo | California | 6079 | 2842 | 21 |
469966 | 469966 | 2020-08-26 | San Luis Obispo | California | 6079 | 2792 | 21 |
466737 | 466737 | 2020-08-25 | San Luis Obispo | California | 6079 | 2769 | 21 |
463508 | 463508 | 2020-08-24 | San Luis Obispo | California | 6079 | 2735 | 21 |
460279 | 460279 | 2020-08-23 | San Luis Obispo | California | 6079 | 2665 | 21 |
457052 | 457052 | 2020-08-22 | San Luis Obispo | California | 6079 | 2665 | 21 |
453824 | 453824 | 2020-08-21 | San Luis Obispo | California | 6079 | 2665 | 21 |
450596 | 450596 | 2020-08-20 | San Luis Obispo | California | 6079 | 2562 | 20 |
447368 | 447368 | 2020-08-19 | San Luis Obispo | California | 6079 | 2562 | 19 |
444141 | 444141 | 2020-08-18 | San Luis Obispo | California | 6079 | 2562 | 19 |
440915 | 440915 | 2020-08-17 | San Luis Obispo | California | 6079 | 2562 | 19 |
437689 | 437689 | 2020-08-16 | San Luis Obispo | California | 6079 | 2461 | 19 |
434463 | 434463 | 2020-08-15 | San Luis Obispo | California | 6079 | 2439 | 19 |
431238 | 431238 | 2020-08-14 | San Luis Obispo | California | 6079 | 2439 | 18 |
428010 | 428010 | 2020-08-13 | San Luis Obispo | California | 6079 | 2324 | 18 |
424786 | 424786 | 2020-08-12 | San Luis Obispo | California | 6079 | 2300 | 17 |
421565 | 421565 | 2020-08-11 | San Luis Obispo | California | 6079 | 2278 | 17 |
418344 | 418344 | 2020-08-10 | San Luis Obispo | California | 6079 | 2254 | 17 |
415123 | 415123 | 2020-08-09 | San Luis Obispo | California | 6079 | 2093 | 17 |
411903 | 411903 | 2020-08-08 | San Luis Obispo | California | 6079 | 2093 | 17 |
408684 | 408684 | 2020-08-07 | San Luis Obispo | California | 6079 | 2093 | 16 |
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);