names

30 rows where place_id = 608030

✎ 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
3671895 1917206 1917206 defendant Blount Thomas merchant 608030 608030 Blount, Thomas, of Porchester, merchant 2
3777987 1950826 1950826 defendant Blount John husbandman 608030 608030 Blount, John, of Porchester, husbandman 3
4187936 2091281 2091281 defendant Henslowe Elizabeth widow 608030 608030 Henslowe, Elizabeth, of Porchester, widow 0
4187937 2091281 2091281 defendant Henslowe Ralph yeoman 608030 608030 Henslowe, Ralph, of Porchester, yeoman 1
4211384 2099535 2099535 defendant Henslowe Elizabeth widow 608030 608030 Henslowe, Elizabeth, of Porchester, widow 0
4211385 2099535 2099535 defendant Henslowe Ralph yeoman 608030 608030 Henslowe, Ralph, of Porchester, yeoman 1
4223104 2103569 2103569 defendant Virgo Samuel gent 608030 608030 Virgo, Samuel, of Porchester, gent 0
4322926 2138083 2138083 defendant Virgo Samuel gent 608030 608030 Virgo, Samuel, of Porchester, gent 0
4367782 2153530 2153530 defendant Davys Richard yeoman 608030 608030 Davys, Richard, of Porchester, yeoman 0
4475895 2193134 2193134 defendant Wrouth John   608030 608030 Wrouth, John, of Porchester 0
4577774 2224556 2224556 defendant Glasyere William   608030 608030 Glasyere, William, of Porchester 0
4597533 2230473 2230473 defendant Mayr Robert   608030 608030 Mayr, Robert, of Porchester 3
4703997 2266628 2266628 defendant Calcard John   608030 608030 Calcard, John, of Porchester, minstrel 4
4836014 2307245 2307245 defendant Herry William gent 608030 608030 Herry, William, of Porchester, gent 0
4836100 2307270 2307270 defendant Harryes William yeoman 608030 608030 Harryes, William, of Porchester, yeoman 0
4840053 2308438 2308438 defendant Saunder William merchant 608030 608030 Saunder, William, of Porchester, merchant 0
4850353 2311566 2311566 defendant Jolyf Richard sawyer 608030 608030 Jolyf, Richard, of Porchester, sawyer 0
5006667 2358848 2358848 plaintiff Shirwyn John (legal representative) 608030 608030 Shirwyn, John, of Porchester, formerly constable of the castle, executors of 0
5089508 2383304 2383304 defendant Taillour Thomas husbandman 608030 608030 Taillour, Thomas, of Porchester, husbandman 0
5089509 2383304 2383304 defendant Taillour John husbandman 608030 608030 Taillour, John, of Porchester, husbandman 1
5299213 2444748 2444748 defendant Carpenter John carpenter 608030 608030 Carpenter, John, of Porchester, carpenter 2
5299220 2444749 2444749 defendant Carpenter John carpenter 608030 608030 together with Carpenter, John, of Porchester, carpenter 2
5307936 2447390 2447390 plaintiff Raunvyle Richard   608030 608030 Raunvyle, Richard, of Porchester, son of John 1
5324517 2452419 2452419 plaintiff Rannule John (legal representative) 608030 608030 Rannule, John, of Porchester, executor of 0
5476394 2497942 2497942 defendant Martyn William husbandman 608030 608030 Martyn, William, of Porchester, husbandman 0
5476395 2497942 2497942 defendant Cokke Thomas husbandman 608030 608030 Cokke, Thomas, of Porchester, husbandman 1
5546672 2519027 2519027 defendant Whytyng William husbandman 608030 608030 Whytyng, William, of Porchester, husbandman 1
5546673 2519027 2519027 defendant Plommer John husbandman 608030 608030 Plommer, John, of Porchester, husbandman 2
5546674 2519027 2519027 defendant Blount John husbandman 608030 608030 Blount, John, of Porchester, husbandman 3
5601269 2535287 2535287 defendant Rawlyns Robert yeoman 608030 608030 Rawlyns, Robert, of Porchester, yeoman 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);