names

37 rows where place_id = 603369

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3654319 1911610 1911610 defendant Blachnet William clerk 603369 603369 Blachnet, William, of Hamsey, clerk 4
3657296 1912541 1912541 defendant Randolf William yeoman 603369 603369 Randolf, William, of Hamsey, yeoman 0
3662100 1914068 1914068 defendant Cooke William gent 603369 603369 Cooke, William, of Hamsey, gent 0
3662102 1914069 1914069 defendant Randolf William yeoman 603369 603369 Randolf, William, of Hamsey, yeoman 0
3662104 1914070 1914070 defendant Randolf William yeoman 603369 603369 Randolf, William, of Hamsey, yeoman 0
3693458 1924166 1924166 defendant Goreham John laborer 603369 603369 Goreham, John, of Hamsey, laborer 0
3738051 1938117 1938117 defendant Mone Thomas husbandman 603369 603369 Mone, Thomas, of Hamsey, husbandman 0
3738052 1938117 1938117 defendant Bette Thomas husbandman 603369 603369 Bette, Thomas, of Hamsey, husbandman 1
3744196 1940081 1940081 defendant Randall William yeoman 603369 603369 Randall, William, of Hamsey, yeoman 0
3746636 1940863 1940863 defendant Randyll William yeoman 603369 603369 Randyll, William, of Hamsey, yeoman 1
3769746 1948191 1948191 defendant Randall John, senior husbandman 603369 603369 Randall, John, senior, of Hamsey, husbandman 0
3786973 1953727 1953727 defendant Rowlandson John clerk 603369 603369 Rowlandson, John, of Hamsey, clerk 0
3787568 1953900 1953900 defendant Randalff William husbandman 603369 603369 Randalff, William, of Hamsey, husbandman 0
3787569 1953900 1953900 defendant Randalff John, junior husbandman 603369 603369 Randalff, John, junior, of Hamsey, husbandman 1
3788427 1954181 1954181 defendant Randolff William yeoman 603369 603369 Randolff, William, of Hamsey, yeoman 0
3803262 1958925 1958925 defendant Rowlandson Edward husbandman 603369 603369 Rowlandson, Edward, of Hamsey, husbandman 0
3820708 1964366 1964366 plaintiff Randall William yeoman 603369 603369 Randall, William, of Hamsey, yeoman 0
4061327 2046454 2046454 defendant Parysshe John husbandman 603369 603369 Parysshe, John, of Hamsey, husbandman 1
4066465 2048298 2048298 defendant Playsted John yeoman 603369 603369 Playsted, John, of Hamsey, yeoman 7
4083358 2054331 2054331 defendant Bottynge Stephen yeoman 603369 603369 Bottynge, Stephen, of Hamsey, yeoman 1
4133728 2072395 2072395 defendant Ren Roger husbandman 603369 603369 Ren, Roger, of Hamsey, husbandman 3
4153115 2079188 2079188 defendant Cowlstock Robert husbandman 603369 603369 Cowlstock, Robert, of Hamsey, husbandman 1
4179129 2088174 2088174 defendant Brewer Alan carpenter 603369 603369 Brewer, Alan, of Hamsey, carpenter 1
4180806 2088765 2088765 defendant Bruer Alan carpenter 603369 603369 Bruer, Alan, of Hamsey, carpenter 1
4182207 2089256 2089256 defendant Robert Thomas gent 603369 603369 Robert, Thomas, of Hamsey, gent 1
4186162 2090646 2090646 defendant Iredge William miller 603369 603369 Iredge, William, of Hamsey, miller 1
4204201 2097020 2097020 defendant Bruer Alan carpenter 603369 603369 Bruer, Alan, of Hamsey, carpenter 1
4230691 2106230 2106230 defendant Randolf alias Randall George yeoman 603369 603369 Randolf alias Randall, George, of Hamsey, yeoman 0
4310351 2133775 2133775 defendant Perse John husbandman 603369 603369 Perse, John, of Hamsey, husbandman 0
4312562 2134528 2134528 defendant Randall Robert yeoman 603369 603369 Randall, Robert, of Hamsey, yeoman 0
4312563 2134528 2134528 defendant Randall George yeoman 603369 603369 Randall, George, of Hamsey, yeoman 1
4318029 2136414 2136414 defendant Randall Robert yeoman 603369 603369 Randall, Robert, of Hamsey, yeoman 1
4318030 2136414 2136414 defendant Randall George yeoman 603369 603369 Randall, George, of Hamsey, yeoman 2
4374627 2155986 2155986 defendant Renne Thomas yeoman 603369 603369 Renne, Thomas, of Hamsey, yeoman 0
4404277 2166002 2166002 defendant Valier Thomas yeoman 603369 603369 Valier, Thomas, of Hamsey, yeoman 1
5421092 2481238 2481238 defendant Dunton John husbandman 603369 603369 Dunton, John, of Hamsey, husbandman 3
5421093 2481238 2481238 defendant Cobbe William husbandman 603369 603369 Cobbe, William, of Hamsey, 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);