names

15 rows where case_id = 2463003

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5359490 2463003 2463003 plaintiff Rees William     Rees, William 0
5359491 2463003 2463003 defendant Brelours John husbandman 613374 613374 Brelours, John, of Shoteswell, husbandman 0
5359492 2463003 2463003 defendant Strutte William husbandman 613374 613374 Strutte, William, of Shoteswell, husbandman 1
5359493 2463003 2463003 defendant Grene Thomas husbandman 613374 613374 Grene, Thomas, of Shoteswell, husbandman 2
5359494 2463003 2463003 defendant Bysshop John husbandman 613374 613374 Bysshop, John, of Shoteswell, husbandman 3
5359495 2463003 2463003 defendant Willyngham Humphrey esq 613843 613843 Willyngham, Humphrey, of Molyngton, esq 4
5359496 2463003 2463003 defendant Halse Robert gent 613843 613843 Halse, Robert, of Molyngton, gent 5
5359497 2463003 2463003 defendant Hogegys John husbandman 613843 613843 Hogegys, John, of Molyngton, husbandman 6
5359498 2463003 2463003 defendant Hogeges Henry husbandman 613843 613843 Hogeges, Henry, of Molyngton, husbandman 7
5359499 2463003 2463003 defendant Wever Ralph yeoman 613843 613843 Wever, Ralph, of Molyngton, yeoman 8
5359500 2463003 2463003 defendant Notynggale Thomas yeoman 613843 613843 Notynggale, Thomas, of Molyngton, yeoman 9
5359501 2463003 2463003 defendant Hill Robert husbandman 613843 613843 Hill, Robert, of Molyngton, husbandman 10
5359502 2463003 2463003 defendant Stanley Thomas yeoman 613843 613843 Stanley, Thomas, of Molyngton, yeoman 11
5359503 2463003 2463003 defendant Bolton John yeoman 613843 613843 Bolton, John, of Molyngton, yeoman 12
5359504 2463003 2463003 defendant Barbour Thomas laborer 613843 613843 Barbour, Thomas, of Molyngton, laborer 13

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