johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
40 rows where active = 3910 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1715955 | 1715955 | 2021-06-25 | Ukraine | Kiev | 213030 | 5186 | 203934 | 3910 | 50.4501 | 30.5234 | 2021-06-26 04:21:43 | Kiev, Ukraine | ||
562937 | 562937 | 2021-06-22 | India | Uttar Pradesh | 1704678 | 22282 | 1678486 | 3910 | 26.925425 | 80.560982 | 2021-06-23 04:21:46 | Uttar Pradesh, India | ||
3358637 | 3358637 | 2021-06-21 | India | Tripura | 62745 | 654 | 58181 | 3910 | 23.746783 | 91.743565 | 2021-06-22 04:21:34 | Tripura, India | ||
3970620 | 3970620 | 2021-06-11 | Mali | 14336 | 523 | 9903 | 3910 | 17.570692 | -3.996166000000001 | 2021-06-12 04:22:22 | Mali | |||
1093280 | 1093280 | 2021-03-03 | US | Texas | San Patricio | 48409 | 3780 | 134 | 0 | 3910 | 28.00880118 | -97.51763891 | 2021-03-04 05:24:24 | San Patricio, Texas, US |
1091726 | 1091726 | 2021-03-03 | US | Michigan | Marquette | 26103 | 3966 | 56 | 0 | 3910 | 46.4338914 | -87.64043701 | 2021-03-04 05:24:24 | Marquette, Michigan, US |
3255385 | 3255385 | 2021-03-02 | US | Iowa | Wapello | 19179 | 4018 | 108 | 0 | 3910 | 41.03064984 | -92.40954728 | 2021-03-03 05:23:28 | Wapello, Iowa, US |
1000910 | 1000910 | 2021-03-01 | US | Ohio | Knox | 39083 | 4016 | 106 | 0 | 3910 | 40.39830217 | -82.42027563 | 2021-03-02 05:23:30 | Knox, Ohio, US |
183676 | 183676 | 2021-02-21 | US | Michigan | Isabella | 26073 | 3983 | 73 | 0 | 3910 | 43.64060976 | -84.84664923 | 2021-02-22 05:24:21 | Isabella, Michigan, US |
743950 | 743950 | 2021-02-20 | US | Michigan | Isabella | 26073 | 3983 | 73 | 0 | 3910 | 43.64060976 | -84.84664923 | 2021-02-21 05:24:33 | Isabella, Michigan, US |
3051216 | 3051216 | 2021-02-16 | US | Illinois | Stephenson | 17177 | 3981 | 71 | 0 | 3910 | 42.35129217 | -89.662598 | 2021-02-17 05:23:10 | Stephenson, Illinois, US |
2680118 | 2680118 | 2021-02-13 | US | North Carolina | Chatham | 37037 | 3982 | 72 | 0 | 3910 | 35.70394416 | -79.25541492 | 2021-02-14 05:23:43 | Chatham, North Carolina, US |
1685961 | 1685961 | 2021-02-02 | US | Kentucky | Shelby | 21211 | 3943 | 33 | 0 | 3910 | 38.21476019 | -85.194223 | 2021-02-03 05:22:52 | Shelby, Kentucky, US |
3154583 | 3154583 | 2021-01-27 | US | Illinois | Franklin | 17055 | 3971 | 61 | 0 | 3910 | 37.99189086 | -88.92567818 | 2021-01-28 05:22:24 | Franklin, Illinois, US |
2571164 | 2571164 | 2021-01-25 | US | West Virginia | Raleigh | 54081 | 3950 | 40 | 0 | 3910 | 37.76936795 | -81.2456041 | 2021-01-26 05:22:02 | Raleigh, West Virginia, US |
1759989 | 1759989 | 2021-01-24 | US | Florida | Hendry | 12051 | 3965 | 55 | 0 | 3910 | 26.55386945 | -81.16469006 | 2021-01-25 05:22:16 | Hendry, Florida, US |
3505446 | 3505446 | 2021-01-17 | US | Nebraska | Madison | 31119 | 3950 | 40 | 0 | 3910 | 41.91676024 | -97.6005481 | 2021-01-18 05:22:34 | Madison, Nebraska, US |
3104155 | 3104155 | 2021-01-16 | US | Puerto Rico | Caguas | 72025 | 3910 | 0 | 0 | 3910 | 18.211615 | -66.050779 | 2021-01-17 05:22:17 | Caguas, Puerto Rico, US |
2349709 | 2349709 | 2020-12-07 | US | North Carolina | Caldwell | 37027 | 3935 | 25 | 0 | 3910 | 35.95204977 | -81.54799522 | 2020-12-08 05:27:42 | Caldwell, North Carolina, US |
1584491 | 1584491 | 2020-11-30 | Syria | 7887 | 417 | 3560 | 3910 | 34.802075 | 38.99681500000001 | 2020-12-01 05:26:18 | Syria | |||
3192282 | 3192282 | 2020-11-22 | US | North Carolina | Cleveland | 37045 | 4014 | 104 | 0 | 3910 | 35.33553364 | -81.55204486 | 2020-11-23 05:25:26 | Cleveland, North Carolina, US |
2701707 | 2701707 | 2020-11-20 | Russia | Ivanovo Oblast | 14259 | 216 | 10133 | 3910 | 56.9167446 | 41.43521370000001 | 2020-11-21 05:25:51 | Ivanovo Oblast, Russia | ||
2921605 | 2921605 | 2020-11-04 | US | North Dakota | Ward | 38101 | 4196 | 56 | 0 | 3910 | 48.22390169 | -101.5436763 | 2020-11-05 06:05:03 | Ward, North Dakota, US |
2083564 | 2083564 | 2020-10-31 | Ukraine | Vinnytsia Oblast | 10342 | 182 | 6250 | 3910 | 49.2331 | 28.4682 | 2020-11-01 04:36:19 | Vinnytsia Oblast, Ukraine | ||
2860481 | 2860481 | 2020-10-16 | Ukraine | Zhytomyr Oblast | 9286 | 163 | 5213 | 3910 | 50.2547 | 28.6587 | 2020-10-17 04:24:12 | Zhytomyr Oblast, Ukraine | ||
786816 | 786816 | 2020-10-15 | US | Arizona | Mohave | 4015 | 4138 | 228 | 0 | 3910 | 35.70471703 | -113.7577902 | 2020-10-16 04:24:01 | Mohave, Arizona, US |
2731238 | 2731238 | 2020-09-15 | US | New York | Onondaga | 36067 | 4114 | 204 | 0 | 3910 | 43.00491923 | -76.19971155 | 2020-09-16 04:22:53 | Onondaga, New York, US |
2172089 | 2172089 | 2020-09-09 | US | California | Madera | 6039 | 3955 | 43 | 0 | 3910 | 37.21513971 | -119.76655890000002 | 2020-09-10 04:29:01 | Madera, California, US |
3484250 | 3484250 | 2020-08-20 | India | Goa | 13099 | 126 | 9063 | 3910 | 15.359682 | 74.057396 | 2020-08-21 04:27:41 | Goa, India | ||
149325 | 149325 | 2020-08-15 | US | Virginia | Norfolk | 51710 | 3944 | 34 | 0 | 3910 | 36.89934014 | -76.26420872 | 2020-08-16 04:27:42 | Norfolk, Virginia, US |
95101 | 95101 | 2020-08-04 | US | Texas | Brazos | 48041 | 4163 | 43 | 0 | 3910 | 30.663644800000004 | -96.30205577 | 2020-08-05 04:34:43 | Brazos, Texas, US |
439629 | 439629 | 2020-07-26 | US | Georgia | Clayton | 13063 | 4002 | 92 | 0 | 3910 | 33.54187245 | -84.35594188 | 2020-07-27 04:35:02 | Clayton, Georgia, US |
61210 | 61210 | 2020-07-23 | US | Florida | St. Lucie | 12111 | 4004 | 94 | 0 | 3910 | 27.37763908 | -80.47106649 | 2020-07-24 05:30:40 | St. Lucie, Florida, US |
121840 | 121840 | 2020-07-19 | Peru | Huanuco | 4307 | 397 | 0 | 3910 | -9.421676 | -76.040642 | 2020-07-20 05:34:40 | Huanuco, Peru | ||
2306814 | 2306814 | 2020-06-28 | Ghana | 16742 | 112 | 12720 | 3910 | 7.9465 | -1.0232 | 2020-06-29 04:33:44 | Ghana | |||
3638973 | 3638973 | 2020-05-30 | Brazil | Tocantins | 3981 | 71 | 0 | 3910 | -10.1753 | -48.2982 | 2020-05-31 02:32:45 | Tocantins, Brazil | ||
3416294 | 3416294 | 2020-05-17 | Italy | Lazio | 7446 | 622 | 2914 | 3910 | 41.89277044 | 12.48366722 | 2020-05-18 02:32:21 | Lazio, Italy | ||
3082079 | 3082079 | 2020-05-04 | US | New Jersey | Camden | 34007 | 4073 | 163 | 0 | 3910 | 39.80343818 | -74.96388753 | 2020-05-05 02:32:34 | Camden, New Jersey, US |
136221 | 136221 | 2020-04-29 | US | Maryland | Montgomery | 24031 | 4152 | 242 | 0 | 3910 | 39.13676329 | -77.20358245 | 2020-04-30 02:32:27 | Montgomery, Maryland, US |
587220 | 587220 | 2020-04-05 | US | New Jersey | Essex | 34013 | 4082 | 172 | 0 | 3910 | 40.78681335 | -74.24657979 | 2020-04-05 23:06:45 | Essex, 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]);