names

16 rows where place_id = 588269

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593901 1865730 1865730 defendant Raulynson William laborer 588269 588269 Raulynson, William, of Burnby, laborer 1
3722529 1933306 1933306 defendant Gascoign William esq 588269 588269 Gascoign, William, of Burnby, esq 0
3800700 1958129 1958129 defendant Gascoigne William gent 588269 588269 Gascoigne, William, of Burnby, gent 0
3800702 1958130 1958130 defendant Gascoygne William gent 588269 588269 Gascoygne, William, of Burnby, gent 0
3817756 1963457 1963457 defendant Gascoign William esq 588269 588269 Gascoign, William, of Burnby, esq 0
3875615 1982086 1982086 defendant Gascoigne William gent 588269 588269 Gascoigne, William, of Burnby, gent 1
4708199 2267942 2267942 defendant Scotte William   588269 588269 Scotte, William, of Burnby, shepherd 4
4749092 2280219 2280219 defendant Newerk John   588269 588269 Newerk, John, of Burnby, parson 2
4919024 2332461 2332461 defendant Bryme William husbandman 588269 588269 Bryme, William, of Burnby, husbandman 2
4942788 2339715 2339715 defendant Lathom William husbandman 588269 588269 Lathom, William, of Burnby, husbandman 0
5022511 2363484 2363484 defendant Wasselyn Robert esq 588269 588269 Wasselyn, Robert, of Burnby, esq 0
5229386 2424203 2424203 defendant Vansour or Vausour Thomas husbandman 588269 588269 Vansour or Vausour, Thomas, of Burnby, husbandman 12
5240032 2427285 2427285 defendant Hornse John husbandman 588269 588269 Hornse, John, of Burnby, husbandman 0
5283939 2440331 2440331 defendant Skelton William husbandman 588269 588269 Skelton, William, of Burnby, husbandman 9
5598136 2534312 2534312 defendant Norrey Edward yeoman 588269 588269 Norrey, Edward, of Burnby, yeoman 0
5598142 2534313 2534313 defendant Norrey Edward yeoman 588269 588269 Norrey, Edward, of Burnby, yeoman 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);