names

30 rows where place_id = 594546

✎ 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
3616542 1872809 1872809 defendant Turton Robert yeoman 594546 594546 Turton, Robert, of Tykhyll, yeoman 3
3712277 1930153 1930153 defendant Erle Amory husbandman 594546 594546 Erle, Amory, of Tykhyll, husbandman 1
3727833 1934976 1934976 defendant Martyn Nicholas chaplain 594546 594546 Martyn, Nicholas, of Tykhyll, chaplain 0
3727834 1934976 1934976 defendant Renell or Revell Geoffrey turner 594546 594546 Renell or Revell, Geoffrey, of Tykhyll, turner 1
3743744 1939927 1939927 defendant Martyn Nicholas chaplain 594546 594546 Martyn, Nicholas, of Tykhyll, chaplain 0
3743745 1939927 1939927 defendant Revell or Renell Geoffrey turner 594546 594546 Revell or Renell, Geoffrey, of Tykhyll, turner 1
3841552 1970940 1970940 defendant Kendall Christopher yeoman 594546 594546 Kendall, Christopher, of Tykhyll, yeoman 0
3841553 1970940 1970940 defendant Kendall Nicholas chaplain 594546 594546 Kendall, Nicholas, of Tykhyll, chaplain 1
3864029 1978151 1978151 defendant Turvyn Thomas husbandman 594546 594546 Turvyn, Thomas, of Tykhyll, husbandman 0
3864031 1978152 1978152 defendant Tyas William yeoman 594546 594546 Tyas, William, of Tykhyll, yeoman 0
3868308 1979642 1979642 defendant Bedford Thomas laborer 594546 594546 Bedford, Thomas, of Tykhyll, laborer 0
4005224 2026649 2026649 plaintiff Kepys John (legal representative) 594546 594546 Kepys, John, of Tykhyll, executrix of 0
4005226 2026649 2026649 defendant Byrley William yeoman 594546 594546 Byrley, William, of Tykhyll, yeoman 0
4493759 2198742 2198742 defendant Wode Willidma   594546 594546 Wode, Willidma, of Tykhyll 2
4493760 2198742 2198742 defendant Dadewall William   594546 594546 Dadewall, William, of Tykhyll 3
4645574 2244775 2244775 defendant Hervy John dyer 594546 594546 Hervy, John, of Tykhyll, dyer 0
4773160 2287574 2287574 defendant Rouclyf William de yeoman 594546 594546 Rouclyf, William de, of Tykhyll, yeoman 2
4831076 2305750 2305750 defendant Waddesworth not given tanner 594546 594546 Waddesworth, [ forename missing ], of Tykhyll, tanner 1
4867999 2316960 2316960 plaintiff Huberd John merchant 594546 594546 Huberd, John, of Tykhyll, merchant 0
4946879 2341031 2341031 defendant Leyston Thomas chapman 594546 594546 Leyston, Thomas, of Tykhyll, chapman 0
5070038 2377532 2377532 defendant Nayler John laborer 594546 594546 Nayler, John, of Tykhyll, laborer 2
5096119 2385307 2385307 defendant Cressy Hugh esq 594546 594546 Cressy, Hugh, of Tykhyll, esq 1
5129098 2394995 2394995 defendant (illegible) John yeoman 594546 594546 ---, John, of Tykhyll, yeoman 1
5228795 2424033 2424033 plaintiff Whyte Robert (legal representative) 594546 594546 Whyte, Robert, of Tykhyll, mercer, executors of 0
5228804 2424034 2424034 plaintiff Whyte Robert (legal representative) 594546 594546 Whyte, Robert, of Tykhyll, mercer, executors of 0
5287832 2441463 2441463 defendant Dylacre John butcher 594546 594546 Dylacre, John, of Tykhyll, butcher 0
5345806 2458827 2458827 defendant Edlyngton William husbandman 594546 594546 Edlyngton, William, of Tykhyll, husbandman 0
5363303 2464180 2464180 plaintiff West Robert   594546 594546 West, Robert, of Tykhyll 0
5369575 2466072 2466072 plaintiff fitz William Edmund esq 594546 594546 fitz William, Edmund, of Tykhyll, esq 0
5531541 2514397 2514397 defendant Twyer Thomas yeoman 594546 594546 Twyer, Thomas, of Tykhyll, yeoman 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);