johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
53 rows where confirmed = 11401 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 40
- Central African Republic 6
- India 4
- Russia 2
- Chile 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756193 | 2756193 | 2022-12-29 | US | Vermont | Franklin | 50011 | 11401 | 75 | 0 | 44.85627605 | -72.91249563 | 2022-12-30 04:21:04 | Franklin, Vermont, US | |
2755873 | 2755873 | 2022-12-29 | US | Tennessee | Lincoln | 47103 | 11401 | 181 | 0 | 35.13738622 | -86.58910106 | 2022-12-30 04:21:04 | Lincoln, Tennessee, US | |
1077199 | 1077199 | 2022-12-28 | US | Vermont | Franklin | 50011 | 11401 | 75 | 0 | 44.85627605 | -72.91249563 | 2022-12-29 04:21:01 | Franklin, Vermont, US | |
1076879 | 1076879 | 2022-12-28 | US | Tennessee | Lincoln | 47103 | 11401 | 181 | 0 | 35.13738622 | -86.58910106 | 2022-12-29 04:21:01 | Lincoln, Tennessee, US | |
330876 | 330876 | 2022-12-27 | US | Tennessee | Lincoln | 47103 | 11401 | 182 | 0 | 35.13738622 | -86.58910106 | 2022-12-28 04:21:04 | Lincoln, Tennessee, US | |
220949 | 220949 | 2022-12-26 | US | Tennessee | Lincoln | 47103 | 11401 | 182 | 0 | 35.13738622 | -86.58910106 | 2022-12-27 04:21:07 | Lincoln, Tennessee, US | |
3225406 | 3225406 | 2022-12-25 | US | Tennessee | Lincoln | 47103 | 11401 | 182 | 0 | 35.13738622 | -86.58910106 | 2022-12-26 04:21:06 | Lincoln, Tennessee, US | |
1021320 | 1021320 | 2022-12-24 | US | Tennessee | Lincoln | 47103 | 11401 | 182 | 0 | 35.13738622 | -86.58910106 | 2022-12-25 04:21:04 | Lincoln, Tennessee, US | |
489853 | 489853 | 2022-11-25 | US | New York | Chenango | 36017 | 11401 | 133 | 0 | 42.49430041 | -75.60887553 | 2022-11-26 04:21:11 | Chenango, New York, US | |
1770754 | 1770754 | 2022-07-03 | US | Virginia | Shenandoah | 51171 | 11401 | 231 | 0 | 38.85905135 | -78.56813762 | 2022-07-04 04:20:54 | Shenandoah, Virginia, US | |
3368740 | 3368740 | 2022-07-02 | US | Virginia | Shenandoah | 51171 | 11401 | 231 | 0 | 38.85905135 | -78.56813762 | 2022-07-03 04:20:59 | Shenandoah, Virginia, US | |
597069 | 597069 | 2022-07-01 | US | Virginia | Shenandoah | 51171 | 11401 | 231 | 0 | 38.85905135 | -78.56813762 | 2022-07-02 04:21:16 | Shenandoah, Virginia, US | |
3447979 | 3447979 | 2022-05-11 | US | Texas | Jim Wells | 48249 | 11401 | 208 | 0 | 27.73103938 | -98.0904705 | 2022-05-12 04:20:54 | Jim Wells, Texas, US | |
2254994 | 2254994 | 2022-04-19 | US | Wisconsin | Oconto | 55083 | 11401 | 119 | 0 | 45.02715345 | -88.26807503 | 2022-04-20 04:20:45 | Oconto, Wisconsin, US | |
3353591 | 3353591 | 2022-04-01 | US | Tennessee | Fayette | 47047 | 11401 | 181 | 0 | 35.19615831 | -89.41399032 | 2022-04-02 04:20:47 | Fayette, Tennessee, US | |
1865417 | 1865417 | 2022-03-10 | India | Lakshadweep | 11401 | 52 | 0 | 13.699997199999999 | 72.18333259999999 | 2022-03-11 04:20:50 | Lakshadweep, India | |||
2140112 | 2140112 | 2022-03-09 | India | Lakshadweep | 11401 | 52 | 0 | 13.699997199999999 | 72.18333259999999 | 2022-03-10 04:20:48 | Lakshadweep, India | |||
921357 | 921357 | 2022-03-08 | US | Michigan | Newaygo | 26123 | 11401 | 153 | 0 | 43.554373999999996 | -85.80070107 | 2022-03-09 04:20:59 | Newaygo, Michigan, US | |
919623 | 919623 | 2022-03-08 | India | Lakshadweep | 11401 | 52 | 0 | 13.699997199999999 | 72.18333259999999 | 2022-03-09 04:20:59 | Lakshadweep, India | |||
1549644 | 1549644 | 2022-03-07 | US | Michigan | Newaygo | 26123 | 11401 | 153 | 0 | 43.554373999999996 | -85.80070107 | 2022-03-08 04:20:54 | Newaygo, Michigan, US | |
1547910 | 1547910 | 2022-03-07 | India | Lakshadweep | 11401 | 52 | 0 | 13.699997199999999 | 72.18333259999999 | 2022-03-08 04:20:54 | Lakshadweep, India | |||
1645413 | 1645413 | 2022-03-03 | US | Illinois | Stephenson | 17177 | 11401 | 153 | 0 | 42.35129217 | -89.662598 | 2022-03-04 04:21:09 | Stephenson, Illinois, US | |
2447872 | 2447872 | 2022-02-22 | US | Indiana | Huntington | 18069 | 11401 | 147 | 0 | 40.82907273 | -85.48822092 | 2022-02-23 04:21:09 | Huntington, Indiana, US | |
128962 | 128962 | 2022-01-09 | US | New York | Clinton | 36019 | 11401 | 59 | 0 | 44.74530905 | -73.67875352 | 2022-01-10 04:22:07 | Clinton, New York, US | |
2963593 | 2963593 | 2021-12-24 | Russia | Jewish Autonomous Okrug | 11401 | 403 | 0 | 48.57527615 | 132.66307460000002 | 2021-12-25 04:21:37 | Jewish Autonomous Okrug, Russia | |||
406121 | 406121 | 2021-12-07 | US | Mississippi | Lowndes | 28087 | 11401 | 193 | 0 | 33.47386518 | -88.44191529999998 | 2021-12-08 04:22:46 | Lowndes, Mississippi, US | |
1742001 | 1742001 | 2021-12-05 | US | Kentucky | Pike | 21195 | 11401 | 209 | 0 | 37.47088263 | -82.39487445 | 2021-12-06 04:22:34 | Pike, Kentucky, US | |
449565 | 449565 | 2021-11-17 | US | New Mexico | Eddy | 35015 | 11401 | 213 | 0 | 32.47167456 | -104.3053527 | 2021-11-18 04:21:33 | Eddy, New Mexico, US | |
3640639 | 3640639 | 2021-11-08 | US | Indiana | Floyd | 18043 | 11401 | 223 | 0 | 38.32117957 | -85.90385377 | 2021-11-09 04:21:36 | Floyd, Indiana, US | |
3124505 | 3124505 | 2021-11-05 | US | Tennessee | Tipton | 47167 | 11401 | 138 | 0 | 35.501942 | -89.73694895 | 2021-11-06 04:21:51 | Tipton, Tennessee, US | |
7855 | 7855 | 2021-10-28 | US | West Virginia | Raleigh | 54081 | 11401 | 173 | 0 | 37.76936795 | -81.2456041 | 2021-10-29 04:22:03 | Raleigh, West Virginia, US | |
1491365 | 1491365 | 2021-10-12 | Central African Republic | 11401 | 100 | 0 | 6.6111 | 20.9394 | 2021-10-13 04:20:51 | Central African Republic | ||||
3007098 | 3007098 | 2021-10-11 | Central African Republic | 11401 | 100 | 0 | 6.6111 | 20.9394 | 2021-10-12 04:21:09 | Central African Republic | ||||
423114 | 423114 | 2021-10-10 | Central African Republic | 11401 | 100 | 0 | 6.6111 | 20.9394 | 2021-10-11 04:21:31 | Central African Republic | ||||
2875971 | 2875971 | 2021-10-09 | Central African Republic | 11401 | 100 | 0 | 6.6111 | 20.9394 | 2021-10-10 04:21:38 | Central African Republic | ||||
2959137 | 2959137 | 2021-10-08 | Central African Republic | 11401 | 100 | 0 | 6.6111 | 20.9394 | 2021-10-09 04:21:34 | Central African Republic | ||||
467175 | 467175 | 2021-10-07 | Central African Republic | 11401 | 100 | 0 | 6.6111 | 20.9394 | 2021-10-08 04:21:25 | Central African Republic | ||||
3757989 | 3757989 | 2021-09-21 | US | Arkansas | Pope | 5115 | 11401 | 148 | 0 | 35.44871474 | -93.03212219 | 2021-09-22 04:21:45 | Pope, Arkansas, US | |
1599040 | 1599040 | 2021-08-26 | US | South Carolina | Orangeburg | 45075 | 11401 | 263 | 0 | 33.4391073 | -80.79886287 | 2021-08-27 04:21:37 | Orangeburg, South Carolina, US | |
3686289 | 3686289 | 2021-08-02 | US | South Carolina | Sumter | 45085 | 11401 | 211 | 0 | 33.91826534 | -80.37942316 | 2021-08-03 04:21:39 | Sumter, South Carolina, US | |
2104809 | 2104809 | 2021-06-01 | US | Florida | Citrus | 12017 | 11401 | 463 | 0 | 28.84804315 | -82.47614748 | 2021-06-02 04:24:34 | Citrus, Florida, US | |
3092383 | 3092383 | 2021-05-30 | US | Tennessee | Madison | 47113 | 11401 | 240 | 0 | 35.61181957 | -88.84076036 | 2021-05-31 03:08:59 | Madison, Tennessee, US | |
54197 | 54197 | 2021-05-29 | US | Virginia | Stafford | 51179 | 11401 | 79 | 0 | 38.41758738 | -77.45917053 | 2021-05-30 04:20:55 | Stafford, Virginia, US | |
616932 | 616932 | 2021-02-08 | US | Texas | Wichita | 48485 | 11401 | 315 | 0 | 13860 | 33.98842886 | -98.7041034 | 2021-02-09 05:23:30 | Wichita, Texas, US |
1675701 | 1675701 | 2021-02-07 | US | Texas | Wichita | 48485 | 11401 | 315 | 0 | 13860 | 33.98842886 | -98.7041034 | 2021-02-08 05:22:39 | Wichita, Texas, US |
978162 | 978162 | 2021-02-06 | US | Texas | Wichita | 48485 | 11401 | 315 | 0 | 13860 | 33.98842886 | -98.7041034 | 2021-02-07 05:23:00 | Wichita, Texas, US |
1460332 | 1460332 | 2021-01-31 | US | California | Shasta | 6089 | 11401 | 112 | 0 | 11327 | 40.76391419 | -122.0396884 | 2021-02-01 05:22:53 | Shasta, California, US |
239542 | 239542 | 2021-01-18 | US | North Carolina | Davidson | 37057 | 11401 | 106 | 0 | 11295 | 35.79115496 | -80.21256572 | 2021-01-19 05:22:15 | Davidson, North Carolina, US |
3505659 | 3505659 | 2021-01-17 | US | North Carolina | Davidson | 37057 | 11401 | 106 | 0 | 11295 | 35.79115496 | -80.21256572 | 2021-01-18 05:22:34 | Davidson, North Carolina, US |
3102436 | 3102436 | 2021-01-16 | US | Illinois | Kankakee | 17091 | 11401 | 171 | 0 | 11230 | 41.13746989 | -87.86205334 | 2021-01-17 05:22:17 | Kankakee, Illinois, US |
776118 | 776118 | 2021-01-12 | US | Minnesota | Wright | 27171 | 11401 | 99 | 0 | 11302 | 45.17297924 | -93.96234781 | 2021-01-13 05:22:15 | Wright, Minnesota, US |
2812982 | 2812982 | 2020-09-25 | Russia | Primorsky Krai | 11401 | 116 | 9886 | 1399 | 45.0819456 | 134.726645 | 2020-09-26 04:23:00 | Primorsky Krai, Russia | ||
2454569 | 2454569 | 2020-09-19 | Chile | Tarapaca | 11401 | 218 | 10898 | 285 | -19.9232 | -69.5132 | 2020-09-20 04:22:00 | Tarapaca, Chile |
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]);