names

24 rows where place_id = 589870

✎ 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
3599069 1867345 1867345 defendant Penson Richard husbandman 589870 589870 Penson, Richard, of Allesley, Warks, husbandman 2
3605069 1869251 1869251 defendant Dey John husbandman 589870 589870 Dey, John, of Allesley, Warks, husbandman 3
4041697 2039514 2039514 plaintiff Norton John gent 589870 589870 Norton, John, of Allesley, Warks, gent 0
4066528 2048321 2048321 defendant Norton John gent 589870 589870 Norton, John, of Allesley, Warks, gent 1
4109814 2063768 2063768 defendant Frecleton Ferdinand gent 589870 589870 Frecleton, Ferdinand, of Allesley, Warks, gent 0
4183322 2089649 2089649 defendant Thorneton Thomas gent 589870 589870 Thorneton, Thomas, of Allesley, Warks, gent 0
4183325 2089650 2089650 defendant Thorneton Thomas gent 589870 589870 Thorneton, Thomas, of Allesley, Warks, gent 0
4277356 2122004 2122004 defendant Fytche Robert gent 589870 589870 Fytche, Robert, of Allesley, Warks, gent 0
4958389 2344477 2344477 defendant Welbek John brasier 589870 589870 Welbek, John, of Allesley, Warks, brasier 0
4976167 2349827 2349827 defendant Grendon Richard husbandman 589870 589870 Grendon, Richard, of Allesley, Warks, husbandman 1
4976172 2349828 2349828 defendant Grendon Richard husbandman 589870 589870 Grendon, Richard, of Allesley, Warks, husbandman 1
4976174 2349828 2349828 defendant Auncell Henry yeoman 589870 589870 Auncell, Henry, of Allesley, Warks, yeoman 3
5089004 2383162 2383162 defendant Grendon Richard husbandman 589870 589870 Grendon, Richard, of Allesley, Warks, husbandman 0
5089008 2383163 2383163 defendant Grendon Richard husbandman 589870 589870 Grendon, Richard, of Allesley, Warks, husbandman 0
5096546 2385422 2385422 defendant Sponer Thomas husbandman 589870 589870 Sponer, Thomas, of Allesley, Warks, husbandman 0
5110514 2389477 2389477 defendant Saunders Thomas husbandman 589870 589870 Saunders, Thomas, of Allesley, Warks, husbandman 0
5116859 2391360 2391360 defendant Grandon Richard husbandman 589870 589870 Grandon, Richard, of Allesley, Warks, husbandman 0
5248895 2429798 2429798 defendant Gefferey William yeoman 589870 589870 Gefferey, William, of Allesley, Warks, yeoman 1
5252455 2430878 2430878 defendant Geffrey William husbandman 589870 589870 (Geffrey, William, of Allesley, Warks, husbandman 1
5252459 2430879 2430879 defendant Geffrey William husbandman 589870 589870 (Geffrey, William, of Allesley, Warks, husbandman 1
5281036 2439530 2439530 defendant Spon John husbandman 589870 589870 Spon, John, of Allesley, Warks, husbandman 3
5328343 2453551 2453551 defendant Halle Henry husbandman 589870 589870 Halle, Henry, of Allesley, Warks, husbandman 0
5504787 2506420 2506420 defendant Halom Peter husbandman 589870 589870 Halom, Peter, of Allesley, Warks, husbandman 0
5517131 2510194 2510194 defendant Halle Henry husbandman 589870 589870 Halle, Henry, of Allesley, Warks, husbandman 2

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