johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
31 rows where confirmed = 15002 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
541505 | 541505 | 2022-10-26 | US | Puerto Rico | Humacao | 72069 | 15002 | 0 | 0 | 18.145211 | -65.810174 | 2022-10-27 04:22:01 | Humacao, Puerto Rico, US | |
898387 | 898387 | 2022-07-24 | US | New York | Genesee | 36037 | 15002 | 195 | 0 | 43.0022601 | -78.19135193 | 2022-07-25 04:20:51 | Genesee, New York, US | |
3272490 | 3272490 | 2022-06-19 | US | Tennessee | Monroe | 47123 | 15002 | 248 | 0 | 35.44550387 | -84.24902965 | 2022-06-20 04:21:01 | Monroe, Tennessee, US | |
1470764 | 1470764 | 2022-03-24 | US | Pennsylvania | Columbia | 42037 | 15002 | 242 | 0 | 41.04821986 | -76.40565017 | 2022-03-25 04:20:46 | Columbia, Pennsylvania, US | |
2319712 | 2319712 | 2022-03-16 | US | Alabama | Jackson | 1071 | 15002 | 233 | 0 | 34.78144169 | -85.99750489 | 2022-03-17 04:20:56 | Jackson, Alabama, US | |
2330377 | 2330377 | 2022-02-04 | US | Texas | Angelina | 48005 | 15002 | 446 | 0 | 31.25457347 | -94.60901487 | 2022-02-05 04:21:05 | Angelina, Texas, US | |
2327984 | 2327984 | 2022-02-04 | US | Colorado | Fremont | 8043 | 15002 | 182 | 0 | 38.47362326 | -105.43996670000001 | 2022-02-05 04:21:05 | Fremont, Colorado, US | |
1701020 | 1701020 | 2022-01-03 | US | Connecticut | Tolland | 9013 | 15002 | 211 | 0 | 41.85853803 | -72.3308481 | 2022-01-04 04:22:17 | Tolland, Connecticut, US | |
2170024 | 2170024 | 2022-01-01 | US | Ohio | Erie | 39043 | 15002 | 223 | 0 | 41.36796058 | -82.62904521 | 2022-01-02 04:20:52 | Erie, Ohio, US | |
2779455 | 2779455 | 2021-12-31 | US | Ohio | Erie | 39043 | 15002 | 223 | 0 | 41.36796058 | -82.62904521 | 2022-01-01 04:22:14 | Erie, Ohio, US | |
3819983 | 3819983 | 2021-12-23 | US | Wisconsin | Manitowoc | 55071 | 15002 | 134 | 0 | 44.11946801 | -87.80928853 | 2021-12-24 04:21:34 | Manitowoc, Wisconsin, US | |
3817974 | 3817974 | 2021-12-23 | US | Maine | Androscoggin | 23001 | 15002 | 154 | 0 | 44.1664747 | -70.20380627 | 2021-12-24 04:21:34 | Androscoggin, Maine, US | |
689378 | 689378 | 2021-11-13 | US | Texas | Bastrop | 48021 | 15002 | 179 | 0 | 30.10370699 | -97.31206354 | 2021-11-14 04:21:31 | Bastrop, Texas, US | |
717487 | 717487 | 2021-11-12 | US | Texas | Bastrop | 48021 | 15002 | 179 | 0 | 30.10370699 | -97.31206354 | 2021-11-13 04:21:38 | Bastrop, Texas, US | |
279204 | 279204 | 2021-11-03 | US | Texas | Bastrop | 48021 | 15002 | 175 | 0 | 30.10370699 | -97.31206354 | 2021-11-04 04:22:20 | Bastrop, Texas, US | |
1238024 | 1238024 | 2021-09-27 | US | North Carolina | Wayne | 37191 | 15002 | 288 | 0 | 35.36438125 | -78.00027268 | 2021-09-28 04:21:28 | Wayne, North Carolina, US | |
3011365 | 3011365 | 2021-09-22 | Japan | Okayama | 15002 | 135 | 0 | 34.89246 | 133.826252 | 2021-09-23 04:21:43 | Okayama, Japan | |||
1374563 | 1374563 | 2021-09-15 | Mali | 15002 | 543 | 0 | 17.570692 | -3.996166000000001 | 2021-09-16 04:22:19 | Mali | ||||
3165316 | 3165316 | 2021-08-23 | Andorra | 15002 | 130 | 0 | 42.5063 | 1.5218 | 2021-08-24 04:21:19 | Andorra | ||||
3334215 | 3334215 | 2021-07-21 | US | Pennsylvania | Monroe | 42089 | 15002 | 322 | 0 | 41.05934058 | -75.34031025 | 2021-07-22 04:21:19 | Monroe, Pennsylvania, US | |
2676507 | 2676507 | 2021-07-18 | US | Pennsylvania | Schuylkill | 42107 | 15002 | 413 | 0 | 40.70497338 | -76.2150785 | 2021-07-19 04:21:24 | Schuylkill, Pennsylvania, US | |
778205 | 778205 | 2021-07-08 | Colombia | Choco | 15002 | 357 | 14244 | 401 | 5.2528 | -76.82600000000002 | 2021-07-09 04:21:21 | Choco, Colombia | ||
3032938 | 3032938 | 2021-06-16 | US | Pennsylvania | Cambria | 42021 | 15002 | 437 | 0 | 40.49527404 | -78.71377428 | 2021-06-17 04:22:36 | Cambria, Pennsylvania, US | |
2006862 | 2006862 | 2021-05-12 | US | New Mexico | San Juan | 35045 | 15002 | 472 | 0 | 36.50838318 | -108.320437 | 2021-05-13 04:20:51 | San Juan, New Mexico, US | |
956112 | 956112 | 2021-04-25 | US | Iowa | Woodbury | 19193 | 15002 | 224 | 0 | 42.38979414 | -96.0459439 | 2021-04-26 04:21:04 | Woodbury, Iowa, US | |
3540231 | 3540231 | 2021-02-12 | US | Georgia | Columbia | 13073 | 15002 | 170 | 0 | 14832 | 33.54534185 | -82.263524 | 2021-02-13 05:22:12 | Columbia, Georgia, US |
2542917 | 2542917 | 2021-01-07 | US | Louisiana | Ouachita | 22073 | 15002 | 311 | 0 | 14691 | 32.47645559 | -92.15704172 | 2021-01-08 05:22:42 | Ouachita, Louisiana, US |
681568 | 681568 | 2020-11-23 | US | Utah | Davis | 49011 | 15002 | 57 | 0 | 14945 | 40.99001837 | -112.1139997 | 2020-11-24 05:27:31 | Davis, Utah, US |
1026213 | 1026213 | 2020-10-17 | Colombia | Sucre | 15002 | 600 | 13843 | 559 | 8.814 | -74.7233 | 2020-10-18 04:24:25 | Sucre, Colombia | ||
2454824 | 2454824 | 2020-09-19 | Kosovo | 15002 | 614 | 12451 | 1937 | 42.602636 | 20.902977 | 2020-09-20 04:22:00 | Kosovo | |||
3610193 | 3610193 | 2020-08-06 | US | Louisiana | Jefferson | 22051 | 15002 | 521 | 0 | 14481 | 29.74075478 | -90.11115756 | 2020-08-07 04:35:11 | Jefferson, Louisiana, 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]);