johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
54 rows where confirmed = 14212 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1076659 | 1076659 | 2022-12-28 | US | Puerto Rico | Gurabo | 72063 | 14212 | 0 | 0 | 18.266461 | -65.979705 | 2022-12-29 04:21:01 | Gurabo, Puerto Rico, US | |
693306 | 693306 | 2022-12-23 | US | Tennessee | Cocke | 47029 | 14212 | 239 | 0 | 35.9278914 | -83.11828725 | 2022-12-24 04:21:02 | Cocke, Tennessee, US | |
2953774 | 2953774 | 2022-12-20 | US | North Carolina | Yadkin | 37197 | 14212 | 138 | 0 | 36.16222629 | -80.66239436 | 2022-12-21 04:21:03 | Yadkin, North Carolina, US | |
3176176 | 3176176 | 2022-12-19 | US | North Carolina | Yadkin | 37197 | 14212 | 138 | 0 | 36.16222629 | -80.66239436 | 2022-12-20 04:21:04 | Yadkin, North Carolina, US | |
1630693 | 1630693 | 2022-12-18 | US | North Carolina | Yadkin | 37197 | 14212 | 138 | 0 | 36.16222629 | -80.66239436 | 2022-12-19 04:21:03 | Yadkin, North Carolina, US | |
506072 | 506072 | 2022-12-17 | US | North Carolina | Yadkin | 37197 | 14212 | 138 | 0 | 36.16222629 | -80.66239436 | 2022-12-18 04:21:03 | Yadkin, North Carolina, US | |
3326644 | 3326644 | 2022-12-16 | US | North Carolina | Yadkin | 37197 | 14212 | 138 | 0 | 36.16222629 | -80.66239436 | 2022-12-17 04:21:04 | Yadkin, North Carolina, US | |
545156 | 545156 | 2022-12-15 | US | North Carolina | Yadkin | 37197 | 14212 | 138 | 0 | 36.16222629 | -80.66239436 | 2022-12-16 04:21:01 | Yadkin, North Carolina, US | |
350684 | 350684 | 2022-12-14 | US | North Carolina | Yadkin | 37197 | 14212 | 138 | 0 | 36.16222629 | -80.66239436 | 2022-12-15 04:20:58 | Yadkin, North Carolina, US | |
3747717 | 3747717 | 2022-09-07 | US | Oklahoma | Washington | 40147 | 14212 | 267 | 0 | 36.71380786 | -95.90514104 | 2022-09-08 04:21:02 | Washington, Oklahoma, US | |
117357 | 117357 | 2022-09-06 | US | Oklahoma | Washington | 40147 | 14212 | 267 | 0 | 36.71380786 | -95.90514104 | 2022-09-07 04:20:59 | Washington, Oklahoma, US | |
2636329 | 2636329 | 2022-09-05 | US | Oklahoma | Washington | 40147 | 14212 | 267 | 0 | 36.71380786 | -95.90514104 | 2022-09-06 04:21:02 | Washington, Oklahoma, US | |
2989893 | 2989893 | 2022-09-04 | US | Oklahoma | Washington | 40147 | 14212 | 267 | 0 | 36.71380786 | -95.90514104 | 2022-09-05 04:21:01 | Washington, Oklahoma, US | |
2715578 | 2715578 | 2022-09-03 | US | Oklahoma | Washington | 40147 | 14212 | 267 | 0 | 36.71380786 | -95.90514104 | 2022-09-04 04:21:22 | Washington, Oklahoma, US | |
1396283 | 1396283 | 2022-09-02 | US | Oklahoma | Washington | 40147 | 14212 | 267 | 0 | 36.71380786 | -95.90514104 | 2022-09-03 04:21:04 | Washington, Oklahoma, US | |
3550112 | 3550112 | 2022-09-01 | US | Oklahoma | Washington | 40147 | 14212 | 267 | 0 | 36.71380786 | -95.90514104 | 2022-09-02 04:21:07 | Washington, Oklahoma, US | |
3776828 | 3776828 | 2022-08-30 | US | Tennessee | Campbell | 47013 | 14212 | 177 | 0 | 36.40355516 | -84.1510856 | 2022-08-31 04:20:57 | Campbell, Tennessee, US | |
1252950 | 1252950 | 2022-08-23 | US | New Mexico | Curry | 35009 | 14212 | 224 | 0 | 34.57421077 | -103.3468876 | 2022-08-24 04:20:46 | Curry, New Mexico, US | |
3911457 | 3911457 | 2022-08-11 | US | Washington | Mason | 53045 | 14212 | 155 | 0 | 47.35007586 | -123.1863685 | 2022-08-12 04:20:54 | Mason, Washington, US | |
1349774 | 1349774 | 2022-08-10 | US | Washington | Mason | 53045 | 14212 | 155 | 0 | 47.35007586 | -123.1863685 | 2022-08-11 04:20:49 | Mason, Washington, US | |
962439 | 962439 | 2022-07-19 | US | Wisconsin | Dunn | 55033 | 14212 | 76 | 0 | 44.94562799 | -91.8962481 | 2022-07-20 04:20:59 | Dunn, Wisconsin, US | |
1423616 | 1423616 | 2022-06-08 | US | Ohio | Sandusky | 39143 | 14212 | 243 | 0 | 41.35624126 | -83.137872 | 2022-06-09 04:20:54 | Sandusky, Ohio, US | |
3728730 | 3728730 | 2022-06-07 | US | Ohio | Sandusky | 39143 | 14212 | 243 | 0 | 41.35624126 | -83.137872 | 2022-06-08 04:20:55 | Sandusky, Ohio, US | |
3890132 | 3890132 | 2022-06-06 | US | Ohio | Sandusky | 39143 | 14212 | 243 | 0 | 41.35624126 | -83.137872 | 2022-06-07 04:21:08 | Sandusky, Ohio, US | |
3509901 | 3509901 | 2022-06-05 | US | Ohio | Sandusky | 39143 | 14212 | 243 | 0 | 41.35624126 | -83.137872 | 2022-06-06 04:20:57 | Sandusky, Ohio, US | |
3529978 | 3529978 | 2022-06-04 | US | Ohio | Sandusky | 39143 | 14212 | 243 | 0 | 41.35624126 | -83.137872 | 2022-06-05 04:20:55 | Sandusky, Ohio, US | |
3136064 | 3136064 | 2022-06-03 | US | Ohio | Sandusky | 39143 | 14212 | 243 | 0 | 41.35624126 | -83.137872 | 2022-06-04 04:20:58 | Sandusky, Ohio, US | |
3581139 | 3581139 | 2022-06-02 | US | Ohio | Sandusky | 39143 | 14212 | 243 | 0 | 41.35624126 | -83.137872 | 2022-06-03 04:20:58 | Sandusky, Ohio, US | |
2480294 | 2480294 | 2022-03-30 | US | North Carolina | Granville | 37077 | 14212 | 111 | 0 | 36.30337451 | -78.65184241 | 2022-03-31 04:20:56 | Granville, North Carolina, US | |
2201821 | 2201821 | 2022-03-06 | US | New Jersey | Salem | 34033 | 14212 | 245 | 0 | 39.58719656 | -75.34696629999998 | 2022-03-07 04:20:47 | Salem, New Jersey, US | |
1514372 | 1514372 | 2022-02-24 | US | Tennessee | Lawrence | 47099 | 14212 | 185 | 0 | 35.21675201 | -87.39787695 | 2022-02-25 04:21:11 | Lawrence, Tennessee, US | |
2476618 | 2476618 | 2022-02-03 | US | Pennsylvania | Columbia | 42037 | 14212 | 217 | 0 | 41.04821986 | -76.40565017 | 2022-02-04 04:21:10 | Columbia, Pennsylvania, US | |
1115411 | 1115411 | 2022-01-11 | US | Mississippi | Lauderdale | 28075 | 14212 | 324 | 0 | 32.40419769 | -88.66229662 | 2022-01-12 04:21:44 | Lauderdale, Mississippi, US | |
1671075 | 1671075 | 2021-12-29 | US | Oregon | Douglas | 41019 | 14212 | 315 | 0 | 43.27941273 | -123.16729099999999 | 2021-12-30 04:21:25 | Douglas, Oregon, US | |
732989 | 732989 | 2021-12-27 | US | Ohio | Erie | 39043 | 14212 | 222 | 0 | 41.36796058 | -82.62904521 | 2021-12-28 04:21:47 | Erie, Ohio, US | |
2197186 | 2197186 | 2021-12-03 | US | Maine | Penobscot | 23019 | 14212 | 205 | 0 | 45.40194593 | -68.65020455 | 2021-12-04 04:22:18 | Penobscot, Maine, US | |
150902 | 150902 | 2021-11-29 | US | Idaho | Bannock | 16005 | 14212 | 203 | 0 | 42.67002716 | -112.2233311 | 2021-11-30 04:22:53 | Bannock, Idaho, US | |
2945257 | 2945257 | 2021-10-15 | US | Missouri | Franklin | 29071 | 14212 | 214 | 0 | 38.41127108 | -91.07522826 | 2021-10-16 04:21:15 | Franklin, Missouri, US | |
1922299 | 1922299 | 2021-09-24 | US | Indiana | Delaware | 18035 | 14212 | 222 | 0 | 40.22787247 | -85.39732772 | 2021-09-25 04:21:31 | Delaware, Indiana, US | |
2903227 | 2903227 | 2021-08-12 | US | Wisconsin | Fond du Lac | 55039 | 14212 | 146 | 0 | 43.75354908 | -88.48885325 | 2021-08-13 04:21:24 | Fond du Lac, Wisconsin, US | |
485125 | 485125 | 2021-07-19 | US | Louisiana | Tangipahoa | 22105 | 14212 | 314 | 0 | 30.62888673 | -90.40664996 | 2021-07-20 04:21:48 | Tangipahoa, Louisiana, US | |
298635 | 298635 | 2021-07-15 | US | Oregon | Lane | 41039 | 14212 | 169 | 0 | 43.93727035 | -122.847753 | 2021-07-16 04:21:22 | Lane, Oregon, US | |
3092795 | 3092795 | 2021-05-30 | US | Virginia | Newport News | 51700 | 14212 | 230 | 0 | 37.08166899 | -76.51754109 | 2021-05-31 03:08:59 | Newport News, Virginia, US | |
1873954 | 1873954 | 2021-05-15 | US | Illinois | Kankakee | 17091 | 14212 | 210 | 0 | 41.13746989 | -87.86205334 | 2021-05-16 04:20:49 | Kankakee, Illinois, US | |
2505664 | 2505664 | 2021-05-07 | Ukraine | Sevastopol* | 14212 | 640 | 13092 | 480 | 44.6054 | 33.522 | 2021-05-08 04:21:04 | Sevastopol*, Ukraine | ||
3624175 | 3624175 | 2021-03-17 | US | Texas | Guadalupe | 48187 | 14212 | 198 | 0 | 29.58165339 | -97.94786822 | 2021-03-18 05:26:22 | Guadalupe, Texas, US | |
3902181 | 3902181 | 2021-01-09 | US | New York | Dutchess | 36027 | 14212 | 270 | 0 | 13942 | 41.76486060000001 | -73.74356679 | 2021-01-10 05:22:12 | Dutchess, New York, US |
3900030 | 3900030 | 2021-01-09 | Malta | 14212 | 232 | 11759 | 2221 | 35.9375 | 14.3754 | 2021-01-10 05:22:12 | Malta | |||
1013464 | 1013464 | 2020-12-30 | US | Texas | McLennan | 48309 | 14212 | 275 | 0 | 18284 | 31.55255453 | -97.20217694 | 2020-12-31 05:22:49 | McLennan, Texas, US |
3770272 | 3770272 | 2020-12-22 | US | Alabama | Shelby | 1117 | 14212 | 98 | 0 | 14114 | 33.26879845 | -86.66232561 | 2020-12-23 05:22:03 | Shelby, Alabama, US |
927897 | 927897 | 2020-12-21 | Russia | Karachay-Cherkess Republic | 14212 | 38 | 12654 | 1520 | 43.7368326 | 41.7267991 | 2020-12-22 05:22:33 | Karachay-Cherkess Republic, Russia | ||
754243 | 754243 | 2020-10-28 | India | Chandigarh | 14212 | 224 | 13359 | 629 | 30.733839 | 76.76827800000002 | 2020-10-29 04:24:49 | Chandigarh, India | ||
3993648 | 3993648 | 2020-10-20 | US | Texas | Collin | 48085 | 14212 | 172 | 0 | 16876 | 33.18820114 | -96.57264368 | 2020-10-21 04:24:14 | Collin, Texas, US |
366805 | 366805 | 2020-07-16 | US | Texas | Travis | 48453 | 14212 | 183 | 0 | 16387 | 30.33432034 | -97.7853562 | 2020-07-17 04:34:50 | Travis, Texas, 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]);