ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Riverside" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635103 | 635103 | 2020-10-16 | Riverside | California | 6065 | 63284 | 1269 |
631857 | 631857 | 2020-10-15 | Riverside | California | 6065 | 63125 | 1269 |
628613 | 628613 | 2020-10-14 | Riverside | California | 6065 | 62900 | 1264 |
625370 | 625370 | 2020-10-13 | Riverside | California | 6065 | 62553 | 1258 |
622127 | 622127 | 2020-10-12 | Riverside | California | 6065 | 62112 | 1256 |
618884 | 618884 | 2020-10-11 | Riverside | California | 6065 | 61845 | 1256 |
615642 | 615642 | 2020-10-10 | Riverside | California | 6065 | 61824 | 1256 |
612401 | 612401 | 2020-10-09 | Riverside | California | 6065 | 61824 | 1256 |
609159 | 609159 | 2020-10-08 | Riverside | California | 6065 | 61416 | 1248 |
605916 | 605916 | 2020-10-07 | Riverside | California | 6065 | 61133 | 1247 |
602674 | 602674 | 2020-10-06 | Riverside | California | 6065 | 60867 | 1244 |
599431 | 599431 | 2020-10-05 | Riverside | California | 6065 | 60738 | 1238 |
596188 | 596188 | 2020-10-04 | Riverside | California | 6065 | 59991 | 1231 |
592946 | 592946 | 2020-10-03 | Riverside | California | 6065 | 59934 | 1231 |
589706 | 589706 | 2020-10-02 | Riverside | California | 6065 | 59934 | 1231 |
586465 | 586465 | 2020-10-01 | Riverside | California | 6065 | 59488 | 1226 |
583225 | 583225 | 2020-09-30 | Riverside | California | 6065 | 59405 | 1226 |
579986 | 579986 | 2020-09-29 | Riverside | California | 6065 | 59173 | 1216 |
576745 | 576745 | 2020-09-28 | Riverside | California | 6065 | 58932 | 1206 |
573502 | 573502 | 2020-09-27 | Riverside | California | 6065 | 58178 | 1189 |
570260 | 570260 | 2020-09-26 | Riverside | California | 6065 | 58178 | 1189 |
567018 | 567018 | 2020-09-25 | Riverside | California | 6065 | 58178 | 1189 |
563778 | 563778 | 2020-09-24 | Riverside | California | 6065 | 57883 | 1179 |
560539 | 560539 | 2020-09-23 | Riverside | California | 6065 | 57695 | 1173 |
557303 | 557303 | 2020-09-22 | Riverside | California | 6065 | 57482 | 1172 |
554066 | 554066 | 2020-09-21 | Riverside | California | 6065 | 57419 | 1162 |
550827 | 550827 | 2020-09-20 | Riverside | California | 6065 | 56681 | 1153 |
547588 | 547588 | 2020-09-19 | Riverside | California | 6065 | 56681 | 1153 |
544350 | 544350 | 2020-09-18 | Riverside | California | 6065 | 56681 | 1153 |
541114 | 541114 | 2020-09-17 | Riverside | California | 6065 | 56374 | 1143 |
537877 | 537877 | 2020-09-16 | Riverside | California | 6065 | 56201 | 1136 |
534641 | 534641 | 2020-09-15 | Riverside | California | 6065 | 55986 | 1125 |
531406 | 531406 | 2020-09-14 | Riverside | California | 6065 | 55766 | 1118 |
528169 | 528169 | 2020-09-13 | Riverside | California | 6065 | 55073 | 1103 |
524933 | 524933 | 2020-09-12 | Riverside | California | 6065 | 55073 | 1103 |
521697 | 521697 | 2020-09-11 | Riverside | California | 6065 | 55073 | 1103 |
518460 | 518460 | 2020-09-10 | Riverside | California | 6065 | 54868 | 1094 |
515225 | 515225 | 2020-09-09 | Riverside | California | 6065 | 54735 | 1085 |
511992 | 511992 | 2020-09-08 | Riverside | California | 6065 | 54572 | 1075 |
508759 | 508759 | 2020-09-07 | Riverside | California | 6065 | 53987 | 1067 |
505527 | 505527 | 2020-09-06 | Riverside | California | 6065 | 53987 | 1067 |
502293 | 502293 | 2020-09-05 | Riverside | California | 6065 | 53987 | 1067 |
499059 | 499059 | 2020-09-04 | Riverside | California | 6065 | 53987 | 1067 |
495826 | 495826 | 2020-09-03 | Riverside | California | 6065 | 53703 | 1053 |
492592 | 492592 | 2020-09-02 | Riverside | California | 6065 | 53306 | 1033 |
489359 | 489359 | 2020-09-01 | Riverside | California | 6065 | 53153 | 1026 |
486126 | 486126 | 2020-08-31 | Riverside | California | 6065 | 52909 | 1019 |
482891 | 482891 | 2020-08-30 | Riverside | California | 6065 | 51918 | 1007 |
479657 | 479657 | 2020-08-29 | Riverside | California | 6065 | 51860 | 1007 |
476424 | 476424 | 2020-08-28 | Riverside | California | 6065 | 51860 | 1007 |
473191 | 473191 | 2020-08-27 | Riverside | California | 6065 | 51734 | 997 |
469959 | 469959 | 2020-08-26 | Riverside | California | 6065 | 51538 | 984 |
466730 | 466730 | 2020-08-25 | Riverside | California | 6065 | 51200 | 978 |
463501 | 463501 | 2020-08-24 | Riverside | California | 6065 | 50744 | 972 |
460272 | 460272 | 2020-08-23 | Riverside | California | 6065 | 49944 | 927 |
457045 | 457045 | 2020-08-22 | Riverside | California | 6065 | 49482 | 927 |
453817 | 453817 | 2020-08-21 | Riverside | California | 6065 | 49482 | 927 |
450589 | 450589 | 2020-08-20 | Riverside | California | 6065 | 48956 | 922 |
447361 | 447361 | 2020-08-19 | Riverside | California | 6065 | 48630 | 917 |
444134 | 444134 | 2020-08-18 | Riverside | California | 6065 | 48200 | 913 |
440908 | 440908 | 2020-08-17 | Riverside | California | 6065 | 47669 | 912 |
437682 | 437682 | 2020-08-16 | Riverside | California | 6065 | 46720 | 881 |
434456 | 434456 | 2020-08-15 | Riverside | California | 6065 | 46456 | 881 |
431231 | 431231 | 2020-08-14 | Riverside | California | 6065 | 45662 | 881 |
428003 | 428003 | 2020-08-13 | Riverside | California | 6065 | 44747 | 879 |
424779 | 424779 | 2020-08-12 | Riverside | California | 6065 | 44237 | 853 |
421558 | 421558 | 2020-08-11 | Riverside | California | 6065 | 43376 | 824 |
418337 | 418337 | 2020-08-10 | Riverside | California | 6065 | 41983 | 820 |
415116 | 415116 | 2020-08-09 | Riverside | California | 6065 | 41412 | 799 |
411896 | 411896 | 2020-08-08 | Riverside | California | 6065 | 40902 | 799 |
408677 | 408677 | 2020-08-07 | Riverside | California | 6065 | 40452 | 799 |
405457 | 405457 | 2020-08-06 | Riverside | California | 6065 | 39741 | 770 |
402239 | 402239 | 2020-08-05 | Riverside | California | 6065 | 38991 | 752 |
399023 | 399023 | 2020-08-04 | Riverside | California | 6065 | 38642 | 738 |
395807 | 395807 | 2020-08-03 | Riverside | California | 6065 | 38507 | 737 |
392591 | 392591 | 2020-08-02 | Riverside | California | 6065 | 38216 | 695 |
389374 | 389374 | 2020-08-01 | Riverside | California | 6065 | 37612 | 695 |
386157 | 386157 | 2020-07-31 | Riverside | California | 6065 | 37308 | 695 |
382939 | 382939 | 2020-07-30 | Riverside | California | 6065 | 36968 | 688 |
379722 | 379722 | 2020-07-29 | Riverside | California | 6065 | 36458 | 682 |
376505 | 376505 | 2020-07-28 | Riverside | California | 6065 | 35910 | 672 |
373291 | 373291 | 2020-07-27 | Riverside | California | 6065 | 35636 | 671 |
370079 | 370079 | 2020-07-26 | Riverside | California | 6065 | 34921 | 637 |
366869 | 366869 | 2020-07-25 | Riverside | California | 6065 | 34513 | 637 |
363662 | 363662 | 2020-07-24 | Riverside | California | 6065 | 33833 | 637 |
360455 | 360455 | 2020-07-23 | Riverside | California | 6065 | 33093 | 637 |
357250 | 357250 | 2020-07-22 | Riverside | California | 6065 | 32231 | 617 |
354047 | 354047 | 2020-07-21 | Riverside | California | 6065 | 31163 | 589 |
350845 | 350845 | 2020-07-20 | Riverside | California | 6065 | 30340 | 588 |
347644 | 347644 | 2020-07-19 | Riverside | California | 6065 | 30245 | 587 |
344444 | 344444 | 2020-07-18 | Riverside | California | 6065 | 29639 | 587 |
341245 | 341245 | 2020-07-17 | Riverside | California | 6065 | 28904 | 587 |
338049 | 338049 | 2020-07-16 | Riverside | California | 6065 | 28492 | 585 |
334854 | 334854 | 2020-07-15 | Riverside | California | 6065 | 27850 | 577 |
331661 | 331661 | 2020-07-14 | Riverside | California | 6065 | 27136 | 553 |
328475 | 328475 | 2020-07-13 | Riverside | California | 6065 | 26404 | 550 |
325289 | 325289 | 2020-07-12 | Riverside | California | 6065 | 25994 | 537 |
322108 | 322108 | 2020-07-11 | Riverside | California | 6065 | 25481 | 537 |
318929 | 318929 | 2020-07-10 | Riverside | California | 6065 | 24980 | 537 |
315756 | 315756 | 2020-07-09 | Riverside | California | 6065 | 24042 | 533 |
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);