johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
40 rows where active = 4368 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2589996 | 2589996 | 2021-06-27 | Italy | Sicilia | 231371 | 5965 | 221038 | 4368 | 38.11569725 | 13.362356699999998 | 2021-06-28 04:21:29 | Sicilia, Italy | ||
2187140 | 2187140 | 2021-02-26 | US | Wisconsin | Monroe | 55081 | 4400 | 32 | 0 | 4368 | 43.94641218 | -90.618819 | 2021-02-27 05:22:28 | Monroe, Wisconsin, US |
2285770 | 2285770 | 2021-02-14 | US | North Carolina | Pender | 37141 | 4419 | 51 | 0 | 4368 | 34.52265624 | -77.90352133 | 2021-02-15 05:24:49 | Pender, North Carolina, US |
343375 | 343375 | 2021-02-03 | US | Texas | Hardin | 48199 | 3703 | 81 | 0 | 4368 | 30.33364686 | -94.38931817 | 2021-02-04 05:22:26 | Hardin, Texas, US |
341486 | 341486 | 2021-02-03 | US | Iowa | Marshall | 19127 | 4436 | 68 | 0 | 4368 | 42.03586837 | -92.9990819 | 2021-02-04 05:22:26 | Marshall, Iowa, US |
1685490 | 1685490 | 2021-02-02 | US | Illinois | Jackson | 17077 | 4427 | 59 | 0 | 4368 | 37.78595185 | -89.38232563 | 2021-02-03 05:22:52 | Jackson, Illinois, US |
2214248 | 2214248 | 2021-01-30 | US | Oklahoma | Pontotoc | 40123 | 4406 | 38 | 0 | 4368 | 34.72959848 | -96.68337199 | 2021-01-31 05:22:42 | Pontotoc, Oklahoma, US |
911471 | 911471 | 2021-01-19 | US | Virginia | Augusta | 51015 | 4410 | 42 | 0 | 4368 | 38.16404586 | -79.12461614 | 2021-01-20 05:21:54 | Augusta, Virginia, US |
3880186 | 3880186 | 2021-01-14 | US | Colorado | Garfield | 8045 | 4642 | 38 | 0 | 4368 | 39.59921777 | -107.902708 | 2021-01-15 05:22:24 | Garfield, Colorado, US |
3900729 | 3900729 | 2021-01-09 | US | Georgia | Coffee | 13069 | 4469 | 101 | 0 | 4368 | 31.54892966 | -82.85492059999999 | 2021-01-10 05:22:12 | Coffee, Georgia, US |
2543942 | 2543942 | 2021-01-07 | US | Oklahoma | Creek | 40037 | 4438 | 70 | 0 | 4368 | 35.90230551 | -96.37086028 | 2021-01-08 05:22:42 | Creek, Oklahoma, US |
3037090 | 3037090 | 2021-01-05 | US | Rhode Island | Washington | 44009 | 4482 | 114 | 0 | 4368 | 41.45961631 | -71.61435303 | 2021-01-06 05:22:16 | Washington, Rhode Island, US |
1064635 | 1064635 | 2021-01-04 | US | Rhode Island | Washington | 44009 | 4482 | 114 | 0 | 4368 | 41.45961631 | -71.61435303 | 2021-01-05 05:21:49 | Washington, Rhode Island, US |
3233238 | 3233238 | 2021-01-03 | US | Rhode Island | Washington | 44009 | 4482 | 114 | 0 | 4368 | 41.45961631 | -71.61435303 | 2021-01-04 05:22:02 | Washington, Rhode Island, US |
2230307 | 2230307 | 2021-01-02 | US | Rhode Island | Washington | 44009 | 4482 | 114 | 0 | 4368 | 41.45961631 | -71.61435303 | 2021-01-03 05:22:52 | Washington, Rhode Island, US |
1139671 | 1139671 | 2021-01-01 | US | Rhode Island | Washington | 44009 | 4482 | 114 | 0 | 4368 | 41.45961631 | -71.61435303 | 2021-01-02 05:22:33 | Washington, Rhode Island, US |
3698277 | 3698277 | 2020-12-31 | US | Rhode Island | Washington | 44009 | 4482 | 114 | 0 | 4368 | 41.45961631 | -71.61435303 | 2021-01-01 05:23:07 | Washington, Rhode Island, US |
1013092 | 1013092 | 2020-12-30 | US | Rhode Island | Washington | 44009 | 4482 | 114 | 0 | 4368 | 41.45961631 | -71.61435303 | 2020-12-31 05:22:49 | Washington, Rhode Island, US |
3765214 | 3765214 | 2020-12-28 | Ukraine | Rivne Oblast | 40332 | 499 | 35465 | 4368 | 50.6199 | 26.2516 | 2020-12-29 05:22:37 | Rivne Oblast, Ukraine | ||
3762109 | 3762109 | 2020-12-28 | US | Arkansas | White | 5145 | 4436 | 68 | 0 | 4368 | 35.25688493 | -91.74908296 | 2020-12-29 05:22:37 | White, Arkansas, US |
1753670 | 1753670 | 2020-12-14 | US | North Dakota | Morton | 38059 | 4425 | 81 | 0 | 4368 | 46.71681782 | -101.2822377 | 2020-12-15 05:26:38 | Morton, North Dakota, US |
925922 | 925922 | 2020-11-26 | US | New York | Oneida | 36065 | 4515 | 147 | 0 | 4368 | 43.24375382 | -75.43710392 | 2020-11-27 05:26:53 | Oneida, New York, US |
678974 | 678974 | 2020-11-23 | US | Delaware | Kent | 10001 | 4498 | 130 | 0 | 4368 | 39.08646628 | -75.56884914 | 2020-11-24 05:27:31 | Kent, Delaware, US |
3189959 | 3189959 | 2020-11-22 | India | Uttarakhand | 71256 | 1155 | 65733 | 4368 | 30.156447 | 79.197608 | 2020-11-23 05:25:26 | Uttarakhand, India | ||
3169943 | 3169943 | 2020-11-16 | Sweden | Dalarna | 4554 | 186 | 0 | 4368 | 61.0917 | 14.6664 | 2020-11-17 05:25:54 | Dalarna, Sweden | ||
3169636 | 3169636 | 2020-11-16 | Jamaica | 9929 | 231 | 5330 | 4368 | 18.1096 | -77.2975 | 2020-11-17 05:25:54 | Jamaica | |||
2880511 | 2880511 | 2020-11-15 | Sweden | Dalarna | 4554 | 186 | 0 | 4368 | 61.0917 | 14.6664 | 2020-11-16 05:25:57 | Dalarna, Sweden | ||
2915489 | 2915489 | 2020-11-14 | Sweden | Dalarna | 4554 | 186 | 0 | 4368 | 61.0917 | 14.6664 | 2020-11-15 05:26:53 | Dalarna, Sweden | ||
2785311 | 2785311 | 2020-11-13 | Sweden | Dalarna | 4554 | 186 | 0 | 4368 | 61.0917 | 14.6664 | 2020-11-14 05:25:37 | Dalarna, Sweden | ||
2784742 | 2784742 | 2020-11-13 | Brazil | Distrito Federal | 219012 | 3808 | 210836 | 4368 | -15.7998 | -47.8645 | 2020-11-14 05:25:37 | Distrito Federal, Brazil | ||
379467 | 379467 | 2020-11-06 | US | Virginia | Alexandria | 51510 | 4444 | 76 | 0 | 4368 | 38.814003 | -77.08183073 | 2020-11-07 05:24:52 | Alexandria, Virginia, US |
3413099 | 3413099 | 2020-11-01 | Venezuela | 92325 | 801 | 87156 | 4368 | 6.4238 | -66.5897 | 2020-11-02 05:25:04 | Venezuela | |||
2243095 | 2243095 | 2020-10-30 | Australia | New South Wales | 4421 | 53 | 0 | 4368 | -33.8688 | 151.2093 | 2020-10-31 04:24:44 | New South Wales, Australia | ||
1179121 | 1179121 | 2020-10-22 | US | Michigan | Ingham | 26065 | 4430 | 62 | 0 | 4368 | 42.59716886 | -84.37472069 | 2020-10-23 04:24:46 | Ingham, Michigan, US |
1029985 | 1029985 | 2020-10-17 | Ukraine | Zaporizhia Oblast | 6259 | 95 | 1796 | 4368 | 47.8388 | 35.1396 | 2020-10-18 04:24:25 | Zaporizhia Oblast, Ukraine | ||
1556091 | 1556091 | 2020-08-16 | Netherlands | Limburg | 5144 | 757 | 0 | 4368 | 51.209227 | 5.93387 | 2020-08-17 04:27:20 | Limburg, Netherlands | ||
750602 | 750602 | 2020-08-01 | US | Georgia | Clayton | 13063 | 4468 | 100 | 0 | 4368 | 33.54187245 | -84.35594188 | 2020-08-02 04:34:47 | Clayton, Georgia, US |
529905 | 529905 | 2020-07-04 | Russia | Krasnoyarsk Krai | 9452 | 164 | 4920 | 4368 | 63.3233807 | 97.0979974 | 2020-07-05 04:33:46 | Krasnoyarsk Krai, Russia | ||
3246855 | 3246855 | 2020-06-21 | US | Texas | El Paso | 48141 | 2357 | 120 | 0 | 4368 | 31.76980765 | -106.23632749999999 | 2020-06-22 04:33:20 | El Paso, Texas, US |
1281315 | 1281315 | 2020-06-04 | US | Puerto Rico | 72 | 4508 | 140 | 0 | 4368 | 18.2208 | -66.5901 | 2020-06-05 02:33:06 | 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]);