daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
292 rows where confirmed = 2336 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 | West Virginia | Tucker | 54093 | 2336 | 39 | 0 | 39.11240885 | -79.57053576 | 2022-12-30 04:21:04 | Tucker, West Virginia, US | |
2022-12-28 | US | West Virginia | Tucker | 54093 | 2336 | 39 | 0 | 39.11240885 | -79.57053576 | 2022-12-29 04:21:01 | Tucker, West Virginia, US | |
2022-12-27 | US | West Virginia | Tucker | 54093 | 2336 | 39 | 0 | 39.11240885 | -79.57053576 | 2022-12-28 04:21:04 | Tucker, West Virginia, US | |
2022-12-06 | US | Texas | Dallam | 48111 | 2336 | 43 | 0 | 36.27787176 | -102.6020725 | 2022-12-07 04:20:58 | Dallam, Texas, US | |
2022-12-05 | US | Texas | Dallam | 48111 | 2336 | 43 | 0 | 36.27787176 | -102.6020725 | 2022-12-06 04:21:03 | Dallam, Texas, US | |
2022-12-04 | US | Texas | Dallam | 48111 | 2336 | 43 | 0 | 36.27787176 | -102.6020725 | 2022-12-05 04:20:58 | Dallam, Texas, US | |
2022-12-03 | US | Texas | Dallam | 48111 | 2336 | 43 | 0 | 36.27787176 | -102.6020725 | 2022-12-04 04:20:56 | Dallam, Texas, US | |
2022-12-02 | US | Texas | Dallam | 48111 | 2336 | 43 | 0 | 36.27787176 | -102.6020725 | 2022-12-03 04:21:02 | Dallam, Texas, US | |
2022-12-01 | US | Texas | Dallam | 48111 | 2336 | 43 | 0 | 36.27787176 | -102.6020725 | 2022-12-02 04:21:07 | Dallam, Texas, US | |
2022-11-30 | US | Texas | Dallam | 48111 | 2336 | 43 | 0 | 36.27787176 | -102.6020725 | 2022-12-01 04:21:03 | Dallam, Texas, US | |
2022-11-14 | US | Missouri | Oregon | 29149 | 2336 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-15 04:21:16 | Oregon, Missouri, US | |
2022-11-13 | US | Missouri | Oregon | 29149 | 2336 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-14 04:21:09 | Oregon, Missouri, US | |
2022-11-12 | US | Missouri | Oregon | 29149 | 2336 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-13 04:21:14 | Oregon, Missouri, US | |
2022-11-11 | US | Missouri | Oregon | 29149 | 2336 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-12 04:20:41 | Oregon, Missouri, US | |
2022-11-10 | US | Missouri | Oregon | 29149 | 2336 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-11 04:21:22 | Oregon, Missouri, US | |
2022-11-09 | US | Missouri | Oregon | 29149 | 2336 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-10 04:21:16 | Oregon, Missouri, US | |
2022-11-08 | US | Missouri | Oregon | 29149 | 2336 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-11-09 04:21:22 | Oregon, Missouri, US | |
2022-10-16 | China | Guangxi | 2336 | 2 | 0 | 23.8298 | 108.7881 | 2022-10-17 04:20:31 | Guangxi, China | |||
2022-09-28 | US | Minnesota | Marshall | 27089 | 2336 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-09-29 04:22:34 | Marshall, Minnesota, US | |
2022-09-27 | US | North Dakota | Traill | 38097 | 2336 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-09-28 04:23:01 | Traill, North Dakota, US | |
2022-09-27 | US | Minnesota | Marshall | 27089 | 2336 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-09-28 04:23:01 | Marshall, Minnesota, US | |
2022-09-26 | US | Minnesota | Marshall | 27089 | 2336 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-09-27 04:23:01 | Marshall, Minnesota, US | |
2022-09-25 | US | Minnesota | Marshall | 27089 | 2336 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-09-26 04:20:52 | Marshall, Minnesota, US | |
2022-09-24 | US | Minnesota | Marshall | 27089 | 2336 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-09-25 04:23:31 | Marshall, Minnesota, US | |
2022-09-23 | US | Minnesota | Marshall | 27089 | 2336 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-09-24 04:21:40 | Marshall, Minnesota, US | |
2022-09-22 | US | Minnesota | Marshall | 27089 | 2336 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-09-23 04:23:13 | Marshall, Minnesota, US | |
2022-09-15 | US | Montana | Sanders | 30089 | 2336 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-09-16 04:21:19 | Sanders, Montana, US | |
2022-09-14 | US | Montana | Sanders | 30089 | 2336 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-09-15 04:21:02 | Sanders, Montana, US | |
2022-09-13 | US | Montana | Sanders | 30089 | 2336 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-09-14 04:20:44 | Sanders, Montana, US | |
2022-09-12 | US | Montana | Sanders | 30089 | 2336 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-09-13 04:20:57 | Sanders, Montana, US | |
2022-09-11 | US | Montana | Sanders | 30089 | 2336 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-09-12 04:20:58 | Sanders, Montana, US | |
2022-09-10 | US | Montana | Sanders | 30089 | 2336 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-09-11 04:20:50 | Sanders, Montana, US | |
2022-09-09 | US | Montana | Sanders | 30089 | 2336 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-09-10 04:21:10 | Sanders, Montana, US | |
2022-09-05 | US | New Mexico | Quay | 35037 | 2336 | 67 | 0 | 35.10403332 | -103.5481727 | 2022-09-06 04:21:02 | Quay, New Mexico, US | |
2022-09-04 | US | New Mexico | Quay | 35037 | 2336 | 67 | 0 | 35.10403332 | -103.5481727 | 2022-09-05 04:21:01 | Quay, New Mexico, US | |
2022-09-04 | US | Colorado | Lincoln | 8073 | 2336 | 11 | 0 | 38.98749519 | -103.5136649 | 2022-09-05 04:21:01 | Lincoln, Colorado, US | |
2022-09-03 | US | New Mexico | Quay | 35037 | 2336 | 67 | 0 | 35.10403332 | -103.5481727 | 2022-09-04 04:21:22 | Quay, New Mexico, US | |
2022-09-03 | US | Colorado | Lincoln | 8073 | 2336 | 11 | 0 | 38.98749519 | -103.5136649 | 2022-09-04 04:21:22 | Lincoln, Colorado, US | |
2022-09-02 | US | New Mexico | Quay | 35037 | 2336 | 67 | 0 | 35.10403332 | -103.5481727 | 2022-09-03 04:21:04 | Quay, New Mexico, US | |
2022-09-02 | US | Colorado | Lincoln | 8073 | 2336 | 11 | 0 | 38.98749519 | -103.5136649 | 2022-09-03 04:21:04 | Lincoln, Colorado, US | |
2022-09-01 | US | New Mexico | Quay | 35037 | 2336 | 67 | 0 | 35.10403332 | -103.5481727 | 2022-09-02 04:21:07 | Quay, New Mexico, US | |
2022-08-30 | US | Georgia | Terrell | 13273 | 2336 | 70 | 0 | 31.77527543 | -84.44069698 | 2022-08-31 04:20:57 | Terrell, Georgia, US | |
2022-08-29 | US | Georgia | Terrell | 13273 | 2336 | 70 | 0 | 31.77527543 | -84.44069698 | 2022-08-30 04:21:03 | Terrell, Georgia, US | |
2022-08-28 | US | Georgia | Terrell | 13273 | 2336 | 70 | 0 | 31.77527543 | -84.44069698 | 2022-08-29 04:21:06 | Terrell, Georgia, US | |
2022-08-27 | US | Georgia | Terrell | 13273 | 2336 | 70 | 0 | 31.77527543 | -84.44069698 | 2022-08-28 04:21:02 | Terrell, Georgia, US | |
2022-08-26 | US | Georgia | Terrell | 13273 | 2336 | 70 | 0 | 31.77527543 | -84.44069698 | 2022-08-27 04:20:57 | Terrell, Georgia, US | |
2022-08-25 | US | Georgia | Terrell | 13273 | 2336 | 70 | 0 | 31.77527543 | -84.44069698 | 2022-08-26 04:21:02 | Terrell, Georgia, US | |
2022-08-24 | US | Georgia | Terrell | 13273 | 2336 | 70 | 0 | 31.77527543 | -84.44069698 | 2022-08-25 04:21:13 | Terrell, Georgia, US | |
2022-08-19 | China | Inner Mongolia | 2336 | 1 | 0 | 44.0935 | 113.9448 | 2022-08-20 04:21:01 | Inner Mongolia, China | |||
2022-08-09 | US | Nebraska | Box Butte | 31013 | 2336 | 17 | 0 | 42.22079243 | -103.0878834 | 2022-08-10 04:20:57 | Box Butte, Nebraska, US | |
2022-08-08 | US | Nebraska | Box Butte | 31013 | 2336 | 17 | 0 | 42.22079243 | -103.0878834 | 2022-08-09 04:20:34 | Box Butte, Nebraska, US | |
2022-07-28 | US | Texas | Franklin | 48159 | 2336 | 45 | 0 | 33.17653242 | -95.21917243 | 2022-07-29 04:20:45 | Franklin, Texas, US | |
2022-07-20 | US | Oklahoma | Latimer | 40077 | 2336 | 35 | 0 | 34.87844729 | -95.25215049 | 2022-07-21 04:21:10 | Latimer, Oklahoma, US | |
2022-07-19 | US | Oklahoma | Latimer | 40077 | 2336 | 35 | 0 | 34.87844729 | -95.25215049 | 2022-07-20 04:20:59 | Latimer, Oklahoma, US | |
2022-07-18 | US | Oklahoma | Latimer | 40077 | 2336 | 35 | 0 | 34.87844729 | -95.25215049 | 2022-07-19 04:20:58 | Latimer, Oklahoma, US | |
2022-07-17 | US | Oklahoma | Latimer | 40077 | 2336 | 35 | 0 | 34.87844729 | -95.25215049 | 2022-07-18 04:20:59 | Latimer, Oklahoma, US | |
2022-07-16 | US | Oklahoma | Latimer | 40077 | 2336 | 35 | 0 | 34.87844729 | -95.25215049 | 2022-07-17 04:21:15 | Latimer, Oklahoma, US | |
2022-07-15 | US | Oklahoma | Latimer | 40077 | 2336 | 35 | 0 | 34.87844729 | -95.25215049 | 2022-07-16 04:21:05 | Latimer, Oklahoma, US | |
2022-07-14 | US | Oklahoma | Latimer | 40077 | 2336 | 35 | 0 | 34.87844729 | -95.25215049 | 2022-07-15 04:20:53 | Latimer, Oklahoma, US | |
2022-07-12 | US | Texas | Archer | 48009 | 2336 | 28 | 0 | 33.61569967 | -98.68754589 | 2022-07-13 04:20:58 | Archer, Texas, US | |
2022-06-29 | US | Puerto Rico | Guanica | 72055 | 2336 | 0 | 0 | 17.982429 | -66.919643 | 2022-06-30 04:21:01 | Guanica, Puerto Rico, US | |
2022-06-29 | US | Arkansas | Cleveland | 5025 | 2336 | 36 | 0 | 33.89723187 | -92.18537045 | 2022-06-30 04:21:01 | Cleveland, Arkansas, US | |
2022-06-28 | US | Indiana | Switzerland | 18155 | 2336 | 20 | 0 | 38.82767338 | -85.03022429 | 2022-06-29 04:20:59 | Switzerland, Indiana, US | |
2022-06-27 | US | Indiana | Switzerland | 18155 | 2336 | 20 | 0 | 38.82767338 | -85.03022429 | 2022-06-28 04:20:58 | Switzerland, Indiana, US | |
2022-06-19 | US | Arkansas | Scott | 5127 | 2336 | 44 | 0 | 34.85588887 | -94.0632176 | 2022-06-20 04:21:01 | Scott, Arkansas, US | |
2022-06-18 | US | Arkansas | Scott | 5127 | 2336 | 44 | 0 | 34.85588887 | -94.0632176 | 2022-06-19 04:20:51 | Scott, Arkansas, US | |
2022-05-31 | US | Alabama | Bullock | 1011 | 2336 | 54 | 0 | 32.10030533 | -85.71265535 | 2022-06-01 04:20:55 | Bullock, Alabama, US | |
2022-05-01 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-05-02 04:21:10 | Perry, Tennessee, US | |
2022-05-01 | US | Minnesota | Rock | 27133 | 2336 | 34 | 0 | 43.67482683 | -96.25296832 | 2022-05-02 04:21:10 | Rock, Minnesota, US | |
2022-04-30 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-05-01 04:20:57 | Perry, Tennessee, US | |
2022-04-30 | US | Minnesota | Rock | 27133 | 2336 | 34 | 0 | 43.67482683 | -96.25296832 | 2022-05-01 04:20:57 | Rock, Minnesota, US | |
2022-04-29 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-30 04:21:05 | Perry, Tennessee, US | |
2022-04-29 | US | Minnesota | Rock | 27133 | 2336 | 34 | 0 | 43.67482683 | -96.25296832 | 2022-04-30 04:21:05 | Rock, Minnesota, US | |
2022-04-28 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-29 04:20:59 | Perry, Tennessee, US | |
2022-04-28 | US | Minnesota | Rock | 27133 | 2336 | 34 | 0 | 43.67482683 | -96.25296832 | 2022-04-29 04:20:59 | Rock, Minnesota, US | |
2022-04-27 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-28 04:20:47 | Perry, Tennessee, US | |
2022-04-26 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-27 04:20:52 | Perry, Tennessee, US | |
2022-04-25 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-26 04:20:51 | Perry, Tennessee, US | |
2022-04-24 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-25 04:20:56 | Perry, Tennessee, US | |
2022-04-23 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-24 04:20:56 | Perry, Tennessee, US | |
2022-04-22 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-23 04:20:50 | Perry, Tennessee, US | |
2022-04-21 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-22 04:20:45 | Perry, Tennessee, US | |
2022-04-20 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-21 04:20:46 | Perry, Tennessee, US | |
2022-04-19 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-20 04:20:45 | Perry, Tennessee, US | |
2022-04-18 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-19 04:21:00 | Perry, Tennessee, US | |
2022-04-17 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-18 04:21:12 | Perry, Tennessee, US | |
2022-04-16 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-17 04:20:59 | Perry, Tennessee, US | |
2022-04-15 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-16 04:20:48 | Perry, Tennessee, US | |
2022-04-14 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-15 04:20:57 | Perry, Tennessee, US | |
2022-04-13 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-13 23:21:06 | Perry, Tennessee, US | |
2022-04-12 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-13 04:21:03 | Perry, Tennessee, US | |
2022-04-11 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-12 04:20:49 | Perry, Tennessee, US | |
2022-04-10 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-11 04:21:02 | Perry, Tennessee, US | |
2022-04-10 | US | Puerto Rico | Santa Isabel | 72133 | 2336 | 0 | 0 | 17.994525 | -66.388913 | 2022-04-11 04:21:02 | Santa Isabel, Puerto Rico, US | |
2022-04-09 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-10 04:20:52 | Perry, Tennessee, US | |
2022-04-08 | US | Tennessee | Perry | 47135 | 2336 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-04-09 04:20:42 | Perry, Tennessee, US | |
2022-04-04 | US | Nebraska | Box Butte | 31013 | 2336 | 17 | 0 | 42.22079243 | -103.08788340000001 | 2022-04-05 04:20:48 | Box Butte, Nebraska, US | |
2022-04-03 | US | Nebraska | Box Butte | 31013 | 2336 | 17 | 0 | 42.22079243 | -103.08788340000001 | 2022-04-04 04:20:51 | Box Butte, Nebraska, US | |
2022-04-02 | US | Nebraska | Box Butte | 31013 | 2336 | 17 | 0 | 42.22079243 | -103.08788340000001 | 2022-04-03 04:20:48 | Box Butte, Nebraska, US | |
2022-03-31 | US | Nebraska | Box Butte | 31013 | 2336 | 8 | 0 | 42.22079243 | -103.08788340000001 | 2022-04-01 04:20:28 | Box Butte, Nebraska, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;