names

45 rows where place_id = 753801

✎ 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
4415874 2169852 2169852 defendant None Edmund   753801 753801 None, Edmund, of Tylneye 12
4437942 2181187 2181187 defendant Blowere Henry   753801 753801 Blowere, Henry, of Tylneye 0
4437943 2181187 2181187 defendant Bailly Peter   753801 753801 Bailly, Peter, of Tylneye 1
4437944 2181187 2181187 defendant Taillour Philip   753801 753801 Taillour, Philip, of Tylneye 2
4439685 2181682 2181682 defendant Plomer Stephen   753801 753801 Plomer, Stephen, of Tylneye 0
4441113 2182147 2182147 plaintiff Blower Nicholas (legal representative) 753801 753801 Blower, Nicholas, of Tylneye, executors of 0
4441114 2182147 2182147 plaintiff Blower Henry   753801 753801 (Blower, Henry, of Tylneye 1
4451639 2185483 2185483 defendant Everard James   753801 753801 Everard, James, of Tylneye 0
4554703 2217396 2217396 defendant Ferrour John   753801 753801 Ferrour, John, of Tylneye 2
4576151 2224044 2224044 defendant Pypere John   753801 753801 Pypere, John, of Tylneye 0
4576152 2224044 2224044 defendant Dykkysson John   753801 753801 Dykkysson, John, of Tylneye 1
4581843 2225766 2225766 defendant Palmere Peter   753801 753801 Palmere, Peter, of Tylneye 0
4607367 2233412 2233412 defendant Broun Robert   753801 753801 Broun, Robert, of Tylneye 4
4640513 2243338 2243338 defendant Broun Robert   753801 753801 Broun, Robert, of Tylneye 0
4657854 2248343 2248343 defendant de Tyryngton Andrewe husbandman 753801 753801 de Tyryngton, Andrewe, of Tylneye, husbandman 0
4674727 2257707 2257707 defendant Blowere Richard gent & son of John Blowere 753801 753801 Blowere, Richard, of Tylneye, gent & son of John Blowere 0
4704461 2266769 2266769 defendant Wolnoth William husbandman 753801 753801 Wolnoth, William, of Tylneye, husbandman 0
4704466 2266771 2266771 defendant Noryse John husbandman 753801 753801 Noryse, John, of Tylneye, husbandman 0
4704468 2266772 2266772 defendant Lany or Lavy John husbandman 753801 753801 Lany or Lavy, John, of Tylneye, husbandman 0
4761242 2283864 2283864 defendant Broun Robert husbandman 753801 753801 Broun, Robert, of Tylneye, husbandman 0
4807005 2298387 2298387 defendant Wacy Geoffrey yeoman 753801 753801 Wacy, Geoffrey, of Tylneye, yeoman 0
4819861 2302286 2302286 defendant Daddy William husbandman 753801 753801 Daddy, William, of Tylneye, husbandman 0
4823778 2303523 2303523 defendant Wattysson John yeoman 753801 753801 Wattysson, John, of Tylneye, yeoman 3
4845516 2310109 2310109 defendant Dekon John yeoman 753801 753801 Dekon, John, of Tylneye, yeoman 4
4857488 2313731 2313731 defendant Dykson Henry yeoman 753801 753801 Dykson, Henry, of Tylneye, yeoman 0
4875622 2319333 2319333 defendant Hyde Simon yeoman 753801 753801 Hyde, Simon, of Tylneye, yeoman 1
4933780 2336944 2336944 defendant Westburgh John husbandman 753801 753801 Westburgh, John, of Tylneye, husbandman 0
4959503 2344809 2344809 defendant Bernewell John husbandman 753801 753801 Bernewell, John, of Tylneye, husbandman 2
4959504 2344809 2344809 defendant Skerell John husbandman 753801 753801 Skerell, John, of Tylneye, husbandman 3
4972353 2348667 2348667 defendant Leveryche Thomas husbandman 753801 753801 Leveryche, Thomas, of Tylneye, husbandman 1
4984030 2352155 2352155 defendant Leverich Thomas husbandman 753801 753801 Leverich, Thomas, of Tylneye, husbandman 3
4984034 2352157 2352157 defendant Dyxes Robert husbandman 753801 753801 Dyxes, Robert, of Tylneye, husbandman 0
4987971 2353372 2353372 defendant Colt Robert yeoman 753801 753801 Colt, Robert, of Tylneye, yeoman 0
4987973 2353372 2353372 defendant Rede John yeoman 753801 753801 Rede, John, of Tylneye, yeoman 2
4989759 2353854 2353854 defendant Blower John gent 753801 753801 Blower, John, of Tylneye, gent 0
4992427 2354620 2354620 defendant Dix Robert husbandman 753801 753801 Dix, Robert, of Tylneye, husbandman 0
4992428 2354620 2354620 defendant Reede John husbandman 753801 753801 Reede, John, of Tylneye, husbandman 1
4997934 2356242 2356242 plaintiff Howeson Robert   753801 753801 Howeson, Robert, of Tylneye, vicar 0
4997935 2356242 2356242 defendant Myddylton John gent 753801 753801 Myddylton, John, of tylneye, gent 0
5019166 2362495 2362495 defendant Rede John husbandman 753801 753801 Rede, John, of Tylneye, husbandman 1
5048299 2371126 2371126 defendant Owerell Geoffrey husbandman 753801 753801 Owerell, Geoffrey, of Tylneye, husbandman 0
5064342 2375881 2375881 defendant Halle John chaplain 753801 753801 Halle, John, of Tylneye, chaplain 0
5127794 2394606 2394606 defendant Halle John chaplain 753801 753801 Halle, John, of Tylneye, chaplain 1
5310394 2448144 2448144 defendant Burton Thomas yeoman 753801 753801 Burton, Thomas, of Tylneye, yeoman 1
5626292 2552188 2552188 defendant Blowere Nicholas husbandman 753801 753801 Blowere, Nicholas, of Tylneye, husbandman 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);