johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
386 rows where deaths = 692 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3177348 | 3177348 | 2022-12-19 | US | Wisconsin | Kenosha | 55059 | 54638 | 692 | 0 | 42.57639354 | -88.04051686 | 2022-12-20 04:21:04 | Kenosha, Wisconsin, US | |
348065 | 348065 | 2022-12-14 | Chile | Atacama | 109301 | 692 | 0 | -27.5661 | -70.0503 | 2022-12-15 04:20:58 | Atacama, Chile | |||
307653 | 307653 | 2022-12-13 | Chile | Atacama | 109161 | 692 | 0 | -27.5661 | -70.0503 | 2022-12-14 04:21:04 | Atacama, Chile | |||
1148714 | 1148714 | 2022-12-12 | Chile | Atacama | 109092 | 692 | 0 | -27.5661 | -70.0503 | 2022-12-13 04:21:01 | Atacama, Chile | |||
1986246 | 1986246 | 2022-12-07 | US | Massachusetts | Barnstable | 25001 | 46309 | 692 | 0 | 41.72980578 | -70.28854339 | 2022-12-08 04:21:07 | Barnstable, Massachusetts, US | |
3715769 | 3715769 | 2022-12-06 | US | Massachusetts | Barnstable | 25001 | 46309 | 692 | 0 | 41.72980578 | -70.28854339 | 2022-12-07 04:20:58 | Barnstable, Massachusetts, US | |
2416474 | 2416474 | 2022-12-05 | US | Massachusetts | Barnstable | 25001 | 46309 | 692 | 0 | 41.72980578 | -70.28854339 | 2022-12-06 04:21:03 | Barnstable, Massachusetts, US | |
720082 | 720082 | 2022-12-04 | US | Massachusetts | Barnstable | 25001 | 46309 | 692 | 0 | 41.72980578 | -70.28854339 | 2022-12-05 04:20:58 | Barnstable, Massachusetts, US | |
2818371 | 2818371 | 2022-12-03 | US | Massachusetts | Barnstable | 25001 | 46309 | 692 | 0 | 41.72980578 | -70.28854339 | 2022-12-04 04:20:56 | Barnstable, Massachusetts, US | |
835227 | 835227 | 2022-12-02 | US | Massachusetts | Barnstable | 25001 | 46309 | 692 | 0 | 41.72980578 | -70.28854339 | 2022-12-03 04:21:02 | Barnstable, Massachusetts, US | |
2137757 | 2137757 | 2022-12-01 | US | Massachusetts | Barnstable | 25001 | 46309 | 692 | 0 | 41.72980578 | -70.28854339 | 2022-12-02 04:21:07 | Barnstable, Massachusetts, US | |
2556592 | 2556592 | 2022-11-29 | Japan | Kumamoto | 367790 | 692 | 0 | 32.608154 | 130.745231 | 2022-11-30 04:21:07 | Kumamoto, Japan | |||
3523422 | 3523422 | 2022-11-24 | Italy | Molise | 95164 | 692 | 0 | 41.55774754 | 14.65916051 | 2022-11-25 04:21:06 | Molise, Italy | |||
3312205 | 3312205 | 2022-11-23 | Italy | Molise | 95164 | 692 | 0 | 41.55774754 | 14.65916051 | 2022-11-24 04:21:09 | Molise, Italy | |||
1620246 | 1620246 | 2022-11-22 | Italy | Molise | 95164 | 692 | 0 | 41.55774754 | 14.65916051 | 2022-11-23 04:21:06 | Molise, Italy | |||
3460134 | 3460134 | 2022-11-21 | Italy | Molise | 95164 | 692 | 0 | 41.55774754 | 14.65916051 | 2022-11-22 04:20:47 | Molise, Italy | |||
1640319 | 1640319 | 2022-11-20 | Italy | Molise | 95164 | 692 | 0 | 41.55774754 | 14.65916051 | 2022-11-21 04:21:05 | Molise, Italy | |||
2063876 | 2063876 | 2022-11-19 | Italy | Molise | 95164 | 692 | 0 | 41.55774754 | 14.65916051 | 2022-11-20 04:21:08 | Molise, Italy | |||
1755270 | 1755270 | 2022-11-18 | Italy | Molise | 95164 | 692 | 0 | 41.55774754 | 14.65916051 | 2022-11-19 04:21:14 | Molise, Italy | |||
482303 | 482303 | 2022-11-08 | US | Pennsylvania | Washington | 42125 | 61033 | 692 | 0 | 40.19208869 | -80.24582867 | 2022-11-09 04:21:22 | Washington, Pennsylvania, US | |
2441453 | 2441453 | 2022-11-07 | US | Pennsylvania | Washington | 42125 | 61033 | 692 | 0 | 40.19208869 | -80.24582867 | 2022-11-08 04:21:21 | Washington, Pennsylvania, US | |
1052551 | 1052551 | 2022-11-06 | US | Pennsylvania | Washington | 42125 | 61033 | 692 | 0 | 40.19208869 | -80.24582867 | 2022-11-07 04:21:26 | Washington, Pennsylvania, US | |
620575 | 620575 | 2022-11-05 | US | Pennsylvania | Washington | 42125 | 61033 | 692 | 0 | 40.19208869 | -80.24582867 | 2022-11-06 04:21:24 | Washington, Pennsylvania, US | |
1025079 | 1025079 | 2022-11-04 | US | Pennsylvania | Washington | 42125 | 61033 | 692 | 0 | 40.19208869 | -80.24582867 | 2022-11-05 04:21:52 | Washington, Pennsylvania, US | |
434070 | 434070 | 2022-11-03 | US | Pennsylvania | Washington | 42125 | 61033 | 692 | 0 | 40.19208869 | -80.24582867 | 2022-11-04 04:22:11 | Washington, Pennsylvania, US | |
852312 | 852312 | 2022-11-02 | US | Pennsylvania | Washington | 42125 | 61033 | 692 | 0 | 40.19208869 | -80.24582867 | 2022-11-03 04:22:05 | Washington, Pennsylvania, US | |
713163 | 713163 | 2022-11-01 | US | Pennsylvania | Washington | 42125 | 60777 | 692 | 0 | 40.19208869 | -80.24582867 | 2022-11-02 04:22:09 | Washington, Pennsylvania, US | |
3287612 | 3287612 | 2022-10-31 | US | Pennsylvania | Washington | 42125 | 60777 | 692 | 0 | 40.19208869 | -80.24582867 | 2022-11-01 04:22:36 | Washington, Pennsylvania, US | |
322645 | 322645 | 2022-10-30 | US | Pennsylvania | Washington | 42125 | 60777 | 692 | 0 | 40.19208869 | -80.24582867 | 2022-10-31 04:21:36 | Washington, Pennsylvania, US | |
914921 | 914921 | 2022-10-29 | US | Pennsylvania | Washington | 42125 | 60777 | 692 | 0 | 40.19208869 | -80.24582867 | 2022-10-30 04:22:14 | Washington, Pennsylvania, US | |
1369190 | 1369190 | 2022-10-28 | US | Pennsylvania | Washington | 42125 | 60777 | 692 | 0 | 40.19208869 | -80.24582867 | 2022-10-29 04:21:13 | Washington, Pennsylvania, US | |
3041045 | 3041045 | 2022-10-27 | US | Pennsylvania | Washington | 42125 | 60777 | 692 | 0 | 40.19208869 | -80.24582867 | 2022-10-28 04:22:31 | Washington, Pennsylvania, US | |
541465 | 541465 | 2022-10-26 | US | Pennsylvania | Washington | 42125 | 60777 | 692 | 0 | 40.19208869 | -80.24582867 | 2022-10-27 04:22:01 | Washington, Pennsylvania, US | |
2531302 | 2531302 | 2022-10-06 | US | Missouri | Jefferson | 29099 | 63078 | 692 | 0 | 38.25926778 | -90.53870896 | 2022-10-07 04:23:08 | Jefferson, Missouri, US | |
1812696 | 1812696 | 2022-10-05 | US | Missouri | Jefferson | 29099 | 63078 | 692 | 0 | 38.25926778 | -90.53870896 | 2022-10-06 04:21:22 | Jefferson, Missouri, US | |
132670 | 132670 | 2022-10-04 | US | Missouri | Jefferson | 29099 | 63078 | 692 | 0 | 38.25926778 | -90.53870896 | 2022-10-05 04:23:06 | Jefferson, Missouri, US | |
2687617 | 2687617 | 2022-10-03 | US | Missouri | Jefferson | 29099 | 63078 | 692 | 0 | 38.25926778 | -90.53870896 | 2022-10-04 04:22:55 | Jefferson, Missouri, US | |
2261684 | 2261684 | 2022-10-02 | US | Missouri | Jefferson | 29099 | 63078 | 692 | 0 | 38.25926778 | -90.53870896 | 2022-10-03 04:23:11 | Jefferson, Missouri, US | |
2997210 | 2997210 | 2022-10-01 | US | Missouri | Jefferson | 29099 | 63078 | 692 | 0 | 38.25926778 | -90.53870896 | 2022-10-02 04:21:23 | Jefferson, Missouri, US | |
855536 | 855536 | 2022-09-30 | US | Missouri | Jefferson | 29099 | 63078 | 692 | 0 | 38.25926778 | -90.53870896 | 2022-10-01 04:23:01 | Jefferson, Missouri, US | |
3996447 | 3996447 | 2022-09-27 | US | Mississippi | Harrison | 28047 | 62399 | 692 | 0 | 30.51359752 | -89.12467576 | 2022-09-28 04:23:01 | Harrison, Mississippi, US | |
3995733 | 3995733 | 2022-09-27 | US | Indiana | Hamilton | 18057 | 91982 | 692 | 0 | 40.07306535 | -86.05244729 | 2022-09-28 04:23:01 | Hamilton, Indiana, US | |
2770775 | 2770775 | 2022-09-26 | US | Mississippi | Harrison | 28047 | 62399 | 692 | 0 | 30.51359752 | -89.12467576 | 2022-09-27 04:23:01 | Harrison, Mississippi, US | |
2770061 | 2770061 | 2022-09-26 | US | Indiana | Hamilton | 18057 | 91982 | 692 | 0 | 40.07306535 | -86.05244729 | 2022-09-27 04:23:01 | Hamilton, Indiana, US | |
1978428 | 1978428 | 2022-09-25 | US | Mississippi | Harrison | 28047 | 62399 | 692 | 0 | 30.51359752 | -89.12467576 | 2022-09-26 04:20:52 | Harrison, Mississippi, US | |
1977714 | 1977714 | 2022-09-25 | US | Indiana | Hamilton | 18057 | 91936 | 692 | 0 | 40.07306535 | -86.05244729 | 2022-09-26 04:20:52 | Hamilton, Indiana, US | |
2651595 | 2651595 | 2022-09-24 | US | Mississippi | Harrison | 28047 | 62399 | 692 | 0 | 30.51359752 | -89.12467576 | 2022-09-25 04:23:31 | Harrison, Mississippi, US | |
2650881 | 2650881 | 2022-09-24 | US | Indiana | Hamilton | 18057 | 91936 | 692 | 0 | 40.07306535 | -86.05244729 | 2022-09-25 04:23:31 | Hamilton, Indiana, US | |
386035 | 386035 | 2022-09-23 | US | Mississippi | Harrison | 28047 | 62399 | 692 | 0 | 30.51359752 | -89.12467576 | 2022-09-24 04:21:40 | Harrison, Mississippi, US | |
385321 | 385321 | 2022-09-23 | US | Indiana | Hamilton | 18057 | 91936 | 692 | 0 | 40.07306535 | -86.05244729 | 2022-09-24 04:21:40 | Hamilton, Indiana, US | |
1626101 | 1626101 | 2022-09-22 | US | Mississippi | Harrison | 28047 | 62399 | 692 | 0 | 30.51359752 | -89.12467576 | 2022-09-23 04:23:13 | Harrison, Mississippi, US | |
1625387 | 1625387 | 2022-09-22 | US | Indiana | Hamilton | 18057 | 91903 | 692 | 0 | 40.07306535 | -86.05244729 | 2022-09-23 04:23:13 | Hamilton, Indiana, US | |
1624967 | 1624967 | 2022-09-22 | US | Delaware | Kent | 10001 | 59609 | 692 | 0 | 39.08646628 | -75.56884914 | 2022-09-23 04:23:13 | Kent, Delaware, US | |
1372305 | 1372305 | 2022-09-21 | US | Mississippi | Harrison | 28047 | 62399 | 692 | 0 | 30.51359752 | -89.12467576 | 2022-09-22 04:22:56 | Harrison, Mississippi, US | |
1371591 | 1371591 | 2022-09-21 | US | Indiana | Hamilton | 18057 | 91903 | 692 | 0 | 40.07306535 | -86.05244729 | 2022-09-22 04:22:56 | Hamilton, Indiana, US | |
1371171 | 1371171 | 2022-09-21 | US | Delaware | Kent | 10001 | 59553 | 692 | 0 | 39.08646628 | -75.56884914 | 2022-09-22 04:22:56 | Kent, Delaware, US | |
2018535 | 2018535 | 2022-09-20 | US | Mississippi | Harrison | 28047 | 62399 | 692 | 0 | 30.51359752 | -89.12467576 | 2022-09-21 04:23:22 | Harrison, Mississippi, US | |
2017821 | 2017821 | 2022-09-20 | US | Indiana | Hamilton | 18057 | 91844 | 692 | 0 | 40.07306535 | -86.05244729 | 2022-09-21 04:23:22 | Hamilton, Indiana, US | |
3571694 | 3571694 | 2022-09-19 | US | Indiana | Hamilton | 18057 | 91844 | 692 | 0 | 40.07306535 | -86.05244729 | 2022-09-20 04:22:48 | Hamilton, Indiana, US | |
420433 | 420433 | 2022-09-18 | US | Indiana | Hamilton | 18057 | 91795 | 692 | 0 | 40.07306535 | -86.05244729 | 2022-09-19 04:21:49 | Hamilton, Indiana, US | |
3374457 | 3374457 | 2022-09-17 | US | Indiana | Hamilton | 18057 | 91795 | 692 | 0 | 40.07306535 | -86.05244729 | 2022-09-18 04:22:50 | Hamilton, Indiana, US | |
2356565 | 2356565 | 2022-09-16 | US | Indiana | Hamilton | 18057 | 91795 | 692 | 0 | 40.07306535 | -86.05244729 | 2022-09-17 04:20:19 | Hamilton, Indiana, US | |
255957 | 255957 | 2022-09-08 | US | Oregon | Washington | 41067 | 112125 | 692 | 0 | 45.55972701 | -123.0955257 | 2022-09-09 04:21:11 | Washington, Oregon, US | |
3747755 | 3747755 | 2022-09-07 | US | Oregon | Washington | 41067 | 112028 | 692 | 0 | 45.55972701 | -123.0955257 | 2022-09-08 04:21:02 | Washington, Oregon, US | |
116986 | 116986 | 2022-09-06 | US | New York | Dutchess | 36027 | 75739 | 692 | 0 | 41.7648606 | -73.74356679 | 2022-09-07 04:20:59 | Dutchess, New York, US | |
2635958 | 2635958 | 2022-09-05 | US | New York | Dutchess | 36027 | 75712 | 692 | 0 | 41.7648606 | -73.74356679 | 2022-09-06 04:21:02 | Dutchess, New York, US | |
2832071 | 2832071 | 2022-08-25 | US | Texas | Wichita | 48485 | 36213 | 692 | 0 | 33.98842886 | -98.7041034 | 2022-08-26 04:21:02 | Wichita, Texas, US | |
1086791 | 1086791 | 2022-08-09 | US | Florida | Leon | 12073 | 101148 | 692 | 0 | 30.45955727 | -84.27491114 | 2022-08-10 04:20:57 | Leon, Florida, US | |
3544206 | 3544206 | 2022-08-08 | US | Florida | Leon | 12073 | 101148 | 692 | 0 | 30.45955727 | -84.27491114 | 2022-08-09 04:20:34 | Leon, Florida, US | |
1070609 | 1070609 | 2022-08-07 | US | Florida | Leon | 12073 | 101148 | 692 | 0 | 30.45955727 | -84.27491114 | 2022-08-08 04:21:08 | Leon, Florida, US | |
1941197 | 1941197 | 2022-08-06 | US | Florida | Leon | 12073 | 101148 | 692 | 0 | 30.45955727 | -84.27491114 | 2022-08-07 04:20:54 | Leon, Florida, US | |
880996 | 880996 | 2022-08-05 | US | Florida | Leon | 12073 | 101148 | 692 | 0 | 30.45955727 | -84.27491114 | 2022-08-06 04:20:56 | Leon, Florida, US | |
2009407 | 2009407 | 2022-08-04 | US | Florida | Leon | 12073 | 101148 | 692 | 0 | 30.45955727 | -84.27491114 | 2022-08-05 04:20:52 | Leon, Florida, US | |
1100966 | 1100966 | 2022-08-03 | US | South Carolina | York | 45091 | 84396 | 692 | 0 | 34.97281497 | -81.18085944 | 2022-08-04 04:20:58 | York, South Carolina, US | |
1098834 | 1098834 | 2022-08-03 | US | Florida | Leon | 12073 | 101148 | 692 | 0 | 30.45955727 | -84.27491114 | 2022-08-04 04:20:58 | Leon, Florida, US | |
1407891 | 1407891 | 2022-08-02 | US | South Carolina | York | 45091 | 84396 | 692 | 0 | 34.97281497 | -81.18085944 | 2022-08-03 04:20:59 | York, South Carolina, US | |
3619929 | 3619929 | 2022-08-01 | US | South Carolina | York | 45091 | 84396 | 692 | 0 | 34.97281497 | -81.18085944 | 2022-08-02 04:20:53 | York, South Carolina, US | |
3874409 | 3874409 | 2022-07-31 | US | South Carolina | York | 45091 | 84396 | 692 | 0 | 34.97281497 | -81.18085944 | 2022-08-01 04:21:03 | York, South Carolina, US | |
677163 | 677163 | 2022-07-30 | US | South Carolina | York | 45091 | 84396 | 692 | 0 | 34.97281497 | -81.18085944 | 2022-07-31 04:21:02 | York, South Carolina, US | |
1786362 | 1786362 | 2022-07-29 | US | South Carolina | York | 45091 | 84396 | 692 | 0 | 34.97281497 | -81.18085944 | 2022-07-30 04:20:42 | York, South Carolina, US | |
1068725 | 1068725 | 2022-07-28 | US | South Carolina | York | 45091 | 84396 | 692 | 0 | 34.97281497 | -81.18085944 | 2022-07-29 04:20:45 | York, South Carolina, US | |
2338244 | 2338244 | 2022-07-27 | US | South Carolina | York | 45091 | 84396 | 692 | 0 | 34.97281497 | -81.18085944 | 2022-07-28 04:20:56 | York, South Carolina, US | |
2335724 | 2335724 | 2022-07-27 | Sweden | Uppsala | 91097 | 692 | 0 | 60.0092 | 17.2715 | 2022-07-28 04:20:56 | Uppsala, Sweden | |||
1490434 | 1490434 | 2022-07-26 | US | South Carolina | York | 45091 | 84396 | 692 | 0 | 34.97281497 | -81.18085944 | 2022-07-27 04:21:04 | York, South Carolina, US | |
1487914 | 1487914 | 2022-07-26 | Sweden | Uppsala | 91097 | 692 | 0 | 60.0092 | 17.2715 | 2022-07-27 04:21:04 | Uppsala, Sweden | |||
2594360 | 2594360 | 2022-07-25 | Sweden | Uppsala | 91097 | 692 | 0 | 60.0092 | 17.2715 | 2022-07-26 04:20:58 | Uppsala, Sweden | |||
896475 | 896475 | 2022-07-24 | Sweden | Uppsala | 91097 | 692 | 0 | 60.0092 | 17.2715 | 2022-07-25 04:20:51 | Uppsala, Sweden | |||
91469 | 91469 | 2022-07-23 | Sweden | Uppsala | 91097 | 692 | 0 | 60.0092 | 17.2715 | 2022-07-24 04:20:47 | Uppsala, Sweden | |||
900491 | 900491 | 2022-07-22 | Sweden | Uppsala | 91097 | 692 | 0 | 60.0092 | 17.2715 | 2022-07-23 04:20:53 | Uppsala, Sweden | |||
671230 | 671230 | 2022-07-21 | US | Idaho | Canyon | 16027 | 64524 | 692 | 0 | 43.61970148 | -116.7095499 | 2022-07-22 04:21:15 | Canyon, Idaho, US | |
670627 | 670627 | 2022-07-21 | Sweden | Uppsala | 91097 | 692 | 0 | 60.0092 | 17.2715 | 2022-07-22 04:21:15 | Uppsala, Sweden | |||
1609193 | 1609193 | 2022-07-20 | US | Idaho | Canyon | 16027 | 64524 | 692 | 0 | 43.61970148 | -116.7095499 | 2022-07-21 04:21:10 | Canyon, Idaho, US | |
1608590 | 1608590 | 2022-07-20 | Sweden | Uppsala | 90862 | 692 | 0 | 60.0092 | 17.2715 | 2022-07-21 04:21:10 | Uppsala, Sweden | |||
959223 | 959223 | 2022-07-19 | Sweden | Uppsala | 90862 | 692 | 0 | 60.0092 | 17.2715 | 2022-07-20 04:20:59 | Uppsala, Sweden | |||
3210610 | 3210610 | 2022-07-18 | Sweden | Uppsala | 90862 | 692 | 0 | 60.0092 | 17.2715 | 2022-07-19 04:20:58 | Uppsala, Sweden | |||
3405785 | 3405785 | 2022-07-17 | Sweden | Uppsala | 90862 | 692 | 0 | 60.0092 | 17.2715 | 2022-07-18 04:20:59 | Uppsala, Sweden | |||
2151985 | 2151985 | 2022-07-16 | Sweden | Uppsala | 90862 | 692 | 0 | 60.0092 | 17.2715 | 2022-07-17 04:21:15 | Uppsala, Sweden | |||
2419218 | 2419218 | 2022-07-15 | Sweden | Uppsala | 90862 | 692 | 0 | 60.0092 | 17.2715 | 2022-07-16 04:21:05 | Uppsala, Sweden | |||
3429293 | 3429293 | 2022-07-14 | Sweden | Uppsala | 90862 | 692 | 0 | 60.0092 | 17.2715 | 2022-07-15 04:20:53 | Uppsala, Sweden | |||
3109804 | 3109804 | 2022-07-13 | Sweden | Jonkoping | 86875 | 692 | 0 | 57.3708 | 14.3439 | 2022-07-14 04:20:57 | Jonkoping, Sweden |
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]);