johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
168 rows where confirmed = 4344 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1076197 | 1076197 | 2022-12-28 | US | New York | Yates | 36123 | 4344 | 42 | 0 | 42.63505484 | -77.10369919 | 2022-12-29 04:21:01 | Yates, New York, US | |
330194 | 330194 | 2022-12-27 | US | New York | Yates | 36123 | 4344 | 42 | 0 | 42.63505484 | -77.10369919 | 2022-12-28 04:21:04 | Yates, New York, US | |
329407 | 329407 | 2022-12-27 | US | Louisiana | Caldwell | 22021 | 4344 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-12-28 04:21:04 | Caldwell, Louisiana, US | |
219480 | 219480 | 2022-12-26 | US | Louisiana | Caldwell | 22021 | 4344 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-12-27 04:21:07 | Caldwell, Louisiana, US | |
3223937 | 3223937 | 2022-12-25 | US | Louisiana | Caldwell | 22021 | 4344 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-12-26 04:21:06 | Caldwell, Louisiana, US | |
1019851 | 1019851 | 2022-12-24 | US | Louisiana | Caldwell | 22021 | 4344 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-12-25 04:21:04 | Caldwell, Louisiana, US | |
691874 | 691874 | 2022-12-23 | US | Louisiana | Caldwell | 22021 | 4344 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-12-24 04:21:02 | Caldwell, Louisiana, US | |
2181084 | 2181084 | 2022-12-22 | US | Louisiana | Caldwell | 22021 | 4344 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-12-23 04:21:04 | Caldwell, Louisiana, US | |
452888 | 452888 | 2022-12-21 | US | Louisiana | Caldwell | 22021 | 4344 | 55 | 0 | 32.0902519 | -92.11752148 | 2022-12-22 04:20:56 | Caldwell, Louisiana, US | |
3717547 | 3717547 | 2022-12-06 | US | Virginia | Martinsville | 51690 | 4344 | 123 | 0 | 36.68212094 | -79.86352771 | 2022-12-07 04:20:58 | Martinsville, Virginia, US | |
2418252 | 2418252 | 2022-12-05 | US | Virginia | Martinsville | 51690 | 4344 | 123 | 0 | 36.68212094 | -79.86352771 | 2022-12-06 04:21:03 | Martinsville, Virginia, US | |
3598905 | 3598905 | 2022-11-14 | US | Mississippi | Walthall | 28147 | 4344 | 83 | 0 | 31.14971548 | -90.10446654 | 2022-11-15 04:21:16 | Walthall, Mississippi, US | |
313763 | 313763 | 2022-11-13 | US | Mississippi | Walthall | 28147 | 4344 | 83 | 0 | 31.14971548 | -90.10446654 | 2022-11-14 04:21:09 | Walthall, Mississippi, US | |
64924 | 64924 | 2022-11-12 | US | Mississippi | Walthall | 28147 | 4344 | 83 | 0 | 31.14971548 | -90.10446654 | 2022-11-13 04:21:14 | Walthall, Mississippi, US | |
2929086 | 2929086 | 2022-11-11 | US | Mississippi | Walthall | 28147 | 4344 | 83 | 0 | 31.14971548 | -90.10446654 | 2022-11-12 04:20:41 | Walthall, Mississippi, US | |
2507922 | 2507922 | 2022-11-10 | US | Mississippi | Walthall | 28147 | 4344 | 83 | 0 | 31.14971548 | -90.10446654 | 2022-11-11 04:21:22 | Walthall, Mississippi, US | |
3252899 | 3252899 | 2022-10-11 | US | Puerto Rico | Hormigueros | 72067 | 4344 | 0 | 0 | 18.134532 | -67.113972 | 2022-10-12 04:22:51 | Hormigueros, Puerto Rico, US | |
2970158 | 2970158 | 2022-10-10 | US | Puerto Rico | Hormigueros | 72067 | 4344 | 0 | 0 | 18.134532 | -67.113972 | 2022-10-11 04:23:05 | Hormigueros, Puerto Rico, US | |
1562628 | 1562628 | 2022-09-28 | US | Oklahoma | Atoka | 40005 | 4344 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-09-29 04:22:34 | Atoka, Oklahoma, US | |
3997171 | 3997171 | 2022-09-27 | US | Oklahoma | Atoka | 40005 | 4344 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-09-28 04:23:01 | Atoka, Oklahoma, US | |
2771499 | 2771499 | 2022-09-26 | US | Oklahoma | Atoka | 40005 | 4344 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-09-27 04:23:01 | Atoka, Oklahoma, US | |
1979152 | 1979152 | 2022-09-25 | US | Oklahoma | Atoka | 40005 | 4344 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-09-26 04:20:52 | Atoka, Oklahoma, US | |
2652319 | 2652319 | 2022-09-24 | US | Oklahoma | Atoka | 40005 | 4344 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-09-25 04:23:31 | Atoka, Oklahoma, US | |
386759 | 386759 | 2022-09-23 | US | Oklahoma | Atoka | 40005 | 4344 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-09-24 04:21:40 | Atoka, Oklahoma, US | |
1626825 | 1626825 | 2022-09-22 | US | Oklahoma | Atoka | 40005 | 4344 | 54 | 0 | 34.37366573 | -96.03802487 | 2022-09-23 04:23:13 | Atoka, Oklahoma, US | |
3550129 | 3550129 | 2022-09-01 | US | Oregon | Hood River | 41027 | 4344 | 47 | 0 | 45.51872811 | -121.6552036 | 2022-09-02 04:21:07 | Hood River, Oregon, US | |
994450 | 994450 | 2022-08-16 | US | Washington | Pacific | 53049 | 4344 | 65 | 0 | 46.55418369 | -123.7285716 | 2022-08-17 04:20:59 | Pacific, Washington, US | |
2497489 | 2497489 | 2022-08-15 | US | Washington | Pacific | 53049 | 4344 | 65 | 0 | 46.55418369 | -123.7285716 | 2022-08-16 04:20:58 | Pacific, Washington, US | |
3911307 | 3911307 | 2022-08-11 | US | Virginia | Appomattox | 51011 | 4344 | 55 | 0 | 37.37569884 | -78.81340003 | 2022-08-12 04:20:54 | Appomattox, Virginia, US | |
3909943 | 3909943 | 2022-08-11 | US | Missouri | Morgan | 29141 | 4344 | 116 | 0 | 38.4181765 | -92.88791859 | 2022-08-12 04:20:54 | Morgan, Missouri, US | |
1348260 | 1348260 | 2022-08-10 | US | Missouri | Morgan | 29141 | 4344 | 116 | 0 | 38.4181765 | -92.88791859 | 2022-08-11 04:20:49 | Morgan, Missouri, US | |
1088015 | 1088015 | 2022-08-09 | US | Missouri | Morgan | 29141 | 4344 | 116 | 0 | 38.4181765 | -92.88791859 | 2022-08-10 04:20:57 | Morgan, Missouri, US | |
3545430 | 3545430 | 2022-08-08 | US | Missouri | Morgan | 29141 | 4344 | 116 | 0 | 38.4181765 | -92.88791859 | 2022-08-09 04:20:34 | Morgan, Missouri, US | |
1071833 | 1071833 | 2022-08-07 | US | Missouri | Morgan | 29141 | 4344 | 116 | 0 | 38.4181765 | -92.88791859 | 2022-08-08 04:21:08 | Morgan, Missouri, US | |
1942421 | 1942421 | 2022-08-06 | US | Missouri | Morgan | 29141 | 4344 | 116 | 0 | 38.4181765 | -92.88791859 | 2022-08-07 04:20:54 | Morgan, Missouri, US | |
882220 | 882220 | 2022-08-05 | US | Missouri | Morgan | 29141 | 4344 | 116 | 0 | 38.4181765 | -92.88791859 | 2022-08-06 04:20:56 | Morgan, Missouri, US | |
1068907 | 1068907 | 2022-07-28 | US | Texas | Bosque | 48035 | 4344 | 70 | 0 | 31.89978581 | -97.63613524 | 2022-07-29 04:20:45 | Bosque, Texas, US | |
3406485 | 3406485 | 2022-07-17 | US | Illinois | Mercer | 17131 | 4344 | 50 | 0 | 41.20596782 | -90.74290052 | 2022-07-18 04:20:59 | Mercer, Illinois, US | |
2152685 | 2152685 | 2022-07-16 | US | Illinois | Mercer | 17131 | 4344 | 50 | 0 | 41.20596782 | -90.74290052 | 2022-07-17 04:21:15 | Mercer, Illinois, US | |
2419918 | 2419918 | 2022-07-15 | US | Illinois | Mercer | 17131 | 4344 | 50 | 0 | 41.20596782 | -90.74290052 | 2022-07-16 04:21:05 | Mercer, Illinois, US | |
476957 | 476957 | 2022-06-26 | US | Louisiana | LaSalle | 22059 | 4344 | 61 | 0 | 31.67884782 | -92.15907765 | 2022-06-27 04:21:00 | LaSalle, Louisiana, US | |
940332 | 940332 | 2022-06-25 | US | Louisiana | LaSalle | 22059 | 4344 | 61 | 0 | 31.67884782 | -92.15907765 | 2022-06-26 04:21:02 | LaSalle, Louisiana, US | |
3348152 | 3348152 | 2022-06-24 | US | Louisiana | LaSalle | 22059 | 4344 | 61 | 0 | 31.67884782 | -92.15907765 | 2022-06-25 04:20:57 | LaSalle, Louisiana, US | |
3723181 | 3723181 | 2022-04-25 | US | Illinois | De Witt | 17039 | 4344 | 37 | 0 | 40.17514519 | -88.90959682 | 2022-04-26 04:20:51 | De Witt, Illinois, US | |
2141684 | 2141684 | 2022-03-09 | US | Louisiana | Jackson | 22049 | 4344 | 72 | 0 | 32.30251776 | -92.55692092 | 2022-03-10 04:20:48 | Jackson, Louisiana, US | |
1548870 | 1548870 | 2022-03-07 | US | Georgia | Washington | 13303 | 4344 | 132 | 0 | 32.96711864 | -82.79357039 | 2022-03-08 04:20:54 | Washington, Georgia, US | |
2526009 | 2526009 | 2022-03-02 | US | Colorado | Otero | 8089 | 4344 | 129 | 0 | 37.9014485 | -103.7173385 | 2022-03-03 04:21:01 | Otero, Colorado, US | |
946054 | 946054 | 2022-02-28 | US | Texas | Shelby | 48419 | 4344 | 126 | 0 | 31.79211404 | -94.14550696 | 2022-03-01 04:21:09 | Shelby, Texas, US | |
3048904 | 3048904 | 2022-02-26 | US | Puerto Rico | Camuy | 72027 | 4344 | 0 | 0 | 18.418578 | -66.860206 | 2022-02-27 04:21:04 | Camuy, Puerto Rico, US | |
1512497 | 1512497 | 2022-02-24 | US | Indiana | Franklin | 18047 | 4344 | 54 | 0 | 39.4142482 | -85.06062647 | 2022-02-25 04:21:11 | Franklin, Indiana, US | |
3821990 | 3821990 | 2022-02-16 | US | Louisiana | Winn | 22127 | 4344 | 60 | 0 | 31.94449367 | -92.63789413 | 2022-02-17 04:20:56 | Winn, Louisiana, US | |
188201 | 188201 | 2022-02-13 | US | Nebraska | Washington | 31177 | 4344 | 25 | 0 | 41.52815707 | -96.22019892 | 2022-02-14 04:20:51 | Washington, Nebraska, US | |
318047 | 318047 | 2022-02-12 | US | Nebraska | Washington | 31177 | 4344 | 25 | 0 | 41.52815707 | -96.22019892 | 2022-02-13 04:21:00 | Washington, Nebraska, US | |
235373 | 235373 | 2022-02-11 | US | Nebraska | Washington | 31177 | 4344 | 25 | 0 | 41.52815707 | -96.22019892 | 2022-02-12 04:21:06 | Washington, Nebraska, US | |
3077357 | 3077357 | 2022-02-09 | US | Virginia | Buchanan | 51027 | 4344 | 92 | 0 | 37.26818323 | -82.03749726 | 2022-02-10 04:21:14 | Buchanan, Virginia, US | |
3303192 | 3303192 | 2022-01-30 | US | Tennessee | Polk | 47139 | 4344 | 52 | 0 | 35.12245443 | -84.52075859 | 2022-01-31 04:21:09 | Polk, Tennessee, US | |
3065178 | 3065178 | 2022-01-29 | US | Texas | Montague | 48337 | 4344 | 109 | 0 | 33.67521893 | -97.72500958 | 2022-01-30 04:21:26 | Montague, Texas, US | |
2054322 | 2054322 | 2022-01-25 | US | Northern Mariana Islands | 69 | 4344 | 22 | 0 | 15.0979 | 145.6739 | 2022-01-26 04:21:07 | Northern Mariana Islands, US | ||
3616217 | 3616217 | 2022-01-12 | US | Texas | Lampasas | 48281 | 4344 | 72 | 0 | 31.19531316 | -98.24206613 | 2022-01-13 08:00:09 | Lampasas, Texas, US | |
3614653 | 3614653 | 2022-01-12 | US | Maryland | Somerset | 24039 | 4344 | 62 | 0 | 38.1163542 | -75.75118623 | 2022-01-13 08:00:09 | Somerset, Maryland, US | |
1115444 | 1115444 | 2022-01-11 | US | Mississippi | Tishomingo | 28141 | 4344 | 99 | 0 | 34.74023475 | -88.23917219 | 2022-01-12 04:21:44 | Tishomingo, Mississippi, US | |
2611825 | 2611825 | 2022-01-06 | US | Minnesota | Waseca | 27161 | 4344 | 35 | 0 | 44.02211116 | -93.58720034 | 2022-01-07 04:22:09 | Waseca, Minnesota, US | |
3498665 | 3498665 | 2021-12-15 | US | Ohio | Hocking | 39073 | 4344 | 98 | 0 | 39.49537927 | -82.47991446 | 2021-12-16 04:22:11 | Hocking, Ohio, US | |
407227 | 407227 | 2021-12-07 | US | Tennessee | DeKalb | 47041 | 4344 | 77 | 0 | 35.97616272 | -85.83689361 | 2021-12-08 04:22:46 | DeKalb, Tennessee, US | |
1233862 | 1233862 | 2021-11-28 | US | New York | Delaware | 36025 | 4344 | 51 | 0 | 42.19837623 | -74.96709306 | 2021-11-29 04:22:30 | Delaware, New York, US | |
2288862 | 2288862 | 2021-11-15 | US | Kentucky | Grant | 21081 | 4344 | 36 | 0 | 38.64962758 | -84.62415957 | 2021-11-16 04:21:10 | Grant, Kentucky, US | |
3122120 | 3122120 | 2021-11-05 | US | Colorado | Delta | 8029 | 4344 | 97 | 0 | 38.86246243 | -107.86313419999999 | 2021-11-06 04:21:51 | Delta, Colorado, US | |
684087 | 684087 | 2021-10-24 | US | Minnesota | Nicollet | 27103 | 4344 | 54 | 0 | 44.35291112 | -94.24710352 | 2021-10-25 04:22:31 | Nicollet, Minnesota, US | |
772779 | 772779 | 2021-10-23 | US | North Dakota | Stutsman | 38093 | 4344 | 86 | 0 | 46.97962541 | -98.95637318 | 2021-10-24 04:21:22 | Stutsman, North Dakota, US | |
772095 | 772095 | 2021-10-23 | US | Minnesota | Nicollet | 27103 | 4344 | 54 | 0 | 44.35291112 | -94.24710352 | 2021-10-24 04:21:22 | Nicollet, Minnesota, US | |
655742 | 655742 | 2021-10-22 | US | Minnesota | Nicollet | 27103 | 4344 | 54 | 0 | 44.35291112 | -94.24710352 | 2021-10-23 04:21:32 | Nicollet, Minnesota, US | |
2124785 | 2124785 | 2021-10-21 | US | Illinois | Saline | 17165 | 4344 | 69 | 0 | 37.75332999 | -88.54119706 | 2021-10-22 04:21:14 | Saline, Illinois, US | |
2046132 | 2046132 | 2021-10-18 | US | New York | Wyoming | 36121 | 4344 | 58 | 0 | 42.70145109 | -78.22199579 | 2021-10-19 04:20:54 | Wyoming, New York, US | |
2878428 | 2878428 | 2021-10-09 | US | New York | Allegany | 36003 | 4344 | 93 | 0 | 42.25748406 | -78.02750466 | 2021-10-10 04:21:38 | Allegany, New York, US | |
3833450 | 3833450 | 2021-10-05 | US | Illinois | Bureau | 17011 | 4344 | 89 | 0 | 41.40385234 | -89.5283051 | 2021-10-06 04:21:33 | Bureau, Illinois, US | |
1335794 | 1335794 | 2021-09-28 | US | Louisiana | Morehouse | 22067 | 4344 | 110 | 0 | 32.81686191 | -91.80421614 | 2021-09-29 04:21:45 | Morehouse, Louisiana, US | |
2620311 | 2620311 | 2021-09-17 | US | New York | Tioga | 36107 | 4344 | 66 | 0 | 42.16852837 | -76.30835812 | 2021-09-18 04:21:24 | Tioga, New York, US | |
2464177 | 2464177 | 2021-09-14 | US | Kentucky | Clark | 21049 | 4344 | 32 | 0 | 37.9689263 | -84.14615986 | 2021-09-15 03:22:37 | Clark, Kentucky, US | |
1388460 | 1388460 | 2021-09-13 | US | South Carolina | Marlboro | 45069 | 4344 | 69 | 0 | 34.59905577 | -79.67561152 | 2021-09-14 04:21:41 | Marlboro, South Carolina, US | |
1387131 | 1387131 | 2021-09-13 | US | Louisiana | East Feliciana | 22037 | 4344 | 133 | 0 | 30.84425359 | -91.04976723 | 2021-09-14 04:21:41 | East Feliciana, Louisiana, US | |
1886637 | 1886637 | 2021-09-12 | US | Michigan | Huron | 26063 | 4344 | 87 | 0 | 43.83353985 | -83.04078453 | 2021-09-13 04:21:15 | Huron, Michigan, US | |
1886500 | 1886500 | 2021-09-12 | US | Louisiana | East Feliciana | 22037 | 4344 | 133 | 0 | 30.84425359 | -91.04976723 | 2021-09-13 04:21:15 | East Feliciana, Louisiana, US | |
3807540 | 3807540 | 2021-09-11 | US | Michigan | Huron | 26063 | 4344 | 87 | 0 | 43.83353985 | -83.04078453 | 2021-09-12 04:21:13 | Huron, Michigan, US | |
3807403 | 3807403 | 2021-09-11 | US | Louisiana | East Feliciana | 22037 | 4344 | 133 | 0 | 30.84425359 | -91.04976723 | 2021-09-12 04:21:13 | East Feliciana, Louisiana, US | |
3451533 | 3451533 | 2021-09-10 | US | Pennsylvania | Perry | 42099 | 4344 | 102 | 0 | 40.40206612 | -77.26297447 | 2021-09-11 04:21:30 | Perry, Pennsylvania, US | |
3450480 | 3450480 | 2021-09-10 | US | Michigan | Huron | 26063 | 4344 | 87 | 0 | 43.83353985 | -83.04078453 | 2021-09-11 04:21:30 | Huron, Michigan, US | |
3450343 | 3450343 | 2021-09-10 | US | Louisiana | East Feliciana | 22037 | 4344 | 133 | 0 | 30.84425359 | -91.04976723 | 2021-09-11 04:21:30 | East Feliciana, Louisiana, US | |
1263626 | 1263626 | 2021-09-09 | US | Georgia | Madison | 13195 | 4344 | 61 | 0 | 34.12920917 | -83.21218732 | 2021-09-10 04:21:20 | Madison, Georgia, US | |
179397 | 179397 | 2021-09-02 | US | Kentucky | Boyle | 21021 | 4344 | 80 | 0 | 37.62680923 | -84.8633779 | 2021-09-03 04:21:20 | Boyle, Kentucky, US | |
178913 | 178913 | 2021-09-02 | US | Georgia | Unassigned | 90013 | 4344 | 8 | 0 | 34.91369188 | 0.0 | 2021-09-03 04:21:20 | Unassigned, Georgia, US | |
1777828 | 1777828 | 2021-08-30 | US | Ohio | Highland | 39071 | 4344 | 80 | 0 | 39.1839264 | -83.60331456 | 2021-08-31 04:21:46 | Highland, Ohio, US | |
3892568 | 3892568 | 2021-08-29 | US | Colorado | Montrose | 8085 | 4344 | 76 | 0 | 38.40214114 | -108.26390220000002 | 2021-08-30 04:21:23 | Montrose, Colorado, US | |
514476 | 514476 | 2021-08-19 | US | Puerto Rico | Toa Alta | 72135 | 4344 | 0 | 0 | 18.362406 | -66.246616 | 2021-08-20 04:21:33 | Toa Alta, Puerto Rico, US | |
248116 | 248116 | 2021-08-17 | US | South Dakota | Brookings | 46011 | 4344 | 37 | 0 | 44.36974375 | -96.79079945 | 2021-08-18 04:21:35 | Brookings, South Dakota, US | |
106031 | 106031 | 2021-08-15 | US | Pennsylvania | Wayne | 42127 | 4344 | 84 | 0 | 41.64938475 | -75.29956506 | 2021-08-16 04:21:31 | Wayne, Pennsylvania, US | |
104597 | 104597 | 2021-08-15 | US | Kansas | Cowley | 20035 | 4344 | 110 | 0 | 37.23781842 | -96.83776647 | 2021-08-16 04:21:31 | Cowley, Kansas, US | |
104176 | 104176 | 2021-08-15 | US | Georgia | Oconee | 13219 | 4344 | 74 | 0 | 33.83749973 | -83.43679568 | 2021-08-16 04:21:31 | Oconee, Georgia, US | |
508955 | 508955 | 2021-08-14 | US | Kansas | Cowley | 20035 | 4344 | 110 | 0 | 37.23781842 | -96.83776647 | 2021-08-15 04:21:41 | Cowley, Kansas, US | |
508534 | 508534 | 2021-08-14 | US | Georgia | Oconee | 13219 | 4344 | 74 | 0 | 33.83749973 | -83.43679568 | 2021-08-15 04:21:41 | Oconee, Georgia, US | |
1484827 | 1484827 | 2021-08-13 | US | Kansas | Cowley | 20035 | 4344 | 110 | 0 | 37.23781842 | -96.83776647 | 2021-08-14 04:21:25 | Cowley, Kansas, 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]);