johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
313 rows where confirmed = 1978 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1150894 | 1150894 | 2022-12-12 | US | Missouri | Ozark | 29153 | 1978 | 64 | 0 | 36.64916339 | -92.44459066 | 2022-12-13 04:21:01 | Ozark, Missouri, US | |
870748 | 870748 | 2022-12-11 | US | Missouri | Ozark | 29153 | 1978 | 64 | 0 | 36.64916339 | -92.44459066 | 2022-12-12 04:21:01 | Ozark, Missouri, US | |
259278 | 259278 | 2022-12-10 | US | Missouri | Ozark | 29153 | 1978 | 64 | 0 | 36.64916339 | -92.44459066 | 2022-12-11 04:20:50 | Ozark, Missouri, US | |
3937992 | 3937992 | 2022-12-09 | US | Missouri | Ozark | 29153 | 1978 | 64 | 0 | 36.64916339 | -92.44459066 | 2022-12-10 04:21:02 | Ozark, Missouri, US | |
3379324 | 3379324 | 2022-12-08 | US | Missouri | Ozark | 29153 | 1978 | 64 | 0 | 36.64916339 | -92.44459066 | 2022-12-09 04:21:05 | Ozark, Missouri, US | |
1986595 | 1986595 | 2022-12-07 | US | Missouri | Ozark | 29153 | 1978 | 64 | 0 | 36.64916339 | -92.44459066 | 2022-12-08 04:21:07 | Ozark, Missouri, US | |
3716118 | 3716118 | 2022-12-06 | US | Missouri | Ozark | 29153 | 1978 | 64 | 0 | 36.64916339 | -92.44459066 | 2022-12-07 04:20:58 | Ozark, Missouri, US | |
3756549 | 3756549 | 2022-10-13 | US | Texas | Delta | 48119 | 1978 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-10-14 04:22:28 | Delta, Texas, US | |
3217374 | 3217374 | 2022-10-12 | US | Texas | Delta | 48119 | 1978 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-10-13 04:22:39 | Delta, Texas, US | |
1101326 | 1101326 | 2022-08-03 | US | Texas | Refugio | 48391 | 1978 | 38 | 0 | 28.3238976 | -97.15766311 | 2022-08-04 04:20:58 | Refugio, Texas, US | |
3620086 | 3620086 | 2022-08-01 | US | Tennessee | Van Buren | 47175 | 1978 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-08-02 04:20:53 | Van Buren, Tennessee, US | |
2148152 | 2148152 | 2022-06-27 | US | Arkansas | Monroe | 5095 | 1978 | 36 | 0 | 34.6815935 | -91.20540287 | 2022-06-28 04:20:58 | Monroe, Arkansas, US | |
478820 | 478820 | 2022-06-26 | US | Virginia | Middlesex | 51119 | 1978 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-06-27 04:21:00 | Middlesex, Virginia, US | |
476976 | 476976 | 2022-06-26 | US | Louisiana | St. Helena | 22091 | 1978 | 24 | 0 | 30.82210324 | -90.71013176 | 2022-06-27 04:21:00 | St. Helena, Louisiana, US | |
475953 | 475953 | 2022-06-26 | US | Arkansas | Monroe | 5095 | 1978 | 36 | 0 | 34.6815935 | -91.20540287 | 2022-06-27 04:21:00 | Monroe, Arkansas, US | |
942195 | 942195 | 2022-06-25 | US | Virginia | Middlesex | 51119 | 1978 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-06-26 04:21:02 | Middlesex, Virginia, US | |
940351 | 940351 | 2022-06-25 | US | Louisiana | St. Helena | 22091 | 1978 | 24 | 0 | 30.82210324 | -90.71013176 | 2022-06-26 04:21:02 | St. Helena, Louisiana, US | |
939328 | 939328 | 2022-06-25 | US | Arkansas | Monroe | 5095 | 1978 | 36 | 0 | 34.6815935 | -91.20540287 | 2022-06-26 04:21:02 | Monroe, Arkansas, US | |
3350015 | 3350015 | 2022-06-24 | US | Virginia | Middlesex | 51119 | 1978 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-06-25 04:20:57 | Middlesex, Virginia, US | |
3348171 | 3348171 | 2022-06-24 | US | Louisiana | St. Helena | 22091 | 1978 | 24 | 0 | 30.82210324 | -90.71013176 | 2022-06-25 04:20:57 | St. Helena, Louisiana, US | |
1766436 | 1766436 | 2022-06-20 | US | Texas | Hamilton | 48193 | 1978 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-06-21 04:20:56 | Hamilton, Texas, US | |
3272622 | 3272622 | 2022-06-19 | US | Texas | Hamilton | 48193 | 1978 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-06-20 04:21:01 | Hamilton, Texas, US | |
3400534 | 3400534 | 2022-06-18 | US | Texas | Hamilton | 48193 | 1978 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-06-19 04:20:51 | Hamilton, Texas, US | |
2314411 | 2314411 | 2022-06-17 | US | Texas | Hamilton | 48193 | 1978 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-06-18 04:21:10 | Hamilton, Texas, US | |
561915 | 561915 | 2022-06-16 | US | Texas | Hamilton | 48193 | 1978 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-06-17 04:20:56 | Hamilton, Texas, US | |
3985717 | 3985717 | 2022-06-15 | US | Texas | Hamilton | 48193 | 1978 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-06-16 04:20:55 | Hamilton, Texas, US | |
3984466 | 3984466 | 2022-06-15 | US | Mississippi | Unassigned | 90028 | 1978 | 8 | 0 | 34.88084463 | 0.0 | 2022-06-16 04:20:55 | Unassigned, Mississippi, US | |
1944308 | 1944308 | 2022-06-10 | China | Tianjin | 1978 | 3 | 0 | 39.3054 | 117.323 | 2022-06-11 04:21:01 | Tianjin, China | |||
3157447 | 3157447 | 2022-06-09 | China | Tianjin | 1978 | 3 | 0 | 39.3054 | 117.323 | 2022-06-10 04:20:55 | Tianjin, China | |||
1420914 | 1420914 | 2022-06-08 | China | Tianjin | 1978 | 3 | 0 | 39.3054 | 117.323 | 2022-06-09 04:20:54 | Tianjin, China | |||
3726028 | 3726028 | 2022-06-07 | China | Tianjin | 1978 | 3 | 0 | 39.3054 | 117.323 | 2022-06-08 04:20:55 | Tianjin, China | |||
3887430 | 3887430 | 2022-06-06 | China | Tianjin | 1978 | 3 | 0 | 39.3054 | 117.323 | 2022-06-07 04:21:08 | Tianjin, China | |||
973308 | 973308 | 2022-06-01 | US | North Dakota | Benson | 38005 | 1978 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-06-02 05:20:39 | Benson, North Dakota, US | |
1504646 | 1504646 | 2022-05-16 | US | Illinois | Schuyler | 17169 | 1978 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-05-17 04:20:59 | Schuyler, Illinois, US | |
3918454 | 3918454 | 2022-05-01 | US | North Dakota | Pembina | 38067 | 1978 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-05-02 04:21:10 | Pembina, North Dakota, US | |
2843258 | 2843258 | 2022-04-30 | US | North Dakota | Pembina | 38067 | 1978 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-05-01 04:20:57 | Pembina, North Dakota, US | |
1159571 | 1159571 | 2022-04-29 | US | North Dakota | Pembina | 38067 | 1978 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-04-30 04:21:05 | Pembina, North Dakota, US | |
1326667 | 1326667 | 2022-04-26 | US | Alaska | Chugach | 2063 | 1978 | 10 | 0 | 61.16666 | -149.9 | 2022-04-27 04:20:52 | Chugach, Alaska, US | |
3722621 | 3722621 | 2022-04-25 | US | Alaska | Chugach | 2063 | 1978 | 10 | 0 | 61.16666 | -149.9 | 2022-04-26 04:20:51 | Chugach, Alaska, US | |
2029189 | 2029189 | 2022-04-24 | US | Alaska | Chugach | 2063 | 1978 | 10 | 0 | 61.16666 | -149.9 | 2022-04-25 04:20:56 | Chugach, Alaska, US | |
746764 | 746764 | 2022-04-23 | US | Alaska | Chugach | 2063 | 1978 | 10 | 0 | 61.16666 | -149.9 | 2022-04-24 04:20:56 | Chugach, Alaska, US | |
3437249 | 3437249 | 2022-04-22 | US | Alaska | Chugach | 2063 | 1978 | 10 | 0 | 61.16666 | -149.9 | 2022-04-23 04:20:50 | Chugach, Alaska, US | |
2892834 | 2892834 | 2022-04-21 | US | Alaska | Chugach | 2063 | 1978 | 10 | 0 | 61.16666 | -149.9 | 2022-04-22 04:20:45 | Chugach, Alaska, US | |
2307706 | 2307706 | 2022-04-20 | US | Alaska | Chugach | 2063 | 1978 | 10 | 0 | 61.16666 | -149.9 | 2022-04-21 04:20:46 | Chugach, Alaska, US | |
2115508 | 2115508 | 2022-04-08 | China | Hebei | 1978 | 7 | 0 | 37.8957 | 114.9042 | 2022-04-09 04:20:42 | Hebei, China | |||
24199 | 24199 | 2022-03-20 | China | Jiangsu | 1978 | 0 | 0 | 32.9711 | 119.455 | 2022-03-21 04:20:50 | Jiangsu, China | |||
1656209 | 1656209 | 2022-03-19 | China | Jiangsu | 1978 | 0 | 0 | 32.9711 | 119.455 | 2022-03-20 04:20:45 | Jiangsu, China | |||
2736532 | 2736532 | 2022-02-27 | US | West Virginia | Pocahontas | 54075 | 1978 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-02-28 04:21:05 | Pocahontas, West Virginia, US | |
3049685 | 3049685 | 2022-02-26 | US | West Virginia | Pocahontas | 54075 | 1978 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-02-27 04:21:04 | Pocahontas, West Virginia, US | |
578340 | 578340 | 2022-02-25 | US | West Virginia | Pocahontas | 54075 | 1978 | 27 | 0 | 38.32758728 | -80.00993811 | 2022-02-26 04:21:12 | Pocahontas, West Virginia, US | |
1300041 | 1300041 | 2022-02-17 | US | Montana | Carbon | 30009 | 1978 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-02-18 04:21:04 | Carbon, Montana, US | |
3822427 | 3822427 | 2022-02-16 | US | Montana | Carbon | 30009 | 1978 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-02-17 04:20:56 | Carbon, Montana, US | |
3821359 | 3821359 | 2022-02-16 | US | Idaho | Benewah | 16009 | 1978 | 37 | 0 | 47.21754179 | -116.6586851 | 2022-02-17 04:20:56 | Benewah, Idaho, US | |
3673386 | 3673386 | 2022-02-15 | US | Minnesota | Lake | 27075 | 1978 | 27 | 0 | 47.64270764 | -91.44557998 | 2022-02-16 04:21:10 | Lake, Minnesota, US | |
2643696 | 2643696 | 2022-02-14 | US | Missouri | Oregon | 29149 | 1978 | 29 | 0 | 36.68710164 | -91.4033755 | 2022-02-15 04:21:09 | Oregon, Missouri, US | |
74597 | 74597 | 2022-02-07 | US | West Virginia | Pleasants | 54073 | 1978 | 34 | 0 | 39.37091679 | -81.16771771 | 2022-02-08 04:21:15 | Pleasants, West Virginia, US | |
1297514 | 1297514 | 2022-02-05 | US | West Virginia | Doddridge | 54017 | 1978 | 16 | 0 | 39.27057157 | -80.70671527 | 2022-02-06 04:21:00 | Doddridge, West Virginia, US | |
2660840 | 2660840 | 2022-01-31 | US | Texas | Clay | 48077 | 1978 | 27 | 0 | 33.78686685 | -98.20771198 | 2022-02-01 04:21:11 | Clay, Texas, US | |
1780821 | 1780821 | 2022-01-27 | US | Kentucky | Livingston | 21139 | 1978 | 51 | 0 | 37.21137452 | -88.34797529 | 2022-01-28 04:21:09 | Livingston, Kentucky, US | |
1144062 | 1144062 | 2022-01-23 | US | Texas | La Salle | 48283 | 1978 | 41 | 0 | 28.34453111 | -99.09908775 | 2022-01-24 04:21:12 | La Salle, Texas, US | |
2836343 | 2836343 | 2022-01-22 | US | West Virginia | Ritchie | 54085 | 1978 | 26 | 0 | 39.18094587 | -81.06356878 | 2022-01-23 04:21:13 | Ritchie, West Virginia, US | |
1961699 | 1961699 | 2022-01-20 | US | Indiana | Switzerland | 18155 | 1978 | 14 | 0 | 38.82767338 | -85.03022429 | 2022-01-21 04:21:09 | Switzerland, Indiana, US | |
1475326 | 1475326 | 2022-01-17 | US | Texas | Runnels | 48399 | 1978 | 57 | 0 | 31.8314342 | -99.97616148 | 2022-01-18 04:21:04 | Runnels, Texas, US | |
1474096 | 1474096 | 2022-01-17 | US | Missouri | Wayne | 29223 | 1978 | 37 | 0 | 37.11303869 | -90.46001416 | 2022-01-18 04:21:04 | Wayne, Missouri, US | |
556770 | 556770 | 2022-01-16 | US | Missouri | Wayne | 29223 | 1978 | 37 | 0 | 37.11303869 | -90.46001416 | 2022-01-17 04:21:08 | Wayne, Missouri, US | |
3842491 | 3842491 | 2022-01-15 | US | Missouri | Wayne | 29223 | 1978 | 37 | 0 | 37.11303869 | -90.46001416 | 2022-01-16 04:21:12 | Wayne, Missouri, US | |
3614025 | 3614025 | 2022-01-12 | US | Idaho | Washington | 16087 | 1978 | 50 | 0 | 44.45275475 | -116.78476880000001 | 2022-01-13 08:00:09 | Washington, Idaho, US | |
2611839 | 2611839 | 2022-01-06 | US | Mississippi | Carroll | 28015 | 1978 | 41 | 0 | 33.44834567 | -89.91994479 | 2022-01-07 04:22:09 | Carroll, Mississippi, US | |
2611676 | 2611676 | 2022-01-06 | US | Michigan | Crawford | 26039 | 1978 | 22 | 0 | 44.68255561 | -84.61006219 | 2022-01-07 04:22:09 | Crawford, Michigan, US | |
1283618 | 1283618 | 2022-01-05 | US | Michigan | Crawford | 26039 | 1978 | 22 | 0 | 44.68255561 | -84.61006219 | 2022-01-06 04:22:09 | Crawford, Michigan, US | |
1288222 | 1288222 | 2022-01-04 | US | New Mexico | Torrance | 35057 | 1978 | 36 | 0 | 34.64048375 | -105.8508949 | 2022-01-05 04:21:59 | Torrance, New Mexico, US | |
2114740 | 2114740 | 2021-12-26 | US | Texas | Callahan | 48059 | 1978 | 58 | 0 | 32.29760619 | -99.37326312 | 2021-12-27 04:21:58 | Callahan, Texas, US | |
800355 | 800355 | 2021-12-22 | US | Missouri | Linn | 29115 | 1978 | 58 | 0 | 39.87001769 | -93.10704106 | 2021-12-23 04:21:21 | Linn, Missouri, US | |
799082 | 799082 | 2021-12-22 | US | Colorado | Rio Grande | 8105 | 1978 | 40 | 0 | 37.5836865 | -106.3847838 | 2021-12-23 04:21:21 | Rio Grande, Colorado, US | |
3831425 | 3831425 | 2021-12-21 | US | Tennessee | Houston | 47083 | 1978 | 47 | 0 | 36.28872054 | -87.71878828 | 2021-12-22 04:21:54 | Houston, Tennessee, US | |
3831250 | 3831250 | 2021-12-21 | US | Puerto Rico | San Sebastian | 72131 | 1978 | 0 | 0 | 18.328646 | -66.971214 | 2021-12-22 04:21:54 | San Sebastian, Puerto Rico, US | |
3830395 | 3830395 | 2021-12-21 | US | Missouri | Linn | 29115 | 1978 | 58 | 0 | 39.87001769 | -93.10704106 | 2021-12-22 04:21:54 | Linn, Missouri, US | |
1258286 | 1258286 | 2021-12-20 | US | West Virginia | Roane | 54087 | 1978 | 27 | 0 | 38.71622686 | -81.35243568 | 2021-12-21 03:21:27 | Roane, West Virginia, US | |
1256556 | 1256556 | 2021-12-20 | US | Minnesota | Yellow Medicine | 27173 | 1978 | 25 | 0 | 44.71710183 | -95.86842453 | 2021-12-21 03:21:27 | Yellow Medicine, Minnesota, US | |
1259352 | 1259352 | 2021-12-18 | US | California | Mono | 6051 | 1978 | 4 | 0 | 37.93899289 | -118.8872409 | 2021-12-19 04:21:11 | Mono, California, US | |
2402105 | 2402105 | 2021-12-17 | US | Vermont | Orange | 50017 | 1978 | 9 | 0 | 44.00470222 | -72.37640104 | 2021-12-18 02:22:20 | Orange, Vermont, US | |
2399380 | 2399380 | 2021-12-17 | US | California | Mono | 6051 | 1978 | 4 | 0 | 37.93899289 | -118.8872409 | 2021-12-18 02:22:20 | Mono, California, US | |
1716918 | 1716918 | 2021-12-16 | US | California | Mono | 6051 | 1978 | 4 | 0 | 37.93899289 | -118.8872409 | 2021-12-17 04:22:14 | Mono, California, US | |
3496671 | 3496671 | 2021-12-15 | US | Arkansas | Desha | 5041 | 1978 | 35 | 0 | 33.83011025 | -91.25500948 | 2021-12-16 04:22:11 | Desha, Arkansas, US | |
2090554 | 2090554 | 2021-12-14 | US | Oklahoma | Noble | 40103 | 1978 | 30 | 0 | 36.38953329 | -97.22928674 | 2021-12-15 03:22:16 | Noble, Oklahoma, US | |
2088456 | 2088456 | 2021-12-14 | US | Arkansas | Desha | 5041 | 1978 | 34 | 0 | 33.83011025 | -91.25500948 | 2021-12-15 03:22:16 | Desha, Arkansas, US | |
784971 | 784971 | 2021-12-13 | US | Oklahoma | Noble | 40103 | 1978 | 30 | 0 | 36.38953329 | -97.22928674 | 2021-12-14 04:22:38 | Noble, Oklahoma, US | |
1663775 | 1663775 | 2021-12-12 | US | Virginia | Greensville | 51081 | 1978 | 26 | 0 | 36.67878901 | -77.56351439 | 2021-12-13 04:22:02 | Greensville, Virginia, US | |
1663006 | 1663006 | 2021-12-12 | US | Oklahoma | Noble | 40103 | 1978 | 30 | 0 | 36.38953329 | -97.22928674 | 2021-12-13 04:22:02 | Noble, Oklahoma, US | |
1667791 | 1667791 | 2021-12-11 | US | Virginia | Greensville | 51081 | 1978 | 26 | 0 | 36.67878901 | -77.56351439 | 2021-12-12 04:22:12 | Greensville, Virginia, US | |
1667022 | 1667022 | 2021-12-11 | US | Oklahoma | Noble | 40103 | 1978 | 30 | 0 | 36.38953329 | -97.22928674 | 2021-12-12 04:22:12 | Noble, Oklahoma, US | |
3658943 | 3658943 | 2021-12-10 | US | Virginia | Greensville | 51081 | 1978 | 26 | 0 | 36.67878901 | -77.56351439 | 2021-12-11 04:22:45 | Greensville, Virginia, US | |
3658174 | 3658174 | 2021-12-10 | US | Oklahoma | Noble | 40103 | 1978 | 30 | 0 | 36.38953329 | -97.22928674 | 2021-12-11 04:22:45 | Noble, Oklahoma, US | |
1080505 | 1080505 | 2021-12-09 | US | Oklahoma | Noble | 40103 | 1978 | 30 | 0 | 36.38953329 | -97.22928674 | 2021-12-10 04:22:28 | Noble, Oklahoma, US | |
553354 | 553354 | 2021-12-08 | US | Oklahoma | Noble | 40103 | 1978 | 30 | 0 | 36.38953329 | -97.22928674 | 2021-12-09 04:22:49 | Noble, Oklahoma, US | |
1743171 | 1743171 | 2021-12-05 | US | Oregon | Morrow | 41049 | 1978 | 25 | 0 | 45.41846568 | -119.584546 | 2021-12-06 04:22:34 | Morrow, Oregon, US | |
140603 | 140603 | 2021-12-04 | US | Oregon | Morrow | 41049 | 1978 | 25 | 0 | 45.41846568 | -119.584546 | 2021-12-05 04:22:25 | Morrow, Oregon, US | |
2198256 | 2198256 | 2021-12-03 | US | Oregon | Morrow | 41049 | 1978 | 25 | 0 | 45.41846568 | -119.584546 | 2021-12-04 04:22:18 | Morrow, Oregon, US | |
3659 | 3659 | 2021-12-02 | US | Virginia | Dickenson | 51051 | 1978 | 30 | 0 | 37.12560977 | -82.35124171 | 2021-12-03 04:23:05 | Dickenson, Virginia, US | |
3086 | 3086 | 2021-12-02 | US | Puerto Rico | Las Piedras | 72085 | 1978 | 0 | 0 | 18.187527 | -65.86946800000001 | 2021-12-03 04:23:05 | Las Piedras, Puerto Rico, 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]);