johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
227 rows where confirmed = 3031 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1631680 | 1631680 | 2022-12-18 | US | Virginia | Madison | 51113 | 3031 | 46 | 0 | 38.41531222 | -78.28220331 | 2022-12-19 04:21:03 | Madison, Virginia, US | |
507059 | 507059 | 2022-12-17 | US | Virginia | Madison | 51113 | 3031 | 46 | 0 | 38.41531222 | -78.28220331 | 2022-12-18 04:21:03 | Madison, Virginia, US | |
3327631 | 3327631 | 2022-12-16 | US | Virginia | Madison | 51113 | 3031 | 46 | 0 | 38.41531222 | -78.28220331 | 2022-12-17 04:21:04 | Madison, Virginia, US | |
719158 | 719158 | 2022-12-04 | US | Connecticut | Unassigned | 90009 | 3031 | 8 | 0 | 41.85853803 | 0.0 | 2022-12-05 04:20:58 | Unassigned, Connecticut, US | |
3525481 | 3525481 | 2022-11-24 | US | Montana | Rosebud | 30087 | 3031 | 62 | 0 | 46.23397237 | -106.729288 | 2022-11-25 04:21:06 | Rosebud, Montana, US | |
3314264 | 3314264 | 2022-11-23 | US | Montana | Rosebud | 30087 | 3031 | 62 | 0 | 46.23397237 | -106.729288 | 2022-11-24 04:21:09 | Rosebud, Montana, US | |
1622305 | 1622305 | 2022-11-22 | US | Montana | Rosebud | 30087 | 3031 | 62 | 0 | 46.23397237 | -106.729288 | 2022-11-23 04:21:06 | Rosebud, Montana, US | |
3462193 | 3462193 | 2022-11-21 | US | Montana | Rosebud | 30087 | 3031 | 62 | 0 | 46.23397237 | -106.729288 | 2022-11-22 04:20:47 | Rosebud, Montana, US | |
1642378 | 1642378 | 2022-11-20 | US | Montana | Rosebud | 30087 | 3031 | 62 | 0 | 46.23397237 | -106.729288 | 2022-11-21 04:21:05 | Rosebud, Montana, US | |
2065935 | 2065935 | 2022-11-19 | US | Montana | Rosebud | 30087 | 3031 | 62 | 0 | 46.23397237 | -106.729288 | 2022-11-20 04:21:08 | Rosebud, Montana, US | |
1757329 | 1757329 | 2022-11-18 | US | Montana | Rosebud | 30087 | 3031 | 62 | 0 | 46.23397237 | -106.729288 | 2022-11-19 04:21:14 | Rosebud, Montana, US | |
2488967 | 2488967 | 2022-11-16 | US | Tennessee | Lake | 47095 | 3031 | 46 | 0 | 36.3418017 | -89.48921915 | 2022-11-17 04:21:11 | Lake, Tennessee, US | |
480244 | 480244 | 2022-11-08 | US | Colorado | Prowers | 8099 | 3031 | 52 | 0 | 37.95544985 | -102.3926052 | 2022-11-09 04:21:22 | Prowers, Colorado, US | |
541362 | 541362 | 2022-10-26 | US | Oklahoma | Washita | 40149 | 3031 | 58 | 0 | 35.29071824 | -98.99180434 | 2022-10-27 04:22:01 | Washita, Oklahoma, US | |
1832763 | 1832763 | 2022-10-25 | US | Oklahoma | Washita | 40149 | 3031 | 58 | 0 | 35.29071824 | -98.99180434 | 2022-10-26 04:22:19 | Washita, Oklahoma, US | |
797024 | 797024 | 2022-10-24 | US | Oklahoma | Washita | 40149 | 3031 | 58 | 0 | 35.29071824 | -98.99180434 | 2022-10-25 04:21:53 | Washita, Oklahoma, US | |
3279479 | 3279479 | 2022-10-23 | US | Oklahoma | Washita | 40149 | 3031 | 58 | 0 | 35.29071824 | -98.99180434 | 2022-10-24 04:22:29 | Washita, Oklahoma, US | |
2270517 | 2270517 | 2022-10-22 | US | Oklahoma | Washita | 40149 | 3031 | 58 | 0 | 35.29071824 | -98.99180434 | 2022-10-23 04:22:46 | Washita, Oklahoma, US | |
1594817 | 1594817 | 2022-10-21 | US | Oklahoma | Washita | 40149 | 3031 | 58 | 0 | 35.29071824 | -98.99180434 | 2022-10-22 04:22:53 | Washita, Oklahoma, US | |
2274533 | 2274533 | 2022-10-20 | US | Oklahoma | Washita | 40149 | 3031 | 58 | 0 | 35.29071824 | -98.99180434 | 2022-10-21 04:22:23 | Washita, Oklahoma, US | |
1813192 | 1813192 | 2022-10-05 | US | North Dakota | McLean | 38055 | 3031 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-10-06 04:21:22 | McLean, North Dakota, US | |
133166 | 133166 | 2022-10-04 | US | North Dakota | McLean | 38055 | 3031 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-10-05 04:23:06 | McLean, North Dakota, US | |
2020096 | 2020096 | 2022-09-20 | US | Virginia | Lunenburg | 51111 | 3031 | 42 | 0 | 36.94618528 | -78.24133319 | 2022-09-21 04:23:22 | Lunenburg, Virginia, US | |
420340 | 420340 | 2022-09-18 | US | Illinois | Jasper | 17079 | 3031 | 31 | 0 | 39.01054275 | -88.15437049 | 2022-09-19 04:21:49 | Jasper, Illinois, US | |
3374364 | 3374364 | 2022-09-17 | US | Illinois | Jasper | 17079 | 3031 | 31 | 0 | 39.01054275 | -88.15437049 | 2022-09-18 04:22:50 | Jasper, Illinois, US | |
2356472 | 2356472 | 2022-09-16 | US | Illinois | Jasper | 17079 | 3031 | 31 | 0 | 39.01054275 | -88.15437049 | 2022-09-17 04:20:19 | Jasper, Illinois, US | |
3987629 | 3987629 | 2022-09-15 | US | Illinois | Jasper | 17079 | 3031 | 31 | 0 | 39.01054275 | -88.15437049 | 2022-09-16 04:21:19 | Jasper, Illinois, US | |
1890146 | 1890146 | 2022-09-14 | US | Illinois | Jasper | 17079 | 3031 | 31 | 0 | 39.01054275 | -88.15437049 | 2022-09-15 04:21:02 | Jasper, Illinois, US | |
373201 | 373201 | 2022-09-13 | US | Illinois | Jasper | 17079 | 3031 | 31 | 0 | 39.01054275 | -88.15437049 | 2022-09-14 04:20:44 | Jasper, Illinois, US | |
2395803 | 2395803 | 2022-09-12 | US | Illinois | Jasper | 17079 | 3031 | 31 | 0 | 39.01054275 | -88.15437049 | 2022-09-13 04:20:57 | Jasper, Illinois, US | |
2402626 | 2402626 | 2022-08-21 | China | Heilongjiang | 3031 | 13 | 0 | 47.862 | 127.7615 | 2022-08-22 04:20:38 | Heilongjiang, China | |||
94185 | 94185 | 2022-07-23 | US | Texas | Camp | 48063 | 3031 | 75 | 0 | 32.97195142 | -94.97790104 | 2022-07-24 04:20:47 | Camp, Texas, US | |
3212100 | 3212100 | 2022-07-18 | US | Mississippi | Jefferson Davis | 28065 | 3031 | 55 | 0 | 31.56884708 | -89.8267099 | 2022-07-19 04:20:58 | Jefferson Davis, Mississippi, US | |
3210784 | 3210784 | 2022-07-18 | US | Arkansas | Lee | 5077 | 3031 | 62 | 0 | 34.78498904 | -90.78383866 | 2022-07-19 04:20:58 | Lee, Arkansas, US | |
3407275 | 3407275 | 2022-07-17 | US | Mississippi | Jefferson Davis | 28065 | 3031 | 55 | 0 | 31.56884708 | -89.8267099 | 2022-07-18 04:20:59 | Jefferson Davis, Mississippi, US | |
3405959 | 3405959 | 2022-07-17 | US | Arkansas | Lee | 5077 | 3031 | 62 | 0 | 34.78498904 | -90.78383866 | 2022-07-18 04:20:59 | Lee, Arkansas, US | |
2153475 | 2153475 | 2022-07-16 | US | Mississippi | Jefferson Davis | 28065 | 3031 | 55 | 0 | 31.56884708 | -89.8267099 | 2022-07-17 04:21:15 | Jefferson Davis, Mississippi, US | |
2152159 | 2152159 | 2022-07-16 | US | Arkansas | Lee | 5077 | 3031 | 62 | 0 | 34.78498904 | -90.78383866 | 2022-07-17 04:21:15 | Lee, Arkansas, US | |
2420708 | 2420708 | 2022-07-15 | US | Mississippi | Jefferson Davis | 28065 | 3031 | 55 | 0 | 31.56884708 | -89.8267099 | 2022-07-16 04:21:05 | Jefferson Davis, Mississippi, US | |
3430783 | 3430783 | 2022-07-14 | US | Mississippi | Jefferson Davis | 28065 | 3031 | 55 | 0 | 31.56884708 | -89.8267099 | 2022-07-15 04:20:53 | Jefferson Davis, Mississippi, US | |
3111303 | 3111303 | 2022-07-13 | US | Mississippi | Jefferson Davis | 28065 | 3031 | 55 | 0 | 31.56884708 | -89.8267099 | 2022-07-14 04:20:57 | Jefferson Davis, Mississippi, US | |
631726 | 631726 | 2022-07-12 | US | Mississippi | Jefferson Davis | 28065 | 3031 | 55 | 0 | 31.56884708 | -89.8267099 | 2022-07-13 04:20:58 | Jefferson Davis, Mississippi, US | |
1213370 | 1213370 | 2022-07-11 | US | Mississippi | Jefferson Davis | 28065 | 3031 | 55 | 0 | 31.56884708 | -89.8267099 | 2022-07-12 04:20:51 | Jefferson Davis, Mississippi, US | |
1211915 | 1211915 | 2022-07-11 | US | Alabama | Conecuh | 1035 | 3031 | 70 | 0 | 31.43401703 | -86.99320044 | 2022-07-12 04:20:51 | Conecuh, Alabama, US | |
1420157 | 1420157 | 2022-07-08 | US | Texas | Dawson | 48115 | 3031 | 95 | 0 | 32.74255572 | -101.9477242 | 2022-07-09 04:20:59 | Dawson, Texas, US | |
166408 | 166408 | 2022-06-21 | US | Alabama | Coosa | 1037 | 3031 | 58 | 0 | 32.93690146 | -86.24847739 | 2022-06-22 04:20:54 | Coosa, Alabama, US | |
2235852 | 2235852 | 2022-06-12 | US | Arkansas | Bradley | 5011 | 3031 | 50 | 0 | 33.46755808 | -92.15980837 | 2022-06-13 04:21:14 | Bradley, Arkansas, US | |
3159417 | 3159417 | 2022-06-09 | US | Minnesota | Watonwan | 27165 | 3031 | 24 | 0 | 43.97823903 | -94.61413846 | 2022-06-10 04:20:55 | Watonwan, Minnesota, US | |
3186639 | 3186639 | 2022-05-30 | US | Colorado | Park | 8093 | 3031 | 21 | 0 | 39.120926 | -105.7182065 | 2022-05-31 04:20:51 | Park, Colorado, US | |
3198788 | 3198788 | 2022-05-29 | US | Colorado | Park | 8093 | 3031 | 21 | 0 | 39.120926 | -105.7182065 | 2022-05-30 04:20:50 | Park, Colorado, US | |
1187133 | 1187133 | 2022-05-18 | US | North Dakota | Barnes | 38003 | 3031 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-05-19 04:20:54 | Barnes, North Dakota, US | |
1185229 | 1185229 | 2022-05-18 | US | Arkansas | Desha | 5041 | 3031 | 41 | 0 | 33.83011025 | -91.25500948 | 2022-05-19 04:20:54 | Desha, Arkansas, US | |
3585030 | 3585030 | 2022-05-17 | US | North Dakota | Barnes | 38003 | 3031 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-05-18 04:20:50 | Barnes, North Dakota, US | |
3583126 | 3583126 | 2022-05-17 | US | Arkansas | Desha | 5041 | 3031 | 41 | 0 | 33.83011025 | -91.25500948 | 2022-05-18 04:20:50 | Desha, Arkansas, US | |
1504083 | 1504083 | 2022-05-16 | US | Arkansas | Desha | 5041 | 3031 | 41 | 0 | 33.83011025 | -91.25500948 | 2022-05-17 04:20:59 | Desha, Arkansas, US | |
2084442 | 2084442 | 2022-05-15 | US | Arkansas | Desha | 5041 | 3031 | 41 | 0 | 33.83011025 | -91.25500948 | 2022-05-16 04:20:47 | Desha, Arkansas, US | |
463182 | 463182 | 2022-05-02 | China | Fujian | 3031 | 1 | 0 | 26.0789 | 117.9874 | 2022-05-03 04:21:00 | Fujian, China | |||
2309850 | 2309850 | 2022-04-20 | US | Oklahoma | Johnston | 40069 | 3031 | 54 | 0 | 34.31440473 | -96.66011537 | 2022-04-21 04:20:46 | Johnston, Oklahoma, US | |
2253989 | 2253989 | 2022-04-19 | US | Oklahoma | Johnston | 40069 | 3031 | 54 | 0 | 34.31440473 | -96.66011537 | 2022-04-20 04:20:45 | Johnston, Oklahoma, US | |
1848539 | 1848539 | 2022-04-18 | US | Oklahoma | Johnston | 40069 | 3031 | 54 | 0 | 34.31440473 | -96.66011537 | 2022-04-19 04:21:00 | Johnston, Oklahoma, US | |
3419483 | 3419483 | 2022-04-17 | US | Oklahoma | Johnston | 40069 | 3031 | 54 | 0 | 34.31440473 | -96.66011537 | 2022-04-18 04:21:12 | Johnston, Oklahoma, US | |
306432 | 306432 | 2022-04-16 | US | Oklahoma | Johnston | 40069 | 3031 | 54 | 0 | 34.31440473 | -96.66011537 | 2022-04-17 04:20:59 | Johnston, Oklahoma, US | |
2672377 | 2672377 | 2022-04-15 | US | Oklahoma | Johnston | 40069 | 3031 | 54 | 0 | 34.31440473 | -96.66011537 | 2022-04-16 04:20:48 | Johnston, Oklahoma, US | |
1226162 | 1226162 | 2022-04-14 | US | Oklahoma | Johnston | 40069 | 3031 | 54 | 0 | 34.31440473 | -96.66011537 | 2022-04-15 04:20:57 | Johnston, Oklahoma, US | |
1950270 | 1950270 | 2022-04-12 | US | Minnesota | Pope | 27121 | 3031 | 17 | 0 | 45.58606667 | -95.44451209 | 2022-04-13 04:21:03 | Pope, Minnesota, US | |
1949073 | 1949073 | 2022-04-12 | US | California | Mariposa | 6043 | 3031 | 34 | 0 | 37.57978556 | -119.9073334 | 2022-04-13 04:21:03 | Mariposa, California, US | |
3208023 | 3208023 | 2022-04-11 | US | Minnesota | Pope | 27121 | 3031 | 17 | 0 | 45.58606667 | -95.44451209 | 2022-04-12 04:20:49 | Pope, Minnesota, US | |
2803340 | 2803340 | 2022-04-06 | US | Oklahoma | Johnston | 40069 | 3031 | 53 | 0 | 34.31440473 | -96.66011537 | 2022-04-07 04:20:53 | Johnston, Oklahoma, US | |
3870109 | 3870109 | 2022-04-05 | US | Oklahoma | Johnston | 40069 | 3031 | 53 | 0 | 34.31440473 | -96.66011537 | 2022-04-06 04:20:49 | Johnston, Oklahoma, US | |
2751451 | 2751451 | 2022-04-04 | US | Oklahoma | Johnston | 40069 | 3031 | 53 | 0 | 34.31440473 | -96.66011537 | 2022-04-05 04:20:48 | Johnston, Oklahoma, US | |
3732797 | 3732797 | 2022-04-03 | US | Oklahoma | Johnston | 40069 | 3031 | 53 | 0 | 34.31440473 | -96.66011537 | 2022-04-04 04:20:51 | Johnston, Oklahoma, US | |
502390 | 502390 | 2022-04-02 | US | Puerto Rico | Barceloneta | 72017 | 3031 | 0 | 0 | 18.445532999999998 | -66.56053100000001 | 2022-04-03 04:20:48 | Barceloneta, Puerto Rico, US | |
502232 | 502232 | 2022-04-02 | US | Oklahoma | Johnston | 40069 | 3031 | 53 | 0 | 34.31440473 | -96.66011537 | 2022-04-03 04:20:48 | Johnston, Oklahoma, US | |
3353217 | 3353217 | 2022-04-01 | US | Oklahoma | Johnston | 40069 | 3031 | 53 | 0 | 34.31440473 | -96.66011537 | 2022-04-02 04:20:47 | Johnston, Oklahoma, US | |
1542522 | 1542522 | 2022-03-31 | US | Oklahoma | Johnston | 40069 | 3031 | 53 | 0 | 34.31440473 | -96.66011537 | 2022-04-01 04:20:28 | Johnston, Oklahoma, US | |
25985 | 25985 | 2022-03-20 | US | Maryland | Kent | 24029 | 3031 | 66 | 0 | 39.24976208 | -76.04741541 | 2022-03-21 04:20:50 | Kent, Maryland, US | |
1994499 | 1994499 | 2022-03-01 | US | Mississippi | Perry | 28111 | 3031 | 63 | 0 | 31.17161885 | -88.99281835 | 2022-03-02 04:21:07 | Perry, Mississippi, US | |
944673 | 944673 | 2022-02-28 | US | Mississippi | Perry | 28111 | 3031 | 63 | 0 | 31.17161885 | -88.99281835 | 2022-03-01 04:21:09 | Perry, Mississippi, US | |
3913150 | 3913150 | 2022-02-20 | US | Indiana | Pulaski | 18131 | 3031 | 83 | 0 | 41.04166107 | -86.69890683 | 2022-02-21 04:21:05 | Pulaski, Indiana, US | |
3876708 | 3876708 | 2022-02-19 | US | Indiana | Pulaski | 18131 | 3031 | 83 | 0 | 41.04166107 | -86.69890683 | 2022-02-20 04:21:00 | Pulaski, Indiana, US | |
3856964 | 3856964 | 2022-02-18 | US | Indiana | Pulaski | 18131 | 3031 | 83 | 0 | 41.04166107 | -86.69890683 | 2022-02-19 04:21:11 | Pulaski, Indiana, US | |
1466850 | 1466850 | 2022-02-10 | US | Puerto Rico | Naguabo | 72103 | 3031 | 0 | 0 | 18.230636999999998 | -65.753897 | 2022-02-11 04:21:09 | Naguabo, Puerto Rico, US | |
2014641 | 2014641 | 2022-02-06 | US | Missouri | Mississippi | 29133 | 3031 | 52 | 0 | 36.82516239 | -89.29505753 | 2022-02-07 04:21:05 | Mississippi, Missouri, US | |
1295970 | 1295970 | 2022-02-05 | US | Missouri | Mississippi | 29133 | 3031 | 52 | 0 | 36.82516239 | -89.29505753 | 2022-02-06 04:21:00 | Mississippi, Missouri, US | |
3302705 | 3302705 | 2022-01-30 | US | Ohio | Morgan | 39115 | 3031 | 49 | 0 | 39.62081738 | -81.85308173 | 2022-01-31 04:21:09 | Morgan, Ohio, US | |
3302151 | 3302151 | 2022-01-30 | US | Missouri | Osage | 29151 | 3031 | 39 | 0 | 38.46036182 | -91.8613635 | 2022-01-31 04:21:09 | Osage, Missouri, US | |
3065056 | 3065056 | 2022-01-29 | US | Texas | Comanche | 48093 | 3031 | 72 | 0 | 31.94854689 | -98.55876441 | 2022-01-30 04:21:26 | Comanche, Texas, US | |
3064496 | 3064496 | 2022-01-29 | US | Ohio | Morgan | 39115 | 3031 | 49 | 0 | 39.62081738 | -81.85308173 | 2022-01-30 04:21:26 | Morgan, Ohio, US | |
2054637 | 2054637 | 2022-01-25 | US | Puerto Rico | Lares | 72081 | 3031 | 0 | 0 | 18.269035000000002 | -66.867236 | 2022-01-26 04:21:07 | Lares, Puerto Rico, US | |
1218651 | 1218651 | 2022-01-08 | US | Texas | Falls | 48145 | 3031 | 52 | 0 | 31.25350609 | -96.93630086 | 2022-01-09 04:21:46 | Falls, Texas, US | |
1703882 | 1703882 | 2022-01-03 | US | Wisconsin | Burnett | 55013 | 3031 | 36 | 0 | 45.86303537 | -92.36711412 | 2022-01-04 04:22:17 | Burnett, Wisconsin, US | |
801103 | 801103 | 2021-12-22 | US | Pennsylvania | Fulton | 42057 | 3031 | 44 | 0 | 39.92913544 | -78.11163677 | 2021-12-23 04:21:21 | Fulton, Pennsylvania, US | |
1256236 | 1256236 | 2021-12-20 | US | Kentucky | Powell | 21197 | 3031 | 27 | 0 | 37.83218794 | -83.82553961 | 2021-12-21 03:21:27 | Powell, Kentucky, US | |
550623 | 550623 | 2021-12-08 | Colombia | Vichada | 3031 | 53 | 0 | 4.4234 | -69.2878 | 2021-12-09 04:22:49 | Vichada, Colombia | |||
404143 | 404143 | 2021-12-07 | Colombia | Vichada | 3031 | 53 | 0 | 4.4234 | -69.2878 | 2021-12-08 04:22:46 | Vichada, Colombia | |||
1030225 | 1030225 | 2021-12-06 | Colombia | Vichada | 3031 | 53 | 0 | 4.4234 | -69.2878 | 2021-12-07 04:22:34 | Vichada, Colombia | |||
2197179 | 2197179 | 2021-12-03 | US | Maine | Franklin | 23007 | 3031 | 35 | 0 | 44.97330019 | -70.44381045 | 2021-12-04 04:22:18 | Franklin, Maine, US | |
1803225 | 1803225 | 2021-11-25 | US | Arkansas | Cross | 5037 | 3031 | 66 | 0 | 35.29631396 | -90.77185818 | 2021-11-26 04:22:33 | Cross, Arkansas, US | |
904659 | 904659 | 2021-11-24 | US | Arkansas | Cross | 5037 | 3031 | 66 | 0 | 35.29631396 | -90.77185818 | 2021-11-25 04:22:33 | Cross, Arkansas, US | |
3073183 | 3073183 | 2021-11-23 | US | Texas | Lee | 48287 | 3031 | 54 | 0 | 30.31120597 | -96.97045773 | 2021-11-24 04:22:14 | Lee, Texas, 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]);