johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
41 rows where confirmed = 12092 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3268089 | 3268089 | 2022-05-04 | US | Oklahoma | Pontotoc | 40123 | 12092 | 147 | 0 | 34.72959848 | -96.68337199 | 2022-05-05 04:20:55 | Pontotoc, Oklahoma, US | |
1574728 | 1574728 | 2022-05-03 | US | Oklahoma | Pontotoc | 40123 | 12092 | 147 | 0 | 34.72959848 | -96.68337199 | 2022-05-04 04:20:59 | Pontotoc, Oklahoma, US | |
465988 | 465988 | 2022-05-02 | US | Oklahoma | Pontotoc | 40123 | 12092 | 147 | 0 | 34.72959848 | -96.68337199 | 2022-05-03 04:21:00 | Pontotoc, Oklahoma, US | |
3918627 | 3918627 | 2022-05-01 | US | Oklahoma | Pontotoc | 40123 | 12092 | 147 | 0 | 34.72959848 | -96.68337199 | 2022-05-02 04:21:10 | Pontotoc, Oklahoma, US | |
2843431 | 2843431 | 2022-04-30 | US | Oklahoma | Pontotoc | 40123 | 12092 | 147 | 0 | 34.72959848 | -96.68337199 | 2022-05-01 04:20:57 | Pontotoc, Oklahoma, US | |
1159744 | 1159744 | 2022-04-29 | US | Oklahoma | Pontotoc | 40123 | 12092 | 147 | 0 | 34.72959848 | -96.68337199 | 2022-04-30 04:21:05 | Pontotoc, Oklahoma, US | |
1698926 | 1698926 | 2022-04-28 | US | Oklahoma | Pontotoc | 40123 | 12092 | 147 | 0 | 34.72959848 | -96.68337199 | 2022-04-29 04:20:59 | Pontotoc, Oklahoma, US | |
3322520 | 3322520 | 2022-04-07 | US | New York | Washington | 36115 | 12092 | 113 | 0 | 43.31153794 | -73.43043448 | 2022-04-08 04:20:48 | Washington, New York, US | |
2752489 | 2752489 | 2022-04-04 | US | Wyoming | Campbell | 56005 | 12092 | 147 | 0 | 44.24886082 | -105.54744040000001 | 2022-04-05 04:20:48 | Campbell, Wyoming, US | |
3733835 | 3733835 | 2022-04-03 | US | Wyoming | Campbell | 56005 | 12092 | 147 | 0 | 44.24886082 | -105.54744040000001 | 2022-04-04 04:20:51 | Campbell, Wyoming, US | |
503270 | 503270 | 2022-04-02 | US | Wyoming | Campbell | 56005 | 12092 | 147 | 0 | 44.24886082 | -105.54744040000001 | 2022-04-03 04:20:48 | Campbell, Wyoming, US | |
3354255 | 3354255 | 2022-04-01 | US | Wyoming | Campbell | 56005 | 12092 | 147 | 0 | 44.24886082 | -105.54744040000001 | 2022-04-02 04:20:47 | Campbell, Wyoming, US | |
3077725 | 3077725 | 2022-02-09 | United Kingdom | Guernsey | 12092 | 31 | 0 | 0 | 49.448196 | -2.58949 | 2022-02-10 04:21:14 | Guernsey, United Kingdom | ||
99079 | 99079 | 2022-01-14 | Canada | Newfoundland and Labrador | 12092 | 24 | 0 | 53.1355 | -57.6604 | 2022-01-15 04:21:07 | Newfoundland and Labrador, Canada | |||
3689795 | 3689795 | 2022-01-13 | US | North Carolina | Duplin | 37061 | 12092 | 202 | 0 | 34.93449805 | -77.93140529 | 2022-01-14 04:21:54 | Duplin, North Carolina, US | |
1322750 | 1322750 | 2021-11-14 | US | Arkansas | Pope | 5115 | 12092 | 159 | 0 | 35.44871474 | -93.03212219 | 2021-11-15 04:21:36 | Pope, Arkansas, US | |
2848079 | 2848079 | 2021-11-10 | US | Texas | Starr | 48427 | 12092 | 331 | 0 | 26.56150059 | -98.73892358 | 2021-11-11 04:21:45 | Starr, Texas, US | |
3009216 | 3009216 | 2021-10-11 | US | Missouri | Cape Girardeau | 29031 | 12092 | 153 | 0 | 37.38489388 | -89.6843587 | 2021-10-12 04:21:09 | Cape Girardeau, Missouri, US | |
467331 | 467331 | 2021-10-07 | Iceland | 12092 | 33 | 0 | 64.9631 | -19.0208 | 2021-10-08 04:21:25 | Iceland | ||||
2776168 | 2776168 | 2021-09-30 | US | Texas | Orange | 48361 | 12092 | 243 | 0 | 30.11879481 | -93.89412775 | 2021-10-01 04:21:35 | Orange, Texas, US | |
709624 | 709624 | 2021-09-29 | US | Texas | Orange | 48361 | 12092 | 239 | 0 | 30.11879481 | -93.89412775 | 2021-09-30 04:21:20 | Orange, Texas, US | |
1817154 | 1817154 | 2021-09-19 | US | North Carolina | Wilson | 37195 | 12092 | 201 | 0 | 35.70625477 | -77.917978 | 2021-09-20 04:21:22 | Wilson, North Carolina, US | |
18734 | 18734 | 2021-09-18 | US | North Carolina | Wilson | 37195 | 12092 | 201 | 0 | 35.70625477 | -77.917978 | 2021-09-19 04:21:34 | Wilson, North Carolina, US | |
2620419 | 2620419 | 2021-09-17 | US | North Carolina | Wilson | 37195 | 12092 | 201 | 0 | 35.70625477 | -77.917978 | 2021-09-18 04:21:24 | Wilson, North Carolina, US | |
512589 | 512589 | 2021-08-19 | US | Georgia | Walton | 13297 | 12092 | 268 | 0 | 33.78017694 | -83.73552314 | 2021-08-20 04:21:33 | Walton, Georgia, US | |
2765732 | 2765732 | 2021-07-01 | US | Georgia | Floyd | 13115 | 12092 | 239 | 0 | 34.26268279 | -85.21577392 | 2021-07-02 04:21:47 | Floyd, Georgia, US | |
3381080 | 3381080 | 2021-06-13 | Bahamas | 12092 | 236 | 11081 | 775 | 25.025885 | -78.035889 | 2021-06-14 04:22:46 | Bahamas | |||
1736214 | 1736214 | 2021-06-12 | Bahamas | 12092 | 236 | 11081 | 775 | 25.025885 | -78.035889 | 2021-06-13 04:22:44 | Bahamas | |||
3970255 | 3970255 | 2021-06-11 | Bahamas | 12092 | 236 | 11081 | 775 | 25.025885 | -78.035889 | 2021-06-12 04:22:22 | Bahamas | |||
826023 | 826023 | 2021-06-06 | US | Arizona | Cochise | 4003 | 12092 | 290 | 0 | 31.87934684 | -109.7516088 | 2021-06-07 04:22:51 | Cochise, Arizona, US | |
85298 | 85298 | 2021-05-25 | US | New Mexico | Sandoval | 35043 | 12092 | 230 | 0 | 35.68862401 | -106.8687803 | 2021-05-26 04:20:35 | Sandoval, New Mexico, US | |
1412244 | 1412244 | 2021-04-23 | US | Texas | Rockwall | 48397 | 12092 | 152 | 0 | 32.89779518 | -96.40771592 | 2021-04-24 04:20:38 | Rockwall, Texas, US | |
3665137 | 3665137 | 2021-03-09 | US | Louisiana | Tangipahoa | 22105 | 12092 | 274 | 0 | 30.62888673 | -90.40664996 | 2021-03-10 05:24:35 | Tangipahoa, Louisiana, US | |
2360996 | 2360996 | 2021-03-08 | US | Louisiana | Tangipahoa | 22105 | 12092 | 274 | 0 | 30.62888673 | -90.40664996 | 2021-03-09 05:28:19 | Tangipahoa, Louisiana, US | |
1001127 | 1001127 | 2021-03-01 | US | Pennsylvania | Schuylkill | 42107 | 12092 | 368 | 0 | 11724 | 40.70497338 | -76.2150785 | 2021-03-02 05:23:30 | Schuylkill, Pennsylvania, US |
3838717 | 3838717 | 2020-11-21 | US | New York | Monroe | 36055 | 12092 | 313 | 0 | 11779 | 43.14638895 | -77.69322942 | 2020-11-22 05:25:45 | Monroe, New York, US |
3836863 | 3836863 | 2020-11-21 | US | Alabama | Madison | 1089 | 12092 | 146 | 0 | 11946 | 34.76327133 | -86.55069633 | 2020-11-22 05:25:45 | Madison, Alabama, US |
2689479 | 2689479 | 2020-10-08 | Chile | Tarapaca | 12092 | 234 | 11520 | 338 | -19.9232 | -69.5132 | 2020-10-09 04:23:59 | Tarapaca, Chile | ||
344467 | 344467 | 2020-09-14 | Russia | Dagestan Republic | 12092 | 524 | 10401 | 1167 | 43.05749160000001 | 47.1332224 | 2020-09-15 03:22:50 | Dagestan Republic, Russia | ||
1920267 | 1920267 | 2020-08-10 | Colombia | Cundinamarca | 12092 | 327 | 6896 | 4869 | 5.026 | -74.03 | 2020-08-11 04:35:08 | Cundinamarca, Colombia | ||
3792891 | 3792891 | 2020-08-05 | Chile | Biobio | 12092 | 127 | 10557 | 1408 | -37.4464 | -72.1416 | 2020-08-06 04:35:02 | Biobio, Chile |
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]);