johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where active = 4743 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
107409 | 107409 | 2021-06-19 | India | Meghalaya | 44896 | 776 | 39377 | 4743 | 25.536934 | 91.278882 | 2021-06-20 04:21:48 | Meghalaya, India | ||
2104367 | 2104367 | 2021-06-01 | Russia | Pskov Oblast | 37806 | 407 | 32656 | 4743 | 57.5358729 | 28.8586826 | 2021-06-02 04:24:34 | Pskov Oblast, Russia | ||
954615 | 954615 | 2021-04-25 | Brazil | Roraima | 95308 | 1472 | 89008 | 4743 | -2.7376 | -62.0751 | 2021-04-26 04:21:04 | Roraima, Brazil | ||
2208458 | 2208458 | 2021-03-04 | US | Georgia | Habersham | 13137 | 4887 | 144 | 0 | 4743 | 34.63331566 | -83.53094677 | 2021-03-05 05:26:29 | Habersham, Georgia, US |
1000671 | 1000671 | 2021-03-01 | US | New York | Jefferson | 36045 | 4806 | 63 | 0 | 4743 | 44.04200959 | -75.94653457 | 2021-03-02 05:23:30 | Jefferson, New York, US |
3067740 | 3067740 | 2021-02-27 | US | Minnesota | Otter Tail | 27111 | 4813 | 70 | 0 | 4743 | 46.40846929 | -95.70835255 | 2021-02-28 05:22:20 | Otter Tail, Minnesota, US |
283778 | 283778 | 2021-02-24 | US | Wyoming | Fremont | 56013 | 4825 | 82 | 0 | 4743 | 43.04183996 | -108.6296893 | 2021-02-25 05:24:57 | Fremont, Wyoming, US |
533343 | 533343 | 2021-02-22 | US | Pennsylvania | Armstrong | 42005 | 4859 | 116 | 0 | 4743 | 40.81665618 | -79.46290811 | 2021-02-23 05:23:41 | Armstrong, Pennsylvania, US |
1529139 | 1529139 | 2021-02-09 | US | Iowa | Webster | 19187 | 4826 | 83 | 0 | 4743 | 42.42853483 | -94.17987389 | 2021-02-10 05:22:41 | Webster, Iowa, US |
1672250 | 1672250 | 2021-02-07 | Chile | Metropolitana | 348022 | 11488 | 331791 | 4743 | -33.4376 | -70.6505 | 2021-02-08 05:22:39 | Metropolitana, Chile | ||
792831 | 792831 | 2021-02-04 | US | Ohio | Darke | 39037 | 4859 | 116 | 0 | 4743 | 40.13412966 | -84.6194517 | 2021-02-05 05:22:38 | Darke, Ohio, US |
1685522 | 1685522 | 2021-02-02 | US | Illinois | Ogle | 17141 | 4810 | 67 | 0 | 4743 | 42.04165196 | -89.32184679 | 2021-02-03 05:22:52 | Ogle, Illinois, US |
1899558 | 1899558 | 2021-01-29 | US | North Dakota | Morton | 38059 | 4788 | 93 | 0 | 4743 | 46.71681782 | -101.2822377 | 2021-01-30 05:22:49 | Morton, North Dakota, US |
1897924 | 1897924 | 2021-01-29 | US | Georgia | Coffee | 13069 | 4864 | 121 | 0 | 4743 | 31.54892966 | -82.85492059999999 | 2021-01-30 05:22:49 | Coffee, Georgia, US |
3154570 | 3154570 | 2021-01-27 | US | Illinois | Coles | 17029 | 4827 | 84 | 0 | 4743 | 39.51949084 | -88.22358557 | 2021-01-28 05:22:24 | Coles, Illinois, US |
2427973 | 2427973 | 2021-01-23 | US | Indiana | Dearborn | 18029 | 4798 | 55 | 0 | 4743 | 39.14647946 | -84.97333539 | 2021-01-24 05:22:35 | Dearborn, Indiana, US |
2628045 | 2628045 | 2021-01-10 | US | New Jersey | Warren | 34041 | 4929 | 186 | 0 | 4743 | 40.85951833 | -74.99556527 | 2021-01-11 05:21:50 | Warren, New Jersey, US |
2542738 | 2542738 | 2021-01-07 | US | Kansas | Saline | 20169 | 4812 | 69 | 0 | 4743 | 38.78369175 | -97.65185177 | 2021-01-08 05:22:42 | Saline, Kansas, US |
2866047 | 2866047 | 2021-01-06 | US | Kansas | Saline | 20169 | 4812 | 69 | 0 | 4743 | 38.78369175 | -97.65185177 | 2021-01-07 05:22:03 | Saline, Kansas, US |
2225073 | 2225073 | 2020-12-26 | US | Maryland | Carroll | 24013 | 4906 | 163 | 0 | 4743 | 39.56453592 | -77.02373735 | 2020-12-27 05:22:55 | Carroll, Maryland, US |
2129683 | 2129683 | 2020-12-17 | US | Minnesota | Blue Earth | 27013 | 4765 | 22 | 0 | 4743 | 44.03554215 | -94.06699781 | 2020-12-18 05:28:18 | Blue Earth, Minnesota, US |
2192773 | 2192773 | 2020-10-21 | US | Iowa | Dubuque | 19061 | 4797 | 54 | 0 | 4743 | 42.46815349 | -90.88181925 | 2020-10-22 04:24:27 | Dubuque, Iowa, US |
3782491 | 3782491 | 2020-10-13 | US | Colorado | Boulder | 8013 | 5138 | 79 | 0 | 4743 | 40.09313619 | -105.3546767 | 2020-10-14 04:24:05 | Boulder, Colorado, US |
1246186 | 1246186 | 2020-09-08 | US | Ohio | Butler | 39017 | 4837 | 94 | 0 | 4743 | 39.44012838 | -84.57388716 | 2020-09-09 04:28:48 | Butler, Ohio, US |
442518 | 442518 | 2020-07-26 | Ukraine | Kiev | 7620 | 129 | 2748 | 4743 | 50.4501 | 30.5234 | 2020-07-27 04:35:02 | Kiev, Ukraine |
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]);