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: deaths, date (date)
cases 661 ✖
- 587246 6
- 371882 5
- 298289 4
- 299948 4
- 358677 4
- 388559 4
- 399021 4
- 576582 4
- 586037 4
- 589219 4
- 591785 4
- 593862 4
- 595566 4
- 2182 3
- 304235 3
- 305351 3
- 307469 3
- 310384 3
- 349047 3
- 351963 3
- 354330 3
- 356315 3
- 361269 3
- 364509 3
- 370171 3
- 376280 3
- 380385 3
- 384019 3
- 425119 3
- 469782 3
- 513848 3
- 545764 3
- 563145 3
- 572709 3
- 579389 3
- 581401 3
- 583178 3
- 584249 3
- 585213 3
- 586323 3
- 590227 3
- 592997 3
- 594674 3
- 596557 3
- 5 2
- 9 2
- 17 2
- 64 2
- 111 2
- 353 2
- 810 2
- 977 2
- 1489 2
- 4365 2
- 6040 2
- 11290 2
- 17414 2
- 47642 2
- 48615 2
- 49691 2
- 277949 2
- 282494 2
- 285334 2
- 297165 2
- 298545 2
- 299289 2
- 314701 2
- 367034 2
- 367946 2
- 1 1
- 2 1
- 3 1
- 38 1
- 54 1
- 55 1
- 183 1
- 254 1
- 304 1
- 372 1
- 530 1
- 547 1
- 641 1
- 729 1
- 887 1
- 996 1
- 1032 1
- 1096 1
- 1219 1
- 1286 1
- 1406 1
- 1564 1
- 1666 1
- 1732 1
- 1751 1
- 1772 1
- 1827 1
- 1928 1
- 2058 1
- 2113 1
- 2329 1
- 2432 1
- 2562 1
- 2629 1
- 2902 1
- 2964 1
- 3015 1
- 3078 1
- 3153 1
- 3198 1
- 3311 1
- 3463 1
- 3511 1
- 3593 1
- 3707 1
- 3795 1
- 3984 1
- 4146 1
- 4315 1
- 4567 1
- 4777 1
- 4914 1
- 5034 1
- 5200 1
- 5246 1
- 5355 1
- 5501 1
- 5650 1
- 5793 1
- 5930 1
- 6247 1
- 6417 1
- 6593 1
- 6742 1
- 6976 1
- 7161 1
- 7359 1
- 7515 1
- 7796 1
- 8014 1
- 8454 1
- 8714 1
- 8959 1
- 9156 1
- 9361 1
- 10010 1
- 10407 1
- 10769 1
- 11501 1
- 11797 1
- 12550 1
- 12746 1
- 13152 1
- 13676 1
- 14040 1
- 14922 1
- 15345 1
- 15932 1
- 16586 1
- 18912 1
- 19043 1
- 19502 1
- 20456 1
- 21468 1
- 21508 1
- 23238 1
- 23566 1
- 23772 1
- 24099 1
- 25067 1
- 25775 1
- 26820 1
- 28121 1
- 28990 1
- 29265 1
- 29545 1
- 29962 1
- 30493 1
- 31688 1
- 32230 1
- 32696 1
- 32980 1
- 33643 1
- 34017 1
- 34237 1
- 34635 1
- 34939 1
- 35452 1
- 35712 1
- 36092 1
- 37367 1
- 38467 1
- 38811 1
- 39395 1
- 40442 1
- 41231 1
- 41724 1
- 42150 1
- 42947 1
- 43469 1
- 43943 1
- 44603 1
- 45035 1
- 45246 1
- 45666 1
- 46051 1
- 46407 1
- 46892 1
- 47145 1
- 47373 1
- 48245 1
- 49325 1
- 49558 1
- 49909 1
- 50210 1
- 50385 1
- 50543 1
- 50699 1
- 50709 1
- 50978 1
- 51252 1
- 51467 1
- 51750 1
- 52287 1
- 52471 1
- 52649 1
- 52873 1
- 53121 1
- 53359 1
- 53669 1
- 54386 1
- 54478 1
- 54482 1
- 54849 1
- 55203 1
- 55394 1
- 55671 1
- 56011 1
- 56275 1
- 56400 1
- 56522 1
- 56823 1
- 57203 1
- 57517 1
- 57834 1
- 57974 1
- 58125 1
- 58579 1
- 58936 1
- 59169 1
- 59463 1
- 59602 1
- 59696 1
- 59779 1
- 60621 1
- 60945 1
- 61550 1
- 61726 1
- 62353 1
- 62619 1
- 62774 1
- 63367 1
- 63850 1
- 64131 1
- 64367 1
- 64952 1
- 65207 1
- 65331 1
- 65997 1
- 66656 1
- 67196 1
- 67777 1
- 68242 1
- 68721 1
- 68865 1
- 70347 1
- 71072 1
- 71847 1
- 73001 1
- 73915 1
- 74166 1
- 74929 1
- 76685 1
- 78298 1
- 80318 1
- 81328 1
- 84201 1
- 84531 1
- 85176 1
- 87542 1
- 88453 1
- 88469 1
- 90222 1
- 92164 1
- 93019 1
- 93671 1
- 94106 1
- 96657 1
- 99104 1
- 100787 1
- 103911 1
- 106770 1
- 107928 1
- 108946 1
- 111518 1
- 115641 1
- 120186 1
- 124264 1
- 126738 1
- 127791 1
- 129522 1
- 137548 1
- 144455 1
- 151113 1
- 157655 1
- 159883 1
- 163945 1
- 168307 1
- 170885 1
- 174091 1
- 176866 1
- 181812 1
- 185111 1
- 186776 1
- 191087 1
- 193214 1
- 194377 1
- 199115 1
- 203651 1
- 206939 1
- 208271 1
- 213357 1
- 214813 1
- 216394 1
- 219691 1
- 224350 1
- 228857 1
- 232171 1
- 235543 1
- 239786 1
- 241523 1
- 245033 1
- 248285 1
- 251213 1
- 254094 1
- 256109 1
- 256914 1
- 258742 1
- 261199 1
- 262858 1
- 264457 1
- 266028 1
- 268542 1
- 269314 1
- 271189 1
- 272198 1
- 273520 1
- 274429 1
- 275076 1
- 275372 1
- 275960 1
- 276606 1
- 277430 1
- 278802 1
- 279412 1
- 279673 1
- 280068 1
- 280949 1
- 281604 1
- 282169 1
- 282736 1
- 283356 1
- 283873 1
- 284280 1
- 284639 1
- 284866 1
- 285081 1
- 286077 1
- 286291 1
- 286607 1
- 286755 1
- 286814 1
- 287055 1
- 287246 1
- 287513 1
- 287782 1
- 287867 1
- 288044 1
- 288045 1
- 288135 1
- 288297 1
- 288364 1
- 288599 1
- 288787 1
- 288868 1
- 288932 1
- 289057 1
- 289242 1
- 289405 1
- 289610 1
- 289773 1
- 289846 1
- 289892 1
- 290030 1
- 290155 1
- 290315 1
- 290505 1
- 290630 1
- 290715 1
- 290803 1
- 290954 1
- 291022 1
- 291199 1
- 291360 1
- 291648 1
- 291727 1
- 291728 1
- 291989 1
- 292160 1
- 292358 1
- 292558 1
- 293638 1
- 293835 1
- 293925 1
- 294101 1
- 294262 1
- 294464 1
- 294577 1
- 294779 1
- 294883 1
- 294973 1
- 295131 1
- 295315 1
- 295390 1
- 295452 1
- 295510 1
- 295565 1
- 295665 1
- 295752 1
- 295806 1
- 295899 1
- 296009 1
- 296089 1
- 296146 1
- 296188 1
- 296257 1
- 296324 1
- 296425 1
- 296514 1
- 296596 1
- 296655 1
- 296700 1
- 296782 1
- 296839 1
- 296903 1
- 297261 1
- 297300 1
- 297349 1
- 297417 1
- 297479 1
- 297539 1
- 297566 1
- 297615 1
- 297688 1
- 297848 1
- 298082 1
- 298599 1
- 298643 1
- 298656 1
- 298676 1
- 298697 1
- 298728 1
- 298808 1
- 298843 1
- 298898 1
- 298939 1
- 298976 1
- 299014 1
- 299049 1
- 299096 1
- 299151 1
- 299186 1
- 299243 1
- 299320 1
- 299372 1
- 299425 1
- 299480 1
- 299502 1
- 299604 1
- 299672 1
- 299730 1
- 299763 1
- 299883 1
- 300045 1
- 300218 1
- 304090 1
- 304645 1
- 304750 1
- 304899 1
- 305123 1
- 306042 1
- 306232 1
- 306525 1
- 307089 1
- 308552 1
- 308808 1
- 309163 1
- 309779 1
- 312200 1
- 312658 1
- 313044 1
- 313909 1
- 316408 1
- 317123 1
- 317783 1
- 318417 1
- 319243 1
- 320165 1
- 321123 1
- 321887 1
- 322865 1
- 323362 1
- 324147 1
- 325441 1
- 326362 1
- 327336 1
- 328257 1
- 328803 1
- 329541 1
- 330264 1
- 331366 1
- 332238 1
- 333031 1
- 333810 1
- 334404 1
- 335008 1
- 335584 1
- 336552 1
- 337242 1
- 337901 1
- 338727 1
- 339364 1
- 339995 1
- 340264 1
- 340633 1
- 341394 1
- 342248 1
- 342866 1
- 343403 1
- 343967 1
- 344322 1
- 345071 1
- 345644 1
- 346325 1
- 346895 1
- 347203 1
- 347574 1
- 347902 1
- 348572 1
- 350405 1
- 350586 1
- 350976 1
- 351423 1
- 353053 1
- 353169 1
- 353462 1
- 353900 1
- 355301 1
- 355472 1
- 355666 1
- 355848 1
- 357421 1
- 357639 1
- 357711 1
- 358213 1
- 360071 1
- 360342 1
- 360817 1
- 362604 1
- 362813 1
- 363025 1
- 363592 1
- 365855 1
- 366108 1
- 366339 1
- 368635 1
- 368927 1
- 369149 1
- 369796 1
- 371470 1
- 371700 1
- 374256 1
- 374543 1
- 374855 1
- 375494 1
- 378408 1
- 378732 1
- 379107 1
- 379756 1
- 382217 1
- 382514 1
- 382844 1
- 383483 1
- 385841 1
- 386242 1
- 386580 1
- 387551 1
- 393033 1
- 393823 1
- 395615 1
- 414681 1
- 417152 1
- 418718 1
- 443652 1
- 450602 1
- 456355 1
- 463256 1
- 489812 1
- 495630 1
- 499140 1
- 506485 1
- 531296 1
- 534243 1
- 537789 1
- 542214 1
- 554565 1
- 555791 1
- 557106 1
- 561318 1
- 564936 1
- 566679 1
- 568491 1
- 571655 1
- 574519 1
- 575225 1
- 575690 1
- 575784 1
- 578093 1
- 578334 1
- 578959 1
- 580178 1
- 580261 1
- 580464 1
- 581062 1
- 582119 1
- 582245 1
- 582492 1
- 582960 1
- 583615 1
- 583670 1
- 583770 1
- 584060 1
- 584524 1
- 584534 1
- 584685 1
- 585021 1
- 585307 1
- 585324 1
- 585497 1
- 585828 1
- 588531 1
- 597377 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);