names

64 rows where place_id = 593106

✎ 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
3610467 1870934 1870934 defendant Tyle Nicholas yeoman 593106 593106 Tyle, Nicholas, of Hampden, yeoman 0
4839345 2308227 2308227 plaintiff Hampden John   593106 593106 Hampden, John, of Hampden 0
4839347 2308228 2308228 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
4918587 2332330 2332330 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
4918591 2332331 2332331 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
4918596 2332332 2332332 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
4918600 2332333 2332333 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq, on his own account 0
4944246 2340173 2340173 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
4944249 2340174 2340174 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
4944251 2340175 2340175 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
4944253 2340176 2340176 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
4944255 2340177 2340177 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
4944257 2340178 2340178 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
4944259 2340179 2340179 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
4944261 2340180 2340180 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
4944263 2340181 2340181 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
5009794 2359743 2359743 plaintiff Hampdon John esq 593106 593106 Hampdon, John, of Hampden, esq 1
5088708 2383074 2383074 defendant Boteler George husbandman 593106 593106 Boteler, George, of Hampden, husbandman 1
5089882 2383417 2383417 defendant Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
5110736 2389542 2389542 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
5110741 2389543 2389543 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
5110745 2389544 2389544 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
5110750 2389545 2389545 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
5110755 2389546 2389546 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
5110761 2389547 2389547 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
5110765 2389548 2389548 plaintiff Hampden John esq 593106 593106 Hampden, John, of Hampden, esq 0
5151791 2401686 2401686 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5151800 2401687 2401687 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5151810 2401688 2401688 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5151818 2401689 2401689 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5151827 2401690 2401690 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5151837 2401691 2401691 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5151846 2401692 2401692 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5151856 2401693 2401693 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5151866 2401694 2401694 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5151875 2401695 2401695 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5151885 2401696 2401696 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5151895 2401697 2401697 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5151904 2401698 2401698 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5151914 2401699 2401699 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5169843 2406923 2406923 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5169851 2406924 2406924 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5169858 2406925 2406925 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5169865 2406926 2406926 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5169874 2406927 2406927 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5169883 2406928 2406928 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5169890 2406929 2406929 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5169898 2406930 2406930 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5187032 2411944 2411944 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5187039 2411945 2411945 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5187047 2411946 2411946 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5187055 2411947 2411947 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5187062 2411948 2411948 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5187070 2411949 2411949 plaintiff Hampden John (legal representative) 593106 593106 Hampden, John, of Hampden, esq, executors of 0
5258638 2432823 2432823 plaintiff Hampden Thomas esq 593106 593106 Hampden, Thomas, of Hampden, esq 0
5343725 2458221 2458221 plaintiff Hampden Thomas esq 593106 593106 Hampden, Thomas, of Hampden, esq 2
5361512 2463622 2463622 plaintiff Hampden Thomas esq 593106 593106 Hampden, Thomas, of Hampden, esq 2
5370897 2466486 2466486 plaintiff Hampden Thomas esq 593106 593106 Hampden, Thomas, of Hampden, esq 0
5414204 2479185 2479185 plaintiff Hampden Thomas esq 593106 593106 Hampden, Thomas, of Hampden, esq 0
5459338 2492703 2492703 plaintiff Hampden Thomas esq 593106 593106 Hampden, Thomas, of Hampden, esq 0
5471003 2496265 2496265 plaintiff Hampden Thomas esq 593106 593106 Hampden, Thomas, of Hampden, esq 0
5503261 2505930 2505930 defendant Hampden Edmund esq 593106 593106 Hampden, Edmund, of Hampden, or of King's household, esq 1
5503266 2505931 2505931 defendant Hampden Edmund esq 593106 593106 Hampden, Edmund, of Hampden, or of King's household, esq 1
5554002 2521211 2521211 plaintiff Hampden Thomas (legal representative) 593106 593106 Hampden, Thomas, of Hampden, executor of 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);