names

31 rows where place_id = 590529

✎ 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
3601497 1868124 1868124 defendant Whyte Richard weaver 590529 590529 Whyte, Richard, of Mydhurst, weaver 1
3723177 1933519 1933519 defendant Massy Edward smith 590529 590529 Massy, Edward, of Mydhurst, smith 0
3723180 1933520 1933520 defendant Massy Edward smith 590529 590529 Massy, Edward, of Mydhurst, smith 0
3723190 1933523 1933523 defendant Redman alias Mason William butcher 590529 590529 Redman alias Mason, William, of Mydhurst, butcher 0
3751646 1942432 1942432 defendant Gobyll Henry butcher 590529 590529 Gobyll, Henry, of Mydhurst, butcher 0
3751647 1942432 1942432 defendant Fechyn William barber 590529 590529 Fechyn, William, of Mydhurst, barber 1
3751648 1942432 1942432 defendant Kempe Thomas tailor 590529 590529 Kempe, Thomas, of Mydhurst, tailor 2
3751649 1942432 1942432 defendant Ball John fuller 590529 590529 Ball, John, of Mydhurst, fuller 3
3751650 1942432 1942432 defendant Bakemley Thomas husbandman 590529 590529 Bakemley, Thomas, of Mydhurst, husbandman 4
3781014 1951794 1951794 defendant Sterte William yeoman 590529 590529 Sterte, William, of Mydhurst, yeoman 0
3781015 1951794 1951794 defendant Moswell Philip butcher 590529 590529 Moswell, Philip, of Mydhurst, butcher 1
3850540 1973756 1973756 defendant Gayce John clothier 590529 590529 Gayce, John, of Mydhurst, clothier 0
3952654 2007998 2007998 defendant Gyddyng John mercer 590529 590529 Gyddyng, John, of Mydhurst, mercer 0
4047789 2041657 2041657 defendant Aylewyn William sherman 590529 590529 Aylewyn, William, of Mydhurst, sherman 0
4124289 2068979 2068979 defendant Moore Richard mercer 590529 590529 Moore, Richard, of Mydhurst, mercer 0
4166651 2083834 2083834 defendant Musholde Robert yeoman 590529 590529 Musholde, Robert, of Mydhurst, yeoman 1
4234341 2107547 2107547 defendant Waberton Robert glover 590529 590529 Waberton, Robert, of Mydhurst, glover 3
4330175 2140393 2140393 defendant Patchynge John yeoman 590529 590529 Patchynge, John, of Mydhurst, yeoman 1
4379580 2157787 2157787 defendant Patchynge John innholder 590529 590529 Patchynge, John, of Mydhurst, innholder 1
4804485 2297589 2297589 defendant Tanner Gregory tanner 590529 590529 Tanner, Gregory, of Mydhurst, tanner 0
4804486 2297589 2297589 defendant Dyer Simon draper 590529 590529 Dyer, Simon, of Mydhurst, draper 1
4925288 2334341 2334341 plaintiff Pedelyn Gregory   590529 590529 Pedelyn, Gregory, of Mydhurst 0
4978590 2350547 2350547 defendant Ray Peter glover 590529 590529 Ray, Peter, of Mydhurst, glover 1
5028689 2365267 2365267 plaintiff Musholl Robert baker 590529 590529 Musholl, Robert, of Mydhurst, baker 0
5077515 2379774 2379774 defendant Rokford Thomas shoemaker 590529 590529 Rokford, Thomas, of Mydhurst, shoemaker 2
5077516 2379774 2379774 defendant Boxfeld William weaver 590529 590529 Boxfeld, William, of Mydhurst, weaver 3
5077517 2379774 2379774 defendant Stokker John weaver 590529 590529 Stokker, John, of Mydhurst, weaver 4
5077518 2379774 2379774 defendant Potter John shoemaker 590529 590529 Potter, John, of Mydhurst, shoemaker 5
5077519 2379774 2379774 defendant Carter Thomas tanner 590529 590529 Carter, Thomas, of Mydhurst, tanner 6
5077523 2379776 2379776 defendant Carter Thomas barker 590529 590529 Carter, Thomas, of Mydhurst, barker 0
5101506 2386853 2386853 plaintiff Bagle Michael (legal representative) 590529 590529 Bagle, Michael, of Mydhurst, executors of 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);