johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
400 rows where active = 499 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3476099 | 3476099 | 2021-07-22 | Chile | Los Lagos | 86909 | 1302 | 85108 | 499 | -41.9198 | -72.1416 | 2021-07-23 04:21:29 | Los Lagos, Chile | ||
1440511 | 1440511 | 2021-07-07 | Guinea | 23945 | 174 | 23272 | 499 | 9.9456 | -9.6966 | 2021-07-08 04:21:26 | Guinea | |||
1932308 | 1932308 | 2021-07-05 | Croatia | 360246 | 8219 | 351528 | 499 | 45.1 | 15.2 | 2021-07-06 04:21:32 | Croatia | |||
3125693 | 3125693 | 2021-06-28 | Russia | Altai Republic | 17747 | 249 | 16999 | 499 | 50.7114101 | 86.8572186 | 2021-06-29 04:21:28 | Altai Republic, Russia | ||
2422724 | 2422724 | 2021-06-23 | Colombia | Arauca | 9788 | 294 | 8995 | 499 | 7.0762 | -70.7105 | 2021-06-24 04:21:55 | Arauca, Colombia | ||
3089633 | 3089633 | 2021-05-30 | Russia | Khanty-Mansi Autonomous Okrug | 57454 | 798 | 56157 | 499 | 61.0259025 | 69.0982628 | 2021-05-31 03:08:59 | Khanty-Mansi Autonomous Okrug, Russia | ||
637780 | 637780 | 2021-03-31 | Colombia | Quindio | 34536 | 1021 | 33016 | 499 | 4.461 | -75.6674 | 2021-04-01 04:27:05 | Quindio, Colombia | ||
1219420 | 1219420 | 2021-03-27 | Colombia | Meta | 43589 | 995 | 42095 | 499 | 3.272 | -73.0877 | 2021-03-28 05:28:10 | Meta, Colombia | ||
1207489 | 1207489 | 2021-03-22 | Malaysia | Sabah | 54296 | 388 | 53409 | 499 | 5.9788 | 116.0753 | 2021-03-23 05:26:18 | Sabah, Malaysia | ||
1203996 | 1203996 | 2021-03-22 | Russia | Bryansk Oblast | 34807 | 279 | 34029 | 499 | 52.8873315 | 33.41585300000001 | 2021-03-23 05:26:18 | Bryansk Oblast, Russia | ||
3624763 | 3624763 | 2021-03-17 | Malaysia | Sabah | 54002 | 385 | 53118 | 499 | 5.9788 | 116.0753 | 2021-03-18 05:26:22 | Sabah, Malaysia | ||
1732684 | 1732684 | 2021-03-14 | Russia | Bryansk Oblast | 34126 | 267 | 33360 | 499 | 52.8873315 | 33.41585300000001 | 2021-03-15 05:25:51 | Bryansk Oblast, Russia | ||
1579936 | 1579936 | 2021-03-13 | Chile | Atacama | 12896 | 160 | 12237 | 499 | -27.5661 | -70.0503 | 2021-03-14 05:25:37 | Atacama, Chile | ||
2359251 | 2359251 | 2021-03-08 | Chile | Atacama | 12539 | 156 | 11884 | 499 | -27.5661 | -70.0503 | 2021-03-09 05:28:19 | Atacama, Chile | ||
1092484 | 1092484 | 2021-03-03 | US | North Dakota | Pierce | 38069 | 523 | 24 | 0 | 499 | 48.24977025 | -99.96407787 | 2021-03-04 05:24:24 | Pierce, North Dakota, US |
3256556 | 3256556 | 2021-03-02 | US | North Dakota | Pierce | 38069 | 522 | 24 | 0 | 499 | 48.24977025 | -99.96407787 | 2021-03-03 05:23:28 | Pierce, North Dakota, US |
2369599 | 2369599 | 2021-02-28 | US | Nebraska | Polk | 31143 | 508 | 9 | 0 | 499 | 41.18813488 | -97.56630712 | 2021-03-01 05:23:01 | Polk, Nebraska, US |
2367509 | 2367509 | 2021-02-28 | Japan | Hyogo | 17968 | 530 | 16939 | 499 | 35.039913 | 134.828057 | 2021-03-01 05:23:01 | Hyogo, Japan | ||
282285 | 282285 | 2021-02-24 | US | Nebraska | Polk | 31143 | 508 | 9 | 0 | 499 | 41.18813488 | -97.56630712 | 2021-02-25 05:24:57 | Polk, Nebraska, US |
744040 | 744040 | 2021-02-20 | US | Minnesota | Lincoln | 27081 | 501 | 2 | 0 | 499 | 44.41311883 | -96.26688165 | 2021-02-21 05:24:33 | Lincoln, Minnesota, US |
473138 | 473138 | 2021-02-19 | US | Minnesota | Lincoln | 27081 | 501 | 2 | 0 | 499 | 44.41311883 | -96.26688165 | 2021-02-20 05:22:51 | Lincoln, Minnesota, US |
3604456 | 3604456 | 2021-02-17 | US | Virginia | Williamsburg | 51830 | 508 | 9 | 0 | 499 | 37.28131268 | -76.70905141 | 2021-02-18 05:22:58 | Williamsburg, Virginia, US |
3600893 | 3600893 | 2021-02-17 | Colombia | Meta | 41853 | 957 | 40397 | 499 | 3.272 | -73.0877 | 2021-02-18 05:22:58 | Meta, Colombia | ||
3050025 | 3050025 | 2021-02-16 | Colombia | Huila | 48941 | 1672 | 46770 | 499 | 2.5359 | -75.5277 | 2021-02-17 05:23:10 | Huila, Colombia | ||
2638761 | 2638761 | 2021-02-11 | US | Illinois | Stark | 17175 | 521 | 22 | 0 | 499 | 41.09309773 | -89.79745866 | 2021-02-12 05:23:29 | Stark, Illinois, US |
3978388 | 3978388 | 2021-02-10 | China | Hong Kong | 10710 | 188 | 10022 | 499 | 22.3 | 114.2 | 2021-02-11 05:23:55 | Hong Kong, China | ||
1529247 | 1529247 | 2021-02-09 | US | Kansas | Washington | 20201 | 508 | 9 | 0 | 499 | 39.78420784 | -97.0875323 | 2021-02-10 05:22:41 | Washington, Kansas, US |
615038 | 615038 | 2021-02-08 | US | Kansas | Washington | 20201 | 508 | 9 | 0 | 499 | 39.78420784 | -97.0875323 | 2021-02-09 05:23:30 | Washington, Kansas, US |
614308 | 614308 | 2021-02-08 | US | Colorado | Kit Carson | 8063 | 529 | 10 | 0 | 499 | 39.30497777 | -102.6022199 | 2021-02-09 05:23:30 | Kit Carson, Colorado, US |
1673077 | 1673077 | 2021-02-07 | US | Colorado | Kit Carson | 8063 | 523 | 10 | 0 | 499 | 39.30497777 | -102.6022199 | 2021-02-08 05:22:39 | Kit Carson, Colorado, US |
975892 | 975892 | 2021-02-06 | US | Illinois | Edwards | 17047 | 507 | 8 | 0 | 499 | 38.41353228 | -88.05720863 | 2021-02-07 05:23:00 | Edwards, Illinois, US |
975538 | 975538 | 2021-02-06 | US | Colorado | Kit Carson | 8063 | 522 | 10 | 0 | 499 | 39.30497777 | -102.6022199 | 2021-02-07 05:23:00 | Kit Carson, Colorado, US |
974699 | 974699 | 2021-02-06 | Chad | 3473 | 125 | 2849 | 499 | 15.4542 | 18.7322 | 2021-02-07 05:23:00 | Chad | |||
1588812 | 1588812 | 2021-02-05 | US | Colorado | Park | 8093 | 534 | 5 | 0 | 499 | 39.120926 | -105.7182065 | 2021-02-06 05:23:55 | Park, Colorado, US |
1588796 | 1588796 | 2021-02-05 | US | Colorado | Kit Carson | 8063 | 521 | 10 | 0 | 499 | 39.30497777 | -102.6022199 | 2021-02-06 05:23:55 | Kit Carson, Colorado, US |
790287 | 790287 | 2021-02-04 | Gabon | 11129 | 70 | 10560 | 499 | -0.8037 | 11.6094 | 2021-02-05 05:22:38 | Gabon | |||
340179 | 340179 | 2021-02-03 | Gabon | 11129 | 70 | 10560 | 499 | -0.8037 | 11.6094 | 2021-02-04 05:22:26 | Gabon | |||
1687041 | 1687041 | 2021-02-02 | US | Oklahoma | Dewey | 40043 | 503 | 4 | 0 | 499 | 35.98772922 | -99.00730714 | 2021-02-03 05:22:52 | Dewey, Oklahoma, US |
1678028 | 1678028 | 2021-02-01 | US | Maine | Waldo | 23027 | 517 | 18 | 0 | 499 | 44.4858305 | -69.12061935 | 2021-02-02 05:22:49 | Waldo, Maine, US |
2214381 | 2214381 | 2021-01-30 | US | Puerto Rico | Cabo Rojo | 72023 | 499 | 0 | 0 | 499 | 18.040993 | -67.154391 | 2021-01-31 05:22:42 | Cabo Rojo, Puerto Rico, US |
2482725 | 2482725 | 2021-01-28 | US | Georgia | Calhoun | 13037 | 511 | 12 | 0 | 499 | 31.53169785 | -84.62725131 | 2021-01-29 05:22:23 | Calhoun, Georgia, US |
3156661 | 3156661 | 2021-01-27 | US | Texas | Dallam | 48111 | 907 | 20 | 0 | 499 | 36.27787176 | -102.6020725 | 2021-01-28 05:22:24 | Dallam, Texas, US |
12268 | 12268 | 2021-01-26 | Guinea | 14379 | 82 | 13798 | 499 | 9.9456 | -9.6966 | 2021-01-27 05:23:41 | Guinea | |||
12195 | 12195 | 2021-01-26 | Colombia | Putumayo | 7086 | 279 | 6308 | 499 | 0.436 | -75.5277 | 2021-01-27 05:23:41 | Putumayo, Colombia | ||
2569975 | 2569975 | 2021-01-25 | US | North Carolina | Graham | 37075 | 511 | 12 | 0 | 499 | 35.3506925 | -83.83369267 | 2021-01-26 05:22:02 | Graham, North Carolina, US |
2567519 | 2567519 | 2021-01-25 | Colombia | Putumayo | 7086 | 279 | 6308 | 499 | 0.436 | -75.5277 | 2021-01-26 05:22:02 | Putumayo, Colombia | ||
1762618 | 1762618 | 2021-01-24 | US | Virginia | Essex | 51057 | 502 | 3 | 0 | 499 | 37.93357639 | -76.94230311 | 2021-01-25 05:22:16 | Essex, Virginia, US |
1761607 | 1761607 | 2021-01-24 | US | North Carolina | Graham | 37075 | 511 | 12 | 0 | 499 | 35.3506925 | -83.83369267 | 2021-01-25 05:22:16 | Graham, North Carolina, US |
2429214 | 2429214 | 2021-01-23 | US | North Carolina | Graham | 37075 | 511 | 12 | 0 | 499 | 35.3506925 | -83.83369267 | 2021-01-24 05:22:35 | Graham, North Carolina, US |
911535 | 911535 | 2021-01-19 | US | Virginia | Lunenburg | 51111 | 502 | 3 | 0 | 499 | 36.94618528 | -78.24133319 | 2021-01-20 05:21:54 | Lunenburg, Virginia, US |
3104197 | 3104197 | 2021-01-16 | US | Puerto Rico | Orocovis | 72107 | 499 | 0 | 0 | 499 | 18.215046 | -66.433604 | 2021-01-17 05:22:17 | Orocovis, Puerto Rico, US |
3101465 | 3101465 | 2021-01-16 | Japan | Miyazaki | 1500 | 11 | 990 | 499 | 32.193203999999994 | 131.299374 | 2021-01-17 05:22:17 | Miyazaki, Japan | ||
3311298 | 3311298 | 2021-01-13 | US | Texas | Hamilton | 48193 | 551 | 19 | 0 | 499 | 31.70470573 | -98.11083887 | 2021-01-14 05:22:32 | Hamilton, Texas, US |
3310157 | 3310157 | 2021-01-13 | US | Missouri | St. Clair | 29185 | 504 | 5 | 0 | 499 | 38.03699437 | -93.77631447 | 2021-01-14 05:22:32 | St. Clair, Missouri, US |
777465 | 777465 | 2021-01-12 | US | Texas | Jack | 48237 | 504 | 12 | 0 | 499 | 33.23377248 | -98.17283469 | 2021-01-13 05:22:15 | Jack, Texas, US |
777443 | 777443 | 2021-01-12 | US | Texas | Hamilton | 48193 | 550 | 18 | 0 | 499 | 31.70470573 | -98.11083887 | 2021-01-13 05:22:15 | Hamilton, Texas, US |
193164 | 193164 | 2021-01-11 | US | Texas | Hamilton | 48193 | 550 | 18 | 0 | 499 | 31.70470573 | -98.11083887 | 2021-01-12 05:22:15 | Hamilton, Texas, US |
191685 | 191685 | 2021-01-11 | US | Michigan | Crawford | 26039 | 504 | 5 | 0 | 499 | 44.68255561 | -84.61006219 | 2021-01-12 05:22:15 | Crawford, Michigan, US |
3901845 | 3901845 | 2021-01-09 | US | Missouri | Daviess | 29061 | 508 | 9 | 0 | 499 | 39.96145298 | -93.98519678 | 2021-01-10 05:22:12 | Daviess, Missouri, US |
2544003 | 2544003 | 2021-01-07 | US | Oregon | Baker | 41001 | 504 | 5 | 0 | 499 | 44.70915557 | -117.6749883 | 2021-01-08 05:22:42 | Baker, Oregon, US |
2868153 | 2868153 | 2021-01-06 | US | Washington | Klickitat | 53039 | 502 | 3 | 0 | 499 | 45.87325839 | -120.7913598 | 2021-01-07 05:22:03 | Klickitat, Washington, US |
3037581 | 3037581 | 2021-01-05 | US | Vermont | Rutland | 50021 | 508 | 9 | 0 | 499 | 43.57723578 | -73.03741676 | 2021-01-06 05:22:16 | Rutland, Vermont, US |
1064052 | 1064052 | 2021-01-04 | US | New Mexico | Torrance | 35057 | 503 | 4 | 0 | 499 | 34.64048375 | -105.8508949 | 2021-01-05 05:21:49 | Torrance, New Mexico, US |
1063270 | 1063270 | 2021-01-04 | US | Kentucky | Livingston | 21139 | 510 | 11 | 0 | 499 | 37.21137452 | -88.34797529 | 2021-01-05 05:21:49 | Livingston, Kentucky, US |
1062348 | 1062348 | 2021-01-04 | US | Arkansas | Montgomery | 5097 | 517 | 18 | 0 | 499 | 34.53704874 | -93.65824478 | 2021-01-05 05:21:49 | Montgomery, Arkansas, US |
3231783 | 3231783 | 2021-01-03 | US | Kansas | Scott | 20171 | 515 | 16 | 0 | 499 | 38.48222076 | -100.9066539 | 2021-01-04 05:22:02 | Scott, Kansas, US |
3230951 | 3230951 | 2021-01-03 | US | Arkansas | Montgomery | 5097 | 517 | 18 | 0 | 499 | 34.53704874 | -93.65824478 | 2021-01-04 05:22:02 | Montgomery, Arkansas, US |
2230690 | 2230690 | 2021-01-02 | US | Texas | Morris | 48343 | 656 | 11 | 0 | 499 | 33.11304005 | -94.73255695 | 2021-01-03 05:22:52 | Morris, Texas, US |
2228852 | 2228852 | 2021-01-02 | US | Kansas | Scott | 20171 | 515 | 16 | 0 | 499 | 38.48222076 | -100.9066539 | 2021-01-03 05:22:52 | Scott, Kansas, US |
1138216 | 1138216 | 2021-01-01 | US | Kansas | Scott | 20171 | 515 | 16 | 0 | 499 | 38.48222076 | -100.9066539 | 2021-01-02 05:22:33 | Scott, Kansas, US |
1137399 | 1137399 | 2021-01-01 | US | Arkansas | Searcy | 5129 | 510 | 11 | 0 | 499 | 35.9109364 | -92.69936482 | 2021-01-02 05:22:33 | Searcy, Arkansas, US |
1136922 | 1136922 | 2021-01-01 | Japan | Shizuoka | 2717 | 41 | 2177 | 499 | 34.916975 | 138.40778400000002 | 2021-01-02 05:22:33 | Shizuoka, Japan | ||
769371 | 769371 | 2020-12-29 | US | Texas | Crockett | 48105 | 361 | 9 | 0 | 499 | 30.72367027 | -101.4134238 | 2020-12-30 05:22:34 | Crockett, Texas, US |
767678 | 767678 | 2020-12-29 | US | Kentucky | Bath | 21011 | 504 | 5 | 0 | 499 | 38.14735938 | -83.74588932 | 2020-12-30 05:22:34 | Bath, Kentucky, US |
2225732 | 2225732 | 2020-12-26 | US | New York | Essex | 36031 | 515 | 16 | 0 | 499 | 44.11630765 | -73.77297842 | 2020-12-27 05:22:55 | Essex, New York, US |
2224754 | 2224754 | 2020-12-26 | US | Iowa | Worth | 19195 | 501 | 2 | 0 | 499 | 43.37750768 | -93.26087602 | 2020-12-27 05:22:55 | Worth, Iowa, US |
2224019 | 2224019 | 2020-12-26 | US | Arkansas | Prairie | 5117 | 512 | 13 | 0 | 499 | 34.83624419 | -91.55162157 | 2020-12-27 05:22:55 | Prairie, Arkansas, US |
203639 | 203639 | 2020-12-25 | US | Kentucky | Edmonson | 21061 | 512 | 13 | 0 | 499 | 37.21218923 | -86.23955613 | 2020-12-26 05:22:28 | Edmonson, Kentucky, US |
3692862 | 3692862 | 2020-12-24 | US | Kentucky | Edmonson | 21061 | 512 | 13 | 0 | 499 | 37.21218923 | -86.23955613 | 2020-12-25 05:22:48 | Edmonson, Kentucky, US |
3691547 | 3691547 | 2020-12-24 | Maldives | 13558 | 48 | 13011 | 499 | 3.2028 | 73.2207 | 2020-12-25 05:22:48 | Maldives | |||
2410223 | 2410223 | 2020-12-23 | US | Virginia | Rockbridge | 51163 | 503 | 4 | 0 | 499 | 37.81204314 | -79.44605905 | 2020-12-24 05:23:04 | Rockbridge, Virginia, US |
2409881 | 2409881 | 2020-12-23 | US | Texas | Crane | 48103 | 355 | 9 | 0 | 499 | 31.43052248 | -102.5143314 | 2020-12-24 05:23:04 | Crane, Texas, US |
2408761 | 2408761 | 2020-12-23 | US | Missouri | Oregon | 29149 | 502 | 3 | 0 | 499 | 36.68710164 | -91.4033755 | 2020-12-24 05:23:04 | Oregon, Missouri, US |
2408214 | 2408214 | 2020-12-23 | US | Kentucky | Edmonson | 21061 | 512 | 13 | 0 | 499 | 37.21218923 | -86.23955613 | 2020-12-24 05:23:04 | Edmonson, Kentucky, US |
2407345 | 2407345 | 2020-12-23 | US | Arkansas | Scott | 5127 | 508 | 9 | 0 | 499 | 34.85588887 | -94.0632176 | 2020-12-24 05:23:04 | Scott, Arkansas, US |
3770529 | 3770529 | 2020-12-22 | US | Colorado | Yuma | 8125 | 652 | 15 | 0 | 499 | 40.00346839 | -102.4258673 | 2020-12-23 05:22:03 | Yuma, Colorado, US |
2121625 | 2121625 | 2020-12-20 | US | Missouri | Lewis | 29111 | 501 | 2 | 0 | 499 | 40.09673161 | -91.72070156 | 2020-12-21 05:27:58 | Lewis, Missouri, US |
2120818 | 2120818 | 2020-12-20 | US | Indiana | Martin | 18101 | 510 | 11 | 0 | 499 | 38.7099921 | -86.80373186 | 2020-12-21 05:27:58 | Martin, Indiana, US |
2119672 | 2119672 | 2020-12-20 | India | Meghalaya | 13253 | 134 | 12620 | 499 | 25.536934 | 91.278882 | 2020-12-21 05:27:58 | Meghalaya, India | ||
2119406 | 2119406 | 2020-12-20 | Andorra | 7577 | 81 | 6997 | 499 | 42.5063 | 1.5218 | 2020-12-21 05:27:58 | Andorra | |||
2934588 | 2934588 | 2020-12-19 | US | Virginia | New Kent | 51127 | 504 | 5 | 0 | 499 | 37.50694406 | -76.99828634 | 2020-12-20 05:27:32 | New Kent, Virginia, US |
2934097 | 2934097 | 2020-12-19 | US | South Dakota | Lyman | 46085 | 508 | 9 | 0 | 499 | 43.89522709 | -99.85201878 | 2020-12-20 05:27:32 | Lyman, South Dakota, US |
2933132 | 2933132 | 2020-12-19 | US | Missouri | Lewis | 29111 | 501 | 2 | 0 | 499 | 40.09673161 | -91.72070156 | 2020-12-20 05:27:32 | Lewis, Missouri, US |
1037661 | 1037661 | 2020-12-15 | US | Virginia | Alleghany | 51005 | 517 | 18 | 0 | 499 | 37.78636074 | -80.00222498 | 2020-12-16 05:28:04 | Alleghany, Virginia, US |
1036672 | 1036672 | 2020-12-15 | US | North Carolina | Currituck | 37053 | 505 | 6 | 0 | 499 | 36.36123664 | -75.95876401 | 2020-12-16 05:28:04 | Currituck, North Carolina, US |
849080 | 849080 | 2020-12-12 | US | West Virginia | Wetzel | 54103 | 513 | 14 | 0 | 499 | 39.6065771 | -80.64016540000001 | 2020-12-13 05:27:20 | Wetzel, West Virginia, US |
1600229 | 1600229 | 2020-12-10 | Japan | Hiroshima | 1327 | 8 | 820 | 499 | 34.605309000000005 | 132.788719 | 2020-12-11 05:26:59 | Hiroshima, Japan | ||
2977962 | 2977962 | 2020-12-09 | US | Puerto Rico | Hatillo | 72065 | 499 | 0 | 0 | 499 | 18.410928 | -66.79632600000001 | 2020-12-10 05:26:19 | Hatillo, Puerto Rico, US |
1821928 | 1821928 | 2020-12-08 | US | Texas | Lampasas | 48281 | 635 | 11 | 0 | 499 | 31.19531316 | -98.24206613 | 2020-12-09 05:28:01 | Lampasas, Texas, US |
1820390 | 1820390 | 2020-12-08 | US | Michigan | Arenac | 26011 | 521 | 22 | 0 | 499 | 44.0636262 | -83.89277559 | 2020-12-09 05:28:01 | Arenac, Michigan, 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]);