johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
295 rows where confirmed = 2717 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 15
- US 268
- United Kingdom 6
- China 4
- Japan 3
- Saint Kitts and Nevis 3
- Russia 2
- Colombia 1
- Italy 1
- Kazakhstan 1
- Mali 1
- Monaco 1
- Peru 1
- Rwanda 1
- Sweden 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
221605 | 221605 | 2022-12-26 | US | Wyoming | Washakie | 56043 | 2717 | 47 | 0 | 43.90451606 | -107.680187 | 2022-12-27 04:21:07 | Washakie, Wyoming, US | |
3226062 | 3226062 | 2022-12-25 | US | Wyoming | Washakie | 56043 | 2717 | 47 | 0 | 43.90451606 | -107.680187 | 2022-12-26 04:21:06 | Washakie, Wyoming, US | |
1021976 | 1021976 | 2022-12-24 | US | Wyoming | Washakie | 56043 | 2717 | 47 | 0 | 43.90451606 | -107.680187 | 2022-12-25 04:21:04 | Washakie, Wyoming, US | |
693999 | 693999 | 2022-12-23 | US | Wyoming | Washakie | 56043 | 2717 | 47 | 0 | 43.90451606 | -107.680187 | 2022-12-24 04:21:02 | Washakie, Wyoming, US | |
2183209 | 2183209 | 2022-12-22 | US | Wyoming | Washakie | 56043 | 2717 | 47 | 0 | 43.90451606 | -107.680187 | 2022-12-23 04:21:04 | Washakie, Wyoming, US | |
455013 | 455013 | 2022-12-21 | US | Wyoming | Washakie | 56043 | 2717 | 47 | 0 | 43.90451606 | -107.680187 | 2022-12-22 04:20:56 | Washakie, Wyoming, US | |
2955012 | 2955012 | 2022-12-20 | US | Wyoming | Washakie | 56043 | 2717 | 47 | 0 | 43.90451606 | -107.680187 | 2022-12-21 04:21:03 | Washakie, Wyoming, US | |
2954373 | 2954373 | 2022-12-20 | US | Tennessee | Perry | 47135 | 2717 | 60 | 0 | 35.63708728 | -87.86139634 | 2022-12-21 04:21:03 | Perry, Tennessee, US | |
3177414 | 3177414 | 2022-12-19 | US | Wyoming | Washakie | 56043 | 2717 | 47 | 0 | 43.90451606 | -107.680187 | 2022-12-20 04:21:04 | Washakie, Wyoming, US | |
1631931 | 1631931 | 2022-12-18 | US | Wyoming | Washakie | 56043 | 2717 | 47 | 0 | 43.90451606 | -107.680187 | 2022-12-19 04:21:03 | Washakie, Wyoming, US | |
507310 | 507310 | 2022-12-17 | US | Wyoming | Washakie | 56043 | 2717 | 47 | 0 | 43.90451606 | -107.680187 | 2022-12-18 04:21:03 | Washakie, Wyoming, US | |
3327882 | 3327882 | 2022-12-16 | US | Wyoming | Washakie | 56043 | 2717 | 47 | 0 | 43.90451606 | -107.680187 | 2022-12-17 04:21:04 | Washakie, Wyoming, US | |
546394 | 546394 | 2022-12-15 | US | Wyoming | Washakie | 56043 | 2717 | 47 | 0 | 43.90451606 | -107.680187 | 2022-12-16 04:21:01 | Washakie, Wyoming, US | |
351922 | 351922 | 2022-12-14 | US | Wyoming | Washakie | 56043 | 2717 | 47 | 0 | 43.90451606 | -107.680187 | 2022-12-15 04:20:58 | Washakie, Wyoming, US | |
311510 | 311510 | 2022-12-13 | US | Wyoming | Washakie | 56043 | 2717 | 47 | 0 | 43.90451606 | -107.680187 | 2022-12-14 04:21:04 | Washakie, Wyoming, US | |
292809 | 292809 | 2022-11-15 | US | Georgia | Dooly | 13093 | 2717 | 74 | 0 | 32.15630737 | -83.79746561 | 2022-11-16 04:21:09 | Dooly, Georgia, US | |
3597839 | 3597839 | 2022-11-14 | US | Georgia | Dooly | 13093 | 2717 | 74 | 0 | 32.15630737 | -83.79746561 | 2022-11-15 04:21:16 | Dooly, Georgia, US | |
312870 | 312870 | 2022-11-13 | US | Illinois | Brown | 17009 | 2717 | 17 | 0 | 39.96209138 | -90.75068024 | 2022-11-14 04:21:09 | Brown, Illinois, US | |
312697 | 312697 | 2022-11-13 | US | Georgia | Dooly | 13093 | 2717 | 74 | 0 | 32.15630737 | -83.79746561 | 2022-11-14 04:21:09 | Dooly, Georgia, US | |
64031 | 64031 | 2022-11-12 | US | Illinois | Brown | 17009 | 2717 | 17 | 0 | 39.96209138 | -90.75068024 | 2022-11-13 04:21:14 | Brown, Illinois, US | |
63858 | 63858 | 2022-11-12 | US | Georgia | Dooly | 13093 | 2717 | 74 | 0 | 32.15630737 | -83.79746561 | 2022-11-13 04:21:14 | Dooly, Georgia, US | |
2928193 | 2928193 | 2022-11-11 | US | Illinois | Brown | 17009 | 2717 | 17 | 0 | 39.96209138 | -90.75068024 | 2022-11-12 04:20:41 | Brown, Illinois, US | |
2928020 | 2928020 | 2022-11-11 | US | Georgia | Dooly | 13093 | 2717 | 74 | 0 | 32.15630737 | -83.79746561 | 2022-11-12 04:20:41 | Dooly, Georgia, US | |
2507029 | 2507029 | 2022-11-10 | US | Illinois | Brown | 17009 | 2717 | 17 | 0 | 39.96209138 | -90.75068024 | 2022-11-11 04:21:22 | Brown, Illinois, US | |
2506856 | 2506856 | 2022-11-10 | US | Georgia | Dooly | 13093 | 2717 | 74 | 0 | 32.15630737 | -83.79746561 | 2022-11-11 04:21:22 | Dooly, Georgia, US | |
2431904 | 2431904 | 2022-11-09 | US | Illinois | Brown | 17009 | 2717 | 17 | 0 | 39.96209138 | -90.75068024 | 2022-11-10 04:21:16 | Brown, Illinois, US | |
2431731 | 2431731 | 2022-11-09 | US | Georgia | Dooly | 13093 | 2717 | 74 | 0 | 32.15630737 | -83.79746561 | 2022-11-10 04:21:16 | Dooly, Georgia, US | |
480818 | 480818 | 2022-11-08 | US | Iowa | Mitchell | 19131 | 2717 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-09 04:21:22 | Mitchell, Iowa, US | |
480387 | 480387 | 2022-11-08 | US | Georgia | Dooly | 13093 | 2717 | 73 | 0 | 32.15630737 | -83.79746561 | 2022-11-09 04:21:22 | Dooly, Georgia, US | |
2439968 | 2439968 | 2022-11-07 | US | Iowa | Mitchell | 19131 | 2717 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-08 04:21:21 | Mitchell, Iowa, US | |
2439537 | 2439537 | 2022-11-07 | US | Georgia | Dooly | 13093 | 2717 | 73 | 0 | 32.15630737 | -83.79746561 | 2022-11-08 04:21:21 | Dooly, Georgia, US | |
1051066 | 1051066 | 2022-11-06 | US | Iowa | Mitchell | 19131 | 2717 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-07 04:21:26 | Mitchell, Iowa, US | |
1050635 | 1050635 | 2022-11-06 | US | Georgia | Dooly | 13093 | 2717 | 73 | 0 | 32.15630737 | -83.79746561 | 2022-11-07 04:21:26 | Dooly, Georgia, US | |
619090 | 619090 | 2022-11-05 | US | Iowa | Mitchell | 19131 | 2717 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-06 04:21:24 | Mitchell, Iowa, US | |
618659 | 618659 | 2022-11-05 | US | Georgia | Dooly | 13093 | 2717 | 73 | 0 | 32.15630737 | -83.79746561 | 2022-11-06 04:21:24 | Dooly, Georgia, US | |
1023594 | 1023594 | 2022-11-04 | US | Iowa | Mitchell | 19131 | 2717 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-05 04:21:52 | Mitchell, Iowa, US | |
1023163 | 1023163 | 2022-11-04 | US | Georgia | Dooly | 13093 | 2717 | 73 | 0 | 32.15630737 | -83.79746561 | 2022-11-05 04:21:52 | Dooly, Georgia, US | |
432585 | 432585 | 2022-11-03 | US | Iowa | Mitchell | 19131 | 2717 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-04 04:22:11 | Mitchell, Iowa, US | |
432154 | 432154 | 2022-11-03 | US | Georgia | Dooly | 13093 | 2717 | 73 | 0 | 32.15630737 | -83.79746561 | 2022-11-04 04:22:11 | Dooly, Georgia, US | |
850827 | 850827 | 2022-11-02 | US | Iowa | Mitchell | 19131 | 2717 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-11-03 04:22:05 | Mitchell, Iowa, US | |
850396 | 850396 | 2022-11-02 | US | Georgia | Dooly | 13093 | 2717 | 73 | 0 | 32.15630737 | -83.79746561 | 2022-11-03 04:22:05 | Dooly, Georgia, US | |
3041858 | 3041858 | 2022-10-27 | US | West Virginia | Webster | 54101 | 2717 | 37 | 0 | 38.49370949 | -80.4202023 | 2022-10-28 04:22:31 | Webster, West Virginia, US | |
2394599 | 2394599 | 2022-09-12 | China | Inner Mongolia | 2717 | 1 | 0 | 44.0935 | 113.9448 | 2022-09-13 04:20:57 | Inner Mongolia, China | |||
1251827 | 1251827 | 2022-08-23 | US | Indiana | Benton | 18007 | 2717 | 23 | 0 | 40.60626947 | -87.31093999 | 2022-08-24 04:20:46 | Benton, Indiana, US | |
2853931 | 2853931 | 2022-08-22 | US | Indiana | Benton | 18007 | 2717 | 23 | 0 | 40.60626947 | -87.31093999 | 2022-08-23 04:20:56 | Benton, Indiana, US | |
994451 | 994451 | 2022-08-16 | US | Washington | Pend Oreille | 53051 | 2717 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-08-17 04:20:59 | Pend Oreille, Washington, US | |
2497490 | 2497490 | 2022-08-15 | US | Washington | Pend Oreille | 53051 | 2717 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-08-16 04:20:58 | Pend Oreille, Washington, US | |
1610869 | 1610869 | 2022-07-20 | US | Oklahoma | Washita | 40149 | 2717 | 55 | 0 | 35.29071824 | -98.99180434 | 2022-07-21 04:21:10 | Washita, Oklahoma, US | |
961502 | 961502 | 2022-07-19 | US | Oklahoma | Washita | 40149 | 2717 | 55 | 0 | 35.29071824 | -98.99180434 | 2022-07-20 04:20:59 | Washita, Oklahoma, US | |
3212889 | 3212889 | 2022-07-18 | US | Oklahoma | Washita | 40149 | 2717 | 55 | 0 | 35.29071824 | -98.99180434 | 2022-07-19 04:20:58 | Washita, Oklahoma, US | |
3408064 | 3408064 | 2022-07-17 | US | Oklahoma | Washita | 40149 | 2717 | 55 | 0 | 35.29071824 | -98.99180434 | 2022-07-18 04:20:59 | Washita, Oklahoma, US | |
2154264 | 2154264 | 2022-07-16 | US | Oklahoma | Washita | 40149 | 2717 | 55 | 0 | 35.29071824 | -98.99180434 | 2022-07-17 04:21:15 | Washita, Oklahoma, US | |
2421497 | 2421497 | 2022-07-15 | US | Oklahoma | Washita | 40149 | 2717 | 55 | 0 | 35.29071824 | -98.99180434 | 2022-07-16 04:21:05 | Washita, Oklahoma, US | |
3432015 | 3432015 | 2022-07-14 | US | Texas | Childress | 48075 | 2717 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-07-15 04:20:53 | Childress, Texas, US | |
3431572 | 3431572 | 2022-07-14 | US | Oklahoma | Washita | 40149 | 2717 | 55 | 0 | 35.29071824 | -98.99180434 | 2022-07-15 04:20:53 | Washita, Oklahoma, US | |
3430992 | 3430992 | 2022-07-14 | US | Montana | Richland | 30083 | 2717 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-07-15 04:20:53 | Richland, Montana, US | |
3111512 | 3111512 | 2022-07-13 | US | Montana | Richland | 30083 | 2717 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-07-14 04:20:57 | Richland, Montana, US | |
631935 | 631935 | 2022-07-12 | US | Montana | Richland | 30083 | 2717 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-07-13 04:20:58 | Richland, Montana, US | |
1213579 | 1213579 | 2022-07-11 | US | Montana | Richland | 30083 | 2717 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-07-12 04:20:51 | Richland, Montana, US | |
2791061 | 2791061 | 2022-07-10 | US | Montana | Richland | 30083 | 2717 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-07-11 04:20:46 | Richland, Montana, US | |
144014 | 144014 | 2022-07-09 | US | Montana | Richland | 30083 | 2717 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-07-10 04:20:54 | Richland, Montana, US | |
1419114 | 1419114 | 2022-07-08 | US | Montana | Richland | 30083 | 2717 | 36 | 0 | 47.78668011 | -104.5610786 | 2022-07-09 04:20:59 | Richland, Montana, US | |
478781 | 478781 | 2022-06-26 | US | Virginia | Floyd | 51063 | 2717 | 49 | 0 | 36.9302126 | -80.36738849 | 2022-06-27 04:21:00 | Floyd, Virginia, US | |
942156 | 942156 | 2022-06-25 | US | Virginia | Floyd | 51063 | 2717 | 49 | 0 | 36.9302126 | -80.36738849 | 2022-06-26 04:21:02 | Floyd, Virginia, US | |
3349976 | 3349976 | 2022-06-24 | US | Virginia | Floyd | 51063 | 2717 | 49 | 0 | 36.9302126 | -80.36738849 | 2022-06-25 04:20:57 | Floyd, Virginia, US | |
169424 | 169424 | 2022-06-21 | US | Virginia | Nelson | 51125 | 2717 | 37 | 0 | 37.78790447 | -78.88498513 | 2022-06-22 04:20:54 | Nelson, Virginia, US | |
167544 | 167544 | 2022-06-21 | US | Louisiana | Catahoula | 22025 | 2717 | 55 | 0 | 31.66778967 | -91.84526385 | 2022-06-22 04:20:54 | Catahoula, Louisiana, US | |
3983259 | 3983259 | 2022-06-15 | US | Colorado | Prowers | 8099 | 2717 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-06-16 04:20:55 | Prowers, Colorado, US | |
947337 | 947337 | 2022-06-14 | US | Arkansas | Fulton | 5049 | 2717 | 93 | 0 | 36.38177105 | -91.81729127 | 2022-06-15 04:20:54 | Fulton, Arkansas, US | |
3536707 | 3536707 | 2022-05-10 | US | Iowa | Union | 19175 | 2717 | 51 | 0 | 41.0277278 | -94.24234847 | 2022-05-11 04:20:48 | Union, Iowa, US | |
223242 | 223242 | 2022-05-09 | US | Iowa | Union | 19175 | 2717 | 51 | 0 | 41.0277278 | -94.24234847 | 2022-05-10 04:20:50 | Union, Iowa, US | |
2333793 | 2333793 | 2022-05-08 | US | North Dakota | McLean | 38055 | 2717 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-05-09 04:20:54 | McLean, North Dakota, US | |
2332627 | 2332627 | 2022-05-08 | US | Iowa | Union | 19175 | 2717 | 51 | 0 | 41.0277278 | -94.24234847 | 2022-05-09 04:20:54 | Union, Iowa, US | |
362755 | 362755 | 2022-05-07 | US | North Dakota | McLean | 38055 | 2717 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-05-08 04:20:49 | McLean, North Dakota, US | |
361589 | 361589 | 2022-05-07 | US | Iowa | Union | 19175 | 2717 | 51 | 0 | 41.0277278 | -94.24234847 | 2022-05-08 04:20:49 | Union, Iowa, US | |
1398940 | 1398940 | 2022-05-06 | US | Iowa | Union | 19175 | 2717 | 51 | 0 | 41.0277278 | -94.24234847 | 2022-05-07 04:21:09 | Union, Iowa, US | |
2599295 | 2599295 | 2022-05-05 | US | Iowa | Union | 19175 | 2717 | 51 | 0 | 41.0277278 | -94.24234847 | 2022-05-06 04:21:00 | Union, Iowa, US | |
3266744 | 3266744 | 2022-05-04 | US | Iowa | Union | 19175 | 2717 | 51 | 0 | 41.0277278 | -94.24234847 | 2022-05-05 04:20:55 | Union, Iowa, US | |
2840646 | 2840646 | 2022-04-30 | China | Shandong | 2717 | 7 | 0 | 36.3427 | 118.1498 | 2022-05-01 04:20:57 | Shandong, China | |||
1697291 | 1697291 | 2022-04-28 | US | Idaho | Teton | 16081 | 2717 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-04-29 04:20:59 | Teton, Idaho, US | |
3852774 | 3852774 | 2022-04-27 | US | Idaho | Teton | 16081 | 2717 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-04-28 04:20:47 | Teton, Idaho, US | |
1579805 | 1579805 | 2022-04-10 | United Kingdom | Anguilla | 2717 | 9 | 0 | 18.2206 | -63.0686 | 2022-04-11 04:21:02 | Anguilla, United Kingdom | |||
1656047 | 1656047 | 2022-04-09 | United Kingdom | Anguilla | 2717 | 9 | 0 | 18.2206 | -63.0686 | 2022-04-10 04:20:52 | Anguilla, United Kingdom | |||
2119369 | 2119369 | 2022-04-08 | United Kingdom | Anguilla | 2717 | 9 | 0 | 18.2206 | -63.0686 | 2022-04-09 04:20:42 | Anguilla, United Kingdom | |||
3323893 | 3323893 | 2022-04-07 | United Kingdom | Anguilla | 2717 | 9 | 0 | 18.2206 | -63.0686 | 2022-04-08 04:20:48 | Anguilla, United Kingdom | |||
2804429 | 2804429 | 2022-04-06 | United Kingdom | Anguilla | 2717 | 9 | 0 | 18.2206 | -63.0686 | 2022-04-07 04:20:53 | Anguilla, United Kingdom | |||
3871198 | 3871198 | 2022-04-05 | United Kingdom | Anguilla | 2717 | 9 | 0 | 18.2206 | -63.0686 | 2022-04-06 04:20:49 | Anguilla, United Kingdom | |||
26236 | 26236 | 2022-03-20 | US | Mississippi | Noxubee | 28103 | 2717 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-03-21 04:20:50 | Noxubee, Mississippi, US | |
1658246 | 1658246 | 2022-03-19 | US | Mississippi | Noxubee | 28103 | 2717 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-03-20 04:20:45 | Noxubee, Mississippi, US | |
337772 | 337772 | 2022-03-18 | US | Mississippi | Noxubee | 28103 | 2717 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-03-19 04:20:47 | Noxubee, Mississippi, US | |
696225 | 696225 | 2022-03-17 | US | Mississippi | Noxubee | 28103 | 2717 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-03-18 04:20:55 | Noxubee, Mississippi, US | |
2321168 | 2321168 | 2022-03-16 | US | Mississippi | Noxubee | 28103 | 2717 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-03-17 04:20:56 | Noxubee, Mississippi, US | |
263368 | 263368 | 2022-03-15 | US | Mississippi | Noxubee | 28103 | 2717 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-03-16 04:20:50 | Noxubee, Mississippi, US | |
2265727 | 2265727 | 2022-03-14 | US | Mississippi | Noxubee | 28103 | 2717 | 48 | 0 | 33.11009499 | -88.56949061 | 2022-03-15 04:20:47 | Noxubee, Mississippi, US | |
1867538 | 1867538 | 2022-03-10 | US | Nebraska | Colfax | 31037 | 2717 | 21 | 0 | 41.57486951 | -97.0868542 | 2022-03-11 04:20:50 | Colfax, Nebraska, US | |
2142233 | 2142233 | 2022-03-09 | US | Nebraska | Colfax | 31037 | 2717 | 21 | 0 | 41.57486951 | -97.0868542 | 2022-03-10 04:20:48 | Colfax, Nebraska, US | |
1512428 | 1512428 | 2022-02-24 | US | Illinois | Marshall | 17123 | 2717 | 30 | 0 | 41.0327901 | -89.34510444 | 2022-02-25 04:21:11 | Marshall, Illinois, US | |
1060705 | 1060705 | 2022-02-23 | US | South Dakota | Butte | 46019 | 2717 | 44 | 0 | 44.90608745 | -103.5079318 | 2022-02-24 04:21:14 | Butte, South Dakota, US | |
1058687 | 1058687 | 2022-02-23 | US | Georgia | Long | 13183 | 2717 | 31 | 0 | 31.75218791 | -81.74952375 | 2022-02-24 04:21:14 | Long, Georgia, US | |
1467334 | 1467334 | 2022-02-10 | US | Texas | Ward | 48475 | 2717 | 42 | 0 | 31.50999644 | -103.09279090000001 | 2022-02-11 04:21:09 | Ward, 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]);