names

27 rows where place_id = 757574

✎ 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
4447099 2184003 2184003 plaintiff Druns Richard   757574 757574 Druns, Richard, of Harewell 0
4453495 2186100 2186100 plaintiff Leghe John   757574 757574 Leghe, John, of Harewell, vicar 0
4469899 2191250 2191250 defendant Raulyn John   757574 757574 Raulyn, John, of Harewell 0
4535941 2211516 2211516 defendant Bonde John   757574 757574 Bonde, John, of Harewell 0
4574829 2223653 2223653 defendant Bruns John   757574 757574 Bruns, John, of Harewell 0
4603916 2232402 2232402 defendant Houglot John   757574 757574 Houglot, John, of Harewell 1
4604619 2232610 2232610 defendant Pychet Walter   757574 757574 Pychet, Walter, of Harewell 0
4604620 2232610 2232610 defendant Vykeries William   757574 757574 Vykeries, William, of Harewell 1
4684397 2260727 2260727 defendant Hamond Robert husbandman 757574 757574 Hamond, Robert, of Harewell, husbandman 0
4684398 2260727 2260727 defendant Hamond Stephen husbandman 757574 757574 Hamond, Stephen, of Harewell, husbandman 1
4691608 2262903 2262903 defendant Hamond Robert husbandman 757574 757574 Hamond, Robert, of Harewell, husbandman [ vacated ] 0
4710226 2268551 2268551 defendant Hamond Robert husbandman 757574 757574 Hamond, Robert, of Harewell, husbandman 0
4710227 2268551 2268551 defendant Hamond Stephen husbandman 757574 757574 Hamond, Stephen, of Harewell, husbandman 1
5032935 2366521 2366521 defendant Walrond Richard husbandman 757574 757574 Walrond, Richard, of Harewell, husbandman 0
5114600 2390681 2390681 defendant Faleryan John husbandman 757574 757574 Faleryan, John, of Harewell, husbandman 0
5114601 2390681 2390681 defendant Bailly John husbandman 757574 757574 Bailly, John, of Harewell, husbandman 1
5161237 2404382 2404382 defendant Yonge Thomas   757574 757574 Yonge, Thomas, of Harewell 1
5222708 2422357 2422357 defendant Duke alias Tor William husbandman 757574 757574 Duke alias Tor, William, of Harewell, husbandman 2
5222709 2422357 2422357 defendant Yonge alias Spycer Thomas husbandman 757574 757574 Yonge alias Spycer, Thomas, of Harewell, husbandman 3
5302906 2445856 2445856 defendant Hamond John husbandman 757574 757574 Hamond, John, of Harewell, husbandman 0
5302909 2445856 2445856 defendant Milton William husbandman 757574 757574 Milton, William, of Harewell, husbandman 3
5348787 2459746 2459746 plaintiff Brouns Richard   757574 757574 Brouns, Richard, of Harewell 0
5348788 2459746 2459746 defendant Bond William   757574 757574 Bond, William, of Harewell 0
5512791 2508853 2508853 plaintiff Milton William husbandman 757574 757574 Milton, William, of Harewell, husbandman 0
5529928 2513863 2513863 defendant Kete Richard husbandman 757574 757574 Kete, Richard, of Harewell, husbandman 0
5529930 2513863 2513863 defendant Wodlef John husbandman 757574 757574 Wodlef, John, of Harewell, husbandman 2
5623662 2551338 2551338 defendant Chambre John laborer 757574 757574 (Chambre, John, of Harewell, laborer 3

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