names

28 rows where place_id = 595473

✎ 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
3620605 1874021 1874021 defendant Skulthorp John husbandman 595473 595473 Skulthorp, John, of Ledyngton, husbandman 0
3683521 1920977 1920977 defendant Lake Robert (legal representative) 595473 595473 Lake, Robert, of Ledyngton, yeoman, administrator of 2
3683522 1920977 1920977 defendant Irelond John yeoman 595473 595473 Irelond, John, of Ledyngton, yeoman 3
3765490 1946872 1946872 defendant Barret John husbandman 595473 595473 Barret, John, of Ledyngton, husbandman 0
3814666 1962498 1962498 defendant Aleyn Robert clerk 595473 595473 Aleyn, Robert, of Ledyngton, clerk 0
3814667 1962498 1962498 defendant Cole William husbandman 595473 595473 Cole, William, of Ledyngton, husbandman 1
3814668 1962498 1962498 defendant Wareman William husbandman 595473 595473 Wareman, William, of Ledyngton, husbandman 2
3868454 1979687 1979687 defendant Farneley Robert yeoman 595473 595473 Farneley, Robert, of Ledyngton, yeoman 0
3868455 1979687 1979687 defendant Parre John shoemaker 595473 595473 Parre, John, of Ledyngton, shoemaker 1
3868456 1979687 1979687 defendant Toppey Alice widow 595473 595473 Toppey, Alice, of Ledyngton, widow 2
3868457 1979687 1979687 defendant Fowler John yeoman 595473 595473 Fowler, John, of Ledyngton, yeoman 3
3882358 1984360 1984360 defendant Farneley Robert yeoman 595473 595473 Farneley, Robert, of Ledyngton, yeoman 0
4851912 2312032 2312032 defendant Spycer William summoner 595473 595473 Spycer, William, of Ledyngton, summoner 0
4882762 2321528 2321528 defendant Isabel John yepoman 595473 595473 Isabel, John, of Ledyngton, yepoman 1
4911174 2330004 2330004 defendant Fyssher John fisher 595473 595473 Fyssher, John, of Ledyngton, fisher 1
4939615 2338778 2338778 defendant Clendon John husbandman 595473 595473 Clendon, John, of Ledyngton, husbandman 0
5011856 2360319 2360319 defendant atte Hill John husbandman 595473 595473 atte Hill, John, of Ledyngton, husbandman 0
5011858 2360319 2360319 defendant Godewyn John barber 595473 595473 Godewyn, John, of Ledyngton, barber 2
5011900 2360332 2360332 defendant Godewyn John barber 595473 595473 Godewyn, John, of Ledyngton, barber 0
5061936 2375169 2375169 defendant Oweyn John husbandman 595473 595473 Oweyn, John, of Ledyngton, husbandman 0
5187318 2412015 2412015 defendant Barwell Simon husbandman 595473 595473 Barwell, Simon, of Ledyngton, husbandman 1
5233330 2425333 2425333 defendant Ray Thomas husbandman 595473 595473 Ray, Thomas, of Ledyngton, husbandman 0
5233331 2425333 2425333 defendant Irland Robert husbandman 595473 595473 Irland, Robert, of Ledyngton, husbandman 1
5240229 2427349 2427349 defendant Ray Thomas husbandman 595473 595473 Ray, Thomas, of Ledyngton, husbandman 0
5481305 2499354 2499354 defendant Davy John husbandman 595473 595473 Davy, John, of Ledyngton, husbandman 5
5481815 2499494 2499494 defendant Slye Robert baker 595473 595473 Slye, Robert, of Ledyngton, baker 1
5505823 2506742 2506742 defendant Slye Robert husbandman 595473 595473 Slye, Robert, of Ledyngton, husbandman 3
5582272 2529530 2529530 defendant Lake Robert yeoman 595473 595473 Lake, Robert, of Ledyngton, yeoman 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);