names

33 rows where place_id = 590050

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599706 1867552 1867552 defendant Sende Robert yeoman 590050 590050 (Sende, Robert, of Trynge, Herts, yeoman 1
3699008 1925900 1925900 defendant Comefeld William shoemaker 590050 590050 Comefeld, William, of Trynge, Herts, shoemaker 1
3699011 1925901 1925901 defendant Domefeld William shoemaker 590050 590050 Domefeld, William, of Trynge, Herts, shoemaker 1
3773047 1949274 1949274 defendant Day William husbandman 590050 590050 Day, William, of Trynge, Herts, husbandman 0
3773049 1949275 1949275 defendant Day William yeoman 590050 590050 Day, William, of Trynge, Herts, yeoman 0
3897750 1989454 1989454 defendant Sayman Richard fisher 590050 590050 Sayman, Richard, of Trynge, Herts, fisher 2
4018677 2031413 2031413 defendant Daye James yeoman 590050 590050 Daye, James, of Trynge, Herts, yeoman 1
4019436 2031684 2031684 defendant Foster Richard gent 590050 590050 Foster, Richard, of Trynge, Herts, gent 0
4062422 2046848 2046848 defendant William James yeoman 590050 590050 William, James, of Trynge, Herts, yeoman 0
4570040 2222202 2222202 defendant Kyng William   590050 590050 Kyng, William, of Trynge, Herts 1
4656038 2247771 2247771 defendant Bourdour John husbandman 590050 590050 Bourdour, John, of Trynge, Herts, husbandman 0
4656042 2247772 2247772 defendant Bourdour John husbandman 590050 590050 Bourdour, John, of Trynge, Herts, husbandman 0
4663909 2250194 2250194 defendant Merston Thomas   590050 590050 Merston, Thomas, of Trynge, Herts 3
4671038 2256610 2256610 defendant Short William draper 590050 590050 Short, William, of Trynge, Herts, draper 1
4678327 2258830 2258830 defendant Short William draper 590050 590050 Short, William, of Trynge, Herts, draper 1
4691381 2262828 2262828 defendant Salwy Thomas   590050 590050 Salwy, Thomas, of Trynge, Herts, king's bailiff 1
4753745 2281545 2281545 defendant Barton Thomas esq 590050 590050 Barton, Thomas, of Trynge, Herts, esq 2
4800768 2296427 2296427 defendant Barton Thomas esq 590050 590050 Barton, Thomas, of Trynge, Herts, esq 0
4892663 2324435 2324435 defendant Milward William shoemaker 590050 590050 Milward, William, of Trynge, Herts, shoemaker 1
4921346 2333187 2333187 defendant Copyrkyn Thomas smith 590050 590050 Copyrkyn, Thomas, of Trynge, Herts, smith 0
4955927 2343738 2343738 defendant Trynge John, junior maltman 590050 590050 Trynge, John, junior, of Trynge, Herts, maltman 3
5039263 2368385 2368385 defendant Sende Thomas husbandman 590050 590050 Sende, Thomas, of Trynge, Herts, husbandman 0
5071070 2377838 2377838 defendant Preest John husbandman 590050 590050 Preest, John, of Trynge, Herts, husbandman 0
5071072 2377839 2377839 defendant Preest John husbandman 590050 590050 Preest, John, of Trynge, Herts, husbandman 0
5112996 2390195 2390195 defendant Sende Thomas yeoman 590050 590050 Sende, Thomas, of Trynge, Herts, yeoman 0
5113001 2390196 2390196 defendant Sonde Thomas yeoman 590050 590050 Sonde, Thomas, of Trynge, Herts, yeoman 0
5218846 2421236 2421236 plaintiff Gybbys William maltman 590050 590050 Gybbys, William, of Trynge, Herts, maltman 0
5238141 2426743 2426743 defendant Sheram John husbandman 590050 590050 Sheram, John, of Trynge, Herts, husbandman 0
5238672 2426906 2426906 defendant Waryn Edmund (legal representative) 590050 590050 Waryn, Edmund, of Trynge, Herts, gent, executors of 3
5238680 2426908 2426908 defendant Waryn Edmund (legal representative) 590050 590050 Waryn, Edmund, of Trynge, Herts, gent, executors of 3
5349508 2459976 2459976 defendant Drynkestone William yeoman 590050 590050 Drynkestone, William, of Trynge, Herts, yeoman 2
5553353 2521020 2521020 defendant Gibbes Thomas maltman 590050 590050 Gibbes, Thomas, of Trynge, Herts, maltman 1
5625171 2551811 2551811 defendant Collys Richard maltman 590050 590050 Collys, Richard, of Trynge, Herts, maltman 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);