johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
245 rows where confirmed = 3481 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2416711 | 2416711 | 2022-12-05 | US | Mississippi | Montgomery | 28097 | 3481 | 83 | 0 | 33.49419589 | -89.61729103 | 2022-12-06 04:21:03 | Montgomery, Mississippi, US | |
720319 | 720319 | 2022-12-04 | US | Mississippi | Montgomery | 28097 | 3481 | 83 | 0 | 33.49419589 | -89.61729103 | 2022-12-05 04:20:58 | Montgomery, Mississippi, US | |
2818608 | 2818608 | 2022-12-03 | US | Mississippi | Montgomery | 28097 | 3481 | 83 | 0 | 33.49419589 | -89.61729103 | 2022-12-04 04:20:56 | Montgomery, Mississippi, US | |
835464 | 835464 | 2022-12-02 | US | Mississippi | Montgomery | 28097 | 3481 | 83 | 0 | 33.49419589 | -89.61729103 | 2022-12-03 04:21:02 | Montgomery, Mississippi, US | |
834099 | 834099 | 2022-12-02 | US | Arkansas | Bradley | 5011 | 3481 | 56 | 0 | 33.46755808 | -92.15980837 | 2022-12-03 04:21:02 | Bradley, Arkansas, US | |
833426 | 833426 | 2022-12-02 | China | Jiangsu | 3481 | 0 | 0 | 32.9711 | 119.455 | 2022-12-03 04:21:02 | Jiangsu, China | |||
2137994 | 2137994 | 2022-12-01 | US | Mississippi | Montgomery | 28097 | 3481 | 83 | 0 | 33.49419589 | -89.61729103 | 2022-12-02 04:21:07 | Montgomery, Mississippi, US | |
2136629 | 2136629 | 2022-12-01 | US | Arkansas | Bradley | 5011 | 3481 | 56 | 0 | 33.46755808 | -92.15980837 | 2022-12-02 04:21:07 | Bradley, Arkansas, US | |
1966410 | 1966410 | 2022-11-30 | US | Mississippi | Montgomery | 28097 | 3481 | 83 | 0 | 33.49419589 | -89.61729103 | 2022-12-01 04:21:03 | Montgomery, Mississippi, US | |
2558424 | 2558424 | 2022-11-29 | US | Mississippi | Montgomery | 28097 | 3481 | 83 | 0 | 33.49419589 | -89.61729103 | 2022-11-30 04:21:07 | Montgomery, Mississippi, US | |
1240318 | 1240318 | 2022-11-28 | US | Colorado | Rio Grande | 8105 | 3481 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-11-29 04:21:05 | Rio Grande, Colorado, US | |
3552306 | 3552306 | 2022-11-27 | US | Colorado | Rio Grande | 8105 | 3481 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-11-28 04:21:02 | Rio Grande, Colorado, US | |
2100786 | 2100786 | 2022-11-26 | US | Colorado | Rio Grande | 8105 | 3481 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-11-27 04:21:05 | Rio Grande, Colorado, US | |
488277 | 488277 | 2022-11-25 | US | Colorado | Rio Grande | 8105 | 3481 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-11-26 04:21:11 | Rio Grande, Colorado, US | |
3525840 | 3525840 | 2022-11-24 | US | North Dakota | Barnes | 38003 | 3481 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-11-25 04:21:06 | Barnes, North Dakota, US | |
3314623 | 3314623 | 2022-11-23 | US | North Dakota | Barnes | 38003 | 3481 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-11-24 04:21:09 | Barnes, North Dakota, US | |
1620930 | 1620930 | 2022-11-22 | US | Colorado | Rio Grande | 8105 | 3481 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-11-23 04:21:06 | Rio Grande, Colorado, US | |
434103 | 434103 | 2022-11-03 | US | Puerto Rico | Guanica | 72055 | 3481 | 0 | 0 | 17.982429 | -66.919643 | 2022-11-04 04:22:11 | Guanica, Puerto Rico, US | |
711094 | 711094 | 2022-11-01 | US | Colorado | Moffat | 8081 | 3481 | 55 | 0 | 40.61810999 | -108.2070876 | 2022-11-02 04:22:09 | Moffat, Colorado, US | |
3285467 | 3285467 | 2022-10-31 | US | California | Mono | 6051 | 3481 | 7 | 0 | 37.93899289 | -118.8872409 | 2022-11-01 04:22:36 | Mono, California, US | |
320500 | 320500 | 2022-10-30 | US | California | Mono | 6051 | 3481 | 7 | 0 | 37.93899289 | -118.8872409 | 2022-10-31 04:21:36 | Mono, California, US | |
912776 | 912776 | 2022-10-29 | US | California | Mono | 6051 | 3481 | 7 | 0 | 37.93899289 | -118.8872409 | 2022-10-30 04:22:14 | Mono, California, US | |
1367045 | 1367045 | 2022-10-28 | US | California | Mono | 6051 | 3481 | 7 | 0 | 37.93899289 | -118.8872409 | 2022-10-29 04:21:13 | Mono, California, US | |
3038900 | 3038900 | 2022-10-27 | US | California | Mono | 6051 | 3481 | 7 | 0 | 37.93899289 | -118.8872409 | 2022-10-28 04:22:31 | Mono, California, US | |
539320 | 539320 | 2022-10-26 | US | California | Mono | 6051 | 3481 | 7 | 0 | 37.93899289 | -118.8872409 | 2022-10-27 04:22:01 | Mono, California, US | |
2267701 | 2267701 | 2022-10-22 | China | Henan | 3481 | 22 | 0 | 33.882 | 113.614 | 2022-10-23 04:22:46 | Henan, China | |||
1814294 | 1814294 | 2022-10-05 | US | West Virginia | Summers | 54089 | 3481 | 60 | 0 | 37.65390597 | -80.86009693 | 2022-10-06 04:21:22 | Summers, West Virginia, US | |
134268 | 134268 | 2022-10-04 | US | West Virginia | Summers | 54089 | 3481 | 60 | 0 | 37.65390597 | -80.86009693 | 2022-10-05 04:23:06 | Summers, West Virginia, US | |
2772571 | 2772571 | 2022-09-26 | US | Wyoming | Converse | 56009 | 3481 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-09-27 04:23:01 | Converse, Wyoming, US | |
1980224 | 1980224 | 2022-09-25 | US | Wyoming | Converse | 56009 | 3481 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-09-26 04:20:52 | Converse, Wyoming, US | |
2653391 | 2653391 | 2022-09-24 | US | Wyoming | Converse | 56009 | 3481 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-09-25 04:23:31 | Converse, Wyoming, US | |
387831 | 387831 | 2022-09-23 | US | Wyoming | Converse | 56009 | 3481 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-09-24 04:21:40 | Converse, Wyoming, US | |
1627897 | 1627897 | 2022-09-22 | US | Wyoming | Converse | 56009 | 3481 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-09-23 04:23:13 | Converse, Wyoming, US | |
1374101 | 1374101 | 2022-09-21 | US | Wyoming | Converse | 56009 | 3481 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-09-22 04:22:56 | Converse, Wyoming, US | |
2020331 | 2020331 | 2022-09-20 | US | Wyoming | Converse | 56009 | 3481 | 56 | 0 | 42.97272268 | -105.5081848 | 2022-09-21 04:23:22 | Converse, Wyoming, US | |
3988572 | 3988572 | 2022-09-15 | US | Missouri | Osage | 29151 | 3481 | 48 | 0 | 38.46036182 | -91.8613635 | 2022-09-16 04:21:19 | Osage, Missouri, US | |
1891089 | 1891089 | 2022-09-14 | US | Missouri | Osage | 29151 | 3481 | 48 | 0 | 38.46036182 | -91.8613635 | 2022-09-15 04:21:02 | Osage, Missouri, US | |
374144 | 374144 | 2022-09-13 | US | Missouri | Osage | 29151 | 3481 | 48 | 0 | 38.46036182 | -91.8613635 | 2022-09-14 04:20:44 | Osage, Missouri, US | |
2396746 | 2396746 | 2022-09-12 | US | Missouri | Osage | 29151 | 3481 | 48 | 0 | 38.46036182 | -91.8613635 | 2022-09-13 04:20:57 | Osage, Missouri, US | |
3767824 | 3767824 | 2022-09-11 | US | Missouri | Osage | 29151 | 3481 | 48 | 0 | 38.46036182 | -91.8613635 | 2022-09-12 04:20:58 | Osage, Missouri, US | |
3826399 | 3826399 | 2022-09-10 | US | Missouri | Osage | 29151 | 3481 | 48 | 0 | 38.46036182 | -91.8613635 | 2022-09-11 04:20:50 | Osage, Missouri, US | |
964856 | 964856 | 2022-09-09 | US | Missouri | Osage | 29151 | 3481 | 48 | 0 | 38.46036182 | -91.8613635 | 2022-09-10 04:21:10 | Osage, Missouri, US | |
117164 | 117164 | 2022-09-06 | US | North Dakota | McKenzie | 38053 | 3481 | 25 | 0 | 47.7413337 | -103.395905 | 2022-09-07 04:20:59 | McKenzie, North Dakota, US | |
1971586 | 1971586 | 2022-08-13 | US | Tennessee | Stewart | 47161 | 3481 | 63 | 0 | 36.50235092 | -87.83920548 | 2022-08-14 04:20:55 | Stewart, Tennessee, US | |
674819 | 674819 | 2022-07-30 | US | Arkansas | Little River | 5081 | 3481 | 106 | 0 | 33.70375665 | -94.23468591 | 2022-07-31 04:21:02 | Little River, Arkansas, US | |
633486 | 633486 | 2022-07-12 | US | Wisconsin | Price | 55099 | 3481 | 34 | 0 | 45.68051754 | -90.3609888 | 2022-07-13 04:20:58 | Price, Wisconsin, US | |
3967774 | 3967774 | 2022-07-05 | US | Iowa | Mills | 19129 | 3481 | 44 | 0 | 41.03299766 | -95.61920963 | 2022-07-06 04:20:58 | Mills, Iowa, US | |
3079285 | 3079285 | 2022-07-04 | US | Iowa | Mills | 19129 | 3481 | 44 | 0 | 41.03299766 | -95.61920963 | 2022-07-05 04:20:45 | Mills, Iowa, US | |
1768567 | 1768567 | 2022-07-03 | US | Iowa | Mills | 19129 | 3481 | 44 | 0 | 41.03299766 | -95.61920963 | 2022-07-04 04:20:54 | Mills, Iowa, US | |
3366553 | 3366553 | 2022-07-02 | US | Iowa | Mills | 19129 | 3481 | 44 | 0 | 41.03299766 | -95.61920963 | 2022-07-03 04:20:59 | Mills, Iowa, US | |
594882 | 594882 | 2022-07-01 | US | Iowa | Mills | 19129 | 3481 | 44 | 0 | 41.03299766 | -95.61920963 | 2022-07-02 04:21:16 | Mills, Iowa, US | |
3941283 | 3941283 | 2022-06-30 | US | Iowa | Mills | 19129 | 3481 | 44 | 0 | 41.03299766 | -95.61920963 | 2022-07-01 04:21:10 | Mills, Iowa, US | |
2491241 | 2491241 | 2022-06-29 | US | Iowa | Mills | 19129 | 3481 | 44 | 0 | 41.03299766 | -95.61920963 | 2022-06-30 04:21:01 | Mills, Iowa, US | |
2240601 | 2240601 | 2022-06-28 | US | Iowa | Harrison | 19085 | 3481 | 95 | 0 | 41.68330137 | -95.81558439 | 2022-06-29 04:20:59 | Harrison, Iowa, US | |
2148843 | 2148843 | 2022-06-27 | US | Iowa | Harrison | 19085 | 3481 | 95 | 0 | 41.68330137 | -95.81558439 | 2022-06-28 04:20:58 | Harrison, Iowa, US | |
476644 | 476644 | 2022-06-26 | US | Iowa | Harrison | 19085 | 3481 | 95 | 0 | 41.68330137 | -95.81558439 | 2022-06-27 04:21:00 | Harrison, Iowa, US | |
940019 | 940019 | 2022-06-25 | US | Iowa | Harrison | 19085 | 3481 | 95 | 0 | 41.68330137 | -95.81558439 | 2022-06-26 04:21:02 | Harrison, Iowa, US | |
3347839 | 3347839 | 2022-06-24 | US | Iowa | Harrison | 19085 | 3481 | 95 | 0 | 41.68330137 | -95.81558439 | 2022-06-25 04:20:57 | Harrison, Iowa, US | |
1649580 | 1649580 | 2022-06-23 | US | Iowa | Harrison | 19085 | 3481 | 95 | 0 | 41.68330137 | -95.81558439 | 2022-06-24 04:20:58 | Harrison, Iowa, US | |
2190589 | 2190589 | 2022-06-22 | US | Tennessee | Meigs | 47121 | 3481 | 59 | 0 | 35.51558739 | -84.81482914 | 2022-06-23 04:20:55 | Meigs, Tennessee, US | |
2188815 | 2188815 | 2022-06-22 | US | Iowa | Harrison | 19085 | 3481 | 95 | 0 | 41.68330137 | -95.81558439 | 2022-06-23 04:20:55 | Harrison, Iowa, US | |
561884 | 561884 | 2022-06-16 | US | Texas | Duval | 48131 | 3481 | 70 | 0 | 27.68184592 | -98.50864568 | 2022-06-17 04:20:56 | Duval, Texas, US | |
3583841 | 3583841 | 2022-05-17 | US | Iowa | Hamilton | 19079 | 3481 | 72 | 0 | 42.38382428 | -93.70197703 | 2022-05-18 04:20:50 | Hamilton, Iowa, US | |
1504798 | 1504798 | 2022-05-16 | US | Iowa | Hamilton | 19079 | 3481 | 72 | 0 | 42.38382428 | -93.70197703 | 2022-05-17 04:20:59 | Hamilton, Iowa, US | |
2085157 | 2085157 | 2022-05-15 | US | Iowa | Hamilton | 19079 | 3481 | 72 | 0 | 42.38382428 | -93.70197703 | 2022-05-16 04:20:47 | Hamilton, Iowa, US | |
3355867 | 3355867 | 2022-05-14 | US | Iowa | Hamilton | 19079 | 3481 | 72 | 0 | 42.38382428 | -93.70197703 | 2022-05-15 04:20:53 | Hamilton, Iowa, US | |
659512 | 659512 | 2022-05-13 | US | Iowa | Hamilton | 19079 | 3481 | 72 | 0 | 42.38382428 | -93.70197703 | 2022-05-14 04:20:48 | Hamilton, Iowa, US | |
2534595 | 2534595 | 2022-05-12 | US | Iowa | Hamilton | 19079 | 3481 | 72 | 0 | 42.38382428 | -93.70197703 | 2022-05-13 04:20:51 | Hamilton, Iowa, US | |
3446041 | 3446041 | 2022-05-11 | US | Iowa | Hamilton | 19079 | 3481 | 72 | 0 | 42.38382428 | -93.70197703 | 2022-05-12 04:20:54 | Hamilton, Iowa, US | |
3538716 | 3538716 | 2022-05-10 | US | Texas | Wilbarger | 48487 | 3481 | 87 | 0 | 34.07945812 | -99.24178437 | 2022-05-11 04:20:48 | Wilbarger, Texas, US | |
225251 | 225251 | 2022-05-09 | US | Texas | Wilbarger | 48487 | 3481 | 87 | 0 | 34.07945812 | -99.24178437 | 2022-05-10 04:20:50 | Wilbarger, Texas, US | |
2334636 | 2334636 | 2022-05-08 | US | Texas | Wilbarger | 48487 | 3481 | 87 | 0 | 34.07945812 | -99.24178437 | 2022-05-09 04:20:54 | Wilbarger, Texas, US | |
363598 | 363598 | 2022-05-07 | US | Texas | Wilbarger | 48487 | 3481 | 87 | 0 | 34.07945812 | -99.24178437 | 2022-05-08 04:20:49 | Wilbarger, Texas, US | |
3266031 | 3266031 | 2022-05-04 | US | Arkansas | Van Buren | 5141 | 3481 | 62 | 0 | 35.58095779 | -92.51295036 | 2022-05-05 04:20:55 | Van Buren, Arkansas, US | |
1572670 | 1572670 | 2022-05-03 | US | Arkansas | Van Buren | 5141 | 3481 | 62 | 0 | 35.58095779 | -92.51295036 | 2022-05-04 04:20:59 | Van Buren, Arkansas, US | |
463930 | 463930 | 2022-05-02 | US | Arkansas | Van Buren | 5141 | 3481 | 62 | 0 | 35.58095779 | -92.51295036 | 2022-05-03 04:21:00 | Van Buren, Arkansas, US | |
3916569 | 3916569 | 2022-05-01 | US | Arkansas | Van Buren | 5141 | 3481 | 62 | 0 | 35.58095779 | -92.51295036 | 2022-05-02 04:21:10 | Van Buren, Arkansas, US | |
2841373 | 2841373 | 2022-04-30 | US | Arkansas | Van Buren | 5141 | 3481 | 62 | 0 | 35.58095779 | -92.51295036 | 2022-05-01 04:20:57 | Van Buren, Arkansas, US | |
1157686 | 1157686 | 2022-04-29 | US | Arkansas | Van Buren | 5141 | 3481 | 62 | 0 | 35.58095779 | -92.51295036 | 2022-04-30 04:21:05 | Van Buren, Arkansas, US | |
1696868 | 1696868 | 2022-04-28 | US | Arkansas | Van Buren | 5141 | 3481 | 62 | 0 | 35.58095779 | -92.51295036 | 2022-04-29 04:20:59 | Van Buren, Arkansas, US | |
2252623 | 2252623 | 2022-04-19 | US | Iowa | Hamilton | 19079 | 3481 | 72 | 0 | 42.38382428 | -93.70197703 | 2022-04-20 04:20:45 | Hamilton, Iowa, US | |
1847173 | 1847173 | 2022-04-18 | US | Iowa | Hamilton | 19079 | 3481 | 72 | 0 | 42.38382428 | -93.70197703 | 2022-04-19 04:21:00 | Hamilton, Iowa, US | |
3418117 | 3418117 | 2022-04-17 | US | Iowa | Hamilton | 19079 | 3481 | 72 | 0 | 42.38382428 | -93.70197703 | 2022-04-18 04:21:12 | Hamilton, Iowa, US | |
305066 | 305066 | 2022-04-16 | US | Iowa | Hamilton | 19079 | 3481 | 72 | 0 | 42.38382428 | -93.70197703 | 2022-04-17 04:20:59 | Hamilton, Iowa, US | |
2671011 | 2671011 | 2022-04-15 | US | Iowa | Hamilton | 19079 | 3481 | 72 | 0 | 42.38382428 | -93.70197703 | 2022-04-16 04:20:48 | Hamilton, Iowa, US | |
1224796 | 1224796 | 2022-04-14 | US | Iowa | Hamilton | 19079 | 3481 | 72 | 0 | 42.38382428 | -93.70197703 | 2022-04-15 04:20:57 | Hamilton, Iowa, US | |
2443954 | 2443954 | 2022-04-13 | US | Iowa | Hamilton | 19079 | 3481 | 72 | 0 | 42.38382428 | -93.70197703 | 2022-04-13 23:21:06 | Hamilton, Iowa, US | |
3869814 | 3869814 | 2022-04-05 | US | New York | Schuyler | 36097 | 3481 | 25 | 0 | 42.39184015 | -76.8773299 | 2022-04-06 04:20:49 | Schuyler, New York, US | |
1471400 | 1471400 | 2022-03-24 | US | Virginia | Alleghany | 51005 | 3481 | 94 | 0 | 37.78636074 | -80.00222498 | 2022-03-25 04:20:46 | Alleghany, Virginia, US | |
1908056 | 1908056 | 2022-03-22 | US | South Dakota | Clay | 46027 | 3481 | 21 | 0 | 42.91296147 | -96.97656917 | 2022-03-23 04:20:48 | Clay, South Dakota, US | |
3241187 | 3241187 | 2022-03-21 | US | South Dakota | Clay | 46027 | 3481 | 21 | 0 | 42.91296147 | -96.97656917 | 2022-03-22 04:20:54 | Clay, South Dakota, US | |
27260 | 27260 | 2022-03-20 | US | South Dakota | Clay | 46027 | 3481 | 21 | 0 | 42.91296147 | -96.97656917 | 2022-03-21 04:20:50 | Clay, South Dakota, US | |
26167 | 26167 | 2022-03-20 | US | Minnesota | Sibley | 27143 | 3481 | 23 | 0 | 44.5796592 | -94.23164924 | 2022-03-21 04:20:50 | Sibley, Minnesota, US | |
1659270 | 1659270 | 2022-03-19 | US | South Dakota | Clay | 46027 | 3481 | 21 | 0 | 42.91296147 | -96.97656917 | 2022-03-20 04:20:45 | Clay, South Dakota, US | |
1658177 | 1658177 | 2022-03-19 | US | Minnesota | Sibley | 27143 | 3481 | 23 | 0 | 44.5796592 | -94.23164924 | 2022-03-20 04:20:45 | Sibley, Minnesota, US | |
338796 | 338796 | 2022-03-18 | US | South Dakota | Clay | 46027 | 3481 | 21 | 0 | 42.91296147 | -96.97656917 | 2022-03-19 04:20:47 | Clay, South Dakota, US | |
337703 | 337703 | 2022-03-18 | US | Minnesota | Sibley | 27143 | 3481 | 23 | 0 | 44.5796592 | -94.23164924 | 2022-03-19 04:20:47 | Sibley, Minnesota, US | |
697249 | 697249 | 2022-03-17 | US | South Dakota | Clay | 46027 | 3481 | 21 | 0 | 42.91296147 | -96.97656917 | 2022-03-18 04:20:55 | Clay, South Dakota, US | |
1548997 | 1548997 | 2022-03-07 | US | Illinois | Menard | 17129 | 3481 | 19 | 0 | 40.02742725 | -89.80246001 | 2022-03-08 04:20:54 | Menard, Illinois, US | |
1994309 | 1994309 | 2022-03-01 | US | Michigan | Kalkaska | 26079 | 3481 | 53 | 0 | 44.68512729 | -85.09085699 | 2022-03-02 04:21:07 | Kalkaska, Michigan, 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]);