daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
258 rows where confirmed = 2602 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-29 | US | Texas | Swisher | 48437 | 2602 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-30 04:21:04 | Swisher, Texas, US | |
2022-12-28 | US | Texas | Swisher | 48437 | 2602 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-12-29 04:21:01 | Swisher, Texas, US | |
2022-12-13 | US | Arkansas | Cleveland | 5025 | 2602 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-12-14 04:21:04 | Cleveland, Arkansas, US | |
2022-12-12 | US | Illinois | Hamilton | 17065 | 2602 | 32 | 0 | 38.08163641 | -88.53883373 | 2022-12-13 04:21:01 | Hamilton, Illinois, US | |
2022-12-12 | US | Arkansas | Cleveland | 5025 | 2602 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-12-13 04:21:01 | Cleveland, Arkansas, US | |
2022-12-11 | US | Kentucky | Nicholas | 21181 | 2602 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-12 04:21:01 | Nicholas, Kentucky, US | |
2022-12-11 | US | Arkansas | Cleveland | 5025 | 2602 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-12-12 04:21:01 | Cleveland, Arkansas, US | |
2022-12-10 | US | Kentucky | Nicholas | 21181 | 2602 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-11 04:20:50 | Nicholas, Kentucky, US | |
2022-12-10 | US | Arkansas | Cleveland | 5025 | 2602 | 40 | 0 | 33.89723187 | -92.18537045 | 2022-12-11 04:20:50 | Cleveland, Arkansas, US | |
2022-12-09 | US | Kentucky | Nicholas | 21181 | 2602 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-10 04:21:02 | Nicholas, Kentucky, US | |
2022-12-08 | US | Kentucky | Nicholas | 21181 | 2602 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-09 04:21:05 | Nicholas, Kentucky, US | |
2022-12-07 | US | Kentucky | Nicholas | 21181 | 2602 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-08 04:21:07 | Nicholas, Kentucky, US | |
2022-12-06 | US | Kentucky | Nicholas | 21181 | 2602 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-07 04:20:58 | Nicholas, Kentucky, US | |
2022-12-05 | US | Kentucky | Nicholas | 21181 | 2602 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-06 04:21:03 | Nicholas, Kentucky, US | |
2022-11-30 | China | Tianjin | 2602 | 3 | 0 | 39.3054 | 117.323 | 2022-12-01 04:21:03 | Tianjin, China | |||
2022-11-29 | US | Georgia | Lanier | 13173 | 2602 | 30 | 0 | 31.0382857 | -83.06472457 | 2022-11-30 04:21:07 | Lanier, Georgia, US | |
2022-11-29 | China | Tianjin | 2602 | 3 | 0 | 39.3054 | 117.323 | 2022-11-30 04:21:07 | Tianjin, China | |||
2022-11-28 | US | Tennessee | Clay | 47027 | 2602 | 56 | 0 | 36.55151008 | -85.53930419 | 2022-11-29 04:21:05 | Clay, Tennessee, US | |
2022-11-28 | US | Georgia | Lanier | 13173 | 2602 | 30 | 0 | 31.0382857 | -83.06472457 | 2022-11-29 04:21:05 | Lanier, Georgia, US | |
2022-11-27 | US | Texas | Ochiltree | 48357 | 2602 | 49 | 0 | 36.27829105 | -100.8158184 | 2022-11-28 04:21:02 | Ochiltree, Texas, US | |
2022-11-27 | US | Georgia | Lanier | 13173 | 2602 | 30 | 0 | 31.0382857 | -83.06472457 | 2022-11-28 04:21:02 | Lanier, Georgia, US | |
2022-11-26 | US | Texas | Ochiltree | 48357 | 2602 | 49 | 0 | 36.27829105 | -100.8158184 | 2022-11-27 04:21:05 | Ochiltree, Texas, US | |
2022-11-26 | US | Georgia | Lanier | 13173 | 2602 | 30 | 0 | 31.0382857 | -83.06472457 | 2022-11-27 04:21:05 | Lanier, Georgia, US | |
2022-11-25 | US | Texas | Ochiltree | 48357 | 2602 | 49 | 0 | 36.27829105 | -100.8158184 | 2022-11-26 04:21:11 | Ochiltree, Texas, US | |
2022-11-25 | US | Georgia | Lanier | 13173 | 2602 | 30 | 0 | 31.0382857 | -83.06472457 | 2022-11-26 04:21:11 | Lanier, Georgia, US | |
2022-11-24 | US | Texas | Ochiltree | 48357 | 2602 | 49 | 0 | 36.27829105 | -100.8158184 | 2022-11-25 04:21:06 | Ochiltree, Texas, US | |
2022-11-24 | US | Georgia | Lanier | 13173 | 2602 | 30 | 0 | 31.0382857 | -83.06472457 | 2022-11-25 04:21:06 | Lanier, Georgia, US | |
2022-11-23 | US | Texas | Ochiltree | 48357 | 2602 | 49 | 0 | 36.27829105 | -100.8158184 | 2022-11-24 04:21:09 | Ochiltree, Texas, US | |
2022-11-23 | US | Georgia | Lanier | 13173 | 2602 | 30 | 0 | 31.0382857 | -83.06472457 | 2022-11-24 04:21:09 | Lanier, Georgia, US | |
2022-11-06 | US | Tennessee | Moore | 47127 | 2602 | 41 | 0 | 35.27724699 | -86.36230578 | 2022-11-07 04:21:26 | Moore, Tennessee, US | |
2022-11-05 | US | Tennessee | Moore | 47127 | 2602 | 41 | 0 | 35.27724699 | -86.36230578 | 2022-11-06 04:21:24 | Moore, Tennessee, US | |
2022-10-16 | US | Texas | Castro | 48069 | 2602 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-10-17 04:20:31 | Castro, Texas, US | |
2022-10-15 | US | Texas | Castro | 48069 | 2602 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-10-16 04:22:39 | Castro, Texas, US | |
2022-10-15 | China | Yunnan | 2602 | 2 | 0 | 24.974 | 101.487 | 2022-10-16 04:22:39 | Yunnan, China | |||
2022-10-14 | US | Texas | Castro | 48069 | 2602 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-10-15 04:22:00 | Castro, Texas, US | |
2022-10-04 | US | Colorado | San Miguel | 8113 | 2602 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-10-05 04:23:06 | San Miguel, Colorado, US | |
2022-09-29 | US | Texas | Red River | 48387 | 2602 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-09-30 04:23:09 | Red River, Texas, US | |
2022-09-13 | US | Texas | Runnels | 48399 | 2602 | 68 | 0 | 31.8314342 | -99.97616148 | 2022-09-14 04:20:44 | Runnels, Texas, US | |
2022-09-12 | US | Texas | Runnels | 48399 | 2602 | 68 | 0 | 31.8314342 | -99.97616148 | 2022-09-13 04:20:57 | Runnels, Texas, US | |
2022-09-11 | US | Texas | Runnels | 48399 | 2602 | 68 | 0 | 31.8314342 | -99.97616148 | 2022-09-12 04:20:58 | Runnels, Texas, US | |
2022-09-10 | US | Texas | Runnels | 48399 | 2602 | 68 | 0 | 31.8314342 | -99.97616148 | 2022-09-11 04:20:50 | Runnels, Texas, US | |
2022-09-09 | US | Texas | Runnels | 48399 | 2602 | 68 | 0 | 31.8314342 | -99.97616148 | 2022-09-10 04:21:10 | Runnels, Texas, US | |
2022-08-25 | US | Virginia | Northampton | 51131 | 2602 | 69 | 0 | 37.34062933 | -75.87751591 | 2022-08-26 04:21:02 | Northampton, Virginia, US | |
2022-08-24 | US | New Mexico | Colfax | 35007 | 2602 | 67 | 0 | 36.60569702 | -104.6472674 | 2022-08-25 04:21:13 | Colfax, New Mexico, US | |
2022-08-23 | US | New Mexico | Colfax | 35007 | 2602 | 67 | 0 | 36.60569702 | -104.6472674 | 2022-08-24 04:20:46 | Colfax, New Mexico, US | |
2022-08-22 | US | New Mexico | Colfax | 35007 | 2602 | 67 | 0 | 36.60569702 | -104.6472674 | 2022-08-23 04:20:56 | Colfax, New Mexico, US | |
2022-07-19 | US | Indiana | Benton | 18007 | 2602 | 23 | 0 | 40.60626947 | -87.31093999 | 2022-07-20 04:20:59 | Benton, Indiana, US | |
2022-07-11 | US | Texas | Morris | 48343 | 2602 | 73 | 0 | 33.11304005 | -94.73255695 | 2022-07-12 04:20:51 | Morris, Texas, US | |
2022-06-22 | US | Oklahoma | Hughes | 40063 | 2602 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-06-23 04:20:55 | Hughes, Oklahoma, US | |
2022-06-21 | US | Oklahoma | Hughes | 40063 | 2602 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-06-22 04:20:54 | Hughes, Oklahoma, US | |
2022-06-20 | US | Oklahoma | Hughes | 40063 | 2602 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-06-21 04:20:56 | Hughes, Oklahoma, US | |
2022-06-19 | US | Oklahoma | Hughes | 40063 | 2602 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-06-20 04:21:01 | Hughes, Oklahoma, US | |
2022-06-18 | US | Oklahoma | Hughes | 40063 | 2602 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-06-19 04:20:51 | Hughes, Oklahoma, US | |
2022-06-17 | US | Oklahoma | Hughes | 40063 | 2602 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-06-18 04:21:10 | Hughes, Oklahoma, US | |
2022-06-16 | US | Oklahoma | Hughes | 40063 | 2602 | 62 | 0 | 35.04912569 | -96.24921145 | 2022-06-17 04:20:56 | Hughes, Oklahoma, US | |
2022-06-06 | US | North Dakota | Mercer | 38057 | 2602 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-06-07 04:21:08 | Mercer, North Dakota, US | |
2022-06-06 | US | Colorado | Bent | 8011 | 2602 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-06-07 04:21:08 | Bent, Colorado, US | |
2022-05-31 | US | Virginia | Galax | 51640 | 2602 | 78 | 0 | 36.66601852 | -80.91703124 | 2022-06-01 04:20:55 | Galax, Virginia, US | |
2022-05-13 | US | Puerto Rico | Arroyo | 72015 | 2602 | 0 | 0 | 17.998457 | -66.056546 | 2022-05-14 04:20:48 | Arroyo, Puerto Rico, US | |
2022-04-26 | US | North Carolina | Pamlico | 37137 | 2602 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-04-27 04:20:52 | Pamlico, North Carolina, US | |
2022-04-25 | US | North Carolina | Pamlico | 37137 | 2602 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-04-26 04:20:51 | Pamlico, North Carolina, US | |
2022-04-24 | US | North Carolina | Pamlico | 37137 | 2602 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-04-25 04:20:56 | Pamlico, North Carolina, US | |
2022-04-23 | US | North Carolina | Pamlico | 37137 | 2602 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-04-24 04:20:56 | Pamlico, North Carolina, US | |
2022-04-22 | US | North Carolina | Pamlico | 37137 | 2602 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-04-23 04:20:50 | Pamlico, North Carolina, US | |
2022-04-21 | US | North Carolina | Pamlico | 37137 | 2602 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-04-22 04:20:45 | Pamlico, North Carolina, US | |
2022-04-20 | US | North Carolina | Pamlico | 37137 | 2602 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-04-21 04:20:46 | Pamlico, North Carolina, US | |
2022-04-07 | US | Virginia | Clarke | 51043 | 2602 | 42 | 0 | 39.11271747 | -77.99199425 | 2022-04-08 04:20:48 | Clarke, Virginia, US | |
2022-03-23 | US | Virginia | Amelia | 51007 | 2602 | 60 | 0 | 37.34081025 | -77.98584649 | 2022-03-24 04:20:43 | Amelia, Virginia, US | |
2022-03-16 | US | Texas | Jim Hogg | 48247 | 2602 | 22 | 0 | 27.04453923 | -98.69681870000001 | 2022-03-17 04:20:56 | Jim Hogg, Texas, US | |
2022-03-15 | US | Texas | Jim Hogg | 48247 | 2602 | 22 | 0 | 27.04453923 | -98.69681870000001 | 2022-03-16 04:20:50 | Jim Hogg, Texas, US | |
2022-03-14 | US | Texas | Jim Hogg | 48247 | 2602 | 22 | 0 | 27.04453923 | -98.69681870000001 | 2022-03-15 04:20:47 | Jim Hogg, Texas, US | |
2022-03-13 | US | Virginia | Clarke | 51043 | 2602 | 40 | 0 | 39.11271747 | -77.99199425 | 2022-03-14 04:20:46 | Clarke, Virginia, US | |
2022-03-13 | US | Texas | Jim Hogg | 48247 | 2602 | 22 | 0 | 27.04453923 | -98.69681870000001 | 2022-03-14 04:20:46 | Jim Hogg, Texas, US | |
2022-03-12 | US | Virginia | Clarke | 51043 | 2602 | 40 | 0 | 39.11271747 | -77.99199425 | 2022-03-13 04:20:49 | Clarke, Virginia, US | |
2022-03-12 | US | Texas | Jim Hogg | 48247 | 2602 | 22 | 0 | 27.04453923 | -98.69681870000001 | 2022-03-13 04:20:49 | Jim Hogg, Texas, US | |
2022-03-11 | US | Virginia | Clarke | 51043 | 2602 | 40 | 0 | 39.11271747 | -77.99199425 | 2022-03-12 04:20:50 | Clarke, Virginia, US | |
2022-03-10 | US | Virginia | Clarke | 51043 | 2602 | 40 | 0 | 39.11271747 | -77.99199425 | 2022-03-11 04:20:50 | Clarke, Virginia, US | |
2022-03-08 | US | Alabama | Lowndes | 1085 | 2602 | 75 | 0 | 32.1597283 | -86.65158371 | 2022-03-09 04:20:59 | Lowndes, Alabama, US | |
2022-03-07 | US | Minnesota | Stevens | 27149 | 2602 | 13 | 0 | 45.58613007 | -96.00163705 | 2022-03-08 04:20:54 | Stevens, Minnesota, US | |
2022-03-07 | US | Alabama | Lowndes | 1085 | 2602 | 75 | 0 | 32.1597283 | -86.65158371 | 2022-03-08 04:20:54 | Lowndes, Alabama, US | |
2022-03-05 | US | Puerto Rico | Orocovis | 72107 | 2602 | 0 | 0 | 18.215046 | -66.433604 | 2022-03-06 04:20:49 | Orocovis, Puerto Rico, US | |
2022-02-21 | US | Virginia | Richmond | 51159 | 2602 | 21 | 0 | 37.937575 | -76.72920628 | 2022-02-22 04:21:01 | Richmond, Virginia, US | |
2022-02-17 | US | Michigan | Iron | 26071 | 2602 | 81 | 0 | 46.20974132 | -88.53136251 | 2022-02-18 04:21:04 | Iron, Michigan, US | |
2022-02-16 | US | Michigan | Iron | 26071 | 2602 | 81 | 0 | 46.20974132 | -88.53136251 | 2022-02-17 04:20:56 | Iron, Michigan, US | |
2022-02-03 | US | Kansas | Brown | 20013 | 2602 | 47 | 0 | 39.82652589 | -95.56421698 | 2022-02-04 04:21:10 | Brown, Kansas, US | |
2022-02-02 | US | Kansas | Brown | 20013 | 2602 | 47 | 0 | 39.82652589 | -95.56421698 | 2022-02-03 04:21:21 | Brown, Kansas, US | |
2022-02-01 | US | Idaho | Teton | 16081 | 2602 | 8 | 0 | 43.75303583 | -111.2056773 | 2022-02-02 04:21:09 | Teton, Idaho, US | |
2022-01-26 | US | South Dakota | Todd | 46121 | 2602 | 43 | 0 | 43.19338568 | -100.71955030000001 | 2022-01-27 04:21:19 | Todd, South Dakota, US | |
2022-01-15 | US | California | Mono | 6051 | 2602 | 4 | 0 | 37.93899289 | -118.8872409 | 2022-01-16 04:21:12 | Mono, California, US | |
2022-01-03 | US | Virginia | Patrick | 51141 | 2602 | 72 | 0 | 36.680163799999995 | -80.2865648 | 2022-01-04 04:22:17 | Patrick, Virginia, US | |
2022-01-03 | US | North Carolina | Polk | 37149 | 2602 | 49 | 0 | 35.27820615 | -82.16812354 | 2022-01-04 04:22:17 | Polk, North Carolina, US | |
2021-12-28 | US | Alabama | Clay | 1027 | 2602 | 69 | 0 | 33.26984193 | -85.85836077 | 2021-12-29 03:21:43 | Clay, Alabama, US | |
2021-12-25 | US | Puerto Rico | Aguada | 72003 | 2602 | 0 | 0 | 18.360255 | -67.17513100000001 | 2021-12-26 04:21:50 | Aguada, Puerto Rico, US | |
2021-12-22 | US | Missouri | Madison | 29123 | 2602 | 40 | 0 | 37.47865134 | -90.34671429999999 | 2021-12-23 04:21:21 | Madison, Missouri, US | |
2021-12-21 | US | Texas | Wilbarger | 48487 | 2602 | 72 | 0 | 34.07945812 | -99.24178437 | 2021-12-22 04:21:54 | Wilbarger, Texas, US | |
2021-12-20 | US | Texas | Tyler | 48457 | 2602 | 72 | 0 | 30.77031716 | -94.37690895 | 2021-12-21 03:21:27 | Tyler, Texas, US | |
2021-12-19 | US | Texas | Tyler | 48457 | 2602 | 72 | 0 | 30.77031716 | -94.37690895 | 2021-12-20 04:21:43 | Tyler, Texas, US | |
2021-12-18 | US | Texas | Tyler | 48457 | 2602 | 72 | 0 | 30.77031716 | -94.37690895 | 2021-12-19 04:21:11 | Tyler, Texas, US | |
2021-12-15 | US | Indiana | Tipton | 18159 | 2602 | 67 | 0 | 40.31123252 | -86.05234925 | 2021-12-16 04:22:11 | Tipton, Indiana, US | |
2021-12-13 | US | Nevada | Humboldt | 32013 | 2602 | 39 | 0 | 41.40692186 | -118.11094270000001 | 2021-12-14 04:22:38 | Humboldt, Nevada, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;