names

32 rows where place_id = 778906

✎ 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
4657431 2248216 2248216 defendant Spryng John tanner 778906 778906 Spryng, John, of Axebrygge, tanner 0
4657432 2248216 2248216 defendant Yevan John tanner 778906 778906 Yevan, John, of Axebrygge, tanner 1
4657433 2248216 2248216 defendant Hayne Thomas tanner 778906 778906 Hayne, Thomas, of Axebrygge, tanner 2
4671938 2256869 2256869 defendant Nyweman Robert t-omer or tanner 778906 778906 Nyweman, Robert, of Axebrygge, t-omer or tanner 0
4676413 2258233 2258233 defendant Payn William tanner 778906 778906 Payn, William, of Axebrygge, tanner 1
4795878 2294862 2294862 defendant Waleys John husbandman 778906 778906 Waleys, John, of Axebrygge, husbandman 0
4795879 2294862 2294862 defendant Wodeward Roger husbandman 778906 778906 Wodeward, Roger, of Axebrygge, husbandman 1
4795880 2294862 2294862 defendant Tremell Philip husbandman 778906 778906 Tremell, Philip, of Axebrygge, husbandman 2
4806697 2298303 2298303 defendant Kyne or Lyne Nicholas shoemaker 778906 778906 Kyne or Lyne, Nicholas, of Axebrygge, shoemaker 1
4806698 2298303 2298303 defendant Aleyn John shoemaker 778906 778906 Aleyn, John, of Axebrygge, shoemaker 2
4806821 2298344 2298344 defendant Hilpe Richard tanner 778906 778906 Hilpe, Richard, of Axebrygge, tanner 1
4824170 2303634 2303634 defendant Kyngdon John shoemaker 778906 778906 Kyngdon, John, of Axebrygge, shoemaker 1
4898170 2326088 2326088 defendant Markedey John currier 778906 778906 Markedey, John, of Axebrygge, currier 0
4898171 2326088 2326088 defendant Markedey Richard currier 778906 778906 Markedey, Richard, of Axebrygge, currier 1
4910390 2329766 2329766 defendant Carmarthn John mercer 778906 778906 Carmarthn, John, of Axebrygge, mercer 2
4910391 2329766 2329766 defendant Apryce William merchant 778906 778906 Apryce, William, of Axebrygge, merchant 3
5030197 2365701 2365701 defendant Wygmore John dyer 778906 778906 Wygmore, John, of Axebrygge, dyer 0
5088746 2383084 2383084 defendant Payn John merchant 778906 778906 Payn, John, of Axebrygge, merchant 0
5088747 2383084 2383084 defendant Payn Thomas tanner 778906 778906 Payn, Thomas, of Axebrygge, tanner 1
5138250 2397697 2397697 defendant Heyne John fuller 778906 778906 Heyne, John, of Axebrygge, fuller 0
5155890 2402885 2402885 defendant Roynon John gent 778906 778906 Roynon, John, of Axebrygge, gent 0
5159042 2403760 2403760 defendant Heyne John fuller 778906 778906 Heyne, John, of Axebrygge, fuller 0
5172585 2407707 2407707 defendant Roynon John gent 778906 778906 Roynon, John, of Axebrygge, gent 0
5217652 2420895 2420895 defendant Harper William tucker 778906 778906 Harper, William, of Axebrygge, tucker 0
5225229 2423053 2423053 defendant Ferrour or Smith John smith 778906 778906 Ferrour or Smith, John, of Axebrygge, smith 4
5250316 2430207 2430207 defendant Sadeler William weaver 778906 778906 Sadeler, William, of Axebrygge, weaver 0
5250317 2430207 2430207 defendant Donne William tucker 778906 778906 Donne, William, of Axebrygge, tucker 1
5258400 2432742 2432742 defendant Rayman Henry tucker 778906 778906 Rayman, Henry, of Axebrygge, tucker 0
5259044 2432944 2432944 defendant Phelypys John draper 778906 778906 Phelypys, John, of Axebrygge, draper 0
5286240 2440985 2440985 defendant Phelpys John draper 778906 778906 Phelpys, John, of Axebrygge, draper 0
5497763 2504274 2504274 defendant Doget John chapman 778906 778906 Doget, John, of Axebrygge, chapman 0
5497765 2504275 2504275 defendant Doget John chapman 778906 778906 Doget, John, of Axebrygge, chapman 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);