names

25 rows where place_id = 597925

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3630387 1904340 1904340 defendant Fulwell Stephen husbandman 597925 597925 Fulwell, Stephen, of Magna Lynton, husbandman 0
3759165 1944855 1944855 defendant Hokley John butcher 597925 597925 Hokley, John, of Magna Lynton, butcher 0
3812858 1961919 1961919 defendant Amy Roger weaver 597925 597925 Amy, Roger, of Magna Lynton, weaver 2
3846348 1972411 1972411 defendant Selyff or Sebyff Robert carpenter 597925 597925 Selyff or Sebyff, Robert, of Magna Lynton, carpenter 0
4123326 2068644 2068644 defendant Hockley Milicent butcher 597925 597925 Hockley, Milicent, of Magna Lynton, butcher 1
4886411 2322611 2322611 plaintiff Fullere William   597925 597925 Fullere, William, of Magna Lynton 0
4886414 2322611 2322611 defendant Bartilmewe John husbandman 597925 597925 Bartilmewe, John, of Magna Lynton, husbandman 2
4888854 2323302 2323302 defendant Westhele Thomas husbandman 597925 597925 Westhele, Thomas, of Magna Lynton, husbandman 3
4888855 2323302 2323302 defendant Reed Richard husbandman 597925 597925 Reed, Richard, of Magna Lynton, husbandman 4
4889023 2323357 2323357 defendant Algor Robert   597925 597925 Algor, Robert, of Magna Lynton, wheelwright 0
5067883 2376893 2376893 defendant Pomell John, senior husbandman 597925 597925 Pomell, John, senior, of Magna Lynton, husbandman 0
5067884 2376893 2376893 defendant Pomell John, junior husbandman 597925 597925 Pomell, John, junior, of Magna Lynton, husbandman 1
5067885 2376893 2376893 defendant Pomell Nicholas laborer 597925 597925 Pomell, Nicholas, of Magna Lynton, laborer 2
5067886 2376893 2376893 defendant Quykesale John laborer 597925 597925 Quykesale, John, of Magna Lynton, laborer 3
5353664 2461215 2461215 defendant Beye Simon mikller 597925 597925 Beye, Simon, of Magna Lynton, mikller 1
5353665 2461215 2461215 defendant Myncent John barker 597925 597925 Myncent, John, of Magna Lynton, barker 2
5353666 2461215 2461215 defendant Teversham John husbandman 597925 597925 Teversham, John, of Magna Lynton, husbandman 3
5353667 2461215 2461215 defendant Myncent William mercer 597925 597925 Myncent, William, of Magna Lynton, mercer 4
5353668 2461215 2461215 defendant Myncent Thomas husbandman 597925 597925 Myncent, Thomas, of Magna Lynton, husbandman 5
5353669 2461215 2461215 defendant Vyncent William yeoman 597925 597925 Vyncent, William, of Magna Lynton, yeoman 6
5353670 2461215 2461215 defendant Gardener Thomas fuller 597925 597925 Gardener, Thomas, of Magna Lynton, fuller 7
5353671 2461215 2461215 defendant Parkyn Richard yeoman 597925 597925 Parkyn, Richard, of Magna Lynton, yeoman 8
5353672 2461215 2461215 defendant Snareston John yeoman 597925 597925 Snareston, John, of Magna Lynton, yeoman 9
5353673 2461215 2461215 defendant Myncent John baker 597925 597925 Myncent, John, of Magna Lynton, baker 10
5353674 2461215 2461215 defendant Grene John husbandman 597925 597925 Grene, John, of Magna Lynton, husbandman 11

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