johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
45 rows where confirmed = 14615 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2139736 | 2139736 | 2022-12-01 | US | Wisconsin | Polk | 55095 | 14615 | 124 | 0 | 45.46130348 | -92.44182875 | 2022-12-02 04:21:07 | Polk, Wisconsin, US | |
1625831 | 1625831 | 2022-09-22 | US | Louisiana | St. Mary | 22101 | 14615 | 275 | 0 | 29.69262097 | -91.44702164 | 2022-09-23 04:23:13 | St. Mary, Louisiana, US | |
3987750 | 3987750 | 2022-09-15 | US | Indiana | Noble | 18113 | 14615 | 165 | 0 | 41.39672484 | -85.41966713 | 2022-09-16 04:21:19 | Noble, Indiana, US | |
1890267 | 1890267 | 2022-09-14 | US | Indiana | Noble | 18113 | 14615 | 165 | 0 | 41.39672484 | -85.41966713 | 2022-09-15 04:21:02 | Noble, Indiana, US | |
3746842 | 3746842 | 2022-09-07 | US | Minnesota | Kandiyohi | 27067 | 14615 | 145 | 0 | 45.1526059 | -95.00586446 | 2022-09-08 04:21:02 | Kandiyohi, Minnesota, US | |
116482 | 116482 | 2022-09-06 | US | Minnesota | Kandiyohi | 27067 | 14615 | 145 | 0 | 45.1526059 | -95.00586446 | 2022-09-07 04:20:59 | Kandiyohi, Minnesota, US | |
2635454 | 2635454 | 2022-09-05 | US | Minnesota | Kandiyohi | 27067 | 14615 | 145 | 0 | 45.1526059 | -95.00586446 | 2022-09-06 04:21:02 | Kandiyohi, Minnesota, US | |
2989018 | 2989018 | 2022-09-04 | US | Minnesota | Kandiyohi | 27067 | 14615 | 145 | 0 | 45.1526059 | -95.00586446 | 2022-09-05 04:21:01 | Kandiyohi, Minnesota, US | |
2714703 | 2714703 | 2022-09-03 | US | Minnesota | Kandiyohi | 27067 | 14615 | 145 | 0 | 45.1526059 | -95.00586446 | 2022-09-04 04:21:22 | Kandiyohi, Minnesota, US | |
1395408 | 1395408 | 2022-09-02 | US | Minnesota | Kandiyohi | 27067 | 14615 | 145 | 0 | 45.1526059 | -95.00586446 | 2022-09-03 04:21:04 | Kandiyohi, Minnesota, US | |
3549237 | 3549237 | 2022-09-01 | US | Minnesota | Kandiyohi | 27067 | 14615 | 145 | 0 | 45.1526059 | -95.00586446 | 2022-09-02 04:21:07 | Kandiyohi, Minnesota, US | |
2346432 | 2346432 | 2022-08-31 | US | Tennessee | Warren | 47177 | 14615 | 183 | 0 | 35.6728299 | -85.77969117 | 2022-09-01 04:21:03 | Warren, Tennessee, US | |
1489793 | 1489793 | 2022-07-26 | US | New Mexico | Otero | 35035 | 14615 | 201 | 0 | 32.61348406 | -105.7417604 | 2022-07-27 04:21:04 | Otero, New Mexico, US | |
466930 | 466930 | 2022-05-02 | US | Wisconsin | Calumet | 55015 | 14615 | 121 | 0 | 44.0816316 | -88.21780273 | 2022-05-03 04:21:00 | Calumet, Wisconsin, US | |
1327017 | 1327017 | 2022-04-26 | US | Georgia | Catoosa | 13047 | 14615 | 162 | 0 | 34.89872298 | -85.13757014 | 2022-04-27 04:20:52 | Catoosa, Georgia, US | |
3722971 | 3722971 | 2022-04-25 | US | Georgia | Catoosa | 13047 | 14615 | 162 | 0 | 34.89872298 | -85.13757014 | 2022-04-26 04:20:51 | Catoosa, Georgia, US | |
2029539 | 2029539 | 2022-04-24 | US | Georgia | Catoosa | 13047 | 14615 | 162 | 0 | 34.89872298 | -85.13757014 | 2022-04-25 04:20:56 | Catoosa, Georgia, US | |
747114 | 747114 | 2022-04-23 | US | Georgia | Catoosa | 13047 | 14615 | 162 | 0 | 34.89872298 | -85.13757014 | 2022-04-24 04:20:56 | Catoosa, Georgia, US | |
3437599 | 3437599 | 2022-04-22 | US | Georgia | Catoosa | 13047 | 14615 | 162 | 0 | 34.89872298 | -85.13757014 | 2022-04-23 04:20:50 | Catoosa, Georgia, US | |
2893184 | 2893184 | 2022-04-21 | US | Georgia | Catoosa | 13047 | 14615 | 162 | 0 | 34.89872298 | -85.13757014 | 2022-04-22 04:20:45 | Catoosa, Georgia, US | |
2308056 | 2308056 | 2022-04-20 | US | Georgia | Catoosa | 13047 | 14615 | 162 | 0 | 34.89872298 | -85.13757014 | 2022-04-21 04:20:46 | Catoosa, Georgia, US | |
3209242 | 3209242 | 2022-04-11 | US | Tennessee | Monroe | 47123 | 14615 | 241 | 0 | 35.44550387 | -84.24902965 | 2022-04-12 04:20:49 | Monroe, Tennessee, US | |
2478562 | 2478562 | 2022-03-30 | US | California | Tehama | 6103 | 14615 | 198 | 0 | 40.12570935 | -122.23701709999999 | 2022-03-31 04:20:56 | Tehama, California, US | |
158603 | 158603 | 2022-03-29 | US | California | Tehama | 6103 | 14615 | 200 | 0 | 40.12570935 | -122.23701709999999 | 2022-03-30 04:20:45 | Tehama, California, US | |
2202121 | 2202121 | 2022-03-06 | US | Ohio | Jefferson | 39081 | 14615 | 320 | 0 | 40.38614126 | -80.76259514 | 2022-03-07 04:20:47 | Jefferson, Ohio, US | |
2736384 | 2736384 | 2022-02-27 | US | Virginia | James City | 51095 | 14615 | 110 | 0 | 37.31156958 | -76.76950618 | 2022-02-28 04:21:05 | James City, Virginia, US | |
3049537 | 3049537 | 2022-02-26 | US | Virginia | James City | 51095 | 14615 | 110 | 0 | 37.31156958 | -76.76950618 | 2022-02-27 04:21:04 | James City, Virginia, US | |
578192 | 578192 | 2022-02-25 | US | Virginia | James City | 51095 | 14615 | 110 | 0 | 37.31156958 | -76.76950618 | 2022-02-26 04:21:12 | James City, Virginia, US | |
2446841 | 2446841 | 2022-02-22 | Malaysia | W.P. Labuan | 14615 | 152 | 0 | 5.2831 | 115.2308 | 2022-02-23 04:21:09 | W.P. Labuan, Malaysia | |||
1465754 | 1465754 | 2022-02-10 | US | Michigan | Montcalm | 26117 | 14615 | 192 | 0 | 43.31082541 | -85.15252824 | 2022-02-11 04:21:09 | Montcalm, Michigan, US | |
3075715 | 3075715 | 2022-02-09 | US | Michigan | Montcalm | 26117 | 14615 | 192 | 0 | 43.31082541 | -85.15252824 | 2022-02-10 04:21:14 | Montcalm, Michigan, US | |
2661097 | 2661097 | 2022-01-31 | US | Virginia | Bedford | 51019 | 14615 | 184 | 0 | 37.3080028 | -79.5281964 | 2022-02-01 04:21:11 | Bedford, Virginia, US | |
1142032 | 1142032 | 2022-01-23 | US | Indiana | Morgan | 18109 | 14615 | 232 | 0 | 39.47899078 | -86.44573375 | 2022-01-24 04:21:12 | Morgan, Indiana, US | |
2833950 | 2833950 | 2022-01-22 | US | Indiana | Morgan | 18109 | 14615 | 232 | 0 | 39.47899078 | -86.44573375 | 2022-01-23 04:21:13 | Morgan, Indiana, US | |
3426068 | 3426068 | 2022-01-21 | US | Indiana | Morgan | 18109 | 14615 | 232 | 0 | 39.47899078 | -86.44573375 | 2022-01-22 04:21:13 | Morgan, Indiana, US | |
3615575 | 3615575 | 2022-01-12 | US | Ohio | Ross | 39141 | 14615 | 266 | 0 | 39.33705391 | -83.06000914 | 2022-01-13 08:00:09 | Ross, Ohio, US | |
497230 | 497230 | 2021-11-06 | US | Maryland | Charles | 24017 | 14615 | 261 | 0 | 38.51092331 | -76.98580666 | 2021-11-07 04:21:53 | Charles, Maryland, US | |
1956597 | 1956597 | 2021-08-05 | Mali | 14615 | 534 | 0 | 17.570692 | -3.996166000000001 | 2021-08-06 04:21:18 | Mali | ||||
2912376 | 2912376 | 2021-06-17 | US | Iowa | Johnson | 19103 | 14615 | 85 | 0 | 41.67169354 | -91.58754744 | 2021-06-18 04:22:16 | Johnson, Iowa, US | |
3472956 | 3472956 | 2021-06-08 | US | Connecticut | Litchfield | 9005 | 14615 | 298 | 0 | 41.7937534 | -73.2451475 | 2021-06-09 04:23:31 | Litchfield, Connecticut, US | |
3154691 | 3154691 | 2021-01-27 | US | Indiana | Hendricks | 18063 | 14615 | 268 | 0 | 14347 | 39.76719009 | -86.51037283 | 2021-01-28 05:22:24 | Hendricks, Indiana, US |
2223288 | 2223288 | 2020-12-26 | Canada | Saskatchewan | 14615 | 134 | 10775 | 3346 | 52.9399 | -106.4509 | 2020-12-27 05:22:55 | Saskatchewan, Canada | ||
2121819 | 2121819 | 2020-12-20 | US | Nebraska | Sarpy | 31153 | 14615 | 67 | 0 | 14548 | 41.11314181 | -96.11156432 | 2020-12-21 05:27:58 | Sarpy, Nebraska, US |
1034996 | 1034996 | 2020-12-15 | US | Colorado | Larimer | 8069 | 14615 | 158 | 0 | 13175 | 40.66671597 | -105.4625784 | 2020-12-16 05:28:04 | Larimer, Colorado, US |
195032 | 195032 | 2020-08-31 | US | Illinois | DuPage | 17043 | 14615 | 533 | 0 | 14082 | 41.85116968 | -88.08642662 | 2020-09-01 04:28:31 | DuPage, Illinois, 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]);