names

36 rows where place_id = 589810

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598846 1867264 1867264 defendant Kethyngton John chapman 589810 589810 Kethyngton, John, of Hundelby, chapman 1
3598847 1867264 1867264 defendant Kethyngton Richard chapman 589810 589810 Kethyngton, Richard, of Hundelby, chapman 2
3599559 1867500 1867500 defendant Canyngton Richard chapman 589810 589810 Canyngton, Richard, of Hundelby, chapman 0
3599560 1867500 1867500 defendant Canyngton John chapman 589810 589810 Canyngton, John, of Hundelby, chapman 1
3703897 1927498 1927498 defendant Burdonn William husbandman 589810 589810 Burdonn, William, of Hundelby, husbandman 3
3779274 1951240 1951240 defendant Smyth Thomas clerk 589810 589810 Smyth, Thomas, of Hundelby, clerk 0
3779275 1951240 1951240 defendant Smyth John husbandman 589810 589810 Smyth, John, of Hundelby, husbandman 1
3845222 1972067 1972067 defendant Kyrke Robert laborer 589810 589810 Kyrke, Robert, of Hundelby, laborer 1
3845223 1972067 1972067 defendant Bende Christopher   589810 589810 Bende, Christopher, of Hundelby, tallow chandler 2
3845224 1972067 1972067 defendant Pynner Richard husbandman 589810 589810 Pynner, Richard, of Hundelby, husbandman 3
3845225 1972067 1972067 defendant Jenkynson Robert husbandman 589810 589810 Jenkynson, Robert, of Hundelby, husbandman 4
4022993 2032943 2032943 defendant Mawlam John tailor 589810 589810 Mawlam, John, of Hundelby, tailor 0
4077099 2052092 2052092 defendant Lincoln John yeoman 589810 589810 Lincoln, John, of Hundelby, yeoman 0
4573299 2223182 2223182 defendant Mason Robert   589810 589810 Mason, Robert, of Hundelby 0
4604076 2232443 2232443 defendant Candelesby Robert   589810 589810 Candelesby, Robert, of Hundelby 0
4604077 2232443 2232443 defendant Perkynson Robert   589810 589810 Perkynson, Robert, of Hundelby 1
4604078 2232443 2232443 defendant Mabson William   589810 589810 Mabson, William, of Hundelby 2
4680697 2259577 2259577 defendant Lavam or Lanam Simon husbandman 589810 589810 Lavam or Lanam, Simon, of Hundelby, husbandman 0
4680698 2259577 2259577 defendant Lanam John laborer 589810 589810 Lanam, John, of Hundelby, laborer 1
4735685 2276307 2276307 defendant Roper John husbandman 589810 589810 Roper, John, of Hundelby, husbandman 2
4798030 2295571 2295571 defendant Roper John laborer 589810 589810 Roper, John, of Hundelby, laborer 0
4798035 2295573 2295573 defendant Tedd William husbandman 589810 589810 Tedd, William, of Hundelby, husbandman 1
4831545 2305899 2305899 plaintiff Rede Robert   589810 589810 Rede, Robert, of Hundelby 2
4954736 2343370 2343370 defendant Tedde William husbandman 589810 589810 Tedde, William, of Hundelby, husbandman 0
5235288 2425899 2425899 defendant Bewestyn William husbandman 589810 589810 Bewestyn, William, of Hundelby, husbandman 2
5265330 2434913 2434913 plaintiff Stoyle Robert   589810 589810 Stoyle, Robert, of Hundelby 0
5265663 2435013 2435013 defendant Randall Richard husbandman 589810 589810 Randall, Richard, of Hundelby, husbandman 1
5265900 2435088 2435088 defendant Westmels John husbandman 589810 589810 Westmels, John, of Hundelby, husbandman 0
5266316 2435217 2435217 defendant Tayllour John tailor 589810 589810 Tayllour, John, of Hundelby, tailor 1
5298959 2444676 2444676 defendant Hamond William, sen husbandman 589810 589810 Hamond, William, sen, of Hundelby, husbandman 0
5317812 2450415 2450415 defendant Est Robert husbandman 589810 589810 Est, Robert, of Hundelby, husbandman 0
5487996 2501300 2501300 defendant Smyth Richard husbandman 589810 589810 Smyth, Richard, of Hundelby, husbandman 0
5487997 2501300 2501300 defendant Todde Thomas, senior husbandman 589810 589810 Todde, Thomas, senior, of Hundelby, husbandman 1
5487998 2501300 2501300 defendant Labyche Edward draper 589810 589810 Labyche, Edward, of Hundelby, draper 2
5593844 2533061 2533061 defendant Pawlyn William yeoman 589810 589810 Pawlyn, William, of Hundelby, yeoman 0
5606821 2537020 2537020 defendant Wright Richard husbandman 589810 589810 Wright, Richard, of Hundelby, husbandman 3

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);