johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where country_or_region = "US", latitude = "36.70586667" and province_or_state = "Virginia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756272 | 2756272 | 2022-12-29 | US | Virginia | Lee | 51105 | 8124 | 108 | 0 | 36.70586667 | -83.12606515 | 2022-12-30 04:21:04 | Lee, Virginia, US | |
1077278 | 1077278 | 2022-12-28 | US | Virginia | Lee | 51105 | 8124 | 108 | 0 | 36.70586667 | -83.12606515 | 2022-12-29 04:21:01 | Lee, Virginia, US | |
331275 | 331275 | 2022-12-27 | US | Virginia | Lee | 51105 | 8102 | 108 | 0 | 36.70586667 | -83.12606515 | 2022-12-28 04:21:04 | Lee, Virginia, US | |
221348 | 221348 | 2022-12-26 | US | Virginia | Lee | 51105 | 8098 | 108 | 0 | 36.70586667 | -83.12606515 | 2022-12-27 04:21:07 | Lee, Virginia, US | |
3225805 | 3225805 | 2022-12-25 | US | Virginia | Lee | 51105 | 8090 | 108 | 0 | 36.70586667 | -83.12606515 | 2022-12-26 04:21:06 | Lee, Virginia, US | |
1021719 | 1021719 | 2022-12-24 | US | Virginia | Lee | 51105 | 8090 | 108 | 0 | 36.70586667 | -83.12606515 | 2022-12-25 04:21:04 | Lee, Virginia, US | |
693742 | 693742 | 2022-12-23 | US | Virginia | Lee | 51105 | 8090 | 108 | 0 | 36.70586667 | -83.12606515 | 2022-12-24 04:21:02 | Lee, Virginia, US | |
2182952 | 2182952 | 2022-12-22 | US | Virginia | Lee | 51105 | 8084 | 108 | 0 | 36.70586667 | -83.12606515 | 2022-12-23 04:21:04 | Lee, Virginia, US | |
454756 | 454756 | 2022-12-21 | US | Virginia | Lee | 51105 | 8072 | 108 | 0 | 36.70586667 | -83.12606515 | 2022-12-22 04:20:56 | Lee, Virginia, US | |
2954755 | 2954755 | 2022-12-20 | US | Virginia | Lee | 51105 | 8071 | 108 | 0 | 36.70586667 | -83.12606515 | 2022-12-21 04:21:03 | Lee, Virginia, US | |
3177157 | 3177157 | 2022-12-19 | US | Virginia | Lee | 51105 | 8065 | 108 | 0 | 36.70586667 | -83.12606515 | 2022-12-20 04:21:04 | Lee, Virginia, US | |
1631674 | 1631674 | 2022-12-18 | US | Virginia | Lee | 51105 | 8059 | 108 | 0 | 36.70586667 | -83.12606515 | 2022-12-19 04:21:03 | Lee, Virginia, US | |
507053 | 507053 | 2022-12-17 | US | Virginia | Lee | 51105 | 8059 | 108 | 0 | 36.70586667 | -83.12606515 | 2022-12-18 04:21:03 | Lee, Virginia, US | |
3327625 | 3327625 | 2022-12-16 | US | Virginia | Lee | 51105 | 8059 | 108 | 0 | 36.70586667 | -83.12606515 | 2022-12-17 04:21:04 | Lee, Virginia, US | |
546137 | 546137 | 2022-12-15 | US | Virginia | Lee | 51105 | 8057 | 108 | 0 | 36.70586667 | -83.12606515 | 2022-12-16 04:21:01 | Lee, Virginia, US | |
351665 | 351665 | 2022-12-14 | US | Virginia | Lee | 51105 | 8054 | 107 | 0 | 36.70586667 | -83.12606515 | 2022-12-15 04:20:58 | Lee, Virginia, US | |
311253 | 311253 | 2022-12-13 | US | Virginia | Lee | 51105 | 8046 | 107 | 0 | 36.70586667 | -83.12606515 | 2022-12-14 04:21:04 | Lee, Virginia, US | |
1152314 | 1152314 | 2022-12-12 | US | Virginia | Lee | 51105 | 8033 | 107 | 0 | 36.70586667 | -83.12606515 | 2022-12-13 04:21:01 | Lee, Virginia, US | |
872168 | 872168 | 2022-12-11 | US | Virginia | Lee | 51105 | 8029 | 107 | 0 | 36.70586667 | -83.12606515 | 2022-12-12 04:21:01 | Lee, Virginia, US | |
260698 | 260698 | 2022-12-10 | US | Virginia | Lee | 51105 | 8029 | 107 | 0 | 36.70586667 | -83.12606515 | 2022-12-11 04:20:50 | Lee, Virginia, US | |
3939412 | 3939412 | 2022-12-09 | US | Virginia | Lee | 51105 | 8029 | 107 | 0 | 36.70586667 | -83.12606515 | 2022-12-10 04:21:02 | Lee, Virginia, US | |
3380744 | 3380744 | 2022-12-08 | US | Virginia | Lee | 51105 | 8025 | 107 | 0 | 36.70586667 | -83.12606515 | 2022-12-09 04:21:05 | Lee, Virginia, US | |
1988015 | 1988015 | 2022-12-07 | US | Virginia | Lee | 51105 | 8021 | 107 | 0 | 36.70586667 | -83.12606515 | 2022-12-08 04:21:07 | Lee, Virginia, US | |
3717538 | 3717538 | 2022-12-06 | US | Virginia | Lee | 51105 | 8019 | 107 | 0 | 36.70586667 | -83.12606515 | 2022-12-07 04:20:58 | Lee, Virginia, US | |
2418243 | 2418243 | 2022-12-05 | US | Virginia | Lee | 51105 | 8018 | 106 | 0 | 36.70586667 | -83.12606515 | 2022-12-06 04:21:03 | Lee, Virginia, US | |
721851 | 721851 | 2022-12-04 | US | Virginia | Lee | 51105 | 8007 | 106 | 0 | 36.70586667 | -83.12606515 | 2022-12-05 04:20:58 | Lee, Virginia, US | |
2820140 | 2820140 | 2022-12-03 | US | Virginia | Lee | 51105 | 8007 | 106 | 0 | 36.70586667 | -83.12606515 | 2022-12-04 04:20:56 | Lee, Virginia, US | |
836996 | 836996 | 2022-12-02 | US | Virginia | Lee | 51105 | 8007 | 106 | 0 | 36.70586667 | -83.12606515 | 2022-12-03 04:21:02 | Lee, Virginia, US | |
2139526 | 2139526 | 2022-12-01 | US | Virginia | Lee | 51105 | 8001 | 106 | 0 | 36.70586667 | -83.12606515 | 2022-12-02 04:21:07 | Lee, Virginia, US | |
1967942 | 1967942 | 2022-11-30 | US | Virginia | Lee | 51105 | 7999 | 106 | 0 | 36.70586667 | -83.12606515 | 2022-12-01 04:21:03 | Lee, Virginia, US | |
2559956 | 2559956 | 2022-11-29 | US | Virginia | Lee | 51105 | 7995 | 106 | 0 | 36.70586667 | -83.12606515 | 2022-11-30 04:21:07 | Lee, Virginia, US | |
1243030 | 1243030 | 2022-11-28 | US | Virginia | Lee | 51105 | 7992 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-29 04:21:05 | Lee, Virginia, US | |
3555018 | 3555018 | 2022-11-27 | US | Virginia | Lee | 51105 | 7988 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-28 04:21:02 | Lee, Virginia, US | |
2103498 | 2103498 | 2022-11-26 | US | Virginia | Lee | 51105 | 7988 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-27 04:21:05 | Lee, Virginia, US | |
490989 | 490989 | 2022-11-25 | US | Virginia | Lee | 51105 | 7988 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-26 04:21:11 | Lee, Virginia, US | |
3526818 | 3526818 | 2022-11-24 | US | Virginia | Lee | 51105 | 7988 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-25 04:21:06 | Lee, Virginia, US | |
3315601 | 3315601 | 2022-11-23 | US | Virginia | Lee | 51105 | 7988 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-24 04:21:09 | Lee, Virginia, US | |
1623642 | 1623642 | 2022-11-22 | US | Virginia | Lee | 51105 | 7986 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-23 04:21:06 | Lee, Virginia, US | |
3463530 | 3463530 | 2022-11-21 | US | Virginia | Lee | 51105 | 7981 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-22 04:20:47 | Lee, Virginia, US | |
1643715 | 1643715 | 2022-11-20 | US | Virginia | Lee | 51105 | 7979 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-21 04:21:05 | Lee, Virginia, US | |
2067272 | 2067272 | 2022-11-19 | US | Virginia | Lee | 51105 | 7979 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-20 04:21:08 | Lee, Virginia, US | |
1758666 | 1758666 | 2022-11-18 | US | Virginia | Lee | 51105 | 7979 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-19 04:21:14 | Lee, Virginia, US | |
3029659 | 3029659 | 2022-11-17 | US | Virginia | Lee | 51105 | 7977 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-18 04:21:15 | Lee, Virginia, US | |
2489370 | 2489370 | 2022-11-16 | US | Virginia | Lee | 51105 | 7972 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-17 04:21:11 | Lee, Virginia, US | |
295381 | 295381 | 2022-11-15 | US | Virginia | Lee | 51105 | 7965 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-16 04:21:09 | Lee, Virginia, US | |
3600411 | 3600411 | 2022-11-14 | US | Virginia | Lee | 51105 | 7955 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-15 04:21:16 | Lee, Virginia, US | |
315269 | 315269 | 2022-11-13 | US | Virginia | Lee | 51105 | 7955 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-14 04:21:09 | Lee, Virginia, US | |
66430 | 66430 | 2022-11-12 | US | Virginia | Lee | 51105 | 7955 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-13 04:21:14 | Lee, Virginia, US | |
2930592 | 2930592 | 2022-11-11 | US | Virginia | Lee | 51105 | 7955 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-12 04:20:41 | Lee, Virginia, US | |
2509428 | 2509428 | 2022-11-10 | US | Virginia | Lee | 51105 | 7948 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-11 04:21:22 | Lee, Virginia, US | |
2434303 | 2434303 | 2022-11-09 | US | Virginia | Lee | 51105 | 7944 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-10 04:21:16 | Lee, Virginia, US | |
482959 | 482959 | 2022-11-08 | US | Virginia | Lee | 51105 | 7940 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-09 04:21:22 | Lee, Virginia, US | |
2442109 | 2442109 | 2022-11-07 | US | Virginia | Lee | 51105 | 7933 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-08 04:21:21 | Lee, Virginia, US | |
1053207 | 1053207 | 2022-11-06 | US | Virginia | Lee | 51105 | 7917 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-07 04:21:26 | Lee, Virginia, US | |
621231 | 621231 | 2022-11-05 | US | Virginia | Lee | 51105 | 7917 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-06 04:21:24 | Lee, Virginia, US | |
1025735 | 1025735 | 2022-11-04 | US | Virginia | Lee | 51105 | 7917 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-05 04:21:52 | Lee, Virginia, US | |
434726 | 434726 | 2022-11-03 | US | Virginia | Lee | 51105 | 7913 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-04 04:22:11 | Lee, Virginia, US | |
852968 | 852968 | 2022-11-02 | US | Virginia | Lee | 51105 | 7909 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-03 04:22:05 | Lee, Virginia, US | |
713819 | 713819 | 2022-11-01 | US | Virginia | Lee | 51105 | 7897 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-02 04:22:09 | Lee, Virginia, US | |
3288268 | 3288268 | 2022-10-31 | US | Virginia | Lee | 51105 | 7892 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-11-01 04:22:36 | Lee, Virginia, US | |
323301 | 323301 | 2022-10-30 | US | Virginia | Lee | 51105 | 7882 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-10-31 04:21:36 | Lee, Virginia, US | |
915577 | 915577 | 2022-10-29 | US | Virginia | Lee | 51105 | 7882 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-10-30 04:22:14 | Lee, Virginia, US | |
1369846 | 1369846 | 2022-10-28 | US | Virginia | Lee | 51105 | 7882 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-10-29 04:21:13 | Lee, Virginia, US | |
3041701 | 3041701 | 2022-10-27 | US | Virginia | Lee | 51105 | 7873 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-10-28 04:22:31 | Lee, Virginia, US | |
542121 | 542121 | 2022-10-26 | US | Virginia | Lee | 51105 | 7863 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-10-27 04:22:01 | Lee, Virginia, US | |
1833522 | 1833522 | 2022-10-25 | US | Virginia | Lee | 51105 | 7855 | 105 | 0 | 36.70586667 | -83.12606515 | 2022-10-26 04:22:19 | Lee, Virginia, US | |
797783 | 797783 | 2022-10-24 | US | Virginia | Lee | 51105 | 7850 | 104 | 0 | 36.70586667 | -83.12606515 | 2022-10-25 04:21:53 | Lee, Virginia, US | |
3280238 | 3280238 | 2022-10-23 | US | Virginia | Lee | 51105 | 7842 | 104 | 0 | 36.70586667 | -83.12606515 | 2022-10-24 04:22:29 | Lee, Virginia, US | |
2271276 | 2271276 | 2022-10-22 | US | Virginia | Lee | 51105 | 7842 | 104 | 0 | 36.70586667 | -83.12606515 | 2022-10-23 04:22:46 | Lee, Virginia, US | |
1595576 | 1595576 | 2022-10-21 | US | Virginia | Lee | 51105 | 7842 | 104 | 0 | 36.70586667 | -83.12606515 | 2022-10-22 04:22:53 | Lee, Virginia, US | |
2275292 | 2275292 | 2022-10-20 | US | Virginia | Lee | 51105 | 7839 | 104 | 0 | 36.70586667 | -83.12606515 | 2022-10-21 04:22:23 | Lee, Virginia, US | |
201627 | 201627 | 2022-10-19 | US | Virginia | Lee | 51105 | 7823 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-20 04:22:59 | Lee, Virginia, US | |
2760288 | 2760288 | 2022-10-18 | US | Virginia | Lee | 51105 | 7809 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-19 04:22:26 | Lee, Virginia, US | |
2028122 | 2028122 | 2022-10-17 | US | Virginia | Lee | 51105 | 7803 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-18 04:22:42 | Lee, Virginia, US | |
2162900 | 2162900 | 2022-10-16 | US | Virginia | Lee | 51105 | 7797 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-17 04:20:31 | Lee, Virginia, US | |
519097 | 519097 | 2022-10-15 | US | Virginia | Lee | 51105 | 7797 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-16 04:22:39 | Lee, Virginia, US | |
2036154 | 2036154 | 2022-10-14 | US | Virginia | Lee | 51105 | 7797 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-15 04:22:00 | Lee, Virginia, US | |
3756842 | 3756842 | 2022-10-13 | US | Virginia | Lee | 51105 | 7787 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-14 04:22:28 | Lee, Virginia, US | |
3217667 | 3217667 | 2022-10-12 | US | Virginia | Lee | 51105 | 7775 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-13 04:22:39 | Lee, Virginia, US | |
3253516 | 3253516 | 2022-10-11 | US | Virginia | Lee | 51105 | 7745 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-12 04:22:51 | Lee, Virginia, US | |
2970775 | 2970775 | 2022-10-10 | US | Virginia | Lee | 51105 | 7741 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-11 04:23:05 | Lee, Virginia, US | |
3100811 | 3100811 | 2022-10-09 | US | Virginia | Lee | 51105 | 7655 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-10 04:22:32 | Lee, Virginia, US | |
4006036 | 4006036 | 2022-10-08 | US | Virginia | Lee | 51105 | 7655 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-09 04:21:16 | Lee, Virginia, US | |
399633 | 399633 | 2022-10-07 | US | Virginia | Lee | 51105 | 7655 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-08 04:22:56 | Lee, Virginia, US | |
2532750 | 2532750 | 2022-10-06 | US | Virginia | Lee | 51105 | 7565 | 102 | 0 | 36.70586667 | -83.12606515 | 2022-10-07 04:23:08 | Lee, Virginia, US | |
1814144 | 1814144 | 2022-10-05 | US | Virginia | Lee | 51105 | 7461 | 102 | 0 | 36.70586667 | -83.12606515 | 2022-10-06 04:21:22 | Lee, Virginia, US | |
134118 | 134118 | 2022-10-04 | US | Virginia | Lee | 51105 | 7434 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-05 04:23:06 | Lee, Virginia, US | |
2689065 | 2689065 | 2022-10-03 | US | Virginia | Lee | 51105 | 7428 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-04 04:22:55 | Lee, Virginia, US | |
2263132 | 2263132 | 2022-10-02 | US | Virginia | Lee | 51105 | 7421 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-03 04:23:11 | Lee, Virginia, US | |
2998658 | 2998658 | 2022-10-01 | US | Virginia | Lee | 51105 | 7421 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-02 04:21:23 | Lee, Virginia, US | |
856984 | 856984 | 2022-09-30 | US | Virginia | Lee | 51105 | 7421 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-10-01 04:23:01 | Lee, Virginia, US | |
2378910 | 2378910 | 2022-09-29 | US | Virginia | Lee | 51105 | 7421 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-09-30 04:23:09 | Lee, Virginia, US | |
1563461 | 1563461 | 2022-09-28 | US | Virginia | Lee | 51105 | 7417 | 103 | 0 | 36.70586667 | -83.12606515 | 2022-09-29 04:22:34 | Lee, Virginia, US | |
3998004 | 3998004 | 2022-09-27 | US | Virginia | Lee | 51105 | 7413 | 102 | 0 | 36.70586667 | -83.12606515 | 2022-09-28 04:23:01 | Lee, Virginia, US | |
2772332 | 2772332 | 2022-09-26 | US | Virginia | Lee | 51105 | 7408 | 102 | 0 | 36.70586667 | -83.12606515 | 2022-09-27 04:23:01 | Lee, Virginia, US | |
1979985 | 1979985 | 2022-09-25 | US | Virginia | Lee | 51105 | 7403 | 101 | 0 | 36.70586667 | -83.12606515 | 2022-09-26 04:20:52 | Lee, Virginia, US | |
2653152 | 2653152 | 2022-09-24 | US | Virginia | Lee | 51105 | 7403 | 101 | 0 | 36.70586667 | -83.12606515 | 2022-09-25 04:23:31 | Lee, Virginia, US | |
387592 | 387592 | 2022-09-23 | US | Virginia | Lee | 51105 | 7403 | 101 | 0 | 36.70586667 | -83.12606515 | 2022-09-24 04:21:40 | Lee, Virginia, US | |
1627658 | 1627658 | 2022-09-22 | US | Virginia | Lee | 51105 | 7401 | 101 | 0 | 36.70586667 | -83.12606515 | 2022-09-23 04:23:13 | Lee, Virginia, US | |
1373862 | 1373862 | 2022-09-21 | US | Virginia | Lee | 51105 | 7394 | 101 | 0 | 36.70586667 | -83.12606515 | 2022-09-22 04:22:56 | Lee, 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]);