johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
936 rows where confirmed = 368 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 18
- US 826
- Malaysia 44
- China 31
- Japan 9
- Sweden 5
- United Kingdom 5
- Netherlands 3
- Colombia 2
- Ukraine 2
- Bosnia and Herzegovina 1
- Chile 1
- India 1
- Lebanon 1
- Mexico 1
- Mongolia 1
- New Zealand 1
- Russia 1
- Sri Lanka 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2953808 | 2953808 | 2022-12-20 | US | North Dakota | Oliver | 38065 | 368 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-21 04:21:03 | Oliver, North Dakota, US | |
3176210 | 3176210 | 2022-12-19 | US | North Dakota | Oliver | 38065 | 368 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-20 04:21:04 | Oliver, North Dakota, US | |
1630727 | 1630727 | 2022-12-18 | US | North Dakota | Oliver | 38065 | 368 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-19 04:21:03 | Oliver, North Dakota, US | |
506106 | 506106 | 2022-12-17 | US | North Dakota | Oliver | 38065 | 368 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-18 04:21:03 | Oliver, North Dakota, US | |
3326678 | 3326678 | 2022-12-16 | US | North Dakota | Oliver | 38065 | 368 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-17 04:21:04 | Oliver, North Dakota, US | |
545190 | 545190 | 2022-12-15 | US | North Dakota | Oliver | 38065 | 368 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-16 04:21:01 | Oliver, North Dakota, US | |
350718 | 350718 | 2022-12-14 | US | North Dakota | Oliver | 38065 | 368 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-15 04:20:58 | Oliver, North Dakota, US | |
310306 | 310306 | 2022-12-13 | US | North Dakota | Oliver | 38065 | 368 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-14 04:21:04 | Oliver, North Dakota, US | |
1151367 | 1151367 | 2022-12-12 | US | North Dakota | Oliver | 38065 | 368 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-13 04:21:01 | Oliver, North Dakota, US | |
871221 | 871221 | 2022-12-11 | US | North Dakota | Oliver | 38065 | 368 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-12 04:21:01 | Oliver, North Dakota, US | |
259751 | 259751 | 2022-12-10 | US | North Dakota | Oliver | 38065 | 368 | 5 | 0 | 47.11530482 | -101.3406158 | 2022-12-11 04:20:50 | Oliver, North Dakota, US | |
1620078 | 1620078 | 2022-11-22 | China | Qinghai | 368 | 0 | 0 | 35.7452 | 95.9956 | 2022-11-23 04:21:06 | Qinghai, China | |||
3459966 | 3459966 | 2022-11-21 | China | Qinghai | 368 | 0 | 0 | 35.7452 | 95.9956 | 2022-11-22 04:20:47 | Qinghai, China | |||
3597676 | 3597676 | 2022-11-14 | US | Colorado | Kiowa | 8061 | 368 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-11-15 04:21:16 | Kiowa, Colorado, US | |
312534 | 312534 | 2022-11-13 | US | Colorado | Kiowa | 8061 | 368 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-11-14 04:21:09 | Kiowa, Colorado, US | |
63695 | 63695 | 2022-11-12 | US | Colorado | Kiowa | 8061 | 368 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-11-13 04:21:14 | Kiowa, Colorado, US | |
2927857 | 2927857 | 2022-11-11 | US | Colorado | Kiowa | 8061 | 368 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-11-12 04:20:41 | Kiowa, Colorado, US | |
2506693 | 2506693 | 2022-11-10 | US | Colorado | Kiowa | 8061 | 368 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-11-11 04:21:22 | Kiowa, Colorado, US | |
2431568 | 2431568 | 2022-11-09 | US | Colorado | Kiowa | 8061 | 368 | 6 | 0 | 38.43260896 | -102.7392145 | 2022-11-10 04:21:16 | Kiowa, Colorado, US | |
2852673 | 2852673 | 2022-08-22 | China | Tibet | 368 | 0 | 0 | 31.6927 | 88.0924 | 2022-08-23 04:20:56 | Tibet, China | |||
1071977 | 1071977 | 2022-08-07 | US | Nebraska | Harlan | 31083 | 368 | 2 | 0 | 40.17658508 | -99.40438879 | 2022-08-08 04:21:08 | Harlan, Nebraska, US | |
1942565 | 1942565 | 2022-08-06 | US | Nebraska | Harlan | 31083 | 368 | 2 | 0 | 40.17658508 | -99.40438879 | 2022-08-07 04:20:54 | Harlan, Nebraska, US | |
882364 | 882364 | 2022-08-05 | US | Nebraska | Harlan | 31083 | 368 | 2 | 0 | 40.17658508 | -99.40438879 | 2022-08-06 04:20:56 | Harlan, Nebraska, US | |
2010775 | 2010775 | 2022-08-04 | US | Nebraska | Harlan | 31083 | 368 | 2 | 0 | 40.17658508 | -99.40438879 | 2022-08-05 04:20:52 | Harlan, Nebraska, US | |
1100202 | 1100202 | 2022-08-03 | US | Nebraska | Harlan | 31083 | 368 | 2 | 0 | 40.17658508 | -99.40438879 | 2022-08-04 04:20:58 | Harlan, Nebraska, US | |
2338135 | 2338135 | 2022-07-27 | US | Puerto Rico | Culebra | 72049 | 368 | 0 | 0 | 18.31586 | -65.28813 | 2022-07-28 04:20:56 | Culebra, Puerto Rico, US | |
673528 | 673528 | 2022-07-21 | US | Texas | Stonewall | 48433 | 368 | 7 | 0 | 33.17906744 | -100.2538401 | 2022-07-22 04:21:15 | Stonewall, Texas, US | |
1611491 | 1611491 | 2022-07-20 | US | Texas | Stonewall | 48433 | 368 | 7 | 0 | 33.17906744 | -100.2538401 | 2022-07-21 04:21:10 | Stonewall, Texas, US | |
962124 | 962124 | 2022-07-19 | US | Texas | Stonewall | 48433 | 368 | 7 | 0 | 33.17906744 | -100.2538401 | 2022-07-20 04:20:59 | Stonewall, Texas, US | |
3213511 | 3213511 | 2022-07-18 | US | Texas | Stonewall | 48433 | 368 | 7 | 0 | 33.17906744 | -100.2538401 | 2022-07-19 04:20:58 | Stonewall, Texas, US | |
3408686 | 3408686 | 2022-07-17 | US | Texas | Stonewall | 48433 | 368 | 7 | 0 | 33.17906744 | -100.2538401 | 2022-07-18 04:20:59 | Stonewall, Texas, US | |
2154886 | 2154886 | 2022-07-16 | US | Texas | Stonewall | 48433 | 368 | 7 | 0 | 33.17906744 | -100.2538401 | 2022-07-17 04:21:15 | Stonewall, Texas, US | |
1846591 | 1846591 | 2022-04-18 | US | Colorado | Dolores | 8033 | 368 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-04-19 04:21:00 | Dolores, Colorado, US | |
3417535 | 3417535 | 2022-04-17 | US | Colorado | Dolores | 8033 | 368 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-04-18 04:21:12 | Dolores, Colorado, US | |
304484 | 304484 | 2022-04-16 | US | Colorado | Dolores | 8033 | 368 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-04-17 04:20:59 | Dolores, Colorado, US | |
2670429 | 2670429 | 2022-04-15 | US | Colorado | Dolores | 8033 | 368 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-04-16 04:20:48 | Dolores, Colorado, US | |
1224214 | 1224214 | 2022-04-14 | US | Colorado | Dolores | 8033 | 368 | 8 | 0 | 37.75208676 | -108.5211585 | 2022-04-15 04:20:57 | Dolores, Colorado, US | |
3322316 | 3322316 | 2022-04-07 | US | Nebraska | Garden | 31069 | 368 | 0 | 0 | 41.61703149 | -102.3313973 | 2022-04-08 04:20:48 | Garden, Nebraska, US | |
2802852 | 2802852 | 2022-04-06 | US | Nebraska | Garden | 31069 | 368 | 0 | 0 | 41.61703149 | -102.3313973 | 2022-04-07 04:20:53 | Garden, Nebraska, US | |
3869621 | 3869621 | 2022-04-05 | US | Nebraska | Garden | 31069 | 368 | 0 | 0 | 41.61703149 | -102.3313973 | 2022-04-06 04:20:49 | Garden, Nebraska, US | |
2750963 | 2750963 | 2022-04-04 | US | Nebraska | Garden | 31069 | 368 | 0 | 0 | 41.61703149 | -102.3313973 | 2022-04-05 04:20:48 | Garden, Nebraska, US | |
3732309 | 3732309 | 2022-04-03 | US | Nebraska | Garden | 31069 | 368 | 0 | 0 | 41.61703149 | -102.3313973 | 2022-04-04 04:20:51 | Garden, Nebraska, US | |
501744 | 501744 | 2022-04-02 | US | Nebraska | Garden | 31069 | 368 | 0 | 0 | 41.61703149 | -102.3313973 | 2022-04-03 04:20:48 | Garden, Nebraska, US | |
3352729 | 3352729 | 2022-04-01 | US | Nebraska | Garden | 31069 | 368 | 0 | 0 | 41.61703149 | -102.3313973 | 2022-04-02 04:20:47 | Garden, Nebraska, US | |
1542034 | 1542034 | 2022-03-31 | US | Nebraska | Garden | 31069 | 368 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-04-01 04:20:28 | Garden, Nebraska, US | |
2480047 | 2480047 | 2022-03-30 | US | Nebraska | Garden | 31069 | 368 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-03-31 04:20:56 | Garden, Nebraska, US | |
160088 | 160088 | 2022-03-29 | US | Nebraska | Garden | 31069 | 368 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-03-30 04:20:45 | Garden, Nebraska, US | |
1438659 | 1438659 | 2022-03-28 | US | Nebraska | Garden | 31069 | 368 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-03-29 04:20:46 | Garden, Nebraska, US | |
878340 | 878340 | 2022-03-27 | US | Nebraska | Garden | 31069 | 368 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-03-28 04:20:33 | Garden, Nebraska, US | |
2165623 | 2165623 | 2022-03-26 | US | Nebraska | Garden | 31069 | 368 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-03-27 04:20:47 | Garden, Nebraska, US | |
1722559 | 1722559 | 2022-03-25 | US | Nebraska | Garden | 31069 | 368 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-03-26 04:20:23 | Garden, Nebraska, US | |
1470176 | 1470176 | 2022-03-24 | US | Nebraska | Garden | 31069 | 368 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-03-25 04:20:46 | Garden, Nebraska, US | |
3024350 | 3024350 | 2022-03-23 | US | Nebraska | Garden | 31069 | 368 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-03-24 04:20:43 | Garden, Nebraska, US | |
1907272 | 1907272 | 2022-03-22 | US | Nebraska | Garden | 31069 | 368 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-03-23 04:20:48 | Garden, Nebraska, US | |
263608 | 263608 | 2022-03-15 | US | Nebraska | Garden | 31069 | 368 | 1 | 0 | 41.61703149 | -102.3313973 | 2022-03-16 04:20:50 | Garden, Nebraska, US | |
1646440 | 1646440 | 2022-03-03 | US | Nebraska | Gosper | 31073 | 368 | 5 | 0 | 40.51481965 | -99.83020279 | 2022-03-04 04:21:09 | Gosper, Nebraska, US | |
2527443 | 2527443 | 2022-03-02 | US | Nebraska | Gosper | 31073 | 368 | 5 | 0 | 40.51481965 | -99.83020279 | 2022-03-03 04:21:01 | Gosper, Nebraska, US | |
1994737 | 1994737 | 2022-03-01 | US | Nebraska | Gosper | 31073 | 368 | 5 | 0 | 40.51481965 | -99.83020279 | 2022-03-02 04:21:07 | Gosper, Nebraska, US | |
1992446 | 1992446 | 2022-03-01 | China | Gansu | 368 | 2 | 0 | 35.7518 | 104.2861 | 2022-03-02 04:21:07 | Gansu, China | |||
942620 | 942620 | 2022-02-28 | China | Gansu | 368 | 2 | 0 | 35.7518 | 104.2861 | 2022-03-01 04:21:09 | Gansu, China | |||
2732811 | 2732811 | 2022-02-27 | China | Gansu | 368 | 2 | 0 | 35.7518 | 104.2861 | 2022-02-28 04:21:05 | Gansu, China | |||
3045964 | 3045964 | 2022-02-26 | China | Gansu | 368 | 2 | 0 | 35.7518 | 104.2861 | 2022-02-27 04:21:04 | Gansu, China | |||
574619 | 574619 | 2022-02-25 | China | Gansu | 368 | 2 | 0 | 35.7518 | 104.2861 | 2022-02-26 04:21:12 | Gansu, China | |||
188109 | 188109 | 2022-02-13 | US | Montana | Wheatland | 30107 | 368 | 14 | 0 | 46.46652491 | -109.84646359999999 | 2022-02-14 04:20:51 | Wheatland, Montana, US | |
317955 | 317955 | 2022-02-12 | US | Montana | Wheatland | 30107 | 368 | 14 | 0 | 46.46652491 | -109.84646359999999 | 2022-02-13 04:21:00 | Wheatland, Montana, US | |
235281 | 235281 | 2022-02-11 | US | Montana | Wheatland | 30107 | 368 | 14 | 0 | 46.46652491 | -109.84646359999999 | 2022-02-12 04:21:06 | Wheatland, Montana, US | |
1781463 | 1781463 | 2022-01-27 | US | Nebraska | Garfield | 31071 | 368 | 1 | 0 | 41.91428955 | -98.99111827 | 2022-01-28 04:21:09 | Garfield, Nebraska, US | |
3228729 | 3228729 | 2022-01-19 | US | New York | Unassigned | 90036 | 368 | 1 | 0 | 44.74530905 | 0.0 | 2022-01-20 04:21:07 | Unassigned, New York, US | |
3689552 | 3689552 | 2022-01-13 | US | Nebraska | Franklin | 31061 | 368 | 4 | 0 | 40.17636348 | -98.95299073 | 2022-01-14 04:21:54 | Franklin, Nebraska, US | |
1116481 | 1116481 | 2022-01-11 | US | South Dakota | McPherson | 46089 | 368 | 9 | 0 | 45.76626028 | -99.22118798 | 2022-01-12 04:21:44 | McPherson, South Dakota, US | |
1218647 | 1218647 | 2022-01-08 | US | Texas | Edwards | 48137 | 368 | 9 | 0 | 29.98202582 | -100.304252 | 2022-01-09 04:21:46 | Edwards, Texas, US | |
2112357 | 2112357 | 2021-12-26 | US | Colorado | Sedgwick | 8115 | 368 | 7 | 0 | 40.87595412 | -102.3519227 | 2021-12-27 04:21:58 | Sedgwick, Colorado, US | |
3605729 | 3605729 | 2021-12-25 | US | Colorado | Sedgwick | 8115 | 368 | 7 | 0 | 40.87595412 | -102.3519227 | 2021-12-26 04:21:50 | Sedgwick, Colorado, US | |
2906119 | 2906119 | 2021-12-19 | US | North Dakota | Grant | 38037 | 368 | 9 | 0 | 46.35821257 | -101.63900129999999 | 2021-12-20 04:21:43 | Grant, North Dakota, US | |
1261192 | 1261192 | 2021-12-18 | US | North Dakota | Grant | 38037 | 368 | 9 | 0 | 46.35821257 | -101.63900129999999 | 2021-12-19 04:21:11 | Grant, North Dakota, US | |
2401220 | 2401220 | 2021-12-17 | US | North Dakota | Grant | 38037 | 368 | 9 | 0 | 46.35821257 | -101.63900129999999 | 2021-12-18 02:22:20 | Grant, North Dakota, US | |
1033270 | 1033270 | 2021-12-06 | US | South Dakota | Miner | 46097 | 368 | 11 | 0 | 44.02197882 | -97.60992207 | 2021-12-07 04:22:34 | Miner, South Dakota, US | |
1743687 | 1743687 | 2021-12-05 | US | Texas | Knox | 48275 | 368 | 22 | 0 | 33.60519951 | -99.74229059999999 | 2021-12-06 04:22:34 | Knox, Texas, US | |
1743433 | 1743433 | 2021-12-05 | US | South Dakota | Miner | 46097 | 368 | 11 | 0 | 44.02197882 | -97.60992207 | 2021-12-06 04:22:34 | Miner, South Dakota, US | |
141119 | 141119 | 2021-12-04 | US | Texas | Knox | 48275 | 368 | 22 | 0 | 33.60519951 | -99.74229059999999 | 2021-12-05 04:22:25 | Knox, Texas, US | |
140865 | 140865 | 2021-12-04 | US | South Dakota | Miner | 46097 | 368 | 11 | 0 | 44.02197882 | -97.60992207 | 2021-12-05 04:22:25 | Miner, South Dakota, US | |
2198772 | 2198772 | 2021-12-03 | US | Texas | Knox | 48275 | 368 | 21 | 0 | 33.60519951 | -99.74229059999999 | 2021-12-04 04:22:18 | Knox, Texas, US | |
2198518 | 2198518 | 2021-12-03 | US | South Dakota | Miner | 46097 | 368 | 11 | 0 | 44.02197882 | -97.60992207 | 2021-12-04 04:22:18 | Miner, South Dakota, US | |
3224 | 3224 | 2021-12-02 | US | South Dakota | Miner | 46097 | 368 | 11 | 0 | 44.02197882 | -97.60992207 | 2021-12-03 04:23:05 | Miner, South Dakota, US | |
163493 | 163493 | 2021-11-19 | US | Kentucky | Robertson | 21201 | 368 | 16 | 0 | 38.51923469 | -84.05055616 | 2021-11-20 04:22:17 | Robertson, Kentucky, US | |
30822 | 30822 | 2021-11-11 | US | North Dakota | Kidder | 38043 | 368 | 11 | 0 | 46.97830064 | -99.77507857 | 2021-11-12 04:22:01 | Kidder, North Dakota, US | |
29166 | 29166 | 2021-11-11 | US | Georgia | Baker | 13007 | 368 | 14 | 0 | 31.32669878 | -84.44218806 | 2021-11-12 04:22:01 | Baker, Georgia, US | |
2848141 | 2848141 | 2021-11-10 | US | Vermont | Grand Isle | 50013 | 368 | 2 | 0 | 44.797582399999996 | -73.29679772 | 2021-11-11 04:21:45 | Grand Isle, Vermont, US | |
2845605 | 2845605 | 2021-11-10 | US | Georgia | Baker | 13007 | 368 | 14 | 0 | 31.32669878 | -84.44218806 | 2021-11-11 04:21:45 | Baker, Georgia, US | |
89174 | 89174 | 2021-11-09 | US | Nebraska | Brown | 31017 | 368 | 2 | 0 | 42.43018907 | -99.92904055 | 2021-11-10 04:21:38 | Brown, Nebraska, US | |
87875 | 87875 | 2021-11-09 | US | Georgia | Baker | 13007 | 368 | 14 | 0 | 31.32669878 | -84.44218806 | 2021-11-10 04:21:38 | Baker, Georgia, US | |
3642989 | 3642989 | 2021-11-08 | US | Washington | Columbia | 53013 | 368 | 8 | 0 | 46.29442881 | -117.9051983 | 2021-11-09 04:21:36 | Columbia, Washington, US | |
3640480 | 3640480 | 2021-11-08 | US | Idaho | Butte | 16023 | 368 | 4 | 0 | 43.72592209 | -113.1735463 | 2021-11-09 04:21:36 | Butte, Idaho, US | |
699682 | 699682 | 2021-11-04 | US | Kansas | Decatur | 20039 | 368 | 13 | 0 | 39.78468441 | -100.45940809999999 | 2021-11-05 04:21:54 | Decatur, Kansas, US | |
277460 | 277460 | 2021-11-03 | US | Kansas | Decatur | 20039 | 368 | 13 | 0 | 39.78468441 | -100.45940809999999 | 2021-11-04 04:22:20 | Decatur, Kansas, US | |
44458 | 44458 | 2021-11-02 | US | Georgia | Baker | 13007 | 368 | 14 | 0 | 31.32669878 | -84.44218806 | 2021-11-03 06:22:09 | Baker, Georgia, US | |
3512154 | 3512154 | 2021-11-01 | US | Georgia | Baker | 13007 | 368 | 14 | 0 | 31.32669878 | -84.44218806 | 2021-11-02 04:22:03 | Baker, Georgia, US | |
289261 | 289261 | 2021-10-31 | US | Kansas | Chase | 20017 | 368 | 4 | 0 | 38.30292938 | -96.59563862 | 2021-11-01 04:22:01 | Chase, Kansas, US | |
288745 | 288745 | 2021-10-31 | US | Georgia | Baker | 13007 | 368 | 14 | 0 | 31.32669878 | -84.44218806 | 2021-11-01 04:22:01 | Baker, Georgia, US | |
2722267 | 2722267 | 2021-10-30 | US | Kansas | Chase | 20017 | 368 | 4 | 0 | 38.30292938 | -96.59563862 | 2021-10-31 04:22:08 | Chase, Kansas, 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]);