names

31 rows where place_id = 757268

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4444577 2183281 2183281 defendant Blay John de merchant 757268 757268 Blay, John de, of Bordeaux, merchant 0
4447642 2184184 2184184 plaintiff Esperon Bernardus   757268 757268 Esperon, Bernardus, of Bordeaux 0
4490717 2197798 2197798 plaintiff Narrant John merchant 757268 757268 Narrant, John, of Bordeaux, merchant 1
4581091 2225569 2225569 plaintiff Drabroyn Arunlphus merchant 757268 757268 Drabroyn, Arunlphus, of Bordeaux, merchant 0
4590137 2228280 2228280 defendant Jayn John   757268 757268 Jayn, John, of Bordeaux 1
4617184 2236384 2236384 plaintiff Gnayen Rayond   757268 757268 Gnayen, Rayond, of Bordeaux, burgess & merchant 0
4644513 2244483 2244483 plaintiff Makanam Arnold   757268 757268 Makanam, Arnold, of Bordeaux, burgess & merchant 0
4665779 2250774 2250774 plaintiff Hosten Gausemot merchant 757268 757268 Hosten, Gausemot, of Bordeaux, merchant 0
4695556 2264094 2264094 plaintiff Bru_ssh Guillem or William merchant 757268 757268 Bru_ssh, Guillem or William, of Bordeaux, merchant 0
4706667 2267468 2267468 plaintiff Makenham Richard merchant 757268 757268 Makenham, Richard, of Bordeaux, merchant 0
4711487 2268922 2268922 plaintiff Ryngossa Guerinus merchant 757268 757268 Ryngossa, Guerinus, of Bordeaux, merchant 0
4742540 2278319 2278319 defendant Holme Robert esq 757268 757268 Holme, Robert, of Bordeaux, esq 0
4743816 2278722 2278722 plaintiff de la Crosse Arnold   757268 757268 de la Crosse, Arnold, of Bordeaux, on his own account 0
4760874 2283741 2283741 plaintiff de la Crosse Arnald   757268 757268 de la Crosse, Arnald, of Bordeaux 0
4767169 2285717 2285717 plaintiff Makenham Richard merchant & burgess 757268 757268 Makenham, Richard, of Bordeaux, merchant & burgess 0
4780145 2289790 2289790 defendant Galhard Guilhaume   757268 757268 Galhard, Guilhaume, of Bordeaux 0
4817465 2301551 2301551 plaintiff Mons Bernard de merchant 757268 757268 Mons, Bernard de, of Bordeaux, merchant, on his own account 0
4817467 2301552 2301552 plaintiff Mons Bernardus de merchant 757268 757268 Mons, Bernardus de, of Bordeaux, merchant, on his own account 0
4837760 2307743 2307743 plaintiff Funell John de merchant 757268 757268 Funell, John de, of Bordeaux, merchant 0
4841374 2308837 2308837 plaintiff Julyan Bernardus merchant 757268 757268 Julyan, Bernardus, of Bordeaux, merchant 0
4841376 2308838 2308838 plaintiff Julyan Bernardus merchant 757268 757268 Julyan, Bernardus, of Bordeaux, merchant 0
4870538 2317760 2317760 plaintiff Puyana Peter mercer 757268 757268 Puyana, Peter, of Bordeaux, mercer 1
4885215 2322263 2322263 plaintiff Femell John merchant 757268 757268 Femell, John, of Bordeaux, merchant 0
4969196 2347748 2347748 plaintiff Graunt Thomas merchant 757268 757268 Graunt, Thomas, of Bordeaux, merchant 0
5094466 2384788 2384788 plaintiff Ape Peter   757268 757268 Ape, Peter, of Bordeaux 1
5094469 2384789 2384789 plaintiff Ape Peter   757268 757268 Ape, Peter, of Bordeaux 1
5094479 2384793 2384793 plaintiff Ape Peter   757268 757268 Ape, Peter, of Bordeaux 1
5625235 2551832 2551832 defendant Gaylard John merchant 757268 757268 Gaylard, John, of Bordeaux, or of Bishops Lenn, merchant 0
5625238 2551833 2551833 defendant Gaylard John merchant 757268 757268 Gaylard, John, of Bordeaux, or of Bishops Lenn, merchant 0
5626864 2552377 2552377 defendant Lambert John merchant 757268 757268 Lambert, John, of Bordeaux, merchant 0
5628337 2552820 2552820 plaintiff Peryn Peter merchant 757268 757268 Peryn, Peter, of Bordeaux, 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);