ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
803 rows where fips = 6081 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
729185 | 729185 | 2020-11-14 | San Mateo | California | 6081 | 12465 | 168 |
725942 | 725942 | 2020-11-13 | San Mateo | California | 6081 | 12332 | 168 |
722699 | 722699 | 2020-11-12 | San Mateo | California | 6081 | 12127 | 165 |
719456 | 719456 | 2020-11-11 | San Mateo | California | 6081 | 12127 | 165 |
716213 | 716213 | 2020-11-10 | San Mateo | California | 6081 | 12049 | 165 |
712969 | 712969 | 2020-11-09 | San Mateo | California | 6081 | 11937 | 162 |
709725 | 709725 | 2020-11-08 | San Mateo | California | 6081 | 11810 | 162 |
706481 | 706481 | 2020-11-07 | San Mateo | California | 6081 | 11810 | 162 |
703238 | 703238 | 2020-11-06 | San Mateo | California | 6081 | 11710 | 162 |
699995 | 699995 | 2020-11-05 | San Mateo | California | 6081 | 11629 | 161 |
696751 | 696751 | 2020-11-04 | San Mateo | California | 6081 | 11564 | 161 |
693509 | 693509 | 2020-11-03 | San Mateo | California | 6081 | 11479 | 161 |
690266 | 690266 | 2020-11-02 | San Mateo | California | 6081 | 11451 | 161 |
687021 | 687021 | 2020-11-01 | San Mateo | California | 6081 | 11371 | 161 |
683777 | 683777 | 2020-10-31 | San Mateo | California | 6081 | 11371 | 161 |
680534 | 680534 | 2020-10-30 | San Mateo | California | 6081 | 11341 | 161 |
677291 | 677291 | 2020-10-29 | San Mateo | California | 6081 | 11278 | 159 |
674048 | 674048 | 2020-10-28 | San Mateo | California | 6081 | 11232 | 159 |
670806 | 670806 | 2020-10-27 | San Mateo | California | 6081 | 11198 | 159 |
667563 | 667563 | 2020-10-26 | San Mateo | California | 6081 | 11149 | 159 |
664318 | 664318 | 2020-10-25 | San Mateo | California | 6081 | 11075 | 159 |
661074 | 661074 | 2020-10-24 | San Mateo | California | 6081 | 11075 | 159 |
657830 | 657830 | 2020-10-23 | San Mateo | California | 6081 | 11002 | 159 |
654585 | 654585 | 2020-10-22 | San Mateo | California | 6081 | 10961 | 157 |
651340 | 651340 | 2020-10-21 | San Mateo | California | 6081 | 10918 | 157 |
648096 | 648096 | 2020-10-20 | San Mateo | California | 6081 | 10889 | 157 |
644851 | 644851 | 2020-10-19 | San Mateo | California | 6081 | 10810 | 157 |
641603 | 641603 | 2020-10-18 | San Mateo | California | 6081 | 10743 | 157 |
638356 | 638356 | 2020-10-17 | San Mateo | California | 6081 | 10743 | 157 |
635111 | 635111 | 2020-10-16 | San Mateo | California | 6081 | 10687 | 155 |
631865 | 631865 | 2020-10-15 | San Mateo | California | 6081 | 10655 | 155 |
628621 | 628621 | 2020-10-14 | San Mateo | California | 6081 | 10622 | 155 |
625378 | 625378 | 2020-10-13 | San Mateo | California | 6081 | 10601 | 155 |
622135 | 622135 | 2020-10-12 | San Mateo | California | 6081 | 10510 | 155 |
618892 | 618892 | 2020-10-11 | San Mateo | California | 6081 | 10510 | 155 |
615650 | 615650 | 2020-10-10 | San Mateo | California | 6081 | 10510 | 155 |
612409 | 612409 | 2020-10-09 | San Mateo | California | 6081 | 10452 | 155 |
609167 | 609167 | 2020-10-08 | San Mateo | California | 6081 | 10395 | 154 |
605924 | 605924 | 2020-10-07 | San Mateo | California | 6081 | 10347 | 154 |
602682 | 602682 | 2020-10-06 | San Mateo | California | 6081 | 10309 | 152 |
599439 | 599439 | 2020-10-05 | San Mateo | California | 6081 | 10275 | 152 |
596196 | 596196 | 2020-10-04 | San Mateo | California | 6081 | 10207 | 152 |
592954 | 592954 | 2020-10-03 | San Mateo | California | 6081 | 10207 | 152 |
589714 | 589714 | 2020-10-02 | San Mateo | California | 6081 | 10126 | 152 |
586473 | 586473 | 2020-10-01 | San Mateo | California | 6081 | 10069 | 150 |
583233 | 583233 | 2020-09-30 | San Mateo | California | 6081 | 9990 | 150 |
579994 | 579994 | 2020-09-29 | San Mateo | California | 6081 | 9950 | 150 |
576753 | 576753 | 2020-09-28 | San Mateo | California | 6081 | 9897 | 150 |
573510 | 573510 | 2020-09-27 | San Mateo | California | 6081 | 9843 | 150 |
570268 | 570268 | 2020-09-26 | San Mateo | California | 6081 | 9843 | 150 |
567026 | 567026 | 2020-09-25 | San Mateo | California | 6081 | 9785 | 150 |
563786 | 563786 | 2020-09-24 | San Mateo | California | 6081 | 9714 | 144 |
560547 | 560547 | 2020-09-23 | San Mateo | California | 6081 | 9664 | 144 |
557311 | 557311 | 2020-09-22 | San Mateo | California | 6081 | 9625 | 144 |
554074 | 554074 | 2020-09-21 | San Mateo | California | 6081 | 9598 | 143 |
550835 | 550835 | 2020-09-20 | San Mateo | California | 6081 | 9522 | 143 |
547596 | 547596 | 2020-09-19 | San Mateo | California | 6081 | 9522 | 143 |
544358 | 544358 | 2020-09-18 | San Mateo | California | 6081 | 9332 | 142 |
541122 | 541122 | 2020-09-17 | San Mateo | California | 6081 | 9332 | 142 |
537885 | 537885 | 2020-09-16 | San Mateo | California | 6081 | 9264 | 142 |
534649 | 534649 | 2020-09-15 | San Mateo | California | 6081 | 9242 | 142 |
531414 | 531414 | 2020-09-14 | San Mateo | California | 6081 | 9166 | 139 |
528177 | 528177 | 2020-09-13 | San Mateo | California | 6081 | 9077 | 139 |
524941 | 524941 | 2020-09-12 | San Mateo | California | 6081 | 9077 | 139 |
521705 | 521705 | 2020-09-11 | San Mateo | California | 6081 | 8966 | 139 |
518468 | 518468 | 2020-09-10 | San Mateo | California | 6081 | 8895 | 136 |
515233 | 515233 | 2020-09-09 | San Mateo | California | 6081 | 8807 | 136 |
512000 | 512000 | 2020-09-08 | San Mateo | California | 6081 | 8750 | 136 |
508767 | 508767 | 2020-09-07 | San Mateo | California | 6081 | 8617 | 135 |
505535 | 505535 | 2020-09-06 | San Mateo | California | 6081 | 8617 | 135 |
502301 | 502301 | 2020-09-05 | San Mateo | California | 6081 | 8617 | 135 |
499067 | 499067 | 2020-09-04 | San Mateo | California | 6081 | 8452 | 135 |
495834 | 495834 | 2020-09-03 | San Mateo | California | 6081 | 8390 | 132 |
492600 | 492600 | 2020-09-02 | San Mateo | California | 6081 | 8311 | 132 |
489367 | 489367 | 2020-09-01 | San Mateo | California | 6081 | 8260 | 132 |
486134 | 486134 | 2020-08-31 | San Mateo | California | 6081 | 8169 | 131 |
482899 | 482899 | 2020-08-30 | San Mateo | California | 6081 | 8074 | 131 |
479665 | 479665 | 2020-08-29 | San Mateo | California | 6081 | 8074 | 131 |
476432 | 476432 | 2020-08-28 | San Mateo | California | 6081 | 7978 | 131 |
473199 | 473199 | 2020-08-27 | San Mateo | California | 6081 | 7911 | 130 |
469967 | 469967 | 2020-08-26 | San Mateo | California | 6081 | 7849 | 130 |
466738 | 466738 | 2020-08-25 | San Mateo | California | 6081 | 7788 | 130 |
463509 | 463509 | 2020-08-24 | San Mateo | California | 6081 | 7670 | 128 |
460280 | 460280 | 2020-08-23 | San Mateo | California | 6081 | 7535 | 128 |
457053 | 457053 | 2020-08-22 | San Mateo | California | 6081 | 7535 | 128 |
453825 | 453825 | 2020-08-21 | San Mateo | California | 6081 | 7472 | 128 |
450597 | 450597 | 2020-08-20 | San Mateo | California | 6081 | 7382 | 127 |
447369 | 447369 | 2020-08-19 | San Mateo | California | 6081 | 7321 | 127 |
444142 | 444142 | 2020-08-18 | San Mateo | California | 6081 | 7228 | 127 |
440916 | 440916 | 2020-08-17 | San Mateo | California | 6081 | 7150 | 126 |
437690 | 437690 | 2020-08-16 | San Mateo | California | 6081 | 6952 | 126 |
434464 | 434464 | 2020-08-15 | San Mateo | California | 6081 | 6952 | 126 |
431239 | 431239 | 2020-08-14 | San Mateo | California | 6081 | 6803 | 126 |
428011 | 428011 | 2020-08-13 | San Mateo | California | 6081 | 6640 | 122 |
424787 | 424787 | 2020-08-12 | San Mateo | California | 6081 | 6535 | 122 |
421566 | 421566 | 2020-08-11 | San Mateo | California | 6081 | 6431 | 122 |
418345 | 418345 | 2020-08-10 | San Mateo | California | 6081 | 6318 | 120 |
415124 | 415124 | 2020-08-09 | San Mateo | California | 6081 | 6110 | 120 |
411904 | 411904 | 2020-08-08 | San Mateo | California | 6081 | 6110 | 120 |
408685 | 408685 | 2020-08-07 | San Mateo | California | 6081 | 5978 | 120 |
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);