names

27 rows where place_id = 645005

✎ 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
3762308 1945857 1945857 plaintiff Gascoign William   645005 645005 Gascoign, William, of Cardyngton, knight 0
3861760 1977399 1977399 plaintiff Gascoigne William   645005 645005 Gascoigne, William, of Cardyngton, knight 0
3883267 1984667 1984667 defendant Waters Thomas, junior husbandman 645005 645005 Waters, Thomas, junior, of Cardyngton, husbandman 1
3883269 1984667 1984667 defendant Smythe Thomas laborer 645005 645005 Smythe, Thomas, of Cardyngton, laborer 3
3966608 2012956 2012956 defendant Bache Elizabeth widow 645005 645005 Bache, Elizabeth, of Cardyngton, widow 0
3966610 2012957 2012957 defendant Bache Elizabeth widow 645005 645005 Bache, Elizabeth, of Cardyngton, widow 0
4031045 2035773 2035773 defendant Blewett Richard husbandman 645005 645005 Blewett, Richard, of Cardyngton, husbandman 0
4031047 2035774 2035774 defendant Blewett Richard husbandman 645005 645005 Blewett, Richard, of Cardyngton, husbandman 0
4049160 2042147 2042147 defendant Gascoigne John gent 645005 645005 Gascoigne, John, of Cardyngton, gent 0
4074366 2051136 2051136 defendant Tayler John husbandman 645005 645005 Tayler, John, of Cardyngton, husbandman 1
4078335 2052551 2052551 defendant Handys Thomas husbandman 645005 645005 Handys, Thomas, of Cardyngton, husbandman 2
4218981 2102133 2102133 defendant Gostwycke William gent 645005 645005 Gostwycke, William, of Cardyngton, gent 1
4218984 2102134 2102134 defendant Gostwycke William gent 645005 645005 Gostwycke, William, of Cardyngton, gent 1
4363395 2151981 2151981 defendant Storer Richard husbandman 645005 645005 Storer, Richard, of Cardyngton, husbandman 0
4721773 2272145 2272145 defendant Sumonour Walter   645005 645005 Sumonour, Walter, of Cardyngton 4
4729375 2274404 2274404 defendant Colyns William butcher 645005 645005 Colyns, William, of Cardyngton, butcher 1
4746945 2279608 2279608 defendant Cartere Richard husbandman 645005 645005 Cartere, Richard, of Cardyngton, husbandman 1
5220033 2421568 2421568 defendant Nesse Richard yeoman 645005 645005 Nesse, Richard, of Cardyngton, yeoman 3
5237515 2426556 2426556 defendant White John laborer 645005 645005 White, John, of Cardyngton, laborer 0
5237516 2426556 2426556 defendant Waren John laborer 645005 645005 Waren, John, of Cardyngton, laborer 1
5269718 2436255 2436255 defendant Bulle John husbandman 645005 645005 Bulle, John, of Cardyngton, husbandman 1
5407273 2477142 2477142 plaintiff Vynter John   645005 645005 Vynter, John, of Cardyngton 0
5420514 2481058 2481058 plaintiff Vynter John   645005 645005 Vynter, John, of Cardyngton 0
5420516 2481059 2481059 plaintiff Vynter John   645005 645005 Vynter, John, of Cardyngton 0
5429123 2483636 2483636 defendant Ovyns or Obyns William yeoman 645005 645005 Ovyns or Obyns, William, of Cardyngton, yeoman 0
5542649 2517819 2517819 defendant Crawemfeld William husbandman 645005 645005 Crawemfeld, William, of Cardyngton, husbandman 0
5569091 2525510 2525510 plaintiff Goldston John   645005 645005 Goldston, John, of Cardyngton 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);