johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46 rows where confirmed = 13948 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 7
- US 39
- Netherlands 2
- Djibouti 1
- Japan 1
- Senegal 1
- Ukraine 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755638 | 2755638 | 2022-12-29 | US | Puerto Rico | Cayey | 72035 | 13948 | 0 | 0 | 18.102851 | -66.14914 | 2022-12-30 04:21:04 | Cayey, Puerto Rico, US | |
2753314 | 2753314 | 2022-12-29 | US | Alabama | Tallapoosa | 1123 | 13948 | 251 | 0 | 32.86698258 | -85.79833053 | 2022-12-30 04:21:04 | Tallapoosa, Alabama, US | |
1074320 | 1074320 | 2022-12-28 | US | Alabama | Tallapoosa | 1123 | 13948 | 251 | 0 | 32.86698258 | -85.79833053 | 2022-12-29 04:21:01 | Tallapoosa, Alabama, US | |
328317 | 328317 | 2022-12-27 | US | Alabama | Tallapoosa | 1123 | 13948 | 251 | 0 | 32.86698258 | -85.79833053 | 2022-12-28 04:21:04 | Tallapoosa, Alabama, US | |
218390 | 218390 | 2022-12-26 | US | Alabama | Tallapoosa | 1123 | 13948 | 251 | 0 | 32.86698258 | -85.79833053 | 2022-12-27 04:21:07 | Tallapoosa, Alabama, US | |
3222847 | 3222847 | 2022-12-25 | US | Alabama | Tallapoosa | 1123 | 13948 | 251 | 0 | 32.86698258 | -85.79833053 | 2022-12-26 04:21:06 | Tallapoosa, Alabama, US | |
1018761 | 1018761 | 2022-12-24 | US | Alabama | Tallapoosa | 1123 | 13948 | 251 | 0 | 32.86698258 | -85.79833053 | 2022-12-25 04:21:04 | Tallapoosa, Alabama, US | |
690784 | 690784 | 2022-12-23 | US | Alabama | Tallapoosa | 1123 | 13948 | 251 | 0 | 32.86698258 | -85.79833053 | 2022-12-24 04:21:02 | Tallapoosa, Alabama, US | |
2179994 | 2179994 | 2022-12-22 | US | Alabama | Tallapoosa | 1123 | 13948 | 251 | 0 | 32.86698258 | -85.79833053 | 2022-12-23 04:21:04 | Tallapoosa, Alabama, US | |
451798 | 451798 | 2022-12-21 | US | Alabama | Tallapoosa | 1123 | 13948 | 251 | 0 | 32.86698258 | -85.79833053 | 2022-12-22 04:20:56 | Tallapoosa, Alabama, US | |
1813222 | 1813222 | 2022-10-05 | US | Ohio | Ashland | 39005 | 13948 | 230 | 0 | 40.84772277 | -82.27280781 | 2022-10-06 04:21:22 | Ashland, Ohio, US | |
133196 | 133196 | 2022-10-04 | US | Ohio | Ashland | 39005 | 13948 | 230 | 0 | 40.84772277 | -82.27280781 | 2022-10-05 04:23:06 | Ashland, Ohio, US | |
2688143 | 2688143 | 2022-10-03 | US | Ohio | Ashland | 39005 | 13948 | 230 | 0 | 40.84772277 | -82.27280781 | 2022-10-04 04:22:55 | Ashland, Ohio, US | |
2262210 | 2262210 | 2022-10-02 | US | Ohio | Ashland | 39005 | 13948 | 230 | 0 | 40.84772277 | -82.27280781 | 2022-10-03 04:23:11 | Ashland, Ohio, US | |
2997736 | 2997736 | 2022-10-01 | US | Ohio | Ashland | 39005 | 13948 | 230 | 0 | 40.84772277 | -82.27280781 | 2022-10-02 04:21:23 | Ashland, Ohio, US | |
856062 | 856062 | 2022-09-30 | US | Ohio | Ashland | 39005 | 13948 | 230 | 0 | 40.84772277 | -82.27280781 | 2022-10-01 04:23:01 | Ashland, Ohio, US | |
2377988 | 2377988 | 2022-09-29 | US | Ohio | Ashland | 39005 | 13948 | 230 | 0 | 40.84772277 | -82.27280781 | 2022-09-30 04:23:09 | Ashland, Ohio, US | |
1213682 | 1213682 | 2022-07-11 | US | Nebraska | Unassigned | 90031 | 13948 | 883 | 0 | 42.8997274 | 0.0 | 2022-07-12 04:20:51 | Unassigned, Nebraska, US | |
2791164 | 2791164 | 2022-07-10 | US | Nebraska | Unassigned | 90031 | 13948 | 883 | 0 | 42.8997274 | 0.0 | 2022-07-11 04:20:46 | Unassigned, Nebraska, US | |
144117 | 144117 | 2022-07-09 | US | Nebraska | Unassigned | 90031 | 13948 | 883 | 0 | 42.8997274 | 0.0 | 2022-07-10 04:20:54 | Unassigned, Nebraska, US | |
1419217 | 1419217 | 2022-07-08 | US | Nebraska | Unassigned | 90031 | 13948 | 883 | 0 | 42.8997274 | 0.0 | 2022-07-09 04:20:59 | Unassigned, Nebraska, US | |
3899385 | 3899385 | 2022-05-19 | US | Virginia | Washington | 51191 | 13948 | 215 | 0 | 36.72341572 | -81.95666289 | 2022-05-20 04:20:57 | Washington, Virginia, US | |
356806 | 356806 | 2022-03-11 | US | Arkansas | Crittenden | 5035 | 13948 | 215 | 0 | 35.21247318 | -90.30839406 | 2022-03-12 04:20:50 | Crittenden, Arkansas, US | |
2449095 | 2449095 | 2022-02-22 | US | North Carolina | Granville | 37077 | 13948 | 111 | 0 | 36.30337451 | -78.65184241 | 2022-02-23 04:21:09 | Granville, North Carolina, US | |
2613046 | 2613046 | 2022-01-06 | US | Tennessee | Tipton | 47167 | 13948 | 179 | 0 | 35.501942 | -89.73694895 | 2022-01-07 04:22:09 | Tipton, Tennessee, US | |
2609911 | 2609911 | 2022-01-06 | Djibouti | 13948 | 189 | 0 | 11.8251 | 42.5903 | 2022-01-07 04:22:09 | Djibouti | ||||
785305 | 785305 | 2021-12-13 | US | Tennessee | Anderson | 47001 | 13948 | 237 | 0 | 36.12684348 | -84.19965764 | 2021-12-14 04:22:38 | Anderson, Tennessee, US | |
3405120 | 3405120 | 2021-11-30 | United Kingdom | Jersey | 13948 | 80 | 0 | 0 | 49.2138 | -2.1358 | 2021-12-01 04:22:29 | Jersey, United Kingdom | ||
1923107 | 1923107 | 2021-09-24 | US | Missouri | Clay | 29047 | 13948 | 199 | 0 | 39.31132056 | -94.41850862 | 2021-09-25 04:21:31 | Clay, Missouri, US | |
2281997 | 2281997 | 2021-09-08 | US | South Carolina | Sumter | 45085 | 13948 | 242 | 0 | 33.91826534 | -80.37942316 | 2021-09-09 04:21:27 | Sumter, South Carolina, US | |
3555766 | 3555766 | 2021-08-21 | Netherlands | Aruba | 13948 | 126 | 0 | 12.5211 | -69.9683 | 2021-08-22 04:21:29 | Aruba, Netherlands | |||
780633 | 780633 | 2021-07-08 | US | New York | Ulster | 36111 | 13948 | 257 | 0 | 41.89027881 | -74.26252104 | 2021-07-09 04:21:21 | Ulster, New York, US | |
1894732 | 1894732 | 2021-06-30 | US | Massachusetts | Barnstable | 25001 | 13948 | 376 | 0 | 41.72980578 | -70.28854339 | 2021-07-01 04:21:19 | Barnstable, Massachusetts, US | |
85269 | 85269 | 2021-05-25 | US | New Jersey | Sussex | 34037 | 13948 | 302 | 0 | 41.13891592 | -74.69118243 | 2021-05-26 04:20:35 | Sussex, New Jersey, US | |
1636904 | 1636904 | 2021-04-29 | US | California | Yolo | 6113 | 13948 | 205 | 0 | 38.68278902 | -121.9018288 | 2021-04-30 04:21:03 | Yolo, California, US | |
237253 | 237253 | 2021-01-18 | Japan | Hyogo | 13948 | 308 | 11213 | 2427 | 35.039913 | 134.828057 | 2021-01-19 05:22:15 | Hyogo, Japan | ||
2626804 | 2626804 | 2021-01-10 | US | Idaho | Kootenai | 16055 | 13948 | 131 | 0 | 13817 | 47.67282258 | -116.7020872 | 2021-01-11 05:21:50 | Kootenai, Idaho, US |
2227638 | 2227638 | 2021-01-02 | Netherlands | Drenthe | 13948 | 140 | 0 | 13792 | 52.862485 | 6.618435000000002 | 2021-01-03 05:22:52 | Drenthe, Netherlands | ||
925646 | 925646 | 2020-11-26 | US | Missouri | Unassigned | 90029 | 13948 | 0 | 0 | 13948 | 40.47945588 | 0.0 | 2020-11-27 05:26:53 | Unassigned, Missouri, US |
1351911 | 1351911 | 2020-11-24 | US | Massachusetts | Plymouth | 25023 | 13948 | 742 | 0 | 13063 | 41.94070556 | -70.80802823 | 2020-11-25 05:27:20 | Plymouth, Massachusetts, US |
123376 | 123376 | 2020-11-18 | US | Florida | Brevard | 12009 | 13948 | 416 | 0 | 13532 | 28.29409504 | -80.73091022 | 2020-11-19 05:25:23 | Brevard, Florida, US |
3173271 | 3173271 | 2020-11-16 | Ukraine | Vinnytsia Oblast | 13948 | 241 | 7973 | 5734 | 49.2331 | 28.4682 | 2020-11-17 05:25:54 | Vinnytsia Oblast, Ukraine | ||
2916742 | 2916742 | 2020-11-14 | US | Maryland | Anne Arundel | 24003 | 13948 | 288 | 0 | 13660 | 39.00670238 | -76.60329337 | 2020-11-15 05:26:53 | Anne Arundel, Maryland, US |
813845 | 813845 | 2020-09-05 | Senegal | 13948 | 290 | 9851 | 3807 | 14.4974 | -14.4524 | 2020-09-06 04:28:33 | Senegal | |||
1612617 | 1612617 | 2020-08-14 | US | Alabama | Jefferson | 1073 | 13948 | 262 | 0 | 13686 | 33.55554728 | -86.89506300000002 | 2020-08-15 04:27:31 | Jefferson, Alabama, US |
2745921 | 2745921 | 2020-07-15 | US | Minnesota | Hennepin | 27053 | 13948 | 793 | 0 | 13155 | 45.00761521 | -93.47694895 | 2020-07-16 04:44:59 | Hennepin, Minnesota, 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]);