names

17 rows where place_id = 589993

✎ 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
3599494 1867483 1867483 defendant Poole Ralph esq 589993 589993 Poole, Ralph, of Rodburn, esq 0
3599497 1867484 1867484 defendant Poole Ralph esq 589993 589993 Poole, Ralph, of Rodburn, esq 0
3695461 1924803 1924803 defendant Dawe Robert   589993 589993 Dawe, Robert, of Rodburn Cheynewehusbandman 1
4420550 2171329 2171329 defendant Walton John de   589993 589993 Walton, John de, of Rodburn 1
4420551 2171329 2171329 defendant Morlegh William   589993 589993 Morlegh, William, of Rodburn 2
4420554 2171329 2171329 defendant Murcaston John de   589993 589993 Murcaston, John de, of Rodburn 5
4420555 2171329 2171329 defendant Tebbe Henry   589993 589993 Tebbe, Henry, of Rodburn 6
4551390 2216374 2216374 defendant Trip Richard   589993 589993 Trip, Richard, of Rodburn 0
4669431 2256146 2256146 defendant Sumpter William husbandman 589993 589993 Sumpter, William, of Rodburn, husbandman 0
4719740 2271523 2271523 plaintiff Brewode John master 589993 589993 Brewode, John, of Rodburn, master 2
4719747 2271524 2271524 plaintiff Brewode John master 589993 589993 Brewode, John, of Rodburn, master 2
4750615 2280666 2280666 defendant de la Pool ralph gent 589993 589993 de la Pool, ralph, of Rodburn, gent 1
4852441 2312178 2312178 defendant Pole Peter de la gent 589993 589993 Pole, Peter de la, of Rodburn, gent 0
4852442 2312178 2312178 defendant Pole Ralph de la   589993 589993 Pole, Ralph de la, of Rodburn 1
4870063 2317603 2317603 defendant de la Pole Peter esq 589993 589993 de la Pole, Peter, of Rodburn, esq 0
5573896 2526933 2526933 defendant Pole German esq 589993 589993 Pole, German, of Rodburn, esq 1
5573897 2526933 2526933 defendant Yarwode William yeoman 589993 589993 Yarwode, William, of Rodburn, yeoman 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);