johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where confirmed = 12390 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
856369 | 856369 | 2022-09-30 | US | Puerto Rico | Isabela | 72071 | 12390 | 0 | 0 | 18.44981 | -67.005093 | 2022-10-01 04:23:01 | Isabela, Puerto Rico, US | |
3998069 | 3998069 | 2022-09-27 | US | Virginia | York | 51199 | 12390 | 117 | 0 | 37.24374789 | -76.54412815 | 2022-09-28 04:23:01 | York, Virginia, US | |
2312865 | 2312865 | 2022-06-17 | US | Maine | Oxford | 23017 | 12390 | 150 | 0 | 44.49952995 | -70.75682123 | 2022-06-18 04:21:10 | Oxford, Maine, US | |
3891162 | 3891162 | 2022-06-06 | US | Wisconsin | Douglas | 55031 | 12390 | 79 | 0 | 46.43222285 | -91.91595768 | 2022-06-07 04:21:08 | Douglas, Wisconsin, US | |
2447139 | 2447139 | 2022-02-22 | US | Alabama | Dale | 1045 | 12390 | 215 | 0 | 31.43037123 | -85.61095742 | 2022-02-23 04:21:09 | Dale, Alabama, US | |
74203 | 74203 | 2022-02-07 | US | Texas | Harrison | 48203 | 12390 | 206 | 0 | 32.54935988 | -94.36934071 | 2022-02-08 04:21:15 | Harrison, Texas, US | |
1695247 | 1695247 | 2022-01-10 | US | Tennessee | Coffee | 47031 | 12390 | 211 | 0 | 35.49090731 | -86.07311784 | 2022-01-11 04:22:01 | Coffee, Tennessee, US | |
3999545 | 3999545 | 2021-12-30 | US | Georgia | Walker | 13295 | 12390 | 176 | 0 | 34.73376362 | -85.30165174 | 2021-12-31 04:21:50 | Walker, Georgia, US | |
2402041 | 2402041 | 2021-12-17 | US | Texas | Starr | 48427 | 12390 | 336 | 0 | 26.56150059 | -98.73892358 | 2021-12-18 02:22:20 | Starr, Texas, US | |
3499558 | 3499558 | 2021-12-15 | US | Virginia | Lynchburg | 51680 | 12390 | 205 | 0 | 37.40021399 | -79.19888138 | 2021-12-16 04:22:11 | Lynchburg, Virginia, US | |
1079746 | 1079746 | 2021-12-09 | US | Mississippi | Lauderdale | 28075 | 12390 | 323 | 0 | 32.40419769 | -88.66229662 | 2021-12-10 04:22:28 | Lauderdale, Mississippi, US | |
552483 | 552483 | 2021-12-08 | US | Minnesota | Clay | 27027 | 12390 | 110 | 0 | 46.89289518 | -96.48761922 | 2021-12-09 04:22:49 | Clay, Minnesota, US | |
3072299 | 3072299 | 2021-11-23 | US | New York | St. Lawrence | 36089 | 12390 | 142 | 0 | 44.4976179 | -75.06550039 | 2021-11-24 04:22:14 | St. Lawrence, New York, US | |
162252 | 162252 | 2021-11-19 | Russia | Magadan Oblast | 12390 | 300 | 0 | 62.48858785 | 153.9903764 | 2021-11-20 04:22:17 | Magadan Oblast, Russia | |||
451050 | 451050 | 2021-11-17 | United Kingdom | Jersey | 12390 | 80 | 0 | 0 | 49.2138 | -2.1358 | 2021-11-18 04:21:33 | Jersey, United Kingdom | ||
44688 | 44688 | 2021-11-02 | US | Illinois | DeKalb | 17037 | 12390 | 134 | 0 | 41.89373302 | -88.76958483 | 2021-11-03 06:22:09 | DeKalb, Illinois, US | |
491555 | 491555 | 2021-10-14 | Iceland | 12390 | 33 | 0 | 64.9631 | -19.0208 | 2021-10-15 04:21:26 | Iceland | ||||
3760499 | 3760499 | 2021-09-21 | US | Texas | Bowie | 48037 | 12390 | 272 | 0 | 33.44626922 | -94.41834132 | 2021-09-22 04:21:45 | Bowie, Texas, US | |
2465096 | 2465096 | 2021-09-14 | US | North Carolina | Craven | 37049 | 12390 | 137 | 0 | 35.11833364 | -77.08398081 | 2021-09-15 03:22:37 | Craven, North Carolina, US | |
106620 | 106620 | 2021-08-15 | US | Virginia | Alexandria | 51510 | 12390 | 141 | 0 | 38.814003 | -77.08183073 | 2021-08-16 04:21:31 | Alexandria, Virginia, US | |
510978 | 510978 | 2021-08-14 | US | Virginia | Alexandria | 51510 | 12390 | 141 | 0 | 38.814003 | -77.08183073 | 2021-08-15 04:21:41 | Alexandria, Virginia, US | |
1486850 | 1486850 | 2021-08-13 | US | Virginia | Alexandria | 51510 | 12390 | 141 | 0 | 38.814003 | -77.08183073 | 2021-08-14 04:21:25 | Alexandria, Virginia, US | |
3709121 | 3709121 | 2021-07-17 | US | Tennessee | Unassigned | 90047 | 12390 | 93 | 0 | 36.55606529 | 0.0 | 2021-07-18 04:22:07 | Unassigned, Tennessee, US | |
955524 | 955524 | 2021-04-25 | US | Connecticut | Middlesex | 9007 | 12390 | 359 | 0 | 41.45949668 | -72.53714864 | 2021-04-26 04:21:04 | Middlesex, Connecticut, US | |
3924671 | 3924671 | 2021-04-24 | US | Connecticut | Middlesex | 9007 | 12390 | 359 | 0 | 41.45949668 | -72.53714864 | 2021-04-25 04:20:32 | Middlesex, Connecticut, US | |
1409702 | 1409702 | 2021-04-23 | US | Connecticut | Middlesex | 9007 | 12390 | 359 | 0 | 41.45949668 | -72.53714864 | 2021-04-24 04:20:38 | Middlesex, Connecticut, US | |
355257 | 355257 | 2021-03-11 | US | Tennessee | Maury | 47119 | 12390 | 162 | 0 | 35.6187413 | -87.07462444 | 2021-03-12 05:26:50 | Maury, Tennessee, US | |
1936382 | 1936382 | 2021-02-23 | Haiti | 12390 | 248 | 9536 | 2526 | 18.9712 | -72.2852 | 2021-02-24 05:29:16 | Haiti | |||
2570017 | 2570017 | 2021-01-25 | US | North Carolina | Rowan | 37159 | 12390 | 236 | 0 | 12154 | 35.64003916 | -80.52446628 | 2021-01-26 05:22:02 | Rowan, North Carolina, US |
3311828 | 3311828 | 2021-01-13 | Ukraine | Luhansk Oblast | 12390 | 342 | 9005 | 3043 | 48.574 | 39.3078 | 2021-01-14 05:22:32 | Luhansk Oblast, Ukraine | ||
3441030 | 3441030 | 2020-11-11 | Russia | Kursk Oblast | 12390 | 130 | 9174 | 3086 | 51.6568453 | 36.4852695 | 2020-11-12 05:25:55 | Kursk Oblast, Russia | ||
2381788 | 2381788 | 2020-10-01 | US | New Jersey | Monmouth | 34025 | 12390 | 868 | 0 | 11522 | 40.26549699 | -74.22240686 | 2020-10-02 04:23:51 | Monmouth, New Jersey, US |
174986 | 174986 | 2020-07-27 | US | Connecticut | Hartford | 9003 | 12390 | 1410 | 0 | 10980 | 41.80283011 | -72.73103891 | 2020-07-28 04:58:43 | Hartford, 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]);