johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
770 rows where confirmed = 563 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 23
- US 730
- Australia 8
- Japan 4
- China 3
- Comoros 3
- Netherlands 3
- Sweden 2
- Ukraine 2
- Canada 1
- Colombia 1
- Eswatini 1
- France 1
- India 1
- Mali 1
- Mexico 1
- Paraguay 1
- Peru 1
- Saint Kitts and Nevis 1
- San Marino 1
- South Sudan 1
- Taiwan* 1
- Timor-Leste 1
- Uruguay 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
330990 | 330990 | 2022-12-27 | US | Texas | Edwards | 48137 | 563 | 11 | 0 | 29.98202582 | -100.304252 | 2022-12-28 04:21:04 | Edwards, Texas, US | |
221063 | 221063 | 2022-12-26 | US | Texas | Edwards | 48137 | 563 | 11 | 0 | 29.98202582 | -100.304252 | 2022-12-27 04:21:07 | Edwards, Texas, US | |
3225520 | 3225520 | 2022-12-25 | US | Texas | Edwards | 48137 | 563 | 11 | 0 | 29.98202582 | -100.304252 | 2022-12-26 04:21:06 | Edwards, Texas, US | |
1021434 | 1021434 | 2022-12-24 | US | Texas | Edwards | 48137 | 563 | 11 | 0 | 29.98202582 | -100.304252 | 2022-12-25 04:21:04 | Edwards, Texas, US | |
693457 | 693457 | 2022-12-23 | US | Texas | Edwards | 48137 | 563 | 11 | 0 | 29.98202582 | -100.304252 | 2022-12-24 04:21:02 | Edwards, Texas, US | |
2182667 | 2182667 | 2022-12-22 | US | Texas | Edwards | 48137 | 563 | 11 | 0 | 29.98202582 | -100.304252 | 2022-12-23 04:21:04 | Edwards, Texas, US | |
454471 | 454471 | 2022-12-21 | US | Texas | Edwards | 48137 | 563 | 11 | 0 | 29.98202582 | -100.304252 | 2022-12-22 04:20:56 | Edwards, Texas, US | |
2952661 | 2952661 | 2022-12-20 | US | Kansas | Clark | 20025 | 563 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-12-21 04:21:03 | Clark, Kansas, US | |
3175063 | 3175063 | 2022-12-19 | US | Kansas | Clark | 20025 | 563 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-12-20 04:21:04 | Clark, Kansas, US | |
1629580 | 1629580 | 2022-12-18 | US | Kansas | Clark | 20025 | 563 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-12-19 04:21:03 | Clark, Kansas, US | |
504959 | 504959 | 2022-12-17 | US | Kansas | Clark | 20025 | 563 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-12-18 04:21:03 | Clark, Kansas, US | |
3325531 | 3325531 | 2022-12-16 | US | Kansas | Clark | 20025 | 563 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-12-17 04:21:04 | Clark, Kansas, US | |
544043 | 544043 | 2022-12-15 | US | Kansas | Clark | 20025 | 563 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-12-16 04:21:01 | Clark, Kansas, US | |
349571 | 349571 | 2022-12-14 | US | Kansas | Clark | 20025 | 563 | 8 | 0 | 37.23577007 | -99.81883015 | 2022-12-15 04:20:58 | Clark, Kansas, US | |
2417275 | 2417275 | 2022-12-05 | US | North Dakota | Divide | 38023 | 563 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-12-06 04:21:03 | Divide, North Dakota, US | |
720883 | 720883 | 2022-12-04 | US | North Dakota | Divide | 38023 | 563 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-12-05 04:20:58 | Divide, North Dakota, US | |
2819172 | 2819172 | 2022-12-03 | US | North Dakota | Divide | 38023 | 563 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-12-04 04:20:56 | Divide, North Dakota, US | |
480956 | 480956 | 2022-11-08 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-11-09 04:21:22 | Wichita, Kansas, US | |
2440106 | 2440106 | 2022-11-07 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-11-08 04:21:21 | Wichita, Kansas, US | |
1051204 | 1051204 | 2022-11-06 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-11-07 04:21:26 | Wichita, Kansas, US | |
619228 | 619228 | 2022-11-05 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-11-06 04:21:24 | Wichita, Kansas, US | |
1023732 | 1023732 | 2022-11-04 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-11-05 04:21:52 | Wichita, Kansas, US | |
432723 | 432723 | 2022-11-03 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-11-04 04:22:11 | Wichita, Kansas, US | |
850965 | 850965 | 2022-11-02 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-11-03 04:22:05 | Wichita, Kansas, US | |
711816 | 711816 | 2022-11-01 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-11-02 04:22:09 | Wichita, Kansas, US | |
3286265 | 3286265 | 2022-10-31 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-11-01 04:22:36 | Wichita, Kansas, US | |
321298 | 321298 | 2022-10-30 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-31 04:21:36 | Wichita, Kansas, US | |
913574 | 913574 | 2022-10-29 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-30 04:22:14 | Wichita, Kansas, US | |
1367843 | 1367843 | 2022-10-28 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-29 04:21:13 | Wichita, Kansas, US | |
3039698 | 3039698 | 2022-10-27 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-28 04:22:31 | Wichita, Kansas, US | |
540118 | 540118 | 2022-10-26 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-27 04:22:01 | Wichita, Kansas, US | |
1831519 | 1831519 | 2022-10-25 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-26 04:22:19 | Wichita, Kansas, US | |
795780 | 795780 | 2022-10-24 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-25 04:21:53 | Wichita, Kansas, US | |
3278235 | 3278235 | 2022-10-23 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-24 04:22:29 | Wichita, Kansas, US | |
2269273 | 2269273 | 2022-10-22 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-23 04:22:46 | Wichita, Kansas, US | |
1593573 | 1593573 | 2022-10-21 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-22 04:22:53 | Wichita, Kansas, US | |
2273289 | 2273289 | 2022-10-20 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-21 04:22:23 | Wichita, Kansas, US | |
199624 | 199624 | 2022-10-19 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-20 04:22:59 | Wichita, Kansas, US | |
2758285 | 2758285 | 2022-10-18 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-19 04:22:26 | Wichita, Kansas, US | |
2026119 | 2026119 | 2022-10-17 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-18 04:22:42 | Wichita, Kansas, US | |
2162664 | 2162664 | 2022-10-16 | US | Texas | Irion | 48235 | 563 | 3 | 0 | 31.30375559 | -100.982439 | 2022-10-17 04:20:31 | Irion, Texas, US | |
2160897 | 2160897 | 2022-10-16 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-17 04:20:31 | Wichita, Kansas, US | |
518861 | 518861 | 2022-10-15 | US | Texas | Irion | 48235 | 563 | 3 | 0 | 31.30375559 | -100.982439 | 2022-10-16 04:22:39 | Irion, Texas, US | |
517094 | 517094 | 2022-10-15 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-16 04:22:39 | Wichita, Kansas, US | |
2035918 | 2035918 | 2022-10-14 | US | Texas | Irion | 48235 | 563 | 3 | 0 | 31.30375559 | -100.982439 | 2022-10-15 04:22:00 | Irion, Texas, US | |
2034151 | 2034151 | 2022-10-14 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-15 04:22:00 | Wichita, Kansas, US | |
3756606 | 3756606 | 2022-10-13 | US | Texas | Irion | 48235 | 563 | 3 | 0 | 31.30375559 | -100.982439 | 2022-10-14 04:22:28 | Irion, Texas, US | |
3755884 | 3755884 | 2022-10-13 | US | North Dakota | Kidder | 38043 | 563 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-10-14 04:22:28 | Kidder, North Dakota, US | |
3754839 | 3754839 | 2022-10-13 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-14 04:22:28 | Wichita, Kansas, US | |
3217431 | 3217431 | 2022-10-12 | US | Texas | Irion | 48235 | 563 | 3 | 0 | 31.30375559 | -100.982439 | 2022-10-13 04:22:39 | Irion, Texas, US | |
3216709 | 3216709 | 2022-10-12 | US | North Dakota | Kidder | 38043 | 563 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-10-13 04:22:39 | Kidder, North Dakota, US | |
3215664 | 3215664 | 2022-10-12 | US | Kansas | Wichita | 20203 | 563 | 10 | 0 | 38.48178252 | -101.3471509 | 2022-10-13 04:22:39 | Wichita, Kansas, US | |
117646 | 117646 | 2022-09-06 | US | South Dakota | Mellette | 46095 | 563 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-09-07 04:20:59 | Mellette, South Dakota, US | |
2636618 | 2636618 | 2022-09-05 | US | South Dakota | Mellette | 46095 | 563 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-09-06 04:21:02 | Mellette, South Dakota, US | |
2990182 | 2990182 | 2022-09-04 | US | South Dakota | Mellette | 46095 | 563 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-09-05 04:21:01 | Mellette, South Dakota, US | |
2715867 | 2715867 | 2022-09-03 | US | South Dakota | Mellette | 46095 | 563 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-09-04 04:21:22 | Mellette, South Dakota, US | |
1396572 | 1396572 | 2022-09-02 | US | South Dakota | Mellette | 46095 | 563 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-09-03 04:21:04 | Mellette, South Dakota, US | |
3550401 | 3550401 | 2022-09-01 | US | South Dakota | Mellette | 46095 | 563 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-09-02 04:21:07 | Mellette, South Dakota, US | |
2346321 | 2346321 | 2022-08-31 | US | South Dakota | Mellette | 46095 | 563 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-09-01 04:21:03 | Mellette, South Dakota, US | |
2856080 | 2856080 | 2022-08-22 | US | Texas | Schleicher | 48413 | 563 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-08-23 04:20:56 | Schleicher, Texas, US | |
2406052 | 2406052 | 2022-08-21 | US | Texas | Schleicher | 48413 | 563 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-08-22 04:20:38 | Schleicher, Texas, US | |
3801130 | 3801130 | 2022-08-20 | US | Texas | Schleicher | 48413 | 563 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-08-21 04:20:44 | Schleicher, Texas, US | |
2366716 | 2366716 | 2022-08-19 | US | Texas | Schleicher | 48413 | 563 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-08-20 04:21:01 | Schleicher, Texas, US | |
1164387 | 1164387 | 2022-08-18 | US | Texas | Schleicher | 48413 | 563 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-08-19 04:20:54 | Schleicher, Texas, US | |
3953711 | 3953711 | 2022-08-17 | US | Texas | Schleicher | 48413 | 563 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-08-18 04:21:11 | Schleicher, Texas, US | |
1086853 | 1086853 | 2022-08-09 | US | Georgia | Clay | 13061 | 563 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-08-10 04:20:57 | Clay, Georgia, US | |
3544268 | 3544268 | 2022-08-08 | US | Georgia | Clay | 13061 | 563 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-08-09 04:20:34 | Clay, Georgia, US | |
1070671 | 1070671 | 2022-08-07 | US | Georgia | Clay | 13061 | 563 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-08-08 04:21:08 | Clay, Georgia, US | |
1941259 | 1941259 | 2022-08-06 | US | Georgia | Clay | 13061 | 563 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-08-07 04:20:54 | Clay, Georgia, US | |
881058 | 881058 | 2022-08-05 | US | Georgia | Clay | 13061 | 563 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-08-06 04:20:56 | Clay, Georgia, US | |
2009469 | 2009469 | 2022-08-04 | US | Georgia | Clay | 13061 | 563 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-08-05 04:20:52 | Clay, Georgia, US | |
1098896 | 1098896 | 2022-08-03 | US | Georgia | Clay | 13061 | 563 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-08-04 04:20:58 | Clay, Georgia, US | |
959647 | 959647 | 2022-07-19 | US | Georgia | Baker | 13007 | 563 | 15 | 0 | 31.32669878 | -84.44218806 | 2022-07-20 04:20:59 | Baker, Georgia, US | |
3211034 | 3211034 | 2022-07-18 | US | Georgia | Baker | 13007 | 563 | 15 | 0 | 31.32669878 | -84.44218806 | 2022-07-19 04:20:58 | Baker, Georgia, US | |
3406209 | 3406209 | 2022-07-17 | US | Georgia | Baker | 13007 | 563 | 15 | 0 | 31.32669878 | -84.44218806 | 2022-07-18 04:20:59 | Baker, Georgia, US | |
2152409 | 2152409 | 2022-07-16 | US | Georgia | Baker | 13007 | 563 | 15 | 0 | 31.32669878 | -84.44218806 | 2022-07-17 04:21:15 | Baker, Georgia, US | |
2419642 | 2419642 | 2022-07-15 | US | Georgia | Baker | 13007 | 563 | 15 | 0 | 31.32669878 | -84.44218806 | 2022-07-16 04:21:05 | Baker, Georgia, US | |
3429717 | 3429717 | 2022-07-14 | US | Georgia | Baker | 13007 | 563 | 15 | 0 | 31.32669878 | -84.44218806 | 2022-07-15 04:20:53 | Baker, Georgia, US | |
3110237 | 3110237 | 2022-07-13 | US | Georgia | Baker | 13007 | 563 | 15 | 0 | 31.32669878 | -84.44218806 | 2022-07-14 04:20:57 | Baker, Georgia, US | |
1213205 | 1213205 | 2022-07-11 | US | Michigan | Keweenaw | 26083 | 563 | 13 | 0 | 47.63197653 | -88.41434263 | 2022-07-12 04:20:51 | Keweenaw, Michigan, US | |
2790687 | 2790687 | 2022-07-10 | US | Michigan | Keweenaw | 26083 | 563 | 13 | 0 | 47.63197653 | -88.41434263 | 2022-07-11 04:20:46 | Keweenaw, Michigan, US | |
143640 | 143640 | 2022-07-09 | US | Michigan | Keweenaw | 26083 | 563 | 13 | 0 | 47.63197653 | -88.41434263 | 2022-07-10 04:20:54 | Keweenaw, Michigan, US | |
1418740 | 1418740 | 2022-07-08 | US | Michigan | Keweenaw | 26083 | 563 | 13 | 0 | 47.63197653 | -88.41434263 | 2022-07-09 04:20:59 | Keweenaw, Michigan, US | |
2744479 | 2744479 | 2022-07-07 | US | Washington | Wahkiakum | 53069 | 563 | 7 | 0 | 46.2918004 | -123.4250831 | 2022-07-08 04:20:56 | Wahkiakum, Washington, US | |
2742665 | 2742665 | 2022-07-07 | US | Michigan | Keweenaw | 26083 | 563 | 13 | 0 | 47.63197653 | -88.41434263 | 2022-07-08 04:20:56 | Keweenaw, Michigan, US | |
1203274 | 1203274 | 2022-07-06 | US | Washington | Wahkiakum | 53069 | 563 | 7 | 0 | 46.2918004 | -123.4250831 | 2022-07-07 04:20:55 | Wahkiakum, Washington, US | |
1201460 | 1201460 | 2022-07-06 | US | Michigan | Keweenaw | 26083 | 563 | 13 | 0 | 47.63197653 | -88.41434263 | 2022-07-07 04:20:55 | Keweenaw, Michigan, US | |
3968203 | 3968203 | 2022-07-05 | US | Michigan | Keweenaw | 26083 | 563 | 13 | 0 | 47.63197653 | -88.41434263 | 2022-07-06 04:20:58 | Keweenaw, Michigan, US | |
3967833 | 3967833 | 2022-07-05 | US | Kansas | Edwards | 20047 | 563 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-06 04:20:58 | Edwards, Kansas, US | |
3079344 | 3079344 | 2022-07-04 | US | Kansas | Edwards | 20047 | 563 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-05 04:20:45 | Edwards, Kansas, US | |
1768626 | 1768626 | 2022-07-03 | US | Kansas | Edwards | 20047 | 563 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-04 04:20:54 | Edwards, Kansas, US | |
3366612 | 3366612 | 2022-07-02 | US | Kansas | Edwards | 20047 | 563 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-03 04:20:59 | Edwards, Kansas, US | |
594941 | 594941 | 2022-07-01 | US | Kansas | Edwards | 20047 | 563 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-02 04:21:16 | Edwards, Kansas, US | |
3941342 | 3941342 | 2022-06-30 | US | Kansas | Edwards | 20047 | 563 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-01 04:21:10 | Edwards, Kansas, US | |
2491300 | 2491300 | 2022-06-29 | US | Kansas | Edwards | 20047 | 563 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-06-30 04:21:01 | Edwards, Kansas, US | |
2240682 | 2240682 | 2022-06-28 | US | Kansas | Edwards | 20047 | 563 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-06-29 04:20:59 | Edwards, Kansas, US | |
2148924 | 2148924 | 2022-06-27 | US | Kansas | Edwards | 20047 | 563 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-06-28 04:20:58 | Edwards, Kansas, US | |
476725 | 476725 | 2022-06-26 | US | Kansas | Edwards | 20047 | 563 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-06-27 04:21:00 | Edwards, Kansas, US | |
940100 | 940100 | 2022-06-25 | US | Kansas | Edwards | 20047 | 563 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-06-26 04:21:02 | Edwards, Kansas, US | |
3347920 | 3347920 | 2022-06-24 | US | Kansas | Edwards | 20047 | 563 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-06-25 04:20:57 | Edwards, 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]);