johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
91 rows where confirmed = 7983 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 82
- Russia 2
- Andorra 1
- Brazil 1
- Italy 1
- Mali 1
- Mozambique 1
- Ukraine 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
869349 | 869349 | 2022-12-11 | US | California | Del Norte | 6015 | 7983 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-12 04:21:01 | Del Norte, California, US | |
257879 | 257879 | 2022-12-10 | US | California | Del Norte | 6015 | 7983 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-11 04:20:50 | Del Norte, California, US | |
3936593 | 3936593 | 2022-12-09 | US | California | Del Norte | 6015 | 7983 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-10 04:21:02 | Del Norte, California, US | |
3377925 | 3377925 | 2022-12-08 | US | California | Del Norte | 6015 | 7983 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-09 04:21:05 | Del Norte, California, US | |
1985196 | 1985196 | 2022-12-07 | US | California | Del Norte | 6015 | 7983 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-08 04:21:07 | Del Norte, California, US | |
3714719 | 3714719 | 2022-12-06 | US | California | Del Norte | 6015 | 7983 | 56 | 0 | 41.74228275 | -123.8974063 | 2022-12-07 04:20:58 | Del Norte, California, US | |
1889502 | 1889502 | 2022-09-14 | US | Alabama | Clarke | 1025 | 7983 | 104 | 0 | 31.68099859 | -87.83548597 | 2022-09-15 04:21:02 | Clarke, Alabama, US | |
372557 | 372557 | 2022-09-13 | US | Alabama | Clarke | 1025 | 7983 | 104 | 0 | 31.68099859 | -87.83548597 | 2022-09-14 04:20:44 | Clarke, Alabama, US | |
2396498 | 2396498 | 2022-09-12 | US | Michigan | Wexford | 26165 | 7983 | 119 | 0 | 44.33853602 | -85.57712739 | 2022-09-13 04:20:57 | Wexford, Michigan, US | |
2395159 | 2395159 | 2022-09-12 | US | Alabama | Clarke | 1025 | 7983 | 104 | 0 | 31.68099859 | -87.83548597 | 2022-09-13 04:20:57 | Clarke, Alabama, US | |
3767576 | 3767576 | 2022-09-11 | US | Michigan | Wexford | 26165 | 7983 | 119 | 0 | 44.33853602 | -85.57712739 | 2022-09-12 04:20:58 | Wexford, Michigan, US | |
3766237 | 3766237 | 2022-09-11 | US | Alabama | Clarke | 1025 | 7983 | 104 | 0 | 31.68099859 | -87.83548597 | 2022-09-12 04:20:58 | Clarke, Alabama, US | |
3826151 | 3826151 | 2022-09-10 | US | Michigan | Wexford | 26165 | 7983 | 119 | 0 | 44.33853602 | -85.57712739 | 2022-09-11 04:20:50 | Wexford, Michigan, US | |
3824812 | 3824812 | 2022-09-10 | US | Alabama | Clarke | 1025 | 7983 | 104 | 0 | 31.68099859 | -87.83548597 | 2022-09-11 04:20:50 | Clarke, Alabama, US | |
964608 | 964608 | 2022-09-09 | US | Michigan | Wexford | 26165 | 7983 | 119 | 0 | 44.33853602 | -85.57712739 | 2022-09-10 04:21:10 | Wexford, Michigan, US | |
963269 | 963269 | 2022-09-09 | US | Alabama | Clarke | 1025 | 7983 | 104 | 0 | 31.68099859 | -87.83548597 | 2022-09-10 04:21:10 | Clarke, Alabama, US | |
255010 | 255010 | 2022-09-08 | US | Michigan | Wexford | 26165 | 7983 | 119 | 0 | 44.33853602 | -85.57712739 | 2022-09-09 04:21:11 | Wexford, Michigan, US | |
253671 | 253671 | 2022-09-08 | US | Alabama | Clarke | 1025 | 7983 | 104 | 0 | 31.68099859 | -87.83548597 | 2022-09-09 04:21:11 | Clarke, Alabama, US | |
3746808 | 3746808 | 2022-09-07 | US | Michigan | Wexford | 26165 | 7983 | 119 | 0 | 44.33853602 | -85.57712739 | 2022-09-08 04:21:02 | Wexford, Michigan, US | |
116448 | 116448 | 2022-09-06 | US | Michigan | Wexford | 26165 | 7983 | 119 | 0 | 44.33853602 | -85.57712739 | 2022-09-07 04:20:59 | Wexford, Michigan, US | |
1683226 | 1683226 | 2022-08-29 | US | Puerto Rico | Barranquitas | 72019 | 7983 | 0 | 0 | 18.201592 | -66.30963 | 2022-08-30 04:21:03 | Barranquitas, Puerto Rico, US | |
1100911 | 1100911 | 2022-08-03 | US | Puerto Rico | Yabucoa | 72151 | 7983 | 0 | 0 | 18.070399 | -65.896289 | 2022-08-04 04:20:58 | Yabucoa, Puerto Rico, US | |
3407648 | 3407648 | 2022-07-17 | US | New Mexico | Cibola | 35006 | 7983 | 199 | 0 | 34.91131525 | -107.998876 | 2022-07-18 04:20:59 | Cibola, New Mexico, US | |
2153848 | 2153848 | 2022-07-16 | US | New Mexico | Cibola | 35006 | 7983 | 199 | 0 | 34.91131525 | -107.998876 | 2022-07-17 04:21:15 | Cibola, New Mexico, US | |
2421081 | 2421081 | 2022-07-15 | US | New Mexico | Cibola | 35006 | 7983 | 199 | 0 | 34.91131525 | -107.998876 | 2022-07-16 04:21:05 | Cibola, New Mexico, US | |
2792571 | 2792571 | 2022-07-10 | US | Wisconsin | Clark | 55019 | 7983 | 122 | 0 | 44.73483377 | -90.61207486 | 2022-07-11 04:20:46 | Clark, Wisconsin, US | |
145524 | 145524 | 2022-07-09 | US | Wisconsin | Clark | 55019 | 7983 | 122 | 0 | 44.73483377 | -90.61207486 | 2022-07-10 04:20:54 | Clark, Wisconsin, US | |
1420624 | 1420624 | 2022-07-08 | US | Wisconsin | Clark | 55019 | 7983 | 122 | 0 | 44.73483377 | -90.61207486 | 2022-07-09 04:20:59 | Clark, Wisconsin, US | |
659871 | 659871 | 2022-05-13 | US | Maine | Hancock | 23009 | 7983 | 87 | 0 | 44.59816444 | -68.38401854 | 2022-05-14 04:20:48 | Hancock, Maine, US | |
225043 | 225043 | 2022-05-09 | US | Texas | Cherokee | 48073 | 7983 | 254 | 0 | 31.837258 | -95.16559897 | 2022-05-10 04:20:50 | Cherokee, Texas, US | |
3868787 | 3868787 | 2022-04-05 | US | Iowa | Sioux | 19167 | 7983 | 86 | 0 | 43.08221074 | -96.17675679999999 | 2022-04-06 04:20:49 | Sioux, Iowa, US | |
2750129 | 2750129 | 2022-04-04 | US | Iowa | Sioux | 19167 | 7983 | 86 | 0 | 43.08221074 | -96.17675679999999 | 2022-04-05 04:20:48 | Sioux, Iowa, US | |
3731475 | 3731475 | 2022-04-03 | US | Iowa | Sioux | 19167 | 7983 | 86 | 0 | 43.08221074 | -96.17675679999999 | 2022-04-04 04:20:51 | Sioux, Iowa, US | |
500910 | 500910 | 2022-04-02 | US | Iowa | Sioux | 19167 | 7983 | 86 | 0 | 43.08221074 | -96.17675679999999 | 2022-04-03 04:20:48 | Sioux, Iowa, US | |
3351895 | 3351895 | 2022-04-01 | US | Iowa | Sioux | 19167 | 7983 | 86 | 0 | 43.08221074 | -96.17675679999999 | 2022-04-02 04:20:47 | Sioux, Iowa, US | |
1541200 | 1541200 | 2022-03-31 | US | Iowa | Sioux | 19167 | 7983 | 86 | 0 | 43.08221074 | -96.17675679999999 | 2022-04-01 04:20:28 | Sioux, Iowa, US | |
2479213 | 2479213 | 2022-03-30 | US | Iowa | Sioux | 19167 | 7983 | 86 | 0 | 43.08221074 | -96.17675679999999 | 2022-03-31 04:20:56 | Sioux, Iowa, US | |
264794 | 264794 | 2022-03-15 | US | Texas | Wood | 48499 | 7983 | 280 | 0 | 32.78722382 | -95.38236368 | 2022-03-16 04:20:50 | Wood, Texas, US | |
2267153 | 2267153 | 2022-03-14 | US | Texas | Wood | 48499 | 7983 | 280 | 0 | 32.78722382 | -95.38236368 | 2022-03-15 04:20:47 | Wood, Texas, US | |
1644753 | 1644753 | 2022-03-03 | US | Alabama | Marion | 1093 | 7983 | 144 | 0 | 34.13697363 | -87.88704173 | 2022-03-04 04:21:09 | Marion, Alabama, US | |
1059801 | 1059801 | 2022-02-23 | US | Missouri | Polk | 29167 | 7983 | 96 | 0 | 37.616229600000004 | -93.39828174 | 2022-02-24 04:21:14 | Polk, Missouri, US | |
1059716 | 1059716 | 2022-02-23 | US | Mississippi | Yazoo | 28163 | 7983 | 102 | 0 | 32.77890365 | -90.39656148 | 2022-02-24 04:21:14 | Yazoo, Mississippi, US | |
236411 | 236411 | 2022-02-11 | US | Texas | Matagorda | 48321 | 7983 | 171 | 0 | 28.81955746 | -96.01230294 | 2022-02-12 04:21:06 | Matagorda, Texas, US | |
1296696 | 1296696 | 2022-02-05 | US | Pennsylvania | Clarion | 42031 | 7983 | 190 | 0 | 41.19265812 | -79.42413524 | 2022-02-06 04:21:00 | Clarion, Pennsylvania, US | |
3303177 | 3303177 | 2022-01-30 | US | Tennessee | Marion | 47115 | 7983 | 116 | 0 | 35.12997174 | -85.62265895 | 2022-01-31 04:21:09 | Marion, Tennessee, US | |
1433992 | 1433992 | 2021-12-28 | US | Kentucky | Knox | 21121 | 7983 | 106 | 0 | 36.89225732 | -83.85403396 | 2021-12-29 03:21:43 | Knox, Kentucky, US | |
2904713 | 2904713 | 2021-12-19 | US | Illinois | Henry | 17073 | 7983 | 87 | 0 | 41.3533994 | -90.13296166 | 2021-12-20 04:21:43 | Henry, Illinois, US | |
1259786 | 1259786 | 2021-12-18 | US | Illinois | Henry | 17073 | 7983 | 87 | 0 | 41.3533994 | -90.13296166 | 2021-12-19 04:21:11 | Henry, Illinois, US | |
2399814 | 2399814 | 2021-12-17 | US | Illinois | Henry | 17073 | 7983 | 87 | 0 | 41.3533994 | -90.13296166 | 2021-12-18 02:22:20 | Henry, Illinois, US | |
1323262 | 1323262 | 2021-11-14 | US | Illinois | Ogle | 17141 | 7983 | 94 | 0 | 42.04165196 | -89.32184679 | 2021-11-15 04:21:36 | Ogle, Illinois, US | |
687388 | 687388 | 2021-11-13 | US | Illinois | Ogle | 17141 | 7983 | 94 | 0 | 42.04165196 | -89.32184679 | 2021-11-14 04:21:31 | Ogle, Illinois, US | |
715497 | 715497 | 2021-11-12 | US | Illinois | Ogle | 17141 | 7983 | 94 | 0 | 42.04165196 | -89.32184679 | 2021-11-13 04:21:38 | Ogle, Illinois, US | |
2002977 | 2002977 | 2021-11-07 | US | North Carolina | Edgecombe | 37065 | 7983 | 126 | 0 | 35.91230639 | -77.59436892 | 2021-11-08 04:21:43 | Edgecombe, North Carolina, US | |
2002207 | 2002207 | 2021-11-07 | US | Louisiana | Washington | 22117 | 7983 | 215 | 0 | 30.85288548 | -90.03866652 | 2021-11-08 04:21:43 | Washington, Louisiana, US | |
497968 | 497968 | 2021-11-06 | US | North Carolina | Edgecombe | 37065 | 7983 | 126 | 0 | 35.91230639 | -77.59436892 | 2021-11-07 04:21:53 | Edgecombe, North Carolina, US | |
497198 | 497198 | 2021-11-06 | US | Louisiana | Washington | 22117 | 7983 | 215 | 0 | 30.85288548 | -90.03866652 | 2021-11-07 04:21:53 | Washington, Louisiana, US | |
3123823 | 3123823 | 2021-11-05 | US | North Carolina | Edgecombe | 37065 | 7983 | 126 | 0 | 35.91230639 | -77.59436892 | 2021-11-06 04:21:51 | Edgecombe, North Carolina, US | |
3123053 | 3123053 | 2021-11-05 | US | Louisiana | Washington | 22117 | 7983 | 215 | 0 | 30.85288548 | -90.03866652 | 2021-11-06 04:21:51 | Washington, Louisiana, US | |
537398 | 537398 | 2021-10-27 | US | Pennsylvania | Columbia | 42037 | 7983 | 153 | 0 | 41.04821986 | -76.40565017 | 2021-10-28 04:22:08 | Columbia, Pennsylvania, US | |
1888401 | 1888401 | 2021-09-12 | US | Virginia | Rockingham | 51165 | 7983 | 117 | 0 | 38.51006137 | -78.87260325 | 2021-09-13 04:21:15 | Rockingham, Virginia, US | |
3809304 | 3809304 | 2021-09-11 | US | Virginia | Rockingham | 51165 | 7983 | 117 | 0 | 38.51006137 | -78.87260325 | 2021-09-12 04:21:13 | Rockingham, Virginia, US | |
3452244 | 3452244 | 2021-09-10 | US | Virginia | Rockingham | 51165 | 7983 | 117 | 0 | 38.51006137 | -78.87260325 | 2021-09-11 04:21:30 | Rockingham, Virginia, US | |
2794418 | 2794418 | 2021-08-28 | US | Kentucky | Christian | 21047 | 7983 | 108 | 0 | 36.89267803 | -87.49055367 | 2021-08-29 04:21:14 | Christian, Kentucky, US | |
2926161 | 2926161 | 2021-08-27 | US | Tennessee | McMinn | 47107 | 7983 | 110 | 0 | 35.42812616 | -84.61520715 | 2021-08-28 04:21:28 | McMinn, Tennessee, US | |
411987 | 411987 | 2021-07-28 | United Kingdom | Jersey | 7983 | 69 | 0 | 0 | 49.2138 | -2.1358 | 2021-07-29 04:21:33 | Jersey, United Kingdom | ||
2372659 | 2372659 | 2021-07-20 | US | Indiana | Warrick | 18173 | 7983 | 157 | 0 | 38.08922676 | -87.2716085 | 2021-07-21 04:21:40 | Warrick, Indiana, US | |
3475233 | 3475233 | 2021-06-08 | US | Tennessee | Greene | 47059 | 7983 | 158 | 0 | 36.17470125 | -82.84691273 | 2021-06-09 04:23:31 | Greene, Tennessee, US | |
1415414 | 1415414 | 2021-05-24 | US | North Carolina | Sampson | 37163 | 7983 | 112 | 0 | 34.98820368 | -78.36914061 | 2021-05-25 04:21:08 | Sampson, North Carolina, US | |
1771760 | 1771760 | 2021-05-23 | US | Alaska | Fairbanks North Star | 2090 | 7983 | 43 | 0 | 64.80726247 | -146.5692662 | 2021-05-24 04:20:53 | Fairbanks North Star, Alaska, US | |
726915 | 726915 | 2021-05-22 | US | Alaska | Fairbanks North Star | 2090 | 7983 | 43 | 0 | 64.80726247 | -146.5692662 | 2021-05-23 04:20:51 | Fairbanks North Star, Alaska, US | |
1952930 | 1952930 | 2021-05-21 | US | Alaska | Fairbanks North Star | 2090 | 7983 | 43 | 0 | 64.80726247 | -146.5692662 | 2021-05-22 04:20:45 | Fairbanks North Star, Alaska, US | |
3114013 | 3114013 | 2021-05-06 | US | Arkansas | White | 5145 | 7983 | 118 | 0 | 35.25688493 | -91.74908296 | 2021-05-07 04:20:40 | White, Arkansas, US | |
383537 | 383537 | 2021-04-30 | US | Virginia | Hanover | 51085 | 7983 | 154 | 0 | 37.7583355 | -77.49464673 | 2021-05-01 04:20:47 | Hanover, Virginia, US | |
3395096 | 3395096 | 2021-04-28 | US | Minnesota | Clay | 27027 | 7983 | 91 | 0 | 46.89289518 | -96.48761922 | 2021-04-29 04:20:55 | Clay, Minnesota, US | |
2411645 | 2411645 | 2021-04-19 | US | Georgia | Glynn | 13127 | 7983 | 171 | 0 | 31.23279254 | -81.53811412 | 2021-04-20 04:20:41 | Glynn, Georgia, US | |
1842642 | 1842642 | 2021-04-14 | US | Florida | Highlands | 12055 | 7983 | 331 | 0 | 27.34254618 | -81.34071957 | 2021-04-15 04:20:54 | Highlands, Florida, US | |
57387 | 57387 | 2021-03-07 | US | Oklahoma | Pottawatomie | 40125 | 7983 | 79 | 0 | 35.20614018 | -96.94923008 | 2021-03-08 05:24:48 | Pottawatomie, Oklahoma, US | |
2680198 | 2680198 | 2021-02-13 | US | North Carolina | Wilson | 37195 | 7983 | 141 | 0 | 7842 | 35.70625477 | -77.917978 | 2021-02-14 05:23:43 | Wilson, North Carolina, US |
1759365 | 1759365 | 2021-01-24 | Mali | 7983 | 323 | 5717 | 1943 | 17.570692 | -3.996166000000001 | 2021-01-25 05:22:16 | Mali | |||
1138055 | 1138055 | 2021-01-01 | US | Iowa | Dallas | 19049 | 7983 | 66 | 0 | 7917 | 41.68560356 | -94.04127625 | 2021-01-02 05:22:33 | Dallas, Iowa, US |
1009997 | 1009997 | 2020-12-30 | Andorra | 7983 | 84 | 7384 | 515 | 42.5063 | 1.5218 | 2020-12-31 05:22:49 | Andorra | |||
3780333 | 3780333 | 2020-12-27 | US | Ohio | Allen | 39003 | 7983 | 170 | 0 | 7813 | 40.77285242 | -84.10802343 | 2020-12-28 05:22:06 | Allen, Ohio, US |
1178257 | 1178257 | 2020-10-22 | US | Georgia | Clayton | 13063 | 7983 | 175 | 0 | 7808 | 33.54187245 | -84.35594188 | 2020-10-23 04:24:46 | Clayton, Georgia, US |
2858997 | 2858997 | 2020-10-16 | US | New Jersey | Burlington | 34005 | 7983 | 505 | 0 | 7478 | 39.87681124 | -74.66927768 | 2020-10-17 04:24:12 | Burlington, New Jersey, US |
790004 | 790004 | 2020-10-15 | Ukraine | Sumy Oblast | 7983 | 104 | 2562 | 5317 | 50.9077 | 34.7981 | 2020-10-16 04:24:01 | Sumy Oblast, Ukraine | ||
2379617 | 2379617 | 2020-10-01 | Italy | Marche | 7983 | 990 | 6180 | 813 | 43.61675973 | 13.5188753 | 2020-10-02 04:23:51 | Marche, Italy | ||
2582092 | 2582092 | 2020-09-27 | Mozambique | 7983 | 58 | 4807 | 3118 | -18.665695 | 35.529562 | 2020-09-28 04:23:00 | Mozambique | |||
2852078 | 2852078 | 2020-09-18 | US | Texas | Williamson | 48491 | 7983 | 139 | 0 | 8246 | 30.64655664 | -97.6004854 | 2020-09-19 04:22:00 | Williamson, Texas, US |
427527 | 427527 | 2020-09-07 | Russia | Chuvashia Republic | 7983 | 73 | 6604 | 1306 | 55.4259922 | 47.0849429 | 2020-09-08 04:28:25 | Chuvashia Republic, Russia | ||
1105785 | 1105785 | 2020-09-02 | Russia | Perm Krai | 7983 | 215 | 5580 | 2188 | 58.5951603 | 56.3159546 | 2020-09-03 04:28:22 | Perm Krai, Russia | ||
2799775 | 2799775 | 2020-06-07 | Brazil | Acre | 7983 | 207 | 0 | 7776 | -9.0238 | -70.812 | 2020-06-08 03:33:22 | Acre, Brazil |
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]);