names

31 rows where place_id = 592695

✎ 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
3608537 1870328 1870328 defendant Roper John husbandman 592695 592695 Roper, John, of Bishops Lydeard, husbandman 1
3611891 1871379 1871379 defendant Seman Thomas husbandman 592695 592695 Seman, Thomas, of Bishops Lydeard, husbandman 2
3650623 1910559 1910559 defendant Credyll Robert husbandman 592695 592695 Credyll, Robert, of Bishops Lydeard, husbandman 0
4069732 2049459 2049459 defendant Shobroke William husbandman 592695 592695 Shobroke, William, of Bishops Lydeard, husbandman 0
4168497 2084467 2084467 defendant Parsons Edward yeoman 592695 592695 Parsons, Edward, of Bishops Lydeard, yeoman 2
4180901 2088798 2088798 defendant Middelton John husbandman 592695 592695 Middelton, John, of Bishops Lydeard, husbandman 0
4861452 2314953 2314953 defendant Kyngeston Thomas gent 592695 592695 Kyngeston, Thomas, of Bishops Lydeard, gent 0
4861453 2314953 2314953 defendant Kyngeston Richard yeoman 592695 592695 Kyngeston, Richard, of Bishops Lydeard, yeoman 1
4865079 2316053 2316053 defendant Edward John shoemaker 592695 592695 Edward, John, of Bishops Lydeard, shoemaker 3
4868094 2316994 2316994 defendant Kyngeston Thomas gent 592695 592695 Kyngeston, Thomas, of Bishops Lydeard, gent 0
4868095 2316994 2316994 defendant Kyngeston Richard yeoman 592695 592695 Kyngeston, Richard, of Bishops Lydeard, yeoman 1
4871789 2318147 2318147 defendant Sparke Richard husbandman 592695 592695 Sparke, Richard, of Bishops Lydeard, husbandman 0
4918818 2332397 2332397 defendant Kyngeston Thomas gent 592695 592695 Kyngeston, Thomas, of Bishops Lydeard, gent 0
4964315 2346239 2346239 defendant Edward John cordwainer 592695 592695 Edward, John, of Bishops Lydeard, cordwainer 3
5280503 2439374 2439374 defendant Fermere John husbandman 592695 592695 Fermere, John, of Bishops Lydeard, husbandman 1
5280506 2439375 2439375 defendant Fermere John husbandman 592695 592695 Fermere, John, of Bishops Lydeard, husbandman 1
5285805 2440874 2440874 defendant Mymmes John laborer 592695 592695 Mymmes, John, of Bishops Lydeard, laborer 0
5285806 2440874 2440874 defendant Nasshyn John, senior husbandman 592695 592695 Nasshyn, John, senior, of Bishops Lydeard, husbandman 1
5285807 2440874 2440874 defendant Nasshyn John, senior laborer 592695 592695 Nasshyn, John, senior, of Bishops Lydeard, laborer 2
5285808 2440874 2440874 defendant Nasshyn John, junior laborer 592695 592695 Nasshyn, John, junior, of Bishops Lydeard, laborer 3
5285809 2440874 2440874 defendant Nasshyn Nicholas laborer 592695 592695 Nasshyn, Nicholas, of Bishops Lydeard, laborer 4
5324408 2452386 2452386 defendant Stanlynch Richard (legal representative) 592695 592695 Stanlynch, Richard, of Bishops Lydeard, gent, executors of 0
5493282 2502899 2502899 defendant Brygge Thomas husbandman 592695 592695 Brygge, Thomas, of Bishops Lydeard, husbandman 0
5517396 2510282 2510282 defendant Wydlake John husbandman 592695 592695 Wydlake, John, of Bishops Lydeard, husbandman 0
5517397 2510282 2510282 defendant Wydlake John   592695 592695 Wydlake, John, of Bishops Lydeard, groom 1
5532206 2514619 2514619 defendant Algar John clerk 592695 592695 Algar, John, of Bishops Lydeard, clerk 0
5532207 2514619 2514619 defendant Barton Walter laborer 592695 592695 Barton, Walter, of Bishops Lydeard, laborer 1
5570396 2525910 2525910 defendant Nasshen Thomas husbandman 592695 592695 Nasshen, Thomas, of Bishops Lydeard, husbandman 0
5573843 2526917 2526917 defendant Nasshyn Thomas husbandman 592695 592695 Nasshyn, Thomas, of Bishops Lydeard, husbandman 0
5585252 2530452 2530452 defendant Nasshen Thomas husbandman 592695 592695 Nasshen, Thomas, of Bishops Lydeard, husbandman 0
5596866 2533939 2533939 defendant Yarde Richard butcher 592695 592695 Yarde, Richard, of Bishops Lydeard, butcher 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);