names

30 rows where place_id = 755600

✎ 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
4429586 2174045 2174045 defendant Cardok Richard   755600 755600 Cardok, Richard, of Bubwyth 0
4429588 2174045 2174045 defendant Conyngwyth Thomas de   755600 755600 Conyngwyth, Thomas de, of Bubwyth 2
4454535 2186435 2186435 defendant Saunderson William   755600 755600 (Saunderson, William, of Bubwyth, vicar 3
4464114 2189445 2189445 defendant Clerk Roger   755600 755600 Clerk, Roger, of Bubwyth 0
4596816 2230239 2230239 defendant Penson John   755600 755600 Penson, John, of Bubwyth 1
4708195 2267942 2267942 defendant Gewe William laborer 755600 755600 Gewe, William, of Bubwyth, laborer 0
4708196 2267942 2267942 defendant (illegible) Richard husbandman 755600 755600 _, Richard, of Bubwyth, husbandman 1
4708197 2267942 2267942 defendant Raby John husbandman 755600 755600 Raby, John, of Bubwyth, husbandman 2
4751621 2280962 2280962 defendant Brewehous John husbandman 755600 755600 Brewehous, John, of Bubwyth, husbandman 0
4768024 2285966 2285966 defendant Marton Richard   755600 755600 Marton, Richard, of Bubwyth, vicar 0
4795793 2294833 2294833 defendant Richardesson Robert husbandman 755600 755600 Richardesson, Robert, of Bubwyth, husbandman 0
4816924 2301394 2301394 defendant Proctour John yeoman 755600 755600 Proctour, John, of Bubwyth, yeoman 3
4866201 2316400 2316400 defendant Adamson Thomas husbandman 755600 755600 Adamson, Thomas, of Bubwyth, husbandman 0
4866202 2316400 2316400 defendant Lokwod John, junior   755600 755600 Lokwod, John, junior, of Bubwyth, servant 1
4875588 2319322 2319322 defendant Walker John walker 755600 755600 Walker, John, of Bubwyth, walker 2
4882687 2321498 2321498 defendant Gunby John husbandman 755600 755600 Gunby, John, of Bubwyth, husbandman 4
4885672 2322392 2322392 defendant Raby Thomas husbandman 755600 755600 Raby, Thomas, of Bubwyth, husbandman 1
4895857 2325374 2325374 defendant Lide William husbandman 755600 755600 Lide, William, of Bubwyth, husbandman 7
4903185 2327605 2327605 defendant Gunby Richard gent 755600 755600 Gunby, Richard, of Bubwyth, gent 2
4967631 2347259 2347259 defendant Gunby Richard gent 755600 755600 Gunby, Richard, of Bubwyth, gent 1
5101171 2386754 2386754 defendant Walker John   755600 755600 Walker, John, of Bubwyth, "flesshewer" or butcher 1
5101186 2386755 2386755 defendant Walker John   755600 755600 Walker, John, of Bubwyth, "flesshewer" or butcher 6
5101191 2386757 2386757 defendant Walker John   755600 755600 Walker, John, of Bubwyth, "flesshewer" or butcher 0
5120348 2392379 2392379 defendant Wright Roger   755600 755600 Wright, Roger, of Bubwyth, wright 0
5242099 2427889 2427889 defendant White John husbandman 755600 755600 White, John, of Bubwyth, husbandman 2
5290910 2442345 2442345 defendant Waller John butcher 755600 755600 Waller, John, of Bubwyth, butcher 0
5322892 2451926 2451926 defendant Walker Thomas walker 755600 755600 Walker, Thomas, of Bubwyth, walker 3
5322893 2451926 2451926 defendant Hewethorp Thomas dyer 755600 755600 Hewethorp, Thomas, of Bubwyth, dyer 4
5330809 2454286 2454286 defendant Hardwyk Henry yeoman 755600 755600 Hardwyk, Henry, of Bubwyth, yeoman 0
5330811 2454287 2454287 defendant Hardwyk Henry yeoman 755600 755600 Hardwyk, Henry, of Bubwyth, yeoman 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);