names

28 rows where place_id = 609085

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3676963 1918831 1918831 plaintiff Kynnersley Thomas esq 609085 609085 Kynnersley, Thomas, of Loxley, esq 0
3706960 1928460 1928460 plaintiff Kynnersley Thomas esq 609085 609085 Kynnersley, Thomas, of Loxley, esq 0
3706964 1928461 1928461 plaintiff Kynnersley Thomas esq 609085 609085 Kynnersley, Thomas, of Loxley, esq 0
3733843 1936837 1936837 defendant Kynnersley Thomas gent 609085 609085 Kynnersley, Thomas, of Loxley, gent 0
3733844 1936837 1936837 defendant Kynnersley John gent 609085 609085 Kynnersley, John, of Loxley, gent 1
3817162 1963280 1963280 plaintiff Kennersley Thomas esq 609085 609085 Kennersley, Thomas, of Loxley, esq 0
3832574 1968108 1968108 defendant Ward Thomas husbandman 609085 609085 Ward, Thomas, of Loxley, husbandman 1
3841624 1970964 1970964 defendant Hogkynson Thomas husbandman 609085 609085 Hogkynson, Thomas, of Loxley, husbandman 0
3858237 1976232 1976232 defendant Hogson Thomas husbandman 609085 609085 Hogson, Thomas, of Loxley, husbandman 1
3864649 1978375 1978375 defendant Warde Thomas husbandman 609085 609085 Warde, Thomas, of Loxley, husbandman 2
3917395 1996176 1996176 defendant Meykyns John husbandman 609085 609085 Meykyns, John, of Loxley, husbandman 3
4167353 2084082 2084082 defendant Craftes Thomas yeoman 609085 609085 Craftes, Thomas, of Loxley, yeoman 0
4177550 2087623 2087623 defendant Eaton John husbandman 609085 609085 Eaton, John, of Loxley, husbandman 2
4189839 2091943 2091943 defendant Croftes Thomas yeoman 609085 609085 Croftes, Thomas, of Loxley, yeoman 1
4222147 2103237 2103237 defendant Hopper John yeoman 609085 609085 Hopper, John, of Loxley, yeoman 0
4230573 2106189 2106189 defendant Hopper John yeoman 609085 609085 Hopper, John, of Loxley, yeoman 0
4282000 2123606 2123606 defendant Craft Thomas yeoman 609085 609085 Craft, Thomas, of Loxley, yeoman 0
4330239 2140416 2140416 defendant Warner William husbandman 609085 609085 Warner, William, of Loxley, husbandman 3
4357768 2149955 2149955 defendant Kynnersley Anthony esq 609085 609085 Kynnersley, Anthony, of Loxley, esq 0
4357769 2149955 2149955 defendant Kynnersley Francis gent 609085 609085 Kynnersley, Francis, of Loxley, gent 1
4379880 2157904 2157904 defendant Croftes or Craft Thomas yeoman 609085 609085 Croftes or Craft, Thomas, of Loxley, yeoman 0
4412602 2168804 2168804 defendant Kynnarsley Anthony esq 609085 609085 Kynnarsley, Anthony, of Loxley, esq 0
4412603 2168804 2168804 defendant Kynnarsley Francis gent 609085 609085 Kynnarsley, Francis, of Loxley, gent 1
4703032 2266331 2266331 defendant Waryn Henry (legal representative) 609085 609085 Waryn, Henry, of Loxley, yeoman, administratrix of 0
5379707 2469237 2469237 defendant Edwardes Thomas husbandman 609085 609085 Edwardes, Thomas, of Loxley, husbandman 3
5391158 2472548 2472548 defendant Lyng Richard husbandman 609085 609085 Lyng, Richard, of Loxley, husbandman 0
5547994 2519445 2519445 plaintiff Kynnersley Thomas esq 609085 609085 Kynnersley, Thomas, of Loxley, esq 1
5599691 2534794 2534794 defendant Hyne or Hyve Richard yeoman 609085 609085 Hyne or Hyve, Richard, of Loxley, 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);