johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
172 rows where confirmed = 4491 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2417080 | 2417080 | 2022-12-05 | US | New Mexico | Los Alamos | 35028 | 4491 | 22 | 0 | 35.86631386 | -106.3134985 | 2022-12-06 04:21:03 | Los Alamos, New Mexico, US | |
1968142 | 1968142 | 2022-11-30 | US | Wisconsin | Marquette | 55077 | 4491 | 66 | 0 | 43.81911946 | -89.40073763 | 2022-12-01 04:21:03 | Marquette, Wisconsin, US | |
292398 | 292398 | 2022-11-15 | US | Alabama | Lamar | 1075 | 4491 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-16 04:21:09 | Lamar, Alabama, US | |
3597428 | 3597428 | 2022-11-14 | US | Alabama | Lamar | 1075 | 4491 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-15 04:21:16 | Lamar, Alabama, US | |
312286 | 312286 | 2022-11-13 | US | Alabama | Lamar | 1075 | 4491 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-14 04:21:09 | Lamar, Alabama, US | |
63447 | 63447 | 2022-11-12 | US | Alabama | Lamar | 1075 | 4491 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-13 04:21:14 | Lamar, Alabama, US | |
2927609 | 2927609 | 2022-11-11 | US | Alabama | Lamar | 1075 | 4491 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-12 04:20:41 | Lamar, Alabama, US | |
2506445 | 2506445 | 2022-11-10 | US | Alabama | Lamar | 1075 | 4491 | 69 | 0 | 33.77995024 | -88.09668032 | 2022-11-11 04:21:22 | Lamar, Alabama, US | |
320431 | 320431 | 2022-10-30 | US | Arkansas | Izard | 5065 | 4491 | 77 | 0 | 36.09604046 | -91.90847954 | 2022-10-31 04:21:36 | Izard, Arkansas, US | |
912707 | 912707 | 2022-10-29 | US | Arkansas | Izard | 5065 | 4491 | 77 | 0 | 36.09604046 | -91.90847954 | 2022-10-30 04:22:14 | Izard, Arkansas, US | |
1977641 | 1977641 | 2022-09-25 | US | Illinois | Mason | 17125 | 4491 | 65 | 0 | 40.23917274 | -89.91824452 | 2022-09-26 04:20:52 | Mason, Illinois, US | |
2650808 | 2650808 | 2022-09-24 | US | Illinois | Mason | 17125 | 4491 | 65 | 0 | 40.23917274 | -89.91824452 | 2022-09-25 04:23:31 | Mason, Illinois, US | |
385248 | 385248 | 2022-09-23 | US | Illinois | Mason | 17125 | 4491 | 65 | 0 | 40.23917274 | -89.91824452 | 2022-09-24 04:21:40 | Mason, Illinois, US | |
1625314 | 1625314 | 2022-09-22 | US | Illinois | Mason | 17125 | 4491 | 65 | 0 | 40.23917274 | -89.91824452 | 2022-09-23 04:23:13 | Mason, Illinois, US | |
2355990 | 2355990 | 2022-09-16 | US | Arkansas | Polk | 5113 | 4491 | 153 | 0 | 34.48254879 | -94.22728802 | 2022-09-17 04:20:19 | Polk, Arkansas, US | |
374624 | 374624 | 2022-09-13 | US | North Dakota | Richland | 38077 | 4491 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-09-14 04:20:44 | Richland, North Dakota, US | |
2715732 | 2715732 | 2022-09-03 | US | Puerto Rico | Luquillo | 72089 | 4491 | 0 | 0 | 18.342114 | -65.725097 | 2022-09-04 04:21:22 | Luquillo, Puerto Rico, US | |
2326070 | 2326070 | 2022-08-24 | US | Puerto Rico | Arroyo | 72015 | 4491 | 0 | 0 | 17.998457 | -66.056546 | 2022-08-25 04:21:13 | Arroyo, Puerto Rico, US | |
3546262 | 3546262 | 2022-08-08 | US | Puerto Rico | Penuelas | 72111 | 4491 | 0 | 0 | 18.059645 | -66.721572 | 2022-08-09 04:20:34 | Penuelas, Puerto Rico, US | |
3620206 | 3620206 | 2022-08-01 | US | Texas | Houston | 48225 | 4491 | 113 | 0 | 31.31925973 | -95.42226208 | 2022-08-02 04:20:53 | Houston, Texas, US | |
3213786 | 3213786 | 2022-07-18 | US | West Virginia | Morgan | 54065 | 4491 | 70 | 0 | 39.55439028 | -78.26311676 | 2022-07-19 04:20:58 | Morgan, West Virginia, US | |
3406883 | 3406883 | 2022-07-17 | US | Kentucky | Knott | 21119 | 4491 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-18 04:20:59 | Knott, Kentucky, US | |
2153083 | 2153083 | 2022-07-16 | US | Kentucky | Knott | 21119 | 4491 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-17 04:21:15 | Knott, Kentucky, US | |
2420316 | 2420316 | 2022-07-15 | US | Kentucky | Knott | 21119 | 4491 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-16 04:21:05 | Knott, Kentucky, US | |
3430391 | 3430391 | 2022-07-14 | US | Kentucky | Knott | 21119 | 4491 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-15 04:20:53 | Knott, Kentucky, US | |
3110911 | 3110911 | 2022-07-13 | US | Kentucky | Knott | 21119 | 4491 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-14 04:20:57 | Knott, Kentucky, US | |
631334 | 631334 | 2022-07-12 | US | Kentucky | Knott | 21119 | 4491 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-13 04:20:58 | Knott, Kentucky, US | |
1212978 | 1212978 | 2022-07-11 | US | Kentucky | Knott | 21119 | 4491 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-12 04:20:51 | Knott, Kentucky, US | |
2493365 | 2493365 | 2022-06-29 | US | Virginia | Goochland | 51075 | 4491 | 53 | 0 | 37.71714806 | -77.90381514 | 2022-06-30 04:21:01 | Goochland, Virginia, US | |
947749 | 947749 | 2022-06-14 | US | Georgia | Washington | 13303 | 4491 | 137 | 0 | 32.96711864 | -82.79357039 | 2022-06-15 04:20:54 | Washington, Georgia, US | |
2980157 | 2980157 | 2022-06-13 | US | Georgia | Washington | 13303 | 4491 | 137 | 0 | 32.96711864 | -82.79357039 | 2022-06-14 04:20:52 | Washington, Georgia, US | |
2236283 | 2236283 | 2022-06-12 | US | Georgia | Washington | 13303 | 4491 | 137 | 0 | 32.96711864 | -82.79357039 | 2022-06-13 04:21:14 | Washington, Georgia, US | |
3142481 | 3142481 | 2022-06-11 | US | Georgia | Washington | 13303 | 4491 | 137 | 0 | 32.96711864 | -82.79357039 | 2022-06-12 04:20:53 | Washington, Georgia, US | |
1945397 | 1945397 | 2022-06-10 | US | Georgia | Washington | 13303 | 4491 | 137 | 0 | 32.96711864 | -82.79357039 | 2022-06-11 04:21:01 | Washington, Georgia, US | |
3158536 | 3158536 | 2022-06-09 | US | Georgia | Washington | 13303 | 4491 | 137 | 0 | 32.96711864 | -82.79357039 | 2022-06-10 04:20:55 | Washington, Georgia, US | |
1422003 | 1422003 | 2022-06-08 | US | Georgia | Washington | 13303 | 4491 | 137 | 0 | 32.96711864 | -82.79357039 | 2022-06-09 04:20:54 | Washington, Georgia, US | |
971409 | 971409 | 2022-06-01 | US | Arkansas | Grant | 5053 | 4491 | 62 | 0 | 34.29017991 | -92.42320562 | 2022-06-02 05:20:39 | Grant, Arkansas, US | |
3188714 | 3188714 | 2022-05-30 | US | Puerto Rico | Barceloneta | 72017 | 4491 | 0 | 0 | 18.445533 | -66.560531 | 2022-05-31 04:20:51 | Barceloneta, Puerto Rico, US | |
1506821 | 1506821 | 2022-05-16 | US | Texas | Shelby | 48419 | 4491 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-05-17 04:20:59 | Shelby, Texas, US | |
2087180 | 2087180 | 2022-05-15 | US | Texas | Shelby | 48419 | 4491 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-05-16 04:20:47 | Shelby, Texas, US | |
3357890 | 3357890 | 2022-05-14 | US | Texas | Shelby | 48419 | 4491 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-05-15 04:20:53 | Shelby, Texas, US | |
661535 | 661535 | 2022-05-13 | US | Texas | Shelby | 48419 | 4491 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-05-14 04:20:48 | Shelby, Texas, US | |
1327112 | 1327112 | 2022-04-26 | US | Georgia | Putnam | 13237 | 4491 | 106 | 0 | 33.32056115 | -83.37552891 | 2022-04-27 04:20:52 | Putnam, Georgia, US | |
3723066 | 3723066 | 2022-04-25 | US | Georgia | Putnam | 13237 | 4491 | 106 | 0 | 33.32056115 | -83.37552891 | 2022-04-26 04:20:51 | Putnam, Georgia, US | |
2029634 | 2029634 | 2022-04-24 | US | Georgia | Putnam | 13237 | 4491 | 106 | 0 | 33.32056115 | -83.37552891 | 2022-04-25 04:20:56 | Putnam, Georgia, US | |
747209 | 747209 | 2022-04-23 | US | Georgia | Putnam | 13237 | 4491 | 106 | 0 | 33.32056115 | -83.37552891 | 2022-04-24 04:20:56 | Putnam, Georgia, US | |
3437694 | 3437694 | 2022-04-22 | US | Georgia | Putnam | 13237 | 4491 | 106 | 0 | 33.32056115 | -83.37552891 | 2022-04-23 04:20:50 | Putnam, Georgia, US | |
2893279 | 2893279 | 2022-04-21 | US | Georgia | Putnam | 13237 | 4491 | 106 | 0 | 33.32056115 | -83.37552891 | 2022-04-22 04:20:45 | Putnam, Georgia, US | |
2308151 | 2308151 | 2022-04-20 | US | Georgia | Putnam | 13237 | 4491 | 106 | 0 | 33.32056115 | -83.37552891 | 2022-04-21 04:20:46 | Putnam, Georgia, US | |
3419662 | 3419662 | 2022-04-17 | US | Puerto Rico | Guayama | 72057 | 4491 | 0 | 0 | 18.007516 | -66.13390799999999 | 2022-04-18 04:21:12 | Guayama, Puerto Rico, US | |
2803543 | 2803543 | 2022-04-06 | US | Puerto Rico | Naranjito | 72105 | 4491 | 0 | 0 | 18.288019 | -66.252703 | 2022-04-07 04:20:53 | Naranjito, Puerto Rico, US | |
3730777 | 3730777 | 2022-04-03 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-04-04 04:20:51 | Colusa, California, US | |
500212 | 500212 | 2022-04-02 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-04-03 04:20:48 | Colusa, California, US | |
3351197 | 3351197 | 2022-04-01 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-04-02 04:20:47 | Colusa, California, US | |
1540502 | 1540502 | 2022-03-31 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-04-01 04:20:28 | Colusa, California, US | |
2478515 | 2478515 | 2022-03-30 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-03-31 04:20:56 | Colusa, California, US | |
158556 | 158556 | 2022-03-29 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-03-30 04:20:45 | Colusa, California, US | |
1437127 | 1437127 | 2022-03-28 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-03-29 04:20:46 | Colusa, California, US | |
876808 | 876808 | 2022-03-27 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-03-28 04:20:33 | Colusa, California, US | |
2164091 | 2164091 | 2022-03-26 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-03-27 04:20:47 | Colusa, California, US | |
1721027 | 1721027 | 2022-03-25 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-03-26 04:20:23 | Colusa, California, US | |
1468644 | 1468644 | 2022-03-24 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-03-25 04:20:46 | Colusa, California, US | |
1905740 | 1905740 | 2022-03-22 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-03-23 04:20:48 | Colusa, California, US | |
3238871 | 3238871 | 2022-03-21 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-03-22 04:20:54 | Colusa, California, US | |
26124 | 26124 | 2022-03-20 | US | Minnesota | Houston | 27055 | 4491 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-03-21 04:20:50 | Houston, Minnesota, US | |
1658134 | 1658134 | 2022-03-19 | US | Minnesota | Houston | 27055 | 4491 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-03-20 04:20:45 | Houston, Minnesota, US | |
1656954 | 1656954 | 2022-03-19 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-03-20 04:20:45 | Colusa, California, US | |
337660 | 337660 | 2022-03-18 | US | Minnesota | Houston | 27055 | 4491 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-03-19 04:20:47 | Houston, Minnesota, US | |
336480 | 336480 | 2022-03-18 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-03-19 04:20:47 | Colusa, California, US | |
694933 | 694933 | 2022-03-17 | US | California | Colusa | 6011 | 4491 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-03-18 04:20:55 | Colusa, California, US | |
2319876 | 2319876 | 2022-03-16 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-03-17 04:20:56 | Colusa, California, US | |
262076 | 262076 | 2022-03-15 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-03-16 04:20:50 | Colusa, California, US | |
2264435 | 2264435 | 2022-03-14 | US | California | Colusa | 6011 | 4491 | 21 | 0 | 39.17881957 | -122.2331726 | 2022-03-15 04:20:47 | Colusa, California, US | |
359018 | 359018 | 2022-03-11 | US | Pennsylvania | Montour | 42093 | 4491 | 91 | 0 | 41.03023987 | -76.66345939 | 2022-03-12 04:20:50 | Montour, Pennsylvania, US | |
1647945 | 1647945 | 2022-03-03 | US | Wisconsin | Sawyer | 55113 | 4491 | 59 | 0 | 45.87931905 | -91.14504927 | 2022-03-04 04:21:09 | Sawyer, Wisconsin, US | |
2735167 | 2735167 | 2022-02-27 | US | Nevada | Humboldt | 32013 | 4491 | 52 | 0 | 41.40692186 | -118.11094270000001 | 2022-02-28 04:21:05 | Humboldt, Nevada, US | |
3048320 | 3048320 | 2022-02-26 | US | Nevada | Humboldt | 32013 | 4491 | 52 | 0 | 41.40692186 | -118.11094270000001 | 2022-02-27 04:21:04 | Humboldt, Nevada, US | |
576975 | 576975 | 2022-02-25 | US | Nevada | Humboldt | 32013 | 4491 | 52 | 0 | 41.40692186 | -118.11094270000001 | 2022-02-26 04:21:12 | Humboldt, Nevada, US | |
3720678 | 3720678 | 2022-02-21 | US | Ohio | Meigs | 39105 | 4491 | 84 | 0 | 39.09224872 | -82.0305041 | 2022-02-22 04:21:01 | Meigs, Ohio, US | |
3856433 | 3856433 | 2022-02-18 | US | Colorado | Alamosa | 8003 | 4491 | 61 | 0 | 37.57250606 | -105.7885451 | 2022-02-19 04:21:11 | Alamosa, Colorado, US | |
189465 | 189465 | 2022-02-13 | US | Virginia | Prince Edward | 51147 | 4491 | 59 | 0 | 37.22554789 | -78.43597949 | 2022-02-14 04:20:51 | Prince Edward, Virginia, US | |
187695 | 187695 | 2022-02-13 | US | Michigan | Cheboygan | 26031 | 4491 | 93 | 0 | 45.44787015 | -84.50122149 | 2022-02-14 04:20:51 | Cheboygan, Michigan, US | |
319311 | 319311 | 2022-02-12 | US | Virginia | Prince Edward | 51147 | 4491 | 59 | 0 | 37.22554789 | -78.43597949 | 2022-02-13 04:21:00 | Prince Edward, Virginia, US | |
317541 | 317541 | 2022-02-12 | US | Michigan | Cheboygan | 26031 | 4491 | 93 | 0 | 45.44787015 | -84.50122149 | 2022-02-13 04:21:00 | Cheboygan, Michigan, US | |
236637 | 236637 | 2022-02-11 | US | Virginia | Prince Edward | 51147 | 4491 | 59 | 0 | 37.22554789 | -78.43597949 | 2022-02-12 04:21:06 | Prince Edward, Virginia, US | |
234867 | 234867 | 2022-02-11 | US | Michigan | Cheboygan | 26031 | 4491 | 93 | 0 | 45.44787015 | -84.50122149 | 2022-02-12 04:21:06 | Cheboygan, Michigan, US | |
1465875 | 1465875 | 2022-02-10 | US | Mississippi | Calhoun | 28013 | 4491 | 57 | 0 | 33.93683395 | -89.33686647 | 2022-02-11 04:21:09 | Calhoun, Mississippi, US | |
3074072 | 3074072 | 2022-02-09 | Japan | Tottori | 4491 | 5 | 0 | 35.359069 | 133.863619 | 2022-02-10 04:21:14 | Tottori, Japan | |||
73475 | 73475 | 2022-02-07 | US | North Carolina | Yancey | 37199 | 4491 | 49 | 0 | 35.90079156 | -82.31237181 | 2022-02-08 04:21:15 | Yancey, North Carolina, US | |
980593 | 980593 | 2022-02-01 | US | Michigan | Iosco | 26069 | 4491 | 128 | 0 | 44.35486835 | -83.63484895 | 2022-02-02 04:21:09 | Iosco, Michigan, US | |
2659435 | 2659435 | 2022-01-31 | US | Michigan | Iosco | 26069 | 4491 | 128 | 0 | 44.35486835 | -83.63484895 | 2022-02-01 04:21:11 | Iosco, Michigan, US | |
1229410 | 1229410 | 2022-01-24 | US | Mississippi | Clay | 28025 | 4491 | 80 | 0 | 33.65358105 | -88.77784255 | 2022-01-25 04:21:05 | Clay, Mississippi, US | |
3226455 | 3226455 | 2022-01-19 | Japan | Kochi | 4491 | 33 | 0 | 33.422519 | 133.367307 | 2022-01-20 04:21:07 | Kochi, Japan | |||
1433502 | 1433502 | 2021-12-28 | US | Idaho | Elmore | 16039 | 4491 | 53 | 0 | 43.3507101 | -115.4701578 | 2021-12-29 03:21:43 | Elmore, Idaho, US | |
1432698 | 1432698 | 2021-12-28 | Netherlands | Unknown | 4491 | 33 | 0 | 2021-12-29 03:21:43 | Unknown, Netherlands | |||||
3818898 | 3818898 | 2021-12-23 | US | Ohio | Hocking | 39073 | 4491 | 100 | 0 | 39.49537927 | -82.47991446 | 2021-12-24 04:21:34 | Hocking, Ohio, US | |
2088443 | 2088443 | 2021-12-14 | US | Arkansas | Carroll | 5015 | 4491 | 78 | 0 | 36.34038560000001 | -93.54270261 | 2021-12-15 03:22:16 | Carroll, Arkansas, US | |
1233063 | 1233063 | 2021-11-28 | US | Kentucky | Lincoln | 21137 | 4491 | 103 | 0 | 37.45475628 | -84.6565327 | 2021-11-29 04:22:30 | Lincoln, Kentucky, US | |
1232711 | 1232711 | 2021-11-28 | US | Indiana | Decatur | 18031 | 4491 | 109 | 0 | 39.30712658 | -85.50087166 | 2021-11-29 04:22:30 | Decatur, Indiana, US | |
1359418 | 1359418 | 2021-11-27 | US | Indiana | Decatur | 18031 | 4491 | 109 | 0 | 39.30712658 | -85.50087166 | 2021-11-28 04:22:43 | Decatur, Indiana, 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]);