names

26 rows where place_id = 766524

✎ 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
4434668 2175604 2175604 defendant Barowe Roger de   766524 766524 Barowe, Roger de, of Bardenay, abbot 2
4499592 2200515 2200515 plaintiff Hayman John   766524 766524 Hayman, John, of Bardenay, abbot of the monastery 0
4528974 2209342 2209342 defendant Merston John   766524 766524 Merston, John, of Bardenay 0
4581118 2225580 2225580 plaintiff Draper William   766524 766524 Draper, William, of Bardenay 0
4581124 2225581 2225581 plaintiff Draper William   766524 766524 Draper, William, of Bardenay 0
4636378 2242213 2242213 defendant Spicer Giles   766524 766524 Spicer, Giles, of Bardenay 0
4655069 2247469 2247469 defendant Poye Simon husbandman 766524 766524 Poye, Simon, of Bardenay, husbandman 0
4723892 2272773 2272773 defendant Nevyll Robert husbandman 766524 766524 Nevyll, Robert, of Bardenay, husbandman 7
4757868 2282840 2282840 plaintiff Broun Richard   766524 766524 Broun, Richard, of Bardenay 0
4774884 2288137 2288137 defendant Hammyngby Geoffrey de   766524 766524 Hammyngby, Geoffrey de, of Bardenay, abbot of the monastery 0
4778653 2289307 2289307 defendant Papulwyk William gent 766524 766524 Papulwyk, William, of Bardenay, gent 0
4791472 2293426 2293426 defendant othe Wode William laborer 766524 766524 othe Wode, William, of Bardenay, laborer 0
4799259 2295945 2295945 defendant Warde Thomas husbandman 766524 766524 Warde, Thomas, of Bardenay, husbandman 0
4814547 2300659 2300659 defendant Warde Thomas husbandman 766524 766524 Warde, Thomas, of Bardenay, husbandman 2
4818238 2301782 2301782 defendant Hemingsby Geoffrey   766524 766524 Hemingsby, Geoffrey, of Bardenay, abbot 0
4835863 2307203 2307203 defendant Warde Thomas husbandman 766524 766524 Warde, Thomas, of Bardenay, husbandman 0
4846283 2310343 2310343 defendant Stevenson William butcher 766524 766524 Stevenson, William, of Bardenay, butcher 0
4863254 2315478 2315478 defendant Warde Thomas husbandman 766524 766524 Warde, Thomas, of Bardenay, husbandman 0
4898994 2326330 2326330 defendant Nutte John husbandman 766524 766524 Nutte, John, of Bardenay, or of Norton, husbandman 2
4918669 2332356 2332356 defendant Cade Thomas husbandman 766524 766524 Cade, Thomas, of Bardenay, husbandman 0
4940976 2339202 2339202 defendant Braytoft William yeoman 766524 766524 Braytoft, William, of Bardenay, yeoman 1
5042714 2369429 2369429 defendant Peny William   766524 766524 Peny, William, of Bardenay, wright 2
5156588 2403080 2403080 defendant Mavenson Robert laborer 766524 766524 Mavenson, Robert, of Bardenay, laborer 0
5156589 2403080 2403080 defendant Andrew John laborer 766524 766524 Andrew, John, of Bardenay, laborer 1
5249364 2429932 2429932 defendant Parot Thomas laborer 766524 766524 Parot, Thomas, of Bardenay, laborer 2
5249365 2429932 2429932 defendant Peny Thomas laborer 766524 766524 Peny, Thomas, of Bardenay, laborer 3

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