johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
39 rows where confirmed = 13713 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
965161 | 965161 | 2022-09-09 | US | New York | Montgomery | 36057 | 13713 | 218 | 0 | 42.90123494 | -74.44011632 | 2022-09-10 04:21:10 | Montgomery, New York, US | |
3650505 | 3650505 | 2022-08-14 | US | Tennessee | Campbell | 47013 | 13713 | 174 | 0 | 36.40355516 | -84.1510856 | 2022-08-15 04:20:59 | Campbell, Tennessee, US | |
1609261 | 1609261 | 2022-07-20 | US | Illinois | Henry | 17073 | 13713 | 121 | 0 | 41.3533994 | -90.13296166 | 2022-07-21 04:21:10 | Henry, Illinois, US | |
2314092 | 2314092 | 2022-06-17 | US | Puerto Rico | Vega Baja | 72145 | 13713 | 0 | 0 | 18.428262 | -66.397924 | 2022-06-18 04:21:10 | Vega Baja, Puerto Rico, US | |
1327081 | 1327081 | 2022-04-26 | US | Georgia | Laurens | 13175 | 13713 | 298 | 0 | 32.46325233 | -82.92221316 | 2022-04-27 04:20:52 | Laurens, Georgia, US | |
3723035 | 3723035 | 2022-04-25 | US | Georgia | Laurens | 13175 | 13713 | 298 | 0 | 32.46325233 | -82.92221316 | 2022-04-26 04:20:51 | Laurens, Georgia, US | |
2029603 | 2029603 | 2022-04-24 | US | Georgia | Laurens | 13175 | 13713 | 298 | 0 | 32.46325233 | -82.92221316 | 2022-04-25 04:20:56 | Laurens, Georgia, US | |
747178 | 747178 | 2022-04-23 | US | Georgia | Laurens | 13175 | 13713 | 298 | 0 | 32.46325233 | -82.92221316 | 2022-04-24 04:20:56 | Laurens, Georgia, US | |
3437663 | 3437663 | 2022-04-22 | US | Georgia | Laurens | 13175 | 13713 | 298 | 0 | 32.46325233 | -82.92221316 | 2022-04-23 04:20:50 | Laurens, Georgia, US | |
2893248 | 2893248 | 2022-04-21 | US | Georgia | Laurens | 13175 | 13713 | 298 | 0 | 32.46325233 | -82.92221316 | 2022-04-22 04:20:45 | Laurens, Georgia, US | |
2309841 | 2309841 | 2022-04-20 | US | Oklahoma | Grady | 40051 | 13713 | 244 | 0 | 35.0167709 | -97.88339847 | 2022-04-21 04:20:46 | Grady, Oklahoma, US | |
2308120 | 2308120 | 2022-04-20 | US | Georgia | Laurens | 13175 | 13713 | 298 | 0 | 32.46325233 | -82.92221316 | 2022-04-21 04:20:46 | Laurens, Georgia, US | |
2253980 | 2253980 | 2022-04-19 | US | Oklahoma | Grady | 40051 | 13713 | 244 | 0 | 35.0167709 | -97.88339847 | 2022-04-20 04:20:45 | Grady, Oklahoma, US | |
1848530 | 1848530 | 2022-04-18 | US | Oklahoma | Grady | 40051 | 13713 | 244 | 0 | 35.0167709 | -97.88339847 | 2022-04-19 04:21:00 | Grady, Oklahoma, US | |
3419474 | 3419474 | 2022-04-17 | US | Oklahoma | Grady | 40051 | 13713 | 244 | 0 | 35.0167709 | -97.88339847 | 2022-04-18 04:21:12 | Grady, Oklahoma, US | |
306423 | 306423 | 2022-04-16 | US | Oklahoma | Grady | 40051 | 13713 | 244 | 0 | 35.0167709 | -97.88339847 | 2022-04-17 04:20:59 | Grady, Oklahoma, US | |
2672368 | 2672368 | 2022-04-15 | US | Oklahoma | Grady | 40051 | 13713 | 244 | 0 | 35.0167709 | -97.88339847 | 2022-04-16 04:20:48 | Grady, Oklahoma, US | |
1226153 | 1226153 | 2022-04-14 | US | Oklahoma | Grady | 40051 | 13713 | 244 | 0 | 35.0167709 | -97.88339847 | 2022-04-15 04:20:57 | Grady, Oklahoma, US | |
2804199 | 2804199 | 2022-04-06 | US | Virginia | Washington | 51191 | 13713 | 213 | 0 | 36.72341572 | -81.95666289 | 2022-04-07 04:20:53 | Washington, Virginia, US | |
2734508 | 2734508 | 2022-02-27 | US | Kentucky | Whitley | 21235 | 13713 | 160 | 0 | 36.75700531 | -84.14541217 | 2022-02-28 04:21:05 | Whitley, Kentucky, US | |
3047661 | 3047661 | 2022-02-26 | US | Kentucky | Whitley | 21235 | 13713 | 160 | 0 | 36.75700531 | -84.14541217 | 2022-02-27 04:21:04 | Whitley, Kentucky, US | |
576316 | 576316 | 2022-02-25 | US | Kentucky | Whitley | 21235 | 13713 | 160 | 0 | 36.75700531 | -84.14541217 | 2022-02-26 04:21:12 | Whitley, Kentucky, US | |
2448304 | 2448304 | 2022-02-22 | US | Louisiana | St. Charles | 22089 | 13713 | 141 | 0 | 29.90709658 | -90.35555967 | 2022-02-23 04:21:09 | St. Charles, Louisiana, US | |
2399382 | 2399382 | 2021-12-17 | US | California | Napa | 6055 | 13713 | 107 | 0 | 38.50735751 | -122.33283899999999 | 2021-12-18 02:22:20 | Napa, California, US | |
1716920 | 1716920 | 2021-12-16 | US | California | Napa | 6055 | 13713 | 107 | 0 | 38.50735751 | -122.33283899999999 | 2021-12-17 04:22:14 | Napa, California, US | |
46054 | 46054 | 2021-11-02 | US | North Carolina | Moore | 37125 | 13713 | 248 | 0 | 35.30885257 | -79.48474178 | 2021-11-03 06:22:09 | Moore, North Carolina, US | |
290938 | 290938 | 2021-10-31 | US | Tennessee | Greene | 47059 | 13713 | 241 | 0 | 36.17470125 | -82.84691273 | 2021-11-01 04:22:01 | Greene, Tennessee, US | |
2175310 | 2175310 | 2021-08-22 | Burkina Faso | 13713 | 171 | 0 | 12.2383 | -1.5616 | 2021-08-23 04:21:27 | Burkina Faso | ||||
1808255 | 1808255 | 2021-05-27 | US | Louisiana | Livingston | 22063 | 13713 | 207 | 0 | 30.44143993 | -90.73061664 | 2021-05-28 04:20:36 | Livingston, Louisiana, US | |
2822358 | 2822358 | 2021-05-10 | US | Massachusetts | Barnstable | 25001 | 13713 | 370 | 0 | 41.72980578 | -70.28854339 | 2021-05-11 04:20:41 | Barnstable, Massachusetts, US | |
3003445 | 3003445 | 2021-04-06 | Pakistan | Azad Jammu and Kashmir | 13713 | 380 | 11409 | 1924 | 34.027401 | 73.947253 | 2021-04-07 04:20:53 | Azad Jammu and Kashmir, Pakistan | ||
3087557 | 3087557 | 2021-04-05 | US | New York | Saratoga | 36091 | 13713 | 157 | 0 | 43.10904162 | -73.86653895 | 2021-04-06 04:20:32 | Saratoga, New York, US | |
1092843 | 1092843 | 2021-03-03 | US | Puerto Rico | San Juan | 72127 | 13713 | 0 | 0 | 13713 | 18.386933 | -66.061128 | 2021-03-04 05:24:24 | San Juan, Puerto Rico, US |
1675248 | 1675248 | 2021-02-07 | US | South Carolina | Aiken | 45003 | 13713 | 182 | 0 | 13531 | 33.54338026 | -81.63645384 | 2021-02-08 05:22:39 | Aiken, South Carolina, US |
12130 | 12130 | 2021-01-26 | Chile | Los Rios | 13713 | 143 | 12156 | 1414 | -40.231 | -72.3311 | 2021-01-27 05:23:41 | Los Rios, Chile | ||
3230362 | 3230362 | 2021-01-03 | Germany | Bremen | 13713 | 202 | 12067 | 1485 | 53.0793 | 8.8017 | 2021-01-04 05:22:02 | Bremen, Germany | ||
1353766 | 1353766 | 2020-11-24 | US | Washington | Snohomish | 53061 | 13713 | 275 | 0 | 13438 | 48.04615983 | -121.7170703 | 2020-11-25 05:27:20 | Snohomish, Washington, US |
2880466 | 2880466 | 2020-11-15 | Russia | Yaroslavl Oblast | 13713 | 69 | 12470 | 1174 | 57.77819760000001 | 39.0021095 | 2020-11-16 05:25:57 | Yaroslavl Oblast, Russia | ||
1105606 | 1105606 | 2020-09-02 | Kosovo | 13713 | 539 | 9923 | 3251 | 42.602636 | 20.902977 | 2020-09-03 04:28:22 | Kosovo |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);