johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
896 rows where country_or_region = "Netherlands" and province_or_state = "Groningen" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2729123 | 2729123 | 2020-09-15 | Netherlands | Groningen | 866 | 19 | 0 | 831 | 53.217922 | 6.741514 | 2020-09-16 04:22:53 | Groningen, Netherlands | ||
344395 | 344395 | 2020-09-14 | Netherlands | Groningen | 824 | 19 | 0 | 790 | 53.217922 | 6.741514 | 2020-09-15 03:22:50 | Groningen, Netherlands | ||
2868834 | 2868834 | 2020-09-13 | Netherlands | Groningen | 789 | 19 | 0 | 756 | 53.217922 | 6.741514 | 2020-09-14 04:26:00 | Groningen, Netherlands | ||
546873 | 546873 | 2020-09-12 | Netherlands | Groningen | 765 | 19 | 0 | 734 | 53.217922 | 6.741514 | 2020-09-13 04:30:52 | Groningen, Netherlands | ||
1444702 | 1444702 | 2020-09-11 | Netherlands | Groningen | 730 | 19 | 0 | 700 | 53.217922 | 6.741514 | 2020-09-12 04:25:05 | Groningen, Netherlands | ||
1173303 | 1173303 | 2020-09-10 | Netherlands | Groningen | 700 | 19 | 0 | 671 | 53.217922 | 6.741514 | 2020-09-11 04:46:23 | Groningen, Netherlands | ||
2171668 | 2171668 | 2020-09-09 | Netherlands | Groningen | 683 | 19 | 0 | 654 | 53.217922 | 6.741514 | 2020-09-10 04:29:01 | Groningen, Netherlands | ||
1243877 | 1243877 | 2020-09-08 | Netherlands | Groningen | 666 | 19 | 0 | 638 | 53.217922 | 6.741514 | 2020-09-09 04:28:48 | Groningen, Netherlands | ||
427456 | 427456 | 2020-09-07 | Netherlands | Groningen | 653 | 19 | 0 | 625 | 53.217922 | 6.741514 | 2020-09-08 04:28:25 | Groningen, Netherlands | ||
3161741 | 3161741 | 2020-09-06 | Netherlands | Groningen | 641 | 19 | 0 | 613 | 53.217922 | 6.741514 | 2020-09-07 04:28:30 | Groningen, Netherlands | ||
813696 | 813696 | 2020-09-05 | Netherlands | Groningen | 635 | 19 | 0 | 607 | 53.217922 | 6.741514 | 2020-09-06 04:28:33 | Groningen, Netherlands | ||
2661896 | 2661896 | 2020-09-04 | Netherlands | Groningen | 627 | 19 | 0 | 600 | 53.217922 | 6.741514 | 2020-09-05 04:28:19 | Groningen, Netherlands | ||
1354436 | 1354436 | 2020-09-03 | Netherlands | Groningen | 620 | 19 | 0 | 593 | 53.217922 | 6.741514 | 2020-09-04 04:28:26 | Groningen, Netherlands | ||
1105673 | 1105673 | 2020-09-02 | Netherlands | Groningen | 611 | 19 | 0 | 585 | 53.217922 | 6.741514 | 2020-09-03 04:28:22 | Groningen, Netherlands | ||
2060002 | 2060002 | 2020-09-01 | Netherlands | Groningen | 607 | 19 | 0 | 581 | 53.217922 | 6.741514 | 2020-09-02 04:28:25 | Groningen, Netherlands | ||
194187 | 194187 | 2020-08-31 | Netherlands | Groningen | 605 | 19 | 0 | 579 | 53.217922 | 6.741514 | 2020-09-01 04:28:31 | Groningen, Netherlands | ||
3932146 | 3932146 | 2020-08-30 | Netherlands | Groningen | 597 | 19 | 0 | 571 | 53.217922 | 6.741514 | 2020-08-31 04:28:27 | Groningen, Netherlands | ||
609808 | 609808 | 2020-08-29 | Netherlands | Groningen | 595 | 19 | 0 | 569 | 53.217922 | 6.741514 | 2020-08-30 04:28:22 | Groningen, Netherlands | ||
1523303 | 1523303 | 2020-08-28 | Netherlands | Groningen | 590 | 19 | 0 | 565 | 53.217922 | 6.741514 | 2020-08-29 04:28:19 | Groningen, Netherlands | ||
2510304 | 2510304 | 2020-08-27 | Netherlands | Groningen | 581 | 19 | 0 | 555 | 53.217922 | 6.741514 | 2020-08-28 04:28:11 | Groningen, Netherlands | ||
1996764 | 1996764 | 2020-08-26 | Netherlands | Groningen | 575 | 19 | 0 | 549 | 53.217922 | 6.741514 | 2020-08-27 04:28:15 | Groningen, Netherlands | ||
3562688 | 3562688 | 2020-08-25 | Netherlands | Groningen | 571 | 19 | 0 | 544 | 53.217922 | 6.741514 | 2020-08-26 04:28:11 | Groningen, Netherlands | ||
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]);