names

31 rows where place_id = 590772

✎ 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
3602283 1868379 1868379 defendant Trokmerton Christopher esq 590772 590772 Trokmerton, Christopher, of Trynley, esq 0
3615228 1872410 1872410 defendant Porter John chaplain 590772 590772 Porter, John, of Trynley, chaplain 0
3642568 1908118 1908118 defendant Throkmarton Mary widow 590772 590772 Throkmarton, Mary, of Trynley, widow 0
3817482 1963380 1963380 defendant Kent Thomas cooper 590772 590772 Kent, Thomas, of Trynley, cooper 1
3817484 1963380 1963380 defendant Horne Roger mariner 590772 590772 Horne, Roger, of Trynley, mariner 3
3961889 2011253 2011253 defendant Dowsyng John fletcher 590772 590772 Dowsyng, John, of Trynley, fletcher 0
3961890 2011253 2011253 defendant Dowsyng Hugh husbandman 590772 590772 Dowsyng, Hugh, of Trynley, husbandman 1
3961891 2011253 2011253 defendant Dowsyng William husbandman 590772 590772 Dowsyng, William, of Trynley, husbandman 2
3961892 2011253 2011253 defendant Doswyng Joan widow 590772 590772 Doswyng, Joan, of Trynley, widow 3
4107852 2063085 2063085 defendant Brydges Christopher husbandman 590772 590772 Brydges, Christopher, of Trynley, husbandman 0
4466661 2190249 2190249 plaintiff Bernarde Thomas, junior   590772 590772 Bernarde, Thomas, junior, of Trynley 1
4584946 2226723 2226723 defendant Rose Henry   590772 590772 Rose, Henry, of Trynley, vicar 1
4743878 2278738 2278738 defendant White John, senior husbandman 590772 590772 White, John, senior, of Trynley, husbandman 0
4802450 2296957 2296957 defendant Smyth John yeoman 590772 590772 Smyth, John, of Trynley, yeoman 2
4816603 2301284 2301284 defendant Huyes Thomas   590772 590772 Huyes, Thomas, of Trynley, vicar 0
4856572 2313439 2313439 defendant Lane Richard husbandman 590772 590772 Lane, Richard, of Trynley, husbandman 0
4861037 2314811 2314811 defendant Gryffyn Richard butcher 590772 590772 Gryffyn, Richard, of Trynley, butcher 0
4875029 2319138 2319138 defendant Whelames Thomas husbandman 590772 590772 Whelames, Thomas, of Trynley, husbandman 0
4893948 2324807 2324807 defendant Kent Richard husbandman 590772 590772 Kent, Richard, of Trynley, husbandman 0
4896607 2325601 2325601 defendant Forster Roger husbandman 590772 590772 (Forster, Roger, of Trynley, husbandman 4
4896608 2325601 2325601 defendant White John husbandman 590772 590772 White, John, of Trynley, husbandman 5
4906735 2328691 2328691 defendant Forster Roger husbandman 590772 590772 (Forster, Roger, of Trynley, husbandman 4
4906736 2328691 2328691 defendant White John husbandman 590772 590772 White, John, of Trynley, husbandman 5
4945058 2340436 2340436 defendant Kent Richard husbandman 590772 590772 Kent, Richard, of Trynley, husbandman 0
4998953 2356567 2356567 defendant Barnard John husbandman 590772 590772 Barnard, John, of Trynley, husbandman 0
4998954 2356567 2356567 defendant Kent Richard husbandman 590772 590772 Kent, Richard, of Trynley, husbandman 1
5003532 2357927 2357927 defendant Rogers Thomas husbandman 590772 590772 Rogers, Thomas, of Trynley, husbandman 0
5003534 2357928 2357928 defendant Rogers Thomas husbandman 590772 590772 Rogers, Thomas, of Trynley, husbandman 0
5340724 2457299 2457299 defendant Baker Richard husbandman 590772 590772 Baker, Richard, of Trynley, husbandman 0
5340725 2457299 2457299 defendant Byrche Thomas husbandman 590772 590772 Byrche, Thomas, of Trynley, husbandman 1
5340726 2457299 2457299 defendant Wytheford Richard laborer 590772 590772 Wytheford, Richard, of Trynley, laborer 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);