names

26 rows where place_id = 773441

✎ 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
4600482 2231372 2231372 plaintiff Tille John   773441 773441 Tille, John, of Wermyngton 0
4600483 2231372 2231372 defendant Hawe John   773441 773441 Hawe, John, of Wermyngton 0
4669401 2256138 2256138 plaintiff Bonne William   773441 773441 Bonne, William, of Wermyngton 0
4669402 2256138 2256138 defendant Bocher John husbandman 773441 773441 Bocher, John, of Wermyngton, husbandman 0
4684943 2260885 2260885 defendant Boteler Roger   773441 773441 Boteler, Roger, of Wermyngton, servant 0
4715903 2270287 2270287 defendant Cardmaker Thomas laborer 773441 773441 Cardmaker, Thomas, of Wermyngton, laborer 0
4727861 2273955 2273955 defendant Milnere John husbandman 773441 773441 Milnere, John, of Wermyngton, husbandman 2
4757483 2282718 2282718 defendant Fermour Walter husbandman 773441 773441 Fermour, Walter, of Wermyngton, husbandman 1
4773261 2287607 2287607 defendant Stafford John laborer 773441 773441 Stafford, John, of Wermyngton, laborer 0
4801583 2296678 2296678 defendant Alward William husbandman 773441 773441 Alward, William, of Wermyngton, husbandman 0
4817409 2301532 2301532 plaintiff Milner John   773441 773441 Milner, John, of Wermyngton 0
4838630 2308009 2308009 defendant Philippe William husbandman alias draper 773441 773441 Philippe, William, of Wermyngton, husbandman alias draper 0
4845896 2310226 2310226 defendant Coyff John husbandman 773441 773441 Coyff, John, of Wermyngton, husbandman 3
4845921 2310231 2310231 defendant Philippe William husbandman 773441 773441 Philippe, William, of Wermyngton, husbandman 0
4845927 2310232 2310232 defendant Coyff John husbandman 773441 773441 Coyff, John, of Wermyngton, husbandman 3
4849228 2311233 2311233 defendant Phelyp William draper 773441 773441 Phelyp, William, of Wermyngton, draper 0
4856462 2313402 2313402 defendant Waryn John husbandman 773441 773441 Waryn, John, of Wermyngton, husbandman 0
4883010 2321609 2321609 defendant Efeham John husbandman 773441 773441 Efeham, John, of Wermyngton, husbandman 0
5137269 2397412 2397412 defendant Thelby John husbandman 773441 773441 Thelby, John, of Wermyngton, husbandman 2
5181432 2410311 2410311 plaintiff Caker William   773441 773441 Caker, William, of Wermyngton 0
5212064 2419268 2419268 defendant Caker William   773441 773441 Caker, William, of Wermyngton, franklin 0
5212066 2419269 2419269 defendant Thelby John husbandman 773441 773441 Thelby, John, of Wermyngton, husbandman 0
5212067 2419269 2419269 defendant Thelby Richard   773441 773441 Thelby, Richard, of Wermyngton, husbandman, son of John 1
5212068 2419269 2419269 defendant Milner Walter husbandman 773441 773441 Milner, Walter, of Wermyngton, husbandman 2
5212070 2419269 2419269 defendant Mason Thomas husbandman 773441 773441 Mason, Thomas, of Wermyngton, husbandman 4
5344422 2458435 2458435 defendant Smyth John husbandman 773441 773441 Smyth, John, of Wermyngton, 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);