names

34 rows where place_id = 763919

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588804 1864145 1864145 plaintiff Botker John   763919 763919 Botker, John, of Germany, Hanssa merchant 0
3595669 1866272 1866272 plaintiff Moliner or Molmer John   763919 763919 Moliner or Molmer, John, of Germany, Hanssa merchant 0
3595671 1866273 1866273 plaintiff Molner John   763919 763919 Molner, John, of Germany, Hanssa merchant 0
3654838 1911772 1911772 plaintiff Baughraugh Herman   763919 763919 Baughraugh, Herman, of Germany, Hanseatic merchant 0
3656012 1912134 1912134 plaintiff Buryng Luckenus   763919 763919 Buryng, Luckenus, of Germany, Hansa merchant 0
3664942 1914980 1914980 plaintiff Sheskyn Peter   763919 763919 Sheskyn, Peter, of Germany, Hansa merchant 0
3789955 1954684 1954684 plaintiff Vantalechyten george (legal representative) 763919 763919 Vantalechyten, george, of Germany, Hanssa merchant, administrator of 0
3805227 1959581 1959581 plaintiff Sutenbaker Dederic (legal representative) 763919 763919 Sutenbaker, Dederic, of Germany, Hanssa merchant, administrator of 0
4501620 2201109 2201109 defendant Lyster Nicholas merchant 763919 763919 Lyster, Nicholas, of Germany, merchant 2
4501630 2201111 2201111 defendant Lyster Nicholas merchant 763919 763919 Lyster, Nicholas, of Germany, merchant 2
4599434 2231038 2231038 plaintiff Suderman Hildebrand merchant 763919 763919 Suderman, Hildebrand, of Germany, merchant 0
4713649 2269591 2269591 plaintiff Swart Ertmarus   763919 763919 Swart, Ertmarus, of Germany, Hansa merchant 0
4961270 2345339 2345339 plaintiff Blateryswyk Robert   763919 763919 Blateryswyk, Robert, of Germany 1
4974419 2349311 2349311 defendant Yengell Stephen esq 763919 763919 Yengell, Stephen, of Germany, gent, or of Southwerk, esq 2
4974424 2349312 2349312 defendant Yengell Stephen esq 763919 763919 Yengell, Stephen, of Germany, gent, of Suthwerk, esq 2
5010021 2359798 2359798 plaintiff van Blekyn Christian merchant 763919 763919 van Blekyn, Christian, of Germany, merchant 0
5010024 2359799 2359799 plaintiff van Blekyn Christian merchant 763919 763919 van Blekyn, Christian, of Germany, merchant 0
5118895 2391957 2391957 plaintiff Hewyser Godfrey   763919 763919 Hewyser, Godfrey, of Germany 2
5118896 2391957 2391957 plaintiff Gosdepp John   763919 763919 Gosdepp, John, of Germany 3
5138773 2397839 2397839 plaintiff Ryng Roger merchant 763919 763919 Ryng, Roger, of Germany, merchant 0
5162922 2404880 2404880 plaintiff Warendorp John merchant 763919 763919 Warendorp, John, of Germany, merchant 0
5162923 2404880 2404880 plaintiff Byspyng John merchant 763919 763919 Byspyng, John, of Germany, merchant 1
5174635 2408282 2408282 plaintiff Houyser Godfrey merchant 763919 763919 Houyser, Godfrey, of Germany, merchant 1
5174637 2408283 2408283 plaintiff Ryng Herman merchant 763919 763919 Ryng, Herman, of Germany, merchant 0
5174638 2408283 2408283 plaintiff Howyser Godfrey merchant 763919 763919 Howyser, Godfrey, of Germany, merchant 1
5174644 2408284 2408284 plaintiff Ryng Herman merchant 763919 763919 Ryng, Herman, of Germany, merchant 0
5174645 2408284 2408284 plaintiff Howyser Godfrey merchant 763919 763919 Howyser, Godfrey, of Germany, merchant 1
5200730 2415970 2415970 plaintiff Wynter John merchant 763919 763919 Wynter, John, of Germany, merchant 0
5200731 2415970 2415970 plaintiff Toussheinen William merchant 763919 763919 Toussheinen, William, of Germany, merchant 1
5370523 2466365 2466365 plaintiff Grenerode John   763919 763919 Grenerode, John, of Germany, Hansa merchant 0
5372525 2467006 2467006 plaintiff Latehonsen Henry merchant 763919 763919 Latehonsen, Henry, of Germany, merchant 0
5377622 2468583 2468583 plaintiff Stute John   763919 763919 Stute, John, of Germany, Hansa merchant 0
5396278 2474025 2474025 plaintiff Bletterswyk Mathew   763919 763919 Bletterswyk, Mathew, of Germany, Hansa merchant 0
5476492 2497974 2497974 plaintiff van Elsygh Conrad   763919 763919 van Elsygh, Conrad, of Germany, Hansa merchant 0

Advanced export

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

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);