johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,182 rows where confirmed = 159 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 22
- US 1,042
- China 58
- Japan 29
- Malaysia 12
- Canada 8
- Grenada 7
- United Kingdom 5
- Guyana 4
- Antigua and Barbuda 3
- Mainland China 2
- Australia 1
- Denmark 1
- El Salvador 1
- Eswatini 1
- Germany 1
- Kuwait 1
- Laos 1
- Paraguay 1
- Russia 1
- Sri Lanka 1
- Timor-Leste 1
- Venezuela 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2531388 | 2531388 | 2022-10-06 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-07 04:23:08 | Golden Valley, Montana, US | |
1812782 | 1812782 | 2022-10-05 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-06 04:21:22 | Golden Valley, Montana, US | |
132756 | 132756 | 2022-10-04 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-05 04:23:06 | Golden Valley, Montana, US | |
2687703 | 2687703 | 2022-10-03 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-04 04:22:55 | Golden Valley, Montana, US | |
2261770 | 2261770 | 2022-10-02 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-03 04:23:11 | Golden Valley, Montana, US | |
2997296 | 2997296 | 2022-10-01 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-02 04:21:23 | Golden Valley, Montana, US | |
855622 | 855622 | 2022-09-30 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-10-01 04:23:01 | Golden Valley, Montana, US | |
2377548 | 2377548 | 2022-09-29 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-30 04:23:09 | Golden Valley, Montana, US | |
1562099 | 1562099 | 2022-09-28 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-29 04:22:34 | Golden Valley, Montana, US | |
3996642 | 3996642 | 2022-09-27 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-28 04:23:01 | Golden Valley, Montana, US | |
2770970 | 2770970 | 2022-09-26 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-27 04:23:01 | Golden Valley, Montana, US | |
1978623 | 1978623 | 2022-09-25 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-26 04:20:52 | Golden Valley, Montana, US | |
2651790 | 2651790 | 2022-09-24 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-25 04:23:31 | Golden Valley, Montana, US | |
386230 | 386230 | 2022-09-23 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-24 04:21:40 | Golden Valley, Montana, US | |
1626296 | 1626296 | 2022-09-22 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-23 04:23:13 | Golden Valley, Montana, US | |
1372500 | 1372500 | 2022-09-21 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-22 04:22:56 | Golden Valley, Montana, US | |
2018730 | 2018730 | 2022-09-20 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-21 04:23:22 | Golden Valley, Montana, US | |
3572603 | 3572603 | 2022-09-19 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-20 04:22:48 | Golden Valley, Montana, US | |
421342 | 421342 | 2022-09-18 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-19 04:21:49 | Golden Valley, Montana, US | |
3375366 | 3375366 | 2022-09-17 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-18 04:22:50 | Golden Valley, Montana, US | |
2357474 | 2357474 | 2022-09-16 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-17 04:20:19 | Golden Valley, Montana, US | |
3988631 | 3988631 | 2022-09-15 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-16 04:21:19 | Golden Valley, Montana, US | |
1891148 | 1891148 | 2022-09-14 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-15 04:21:02 | Golden Valley, Montana, US | |
374203 | 374203 | 2022-09-13 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-14 04:20:44 | Golden Valley, Montana, US | |
2396805 | 2396805 | 2022-09-12 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-13 04:20:57 | Golden Valley, Montana, US | |
3767883 | 3767883 | 2022-09-11 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-12 04:20:58 | Golden Valley, Montana, US | |
3826458 | 3826458 | 2022-09-10 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-11 04:20:50 | Golden Valley, Montana, US | |
964915 | 964915 | 2022-09-09 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-10 04:21:10 | Golden Valley, Montana, US | |
255317 | 255317 | 2022-09-08 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-09 04:21:11 | Golden Valley, Montana, US | |
3747115 | 3747115 | 2022-09-07 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-08 04:21:02 | Golden Valley, Montana, US | |
116755 | 116755 | 2022-09-06 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-07 04:20:59 | Golden Valley, Montana, US | |
2635727 | 2635727 | 2022-09-05 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-06 04:21:02 | Golden Valley, Montana, US | |
2989291 | 2989291 | 2022-09-04 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-05 04:21:01 | Golden Valley, Montana, US | |
2714976 | 2714976 | 2022-09-03 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-04 04:21:22 | Golden Valley, Montana, US | |
1395681 | 1395681 | 2022-09-02 | US | Montana | Golden Valley | 30037 | 159 | 5 | 0 | 46.3816474 | -109.1768522 | 2022-09-03 04:21:04 | Golden Valley, Montana, US | |
1877648 | 1877648 | 2022-08-28 | US | Colorado | Unassigned | 90008 | 159 | 0 | 0 | 40.87595412 | 0.0 | 2022-08-29 04:21:06 | Unassigned, Colorado, US | |
2096775 | 2096775 | 2022-08-27 | US | Colorado | Unassigned | 90008 | 159 | 0 | 0 | 40.87595412 | 0.0 | 2022-08-28 04:21:02 | Unassigned, Colorado, US | |
1532590 | 1532590 | 2022-08-26 | US | Colorado | Unassigned | 90008 | 159 | 0 | 0 | 40.87595412 | 0.0 | 2022-08-27 04:20:57 | Unassigned, Colorado, US | |
2829477 | 2829477 | 2022-08-25 | US | Colorado | Unassigned | 90008 | 159 | 0 | 0 | 40.87595412 | 0.0 | 2022-08-26 04:21:02 | Unassigned, Colorado, US | |
2324010 | 2324010 | 2022-08-24 | US | Colorado | Unassigned | 90008 | 159 | 0 | 0 | 40.87595412 | 0.0 | 2022-08-25 04:21:13 | Unassigned, Colorado, US | |
1969251 | 1969251 | 2022-08-13 | US | Colorado | Unassigned | 90008 | 159 | 0 | 0 | 40.87595412 | 0.0 | 2022-08-14 04:20:55 | Unassigned, Colorado, US | |
2889060 | 2889060 | 2022-08-12 | US | Colorado | Unassigned | 90008 | 159 | 0 | 0 | 40.87595412 | 0.0 | 2022-08-13 04:20:52 | Unassigned, Colorado, US | |
3908665 | 3908665 | 2022-08-11 | US | Colorado | Unassigned | 90008 | 159 | 0 | 0 | 40.87595412 | 0.0 | 2022-08-12 04:20:54 | Unassigned, Colorado, US | |
1346982 | 1346982 | 2022-08-10 | US | Colorado | Unassigned | 90008 | 159 | 0 | 0 | 40.87595412 | 0.0 | 2022-08-11 04:20:49 | Unassigned, Colorado, US | |
1086737 | 1086737 | 2022-08-09 | US | Colorado | Unassigned | 90008 | 159 | 0 | 0 | 40.87595412 | 0.0 | 2022-08-10 04:20:57 | Unassigned, Colorado, US | |
3544152 | 3544152 | 2022-08-08 | US | Colorado | Unassigned | 90008 | 159 | 0 | 0 | 40.87595412 | 0.0 | 2022-08-09 04:20:34 | Unassigned, Colorado, US | |
1072283 | 1072283 | 2022-08-07 | US | North Dakota | Billings | 38007 | 159 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-08-08 04:21:08 | Billings, North Dakota, US | |
1942871 | 1942871 | 2022-08-06 | US | North Dakota | Billings | 38007 | 159 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-08-07 04:20:54 | Billings, North Dakota, US | |
882670 | 882670 | 2022-08-05 | US | North Dakota | Billings | 38007 | 159 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-08-06 04:20:56 | Billings, North Dakota, US | |
2011081 | 2011081 | 2022-08-04 | US | North Dakota | Billings | 38007 | 159 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-08-05 04:20:52 | Billings, North Dakota, US | |
1100508 | 1100508 | 2022-08-03 | US | North Dakota | Billings | 38007 | 159 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-08-04 04:20:58 | Billings, North Dakota, US | |
1407433 | 1407433 | 2022-08-02 | US | North Dakota | Billings | 38007 | 159 | 1 | 0 | 47.02366884 | -103.3762965 | 2022-08-03 04:20:59 | Billings, North Dakota, US | |
961046 | 961046 | 2022-07-19 | US | Nevada | Storey | 32029 | 159 | 12 | 0 | 39.44875482 | -119.5250207 | 2022-07-20 04:20:59 | Storey, Nevada, US | |
3212433 | 3212433 | 2022-07-18 | US | Nevada | Storey | 32029 | 159 | 12 | 0 | 39.44875482 | -119.5250207 | 2022-07-19 04:20:58 | Storey, Nevada, US | |
3407608 | 3407608 | 2022-07-17 | US | Nevada | Storey | 32029 | 159 | 12 | 0 | 39.44875482 | -119.5250207 | 2022-07-18 04:20:59 | Storey, Nevada, US | |
2153808 | 2153808 | 2022-07-16 | US | Nevada | Storey | 32029 | 159 | 12 | 0 | 39.44875482 | -119.5250207 | 2022-07-17 04:21:15 | Storey, Nevada, US | |
2421041 | 2421041 | 2022-07-15 | US | Nevada | Storey | 32029 | 159 | 12 | 0 | 39.44875482 | -119.5250207 | 2022-07-16 04:21:05 | Storey, Nevada, US | |
3431116 | 3431116 | 2022-07-14 | US | Nevada | Storey | 32029 | 159 | 12 | 0 | 39.44875482 | -119.5250207 | 2022-07-15 04:20:53 | Storey, Nevada, US | |
3111636 | 3111636 | 2022-07-13 | US | Nevada | Storey | 32029 | 159 | 12 | 0 | 39.44875482 | -119.5250207 | 2022-07-14 04:20:57 | Storey, Nevada, US | |
1649308 | 1649308 | 2022-06-23 | US | Idaho | Camas | 16025 | 159 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-06-24 04:20:58 | Camas, Idaho, US | |
2188543 | 2188543 | 2022-06-22 | US | Idaho | Camas | 16025 | 159 | 2 | 0 | 43.46665742 | -114.8065892 | 2022-06-23 04:20:55 | Camas, Idaho, US | |
1951251 | 1951251 | 2022-04-12 | US | Puerto Rico | Culebra | 72049 | 159 | 0 | 0 | 18.31586 | -65.28813000000001 | 2022-04-13 04:21:03 | Culebra, Puerto Rico, US | |
3209004 | 3209004 | 2022-04-11 | US | Puerto Rico | Culebra | 72049 | 159 | 0 | 0 | 18.31586 | -65.28813000000001 | 2022-04-12 04:20:49 | Culebra, Puerto Rico, US | |
1578890 | 1578890 | 2022-04-10 | US | Puerto Rico | Culebra | 72049 | 159 | 0 | 0 | 18.31586 | -65.28813000000001 | 2022-04-11 04:21:02 | Culebra, Puerto Rico, US | |
1655132 | 1655132 | 2022-04-09 | US | Puerto Rico | Culebra | 72049 | 159 | 0 | 0 | 18.31586 | -65.28813000000001 | 2022-04-10 04:20:52 | Culebra, Puerto Rico, US | |
2118454 | 2118454 | 2022-04-08 | US | Puerto Rico | Culebra | 72049 | 159 | 0 | 0 | 18.31586 | -65.28813000000001 | 2022-04-09 04:20:42 | Culebra, Puerto Rico, US | |
3322978 | 3322978 | 2022-04-07 | US | Puerto Rico | Culebra | 72049 | 159 | 0 | 0 | 18.31586 | -65.28813000000001 | 2022-04-08 04:20:48 | Culebra, Puerto Rico, US | |
2477162 | 2477162 | 2022-02-03 | US | Texas | Roberts | 48393 | 159 | 1 | 0 | 35.83809685 | -100.813175 | 2022-02-04 04:21:10 | Roberts, Texas, US | |
462587 | 462587 | 2022-02-02 | US | Texas | Roberts | 48393 | 159 | 1 | 0 | 35.83809685 | -100.813175 | 2022-02-03 04:21:21 | Roberts, Texas, US | |
460007 | 460007 | 2022-02-02 | US | Colorado | Jackson | 8057 | 159 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2022-02-03 04:21:21 | Jackson, Colorado, US | |
982156 | 982156 | 2022-02-01 | US | Texas | Roberts | 48393 | 159 | 1 | 0 | 35.83809685 | -100.813175 | 2022-02-02 04:21:09 | Roberts, Texas, US | |
1390316 | 1390316 | 2022-01-07 | US | Colorado | San Juan | 8111 | 159 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2022-01-08 04:21:53 | San Juan, Colorado, US | |
3998440 | 3998440 | 2021-12-30 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-31 04:21:50 | Guizhou, China | |||
1668247 | 1668247 | 2021-12-29 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-30 04:21:25 | Guizhou, China | |||
1432356 | 1432356 | 2021-12-28 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-29 03:21:43 | Guizhou, China | |||
730317 | 730317 | 2021-12-27 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-28 04:21:47 | Guizhou, China | |||
2111489 | 2111489 | 2021-12-26 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-27 04:21:58 | Guizhou, China | |||
3604861 | 3604861 | 2021-12-25 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-26 04:21:50 | Guizhou, China | |||
2963179 | 2963179 | 2021-12-24 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-25 04:21:37 | Guizhou, China | |||
3816211 | 3816211 | 2021-12-23 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-24 04:21:34 | Guizhou, China | |||
798219 | 798219 | 2021-12-22 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-23 04:21:21 | Guizhou, China | |||
3830585 | 3830585 | 2021-12-21 | US | Nebraska | Rock | 31149 | 159 | 2 | 0 | 42.42252217 | -99.44832069 | 2021-12-22 04:21:54 | Rock, Nebraska, US | |
3828259 | 3828259 | 2021-12-21 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-22 04:21:54 | Guizhou, China | |||
1254562 | 1254562 | 2021-12-20 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-21 03:21:27 | Guizhou, China | |||
2903505 | 2903505 | 2021-12-19 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-20 04:21:43 | Guizhou, China | |||
1258578 | 1258578 | 2021-12-18 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-19 04:21:11 | Guizhou, China | |||
2398606 | 2398606 | 2021-12-17 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-18 02:22:20 | Guizhou, China | |||
1716144 | 1716144 | 2021-12-16 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-17 04:22:14 | Guizhou, China | |||
3495978 | 3495978 | 2021-12-15 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-16 04:22:11 | Guizhou, China | |||
2087763 | 2087763 | 2021-12-14 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-15 03:22:16 | Guizhou, China | |||
782180 | 782180 | 2021-12-13 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-14 04:22:38 | Guizhou, China | |||
1660215 | 1660215 | 2021-12-12 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-13 04:22:02 | Guizhou, China | |||
1664231 | 1664231 | 2021-12-11 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-12 04:22:12 | Guizhou, China | |||
3655383 | 3655383 | 2021-12-10 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-11 04:22:45 | Guizhou, China | |||
1077714 | 1077714 | 2021-12-09 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-10 04:22:28 | Guizhou, China | |||
554065 | 554065 | 2021-12-08 | US | Vermont | Unassigned | 90050 | 159 | 0 | 0 | 44.85627605 | 0.0 | 2021-12-09 04:22:49 | Unassigned, Vermont, US | |
550563 | 550563 | 2021-12-08 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-09 04:22:49 | Guizhou, China | |||
404083 | 404083 | 2021-12-07 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-08 04:22:46 | Guizhou, China | |||
1030165 | 1030165 | 2021-12-06 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-07 04:22:34 | Guizhou, China | |||
1740328 | 1740328 | 2021-12-05 | China | Guizhou | 159 | 2 | 0 | 26.8154 | 106.8748 | 2021-12-06 04:22:34 | Guizhou, China |
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]);