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 |
---|---|---|---|---|---|---|---|
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 |
405465 | 405465 | 2020-08-06 | San Mateo | California | 6081 | 5891 | 120 |
402247 | 402247 | 2020-08-05 | San Mateo | California | 6081 | 5758 | 120 |
399031 | 399031 | 2020-08-04 | San Mateo | California | 6081 | 5744 | 120 |
395815 | 395815 | 2020-08-03 | San Mateo | California | 6081 | 5683 | 119 |
392599 | 392599 | 2020-08-02 | San Mateo | California | 6081 | 5544 | 119 |
389382 | 389382 | 2020-08-01 | San Mateo | California | 6081 | 5544 | 119 |
386165 | 386165 | 2020-07-31 | San Mateo | California | 6081 | 5469 | 119 |
382947 | 382947 | 2020-07-30 | San Mateo | California | 6081 | 5398 | 118 |
379730 | 379730 | 2020-07-29 | San Mateo | California | 6081 | 5306 | 118 |
376513 | 376513 | 2020-07-28 | San Mateo | California | 6081 | 5198 | 118 |
373299 | 373299 | 2020-07-27 | San Mateo | California | 6081 | 5124 | 117 |
370087 | 370087 | 2020-07-26 | San Mateo | California | 6081 | 5023 | 117 |
366877 | 366877 | 2020-07-25 | San Mateo | California | 6081 | 5022 | 117 |
363670 | 363670 | 2020-07-24 | San Mateo | California | 6081 | 4957 | 117 |
360463 | 360463 | 2020-07-23 | San Mateo | California | 6081 | 4885 | 114 |
357258 | 357258 | 2020-07-22 | San Mateo | California | 6081 | 4776 | 114 |
354055 | 354055 | 2020-07-21 | San Mateo | California | 6081 | 4674 | 114 |
350853 | 350853 | 2020-07-20 | San Mateo | California | 6081 | 4551 | 114 |
347652 | 347652 | 2020-07-19 | San Mateo | California | 6081 | 4488 | 114 |
344452 | 344452 | 2020-07-18 | San Mateo | California | 6081 | 4465 | 114 |
341253 | 341253 | 2020-07-17 | San Mateo | California | 6081 | 4403 | 114 |
338057 | 338057 | 2020-07-16 | San Mateo | California | 6081 | 4333 | 114 |
334862 | 334862 | 2020-07-15 | San Mateo | California | 6081 | 4254 | 114 |
331669 | 331669 | 2020-07-14 | San Mateo | California | 6081 | 4168 | 114 |
328483 | 328483 | 2020-07-13 | San Mateo | California | 6081 | 4045 | 112 |
325297 | 325297 | 2020-07-12 | San Mateo | California | 6081 | 3956 | 112 |
322116 | 322116 | 2020-07-11 | San Mateo | California | 6081 | 3949 | 112 |
318937 | 318937 | 2020-07-10 | San Mateo | California | 6081 | 3846 | 112 |
315764 | 315764 | 2020-07-09 | San Mateo | California | 6081 | 3787 | 111 |
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);