names

29 rows where place_id = 586428

✎ 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
3588696 1864108 1864108 defendant Mounteney William yeoman 586428 586428 Mounteney, William, of Wilby, yeoman 0
3708151 1928848 1928848 defendant Mownteney John gent 586428 586428 Mownteney, John, of Wilby, gent 0
3859578 1976695 1976695 defendant Ragdale Henry husbandman 586428 586428 Ragdale, Henry, of Wilby, husbandman 0
3869380 1979997 1979997 defendant Levald Charles husbandman 586428 586428 Levald, Charles, of Wilby, husbandman 1
3990911 2021512 2021512 defendant Calver Lawrence weaver 586428 586428 Calver, Lawrence, of Wilby, weaver 0
4093798 2058105 2058105 defendant Roobewood John, senior yeoman 586428 586428 Roobewood, John, senior, of Wilby, yeoman 0
4099762 2060237 2060237 defendant Goldsmyth William gent 586428 586428 Goldsmyth, William, of Wilby, gent 1
4162894 2082551 2082551 defendant Bales Thomas   586428 586428 Bales, Thomas, of Wilby, gent, his son 1
4309379 2133439 2133439 defendant Bales Thomas gent 586428 586428 Bales, Thomas, of Wilby, gent 0
4309381 2133440 2133440 defendant Bales Thomas gent 586428 586428 Bales, Thomas, of Wilby, gent 0
4515651 2205319 2205319 defendant Ferour Robert   586428 586428 Ferour, Robert, of Wilby 2
4604050 2232434 2232434 defendant Kyngton Henry   586428 586428 Kyngton, Henry, of Wilby 1
4635907 2242065 2242065 defendant Roo William   586428 586428 Roo, William, of Wilby 0
4665195 2250599 2250599 plaintiff Heryot Simon   586428 586428 Heryot, Simon, of Wilby 0
4671528 2256740 2256740 defendant Colton Thomas husbandman 586428 586428 Colton, Thomas, of Wilby, husbandman 4
4734130 2275857 2275857 defendant Rok Thomas yeoman 586428 586428 Rok, Thomas, of Wilby, yeoman 3
4734132 2275857 2275857 defendant Neel John yeoman 586428 586428 Neel, John, of Wilby, yeoman 5
4752052 2281088 2281088 defendant Mounteneye Thomas (legal representative) 586428 586428 Mounteneye, Thomas, of Wilby, executrix of 3
4887305 2322866 2322866 plaintiff Silston William   586428 586428 Silston, William, of Wilby 1
4958262 2344440 2344440 defendant Banham Robert husbandman 586428 586428 Banham, Robert, of Wilby, husbandman 0
5070725 2377741 2377741 defendant Thonge William yeoman 586428 586428 Thonge, William, of Wilby, yeoman 0
5136986 2397335 2397335 defendant Philypp William laborer 586428 586428 Philypp, William, of Wilby, laborer 2
5148878 2400796 2400796 defendant Houson Richard clerk 586428 586428 Houson, Richard, of Wilby, clerk 0
5173424 2407930 2407930 defendant Philipp William laborer 586428 586428 Philipp, William, of Wilby, laborer 2
5362195 2463841 2463841 defendant Mounteney William gent 586428 586428 Mounteney, William, of Wilby, gent 0
5362197 2463842 2463842 defendant Mounteney William gent 586428 586428 Mounteney, William, of Wilby, gent 0
5511533 2508456 2508456 defendant Barnshawe Roger yeoman 586428 586428 Barnshawe, Roger, of Wilby, yeoman 0
5604131 2536151 2536151 defendant Hamonde Robert yeoman 586428 586428 Hamonde, Robert, of Wilby, yeoman 2
5627970 2552717 2552717 defendant Rook Thomas husbandman 586428 586428 Rook, Thomas, of Wilby, husbandman 4

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