names

30 rows where place_id = 590085

✎ 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
3599829 1867594 1867594 defendant Skarne or Skarve Thomas yeoman 590085 590085 Skarne or Skarve, Thomas, of Dryffeld, yeoman 0
4016629 2030653 2030653 defendant Adams John yeoman 590085 590085 Adams, John, of Dryffeld, clerk, or of Holyroode Ampney, yeoman 0
4497073 2199746 2199746 defendant Couton William   590085 590085 Couton, William, of Dryffeld 2
4514445 2204935 2204935 defendant Lytster William   590085 590085 Lytster, William, of Dryffeld 0
4558558 2218630 2218630 defendant Rose Robert   590085 590085 Rose, Robert, of Dryffeld 0
4634167 2241530 2241530 defendant Chapman William   590085 590085 Chapman, William, of Dryffeld 1
4776148 2288538 2288538 defendant Bolton John   590085 590085 Bolton, John, of Dryffeld, shield bearer 0
4784713 2291224 2291224 defendant Cartwryght Marmaduke (legal representative) 590085 590085 Cartwryght, Marmaduke, of Dryffeld, executor of 4
4818826 2301971 2301971 defendant Garton Richard husbandman 590085 590085 Garton, Richard, of Dryffeld, husbandman 1
4898774 2326266 2326266 plaintiff Routh William   590085 590085 (Routh, William, of Dryffeld 1
4898845 2326282 2326282 defendant Water William gent 590085 590085 Water, William, of Dryffeld, gent 0
4898848 2326284 2326284 plaintiff Routh William esq 590085 590085 Routh, William, of Dryffeld, esq 0
4922060 2333310 2333310 defendant Raper John smith 590085 590085 Raper, John, of Dryffeld, smith 3
4929839 2335747 2335747 defendant Misterton Robert laborer 590085 590085 Misterton, Robert, of Dryffeld, laborer 0
4952571 2342728 2342728 plaintiff Routh William esq 590085 590085 Routh, William, of Dryffeld, esq 0
4952573 2342729 2342729 plaintiff Routh William esq 590085 590085 Routh, William, of Dryffeld, esq 0
4974542 2349348 2349348 defendant Marshall John laborer 590085 590085 Marshall, John, of Dryffeld, laborer 0
4999589 2356752 2356752 defendant Smyth William smith 590085 590085 Smyth, William, of Dryffeld, smith 4
5020151 2362782 2362782 defendant Routhe Brian gent 590085 590085 Routhe, Brian, of Dryffeld, gent 0
5027815 2365015 2365015 defendant Routhe Brian gent 590085 590085 Routhe, Brian, of Dryffeld, gent 0
5048688 2371245 2371245 defendant Routhe William (legal representative) 590085 590085 Routhe, William, of Dryffeld, esq, executors of 0
5048689 2371245 2371245 defendant Routhe Brian   590085 590085 (Routhe, Brian, of Dryffeld, gent, son of Testator 1
5048690 2371245 2371245 defendant Routhe Edward   590085 590085 Routhe, Edward, of Dryffeld, gent, son of Testator 2
5048696 2371247 2371247 plaintiff Routhe William (legal representative) 590085 590085 Routhe, William, of Dryffeld, esq, executors of 0
5048697 2371247 2371247 plaintiff Routhe Brian   590085 590085 (Routhe, Brian, of Dryffeld, gent, son of Testator 1
5048698 2371247 2371247 plaintiff Routhe Edward   590085 590085 Routhe, Edward, of Dryffeld, gent, son of Testator 2
5058325 2374034 2374034 defendant Brayn John husbandman 590085 590085 Brayn, John, of Dryffeld, husbandman 4
5286003 2440917 2440917 defendant Laurens William laborer 590085 590085 Laurens, William, of Dryffeld, laborer 0
5286004 2440917 2440917 defendant Cleve William laborer 590085 590085 Cleve, William, of Dryffeld, laborer 1
5286005 2440917 2440917 defendant Elborough Richard laborer 590085 590085 Elborough, Richard, of Dryffeld, laborer 2

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);