johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
51 rows where confirmed = 11558 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2953619 | 2953619 | 2022-12-20 | US | New York | Chenango | 36017 | 11558 | 138 | 0 | 42.49430041 | -75.60887553 | 2022-12-21 04:21:03 | Chenango, New York, US | |
294373 | 294373 | 2022-11-15 | US | North Carolina | Person | 37145 | 11558 | 115 | 0 | 36.38989032 | -78.97217358 | 2022-11-16 04:21:09 | Person, North Carolina, US | |
3599403 | 3599403 | 2022-11-14 | US | North Carolina | Person | 37145 | 11558 | 115 | 0 | 36.38989032 | -78.97217358 | 2022-11-15 04:21:16 | Person, North Carolina, US | |
314261 | 314261 | 2022-11-13 | US | North Carolina | Person | 37145 | 11558 | 115 | 0 | 36.38989032 | -78.97217358 | 2022-11-14 04:21:09 | Person, North Carolina, US | |
65422 | 65422 | 2022-11-12 | US | North Carolina | Person | 37145 | 11558 | 115 | 0 | 36.38989032 | -78.97217358 | 2022-11-13 04:21:14 | Person, North Carolina, US | |
2929584 | 2929584 | 2022-11-11 | US | North Carolina | Person | 37145 | 11558 | 115 | 0 | 36.38989032 | -78.97217358 | 2022-11-12 04:20:41 | Person, North Carolina, US | |
2508420 | 2508420 | 2022-11-10 | US | North Carolina | Person | 37145 | 11558 | 115 | 0 | 36.38989032 | -78.97217358 | 2022-11-11 04:21:22 | Person, North Carolina, US | |
2433295 | 2433295 | 2022-11-09 | US | North Carolina | Person | 37145 | 11558 | 115 | 0 | 36.38989032 | -78.97217358 | 2022-11-10 04:21:16 | Person, North Carolina, US | |
2853852 | 2853852 | 2022-08-22 | US | Illinois | Fulton | 17057 | 11558 | 132 | 0 | 40.47289135 | -90.20862357 | 2022-08-23 04:20:56 | Fulton, Illinois, US | |
1346248 | 1346248 | 2022-08-10 | India | Dadra and Nagar Haveli and Daman and Diu | 11558 | 4 | 0 | 20.194742 | 73.080901 | 2022-08-11 04:20:49 | Dadra and Nagar Haveli and Daman and Diu, India | |||
1853497 | 1853497 | 2022-05-26 | US | West Virginia | Ohio | 54069 | 11558 | 169 | 0 | 40.0955451 | -80.62203992 | 2022-05-27 04:20:56 | Ohio, West Virginia, US | |
3585406 | 3585406 | 2022-05-17 | US | Puerto Rico | Mayaguez | 72097 | 11558 | 0 | 0 | 18.2013 | -67.1452 | 2022-05-18 04:20:50 | Mayaguez, Puerto Rico, US | |
464958 | 464958 | 2022-05-02 | US | Maine | Oxford | 23017 | 11558 | 146 | 0 | 44.49952995 | -70.75682123 | 2022-05-03 04:21:00 | Oxford, Maine, US | |
2751816 | 2751816 | 2022-04-04 | US | Tennessee | Cocke | 47029 | 11558 | 212 | 0 | 35.9278914 | -83.11828725 | 2022-04-05 04:20:48 | Cocke, Tennessee, US | |
1540513 | 1540513 | 2022-03-31 | US | California | Lake | 6033 | 11558 | 136 | 0 | 39.10124298 | -122.75362439999999 | 2022-04-01 04:20:28 | Lake, California, US | |
2478526 | 2478526 | 2022-03-30 | US | California | Lake | 6033 | 11558 | 136 | 0 | 39.10124298 | -122.75362439999999 | 2022-03-31 04:20:56 | Lake, California, US | |
158567 | 158567 | 2022-03-29 | US | California | Lake | 6033 | 11558 | 136 | 0 | 39.10124298 | -122.75362439999999 | 2022-03-30 04:20:45 | Lake, California, US | |
921175 | 921175 | 2022-03-08 | US | Louisiana | Avoyelles | 22009 | 11558 | 201 | 0 | 31.07796211 | -92.00079449 | 2022-03-09 04:20:59 | Avoyelles, Louisiana, US | |
3048607 | 3048607 | 2022-02-26 | US | North Dakota | Stark | 38089 | 11558 | 85 | 0 | 46.80851182 | -102.65763259999999 | 2022-02-27 04:21:04 | Stark, North Dakota, US | |
1288802 | 1288802 | 2022-01-04 | US | Rhode Island | Newport | 44005 | 11558 | 58 | 0 | 41.5642026 | -71.26569799 | 2022-01-05 04:21:59 | Newport, Rhode Island, US | |
1703146 | 1703146 | 2022-01-03 | US | Rhode Island | Newport | 44005 | 11558 | 58 | 0 | 41.5642026 | -71.26569799 | 2022-01-04 04:22:17 | Newport, Rhode Island, US | |
3522229 | 3522229 | 2022-01-02 | US | Rhode Island | Newport | 44005 | 11558 | 58 | 0 | 41.5642026 | -71.26569799 | 2022-01-03 02:22:25 | Newport, Rhode Island, US | |
2170359 | 2170359 | 2022-01-01 | US | Rhode Island | Newport | 44005 | 11558 | 58 | 0 | 41.5642026 | -71.26569799 | 2022-01-02 04:20:52 | Newport, Rhode Island, US | |
2779790 | 2779790 | 2021-12-31 | US | Rhode Island | Newport | 44005 | 11558 | 58 | 0 | 41.5642026 | -71.26569799 | 2022-01-01 04:22:14 | Newport, Rhode Island, US | |
4001447 | 4001447 | 2021-12-30 | US | Rhode Island | Newport | 44005 | 11558 | 58 | 0 | 41.5642026 | -71.26569799 | 2021-12-31 04:21:50 | Newport, Rhode Island, US | |
1671254 | 1671254 | 2021-12-29 | US | Rhode Island | Newport | 44005 | 11558 | 58 | 0 | 41.5642026 | -71.26569799 | 2021-12-30 04:21:25 | Newport, Rhode Island, US | |
1325765 | 1325765 | 2021-11-14 | US | Wisconsin | Chippewa | 55017 | 11558 | 123 | 0 | 45.06939744 | -91.28068855 | 2021-11-15 04:21:36 | Chippewa, Wisconsin, US | |
689891 | 689891 | 2021-11-13 | US | Wisconsin | Chippewa | 55017 | 11558 | 123 | 0 | 45.06939744 | -91.28068855 | 2021-11-14 04:21:31 | Chippewa, Wisconsin, US | |
718000 | 718000 | 2021-11-12 | US | Wisconsin | Chippewa | 55017 | 11558 | 123 | 0 | 45.06939744 | -91.28068855 | 2021-11-13 04:21:38 | Chippewa, Wisconsin, US | |
989804 | 989804 | 2021-10-04 | US | South Carolina | Kershaw | 45055 | 11558 | 191 | 0 | 34.33988254 | -80.58763164 | 2021-10-05 04:21:27 | Kershaw, South Carolina, US | |
1276656 | 1276656 | 2021-10-03 | US | North Carolina | Surry | 37171 | 11558 | 217 | 0 | 36.41689489 | -80.69102283 | 2021-10-04 04:21:31 | Surry, North Carolina, US | |
3930409 | 3930409 | 2021-10-02 | US | North Carolina | Surry | 37171 | 11558 | 217 | 0 | 36.41689489 | -80.69102283 | 2021-10-03 04:21:24 | Surry, North Carolina, US | |
2134389 | 2134389 | 2021-10-01 | US | North Carolina | Surry | 37171 | 11558 | 217 | 0 | 36.41689489 | -80.69102283 | 2021-10-02 04:21:25 | Surry, North Carolina, US | |
1923653 | 1923653 | 2021-09-24 | US | North Dakota | Ward | 38101 | 11558 | 209 | 0 | 48.22390169 | -101.54367629999999 | 2021-09-25 04:21:31 | Ward, North Dakota, US | |
3011270 | 3011270 | 2021-09-22 | Iceland | 11558 | 33 | 0 | 64.9631 | -19.0208 | 2021-09-23 04:21:43 | Iceland | ||||
247157 | 247157 | 2021-08-17 | US | Missouri | Cole | 29051 | 11558 | 142 | 0 | 38.50455671 | -92.27860244 | 2021-08-18 04:21:35 | Cole, Missouri, US | |
649662 | 649662 | 2021-08-09 | Australia | New South Wales | 11558 | 87 | 0 | -33.8688 | 151.2093 | 2021-08-10 04:21:27 | New South Wales, Australia | |||
1330731 | 1330731 | 2021-07-24 | US | Arkansas | Garland | 5051 | 11558 | 268 | 0 | 34.57692074 | -93.14921604 | 2021-07-25 04:22:12 | Garland, Arkansas, US | |
3961470 | 3961470 | 2021-06-26 | US | Tennessee | Madison | 47113 | 11558 | 242 | 0 | 35.61181957 | -88.84076036 | 2021-06-27 04:21:39 | Madison, Tennessee, US | |
2823089 | 2823089 | 2021-05-10 | US | North Carolina | Harnett | 37085 | 11558 | 170 | 0 | 35.36731853 | -78.87243571 | 2021-05-11 04:20:41 | Harnett, North Carolina, US | |
3542441 | 3542441 | 2021-02-12 | US | Tennessee | Sevier | 47155 | 11558 | 152 | 0 | 11421 | 35.78077323 | -83.52244332 | 2021-02-13 05:22:12 | Sevier, Tennessee, US |
791298 | 791298 | 2021-02-04 | US | Idaho | Bonneville | 16019 | 11558 | 137 | 0 | 11421 | 43.38713372 | -111.6161537 | 2021-02-05 05:22:38 | Bonneville, Idaho, US |
1013269 | 1013269 | 2020-12-30 | US | Tennessee | Montgomery | 47125 | 11558 | 124 | 0 | 11261 | 36.49609412 | -87.38550661 | 2020-12-31 05:22:49 | Montgomery, Tennessee, US |
205828 | 205828 | 2020-12-25 | US | Wisconsin | Sheboygan | 55117 | 11558 | 93 | 0 | 11465 | 43.72099677 | -87.94579284 | 2020-12-26 05:22:28 | Sheboygan, Wisconsin, US |
923918 | 923918 | 2020-11-26 | Russia | Pskov Oblast | 11558 | 72 | 6408 | 5078 | 57.5358729 | 28.8586826 | 2020-11-27 05:26:53 | Pskov Oblast, Russia | ||
1546324 | 1546324 | 2020-11-07 | US | North Dakota | Cass | 38017 | 11558 | 95 | 0 | 11311 | 46.93201724 | -97.2444719 | 2020-11-08 05:24:56 | Cass, North Dakota, US |
376899 | 376899 | 2020-11-06 | US | Florida | Pasco | 12101 | 11558 | 245 | 0 | 11313 | 28.30810945 | -82.40227529 | 2020-11-07 05:24:52 | Pasco, Florida, US |
2836606 | 2836606 | 2020-09-21 | Chile | Coquimbo | 11558 | 194 | 10859 | 505 | -29.959 | -71.3389 | 2020-09-22 04:23:00 | Coquimbo, Chile | ||
3562821 | 3562821 | 2020-08-25 | Russia | Ulyanovsk Oblast | 11558 | 91 | 8718 | 2749 | 54.1463177 | 47.2324921 | 2020-08-26 04:28:11 | Ulyanovsk Oblast, Russia | ||
2737549 | 2737549 | 2020-08-03 | US | Illinois | DuPage | 17043 | 11558 | 510 | 0 | 11048 | 41.85116968 | -88.08642662 | 2020-08-04 04:41:59 | DuPage, Illinois, US |
2037659 | 2037659 | 2020-06-27 | US | Connecticut | Hartford | 9003 | 11558 | 1369 | 0 | 10189 | 41.80283011 | -72.73103891 | 2020-06-28 04:34:04 | Hartford, Connecticut, 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]);