names

29 rows where place_id = 607990

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3671761 1917157 1917157 defendant Foster John yeoman 607990 607990 Foster, John, of Wrangle, Lincs, yeoman 0
3671763 1917158 1917158 defendant Foster John yeoman 607990 607990 Foster, John, of Wrangle, Lincs, yeoman 0
3671765 1917159 1917159 defendant Foster John yeoman 607990 607990 Foster, John, of Wrangle, Lincs, yeoman 0
3829808 1967215 1967215 defendant Rede John gent 607990 607990 Rede, John, of Wrangle, Lincs, gent 0
3845571 1972161 1972161 defendant Rodde John gent 607990 607990 Rodde, John, of Wrangle, Lincs, gent 0
3861341 1977260 1977260 defendant Rede John gent 607990 607990 Rede, John, of Wrangle, Lincs, gent 0
3886256 1985656 1985656 defendant Den Alexander yeoman 607990 607990 Den, Alexander, of Wrangle, Lincs, yeoman, Dawdry, Leonard, of Leke, yeoman 0
3930914 2000678 2000678 defendant Rede John gent 607990 607990 Rede, John, of Wrangle, Lincs, gent 1
4079265 2052886 2052886 defendant Brooke Thomas clerk 607990 607990 Brooke, Thomas, of Wrangle, Lincs, clerk 0
4095666 2058781 2058781 defendant Chamberleyn Francis yeoman 607990 607990 Chamberleyn, Francis, of Wrangle, Lincs, yeoman 0
4176318 2087197 2087197 defendant Chamberlen Francis yeoman 607990 607990 Chamberlen, Francis, of Wrangle, Lincs, yeoman 0
4199706 2095446 2095446 defendant Chamberlayn Francis gent 607990 607990 Chamberlayn, Francis, of Wrangle, Lincs, gent 0
4410896 2168234 2168234 defendant Rawe George glover 607990 607990 Rawe, George, of Wrangle, Lincs, glover 0
4583353 2226213 2226213 defendant Whytebred Alan   607990 607990 Whytebred, Alan, of Wrangle, Lincs 2
4583357 2226214 2226214 defendant Whytebred Alan   607990 607990 Whytebred, Alan, of Wrangle, Lincs 2
4659061 2248703 2248703 defendant Haliday Robert yeoman 607990 607990 Haliday, Robert, of Wrangle, Lincs, yeoman 0
4690396 2262554 2262554 defendant Grave or Grane John husbandman 607990 607990 Grave or Grane, John, of Wrangle, Lincs, husbandman 1
4806939 2298377 2298377 defendant Dandyson Hugh gent 607990 607990 Dandyson, Hugh, of Wrangle, Lincs, gent 2
4843318 2309427 2309427 defendant Dandeson Hugh gent 607990 607990 Dandeson, Hugh, of Wrangle, Lincs, gent 2
4843323 2309428 2309428 defendant Dandison Hugh gent 607990 607990 Dandison, Hugh, of Wrangle, Lincs, gent 3
4870749 2317829 2317829 defendant Dandison Hugh gent 607990 607990 Dandison, Hugh, of Wrangle, Lincs, gent 1
4870752 2317830 2317830 defendant Dandison Hugh gent 607990 607990 Dandison, Hugh, of Wrangle, Lincs, gent 1
4884761 2322135 2322135 defendant Dandyson or Daudyson Hugh gent 607990 607990 (Dandyson or Daudyson, Hugh, of Wrangle, Lincs, gent 1
4903673 2327765 2327765 defendant Dandyson Hugh gent 607990 607990 together with Dandyson, Hugh, of Wrangle, Lincs, gent 2
4995331 2355448 2355448 defendant Hughson William yeoman 607990 607990 Hughson, William, of Wrangle, Lincs, yeoman 0
5426072 2482751 2482751 defendant Kyme John gent 607990 607990 Kyme, John, of Wrangle, Lincs, gent 3
5444325 2488209 2488209 defendant Kyme John esq 607990 607990 Kyme, John, of Wrangle, Lincs, esq 3
5444330 2488210 2488210 defendant Kyme John esq 607990 607990 Kyme, John, of Wrangle, Lincs, esq 3
5486699 2500923 2500923 defendant Kyme John esq 607990 607990 Kyme, John,of Wrangle, Lincs, esq 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);