johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
39 rows where confirmed = 11722 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3028449 | 3028449 | 2022-11-17 | US | New Hampshire | Carroll | 33003 | 11722 | 70 | 0 | 43.87498583 | -71.20430216 | 2022-11-18 04:21:15 | Carroll, New Hampshire, US | |
482322 | 482322 | 2022-11-08 | US | Puerto Rico | Canovanas | 72029 | 11722 | 0 | 0 | 18.328802 | -65.887612 | 2022-11-09 04:21:22 | Canovanas, Puerto Rico, US | |
1813245 | 1813245 | 2022-10-05 | US | Ohio | Fulton | 39051 | 11722 | 182 | 0 | 41.60213491 | -84.12571393 | 2022-10-06 04:21:22 | Fulton, Ohio, US | |
133219 | 133219 | 2022-10-04 | US | Ohio | Fulton | 39051 | 11722 | 182 | 0 | 41.60213491 | -84.12571393 | 2022-10-05 04:23:06 | Fulton, Ohio, US | |
2688166 | 2688166 | 2022-10-03 | US | Ohio | Fulton | 39051 | 11722 | 182 | 0 | 41.60213491 | -84.12571393 | 2022-10-04 04:22:55 | Fulton, Ohio, US | |
2262233 | 2262233 | 2022-10-02 | US | Ohio | Fulton | 39051 | 11722 | 182 | 0 | 41.60213491 | -84.12571393 | 2022-10-03 04:23:11 | Fulton, Ohio, US | |
2997759 | 2997759 | 2022-10-01 | US | Ohio | Fulton | 39051 | 11722 | 182 | 0 | 41.60213491 | -84.12571393 | 2022-10-02 04:21:23 | Fulton, Ohio, US | |
856085 | 856085 | 2022-09-30 | US | Ohio | Fulton | 39051 | 11722 | 182 | 0 | 41.60213491 | -84.12571393 | 2022-10-01 04:23:01 | Fulton, Ohio, US | |
2378011 | 2378011 | 2022-09-29 | US | Ohio | Fulton | 39051 | 11722 | 182 | 0 | 41.60213491 | -84.12571393 | 2022-09-30 04:23:09 | Fulton, Ohio, US | |
1069137 | 1069137 | 2022-07-28 | US | Texas | Wilson | 48493 | 11722 | 160 | 0 | 29.1732598 | -98.08693082 | 2022-07-29 04:20:45 | Wilson, Texas, US | |
3409132 | 3409132 | 2022-07-17 | Vanuatu | 11722 | 14 | 0 | -15.3767 | 166.9592 | 2022-07-18 04:20:59 | Vanuatu | ||||
2155332 | 2155332 | 2022-07-16 | Vanuatu | 11722 | 14 | 0 | -15.3767 | 166.9592 | 2022-07-17 04:21:15 | Vanuatu | ||||
2422565 | 2422565 | 2022-07-15 | Vanuatu | 11722 | 14 | 0 | -15.3767 | 166.9592 | 2022-07-16 04:21:05 | Vanuatu | ||||
3111718 | 3111718 | 2022-07-13 | US | New York | Cortland | 36023 | 11722 | 123 | 0 | 42.59509207 | -76.07048931 | 2022-07-14 04:20:57 | Cortland, New York, US | |
1223744 | 1223744 | 2022-04-14 | Pakistan | Gilgit-Baltistan | 11722 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-15 04:20:57 | Gilgit-Baltistan, Pakistan | |||
2442902 | 2442902 | 2022-04-13 | Pakistan | Gilgit-Baltistan | 11722 | 191 | 0 | 35.792146 | 74.982138 | 2022-04-13 23:21:06 | Gilgit-Baltistan, Pakistan | |||
159953 | 159953 | 2022-03-29 | US | Missouri | Newton | 29145 | 11722 | 203 | 0 | 36.90519407 | -94.3394104 | 2022-03-30 04:20:45 | Newton, Missouri, US | |
1438524 | 1438524 | 2022-03-28 | US | Missouri | Newton | 29145 | 11722 | 202 | 0 | 36.90519407 | -94.3394104 | 2022-03-29 04:20:46 | Newton, Missouri, US | |
1470820 | 1470820 | 2022-03-24 | US | Puerto Rico | Arecibo | 72013 | 11722 | 0 | 0 | 18.406631 | -66.675077 | 2022-03-25 04:20:46 | Arecibo, Puerto Rico, US | |
1513784 | 1513784 | 2022-02-24 | US | North Carolina | Vance | 37181 | 11722 | 112 | 0 | 36.36880673 | -78.40670845 | 2022-02-25 04:21:11 | Vance, North Carolina, US | |
2644133 | 2644133 | 2022-02-14 | US | North Carolina | Watauga | 37189 | 11722 | 53 | 0 | 36.23103603 | -81.70033724 | 2022-02-15 04:21:09 | Watauga, North Carolina, US | |
2476257 | 2476257 | 2022-02-03 | US | North Carolina | Chatham | 37037 | 11722 | 103 | 0 | 35.70394416 | -79.25541492 | 2022-02-04 04:21:10 | Chatham, North Carolina, US | |
4001574 | 4001574 | 2021-12-30 | US | Tennessee | Carter | 47019 | 11722 | 267 | 0 | 36.28969086 | -82.12588974 | 2021-12-31 04:21:50 | Carter, Tennessee, US | |
3497653 | 3497653 | 2021-12-15 | US | Kentucky | Pulaski | 21199 | 11722 | 211 | 0 | 37.10466131 | -84.57629079 | 2021-12-16 04:22:11 | Pulaski, Kentucky, US | |
3072393 | 3072393 | 2021-11-23 | US | North Carolina | Rutherford | 37161 | 11722 | 336 | 0 | 35.40114178 | -81.92112099 | 2021-11-24 04:22:14 | Rutherford, North Carolina, US | |
2004002 | 2004002 | 2021-11-07 | US | Virginia | Frederick | 51069 | 11722 | 151 | 0 | 39.20172582 | -78.25974949 | 2021-11-08 04:21:43 | Frederick, Virginia, US | |
498993 | 498993 | 2021-11-06 | US | Virginia | Frederick | 51069 | 11722 | 151 | 0 | 39.20172582 | -78.25974949 | 2021-11-07 04:21:53 | Frederick, Virginia, US | |
3124848 | 3124848 | 2021-11-05 | US | Virginia | Frederick | 51069 | 11722 | 151 | 0 | 39.20172582 | -78.25974949 | 2021-11-06 04:21:51 | Frederick, Virginia, US | |
536311 | 536311 | 2021-10-27 | US | Maryland | Carroll | 24013 | 11722 | 287 | 0 | 39.56453592 | -77.02373735 | 2021-10-28 04:22:08 | Carroll, Maryland, US | |
3794961 | 3794961 | 2021-10-25 | US | Indiana | Bartholomew | 18005 | 11722 | 180 | 0 | 39.20744865 | -85.89558181 | 2021-10-26 04:22:09 | Bartholomew, Indiana, US | |
1235565 | 1235565 | 2021-09-27 | Iceland | 11722 | 33 | 0 | 64.9631 | -19.0208 | 2021-09-28 04:21:28 | Iceland | ||||
1381012 | 1381012 | 2021-07-25 | US | Ohio | Richland | 39139 | 11722 | 215 | 0 | 40.77180308 | -82.53799609999999 | 2021-07-26 04:21:28 | Richland, Ohio, US | |
2023342 | 2023342 | 2021-04-20 | US | Oregon | Lane | 41039 | 11722 | 144 | 0 | 43.93727035 | -122.847753 | 2021-04-21 04:21:14 | Lane, Oregon, US | |
2426626 | 2426626 | 2021-01-23 | Belize | 11722 | 290 | 11050 | 382 | 17.1899 | -88.4976 | 2021-01-24 05:22:35 | Belize | |||
3103724 | 3103724 | 2021-01-16 | US | North Carolina | Buncombe | 37021 | 11722 | 218 | 0 | 11504 | 35.61113393 | -82.53305 | 2021-01-17 05:22:17 | Buncombe, North Carolina, US |
2931559 | 2931559 | 2020-12-19 | US | Alabama | Baldwin | 1003 | 11722 | 147 | 0 | 11575 | 30.72774991 | -87.72207058 | 2020-12-20 05:27:32 | Baldwin, Alabama, US |
77908 | 77908 | 2020-12-03 | US | South Carolina | Lexington | 45063 | 11722 | 231 | 0 | 11491 | 33.89665987 | -81.27146426 | 2020-12-04 05:27:27 | Lexington, South Carolina, US |
821627 | 821627 | 2020-11-19 | Latvia | 11722 | 141 | 1557 | 10024 | 56.8796 | 24.6032 | 2020-11-20 05:26:28 | Latvia | |||
1544511 | 1544511 | 2020-11-07 | US | California | San Mateo | 6081 | 11722 | 169 | 0 | 11549 | 37.4228808 | -122.32755459999998 | 2020-11-08 05:24:56 | San Mateo, California, 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]);