johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,221 rows where deaths = 342 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 904
- Sweden 100
- Gambia 40
- Japan 36
- Russia 30
- France 10
- Ukraine 10
- Chile 9
- Netherlands 8
- Pakistan 8
- Mali 6
- Peru 6
- Uganda 6
- Colombia 4
- Germany 4
- India 4
- Spain 4
- Brazil 3
- Finland 3
- Australia 2
- Cabo Verde 2
- Italy 2
- Malaysia 2
- Saint Lucia 2
- United Arab Emirates 2
- Angola 1
- Austria 1
- Canada 1
- Congo (Kinshasa) 1
- Cyprus 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753777 | 2753777 | 2022-12-29 | US | Georgia | Rockdale | 13247 | 22922 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-30 04:21:04 | Rockdale, Georgia, US | |
1074783 | 1074783 | 2022-12-28 | US | Georgia | Rockdale | 13247 | 22922 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-29 04:21:01 | Rockdale, Georgia, US | |
329480 | 329480 | 2022-12-27 | US | Maine | York | 23031 | 50129 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-28 04:21:04 | York, Maine, US | |
328780 | 328780 | 2022-12-27 | US | Georgia | Rockdale | 13247 | 22817 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-28 04:21:04 | Rockdale, Georgia, US | |
219553 | 219553 | 2022-12-26 | US | Maine | York | 23031 | 50129 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-27 04:21:07 | York, Maine, US | |
218853 | 218853 | 2022-12-26 | US | Georgia | Rockdale | 13247 | 22817 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-27 04:21:07 | Rockdale, Georgia, US | |
3224010 | 3224010 | 2022-12-25 | US | Maine | York | 23031 | 50129 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-26 04:21:06 | York, Maine, US | |
3223310 | 3223310 | 2022-12-25 | US | Georgia | Rockdale | 13247 | 22817 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-26 04:21:06 | Rockdale, Georgia, US | |
1019924 | 1019924 | 2022-12-24 | US | Maine | York | 23031 | 50129 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-25 04:21:04 | York, Maine, US | |
1019224 | 1019224 | 2022-12-24 | US | Georgia | Rockdale | 13247 | 22817 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-25 04:21:04 | Rockdale, Georgia, US | |
691947 | 691947 | 2022-12-23 | US | Maine | York | 23031 | 50089 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-24 04:21:02 | York, Maine, US | |
691247 | 691247 | 2022-12-23 | US | Georgia | Rockdale | 13247 | 22817 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-24 04:21:02 | Rockdale, Georgia, US | |
690403 | 690403 | 2022-12-23 | Japan | Wakayama | 182140 | 342 | 0 | 33.911879 | 135.505446 | 2022-12-24 04:21:02 | Wakayama, Japan | |||
2181157 | 2181157 | 2022-12-22 | US | Maine | York | 23031 | 50068 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-23 04:21:04 | York, Maine, US | |
2180457 | 2180457 | 2022-12-22 | US | Georgia | Rockdale | 13247 | 22817 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-23 04:21:04 | Rockdale, Georgia, US | |
452961 | 452961 | 2022-12-21 | US | Maine | York | 23031 | 50003 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-22 04:20:56 | York, Maine, US | |
452261 | 452261 | 2022-12-21 | US | Georgia | Rockdale | 13247 | 22817 | 342 | 0 | 33.65145002 | -84.02202167 | 2022-12-22 04:20:56 | Rockdale, Georgia, US | |
2952960 | 2952960 | 2022-12-20 | US | Maine | York | 23031 | 49950 | 342 | 0 | 43.47808377 | -70.71052375 | 2022-12-21 04:21:03 | York, Maine, US | |
348295 | 348295 | 2022-12-14 | Japan | Ishikawa | 218028 | 342 | 0 | 36.769464 | 136.771027 | 2022-12-15 04:20:58 | Ishikawa, Japan | |||
1148934 | 1148934 | 2022-12-12 | Japan | Ehime | 208226 | 342 | 0 | 33.624835 | 132.856842 | 2022-12-13 04:21:01 | Ehime, Japan | |||
868788 | 868788 | 2022-12-11 | Japan | Ehime | 207557 | 342 | 0 | 33.624835 | 132.856842 | 2022-12-12 04:21:01 | Ehime, Japan | |||
257318 | 257318 | 2022-12-10 | Japan | Ehime | 206189 | 342 | 0 | 33.624835 | 132.856842 | 2022-12-11 04:20:50 | Ehime, Japan | |||
1984647 | 1984647 | 2022-12-07 | Japan | Kagawa | 174097 | 342 | 0 | 34.217292 | 133.969047 | 2022-12-08 04:21:07 | Kagawa, Japan | |||
3717641 | 3717641 | 2022-12-06 | US | Washington | Whatcom | 53073 | 47818 | 342 | 0 | 48.82227976 | -121.7490018 | 2022-12-07 04:20:58 | Whatcom, Washington, US | |
2418346 | 2418346 | 2022-12-05 | US | Washington | Whatcom | 53073 | 47818 | 342 | 0 | 48.82227976 | -121.7490018 | 2022-12-06 04:21:03 | Whatcom, Washington, US | |
721954 | 721954 | 2022-12-04 | US | Washington | Whatcom | 53073 | 47818 | 342 | 0 | 48.82227976 | -121.7490018 | 2022-12-05 04:20:58 | Whatcom, Washington, US | |
2820243 | 2820243 | 2022-12-03 | US | Washington | Whatcom | 53073 | 47818 | 342 | 0 | 48.82227976 | -121.7490018 | 2022-12-04 04:20:56 | Whatcom, Washington, US | |
837099 | 837099 | 2022-12-02 | US | Washington | Whatcom | 53073 | 47818 | 342 | 0 | 48.82227976 | -121.7490018 | 2022-12-03 04:21:02 | Whatcom, Washington, US | |
2139629 | 2139629 | 2022-12-01 | US | Washington | Whatcom | 53073 | 47818 | 342 | 0 | 48.82227976 | -121.7490018 | 2022-12-02 04:21:07 | Whatcom, Washington, US | |
1968045 | 1968045 | 2022-11-30 | US | Washington | Whatcom | 53073 | 47818 | 342 | 0 | 48.82227976 | -121.7490018 | 2022-12-01 04:21:03 | Whatcom, Washington, US | |
2063914 | 2063914 | 2022-11-19 | Japan | Nagasaki | 230178 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-20 04:21:08 | Nagasaki, Japan | |||
3026301 | 3026301 | 2022-11-17 | Japan | Nagasaki | 227223 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-18 04:21:15 | Nagasaki, Japan | |||
294948 | 294948 | 2022-11-15 | US | Tennessee | Cumberland | 47035 | 18849 | 342 | 0 | 35.95271721 | -84.99840585 | 2022-11-16 04:21:09 | Cumberland, Tennessee, US | |
3599978 | 3599978 | 2022-11-14 | US | Tennessee | Cumberland | 47035 | 18840 | 342 | 0 | 35.95271721 | -84.99840585 | 2022-11-15 04:21:16 | Cumberland, Tennessee, US | |
3597053 | 3597053 | 2022-11-14 | Japan | Nagasaki | 227223 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-15 04:21:16 | Nagasaki, Japan | |||
314171 | 314171 | 2022-11-13 | US | New York | Schenectady | 36093 | 41759 | 342 | 0 | 42.81668777 | -74.05278291 | 2022-11-14 04:21:09 | Schenectady, New York, US | |
311911 | 311911 | 2022-11-13 | Japan | Nagasaki | 227003 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-14 04:21:09 | Nagasaki, Japan | |||
65332 | 65332 | 2022-11-12 | US | New York | Schenectady | 36093 | 41748 | 342 | 0 | 42.81668777 | -74.05278291 | 2022-11-13 04:21:14 | Schenectady, New York, US | |
63072 | 63072 | 2022-11-12 | Japan | Nagasaki | 226510 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-13 04:21:14 | Nagasaki, Japan | |||
2929494 | 2929494 | 2022-11-11 | US | New York | Schenectady | 36093 | 41725 | 342 | 0 | 42.81668777 | -74.05278291 | 2022-11-12 04:20:41 | Schenectady, New York, US | |
2927234 | 2927234 | 2022-11-11 | Japan | Nagasaki | 225985 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-12 04:20:41 | Nagasaki, Japan | |||
2508330 | 2508330 | 2022-11-10 | US | New York | Schenectady | 36093 | 41706 | 342 | 0 | 42.81668777 | -74.05278291 | 2022-11-11 04:21:22 | Schenectady, New York, US | |
2506070 | 2506070 | 2022-11-10 | Japan | Nagasaki | 225469 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-11 04:21:22 | Nagasaki, Japan | |||
2433205 | 2433205 | 2022-11-09 | US | New York | Schenectady | 36093 | 41684 | 342 | 0 | 42.81668777 | -74.05278291 | 2022-11-10 04:21:16 | Schenectady, New York, US | |
2431307 | 2431307 | 2022-11-09 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-10 04:21:16 | DeKalb, Alabama, US | |
2430945 | 2430945 | 2022-11-09 | Japan | Nagasaki | 224935 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-10 04:21:16 | Nagasaki, Japan | |||
481861 | 481861 | 2022-11-08 | US | New York | Schenectady | 36093 | 41659 | 342 | 0 | 42.81668777 | -74.05278291 | 2022-11-09 04:21:22 | Schenectady, New York, US | |
479963 | 479963 | 2022-11-08 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-09 04:21:22 | DeKalb, Alabama, US | |
479601 | 479601 | 2022-11-08 | Japan | Nagasaki | 224375 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-09 04:21:22 | Nagasaki, Japan | |||
2439113 | 2439113 | 2022-11-07 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-08 04:21:21 | DeKalb, Alabama, US | |
2438751 | 2438751 | 2022-11-07 | Japan | Nagasaki | 223699 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-08 04:21:21 | Nagasaki, Japan | |||
2438727 | 2438727 | 2022-11-07 | Japan | Aomori | 178913 | 342 | 0 | 40.781541 | 140.828896 | 2022-11-08 04:21:21 | Aomori, Japan | |||
1050211 | 1050211 | 2022-11-06 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-07 04:21:26 | DeKalb, Alabama, US | |
1049849 | 1049849 | 2022-11-06 | Japan | Nagasaki | 223514 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-07 04:21:26 | Nagasaki, Japan | |||
618235 | 618235 | 2022-11-05 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-06 04:21:24 | DeKalb, Alabama, US | |
617873 | 617873 | 2022-11-05 | Japan | Nagasaki | 223051 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-06 04:21:24 | Nagasaki, Japan | |||
1022739 | 1022739 | 2022-11-04 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-05 04:21:52 | DeKalb, Alabama, US | |
1022377 | 1022377 | 2022-11-04 | Japan | Nagasaki | 222390 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-05 04:21:52 | Nagasaki, Japan | |||
431730 | 431730 | 2022-11-03 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-04 04:22:11 | DeKalb, Alabama, US | |
431368 | 431368 | 2022-11-03 | Japan | Nagasaki | 222265 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-04 04:22:11 | Nagasaki, Japan | |||
849972 | 849972 | 2022-11-02 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-03 04:22:05 | DeKalb, Alabama, US | |
849610 | 849610 | 2022-11-02 | Japan | Nagasaki | 221747 | 342 | 0 | 33.235712 | 129.608033 | 2022-11-03 04:22:05 | Nagasaki, Japan | |||
710823 | 710823 | 2022-11-01 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-02 04:22:09 | DeKalb, Alabama, US | |
3285272 | 3285272 | 2022-10-31 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-11-01 04:22:36 | DeKalb, Alabama, US | |
320305 | 320305 | 2022-10-30 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-10-31 04:21:36 | DeKalb, Alabama, US | |
912581 | 912581 | 2022-10-29 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-10-30 04:22:14 | DeKalb, Alabama, US | |
1366850 | 1366850 | 2022-10-28 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-10-29 04:21:13 | DeKalb, Alabama, US | |
3038705 | 3038705 | 2022-10-27 | US | Alabama | DeKalb | 1049 | 21359 | 342 | 0 | 34.45946862 | -85.80782906 | 2022-10-28 04:22:31 | DeKalb, Alabama, US | |
3280177 | 3280177 | 2022-10-23 | US | Virginia | Arlington | 51013 | 61693 | 342 | 0 | 38.8767675 | -77.10139853 | 2022-10-24 04:22:29 | Arlington, Virginia, US | |
2271215 | 2271215 | 2022-10-22 | US | Virginia | Arlington | 51013 | 61693 | 342 | 0 | 38.8767675 | -77.10139853 | 2022-10-23 04:22:46 | Arlington, Virginia, US | |
1595515 | 1595515 | 2022-10-21 | US | Virginia | Arlington | 51013 | 61693 | 342 | 0 | 38.8767675 | -77.10139853 | 2022-10-22 04:22:53 | Arlington, Virginia, US | |
2275512 | 2275512 | 2022-10-20 | US | Wisconsin | Sheboygan | 55117 | 37393 | 342 | 0 | 43.72099677 | -87.94579284 | 2022-10-21 04:22:23 | Sheboygan, Wisconsin, US | |
2275231 | 2275231 | 2022-10-20 | US | Virginia | Arlington | 51013 | 61662 | 342 | 0 | 38.8767675 | -77.10139853 | 2022-10-21 04:22:23 | Arlington, Virginia, US | |
201847 | 201847 | 2022-10-19 | US | Wisconsin | Sheboygan | 55117 | 37371 | 342 | 0 | 43.72099677 | -87.94579284 | 2022-10-20 04:22:59 | Sheboygan, Wisconsin, US | |
2760508 | 2760508 | 2022-10-18 | US | Wisconsin | Sheboygan | 55117 | 37356 | 342 | 0 | 43.72099677 | -87.94579284 | 2022-10-19 04:22:26 | Sheboygan, Wisconsin, US | |
2759588 | 2759588 | 2022-10-18 | US | Pennsylvania | Crawford | 42039 | 23233 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-19 04:22:26 | Crawford, Pennsylvania, US | |
2028342 | 2028342 | 2022-10-17 | US | Wisconsin | Sheboygan | 55117 | 37342 | 342 | 0 | 43.72099677 | -87.94579284 | 2022-10-18 04:22:42 | Sheboygan, Wisconsin, US | |
2027422 | 2027422 | 2022-10-17 | US | Pennsylvania | Crawford | 42039 | 23233 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-18 04:22:42 | Crawford, Pennsylvania, US | |
2026413 | 2026413 | 2022-10-17 | US | Michigan | Lenawee | 26091 | 28837 | 342 | 0 | 41.89475156 | -84.06603727 | 2022-10-18 04:22:42 | Lenawee, Michigan, US | |
2163120 | 2163120 | 2022-10-16 | US | Wisconsin | Sheboygan | 55117 | 37298 | 342 | 0 | 43.72099677 | -87.94579284 | 2022-10-17 04:20:31 | Sheboygan, Wisconsin, US | |
2162200 | 2162200 | 2022-10-16 | US | Pennsylvania | Crawford | 42039 | 23233 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-17 04:20:31 | Crawford, Pennsylvania, US | |
2161191 | 2161191 | 2022-10-16 | US | Michigan | Lenawee | 26091 | 28837 | 342 | 0 | 41.89475156 | -84.06603727 | 2022-10-17 04:20:31 | Lenawee, Michigan, US | |
519317 | 519317 | 2022-10-15 | US | Wisconsin | Sheboygan | 55117 | 37298 | 342 | 0 | 43.72099677 | -87.94579284 | 2022-10-16 04:22:39 | Sheboygan, Wisconsin, US | |
518397 | 518397 | 2022-10-15 | US | Pennsylvania | Crawford | 42039 | 23233 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-16 04:22:39 | Crawford, Pennsylvania, US | |
517388 | 517388 | 2022-10-15 | US | Michigan | Lenawee | 26091 | 28837 | 342 | 0 | 41.89475156 | -84.06603727 | 2022-10-16 04:22:39 | Lenawee, Michigan, US | |
515749 | 515749 | 2022-10-15 | Japan | Shiga | 239495 | 342 | 0 | 35.215827 | 136.138064 | 2022-10-16 04:22:39 | Shiga, Japan | |||
2036374 | 2036374 | 2022-10-14 | US | Wisconsin | Sheboygan | 55117 | 37298 | 342 | 0 | 43.72099677 | -87.94579284 | 2022-10-15 04:22:00 | Sheboygan, Wisconsin, US | |
2035454 | 2035454 | 2022-10-14 | US | Pennsylvania | Crawford | 42039 | 23233 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-15 04:22:00 | Crawford, Pennsylvania, US | |
2034445 | 2034445 | 2022-10-14 | US | Michigan | Lenawee | 26091 | 28837 | 342 | 0 | 41.89475156 | -84.06603727 | 2022-10-15 04:22:00 | Lenawee, Michigan, US | |
3756142 | 3756142 | 2022-10-13 | US | Pennsylvania | Crawford | 42039 | 23233 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-14 04:22:28 | Crawford, Pennsylvania, US | |
3755133 | 3755133 | 2022-10-13 | US | Michigan | Lenawee | 26091 | 28837 | 342 | 0 | 41.89475156 | -84.06603727 | 2022-10-14 04:22:28 | Lenawee, Michigan, US | |
3216967 | 3216967 | 2022-10-12 | US | Pennsylvania | Crawford | 42039 | 23233 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-13 04:22:39 | Crawford, Pennsylvania, US | |
3216850 | 3216850 | 2022-10-12 | US | Oklahoma | Creek | 40037 | 20944 | 342 | 0 | 35.90230551 | -96.37086028 | 2022-10-13 04:22:39 | Creek, Oklahoma, US | |
3215958 | 3215958 | 2022-10-12 | US | Michigan | Lenawee | 26091 | 28837 | 342 | 0 | 41.89475156 | -84.06603727 | 2022-10-13 04:22:39 | Lenawee, Michigan, US | |
3214787 | 3214787 | 2022-10-12 | US | Arkansas | Faulkner | 5045 | 40742 | 342 | 0 | 35.14719007 | -92.33717519 | 2022-10-13 04:22:39 | Faulkner, Arkansas, US | |
3252816 | 3252816 | 2022-10-11 | US | Pennsylvania | Crawford | 42039 | 23073 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-12 04:22:51 | Crawford, Pennsylvania, US | |
3252699 | 3252699 | 2022-10-11 | US | Oklahoma | Creek | 40037 | 20944 | 342 | 0 | 35.90230551 | -96.37086028 | 2022-10-12 04:22:51 | Creek, Oklahoma, US | |
3251807 | 3251807 | 2022-10-11 | US | Michigan | Lenawee | 26091 | 28837 | 342 | 0 | 41.89475156 | -84.06603727 | 2022-10-12 04:22:51 | Lenawee, Michigan, US | |
2970075 | 2970075 | 2022-10-10 | US | Pennsylvania | Crawford | 42039 | 23073 | 342 | 0 | 41.68447709 | -80.10760592 | 2022-10-11 04:23:05 | Crawford, Pennsylvania, US | |
2969958 | 2969958 | 2022-10-10 | US | Oklahoma | Creek | 40037 | 20944 | 342 | 0 | 35.90230551 | -96.37086028 | 2022-10-11 04:23:05 | Creek, Oklahoma, 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]);