names

36 rows where place_id = 630426

✎ 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
3794293 1956089 1956089 defendant Pytney Richard smith 630426 630426 Pytney, Richard, of Horton, Bucks, smith 0
3905429 1992086 1992086 defendant Kerlek Thomas yeoman 630426 630426 (Kerlek, Thomas, of Horton, Bucks, yeoman 1
3907810 1992900 1992900 defendant Balnett John gent 630426 630426 Balnett, John, of Horton, Bucks, gent 0
3940401 2003808 2003808 defendant Brokas Robert esq 630426 630426 Brokas, Robert, of Horton, Bucks, esq 0
3946076 2005703 2005703 defendant Warde Thomas yeoman 630426 630426 Warde, Thomas, of Horton, Bucks, yeoman 0
3960112 2010639 2010639 defendant Hartwell Henry yeoman 630426 630426 Hartwell, Henry, of Horton, Bucks, yeoman 0
3962769 2011565 2011565 defendant Warde Thomas miller 630426 630426 Warde, Thomas, of Horton, Bucks, miller 0
3968399 2013580 2013580 defendant Mayn Henry yeoman 630426 630426 Mayn, Henry, of Horton, Bucks, yeoman 0
3969274 2013860 2013860 defendant Drurye Edmund gent 630426 630426 Drurye, Edmund, of Horton, Bucks, gent 0
3970715 2014346 2014346 defendant Brocas Barnard gent 630426 630426 Brocas, Barnard, of Horton, Bucks, gent 0
3970717 2014347 2014347 defendant Brocas Barnard gent 630426 630426 Brocas, Barnard, of Horton, Bucks, gent 0
3991846 2021837 2021837 defendant Goomer John yeoman 630426 630426 Goomer, John, of Horton, Bucks, yeoman 0
4001809 2025421 2025421 defendant Brocas Barnard gent 630426 630426 Brocas, Barnard, of Horton, Bucks, gent 5
4046073 2041034 2041034 defendant Brocas Barnard esq 630426 630426 Brocas, Barnard, of Horton, Bucks, esq 0
4046076 2041035 2041035 defendant Brocas Bernard esq 630426 630426 Brocas, Bernard, of Horton, Bucks, esq 0
4065019 2047772 2047772 defendant Brocas Barnard esq 630426 630426 Brocas, Barnard, of Horton, Bucks, esq 0
4076799 2051990 2051990 defendant Digbye Ambrose esq 630426 630426 Digbye, Ambrose, of Horton, Bucks, esq 0
4254513 2114498 2114498 defendant Higgons William gent 630426 630426 Higgons, William, of Horton, Bucks, gent 0
4304857 2131834 2131834 defendant Glossonne or Gloston Thomas yeoman 630426 630426 Glossonne or Gloston, Thomas, of Horton, Bucks, yeoman 0
4327025 2139369 2139369 defendant Reve Nicholas smith 630426 630426 Reve, Nicholas, of Horton, Bucks, smith 0
4401326 2165040 2165040 defendant Langley Thomas tanner 630426 630426 Langley, Thomas, of Horton, Bucks, tanner 0
4559973 2219068 2219068 defendant Naveby John   630426 630426 Naveby, John, of Horton, Bucks 1
4692916 2263293 2263293 defendant Navenby John husbandman 630426 630426 Navenby, John, of Horton, Bucks, husbandman 0
4692918 2263294 2263294 defendant Navenby John   630426 630426 Navenby, John, of Horton, Bucks 0
4730865 2274852 2274852 plaintiff Melreth Thomas   630426 630426 Melreth, Thomas, of Horton, Bucks 0
5137749 2397552 2397552 defendant Godewyn Richard husbandman 630426 630426 Godewyn, Richard, of Horton, Bucks, husbandman 1
5137751 2397552 2397552 defendant Snowesmere William butcher 630426 630426 Snowesmere, William, of hOrton, Bucks, butcher 3
5158458 2403594 2403594 defendant Godewyn Richard husbandman 630426 630426 Godewyn, Richard, of Horton, Bucks, husbandman 1
5174012 2408098 2408098 defendant Godewyn Richard husbandman 630426 630426 Godewyn, Richard, of Horton, Bucks, husbandman 0
5375728 2468000 2468000 plaintiff Reve Richard   630426 630426 Reve, Richard, of Horton, Bucks 0
5499933 2504932 2504932 plaintiff Reve Richard husbandman 630426 630426 Reve, Richard, of Horton, Bucks, husbandman 0
5499935 2504933 2504933 plaintiff Reve Richard husbandman 630426 630426 Reve, Richard, of Horton, Bucks, husbandman 0
5558533 2522447 2522447 defendant Lyrer John yeoman 630426 630426 Lyrer, John, of Horton, Bucks, yeoman 0
5627711 2552636 2552636 defendant Carpenter William glover 630426 630426 Carpenter, William, of Horton, Bucks, glover 0
5630847 2553654 2553654 defendant Melreth Thomas gent 630426 630426 Melreth, Thomas, of Horton, Bucks, gent 0
5630849 2553655 2553655 defendant Melreth Thomas gent 630426 630426 Melreth, Thomas, of Horton, Bucks, gent 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);