names

47 rows where place_id = 625399

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3763943 1946365 1946365 defendant Notte John husbandman 625399 625399 Notte, John, of Worthyng, husbandman 0
3822785 1965031 1965031 defendant Tays Mathew miller 625399 625399 Tays, Mathew, of Worthyng, miller 1
3822786 1965031 1965031 defendant Walden John husbandman 625399 625399 Walden, John, of Worthyng, husbandman 2
3885455 1985391 1985391 defendant Wylmer William   625399 625399 Wylmer, William, of Worthyng, shepherd 0
3990070 2021202 2021202 defendant Preston William husbandman 625399 625399 Preston, William, of Worthyng, husbandman 1
3990073 2021203 2021203 defendant Hamlyn Randolph husbandman 625399 625399 Hamlyn, Randolph, of Worthyng, husbandman 0
3990074 2021203 2021203 defendant Preston William husbandman 625399 625399 Preston, William, of Worthyng, husbandman 1
3990075 2021203 2021203 defendant Beles Thomas husbandman 625399 625399 Beles, Thomas, of Worthyng, husbandman 2
3995036 2022971 2022971 defendant Beales Thomas husbandman 625399 625399 Beales, Thomas, of Worthyng, husbandman 2
4235030 2107804 2107804 defendant Kentt Noel or Neel fisherman 625399 625399 Kentt, Noel or Neel, of Worthyng, fisherman 0
4512865 2204453 2204453 defendant Poynaunt John   625399 625399 Poynaunt, John, of Worthyng 0
4610134 2234254 2234254 defendant Palyngham Ralph   625399 625399 Palyngham, Ralph, of worthyng 0
4614978 2235695 2235695 defendant Taillour John   625399 625399 Taillour, John, of Worthyng 1
4774303 2287942 2287942 defendant Mombray Richard husbandman 625399 625399 Mombray, Richard, of Worthyng, husbandman 0
4779452 2289550 2289550 defendant Gilberd Thomas husbandman 625399 625399 Gilberd, Thomas, of Worthyng, husbandman 4
4781481 2290219 2290219 defendant Sale William husbandman 625399 625399 Sale, William, of Worthyng, husbandman 0
4794798 2294515 2294515 defendant Moughter Thomas husbandman 625399 625399 Moughter, Thomas, of Worthyng, husbandman 0
4891726 2324155 2324155 defendant Stunte Henry husbandman 625399 625399 Stunte, Henry, of Worthyng, husbandman 0
4984384 2352260 2352260 defendant Paynot Thomas husbandman 625399 625399 Paynot, Thomas, of Worthyng, husbandman 1
5036393 2367500 2367500 defendant Child Thomas, junior   625399 625399 Child, Thomas, junior, of Worthyng 0
5036394 2367500 2367500 defendant Piers John, junior husbandman 625399 625399 Piers, John, junior, of Worthyng, husbandman 1
5077689 2379822 2379822 defendant Gosse John husandman 625399 625399 Gosse, John, of Worthyng, husandman 0
5091065 2383782 2383782 defendant Wattys Richard husbandman 625399 625399 Wattys, Richard, of Worthyng, husbandman 0
5101401 2386823 2386823 defendant Wattys Richard husbandman 625399 625399 Wattys, Richard, of Worthyng, husbandman 0
5234951 2425802 2425802 defendant Costyn John, senior husbandman 625399 625399 Costyn, John, senior, of Worthyng, husbandman 1
5288565 2441675 2441675 defendant Costantyn Thomas, senior husbandman 625399 625399 Costantyn, Thomas, senior, of Worthyng, husbandman 0
5288567 2441675 2441675 defendant Costantyn Thomas, junior husbandman 625399 625399 Costantyn, Thomas, junior, of Worthyng, husbandman 2
5301888 2445519 2445519 plaintiff Drake Richard (legal representative) 625399 625399 Drake, Richard, of Worthyng, executor of 0
5301894 2445520 2445520 plaintiff Drake Richard (legal representative) 625399 625399 Drake, Richard, of Worthyng, husbandman, executor of 0
5308823 2447679 2447679 defendant Drake Thomas husbandman 625399 625399 together with Drake, Thomas, of Worthyng, husbandman 1
5313845 2449165 2449165 defendant Drake Thomas husbandman 625399 625399 Drake, Thomas, of Worthyng, husbandman 12
5376811 2468341 2468341 defendant Cuttys John husbandman 625399 625399 Cuttys, John, of Worthyng, husbandman 0
5392911 2473043 2473043 defendant Cuttys John fuller 625399 625399 Cuttys, John, of Worthyng, fuller 2
5406040 2476800 2476800 defendant Curtys Ohn fuller 625399 625399 Curtys, Ohn, of Worthyng, fuller 3
5408291 2477447 2477447 defendant Costyntyn Bartholomew miller 625399 625399 Costyntyn, Bartholomew, of Worthyng, miller 1
5419063 2480628 2480628 defendant Cuttys John fuller 625399 625399 Cuttys, John, of Worthyng, fuller 3
5419900 2480867 2480867 defendant Constyntyn Bartholomew miller 625399 625399 Constyntyn, Bartholomew, of Worthyng, miller 1
5438453 2486435 2486435 defendant Constantyn Bartholomew miller 625399 625399 Constantyn, Bartholomew, of Worthyng, miller 1
5472069 2496606 2496606 defendant Drake Alan husbandman 625399 625399 Drake, Alan, of Worthyng, husbandman 1
5483501 2500012 2500012 defendant Drake Alan husbandman 625399 625399 Drake, Alan, of Worthyng, husbandman 1
5549455 2519894 2519894 defendant Rayman Thomas gent 625399 625399 Rayman, Thomas, of Worthyng, gent 0
5567557 2525085 2525085 plaintiff Drake Henry clerk 625399 625399 Drake, Henry, of Worthyng, clerk 0
5568373 2525296 2525296 defendant Trenet or Trevet James carpenter 625399 625399 Trenet or Trevet, James, of Worthyng, carpenter 1
5573977 2526953 2526953 defendant Gegge Henry (legal representative) 625399 625399 Gegge, Henry, of Worthyng, executors of 0
5609503 2537868 2537868 defendant Cuttys John husbandman 625399 625399 Cuttys, John, of Worthyng, husbandman 0
5612310 2547598 2547598 defendant Pypere John   625399 625399 Pypere, John, of Worthyng 0
5623944 2551436 2551436 defendant Roo John laborer 625399 625399 Roo, John, of Worthyng, laborer 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);