names

17 rows where place_id = 613843

✎ 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
3700589 1926430 1926430 defendant Barton Richard husbandman 613843 613843 Barton, Richard, of Molyngton, husbandman 0
4658454 2248525 2248525 defendant Hardewyk John gent 613843 613843 Hardewyk, John, of Molyngton, gent 0
4912553 2330428 2330428 plaintiff Carter Thomas   613843 613843 Carter, Thomas, of Molyngton 0
5102921 2387276 2387276 defendant Willyngham Humphrey esq 613843 613843 Willyngham, Humphrey, of Molyngton, esq 0
5126438 2394206 2394206 defendant Willyngham Humphrey   613843 613843 Willyngham, Humphrey, of Molyngton 0
5158693 2403663 2403663 defendant Yevot Thomas carpenter 613843 613843 Yevot, Thomas, of Molyngton, carpenter 0
5174120 2408133 2408133 defendant Yevot Thomas carpenter 613843 613843 Yevot, Thomas, of Molyngton, carpenter 0
5359495 2463003 2463003 defendant Willyngham Humphrey esq 613843 613843 Willyngham, Humphrey, of Molyngton, esq 4
5359496 2463003 2463003 defendant Halse Robert gent 613843 613843 Halse, Robert, of Molyngton, gent 5
5359497 2463003 2463003 defendant Hogegys John husbandman 613843 613843 Hogegys, John, of Molyngton, husbandman 6
5359498 2463003 2463003 defendant Hogeges Henry husbandman 613843 613843 Hogeges, Henry, of Molyngton, husbandman 7
5359499 2463003 2463003 defendant Wever Ralph yeoman 613843 613843 Wever, Ralph, of Molyngton, yeoman 8
5359500 2463003 2463003 defendant Notynggale Thomas yeoman 613843 613843 Notynggale, Thomas, of Molyngton, yeoman 9
5359501 2463003 2463003 defendant Hill Robert husbandman 613843 613843 Hill, Robert, of Molyngton, husbandman 10
5359502 2463003 2463003 defendant Stanley Thomas yeoman 613843 613843 Stanley, Thomas, of Molyngton, yeoman 11
5359503 2463003 2463003 defendant Bolton John yeoman 613843 613843 Bolton, John, of Molyngton, yeoman 12
5359504 2463003 2463003 defendant Barbour Thomas laborer 613843 613843 Barbour, Thomas, of Molyngton, laborer 13

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