johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
17 rows where country_or_region = "Netherlands" and "last_update" is on date 2020-10-03 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, last_update (date)
province_or_state 17
- Aruba 1
- Bonaire, Sint Eustatius and Saba 1
- Curacao 1
- Drenthe 1
- Flevoland 1
- Friesland 1
- Gelderland 1
- Groningen 1
- Limburg 1
- Noord-Brabant 1
- Noord-Holland 1
- Overijssel 1
- Sint Maarten 1
- Unknown 1
- Utrecht 1
- Zeeland 1
- Zuid-Holland 1
country_or_region 1
- Netherlands · 17 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3389502 | 3389502 | 2020-10-02 | Netherlands | Aruba | 4038 | 30 | 3406 | 602 | 12.5211 | -69.9683 | 2020-10-03 04:23:40 | Aruba, Netherlands | ||
3389503 | 3389503 | 2020-10-02 | Netherlands | Bonaire, Sint Eustatius and Saba | 121 | 1 | 32 | 88 | 12.1784 | -68.2385 | 2020-10-03 04:23:40 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
3389504 | 3389504 | 2020-10-02 | Netherlands | Curacao | 411 | 1 | 197 | 213 | 12.1696 | -68.99 | 2020-10-03 04:23:40 | Curacao, Netherlands | ||
3389505 | 3389505 | 2020-10-02 | Netherlands | Drenthe | 1331 | 49 | 0 | 1274 | 52.862485 | 6.618435000000002 | 2020-10-03 04:23:40 | Drenthe, Netherlands | ||
3389506 | 3389506 | 2020-10-02 | Netherlands | Flevoland | 2349 | 100 | 0 | 2242 | 52.550383 | 5.515162 | 2020-10-03 04:23:40 | Flevoland, Netherlands | ||
3389507 | 3389507 | 2020-10-02 | Netherlands | Friesland | 1789 | 69 | 0 | 1714 | 53.087337 | 5.7925 | 2020-10-03 04:23:40 | Friesland, Netherlands | ||
3389508 | 3389508 | 2020-10-02 | Netherlands | Gelderland | 12547 | 705 | 0 | 11712 | 52.061738 | 5.939114 | 2020-10-03 04:23:40 | Gelderland, Netherlands | ||
3389509 | 3389509 | 2020-10-02 | Netherlands | Groningen | 1965 | 20 | 0 | 1920 | 53.217922 | 6.741514 | 2020-10-03 04:23:40 | Groningen, Netherlands | ||
3389510 | 3389510 | 2020-10-02 | Netherlands | Limburg | 6914 | 767 | 0 | 6125 | 51.209227 | 5.93387 | 2020-10-03 04:23:40 | Limburg, Netherlands | ||
3389511 | 3389511 | 2020-10-02 | Netherlands | Noord-Brabant | 18478 | 1557 | 0 | 16861 | 51.561174 | 5.184942 | 2020-10-03 04:23:40 | Noord-Brabant, Netherlands | ||
3389512 | 3389512 | 2020-10-02 | Netherlands | Noord-Holland | 26332 | 871 | 0 | 25382 | 52.60090600000001 | 4.918688 | 2020-10-03 04:23:40 | Noord-Holland, Netherlands | ||
3389513 | 3389513 | 2020-10-02 | Netherlands | Overijssel | 5468 | 345 | 0 | 5110 | 52.444558 | 6.441722 | 2020-10-03 04:23:40 | Overijssel, Netherlands | ||
3389514 | 3389514 | 2020-10-02 | Netherlands | Sint Maarten | 674 | 22 | 572 | 80 | 18.0425 | -63.0548 | 2020-10-03 04:23:40 | Sint Maarten, Netherlands | ||
3389515 | 3389515 | 2020-10-02 | Netherlands | Unknown | 425 | 7 | 0 | 1045 | 2020-10-03 04:23:40 | Unknown, Netherlands | ||||
3389516 | 3389516 | 2020-10-02 | Netherlands | Utrecht | 10286 | 443 | 0 | 9785 | 52.084251 | 5.163824 | 2020-10-03 04:23:40 | Utrecht, Netherlands | ||
3389517 | 3389517 | 2020-10-02 | Netherlands | Zeeland | 1430 | 73 | 0 | 1355 | 51.47936 | 3.861559 | 2020-10-03 04:23:40 | Zeeland, Netherlands | ||
3389518 | 3389518 | 2020-10-02 | Netherlands | Zuid-Holland | 38608 | 1422 | 0 | 36969 | 51.937835 | 4.462114 | 2020-10-03 04:23:40 | Zuid-Holland, Netherlands |
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]);