johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
49 rows where confirmed = 13485 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
- Equatorial Guinea 5
- Burkina Faso 1
- Guinea 1
- Japan 1
- Mozambique 1
- Spain 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3216002 | 3216002 | 2022-10-12 | US | Minnesota | Beltrami | 27007 | 13485 | 131 | 0 | 47.97373527 | -94.93732139 | 2022-10-13 04:22:39 | Beltrami, Minnesota, US | |
3251851 | 3251851 | 2022-10-11 | US | Minnesota | Beltrami | 27007 | 13485 | 131 | 0 | 47.97373527 | -94.93732139 | 2022-10-12 04:22:51 | Beltrami, Minnesota, US | |
2969110 | 2969110 | 2022-10-10 | US | Minnesota | Beltrami | 27007 | 13485 | 131 | 0 | 47.97373527 | -94.93732139 | 2022-10-11 04:23:05 | Beltrami, Minnesota, US | |
3099146 | 3099146 | 2022-10-09 | US | Minnesota | Beltrami | 27007 | 13485 | 131 | 0 | 47.97373527 | -94.93732139 | 2022-10-10 04:22:32 | Beltrami, Minnesota, US | |
4004371 | 4004371 | 2022-10-08 | US | Minnesota | Beltrami | 27007 | 13485 | 131 | 0 | 47.97373527 | -94.93732139 | 2022-10-09 04:21:16 | Beltrami, Minnesota, US | |
397968 | 397968 | 2022-10-07 | US | Minnesota | Beltrami | 27007 | 13485 | 131 | 0 | 47.97373527 | -94.93732139 | 2022-10-08 04:22:56 | Beltrami, Minnesota, US | |
2531085 | 2531085 | 2022-10-06 | US | Minnesota | Beltrami | 27007 | 13485 | 131 | 0 | 47.97373527 | -94.93732139 | 2022-10-07 04:23:08 | Beltrami, Minnesota, US | |
947843 | 947843 | 2022-06-14 | US | Illinois | Grundy | 17063 | 13485 | 136 | 0 | 41.28569601 | -88.41905692 | 2022-06-15 04:20:54 | Grundy, Illinois, US | |
3729331 | 3729331 | 2022-06-07 | US | Texas | Harrison | 48203 | 13485 | 227 | 0 | 32.54935988 | -94.36934071 | 2022-06-08 04:20:55 | Harrison, Texas, US | |
1172321 | 1172321 | 2022-05-20 | US | Texas | Hood | 48221 | 13485 | 274 | 0 | 32.42990927 | -97.83242024 | 2022-05-21 04:20:58 | Hood, Texas, US | |
3420448 | 3420448 | 2022-04-17 | US | Wisconsin | Barron | 55005 | 13485 | 143 | 0 | 45.42372701 | -91.84833627 | 2022-04-18 04:21:12 | Barron, Wisconsin, US | |
307397 | 307397 | 2022-04-16 | US | Wisconsin | Barron | 55005 | 13485 | 143 | 0 | 45.42372701 | -91.84833627 | 2022-04-17 04:20:59 | Barron, Wisconsin, US | |
2673342 | 2673342 | 2022-04-15 | US | Wisconsin | Barron | 55005 | 13485 | 143 | 0 | 45.42372701 | -91.84833627 | 2022-04-16 04:20:48 | Barron, Wisconsin, US | |
2751204 | 2751204 | 2022-04-04 | US | North Carolina | Edgecombe | 37065 | 13485 | 141 | 0 | 35.91230639 | -77.59436892 | 2022-04-05 04:20:48 | Edgecombe, North Carolina, US | |
3024026 | 3024026 | 2022-03-23 | US | Minnesota | Otter Tail | 27111 | 13485 | 164 | 0 | 46.40846929 | -95.70835255 | 2022-03-24 04:20:43 | Otter Tail, Minnesota, US | |
1061272 | 1061272 | 2022-02-23 | US | Virginia | Washington | 51191 | 13485 | 204 | 0 | 36.72341572 | -81.95666289 | 2022-02-24 04:21:14 | Washington, Virginia, US | |
2660425 | 2660425 | 2022-01-31 | US | Oregon | Polk | 41053 | 13485 | 117 | 0 | 44.90322804 | -123.4128888 | 2022-02-01 04:21:11 | Polk, Oregon, US | |
2052231 | 2052231 | 2022-01-25 | US | Alabama | Blount | 1009 | 13485 | 206 | 0 | 33.98210918 | -86.56790593 | 2022-01-26 04:21:07 | Blount, Alabama, US | |
1670809 | 1670809 | 2021-12-29 | US | North Carolina | Orange | 37135 | 13485 | 112 | 0 | 36.06092947 | -79.12167935 | 2021-12-30 04:21:25 | Orange, North Carolina, US | |
1234659 | 1234659 | 2021-11-28 | US | Texas | Bowie | 48037 | 13485 | 342 | 0 | 33.44626922 | -94.41834132 | 2021-11-29 04:22:30 | Bowie, Texas, US | |
1361366 | 1361366 | 2021-11-27 | US | Texas | Bowie | 48037 | 13485 | 342 | 0 | 33.44626922 | -94.41834132 | 2021-11-28 04:22:43 | Bowie, Texas, US | |
761357 | 761357 | 2021-11-26 | US | Texas | Bowie | 48037 | 13485 | 342 | 0 | 33.44626922 | -94.41834132 | 2021-11-27 04:22:45 | Bowie, Texas, US | |
1805774 | 1805774 | 2021-11-25 | US | Texas | Bowie | 48037 | 13485 | 342 | 0 | 33.44626922 | -94.41834132 | 2021-11-26 04:22:33 | Bowie, Texas, US | |
907208 | 907208 | 2021-11-24 | US | Texas | Bowie | 48037 | 13485 | 342 | 0 | 33.44626922 | -94.41834132 | 2021-11-25 04:22:33 | Bowie, Texas, US | |
2287326 | 2287326 | 2021-11-15 | Equatorial Guinea | 13485 | 168 | 0 | 1.6508 | 10.2679 | 2021-11-16 04:21:10 | Equatorial Guinea | ||||
1322100 | 1322100 | 2021-11-14 | Equatorial Guinea | 13485 | 168 | 0 | 1.6508 | 10.2679 | 2021-11-15 04:21:36 | Equatorial Guinea | ||||
686226 | 686226 | 2021-11-13 | Equatorial Guinea | 13485 | 168 | 0 | 1.6508 | 10.2679 | 2021-11-14 04:21:31 | Equatorial Guinea | ||||
714335 | 714335 | 2021-11-12 | Equatorial Guinea | 13485 | 168 | 0 | 1.6508 | 10.2679 | 2021-11-13 04:21:38 | Equatorial Guinea | ||||
28285 | 28285 | 2021-11-11 | Equatorial Guinea | 13485 | 168 | 0 | 1.6508 | 10.2679 | 2021-11-12 04:22:01 | Equatorial Guinea | ||||
3796617 | 3796617 | 2021-10-25 | US | Puerto Rico | Bayamon | 72021 | 13485 | 0 | 0 | 18.34946 | -66.168435 | 2021-10-26 04:22:09 | Bayamon, Puerto Rico, US | |
685063 | 685063 | 2021-10-24 | US | Puerto Rico | Bayamon | 72021 | 13485 | 0 | 0 | 18.34946 | -66.168435 | 2021-10-25 04:22:31 | Bayamon, Puerto Rico, US | |
600019 | 600019 | 2021-10-19 | US | North Carolina | Moore | 37125 | 13485 | 244 | 0 | 35.30885257 | -79.48474178 | 2021-10-20 04:21:00 | Moore, North Carolina, US | |
2465624 | 2465624 | 2021-09-14 | US | South Carolina | Oconee | 45073 | 13485 | 163 | 0 | 34.75225169 | -83.06742317 | 2021-09-15 03:22:37 | Oconee, South Carolina, US | |
2464991 | 2464991 | 2021-09-14 | US | New Mexico | McKinley | 35031 | 13485 | 491 | 0 | 35.58007720000001 | -108.262245 | 2021-09-15 03:22:37 | McKinley, New Mexico, US | |
1263156 | 1263156 | 2021-09-09 | US | Alabama | Elmore | 1051 | 13485 | 235 | 0 | 32.59785413 | -86.14415284 | 2021-09-10 04:21:20 | Elmore, Alabama, US | |
652489 | 652489 | 2021-08-09 | US | Ohio | Wood | 39173 | 13485 | 206 | 0 | 41.36224827 | -83.62285108 | 2021-08-10 04:21:27 | Wood, Ohio, US | |
2373257 | 2373257 | 2021-07-20 | US | Minnesota | Olmsted | 27109 | 13485 | 102 | 0 | 44.00374114 | -92.40209944 | 2021-07-21 04:21:40 | Olmsted, Minnesota, US | |
2764690 | 2764690 | 2021-07-01 | Burkina Faso | 13485 | 168 | 13308 | 9 | 12.2383 | -1.5616 | 2021-07-02 04:21:47 | Burkina Faso | |||
2718153 | 2718153 | 2021-06-10 | US | Iowa | Dubuque | 19061 | 13485 | 211 | 0 | 42.46815349 | -90.88181925 | 2021-06-11 04:23:20 | Dubuque, Iowa, US | |
703149 | 703149 | 2021-03-16 | US | Georgia | Bartow | 13015 | 13485 | 203 | 0 | 34.23732119 | -84.83887523 | 2021-03-17 05:25:07 | Bartow, Georgia, US | |
1580517 | 1580517 | 2021-03-13 | US | Alabama | Etowah | 1055 | 13485 | 335 | 0 | 34.04567266 | -86.04051873 | 2021-03-14 05:25:37 | Etowah, Alabama, US | |
3309356 | 3309356 | 2021-01-13 | US | Iowa | Black Hawk | 19013 | 13485 | 228 | 0 | 13257 | 42.4704581 | -92.30524729 | 2021-01-14 05:22:32 | Black Hawk, Iowa, US |
2408619 | 2408619 | 2020-12-23 | US | Mississippi | DeSoto | 28033 | 13485 | 128 | 0 | 13357 | 34.87625235 | -89.99091418 | 2020-12-24 05:23:04 | DeSoto, Mississippi, US |
2127921 | 2127921 | 2020-12-17 | Guinea | 13485 | 80 | 12773 | 632 | 9.9456 | -9.6966 | 2020-12-18 05:28:18 | Guinea | |||
3840067 | 3840067 | 2020-11-21 | US | Wisconsin | Winnebago | 55139 | 13485 | 105 | 0 | 13380 | 44.06886922 | -88.64477096 | 2020-11-22 05:25:45 | Winnebago, Wisconsin, US |
376293 | 376293 | 2020-11-06 | Mozambique | 13485 | 99 | 11275 | 2111 | -18.665695 | 35.529562 | 2020-11-07 05:24:52 | Mozambique | |||
376214 | 376214 | 2020-11-06 | Japan | Osaka | 13485 | 249 | 12014 | 1222 | 34.620965000000005 | 135.507481 | 2020-11-07 05:24:52 | Osaka, Japan | ||
1046100 | 1046100 | 2020-09-30 | Spain | Canarias | 13485 | 232 | 1537 | 11716 | 28.2916 | -16.6291 | 2020-10-01 04:23:42 | Canarias, Spain | ||
3179000 | 3179000 | 2020-08-18 | US | Illinois | Lake | 17097 | 13485 | 452 | 0 | 13033 | 42.3224907 | -88.00367925 | 2020-08-19 04:27:00 | Lake, Illinois, 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]);