johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where combined_key = "Alexandria, Virginia, US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756206 | 2756206 | 2022-12-29 | US | Virginia | Alexandria | 51510 | 44038 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-30 04:21:04 | Alexandria, Virginia, US | |
1077212 | 1077212 | 2022-12-28 | US | Virginia | Alexandria | 51510 | 44038 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-29 04:21:01 | Alexandria, Virginia, US | |
331209 | 331209 | 2022-12-27 | US | Virginia | Alexandria | 51510 | 44006 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-28 04:21:04 | Alexandria, Virginia, US | |
221282 | 221282 | 2022-12-26 | US | Virginia | Alexandria | 51510 | 43977 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-27 04:21:07 | Alexandria, Virginia, US | |
3225739 | 3225739 | 2022-12-25 | US | Virginia | Alexandria | 51510 | 43880 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-26 04:21:06 | Alexandria, Virginia, US | |
1021653 | 1021653 | 2022-12-24 | US | Virginia | Alexandria | 51510 | 43880 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-25 04:21:04 | Alexandria, Virginia, US | |
693676 | 693676 | 2022-12-23 | US | Virginia | Alexandria | 51510 | 43880 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-24 04:21:02 | Alexandria, Virginia, US | |
2182886 | 2182886 | 2022-12-22 | US | Virginia | Alexandria | 51510 | 43817 | 219 | 0 | 38.814003 | -77.08183073 | 2022-12-23 04:21:04 | Alexandria, Virginia, US | |
454690 | 454690 | 2022-12-21 | US | Virginia | Alexandria | 51510 | 43765 | 218 | 0 | 38.814003 | -77.08183073 | 2022-12-22 04:20:56 | Alexandria, Virginia, US | |
2954689 | 2954689 | 2022-12-20 | US | Virginia | Alexandria | 51510 | 43685 | 218 | 0 | 38.814003 | -77.08183073 | 2022-12-21 04:21:03 | Alexandria, Virginia, US | |
3177091 | 3177091 | 2022-12-19 | US | Virginia | Alexandria | 51510 | 43657 | 218 | 0 | 38.814003 | -77.08183073 | 2022-12-20 04:21:04 | Alexandria, Virginia, US | |
1631608 | 1631608 | 2022-12-18 | US | Virginia | Alexandria | 51510 | 43529 | 218 | 0 | 38.814003 | -77.08183073 | 2022-12-19 04:21:03 | Alexandria, Virginia, US | |
506987 | 506987 | 2022-12-17 | US | Virginia | Alexandria | 51510 | 43529 | 218 | 0 | 38.814003 | -77.08183073 | 2022-12-18 04:21:03 | Alexandria, Virginia, US | |
3327559 | 3327559 | 2022-12-16 | US | Virginia | Alexandria | 51510 | 43529 | 218 | 0 | 38.814003 | -77.08183073 | 2022-12-17 04:21:04 | Alexandria, Virginia, US | |
546071 | 546071 | 2022-12-15 | US | Virginia | Alexandria | 51510 | 43478 | 216 | 0 | 38.814003 | -77.08183073 | 2022-12-16 04:21:01 | Alexandria, Virginia, US | |
351599 | 351599 | 2022-12-14 | US | Virginia | Alexandria | 51510 | 43429 | 216 | 0 | 38.814003 | -77.08183073 | 2022-12-15 04:20:58 | Alexandria, Virginia, US | |
311187 | 311187 | 2022-12-13 | US | Virginia | Alexandria | 51510 | 43360 | 215 | 0 | 38.814003 | -77.08183073 | 2022-12-14 04:21:04 | Alexandria, Virginia, US | |
1152248 | 1152248 | 2022-12-12 | US | Virginia | Alexandria | 51510 | 43325 | 215 | 0 | 38.814003 | -77.08183073 | 2022-12-13 04:21:01 | Alexandria, Virginia, US | |
872102 | 872102 | 2022-12-11 | US | Virginia | Alexandria | 51510 | 43219 | 215 | 0 | 38.814003 | -77.08183073 | 2022-12-12 04:21:01 | Alexandria, Virginia, US | |
260632 | 260632 | 2022-12-10 | US | Virginia | Alexandria | 51510 | 43219 | 215 | 0 | 38.814003 | -77.08183073 | 2022-12-11 04:20:50 | Alexandria, Virginia, US | |
3939346 | 3939346 | 2022-12-09 | US | Virginia | Alexandria | 51510 | 43219 | 215 | 0 | 38.814003 | -77.08183073 | 2022-12-10 04:21:02 | Alexandria, Virginia, US | |
3380678 | 3380678 | 2022-12-08 | US | Virginia | Alexandria | 51510 | 43176 | 214 | 0 | 38.814003 | -77.08183073 | 2022-12-09 04:21:05 | Alexandria, Virginia, US | |
1987949 | 1987949 | 2022-12-07 | US | Virginia | Alexandria | 51510 | 43130 | 214 | 0 | 38.814003 | -77.08183073 | 2022-12-08 04:21:07 | Alexandria, Virginia, US | |
3717472 | 3717472 | 2022-12-06 | US | Virginia | Alexandria | 51510 | 43076 | 214 | 0 | 38.814003 | -77.08183073 | 2022-12-07 04:20:58 | Alexandria, Virginia, US | |
2418177 | 2418177 | 2022-12-05 | US | Virginia | Alexandria | 51510 | 43046 | 214 | 0 | 38.814003 | -77.08183073 | 2022-12-06 04:21:03 | Alexandria, Virginia, US | |
721785 | 721785 | 2022-12-04 | US | Virginia | Alexandria | 51510 | 42986 | 214 | 0 | 38.814003 | -77.08183073 | 2022-12-05 04:20:58 | Alexandria, Virginia, US | |
2820074 | 2820074 | 2022-12-03 | US | Virginia | Alexandria | 51510 | 42986 | 214 | 0 | 38.814003 | -77.08183073 | 2022-12-04 04:20:56 | Alexandria, Virginia, US | |
836930 | 836930 | 2022-12-02 | US | Virginia | Alexandria | 51510 | 42986 | 214 | 0 | 38.814003 | -77.08183073 | 2022-12-03 04:21:02 | Alexandria, Virginia, US | |
2139460 | 2139460 | 2022-12-01 | US | Virginia | Alexandria | 51510 | 42939 | 213 | 0 | 38.814003 | -77.08183073 | 2022-12-02 04:21:07 | Alexandria, Virginia, US | |
1967876 | 1967876 | 2022-11-30 | US | Virginia | Alexandria | 51510 | 42900 | 213 | 0 | 38.814003 | -77.08183073 | 2022-12-01 04:21:03 | Alexandria, Virginia, US | |
2559890 | 2559890 | 2022-11-29 | US | Virginia | Alexandria | 51510 | 42861 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-30 04:21:07 | Alexandria, Virginia, US | |
1242964 | 1242964 | 2022-11-28 | US | Virginia | Alexandria | 51510 | 42828 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-29 04:21:05 | Alexandria, Virginia, US | |
3554952 | 3554952 | 2022-11-27 | US | Virginia | Alexandria | 51510 | 42774 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-28 04:21:02 | Alexandria, Virginia, US | |
2103432 | 2103432 | 2022-11-26 | US | Virginia | Alexandria | 51510 | 42774 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-27 04:21:05 | Alexandria, Virginia, US | |
490923 | 490923 | 2022-11-25 | US | Virginia | Alexandria | 51510 | 42774 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-26 04:21:11 | Alexandria, Virginia, US | |
3526752 | 3526752 | 2022-11-24 | US | Virginia | Alexandria | 51510 | 42730 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-25 04:21:06 | Alexandria, Virginia, US | |
3315535 | 3315535 | 2022-11-23 | US | Virginia | Alexandria | 51510 | 42730 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-24 04:21:09 | Alexandria, Virginia, US | |
1623576 | 1623576 | 2022-11-22 | US | Virginia | Alexandria | 51510 | 42695 | 213 | 0 | 38.814003 | -77.08183073 | 2022-11-23 04:21:06 | Alexandria, Virginia, US | |
3463464 | 3463464 | 2022-11-21 | US | Virginia | Alexandria | 51510 | 42677 | 212 | 0 | 38.814003 | -77.08183073 | 2022-11-22 04:20:47 | Alexandria, Virginia, US | |
1643649 | 1643649 | 2022-11-20 | US | Virginia | Alexandria | 51510 | 42613 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-21 04:21:05 | Alexandria, Virginia, US | |
2067206 | 2067206 | 2022-11-19 | US | Virginia | Alexandria | 51510 | 42613 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-20 04:21:08 | Alexandria, Virginia, US | |
1758600 | 1758600 | 2022-11-18 | US | Virginia | Alexandria | 51510 | 42613 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-19 04:21:14 | Alexandria, Virginia, US | |
3029593 | 3029593 | 2022-11-17 | US | Virginia | Alexandria | 51510 | 42581 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-18 04:21:15 | Alexandria, Virginia, US | |
2489304 | 2489304 | 2022-11-16 | US | Virginia | Alexandria | 51510 | 42559 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-17 04:21:11 | Alexandria, Virginia, US | |
295315 | 295315 | 2022-11-15 | US | Virginia | Alexandria | 51510 | 42547 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-16 04:21:09 | Alexandria, Virginia, US | |
3600345 | 3600345 | 2022-11-14 | US | Virginia | Alexandria | 51510 | 42491 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-15 04:21:16 | Alexandria, Virginia, US | |
315203 | 315203 | 2022-11-13 | US | Virginia | Alexandria | 51510 | 42491 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-14 04:21:09 | Alexandria, Virginia, US | |
66364 | 66364 | 2022-11-12 | US | Virginia | Alexandria | 51510 | 42491 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-13 04:21:14 | Alexandria, Virginia, US | |
2930526 | 2930526 | 2022-11-11 | US | Virginia | Alexandria | 51510 | 42491 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-12 04:20:41 | Alexandria, Virginia, US | |
2509362 | 2509362 | 2022-11-10 | US | Virginia | Alexandria | 51510 | 42468 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-11 04:21:22 | Alexandria, Virginia, US | |
2434237 | 2434237 | 2022-11-09 | US | Virginia | Alexandria | 51510 | 42443 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-10 04:21:16 | Alexandria, Virginia, US | |
482893 | 482893 | 2022-11-08 | US | Virginia | Alexandria | 51510 | 42426 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-09 04:21:22 | Alexandria, Virginia, US | |
2442043 | 2442043 | 2022-11-07 | US | Virginia | Alexandria | 51510 | 42411 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-08 04:21:21 | Alexandria, Virginia, US | |
1053141 | 1053141 | 2022-11-06 | US | Virginia | Alexandria | 51510 | 42356 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-07 04:21:26 | Alexandria, Virginia, US | |
621165 | 621165 | 2022-11-05 | US | Virginia | Alexandria | 51510 | 42356 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-06 04:21:24 | Alexandria, Virginia, US | |
1025669 | 1025669 | 2022-11-04 | US | Virginia | Alexandria | 51510 | 42356 | 211 | 0 | 38.814003 | -77.08183073 | 2022-11-05 04:21:52 | Alexandria, Virginia, US | |
434660 | 434660 | 2022-11-03 | US | Virginia | Alexandria | 51510 | 42334 | 210 | 0 | 38.814003 | -77.08183073 | 2022-11-04 04:22:11 | Alexandria, Virginia, US | |
852902 | 852902 | 2022-11-02 | US | Virginia | Alexandria | 51510 | 42307 | 210 | 0 | 38.814003 | -77.08183073 | 2022-11-03 04:22:05 | Alexandria, Virginia, US | |
713753 | 713753 | 2022-11-01 | US | Virginia | Alexandria | 51510 | 42290 | 210 | 0 | 38.814003 | -77.08183073 | 2022-11-02 04:22:09 | Alexandria, Virginia, US | |
3288202 | 3288202 | 2022-10-31 | US | Virginia | Alexandria | 51510 | 42274 | 210 | 0 | 38.814003 | -77.08183073 | 2022-11-01 04:22:36 | Alexandria, Virginia, US | |
323235 | 323235 | 2022-10-30 | US | Virginia | Alexandria | 51510 | 42217 | 210 | 0 | 38.814003 | -77.08183073 | 2022-10-31 04:21:36 | Alexandria, Virginia, US | |
915511 | 915511 | 2022-10-29 | US | Virginia | Alexandria | 51510 | 42217 | 210 | 0 | 38.814003 | -77.08183073 | 2022-10-30 04:22:14 | Alexandria, Virginia, US | |
1369780 | 1369780 | 2022-10-28 | US | Virginia | Alexandria | 51510 | 42217 | 210 | 0 | 38.814003 | -77.08183073 | 2022-10-29 04:21:13 | Alexandria, Virginia, US | |
3041635 | 3041635 | 2022-10-27 | US | Virginia | Alexandria | 51510 | 42182 | 210 | 0 | 38.814003 | -77.08183073 | 2022-10-28 04:22:31 | Alexandria, Virginia, US | |
542055 | 542055 | 2022-10-26 | US | Virginia | Alexandria | 51510 | 42169 | 210 | 0 | 38.814003 | -77.08183073 | 2022-10-27 04:22:01 | Alexandria, Virginia, US | |
1833456 | 1833456 | 2022-10-25 | US | Virginia | Alexandria | 51510 | 42143 | 210 | 0 | 38.814003 | -77.08183073 | 2022-10-26 04:22:19 | Alexandria, Virginia, US | |
797717 | 797717 | 2022-10-24 | US | Virginia | Alexandria | 51510 | 42133 | 210 | 0 | 38.814003 | -77.08183073 | 2022-10-25 04:21:53 | Alexandria, Virginia, US | |
3280172 | 3280172 | 2022-10-23 | US | Virginia | Alexandria | 51510 | 42087 | 210 | 0 | 38.814003 | -77.08183073 | 2022-10-24 04:22:29 | Alexandria, Virginia, US | |
2271210 | 2271210 | 2022-10-22 | US | Virginia | Alexandria | 51510 | 42087 | 210 | 0 | 38.814003 | -77.08183073 | 2022-10-23 04:22:46 | Alexandria, Virginia, US | |
1595510 | 1595510 | 2022-10-21 | US | Virginia | Alexandria | 51510 | 42087 | 210 | 0 | 38.814003 | -77.08183073 | 2022-10-22 04:22:53 | Alexandria, Virginia, US | |
2275226 | 2275226 | 2022-10-20 | US | Virginia | Alexandria | 51510 | 42074 | 210 | 0 | 38.814003 | -77.08183073 | 2022-10-21 04:22:23 | Alexandria, Virginia, US | |
201561 | 201561 | 2022-10-19 | US | Virginia | Alexandria | 51510 | 42066 | 209 | 0 | 38.814003 | -77.08183073 | 2022-10-20 04:22:59 | Alexandria, Virginia, US | |
2760222 | 2760222 | 2022-10-18 | US | Virginia | Alexandria | 51510 | 42067 | 209 | 0 | 38.814003 | -77.08183073 | 2022-10-19 04:22:26 | Alexandria, Virginia, US | |
2028056 | 2028056 | 2022-10-17 | US | Virginia | Alexandria | 51510 | 42058 | 209 | 0 | 38.814003 | -77.08183073 | 2022-10-18 04:22:42 | Alexandria, Virginia, US | |
2162834 | 2162834 | 2022-10-16 | US | Virginia | Alexandria | 51510 | 41977 | 209 | 0 | 38.814003 | -77.08183073 | 2022-10-17 04:20:31 | Alexandria, Virginia, US | |
519031 | 519031 | 2022-10-15 | US | Virginia | Alexandria | 51510 | 41977 | 209 | 0 | 38.814003 | -77.08183073 | 2022-10-16 04:22:39 | Alexandria, Virginia, US | |
2036088 | 2036088 | 2022-10-14 | US | Virginia | Alexandria | 51510 | 41977 | 209 | 0 | 38.814003 | -77.08183073 | 2022-10-15 04:22:00 | Alexandria, Virginia, US | |
3756776 | 3756776 | 2022-10-13 | US | Virginia | Alexandria | 51510 | 41961 | 208 | 0 | 38.814003 | -77.08183073 | 2022-10-14 04:22:28 | Alexandria, Virginia, US | |
3217601 | 3217601 | 2022-10-12 | US | Virginia | Alexandria | 51510 | 41954 | 208 | 0 | 38.814003 | -77.08183073 | 2022-10-13 04:22:39 | Alexandria, Virginia, US | |
3253450 | 3253450 | 2022-10-11 | US | Virginia | Alexandria | 51510 | 41930 | 208 | 0 | 38.814003 | -77.08183073 | 2022-10-12 04:22:51 | Alexandria, Virginia, US | |
2970709 | 2970709 | 2022-10-10 | US | Virginia | Alexandria | 51510 | 41926 | 207 | 0 | 38.814003 | -77.08183073 | 2022-10-11 04:23:05 | Alexandria, Virginia, US | |
3100745 | 3100745 | 2022-10-09 | US | Virginia | Alexandria | 51510 | 41877 | 207 | 0 | 38.814003 | -77.08183073 | 2022-10-10 04:22:32 | Alexandria, Virginia, US | |
4005970 | 4005970 | 2022-10-08 | US | Virginia | Alexandria | 51510 | 41877 | 207 | 0 | 38.814003 | -77.08183073 | 2022-10-09 04:21:16 | Alexandria, Virginia, US | |
399567 | 399567 | 2022-10-07 | US | Virginia | Alexandria | 51510 | 41877 | 207 | 0 | 38.814003 | -77.08183073 | 2022-10-08 04:22:56 | Alexandria, Virginia, US | |
2532684 | 2532684 | 2022-10-06 | US | Virginia | Alexandria | 51510 | 41858 | 207 | 0 | 38.814003 | -77.08183073 | 2022-10-07 04:23:08 | Alexandria, Virginia, US | |
1814078 | 1814078 | 2022-10-05 | US | Virginia | Alexandria | 51510 | 41839 | 206 | 0 | 38.814003 | -77.08183073 | 2022-10-06 04:21:22 | Alexandria, Virginia, US | |
134052 | 134052 | 2022-10-04 | US | Virginia | Alexandria | 51510 | 41823 | 206 | 0 | 38.814003 | -77.08183073 | 2022-10-05 04:23:06 | Alexandria, Virginia, US | |
2688999 | 2688999 | 2022-10-03 | US | Virginia | Alexandria | 51510 | 41804 | 206 | 0 | 38.814003 | -77.08183073 | 2022-10-04 04:22:55 | Alexandria, Virginia, US | |
2263066 | 2263066 | 2022-10-02 | US | Virginia | Alexandria | 51510 | 41707 | 205 | 0 | 38.814003 | -77.08183073 | 2022-10-03 04:23:11 | Alexandria, Virginia, US | |
2998592 | 2998592 | 2022-10-01 | US | Virginia | Alexandria | 51510 | 41707 | 205 | 0 | 38.814003 | -77.08183073 | 2022-10-02 04:21:23 | Alexandria, Virginia, US | |
856918 | 856918 | 2022-09-30 | US | Virginia | Alexandria | 51510 | 41707 | 205 | 0 | 38.814003 | -77.08183073 | 2022-10-01 04:23:01 | Alexandria, Virginia, US | |
2378844 | 2378844 | 2022-09-29 | US | Virginia | Alexandria | 51510 | 41707 | 205 | 0 | 38.814003 | -77.08183073 | 2022-09-30 04:23:09 | Alexandria, Virginia, US | |
1563395 | 1563395 | 2022-09-28 | US | Virginia | Alexandria | 51510 | 41687 | 205 | 0 | 38.814003 | -77.08183073 | 2022-09-29 04:22:34 | Alexandria, Virginia, US | |
3997938 | 3997938 | 2022-09-27 | US | Virginia | Alexandria | 51510 | 41645 | 205 | 0 | 38.814003 | -77.08183073 | 2022-09-28 04:23:01 | Alexandria, Virginia, US | |
2772266 | 2772266 | 2022-09-26 | US | Virginia | Alexandria | 51510 | 41627 | 204 | 0 | 38.814003 | -77.08183073 | 2022-09-27 04:23:01 | Alexandria, Virginia, US | |
1979919 | 1979919 | 2022-09-25 | US | Virginia | Alexandria | 51510 | 41569 | 204 | 0 | 38.814003 | -77.08183073 | 2022-09-26 04:20:52 | Alexandria, Virginia, US | |
2653086 | 2653086 | 2022-09-24 | US | Virginia | Alexandria | 51510 | 41569 | 204 | 0 | 38.814003 | -77.08183073 | 2022-09-25 04:23:31 | Alexandria, Virginia, US | |
387526 | 387526 | 2022-09-23 | US | Virginia | Alexandria | 51510 | 41569 | 204 | 0 | 38.814003 | -77.08183073 | 2022-09-24 04:21:40 | Alexandria, Virginia, US | |
1627592 | 1627592 | 2022-09-22 | US | Virginia | Alexandria | 51510 | 41547 | 204 | 0 | 38.814003 | -77.08183073 | 2022-09-23 04:23:13 | Alexandria, Virginia, US | |
1373796 | 1373796 | 2022-09-21 | US | Virginia | Alexandria | 51510 | 41510 | 204 | 0 | 38.814003 | -77.08183073 | 2022-09-22 04:22:56 | Alexandria, Virginia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);