names

67 rows where place_id = 707460

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4168103 2084331 2084331 defendant Stutfylde Thomas gent 707460 707460 Stutfylde, Thomas, of Cambridgeshire, gent 3
4433527 2175248 2175248 defendant Lacy Thomas de   707460 707460 Lacy, Thomas de, of Cambridgeshire, knight 0
4453991 2186264 2186264 defendant Clare John   707460 707460 Clare, John, of Cambridgeshire 0
4454235 2186342 2186342 defendant Cole William summoner 707460 707460 Cole, William, of Cambridgeshire, summoner 0
4455820 2186836 2186836 defendant Grey Roger   707460 707460 Grey, Roger, of Cambridgeshire 0
4468321 2190758 2190758 defendant Wyresdale John   707460 707460 Wyresdale, John, of Cambridgeshire 3
4473179 2192276 2192276 defendant Wyndesore Robert esq 707460 707460 Wyndesore, Robert, of Cambridgeshire, esq 0
4473185 2192277 2192277 defendant Wyndesore Robert esq 707460 707460 Wyndesore, Robert, of Cambridgeshire, esq 0
4475209 2192921 2192921 defendant Borewell Francis de   707460 707460 Borewell, Francis de, of Cambridgeshire 0
4487770 2196892 2196892 defendant Hykeman Walter   707460 707460 Hykeman, Walter, of Cambridgeshire 4
4499426 2200471 2200471 defendant Brewester Geoffrey   707460 707460 Brewester, Geoffrey, of Cambridgeshire 2
4507179 2202713 2202713 defendant Masoun Philip   707460 707460 Masoun, Philip, of Cambridgeshire 1
4509268 2203377 2203377 defendant Freman John esq 707460 707460 Freman, John, of Cambridgeshire, esq 4
4509271 2203378 2203378 defendant Freman John esq 707460 707460 Freman, John, of Cambridgeshire, esq 1
4511222 2203956 2203956 defendant Priour Thomas   707460 707460 Priour, Thomas, of Cambridgeshire 0
4511334 2203990 2203990 defendant Bassyngbourne Robert (legal representative) 707460 707460 Bassyngbourne, Robert, of Cambridgeshire, esq, executors of 1
4521852 2207170 2207170 defendant Hende William   707460 707460 Hende, William, of Cambridgeshire 1
4523279 2207605 2207605 defendant Brewester Geoffrey   707460 707460 Brewester, Geoffrey, of Cambridgeshire 0
4541894 2213354 2213354 defendant Autres John   707460 707460 Autres, John, of Cambridgeshire 2
4549953 2215916 2215916 defendant Wyndesore John   707460 707460 Wyndesore, John, of Cambridgeshire 0
4549955 2215917 2215917 defendant Wyndesore John   707460 707460 Wyndesore, John, of Cambridgeshire 0
4560047 2219093 2219093 plaintiff Morys Thomas   707460 707460 Morys, Thomas, of Cambridgeshire 0
4560050 2219094 2219094 plaintiff Morys Thomas   707460 707460 Morys, Thomas, of Cambridgeshire 0
4569809 2222130 2222130 defendant Lemman Edward   707460 707460 Lemman, Edward, of Cambridgeshire 1
4570988 2222492 2222492 defendant Bernard John   707460 707460 Bernard, John, of Cambridgeshire 0
4573142 2223134 2223134 defendant Naston Thomas   707460 707460 Naston, Thomas, of Cambridgeshire 0
4575280 2223784 2223784 defendant Deye Stephen   707460 707460 Deye, Stephen, of Cambridgeshire 0
4579438 2225047 2225047 defendant Gorlay William   707460 707460 Gorlay, William, of Cambridgeshire 1
4579966 2225221 2225221 defendant Hobildode John esq 707460 707460 Hobildode, John, of Cambridgeshire, esq 1
4579969 2225222 2225222 defendant Hobildode John esq 707460 707460 Hobildode, John, of Cambridgeshire, esq 1
4581649 2225709 2225709 defendant St George Baldwin   707460 707460 St George, Baldwin, of Cambridgeshire, knight 1
4581654 2225709 2225709 defendant Harpeden William esq 707460 707460 Harpeden, William, of Cambridgeshire, esq 6
4581657 2225710 2225710 defendant St George Baldwin   707460 707460 St George, Baldwin, of Cambridgeshire, knight 1
4581662 2225710 2225710 defendant Harppeden William esq 707460 707460 Harppeden, William, of Cambridgeshire, esq 6
4584719 2226644 2226644 defendant Borlay William   707460 707460 Borlay, William, of Cambridgeshire 1
4584722 2226645 2226645 defendant Borlay William   707460 707460 Borlay, William, of Cambridgeshire 1
4587626 2227535 2227535 plaintiff Ingrith Warin   707460 707460 Ingrith, Warin, of Cambridgeshire 0
4598405 2230741 2230741 plaintiff Brampton Thomas   707460 707460 Brampton, Thomas, of Cambridgeshire 1
4598414 2230742 2230742 plaintiff Brampton Thomas   707460 707460 Brampton, Thomas, of Cambridgeshire 1
4603309 2232235 2232235 defendant Hesylden Hugh   707460 707460 Hesylden, Hugh, of Cambridgeshire 0
4604181 2232477 2232477 defendant Ferrour William   707460 707460 Ferrour, William, of Cambridgeshire 0
4606159 2233036 2233036 defendant Turpyn John   707460 707460 Turpyn, John, of Cambridgeshire 1
4608685 2233821 2233821 defendant Bury John   707460 707460 Bury, John, of Cambridgeshire 0
4615335 2235804 2235804 defendant Ederich Robert   707460 707460 Ederich, Robert, of Cambridgeshire 0
4616447 2236138 2236138 defendant Ederich Robert   707460 707460 Ederich, Robert, of Cambridgeshire 0
4616449 2236139 2236139 defendant Ederich Robert   707460 707460 Ederich, Robert, of Cambridgeshire 0
4618408 2236768 2236768 defendant Umfrey John   707460 707460 Umfrey, John, of Cambridgeshire 0
4624477 2238640 2238640 defendant Dengayne William esq 707460 707460 Dengayne, William, of Cambridgeshire, esq 1
4637377 2242488 2242488 defendant Wykys John esq 707460 707460 Wykys, John, of Cambridgeshire, esq 0
4637383 2242489 2242489 defendant Wykys John esq 707460 707460 Wykys, John, of Cambridgeshire, esq 0
4641554 2243629 2243629 plaintiff Fulburne John   707460 707460 Fulburne, John, of Cambridgeshire 0
4645409 2244726 2244726 defendant Parker Ralph   707460 707460 Parker, Ralph, of Cambridgeshire 2
4646465 2245030 2245030 defendant Yoman Robert   707460 707460 Yoman, Robert, of Cambridgeshire 1
4690381 2262550 2262550 plaintiff Kneseworde John   707460 707460 Kneseworde, John, of Cambridgeshire 2
4690385 2262551 2262551 plaintiff Kneseworde John   707460 707460 Kneseworde, John, of Cambridgeshire 2
4695188 2263978 2263978 defendant Pattesle Thomas (legal representative) 707460 707460 Pattesle, Thomas, of Cambridgeshire, executors of 0
4695192 2263979 2263979 defendant Patterl_ Thomas (legal representative) 707460 707460 Patterl_, Thomas, of Cambridgeshire, clerk, executors of 0
4708398 2267992 2267992 defendant Dolfe Adam husbandman 707460 707460 Dolfe, Adam, of Cambridgeshire, husbandman 4
4720627 2271784 2271784 defendant Pattesle Thomas (legal representative) 707460 707460 Pattesle, Thomas, of Cambridgeshire, clerk, executors of 0
4726741 2273633 2273633 plaintiff Halle Thomas clerk 707460 707460 Halle, Thomas, of Cambridgeshire, clerk 1
5142231 2398848 2398848 defendant Neu-- Lawrence yeoman 707460 707460 Neu--, Lawrence, of Cambridgeshire, yeoman 3
5166650 2405969 2405969 defendant Holdyche Thomas esq 707460 707460 Holdyche, Thomas, of Cambridgeshire, esq 0
5271725 2436830 2436830 defendant Langley John gent 707460 707460 Langley, John, of Cambridgeshire, gent 0
5304072 2446224 2446224 plaintiff Boorle Robert esq 707460 707460 Boorle, Robert, of Cambridgeshire, esq 1
5391366 2472608 2472608 defendant Warde Bernard tailor 707460 707460 Warde, Bernard, of Cambridgeshire, tailor 0
5393560 2473220 2473220 plaintiff Tanfeld Robert esq & formerly sheriff 707460 707460 Tanfeld, Robert, of Cambridgeshire, esq & formerly sheriff 0
5616841 2549075 2549075 plaintiff Jerpenvyle John   707460 707460 Jerpenvyle, John, of Cambridgeshire 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);