johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
66 rows where confirmed = 9327 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 55
- Mexico 3
- Chile 1
- Colombia 1
- India 1
- Mongolia 1
- Peru 1
- Russia 1
- Saint Lucia 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
310936 | 310936 | 2022-12-13 | US | Texas | Cherokee | 48073 | 9327 | 258 | 0 | 31.837258 | -95.16559897 | 2022-12-14 04:21:04 | Cherokee, Texas, US | |
1151997 | 1151997 | 2022-12-12 | US | Texas | Cherokee | 48073 | 9327 | 258 | 0 | 31.837258 | -95.16559897 | 2022-12-13 04:21:01 | Cherokee, Texas, US | |
871851 | 871851 | 2022-12-11 | US | Texas | Cherokee | 48073 | 9327 | 258 | 0 | 31.837258 | -95.16559897 | 2022-12-12 04:21:01 | Cherokee, Texas, US | |
260381 | 260381 | 2022-12-10 | US | Texas | Cherokee | 48073 | 9327 | 258 | 0 | 31.837258 | -95.16559897 | 2022-12-11 04:20:50 | Cherokee, Texas, US | |
3939095 | 3939095 | 2022-12-09 | US | Texas | Cherokee | 48073 | 9327 | 258 | 0 | 31.837258 | -95.16559897 | 2022-12-10 04:21:02 | Cherokee, Texas, US | |
3380427 | 3380427 | 2022-12-08 | US | Texas | Cherokee | 48073 | 9327 | 258 | 0 | 31.837258 | -95.16559897 | 2022-12-09 04:21:05 | Cherokee, Texas, US | |
1987698 | 1987698 | 2022-12-07 | US | Texas | Cherokee | 48073 | 9327 | 258 | 0 | 31.837258 | -95.16559897 | 2022-12-08 04:21:07 | Cherokee, Texas, US | |
2441578 | 2441578 | 2022-11-07 | US | South Carolina | Marlboro | 45069 | 9327 | 112 | 0 | 34.59905577 | -79.67561152 | 2022-11-08 04:21:21 | Marlboro, South Carolina, US | |
1052676 | 1052676 | 2022-11-06 | US | South Carolina | Marlboro | 45069 | 9327 | 112 | 0 | 34.59905577 | -79.67561152 | 2022-11-07 04:21:26 | Marlboro, South Carolina, US | |
620700 | 620700 | 2022-11-05 | US | South Carolina | Marlboro | 45069 | 9327 | 112 | 0 | 34.59905577 | -79.67561152 | 2022-11-06 04:21:24 | Marlboro, South Carolina, US | |
1025204 | 1025204 | 2022-11-04 | US | South Carolina | Marlboro | 45069 | 9327 | 112 | 0 | 34.59905577 | -79.67561152 | 2022-11-05 04:21:52 | Marlboro, South Carolina, US | |
434195 | 434195 | 2022-11-03 | US | South Carolina | Marlboro | 45069 | 9327 | 112 | 0 | 34.59905577 | -79.67561152 | 2022-11-04 04:22:11 | Marlboro, South Carolina, US | |
852437 | 852437 | 2022-11-02 | US | South Carolina | Marlboro | 45069 | 9327 | 112 | 0 | 34.59905577 | -79.67561152 | 2022-11-03 04:22:05 | Marlboro, South Carolina, US | |
713288 | 713288 | 2022-11-01 | US | South Carolina | Marlboro | 45069 | 9327 | 112 | 0 | 34.59905577 | -79.67561152 | 2022-11-02 04:22:09 | Marlboro, South Carolina, US | |
200768 | 200768 | 2022-10-19 | US | Ohio | Pike | 39131 | 9327 | 130 | 0 | 39.07634001 | -83.06769584 | 2022-10-20 04:22:59 | Pike, Ohio, US | |
2759429 | 2759429 | 2022-10-18 | US | Ohio | Pike | 39131 | 9327 | 130 | 0 | 39.07634001 | -83.06769584 | 2022-10-19 04:22:26 | Pike, Ohio, US | |
2027263 | 2027263 | 2022-10-17 | US | Ohio | Pike | 39131 | 9327 | 130 | 0 | 39.07634001 | -83.06769584 | 2022-10-18 04:22:42 | Pike, Ohio, US | |
2162041 | 2162041 | 2022-10-16 | US | Ohio | Pike | 39131 | 9327 | 130 | 0 | 39.07634001 | -83.06769584 | 2022-10-17 04:20:31 | Pike, Ohio, US | |
518238 | 518238 | 2022-10-15 | US | Ohio | Pike | 39131 | 9327 | 129 | 0 | 39.07634001 | -83.06769584 | 2022-10-16 04:22:39 | Pike, Ohio, US | |
2035295 | 2035295 | 2022-10-14 | US | Ohio | Pike | 39131 | 9327 | 129 | 0 | 39.07634001 | -83.06769584 | 2022-10-15 04:22:00 | Pike, Ohio, US | |
3755983 | 3755983 | 2022-10-13 | US | Ohio | Pike | 39131 | 9327 | 129 | 0 | 39.07634001 | -83.06769584 | 2022-10-14 04:22:28 | Pike, Ohio, US | |
133414 | 133414 | 2022-10-04 | US | Pennsylvania | Clarion | 42031 | 9327 | 212 | 0 | 41.19265812 | -79.42413524 | 2022-10-05 04:23:06 | Clarion, Pennsylvania, US | |
2688361 | 2688361 | 2022-10-03 | US | Pennsylvania | Clarion | 42031 | 9327 | 212 | 0 | 41.19265812 | -79.42413524 | 2022-10-04 04:22:55 | Clarion, Pennsylvania, US | |
2262428 | 2262428 | 2022-10-02 | US | Pennsylvania | Clarion | 42031 | 9327 | 212 | 0 | 41.19265812 | -79.42413524 | 2022-10-03 04:23:11 | Clarion, Pennsylvania, US | |
2997954 | 2997954 | 2022-10-01 | US | Pennsylvania | Clarion | 42031 | 9327 | 212 | 0 | 41.19265812 | -79.42413524 | 2022-10-02 04:21:23 | Clarion, Pennsylvania, US | |
856280 | 856280 | 2022-09-30 | US | Pennsylvania | Clarion | 42031 | 9327 | 212 | 0 | 41.19265812 | -79.42413524 | 2022-10-01 04:23:01 | Clarion, Pennsylvania, US | |
2378206 | 2378206 | 2022-09-29 | US | Pennsylvania | Clarion | 42031 | 9327 | 212 | 0 | 41.19265812 | -79.42413524 | 2022-09-30 04:23:09 | Clarion, Pennsylvania, US | |
1562757 | 1562757 | 2022-09-28 | US | Pennsylvania | Clarion | 42031 | 9327 | 212 | 0 | 41.19265812 | -79.42413524 | 2022-09-29 04:22:34 | Clarion, Pennsylvania, US | |
2236486 | 2236486 | 2022-06-12 | US | Indiana | Jasper | 18073 | 9327 | 149 | 0 | 41.02078733 | -87.11553319 | 2022-06-13 04:21:14 | Jasper, Indiana, US | |
3142684 | 3142684 | 2022-06-11 | US | Indiana | Jasper | 18073 | 9327 | 149 | 0 | 41.02078733 | -87.11553319 | 2022-06-12 04:20:53 | Jasper, Indiana, US | |
1945600 | 1945600 | 2022-06-10 | US | Indiana | Jasper | 18073 | 9327 | 149 | 0 | 41.02078733 | -87.11553319 | 2022-06-11 04:21:01 | Jasper, Indiana, US | |
1424599 | 1424599 | 2022-06-08 | US | West Virginia | Marshall | 54051 | 9327 | 155 | 0 | 39.86064362 | -80.66591062 | 2022-06-09 04:20:54 | Marshall, West Virginia, US | |
2601557 | 2601557 | 2022-05-05 | US | West Virginia | Preston | 54077 | 9327 | 137 | 0 | 39.46770987 | -79.66712803 | 2022-05-06 04:21:00 | Preston, West Virginia, US | |
2029133 | 2029133 | 2022-04-24 | US | Alabama | Covington | 1039 | 9327 | 232 | 0 | 31.247785399999998 | -86.45050893 | 2022-04-25 04:20:56 | Covington, Alabama, US | |
746708 | 746708 | 2022-04-23 | US | Alabama | Covington | 1039 | 9327 | 232 | 0 | 31.247785399999998 | -86.45050893 | 2022-04-24 04:20:56 | Covington, Alabama, US | |
3437193 | 3437193 | 2022-04-22 | US | Alabama | Covington | 1039 | 9327 | 232 | 0 | 31.247785399999998 | -86.45050893 | 2022-04-23 04:20:50 | Covington, Alabama, US | |
2892778 | 2892778 | 2022-04-21 | US | Alabama | Covington | 1039 | 9327 | 231 | 0 | 31.247785399999998 | -86.45050893 | 2022-04-22 04:20:45 | Covington, Alabama, US | |
2267177 | 2267177 | 2022-03-14 | US | Vermont | Franklin | 50011 | 9327 | 66 | 0 | 44.85627605 | -72.91249563 | 2022-03-15 04:20:47 | Franklin, Vermont, US | |
2141277 | 2141277 | 2022-03-09 | US | Indiana | Jefferson | 18077 | 9327 | 142 | 0 | 38.78576239 | -85.43633383 | 2022-03-10 04:20:48 | Jefferson, Indiana, US | |
3821466 | 3821466 | 2022-02-16 | US | Illinois | Monroe | 17133 | 9327 | 128 | 0 | 38.27594376 | -90.17761038 | 2022-02-17 04:20:56 | Monroe, Illinois, US | |
2644897 | 2644897 | 2022-02-14 | US | Texas | Kerr | 48265 | 9327 | 163 | 0 | 30.06040006 | -99.34930144 | 2022-02-15 04:21:09 | Kerr, Texas, US | |
1694763 | 1694763 | 2022-01-10 | US | Ohio | Auglaize | 39011 | 9327 | 154 | 0 | 40.55998859 | -84.22421429999999 | 2022-01-11 04:22:01 | Auglaize, Ohio, US | |
1217485 | 1217485 | 2022-01-08 | US | Missouri | Johnson | 29101 | 9327 | 117 | 0 | 38.74719601 | -93.80691168 | 2022-01-09 04:21:46 | Johnson, Missouri, US | |
3495832 | 3495832 | 2021-10-26 | United Kingdom | Isle of Man | 9327 | 57 | 0 | 54.2361 | -4.5481 | 2021-10-27 04:22:32 | Isle of Man, United Kingdom | |||
2279428 | 2279428 | 2021-09-08 | Saint Lucia | 9327 | 128 | 0 | 13.9094 | -60.9789 | 2021-09-09 04:21:27 | Saint Lucia | ||||
1497486 | 1497486 | 2021-07-03 | US | Missouri | Christian | 29043 | 9327 | 97 | 0 | 36.9711783 | -93.18537118 | 2021-07-04 04:21:38 | Christian, Missouri, US | |
3956781 | 3956781 | 2021-05-11 | US | North Carolina | Caldwell | 37027 | 9327 | 104 | 0 | 35.95204977 | -81.54799522 | 2021-05-12 04:21:29 | Caldwell, North Carolina, US | |
2413021 | 2413021 | 2021-04-19 | US | New Jersey | Warren | 34041 | 9327 | 230 | 0 | 40.85951833 | -74.99556527 | 2021-04-20 04:20:41 | Warren, New Jersey, US | |
2411793 | 2411793 | 2021-04-19 | US | Idaho | Twin Falls | 16083 | 9327 | 126 | 0 | 42.35440512 | -114.6685381 | 2021-04-20 04:20:41 | Twin Falls, Idaho, US | |
170625 | 170625 | 2021-04-16 | US | California | Sutter | 6101 | 9327 | 109 | 0 | 39.03417539 | -121.6945899 | 2021-04-17 04:20:40 | Sutter, California, US | |
241365 | 241365 | 2021-04-02 | Mongolia | 9327 | 12 | 5379 | 4209 | 46.8625 | 103.8467 | 2021-04-03 04:20:44 | Mongolia | |||
1536325 | 1536325 | 2021-03-28 | US | Alabama | St. Clair | 1115 | 9327 | 232 | 0 | 33.71902176 | -86.31029372 | 2021-03-29 04:28:35 | St. Clair, Alabama, US | |
2783420 | 2783420 | 2021-03-24 | US | North Dakota | Ward | 38101 | 9327 | 192 | 0 | 48.22390169 | -101.5436763 | 2021-03-25 05:27:00 | Ward, North Dakota, US | |
2782082 | 2782082 | 2021-03-24 | US | Indiana | Howard | 18067 | 9327 | 208 | 0 | 40.48527731 | -86.11351892 | 2021-03-25 05:27:00 | Howard, Indiana, US | |
2184426 | 2184426 | 2021-02-26 | US | Georgia | Newton | 13217 | 9327 | 194 | 0 | 9133 | 33.55514538 | -83.84547140000002 | 2021-02-27 05:22:28 | Newton, Georgia, US |
742472 | 742472 | 2021-02-20 | Peru | Huancavelica | 9327 | 552 | 0 | 8775 | -13.023888 | -75.00277 | 2021-02-21 05:24:33 | Huancavelica, Peru | ||
1154939 | 1154939 | 2021-02-18 | US | Mississippi | Madison | 28089 | 9327 | 189 | 0 | 9138 | 32.63389156 | -90.03513564 | 2021-02-19 05:24:16 | Madison, Mississippi, US |
1754337 | 1754337 | 2020-12-14 | US | Texas | Ellis | 48139 | 9327 | 138 | 0 | 9588 | 32.34894117 | -96.79371841 | 2020-12-15 05:26:38 | Ellis, Texas, US |
2785223 | 2785223 | 2020-11-13 | Russia | Lipetsk Oblast | 9327 | 83 | 7502 | 1742 | 52.6935178 | 39.1122664 | 2020-11-14 05:25:37 | Lipetsk Oblast, Russia | ||
376142 | 376142 | 2020-11-06 | India | Nagaland | 9327 | 45 | 8282 | 1000 | 26.06702 | 94.470302 | 2020-11-07 05:24:52 | Nagaland, India | ||
1822869 | 1822869 | 2020-10-04 | Mexico | Durango | 9327 | 645 | 7926 | 756 | 24.5593 | -104.6588 | 2020-10-05 04:23:33 | Durango, Mexico | ||
2059736 | 2059736 | 2020-09-01 | Colombia | Meta | 9327 | 213 | 6202 | 2912 | 3.272 | -73.0877 | 2020-09-02 04:28:25 | Meta, Colombia | ||
612490 | 612490 | 2020-08-29 | US | South Carolina | Horry | 45051 | 9327 | 181 | 0 | 9146 | 33.9212828 | -78.99555293 | 2020-08-30 04:28:22 | Horry, South Carolina, US |
3562358 | 3562358 | 2020-08-25 | Chile | Coquimbo | 9327 | 119 | 8143 | 1065 | -29.959 | -71.3389 | 2020-08-26 04:28:11 | Coquimbo, Chile | ||
837707 | 837707 | 2020-08-17 | Mexico | Quintana Roo | 9327 | 1215 | 7438 | 674 | 19.1817 | -88.4791 | 2020-08-18 04:27:56 | Quintana Roo, Mexico | ||
3491313 | 3491313 | 2020-07-13 | Mexico | Jalisco | 9327 | 1045 | 6953 | 1329 | 20.6595 | -103.3494 | 2020-07-14 04:34:46 | Jalisco, Mexico |
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]);