johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
297 rows where confirmed = 2739 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- US 273
- France 10
- Japan 2
- Ukraine 2
- Colombia 1
- India 1
- Jordan 1
- Malaysia 1
- Mexico 1
- Netherlands 1
- Sierra Leone 1
- Slovakia 1
- Spain 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2557557 | 2557557 | 2022-11-29 | US | Illinois | Brown | 17009 | 2739 | 17 | 0 | 39.96209138 | -90.75068024 | 2022-11-30 04:21:07 | Brown, Illinois, US | |
1621078 | 1621078 | 2022-11-22 | US | Georgia | Evans | 13109 | 2739 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-11-23 04:21:06 | Evans, Georgia, US | |
3460966 | 3460966 | 2022-11-21 | US | Georgia | Evans | 13109 | 2739 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-11-22 04:20:47 | Evans, Georgia, US | |
1641151 | 1641151 | 2022-11-20 | US | Georgia | Evans | 13109 | 2739 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-11-21 04:21:05 | Evans, Georgia, US | |
2064708 | 2064708 | 2022-11-19 | US | Georgia | Evans | 13109 | 2739 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-11-20 04:21:08 | Evans, Georgia, US | |
1756102 | 1756102 | 2022-11-18 | US | Georgia | Evans | 13109 | 2739 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-11-19 04:21:14 | Evans, Georgia, US | |
3027095 | 3027095 | 2022-11-17 | US | Georgia | Evans | 13109 | 2739 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-11-18 04:21:15 | Evans, Georgia, US | |
2486806 | 2486806 | 2022-11-16 | US | Georgia | Evans | 13109 | 2739 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-11-17 04:21:11 | Evans, Georgia, US | |
2757768 | 2757768 | 2022-10-18 | US | Georgia | McIntosh | 13191 | 2739 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-10-19 04:22:26 | McIntosh, Georgia, US | |
2025602 | 2025602 | 2022-10-17 | US | Georgia | McIntosh | 13191 | 2739 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-10-18 04:22:42 | McIntosh, Georgia, US | |
2160380 | 2160380 | 2022-10-16 | US | Georgia | McIntosh | 13191 | 2739 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-10-17 04:20:31 | McIntosh, Georgia, US | |
516577 | 516577 | 2022-10-15 | US | Georgia | McIntosh | 13191 | 2739 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-10-16 04:22:39 | McIntosh, Georgia, US | |
2033634 | 2033634 | 2022-10-14 | US | Georgia | McIntosh | 13191 | 2739 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-10-15 04:22:00 | McIntosh, Georgia, US | |
3754322 | 3754322 | 2022-10-13 | US | Georgia | McIntosh | 13191 | 2739 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-10-14 04:22:28 | McIntosh, Georgia, US | |
3215147 | 3215147 | 2022-10-12 | US | Georgia | McIntosh | 13191 | 2739 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-10-13 04:22:39 | McIntosh, Georgia, US | |
3250996 | 3250996 | 2022-10-11 | US | Georgia | McIntosh | 13191 | 2739 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-10-12 04:22:51 | McIntosh, Georgia, US | |
2968255 | 2968255 | 2022-10-10 | US | Georgia | McIntosh | 13191 | 2739 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-10-11 04:23:05 | McIntosh, Georgia, US | |
3098291 | 3098291 | 2022-10-09 | US | Georgia | McIntosh | 13191 | 2739 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-10-10 04:22:32 | McIntosh, Georgia, US | |
4003516 | 4003516 | 2022-10-08 | US | Georgia | McIntosh | 13191 | 2739 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-10-09 04:21:16 | McIntosh, Georgia, US | |
397113 | 397113 | 2022-10-07 | US | Georgia | McIntosh | 13191 | 2739 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-10-08 04:22:56 | McIntosh, Georgia, US | |
2530230 | 2530230 | 2022-10-06 | US | Georgia | McIntosh | 13191 | 2739 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-10-07 04:23:08 | McIntosh, Georgia, US | |
1811624 | 1811624 | 2022-10-05 | US | Georgia | McIntosh | 13191 | 2739 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-10-06 04:21:22 | McIntosh, Georgia, US | |
3995440 | 3995440 | 2022-09-27 | US | Georgia | Evans | 13109 | 2739 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-09-28 04:23:01 | Evans, Georgia, US | |
2769768 | 2769768 | 2022-09-26 | US | Georgia | Evans | 13109 | 2739 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-09-27 04:23:01 | Evans, Georgia, US | |
1977421 | 1977421 | 2022-09-25 | US | Georgia | Evans | 13109 | 2739 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-09-26 04:20:52 | Evans, Georgia, US | |
2650588 | 2650588 | 2022-09-24 | US | Georgia | Evans | 13109 | 2739 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-09-25 04:23:31 | Evans, Georgia, US | |
385028 | 385028 | 2022-09-23 | US | Georgia | Evans | 13109 | 2739 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-09-24 04:21:40 | Evans, Georgia, US | |
1625094 | 1625094 | 2022-09-22 | US | Georgia | Evans | 13109 | 2739 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-09-23 04:23:13 | Evans, Georgia, US | |
1371298 | 1371298 | 2022-09-21 | US | Georgia | Evans | 13109 | 2739 | 67 | 0 | 32.15328841 | -81.8870105 | 2022-09-22 04:22:56 | Evans, Georgia, US | |
3745716 | 3745716 | 2022-09-07 | US | Colorado | Bent | 8011 | 2739 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-09-08 04:21:02 | Bent, Colorado, US | |
3776639 | 3776639 | 2022-08-30 | US | Puerto Rico | Ceiba | 72037 | 2739 | 0 | 0 | 18.251818 | -65.666416 | 2022-08-31 04:20:57 | Ceiba, Puerto Rico, US | |
1683235 | 1683235 | 2022-08-29 | US | Puerto Rico | Ceiba | 72037 | 2739 | 0 | 0 | 18.251818 | -65.666416 | 2022-08-30 04:21:03 | Ceiba, Puerto Rico, US | |
3909942 | 3909942 | 2022-08-11 | US | Missouri | Montgomery | 29139 | 2739 | 58 | 0 | 38.94022054 | -91.47000721 | 2022-08-12 04:20:54 | Montgomery, Missouri, US | |
1348259 | 1348259 | 2022-08-10 | US | Missouri | Montgomery | 29139 | 2739 | 58 | 0 | 38.94022054 | -91.47000721 | 2022-08-11 04:20:49 | Montgomery, Missouri, US | |
1088014 | 1088014 | 2022-08-09 | US | Missouri | Montgomery | 29139 | 2739 | 58 | 0 | 38.94022054 | -91.47000721 | 2022-08-10 04:20:57 | Montgomery, Missouri, US | |
3545429 | 3545429 | 2022-08-08 | US | Missouri | Montgomery | 29139 | 2739 | 58 | 0 | 38.94022054 | -91.47000721 | 2022-08-09 04:20:34 | Montgomery, Missouri, US | |
1071832 | 1071832 | 2022-08-07 | US | Missouri | Montgomery | 29139 | 2739 | 58 | 0 | 38.94022054 | -91.47000721 | 2022-08-08 04:21:08 | Montgomery, Missouri, US | |
1942420 | 1942420 | 2022-08-06 | US | Missouri | Montgomery | 29139 | 2739 | 58 | 0 | 38.94022054 | -91.47000721 | 2022-08-07 04:20:54 | Montgomery, Missouri, US | |
882219 | 882219 | 2022-08-05 | US | Missouri | Montgomery | 29139 | 2739 | 58 | 0 | 38.94022054 | -91.47000721 | 2022-08-06 04:20:56 | Montgomery, Missouri, US | |
1407458 | 1407458 | 2022-08-02 | US | North Dakota | Mercer | 38057 | 2739 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-08-03 04:20:59 | Mercer, North Dakota, US | |
1067906 | 1067906 | 2022-07-28 | US | Montana | Rosebud | 30087 | 2739 | 61 | 0 | 46.23397237 | -106.729288 | 2022-07-29 04:20:45 | Rosebud, Montana, US | |
2337425 | 2337425 | 2022-07-27 | US | Montana | Rosebud | 30087 | 2739 | 61 | 0 | 46.23397237 | -106.729288 | 2022-07-28 04:20:56 | Rosebud, Montana, US | |
1489615 | 1489615 | 2022-07-26 | US | Montana | Rosebud | 30087 | 2739 | 61 | 0 | 46.23397237 | -106.729288 | 2022-07-27 04:21:04 | Rosebud, Montana, US | |
2596061 | 2596061 | 2022-07-25 | US | Montana | Rosebud | 30087 | 2739 | 61 | 0 | 46.23397237 | -106.729288 | 2022-07-26 04:20:58 | Rosebud, Montana, US | |
898176 | 898176 | 2022-07-24 | US | Montana | Rosebud | 30087 | 2739 | 61 | 0 | 46.23397237 | -106.729288 | 2022-07-25 04:20:51 | Rosebud, Montana, US | |
897652 | 897652 | 2022-07-24 | US | Louisiana | East Carroll | 22035 | 2739 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-07-25 04:20:51 | East Carroll, Louisiana, US | |
93170 | 93170 | 2022-07-23 | US | Montana | Rosebud | 30087 | 2739 | 61 | 0 | 46.23397237 | -106.729288 | 2022-07-24 04:20:47 | Rosebud, Montana, US | |
92646 | 92646 | 2022-07-23 | US | Louisiana | East Carroll | 22035 | 2739 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-07-24 04:20:47 | East Carroll, Louisiana, US | |
903213 | 903213 | 2022-07-22 | US | Texas | Childress | 48075 | 2739 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-07-23 04:20:53 | Childress, Texas, US | |
902192 | 902192 | 2022-07-22 | US | Montana | Rosebud | 30087 | 2739 | 61 | 0 | 46.23397237 | -106.729288 | 2022-07-23 04:20:53 | Rosebud, Montana, US | |
901668 | 901668 | 2022-07-22 | US | Louisiana | East Carroll | 22035 | 2739 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-07-23 04:20:53 | East Carroll, Louisiana, US | |
3211404 | 3211404 | 2022-07-18 | US | Indiana | Newton | 18111 | 2739 | 69 | 0 | 40.95610449 | -87.39635768 | 2022-07-19 04:20:58 | Newton, Indiana, US | |
2743019 | 2743019 | 2022-07-07 | US | Montana | Jefferson | 30043 | 2739 | 25 | 0 | 46.14907081 | -112.094396 | 2022-07-08 04:20:56 | Jefferson, Montana, US | |
1201814 | 1201814 | 2022-07-06 | US | Montana | Jefferson | 30043 | 2739 | 25 | 0 | 46.14907081 | -112.094396 | 2022-07-07 04:20:55 | Jefferson, Montana, US | |
3968557 | 3968557 | 2022-07-05 | US | Montana | Jefferson | 30043 | 2739 | 25 | 0 | 46.14907081 | -112.094396 | 2022-07-06 04:20:58 | Jefferson, Montana, US | |
3080068 | 3080068 | 2022-07-04 | US | Montana | Jefferson | 30043 | 2739 | 25 | 0 | 46.14907081 | -112.094396 | 2022-07-05 04:20:45 | Jefferson, Montana, US | |
1769350 | 1769350 | 2022-07-03 | US | Montana | Jefferson | 30043 | 2739 | 25 | 0 | 46.14907081 | -112.094396 | 2022-07-04 04:20:54 | Jefferson, Montana, US | |
3367336 | 3367336 | 2022-07-02 | US | Montana | Jefferson | 30043 | 2739 | 25 | 0 | 46.14907081 | -112.094396 | 2022-07-03 04:20:59 | Jefferson, Montana, US | |
596615 | 596615 | 2022-07-01 | US | Tennessee | Houston | 47083 | 2739 | 62 | 0 | 36.28872054 | -87.71878828 | 2022-07-02 04:21:16 | Houston, Tennessee, US | |
595665 | 595665 | 2022-07-01 | US | Montana | Jefferson | 30043 | 2739 | 25 | 0 | 46.14907081 | -112.094396 | 2022-07-02 04:21:16 | Jefferson, Montana, US | |
167005 | 167005 | 2022-06-21 | US | Idaho | Valley | 16085 | 2739 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-06-22 04:20:54 | Valley, Idaho, US | |
1764288 | 1764288 | 2022-06-20 | US | Idaho | Valley | 16085 | 2739 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-06-21 04:20:56 | Valley, Idaho, US | |
3270474 | 3270474 | 2022-06-19 | US | Idaho | Valley | 16085 | 2739 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-06-20 04:21:01 | Valley, Idaho, US | |
3398386 | 3398386 | 2022-06-18 | US | Idaho | Valley | 16085 | 2739 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-06-19 04:20:51 | Valley, Idaho, US | |
2312263 | 2312263 | 2022-06-17 | US | Idaho | Valley | 16085 | 2739 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-06-18 04:21:10 | Valley, Idaho, US | |
3200915 | 3200915 | 2022-05-29 | US | Puerto Rico | Rincon | 72117 | 2739 | 0 | 0 | 18.335443 | -67.23174 | 2022-05-30 04:20:50 | Rincon, Puerto Rico, US | |
1852209 | 1852209 | 2022-05-26 | US | New Mexico | Torrance | 35057 | 2739 | 57 | 0 | 34.64048375 | -105.8508949 | 2022-05-27 04:20:56 | Torrance, New Mexico, US | |
3000571 | 3000571 | 2022-05-24 | US | Kansas | Brown | 20013 | 2739 | 48 | 0 | 39.82652589 | -95.56421698 | 2022-05-25 04:20:56 | Brown, Kansas, US | |
3000102 | 3000102 | 2022-05-24 | US | Georgia | Early | 13099 | 2739 | 62 | 0 | 31.32155345 | -84.90255207 | 2022-05-25 04:20:56 | Early, Georgia, US | |
3595440 | 3595440 | 2022-05-23 | US | North Dakota | McLean | 38055 | 2739 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-05-24 04:20:57 | McLean, North Dakota, US | |
3594292 | 3594292 | 2022-05-23 | US | Kansas | Brown | 20013 | 2739 | 48 | 0 | 39.82652589 | -95.56421698 | 2022-05-24 04:20:57 | Brown, Kansas, US | |
3593823 | 3593823 | 2022-05-23 | US | Georgia | Early | 13099 | 2739 | 62 | 0 | 31.32155345 | -84.90255207 | 2022-05-24 04:20:57 | Early, Georgia, US | |
1110840 | 1110840 | 2022-05-21 | US | Kansas | Brown | 20013 | 2739 | 48 | 0 | 39.82652589 | -95.56421698 | 2022-05-22 04:20:52 | Brown, Kansas, US | |
1110371 | 1110371 | 2022-05-21 | US | Georgia | Early | 13099 | 2739 | 62 | 0 | 31.32155345 | -84.90255207 | 2022-05-22 04:20:52 | Early, Georgia, US | |
1170464 | 1170464 | 2022-05-20 | US | Kansas | Brown | 20013 | 2739 | 48 | 0 | 39.82652589 | -95.56421698 | 2022-05-21 04:20:58 | Brown, Kansas, US | |
1169995 | 1169995 | 2022-05-20 | US | Georgia | Early | 13099 | 2739 | 62 | 0 | 31.32155345 | -84.90255207 | 2022-05-21 04:20:58 | Early, Georgia, US | |
3897227 | 3897227 | 2022-05-19 | US | Kansas | Brown | 20013 | 2739 | 48 | 0 | 39.82652589 | -95.56421698 | 2022-05-20 04:20:57 | Brown, Kansas, US | |
3896758 | 3896758 | 2022-05-19 | US | Georgia | Early | 13099 | 2739 | 62 | 0 | 31.32155345 | -84.90255207 | 2022-05-20 04:20:57 | Early, Georgia, US | |
3895846 | 3895846 | 2022-05-19 | France | Saint Pierre and Miquelon | 2739 | 1 | 0 | 46.8852 | -56.3159 | 2022-05-20 04:20:57 | Saint Pierre and Miquelon, France | |||
1186011 | 1186011 | 2022-05-18 | US | Kansas | Brown | 20013 | 2739 | 48 | 0 | 39.82652589 | -95.56421698 | 2022-05-19 04:20:54 | Brown, Kansas, US | |
1185542 | 1185542 | 2022-05-18 | US | Georgia | Early | 13099 | 2739 | 62 | 0 | 31.32155345 | -84.90255207 | 2022-05-19 04:20:54 | Early, Georgia, US | |
1184630 | 1184630 | 2022-05-18 | France | Saint Pierre and Miquelon | 2739 | 1 | 0 | 46.8852 | -56.3159 | 2022-05-19 04:20:54 | Saint Pierre and Miquelon, France | |||
3582527 | 3582527 | 2022-05-17 | France | Saint Pierre and Miquelon | 2739 | 1 | 0 | 46.8852 | -56.3159 | 2022-05-18 04:20:50 | Saint Pierre and Miquelon, France | |||
1503484 | 1503484 | 2022-05-16 | France | Saint Pierre and Miquelon | 2739 | 1 | 0 | 46.8852 | -56.3159 | 2022-05-17 04:20:59 | Saint Pierre and Miquelon, France | |||
2083843 | 2083843 | 2022-05-15 | France | Saint Pierre and Miquelon | 2739 | 1 | 0 | 46.8852 | -56.3159 | 2022-05-16 04:20:47 | Saint Pierre and Miquelon, France | |||
3354554 | 3354554 | 2022-05-14 | France | Saint Pierre and Miquelon | 2739 | 1 | 0 | 46.8852 | -56.3159 | 2022-05-15 04:20:53 | Saint Pierre and Miquelon, France | |||
658199 | 658199 | 2022-05-13 | France | Saint Pierre and Miquelon | 2739 | 1 | 0 | 46.8852 | -56.3159 | 2022-05-14 04:20:48 | Saint Pierre and Miquelon, France | |||
2533282 | 2533282 | 2022-05-12 | France | Saint Pierre and Miquelon | 2739 | 1 | 0 | 46.8852 | -56.3159 | 2022-05-13 04:20:51 | Saint Pierre and Miquelon, France | |||
3444728 | 3444728 | 2022-05-11 | France | Saint Pierre and Miquelon | 2739 | 1 | 0 | 46.8852 | -56.3159 | 2022-05-12 04:20:54 | Saint Pierre and Miquelon, France | |||
3536416 | 3536416 | 2022-05-10 | US | Idaho | Shoshone | 16079 | 2739 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-05-11 04:20:48 | Shoshone, Idaho, US | |
3535345 | 3535345 | 2022-05-10 | France | Saint Pierre and Miquelon | 2739 | 1 | 0 | 46.8852 | -56.3159 | 2022-05-11 04:20:48 | Saint Pierre and Miquelon, France | |||
224055 | 224055 | 2022-05-09 | US | Nebraska | Colfax | 31037 | 2739 | 27 | 0 | 41.57486951 | -97.0868542 | 2022-05-10 04:20:50 | Colfax, Nebraska, US | |
222951 | 222951 | 2022-05-09 | US | Idaho | Shoshone | 16079 | 2739 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-05-10 04:20:50 | Shoshone, Idaho, US | |
2333440 | 2333440 | 2022-05-08 | US | Nebraska | Colfax | 31037 | 2739 | 27 | 0 | 41.57486951 | -97.0868542 | 2022-05-09 04:20:54 | Colfax, Nebraska, US | |
2332336 | 2332336 | 2022-05-08 | US | Idaho | Shoshone | 16079 | 2739 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-05-09 04:20:54 | Shoshone, Idaho, US | |
362402 | 362402 | 2022-05-07 | US | Nebraska | Colfax | 31037 | 2739 | 27 | 0 | 41.57486951 | -97.0868542 | 2022-05-08 04:20:49 | Colfax, Nebraska, US | |
361298 | 361298 | 2022-05-07 | US | Idaho | Shoshone | 16079 | 2739 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-05-08 04:20:49 | Shoshone, Idaho, US | |
1399753 | 1399753 | 2022-05-06 | US | Nebraska | Colfax | 31037 | 2739 | 27 | 0 | 41.57486951 | -97.0868542 | 2022-05-07 04:21:09 | Colfax, Nebraska, US | |
1398649 | 1398649 | 2022-05-06 | US | Idaho | Shoshone | 16079 | 2739 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-05-07 04:21:09 | Shoshone, Idaho, US | |
2600781 | 2600781 | 2022-05-05 | US | Puerto Rico | Ciales | 72039 | 2739 | 0 | 0 | 18.28885 | -66.516475 | 2022-05-06 04:21:00 | Ciales, Puerto Rico, 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]);