names

39 rows where place_id = 610557

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3643159 1908300 1908300 plaintiff Corbold John (legal representative) 610557 610557 Corbold, John, of Wyrlyngworth, executors of 0
3684133 1921173 1921173 defendant Broun Richard thatcher 610557 610557 Broun, Richard, of Wyrlyngworth, thatcher 2
3762144 1945803 1945803 defendant Harvy John husbandman 610557 610557 Harvy, John, of Wyrlyngworth, husbandman 1
4447866 2184259 2184259 plaintiff Fauconer John (legal representative) 610557 610557 Fauconer, John, of Wyrlyngworth, executors of 0
4447869 2184259 2184259 defendant Cheseman Roger   610557 610557 Cheseman, Roger, of Wyrlyngworth 0
4455930 2186870 2186870 defendant Child William le   610557 610557 Child, William le, of Wyrlyngworth 1
4520696 2206822 2206822 plaintiff Clerk Richard   610557 610557 (Clerk, Richard, of Wyrlyngworth, parson 1
4552667 2216788 2216788 plaintiff Clerk Richard   610557 610557 (Clerk, Richard, of Wyrlyngworth 1
4625196 2238848 2238848 plaintiff Page John   610557 610557 Page, John, of Wyrlyngworth 0
4742056 2278174 2278174 defendant Corbald Richard butcher 610557 610557 Corbald, Richard, of Wyrlyngworth, butcher 1
4822628 2303154 2303154 defendant Chetilbere William husbandman 610557 610557 Chetilbere, William, of Wyrlyngworth, husbandman 0
4850731 2311681 2311681 defendant Corbald Robert husbandman 610557 610557 Corbald, Robert, of Wyrlyngworth, husbandman 1
4884061 2321926 2321926 defendant Fydyon John miller 610557 610557 Fydyon, John, of Wyrlyngworth, miller 4
4947482 2341207 2341207 defendant Corbald John butcher 610557 610557 Corbald, John, of Wyrlyngworth, butcher 3
4979871 2350935 2350935 defendant Corbald Robert husbandman 610557 610557 Corbald, Robert, of Wyrlyngworth, husbandman 2
4997419 2356076 2356076 defendant Corbald John, sen husbandman 610557 610557 Corbald, John, sen, of Wyrlyngworth, husbandman 0
5016259 2361644 2361644 defendant Fuller John butcher 610557 610557 Fuller, John, of Wyrlyngworth, butcher 0
5028057 2365084 2365084 defendant Cole John husbandman 610557 610557 Cole, John, of Wyrlyngworth, husbandman 1
5031391 2366037 2366037 defendant Talbot Roger   610557 610557 Talbot, Roger, of Wyrlyngworth, collar maker 0
5077117 2379655 2379655 defendant Hervy John, junior yeoman 610557 610557 Hervy, John, junior, of Wyrlyngworth, yeoman 0
5077118 2379655 2379655 defendant Corbald Rihcard yeoman 610557 610557 Corbald, Rihcard, of Wyrlyngworth, yeoman 1
5138619 2397790 2397790 defendant Maushope John yeoman 610557 610557 Maushope, John, of Wyrlyngworth, yeoman 3
5138620 2397790 2397790 defendant another senior husbandman 610557 610557 another, senior, of Wyrlyngworth, husbandman 4
5152485 2401863 2401863 defendant Magges John husbandman 610557 610557 Magges, John, of Wyrlyngworth, husbandman 0
5159379 2403858 2403858 defendant Manschepe John yeoman 610557 610557 Manschepe, John, of Wyrlyngworth, yeoman 3
5159380 2403858 2403858 defendant Maggys John, sen husbandman 610557 610557 Maggys, John, sen, of Wyrlyngworth, husbandman 4
5174538 2408254 2408254 defendant Manschepe John yeoman 610557 610557 Manschepe, John, of Wyrlyngworth, yeoman 2
5174540 2408254 2408254 defendant Maggys John husbandman 610557 610557 Maggys, John, of Wyrlyngworth, husbandman 4
5187748 2412134 2412134 defendant Magges John husbandman 610557 610557 Magges, John, of Wyrlyngworth, husbandman 0
5251498 2430571 2430571 defendant Corbold Richard butcher 610557 610557 Corbold, Richard, of Wyrlyngworth, butcher 0
5263939 2434481 2434481 defendant Corbald Richard butcher 610557 610557 Corbald, Richard, of Wyrlyngworth, butcher 0
5359329 2462954 2462954 defendant Corbald Robert butcher 610557 610557 Corbald, Robert, of Wyrlyngworth, butcher 1
5386468 2471202 2471202 defendant Corbold Richard butcher 610557 610557 Corbold, Richard, of Wyrlyngworth, butcher 0
5398758 2474711 2474711 defendant Corbold Richard butcher 610557 610557 Corbold, Richard, of Wyrlyngworth, butcher 0
5398763 2474712 2474712 defendant Corbold Richard butcher 610557 610557 Corbold, Richard, of Wyrlyngworth, butcher 0
5411869 2478503 2478503 defendant Corbold Richard butcher 610557 610557 Corbold, Richard, of Wyrlyngworth, butcher 0
5420180 2480954 2480954 defendant Corbold Richard butcher 610557 610557 Corbold, Richard, of Wyrlyngworth, butcher 0
5508073 2507418 2507418 defendant Corbald John husbandman 610557 610557 Corbald, John, of Wyrlyngworth, husbandman 0
5565623 2524537 2524537 defendant Corbold Peter butcher 610557 610557 Corbold, Peter, of Wyrlyngworth, butcher 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);