johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
28 rows where active = 5122 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
332052 | 332052 | 2021-08-04 | Pakistan | Khyber Pakhtunkhwa | 146485 | 4495 | 136868 | 5122 | 34.485332 | 72.09169 | 2021-08-05 04:21:51 | Khyber Pakhtunkhwa, Pakistan | ||
1330495 | 1330495 | 2021-07-24 | Russia | Smolensk Oblast | 40142 | 1280 | 33740 | 5122 | 55.03434960000001 | 33.0192065 | 2021-07-25 04:22:12 | Smolensk Oblast, Russia | ||
1165409 | 1165409 | 2021-07-04 | Russia | Rostov Oblast | 100318 | 4702 | 90494 | 5122 | 47.6222451 | 40.7957942 | 2021-07-05 04:21:28 | Rostov Oblast, Russia | ||
3030258 | 3030258 | 2021-06-16 | India | Tripura | 60872 | 634 | 55116 | 5122 | 23.746783 | 91.743565 | 2021-06-17 04:22:36 | Tripura, India | ||
3421157 | 3421157 | 2021-03-19 | Russia | Rostov Oblast | 77948 | 3369 | 69457 | 5122 | 47.6222451 | 40.7957942 | 2021-03-20 05:25:46 | Rostov Oblast, Russia | ||
1617225 | 1617225 | 2021-03-05 | US | Illinois | Grundy | 17063 | 5185 | 63 | 0 | 5122 | 41.28569601 | -88.41905692 | 2021-03-06 04:23:41 | Grundy, Illinois, US |
3255112 | 3255112 | 2021-03-02 | US | Illinois | Coles | 17029 | 5213 | 91 | 0 | 5122 | 39.51949084 | -88.22358557 | 2021-03-03 05:23:28 | Coles, Illinois, US |
2186877 | 2186877 | 2021-02-26 | US | Virginia | Augusta | 51015 | 5178 | 56 | 0 | 5122 | 38.16404586 | -79.12461614 | 2021-02-27 05:22:28 | Augusta, Virginia, US |
2186523 | 2186523 | 2021-02-26 | US | Tennessee | Hawkins | 47073 | 5193 | 94 | 0 | 5122 | 36.44355426 | -82.94885298 | 2021-02-27 05:22:28 | Hawkins, Tennessee, US |
742048 | 742048 | 2021-02-20 | Brazil | Distrito Federal | 288977 | 4747 | 279108 | 5122 | -15.7998 | -47.8645 | 2021-02-21 05:24:33 | Distrito Federal, Brazil | ||
1461176 | 1461176 | 2021-01-31 | US | Kentucky | Laurel | 21125 | 5140 | 18 | 0 | 5122 | 37.10975748 | -84.11321779 | 2021-02-01 05:22:53 | Laurel, Kentucky, US |
1761967 | 1761967 | 2021-01-24 | US | Pennsylvania | Lawrence | 42073 | 5281 | 159 | 0 | 5122 | 40.99206278 | -80.33393706 | 2021-01-25 05:22:16 | Lawrence, Pennsylvania, US |
1759502 | 1759502 | 2021-01-24 | Russia | Karelia Republic | 34231 | 214 | 28895 | 5122 | 62.61940309999999 | 33.4920267 | 2021-01-25 05:22:16 | Karelia Republic, Russia | ||
3882479 | 3882479 | 2021-01-14 | US | Tennessee | Bedford | 47003 | 5317 | 85 | 0 | 5122 | 35.51123746 | -86.45549096 | 2021-01-15 05:22:24 | Bedford, Tennessee, US |
3311435 | 3311435 | 2021-01-13 | US | Texas | Val Verde | 48465 | 4399 | 156 | 0 | 5122 | 29.89149232 | -101.1525205 | 2021-01-14 05:22:32 | Val Verde, Texas, US |
777580 | 777580 | 2021-01-12 | US | Texas | Val Verde | 48465 | 4399 | 156 | 0 | 5122 | 29.89149232 | -101.1525205 | 2021-01-13 05:22:15 | Val Verde, Texas, US |
2543530 | 2543530 | 2021-01-07 | US | Nevada | Carson City | 32510 | 5190 | 68 | 0 | 5122 | 39.15509045 | -119.7480219 | 2021-01-08 05:22:42 | Carson City, Nevada, US |
1062801 | 1062801 | 2021-01-04 | US | Illinois | Boone | 17007 | 5183 | 61 | 0 | 5122 | 42.32359279 | -88.82345779 | 2021-01-05 05:21:49 | Boone, Illinois, US |
1013484 | 1013484 | 2020-12-30 | US | Texas | Orange | 48361 | 3654 | 70 | 0 | 5122 | 30.11879481 | -93.89412775 | 2020-12-31 05:22:49 | Orange, Texas, US |
2977725 | 2977725 | 2020-12-09 | US | Ohio | Richland | 39139 | 5192 | 70 | 0 | 5122 | 40.77180308 | -82.53799609999999 | 2020-12-10 05:26:19 | Richland, Ohio, US |
824694 | 824694 | 2020-11-19 | US | Texas | Johnson | 48251 | 4851 | 86 | 0 | 5122 | 32.37877812 | -97.36615819 | 2020-11-20 05:26:28 | Johnson, Texas, US |
822655 | 822655 | 2020-11-19 | US | Indiana | Hendricks | 18063 | 5279 | 157 | 0 | 5122 | 39.76719009 | -86.51037283 | 2020-11-20 05:26:28 | Hendricks, Indiana, US |
3566083 | 3566083 | 2020-08-25 | US | Wisconsin | Dane | 55025 | 5161 | 39 | 0 | 5122 | 43.06601594 | -89.41733797 | 2020-08-26 04:28:11 | Dane, Wisconsin, US |
1928369 | 1928369 | 2020-07-30 | Ukraine | Kiev | 8131 | 132 | 2877 | 5122 | 50.4501 | 30.5234 | 2020-07-31 04:35:18 | Kiev, Ukraine | ||
61949 | 61949 | 2020-07-23 | Pakistan | Khyber Pakhtunkhwa | 32898 | 1169 | 26607 | 5122 | 34.485332 | 72.09169 | 2020-07-24 05:30:40 | Khyber Pakhtunkhwa, Pakistan | ||
2155387 | 2155387 | 2020-07-14 | US | Pennsylvania | Allegheny | 42003 | 5321 | 199 | 0 | 5122 | 40.46809875 | -79.98167747 | 2020-07-15 04:34:39 | Allegheny, Pennsylvania, US |
1208279 | 1208279 | 2020-06-09 | US | Nebraska | Douglas | 31055 | 5164 | 42 | 0 | 5122 | 41.29518299 | -96.15085305 | 2020-06-10 04:07:00 | Douglas, Nebraska, US |
2523203 | 2523203 | 2020-04-23 | US | Washington | King | 53033 | 5532 | 410 | 0 | 5122 | 47.49137892 | -121.8346131 | 2020-04-23 00:00:00 | King, Washington, 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]);