johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
110 rows where confirmed = 7014 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754498 | 2754498 | 2022-12-29 | US | Maryland | Talbot | 24041 | 7014 | 107 | 0 | 38.76618159 | -76.10882561 | 2022-12-30 04:21:04 | Talbot, Maryland, US | |
1076643 | 1076643 | 2022-12-28 | US | Puerto Rico | Catano | 72033 | 7014 | 0 | 0 | 18.437269 | -66.143306 | 2022-12-29 04:21:01 | Catano, Puerto Rico, US | |
1966153 | 1966153 | 2022-11-30 | US | Maryland | Caroline | 24011 | 7014 | 89 | 0 | 38.87172293 | -75.82904158 | 2022-12-01 04:21:03 | Caroline, Maryland, US | |
1243149 | 1243149 | 2022-11-28 | US | West Virginia | Hampshire | 54027 | 7014 | 74 | 0 | 39.32103553 | -78.60826476 | 2022-11-29 04:21:05 | Hampshire, West Virginia, US | |
3026100 | 3026100 | 2022-11-17 | China | Sichuan | 7014 | 3 | 0 | 30.6171 | 102.7103 | 2022-11-18 04:21:15 | Sichuan, China | |||
2485811 | 2485811 | 2022-11-16 | China | Sichuan | 7014 | 3 | 0 | 30.6171 | 102.7103 | 2022-11-17 04:21:11 | Sichuan, China | |||
2507619 | 2507619 | 2022-11-10 | US | Maine | Franklin | 23007 | 7014 | 70 | 0 | 44.97330019 | -70.44381045 | 2022-11-11 04:21:22 | Franklin, Maine, US | |
2431408 | 2431408 | 2022-11-09 | US | Arkansas | Carroll | 5015 | 7014 | 119 | 0 | 36.3403856 | -93.54270261 | 2022-11-10 04:21:16 | Carroll, Arkansas, US | |
1832402 | 1832402 | 2022-10-25 | US | New York | Lewis | 36049 | 7014 | 53 | 0 | 43.7844157 | -75.44903992 | 2022-10-26 04:22:19 | Lewis, New York, US | |
2018938 | 2018938 | 2022-09-20 | US | New Mexico | San Miguel | 35047 | 7014 | 74 | 0 | 35.48014807 | -104.8163562 | 2022-09-21 04:23:22 | San Miguel, New Mexico, US | |
1682721 | 1682721 | 2022-08-29 | US | New Mexico | Unassigned | 90035 | 7014 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-08-30 04:21:03 | Unassigned, New Mexico, US | |
1879205 | 1879205 | 2022-08-28 | US | New Mexico | Unassigned | 90035 | 7014 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-08-29 04:21:06 | Unassigned, New Mexico, US | |
2098332 | 2098332 | 2022-08-27 | US | New Mexico | Unassigned | 90035 | 7014 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-08-28 04:21:02 | Unassigned, New Mexico, US | |
1534147 | 1534147 | 2022-08-26 | US | New Mexico | Unassigned | 90035 | 7014 | 0 | 0 | 36.60569702 | -108.7151824 | 2022-08-27 04:20:57 | Unassigned, New Mexico, US | |
2495667 | 2495667 | 2022-08-15 | US | Michigan | Emmet | 26047 | 7014 | 94 | 0 | 45.52625509 | -84.89083249 | 2022-08-16 04:20:58 | Emmet, Michigan, US | |
2495012 | 2495012 | 2022-08-15 | US | Illinois | Crawford | 17033 | 7014 | 46 | 0 | 39.0032229 | -87.75954624 | 2022-08-16 04:20:58 | Crawford, Illinois, US | |
3649217 | 3649217 | 2022-08-14 | US | Michigan | Emmet | 26047 | 7014 | 94 | 0 | 45.52625509 | -84.89083249 | 2022-08-15 04:20:59 | Emmet, Michigan, US | |
1970223 | 1970223 | 2022-08-13 | US | Michigan | Emmet | 26047 | 7014 | 94 | 0 | 45.52625509 | -84.89083249 | 2022-08-14 04:20:55 | Emmet, Michigan, US | |
2890032 | 2890032 | 2022-08-12 | US | Michigan | Emmet | 26047 | 7014 | 94 | 0 | 45.52625509 | -84.89083249 | 2022-08-13 04:20:52 | Emmet, Michigan, US | |
3909637 | 3909637 | 2022-08-11 | US | Michigan | Emmet | 26047 | 7014 | 94 | 0 | 45.52625509 | -84.89083249 | 2022-08-12 04:20:54 | Emmet, Michigan, US | |
1349094 | 1349094 | 2022-08-10 | US | Puerto Rico | Quebradillas | 72115 | 7014 | 0 | 0 | 18.439692 | -66.926113 | 2022-08-11 04:20:49 | Quebradillas, Puerto Rico, US | |
1347954 | 1347954 | 2022-08-10 | US | Michigan | Emmet | 26047 | 7014 | 94 | 0 | 45.52625509 | -84.89083249 | 2022-08-11 04:20:49 | Emmet, Michigan, US | |
1087709 | 1087709 | 2022-08-09 | US | Michigan | Emmet | 26047 | 7014 | 94 | 0 | 45.52625509 | -84.89083249 | 2022-08-10 04:20:57 | Emmet, Michigan, US | |
1099965 | 1099965 | 2022-08-03 | US | Mississippi | Scott | 28123 | 7014 | 121 | 0 | 32.4067041 | -89.53789439 | 2022-08-04 04:20:58 | Scott, Mississippi, US | |
1406890 | 1406890 | 2022-08-02 | US | Mississippi | Scott | 28123 | 7014 | 121 | 0 | 32.4067041 | -89.53789439 | 2022-08-03 04:20:59 | Scott, Mississippi, US | |
3618928 | 3618928 | 2022-08-01 | US | Mississippi | Scott | 28123 | 7014 | 121 | 0 | 32.4067041 | -89.53789439 | 2022-08-02 04:20:53 | Scott, Mississippi, US | |
3873408 | 3873408 | 2022-07-31 | US | Mississippi | Scott | 28123 | 7014 | 121 | 0 | 32.4067041 | -89.53789439 | 2022-08-01 04:21:03 | Scott, Mississippi, US | |
676162 | 676162 | 2022-07-30 | US | Mississippi | Scott | 28123 | 7014 | 121 | 0 | 32.4067041 | -89.53789439 | 2022-07-31 04:21:02 | Scott, Mississippi, US | |
1785361 | 1785361 | 2022-07-29 | US | Mississippi | Scott | 28123 | 7014 | 121 | 0 | 32.4067041 | -89.53789439 | 2022-07-30 04:20:42 | Scott, Mississippi, US | |
1067724 | 1067724 | 2022-07-28 | US | Mississippi | Scott | 28123 | 7014 | 121 | 0 | 32.4067041 | -89.53789439 | 2022-07-29 04:20:45 | Scott, Mississippi, US | |
2337243 | 2337243 | 2022-07-27 | US | Mississippi | Scott | 28123 | 7014 | 121 | 0 | 32.4067041 | -89.53789439 | 2022-07-28 04:20:56 | Scott, Mississippi, US | |
2336923 | 2336923 | 2022-07-27 | US | Louisiana | Pointe Coupee | 22077 | 7014 | 93 | 0 | 30.71409502 | -91.60209535 | 2022-07-28 04:20:56 | Pointe Coupee, Louisiana, US | |
1489433 | 1489433 | 2022-07-26 | US | Mississippi | Scott | 28123 | 7014 | 121 | 0 | 32.4067041 | -89.53789439 | 2022-07-27 04:21:04 | Scott, Mississippi, US | |
2595879 | 2595879 | 2022-07-25 | US | Mississippi | Scott | 28123 | 7014 | 121 | 0 | 32.4067041 | -89.53789439 | 2022-07-26 04:20:58 | Scott, Mississippi, US | |
672172 | 672172 | 2022-07-21 | US | Missouri | Barry | 29009 | 7014 | 144 | 0 | 36.70978521 | -93.82919888 | 2022-07-22 04:21:15 | Barry, Missouri, US | |
1610135 | 1610135 | 2022-07-20 | US | Missouri | Barry | 29009 | 7014 | 144 | 0 | 36.70978521 | -93.82919888 | 2022-07-21 04:21:10 | Barry, Missouri, US | |
960768 | 960768 | 2022-07-19 | US | Missouri | Barry | 29009 | 7014 | 144 | 0 | 36.70978521 | -93.82919888 | 2022-07-20 04:20:59 | Barry, Missouri, US | |
3212155 | 3212155 | 2022-07-18 | US | Missouri | Barry | 29009 | 7014 | 144 | 0 | 36.70978521 | -93.82919888 | 2022-07-19 04:20:58 | Barry, Missouri, US | |
3407330 | 3407330 | 2022-07-17 | US | Missouri | Barry | 29009 | 7014 | 144 | 0 | 36.70978521 | -93.82919888 | 2022-07-18 04:20:59 | Barry, Missouri, US | |
2153530 | 2153530 | 2022-07-16 | US | Missouri | Barry | 29009 | 7014 | 144 | 0 | 36.70978521 | -93.82919888 | 2022-07-17 04:21:15 | Barry, Missouri, US | |
2420763 | 2420763 | 2022-07-15 | US | Missouri | Barry | 29009 | 7014 | 144 | 0 | 36.70978521 | -93.82919888 | 2022-07-16 04:21:05 | Barry, Missouri, US | |
166699 | 166699 | 2022-06-21 | US | Colorado | Routt | 8107 | 7014 | 25 | 0 | 40.48596505 | -106.9905548 | 2022-06-22 04:20:54 | Routt, Colorado, US | |
3161122 | 3161122 | 2022-06-09 | US | West Virginia | Hancock | 54029 | 7014 | 142 | 0 | 40.51943859 | -80.57461608 | 2022-06-10 04:20:55 | Hancock, West Virginia, US | |
3580376 | 3580376 | 2022-06-02 | US | Minnesota | Nobles | 27105 | 7014 | 60 | 0 | 43.67434621 | -95.75329576 | 2022-06-03 04:20:58 | Nobles, Minnesota, US | |
1699860 | 1699860 | 2022-04-28 | US | West Virginia | Wyoming | 54109 | 7014 | 114 | 0 | 37.612327 | -81.54511071 | 2022-04-29 04:20:59 | Wyoming, West Virginia, US | |
1329504 | 1329504 | 2022-04-26 | US | Texas | Willacy | 48489 | 7014 | 130 | 0 | 26.47411727 | -97.61535848 | 2022-04-27 04:20:52 | Willacy, Texas, US | |
3724358 | 3724358 | 2022-04-25 | US | New Hampshire | Coos | 33007 | 7014 | 113 | 0 | 44.69063265 | -71.30633239 | 2022-04-26 04:20:51 | Coos, New Hampshire, US | |
2444463 | 2444463 | 2022-04-13 | US | Minnesota | Cass | 27021 | 7014 | 80 | 0 | 46.95043611 | -94.32603968 | 2022-04-13 23:21:06 | Cass, Minnesota, US | |
1952074 | 1952074 | 2022-04-12 | US | Wisconsin | Lincoln | 55069 | 7014 | 148 | 0 | 45.33737523 | -89.73411273 | 2022-04-13 04:21:03 | Lincoln, Wisconsin, US | |
2803330 | 2803330 | 2022-04-06 | US | Oklahoma | Garvin | 40049 | 7014 | 141 | 0 | 34.70418038 | -97.30811132 | 2022-04-07 04:20:53 | Garvin, Oklahoma, US | |
3870099 | 3870099 | 2022-04-05 | US | Oklahoma | Garvin | 40049 | 7014 | 141 | 0 | 34.70418038 | -97.30811132 | 2022-04-06 04:20:49 | Garvin, Oklahoma, US | |
2751441 | 2751441 | 2022-04-04 | US | Oklahoma | Garvin | 40049 | 7014 | 141 | 0 | 34.70418038 | -97.30811132 | 2022-04-05 04:20:48 | Garvin, Oklahoma, US | |
3732787 | 3732787 | 2022-04-03 | US | Oklahoma | Garvin | 40049 | 7014 | 141 | 0 | 34.70418038 | -97.30811132 | 2022-04-04 04:20:51 | Garvin, Oklahoma, US | |
502222 | 502222 | 2022-04-02 | US | Oklahoma | Garvin | 40049 | 7014 | 141 | 0 | 34.70418038 | -97.30811132 | 2022-04-03 04:20:48 | Garvin, Oklahoma, US | |
3353207 | 3353207 | 2022-04-01 | US | Oklahoma | Garvin | 40049 | 7014 | 141 | 0 | 34.70418038 | -97.30811132 | 2022-04-02 04:20:47 | Garvin, Oklahoma, US | |
1542512 | 1542512 | 2022-03-31 | US | Oklahoma | Garvin | 40049 | 7014 | 141 | 0 | 34.70418038 | -97.30811132 | 2022-04-01 04:20:28 | Garvin, Oklahoma, US | |
1659603 | 1659603 | 2022-03-19 | US | Texas | Palo Pinto | 48363 | 7014 | 152 | 0 | 32.75310985 | -98.31319001 | 2022-03-20 04:20:45 | Palo Pinto, Texas, US | |
339129 | 339129 | 2022-03-18 | US | Texas | Palo Pinto | 48363 | 7014 | 152 | 0 | 32.75310985 | -98.31319001 | 2022-03-19 04:20:47 | Palo Pinto, Texas, US | |
2322081 | 2322081 | 2022-03-16 | US | Puerto Rico | Humacao | 72069 | 7014 | 0 | 0 | 18.145211 | -65.810174 | 2022-03-17 04:20:56 | Humacao, Puerto Rico, US | |
1551273 | 1551273 | 2022-03-07 | US | Virginia | Amherst | 51009 | 7014 | 83 | 0 | 37.60308293 | -79.14548696 | 2022-03-08 04:20:54 | Amherst, Virginia, US | |
1550403 | 1550403 | 2022-03-07 | US | North Dakota | Stutsman | 38093 | 7014 | 96 | 0 | 46.97962541 | -98.95637318 | 2022-03-08 04:20:54 | Stutsman, North Dakota, US | |
2202072 | 2202072 | 2022-03-06 | US | North Dakota | Stutsman | 38093 | 7014 | 96 | 0 | 46.97962541 | -98.95637318 | 2022-03-07 04:20:47 | Stutsman, North Dakota, US | |
2094529 | 2094529 | 2022-03-05 | US | North Dakota | Stutsman | 38093 | 7014 | 96 | 0 | 46.97962541 | -98.95637318 | 2022-03-06 04:20:49 | Stutsman, North Dakota, US | |
3719172 | 3719172 | 2022-02-21 | US | Illinois | Fayette | 17051 | 7014 | 93 | 0 | 39.00072038 | -89.02452658 | 2022-02-22 04:21:01 | Fayette, Illinois, US | |
3913006 | 3913006 | 2022-02-20 | US | Illinois | Fayette | 17051 | 7014 | 93 | 0 | 39.00072038 | -89.02452658 | 2022-02-21 04:21:05 | Fayette, Illinois, US | |
3876564 | 3876564 | 2022-02-19 | US | Illinois | Fayette | 17051 | 7014 | 93 | 0 | 39.00072038 | -89.02452658 | 2022-02-20 04:21:00 | Fayette, Illinois, US | |
3856820 | 3856820 | 2022-02-18 | US | Illinois | Fayette | 17051 | 7014 | 93 | 0 | 39.00072038 | -89.02452658 | 2022-02-19 04:21:11 | Fayette, Illinois, US | |
1365412 | 1365412 | 2022-02-08 | US | Texas | Cooke | 48097 | 7014 | 121 | 0 | 33.63979567 | -97.21240912 | 2022-02-09 04:21:04 | Cooke, Texas, US | |
979361 | 979361 | 2022-02-01 | US | Alabama | Winston | 1133 | 7014 | 115 | 0 | 34.15030532 | -87.37325922 | 2022-02-02 04:21:09 | Winston, Alabama, US | |
1963524 | 1963524 | 2022-01-20 | US | Tennessee | Macon | 47111 | 7014 | 123 | 0 | 36.53157855 | -86.00778595 | 2022-01-21 04:21:09 | Macon, Tennessee, US | |
3289912 | 3289912 | 2021-11-18 | US | Illinois | Henry | 17073 | 7014 | 82 | 0 | 41.3533994 | -90.13296166 | 2021-11-19 04:21:40 | Henry, Illinois, US | |
2845256 | 2845256 | 2021-11-10 | US | Alabama | Russell | 1113 | 7014 | 62 | 0 | 32.28725256 | -85.18415324 | 2021-11-11 04:21:45 | Russell, Alabama, US | |
87526 | 87526 | 2021-11-09 | US | Alabama | Russell | 1113 | 7014 | 62 | 0 | 32.28725256 | -85.18415324 | 2021-11-10 04:21:38 | Russell, Alabama, US | |
2003647 | 2003647 | 2021-11-07 | US | Tennessee | Rhea | 47143 | 7014 | 93 | 0 | 35.60536161 | -84.93076643 | 2021-11-08 04:21:43 | Rhea, Tennessee, US | |
7269 | 7269 | 2021-10-28 | US | Tennessee | Cheatham | 47021 | 7014 | 70 | 0 | 36.26136216 | -87.08903581 | 2021-10-29 04:22:03 | Cheatham, Tennessee, US | |
599963 | 599963 | 2021-10-19 | US | North Carolina | Beaufort | 37013 | 7014 | 126 | 0 | 35.48531943 | -76.84325809 | 2021-10-20 04:21:00 | Beaufort, North Carolina, US | |
935355 | 935355 | 2021-10-16 | US | California | Lassen | 6035 | 7014 | 39 | 0 | 40.67311306 | -120.59350990000002 | 2021-10-17 04:21:29 | Lassen, California, US | |
2961335 | 2961335 | 2021-10-08 | US | Missouri | Scott | 29201 | 7014 | 111 | 0 | 37.05588075 | -89.56474493 | 2021-10-09 04:21:34 | Scott, Missouri, US | |
988383 | 988383 | 2021-10-04 | US | Kentucky | Graves | 21083 | 7014 | 118 | 0 | 36.72292505 | -88.65143315 | 2021-10-05 04:21:27 | Graves, Kentucky, US | |
3759350 | 3759350 | 2021-09-21 | US | Missouri | Callaway | 29027 | 7014 | 64 | 0 | 38.83674754 | -91.92186505 | 2021-09-22 04:21:45 | Callaway, Missouri, US | |
1263488 | 1263488 | 2021-09-09 | US | Florida | Hendry | 12051 | 7014 | 87 | 0 | 26.55386945 | -81.16469006 | 2021-09-10 04:21:20 | Hendry, Florida, US | |
2279858 | 2279858 | 2021-09-08 | US | Florida | Hendry | 12051 | 7014 | 87 | 0 | 26.55386945 | -81.16469006 | 2021-09-09 04:21:27 | Hendry, Florida, US | |
642637 | 642637 | 2021-09-07 | US | Florida | Hendry | 12051 | 7014 | 87 | 0 | 26.55386945 | -81.16469006 | 2021-09-08 04:21:31 | Hendry, Florida, US | |
3194700 | 3194700 | 2021-09-06 | US | Florida | Hendry | 12051 | 7014 | 87 | 0 | 26.55386945 | -81.16469006 | 2021-09-07 04:21:35 | Hendry, Florida, US | |
3281568 | 3281568 | 2021-09-05 | US | Florida | Hendry | 12051 | 7014 | 87 | 0 | 26.55386945 | -81.16469006 | 2021-09-06 04:21:22 | Hendry, Florida, US | |
249982 | 249982 | 2021-09-04 | US | Florida | Hendry | 12051 | 7014 | 87 | 0 | 26.55386945 | -81.16469006 | 2021-09-05 04:21:33 | Hendry, Florida, US | |
3975263 | 3975263 | 2021-09-03 | US | Florida | Hendry | 12051 | 7014 | 87 | 0 | 26.55386945 | -81.16469006 | 2021-09-04 04:21:28 | Hendry, Florida, US | |
832064 | 832064 | 2021-07-09 | US | Ohio | Hancock | 39063 | 7014 | 137 | 0 | 41.00250487 | -83.66838948 | 2021-07-10 04:21:25 | Hancock, Ohio, US | |
3381817 | 3381817 | 2021-06-13 | US | Arizona | Gila | 4007 | 7014 | 229 | 0 | 33.80190085 | -110.8132779 | 2021-06-14 04:22:46 | Gila, Arizona, US | |
1536038 | 1536038 | 2021-03-28 | Mongolia | 7014 | 6 | 4711 | 2872 | 46.8625 | 103.8467 | 2021-03-29 04:28:35 | Mongolia | |||
2187097 | 2187097 | 2021-02-26 | US | West Virginia | Wood | 54107 | 7014 | 130 | 0 | 6884 | 39.20967886 | -81.5162836 | 2021-02-27 05:22:28 | Wood, West Virginia, US |
3050702 | 3050702 | 2021-02-16 | US | Arkansas | White | 5145 | 7014 | 101 | 0 | 6913 | 35.25688493 | -91.74908296 | 2021-02-17 05:23:10 | White, Arkansas, US |
342958 | 342958 | 2021-02-03 | US | Pennsylvania | Northumberland | 42097 | 7014 | 303 | 0 | 6711 | 40.84785433 | -76.70798222 | 2021-02-04 05:22:26 | Northumberland, Pennsylvania, US |
2567970 | 2567970 | 2021-01-25 | Sweden | Blekinge | 7014 | 81 | 0 | 6933 | 56.2784 | 15.018 | 2021-01-26 05:22:02 | Blekinge, Sweden | ||
1759602 | 1759602 | 2021-01-24 | Sweden | Blekinge | 7014 | 81 | 0 | 6933 | 56.2784 | 15.018 | 2021-01-25 05:22:16 | Blekinge, Sweden | ||
1759327 | 1759327 | 2021-01-24 | Japan | Okinawa | 7014 | 90 | 6032 | 892 | 25.768923 | 126.668016 | 2021-01-25 05:22:16 | Okinawa, Japan | ||
2427209 | 2427209 | 2021-01-23 | Sweden | Blekinge | 7014 | 81 | 0 | 6933 | 56.2784 | 15.018 | 2021-01-24 05:22:35 | Blekinge, Sweden | ||
2467111 | 2467111 | 2021-01-22 | Sweden | Blekinge | 7014 | 81 | 0 | 6933 | 56.2784 | 15.018 | 2021-01-23 05:22:03 | Blekinge, Sweden | ||
3901003 | 3901003 | 2021-01-09 | US | Illinois | Vermilion | 17183 | 7014 | 81 | 0 | 6933 | 40.18417171 | -87.73384359 | 2021-01-10 05:22:12 | Vermilion, Illinois, US |
1036803 | 1036803 | 2020-12-15 | US | Ohio | Allen | 39003 | 7014 | 148 | 0 | 6866 | 40.77285242 | -84.10802343 | 2020-12-16 05:28:04 | Allen, Ohio, 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]);