\begin{tabular}{rlllllrrrlrrll} \hline rowid & day & country\_or\_region & province\_or\_state & admin2 & fips & confirmed & deaths & recovered & active & latitude & longitude & last\_update & combined\_key \\ \hline 2752652 & 2022-12-29 & Canada & British Columbia & & & 391897 & 4806 & 0 & & 53.7267 & -127.648 & 2022-12-30 04:21:04 & British Columbia, Canada \\ 1073658 & 2022-12-28 & Canada & British Columbia & & & 391897 & 4806 & 0 & & 53.7267 & -127.648 & 2022-12-29 04:21:01 & British Columbia, Canada \\ 327655 & 2022-12-27 & Canada & British Columbia & & & 391897 & 4806 & 0 & & 53.7267 & -127.648 & 2022-12-28 04:21:04 & British Columbia, Canada \\ 217728 & 2022-12-26 & Canada & British Columbia & & & 391897 & 4806 & 0 & & 53.7267 & -127.648 & 2022-12-27 04:21:07 & British Columbia, Canada \\ 3222185 & 2022-12-25 & Canada & British Columbia & & & 391897 & 4806 & 0 & & 53.7267 & -127.648 & 2022-12-26 04:21:06 & British Columbia, Canada \\ 1018099 & 2022-12-24 & Canada & British Columbia & & & 391897 & 4806 & 0 & & 53.7267 & -127.648 & 2022-12-25 04:21:04 & British Columbia, Canada \\ 690122 & 2022-12-23 & Canada & British Columbia & & & 391897 & 4806 & 0 & & 53.7267 & -127.648 & 2022-12-24 04:21:02 & British Columbia, Canada \\ 2179332 & 2022-12-22 & Canada & British Columbia & & & 391285 & 4760 & 0 & & 53.7267 & -127.648 & 2022-12-23 04:21:04 & British Columbia, Canada \\ 451136 & 2022-12-21 & Canada & British Columbia & & & 391285 & 4760 & 0 & & 53.7267 & -127.648 & 2022-12-22 04:20:56 & British Columbia, Canada \\ 2951135 & 2022-12-20 & Canada & British Columbia & & & 391285 & 4760 & 0 & & 53.7267 & -127.648 & 2022-12-21 04:21:03 & British Columbia, Canada \\ 3173537 & 2022-12-19 & Canada & British Columbia & & & 391285 & 4760 & 0 & & 53.7267 & -127.648 & 2022-12-20 04:21:04 & British Columbia, Canada \\ 1628054 & 2022-12-18 & Canada & British Columbia & & & 391285 & 4760 & 0 & & 53.7267 & -127.648 & 2022-12-19 04:21:03 & British Columbia, Canada \\ 503433 & 2022-12-17 & Canada & British Columbia & & & 391285 & 4760 & 0 & & 53.7267 & -127.648 & 2022-12-18 04:21:03 & British Columbia, Canada \\ 3324005 & 2022-12-16 & Canada & British Columbia & & & 391285 & 4760 & 0 & & 53.7267 & -127.648 & 2022-12-17 04:21:04 & British Columbia, Canada \\ 542517 & 2022-12-15 & Canada & British Columbia & & & 391285 & 4760 & 0 & & 53.7267 & -127.648 & 2022-12-16 04:21:01 & British Columbia, Canada \\ 348045 & 2022-12-14 & Canada & British Columbia & & & 390626 & 4715 & 0 & & 53.7267 & -127.648 & 2022-12-15 04:20:58 & British Columbia, Canada \\ 307633 & 2022-12-13 & Canada & British Columbia & & & 390626 & 4715 & 0 & & 53.7267 & -127.648 & 2022-12-14 04:21:04 & British Columbia, Canada \\ 1148694 & 2022-12-12 & Canada & British Columbia & & & 390626 & 4715 & 0 & & 53.7267 & -127.648 & 2022-12-13 04:21:01 & British Columbia, Canada \\ 868548 & 2022-12-11 & Canada & British Columbia & & & 390626 & 4715 & 0 & & 53.7267 & -127.648 & 2022-12-12 04:21:01 & British Columbia, Canada \\ 257078 & 2022-12-10 & Canada & British Columbia & & & 390626 & 4715 & 0 & & 53.7267 & -127.648 & 2022-12-11 04:20:50 & British Columbia, Canada \\ 3935792 & 2022-12-09 & Canada & British Columbia & & & 390626 & 4715 & 0 & & 53.7267 & -127.648 & 2022-12-10 04:21:02 & British Columbia, Canada \\ 3377124 & 2022-12-08 & Canada & British Columbia & & & 390087 & 4680 & 0 & & 53.7267 & -127.648 & 2022-12-09 04:21:05 & British Columbia, Canada \\ 1984395 & 2022-12-07 & Canada & British Columbia & & & 390087 & 4680 & 0 & & 53.7267 & -127.648 & 2022-12-08 04:21:07 & British Columbia, Canada \\ 3713918 & 2022-12-06 & Canada & British Columbia & & & 390087 & 4680 & 0 & & 53.7267 & -127.648 & 2022-12-07 04:20:58 & British Columbia, Canada \\ 2414623 & 2022-12-05 & Canada & British Columbia & & & 390087 & 4680 & 0 & & 53.7267 & -127.648 & 2022-12-02 18:21:06 & British Columbia, Canada \\ 718231 & 2022-12-04 & Canada & British Columbia & & & 389479 & 4642 & 0 & & 53.7267 & -127.648 & 2022-12-02 18:21:06 & British Columbia, Canada \\ 2816520 & 2022-12-03 & Canada & British Columbia & & & 389479 & 4642 & 0 & & 53.7267 & -127.648 & 2022-12-02 18:21:06 & British Columbia, Canada \\ 833376 & 2022-12-02 & Canada & British Columbia & & & 389479 & 4642 & 0 & & 53.7267 & -127.648 & 2022-12-02 18:21:06 & British Columbia, Canada \\ 2135906 & 2022-12-01 & Canada & British Columbia & & & 389479 & 4642 & 0 & & 53.7267 & -127.648 & 2022-12-02 04:21:07 & British Columbia, Canada \\ 1964322 & 2022-11-30 & Canada & British Columbia & & & 389479 & 4642 & 0 & & 53.7267 & -127.648 & 2022-12-01 04:21:03 & British Columbia, Canada \\ 2556336 & 2022-11-29 & Canada & British Columbia & & & 389479 & 4642 & 0 & & 53.7267 & -127.648 & 2022-11-30 04:21:07 & British Columbia, Canada \\ 1239410 & 2022-11-28 & Canada & British Columbia & & & 389479 & 4642 & 0 & & 53.7267 & -127.648 & 2022-11-29 04:21:05 & British Columbia, Canada \\ 3551398 & 2022-11-27 & Canada & British Columbia & & & 389479 & 4642 & 0 & & 53.7267 & -127.648 & 2022-11-28 04:21:02 & British Columbia, Canada \\ 2099878 & 2022-11-26 & Canada & British Columbia & & & 389479 & 4642 & 0 & & 53.7267 & -127.648 & 2022-11-27 04:21:05 & British Columbia, Canada \\ 487369 & 2022-11-25 & Canada & British Columbia & & & 389479 & 4642 & 0 & & 53.7267 & -127.648 & 2022-11-26 04:21:11 & British Columbia, Canada \\ 3523198 & 2022-11-24 & Canada & British Columbia & & & 389479 & 4642 & 0 & & 53.7267 & -127.648 & 2022-11-25 04:21:06 & British Columbia, Canada \\ 3311981 & 2022-11-23 & Canada & British Columbia & & & 388984 & 4607 & 0 & & 53.7267 & -127.648 & 2022-11-24 04:21:09 & British Columbia, Canada \\ 1620022 & 2022-11-22 & Canada & British Columbia & & & 388984 & 4607 & 0 & & 53.7267 & -127.648 & 2022-11-23 04:21:06 & British Columbia, Canada \\ 3459910 & 2022-11-21 & Canada & British Columbia & & & 388984 & 4607 & 0 & & 53.7267 & -127.648 & 2022-11-22 04:20:47 & British Columbia, Canada \\ 1640095 & 2022-11-20 & Canada & British Columbia & & & 388984 & 4607 & 0 & & 53.7267 & -127.648 & 2022-11-21 04:21:05 & British Columbia, Canada \\ 2063652 & 2022-11-19 & Canada & British Columbia & & & 388984 & 4607 & 0 & & 53.7267 & -127.648 & 2022-11-20 04:21:08 & British Columbia, Canada \\ 1755046 & 2022-11-18 & Canada & British Columbia & & & 388984 & 4607 & 0 & & 53.7267 & -127.648 & 2022-11-19 04:21:14 & British Columbia, Canada \\ 3026039 & 2022-11-17 & Canada & British Columbia & & & 388984 & 4607 & 0 & & 53.7267 & -127.648 & 2022-11-18 04:21:15 & British Columbia, Canada \\ 2485750 & 2022-11-16 & Canada & British Columbia & & & 388497 & 4552 & 0 & & 53.7267 & -127.648 & 2022-11-17 04:21:11 & British Columbia, Canada \\ 291761 & 2022-11-15 & Canada & British Columbia & & & 388497 & 4552 & 0 & & 53.7267 & -127.648 & 2022-11-16 04:21:09 & British Columbia, Canada \\ 3596791 & 2022-11-14 & Canada & British Columbia & & & 388497 & 4552 & 0 & & 53.7267 & -127.648 & 2022-11-15 04:21:16 & British Columbia, Canada \\ 311649 & 2022-11-13 & Canada & British Columbia & & & 388497 & 4552 & 0 & & 53.7267 & -127.648 & 2022-11-14 04:21:09 & British Columbia, Canada \\ 62810 & 2022-11-12 & Canada & British Columbia & & & 388497 & 4552 & 0 & & 53.7267 & -127.648 & 2022-11-13 04:21:14 & British Columbia, Canada \\ 2926972 & 2022-11-11 & Canada & British Columbia & & & 388497 & 4552 & 0 & & 53.7267 & -127.648 & 2022-11-12 04:20:41 & British Columbia, Canada \\ 2505808 & 2022-11-10 & Canada & British Columbia & & & 388497 & 4552 & 0 & & 53.7267 & -127.648 & 2022-11-11 04:21:22 & British Columbia, Canada \\ 2430683 & 2022-11-09 & Canada & British Columbia & & & 387936 & 4525 & 0 & & 53.7267 & -127.648 & 2022-11-10 04:21:16 & British Columbia, Canada \\ 479339 & 2022-11-08 & Canada & British Columbia & & & 387936 & 4525 & 0 & & 53.7267 & -127.648 & 2022-11-09 04:21:22 & British Columbia, Canada \\ 2438489 & 2022-11-07 & Canada & British Columbia & & & 387936 & 4525 & 0 & & 53.7267 & -127.648 & 2022-11-08 04:21:21 & British Columbia, Canada \\ 1049587 & 2022-11-06 & Canada & British Columbia & & & 387936 & 4525 & 0 & & 53.7267 & -127.648 & 2022-11-07 04:21:26 & British Columbia, Canada \\ 617611 & 2022-11-05 & Canada & British Columbia & & & 387936 & 4525 & 0 & & 53.7267 & -127.648 & 2022-11-06 04:21:24 & British Columbia, Canada \\ 1022115 & 2022-11-04 & Canada & British Columbia & & & 387936 & 4525 & 0 & & 53.7267 & -127.648 & 2022-11-05 04:21:52 & British Columbia, Canada \\ 431106 & 2022-11-03 & Canada & British Columbia & & & 387936 & 4525 & 0 & & 53.7267 & -127.648 & 2022-11-04 04:22:11 & British Columbia, Canada \\ 849348 & 2022-11-02 & Canada & British Columbia & & & 387451 & 4485 & 0 & & 53.7267 & -127.648 & 2022-11-03 04:22:05 & British Columbia, Canada \\ 710199 & 2022-11-01 & Canada & British Columbia & & & 387451 & 4485 & 0 & & 53.7267 & -127.648 & 2022-11-02 04:22:09 & British Columbia, Canada \\ 3284648 & 2022-10-31 & Canada & British Columbia & & & 387451 & 4485 & 0 & & 53.7267 & -127.648 & 2022-11-01 04:22:36 & British Columbia, Canada \\ 319681 & 2022-10-30 & Canada & British Columbia & & & 387451 & 4485 & 0 & & 53.7267 & -127.648 & 2022-10-31 04:21:36 & British Columbia, Canada \\ 911957 & 2022-10-29 & Canada & British Columbia & & & 387451 & 4485 & 0 & & 53.7267 & -127.648 & 2022-10-30 04:22:14 & British Columbia, Canada \\ 1366226 & 2022-10-28 & Canada & British Columbia & & & 387451 & 4485 & 0 & & 53.7267 & -127.648 & 2022-10-29 04:21:13 & British Columbia, Canada \\ 3038081 & 2022-10-27 & Canada & British Columbia & & & 387451 & 4485 & 0 & & 53.7267 & -127.648 & 2022-10-28 04:22:31 & British Columbia, Canada \\ 538501 & 2022-10-26 & Canada & British Columbia & & & 386920 & 4423 & 0 & & 53.7267 & -127.648 & 2022-10-27 04:22:01 & British Columbia, Canada \\ 1829902 & 2022-10-25 & Canada & British Columbia & & & 386920 & 4423 & 0 & & 53.7267 & -127.648 & 2022-10-26 04:22:19 & British Columbia, Canada \\ 794163 & 2022-10-24 & Canada & British Columbia & & & 386920 & 4423 & 0 & & 53.7267 & -127.648 & 2022-10-25 04:21:53 & British Columbia, Canada \\ 3276618 & 2022-10-23 & Canada & British Columbia & & & 386920 & 4423 & 0 & & 53.7267 & -127.648 & 2022-10-24 04:22:29 & British Columbia, Canada \\ 2267656 & 2022-10-22 & Canada & British Columbia & & & 386920 & 4423 & 0 & & 53.7267 & -127.648 & 2022-10-23 04:22:46 & British Columbia, Canada \\ 1591956 & 2022-10-21 & Canada & British Columbia & & & 386920 & 4423 & 0 & & 53.7267 & -127.648 & 2022-10-22 04:22:53 & British Columbia, Canada \\ 2271672 & 2022-10-20 & Canada & British Columbia & & & 386920 & 4423 & 0 & & 53.7267 & -127.648 & 2022-10-21 04:22:23 & British Columbia, Canada \\ 198007 & 2022-10-19 & Canada & British Columbia & & & 386293 & 4370 & 0 & & 53.7267 & -127.648 & 2022-10-20 04:22:59 & British Columbia, Canada \\ 2756668 & 2022-10-18 & Canada & British Columbia & & & 386293 & 4370 & 0 & & 53.7267 & -127.648 & 2022-10-19 04:22:26 & British Columbia, Canada \\ 2024502 & 2022-10-17 & Canada & British Columbia & & & 386293 & 4370 & 0 & & 53.7267 & -127.648 & 2022-10-18 04:22:42 & British Columbia, Canada \\ 2159280 & 2022-10-16 & Canada & British Columbia & & & 386293 & 4370 & 0 & & 53.7267 & -127.648 & 2022-10-17 04:20:31 & British Columbia, Canada \\ 515477 & 2022-10-15 & Canada & British Columbia & & & 386293 & 4370 & 0 & & 53.7267 & -127.648 & 2022-10-16 04:22:39 & British Columbia, Canada \\ 2032534 & 2022-10-14 & Canada & British Columbia & & & 386293 & 4370 & 0 & & 53.7267 & -127.648 & 2022-10-15 04:22:00 & British Columbia, Canada \\ 3753222 & 2022-10-13 & Canada & British Columbia & & & 386293 & 4370 & 0 & & 53.7267 & -127.648 & 2022-10-14 04:22:28 & British Columbia, Canada \\ 3214047 & 2022-10-12 & Canada & British Columbia & & & 385599 & 4321 & 0 & & 53.7267 & -127.648 & 2022-10-13 04:22:39 & British Columbia, Canada \\ 3249896 & 2022-10-11 & Canada & British Columbia & & & 385599 & 4321 & 0 & & 53.7267 & -127.648 & 2022-10-12 04:22:51 & British Columbia, Canada \\ 2967155 & 2022-10-10 & Canada & British Columbia & & & 385599 & 4321 & 0 & & 53.7267 & -127.648 & 2022-10-11 04:23:05 & British Columbia, Canada \\ 3097191 & 2022-10-09 & Canada & British Columbia & & & 385599 & 4321 & 0 & & 53.7267 & -127.648 & 2022-10-10 04:22:32 & British Columbia, Canada \\ 4002416 & 2022-10-08 & Canada & British Columbia & & & 385599 & 4321 & 0 & & 53.7267 & -127.648 & 2022-10-09 04:21:16 & British Columbia, Canada \\ 396013 & 2022-10-07 & Canada & British Columbia & & & 385599 & 4321 & 0 & & 53.7267 & -127.648 & 2022-10-08 04:22:56 & British Columbia, Canada \\ 2529130 & 2022-10-06 & Canada & British Columbia & & & 385599 & 4321 & 0 & & 53.7267 & -127.648 & 2022-10-07 04:23:08 & British Columbia, Canada \\ 1810524 & 2022-10-05 & Canada & British Columbia & & & 384900 & 4283 & 0 & & 53.7267 & -127.648 & 2022-10-06 04:21:22 & British Columbia, Canada \\ 130498 & 2022-10-04 & Canada & British Columbia & & & 384900 & 4283 & 0 & & 53.7267 & -127.648 & 2022-10-05 04:23:06 & British Columbia, Canada \\ 2685445 & 2022-10-03 & Canada & British Columbia & & & 384900 & 4283 & 0 & & 53.7267 & -127.648 & 2022-10-04 04:22:55 & British Columbia, Canada \\ 2259512 & 2022-10-02 & Canada & British Columbia & & & 384900 & 4283 & 0 & & 53.7267 & -127.648 & 2022-10-03 04:23:11 & British Columbia, Canada \\ 2995038 & 2022-10-01 & Canada & British Columbia & & & 384900 & 4283 & 0 & & 53.7267 & -127.648 & 2022-10-02 04:21:23 & British Columbia, Canada \\ 853364 & 2022-09-30 & Canada & British Columbia & & & 384900 & 4283 & 0 & & 53.7267 & -127.648 & 2022-10-01 04:23:01 & British Columbia, Canada \\ 2375290 & 2022-09-29 & Canada & British Columbia & & & 384900 & 4283 & 0 & & 53.7267 & -127.648 & 2022-09-30 04:23:09 & British Columbia, Canada \\ 1559841 & 2022-09-28 & Canada & British Columbia & & & 384266 & 4253 & 0 & & 53.7267 & -127.648 & 2022-09-29 04:22:34 & British Columbia, Canada \\ 3994384 & 2022-09-27 & Canada & British Columbia & & & 384266 & 4253 & 0 & & 53.7267 & -127.648 & 2022-09-28 04:23:01 & British Columbia, Canada \\ 2768712 & 2022-09-26 & Canada & British Columbia & & & 384266 & 4253 & 0 & & 53.7267 & -127.648 & 2022-09-27 04:23:01 & British Columbia, Canada \\ 1976365 & 2022-09-25 & Canada & British Columbia & & & 384266 & 4253 & 0 & & 53.7267 & -127.648 & 2022-09-26 04:20:52 & British Columbia, Canada \\ 2649532 & 2022-09-24 & Canada & British Columbia & & & 384266 & 4253 & 0 & & 53.7267 & -127.648 & 2022-09-25 04:23:31 & British Columbia, Canada \\ 383972 & 2022-09-23 & Canada & British Columbia & & & 384266 & 4253 & 0 & & 53.7267 & -127.648 & 2022-09-24 04:21:40 & British Columbia, Canada \\ 1624038 & 2022-09-22 & Canada & British Columbia & & & 384266 & 4253 & 0 & & 53.7267 & -127.648 & 2022-09-23 04:23:13 & British Columbia, Canada \\ 1370242 & 2022-09-21 & Canada & British Columbia & & & 383628 & 4216 & 0 & & 53.7267 & -127.648 & 2022-09-22 04:22:56 & British Columbia, Canada \\ \hline \end{tabular}