johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
63 rows where confirmed = 9123 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
454708 | 454708 | 2022-12-21 | US | Virginia | Carroll | 51035 | 9123 | 162 | 0 | 36.73066666 | -80.73455942 | 2022-12-22 04:20:56 | Carroll, Virginia, US | |
1152453 | 1152453 | 2022-12-12 | US | West Virginia | Nicholas | 54067 | 9123 | 108 | 0 | 38.29617706 | -80.79759588 | 2022-12-13 04:21:01 | Nicholas, West Virginia, US | |
852395 | 852395 | 2022-11-02 | US | Puerto Rico | Yabucoa | 72151 | 9123 | 0 | 0 | 18.070399 | -65.896289 | 2022-11-03 04:22:05 | Yabucoa, Puerto Rico, US | |
2019989 | 2019989 | 2022-09-20 | US | Texas | Wood | 48499 | 9123 | 297 | 0 | 32.78722382 | -95.38236368 | 2022-09-21 04:23:22 | Wood, Texas, US | |
3573862 | 3573862 | 2022-09-19 | US | Texas | Wood | 48499 | 9123 | 297 | 0 | 32.78722382 | -95.38236368 | 2022-09-20 04:22:48 | Wood, Texas, US | |
2343945 | 2343945 | 2022-08-31 | US | Arkansas | Poinsett | 5111 | 9123 | 133 | 0 | 35.57433534 | -90.66268713 | 2022-09-01 04:21:03 | Poinsett, Arkansas, US | |
3651172 | 3651172 | 2022-08-14 | US | Wisconsin | Trempealeau | 55121 | 9123 | 67 | 0 | 44.30360275 | -91.35893614 | 2022-08-15 04:20:59 | Trempealeau, Wisconsin, US | |
1972178 | 1972178 | 2022-08-13 | US | Wisconsin | Trempealeau | 55121 | 9123 | 67 | 0 | 44.30360275 | -91.35893614 | 2022-08-14 04:20:55 | Trempealeau, Wisconsin, US | |
2891987 | 2891987 | 2022-08-12 | US | Wisconsin | Trempealeau | 55121 | 9123 | 67 | 0 | 44.30360275 | -91.35893614 | 2022-08-13 04:20:52 | Trempealeau, Wisconsin, US | |
1089044 | 1089044 | 2022-08-09 | US | Tennessee | Macon | 47111 | 9123 | 150 | 0 | 36.53157855 | -86.00778595 | 2022-08-10 04:20:57 | Macon, Tennessee, US | |
676599 | 676599 | 2022-07-30 | US | New York | Wyoming | 36121 | 9123 | 85 | 0 | 42.70145109 | -78.22199579 | 2022-07-31 04:21:02 | Wyoming, New York, US | |
1491056 | 1491056 | 2022-07-26 | US | Washington | Whitman | 53075 | 9123 | 92 | 0 | 46.90022523 | -117.5241763 | 2022-07-27 04:21:04 | Whitman, Washington, US | |
2597502 | 2597502 | 2022-07-25 | US | Washington | Whitman | 53075 | 9123 | 92 | 0 | 46.90022523 | -117.5241763 | 2022-07-26 04:20:58 | Whitman, Washington, US | |
1422803 | 1422803 | 2022-06-08 | US | Minnesota | Becker | 27005 | 9123 | 95 | 0 | 46.93479392 | -95.67158144 | 2022-06-09 04:20:54 | Becker, Minnesota, US | |
1422699 | 1422699 | 2022-06-08 | US | Maryland | Worcester | 24047 | 9123 | 160 | 0 | 38.21274277 | -75.33200012 | 2022-06-09 04:20:54 | Worcester, Maryland, US | |
1574358 | 1574358 | 2022-05-03 | US | New York | Allegany | 36003 | 9123 | 154 | 0 | 42.25748406 | -78.02750466 | 2022-05-04 04:20:59 | Allegany, New York, US | |
2310658 | 2310658 | 2022-04-20 | US | Virginia | Manassas | 51683 | 9123 | 70 | 0 | 38.7464321 | -77.48509905 | 2022-04-21 04:20:46 | Manassas, Virginia, US | |
2446128 | 2446128 | 2022-04-13 | US | Virginia | Manassas | 51683 | 9123 | 70 | 0 | 38.7464321 | -77.48509905 | 2022-04-13 23:21:06 | Manassas, Virginia, US | |
2445343 | 2445343 | 2022-04-13 | US | Oklahoma | Ottawa | 40115 | 9123 | 124 | 0 | 36.83532655 | -94.81011909 | 2022-04-13 23:21:06 | Ottawa, Oklahoma, US | |
1951100 | 1951100 | 2022-04-12 | US | Oklahoma | Ottawa | 40115 | 9123 | 124 | 0 | 36.83532655 | -94.81011909 | 2022-04-13 04:21:03 | Ottawa, Oklahoma, US | |
3208853 | 3208853 | 2022-04-11 | US | Oklahoma | Ottawa | 40115 | 9123 | 124 | 0 | 36.83532655 | -94.81011909 | 2022-04-12 04:20:49 | Ottawa, Oklahoma, US | |
1578739 | 1578739 | 2022-04-10 | US | Oklahoma | Ottawa | 40115 | 9123 | 124 | 0 | 36.83532655 | -94.81011909 | 2022-04-11 04:21:02 | Ottawa, Oklahoma, US | |
1654981 | 1654981 | 2022-04-09 | US | Oklahoma | Ottawa | 40115 | 9123 | 124 | 0 | 36.83532655 | -94.81011909 | 2022-04-10 04:20:52 | Ottawa, Oklahoma, US | |
2118303 | 2118303 | 2022-04-08 | US | Oklahoma | Ottawa | 40115 | 9123 | 124 | 0 | 36.83532655 | -94.81011909 | 2022-04-09 04:20:42 | Ottawa, Oklahoma, US | |
3322827 | 3322827 | 2022-04-07 | US | Oklahoma | Ottawa | 40115 | 9123 | 124 | 0 | 36.83532655 | -94.81011909 | 2022-04-08 04:20:48 | Ottawa, Oklahoma, US | |
158553 | 158553 | 2022-03-29 | US | California | Amador | 6005 | 9123 | 86 | 0 | 38.44583082 | -120.65696000000001 | 2022-03-30 04:20:45 | Amador, California, US | |
2266046 | 2266046 | 2022-03-14 | US | New Hampshire | Carroll | 33003 | 9123 | 56 | 0 | 43.87498583 | -71.20430216 | 2022-03-15 04:20:47 | Carroll, New Hampshire, US | |
920217 | 920217 | 2022-03-08 | US | Arkansas | Union | 5139 | 9123 | 165 | 0 | 33.16887091 | -92.59746952 | 2022-03-09 04:20:59 | Union, Arkansas, US | |
3822731 | 3822731 | 2022-02-16 | US | North Carolina | Bladen | 37017 | 9123 | 117 | 0 | 34.61296243 | -78.56180059 | 2022-02-17 04:20:56 | Bladen, North Carolina, US | |
1365771 | 1365771 | 2022-02-08 | US | Virginia | Tazewell | 51185 | 9123 | 136 | 0 | 37.12191123 | -81.56685568 | 2022-02-09 04:21:04 | Tazewell, Virginia, US | |
1363382 | 1363382 | 2022-02-08 | US | Illinois | Morgan | 17137 | 9123 | 116 | 0 | 39.71654544 | -90.20255104 | 2022-02-09 04:21:04 | Morgan, Illinois, US | |
1296543 | 1296543 | 2022-02-05 | US | Ohio | Preble | 39135 | 9123 | 188 | 0 | 39.7420247 | -84.64787018 | 2022-02-06 04:21:00 | Preble, Ohio, US | |
1142773 | 1142773 | 2022-01-23 | US | Mississippi | Washington | 28151 | 9123 | 171 | 0 | 33.28392041 | -90.94196237 | 2022-01-24 04:21:12 | Washington, Mississippi, US | |
2834691 | 2834691 | 2022-01-22 | US | Mississippi | Washington | 28151 | 9123 | 171 | 0 | 33.28392041 | -90.94196237 | 2022-01-23 04:21:13 | Washington, Mississippi, US | |
3426809 | 3426809 | 2022-01-21 | US | Mississippi | Washington | 28151 | 9123 | 171 | 0 | 33.28392041 | -90.94196237 | 2022-01-22 04:21:13 | Washington, Mississippi, US | |
557827 | 557827 | 2022-01-16 | US | Texas | Burnet | 48053 | 9123 | 139 | 0 | 30.78801353 | -98.181887 | 2022-01-17 04:21:08 | Burnet, Texas, US | |
3689995 | 3689995 | 2022-01-13 | US | Ohio | Shelby | 39149 | 9123 | 164 | 0 | 40.33163494 | -84.20258189 | 2022-01-14 04:21:54 | Shelby, Ohio, US | |
1288331 | 1288331 | 2022-01-04 | US | North Carolina | Halifax | 37083 | 9123 | 146 | 0 | 36.25669272 | -77.6556109 | 2022-01-05 04:21:59 | Halifax, North Carolina, US | |
3519434 | 3519434 | 2022-01-02 | Japan | Kagoshima | 9123 | 66 | 0 | 31.009484000000004 | 130.430665 | 2022-01-03 02:22:25 | Kagoshima, Japan | |||
3819439 | 3819439 | 2021-12-23 | US | Texas | Atascosa | 48013 | 9123 | 211 | 0 | 28.89333001 | -98.52730485 | 2021-12-24 04:21:34 | Atascosa, Texas, US | |
2907263 | 2907263 | 2021-12-19 | US | Wisconsin | Grant | 55043 | 9123 | 124 | 0 | 42.8671731 | -90.7063218 | 2021-12-20 04:21:43 | Grant, Wisconsin, US | |
1262336 | 1262336 | 2021-12-18 | US | Wisconsin | Grant | 55043 | 9123 | 124 | 0 | 42.8671731 | -90.7063218 | 2021-12-19 04:21:11 | Grant, Wisconsin, US | |
2402364 | 2402364 | 2021-12-17 | US | Wisconsin | Grant | 55043 | 9123 | 124 | 0 | 42.8671731 | -90.7063218 | 2021-12-18 02:22:20 | Grant, Wisconsin, US | |
45345 | 45345 | 2021-11-02 | US | Michigan | Grand Traverse | 26055 | 9123 | 118 | 0 | 44.69565625 | -85.55585247 | 2021-11-03 06:22:09 | Grand Traverse, Michigan, US | |
3513041 | 3513041 | 2021-11-01 | US | Michigan | Grand Traverse | 26055 | 9123 | 118 | 0 | 44.69565625 | -85.55585247 | 2021-11-02 04:22:03 | Grand Traverse, Michigan, US | |
2044416 | 2044416 | 2021-10-18 | US | California | Nevada | 6057 | 9123 | 90 | 0 | 39.30394768 | -120.76272809999999 | 2021-10-19 04:20:54 | Nevada, California, US | |
2461912 | 2461912 | 2021-10-06 | US | Texas | Hood | 48221 | 9123 | 184 | 0 | 32.42990927 | -97.83242024 | 2021-10-07 04:21:36 | Hood, Texas, US | |
812877 | 812877 | 2021-09-20 | US | Virginia | Augusta | 51015 | 9123 | 101 | 0 | 38.16404586 | -79.12461614 | 2021-09-21 04:21:26 | Augusta, Virginia, US | |
180962 | 180962 | 2021-09-02 | US | Tennessee | Gibson | 47053 | 9123 | 161 | 0 | 35.99438059 | -88.93358327 | 2021-09-03 04:21:20 | Gibson, Tennessee, US | |
3140994 | 3140994 | 2021-07-23 | US | Washington | Kitsap | 53035 | 9123 | 123 | 0 | 47.63479026 | -122.6436061 | 2021-07-24 00:21:36 | Kitsap, Washington, US | |
3479754 | 3479754 | 2021-07-22 | US | Washington | Kitsap | 53035 | 9123 | 123 | 0 | 47.63479026 | -122.6436061 | 2021-07-23 04:21:29 | Kitsap, Washington, US | |
3361931 | 3361931 | 2021-06-21 | US | Utah | Central Utah | 9123 | 69 | 0 | 39.37231946 | -111.5758676 | 2021-06-22 04:21:34 | Central Utah, Utah, US | ||
3030298 | 3030298 | 2021-06-16 | Japan | Gifu | 9123 | 182 | 8821 | 120 | 35.778671 | 137.055925 | 2021-06-17 04:22:36 | Gifu, Japan | ||
23755 | 23755 | 2021-05-28 | US | Virginia | Portsmouth | 51740 | 9123 | 199 | 0 | 36.85914825 | -76.35971629 | 2021-05-29 04:20:41 | Portsmouth, Virginia, US | |
957544 | 957544 | 2021-04-25 | US | Pennsylvania | Mercer | 42085 | 9123 | 253 | 0 | 41.30248872 | -80.25816981 | 2021-04-26 04:21:04 | Mercer, Pennsylvania, US | |
3647096 | 3647096 | 2021-03-30 | US | Wisconsin | Jefferson | 55055 | 9123 | 126 | 0 | 43.02054068 | -88.77529134 | 2021-03-31 04:26:25 | Jefferson, Wisconsin, US | |
1838328 | 1838328 | 2021-03-12 | US | Alabama | St. Clair | 1115 | 9123 | 230 | 0 | 33.71902176 | -86.31029372 | 2021-03-13 05:25:15 | St. Clair, Alabama, US | |
2543393 | 2543393 | 2021-01-07 | US | Montana | Flathead | 30029 | 9123 | 56 | 0 | 9067 | 48.29575866 | -114.0520569 | 2021-01-08 05:22:42 | Flathead, Montana, US |
738473 | 738473 | 2020-12-02 | Peru | Tumbes | 9123 | 732 | 0 | 8391 | -3.857496 | -80.54525500000003 | 2020-12-03 05:28:22 | Tumbes, Peru | ||
2537567 | 2537567 | 2020-12-01 | Peru | Tumbes | 9123 | 731 | 0 | 8392 | -3.857496 | -80.54525500000003 | 2020-12-02 05:27:41 | Tumbes, Peru | ||
211293 | 211293 | 2020-10-29 | US | Indiana | Allen | 18003 | 9123 | 239 | 0 | 8884 | 41.09194313 | -85.06800636 | 2020-10-30 04:24:49 | Allen, Indiana, US |
1996940 | 1996940 | 2020-08-26 | Spain | Navarra | 9123 | 533 | 3905 | 4685 | 42.6954 | -1.6761 | 2020-08-27 04:28:15 | Navarra, Spain | ||
3562801 | 3562801 | 2020-08-25 | Russia | Primorsky Krai | 9123 | 101 | 7250 | 1772 | 45.0819456 | 134.726645 | 2020-08-26 04:28:11 | Primorsky Krai, Russia |
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]);