johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
13 rows where confirmed = 31295 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2241752 | 2241752 | 2022-06-28 | US | North Carolina | Orange | 37135 | 31295 | 137 | 0 | 36.06092947 | -79.12167935 | 2022-06-29 04:20:59 | Orange, North Carolina, US | |
2149994 | 2149994 | 2022-06-27 | US | North Carolina | Orange | 37135 | 31295 | 137 | 0 | 36.06092947 | -79.12167935 | 2022-06-28 04:20:58 | Orange, North Carolina, US | |
477795 | 477795 | 2022-06-26 | US | North Carolina | Orange | 37135 | 31295 | 137 | 0 | 36.06092947 | -79.12167935 | 2022-06-27 04:21:00 | Orange, North Carolina, US | |
941170 | 941170 | 2022-06-25 | US | North Carolina | Orange | 37135 | 31295 | 137 | 0 | 36.06092947 | -79.12167935 | 2022-06-26 04:21:02 | Orange, North Carolina, US | |
3348990 | 3348990 | 2022-06-24 | US | North Carolina | Orange | 37135 | 31295 | 137 | 0 | 36.06092947 | -79.12167935 | 2022-06-25 04:20:57 | Orange, North Carolina, US | |
1650731 | 1650731 | 2022-06-23 | US | North Carolina | Orange | 37135 | 31295 | 137 | 0 | 36.06092947 | -79.12167935 | 2022-06-24 04:20:58 | Orange, North Carolina, US | |
2189966 | 2189966 | 2022-06-22 | US | North Carolina | Orange | 37135 | 31295 | 137 | 0 | 36.06092947 | -79.12167935 | 2022-06-23 04:20:55 | Orange, North Carolina, US | |
3896978 | 3896978 | 2022-05-19 | US | Illinois | Macon | 17115 | 31295 | 344 | 0 | 39.86064913 | -88.96342505 | 2022-05-20 04:20:57 | Macon, Illinois, US | |
1358915 | 1358915 | 2021-11-27 | US | California | San Luis Obispo | 6079 | 31295 | 358 | 0 | 35.38822029 | -120.4039028 | 2021-11-28 04:22:43 | San Luis Obispo, California, US | |
3927986 | 3927986 | 2021-10-02 | India | Nagaland | 31295 | 666 | 0 | 26.06702 | 94.470302 | 2021-10-03 04:21:24 | Nagaland, India | |||
2693405 | 2693405 | 2021-07-06 | Belgium | Luxembourg | 31295 | 0 | 0 | 31295 | 50.0547 | 5.4677 | 2021-07-07 04:21:20 | Luxembourg, Belgium | ||
280250 | 280250 | 2021-02-24 | Malawi | 31295 | 1029 | 17570 | 12696 | -13.2543 | 34.3015 | 2021-02-25 05:24:57 | Malawi | |||
3316065 | 3316065 | 2020-09-22 | Colombia | Cundinamarca | 31295 | 916 | 25677 | 4702 | 5.026 | -74.03 | 2020-09-23 04:23:00 | Cundinamarca, Colombia |
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]);