johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
66 rows where active = 2830 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 12
- US 50
- Russia 5
- India 2
- Australia 1
- France 1
- Nigeria 1
- Peru 1
- Philippines 1
- Saudi Arabia 1
- South Africa 1
- South Sudan 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
483728 | 483728 | 2021-07-19 | Nigeria | 169678 | 2128 | 164720 | 2830 | 9.082 | 8.6753 | 2021-07-20 04:21:48 | Nigeria | |||
3643501 | 3643501 | 2021-03-30 | India | Himachal Pradesh | 63320 | 1045 | 59445 | 2830 | 31.927213 | 77.233081 | 2021-03-31 04:26:25 | Himachal Pradesh, India | ||
3962791 | 3962791 | 2021-03-10 | Saudi Arabia | 380958 | 6545 | 371583 | 2830 | 23.885942 | 45.079162 | 2021-03-11 05:25:48 | Saudi Arabia | |||
3669894 | 3669894 | 2021-03-06 | US | New York | Wyoming | 36121 | 2879 | 49 | 0 | 2830 | 42.70145109 | -78.22199579 | 2021-03-07 05:21:54 | Wyoming, New York, US |
1618045 | 1618045 | 2021-03-05 | US | Mississippi | Itawamba | 28057 | 2905 | 75 | 0 | 2830 | 34.27993475 | -88.3606733 | 2021-03-06 04:23:41 | Itawamba, Mississippi, US |
2208633 | 2208633 | 2021-03-04 | US | Illinois | Fulton | 17057 | 2875 | 45 | 0 | 2830 | 40.47289135 | -90.20862357 | 2021-03-05 05:26:29 | Fulton, Illinois, US |
1000295 | 1000295 | 2021-03-01 | US | Mississippi | Yazoo | 28163 | 2892 | 62 | 0 | 2830 | 32.77890365 | -90.39656148 | 2021-03-02 05:23:30 | Yazoo, Mississippi, US |
1858926 | 1858926 | 2021-02-25 | US | Idaho | Cassia | 16031 | 2855 | 25 | 0 | 2830 | 42.28347888 | -113.6012409 | 2021-02-26 05:22:40 | Cassia, Idaho, US |
530988 | 530988 | 2021-02-22 | South Sudan | 6931 | 87 | 4014 | 2830 | 6.877000000000002 | 31.307 | 2021-02-23 05:23:41 | South Sudan | |||
1340974 | 1340974 | 2021-02-15 | US | Pennsylvania | Wayne | 42127 | 2893 | 63 | 0 | 2830 | 41.64938475 | -75.29956506 | 2021-02-16 05:24:38 | Wayne, Pennsylvania, US |
2286125 | 2286125 | 2021-02-14 | US | Pennsylvania | Wayne | 42127 | 2893 | 63 | 0 | 2830 | 41.64938475 | -75.29956506 | 2021-02-15 05:24:49 | Wayne, Pennsylvania, US |
2680161 | 2680161 | 2021-02-13 | US | North Carolina | Montgomery | 37123 | 2910 | 80 | 0 | 2830 | 35.33155144 | -79.90416657 | 2021-02-14 05:23:43 | Montgomery, North Carolina, US |
3541697 | 3541697 | 2021-02-12 | US | New York | Montgomery | 36057 | 2926 | 96 | 0 | 2830 | 42.90123494 | -74.44011632 | 2021-02-13 05:22:12 | Montgomery, New York, US |
3979426 | 3979426 | 2021-02-10 | US | Georgia | Pickens | 13227 | 2888 | 58 | 0 | 2830 | 34.46589159 | -84.46406611 | 2021-02-11 05:23:55 | Pickens, Georgia, US |
1529807 | 1529807 | 2021-02-09 | US | Missouri | Laclede | 29105 | 2894 | 64 | 0 | 2830 | 37.65896829 | -92.5888493 | 2021-02-10 05:22:41 | Laclede, Missouri, US |
1528789 | 1528789 | 2021-02-09 | US | Georgia | White | 13311 | 2895 | 65 | 0 | 2830 | 34.64624278 | -83.74905525 | 2021-02-10 05:22:41 | White, Georgia, US |
977061 | 977061 | 2021-02-06 | US | New Hampshire | Belknap | 33001 | 2919 | 89 | 0 | 2830 | 43.51637314 | -71.41684235 | 2021-02-07 05:23:00 | Belknap, New Hampshire, US |
3155545 | 3155545 | 2021-01-27 | US | Missouri | Platte | 29165 | 2865 | 35 | 0 | 2830 | 39.38154439 | -94.77068479 | 2021-01-28 05:22:24 | Platte, Missouri, US |
1761012 | 1761012 | 2021-01-24 | US | Minnesota | Itasca | 27061 | 2873 | 43 | 0 | 2830 | 47.51009045 | -93.63092229 | 2021-01-25 05:22:16 | Itasca, Minnesota, US |
2468645 | 2468645 | 2021-01-22 | US | Mississippi | Sunflower | 28133 | 2903 | 73 | 0 | 2830 | 33.60192578 | -90.58882684 | 2021-01-23 05:22:03 | Sunflower, Mississippi, US |
437044 | 437044 | 2021-01-21 | US | Minnesota | Becker | 27005 | 2869 | 39 | 0 | 2830 | 46.93479392 | -95.67158144 | 2021-01-22 05:22:10 | Becker, Minnesota, US |
909857 | 909857 | 2021-01-19 | US | Michigan | Tuscola | 26157 | 2946 | 116 | 0 | 2830 | 43.46606813 | -83.41897025 | 2021-01-20 05:21:54 | Tuscola, Michigan, US |
238920 | 238920 | 2021-01-18 | US | Michigan | Tuscola | 26157 | 2946 | 116 | 0 | 2830 | 43.46606813 | -83.41897025 | 2021-01-19 05:22:15 | Tuscola, Michigan, US |
156212 | 156212 | 2021-01-08 | US | New York | Herkimer | 36043 | 2862 | 32 | 0 | 2830 | 43.42034246 | -74.96145307 | 2021-01-09 05:22:18 | Herkimer, New York, US |
154984 | 154984 | 2021-01-08 | US | Illinois | Lee | 17103 | 2864 | 34 | 0 | 2830 | 41.74583951 | -89.29977132 | 2021-01-09 05:22:18 | Lee, Illinois, US |
2230165 | 2230165 | 2021-01-02 | US | Pennsylvania | Carbon | 42025 | 2920 | 90 | 0 | 2830 | 40.91545395 | -75.7068525 | 2021-01-03 05:22:52 | Carbon, Pennsylvania, US |
1138571 | 1138571 | 2021-01-01 | US | Minnesota | Beltrami | 27007 | 2871 | 41 | 0 | 2830 | 47.97373527 | -94.93732139 | 2021-01-02 05:22:33 | Beltrami, Minnesota, US |
3697177 | 3697177 | 2020-12-31 | US | Minnesota | Beltrami | 27007 | 2871 | 41 | 0 | 2830 | 47.97373527 | -94.93732139 | 2021-01-01 05:23:07 | Beltrami, Minnesota, US |
1010661 | 1010661 | 2020-12-30 | US | Alabama | Covington | 1039 | 2868 | 38 | 0 | 2830 | 31.2477854 | -86.45050893 | 2020-12-31 05:22:49 | Covington, Alabama, US |
1010198 | 1010198 | 2020-12-30 | France | French Guiana | 12896 | 71 | 9995 | 2830 | 4.0 | -53.0 | 2020-12-31 05:22:49 | French Guiana, France | ||
768957 | 768957 | 2020-12-29 | US | Pennsylvania | Bedford | 42009 | 2921 | 91 | 0 | 2830 | 40.00522157 | -78.48998442 | 2020-12-30 05:22:34 | Bedford, Pennsylvania, US |
2227114 | 2227114 | 2020-12-26 | US | Wyoming | Sweetwater | 56037 | 2845 | 15 | 0 | 2830 | 41.65943896 | -108.8827882 | 2020-12-27 05:22:55 | Sweetwater, Wyoming, US |
2409670 | 2409670 | 2020-12-23 | US | South Dakota | Brookings | 46011 | 2858 | 28 | 0 | 2830 | 44.36974375 | -96.79079945 | 2020-12-24 05:23:04 | Brookings, South Dakota, US |
2122975 | 2122975 | 2020-12-20 | US | Utah | Summit | 49043 | 2835 | 5 | 0 | 2830 | 40.86688146 | -110.9535882 | 2020-12-21 05:27:58 | Summit, Utah, US |
864132 | 864132 | 2020-12-11 | US | Washington | Whatcom | 53073 | 2876 | 46 | 0 | 2830 | 48.82227976 | -121.7490018 | 2020-12-12 05:26:19 | Whatcom, Washington, US |
861550 | 861550 | 2020-12-11 | US | Georgia | Tift | 13277 | 2909 | 79 | 0 | 2830 | 31.45743864 | -83.5236119 | 2020-12-12 05:26:19 | Tift, Georgia, US |
2978476 | 2978476 | 2020-12-09 | US | Texas | Wise | 48497 | 2874 | 51 | 0 | 2830 | 33.21570665 | -97.65460265 | 2020-12-10 05:26:19 | Wise, Texas, US |
3860917 | 3860917 | 2020-12-04 | US | Indiana | Henry | 18065 | 2875 | 45 | 0 | 2830 | 39.93029017 | -85.39625719 | 2020-12-05 05:27:36 | Henry, Indiana, US |
3860064 | 3860064 | 2020-12-04 | Russia | Penza Oblast | 20895 | 251 | 17814 | 2830 | 53.1655415 | 44.78791810000001 | 2020-12-05 05:27:36 | Penza Oblast, Russia | ||
756774 | 756774 | 2020-10-28 | US | Ohio | Lorain | 39093 | 2927 | 97 | 0 | 2830 | 41.29553751 | -82.15083537 | 2020-10-29 04:24:49 | Lorain, Ohio, US |
1178264 | 1178264 | 2020-10-22 | US | Georgia | Coweta | 13077 | 2893 | 63 | 0 | 2830 | 33.35334302 | -84.76129976 | 2020-10-23 04:24:46 | Coweta, Georgia, US |
3786975 | 3786975 | 2020-10-11 | US | Indiana | Hendricks | 18063 | 2961 | 131 | 0 | 2830 | 39.76719009 | -86.51037283 | 2020-10-12 04:23:45 | Hendricks, Indiana, US |
3786931 | 3786931 | 2020-10-11 | US | Illinois | Unassigned | 90017 | 3076 | 246 | 0 | 2830 | 42.36542373 | 0.0 | 2020-10-12 04:23:45 | Unassigned, Illinois, US |
2605662 | 2605662 | 2020-10-10 | Ukraine | Vinnytsia Oblast | 7466 | 127 | 4509 | 2830 | 49.2331 | 28.4682 | 2020-10-11 04:23:46 | Vinnytsia Oblast, Ukraine | ||
3803023 | 3803023 | 2020-10-05 | US | Indiana | Tippecanoe | 18157 | 2843 | 13 | 0 | 2830 | 40.38872739 | -86.89413959 | 2020-10-06 04:23:33 | Tippecanoe, Indiana, US |
2515500 | 2515500 | 2020-10-03 | US | Kansas | Shawnee | 20177 | 2864 | 34 | 0 | 2830 | 39.04100763 | -95.7557264 | 2020-10-04 04:23:44 | Shawnee, Kansas, US |
3390718 | 3390718 | 2020-10-02 | US | Kansas | Shawnee | 20177 | 2864 | 34 | 0 | 2830 | 39.04100763 | -95.7557264 | 2020-10-03 04:23:40 | Shawnee, Kansas, US |
1048157 | 1048157 | 2020-09-30 | US | North Carolina | Randolph | 37151 | 2884 | 54 | 0 | 2830 | 35.71015088 | -79.80570339 | 2020-10-01 04:23:42 | Randolph, North Carolina, US |
2582176 | 2582176 | 2020-09-27 | Russia | Irkutsk Oblast | 18821 | 284 | 15707 | 2830 | 56.6370122 | 104.719221 | 2020-09-28 04:23:00 | Irkutsk Oblast, Russia | ||
2851344 | 2851344 | 2020-09-18 | US | Ohio | Warren | 39165 | 2876 | 46 | 0 | 2830 | 39.42581994 | -84.16557457 | 2020-09-19 04:22:00 | Warren, Ohio, US |
814352 | 814352 | 2020-09-05 | US | Georgia | Dougherty | 13095 | 3010 | 180 | 0 | 2830 | 31.53328528 | -84.21722377 | 2020-09-06 04:28:33 | Dougherty, Georgia, US |
2664599 | 2664599 | 2020-09-04 | US | South Carolina | Sumter | 45085 | 2899 | 69 | 0 | 2830 | 33.91826534 | -80.37942316 | 2020-09-05 04:28:19 | Sumter, South Carolina, US |
3790295 | 3790295 | 2020-08-05 | US | North Carolina | Cumberland | 37051 | 2880 | 50 | 0 | 2830 | 35.04762133 | -78.82623165 | 2020-08-06 04:35:02 | Cumberland, North Carolina, US |
753709 | 753709 | 2020-08-01 | Russia | Sverdlovsk Oblast | 20784 | 276 | 17678 | 2830 | 58.6414755 | 61.802154599999994 | 2020-08-02 04:34:47 | Sverdlovsk Oblast, Russia | ||
3261797 | 3261797 | 2020-07-31 | US | Arizona | Coconino | 4005 | 2947 | 117 | 0 | 2830 | 35.83883429 | -111.7707178 | 2020-08-01 04:36:27 | Coconino, Arizona, US |
1925945 | 1925945 | 2020-07-30 | US | North Carolina | Gaston | 37071 | 2863 | 33 | 0 | 2830 | 35.29373559 | -81.17477045 | 2020-07-31 04:35:18 | Gaston, North Carolina, US |
1707735 | 1707735 | 2020-07-21 | Russia | Ulyanovsk Oblast | 8037 | 60 | 5147 | 2830 | 54.1463177 | 47.2324921 | 2020-07-22 04:34:42 | Ulyanovsk Oblast, Russia | ||
326860 | 326860 | 2020-07-20 | Russia | Chuvashia Republic | 6264 | 49 | 3385 | 2830 | 55.4259922 | 47.0849429 | 2020-07-21 04:38:46 | Chuvashia Republic, Russia | ||
3203086 | 3203086 | 2020-07-18 | US | Virginia | Henrico | 51087 | 3005 | 175 | 0 | 2830 | 37.53460572 | -77.39326555 | 2020-07-19 04:34:58 | Henrico, Virginia, US |
2708718 | 2708718 | 2020-07-17 | India | Punjab | 9442 | 239 | 6373 | 2830 | 30.841465000000003 | 75.40879 | 2020-07-18 04:34:45 | Punjab, India | ||
1521509 | 1521509 | 2020-06-23 | US | California | San Mateo | 6081 | 2911 | 81 | 0 | 2830 | 37.4228808 | -122.32755459999998 | 2020-06-24 04:33:28 | San Mateo, California, US |
1208713 | 1208713 | 2020-06-09 | US | Florida | Hillsborough | 12057 | 2923 | 93 | 0 | 2830 | 27.9276559 | -82.32013172 | 2020-06-10 04:07:00 | Hillsborough, Florida, US |
1793921 | 1793921 | 2020-05-31 | Peru | Ica | 3334 | 504 | 0 | 2830 | -14.235097 | -75.574821 | 2020-06-01 02:32:46 | Ica, Peru | ||
271790 | 271790 | 2020-04-28 | South Africa | 4996 | 93 | 2073 | 2830 | -30.5595 | 22.9375 | 2020-04-29 02:32:29 | South Africa | |||
2566985 | 2566985 | 2020-04-11 | Australia | New South Wales | 2857 | 23 | 4 | 2830 | -33.8688 | 151.2093 | 2020-04-11 22:52:46 | New South Wales, Australia | ||
3740682 | 3740682 | 2020-04-03 | Philippines | 3018 | 136 | 52 | 2830 | 12.879721 | 121.77401699999999 | 2020-04-03 22:46:20 | Philippines |
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]);