johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
205 rows where confirmed = 3345 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- US 194
- China 2
- India 2
- Ethiopia 1
- Liechtenstein 1
- Netherlands 1
- Russia 1
- Spain 1
- Sri Lanka 1
- Thailand 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2182923 | 2182923 | 2022-12-22 | US | Virginia | Falls Church | 51610 | 3345 | 20 | 0 | 38.88485255 | -77.17560759 | 2022-12-23 04:21:04 | Falls Church, Virginia, US | |
3717474 | 3717474 | 2022-12-06 | US | Virginia | Amelia | 51007 | 3345 | 62 | 0 | 37.34081025 | -77.98584649 | 2022-12-07 04:20:58 | Amelia, Virginia, US | |
1623318 | 1623318 | 2022-11-22 | US | Texas | Callahan | 48059 | 3345 | 76 | 0 | 32.29760619 | -99.37326312 | 2022-11-23 04:21:06 | Callahan, Texas, US | |
3463206 | 3463206 | 2022-11-21 | US | Texas | Callahan | 48059 | 3345 | 76 | 0 | 32.29760619 | -99.37326312 | 2022-11-22 04:20:47 | Callahan, Texas, US | |
1643391 | 1643391 | 2022-11-20 | US | Texas | Callahan | 48059 | 3345 | 76 | 0 | 32.29760619 | -99.37326312 | 2022-11-21 04:21:05 | Callahan, Texas, US | |
2066948 | 2066948 | 2022-11-19 | US | Texas | Callahan | 48059 | 3345 | 76 | 0 | 32.29760619 | -99.37326312 | 2022-11-20 04:21:08 | Callahan, Texas, US | |
1758342 | 1758342 | 2022-11-18 | US | Texas | Callahan | 48059 | 3345 | 76 | 0 | 32.29760619 | -99.37326312 | 2022-11-19 04:21:14 | Callahan, Texas, US | |
293270 | 293270 | 2022-11-15 | US | Iowa | Winnebago | 19189 | 3345 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-11-16 04:21:09 | Winnebago, Iowa, US | |
3598300 | 3598300 | 2022-11-14 | US | Iowa | Winnebago | 19189 | 3345 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-11-15 04:21:16 | Winnebago, Iowa, US | |
313158 | 313158 | 2022-11-13 | US | Iowa | Winnebago | 19189 | 3345 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-11-14 04:21:09 | Winnebago, Iowa, US | |
64319 | 64319 | 2022-11-12 | US | Iowa | Winnebago | 19189 | 3345 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-11-13 04:21:14 | Winnebago, Iowa, US | |
2928481 | 2928481 | 2022-11-11 | US | Iowa | Winnebago | 19189 | 3345 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-11-12 04:20:41 | Winnebago, Iowa, US | |
2507317 | 2507317 | 2022-11-10 | US | Iowa | Winnebago | 19189 | 3345 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-11-11 04:21:22 | Winnebago, Iowa, US | |
2432192 | 2432192 | 2022-11-09 | US | Iowa | Winnebago | 19189 | 3345 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-11-10 04:21:16 | Winnebago, Iowa, US | |
1833495 | 1833495 | 2022-10-25 | US | Virginia | Floyd | 51063 | 3345 | 51 | 0 | 36.9302126 | -80.36738849 | 2022-10-26 04:22:19 | Floyd, Virginia, US | |
2161528 | 2161528 | 2022-10-16 | US | Montana | Custer | 30017 | 3345 | 51 | 0 | 46.25319932 | -105.5737526 | 2022-10-17 04:20:31 | Custer, Montana, US | |
517725 | 517725 | 2022-10-15 | US | Montana | Custer | 30017 | 3345 | 51 | 0 | 46.25319932 | -105.5737526 | 2022-10-16 04:22:39 | Custer, Montana, US | |
2034782 | 2034782 | 2022-10-14 | US | Montana | Custer | 30017 | 3345 | 51 | 0 | 46.25319932 | -105.5737526 | 2022-10-15 04:22:00 | Custer, Montana, US | |
3755470 | 3755470 | 2022-10-13 | US | Montana | Custer | 30017 | 3345 | 51 | 0 | 46.25319932 | -105.5737526 | 2022-10-14 04:22:28 | Custer, Montana, US | |
3216295 | 3216295 | 2022-10-12 | US | Montana | Custer | 30017 | 3345 | 51 | 0 | 46.25319932 | -105.5737526 | 2022-10-13 04:22:39 | Custer, Montana, US | |
3252144 | 3252144 | 2022-10-11 | US | Montana | Custer | 30017 | 3345 | 51 | 0 | 46.25319932 | -105.5737526 | 2022-10-12 04:22:51 | Custer, Montana, US | |
3250798 | 3250798 | 2022-10-11 | US | Colorado | Park | 8093 | 3345 | 22 | 0 | 39.120926 | -105.7182065 | 2022-10-12 04:22:51 | Park, Colorado, US | |
2969403 | 2969403 | 2022-10-10 | US | Montana | Custer | 30017 | 3345 | 51 | 0 | 46.25319932 | -105.5737526 | 2022-10-11 04:23:05 | Custer, Montana, US | |
2968057 | 2968057 | 2022-10-10 | US | Colorado | Park | 8093 | 3345 | 22 | 0 | 39.120926 | -105.7182065 | 2022-10-11 04:23:05 | Park, Colorado, US | |
3099439 | 3099439 | 2022-10-09 | US | Montana | Custer | 30017 | 3345 | 51 | 0 | 46.25319932 | -105.5737526 | 2022-10-10 04:22:32 | Custer, Montana, US | |
3098093 | 3098093 | 2022-10-09 | US | Colorado | Park | 8093 | 3345 | 22 | 0 | 39.120926 | -105.7182065 | 2022-10-10 04:22:32 | Park, Colorado, US | |
3098048 | 3098048 | 2022-10-09 | US | Colorado | Archuleta | 8007 | 3345 | 17 | 0 | 37.19474156 | -107.0476867 | 2022-10-10 04:22:32 | Archuleta, Colorado, US | |
4004664 | 4004664 | 2022-10-08 | US | Montana | Custer | 30017 | 3345 | 51 | 0 | 46.25319932 | -105.5737526 | 2022-10-09 04:21:16 | Custer, Montana, US | |
4003318 | 4003318 | 2022-10-08 | US | Colorado | Park | 8093 | 3345 | 22 | 0 | 39.120926 | -105.7182065 | 2022-10-09 04:21:16 | Park, Colorado, US | |
4003273 | 4003273 | 2022-10-08 | US | Colorado | Archuleta | 8007 | 3345 | 17 | 0 | 37.19474156 | -107.0476867 | 2022-10-09 04:21:16 | Archuleta, Colorado, US | |
398261 | 398261 | 2022-10-07 | US | Montana | Custer | 30017 | 3345 | 51 | 0 | 46.25319932 | -105.5737526 | 2022-10-08 04:22:56 | Custer, Montana, US | |
396915 | 396915 | 2022-10-07 | US | Colorado | Park | 8093 | 3345 | 22 | 0 | 39.120926 | -105.7182065 | 2022-10-08 04:22:56 | Park, Colorado, US | |
396870 | 396870 | 2022-10-07 | US | Colorado | Archuleta | 8007 | 3345 | 17 | 0 | 37.19474156 | -107.0476867 | 2022-10-08 04:22:56 | Archuleta, Colorado, US | |
253845 | 253845 | 2022-09-08 | US | Arkansas | Stone | 5137 | 3345 | 69 | 0 | 35.86251946 | -92.15684085 | 2022-09-09 04:21:11 | Stone, Arkansas, US | |
990810 | 990810 | 2022-08-16 | China | Zhejiang | 3345 | 1 | 0 | 29.1832 | 120.0934 | 2022-08-17 04:20:59 | Zhejiang, China | |||
3545055 | 3545055 | 2022-08-08 | US | Maine | Piscataquis | 23021 | 3345 | 34 | 0 | 45.83839062 | -69.2860223 | 2022-08-09 04:20:34 | Piscataquis, Maine, US | |
1071458 | 1071458 | 2022-08-07 | US | Maine | Piscataquis | 23021 | 3345 | 34 | 0 | 45.83839062 | -69.2860223 | 2022-08-08 04:21:08 | Piscataquis, Maine, US | |
1942046 | 1942046 | 2022-08-06 | US | Maine | Piscataquis | 23021 | 3345 | 34 | 0 | 45.83839062 | -69.2860223 | 2022-08-07 04:20:54 | Piscataquis, Maine, US | |
3212135 | 3212135 | 2022-07-18 | US | Mississippi | Tallahatchie | 28135 | 3345 | 60 | 0 | 33.95339918 | -90.1729398 | 2022-07-19 04:20:58 | Tallahatchie, Mississippi, US | |
3407310 | 3407310 | 2022-07-17 | US | Mississippi | Tallahatchie | 28135 | 3345 | 60 | 0 | 33.95339918 | -90.1729398 | 2022-07-18 04:20:59 | Tallahatchie, Mississippi, US | |
2153510 | 2153510 | 2022-07-16 | US | Mississippi | Tallahatchie | 28135 | 3345 | 60 | 0 | 33.95339918 | -90.1729398 | 2022-07-17 04:21:15 | Tallahatchie, Mississippi, US | |
2420743 | 2420743 | 2022-07-15 | US | Mississippi | Tallahatchie | 28135 | 3345 | 60 | 0 | 33.95339918 | -90.1729398 | 2022-07-16 04:21:05 | Tallahatchie, Mississippi, US | |
3430818 | 3430818 | 2022-07-14 | US | Mississippi | Tallahatchie | 28135 | 3345 | 60 | 0 | 33.95339918 | -90.1729398 | 2022-07-15 04:20:53 | Tallahatchie, Mississippi, US | |
3111338 | 3111338 | 2022-07-13 | US | Mississippi | Tallahatchie | 28135 | 3345 | 60 | 0 | 33.95339918 | -90.1729398 | 2022-07-14 04:20:57 | Tallahatchie, Mississippi, US | |
632867 | 632867 | 2022-07-12 | US | Tennessee | Jackson | 47087 | 3345 | 63 | 0 | 36.36380466 | -85.67239905 | 2022-07-13 04:20:58 | Jackson, Tennessee, US | |
631761 | 631761 | 2022-07-12 | US | Mississippi | Tallahatchie | 28135 | 3345 | 60 | 0 | 33.95339918 | -90.1729398 | 2022-07-13 04:20:58 | Tallahatchie, Mississippi, US | |
1213405 | 1213405 | 2022-07-11 | US | Mississippi | Tallahatchie | 28135 | 3345 | 60 | 0 | 33.95339918 | -90.1729398 | 2022-07-12 04:20:51 | Tallahatchie, Mississippi, US | |
3077867 | 3077867 | 2022-07-04 | China | Shaanxi | 3345 | 3 | 0 | 35.1917 | 108.8701 | 2022-07-05 04:20:45 | Shaanxi, China | |||
3984811 | 3984811 | 2022-06-15 | US | New Mexico | Los Alamos | 35028 | 3345 | 16 | 0 | 35.86631386 | -106.3134985 | 2022-06-16 04:20:55 | Los Alamos, New Mexico, US | |
2982028 | 2982028 | 2022-06-13 | US | Puerto Rico | Patillas | 72109 | 3345 | 0 | 0 | 18.03174 | -66.012242 | 2022-06-14 04:20:52 | Patillas, Puerto Rico, US | |
1506368 | 1506368 | 2022-05-16 | US | Puerto Rico | Orocovis | 72107 | 3345 | 0 | 0 | 18.215046 | -66.433604 | 2022-05-17 04:20:59 | Orocovis, Puerto Rico, US | |
2309722 | 2309722 | 2022-04-20 | US | North Dakota | Walsh | 38099 | 3345 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-04-21 04:20:46 | Walsh, North Dakota, US | |
1849387 | 1849387 | 2022-04-18 | US | Virginia | Southampton | 51175 | 3345 | 91 | 0 | 36.72231125 | -77.10642712 | 2022-04-19 04:21:00 | Southampton, Virginia, US | |
2446130 | 2446130 | 2022-04-13 | US | Virginia | Martinsville | 51690 | 3345 | 117 | 0 | 36.68212094 | -79.86352771 | 2022-04-13 23:21:06 | Martinsville, Virginia, US | |
1949736 | 1949736 | 2022-04-12 | US | Iowa | Mills | 19129 | 3345 | 41 | 0 | 41.03299766 | -95.61920963 | 2022-04-13 04:21:03 | Mills, Iowa, US | |
3207489 | 3207489 | 2022-04-11 | US | Iowa | Mills | 19129 | 3345 | 41 | 0 | 41.03299766 | -95.61920963 | 2022-04-12 04:20:49 | Mills, Iowa, US | |
1577375 | 1577375 | 2022-04-10 | US | Iowa | Mills | 19129 | 3345 | 41 | 0 | 41.03299766 | -95.61920963 | 2022-04-11 04:21:02 | Mills, Iowa, US | |
1653617 | 1653617 | 2022-04-09 | US | Iowa | Mills | 19129 | 3345 | 41 | 0 | 41.03299766 | -95.61920963 | 2022-04-10 04:20:52 | Mills, Iowa, US | |
2116939 | 2116939 | 2022-04-08 | US | Iowa | Mills | 19129 | 3345 | 41 | 0 | 41.03299766 | -95.61920963 | 2022-04-09 04:20:42 | Mills, Iowa, US | |
3321463 | 3321463 | 2022-04-07 | US | Iowa | Mills | 19129 | 3345 | 41 | 0 | 41.03299766 | -95.61920963 | 2022-04-08 04:20:48 | Mills, Iowa, US | |
2801999 | 2801999 | 2022-04-06 | US | Iowa | Mills | 19129 | 3345 | 41 | 0 | 41.03299766 | -95.61920963 | 2022-04-07 04:20:53 | Mills, Iowa, US | |
1542065 | 1542065 | 2022-03-31 | US | Nebraska | Otoe | 31131 | 3345 | 10 | 0 | 40.64843556 | -96.13374142 | 2022-04-01 04:20:28 | Otoe, Nebraska, US | |
2480078 | 2480078 | 2022-03-30 | US | Nebraska | Otoe | 31131 | 3345 | 10 | 0 | 40.64843556 | -96.13374142 | 2022-03-31 04:20:56 | Otoe, Nebraska, US | |
1723201 | 1723201 | 2022-03-25 | US | Puerto Rico | Aibonito | 72009 | 3345 | 0 | 0 | 18.131361 | -66.264131 | 2022-03-26 04:20:23 | Aibonito, Puerto Rico, US | |
3628569 | 3628569 | 2022-03-13 | US | Colorado | Crowley | 8025 | 3345 | 30 | 0 | 38.32608609 | -103.7844965 | 2022-03-14 04:20:46 | Crowley, Colorado, US | |
951477 | 951477 | 2022-03-12 | US | Colorado | Crowley | 8025 | 3345 | 30 | 0 | 38.32608609 | -103.7844965 | 2022-03-13 04:20:49 | Crowley, Colorado, US | |
356938 | 356938 | 2022-03-11 | US | Colorado | Crowley | 8025 | 3345 | 30 | 0 | 38.32608609 | -103.7844965 | 2022-03-12 04:20:50 | Crowley, Colorado, US | |
1866090 | 1866090 | 2022-03-10 | US | Colorado | Crowley | 8025 | 3345 | 30 | 0 | 38.32608609 | -103.7844965 | 2022-03-11 04:20:50 | Crowley, Colorado, US | |
2140785 | 2140785 | 2022-03-09 | US | Colorado | Crowley | 8025 | 3345 | 30 | 0 | 38.32608609 | -103.7844965 | 2022-03-10 04:20:48 | Crowley, Colorado, US | |
3075798 | 3075798 | 2022-02-09 | US | Minnesota | Pennington | 27113 | 3345 | 37 | 0 | 48.06642577 | -96.0370814 | 2022-02-10 04:21:14 | Pennington, Minnesota, US | |
74671 | 74671 | 2022-02-07 | US | Wisconsin | Rusk | 55107 | 3345 | 47 | 0 | 45.47498854 | -91.1333012 | 2022-02-08 04:21:15 | Rusk, Wisconsin, US | |
981913 | 981913 | 2022-02-01 | US | Tennessee | Lewis | 47101 | 3345 | 50 | 0 | 35.52853208 | -87.49022694 | 2022-02-02 04:21:09 | Lewis, Tennessee, US | |
1780531 | 1780531 | 2022-01-27 | US | Indiana | Tipton | 18159 | 3345 | 77 | 0 | 40.31123252 | -86.05234925 | 2022-01-28 04:21:09 | Tipton, Indiana, US | |
2052293 | 2052293 | 2022-01-25 | US | Alabama | Washington | 1129 | 3345 | 53 | 0 | 31.4092794 | -88.20689944 | 2022-01-26 04:21:07 | Washington, Alabama, US | |
1229797 | 1229797 | 2022-01-24 | US | New Jersey | Unassigned | 90034 | 3345 | 0 | 0 | 41.13891592 | 0.0 | 2022-01-25 04:21:05 | Unassigned, New Jersey, US | |
1229510 | 1229510 | 2022-01-24 | US | Missouri | Dallas | 29059 | 3345 | 64 | 0 | 37.681135499999996 | -93.02127031 | 2022-01-25 04:21:05 | Dallas, Missouri, US | |
1475280 | 1475280 | 2022-01-17 | US | Texas | Madison | 48313 | 3345 | 48 | 0 | 30.96694679 | -95.93003775 | 2022-01-18 04:21:04 | Madison, Texas, US | |
100024 | 100024 | 2022-01-14 | US | Florida | Gilchrist | 12041 | 3345 | 70 | 0 | 29.72856978 | -82.79880657 | 2022-01-15 04:21:07 | Gilchrist, Florida, US | |
3688179 | 3688179 | 2022-01-13 | US | Florida | Gilchrist | 12041 | 3345 | 70 | 0 | 29.72856978 | -82.79880657 | 2022-01-14 04:21:54 | Gilchrist, Florida, US | |
3613763 | 3613763 | 2022-01-12 | US | Florida | Gilchrist | 12041 | 3345 | 70 | 0 | 29.72856978 | -82.79880657 | 2022-01-13 08:00:09 | Gilchrist, Florida, US | |
1114288 | 1114288 | 2022-01-11 | US | Florida | Gilchrist | 12041 | 3345 | 44 | 0 | 29.72856978 | -82.79880657 | 2022-01-12 04:21:44 | Gilchrist, Florida, US | |
1693297 | 1693297 | 2022-01-10 | US | Illinois | De Witt | 17039 | 3345 | 33 | 0 | 40.17514519 | -88.90959682 | 2022-01-11 04:22:01 | De Witt, Illinois, US | |
1693016 | 1693016 | 2022-01-10 | US | Florida | Gilchrist | 12041 | 3345 | 44 | 0 | 29.72856978 | -82.79880657 | 2022-01-11 04:22:01 | Gilchrist, Florida, US | |
127431 | 127431 | 2022-01-09 | US | Florida | Gilchrist | 12041 | 3345 | 44 | 0 | 29.72856978 | -82.79880657 | 2022-01-10 04:22:07 | Gilchrist, Florida, US | |
1216266 | 1216266 | 2022-01-08 | US | Florida | Gilchrist | 12041 | 3345 | 44 | 0 | 29.72856978 | -82.79880657 | 2022-01-09 04:21:46 | Gilchrist, Florida, US | |
1390359 | 1390359 | 2022-01-07 | US | Florida | Gilchrist | 12041 | 3345 | 44 | 0 | 29.72856978 | -82.79880657 | 2022-01-08 04:21:53 | Gilchrist, Florida, US | |
3521229 | 3521229 | 2022-01-02 | US | Mississippi | Clay | 28025 | 3345 | 78 | 0 | 33.65358105 | -88.77784255 | 2022-01-03 02:22:25 | Clay, Mississippi, US | |
2169359 | 2169359 | 2022-01-01 | US | Mississippi | Clay | 28025 | 3345 | 78 | 0 | 33.65358105 | -88.77784255 | 2022-01-02 04:20:52 | Clay, Mississippi, US | |
2778790 | 2778790 | 2021-12-31 | US | Mississippi | Clay | 28025 | 3345 | 78 | 0 | 33.65358105 | -88.77784255 | 2022-01-01 04:22:14 | Clay, Mississippi, US | |
4001830 | 4001830 | 2021-12-30 | US | Texas | Montague | 48337 | 3345 | 99 | 0 | 33.67521893 | -97.72500958 | 2021-12-31 04:21:50 | Montague, Texas, US | |
4000447 | 4000447 | 2021-12-30 | US | Mississippi | Clay | 28025 | 3345 | 78 | 0 | 33.65358105 | -88.77784255 | 2021-12-31 04:21:50 | Clay, Mississippi, US | |
1671210 | 1671210 | 2021-12-29 | US | Puerto Rico | Juncos | 72077 | 3345 | 0 | 0 | 18.223793 | -65.909109 | 2021-12-30 04:21:25 | Juncos, Puerto Rico, US | |
1668921 | 1668921 | 2021-12-29 | US | Arkansas | Ashley | 5003 | 3345 | 55 | 0 | 33.19153461 | -91.76984709999999 | 2021-12-30 04:21:25 | Ashley, Arkansas, US | |
1434697 | 1434697 | 2021-12-28 | US | Nebraska | Washington | 31177 | 3345 | 25 | 0 | 41.52815707 | -96.22019892 | 2021-12-29 03:21:43 | Washington, Nebraska, US | |
2113172 | 2113172 | 2021-12-26 | US | Kentucky | Spencer | 21215 | 3345 | 43 | 0 | 38.03223971 | -85.32749335 | 2021-12-27 04:21:58 | Spencer, Kentucky, US | |
3606544 | 3606544 | 2021-12-25 | US | Kentucky | Spencer | 21215 | 3345 | 43 | 0 | 38.03223971 | -85.32749335 | 2021-12-26 04:21:50 | Spencer, Kentucky, US | |
2964862 | 2964862 | 2021-12-24 | US | Kentucky | Spencer | 21215 | 3345 | 43 | 0 | 38.03223971 | -85.32749335 | 2021-12-25 04:21:37 | Spencer, Kentucky, US | |
2963933 | 2963933 | 2021-12-24 | US | California | Colusa | 6011 | 3345 | 21 | 0 | 39.17881957 | -122.2331726 | 2021-12-25 04:21:37 | Colusa, California, US | |
3817894 | 3817894 | 2021-12-23 | US | Kentucky | Spencer | 21215 | 3345 | 43 | 0 | 38.03223971 | -85.32749335 | 2021-12-24 04:21:34 | Spencer, Kentucky, US | |
799902 | 799902 | 2021-12-22 | US | Kentucky | Spencer | 21215 | 3345 | 43 | 0 | 38.03223971 | -85.32749335 | 2021-12-23 04:21:21 | Spencer, Kentucky, 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]);