names

23 rows where place_id = 624918

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3761076 1945465 1945465 defendant Shillytode John yeoman 624918 624918 Shillytode, John, of Methley, yeoman 0
3786078 1953437 1953437 defendant Webster John sherman 624918 624918 Webster, John, of Methley, sherman 1
3790106 1954723 1954723 defendant Warde John laborer 624918 624918 Warde, John, of Methley, laborer 0
3834761 1968808 1968808 defendant Raynold Thomas gent 624918 624918 Raynold, Thomas, of Methley, gent 0
3973584 2015330 2015330 defendant Shyllyto Robert husbandman 624918 624918 Shyllyto, Robert, of Methley, husbandman 1
4105136 2062110 2062110 defendant Dobson Ralph, senior yeoman 624918 624918 Dobson, Ralph, senior, of Methley, yeoman 0
4105137 2062110 2062110 defendant Dobson John husbandman 624918 624918 Dobson, John, of Methley, husbandman 1
4105138 2062110 2062110 defendant Dobson Richard, junior husbandman 624918 624918 Dobson, Richard, junior, of Methley, husbandman 2
4137324 2073698 2073698 defendant Dobson Robert victualer 624918 624918 Dobson, Robert, of Methley, victualer 0
4182851 2089483 2089483 defendant Cristofer Alan miller 624918 624918 Cristofer, Alan, of Methley, miller 0
4182852 2089483 2089483 defendant Crosfeild Edmund husbandman 624918 624918 Crosfeild, Edmund, of Methley, husbandman 1
4182853 2089483 2089483 defendant Thorpe Richard laborer 624918 624918 Thorpe, Richard, of Methley, laborer 2
4182855 2089484 2089484 defendant Sheppe George butcher 624918 624918 Sheppe, George, of Methley, butcher 0
4182857 2089484 2089484 defendant Richardson Alexander shoemaker 624918 624918 Richardson, Alexander, of Methley, shoemaker 2
4184838 2090206 2090206 defendant Marshall John badger 624918 624918 Marshall, John, of Methley, badger 0
4184840 2090207 2090207 defendant Marshall John badger 624918 624918 Marshall, John, of Methley, badger 0
4189251 2091735 2091735 defendant Burton alias Carver Robert yeoman 624918 624918 Burton alias Carver, Robert, of Methley, yeoman 0
4189252 2091735 2091735 defendant Dobson Robert yeoman 624918 624918 Dobson, Robert, of Methley, yeoman 1
4260394 2116443 2116443 defendant Nalson or Nelson Robert yeoman 624918 624918 Nalson or Nelson, Robert, of Methley, yeoman 0
4320355 2137220 2137220 defendant Laborne Robert, senior yeoman 624918 624918 Laborne, Robert, senior, of Methley, yeoman 0
4337205 2142741 2142741 defendant Loder William clerk 624918 624918 Loder, William, of Methley, clerk 0
4352925 2148250 2148250 defendant Lynley Francis pointer 624918 624918 Lynley, Francis, of Methley, pointer 0
4406289 2166669 2166669 defendant Lynley Francis painter 624918 624918 Lynley, Francis, of Methley, painter 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);