ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 6079 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
405464 | 405464 | 2020-08-06 | San Luis Obispo | California | 6079 | 2047 | 16 |
402246 | 402246 | 2020-08-05 | San Luis Obispo | California | 6079 | 1970 | 16 |
399030 | 399030 | 2020-08-04 | San Luis Obispo | California | 6079 | 1926 | 16 |
395814 | 395814 | 2020-08-03 | San Luis Obispo | California | 6079 | 1902 | 16 |
392598 | 392598 | 2020-08-02 | San Luis Obispo | California | 6079 | 1798 | 15 |
389381 | 389381 | 2020-08-01 | San Luis Obispo | California | 6079 | 1783 | 15 |
386164 | 386164 | 2020-07-31 | San Luis Obispo | California | 6079 | 1783 | 15 |
382946 | 382946 | 2020-07-30 | San Luis Obispo | California | 6079 | 1740 | 14 |
379729 | 379729 | 2020-07-29 | San Luis Obispo | California | 6079 | 1710 | 12 |
376512 | 376512 | 2020-07-28 | San Luis Obispo | California | 6079 | 1689 | 11 |
373298 | 373298 | 2020-07-27 | San Luis Obispo | California | 6079 | 1644 | 9 |
370086 | 370086 | 2020-07-26 | San Luis Obispo | California | 6079 | 1530 | 8 |
366876 | 366876 | 2020-07-25 | San Luis Obispo | California | 6079 | 1500 | 8 |
363669 | 363669 | 2020-07-24 | San Luis Obispo | California | 6079 | 1500 | 8 |
360462 | 360462 | 2020-07-23 | San Luis Obispo | California | 6079 | 1467 | 8 |
357257 | 357257 | 2020-07-22 | San Luis Obispo | California | 6079 | 1393 | 7 |
354054 | 354054 | 2020-07-21 | San Luis Obispo | California | 6079 | 1369 | 7 |
350852 | 350852 | 2020-07-20 | San Luis Obispo | California | 6079 | 1306 | 6 |
347651 | 347651 | 2020-07-19 | San Luis Obispo | California | 6079 | 1234 | 6 |
344451 | 344451 | 2020-07-18 | San Luis Obispo | California | 6079 | 1213 | 6 |
341252 | 341252 | 2020-07-17 | San Luis Obispo | California | 6079 | 1213 | 6 |
338056 | 338056 | 2020-07-16 | San Luis Obispo | California | 6079 | 1158 | 6 |
334861 | 334861 | 2020-07-15 | San Luis Obispo | California | 6079 | 1112 | 6 |
331668 | 331668 | 2020-07-14 | San Luis Obispo | California | 6079 | 1078 | 5 |
328482 | 328482 | 2020-07-13 | San Luis Obispo | California | 6079 | 1006 | 5 |
325296 | 325296 | 2020-07-12 | San Luis Obispo | California | 6079 | 930 | 4 |
322115 | 322115 | 2020-07-11 | San Luis Obispo | California | 6079 | 905 | 4 |
318936 | 318936 | 2020-07-10 | San Luis Obispo | California | 6079 | 905 | 4 |
315763 | 315763 | 2020-07-09 | San Luis Obispo | California | 6079 | 877 | 4 |
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);