johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
60 rows where confirmed = 11269 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753448 | 2753448 | 2022-12-29 | US | California | Amador | 6005 | 11269 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-30 04:21:04 | Amador, California, US | |
1074454 | 1074454 | 2022-12-28 | US | California | Amador | 6005 | 11269 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-29 04:21:01 | Amador, California, US | |
328451 | 328451 | 2022-12-27 | US | California | Amador | 6005 | 11269 | 96 | 0 | 38.44583082 | -120.65696 | 2022-12-28 04:21:04 | Amador, California, US | |
3377887 | 3377887 | 2022-12-08 | US | Arkansas | Miller | 5091 | 11269 | 201 | 0 | 33.31403423 | -93.89285258 | 2022-12-09 04:21:05 | Miller, Arkansas, US | |
3715719 | 3715719 | 2022-12-06 | US | Louisiana | Vernon | 22115 | 11269 | 198 | 0 | 31.10884837 | -93.18153838 | 2022-12-07 04:20:58 | Vernon, Louisiana, US | |
2416424 | 2416424 | 2022-12-05 | US | Louisiana | Vernon | 22115 | 11269 | 198 | 0 | 31.10884837 | -93.18153838 | 2022-12-06 04:21:03 | Vernon, Louisiana, US | |
720032 | 720032 | 2022-12-04 | US | Louisiana | Vernon | 22115 | 11269 | 198 | 0 | 31.10884837 | -93.18153838 | 2022-12-05 04:20:58 | Vernon, Louisiana, US | |
2818321 | 2818321 | 2022-12-03 | US | Louisiana | Vernon | 22115 | 11269 | 198 | 0 | 31.10884837 | -93.18153838 | 2022-12-04 04:20:56 | Vernon, Louisiana, US | |
835177 | 835177 | 2022-12-02 | US | Louisiana | Vernon | 22115 | 11269 | 198 | 0 | 31.10884837 | -93.18153838 | 2022-12-03 04:21:02 | Vernon, Louisiana, US | |
2137707 | 2137707 | 2022-12-01 | US | Louisiana | Vernon | 22115 | 11269 | 198 | 0 | 31.10884837 | -93.18153838 | 2022-12-02 04:21:07 | Vernon, Louisiana, US | |
1966123 | 1966123 | 2022-11-30 | US | Louisiana | Vernon | 22115 | 11269 | 198 | 0 | 31.10884837 | -93.18153838 | 2022-12-01 04:21:03 | Vernon, Louisiana, US | |
3029543 | 3029543 | 2022-11-17 | US | Texas | Waller | 48473 | 11269 | 109 | 0 | 30.01058447 | -95.99011759 | 2022-11-18 04:21:15 | Waller, Texas, US | |
2489254 | 2489254 | 2022-11-16 | US | Texas | Waller | 48473 | 11269 | 109 | 0 | 30.01058447 | -95.99011759 | 2022-11-17 04:21:11 | Waller, Texas, US | |
1626448 | 1626448 | 2022-09-22 | US | New Hampshire | Carroll | 33003 | 11269 | 67 | 0 | 43.87498583 | -71.20430216 | 2022-09-23 04:23:13 | Carroll, New Hampshire, US | |
1890175 | 1890175 | 2022-09-14 | US | Illinois | Morgan | 17137 | 11269 | 132 | 0 | 39.71654544 | -90.20255104 | 2022-09-15 04:21:02 | Morgan, Illinois, US | |
2189873 | 2189873 | 2022-06-22 | US | New York | Otsego | 36077 | 11269 | 93 | 0 | 42.63492579 | -75.03151402 | 2022-06-23 04:20:55 | Otsego, New York, US | |
2187969 | 2187969 | 2022-06-22 | US | Alabama | Chilton | 1021 | 11269 | 208 | 0 | 32.85044126 | -86.7173256 | 2022-06-23 04:20:55 | Chilton, Alabama, US | |
1111990 | 1111990 | 2022-05-21 | US | North Dakota | Morton | 38059 | 11269 | 142 | 0 | 46.71681782 | -101.2822377 | 2022-05-22 04:20:52 | Morton, North Dakota, US | |
1506929 | 1506929 | 2022-05-16 | US | Virginia | Danville | 51590 | 11269 | 282 | 0 | 36.58022376 | -79.40395668 | 2022-05-17 04:20:59 | Danville, Virginia, US | |
2087398 | 2087398 | 2022-05-15 | US | Washington | Douglas | 53017 | 11269 | 70 | 0 | 47.7361335 | -119.692937 | 2022-05-16 04:20:47 | Douglas, Washington, US | |
3358108 | 3358108 | 2022-05-14 | US | Washington | Douglas | 53017 | 11269 | 70 | 0 | 47.7361335 | -119.692937 | 2022-05-15 04:20:53 | Douglas, Washington, US | |
661753 | 661753 | 2022-05-13 | US | Washington | Douglas | 53017 | 11269 | 70 | 0 | 47.7361335 | -119.692937 | 2022-05-14 04:20:48 | Douglas, Washington, US | |
3439536 | 3439536 | 2022-04-22 | US | Pennsylvania | Venango | 42121 | 11269 | 238 | 0 | 41.40323442 | -79.75845449 | 2022-04-23 04:20:50 | Venango, Pennsylvania, US | |
3733668 | 3733668 | 2022-04-03 | US | Washington | Clallam | 53009 | 11269 | 138 | 0 | 48.04754642 | -123.92263190000001 | 2022-04-04 04:20:51 | Clallam, Washington, US | |
503103 | 503103 | 2022-04-02 | US | Washington | Clallam | 53009 | 11269 | 138 | 0 | 48.04754642 | -123.92263190000001 | 2022-04-03 04:20:48 | Clallam, Washington, US | |
3354088 | 3354088 | 2022-04-01 | US | Washington | Clallam | 53009 | 11269 | 138 | 0 | 48.04754642 | -123.92263190000001 | 2022-04-02 04:20:47 | Clallam, Washington, US | |
2735953 | 2735953 | 2022-02-27 | US | Tennessee | Cocke | 47029 | 11269 | 201 | 0 | 35.9278914 | -83.11828725 | 2022-02-28 04:21:05 | Cocke, Tennessee, US | |
3675221 | 3675221 | 2022-02-15 | US | Wisconsin | Oconto | 55083 | 11269 | 103 | 0 | 45.02715345 | -88.26807503 | 2022-02-16 04:21:10 | Oconto, Wisconsin, US | |
981228 | 981228 | 2022-02-01 | US | New York | Washington | 36115 | 11269 | 106 | 0 | 43.31153794 | -73.43043448 | 2022-02-02 04:21:09 | Washington, New York, US | |
2054120 | 2054120 | 2022-01-25 | US | New York | Fulton | 36035 | 11269 | 148 | 0 | 43.11363907 | -74.41798804 | 2022-01-26 04:21:07 | Fulton, New York, US | |
3830953 | 3830953 | 2021-12-21 | US | Ohio | Lawrence | 39087 | 11269 | 196 | 0 | 38.59743452 | -82.53466552 | 2021-12-22 04:21:54 | Lawrence, Ohio, US | |
717397 | 717397 | 2021-11-12 | US | Tennessee | Cumberland | 47035 | 11269 | 225 | 0 | 35.95271721 | -84.99840585 | 2021-11-13 04:21:38 | Cumberland, Tennessee, US | |
1912485 | 1912485 | 2021-10-17 | US | Utah | Tooele | 49045 | 11269 | 63 | 0 | 40.44862644 | -113.12957150000001 | 2021-10-18 04:21:10 | Tooele, Utah, US | |
938074 | 938074 | 2021-10-16 | US | Utah | Tooele | 49045 | 11269 | 63 | 0 | 40.44862644 | -113.12957150000001 | 2021-10-17 04:21:29 | Tooele, Utah, US | |
2946629 | 2946629 | 2021-10-15 | US | Utah | Tooele | 49045 | 11269 | 63 | 0 | 40.44862644 | -113.12957150000001 | 2021-10-16 04:21:15 | Tooele, Utah, US | |
1377881 | 1377881 | 2021-09-15 | US | Virginia | Portsmouth | 51740 | 11269 | 214 | 0 | 36.85914825 | -76.35971629 | 2021-09-16 04:22:19 | Portsmouth, Virginia, US | |
2901567 | 2901567 | 2021-08-12 | US | Missouri | Cass | 29037 | 11269 | 124 | 0 | 38.64789422 | -94.353399 | 2021-08-13 04:21:24 | Cass, Missouri, US | |
580369 | 580369 | 2021-07-13 | US | Louisiana | Terrebonne | 22109 | 11269 | 228 | 0 | 29.37343766 | -90.82626855 | 2021-07-14 04:21:35 | Terrebonne, Louisiana, US | |
2339406 | 2339406 | 2021-06-15 | Japan | Hiroshima | 11269 | 160 | 10621 | 488 | 34.605309000000005 | 132.788719 | 2021-06-16 04:22:32 | Hiroshima, Japan | ||
826758 | 826758 | 2021-06-06 | US | Iowa | Dallas | 19049 | 11269 | 99 | 0 | 41.68560356 | -94.04127625 | 2021-06-07 04:22:51 | Dallas, Iowa, US | |
3129959 | 3129959 | 2021-04-18 | US | Arizona | Apache | 4001 | 11269 | 422 | 0 | 35.39465006 | -109.4892383 | 2021-04-19 04:20:57 | Apache, Arizona, US | |
3254532 | 3254532 | 2021-03-02 | US | Alabama | Marshall | 1095 | 11269 | 209 | 0 | 11060 | 34.36975964 | -86.30486727 | 2021-03-03 05:23:28 | Marshall, Alabama, US |
1529036 | 1529036 | 2021-02-09 | US | Indiana | Vigo | 18167 | 11269 | 220 | 0 | 11049 | 39.42944561 | -87.39169027 | 2021-02-10 05:22:41 | Vigo, Indiana, US |
793862 | 793862 | 2021-02-04 | US | West Virginia | Kanawha | 54039 | 11269 | 267 | 0 | 11002 | 38.33860077 | -81.52857054 | 2021-02-05 05:22:38 | Kanawha, West Virginia, US |
1461266 | 1461266 | 2021-01-31 | US | Louisiana | Livingston | 22063 | 11269 | 160 | 0 | 11109 | 30.44143993 | -90.73061664 | 2021-02-01 05:22:53 | Livingston, Louisiana, US |
1899802 | 1899802 | 2021-01-29 | US | Pennsylvania | Centre | 42027 | 11269 | 193 | 0 | 11076 | 40.92058903 | -77.82200624 | 2021-01-30 05:22:49 | Centre, Pennsylvania, US |
2570957 | 2570957 | 2021-01-25 | US | Virginia | Arlington | 51013 | 11269 | 197 | 0 | 11072 | 38.8767675 | -77.10139853 | 2021-01-26 05:22:02 | Arlington, Virginia, US |
435670 | 435670 | 2021-01-21 | Sweden | Kronoberg | 11269 | 260 | 0 | 11009 | 56.7183 | 14.4115 | 2021-01-22 05:22:10 | Kronoberg, Sweden | ||
2865022 | 2865022 | 2021-01-06 | Sweden | Dalarna | 11269 | 247 | 0 | 11022 | 61.0917 | 14.6664 | 2021-01-07 05:22:03 | Dalarna, Sweden | ||
3034609 | 3034609 | 2021-01-05 | Sweden | Dalarna | 11269 | 247 | 0 | 11022 | 61.0917 | 14.6664 | 2021-01-06 05:22:16 | Dalarna, Sweden | ||
1037602 | 1037602 | 2020-12-15 | US | Texas | Unassigned | 90048 | 11269 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-12-16 05:28:04 | Unassigned, Texas, US |
3836440 | 3836440 | 2020-11-21 | India | Meghalaya | 11269 | 108 | 10236 | 925 | 25.536934 | 91.278882 | 2020-11-22 05:25:45 | Meghalaya, India | ||
2245336 | 2245336 | 2020-10-30 | US | Missouri | St. Charles | 29183 | 11269 | 147 | 0 | 11122 | 38.77875681 | -90.66662425 | 2020-10-31 04:24:44 | St. Charles, Missouri, US |
2856841 | 2856841 | 2020-10-16 | Italy | Sicilia | 11269 | 360 | 4975 | 5934 | 38.11569725 | 13.362356699999998 | 2020-10-17 04:24:12 | Sicilia, Italy | ||
970541 | 970541 | 2020-09-29 | United Kingdom | Northern Ireland | 11269 | 903 | 0 | 10691 | 54.7877 | -6.4923 | 2020-09-30 04:23:33 | Northern Ireland, United Kingdom | ||
427518 | 427518 | 2020-09-07 | Russia | Arkhangelsk Oblast | 11269 | 255 | 9222 | 1792 | 63.5589686 | 43.1221646 | 2020-09-08 04:28:25 | Arkhangelsk Oblast, Russia | ||
1998147 | 1998147 | 2020-08-26 | US | Louisiana | Orleans | 22071 | 11269 | 573 | 0 | 10696 | 30.06971951 | -89.92660315 | 2020-08-27 04:28:15 | Orleans, Louisiana, US |
3180240 | 3180240 | 2020-08-18 | US | New York | Orange | 36071 | 11269 | 491 | 0 | 10778 | 41.40337468 | -74.30240757 | 2020-08-19 04:27:00 | Orange, New York, US |
838209 | 838209 | 2020-08-17 | US | Colorado | Denver | 8031 | 11269 | 410 | 0 | 10187 | 39.76018276 | -104.8725695 | 2020-08-18 04:27:56 | Denver, Colorado, US |
2233749 | 2233749 | 2020-07-03 | US | Tennessee | Shelby | 47157 | 11269 | 197 | 0 | 10948 | 35.1864775 | -89.89692423 | 2020-07-04 04:33:51 | Shelby, Tennessee, 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]);