johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where active = 5691 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 17
- India 1
- Spain 1
- Trinidad and Tobago 1
- Uzbekistan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2371850 | 2371850 | 2021-07-20 | Trinidad and Tobago | 36354 | 1000 | 29663 | 5691 | 10.6918 | -61.2225 | 2021-07-21 04:21:40 | Trinidad and Tobago | |||
2339690 | 2339690 | 2021-06-15 | Spain | Ceuta | 5970 | 116 | 163 | 5691 | 35.8894 | -5.3213 | 2021-06-16 04:22:32 | Ceuta, Spain | ||
182520 | 182520 | 2021-02-21 | US | Arkansas | Greene | 5055 | 5765 | 74 | 0 | 5691 | 36.11735460000001 | -90.55832668 | 2021-02-22 05:24:21 | Greene, Arkansas, US |
742794 | 742794 | 2021-02-20 | US | Arkansas | Greene | 5055 | 5765 | 74 | 0 | 5691 | 36.11735460000001 | -90.55832668 | 2021-02-21 05:24:33 | Greene, Arkansas, US |
3601604 | 3601604 | 2021-02-17 | US | California | San Benito | 6069 | 5742 | 57 | 0 | 5691 | 36.60308176 | -121.069975 | 2021-02-18 05:22:58 | San Benito, California, US |
1341188 | 1341188 | 2021-02-15 | US | Tennessee | Carter | 47019 | 5822 | 147 | 0 | 5691 | 36.28969086 | -82.12588974 | 2021-02-16 05:24:38 | Carter, Tennessee, US |
3981038 | 3981038 | 2021-02-10 | US | Ohio | Hancock | 39063 | 5813 | 122 | 0 | 5691 | 41.00250487 | -83.66838948 | 2021-02-11 05:23:55 | Hancock, Ohio, US |
1095025 | 1095025 | 2021-01-20 | US | Idaho | Madison | 16065 | 5712 | 21 | 0 | 5691 | 43.78141028 | -111.65384740000002 | 2021-01-21 05:22:01 | Madison, Idaho, US |
3763113 | 3763113 | 2020-12-28 | US | Louisiana | Terrebonne | 22109 | 5838 | 147 | 0 | 5691 | 29.37343766 | -90.82626855 | 2020-12-29 05:22:37 | Terrebonne, Louisiana, US |
930351 | 930351 | 2020-12-21 | US | Pennsylvania | Fayette | 42051 | 5751 | 60 | 0 | 5691 | 39.92041012 | -79.64291195 | 2020-12-22 05:22:33 | Fayette, Pennsylvania, US |
1587070 | 1587070 | 2020-11-30 | US | Tennessee | Blount | 47009 | 5906 | 61 | 0 | 5691 | 35.68938198 | -83.92847788 | 2020-12-01 05:26:18 | Blount, Tennessee, US |
865563 | 865563 | 2020-11-12 | US | Georgia | Forsyth | 13117 | 5748 | 57 | 0 | 5691 | 34.22604035 | -84.12315129999998 | 2020-11-13 05:25:30 | Forsyth, Georgia, US |
275523 | 275523 | 2020-11-10 | US | Virginia | Norfolk | 51710 | 5777 | 86 | 0 | 5691 | 36.89934014 | -76.26420872 | 2020-11-11 05:25:30 | Norfolk, Virginia, US |
755503 | 755503 | 2020-10-28 | US | Iowa | Linn | 19113 | 5823 | 132 | 0 | 5691 | 42.07923082 | -91.59809485 | 2020-10-29 04:24:49 | Linn, Iowa, US |
1795340 | 1795340 | 2020-10-19 | US | Florida | Okaloosa | 12091 | 5820 | 129 | 0 | 5691 | 30.69143028 | -86.59267105 | 2020-10-20 04:24:22 | Okaloosa, Florida, US |
1045784 | 1045784 | 2020-09-30 | India | Tripura | 26066 | 283 | 20092 | 5691 | 23.746783 | 91.743565 | 2020-10-01 04:23:42 | Tripura, India | ||
549575 | 549575 | 2020-09-12 | US | South Carolina | Spartanburg | 45083 | 5872 | 181 | 0 | 5691 | 34.92960077 | -81.99225984 | 2020-09-13 04:30:52 | Spartanburg, South Carolina, US |
1445031 | 1445031 | 2020-09-11 | US | Arkansas | Benton | 5007 | 5752 | 61 | 0 | 5691 | 36.33644656 | -94.25680817 | 2020-09-12 04:25:05 | Benton, Arkansas, US |
814643 | 814643 | 2020-09-05 | US | Indiana | Elkhart | 18039 | 5791 | 100 | 0 | 5691 | 41.59761169 | -85.85875695 | 2020-09-06 04:28:33 | Elkhart, Indiana, US |
3201830 | 3201830 | 2020-07-18 | US | Idaho | Ada | 16001 | 5723 | 32 | 0 | 5691 | 43.4526575 | -116.24155159999998 | 2020-07-19 04:34:58 | Ada, Idaho, US |
2159157 | 2159157 | 2020-07-14 | Uzbekistan | 14085 | 67 | 8327 | 5691 | 41.377491 | 64.585262 | 2020-07-15 04:34:39 | Uzbekistan |
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]);