names

29 rows where place_id = 597666

✎ 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
3629394 1904049 1904049 defendant Glover Robert turner 597666 597666 Glover, Robert, of Garveston, turner 0
3639584 1907191 1907191 defendant Hykkys Thomas husbandman 597666 597666 Hykkys, Thomas, of Garveston, husbandman 0
3639585 1907191 1907191 defendant Hykkys John husbandman 597666 597666 Hykkys, John, of Garveston, husbandman 1
3639586 1907191 1907191 defendant Hykkys Richard laborer 597666 597666 Hykkys, Richard, of Garveston, laborer 2
3654866 1911781 1911781 defendant Wyxkys Robert carpenter 597666 597666 Wyxkys, Robert, of Garveston, carpenter 1
3768704 1947859 1947859 defendant Clerke Henry   597666 597666 Clerke, Henry, of Garveston, wheelwright 0
3768706 1947859 1947859 defendant Clerke Richard   597666 597666 Clerke, Richard, of Garveston, wheelwright 2
3768773 1947884 1947884 defendant Barnwell Thomas husbandman 597666 597666 Barnwell, Thomas, of Garveston, husbandman 1
3811738 1961568 1961568 defendant Raven Robert husbandman 597666 597666 Raven, Robert, of Garveston, husbandman 0
3837552 1969654 1969654 defendant Hyx Robert husbandman 597666 597666 Hyx, Robert, of Garveston, husbandman 1
3837556 1969655 1969655 defendant Hyx Robert husbandman 597666 597666 Hyx, Robert, of Garveston, husbandman 1
3887873 1986193 1986193 defendant Ryckys Robert   597666 597666 Ryckys, Robert, of Garveston, wheelwright 2
3903502 1991400 1991400 plaintiff Glover Robert husbandman 597666 597666 Glover, Robert, of Garveston, husbandman 0
3949435 2006875 2006875 defendant Ryxe William   597666 597666 Ryxe, William, of Garveston, wheelwright 1
4015029 2030074 2030074 defendant Webster John husbandman 597666 597666 Webster, John, of Garveston, husbandman 5
4019647 2031754 2031754 defendant Hardy Thomas husbandman 597666 597666 Hardy, Thomas, of Garveston, husbandman 0
4031260 2035852 2035852 defendant Clarke Robert, junior husbandman 597666 597666 Clarke, Robert, junior, of Garveston, husbandman 2
4251029 2113322 2113322 defendant Poynton William cordwainer 597666 597666 Poynton, William, of Garveston, cordwainer 2
4263456 2117441 2117441 defendant Salter John innholder 597666 597666 Salter, John, of Garveston, innholder 1
4278529 2122425 2122425 defendant Chappell Thomas yeoman 597666 597666 Chappell, Thomas, of Garveston, yeoman 1
4309521 2133490 2133490 defendant Pitcher Robert laborer 597666 597666 Pitcher, Robert, of Garveston, laborer 2
5077952 2379887 2379887 defendant Smyth alias Banke Thomas husbandman 597666 597666 Smyth alias Banke, Thomas, of Garveston, husbandman 2
5506864 2507068 2507068 defendant Hikkys Thomas husbandman 597666 597666 Hikkys, Thomas, of Garveston, husbandman 0
5566344 2524749 2524749 defendant Hyxe Thomas husbandman 597666 597666 Hyxe, Thomas, of Garveston, husbandman 2
5568863 2525443 2525443 defendant Wyxe Robert carpenter 597666 597666 Wyxe, Robert, of Garveston, carpenter 0
5568864 2525443 2525443 defendant Fawcett John husbandman 597666 597666 Fawcett, John, of Garveston, husbandman 1
5568865 2525443 2525443 defendant Wryght Richard   597666 597666 Wryght, Richard, of Garveston, wheelwright 2
5584188 2530124 2530124 defendant Randolff John smith 597666 597666 Randolff, John, of Garveston, smith 2
5591950 2532470 2532470 defendant Barker Reginald husbandman 597666 597666 Barker, Reginald, of Garveston, 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);