johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
53 rows where active = 3159 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3141203 | 3141203 | 2021-07-23 | United Kingdom | Channel Islands | 0 | 0 | 5182 | 3159 | 49.3723 | -2.3644 | 2021-07-24 00:21:36 | Channel Islands, United Kingdom | ||
3744759 | 3744759 | 2021-07-12 | Malaysia | Pahang | 16465 | 155 | 13151 | 3159 | 3.8126 | 103.3256 | 2021-07-13 04:21:18 | Pahang, Malaysia | ||
1712098 | 1712098 | 2021-06-25 | Canada | Ontario | 547882 | 9101 | 538876 | 3159 | 51.2538 | -85.3232 | 2021-06-26 04:21:43 | Ontario, Canada | ||
1744580 | 1744580 | 2021-03-20 | Japan | Tokyo | 117261 | 1632 | 112470 | 3159 | 35.711343 | 139.446921 | 2021-03-21 05:25:44 | Tokyo, Japan | ||
3670426 | 3670426 | 2021-03-06 | US | South Carolina | Colleton | 45029 | 3274 | 115 | 0 | 3159 | 32.87582989 | -80.67641292 | 2021-03-07 05:21:54 | Colleton, South Carolina, US |
1937761 | 1937761 | 2021-02-23 | US | Kansas | Montgomery | 20125 | 3225 | 66 | 0 | 3159 | 37.19236568 | -95.74329258 | 2021-02-24 05:29:16 | Montgomery, Kansas, US |
532016 | 532016 | 2021-02-22 | US | Kansas | Montgomery | 20125 | 3225 | 66 | 0 | 3159 | 37.19236568 | -95.74329258 | 2021-02-23 05:23:41 | Montgomery, Kansas, US |
744048 | 744048 | 2021-02-20 | US | Minnesota | Morrison | 27097 | 3205 | 46 | 0 | 3159 | 46.01265363 | -94.27341528 | 2021-02-21 05:24:33 | Morrison, Minnesota, US |
3052396 | 3052396 | 2021-02-16 | US | New York | Columbia | 36021 | 3251 | 92 | 0 | 3159 | 42.24819348 | -73.63089095 | 2021-02-17 05:23:10 | Columbia, New York, US |
3051299 | 3051299 | 2021-02-16 | US | Indiana | Ripley | 18137 | 3218 | 59 | 0 | 3159 | 39.10235626 | -85.26212744 | 2021-02-17 05:23:10 | Ripley, Indiana, US |
2641155 | 2641155 | 2021-02-11 | US | Washington | Grays Harbor | 53027 | 3200 | 41 | 0 | 3159 | 47.14003705 | -123.7820567 | 2021-02-12 05:23:29 | Grays Harbor, Washington, US |
2637986 | 2637986 | 2021-02-11 | Rwanda | 17068 | 231 | 13678 | 3159 | -1.9403 | 29.8739 | 2021-02-12 05:23:29 | Rwanda | |||
3978826 | 3978826 | 2021-02-10 | Russia | Tatarstan Republic | 16879 | 293 | 13427 | 3159 | 55.7648572 | 52.43104273 | 2021-02-11 05:23:55 | Tatarstan Republic, Russia | ||
1686000 | 1686000 | 2021-02-02 | US | Louisiana | Iberville | 22047 | 3246 | 87 | 0 | 3159 | 30.25734305 | -91.3499598 | 2021-02-03 05:22:52 | Iberville, Louisiana, US |
1678668 | 1678668 | 2021-02-01 | US | New Mexico | Rio Arriba | 35039 | 3214 | 55 | 0 | 3159 | 36.51072137 | -106.6931674 | 2021-02-02 05:22:49 | Rio Arriba, New Mexico, US |
1462697 | 1462697 | 2021-01-31 | US | Tennessee | Hardeman | 47069 | 3256 | 57 | 0 | 3159 | 35.20772017 | -88.99161161 | 2021-02-01 05:22:53 | Hardeman, Tennessee, US |
3517857 | 3517857 | 2021-01-15 | US | Ohio | Fulton | 39051 | 3211 | 52 | 0 | 3159 | 41.60213491 | -84.12571393 | 2021-01-16 05:22:40 | Fulton, Ohio, US |
192087 | 192087 | 2021-01-11 | US | Montana | Silver Bow | 30093 | 3216 | 57 | 0 | 3159 | 45.90018933 | -112.6620092 | 2021-01-12 05:22:15 | Silver Bow, Montana, US |
3233029 | 3233029 | 2021-01-03 | US | Oklahoma | Pittsburg | 40121 | 3184 | 25 | 0 | 3159 | 34.92065823 | -95.7513432 | 2021-01-04 05:22:02 | Pittsburg, Oklahoma, US |
2229263 | 2229263 | 2021-01-02 | US | Minnesota | Polk | 27119 | 3208 | 49 | 0 | 3159 | 47.77372465 | -96.40134647 | 2021-01-03 05:22:52 | Polk, Minnesota, US |
767359 | 767359 | 2020-12-29 | US | Illinois | Stephenson | 17177 | 3205 | 46 | 0 | 3159 | 42.35129217 | -89.662598 | 2020-12-30 05:22:34 | Stephenson, Illinois, US |
2407704 | 2407704 | 2020-12-23 | US | Georgia | Tift | 13277 | 3239 | 80 | 0 | 3159 | 31.45743864 | -83.5236119 | 2020-12-24 05:23:04 | Tift, Georgia, US |
1751454 | 1751454 | 2020-12-14 | Russia | Bashkortostan Republic | 16317 | 106 | 13052 | 3159 | 54.8573563 | 57.1439682 | 2020-12-15 05:26:38 | Bashkortostan Republic, Russia | ||
862930 | 862930 | 2020-12-11 | US | New York | Saratoga | 36091 | 3183 | 24 | 0 | 3159 | 43.10904162 | -73.86653895 | 2020-12-12 05:26:19 | Saratoga, New York, US |
2976877 | 2976877 | 2020-12-09 | US | Michigan | Marquette | 26103 | 3198 | 39 | 0 | 3159 | 46.4338914 | -87.64043701 | 2020-12-10 05:26:19 | Marquette, Michigan, US |
1819762 | 1819762 | 2020-12-08 | US | Illinois | Effingham | 17049 | 3191 | 32 | 0 | 3159 | 39.05935711 | -88.58969584 | 2020-12-09 05:28:01 | Effingham, Illinois, US |
1819557 | 1819557 | 2020-12-08 | US | Georgia | Coffee | 13069 | 3240 | 81 | 0 | 3159 | 31.54892966 | -82.85492059999999 | 2020-12-09 05:28:01 | Coffee, Georgia, US |
1818749 | 1818749 | 2020-12-08 | India | Odisha | 321913 | 1784 | 316970 | 3159 | 20.505428 | 84.418059 | 2020-12-09 05:28:01 | Odisha, India | ||
1635114 | 1635114 | 2020-12-05 | US | South Carolina | Greenwood | 45047 | 3245 | 86 | 0 | 3159 | 34.15272415 | -82.12715789 | 2020-12-06 05:26:18 | Greenwood, South Carolina, US |
1633670 | 1633670 | 2020-12-05 | US | Kentucky | Bullitt | 21029 | 3181 | 22 | 0 | 3159 | 37.97162523 | -85.68955617 | 2020-12-06 05:26:18 | Bullitt, Kentucky, US |
75568 | 75568 | 2020-12-03 | US | Arkansas | Greene | 5055 | 3188 | 29 | 0 | 3159 | 36.11735460000001 | -90.55832668 | 2020-12-04 05:27:27 | Greene, Arkansas, US |
741533 | 741533 | 2020-12-02 | US | Texas | Val Verde | 48465 | 1970 | 141 | 0 | 3159 | 29.89149232 | -101.1525205 | 2020-12-03 05:28:22 | Val Verde, Texas, US |
924851 | 924851 | 2020-11-26 | US | Iowa | Clinton | 19045 | 3198 | 39 | 0 | 3159 | 41.89981633 | -90.53275096 | 2020-11-27 05:26:53 | Clinton, Iowa, US |
822369 | 822369 | 2020-11-19 | US | Georgia | Gordon | 13129 | 3219 | 60 | 0 | 3159 | 34.50487351 | -84.87296253 | 2020-11-20 05:26:28 | Gordon, Georgia, US |
2915067 | 2915067 | 2020-11-14 | Egypt | 110547 | 6442 | 100946 | 3159 | 26.820553000000004 | 30.802498 | 2020-11-15 05:26:53 | Egypt | |||
2245875 | 2245875 | 2020-10-30 | US | Ohio | Pickaway | 39129 | 3202 | 43 | 0 | 3159 | 39.64170392 | -83.0243386 | 2020-10-31 04:24:44 | Pickaway, Ohio, US |
1180397 | 1180397 | 2020-10-22 | US | Tennessee | Blount | 47009 | 3237 | 32 | 0 | 3159 | 35.68938198 | -83.92847788 | 2020-10-23 04:24:46 | Blount, Tennessee, US |
2194421 | 2194421 | 2020-10-21 | US | South Carolina | Orangeburg | 45075 | 3289 | 130 | 0 | 3159 | 33.4391073 | -80.79886287 | 2020-10-22 04:24:27 | Orangeburg, South Carolina, US |
3785328 | 3785328 | 2020-10-13 | US | Washington | Grant | 53025 | 3183 | 24 | 0 | 3159 | 47.20753737 | -119.4500749 | 2020-10-14 04:24:05 | Grant, Washington, US |
1825101 | 1825101 | 2020-10-04 | US | North Carolina | Iredell | 37097 | 3192 | 33 | 0 | 3159 | 35.80950511 | -80.8743128 | 2020-10-05 04:23:33 | Iredell, North Carolina, US |
3392347 | 3392347 | 2020-10-02 | US | Tennessee | Montgomery | 47125 | 3223 | 46 | 0 | 3159 | 36.49609412 | -87.38550661 | 2020-10-03 04:23:40 | Montgomery, Tennessee, US |
2380321 | 2380321 | 2020-10-01 | US | Florida | Indian River | 12061 | 3279 | 120 | 0 | 3159 | 27.69308961 | -80.60556721 | 2020-10-02 04:23:51 | Indian River, Florida, US |
2606330 | 2606330 | 2020-09-24 | Sweden | Gavleborg | 3326 | 167 | 0 | 3159 | 61.3012 | 16.1534 | 2020-09-25 04:23:00 | Gavleborg, Sweden | ||
2729364 | 2729364 | 2020-09-15 | US | Alabama | Etowah | 1055 | 3202 | 43 | 0 | 3159 | 34.04567266 | -86.04051873 | 2020-09-16 04:22:53 | Etowah, Alabama, US |
546462 | 546462 | 2020-09-12 | Armenia | 45675 | 911 | 41605 | 3159 | 40.0691 | 45.0382 | 2020-09-13 04:30:52 | Armenia | |||
196714 | 196714 | 2020-08-31 | US | Pennsylvania | Dauphin | 42043 | 3322 | 163 | 0 | 3159 | 40.41377078 | -76.77993242 | 2020-09-01 04:28:31 | Dauphin, Pennsylvania, US |
3793238 | 3793238 | 2020-08-05 | Colombia | Santander | 5087 | 163 | 1765 | 3159 | 6.6437 | -73.6536 | 2020-08-06 04:35:02 | Santander, Colombia | ||
753920 | 753920 | 2020-08-01 | Qatar | 110911 | 174 | 107578 | 3159 | 25.3548 | 51.1839 | 2020-08-02 04:34:47 | Qatar | |||
752149 | 752149 | 2020-08-01 | US | Virginia | Norfolk | 51710 | 3185 | 26 | 0 | 3159 | 36.89934014 | -76.26420872 | 2020-08-02 04:34:47 | Norfolk, Virginia, US |
3235291 | 3235291 | 2020-07-10 | US | Tennessee | Hamilton | 47065 | 3085 | 37 | 0 | 3159 | 35.17670231 | -85.16652245 | 2020-07-11 04:34:26 | Hamilton, Tennessee, US |
1005599 | 1005599 | 2020-07-09 | Sweden | Ostergotland | 3383 | 224 | 0 | 3159 | 58.3454 | 15.5198 | 2020-07-10 04:34:24 | Ostergotland, Sweden | ||
997838 | 997838 | 2020-05-23 | Brazil | Piaui | 3390 | 107 | 0 | 3159 | -7.7183 | -42.7289 | 2020-05-24 02:32:43 | Piaui, Brazil | ||
3815959 | 3815959 | 2020-03-31 | Ireland | 3235 | 71 | 5 | 3159 | 53.1424 | -7.6921 | 2020-03-31 23:43:43 | Ireland |
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]);