names

26 rows where place_id = 591942

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606062 1869562 1869562 defendant Pychon Henry husbandman 591942 591942 Pychon, Henry, of Luddesdon, husbandman 0
3648364 1909888 1909888 defendant Bogherst John husbandman 591942 591942 Bogherst, John, of Luddesdon, husbandman 0
3676410 1918667 1918667 defendant Jones John husbandman 591942 591942 Jones, John, of Luddesdon, husbandman 0
3676411 1918667 1918667 defendant Halle Humphrey husbandman 591942 591942 Halle, Humphrey, of Luddesdon, husbandman 1
3704171 1927601 1927601 defendant German John laborer 591942 591942 German, John, of Luddesdon, laborer 0
3717991 1931923 1931923 defendant Wesshnes William yeoman 591942 591942 Wesshnes, William, of Luddesdon, yeoman 1
3731677 1936138 1936138 defendant Wasshenes William yeoman 591942 591942 Wasshenes, William, of Luddesdon, yeoman 0
3733796 1936822 1936822 defendant Pett alias Mason Joan widow 591942 591942 Pett alias Mason, Joan, of Luddesdon, widow 0
3766651 1947231 1947231 defendant Man John laborer 591942 591942 Man, John, of Luddesdon, laborer 0
4115141 2065703 2065703 defendant Edmede Henry husbandman 591942 591942 Edmede, Henry, of Luddesdon, husbandman 1
4227926 2105250 2105250 defendant Beverley John husbandman 591942 591942 Beverley, John, of Luddesdon, husbandman 1
5173792 2408031 2408031 defendant Peion John husbandman 591942 591942 Peion, John, of Luddesdon, husbandman 2
5240617 2427467 2427467 defendant Bokelond Thomas yeoman 591942 591942 Bokelond, Thomas, of Luddesdon, yeoman 0
5290662 2442270 2442270 defendant Estdown Richard husbandman 591942 591942 Estdown, Richard, of Luddesdon, husbandman 1
5326675 2453047 2453047 defendant Bogherst John husbandman 591942 591942 Bogherst, John, of Luddesdon, husbandman 3
5327393 2453265 2453265 defendant Estdowen William husbandman 591942 591942 Estdowen, William, of Luddesdon, husbandman 0
5354065 2461334 2461334 defendant Dalam John husbandman 591942 591942 Dalam, John, of Luddesdon, husbandman 3
5357148 2462300 2462300 defendant Pette William   591942 591942 Pette, William, of Luddesdon, mason 0
5361156 2463517 2463517 defendant Batheherst William laborer 591942 591942 Batheherst, William, of Luddesdon, laborer 4
5430881 2484178 2484178 defendant Buklond John husbandman 591942 591942 Buklond, John, of Luddesdon, husbandman 0
5481143 2499313 2499313 defendant Pygeon John husbandman 591942 591942 Pygeon, John, of Luddesdon, husbandman 0
5539612 2516871 2516871 defendant Elliotys John yeoman 591942 591942 Elliotys, John, of Luddesdon, yeoman 0
5539615 2516872 2516872 defendant Ellyottys John yeoman 591942 591942 Ellyottys, John, of Luddesdon, yeoman 0
5573652 2526859 2526859 defendant Frylond Robert husbandman 591942 591942 Frylond, Robert, of Luddesdon, husbandman 0
5573653 2526859 2526859 defendant Estdowne Thomas husbandman 591942 591942 Estdowne, Thomas, of Luddesdon, husbandman 1
5573654 2526859 2526859 defendant Estdowne Richard husbandman 591942 591942 Estdowne, Richard, of Luddesdon, 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);