johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where active = 4252 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3385327 | 3385327 | 2021-07-29 | India | Arunachal Pradesh | 47477 | 225 | 43000 | 4252 | 27.768456 | 96.384277 | 2021-07-30 04:21:34 | Arunachal Pradesh, India | ||
280427 | 280427 | 2021-02-24 | Russia | Saratov Oblast | 48704 | 633 | 43819 | 4252 | 51.6520555 | 46.86319520000001 | 2021-02-25 05:24:57 | Saratov Oblast, Russia | ||
1939093 | 1939093 | 2021-02-23 | US | Pennsylvania | Bradford | 42015 | 4327 | 75 | 0 | 4252 | 41.78869215 | -76.51570822 | 2021-02-24 05:29:16 | Bradford, Pennsylvania, US |
473701 | 473701 | 2021-02-19 | US | North Carolina | Carteret | 37031 | 4295 | 43 | 0 | 4252 | 34.8932941 | -76.54120135 | 2021-02-20 05:22:51 | Carteret, North Carolina, US |
3053739 | 3053739 | 2021-02-16 | US | Wisconsin | Pierce | 55093 | 4291 | 39 | 0 | 4252 | 44.71850291 | -92.4224416 | 2021-02-17 05:23:10 | Pierce, Wisconsin, US |
1530401 | 1530401 | 2021-02-09 | US | Ohio | Shelby | 39149 | 4334 | 82 | 0 | 4252 | 40.33163494 | -84.20258189 | 2021-02-10 05:22:41 | Shelby, Ohio, US |
792977 | 792977 | 2021-02-04 | US | Oklahoma | Washington | 40147 | 4329 | 77 | 0 | 4252 | 36.71380786 | -95.90514104 | 2021-02-05 05:22:38 | Washington, Oklahoma, US |
1687089 | 1687089 | 2021-02-02 | US | Oklahoma | Stephens | 40137 | 4303 | 51 | 0 | 4252 | 34.48556989 | -97.85141892 | 2021-02-03 05:22:52 | Stephens, Oklahoma, US |
1462195 | 1462195 | 2021-01-31 | US | Ohio | Belmont | 39013 | 4403 | 151 | 0 | 4252 | 40.01625942 | -80.9924051 | 2021-02-01 05:22:53 | Belmont, Ohio, US |
2484398 | 2484398 | 2021-01-28 | US | North Dakota | Williams | 38105 | 4276 | 35 | 0 | 4252 | 48.34522353 | -103.4793387 | 2021-01-29 05:22:23 | Williams, North Dakota, US |
2569628 | 2569628 | 2021-01-25 | US | Missouri | Taney | 29213 | 4320 | 68 | 0 | 4252 | 36.65465345 | -93.04075153 | 2021-01-26 05:22:02 | Taney, Missouri, US |
2626941 | 2626941 | 2021-01-10 | US | Indiana | Dearborn | 18029 | 4301 | 49 | 0 | 4252 | 39.14647946 | -84.97333539 | 2021-01-11 05:21:50 | Dearborn, Indiana, US |
3900178 | 3900178 | 2021-01-09 | Russia | Lipetsk Oblast | 17522 | 290 | 12980 | 4252 | 52.6935178 | 39.1122664 | 2021-01-10 05:22:12 | Lipetsk Oblast, Russia | ||
3036907 | 3036907 | 2021-01-05 | US | Oregon | Deschutes | 41017 | 4276 | 24 | 0 | 4252 | 43.91570171 | -121.2289121 | 2021-01-06 05:22:16 | Deschutes, Oregon, US |
3762335 | 3762335 | 2020-12-28 | US | Georgia | Bulloch | 13031 | 4309 | 57 | 0 | 4252 | 32.39577406 | -81.74811421 | 2020-12-29 05:22:37 | Bulloch, Georgia, US |
931144 | 931144 | 2020-12-21 | US | Washington | Thurston | 53067 | 4302 | 50 | 0 | 4252 | 46.9291895 | -122.8290656 | 2020-12-22 05:22:33 | Thurston, Washington, US |
2932717 | 2932717 | 2020-12-19 | US | Louisiana | Iberia | 22045 | 4366 | 114 | 0 | 4252 | 29.86803617 | -91.75871777 | 2020-12-20 05:27:32 | Iberia, Louisiana, US |
1902663 | 1902663 | 2020-12-18 | US | Louisiana | Iberia | 22045 | 4366 | 114 | 0 | 4252 | 29.86803617 | -91.75871777 | 2020-12-19 05:27:52 | Iberia, Louisiana, US |
1584196 | 1584196 | 2020-11-30 | Japan | Osaka | 20270 | 320 | 15698 | 4252 | 34.620965000000005 | 135.507481 | 2020-12-01 05:26:18 | Osaka, Japan | ||
2935484 | 2935484 | 2020-11-28 | Russia | Tyumen Oblast | 17945 | 131 | 13562 | 4252 | 58.8206488 | 70.36588370000001 | 2020-11-29 05:25:55 | Tyumen Oblast, Russia | ||
394860 | 394860 | 2020-11-27 | US | Oregon | Umatilla | 41059 | 4301 | 49 | 0 | 4252 | 45.59073056 | -118.7353826 | 2020-11-28 05:25:50 | Umatilla, Oregon, US |
275813 | 275813 | 2020-11-10 | Venezuela | 95445 | 834 | 90359 | 4252 | 6.4238 | -66.5897 | 2020-11-11 05:25:30 | Venezuela | |||
1990617 | 1990617 | 2020-11-09 | US | Montana | Flathead | 30029 | 4279 | 27 | 0 | 4252 | 48.29575866 | -114.0520569 | 2020-11-10 05:40:07 | Flathead, Montana, US |
2920657 | 2920657 | 2020-11-04 | US | Louisiana | Ascension | 22005 | 4352 | 100 | 0 | 4252 | 30.20406249 | -90.91328409999998 | 2020-11-05 06:05:03 | Ascension, Louisiana, US |
2919390 | 2919390 | 2020-11-04 | Russia | Khanty-Mansi Autonomous Okrug | 29043 | 261 | 24530 | 4252 | 61.0259025 | 69.0982628 | 2020-11-05 06:05:03 | Khanty-Mansi Autonomous Okrug, Russia | ||
2243277 | 2243277 | 2020-10-30 | Finland | 16224 | 349 | 11300 | 4252 | 61.92411 | 25.748151 | 2020-10-31 04:24:44 | Finland | |||
765948 | 765948 | 2020-10-18 | Ukraine | Zhytomyr Oblast | 9787 | 170 | 5365 | 4252 | 50.2547 | 28.6587 | 2020-10-19 04:24:16 | Zhytomyr Oblast, Ukraine | ||
3391535 | 3391535 | 2020-10-02 | US | New Jersey | Atlantic | 34001 | 4508 | 256 | 0 | 4252 | 39.47538693 | -74.65848483 | 2020-10-03 04:23:40 | Atlantic, New Jersey, US |
666923 | 666923 | 2020-09-16 | US | Colorado | Weld | 8123 | 4605 | 144 | 0 | 4252 | 40.55499405 | -104.3929621 | 2020-09-17 04:22:00 | Weld, Colorado, US |
430965 | 430965 | 2020-09-07 | Ukraine | Zakarpattia Oblast | 8091 | 271 | 3568 | 4252 | 48.6208 | 22.2879 | 2020-09-08 04:28:25 | Zakarpattia Oblast, Ukraine | ||
2807466 | 2807466 | 2020-08-02 | US | Virginia | Virginia Beach | 51810 | 4299 | 47 | 0 | 4252 | 36.73285734 | -76.04566934 | 2020-08-03 04:34:35 | Virginia Beach, Virginia, US |
3433241 | 3433241 | 2020-07-11 | US | Texas | Collin | 48085 | 4045 | 56 | 0 | 4252 | 33.18820114 | -96.57264368 | 2020-07-12 04:34:30 | Collin, Texas, US |
2221723 | 2221723 | 2020-07-08 | US | South Carolina | Richland | 45079 | 4344 | 92 | 0 | 4252 | 34.01791263 | -80.90267209 | 2020-07-09 04:34:23 | Richland, South Carolina, US |
2685307 | 2685307 | 2020-07-06 | Sudan | 9767 | 616 | 4899 | 4252 | 12.8628 | 30.2176 | 2020-07-07 04:34:00 | Sudan | |||
1273573 | 1273573 | 2020-06-11 | Canada | Ontario | 32059 | 2487 | 26358 | 4252 | 51.2538 | -85.3232 | 2020-06-12 05:09:52 | Ontario, Canada | ||
217003 | 217003 | 2020-06-08 | Peru | Arequipa | 4494 | 242 | 0 | 4252 | -15.843524 | -72.475539 | 2020-06-09 03:33:03 | Arequipa, Peru | ||
1827385 | 1827385 | 2020-05-16 | US | Ohio | Franklin | 39049 | 4420 | 168 | 0 | 4252 | 39.96995815 | -83.01115755 | 2020-05-17 02:32:32 | Franklin, Ohio, US |
2875788 | 2875788 | 2020-03-29 | Norway | 4284 | 25 | 7 | 4252 | 60.472 | 8.4689 | 3/29/20 23:08 | Norway |
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]);