names

32 rows where place_id = 594443

✎ 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
3616153 1872690 1872690 defendant Smyth William, senior husbandman 594443 594443 Smyth, William, senior, of Thurlaston, husbandman 0
3634255 1905512 1905512 defendant Lawe Roger husbandman 594443 594443 Lawe, Roger, of Thurlaston, husbandman 1
3671126 1916938 1916938 defendant Smyth Richard husbandman 594443 594443 Smyth, Richard, of Thurlaston, husbandman 0
3671127 1916938 1916938 defendant Tayllour Robert husbandman 594443 594443 Tayllour, Robert, of Thurlaston, husbandman 1
3678463 1919318 1919318 defendant Pake Henry husbandman 594443 594443 Pake, Henry, of Thurlaston, husbandman 0
4219613 2102365 2102365 defendant Edmond John husbandman 594443 594443 Edmond, John, of Thurlaston, husbandman 1
4219614 2102365 2102365 defendant Edmind Henry husbandman 594443 594443 Edmind, Henry, of Thurlaston, husbandman 2
4304335 2131654 2131654 defendant Edmond Henry husbandman 594443 594443 Edmond, Henry, of Thurlaston, husbandman 1
4425227 2172720 2172720 plaintiff Lord Simon le   594443 594443 Lord, Simon le, of Thurlaston 0
4516775 2205653 2205653 plaintiff Corbrond Roger   594443 594443 Corbrond, Roger, of Thurlaston 0
4782322 2290474 2290474 defendant Derset William gent 594443 594443 Derset, William, of Thurlaston, gent 1
4958953 2344646 2344646 defendant Darset William gent 594443 594443 Darset, William, of Thurlaston, gent 0
5107550 2388639 2388639 defendant Pake William yeoman 594443 594443 Pake, William, of Thurlaston, yeoman 2
5107551 2388639 2388639 defendant Bernangle John husbandman 594443 594443 Bernangle, John, of Thurlaston, husbandman 3
5107552 2388639 2388639 defendant Nicols Thomas husbandman 594443 594443 Nicols, Thomas, of Thurlaston, husbandman 4
5107553 2388639 2388639 defendant Persons William husbandman 594443 594443 Persons, William, of Thurlaston, husbandman 5
5115985 2391103 2391103 plaintiff Nicols Roger   594443 594443 Nicols, Roger, of Thurlaston 0
5115987 2391103 2391103 defendant Nicols Henry husbandman 594443 594443 Nicols, Henry, of Thurlaston, husbandman 1
5231046 2424677 2424677 defendant Dorsett William (legal representative) 594443 594443 Dorsett, William, of Thurlaston, executrix of 5
5231051 2424678 2424678 defendant Dorset Agnes Widow 594443 594443 Dorset, Agnes, of Thurlaston, Widow 1
5336299 2455925 2455925 defendant Nicholles Thomas husbandman 594443 594443 Nicholles, Thomas, of Thurlaston, husbandman 0
5336300 2455925 2455925 defendant Barnangull John husbandman 594443 594443 Barnangull, John, of Thurlaston, husbandman 1
5420921 2481186 2481186 defendant Darset Thomas gent 594443 594443 Darset, Thomas, of Thurlaston, gent 0
5440047 2486925 2486925 defendant Darset Thomas gent 594443 594443 Darset, Thomas, of Thurlaston, gent 0
5440049 2486926 2486926 defendant Darset Thomas gent 594443 594443 Darset, Thomas, of Thurlaston, gent 0
5449912 2489862 2489862 plaintiff Pake William   594443 594443 Pake, William, of Thurlaston 0
5465478 2494581 2494581 defendant Darset Thomas gent 594443 594443 Darset, Thomas, of Thurlaston, gent 0
5491341 2502299 2502299 defendant Harrys Thomas husbandman 594443 594443 Harrys, Thomas, of Thurlaston, husbandman 0
5491342 2502299 2502299 defendant Bengeworth Robert husbandman 594443 594443 Bengeworth, Robert, of Thurlaston, husbandman 1
5491343 2502299 2502299 defendant Ball Nicholas husbandman 594443 594443 Ball, Nicholas, of Thurlaston, husbandman 2
5491344 2502299 2502299 defendant Pake Henry husbandman 594443 594443 Pake, Henry, of Thurlaston, husbandman 3
5491345 2502299 2502299 defendant Gilbert Richard husbandman 594443 594443 Gilbert, Richard, of Thurlaston, husbandman 4

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