johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,528 rows where confirmed = 44 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
These facets timed out: province_or_state
country_or_region >30
- US 2,280
- Saint Kitts and Nevis 44
- United Kingdom 33
- Chile 30
- France 27
- Canada 16
- India 15
- Malaysia 10
- Fiji 9
- Japan 9
- Laos 9
- Timor-Leste 6
- Syria 5
- China 3
- Denmark 3
- Mainland China 3
- Azerbaijan 2
- Gabon 2
- Haiti 2
- Kyrgyzstan 2
- Uganda 2
- Bangladesh 1
- Colombia 1
- Ethiopia 1
- Finland 1
- Gambia 1
- Jamaica 1
- Kazakhstan 1
- Liechtenstein 1
- Nigeria 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1783295 | 1783295 | 2022-07-29 | Chile | Unknown | 44 | 2 | 0 | 2022-07-30 04:20:42 | Unknown, Chile | |||||
3045958 | 3045958 | 2022-02-26 | Chile | Unknown | 44 | 0 | 0 | 2022-02-27 04:21:04 | Unknown, Chile | |||||
574613 | 574613 | 2022-02-25 | Chile | Unknown | 44 | 0 | 0 | 2022-02-26 04:21:12 | Unknown, Chile | |||||
1511189 | 1511189 | 2022-02-24 | Chile | Unknown | 44 | 0 | 0 | 2022-02-25 04:21:11 | Unknown, Chile | |||||
1057630 | 1057630 | 2022-02-23 | Chile | Unknown | 44 | 0 | 0 | 2022-02-24 04:21:14 | Unknown, Chile | |||||
2446553 | 2446553 | 2022-02-22 | Chile | Unknown | 44 | 0 | 0 | 2022-02-23 04:21:09 | Unknown, Chile | |||||
3717966 | 3717966 | 2022-02-21 | Chile | Unknown | 44 | 0 | 0 | 2022-02-22 04:21:01 | Unknown, Chile | |||||
3911800 | 3911800 | 2022-02-20 | Chile | Unknown | 44 | 0 | 0 | 2022-02-21 04:21:05 | Unknown, Chile | |||||
3875358 | 3875358 | 2022-02-19 | Chile | Unknown | 44 | 0 | 0 | 2022-02-20 04:21:00 | Unknown, Chile | |||||
3855614 | 3855614 | 2022-02-18 | Chile | Unknown | 44 | 0 | 0 | 2022-02-19 04:21:11 | Unknown, Chile | |||||
1297833 | 1297833 | 2022-02-17 | Chile | Unknown | 44 | 0 | 0 | 2022-02-18 04:21:04 | Unknown, Chile | |||||
3820219 | 3820219 | 2022-02-16 | Chile | Unknown | 44 | 0 | 0 | 2022-02-17 04:20:56 | Unknown, Chile | |||||
3671433 | 3671433 | 2022-02-15 | Chile | Unknown | 44 | 0 | 0 | 2022-02-16 04:21:10 | Unknown, Chile | |||||
2641534 | 2641534 | 2022-02-14 | Chile | Unknown | 44 | 0 | 0 | 2022-02-15 04:21:09 | Unknown, Chile | |||||
185851 | 185851 | 2022-02-13 | Chile | Unknown | 44 | 0 | 0 | 2022-02-14 04:20:51 | Unknown, Chile | |||||
315697 | 315697 | 2022-02-12 | Chile | Unknown | 44 | 0 | 0 | 2022-02-13 04:21:00 | Unknown, Chile | |||||
233023 | 233023 | 2022-02-11 | Chile | Unknown | 44 | 0 | 0 | 2022-02-12 04:21:06 | Unknown, Chile | |||||
1463865 | 1463865 | 2022-02-10 | Chile | Unknown | 44 | 0 | 0 | 2022-02-11 04:21:09 | Unknown, Chile | |||||
3073826 | 3073826 | 2022-02-09 | Chile | Unknown | 44 | 0 | 0 | 2022-02-10 04:21:14 | Unknown, Chile | |||||
2907377 | 2907377 | 2021-12-19 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-20 04:21:43 | Montserrat, United Kingdom | |||
1262450 | 1262450 | 2021-12-18 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-19 04:21:11 | Montserrat, United Kingdom | |||
2402478 | 2402478 | 2021-12-17 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-18 02:22:20 | Montserrat, United Kingdom | |||
1720016 | 1720016 | 2021-12-16 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-17 04:22:14 | Montserrat, United Kingdom | |||
3499850 | 3499850 | 2021-12-15 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-16 04:22:11 | Montserrat, United Kingdom | |||
2091635 | 2091635 | 2021-12-14 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-15 03:22:16 | Montserrat, United Kingdom | |||
786052 | 786052 | 2021-12-13 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-14 04:22:38 | Montserrat, United Kingdom | |||
1664087 | 1664087 | 2021-12-12 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-13 04:22:02 | Montserrat, United Kingdom | |||
1668103 | 1668103 | 2021-12-11 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-12 04:22:12 | Montserrat, United Kingdom | |||
3659255 | 3659255 | 2021-12-10 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-11 04:22:45 | Montserrat, United Kingdom | |||
1081586 | 1081586 | 2021-12-09 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-10 04:22:28 | Montserrat, United Kingdom | |||
554435 | 554435 | 2021-12-08 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-09 04:22:49 | Montserrat, United Kingdom | |||
407955 | 407955 | 2021-12-07 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-08 04:22:46 | Montserrat, United Kingdom | |||
1034037 | 1034037 | 2021-12-06 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-07 04:22:34 | Montserrat, United Kingdom | |||
1744200 | 1744200 | 2021-12-05 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-06 04:22:34 | Montserrat, United Kingdom | |||
141632 | 141632 | 2021-12-04 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-05 04:22:25 | Montserrat, United Kingdom | |||
2199285 | 2199285 | 2021-12-03 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-04 04:22:18 | Montserrat, United Kingdom | |||
3991 | 3991 | 2021-12-02 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-03 04:23:05 | Montserrat, United Kingdom | |||
1148590 | 1148590 | 2021-12-01 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-02 04:22:37 | Montserrat, United Kingdom | |||
3405102 | 3405102 | 2021-11-30 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-12-01 04:22:29 | Montserrat, United Kingdom | |||
3403486 | 3403486 | 2021-11-30 | US | Nebraska | Blaine | 31009 | 44 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-12-01 04:22:29 | Blaine, Nebraska, US | |
153645 | 153645 | 2021-11-29 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-30 04:22:53 | Montserrat, United Kingdom | |||
152029 | 152029 | 2021-11-29 | US | Nebraska | Blaine | 31009 | 44 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-30 04:22:53 | Blaine, Nebraska, US | |
1235291 | 1235291 | 2021-11-28 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-29 04:22:30 | Montserrat, United Kingdom | |||
1233675 | 1233675 | 2021-11-28 | US | Nebraska | Blaine | 31009 | 44 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-29 04:22:30 | Blaine, Nebraska, US | |
1361998 | 1361998 | 2021-11-27 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-28 04:22:43 | Montserrat, United Kingdom | |||
1360382 | 1360382 | 2021-11-27 | US | Nebraska | Blaine | 31009 | 44 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-28 04:22:43 | Blaine, Nebraska, US | |
761989 | 761989 | 2021-11-26 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-27 04:22:45 | Montserrat, United Kingdom | |||
760373 | 760373 | 2021-11-26 | US | Nebraska | Blaine | 31009 | 44 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-27 04:22:45 | Blaine, Nebraska, US | |
1806406 | 1806406 | 2021-11-25 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-26 04:22:33 | Montserrat, United Kingdom | |||
1804790 | 1804790 | 2021-11-25 | US | Nebraska | Blaine | 31009 | 44 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-26 04:22:33 | Blaine, Nebraska, US | |
907840 | 907840 | 2021-11-24 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-25 04:22:33 | Montserrat, United Kingdom | |||
906224 | 906224 | 2021-11-24 | US | Nebraska | Blaine | 31009 | 44 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-25 04:22:33 | Blaine, Nebraska, US | |
3073690 | 3073690 | 2021-11-23 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-24 04:22:14 | Montserrat, United Kingdom | |||
3072074 | 3072074 | 2021-11-23 | US | Nebraska | Blaine | 31009 | 44 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-24 04:22:14 | Blaine, Nebraska, US | |
3752788 | 3752788 | 2021-11-22 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-23 04:22:39 | Montserrat, United Kingdom | |||
3751172 | 3751172 | 2021-11-22 | US | Nebraska | Blaine | 31009 | 44 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-23 04:22:39 | Blaine, Nebraska, US | |
3749011 | 3749011 | 2021-11-22 | France | Saint Pierre and Miquelon | 44 | 0 | 0 | 46.8852 | -56.3159 | 2021-11-23 04:22:39 | Saint Pierre and Miquelon, France | |||
1017995 | 1017995 | 2021-11-21 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-22 04:22:20 | Montserrat, United Kingdom | |||
1016379 | 1016379 | 2021-11-21 | US | Nebraska | Blaine | 31009 | 44 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-22 04:22:20 | Blaine, Nebraska, US | |
726159 | 726159 | 2021-11-20 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-21 04:22:13 | Montserrat, United Kingdom | |||
724543 | 724543 | 2021-11-20 | US | Nebraska | Blaine | 31009 | 44 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-21 04:22:13 | Blaine, Nebraska, US | |
165689 | 165689 | 2021-11-19 | United Kingdom | Montserrat | 44 | 1 | 0 | 16.742498 | -62.187366000000004 | 2021-11-20 04:22:17 | Montserrat, United Kingdom | |||
164073 | 164073 | 2021-11-19 | US | Nebraska | Blaine | 31009 | 44 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-20 04:22:17 | Blaine, Nebraska, US | |
3290960 | 3290960 | 2021-11-18 | US | Nebraska | Blaine | 31009 | 44 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-11-19 04:21:40 | Blaine, Nebraska, US | |
30613 | 30613 | 2021-11-11 | US | New Mexico | Harding | 35021 | 44 | 3 | 0 | 35.85751555 | -103.82209379999999 | 2021-11-12 04:22:01 | Harding, New Mexico, US | |
2847052 | 2847052 | 2021-11-10 | US | New Mexico | Harding | 35021 | 44 | 3 | 0 | 35.85751555 | -103.82209379999999 | 2021-11-11 04:21:45 | Harding, New Mexico, US | |
90416 | 90416 | 2021-11-09 | US | Vermont | Unassigned | 90050 | 44 | 0 | 0 | 44.85627605 | 0.0 | 2021-11-10 04:21:38 | Unassigned, Vermont, US | |
89322 | 89322 | 2021-11-09 | US | New Mexico | Harding | 35021 | 44 | 3 | 0 | 35.85751555 | -103.82209379999999 | 2021-11-10 04:21:38 | Harding, New Mexico, US | |
88816 | 88816 | 2021-11-09 | US | Michigan | Unassigned | 90026 | 44 | 0 | 0 | 47.63197653 | 0.0 | 2021-11-10 04:21:38 | Unassigned, Michigan, US | |
3641750 | 3641750 | 2021-11-08 | US | New Mexico | Harding | 35021 | 44 | 3 | 0 | 35.85751555 | -103.82209379999999 | 2021-11-09 04:21:36 | Harding, New Mexico, US | |
3641244 | 3641244 | 2021-11-08 | US | Michigan | Unassigned | 90026 | 44 | 0 | 0 | 47.63197653 | 0.0 | 2021-11-09 04:21:36 | Unassigned, Michigan, US | |
2002858 | 2002858 | 2021-11-07 | US | New Mexico | Harding | 35021 | 44 | 3 | 0 | 35.85751555 | -103.82209379999999 | 2021-11-08 04:21:43 | Harding, New Mexico, US | |
2002352 | 2002352 | 2021-11-07 | US | Michigan | Unassigned | 90026 | 44 | 0 | 0 | 47.63197653 | 0.0 | 2021-11-08 04:21:43 | Unassigned, Michigan, US | |
497849 | 497849 | 2021-11-06 | US | New Mexico | Harding | 35021 | 44 | 3 | 0 | 35.85751555 | -103.82209379999999 | 2021-11-07 04:21:53 | Harding, New Mexico, US | |
497343 | 497343 | 2021-11-06 | US | Michigan | Unassigned | 90026 | 44 | 0 | 0 | 47.63197653 | 0.0 | 2021-11-07 04:21:53 | Unassigned, Michigan, US | |
3123704 | 3123704 | 2021-11-05 | US | New Mexico | Harding | 35021 | 44 | 3 | 0 | 35.85751555 | -103.82209379999999 | 2021-11-06 04:21:51 | Harding, New Mexico, US | |
3123198 | 3123198 | 2021-11-05 | US | Michigan | Unassigned | 90026 | 44 | 0 | 0 | 47.63197653 | 0.0 | 2021-11-06 04:21:51 | Unassigned, Michigan, US | |
700602 | 700602 | 2021-11-04 | US | New Mexico | Harding | 35021 | 44 | 3 | 0 | 35.85751555 | -103.82209379999999 | 2021-11-05 04:21:54 | Harding, New Mexico, US | |
278380 | 278380 | 2021-11-03 | US | New Mexico | Harding | 35021 | 44 | 3 | 0 | 35.85751555 | -103.82209379999999 | 2021-11-04 04:22:20 | Harding, New Mexico, US | |
45905 | 45905 | 2021-11-02 | US | New Mexico | Harding | 35021 | 44 | 3 | 0 | 35.85751555 | -103.82209379999999 | 2021-11-03 06:22:09 | Harding, New Mexico, US | |
3513601 | 3513601 | 2021-11-01 | US | New Mexico | Harding | 35021 | 44 | 3 | 0 | 35.85751555 | -103.82209379999999 | 2021-11-02 04:22:03 | Harding, New Mexico, US | |
290192 | 290192 | 2021-10-31 | US | New Mexico | Harding | 35021 | 44 | 3 | 0 | 35.85751555 | -103.82209379999999 | 2021-11-01 04:22:01 | Harding, New Mexico, US | |
2723198 | 2723198 | 2021-10-30 | US | New Mexico | Harding | 35021 | 44 | 3 | 0 | 35.85751555 | -103.82209379999999 | 2021-10-31 04:22:08 | Harding, New Mexico, US | |
569300 | 569300 | 2021-10-29 | US | New Mexico | Harding | 35021 | 44 | 3 | 0 | 35.85751555 | -103.82209379999999 | 2021-10-30 04:22:03 | Harding, New Mexico, US | |
6542 | 6542 | 2021-10-28 | US | New Mexico | Harding | 35021 | 44 | 3 | 0 | 35.85751555 | -103.82209379999999 | 2021-10-29 04:22:03 | Harding, New Mexico, US | |
537163 | 537163 | 2021-10-27 | US | North Dakota | Slope | 38087 | 44 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-10-28 04:22:08 | Slope, North Dakota, US | |
3494600 | 3494600 | 2021-10-26 | US | North Dakota | Slope | 38087 | 44 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-10-27 04:22:32 | Slope, North Dakota, US | |
3796322 | 3796322 | 2021-10-25 | US | North Dakota | Slope | 38087 | 44 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-10-26 04:22:09 | Slope, North Dakota, US | |
684768 | 684768 | 2021-10-24 | US | North Dakota | Slope | 38087 | 44 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-10-25 04:22:31 | Slope, North Dakota, US | |
772776 | 772776 | 2021-10-23 | US | North Dakota | Slope | 38087 | 44 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-10-24 04:21:22 | Slope, North Dakota, US | |
656423 | 656423 | 2021-10-22 | US | North Dakota | Slope | 38087 | 44 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-10-23 04:21:32 | Slope, North Dakota, US | |
2126170 | 2126170 | 2021-10-21 | US | North Dakota | Slope | 38087 | 44 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-10-22 04:21:14 | Slope, North Dakota, US | |
445782 | 445782 | 2021-10-20 | US | North Dakota | Slope | 38087 | 44 | 0 | 0 | 46.44737738 | -103.4601547 | 2021-10-21 04:21:18 | Slope, North Dakota, US | |
2775077 | 2775077 | 2021-09-30 | US | Nebraska | McPherson | 31117 | 44 | 1 | 0 | 41.56797682 | -101.05993620000001 | 2021-10-01 04:21:35 | McPherson, Nebraska, US | |
2775021 | 2775021 | 2021-09-30 | US | Nebraska | Banner | 31007 | 44 | 0 | 0 | 41.54634427 | -103.7114332 | 2021-10-01 04:21:35 | Banner, Nebraska, US | |
708533 | 708533 | 2021-09-29 | US | Nebraska | McPherson | 31117 | 44 | 1 | 0 | 41.56797682 | -101.05993620000001 | 2021-09-30 04:21:20 | McPherson, Nebraska, US | |
708477 | 708477 | 2021-09-29 | US | Nebraska | Banner | 31007 | 44 | 0 | 0 | 41.54634427 | -103.7114332 | 2021-09-30 04:21:20 | Banner, Nebraska, US | |
1336375 | 1336375 | 2021-09-28 | US | Nebraska | McPherson | 31117 | 44 | 1 | 0 | 41.56797682 | -101.05993620000001 | 2021-09-29 04:21:45 | McPherson, Nebraska, US | |
1237744 | 1237744 | 2021-09-27 | US | Nebraska | McPherson | 31117 | 44 | 1 | 0 | 41.56797682 | -101.05993620000001 | 2021-09-28 04:21:28 | McPherson, Nebraska, US | |
2078045 | 2078045 | 2021-09-26 | US | Nebraska | McPherson | 31117 | 44 | 1 | 0 | 41.56797682 | -101.05993620000001 | 2021-09-27 04:21:16 | McPherson, Nebraska, 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]);