johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
397 rows where deaths = 681 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755535 | 2755535 | 2022-12-29 | US | Oregon | Lane | 41039 | 77225 | 681 | 0 | 43.93727035 | -122.847753 | 2022-12-30 04:21:04 | Lane, Oregon, US | |
2753641 | 2753641 | 2022-12-29 | US | Florida | Santa Rosa | 12113 | 57468 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-30 04:21:04 | Santa Rosa, Florida, US | |
1076541 | 1076541 | 2022-12-28 | US | Oregon | Lane | 41039 | 77225 | 681 | 0 | 43.93727035 | -122.847753 | 2022-12-29 04:21:01 | Lane, Oregon, US | |
1074647 | 1074647 | 2022-12-28 | US | Florida | Santa Rosa | 12113 | 57468 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-29 04:21:01 | Santa Rosa, Florida, US | |
1073916 | 1073916 | 2022-12-28 | Japan | Mie | 362466 | 681 | 0 | 34.508018 | 136.376013 | 2022-12-29 04:21:01 | Mie, Japan | |||
328644 | 328644 | 2022-12-27 | US | Florida | Santa Rosa | 12113 | 57468 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-28 04:21:04 | Santa Rosa, Florida, US | |
218717 | 218717 | 2022-12-26 | US | Florida | Santa Rosa | 12113 | 57468 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-27 04:21:07 | Santa Rosa, Florida, US | |
3223174 | 3223174 | 2022-12-25 | US | Florida | Santa Rosa | 12113 | 57468 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-26 04:21:06 | Santa Rosa, Florida, US | |
1019088 | 1019088 | 2022-12-24 | US | Florida | Santa Rosa | 12113 | 57468 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-25 04:21:04 | Santa Rosa, Florida, US | |
691111 | 691111 | 2022-12-23 | US | Florida | Santa Rosa | 12113 | 57468 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-24 04:21:02 | Santa Rosa, Florida, US | |
2180321 | 2180321 | 2022-12-22 | US | Florida | Santa Rosa | 12113 | 57468 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-23 04:21:04 | Santa Rosa, Florida, US | |
452125 | 452125 | 2022-12-21 | US | Florida | Santa Rosa | 12113 | 57468 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-22 04:20:56 | Santa Rosa, Florida, US | |
2952124 | 2952124 | 2022-12-20 | US | Florida | Santa Rosa | 12113 | 57468 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-21 04:21:03 | Santa Rosa, Florida, US | |
3174526 | 3174526 | 2022-12-19 | US | Florida | Santa Rosa | 12113 | 57468 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-20 04:21:04 | Santa Rosa, Florida, US | |
1629043 | 1629043 | 2022-12-18 | US | Florida | Santa Rosa | 12113 | 57468 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-19 04:21:03 | Santa Rosa, Florida, US | |
504422 | 504422 | 2022-12-17 | US | Florida | Santa Rosa | 12113 | 57468 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-18 04:21:03 | Santa Rosa, Florida, US | |
3324994 | 3324994 | 2022-12-16 | US | Florida | Santa Rosa | 12113 | 57468 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-17 04:21:04 | Santa Rosa, Florida, US | |
543506 | 543506 | 2022-12-15 | US | Florida | Santa Rosa | 12113 | 57172 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-16 04:21:01 | Santa Rosa, Florida, US | |
542762 | 542762 | 2022-12-15 | Japan | Gunma | 334853 | 681 | 0 | 36.504479 | 138.985605 | 2022-12-16 04:21:01 | Gunma, Japan | |||
349034 | 349034 | 2022-12-14 | US | Florida | Santa Rosa | 12113 | 57172 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-15 04:20:58 | Santa Rosa, Florida, US | |
308622 | 308622 | 2022-12-13 | US | Florida | Santa Rosa | 12113 | 57172 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-14 04:21:04 | Santa Rosa, Florida, US | |
1149683 | 1149683 | 2022-12-12 | US | Florida | Santa Rosa | 12113 | 57172 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-13 04:21:01 | Santa Rosa, Florida, US | |
869537 | 869537 | 2022-12-11 | US | Florida | Santa Rosa | 12113 | 57172 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-12 04:21:01 | Santa Rosa, Florida, US | |
258067 | 258067 | 2022-12-10 | US | Florida | Santa Rosa | 12113 | 57172 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-11 04:20:50 | Santa Rosa, Florida, US | |
3936781 | 3936781 | 2022-12-09 | US | Florida | Santa Rosa | 12113 | 57172 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-10 04:21:02 | Santa Rosa, Florida, US | |
3378113 | 3378113 | 2022-12-08 | US | Florida | Santa Rosa | 12113 | 57172 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-09 04:21:05 | Santa Rosa, Florida, US | |
1985384 | 1985384 | 2022-12-07 | US | Florida | Santa Rosa | 12113 | 57172 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-08 04:21:07 | Santa Rosa, Florida, US | |
3714907 | 3714907 | 2022-12-06 | US | Florida | Santa Rosa | 12113 | 57172 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-07 04:20:58 | Santa Rosa, Florida, US | |
2415612 | 2415612 | 2022-12-05 | US | Florida | Santa Rosa | 12113 | 57172 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-06 04:21:03 | Santa Rosa, Florida, US | |
719220 | 719220 | 2022-12-04 | US | Florida | Santa Rosa | 12113 | 57172 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-05 04:20:58 | Santa Rosa, Florida, US | |
2817509 | 2817509 | 2022-12-03 | US | Florida | Santa Rosa | 12113 | 57172 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-04 04:20:56 | Santa Rosa, Florida, US | |
834365 | 834365 | 2022-12-02 | US | Florida | Santa Rosa | 12113 | 57172 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-03 04:21:02 | Santa Rosa, Florida, US | |
2136895 | 2136895 | 2022-12-01 | US | Florida | Santa Rosa | 12113 | 56967 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-02 04:21:07 | Santa Rosa, Florida, US | |
1968133 | 1968133 | 2022-11-30 | US | Wisconsin | Kenosha | 55059 | 53790 | 681 | 0 | 42.57639354 | -88.04051686 | 2022-12-01 04:21:03 | Kenosha, Wisconsin, US | |
1965311 | 1965311 | 2022-11-30 | US | Florida | Santa Rosa | 12113 | 56967 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-12-01 04:21:03 | Santa Rosa, Florida, US | |
2557325 | 2557325 | 2022-11-29 | US | Florida | Santa Rosa | 12113 | 56967 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-11-30 04:21:07 | Santa Rosa, Florida, US | |
1240399 | 1240399 | 2022-11-28 | US | Florida | Santa Rosa | 12113 | 56967 | 681 | 0 | 30.6934145 | -87.02458128 | 2022-11-29 04:21:05 | Santa Rosa, Florida, US | |
1641749 | 1641749 | 2022-11-20 | US | Kentucky | Fayette | 21067 | 115874 | 681 | 0 | 38.0368225 | -84.45576892 | 2022-11-21 04:21:05 | Fayette, Kentucky, US | |
2065306 | 2065306 | 2022-11-19 | US | Kentucky | Fayette | 21067 | 115874 | 681 | 0 | 38.0368225 | -84.45576892 | 2022-11-20 04:21:08 | Fayette, Kentucky, US | |
1756700 | 1756700 | 2022-11-18 | US | Kentucky | Fayette | 21067 | 115874 | 681 | 0 | 38.0368225 | -84.45576892 | 2022-11-19 04:21:14 | Fayette, Kentucky, US | |
3027693 | 3027693 | 2022-11-17 | US | Kentucky | Fayette | 21067 | 115874 | 681 | 0 | 38.0368225 | -84.45576892 | 2022-11-18 04:21:15 | Fayette, Kentucky, US | |
2487404 | 2487404 | 2022-11-16 | US | Kentucky | Fayette | 21067 | 115874 | 681 | 0 | 38.0368225 | -84.45576892 | 2022-11-17 04:21:11 | Fayette, Kentucky, US | |
293415 | 293415 | 2022-11-15 | US | Kentucky | Fayette | 21067 | 115874 | 681 | 0 | 38.0368225 | -84.45576892 | 2022-11-16 04:21:09 | Fayette, Kentucky, US | |
3598445 | 3598445 | 2022-11-14 | US | Kentucky | Fayette | 21067 | 115874 | 681 | 0 | 38.0368225 | -84.45576892 | 2022-11-15 04:21:16 | Fayette, Kentucky, US | |
2431310 | 2431310 | 2022-11-09 | US | Alabama | Etowah | 1055 | 32489 | 681 | 0 | 34.04567266 | -86.04051873 | 2022-11-10 04:21:16 | Etowah, Alabama, US | |
479966 | 479966 | 2022-11-08 | US | Alabama | Etowah | 1055 | 32489 | 681 | 0 | 34.04567266 | -86.04051873 | 2022-11-09 04:21:22 | Etowah, Alabama, US | |
2439116 | 2439116 | 2022-11-07 | US | Alabama | Etowah | 1055 | 32489 | 681 | 0 | 34.04567266 | -86.04051873 | 2022-11-08 04:21:21 | Etowah, Alabama, US | |
1050214 | 1050214 | 2022-11-06 | US | Alabama | Etowah | 1055 | 32489 | 681 | 0 | 34.04567266 | -86.04051873 | 2022-11-07 04:21:26 | Etowah, Alabama, US | |
618238 | 618238 | 2022-11-05 | US | Alabama | Etowah | 1055 | 32489 | 681 | 0 | 34.04567266 | -86.04051873 | 2022-11-06 04:21:24 | Etowah, Alabama, US | |
1022742 | 1022742 | 2022-11-04 | US | Alabama | Etowah | 1055 | 32489 | 681 | 0 | 34.04567266 | -86.04051873 | 2022-11-05 04:21:52 | Etowah, Alabama, US | |
431733 | 431733 | 2022-11-03 | US | Alabama | Etowah | 1055 | 32489 | 681 | 0 | 34.04567266 | -86.04051873 | 2022-11-04 04:22:11 | Etowah, Alabama, US | |
849975 | 849975 | 2022-11-02 | US | Alabama | Etowah | 1055 | 32489 | 681 | 0 | 34.04567266 | -86.04051873 | 2022-11-03 04:22:05 | Etowah, Alabama, US | |
710826 | 710826 | 2022-11-01 | US | Alabama | Etowah | 1055 | 32489 | 681 | 0 | 34.04567266 | -86.04051873 | 2022-11-02 04:22:09 | Etowah, Alabama, US | |
3285275 | 3285275 | 2022-10-31 | US | Alabama | Etowah | 1055 | 32489 | 681 | 0 | 34.04567266 | -86.04051873 | 2022-11-01 04:22:36 | Etowah, Alabama, US | |
320308 | 320308 | 2022-10-30 | US | Alabama | Etowah | 1055 | 32489 | 681 | 0 | 34.04567266 | -86.04051873 | 2022-10-31 04:21:36 | Etowah, Alabama, US | |
912584 | 912584 | 2022-10-29 | US | Alabama | Etowah | 1055 | 32489 | 681 | 0 | 34.04567266 | -86.04051873 | 2022-10-30 04:22:14 | Etowah, Alabama, US | |
1366853 | 1366853 | 2022-10-28 | US | Alabama | Etowah | 1055 | 32489 | 681 | 0 | 34.04567266 | -86.04051873 | 2022-10-29 04:21:13 | Etowah, Alabama, US | |
3038708 | 3038708 | 2022-10-27 | US | Alabama | Etowah | 1055 | 32489 | 681 | 0 | 34.04567266 | -86.04051873 | 2022-10-28 04:22:31 | Etowah, Alabama, US | |
515497 | 515497 | 2022-10-15 | Chile | Atacama | 102368 | 681 | 0 | -27.5661 | -70.0503 | 2022-10-16 04:22:39 | Atacama, Chile | |||
2032554 | 2032554 | 2022-10-14 | Chile | Atacama | 102281 | 681 | 0 | -27.5661 | -70.0503 | 2022-10-15 04:22:00 | Atacama, Chile | |||
3753446 | 3753446 | 2022-10-13 | Italy | Molise | 92010 | 681 | 0 | 41.55774754 | 14.65916051 | 2022-10-14 04:22:28 | Molise, Italy | |||
3753242 | 3753242 | 2022-10-13 | Chile | Atacama | 102179 | 681 | 0 | -27.5661 | -70.0503 | 2022-10-14 04:22:28 | Atacama, Chile | |||
3214271 | 3214271 | 2022-10-12 | Italy | Molise | 91864 | 681 | 0 | 41.55774754 | 14.65916051 | 2022-10-13 04:22:39 | Molise, Italy | |||
3214067 | 3214067 | 2022-10-12 | Chile | Atacama | 102067 | 681 | 0 | -27.5661 | -70.0503 | 2022-10-13 04:22:39 | Atacama, Chile | |||
3250120 | 3250120 | 2022-10-11 | Italy | Molise | 91703 | 681 | 0 | 41.55774754 | 14.65916051 | 2022-10-12 04:22:51 | Molise, Italy | |||
3249916 | 3249916 | 2022-10-11 | Chile | Atacama | 102004 | 681 | 0 | -27.5661 | -70.0503 | 2022-10-12 04:22:51 | Atacama, Chile | |||
2967379 | 2967379 | 2022-10-10 | Italy | Molise | 91536 | 681 | 0 | 41.55774754 | 14.65916051 | 2022-10-11 04:23:05 | Molise, Italy | |||
2967175 | 2967175 | 2022-10-10 | Chile | Atacama | 101957 | 681 | 0 | -27.5661 | -70.0503 | 2022-10-11 04:23:05 | Atacama, Chile | |||
3097415 | 3097415 | 2022-10-09 | Italy | Molise | 91456 | 681 | 0 | 41.55774754 | 14.65916051 | 2022-10-10 04:22:32 | Molise, Italy | |||
255231 | 255231 | 2022-09-08 | US | Missouri | Jefferson | 29099 | 61779 | 681 | 0 | 38.25926778 | -90.53870896 | 2022-09-09 04:21:11 | Jefferson, Missouri, US | |
253498 | 253498 | 2022-09-08 | Qatar | 434153 | 681 | 0 | 25.3548 | 51.1839 | 2022-09-09 04:21:11 | Qatar | ||||
3747029 | 3747029 | 2022-09-07 | US | Missouri | Jefferson | 29099 | 61779 | 681 | 0 | 38.25926778 | -90.53870896 | 2022-09-08 04:21:02 | Jefferson, Missouri, US | |
3745296 | 3745296 | 2022-09-07 | Qatar | 433531 | 681 | 0 | 25.3548 | 51.1839 | 2022-09-08 04:21:02 | Qatar | ||||
116669 | 116669 | 2022-09-06 | US | Missouri | Jefferson | 29099 | 61779 | 681 | 0 | 38.25926778 | -90.53870896 | 2022-09-07 04:20:59 | Jefferson, Missouri, US | |
114936 | 114936 | 2022-09-06 | Qatar | 432846 | 681 | 0 | 25.3548 | 51.1839 | 2022-09-07 04:20:59 | Qatar | ||||
2635641 | 2635641 | 2022-09-05 | US | Missouri | Jefferson | 29099 | 61779 | 681 | 0 | 38.25926778 | -90.53870896 | 2022-09-06 04:21:02 | Jefferson, Missouri, US | |
2633908 | 2633908 | 2022-09-05 | Qatar | 432202 | 681 | 0 | 25.3548 | 51.1839 | 2022-09-06 04:21:02 | Qatar | ||||
2989205 | 2989205 | 2022-09-04 | US | Missouri | Jefferson | 29099 | 61779 | 681 | 0 | 38.25926778 | -90.53870896 | 2022-09-05 04:21:01 | Jefferson, Missouri, US | |
2987472 | 2987472 | 2022-09-04 | Qatar | 431519 | 681 | 0 | 25.3548 | 51.1839 | 2022-09-05 04:21:01 | Qatar | ||||
2987310 | 2987310 | 2022-09-04 | Japan | Shizuoka | 440994 | 681 | 0 | 34.916975 | 138.407784 | 2022-09-05 04:21:01 | Shizuoka, Japan | |||
2714890 | 2714890 | 2022-09-03 | US | Missouri | Jefferson | 29099 | 61779 | 681 | 0 | 38.25926778 | -90.53870896 | 2022-09-04 04:21:22 | Jefferson, Missouri, US | |
2713157 | 2713157 | 2022-09-03 | Qatar | 430945 | 681 | 0 | 25.3548 | 51.1839 | 2022-09-04 04:21:22 | Qatar | ||||
1395595 | 1395595 | 2022-09-02 | US | Missouri | Jefferson | 29099 | 61779 | 681 | 0 | 38.25926778 | -90.53870896 | 2022-09-03 04:21:04 | Jefferson, Missouri, US | |
1393862 | 1393862 | 2022-09-02 | Qatar | 430484 | 681 | 0 | 25.3548 | 51.1839 | 2022-09-03 04:21:04 | Qatar | ||||
3547691 | 3547691 | 2022-09-01 | Qatar | 429963 | 681 | 0 | 25.3548 | 51.1839 | 2022-09-02 04:21:07 | Qatar | ||||
2343611 | 2343611 | 2022-08-31 | Qatar | 429396 | 681 | 0 | 25.3548 | 51.1839 | 2022-09-01 04:21:03 | Qatar | ||||
3774091 | 3774091 | 2022-08-30 | Qatar | 428791 | 681 | 0 | 25.3548 | 51.1839 | 2022-08-31 04:20:57 | Qatar | ||||
1680687 | 1680687 | 2022-08-29 | Qatar | 428147 | 681 | 0 | 25.3548 | 51.1839 | 2022-08-30 04:21:03 | Qatar | ||||
1877171 | 1877171 | 2022-08-28 | Qatar | 427563 | 681 | 0 | 25.3548 | 51.1839 | 2022-08-29 04:21:06 | Qatar | ||||
2096298 | 2096298 | 2022-08-27 | Qatar | 427001 | 681 | 0 | 25.3548 | 51.1839 | 2022-08-28 04:21:02 | Qatar | ||||
1532113 | 1532113 | 2022-08-26 | Qatar | 426586 | 681 | 0 | 25.3548 | 51.1839 | 2022-08-27 04:20:57 | Qatar | ||||
2829000 | 2829000 | 2022-08-25 | Qatar | 426083 | 681 | 0 | 25.3548 | 51.1839 | 2022-08-26 04:21:02 | Qatar | ||||
2323533 | 2323533 | 2022-08-24 | Qatar | 425582 | 681 | 0 | 25.3548 | 51.1839 | 2022-08-25 04:21:13 | Qatar | ||||
1250942 | 1250942 | 2022-08-23 | Qatar | 424999 | 681 | 0 | 25.3548 | 51.1839 | 2022-08-24 04:20:46 | Qatar | ||||
2855505 | 2855505 | 2022-08-22 | US | Oregon | Washington | 41067 | 110667 | 681 | 0 | 45.55972701 | -123.0955257 | 2022-08-23 04:20:56 | Washington, Oregon, US | |
2853046 | 2853046 | 2022-08-22 | Qatar | 424419 | 681 | 0 | 25.3548 | 51.1839 | 2022-08-23 04:20:56 | Qatar | ||||
2405477 | 2405477 | 2022-08-21 | US | Oregon | Washington | 41067 | 110459 | 681 | 0 | 45.55972701 | -123.0955257 | 2022-08-22 04:20:38 | Washington, Oregon, US | |
2403018 | 2403018 | 2022-08-21 | Qatar | 423772 | 681 | 0 | 25.3548 | 51.1839 | 2022-08-22 04:20:38 | Qatar | ||||
3800555 | 3800555 | 2022-08-20 | US | Oregon | Washington | 41067 | 110459 | 681 | 0 | 45.55972701 | -123.0955257 | 2022-08-21 04:20:44 | Washington, Oregon, US | |
3798096 | 3798096 | 2022-08-20 | Qatar | 423118 | 681 | 0 | 25.3548 | 51.1839 | 2022-08-21 04:20:44 | Qatar |
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]);