johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where active = 3816 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 27
- India 3
- Russia 2
- Ukraine 2
- Switzerland 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2764901 | 2764901 | 2021-07-01 | India | Tripura | 66629 | 683 | 62130 | 3816 | 23.746783 | 91.743565 | 2021-07-02 04:21:47 | Tripura, India | ||
107410 | 107410 | 2021-06-19 | India | Mizoram | 16750 | 76 | 12858 | 3816 | 23.309381 | 92.83822 | 2021-06-20 04:21:48 | Mizoram, India | ||
1125553 | 1125553 | 2021-06-18 | India | Mizoram | 16750 | 76 | 12858 | 3816 | 23.309381 | 92.83822 | 2021-06-19 04:22:33 | Mizoram, India | ||
2185321 | 2185321 | 2021-02-26 | US | Minnesota | Nobles | 27105 | 3863 | 47 | 0 | 3816 | 43.67434621 | -95.75329576 | 2021-02-27 05:22:28 | Nobles, Minnesota, US |
1860811 | 1860811 | 2021-02-25 | US | South Carolina | Dillon | 45033 | 3894 | 78 | 0 | 3816 | 34.39007791 | -79.37741872 | 2021-02-26 05:22:40 | Dillon, South Carolina, US |
1859912 | 1859912 | 2021-02-25 | US | Missouri | Johnson | 29101 | 3861 | 45 | 0 | 3816 | 38.74719601 | -93.80691168 | 2021-02-26 05:22:40 | Johnson, Missouri, US |
3604605 | 3604605 | 2021-02-17 | US | Wisconsin | Polk | 55095 | 3860 | 44 | 0 | 3816 | 45.46130348 | -92.44182875 | 2021-02-18 05:22:58 | Polk, Wisconsin, US |
1340835 | 1340835 | 2021-02-15 | US | Oklahoma | Logan | 40083 | 3842 | 26 | 0 | 3816 | 35.91899576 | -97.44352845 | 2021-02-16 05:24:38 | Logan, Oklahoma, US |
1674822 | 1674822 | 2021-02-07 | US | North Carolina | Vance | 37181 | 3893 | 77 | 0 | 3816 | 36.36880673 | -78.40670845 | 2021-02-08 05:22:39 | Vance, North Carolina, US |
1674807 | 1674807 | 2021-02-07 | US | North Carolina | Richmond | 37153 | 3892 | 76 | 0 | 3816 | 35.00417719 | -79.74491009 | 2021-02-08 05:22:39 | Richmond, North Carolina, US |
1673523 | 1673523 | 2021-02-07 | US | Indiana | Clinton | 18023 | 3867 | 51 | 0 | 3816 | 40.30319754 | -86.47277257 | 2021-02-08 05:22:39 | Clinton, Indiana, US |
790750 | 790750 | 2021-02-04 | US | Alabama | Franklin | 1059 | 3883 | 67 | 0 | 3816 | 34.44235334 | -87.84289505 | 2021-02-05 05:22:38 | Franklin, Alabama, US |
1898027 | 1898027 | 2021-01-29 | US | Georgia | Thomas | 13275 | 3914 | 98 | 0 | 3816 | 30.86392347 | -83.91847289 | 2021-01-30 05:22:49 | Thomas, Georgia, US |
14774 | 14774 | 2021-01-26 | US | Ohio | Athens | 39009 | 3861 | 45 | 0 | 3816 | 39.33425634 | -82.04278644 | 2021-01-27 05:23:41 | Athens, Ohio, US |
14270 | 14270 | 2021-01-26 | US | Missouri | Newton | 29145 | 3876 | 60 | 0 | 3816 | 36.90519407 | -94.3394104 | 2021-01-27 05:23:41 | Newton, Missouri, US |
3103211 | 3103211 | 2021-01-16 | US | Minnesota | Winona | 27169 | 3862 | 46 | 0 | 3816 | 43.98772283 | -91.78081305 | 2021-01-17 05:22:17 | Winona, Minnesota, US |
204191 | 204191 | 2020-12-25 | US | Missouri | Pettis | 29159 | 3876 | 60 | 0 | 3816 | 38.72798918 | -93.28471706 | 2020-12-26 05:22:28 | Pettis, Missouri, US |
3847997 | 3847997 | 2020-12-13 | Russia | Khanty-Mansi Autonomous Okrug | 37249 | 469 | 32964 | 3816 | 61.0259025 | 69.0982628 | 2020-12-14 05:26:27 | Khanty-Mansi Autonomous Okrug, Russia | ||
848498 | 848498 | 2020-12-12 | US | Tennessee | Gibson | 47053 | 3867 | 77 | 0 | 3816 | 35.99438059 | -88.93358327 | 2020-12-13 05:27:20 | Gibson, Tennessee, US |
847566 | 847566 | 2020-12-12 | US | Montana | Lewis and Clark | 30049 | 3842 | 26 | 0 | 3816 | 47.12610041 | -112.394698 | 2020-12-13 05:27:20 | Lewis and Clark, Montana, US |
2978843 | 2978843 | 2020-12-09 | Ukraine | Crimea Republic* | 17661 | 345 | 13500 | 3816 | 45.2835 | 34.2008 | 2020-12-10 05:26:19 | Crimea Republic*, Ukraine | ||
1009753 | 1009753 | 2020-12-06 | US | West Virginia | Berkeley | 54003 | 3847 | 31 | 0 | 3816 | 39.46704621 | -78.02414609 | 2020-12-07 05:26:14 | Berkeley, West Virginia, US |
1632675 | 1632675 | 2020-12-05 | US | Alabama | Jackson | 1071 | 3839 | 23 | 0 | 3816 | 34.78144169 | -85.99750489 | 2020-12-06 05:26:18 | Jackson, Alabama, US |
3569203 | 3569203 | 2020-11-29 | US | Pennsylvania | Beaver | 42007 | 3972 | 156 | 0 | 3816 | 40.6825484 | -80.34921611 | 2020-11-30 05:26:13 | Beaver, Pennsylvania, US |
3839059 | 3839059 | 2020-11-21 | US | Oklahoma | Payne | 40119 | 3833 | 17 | 0 | 3816 | 36.07695283 | -96.97584944 | 2020-11-22 05:25:45 | Payne, Oklahoma, US |
1990160 | 1990160 | 2020-11-09 | US | Louisiana | Terrebonne | 22109 | 3942 | 126 | 0 | 3816 | 29.37343766 | -90.82626855 | 2020-11-10 05:40:07 | Terrebonne, Louisiana, US |
1544741 | 1544741 | 2020-11-07 | US | Georgia | Glynn | 13127 | 3929 | 113 | 0 | 3816 | 31.23279254 | -81.53811412 | 2020-11-08 05:24:56 | Glynn, Georgia, US |
3655196 | 3655196 | 2020-10-24 | Ukraine | Rivne Oblast | 17257 | 211 | 13230 | 3816 | 50.6199 | 26.2516 | 2020-10-25 04:24:36 | Rivne Oblast, Ukraine | ||
2602595 | 2602595 | 2020-10-10 | US | California | San Luis Obispo | 6079 | 3849 | 32 | 0 | 3816 | 35.38822029 | -120.4039028 | 2020-10-11 04:23:46 | San Luis Obispo, California, US |
1042995 | 1042995 | 2020-10-07 | US | Iowa | Dubuque | 19061 | 3863 | 47 | 0 | 3816 | 42.46815349 | -90.88181925 | 2020-10-08 04:23:56 | Dubuque, Iowa, US |
2457436 | 2457436 | 2020-09-19 | US | Pennsylvania | Luzerne | 42079 | 4005 | 189 | 0 | 3816 | 41.17823008 | -75.98447579 | 2020-09-20 04:22:00 | Luzerne, Pennsylvania, US |
2991595 | 2991595 | 2020-08-24 | Switzerland | 40060 | 1844 | 34400 | 3816 | 46.8182 | 8.2275 | 2020-08-25 04:28:02 | Switzerland | |||
3180828 | 3180828 | 2020-08-18 | US | South Carolina | York | 45091 | 3848 | 32 | 0 | 3816 | 34.97281497 | -81.18085944 | 2020-08-19 04:27:00 | York, South Carolina, US |
371541 | 371541 | 2020-08-08 | Russia | Saratov Oblast | 10157 | 63 | 6278 | 3816 | 51.652055499999996 | 46.86319520000001 | 2020-08-09 04:34:54 | Saratov Oblast, Russia | ||
1135204 | 1135204 | 2020-06-26 | US | California | Santa Clara | 6085 | 3982 | 156 | 0 | 3816 | 37.23104908 | -121.6970462 | 2020-06-27 04:33:35 | Santa Clara, California, 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]);