daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
181 rows where confirmed = 4342 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Texas | Colorado | 48089 | 4342 | 68 | 0 | 29.622098 | -96.5273805 | 2022-12-30 04:21:04 | Colorado, Texas, US | |
2022-12-28 | US | Texas | Colorado | 48089 | 4342 | 68 | 0 | 29.622098 | -96.5273805 | 2022-12-29 04:21:01 | Colorado, Texas, US | |
2022-12-22 | US | Tennessee | Decatur | 47039 | 4342 | 72 | 0 | 35.60048904 | -88.11043779 | 2022-12-23 04:21:04 | Decatur, Tennessee, US | |
2022-11-09 | US | Mississippi | Walthall | 28147 | 4342 | 83 | 0 | 31.14971548 | -90.10446654 | 2022-11-10 04:21:16 | Walthall, Mississippi, US | |
2022-11-08 | US | Mississippi | Walthall | 28147 | 4342 | 83 | 0 | 31.14971548 | -90.10446654 | 2022-11-09 04:21:22 | Walthall, Mississippi, US | |
2022-11-07 | US | Mississippi | Walthall | 28147 | 4342 | 83 | 0 | 31.14971548 | -90.10446654 | 2022-11-08 04:21:21 | Walthall, Mississippi, US | |
2022-11-06 | US | Mississippi | Walthall | 28147 | 4342 | 83 | 0 | 31.14971548 | -90.10446654 | 2022-11-07 04:21:26 | Walthall, Mississippi, US | |
2022-11-05 | US | Mississippi | Walthall | 28147 | 4342 | 83 | 0 | 31.14971548 | -90.10446654 | 2022-11-06 04:21:24 | Walthall, Mississippi, US | |
2022-11-04 | US | Mississippi | Walthall | 28147 | 4342 | 83 | 0 | 31.14971548 | -90.10446654 | 2022-11-05 04:21:52 | Walthall, Mississippi, US | |
2022-11-03 | US | Mississippi | Walthall | 28147 | 4342 | 83 | 0 | 31.14971548 | -90.10446654 | 2022-11-04 04:22:11 | Walthall, Mississippi, US | |
2022-11-02 | US | Mississippi | Walthall | 28147 | 4342 | 83 | 0 | 31.14971548 | -90.10446654 | 2022-11-03 04:22:05 | Walthall, Mississippi, US | |
2022-11-01 | US | Louisiana | West Carroll | 22123 | 4342 | 71 | 0 | 32.78550125 | -91.461201 | 2022-11-02 04:22:09 | West Carroll, Louisiana, US | |
2022-10-31 | US | Louisiana | West Carroll | 22123 | 4342 | 71 | 0 | 32.78550125 | -91.461201 | 2022-11-01 04:22:36 | West Carroll, Louisiana, US | |
2022-10-30 | US | Louisiana | West Carroll | 22123 | 4342 | 71 | 0 | 32.78550125 | -91.461201 | 2022-10-31 04:21:36 | West Carroll, Louisiana, US | |
2022-10-29 | US | Louisiana | West Carroll | 22123 | 4342 | 71 | 0 | 32.78550125 | -91.461201 | 2022-10-30 04:22:14 | West Carroll, Louisiana, US | |
2022-10-28 | US | Louisiana | West Carroll | 22123 | 4342 | 71 | 0 | 32.78550125 | -91.461201 | 2022-10-29 04:21:13 | West Carroll, Louisiana, US | |
2022-10-27 | US | Louisiana | West Carroll | 22123 | 4342 | 71 | 0 | 32.78550125 | -91.461201 | 2022-10-28 04:22:31 | West Carroll, Louisiana, US | |
2022-10-26 | US | Louisiana | West Carroll | 22123 | 4342 | 71 | 0 | 32.78550125 | -91.461201 | 2022-10-27 04:22:01 | West Carroll, Louisiana, US | |
2022-10-25 | US | Kansas | Jackson | 20085 | 4342 | 37 | 0 | 39.41673394 | -95.79356799 | 2022-10-26 04:22:19 | Jackson, Kansas, US | |
2022-10-24 | US | Kansas | Jackson | 20085 | 4342 | 37 | 0 | 39.41673394 | -95.79356799 | 2022-10-25 04:21:53 | Jackson, Kansas, US | |
2022-10-23 | US | Kansas | Jackson | 20085 | 4342 | 37 | 0 | 39.41673394 | -95.79356799 | 2022-10-24 04:22:29 | Jackson, Kansas, US | |
2022-10-22 | US | Kansas | Jackson | 20085 | 4342 | 37 | 0 | 39.41673394 | -95.79356799 | 2022-10-23 04:22:46 | Jackson, Kansas, US | |
2022-10-21 | US | Kansas | Jackson | 20085 | 4342 | 37 | 0 | 39.41673394 | -95.79356799 | 2022-10-22 04:22:53 | Jackson, Kansas, US | |
2022-10-20 | US | Kansas | Jackson | 20085 | 4342 | 37 | 0 | 39.41673394 | -95.79356799 | 2022-10-21 04:22:23 | Jackson, Kansas, US | |
2022-10-19 | US | Kansas | Jackson | 20085 | 4342 | 37 | 0 | 39.41673394 | -95.79356799 | 2022-10-20 04:22:59 | Jackson, Kansas, US | |
2022-10-09 | US | Puerto Rico | Hormigueros | 72067 | 4342 | 0 | 0 | 18.134532 | -67.113972 | 2022-10-10 04:22:32 | Hormigueros, Puerto Rico, US | |
2022-09-22 | US | California | Unassigned | 90006 | 4342 | 1 | 0 | 41.74228275 | 0.0 | 2022-09-23 04:23:13 | Unassigned, California, US | |
2022-08-18 | US | Puerto Rico | Luquillo | 72089 | 4342 | 0 | 0 | 18.342114 | -65.725097 | 2022-08-19 04:20:54 | Luquillo, Puerto Rico, US | |
2022-08-07 | US | Arkansas | Polk | 5113 | 4342 | 151 | 0 | 34.48254879 | -94.22728802 | 2022-08-08 04:21:08 | Polk, Arkansas, US | |
2022-08-04 | US | Arkansas | Madison | 5087 | 4342 | 65 | 0 | 36.01038185 | -93.72524943 | 2022-08-05 04:20:52 | Madison, Arkansas, US | |
2022-07-27 | US | Utah | San Juan | 49037 | 4342 | 50 | 0 | 37.62762978 | -109.8033714 | 2022-07-28 04:20:56 | San Juan, Utah, US | |
2022-07-26 | US | Utah | San Juan | 49037 | 4342 | 50 | 0 | 37.62762978 | -109.8033714 | 2022-07-27 04:21:04 | San Juan, Utah, US | |
2022-07-25 | US | Utah | San Juan | 49037 | 4342 | 50 | 0 | 37.62762978 | -109.8033714 | 2022-07-26 04:20:58 | San Juan, Utah, US | |
2022-07-24 | US | Utah | San Juan | 49037 | 4342 | 50 | 0 | 37.62762978 | -109.8033714 | 2022-07-25 04:20:51 | San Juan, Utah, US | |
2022-07-24 | US | Illinois | Moultrie | 17139 | 4342 | 47 | 0 | 39.64187451 | -88.62099969 | 2022-07-25 04:20:51 | Moultrie, Illinois, US | |
2022-07-23 | US | Utah | San Juan | 49037 | 4342 | 50 | 0 | 37.62762978 | -109.8033714 | 2022-07-24 04:20:47 | San Juan, Utah, US | |
2022-07-23 | US | Illinois | Moultrie | 17139 | 4342 | 47 | 0 | 39.64187451 | -88.62099969 | 2022-07-24 04:20:47 | Moultrie, Illinois, US | |
2022-07-22 | US | Utah | San Juan | 49037 | 4342 | 50 | 0 | 37.62762978 | -109.8033714 | 2022-07-23 04:20:53 | San Juan, Utah, US | |
2022-07-22 | US | Illinois | Moultrie | 17139 | 4342 | 47 | 0 | 39.64187451 | -88.62099969 | 2022-07-23 04:20:53 | Moultrie, Illinois, US | |
2022-07-21 | US | Utah | San Juan | 49037 | 4342 | 50 | 0 | 37.62762978 | -109.8033714 | 2022-07-22 04:21:15 | San Juan, Utah, US | |
2022-07-17 | US | Wisconsin | Washburn | 55129 | 4342 | 46 | 0 | 45.89838588 | -91.79050449 | 2022-07-18 04:20:59 | Washburn, Wisconsin, US | |
2022-07-16 | US | Wisconsin | Washburn | 55129 | 4342 | 46 | 0 | 45.89838588 | -91.79050449 | 2022-07-17 04:21:15 | Washburn, Wisconsin, US | |
2022-07-15 | US | Wisconsin | Washburn | 55129 | 4342 | 46 | 0 | 45.89838588 | -91.79050449 | 2022-07-16 04:21:05 | Washburn, Wisconsin, US | |
2022-07-13 | US | Illinois | Warren | 17187 | 4342 | 86 | 0 | 40.84925021 | -90.6147432 | 2022-07-14 04:20:57 | Warren, Illinois, US | |
2022-07-10 | US | Tennessee | Trousdale | 47169 | 4342 | 46 | 0 | 36.39026213 | -86.16087954 | 2022-07-11 04:20:46 | Trousdale, Tennessee, US | |
2022-07-09 | US | Tennessee | Trousdale | 47169 | 4342 | 46 | 0 | 36.39026213 | -86.16087954 | 2022-07-10 04:20:54 | Trousdale, Tennessee, US | |
2022-06-28 | US | Illinois | Jo Daviess | 17085 | 4342 | 36 | 0 | 42.36542373 | -90.21094405 | 2022-06-29 04:20:59 | Jo Daviess, Illinois, US | |
2022-06-21 | US | Iowa | Cedar | 19031 | 4342 | 35 | 0 | 41.77233777 | -91.13246684 | 2022-06-22 04:20:54 | Cedar, Iowa, US | |
2022-06-20 | US | Iowa | Cedar | 19031 | 4342 | 35 | 0 | 41.77233777 | -91.13246684 | 2022-06-21 04:20:56 | Cedar, Iowa, US | |
2022-06-19 | US | Iowa | Cedar | 19031 | 4342 | 35 | 0 | 41.77233777 | -91.13246684 | 2022-06-20 04:21:01 | Cedar, Iowa, US | |
2022-06-18 | US | Iowa | Cedar | 19031 | 4342 | 35 | 0 | 41.77233777 | -91.13246684 | 2022-06-19 04:20:51 | Cedar, Iowa, US | |
2022-06-17 | US | Iowa | Cedar | 19031 | 4342 | 35 | 0 | 41.77233777 | -91.13246684 | 2022-06-18 04:21:10 | Cedar, Iowa, US | |
2022-06-16 | US | Iowa | Cedar | 19031 | 4342 | 35 | 0 | 41.77233777 | -91.13246684 | 2022-06-17 04:20:56 | Cedar, Iowa, US | |
2022-06-15 | US | Iowa | Cedar | 19031 | 4342 | 35 | 0 | 41.77233777 | -91.13246684 | 2022-06-16 04:20:55 | Cedar, Iowa, US | |
2022-05-30 | US | West Virginia | Monroe | 54063 | 4342 | 46 | 0 | 37.56274716 | -80.54577965 | 2022-05-31 04:20:51 | Monroe, West Virginia, US | |
2022-05-29 | US | West Virginia | Monroe | 54063 | 4342 | 46 | 0 | 37.56274716 | -80.54577965 | 2022-05-30 04:20:50 | Monroe, West Virginia, US | |
2022-05-28 | US | West Virginia | Monroe | 54063 | 4342 | 46 | 0 | 37.56274716 | -80.54577965 | 2022-05-29 04:20:53 | Monroe, West Virginia, US | |
2022-05-27 | US | West Virginia | Monroe | 54063 | 4342 | 46 | 0 | 37.56274716 | -80.54577965 | 2022-05-28 04:21:07 | Monroe, West Virginia, US | |
2022-04-26 | US | Illinois | Bond | 17005 | 4342 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-04-27 04:20:52 | Bond, Illinois, US | |
2022-04-19 | US | Texas | Lamb | 48279 | 4342 | 122 | 0 | 34.06859623 | -102.35162890000001 | 2022-04-20 04:20:45 | Lamb, Texas, US | |
2022-03-13 | US | Alaska | Northwest Arctic | 2188 | 4342 | 14 | 0 | 67.04919196 | -159.7503946 | 2022-03-14 04:20:46 | Northwest Arctic, Alaska, US | |
2022-03-12 | US | Alaska | Northwest Arctic | 2188 | 4342 | 14 | 0 | 67.04919196 | -159.7503946 | 2022-03-13 04:20:49 | Northwest Arctic, Alaska, US | |
2022-03-11 | US | Alaska | Northwest Arctic | 2188 | 4342 | 14 | 0 | 67.04919196 | -159.7503946 | 2022-03-12 04:20:50 | Northwest Arctic, Alaska, US | |
2022-03-03 | US | Georgia | Washington | 13303 | 4342 | 132 | 0 | 32.96711864 | -82.79357039 | 2022-03-04 04:21:09 | Washington, Georgia, US | |
2022-02-26 | US | Texas | Shelby | 48419 | 4342 | 126 | 0 | 31.79211404 | -94.14550696 | 2022-02-27 04:21:04 | Shelby, Texas, US | |
2022-02-09 | US | Montana | Big Horn | 30003 | 4342 | 89 | 0 | 45.42335905 | -107.492347 | 2022-02-10 04:21:14 | Big Horn, Montana, US | |
2022-02-04 | US | Texas | Jones | 48253 | 4342 | 86 | 0 | 32.73997145 | -99.87861576 | 2022-02-05 04:21:05 | Jones, Texas, US | |
2022-02-04 | US | Texas | Gonzales | 48177 | 4342 | 92 | 0 | 29.45634206 | -97.49424032 | 2022-02-05 04:21:05 | Gonzales, Texas, US | |
2022-02-04 | US | Puerto Rico | Naranjito | 72105 | 4342 | 0 | 0 | 18.288019 | -66.252703 | 2022-02-05 04:21:05 | Naranjito, Puerto Rico, US | |
2022-02-01 | US | North Carolina | Madison | 37115 | 4342 | 74 | 0 | 35.85402722 | -82.71346418 | 2022-02-02 04:21:09 | Madison, North Carolina, US | |
2022-01-18 | US | Texas | Scurry | 48415 | 4342 | 95 | 0 | 32.74613808 | -100.91626640000001 | 2022-01-19 04:21:23 | Scurry, Texas, US | |
2022-01-17 | US | Minnesota | Dodge | 27039 | 4342 | 14 | 0 | 44.02238415 | -92.86244324 | 2022-01-18 04:21:04 | Dodge, Minnesota, US | |
2022-01-16 | US | Minnesota | Dodge | 27039 | 4342 | 14 | 0 | 44.02238415 | -92.86244324 | 2022-01-17 04:21:08 | Dodge, Minnesota, US | |
2022-01-15 | US | Minnesota | Dodge | 27039 | 4342 | 14 | 0 | 44.02238415 | -92.86244324 | 2022-01-16 04:21:12 | Dodge, Minnesota, US | |
2022-01-14 | US | Minnesota | Dodge | 27039 | 4342 | 14 | 0 | 44.02238415 | -92.86244324 | 2022-01-15 04:21:07 | Dodge, Minnesota, US | |
2021-12-30 | US | Virginia | Salem | 51775 | 4342 | 83 | 0 | 37.2836193 | -80.06219455 | 2021-12-31 04:21:50 | Salem, Virginia, US | |
2021-12-22 | US | Puerto Rico | Arecibo | 72013 | 4342 | 0 | 0 | 18.406631 | -66.675077 | 2021-12-23 04:21:21 | Arecibo, Puerto Rico, US | |
2021-12-21 | US | Tennessee | Smith | 47159 | 4342 | 55 | 0 | 36.25359775 | -85.95411046 | 2021-12-22 04:21:54 | Smith, Tennessee, US | |
2021-12-21 | US | Louisiana | Union | 22111 | 4342 | 112 | 0 | 32.83121059 | -92.3749373 | 2021-12-22 04:21:54 | Union, Louisiana, US | |
2021-12-08 | US | Mississippi | Sunflower | 28133 | 4342 | 106 | 0 | 33.60192578 | -90.58882684 | 2021-12-09 04:22:49 | Sunflower, Mississippi, US | |
2021-12-03 | US | Ohio | Henry | 39069 | 4342 | 83 | 0 | 41.333964200000004 | -84.06830637 | 2021-12-04 04:22:18 | Henry, Ohio, US | |
2021-11-22 | US | Idaho | Jerome | 16053 | 4342 | 53 | 0 | 42.68891267 | -114.2655033 | 2021-11-23 04:22:39 | Jerome, Idaho, US | |
2021-11-06 | US | Pennsylvania | Warren | 42123 | 4342 | 135 | 0 | 41.81304978 | -79.26969577 | 2021-11-07 04:21:53 | Warren, Pennsylvania, US | |
2021-10-17 | US | New York | Greene | 36039 | 4342 | 86 | 0 | 42.275797 | -74.12384884 | 2021-10-18 04:21:10 | Greene, New York, US | |
2021-10-16 | Japan | Port Quarantine | 4342 | 7 | 0 | 2021-10-17 04:21:29 | Port Quarantine, Japan | |||||
2021-10-15 | Japan | Port Quarantine | 4342 | 7 | 0 | 2021-10-16 04:21:15 | Port Quarantine, Japan | |||||
2021-10-14 | Japan | Port Quarantine | 4342 | 7 | 0 | 2021-10-15 04:21:26 | Port Quarantine, Japan | |||||
2021-10-13 | US | Indiana | Scott | 18143 | 4342 | 68 | 0 | 38.68672078 | -85.74627859 | 2021-10-14 04:21:29 | Scott, Indiana, US | |
2021-10-05 | Netherlands | Sint Maarten | 4342 | 68 | 0 | 18.0425 | -63.0548 | 2021-10-06 04:21:33 | Sint Maarten, Netherlands | |||
2021-10-04 | Netherlands | Sint Maarten | 4342 | 68 | 0 | 18.0425 | -63.0548 | 2021-10-05 04:21:27 | Sint Maarten, Netherlands | |||
2021-09-28 | US | Pennsylvania | Snyder | 42109 | 4342 | 92 | 0 | 40.77129231 | -77.06840691 | 2021-09-29 04:21:45 | Snyder, Pennsylvania, US | |
2021-09-28 | US | Pennsylvania | Clinton | 42035 | 4342 | 71 | 0 | 41.23255967 | -77.63785995 | 2021-09-29 04:21:45 | Clinton, Pennsylvania, US | |
2021-09-21 | US | Ohio | Ottawa | 39123 | 4342 | 86 | 0 | 41.53781826 | -83.0940185 | 2021-09-22 04:21:45 | Ottawa, Ohio, US | |
2021-09-19 | US | Wyoming | Sheridan | 56033 | 4342 | 38 | 0 | 44.79048913 | -106.8862389 | 2021-09-20 04:21:22 | Sheridan, Wyoming, US | |
2021-09-18 | US | Wyoming | Sheridan | 56033 | 4342 | 38 | 0 | 44.79048913 | -106.8862389 | 2021-09-19 04:21:34 | Sheridan, Wyoming, US | |
2021-09-17 | US | Wyoming | Sheridan | 56033 | 4342 | 38 | 0 | 44.79048913 | -106.8862389 | 2021-09-18 04:21:24 | Sheridan, Wyoming, US | |
2021-09-13 | US | Colorado | Logan | 8075 | 4342 | 78 | 0 | 40.7249637 | -103.110817 | 2021-09-14 04:21:41 | Logan, Colorado, US | |
2021-09-05 | US | Arkansas | Poinsett | 5111 | 4342 | 92 | 0 | 35.57433534 | -90.66268713 | 2021-09-06 04:21:22 | Poinsett, Arkansas, US | |
2021-08-29 | US | Virginia | Charlottesville | 51540 | 4342 | 58 | 0 | 38.03527919 | -78.48569588 | 2021-08-30 04:21:23 | Charlottesville, Virginia, US | |
2021-08-28 | US | Virginia | Charlottesville | 51540 | 4342 | 58 | 0 | 38.03527919 | -78.48569588 | 2021-08-29 04:21:14 | Charlottesville, Virginia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;