names

25 rows where place_id = 599972

✎ 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
3639124 1907057 1907057 defendant Apoole John yeoman 599972 599972 Apoole, John, of Offyngton, yeoman 3
3639131 1907058 1907058 defendant Apoole John yeoman 599972 599972 Apoole, John, of Offyngton, yeoman 3
4515080 2205128 2205128 defendant Smyth Robert   599972 599972 Smyth, Robert, of Offyngton 0
4556028 2217826 2217826 defendant Magge John   599972 599972 Magge, John, of Offyngton, vicar 0
4629501 2240156 2240156 defendant Whitelegge John   599972 599972 Whitelegge, John, of Offyngton 0
4704274 2266714 2266714 defendant Smyth Robert husbandman 599972 599972 Smyth, Robert, of Offyngton, husbandman 0
5350407 2460249 2460249 defendant Castell Robert butcher 599972 599972 Castell, Robert, of Offyngton, butcher 2
5419034 2480620 2480620 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight 0
5437365 2486120 2486120 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight, Lord de la Warr 0
5451777 2490407 2490407 defendant Welt Thomas   599972 599972 Welt, Thomas, of Offyngton, knight, Lord la Warre 0
5463726 2494067 2494067 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight, Lord la Warr 0
5463728 2494068 2494068 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight, Lord la Warre 0
5472440 2496722 2496722 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight, Lord le Ware 0
5475299 2497601 2497601 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight & Lord la Warre 0
5475301 2497602 2497602 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight, Lord la Warre 0
5489880 2501858 2501858 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight, Lord de la Warre 0
5494846 2503351 2503351 defendant Rede Henry yeoman 599972 599972 Rede, Henry, of Offyngton, yeoman 0
5499809 2504891 2504891 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight, Lord de la Ware 0
5499812 2504892 2504892 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight, Lord de la Ware 0
5504776 2506415 2506415 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight, Lord de la Warre 0
5507304 2507181 2507181 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight, Lord Lawarr 0
5514363 2509343 2509343 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight, Lord de la Warre 0
5514366 2509344 2509344 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight, Lord Laware 0
5517722 2510383 2510383 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight, Lord Lawarr 0
5518050 2510484 2510484 defendant West Thomas   599972 599972 West, Thomas, of Offyngton, knight, Lord de la Warre 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);