names

25 rows where place_id = 640610

✎ 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
3594191 1865826 1865826 plaintiff Joly Thomas (legal representative) 640610 640610 Joly, Thomas, of Wyverston, executors of 0
3856389 1975619 1975619 defendant Morevyll Richard husbandman 640610 640610 Morevyll, Richard, of Wyverston, husbandman 0
3866516 1979030 1979030 defendant Talbott Thomas butcher 640610 640610 Talbott, Thomas, of Wyverston, butcher 2
3908013 1992973 1992973 plaintiff Pratyman John clerk 640610 640610 Pratyman, John, of Wyverston, clerk 0
3917221 1996119 1996119 defendant Patell George husbandman 640610 640610 Patell, George, of Wyverston, husbandman 3
4011396 2028853 2028853 defendant Gooderych William yeoman 640610 640610 Gooderych, William, of Wyverston, yeoman 0
4046137 2041057 2041057 defendant Raynberd Nicholas yeoman 640610 640610 Raynberd, Nicholas, of Wyverston, yeoman 0
4046139 2041058 2041058 defendant Raynberd Nicholas yeoman or sawyer 640610 640610 Raynberd, Nicholas, of Wyverston, yeoman or sawyer 0
4409487 2167770 2167770 defendant Beacon William, senior yeoman 640610 640610 Beacon, William, senior, of Wyverston, yeoman 0
4409492 2167771 2167771 defendant Beacon William, senior yeoman 640610 640610 Beacon, William, senior, of Wyverston, yeoman 0
4483538 2195538 2195538 defendant Page Thomas vicar 640610 640610 Page Thomas, of Wyverston, vicar 2
4513548 2204661 2204661 plaintiff Broun Alexander   640610 640610 Broun, Alexander, of Wyverston 0
4513553 2204662 2204662 plaintiff Broun Alexander   640610 640610 Broun, Alexander, of Wyverston 0
4586534 2227197 2227197 defendant Kyng John thatcher 640610 640610 Kyng, John, of Wyverston, thatcher 0
4832950 2306324 2306324 defendant Baron Robert yeoman 640610 640610 Baron, Robert, of Wyverston, yeoman 5
4868514 2317127 2317127 defendant Mikelwod Robert husbandman 640610 640610 Mikelwod, Robert, of Wyverston, husbandman 2
4993439 2354906 2354906 defendant Smyth John husbandman 640610 640610 Smyth, John, of Wyverston, husbandman 0
5024299 2364022 2364022 defendant Smyth John husbandman 640610 640610 Smyth, John, of Wyverston, husbandman 0
5045499 2370282 2370282 defendant Crystemasse John husbandman 640610 640610 Crystemasse, John, of Wyverston, husbandman 0
5099987 2386434 2386434 defendant Joly Hugh husbandman 640610 640610 Joly, Hugh, of Wyverston, husbandman 0
5100786 2386652 2386652 defendant Joly Hugh husbandman 640610 640610 Joly, Hugh, of Wyverston, husbandman 7
5100797 2386652 2386652 defendant Lacy Thomas husbandman 640610 640610 Lacy, Thomas, of Wyverston, husbandman 18
5104023 2387602 2387602 defendant Smyth John husbandman 640610 640610 Smyth, John, of Wyverston, or of Bakton, husbandman 0
5112141 2389936 2389936 defendant Spark Thomas yeoman 640610 640610 Spark, Thomas, of Wyverston, yeoman 0
5123845 2393430 2393430 defendant Smyth John husbandman 640610 640610 Smyth, John, of Wyverston, husbandman 4

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