johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where active = 3726 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1712293 | 1712293 | 2021-06-25 | India | Tripura | 64159 | 665 | 59768 | 3726 | 23.746783 | 91.743565 | 2021-06-26 04:21:43 | Tripura, India | ||
3054149 | 3054149 | 2021-05-13 | India | Meghalaya | 21576 | 268 | 17582 | 3726 | 25.536934 | 91.278882 | 2021-05-14 04:20:41 | Meghalaya, India | ||
2820630 | 2820630 | 2021-05-10 | Colombia | Santander | 110711 | 3884 | 103101 | 3726 | 6.6437 | -73.6536 | 2021-05-11 04:20:41 | Santander, Colombia | ||
282500 | 282500 | 2021-02-24 | US | North Carolina | Haywood | 37087 | 3812 | 86 | 0 | 3726 | 35.55269063 | -82.98196486 | 2021-02-25 05:24:57 | Haywood, North Carolina, US |
742198 | 742198 | 2021-02-20 | El Salvador | 58903 | 1792 | 53385 | 3726 | 13.7942 | -88.8965 | 2021-02-21 05:24:33 | El Salvador | |||
3053411 | 3053411 | 2021-02-16 | US | Texas | Van Zandt | 48467 | 3232 | 103 | 0 | 3726 | 32.56483801 | -95.83766469 | 2021-02-17 05:23:10 | Van Zandt, Texas, US |
1341510 | 1341510 | 2021-02-15 | US | Texas | Van Zandt | 48467 | 3232 | 103 | 0 | 3726 | 32.56483801 | -95.83766469 | 2021-02-16 05:24:38 | Van Zandt, Texas, US |
1340482 | 1340482 | 2021-02-15 | US | New Mexico | Unassigned | 90035 | 3726 | 0 | 0 | 3726 | 36.60569702 | -108.7151824 | 2021-02-16 05:24:38 | Unassigned, New Mexico, US |
2286661 | 2286661 | 2021-02-14 | US | Texas | Van Zandt | 48467 | 3232 | 103 | 0 | 3726 | 32.56483801 | -95.83766469 | 2021-02-15 05:24:49 | Van Zandt, Texas, US |
1530461 | 1530461 | 2021-02-09 | US | Oklahoma | Mayes | 40097 | 3760 | 34 | 0 | 3726 | 36.30179091 | -95.23175116 | 2021-02-10 05:22:41 | Mayes, Oklahoma, US |
978043 | 978043 | 2021-02-06 | US | Texas | Jim Wells | 48249 | 4190 | 79 | 0 | 3726 | 27.73103938 | -98.0904705 | 2021-02-07 05:23:00 | Jim Wells, Texas, US |
976003 | 976003 | 2021-02-06 | US | Indiana | Harrison | 18061 | 3780 | 54 | 0 | 3726 | 38.19467379 | -86.10948271 | 2021-02-07 05:23:00 | Harrison, Indiana, US |
1687526 | 1687526 | 2021-02-02 | US | Texas | Brown | 48049 | 4058 | 91 | 0 | 3726 | 31.77430356 | -98.99907113 | 2021-02-03 05:22:52 | Brown, Texas, US |
3516380 | 3516380 | 2021-01-15 | US | Illinois | Franklin | 17055 | 3783 | 57 | 0 | 3726 | 37.99189086 | -88.92567818 | 2021-01-16 05:22:40 | Franklin, Illinois, US |
2544455 | 2544455 | 2021-01-07 | US | Texas | Coryell | 48099 | 5279 | 34 | 0 | 3726 | 31.39078397 | -97.79936155 | 2021-01-08 05:22:42 | Coryell, Texas, US |
3773428 | 3773428 | 2020-12-22 | US | Wisconsin | Marinette | 55075 | 3765 | 39 | 0 | 3726 | 45.38553432 | -88.03324599999998 | 2020-12-23 05:22:03 | Marinette, Wisconsin, US |
1037277 | 1037277 | 2020-12-15 | US | Tennessee | Bedford | 47003 | 3862 | 46 | 0 | 3726 | 35.51123746 | -86.45549096 | 2020-12-16 05:28:04 | Bedford, Tennessee, US |
1036530 | 1036530 | 2020-12-15 | US | New Jersey | Cape May | 34009 | 3849 | 123 | 0 | 3726 | 39.15008829 | -74.80170244 | 2020-12-16 05:28:04 | Cape May, New Jersey, US |
1007437 | 1007437 | 2020-12-06 | US | Indiana | Wayne | 18177 | 3831 | 105 | 0 | 3726 | 39.8633444 | -85.01044989 | 2020-12-07 05:26:14 | Wayne, Indiana, US |
3568440 | 3568440 | 2020-11-29 | US | Missouri | Cass | 29037 | 3765 | 39 | 0 | 3726 | 38.64789422 | -94.353399 | 2020-11-30 05:26:13 | Cass, Missouri, US |
2935417 | 2935417 | 2020-11-28 | Russia | Astrakhan Oblast | 13406 | 250 | 9430 | 3726 | 47.1878186 | 47.608851 | 2020-11-29 05:25:55 | Astrakhan Oblast, Russia | ||
2880450 | 2880450 | 2020-11-15 | Russia | Stavropol Krai | 24379 | 481 | 20172 | 3726 | 44.86325770000001 | 43.4406913 | 2020-11-16 05:25:57 | Stavropol Krai, Russia | ||
8319 | 8319 | 2020-10-25 | Italy | Marche | 11440 | 1003 | 6711 | 3726 | 43.61675973 | 13.5188753 | 2020-10-26 04:25:02 | Marche, Italy | ||
3651774 | 3651774 | 2020-10-24 | Russia | Khabarovsk Krai | 14860 | 124 | 11010 | 3726 | 51.6312684 | 136.121524 | 2020-10-25 04:24:36 | Khabarovsk Krai, Russia | ||
2194564 | 2194564 | 2020-10-21 | US | Tennessee | Out of TN | 80047 | 2675 | 35 | 0 | 3726 | 36.55606529 | 0.0 | 2020-10-22 04:24:27 | Out of TN, Tennessee, US |
2604396 | 2604396 | 2020-10-10 | US | North Carolina | Wayne | 37191 | 3800 | 74 | 0 | 3726 | 35.36438125 | -78.00027268 | 2020-10-11 04:23:46 | Wayne, North Carolina, US |
3163237 | 3163237 | 2020-09-06 | US | Michigan | Genesee | 26049 | 4031 | 305 | 0 | 3726 | 43.02244215 | -83.70589709 | 2020-09-07 04:28:30 | Genesee, Michigan, US |
815192 | 815192 | 2020-09-05 | US | Michigan | Genesee | 26049 | 4031 | 305 | 0 | 3726 | 43.02244215 | -83.70589709 | 2020-09-06 04:28:33 | Genesee, Michigan, US |
1523151 | 1523151 | 2020-08-28 | India | Tripura | 10857 | 94 | 7037 | 3726 | 23.746783 | 91.743565 | 2020-08-29 04:28:19 | Tripura, India | ||
584507 | 584507 | 2020-08-13 | US | Minnesota | Anoka | 27003 | 3841 | 115 | 0 | 3726 | 45.27476015 | -93.24604565 | 2020-08-14 04:51:19 | Anoka, Minnesota, US |
2736739 | 2736739 | 2020-08-03 | US | Florida | Alachua | 12001 | 3749 | 23 | 0 | 3726 | 29.67866525 | -82.35928158 | 2020-08-04 04:41:59 | Alachua, Florida, US |
1211160 | 1211160 | 2020-06-09 | Sudan | 6242 | 389 | 2127 | 3726 | 12.8628 | 30.2176 | 2020-06-10 04:07:00 | Sudan |
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]);