johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
84 rows where active = 2543 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1378653 | 1378653 | 2021-07-25 | Pakistan | Khyber Pakhtunkhwa | 141925 | 4420 | 134962 | 2543 | 34.485332 | 72.09169 | 2021-07-26 04:21:28 | Khyber Pakhtunkhwa, Pakistan | ||
1495860 | 1495860 | 2021-07-03 | Russia | Udmurt Republic | 35956 | 1068 | 32345 | 2543 | 57.1961165 | 52.69598320000001 | 2021-07-04 04:21:38 | Udmurt Republic, Russia | ||
2884379 | 2884379 | 2021-06-20 | Japan | Hokkaido | 40995 | 1342 | 37110 | 2543 | 43.385711 | 142.552318 | 2021-06-21 04:21:41 | Hokkaido, Japan | ||
1452266 | 1452266 | 2021-06-03 | Malaysia | Perak | 21627 | 94 | 18990 | 2543 | 4.5921 | 101.0901 | 2021-06-04 04:23:37 | Perak, Malaysia | ||
1913324 | 1913324 | 2021-05-20 | Morocco | 516091 | 9109 | 504439 | 2543 | 31.7917 | -7.0926 | 2021-05-21 04:20:43 | Morocco | |||
1082174 | 1082174 | 2021-05-14 | Russia | Tatarstan Republic | 20944 | 478 | 17923 | 2543 | 55.7648572 | 52.43104273 | 2021-05-15 04:20:58 | Tatarstan Republic, Russia | ||
3003554 | 3003554 | 2021-04-06 | Russia | Tatarstan Republic | 19633 | 426 | 16664 | 2543 | 55.7648572 | 52.43104273 | 2021-04-07 04:20:53 | Tatarstan Republic, Russia | ||
3453160 | 3453160 | 2021-03-18 | Sri Lanka | 89024 | 537 | 85944 | 2543 | 7.873054 | 80.77179699999998 | 2021-03-19 05:26:09 | Sri Lanka | |||
3670606 | 3670606 | 2021-03-06 | US | Tennessee | Smith | 47159 | 2577 | 36 | 0 | 2543 | 36.25359775 | -85.95411046 | 2021-03-07 05:21:54 | Smith, Tennessee, US |
532851 | 532851 | 2021-02-22 | US | New Hampshire | Cheshire | 33005 | 2568 | 25 | 0 | 2543 | 42.92015988 | -72.25311043 | 2021-02-23 05:23:41 | Cheshire, New Hampshire, US |
531224 | 531224 | 2021-02-22 | US | Arkansas | Sevier | 5133 | 2571 | 28 | 0 | 2543 | 33.99780401 | -94.2424869 | 2021-02-23 05:23:41 | Sevier, Arkansas, US |
3601229 | 3601229 | 2021-02-17 | Russia | Belgorod Oblast | 30202 | 458 | 27201 | 2543 | 50.7080119 | 37.5837615 | 2021-02-18 05:22:58 | Belgorod Oblast, Russia | ||
1341878 | 1341878 | 2021-02-15 | US | Wyoming | Park | 56029 | 2568 | 25 | 0 | 2543 | 44.52157546 | -109.5852825 | 2021-02-16 05:24:38 | Park, Wyoming, US |
1340112 | 1340112 | 2021-02-15 | US | Mississippi | Simpson | 28127 | 2621 | 78 | 0 | 2543 | 31.91282117 | -89.91716179 | 2021-02-16 05:24:38 | Simpson, Mississippi, US |
2287029 | 2287029 | 2021-02-14 | US | Wyoming | Park | 56029 | 2568 | 25 | 0 | 2543 | 44.52157546 | -109.5852825 | 2021-02-15 05:24:49 | Park, Wyoming, US |
2679187 | 2679187 | 2021-02-13 | US | Kentucky | Bell | 21013 | 2576 | 33 | 0 | 2543 | 36.73355174 | -83.67766671 | 2021-02-14 05:23:43 | Bell, Kentucky, US |
3979733 | 3979733 | 2021-02-10 | US | Iowa | Bremer | 19017 | 2596 | 53 | 0 | 2543 | 42.77461496 | -92.31795937 | 2021-02-11 05:23:55 | Bremer, Iowa, US |
617218 | 617218 | 2021-02-08 | US | Wisconsin | Door | 55029 | 2566 | 23 | 0 | 2543 | 44.95856458 | -87.30002707 | 2021-02-09 05:23:30 | Door, Wisconsin, US |
615952 | 615952 | 2021-02-08 | US | New York | Tioga | 36107 | 2599 | 56 | 0 | 2543 | 42.16852837 | -76.30835812 | 2021-02-09 05:23:30 | Tioga, New York, US |
1675987 | 1675987 | 2021-02-07 | US | Wisconsin | Door | 55029 | 2566 | 23 | 0 | 2543 | 44.95856458 | -87.30002707 | 2021-02-08 05:22:39 | Door, Wisconsin, US |
1674636 | 1674636 | 2021-02-07 | US | New Mexico | Cibola | 35006 | 2643 | 100 | 0 | 2543 | 34.91131525 | -107.998876 | 2021-02-08 05:22:39 | Cibola, New Mexico, US |
1679890 | 1679890 | 2021-02-01 | US | Virginia | York | 51199 | 2559 | 16 | 0 | 2543 | 37.24374789 | -76.54412815 | 2021-02-02 05:22:49 | York, Virginia, US |
1677990 | 1677990 | 2021-02-01 | US | Louisiana | Sabine | 22085 | 2591 | 48 | 0 | 2543 | 31.56388699 | -93.55433981 | 2021-02-02 05:22:49 | Sabine, Louisiana, US |
1676855 | 1676855 | 2021-02-01 | US | Alabama | Marion | 1093 | 2617 | 74 | 0 | 2543 | 34.13697363 | -87.88704173 | 2021-02-02 05:22:49 | Marion, Alabama, US |
3155461 | 3155461 | 2021-01-27 | US | Mississippi | Yazoo | 28163 | 2599 | 56 | 0 | 2543 | 32.77890365 | -90.39656148 | 2021-01-28 05:22:24 | Yazoo, Mississippi, US |
3153806 | 3153806 | 2021-01-27 | Russia | Kaliningrad Oblast | 23305 | 215 | 20547 | 2543 | 54.7293041 | 21.1489473 | 2021-01-28 05:22:24 | Kaliningrad Oblast, Russia | ||
14002 | 14002 | 2021-01-26 | US | Michigan | Newaygo | 26123 | 2585 | 42 | 0 | 2543 | 43.554374 | -85.80070107 | 2021-01-27 05:23:41 | Newaygo, Michigan, US |
1760924 | 1760924 | 2021-01-24 | US | Michigan | Gratiot | 26057 | 2638 | 95 | 0 | 2543 | 43.29265605 | -84.60505416 | 2021-01-25 05:22:16 | Gratiot, Michigan, US |
2428531 | 2428531 | 2021-01-23 | US | Michigan | Gratiot | 26057 | 2638 | 95 | 0 | 2543 | 43.29265605 | -84.60505416 | 2021-01-24 05:22:35 | Gratiot, Michigan, US |
2468433 | 2468433 | 2021-01-22 | US | Michigan | Gratiot | 26057 | 2635 | 92 | 0 | 2543 | 43.29265605 | -84.60505416 | 2021-01-23 05:22:03 | Gratiot, Michigan, US |
909165 | 909165 | 2021-01-19 | US | Illinois | Iroquois | 17075 | 2597 | 54 | 0 | 2543 | 40.74717633 | -87.82466784 | 2021-01-20 05:21:54 | Iroquois, Illinois, US |
238308 | 238308 | 2021-01-18 | US | Indiana | Daviess | 18027 | 2621 | 78 | 0 | 2543 | 38.70186039 | -87.07185406 | 2021-01-19 05:22:15 | Daviess, Indiana, US |
3506590 | 3506590 | 2021-01-17 | US | Texas | Uvalde | 48463 | 2696 | 47 | 0 | 2543 | 29.35739637 | -99.76229172 | 2021-01-18 05:22:34 | Uvalde, Texas, US |
3505187 | 3505187 | 2021-01-17 | US | Mississippi | Pike | 28113 | 2620 | 77 | 0 | 2543 | 31.17507789 | -90.40392572 | 2021-01-18 05:22:34 | Pike, Mississippi, US |
3880309 | 3880309 | 2021-01-14 | US | Florida | Wakulla | 12129 | 2574 | 31 | 0 | 2543 | 30.16548905 | -84.39895211 | 2021-01-15 05:22:24 | Wakulla, Florida, US |
2628866 | 2628866 | 2021-01-10 | US | Tennessee | Wayne | 47181 | 2607 | 18 | 0 | 2543 | 35.23868267 | -87.78644456 | 2021-01-11 05:21:50 | Wayne, Tennessee, US |
2865836 | 2865836 | 2021-01-06 | US | Indiana | Putnam | 18133 | 2584 | 41 | 0 | 2543 | 39.66437981 | -86.84517605 | 2021-01-07 05:22:03 | Putnam, Indiana, US |
1139839 | 1139839 | 2021-01-01 | US | Tennessee | Macon | 47111 | 2751 | 45 | 0 | 2543 | 36.53157855 | -86.00778595 | 2021-01-02 05:22:33 | Macon, Tennessee, US |
3698445 | 3698445 | 2020-12-31 | US | Tennessee | Macon | 47111 | 2733 | 45 | 0 | 2543 | 36.53157855 | -86.00778595 | 2021-01-01 05:23:07 | Macon, Tennessee, US |
1013037 | 1013037 | 2020-12-30 | US | Puerto Rico | Guaynabo | 72061 | 2543 | 0 | 0 | 2543 | 18.345114 | -66.11452299999999 | 2020-12-31 05:22:49 | Guaynabo, Puerto Rico, US |
768937 | 768937 | 2020-12-29 | US | Oregon | Linn | 41043 | 2575 | 32 | 0 | 2543 | 44.48899494 | -122.5373154 | 2020-12-30 05:22:34 | Linn, Oregon, US |
3769877 | 3769877 | 2020-12-22 | Japan | Aichi | 14429 | 174 | 11712 | 2543 | 35.035551 | 137.211621 | 2020-12-23 05:22:03 | Aichi, Japan | ||
1904848 | 1904848 | 2020-12-18 | Malaysia | Sabah | 34084 | 250 | 31291 | 2543 | 5.9788 | 116.0753 | 2020-12-19 05:27:52 | Sabah, Malaysia | ||
863002 | 863002 | 2020-12-11 | US | North Carolina | Lenoir | 37107 | 2601 | 58 | 0 | 2543 | 35.24032589999999 | -77.64245615 | 2020-12-12 05:26:19 | Lenoir, North Carolina, US |
1008071 | 1008071 | 2020-12-06 | US | Mississippi | Bolivar | 28011 | 2629 | 86 | 0 | 2543 | 33.79696941 | -90.87372121 | 2020-12-07 05:26:14 | Bolivar, Mississippi, US |
3862648 | 3862648 | 2020-12-04 | US | South Carolina | Laurens | 45059 | 2611 | 68 | 0 | 2543 | 34.48244419 | -82.00490796 | 2020-12-05 05:27:36 | Laurens, South Carolina, US |
77693 | 77693 | 2020-12-03 | US | Oregon | Deschutes | 41017 | 2558 | 15 | 0 | 2543 | 43.91570171 | -121.2289121 | 2020-12-04 05:27:27 | Deschutes, Oregon, US |
2538280 | 2538280 | 2020-12-01 | US | Georgia | Ware | 13299 | 2624 | 81 | 0 | 2543 | 31.05449097 | -82.42224148 | 2020-12-02 05:27:41 | Ware, Georgia, US |
1975760 | 1975760 | 2020-11-25 | US | Texas | Navarro | 48349 | 2681 | 36 | 0 | 2543 | 32.04620681 | -96.47428766 | 2020-11-26 05:27:44 | Navarro, Texas, US |
3839399 | 3839399 | 2020-11-21 | US | Tennessee | Coffee | 47031 | 2578 | 39 | 0 | 2543 | 35.49090731 | -86.07311784 | 2020-11-22 05:25:45 | Coffee, Tennessee, US |
125713 | 125713 | 2020-11-18 | US | Texas | Bastrop | 48021 | 2251 | 34 | 0 | 2543 | 30.10370699 | -97.31206354 | 2020-11-19 05:25:23 | Bastrop, Texas, US |
3341704 | 3341704 | 2020-11-17 | US | Texas | Howard | 48227 | 1907 | 30 | 0 | 2543 | 32.30621324 | -101.4356444 | 2020-11-18 05:40:31 | Howard, Texas, US |
3173224 | 3173224 | 2020-11-16 | US | Wyoming | Albany | 56001 | 2551 | 8 | 0 | 2543 | 41.65498705 | -105.7235415 | 2020-11-17 05:25:54 | Albany, Wyoming, US |
1729194 | 1729194 | 2020-11-08 | US | Florida | Monroe | 12087 | 2568 | 25 | 0 | 2543 | 25.20904673 | -81.07812416 | 2020-11-09 05:25:45 | Monroe, Florida, US |
1547364 | 1547364 | 2020-11-07 | US | Washington | Chelan | 53007 | 2566 | 23 | 0 | 2543 | 47.87046092 | -120.6173956 | 2020-11-08 05:24:56 | Chelan, Washington, US |
895136 | 895136 | 2020-11-05 | US | Texas | Bowie | 48037 | 2279 | 84 | 0 | 2543 | 33.44626922 | -94.41834132 | 2020-11-06 05:24:55 | Bowie, Texas, US |
2500841 | 2500841 | 2020-11-03 | US | South Carolina | Oconee | 45073 | 2577 | 34 | 0 | 2543 | 34.75225169 | -83.06742317 | 2020-11-04 05:25:09 | Oconee, South Carolina, US |
2081980 | 2081980 | 2020-10-31 | US | Nebraska | Dakota | 31043 | 2592 | 49 | 0 | 2543 | 42.39040144 | -96.56656425 | 2020-11-01 04:36:19 | Dakota, Nebraska, US |
3482823 | 3482823 | 2020-10-26 | US | Ohio | Wood | 39173 | 2620 | 77 | 0 | 2543 | 41.36224827 | -83.62285108 | 2020-10-27 04:24:45 | Wood, Ohio, US |
1057212 | 1057212 | 2020-10-23 | US | Virginia | Roanoke City | 51770 | 2578 | 35 | 0 | 2543 | 37.27791025 | -79.96189766 | 2020-10-24 04:24:46 | Roanoke City, Virginia, US |
2192894 | 2192894 | 2020-10-21 | US | Kansas | Leavenworth | 20103 | 2561 | 18 | 0 | 2543 | 39.20183497 | -95.03620809 | 2020-10-22 04:24:27 | Leavenworth, Kansas, US |
82325 | 82325 | 2020-10-14 | US | Texas | Wichita | 48485 | 1760 | 26 | 0 | 2543 | 33.98842886 | -98.7041034 | 2020-10-15 04:24:28 | Wichita, Texas, US |
2617607 | 2617607 | 2020-09-26 | US | Wisconsin | Walworth | 55127 | 2578 | 35 | 0 | 2543 | 42.66858202 | -88.54163073 | 2020-09-27 04:23:00 | Walworth, Wisconsin, US |
2838623 | 2838623 | 2020-09-21 | US | Mississippi | Lee | 28081 | 2610 | 67 | 0 | 2543 | 34.2918775 | -88.68149954 | 2020-09-22 04:23:00 | Lee, Mississippi, US |
2849591 | 2849591 | 2020-09-18 | US | Georgia | Carroll | 13045 | 2606 | 63 | 0 | 2543 | 33.58138199 | -85.07976677 | 2020-09-19 04:22:00 | Carroll, Georgia, US |
2869739 | 2869739 | 2020-09-13 | US | Illinois | Rock Island | 17161 | 2610 | 67 | 0 | 2543 | 41.46613806 | -90.57042164 | 2020-09-14 04:26:00 | Rock Island, Illinois, US |
2869038 | 2869038 | 2020-09-13 | Syria | 3540 | 155 | 842 | 2543 | 34.802075 | 38.996815 | 2020-09-14 04:26:00 | Syria | |||
1354972 | 1354972 | 2020-09-03 | US | Delaware | Kent | 10001 | 2655 | 112 | 0 | 2543 | 39.08646628 | -75.56884914 | 2020-09-04 04:28:26 | Kent, Delaware, US |
839286 | 839286 | 2020-08-17 | US | Michigan | Washtenaw | 26161 | 2657 | 114 | 0 | 2543 | 42.253105 | -83.83853204 | 2020-08-18 04:27:56 | Washtenaw, Michigan, US |
149113 | 149113 | 2020-08-15 | US | Texas | Maverick | 48323 | 2122 | 53 | 0 | 2543 | 28.7429195 | -100.3157686 | 2020-08-16 04:27:42 | Maverick, Texas, US |
1920313 | 1920313 | 2020-08-10 | Mexico | Guanajuato | 24561 | 1252 | 20766 | 2543 | 21.019000000000002 | -101.2574 | 2020-08-11 04:35:08 | Guanajuato, Mexico | ||
98595 | 98595 | 2020-08-04 | Albania | 5750 | 176 | 3031 | 2543 | 41.1533 | 20.1683 | 2020-08-05 04:34:43 | Albania | |||
2739616 | 2739616 | 2020-08-03 | US | Georgia | Unassigned | 90013 | 2549 | 6 | 0 | 2543 | 34.91369188 | 0.0 | 2020-08-04 04:41:59 | Unassigned, Georgia, US |
2562106 | 2562106 | 2020-07-24 | US | Alabama | Marshall | 1095 | 2568 | 25 | 0 | 2543 | 34.36975964 | -86.30486727 | 2020-07-25 04:47:39 | Marshall, Alabama, US |
2708485 | 2708485 | 2020-07-17 | France | French Guiana | 6509 | 34 | 3932 | 2543 | 4.0 | -53.0 | 2020-07-18 04:34:45 | French Guiana, France | ||
2744780 | 2744780 | 2020-07-15 | US | Virginia | Arlington | 51013 | 2677 | 134 | 0 | 2543 | 38.8767675 | -77.10139853 | 2020-07-16 04:44:59 | Arlington, Virginia, US |
3237383 | 3237383 | 2020-07-10 | Russia | Chuvashia Republic | 5718 | 43 | 3132 | 2543 | 55.4259922 | 47.0849429 | 2020-07-11 04:34:26 | Chuvashia Republic, Russia | ||
3235179 | 3235179 | 2020-07-10 | US | New Jersey | Gloucester | 34015 | 2736 | 193 | 0 | 2543 | 39.71581067 | -75.13995546 | 2020-07-11 04:34:26 | Gloucester, New Jersey, US |
887185 | 887185 | 2020-07-07 | Ukraine | Chernivtsi Oblast | 5032 | 190 | 2299 | 2543 | 48.2917 | 25.9352 | 2020-07-08 05:33:48 | Chernivtsi Oblast, Ukraine | ||
2973696 | 2973696 | 2020-06-30 | US | California | Stanislaus | 6099 | 2585 | 58 | 0 | 2543 | 37.55862499 | -120.9970722 | 2020-07-01 04:33:52 | Stanislaus, California, US |
1210891 | 1210891 | 2020-06-09 | Russia | Ryazan Oblast | 4164 | 10 | 1611 | 2543 | 54.42267320000001 | 40.57052460000001 | 2020-06-10 04:07:00 | Ryazan Oblast, Russia | ||
3330998 | 3330998 | 2020-05-11 | Algeria | 5891 | 507 | 2841 | 2543 | 28.0339 | 1.6596 | 2020-05-12 03:32:27 | Algeria | |||
3459613 | 3459613 | 2020-05-10 | Algeria | 5723 | 502 | 2678 | 2543 | 28.0339 | 1.6596 | 2020-05-11 02:32:30 | Algeria | |||
2524107 | 2524107 | 2020-04-23 | US | California | San Diego | 6073 | 2643 | 100 | 0 | 2543 | 33.03484597 | -116.7365326 | 2020-04-24 03:30:50 | San Diego, 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]);