johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
21 rows where confirmed = 30155 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1890851 | 1890851 | 2022-09-14 | US | Minnesota | Carver | 27019 | 30155 | 125 | 0 | 44.82017001 | -93.8009918 | 2022-09-15 04:21:02 | Carver, Minnesota, US | |
373906 | 373906 | 2022-09-13 | US | Minnesota | Carver | 27019 | 30155 | 125 | 0 | 44.82017001 | -93.8009918 | 2022-09-14 04:20:44 | Carver, Minnesota, US | |
2396508 | 2396508 | 2022-09-12 | US | Minnesota | Carver | 27019 | 30155 | 125 | 0 | 44.82017001 | -93.8009918 | 2022-09-13 04:20:57 | Carver, Minnesota, US | |
3767586 | 3767586 | 2022-09-11 | US | Minnesota | Carver | 27019 | 30155 | 125 | 0 | 44.82017001 | -93.8009918 | 2022-09-12 04:20:58 | Carver, Minnesota, US | |
3826161 | 3826161 | 2022-09-10 | US | Minnesota | Carver | 27019 | 30155 | 125 | 0 | 44.82017001 | -93.8009918 | 2022-09-11 04:20:50 | Carver, Minnesota, US | |
964618 | 964618 | 2022-09-09 | US | Minnesota | Carver | 27019 | 30155 | 125 | 0 | 44.82017001 | -93.8009918 | 2022-09-10 04:21:10 | Carver, Minnesota, US | |
255020 | 255020 | 2022-09-08 | US | Minnesota | Carver | 27019 | 30155 | 125 | 0 | 44.82017001 | -93.8009918 | 2022-09-09 04:21:11 | Carver, Minnesota, US | |
1346633 | 1346633 | 2022-08-10 | Sweden | Blekinge | 30155 | 171 | 0 | 56.2784 | 15.018 | 2022-08-11 04:20:49 | Blekinge, Sweden | |||
1086388 | 1086388 | 2022-08-09 | Sweden | Blekinge | 30155 | 171 | 0 | 56.2784 | 15.018 | 2022-08-10 04:20:57 | Blekinge, Sweden | |||
3543803 | 3543803 | 2022-08-08 | Sweden | Blekinge | 30155 | 171 | 0 | 56.2784 | 15.018 | 2022-08-09 04:20:34 | Blekinge, Sweden | |||
1070206 | 1070206 | 2022-08-07 | Sweden | Blekinge | 30155 | 171 | 0 | 56.2784 | 15.018 | 2022-08-08 04:21:08 | Blekinge, Sweden | |||
1940794 | 1940794 | 2022-08-06 | Sweden | Blekinge | 30155 | 171 | 0 | 56.2784 | 15.018 | 2022-08-07 04:20:54 | Blekinge, Sweden | |||
880593 | 880593 | 2022-08-05 | Sweden | Blekinge | 30155 | 171 | 0 | 56.2784 | 15.018 | 2022-08-06 04:20:56 | Blekinge, Sweden | |||
2009004 | 2009004 | 2022-08-04 | Sweden | Blekinge | 30155 | 171 | 0 | 56.2784 | 15.018 | 2022-08-05 04:20:52 | Blekinge, Sweden | |||
443581 | 443581 | 2021-10-20 | Russia | Mordovia Republic | 30155 | 648 | 0 | 54.4419829 | 44.466114399999995 | 2021-10-21 04:21:18 | Mordovia Republic, Russia | |||
2772867 | 2772867 | 2021-09-30 | Gabon | 30155 | 186 | 0 | -0.8037 | 11.6094 | 2021-10-01 04:21:35 | Gabon | ||||
3759439 | 3759439 | 2021-09-21 | US | Missouri | St. Louis City | 29510 | 30155 | 578 | 0 | 38.63555736 | -90.24349225 | 2021-09-22 04:21:45 | St. Louis City, Missouri, US | |
811542 | 811542 | 2021-09-20 | US | Missouri | St. Louis City | 29510 | 30155 | 578 | 0 | 38.63555736 | -90.24349225 | 2021-09-21 04:21:26 | St. Louis City, Missouri, US | |
1815919 | 1815919 | 2021-09-19 | US | Indiana | Vanderburgh | 18163 | 30155 | 439 | 0 | 38.02658833 | -87.58763124 | 2021-09-20 04:21:22 | Vanderburgh, Indiana, US | |
2621013 | 2621013 | 2021-09-17 | US | Tennessee | Montgomery | 47125 | 30155 | 288 | 0 | 36.49609412 | -87.38550661 | 2021-09-18 04:21:24 | Montgomery, Tennessee, US | |
2602193 | 2602193 | 2020-10-10 | Peru | La Libertad | 30155 | 4329 | 0 | 25826 | -7.92139 | -78.370238 | 2020-10-11 04:23:46 | La Libertad, Peru |
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]);