names

38 rows where place_id = 595517

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3620816 1874079 1874079 defendant Kyng alias Socoure William baker 595517 595517 Kyng alias Socoure, William, of Leomynster, Herefs, baker 0
3686470 1921920 1921920 defendant Redyng Hugh gent 595517 595517 Redyng, Hugh, of Leomynster, Herefs, gent 0
3686473 1921921 1921921 defendant Redyng Hugh gent 595517 595517 Redyng, Hugh, of Leomynster, Herefs, gent 0
3708217 1928864 1928864 defendant Redyng Hugh glover 595517 595517 Redyng, Hugh, of Leomynster, Herefs, glover 2
3712003 1930072 1930072 defendant Kynton John yeoman 595517 595517 Kynton, John, of Leomynster, Herefs, yeoman 0
3763349 1946166 1946166 defendant Dyer William carrier 595517 595517 Dyer, William, of Leomynster, Herefs, carrier 1
3763354 1946167 1946167 defendant Dyer William carrier 595517 595517 Dyer, William, of Leomynster, Herefs, carrier 1
3769672 1948171 1948171 defendant Grene Richard chapman 595517 595517 Grene, Richard, of Leomynster, Herefs, chapman 1
3804876 1959468 1959468 defendant Harley John esq 595517 595517 Harley, John, of Leomynster, Herefs, esq 2
3880390 1983696 1983696 defendant Inke or Juke John yeoman 595517 595517 Inke or Juke, John, of Leomynster, herefs, yeoman 0
3880766 1983831 1983831 defendant Ynke John chapman 595517 595517 Ynke, John, of Leomynster, Herefs, chapman 2
3950144 2007132 2007132 defendant Baker John yeoman 595517 595517 (Baker, John, of Leomynster, Herefs, yeoman 2
3951672 2007638 2007638 defendant Dallowe Thomas gent 595517 595517 (Dallowe, Thomas, of Leomynster, Herefs, gent 1
3955147 2008860 2008860 defendant Moryse Philip mercer 595517 595517 Moryse, Philip, of Leomynster, Herefs, mercer 0
3969443 2013918 2013918 defendant Parsons John laborer 595517 595517 Parsons, John, of Leomynster, Herefs, laborer 2
4080157 2053214 2053214 defendant Caswall John yeoman 595517 595517 Caswall, John, of Leomynster, Herefs, yeoman 0
4091233 2057155 2057155 defendant Creswell John gent 595517 595517 Creswell, John, of Leomynster, Herefs, gent 0
4098057 2059633 2059633 defendant Perryn Thomas chapman 595517 595517 Perryn, Thomas, of Leomynster, Herefs, chapman 0
4098059 2059634 2059634 defendant Stevens Thomas gent 595517 595517 Stevens, Thomas, of Leomynster, Herefs, gent 0
4102720 2061272 2061272 defendant Peryn Thomas yeoman 595517 595517 Peryn, Thomas, of Leomynster, Herefs, yeoman 0
4155732 2080087 2080087 defendant Longe Thomas yeoman 595517 595517 Longe, Thomas, of Leomynster, Herefs, yeoman 0
4177792 2087707 2087707 defendant Morys Philip gent 595517 595517 Morys, Philip, of Leomynster, Herefs, gent 0
4238722 2109163 2109163 defendant Addys John mercer 595517 595517 Addys, John, of Leomynster, Herefs, mercer 0
4258201 2115715 2115715 defendant Monoxe Richard yeoman 595517 595517 Monoxe, Richard, of Leomynster, Herefs, yeoman 0
4283586 2124167 2124167 defendant Rawlyns Hugh glover 595517 595517 Rawlyns, Hugh, of Leomynster, Herefs, glover 0
4863748 2315634 2315634 defendant Clerke Robert dyer 595517 595517 Clerke, Robert, of Leomynster, Herefs, dyer 0
4978043 2350399 2350399 defendant Walker Walter yeoman 595517 595517 Walker, Walter, of Leomynster, Herefs, yeoman 0
5105587 2388084 2388084 defendant Hoode William chapman 595517 595517 Hoode, William, of Leomynster, Herefs, chapman 1
5105591 2388085 2388085 defendant Hoode William chapman 595517 595517 Hoode, William, of Leomynster, Herefs, chapman 1
5123179 2393214 2393214 defendant Hode William mercer 595517 595517 Hode, William, of Leomynster, Herefs, mercer 2
5142292 2398864 2398864 defendant Baret Richard   595517 595517 Baret, Richard, of Leomynster, Herefs 0
5212687 2419459 2419459 defendant mainpernors for Bradford John yeoman 595517 595517 mainpernors for Bradford, John, of Leomynster, Herefs, yeoman 4
5222326 2422238 2422238 defendant Spenser William Dyer 595517 595517 Spenser, William, of Leomynster, Herefs, Dyer 0
5258894 2432897 2432897 defendant Hopkyns Thomas chapman 595517 595517 Hopkyns, Thomas, of Leomynster, Herefs, Herefs, chapman 2
5530332 2513998 2513998 defendant Baret John yeoman 595517 595517 Baret, John, of Leomynster, Herefs, yeoman 1
5535498 2515630 2515630 defendant Eliot Henry mercer 595517 595517 Eliot, Henry, of Leomynster, Herefs, mercer 4
5586090 2530690 2530690 defendant Cornwall Thomas   595517 595517 Cornwall, Thomas, of Leomynster, Herefs, knight 0
5596931 2533954 2533954 defendant ap Howell Roger capper 595517 595517 (ap Howell, Roger, of Leomynster, Herefs, capper 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);