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 date descending
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 |
---|---|---|---|---|---|---|---|
2499797 | 2499797 | 2022-05-13 | San Bernardino | California | 6071 | 597377 | 7423 |
2496539 | 2496539 | 2022-05-12 | San Bernardino | California | 6071 | 596557 | 7354 |
2493281 | 2493281 | 2022-05-11 | San Bernardino | California | 6071 | 596557 | 7354 |
2490023 | 2490023 | 2022-05-10 | San Bernardino | California | 6071 | 596557 | 7354 |
2486766 | 2486766 | 2022-05-09 | San Bernardino | California | 6071 | 595566 | 7306 |
2483508 | 2483508 | 2022-05-08 | San Bernardino | California | 6071 | 595566 | 7306 |
2480250 | 2480250 | 2022-05-07 | San Bernardino | California | 6071 | 595566 | 7306 |
2476992 | 2476992 | 2022-05-06 | San Bernardino | California | 6071 | 595566 | 7306 |
2473734 | 2473734 | 2022-05-05 | San Bernardino | California | 6071 | 594674 | 7240 |
2470477 | 2470477 | 2022-05-04 | San Bernardino | California | 6071 | 594674 | 7240 |
2467221 | 2467221 | 2022-05-03 | San Bernardino | California | 6071 | 594674 | 7240 |
2463966 | 2463966 | 2022-05-02 | San Bernardino | California | 6071 | 593862 | 7191 |
2460710 | 2460710 | 2022-05-01 | San Bernardino | California | 6071 | 593862 | 7191 |
2457454 | 2457454 | 2022-04-30 | San Bernardino | California | 6071 | 593862 | 7191 |
2454198 | 2454198 | 2022-04-29 | San Bernardino | California | 6071 | 593862 | 7191 |
2450942 | 2450942 | 2022-04-28 | San Bernardino | California | 6071 | 592997 | 7105 |
2447686 | 2447686 | 2022-04-27 | San Bernardino | California | 6071 | 592997 | 7105 |
2444430 | 2444430 | 2022-04-26 | San Bernardino | California | 6071 | 592997 | 7105 |
2441174 | 2441174 | 2022-04-25 | San Bernardino | California | 6071 | 591785 | 7047 |
2437918 | 2437918 | 2022-04-24 | San Bernardino | California | 6071 | 591785 | 7047 |
2434662 | 2434662 | 2022-04-23 | San Bernardino | California | 6071 | 591785 | 7047 |
2431406 | 2431406 | 2022-04-22 | San Bernardino | California | 6071 | 591785 | 7047 |
2428150 | 2428150 | 2022-04-21 | San Bernardino | California | 6071 | 590227 | 6977 |
2424894 | 2424894 | 2022-04-20 | San Bernardino | California | 6071 | 590227 | 6977 |
2421638 | 2421638 | 2022-04-19 | San Bernardino | California | 6071 | 590227 | 6977 |
2418382 | 2418382 | 2022-04-18 | San Bernardino | California | 6071 | 589219 | 6948 |
2415126 | 2415126 | 2022-04-17 | San Bernardino | California | 6071 | 589219 | 6948 |
2411870 | 2411870 | 2022-04-16 | San Bernardino | California | 6071 | 589219 | 6948 |
2408614 | 2408614 | 2022-04-15 | San Bernardino | California | 6071 | 589219 | 6948 |
2405358 | 2405358 | 2022-04-14 | San Bernardino | California | 6071 | 588531 | 6905 |
2402103 | 2402103 | 2022-04-13 | San Bernardino | California | 6071 | 587246 | 6892 |
2398848 | 2398848 | 2022-04-12 | San Bernardino | California | 6071 | 587246 | 6892 |
2395593 | 2395593 | 2022-04-11 | San Bernardino | California | 6071 | 587246 | 6892 |
2392337 | 2392337 | 2022-04-10 | San Bernardino | California | 6071 | 587246 | 6892 |
2389081 | 2389081 | 2022-04-09 | San Bernardino | California | 6071 | 587246 | 6892 |
2385826 | 2385826 | 2022-04-08 | San Bernardino | California | 6071 | 587246 | 6892 |
2382571 | 2382571 | 2022-04-07 | San Bernardino | California | 6071 | 586323 | 6883 |
2379316 | 2379316 | 2022-04-06 | San Bernardino | California | 6071 | 586323 | 6883 |
2376062 | 2376062 | 2022-04-05 | San Bernardino | California | 6071 | 586323 | 6883 |
2372810 | 2372810 | 2022-04-04 | San Bernardino | California | 6071 | 586037 | 6865 |
2369557 | 2369557 | 2022-04-03 | San Bernardino | California | 6071 | 586037 | 6865 |
2366304 | 2366304 | 2022-04-02 | San Bernardino | California | 6071 | 586037 | 6865 |
2363051 | 2363051 | 2022-04-01 | San Bernardino | California | 6071 | 586037 | 6865 |
2359797 | 2359797 | 2022-03-31 | San Bernardino | California | 6071 | 585828 | 6863 |
2356543 | 2356543 | 2022-03-30 | San Bernardino | California | 6071 | 585497 | 6862 |
2353290 | 2353290 | 2022-03-29 | San Bernardino | California | 6071 | 585307 | 6858 |
2350038 | 2350038 | 2022-03-28 | San Bernardino | California | 6071 | 585324 | 6862 |
2346785 | 2346785 | 2022-03-27 | San Bernardino | California | 6071 | 585213 | 6840 |
2343532 | 2343532 | 2022-03-26 | San Bernardino | California | 6071 | 585213 | 6840 |
2340279 | 2340279 | 2022-03-25 | San Bernardino | California | 6071 | 585213 | 6840 |
2337026 | 2337026 | 2022-03-24 | San Bernardino | California | 6071 | 585021 | 6828 |
2333772 | 2333772 | 2022-03-23 | San Bernardino | California | 6071 | 584685 | 6811 |
2330518 | 2330518 | 2022-03-22 | San Bernardino | California | 6071 | 584524 | 6807 |
2327266 | 2327266 | 2022-03-21 | San Bernardino | California | 6071 | 584534 | 6805 |
2324013 | 2324013 | 2022-03-20 | San Bernardino | California | 6071 | 584249 | 6778 |
2320759 | 2320759 | 2022-03-19 | San Bernardino | California | 6071 | 584249 | 6778 |
2317505 | 2317505 | 2022-03-18 | San Bernardino | California | 6071 | 584249 | 6778 |
2314252 | 2314252 | 2022-03-17 | San Bernardino | California | 6071 | 584060 | 6775 |
2310999 | 2310999 | 2022-03-16 | San Bernardino | California | 6071 | 583770 | 6770 |
2307746 | 2307746 | 2022-03-15 | San Bernardino | California | 6071 | 583670 | 6767 |
2304495 | 2304495 | 2022-03-14 | San Bernardino | California | 6071 | 583615 | 6767 |
2301243 | 2301243 | 2022-03-13 | San Bernardino | California | 6071 | 583178 | 6734 |
2297991 | 2297991 | 2022-03-12 | San Bernardino | California | 6071 | 583178 | 6734 |
2294739 | 2294739 | 2022-03-11 | San Bernardino | California | 6071 | 583178 | 6734 |
2291487 | 2291487 | 2022-03-10 | San Bernardino | California | 6071 | 582960 | 6723 |
2288235 | 2288235 | 2022-03-09 | San Bernardino | California | 6071 | 582492 | 6715 |
2284984 | 2284984 | 2022-03-08 | San Bernardino | California | 6071 | 582245 | 6703 |
2281732 | 2281732 | 2022-03-07 | San Bernardino | California | 6071 | 582119 | 6701 |
2278479 | 2278479 | 2022-03-06 | San Bernardino | California | 6071 | 581401 | 6641 |
2275226 | 2275226 | 2022-03-05 | San Bernardino | California | 6071 | 581401 | 6641 |
2271973 | 2271973 | 2022-03-04 | San Bernardino | California | 6071 | 581401 | 6641 |
2268721 | 2268721 | 2022-03-03 | San Bernardino | California | 6071 | 581062 | 6619 |
2265468 | 2265468 | 2022-03-02 | San Bernardino | California | 6071 | 580464 | 6588 |
2262217 | 2262217 | 2022-03-01 | San Bernardino | California | 6071 | 580261 | 6576 |
2258966 | 2258966 | 2022-02-28 | San Bernardino | California | 6071 | 580178 | 6572 |
2255715 | 2255715 | 2022-02-27 | San Bernardino | California | 6071 | 579389 | 6505 |
2252464 | 2252464 | 2022-02-26 | San Bernardino | California | 6071 | 579389 | 6505 |
2249213 | 2249213 | 2022-02-25 | San Bernardino | California | 6071 | 579389 | 6505 |
2245962 | 2245962 | 2022-02-24 | San Bernardino | California | 6071 | 578959 | 6479 |
2242711 | 2242711 | 2022-02-23 | San Bernardino | California | 6071 | 578334 | 6451 |
2239460 | 2239460 | 2022-02-22 | San Bernardino | California | 6071 | 578093 | 6441 |
2236209 | 2236209 | 2022-02-21 | San Bernardino | California | 6071 | 576582 | 6400 |
2232958 | 2232958 | 2022-02-20 | San Bernardino | California | 6071 | 576582 | 6400 |
2229707 | 2229707 | 2022-02-19 | San Bernardino | California | 6071 | 576582 | 6400 |
2226456 | 2226456 | 2022-02-18 | San Bernardino | California | 6071 | 576582 | 6400 |
2223205 | 2223205 | 2022-02-17 | San Bernardino | California | 6071 | 575784 | 6379 |
2219954 | 2219954 | 2022-02-16 | San Bernardino | California | 6071 | 575690 | 6372 |
2216703 | 2216703 | 2022-02-15 | San Bernardino | California | 6071 | 575225 | 6372 |
2213452 | 2213452 | 2022-02-14 | San Bernardino | California | 6071 | 574519 | 6367 |
2210200 | 2210200 | 2022-02-13 | San Bernardino | California | 6071 | 572709 | 6360 |
2206947 | 2206947 | 2022-02-12 | San Bernardino | California | 6071 | 572709 | 6360 |
2203694 | 2203694 | 2022-02-11 | San Bernardino | California | 6071 | 572709 | 6360 |
2200441 | 2200441 | 2022-02-10 | San Bernardino | California | 6071 | 571655 | 6335 |
2197187 | 2197187 | 2022-02-09 | San Bernardino | California | 6071 | 568491 | 6335 |
2193932 | 2193932 | 2022-02-08 | San Bernardino | California | 6071 | 566679 | 6335 |
2190679 | 2190679 | 2022-02-07 | San Bernardino | California | 6071 | 564936 | 6334 |
2187426 | 2187426 | 2022-02-06 | San Bernardino | California | 6071 | 563145 | 6322 |
2184173 | 2184173 | 2022-02-05 | San Bernardino | California | 6071 | 563145 | 6322 |
2180921 | 2180921 | 2022-02-04 | San Bernardino | California | 6071 | 563145 | 6322 |
2177670 | 2177670 | 2022-02-03 | San Bernardino | California | 6071 | 561318 | 6317 |
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);