johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
173 rows where confirmed = 3889 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2557216 | 2557216 | 2022-11-29 | US | Colorado | Gunnison | 8051 | 3889 | 16 | 0 | 38.66611652 | -107.0320729 | 2022-11-30 04:21:07 | Gunnison, Colorado, US | |
3312048 | 3312048 | 2022-11-23 | China | Zhejiang | 3889 | 1 | 0 | 29.1832 | 120.0934 | 2022-11-24 04:21:09 | Zhejiang, China | |||
797192 | 797192 | 2022-10-24 | US | Puerto Rico | Rincon | 72117 | 3889 | 0 | 0 | 18.335443 | -67.23174 | 2022-10-25 04:21:53 | Rincon, Puerto Rico, US | |
2759359 | 2759359 | 2022-10-18 | US | North Dakota | Walsh | 38099 | 3889 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-10-19 04:22:26 | Walsh, North Dakota, US | |
375781 | 375781 | 2022-09-13 | US | Wisconsin | Rusk | 55107 | 3889 | 59 | 0 | 45.47498854 | -91.1333012 | 2022-09-14 04:20:44 | Rusk, Wisconsin, US | |
2346704 | 2346704 | 2022-08-31 | US | Utah | Unassigned | 90049 | 3889 | 7 | 0 | 41.72330587 | 0.0 | 2022-09-01 04:21:03 | Unassigned, Utah, US | |
3777184 | 3777184 | 2022-08-30 | US | Utah | Unassigned | 90049 | 3889 | 7 | 0 | 41.72330587 | 0.0 | 2022-08-31 04:20:57 | Unassigned, Utah, US | |
1683780 | 1683780 | 2022-08-29 | US | Utah | Unassigned | 90049 | 3889 | 7 | 0 | 41.72330587 | 0.0 | 2022-08-30 04:21:03 | Unassigned, Utah, US | |
1880264 | 1880264 | 2022-08-28 | US | Utah | Unassigned | 90049 | 3889 | 7 | 0 | 41.72330587 | 0.0 | 2022-08-29 04:21:06 | Unassigned, Utah, US | |
2099391 | 2099391 | 2022-08-27 | US | Utah | Unassigned | 90049 | 3889 | 7 | 0 | 41.72330587 | 0.0 | 2022-08-28 04:21:02 | Unassigned, Utah, US | |
1535206 | 1535206 | 2022-08-26 | US | Utah | Unassigned | 90049 | 3889 | 7 | 0 | 41.72330587 | 0.0 | 2022-08-27 04:20:57 | Unassigned, Utah, US | |
2832093 | 2832093 | 2022-08-25 | US | Utah | Unassigned | 90049 | 3889 | 7 | 0 | 41.72330587 | 0.0 | 2022-08-26 04:21:02 | Unassigned, Utah, US | |
2829350 | 2829350 | 2022-08-25 | US | Arkansas | Van Buren | 5141 | 3889 | 63 | 0 | 35.58095779 | -92.51295036 | 2022-08-26 04:21:02 | Van Buren, Arkansas, US | |
3544483 | 3544483 | 2022-08-08 | US | Illinois | Greene | 17061 | 3889 | 46 | 0 | 39.35907414 | -90.388865 | 2022-08-09 04:20:34 | Greene, Illinois, US | |
1067375 | 1067375 | 2022-07-28 | US | Louisiana | Caldwell | 22021 | 3889 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-07-29 04:20:45 | Caldwell, Louisiana, US | |
3429992 | 3429992 | 2022-07-14 | US | Illinois | Menard | 17129 | 3889 | 22 | 0 | 40.02742725 | -89.80246001 | 2022-07-15 04:20:53 | Menard, Illinois, US | |
2743948 | 2743948 | 2022-07-07 | US | Tennessee | Decatur | 47039 | 3889 | 71 | 0 | 35.60048904 | -88.11043779 | 2022-07-08 04:20:56 | Decatur, Tennessee, US | |
2743282 | 2743282 | 2022-07-07 | US | New York | Schuyler | 36097 | 3889 | 28 | 0 | 42.39184015 | -76.8773299 | 2022-07-08 04:20:56 | Schuyler, New York, US | |
2742949 | 2742949 | 2022-07-07 | US | Missouri | Moniteau | 29135 | 3889 | 57 | 0 | 38.63571781 | -92.57976951 | 2022-07-08 04:20:56 | Moniteau, Missouri, US | |
1202077 | 1202077 | 2022-07-06 | US | New York | Schuyler | 36097 | 3889 | 28 | 0 | 42.39184015 | -76.8773299 | 2022-07-07 04:20:55 | Schuyler, New York, US | |
1201744 | 1201744 | 2022-07-06 | US | Missouri | Moniteau | 29135 | 3889 | 57 | 0 | 38.63571781 | -92.57976951 | 2022-07-07 04:20:55 | Moniteau, Missouri, US | |
3968487 | 3968487 | 2022-07-05 | US | Missouri | Moniteau | 29135 | 3889 | 57 | 0 | 38.63571781 | -92.57976951 | 2022-07-06 04:20:58 | Moniteau, Missouri, US | |
3079998 | 3079998 | 2022-07-04 | US | Missouri | Moniteau | 29135 | 3889 | 57 | 0 | 38.63571781 | -92.57976951 | 2022-07-05 04:20:45 | Moniteau, Missouri, US | |
1769280 | 1769280 | 2022-07-03 | US | Missouri | Moniteau | 29135 | 3889 | 57 | 0 | 38.63571781 | -92.57976951 | 2022-07-04 04:20:54 | Moniteau, Missouri, US | |
3367266 | 3367266 | 2022-07-02 | US | Missouri | Moniteau | 29135 | 3889 | 57 | 0 | 38.63571781 | -92.57976951 | 2022-07-03 04:20:59 | Moniteau, Missouri, US | |
595595 | 595595 | 2022-07-01 | US | Missouri | Moniteau | 29135 | 3889 | 57 | 0 | 38.63571781 | -92.57976951 | 2022-07-02 04:21:16 | Moniteau, Missouri, US | |
1766341 | 1766341 | 2022-06-20 | US | Texas | Andrews | 48003 | 3889 | 72 | 0 | 32.30468633 | -102.6376548 | 2022-06-21 04:20:56 | Andrews, Texas, US | |
3272527 | 3272527 | 2022-06-19 | US | Texas | Andrews | 48003 | 3889 | 72 | 0 | 32.30468633 | -102.6376548 | 2022-06-20 04:21:01 | Andrews, Texas, US | |
3400439 | 3400439 | 2022-06-18 | US | Texas | Andrews | 48003 | 3889 | 72 | 0 | 32.30468633 | -102.6376548 | 2022-06-19 04:20:51 | Andrews, Texas, US | |
2314316 | 2314316 | 2022-06-17 | US | Texas | Andrews | 48003 | 3889 | 72 | 0 | 32.30468633 | -102.6376548 | 2022-06-18 04:21:10 | Andrews, Texas, US | |
947215 | 947215 | 2022-06-14 | US | Alabama | Crenshaw | 1041 | 3889 | 100 | 0 | 31.72941803 | -86.31593104 | 2022-06-15 04:20:54 | Crenshaw, Alabama, US | |
3510844 | 3510844 | 2022-06-05 | US | Washington | Pacific | 53049 | 3889 | 59 | 0 | 46.55418369 | -123.7285716 | 2022-06-06 04:20:57 | Pacific, Washington, US | |
3530921 | 3530921 | 2022-06-04 | US | Washington | Pacific | 53049 | 3889 | 59 | 0 | 46.55418369 | -123.7285716 | 2022-06-05 04:20:55 | Pacific, Washington, US | |
3137007 | 3137007 | 2022-06-03 | US | Washington | Pacific | 53049 | 3889 | 59 | 0 | 46.55418369 | -123.7285716 | 2022-06-04 04:20:58 | Pacific, Washington, US | |
974012 | 974012 | 2022-06-01 | US | Texas | Freestone | 48161 | 3889 | 82 | 0 | 31.70422788 | -96.15072516 | 2022-06-02 05:20:39 | Freestone, Texas, US | |
3200909 | 3200909 | 2022-05-29 | US | Puerto Rico | Orocovis | 72107 | 3889 | 0 | 0 | 18.215046 | -66.433604 | 2022-05-30 04:20:50 | Orocovis, Puerto Rico, US | |
2050626 | 2050626 | 2022-05-25 | US | Puerto Rico | Loiza | 72087 | 3889 | 0 | 0 | 18.425688 | -65.89943 | 2022-05-26 04:20:50 | Loiza, Puerto Rico, US | |
3001024 | 3001024 | 2022-05-24 | US | Minnesota | Faribault | 27043 | 3889 | 53 | 0 | 43.67381499 | -93.94787458 | 2022-05-25 04:20:56 | Faribault, Minnesota, US | |
624637 | 624637 | 2022-05-22 | US | Puerto Rico | Loiza | 72087 | 3889 | 0 | 0 | 18.425688 | -65.89943 | 2022-05-26 04:20:50 | Loiza, Puerto Rico, US | |
3855105 | 3855105 | 2022-04-27 | US | Vermont | Lamoille | 50015 | 3889 | 16 | 0 | 44.60353043 | -72.64356694 | 2022-04-28 04:20:47 | Lamoille, Vermont, US | |
3206761 | 3206761 | 2022-04-11 | US | Arkansas | Izard | 5065 | 3889 | 69 | 0 | 36.09604046 | -91.90847954 | 2022-04-12 04:20:49 | Izard, Arkansas, US | |
1576647 | 1576647 | 2022-04-10 | US | Arkansas | Izard | 5065 | 3889 | 69 | 0 | 36.09604046 | -91.90847954 | 2022-04-11 04:21:02 | Izard, Arkansas, US | |
2802536 | 2802536 | 2022-04-06 | US | Minnesota | Redwood | 27127 | 3889 | 53 | 0 | 44.40555844 | -95.25207021 | 2022-04-07 04:20:53 | Redwood, Minnesota, US | |
1543119 | 1543119 | 2022-03-31 | US | Texas | Llano | 48299 | 3889 | 97 | 0 | 30.70645047 | -98.68475262 | 2022-04-01 04:20:28 | Llano, Texas, US | |
1540979 | 1540979 | 2022-03-31 | US | Illinois | Mason | 17125 | 3889 | 60 | 0 | 40.23917274 | -89.91824452 | 2022-04-01 04:20:28 | Mason, Illinois, US | |
2478992 | 2478992 | 2022-03-30 | US | Illinois | Mason | 17125 | 3889 | 60 | 0 | 40.23917274 | -89.91824452 | 2022-03-31 04:20:56 | Mason, Illinois, US | |
159033 | 159033 | 2022-03-29 | US | Illinois | Mason | 17125 | 3889 | 60 | 0 | 40.23917274 | -89.91824452 | 2022-03-30 04:20:45 | Mason, Illinois, US | |
1437604 | 1437604 | 2022-03-28 | US | Illinois | Mason | 17125 | 3889 | 60 | 0 | 40.23917274 | -89.91824452 | 2022-03-29 04:20:46 | Mason, Illinois, US | |
1908670 | 1908670 | 2022-03-22 | US | West Virginia | Braxton | 54007 | 3889 | 42 | 0 | 38.70036159 | -80.72011184 | 2022-03-23 04:20:48 | Braxton, West Virginia, US | |
2267155 | 2267155 | 2022-03-14 | US | Texas | Young | 48503 | 3889 | 89 | 0 | 33.17659707 | -98.68790885 | 2022-03-15 04:20:47 | Young, Texas, US | |
3631221 | 3631221 | 2022-03-13 | US | Texas | Young | 48503 | 3889 | 89 | 0 | 33.17659707 | -98.68790885 | 2022-03-14 04:20:46 | Young, Texas, US | |
3629285 | 3629285 | 2022-03-13 | US | Kansas | Osage | 20139 | 3889 | 45 | 0 | 38.65235984 | -95.72707998 | 2022-03-14 04:20:46 | Osage, Kansas, US | |
954129 | 954129 | 2022-03-12 | US | Texas | Young | 48503 | 3889 | 89 | 0 | 33.17659707 | -98.68790885 | 2022-03-13 04:20:49 | Young, Texas, US | |
952193 | 952193 | 2022-03-12 | US | Kansas | Osage | 20139 | 3889 | 45 | 0 | 38.65235984 | -95.72707998 | 2022-03-13 04:20:49 | Osage, Kansas, US | |
359590 | 359590 | 2022-03-11 | US | Texas | Young | 48503 | 3889 | 89 | 0 | 33.17659707 | -98.68790885 | 2022-03-12 04:20:50 | Young, Texas, US | |
357654 | 357654 | 2022-03-11 | US | Kansas | Osage | 20139 | 3889 | 45 | 0 | 38.65235984 | -95.72707998 | 2022-03-12 04:20:50 | Osage, Kansas, US | |
1866806 | 1866806 | 2022-03-10 | US | Kansas | Osage | 20139 | 3889 | 44 | 0 | 38.65235984 | -95.72707998 | 2022-03-11 04:20:50 | Osage, Kansas, US | |
1866291 | 1866291 | 2022-03-10 | US | Georgia | Greene | 13133 | 3889 | 81 | 0 | 33.5769205 | -83.17139104 | 2022-03-11 04:20:50 | Greene, Georgia, US | |
2141501 | 2141501 | 2022-03-09 | US | Kansas | Osage | 20139 | 3889 | 44 | 0 | 38.65235984 | -95.72707998 | 2022-03-10 04:20:48 | Osage, Kansas, US | |
2140986 | 2140986 | 2022-03-09 | US | Georgia | Greene | 13133 | 3889 | 80 | 0 | 33.5769205 | -83.17139104 | 2022-03-10 04:20:48 | Greene, Georgia, US | |
1512235 | 1512235 | 2022-02-24 | US | Georgia | Jeff Davis | 13161 | 3889 | 66 | 0 | 31.80405727 | -82.63724870000001 | 2022-02-25 04:21:11 | Jeff Davis, Georgia, US | |
3915368 | 3915368 | 2022-02-20 | US | Virginia | Greene | 51079 | 3889 | 57 | 0 | 38.29545894 | -78.46525378 | 2022-02-21 04:21:05 | Greene, Virginia, US | |
3878926 | 3878926 | 2022-02-19 | US | Virginia | Greene | 51079 | 3889 | 57 | 0 | 38.29545894 | -78.46525378 | 2022-02-20 04:21:00 | Greene, Virginia, US | |
3859182 | 3859182 | 2022-02-18 | US | Virginia | Greene | 51079 | 3889 | 57 | 0 | 38.29545894 | -78.46525378 | 2022-02-19 04:21:11 | Greene, Virginia, US | |
3075538 | 3075538 | 2022-02-09 | US | Louisiana | Bienville | 22013 | 3889 | 103 | 0 | 32.34569994 | -93.05398492 | 2022-02-10 04:21:14 | Bienville, Louisiana, US | |
3075072 | 3075072 | 2022-02-09 | US | Illinois | Mercer | 17131 | 3889 | 43 | 0 | 41.20596782 | -90.74290052 | 2022-02-10 04:21:14 | Mercer, Illinois, US | |
980672 | 980672 | 2022-02-01 | US | Minnesota | Houston | 27055 | 3889 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-02-02 04:21:09 | Houston, Minnesota, US | |
2054647 | 2054647 | 2022-01-25 | US | Puerto Rico | Morovis | 72101 | 3889 | 0 | 0 | 18.316963 | -66.420383 | 2022-01-26 04:21:07 | Morovis, Puerto Rico, US | |
1143635 | 1143635 | 2022-01-23 | US | Puerto Rico | Barranquitas | 72019 | 3889 | 0 | 0 | 18.201592 | -66.30963 | 2022-01-24 04:21:12 | Barranquitas, Puerto Rico, US | |
3229143 | 3229143 | 2022-01-19 | US | Pennsylvania | Montour | 42093 | 3889 | 83 | 0 | 41.03023987 | -76.66345939 | 2022-01-20 04:21:07 | Montour, Pennsylvania, US | |
558286 | 558286 | 2022-01-16 | US | West Virginia | McDowell | 54047 | 3889 | 56 | 0 | 37.38002939 | -81.65083669 | 2022-01-17 04:21:08 | McDowell, West Virginia, US | |
1717173 | 1717173 | 2021-12-16 | US | Georgia | Harris | 13145 | 3889 | 96 | 0 | 32.73709786 | -84.90538572 | 2021-12-17 04:22:14 | Harris, Georgia, US | |
1080863 | 1080863 | 2021-12-09 | US | Tennessee | Fentress | 47049 | 3889 | 72 | 0 | 36.38128818 | -84.92870012 | 2021-12-10 04:22:28 | Fentress, Tennessee, US | |
1031237 | 1031237 | 2021-12-06 | US | Georgia | Pike | 13231 | 3889 | 71 | 0 | 33.09310242 | -84.38790389 | 2021-12-07 04:22:34 | Pike, Georgia, US | |
724974 | 724974 | 2021-11-20 | US | Ohio | Hocking | 39073 | 3889 | 95 | 0 | 39.49537927 | -82.47991446 | 2021-11-21 04:22:13 | Hocking, Ohio, US | |
165006 | 165006 | 2021-11-19 | US | Tennessee | Morgan | 47129 | 3889 | 50 | 0 | 36.13248031 | -84.64880098 | 2021-11-20 04:22:17 | Morgan, Tennessee, US | |
162501 | 162501 | 2021-11-19 | US | Arkansas | Cleburne | 5023 | 3889 | 94 | 0 | 35.53864922 | -92.02640019 | 2021-11-20 04:22:17 | Cleburne, Arkansas, US | |
717250 | 717250 | 2021-11-12 | US | Puerto Rico | Trujillo Alto | 72139 | 3889 | 0 | 0 | 18.336159 | -65.99888399999999 | 2021-11-13 04:21:38 | Trujillo Alto, Puerto Rico, US | |
2004201 | 2004201 | 2021-11-07 | US | Wisconsin | Door | 55029 | 3889 | 41 | 0 | 44.95856458 | -87.30002707 | 2021-11-08 04:21:43 | Door, Wisconsin, US | |
499192 | 499192 | 2021-11-06 | US | Wisconsin | Door | 55029 | 3889 | 41 | 0 | 44.95856458 | -87.30002707 | 2021-11-07 04:21:53 | Door, Wisconsin, US | |
3125047 | 3125047 | 2021-11-05 | US | Wisconsin | Door | 55029 | 3889 | 41 | 0 | 44.95856458 | -87.30002707 | 2021-11-06 04:21:51 | Door, Wisconsin, US | |
7695 | 7695 | 2021-10-28 | US | Virginia | Halifax | 51083 | 3889 | 104 | 0 | 36.76654925 | -78.93512622 | 2021-10-29 04:22:03 | Halifax, Virginia, US | |
537347 | 537347 | 2021-10-27 | US | Oregon | Columbia | 41009 | 3889 | 44 | 0 | 45.94464254 | -123.08908980000001 | 2021-10-28 04:22:08 | Columbia, Oregon, US | |
599680 | 599680 | 2021-10-19 | US | Montana | Lake | 30047 | 3889 | 58 | 0 | 47.64514965 | -114.0898013 | 2021-10-20 04:21:00 | Lake, Montana, US | |
2046638 | 2046638 | 2021-10-18 | US | Puerto Rico | Vega Baja | 72145 | 3889 | 0 | 0 | 18.428262 | -66.397924 | 2021-10-19 04:20:54 | Vega Baja, Puerto Rico, US | |
2962857 | 2962857 | 2021-10-08 | US | West Virginia | Hancock | 54029 | 3889 | 103 | 0 | 40.51943859 | -80.57461608 | 2021-10-09 04:21:34 | Hancock, West Virginia, US | |
469117 | 469117 | 2021-10-07 | US | Minnesota | Cass | 27021 | 3889 | 41 | 0 | 46.95043611 | -94.32603968 | 2021-10-08 04:21:25 | Cass, Minnesota, US | |
2776537 | 2776537 | 2021-09-30 | US | Wisconsin | Lincoln | 55069 | 3889 | 106 | 0 | 45.33737523 | -89.73411273 | 2021-10-01 04:21:35 | Lincoln, Wisconsin, US | |
810729 | 810729 | 2021-09-20 | US | Indiana | White | 18181 | 3889 | 57 | 0 | 40.74911165 | -86.86492015 | 2021-09-21 04:21:26 | White, Indiana, US | |
1816220 | 1816220 | 2021-09-19 | US | Kentucky | Mercer | 21167 | 3889 | 60 | 0 | 37.81474237 | -84.87488475 | 2021-09-20 04:21:22 | Mercer, Kentucky, US | |
17759 | 17759 | 2021-09-18 | US | Kentucky | Grayson | 21085 | 3889 | 71 | 0 | 37.46231118 | -86.34248968 | 2021-09-19 04:21:34 | Grayson, Kentucky, US | |
1374838 | 1374838 | 2021-09-15 | US | Alabama | Bibb | 1007 | 3889 | 75 | 0 | 32.99642064 | -87.12511459999996 | 2021-09-16 04:22:19 | Bibb, Alabama, US | |
2465009 | 2465009 | 2021-09-14 | US | New York | Allegany | 36003 | 3889 | 91 | 0 | 42.25748406 | -78.02750466 | 2021-09-15 03:22:37 | Allegany, New York, US | |
3806448 | 3806448 | 2021-09-11 | US | California | Glenn | 6021 | 3889 | 20 | 0 | 39.59875897 | -122.3938452 | 2021-09-12 04:21:13 | Glenn, California, US | |
1264313 | 1264313 | 2021-09-09 | US | Louisiana | Richland | 22083 | 3889 | 72 | 0 | 32.41391005 | -91.76634876 | 2021-09-10 04:21:20 | Richland, Louisiana, US | |
1777205 | 1777205 | 2021-08-30 | US | Mississippi | Tate | 28137 | 3889 | 90 | 0 | 34.65133709 | -89.94485778 | 2021-08-31 04:21:46 | Tate, Mississippi, US | |
1856488 | 1856488 | 2021-08-20 | US | Ohio | Ottawa | 39123 | 3889 | 83 | 0 | 41.53781826 | -83.0940185 | 2021-08-21 04:21:38 | Ottawa, Ohio, US | |
1344564 | 1344564 | 2021-08-11 | US | New York | Warren | 36113 | 3889 | 64 | 0 | 43.56173026 | -73.8433699 | 2021-08-12 04:21:25 | Warren, New York, US | |
593193 | 593193 | 2021-08-08 | US | Wisconsin | Oneida | 55085 | 3889 | 82 | 0 | 45.70677897 | -89.51944105 | 2021-08-09 04:21:24 | Oneida, Wisconsin, US | |
2207205 | 2207205 | 2021-08-07 | US | Wisconsin | Oneida | 55085 | 3889 | 82 | 0 | 45.70677897 | -89.51944105 | 2021-08-08 04:21:33 | Oneida, Wisconsin, 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]);