names

24 rows where place_id = 588736

✎ 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
3595413 1866199 1866199 defendant Edward Richard laboer 588736 588736 Edward, Richard, of Playden, laboer 1
3734193 1936935 1936935 defendant Sandys George   588736 588736 Sandys, George, of Playden, minstrel 0
3734194 1936935 1936935 defendant Aleyn Richard laborer 588736 588736 Aleyn, Richard, of Playden, laborer 1
3805892 1959784 1959784 defendant Standen Thomas husbandman 588736 588736 Standen, Thomas, of Playden, husbandman 0
3805894 1959784 1959784 defendant Fryer Robert yeoman 588736 588736 Fryer, Robert, of Playden, yeoman 2
3823546 1965266 1965266 defendant Standen Thomas husbandman 588736 588736 Standen, Thomas, of Playden, husbandman 0
4059537 2045804 2045804 defendant Willes John   588736 588736 Willes, John, of Playden yeoman 0
4127802 2070232 2070232 defendant Carpenter John husbandman 588736 588736 Carpenter, John, of Playden, husbandman 2
4230238 2106064 2106064 defendant Dandye John yeoman 588736 588736 Dandye, John, of Playden, yeoman 0
4310522 2133833 2133833 defendant Sote John husbandman 588736 588736 Sote, John, of Playden, husbandman 0
4314830 2135300 2135300 defendant Sherley Stephen   588736 588736 Sherley, Stephen, of Playden, "typler" or alehouse keeper 0
4358934 2150361 2150361 defendant Mylles William husbandman 588736 588736 Mylles, William, of Playden, husbandman 6
4372413 2155200 2155200 defendant Rolfe Stephen miller 588736 588736 Rolfe, Stephen, of Playden, miller 0
4375052 2156138 2156138 defendant Mawle William tanner 588736 588736 Mawle, William, of Playden, tanner 0
4505294 2202186 2202186 plaintiff Smyth William   588736 588736 Smyth, William, of Playden 0
4634423 2241614 2241614 defendant Gold William   588736 588736 Gold, William, of Playden 0
4697617 2264743 2264743 plaintiff Colnet Nicholas master of St Bartholomew's hospital 588736 588736 Colnet, Nicholas, of Playden, master of St Bartholomew's hospital 0
4914428 2331029 2331029 defendant Gerveys Thomas husbandman 588736 588736 Gerveys, Thomas, of Playden, husbandman 1
5069057 2377243 2377243 defendant Potyn James fisher 588736 588736 Potyn, James, of Playden, fisher 0
5117949 2391676 2391676 defendant Grene Lawrencia widow 588736 588736 Grene, Lawrencia, of Playden, widow 0
5151395 2401557 2401557 defendant Adam Stephen fishmonger 588736 588736 Adam, Stephen, of Playden, fishmonger 1
5169549 2406830 2406830 defendant Adam Stephen fishmonger 588736 588736 Adam, Stephen, of Playden, fishmonger 1
5341270 2457460 2457460 defendant Hewys Simon husbandman 588736 588736 Hewys, Simon, of Playden, husbandman 4
5377678 2468600 2468600 defendant Curle John husbandman 588736 588736 Curle, John, of Playden, husbandman 1

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