names

20 rows where place_id = 586359

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588521 1864054 1864054 defendant Bevys William mercer 586359 586359 Bevys, William, of Warwyk, mercer 2
3749369 1941722 1941722 defendant Walker Richard husbandman 586359 586359 Walker, Richard, of Warwyk, husbandman 3
3754541 1943377 1943377 defendant Page Nicholas butcher 586359 586359 Page, Nicholas, of Warwyk, butcher 0
3786383 1953527 1953527 defendant Corpson Robert   586359 586359 Corpson, Robert, of Warwyk, yeoman, or of Dawnsers Ende, Buklond 0
3786385 1953528 1953528 defendant Corpson Robert   586359 586359 Corpson, Robert, of Warwyk, yeoman, or of Dawnsers Ende, Buklond 0
3806948 1960079 1960079 defendant Underhyll William gent 586359 586359 Underhyll, William, of Warwyk, gent 9
3883454 1984737 1984737 defendant Byssell Robert cordwainer 586359 586359 Byssell, Robert, of Warwyk, cordwainer 1
3883457 1984738 1984738 defendant Byssell Robert cordwainer 586359 586359 Byssell, Robert, of Warwyk, cordwainer 1
4635501 2241964 2241964 defendant Bernewell Thomas chapman 586359 586359 Bernewell, Thomas, of Warwyk, chapman 0
4636992 2242375 2242375 defendant Beveton John   586359 586359 Beveton, John, of Warwyk 0
4676623 2258306 2258306 defendant del Spence John yeoman 586359 586359 del Spence, John, of Warwyk, yeoman 2
4719333 2271390 2271390 defendant Sklater William yeoman 586359 586359 Sklater, William, of Warwyk, yeoman 1
4946724 2340977 2340977 defendant Warwyk John esq 586359 586359 Warwyk, John, of Warwyk, Cumber, esq 1
4946725 2340977 2340977 defendant Richardson John yeoman 586359 586359 Richardson, John, of Warwyk, yeoman 2
5045566 2370304 2370304 defendant Fissher John fuller 586359 586359 Fissher, John, of Warwyk, fuller 0
5211922 2419225 2419225 defendant Grete Richard yeoman 586359 586359 Grete, Richard, of Warwyk, yeoman 0
5230236 2424462 2424462 defendant Mayll John draper 586359 586359 Mayll, John, of Warwyk, draper 4
5391696 2472698 2472698 defendant Smyth John barber 586359 586359 Smyth, John, of Warwyk, barber 0
5552177 2520680 2520680 defendant Wode Thomas laborer 586359 586359 Wode, Thomas, of Warwyk, laborer 1
5634667 2554838 2554838 defendant Talkan Walter yeoman 586359 586359 Talkan, Walter, of Warwyk, yeoman 6

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