johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
584 rows where confirmed = 794 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954549 | 2954549 | 2022-12-20 | US | Texas | Lipscomb | 48295 | 794 | 17 | 0 | 36.27783108 | -100.2733151 | 2022-12-21 04:21:03 | Lipscomb, Texas, US | |
2952308 | 2952308 | 2022-12-20 | US | Idaho | Adams | 16003 | 794 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-12-21 04:21:03 | Adams, Idaho, US | |
3176951 | 3176951 | 2022-12-19 | US | Texas | Lipscomb | 48295 | 794 | 17 | 0 | 36.27783108 | -100.2733151 | 2022-12-20 04:21:04 | Lipscomb, Texas, US | |
3174710 | 3174710 | 2022-12-19 | US | Idaho | Adams | 16003 | 794 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-12-20 04:21:04 | Adams, Idaho, US | |
1631468 | 1631468 | 2022-12-18 | US | Texas | Lipscomb | 48295 | 794 | 17 | 0 | 36.27783108 | -100.2733151 | 2022-12-19 04:21:03 | Lipscomb, Texas, US | |
1629227 | 1629227 | 2022-12-18 | US | Idaho | Adams | 16003 | 794 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-12-19 04:21:03 | Adams, Idaho, US | |
506847 | 506847 | 2022-12-17 | US | Texas | Lipscomb | 48295 | 794 | 17 | 0 | 36.27783108 | -100.2733151 | 2022-12-18 04:21:03 | Lipscomb, Texas, US | |
504606 | 504606 | 2022-12-17 | US | Idaho | Adams | 16003 | 794 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-12-18 04:21:03 | Adams, Idaho, US | |
3327419 | 3327419 | 2022-12-16 | US | Texas | Lipscomb | 48295 | 794 | 17 | 0 | 36.27783108 | -100.2733151 | 2022-12-17 04:21:04 | Lipscomb, Texas, US | |
3325178 | 3325178 | 2022-12-16 | US | Idaho | Adams | 16003 | 794 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-12-17 04:21:04 | Adams, Idaho, US | |
545931 | 545931 | 2022-12-15 | US | Texas | Lipscomb | 48295 | 794 | 17 | 0 | 36.27783108 | -100.2733151 | 2022-12-16 04:21:01 | Lipscomb, Texas, US | |
543690 | 543690 | 2022-12-15 | US | Idaho | Adams | 16003 | 794 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-12-16 04:21:01 | Adams, Idaho, US | |
351459 | 351459 | 2022-12-14 | US | Texas | Lipscomb | 48295 | 794 | 17 | 0 | 36.27783108 | -100.2733151 | 2022-12-15 04:20:58 | Lipscomb, Texas, US | |
349218 | 349218 | 2022-12-14 | US | Idaho | Adams | 16003 | 794 | 16 | 0 | 44.89333571 | -116.4545247 | 2022-12-15 04:20:58 | Adams, Idaho, US | |
1050455 | 1050455 | 2022-11-06 | US | Colorado | Custer | 8027 | 794 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-11-07 04:21:26 | Custer, Colorado, US | |
618479 | 618479 | 2022-11-05 | US | Colorado | Custer | 8027 | 794 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-11-06 04:21:24 | Custer, Colorado, US | |
1022983 | 1022983 | 2022-11-04 | US | Colorado | Custer | 8027 | 794 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-11-05 04:21:52 | Custer, Colorado, US | |
431974 | 431974 | 2022-11-03 | US | Colorado | Custer | 8027 | 794 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-11-04 04:22:11 | Custer, Colorado, US | |
1830599 | 1830599 | 2022-10-25 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-26 04:22:19 | Wrangell, Alaska, US | |
796829 | 796829 | 2022-10-24 | US | North Dakota | McIntosh | 38051 | 794 | 9 | 0 | 46.11182017 | -99.44145858 | 2022-10-25 04:21:53 | McIntosh, North Dakota, US | |
794860 | 794860 | 2022-10-24 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-25 04:21:53 | Wrangell, Alaska, US | |
3277315 | 3277315 | 2022-10-23 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-24 04:22:29 | Wrangell, Alaska, US | |
2268353 | 2268353 | 2022-10-22 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-23 04:22:46 | Wrangell, Alaska, US | |
1592653 | 1592653 | 2022-10-21 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-22 04:22:53 | Wrangell, Alaska, US | |
2272369 | 2272369 | 2022-10-20 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-21 04:22:23 | Wrangell, Alaska, US | |
198704 | 198704 | 2022-10-19 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-20 04:22:59 | Wrangell, Alaska, US | |
2757365 | 2757365 | 2022-10-18 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-19 04:22:26 | Wrangell, Alaska, US | |
2025199 | 2025199 | 2022-10-17 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-18 04:22:42 | Wrangell, Alaska, US | |
2159977 | 2159977 | 2022-10-16 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-17 04:20:31 | Wrangell, Alaska, US | |
516174 | 516174 | 2022-10-15 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-16 04:22:39 | Wrangell, Alaska, US | |
2033231 | 2033231 | 2022-10-14 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-15 04:22:00 | Wrangell, Alaska, US | |
3753919 | 3753919 | 2022-10-13 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-14 04:22:28 | Wrangell, Alaska, US | |
3214744 | 3214744 | 2022-10-12 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-13 04:22:39 | Wrangell, Alaska, US | |
3250593 | 3250593 | 2022-10-11 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-12 04:22:51 | Wrangell, Alaska, US | |
2967852 | 2967852 | 2022-10-10 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-11 04:23:05 | Wrangell, Alaska, US | |
3097888 | 3097888 | 2022-10-09 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-10 04:22:32 | Wrangell, Alaska, US | |
4003113 | 4003113 | 2022-10-08 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-09 04:21:16 | Wrangell, Alaska, US | |
396710 | 396710 | 2022-10-07 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-08 04:22:56 | Wrangell, Alaska, US | |
2529827 | 2529827 | 2022-10-06 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-07 04:23:08 | Wrangell, Alaska, US | |
1811221 | 1811221 | 2022-10-05 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-06 04:21:22 | Wrangell, Alaska, US | |
133153 | 133153 | 2022-10-04 | US | North Dakota | Emmons | 38029 | 794 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-10-05 04:23:06 | Emmons, North Dakota, US | |
131195 | 131195 | 2022-10-04 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-05 04:23:06 | Wrangell, Alaska, US | |
2686142 | 2686142 | 2022-10-03 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-04 04:22:55 | Wrangell, Alaska, US | |
2260209 | 2260209 | 2022-10-02 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-03 04:23:11 | Wrangell, Alaska, US | |
2995735 | 2995735 | 2022-10-01 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-02 04:21:23 | Wrangell, Alaska, US | |
854061 | 854061 | 2022-09-30 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-10-01 04:23:01 | Wrangell, Alaska, US | |
2375987 | 2375987 | 2022-09-29 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-09-30 04:23:09 | Wrangell, Alaska, US | |
1560538 | 1560538 | 2022-09-28 | US | Alaska | Wrangell | 2275 | 794 | 1 | 0 | 56.3202004 | -132.0583731 | 2022-09-29 04:22:34 | Wrangell, Alaska, US | |
1890920 | 1890920 | 2022-09-14 | US | Minnesota | Unassigned | 90027 | 794 | 356 | 0 | 48.77754106 | 0.0 | 2022-09-15 04:21:02 | Unassigned, Minnesota, US | |
373975 | 373975 | 2022-09-13 | US | Minnesota | Unassigned | 90027 | 794 | 356 | 0 | 48.77754106 | 0.0 | 2022-09-14 04:20:44 | Unassigned, Minnesota, US | |
2396577 | 2396577 | 2022-09-12 | US | Minnesota | Unassigned | 90027 | 794 | 356 | 0 | 48.77754106 | 0.0 | 2022-09-13 04:20:57 | Unassigned, Minnesota, US | |
3767655 | 3767655 | 2022-09-11 | US | Minnesota | Unassigned | 90027 | 794 | 356 | 0 | 48.77754106 | 0.0 | 2022-09-12 04:20:58 | Unassigned, Minnesota, US | |
3826230 | 3826230 | 2022-09-10 | US | Minnesota | Unassigned | 90027 | 794 | 356 | 0 | 48.77754106 | 0.0 | 2022-09-11 04:20:50 | Unassigned, Minnesota, US | |
964687 | 964687 | 2022-09-09 | US | Minnesota | Unassigned | 90027 | 794 | 356 | 0 | 48.77754106 | 0.0 | 2022-09-10 04:21:10 | Unassigned, Minnesota, US | |
255089 | 255089 | 2022-09-08 | US | Minnesota | Unassigned | 90027 | 794 | 356 | 0 | 48.77754106 | 0.0 | 2022-09-09 04:21:11 | Unassigned, Minnesota, US | |
1163102 | 1163102 | 2022-08-18 | US | Missouri | Mercer | 29129 | 794 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-08-19 04:20:54 | Mercer, Missouri, US | |
3953640 | 3953640 | 2022-08-17 | US | Texas | Kinney | 48271 | 794 | 12 | 0 | 29.34967888 | -100.4186638 | 2022-08-18 04:21:11 | Kinney, Texas, US | |
3952426 | 3952426 | 2022-08-17 | US | Missouri | Mercer | 29129 | 794 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-08-18 04:21:11 | Mercer, Missouri, US | |
992928 | 992928 | 2022-08-16 | US | Missouri | Mercer | 29129 | 794 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-08-17 04:20:59 | Mercer, Missouri, US | |
2495967 | 2495967 | 2022-08-15 | US | Missouri | Mercer | 29129 | 794 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-08-16 04:20:58 | Mercer, Missouri, US | |
3649517 | 3649517 | 2022-08-14 | US | Missouri | Mercer | 29129 | 794 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-08-15 04:20:59 | Mercer, Missouri, US | |
1970523 | 1970523 | 2022-08-13 | US | Missouri | Mercer | 29129 | 794 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-08-14 04:20:55 | Mercer, Missouri, US | |
2890332 | 2890332 | 2022-08-12 | US | Missouri | Mercer | 29129 | 794 | 14 | 0 | 40.42212303 | -93.5682959 | 2022-08-13 04:20:52 | Mercer, Missouri, US | |
898547 | 898547 | 2022-07-24 | US | North Dakota | Eddy | 38027 | 794 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-07-25 04:20:51 | Eddy, North Dakota, US | |
1213970 | 1213970 | 2022-07-11 | US | North Dakota | Nelson | 38063 | 794 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-07-12 04:20:51 | Nelson, North Dakota, US | |
2791452 | 2791452 | 2022-07-10 | US | North Dakota | Nelson | 38063 | 794 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-07-11 04:20:46 | Nelson, North Dakota, US | |
144405 | 144405 | 2022-07-09 | US | North Dakota | Nelson | 38063 | 794 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-07-10 04:20:54 | Nelson, North Dakota, US | |
3967877 | 3967877 | 2022-07-05 | US | Kansas | Ness | 20135 | 794 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-07-06 04:20:58 | Ness, Kansas, US | |
3079388 | 3079388 | 2022-07-04 | US | Kansas | Ness | 20135 | 794 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-07-05 04:20:45 | Ness, Kansas, US | |
1768670 | 1768670 | 2022-07-03 | US | Kansas | Ness | 20135 | 794 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-07-04 04:20:54 | Ness, Kansas, US | |
3366656 | 3366656 | 2022-07-02 | US | Kansas | Ness | 20135 | 794 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-07-03 04:20:59 | Ness, Kansas, US | |
594985 | 594985 | 2022-07-01 | US | Kansas | Ness | 20135 | 794 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-07-02 04:21:16 | Ness, Kansas, US | |
3941386 | 3941386 | 2022-06-30 | US | Kansas | Ness | 20135 | 794 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-07-01 04:21:10 | Ness, Kansas, US | |
2491344 | 2491344 | 2022-06-29 | US | Kansas | Ness | 20135 | 794 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-06-30 04:21:01 | Ness, Kansas, US | |
2149746 | 2149746 | 2022-06-27 | US | Nebraska | Nance | 31125 | 794 | 12 | 0 | 41.39750195 | -97.99327291 | 2022-06-28 04:20:58 | Nance, Nebraska, US | |
477547 | 477547 | 2022-06-26 | US | Nebraska | Nance | 31125 | 794 | 12 | 0 | 41.39750195 | -97.99327291 | 2022-06-27 04:21:00 | Nance, Nebraska, US | |
940922 | 940922 | 2022-06-25 | US | Nebraska | Nance | 31125 | 794 | 12 | 0 | 41.39750195 | -97.99327291 | 2022-06-26 04:21:02 | Nance, Nebraska, US | |
167348 | 167348 | 2022-06-21 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-22 04:20:54 | Jewell, Kansas, US | |
1764631 | 1764631 | 2022-06-20 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-21 04:20:56 | Jewell, Kansas, US | |
3270817 | 3270817 | 2022-06-19 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-20 04:21:01 | Jewell, Kansas, US | |
3398729 | 3398729 | 2022-06-18 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-19 04:20:51 | Jewell, Kansas, US | |
2312606 | 2312606 | 2022-06-17 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-18 04:21:10 | Jewell, Kansas, US | |
560110 | 560110 | 2022-06-16 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-17 04:20:56 | Jewell, Kansas, US | |
3983912 | 3983912 | 2022-06-15 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-16 04:20:55 | Jewell, Kansas, US | |
948153 | 948153 | 2022-06-14 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-15 04:20:54 | Jewell, Kansas, US | |
2980561 | 2980561 | 2022-06-13 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-14 04:20:52 | Jewell, Kansas, US | |
2236687 | 2236687 | 2022-06-12 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-13 04:21:14 | Jewell, Kansas, US | |
3142885 | 3142885 | 2022-06-11 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-12 04:20:53 | Jewell, Kansas, US | |
1945801 | 1945801 | 2022-06-10 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-11 04:21:01 | Jewell, Kansas, US | |
3158940 | 3158940 | 2022-06-09 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-10 04:20:55 | Jewell, Kansas, US | |
1422407 | 1422407 | 2022-06-08 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-09 04:20:54 | Jewell, Kansas, US | |
3727521 | 3727521 | 2022-06-07 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-08 04:20:55 | Jewell, Kansas, US | |
3888923 | 3888923 | 2022-06-06 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-07 04:21:08 | Jewell, Kansas, US | |
3508692 | 3508692 | 2022-06-05 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-06 04:20:57 | Jewell, Kansas, US | |
3528769 | 3528769 | 2022-06-04 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-05 04:20:55 | Jewell, Kansas, US | |
3134855 | 3134855 | 2022-06-03 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-04 04:20:58 | Jewell, Kansas, US | |
3579930 | 3579930 | 2022-06-02 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-03 04:20:58 | Jewell, Kansas, US | |
972223 | 972223 | 2022-06-01 | US | Kansas | Jewell | 20089 | 794 | 15 | 0 | 39.78470589 | -98.21820662 | 2022-06-02 05:20:39 | Jewell, Kansas, US | |
3189160 | 3189160 | 2022-05-30 | US | Texas | Mason | 48319 | 794 | 12 | 0 | 30.71780434 | -99.22629416 | 2022-05-31 04:20:51 | Mason, Texas, US | |
3201309 | 3201309 | 2022-05-29 | US | Texas | Mason | 48319 | 794 | 12 | 0 | 30.71780434 | -99.22629416 | 2022-05-30 04:20:50 | Mason, Texas, 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]);