names

34 rows where place_id = 587762

✎ 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
3592363 1865227 1865227 defendant Smythston John yeoman 587762 587762 Smythston, John, of Merwode, yeoman 0
3618577 1873434 1873434 defendant Merwode William gent 587762 587762 Merwode, William, of Merwode, gent 2
3628111 1903647 1903647 defendant Lytell alias Lorimer John husbandman 587762 587762 Lytell alias Lorimer, John, of Merwode, husbandman 0
3628112 1903647 1903647 defendant Fosse Hugh husbandman 587762 587762 Fosse, Hugh, of Merwode, husbandman 1
3630783 1904451 1904451 defendant Harry Andrew husbandman 587762 587762 Harry, Andrew, of Merwode, husbandman 2
3645072 1908868 1908868 defendant Beare William husbandman 587762 587762 Beare, William, of Merwode, husbandman 0
3645073 1908868 1908868 defendant Beare Richard   587762 587762 Beare, Richard, of Merwode, groom 1
3676284 1918627 1918627 defendant Curteys John husbandman 587762 587762 Curteys, John, of Merwode, husbandman 2
3676285 1918627 1918627 defendant Dyer John husbandman 587762 587762 Dyer, John, of Merwode, husbandman 3
3676286 1918627 1918627 defendant Beple John clerk 587762 587762 Beple, John, of Merwode, clerk 4
3676289 1918628 1918628 defendant Merwode John gent 587762 587762 Merwode, John, of Merwode, gent 0
3676290 1918628 1918628 defendant Garlond John gent 587762 587762 Garlond, John, of Merwode, gent 1
3676291 1918628 1918628 defendant Hamont Thomas husbandman 587762 587762 Hamont, Thomas, of Merwode, husbandman 2
3676292 1918628 1918628 defendant Cutclyff Thomas husbandman 587762 587762 Cutclyff, Thomas, of Merwode, husbandman 3
3676293 1918628 1918628 defendant Hele Robert clerk 587762 587762 Hele, Robert, of Merwode, clerk 4
3676294 1918628 1918628 defendant Beaple John clerk 587762 587762 Beaple, John, of Merwode, clerk 5
3740127 1938770 1938770 defendant Harrys Andrew husbandman 587762 587762 Harrys, Andrew, of Merwode, husbandman 0
3740129 1938771 1938771 defendant Harrys Andrew husbandman 587762 587762 Harrys, Andrew, of Merwode, husbandman 0
3745474 1940491 1940491 defendant Harrys Andrew husbandman 587762 587762 Harrys, Andrew, of Merwode, husbandman 0
3820803 1964397 1964397 defendant Harrys Andrew husbandman 587762 587762 Harrys, Andrew, of Merwode, husbandman 0
3832073 1967934 1967934 defendant Cad alias Humfrey John husbandman 587762 587762 Cad alias Humfrey, John, of Merwode, husbandman 0
3858077 1976179 1976179 defendant Somer Stephen husbandman 587762 587762 Somer, Stephen, of Merwode, husbandman 0
4642116 2243806 2243806 defendant Millond John   587762 587762 Millond, John, of Merwode 0
4656209 2247831 2247831 defendant Parkeman William tucker 587762 587762 Parkeman, William, of Merwode, tucker 0
5029526 2365505 2365505 defendant Willyam John   587762 587762 Willyam, John, of Merwode, holy water clerk 1
5230050 2424403 2424403 defendant Harry John merchant 587762 587762 Harry, John, of Merwode, merchant 2
5370892 2466484 2466484 plaintiff Hamond William (legal representative) 587762 587762 Hamond, William, of Merwode, Exeter diocese, rector, executor of 0
5395995 2473937 2473937 defendant Bryght Richard   587762 587762 Bryght, Richard, of Merwode 0
5409275 2477742 2477742 defendant Bryght Richard clerk 587762 587762 Bryght, Richard, of Merwode, clerk 0
5429878 2483879 2483879 plaintiff Hamond William (legal representative) 587762 587762 Hamond, William, of Merwode, Exeter diocese, rector, executor of 0
5509616 2507840 2507840 defendant Egger Robert laborer 587762 587762 Egger, Robert, of Merwode, laborer 0
5509618 2507841 2507841 defendant Egger Robert laborer 587762 587762 Egger, Robert, of Merwode, laborer 0
5545485 2518669 2518669 defendant Bryte Richard clerk 587762 587762 Bryte, Richard, of Merwode, clerk 0
5558931 2522562 2522562 defendant Garlond John gent 587762 587762 Garlond, John, of Merwode, gent 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);