names

20 rows where place_id = 614630

✎ 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
3704664 1927745 1927745 defendant Hounesley John yeoman 614630 614630 Hounesley, John, of Chaddesley, Worcs, yeoman 3
3714419 1930805 1930805 defendant Berket John yeoman 614630 614630 Berket, John, of Chaddesley, Worcs, yeoman 2
3910488 1993824 1993824 defendant Phyllyps Robert   614630 614630 Phyllyps, Robert, of Chaddesley, Worcs 0
3938341 2003160 2003160 defendant Burneforde John   614630 614630 Burneforde, John, of Chaddesley, Worcs, scyth smith 0
4670652 2256504 2256504 defendant Petyt John yeoman 614630 614630 with Petyt, John, of Chaddesley, Worcs, yeoman 3
4670654 2256505 2256505 defendant Petyt John yeoman 614630 614630 Petyt, John, of Chaddesley, Worcs, yeoman 0
4852307 2312145 2312145 defendant Sturmy John husbandman 614630 614630 Sturmy, John, of Chaddesley, Worcs, husbandman 4
4971589 2348432 2348432 defendant Tyrret Thomas husbandman 614630 614630 Tyrret, Thomas, of Chaddesley, Worcs, husbandman 2
4991667 2354391 2354391 defendant Tyret Thomas husbandman 614630 614630 Tyret, Thomas, of Chaddesley, Worcs, husbandman 0
5085935 2382279 2382279 defendant Goderich William husbandman 614630 614630 Goderich, William, of Chaddesley, Worcs, husbandman 0
5103355 2387410 2387410 defendant atte Cley John smith 614630 614630 atte Cley, John, of Chaddesley, Worcs, smith 2
5327375 2453259 2453259 defendant Bole John husbandman 614630 614630 Bole, John, of Chaddesley, Worcs, husbandman 2
5380865 2469583 2469583 defendant Symondes John husbandman 614630 614630 Symondes, John, of Chaddesley, Worcs, husbandman 0
5384085 2470537 2470537 defendant Symondes John husbandman 614630 614630 Symondes, John, of Chaddesley, Worcs, husbandman 0
5535672 2515672 2515672 defendant Blount Thomas gent 614630 614630 Blount, Thomas, of Chaddesley, Worcs, gent 0
5535678 2515673 2515673 defendant Blount Thomas gent 614630 614630 Blount, Thomas, of Chaddesley, Worcs, gent 0
5535974 2515752 2515752 defendant Blount Thomas gent 614630 614630 Blount, Thomas, of Chaddesley, Worcs, gent 4
5539078 2516704 2516704 defendant Smyth John smith 614630 614630 Smyth, John, of Chaddesley, Worcs, smith 0
5550896 2520294 2520294 defendant Blount Thomas gent 614630 614630 Blount, Thomas, of Chaddesley, Worcs, gent 1
5551298 2520412 2520412 defendant Blount Thomas gent 614630 614630 Blount, Thomas, of Chaddesley, Worcs, gent 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);