names

28 rows where place_id = 601946

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3647777 1909697 1909697 defendant Tregasowe John esq 601946 601946 Tregasowe, John, of Leskerd, Cornw, esq 0
3662098 1914067 1914067 defendant Tregasowe John esq 601946 601946 Tregasowe, John, of Leskerd, Cornw, esq 0
3673656 1917790 1917790 defendant Tregafowe John gent 601946 601946 Tregafowe, John, of Leskerd, Cornw, gent 7
3705240 1927923 1927923 defendant Tregasowe John gent 601946 601946 Tregasowe, John, of Leskerd, Cornw, gent 0
3707632 1928684 1928684 defendant Tregasowe John esq 601946 601946 Tregasowe, John, of Leskerd, Cornw, esq 0
3867830 1979473 1979473 defendant Quyntrell Richard yeoman 601946 601946 Quyntrell, Richard, of Leskerd, Cornw, yeoman 0
3878536 1983065 1983065 defendant Wall Thomas yeoman 601946 601946 Wall, Thomas, of Leskerd, Cornw, yeoman 0
3995216 2023029 2023029 defendant Corynton William gent 601946 601946 Corynton, William, of Leskerd, Cornw, gent 3
4129996 2071032 2071032 defendant Langisforde Robert gent 601946 601946 Langisforde, Robert, of Leskerd, Cornw, gent 0
4950833 2342232 2342232 defendant Skynnard Thomas tanner 601946 601946 Skynnard, Thomas, of Leskerd, Cornw, tanner 0
4950839 2342233 2342233 defendant Skynnard Thomas tanner 601946 601946 Skynnard, Thomas, of Leskerd, Cornw, tanner 0
4979750 2350900 2350900 defendant Stephen Nicholas gent 601946 601946 Stephen, Nicholas, of Leskerd, Cornw, gent 5
4979757 2350901 2350901 defendant Stephen Nicholas gent 601946 601946 Stephen, Nicholas, of Leskerd, Cornw, gent 5
5109204 2389115 2389115 defendant Knyght Robert dyer 601946 601946 Knyght, Robert, of Leskerd, Cornw, dyer 2
5112257 2389966 2389966 defendant John Thomas gent 601946 601946 John, Thomas, of Leskerd, Cornw, gent 3
5234097 2425565 2425565 defendant Clemens Thomas gent 601946 601946 Clemens, Thomas, of Leskerd, Cornw, gent 0
5272684 2437088 2437088 defendant Clemens Thomas gent 601946 601946 Clemens, Thomas, of Leskerd, Cornw, gent 0
5323880 2452224 2452224 defendant Vage Robert gent 601946 601946 Vage, Robert, of Leskerd, Cornw, gent 3
5323884 2452225 2452225 plaintiff Vage Robert gent 601946 601946 Vage, Robert, of Leskerd, Cornw, gent 3
5328533 2453611 2453611 defendant Russell Nicholas girdler 601946 601946 (Russell, Nicholas, of Leskerd, Cornw, girdler 1
5369097 2465932 2465932 defendant Bromboyte John yeoman 601946 601946 Bromboyte, John, of Leskerd, Cornw, yeoman 0
5369758 2466131 2466131 defendant Bray Robert gent 601946 601946 Bray, Robert, of Leskerd, Cornw, gent 0
5385493 2470921 2470921 defendant Brounbogte John yeoman 601946 601946 Brounbogte, John, of Leskerd, Cornw, yeoman 0
5397632 2474391 2474391 defendant Brounboyte John yeoman 601946 601946 Brounboyte, John, of Leskerd, Cornw, yeoman 0
5397827 2474449 2474449 defendant Broun John yeoman 601946 601946 Broun, John, of Leskerd, Cornw, yeoman 0
5410307 2478034 2478034 defendant Bylbery John chapman 601946 601946 Bylbery, John, of Leskerd, Cornw, chapman 0
5410743 2478158 2478158 defendant Bromboyte John yeoman 601946 601946 Bromboyte, John, of Leskerd, Cornw, yeoman 0
5584844 2530338 2530338 defendant Bellery John mercer 601946 601946 Bellery, John, of Leskerd, Cornw, mercer 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);