johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46 rows where confirmed = 14714 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2952927 | 2952927 | 2022-12-20 | US | Louisiana | St. Martin | 22099 | 14714 | 197 | 0 | 30.13112107 | -91.61403569 | 2022-12-21 04:21:03 | St. Martin, Louisiana, US | |
3175329 | 3175329 | 2022-12-19 | US | Louisiana | St. Martin | 22099 | 14714 | 197 | 0 | 30.13112107 | -91.61403569 | 2022-12-20 04:21:04 | St. Martin, Louisiana, US | |
1629846 | 1629846 | 2022-12-18 | US | Louisiana | St. Martin | 22099 | 14714 | 197 | 0 | 30.13112107 | -91.61403569 | 2022-12-19 04:21:03 | St. Martin, Louisiana, US | |
505225 | 505225 | 2022-12-17 | US | Louisiana | St. Martin | 22099 | 14714 | 197 | 0 | 30.13112107 | -91.61403569 | 2022-12-18 04:21:03 | St. Martin, Louisiana, US | |
3325797 | 3325797 | 2022-12-16 | US | Louisiana | St. Martin | 22099 | 14714 | 197 | 0 | 30.13112107 | -91.61403569 | 2022-12-17 04:21:04 | St. Martin, Louisiana, US | |
544309 | 544309 | 2022-12-15 | US | Louisiana | St. Martin | 22099 | 14714 | 197 | 0 | 30.13112107 | -91.61403569 | 2022-12-16 04:21:01 | St. Martin, Louisiana, US | |
349837 | 349837 | 2022-12-14 | US | Louisiana | St. Martin | 22099 | 14714 | 197 | 0 | 30.13112107 | -91.61403569 | 2022-12-15 04:20:58 | St. Martin, Louisiana, US | |
3769423 | 3769423 | 2022-09-11 | US | Wisconsin | Dunn | 55033 | 14714 | 77 | 0 | 44.94562799 | -91.8962481 | 2022-09-12 04:20:58 | Dunn, Wisconsin, US | |
3827998 | 3827998 | 2022-09-10 | US | Wisconsin | Dunn | 55033 | 14714 | 77 | 0 | 44.94562799 | -91.8962481 | 2022-09-11 04:20:50 | Dunn, Wisconsin, US | |
966455 | 966455 | 2022-09-09 | US | Wisconsin | Dunn | 55033 | 14714 | 77 | 0 | 44.94562799 | -91.8962481 | 2022-09-10 04:21:10 | Dunn, Wisconsin, US | |
256857 | 256857 | 2022-09-08 | US | Wisconsin | Dunn | 55033 | 14714 | 77 | 0 | 44.94562799 | -91.8962481 | 2022-09-09 04:21:11 | Dunn, Wisconsin, US | |
2715913 | 2715913 | 2022-09-03 | US | Tennessee | Franklin | 47051 | 14714 | 196 | 0 | 35.15634626 | -86.09201039 | 2022-09-04 04:21:22 | Franklin, Tennessee, US | |
1101715 | 1101715 | 2022-08-03 | US | Wisconsin | Waupaca | 55135 | 14714 | 256 | 0 | 44.47068056 | -88.96534501 | 2022-08-04 04:20:58 | Waupaca, Wisconsin, US | |
3213068 | 3213068 | 2022-07-18 | US | Puerto Rico | Trujillo Alto | 72139 | 14714 | 0 | 0 | 18.336159 | -65.998884 | 2022-07-19 04:20:58 | Trujillo Alto, Puerto Rico, US | |
2241726 | 2241726 | 2022-06-28 | US | North Carolina | Halifax | 37083 | 14714 | 188 | 0 | 36.25669272 | -77.6556109 | 2022-06-29 04:20:59 | Halifax, North Carolina, US | |
2149968 | 2149968 | 2022-06-27 | US | North Carolina | Halifax | 37083 | 14714 | 188 | 0 | 36.25669272 | -77.6556109 | 2022-06-28 04:20:58 | Halifax, North Carolina, US | |
477769 | 477769 | 2022-06-26 | US | North Carolina | Halifax | 37083 | 14714 | 188 | 0 | 36.25669272 | -77.6556109 | 2022-06-27 04:21:00 | Halifax, North Carolina, US | |
941144 | 941144 | 2022-06-25 | US | North Carolina | Halifax | 37083 | 14714 | 188 | 0 | 36.25669272 | -77.6556109 | 2022-06-26 04:21:02 | Halifax, North Carolina, US | |
3348964 | 3348964 | 2022-06-24 | US | North Carolina | Halifax | 37083 | 14714 | 188 | 0 | 36.25669272 | -77.6556109 | 2022-06-25 04:20:57 | Halifax, North Carolina, US | |
1650705 | 1650705 | 2022-06-23 | US | North Carolina | Halifax | 37083 | 14714 | 188 | 0 | 36.25669272 | -77.6556109 | 2022-06-24 04:20:58 | Halifax, North Carolina, US | |
2189940 | 2189940 | 2022-06-22 | US | North Carolina | Halifax | 37083 | 14714 | 188 | 0 | 36.25669272 | -77.6556109 | 2022-06-23 04:20:55 | Halifax, North Carolina, US | |
3725177 | 3725177 | 2022-04-25 | US | Tennessee | Monroe | 47123 | 14714 | 244 | 0 | 35.44550387 | -84.24902965 | 2022-04-26 04:20:51 | Monroe, Tennessee, US | |
2031745 | 2031745 | 2022-04-24 | US | Tennessee | Monroe | 47123 | 14714 | 244 | 0 | 35.44550387 | -84.24902965 | 2022-04-25 04:20:56 | Monroe, Tennessee, US | |
749320 | 749320 | 2022-04-23 | US | Tennessee | Monroe | 47123 | 14714 | 244 | 0 | 35.44550387 | -84.24902965 | 2022-04-24 04:20:56 | Monroe, Tennessee, US | |
3439805 | 3439805 | 2022-04-22 | US | Tennessee | Monroe | 47123 | 14714 | 244 | 0 | 35.44550387 | -84.24902965 | 2022-04-23 04:20:50 | Monroe, Tennessee, US | |
2895390 | 2895390 | 2022-04-21 | US | Tennessee | Monroe | 47123 | 14714 | 244 | 0 | 35.44550387 | -84.24902965 | 2022-04-22 04:20:45 | Monroe, Tennessee, US | |
187459 | 187459 | 2022-02-13 | US | Kentucky | Christian | 21047 | 14714 | 191 | 0 | 36.89267803 | -87.49055367 | 2022-02-14 04:20:51 | Christian, Kentucky, US | |
317305 | 317305 | 2022-02-12 | US | Kentucky | Christian | 21047 | 14714 | 191 | 0 | 36.89267803 | -87.49055367 | 2022-02-13 04:21:00 | Christian, Kentucky, US | |
234631 | 234631 | 2022-02-11 | US | Kentucky | Christian | 21047 | 14714 | 191 | 0 | 36.89267803 | -87.49055367 | 2022-02-12 04:21:06 | Christian, Kentucky, US | |
1663369 | 1663369 | 2021-12-12 | US | Tennessee | Greene | 47059 | 14714 | 249 | 0 | 36.17470125 | -82.84691273 | 2021-12-13 04:22:02 | Greene, Tennessee, US | |
3073327 | 3073327 | 2021-11-23 | US | Virginia | Alexandria | 51510 | 14714 | 154 | 0 | 38.814003 | -77.08183073 | 2021-11-24 04:22:14 | Alexandria, Virginia, US | |
2518247 | 2518247 | 2021-08-18 | Mali | 14714 | 535 | 0 | 17.570692 | -3.996166000000001 | 2021-08-19 04:21:15 | Mali | ||||
3741743 | 3741743 | 2021-07-12 | US | Connecticut | Litchfield | 9005 | 14714 | 298 | 0 | 41.7937534 | -73.2451475 | 2021-07-13 04:21:18 | Litchfield, Connecticut, US | |
2339742 | 2339742 | 2021-06-15 | US | Alabama | Calhoun | 1015 | 14714 | 325 | 0 | 33.77483727 | -85.82630386 | 2021-06-16 04:22:32 | Calhoun, Alabama, US | |
2586170 | 2586170 | 2021-06-05 | Russia | Adygea Republic | 14714 | 207 | 14192 | 315 | 44.6939006 | 40.1520421 | 2021-06-06 04:24:03 | Adygea Republic, Russia | ||
606456 | 606456 | 2021-04-09 | US | Georgia | Clarke | 13059 | 14714 | 140 | 0 | 33.95436462 | -83.37124007 | 2021-04-10 04:20:59 | Clarke, Georgia, US | |
3664450 | 3664450 | 2021-03-09 | US | Georgia | Muscogee | 13215 | 14714 | 383 | 0 | 32.50931999 | -84.87142262 | 2021-03-10 05:24:35 | Muscogee, Georgia, US | |
1092415 | 1092415 | 2021-03-03 | US | North Carolina | Onslow | 37133 | 14714 | 133 | 0 | 14581 | 34.72607366 | -77.42908179 | 2021-03-04 05:24:24 | Onslow, North Carolina, US |
1859418 | 1859418 | 2021-02-25 | US | Kentucky | Kenton | 21117 | 14714 | 124 | 0 | 14590 | 38.93950319 | -84.53241199 | 2021-02-26 05:22:40 | Kenton, Kentucky, US |
3154498 | 3154498 | 2021-01-27 | US | Georgia | Whitfield | 13313 | 14714 | 169 | 0 | 14545 | 34.80987459 | -84.96093476 | 2021-01-28 05:22:24 | Whitfield, Georgia, US |
1761643 | 1761643 | 2021-01-24 | US | North Carolina | Pitt | 37147 | 14714 | 70 | 0 | 14644 | 35.59535426 | -77.37353178 | 2021-01-25 05:22:16 | Pitt, North Carolina, US |
3697278 | 3697278 | 2020-12-31 | US | Mississippi | DeSoto | 28033 | 14714 | 139 | 0 | 14575 | 34.87625235 | -89.99091418 | 2021-01-01 05:23:07 | DeSoto, Mississippi, US |
3839500 | 3839500 | 2020-11-21 | US | Texas | Brazoria | 48039 | 14714 | 194 | 0 | 13528 | 29.18757369 | -95.44563172 | 2020-11-22 05:25:45 | Brazoria, Texas, US |
3093690 | 3093690 | 2020-09-20 | Senegal | 14714 | 302 | 11260 | 3152 | 14.4974 | -14.4524 | 2020-09-21 04:23:00 | Senegal | |||
662351 | 662351 | 2020-08-11 | Korea, South | 14714 | 305 | 13786 | 623 | 35.90775700000001 | 127.766922 | 2020-08-12 04:27:29 | Korea, South | |||
1522784 | 1522784 | 2020-06-23 | Moldova | 14714 | 490 | 8212 | 6012 | 47.4116 | 28.3699 | 2020-06-24 04:33:28 | Moldova |
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]);