johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
148 rows where confirmed = 5323 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- US 115
- France 21
- Australia 2
- Germany 2
- Japan 2
- Russia 2
- China 1
- Iceland 1
- Netherlands 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2559938 | 2559938 | 2022-11-29 | US | Virginia | Goochland | 51075 | 5323 | 61 | 0 | 37.71714806 | -77.90381514 | 2022-11-30 04:21:07 | Goochland, Virginia, US | |
3596926 | 3596926 | 2022-11-14 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-11-15 04:21:16 | Saint Barthelemy, France | |||
311784 | 311784 | 2022-11-13 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-11-14 04:21:09 | Saint Barthelemy, France | |||
62945 | 62945 | 2022-11-12 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-11-13 04:21:14 | Saint Barthelemy, France | |||
2927107 | 2927107 | 2022-11-11 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-11-12 04:20:41 | Saint Barthelemy, France | |||
2505943 | 2505943 | 2022-11-10 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-11-11 04:21:22 | Saint Barthelemy, France | |||
2430818 | 2430818 | 2022-11-09 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-11-10 04:21:16 | Saint Barthelemy, France | |||
479474 | 479474 | 2022-11-08 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-11-09 04:21:22 | Saint Barthelemy, France | |||
2438624 | 2438624 | 2022-11-07 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-11-08 04:21:21 | Saint Barthelemy, France | |||
1049722 | 1049722 | 2022-11-06 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-11-07 04:21:26 | Saint Barthelemy, France | |||
617746 | 617746 | 2022-11-05 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-11-06 04:21:24 | Saint Barthelemy, France | |||
1025128 | 1025128 | 2022-11-04 | US | Puerto Rico | Loiza | 72087 | 5323 | 0 | 0 | 18.425688 | -65.89943 | 2022-11-05 04:21:52 | Loiza, Puerto Rico, US | |
1022250 | 1022250 | 2022-11-04 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-11-05 04:21:52 | Saint Barthelemy, France | |||
431241 | 431241 | 2022-11-03 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-11-04 04:22:11 | Saint Barthelemy, France | |||
849483 | 849483 | 2022-11-02 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-11-03 04:22:05 | Saint Barthelemy, France | |||
710334 | 710334 | 2022-11-01 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-11-02 04:22:09 | Saint Barthelemy, France | |||
3284783 | 3284783 | 2022-10-31 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-11-01 04:22:36 | Saint Barthelemy, France | |||
319816 | 319816 | 2022-10-30 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-10-31 04:21:36 | Saint Barthelemy, France | |||
912092 | 912092 | 2022-10-29 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-10-30 04:22:14 | Saint Barthelemy, France | |||
1366361 | 1366361 | 2022-10-28 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-10-29 04:21:13 | Saint Barthelemy, France | |||
3038216 | 3038216 | 2022-10-27 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-10-28 04:22:31 | Saint Barthelemy, France | |||
538636 | 538636 | 2022-10-26 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-10-27 04:22:01 | Saint Barthelemy, France | |||
1830037 | 1830037 | 2022-10-25 | France | Saint Barthelemy | 5323 | 6 | 0 | 17.9 | -62.8333 | 2022-10-26 04:22:19 | Saint Barthelemy, France | |||
796102 | 796102 | 2022-10-24 | US | Michigan | Roscommon | 26143 | 5323 | 123 | 0 | 44.33473082 | -84.61067651 | 2022-10-25 04:21:53 | Roscommon, Michigan, US | |
3278557 | 3278557 | 2022-10-23 | US | Michigan | Roscommon | 26143 | 5323 | 123 | 0 | 44.33473082 | -84.61067651 | 2022-10-24 04:22:29 | Roscommon, Michigan, US | |
2269595 | 2269595 | 2022-10-22 | US | Michigan | Roscommon | 26143 | 5323 | 123 | 0 | 44.33473082 | -84.61067651 | 2022-10-23 04:22:46 | Roscommon, Michigan, US | |
1593895 | 1593895 | 2022-10-21 | US | Michigan | Roscommon | 26143 | 5323 | 123 | 0 | 44.33473082 | -84.61067651 | 2022-10-22 04:22:53 | Roscommon, Michigan, US | |
2273611 | 2273611 | 2022-10-20 | US | Michigan | Roscommon | 26143 | 5323 | 123 | 0 | 44.33473082 | -84.61067651 | 2022-10-21 04:22:23 | Roscommon, Michigan, US | |
199946 | 199946 | 2022-10-19 | US | Michigan | Roscommon | 26143 | 5323 | 123 | 0 | 44.33473082 | -84.61067651 | 2022-10-20 04:22:59 | Roscommon, Michigan, US | |
2758607 | 2758607 | 2022-10-18 | US | Michigan | Roscommon | 26143 | 5323 | 123 | 0 | 44.33473082 | -84.61067651 | 2022-10-19 04:22:26 | Roscommon, Michigan, US | |
2967894 | 2967894 | 2022-10-10 | US | Arkansas | Drew | 5043 | 5323 | 75 | 0 | 33.59035001 | -91.71777921 | 2022-10-11 04:23:05 | Drew, Arkansas, US | |
3097930 | 3097930 | 2022-10-09 | US | Arkansas | Drew | 5043 | 5323 | 75 | 0 | 33.59035001 | -91.71777921 | 2022-10-10 04:22:32 | Drew, Arkansas, US | |
2532121 | 2532121 | 2022-10-06 | US | Puerto Rico | Comerio | 72045 | 5323 | 0 | 0 | 18.224687 | -66.221622 | 2022-10-07 04:23:08 | Comerio, Puerto Rico, US | |
3572245 | 3572245 | 2022-09-19 | US | Michigan | Iosco | 26069 | 5323 | 156 | 0 | 44.35486835 | -83.63484895 | 2022-09-20 04:22:48 | Iosco, Michigan, US | |
420984 | 420984 | 2022-09-18 | US | Michigan | Iosco | 26069 | 5323 | 156 | 0 | 44.35486835 | -83.63484895 | 2022-09-19 04:21:49 | Iosco, Michigan, US | |
3375008 | 3375008 | 2022-09-17 | US | Michigan | Iosco | 26069 | 5323 | 156 | 0 | 44.35486835 | -83.63484895 | 2022-09-18 04:22:50 | Iosco, Michigan, US | |
2357116 | 2357116 | 2022-09-16 | US | Michigan | Iosco | 26069 | 5323 | 156 | 0 | 44.35486835 | -83.63484895 | 2022-09-17 04:20:19 | Iosco, Michigan, US | |
3988273 | 3988273 | 2022-09-15 | US | Michigan | Iosco | 26069 | 5323 | 156 | 0 | 44.35486835 | -83.63484895 | 2022-09-16 04:21:19 | Iosco, Michigan, US | |
1890790 | 1890790 | 2022-09-14 | US | Michigan | Iosco | 26069 | 5323 | 156 | 0 | 44.35486835 | -83.63484895 | 2022-09-15 04:21:02 | Iosco, Michigan, US | |
373845 | 373845 | 2022-09-13 | US | Michigan | Iosco | 26069 | 5323 | 156 | 0 | 44.35486835 | -83.63484895 | 2022-09-14 04:20:44 | Iosco, Michigan, US | |
2637251 | 2637251 | 2022-09-05 | US | Wisconsin | Adams | 55001 | 5323 | 65 | 0 | 43.96974651 | -89.76782777 | 2022-09-06 04:21:02 | Adams, Wisconsin, US | |
1251732 | 1251732 | 2022-08-23 | US | Illinois | Clay | 17025 | 5323 | 70 | 0 | 38.75388572 | -88.48914513 | 2022-08-24 04:20:46 | Clay, Illinois, US | |
3950974 | 3950974 | 2022-08-17 | US | Arkansas | Cross | 5037 | 5323 | 88 | 0 | 35.29631396 | -90.77185818 | 2022-08-18 04:21:11 | Cross, Arkansas, US | |
1349701 | 1349701 | 2022-08-10 | US | Virginia | New Kent | 51127 | 5323 | 38 | 0 | 37.50694406 | -76.99828634 | 2022-08-11 04:20:49 | New Kent, Virginia, US | |
3546710 | 3546710 | 2022-08-08 | US | Texas | Scurry | 48415 | 5323 | 105 | 0 | 32.74613808 | -100.9162664 | 2022-08-09 04:20:34 | Scurry, Texas, US | |
897591 | 897591 | 2022-07-24 | US | Kentucky | Mason | 21161 | 5323 | 108 | 0 | 38.59471935 | -83.82151043 | 2022-07-25 04:20:51 | Mason, Kentucky, US | |
92585 | 92585 | 2022-07-23 | US | Kentucky | Mason | 21161 | 5323 | 108 | 0 | 38.59471935 | -83.82151043 | 2022-07-24 04:20:47 | Mason, Kentucky, US | |
901607 | 901607 | 2022-07-22 | US | Kentucky | Mason | 21161 | 5323 | 108 | 0 | 38.59471935 | -83.82151043 | 2022-07-23 04:20:53 | Mason, Kentucky, US | |
672509 | 672509 | 2022-07-21 | US | New Mexico | Roosevelt | 35041 | 5323 | 104 | 0 | 34.02097406 | -103.4799493 | 2022-07-22 04:21:15 | Roosevelt, New Mexico, US | |
671743 | 671743 | 2022-07-21 | US | Kentucky | Mason | 21161 | 5323 | 108 | 0 | 38.59471935 | -83.82151043 | 2022-07-22 04:21:15 | Mason, Kentucky, US | |
1609706 | 1609706 | 2022-07-20 | US | Kentucky | Mason | 21161 | 5323 | 108 | 0 | 38.59471935 | -83.82151043 | 2022-07-21 04:21:10 | Mason, Kentucky, US | |
960339 | 960339 | 2022-07-19 | US | Kentucky | Mason | 21161 | 5323 | 108 | 0 | 38.59471935 | -83.82151043 | 2022-07-20 04:20:59 | Mason, Kentucky, US | |
3211726 | 3211726 | 2022-07-18 | US | Kentucky | Mason | 21161 | 5323 | 108 | 0 | 38.59471935 | -83.82151043 | 2022-07-19 04:20:58 | Mason, Kentucky, US | |
2791801 | 2791801 | 2022-07-10 | US | Puerto Rico | Naguabo | 72103 | 5323 | 0 | 0 | 18.230637 | -65.753897 | 2022-07-11 04:20:46 | Naguabo, Puerto Rico, US | |
3940720 | 3940720 | 2022-06-30 | US | Colorado | Teller | 8119 | 5323 | 58 | 0 | 38.88133511 | -105.1614893 | 2022-07-01 04:21:10 | Teller, Colorado, US | |
1650336 | 1650336 | 2022-06-23 | US | Missouri | Ray | 29177 | 5323 | 95 | 0 | 39.3537468 | -93.98905745 | 2022-06-24 04:20:58 | Ray, Missouri, US | |
2189571 | 2189571 | 2022-06-22 | US | Missouri | Ray | 29177 | 5323 | 95 | 0 | 39.3537468 | -93.98905745 | 2022-06-23 04:20:55 | Ray, Missouri, US | |
168002 | 168002 | 2022-06-21 | US | Missouri | Ray | 29177 | 5323 | 95 | 0 | 39.3537468 | -93.98905745 | 2022-06-22 04:20:54 | Ray, Missouri, US | |
1765285 | 1765285 | 2022-06-20 | US | Missouri | Ray | 29177 | 5323 | 95 | 0 | 39.3537468 | -93.98905745 | 2022-06-21 04:20:56 | Ray, Missouri, US | |
3271471 | 3271471 | 2022-06-19 | US | Missouri | Ray | 29177 | 5323 | 95 | 0 | 39.3537468 | -93.98905745 | 2022-06-20 04:21:01 | Ray, Missouri, US | |
3399383 | 3399383 | 2022-06-18 | US | Missouri | Ray | 29177 | 5323 | 95 | 0 | 39.3537468 | -93.98905745 | 2022-06-19 04:20:51 | Ray, Missouri, US | |
2313260 | 2313260 | 2022-06-17 | US | Missouri | Ray | 29177 | 5323 | 95 | 0 | 39.3537468 | -93.98905745 | 2022-06-18 04:21:10 | Ray, Missouri, US | |
1421498 | 1421498 | 2022-06-08 | US | Alabama | Monroe | 1099 | 5323 | 80 | 0 | 31.56729412 | -87.36995001 | 2022-06-09 04:20:54 | Monroe, Alabama, US | |
3189386 | 3189386 | 2022-05-30 | US | Virginia | Powhatan | 51145 | 5323 | 59 | 0 | 37.55016038 | -77.91267882 | 2022-05-31 04:20:51 | Powhatan, Virginia, US | |
3201535 | 3201535 | 2022-05-29 | US | Virginia | Powhatan | 51145 | 5323 | 59 | 0 | 37.55016038 | -77.91267882 | 2022-05-30 04:20:50 | Powhatan, Virginia, US | |
2728413 | 2728413 | 2022-05-28 | US | Virginia | Powhatan | 51145 | 5323 | 59 | 0 | 37.55016038 | -77.91267882 | 2022-05-29 04:20:53 | Powhatan, Virginia, US | |
1317594 | 1317594 | 2022-05-27 | US | Virginia | Powhatan | 51145 | 5323 | 59 | 0 | 37.55016038 | -77.91267882 | 2022-05-28 04:21:07 | Powhatan, Virginia, US | |
466947 | 466947 | 2022-05-02 | US | Wisconsin | Iowa | 55049 | 5323 | 28 | 0 | 43.00050278 | -90.13469017 | 2022-05-03 04:21:00 | Iowa, Wisconsin, US | |
1329738 | 1329738 | 2022-04-26 | US | West Virginia | Lewis | 54041 | 5323 | 86 | 0 | 38.9947249 | -80.49988181 | 2022-04-27 04:20:52 | Lewis, West Virginia, US | |
2895757 | 2895757 | 2022-04-21 | US | Virginia | Fredericksburg | 51630 | 5323 | 42 | 0 | 38.2977863 | -77.4922454 | 2022-04-22 04:20:45 | Fredericksburg, Virginia, US | |
2310629 | 2310629 | 2022-04-20 | US | Virginia | Fredericksburg | 51630 | 5323 | 42 | 0 | 38.2977863 | -77.4922454 | 2022-04-21 04:20:46 | Fredericksburg, Virginia, US | |
3418392 | 3418392 | 2022-04-17 | US | Kentucky | Spencer | 21215 | 5323 | 55 | 0 | 38.03223971 | -85.32749335 | 2022-04-18 04:21:12 | Spencer, Kentucky, US | |
305341 | 305341 | 2022-04-16 | US | Kentucky | Spencer | 21215 | 5323 | 55 | 0 | 38.03223971 | -85.32749335 | 2022-04-17 04:20:59 | Spencer, Kentucky, US | |
2671286 | 2671286 | 2022-04-15 | US | Kentucky | Spencer | 21215 | 5323 | 55 | 0 | 38.03223971 | -85.32749335 | 2022-04-16 04:20:48 | Spencer, Kentucky, US | |
1225071 | 1225071 | 2022-04-14 | US | Kentucky | Spencer | 21215 | 5323 | 55 | 0 | 38.03223971 | -85.32749335 | 2022-04-15 04:20:57 | Spencer, Kentucky, US | |
2444229 | 2444229 | 2022-04-13 | US | Kentucky | Spencer | 21215 | 5323 | 55 | 0 | 38.03223971 | -85.32749335 | 2022-04-13 23:21:06 | Spencer, Kentucky, US | |
1949986 | 1949986 | 2022-04-12 | US | Kentucky | Spencer | 21215 | 5323 | 55 | 0 | 38.03223971 | -85.32749335 | 2022-04-13 04:21:03 | Spencer, Kentucky, US | |
3207739 | 3207739 | 2022-04-11 | US | Kentucky | Spencer | 21215 | 5323 | 55 | 0 | 38.03223971 | -85.32749335 | 2022-04-12 04:20:49 | Spencer, Kentucky, US | |
3322974 | 3322974 | 2022-04-07 | US | Puerto Rico | Cidra | 72041 | 5323 | 0 | 0 | 18.173559 | -66.161179 | 2022-04-08 04:20:48 | Cidra, Puerto Rico, US | |
1908293 | 1908293 | 2022-03-22 | US | Texas | Gillespie | 48171 | 5323 | 107 | 0 | 30.31824095 | -98.94676915 | 2022-03-23 04:20:48 | Gillespie, Texas, US | |
27131 | 27131 | 2022-03-20 | US | Puerto Rico | Cayey | 72035 | 5323 | 0 | 0 | 18.102851 | -66.14914 | 2022-03-21 04:20:50 | Cayey, Puerto Rico, US | |
1512462 | 1512462 | 2022-02-24 | US | Illinois | Union | 17181 | 5323 | 63 | 0 | 37.47119609 | -89.25548938 | 2022-02-25 04:21:11 | Union, Illinois, US | |
186301 | 186301 | 2022-02-13 | Russia | Nenets Autonomous Okrug | 5323 | 93 | 0 | 68.27557185 | 57.1686375 | 2022-02-14 04:20:51 | Nenets Autonomous Okrug, Russia | |||
318697 | 318697 | 2022-02-12 | US | Puerto Rico | San Sebastian | 72131 | 5323 | 0 | 0 | 18.328646 | -66.971214 | 2022-02-13 04:21:00 | San Sebastian, Puerto Rico, US | |
1467493 | 1467493 | 2022-02-10 | US | Virginia | Scott | 51169 | 5323 | 95 | 0 | 36.71466456 | -82.60171704 | 2022-02-11 04:21:09 | Scott, Virginia, US | |
558277 | 558277 | 2022-01-16 | US | West Virginia | Jackson | 54035 | 5323 | 112 | 0 | 38.84263974 | -81.68148753 | 2022-01-17 04:21:08 | Jackson, West Virginia, US | |
1694621 | 1694621 | 2022-01-10 | US | North Carolina | Cherokee | 37039 | 5323 | 90 | 0 | 35.1349263 | -84.05970864 | 2022-01-11 04:22:01 | Cherokee, North Carolina, US | |
2610077 | 2610077 | 2022-01-06 | Japan | Wakayama | 5323 | 62 | 0 | 33.911879 | 135.505446 | 2022-01-07 04:22:09 | Wakayama, Japan | |||
1700029 | 1700029 | 2022-01-03 | Australia | Australian Capital Territory | 5323 | 15 | 0 | -35.4735 | 149.0124 | 2022-01-04 04:22:17 | Australian Capital Territory, Australia | |||
3519112 | 3519112 | 2022-01-02 | Australia | Australian Capital Territory | 5323 | 15 | 0 | -35.4735 | 149.0124 | 2022-01-03 02:22:25 | Australian Capital Territory, Australia | |||
783831 | 783831 | 2021-12-13 | US | Kentucky | Marshall | 21157 | 5323 | 85 | 0 | 36.88007070000001 | -88.32803576 | 2021-12-14 04:22:38 | Marshall, Kentucky, US | |
1743987 | 1743987 | 2021-12-05 | US | Washington | Kittitas | 53037 | 5323 | 55 | 0 | 47.12521214 | -120.67943899999999 | 2021-12-06 04:22:34 | Kittitas, Washington, US | |
141419 | 141419 | 2021-12-04 | US | Washington | Kittitas | 53037 | 5323 | 55 | 0 | 47.12521214 | -120.67943899999999 | 2021-12-05 04:22:25 | Kittitas, Washington, US | |
2199072 | 2199072 | 2021-12-03 | US | Washington | Kittitas | 53037 | 5323 | 55 | 0 | 47.12521214 | -120.67943899999999 | 2021-12-04 04:22:18 | Kittitas, Washington, US | |
151049 | 151049 | 2021-11-29 | US | Indiana | Adams | 18001 | 5323 | 81 | 0 | 40.7457653 | -84.93671406 | 2021-11-30 04:22:53 | Adams, Indiana, US | |
3346239 | 3346239 | 2021-11-16 | US | Wyoming | Teton | 56039 | 5323 | 14 | 0 | 43.93522482 | -110.5890801 | 2021-11-17 04:21:48 | Teton, Wyoming, US | |
3642215 | 3642215 | 2021-11-08 | US | Pennsylvania | Clinton | 42035 | 5323 | 81 | 0 | 41.23255967 | -77.63785995 | 2021-11-09 04:21:36 | Clinton, Pennsylvania, US | |
701464 | 701464 | 2021-11-04 | US | Texas | Cooke | 48097 | 5323 | 102 | 0 | 33.63979567 | -97.21240912 | 2021-11-05 04:21:54 | Cooke, Texas, US | |
656503 | 656503 | 2021-10-22 | US | Ohio | Putnam | 39137 | 5323 | 114 | 0 | 41.02094889 | -84.1336111 | 2021-10-23 04:21:32 | Putnam, Ohio, US | |
443343 | 443343 | 2021-10-20 | Japan | Ehime | 5323 | 82 | 0 | 33.624835 | 132.856842 | 2021-10-21 04:21:18 | Ehime, Japan |
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]);