names

29 rows where place_id = 759039

✎ 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
4458715 2187770 2187770 plaintiff Reme John   759039 759039 Reme, John, of Hegham Ferrers 0
4557273 2218212 2218212 plaintiff Koo Richard chaplain 759039 759039 Koo, Richard, of Hegham Ferrers, chaplain 0
4559351 2218877 2218877 plaintiff Maysham John draper 759039 759039 Maysham, John, of Hegham Ferrers, draper 0
4618768 2236872 2236872 defendant Curtays Alice   759039 759039 Curtays, Alice, of Hegham Ferrers 1
4618780 2236874 2236874 defendant Curteys Alice   759039 759039 Curteys, Alice, of Hegham Ferrers 3
4623775 2238413 2238413 plaintiff Milner William (legal representative) 759039 759039 Milner, William, of Hegham Ferrers, executors of 0
4623776 2238413 2238413 plaintiff Milner Agnes   759039 759039 (Milner, Agnes, of Hegham Ferrers, formerly wife of William 1
4639752 2243134 2243134 defendant Roweley John   759039 759039 Roweley, John, of Hegham Ferrers 3
4640352 2243293 2243293 defendant Brasiere William   759039 759039 Brasiere, William, of Hegham Ferrers 3
4652883 2246837 2246837 defendant Pulter Stephen fisher 759039 759039 Pulter, Stephen, of Hegham Ferrers, fisher 3
4652889 2246838 2246838 defendant Cantell Alice widow 759039 759039 Cantell, Alice, of Hegham Ferrers, widow 1
4656512 2247932 2247932 defendant Bolno William   759039 759039 Bolno, William, of Hegham Ferrers 0
4656513 2247932 2247932 defendant Roweley John   759039 759039 Roweley, John, of Hegham Ferrers 1
4741838 2278107 2278107 defendant Steffyngton Richard shoemaker 759039 759039 Steffyngton, Richard, of Hegham Ferrers, shoemaker 0
4806683 2298299 2298299 defendant Duffyn Alice widow 759039 759039 Duffyn, Alice, of Hegham Ferrers, widow 0
4808903 2298956 2298956 defendant Bolne William gent 759039 759039 Bolne, William, of Hegham Ferrers, gent 0
4815736 2301023 2301023 defendant Beare Walter husbandman 759039 759039 Beare, Walter, of Hegham Ferrers, husbandman 1
4828730 2305027 2305027 defendant Bere John miller 759039 759039 Bere, John, of Hegham Ferrers, miller 2
4832737 2306262 2306262 defendant Chapman Nicholas chapman 759039 759039 Chapman, Nicholas, of Hegham Ferrers, chapman 0
4837007 2307533 2307533 defendant Colle Richard cooper 759039 759039 Colle, Richard, of Hegham Ferrers, cooper 1
4846471 2310404 2310404 defendant Bukby John yeoman 759039 759039 Bukby, John, of Hegham Ferrers, yeoman 0
4856395 2313376 2313376 defendant Crabbe Henry husbandman 759039 759039 Crabbe, Henry, of Hegham Ferrers, husbandman 2
4858077 2313896 2313896 defendant Bukkeby John yeoman 759039 759039 Bukkeby, John, of Hegham ferrers, yeoman 0
4859635 2314386 2314386 defendant Chapman Nicholas chapman 759039 759039 Chapman, Nicholas, of Hegham Ferrers, chapman 0
4863445 2315536 2315536 defendant Park William husbandman 759039 759039 Park, William, of Hegham Ferrers, husbandman 3
5629580 2553239 2553239 defendant Golde Roger   759039 759039 Golde, Roger, of Hegham Ferrers 0
5634966 2554925 2554925 defendant Goolde Roger courser 759039 759039 Goolde, Roger, of Hegham Ferrers, courser 0
5634967 2554925 2554925 defendant Goolde John courser 759039 759039 Goolde, John, of Hegham Ferrers, courser 1
5634968 2554925 2554925 defendant Broun Richard courser 759039 759039 Broun, Richard, of Hegham Ferrers, courser 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);