daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
177 rows where confirmed = 3349 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- US 160
- France 7
- China 2
- Colombia 2
- Canada 1
- Chile 1
- Lithuania 1
- Netherlands 1
- Sao Tome and Principe 1
- Sri Lanka 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | France | Saint Pierre and Miquelon | 3349 | 2 | 0 | 46.8852 | -56.3159 | 2022-12-30 04:21:04 | Saint Pierre and Miquelon, France | |||
2022-12-28 | France | Saint Pierre and Miquelon | 3349 | 2 | 0 | 46.8852 | -56.3159 | 2022-12-29 04:21:01 | Saint Pierre and Miquelon, France | |||
2022-12-27 | France | Saint Pierre and Miquelon | 3349 | 2 | 0 | 46.8852 | -56.3159 | 2022-12-28 04:21:04 | Saint Pierre and Miquelon, France | |||
2022-12-26 | France | Saint Pierre and Miquelon | 3349 | 2 | 0 | 46.8852 | -56.3159 | 2022-12-27 04:21:07 | Saint Pierre and Miquelon, France | |||
2022-12-25 | France | Saint Pierre and Miquelon | 3349 | 2 | 0 | 46.8852 | -56.3159 | 2022-12-26 04:21:06 | Saint Pierre and Miquelon, France | |||
2022-12-24 | France | Saint Pierre and Miquelon | 3349 | 2 | 0 | 46.8852 | -56.3159 | 2022-12-25 04:21:04 | Saint Pierre and Miquelon, France | |||
2022-12-23 | France | Saint Pierre and Miquelon | 3349 | 2 | 0 | 46.8852 | -56.3159 | 2022-12-24 04:21:02 | Saint Pierre and Miquelon, France | |||
2022-12-05 | US | Illinois | Marshall | 17123 | 3349 | 33 | 0 | 41.0327901 | -89.34510444 | 2022-12-06 04:21:03 | Marshall, Illinois, US | |
2022-10-13 | US | Colorado | Park | 8093 | 3349 | 22 | 0 | 39.120926 | -105.7182065 | 2022-10-14 04:22:28 | Park, Colorado, US | |
2022-10-12 | US | Colorado | Archuleta | 8007 | 3349 | 18 | 0 | 37.19474156 | -107.0476867 | 2022-10-13 04:22:39 | Archuleta, Colorado, US | |
2022-10-08 | China | Henan | 3349 | 22 | 0 | 33.882 | 113.614 | 2022-10-09 04:21:16 | Henan, China | |||
2022-09-22 | US | Idaho | Idaho | 16049 | 3349 | 57 | 0 | 45.84721541 | -115.4634436 | 2022-09-23 04:23:13 | Idaho, Idaho, US | |
2022-09-21 | US | Idaho | Idaho | 16049 | 3349 | 57 | 0 | 45.84721541 | -115.4634436 | 2022-09-22 04:22:56 | Idaho, Idaho, US | |
2022-09-12 | US | Arkansas | Stone | 5137 | 3349 | 69 | 0 | 35.86251946 | -92.15684085 | 2022-09-13 04:20:57 | Stone, Arkansas, US | |
2022-09-11 | US | Arkansas | Stone | 5137 | 3349 | 69 | 0 | 35.86251946 | -92.15684085 | 2022-09-12 04:20:58 | Stone, Arkansas, US | |
2022-09-10 | US | Arkansas | Stone | 5137 | 3349 | 69 | 0 | 35.86251946 | -92.15684085 | 2022-09-11 04:20:50 | Stone, Arkansas, US | |
2022-09-01 | US | Missouri | Cedar | 29039 | 3349 | 59 | 0 | 37.72391475 | -93.85445441 | 2022-09-02 04:21:07 | Cedar, Missouri, US | |
2022-08-31 | US | Texas | Jim Hogg | 48247 | 3349 | 22 | 0 | 27.04453923 | -98.6968187 | 2022-09-01 04:21:03 | Jim Hogg, Texas, US | |
2022-08-31 | US | Missouri | Cedar | 29039 | 3349 | 59 | 0 | 37.72391475 | -93.85445441 | 2022-09-01 04:21:03 | Cedar, Missouri, US | |
2022-08-30 | US | Texas | Jim Hogg | 48247 | 3349 | 22 | 0 | 27.04453923 | -98.6968187 | 2022-08-31 04:20:57 | Jim Hogg, Texas, US | |
2022-08-30 | US | Missouri | Cedar | 29039 | 3349 | 59 | 0 | 37.72391475 | -93.85445441 | 2022-08-31 04:20:57 | Cedar, Missouri, US | |
2022-08-29 | US | Missouri | Cedar | 29039 | 3349 | 59 | 0 | 37.72391475 | -93.85445441 | 2022-08-30 04:21:03 | Cedar, Missouri, US | |
2022-08-28 | US | Missouri | Cedar | 29039 | 3349 | 59 | 0 | 37.72391475 | -93.85445441 | 2022-08-29 04:21:06 | Cedar, Missouri, US | |
2022-08-27 | US | Missouri | Cedar | 29039 | 3349 | 59 | 0 | 37.72391475 | -93.85445441 | 2022-08-28 04:21:02 | Cedar, Missouri, US | |
2022-08-26 | US | Missouri | Cedar | 29039 | 3349 | 59 | 0 | 37.72391475 | -93.85445441 | 2022-08-27 04:20:57 | Cedar, Missouri, US | |
2022-08-12 | US | Arkansas | Desha | 5041 | 3349 | 41 | 0 | 33.83011025 | -91.25500948 | 2022-08-13 04:20:52 | Desha, Arkansas, US | |
2022-08-09 | US | Maine | Piscataquis | 23021 | 3349 | 34 | 0 | 45.83839062 | -69.2860223 | 2022-08-10 04:20:57 | Piscataquis, Maine, US | |
2022-08-09 | US | Iowa | Madison | 19121 | 3349 | 41 | 0 | 41.33081904 | -94.01554631 | 2022-08-10 04:20:57 | Madison, Iowa, US | |
2022-08-08 | US | Iowa | Madison | 19121 | 3349 | 41 | 0 | 41.33081904 | -94.01554631 | 2022-08-09 04:20:34 | Madison, Iowa, US | |
2022-08-07 | US | Iowa | Madison | 19121 | 3349 | 41 | 0 | 41.33081904 | -94.01554631 | 2022-08-08 04:21:08 | Madison, Iowa, US | |
2022-08-06 | US | Iowa | Madison | 19121 | 3349 | 41 | 0 | 41.33081904 | -94.01554631 | 2022-08-07 04:20:54 | Madison, Iowa, US | |
2022-08-05 | US | Iowa | Madison | 19121 | 3349 | 41 | 0 | 41.33081904 | -94.01554631 | 2022-08-06 04:20:56 | Madison, Iowa, US | |
2022-08-04 | US | Iowa | Madison | 19121 | 3349 | 41 | 0 | 41.33081904 | -94.01554631 | 2022-08-05 04:20:52 | Madison, Iowa, US | |
2022-08-03 | US | Iowa | Madison | 19121 | 3349 | 41 | 0 | 41.33081904 | -94.01554631 | 2022-08-04 04:20:58 | Madison, Iowa, US | |
2022-07-06 | US | Arkansas | Little River | 5081 | 3349 | 106 | 0 | 33.70375665 | -94.23468591 | 2022-07-07 04:20:55 | Little River, Arkansas, US | |
2022-07-05 | US | Texas | Jackson | 48239 | 3349 | 59 | 0 | 28.95472367 | -96.57749563 | 2022-07-06 04:20:58 | Jackson, Texas, US | |
2022-07-05 | US | Georgia | Oglethorpe | 13221 | 3349 | 58 | 0 | 33.8786296 | -83.08278123 | 2022-07-06 04:20:58 | Oglethorpe, Georgia, US | |
2022-07-04 | US | Georgia | Oglethorpe | 13221 | 3349 | 58 | 0 | 33.8786296 | -83.08278123 | 2022-07-05 04:20:45 | Oglethorpe, Georgia, US | |
2022-07-03 | US | Georgia | Oglethorpe | 13221 | 3349 | 58 | 0 | 33.8786296 | -83.08278123 | 2022-07-04 04:20:54 | Oglethorpe, Georgia, US | |
2022-07-02 | US | Georgia | Oglethorpe | 13221 | 3349 | 58 | 0 | 33.8786296 | -83.08278123 | 2022-07-03 04:20:59 | Oglethorpe, Georgia, US | |
2022-07-01 | US | Georgia | Oglethorpe | 13221 | 3349 | 58 | 0 | 33.8786296 | -83.08278123 | 2022-07-02 04:21:16 | Oglethorpe, Georgia, US | |
2022-06-30 | US | Missouri | Dent | 29065 | 3349 | 85 | 0 | 37.60663134 | -91.50790473 | 2022-07-01 04:21:10 | Dent, Missouri, US | |
2022-06-30 | US | Georgia | Oglethorpe | 13221 | 3349 | 58 | 0 | 33.8786296 | -83.08278123 | 2022-07-01 04:21:10 | Oglethorpe, Georgia, US | |
2022-06-29 | US | Missouri | Dent | 29065 | 3349 | 85 | 0 | 37.60663134 | -91.50790473 | 2022-06-30 04:21:01 | Dent, Missouri, US | |
2022-06-29 | US | Georgia | Oglethorpe | 13221 | 3349 | 58 | 0 | 33.8786296 | -83.08278123 | 2022-06-30 04:21:01 | Oglethorpe, Georgia, US | |
2022-06-28 | US | Missouri | Dent | 29065 | 3349 | 85 | 0 | 37.60663134 | -91.50790473 | 2022-06-29 04:20:59 | Dent, Missouri, US | |
2022-06-27 | US | Missouri | Dent | 29065 | 3349 | 85 | 0 | 37.60663134 | -91.50790473 | 2022-06-28 04:20:58 | Dent, Missouri, US | |
2022-06-26 | US | Missouri | Dent | 29065 | 3349 | 85 | 0 | 37.60663134 | -91.50790473 | 2022-06-27 04:21:00 | Dent, Missouri, US | |
2022-06-25 | US | Missouri | Dent | 29065 | 3349 | 85 | 0 | 37.60663134 | -91.50790473 | 2022-06-26 04:21:02 | Dent, Missouri, US | |
2022-06-24 | US | Missouri | Dent | 29065 | 3349 | 85 | 0 | 37.60663134 | -91.50790473 | 2022-06-25 04:20:57 | Dent, Missouri, US | |
2022-06-15 | China | Fujian | 3349 | 1 | 0 | 26.0789 | 117.9874 | 2022-06-16 04:20:55 | Fujian, China | |||
2022-05-26 | US | Virginia | Rockbridge | 51163 | 3349 | 79 | 0 | 37.81204314 | -79.44605905 | 2022-05-27 04:20:56 | Rockbridge, Virginia, US | |
2022-04-14 | US | Virginia | Martinsville | 51690 | 3349 | 118 | 0 | 36.68212094 | -79.86352771 | 2022-04-15 04:20:57 | Martinsville, Virginia, US | |
2022-04-12 | US | Illinois | Cumberland | 17035 | 3349 | 37 | 0 | 39.27432424 | -88.2401158 | 2022-04-13 04:21:03 | Cumberland, Illinois, US | |
2022-04-11 | US | Illinois | Cumberland | 17035 | 3349 | 37 | 0 | 39.27432424 | -88.2401158 | 2022-04-12 04:20:49 | Cumberland, Illinois, US | |
2022-04-09 | US | Puerto Rico | Anasco | 72011 | 3349 | 0 | 0 | 18.287985 | -67.120611 | 2022-04-10 04:20:52 | Anasco, Puerto Rico, US | |
2022-04-07 | US | Puerto Rico | Lares | 72081 | 3349 | 0 | 0 | 18.269035000000002 | -66.867236 | 2022-04-08 04:20:48 | Lares, Puerto Rico, US | |
2022-04-06 | US | Colorado | Crowley | 8025 | 3349 | 30 | 0 | 38.32608609 | -103.7844965 | 2022-04-07 04:20:53 | Crowley, Colorado, US | |
2022-04-05 | US | Colorado | Crowley | 8025 | 3349 | 30 | 0 | 38.32608609 | -103.7844965 | 2022-04-06 04:20:49 | Crowley, Colorado, US | |
2022-03-26 | US | Puerto Rico | Aibonito | 72009 | 3349 | 0 | 0 | 18.131361 | -66.264131 | 2022-03-27 04:20:47 | Aibonito, Puerto Rico, US | |
2022-03-24 | US | New York | Yates | 36123 | 3349 | 39 | 0 | 42.63505484 | -77.10369919 | 2022-03-25 04:20:46 | Yates, New York, US | |
2022-02-21 | US | Texas | Tyler | 48457 | 3349 | 81 | 0 | 30.77031716 | -94.37690895 | 2022-02-22 04:21:01 | Tyler, Texas, US | |
2022-02-16 | Canada | Yukon | 3349 | 20 | 0 | 64.2823 | -135.0 | 2022-02-17 04:20:56 | Yukon, Canada | |||
2022-02-13 | Colombia | Vichada | 3349 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-14 04:20:51 | Vichada, Colombia | |||
2022-02-12 | Colombia | Vichada | 3349 | 59 | 0 | 4.4234 | -69.2878 | 2022-02-13 04:21:00 | Vichada, Colombia | |||
2022-02-10 | US | Georgia | Brooks | 13027 | 3349 | 79 | 0 | 30.83922642 | -83.58303423 | 2022-02-11 04:21:09 | Brooks, Georgia, US | |
2022-02-09 | US | Illinois | Washington | 17189 | 3349 | 33 | 0 | 38.35309213 | -89.40982703 | 2022-02-10 04:21:14 | Washington, Illinois, US | |
2022-02-07 | US | Minnesota | Kanabec | 27065 | 3349 | 53 | 0 | 45.9459309 | -93.29275192 | 2022-02-08 04:21:15 | Kanabec, Minnesota, US | |
2022-01-19 | US | Texas | Llano | 48299 | 3349 | 87 | 0 | 30.70645047 | -98.68475262 | 2022-01-20 04:21:07 | Llano, Texas, US | |
2022-01-16 | US | Puerto Rico | Catano | 72033 | 3349 | 0 | 0 | 18.437269 | -66.14330600000001 | 2022-01-17 04:21:08 | Catano, Puerto Rico, US | |
2022-01-13 | US | Mississippi | Clarke | 28023 | 3349 | 96 | 0 | 32.04158545 | -88.68896219999998 | 2022-01-14 04:21:54 | Clarke, Mississippi, US | |
2022-01-03 | US | Pennsylvania | Montour | 42093 | 3349 | 81 | 0 | 41.03023987 | -76.66345939 | 2022-01-04 04:22:17 | Montour, Pennsylvania, US | |
2022-01-03 | US | Indiana | Franklin | 18047 | 3349 | 48 | 0 | 39.4142482 | -85.06062647 | 2022-01-04 04:22:17 | Franklin, Indiana, US | |
2021-12-21 | US | Virginia | Fredericksburg | 51630 | 3349 | 26 | 0 | 38.2977863 | -77.4922454 | 2021-12-22 04:21:54 | Fredericksburg, Virginia, US | |
2021-12-19 | US | Minnesota | Roseau | 27135 | 3349 | 34 | 0 | 48.77501878 | -95.81079919 | 2021-12-20 04:21:43 | Roseau, Minnesota, US | |
2021-12-18 | US | Minnesota | Roseau | 27135 | 3349 | 34 | 0 | 48.77501878 | -95.81079919 | 2021-12-19 04:21:11 | Roseau, Minnesota, US | |
2021-12-17 | US | Minnesota | Roseau | 27135 | 3349 | 34 | 0 | 48.77501878 | -95.81079919 | 2021-12-18 02:22:20 | Roseau, Minnesota, US | |
2021-12-07 | US | Colorado | Pitkin | 8097 | 3349 | 6 | 0 | 39.21720112 | -106.9310027 | 2021-12-08 04:22:46 | Pitkin, Colorado, US | |
2021-11-18 | US | Michigan | Iosco | 26069 | 3349 | 102 | 0 | 44.35486835 | -83.63484895 | 2021-11-19 04:21:40 | Iosco, Michigan, US | |
2021-11-17 | US | Michigan | Iosco | 26069 | 3349 | 102 | 0 | 44.35486835 | -83.63484895 | 2021-11-18 04:21:33 | Iosco, Michigan, US | |
2021-11-03 | US | Ohio | Wyandot | 39175 | 3349 | 71 | 0 | 40.84339621 | -83.30734173 | 2021-11-04 04:22:20 | Wyandot, Ohio, US | |
2021-10-30 | US | Alabama | Butler | 1013 | 3349 | 96 | 0 | 31.75300095 | -86.68057478 | 2021-10-31 04:22:08 | Butler, Alabama, US | |
2021-10-24 | US | Georgia | Mitchell | 13205 | 3349 | 100 | 0 | 31.22483255 | -84.19381821 | 2021-10-25 04:22:31 | Mitchell, Georgia, US | |
2021-10-23 | US | Georgia | Mitchell | 13205 | 3349 | 100 | 0 | 31.22483255 | -84.19381821 | 2021-10-24 04:21:22 | Mitchell, Georgia, US | |
2021-10-22 | US | Georgia | Mitchell | 13205 | 3349 | 100 | 0 | 31.22483255 | -84.19381821 | 2021-10-23 04:21:32 | Mitchell, Georgia, US | |
2021-10-07 | US | Georgia | Lamar | 13171 | 3349 | 83 | 0 | 33.07841647 | -84.14263877 | 2021-10-08 04:21:25 | Lamar, Georgia, US | |
2021-10-03 | US | New Mexico | Cibola | 35006 | 3349 | 135 | 0 | 34.91131525 | -107.998876 | 2021-10-04 04:21:31 | Cibola, New Mexico, US | |
2021-10-02 | US | New Mexico | Cibola | 35006 | 3349 | 135 | 0 | 34.91131525 | -107.998876 | 2021-10-03 04:21:24 | Cibola, New Mexico, US | |
2021-10-01 | US | New Mexico | Cibola | 35006 | 3349 | 135 | 0 | 34.91131525 | -107.998876 | 2021-10-02 04:21:25 | Cibola, New Mexico, US | |
2021-09-29 | US | Arkansas | Ouachita | 5103 | 3349 | 75 | 0 | 33.58839816 | -92.87795984 | 2021-09-30 04:21:20 | Ouachita, Arkansas, US | |
2021-09-28 | US | Ohio | Holmes | 39075 | 3349 | 122 | 0 | 40.56163713 | -81.92635677 | 2021-09-29 04:21:45 | Holmes, Ohio, US | |
2021-09-27 | Sao Tome and Principe | 3349 | 49 | 0 | 0.1864 | 6.6131 | 2021-09-28 04:21:28 | Sao Tome and Principe | ||||
2021-09-21 | US | Georgia | Grady | 13131 | 3349 | 78 | 0 | 30.87454847 | -84.23418364 | 2021-09-22 04:21:45 | Grady, Georgia, US | |
2021-09-20 | US | Georgia | Union | 13291 | 3349 | 100 | 0 | 34.82995757 | -83.98967069 | 2021-09-21 04:21:26 | Union, Georgia, US | |
2021-09-13 | US | Minnesota | Cass | 27021 | 3349 | 35 | 0 | 46.95043611 | -94.32603968 | 2021-09-14 04:21:41 | Cass, Minnesota, US | |
2021-09-13 | US | Arkansas | Cleburne | 5023 | 3349 | 86 | 0 | 35.53864922 | -92.02640019 | 2021-09-14 04:21:41 | Cleburne, Arkansas, US | |
2021-09-08 | US | Colorado | Delta | 8029 | 3349 | 79 | 0 | 38.86246243 | -107.86313419999999 | 2021-09-09 04:21:27 | Delta, Colorado, US | |
2021-09-03 | US | Texas | Hale | 48189 | 3349 | 167 | 0 | 34.07044901 | -101.82681140000001 | 2021-09-04 04:21:28 | Hale, Texas, US | |
2021-09-02 | US | Texas | Hale | 48189 | 3349 | 167 | 0 | 34.07044901 | -101.82681140000001 | 2021-09-03 04:21:20 | Hale, Texas, US | |
2021-09-01 | US | Virginia | Accomack | 51001 | 3349 | 53 | 0 | 37.76707161 | -75.63234615 | 2021-09-02 04:21:15 | Accomack, Virginia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;