johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
202 rows where active = 1110 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3683303 | 3683303 | 2021-08-02 | Colombia | Meta | 85638 | 2125 | 82403 | 1110 | 3.272 | -73.0877 | 2021-08-03 04:21:39 | Meta, Colombia | ||
3137551 | 3137551 | 2021-07-23 | Japan | Aichi | 52640 | 1002 | 50528 | 1110 | 35.035551 | 137.211621 | 2021-07-24 00:21:36 | Aichi, Japan | ||
3706073 | 3706073 | 2021-07-17 | India | Himachal Pradesh | 204337 | 3505 | 199722 | 1110 | 31.927213 | 77.233081 | 2021-07-18 04:22:07 | Himachal Pradesh, India | ||
1712280 | 1712280 | 2021-06-25 | India | Madhya Pradesh | 789611 | 8871 | 779630 | 1110 | 23.541513 | 78.289633 | 2021-06-26 04:21:43 | Madhya Pradesh, India | ||
1740132 | 1740132 | 2021-06-12 | Ukraine | Ivano-Frankivsk Oblast | 86531 | 2082 | 83339 | 1110 | 48.9226 | 24.7111 | 2021-06-13 04:22:44 | Ivano-Frankivsk Oblast, Ukraine | ||
2586221 | 2586221 | 2021-06-05 | Russia | Orel Oblast | 35889 | 674 | 34105 | 1110 | 52.96854329999999 | 36.0692477 | 2021-06-06 04:24:03 | Orel Oblast, Russia | ||
2315577 | 2315577 | 2021-06-04 | Seychelles | 12035 | 42 | 10883 | 1110 | -4.6796 | 55.492 | 2021-06-05 04:23:03 | Seychelles | |||
1708544 | 1708544 | 2021-06-02 | Russia | Orel Oblast | 35751 | 667 | 33974 | 1110 | 52.96854329999999 | 36.0692477 | 2021-06-03 04:23:32 | Orel Oblast, Russia | ||
1806887 | 1806887 | 2021-05-27 | Pakistan | Balochistan | 24908 | 273 | 23525 | 1110 | 28.328492 | 65.898403 | 2021-05-28 04:20:36 | Balochistan, Pakistan | ||
1771586 | 1771586 | 2021-05-23 | Russia | Samara Oblast | 64143 | 1827 | 61206 | 1110 | 53.2128813 | 50.8914633 | 2021-05-24 04:20:53 | Samara Oblast, Russia | ||
2391024 | 2391024 | 2021-05-18 | Russia | Tyumen Oblast | 36056 | 516 | 34430 | 1110 | 58.8206488 | 70.36588370000001 | 2021-05-19 04:20:42 | Tyumen Oblast, Russia | ||
2824574 | 2824574 | 2021-05-01 | Chile | Los Rios | 33883 | 379 | 32394 | 1110 | -40.231 | -72.3311 | 2021-05-02 04:20:48 | Los Rios, Chile | ||
3393385 | 3393385 | 2021-04-28 | Italy | P.A. Trento | 43832 | 1340 | 41382 | 1110 | 46.06893511 | 11.12123097 | 2021-04-29 04:20:55 | P.A. Trento, Italy | ||
169837 | 169837 | 2021-04-16 | Chile | Nuble | 24012 | 436 | 22466 | 1110 | -36.7226 | -71.7622 | 2021-04-17 04:20:40 | Nuble, Chile | ||
3883586 | 3883586 | 2021-04-11 | Italy | Valle d'Aosta | 10055 | 436 | 8509 | 1110 | 45.73750286 | 7.320149366 | 2021-04-12 04:21:00 | Valle d'Aosta, Italy | ||
1748166 | 1748166 | 2021-03-20 | Ukraine | Luhansk Oblast | 16182 | 500 | 14572 | 1110 | 48.574 | 39.3078 | 2021-03-21 05:25:44 | Luhansk Oblast, Ukraine | ||
2359365 | 2359365 | 2021-03-08 | France | Reunion | 13125 | 59 | 11956 | 1110 | -21.1151 | 55.5364 | 2021-03-09 05:28:19 | Reunion, France | ||
54703 | 54703 | 2021-03-07 | France | Reunion | 13125 | 59 | 11956 | 1110 | -21.1151 | 55.5364 | 2021-03-08 05:24:48 | Reunion, France | ||
3667520 | 3667520 | 2021-03-06 | France | Reunion | 13125 | 59 | 11956 | 1110 | -21.1151 | 55.5364 | 2021-03-07 05:21:54 | Reunion, France | ||
1616141 | 1616141 | 2021-03-05 | France | Reunion | 13125 | 59 | 11956 | 1110 | -21.1151 | 55.5364 | 2021-03-06 04:23:41 | Reunion, France | ||
2207552 | 2207552 | 2021-03-04 | France | Reunion | 13125 | 59 | 11956 | 1110 | -21.1151 | 55.5364 | 2021-03-05 05:26:29 | Reunion, France | ||
1091268 | 1091268 | 2021-03-03 | US | Iowa | Humboldt | 19091 | 1135 | 25 | 0 | 1110 | 42.7764426 | -94.20722537 | 2021-03-04 05:24:24 | Humboldt, Iowa, US |
1091254 | 1091254 | 2021-03-03 | US | Iowa | Emmet | 19063 | 1150 | 40 | 0 | 1110 | 43.37782951 | -94.67858943 | 2021-03-04 05:24:24 | Emmet, Iowa, US |
1089973 | 1089973 | 2021-03-03 | France | Reunion | 13125 | 59 | 11956 | 1110 | -21.1151 | 55.5364 | 2021-03-04 05:24:24 | Reunion, France | ||
3255612 | 3255612 | 2021-03-02 | US | Kentucky | Trigg | 21221 | 1118 | 8 | 0 | 1110 | 36.80767017 | -87.87333656 | 2021-03-03 05:23:28 | Trigg, Kentucky, US |
1861071 | 1861071 | 2021-02-25 | US | Texas | Duval | 48131 | 1180 | 37 | 0 | 1110 | 27.68184592 | -98.50864568 | 2021-02-26 05:22:40 | Duval, Texas, US |
280106 | 280106 | 2021-02-24 | Germany | Unknown | 1110 | 0 | 0 | 1110 | 2021-02-25 05:24:57 | Unknown, Germany | ||||
533369 | 533369 | 2021-02-22 | US | Pennsylvania | Fulton | 42057 | 1124 | 14 | 0 | 1110 | 39.92913544 | -78.11163677 | 2021-02-23 05:23:41 | Fulton, Pennsylvania, US |
184703 | 184703 | 2021-02-21 | US | Pennsylvania | Fulton | 42057 | 1124 | 14 | 0 | 1110 | 39.92913544 | -78.11163677 | 2021-02-22 05:24:21 | Fulton, Pennsylvania, US |
745019 | 745019 | 2021-02-20 | US | Puerto Rico | Aguadilla | 72005 | 1110 | 0 | 0 | 1110 | 18.459681 | -67.12081500000001 | 2021-02-21 05:24:33 | Aguadilla, Puerto Rico, US |
744977 | 744977 | 2021-02-20 | US | Pennsylvania | Fulton | 42057 | 1124 | 14 | 0 | 1110 | 39.92913544 | -78.11163677 | 2021-02-21 05:24:33 | Fulton, Pennsylvania, US |
471273 | 471273 | 2021-02-19 | Colombia | Tolima | 64777 | 2061 | 61606 | 1110 | 4.0925 | -75.1545 | 2021-02-20 05:22:51 | Tolima, Colombia | ||
3601384 | 3601384 | 2021-02-17 | US | Alabama | Bullock | 1011 | 1143 | 33 | 0 | 1110 | 32.10030533 | -85.71265535 | 2021-02-18 05:22:58 | Bullock, Alabama, US |
3053772 | 3053772 | 2021-02-16 | US | Wyoming | Goshen | 56015 | 1132 | 22 | 0 | 1110 | 42.08798185 | -104.3534743 | 2021-02-17 05:23:10 | Goshen, Wyoming, US |
1341871 | 1341871 | 2021-02-15 | US | Wyoming | Goshen | 56015 | 1132 | 22 | 0 | 1110 | 42.08798185 | -104.3534743 | 2021-02-16 05:24:38 | Goshen, Wyoming, US |
1340532 | 1340532 | 2021-02-15 | US | New York | Schoharie | 36095 | 1121 | 11 | 0 | 1110 | 42.58831742 | -74.44339029999998 | 2021-02-16 05:24:38 | Schoharie, New York, US |
1338618 | 1338618 | 2021-02-15 | US | Alabama | Bullock | 1011 | 1142 | 32 | 0 | 1110 | 32.10030533 | -85.71265535 | 2021-02-16 05:24:38 | Bullock, Alabama, US |
2287022 | 2287022 | 2021-02-14 | US | Wyoming | Goshen | 56015 | 1132 | 22 | 0 | 1110 | 42.08798185 | -104.3534743 | 2021-02-15 05:24:49 | Goshen, Wyoming, US |
2283769 | 2283769 | 2021-02-14 | US | Alabama | Bullock | 1011 | 1142 | 32 | 0 | 1110 | 32.10030533 | -85.71265535 | 2021-02-15 05:24:49 | Bullock, Alabama, US |
2681422 | 2681422 | 2021-02-13 | US | Wyoming | Goshen | 56015 | 1132 | 22 | 0 | 1110 | 42.08798185 | -104.3534743 | 2021-02-14 05:23:43 | Goshen, Wyoming, US |
2681345 | 2681345 | 2021-02-13 | US | Wisconsin | Bayfield | 55007 | 1128 | 18 | 0 | 1110 | 46.52868768 | -91.19716729 | 2021-02-14 05:23:43 | Bayfield, Wisconsin, US |
2681319 | 2681319 | 2021-02-13 | US | West Virginia | Nicholas | 54067 | 1122 | 12 | 0 | 1110 | 38.29617706 | -80.79759588 | 2021-02-14 05:23:43 | Nicholas, West Virginia, US |
2679365 | 2679365 | 2021-02-13 | US | Louisiana | West Carroll | 22123 | 1148 | 38 | 0 | 1110 | 32.78550125 | -91.461201 | 2021-02-14 05:23:43 | West Carroll, Louisiana, US |
2679203 | 2679203 | 2021-02-13 | US | Kentucky | Casey | 21045 | 1142 | 32 | 0 | 1110 | 37.32533118 | -84.92726209 | 2021-02-14 05:23:43 | Casey, Kentucky, US |
3543055 | 3543055 | 2021-02-12 | US | Wyoming | Goshen | 56015 | 1132 | 22 | 0 | 1110 | 42.08798185 | -104.3534743 | 2021-02-13 05:22:12 | Goshen, Wyoming, US |
3542978 | 3542978 | 2021-02-12 | US | Wisconsin | Bayfield | 55007 | 1128 | 18 | 0 | 1110 | 46.52868768 | -91.19716729 | 2021-02-13 05:22:12 | Bayfield, Wisconsin, US |
3542688 | 3542688 | 2021-02-12 | US | Texas | Tyler | 48457 | 1224 | 31 | 0 | 1110 | 30.77031716 | -94.37690895 | 2021-02-13 05:22:12 | Tyler, Texas, US |
3540998 | 3540998 | 2021-02-12 | US | Louisiana | West Carroll | 22123 | 1148 | 38 | 0 | 1110 | 32.78550125 | -91.461201 | 2021-02-13 05:22:12 | West Carroll, Louisiana, US |
2639739 | 2639739 | 2021-02-11 | US | Montana | Rosebud | 30087 | 1154 | 44 | 0 | 1110 | 46.23397237 | -106.72928799999998 | 2021-02-12 05:23:29 | Rosebud, Montana, US |
1529313 | 1529313 | 2021-02-09 | US | Kentucky | Larue | 21123 | 1121 | 11 | 0 | 1110 | 37.54567114 | -85.70138352 | 2021-02-10 05:22:41 | Larue, Kentucky, US |
1674474 | 1674474 | 2021-02-07 | US | Montana | Rosebud | 30087 | 1154 | 44 | 0 | 1110 | 46.23397237 | -106.72928799999998 | 2021-02-08 05:22:39 | Rosebud, Montana, US |
1686801 | 1686801 | 2021-02-02 | US | North Carolina | Currituck | 37053 | 1124 | 14 | 0 | 1110 | 36.36123664 | -75.95876401 | 2021-02-03 05:22:52 | Currituck, North Carolina, US |
1678178 | 1678178 | 2021-02-01 | US | Minnesota | Faribault | 27043 | 1126 | 16 | 0 | 1110 | 43.67381499 | -93.94787458 | 2021-02-02 05:22:49 | Faribault, Minnesota, US |
1676234 | 1676234 | 2021-02-01 | Cameroon | 29617 | 462 | 28045 | 1110 | 3.848 | 11.5021 | 2021-02-02 05:22:49 | Cameroon | |||
1459522 | 1459522 | 2021-01-31 | Cameroon | 29617 | 462 | 28045 | 1110 | 3.848 | 11.5021 | 2021-02-01 05:22:53 | Cameroon | |||
2211430 | 2211430 | 2021-01-30 | Cameroon | 29617 | 462 | 28045 | 1110 | 3.848 | 11.5021 | 2021-01-31 05:22:42 | Cameroon | |||
1898122 | 1898122 | 2021-01-29 | US | Illinois | Cumberland | 17035 | 1125 | 15 | 0 | 1110 | 39.27432424 | -88.2401158 | 2021-01-30 05:22:49 | Cumberland, Illinois, US |
1896917 | 1896917 | 2021-01-29 | Cameroon | 29617 | 462 | 28045 | 1110 | 3.848 | 11.5021 | 2021-01-30 05:22:49 | Cameroon | |||
2481733 | 2481733 | 2021-01-28 | Cameroon | 29617 | 462 | 28045 | 1110 | 3.848 | 11.5021 | 2021-01-29 05:22:23 | Cameroon | |||
3153368 | 3153368 | 2021-01-27 | Cameroon | 29617 | 462 | 28045 | 1110 | 3.848 | 11.5021 | 2021-01-28 05:22:24 | Cameroon | |||
14092 | 14092 | 2021-01-26 | US | Minnesota | Rock | 27133 | 1122 | 12 | 0 | 1110 | 43.67482683 | -96.25296832 | 2021-01-27 05:23:41 | Rock, Minnesota, US |
12103 | 12103 | 2021-01-26 | Cameroon | 29617 | 462 | 28045 | 1110 | 3.848 | 11.5021 | 2021-01-27 05:23:41 | Cameroon | |||
2568826 | 2568826 | 2021-01-25 | US | Iowa | Cass | 19029 | 1153 | 43 | 0 | 1110 | 41.33149454 | -94.92792482 | 2021-01-26 05:22:02 | Cass, Iowa, US |
2568273 | 2568273 | 2021-01-25 | US | Colorado | Elbert | 8039 | 1214 | 12 | 0 | 1110 | 39.28656773 | -104.1358721 | 2021-01-26 05:22:02 | Elbert, Colorado, US |
2567427 | 2567427 | 2021-01-25 | Cameroon | 29617 | 462 | 28045 | 1110 | 3.848 | 11.5021 | 2021-01-26 05:22:02 | Cameroon | |||
1759490 | 1759490 | 2021-01-24 | Russia | Chuvashia Republic | 18812 | 794 | 16908 | 1110 | 55.4259922 | 47.0849429 | 2021-01-25 05:22:16 | Chuvashia Republic, Russia | ||
1759059 | 1759059 | 2021-01-24 | Cameroon | 29617 | 462 | 28045 | 1110 | 3.848 | 11.5021 | 2021-01-25 05:22:16 | Cameroon | |||
2429197 | 2429197 | 2021-01-23 | US | North Carolina | Chowan | 37041 | 1130 | 20 | 0 | 1110 | 36.12908077 | -76.60118385 | 2021-01-24 05:22:35 | Chowan, North Carolina, US |
2426666 | 2426666 | 2021-01-23 | Cameroon | 29617 | 462 | 28045 | 1110 | 3.848 | 11.5021 | 2021-01-24 05:22:35 | Cameroon | |||
1095253 | 1095253 | 2021-01-20 | US | Iowa | Chickasaw | 19037 | 1122 | 12 | 0 | 1110 | 43.06001295 | -92.31773347 | 2021-01-21 05:22:01 | Chickasaw, Iowa, US |
3102409 | 3102409 | 2021-01-16 | US | Illinois | De Witt | 17039 | 1130 | 20 | 0 | 1110 | 40.17514519 | -88.90959682 | 2021-01-17 05:22:17 | De Witt, Illinois, US |
777529 | 777529 | 2021-01-12 | US | Texas | Panola | 48365 | 1407 | 46 | 0 | 1110 | 32.163959600000005 | -94.30552481 | 2021-01-13 05:22:15 | Panola, Texas, US |
775095 | 775095 | 2021-01-12 | US | Georgia | Bleckley | 13023 | 1147 | 37 | 0 | 1110 | 32.43829035 | -83.33035166 | 2021-01-13 05:22:15 | Bleckley, Georgia, US |
190420 | 190420 | 2021-01-11 | US | Alabama | Cleburne | 1029 | 1128 | 18 | 0 | 1110 | 33.67679204 | -85.52005899 | 2021-01-12 05:22:15 | Cleburne, Alabama, US |
2629330 | 2629330 | 2021-01-10 | US | West Virginia | Barbour | 54001 | 1124 | 14 | 0 | 1110 | 39.1307219 | -80.00350858 | 2021-01-11 05:21:50 | Barbour, West Virginia, US |
2628915 | 2628915 | 2021-01-10 | US | Texas | Colorado | 48089 | 1153 | 16 | 0 | 1110 | 29.622098 | -96.5273805 | 2021-01-11 05:21:50 | Colorado, Texas, US |
3902319 | 3902319 | 2021-01-09 | US | North Carolina | Transylvania | 37175 | 1121 | 11 | 0 | 1110 | 35.20383864 | -82.79638423 | 2021-01-10 05:22:12 | Transylvania, North Carolina, US |
2868236 | 2868236 | 2021-01-06 | US | Wisconsin | Burnett | 55013 | 1131 | 21 | 0 | 1110 | 45.86303537 | -92.36711412 | 2021-01-07 05:22:03 | Burnett, Wisconsin, US |
1011125 | 1011125 | 2020-12-30 | US | Georgia | Lamar | 13171 | 1142 | 32 | 0 | 1110 | 33.07841647 | -84.14263877 | 2020-12-31 05:22:49 | Lamar, Georgia, US |
767674 | 767674 | 2020-12-29 | US | Kentucky | Allen | 21003 | 1127 | 17 | 0 | 1110 | 36.75197631 | -86.19457544 | 2020-12-30 05:22:34 | Allen, Kentucky, US |
3778865 | 3778865 | 2020-12-27 | US | Illinois | Clark | 17023 | 1134 | 24 | 0 | 1110 | 39.33425789 | -87.78705622 | 2020-12-28 05:22:06 | Clark, Illinois, US |
203184 | 203184 | 2020-12-25 | US | Idaho | Gooding | 16047 | 1127 | 17 | 0 | 1110 | 42.96927962 | -114.8108306 | 2020-12-26 05:22:28 | Gooding, Idaho, US |
3694875 | 3694875 | 2020-12-24 | US | Virginia | Scott | 51169 | 1139 | 29 | 0 | 1110 | 36.71466456 | -82.60171704 | 2020-12-25 05:22:48 | Scott, Virginia, US |
3693704 | 3693704 | 2020-12-24 | US | New York | Fulton | 36035 | 1140 | 30 | 0 | 1110 | 43.11363907 | -74.41798804 | 2020-12-25 05:22:48 | Fulton, New York, US |
3692407 | 3692407 | 2020-12-24 | US | Idaho | Gooding | 16047 | 1127 | 17 | 0 | 1110 | 42.96927962 | -114.8108306 | 2020-12-25 05:22:48 | Gooding, Idaho, US |
2407339 | 2407339 | 2020-12-23 | US | Arkansas | Polk | 5113 | 1139 | 29 | 0 | 1110 | 34.48254879 | -94.22728802 | 2020-12-24 05:23:04 | Polk, Arkansas, US |
928655 | 928655 | 2020-12-21 | US | Illinois | Clay | 17025 | 1140 | 30 | 0 | 1110 | 38.75388572 | -88.48914513 | 2020-12-22 05:22:33 | Clay, Illinois, US |
2120676 | 2120676 | 2020-12-20 | US | Illinois | Clay | 17025 | 1140 | 30 | 0 | 1110 | 38.75388572 | -88.48914513 | 2020-12-21 05:27:58 | Clay, Illinois, US |
2933512 | 2933512 | 2020-12-19 | US | North Carolina | Cherokee | 37039 | 1125 | 15 | 0 | 1110 | 35.1349263 | -84.05970864 | 2020-12-20 05:27:32 | Cherokee, North Carolina, US |
2931227 | 2931227 | 2020-12-19 | Japan | Fukuoka | 7268 | 112 | 6046 | 1110 | 33.526032 | 130.666949 | 2020-12-20 05:27:32 | Fukuoka, Japan | ||
1902069 | 1902069 | 2020-12-18 | US | Hawaii | Maui | 15009 | 1127 | 17 | 0 | 1110 | 20.86399628 | -156.56890969999995 | 2020-12-19 05:27:52 | Maui, Hawaii, US |
1752048 | 1752048 | 2020-12-14 | US | Georgia | Dodge | 13091 | 1167 | 57 | 0 | 1110 | 32.17265114 | -83.16948926 | 2020-12-15 05:26:38 | Dodge, Georgia, US |
1603440 | 1603440 | 2020-12-10 | US | Texas | Terry | 48445 | 456 | 30 | 0 | 1110 | 33.17402785 | -102.3354521 | 2020-12-11 05:26:59 | Terry, Texas, US |
2975758 | 2975758 | 2020-12-09 | US | California | Amador | 6005 | 1129 | 19 | 0 | 1110 | 38.44583082 | -120.65696 | 2020-12-10 05:26:19 | Amador, California, US |
2975574 | 2975574 | 2020-12-09 | US | Alabama | Cherokee | 1019 | 1134 | 24 | 0 | 1110 | 34.17805983 | -85.60638968 | 2020-12-10 05:26:19 | Cherokee, Alabama, US |
2348305 | 2348305 | 2020-12-07 | US | Georgia | Union | 13291 | 1148 | 38 | 0 | 1110 | 34.82995757 | -83.98967069 | 2020-12-08 05:27:42 | Union, Georgia, US |
1635135 | 1635135 | 2020-12-05 | US | South Carolina | Union | 45087 | 1139 | 29 | 0 | 1110 | 34.68835752 | -81.61730349 | 2020-12-06 05:26:18 | Union, South Carolina, US |
3862538 | 3862538 | 2020-12-04 | US | Puerto Rico | Arecibo | 72013 | 1110 | 0 | 0 | 1110 | 18.406631 | -66.675077 | 2020-12-05 05:27:36 | Arecibo, Puerto Rico, US |
3861280 | 3861280 | 2020-12-04 | US | Kentucky | Perry | 21193 | 1121 | 11 | 0 | 1110 | 37.25023553 | -83.22922731 | 2020-12-05 05:27:36 | Perry, Kentucky, US |
3860718 | 3860718 | 2020-12-04 | US | Georgia | Washington | 13303 | 1145 | 35 | 0 | 1110 | 32.96711864 | -82.79357039 | 2020-12-05 05:27:36 | Washington, Georgia, 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]);