names

25 rows where place_id = 613767

✎ 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
3700180 1926288 1926288 defendant Thomas William husbandman 613767 613767 Thomas, William, of Assheburnham, husbandman 0
3700181 1926288 1926288 defendant Bulmer James tailor 613767 613767 Bulmer, James, of Assheburnham, tailor 1
3770211 1948350 1948350 defendant Assheburnham William esq 613767 613767 Assheburnham, William, of Assheburnham, esq 0
3780734 1951709 1951709 defendant Stokke William husbandman 613767 613767 Stokke, William, of Assheburnham, husbandman 0
3787926 1954016 1954016 defendant Assheburnham William esq 613767 613767 Assheburnham, William, of Assheburnham, esq 0
3789851 1954653 1954653 defendant Assheburnham William esq 613767 613767 Assheburnham, William, of Assheburnham, esq 0
3823609 1965282 1965282 defendant Assheburnham William esq 613767 613767 Assheburnham, William, of Assheburnham, esq 0
3824614 1965573 1965573 defendant Wylson John yeoman 613767 613767 Wylson, John, of Assheburnham, yeoman 0
3907933 1992943 1992943 defendant Tyseherst Thomas husbandman 613767 613767 Tyseherst, Thomas, of Assheburnham, husbandman 3
3907934 1992943 1992943 defendant Tyseherst William husbandman 613767 613767 Tyseherst, William, of Assheburnham, husbandman 4
4173995 2086360 2086360 defendant Cooper William yeoman 613767 613767 Cooper, William, of Assheburnham, yeoman 0
4183530 2089721 2089721 defendant Baker Robert yeoman 613767 613767 Baker, Robert, of Assheburnham, or of Brightlinge, yeoman 1
4635968 2242084 2242084 defendant Wilsham John   613767 613767 Wilsham, John, of Assheburnham 3
4769650 2286484 2286484 defendant Rabet John   613767 613767 Rabet, John, of Assheburnham, arrow maker 3
4794147 2294305 2294305 defendant Rabet John fletcher 613767 613767 Rabet, John, of Assheburnham, fletcher 3
4908582 2329240 2329240 defendant Wodesell Roger butcher 613767 613767 Wodesell, Roger, of Assheburnham, butcher 1
4952002 2342570 2342570 defendant Ponte John   613767 613767 Ponte, John, of Assheburnham, "hogheler" 0
5070761 2377755 2377755 defendant Tysehert Richard husbandman 613767 613767 Tysehert, Richard, of Assheburnham, husbandman 0
5102271 2387082 2387082 defendant Brekynden John, junior husbandman 613767 613767 Brekynden, John, junior, of Assheburnham, husbandman 4
5229933 2424372 2424372 defendant Tyseherst John laborer 613767 613767 Tyseherst, John, of Assheburnham, laborer 3
5297788 2444360 2444360 defendant Tyseherst John husbandman 613767 613767 Tyseherst, John, of Assheburnham, husbandman 0
5317420 2450293 2450293 defendant Bates John gent 613767 613767 Bates, John, of Assheburnham, gent 0
5598299 2534357 2534357 defendant Assheburnham William esq 613767 613767 Assheburnham, William, of Assheburnham, esq 0
5630379 2553509 2553509 defendant Watte Alan yeoman 613767 613767 Watte, Alan, of Assheburnham, yeoman 1
5630380 2553509 2553509 defendant Martyn John husbandman 613767 613767 Martyn, John, of Assheburnham, husbandman 2

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