ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "San Bernardino" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 499 ✖
- 1129 10
- 0 9
- 1560 7
- 229 6
- 908 6
- 5545 6
- 5557 6
- 6892 6
- 3 5
- 716 5
- 986 5
- 1096 5
- 5236 5
- 5815 5
- 5944 5
- 176 4
- 224 4
- 249 4
- 269 4
- 765 4
- 962 4
- 4707 4
- 4724 4
- 5003 4
- 5295 4
- 5301 4
- 5777 4
- 5901 4
- 6007 4
- 6043 4
- 6051 4
- 6400 4
- 6865 4
- 6948 4
- 7047 4
- 7191 4
- 7306 4
- 13 3
- 31 3
- 82 3
- 121 3
- 155 3
- 204 3
- 304 3
- 568 3
- 925 3
- 1072 3
- 1073 3
- 1097 3
- 1175 3
- 1445 3
- 4076 3
- 4747 3
- 4758 3
- 4788 3
- 4928 3
- 5117 3
- 5218 3
- 5240 3
- 5324 3
- 5348 3
- 5540 3
- 5566 3
- 5692 3
- 5983 3
- 6017 3
- 6122 3
- 6233 3
- 6259 3
- 6267 3
- 6297 3
- 6322 3
- 6335 3
- 6360 3
- 6505 3
- 6641 3
- 6734 3
- 6778 3
- 6840 3
- 6883 3
- 6977 3
- 7105 3
- 7240 3
- 7354 3
- 6 2
- 25 2
- 57 2
- 67 2
- 99 2
- 230 2
- 233 2
- 234 2
- 310 2
- 328 2
- 395 2
- 417 2
- 546 2
- 691 2
- 744 2
- 832 2
- 955 2
- 1021 2
- 1070 2
- 1078 2
- 1079 2
- 1092 2
- 1098 2
- 1209 2
- 1241 2
- 1323 2
- 1327 2
- 1420 2
- 1437 2
- 1454 2
- 2125 2
- 2418 2
- 2673 2
- 4568 2
- 4571 2
- 4572 2
- 4755 2
- 4757 2
- 4782 2
- 4790 2
- 5237 2
- 5284 2
- 5555 2
- 5849 2
- 5873 2
- 5898 2
- 5998 2
- 6011 2
- 6013 2
- 6023 2
- 6047 2
- 6302 2
- 6372 2
- 6767 2
- 6862 2
- 1 1
- 2 1
- 8 1
- 16 1
- 17 1
- 20 1
- 24 1
- 39 1
- 47 1
- 55 1
- 60 1
- 72 1
- 80 1
- 85 1
- 89 1
- 93 1
- 96 1
- 98 1
- 101 1
- 104 1
- 108 1
- 111 1
- 119 1
- 138 1
- 139 1
- 150 1
- 157 1
- 158 1
- 164 1
- 173 1
- 183 1
- 190 1
- 199 1
- 208 1
- 209 1
- 210 1
- 217 1
- 225 1
- 227 1
- 245 1
- 248 1
- 253 1
- 258 1
- 265 1
- 272 1
- 293 1
- 306 1
- 307 1
- 309 1
- 315 1
- 329 1
- 333 1
- 337 1
- 358 1
- 372 1
- 376 1
- 383 1
- 384 1
- 403 1
- 409 1
- 418 1
- 477 1
- 487 1
- 490 1
- 497 1
- 502 1
- 549 1
- 555 1
- 558 1
- 561 1
- 616 1
- 621 1
- 625 1
- 629 1
- 692 1
- 695 1
- 709 1
- 715 1
- 743 1
- 791 1
- 796 1
- 800 1
- 814 1
- 835 1
- 838 1
- 839 1
- 858 1
- 922 1
- 952 1
- 966 1
- 967 1
- 974 1
- 984 1
- 988 1
- 989 1
- 998 1
- 1028 1
- 1065 1
- 1074 1
- 1088 1
- 1093 1
- 1118 1
- 1124 1
- 1125 1
- 1127 1
- 1136 1
- 1154 1
- 1188 1
- 1207 1
- 1208 1
- 1215 1
- 1223 1
- 1304 1
- 1375 1
- 1387 1
- 1407 1
- 1429 1
- 1438 1
- 1442 1
- 1447 1
- 1449 1
- 1450 1
- 1486 1
- 1520 1
- 1531 1
- 1546 1
- 1551 1
- 1552 1
- 1561 1
- 1579 1
- 1594 1
- 1667 1
- 1678 1
- 1719 1
- 1746 1
- 1776 1
- 1798 1
- 1821 1
- 1839 1
- 1856 1
- 1917 1
- 1966 1
- 2041 1
- 2080 1
- 2141 1
- 2142 1
- 2184 1
- 2243 1
- 2308 1
- 2352 1
- 2392 1
- 2457 1
- 2492 1
- 2522 1
- 2557 1
- 2612 1
- 2637 1
- 2651 1
- 2783 1
- 2816 1
- 2874 1
- 2940 1
- 2952 1
- 2959 1
- 3022 1
- 3116 1
- 3137 1
- 3153 1
- 3176 1
- 3180 1
- 3198 1
- 3225 1
- 3282 1
- 3917 1
- 3972 1
- 3996 1
- 4004 1
- 4032 1
- 4049 1
- 4094 1
- 4107 1
- 4134 1
- 4170 1
- 4222 1
- 4288 1
- 4325 1
- 4332 1
- 4335 1
- 4343 1
- 4356 1
- 4404 1
- 4417 1
- 4422 1
- 4423 1
- 4425 1
- 4428 1
- 4433 1
- 4445 1
- 4467 1
- 4489 1
- 4492 1
- 4493 1
- 4521 1
- 4523 1
- 4544 1
- 4550 1
- 4555 1
- 4556 1
- 4561 1
- 4569 1
- 4575 1
- 4582 1
- 4609 1
- 4640 1
- 4652 1
- 4655 1
- 4659 1
- 4668 1
- 4677 1
- 4683 1
- 4697 1
- 4715 1
- 4721 1
- 4722 1
- 4725 1
- 4728 1
- 4744 1
- 4756 1
- 4760 1
- 4762 1
- 4768 1
- 4772 1
- 4773 1
- 4775 1
- 4778 1
- 4797 1
- 4811 1
- 4826 1
- 4844 1
- 4845 1
- 4850 1
- 4873 1
- 4886 1
- 4898 1
- 4911 1
- 4940 1
- 4975 1
- 5037 1
- 5056 1
- 5087 1
- 5167 1
- 5171 1
- 5183 1
- 5193 1
- 5230 1
- 5231 1
- 5233 1
- 5235 1
- 5248 1
- 5253 1
- 5265 1
- 5285 1
- 5296 1
- 5297 1
- 5302 1
- 5304 1
- 5318 1
- 5322 1
- 5328 1
- 5337 1
- 5339 1
- 5342 1
- 5350 1
- 5364 1
- 5369 1
- 5381 1
- 5392 1
- 5393 1
- 5398 1
- 5407 1
- 5411 1
- 5417 1
- 5422 1
- 5430 1
- 5439 1
- 5441 1
- 5465 1
- 5470 1
- 5474 1
- 5488 1
- 5501 1
- 5506 1
- 5507 1
- 5520 1
- 5528 1
- 5544 1
- 5551 1
- 5562 1
- 5563 1
- 5597 1
- 5606 1
- 5627 1
- 5663 1
- 5720 1
- 5754 1
- 5771 1
- 5810 1
- 5813 1
- 5832 1
- 5836 1
- 5839 1
- 5897 1
- 5912 1
- 5926 1
- 5958 1
- 5962 1
- 5967 1
- 5973 1
- 6006 1
- 6026 1
- 6039 1
- 6049 1
- 6056 1
- 6060 1
- 6085 1
- 6180 1
- 6184 1
- 6198 1
- 6222 1
- 6265 1
- 6281 1
- 6285 1
- 6288 1
- 6291 1
- 6311 1
- 6317 1
- 6334 1
- 6367 1
- 6379 1
- 6441 1
- 6451 1
- 6479 1
- 6572 1
- 6576 1
- 6588 1
- 6619 1
- 6701 1
- 6703 1
- 6715 1
- 6723 1
- 6770 1
- 6775 1
- 6805 1
- 6807 1
- 6811 1
- 6828 1
- 6858 1
- 6863 1
- 6905 1
- 7423 1
state 1
- California 790
fips 1
- 6071 790
county 1
- San Bernardino · 790 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
2340 | 2340 | 2020-03-15 | San Bernardino | California | 6071 | 1 | 0 |
2775 | 2775 | 2020-03-16 | San Bernardino | California | 6071 | 2 | 0 |
3257 | 3257 | 2020-03-17 | San Bernardino | California | 6071 | 3 | 0 |
3811 | 3811 | 2020-03-18 | San Bernardino | California | 6071 | 5 | 0 |
4471 | 4471 | 2020-03-19 | San Bernardino | California | 6071 | 5 | 0 |
5246 | 5246 | 2020-03-20 | San Bernardino | California | 6071 | 9 | 0 |
6167 | 6167 | 2020-03-21 | San Bernardino | California | 6071 | 9 | 0 |
7201 | 7201 | 2020-03-22 | San Bernardino | California | 6071 | 17 | 0 |
8344 | 8344 | 2020-03-23 | San Bernardino | California | 6071 | 17 | 0 |
9587 | 9587 | 2020-03-24 | San Bernardino | California | 6071 | 38 | 1 |
10959 | 10959 | 2020-03-25 | San Bernardino | California | 6071 | 54 | 2 |
12504 | 12504 | 2020-03-26 | San Bernardino | California | 6071 | 55 | 3 |
14170 | 14170 | 2020-03-27 | San Bernardino | California | 6071 | 64 | 3 |
15952 | 15952 | 2020-03-28 | San Bernardino | California | 6071 | 64 | 3 |
17841 | 17841 | 2020-03-29 | San Bernardino | California | 6071 | 111 | 3 |
19818 | 19818 | 2020-03-30 | San Bernardino | California | 6071 | 111 | 3 |
21893 | 21893 | 2020-03-31 | San Bernardino | California | 6071 | 183 | 6 |
24051 | 24051 | 2020-04-01 | San Bernardino | California | 6071 | 254 | 6 |
26280 | 26280 | 2020-04-02 | San Bernardino | California | 6071 | 304 | 8 |
28579 | 28579 | 2020-04-03 | San Bernardino | California | 6071 | 353 | 13 |
30937 | 30937 | 2020-04-04 | San Bernardino | California | 6071 | 353 | 13 |
33343 | 33343 | 2020-04-05 | San Bernardino | California | 6071 | 372 | 13 |
35788 | 35788 | 2020-04-06 | San Bernardino | California | 6071 | 530 | 16 |
38277 | 38277 | 2020-04-07 | San Bernardino | California | 6071 | 547 | 17 |
40821 | 40821 | 2020-04-08 | San Bernardino | California | 6071 | 641 | 20 |
43393 | 43393 | 2020-04-09 | San Bernardino | California | 6071 | 729 | 24 |
45993 | 45993 | 2020-04-10 | San Bernardino | California | 6071 | 810 | 25 |
48623 | 48623 | 2020-04-11 | San Bernardino | California | 6071 | 810 | 25 |
51285 | 51285 | 2020-04-12 | San Bernardino | California | 6071 | 887 | 31 |
53964 | 53964 | 2020-04-13 | San Bernardino | California | 6071 | 977 | 31 |
56656 | 56656 | 2020-04-14 | San Bernardino | California | 6071 | 977 | 31 |
59364 | 59364 | 2020-04-15 | San Bernardino | California | 6071 | 996 | 39 |
62083 | 62083 | 2020-04-16 | San Bernardino | California | 6071 | 1032 | 47 |
64816 | 64816 | 2020-04-17 | San Bernardino | California | 6071 | 1096 | 55 |
67564 | 67564 | 2020-04-18 | San Bernardino | California | 6071 | 1219 | 57 |
70326 | 70326 | 2020-04-19 | San Bernardino | California | 6071 | 1286 | 57 |
73095 | 73095 | 2020-04-20 | San Bernardino | California | 6071 | 1406 | 60 |
75871 | 75871 | 2020-04-21 | San Bernardino | California | 6071 | 1489 | 67 |
78655 | 78655 | 2020-04-22 | San Bernardino | California | 6071 | 1489 | 67 |
81449 | 81449 | 2020-04-23 | San Bernardino | California | 6071 | 1564 | 72 |
84249 | 84249 | 2020-04-24 | San Bernardino | California | 6071 | 1666 | 80 |
87057 | 87057 | 2020-04-25 | San Bernardino | California | 6071 | 1732 | 82 |
89874 | 89874 | 2020-04-26 | San Bernardino | California | 6071 | 1751 | 82 |
92692 | 92692 | 2020-04-27 | San Bernardino | California | 6071 | 1772 | 82 |
95524 | 95524 | 2020-04-28 | San Bernardino | California | 6071 | 1827 | 85 |
98369 | 98369 | 2020-04-29 | San Bernardino | California | 6071 | 1928 | 89 |
101219 | 101219 | 2020-04-30 | San Bernardino | California | 6071 | 2058 | 93 |
104074 | 104074 | 2020-05-01 | San Bernardino | California | 6071 | 2113 | 96 |
106939 | 106939 | 2020-05-02 | San Bernardino | California | 6071 | 2182 | 98 |
109808 | 109808 | 2020-05-03 | San Bernardino | California | 6071 | 2182 | 99 |
112683 | 112683 | 2020-05-04 | San Bernardino | California | 6071 | 2182 | 99 |
115566 | 115566 | 2020-05-05 | San Bernardino | California | 6071 | 2329 | 101 |
118525 | 118525 | 2020-05-06 | San Bernardino | California | 6071 | 2432 | 104 |
121492 | 121492 | 2020-05-07 | San Bernardino | California | 6071 | 2562 | 108 |
124472 | 124472 | 2020-05-08 | San Bernardino | California | 6071 | 2629 | 111 |
127457 | 127457 | 2020-05-09 | San Bernardino | California | 6071 | 2902 | 119 |
130447 | 130447 | 2020-05-10 | San Bernardino | California | 6071 | 2964 | 121 |
133437 | 133437 | 2020-05-11 | San Bernardino | California | 6071 | 3015 | 121 |
136427 | 136427 | 2020-05-12 | San Bernardino | California | 6071 | 3078 | 121 |
139418 | 139418 | 2020-05-13 | San Bernardino | California | 6071 | 3153 | 138 |
142414 | 142414 | 2020-05-14 | San Bernardino | California | 6071 | 3198 | 139 |
145413 | 145413 | 2020-05-15 | San Bernardino | California | 6071 | 3311 | 150 |
148417 | 148417 | 2020-05-16 | San Bernardino | California | 6071 | 3463 | 155 |
151426 | 151426 | 2020-05-17 | San Bernardino | California | 6071 | 3511 | 155 |
154438 | 154438 | 2020-05-18 | San Bernardino | California | 6071 | 3593 | 155 |
157454 | 157454 | 2020-05-19 | San Bernardino | California | 6071 | 3707 | 157 |
160480 | 160480 | 2020-05-20 | San Bernardino | California | 6071 | 3795 | 158 |
163508 | 163508 | 2020-05-21 | San Bernardino | California | 6071 | 3984 | 164 |
166540 | 166540 | 2020-05-22 | San Bernardino | California | 6071 | 4146 | 173 |
169577 | 169577 | 2020-05-23 | San Bernardino | California | 6071 | 4315 | 176 |
172618 | 172618 | 2020-05-24 | San Bernardino | California | 6071 | 4365 | 176 |
175662 | 175662 | 2020-05-25 | San Bernardino | California | 6071 | 4365 | 176 |
178706 | 178706 | 2020-05-26 | San Bernardino | California | 6071 | 4567 | 176 |
181750 | 181750 | 2020-05-27 | San Bernardino | California | 6071 | 4777 | 183 |
184804 | 184804 | 2020-05-28 | San Bernardino | California | 6071 | 4914 | 190 |
187860 | 187860 | 2020-05-29 | San Bernardino | California | 6071 | 5034 | 199 |
190925 | 190925 | 2020-05-30 | San Bernardino | California | 6071 | 5200 | 204 |
193992 | 193992 | 2020-05-31 | San Bernardino | California | 6071 | 5246 | 204 |
197062 | 197062 | 2020-06-01 | San Bernardino | California | 6071 | 5355 | 204 |
200135 | 200135 | 2020-06-02 | San Bernardino | California | 6071 | 5501 | 208 |
203211 | 203211 | 2020-06-03 | San Bernardino | California | 6071 | 5650 | 209 |
206291 | 206291 | 2020-06-04 | San Bernardino | California | 6071 | 5793 | 210 |
209372 | 209372 | 2020-06-05 | San Bernardino | California | 6071 | 5930 | 217 |
212457 | 212457 | 2020-06-06 | San Bernardino | California | 6071 | 6040 | 224 |
215544 | 215544 | 2020-06-07 | San Bernardino | California | 6071 | 6040 | 224 |
218635 | 218635 | 2020-06-08 | San Bernardino | California | 6071 | 6247 | 224 |
221730 | 221730 | 2020-06-09 | San Bernardino | California | 6071 | 6417 | 224 |
224825 | 224825 | 2020-06-10 | San Bernardino | California | 6071 | 6593 | 225 |
227927 | 227927 | 2020-06-11 | San Bernardino | California | 6071 | 6742 | 227 |
231030 | 231030 | 2020-06-12 | San Bernardino | California | 6071 | 6976 | 229 |
234136 | 234136 | 2020-06-13 | San Bernardino | California | 6071 | 7161 | 229 |
237243 | 237243 | 2020-06-14 | San Bernardino | California | 6071 | 7359 | 229 |
240351 | 240351 | 2020-06-15 | San Bernardino | California | 6071 | 7515 | 229 |
243462 | 243462 | 2020-06-16 | San Bernardino | California | 6071 | 7796 | 229 |
246575 | 246575 | 2020-06-17 | San Bernardino | California | 6071 | 8014 | 229 |
249687 | 249687 | 2020-06-18 | San Bernardino | California | 6071 | 8454 | 230 |
252802 | 252802 | 2020-06-19 | San Bernardino | California | 6071 | 8714 | 230 |
255921 | 255921 | 2020-06-20 | San Bernardino | California | 6071 | 8959 | 233 |
259048 | 259048 | 2020-06-21 | San Bernardino | California | 6071 | 9156 | 233 |
262175 | 262175 | 2020-06-22 | San Bernardino | California | 6071 | 9361 | 234 |
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);