johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
23,328 rows where deaths = 31 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
These facets timed out: province_or_state
country_or_region 94
- US 22,093
- Japan 195
- United Kingdom 147
- Sweden 132
- Russia 114
- Malaysia 79
- Netherlands 74
- Canada 52
- Colombia 44
- Ukraine 35
- Australia 28
- Albania 24
- Chile 21
- Singapore 19
- Latvia 18
- Lesotho 16
- Monaco 16
- India 15
- New Zealand 14
- Antigua and Barbuda 13
- France 13
- Micronesia 13
- Peru 13
- Slovakia 12
- Botswana 11
- Benin 5
- Ghana 5
- Guyana 5
- Kosovo 5
- Mexico 5
- Barbados 4
- Maldives 4
- Uruguay 4
- Chad 3
- Kazakhstan 3
- Liberia 3
- Mauritius 3
- Bolivia 2
- Brunei 2
- Dominica 2
- Guinea 2
- Kyrgyzstan 2
- Lebanon 2
- Luxembourg 2
- Malta 2
- Mozambique 2
- Sao Tome and Principe 2
- Togo 2
- Algeria 1
- Andorra 1
- Azerbaijan 1
- Bahrain 1
- Brazil 1
- China 1
- Congo (Kinshasa) 1
- Cote d'Ivoire 1
- Croatia 1
- Cuba 1
- Czechia 1
- Djibouti 1
- El Salvador 1
- Estonia 1
- Finland 1
- Germany 1
- Haiti 1
- Honduras 1
- Iceland 1
- Italy 1
- Liechtenstein 1
- Lithuania 1
- Malawi 1
- Mauritania 1
- Moldova 1
- Mongolia 1
- Namibia 1
- Nepal 1
- Niger 1
- Nigeria 1
- Oman 1
- Pakistan 1
- Papua New Guinea 1
- Paraguay 1
- Poland 1
- Rwanda 1
- Saint Lucia 1
- Serbia 1
- Somalia 1
- South Sudan 1
- Spain 1
- Sudan 1
- Syria 1
- Trinidad and Tobago 1
- Tunisia 1
- Uzbekistan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756512 | 2756512 | 2022-12-29 | US | Wyoming | Crook | 56011 | 1544 | 31 | 0 | 44.58855102 | -104.5697705 | 2022-12-30 04:21:04 | Crook, Wyoming, US | |
2756299 | 2756299 | 2022-12-29 | US | Virginia | Poquoson | 51735 | 2864 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-12-30 04:21:04 | Poquoson, Virginia, US | |
2756225 | 2756225 | 2022-12-29 | US | Virginia | Charles City | 51036 | 1606 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-12-30 04:21:04 | Charles City, Virginia, US | |
2756037 | 2756037 | 2022-12-29 | US | Texas | Jack | 48237 | 1641 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-30 04:21:04 | Jack, Texas, US | |
2755317 | 2755317 | 2022-12-29 | US | North Dakota | McHenry | 38049 | 1552 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-12-30 04:21:04 | McHenry, North Dakota, US | |
2755229 | 2755229 | 2022-12-29 | US | North Carolina | Graham | 37075 | 2838 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-12-30 04:21:04 | Graham, North Carolina, US | |
2754967 | 2754967 | 2022-12-29 | US | Nebraska | Colfax | 31037 | 2890 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-12-30 04:21:04 | Colfax, Nebraska, US | |
2754924 | 2754924 | 2022-12-29 | US | Montana | Musselshell | 30065 | 1082 | 31 | 0 | 46.49684637 | -108.39498 | 2022-12-30 04:21:04 | Musselshell, Montana, US | |
2754691 | 2754691 | 2022-12-29 | US | Minnesota | Yellow Medicine | 27173 | 3038 | 31 | 0 | 44.71710183 | -95.86842453 | 2022-12-30 04:21:04 | Yellow Medicine, Minnesota, US | |
2754626 | 2754626 | 2022-12-29 | US | Minnesota | Fillmore | 27045 | 5751 | 31 | 0 | 43.67394126 | -92.08980382 | 2022-12-30 04:21:04 | Fillmore, Minnesota, US | |
2754325 | 2754325 | 2022-12-29 | US | Kentucky | Hickman | 21105 | 1066 | 31 | 0 | 36.6794808 | -88.97875928 | 2022-12-30 04:21:04 | Hickman, Kentucky, US | |
2754263 | 2754263 | 2022-12-29 | US | Kansas | Thomas | 20193 | 2946 | 31 | 0 | 39.35107575 | -101.0553705 | 2022-12-30 04:21:04 | Thomas, Kansas, US | |
2754259 | 2754259 | 2022-12-29 | US | Kansas | Stafford | 20185 | 1367 | 31 | 0 | 38.03100851 | -98.71762001 | 2022-12-30 04:21:04 | Stafford, Kansas, US | |
2754246 | 2754246 | 2022-12-29 | US | Kansas | Rice | 20159 | 3036 | 31 | 0 | 38.34616184 | -98.19992118 | 2022-12-30 04:21:04 | Rice, Kansas, US | |
2754229 | 2754229 | 2022-12-29 | US | Kansas | Morris | 20127 | 1740 | 31 | 0 | 38.68827511 | -96.65128437 | 2022-12-30 04:21:04 | Morris, Kansas, US | |
2753871 | 2753871 | 2022-12-29 | US | Illinois | Bond | 17005 | 5193 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-12-30 04:21:04 | Bond, Illinois, US | |
2753844 | 2753844 | 2022-12-29 | US | Idaho | Franklin | 16041 | 2557 | 31 | 0 | 42.18332217 | -111.8149666 | 2022-12-30 04:21:04 | Franklin, Idaho, US | |
2753624 | 2753624 | 2022-12-29 | US | Florida | Liberty | 12077 | 2913 | 31 | 0 | 30.23766008 | -84.8829258 | 2022-12-30 04:21:04 | Liberty, Florida, US | |
2752974 | 2752974 | 2022-12-29 | Malaysia | W.P. Putrajaya | 32108 | 31 | 0 | 2.9264 | 101.6964 | 2022-12-30 04:21:04 | W.P. Putrajaya, Malaysia | |||
1077518 | 1077518 | 2022-12-28 | US | Wyoming | Crook | 56011 | 1544 | 31 | 0 | 44.58855102 | -104.5697705 | 2022-12-29 04:21:01 | Crook, Wyoming, US | |
1077305 | 1077305 | 2022-12-28 | US | Virginia | Poquoson | 51735 | 2864 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-12-29 04:21:01 | Poquoson, Virginia, US | |
1077231 | 1077231 | 2022-12-28 | US | Virginia | Charles City | 51036 | 1606 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-12-29 04:21:01 | Charles City, Virginia, US | |
1077043 | 1077043 | 2022-12-28 | US | Texas | Jack | 48237 | 1641 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-29 04:21:01 | Jack, Texas, US | |
1076323 | 1076323 | 2022-12-28 | US | North Dakota | McHenry | 38049 | 1552 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-12-29 04:21:01 | McHenry, North Dakota, US | |
1076235 | 1076235 | 2022-12-28 | US | North Carolina | Graham | 37075 | 2838 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-12-29 04:21:01 | Graham, North Carolina, US | |
1076042 | 1076042 | 2022-12-28 | US | Nebraska | Unassigned | 90031 | 12217 | 31 | 0 | 42.8997274 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Nebraska, US | |
1075973 | 1075973 | 2022-12-28 | US | Nebraska | Colfax | 31037 | 2890 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-12-29 04:21:01 | Colfax, Nebraska, US | |
1075930 | 1075930 | 2022-12-28 | US | Montana | Musselshell | 30065 | 1082 | 31 | 0 | 46.49684637 | -108.39498 | 2022-12-29 04:21:01 | Musselshell, Montana, US | |
1075697 | 1075697 | 2022-12-28 | US | Minnesota | Yellow Medicine | 27173 | 3030 | 31 | 0 | 44.71710183 | -95.86842453 | 2022-12-29 04:21:01 | Yellow Medicine, Minnesota, US | |
1075632 | 1075632 | 2022-12-28 | US | Minnesota | Fillmore | 27045 | 5737 | 31 | 0 | 43.67394126 | -92.08980382 | 2022-12-29 04:21:01 | Fillmore, Minnesota, US | |
1075331 | 1075331 | 2022-12-28 | US | Kentucky | Hickman | 21105 | 1066 | 31 | 0 | 36.6794808 | -88.97875928 | 2022-12-29 04:21:01 | Hickman, Kentucky, US | |
1075269 | 1075269 | 2022-12-28 | US | Kansas | Thomas | 20193 | 2946 | 31 | 0 | 39.35107575 | -101.0553705 | 2022-12-29 04:21:01 | Thomas, Kansas, US | |
1075265 | 1075265 | 2022-12-28 | US | Kansas | Stafford | 20185 | 1367 | 31 | 0 | 38.03100851 | -98.71762001 | 2022-12-29 04:21:01 | Stafford, Kansas, US | |
1075252 | 1075252 | 2022-12-28 | US | Kansas | Rice | 20159 | 3036 | 31 | 0 | 38.34616184 | -98.19992118 | 2022-12-29 04:21:01 | Rice, Kansas, US | |
1075235 | 1075235 | 2022-12-28 | US | Kansas | Morris | 20127 | 1740 | 31 | 0 | 38.68827511 | -96.65128437 | 2022-12-29 04:21:01 | Morris, Kansas, US | |
1074877 | 1074877 | 2022-12-28 | US | Illinois | Bond | 17005 | 5193 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-12-29 04:21:01 | Bond, Illinois, US | |
1074850 | 1074850 | 2022-12-28 | US | Idaho | Franklin | 16041 | 2557 | 31 | 0 | 42.18332217 | -111.8149666 | 2022-12-29 04:21:01 | Franklin, Idaho, US | |
1074630 | 1074630 | 2022-12-28 | US | Florida | Liberty | 12077 | 2913 | 31 | 0 | 30.23766008 | -84.8829258 | 2022-12-29 04:21:01 | Liberty, Florida, US | |
1073980 | 1073980 | 2022-12-28 | Malaysia | W.P. Putrajaya | 32087 | 31 | 0 | 2.9264 | 101.6964 | 2022-12-29 04:21:01 | W.P. Putrajaya, Malaysia | |||
331515 | 331515 | 2022-12-27 | US | Wyoming | Crook | 56011 | 1544 | 31 | 0 | 44.58855102 | -104.5697705 | 2022-12-28 04:21:04 | Crook, Wyoming, US | |
331302 | 331302 | 2022-12-27 | US | Virginia | Poquoson | 51735 | 2861 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-12-28 04:21:04 | Poquoson, Virginia, US | |
331228 | 331228 | 2022-12-27 | US | Virginia | Charles City | 51036 | 1604 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-12-28 04:21:04 | Charles City, Virginia, US | |
331040 | 331040 | 2022-12-27 | US | Texas | Jack | 48237 | 1641 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-28 04:21:04 | Jack, Texas, US | |
330320 | 330320 | 2022-12-27 | US | North Dakota | McHenry | 38049 | 1552 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-12-28 04:21:04 | McHenry, North Dakota, US | |
330232 | 330232 | 2022-12-27 | US | North Carolina | Graham | 37075 | 2838 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-12-28 04:21:04 | Graham, North Carolina, US | |
330039 | 330039 | 2022-12-27 | US | Nebraska | Unassigned | 90031 | 12217 | 31 | 0 | 42.8997274 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Nebraska, US | |
329970 | 329970 | 2022-12-27 | US | Nebraska | Colfax | 31037 | 2890 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-12-28 04:21:04 | Colfax, Nebraska, US | |
329927 | 329927 | 2022-12-27 | US | Montana | Musselshell | 30065 | 1082 | 31 | 0 | 46.49684637 | -108.39498 | 2022-12-28 04:21:04 | Musselshell, Montana, US | |
329694 | 329694 | 2022-12-27 | US | Minnesota | Yellow Medicine | 27173 | 3030 | 31 | 0 | 44.71710183 | -95.86842453 | 2022-12-28 04:21:04 | Yellow Medicine, Minnesota, US | |
329629 | 329629 | 2022-12-27 | US | Minnesota | Fillmore | 27045 | 5737 | 31 | 0 | 43.67394126 | -92.08980382 | 2022-12-28 04:21:04 | Fillmore, Minnesota, US | |
329328 | 329328 | 2022-12-27 | US | Kentucky | Hickman | 21105 | 1066 | 31 | 0 | 36.6794808 | -88.97875928 | 2022-12-28 04:21:04 | Hickman, Kentucky, US | |
329266 | 329266 | 2022-12-27 | US | Kansas | Thomas | 20193 | 2936 | 31 | 0 | 39.35107575 | -101.0553705 | 2022-12-28 04:21:04 | Thomas, Kansas, US | |
329262 | 329262 | 2022-12-27 | US | Kansas | Stafford | 20185 | 1364 | 31 | 0 | 38.03100851 | -98.71762001 | 2022-12-28 04:21:04 | Stafford, Kansas, US | |
329249 | 329249 | 2022-12-27 | US | Kansas | Rice | 20159 | 3029 | 31 | 0 | 38.34616184 | -98.19992118 | 2022-12-28 04:21:04 | Rice, Kansas, US | |
329232 | 329232 | 2022-12-27 | US | Kansas | Morris | 20127 | 1738 | 31 | 0 | 38.68827511 | -96.65128437 | 2022-12-28 04:21:04 | Morris, Kansas, US | |
328874 | 328874 | 2022-12-27 | US | Illinois | Bond | 17005 | 5188 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-12-28 04:21:04 | Bond, Illinois, US | |
328847 | 328847 | 2022-12-27 | US | Idaho | Franklin | 16041 | 2554 | 31 | 0 | 42.18332217 | -111.8149666 | 2022-12-28 04:21:04 | Franklin, Idaho, US | |
328627 | 328627 | 2022-12-27 | US | Florida | Liberty | 12077 | 2913 | 31 | 0 | 30.23766008 | -84.8829258 | 2022-12-28 04:21:04 | Liberty, Florida, US | |
327977 | 327977 | 2022-12-27 | Malaysia | W.P. Putrajaya | 32074 | 31 | 0 | 2.9264 | 101.6964 | 2022-12-28 04:21:04 | W.P. Putrajaya, Malaysia | |||
221588 | 221588 | 2022-12-26 | US | Wyoming | Crook | 56011 | 1543 | 31 | 0 | 44.58855102 | -104.5697705 | 2022-12-27 04:21:07 | Crook, Wyoming, US | |
221375 | 221375 | 2022-12-26 | US | Virginia | Poquoson | 51735 | 2861 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-12-27 04:21:07 | Poquoson, Virginia, US | |
221301 | 221301 | 2022-12-26 | US | Virginia | Charles City | 51036 | 1604 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-12-27 04:21:07 | Charles City, Virginia, US | |
221113 | 221113 | 2022-12-26 | US | Texas | Jack | 48237 | 1641 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-27 04:21:07 | Jack, Texas, US | |
220393 | 220393 | 2022-12-26 | US | North Dakota | McHenry | 38049 | 1552 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-12-27 04:21:07 | McHenry, North Dakota, US | |
220305 | 220305 | 2022-12-26 | US | North Carolina | Graham | 37075 | 2838 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-12-27 04:21:07 | Graham, North Carolina, US | |
220112 | 220112 | 2022-12-26 | US | Nebraska | Unassigned | 90031 | 12217 | 31 | 0 | 42.8997274 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Nebraska, US | |
220043 | 220043 | 2022-12-26 | US | Nebraska | Colfax | 31037 | 2890 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-12-27 04:21:07 | Colfax, Nebraska, US | |
220000 | 220000 | 2022-12-26 | US | Montana | Musselshell | 30065 | 1082 | 31 | 0 | 46.49684637 | -108.39498 | 2022-12-27 04:21:07 | Musselshell, Montana, US | |
219767 | 219767 | 2022-12-26 | US | Minnesota | Yellow Medicine | 27173 | 3030 | 31 | 0 | 44.71710183 | -95.86842453 | 2022-12-27 04:21:07 | Yellow Medicine, Minnesota, US | |
219702 | 219702 | 2022-12-26 | US | Minnesota | Fillmore | 27045 | 5737 | 31 | 0 | 43.67394126 | -92.08980382 | 2022-12-27 04:21:07 | Fillmore, Minnesota, US | |
219401 | 219401 | 2022-12-26 | US | Kentucky | Hickman | 21105 | 1060 | 31 | 0 | 36.6794808 | -88.97875928 | 2022-12-27 04:21:07 | Hickman, Kentucky, US | |
219339 | 219339 | 2022-12-26 | US | Kansas | Thomas | 20193 | 2936 | 31 | 0 | 39.35107575 | -101.0553705 | 2022-12-27 04:21:07 | Thomas, Kansas, US | |
219335 | 219335 | 2022-12-26 | US | Kansas | Stafford | 20185 | 1364 | 31 | 0 | 38.03100851 | -98.71762001 | 2022-12-27 04:21:07 | Stafford, Kansas, US | |
219322 | 219322 | 2022-12-26 | US | Kansas | Rice | 20159 | 3029 | 31 | 0 | 38.34616184 | -98.19992118 | 2022-12-27 04:21:07 | Rice, Kansas, US | |
219305 | 219305 | 2022-12-26 | US | Kansas | Morris | 20127 | 1738 | 31 | 0 | 38.68827511 | -96.65128437 | 2022-12-27 04:21:07 | Morris, Kansas, US | |
218947 | 218947 | 2022-12-26 | US | Illinois | Bond | 17005 | 5178 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-12-27 04:21:07 | Bond, Illinois, US | |
218920 | 218920 | 2022-12-26 | US | Idaho | Franklin | 16041 | 2554 | 31 | 0 | 42.18332217 | -111.8149666 | 2022-12-27 04:21:07 | Franklin, Idaho, US | |
218700 | 218700 | 2022-12-26 | US | Florida | Liberty | 12077 | 2913 | 31 | 0 | 30.23766008 | -84.8829258 | 2022-12-27 04:21:07 | Liberty, Florida, US | |
218050 | 218050 | 2022-12-26 | Malaysia | W.P. Putrajaya | 32070 | 31 | 0 | 2.9264 | 101.6964 | 2022-12-27 04:21:07 | W.P. Putrajaya, Malaysia | |||
3226045 | 3226045 | 2022-12-25 | US | Wyoming | Crook | 56011 | 1543 | 31 | 0 | 44.58855102 | -104.5697705 | 2022-12-26 04:21:06 | Crook, Wyoming, US | |
3225832 | 3225832 | 2022-12-25 | US | Virginia | Poquoson | 51735 | 2858 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-12-26 04:21:06 | Poquoson, Virginia, US | |
3225758 | 3225758 | 2022-12-25 | US | Virginia | Charles City | 51036 | 1602 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-12-26 04:21:06 | Charles City, Virginia, US | |
3225570 | 3225570 | 2022-12-25 | US | Texas | Jack | 48237 | 1641 | 31 | 0 | 33.23377248 | -98.17283469 | 2022-12-26 04:21:06 | Jack, Texas, US | |
3224850 | 3224850 | 2022-12-25 | US | North Dakota | McHenry | 38049 | 1552 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-12-26 04:21:06 | McHenry, North Dakota, US | |
3224762 | 3224762 | 2022-12-25 | US | North Carolina | Graham | 37075 | 2838 | 31 | 0 | 35.3506925 | -83.83369267 | 2022-12-26 04:21:06 | Graham, North Carolina, US | |
3224569 | 3224569 | 2022-12-25 | US | Nebraska | Unassigned | 90031 | 12217 | 31 | 0 | 42.8997274 | 0.0 | 2022-12-26 04:21:06 | Unassigned, Nebraska, US | |
3224500 | 3224500 | 2022-12-25 | US | Nebraska | Colfax | 31037 | 2890 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-12-26 04:21:06 | Colfax, Nebraska, US | |
3224457 | 3224457 | 2022-12-25 | US | Montana | Musselshell | 30065 | 1082 | 31 | 0 | 46.49684637 | -108.39498 | 2022-12-26 04:21:06 | Musselshell, Montana, US | |
3224224 | 3224224 | 2022-12-25 | US | Minnesota | Yellow Medicine | 27173 | 3030 | 31 | 0 | 44.71710183 | -95.86842453 | 2022-12-26 04:21:06 | Yellow Medicine, Minnesota, US | |
3224159 | 3224159 | 2022-12-25 | US | Minnesota | Fillmore | 27045 | 5737 | 31 | 0 | 43.67394126 | -92.08980382 | 2022-12-26 04:21:06 | Fillmore, Minnesota, US | |
3223858 | 3223858 | 2022-12-25 | US | Kentucky | Hickman | 21105 | 1060 | 31 | 0 | 36.6794808 | -88.97875928 | 2022-12-26 04:21:06 | Hickman, Kentucky, US | |
3223796 | 3223796 | 2022-12-25 | US | Kansas | Thomas | 20193 | 2936 | 31 | 0 | 39.35107575 | -101.0553705 | 2022-12-26 04:21:06 | Thomas, Kansas, US | |
3223792 | 3223792 | 2022-12-25 | US | Kansas | Stafford | 20185 | 1364 | 31 | 0 | 38.03100851 | -98.71762001 | 2022-12-26 04:21:06 | Stafford, Kansas, US | |
3223779 | 3223779 | 2022-12-25 | US | Kansas | Rice | 20159 | 3029 | 31 | 0 | 38.34616184 | -98.19992118 | 2022-12-26 04:21:06 | Rice, Kansas, US | |
3223762 | 3223762 | 2022-12-25 | US | Kansas | Morris | 20127 | 1738 | 31 | 0 | 38.68827511 | -96.65128437 | 2022-12-26 04:21:06 | Morris, Kansas, US | |
3223404 | 3223404 | 2022-12-25 | US | Illinois | Bond | 17005 | 5178 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-12-26 04:21:06 | Bond, Illinois, US | |
3223377 | 3223377 | 2022-12-25 | US | Idaho | Franklin | 16041 | 2554 | 31 | 0 | 42.18332217 | -111.8149666 | 2022-12-26 04:21:06 | Franklin, Idaho, US | |
3223157 | 3223157 | 2022-12-25 | US | Florida | Liberty | 12077 | 2913 | 31 | 0 | 30.23766008 | -84.8829258 | 2022-12-26 04:21:06 | Liberty, Florida, US | |
3222507 | 3222507 | 2022-12-25 | Malaysia | W.P. Putrajaya | 32059 | 31 | 0 | 2.9264 | 101.6964 | 2022-12-26 04:21:06 | W.P. Putrajaya, Malaysia | |||
1021959 | 1021959 | 2022-12-24 | US | Wyoming | Crook | 56011 | 1543 | 31 | 0 | 44.58855102 | -104.5697705 | 2022-12-25 04:21:04 | Crook, Wyoming, 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]);