johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,102 rows where deaths = 343 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754477 | 2754477 | 2022-12-29 | US | Maine | York | 23031 | 50255 | 343 | 0 | 43.47808377 | -70.71052375 | 2022-12-30 04:21:04 | York, Maine, US | |
1075483 | 1075483 | 2022-12-28 | US | Maine | York | 23031 | 50218 | 343 | 0 | 43.47808377 | -70.71052375 | 2022-12-29 04:21:01 | York, Maine, US | |
1628305 | 1628305 | 2022-12-18 | Japan | Iwate | 182284 | 343 | 0 | 39.593287 | 141.361777 | 2022-12-19 04:21:03 | Iwate, Japan | |||
309124 | 309124 | 2022-12-13 | US | Iowa | Pottawattamie | 19155 | 27312 | 343 | 0 | 41.33640314 | -95.53907776 | 2022-12-14 04:21:04 | Pottawattamie, Iowa, US | |
1150185 | 1150185 | 2022-12-12 | US | Iowa | Pottawattamie | 19155 | 27312 | 343 | 0 | 41.33640314 | -95.53907776 | 2022-12-13 04:21:01 | Pottawattamie, Iowa, US | |
870039 | 870039 | 2022-12-11 | US | Iowa | Pottawattamie | 19155 | 27312 | 343 | 0 | 41.33640314 | -95.53907776 | 2022-12-12 04:21:01 | Pottawattamie, Iowa, US | |
258569 | 258569 | 2022-12-10 | US | Iowa | Pottawattamie | 19155 | 27312 | 343 | 0 | 41.33640314 | -95.53907776 | 2022-12-11 04:20:50 | Pottawattamie, Iowa, US | |
3937283 | 3937283 | 2022-12-09 | US | Iowa | Pottawattamie | 19155 | 27312 | 343 | 0 | 41.33640314 | -95.53907776 | 2022-12-10 04:21:02 | Pottawattamie, Iowa, US | |
3936047 | 3936047 | 2022-12-09 | Japan | Kochi | 118596 | 343 | 0 | 33.422519 | 133.367307 | 2022-12-10 04:21:02 | Kochi, Japan | |||
3378615 | 3378615 | 2022-12-08 | US | Iowa | Pottawattamie | 19155 | 27312 | 343 | 0 | 41.33640314 | -95.53907776 | 2022-12-09 04:21:05 | Pottawattamie, Iowa, US | |
3377379 | 3377379 | 2022-12-08 | Japan | Kochi | 117880 | 343 | 0 | 33.422519 | 133.367307 | 2022-12-09 04:21:05 | Kochi, Japan | |||
3377361 | 3377361 | 2022-12-08 | Japan | Akita | 154261 | 343 | 0 | 39.748679 | 140.408228 | 2022-12-09 04:21:05 | Akita, Japan | |||
1985886 | 1985886 | 2022-12-07 | US | Iowa | Pottawattamie | 19155 | 27312 | 343 | 0 | 41.33640314 | -95.53907776 | 2022-12-08 04:21:07 | Pottawattamie, Iowa, US | |
2139093 | 2139093 | 2022-12-01 | US | Tennessee | Cumberland | 47035 | 18942 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-12-02 04:21:07 | Cumberland, Tennessee, US | |
1967509 | 1967509 | 2022-11-30 | US | Tennessee | Cumberland | 47035 | 18926 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-12-01 04:21:03 | Cumberland, Tennessee, US | |
2560059 | 2560059 | 2022-11-29 | US | Washington | Whatcom | 53073 | 47640 | 343 | 0 | 48.82227976 | -121.7490018 | 2022-11-30 04:21:07 | Whatcom, Washington, US | |
2559523 | 2559523 | 2022-11-29 | US | Tennessee | Cumberland | 47035 | 18916 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-11-30 04:21:07 | Cumberland, Tennessee, US | |
2556960 | 2556960 | 2022-11-29 | US | Alabama | DeKalb | 1049 | 21485 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-30 04:21:07 | DeKalb, Alabama, US | |
1243133 | 1243133 | 2022-11-28 | US | Washington | Whatcom | 53073 | 47640 | 343 | 0 | 48.82227976 | -121.7490018 | 2022-11-29 04:21:05 | Whatcom, Washington, US | |
1242597 | 1242597 | 2022-11-28 | US | Tennessee | Cumberland | 47035 | 18909 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-11-29 04:21:05 | Cumberland, Tennessee, US | |
1240034 | 1240034 | 2022-11-28 | US | Alabama | DeKalb | 1049 | 21485 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-29 04:21:05 | DeKalb, Alabama, US | |
3555121 | 3555121 | 2022-11-27 | US | Washington | Whatcom | 53073 | 47640 | 343 | 0 | 48.82227976 | -121.7490018 | 2022-11-28 04:21:02 | Whatcom, Washington, US | |
3554585 | 3554585 | 2022-11-27 | US | Tennessee | Cumberland | 47035 | 18905 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-11-28 04:21:02 | Cumberland, Tennessee, US | |
3552022 | 3552022 | 2022-11-27 | US | Alabama | DeKalb | 1049 | 21485 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-28 04:21:02 | DeKalb, Alabama, US | |
2103601 | 2103601 | 2022-11-26 | US | Washington | Whatcom | 53073 | 47640 | 343 | 0 | 48.82227976 | -121.7490018 | 2022-11-27 04:21:05 | Whatcom, Washington, US | |
2103065 | 2103065 | 2022-11-26 | US | Tennessee | Cumberland | 47035 | 18896 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-11-27 04:21:05 | Cumberland, Tennessee, US | |
2100502 | 2100502 | 2022-11-26 | US | Alabama | DeKalb | 1049 | 21485 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-27 04:21:05 | DeKalb, Alabama, US | |
491092 | 491092 | 2022-11-25 | US | Washington | Whatcom | 53073 | 47640 | 343 | 0 | 48.82227976 | -121.7490018 | 2022-11-26 04:21:11 | Whatcom, Washington, US | |
490556 | 490556 | 2022-11-25 | US | Tennessee | Cumberland | 47035 | 18895 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-11-26 04:21:11 | Cumberland, Tennessee, US | |
487993 | 487993 | 2022-11-25 | US | Alabama | DeKalb | 1049 | 21485 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-26 04:21:11 | DeKalb, Alabama, US | |
3526921 | 3526921 | 2022-11-24 | US | Washington | Whatcom | 53073 | 47640 | 343 | 0 | 48.82227976 | -121.7490018 | 2022-11-25 04:21:06 | Whatcom, Washington, US | |
3526385 | 3526385 | 2022-11-24 | US | Tennessee | Cumberland | 47035 | 18893 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-11-25 04:21:06 | Cumberland, Tennessee, US | |
3523822 | 3523822 | 2022-11-24 | US | Alabama | DeKalb | 1049 | 21485 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-25 04:21:06 | DeKalb, Alabama, US | |
3315704 | 3315704 | 2022-11-23 | US | Washington | Whatcom | 53073 | 47640 | 343 | 0 | 48.82227976 | -121.7490018 | 2022-11-24 04:21:09 | Whatcom, Washington, US | |
3315168 | 3315168 | 2022-11-23 | US | Tennessee | Cumberland | 47035 | 18891 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-11-24 04:21:09 | Cumberland, Tennessee, US | |
3312605 | 3312605 | 2022-11-23 | US | Alabama | DeKalb | 1049 | 21485 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-24 04:21:09 | DeKalb, Alabama, US | |
1623745 | 1623745 | 2022-11-22 | US | Washington | Whatcom | 53073 | 47484 | 343 | 0 | 48.82227976 | -121.7490018 | 2022-11-23 04:21:06 | Whatcom, Washington, US | |
1623209 | 1623209 | 2022-11-22 | US | Tennessee | Cumberland | 47035 | 18889 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-11-23 04:21:06 | Cumberland, Tennessee, US | |
1620646 | 1620646 | 2022-11-22 | US | Alabama | DeKalb | 1049 | 21462 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-23 04:21:06 | DeKalb, Alabama, US | |
3463633 | 3463633 | 2022-11-21 | US | Washington | Whatcom | 53073 | 47484 | 343 | 0 | 48.82227976 | -121.7490018 | 2022-11-22 04:20:47 | Whatcom, Washington, US | |
3463097 | 3463097 | 2022-11-21 | US | Tennessee | Cumberland | 47035 | 18877 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-11-22 04:20:47 | Cumberland, Tennessee, US | |
3460534 | 3460534 | 2022-11-21 | US | Alabama | DeKalb | 1049 | 21462 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-22 04:20:47 | DeKalb, Alabama, US | |
1643818 | 1643818 | 2022-11-20 | US | Washington | Whatcom | 53073 | 47484 | 343 | 0 | 48.82227976 | -121.7490018 | 2022-11-21 04:21:05 | Whatcom, Washington, US | |
1643282 | 1643282 | 2022-11-20 | US | Tennessee | Cumberland | 47035 | 18871 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-11-21 04:21:05 | Cumberland, Tennessee, US | |
1640719 | 1640719 | 2022-11-20 | US | Alabama | DeKalb | 1049 | 21462 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-21 04:21:05 | DeKalb, Alabama, US | |
2067375 | 2067375 | 2022-11-19 | US | Washington | Whatcom | 53073 | 47484 | 343 | 0 | 48.82227976 | -121.7490018 | 2022-11-20 04:21:08 | Whatcom, Washington, US | |
2066839 | 2066839 | 2022-11-19 | US | Tennessee | Cumberland | 47035 | 18871 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-11-20 04:21:08 | Cumberland, Tennessee, US | |
2064276 | 2064276 | 2022-11-19 | US | Alabama | DeKalb | 1049 | 21462 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-20 04:21:08 | DeKalb, Alabama, US | |
1758769 | 1758769 | 2022-11-18 | US | Washington | Whatcom | 53073 | 47484 | 343 | 0 | 48.82227976 | -121.7490018 | 2022-11-19 04:21:14 | Whatcom, Washington, US | |
1758233 | 1758233 | 2022-11-18 | US | Tennessee | Cumberland | 47035 | 18867 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-11-19 04:21:14 | Cumberland, Tennessee, US | |
1755670 | 1755670 | 2022-11-18 | US | Alabama | DeKalb | 1049 | 21462 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-19 04:21:14 | DeKalb, Alabama, US | |
3029762 | 3029762 | 2022-11-17 | US | Washington | Whatcom | 53073 | 47484 | 343 | 0 | 48.82227976 | -121.7490018 | 2022-11-18 04:21:15 | Whatcom, Washington, US | |
3029226 | 3029226 | 2022-11-17 | US | Tennessee | Cumberland | 47035 | 18859 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-11-18 04:21:15 | Cumberland, Tennessee, US | |
3026663 | 3026663 | 2022-11-17 | US | Alabama | DeKalb | 1049 | 21462 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-18 04:21:15 | DeKalb, Alabama, US | |
2489473 | 2489473 | 2022-11-16 | US | Washington | Whatcom | 53073 | 47484 | 343 | 0 | 48.82227976 | -121.7490018 | 2022-11-17 04:21:11 | Whatcom, Washington, US | |
2488937 | 2488937 | 2022-11-16 | US | Tennessee | Cumberland | 47035 | 18855 | 343 | 0 | 35.95271721 | -84.99840585 | 2022-11-17 04:21:11 | Cumberland, Tennessee, US | |
2486374 | 2486374 | 2022-11-16 | US | Alabama | DeKalb | 1049 | 21462 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-17 04:21:11 | DeKalb, Alabama, US | |
294283 | 294283 | 2022-11-15 | US | New York | Schenectady | 36093 | 41774 | 343 | 0 | 42.81668777 | -74.05278291 | 2022-11-16 04:21:09 | Schenectady, New York, US | |
292385 | 292385 | 2022-11-15 | US | Alabama | DeKalb | 1049 | 21433 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-16 04:21:09 | DeKalb, Alabama, US | |
3599313 | 3599313 | 2022-11-14 | US | New York | Schenectady | 36093 | 41764 | 343 | 0 | 42.81668777 | -74.05278291 | 2022-11-15 04:21:16 | Schenectady, New York, US | |
3597786 | 3597786 | 2022-11-14 | US | Florida | Suwannee | 12121 | 15176 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-11-15 04:21:16 | Suwannee, Florida, US | |
3597415 | 3597415 | 2022-11-14 | US | Alabama | DeKalb | 1049 | 21433 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-15 04:21:16 | DeKalb, Alabama, US | |
312644 | 312644 | 2022-11-13 | US | Florida | Suwannee | 12121 | 15176 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-11-14 04:21:09 | Suwannee, Florida, US | |
312273 | 312273 | 2022-11-13 | US | Alabama | DeKalb | 1049 | 21433 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-14 04:21:09 | DeKalb, Alabama, US | |
63805 | 63805 | 2022-11-12 | US | Florida | Suwannee | 12121 | 15176 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-11-13 04:21:14 | Suwannee, Florida, US | |
63434 | 63434 | 2022-11-12 | US | Alabama | DeKalb | 1049 | 21433 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-13 04:21:14 | DeKalb, Alabama, US | |
2927967 | 2927967 | 2022-11-11 | US | Florida | Suwannee | 12121 | 15176 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-11-12 04:20:41 | Suwannee, Florida, US | |
2927596 | 2927596 | 2022-11-11 | US | Alabama | DeKalb | 1049 | 21433 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-12 04:20:41 | DeKalb, Alabama, US | |
2506803 | 2506803 | 2022-11-10 | US | Florida | Suwannee | 12121 | 15176 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-11-11 04:21:22 | Suwannee, Florida, US | |
2506432 | 2506432 | 2022-11-10 | US | Alabama | DeKalb | 1049 | 21433 | 343 | 0 | 34.45946862 | -85.80782906 | 2022-11-11 04:21:22 | DeKalb, Alabama, US | |
2431678 | 2431678 | 2022-11-09 | US | Florida | Suwannee | 12121 | 15176 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-11-10 04:21:16 | Suwannee, Florida, US | |
480334 | 480334 | 2022-11-08 | US | Florida | Suwannee | 12121 | 15176 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-11-09 04:21:22 | Suwannee, Florida, US | |
479577 | 479577 | 2022-11-08 | Japan | Aomori | 179989 | 343 | 0 | 40.781541 | 140.828896 | 2022-11-09 04:21:22 | Aomori, Japan | |||
2439484 | 2439484 | 2022-11-07 | US | Florida | Suwannee | 12121 | 15176 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-11-08 04:21:21 | Suwannee, Florida, US | |
1050582 | 1050582 | 2022-11-06 | US | Florida | Suwannee | 12121 | 15176 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-11-07 04:21:26 | Suwannee, Florida, US | |
618606 | 618606 | 2022-11-05 | US | Florida | Suwannee | 12121 | 15176 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-11-06 04:21:24 | Suwannee, Florida, US | |
1023110 | 1023110 | 2022-11-04 | US | Florida | Suwannee | 12121 | 15176 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-11-05 04:21:52 | Suwannee, Florida, US | |
432101 | 432101 | 2022-11-03 | US | Florida | Suwannee | 12121 | 15134 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-11-04 04:22:11 | Suwannee, Florida, US | |
852151 | 852151 | 2022-11-02 | US | Oklahoma | Creek | 40037 | 21121 | 343 | 0 | 35.90230551 | -96.37086028 | 2022-11-03 04:22:05 | Creek, Oklahoma, US | |
850343 | 850343 | 2022-11-02 | US | Florida | Suwannee | 12121 | 15134 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-11-03 04:22:05 | Suwannee, Florida, US | |
713002 | 713002 | 2022-11-01 | US | Oklahoma | Creek | 40037 | 21121 | 343 | 0 | 35.90230551 | -96.37086028 | 2022-11-02 04:22:09 | Creek, Oklahoma, US | |
711194 | 711194 | 2022-11-01 | US | Florida | Suwannee | 12121 | 15134 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-11-02 04:22:09 | Suwannee, Florida, US | |
3287451 | 3287451 | 2022-10-31 | US | Oklahoma | Creek | 40037 | 21121 | 343 | 0 | 35.90230551 | -96.37086028 | 2022-11-01 04:22:36 | Creek, Oklahoma, US | |
3285643 | 3285643 | 2022-10-31 | US | Florida | Suwannee | 12121 | 15134 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-11-01 04:22:36 | Suwannee, Florida, US | |
322484 | 322484 | 2022-10-30 | US | Oklahoma | Creek | 40037 | 21121 | 343 | 0 | 35.90230551 | -96.37086028 | 2022-10-31 04:21:36 | Creek, Oklahoma, US | |
320676 | 320676 | 2022-10-30 | US | Florida | Suwannee | 12121 | 15134 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-10-31 04:21:36 | Suwannee, Florida, US | |
914760 | 914760 | 2022-10-29 | US | Oklahoma | Creek | 40037 | 21121 | 343 | 0 | 35.90230551 | -96.37086028 | 2022-10-30 04:22:14 | Creek, Oklahoma, US | |
912952 | 912952 | 2022-10-29 | US | Florida | Suwannee | 12121 | 15134 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-10-30 04:22:14 | Suwannee, Florida, US | |
1369029 | 1369029 | 2022-10-28 | US | Oklahoma | Creek | 40037 | 21121 | 343 | 0 | 35.90230551 | -96.37086028 | 2022-10-29 04:21:13 | Creek, Oklahoma, US | |
1367221 | 1367221 | 2022-10-28 | US | Florida | Suwannee | 12121 | 15134 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-10-29 04:21:13 | Suwannee, Florida, US | |
3041921 | 3041921 | 2022-10-27 | US | Wisconsin | Sheboygan | 55117 | 37515 | 343 | 0 | 43.72099677 | -87.94579284 | 2022-10-28 04:22:31 | Sheboygan, Wisconsin, US | |
3040884 | 3040884 | 2022-10-27 | US | Oklahoma | Creek | 40037 | 21121 | 343 | 0 | 35.90230551 | -96.37086028 | 2022-10-28 04:22:31 | Creek, Oklahoma, US | |
3039076 | 3039076 | 2022-10-27 | US | Florida | Suwannee | 12121 | 15134 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-10-28 04:22:31 | Suwannee, Florida, US | |
542341 | 542341 | 2022-10-26 | US | Wisconsin | Sheboygan | 55117 | 37496 | 343 | 0 | 43.72099677 | -87.94579284 | 2022-10-27 04:22:01 | Sheboygan, Wisconsin, US | |
541304 | 541304 | 2022-10-26 | US | Oklahoma | Creek | 40037 | 21063 | 343 | 0 | 35.90230551 | -96.37086028 | 2022-10-27 04:22:01 | Creek, Oklahoma, US | |
539496 | 539496 | 2022-10-26 | US | Florida | Suwannee | 12121 | 15134 | 343 | 0 | 30.19746066 | -82.9909967 | 2022-10-27 04:22:01 | Suwannee, Florida, US | |
1833742 | 1833742 | 2022-10-25 | US | Wisconsin | Sheboygan | 55117 | 37471 | 343 | 0 | 43.72099677 | -87.94579284 | 2022-10-26 04:22:19 | Sheboygan, Wisconsin, US | |
1833461 | 1833461 | 2022-10-25 | US | Virginia | Arlington | 51013 | 61822 | 343 | 0 | 38.8767675 | -77.10139853 | 2022-10-26 04:22:19 | Arlington, Virginia, US | |
1832822 | 1832822 | 2022-10-25 | US | Pennsylvania | Crawford | 42039 | 23369 | 343 | 0 | 41.68447709 | -80.10760592 | 2022-10-26 04:22:19 | Crawford, Pennsylvania, US | |
1832705 | 1832705 | 2022-10-25 | US | Oklahoma | Creek | 40037 | 21063 | 343 | 0 | 35.90230551 | -96.37086028 | 2022-10-26 04:22:19 | 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]);