johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where confirmed = 20500 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 11
- India 1
- Japan 1
- Russia 1
- San Marino 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1626523 | 1626523 | 2022-09-22 | US | New York | Clinton | 36019 | 20500 | 103 | 0 | 44.74530905 | -73.67875352 | 2022-09-23 04:23:13 | Clinton, New York, US | |
2395076 | 2395076 | 2022-09-12 | San Marino | 20500 | 118 | 0 | 43.9424 | 12.4578 | 2022-09-13 04:20:57 | San Marino | ||||
2527636 | 2527636 | 2022-03-02 | US | New York | St. Lawrence | 36089 | 20500 | 176 | 0 | 44.4976179 | -75.06550039 | 2022-03-03 04:21:01 | St. Lawrence, New York, US | |
3718215 | 3718215 | 2022-02-21 | Japan | Wakayama | 20500 | 93 | 0 | 33.911879 | 135.505446 | 2022-02-22 04:21:01 | Wakayama, Japan | |||
1298971 | 1298971 | 2022-02-17 | US | Idaho | Bannock | 16005 | 20500 | 235 | 0 | 42.67002716 | -112.2233311 | 2022-02-18 04:21:04 | Bannock, Idaho, US | |
1364580 | 1364580 | 2022-02-08 | US | New York | Chemung | 36015 | 20500 | 222 | 0 | 42.13891056 | -76.7638805 | 2022-02-09 04:21:04 | Chemung, New York, US | |
3007729 | 3007729 | 2021-10-11 | US | Alabama | Morgan | 1103 | 20500 | 361 | 0 | 34.45500589 | -86.85475946 | 2021-10-12 04:21:09 | Morgan, Alabama, US | |
3105408 | 3105408 | 2021-08-24 | India | Ladakh | 20500 | 207 | 0 | 34.1526 | 77.5771 | 2021-08-25 04:21:41 | Ladakh, India | |||
1873178 | 1873178 | 2021-05-15 | Russia | Mordovia Republic | 20500 | 258 | 18353 | 1889 | 54.4419829 | 44.4661144 | 2021-05-16 04:20:49 | Mordovia Republic, Russia | ||
889326 | 889326 | 2021-04-26 | US | Iowa | Linn | 19113 | 20500 | 332 | 0 | 42.07923082 | -91.59809485 | 2021-04-27 04:20:52 | Linn, Iowa, US | |
1153680 | 1153680 | 2021-02-18 | US | California | Placer | 6061 | 20500 | 232 | 0 | 20321 | 39.06167234 | -120.7240569 | 2021-02-19 05:24:16 | Placer, California, US |
3517785 | 3517785 | 2021-01-15 | US | North Dakota | Cass | 38017 | 20500 | 179 | 0 | 20394 | 46.93201724 | -97.2444719 | 2021-01-16 05:22:40 | Cass, North Dakota, US |
861124 | 861124 | 2020-12-11 | US | Arizona | Pinal | 4021 | 20500 | 292 | 0 | 20208 | 32.90525627 | -111.3449483 | 2020-12-12 05:26:19 | Pinal, Arizona, US |
3802611 | 3802611 | 2020-10-05 | US | Florida | Polk | 12105 | 20500 | 533 | 0 | 19967 | 27.95027105 | -81.69732947 | 2020-10-06 04:23:33 | Polk, Florida, US |
815143 | 815143 | 2020-09-05 | US | Maryland | Montgomery | 24031 | 20500 | 823 | 0 | 19677 | 39.13676329 | -77.20358245 | 2020-09-06 04:28:33 | Montgomery, Maryland, 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]);