johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
85 rows where confirmed = 6347 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
329121 | 329121 | 2022-12-27 | US | Iowa | Jones | 19105 | 6347 | 80 | 0 | 42.12118609 | -91.13139641 | 2022-12-28 04:21:04 | Jones, Iowa, US | |
219194 | 219194 | 2022-12-26 | US | Iowa | Jones | 19105 | 6347 | 80 | 0 | 42.12118609 | -91.13139641 | 2022-12-27 04:21:07 | Jones, Iowa, US | |
3223651 | 3223651 | 2022-12-25 | US | Iowa | Jones | 19105 | 6347 | 80 | 0 | 42.12118609 | -91.13139641 | 2022-12-26 04:21:06 | Jones, Iowa, US | |
1019565 | 1019565 | 2022-12-24 | US | Iowa | Jones | 19105 | 6347 | 80 | 0 | 42.12118609 | -91.13139641 | 2022-12-25 04:21:04 | Jones, Iowa, US | |
691588 | 691588 | 2022-12-23 | US | Iowa | Jones | 19105 | 6347 | 80 | 0 | 42.12118609 | -91.13139641 | 2022-12-24 04:21:02 | Jones, Iowa, US | |
2180798 | 2180798 | 2022-12-22 | US | Iowa | Jones | 19105 | 6347 | 80 | 0 | 42.12118609 | -91.13139641 | 2022-12-23 04:21:04 | Jones, Iowa, US | |
452602 | 452602 | 2022-12-21 | US | Iowa | Jones | 19105 | 6347 | 80 | 0 | 42.12118609 | -91.13139641 | 2022-12-22 04:20:56 | Jones, Iowa, US | |
2954104 | 2954104 | 2022-12-20 | US | Puerto Rico | Adjuntas | 72001 | 6347 | 0 | 0 | 18.180117 | -66.754367 | 2022-12-21 04:21:03 | Adjuntas, Puerto Rico, US | |
2326773 | 2326773 | 2022-08-24 | US | Virginia | Waynesboro | 51820 | 6347 | 70 | 0 | 38.06451466 | -78.90293905 | 2022-08-25 04:21:13 | Waynesboro, Virginia, US | |
1346964 | 1346964 | 2022-08-10 | US | Colorado | Morgan | 8087 | 6347 | 138 | 0 | 40.2627981 | -103.8093302 | 2022-08-11 04:20:49 | Morgan, Colorado, US | |
898865 | 898865 | 2022-07-24 | US | Puerto Rico | Aguas Buenas | 72007 | 6347 | 0 | 0 | 18.251619 | -66.126806 | 2022-07-25 04:20:51 | Aguas Buenas, Puerto Rico, US | |
1212049 | 1212049 | 2022-07-11 | US | Arkansas | Jackson | 5067 | 6347 | 64 | 0 | 35.59802983 | -91.21494602 | 2022-07-12 04:20:51 | Jackson, Arkansas, US | |
1203232 | 1203232 | 2022-07-06 | US | Virginia | Waynesboro | 51820 | 6347 | 68 | 0 | 38.06451466 | -78.90293905 | 2022-07-07 04:20:55 | Waynesboro, Virginia, US | |
3968107 | 3968107 | 2022-07-05 | US | Maine | Franklin | 23007 | 6347 | 63 | 0 | 44.97330019 | -70.44381045 | 2022-07-06 04:20:58 | Franklin, Maine, US | |
3079618 | 3079618 | 2022-07-04 | US | Maine | Franklin | 23007 | 6347 | 63 | 0 | 44.97330019 | -70.44381045 | 2022-07-05 04:20:45 | Franklin, Maine, US | |
1768900 | 1768900 | 2022-07-03 | US | Maine | Franklin | 23007 | 6347 | 63 | 0 | 44.97330019 | -70.44381045 | 2022-07-04 04:20:54 | Franklin, Maine, US | |
3366886 | 3366886 | 2022-07-02 | US | Maine | Franklin | 23007 | 6347 | 63 | 0 | 44.97330019 | -70.44381045 | 2022-07-03 04:20:59 | Franklin, Maine, US | |
3985034 | 3985034 | 2022-06-15 | US | North Dakota | Rolette | 38079 | 6347 | 43 | 0 | 48.77245354 | -99.84097493 | 2022-06-16 04:20:55 | Rolette, North Dakota, US | |
1110578 | 1110578 | 2022-05-21 | US | Illinois | Jersey | 17083 | 6347 | 72 | 0 | 39.08869046 | -90.35393073 | 2022-05-22 04:20:52 | Jersey, Illinois, US | |
1170202 | 1170202 | 2022-05-20 | US | Illinois | Jersey | 17083 | 6347 | 72 | 0 | 39.08869046 | -90.35393073 | 2022-05-21 04:20:58 | Jersey, Illinois, US | |
3725628 | 3725628 | 2022-04-25 | US | Virginia | Winchester | 51840 | 6347 | 79 | 0 | 39.17054517 | -78.17325058 | 2022-04-26 04:20:51 | Winchester, Virginia, US | |
2643061 | 2643061 | 2022-02-14 | US | Kansas | Labette | 20099 | 6347 | 71 | 0 | 37.19113093 | -95.29849679 | 2022-02-15 04:21:09 | Labette, Kansas, US | |
187378 | 187378 | 2022-02-13 | US | Kansas | Labette | 20099 | 6347 | 71 | 0 | 37.19113093 | -95.29849679 | 2022-02-14 04:20:51 | Labette, Kansas, US | |
317224 | 317224 | 2022-02-12 | US | Kansas | Labette | 20099 | 6347 | 71 | 0 | 37.19113093 | -95.29849679 | 2022-02-13 04:21:00 | Labette, Kansas, US | |
234550 | 234550 | 2022-02-11 | US | Kansas | Labette | 20099 | 6347 | 71 | 0 | 37.19113093 | -95.29849679 | 2022-02-12 04:21:06 | Labette, Kansas, US | |
1465788 | 1465788 | 2022-02-10 | US | Minnesota | Brown | 27015 | 6347 | 72 | 0 | 44.24205652 | -94.72562874 | 2022-02-11 04:21:09 | Brown, Minnesota, US | |
1465392 | 1465392 | 2022-02-10 | US | Kansas | Labette | 20099 | 6347 | 71 | 0 | 37.19113093 | -95.29849679 | 2022-02-11 04:21:09 | Labette, Kansas, US | |
3075353 | 3075353 | 2022-02-09 | US | Kansas | Labette | 20099 | 6347 | 71 | 0 | 37.19113093 | -95.29849679 | 2022-02-10 04:21:14 | Labette, Kansas, US | |
1363660 | 1363660 | 2022-02-08 | US | Kansas | Labette | 20099 | 6347 | 71 | 0 | 37.19113093 | -95.29849679 | 2022-02-09 04:21:04 | Labette, Kansas, US | |
1362901 | 1362901 | 2022-02-08 | US | California | Glenn | 6021 | 6347 | 39 | 0 | 39.59875897 | -122.3938452 | 2022-02-09 04:21:04 | Glenn, California, US | |
72398 | 72398 | 2022-02-07 | US | Kansas | Labette | 20099 | 6347 | 71 | 0 | 37.19113093 | -95.29849679 | 2022-02-08 04:21:15 | Labette, Kansas, US | |
462787 | 462787 | 2022-02-02 | US | Virginia | Salem | 51775 | 6347 | 88 | 0 | 37.2836193 | -80.06219455 | 2022-02-03 04:21:21 | Salem, Virginia, US | |
3301961 | 3301961 | 2022-01-30 | US | Minnesota | Pine | 27115 | 6347 | 58 | 0 | 46.12105238 | -92.74070188 | 2022-01-31 04:21:09 | Pine, Minnesota, US | |
3063752 | 3063752 | 2022-01-29 | US | Minnesota | Pine | 27115 | 6347 | 58 | 0 | 46.12105238 | -92.74070188 | 2022-01-30 04:21:26 | Pine, Minnesota, US | |
3811686 | 3811686 | 2022-01-28 | US | Minnesota | Pine | 27115 | 6347 | 58 | 0 | 46.12105238 | -92.74070188 | 2022-01-29 04:21:10 | Pine, Minnesota, US | |
801371 | 801371 | 2021-12-22 | US | Tennessee | Giles | 47055 | 6347 | 146 | 0 | 35.20222469 | -87.03992678 | 2021-12-23 04:21:21 | Giles, Tennessee, US | |
1662338 | 1662338 | 2021-12-12 | US | Missouri | Howell | 29091 | 6347 | 173 | 0 | 36.77383887 | -91.88683935 | 2021-12-13 04:22:02 | Howell, Missouri, US | |
1667694 | 1667694 | 2021-12-11 | US | Texas | Wharton | 48481 | 6347 | 190 | 0 | 29.27765923 | -96.22319248 | 2021-12-12 04:22:12 | Wharton, Texas, US | |
1091 | 1091 | 2021-12-02 | US | Georgia | Bryan | 13029 | 6347 | 75 | 0 | 32.00979311 | -81.44002948 | 2021-12-03 04:23:05 | Bryan, Georgia, US | |
1145302 | 1145302 | 2021-12-01 | US | Alabama | Franklin | 1059 | 6347 | 108 | 0 | 34.44235334 | -87.84289505 | 2021-12-02 04:22:37 | Franklin, Alabama, US | |
1232580 | 1232580 | 2021-11-28 | US | Idaho | Nez Perce | 16069 | 6347 | 104 | 0 | 46.32638236 | -116.75009750000001 | 2021-11-29 04:22:30 | Nez Perce, Idaho, US | |
1359287 | 1359287 | 2021-11-27 | US | Idaho | Nez Perce | 16069 | 6347 | 104 | 0 | 46.32638236 | -116.75009750000001 | 2021-11-28 04:22:43 | Nez Perce, Idaho, US | |
759278 | 759278 | 2021-11-26 | US | Idaho | Nez Perce | 16069 | 6347 | 104 | 0 | 46.32638236 | -116.75009750000001 | 2021-11-27 04:22:45 | Nez Perce, Idaho, US | |
699950 | 699950 | 2021-11-04 | US | Louisiana | Vernon | 22115 | 6347 | 161 | 0 | 31.10884837 | -93.18153838 | 2021-11-05 04:21:54 | Vernon, Louisiana, US | |
535228 | 535228 | 2021-10-27 | US | Arkansas | Independence | 5063 | 6347 | 158 | 0 | 35.74242707 | -91.57001641 | 2021-10-28 04:22:08 | Independence, Arkansas, US | |
2126055 | 2126055 | 2021-10-21 | US | North Carolina | Davie | 37059 | 6347 | 73 | 0 | 35.93099927 | -80.54496571 | 2021-10-22 04:21:14 | Davie, North Carolina, US | |
598779 | 598779 | 2021-10-19 | US | Indiana | Knox | 18083 | 6347 | 106 | 0 | 38.68861576 | -87.4194665 | 2021-10-20 04:21:00 | Knox, Indiana, US | |
935899 | 935899 | 2021-10-16 | US | Indiana | Huntington | 18069 | 6347 | 99 | 0 | 40.82907273 | -85.48822092 | 2021-10-17 04:21:29 | Huntington, Indiana, US | |
1492108 | 1492108 | 2021-10-12 | US | Arkansas | Miller | 5091 | 6347 | 115 | 0 | 33.31403423 | -93.89285258 | 2021-10-13 04:20:51 | Miller, Arkansas, US | |
1336116 | 1336116 | 2021-09-28 | US | Mississippi | Pontotoc | 28115 | 6347 | 93 | 0 | 34.226046000000004 | -89.03636807 | 2021-09-29 04:21:45 | Pontotoc, Mississippi, US | |
3555927 | 3555927 | 2021-08-21 | Sierra Leone | 6347 | 121 | 0 | 8.460555000000001 | -11.779889 | 2021-08-22 04:21:29 | Sierra Leone | ||||
1854269 | 1854269 | 2021-08-20 | Sierra Leone | 6347 | 121 | 0 | 8.460555000000001 | -11.779889 | 2021-08-21 04:21:38 | Sierra Leone | ||||
511976 | 511976 | 2021-08-19 | Sierra Leone | 6347 | 121 | 0 | 8.460555000000001 | -11.779889 | 2021-08-20 04:21:33 | Sierra Leone | ||||
1607532 | 1607532 | 2021-08-16 | US | Virginia | Augusta | 51015 | 6347 | 81 | 0 | 38.16404586 | -79.12461614 | 2021-08-17 04:21:49 | Augusta, Virginia, US | |
3631843 | 3631843 | 2021-07-14 | Eritrea | 6347 | 30 | 5948 | 369 | 15.1794 | 39.7823 | 2021-07-15 04:21:48 | Eritrea | |||
402485 | 402485 | 2021-06-29 | US | New York | Cayuga | 36011 | 6347 | 92 | 0 | 42.91261714 | -76.55731592 | 2021-06-30 04:21:41 | Cayuga, New York, US | |
2107109 | 2107109 | 2021-06-01 | US | Tennessee | Roane | 47145 | 6347 | 105 | 0 | 35.84923189 | -84.52458689 | 2021-06-02 04:24:34 | Roane, Tennessee, US | |
1189100 | 1189100 | 2021-05-31 | US | Alabama | Colbert | 1033 | 6347 | 137 | 0 | 34.69847452 | -87.80168544 | 2021-06-01 04:23:09 | Colbert, Alabama, US | |
3089777 | 3089777 | 2021-05-30 | US | Alabama | Colbert | 1033 | 6347 | 137 | 0 | 34.69847452 | -87.80168544 | 2021-05-31 03:08:59 | Colbert, Alabama, US | |
51146 | 51146 | 2021-05-29 | US | Alabama | Colbert | 1033 | 6347 | 137 | 0 | 34.69847452 | -87.80168544 | 2021-05-30 04:20:55 | Colbert, Alabama, US | |
20725 | 20725 | 2021-05-28 | US | Alabama | Colbert | 1033 | 6347 | 137 | 0 | 34.69847452 | -87.80168544 | 2021-05-29 04:20:41 | Colbert, Alabama, US | |
1807100 | 1807100 | 2021-05-27 | US | Alabama | Colbert | 1033 | 6347 | 137 | 0 | 34.69847452 | -87.80168544 | 2021-05-28 04:20:36 | Colbert, Alabama, US | |
3704376 | 3704376 | 2021-04-27 | US | New York | Sullivan | 36105 | 6347 | 71 | 0 | 41.71579493 | -74.76394559 | 2021-04-28 04:20:32 | Sullivan, New York, US | |
3701945 | 3701945 | 2021-04-27 | Colombia | Arauca | 6347 | 185 | 5939 | 223 | 7.0762 | -70.7105 | 2021-04-28 04:20:32 | Arauca, Colombia | ||
641319 | 641319 | 2021-03-31 | US | Virginia | Rockingham | 51165 | 6347 | 103 | 0 | 38.51006137 | -78.87260325 | 2021-04-01 04:27:05 | Rockingham, Virginia, US | |
55143 | 55143 | 2021-03-07 | US | Alabama | Autauga | 1001 | 6347 | 92 | 0 | 32.53952745 | -86.64408227 | 2021-03-08 05:24:48 | Autauga, Alabama, US | |
3539862 | 3539862 | 2021-02-12 | US | Alabama | Walker | 1127 | 6347 | 235 | 0 | 6112 | 33.80270512 | -87.30027177 | 2021-02-13 05:22:12 | Walker, Alabama, US |
2640079 | 2640079 | 2021-02-11 | US | North Carolina | Stanly | 37167 | 6347 | 103 | 0 | 6244 | 35.31647813 | -80.25093221 | 2021-02-12 05:23:29 | Stanly, North Carolina, US |
1679838 | 1679838 | 2021-02-01 | US | Virginia | Montgomery | 51121 | 6347 | 64 | 0 | 6283 | 37.17746986 | -80.37868691 | 2021-02-02 05:22:49 | Montgomery, Virginia, US |
435755 | 435755 | 2021-01-21 | US | Alabama | Talladega | 1121 | 6347 | 109 | 0 | 6238 | 33.37823223 | -86.16886178 | 2021-01-22 05:22:10 | Talladega, Alabama, US |
766898 | 766898 | 2020-12-29 | US | California | Sutter | 6101 | 6347 | 50 | 0 | 6300 | 39.03417539 | -121.6945899 | 2020-12-30 05:22:34 | Sutter, California, US |
2406900 | 2406900 | 2020-12-23 | Mali | 6347 | 229 | 3927 | 2191 | 17.570692 | -3.996166000000001 | 2020-12-24 05:23:04 | Mali | |||
1600976 | 1600976 | 2020-12-10 | US | Georgia | Carroll | 13045 | 6347 | 103 | 0 | 6244 | 33.58138199 | -85.07976677 | 2020-12-11 05:26:59 | Carroll, Georgia, US |
2347742 | 2347742 | 2020-12-07 | Sweden | Sormland | 6347 | 281 | 0 | 6066 | 59.0336 | 16.7519 | 2020-12-08 05:27:42 | Sormland, Sweden | ||
1006612 | 1006612 | 2020-12-06 | Sweden | Sormland | 6347 | 281 | 0 | 6066 | 59.0336 | 16.7519 | 2020-12-07 05:26:14 | Sormland, Sweden | ||
1632621 | 1632621 | 2020-12-05 | Sweden | Sormland | 6347 | 281 | 0 | 6066 | 59.0336 | 16.7519 | 2020-12-06 05:26:18 | Sormland, Sweden | ||
3860149 | 3860149 | 2020-12-04 | Sweden | Sormland | 6347 | 281 | 0 | 6066 | 59.0336 | 16.7519 | 2020-12-05 05:27:36 | Sormland, Sweden | ||
2936370 | 2936370 | 2020-11-28 | US | Indiana | Vigo | 18167 | 6347 | 112 | 0 | 6235 | 39.42944561 | -87.39169027 | 2020-11-29 05:25:55 | Vigo, Indiana, US |
1794706 | 1794706 | 2020-10-19 | Mexico | Campeche | 6347 | 852 | 5449 | 46 | 19.8301 | -90.5349 | 2020-10-20 04:24:22 | Campeche, Mexico | ||
3782568 | 3782568 | 2020-10-13 | US | Florida | Bay | 12005 | 6347 | 122 | 0 | 6225 | 30.26548745 | -85.62122584 | 2020-10-14 04:24:05 | Bay, Florida, US |
1525134 | 1525134 | 2020-08-28 | US | Missouri | St. Louis City | 29510 | 6347 | 210 | 0 | 6137 | 38.63555736 | -90.24349225 | 2020-08-29 04:28:19 | St. Louis City, Missouri, US |
2808394 | 2808394 | 2020-08-02 | Zambia | 6347 | 170 | 4493 | 1684 | -13.133897 | 27.849332 | 2020-08-03 04:34:35 | Zambia | |||
176153 | 176153 | 2020-07-27 | US | Minnesota | Ramsey | 27123 | 6347 | 254 | 0 | 6093 | 45.01625271 | -93.09872295 | 2020-07-28 04:58:43 | Ramsey, Minnesota, US |
1210889 | 1210889 | 2020-06-09 | Brazil | Roraima | 6347 | 182 | 1569 | 4319 | -2.7376 | -62.0751 | 2020-06-10 04:07:00 | Roraima, Brazil | ||
3636382 | 3636382 | 2020-05-30 | US | Pennsylvania | Delaware | 42045 | 6347 | 558 | 0 | 5789 | 39.91680171 | -75.40243663 | 2020-05-31 02:32:45 | Delaware, Pennsylvania, 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]);