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 rowid
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 |
---|---|---|---|---|---|---|---|
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);