johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
374 rows where confirmed = 2205 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331134 | 331134 | 2022-12-27 | US | Texas | Somervell | 48425 | 2205 | 37 | 0 | 32.22236802 | -97.77403489 | 2022-12-28 04:21:04 | Somervell, Texas, US | |
221297 | 221297 | 2022-12-26 | US | Virginia | Buena Vista | 51530 | 2205 | 47 | 0 | 37.73484642 | -79.35296097 | 2022-12-27 04:21:07 | Buena Vista, Virginia, US | |
221207 | 221207 | 2022-12-26 | US | Texas | Somervell | 48425 | 2205 | 37 | 0 | 32.22236802 | -97.77403489 | 2022-12-27 04:21:07 | Somervell, Texas, US | |
3225664 | 3225664 | 2022-12-25 | US | Texas | Somervell | 48425 | 2205 | 37 | 0 | 32.22236802 | -97.77403489 | 2022-12-26 04:21:06 | Somervell, Texas, US | |
1021578 | 1021578 | 2022-12-24 | US | Texas | Somervell | 48425 | 2205 | 37 | 0 | 32.22236802 | -97.77403489 | 2022-12-25 04:21:04 | Somervell, Texas, US | |
693601 | 693601 | 2022-12-23 | US | Texas | Somervell | 48425 | 2205 | 37 | 0 | 32.22236802 | -97.77403489 | 2022-12-24 04:21:02 | Somervell, Texas, US | |
2182811 | 2182811 | 2022-12-22 | US | Texas | Somervell | 48425 | 2205 | 37 | 0 | 32.22236802 | -97.77403489 | 2022-12-23 04:21:04 | Somervell, Texas, US | |
454817 | 454817 | 2022-12-21 | US | Virginia | Williamsburg | 51830 | 2205 | 24 | 0 | 37.28131268 | -76.70905141 | 2022-12-22 04:20:56 | Williamsburg, Virginia, US | |
454615 | 454615 | 2022-12-21 | US | Texas | Somervell | 48425 | 2205 | 37 | 0 | 32.22236802 | -97.77403489 | 2022-12-22 04:20:56 | Somervell, Texas, US | |
2952725 | 2952725 | 2022-12-20 | US | Kansas | Pratt | 20151 | 2205 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-12-21 04:21:03 | Pratt, Kansas, US | |
3175127 | 3175127 | 2022-12-19 | US | Kansas | Pratt | 20151 | 2205 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-12-20 04:21:04 | Pratt, Kansas, US | |
1629644 | 1629644 | 2022-12-18 | US | Kansas | Pratt | 20151 | 2205 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-12-19 04:21:03 | Pratt, Kansas, US | |
505023 | 505023 | 2022-12-17 | US | Kansas | Pratt | 20151 | 2205 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-12-18 04:21:03 | Pratt, Kansas, US | |
3325595 | 3325595 | 2022-12-16 | US | Kansas | Pratt | 20151 | 2205 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-12-17 04:21:04 | Pratt, Kansas, US | |
544107 | 544107 | 2022-12-15 | US | Kansas | Pratt | 20151 | 2205 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-12-16 04:21:01 | Pratt, Kansas, US | |
349635 | 349635 | 2022-12-14 | US | Kansas | Pratt | 20151 | 2205 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-12-15 04:20:58 | Pratt, Kansas, US | |
320600 | 320600 | 2022-10-30 | US | Colorado | Yuma | 8125 | 2205 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-10-31 04:21:36 | Yuma, Colorado, US | |
912876 | 912876 | 2022-10-29 | US | Colorado | Yuma | 8125 | 2205 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-10-30 04:22:14 | Yuma, Colorado, US | |
1367145 | 1367145 | 2022-10-28 | US | Colorado | Yuma | 8125 | 2205 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-10-29 04:21:13 | Yuma, Colorado, US | |
3039000 | 3039000 | 2022-10-27 | US | Colorado | Yuma | 8125 | 2205 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-10-28 04:22:31 | Yuma, Colorado, US | |
2971027 | 2971027 | 2022-10-10 | US | Wyoming | Sublette | 56035 | 2205 | 28 | 0 | 42.76558279 | -109.9130922 | 2022-10-11 04:23:05 | Sublette, Wyoming, US | |
3101063 | 3101063 | 2022-10-09 | US | Wyoming | Sublette | 56035 | 2205 | 28 | 0 | 42.76558279 | -109.9130922 | 2022-10-10 04:22:32 | Sublette, Wyoming, US | |
4006288 | 4006288 | 2022-10-08 | US | Wyoming | Sublette | 56035 | 2205 | 28 | 0 | 42.76558279 | -109.9130922 | 2022-10-09 04:21:16 | Sublette, Wyoming, US | |
399885 | 399885 | 2022-10-07 | US | Wyoming | Sublette | 56035 | 2205 | 28 | 0 | 42.76558279 | -109.9130922 | 2022-10-08 04:22:56 | Sublette, Wyoming, US | |
396778 | 396778 | 2022-10-07 | US | Arkansas | Monroe | 5095 | 2205 | 37 | 0 | 34.6815935 | -91.20540287 | 2022-10-08 04:22:56 | Monroe, Arkansas, US | |
2533002 | 2533002 | 2022-10-06 | US | Wyoming | Sublette | 56035 | 2205 | 28 | 0 | 42.76558279 | -109.9130922 | 2022-10-07 04:23:08 | Sublette, Wyoming, US | |
1814396 | 1814396 | 2022-10-05 | US | Wyoming | Sublette | 56035 | 2205 | 28 | 0 | 42.76558279 | -109.9130922 | 2022-10-06 04:21:22 | Sublette, Wyoming, US | |
134370 | 134370 | 2022-10-04 | US | Wyoming | Sublette | 56035 | 2205 | 28 | 0 | 42.76558279 | -109.9130922 | 2022-10-05 04:23:06 | Sublette, Wyoming, US | |
134326 | 134326 | 2022-10-04 | US | Wisconsin | Pepin | 55091 | 2205 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-10-05 04:23:06 | Pepin, Wisconsin, US | |
2689273 | 2689273 | 2022-10-03 | US | Wisconsin | Pepin | 55091 | 2205 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-10-04 04:22:55 | Pepin, Wisconsin, US | |
3998212 | 3998212 | 2022-09-27 | US | Wisconsin | Pepin | 55091 | 2205 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-09-28 04:23:01 | Pepin, Wisconsin, US | |
3998205 | 3998205 | 2022-09-27 | US | Wisconsin | Menominee | 55078 | 2205 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-09-28 04:23:01 | Menominee, Wisconsin, US | |
1374003 | 1374003 | 2022-09-21 | US | West Virginia | Pendleton | 54071 | 2205 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-09-22 04:22:56 | Pendleton, West Virginia, US | |
2020233 | 2020233 | 2022-09-20 | US | West Virginia | Pendleton | 54071 | 2205 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-09-21 04:23:22 | Pendleton, West Virginia, US | |
3574106 | 3574106 | 2022-09-19 | US | West Virginia | Pendleton | 54071 | 2205 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-09-20 04:22:48 | Pendleton, West Virginia, US | |
422427 | 422427 | 2022-09-18 | US | Texas | Floyd | 48153 | 2205 | 49 | 0 | 34.07227468 | -101.3031546 | 2022-09-19 04:21:49 | Floyd, Texas, US | |
3376451 | 3376451 | 2022-09-17 | US | Texas | Floyd | 48153 | 2205 | 49 | 0 | 34.07227468 | -101.3031546 | 2022-09-18 04:22:50 | Floyd, Texas, US | |
2358559 | 2358559 | 2022-09-16 | US | Texas | Floyd | 48153 | 2205 | 49 | 0 | 34.07227468 | -101.3031546 | 2022-09-17 04:20:19 | Floyd, Texas, US | |
115602 | 115602 | 2022-09-06 | US | Georgia | Montgomery | 13209 | 2205 | 54 | 0 | 32.17201038 | -82.53527476 | 2022-09-07 04:20:59 | Montgomery, Georgia, US | |
2634574 | 2634574 | 2022-09-05 | US | Georgia | Montgomery | 13209 | 2205 | 54 | 0 | 32.17201038 | -82.53527476 | 2022-09-06 04:21:02 | Montgomery, Georgia, US | |
2988138 | 2988138 | 2022-09-04 | US | Georgia | Montgomery | 13209 | 2205 | 54 | 0 | 32.17201038 | -82.53527476 | 2022-09-05 04:21:01 | Montgomery, Georgia, US | |
2713823 | 2713823 | 2022-09-03 | US | Georgia | Montgomery | 13209 | 2205 | 54 | 0 | 32.17201038 | -82.53527476 | 2022-09-04 04:21:22 | Montgomery, Georgia, US | |
1394528 | 1394528 | 2022-09-02 | US | Georgia | Montgomery | 13209 | 2205 | 54 | 0 | 32.17201038 | -82.53527476 | 2022-09-03 04:21:04 | Montgomery, Georgia, US | |
3549450 | 3549450 | 2022-09-01 | US | Missouri | Oregon | 29149 | 2205 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-09-02 04:21:07 | Oregon, Missouri, US | |
3548357 | 3548357 | 2022-09-01 | US | Georgia | Montgomery | 13209 | 2205 | 54 | 0 | 32.17201038 | -82.53527476 | 2022-09-02 04:21:07 | Montgomery, Georgia, US | |
2345370 | 2345370 | 2022-08-31 | US | Missouri | Oregon | 29149 | 2205 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-09-01 04:21:03 | Oregon, Missouri, US | |
2344277 | 2344277 | 2022-08-31 | US | Georgia | Montgomery | 13209 | 2205 | 54 | 0 | 32.17201038 | -82.53527476 | 2022-09-01 04:21:03 | Montgomery, Georgia, US | |
3775850 | 3775850 | 2022-08-30 | US | Missouri | Oregon | 29149 | 2205 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-08-31 04:20:57 | Oregon, Missouri, US | |
1682446 | 1682446 | 2022-08-29 | US | Missouri | Oregon | 29149 | 2205 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-08-30 04:21:03 | Oregon, Missouri, US | |
1878930 | 1878930 | 2022-08-28 | US | Missouri | Oregon | 29149 | 2205 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-08-29 04:21:06 | Oregon, Missouri, US | |
2098057 | 2098057 | 2022-08-27 | US | Missouri | Oregon | 29149 | 2205 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-08-28 04:21:02 | Oregon, Missouri, US | |
1533872 | 1533872 | 2022-08-26 | US | Missouri | Oregon | 29149 | 2205 | 38 | 0 | 36.68710164 | -91.4033755 | 2022-08-27 04:20:57 | Oregon, Missouri, US | |
1404832 | 1404832 | 2022-08-02 | China | Guangxi | 2205 | 2 | 0 | 23.8298 | 108.7881 | 2022-08-03 04:20:59 | Guangxi, China | |||
3618765 | 3618765 | 2022-08-01 | US | Michigan | Presque Isle | 26141 | 2205 | 61 | 0 | 45.34018577 | -83.91498656 | 2022-08-02 04:20:53 | Presque Isle, Michigan, US | |
3873245 | 3873245 | 2022-07-31 | US | Michigan | Presque Isle | 26141 | 2205 | 61 | 0 | 45.34018577 | -83.91498656 | 2022-08-01 04:21:03 | Presque Isle, Michigan, US | |
675999 | 675999 | 2022-07-30 | US | Michigan | Presque Isle | 26141 | 2205 | 61 | 0 | 45.34018577 | -83.91498656 | 2022-07-31 04:21:02 | Presque Isle, Michigan, US | |
1785198 | 1785198 | 2022-07-29 | US | Michigan | Presque Isle | 26141 | 2205 | 61 | 0 | 45.34018577 | -83.91498656 | 2022-07-30 04:20:42 | Presque Isle, Michigan, US | |
1067867 | 1067867 | 2022-07-28 | US | Montana | Carbon | 30009 | 2205 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-07-29 04:20:45 | Carbon, Montana, US | |
1067561 | 1067561 | 2022-07-28 | US | Michigan | Presque Isle | 26141 | 2205 | 61 | 0 | 45.34018577 | -83.91498656 | 2022-07-29 04:20:45 | Presque Isle, Michigan, US | |
2337386 | 2337386 | 2022-07-27 | US | Montana | Carbon | 30009 | 2205 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-07-28 04:20:56 | Carbon, Montana, US | |
2337080 | 2337080 | 2022-07-27 | US | Michigan | Presque Isle | 26141 | 2205 | 61 | 0 | 45.34018577 | -83.91498656 | 2022-07-28 04:20:56 | Presque Isle, Michigan, US | |
1489576 | 1489576 | 2022-07-26 | US | Montana | Carbon | 30009 | 2205 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-07-27 04:21:04 | Carbon, Montana, US | |
1489270 | 1489270 | 2022-07-26 | US | Michigan | Presque Isle | 26141 | 2205 | 61 | 0 | 45.34018577 | -83.91498656 | 2022-07-27 04:21:04 | Presque Isle, Michigan, US | |
1487401 | 1487401 | 2022-07-26 | China | Yunnan | 2205 | 2 | 0 | 24.974 | 101.487 | 2022-07-27 04:21:04 | Yunnan, China | |||
2596240 | 2596240 | 2022-07-25 | US | New Mexico | Quay | 35037 | 2205 | 64 | 0 | 35.10403332 | -103.5481727 | 2022-07-26 04:20:58 | Quay, New Mexico, US | |
2596022 | 2596022 | 2022-07-25 | US | Montana | Carbon | 30009 | 2205 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-07-26 04:20:58 | Carbon, Montana, US | |
2593847 | 2593847 | 2022-07-25 | China | Yunnan | 2205 | 2 | 0 | 24.974 | 101.487 | 2022-07-26 04:20:58 | Yunnan, China | |||
898137 | 898137 | 2022-07-24 | US | Montana | Carbon | 30009 | 2205 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-07-25 04:20:51 | Carbon, Montana, US | |
895962 | 895962 | 2022-07-24 | China | Yunnan | 2205 | 2 | 0 | 24.974 | 101.487 | 2022-07-25 04:20:51 | Yunnan, China | |||
93131 | 93131 | 2022-07-23 | US | Montana | Carbon | 30009 | 2205 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-07-24 04:20:47 | Carbon, Montana, US | |
90956 | 90956 | 2022-07-23 | China | Yunnan | 2205 | 2 | 0 | 24.974 | 101.487 | 2022-07-24 04:20:47 | Yunnan, China | |||
902920 | 902920 | 2022-07-22 | US | Puerto Rico | Las Marias | 72083 | 2205 | 0 | 0 | 18.23679 | -66.98362 | 2022-07-23 04:20:53 | Las Marias, Puerto Rico, US | |
902153 | 902153 | 2022-07-22 | US | Montana | Carbon | 30009 | 2205 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-07-23 04:20:53 | Carbon, Montana, US | |
2149353 | 2149353 | 2022-06-27 | US | Minnesota | Clearwater | 27029 | 2205 | 30 | 0 | 47.57992111 | -95.37790562 | 2022-06-28 04:20:58 | Clearwater, Minnesota, US | |
477154 | 477154 | 2022-06-26 | US | Minnesota | Clearwater | 27029 | 2205 | 30 | 0 | 47.57992111 | -95.37790562 | 2022-06-27 04:21:00 | Clearwater, Minnesota, US | |
940529 | 940529 | 2022-06-25 | US | Minnesota | Clearwater | 27029 | 2205 | 30 | 0 | 47.57992111 | -95.37790562 | 2022-06-26 04:21:02 | Clearwater, Minnesota, US | |
3348349 | 3348349 | 2022-06-24 | US | Minnesota | Clearwater | 27029 | 2205 | 30 | 0 | 47.57992111 | -95.37790562 | 2022-06-25 04:20:57 | Clearwater, Minnesota, US | |
3983603 | 3983603 | 2022-06-15 | US | Illinois | Hamilton | 17065 | 2205 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-06-16 04:20:55 | Hamilton, Illinois, US | |
947844 | 947844 | 2022-06-14 | US | Illinois | Hamilton | 17065 | 2205 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-06-15 04:20:54 | Hamilton, Illinois, US | |
3509208 | 3509208 | 2022-06-05 | US | Mississippi | Kemper | 28069 | 2205 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-06-06 04:20:57 | Kemper, Mississippi, US | |
3529285 | 3529285 | 2022-06-04 | US | Mississippi | Kemper | 28069 | 2205 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-06-05 04:20:55 | Kemper, Mississippi, US | |
3135371 | 3135371 | 2022-06-03 | US | Mississippi | Kemper | 28069 | 2205 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-06-04 04:20:58 | Kemper, Mississippi, US | |
3580446 | 3580446 | 2022-06-02 | US | Mississippi | Kemper | 28069 | 2205 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-06-03 04:20:58 | Kemper, Mississippi, US | |
972739 | 972739 | 2022-06-01 | US | Mississippi | Kemper | 28069 | 2205 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-06-02 05:20:39 | Kemper, Mississippi, US | |
231046 | 231046 | 2022-05-31 | US | Mississippi | Kemper | 28069 | 2205 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-06-01 04:20:55 | Kemper, Mississippi, US | |
3187811 | 3187811 | 2022-05-30 | US | Mississippi | Kemper | 28069 | 2205 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-05-31 04:20:51 | Kemper, Mississippi, US | |
3199960 | 3199960 | 2022-05-29 | US | Mississippi | Kemper | 28069 | 2205 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-05-30 04:20:50 | Kemper, Mississippi, US | |
2726838 | 2726838 | 2022-05-28 | US | Mississippi | Kemper | 28069 | 2205 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-05-29 04:20:53 | Kemper, Mississippi, US | |
1316019 | 1316019 | 2022-05-27 | US | Mississippi | Kemper | 28069 | 2205 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-05-28 04:21:07 | Kemper, Mississippi, US | |
1851811 | 1851811 | 2022-05-26 | US | Mississippi | Kemper | 28069 | 2205 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-05-27 04:20:56 | Kemper, Mississippi, US | |
2049687 | 2049687 | 2022-05-25 | US | Mississippi | Kemper | 28069 | 2205 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-05-26 04:20:50 | Kemper, Mississippi, US | |
3001740 | 3001740 | 2022-05-24 | US | North Dakota | Traill | 38097 | 2205 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-05-25 04:20:56 | Traill, North Dakota, US | |
3001125 | 3001125 | 2022-05-24 | US | Mississippi | Kemper | 28069 | 2205 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-05-25 04:20:56 | Kemper, Mississippi, US | |
3595461 | 3595461 | 2022-05-23 | US | North Dakota | Traill | 38097 | 2205 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-05-24 04:20:57 | Traill, North Dakota, US | |
3594846 | 3594846 | 2022-05-23 | US | Mississippi | Kemper | 28069 | 2205 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-05-24 04:20:57 | Kemper, Mississippi, US | |
624313 | 624313 | 2022-05-22 | US | North Dakota | Traill | 38097 | 2205 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-05-26 04:20:50 | Traill, North Dakota, US | |
623698 | 623698 | 2022-05-22 | US | Mississippi | Kemper | 28069 | 2205 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-05-26 04:20:50 | Kemper, Mississippi, US | |
1112009 | 1112009 | 2022-05-21 | US | North Dakota | Traill | 38097 | 2205 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-05-22 04:20:52 | Traill, North Dakota, US | |
1171633 | 1171633 | 2022-05-20 | US | North Dakota | Traill | 38097 | 2205 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-05-21 04:20:58 | Traill, North Dakota, US | |
2536733 | 2536733 | 2022-05-12 | US | Virginia | Falls Church | 51610 | 2205 | 17 | 0 | 38.88485255 | -77.17560759 | 2022-05-13 04:20:51 | Falls Church, Virginia, 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]);