johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
23 rows where confirmed = 22116 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
871003 | 871003 | 2022-12-11 | US | New Mexico | Lea | 35025 | 22116 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-12 04:21:01 | Lea, New Mexico, US | |
259533 | 259533 | 2022-12-10 | US | New Mexico | Lea | 35025 | 22116 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-11 04:20:50 | Lea, New Mexico, US | |
3938247 | 3938247 | 2022-12-09 | US | New Mexico | Lea | 35025 | 22116 | 406 | 0 | 32.79215361 | -103.4123733 | 2022-12-10 04:21:02 | Lea, New Mexico, US | |
3714376 | 3714376 | 2022-12-06 | Russia | Jewish Autonomous Okrug | 22116 | 561 | 0 | 48.57527615 | 132.6630746 | 2022-12-07 04:20:58 | Jewish Autonomous Okrug, Russia | |||
712820 | 712820 | 2022-11-01 | US | North Carolina | Sampson | 37163 | 22116 | 199 | 0 | 34.98820368 | -78.36914061 | 2022-11-02 04:22:09 | Sampson, North Carolina, US | |
3287269 | 3287269 | 2022-10-31 | US | North Carolina | Sampson | 37163 | 22116 | 199 | 0 | 34.98820368 | -78.36914061 | 2022-11-01 04:22:36 | Sampson, North Carolina, US | |
322302 | 322302 | 2022-10-30 | US | North Carolina | Sampson | 37163 | 22116 | 199 | 0 | 34.98820368 | -78.36914061 | 2022-10-31 04:21:36 | Sampson, North Carolina, US | |
914578 | 914578 | 2022-10-29 | US | North Carolina | Sampson | 37163 | 22116 | 199 | 0 | 34.98820368 | -78.36914061 | 2022-10-30 04:22:14 | Sampson, North Carolina, US | |
1368847 | 1368847 | 2022-10-28 | US | North Carolina | Sampson | 37163 | 22116 | 199 | 0 | 34.98820368 | -78.36914061 | 2022-10-29 04:21:13 | Sampson, North Carolina, US | |
3040702 | 3040702 | 2022-10-27 | US | North Carolina | Sampson | 37163 | 22116 | 199 | 0 | 34.98820368 | -78.36914061 | 2022-10-28 04:22:31 | Sampson, North Carolina, US | |
541122 | 541122 | 2022-10-26 | US | North Carolina | Sampson | 37163 | 22116 | 199 | 0 | 34.98820368 | -78.36914061 | 2022-10-27 04:22:01 | Sampson, North Carolina, US | |
3718775 | 3718775 | 2022-02-21 | US | California | Sutter | 6101 | 22116 | 210 | 0 | 39.03417539 | -121.6945899 | 2022-02-22 04:21:01 | Sutter, California, US | |
2904312 | 2904312 | 2021-12-19 | US | California | Yolo | 6113 | 22116 | 267 | 0 | 38.68278902 | -121.90182879999999 | 2021-12-20 04:21:43 | Yolo, California, US | |
2091558 | 2091558 | 2021-12-14 | US | Wisconsin | Sheboygan | 55117 | 22116 | 200 | 0 | 43.72099677 | -87.94579284 | 2021-12-15 03:22:16 | Sheboygan, Wisconsin, US | |
2132603 | 2132603 | 2021-10-01 | US | California | Shasta | 6089 | 22116 | 270 | 0 | 40.76391419 | -122.0396884 | 2021-10-02 04:21:25 | Shasta, California, US | |
250384 | 250384 | 2021-09-04 | US | Indiana | Johnson | 18081 | 22116 | 406 | 0 | 39.48994426 | -86.10149107 | 2021-09-05 04:21:33 | Johnson, Indiana, US | |
2673955 | 2673955 | 2021-07-18 | Pakistan | Azad Jammu and Kashmir | 22116 | 601 | 19995 | 1520 | 34.027401 | 73.947253 | 2021-07-19 04:21:24 | Azad Jammu and Kashmir, Pakistan | ||
2822531 | 2822531 | 2021-05-10 | US | Minnesota | Stearns | 27145 | 22116 | 221 | 0 | 45.55192576 | -94.61078221 | 2021-05-11 04:20:41 | Stearns, Minnesota, US | |
1616184 | 1616184 | 2021-03-05 | India | Chandigarh | 22116 | 355 | 21174 | 587 | 30.733839 | 76.76827800000002 | 2021-03-06 04:23:41 | Chandigarh, India | ||
2408733 | 2408733 | 2020-12-23 | US | Missouri | Jackson | 29095 | 22116 | 222 | 0 | 21894 | 39.01002188 | -94.34724536 | 2020-12-24 05:23:04 | Jackson, Missouri, US |
3836321 | 3836321 | 2020-11-21 | Colombia | Caldas | 22116 | 419 | 19513 | 2184 | 5.2983 | -75.2479 | 2020-11-22 05:25:45 | Caldas, Colombia | ||
1728653 | 1728653 | 2020-11-08 | Peru | San Martin | 22116 | 1542 | 0 | 20574 | -7.039531 | -76.729127 | 2020-11-09 05:25:45 | San Martin, Peru | ||
2234919 | 2234919 | 2020-07-03 | Honduras | 22116 | 605 | 2250 | 19261 | 15.2 | -86.2419 | 2020-07-04 04:33:51 | Honduras |
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]);