names

23 rows where place_id = 609822

✎ 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
3680524 1919990 1919990 plaintiff Rokeby Thomas gent 609822 609822 Rokeby, Thomas, of Gresbroke, gent 0
3680525 1919990 1919990 defendant Worall Richard yeoman 609822 609822 Worall, Richard, of Gresbroke, yeoman 0
3680526 1919990 1919990 defendant Worall William yeoman 609822 609822 Worall, William, of Gresbroke, yeoman 1
3683784 1921063 1921063 defendant Holt John husbandman 609822 609822 (Holt, John, of Gresbroke, husbandman 1
3715070 1931009 1931009 defendant Wanewright James laborer 609822 609822 Wanewright, James, of Gresbroke, laborer 0
3790732 1954925 1954925 defendant Worall William yeoman 609822 609822 Worall, William, of Gresbroke, yeoman 0
3959807 2010522 2010522 defendant Hudson John smith 609822 609822 Hudson, John, of Gresbroke, smith 3
3962940 2011636 2011636 defendant Rysheforde Thomas laborer 609822 609822 Rysheforde, Thomas, of Gresbroke, laborer 0
4158394 2081007 2081007 defendant Saterthwette Thomas yeoman 609822 609822 Saterthwette, Thomas, of Gresbroke, yeoman 0
4176889 2087386 2087386 defendant Adamson Richard weaver 609822 609822 Adamson, Richard, of Gresbroke, weaver 2
4261696 2116866 2116866 defendant Swyfte Alexander gent 609822 609822 Swyfte, Alexander, of Gresbroke, gent 2
4751658 2280975 2280975 defendant Speyne Robert husbandman 609822 609822 Speyne, Robert, of Gresbroke, husbandman 0
4804651 2297650 2297650 defendant Nayler William nayler 609822 609822 Nayler, William, of Gresbroke, nayler 0
5243971 2428426 2428426 defendant Turnlay Elias   609822 609822 Turnlay, Elias, of Gresbroke, "sonyour" 3
5348470 2459661 2459661 defendant Tailloure William husbandman 609822 609822 Tailloure, William, of Gresbroke, husbandman 2
5380371 2469435 2469435 defendant Taillour William husbandman 609822 609822 Taillour, William, of Gresbroke, husbandman 3
5384951 2470768 2470768 defendant Taillour William husbandman 609822 609822 Taillour, William, of Gresbroke, husbandman 3
5397004 2474223 2474223 defendant Tayllour William husbandman 609822 609822 Tayllour, William, of Gresbroke, husbandman 3
5397011 2474224 2474224 defendant Tayllour William husbandman 609822 609822 Tayllour, William, of Gresbroke, husbandman 3
5565175 2524403 2524403 defendant Beete Thomas yeoman 609822 609822 Beete, Thomas, of Gresbroke, yeoman 0
5607693 2537306 2537306 defendant Lawton Thomas yeoman 609822 609822 Lawton, Thomas, of Gresbroke, yeoman 0
5607694 2537306 2537306 defendant Lawton John yeoman 609822 609822 Lawton, John, of Gresbroke, yeoman 1
5607695 2537306 2537306 defendant Russhworth Thomas yeoman 609822 609822 Russhworth, Thomas, of Gresbroke, yeoman 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);