names

22 rows where place_id = 588920

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596002 1866379 1866379 defendant Carpenter John husbandman 588920 588920 Carpenter, John, of Flamstede, Herts, husbandman 1
3618734 1873481 1873481 defendant Willyams Joan widow 588920 588920 Willyams, Joan, of Flamstede, Herts, widow 0
3828991 1966951 1966951 defendant Wyght John   588920 588920 Wyght, John, of Flamstede, Herts 0
3948759 2006634 2006634 defendant Belgrave Richard husbandman 588920 588920 Belgrave, Richard, of Flamstede, Herts, husbandman 0
3955296 2008920 2008920 defendant Belgrave Richard husbandman 588920 588920 Belgrave, Richard, of Flamstede, Herts, husbandman 0
4002607 2025704 2025704 defendant Astwycke John yeoman 588920 588920 Astwycke, John, of Flamstede, Herts, yeoman 0
4873909 2318778 2318778 defendant Warner Walter yeoman 588920 588920 Warner, Walter, of Flamstede, Herts, yeoman 0
4899697 2326538 2326538 defendant Balsham William husbandman 588920 588920 Balsham, William, of Flamstede, Herts, husbandman 1
4952757 2342782 2342782 defendant Redyng William yeoman 588920 588920 Redyng, William, of Flamstede, Herts, yeoman 0
5117560 2391568 2391568 defendant Ingilton Robert gent 588920 588920 Ingilton, Robert, of Flamstede, Herts, gent 0
5117562 2391569 2391569 defendant Ingilton Thomas gent 588920 588920 Ingilton, Thomas, of Flamstede, Herts, gent 0
5138713 2397818 2397818 defendant Chalvehunt John husbandman 588920 588920 Chalvehunt, John, of Flamstede, Herts, husbandman 0
5138715 2397819 2397819 defendant Chalvehunt John husbandman 588920 588920 Chalvehunt, John, of Flamstede, Herts, husbandman 0
5181590 2410360 2410360 defendant Palmer Thomas carpenter 588920 588920 Palmer, Thomas, of Flamstede, Herts, carpenter 2
5202980 2416635 2416635 defendant Palmer Thomas carpenter 588920 588920 Palmer, Thomas, of Flamstede, Herts, carpenter 2
5243385 2428261 2428261 defendant Spenser William yoman 588920 588920 Spenser, William, of Flamstede, Herts, yoman 4
5344154 2458349 2458349 defendant Fynour John tanner 588920 588920 Fynour, John, of Flamstede, Herts, tanner 0
5348559 2459684 2459684 defendant Warner Thomas husbandman 588920 588920 Warner, Thomas, of Flamstede, Herts, husbandman 0
5348564 2459685 2459685 defendant Warner Thomas husbandman 588920 588920 Warner, Thomas, of Flamstede, Herts, husbandman 0
5380431 2469452 2469452 defendant Grigge John skinner 588920 588920 Grigge, John, of Flamstede, Herts, skinner 0
5380434 2469453 2469453 defendant Grygge John, senior pulter 588920 588920 Grygge, John, senior, of Flamstede, Herts, pulter 0
5384990 2470781 2470781 defendant Grygge John skinner 588920 588920 Grygge, John, of Flamstede, Herts, skinner 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);