johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where combined_key = "Galax, Virginia, US" and province_or_state = "Virginia" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756251 | 2756251 | 2022-12-29 | US | Virginia | Galax | 51640 | 3113 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-30 04:21:04 | Galax, Virginia, US | |
1077257 | 1077257 | 2022-12-28 | US | Virginia | Galax | 51640 | 3113 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-29 04:21:01 | Galax, Virginia, US | |
331254 | 331254 | 2022-12-27 | US | Virginia | Galax | 51640 | 3112 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-28 04:21:04 | Galax, Virginia, US | |
221327 | 221327 | 2022-12-26 | US | Virginia | Galax | 51640 | 3111 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-27 04:21:07 | Galax, Virginia, US | |
3225784 | 3225784 | 2022-12-25 | US | Virginia | Galax | 51640 | 3099 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-26 04:21:06 | Galax, Virginia, US | |
1021698 | 1021698 | 2022-12-24 | US | Virginia | Galax | 51640 | 3099 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-25 04:21:04 | Galax, Virginia, US | |
693721 | 693721 | 2022-12-23 | US | Virginia | Galax | 51640 | 3099 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-24 04:21:02 | Galax, Virginia, US | |
2182931 | 2182931 | 2022-12-22 | US | Virginia | Galax | 51640 | 3102 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-23 04:21:04 | Galax, Virginia, US | |
454735 | 454735 | 2022-12-21 | US | Virginia | Galax | 51640 | 3096 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-22 04:20:56 | Galax, Virginia, US | |
2954734 | 2954734 | 2022-12-20 | US | Virginia | Galax | 51640 | 3093 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-21 04:21:03 | Galax, Virginia, US | |
3177136 | 3177136 | 2022-12-19 | US | Virginia | Galax | 51640 | 3089 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-20 04:21:04 | Galax, Virginia, US | |
1631653 | 1631653 | 2022-12-18 | US | Virginia | Galax | 51640 | 3084 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-19 04:21:03 | Galax, Virginia, US | |
507032 | 507032 | 2022-12-17 | US | Virginia | Galax | 51640 | 3084 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-18 04:21:03 | Galax, Virginia, US | |
3327604 | 3327604 | 2022-12-16 | US | Virginia | Galax | 51640 | 3084 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-17 04:21:04 | Galax, Virginia, US | |
546116 | 546116 | 2022-12-15 | US | Virginia | Galax | 51640 | 3085 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-16 04:21:01 | Galax, Virginia, US | |
351644 | 351644 | 2022-12-14 | US | Virginia | Galax | 51640 | 3078 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-15 04:20:58 | Galax, Virginia, US | |
311232 | 311232 | 2022-12-13 | US | Virginia | Galax | 51640 | 3075 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-14 04:21:04 | Galax, Virginia, US | |
1152293 | 1152293 | 2022-12-12 | US | Virginia | Galax | 51640 | 3073 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-13 04:21:01 | Galax, Virginia, US | |
872147 | 872147 | 2022-12-11 | US | Virginia | Galax | 51640 | 3068 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-12 04:21:01 | Galax, Virginia, US | |
260677 | 260677 | 2022-12-10 | US | Virginia | Galax | 51640 | 3068 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-11 04:20:50 | Galax, Virginia, US | |
3939391 | 3939391 | 2022-12-09 | US | Virginia | Galax | 51640 | 3068 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-10 04:21:02 | Galax, Virginia, US | |
3380723 | 3380723 | 2022-12-08 | US | Virginia | Galax | 51640 | 3066 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-09 04:21:05 | Galax, Virginia, US | |
1987994 | 1987994 | 2022-12-07 | US | Virginia | Galax | 51640 | 3065 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-08 04:21:07 | Galax, Virginia, US | |
3717517 | 3717517 | 2022-12-06 | US | Virginia | Galax | 51640 | 3066 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-07 04:20:58 | Galax, Virginia, US | |
2418222 | 2418222 | 2022-12-05 | US | Virginia | Galax | 51640 | 3057 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-06 04:21:03 | Galax, Virginia, US | |
721830 | 721830 | 2022-12-04 | US | Virginia | Galax | 51640 | 3063 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-05 04:20:58 | Galax, Virginia, US | |
2820119 | 2820119 | 2022-12-03 | US | Virginia | Galax | 51640 | 3063 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-04 04:20:56 | Galax, Virginia, US | |
836975 | 836975 | 2022-12-02 | US | Virginia | Galax | 51640 | 3063 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-03 04:21:02 | Galax, Virginia, US | |
2139505 | 2139505 | 2022-12-01 | US | Virginia | Galax | 51640 | 3052 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-02 04:21:07 | Galax, Virginia, US | |
1967921 | 1967921 | 2022-11-30 | US | Virginia | Galax | 51640 | 3051 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-01 04:21:03 | Galax, Virginia, US | |
2559935 | 2559935 | 2022-11-29 | US | Virginia | Galax | 51640 | 3050 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-11-30 04:21:07 | Galax, Virginia, US | |
1243009 | 1243009 | 2022-11-28 | US | Virginia | Galax | 51640 | 3046 | 82 | 0 | 36.66601852 | -80.91703124 | 2022-11-29 04:21:05 | Galax, Virginia, US | |
3554997 | 3554997 | 2022-11-27 | US | Virginia | Galax | 51640 | 3045 | 82 | 0 | 36.66601852 | -80.91703124 | 2022-11-28 04:21:02 | Galax, Virginia, US | |
2103477 | 2103477 | 2022-11-26 | US | Virginia | Galax | 51640 | 3045 | 82 | 0 | 36.66601852 | -80.91703124 | 2022-11-27 04:21:05 | Galax, Virginia, US | |
490968 | 490968 | 2022-11-25 | US | Virginia | Galax | 51640 | 3045 | 82 | 0 | 36.66601852 | -80.91703124 | 2022-11-26 04:21:11 | Galax, Virginia, US | |
3526797 | 3526797 | 2022-11-24 | US | Virginia | Galax | 51640 | 3048 | 82 | 0 | 36.66601852 | -80.91703124 | 2022-11-25 04:21:06 | Galax, Virginia, US | |
3315580 | 3315580 | 2022-11-23 | US | Virginia | Galax | 51640 | 3048 | 82 | 0 | 36.66601852 | -80.91703124 | 2022-11-24 04:21:09 | Galax, Virginia, US | |
1623621 | 1623621 | 2022-11-22 | US | Virginia | Galax | 51640 | 3049 | 82 | 0 | 36.66601852 | -80.91703124 | 2022-11-23 04:21:06 | Galax, Virginia, US | |
3463509 | 3463509 | 2022-11-21 | US | Virginia | Galax | 51640 | 3043 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-22 04:20:47 | Galax, Virginia, US | |
1643694 | 1643694 | 2022-11-20 | US | Virginia | Galax | 51640 | 3042 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-21 04:21:05 | Galax, Virginia, US | |
2067251 | 2067251 | 2022-11-19 | US | Virginia | Galax | 51640 | 3042 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-20 04:21:08 | Galax, Virginia, US | |
1758645 | 1758645 | 2022-11-18 | US | Virginia | Galax | 51640 | 3042 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-19 04:21:14 | Galax, Virginia, US | |
3029638 | 3029638 | 2022-11-17 | US | Virginia | Galax | 51640 | 3045 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-18 04:21:15 | Galax, Virginia, US | |
2489349 | 2489349 | 2022-11-16 | US | Virginia | Galax | 51640 | 3040 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-17 04:21:11 | Galax, Virginia, US | |
295360 | 295360 | 2022-11-15 | US | Virginia | Galax | 51640 | 3041 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-16 04:21:09 | Galax, Virginia, US | |
3600390 | 3600390 | 2022-11-14 | US | Virginia | Galax | 51640 | 3039 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-15 04:21:16 | Galax, Virginia, US | |
315248 | 315248 | 2022-11-13 | US | Virginia | Galax | 51640 | 3039 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-14 04:21:09 | Galax, Virginia, US | |
66409 | 66409 | 2022-11-12 | US | Virginia | Galax | 51640 | 3039 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-13 04:21:14 | Galax, Virginia, US | |
2930571 | 2930571 | 2022-11-11 | US | Virginia | Galax | 51640 | 3039 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-12 04:20:41 | Galax, Virginia, US | |
2509407 | 2509407 | 2022-11-10 | US | Virginia | Galax | 51640 | 3038 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-11 04:21:22 | Galax, Virginia, US | |
2434282 | 2434282 | 2022-11-09 | US | Virginia | Galax | 51640 | 3043 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-10 04:21:16 | Galax, Virginia, US | |
482938 | 482938 | 2022-11-08 | US | Virginia | Galax | 51640 | 3039 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-09 04:21:22 | Galax, Virginia, US | |
2442088 | 2442088 | 2022-11-07 | US | Virginia | Galax | 51640 | 3033 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-08 04:21:21 | Galax, Virginia, US | |
1053186 | 1053186 | 2022-11-06 | US | Virginia | Galax | 51640 | 3030 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-07 04:21:26 | Galax, Virginia, US | |
621210 | 621210 | 2022-11-05 | US | Virginia | Galax | 51640 | 3030 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-06 04:21:24 | Galax, Virginia, US | |
1025714 | 1025714 | 2022-11-04 | US | Virginia | Galax | 51640 | 3030 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-05 04:21:52 | Galax, Virginia, US | |
434705 | 434705 | 2022-11-03 | US | Virginia | Galax | 51640 | 3023 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-04 04:22:11 | Galax, Virginia, US | |
852947 | 852947 | 2022-11-02 | US | Virginia | Galax | 51640 | 3022 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-03 04:22:05 | Galax, Virginia, US | |
713798 | 713798 | 2022-11-01 | US | Virginia | Galax | 51640 | 3022 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-02 04:22:09 | Galax, Virginia, US | |
3288247 | 3288247 | 2022-10-31 | US | Virginia | Galax | 51640 | 3018 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-11-01 04:22:36 | Galax, Virginia, US | |
323280 | 323280 | 2022-10-30 | US | Virginia | Galax | 51640 | 3014 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-10-31 04:21:36 | Galax, Virginia, US | |
915556 | 915556 | 2022-10-29 | US | Virginia | Galax | 51640 | 3014 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-10-30 04:22:14 | Galax, Virginia, US | |
1369825 | 1369825 | 2022-10-28 | US | Virginia | Galax | 51640 | 3014 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-10-29 04:21:13 | Galax, Virginia, US | |
3041680 | 3041680 | 2022-10-27 | US | Virginia | Galax | 51640 | 2998 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-10-28 04:22:31 | Galax, Virginia, US | |
542100 | 542100 | 2022-10-26 | US | Virginia | Galax | 51640 | 2999 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-10-27 04:22:01 | Galax, Virginia, US | |
1833501 | 1833501 | 2022-10-25 | US | Virginia | Galax | 51640 | 2993 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-10-26 04:22:19 | Galax, Virginia, US | |
797762 | 797762 | 2022-10-24 | US | Virginia | Galax | 51640 | 2993 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-10-25 04:21:53 | Galax, Virginia, US | |
3280217 | 3280217 | 2022-10-23 | US | Virginia | Galax | 51640 | 2989 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-10-24 04:22:29 | Galax, Virginia, US | |
2271255 | 2271255 | 2022-10-22 | US | Virginia | Galax | 51640 | 2989 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-10-23 04:22:46 | Galax, Virginia, US | |
1595555 | 1595555 | 2022-10-21 | US | Virginia | Galax | 51640 | 2989 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-10-22 04:22:53 | Galax, Virginia, US | |
2275271 | 2275271 | 2022-10-20 | US | Virginia | Galax | 51640 | 2992 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-10-21 04:22:23 | Galax, Virginia, US | |
201606 | 201606 | 2022-10-19 | US | Virginia | Galax | 51640 | 2984 | 81 | 0 | 36.66601852 | -80.91703124 | 2022-10-20 04:22:59 | Galax, Virginia, US | |
2760267 | 2760267 | 2022-10-18 | US | Virginia | Galax | 51640 | 2983 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-19 04:22:26 | Galax, Virginia, US | |
2028101 | 2028101 | 2022-10-17 | US | Virginia | Galax | 51640 | 2982 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-18 04:22:42 | Galax, Virginia, US | |
2162879 | 2162879 | 2022-10-16 | US | Virginia | Galax | 51640 | 2982 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-17 04:20:31 | Galax, Virginia, US | |
519076 | 519076 | 2022-10-15 | US | Virginia | Galax | 51640 | 2982 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-16 04:22:39 | Galax, Virginia, US | |
2036133 | 2036133 | 2022-10-14 | US | Virginia | Galax | 51640 | 2982 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-15 04:22:00 | Galax, Virginia, US | |
3756821 | 3756821 | 2022-10-13 | US | Virginia | Galax | 51640 | 3011 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-14 04:22:28 | Galax, Virginia, US | |
3217646 | 3217646 | 2022-10-12 | US | Virginia | Galax | 51640 | 3022 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-13 04:22:39 | Galax, Virginia, US | |
3253495 | 3253495 | 2022-10-11 | US | Virginia | Galax | 51640 | 3075 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-12 04:22:51 | Galax, Virginia, US | |
2970754 | 2970754 | 2022-10-10 | US | Virginia | Galax | 51640 | 3073 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-11 04:23:05 | Galax, Virginia, US | |
3100790 | 3100790 | 2022-10-09 | US | Virginia | Galax | 51640 | 3185 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-10 04:22:32 | Galax, Virginia, US | |
4006015 | 4006015 | 2022-10-08 | US | Virginia | Galax | 51640 | 3185 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-09 04:21:16 | Galax, Virginia, US | |
399612 | 399612 | 2022-10-07 | US | Virginia | Galax | 51640 | 3185 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-08 04:22:56 | Galax, Virginia, US | |
2532729 | 2532729 | 2022-10-06 | US | Virginia | Galax | 51640 | 3215 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-07 04:23:08 | Galax, Virginia, US | |
1814123 | 1814123 | 2022-10-05 | US | Virginia | Galax | 51640 | 3203 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-06 04:21:22 | Galax, Virginia, US | |
134097 | 134097 | 2022-10-04 | US | Virginia | Galax | 51640 | 3195 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-05 04:23:06 | Galax, Virginia, US | |
2689044 | 2689044 | 2022-10-03 | US | Virginia | Galax | 51640 | 3196 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-04 04:22:55 | Galax, Virginia, US | |
2263111 | 2263111 | 2022-10-02 | US | Virginia | Galax | 51640 | 3195 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-03 04:23:11 | Galax, Virginia, US | |
2998637 | 2998637 | 2022-10-01 | US | Virginia | Galax | 51640 | 3195 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-02 04:21:23 | Galax, Virginia, US | |
856963 | 856963 | 2022-09-30 | US | Virginia | Galax | 51640 | 3195 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-01 04:23:01 | Galax, Virginia, US | |
2378889 | 2378889 | 2022-09-29 | US | Virginia | Galax | 51640 | 3195 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-09-30 04:23:09 | Galax, Virginia, US | |
1563440 | 1563440 | 2022-09-28 | US | Virginia | Galax | 51640 | 3195 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-09-29 04:22:34 | Galax, Virginia, US | |
3997983 | 3997983 | 2022-09-27 | US | Virginia | Galax | 51640 | 3190 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-09-28 04:23:01 | Galax, Virginia, US | |
2772311 | 2772311 | 2022-09-26 | US | Virginia | Galax | 51640 | 3191 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-09-27 04:23:01 | Galax, Virginia, US | |
1979964 | 1979964 | 2022-09-25 | US | Virginia | Galax | 51640 | 3184 | 79 | 0 | 36.66601852 | -80.91703124 | 2022-09-26 04:20:52 | Galax, Virginia, US | |
2653131 | 2653131 | 2022-09-24 | US | Virginia | Galax | 51640 | 3184 | 79 | 0 | 36.66601852 | -80.91703124 | 2022-09-25 04:23:31 | Galax, Virginia, US | |
387571 | 387571 | 2022-09-23 | US | Virginia | Galax | 51640 | 3184 | 79 | 0 | 36.66601852 | -80.91703124 | 2022-09-24 04:21:40 | Galax, Virginia, US | |
1627637 | 1627637 | 2022-09-22 | US | Virginia | Galax | 51640 | 3185 | 79 | 0 | 36.66601852 | -80.91703124 | 2022-09-23 04:23:13 | Galax, Virginia, US | |
1373841 | 1373841 | 2022-09-21 | US | Virginia | Galax | 51640 | 3182 | 79 | 0 | 36.66601852 | -80.91703124 | 2022-09-22 04:22:56 | Galax, 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]);