names

45 rows where place_id = 586024

✎ 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
3587726 1863807 1863807 defendant Lulleham Henry laborer 586024 586024 Lulleham, Henry, of Rype, laborer 5
3587730 1863807 1863807 defendant A Towne John laborer 586024 586024 A Towne, John, of Rype, laborer 9
3693728 1924232 1924232 defendant Smyth Lawrence butcher 586024 586024 Smyth, Lawrence, of Rype, butcher 2
3703744 1927450 1927450 defendant Goodwyn John husbandman 586024 586024 Goodwyn, John, of Rype, husbandman 1
3718456 1932051 1932051 defendant Goodwyn John yeoman 586024 586024 Goodwyn, John, of Rype, yeoman 0
3778866 1951104 1951104 defendant Geffrey Robert husbandman 586024 586024 Geffrey, Robert, of Rype, husbandman 1
3778867 1951104 1951104 defendant Snayle John husbandman 586024 586024 Snayle, John, of Rype, husbandman 2
3781269 1951883 1951883 plaintiff Halle John   586024 586024 Halle, John, of Rype 0
3794237 1956069 1956069 defendant Rychardson William yeoman 586024 586024 Rychardson, William, of Rype, yeoman 0
3795758 1956540 1956540 defendant Laket Richard laborer 586024 586024 Laket, Richard, of Rype, laborer 0
3795759 1956541 1956541 plaintiff Davy John   586024 586024 Davy, John, of Rype 0
3799968 1957911 1957911 defendant Davy John husbandman 586024 586024 Davy, John, of Rype, husbandman 0
3809924 1960991 1960991 defendant Clever John husbandman 586024 586024 Clever, John, of Rype, husbandman 0
3864727 1978398 1978398 defendant Richardson William (legal representative) 586024 586024 Richardson, William, of Rype, yeoman, executors of 0
3878023 1982893 1982893 defendant Mott John tailor 586024 586024 Mott, John, of Rype, tailor 3
4019015 2031536 2031536 defendant Reynold John clerk 586024 586024 Reynold, John, of Rype, clerk 0
4027517 2034486 2034486 defendant Wylkyns Thomas husbandman 586024 586024 Wylkyns, Thomas, of Rype, husbandman 0
4038361 2038361 2038361 plaintiff Langredge Elizabeth singlewoman 586024 586024 Langredge, Elizabeth, of Rype, singlewoman 0
4038362 2038361 2038361 defendant Turpyn Lawrence husbandman 586024 586024 Turpyn, Lawrence, of Rype, husbandman 0
4051930 2043110 2043110 defendant Raynold John clerk 586024 586024 Raynold, John, of Rype, clerk 0
4054339 2043942 2043942 defendant Raynold John clerk 586024 586024 Raynold, John, of Rype, clerk 3
4107039 2062814 2062814 defendant Senock William yeoman 586024 586024 Senock, William, of Rype, yeoman 2
4107060 2062819 2062819 defendant Champneys John yeoman 586024 586024 Champneys, John, of Rype, yeoman 3
4173611 2086224 2086224 defendant Eston Nicholas yeoman 586024 586024 Eston, Nicholas, of Rype, yeoman 1
4364654 2152416 2152416 defendant Olyver William yeoman 586024 586024 Olyver, William, of Rype, yeoman 3
4370342 2154446 2154446 defendant Page John yeoman 586024 586024 Page, John, of Rype, or of Pevensey, yeoman 0
4372191 2155120 2155120 defendant Acton William tailor 586024 586024 Acton, William, of Rype, tailor 0
4622697 2238073 2238073 plaintiff Mabbe John   586024 586024 Mabbe, John, of Rype 0
4622698 2238073 2238073 defendant Clerk William   586024 586024 Clerk, William, of Rype 0
4646872 2245147 2245147 defendant atte Chambr Thomas   586024 586024 atte Chambr, Thomas, of Rype 4
4946111 2340772 2340772 defendant Topyn Richard husbandman 586024 586024 Topyn, Richard, of Rype, husbandman 3
4946118 2340773 2340773 defendant Topyn Richard husbandman 586024 586024 Topyn, Richard, of Rype, husbandman 3
4968776 2347630 2347630 defendant Lane William laborer 586024 586024 Lane, William, of Rype, laborer 0
4968777 2347630 2347630 defendant Roper Roger laborer 586024 586024 Roper, Roger, of Rype, laborer 1
4968778 2347630 2347630 defendant atte Welle John laborer 586024 586024 atte Welle, John, of Rype, laborer 2
5012791 2360572 2360572 defendant Stapelegh William husbandman 586024 586024 Stapelegh, William, of Rype, husbandman 1
5020646 2362932 2362932 defendant Lane Walter laborer 586024 586024 Lane, Walter, of Rype, laborer 0
5020647 2362932 2362932 defendant Roper Roger laborer 586024 586024 Roper, Roger, of Rype, laborer 1
5031943 2366213 2366213 defendant Baron Simon laborer 586024 586024 Baron, Simon, of Rype, laborer 0
5039261 2368384 2368384 defendant Roper John tailor 586024 586024 Roper, John, of Rype, tailor 0
5101304 2386791 2386791 defendant Broun Thomas tailor 586024 586024 Broun, Thomas, of Rype, tailor 0
5272626 2437068 2437068 defendant Keneth John laborer 586024 586024 Keneth, John, of Rype, laborer 5
5346279 2458977 2458977 defendant Levet or Lenet John husbandman 586024 586024 Levet or Lenet, John, of Rype, husbandman 3
5364248 2464477 2464477 defendant Levet John husbandman 586024 586024 Levet, John, of Rype, husbandman 0
5587583 2531132 2531132 defendant Lulleham John husbandman 586024 586024 Lulleham, John, of Rype, 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);