names

30 rows where place_id = 626136

✎ 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
3654677 1911721 1911721 defendant Owen David   626136 626136 Owen, David, of Midhurst, Sussex, knight 0
3768227 1947701 1947701 defendant Owen Jasper esq 626136 626136 Owen, Jasper, of Midhurst, Sussex, esq 0
3808234 1960452 1960452 defendant Wellys Thomas yeoman 626136 626136 Wellys, Thomas, of Midhurst, Sussex, yeoman 1
3929421 2000183 2000183 defendant Vyncent Roger clothier 626136 626136 Vyncent, Roger, of Midhurst, Sussex, clothier 5
3942129 2004386 2004386 defendant Brokhurst John yeoman 626136 626136 Brokhurst, John, of Midhurst, Sussex, yeoman 0
3996279 2023418 2023418 defendant Baygesley or Badgeslaye William yeoman 626136 626136 Baygesley or Badgeslaye, William, of Midhurst, Sussex, yeoman 0
4061771 2046610 2046610 defendant Fylder John yeoman 626136 626136 Fylder, John, of Midhurst, Sussex, yeoman 2
4166445 2083763 2083763 defendant Moore Richard chapman 626136 626136 Moore, Richard, of Midhurst, Sussex, chapman 2
4193797 2093402 2093402 defendant Musholde Robert yeoman 626136 626136 Musholde, Robert, of Midhurst, Sussex, yeoman 0
4204267 2097041 2097041 defendant Knyght Richard weaver 626136 626136 Knyght, Richard, of Midhurst, Sussex, weaver 0
4206184 2097710 2097710 defendant Moore Richard yeoman 626136 626136 Moore, Richard, of Midhurst, Sussex, yeoman 2
4349535 2147098 2147098 defendant Greete Henry yeoman 626136 626136 Greete, Henry, of Midhurst, Sussex, yeoman 2
4405745 2166491 2166491 defendant Ruffyn Roger clothier 626136 626136 Ruffyn, Roger, of Midhurst, Sussex, clothier 0
4405748 2166492 2166492 defendant Ruffyn Roger clothier 626136 626136 Ruffyn, Roger, of Midhurst, Sussex, clothier 0
4700325 2265518 2265518 defendant Playce William barber 626136 626136 Playce, William, of Midhurst, Sussex, barber 2
4797309 2295331 2295331 defendant Wrothale John gent 626136 626136 Wrothale, John, of Midhurst, Sussex, gent 2
4842200 2309094 2309094 defendant Hyden Thomas gent 626136 626136 Hyden, Thomas, of Midhurst, Sussex, gent 1
4981517 2351383 2351383 defendant Lombe Thomas tailor 626136 626136 Lombe, Thomas, of Midhurst, Sussex, tailor 0
5086757 2382520 2382520 defendant Fetsale Robert mercer 626136 626136 Fetsale, Robert, of Midhurst, Sussex, mercer 0
5101505 2386852 2386852 defendant Stert John sherman 626136 626136 Stert, John, of Midhurst, Sussex, sherman 0
5129943 2395247 2395247 plaintiff Dempe Richard weaver 626136 626136 Dempe, Richard, of Midhurst, Sussex, weaver 2
5148651 2400727 2400727 defendant Symkyns John butcher 626136 626136 Symkyns, John, of Midhurst, Sussex, butcher 1
5148654 2400728 2400728 defendant Symkyns John butcher 626136 626136 Symkyns, John, of Midhurst, Sussex, butcher 1
5167883 2406318 2406318 defendant Symkyns John butcher 626136 626136 Symkyns, John, of Midhurst, Sussex, butcher 1
5189227 2412580 2412580 defendant Amys John husbandman 626136 626136 Amys, John, of Midhurst, Sussex, husbandman 1
5189230 2412581 2412581 defendant Amys John husbandman 626136 626136 Amys, John, of Midhurst, Sussex, husbandman 1
5192398 2413512 2413512 defendant Rey John husbandman 626136 626136 Rey, John, of Midhurst, Sussex, husbandman 3
5207740 2418002 2418002 defendant Rey John husbandman 626136 626136 Rey, John, of Midhurst, Sussex, husbandman 2
5245585 2428866 2428866 defendant Fytsall Robert (legal representative) 626136 626136 Fytsall, Robert, of Midhurst, Sussex, executor of 1
5245606 2428873 2428873 defendant Fitsall Robert (legal representative) 626136 626136 Fitsall, Robert, of Midhurst, Sussex, executor of 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);