johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
57 rows where active = 3725 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2071911 | 2071911 | 2021-07-02 | Italy | Sicilia | 231948 | 5979 | 222244 | 3725 | 38.11569725 | 13.362356699999998 | 2021-07-03 04:21:37 | Sicilia, Italy | ||
2717117 | 2717117 | 2021-06-10 | Pakistan | Khyber Pakhtunkhwa | 135383 | 4194 | 127464 | 3725 | 34.485332 | 72.09169 | 2021-06-11 04:23:20 | Khyber Pakhtunkhwa, Pakistan | ||
3701902 | 3701902 | 2021-04-27 | Chile | Maule | 69318 | 1168 | 64425 | 3725 | -35.5183 | -71.6885 | 2021-04-28 04:20:32 | Maule, Chile | ||
2055793 | 2055793 | 2021-03-15 | Germany | Brandenburg | 80226 | 3150 | 73455 | 3725 | 52.4125 | 12.5316 | 2021-03-16 05:25:13 | Brandenburg, Germany | ||
2371104 | 2371104 | 2021-02-28 | US | Wyoming | Sweetwater | 56037 | 3759 | 34 | 0 | 3725 | 41.65943896 | -108.8827882 | 2021-03-01 05:23:01 | Sweetwater, Wyoming, US |
3068996 | 3068996 | 2021-02-27 | US | Tennessee | Weakley | 47183 | 3782 | 59 | 0 | 3725 | 36.29896232 | -88.71990865 | 2021-02-28 05:22:20 | Weakley, Tennessee, US |
183376 | 183376 | 2021-02-21 | US | Kansas | Seward | 20175 | 3759 | 34 | 0 | 3725 | 37.19324632 | -100.8507201 | 2021-02-22 05:24:21 | Seward, Kansas, US |
743794 | 743794 | 2021-02-20 | US | Louisiana | Avoyelles | 22009 | 3842 | 117 | 0 | 3725 | 31.07796211 | -92.00079449 | 2021-02-21 05:24:33 | Avoyelles, Louisiana, US |
743650 | 743650 | 2021-02-20 | US | Kansas | Seward | 20175 | 3759 | 34 | 0 | 3725 | 37.19324632 | -100.8507201 | 2021-02-21 05:24:33 | Seward, Kansas, US |
472892 | 472892 | 2021-02-19 | US | Louisiana | Avoyelles | 22009 | 3842 | 117 | 0 | 3725 | 31.07796211 | -92.00079449 | 2021-02-20 05:22:51 | Avoyelles, Louisiana, US |
472748 | 472748 | 2021-02-19 | US | Kansas | Seward | 20175 | 3759 | 34 | 0 | 3725 | 37.19324632 | -100.8507201 | 2021-02-20 05:22:51 | Seward, Kansas, US |
472481 | 472481 | 2021-02-19 | US | Indiana | DeKalb | 18033 | 3802 | 77 | 0 | 3725 | 41.39804622 | -84.99906934 | 2021-02-20 05:22:51 | DeKalb, Indiana, US |
2285633 | 2285633 | 2021-02-14 | US | New Mexico | Unassigned | 90035 | 3725 | 0 | 0 | 3725 | 36.60569702 | -108.7151824 | 2021-02-15 05:24:49 | Unassigned, New Mexico, US |
2678183 | 2678183 | 2021-02-13 | US | Alabama | Covington | 1039 | 3822 | 97 | 0 | 3725 | 31.2477854 | -86.45050893 | 2021-02-14 05:23:43 | Covington, Alabama, US |
614475 | 614475 | 2021-02-08 | US | Georgia | Effingham | 13103 | 3776 | 51 | 0 | 3725 | 32.36616021 | -81.34280942 | 2021-02-09 05:23:30 | Effingham, Georgia, US |
1673244 | 1673244 | 2021-02-07 | US | Georgia | Effingham | 13103 | 3775 | 50 | 0 | 3725 | 32.36616021 | -81.34280942 | 2021-02-08 05:22:39 | Effingham, Georgia, US |
975909 | 975909 | 2021-02-06 | US | Illinois | Jefferson | 17081 | 3836 | 111 | 0 | 3725 | 38.29980057 | -88.9240025 | 2021-02-07 05:23:00 | Jefferson, Illinois, US |
793744 | 793744 | 2021-02-04 | US | Virginia | Manassas | 51683 | 3758 | 33 | 0 | 3725 | 38.7464321 | -77.48509905 | 2021-02-05 05:22:38 | Manassas, Virginia, US |
342013 | 342013 | 2021-02-03 | US | Minnesota | Nobles | 27105 | 3772 | 47 | 0 | 3725 | 43.67434621 | -95.75329576 | 2021-02-04 05:22:26 | Nobles, Minnesota, US |
2569495 | 2569495 | 2021-01-25 | US | Mississippi | Pontotoc | 28115 | 3785 | 60 | 0 | 3725 | 34.226046000000004 | -89.03636807 | 2021-01-26 05:22:02 | Pontotoc, Mississippi, US |
2568031 | 2568031 | 2021-01-25 | US | Alabama | Franklin | 1059 | 3775 | 50 | 0 | 3725 | 34.44235334 | -87.84289505 | 2021-01-26 05:22:02 | Franklin, Alabama, US |
1759296 | 1759296 | 2021-01-24 | Japan | Aichi | 22863 | 364 | 18774 | 3725 | 35.035551 | 137.211621 | 2021-01-25 05:22:16 | Aichi, Japan | ||
436197 | 436197 | 2021-01-21 | US | Georgia | Murray | 13213 | 3772 | 47 | 0 | 3725 | 34.78897608 | -84.74993177 | 2021-01-22 05:22:10 | Murray, Georgia, US |
239820 | 239820 | 2021-01-18 | US | Oklahoma | Pittsburg | 40121 | 3750 | 25 | 0 | 3725 | 34.92065823 | -95.7513432 | 2021-01-19 05:22:15 | Pittsburg, Oklahoma, US |
3103610 | 3103610 | 2021-01-16 | US | New Jersey | Salem | 34033 | 3850 | 125 | 0 | 3725 | 39.58719656 | -75.34696629999998 | 2021-01-17 05:22:17 | Salem, New Jersey, US |
3881906 | 3881906 | 2021-01-14 | US | North Carolina | McDowell | 37111 | 3764 | 39 | 0 | 3725 | 35.67736232 | -82.0482425 | 2021-01-15 05:22:24 | McDowell, North Carolina, US |
190069 | 190069 | 2021-01-11 | Japan | Aichi | 19638 | 279 | 15634 | 3725 | 35.035551 | 137.211621 | 2021-01-12 05:22:15 | Aichi, Japan | ||
1012173 | 1012173 | 2020-12-30 | US | Missouri | Callaway | 29027 | 3745 | 20 | 0 | 3725 | 38.83674754 | -91.92186505 | 2020-12-31 05:22:49 | Callaway, Missouri, US |
1011374 | 1011374 | 2020-12-30 | US | Indiana | Dearborn | 18029 | 3772 | 47 | 0 | 3725 | 39.14647946 | -84.97333539 | 2020-12-31 05:22:49 | Dearborn, Indiana, US |
3764601 | 3764601 | 2020-12-28 | US | Texas | Bowie | 48037 | 4205 | 119 | 0 | 3725 | 33.44626922 | -94.41834132 | 2020-12-29 05:22:37 | Bowie, Texas, US |
3780921 | 3780921 | 2020-12-27 | US | Texas | Bowie | 48037 | 4182 | 119 | 0 | 3725 | 33.44626922 | -94.41834132 | 2020-12-28 05:22:06 | Bowie, Texas, US |
2121271 | 2121271 | 2020-12-20 | US | Maine | York | 23031 | 3773 | 48 | 0 | 3725 | 43.47808377 | -70.71052375 | 2020-12-21 05:27:58 | York, Maine, US |
2128538 | 2128538 | 2020-12-17 | US | California | Lassen | 6035 | 3922 | 5 | 0 | 3725 | 40.67311306 | -120.59350990000002 | 2020-12-18 05:28:18 | Lassen, California, US |
1037297 | 1037297 | 2020-12-15 | US | Tennessee | Dickson | 47043 | 3820 | 48 | 0 | 3725 | 36.14669837 | -87.35891709 | 2020-12-16 05:28:04 | Dickson, Tennessee, US |
1036589 | 1036589 | 2020-12-15 | US | New York | Chemung | 36015 | 3803 | 78 | 0 | 3725 | 42.13891056 | -76.7638805 | 2020-12-16 05:28:04 | Chemung, New York, US |
1601322 | 1601322 | 2020-12-10 | US | Indiana | Marshall | 18099 | 3789 | 64 | 0 | 3725 | 41.32467367 | -86.26185087 | 2020-12-11 05:26:59 | Marshall, Indiana, US |
1635236 | 1635236 | 2020-12-05 | US | Tennessee | Hamblen | 47063 | 3754 | 63 | 0 | 3725 | 36.21990035 | -83.26586179 | 2020-12-06 05:26:18 | Hamblen, Tennessee, US |
3862116 | 3862116 | 2020-12-04 | US | North Carolina | Caldwell | 37027 | 3750 | 25 | 0 | 3725 | 35.95204977 | -81.54799522 | 2020-12-05 05:27:36 | Caldwell, North Carolina, US |
740002 | 740002 | 2020-12-02 | US | Minnesota | Crow Wing | 27035 | 3762 | 37 | 0 | 3725 | 46.48096553 | -94.06755609 | 2020-12-03 05:28:22 | Crow Wing, Minnesota, US |
2538625 | 2538625 | 2020-12-01 | US | Iowa | Sioux | 19167 | 3751 | 26 | 0 | 3725 | 43.08221074 | -96.1767568 | 2020-12-02 05:27:41 | Sioux, Iowa, US |
2538444 | 2538444 | 2020-12-01 | US | Illinois | Whiteside | 17195 | 3808 | 83 | 0 | 3725 | 41.75509713 | -89.91556058 | 2020-12-02 05:27:41 | Whiteside, Illinois, US |
394775 | 394775 | 2020-11-27 | US | Oklahoma | Garfield | 40047 | 3762 | 37 | 0 | 3725 | 36.3791334 | -97.78265517 | 2020-11-28 05:25:50 | Garfield, Oklahoma, US |
925996 | 925996 | 2020-11-26 | US | North Carolina | Harnett | 37085 | 3802 | 77 | 0 | 3725 | 35.36731853 | -78.87243571 | 2020-11-27 05:26:53 | Harnett, North Carolina, US |
1974901 | 1974901 | 2020-11-25 | US | North Carolina | Harnett | 37085 | 3802 | 77 | 0 | 3725 | 35.36731853 | -78.87243571 | 2020-11-26 05:27:44 | Harnett, North Carolina, US |
2704498 | 2704498 | 2020-11-20 | US | Tennessee | Unassigned | 90047 | 2944 | 13 | 0 | 3725 | 36.55606529 | 0.0 | 2020-11-21 05:25:51 | Unassigned, Tennessee, US |
2701837 | 2701837 | 2020-11-20 | Syria | 7079 | 368 | 2986 | 3725 | 34.802075 | 38.99681500000001 | 2020-11-21 05:25:51 | Syria | |||
1546541 | 1546541 | 2020-11-07 | US | Oregon | Clackamas | 41005 | 3796 | 71 | 0 | 3725 | 45.18787398 | -122.2179634 | 2020-11-08 05:24:56 | Clackamas, Oregon, US |
2500684 | 2500684 | 2020-11-03 | US | Pennsylvania | Lackawanna | 42069 | 3945 | 220 | 0 | 3725 | 41.43564672 | -75.60379201 | 2020-11-04 05:25:09 | Lackawanna, Pennsylvania, US |
2498229 | 2498229 | 2020-11-03 | Russia | Komi Republic | 14084 | 231 | 10128 | 3725 | 63.9881421 | 54.3326073 | 2020-11-04 05:25:09 | Komi Republic, Russia | ||
3994157 | 3994157 | 2020-10-20 | US | Wisconsin | Marathon | 55073 | 3763 | 38 | 0 | 3725 | 44.89792533 | -89.75863384 | 2020-10-21 04:24:14 | Marathon, Wisconsin, US |
3392037 | 3392037 | 2020-10-02 | US | Pennsylvania | Dauphin | 42043 | 3907 | 182 | 0 | 3725 | 40.41377078 | -76.77993242 | 2020-10-03 04:23:40 | Dauphin, Pennsylvania, US |
2606464 | 2606464 | 2020-09-24 | US | Arizona | Mohave | 4015 | 3947 | 222 | 0 | 3725 | 35.70471703 | -113.7577902 | 2020-09-25 04:23:00 | Mohave, Arizona, US |
195214 | 195214 | 2020-08-31 | US | Iowa | Black Hawk | 19013 | 3800 | 75 | 0 | 3725 | 42.4704581 | -92.30524729 | 2020-09-01 04:28:31 | Black Hawk, Iowa, US |
3792266 | 3792266 | 2020-08-05 | US | California | Solano | 6095 | 3752 | 29 | 0 | 3725 | 38.26827353 | -121.9357113 | 2020-08-06 04:35:02 | Solano, California, US |
2956963 | 2956963 | 2020-07-29 | US | New Mexico | McKinley | 35031 | 3942 | 217 | 0 | 3725 | 35.58007720000001 | -108.262245 | 2020-07-30 04:35:05 | McKinley, New Mexico, US |
2548291 | 2548291 | 2020-05-27 | Brazil | Rondonia | 3862 | 137 | 0 | 3725 | -11.5057 | -63.5806 | 2020-05-28 02:32:31 | Rondonia, Brazil | ||
3459611 | 3459611 | 2020-05-10 | Afghanistan | 4402 | 119 | 558 | 3725 | 33.93911 | 67.709953 | 2020-05-11 02:32:30 | Afghanistan |
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]);