johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
50 rows where active = 3536 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- US 35
- Russia 5
- Luxembourg 3
- Azerbaijan 1
- Brazil 1
- Canada 1
- Colombia 1
- Pakistan 1
- Uganda 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3883653 | 3883653 | 2021-04-11 | Luxembourg | 63467 | 763 | 59168 | 3536 | 49.8153 | 6.1296 | 2021-04-12 04:21:00 | Luxembourg | |||
2983321 | 2983321 | 2021-04-10 | Luxembourg | 63467 | 763 | 59168 | 3536 | 49.8153 | 6.1296 | 2021-04-11 04:20:56 | Luxembourg | |||
605753 | 605753 | 2021-04-09 | Luxembourg | 63467 | 763 | 59168 | 3536 | 49.8153 | 6.1296 | 2021-04-10 04:20:59 | Luxembourg | |||
1980843 | 1980843 | 2021-03-25 | Russia | Nizhny Novgorod Oblast | 105661 | 2782 | 99343 | 3536 | 55.47180329999999 | 44.0911594 | 2021-03-26 05:26:55 | Nizhny Novgorod Oblast, Russia | ||
702549 | 702549 | 2021-03-16 | Pakistan | Khyber Pakhtunkhwa | 76819 | 2179 | 71104 | 3536 | 34.485332 | 72.09169 | 2021-03-17 05:25:07 | Khyber Pakhtunkhwa, Pakistan | ||
3669708 | 3669708 | 2021-03-06 | US | Nebraska | Lincoln | 31111 | 3588 | 52 | 0 | 3536 | 41.04658298 | -100.7475374 | 2021-03-07 05:21:54 | Lincoln, Nebraska, US |
3668641 | 3668641 | 2021-03-06 | US | Illinois | Morgan | 17137 | 3613 | 77 | 0 | 3536 | 39.71654544 | -90.20255104 | 2021-03-07 05:21:54 | Morgan, Illinois, US |
3667326 | 3667326 | 2021-03-06 | Azerbaijan | 236365 | 3238 | 229591 | 3536 | 40.1431 | 47.5769 | 2021-03-07 05:21:54 | Azerbaijan | |||
2211289 | 2211289 | 2021-03-04 | Ukraine | Ternopil Oblast | 43223 | 612 | 39075 | 3536 | 49.5535 | 25.5948 | 2021-03-05 05:26:29 | Ternopil Oblast, Ukraine | ||
2210879 | 2210879 | 2021-03-04 | US | Texas | Titus | 48449 | 3897 | 82 | 0 | 3536 | 33.21339719 | -94.96797273 | 2021-03-05 05:26:29 | Titus, Texas, US |
2184067 | 2184067 | 2021-02-26 | US | Arkansas | Independence | 5063 | 3657 | 121 | 0 | 3536 | 35.74242707 | -91.57001641 | 2021-02-27 05:22:28 | Independence, Arkansas, US |
1858489 | 1858489 | 2021-02-25 | US | Arkansas | Independence | 5063 | 3656 | 120 | 0 | 3536 | 35.74242707 | -91.57001641 | 2021-02-26 05:22:40 | Independence, Arkansas, US |
1939945 | 1939945 | 2021-02-23 | US | West Virginia | Ohio | 54069 | 3603 | 67 | 0 | 3536 | 40.0955451 | -80.62203992 | 2021-02-24 05:29:16 | Ohio, West Virginia, US |
472976 | 472976 | 2021-02-19 | US | Maryland | Calvert | 24009 | 3602 | 66 | 0 | 3536 | 38.53961642 | -76.56820632 | 2021-02-20 05:22:51 | Calvert, Maryland, US |
3051449 | 3051449 | 2021-02-16 | US | Kansas | Ellis | 20051 | 3604 | 68 | 0 | 3536 | 38.91458712 | -99.31751551 | 2021-02-17 05:23:10 | Ellis, Kansas, US |
1341517 | 1341517 | 2021-02-15 | US | Texas | Wharton | 48481 | 3648 | 96 | 0 | 3536 | 29.27765923 | -96.22319248 | 2021-02-16 05:24:38 | Wharton, Texas, US |
1340098 | 1340098 | 2021-02-15 | US | Mississippi | Neshoba | 28099 | 3701 | 165 | 0 | 3536 | 32.75339664 | -89.11726492 | 2021-02-16 05:24:38 | Neshoba, Mississippi, US |
1339548 | 1339548 | 2021-02-15 | US | Kansas | Ellis | 20051 | 3604 | 68 | 0 | 3536 | 38.91458712 | -99.31751551 | 2021-02-16 05:24:38 | Ellis, Kansas, US |
2679048 | 2679048 | 2021-02-13 | US | Iowa | Plymouth | 19149 | 3611 | 75 | 0 | 3536 | 42.737633 | -96.21366621 | 2021-02-14 05:23:43 | Plymouth, Iowa, US |
1675454 | 1675454 | 2021-02-07 | US | Tennessee | Weakley | 47183 | 3720 | 53 | 0 | 3536 | 36.29896232 | -88.71990865 | 2021-02-08 05:22:39 | Weakley, Tennessee, US |
2483381 | 2483381 | 2021-01-28 | US | Kentucky | Jessamine | 21113 | 3584 | 48 | 0 | 3536 | 37.87119786 | -84.58252003 | 2021-01-29 05:22:23 | Jessamine, Kentucky, US |
14187 | 14187 | 2021-01-26 | US | Mississippi | Union | 28145 | 3601 | 65 | 0 | 3536 | 34.49162015 | -89.00776006 | 2021-01-27 05:23:41 | Union, Mississippi, US |
12897 | 12897 | 2021-01-26 | US | California | Nevada | 6057 | 3550 | 18 | 0 | 3536 | 39.30394768 | -120.7627281 | 2021-01-27 05:23:41 | Nevada, California, US |
3505564 | 3505564 | 2021-01-17 | US | New Mexico | Unassigned | 90035 | 3536 | 0 | 0 | 3536 | 36.60569702 | -108.7151824 | 2021-01-18 05:22:34 | Unassigned, New Mexico, US |
3104852 | 3104852 | 2021-01-16 | US | Virginia | Washington | 51191 | 3596 | 60 | 0 | 3536 | 36.72341572 | -81.95666289 | 2021-01-17 05:22:17 | Washington, Virginia, US |
3103647 | 3103647 | 2021-01-16 | US | New Mexico | Unassigned | 90035 | 3536 | 0 | 0 | 3536 | 36.60569702 | -108.7151824 | 2021-01-17 05:22:17 | Unassigned, New Mexico, US |
3101294 | 3101294 | 2021-01-16 | Colombia | Narino | 39137 | 1139 | 34462 | 3536 | 1.2892 | -77.3579 | 2021-01-17 05:22:17 | Narino, Colombia | ||
3517609 | 3517609 | 2021-01-15 | US | New Mexico | Unassigned | 90035 | 3536 | 0 | 0 | 3536 | 36.60569702 | -108.7151824 | 2021-01-16 05:22:40 | Unassigned, New Mexico, US |
2542384 | 2542384 | 2021-01-07 | US | Illinois | Franklin | 17055 | 3589 | 53 | 0 | 3536 | 37.99189086 | -88.92567818 | 2021-01-08 05:22:42 | Franklin, Illinois, US |
3231667 | 3231667 | 2021-01-03 | US | Iowa | Muscatine | 19139 | 3611 | 75 | 0 | 3536 | 41.48370744 | -91.1121697 | 2021-01-04 05:22:02 | Muscatine, Iowa, US |
3849958 | 3849958 | 2020-12-13 | US | New Jersey | Sussex | 34037 | 3739 | 203 | 0 | 3536 | 41.13891592 | -74.69118243 | 2020-12-14 05:26:27 | Sussex, New Jersey, US |
3849636 | 3849636 | 2020-12-13 | US | Mississippi | Washington | 28151 | 3645 | 109 | 0 | 3536 | 33.28392041 | -90.94196237 | 2020-12-14 05:26:27 | Washington, Mississippi, US |
1584393 | 1584393 | 2020-11-30 | Russia | Novosibirsk Oblast | 22687 | 743 | 18408 | 3536 | 54.9720169 | 79.48139240000002 | 2020-12-01 05:26:18 | Novosibirsk Oblast, Russia | ||
1583903 | 1583903 | 2020-11-30 | Brazil | Maranhao | 193170 | 4296 | 185338 | 3536 | -4.9609 | -45.2744 | 2020-12-01 05:26:18 | Maranhao, Brazil | ||
679265 | 679265 | 2020-11-23 | US | Illinois | Boone | 17007 | 3565 | 29 | 0 | 3536 | 42.32359279 | -88.82345779 | 2020-11-24 05:27:31 | Boone, Illinois, US |
2785383 | 2785383 | 2020-11-13 | US | Alabama | Limestone | 1083 | 3577 | 41 | 0 | 3536 | 34.81185586 | -86.98310072 | 2020-11-14 05:25:37 | Limestone, Alabama, US |
3442684 | 3442684 | 2020-11-11 | US | Missouri | Cape Girardeau | 29031 | 3594 | 58 | 0 | 3536 | 37.38489388 | -89.6843587 | 2020-11-12 05:25:55 | Cape Girardeau, Missouri, US |
10806 | 10806 | 2020-10-25 | US | Ohio | Mahoning | 39099 | 3810 | 274 | 0 | 3536 | 41.01631101 | -80.77287029 | 2020-10-26 04:25:02 | Mahoning, Ohio, US |
762552 | 762552 | 2020-10-18 | Russia | Sakha (Yakutiya) Republic | 11388 | 106 | 7746 | 3536 | 66.941626 | 129.642371 | 2020-10-19 04:24:16 | Sakha (Yakutiya) Republic, Russia | ||
967121 | 967121 | 2020-09-29 | Russia | Nizhny Novgorod Oblast | 32224 | 575 | 28113 | 3536 | 55.47180329999999 | 44.0911594 | 2020-09-30 04:23:33 | Nizhny Novgorod Oblast, Russia | ||
2816354 | 2816354 | 2020-09-25 | Uganda | 7218 | 71 | 3611 | 3536 | 1.373333 | 32.290275 | 2020-09-26 04:23:00 | Uganda | |||
2731268 | 2731268 | 2020-09-15 | US | North Carolina | Alamance | 37001 | 3584 | 48 | 0 | 3536 | 36.0434701 | -79.39976137 | 2020-09-16 04:22:53 | Alamance, North Carolina, US |
344487 | 344487 | 2020-09-14 | Russia | Krasnoyarsk Krai | 18344 | 521 | 14287 | 3536 | 63.3233807 | 97.0979974 | 2020-09-15 03:22:50 | Krasnoyarsk Krai, Russia | ||
2174832 | 2174832 | 2020-09-09 | US | Virginia | Arlington | 51013 | 3679 | 143 | 0 | 3536 | 38.8767675 | -77.10139853 | 2020-09-10 04:29:01 | Arlington, Virginia, US |
2512845 | 2512845 | 2020-08-27 | US | Pennsylvania | Luzerne | 42079 | 3723 | 187 | 0 | 3536 | 41.17823008 | -75.98447579 | 2020-08-28 04:28:11 | Luzerne, Pennsylvania, US |
2806585 | 2806585 | 2020-08-02 | US | Pennsylvania | Northampton | 42095 | 3826 | 290 | 0 | 3536 | 40.75182733 | -75.30471829 | 2020-08-03 04:34:35 | Northampton, Pennsylvania, US |
1691050 | 1691050 | 2020-06-19 | US | North Carolina | Wake | 37183 | 3579 | 43 | 0 | 3536 | 35.78879266 | -78.65249174 | 2020-06-20 04:33:19 | Wake, North Carolina, US |
1194612 | 1194612 | 2020-06-17 | US | Florida | Orange | 12095 | 3584 | 48 | 0 | 3536 | 28.51367621 | -81.31799498 | 2020-06-18 04:33:18 | Orange, Florida, US |
2565878 | 2565878 | 2020-04-11 | US | New Jersey | Monmouth | 34025 | 3651 | 115 | 0 | 3536 | 40.26549699 | -74.22240686 | 2020-04-11 22:45:33 | Monmouth, New Jersey, US |
1750711 | 1750711 | 2020-04-04 | Canada | Ontario | 5123 | 94 | 0 | 3536 | 51.2538 | -85.3232 | 4/4/20 23:40 | Ontario, Canada |
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]);