names

21 rows where place_id = 595689

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621478 1874257 1874257 defendant Steed Peter husbandman 595689 595689 Steed, Peter, of Fraunsham, husbandman 0
3632409 1904954 1904954 defendant Wyskard Thomas yeoman 595689 595689 Wyskard, Thomas, of Fraunsham, yeoman 0
3632414 1904955 1904955 defendant Wyskard Thomas yeoman 595689 595689 Wyskard, Thomas, of Fraunsham, yeoman 0
3632418 1904956 1904956 defendant Crowe Robert husbandman 595689 595689 Crowe, Robert, of Fraunsham, husbandman 1
3702045 1926892 1926892 defendant Stede William gent 595689 595689 Stede, William, of Fraunsham, gent 1
3710665 1929656 1929656 defendant Toly Henry tailor 595689 595689 Toly, Henry, of Fraunsham, tailor 2
3736944 1937803 1937803 defendant Stede William gent 595689 595689 Stede, William, of Fraunsham, gent 3
3736950 1937804 1937804 defendant Stede William gent 595689 595689 Stede, William, of Fraunsham, gent 3
3739235 1938491 1938491 defendant Stede William gent 595689 595689 Stede, William, of Fraunsham, gent 0
3751841 1942493 1942493 defendant Stede William gent 595689 595689 Stede, William, of Fraunsham, gent 0
3752605 1942745 1942745 defendant Parker Robert husbandman 595689 595689 Parker, Robert, of Fraunsham, husbandman 1
3771045 1948632 1948632 plaintiff Stede William   595689 595689 Stede, William, of Fraunsham 0
3773836 1949528 1949528 defendant Toly Henry husbandman 595689 595689 Toly, Henry, of Fraunsham, husbandman 1
4208142 2098403 2098403 defendant Bloncoll John carpenter 595689 595689 Bloncoll, John, of Fraunsham, carpenter 0
4544197 2214101 2214101 defendant Shortwode John   595689 595689 Shortwode, John, of Fraunsham 1
4592637 2229047 2229047 plaintiff Oldhalle Edmund   595689 595689 Oldhalle, Edmund, of Fraunsham 0
4608608 2233798 2233798 plaintiff Bracke Geoffrey   595689 595689 Bracke, Geoffrey, of Fraunsham 0
4809334 2299095 2299095 defendant Colyn Adam yeoman 595689 595689 Colyn, Adam, of Fraunsham, yeoman 0
4985261 2352517 2352517 defendant Soules John husbandman 595689 595689 Soules, John, of Fraunsham, husbandman 6
5263738 2434410 2434410 defendant Boor John clerk 595689 595689 Boor, John, of Fraunsham, clerk 0
5272138 2436933 2436933 defendant Drake Geoffrey husbandman 595689 595689 Drake, Geoffrey, of Fraunsham, husbandman 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);