names

34 rows where place_id = 587877

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592717 1865337 1865337 plaintiff Grendyll John   587877 587877 Grendyll, John, of Market Depyng 0
3624337 1875146 1875146 plaintiff Tego William   587877 587877 Tego, William, of Market Depyng 0
3624338 1875146 1875146 defendant Sharwyn John husbandman 587877 587877 Sharwyn, John, of Market Depyng, husbandman 0
3624339 1875146 1875146 defendant Lambe Brian miller 587877 587877 Lambe, Brian, of Market Depyng, miller 1
3639805 1907261 1907261 defendant Bocher William butcher 587877 587877 Bocher, William, of Market Depyng, butcher 0
3677817 1919114 1919114 defendant Adam Nicholas smith 587877 587877 Adam, Nicholas, of Market Depyng, smith 0
3677818 1919114 1919114 defendant Jakson Thomas husbandman 587877 587877 Jakson, Thomas, of Market Depyng, husbandman 1
3677820 1919115 1919115 defendant Adam Nicholas smith 587877 587877 Adam, Nicholas, of Market Depyng, smith 0
3677821 1919115 1919115 defendant Jakson Thomas husbandman 587877 587877 Jakson, Thomas, of Market Depyng, husbandman 1
3683248 1920881 1920881 defendant Watson Thomas husbandman 587877 587877 Watson, Thomas, of Market Depyng, husbandman 0
3691075 1923371 1923371 defendant Shyngyls Thomas mercer 587877 587877 Shyngyls, Thomas, of Market Depyng, mercer 0
3691080 1923372 1923372 defendant Shyngyls Thomas mercer 587877 587877 Shyngyls, Thomas, of Market Depyng, mercer 0
3691984 1923657 1923657 defendant Mawdesley James yeoman 587877 587877 Mawdesley, James, of Market Depyng, yeoman 0
3711934 1930047 1930047 defendant Wake Thomas gent 587877 587877 Wake, Thomas, of Market Depyng, gent 0
3853252 1974636 1974636 defendant Grene Athelard fuller 587877 587877 Grene, Athelard, of Market Depyng, fuller 0
3892850 1987855 1987855 defendant Whyte Thomas carpenter 587877 587877 Whyte, Thomas, of Market Depyng, carpenter 2
4750712 2280694 2280694 defendant Twywell John   587877 587877 Twywell, John, of Market Depyng, bailiff 1
4750731 2280698 2280698 defendant Watson John husbandman 587877 587877 Watson, John, of Market Depyng, husbandman 0
4850971 2311753 2311753 defendant Hunt John butcher 587877 587877 Hunt, John, of Market Depyng, butcher 3
5042127 2369252 2369252 defendant Neweland John husbandman 587877 587877 Neweland, John, of Market Depyng, husbandman 1
5049415 2371461 2371461 defendant Jelons or Jelous John husbandman 587877 587877 Jelons or Jelous, John, of Market Depyng, husbandman 0
5075682 2379227 2379227 defendant Whitley John fisher 587877 587877 Whitley, John, of Market Depyng, fisher 3
5102690 2387199 2387199 defendant Dykelyn Richard clerk 587877 587877 Dykelyn, Richard, of Market Depyng, clerk 1
5141801 2398717 2398717 defendant Mase William weaver 587877 587877 Mase, William, of Market Depyng, weaver 0
5230891 2424643 2424643 defendant Dykun Simon (legal representative) 587877 587877 Dykun, Simon, of Market Depyng, executors of 0
5238962 2426986 2426986 defendant Dykun Simon (legal representative) 587877 587877 Dykun, Simon, of Market Depyng, executors of 0
5269426 2436154 2436154 defendant Sherwen John, junior husbandman 587877 587877 Sherwen, John, junior, of Market Depyng, husbandman 0
5289716 2441994 2441994 defendant Fayrefax William esq 587877 587877 Fayrefax, William, of Market Depyng, esq 0
5289718 2441995 2441995 defendant Fayrfax William esq 587877 587877 Fayrfax, William, of Market Depyng, esq 0
5352629 2460917 2460917 defendant Tego Stephen draper 587877 587877 Tego, Stephen, of Market Depyng, draper 0
5411888 2478507 2478507 defendant Tego Stephen draper 587877 587877 Tego, Stephen, of Market Depyng, draper 0
5482908 2499831 2499831 defendant Johnson John husbandman 587877 587877 Johnson, John, of Market Depyng, husbandman 1
5590759 2532082 2532082 defendant Mawdysley James yeoman 587877 587877 (Mawdysley, James, of Market Depyng, yeoman 1
5590774 2532085 2532085 defendant Mawdysley James yeoman 587877 587877 (Mawdysley, James, of Market Depyng, yeoman 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);