johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
47 rows where confirmed = 16828 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755224 | 2755224 | 2022-12-29 | US | North Carolina | Edgecombe | 37065 | 16828 | 173 | 0 | 35.91230639 | -77.59436892 | 2022-12-30 04:21:04 | Edgecombe, North Carolina, US | |
1076230 | 1076230 | 2022-12-28 | US | North Carolina | Edgecombe | 37065 | 16828 | 173 | 0 | 35.91230639 | -77.59436892 | 2022-12-29 04:21:01 | Edgecombe, North Carolina, US | |
330227 | 330227 | 2022-12-27 | US | North Carolina | Edgecombe | 37065 | 16828 | 173 | 0 | 35.91230639 | -77.59436892 | 2022-12-28 04:21:04 | Edgecombe, North Carolina, US | |
220300 | 220300 | 2022-12-26 | US | North Carolina | Edgecombe | 37065 | 16828 | 173 | 0 | 35.91230639 | -77.59436892 | 2022-12-27 04:21:07 | Edgecombe, North Carolina, US | |
3224757 | 3224757 | 2022-12-25 | US | North Carolina | Edgecombe | 37065 | 16828 | 173 | 0 | 35.91230639 | -77.59436892 | 2022-12-26 04:21:06 | Edgecombe, North Carolina, US | |
1020671 | 1020671 | 2022-12-24 | US | North Carolina | Edgecombe | 37065 | 16828 | 173 | 0 | 35.91230639 | -77.59436892 | 2022-12-25 04:21:04 | Edgecombe, North Carolina, US | |
692694 | 692694 | 2022-12-23 | US | North Carolina | Edgecombe | 37065 | 16828 | 173 | 0 | 35.91230639 | -77.59436892 | 2022-12-24 04:21:02 | Edgecombe, North Carolina, US | |
2181904 | 2181904 | 2022-12-22 | US | North Carolina | Edgecombe | 37065 | 16828 | 173 | 0 | 35.91230639 | -77.59436892 | 2022-12-23 04:21:04 | Edgecombe, North Carolina, US | |
453708 | 453708 | 2022-12-21 | US | North Carolina | Edgecombe | 37065 | 16828 | 173 | 0 | 35.91230639 | -77.59436892 | 2022-12-22 04:20:56 | Edgecombe, North Carolina, US | |
131824 | 131824 | 2022-10-04 | US | Indiana | Boone | 18011 | 16828 | 197 | 0 | 40.0509304 | -86.46841646 | 2022-10-05 04:23:06 | Boone, Indiana, US | |
2686771 | 2686771 | 2022-10-03 | US | Indiana | Boone | 18011 | 16828 | 197 | 0 | 40.0509304 | -86.46841646 | 2022-10-04 04:22:55 | Boone, Indiana, US | |
2260838 | 2260838 | 2022-10-02 | US | Indiana | Boone | 18011 | 16828 | 197 | 0 | 40.0509304 | -86.46841646 | 2022-10-03 04:23:11 | Boone, Indiana, US | |
2996364 | 2996364 | 2022-10-01 | US | Indiana | Boone | 18011 | 16828 | 197 | 0 | 40.0509304 | -86.46841646 | 2022-10-02 04:21:23 | Boone, Indiana, US | |
854690 | 854690 | 2022-09-30 | US | Indiana | Boone | 18011 | 16828 | 197 | 0 | 40.0509304 | -86.46841646 | 2022-10-01 04:23:01 | Boone, Indiana, US | |
2376616 | 2376616 | 2022-09-29 | US | Indiana | Boone | 18011 | 16828 | 197 | 0 | 40.0509304 | -86.46841646 | 2022-09-30 04:23:09 | Boone, Indiana, US | |
1561167 | 1561167 | 2022-09-28 | US | Indiana | Boone | 18011 | 16828 | 197 | 0 | 40.0509304 | -86.46841646 | 2022-09-29 04:22:34 | Boone, Indiana, US | |
1978801 | 1978801 | 2022-09-25 | US | New Jersey | Salem | 34033 | 16828 | 258 | 0 | 39.58719656 | -75.3469663 | 2022-09-26 04:20:52 | Salem, New Jersey, US | |
1627078 | 1627078 | 2022-09-22 | US | Puerto Rico | Trujillo Alto | 72139 | 16828 | 0 | 0 | 18.336159 | -65.998884 | 2022-09-23 04:23:13 | Trujillo Alto, Puerto Rico, US | |
896627 | 896627 | 2022-07-24 | US | Arkansas | Crawford | 5033 | 16828 | 254 | 0 | 35.58928601 | -94.2446814 | 2022-07-25 04:20:51 | Crawford, Arkansas, US | |
91621 | 91621 | 2022-07-23 | US | Arkansas | Crawford | 5033 | 16828 | 254 | 0 | 35.58928601 | -94.2446814 | 2022-07-24 04:20:47 | Crawford, Arkansas, US | |
3584287 | 3584287 | 2022-05-17 | US | Michigan | Ionia | 26067 | 16828 | 176 | 0 | 42.94502238 | -85.07413319 | 2022-05-18 04:20:50 | Ionia, Michigan, US | |
1505244 | 1505244 | 2022-05-16 | US | Michigan | Ionia | 26067 | 16828 | 176 | 0 | 42.94502238 | -85.07413319 | 2022-05-17 04:20:59 | Ionia, Michigan, US | |
2085603 | 2085603 | 2022-05-15 | US | Michigan | Ionia | 26067 | 16828 | 176 | 0 | 42.94502238 | -85.07413319 | 2022-05-16 04:20:47 | Ionia, Michigan, US | |
3356313 | 3356313 | 2022-05-14 | US | Michigan | Ionia | 26067 | 16828 | 176 | 0 | 42.94502238 | -85.07413319 | 2022-05-15 04:20:53 | Ionia, Michigan, US | |
659958 | 659958 | 2022-05-13 | US | Michigan | Ionia | 26067 | 16828 | 176 | 0 | 42.94502238 | -85.07413319 | 2022-05-14 04:20:48 | Ionia, Michigan, US | |
2535041 | 2535041 | 2022-05-12 | US | Michigan | Ionia | 26067 | 16828 | 176 | 0 | 42.94502238 | -85.07413319 | 2022-05-13 04:20:51 | Ionia, Michigan, US | |
3446487 | 3446487 | 2022-05-11 | US | Michigan | Ionia | 26067 | 16828 | 176 | 0 | 42.94502238 | -85.07413319 | 2022-05-12 04:20:54 | Ionia, Michigan, US | |
73574 | 73574 | 2022-02-07 | US | Ohio | Lawrence | 39087 | 16828 | 232 | 0 | 38.59743452 | -82.53466552 | 2022-02-08 04:21:15 | Lawrence, Ohio, US | |
3227370 | 3227370 | 2022-01-19 | US | Idaho | Bannock | 16005 | 16828 | 220 | 0 | 42.67002716 | -112.2233311 | 2022-01-20 04:21:07 | Bannock, Idaho, US | |
2088742 | 2088742 | 2021-12-14 | US | Georgia | Carroll | 13045 | 16828 | 358 | 0 | 33.58138199 | -85.07976677 | 2021-12-15 03:22:16 | Carroll, Georgia, US | |
1667129 | 1667129 | 2021-12-11 | US | Pennsylvania | Mercer | 42085 | 16828 | 384 | 0 | 41.30248872 | -80.25816981 | 2021-12-12 04:22:12 | Mercer, Pennsylvania, US | |
3342614 | 3342614 | 2021-11-16 | Japan | Gunma | 16828 | 176 | 0 | 36.504478999999996 | 138.985605 | 2021-11-17 04:21:48 | Gunma, Japan | |||
1386701 | 1386701 | 2021-09-13 | US | Indiana | Clark | 18019 | 16828 | 215 | 0 | 38.48015445 | -85.70510334 | 2021-09-14 04:21:41 | Clark, Indiana, US | |
3449398 | 3449398 | 2021-09-10 | US | California | Marin | 6041 | 16828 | 242 | 0 | 38.07122463 | -122.72106310000001 | 2021-09-11 04:21:30 | Marin, California, US | |
32426 | 32426 | 2021-08-25 | Japan | Hiroshima | 16828 | 180 | 0 | 34.605309000000005 | 132.788719 | 2021-08-26 04:21:28 | Hiroshima, Japan | |||
3218680 | 3218680 | 2021-07-26 | US | Alabama | Lee | 1081 | 16828 | 181 | 0 | 32.60154883 | -85.35132246 | 2021-07-27 04:21:18 | Lee, Alabama, US | |
646135 | 646135 | 2021-05-05 | Russia | Altai Republic | 16828 | 240 | 16523 | 65 | 50.7114101 | 86.8572186 | 2021-05-06 04:20:38 | Altai Republic, Russia | ||
352734 | 352734 | 2021-03-11 | US | Arizona | Coconino | 4005 | 16828 | 316 | 0 | 35.83883429 | -111.7707178 | 2021-03-12 05:26:50 | Coconino, Arizona, US | |
3981543 | 3981543 | 2021-02-10 | US | Tennessee | Montgomery | 47125 | 16828 | 190 | 0 | 16287 | 36.49609412 | -87.38550661 | 2021-02-11 05:23:55 | Montgomery, Tennessee, US |
3978417 | 3978417 | 2021-02-10 | Colombia | Caqueta | 16828 | 610 | 15716 | 502 | 0.8699 | -73.8419 | 2021-02-11 05:23:55 | Caqueta, Colombia | ||
1676409 | 1676409 | 2021-02-01 | India | Arunachal Pradesh | 16828 | 56 | 16762 | 10 | 27.768456 | 96.384277 | 2021-02-02 05:22:49 | Arunachal Pradesh, India | ||
1459697 | 1459697 | 2021-01-31 | India | Arunachal Pradesh | 16828 | 56 | 16759 | 13 | 27.768456 | 96.384277 | 2021-02-01 05:22:53 | Arunachal Pradesh, India | ||
2211605 | 2211605 | 2021-01-30 | India | Arunachal Pradesh | 16828 | 56 | 16758 | 14 | 27.768456 | 96.384277 | 2021-01-31 05:22:42 | Arunachal Pradesh, India | ||
3153818 | 3153818 | 2021-01-27 | Russia | Kostroma Oblast | 16828 | 284 | 13526 | 3018 | 58.424756 | 44.2533273 | 2021-01-28 05:22:24 | Kostroma Oblast, Russia | ||
3880169 | 3880169 | 2021-01-14 | US | Colorado | Boulder | 8013 | 16828 | 216 | 0 | 15837 | 40.09313619 | -105.3546767 | 2021-01-15 05:22:24 | Boulder, Colorado, US |
2915394 | 2915394 | 2020-11-14 | Russia | Komi Republic | 16828 | 277 | 11846 | 4705 | 63.9881421 | 54.3326073 | 2020-11-15 05:26:53 | Komi Republic, Russia | ||
82697 | 82697 | 2020-10-14 | Ukraine | Chernivtsi Oblast | 16828 | 395 | 8987 | 7446 | 48.2917 | 25.9352 | 2020-10-15 04:24:28 | Chernivtsi Oblast, Ukraine |
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]);