johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where confirmed = 19672 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2558817 | 2558817 | 2022-11-29 | US | New York | Cayuga | 36011 | 19672 | 171 | 0 | 42.91261714 | -76.55731592 | 2022-11-30 04:21:07 | Cayuga, New York, US | |
2378496 | 2378496 | 2022-09-29 | US | Tennessee | Hawkins | 47073 | 19672 | 342 | 0 | 36.44355426 | -82.94885298 | 2022-09-30 04:23:09 | Hawkins, Tennessee, US | |
1683810 | 1683810 | 2022-08-29 | US | Virginia | Bedford | 51019 | 19672 | 256 | 0 | 37.3080028 | -79.5281964 | 2022-08-30 04:21:03 | Bedford, Virginia, US | |
896517 | 896517 | 2022-07-24 | US | Alabama | DeKalb | 1049 | 19672 | 333 | 0 | 34.45946862 | -85.80782906 | 2022-07-25 04:20:51 | DeKalb, Alabama, US | |
91511 | 91511 | 2022-07-23 | US | Alabama | DeKalb | 1049 | 19672 | 333 | 0 | 34.45946862 | -85.80782906 | 2022-07-24 04:20:47 | DeKalb, Alabama, US | |
900533 | 900533 | 2022-07-22 | US | Alabama | DeKalb | 1049 | 19672 | 333 | 0 | 34.45946862 | -85.80782906 | 2022-07-23 04:20:53 | DeKalb, Alabama, US | |
3890925 | 3890925 | 2022-06-06 | US | Virginia | Augusta | 51015 | 19672 | 209 | 0 | 38.16404586 | -79.12461614 | 2022-06-07 04:21:08 | Augusta, Virginia, US | |
1652619 | 1652619 | 2022-04-09 | Russia | Magadan Oblast | 19672 | 388 | 0 | 62.48858785 | 153.9903764 | 2022-04-10 04:20:52 | Magadan Oblast, Russia | |||
3024892 | 3024892 | 2022-03-23 | US | Oregon | Douglas | 41019 | 19672 | 379 | 0 | 43.27941273 | -123.16729099999999 | 2022-03-24 04:20:43 | Douglas, Oregon, US | |
1550214 | 1550214 | 2022-03-07 | US | New York | Jefferson | 36045 | 19672 | 130 | 0 | 44.04200959 | -75.94653457 | 2022-03-08 04:20:54 | Jefferson, New York, US | |
2526473 | 2526473 | 2022-03-02 | US | Indiana | Kosciusko | 18085 | 19672 | 225 | 0 | 41.24521668 | -85.86312322 | 2022-03-03 04:21:01 | Kosciusko, Indiana, US | |
3671666 | 3671666 | 2022-02-15 | Japan | Oita | 19672 | 90 | 0 | 33.200697 | 131.43323999999998 | 2022-02-16 04:21:10 | Oita, Japan | |||
165499 | 165499 | 2021-11-19 | US | West Virginia | Berkeley | 54003 | 19672 | 190 | 0 | 39.46704621 | -78.02414609 | 2021-11-20 04:22:17 | Berkeley, West Virginia, US | |
1119501 | 1119501 | 2021-08-06 | US | Missouri | Jasper | 29097 | 19672 | 271 | 0 | 37.20351921 | -94.34050458 | 2021-08-07 04:21:30 | Jasper, Missouri, US | |
409334 | 409334 | 2021-07-28 | US | Illinois | Sangamon | 17167 | 19672 | 245 | 0 | 39.75836914 | -89.65872023 | 2021-07-29 04:21:33 | Sangamon, Illinois, US | |
2106423 | 2106423 | 2021-06-01 | US | North Carolina | Catawba | 37035 | 19672 | 307 | 0 | 35.66211129 | -81.2132617 | 2021-06-02 04:24:34 | Catawba, North Carolina, US | |
170154 | 170154 | 2021-04-16 | Mongolia | 19672 | 41 | 11044 | 8591 | 46.8625 | 103.8467 | 2021-04-17 04:20:40 | Mongolia | |||
354775 | 354775 | 2021-03-11 | US | Ohio | Mahoning | 39099 | 19672 | 594 | 0 | 41.01631101 | -80.77287029 | 2021-03-12 05:26:50 | Mahoning, Ohio, US | |
1000229 | 1000229 | 2021-03-01 | US | Mississippi | DeSoto | 28033 | 19672 | 230 | 0 | 19442 | 34.87625235 | -89.99091418 | 2021-03-02 05:23:30 | DeSoto, Mississippi, US |
3068241 | 3068241 | 2021-02-27 | US | New York | Oneida | 36065 | 19672 | 475 | 0 | 19197 | 43.24375382 | -75.43710392 | 2021-02-28 05:22:20 | Oneida, New York, US |
2481662 | 2481662 | 2021-01-28 | Angola | 19672 | 464 | 17692 | 1516 | -11.2027 | 17.8739 | 2021-01-29 05:22:23 | Angola | |||
2231085 | 2231085 | 2021-01-02 | US | Wisconsin | Racine | 55101 | 19672 | 259 | 0 | 19413 | 42.74753117 | -88.05941254 | 2021-01-03 05:22:52 | Racine, Wisconsin, US |
768701 | 768701 | 2020-12-29 | US | North Dakota | Cass | 38017 | 19672 | 165 | 0 | 19550 | 46.93201724 | -97.2444719 | 2020-12-30 05:22:34 | Cass, North Dakota, US |
2915390 | 2915390 | 2020-11-14 | Russia | Khabarovsk Krai | 19672 | 146 | 12897 | 6629 | 51.6312684 | 136.121524 | 2020-11-15 05:26:53 | Khabarovsk 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]);