johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
44 rows where confirmed = 10119 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- US 39
- India 2
- South Sudan 2
- Chile 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1621976 | 1621976 | 2022-11-22 | US | Minnesota | Becker | 27005 | 10119 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-11-23 04:21:06 | Becker, Minnesota, US | |
3461864 | 3461864 | 2022-11-21 | US | Minnesota | Becker | 27005 | 10119 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-11-22 04:20:47 | Becker, Minnesota, US | |
1642049 | 1642049 | 2022-11-20 | US | Minnesota | Becker | 27005 | 10119 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-11-21 04:21:05 | Becker, Minnesota, US | |
2065606 | 2065606 | 2022-11-19 | US | Minnesota | Becker | 27005 | 10119 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-11-20 04:21:08 | Becker, Minnesota, US | |
1757000 | 1757000 | 2022-11-18 | US | Minnesota | Becker | 27005 | 10119 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-11-19 04:21:14 | Becker, Minnesota, US | |
3027993 | 3027993 | 2022-11-17 | US | Minnesota | Becker | 27005 | 10119 | 99 | 0 | 46.93479392 | -95.67158144 | 2022-11-18 04:21:15 | Becker, Minnesota, US | |
1370962 | 1370962 | 2022-09-21 | US | Arkansas | Baxter | 5005 | 10119 | 269 | 0 | 36.28784385 | -92.33782872 | 2022-09-22 04:22:56 | Baxter, Arkansas, US | |
3873054 | 3873054 | 2022-07-31 | US | Louisiana | Beauregard | 22011 | 10119 | 143 | 0 | 30.64836518 | -93.34173616 | 2022-08-01 04:21:03 | Beauregard, Louisiana, US | |
675808 | 675808 | 2022-07-30 | US | Louisiana | Beauregard | 22011 | 10119 | 143 | 0 | 30.64836518 | -93.34173616 | 2022-07-31 04:21:02 | Beauregard, Louisiana, US | |
1785007 | 1785007 | 2022-07-29 | US | Louisiana | Beauregard | 22011 | 10119 | 143 | 0 | 30.64836518 | -93.34173616 | 2022-07-30 04:20:42 | Beauregard, Louisiana, US | |
2421625 | 2421625 | 2022-07-15 | US | Puerto Rico | Cidra | 72041 | 10119 | 0 | 0 | 18.173559 | -66.161179 | 2022-07-16 04:21:05 | Cidra, Puerto Rico, US | |
3346558 | 3346558 | 2022-06-24 | India | Andaman and Nicobar Islands | 10119 | 129 | 0 | 11.225999 | 92.968178 | 2022-06-25 04:20:57 | Andaman and Nicobar Islands, India | |||
1764874 | 1764874 | 2022-06-20 | US | Louisiana | Vernon | 22115 | 10119 | 191 | 0 | 31.10884837 | -93.18153838 | 2022-06-21 04:20:56 | Vernon, Louisiana, US | |
949837 | 949837 | 2022-06-14 | US | Tennessee | Rhea | 47143 | 10119 | 161 | 0 | 35.60536161 | -84.93076643 | 2022-06-15 04:20:54 | Rhea, Tennessee, US | |
2238867 | 2238867 | 2022-06-12 | US | West Virginia | Greenbrier | 54025 | 10119 | 163 | 0 | 37.9463652 | -80.45335881 | 2022-06-13 04:21:14 | Greenbrier, West Virginia, US | |
3145065 | 3145065 | 2022-06-11 | US | West Virginia | Greenbrier | 54025 | 10119 | 163 | 0 | 37.9463652 | -80.45335881 | 2022-06-12 04:20:53 | Greenbrier, West Virginia, US | |
1947981 | 1947981 | 2022-06-10 | US | West Virginia | Greenbrier | 54025 | 10119 | 163 | 0 | 37.9463652 | -80.45335881 | 2022-06-11 04:21:01 | Greenbrier, West Virginia, US | |
3510355 | 3510355 | 2022-06-05 | US | Tennessee | Lincoln | 47103 | 10119 | 175 | 0 | 35.13738622 | -86.58910106 | 2022-06-06 04:20:57 | Lincoln, Tennessee, US | |
3732930 | 3732930 | 2022-04-03 | US | Pennsylvania | Pike | 42103 | 10119 | 95 | 0 | 41.33155042 | -75.03208106 | 2022-04-04 04:20:51 | Pike, Pennsylvania, US | |
502365 | 502365 | 2022-04-02 | US | Pennsylvania | Pike | 42103 | 10119 | 95 | 0 | 41.33155042 | -75.03208106 | 2022-04-03 04:20:48 | Pike, Pennsylvania, US | |
2322506 | 2322506 | 2022-03-16 | US | Texas | Medina | 48325 | 10119 | 195 | 0 | 29.355730100000002 | -99.11030298 | 2022-03-17 04:20:56 | Medina, Texas, US | |
2476229 | 2476229 | 2022-02-03 | US | New York | Tioga | 36107 | 10119 | 81 | 0 | 42.16852837 | -76.30835812 | 2022-02-04 04:21:10 | Tioga, New York, US | |
1475055 | 1475055 | 2022-01-17 | US | Tennessee | Franklin | 47051 | 10119 | 148 | 0 | 35.15634626 | -86.09201039 | 2022-01-18 04:21:04 | Franklin, Tennessee, US | |
2847338 | 2847338 | 2021-11-10 | US | Ohio | Lawrence | 39087 | 10119 | 180 | 0 | 38.59743452 | -82.53466552 | 2021-11-11 04:21:45 | Lawrence, Ohio, US | |
698784 | 698784 | 2021-11-04 | US | Alabama | Jackson | 1071 | 10119 | 191 | 0 | 34.78144169 | -85.99750489 | 2021-11-05 04:21:54 | Jackson, Alabama, US | |
493905 | 493905 | 2021-10-14 | US | New York | St. Lawrence | 36089 | 10119 | 124 | 0 | 44.4976179 | -75.06550039 | 2021-10-15 04:21:26 | St. Lawrence, New York, US | |
2461917 | 2461917 | 2021-10-06 | US | Texas | Hunt | 48231 | 10119 | 263 | 0 | 33.12351514 | -96.08551032 | 2021-10-07 04:21:36 | Hunt, Texas, US | |
2078606 | 2078606 | 2021-09-26 | US | Pennsylvania | Clearfield | 42033 | 10119 | 177 | 0 | 41.00110782 | -78.47592663 | 2021-09-27 04:21:16 | Clearfield, Pennsylvania, US | |
2176656 | 2176656 | 2021-08-22 | US | Indiana | Kosciusko | 18085 | 10119 | 125 | 0 | 41.24521668 | -85.86312322 | 2021-08-23 04:21:27 | Kosciusko, Indiana, US | |
3556752 | 3556752 | 2021-08-21 | US | Indiana | Kosciusko | 18085 | 10119 | 125 | 0 | 41.24521668 | -85.86312322 | 2021-08-22 04:21:29 | Kosciusko, Indiana, US | |
1855094 | 1855094 | 2021-08-20 | US | Indiana | Kosciusko | 18085 | 10119 | 125 | 0 | 41.24521668 | -85.86312322 | 2021-08-21 04:21:38 | Kosciusko, Indiana, US | |
3478192 | 3478192 | 2021-07-22 | US | Missouri | Cass | 29037 | 10119 | 118 | 0 | 38.64789422 | -94.353399 | 2021-07-23 04:21:29 | Cass, Missouri, US | |
297062 | 297062 | 2021-07-15 | US | Illinois | Vermilion | 17183 | 10119 | 151 | 0 | 40.18417171 | -87.73384359 | 2021-07-16 04:21:22 | Vermilion, Illinois, US | |
565257 | 565257 | 2021-06-22 | US | North Carolina | Burke | 37023 | 10119 | 162 | 0 | 35.74989637 | -81.70755735 | 2021-06-23 04:21:46 | Burke, North Carolina, US | |
3576926 | 3576926 | 2021-05-17 | US | North Carolina | Lincoln | 37109 | 10119 | 85 | 0 | 35.48508185 | -81.21740317 | 2021-05-18 04:20:33 | Lincoln, North Carolina, US | |
3088134 | 3088134 | 2021-04-05 | US | South Carolina | Sumter | 45085 | 10119 | 196 | 0 | 33.91826534 | -80.37942316 | 2021-04-06 04:20:32 | Sumter, South Carolina, US | |
3643835 | 3643835 | 2021-03-30 | South Sudan | 10119 | 108 | 9594 | 417 | 6.877000000000002 | 31.307 | 2021-03-31 04:26:25 | South Sudan | |||
3643506 | 3643506 | 2021-03-30 | India | Ladakh | 10119 | 130 | 9767 | 222 | 34.1526 | 77.5771 | 2021-03-31 04:26:25 | Ladakh, India | ||
1290288 | 1290288 | 2021-03-29 | South Sudan | 10119 | 108 | 9594 | 417 | 6.877000000000002 | 31.307 | 2021-03-30 04:26:23 | South Sudan | |||
3504131 | 3504131 | 2021-01-17 | US | Georgia | Coweta | 13077 | 10119 | 98 | 0 | 10021 | 33.35334302 | -84.76129976 | 2021-01-18 05:22:34 | Coweta, Georgia, US |
3764392 | 3764392 | 2020-12-28 | US | South Carolina | Florence | 45041 | 10119 | 251 | 0 | 9868 | 34.02361754 | -79.70189312 | 2020-12-29 05:22:37 | Florence, South Carolina, US |
2916949 | 2916949 | 2020-11-14 | US | Minnesota | Washington | 27163 | 10119 | 94 | 0 | 10025 | 45.03864533 | -92.88429635 | 2020-11-15 05:26:53 | Washington, Minnesota, US |
2849734 | 2849734 | 2020-09-18 | US | Hawaii | Honolulu | 15003 | 10119 | 95 | 0 | 10024 | 21.45803166 | -157.9712182 | 2020-09-19 04:22:00 | Honolulu, Hawaii, US |
415139 | 415139 | 2020-07-05 | Chile | Antofagasta | 10119 | 183 | 8113 | 1823 | -23.6509 | -70.3975 | 2020-07-06 04:33:57 | Antofagasta, Chile |
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]);