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 |
---|---|---|---|---|---|---|---|
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 |
868734 | 868734 | 2020-12-27 | San Bernardino | California | 6071 | 185111 | 1437 |
865489 | 865489 | 2020-12-26 | San Bernardino | California | 6071 | 181812 | 1429 |
862244 | 862244 | 2020-12-25 | San Bernardino | California | 6071 | 176866 | 1420 |
858999 | 858999 | 2020-12-24 | San Bernardino | California | 6071 | 174091 | 1420 |
855754 | 855754 | 2020-12-23 | San Bernardino | California | 6071 | 170885 | 1407 |
852509 | 852509 | 2020-12-22 | San Bernardino | California | 6071 | 168307 | 1387 |
849264 | 849264 | 2020-12-21 | San Bernardino | California | 6071 | 163945 | 1375 |
846019 | 846019 | 2020-12-20 | San Bernardino | California | 6071 | 159883 | 1327 |
842773 | 842773 | 2020-12-19 | San Bernardino | California | 6071 | 157655 | 1327 |
839528 | 839528 | 2020-12-18 | San Bernardino | California | 6071 | 151113 | 1323 |
836283 | 836283 | 2020-12-17 | San Bernardino | California | 6071 | 144455 | 1323 |
833037 | 833037 | 2020-12-16 | San Bernardino | California | 6071 | 137548 | 1304 |
829790 | 829790 | 2020-12-15 | San Bernardino | California | 6071 | 129522 | 1241 |
826544 | 826544 | 2020-12-14 | San Bernardino | California | 6071 | 127791 | 1241 |
823297 | 823297 | 2020-12-13 | San Bernardino | California | 6071 | 126738 | 1223 |
820051 | 820051 | 2020-12-12 | San Bernardino | California | 6071 | 124264 | 1215 |
816805 | 816805 | 2020-12-11 | San Bernardino | California | 6071 | 120186 | 1209 |
813559 | 813559 | 2020-12-10 | San Bernardino | California | 6071 | 115641 | 1209 |
810315 | 810315 | 2020-12-09 | San Bernardino | California | 6071 | 111518 | 1208 |
807070 | 807070 | 2020-12-08 | San Bernardino | California | 6071 | 108946 | 1207 |
803825 | 803825 | 2020-12-07 | San Bernardino | California | 6071 | 107928 | 1188 |
800580 | 800580 | 2020-12-06 | San Bernardino | California | 6071 | 106770 | 1175 |
797335 | 797335 | 2020-12-05 | San Bernardino | California | 6071 | 103911 | 1175 |
794090 | 794090 | 2020-12-04 | San Bernardino | California | 6071 | 100787 | 1175 |
790845 | 790845 | 2020-12-03 | San Bernardino | California | 6071 | 99104 | 1154 |
787600 | 787600 | 2020-12-02 | San Bernardino | California | 6071 | 96657 | 1136 |
784356 | 784356 | 2020-12-01 | San Bernardino | California | 6071 | 94106 | 1129 |
781111 | 781111 | 2020-11-30 | San Bernardino | California | 6071 | 93671 | 1129 |
777865 | 777865 | 2020-11-29 | San Bernardino | California | 6071 | 93019 | 1129 |
774620 | 774620 | 2020-11-28 | San Bernardino | California | 6071 | 92164 | 1129 |
771375 | 771375 | 2020-11-27 | San Bernardino | California | 6071 | 90222 | 1129 |
768130 | 768130 | 2020-11-26 | San Bernardino | California | 6071 | 88469 | 1129 |
764884 | 764884 | 2020-11-25 | San Bernardino | California | 6071 | 88453 | 1129 |
761639 | 761639 | 2020-11-24 | San Bernardino | California | 6071 | 87542 | 1129 |
758394 | 758394 | 2020-11-23 | San Bernardino | California | 6071 | 85176 | 1129 |
755147 | 755147 | 2020-11-22 | San Bernardino | California | 6071 | 84531 | 1129 |
751901 | 751901 | 2020-11-21 | San Bernardino | California | 6071 | 84201 | 1127 |
748655 | 748655 | 2020-11-20 | San Bernardino | California | 6071 | 81328 | 1125 |
745409 | 745409 | 2020-11-19 | San Bernardino | California | 6071 | 80318 | 1124 |
742162 | 742162 | 2020-11-18 | San Bernardino | California | 6071 | 78298 | 1118 |
738915 | 738915 | 2020-11-17 | San Bernardino | California | 6071 | 76685 | 1098 |
735671 | 735671 | 2020-11-16 | San Bernardino | California | 6071 | 74929 | 1098 |
732425 | 732425 | 2020-11-15 | San Bernardino | California | 6071 | 74166 | 1097 |
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);