johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
56 rows where active = 3318 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3683701 | 3683701 | 2021-08-02 | Russia | Sverdlovsk Oblast | 108468 | 4402 | 100748 | 3318 | 58.6414755 | 61.8021546 | 2021-08-03 04:21:39 | Sverdlovsk Oblast, Russia | ||
1378500 | 1378500 | 2021-07-25 | Italy | Sardegna | 60106 | 1497 | 55291 | 3318 | 39.21531192 | 9.110616306 | 2021-07-26 04:21:28 | Sardegna, Italy | ||
1842132 | 1842132 | 2021-04-14 | Russia | Bashkortostan Republic | 33803 | 406 | 30079 | 3318 | 54.8573563 | 57.1439682 | 2021-04-15 04:20:54 | Bashkortostan Republic, Russia | ||
3710067 | 3710067 | 2021-04-03 | Guinea | 20319 | 129 | 16872 | 3318 | 9.9456 | -9.6966 | 2021-04-04 04:20:49 | Guinea | |||
1580386 | 1580386 | 2021-03-13 | Russia | Penza Oblast | 40063 | 469 | 36276 | 3318 | 53.1655415 | 44.78791810000001 | 2021-03-14 05:25:37 | Penza Oblast, Russia | ||
3669945 | 3669945 | 2021-03-06 | US | North Carolina | Jackson | 37099 | 3372 | 54 | 0 | 3318 | 35.28814273 | -83.14093385 | 2021-03-07 05:21:54 | Jackson, North Carolina, US |
2208594 | 2208594 | 2021-03-04 | US | Idaho | Nez Perce | 16069 | 3369 | 51 | 0 | 3318 | 46.32638236 | -116.7500975 | 2021-03-05 05:26:29 | Nez Perce, Idaho, US |
3254188 | 3254188 | 2021-03-02 | Japan | Tokyo | 112029 | 1400 | 107311 | 3318 | 35.711343 | 139.446921 | 2021-03-03 05:23:28 | Tokyo, Japan | ||
1859504 | 1859504 | 2021-02-25 | US | Louisiana | Iberville | 22047 | 3409 | 91 | 0 | 3318 | 30.25734305 | -91.3499598 | 2021-02-26 05:22:40 | Iberville, Louisiana, US |
283391 | 283391 | 2021-02-24 | US | Texas | Scurry | 48415 | 3135 | 61 | 0 | 3318 | 32.74613808 | -100.9162664 | 2021-02-25 05:24:57 | Scurry, Texas, US |
281555 | 281555 | 2021-02-24 | US | Kentucky | Calloway | 21035 | 3356 | 38 | 0 | 3318 | 36.62093411 | -88.2731593 | 2021-02-25 05:24:57 | Calloway, Kentucky, US |
1939659 | 1939659 | 2021-02-23 | US | Texas | Scurry | 48415 | 3135 | 61 | 0 | 3318 | 32.74613808 | -100.9162664 | 2021-02-24 05:29:16 | Scurry, Texas, US |
1939185 | 1939185 | 2021-02-23 | US | Puerto Rico | Guaynabo | 72061 | 3318 | 0 | 0 | 3318 | 18.345114 | -66.11452299999999 | 2021-02-24 05:29:16 | Guaynabo, Puerto Rico, US |
1156359 | 1156359 | 2021-02-18 | US | Texas | Waller | 48473 | 3298 | 37 | 0 | 3318 | 30.01058447 | -95.99011759 | 2021-02-19 05:24:16 | Waller, Texas, US |
2285171 | 2285171 | 2021-02-14 | US | Minnesota | Polk | 27119 | 3380 | 62 | 0 | 3318 | 47.77372465 | -96.40134647 | 2021-02-15 05:24:49 | Polk, Minnesota, US |
3981120 | 3981120 | 2021-02-10 | US | Oklahoma | Garvin | 40049 | 3357 | 39 | 0 | 3318 | 34.70418038 | -97.30811132 | 2021-02-11 05:23:55 | Garvin, Oklahoma, US |
1684734 | 1684734 | 2021-02-02 | Russia | Orenburg Oblast | 34401 | 487 | 30596 | 3318 | 52.02692620000001 | 54.7276647 | 2021-02-03 05:22:52 | Orenburg Oblast, Russia | ||
2485547 | 2485547 | 2021-01-28 | US | Wisconsin | Trempealeau | 55121 | 3354 | 36 | 0 | 3318 | 44.30360275 | -91.35893614 | 2021-01-29 05:22:23 | Trempealeau, Wisconsin, US |
2568395 | 2568395 | 2021-01-25 | US | Florida | Unassigned | 90012 | 3318 | 0 | 0 | 3318 | 30.86747479 | 0.0 | 2021-01-26 05:22:02 | Unassigned, Florida, US |
2469392 | 2469392 | 2021-01-22 | US | Oklahoma | Sequoyah | 40135 | 3341 | 23 | 0 | 3318 | 35.49447108 | -94.75463785 | 2021-01-23 05:22:03 | Sequoyah, Oklahoma, US |
238231 | 238231 | 2021-01-18 | US | Illinois | Jefferson | 17081 | 3421 | 103 | 0 | 3318 | 38.29980057 | -88.9240025 | 2021-01-19 05:22:15 | Jefferson, Illinois, US |
237797 | 237797 | 2021-01-18 | US | California | Nevada | 6057 | 3332 | 17 | 0 | 3318 | 39.30394768 | -120.7627281 | 2021-01-19 05:22:15 | Nevada, California, US |
3504595 | 3504595 | 2021-01-17 | US | Iowa | Wapello | 19179 | 3416 | 98 | 0 | 3318 | 41.03064984 | -92.40954728 | 2021-01-18 05:22:34 | Wapello, Iowa, US |
3881184 | 3881184 | 2021-01-14 | US | Michigan | Branch | 26023 | 3390 | 72 | 0 | 3318 | 41.91600556 | -85.05929476 | 2021-01-15 05:22:24 | Branch, Michigan, US |
777910 | 777910 | 2021-01-12 | US | Wisconsin | Polk | 55095 | 3347 | 29 | 0 | 3318 | 45.46130348 | -92.44182875 | 2021-01-13 05:22:15 | Polk, Wisconsin, US |
2629508 | 2629508 | 2021-01-10 | Ukraine | Zakarpattia Oblast | 28987 | 659 | 25010 | 3318 | 48.6208 | 22.2879 | 2021-01-11 05:21:50 | Zakarpattia Oblast, Ukraine | ||
2229253 | 2229253 | 2021-01-02 | US | Minnesota | Mower | 27099 | 3343 | 25 | 0 | 3318 | 43.67142874 | -92.75234549 | 2021-01-03 05:22:52 | Mower, Minnesota, US |
1010152 | 1010152 | 2020-12-30 | Colombia | Cundinamarca | 66254 | 1684 | 61252 | 3318 | 5.026 | -74.03 | 2020-12-31 05:22:49 | Cundinamarca, Colombia | ||
768534 | 768534 | 2020-12-29 | US | New York | Chautauqua | 36013 | 3337 | 19 | 0 | 3318 | 42.22769210000001 | -79.36691763 | 2020-12-30 05:22:34 | Chautauqua, New York, US |
2225714 | 2225714 | 2020-12-26 | US | New Mexico | Unassigned | 90035 | 3318 | 0 | 0 | 3318 | 36.60569702 | -108.7151824 | 2020-12-27 05:22:55 | Unassigned, New Mexico, US |
2225028 | 2225028 | 2020-12-26 | US | Louisiana | St. Charles | 22089 | 3391 | 73 | 0 | 3318 | 29.90709658 | -90.35555967 | 2020-12-27 05:22:55 | St. Charles, Louisiana, US |
204566 | 204566 | 2020-12-25 | US | North Carolina | Granville | 37077 | 3378 | 60 | 0 | 3318 | 36.30337451 | -78.65184241 | 2020-12-26 05:22:28 | Granville, North Carolina, US |
203775 | 203775 | 2020-12-25 | US | Louisiana | St. Charles | 22089 | 3391 | 73 | 0 | 3318 | 29.90709658 | -90.35555967 | 2020-12-26 05:22:28 | St. Charles, Louisiana, US |
3693789 | 3693789 | 2020-12-24 | US | North Carolina | Granville | 37077 | 3378 | 60 | 0 | 3318 | 36.30337451 | -78.65184241 | 2020-12-25 05:22:48 | Granville, North Carolina, US |
3692998 | 3692998 | 2020-12-24 | US | Louisiana | St. Charles | 22089 | 3391 | 73 | 0 | 3318 | 29.90709658 | -90.35555967 | 2020-12-25 05:22:48 | St. Charles, Louisiana, US |
2409141 | 2409141 | 2020-12-23 | US | North Carolina | Granville | 37077 | 3378 | 60 | 0 | 3318 | 36.30337451 | -78.65184241 | 2020-12-24 05:23:04 | Granville, North Carolina, US |
863123 | 863123 | 2020-12-11 | US | Ohio | Darke | 39037 | 3389 | 71 | 0 | 3318 | 40.13412966 | -84.6194517 | 2020-12-12 05:26:19 | Darke, Ohio, US |
2975436 | 2975436 | 2020-12-09 | Russia | Khakassia Republic | 13694 | 154 | 10222 | 3318 | 53.72258845 | 91.44293627 | 2020-12-10 05:26:19 | Khakassia Republic, Russia | ||
1008610 | 1008610 | 2020-12-06 | US | North Carolina | Henderson | 37089 | 3391 | 73 | 0 | 3318 | 35.33788927 | -82.4766782 | 2020-12-07 05:26:14 | Henderson, North Carolina, US |
2936813 | 2936813 | 2020-11-28 | US | Maryland | Wicomico | 24045 | 3377 | 59 | 0 | 3318 | 38.37301947 | -75.62705831 | 2020-11-29 05:25:55 | Wicomico, Maryland, US |
1972325 | 1972325 | 2020-11-25 | Brazil | Goias | 276135 | 6300 | 266188 | 3318 | -15.827 | -49.8362 | 2020-11-26 05:27:44 | Goias, Brazil | ||
1352603 | 1352603 | 2020-11-24 | US | North Carolina | Caldwell | 37027 | 3339 | 21 | 0 | 3318 | 35.95204977 | -81.54799522 | 2020-11-25 05:27:20 | Caldwell, North Carolina, US |
3339991 | 3339991 | 2020-11-17 | US | Kentucky | Hardin | 21093 | 3342 | 24 | 0 | 3318 | 37.6976111 | -85.96319251 | 2020-11-18 05:40:31 | Hardin, Kentucky, US |
2916972 | 2916972 | 2020-11-14 | US | Mississippi | Forrest | 28035 | 3401 | 83 | 0 | 3318 | 31.18961454 | -89.25832496 | 2020-11-15 05:26:53 | Forrest, Mississippi, US |
1544321 | 1544321 | 2020-11-07 | US | Alabama | Limestone | 1083 | 3355 | 37 | 0 | 3318 | 34.81185586 | -86.98310072 | 2020-11-08 05:24:56 | Limestone, Alabama, US |
892901 | 892901 | 2020-11-05 | US | Georgia | Dougherty | 13095 | 3515 | 197 | 0 | 3318 | 31.53328528 | -84.21722377 | 2020-11-06 05:24:55 | Dougherty, Georgia, US |
2080119 | 2080119 | 2020-10-31 | Russia | Bryansk Oblast | 12786 | 64 | 9404 | 3318 | 52.8873315 | 33.41585300000001 | 2020-11-01 04:36:19 | Bryansk Oblast, Russia | ||
1794955 | 1794955 | 2020-10-19 | Syria | 5134 | 251 | 1565 | 3318 | 34.802075 | 38.99681500000001 | 2020-10-20 04:24:22 | Syria | |||
79056 | 79056 | 2020-10-14 | India | Tripura | 29031 | 319 | 25394 | 3318 | 23.746783 | 91.743565 | 2020-10-15 04:24:28 | Tripura, India | ||
549981 | 549981 | 2020-09-12 | US | Texas | Walker | 48471 | 4265 | 52 | 0 | 3318 | 30.73872995 | -95.57440968 | 2020-09-13 04:30:52 | Walker, Texas, US |
1105808 | 1105808 | 2020-09-02 | Russia | Volgograd Oblast | 12309 | 106 | 8885 | 3318 | 49.6048339 | 44.29035820000001 | 2020-09-03 04:28:22 | Volgograd Oblast, Russia | ||
2061343 | 2061343 | 2020-09-01 | US | Kentucky | Warren | 21227 | 3344 | 26 | 0 | 3318 | 36.99903045 | -86.42672751 | 2020-09-02 04:28:25 | Warren, Kentucky, US |
753492 | 753492 | 2020-08-01 | Russia | Khanty-Mansi Autonomous Okrug | 16503 | 129 | 13056 | 3318 | 61.0259025 | 69.0982628 | 2020-08-02 04:34:47 | Khanty-Mansi Autonomous Okrug, Russia | ||
120488 | 120488 | 2020-07-19 | US | Georgia | Muscogee | 13215 | 3382 | 64 | 0 | 3318 | 32.50931999 | -84.87142262 | 2020-07-20 05:34:40 | Muscogee, Georgia, US |
2388615 | 2388615 | 2020-05-19 | US | Pennsylvania | Lehigh | 42077 | 3500 | 182 | 0 | 3318 | 40.6154815 | -75.59435245 | 2020-05-20 02:32:19 | Lehigh, Pennsylvania, US |
2042692 | 2042692 | 2020-05-02 | US | New Jersey | Somerset | 34035 | 3607 | 289 | 0 | 3318 | 40.56465737 | -74.61683016 | 2020-05-03 02:32:28 | Somerset, New Jersey, 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]);