johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
99 rows where confirmed = 7620 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2559206 | 2559206 | 2022-11-29 | US | Oregon | Crook | 41013 | 7620 | 93 | 0 | 44.14230227 | -120.356297 | 2022-11-30 04:21:07 | Crook, Oregon, US | |
1242280 | 1242280 | 2022-11-28 | US | Oregon | Crook | 41013 | 7620 | 93 | 0 | 44.14230227 | -120.356297 | 2022-11-29 04:21:05 | Crook, Oregon, US | |
1241537 | 1241537 | 2022-11-28 | US | Missouri | Barry | 29009 | 7620 | 150 | 0 | 36.70978521 | -93.82919888 | 2022-11-29 04:21:05 | Barry, Missouri, US | |
3554268 | 3554268 | 2022-11-27 | US | Oregon | Crook | 41013 | 7620 | 93 | 0 | 44.14230227 | -120.356297 | 2022-11-28 04:21:02 | Crook, Oregon, US | |
3553525 | 3553525 | 2022-11-27 | US | Missouri | Barry | 29009 | 7620 | 150 | 0 | 36.70978521 | -93.82919888 | 2022-11-28 04:21:02 | Barry, Missouri, US | |
2102748 | 2102748 | 2022-11-26 | US | Oregon | Crook | 41013 | 7620 | 93 | 0 | 44.14230227 | -120.356297 | 2022-11-27 04:21:05 | Crook, Oregon, US | |
2102005 | 2102005 | 2022-11-26 | US | Missouri | Barry | 29009 | 7620 | 150 | 0 | 36.70978521 | -93.82919888 | 2022-11-27 04:21:05 | Barry, Missouri, US | |
490239 | 490239 | 2022-11-25 | US | Oregon | Crook | 41013 | 7620 | 93 | 0 | 44.14230227 | -120.356297 | 2022-11-26 04:21:11 | Crook, Oregon, US | |
489496 | 489496 | 2022-11-25 | US | Missouri | Barry | 29009 | 7620 | 150 | 0 | 36.70978521 | -93.82919888 | 2022-11-26 04:21:11 | Barry, Missouri, US | |
3526068 | 3526068 | 2022-11-24 | US | Oregon | Crook | 41013 | 7620 | 93 | 0 | 44.14230227 | -120.356297 | 2022-11-25 04:21:06 | Crook, Oregon, US | |
3525325 | 3525325 | 2022-11-24 | US | Missouri | Barry | 29009 | 7620 | 150 | 0 | 36.70978521 | -93.82919888 | 2022-11-25 04:21:06 | Barry, Missouri, US | |
3315013 | 3315013 | 2022-11-23 | US | Puerto Rico | Salinas | 72123 | 7620 | 0 | 0 | 18.010387 | -66.256592 | 2022-11-24 04:21:09 | Salinas, Puerto Rico, US | |
3314851 | 3314851 | 2022-11-23 | US | Oregon | Crook | 41013 | 7620 | 93 | 0 | 44.14230227 | -120.356297 | 2022-11-24 04:21:09 | Crook, Oregon, US | |
3314108 | 3314108 | 2022-11-23 | US | Missouri | Barry | 29009 | 7620 | 150 | 0 | 36.70978521 | -93.82919888 | 2022-11-24 04:21:09 | Barry, Missouri, US | |
1622149 | 1622149 | 2022-11-22 | US | Missouri | Barry | 29009 | 7620 | 150 | 0 | 36.70978521 | -93.82919888 | 2022-11-23 04:21:06 | Barry, Missouri, US | |
851162 | 851162 | 2022-11-02 | US | Maine | Knox | 23013 | 7620 | 47 | 0 | 44.11486325 | -69.10529169 | 2022-11-03 04:22:05 | Knox, Maine, US | |
319697 | 319697 | 2022-10-30 | Chad | 7620 | 194 | 0 | 15.4542 | 18.7322 | 2022-10-31 04:21:36 | Chad | ||||
911973 | 911973 | 2022-10-29 | Chad | 7620 | 194 | 0 | 15.4542 | 18.7322 | 2022-10-30 04:22:14 | Chad | ||||
1366242 | 1366242 | 2022-10-28 | Chad | 7620 | 194 | 0 | 15.4542 | 18.7322 | 2022-10-29 04:21:13 | Chad | ||||
3038097 | 3038097 | 2022-10-27 | Chad | 7620 | 194 | 0 | 15.4542 | 18.7322 | 2022-10-28 04:22:31 | Chad | ||||
538517 | 538517 | 2022-10-26 | Chad | 7620 | 194 | 0 | 15.4542 | 18.7322 | 2022-10-27 04:22:01 | Chad | ||||
1829918 | 1829918 | 2022-10-25 | Chad | 7620 | 194 | 0 | 15.4542 | 18.7322 | 2022-10-26 04:22:19 | Chad | ||||
794179 | 794179 | 2022-10-24 | Chad | 7620 | 194 | 0 | 15.4542 | 18.7322 | 2022-10-25 04:21:53 | Chad | ||||
3995481 | 3995481 | 2022-09-27 | US | Georgia | Madison | 13195 | 7620 | 118 | 0 | 34.12920917 | -83.21218732 | 2022-09-28 04:23:01 | Madison, Georgia, US | |
2769809 | 2769809 | 2022-09-26 | US | Georgia | Madison | 13195 | 7620 | 118 | 0 | 34.12920917 | -83.21218732 | 2022-09-27 04:23:01 | Madison, Georgia, US | |
1977462 | 1977462 | 2022-09-25 | US | Georgia | Madison | 13195 | 7620 | 118 | 0 | 34.12920917 | -83.21218732 | 2022-09-26 04:20:52 | Madison, Georgia, US | |
2650629 | 2650629 | 2022-09-24 | US | Georgia | Madison | 13195 | 7620 | 118 | 0 | 34.12920917 | -83.21218732 | 2022-09-25 04:23:31 | Madison, Georgia, US | |
385069 | 385069 | 2022-09-23 | US | Georgia | Madison | 13195 | 7620 | 118 | 0 | 34.12920917 | -83.21218732 | 2022-09-24 04:21:40 | Madison, Georgia, US | |
1625135 | 1625135 | 2022-09-22 | US | Georgia | Madison | 13195 | 7620 | 118 | 0 | 34.12920917 | -83.21218732 | 2022-09-23 04:23:13 | Madison, Georgia, US | |
1371339 | 1371339 | 2022-09-21 | US | Georgia | Madison | 13195 | 7620 | 118 | 0 | 34.12920917 | -83.21218732 | 2022-09-22 04:22:56 | Madison, Georgia, US | |
3988831 | 3988831 | 2022-09-15 | US | New Mexico | Luna | 35029 | 7620 | 144 | 0 | 32.18179341 | -107.7508826 | 2022-09-16 04:21:19 | Luna, New Mexico, US | |
671287 | 671287 | 2022-07-21 | US | Illinois | Fayette | 17051 | 7620 | 101 | 0 | 39.00072038 | -89.02452658 | 2022-07-22 04:21:15 | Fayette, Illinois, US | |
2725656 | 2725656 | 2022-05-28 | US | Colorado | Logan | 8075 | 7620 | 112 | 0 | 40.7249637 | -103.110817 | 2022-05-29 04:20:53 | Logan, Colorado, US | |
2032305 | 2032305 | 2022-04-24 | US | Wisconsin | Clark | 55019 | 7620 | 122 | 0 | 44.73483377 | -90.61207486 | 2022-04-25 04:20:56 | Clark, Wisconsin, US | |
749880 | 749880 | 2022-04-23 | US | Wisconsin | Clark | 55019 | 7620 | 122 | 0 | 44.73483377 | -90.61207486 | 2022-04-24 04:20:56 | Clark, Wisconsin, US | |
3440365 | 3440365 | 2022-04-22 | US | Wisconsin | Clark | 55019 | 7620 | 122 | 0 | 44.73483377 | -90.61207486 | 2022-04-23 04:20:50 | Clark, Wisconsin, US | |
2895950 | 2895950 | 2022-04-21 | US | Wisconsin | Clark | 55019 | 7620 | 122 | 0 | 44.73483377 | -90.61207486 | 2022-04-22 04:20:45 | Clark, Wisconsin, US | |
2443299 | 2443299 | 2022-04-13 | US | California | Calaveras | 6009 | 7620 | 119 | 0 | 38.20537103 | -120.55291299999999 | 2022-04-13 23:21:06 | Calaveras, California, US | |
1658643 | 1658643 | 2022-03-19 | US | New York | Delaware | 36025 | 7620 | 68 | 0 | 42.19837623 | -74.96709306 | 2022-03-20 04:20:45 | Delaware, New York, US | |
2319716 | 2319716 | 2022-03-16 | US | Alabama | Lawrence | 1079 | 7620 | 153 | 0 | 34.52041498 | -87.31069453 | 2022-03-17 04:20:56 | Lawrence, Alabama, US | |
1550816 | 1550816 | 2022-03-07 | US | South Carolina | Union | 45087 | 7620 | 145 | 0 | 34.68835752 | -81.61730349 | 2022-03-08 04:20:54 | Union, South Carolina, US | |
1299632 | 1299632 | 2022-02-17 | US | Maryland | Dorchester | 24019 | 7620 | 104 | 0 | 38.45413522 | -76.02752426 | 2022-02-18 04:21:04 | Dorchester, Maryland, US | |
3671784 | 3671784 | 2022-02-15 | Netherlands | Unknown | 7620 | 29 | 0 | 2022-02-16 04:21:10 | Unknown, Netherlands | |||||
3075793 | 3075793 | 2022-02-09 | US | Minnesota | Nicollet | 27103 | 7620 | 66 | 0 | 44.35291112 | -94.24710352 | 2022-02-10 04:21:14 | Nicollet, Minnesota, US | |
982210 | 982210 | 2022-02-01 | US | Texas | Wood | 48499 | 7620 | 257 | 0 | 32.78722382 | -95.38236368 | 2022-02-02 04:21:09 | Wood, Texas, US | |
1780246 | 1780246 | 2022-01-27 | US | Georgia | Pickens | 13227 | 7620 | 140 | 0 | 34.46589159 | -84.46406611 | 2022-01-28 04:21:09 | Pickens, Georgia, US | |
1230274 | 1230274 | 2022-01-24 | US | Pennsylvania | Clarion | 42031 | 7620 | 184 | 0 | 41.19265812 | -79.42413524 | 2022-01-25 04:21:05 | Clarion, Pennsylvania, US | |
102333 | 102333 | 2022-01-14 | US | Tennessee | Weakley | 47183 | 7620 | 107 | 0 | 36.29896232 | -88.71990865 | 2022-01-15 04:21:07 | Weakley, Tennessee, US | |
1435419 | 1435419 | 2021-12-28 | US | South Dakota | Brown | 46013 | 7620 | 107 | 0 | 45.58994323 | -98.35165355 | 2021-12-29 03:21:43 | Brown, South Dakota, US | |
1081466 | 1081466 | 2021-12-09 | US | Wisconsin | Douglas | 55031 | 7620 | 70 | 0 | 46.43222285 | -91.91595768 | 2021-12-10 04:22:28 | Douglas, Wisconsin, US | |
2198759 | 2198759 | 2021-12-03 | US | Texas | Jim Wells | 48249 | 7620 | 182 | 0 | 27.73103938 | -98.0904705 | 2021-12-04 04:22:18 | Jim Wells, Texas, US | |
1146330 | 1146330 | 2021-12-01 | US | Kentucky | Franklin | 21073 | 7620 | 100 | 0 | 38.2379395 | -84.87962551 | 2021-12-02 04:22:37 | Franklin, Kentucky, US | |
699690 | 699690 | 2021-11-04 | US | Kansas | Finney | 20055 | 7620 | 89 | 0 | 38.04340344 | -100.73819379999999 | 2021-11-05 04:21:54 | Finney, Kansas, US | |
988685 | 988685 | 2021-10-04 | US | Minnesota | Chisago | 27025 | 7620 | 59 | 0 | 45.5021011 | -92.90861945 | 2021-10-05 04:21:27 | Chisago, Minnesota, US | |
2133141 | 2133141 | 2021-10-01 | US | Indiana | Noble | 18113 | 7620 | 101 | 0 | 41.39672484 | -85.41966713 | 2021-10-02 04:21:25 | Noble, Indiana, US | |
706355 | 706355 | 2021-09-29 | India | Andaman and Nicobar Islands | 7620 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-09-30 04:21:20 | Andaman and Nicobar Islands, India | |||
1334197 | 1334197 | 2021-09-28 | India | Andaman and Nicobar Islands | 7620 | 129 | 0 | 11.225999 | 92.96817800000001 | 2021-09-29 04:21:45 | Andaman and Nicobar Islands, India | |||
1387900 | 1387900 | 2021-09-13 | US | New York | Sullivan | 36105 | 7620 | 79 | 0 | 41.71579493 | -74.76394559 | 2021-09-14 04:21:41 | Sullivan, New York, US | |
1265510 | 1265510 | 2021-09-09 | US | Puerto Rico | Caguas | 72025 | 7620 | 0 | 0 | 18.211615 | -66.050779 | 2021-09-10 04:21:20 | Caguas, Puerto Rico, US | |
69500 | 69500 | 2021-09-01 | US | Ohio | Ashtabula | 39007 | 7620 | 185 | 0 | 41.70860332 | -80.74830218 | 2021-09-02 04:21:15 | Ashtabula, Ohio, US | |
3166692 | 3166692 | 2021-08-23 | US | Indiana | Boone | 18011 | 7620 | 107 | 0 | 40.0509304 | -86.46841646 | 2021-08-24 04:21:19 | Boone, Indiana, US | |
515204 | 515204 | 2021-08-19 | US | West Virginia | Raleigh | 54081 | 7620 | 106 | 0 | 37.76936795 | -81.2456041 | 2021-08-20 04:21:33 | Raleigh, West Virginia, US | |
1486492 | 1486492 | 2021-08-13 | US | Tennessee | Gibson | 47053 | 7620 | 150 | 0 | 35.99438059 | -88.93358327 | 2021-08-14 04:21:25 | Gibson, Tennessee, US | |
593199 | 593199 | 2021-08-08 | US | Wisconsin | Portage | 55097 | 7620 | 77 | 0 | 44.47558711 | -89.50152965 | 2021-08-09 04:21:24 | Portage, Wisconsin, US | |
2207211 | 2207211 | 2021-08-07 | US | Wisconsin | Portage | 55097 | 7620 | 77 | 0 | 44.47558711 | -89.50152965 | 2021-08-08 04:21:33 | Portage, Wisconsin, US | |
1121161 | 1121161 | 2021-08-06 | US | Wisconsin | Portage | 55097 | 7620 | 77 | 0 | 44.47558711 | -89.50152965 | 2021-08-07 04:21:30 | Portage, Wisconsin, US | |
3477973 | 3477973 | 2021-07-22 | US | Michigan | Midland | 26111 | 7620 | 95 | 0 | 43.64330771 | -84.38804374 | 2021-07-23 04:21:29 | Midland, Michigan, US | |
3333192 | 3333192 | 2021-07-21 | US | Michigan | Midland | 26111 | 7620 | 95 | 0 | 43.64330771 | -84.38804374 | 2021-07-22 04:21:19 | Midland, Michigan, US | |
2373173 | 2373173 | 2021-07-20 | US | Michigan | Midland | 26111 | 7620 | 95 | 0 | 43.64330771 | -84.38804374 | 2021-07-21 04:21:40 | Midland, Michigan, US | |
580336 | 580336 | 2021-07-13 | US | Louisiana | Iberia | 22045 | 7620 | 164 | 0 | 29.86803617 | -91.75871777 | 2021-07-14 04:21:35 | Iberia, Louisiana, US | |
3128763 | 3128763 | 2021-06-28 | US | Texas | Wise | 48497 | 7620 | 124 | 0 | 33.21570665 | -97.65460265 | 2021-06-29 04:21:28 | Wise, Texas, US | |
2593258 | 2593258 | 2021-06-27 | US | Texas | Wise | 48497 | 7620 | 124 | 0 | 33.21570665 | -97.65460265 | 2021-06-28 04:21:29 | Wise, Texas, US | |
2590886 | 2590886 | 2021-06-27 | US | Georgia | Troup | 13285 | 7620 | 237 | 0 | 33.03349196 | -85.02812115 | 2021-06-28 04:21:29 | Troup, Georgia, US | |
3961762 | 3961762 | 2021-06-26 | US | Texas | Wise | 48497 | 7620 | 124 | 0 | 33.21570665 | -97.65460265 | 2021-06-27 04:21:39 | Wise, Texas, US | |
3032947 | 3032947 | 2021-06-16 | US | Pennsylvania | Crawford | 42039 | 7620 | 153 | 0 | 41.68447709 | -80.10760592 | 2021-06-17 04:22:36 | Crawford, Pennsylvania, US | |
2342053 | 2342053 | 2021-06-15 | US | Pennsylvania | Crawford | 42039 | 7620 | 153 | 0 | 41.68447709 | -80.10760592 | 2021-06-16 04:22:32 | Crawford, Pennsylvania, US | |
53465 | 53465 | 2021-05-29 | US | Pennsylvania | Lawrence | 42073 | 7620 | 211 | 0 | 40.99206278 | -80.33393706 | 2021-05-30 04:20:55 | Lawrence, Pennsylvania, US | |
3955941 | 3955941 | 2021-05-11 | US | Kentucky | Oldham | 21185 | 7620 | 82 | 0 | 38.39791089 | -85.448222 | 2021-05-12 04:21:29 | Oldham, Kentucky, US | |
2452565 | 2452565 | 2021-05-02 | US | Mississippi | Forrest | 28035 | 7620 | 149 | 0 | 31.18961454 | -89.25832496 | 2021-05-03 04:20:39 | Forrest, Mississippi, US | |
2826578 | 2826578 | 2021-05-01 | US | Mississippi | Forrest | 28035 | 7620 | 149 | 0 | 31.18961454 | -89.25832496 | 2021-05-02 04:20:48 | Forrest, Mississippi, US | |
381986 | 381986 | 2021-04-30 | US | Mississippi | Forrest | 28035 | 7620 | 149 | 0 | 31.18961454 | -89.25832496 | 2021-05-01 04:20:47 | Forrest, Mississippi, US | |
3927528 | 3927528 | 2021-04-24 | US | West Virginia | Wood | 54107 | 7620 | 168 | 0 | 39.20967886 | -81.5162836 | 2021-04-25 04:20:32 | Wood, West Virginia, US | |
608624 | 608624 | 2021-04-09 | US | Tennessee | Greene | 47059 | 7620 | 151 | 0 | 36.17470125 | -82.84691273 | 2021-04-10 04:20:59 | Greene, Tennessee, US | |
2782078 | 2782078 | 2021-03-24 | US | Indiana | Hancock | 18059 | 7620 | 135 | 0 | 39.82304555 | -85.77566351 | 2021-03-25 05:27:00 | Hancock, Indiana, US | |
3964477 | 3964477 | 2021-03-10 | US | Missouri | St. Francois | 29187 | 7620 | 109 | 0 | 37.81214171 | -90.47598685 | 2021-03-11 05:25:48 | St. Francois, Missouri, US | |
2362009 | 2362009 | 2021-03-08 | US | Oklahoma | Garfield | 40047 | 7620 | 78 | 0 | 36.3791334 | -97.78265517 | 2021-03-09 05:28:19 | Garfield, Oklahoma, US | |
1858454 | 1858454 | 2021-02-25 | US | Arizona | Santa Cruz | 4023 | 7620 | 167 | 0 | 7453 | 31.52508998 | -110.8479088 | 2021-02-26 05:22:40 | Santa Cruz, Arizona, US |
1096762 | 1096762 | 2021-01-20 | US | Pennsylvania | Lycoming | 42081 | 7620 | 192 | 0 | 7428 | 41.34310539 | -77.06629984 | 2021-01-21 05:22:01 | Lycoming, Pennsylvania, US |
156515 | 156515 | 2021-01-08 | US | Oklahoma | Comanche | 40031 | 7620 | 74 | 0 | 7546 | 34.65973764 | -98.47195055 | 2021-01-09 05:22:18 | Comanche, Oklahoma, US |
1064342 | 1064342 | 2021-01-04 | US | Ohio | Portage | 39133 | 7620 | 126 | 0 | 7494 | 41.16793482 | -81.19735782 | 2021-01-05 05:21:49 | Portage, Ohio, US |
3692064 | 3692064 | 2020-12-24 | US | California | Yolo | 6113 | 7620 | 113 | 0 | 7513 | 38.68278902 | -121.9018288 | 2020-12-25 05:22:48 | Yolo, California, US |
1754576 | 1754576 | 2020-12-14 | US | Virginia | Chesapeake | 51550 | 7620 | 88 | 0 | 7532 | 36.67670048 | -76.30545744 | 2020-12-15 05:26:38 | Chesapeake, Virginia, US |
860816 | 860816 | 2020-12-11 | Pakistan | Azad Jammu and Kashmir | 7620 | 188 | 6065 | 1367 | 34.027401 | 73.947253 | 2020-12-12 05:26:19 | Azad Jammu and Kashmir, Pakistan | ||
1350866 | 1350866 | 2020-11-24 | US | California | Marin | 6041 | 7620 | 135 | 0 | 7483 | 38.07122463 | -122.7210631 | 2020-11-25 05:27:20 | Marin, California, US |
3838628 | 3838628 | 2020-11-21 | US | New Hampshire | Hillsborough | 33011 | 7620 | 332 | 0 | 7288 | 42.91537785 | -71.7200253 | 2020-11-22 05:25:45 | Hillsborough, New Hampshire, US |
818688 | 818688 | 2020-10-09 | US | Indiana | St. Joseph | 18141 | 7620 | 150 | 0 | 7470 | 41.61756781 | -86.29040834 | 2020-10-10 04:23:57 | St. Joseph, Indiana, US |
837852 | 837852 | 2020-08-17 | Russia | Samara Oblast | 7620 | 117 | 5776 | 1727 | 53.2128813 | 50.8914633 | 2020-08-18 04:27:56 | Samara Oblast, Russia | ||
442518 | 442518 | 2020-07-26 | Ukraine | Kiev | 7620 | 129 | 2748 | 4743 | 50.4501 | 30.5234 | 2020-07-27 04:35:02 | Kiev, Ukraine | ||
3636431 | 3636431 | 2020-05-30 | US | Illinois | DuPage | 17043 | 7620 | 368 | 0 | 7252 | 41.85116968 | -88.08642662 | 2020-05-31 02:32:45 | DuPage, Illinois, 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]);