cluster

cluster_num_id
{'link': '/cluster/{value}'}

9,077 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: eventDate_min (date), eventDate_max (date)

cluster_num_id ▼ recordedBy_first_family eventDate_min eventDate_max recordNumber_mainNumber_min recordNumber_mainNumber_max cluster_num_id_count recordedBy_identity_nonnull_count eventDate_unique_count recordNumber_mainNumber_unique_count countryCode_unique_count family_unique_count eventDate_diff_days recordNumber_mainNumber_diff completeness georef_completeness
0 Clemens 1933-05-24 1933-07-03T00:00 32310.0 32620.0 394 173 34 193 1 65 40 310.0 0.6205787781350482 0.10406091370558376
1 Clemens 1933-07-20 1933-08-09 34272.0 34314.0 29 14 10 15 1 12 20 42.0 0.3488372093023256 0.06896551724137931
2 Clemens 1931-08 1932-07-07T00:00 26594.0 30014.0 5799 2932 461 2464 1 166 341 3420.0 0.7202572347266881 0.19934471460596653
3 Clemens 1929 1929-01-01T00:00 20385.0 22038.0 1926 622 3 988 1 135 0 1653.0 0.5973397823458283 0.11318795430944964
4 Clemens 1929 1929-01-01T00:00 20045.0 20136.0 52 15 3 30 1 24 0 91.0 0.32608695652173914 0.019230769230769232
5 Clemens 1932-12-13 1933-05-05 30464.0 33005.0 2856 1244 161 1462 1 141 143 2541.0 0.5751376868607396 0.13550420168067226
6 Clemens 1933-04-17 1933-05-29T00:00 33026.0 33232.0 291 163 37 130 1 52 42 206.0 0.6280193236714976 0.1958762886597938
7 Clemens 1933-10-01 1933-12-28T00:00 50000.0 51161.0 1500 487 111 676 1 116 88 1161.0 0.5817555938037866 0.07866666666666666
8 Clemens 1933-10-28 1934-01-02T00:00 51382.0 51743.0 248 110 43 125 1 49 66 361.0 0.3453038674033149 0.14516129032258066
9 Clemens 1931-08 1931-10-01T00:00 26000.0 26544.0 782 238 98 410 1 91 61 544.0 0.7522935779816514 0.1265984654731458
10 Clemens 1933-06 1933-07-19 33618.0 33917.0 322 172 34 164 1 64 48 299.0 0.5466666666666666 0.13354037267080746
11 Clemens 1932-05-08 1932-05-24 28199.0 28200.0 8 4 4 2 1 2 16 1.0 1.0 0.0
12 Clemens 1933-08-10 1933-09-07T00:00 40001.0 40235.0 173 73 23 96 1 43 28 234.0 0.4085106382978723 0.12716763005780346
13 Clemens 1933 1933-01-01T00:00 33205.0 33206.0 10 2 3 2 1 1 0 1.0 1.0 0.4
14 Clemens 1933-07-26 1933-08-19 34333.0 34499.0 208 101 27 96 1 43 24 166.0 0.5748502994011976 0.11057692307692307
15 Clemens 1933-06-15 1933-08-04T00:00 33938.0 34237.0 290 128 35 163 1 69 50 299.0 0.5433333333333333 0.10689655172413794
16 Clemens 1915-10-17 1915-12-09 18.0 408.0 643 578 44 313 1 2 53 390.0 0.8005115089514067 0.08398133748055987
17 Clemens 1933-09 1933-11-03 40255.0 40999.0 1020 315 88 474 1 110 63 744.0 0.636241610738255 0.07450980392156863
18 Clemens 1933-12 1934-01-02 51181.0 51371.0 131 43 29 70 1 42 32 190.0 0.36649214659685864 0.07633587786259542
19 Clemens 1933-02 1933-03-18 35003.0 35047.0 15 12 8 8 1 7 45 44.0 0.17777777777777778 0.26666666666666666
20 Clemens 1933-06-13 1933-07-12 35042.0 35078.0 12 6 7 7 1 4 29 36.0 0.1891891891891892 0.0
21 Clemens 1932-03-02 1932-06-03T00:00 30015.0 30090.0 55 20 35 32 1 19 93 75.0 0.42105263157894735 0.03636363636363636
22 Clemens 1915-11 1915-11-29 10322.0 10533.0 144 74 9 98 1 47 28 211.0 0.46226415094339623 0.14583333333333334
23 Clemens 1915-10-18 1915-11-15T00:00 10559.0 10738.0 150 77 8 94 1 43 28 179.0 0.5222222222222223 0.10666666666666667
24 Clemens 1933-06-15 1933-07-01T00:00 34133.0 34140.0 12 11 4 3 1 3 16 7.0 0.375 0.25
25 Clemens 1915-10-18 1915-10-18T00:00 9438.0 9498.0 75 35 2 40 1 27 0 60.0 0.6557377049180327 0.16
26 Clemens 1931-12-05 1932-01-09 30456.0 30463.0 24 16 9 7 1 5 35 7.0 0.875 0.375
27 Clemens 1929-10 1929-10-12 22040.0 22078.0 81 50 8 37 1 14 11 38.0 0.9487179487179487 0.32098765432098764
28 Clemens 1929-09-29 1929-10-23 20586.0 20784.0 83 19 16 68 1 34 24 198.0 0.3417085427135678 0.10843373493975904
29 Clemens 1929-08-29 1929-10-12 20004.0 20488.0 450 98 51 255 1 79 44 484.0 0.5257731958762887 0.07555555555555556
30 Clemens 1915-10-18 1915-11-08 9905.0 10252.0 175 67 7 130 1 56 21 347.0 0.3735632183908046 0.05142857142857143
31 Clemens 1932-02-11 1932-02-24T00:00 27769.0 27789.0 13 10 4 3 1 3 13 20.0 0.14285714285714285 0.3076923076923077
32 Clemens 1929-06-29 1929-08-14 21986.0 22037.0 38 13 16 34 1 15 46 51.0 0.6538461538461539 0.05263157894736842
33 Clemens 1915-12-20 1915-12-21T00:00 9500.0 9561.0 32 9 4 24 1 20 1 61.0 0.3870967741935484 0.03125
34 Clemens 1933-09-02 1934-01-01 30.0 51.0 129 87 60 4 1 8 121 21.0 0.18181818181818182 0.007751937984496124
35 Clemens 1933-09-25 1933-09-26 51331.0 51339.0 5 0 2 4 1 4 1 8.0 0.4444444444444444 0.0
36 Clemens 1915-11 1915-11-01T00:00 10770.0 10861.0 78 31 2 53 1 26 0 91.0 0.5760869565217391 0.05128205128205128
37 Clemens 1931-01-31 1931-01-31T00:00 28154.0 28158.0 5 4 2 3 1 3 0 4.0 0.6 0.4
38 Clemens 1933 1933-01-01T00:00 33675.0 33750.0 25 14 3 11 1 5 0 75.0 0.14473684210526316 0.2
39 Clemens 1915-10-27 1915-10-29T00:00 9754.0 9883.0 70 18 6 57 1 31 2 129.0 0.43846153846153846 0.0
40 Clemens 1933-09-13 1933-09-17T00:00 40103.0 40107.0 15 9 4 5 1 6 4 4.0 1.0 0.3333333333333333
41 Clemens 1933 1933-01-01T00:00 31798.0 31804.0 6 5 2 3 1 3 0 6.0 0.42857142857142855 0.16666666666666666
42 Clemens 1933-01 1933-02-15T00:00 51699.0 51710.0 21 15 11 8 1 4 45 11.0 0.6666666666666666 0.3333333333333333
43 Clemens 1915-12 1915-12-14T00:00 9600.0 9739.0 35 8 3 31 1 18 13 139.0 0.22142857142857142 0.11428571428571428
44 Clemens 1933-10-03 1933-10-07T00:00 51520.0 51520.0 5 0 3 1 1 1 4 0.0 1.0 0.0
45 Clemens 1929 1929-01-01T00:00 22081.0 22184.0 143 55 3 67 1 32 0 103.0 0.6442307692307693 0.20279720279720279
46 Clemens 1933-12-26 1933-12-26T00:00 34448.0 34448.0 13 13 2 1 1 1 0 0.0 1.0 0.15384615384615385
47 Clemens 1915-12 1915-12-03 11009.0 11089.0 20 15 4 18 1 14 2 80.0 0.2222222222222222 0.6
48 Clemens 1915-11-22 1915-12-02 10885.0 10984.0 20 11 5 19 1 17 10 99.0 0.19 0.35
49 Clemens 1933-10-23 1933-10-23T00:00 40286.0 40294.0 5 3 2 2 1 2 0 8.0 0.2222222222222222 0.2
50 Clemens 1931-11-23 1931-12-01T00:00 27727.0 27730.0 7 7 3 2 1 1 8 3.0 0.5 0.42857142857142855
51 Clemens 1929-10-12T00:00 1929-10-30T00:00 20892.0 21028.0 64 6 11 59 1 33 18 136.0 0.4306569343065693 0.015625
52 Clemens 1929-10-25 1929-11-06 22295.0 22422.0 58 10 10 49 1 26 12 127.0 0.3828125 0.08620689655172414
53 Clemens 1929-09 1929-10-04T00:00 6996.0 7233.0 55 4 21 53 1 23 33 237.0 0.22268907563025211 0.03636363636363636
54 Clemens 1929 1929-01-01T00:00 22298.0 22408.0 82 35 3 52 1 32 0 110.0 0.46846846846846846 0.07317073170731707
55 Clemens 1931-12-28 1932-01-03 28300.0 28315.0 16 8 6 5 1 4 6 15.0 0.3125 0.1875
56 Clemens 1932-05-24 1932-05-30T00:00 27470.0 27479.0 7 5 3 2 1 2 6 9.0 0.2 0.14285714285714285
57 Clemens 1933 1933-01-01T00:00 32513.0 32593.0 20 13 3 9 1 5 0 80.0 0.1111111111111111 0.25
58 Clemens 1931-10 1932-06-27 30096.0 30401.0 532 117 199 217 1 53 270 305.0 0.7091503267973857 0.03195488721804511
59 Clemens 1929-09-01T00:00 1929-09-16T00:00 6733.0 6857.0 27 6 9 24 1 15 15 124.0 0.192 0.14814814814814814
60 Clemens 1929-10-01T00:00 1929-10-28T00:00 7365.0 7665.0 73 24 19 70 1 37 27 300.0 0.23255813953488372 0.2328767123287671
61 Clemens 1933 1933-01-01T00:00 34093.0 34105.0 7 4 3 3 1 3 0 12.0 0.23076923076923078 0.14285714285714285
62 Clemens 1915-12 1915-12-16T00:00 11137.0 11277.0 51 13 10 43 1 32 15 140.0 0.3049645390070922 0.0784313725490196
63 Clemens 1929-10 1929-10-11T00:00 22186.0 22293.0 160 20 9 73 1 40 10 107.0 0.6759259259259259 0.025
64 Clemens 1931-11-20 1932-01-03T00:00 30223.0 30319.0 44 7 27 22 1 9 44 96.0 0.2268041237113402 0.0
65 Clemens 1929-10-26T00:00 1929-10-30T00:00 7759.0 7890.0 29 5 6 28 1 20 4 131.0 0.21212121212121213 0.06896551724137931
66 Clemens 1915-10-23 1915-10-23T00:00 9563.0 9591.0 11 1 2 11 1 9 0 28.0 0.3793103448275862 0.0
67 Clemens 1915-12-01 1915-12-01T00:00 10267.0 10285.0 8 4 2 6 1 5 0 18.0 0.3157894736842105 0.125
68 Clemens 1932-04-17 1932-05-07 28651.0 28707.0 16 8 7 6 1 6 20 56.0 0.10526315789473684 0.1875
69 Clemens 1929 1929-01-01T00:00 20157.0 20230.0 51 9 3 33 1 24 0 73.0 0.44594594594594594 0.0196078431372549
70 Clemens 1932-04-01T00:00 1932-04-09 29475.0 29489.0 5 2 2 3 1 3 8 14.0 0.2 0.0
71 Clemens 1931-12-25 1932-01-01T00:00 30172.0 30177.0 10 7 5 4 1 3 7 5.0 0.6666666666666666 0.1
72 Clemens 1931 1931-01-01T00:00 30344.0 30361.0 6 2 3 4 1 4 0 17.0 0.2222222222222222 0.16666666666666666
73 Clemens 1929-09-30 1929-10-03T00:00 7256.0 7339.0 23 5 6 22 1 17 3 83.0 0.2619047619047619 0.13043478260869565
74 Clemens 1929 1929-01-01T00:00 22582.0 22591.0 6 4 2 6 1 5 0 9.0 0.6 0.16666666666666666
75 Clemens 1933 1933-01-01T00:00 32383.0 32416.0 14 6 3 7 1 3 0 33.0 0.20588235294117646 0.35714285714285715
76 Clemens 1929-09-01T00:00 1929-09-18T00:00 6917.0 6941.0 8 2 4 7 1 6 17 24.0 0.28 0.0
77 Clemens 1929-07-22 1929-07-24T00:00 6098.0 6136.0 9 5 3 8 1 6 2 38.0 0.20512820512820512 0.0
78 Clemens 1931 1931-01-01T00:00 28986.0 29022.0 6 4 2 5 1 4 0 36.0 0.13513513513513514 0.0
79 Clemens 1933 1933-01-01T00:00 34457.0 34477.0 6 3 2 3 1 3 0 20.0 0.14285714285714285 0.3333333333333333
80 Clemens 1931-12-29 1932-01-14 30046.0 30123.0 21 10 8 12 1 6 16 77.0 0.15384615384615385 0.0
81 Clemens 1929-10-22T00:00 1929-10-26T00:00 7697.0 7735.0 11 4 5 9 1 7 4 38.0 0.23076923076923078 0.18181818181818182
82 Clemens 1929-06-28 1929-07-27T00:00 22081.0 22143.0 26 14 17 22 1 10 29 62.0 0.3492063492063492 0.038461538461538464
83 Clemens 1931-01-01T00:00 1931-01-01T00:00 30461.0 30461.0 5 0 1 1 1 1 0 0.0 1.0 0.0
84 Clemens 1932-06-09 1932-06-09T00:00 29462.0 29462.0 5 5 2 1 1 1 0 0.0 1.0 0.2
85 Clemens 1933-06-30 1933-07-11T00:00 51368.0 51368.0 7 7 4 1 1 1 11 0.0 1.0 0.5714285714285714
86 Clemens 1933-06-15 1933-06-16 33920.0 33925.0 7 2 3 5 1 5 1 5.0 0.8333333333333334 0.14285714285714285
87 Clemens 1932-01 1932-01-03 27290.0 27300.0 6 3 3 2 1 1 2 10.0 0.18181818181818182 0.16666666666666666
88 Clemens 1933-09-20 1933-09-29T00:00 51741.0 51757.0 5 3 4 2 1 2 9 16.0 0.11764705882352941 0.2
89 Clemens 1929-06-27T00:00 1929-07-27T00:00 21618.0 21719.0 29 5 18 24 1 10 30 101.0 0.23529411764705882 0.0
90 Clemens 1932-04-26 1932-05-02 28562.0 28585.0 7 3 5 4 1 4 6 23.0 0.16666666666666666 0.14285714285714285
91 Clemens 1932-03-29T00:00 1932-04-02T00:00 27839.0 27852.0 5 3 3 2 1 2 4 13.0 0.14285714285714285 0.4
92 Clemens 1929-10-04 1929-10-24T00:00 20803.0 20831.0 8 1 7 6 1 4 20 28.0 0.20689655172413793 0.0
93 Clemens 1929-09-01T00:00 1929-09-19T00:00 6959.0 6977.0 8 2 2 7 1 7 18 18.0 0.3684210526315789 0.0
94 Clemens 1932-09-26T00:00 1932-10-01 26609.0 26663.0 8 3 7 5 1 5 5 54.0 0.09090909090909091 0.375
95 Clemens 1932-01 1932-01-08T00:00 28259.0 28279.0 19 1 6 8 1 5 7 20.0 0.38095238095238093 0.05263157894736842
96 Clemens 1932 1932-01-01T00:00 28966.0 28991.0 6 5 3 3 1 2 0 25.0 0.11538461538461539 0.16666666666666666
97 Clemens 1932-11-10 1932-11-14T00:00 27013.0 27050.0 8 2 4 4 1 4 4 37.0 0.10526315789473684 0.25
98 Clemens 1932-06-02 1932-06-08T00:00 27910.0 27943.0 7 3 4 4 1 4 6 33.0 0.11764705882352941 0.14285714285714285
99 Clemens 1933 1933-01-01T00:00 34339.0 34372.0 7 2 3 4 1 4 0 33.0 0.11764705882352941 0.14285714285714285

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "cluster" (
   [cluster_num_id] INTEGER PRIMARY KEY,
   [recordedBy_first_family] TEXT,
   [eventDate_min] TEXT,
   [eventDate_max] TEXT,
   [recordNumber_mainNumber_min] FLOAT,
   [recordNumber_mainNumber_max] FLOAT,
   [cluster_num_id_count] INTEGER,
   [recordedBy_identity_nonnull_count] INTEGER,
   [eventDate_unique_count] INTEGER,
   [recordNumber_mainNumber_unique_count] INTEGER,
   [countryCode_unique_count] INTEGER,
   [family_unique_count] INTEGER,
   [eventDate_diff_days] INTEGER,
   [recordNumber_mainNumber_diff] FLOAT,
   [completeness] FLOAT,
   [georef_completeness] FLOAT
);