johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
23 rows where confirmed = 211, country_or_region = "US" and province_or_state = "North Carolina" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 23 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1730806 | 1730806 | 2020-11-08 | US | North Carolina | Jones | 37103 | 211 | 15 | 0 | 196 | 35.02254606 | -77.35870791 | 2020-11-09 05:25:45 | Jones, North Carolina, US |
1546266 | 1546266 | 2020-11-07 | US | North Carolina | Jones | 37103 | 211 | 15 | 0 | 196 | 35.02254606 | -77.35870791 | 2020-11-08 05:24:56 | Jones, North Carolina, US |
3482640 | 3482640 | 2020-10-26 | US | North Carolina | Mitchell | 37121 | 211 | 4 | 0 | 207 | 36.01059309 | -82.1582442 | 2020-10-27 04:24:45 | Mitchell, North Carolina, US |
2604371 | 2604371 | 2020-10-10 | US | North Carolina | Perquimans | 37143 | 211 | 3 | 0 | 208 | 36.17847453 | -76.40603143 | 2020-10-11 04:23:46 | Perquimans, North Carolina, US |
1175516 | 1175516 | 2020-09-10 | US | North Carolina | Pamlico | 37137 | 211 | 2 | 0 | 209 | 35.15253315 | -76.66559823 | 2020-09-11 04:46:23 | Pamlico, North Carolina, US |
2173815 | 2173815 | 2020-09-09 | US | North Carolina | Alleghany | 37005 | 211 | 0 | 0 | 211 | 36.49360862 | -81.12857041 | 2020-09-10 04:29:01 | Alleghany, North Carolina, US |
1246090 | 1246090 | 2020-09-08 | US | North Carolina | Pamlico | 37137 | 211 | 2 | 0 | 209 | 35.15253315 | -76.66559823 | 2020-09-09 04:28:48 | Pamlico, North Carolina, US |
611969 | 611969 | 2020-08-29 | US | North Carolina | Chowan | 37041 | 211 | 2 | 0 | 209 | 36.12908077 | -76.60118385 | 2020-08-30 04:28:22 | Chowan, North Carolina, US |
1614530 | 1614530 | 2020-08-14 | US | North Carolina | Dare | 37055 | 211 | 2 | 0 | 209 | 35.66520691 | -75.71767334 | 2020-08-15 04:27:31 | Dare, North Carolina, US |
585114 | 585114 | 2020-08-13 | US | North Carolina | Dare | 37055 | 211 | 2 | 0 | 209 | 35.66520691 | -75.71767334 | 2020-08-14 04:51:19 | Dare, North Carolina, US |
175595 | 175595 | 2020-07-27 | US | North Carolina | Martin | 37117 | 211 | 6 | 0 | 205 | 35.84326734 | -77.10860251 | 2020-07-28 04:58:43 | Martin, North Carolina, US |
2157398 | 2157398 | 2020-07-14 | US | North Carolina | Northampton | 37131 | 211 | 16 | 0 | 195 | 36.41736238 | -77.39769443 | 2020-07-15 04:34:39 | Northampton, North Carolina, US |
3490043 | 3490043 | 2020-07-13 | US | North Carolina | Northampton | 37131 | 211 | 16 | 0 | 195 | 36.41736238 | -77.39769443 | 2020-07-14 04:34:46 | Northampton, North Carolina, US |
3736304 | 3736304 | 2020-07-12 | US | North Carolina | Northampton | 37131 | 211 | 16 | 0 | 195 | 36.41736238 | -77.39769443 | 2020-07-13 04:43:04 | Northampton, North Carolina, US |
3434699 | 3434699 | 2020-07-11 | US | North Carolina | Northampton | 37131 | 211 | 16 | 0 | 195 | 36.41736238 | -77.39769443 | 2020-07-12 04:34:30 | Northampton, North Carolina, US |
3236198 | 3236198 | 2020-07-10 | US | North Carolina | Northampton | 37131 | 211 | 16 | 0 | 195 | 36.41736238 | -77.39769443 | 2020-07-11 04:34:26 | Northampton, North Carolina, US |
1004184 | 1004184 | 2020-07-09 | US | North Carolina | Northampton | 37131 | 211 | 15 | 0 | 196 | 36.41736238 | -77.39769443 | 2020-07-10 04:34:24 | Northampton, North Carolina, US |
3248084 | 3248084 | 2020-06-21 | US | North Carolina | Onslow | 37133 | 211 | 3 | 0 | 208 | 34.72607366 | -77.42908179 | 2020-06-22 04:33:20 | Onslow, North Carolina, US |
2385227 | 2385227 | 2020-06-16 | US | North Carolina | Montgomery | 37123 | 211 | 5 | 0 | 206 | 35.33155144 | -79.90416657 | 2020-06-17 04:33:21 | Montgomery, North Carolina, US |
286213 | 286213 | 2020-06-15 | US | North Carolina | Richmond | 37153 | 211 | 5 | 0 | 206 | 35.00417719 | -79.74491009 | 2020-06-16 04:33:09 | Richmond, North Carolina, US |
1403699 | 1403699 | 2020-05-14 | US | North Carolina | Sampson | 37163 | 211 | 1 | 0 | 210 | 34.98820368 | -78.36914061 | 2020-05-15 02:33:02 | Sampson, North Carolina, US |
271288 | 271288 | 2020-04-28 | US | North Carolina | Union | 37179 | 211 | 9 | 0 | 202 | 34.98960527 | -80.52955873 | 2020-04-29 02:32:29 | Union, North Carolina, US |
3500287 | 3500287 | 2020-04-25 | US | North Carolina | Chatham | 37037 | 211 | 6 | 0 | 205 | 35.70394416 | -79.25541492 | 2020-04-26 02:30:51 | Chatham, North Carolina, 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]);