daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
238 rows where confirmed = 2934 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-16 | US | Arkansas | Perry | 5105 | 2934 | 42 | 0 | 34.9459153 | -92.94372564 | 2022-12-17 04:21:04 | Perry, Arkansas, US | |
2022-12-12 | US | Mississippi | Tunica | 28143 | 2934 | 49 | 0 | 34.64967704 | -90.37481167 | 2022-12-13 04:21:01 | Tunica, Mississippi, US | |
2022-12-11 | US | Mississippi | Tunica | 28143 | 2934 | 49 | 0 | 34.64967704 | -90.37481167 | 2022-12-12 04:21:01 | Tunica, Mississippi, US | |
2022-12-10 | US | Mississippi | Tunica | 28143 | 2934 | 49 | 0 | 34.64967704 | -90.37481167 | 2022-12-11 04:20:50 | Tunica, Mississippi, US | |
2022-12-09 | US | Mississippi | Tunica | 28143 | 2934 | 49 | 0 | 34.64967704 | -90.37481167 | 2022-12-10 04:21:02 | Tunica, Mississippi, US | |
2022-12-08 | US | Mississippi | Tunica | 28143 | 2934 | 49 | 0 | 34.64967704 | -90.37481167 | 2022-12-09 04:21:05 | Tunica, Mississippi, US | |
2022-12-07 | US | Mississippi | Tunica | 28143 | 2934 | 49 | 0 | 34.64967704 | -90.37481167 | 2022-12-08 04:21:07 | Tunica, Mississippi, US | |
2022-12-06 | US | Mississippi | Tunica | 28143 | 2934 | 49 | 0 | 34.64967704 | -90.37481167 | 2022-12-07 04:20:58 | Tunica, Mississippi, US | |
2022-11-17 | US | Puerto Rico | Ceiba | 72037 | 2934 | 0 | 0 | 18.251818 | -65.666416 | 2022-11-18 04:21:15 | Ceiba, Puerto Rico, US | |
2022-11-16 | US | Puerto Rico | Ceiba | 72037 | 2934 | 0 | 0 | 18.251818 | -65.666416 | 2022-11-17 04:21:11 | Ceiba, Puerto Rico, US | |
2022-11-01 | US | Puerto Rico | Maunabo | 72095 | 2934 | 0 | 0 | 18.017889 | -65.922235 | 2022-11-02 04:22:09 | Maunabo, Puerto Rico, US | |
2022-10-31 | US | Puerto Rico | Maunabo | 72095 | 2934 | 0 | 0 | 18.017889 | -65.922235 | 2022-11-01 04:22:36 | Maunabo, Puerto Rico, US | |
2022-09-26 | US | Colorado | Prowers | 8099 | 2934 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-09-27 04:23:01 | Prowers, Colorado, US | |
2022-09-05 | US | Tennessee | Lake | 47095 | 2934 | 44 | 0 | 36.3418017 | -89.48921915 | 2022-09-06 04:21:02 | Lake, Tennessee, US | |
2022-08-30 | China | Shandong | 2934 | 7 | 0 | 36.3427 | 118.1498 | 2022-08-31 04:20:57 | Shandong, China | |||
2022-08-25 | US | Missouri | Ripley | 29181 | 2934 | 63 | 0 | 36.65460667 | -90.85990261 | 2022-08-26 04:21:02 | Ripley, Missouri, US | |
2022-08-25 | US | Louisiana | Catahoula | 22025 | 2934 | 59 | 0 | 31.66778967 | -91.84526385 | 2022-08-26 04:21:02 | Catahoula, Louisiana, US | |
2022-08-24 | US | Missouri | Ripley | 29181 | 2934 | 63 | 0 | 36.65460667 | -90.85990261 | 2022-08-25 04:21:13 | Ripley, Missouri, US | |
2022-08-23 | US | Missouri | Ripley | 29181 | 2934 | 63 | 0 | 36.65460667 | -90.85990261 | 2022-08-24 04:20:46 | Ripley, Missouri, US | |
2022-08-22 | US | Missouri | Ripley | 29181 | 2934 | 63 | 0 | 36.65460667 | -90.85990261 | 2022-08-23 04:20:56 | Ripley, Missouri, US | |
2022-08-21 | US | Missouri | Ripley | 29181 | 2934 | 63 | 0 | 36.65460667 | -90.85990261 | 2022-08-22 04:20:38 | Ripley, Missouri, US | |
2022-08-21 | US | Kentucky | Wolfe | 21237 | 2934 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-08-22 04:20:38 | Wolfe, Kentucky, US | |
2022-08-20 | US | Missouri | Ripley | 29181 | 2934 | 63 | 0 | 36.65460667 | -90.85990261 | 2022-08-21 04:20:44 | Ripley, Missouri, US | |
2022-08-20 | US | Kentucky | Wolfe | 21237 | 2934 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-08-21 04:20:44 | Wolfe, Kentucky, US | |
2022-08-19 | US | Missouri | Ripley | 29181 | 2934 | 63 | 0 | 36.65460667 | -90.85990261 | 2022-08-20 04:21:01 | Ripley, Missouri, US | |
2022-08-19 | US | Kentucky | Wolfe | 21237 | 2934 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-08-20 04:21:01 | Wolfe, Kentucky, US | |
2022-08-18 | US | Kentucky | Wolfe | 21237 | 2934 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-08-19 04:20:54 | Wolfe, Kentucky, US | |
2022-08-17 | US | Kentucky | Wolfe | 21237 | 2934 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-08-18 04:21:11 | Wolfe, Kentucky, US | |
2022-08-16 | US | Kentucky | Wolfe | 21237 | 2934 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-08-17 04:20:59 | Wolfe, Kentucky, US | |
2022-08-15 | US | Kentucky | Wolfe | 21237 | 2934 | 29 | 0 | 37.73941626 | -83.49303612 | 2022-08-16 04:20:58 | Wolfe, Kentucky, US | |
2022-08-15 | US | Illinois | Jasper | 17079 | 2934 | 31 | 0 | 39.01054275 | -88.15437049 | 2022-08-16 04:20:58 | Jasper, Illinois, US | |
2022-07-19 | US | Texas | Ward | 48475 | 2934 | 45 | 0 | 31.50999644 | -103.0927909 | 2022-07-20 04:20:59 | Ward, Texas, US | |
2022-06-22 | US | Louisiana | West Feliciana | 22125 | 2934 | 46 | 0 | 30.87882871 | -91.4148538 | 2022-06-23 04:20:55 | West Feliciana, Louisiana, US | |
2022-06-19 | US | Kentucky | Metcalfe | 21169 | 2934 | 65 | 0 | 36.99459295 | -85.63123699 | 2022-06-20 04:21:01 | Metcalfe, Kentucky, US | |
2022-06-18 | US | Kentucky | Metcalfe | 21169 | 2934 | 65 | 0 | 36.99459295 | -85.63123699 | 2022-06-19 04:20:51 | Metcalfe, Kentucky, US | |
2022-06-17 | US | Kentucky | Metcalfe | 21169 | 2934 | 65 | 0 | 36.99459295 | -85.63123699 | 2022-06-18 04:21:10 | Metcalfe, Kentucky, US | |
2022-06-16 | US | Kentucky | Metcalfe | 21169 | 2934 | 65 | 0 | 36.99459295 | -85.63123699 | 2022-06-17 04:20:56 | Metcalfe, Kentucky, US | |
2022-06-15 | US | Kentucky | Metcalfe | 21169 | 2934 | 65 | 0 | 36.99459295 | -85.63123699 | 2022-06-16 04:20:55 | Metcalfe, Kentucky, US | |
2022-06-14 | US | Kentucky | Metcalfe | 21169 | 2934 | 65 | 0 | 36.99459295 | -85.63123699 | 2022-06-15 04:20:54 | Metcalfe, Kentucky, US | |
2022-06-13 | US | Kentucky | Metcalfe | 21169 | 2934 | 65 | 0 | 36.99459295 | -85.63123699 | 2022-06-14 04:20:52 | Metcalfe, Kentucky, US | |
2022-05-23 | US | Texas | Callahan | 48059 | 2934 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-05-24 04:20:57 | Callahan, Texas, US | |
2022-05-03 | US | South Dakota | Charles Mix | 46023 | 2934 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-05-04 04:20:59 | Charles Mix, South Dakota, US | |
2022-05-02 | US | South Dakota | Charles Mix | 46023 | 2934 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-05-03 04:21:00 | Charles Mix, South Dakota, US | |
2022-05-01 | US | South Dakota | Charles Mix | 46023 | 2934 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-05-02 04:21:10 | Charles Mix, South Dakota, US | |
2022-04-30 | US | South Dakota | Charles Mix | 46023 | 2934 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-05-01 04:20:57 | Charles Mix, South Dakota, US | |
2022-04-29 | US | South Dakota | Charles Mix | 46023 | 2934 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-04-30 04:21:05 | Charles Mix, South Dakota, US | |
2022-04-28 | US | South Dakota | Charles Mix | 46023 | 2934 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-04-29 04:20:59 | Charles Mix, South Dakota, US | |
2022-04-27 | US | South Dakota | Charles Mix | 46023 | 2934 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-04-28 04:20:47 | Charles Mix, South Dakota, US | |
2022-04-18 | US | Puerto Rico | Villalba | 72149 | 2934 | 0 | 0 | 18.127951 | -66.473115 | 2022-04-19 04:21:00 | Villalba, Puerto Rico, US | |
2022-04-14 | US | Colorado | Park | 8093 | 2934 | 20 | 0 | 39.120926000000004 | -105.7182065 | 2022-04-15 04:20:57 | Park, Colorado, US | |
2022-03-27 | US | Washington | Jefferson | 53031 | 2934 | 28 | 0 | 47.75003077 | -123.56097040000002 | 2022-03-28 04:20:33 | Jefferson, Washington, US | |
2022-03-26 | US | Washington | Jefferson | 53031 | 2934 | 28 | 0 | 47.75003077 | -123.56097040000002 | 2022-03-27 04:20:47 | Jefferson, Washington, US | |
2022-03-25 | US | Washington | Jefferson | 53031 | 2934 | 28 | 0 | 47.75003077 | -123.56097040000002 | 2022-03-26 04:20:23 | Jefferson, Washington, US | |
2022-03-21 | US | Minnesota | Aitkin | 27001 | 2934 | 60 | 0 | 46.60962049 | -93.41168259999999 | 2022-03-22 04:20:54 | Aitkin, Minnesota, US | |
2022-03-16 | US | North Carolina | Alleghany | 37005 | 2934 | 12 | 0 | 36.49360862 | -81.12857041 | 2022-03-17 04:20:56 | Alleghany, North Carolina, US | |
2022-03-15 | US | North Carolina | Alleghany | 37005 | 2934 | 12 | 0 | 36.49360862 | -81.12857041 | 2022-03-16 04:20:50 | Alleghany, North Carolina, US | |
2022-03-14 | US | North Carolina | Alleghany | 37005 | 2934 | 12 | 0 | 36.49360862 | -81.12857041 | 2022-03-15 04:20:47 | Alleghany, North Carolina, US | |
2022-03-14 | US | Alabama | Coosa | 1037 | 2934 | 56 | 0 | 32.93690146 | -86.24847739 | 2022-03-15 04:20:47 | Coosa, Alabama, US | |
2022-03-13 | US | Idaho | Idaho | 16049 | 2934 | 51 | 0 | 45.84721541 | -115.4634436 | 2022-03-14 04:20:46 | Idaho, Idaho, US | |
2022-03-12 | US | Idaho | Idaho | 16049 | 2934 | 51 | 0 | 45.84721541 | -115.4634436 | 2022-03-13 04:20:49 | Idaho, Idaho, US | |
2022-03-11 | US | Idaho | Idaho | 16049 | 2934 | 51 | 0 | 45.84721541 | -115.4634436 | 2022-03-12 04:20:50 | Idaho, Idaho, US | |
2022-03-01 | US | Iowa | Cass | 19029 | 2934 | 75 | 0 | 41.33149454 | -94.92792482 | 2022-03-02 04:21:07 | Cass, Iowa, US | |
2022-02-28 | US | Iowa | Cass | 19029 | 2934 | 75 | 0 | 41.33149454 | -94.92792482 | 2022-03-01 04:21:09 | Cass, Iowa, US | |
2022-02-27 | US | Iowa | Cass | 19029 | 2934 | 75 | 0 | 41.33149454 | -94.92792482 | 2022-02-28 04:21:05 | Cass, Iowa, US | |
2022-02-26 | US | Iowa | Cass | 19029 | 2934 | 75 | 0 | 41.33149454 | -94.92792482 | 2022-02-27 04:21:04 | Cass, Iowa, US | |
2022-02-25 | US | Iowa | Cass | 19029 | 2934 | 75 | 0 | 41.33149454 | -94.92792482 | 2022-02-26 04:21:12 | Cass, Iowa, US | |
2022-02-24 | US | Iowa | Cass | 19029 | 2934 | 75 | 0 | 41.33149454 | -94.92792482 | 2022-02-25 04:21:11 | Cass, Iowa, US | |
2022-02-23 | US | Iowa | Cass | 19029 | 2934 | 75 | 0 | 41.33149454 | -94.92792482 | 2022-02-24 04:21:14 | Cass, Iowa, US | |
2022-02-22 | US | Iowa | Cherokee | 19035 | 2934 | 58 | 0 | 42.73538914 | -95.62389402 | 2022-02-23 04:21:09 | Cherokee, Iowa, US | |
2022-02-21 | US | Iowa | Cherokee | 19035 | 2934 | 58 | 0 | 42.73538914 | -95.62389402 | 2022-02-22 04:21:01 | Cherokee, Iowa, US | |
2022-02-20 | US | Iowa | Cherokee | 19035 | 2934 | 58 | 0 | 42.73538914 | -95.62389402 | 2022-02-21 04:21:05 | Cherokee, Iowa, US | |
2022-02-19 | US | North Dakota | Barnes | 38003 | 2934 | 46 | 0 | 46.93579637 | -98.06605978 | 2022-02-20 04:21:00 | Barnes, North Dakota, US | |
2022-02-19 | US | Iowa | Cherokee | 19035 | 2934 | 58 | 0 | 42.73538914 | -95.62389402 | 2022-02-20 04:21:00 | Cherokee, Iowa, US | |
2022-02-18 | US | North Dakota | Barnes | 38003 | 2934 | 46 | 0 | 46.93579637 | -98.06605978 | 2022-02-19 04:21:11 | Barnes, North Dakota, US | |
2022-02-18 | US | Iowa | Cherokee | 19035 | 2934 | 58 | 0 | 42.73538914 | -95.62389402 | 2022-02-19 04:21:11 | Cherokee, Iowa, US | |
2022-02-17 | US | North Dakota | Barnes | 38003 | 2934 | 46 | 0 | 46.93579637 | -98.06605978 | 2022-02-18 04:21:04 | Barnes, North Dakota, US | |
2022-02-17 | US | Montana | Custer | 30017 | 2934 | 46 | 0 | 46.25319932 | -105.57375259999998 | 2022-02-18 04:21:04 | Custer, Montana, US | |
2022-02-17 | US | Iowa | Cherokee | 19035 | 2934 | 58 | 0 | 42.73538914 | -95.62389402 | 2022-02-18 04:21:04 | Cherokee, Iowa, US | |
2022-02-16 | US | Iowa | Cherokee | 19035 | 2934 | 58 | 0 | 42.73538914 | -95.62389402 | 2022-02-17 04:20:56 | Cherokee, Iowa, US | |
2022-02-12 | US | Puerto Rico | Loiza | 72087 | 2934 | 0 | 0 | 18.425688 | -65.89943000000001 | 2022-02-13 04:21:00 | Loiza, Puerto Rico, US | |
2022-02-04 | US | Texas | Nolan | 48353 | 2934 | 90 | 0 | 32.30365282 | -100.4060208 | 2022-02-05 04:21:05 | Nolan, Texas, US | |
2022-02-03 | US | Texas | Nolan | 48353 | 2934 | 90 | 0 | 32.30365282 | -100.4060208 | 2022-02-04 04:21:10 | Nolan, Texas, US | |
2022-02-01 | US | Maryland | Kent | 24029 | 2934 | 64 | 0 | 39.24976208 | -76.04741541 | 2022-02-02 04:21:09 | Kent, Maryland, US | |
2022-01-22 | US | Tennessee | Meigs | 47121 | 2934 | 47 | 0 | 35.51558739 | -84.81482914 | 2022-01-23 04:21:13 | Meigs, Tennessee, US | |
2022-01-13 | US | Puerto Rico | Aguas Buenas | 72007 | 2934 | 0 | 0 | 18.251619 | -66.126806 | 2022-01-14 04:21:54 | Aguas Buenas, Puerto Rico, US | |
2022-01-02 | US | West Virginia | Taylor | 54091 | 2934 | 51 | 0 | 39.33602617 | -80.0421439 | 2022-01-03 02:22:25 | Taylor, West Virginia, US | |
2022-01-01 | US | West Virginia | Taylor | 54091 | 2934 | 51 | 0 | 39.33602617 | -80.0421439 | 2022-01-02 04:20:52 | Taylor, West Virginia, US | |
2021-12-31 | US | West Virginia | Taylor | 54091 | 2934 | 51 | 0 | 39.33602617 | -80.0421439 | 2022-01-01 04:22:14 | Taylor, West Virginia, US | |
2021-12-30 | US | West Virginia | Taylor | 54091 | 2934 | 51 | 0 | 39.33602617 | -80.0421439 | 2021-12-31 04:21:50 | Taylor, West Virginia, US | |
2021-12-21 | US | Puerto Rico | Dorado | 72051 | 2934 | 0 | 0 | 18.436115 | -66.278669 | 2021-12-22 04:21:54 | Dorado, Puerto Rico, US | |
2021-12-20 | US | Tennessee | Cannon | 47015 | 2934 | 45 | 0 | 35.80990797 | -86.05738983 | 2021-12-21 03:21:27 | Cannon, Tennessee, US | |
2021-12-16 | US | Kentucky | Casey | 21045 | 2934 | 61 | 0 | 37.32533118 | -84.92726209 | 2021-12-17 04:22:14 | Casey, Kentucky, US | |
2021-12-14 | US | North Dakota | Richland | 38077 | 2934 | 21 | 0 | 46.26440649 | -96.94852979 | 2021-12-15 03:22:16 | Richland, North Dakota, US | |
2021-12-14 | US | Minnesota | Redwood | 27127 | 2934 | 46 | 0 | 44.40555844 | -95.25207021 | 2021-12-15 03:22:16 | Redwood, Minnesota, US | |
2021-12-07 | US | Iowa | Kossuth | 19109 | 2934 | 77 | 0 | 43.20405458 | -94.20691791 | 2021-12-08 04:22:46 | Kossuth, Iowa, US | |
2021-12-06 | US | Iowa | Kossuth | 19109 | 2934 | 77 | 0 | 43.20405458 | -94.20691791 | 2021-12-07 04:22:34 | Kossuth, Iowa, US | |
2021-12-05 | US | Iowa | Kossuth | 19109 | 2934 | 77 | 0 | 43.20405458 | -94.20691791 | 2021-12-06 04:22:34 | Kossuth, Iowa, US | |
2021-12-05 | US | Arkansas | Grant | 5053 | 2934 | 50 | 0 | 34.29017991 | -92.42320562 | 2021-12-06 04:22:34 | Grant, Arkansas, US | |
2021-12-04 | US | Pennsylvania | Montour | 42093 | 2934 | 75 | 0 | 41.03023987 | -76.66345939 | 2021-12-05 04:22:25 | Montour, Pennsylvania, US | |
2021-12-04 | US | Iowa | Kossuth | 19109 | 2934 | 77 | 0 | 43.20405458 | -94.20691791 | 2021-12-05 04:22:25 | Kossuth, Iowa, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;