johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
10,231 rows where confirmed = 6 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 9,774
- France 127
- Vanuatu 48
- Netherlands 38
- United Kingdom 23
- Summer Olympics 2020 21
- Colombia 19
- Japan 15
- Canada 12
- Mauritania 9
- Australia 7
- Benin 7
- Mainland China 7
- Belarus 6
- Cabo Verde 6
- Liberia 6
- Holy See 5
- Botswana 4
- Equatorial Guinea 4
- Nicaragua 4
- Pakistan 4
- Denmark 3
- Eritrea 3
- New Zealand 3
- Oman 3
- Sierra Leone 3
- Tanzania 3
- Azerbaijan 2
- Bhutan 2
- Cyprus 2
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753347 | 2753347 | 2022-12-29 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Alaska, US | |
1074353 | 1074353 | 2022-12-28 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Alaska, US | |
328350 | 328350 | 2022-12-27 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Alaska, US | |
218423 | 218423 | 2022-12-26 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Alaska, US | |
3222880 | 3222880 | 2022-12-25 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-26 04:21:06 | Unassigned, Alaska, US | |
1018794 | 1018794 | 2022-12-24 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-25 04:21:04 | Unassigned, Alaska, US | |
690817 | 690817 | 2022-12-23 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-24 04:21:02 | Unassigned, Alaska, US | |
2180027 | 2180027 | 2022-12-22 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-23 04:21:04 | Unassigned, Alaska, US | |
451831 | 451831 | 2022-12-21 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-22 04:20:56 | Unassigned, Alaska, US | |
2951830 | 2951830 | 2022-12-20 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-21 04:21:03 | Unassigned, Alaska, US | |
3174232 | 3174232 | 2022-12-19 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-20 04:21:04 | Unassigned, Alaska, US | |
1628749 | 1628749 | 2022-12-18 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-19 04:21:03 | Unassigned, Alaska, US | |
504128 | 504128 | 2022-12-17 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-18 04:21:03 | Unassigned, Alaska, US | |
3324700 | 3324700 | 2022-12-16 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-17 04:21:04 | Unassigned, Alaska, US | |
543805 | 543805 | 2022-12-15 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-12-16 04:21:01 | Out of IL, Illinois, US | |
543212 | 543212 | 2022-12-15 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-16 04:21:01 | Unassigned, Alaska, US | |
349333 | 349333 | 2022-12-14 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-12-15 04:20:58 | Out of IL, Illinois, US | |
348740 | 348740 | 2022-12-14 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-15 04:20:58 | Unassigned, Alaska, US | |
308328 | 308328 | 2022-12-13 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-14 04:21:04 | Unassigned, Alaska, US | |
1149389 | 1149389 | 2022-12-12 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-13 04:21:01 | Unassigned, Alaska, US | |
869243 | 869243 | 2022-12-11 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-12 04:21:01 | Unassigned, Alaska, US | |
257773 | 257773 | 2022-12-10 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-11 04:20:50 | Unassigned, Alaska, US | |
3936487 | 3936487 | 2022-12-09 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-10 04:21:02 | Unassigned, Alaska, US | |
3377819 | 3377819 | 2022-12-08 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-09 04:21:05 | Unassigned, Alaska, US | |
1985090 | 1985090 | 2022-12-07 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-08 04:21:07 | Unassigned, Alaska, US | |
3715740 | 3715740 | 2022-12-06 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-12-07 04:20:58 | Unassigned, Maine, US | |
3714613 | 3714613 | 2022-12-06 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-07 04:20:58 | Unassigned, Alaska, US | |
2416445 | 2416445 | 2022-12-05 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-12-06 04:21:03 | Unassigned, Maine, US | |
2415318 | 2415318 | 2022-12-05 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-06 04:21:03 | Unassigned, Alaska, US | |
720053 | 720053 | 2022-12-04 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-12-05 04:20:58 | Unassigned, Maine, US | |
718926 | 718926 | 2022-12-04 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-05 04:20:58 | Unassigned, Alaska, US | |
2818342 | 2818342 | 2022-12-03 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-12-04 04:20:56 | Unassigned, Maine, US | |
2817215 | 2817215 | 2022-12-03 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-04 04:20:56 | Unassigned, Alaska, US | |
834071 | 834071 | 2022-12-02 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-03 04:21:02 | Unassigned, Alaska, US | |
2136601 | 2136601 | 2022-12-01 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-02 04:21:07 | Unassigned, Alaska, US | |
1965017 | 1965017 | 2022-11-30 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-12-01 04:21:03 | Unassigned, Alaska, US | |
2557031 | 2557031 | 2022-11-29 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-11-30 04:21:07 | Unassigned, Alaska, US | |
1240105 | 1240105 | 2022-11-28 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-11-29 04:21:05 | Unassigned, Alaska, US | |
3552093 | 3552093 | 2022-11-27 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-11-28 04:21:02 | Unassigned, Alaska, US | |
2100573 | 2100573 | 2022-11-26 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-11-27 04:21:05 | Unassigned, Alaska, US | |
488064 | 488064 | 2022-11-25 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-11-26 04:21:11 | Unassigned, Alaska, US | |
3523893 | 3523893 | 2022-11-24 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-11-25 04:21:06 | Unassigned, Alaska, US | |
3312676 | 3312676 | 2022-11-23 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-11-24 04:21:09 | Unassigned, Alaska, US | |
1620717 | 1620717 | 2022-11-22 | US | Alaska | Unassigned | 90002 | 6 | 0 | 0 | 69.31479216 | 0.0 | 2022-11-23 04:21:06 | Unassigned, Alaska, US | |
1641383 | 1641383 | 2022-11-20 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-11-21 04:21:05 | Out of IL, Illinois, US | |
2064940 | 2064940 | 2022-11-19 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-11-20 04:21:08 | Out of IL, Illinois, US | |
1756868 | 1756868 | 2022-11-18 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-11-19 04:21:14 | Unassigned, Maine, US | |
1756334 | 1756334 | 2022-11-18 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-11-19 04:21:14 | Out of IL, Illinois, US | |
3027327 | 3027327 | 2022-11-17 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-11-18 04:21:15 | Out of IL, Illinois, US | |
2487038 | 2487038 | 2022-11-16 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-11-17 04:21:11 | Out of IL, Illinois, US | |
795451 | 795451 | 2022-10-24 | US | Illinois | Out of IL | 80017 | 6 | 2 | 0 | 42.36542373 | 0.0 | 2022-10-25 04:21:53 | Out of IL, Illinois, US | |
199829 | 199829 | 2022-10-19 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-10-20 04:22:59 | Unassigned, Maine, US | |
2757956 | 2757956 | 2022-10-18 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-10-19 04:22:26 | Out of IL, Illinois, US | |
397835 | 397835 | 2022-10-07 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-10-08 04:22:56 | Unassigned, Maine, US | |
1682070 | 1682070 | 2022-08-29 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-30 04:21:03 | Unassigned, Maine, US | |
1878554 | 1878554 | 2022-08-28 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-29 04:21:06 | Unassigned, Maine, US | |
2097681 | 2097681 | 2022-08-27 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-28 04:21:02 | Unassigned, Maine, US | |
2854429 | 2854429 | 2022-08-22 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-23 04:20:56 | Unassigned, Maine, US | |
2404401 | 2404401 | 2022-08-21 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-22 04:20:38 | Unassigned, Maine, US | |
3799479 | 3799479 | 2022-08-20 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-21 04:20:44 | Unassigned, Maine, US | |
2365065 | 2365065 | 2022-08-19 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-20 04:21:01 | Unassigned, Maine, US | |
1162736 | 1162736 | 2022-08-18 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-19 04:20:54 | Unassigned, Maine, US | |
1406611 | 1406611 | 2022-08-02 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-08-03 04:20:59 | Unassigned, Maine, US | |
2491264 | 2491264 | 2022-06-29 | US | Iowa | Unassigned | 90019 | 6 | 0 | 0 | 43.38107862 | 0.0 | 2022-06-30 04:21:01 | Unassigned, Iowa, US | |
1764361 | 1764361 | 2022-06-20 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-06-21 04:20:56 | Out of IL, Illinois, US | |
3270547 | 3270547 | 2022-06-19 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-06-20 04:21:01 | Out of IL, Illinois, US | |
3398459 | 3398459 | 2022-06-18 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-06-19 04:20:51 | Out of IL, Illinois, US | |
2312336 | 2312336 | 2022-06-17 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-06-18 04:21:10 | Out of IL, Illinois, US | |
3888653 | 3888653 | 2022-06-06 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-06-07 04:21:08 | Out of IL, Illinois, US | |
2048901 | 2048901 | 2022-05-25 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-05-26 04:20:50 | Out of IL, Illinois, US | |
622912 | 622912 | 2022-05-22 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-05-26 04:20:50 | Out of IL, Illinois, US | |
3896995 | 3896995 | 2022-05-19 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-05-20 04:20:57 | Out of IL, Illinois, US | |
1504633 | 1504633 | 2022-05-16 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-05-17 04:20:59 | Out of IL, Illinois, US | |
3852850 | 3852850 | 2022-04-27 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-04-28 04:20:47 | Out of IL, Illinois, US | |
2252458 | 2252458 | 2022-04-19 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-04-20 04:20:45 | Out of IL, Illinois, US | |
1225165 | 1225165 | 2022-04-14 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-04-15 04:20:57 | Unassigned, Maine, US | |
3207833 | 3207833 | 2022-04-11 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-04-12 04:20:49 | Unassigned, Maine, US | |
1577719 | 1577719 | 2022-04-10 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-04-11 04:21:02 | Unassigned, Maine, US | |
1653961 | 1653961 | 2022-04-09 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-04-10 04:20:52 | Unassigned, Maine, US | |
3321273 | 3321273 | 2022-04-07 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-04-08 04:20:48 | Out of IL, Illinois, US | |
159579 | 159579 | 2022-03-29 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-03-30 04:20:45 | Unassigned, Maine, US | |
159045 | 159045 | 2022-03-29 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-03-30 04:20:45 | Out of IL, Illinois, US | |
1437616 | 1437616 | 2022-03-28 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-03-29 04:20:46 | Out of IL, Illinois, US | |
877297 | 877297 | 2022-03-27 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-03-28 04:20:33 | Out of IL, Illinois, US | |
2164580 | 2164580 | 2022-03-26 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-03-27 04:20:47 | Out of IL, Illinois, US | |
3023841 | 3023841 | 2022-03-23 | US | Maine | Unassigned | 90023 | 6 | 0 | 0 | 46.65926321 | 0.0 | 2022-03-24 04:20:43 | Unassigned, Maine, US | |
3239360 | 3239360 | 2022-03-21 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-03-22 04:20:54 | Out of IL, Illinois, US | |
25433 | 25433 | 2022-03-20 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-03-21 04:20:50 | Out of IL, Illinois, US | |
1657443 | 1657443 | 2022-03-19 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-03-20 04:20:45 | Out of IL, Illinois, US | |
336969 | 336969 | 2022-03-18 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-03-19 04:20:47 | Out of IL, Illinois, US | |
1645395 | 1645395 | 2022-03-03 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-03-04 04:21:09 | Out of IL, Illinois, US | |
1511544 | 1511544 | 2022-02-24 | New Zealand | Cook Islands | 6 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-25 04:21:11 | Cook Islands, New Zealand | |||
1058882 | 1058882 | 2022-02-23 | US | Illinois | Out of IL | 80017 | 6 | 0 | 0 | 42.36542373 | 0.0 | 2022-02-24 04:21:14 | Out of IL, Illinois, US | |
1057985 | 1057985 | 2022-02-23 | New Zealand | Cook Islands | 6 | 0 | 0 | -21.2367 | -159.7777 | 2022-02-24 04:21:14 | Cook Islands, New Zealand | |||
1364044 | 1364044 | 2022-02-08 | US | Michigan | Unassigned | 90026 | 6 | 0 | 0 | 47.63197653 | 0.0 | 2022-02-09 04:21:04 | Unassigned, Michigan, US | |
72782 | 72782 | 2022-02-07 | US | Michigan | Unassigned | 90026 | 6 | 0 | 0 | 47.63197653 | 0.0 | 2022-02-08 04:21:15 | Unassigned, Michigan, US | |
2474295 | 2474295 | 2022-02-03 | Tonga | 6 | 0 | 0 | -21.179000000000002 | -175.1982 | 2022-02-04 04:21:10 | Tonga | ||||
3301899 | 3301899 | 2022-01-30 | US | Michigan | Unassigned | 90026 | 6 | 0 | 0 | 47.63197653 | 0.0 | 2022-01-31 04:21:09 | Unassigned, Michigan, US | |
3063690 | 3063690 | 2022-01-29 | US | Michigan | Unassigned | 90026 | 6 | 0 | 0 | 47.63197653 | 0.0 | 2022-01-30 04:21:26 | Unassigned, Michigan, US | |
3811624 | 3811624 | 2022-01-28 | US | Michigan | Unassigned | 90026 | 6 | 0 | 0 | 47.63197653 | 0.0 | 2022-01-29 04:21:10 | Unassigned, Michigan, 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]);