names

51 rows where place_id = 589665

✎ 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
3598361 1867119 1867119 defendant Mason Thomas husbandman 589665 589665 Mason, Thomas, of Lucham, husbandman 0
3598363 1867119 1867119 defendant Burnham William yeoman 589665 589665 Burnham, William, of Lucham, yeoman 2
3608563 1870334 1870334 defendant Warter Richard yeoman 589665 589665 Warter, Richard, of Lucham, yeoman 4
3630816 1904460 1904460 defendant Lee Robert innholder 589665 589665 Lee, Robert, of Lucham, innholder 0
3808380 1960495 1960495 defendant Arton Christopher innkeeper 589665 589665 Arton, Christopher, of Lucham, innkeeper 0
3847618 1972825 1972825 defendant Constable Robert, senior husbandman 589665 589665 Constable, Robert, senior, of Lucham, husbandman 2
3847619 1972825 1972825 defendant Constable Robert, junior husbandman 589665 589665 Constable, Robert, junior, of Lucham, husbandman 3
3866591 1979053 1979053 defendant Jeffreys John husbandman 589665 589665 Jeffreys, John, of Lucham, husbandman 1
3887599 1986101 1986101 defendant Stede John carpenter 589665 589665 Stede, John, of Lucham, carpenter 1
4417916 2170481 2170481 plaintiff Taverner Thomas le chaplain 589665 589665 Taverner, Thomas le, of Lucham, chaplain 0
4485602 2196204 2196204 defendant Trendill John   589665 589665 Trendill, John, of Lucham 1
4497505 2199862 2199862 defendant Caudelere John   589665 589665 Caudelere, John, of Lucham 7
4498940 2200307 2200307 defendant Caudeler John   589665 589665 Caudeler, John, of Lucham 0
4537785 2212097 2212097 defendant Sadeler Reginald   589665 589665 Sadeler, Reginald, of Lucham 0
4544558 2214212 2214212 defendant Sadelere Reginald   589665 589665 Sadelere, Reginald, of Lucham 0
4545328 2214461 2214461 defendant Sadillere Reginald   589665 589665 Sadillere, Reginald, of Lucham 0
4545569 2214536 2214536 defendant Caudeler John   589665 589665 Caudeler, John, of Lucham 3
4550917 2216223 2216223 defendant Sadelere Reginald   589665 589665 Sadelere, Reginald, of Lucham 0
4572532 2222944 2222944 defendant Shepherd William   589665 589665 Shepherd, William, of Lucham 0
4583692 2226314 2226314 defendant Sadeler Reginald   589665 589665 Sadeler, Reginald, of Lucham 0
4584170 2226465 2226465 defendant Sadelere Reginald   589665 589665 Sadelere, Reginald, of Lucham 2
4608611 2233798 2233798 defendant Sadelere Reginald   589665 589665 Sadelere, Reginald, of Lucham 2
4619586 2237116 2237116 defendant Baxter John   589665 589665 Baxter, John, of Lucham 5
4619649 2237132 2237132 defendant Yaxham William   589665 589665 Yaxham, William, of Lucham 0
4620087 2237264 2237264 defendant Caudeler Nicholas   589665 589665 Caudeler, Nicholas, of Lucham 1
4642214 2243840 2243840 defendant Clerk Ralph   589665 589665 Clerk, Ralph, of Lucham 0
4648342 2245569 2245569 defendant Caudeler John   589665 589665 Caudeler, John, of Lucham 13
4661028 2249274 2249274 defendant Gatle John husbandman 589665 589665 Gatle, John, of Lucham, husbandman 3
4661032 2249275 2249275 defendant Gattele John husbandman 589665 589665 Gattele, John, of Lucham, husbandman 1
4661630 2249474 2249474 defendant Gatele John yeoman 589665 589665 Gatele, John, of Lucham, yeoman 1
4662739 2249804 2249804 defendant Yaxham William hosteler 589665 589665 Yaxham, William, of Lucham, hosteler 0
4677177 2258479 2258479 defendant Sadeler Reginald husbandman 589665 589665 Sadeler, Reginald, of Lucham, husbandman 2
4702541 2266207 2266207 defendant Sadeler Reginald husbandman 589665 589665 Sadeler, Reginald, of Lucham, husbandman 1
4714189 2269765 2269765 defendant Sadelere Reginald hosteller 589665 589665 Sadelere, Reginald, of Lucham, hosteller 0
4714191 2269765 2269765 defendant Caudeler John hosteller 589665 589665 Caudeler, John, of Lucham, hosteller 2
4855128 2312954 2312954 defendant Skynner Eleanor Roger 589665 589665 Skynner, Eleanor, of Lucham, singleman or spinster, innkeeper, daugher of Fayerchild, Roger 0
4892982 2324529 2324529 defendant Whyte Walter husbandman 589665 589665 Whyte, Walter, of Lucham, husbandman 1
4892983 2324529 2324529 defendant Tryce John husbandman 589665 589665 Tryce, John, of Lucham, husbandman 2
4893539 2324680 2324680 defendant Holley Thomas yeoman 589665 589665 Holley, Thomas, of Lucham, yeoman 0
4982714 2351742 2351742 defendant Wilkyn John butcher 589665 589665 Wilkyn, John, of Lucham, butcher 1
5161901 2404589 2404589 defendant Basse Robert yeoman 589665 589665 Basse, Robert, of Lucham, yeoman 1
5176155 2408714 2408714 defendant Basse Robert yeoman 589665 589665 Basse, Robert, of Lucham, yeoman 1
5198067 2415178 2415178 defendant Basse Robert yeoman 589665 589665 Basse, Robert, of Lucham, yeoman 1
5243823 2428387 2428387 defendant Shortwood John yeoman 589665 589665 Shortwood, John, of Lucham, yeoman 4
5262195 2433925 2433925 plaintiff Koo John yeoman 589665 589665 Koo, John, of Lucham, yeoman 1
5262196 2433925 2433925 defendant Schorthwode John yeoman 589665 589665 Schorthwode, John, of Lucham, yeoman 0
5312350 2448729 2448729 defendant Ketelston Thomas yeoman 589665 589665 Ketelston, Thomas, of Lucham, yeoman 0
5312351 2448729 2448729 defendant Neell William yeoman 589665 589665 Neell, William, of Lucham, yeoman 1
5319876 2451031 2451031 defendant Blaunche John carpenter 589665 589665 Blaunche, John, of Lucham, carpenter 2
5340300 2457173 2457173 defendant Warter Richard husbandman 589665 589665 Warter, Richard, of Lucham, husbandman 1
5355550 2461806 2461806 defendant Vyrby or Vyrly William husbandman 589665 589665 Vyrby or Vyrly, William, of Lucham, husbandman 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);