johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
65 rows where active = 2936 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
726436 | 726436 | 2021-05-22 | India | Arunachal Pradesh | 23867 | 95 | 20836 | 2936 | 27.768456 | 96.384277 | 2021-05-23 04:20:51 | Arunachal Pradesh, India | ||
1425285 | 1425285 | 2021-05-09 | Russia | Altai Krai | 50272 | 2119 | 45217 | 2936 | 52.6932243 | 82.69314240000001 | 2021-05-10 04:20:38 | Altai Krai, Russia | ||
3393233 | 3393233 | 2021-04-28 | Colombia | Caldas | 60367 | 1178 | 56253 | 2936 | 5.2983 | -75.2479 | 2021-04-29 04:20:55 | Caldas, Colombia | ||
36663 | 36663 | 2021-04-12 | Russia | Orenburg Oblast | 41012 | 773 | 37303 | 2936 | 52.02692620000001 | 54.7276647 | 2021-04-13 04:20:37 | Orenburg Oblast, Russia | ||
1744745 | 1744745 | 2021-03-20 | Russia | Karelia Republic | 42904 | 358 | 39610 | 2936 | 62.61940309999999 | 33.4920267 | 2021-03-21 05:25:44 | Karelia Republic, Russia | ||
183734 | 183734 | 2021-02-21 | US | Minnesota | Carlton | 27017 | 2980 | 44 | 0 | 2936 | 46.59180601 | -92.67601019 | 2021-02-22 05:24:21 | Carlton, Minnesota, US |
744938 | 744938 | 2021-02-20 | US | Oregon | Polk | 41053 | 2978 | 42 | 0 | 2936 | 44.90322804 | -123.4128888 | 2021-02-21 05:24:33 | Polk, Oregon, US |
743704 | 743704 | 2021-02-20 | US | Kentucky | Floyd | 21071 | 2965 | 29 | 0 | 2936 | 37.56213922 | -82.74750924 | 2021-02-21 05:24:33 | Floyd, Kentucky, US |
3052147 | 3052147 | 2021-02-16 | US | Missouri | Webster | 29225 | 2984 | 48 | 0 | 2936 | 37.2813734 | -92.876329 | 2021-02-17 05:23:10 | Webster, Missouri, US |
1529203 | 1529203 | 2021-02-09 | US | Kansas | McPherson | 20113 | 3009 | 73 | 0 | 2936 | 38.39184858 | -97.64769869 | 2021-02-10 05:22:41 | McPherson, Kansas, US |
614994 | 614994 | 2021-02-08 | US | Kansas | McPherson | 20113 | 3009 | 73 | 0 | 2936 | 38.39184858 | -97.64769869 | 2021-02-09 05:23:30 | McPherson, Kansas, US |
1678311 | 1678311 | 2021-02-01 | US | Mississippi | Sunflower | 28133 | 3017 | 81 | 0 | 2936 | 33.60192578 | -90.58882684 | 2021-02-02 05:22:49 | Sunflower, Mississippi, US |
13461 | 13461 | 2021-01-26 | US | Indiana | Putnam | 18133 | 2991 | 55 | 0 | 2936 | 39.66437981 | -86.84517605 | 2021-01-27 05:23:41 | Putnam, Indiana, US |
2568785 | 2568785 | 2021-01-25 | US | Indiana | Putnam | 18133 | 2989 | 53 | 0 | 2936 | 39.66437981 | -86.84517605 | 2021-01-26 05:22:02 | Putnam, Indiana, US |
2469757 | 2469757 | 2021-01-22 | US | Tennessee | Lauderdale | 47097 | 2954 | 33 | 0 | 2936 | 35.75893438 | -89.63015909999999 | 2021-01-23 05:22:03 | Lauderdale, Tennessee, US |
1095142 | 1095142 | 2021-01-20 | US | Indiana | Adams | 18001 | 2978 | 42 | 0 | 2936 | 40.7457653 | -84.93671406 | 2021-01-21 05:22:01 | Adams, Indiana, US |
239677 | 239677 | 2021-01-18 | US | Ohio | Brown | 39015 | 2982 | 46 | 0 | 2936 | 38.93416837 | -83.86788395 | 2021-01-19 05:22:15 | Brown, Ohio, US |
3504976 | 3504976 | 2021-01-17 | US | Michigan | Delta | 26041 | 3015 | 79 | 0 | 2936 | 45.90484910000001 | -86.9080745 | 2021-01-18 05:22:34 | Delta, Michigan, US |
3103059 | 3103059 | 2021-01-16 | US | Michigan | Delta | 26041 | 3015 | 79 | 0 | 2936 | 45.90484910000001 | -86.9080745 | 2021-01-17 05:22:17 | Delta, Michigan, US |
3516761 | 3516761 | 2021-01-15 | US | Kentucky | Barren | 21009 | 2971 | 35 | 0 | 2936 | 36.96469836 | -85.93338945 | 2021-01-16 05:22:40 | Barren, Kentucky, US |
3880785 | 3880785 | 2021-01-14 | US | Iowa | Marion | 19125 | 2988 | 52 | 0 | 2936 | 41.33445101 | -93.09934783 | 2021-01-15 05:22:24 | Marion, Iowa, US |
3308688 | 3308688 | 2021-01-13 | US | Arkansas | Jackson | 5067 | 2963 | 27 | 0 | 2936 | 35.59802983 | -91.21494602 | 2021-01-14 05:22:32 | Jackson, Arkansas, US |
776920 | 776920 | 2021-01-12 | US | Oklahoma | Okmulgee | 40111 | 2966 | 30 | 0 | 2936 | 35.64661916 | -95.96432828 | 2021-01-13 05:22:15 | Okmulgee, Oklahoma, US |
775134 | 775134 | 2021-01-12 | US | Georgia | Effingham | 13103 | 2973 | 37 | 0 | 2936 | 32.36616021 | -81.34280942 | 2021-01-13 05:22:15 | Effingham, Georgia, US |
156436 | 156436 | 2021-01-08 | US | Ohio | Fulton | 39051 | 2987 | 51 | 0 | 2936 | 41.60213491 | -84.12571393 | 2021-01-09 05:22:18 | Fulton, Ohio, US |
3036948 | 3036948 | 2021-01-05 | US | Pennsylvania | Carbon | 42025 | 3028 | 92 | 0 | 2936 | 40.91545395 | -75.7068525 | 2021-01-06 05:22:16 | Carbon, Pennsylvania, US |
768338 | 768338 | 2020-12-29 | US | Montana | Silver Bow | 30093 | 2970 | 34 | 0 | 2936 | 45.90018933 | -112.6620092 | 2020-12-30 05:22:34 | Silver Bow, Montana, US |
767778 | 767778 | 2020-12-29 | US | Kentucky | Shelby | 21211 | 2964 | 28 | 0 | 2936 | 38.21476019 | -85.194223 | 2020-12-30 05:22:34 | Shelby, Kentucky, US |
3761322 | 3761322 | 2020-12-28 | Brazil | Goias | 306395 | 6776 | 295425 | 2936 | -15.827 | -49.8362 | 2020-12-29 05:22:37 | Goias, Brazil | ||
2227084 | 2227084 | 2020-12-26 | US | Wisconsin | Trempealeau | 55121 | 2966 | 30 | 0 | 2936 | 44.30360275 | -91.35893614 | 2020-12-27 05:22:55 | Trempealeau, Wisconsin, US |
204581 | 204581 | 2020-12-25 | US | North Carolina | Lenoir | 37107 | 3000 | 64 | 0 | 2936 | 35.24032589999999 | -77.64245615 | 2020-12-26 05:22:28 | Lenoir, North Carolina, US |
3693804 | 3693804 | 2020-12-24 | US | North Carolina | Lenoir | 37107 | 3000 | 64 | 0 | 2936 | 35.24032589999999 | -77.64245615 | 2020-12-25 05:22:48 | Lenoir, North Carolina, US |
2409156 | 2409156 | 2020-12-23 | US | North Carolina | Lenoir | 37107 | 3000 | 64 | 0 | 2936 | 35.24032589999999 | -77.64245615 | 2020-12-24 05:23:04 | Lenoir, North Carolina, US |
2932226 | 2932226 | 2020-12-19 | US | Illinois | Macoupin | 17117 | 2984 | 48 | 0 | 2936 | 39.26119767 | -89.92424028 | 2020-12-20 05:27:32 | Macoupin, Illinois, US |
1037767 | 1037767 | 2020-12-15 | US | Virginia | Rockingham | 51165 | 2974 | 38 | 0 | 2936 | 38.51006137 | -78.87260325 | 2020-12-16 05:28:04 | Rockingham, Virginia, US |
862824 | 862824 | 2020-12-11 | US | New Hampshire | Merrimack | 33013 | 2975 | 39 | 0 | 2936 | 43.29662971 | -71.6811573 | 2020-12-12 05:26:19 | Merrimack, New Hampshire, US |
2976317 | 2976317 | 2020-12-09 | US | Indiana | Jackson | 18071 | 2981 | 45 | 0 | 2936 | 38.90915820000001 | -86.03851889 | 2020-12-10 05:26:19 | Jackson, Indiana, US |
3861474 | 3861474 | 2020-12-04 | US | Michigan | Lenawee | 26091 | 2964 | 28 | 0 | 2936 | 41.89475156 | -84.06603727 | 2020-12-05 05:27:36 | Lenawee, Michigan, US |
2702597 | 2702597 | 2020-11-20 | US | Indiana | Howard | 18067 | 3017 | 81 | 0 | 2936 | 40.48527731 | -86.11351892 | 2020-11-21 05:25:51 | Howard, Indiana, US |
821814 | 821814 | 2020-11-19 | Russia | Smolensk Oblast | 10917 | 262 | 7719 | 2936 | 55.03434960000001 | 33.0192065 | 2020-11-20 05:26:28 | Smolensk Oblast, Russia | ||
821772 | 821772 | 2020-11-19 | Russia | Kaluga Oblast | 14437 | 100 | 11401 | 2936 | 54.4382773 | 35.5272854 | 2020-11-20 05:26:28 | Kaluga Oblast, Russia | ||
2785804 | 2785804 | 2020-11-13 | US | Georgia | Gordon | 13129 | 2994 | 58 | 0 | 2936 | 34.50487351 | -84.87296253 | 2020-11-14 05:25:37 | Gordon, Georgia, US |
3441291 | 3441291 | 2020-11-11 | US | Arkansas | Garland | 5051 | 3018 | 82 | 0 | 2936 | 34.57692074 | -93.14921604 | 2020-11-12 05:25:55 | Garland, Arkansas, US |
376393 | 376393 | 2020-11-06 | Russia | Kostroma Oblast | 8101 | 140 | 5025 | 2936 | 58.424756 | 44.2533273 | 2020-11-07 05:24:52 | Kostroma Oblast, Russia | ||
2501600 | 2501600 | 2020-11-03 | US | Wisconsin | Waupaca | 55135 | 2985 | 49 | 0 | 2936 | 44.47068056 | -88.96534501 | 2020-11-04 05:25:09 | Waupaca, Wisconsin, US |
1454449 | 1454449 | 2020-10-27 | US | Missouri | Buchanan | 29021 | 2976 | 40 | 0 | 2936 | 39.65816401 | -94.80138942 | 2020-10-28 04:24:39 | Buchanan, Missouri, US |
1027844 | 1027844 | 2020-10-17 | US | Louisiana | Iberia | 22045 | 3029 | 93 | 0 | 2936 | 29.86803617 | -91.75871777 | 2020-10-18 04:24:25 | Iberia, Louisiana, US |
2858339 | 2858339 | 2020-10-16 | US | Louisiana | Iberia | 22045 | 3029 | 93 | 0 | 2936 | 29.86803617 | -91.75871777 | 2020-10-17 04:24:12 | Iberia, Louisiana, US |
3782372 | 3782372 | 2020-10-13 | US | Arkansas | Faulkner | 5045 | 2963 | 27 | 0 | 2936 | 35.14719007 | -92.33717519 | 2020-10-14 04:24:05 | Faulkner, Arkansas, US |
3786421 | 3786421 | 2020-10-11 | US | California | Butte | 6007 | 3019 | 54 | 0 | 2936 | 39.66727762 | -121.6005252 | 2020-10-12 04:23:45 | Butte, California, US |
3121117 | 3121117 | 2020-10-06 | Ukraine | Zhytomyr Oblast | 7070 | 128 | 4006 | 2936 | 50.2547 | 28.6587 | 2020-10-07 04:23:40 | Zhytomyr Oblast, Ukraine | ||
2379624 | 2379624 | 2020-10-01 | Italy | Sicilia | 7274 | 312 | 4026 | 2936 | 38.11569725 | 13.362356699999998 | 2020-10-02 04:23:51 | Sicilia, Italy | ||
2606220 | 2606220 | 2020-09-24 | Russia | Irkutsk Oblast | 18586 | 281 | 15369 | 2936 | 56.6370122 | 104.719221 | 2020-09-25 04:23:00 | Irkutsk Oblast, Russia | ||
2839100 | 2839100 | 2020-09-21 | US | North Carolina | Catawba | 37035 | 2987 | 51 | 0 | 2936 | 35.66211129 | -81.2132617 | 2020-09-22 04:23:00 | Catawba, North Carolina, US |
3093702 | 3093702 | 2020-09-20 | Spain | Asturias | 4340 | 341 | 1063 | 2936 | 43.3614 | -5.8593 | 2020-09-21 04:23:00 | Asturias, Spain | ||
2455052 | 2455052 | 2020-09-19 | Spain | Asturias | 4340 | 341 | 1063 | 2936 | 43.3614 | -5.8593 | 2020-09-20 04:22:00 | Asturias, Spain | ||
2849121 | 2849121 | 2020-09-18 | Spain | Asturias | 4340 | 341 | 1063 | 2936 | 43.3614 | -5.8593 | 2020-09-19 04:22:00 | Asturias, Spain | ||
669398 | 669398 | 2020-09-16 | US | Texas | Kaufman | 48257 | 2750 | 45 | 0 | 2936 | 32.5991417 | -96.28734728 | 2020-09-17 04:22:00 | Kaufman, Texas, US |
665295 | 665295 | 2020-08-11 | US | Tennessee | Out of TN | 80047 | 1370 | 16 | 0 | 2936 | 36.55606529 | 0.0 | 2020-08-12 04:27:29 | Out of TN, Tennessee, US |
2957480 | 2957480 | 2020-07-29 | US | Wisconsin | Racine | 55101 | 3011 | 75 | 0 | 2936 | 42.74753117 | -88.05941254 | 2020-07-30 04:35:05 | Racine, Wisconsin, US |
3184684 | 3184684 | 2020-07-28 | US | Texas | Victoria | 48469 | 2759 | 24 | 0 | 2936 | 28.79780988 | -96.96813006 | 2020-07-29 04:35:11 | Victoria, Texas, US |
177537 | 177537 | 2020-07-27 | Congo (Kinshasa) | 8844 | 208 | 5700 | 2936 | -4.0383 | 21.7587 | 2020-07-28 04:58:43 | Congo (Kinshasa) | |||
1500852 | 1500852 | 2020-07-25 | US | Tennessee | Knox | 47093 | 3298 | 23 | 0 | 2936 | 35.99508821 | -83.94635435 | 2020-07-26 04:35:00 | Knox, Tennessee, US |
2974139 | 2974139 | 2020-06-30 | US | Illinois | Winnebago | 17201 | 3030 | 94 | 0 | 2936 | 42.33641854 | -89.16085327 | 2020-07-01 04:33:52 | Winnebago, Illinois, US |
3082655 | 3082655 | 2020-05-04 | US | Georgia | Fulton | 13121 | 3065 | 129 | 0 | 2936 | 33.79216944 | -84.46319413 | 2020-05-05 02:32:34 | Fulton, Georgia, 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]);