johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
130 rows where confirmed = 10189 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752774 | 2752774 | 2022-12-29 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-30 04:21:04 | Eritrea | ||||
1073780 | 1073780 | 2022-12-28 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-29 04:21:01 | Eritrea | ||||
327777 | 327777 | 2022-12-27 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-28 04:21:04 | Eritrea | ||||
217850 | 217850 | 2022-12-26 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-27 04:21:07 | Eritrea | ||||
3222307 | 3222307 | 2022-12-25 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-26 04:21:06 | Eritrea | ||||
1018221 | 1018221 | 2022-12-24 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-25 04:21:04 | Eritrea | ||||
690244 | 690244 | 2022-12-23 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-24 04:21:02 | Eritrea | ||||
2179454 | 2179454 | 2022-12-22 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-23 04:21:04 | Eritrea | ||||
451258 | 451258 | 2022-12-21 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-22 04:20:56 | Eritrea | ||||
2951257 | 2951257 | 2022-12-20 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-21 04:21:03 | Eritrea | ||||
3173659 | 3173659 | 2022-12-19 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-20 04:21:04 | Eritrea | ||||
1628176 | 1628176 | 2022-12-18 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-19 04:21:03 | Eritrea | ||||
503555 | 503555 | 2022-12-17 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-18 04:21:03 | Eritrea | ||||
3324127 | 3324127 | 2022-12-16 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-17 04:21:04 | Eritrea | ||||
542639 | 542639 | 2022-12-15 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-16 04:21:01 | Eritrea | ||||
348167 | 348167 | 2022-12-14 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-15 04:20:58 | Eritrea | ||||
307755 | 307755 | 2022-12-13 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-14 04:21:04 | Eritrea | ||||
1148816 | 1148816 | 2022-12-12 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-13 04:21:01 | Eritrea | ||||
868670 | 868670 | 2022-12-11 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-12 04:21:01 | Eritrea | ||||
257200 | 257200 | 2022-12-10 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-11 04:20:50 | Eritrea | ||||
3935914 | 3935914 | 2022-12-09 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-10 04:21:02 | Eritrea | ||||
3377246 | 3377246 | 2022-12-08 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-09 04:21:05 | Eritrea | ||||
1984517 | 1984517 | 2022-12-07 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-08 04:21:07 | Eritrea | ||||
3714040 | 3714040 | 2022-12-06 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-07 04:20:58 | Eritrea | ||||
2414745 | 2414745 | 2022-12-05 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-06 04:21:03 | Eritrea | ||||
718353 | 718353 | 2022-12-04 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-05 04:20:58 | Eritrea | ||||
2816642 | 2816642 | 2022-12-03 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-04 04:20:56 | Eritrea | ||||
833498 | 833498 | 2022-12-02 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-03 04:21:02 | Eritrea | ||||
2136028 | 2136028 | 2022-12-01 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-02 04:21:07 | Eritrea | ||||
1964444 | 1964444 | 2022-11-30 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-12-01 04:21:03 | Eritrea | ||||
2556458 | 2556458 | 2022-11-29 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-30 04:21:07 | Eritrea | ||||
1239532 | 1239532 | 2022-11-28 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-29 04:21:05 | Eritrea | ||||
3551520 | 3551520 | 2022-11-27 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-28 04:21:02 | Eritrea | ||||
2100000 | 2100000 | 2022-11-26 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-27 04:21:05 | Eritrea | ||||
487491 | 487491 | 2022-11-25 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-26 04:21:11 | Eritrea | ||||
3523320 | 3523320 | 2022-11-24 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-25 04:21:06 | Eritrea | ||||
3312103 | 3312103 | 2022-11-23 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-24 04:21:09 | Eritrea | ||||
1620645 | 1620645 | 2022-11-22 | US | Alabama | Dallas | 1047 | 10189 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-23 04:21:06 | Dallas, Alabama, US | |
1620144 | 1620144 | 2022-11-22 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-23 04:21:06 | Eritrea | ||||
3460533 | 3460533 | 2022-11-21 | US | Alabama | Dallas | 1047 | 10189 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-22 04:20:47 | Dallas, Alabama, US | |
3460032 | 3460032 | 2022-11-21 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-22 04:20:47 | Eritrea | ||||
1640718 | 1640718 | 2022-11-20 | US | Alabama | Dallas | 1047 | 10189 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-21 04:21:05 | Dallas, Alabama, US | |
1640217 | 1640217 | 2022-11-20 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-21 04:21:05 | Eritrea | ||||
2064275 | 2064275 | 2022-11-19 | US | Alabama | Dallas | 1047 | 10189 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-20 04:21:08 | Dallas, Alabama, US | |
2063774 | 2063774 | 2022-11-19 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-20 04:21:08 | Eritrea | ||||
1755669 | 1755669 | 2022-11-18 | US | Alabama | Dallas | 1047 | 10189 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-19 04:21:14 | Dallas, Alabama, US | |
1755168 | 1755168 | 2022-11-18 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-19 04:21:14 | Eritrea | ||||
3026662 | 3026662 | 2022-11-17 | US | Alabama | Dallas | 1047 | 10189 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-18 04:21:15 | Dallas, Alabama, US | |
3026161 | 3026161 | 2022-11-17 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-18 04:21:15 | Eritrea | ||||
2486373 | 2486373 | 2022-11-16 | US | Alabama | Dallas | 1047 | 10189 | 255 | 0 | 32.32688101 | -87.1086671 | 2022-11-17 04:21:11 | Dallas, Alabama, US | |
2485872 | 2485872 | 2022-11-16 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-17 04:21:11 | Eritrea | ||||
291883 | 291883 | 2022-11-15 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-16 04:21:09 | Eritrea | ||||
3596913 | 3596913 | 2022-11-14 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-15 04:21:16 | Eritrea | ||||
311771 | 311771 | 2022-11-13 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-14 04:21:09 | Eritrea | ||||
62932 | 62932 | 2022-11-12 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-13 04:21:14 | Eritrea | ||||
2927094 | 2927094 | 2022-11-11 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-12 04:20:41 | Eritrea | ||||
2505930 | 2505930 | 2022-11-10 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-11 04:21:22 | Eritrea | ||||
2430805 | 2430805 | 2022-11-09 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-10 04:21:16 | Eritrea | ||||
479461 | 479461 | 2022-11-08 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-09 04:21:22 | Eritrea | ||||
2438611 | 2438611 | 2022-11-07 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-08 04:21:21 | Eritrea | ||||
1049709 | 1049709 | 2022-11-06 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-07 04:21:26 | Eritrea | ||||
617733 | 617733 | 2022-11-05 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-06 04:21:24 | Eritrea | ||||
1022237 | 1022237 | 2022-11-04 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-05 04:21:52 | Eritrea | ||||
431228 | 431228 | 2022-11-03 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-04 04:22:11 | Eritrea | ||||
849470 | 849470 | 2022-11-02 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-03 04:22:05 | Eritrea | ||||
710321 | 710321 | 2022-11-01 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-02 04:22:09 | Eritrea | ||||
3284770 | 3284770 | 2022-10-31 | Eritrea | 10189 | 103 | 0 | 15.1794 | 39.7823 | 2022-11-01 04:22:36 | Eritrea | ||||
3755072 | 3755072 | 2022-10-13 | US | Maryland | Worcester | 24047 | 10189 | 173 | 0 | 38.21274277 | -75.33200012 | 2022-10-14 04:22:28 | Worcester, Maryland, US | |
1811244 | 1811244 | 2022-10-05 | US | Arkansas | Baxter | 5005 | 10189 | 270 | 0 | 36.28784385 | -92.33782872 | 2022-10-06 04:21:22 | Baxter, Arkansas, US | |
373317 | 373317 | 2022-09-13 | US | Indiana | Miami | 18103 | 10189 | 165 | 0 | 40.76940965 | -86.04525048 | 2022-09-14 04:20:44 | Miami, Indiana, US | |
2395919 | 2395919 | 2022-09-12 | US | Indiana | Miami | 18103 | 10189 | 165 | 0 | 40.76940965 | -86.04525048 | 2022-09-13 04:20:57 | Miami, Indiana, US | |
3548609 | 3548609 | 2022-09-01 | US | Indiana | Jasper | 18073 | 10189 | 155 | 0 | 41.02078733 | -87.11553319 | 2022-09-02 04:21:07 | Jasper, Indiana, US | |
2344529 | 2344529 | 2022-08-31 | US | Indiana | Jasper | 18073 | 10189 | 155 | 0 | 41.02078733 | -87.11553319 | 2022-09-01 04:21:03 | Jasper, Indiana, US | |
632266 | 632266 | 2022-07-12 | US | North Carolina | Person | 37145 | 10189 | 110 | 0 | 36.38989032 | -78.97217358 | 2022-07-13 04:20:58 | Person, North Carolina, US | |
1214370 | 1214370 | 2022-07-11 | US | South Carolina | Dillon | 45033 | 10189 | 145 | 0 | 34.39007791 | -79.37741872 | 2022-07-12 04:20:51 | Dillon, South Carolina, US | |
1213910 | 1213910 | 2022-07-11 | US | North Carolina | Person | 37145 | 10189 | 110 | 0 | 36.38989032 | -78.97217358 | 2022-07-12 04:20:51 | Person, North Carolina, US | |
2791852 | 2791852 | 2022-07-10 | US | South Carolina | Dillon | 45033 | 10189 | 145 | 0 | 34.39007791 | -79.37741872 | 2022-07-11 04:20:46 | Dillon, South Carolina, US | |
2791392 | 2791392 | 2022-07-10 | US | North Carolina | Person | 37145 | 10189 | 110 | 0 | 36.38989032 | -78.97217358 | 2022-07-11 04:20:46 | Person, North Carolina, US | |
144805 | 144805 | 2022-07-09 | US | South Carolina | Dillon | 45033 | 10189 | 145 | 0 | 34.39007791 | -79.37741872 | 2022-07-10 04:20:54 | Dillon, South Carolina, US | |
144345 | 144345 | 2022-07-09 | US | North Carolina | Person | 37145 | 10189 | 110 | 0 | 36.38989032 | -78.97217358 | 2022-07-10 04:20:54 | Person, North Carolina, US | |
1419905 | 1419905 | 2022-07-08 | US | South Carolina | Dillon | 45033 | 10189 | 145 | 0 | 34.39007791 | -79.37741872 | 2022-07-09 04:20:59 | Dillon, South Carolina, US | |
1419445 | 1419445 | 2022-07-08 | US | North Carolina | Person | 37145 | 10189 | 110 | 0 | 36.38989032 | -78.97217358 | 2022-07-09 04:20:59 | Person, North Carolina, US | |
2743830 | 2743830 | 2022-07-07 | US | South Carolina | Dillon | 45033 | 10189 | 145 | 0 | 34.39007791 | -79.37741872 | 2022-07-08 04:20:56 | Dillon, South Carolina, US | |
2743370 | 2743370 | 2022-07-07 | US | North Carolina | Person | 37145 | 10189 | 110 | 0 | 36.38989032 | -78.97217358 | 2022-07-08 04:20:56 | Person, North Carolina, US | |
1202625 | 1202625 | 2022-07-06 | US | South Carolina | Dillon | 45033 | 10189 | 145 | 0 | 34.39007791 | -79.37741872 | 2022-07-07 04:20:55 | Dillon, South Carolina, US | |
1202165 | 1202165 | 2022-07-06 | US | North Carolina | Person | 37145 | 10189 | 110 | 0 | 36.38989032 | -78.97217358 | 2022-07-07 04:20:55 | Person, North Carolina, US | |
1946727 | 1946727 | 2022-06-10 | US | New York | Chenango | 36017 | 10189 | 123 | 0 | 42.49430041 | -75.60887553 | 2022-06-11 04:21:01 | Chenango, New York, US | |
3593158 | 3593158 | 2022-05-23 | Netherlands | Sint Maarten | 10189 | 86 | 0 | 18.0425 | -63.0548 | 2022-05-24 04:20:57 | Sint Maarten, Netherlands | |||
1109706 | 1109706 | 2022-05-21 | Netherlands | Sint Maarten | 10189 | 86 | 0 | 18.0425 | -63.0548 | 2022-05-22 04:20:52 | Sint Maarten, Netherlands | |||
1169330 | 1169330 | 2022-05-20 | Netherlands | Sint Maarten | 10189 | 86 | 0 | 18.0425 | -63.0548 | 2022-05-21 04:20:58 | Sint Maarten, Netherlands | |||
3896093 | 3896093 | 2022-05-19 | Netherlands | Sint Maarten | 10189 | 86 | 0 | 18.0425 | -63.0548 | 2022-05-20 04:20:57 | Sint Maarten, Netherlands | |||
1184877 | 1184877 | 2022-05-18 | Netherlands | Sint Maarten | 10189 | 86 | 0 | 18.0425 | -63.0548 | 2022-05-19 04:20:54 | Sint Maarten, Netherlands | |||
3582774 | 3582774 | 2022-05-17 | Netherlands | Sint Maarten | 10189 | 86 | 0 | 18.0425 | -63.0548 | 2022-05-18 04:20:50 | Sint Maarten, Netherlands | |||
2087389 | 2087389 | 2022-05-15 | US | Virginia | York | 51199 | 10189 | 109 | 0 | 37.24374789 | -76.54412815 | 2022-05-16 04:20:47 | York, Virginia, US | |
3358099 | 3358099 | 2022-05-14 | US | Virginia | York | 51199 | 10189 | 109 | 0 | 37.24374789 | -76.54412815 | 2022-05-15 04:20:53 | York, Virginia, US | |
661744 | 661744 | 2022-05-13 | US | Virginia | York | 51199 | 10189 | 109 | 0 | 37.24374789 | -76.54412815 | 2022-05-14 04:20:48 | York, Virginia, US | |
3419150 | 3419150 | 2022-04-17 | US | New York | Columbia | 36021 | 10189 | 140 | 0 | 42.24819348 | -73.63089095 | 2022-04-18 04:21:12 | Columbia, New York, US | |
306099 | 306099 | 2022-04-16 | US | New York | Columbia | 36021 | 10189 | 140 | 0 | 42.24819348 | -73.63089095 | 2022-04-17 04:20:59 | Columbia, New York, US | |
303711 | 303711 | 2022-04-16 | Colombia | San Andres y Providencia | 10189 | 155 | 0 | 12.5567 | -81.7185 | 2022-04-17 04:20:59 | San Andres y Providencia, Colombia | |||
2669656 | 2669656 | 2022-04-15 | Colombia | San Andres y Providencia | 10189 | 155 | 0 | 12.5567 | -81.7185 | 2022-04-16 04:20:48 | San Andres y Providencia, Colombia |
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]);