johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
39 rows where confirmed = 9828 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756297 | 2756297 | 2022-12-29 | US | Virginia | Petersburg | 51730 | 9828 | 150 | 0 | 37.20530399 | -77.39368102 | 2022-12-30 04:21:04 | Petersburg, Virginia, US | |
1077303 | 1077303 | 2022-12-28 | US | Virginia | Petersburg | 51730 | 9828 | 150 | 0 | 37.20530399 | -77.39368102 | 2022-12-29 04:21:01 | Petersburg, Virginia, US | |
692610 | 692610 | 2022-12-23 | US | New York | Delaware | 36025 | 9828 | 87 | 0 | 42.19837623 | -74.96709306 | 2022-12-24 04:21:02 | Delaware, New York, US | |
131678 | 131678 | 2022-10-04 | US | Idaho | Bonner | 16017 | 9828 | 193 | 0 | 48.29996017 | -116.6017932 | 2022-10-05 04:23:06 | Bonner, Idaho, US | |
2686625 | 2686625 | 2022-10-03 | US | Idaho | Bonner | 16017 | 9828 | 193 | 0 | 48.29996017 | -116.6017932 | 2022-10-04 04:22:55 | Bonner, Idaho, US | |
1609276 | 1609276 | 2022-07-20 | US | Illinois | Lee | 17103 | 9828 | 80 | 0 | 41.74583951 | -89.29977132 | 2022-07-21 04:21:10 | Lee, Illinois, US | |
3917064 | 3917064 | 2022-05-01 | US | Illinois | Montgomery | 17135 | 9828 | 105 | 0 | 39.23198845 | -89.47809254 | 2022-05-02 04:21:10 | Montgomery, Illinois, US | |
2841868 | 2841868 | 2022-04-30 | US | Illinois | Montgomery | 17135 | 9828 | 105 | 0 | 39.23198845 | -89.47809254 | 2022-05-01 04:20:57 | Montgomery, Illinois, US | |
1158181 | 1158181 | 2022-04-29 | US | Illinois | Montgomery | 17135 | 9828 | 105 | 0 | 39.23198845 | -89.47809254 | 2022-04-30 04:21:05 | Montgomery, Illinois, US | |
1992645 | 1992645 | 2022-03-01 | Japan | Akita | 9828 | 33 | 0 | 39.748678999999996 | 140.408228 | 2022-03-02 04:21:07 | Akita, Japan | |||
3821253 | 3821253 | 2022-02-16 | US | Georgia | Habersham | 13137 | 9828 | 238 | 0 | 34.63331566 | -83.53094677 | 2022-02-17 04:20:56 | Habersham, Georgia, US | |
72691 | 72691 | 2022-02-07 | US | Massachusetts | Franklin | 25011 | 9828 | 115 | 0 | 42.58119713 | -72.58602547 | 2022-02-08 04:21:15 | Franklin, Massachusetts, US | |
2660076 | 2660076 | 2022-01-31 | US | North Carolina | Alexander | 37003 | 9828 | 121 | 0 | 35.922379600000006 | -81.17751948 | 2022-02-01 04:21:11 | Alexander, North Carolina, US | |
3228866 | 3228866 | 2022-01-19 | US | North Dakota | Morton | 38059 | 9828 | 135 | 0 | 46.71681782 | -101.2822377 | 2022-01-20 04:21:07 | Morton, North Dakota, US | |
1475442 | 1475442 | 2022-01-17 | US | Virginia | Culpeper | 51047 | 9828 | 97 | 0 | 38.48199985 | -77.95630870000002 | 2022-01-18 04:21:04 | Culpeper, Virginia, US | |
3689760 | 3689760 | 2022-01-13 | US | New York | Washington | 36115 | 9828 | 96 | 0 | 43.31153794 | -73.43043448 | 2022-01-14 04:21:54 | Washington, New York, US | |
1717415 | 1717415 | 2021-12-16 | US | Illinois | Whiteside | 17195 | 9828 | 193 | 0 | 41.75509713 | -89.91556058 | 2021-12-17 04:22:14 | Whiteside, Illinois, US | |
1033339 | 1033339 | 2021-12-06 | US | Tennessee | Lawrence | 47099 | 9828 | 131 | 0 | 35.21675201 | -87.39787695 | 2021-12-07 04:22:34 | Lawrence, Tennessee, US | |
3344308 | 3344308 | 2021-11-16 | US | Michigan | Shiawassee | 26155 | 9828 | 137 | 0 | 42.95392800000001 | -84.14585902 | 2021-11-17 04:21:48 | Shiawassee, Michigan, US | |
3344267 | 3344267 | 2021-11-16 | US | Michigan | Isabella | 26073 | 9828 | 137 | 0 | 43.64060976 | -84.84664923 | 2021-11-17 04:21:48 | Isabella, Michigan, US | |
2289144 | 2289144 | 2021-11-15 | US | Michigan | Shiawassee | 26155 | 9828 | 137 | 0 | 42.95392800000001 | -84.14585902 | 2021-11-16 04:21:10 | Shiawassee, Michigan, US | |
2289103 | 2289103 | 2021-11-15 | US | Michigan | Isabella | 26073 | 9828 | 137 | 0 | 43.64060976 | -84.84664923 | 2021-11-16 04:21:10 | Isabella, Michigan, US | |
491375 | 491375 | 2021-10-14 | Brunei | 9828 | 67 | 0 | 4.5353 | 114.7277 | 2021-10-15 04:21:26 | Brunei | ||||
2878477 | 2878477 | 2021-10-09 | US | New York | St. Lawrence | 36089 | 9828 | 122 | 0 | 44.4976179 | -75.06550039 | 2021-10-10 04:21:38 | St. Lawrence, New York, US | |
3195376 | 3195376 | 2021-09-06 | US | Kentucky | Bullitt | 21029 | 9828 | 96 | 0 | 37.97162523 | -85.68955617 | 2021-09-07 04:21:35 | Bullitt, Kentucky, US | |
3128196 | 3128196 | 2021-06-28 | US | Pennsylvania | Northumberland | 42097 | 9828 | 360 | 0 | 40.84785433 | -76.70798222 | 2021-06-29 04:21:28 | Northumberland, Pennsylvania, US | |
2592691 | 2592691 | 2021-06-27 | US | Pennsylvania | Northumberland | 42097 | 9828 | 360 | 0 | 40.84785433 | -76.70798222 | 2021-06-28 04:21:29 | Northumberland, Pennsylvania, US | |
2299031 | 2299031 | 2021-06-24 | US | Wisconsin | St. Croix | 55109 | 9828 | 67 | 0 | 45.03437474 | -92.45000068 | 2021-06-25 04:21:33 | St. Croix, Wisconsin, US | |
3383541 | 3383541 | 2021-06-13 | US | New Jersey | Hunterdon | 34019 | 9828 | 176 | 0 | 40.56335249 | -74.91284156 | 2021-06-14 04:22:46 | Hunterdon, New Jersey, US | |
1773496 | 1773496 | 2021-05-23 | US | New Hampshire | Strafford | 33017 | 9828 | 90 | 0 | 43.291833 | -71.02336013 | 2021-05-24 04:20:53 | Strafford, New Hampshire, US | |
3243930 | 3243930 | 2021-04-21 | US | Michigan | Allegan | 26005 | 9828 | 126 | 0 | 42.59147037 | -85.89102866 | 2021-04-22 04:20:53 | Allegan, Michigan, US | |
1735898 | 1735898 | 2021-03-14 | US | Virginia | Stafford | 51179 | 9828 | 70 | 0 | 38.41758738 | -77.45917053 | 2021-03-15 05:25:51 | Stafford, Virginia, US | |
1838468 | 1838468 | 2021-03-12 | US | California | El Dorado | 6017 | 9828 | 103 | 0 | 38.77965956 | -120.5233166 | 2021-03-13 05:25:15 | El Dorado, California, US | |
2359945 | 2359945 | 2021-03-08 | US | Arkansas | Garland | 5051 | 9828 | 234 | 0 | 34.57692074 | -93.14921604 | 2021-03-09 05:28:19 | Garland, Arkansas, US | |
1091300 | 1091300 | 2021-03-03 | US | Iowa | Pottawattamie | 19155 | 9828 | 143 | 0 | 9685 | 41.33640314 | -95.53907776 | 2021-03-04 05:24:24 | Pottawattamie, Iowa, US |
182180 | 182180 | 2021-02-21 | Pakistan | Azad Jammu and Kashmir | 9828 | 288 | 8971 | 569 | 34.027401 | 73.947253 | 2021-02-22 05:24:21 | Azad Jammu and Kashmir, Pakistan | ||
1026750 | 1026750 | 2020-10-17 | US | Alabama | Tuscaloosa | 1125 | 9828 | 132 | 0 | 9696 | 33.28726072 | -87.52556818 | 2020-10-18 04:24:25 | Tuscaloosa, Alabama, US |
323745 | 323745 | 2020-07-20 | US | Maryland | Baltimore | 24005 | 9828 | 512 | 0 | 9316 | 39.45784712 | -76.62911955 | 2020-07-21 04:38:46 | Baltimore, Maryland, US |
2524066 | 2524066 | 2020-04-23 | US | New York | Rockland | 36087 | 9828 | 362 | 0 | 9466 | 41.15027894 | -74.02560498 | 2020-04-22 00:00:00 | Rockland, New York, US |
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]);