names

37 rows where place_id = 618126

✎ 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
3722976 1933451 1933451 defendant Jude William yeoman 618126 618126 Jude, William, of Branston, yeoman 0
3750222 1941986 1941986 defendant Pope John butcher 618126 618126 Pope, John, of Branston, butcher 3
3772824 1949192 1949192 defendant Crosse Nicholas husbandman 618126 618126 Crosse, Nicholas, of Branston, husbandman 0
3852313 1974323 1974323 defendant Fronton John husbandman 618126 618126 Fronton, John, of Branston, husbandman 3
3854640 1975095 1975095 defendant Funteyn John yeoman 618126 618126 Funteyn, John, of Branston, yeoman 2
3866759 1979118 1979118 defendant Funteyn John husbandman 618126 618126 Funteyn, John, of Branston, husbandman 3
3959551 2010431 2010431 defendant Roper John husbandman 618126 618126 Roper, John, of Branston, husbandman 3
4036720 2037819 2037819 defendant Belcher Walter husbandman 618126 618126 Belcher, Walter, of Branston, husbandman 0
4036722 2037820 2037820 defendant Belcher Walter husbandman 618126 618126 Belcher, Walter, of Branston, husbandman 0
4150140 2078184 2078184 defendant Baxter John yeoman 618126 618126 Baxter, John, of Branston, yeoman 1
4152361 2078935 2078935 defendant Arnold Robert laborer 618126 618126 Arnold, Robert, of Branston, laborer 2
4218709 2102044 2102044 defendant Pell Thomas husbandman 618126 618126 Pell, Thomas, of Branston, husbandman 0
4218711 2102045 2102045 defendant Robinson Nicholas husbandman 618126 618126 Robinson, Nicholas, of Branston, husbandman 0
4261768 2116891 2116891 defendant Baxter William husbandman 618126 618126 Baxter, William, of Branston, husbandman 0
4327564 2139542 2139542 defendant Goodynge Robert miller 618126 618126 Goodynge, Robert, of Branston, miller 1
4387607 2160493 2160493 defendant Godfrey Robert gent 618126 618126 Godfrey, Robert, of Branston, gent 0
4464942 2189708 2189708 defendant atte Kichyn Peter   618126 618126 atte Kichyn, Peter, of Branston 9
4663174 2249947 2249947 defendant Brounham Geoffrey laborer 618126 618126 Brounham, Geoffrey, of Branston, laborer 0
4770881 2286872 2286872 defendant atte Style Peter husbandman 618126 618126 atte Style, Peter, of Branston, husbandman 0
4826977 2304477 2304477 defendant Chapman John yeoman 618126 618126 Chapman, John, of Branston, yeoman 0
4826979 2304478 2304478 defendant Chapman John yeoman 618126 618126 Chapman, John, of Branston, yeoman 0
4878594 2320249 2320249 defendant Howeman John turner 618126 618126 Howeman, John, of Branston, turner 2
4888086 2323078 2323078 defendant Botheman John butcher 618126 618126 Botheman, John, of Branston, butcher 1
4908799 2329303 2329303 defendant Sheryngham Alexander yeoman 618126 618126 Sheryngham, Alexander, of Branston, yeoman 0
5064074 2375789 2375789 defendant Bocheman Robert butcher 618126 618126 Bocheman, Robert, of Branston, butcher 1
5105425 2388027 2388027 defendant Botheman Robert butcher 618126 618126 Botheman, Robert, of Branston, butcher 0
5137056 2397353 2397353 defendant Corbrig Thomas laborer 618126 618126 Corbrig, Thomas, of Branston, laborer 0
5137059 2397354 2397354 defendant Botheman Robert husbandman 618126 618126 Botheman, Robert, of Branston, husbandman 1
5157657 2403369 2403369 defendant Corbrig Thomas laborer 618126 618126 Corbrig, Thomas, of Branston, laborer 0
5157660 2403370 2403370 defendant Botheman Robert husbandman 618126 618126 Botheman, Robert, of Branston, husbandman 1
5173489 2407948 2407948 defendant Corbrig Thomas laborer 618126 618126 Corbrig, Thomas, of Branston, laborer 0
5173492 2407949 2407949 defendant Botheman Robert husbandman 618126 618126 Botheman, Robert, of Branston, husbandman 1
5193581 2413845 2413845 defendant Skarlet John husbandman 618126 618126 Skarlet, John, of Branston, husbandman 1
5208254 2418142 2418142 defendant Skarlet John husbandman 618126 618126 Skarlet, John, of Branston, husbandman 1
5251242 2430491 2430491 defendant Botheman Robert butcher 618126 618126 Botheman, Robert, of Branston, butcher 1
5263496 2434331 2434331 defendant Wade Thomas (legal representative) 618126 618126 Wade, Thomas, of Branston, executrix of 0
5331966 2454635 2454635 defendant Corbrygge Thomas husbandman 618126 618126 Corbrygge, Thomas, of Branston, husbandman 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);