names

31 rows where place_id = 589790

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598758 1867240 1867240 defendant Begot Henry gent 589790 589790 Begot, Henry, of Lincs, gent 0
3598760 1867241 1867241 defendant Begot Henry gent 589790 589790 Begot, Henry, of Lincs, gent 0
3805592 1959691 1959691 plaintiff Thornton Robert   589790 589790 Thornton, Robert, of Lincs, corn man 0
3805594 1959692 1959692 plaintiff Thornton Robert   589790 589790 Thornton, Robert, of Lincs, corn man 0
3823094 1965132 1965132 plaintiff Thornton Robert cornman 589790 589790 Thornton, Robert, of Lincs, cornman 0
3827738 1966542 1966542 defendant Holond Thomas gent 589790 589790 Holond, Thomas, of Lincs, gent 1
3982429 2018488 2018488 plaintiff Sapcott Edward esq 589790 589790 Sapcott, Edward, of Lincs, esq 0
4295273 2128396 2128396 defendant Gamblyn or Gamble Mathew gent 589790 589790 Gamblyn or Gamble, Mathew, of Lincs, gent 0
4299557 2129930 2129930 defendant Egglefeild Anthony yeoman 589790 589790 Egglefeild, Anthony, of Lincs, yeoman 0
4500494 2200775 2200775 defendant Haweberkes John   589790 589790 Haweberkes, John, of Lincs 2
4659952 2248964 2248964 defendant Gra John esq 589790 589790 Gra, John, of Lincs, esq 0
4781090 2290095 2290095 defendant Beaumond Thomas   589790 589790 Beaumond, Thomas, of Lincs, or of Overton, Leics, knight 0
4781364 2290181 2290181 defendant Catour William butcher 589790 589790 Catour, William, of Lincs, butcher 0
4893344 2324623 2324623 defendant Ratford Henry   589790 589790 Ratford, Henry, of Lincs, or of London knight 0
4946104 2340770 2340770 defendant Rouseby or Ronseby Robert merchant 589790 589790 Rouseby or Ronseby, Robert, of Lincs, merchant 0
4955397 2343575 2343575 defendant Rouseby or Ronseby Robert merchant 589790 589790 Rouseby or Ronseby, Robert, of Lincs, merchant 0
4955849 2343717 2343717 plaintiff Tirwhyt William   589790 589790 Tirwhyt, William, of Lincs, knight 0
4973407 2348988 2348988 defendant Thurleston John clerk 589790 589790 Thurleston, John, of Lincs, clerk 0
4984258 2352220 2352220 plaintiff White Roger (legal representative) 589790 589790 White, Roger, of Lincs, esq, executors of 0
5021394 2363163 2363163 defendant Blykelyng John   589790 589790 Blykelyng, John, of Parson of Wst Bytham, Lincs 1
5052345 2372303 2372303 defendant Preston John (legal representative) 589790 589790 Preston, John, of Lincs, esq, executors of 1
5065128 2376103 2376103 defendant North John butcher 589790 589790 North, John, of Lincs, butcher 0
5065486 2376209 2376209 defendant Hoddylston John merchant 589790 589790 Hoddylston, John, of Lincs, merchant 2
5083898 2381685 2381685 defendant Goderyk John   589790 589790 Goderyk, John, of Lincs, apothecary 0
5097046 2385568 2385568 plaintiff Swerdeston John, junior gent 589790 589790 Swerdeston, John, junior, of Lincs, gent 0
5100756 2386645 2386645 defendant Calcrofte John gent 589790 589790 Calcrofte, John, of Lincs, gent 1
5119374 2392092 2392092 defendant Hornclyffe Robert yeoman 589790 589790 Hornclyffe, Robert, of Lincs, yeoman 0
5232214 2425001 2425001 plaintiff Brompton William mercer 589790 589790 Brompton, William, of Lincs, mercer 0
5510035 2507978 2507978 plaintiff Greves or Grenes William yeoman 589790 589790 Greves or Grenes, William, of Lincs, yeoman 0
5549036 2519757 2519757 defendant Laken George gent 589790 589790 Laken, George, of Derby, Lincs, gent 0
5625733 2551991 2551991 defendant Barnaby John, senior esq 589790 589790 Barnaby, John, senior, of Lincs, esq 5

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