johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where active = 5314 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2295156 | 2295156 | 2021-06-24 | Bahrain | 264405 | 1334 | 257757 | 5314 | 26.0275 | 50.55 | 2021-06-25 04:21:33 | Bahrain | |||
2450635 | 2450635 | 2021-05-02 | Colombia | Valle del Cauca | 238813 | 7376 | 226123 | 5314 | 3.8009 | -76.6413 | 2021-05-03 04:20:39 | Valle del Cauca, Colombia | ||
1636424 | 1636424 | 2021-04-29 | Moldova | 250508 | 5795 | 239399 | 5314 | 47.4116 | 28.3699 | 2021-04-30 04:21:03 | Moldova | |||
2185891 | 2185891 | 2021-02-26 | US | North Carolina | Franklin | 37069 | 5357 | 43 | 0 | 5314 | 36.081519 | -78.28708884 | 2021-02-27 05:22:28 | Franklin, North Carolina, US |
743073 | 743073 | 2021-02-20 | US | Georgia | Catoosa | 13047 | 5376 | 62 | 0 | 5314 | 34.89872298 | -85.13757014 | 2021-02-21 05:24:33 | Catoosa, Georgia, US |
1156261 | 1156261 | 2021-02-18 | US | Texas | Lamar | 48277 | 3332 | 140 | 0 | 5314 | 33.66981763 | -95.57404777 | 2021-02-19 05:24:16 | Lamar, Texas, US |
3604679 | 3604679 | 2021-02-17 | Ukraine | Zakarpattia Oblast | 35602 | 812 | 29476 | 5314 | 48.6208 | 22.2879 | 2021-02-18 05:22:58 | Zakarpattia Oblast, Ukraine | ||
3604181 | 3604181 | 2021-02-17 | US | Texas | Lamar | 48277 | 3332 | 140 | 0 | 5314 | 33.66981763 | -95.57404777 | 2021-02-18 05:22:58 | Lamar, Texas, US |
1591132 | 1591132 | 2021-02-05 | US | Tennessee | Loudon | 47105 | 5254 | 61 | 0 | 5314 | 35.73939663 | -84.31145275 | 2021-02-06 05:23:55 | Loudon, Tennessee, US |
1679142 | 1679142 | 2021-02-01 | US | Pennsylvania | Lawrence | 42073 | 5481 | 167 | 0 | 5314 | 40.99206278 | -80.33393706 | 2021-02-02 05:22:49 | Lawrence, Pennsylvania, US |
2213914 | 2213914 | 2021-01-30 | US | New York | Oswego | 36075 | 5397 | 83 | 0 | 5314 | 43.42778894 | -76.14635194 | 2021-01-31 05:22:42 | Oswego, New York, US |
1759634 | 1759634 | 2021-01-24 | US | Alabama | Autauga | 1001 | 5376 | 62 | 0 | 5314 | 32.53952745 | -86.64408227 | 2021-01-25 05:22:16 | Autauga, Alabama, US |
1094054 | 1094054 | 2021-01-20 | India | Tamil Nadu | 832415 | 12290 | 814811 | 5314 | 11.006091 | 78.400624 | 2021-01-21 05:22:01 | Tamil Nadu, India | ||
910638 | 910638 | 2021-01-19 | US | Ohio | Hancock | 39063 | 5429 | 115 | 0 | 5314 | 41.00250487 | -83.66838948 | 2021-01-20 05:21:54 | Hancock, Ohio, US |
239597 | 239597 | 2021-01-18 | US | North Carolina | Stanly | 37167 | 5406 | 92 | 0 | 5314 | 35.31647813 | -80.25093221 | 2021-01-19 05:22:15 | Stanly, North Carolina, US |
3505714 | 3505714 | 2021-01-17 | US | North Carolina | Stanly | 37167 | 5406 | 92 | 0 | 5314 | 35.31647813 | -80.25093221 | 2021-01-18 05:22:34 | Stanly, North Carolina, US |
3037668 | 3037668 | 2021-01-05 | US | Virginia | Montgomery | 51121 | 5357 | 43 | 0 | 5314 | 37.17746986 | -80.37868691 | 2021-01-06 05:22:16 | Montgomery, Virginia, US |
3231592 | 3231592 | 2021-01-03 | US | Indiana | Warrick | 18173 | 5422 | 108 | 0 | 5314 | 38.08922676 | -87.2716085 | 2021-01-04 05:22:02 | Warrick, Indiana, US |
1138601 | 1138601 | 2021-01-01 | US | Minnesota | Kandiyohi | 27067 | 5379 | 65 | 0 | 5314 | 45.1526059 | -95.00586446 | 2021-01-02 05:22:33 | Kandiyohi, Minnesota, US |
3697977 | 3697977 | 2020-12-31 | US | Ohio | Muskingum | 39119 | 5400 | 86 | 0 | 5314 | 39.96575964 | -81.94363275 | 2021-01-01 05:23:07 | Muskingum, Ohio, US |
3697207 | 3697207 | 2020-12-31 | US | Minnesota | Kandiyohi | 27067 | 5379 | 65 | 0 | 5314 | 45.1526059 | -95.00586446 | 2021-01-01 05:23:07 | Kandiyohi, Minnesota, US |
1011189 | 1011189 | 2020-12-30 | US | Georgia | Walton | 13297 | 5405 | 91 | 0 | 5314 | 33.78017694 | -83.73552314 | 2020-12-31 05:22:49 | Walton, Georgia, US |
2130576 | 2130576 | 2020-12-17 | US | Oklahoma | Rogers | 40131 | 5391 | 77 | 0 | 5314 | 36.37004357 | -95.60406759 | 2020-12-18 05:28:18 | Rogers, Oklahoma, US |
1991420 | 1991420 | 2020-11-09 | US | South Carolina | Aiken | 45003 | 5404 | 90 | 0 | 5314 | 33.54338026 | -81.63645384 | 2020-11-10 05:40:07 | Aiken, South Carolina, US |
377008 | 377008 | 2020-11-06 | US | Georgia | Lowndes | 13185 | 5432 | 118 | 0 | 5314 | 30.83568832 | -83.27056716 | 2020-11-07 05:24:52 | Lowndes, Georgia, US |
2919890 | 2919890 | 2020-11-04 | US | Florida | Martin | 12085 | 5482 | 168 | 0 | 5314 | 27.0772071 | -80.43109784 | 2020-11-05 06:05:03 | Martin, Florida, US |
2244850 | 2244850 | 2020-10-30 | US | Kentucky | Warren | 21227 | 5372 | 58 | 0 | 5314 | 36.99903045 | -86.42672751 | 2020-10-31 04:24:44 | Warren, Kentucky, US |
1454379 | 1454379 | 2020-10-27 | US | Mississippi | Harrison | 28047 | 5398 | 84 | 0 | 5314 | 30.51359752 | -89.12467576 | 2020-10-28 04:24:39 | Harrison, Mississippi, US |
3319826 | 3319826 | 2020-09-22 | Ukraine | Chernivtsi Oblast | 13304 | 338 | 7652 | 5314 | 48.2917 | 25.9352 | 2020-09-23 04:23:00 | Chernivtsi Oblast, Ukraine | ||
3177994 | 3177994 | 2020-08-18 | Italy | Lombardia | 97473 | 16840 | 75319 | 5314 | 45.46679409 | 9.190347404 | 2020-08-19 04:27:00 | Lombardia, Italy | ||
2747077 | 2747077 | 2020-07-15 | US | South Carolina | Richland | 45079 | 5413 | 99 | 0 | 5314 | 34.01791263 | -80.90267209 | 2020-07-16 04:44:59 | Richland, South Carolina, US |
3638267 | 3638267 | 2020-05-30 | US | Texas | Tarrant | 48439 | 4587 | 199 | 0 | 5314 | 32.77143818 | -97.29101614 | 2020-05-31 02:32:45 | Tarrant, Texas, 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]);