names

38 rows where place_id = 625983

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3767352 1947435 1947435 defendant Carden William husbandman 625983 625983 Carden, William, of Fulham, Middx, husbandman 0
3827822 1966567 1966567 defendant Spendlove Edward yeoman 625983 625983 Spendlove, Edward, of Fulham, Middx, yeoman 0
3852651 1974435 1974435 defendant Toller John gent 625983 625983 Toller, John, of Fulham, Middx, gent 2
3852655 1974436 1974436 defendant Toller John husbandman 625983 625983 Toller, John, of Fulham, Middx, husbandman 2
3856855 1975771 1975771 defendant Tayler John yeoman 625983 625983 Tayler, John, of Fulham, Middx, yeoman 1
3956324 2009276 2009276 defendant Marten Richard husbandman 625983 625983 Marten, Richard, of Fulham, Middx, husbandman 1
3960766 2010869 2010869 defendant Parker Henry gent 625983 625983 Parker, Henry, of Fulham, Middx, gent 1
3998457 2024187 2024187 plaintiff Ferne or Fyron John (legal representative) 625983 625983 Ferne or Fyron, John, of Fulham, Middx, or of St Giles Creplegate, London, yeoman, administratrix of 0
4123874 2068836 2068836 defendant Essex William gent 625983 625983 Essex, William, of Fulham, Middx, gent 3
4130840 2071342 2071342 defendant Atkynson Peter yeoman 625983 625983 Atkynson, Peter, of Fulham, Middx, yeoman 0
4302666 2131050 2131050 defendant Wade Hugh gardiner 625983 625983 Wade, Hugh, of Fulham, Middx, gardiner 0
4345595 2145726 2145726 defendant Gaies Thomas pewterer 625983 625983 Gaies, Thomas, of Fulham, Middx, yeoman, pewterer 0
4371846 2154993 2154993 defendant Doggewell Richard yeoman 625983 625983 Doggewell, Richard, of Fulham, Middx, yeoman 1
4475937 2193146 2193146 defendant Ilberd William   625983 625983 Ilberd, William, of Fulham, Middx, parson 1
4504898 2202070 2202070 defendant Symond Richard   625983 625983 Symond, Richard, of Fulham, Middx 3
4672360 2257004 2257004 defendant Clyfford Richard clerk 625983 625983 Clyfford, Richard, of Fulham, Middx, clerk 0
4701079 2265745 2265745 defendant Knotte John   625983 625983 Knotte, John, of Fulham, Middx 0
4701081 2265746 2265746 defendant Knoote John gent 625983 625983 Knoote, John, of Fulham, Middx, gent 0
4835195 2307008 2307008 defendant Knotte John husbandman 625983 625983 Knotte, John, of Fulham, Middx, husbandman 0
4835199 2307009 2307009 defendant Knotte John husbandman 625983 625983 Knotte, John, of Fulham, Middx, husbandman 0
4844064 2309654 2309654 defendant Fuller Ralph husbandman 625983 625983 Fuller, Ralph, of Fulham, Middx, husbandman 0
4844068 2309655 2309655 defendant Fuller Ralph husbandman 625983 625983 Fuller, Ralph, of Fulham, Middx, husbandman 0
5105143 2387942 2387942 defendant Brook Henry gent 625983 625983 Brook, Henry, of Fulham, Middx, gent 0
5107659 2388671 2388671 defendant Walfray Henry clerk 625983 625983 Walfray, Henry, of Fulham, Middx, clerk 1
5138234 2397694 2397694 defendant Bedyll Thomas husbandman 625983 625983 Bedyll, Thomas, of Fulham, Middx, husbandman 1
5155034 2402627 2402627 defendant Sherwold Richard husbandman 625983 625983 Sherwold, Richard, of Fulham, Middx, husbandman 0
5159028 2403758 2403758 defendant Bodyll Thomas husbandman 625983 625983 Bodyll, Thomas, of Fulham, Middx, husbandman 1
5171828 2407479 2407479 defendant Sherwold Richard husbandman 625983 625983 Sherwold, Richard, of Fulham, Middx, husbandman 0
5190578 2412990 2412990 defendant Sherwold Richard husbandman 625983 625983 Sherwold, Richard, of Fulham, Middx, husbandman 0
5190588 2412992 2412992 defendant Sherwold Richard husbandman 625983 625983 Sherwold, Richard, of Fulham, Middx, husbandman 0
5273079 2437200 2437200 defendant Pantagu Nicholas laborer 625983 625983 Pantagu, Nicholas, of Fulham, Middx, laborer 3
5293067 2442955 2442955 defendant Coppyng John husbandman 625983 625983 Coppyng, John, of Fulham, Middx, husbandman 1
5293070 2442956 2442956 defendant Coppyng John husbandman 625983 625983 Coppyng, John, of Fulham, Middx, husbandman 1
5303070 2445908 2445908 defendant Yong John yeoman 625983 625983 Yong, John, of Fulham, Middx, yeoman 0
5303074 2445909 2445909 defendant Yonge John yeoman 625983 625983 together with Yonge, John, of Fulham, Middx, yeoman 1
5493642 2503011 2503011 defendant Haynes John gent 625983 625983 Haynes, John, of Fulham, Middx, gent 1
5512611 2508798 2508798 defendant Sturgeon Beatrice widow 625983 625983 Sturgeon, Beatrice, of Fulham, Middx, widow 0
5563447 2523910 2523910 defendant Morse John husbandman 625983 625983 Morse, John, of Fulham, Middx, husbandman 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);