johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where confirmed = 23351 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
219427 | 219427 | 2022-12-26 | US | Kentucky | McCracken | 21145 | 23351 | 305 | 0 | 37.05350953 | -88.70445755 | 2022-12-27 04:21:07 | McCracken, Kentucky, US | |
3223884 | 3223884 | 2022-12-25 | US | Kentucky | McCracken | 21145 | 23351 | 305 | 0 | 37.05350953 | -88.70445755 | 2022-12-26 04:21:06 | McCracken, Kentucky, US | |
1019798 | 1019798 | 2022-12-24 | US | Kentucky | McCracken | 21145 | 23351 | 305 | 0 | 37.05350953 | -88.70445755 | 2022-12-25 04:21:04 | McCracken, Kentucky, US | |
691821 | 691821 | 2022-12-23 | US | Kentucky | McCracken | 21145 | 23351 | 305 | 0 | 37.05350953 | -88.70445755 | 2022-12-24 04:21:02 | McCracken, Kentucky, US | |
2181031 | 2181031 | 2022-12-22 | US | Kentucky | McCracken | 21145 | 23351 | 305 | 0 | 37.05350953 | -88.70445755 | 2022-12-23 04:21:04 | McCracken, Kentucky, US | |
452835 | 452835 | 2022-12-21 | US | Kentucky | McCracken | 21145 | 23351 | 305 | 0 | 37.05350953 | -88.70445755 | 2022-12-22 04:20:56 | McCracken, Kentucky, US | |
2952834 | 2952834 | 2022-12-20 | US | Kentucky | McCracken | 21145 | 23351 | 305 | 0 | 37.05350953 | -88.70445755 | 2022-12-21 04:21:03 | McCracken, Kentucky, US | |
3175236 | 3175236 | 2022-12-19 | US | Kentucky | McCracken | 21145 | 23351 | 305 | 0 | 37.05350953 | -88.70445755 | 2022-12-20 04:21:04 | McCracken, Kentucky, US | |
3756911 | 3756911 | 2022-10-13 | US | Washington | Chelan | 53007 | 23351 | 186 | 0 | 47.87046092 | -120.6173956 | 2022-10-14 04:22:28 | Chelan, Washington, US | |
3217736 | 3217736 | 2022-10-12 | US | Washington | Chelan | 53007 | 23351 | 186 | 0 | 47.87046092 | -120.6173956 | 2022-10-13 04:22:39 | Chelan, Washington, US | |
2019897 | 2019897 | 2022-09-20 | US | Texas | Maverick | 48323 | 23351 | 473 | 0 | 28.7429195 | -100.3157686 | 2022-09-21 04:23:22 | Maverick, Texas, US | |
3573770 | 3573770 | 2022-09-19 | US | Texas | Maverick | 48323 | 23351 | 473 | 0 | 28.7429195 | -100.3157686 | 2022-09-20 04:22:48 | Maverick, Texas, US | |
2855117 | 2855117 | 2022-08-22 | US | New York | Ontario | 36069 | 23351 | 191 | 0 | 42.85145728 | -77.30874425 | 2022-08-23 04:20:56 | Ontario, New York, US | |
2405089 | 2405089 | 2022-08-21 | US | New York | Ontario | 36069 | 23351 | 191 | 0 | 42.85145728 | -77.30874425 | 2022-08-22 04:20:38 | Ontario, New York, US | |
3409012 | 3409012 | 2022-07-17 | US | Wisconsin | Jefferson | 55055 | 23351 | 246 | 0 | 43.02054068 | -88.77529134 | 2022-07-18 04:20:59 | Jefferson, Wisconsin, US | |
2155212 | 2155212 | 2022-07-16 | US | Wisconsin | Jefferson | 55055 | 23351 | 246 | 0 | 43.02054068 | -88.77529134 | 2022-07-17 04:21:15 | Jefferson, Wisconsin, US | |
2422445 | 2422445 | 2022-07-15 | US | Wisconsin | Jefferson | 55055 | 23351 | 246 | 0 | 43.02054068 | -88.77529134 | 2022-07-16 04:21:05 | Jefferson, Wisconsin, US | |
3110022 | 3110022 | 2022-07-13 | US | Arkansas | White | 5145 | 23351 | 303 | 0 | 35.25688493 | -91.74908296 | 2022-07-14 04:20:57 | White, Arkansas, US | |
560384 | 560384 | 2022-06-16 | US | Maryland | Carroll | 24013 | 23351 | 414 | 0 | 39.56453592 | -77.02373735 | 2022-06-17 04:20:56 | Carroll, Maryland, US | |
921945 | 921945 | 2022-03-08 | US | New York | Putnam | 36079 | 23351 | 121 | 0 | 41.42630093 | -73.74965532 | 2022-03-09 04:20:59 | Putnam, New York, US | |
6967 | 6967 | 2021-10-28 | US | Oregon | Jackson | 41029 | 23351 | 318 | 0 | 42.43201126 | -122.72893090000001 | 2021-10-29 04:22:03 | Jackson, Oregon, US | |
3007414 | 3007414 | 2021-10-11 | Mexico | Campeche | 23351 | 2000 | 0 | 19.8301 | -90.5349 | 2021-10-12 04:21:09 | Campeche, Mexico | |||
642978 | 642978 | 2021-09-07 | US | Illinois | Sangamon | 17167 | 23351 | 255 | 0 | 39.75836914 | -89.65872023 | 2021-09-08 04:21:31 | Sangamon, Illinois, US | |
2717215 | 2717215 | 2021-06-10 | Russia | Sakhalin Oblast | 23351 | 55 | 22732 | 564 | 49.7219665 | 143.448533 | 2021-06-11 04:23:20 | Sakhalin Oblast, Russia | ||
889754 | 889754 | 2021-04-26 | US | Michigan | Ingham | 26065 | 23351 | 342 | 0 | 42.59716886 | -84.37472069 | 2021-04-27 04:20:52 | Ingham, Michigan, US | |
2549075 | 2549075 | 2021-04-15 | Russia | Kabardino-Balkarian Republic | 23351 | 431 | 22409 | 511 | 43.4806048 | 43.5978976 | 2021-04-16 04:20:46 | Kabardino-Balkarian Republic, Russia | ||
2571873 | 2571873 | 2021-04-13 | Russia | Chuvashia Republic | 23351 | 1292 | 21278 | 781 | 55.4259922 | 47.0849429 | 2021-04-14 04:20:41 | Chuvashia Republic, Russia | ||
3453245 | 3453245 | 2021-03-18 | US | Alabama | Montgomery | 1101 | 23351 | 541 | 0 | 32.2206831 | -86.20969272 | 2021-03-19 05:26:09 | Montgomery, Alabama, US | |
2921770 | 2921770 | 2020-11-04 | US | Oklahoma | Tulsa | 40143 | 23351 | 219 | 0 | 23132 | 36.11939621 | -95.94013939 | 2020-11-05 06:05:03 | Tulsa, Oklahoma, US |
11650 | 11650 | 2020-10-25 | US | Virginia | Fairfax | 51059 | 23351 | 606 | 0 | 22745 | 38.83677558 | -77.27565836 | 2020-10-26 04:25:02 | Fairfax, Virginia, US |
1041972 | 1041972 | 2020-10-07 | Peru | Ancash | 23351 | 2550 | 0 | 20801 | -9.407125 | -77.67179499999997 | 2020-10-08 04:23:56 | Ancash, Peru | ||
3683053 | 3683053 | 2020-06-18 | Panama | 23351 | 475 | 13782 | 9094 | 8.538 | -80.7821 | 2020-06-19 04:33:17 | Panama |
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]);