names

56 rows where place_id = 757174

✎ 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
4443915 2183065 2183065 defendant Porter Adam   757174 757174 Porter, Adam, of Welynton 0
4446996 2183975 2183975 defendant Huchecok John   757174 757174 Huchecok, John, of Welynton, vicar 0
4452458 2185765 2185765 defendant Aleyn John   757174 757174 Aleyn, John, of Welynton 1
4453832 2186207 2186207 defendant Aleyn John   757174 757174 Aleyn, John, of Welynton 1
4489350 2197387 2197387 defendant Hychecok John   757174 757174 Hychecok, John, of Welynton, vicar 0
4489354 2197388 2197388 defendant Hichecok John   757174 757174 Hichecok, John, of Welynton, vicar 0
4498494 2200176 2200176 plaintiff Frenshe John (legal representative) 757174 757174 Frenshe, John, of Welynton, executors of 0
4521017 2206908 2206908 plaintiff Frensshe John le (legal representative) 757174 757174 Frensshe, John le, of Welynton, executor of 0
4531163 2210021 2210021 defendant Brokton Roger   757174 757174 (Brokton, Roger, of Welynton 5
4546618 2214867 2214867 defendant Harper William   757174 757174 Harper, William, of Welynton 2
4565292 2220714 2220714 defendant Morton John   757174 757174 Morton, John, of Welynton 2
4565293 2220714 2220714 defendant Baker Thomas   757174 757174 Baker, Thomas, of Welynton 3
4565304 2220716 2220716 defendant Holgrene William   757174 757174 Holgrene, William, of Welynton 0
4585790 2226977 2226977 plaintiff Harper William   757174 757174 Harper, William, of Welynton 0
4607941 2233605 2233605 defendant Walker Ralp;h   757174 757174 Walker, Ralp;h, of Welynton 0
4607942 2233605 2233605 defendant Playbury John   757174 757174 Playbury, John, of Welynton 1
4619901 2237204 2237204 defendant Hunt Robert   757174 757174 Hunt, Robert, of Welynton 0
4646127 2244940 2244940 defendant Barton John   757174 757174 Barton, John, of Welynton 0
4662638 2249780 2249780 plaintiff Frensshe William   757174 757174 Frensshe, William, of Welynton 0
4662643 2249780 2249780 defendant Petur William yeoman 757174 757174 Petur, William, of Welynton, yeoman 4
4662644 2249781 2249781 plaintiff Frensshe William   757174 757174 Frensshe, William, of Welynton 0
4662648 2249781 2249781 defendant Holgreve William husbandman 757174 757174 Holgreve, William, of Welynton, husbandman 3
4662649 2249781 2249781 defendant Petur William yeoman 757174 757174 Petur, William, of Welynton, yeoman 4
4671986 2256882 2256882 defendant Dicon Richard tanner 757174 757174 Dicon, Richard, of Welynton, tanner 1
4684911 2260875 2260875 defendant Restard Isolda widow 757174 757174 Restard, Isolda, of Welynton, widow 0
4684912 2260875 2260875 defendant Restard Richard chaplain 757174 757174 Restard, Richard, of Welynton, chaplain 1
4684913 2260875 2260875 defendant Restard Roger yeoman 757174 757174 Restard, Roger, of Welynton, yeoman 2
4815754 2301029 2301029 defendant Welynton John gent 757174 757174 Welynton, John, of Welynton, gent 0
4816852 2301375 2301375 defendant Chapman Roger husbandman 757174 757174 Chapman, Roger, of Welynton, husbandman 1
4828456 2304943 2304943 defendant Orchard John laboroer 757174 757174 Orchard, John, of Welynton, laboroer 4
4861947 2315116 2315116 defendant Meryell William yeoman 757174 757174 Meryell, William, of Welynton, yeoman 0
4861948 2315116 2315116 defendant Mersshe John husbandman 757174 757174 Mersshe, John, of Welynton, husbandman 1
4861949 2315116 2315116 defendant Drede Robert laborer 757174 757174 Drede, Robert, of Welynton, laborer 2
4861950 2315116 2315116 defendant de la Hey Hugh Thomasservant laborer 757174 757174 de la Hey, Hugh Thomasservant, of Welynton, laborer 3
4877005 2319780 2319780 defendant Wyke Richard husbandman 757174 757174 Wyke, Richard, of Welynton, husbandman 0
4883816 2321844 2321844 defendant Chaundes John husbandman 757174 757174 Chaundes, John, of Welynton, husbandman 1
4890110 2323684 2323684 defendant Mayell William, senior husbandman 757174 757174 Mayell, William, senior, of Welynton, husbandman 0
4899850 2326590 2326590 defendant Chaundes Robert gent 757174 757174 Chaundes, Robert, of Welynton, gent 1
4902848 2327507 2327507 defendant Brewere John husbandman 757174 757174 Brewere, John, of Welynton, husbandman 0
4902850 2327507 2327507 defendant Wotton Richard husbandman 757174 757174 Wotton, Richard, of Welynton, husbandman 2
4959281 2344741 2344741 defendant Ederyche John husbandman 757174 757174 Ederyche, John, of Welynton, husbandman 3
5023448 2363767 2363767 defendant Welynton John gent 757174 757174 Welynton, John, of Welynton, gent 0
5145287 2399763 2399763 defendant Tedyr Robert weaver 757174 757174 Tedyr, Robert, of Welynton, under the Wrekyn, Shrops, weaver 0
5170188 2407009 2407009 defendant Welyngton Thomas gent 757174 757174 Welyngton, Thomas, of Welynton, gent 1
5182928 2410755 2410755 defendant Hogges William husbandman 757174 757174 Hogges, William, of Welynton, husbandman 0
5182929 2410755 2410755 defendant Balle Lewis husbandman 757174 757174 Balle, Lewis, of Welynton, husbandman 1
5182930 2410755 2410755 defendant Smyth Lewis husbandman 757174 757174 Smyth, Lewis, of Welynton, husbandman 2
5182931 2410755 2410755 defendant Chaundes John husbandman 757174 757174 Chaundes, John, of Welynton, husbandman 3
5297958 2444415 2444415 defendant Bragges Isabel (legal representative) 757174 757174 Bragges, Isabel, of Welynton under Wreken, widow, executors of 1
5297960 2444415 2444415 defendant Bragges Roger chaplain 757174 757174 Bragges, Roger, of Welynton under Wreken, chaplain 3
5480444 2499131 2499131 defendant Elys John tailor 757174 757174 Elys, John, of Welynton, tailor 1
5584208 2530131 2530131 defendant Shmyth John husbandman 757174 757174 Shmyth, John, of Welynton, husbandman 1
5588697 2531476 2531476 defendant Tayllour David husbandman 757174 757174 Tayllour, David, of Welynton, husbandman 0
5615074 2548505 2548505 plaintiff Freynche Roger le   757174 757174 Freynche, Roger le, of Welynton 0
5624458 2551592 2551592 plaintiff le Frensche Roger (legal representative) 757174 757174 le Frensche, Roger, of Welynton, executor of 0
5624461 2551593 2551593 plaintiff le Frensche Roger (legal representative) 757174 757174 le Frensche, Roger, of Welynton, executor of 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);