johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
88 rows where confirmed = 6964 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754241 | 2754241 | 2022-12-29 | US | Kansas | Pottawatomie | 20149 | 6964 | 70 | 0 | 39.37925655 | -96.34564657 | 2022-12-30 04:21:04 | Pottawatomie, Kansas, US | |
1075247 | 1075247 | 2022-12-28 | US | Kansas | Pottawatomie | 20149 | 6964 | 70 | 0 | 39.37925655 | -96.34564657 | 2022-12-29 04:21:01 | Pottawatomie, Kansas, US | |
2275336 | 2275336 | 2022-10-20 | US | Virginia | Scott | 51169 | 6964 | 123 | 0 | 36.71466456 | -82.60171704 | 2022-10-21 04:22:23 | Scott, Virginia, US | |
1396395 | 1396395 | 2022-09-02 | US | Puerto Rico | Aguas Buenas | 72007 | 6964 | 0 | 0 | 18.251619 | -66.126806 | 2022-09-03 04:21:04 | Aguas Buenas, Puerto Rico, US | |
1254123 | 1254123 | 2022-08-23 | US | Virginia | Lee | 51105 | 6964 | 96 | 0 | 36.70586667 | -83.12606515 | 2022-08-24 04:20:46 | Lee, Virginia, US | |
1253828 | 1253828 | 2022-08-23 | US | Texas | DeWitt | 48123 | 6964 | 101 | 0 | 29.08101855 | -97.3568117 | 2022-08-24 04:20:46 | DeWitt, Texas, US | |
2596648 | 2596648 | 2022-07-25 | US | Oregon | Crook | 41013 | 6964 | 86 | 0 | 44.14230227 | -120.356297 | 2022-07-26 04:20:58 | Crook, Oregon, US | |
3000819 | 3000819 | 2022-05-24 | US | Louisiana | Jefferson Davis | 22053 | 6964 | 157 | 0 | 30.26896765 | -92.81210004 | 2022-05-25 04:20:56 | Jefferson Davis, Louisiana, US | |
3853566 | 3853566 | 2022-04-27 | US | Minnesota | Nobles | 27105 | 6964 | 60 | 0 | 43.67434621 | -95.75329576 | 2022-04-28 04:20:47 | Nobles, Minnesota, US | |
1227139 | 1227139 | 2022-04-14 | US | Wisconsin | Door | 55029 | 6964 | 71 | 0 | 44.95856458 | -87.30002707 | 2022-04-15 04:20:57 | Door, Wisconsin, US | |
2752144 | 2752144 | 2022-04-04 | US | Texas | Willacy | 48489 | 6964 | 129 | 0 | 26.47411727 | -97.61535848 | 2022-04-05 04:20:48 | Willacy, Texas, US | |
1471626 | 1471626 | 2022-03-24 | US | West Virginia | Wyoming | 54109 | 6964 | 106 | 0 | 37.612327 | -81.54511071 | 2022-03-25 04:20:46 | Wyoming, West Virginia, US | |
2734106 | 2734106 | 2022-02-27 | US | Indiana | Decatur | 18031 | 6964 | 130 | 0 | 39.30712658 | -85.50087166 | 2022-02-28 04:21:05 | Decatur, Indiana, US | |
3047259 | 3047259 | 2022-02-26 | US | Indiana | Decatur | 18031 | 6964 | 130 | 0 | 39.30712658 | -85.50087166 | 2022-02-27 04:21:04 | Decatur, Indiana, US | |
575914 | 575914 | 2022-02-25 | US | Indiana | Decatur | 18031 | 6964 | 130 | 0 | 39.30712658 | -85.50087166 | 2022-02-26 04:21:12 | Decatur, Indiana, US | |
188739 | 188739 | 2022-02-13 | US | Pennsylvania | Elk | 42047 | 6964 | 93 | 0 | 41.42822061 | -78.64524744 | 2022-02-14 04:20:51 | Elk, Pennsylvania, US | |
232951 | 232951 | 2022-02-11 | Bhutan | 6964 | 5 | 0 | 27.5142 | 90.4336 | 2022-02-12 04:21:06 | Bhutan | ||||
1465828 | 1465828 | 2022-02-10 | US | Minnesota | Mille Lacs | 27095 | 6964 | 104 | 0 | 45.93705297 | -93.63236823 | 2022-02-11 04:21:09 | Mille Lacs, Minnesota, US | |
72547 | 72547 | 2022-02-07 | US | Kentucky | Ohio | 21183 | 6964 | 91 | 0 | 37.47751843 | -86.85368087 | 2022-02-08 04:21:15 | Ohio, Kentucky, US | |
2475767 | 2475767 | 2022-02-03 | US | Mississippi | Itawamba | 28057 | 6964 | 123 | 0 | 34.27993475 | -88.3606733 | 2022-02-04 04:21:10 | Itawamba, Mississippi, US | |
2052782 | 2052782 | 2022-01-25 | US | Georgia | Wayne | 13305 | 6964 | 184 | 0 | 31.5521809 | -81.91894878 | 2022-01-26 04:21:07 | Wayne, Georgia, US | |
1143051 | 1143051 | 2022-01-23 | US | Nevada | Douglas | 32005 | 6964 | 76 | 0 | 38.912862 | -119.61713329999999 | 2022-01-24 04:21:12 | Douglas, Nevada, US | |
2834969 | 2834969 | 2022-01-22 | US | Nevada | Douglas | 32005 | 6964 | 76 | 0 | 38.912862 | -119.61713329999999 | 2022-01-23 04:21:13 | Douglas, Nevada, US | |
3427087 | 3427087 | 2022-01-21 | US | Nevada | Douglas | 32005 | 6964 | 76 | 0 | 38.912862 | -119.61713329999999 | 2022-01-22 04:21:13 | Douglas, Nevada, US | |
558179 | 558179 | 2022-01-16 | US | Virginia | Petersburg | 51730 | 6964 | 111 | 0 | 37.20530399 | -77.39368102 | 2022-01-17 04:21:08 | Petersburg, Virginia, US | |
3843900 | 3843900 | 2022-01-15 | US | Virginia | Petersburg | 51730 | 6964 | 111 | 0 | 37.20530399 | -77.39368102 | 2022-01-16 04:21:12 | Petersburg, Virginia, US | |
102715 | 102715 | 2022-01-14 | US | Virginia | Petersburg | 51730 | 6964 | 111 | 0 | 37.20530399 | -77.39368102 | 2022-01-15 04:21:07 | Petersburg, Virginia, US | |
1115797 | 1115797 | 2022-01-11 | US | New Mexico | Rio Arriba | 35039 | 6964 | 103 | 0 | 36.51072137 | -106.69316740000001 | 2022-01-12 04:21:44 | Rio Arriba, New Mexico, US | |
1114619 | 1114619 | 2022-01-11 | US | Illinois | Morgan | 17137 | 6964 | 107 | 0 | 39.71654544 | -90.20255104 | 2022-01-12 04:21:44 | Morgan, Illinois, US | |
1114514 | 1114514 | 2022-01-11 | US | Idaho | Bonner | 16017 | 6964 | 152 | 0 | 48.29996017 | -116.6017932 | 2022-01-12 04:21:44 | Bonner, Idaho, US | |
2087790 | 2087790 | 2021-12-14 | Colombia | Amazonas | 6964 | 258 | 0 | -1.4429 | -71.5724 | 2021-12-15 03:22:16 | Amazonas, Colombia | |||
1032869 | 1032869 | 2021-12-06 | US | Ohio | Mercer | 39107 | 6964 | 106 | 0 | 40.54043046 | -84.62912742 | 2021-12-07 04:22:34 | Mercer, Ohio, US | |
3404712 | 3404712 | 2021-11-30 | US | Utah | Southeast Utah | 6964 | 55 | 0 | 38.99617072 | -110.70139579999999 | 2021-12-01 04:22:29 | Southeast Utah, Utah, US | ||
3071870 | 3071870 | 2021-11-23 | US | Mississippi | Pontotoc | 28115 | 6964 | 109 | 0 | 34.226046000000004 | -89.03636807 | 2021-11-24 04:22:14 | Pontotoc, Mississippi, US | |
3495158 | 3495158 | 2021-10-26 | US | Tennessee | Rhea | 47143 | 6964 | 93 | 0 | 35.60536161 | -84.93076643 | 2021-10-27 04:22:32 | Rhea, Tennessee, US | |
685699 | 685699 | 2021-10-24 | US | Virginia | James City | 51095 | 6964 | 95 | 0 | 37.31156958 | -76.76950618 | 2021-10-25 04:22:31 | James City, Virginia, US | |
773707 | 773707 | 2021-10-23 | US | Virginia | James City | 51095 | 6964 | 95 | 0 | 37.31156958 | -76.76950618 | 2021-10-24 04:21:22 | James City, Virginia, US | |
657354 | 657354 | 2021-10-22 | US | Virginia | James City | 51095 | 6964 | 95 | 0 | 37.31156958 | -76.76950618 | 2021-10-23 04:21:32 | James City, Virginia, US | |
1493518 | 1493518 | 2021-10-12 | US | Missouri | Johnson | 29101 | 6964 | 70 | 0 | 38.74719601 | -93.80691168 | 2021-10-13 04:20:51 | Johnson, Missouri, US | |
2077781 | 2077781 | 2021-09-26 | US | Mississippi | Oktibbeha | 28105 | 6964 | 124 | 0 | 33.42491685 | -88.87905132 | 2021-09-27 04:21:16 | Oktibbeha, Mississippi, US | |
1726333 | 1726333 | 2021-09-25 | US | Mississippi | Oktibbeha | 28105 | 6964 | 124 | 0 | 33.42491685 | -88.87905132 | 2021-09-26 04:21:29 | Oktibbeha, Mississippi, US | |
1923053 | 1923053 | 2021-09-24 | US | Mississippi | Oktibbeha | 28105 | 6964 | 124 | 0 | 33.42491685 | -88.87905132 | 2021-09-25 04:21:31 | Oktibbeha, Mississippi, US | |
643048 | 643048 | 2021-09-07 | US | Indiana | Marshall | 18099 | 6964 | 123 | 0 | 41.32467367 | -86.26185087 | 2021-09-08 04:21:31 | Marshall, Indiana, US | |
248391 | 248391 | 2021-08-17 | US | Texas | Hunt | 48231 | 6964 | 185 | 0 | 33.12351514 | -96.08551032 | 2021-08-18 04:21:35 | Hunt, Texas, US | |
105592 | 105592 | 2021-08-15 | US | New York | St. Lawrence | 36089 | 6964 | 97 | 0 | 44.4976179 | -75.06550039 | 2021-08-16 04:21:31 | St. Lawrence, New York, US | |
1119510 | 1119510 | 2021-08-06 | US | Missouri | Lincoln | 29113 | 6964 | 53 | 0 | 39.05345619 | -90.95588181 | 2021-08-07 04:21:30 | Lincoln, Missouri, US | |
2373481 | 2373481 | 2021-07-20 | US | Missouri | Taney | 29213 | 6964 | 106 | 0 | 36.65465345 | -93.04075153 | 2021-07-21 04:21:40 | Taney, Missouri, US | |
2675295 | 2675295 | 2021-07-18 | US | Louisiana | Acadia | 22001 | 6964 | 198 | 0 | 30.2950649 | -92.41419698 | 2021-07-19 04:21:24 | Acadia, Louisiana, US | |
3707607 | 3707607 | 2021-07-17 | US | Louisiana | Acadia | 22001 | 6964 | 198 | 0 | 30.2950649 | -92.41419698 | 2021-07-18 04:22:07 | Acadia, Louisiana, US | |
2948838 | 2948838 | 2021-07-16 | US | Louisiana | Acadia | 22001 | 6964 | 198 | 0 | 30.2950649 | -92.41419698 | 2021-07-17 04:22:22 | Acadia, Louisiana, US | |
3635627 | 3635627 | 2021-07-14 | Yemen | 6964 | 1366 | 4151 | 1447 | 15.552727 | 48.516388 | 2021-07-15 04:21:48 | Yemen | |||
581047 | 581047 | 2021-07-13 | US | New Mexico | Valencia | 35061 | 6964 | 119 | 0 | 34.71669834 | -106.8103733 | 2021-07-14 04:21:35 | Valencia, New Mexico, US | |
2696194 | 2696194 | 2021-07-06 | US | Ohio | Ross | 39141 | 6964 | 165 | 0 | 39.33705391 | -83.06000914 | 2021-07-07 04:21:20 | Ross, Ohio, US | |
1934943 | 1934943 | 2021-07-05 | US | Ohio | Ross | 39141 | 6964 | 165 | 0 | 39.33705391 | -83.06000914 | 2021-07-06 04:21:32 | Ross, Ohio, US | |
1497041 | 1497041 | 2021-07-03 | US | Kentucky | McCracken | 21145 | 6964 | 133 | 0 | 37.05350953 | -88.70445755 | 2021-07-04 04:21:38 | McCracken, Kentucky, US | |
3148503 | 3148503 | 2021-06-07 | US | Tennessee | Coffee | 47031 | 6964 | 124 | 0 | 35.49090731 | -86.07311784 | 2021-06-08 04:22:35 | Coffee, Tennessee, US | |
2106130 | 2106130 | 2021-06-01 | US | Montana | Lewis and Clark | 30049 | 6964 | 88 | 0 | 47.12610041 | -112.394698 | 2021-06-02 04:24:34 | Lewis and Clark, Montana, US | |
1190746 | 1190746 | 2021-05-31 | US | Montana | Lewis and Clark | 30049 | 6964 | 88 | 0 | 47.12610041 | -112.394698 | 2021-06-01 04:23:09 | Lewis and Clark, Montana, US | |
3091423 | 3091423 | 2021-05-30 | US | Montana | Lewis and Clark | 30049 | 6964 | 88 | 0 | 47.12610041 | -112.394698 | 2021-05-31 03:08:59 | Lewis and Clark, Montana, US | |
50727 | 50727 | 2021-05-29 | India | Andaman and Nicobar Islands | 6964 | 113 | 6660 | 191 | 11.225999 | 92.968178 | 2021-05-30 04:20:55 | Andaman and Nicobar Islands, India | ||
1083609 | 1083609 | 2021-05-14 | US | Michigan | Van Buren | 26159 | 6964 | 123 | 0 | 42.25190229 | -86.01939087 | 2021-05-15 04:20:58 | Van Buren, Michigan, US | |
645911 | 645911 | 2021-05-05 | India | Mizoram | 6964 | 17 | 5305 | 1642 | 23.309381 | 92.83822 | 2021-05-06 04:20:38 | Mizoram, India | ||
1637816 | 1637816 | 2021-04-29 | US | Louisiana | Iberia | 22045 | 6964 | 153 | 0 | 29.86803617 | -91.75871777 | 2021-04-30 04:21:03 | Iberia, Louisiana, US | |
3964877 | 3964877 | 2021-03-10 | US | North Carolina | Stanly | 37167 | 6964 | 111 | 0 | 35.31647813 | -80.25093221 | 2021-03-11 05:25:48 | Stanly, North Carolina, US | |
1091522 | 1091522 | 2021-03-03 | US | Kentucky | Oldham | 21185 | 6964 | 69 | 0 | 6895 | 38.39791089 | -85.448222 | 2021-03-04 05:24:24 | Oldham, Kentucky, US |
283433 | 283433 | 2021-02-24 | US | Texas | Wise | 48497 | 6964 | 109 | 0 | 6758 | 33.21570665 | -97.65460265 | 2021-02-25 05:24:57 | Wise, Texas, US |
1156574 | 1156574 | 2021-02-18 | US | Washington | Thurston | 53067 | 6964 | 74 | 0 | 6890 | 46.9291895 | -122.8290656 | 2021-02-19 05:24:16 | Thurston, Washington, US |
2638248 | 2638248 | 2021-02-11 | US | Arkansas | White | 5145 | 6964 | 100 | 0 | 6864 | 35.25688493 | -91.74908296 | 2021-02-12 05:23:29 | White, Arkansas, US |
617276 | 617276 | 2021-02-08 | US | Wisconsin | Wood | 55141 | 6964 | 80 | 0 | 6884 | 44.45537896 | -90.04158336 | 2021-02-09 05:23:30 | Wood, Wisconsin, US |
1462564 | 1462564 | 2021-01-31 | US | South Carolina | Darlington | 45031 | 6964 | 131 | 0 | 6833 | 34.33358335 | -79.96027485 | 2021-02-01 05:22:53 | Darlington, South Carolina, US |
1095782 | 1095782 | 2021-01-20 | US | Minnesota | Carver | 27019 | 6964 | 36 | 0 | 6928 | 44.82017001 | -93.8009918 | 2021-01-21 05:22:01 | Carver, Minnesota, US |
3308524 | 3308524 | 2021-01-13 | Sweden | Varmland | 6964 | 137 | 0 | 6827 | 59.7294 | 13.2354 | 2021-01-14 05:22:32 | Varmland, Sweden | ||
769412 | 769412 | 2020-12-29 | US | Texas | Guadalupe | 48187 | 6964 | 104 | 0 | 6719 | 29.58165339 | -97.94786822 | 2020-12-30 05:22:34 | Guadalupe, Texas, US |
3691953 | 3691953 | 2020-12-24 | US | Arkansas | Faulkner | 5045 | 6964 | 83 | 0 | 6881 | 35.14719007 | -92.33717519 | 2020-12-25 05:22:48 | Faulkner, Arkansas, US |
3770312 | 3770312 | 2020-12-22 | US | Arizona | Apache | 4001 | 6964 | 221 | 0 | 6743 | 35.39465006 | -109.4892383 | 2020-12-23 05:22:03 | Apache, Arizona, US |
1009602 | 1009602 | 2020-12-06 | US | Virginia | Chesapeake | 51550 | 6964 | 81 | 0 | 6883 | 36.67670048 | -76.30545744 | 2020-12-07 05:26:14 | Chesapeake, Virginia, US |
2537783 | 2537783 | 2020-12-01 | US | Alabama | Morgan | 1103 | 6964 | 51 | 0 | 6913 | 34.45500589 | -86.85475946 | 2020-12-02 05:27:41 | Morgan, Alabama, US |
1584006 | 1584006 | 2020-11-30 | Colombia | Casanare | 6964 | 149 | 6240 | 575 | 5.7589 | -71.5724 | 2020-12-01 05:26:18 | Casanare, Colombia | ||
1988351 | 1988351 | 2020-11-09 | Bahamas | 6964 | 154 | 4943 | 1867 | 25.025885 | -78.035889 | 2020-11-10 05:40:07 | Bahamas | |||
786629 | 786629 | 2020-10-15 | Russia | Udmurt Republic | 6964 | 99 | 4800 | 2065 | 57.1961165 | 52.69598320000001 | 2020-10-16 04:24:01 | Udmurt Republic, Russia | ||
967099 | 967099 | 2020-09-29 | Russia | Karachay-Cherkess Republic | 6964 | 28 | 4816 | 2120 | 43.7368326 | 41.7267991 | 2020-09-30 04:23:33 | Karachay-Cherkess Republic, Russia | ||
2656401 | 2656401 | 2020-09-23 | US | Pennsylvania | Berks | 42011 | 6964 | 393 | 0 | 6571 | 40.41570541 | -75.92457766 | 2020-09-24 04:23:00 | Berks, Pennsylvania, US |
1121501 | 1121501 | 2020-09-17 | Germany | Hamburg | 6964 | 268 | 6058 | 683 | 53.5511 | 9.9937 | 2020-09-18 05:05:00 | Hamburg, Germany | ||
2513823 | 2513823 | 2020-08-27 | United Kingdom | Northern Ireland | 6964 | 873 | 0 | 6404 | 54.7877 | -6.4923 | 2020-08-28 04:28:11 | Northern Ireland, United Kingdom | ||
2991531 | 2991531 | 2020-08-24 | Russia | Yaroslavl Oblast | 6964 | 32 | 6159 | 773 | 57.77819760000001 | 39.0021095 | 2020-08-25 04:28:02 | Yaroslavl Oblast, Russia | ||
3237816 | 3237816 | 2020-07-10 | Bulgaria | 6964 | 267 | 3308 | 3389 | 42.7339 | 25.4858 | 2020-07-11 04:34:26 | Bulgaria | |||
573877 | 573877 | 2020-06-06 | Germany | Berlin | 6964 | 201 | 6455 | 336 | 52.52 | 13.405 | 2020-06-07 03:53:30 | Berlin, Germany | ||
3639066 | 3639066 | 2020-05-30 | Finland | 6964 | 305 | 5500 | 1010 | 61.92411 | 25.748151 | 2020-05-31 02:32:45 | Finland |
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]);