names

16 rows where place_id = 606902

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3666922 1915598 1915598 defendant Colyer Henry weaver 606902 606902 Colyer, Henry, of Stapelherst, weaver 1
4145321 2076524 2076524 defendant Slayne William butcher 606902 606902 Slayne, William, of Stapelherst, butcher 2
4571571 2222687 2222687 defendant Cherche John   606902 606902 Cherche, John, of Stapelherst 0
4619526 2237097 2237097 defendant Eaxherst Richard   606902 606902 Eaxherst, Richard, of Stapelherst 0
4660545 2249123 2249123 defendant atte Frythe Thomas farmer 606902 606902 atte Frythe, Thomas, of Stapelherst, farmer 0
4721847 2272165 2272165 plaintiff Chirche John   606902 606902 Chirche, John, of Stapelherst 0
4730780 2274829 2274829 defendant Chirche John gent 606902 606902 Chirche, John, of Stapelherst, gent 0
4782859 2290657 2290657 defendant Robard John butcher 606902 606902 Robard, John, of Stapelherst, butcher 3
4874918 2319099 2319099 defendant Person William husbandman 606902 606902 Person, William, of Stapelherst, husbandman 0
5223716 2422621 2422621 defendant Forde John, junior tailor 606902 606902 Forde, John, junior, of Stapelherst, tailor 4
5355907 2461924 2461924 defendant Borell William dyer 606902 606902 Borell, William, of Stapelherst, dyer 2
5364447 2464543 2464543 defendant Dorell William   606902 606902 Dorell, William, of Stapelherst, cloth maker 0
5376873 2468361 2468361 defendant Hopper Richard husbandman 606902 606902 Hopper, Richard, of Stapelherst, husbandman 0
5433696 2485041 2485041 defendant Goldham John husbandman 606902 606902 Goldham, John, of Stapelherst, husbandman 0
5525864 2512680 2512680 defendant William John husbandman 606902 606902 William, John, of Stapelherst, husbandman 3
5620086 2550143 2550143 defendant Streteman William   606902 606902 Streteman, William, of Stapelherst 0

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