johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
58 rows where confirmed = 12245 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3176545 | 3176545 | 2022-12-19 | US | Puerto Rico | Juncos | 72077 | 12245 | 0 | 0 | 18.223793 | -65.909109 | 2022-12-20 04:21:04 | Juncos, Puerto Rico, US | |
852384 | 852384 | 2022-11-02 | US | Puerto Rico | San Sebastian | 72131 | 12245 | 0 | 0 | 18.328646 | -66.971214 | 2022-11-03 04:22:05 | San Sebastian, Puerto Rico, US | |
1890862 | 1890862 | 2022-09-14 | US | Minnesota | Douglas | 27041 | 12245 | 122 | 0 | 45.93348491 | -95.45335469 | 2022-09-15 04:21:02 | Douglas, Minnesota, US | |
373917 | 373917 | 2022-09-13 | US | Minnesota | Douglas | 27041 | 12245 | 122 | 0 | 45.93348491 | -95.45335469 | 2022-09-14 04:20:44 | Douglas, Minnesota, US | |
2396519 | 2396519 | 2022-09-12 | US | Minnesota | Douglas | 27041 | 12245 | 122 | 0 | 45.93348491 | -95.45335469 | 2022-09-13 04:20:57 | Douglas, Minnesota, US | |
3767597 | 3767597 | 2022-09-11 | US | Minnesota | Douglas | 27041 | 12245 | 122 | 0 | 45.93348491 | -95.45335469 | 2022-09-12 04:20:58 | Douglas, Minnesota, US | |
3826172 | 3826172 | 2022-09-10 | US | Minnesota | Douglas | 27041 | 12245 | 122 | 0 | 45.93348491 | -95.45335469 | 2022-09-11 04:20:50 | Douglas, Minnesota, US | |
964629 | 964629 | 2022-09-09 | US | Minnesota | Douglas | 27041 | 12245 | 122 | 0 | 45.93348491 | -95.45335469 | 2022-09-10 04:21:10 | Douglas, Minnesota, US | |
255031 | 255031 | 2022-09-08 | US | Minnesota | Douglas | 27041 | 12245 | 122 | 0 | 45.93348491 | -95.45335469 | 2022-09-09 04:21:11 | Douglas, Minnesota, US | |
3508501 | 3508501 | 2022-06-05 | US | Indiana | Lawrence | 18093 | 12245 | 263 | 0 | 38.84112637 | -86.48361629 | 2022-06-06 04:20:57 | Lawrence, Indiana, US | |
3528578 | 3528578 | 2022-06-04 | US | Indiana | Lawrence | 18093 | 12245 | 263 | 0 | 38.84112637 | -86.48361629 | 2022-06-05 04:20:55 | Lawrence, Indiana, US | |
3134664 | 3134664 | 2022-06-03 | US | Indiana | Lawrence | 18093 | 12245 | 263 | 0 | 38.84112637 | -86.48361629 | 2022-06-04 04:20:58 | Lawrence, Indiana, US | |
3594727 | 3594727 | 2022-05-23 | US | Minnesota | Beltrami | 27007 | 12245 | 128 | 0 | 47.97373527 | -94.93732139 | 2022-05-24 04:20:57 | Beltrami, Minnesota, US | |
3267014 | 3267014 | 2022-05-04 | US | Louisiana | Lincoln | 22061 | 12245 | 144 | 0 | 32.6003154 | -92.6659741 | 2022-05-05 04:20:55 | Lincoln, Louisiana, US | |
1573653 | 1573653 | 2022-05-03 | US | Louisiana | Lincoln | 22061 | 12245 | 144 | 0 | 32.6003154 | -92.6659741 | 2022-05-04 04:20:59 | Lincoln, Louisiana, US | |
464385 | 464385 | 2022-05-02 | US | Illinois | Franklin | 17055 | 12245 | 165 | 0 | 37.99189086 | -88.92567818 | 2022-05-03 04:21:00 | Franklin, Illinois, US | |
3870730 | 3870730 | 2022-04-05 | US | Texas | Nacogdoches | 48347 | 12245 | 256 | 0 | 31.62017125 | -94.61803994 | 2022-04-06 04:20:49 | Nacogdoches, Texas, US | |
2752072 | 2752072 | 2022-04-04 | US | Texas | Nacogdoches | 48347 | 12245 | 256 | 0 | 31.62017125 | -94.61803994 | 2022-04-05 04:20:48 | Nacogdoches, Texas, US | |
3733418 | 3733418 | 2022-04-03 | US | Texas | Nacogdoches | 48347 | 12245 | 256 | 0 | 31.62017125 | -94.61803994 | 2022-04-04 04:20:51 | Nacogdoches, Texas, US | |
502853 | 502853 | 2022-04-02 | US | Texas | Nacogdoches | 48347 | 12245 | 256 | 0 | 31.62017125 | -94.61803994 | 2022-04-03 04:20:48 | Nacogdoches, Texas, US | |
3241902 | 3241902 | 2022-03-21 | US | Wisconsin | Polk | 55095 | 12245 | 120 | 0 | 45.46130348 | -92.44182875 | 2022-03-22 04:20:54 | Polk, Wisconsin, US | |
3822578 | 3822578 | 2022-02-16 | US | Nevada | Elko | 32007 | 12245 | 131 | 0 | 41.14531606 | -115.3577619 | 2022-02-17 04:20:56 | Elko, Nevada, US | |
2015982 | 2015982 | 2022-02-06 | US | Utah | TriCounty | 12245 | 85 | 0 | 40.12491499 | -109.5174415 | 2022-02-07 04:21:05 | TriCounty, Utah, US | ||
1297311 | 1297311 | 2022-02-05 | US | Utah | TriCounty | 12245 | 85 | 0 | 40.12491499 | -109.5174415 | 2022-02-06 04:21:00 | TriCounty, Utah, US | ||
2330639 | 2330639 | 2022-02-04 | US | Utah | TriCounty | 12245 | 85 | 0 | 40.12491499 | -109.5174415 | 2022-02-05 04:21:05 | TriCounty, Utah, US | ||
1473504 | 1473504 | 2022-01-17 | US | Kentucky | Christian | 21047 | 12245 | 179 | 0 | 36.89267803 | -87.49055367 | 2022-01-18 04:21:04 | Christian, Kentucky, US | |
556178 | 556178 | 2022-01-16 | US | Kentucky | Christian | 21047 | 12245 | 179 | 0 | 36.89267803 | -87.49055367 | 2022-01-17 04:21:08 | Christian, Kentucky, US | |
3841899 | 3841899 | 2022-01-15 | US | Kentucky | Christian | 21047 | 12245 | 179 | 0 | 36.89267803 | -87.49055367 | 2022-01-16 04:21:12 | Christian, Kentucky, US | |
100714 | 100714 | 2022-01-14 | US | Kentucky | Christian | 21047 | 12245 | 179 | 0 | 36.89267803 | -87.49055367 | 2022-01-15 04:21:07 | Christian, Kentucky, US | |
3690125 | 3690125 | 2022-01-13 | US | Oregon | Yamhill | 41071 | 12245 | 168 | 0 | 45.23330449 | -123.3086963 | 2022-01-14 04:21:54 | Yamhill, Oregon, US | |
2964300 | 2964300 | 2021-12-24 | US | Hawaii | Hawaii | 15001 | 12245 | 151 | 0 | 19.60121157 | -155.5210167 | 2021-12-25 04:21:37 | Hawaii, Hawaii, US | |
3499018 | 3499018 | 2021-12-15 | US | South Carolina | Laurens | 45059 | 12245 | 240 | 0 | 34.48244419 | -82.00490796 | 2021-12-16 04:22:11 | Laurens, South Carolina, US | |
1078334 | 1078334 | 2021-12-09 | US | Alabama | Walker | 1127 | 12245 | 380 | 0 | 33.80270512 | -87.30027177 | 2021-12-10 04:22:28 | Walker, Alabama, US | |
2290859 | 2290859 | 2021-11-15 | US | Virginia | Roanoke | 51161 | 12245 | 180 | 0 | 37.26865804 | -80.06396753 | 2021-11-16 04:21:10 | Roanoke, Virginia, US | |
684709 | 684709 | 2021-10-24 | US | North Carolina | Surry | 37171 | 12245 | 226 | 0 | 36.41689489 | -80.69102283 | 2021-10-25 04:22:31 | Surry, North Carolina, US | |
772717 | 772717 | 2021-10-23 | US | North Carolina | Surry | 37171 | 12245 | 226 | 0 | 36.41689489 | -80.69102283 | 2021-10-24 04:21:22 | Surry, North Carolina, US | |
656364 | 656364 | 2021-10-22 | US | North Carolina | Surry | 37171 | 12245 | 226 | 0 | 36.41689489 | -80.69102283 | 2021-10-23 04:21:32 | Surry, North Carolina, US | |
446177 | 446177 | 2021-10-20 | US | South Carolina | Greenwood | 45047 | 12245 | 216 | 0 | 34.15272415 | -82.12715789 | 2021-10-21 04:21:18 | Greenwood, South Carolina, US | |
2959869 | 2959869 | 2021-10-08 | US | Arkansas | Jefferson | 5069 | 12245 | 225 | 0 | 34.26767081 | -91.92619839 | 2021-10-09 04:21:34 | Jefferson, Arkansas, US | |
3759852 | 3759852 | 2021-09-21 | US | North Carolina | Wilson | 37195 | 12245 | 202 | 0 | 35.70625477 | -77.917978 | 2021-09-22 04:21:45 | Wilson, North Carolina, US | |
1486061 | 1486061 | 2021-08-13 | US | Ohio | Richland | 39139 | 12245 | 218 | 0 | 40.77180308 | -82.53799609999999 | 2021-08-14 04:21:25 | Richland, Ohio, US | |
1341986 | 1341986 | 2021-08-11 | Australia | New South Wales | 12245 | 91 | 0 | -33.8688 | 151.2093 | 2021-08-12 04:21:25 | New South Wales, Australia | |||
2107122 | 2107122 | 2021-06-01 | US | Tennessee | Unassigned | 90047 | 12245 | 133 | 0 | 36.55606529 | 0.0 | 2021-06-02 04:24:34 | Unassigned, Tennessee, US | |
1085171 | 1085171 | 2021-05-14 | US | Texas | Wichita | 48485 | 12245 | 377 | 0 | 33.98842886 | -98.7041034 | 2021-05-15 04:20:58 | Wichita, Texas, US | |
3057437 | 3057437 | 2021-05-13 | US | Texas | Wichita | 48485 | 12245 | 377 | 0 | 33.98842886 | -98.7041034 | 2021-05-14 04:20:41 | Wichita, Texas, US | |
2007907 | 2007907 | 2021-05-12 | US | Texas | Wichita | 48485 | 12245 | 377 | 0 | 33.98842886 | -98.7041034 | 2021-05-13 04:20:51 | Wichita, Texas, US | |
3957738 | 3957738 | 2021-05-11 | US | Texas | Wichita | 48485 | 12245 | 377 | 0 | 33.98842886 | -98.7041034 | 2021-05-12 04:21:29 | Wichita, Texas, US | |
2824017 | 2824017 | 2021-05-10 | US | Texas | Wichita | 48485 | 12245 | 376 | 0 | 33.98842886 | -98.7041034 | 2021-05-11 04:20:41 | Wichita, Texas, US | |
1428349 | 1428349 | 2021-05-09 | US | Texas | Wichita | 48485 | 12245 | 376 | 0 | 33.98842886 | -98.7041034 | 2021-05-10 04:20:38 | Wichita, Texas, US | |
1555217 | 1555217 | 2021-05-08 | US | Texas | Wichita | 48485 | 12245 | 376 | 0 | 33.98842886 | -98.7041034 | 2021-05-09 04:20:35 | Wichita, Texas, US | |
1881126 | 1881126 | 2021-03-26 | Pakistan | Azad Jammu and Kashmir | 12245 | 342 | 10631 | 1272 | 34.027401 | 73.947253 | 2021-03-27 05:25:04 | Azad Jammu and Kashmir, Pakistan | ||
2362996 | 2362996 | 2021-03-08 | US | Wisconsin | Dodge | 55027 | 12245 | 179 | 0 | 43.41576662 | -88.70928178 | 2021-03-09 05:28:19 | Dodge, Wisconsin, US | |
57060 | 57060 | 2021-03-07 | US | New York | Saratoga | 36091 | 12245 | 149 | 0 | 43.10904162 | -73.86653895 | 2021-03-08 05:24:48 | Saratoga, New York, US | |
3542368 | 3542368 | 2021-02-12 | US | Tennessee | Bradley | 47011 | 12245 | 131 | 0 | 12115 | 35.15739424 | -84.857186 | 2021-02-13 05:22:12 | Bradley, Tennessee, US |
14680 | 14680 | 2021-01-26 | US | North Carolina | Onslow | 37133 | 12245 | 103 | 0 | 12142 | 34.72607366 | -77.42908179 | 2021-01-27 05:23:41 | Onslow, North Carolina, US |
2623740 | 2623740 | 2020-06-25 | US | Connecticut | New Haven | 9009 | 12245 | 1068 | 0 | 11177 | 41.4080325 | -72.93620426 | 2020-06-26 04:33:43 | New Haven, Connecticut, US |
1281469 | 1281469 | 2020-06-04 | Bolivia | 12245 | 415 | 1658 | 10172 | -16.2902 | -63.5887 | 2020-06-05 02:33:06 | Bolivia | |||
3082566 | 3082566 | 2020-05-04 | US | Connecticut | Fairfield | 9001 | 12245 | 910 | 0 | 11335 | 41.26809896 | -73.3881171 | 2020-05-05 02:32:34 | Fairfield, Connecticut, 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]);