ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "San Bernardino" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193330 | 1193330 | 2021-04-06 | San Bernardino | California | 6071 | 291728 | 4425 |
1190080 | 1190080 | 2021-04-05 | San Bernardino | California | 6071 | 291727 | 4423 |
1186833 | 1186833 | 2021-04-04 | San Bernardino | California | 6071 | 291648 | 4422 |
1183586 | 1183586 | 2021-04-03 | San Bernardino | California | 6071 | 291360 | 4417 |
1180339 | 1180339 | 2021-04-02 | San Bernardino | California | 6071 | 291199 | 4404 |
1177092 | 1177092 | 2021-04-01 | San Bernardino | California | 6071 | 291022 | 4356 |
1173845 | 1173845 | 2021-03-31 | San Bernardino | California | 6071 | 290954 | 4343 |
1170598 | 1170598 | 2021-03-30 | San Bernardino | California | 6071 | 290803 | 4335 |
1167350 | 1167350 | 2021-03-29 | San Bernardino | California | 6071 | 290715 | 4332 |
1164102 | 1164102 | 2021-03-28 | San Bernardino | California | 6071 | 290630 | 4325 |
1160854 | 1160854 | 2021-03-27 | San Bernardino | California | 6071 | 290505 | 4288 |
1157606 | 1157606 | 2021-03-26 | San Bernardino | California | 6071 | 290315 | 4222 |
1154359 | 1154359 | 2021-03-25 | San Bernardino | California | 6071 | 290155 | 4170 |
1151112 | 1151112 | 2021-03-24 | San Bernardino | California | 6071 | 290030 | 4134 |
1147865 | 1147865 | 2021-03-23 | San Bernardino | California | 6071 | 289892 | 4107 |
1144618 | 1144618 | 2021-03-22 | San Bernardino | California | 6071 | 289846 | 4094 |
1141371 | 1141371 | 2021-03-21 | San Bernardino | California | 6071 | 289773 | 4076 |
1138125 | 1138125 | 2021-03-20 | San Bernardino | California | 6071 | 289610 | 4076 |
1134879 | 1134879 | 2021-03-19 | San Bernardino | California | 6071 | 289405 | 4076 |
1131632 | 1131632 | 2021-03-18 | San Bernardino | California | 6071 | 289242 | 4049 |
1128384 | 1128384 | 2021-03-17 | San Bernardino | California | 6071 | 289057 | 4032 |
1125138 | 1125138 | 2021-03-16 | San Bernardino | California | 6071 | 288932 | 4004 |
1121892 | 1121892 | 2021-03-15 | San Bernardino | California | 6071 | 288868 | 3996 |
1118645 | 1118645 | 2021-03-14 | San Bernardino | California | 6071 | 288787 | 3972 |
1115398 | 1115398 | 2021-03-13 | San Bernardino | California | 6071 | 288599 | 3917 |
1112152 | 1112152 | 2021-03-12 | San Bernardino | California | 6071 | 288364 | 3282 |
1108906 | 1108906 | 2021-03-11 | San Bernardino | California | 6071 | 288297 | 3225 |
1105660 | 1105660 | 2021-03-10 | San Bernardino | California | 6071 | 288135 | 3198 |
1102414 | 1102414 | 2021-03-09 | San Bernardino | California | 6071 | 288045 | 3180 |
1099168 | 1099168 | 2021-03-08 | San Bernardino | California | 6071 | 288044 | 3176 |
1095920 | 1095920 | 2021-03-07 | San Bernardino | California | 6071 | 287867 | 3153 |
1092674 | 1092674 | 2021-03-06 | San Bernardino | California | 6071 | 287782 | 3137 |
1089428 | 1089428 | 2021-03-05 | San Bernardino | California | 6071 | 287513 | 3116 |
1086183 | 1086183 | 2021-03-04 | San Bernardino | California | 6071 | 287246 | 3022 |
1082937 | 1082937 | 2021-03-03 | San Bernardino | California | 6071 | 287055 | 2959 |
1079691 | 1079691 | 2021-03-02 | San Bernardino | California | 6071 | 286814 | 2952 |
1076446 | 1076446 | 2021-03-01 | San Bernardino | California | 6071 | 286755 | 2940 |
1073200 | 1073200 | 2021-02-28 | San Bernardino | California | 6071 | 286607 | 2874 |
1069954 | 1069954 | 2021-02-27 | San Bernardino | California | 6071 | 286291 | 2816 |
1066709 | 1066709 | 2021-02-26 | San Bernardino | California | 6071 | 286077 | 2783 |
1063464 | 1063464 | 2021-02-25 | San Bernardino | California | 6071 | 285334 | 2673 |
1060219 | 1060219 | 2021-02-24 | San Bernardino | California | 6071 | 285334 | 2673 |
1056973 | 1056973 | 2021-02-23 | San Bernardino | California | 6071 | 285081 | 2651 |
1053727 | 1053727 | 2021-02-22 | San Bernardino | California | 6071 | 284866 | 2637 |
1050480 | 1050480 | 2021-02-21 | San Bernardino | California | 6071 | 284639 | 2612 |
1047233 | 1047233 | 2021-02-20 | San Bernardino | California | 6071 | 284280 | 2557 |
1043988 | 1043988 | 2021-02-19 | San Bernardino | California | 6071 | 283873 | 2522 |
1040743 | 1040743 | 2021-02-18 | San Bernardino | California | 6071 | 283356 | 2492 |
1037498 | 1037498 | 2021-02-17 | San Bernardino | California | 6071 | 282736 | 2457 |
1034253 | 1034253 | 2021-02-16 | San Bernardino | California | 6071 | 282494 | 2418 |
1031007 | 1031007 | 2021-02-15 | San Bernardino | California | 6071 | 282494 | 2418 |
1027760 | 1027760 | 2021-02-14 | San Bernardino | California | 6071 | 282169 | 2392 |
1024515 | 1024515 | 2021-02-13 | San Bernardino | California | 6071 | 281604 | 2352 |
1021270 | 1021270 | 2021-02-12 | San Bernardino | California | 6071 | 280949 | 2308 |
1018025 | 1018025 | 2021-02-11 | San Bernardino | California | 6071 | 280068 | 2243 |
1014780 | 1014780 | 2021-02-10 | San Bernardino | California | 6071 | 279673 | 2184 |
1011535 | 1011535 | 2021-02-09 | San Bernardino | California | 6071 | 279412 | 2142 |
1008289 | 1008289 | 2021-02-08 | San Bernardino | California | 6071 | 278802 | 2141 |
1005043 | 1005043 | 2021-02-07 | San Bernardino | California | 6071 | 277949 | 2125 |
1001797 | 1001797 | 2021-02-06 | San Bernardino | California | 6071 | 277949 | 2125 |
998551 | 998551 | 2021-02-05 | San Bernardino | California | 6071 | 277430 | 2080 |
995305 | 995305 | 2021-02-04 | San Bernardino | California | 6071 | 276606 | 2041 |
992059 | 992059 | 2021-02-03 | San Bernardino | California | 6071 | 275960 | 1966 |
988813 | 988813 | 2021-02-02 | San Bernardino | California | 6071 | 275372 | 1917 |
985566 | 985566 | 2021-02-01 | San Bernardino | California | 6071 | 275076 | 1856 |
982319 | 982319 | 2021-01-31 | San Bernardino | California | 6071 | 274429 | 1839 |
979073 | 979073 | 2021-01-30 | San Bernardino | California | 6071 | 273520 | 1821 |
975828 | 975828 | 2021-01-29 | San Bernardino | California | 6071 | 272198 | 1798 |
972583 | 972583 | 2021-01-28 | San Bernardino | California | 6071 | 271189 | 1776 |
969338 | 969338 | 2021-01-27 | San Bernardino | California | 6071 | 269314 | 1746 |
966094 | 966094 | 2021-01-26 | San Bernardino | California | 6071 | 268542 | 1719 |
962849 | 962849 | 2021-01-25 | San Bernardino | California | 6071 | 266028 | 1678 |
959604 | 959604 | 2021-01-24 | San Bernardino | California | 6071 | 264457 | 1667 |
956358 | 956358 | 2021-01-23 | San Bernardino | California | 6071 | 262858 | 1594 |
953113 | 953113 | 2021-01-22 | San Bernardino | California | 6071 | 261199 | 1579 |
949868 | 949868 | 2021-01-21 | San Bernardino | California | 6071 | 258742 | 1561 |
946622 | 946622 | 2021-01-20 | San Bernardino | California | 6071 | 256914 | 1560 |
943375 | 943375 | 2021-01-19 | San Bernardino | California | 6071 | 256109 | 1560 |
940130 | 940130 | 2021-01-18 | San Bernardino | California | 6071 | 254094 | 1560 |
936885 | 936885 | 2021-01-17 | San Bernardino | California | 6071 | 251213 | 1560 |
933640 | 933640 | 2021-01-16 | San Bernardino | California | 6071 | 248285 | 1560 |
930395 | 930395 | 2021-01-15 | San Bernardino | California | 6071 | 245033 | 1560 |
927150 | 927150 | 2021-01-14 | San Bernardino | California | 6071 | 241523 | 1560 |
923904 | 923904 | 2021-01-13 | San Bernardino | California | 6071 | 239786 | 1552 |
920659 | 920659 | 2021-01-12 | San Bernardino | California | 6071 | 235543 | 1551 |
917414 | 917414 | 2021-01-11 | San Bernardino | California | 6071 | 232171 | 1546 |
914169 | 914169 | 2021-01-10 | San Bernardino | California | 6071 | 228857 | 1531 |
910924 | 910924 | 2021-01-09 | San Bernardino | California | 6071 | 224350 | 1520 |
907679 | 907679 | 2021-01-08 | San Bernardino | California | 6071 | 219691 | 1486 |
904433 | 904433 | 2021-01-07 | San Bernardino | California | 6071 | 216394 | 1454 |
901188 | 901188 | 2021-01-06 | San Bernardino | California | 6071 | 214813 | 1454 |
897943 | 897943 | 2021-01-05 | San Bernardino | California | 6071 | 213357 | 1450 |
894698 | 894698 | 2021-01-04 | San Bernardino | California | 6071 | 208271 | 1449 |
891451 | 891451 | 2021-01-03 | San Bernardino | California | 6071 | 206939 | 1447 |
888204 | 888204 | 2021-01-02 | San Bernardino | California | 6071 | 203651 | 1445 |
884959 | 884959 | 2021-01-01 | San Bernardino | California | 6071 | 199115 | 1445 |
881714 | 881714 | 2020-12-31 | San Bernardino | California | 6071 | 194377 | 1445 |
878469 | 878469 | 2020-12-30 | San Bernardino | California | 6071 | 193214 | 1442 |
875224 | 875224 | 2020-12-29 | San Bernardino | California | 6071 | 191087 | 1438 |
871979 | 871979 | 2020-12-28 | San Bernardino | California | 6071 | 186776 | 1437 |
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);