names

27 rows where place_id = 587034

✎ 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
3590305 1864611 1864611 defendant Mitton Richard clerk 587034 587034 Mitton, Richard, of Trunch, clerk 1
3633112 1905167 1905167 defendant Tatsall William husbandman 587034 587034 Tatsall, William, of Trunch, husbandman 3
3639191 1907072 1907072 defendant Beaffeld alias Note Richard (legal representative) 587034 587034 Beaffeld alias Note, Richard, of Trunch, husbandman, executor of 0
3639192 1907072 1907072 defendant Wurtys Robert husbandman 587034 587034 Wurtys, Robert, of Trunch, husbandman 1
3885829 1985514 1985514 plaintiff Bolte William   587034 587034 Bolte, William, of Trunch 0
4071172 2049994 2049994 defendant Howes Robert husbandman 587034 587034 Howes, Robert, of Trunch, husbandman 0
4334004 2141654 2141654 defendant Chowte Arthur gent 587034 587034 Chowte, Arthur, of Trunch, gent 1
4343549 2145021 2145021 defendant Purgall William cordwainer 587034 587034 Purgall, William, of Trunch, cordwainer 1
4343550 2145021 2145021 defendant Rowland Denis laborer 587034 587034 Rowland, Denis, of Trunch, laborer 2
4343551 2145021 2145021 defendant Drewes James laborer 587034 587034 Drewes, James, of Trunch, laborer 3
4343553 2145022 2145022 defendant Brownyng John husbandman 587034 587034 Brownyng, John, of Trunch, husbandman 0
4351870 2147894 2147894 defendant Purgall William cordwainer 587034 587034 Purgall, William, of Trunch, cordwainer 0
4649163 2245806 2245806 plaintiff Trunch Clement (legal representative) 587034 587034 Trunch, Clement, of Trunch, executors of 0
4767112 2285698 2285698 defendant Gogel John   587034 587034 Gogel, John, of Trunch 7
5214368 2419935 2419935 defendant Hornyngtoft John yeoman 587034 587034 Hornyngtoft, John, of Trunch, yeoman 2
5219440 2421413 2421413 defendant Hornyngtoft John yeoman 587034 587034 Hornyngtoft, John, of Trunch, yeoman 1
5220527 2421701 2421701 defendant Hornyngtoft John husbandman 587034 587034 Hornyngtoft, John, of Trunch, husbandman 1
5224693 2422892 2422892 defendant Hornyngtoft John yeoman 587034 587034 Hornyngtoft, John, of Trunch, yeoman 0
5367492 2465481 2465481 plaintiff Cogull John   587034 587034 Cogull, John, of Trunch 0
5377697 2468606 2468606 plaintiff Gryme Thomas   587034 587034 Gryme, Thomas, of Trunch 1
5377700 2468607 2468607 plaintiff Gryme Thomas   587034 587034 Gryme, Thomas, of Trunch 1
5379406 2469150 2469150 plaintiff Gryme Thomas   587034 587034 Gryme, Thomas, of Trunch 1
5380761 2469551 2469551 plaintiff Cogull (illegible)   587034 587034 Cogull, _, of Trunch 0
5393435 2473182 2473182 plaintiff Gryme Thomas   587034 587034 Gryme, Thomas, of Trunch 1
5406629 2476963 2476963 plaintiff Bryme Thomas   587034 587034 Bryme, Thomas, of Trunch 1
5580759 2529062 2529062 defendant Symoner Thomas chapman 587034 587034 Symoner, Thomas, of Trunch, chapman 2
5609559 2537886 2537886 plaintiff Peryiat Thomas   587034 587034 Peryiat, Thomas, of Trunch 1

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);