ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Yolo" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635127 | 635127 | 2020-10-16 | Yolo | California | 6113 | 3034 | 56 |
631881 | 631881 | 2020-10-15 | Yolo | California | 6113 | 3015 | 56 |
628637 | 628637 | 2020-10-14 | Yolo | California | 6113 | 3010 | 56 |
625394 | 625394 | 2020-10-13 | Yolo | California | 6113 | 2986 | 56 |
622151 | 622151 | 2020-10-12 | Yolo | California | 6113 | 2966 | 56 |
618908 | 618908 | 2020-10-11 | Yolo | California | 6113 | 2954 | 56 |
615666 | 615666 | 2020-10-10 | Yolo | California | 6113 | 2942 | 56 |
612425 | 612425 | 2020-10-09 | Yolo | California | 6113 | 2929 | 56 |
609183 | 609183 | 2020-10-08 | Yolo | California | 6113 | 2918 | 56 |
605940 | 605940 | 2020-10-07 | Yolo | California | 6113 | 2909 | 56 |
602698 | 602698 | 2020-10-06 | Yolo | California | 6113 | 2903 | 56 |
599455 | 599455 | 2020-10-05 | Yolo | California | 6113 | 2893 | 56 |
596212 | 596212 | 2020-10-04 | Yolo | California | 6113 | 2879 | 56 |
592970 | 592970 | 2020-10-03 | Yolo | California | 6113 | 2867 | 56 |
589730 | 589730 | 2020-10-02 | Yolo | California | 6113 | 2847 | 55 |
586489 | 586489 | 2020-10-01 | Yolo | California | 6113 | 2836 | 55 |
583249 | 583249 | 2020-09-30 | Yolo | California | 6113 | 2828 | 55 |
580010 | 580010 | 2020-09-29 | Yolo | California | 6113 | 2825 | 55 |
576769 | 576769 | 2020-09-28 | Yolo | California | 6113 | 2815 | 55 |
573526 | 573526 | 2020-09-27 | Yolo | California | 6113 | 2803 | 55 |
570284 | 570284 | 2020-09-26 | Yolo | California | 6113 | 2795 | 55 |
567042 | 567042 | 2020-09-25 | Yolo | California | 6113 | 2789 | 55 |
563802 | 563802 | 2020-09-24 | Yolo | California | 6113 | 2782 | 55 |
560563 | 560563 | 2020-09-23 | Yolo | California | 6113 | 2773 | 55 |
557327 | 557327 | 2020-09-22 | Yolo | California | 6113 | 2765 | 54 |
554090 | 554090 | 2020-09-21 | Yolo | California | 6113 | 2754 | 54 |
550851 | 550851 | 2020-09-20 | Yolo | California | 6113 | 2747 | 54 |
547612 | 547612 | 2020-09-19 | Yolo | California | 6113 | 2740 | 54 |
544374 | 544374 | 2020-09-18 | Yolo | California | 6113 | 2732 | 53 |
541138 | 541138 | 2020-09-17 | Yolo | California | 6113 | 2721 | 53 |
537901 | 537901 | 2020-09-16 | Yolo | California | 6113 | 2710 | 53 |
534665 | 534665 | 2020-09-15 | Yolo | California | 6113 | 2710 | 53 |
531430 | 531430 | 2020-09-14 | Yolo | California | 6113 | 2689 | 53 |
528193 | 528193 | 2020-09-13 | Yolo | California | 6113 | 2677 | 53 |
524957 | 524957 | 2020-09-12 | Yolo | California | 6113 | 2650 | 53 |
521721 | 521721 | 2020-09-11 | Yolo | California | 6113 | 2633 | 53 |
518484 | 518484 | 2020-09-10 | Yolo | California | 6113 | 2611 | 53 |
515249 | 515249 | 2020-09-09 | Yolo | California | 6113 | 2597 | 53 |
512016 | 512016 | 2020-09-08 | Yolo | California | 6113 | 2565 | 53 |
508783 | 508783 | 2020-09-07 | Yolo | California | 6113 | 2564 | 53 |
505551 | 505551 | 2020-09-06 | Yolo | California | 6113 | 2541 | 53 |
502317 | 502317 | 2020-09-05 | Yolo | California | 6113 | 2524 | 53 |
499083 | 499083 | 2020-09-04 | Yolo | California | 6113 | 2495 | 53 |
495850 | 495850 | 2020-09-03 | Yolo | California | 6113 | 2478 | 53 |
492616 | 492616 | 2020-09-02 | Yolo | California | 6113 | 2451 | 52 |
489383 | 489383 | 2020-09-01 | Yolo | California | 6113 | 2438 | 52 |
486150 | 486150 | 2020-08-31 | Yolo | California | 6113 | 2424 | 52 |
482915 | 482915 | 2020-08-30 | Yolo | California | 6113 | 2386 | 52 |
479681 | 479681 | 2020-08-29 | Yolo | California | 6113 | 2335 | 51 |
476448 | 476448 | 2020-08-28 | Yolo | California | 6113 | 2310 | 51 |
473215 | 473215 | 2020-08-27 | Yolo | California | 6113 | 2287 | 51 |
469983 | 469983 | 2020-08-26 | Yolo | California | 6113 | 2274 | 49 |
466754 | 466754 | 2020-08-25 | Yolo | California | 6113 | 2255 | 49 |
463525 | 463525 | 2020-08-24 | Yolo | California | 6113 | 2239 | 47 |
460296 | 460296 | 2020-08-23 | Yolo | California | 6113 | 2205 | 47 |
457069 | 457069 | 2020-08-22 | Yolo | California | 6113 | 2184 | 47 |
453841 | 453841 | 2020-08-21 | Yolo | California | 6113 | 2164 | 47 |
450613 | 450613 | 2020-08-20 | Yolo | California | 6113 | 2147 | 47 |
447385 | 447385 | 2020-08-19 | Yolo | California | 6113 | 2118 | 47 |
444158 | 444158 | 2020-08-18 | Yolo | California | 6113 | 2097 | 46 |
440932 | 440932 | 2020-08-17 | Yolo | California | 6113 | 2076 | 46 |
437706 | 437706 | 2020-08-16 | Yolo | California | 6113 | 2046 | 46 |
434480 | 434480 | 2020-08-15 | Yolo | California | 6113 | 2019 | 46 |
431255 | 431255 | 2020-08-14 | Yolo | California | 6113 | 1966 | 46 |
428027 | 428027 | 2020-08-13 | Yolo | California | 6113 | 1927 | 45 |
424803 | 424803 | 2020-08-12 | Yolo | California | 6113 | 1918 | 45 |
421582 | 421582 | 2020-08-11 | Yolo | California | 6113 | 1898 | 45 |
418361 | 418361 | 2020-08-10 | Yolo | California | 6113 | 1834 | 44 |
415140 | 415140 | 2020-08-09 | Yolo | California | 6113 | 1759 | 44 |
411920 | 411920 | 2020-08-08 | Yolo | California | 6113 | 1721 | 43 |
408701 | 408701 | 2020-08-07 | Yolo | California | 6113 | 1690 | 43 |
405481 | 405481 | 2020-08-06 | Yolo | California | 6113 | 1660 | 42 |
402263 | 402263 | 2020-08-05 | Yolo | California | 6113 | 1636 | 42 |
399047 | 399047 | 2020-08-04 | Yolo | California | 6113 | 1614 | 42 |
395831 | 395831 | 2020-08-03 | Yolo | California | 6113 | 1588 | 42 |
392615 | 392615 | 2020-08-02 | Yolo | California | 6113 | 1572 | 42 |
389398 | 389398 | 2020-08-01 | Yolo | California | 6113 | 1544 | 42 |
386181 | 386181 | 2020-07-31 | Yolo | California | 6113 | 1511 | 41 |
382963 | 382963 | 2020-07-30 | Yolo | California | 6113 | 1494 | 41 |
379746 | 379746 | 2020-07-29 | Yolo | California | 6113 | 1477 | 41 |
376529 | 376529 | 2020-07-28 | Yolo | California | 6113 | 1446 | 39 |
373315 | 373315 | 2020-07-27 | Yolo | California | 6113 | 1424 | 37 |
370103 | 370103 | 2020-07-26 | Yolo | California | 6113 | 1394 | 37 |
366893 | 366893 | 2020-07-25 | Yolo | California | 6113 | 1342 | 37 |
363686 | 363686 | 2020-07-24 | Yolo | California | 6113 | 1315 | 37 |
360479 | 360479 | 2020-07-23 | Yolo | California | 6113 | 1275 | 37 |
357274 | 357274 | 2020-07-22 | Yolo | California | 6113 | 1225 | 35 |
354071 | 354071 | 2020-07-21 | Yolo | California | 6113 | 1200 | 34 |
350869 | 350869 | 2020-07-20 | Yolo | California | 6113 | 1196 | 34 |
347668 | 347668 | 2020-07-19 | Yolo | California | 6113 | 1162 | 32 |
344468 | 344468 | 2020-07-18 | Yolo | California | 6113 | 1123 | 31 |
341269 | 341269 | 2020-07-17 | Yolo | California | 6113 | 1101 | 31 |
338073 | 338073 | 2020-07-16 | Yolo | California | 6113 | 1062 | 30 |
334878 | 334878 | 2020-07-15 | Yolo | California | 6113 | 1023 | 30 |
331685 | 331685 | 2020-07-14 | Yolo | California | 6113 | 999 | 29 |
328499 | 328499 | 2020-07-13 | Yolo | California | 6113 | 966 | 28 |
325313 | 325313 | 2020-07-12 | Yolo | California | 6113 | 929 | 28 |
322132 | 322132 | 2020-07-11 | Yolo | California | 6113 | 884 | 28 |
318953 | 318953 | 2020-07-10 | Yolo | California | 6113 | 839 | 28 |
315780 | 315780 | 2020-07-09 | Yolo | California | 6113 | 802 | 28 |
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);