names

35 rows where place_id = 616175

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3713017 1930395 1930395 defendant Ducke Thomas husbandman 616175 616175 Ducke, Thomas, of Erlestoke, husbandman 0
3772064 1948953 1948953 defendant Trymnell Christopher husbandman 616175 616175 Trymnell, Christopher, of Erlestoke, husbandman 0
3878292 1982987 1982987 defendant Dydmyll Thomas husbandman 616175 616175 Dydmyll, Thomas, of Erlestoke, husbandman 0
3878294 1982988 1982988 defendant Markys John husbandman 616175 616175 Markys, John, of Erlestoke, husbandman 0
3991830 2021832 2021832 plaintiff Brounker Henry (legal representative) 616175 616175 Brounker, Henry, of Erlestoke, esq, executor of 0
4235544 2108000 2108000 defendant Cromwell John yeoman 616175 616175 Cromwell, John, of Erlestoke, yeoman 0
4255244 2114740 2114740 defendant Cromwell John yeoman 616175 616175 Cromwell, John, of Erlestoke, yeoman 0
4532401 2210401 2210401 plaintiff Preston Peter   616175 616175 Preston, Peter, of Erlestoke 0
4570751 2222423 2222423 defendant Hore William   616175 616175 Hore, William, of Erlestoke 0
4584916 2226714 2226714 defendant Broun Walter   616175 616175 Broun, Walter, of Erlestoke 3
4597530 2230473 2230473 defendant Luke William   616175 616175 Luke, William, of Erlestoke 0
4603895 2232397 2232397 defendant Gore John   616175 616175 Gore, John, of Erlestoke 2
4675519 2257955 2257955 defendant Boteler John tailor 616175 616175 Boteler, John, of Erlestoke, tailor 0
4675520 2257955 2257955 defendant Couper Thomas carpenter 616175 616175 Couper, Thomas, of Erlestoke, carpenter 1
4675521 2257955 2257955 defendant Sleywort John, senior   616175 616175 Sleywort, John, senior, of Erlestoke, sleigh maker 2
4695436 2264052 2264052 defendant Chambre Richard husbandman 616175 616175 Chambre, Richard, of Erlestoke, husbandman 0
4711199 2268855 2268855 defendant Cuper Thomas carpenter 616175 616175 Cuper, Thomas, of Erlestoke, carpenter 1
4734730 2276017 2276017 defendant Broun Walter husbandman 616175 616175 Broun, Walter, of Erlestoke, husbandman 1
4751516 2280927 2280927 defendant atte Chambre Richard husbandman 616175 616175 atte Chambre, Richard, of Erlestoke, husbandman 0
5040914 2368902 2368902 defendant Godyll alias Hawekyns John husbandman 616175 616175 Godyll alias Hawekyns, John, of Erlestoke, husbandman 0
5098191 2385900 2385900 defendant Monke John, junior husbandman 616175 616175 (Monke, John, junior, of Erlestoke, husbandman 8
5158383 2403573 2403573 defendant Hawekyns Peter   616175 616175 Hawekyns, Peter, of Erlestoke 0
5224401 2422813 2422813 defendant Haukyns Peter husbandman 616175 616175 Haukyns, Peter, of Erlestoke, husbandman 0
5224402 2422813 2422813 defendant Haukyns Roger husbandman 616175 616175 Haukyns, Roger, of Erlestoke, husbandman 1
5257188 2432380 2432380 defendant Haukyns Peter husbandman 616175 616175 Haukyns, Peter, of Erlestoke, husbandman 6
5423478 2481982 2481982 defendant Wulley William (legal representative) 616175 616175 Wulley, William, of Erlestoke, executrix of 0
5442755 2487746 2487746 defendant Walley William (legal representative) 616175 616175 Walley, William, of Erlestoke, executor of 0
5455474 2491549 2491549 defendant Wulley William (legal representative) 616175 616175 Wulley, William, of Erlestoke, executrix of 0
5455479 2491550 2491550 defendant Wulley William (legal representative) 616175 616175 Wulley, William, of Erlestoke, executrix of 0
5506547 2506958 2506958 defendant Carawey William husbandman 616175 616175 Carawey, William, of Erlestoke, husbandman 0
5506551 2506959 2506959 defendant Carawey William husbandman 616175 616175 Carawey, William, of Erlestoke, husbandman 1
5507604 2507275 2507275 defendant Chamber Robert husbandman 616175 616175 Chamber, Robert, of Erlestoke, husbandman 0
5517040 2510162 2510162 defendant Stokes William chaplain 616175 616175 Stokes, William, of Erlestoke, chaplain 0
5517041 2510162 2510162 defendant Perot Robert husbandman 616175 616175 Perot, Robert, of Erlestoke, husbandman 1
5589847 2531809 2531809 defendant Markes William husbandman 616175 616175 Markes, William, of Erlestoke, 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);