names

28 rows where place_id = 623017

✎ 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
3677896 1919139 1919139 defendant Fowler Robert yeoman 623017 623017 Fowler, Robert, of Iseldon, Middx, gent, son of Fowler, John, of Stepyng Parva, Lincs, yeoman 0
3677901 1919140 1919140 defendant Fowler Robert yeoman 623017 623017 Fowler, Robert, of Iseldon, Middx, gent, son of Fowler, John, of Stepyng Parva, Lincs, yeoman 0
3750224 1941987 1941987 defendant Ferrour John yeoman 623017 623017 Ferrour, John, of Iseldon, Middx, yeoman 0
3798110 1957306 1957306 defendant Lyney William wheeler 623017 623017 Lyney, William, of Iseldon, Middx, wheeler 3
3895452 1988689 1988689 defendant Averey John gent 623017 623017 Averey, John, of Iseldon, Middx, gent 0
4800324 2296281 2296281 defendant Lorymer John husbandman 623017 623017 Lorymer, John, of Iseldon, Middx, husbandman 1
4805963 2298073 2298073 defendant Selby Ralph yeoman 623017 623017 Selby, Ralph, of Iseldon, Middx, yeoman 0
4998143 2356311 2356311 defendant Farley John   623017 623017 Farley, John, of Iseldon, Middx, vicar 0
5044460 2369973 2369973 defendant Saundre Henry   623017 623017 Saundre, Henry, of Iseldon, Middx 0
5044462 2369974 2369974 defendant Saundre Henry husbandman 623017 623017 Saundre, Henry, of Iseldon, Middx, husbandman 0
5077646 2379811 2379811 defendant Hale William yeoman 623017 623017 Hale, William, of Iseldon, Middx, yeoman 1
5089186 2383207 2383207 defendant Bukston Geoffrey yeoman 623017 623017 Bukston, Geoffrey, of Iseldon, Middx, yeoman 1
5213291 2419619 2419619 defendant Farley John clerk 623017 623017 Farley, John, of Iseldon, Middx, or of Maydewell, Nhants, clerk 0
5213293 2419620 2419620 defendant Farley John clerk 623017 623017 Farley, John, of Iseldon, Middx, or of Maydewell, Nhants, clerk 0
5216856 2420669 2420669 defendant Curson Richard gent 623017 623017 Curson, Richard, of Iseldon, Middx, gent 0
5217307 2420798 2420798 defendant Halome William   623017 623017 Halome, William, of Iseldon, Middx, gent, sergeant at arms 0
5217331 2420806 2420806 defendant Halome William   623017 623017 Halome, William, of Iseldon, Middx, gent, sergeant at arms 0
5218464 2421130 2421130 defendant Watyrhous William yeoman 623017 623017 Watyrhous, William, of Iseldon, Middx, yeoman 0
5228318 2423890 2423890 defendant Halle Thomas baker 623017 623017 Halle, Thomas, of Iseldon, Middx, baker 3
5248152 2429594 2429594 defendant Curson Richard gent 623017 623017 Curson, Richard, of Iseldon, Middx, gent 2
5296299 2443907 2443907 defendant Gerveys Richard yeoman 623017 623017 Gerveys, Richard, of Iseldon, Middx, yeoman 0
5296408 2443938 2443938 defendant Gerveys Richard yeoman 623017 623017 Gerveys, Richard, of Iseldon, Middx, yeoman 0
5352535 2460885 2460885 defendant Maideforth John weaver 623017 623017 Maideforth, John, of Iseldon, Middx, weaver 0
5448446 2489432 2489432 defendant Heybourn Thomas husbandman 623017 623017 Heybourn, Thomas, of Iseldon, Middx, husbandman 0
5463002 2493844 2493844 defendant Rogers Thomas laborer 623017 623017 Rogers, Thomas, of Iseldon, Middx, laborer 0
5474550 2497363 2497363 defendant Rogers Thomas laborer 623017 623017 Rogers, Thomas, of Iseldon, Middx, laborer 0
5538020 2516382 2516382 defendant Radwyke Thomas yeoman 623017 623017 Radwyke, Thomas, of Iseldon, Middx, yeoman 3
5590455 2531982 2531982 defendant Camfeld John carpenter 623017 623017 Camfeld, John, of Iseldon, Middx, carpenter 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);