names

28 rows where place_id = 600573

✎ 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
3641607 1907835 1907835 defendant Halfaker William yeoman 600573 600573 Halfaker, William, of Welyngton, Soms, yeoman 1
4530646 2209879 2209879 defendant Ropey Thomas   600573 600573 Ropey, Thomas, of Welyngton, Soms 1
4757021 2282566 2282566 defendant Powe Richard husbandman 600573 600573 Powe, Richard, of Welyngton, Soms, husbandman 1
4757043 2282573 2282573 defendant Tournour Thomas turner 600573 600573 Tournour, Thomas, of Welyngton, Soms, turner 2
4757045 2282573 2282573 defendant Tournour John turner 600573 600573 Tournour, John, of Welyngton, Soms, turner 4
4778976 2289402 2289402 defendant Tournour Thomas turner 600573 600573 Tournour, Thomas, of Welyngton, Soms, turner 2
4817257 2301490 2301490 defendant Baker Walter baker 600573 600573 Baker, Walter, of Welyngton, Soms, baker 0
4825160 2303911 2303911 defendant Comer Raymond ostler 600573 600573 Comer, Raymond, of Welyngton, Soms, ostler 0
4848295 2310938 2310938 defendant Knyght John   600573 600573 Knyght, John, of Welyngton, Soms, wheel wright 0
4875929 2319432 2319432 defendant Knyght John wheeler 600573 600573 Knyght, John, of Welyngton, Soms, wheeler 0
5024470 2364069 2364069 defendant More John gent 600573 600573 More, John, of Welyngton, Soms, gent 2
5125160 2393835 2393835 defendant Carter John gent 600573 600573 Carter, John, of Welyngton, Soms, gent 3
5130616 2395443 2395443 defendant Whyteknyght Roger husbandman 600573 600573 Whyteknyght, Roger, of Welyngton, soms, husbandman 0
5191819 2413341 2413341 plaintiff Wykys John gent 600573 600573 Wykys, John, of Welyngton, Soms, gent 1
5202564 2416511 2416511 defendant Pery Robert yeoman 600573 600573 Pery, Robert, of Welyngton, Soms, yeoman 0
5205049 2417231 2417231 defendant Richard John drover 600573 600573 Richard, John, of Welyngton, Soms, drover 3
5215476 2420250 2420250 defendant Whiteknyght John   600573 600573 Whiteknyght, John, of Welyngton, Soms, franklin 0
5264084 2434525 2434525 defendant Elys John tailor 600573 600573 Elys, John, of Welyngton, Soms, tailor 0
5302061 2445573 2445573 defendant Baunfeld William   600573 600573 Baunfeld, William, of Welyngton, Soms, knight 0
5308197 2447482 2447482 defendant Dommet William dyer 600573 600573 Dommet, William, of Welyngton, Soms, dyer 0
5350975 2460418 2460418 defendant Seyntclere John yeoman 600573 600573 Seyntclere, John, of Welyngton, Soms, yeoman 0
5457320 2492090 2492090 defendant St Clere John yeoman 600573 600573 St Clere, John, of Welyngton, Soms, yeoman 0
5469151 2495701 2495701 defendant St Clere John yeoman 600573 600573 St Clere, John, of Welyngton, Soms, yeoman 0
5480300 2499090 2499090 defendant Seyntclere John yeoman 600573 600573 Seyntclere, John, of Welyngton, Soms, yeoman 0
5484032 2500159 2500159 defendant Domet William dyer 600573 600573 Domet, William, of Welyngton, Soms, dyer 2
5501489 2505401 2505401 defendant Carter John husbandman 600573 600573 Carter, John, of Welyngton, Soms, husbandman 0
5511267 2508365 2508365 defendant Piers William   600573 600573 Piers, William, of Welyngton, Soms, lime burner 3
5565371 2524462 2524462 defendant Edward Richard innholder 600573 600573 Edward, Richard, of Welyngton, Soms, innholder 1

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);