johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where active = 7727 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1188856 | 1188856 | 2021-05-31 | Mongolia | 58439 | 253 | 50436 | 7727 | 46.8625 | 103.8467 | 2021-06-01 04:23:09 | Mongolia | |||
3369406 | 3369406 | 2021-03-21 | Mexico | Campeche | 8810 | 1083 | 0 | 7727 | 19.8301 | -90.5349 | 2021-03-22 05:25:43 | Campeche, Mexico | ||
3257150 | 3257150 | 2021-03-02 | US | Texas | Angelina | 48005 | 6869 | 257 | 0 | 7727 | 31.25457347 | -94.60901487 | 2021-03-03 05:23:28 | Angelina, Texas, US |
2184311 | 2184311 | 2021-02-26 | US | Florida | Sumter | 12119 | 7965 | 238 | 0 | 7727 | 28.70181754 | -82.0794267 | 2021-02-27 05:22:28 | Sumter, Florida, US |
184548 | 184548 | 2021-02-21 | US | Ohio | Tuscarawas | 39157 | 7964 | 237 | 0 | 7727 | 40.44214695 | -81.47226262 | 2021-02-22 05:24:21 | Tuscarawas, Ohio, US |
3603485 | 3603485 | 2021-02-17 | US | Ohio | Columbiana | 39029 | 7942 | 215 | 0 | 7727 | 40.76932373 | -80.78094576 | 2021-02-18 05:22:58 | Columbiana, Ohio, US |
613584 | 613584 | 2021-02-08 | France | Mayotte | 10755 | 64 | 2964 | 7727 | -12.8275 | 45.166244 | 2021-02-09 05:23:30 | Mayotte, France | ||
1672353 | 1672353 | 2021-02-07 | France | Mayotte | 10755 | 64 | 2964 | 7727 | -12.8275 | 45.166244 | 2021-02-08 05:22:39 | Mayotte, France | ||
974814 | 974814 | 2021-02-06 | France | Mayotte | 10755 | 64 | 2964 | 7727 | -12.8275 | 45.166244 | 2021-02-07 05:23:00 | Mayotte, France | ||
974658 | 974658 | 2021-02-06 | Brazil | Mato Grosso do Sul | 165553 | 3012 | 153604 | 7727 | -20.7722 | -54.7852 | 2021-02-07 05:23:00 | Mato Grosso do Sul, Brazil | ||
1587916 | 1587916 | 2021-02-05 | Brazil | Mato Grosso do Sul | 165141 | 2999 | 153604 | 7727 | -20.7722 | -54.7852 | 2021-02-06 05:23:55 | Mato Grosso do Sul, Brazil | ||
2628166 | 2628166 | 2021-01-10 | US | North Carolina | Cleveland | 37045 | 7883 | 156 | 0 | 7727 | 35.33553364 | -81.55204486 | 2021-01-11 05:21:50 | Cleveland, North Carolina, US |
2121996 | 2121996 | 2020-12-20 | US | North Carolina | Buncombe | 37021 | 7869 | 142 | 0 | 7727 | 35.61113393 | -82.53305 | 2020-12-21 05:27:58 | Buncombe, North Carolina, US |
1632266 | 1632266 | 2020-12-05 | India | Punjab | 155424 | 4906 | 142791 | 7727 | 30.841465000000003 | 75.40879 | 2020-12-06 05:26:18 | Punjab, India | ||
2918393 | 2918393 | 2020-11-14 | US | Texas | Smith | 48423 | 3331 | 174 | 0 | 7727 | 32.37474036 | -95.2717568 | 2020-11-15 05:26:53 | Smith, Texas, US |
2080326 | 2080326 | 2020-10-31 | US | Alabama | Shelby | 1117 | 7797 | 70 | 0 | 7727 | 33.26879845 | -86.66232561 | 2020-11-01 04:36:19 | Shelby, Alabama, US |
82204 | 82204 | 2020-10-14 | US | Texas | Jefferson | 48245 | 6567 | 144 | 0 | 7727 | 29.8832777 | -94.16434171 | 2020-10-15 04:24:28 | Jefferson, Texas, US |
2510902 | 2510902 | 2020-08-27 | US | Florida | Seminole | 12117 | 7896 | 169 | 0 | 7727 | 28.7158582 | -81.24060348 | 2020-08-28 04:28:11 | Seminole, Florida, US |
1930764 | 1930764 | 2020-05-05 | US | Connecticut | New Haven | 9009 | 8337 | 610 | 0 | 7727 | 41.408032500000004 | -72.93620426 | 2020-05-06 02:32:31 | New Haven, Connecticut, 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]);