ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 6065 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193327 | 1193327 | 2021-04-06 | Riverside | California | 6065 | 295631 | 4417 |
1190077 | 1190077 | 2021-04-05 | Riverside | California | 6065 | 295426 | 4389 |
1186830 | 1186830 | 2021-04-04 | Riverside | California | 6065 | 294736 | 4362 |
1183583 | 1183583 | 2021-04-03 | Riverside | California | 6065 | 294736 | 4362 |
1180336 | 1180336 | 2021-04-02 | Riverside | California | 6065 | 294736 | 4362 |
1177089 | 1177089 | 2021-04-01 | Riverside | California | 6065 | 294617 | 4339 |
1173842 | 1173842 | 2021-03-31 | Riverside | California | 6065 | 294461 | 4315 |
1170595 | 1170595 | 2021-03-30 | Riverside | California | 6065 | 294192 | 4297 |
1167347 | 1167347 | 2021-03-29 | Riverside | California | 6065 | 294063 | 4273 |
1164099 | 1164099 | 2021-03-28 | Riverside | California | 6065 | 293831 | 4248 |
1160851 | 1160851 | 2021-03-27 | Riverside | California | 6065 | 293831 | 4248 |
1157603 | 1157603 | 2021-03-26 | Riverside | California | 6065 | 293831 | 4248 |
1154356 | 1154356 | 2021-03-25 | Riverside | California | 6065 | 293707 | 4214 |
1151109 | 1151109 | 2021-03-24 | Riverside | California | 6065 | 293600 | 4190 |
1147862 | 1147862 | 2021-03-23 | Riverside | California | 6065 | 293436 | 4164 |
1144615 | 1144615 | 2021-03-22 | Riverside | California | 6065 | 293149 | 4141 |
1141368 | 1141368 | 2021-03-21 | Riverside | California | 6065 | 292967 | 4117 |
1138122 | 1138122 | 2021-03-20 | Riverside | California | 6065 | 292967 | 4117 |
1134876 | 1134876 | 2021-03-19 | Riverside | California | 6065 | 292967 | 4117 |
1131629 | 1131629 | 2021-03-18 | Riverside | California | 6065 | 292817 | 4097 |
1128381 | 1128381 | 2021-03-17 | Riverside | California | 6065 | 292606 | 4052 |
1125135 | 1125135 | 2021-03-16 | Riverside | California | 6065 | 292403 | 4011 |
1121889 | 1121889 | 2021-03-15 | Riverside | California | 6065 | 292293 | 3984 |
1118642 | 1118642 | 2021-03-14 | Riverside | California | 6065 | 291866 | 3971 |
1115395 | 1115395 | 2021-03-13 | Riverside | California | 6065 | 291866 | 3971 |
1112149 | 1112149 | 2021-03-12 | Riverside | California | 6065 | 291866 | 3971 |
1108903 | 1108903 | 2021-03-11 | Riverside | California | 6065 | 291675 | 3941 |
1105657 | 1105657 | 2021-03-10 | Riverside | California | 6065 | 291675 | 3941 |
1102411 | 1102411 | 2021-03-09 | Riverside | California | 6065 | 291492 | 3940 |
1099165 | 1099165 | 2021-03-08 | Riverside | California | 6065 | 291040 | 3912 |
1095917 | 1095917 | 2021-03-07 | Riverside | California | 6065 | 290904 | 3892 |
1092671 | 1092671 | 2021-03-06 | Riverside | California | 6065 | 290904 | 3892 |
1089425 | 1089425 | 2021-03-05 | Riverside | California | 6065 | 290904 | 3892 |
1086180 | 1086180 | 2021-03-04 | Riverside | California | 6065 | 290744 | 3884 |
1082934 | 1082934 | 2021-03-03 | Riverside | California | 6065 | 290498 | 3849 |
1079688 | 1079688 | 2021-03-02 | Riverside | California | 6065 | 290325 | 3829 |
1076443 | 1076443 | 2021-03-01 | Riverside | California | 6065 | 289773 | 3792 |
1073197 | 1073197 | 2021-02-28 | Riverside | California | 6065 | 289450 | 3767 |
1069951 | 1069951 | 2021-02-27 | Riverside | California | 6065 | 289450 | 3767 |
1066706 | 1066706 | 2021-02-26 | Riverside | California | 6065 | 289450 | 3767 |
1063461 | 1063461 | 2021-02-25 | Riverside | California | 6065 | 289185 | 3749 |
1060216 | 1060216 | 2021-02-24 | Riverside | California | 6065 | 288960 | 3707 |
1056970 | 1056970 | 2021-02-23 | Riverside | California | 6065 | 288541 | 3695 |
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 |
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);