johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
377 rows where confirmed = 2118 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
309183 | 309183 | 2022-12-13 | US | Kansas | Greenwood | 20073 | 2118 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-12-14 04:21:04 | Greenwood, Kansas, US | |
1150244 | 1150244 | 2022-12-12 | US | Kansas | Greenwood | 20073 | 2118 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-12-13 04:21:01 | Greenwood, Kansas, US | |
870098 | 870098 | 2022-12-11 | US | Kansas | Greenwood | 20073 | 2118 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-12-12 04:21:01 | Greenwood, Kansas, US | |
258628 | 258628 | 2022-12-10 | US | Kansas | Greenwood | 20073 | 2118 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-12-11 04:20:50 | Greenwood, Kansas, US | |
3937342 | 3937342 | 2022-12-09 | US | Kansas | Greenwood | 20073 | 2118 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-12-10 04:21:02 | Greenwood, Kansas, US | |
3378674 | 3378674 | 2022-12-08 | US | Kansas | Greenwood | 20073 | 2118 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-12-09 04:21:05 | Greenwood, Kansas, US | |
1985945 | 1985945 | 2022-12-07 | US | Kansas | Greenwood | 20073 | 2118 | 25 | 0 | 37.8774388 | -96.23250453 | 2022-12-08 04:21:07 | Greenwood, Kansas, US | |
2557415 | 2557415 | 2022-11-29 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-30 04:21:07 | Irwin, Georgia, US | |
1240489 | 1240489 | 2022-11-28 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-29 04:21:05 | Irwin, Georgia, US | |
3552477 | 3552477 | 2022-11-27 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-28 04:21:02 | Irwin, Georgia, US | |
2100957 | 2100957 | 2022-11-26 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-27 04:21:05 | Irwin, Georgia, US | |
488448 | 488448 | 2022-11-25 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-26 04:21:11 | Irwin, Georgia, US | |
3524277 | 3524277 | 2022-11-24 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-25 04:21:06 | Irwin, Georgia, US | |
3313060 | 3313060 | 2022-11-23 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-24 04:21:09 | Irwin, Georgia, US | |
1621101 | 1621101 | 2022-11-22 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-23 04:21:06 | Irwin, Georgia, US | |
3460989 | 3460989 | 2022-11-21 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-22 04:20:47 | Irwin, Georgia, US | |
1641174 | 1641174 | 2022-11-20 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-21 04:21:05 | Irwin, Georgia, US | |
2064731 | 2064731 | 2022-11-19 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-20 04:21:08 | Irwin, Georgia, US | |
2063705 | 2063705 | 2022-11-19 | China | Liaoning | 2118 | 2 | 0 | 41.2956 | 122.6085 | 2022-11-20 04:21:08 | Liaoning, China | |||
1756125 | 1756125 | 2022-11-18 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-19 04:21:14 | Irwin, Georgia, US | |
3029501 | 3029501 | 2022-11-17 | US | Texas | Refugio | 48391 | 2118 | 39 | 0 | 28.3238976 | -97.15766311 | 2022-11-18 04:21:15 | Refugio, Texas, US | |
3027118 | 3027118 | 2022-11-17 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-18 04:21:15 | Irwin, Georgia, US | |
2489212 | 2489212 | 2022-11-16 | US | Texas | Refugio | 48391 | 2118 | 39 | 0 | 28.3238976 | -97.15766311 | 2022-11-17 04:21:11 | Refugio, Texas, US | |
2486829 | 2486829 | 2022-11-16 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-17 04:21:11 | Irwin, Georgia, US | |
292840 | 292840 | 2022-11-15 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-16 04:21:09 | Irwin, Georgia, US | |
3597870 | 3597870 | 2022-11-14 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-15 04:21:16 | Irwin, Georgia, US | |
312728 | 312728 | 2022-11-13 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-14 04:21:09 | Irwin, Georgia, US | |
63889 | 63889 | 2022-11-12 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-13 04:21:14 | Irwin, Georgia, US | |
2928051 | 2928051 | 2022-11-11 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-12 04:20:41 | Irwin, Georgia, US | |
2506887 | 2506887 | 2022-11-10 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-11 04:21:22 | Irwin, Georgia, US | |
2431762 | 2431762 | 2022-11-09 | US | Georgia | Irwin | 13155 | 2118 | 54 | 0 | 31.60213036 | -83.27501387 | 2022-11-10 04:21:16 | Irwin, Georgia, US | |
3756678 | 3756678 | 2022-10-13 | US | Texas | Rains | 48379 | 2118 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-10-14 04:22:28 | Rains, Texas, US | |
3217503 | 3217503 | 2022-10-12 | US | Texas | Rains | 48379 | 2118 | 60 | 0 | 32.87109387 | -95.79232691 | 2022-10-13 04:22:39 | Rains, Texas, US | |
2532811 | 2532811 | 2022-10-06 | US | Virginia | Williamsburg | 51830 | 2118 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-07 04:23:08 | Williamsburg, Virginia, US | |
1813783 | 1813783 | 2022-10-05 | US | Tennessee | Van Buren | 47175 | 2118 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-10-06 04:21:22 | Van Buren, Tennessee, US | |
2376178 | 2376178 | 2022-09-29 | US | Colorado | Lake | 8065 | 2118 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-09-30 04:23:09 | Lake, Colorado, US | |
2772281 | 2772281 | 2022-09-26 | US | Virginia | Buena Vista | 51530 | 2118 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-09-27 04:23:01 | Buena Vista, Virginia, US | |
1626316 | 1626316 | 2022-09-22 | US | Montana | Powell | 30077 | 2118 | 30 | 0 | 46.85538891 | -112.9359164 | 2022-09-23 04:23:13 | Powell, Montana, US | |
1372520 | 1372520 | 2022-09-21 | US | Montana | Powell | 30077 | 2118 | 30 | 0 | 46.85538891 | -112.9359164 | 2022-09-22 04:22:56 | Powell, Montana, US | |
2018750 | 2018750 | 2022-09-20 | US | Montana | Powell | 30077 | 2118 | 30 | 0 | 46.85538891 | -112.9359164 | 2022-09-21 04:23:22 | Powell, Montana, US | |
3573914 | 3573914 | 2022-09-19 | US | Virginia | Buena Vista | 51530 | 2118 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-09-20 04:22:48 | Buena Vista, Virginia, US | |
3572623 | 3572623 | 2022-09-19 | US | Montana | Powell | 30077 | 2118 | 30 | 0 | 46.85538891 | -112.9359164 | 2022-09-20 04:22:48 | Powell, Montana, US | |
421362 | 421362 | 2022-09-18 | US | Montana | Powell | 30077 | 2118 | 30 | 0 | 46.85538891 | -112.9359164 | 2022-09-19 04:21:49 | Powell, Montana, US | |
3375386 | 3375386 | 2022-09-17 | US | Montana | Powell | 30077 | 2118 | 30 | 0 | 46.85538891 | -112.9359164 | 2022-09-18 04:22:50 | Powell, Montana, US | |
2357494 | 2357494 | 2022-09-16 | US | Montana | Powell | 30077 | 2118 | 30 | 0 | 46.85538891 | -112.9359164 | 2022-09-17 04:20:19 | Powell, Montana, US | |
3987165 | 3987165 | 2022-09-15 | US | Arkansas | Woodruff | 5147 | 2118 | 31 | 0 | 35.18902527 | -91.2439489 | 2022-09-16 04:21:19 | Woodruff, Arkansas, US | |
2395412 | 2395412 | 2022-09-12 | US | Colorado | Conejos | 8021 | 2118 | 57 | 0 | 37.201606 | -106.1917488 | 2022-09-13 04:20:57 | Conejos, Colorado, US | |
3769244 | 3769244 | 2022-09-11 | US | Virginia | Lancaster | 51103 | 2118 | 37 | 0 | 37.71889653 | -76.46400482 | 2022-09-12 04:20:58 | Lancaster, Virginia, US | |
3827819 | 3827819 | 2022-09-10 | US | Virginia | Lancaster | 51103 | 2118 | 37 | 0 | 37.71889653 | -76.46400482 | 2022-09-11 04:20:50 | Lancaster, Virginia, US | |
966276 | 966276 | 2022-09-09 | US | Virginia | Lancaster | 51103 | 2118 | 37 | 0 | 37.71889653 | -76.46400482 | 2022-09-10 04:21:10 | Lancaster, Virginia, US | |
994104 | 994104 | 2022-08-16 | US | Texas | Hansford | 48195 | 2118 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-08-17 04:20:59 | Hansford, Texas, US | |
2497143 | 2497143 | 2022-08-15 | US | Texas | Hansford | 48195 | 2118 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-08-16 04:20:58 | Hansford, Texas, US | |
3650693 | 3650693 | 2022-08-14 | US | Texas | Hansford | 48195 | 2118 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-08-15 04:20:59 | Hansford, Texas, US | |
1971699 | 1971699 | 2022-08-13 | US | Texas | Hansford | 48195 | 2118 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-08-14 04:20:55 | Hansford, Texas, US | |
2891508 | 2891508 | 2022-08-12 | US | Texas | Hansford | 48195 | 2118 | 29 | 0 | 36.27743284 | -101.3545796 | 2022-08-13 04:20:52 | Hansford, Texas, US | |
1088397 | 1088397 | 2022-08-09 | US | North Carolina | Gates | 37073 | 2118 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-08-10 04:20:57 | Gates, North Carolina, US | |
3545812 | 3545812 | 2022-08-08 | US | North Carolina | Gates | 37073 | 2118 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-08-09 04:20:34 | Gates, North Carolina, US | |
1072215 | 1072215 | 2022-08-07 | US | North Carolina | Gates | 37073 | 2118 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-08-08 04:21:08 | Gates, North Carolina, US | |
1942803 | 1942803 | 2022-08-06 | US | North Carolina | Gates | 37073 | 2118 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-08-07 04:20:54 | Gates, North Carolina, US | |
882602 | 882602 | 2022-08-05 | US | North Carolina | Gates | 37073 | 2118 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-08-06 04:20:56 | Gates, North Carolina, US | |
2011013 | 2011013 | 2022-08-04 | US | North Carolina | Gates | 37073 | 2118 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-08-05 04:20:52 | Gates, North Carolina, US | |
2009356 | 2009356 | 2022-08-04 | US | Colorado | Yuma | 8125 | 2118 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-05 04:20:52 | Yuma, Colorado, US | |
1100440 | 1100440 | 2022-08-03 | US | North Carolina | Gates | 37073 | 2118 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-08-04 04:20:58 | Gates, North Carolina, US | |
1098783 | 1098783 | 2022-08-03 | US | Colorado | Yuma | 8125 | 2118 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-04 04:20:58 | Yuma, Colorado, US | |
2154077 | 2154077 | 2022-07-16 | US | North Dakota | Pembina | 38067 | 2118 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-07-17 04:21:15 | Pembina, North Dakota, US | |
2421310 | 2421310 | 2022-07-15 | US | North Dakota | Pembina | 38067 | 2118 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-07-16 04:21:05 | Pembina, North Dakota, US | |
3112242 | 3112242 | 2022-07-13 | US | Puerto Rico | Las Marias | 72083 | 2118 | 0 | 0 | 18.23679 | -66.98362 | 2022-07-14 04:20:57 | Las Marias, Puerto Rico, US | |
3967434 | 3967434 | 2022-07-05 | US | Georgia | Terrell | 13273 | 2118 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-07-06 04:20:58 | Terrell, Georgia, US | |
3078945 | 3078945 | 2022-07-04 | US | Georgia | Terrell | 13273 | 2118 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-07-05 04:20:45 | Terrell, Georgia, US | |
1768227 | 1768227 | 2022-07-03 | US | Georgia | Terrell | 13273 | 2118 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-07-04 04:20:54 | Terrell, Georgia, US | |
3366213 | 3366213 | 2022-07-02 | US | Georgia | Terrell | 13273 | 2118 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-07-03 04:20:59 | Terrell, Georgia, US | |
594542 | 594542 | 2022-07-01 | US | Georgia | Terrell | 13273 | 2118 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-07-02 04:21:16 | Terrell, Georgia, US | |
3940943 | 3940943 | 2022-06-30 | US | Georgia | Terrell | 13273 | 2118 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-07-01 04:21:10 | Terrell, Georgia, US | |
2490901 | 2490901 | 2022-06-29 | US | Georgia | Terrell | 13273 | 2118 | 68 | 0 | 31.77527543 | -84.44069698 | 2022-06-30 04:21:01 | Terrell, Georgia, US | |
2240612 | 2240612 | 2022-06-28 | US | Iowa | Keokuk | 19107 | 2118 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-06-29 04:20:59 | Keokuk, Iowa, US | |
2151150 | 2151150 | 2022-06-27 | US | West Virginia | Pocahontas | 54075 | 2118 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-06-28 04:20:58 | Pocahontas, West Virginia, US | |
2148854 | 2148854 | 2022-06-27 | US | Iowa | Keokuk | 19107 | 2118 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-06-28 04:20:58 | Keokuk, Iowa, US | |
476655 | 476655 | 2022-06-26 | US | Iowa | Keokuk | 19107 | 2118 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-06-27 04:21:00 | Keokuk, Iowa, US | |
940030 | 940030 | 2022-06-25 | US | Iowa | Keokuk | 19107 | 2118 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-06-26 04:21:02 | Keokuk, Iowa, US | |
3347850 | 3347850 | 2022-06-24 | US | Iowa | Keokuk | 19107 | 2118 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-06-25 04:20:57 | Keokuk, Iowa, US | |
1649591 | 1649591 | 2022-06-23 | US | Iowa | Keokuk | 19107 | 2118 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-06-24 04:20:58 | Keokuk, Iowa, US | |
2191121 | 2191121 | 2022-06-22 | US | West Virginia | Pleasants | 54073 | 2118 | 36 | 0 | 39.37091679 | -81.16771771 | 2022-06-23 04:20:55 | Pleasants, West Virginia, US | |
2188826 | 2188826 | 2022-06-22 | US | Iowa | Keokuk | 19107 | 2118 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-06-23 04:20:55 | Keokuk, Iowa, US | |
1421502 | 1421502 | 2022-06-08 | US | Alabama | Perry | 1105 | 2118 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-06-09 04:20:54 | Perry, Alabama, US | |
3189042 | 3189042 | 2022-05-30 | US | Texas | Clay | 48077 | 2118 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-05-31 04:20:51 | Clay, Texas, US | |
3201191 | 3201191 | 2022-05-29 | US | Texas | Clay | 48077 | 2118 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-05-30 04:20:50 | Clay, Texas, US | |
2728069 | 2728069 | 2022-05-28 | US | Texas | Clay | 48077 | 2118 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-05-29 04:20:53 | Clay, Texas, US | |
1317250 | 1317250 | 2022-05-27 | US | Texas | Clay | 48077 | 2118 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-05-28 04:21:07 | Clay, Texas, US | |
2051092 | 2051092 | 2022-05-25 | US | Texas | Somervell | 48425 | 2118 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-05-26 04:20:50 | Somervell, Texas, US | |
3002530 | 3002530 | 2022-05-24 | US | Texas | Somervell | 48425 | 2118 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-05-25 04:20:56 | Somervell, Texas, US | |
3596251 | 3596251 | 2022-05-23 | US | Texas | Somervell | 48425 | 2118 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-05-24 04:20:57 | Somervell, Texas, US | |
625103 | 625103 | 2022-05-22 | US | Texas | Somervell | 48425 | 2118 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-05-26 04:20:50 | Somervell, Texas, US | |
1112799 | 1112799 | 2022-05-21 | US | Texas | Somervell | 48425 | 2118 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-05-22 04:20:52 | Somervell, Texas, US | |
1172423 | 1172423 | 2022-05-20 | US | Texas | Somervell | 48425 | 2118 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-05-21 04:20:58 | Somervell, Texas, US | |
1572915 | 1572915 | 2022-05-03 | US | Georgia | Clinch | 13065 | 2118 | 42 | 0 | 30.91395822 | -82.70432472 | 2022-05-04 04:20:59 | Clinch, Georgia, US | |
464175 | 464175 | 2022-05-02 | US | Georgia | Clinch | 13065 | 2118 | 42 | 0 | 30.91395822 | -82.70432472 | 2022-05-03 04:21:00 | Clinch, Georgia, US | |
3916814 | 3916814 | 2022-05-01 | US | Georgia | Clinch | 13065 | 2118 | 42 | 0 | 30.91395822 | -82.70432472 | 2022-05-02 04:21:10 | Clinch, Georgia, US | |
2841618 | 2841618 | 2022-04-30 | US | Georgia | Clinch | 13065 | 2118 | 42 | 0 | 30.91395822 | -82.70432472 | 2022-05-01 04:20:57 | Clinch, Georgia, US | |
1157931 | 1157931 | 2022-04-29 | US | Georgia | Clinch | 13065 | 2118 | 42 | 0 | 30.91395822 | -82.70432472 | 2022-04-30 04:21:05 | Clinch, Georgia, US | |
1697666 | 1697666 | 2022-04-28 | US | Kansas | Pawnee | 20145 | 2118 | 24 | 0 | 38.18108732 | -99.23692334 | 2022-04-29 04:20:59 | Pawnee, 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]);