names

28 rows where place_id = 666635

✎ 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
3981756 2018234 2018234 defendant Osborne John tailor 666635 666635 Osborne, John, of Stoke Ferry, tailor 3
4391394 2161738 2161738 defendant Inglebright William clerk 666635 666635 Inglebright, William, of Stoke Ferry, clerk 1
4393540 2162443 2162443 defendant Inglebrighte William husbandman 666635 666635 Inglebrighte, William, of Stoke Ferry, husbandman 0
4454879 2186537 2186537 defendant atte Grene Thomas   666635 666635 atte Grene, Thomas, of Stoke Ferry 0
4647945 2245466 2245466 defendant Baxtere John   666635 666635 Baxtere, John, of Stoke Ferry 6
4694548 2263790 2263790 defendant Mouneford William yeoman 666635 666635 Mouneford, William, of Stoke Ferry, yeoman 0
4698477 2265001 2265001 plaintiff Curteys William (legal representative) 666635 666635 Curteys, William, of Stoke Ferry, chaplain, executors of 0
4698482 2265002 2265002 plaintiff Curteys William (legal representative) 666635 666635 Curteys, William, of Stoke Ferry, executors of 0
4712940 2269361 2269361 defendant Mundeford Robert husbandman 666635 666635 Mundeford, Robert, of Stoke Ferry, husbandman 1
4730983 2274893 2274893 defendant Mountford William husbandman 666635 666635 Mountford, William, of Stoke Ferry, husbandman 0
4749017 2280197 2280197 plaintiff Mundeford John   666635 666635 Mundeford, John, of Stoke Ferry, son of Geoffrey Mundeford, on his own account 0
4764277 2284822 2284822 defendant Dawys Richard yeoman 666635 666635 Dawys, Richard, of Stoke Ferry, yeoman 0
4811310 2299647 2299647 defendant Halyday Robert yeoman 666635 666635 Halyday, Robert, of Stoke Ferry, yeoman 0
4908117 2329096 2329096 defendant Fyssher Katherine widow 666635 666635 Fyssher, Katherine, of Stoke Ferry, widow 0
4912924 2330538 2330538 defendant Walpole John husbandman 666635 666635 Walpole, John, of Stoke Ferry, husbandman 2
4912925 2330538 2330538 defendant Rede Thomas husbandman 666635 666635 Rede, Thomas, of Stoke Ferry, husbandman 3
5003890 2358027 2358027 defendant Tassell William husbandman 666635 666635 Tassell, William, of Stoke Ferry, husbandman 0
5269445 2436161 2436161 defendant Thorndon John husbandman 666635 666635 Thorndon, John, of Stoke Ferry, husbandman 1
5371346 2466616 2466616 defendant Mason Thomas, junior yeoman 666635 666635 Mason, Thomas, junior, of Stoke Ferry, yeoman 0
5392347 2472896 2472896 defendant M Thomas husbandman 666635 666635 M, Thomas, of Stoke Ferry, husbandman 0
5405432 2476634 2476634 defendant Fyssher William husbandman 666635 666635 Fyssher, William, of Stoke Ferry, husbandman 0
5406877 2477031 2477031 defendant Cooke Thomas husbandman 666635 666635 Cooke, Thomas, of Stoke Ferry, husbandman 1
5416082 2479741 2479741 defendant Rothermere Thomas husbandman 666635 666635 Rothermere, Thomas, of Stoke Ferry, husbandman 0
5419507 2480754 2480754 defendant Fyssher William husbandman 666635 666635 Fyssher, William, of Stoke Ferry, husbandman 0
5438673 2486501 2486501 defendant Mason Thomas husbandman 666635 666635 Mason, Thomas, of Stoke Ferry, husbandman 0
5461131 2493275 2493275 plaintiff Mason Thomas   666635 666635 Mason, Thomas, of Stoke Ferry 1
5464521 2494309 2494309 defendant Mason Thomas husbandman 666635 666635 Mason, Thomas, of Stoke Ferry, husbandman 0
5464525 2494310 2494310 defendant Mason Thomas husbandman 666635 666635 Mason, Thomas, of Stoke Ferry, husbandman 0

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);