johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
155 rows where confirmed = 5604 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954461 | 2954461 | 2022-12-20 | US | Texas | Deaf Smith | 48117 | 5604 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-21 04:21:03 | Deaf Smith, Texas, US | |
3176863 | 3176863 | 2022-12-19 | US | Texas | Deaf Smith | 48117 | 5604 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-20 04:21:04 | Deaf Smith, Texas, US | |
1631380 | 1631380 | 2022-12-18 | US | Texas | Deaf Smith | 48117 | 5604 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-19 04:21:03 | Deaf Smith, Texas, US | |
506759 | 506759 | 2022-12-17 | US | Texas | Deaf Smith | 48117 | 5604 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-18 04:21:03 | Deaf Smith, Texas, US | |
3327331 | 3327331 | 2022-12-16 | US | Texas | Deaf Smith | 48117 | 5604 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-17 04:21:04 | Deaf Smith, Texas, US | |
545843 | 545843 | 2022-12-15 | US | Texas | Deaf Smith | 48117 | 5604 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-16 04:21:01 | Deaf Smith, Texas, US | |
351371 | 351371 | 2022-12-14 | US | Texas | Deaf Smith | 48117 | 5604 | 116 | 0 | 34.96522957 | -102.6054267 | 2022-12-15 04:20:58 | Deaf Smith, Texas, US | |
308720 | 308720 | 2022-12-13 | US | Georgia | Lamar | 13171 | 5604 | 125 | 0 | 33.07841647 | -84.14263877 | 2022-12-14 04:21:04 | Lamar, Georgia, US | |
1149781 | 1149781 | 2022-12-12 | US | Georgia | Lamar | 13171 | 5604 | 125 | 0 | 33.07841647 | -84.14263877 | 2022-12-13 04:21:01 | Lamar, Georgia, US | |
869635 | 869635 | 2022-12-11 | US | Georgia | Lamar | 13171 | 5604 | 125 | 0 | 33.07841647 | -84.14263877 | 2022-12-12 04:21:01 | Lamar, Georgia, US | |
258165 | 258165 | 2022-12-10 | US | Georgia | Lamar | 13171 | 5604 | 125 | 0 | 33.07841647 | -84.14263877 | 2022-12-11 04:20:50 | Lamar, Georgia, US | |
3936879 | 3936879 | 2022-12-09 | US | Georgia | Lamar | 13171 | 5604 | 125 | 0 | 33.07841647 | -84.14263877 | 2022-12-10 04:21:02 | Lamar, Georgia, US | |
3378211 | 3378211 | 2022-12-08 | US | Georgia | Lamar | 13171 | 5604 | 125 | 0 | 33.07841647 | -84.14263877 | 2022-12-09 04:21:05 | Lamar, Georgia, US | |
2486557 | 2486557 | 2022-11-16 | US | California | Inyo | 6027 | 5604 | 60 | 0 | 36.51112084 | -117.4111978 | 2022-11-17 04:21:11 | Inyo, California, US | |
2432657 | 2432657 | 2022-11-09 | US | Minnesota | Fillmore | 27045 | 5604 | 31 | 0 | 43.67394126 | -92.08980382 | 2022-11-10 04:21:16 | Fillmore, Minnesota, US | |
481313 | 481313 | 2022-11-08 | US | Minnesota | Fillmore | 27045 | 5604 | 31 | 0 | 43.67394126 | -92.08980382 | 2022-11-09 04:21:22 | Fillmore, Minnesota, US | |
2440463 | 2440463 | 2022-11-07 | US | Minnesota | Fillmore | 27045 | 5604 | 31 | 0 | 43.67394126 | -92.08980382 | 2022-11-08 04:21:21 | Fillmore, Minnesota, US | |
1051561 | 1051561 | 2022-11-06 | US | Minnesota | Fillmore | 27045 | 5604 | 31 | 0 | 43.67394126 | -92.08980382 | 2022-11-07 04:21:26 | Fillmore, Minnesota, US | |
619585 | 619585 | 2022-11-05 | US | Minnesota | Fillmore | 27045 | 5604 | 31 | 0 | 43.67394126 | -92.08980382 | 2022-11-06 04:21:24 | Fillmore, Minnesota, US | |
1024089 | 1024089 | 2022-11-04 | US | Minnesota | Fillmore | 27045 | 5604 | 31 | 0 | 43.67394126 | -92.08980382 | 2022-11-05 04:21:52 | Fillmore, Minnesota, US | |
434580 | 434580 | 2022-11-03 | US | Texas | Scurry | 48415 | 5604 | 107 | 0 | 32.74613808 | -100.9162664 | 2022-11-04 04:22:11 | Scurry, Texas, US | |
433080 | 433080 | 2022-11-03 | US | Minnesota | Fillmore | 27045 | 5604 | 31 | 0 | 43.67394126 | -92.08980382 | 2022-11-04 04:22:11 | Fillmore, Minnesota, US | |
852822 | 852822 | 2022-11-02 | US | Texas | Scurry | 48415 | 5604 | 107 | 0 | 32.74613808 | -100.9162664 | 2022-11-03 04:22:05 | Scurry, Texas, US | |
3098851 | 3098851 | 2022-10-09 | US | Kentucky | Garrard | 21079 | 5604 | 86 | 0 | 37.6388668 | -84.53289319 | 2022-10-10 04:22:32 | Garrard, Kentucky, US | |
4004076 | 4004076 | 2022-10-08 | US | Kentucky | Garrard | 21079 | 5604 | 86 | 0 | 37.6388668 | -84.53289319 | 2022-10-09 04:21:16 | Garrard, Kentucky, US | |
397673 | 397673 | 2022-10-07 | US | Kentucky | Garrard | 21079 | 5604 | 86 | 0 | 37.6388668 | -84.53289319 | 2022-10-08 04:22:56 | Garrard, Kentucky, US | |
2530790 | 2530790 | 2022-10-06 | US | Kentucky | Garrard | 21079 | 5604 | 86 | 0 | 37.6388668 | -84.53289319 | 2022-10-07 04:23:08 | Garrard, Kentucky, US | |
1812184 | 1812184 | 2022-10-05 | US | Kentucky | Garrard | 21079 | 5604 | 86 | 0 | 37.6388668 | -84.53289319 | 2022-10-06 04:21:22 | Garrard, Kentucky, US | |
132158 | 132158 | 2022-10-04 | US | Kentucky | Garrard | 21079 | 5604 | 86 | 0 | 37.6388668 | -84.53289319 | 2022-10-05 04:23:06 | Garrard, Kentucky, US | |
2687105 | 2687105 | 2022-10-03 | US | Kentucky | Garrard | 21079 | 5604 | 86 | 0 | 37.6388668 | -84.53289319 | 2022-10-04 04:22:55 | Garrard, Kentucky, US | |
3774800 | 3774800 | 2022-08-30 | US | Georgia | Union | 13291 | 5604 | 166 | 0 | 34.82995757 | -83.98967069 | 2022-08-31 04:20:57 | Union, Georgia, US | |
1681396 | 1681396 | 2022-08-29 | US | Georgia | Union | 13291 | 5604 | 166 | 0 | 34.82995757 | -83.98967069 | 2022-08-30 04:21:03 | Union, Georgia, US | |
1877880 | 1877880 | 2022-08-28 | US | Georgia | Union | 13291 | 5604 | 166 | 0 | 34.82995757 | -83.98967069 | 2022-08-29 04:21:06 | Union, Georgia, US | |
2097007 | 2097007 | 2022-08-27 | US | Georgia | Union | 13291 | 5604 | 166 | 0 | 34.82995757 | -83.98967069 | 2022-08-28 04:21:02 | Union, Georgia, US | |
1532822 | 1532822 | 2022-08-26 | US | Georgia | Union | 13291 | 5604 | 166 | 0 | 34.82995757 | -83.98967069 | 2022-08-27 04:20:57 | Union, Georgia, US | |
2829709 | 2829709 | 2022-08-25 | US | Georgia | Union | 13291 | 5604 | 166 | 0 | 34.82995757 | -83.98967069 | 2022-08-26 04:21:02 | Union, Georgia, US | |
2324242 | 2324242 | 2022-08-24 | US | Georgia | Union | 13291 | 5604 | 166 | 0 | 34.82995757 | -83.98967069 | 2022-08-25 04:21:13 | Union, Georgia, US | |
1408368 | 1408368 | 2022-08-02 | US | Virginia | Colonial Heights | 51570 | 5604 | 101 | 0 | 37.26420587 | -77.39609676 | 2022-08-03 04:20:59 | Colonial Heights, Virginia, US | |
1489928 | 1489928 | 2022-07-26 | US | North Carolina | Madison | 37115 | 5604 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-07-27 04:21:04 | Madison, North Carolina, US | |
2596374 | 2596374 | 2022-07-25 | US | North Carolina | Madison | 37115 | 5604 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-07-26 04:20:58 | Madison, North Carolina, US | |
898489 | 898489 | 2022-07-24 | US | North Carolina | Madison | 37115 | 5604 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-07-25 04:20:51 | Madison, North Carolina, US | |
93483 | 93483 | 2022-07-23 | US | North Carolina | Madison | 37115 | 5604 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-07-24 04:20:47 | Madison, North Carolina, US | |
902505 | 902505 | 2022-07-22 | US | North Carolina | Madison | 37115 | 5604 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-07-23 04:20:53 | Madison, North Carolina, US | |
672641 | 672641 | 2022-07-21 | US | North Carolina | Madison | 37115 | 5604 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-07-22 04:21:15 | Madison, North Carolina, US | |
670132 | 670132 | 2022-07-21 | Colombia | Guaviare | 5604 | 105 | 0 | 1.0654 | -73.2603 | 2022-07-22 04:21:15 | Guaviare, Colombia | |||
1610604 | 1610604 | 2022-07-20 | US | North Carolina | Madison | 37115 | 5604 | 81 | 0 | 35.85402722 | -82.71346418 | 2022-07-21 04:21:10 | Madison, North Carolina, US | |
1608095 | 1608095 | 2022-07-20 | Colombia | Guaviare | 5604 | 105 | 0 | 1.0654 | -73.2603 | 2022-07-21 04:21:10 | Guaviare, Colombia | |||
958728 | 958728 | 2022-07-19 | Colombia | Guaviare | 5604 | 105 | 0 | 1.0654 | -73.2603 | 2022-07-20 04:20:59 | Guaviare, Colombia | |||
3210115 | 3210115 | 2022-07-18 | Colombia | Guaviare | 5604 | 105 | 0 | 1.0654 | -73.2603 | 2022-07-19 04:20:58 | Guaviare, Colombia | |||
3405290 | 3405290 | 2022-07-17 | Colombia | Guaviare | 5604 | 105 | 0 | 1.0654 | -73.2603 | 2022-07-18 04:20:59 | Guaviare, Colombia | |||
2151490 | 2151490 | 2022-07-16 | Colombia | Guaviare | 5604 | 105 | 0 | 1.0654 | -73.2603 | 2022-07-17 04:21:15 | Guaviare, Colombia | |||
2418723 | 2418723 | 2022-07-15 | Colombia | Guaviare | 5604 | 105 | 0 | 1.0654 | -73.2603 | 2022-07-16 04:21:05 | Guaviare, Colombia | |||
3428798 | 3428798 | 2022-07-14 | Colombia | Guaviare | 5604 | 105 | 0 | 1.0654 | -73.2603 | 2022-07-15 04:20:53 | Guaviare, Colombia | |||
3109318 | 3109318 | 2022-07-13 | Colombia | Guaviare | 5604 | 105 | 0 | 1.0654 | -73.2603 | 2022-07-14 04:20:57 | Guaviare, Colombia | |||
629741 | 629741 | 2022-07-12 | Colombia | Guaviare | 5604 | 105 | 0 | 1.0654 | -73.2603 | 2022-07-13 04:20:58 | Guaviare, Colombia | |||
1211385 | 1211385 | 2022-07-11 | Colombia | Guaviare | 5604 | 105 | 0 | 1.0654 | -73.2603 | 2022-07-12 04:20:51 | Guaviare, Colombia | |||
2788867 | 2788867 | 2022-07-10 | Colombia | Guaviare | 5604 | 105 | 0 | 1.0654 | -73.2603 | 2022-07-11 04:20:46 | Guaviare, Colombia | |||
141820 | 141820 | 2022-07-09 | Colombia | Guaviare | 5604 | 105 | 0 | 1.0654 | -73.2603 | 2022-07-10 04:20:54 | Guaviare, Colombia | |||
1416920 | 1416920 | 2022-07-08 | Colombia | Guaviare | 5604 | 105 | 0 | 1.0654 | -73.2603 | 2022-07-09 04:20:59 | Guaviare, Colombia | |||
2740845 | 2740845 | 2022-07-07 | Colombia | Guaviare | 5604 | 105 | 0 | 1.0654 | -73.2603 | 2022-07-08 04:20:56 | Guaviare, Colombia | |||
3081159 | 3081159 | 2022-07-04 | US | Texas | Gillespie | 48171 | 5604 | 109 | 0 | 30.31824095 | -98.94676915 | 2022-07-05 04:20:45 | Gillespie, Texas, US | |
1770441 | 1770441 | 2022-07-03 | US | Texas | Gillespie | 48171 | 5604 | 109 | 0 | 30.31824095 | -98.94676915 | 2022-07-04 04:20:54 | Gillespie, Texas, US | |
3368427 | 3368427 | 2022-07-02 | US | Texas | Gillespie | 48171 | 5604 | 109 | 0 | 30.31824095 | -98.94676915 | 2022-07-03 04:20:59 | Gillespie, Texas, US | |
596756 | 596756 | 2022-07-01 | US | Texas | Gillespie | 48171 | 5604 | 109 | 0 | 30.31824095 | -98.94676915 | 2022-07-02 04:21:16 | Gillespie, Texas, US | |
3272853 | 3272853 | 2022-06-19 | US | Virginia | Fluvanna | 51065 | 5604 | 47 | 0 | 37.84157909 | -78.27715475 | 2022-06-20 04:21:01 | Fluvanna, Virginia, US | |
3400765 | 3400765 | 2022-06-18 | US | Virginia | Fluvanna | 51065 | 5604 | 47 | 0 | 37.84157909 | -78.27715475 | 2022-06-19 04:20:51 | Fluvanna, Virginia, US | |
2314642 | 2314642 | 2022-06-17 | US | Virginia | Fluvanna | 51065 | 5604 | 47 | 0 | 37.84157909 | -78.27715475 | 2022-06-18 04:21:10 | Fluvanna, Virginia, US | |
949623 | 949623 | 2022-06-14 | US | Puerto Rico | Quebradillas | 72115 | 5604 | 0 | 0 | 18.439692 | -66.926113 | 2022-06-15 04:20:54 | Quebradillas, Puerto Rico, US | |
3729709 | 3729709 | 2022-06-07 | US | West Virginia | Lewis | 54041 | 5604 | 87 | 0 | 38.9947249 | -80.49988181 | 2022-06-08 04:20:55 | Lewis, West Virginia, US | |
3530619 | 3530619 | 2022-06-04 | US | Texas | Lampasas | 48281 | 5604 | 91 | 0 | 31.19531316 | -98.24206613 | 2022-06-05 04:20:55 | Lampasas, Texas, US | |
3000260 | 3000260 | 2022-05-24 | US | Idaho | Payette | 16075 | 5604 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-05-25 04:20:56 | Payette, Idaho, US | |
3594517 | 3594517 | 2022-05-23 | US | Louisiana | Assumption | 22007 | 5604 | 70 | 0 | 29.89946234 | -91.06461642 | 2022-05-24 04:20:57 | Assumption, Louisiana, US | |
3593981 | 3593981 | 2022-05-23 | US | Idaho | Payette | 16075 | 5604 | 87 | 0 | 44.00545243 | -116.7647695 | 2022-05-24 04:20:57 | Payette, Idaho, US | |
1172381 | 1172381 | 2022-05-20 | US | Texas | Moore | 48341 | 5604 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-05-21 04:20:58 | Moore, Texas, US | |
3899144 | 3899144 | 2022-05-19 | US | Texas | Moore | 48341 | 5604 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-05-20 04:20:57 | Moore, Texas, US | |
1187928 | 1187928 | 2022-05-18 | US | Texas | Moore | 48341 | 5604 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-05-19 04:20:54 | Moore, Texas, US | |
3585825 | 3585825 | 2022-05-17 | US | Texas | Moore | 48341 | 5604 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-05-18 04:20:50 | Moore, Texas, US | |
1506782 | 1506782 | 2022-05-16 | US | Texas | Moore | 48341 | 5604 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-05-17 04:20:59 | Moore, Texas, US | |
2087141 | 2087141 | 2022-05-15 | US | Texas | Moore | 48341 | 5604 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-05-16 04:20:47 | Moore, Texas, US | |
3357851 | 3357851 | 2022-05-14 | US | Texas | Moore | 48341 | 5604 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-05-15 04:20:53 | Moore, Texas, US | |
661496 | 661496 | 2022-05-13 | US | Texas | Moore | 48341 | 5604 | 111 | 0 | 35.83769242 | -101.8930281 | 2022-05-14 04:20:48 | Moore, Texas, US | |
2334595 | 2334595 | 2022-05-08 | US | Texas | San Jacinto | 48407 | 5604 | 101 | 0 | 30.57933681 | -95.16260304 | 2022-05-09 04:20:54 | San Jacinto, Texas, US | |
363557 | 363557 | 2022-05-07 | US | Texas | San Jacinto | 48407 | 5604 | 101 | 0 | 30.57933681 | -95.16260304 | 2022-05-08 04:20:49 | San Jacinto, Texas, US | |
2892612 | 2892612 | 2022-04-21 | Russia | Chukotka Autonomous Okrug | 5604 | 42 | 0 | 66.0006475 | 169.4900869 | 2022-04-22 04:20:45 | Chukotka Autonomous Okrug, Russia | |||
1655158 | 1655158 | 2022-04-09 | US | Puerto Rico | Moca | 72099 | 5604 | 0 | 0 | 18.377805 | -67.080952 | 2022-04-10 04:20:52 | Moca, Puerto Rico, US | |
3323737 | 3323737 | 2022-04-07 | US | West Virginia | McDowell | 54047 | 5604 | 72 | 0 | 37.38002939 | -81.65083669 | 2022-04-08 04:20:48 | McDowell, West Virginia, US | |
159692 | 159692 | 2022-03-29 | US | Michigan | Otsego | 26137 | 5604 | 99 | 0 | 45.02085831 | -84.59898295 | 2022-03-30 04:20:45 | Otsego, Michigan, US | |
1438263 | 1438263 | 2022-03-28 | US | Michigan | Otsego | 26137 | 5604 | 99 | 0 | 45.02085831 | -84.59898295 | 2022-03-29 04:20:46 | Otsego, Michigan, US | |
27808 | 27808 | 2022-03-20 | US | Virginia | Salem | 51775 | 5604 | 96 | 0 | 37.2836193 | -80.06219455 | 2022-03-21 04:20:50 | Salem, Virginia, US | |
1659818 | 1659818 | 2022-03-19 | US | Virginia | Salem | 51775 | 5604 | 96 | 0 | 37.2836193 | -80.06219455 | 2022-03-20 04:20:45 | Salem, Virginia, US | |
339344 | 339344 | 2022-03-18 | US | Virginia | Salem | 51775 | 5604 | 96 | 0 | 37.2836193 | -80.06219455 | 2022-03-19 04:20:47 | Salem, Virginia, US | |
2734379 | 2734379 | 2022-02-27 | US | Kansas | Sumner | 20191 | 5604 | 66 | 0 | 37.23682549 | -97.47721621 | 2022-02-28 04:21:05 | Sumner, Kansas, US | |
3047532 | 3047532 | 2022-02-26 | US | Kansas | Sumner | 20191 | 5604 | 66 | 0 | 37.23682549 | -97.47721621 | 2022-02-27 04:21:04 | Sumner, Kansas, US | |
576187 | 576187 | 2022-02-25 | US | Kansas | Sumner | 20191 | 5604 | 66 | 0 | 37.23682549 | -97.47721621 | 2022-02-26 04:21:12 | Sumner, Kansas, US | |
1060889 | 1060889 | 2022-02-23 | US | Texas | Calhoun | 48057 | 5604 | 46 | 0 | 28.47048236 | -96.61633945 | 2022-02-24 04:21:14 | Calhoun, Texas, US | |
3720396 | 3720396 | 2022-02-21 | US | New Mexico | San Miguel | 35047 | 5604 | 49 | 0 | 35.48014807 | -104.8163562 | 2022-02-22 04:21:01 | San Miguel, New Mexico, US | |
1365105 | 1365105 | 2022-02-08 | US | Puerto Rico | Juncos | 72077 | 5604 | 0 | 0 | 18.223793 | -65.909109 | 2022-02-09 04:21:04 | Juncos, Puerto Rico, US | |
73843 | 73843 | 2022-02-07 | US | Puerto Rico | Juncos | 72077 | 5604 | 0 | 0 | 18.223793 | -65.909109 | 2022-02-08 04:21:15 | Juncos, Puerto Rico, US | |
2475079 | 2475079 | 2022-02-03 | US | Indiana | Owen | 18119 | 5604 | 104 | 0 | 39.31145587 | -86.83900724 | 2022-02-04 04:21:10 | Owen, Indiana, US | |
1143102 | 1143102 | 2022-01-23 | US | New Mexico | Cibola | 35006 | 5604 | 166 | 0 | 34.91131525 | -107.998876 | 2022-01-24 04:21:12 | Cibola, New Mexico, 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]);