johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
39 rows where deaths = 17 and province_or_state = "Groningen" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: latitude, day (date), last_update (date)
province_or_state 1
- Groningen · 39 ✖
country_or_region 1
- Netherlands 39
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2991392 | 2991392 | 2020-08-24 | Netherlands | Groningen | 565 | 17 | 0 | 541 | 53.217922 | 6.741514 | 2020-08-25 04:28:02 | Groningen, Netherlands | ||
2215787 | 2215787 | 2020-08-23 | Netherlands | Groningen | 562 | 17 | 0 | 538 | 53.217922 | 6.741514 | 2020-08-24 04:27:56 | Groningen, Netherlands | ||
2299569 | 2299569 | 2020-08-22 | Netherlands | Groningen | 556 | 17 | 0 | 532 | 53.217922 | 6.741514 | 2020-08-23 04:27:48 | Groningen, Netherlands | ||
1479676 | 1479676 | 2020-08-21 | Netherlands | Groningen | 546 | 17 | 0 | 523 | 53.217922 | 6.741514 | 2020-08-22 04:27:49 | Groningen, Netherlands | ||
3484425 | 3484425 | 2020-08-20 | Netherlands | Groningen | 539 | 17 | 0 | 516 | 53.217922 | 6.741514 | 2020-08-21 04:27:41 | Groningen, Netherlands | ||
206374 | 206374 | 2020-08-19 | Netherlands | Groningen | 530 | 17 | 0 | 508 | 53.217922 | 6.741514 | 2020-08-20 04:27:43 | Groningen, Netherlands | ||
3178128 | 3178128 | 2020-08-18 | Netherlands | Groningen | 525 | 17 | 0 | 503 | 53.217922 | 6.741514 | 2020-08-19 04:27:00 | Groningen, Netherlands | ||
837732 | 837732 | 2020-08-17 | Netherlands | Groningen | 516 | 17 | 0 | 492 | 53.217922 | 6.741514 | 2020-08-18 04:27:56 | Groningen, Netherlands | ||
1556090 | 1556090 | 2020-08-16 | Netherlands | Groningen | 507 | 17 | 0 | 483 | 53.217922 | 6.741514 | 2020-08-17 04:27:20 | Groningen, Netherlands | ||
146092 | 146092 | 2020-08-15 | Netherlands | Groningen | 492 | 17 | 0 | 473 | 53.217922 | 6.741514 | 2020-08-16 04:27:42 | Groningen, Netherlands | ||
1612367 | 1612367 | 2020-08-14 | Netherlands | Groningen | 484 | 17 | 0 | 465 | 53.217922 | 6.741514 | 2020-08-15 04:27:31 | Groningen, Netherlands | ||
582951 | 582951 | 2020-08-13 | Netherlands | Groningen | 472 | 17 | 0 | 453 | 53.217922 | 6.741514 | 2020-08-14 04:51:19 | Groningen, Netherlands | ||
3531570 | 3531570 | 2020-08-12 | Netherlands | Groningen | 459 | 17 | 0 | 439 | 53.217922 | 6.741514 | 2020-08-13 04:29:15 | Groningen, Netherlands | ||
662419 | 662419 | 2020-08-11 | Netherlands | Groningen | 448 | 17 | 0 | 429 | 53.217922 | 6.741514 | 2020-08-12 04:27:29 | Groningen, Netherlands | ||
1920309 | 1920309 | 2020-08-10 | Netherlands | Groningen | 444 | 17 | 0 | 424 | 53.217922 | 6.741514 | 2020-08-11 04:35:08 | Groningen, Netherlands | ||
3923118 | 3923118 | 2020-08-09 | Netherlands | Groningen | 434 | 17 | 0 | 415 | 53.217922 | 6.741514 | 2020-08-10 04:34:55 | Groningen, Netherlands | ||
371286 | 371286 | 2020-08-08 | Netherlands | Groningen | 427 | 17 | 0 | 408 | 53.217922 | 6.741514 | 2020-08-09 04:34:54 | Groningen, Netherlands | ||
458470 | 458470 | 2020-08-07 | Netherlands | Groningen | 420 | 17 | 0 | 401 | 53.217922 | 6.741514 | 2020-08-08 04:34:53 | Groningen, Netherlands | ||
3612155 | 3612155 | 2020-08-06 | Netherlands | Groningen | 413 | 17 | 0 | 394 | 53.217922 | 6.741514 | 2020-08-07 04:35:11 | Groningen, Netherlands | ||
3792985 | 3792985 | 2020-08-05 | Netherlands | Groningen | 407 | 17 | 0 | 388 | 53.217922 | 6.741514 | 2020-08-06 04:35:02 | Groningen, Netherlands | ||
98221 | 98221 | 2020-08-04 | Netherlands | Groningen | 402 | 17 | 0 | 383 | 53.217922 | 6.741514 | 2020-08-05 04:34:43 | Groningen, Netherlands | ||
2740104 | 2740104 | 2020-08-03 | Netherlands | Groningen | 395 | 17 | 0 | 376 | 53.217922 | 6.741514 | 2020-08-04 04:41:59 | Groningen, Netherlands | ||
2807856 | 2807856 | 2020-08-02 | Netherlands | Groningen | 392 | 17 | 0 | 373 | 53.217922 | 6.741514 | 2020-08-03 04:34:35 | Groningen, Netherlands | ||
753424 | 753424 | 2020-08-01 | Netherlands | Groningen | 389 | 17 | 0 | 371 | 53.217922 | 6.741514 | 2020-08-02 04:34:47 | Groningen, Netherlands | ||
3264589 | 3264589 | 2020-07-31 | Netherlands | Groningen | 386 | 17 | 0 | 368 | 53.217922 | 6.741514 | 2020-08-01 04:36:27 | Groningen, Netherlands | ||
1928296 | 1928296 | 2020-07-30 | Netherlands | Groningen | 383 | 17 | 0 | 365 | 53.217922 | 6.741514 | 2020-07-31 04:35:18 | Groningen, Netherlands | ||
2958464 | 2958464 | 2020-07-29 | Netherlands | Groningen | 381 | 17 | 0 | 363 | 53.217922 | 6.741514 | 2020-07-30 04:35:05 | Groningen, Netherlands | ||
3185080 | 3185080 | 2020-07-28 | Netherlands | Groningen | 380 | 17 | 0 | 362 | 53.217922 | 6.741514 | 2020-07-29 04:35:11 | Groningen, Netherlands | ||
177132 | 177132 | 2020-07-27 | Netherlands | Groningen | 378 | 17 | 0 | 360 | 53.217922 | 6.741514 | 2020-07-28 04:58:43 | Groningen, Netherlands | ||
442445 | 442445 | 2020-07-26 | Netherlands | Groningen | 376 | 17 | 0 | 355 | 53.217922 | 6.741514 | 2020-07-27 04:35:02 | Groningen, Netherlands | ||
1502689 | 1502689 | 2020-07-25 | Netherlands | Groningen | 373 | 17 | 0 | 355 | 53.217922 | 6.741514 | 2020-07-26 04:35:00 | Groningen, Netherlands | ||
2563659 | 2563659 | 2020-07-24 | Netherlands | Groningen | 371 | 17 | 0 | 353 | 53.217922 | 6.741514 | 2020-07-25 04:47:39 | Groningen, Netherlands | ||
61881 | 61881 | 2020-07-23 | Netherlands | Groningen | 370 | 17 | 0 | 352 | 53.217922 | 6.741514 | 2020-07-24 05:30:40 | Groningen, Netherlands | ||
844679 | 844679 | 2020-07-22 | Netherlands | Groningen | 370 | 17 | 0 | 352 | 53.217922 | 6.741514 | 2020-07-23 05:15:04 | Groningen, Netherlands | ||
1707418 | 1707418 | 2020-07-21 | Netherlands | Groningen | 370 | 17 | 0 | 352 | 53.217921999999994 | 6.741514 | 2020-07-22 04:34:42 | Groningen, Netherlands | ||
326909 | 326909 | 2020-07-20 | Netherlands | Groningen | 369 | 17 | 0 | 351 | 53.217921999999994 | 6.741514 | 2020-07-21 04:38:46 | Groningen, Netherlands | ||
121814 | 121814 | 2020-07-19 | Netherlands | Groningen | 369 | 17 | 0 | 351 | 53.217921999999994 | 6.741514 | 2020-07-20 05:34:40 | Groningen, Netherlands | ||
3205203 | 3205203 | 2020-07-18 | Netherlands | Groningen | 368 | 17 | 0 | 350 | 53.217921999999994 | 6.741514 | 2020-07-19 04:34:58 | Groningen, Netherlands | ||
2708505 | 2708505 | 2020-07-17 | Netherlands | Groningen | 368 | 17 | 0 | 350 | 53.217921999999994 | 6.741514 | 2020-07-18 04:34:45 | Groningen, 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]);