johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
57 rows where active = 2672 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1330318 | 1330318 | 2021-07-24 | Malta | 33541 | 421 | 30448 | 2672 | 35.9375 | 14.3754 | 2021-07-25 04:22:12 | Malta | |||
2947544 | 2947544 | 2021-07-16 | Russia | Arkhangelsk Oblast | 70664 | 1064 | 66928 | 2672 | 63.5589686 | 43.1221646 | 2021-07-17 04:22:22 | Arkhangelsk Oblast, Russia | ||
2589964 | 2589964 | 2021-06-27 | India | Puducherry | 116645 | 1744 | 112229 | 2672 | 11.882658 | 78.86498 | 2021-06-28 04:21:29 | Puducherry, India | ||
3256670 | 3256670 | 2021-03-02 | US | Oklahoma | Beckham | 40009 | 2709 | 37 | 0 | 2672 | 35.26862449 | -99.68128023 | 2021-03-03 05:23:28 | Beckham, Oklahoma, US |
3255775 | 3255775 | 2021-03-02 | US | Michigan | Gratiot | 26057 | 2775 | 103 | 0 | 2672 | 43.29265605 | -84.60505416 | 2021-03-03 05:23:28 | Gratiot, Michigan, US |
3254607 | 3254607 | 2021-03-02 | US | Arkansas | Carroll | 5015 | 2714 | 42 | 0 | 2672 | 36.34038560000001 | -93.54270261 | 2021-03-03 05:23:28 | Carroll, Arkansas, US |
999219 | 999219 | 2021-03-01 | US | Georgia | Decatur | 13087 | 2737 | 65 | 0 | 2672 | 30.87967778 | -84.57619536 | 2021-03-02 05:23:30 | Decatur, Georgia, US |
2368277 | 2368277 | 2021-02-28 | US | Georgia | Decatur | 13087 | 2737 | 65 | 0 | 2672 | 30.87967778 | -84.57619536 | 2021-03-01 05:23:01 | Decatur, Georgia, US |
2367957 | 2367957 | 2021-02-28 | US | Arkansas | Carroll | 5015 | 2713 | 41 | 0 | 2672 | 36.34038560000001 | -93.54270261 | 2021-03-01 05:23:01 | Carroll, Arkansas, US |
281086 | 281086 | 2021-02-24 | US | Hawaii | Maui | 15009 | 2704 | 32 | 0 | 2672 | 20.86399628 | -156.56890969999995 | 2021-02-25 05:24:57 | Maui, Hawaii, US |
533373 | 533373 | 2021-02-22 | US | Pennsylvania | Jefferson | 42065 | 2758 | 86 | 0 | 2672 | 41.12913106 | -78.9986361 | 2021-02-23 05:23:41 | Jefferson, Pennsylvania, US |
532843 | 532843 | 2021-02-22 | US | Nevada | Nye | 32023 | 2766 | 94 | 0 | 2672 | 38.04264256 | -116.4722702 | 2021-02-23 05:23:41 | Nye, Nevada, US |
2638099 | 2638099 | 2021-02-11 | US | Alabama | Lawrence | 1079 | 2755 | 83 | 0 | 2672 | 34.52041498 | -87.31069453 | 2021-02-12 05:23:29 | Lawrence, Alabama, US |
1590458 | 1590458 | 2021-02-05 | US | North Carolina | Bladen | 37017 | 2707 | 35 | 0 | 2672 | 34.61296243 | -78.56180059 | 2021-02-06 05:23:55 | Bladen, North Carolina, US |
1677233 | 1677233 | 2021-02-01 | US | Georgia | Chattahoochee | 13053 | 2675 | 3 | 0 | 2672 | 32.34341231 | -84.78809239 | 2021-02-02 05:22:49 | Chattahoochee, Georgia, US |
1462228 | 1462228 | 2021-01-31 | US | Ohio | Jackson | 39079 | 2719 | 47 | 0 | 2672 | 39.01914254 | -82.61818559999998 | 2021-02-01 05:22:53 | Jackson, Ohio, US |
3155507 | 3155507 | 2021-01-27 | US | Missouri | Howell | 29091 | 2713 | 41 | 0 | 2672 | 36.77383887 | -91.88683935 | 2021-01-28 05:22:24 | Howell, Missouri, US |
2864663 | 2864663 | 2021-01-06 | India | Haryana | 263887 | 2934 | 258281 | 2672 | 29.20004 | 76.332824 | 2021-01-07 05:22:03 | Haryana, India | ||
1063257 | 1063257 | 2021-01-04 | US | Kentucky | Jessamine | 21113 | 2719 | 47 | 0 | 2672 | 37.87119786 | -84.58252003 | 2021-01-05 05:21:49 | Jessamine, Kentucky, US |
2230863 | 2230863 | 2021-01-02 | US | Virginia | Henry | 51089 | 2727 | 55 | 0 | 2672 | 36.68542395 | -79.87634026 | 2021-01-03 05:22:52 | Henry, Virginia, US |
202838 | 202838 | 2020-12-25 | US | California | Tuolumne | 6109 | 2688 | 12 | 0 | 2672 | 38.02644018 | -119.9525093 | 2020-12-26 05:22:28 | Tuolumne, California, US |
2409395 | 2409395 | 2020-12-23 | US | Oklahoma | McCurtain | 40089 | 2722 | 50 | 0 | 2672 | 34.11664328 | -94.77222373 | 2020-12-24 05:23:04 | McCurtain, Oklahoma, US |
3772813 | 3772813 | 2020-12-22 | US | Tennessee | Hardeman | 47069 | 2672 | 41 | 0 | 2672 | 35.20772017 | -88.99161161 | 2020-12-23 05:22:03 | Hardeman, Tennessee, US |
2121973 | 2121973 | 2020-12-20 | US | New York | Steuben | 36101 | 2785 | 113 | 0 | 2672 | 42.2689144 | -77.3829924 | 2020-12-21 05:27:58 | Steuben, New York, US |
1902529 | 1902529 | 2020-12-18 | US | Kentucky | Boyd | 21019 | 2702 | 30 | 0 | 2672 | 38.36176608 | -82.68652187 | 2020-12-19 05:27:52 | Boyd, Kentucky, US |
3150658 | 3150658 | 2020-12-16 | US | Indiana | Clinton | 18023 | 2703 | 31 | 0 | 2672 | 40.30319754 | -86.47277257 | 2020-12-17 05:28:12 | Clinton, Indiana, US |
679931 | 679931 | 2020-11-23 | US | Michigan | Eaton | 26045 | 2702 | 30 | 0 | 2672 | 42.59599185 | -84.83740035 | 2020-11-24 05:27:31 | Eaton, Michigan, US |
3192322 | 3192322 | 2020-11-22 | US | North Carolina | Moore | 37125 | 2730 | 58 | 0 | 2672 | 35.30885257 | -79.48474178 | 2020-11-23 05:25:26 | Moore, North Carolina, US |
2915895 | 2915895 | 2020-11-14 | US | Florida | Nassau | 12089 | 2724 | 52 | 0 | 2672 | 30.61037141 | -81.80297522 | 2020-11-15 05:26:53 | Nassau, Florida, US |
1990479 | 1990479 | 2020-11-09 | US | Mississippi | Washington | 28151 | 2777 | 105 | 0 | 2672 | 33.28392041 | -90.94196237 | 2020-11-10 05:40:07 | Washington, Mississippi, US |
892596 | 892596 | 2020-11-05 | US | Arkansas | Garland | 5051 | 2748 | 76 | 0 | 2672 | 34.57692074 | -93.14921604 | 2020-11-06 05:24:55 | Garland, Arkansas, US |
1056123 | 1056123 | 2020-10-23 | US | North Carolina | Duplin | 37061 | 2726 | 54 | 0 | 2672 | 34.93449805 | -77.93140529 | 2020-10-24 04:24:46 | Duplin, North Carolina, US |
762392 | 762392 | 2020-10-18 | Mexico | Chihuahua | 14366 | 1582 | 10112 | 2672 | 28.633000000000006 | -106.0691 | 2020-10-19 04:24:16 | Chihuahua, Mexico | ||
762282 | 762282 | 2020-10-18 | India | Tripura | 29553 | 331 | 26550 | 2672 | 23.746783 | 91.743565 | 2020-10-19 04:24:16 | Tripura, India | ||
2869370 | 2869370 | 2020-09-13 | US | Delaware | Kent | 10001 | 2788 | 116 | 0 | 2672 | 39.08646628 | -75.56884914 | 2020-09-14 04:26:00 | Kent, Delaware, US |
430583 | 430583 | 2020-09-07 | US | Utah | Bear River | 2683 | 11 | 0 | 2672 | 41.52106798 | -113.0832816 | 2020-09-08 04:28:25 | Bear River, Utah, US | |
3163111 | 3163111 | 2020-09-06 | US | Louisiana | Iberia | 22045 | 2759 | 87 | 0 | 2672 | 29.86803617 | -91.75871777 | 2020-09-07 04:28:30 | Iberia, Louisiana, US |
1999760 | 1999760 | 2020-08-26 | US | Texas | Kaufman | 48257 | 2481 | 33 | 0 | 2672 | 32.599141700000004 | -96.28734728 | 2020-08-27 04:28:15 | Kaufman, Texas, US |
1999458 | 1999458 | 2020-08-26 | US | South Carolina | Orangeburg | 45075 | 2765 | 93 | 0 | 2672 | 33.4391073 | -80.79886287 | 2020-08-27 04:28:15 | Orangeburg, South Carolina, US |
3563010 | 3563010 | 2020-08-25 | US | Arizona | Santa Cruz | 4023 | 2728 | 56 | 0 | 2672 | 31.52508998 | -110.8479088 | 2020-08-26 04:28:11 | Santa Cruz, Arizona, US |
2994091 | 2994091 | 2020-08-24 | US | South Carolina | Sumter | 45085 | 2731 | 59 | 0 | 2672 | 33.91826534 | -80.37942316 | 2020-08-25 04:28:02 | Sumter, South Carolina, US |
2992947 | 2992947 | 2020-08-24 | US | Michigan | Washtenaw | 26161 | 2787 | 115 | 0 | 2672 | 42.253105 | -83.83853204 | 2020-08-25 04:28:02 | Washtenaw, Michigan, US |
1480108 | 1480108 | 2020-08-21 | US | California | Placer | 6061 | 2704 | 30 | 0 | 2672 | 39.06167234 | -120.7240569 | 2020-08-22 04:27:49 | Placer, California, US |
207029 | 207029 | 2020-08-19 | US | Georgia | Dougherty | 13095 | 2845 | 173 | 0 | 2672 | 31.53328528 | -84.21722377 | 2020-08-20 04:27:43 | Dougherty, Georgia, US |
2956956 | 2956956 | 2020-07-29 | US | Illinois | McHenry | 17111 | 2783 | 111 | 0 | 2672 | 42.32451172 | -88.45248227 | 2020-07-30 04:35:05 | McHenry, Illinois, US |
3185398 | 3185398 | 2020-07-28 | Russia | Ulyanovsk Oblast | 8781 | 72 | 6037 | 2672 | 54.146317700000004 | 47.2324921 | 2020-07-29 04:35:11 | Ulyanovsk Oblast, Russia | ||
177448 | 177448 | 2020-07-27 | Russia | Ulyanovsk Oblast | 8671 | 66 | 5933 | 2672 | 54.146317700000004 | 47.2324921 | 2020-07-28 04:58:43 | Ulyanovsk Oblast, Russia | ||
439148 | 439148 | 2020-07-26 | US | Virginia | Arlington | 51013 | 2807 | 135 | 0 | 2672 | 38.8767675 | -77.10139853 | 2020-07-27 04:35:02 | Arlington, Virginia, US |
3737880 | 3737880 | 2020-07-12 | Russia | Voronezh Oblast | 9280 | 63 | 6545 | 2672 | 50.9800393 | 40.15065070000001 | 2020-07-13 04:43:04 | Voronezh Oblast, Russia | ||
3737257 | 3737257 | 2020-07-12 | US | Texas | Webb | 48479 | 2078 | 50 | 0 | 2672 | 27.7610369 | -99.33237355 | 2020-07-13 04:43:04 | Webb, Texas, US |
2385186 | 2385186 | 2020-06-16 | US | Alabama | Mobile | 1097 | 2801 | 129 | 0 | 2672 | 30.78472347 | -88.20842409 | 2020-06-17 04:33:21 | Mobile, Alabama, US |
287521 | 287521 | 2020-06-15 | Gabon | 4033 | 27 | 1334 | 2672 | -0.8037 | 11.6094 | 2020-06-16 04:33:09 | Gabon | |||
737541 | 737541 | 2020-06-12 | Chile | Maule | 2691 | 19 | 0 | 2672 | -35.5183 | -71.6885 | 2020-06-13 03:33:14 | Maule, Chile | ||
735317 | 735317 | 2020-06-12 | US | Georgia | Hall | 13139 | 2727 | 55 | 0 | 2672 | 34.32207823 | -83.81896936 | 2020-06-13 03:33:14 | Hall, Georgia, US |
1271913 | 1271913 | 2020-06-11 | US | Ohio | Marion | 39101 | 2699 | 27 | 0 | 2672 | 40.58610662 | -83.15736305 | 2020-06-12 05:09:52 | Marion, Ohio, US |
573881 | 573881 | 2020-06-06 | Colombia | Bolivar | 3858 | 175 | 1011 | 2672 | 8.6704 | -74.03 | 2020-06-07 03:53:30 | Bolivar, Colombia | ||
1269578 | 1269578 | 2020-06-05 | Colombia | Bolivar | 3858 | 175 | 1011 | 2672 | 8.6704 | -74.03 | 2020-06-06 02:33:00 | Bolivar, Colombia |
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]);