johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
762892 | 762892 | 2020-10-18 | US | California | Tuolumne | 6109 | 251 | 4 | 0 | 244 | 38.02644018 | -119.9525093 | 2020-10-19 04:24:16 | Tuolumne, California, US |
763622 | 763622 | 2020-10-18 | US | Kansas | Nemaha | 20131 | 251 | 1 | 0 | 250 | 39.78345387 | -96.01392079 | 2020-10-19 04:24:16 | Nemaha, Kansas, US |
764869 | 764869 | 2020-10-18 | US | Oklahoma | Love | 40085 | 251 | 1 | 0 | 250 | 33.95273467 | -97.23906784 | 2020-10-19 04:24:16 | Love, Oklahoma, US |
764871 | 764871 | 2020-10-18 | US | Oklahoma | Marshall | 40095 | 251 | 2 | 0 | 249 | 34.02311222 | -96.76855464 | 2020-10-19 04:24:16 | Marshall, Oklahoma, US |
768902 | 768902 | 2020-12-29 | US | Oklahoma | Roger Mills | 40129 | 251 | 6 | 0 | 245 | 35.68711719 | -99.69666167 | 2020-12-30 05:22:34 | Roger Mills, Oklahoma, US |
769588 | 769588 | 2020-12-29 | US | Vermont | Addison | 50001 | 251 | 4 | 0 | 247 | 44.03217337 | -73.14130877 | 2020-12-30 05:22:34 | Addison, Vermont, US |
776742 | 776742 | 2021-01-12 | US | North Dakota | Kidder | 38043 | 251 | 9 | 0 | 242 | 46.97830064 | -99.77507857 | 2021-01-13 05:22:15 | Kidder, North Dakota, US |
787265 | 787265 | 2020-10-15 | US | Georgia | Wilcox | 13315 | 251 | 25 | 0 | 226 | 31.97496928 | -83.43438555 | 2020-10-16 04:24:01 | Wilcox, Georgia, US |
787531 | 787531 | 2020-10-15 | US | Iowa | Calhoun | 19025 | 251 | 3 | 0 | 248 | 42.38521079 | -94.64046046 | 2020-10-16 04:24:01 | Calhoun, Iowa, US |
788001 | 788001 | 2020-10-15 | US | Michigan | Huron | 26063 | 251 | 5 | 0 | 246 | 43.83353985 | -83.04078453 | 2020-10-16 04:24:01 | Huron, Michigan, US |
788923 | 788923 | 2020-10-15 | US | Oklahoma | Johnston | 40069 | 251 | 4 | 0 | 247 | 34.31440473 | -96.66011537 | 2020-10-16 04:24:01 | Johnston, Oklahoma, US |
789549 | 789549 | 2020-10-15 | US | Texas | Ochiltree | 48357 | 251 | 5 | 0 | 221 | 36.27829105 | -100.8158184 | 2020-10-16 04:24:01 | Ochiltree, Texas, US |
793104 | 793104 | 2021-02-04 | US | Puerto Rico | Ceiba | 72037 | 251 | 0 | 0 | 251 | 18.251818 | -65.666416 | 2021-02-05 05:22:38 | Ceiba, Puerto Rico, US |
802133 | 802133 | 2020-06-01 | US | Pennsylvania | Adams | 42001 | 251 | 8 | 0 | 243 | 39.87140411 | -77.21610347 | 2020-06-02 02:33:08 | Adams, Pennsylvania, US |
802697 | 802697 | 2020-06-01 | US | Georgia | Columbia | 13073 | 251 | 8 | 0 | 243 | 33.54534185 | -82.263524 | 2020-06-02 02:33:08 | Columbia, Georgia, US |
814692 | 814692 | 2020-09-05 | US | Indiana | Ripley | 18137 | 251 | 8 | 0 | 243 | 39.10235626 | -85.26212744 | 2020-09-06 04:28:33 | Ripley, Indiana, US |
816042 | 816042 | 2020-09-05 | US | Ohio | Logan | 39091 | 251 | 4 | 0 | 247 | 40.38996525 | -83.76784341 | 2020-09-06 04:28:33 | Logan, Ohio, US |
818539 | 818539 | 2020-10-09 | US | Illinois | Fulton | 17057 | 251 | 0 | 0 | 251 | 40.47289135 | -90.20862357 | 2020-10-10 04:23:57 | Fulton, Illinois, US |
818935 | 818935 | 2020-10-09 | US | Kentucky | Carter | 21043 | 251 | 3 | 0 | 248 | 38.31690743 | -83.05092385 | 2020-10-10 04:23:57 | Carter, Kentucky, US |
820523 | 820523 | 2020-10-09 | US | Tennessee | Meigs | 47121 | 251 | 3 | 0 | 249 | 35.51558739 | -84.81482914 | 2020-10-10 04:23:57 | Meigs, Tennessee, US |
822105 | 822105 | 2020-11-19 | US | California | Del Norte | 6015 | 251 | 2 | 0 | 249 | 41.74228275 | -123.8974063 | 2020-11-20 05:26:28 | Del Norte, California, US |
823234 | 823234 | 2020-11-19 | US | Michigan | Ontonagon | 26131 | 251 | 9 | 0 | 242 | 46.665226200000006 | -89.31390481 | 2020-11-20 05:26:28 | Ontonagon, Michigan, US |
824674 | 824674 | 2020-11-19 | US | Texas | Hemphill | 48211 | 251 | 1 | 0 | 237 | 35.83764858 | -100.2703577 | 2020-11-20 05:26:28 | Hemphill, Texas, US |
826846 | 826846 | 2021-06-06 | US | Kansas | Clark | 20025 | 251 | 7 | 0 | 37.23577007 | -99.81883015 | 2021-06-07 04:22:51 | Clark, Kansas, US | |
839411 | 839411 | 2020-08-17 | US | Mississippi | Kemper | 28069 | 251 | 14 | 0 | 237 | 32.75462946 | -88.64105766 | 2020-08-18 04:27:56 | Kemper, Mississippi, US |
840099 | 840099 | 2020-08-17 | US | Ohio | Seneca | 39147 | 251 | 12 | 0 | 239 | 41.12351311 | -83.12783209 | 2020-08-18 04:27:56 | Seneca, Ohio, US |
840831 | 840831 | 2020-08-17 | US | Texas | Van Zandt | 48467 | 251 | 8 | 0 | 438 | 32.56483801 | -95.83766469 | 2020-08-18 04:27:56 | Van Zandt, Texas, US |
842555 | 842555 | 2020-07-22 | US | Tennessee | Henderson | 47077 | 251 | 0 | 0 | 211 | 35.65581134 | -88.38600175 | 2020-07-23 05:15:04 | Henderson, Tennessee, US |
843377 | 843377 | 2020-07-22 | US | California | Nevada | 6057 | 251 | 1 | 0 | 249 | 39.30394768 | -120.7627281 | 2020-07-23 05:15:04 | Nevada, California, US |
844356 | 844356 | 2020-07-22 | US | New York | Washington | 36115 | 251 | 14 | 0 | 237 | 43.31153794 | -73.43043448 | 2020-07-23 05:15:04 | Washington, New York, US |
845100 | 845100 | 2020-07-22 | Eritrea | 251 | 0 | 155 | 96 | 15.1794 | 39.7823 | 2020-07-23 05:15:04 | Eritrea | |||
845992 | 845992 | 2020-12-12 | US | Alaska | Nome | 2180 | 251 | 0 | 0 | 251 | 64.90320724 | -164.0353804 | 2020-12-13 05:27:20 | Nome, Alaska, US |
847545 | 847545 | 2020-12-12 | US | Montana | Broadwater | 30007 | 251 | 1 | 0 | 250 | 46.33277565 | -111.4955813 | 2020-12-13 05:27:20 | Broadwater, Montana, US |
847702 | 847702 | 2020-12-12 | US | Nevada | Lincoln | 32017 | 251 | 1 | 0 | 250 | 37.64268459 | -114.8790388 | 2020-12-13 05:27:20 | Lincoln, Nevada, US |
858008 | 858008 | 2020-04-15 | US | Nebraska | Douglas | 31055 | 251 | 5 | 0 | 246 | 41.29518299 | -96.15085305 | 2020-04-15 22:56:51 | Douglas, Nebraska, US |
862809 | 862809 | 2020-12-11 | US | Nevada | Lincoln | 32017 | 251 | 1 | 0 | 250 | 37.64268459 | -114.8790388 | 2020-12-12 05:26:19 | Lincoln, Nevada, US |
863989 | 863989 | 2020-12-11 | US | Virginia | Covington | 51580 | 251 | 3 | 0 | 248 | 37.7824656 | -79.98631446 | 2020-12-12 05:26:19 | Covington, Virginia, US |
865943 | 865943 | 2020-11-12 | US | Iowa | Decatur | 19053 | 251 | 0 | 0 | 251 | 40.73742757 | -93.78645949 | 2020-11-13 05:25:30 | Decatur, Iowa, US |
867798 | 867798 | 2020-11-12 | US | Texas | Callahan | 48059 | 251 | 7 | 0 | 280 | 32.29760619 | -99.37326312 | 2020-11-13 05:25:30 | Callahan, Texas, US |
872749 | 872749 | 2020-05-24 | US | Colorado | Broomfield | 8014 | 251 | 26 | 0 | 195 | 39.95998787 | -105.0566324 | 2020-05-25 02:32:44 | Broomfield, Colorado, US |
875857 | 875857 | 2020-05-24 | Sao Tome and Principe | 251 | 8 | 4 | 239 | 0.18636 | 6.613081 | 2020-05-25 02:32:44 | Sao Tome and Principe | |||
884674 | 884674 | 2020-07-07 | US | North Carolina | Davie | 37059 | 251 | 4 | 0 | 247 | 35.93099927 | -80.54496571 | 2020-07-08 05:33:48 | Davie, North Carolina, US |
887782 | 887782 | 2020-07-07 | Malaysia | Melaka | 251 | 6 | 246 | 0 | 2.1896 | 102.2501 | 2020-07-08 05:33:48 | Melaka, Malaysia | ||
893790 | 893790 | 2020-11-05 | US | Michigan | Roscommon | 26143 | 251 | 6 | 0 | 245 | 44.33473082 | -84.61067651 | 2020-11-06 05:24:55 | Roscommon, Michigan, US |
925391 | 925391 | 2020-11-26 | US | Minnesota | Grant | 27051 | 251 | 6 | 0 | 245 | 45.93424769 | -96.01139609 | 2020-11-27 05:26:53 | Grant, Minnesota, US |
926999 | 926999 | 2020-11-26 | US | Virginia | Dickenson | 51051 | 251 | 1 | 0 | 250 | 37.12560977 | -82.35124171 | 2020-11-27 05:26:53 | Dickenson, Virginia, US |
929016 | 929016 | 2020-12-21 | US | Kansas | Rawlins | 20153 | 251 | 3 | 0 | 248 | 39.78525843 | -101.0761617 | 2020-12-22 05:22:33 | Rawlins, Kansas, US |
929979 | 929979 | 2020-12-21 | US | North Carolina | Camden | 37029 | 251 | 4 | 0 | 247 | 36.33804939 | -76.15568396 | 2020-12-22 05:22:33 | Camden, North Carolina, US |
930296 | 930296 | 2020-12-21 | US | Oregon | Curry | 41015 | 251 | 2 | 0 | 249 | 42.45911325 | -124.157282 | 2020-12-22 05:22:33 | Curry, Oregon, US |
930883 | 930883 | 2020-12-21 | US | Texas | Reagan | 48383 | 251 | 6 | 0 | 344 | 31.36607041 | -101.5232659 | 2020-12-22 05:22:33 | Reagan, Texas, US |
961802 | 961802 | 2022-07-19 | US | South Dakota | Sully | 46119 | 251 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-07-20 04:20:59 | Sully, South Dakota, US | |
966904 | 966904 | 2020-09-29 | Japan | Fukushima | 251 | 3 | 206 | 42 | 37.378867 | 140.223295 | 2020-09-30 04:23:33 | Fukushima, Japan | ||
967717 | 967717 | 2020-09-29 | US | Georgia | Long | 13183 | 251 | 3 | 0 | 248 | 31.75218791 | -81.74952375 | 2020-09-30 04:23:33 | Long, Georgia, US |
969107 | 969107 | 2020-09-29 | US | New York | Chenango | 36017 | 251 | 7 | 0 | 244 | 42.49430041 | -75.60887553 | 2020-09-30 04:23:33 | Chenango, New York, US |
984207 | 984207 | 2021-04-17 | US | Kansas | Chase | 20017 | 251 | 3 | 0 | 38.30292938 | -96.59563862 | 2021-04-18 04:20:41 | Chase, Kansas, US | |
984955 | 984955 | 2021-04-17 | US | Montana | Mineral | 30061 | 251 | 0 | 0 | 47.15283992 | -115.0015239 | 2021-04-18 04:20:41 | Mineral, Montana, US | |
994972 | 994972 | 2020-05-23 | US | North Carolina | Buncombe | 37021 | 251 | 8 | 0 | 243 | 35.61113393 | -82.53305 | 2020-05-24 02:32:43 | Buncombe, North Carolina, US |
998048 | 998048 | 2020-05-23 | Sao Tome and Principe | 251 | 8 | 4 | 239 | 0.18636 | 6.613081 | 2020-05-24 02:32:43 | Sao Tome and Principe | |||
1001302 | 1001302 | 2021-03-01 | US | South Dakota | Haakon | 46055 | 251 | 10 | 0 | 241 | 44.29299053 | -101.539099 | 2021-03-02 05:23:30 | Haakon, South Dakota, US |
1002585 | 1002585 | 2020-07-09 | US | Virginia | Charlottesville | 51540 | 251 | 7 | 0 | 244 | 38.03527919 | -78.48569588 | 2020-07-10 04:34:24 | Charlottesville, Virginia, US |
1002848 | 1002848 | 2020-07-09 | US | North Carolina | Davie | 37059 | 251 | 4 | 0 | 247 | 35.93099927 | -80.54496571 | 2020-07-10 04:34:24 | Davie, North Carolina, US |
1003708 | 1003708 | 2020-07-09 | US | Indiana | Lawrence | 18093 | 251 | 26 | 0 | 225 | 38.84112637 | -86.48361629 | 2020-07-10 04:34:24 | Lawrence, Indiana, US |
1005958 | 1005958 | 2020-07-09 | Malaysia | Melaka | 251 | 6 | 246 | 0 | 2.1896 | 102.2501 | 2020-07-10 04:34:24 | Melaka, Malaysia | ||
1006937 | 1006937 | 2020-12-06 | US | Colorado | Saguache | 8109 | 251 | 4 | 0 | 227 | 38.08054629 | -106.282466 | 2020-12-07 05:26:14 | Saguache, Colorado, US |
1011211 | 1011211 | 2020-12-30 | US | Idaho | Adams | 16003 | 251 | 3 | 0 | 248 | 44.89333571 | -116.4545247 | 2020-12-31 05:22:49 | Adams, Idaho, US |
1027309 | 1027309 | 2020-10-17 | US | Illinois | Clark | 17023 | 251 | 6 | 0 | 245 | 39.33425789 | -87.78705622 | 2020-10-18 04:24:25 | Clark, Illinois, US |
1028914 | 1028914 | 2020-10-17 | US | Oklahoma | Murray | 40099 | 251 | 2 | 0 | 249 | 34.48116015 | -97.06826283 | 2020-10-18 04:24:25 | Murray, Oklahoma, US |
1029207 | 1029207 | 2020-10-17 | US | South Dakota | Grant | 46051 | 251 | 2 | 0 | 249 | 45.1723937 | -96.77002276 | 2020-10-18 04:24:25 | Grant, South Dakota, US |
1029770 | 1029770 | 2020-10-17 | US | Washington | Clallam | 53009 | 251 | 1 | 0 | 250 | 48.04754642 | -123.9226319 | 2020-10-18 04:24:25 | Clallam, Washington, US |
1037132 | 1037132 | 2020-12-15 | US | Puerto Rico | Penuelas | 72111 | 251 | 0 | 0 | 251 | 18.059645 | -66.721572 | 2020-12-16 05:28:04 | Penuelas, Puerto Rico, US |
1037388 | 1037388 | 2020-12-15 | US | Texas | Blanco | 48031 | 251 | 7 | 0 | 237 | 30.26640707 | -98.3999852 | 2020-12-16 05:28:04 | Blanco, Texas, US |
1040890 | 1040890 | 2020-05-26 | US | New York | Warren | 36113 | 251 | 26 | 0 | 225 | 43.56173026 | -73.8433699 | 2020-05-27 02:32:31 | Warren, New York, US |
1041307 | 1041307 | 2020-05-26 | Mexico | Zacatecas | 251 | 29 | 170 | 52 | 22.7709 | -102.5832 | 2020-05-27 02:32:31 | Zacatecas, Mexico | ||
1042572 | 1042572 | 2020-10-07 | US | Georgia | Calhoun | 13037 | 251 | 9 | 0 | 242 | 31.53169785 | -84.62725131 | 2020-10-08 04:23:56 | Calhoun, Georgia, US |
1043714 | 1043714 | 2020-10-07 | US | Missouri | Henry | 29083 | 251 | 5 | 0 | 246 | 38.38482826 | -93.79293734 | 2020-10-08 04:23:56 | Henry, Missouri, US |
1044241 | 1044241 | 2020-10-07 | US | North Dakota | Walsh | 38099 | 251 | 1 | 0 | 250 | 48.36876964 | -97.72574783 | 2020-10-08 04:23:56 | Walsh, North Dakota, US |
1047246 | 1047246 | 2020-09-30 | US | Kentucky | Mercer | 21167 | 251 | 2 | 0 | 249 | 37.81474237 | -84.87488475 | 2020-10-01 04:23:42 | Mercer, Kentucky, US |
1048209 | 1048209 | 2020-09-30 | US | North Dakota | McKenzie | 38053 | 251 | 2 | 0 | 248 | 47.74133370000001 | -103.395905 | 2020-10-01 04:23:42 | McKenzie, North Dakota, US |
1054714 | 1054714 | 2020-10-23 | US | Georgia | Wilcox | 13315 | 251 | 25 | 0 | 226 | 31.97496928 | -83.43438555 | 2020-10-24 04:24:46 | Wilcox, Georgia, US |
1054789 | 1054789 | 2020-10-23 | US | Illinois | De Witt | 17039 | 251 | 5 | 0 | 246 | 40.17514519 | -88.90959682 | 2020-10-24 04:24:46 | De Witt, Illinois, US |
1055253 | 1055253 | 2020-10-23 | US | Kentucky | McCreary | 21147 | 251 | 1 | 0 | 250 | 36.73874143 | -84.48102924 | 2020-10-24 04:24:46 | McCreary, Kentucky, US |
1055899 | 1055899 | 2020-10-23 | US | Nebraska | Kearney | 31099 | 251 | 0 | 0 | 251 | 40.50663314 | -98.94877182 | 2020-10-24 04:24:46 | Kearney, Nebraska, US |
1056198 | 1056198 | 2020-10-23 | US | North Dakota | Bottineau | 38009 | 251 | 16 | 0 | 226 | 48.79106111 | -100.8378166 | 2020-10-24 04:24:46 | Bottineau, North Dakota, US |
1056662 | 1056662 | 2020-10-23 | US | South Dakota | Brule | 46015 | 251 | 2 | 0 | 249 | 43.71756379 | -99.08118954 | 2020-10-24 04:24:46 | Brule, South Dakota, US |
1056716 | 1056716 | 2020-10-23 | US | South Dakota | Tripp | 46123 | 251 | 2 | 0 | 249 | 43.34459388 | -99.8854891 | 2020-10-24 04:24:46 | Tripp, South Dakota, US |
1063892 | 1063892 | 2021-01-04 | US | Nebraska | Cherry | 31031 | 251 | 4 | 0 | 247 | 42.54502621 | -101.1244332 | 2021-01-05 05:21:49 | Cherry, Nebraska, US |
1080342 | 1080342 | 2021-12-09 | US | North Dakota | Oliver | 38065 | 251 | 4 | 0 | 47.11530482 | -101.3406158 | 2021-12-10 04:22:28 | Oliver, North Dakota, US | |
1081749 | 1081749 | 2021-05-14 | China | Shanxi | 251 | 0 | 244 | 7 | 37.5777 | 112.2922 | 2021-05-15 04:20:58 | Shanxi, China | ||
1092818 | 1092818 | 2021-03-03 | US | Puerto Rico | Lajas | 72079 | 251 | 0 | 0 | 251 | 18.011661 | -67.040585 | 2021-03-04 05:24:24 | Lajas, Puerto Rico, US |
1104620 | 1104620 | 2020-05-25 | US | New York | Warren | 36113 | 251 | 26 | 0 | 225 | 43.56173026 | -73.8433699 | 2020-05-26 02:32:35 | Warren, New York, US |
1105901 | 1105901 | 2020-09-02 | US | Alabama | Cleburne | 1029 | 251 | 5 | 0 | 246 | 33.67679204 | -85.52005899 | 2020-09-03 04:28:22 | Cleburne, Alabama, US |
1106380 | 1106380 | 2020-09-02 | US | Georgia | McIntosh | 13191 | 251 | 5 | 0 | 246 | 31.49683595 | -81.40163426 | 2020-09-03 04:28:22 | McIntosh, Georgia, US |
1107987 | 1107987 | 2020-09-02 | US | Ohio | Clinton | 39027 | 251 | 7 | 0 | 244 | 39.41485808 | -83.80852286 | 2020-09-03 04:28:22 | Clinton, Ohio, US |
1108512 | 1108512 | 2020-09-02 | US | Tennessee | Morgan | 47129 | 251 | 2 | 0 | 218 | 36.13248031 | -84.64880098 | 2020-09-03 04:28:22 | Morgan, Tennessee, US |
1108842 | 1108842 | 2020-09-02 | US | Virginia | Botetourt | 51023 | 251 | 10 | 0 | 241 | 37.55531756 | -79.80982182 | 2020-09-03 04:28:22 | Botetourt, Virginia, US |
1119977 | 1119977 | 2021-08-06 | US | North Dakota | Burke | 38013 | 251 | 3 | 0 | 48.79094471 | -102.5182117 | 2021-08-07 04:21:30 | Burke, North Dakota, US | |
1122045 | 1122045 | 2020-09-17 | US | Arkansas | Clay | 5021 | 251 | 7 | 0 | 244 | 36.36826212 | -90.4148172 | 2020-09-18 05:05:00 | Clay, Arkansas, US |
1122741 | 1122741 | 2020-09-17 | US | Iowa | Butler | 19023 | 251 | 2 | 0 | 249 | 42.73172833 | -92.79015971 | 2020-09-18 05:05:00 | Butler, Iowa, US |
1123011 | 1123011 | 2020-09-17 | US | Kentucky | Marshall | 21157 | 251 | 2 | 0 | 249 | 36.8800707 | -88.32803576 | 2020-09-18 05:05:00 | Marshall, Kentucky, US |
1123211 | 1123211 | 2020-09-17 | US | Michigan | Houghton | 26061 | 251 | 1 | 0 | 250 | 46.89988536 | -88.68495385 | 2020-09-18 05:05:00 | Houghton, 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]);