names

25 rows where place_id = 593016

✎ 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
3610069 1870816 1870816 defendant Bastard John husbabdman 593016 593016 Bastard, John, of Dipford, husbabdman 2
3701345 1926664 1926664 defendant Laurans Thomas   593016 593016 Laurans, Thomas, of Dipford, groom 1
3701346 1926664 1926664 defendant Laurans John, senior husbandman 593016 593016 Laurans, John, senior, of Dipford, husbandman 2
3701347 1926664 1926664 defendant Laurans John, junior husbandman 593016 593016 Laurans, John, junior, of Dipford, husbandman 3
3714882 1930950 1930950 defendant Laurans Thomas   593016 593016 Laurans, Thomas, of Dipford, groom 1
3714883 1930950 1930950 defendant Laurans John, senior husbandman 593016 593016 Laurans, John, senior, of Dipford, husbandman 2
3714884 1930950 1930950 defendant Laurans John, junior husbandman 593016 593016 Laurans, John, junior, of Dipford, husbandman 3
4294254 2128021 2128021 defendant Beane John husbandman 593016 593016 Beane, John, of Dipford, husbandman 0
4412418 2168744 2168744 defendant Hamlyn Nicholas yeoman 593016 593016 Hamlyn, Nicholas, of Dipford, yeoman 0
5347247 2459305 2459305 defendant Lovet Richard husbandman 593016 593016 Lovet, Richard, of Dipford, husbandman 0
5348131 2459559 2459559 defendant Drewe alias Cole John husbandman 593016 593016 Drewe alias Cole, John, of Dipford, husbandman 2
5348132 2459559 2459559 defendant Lovet Richard husbandman 593016 593016 Lovet, Richard, of Dipford, husbandman 3
5349827 2460081 2460081 defendant Lytelton John, junior husbandman 593016 593016 Lytelton, John, junior, of Dipford, husbandman 0
5352509 2460878 2460878 defendant Harrys Vincent husbandman 593016 593016 Harrys, Vincent, of Dipford, husbandman 2
5352510 2460878 2460878 defendant Lovet Richard husbandman 593016 593016 Lovet, Richard, of Dipford, husbandman 3
5422658 2481728 2481728 defendant Groby Joan widow 593016 593016 Groby, Joan, of Dipford, widow 1
5522514 2511864 2511864 defendant Chopyn John husbandman 593016 593016 Chopyn, John, of Dipford, husbandman 0
5522515 2511864 2511864 defendant Trebe or Treve William husbandman 593016 593016 Trebe or Treve, William, of Dipford, husbandman 1
5522517 2511865 2511865 defendant Trebe or Treve William husbandman 593016 593016 Trebe or Treve, William, of Dipford, husbandman 0
5522518 2511865 2511865 defendant Chopyn John husbandman 593016 593016 Chopyn, John, of Dipford, husbandman 1
5525971 2512717 2512717 defendant Choppyn John husbandman 593016 593016 Choppyn, John, of Dipford, husbandman 0
5525972 2512717 2512717 defendant Trebe or Treve William husbandman 593016 593016 Trebe or Treve, William, of Dipford, husbandman 1
5525974 2512718 2512718 defendant Trebe William husbandman 593016 593016 Trebe, William, of Dipford, husbandman 0
5525975 2512718 2512718 defendant Choppyn John husbandman 593016 593016 Choppyn, John, of Dipford, husbandman 1
5559946 2522864 2522864 defendant Lusshe Henry yeoman 593016 593016 Lusshe, Henry, of Dipford, 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);