names

19 rows where place_id = 588722

✎ 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
3595382 1866187 1866187 defendant Seman Roger chapman 588722 588722 Seman, Roger, of Marlowe, Bucks, chapman 2
3604273 1868999 1868999 defendant Phylyppys Thomas courser 588722 588722 Phylyppys, Thomas, of Marlowe, Bucks, courser 2
3659642 1913271 1913271 defendant Ward John weaver 588722 588722 Ward, John, of Marlowe, Bucks, weaver 0
3850468 1973734 1973734 defendant Foster William yeoman 588722 588722 Foster, William, of Marlowe, Bucks, yeoman 1
3850471 1973735 1973735 defendant Foster William yeoman 588722 588722 Foster, William, of Marlowe, Bucks, yeoman 1
3917851 1996330 1996330 defendant Conessbye Robert gent 588722 588722 Conessbye, Robert, of Marlowe, Bucks, gent 0
3929009 2000040 2000040 defendant Conyngesby Robert gent 588722 588722 Conyngesby, Robert, of Marlowe, Bucks, gent 0
4032149 2036166 2036166 defendant Hyde William husbandman 588722 588722 Hyde, William, of Marlowe, Bucks, husbandman 0
4111616 2064404 2064404 defendant Hamond Robert yeoman 588722 588722 Hamond, Robert, of Marlowe, Bucks, yeoman 1
4148126 2077477 2077477 defendant More Ralph butcher 588722 588722 More, Ralph, of Marlowe, Bucks, butcher 0
4173037 2086025 2086025 defendant Moore Ralph butcher 588722 588722 Moore, Ralph, of Marlowe, Bucks, butcher 0
4380226 2158032 2158032 defendant Saunders Robert gent 588722 588722 (Saunders, Robert, of Marlowe, Bucks, gent 2
5249230 2429894 2429894 defendant Brown Thomas miller 588722 588722 Brown, Thomas, of Marlowe, Bucks, miller 4
5332800 2454877 2454877 defendant Crook John butcher 588722 588722 Crook, John, of Marlowe, Bucks, butcher 3
5494222 2503176 2503176 defendant Hicdayes Robert laborer 588722 588722 Hicdayes, Robert, of Marlowe, Bucks, laborer 1
5494227 2503177 2503177 defendant Hicdayes Robert laborer 588722 588722 Hicdayes, Robert, of Marlowe, Bucks, laborer 1
5503423 2505979 2505979 defendant Godyer Richard tailor 588722 588722 Godyer, Richard, of Marlowe, Bucks, tailor 0
5553807 2521150 2521150 defendant Smalle William butcher 588722 588722 Smalle, William, of Marlowe, Bucks, butcher 0
5603168 2535877 2535877 defendant Gower Robert chapman 588722 588722 Gower, Robert, of Marlowe, Bucks, chapman 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);