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 |
---|---|---|---|---|---|---|---|
1053724 | 1053724 | 2021-02-22 | Riverside | California | 6065 | 287822 | 3664 |
1050477 | 1050477 | 2021-02-21 | Riverside | California | 6065 | 287534 | 3633 |
1047230 | 1047230 | 2021-02-20 | Riverside | California | 6065 | 287534 | 3633 |
1043985 | 1043985 | 2021-02-19 | Riverside | California | 6065 | 287534 | 3633 |
1040740 | 1040740 | 2021-02-18 | Riverside | California | 6065 | 287200 | 3599 |
1037495 | 1037495 | 2021-02-17 | Riverside | California | 6065 | 287063 | 3577 |
1034250 | 1034250 | 2021-02-16 | Riverside | California | 6065 | 286590 | 3558 |
1031004 | 1031004 | 2021-02-15 | Riverside | California | 6065 | 285414 | 3524 |
1027757 | 1027757 | 2021-02-14 | Riverside | California | 6065 | 285414 | 3524 |
1024512 | 1024512 | 2021-02-13 | Riverside | California | 6065 | 285414 | 3524 |
1021267 | 1021267 | 2021-02-12 | Riverside | California | 6065 | 285414 | 3524 |
1018022 | 1018022 | 2021-02-11 | Riverside | California | 6065 | 284814 | 3477 |
1014777 | 1014777 | 2021-02-10 | Riverside | California | 6065 | 284168 | 3454 |
1011532 | 1011532 | 2021-02-09 | Riverside | California | 6065 | 283525 | 3414 |
1008286 | 1008286 | 2021-02-08 | Riverside | California | 6065 | 282736 | 3377 |
1005040 | 1005040 | 2021-02-07 | Riverside | California | 6065 | 280170 | 3320 |
1001794 | 1001794 | 2021-02-06 | Riverside | California | 6065 | 280170 | 3320 |
998548 | 998548 | 2021-02-05 | Riverside | California | 6065 | 280170 | 3320 |
995302 | 995302 | 2021-02-04 | Riverside | California | 6065 | 279189 | 3309 |
992056 | 992056 | 2021-02-03 | Riverside | California | 6065 | 277724 | 3278 |
988810 | 988810 | 2021-02-02 | Riverside | California | 6065 | 276931 | 3251 |
985563 | 985563 | 2021-02-01 | Riverside | California | 6065 | 275872 | 3171 |
982316 | 982316 | 2021-01-31 | Riverside | California | 6065 | 271910 | 3091 |
979070 | 979070 | 2021-01-30 | Riverside | California | 6065 | 271910 | 3091 |
975825 | 975825 | 2021-01-29 | Riverside | California | 6065 | 271910 | 3091 |
972580 | 972580 | 2021-01-28 | Riverside | California | 6065 | 270105 | 3058 |
969335 | 969335 | 2021-01-27 | Riverside | California | 6065 | 268490 | 3003 |
966091 | 966091 | 2021-01-26 | Riverside | California | 6065 | 266849 | 2970 |
962846 | 962846 | 2021-01-25 | Riverside | California | 6065 | 264363 | 2857 |
959601 | 959601 | 2021-01-24 | Riverside | California | 6065 | 258352 | 2777 |
956355 | 956355 | 2021-01-23 | Riverside | California | 6065 | 258352 | 2777 |
953110 | 953110 | 2021-01-22 | Riverside | California | 6065 | 258352 | 2777 |
949865 | 949865 | 2021-01-21 | Riverside | California | 6065 | 255808 | 2739 |
946619 | 946619 | 2021-01-20 | Riverside | California | 6065 | 251000 | 2676 |
943372 | 943372 | 2021-01-19 | Riverside | California | 6065 | 250436 | 2645 |
940127 | 940127 | 2021-01-18 | Riverside | California | 6065 | 242206 | 2517 |
936882 | 936882 | 2021-01-17 | Riverside | California | 6065 | 239412 | 2517 |
933637 | 933637 | 2021-01-16 | Riverside | California | 6065 | 235235 | 2517 |
930392 | 930392 | 2021-01-15 | Riverside | California | 6065 | 233899 | 2517 |
927147 | 927147 | 2021-01-14 | Riverside | California | 6065 | 233480 | 2399 |
923901 | 923901 | 2021-01-13 | Riverside | California | 6065 | 230600 | 2307 |
920656 | 920656 | 2021-01-12 | Riverside | California | 6065 | 227827 | 2294 |
917411 | 917411 | 2021-01-11 | Riverside | California | 6065 | 219486 | 2250 |
914166 | 914166 | 2021-01-10 | Riverside | California | 6065 | 216076 | 2218 |
910921 | 910921 | 2021-01-09 | Riverside | California | 6065 | 212122 | 2218 |
907676 | 907676 | 2021-01-08 | Riverside | California | 6065 | 208177 | 2218 |
904430 | 904430 | 2021-01-07 | Riverside | California | 6065 | 204327 | 2189 |
901185 | 901185 | 2021-01-06 | Riverside | California | 6065 | 203957 | 2151 |
897940 | 897940 | 2021-01-05 | Riverside | California | 6065 | 200056 | 2098 |
894695 | 894695 | 2021-01-04 | Riverside | California | 6065 | 198236 | 2096 |
891448 | 891448 | 2021-01-03 | Riverside | California | 6065 | 192069 | 1985 |
888201 | 888201 | 2021-01-02 | Riverside | California | 6065 | 188674 | 1985 |
884956 | 884956 | 2021-01-01 | Riverside | California | 6065 | 184193 | 1985 |
881711 | 881711 | 2020-12-31 | Riverside | California | 6065 | 180553 | 1985 |
878466 | 878466 | 2020-12-30 | Riverside | California | 6065 | 180537 | 1951 |
875221 | 875221 | 2020-12-29 | Riverside | California | 6065 | 176688 | 1943 |
871976 | 871976 | 2020-12-28 | Riverside | California | 6065 | 174477 | 1870 |
868731 | 868731 | 2020-12-27 | Riverside | California | 6065 | 169360 | 1829 |
865486 | 865486 | 2020-12-26 | Riverside | California | 6065 | 166690 | 1829 |
862241 | 862241 | 2020-12-25 | Riverside | California | 6065 | 162435 | 1829 |
858996 | 858996 | 2020-12-24 | Riverside | California | 6065 | 158110 | 1829 |
855751 | 855751 | 2020-12-23 | Riverside | California | 6065 | 156834 | 1805 |
852506 | 852506 | 2020-12-22 | Riverside | California | 6065 | 151713 | 1789 |
849261 | 849261 | 2020-12-21 | Riverside | California | 6065 | 150422 | 1753 |
846016 | 846016 | 2020-12-20 | Riverside | California | 6065 | 146703 | 1744 |
842770 | 842770 | 2020-12-19 | Riverside | California | 6065 | 142375 | 1744 |
839525 | 839525 | 2020-12-18 | Riverside | California | 6065 | 141062 | 1744 |
836280 | 836280 | 2020-12-17 | Riverside | California | 6065 | 135751 | 1708 |
833034 | 833034 | 2020-12-16 | Riverside | California | 6065 | 131822 | 1666 |
829787 | 829787 | 2020-12-15 | Riverside | California | 6065 | 123715 | 1628 |
826541 | 826541 | 2020-12-14 | Riverside | California | 6065 | 119691 | 1586 |
823294 | 823294 | 2020-12-13 | Riverside | California | 6065 | 118335 | 1573 |
820048 | 820048 | 2020-12-12 | Riverside | California | 6065 | 115329 | 1573 |
816802 | 816802 | 2020-12-11 | Riverside | California | 6065 | 112950 | 1573 |
813556 | 813556 | 2020-12-10 | Riverside | California | 6065 | 111053 | 1551 |
810312 | 810312 | 2020-12-09 | Riverside | California | 6065 | 107620 | 1539 |
807067 | 807067 | 2020-12-08 | Riverside | California | 6065 | 103221 | 1513 |
803822 | 803822 | 2020-12-07 | Riverside | California | 6065 | 100088 | 1488 |
800577 | 800577 | 2020-12-06 | Riverside | California | 6065 | 98612 | 1472 |
797332 | 797332 | 2020-12-05 | Riverside | California | 6065 | 95255 | 1472 |
794087 | 794087 | 2020-12-04 | Riverside | California | 6065 | 92489 | 1472 |
790842 | 790842 | 2020-12-03 | Riverside | California | 6065 | 90089 | 1457 |
787597 | 787597 | 2020-12-02 | Riverside | California | 6065 | 88530 | 1444 |
784353 | 784353 | 2020-12-01 | Riverside | California | 6065 | 87722 | 1443 |
781108 | 781108 | 2020-11-30 | Riverside | California | 6065 | 87383 | 1442 |
777862 | 777862 | 2020-11-29 | Riverside | California | 6065 | 86854 | 1437 |
774617 | 774617 | 2020-11-28 | Riverside | California | 6065 | 85769 | 1437 |
771372 | 771372 | 2020-11-27 | Riverside | California | 6065 | 85774 | 1437 |
768127 | 768127 | 2020-11-26 | Riverside | California | 6065 | 85077 | 1434 |
764881 | 764881 | 2020-11-25 | Riverside | California | 6065 | 83685 | 1434 |
761636 | 761636 | 2020-11-24 | Riverside | California | 6065 | 82175 | 1417 |
758391 | 758391 | 2020-11-23 | Riverside | California | 6065 | 81565 | 1413 |
755144 | 755144 | 2020-11-22 | Riverside | California | 6065 | 80676 | 1400 |
751898 | 751898 | 2020-11-21 | Riverside | California | 6065 | 79613 | 1400 |
748652 | 748652 | 2020-11-20 | Riverside | California | 6065 | 78535 | 1400 |
745406 | 745406 | 2020-11-19 | Riverside | California | 6065 | 78009 | 1396 |
742159 | 742159 | 2020-11-18 | Riverside | California | 6065 | 77636 | 1383 |
738912 | 738912 | 2020-11-17 | Riverside | California | 6065 | 76724 | 1374 |
735668 | 735668 | 2020-11-16 | Riverside | California | 6065 | 75848 | 1374 |
732422 | 732422 | 2020-11-15 | Riverside | California | 6065 | 74910 | 1367 |
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);