johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
54 rows where active = 3675 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 40
- Somalia 2
- Armenia 1
- Germany 1
- India 1
- Italy 1
- Japan 1
- Kyrgyzstan 1
- Nepal 1
- Netherlands 1
- North Macedonia 1
- Russia 1
- Spain 1
- Sweden 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015288 | 3015288 | 2021-08-01 | India | Arunachal Pradesh | 48260 | 231 | 44354 | 3675 | 27.768456 | 96.384277 | 2021-08-02 04:21:36 | Arunachal Pradesh, India | ||
1165405 | 1165405 | 2021-07-04 | Russia | Penza Oblast | 50369 | 1107 | 45587 | 3675 | 53.1655415 | 44.78791810000001 | 2021-07-05 04:21:28 | Penza Oblast, Russia | ||
1495596 | 1495596 | 2021-07-03 | Italy | Sicilia | 232082 | 5979 | 222428 | 3675 | 38.11569725 | 13.362356699999998 | 2021-07-04 04:21:38 | Sicilia, Italy | ||
646081 | 646081 | 2021-05-05 | Netherlands | Unknown | 2844 | 20 | 0 | 3675 | 2021-05-06 04:20:38 | Unknown, Netherlands | ||||
3242382 | 3242382 | 2021-04-21 | Kyrgyzstan | 92626 | 1561 | 87390 | 3675 | 41.20438 | 74.766098 | 2021-04-22 04:20:53 | Kyrgyzstan | |||
1302093 | 1302093 | 2021-04-01 | Japan | Tokyo | 121461 | 1774 | 116012 | 3675 | 35.711343 | 139.446921 | 2021-04-02 04:20:36 | Tokyo, Japan | ||
3668145 | 3668145 | 2021-03-06 | US | Arkansas | Union | 5139 | 3776 | 101 | 0 | 3675 | 33.16887091 | -92.59746952 | 2021-03-07 05:21:54 | Union, Arkansas, US |
1619572 | 1619572 | 2021-03-05 | US | Virginia | Franklin | 51067 | 3733 | 58 | 0 | 3675 | 36.99536167 | -79.88023649 | 2021-03-06 04:23:41 | Franklin, Virginia, US |
1616523 | 1616523 | 2021-03-05 | Somalia | 7850 | 274 | 3901 | 3675 | 5.152149 | 46.199616 | 2021-03-06 04:23:41 | Somalia | |||
2207934 | 2207934 | 2021-03-04 | Somalia | 7850 | 274 | 3901 | 3675 | 5.152149 | 46.199616 | 2021-03-05 05:26:29 | Somalia | |||
999065 | 999065 | 2021-03-01 | US | Colorado | Logan | 8075 | 3826 | 66 | 0 | 3675 | 40.7249637 | -103.110817 | 2021-03-02 05:23:30 | Logan, Colorado, US |
282822 | 282822 | 2021-02-24 | US | Pennsylvania | Bedford | 42009 | 3804 | 129 | 0 | 3675 | 40.00522157 | -78.48998442 | 2021-02-25 05:24:57 | Bedford, Pennsylvania, US |
280103 | 280103 | 2021-02-24 | Germany | Sachsen-Anhalt | 59049 | 2339 | 53575 | 3675 | 51.9503 | 11.6923 | 2021-02-25 05:24:57 | Sachsen-Anhalt, Germany | ||
2680101 | 2680101 | 2021-02-13 | US | North Carolina | Alexander | 37003 | 3746 | 71 | 0 | 3675 | 35.922379600000006 | -81.17751948 | 2021-02-14 05:23:43 | Alexander, North Carolina, US |
2679234 | 2679234 | 2021-02-13 | US | Kentucky | Hopkins | 21107 | 3796 | 121 | 0 | 3675 | 37.30939025 | -87.54670406 | 2021-02-14 05:23:43 | Hopkins, Kentucky, US |
792861 | 792861 | 2021-02-04 | US | Ohio | Madison | 39097 | 3728 | 53 | 0 | 3675 | 39.89381073 | -83.40178317 | 2021-02-05 05:22:38 | Madison, Ohio, US |
792211 | 792211 | 2021-02-04 | US | Mississippi | Pearl River | 28109 | 3791 | 116 | 0 | 3675 | 30.77090935 | -89.58677275 | 2021-02-05 05:22:38 | Pearl River, Mississippi, US |
341266 | 341266 | 2021-02-03 | US | Illinois | Jefferson | 17081 | 3783 | 108 | 0 | 3675 | 38.29980057 | -88.9240025 | 2021-02-04 05:22:26 | Jefferson, Illinois, US |
2212707 | 2212707 | 2021-01-30 | US | Illinois | Stephenson | 17177 | 3739 | 64 | 0 | 3675 | 42.35129217 | -89.662598 | 2021-01-31 05:22:42 | Stephenson, Illinois, US |
1900179 | 1900179 | 2021-01-29 | US | Texas | Brown | 48049 | 4005 | 89 | 0 | 3675 | 31.77430356 | -98.99907113 | 2021-01-30 05:22:49 | Brown, Texas, US |
436659 | 436659 | 2021-01-21 | US | Kansas | Lyon | 20111 | 3743 | 68 | 0 | 3675 | 38.45576156 | -96.15275715 | 2021-01-22 05:22:10 | Lyon, Kansas, US |
1095390 | 1095390 | 2021-01-20 | US | Kansas | Lyon | 20111 | 3743 | 68 | 0 | 3675 | 38.45576156 | -96.15275715 | 2021-01-21 05:22:01 | Lyon, Kansas, US |
1095117 | 1095117 | 2021-01-20 | US | Illinois | Randolph | 17157 | 3738 | 63 | 0 | 3675 | 38.05095369 | -89.82512254 | 2021-01-21 05:22:01 | Randolph, Illinois, US |
909883 | 909883 | 2021-01-19 | US | Minnesota | Douglas | 27041 | 3741 | 66 | 0 | 3675 | 45.93348491 | -95.45335469 | 2021-01-20 05:21:54 | Douglas, Minnesota, US |
3901135 | 3901135 | 2021-01-09 | US | Iowa | Des Moines | 19057 | 3713 | 38 | 0 | 3675 | 40.92012606 | -91.18326592 | 2021-01-10 05:22:12 | Des Moines, Iowa, US |
157512 | 157512 | 2021-01-08 | US | Wisconsin | Douglas | 55031 | 3705 | 30 | 0 | 3675 | 46.43222285 | -91.91595768 | 2021-01-09 05:22:18 | Douglas, Wisconsin, US |
155752 | 155752 | 2021-01-08 | US | Minnesota | Winona | 27169 | 3720 | 45 | 0 | 3675 | 43.98772283 | -91.78081305 | 2021-01-09 05:22:18 | Winona, Minnesota, US |
1013314 | 1013314 | 2020-12-30 | US | Texas | Bastrop | 48021 | 3940 | 45 | 0 | 3675 | 30.10370699 | -97.31206354 | 2020-12-31 05:22:49 | Bastrop, Texas, US |
3770646 | 3770646 | 2020-12-22 | US | Georgia | Coffee | 13069 | 3758 | 83 | 0 | 3675 | 31.54892966 | -82.85492059999999 | 2020-12-23 05:22:03 | Coffee, Georgia, US |
1753424 | 1753424 | 2020-12-14 | US | New Jersey | Cape May | 34009 | 3798 | 123 | 0 | 3675 | 39.15008829 | -74.80170244 | 2020-12-15 05:26:38 | Cape May, New Jersey, US |
1635482 | 1635482 | 2020-12-05 | US | Texas | Orange | 48361 | 2491 | 54 | 0 | 3675 | 30.11879481 | -93.89412775 | 2020-12-06 05:26:18 | Orange, Texas, US |
1634567 | 1634567 | 2020-12-05 | US | New York | Ulster | 36111 | 3773 | 98 | 0 | 3675 | 41.89027881 | -74.26252104 | 2020-12-06 05:26:18 | Ulster, New York, US |
3860613 | 3860613 | 2020-12-04 | US | Georgia | Dougherty | 13095 | 3880 | 205 | 0 | 3675 | 31.53328528 | -84.21722377 | 2020-12-05 05:27:36 | Dougherty, Georgia, US |
394111 | 394111 | 2020-11-27 | US | Missouri | Christian | 29043 | 3698 | 23 | 0 | 3675 | 36.9711783 | -93.18537118 | 2020-11-28 05:25:50 | Christian, Missouri, US |
1973338 | 1973338 | 2020-11-25 | US | Georgia | Bulloch | 13031 | 3728 | 53 | 0 | 3675 | 32.39577406 | -81.74811421 | 2020-11-26 05:27:44 | Bulloch, Georgia, US |
2788435 | 2788435 | 2020-11-13 | US | Washington | Grant | 53025 | 3704 | 29 | 0 | 3675 | 47.20753737 | -119.4500749 | 2020-11-14 05:25:37 | Grant, Washington, US |
1544417 | 1544417 | 2020-11-07 | US | Arkansas | Faulkner | 5045 | 3719 | 44 | 0 | 3675 | 35.14719007 | -92.33717519 | 2020-11-08 05:24:56 | Faulkner, Arkansas, US |
3783534 | 3783534 | 2020-10-13 | US | Michigan | Kalamazoo | 26077 | 3773 | 98 | 0 | 3675 | 42.24542231 | -85.53038622 | 2020-10-14 04:24:05 | Kalamazoo, Michigan, US |
2605001 | 2605001 | 2020-10-10 | US | Tennessee | Putnam | 47141 | 3661 | 50 | 0 | 3675 | 36.14005459 | -85.50646123 | 2020-10-11 04:23:46 | Putnam, Tennessee, US |
970126 | 970126 | 2020-09-29 | US | Texas | Walker | 48471 | 4623 | 57 | 0 | 3675 | 30.73872995 | -95.57440968 | 2020-09-30 04:23:33 | Walker, Texas, US |
1518551 | 1518551 | 2020-09-28 | US | Texas | Midland | 48329 | 2899 | 84 | 0 | 3675 | 31.86904128 | -102.0315682 | 2020-09-29 04:23:42 | Midland, Texas, US |
2454480 | 2454480 | 2020-09-19 | Armenia | 47154 | 928 | 42551 | 3675 | 40.0691 | 45.0382 | 2020-09-20 04:22:00 | Armenia | |||
2061498 | 2061498 | 2020-09-01 | US | Michigan | Genesee | 26049 | 3980 | 305 | 0 | 3675 | 43.02244215 | -83.70589709 | 2020-09-02 04:28:25 | Genesee, Michigan, US |
3532494 | 3532494 | 2020-08-12 | US | Illinois | Winnebago | 17201 | 3806 | 131 | 0 | 3675 | 42.33641854 | -89.16085327 | 2020-08-13 04:29:15 | Winnebago, Illinois, US |
662613 | 662613 | 2020-08-11 | Sweden | Skane | 3949 | 274 | 0 | 3675 | 55.9903 | 13.5958 | 2020-08-12 04:27:29 | Skane, Sweden | ||
1920107 | 1920107 | 2020-08-10 | US | Iowa | Woodbury | 19193 | 3727 | 52 | 0 | 3675 | 42.38979414 | -96.0459439 | 2020-08-11 04:35:08 | Woodbury, Iowa, US |
1917040 | 1917040 | 2020-08-10 | US | Alabama | Baldwin | 1003 | 3700 | 25 | 0 | 3675 | 30.72774991 | -87.72207058 | 2020-08-11 04:35:08 | Baldwin, Alabama, US |
2808343 | 2808343 | 2020-08-02 | North Macedonia | 11054 | 497 | 6882 | 3675 | 41.6086 | 21.7453 | 2020-08-03 04:34:35 | North Macedonia | |||
3262748 | 3262748 | 2020-07-31 | US | Tennessee | Knox | 47093 | 4034 | 30 | 0 | 3675 | 35.99508821 | -83.94635435 | 2020-08-01 04:36:27 | Knox, Tennessee, US |
118642 | 118642 | 2020-07-19 | US | New Mexico | Bernalillo | 35001 | 3775 | 100 | 0 | 3675 | 35.05163625 | -106.6703554 | 2020-07-20 05:34:40 | Bernalillo, New Mexico, US |
2705388 | 2705388 | 2020-07-17 | US | Arkansas | Benton | 5007 | 3699 | 24 | 0 | 3675 | 36.33644656 | -94.25680817 | 2020-07-18 04:34:45 | Benton, Arkansas, US |
285448 | 285448 | 2020-06-15 | US | Pennsylvania | Lehigh | 42077 | 3944 | 269 | 0 | 3675 | 40.6154815 | -75.59435245 | 2020-06-16 04:33:09 | Lehigh, Pennsylvania, US |
2864305 | 2864305 | 2020-06-10 | Nepal | 4364 | 15 | 674 | 3675 | 28.1667 | 84.25 | 2020-06-11 03:33:41 | Nepal | |||
2390161 | 2390161 | 2020-05-19 | Spain | La Rioja | 4027 | 352 | 0 | 3675 | 42.2871 | -2.5396 | 2020-05-20 02:32:19 | La Rioja, Spain |
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]);