johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
48 rows where active = 3599 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1125539 | 1125539 | 2021-06-18 | India | Goa | 163927 | 2975 | 157353 | 3599 | 15.359682 | 74.057396 | 2021-06-19 04:22:33 | Goa, India | ||
2318978 | 2318978 | 2021-06-04 | Malaysia | Melaka | 13095 | 83 | 9413 | 3599 | 2.1896 | 102.2501 | 2021-06-05 04:23:03 | Melaka, Malaysia | ||
2505690 | 2505690 | 2021-05-07 | Uzbekistan | 93597 | 660 | 89338 | 3599 | 41.377491 | 64.585262 | 2021-05-08 04:21:04 | Uzbekistan | |||
3927687 | 3927687 | 2021-04-24 | Malaysia | Kelantan | 11193 | 31 | 7563 | 3599 | 6.1254 | 102.2381 | 2021-04-25 04:20:32 | Kelantan, Malaysia | ||
1619737 | 1619737 | 2021-03-05 | US | West Virginia | Ohio | 54069 | 3666 | 67 | 0 | 3599 | 40.0955451 | -80.62203992 | 2021-03-06 04:23:41 | Ohio, West Virginia, US |
744751 | 744751 | 2021-02-20 | US | Ohio | Brown | 39015 | 3653 | 54 | 0 | 3599 | 38.93416837 | -83.86788395 | 2021-02-21 05:24:33 | Brown, Ohio, US |
1156450 | 1156450 | 2021-02-18 | US | Virginia | Franklin | 51067 | 3641 | 42 | 0 | 3599 | 36.99536167 | -79.88023649 | 2021-02-19 05:24:16 | Franklin, Virginia, US |
2287043 | 2287043 | 2021-02-14 | Ukraine | Crimea Republic* | 34395 | 856 | 29940 | 3599 | 45.2835 | 34.2008 | 2021-02-15 05:24:49 | Crimea Republic*, Ukraine | ||
3541065 | 3541065 | 2021-02-12 | US | Michigan | Barry | 26015 | 3640 | 41 | 0 | 3599 | 42.59513984 | -85.30834519 | 2021-02-13 05:22:12 | Barry, Michigan, US |
1591812 | 1591812 | 2021-02-05 | Ukraine | Vinnytsia Oblast | 27916 | 527 | 23790 | 3599 | 49.2331 | 28.4682 | 2021-02-06 05:23:55 | Vinnytsia Oblast, Ukraine | ||
1590702 | 1590702 | 2021-02-05 | US | Oklahoma | Caddo | 40015 | 3649 | 50 | 0 | 3599 | 35.17364557 | -98.37534464 | 2021-02-06 05:23:55 | Caddo, Oklahoma, US |
340494 | 340494 | 2021-02-03 | Russia | Lipetsk Oblast | 21374 | 380 | 17395 | 3599 | 52.6935178 | 39.1122664 | 2021-02-04 05:22:26 | Lipetsk Oblast, Russia | ||
2214585 | 2214585 | 2021-01-30 | US | Tennessee | Cocke | 47029 | 3708 | 71 | 0 | 3599 | 35.9278914 | -83.11828725 | 2021-01-31 05:22:42 | Cocke, Tennessee, US |
1900114 | 1900114 | 2021-01-29 | US | Tennessee | Marshall | 47117 | 3699 | 42 | 0 | 3599 | 35.45798777 | -86.76420988 | 2021-01-30 05:22:49 | Marshall, Tennessee, US |
3155812 | 3155812 | 2021-01-27 | US | New Mexico | Unassigned | 90035 | 3599 | 0 | 0 | 3599 | 36.60569702 | -108.7151824 | 2021-01-28 05:22:24 | Unassigned, New Mexico, US |
2569191 | 2569191 | 2021-01-25 | US | Louisiana | St. Mary | 22101 | 3709 | 110 | 0 | 3599 | 29.69262097 | -91.44702164 | 2021-01-26 05:22:02 | St. Mary, Louisiana, US |
3519028 | 3519028 | 2021-01-15 | Ukraine | Kirovohrad Oblast | 9244 | 289 | 5356 | 3599 | 48.5079 | 32.2623 | 2021-01-16 05:22:40 | Kirovohrad Oblast, Ukraine | ||
3882154 | 3882154 | 2021-01-14 | US | Oklahoma | Pittsburg | 40121 | 3624 | 25 | 0 | 3599 | 34.92065823 | -95.7513432 | 2021-01-15 05:22:24 | Pittsburg, Oklahoma, US |
2627576 | 2627576 | 2021-01-10 | US | Minnesota | Douglas | 27041 | 3663 | 64 | 0 | 3599 | 45.93348491 | -95.45335469 | 2021-01-11 05:21:50 | Douglas, Minnesota, US |
3903590 | 3903590 | 2021-01-09 | Ukraine | Rivne Oblast | 42564 | 529 | 38436 | 3599 | 50.6199 | 26.2516 | 2021-01-10 05:22:12 | Rivne Oblast, Ukraine | ||
2542414 | 2542414 | 2021-01-07 | US | Illinois | Marion | 17121 | 3702 | 103 | 0 | 3599 | 38.64963204 | -88.91899208 | 2021-01-08 05:22:42 | Marion, Illinois, US |
1064561 | 1064561 | 2021-01-04 | US | Puerto Rico | Caguas | 72025 | 3599 | 0 | 0 | 3599 | 18.211615 | -66.050779 | 2021-01-05 05:21:49 | Caguas, Puerto Rico, US |
1137872 | 1137872 | 2021-01-01 | US | Illinois | Jackson | 17077 | 3650 | 51 | 0 | 3599 | 37.78595185 | -89.38232563 | 2021-01-02 05:22:33 | Jackson, Illinois, US |
3696478 | 3696478 | 2020-12-31 | US | Illinois | Jackson | 17077 | 3650 | 51 | 0 | 3599 | 37.78595185 | -89.38232563 | 2021-01-01 05:23:07 | Jackson, Illinois, US |
204798 | 204798 | 2020-12-25 | US | Oklahoma | Grady | 40051 | 3635 | 36 | 0 | 3599 | 35.0167709 | -97.88339847 | 2020-12-26 05:22:28 | Grady, Oklahoma, US |
204218 | 204218 | 2020-12-25 | US | Missouri | Taney | 29213 | 3650 | 51 | 0 | 3599 | 36.65465345 | -93.04075153 | 2020-12-26 05:22:28 | Taney, Missouri, US |
203413 | 203413 | 2020-12-25 | US | Iowa | Buena Vista | 19021 | 3624 | 25 | 0 | 3599 | 42.73545875 | -95.15100162 | 2020-12-26 05:22:28 | Buena Vista, Iowa, US |
3694021 | 3694021 | 2020-12-24 | US | Oklahoma | Grady | 40051 | 3635 | 36 | 0 | 3599 | 35.0167709 | -97.88339847 | 2020-12-25 05:22:48 | Grady, Oklahoma, US |
2409286 | 2409286 | 2020-12-23 | US | Ohio | Geauga | 39055 | 3704 | 105 | 0 | 3599 | 41.49952319 | -81.17935342 | 2020-12-24 05:23:04 | Geauga, Ohio, US |
3862095 | 3862095 | 2020-12-04 | US | New York | Ulster | 36111 | 3697 | 98 | 0 | 3599 | 41.89027881 | -74.26252104 | 2020-12-05 05:27:36 | Ulster, New York, US |
1584566 | 1584566 | 2020-11-30 | US | Alabama | Walker | 1127 | 3710 | 111 | 0 | 3599 | 33.80270512 | -87.30027177 | 2020-12-01 05:26:18 | Walker, Alabama, US |
3838821 | 3838821 | 2020-11-21 | US | North Carolina | Orange | 37135 | 3660 | 61 | 0 | 3599 | 36.06092947 | -79.12167935 | 2020-11-22 05:25:45 | Orange, North Carolina, US |
3789501 | 3789501 | 2020-10-11 | Uganda | 9801 | 93 | 6109 | 3599 | 1.373333 | 32.290275 | 2020-10-12 04:23:45 | Uganda | |||
2691205 | 2691205 | 2020-10-08 | US | Louisiana | Terrebonne | 22109 | 3718 | 119 | 0 | 3599 | 29.37343766 | -90.82626855 | 2020-10-09 04:23:59 | Terrebonne, Louisiana, US |
2381588 | 2381588 | 2020-10-01 | US | Missouri | Unassigned | 90029 | 3599 | 0 | 0 | 3599 | 40.47945588 | 0.0 | 2020-10-02 04:23:51 | Unassigned, Missouri, US |
2617252 | 2617252 | 2020-09-26 | US | Texas | Tom Green | 48451 | 2135 | 71 | 0 | 3599 | 31.40464436 | -100.462443 | 2020-09-27 04:23:00 | Tom Green, Texas, US |
2837490 | 2837490 | 2020-09-21 | US | Florida | Columbia | 12023 | 3649 | 50 | 0 | 3599 | 30.22509788 | -82.62160164 | 2020-09-22 04:23:00 | Columbia, Florida, US |
666194 | 666194 | 2020-09-16 | Germany | Nordrhein-Westfalen | 63155 | 1837 | 57719 | 3599 | 51.4332 | 7.6616 | 2020-09-17 04:22:00 | Nordrhein-Westfalen, Germany | ||
2731154 | 2731154 | 2020-09-15 | US | New Jersey | Cumberland | 34011 | 3756 | 157 | 0 | 3599 | 39.37199394 | -75.10712559 | 2020-09-16 04:22:53 | Cumberland, New Jersey, US |
2728919 | 2728919 | 2020-09-15 | Germany | Nordrhein-Westfalen | 62725 | 1834 | 57297 | 3599 | 51.4332 | 7.6616 | 2020-09-16 04:22:53 | Nordrhein-Westfalen, Germany | ||
197295 | 197295 | 2020-08-31 | US | Texas | Walker | 48471 | 3922 | 48 | 0 | 3599 | 30.73872995 | -95.57440968 | 2020-09-01 04:28:31 | Walker, Texas, US |
3935250 | 3935250 | 2020-08-30 | US | Texas | Walker | 48471 | 3909 | 48 | 0 | 3599 | 30.73872995 | -95.57440968 | 2020-08-31 04:28:27 | Walker, Texas, US |
457195 | 457195 | 2020-08-07 | US | Virginia | Norfolk | 51710 | 3629 | 30 | 0 | 3599 | 36.89934014 | -76.26420872 | 2020-08-08 04:34:53 | Norfolk, Virginia, US |
750191 | 750191 | 2020-08-01 | US | Florida | Bay | 12005 | 3620 | 21 | 0 | 3599 | 30.26548745 | -85.62122584 | 2020-08-02 04:34:47 | Bay, Florida, US |
3185428 | 3185428 | 2020-07-28 | Russia | Volgograd Oblast | 8870 | 61 | 5210 | 3599 | 49.604833899999996 | 44.29035820000001 | 2020-07-29 04:35:11 | Volgograd Oblast, Russia | ||
2699046 | 2699046 | 2020-06-24 | US | Virginia | Loudoun | 51107 | 3683 | 84 | 0 | 3599 | 39.08990083 | -77.63481877 | 2020-06-25 05:26:54 | Loudoun, Virginia, US |
1833848 | 1833848 | 2020-06-14 | US | Colorado | Adams | 8001 | 4005 | 157 | 0 | 3599 | 39.87432092 | -104.3362578 | 2020-06-15 03:33:14 | Adams, Colorado, US |
574032 | 574032 | 2020-06-06 | Russia | Krasnoyarsk Krai | 5136 | 49 | 1488 | 3599 | 63.3233807 | 97.09799740000001 | 2020-06-07 03:53:30 | Krasnoyarsk Krai, Russia |
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]);