names

54 rows where place_id = 599814

✎ 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
3638381 1906823 1906823 defendant Owteryd William innholder 599814 599814 Owteryd, William, of Rumford, Essex, innholder 1
3657706 1912660 1912660 defendant Cook Richard gent 599814 599814 Cook, Richard, of Rumford, Essex, gent 0
3661864 1913997 1913997 defendant Halys Marcellus gent 599814 599814 Halys, Marcellus, of Rumford, Essex, gent 0
3662020 1914054 1914054 defendant Cooke Richard gent 599814 599814 Cooke, Richard, of Rumford, Essex, gent 0
3662022 1914055 1914055 defendant Cooke Richard gent 599814 599814 Cooke, Richard, of Rumford, Essex, gent 0
3777861 1950792 1950792 defendant Coke Richard gent 599814 599814 Coke, Richard, of Rumford, Essex, gent 1
3811081 1961361 1961361 defendant Halys Marcel gent 599814 599814 Halys, Marcel, of Rumford, Essex, gent 0
3839053 1970139 1970139 defendant Coke Richard gent 599814 599814 Coke, Richard, of Rumford, Essex, gent 3
3921976 1997694 1997694 plaintiff Rawson Beatrice widow 599814 599814 Rawson, Beatrice, of Rumford, Essex, widow 0
3946282 2005775 2005775 defendant Charvell Thomas chapman 599814 599814 Charvell, Thomas, of Rumford, Essex, chapman 4
3960860 2010897 2010897 defendant Cooke Richard esq 599814 599814 Cooke, Richard, of Rumford, Essex, esq 0
3960863 2010898 2010898 defendant Cooke Richard esq 599814 599814 Cooke, Richard, of Rumford, Essex, esq 0
4066198 2048204 2048204 plaintiff Hodgeson Richard butcher 599814 599814 Hodgeson, Richard, of Rumford, Essex, butcher 0
4143228 2075800 2075800 defendant Grey Edward esq 599814 599814 Grey, Edward, of Rumford, Essex, esq 0
4197444 2094662 2094662 defendant Foster William tailor 599814 599814 Foster, William, of Rumford, Essex, tailor 1
4263568 2117479 2117479 defendant Copland William yeoman 599814 599814 Copland, William, of Rumford, Essex, yeoman 1
4266109 2118305 2118305 defendant Wells John yeoman 599814 599814 Wells, John, of Rumford, Essex, yeoman 1
4337964 2143021 2143021 defendant Locksmythe John (legal representative) 599814 599814 Locksmythe, John, of Rumford, Essex, vintner, executrix of 2
4354714 2148878 2148878 defendant Osborne Richard yeoman 599814 599814 Osborne, Richard, of Rumford, Essex, yeoman 1
4509607 2203480 2203480 defendant Bocher John   599814 599814 Bocher, John, of Rumford, Essex 0
4654554 2247302 2247302 defendant Bardevyle John tanner 599814 599814 Bardevyle, John, of Rumford, Essex, tanner 0
4767867 2285924 2285924 defendant Rodyng William laborer 599814 599814 Rodyng, William, of Rumford, Essex, laborer 0
4851977 2312052 2312052 defendant Scotte John   599814 599814 Scotte, John, of Rumford, Essex, glove maker 1
4879980 2320653 2320653 defendant Scot John glover 599814 599814 Scot, John, of Rumford, Essex, glover 0
4889800 2323601 2323601 defendant Ferburne William chapman 599814 599814 Ferburne, William, of Rumford, Essex, chapman 4
4894854 2325056 2325056 defendant Ferburne William chapman 599814 599814 Ferburne, William, of Rumford, Essex, chapman 4
4935240 2337423 2337423 defendant Spycer John chapman 599814 599814 Spycer, John, of Rumford, Essex, chapman 1
4989153 2353693 2353693 defendant Spycer John chapman 599814 599814 Spycer, John, of Rumford, Essex, chapman 1
4996346 2355765 2355765 defendant Cappys Thomas husbandman 599814 599814 Cappys, Thomas, of Rumford, Essex, husbandman 1
4996349 2355766 2355766 defendant Cappys Thomas   599814 599814 Cappys, Thomas, of Rumford, Essex 0
5002164 2357538 2357538 defendant Wellys George barber 599814 599814 Wellys, George, of Rumford, Essex, barber 1
5002169 2357539 2357539 defendant Wellys George barber 599814 599814 Wellys, George, of Rumford, Essex, barber 1
5003594 2357942 2357942 defendant Marchall John husbandman 599814 599814 Marchall, John, of Rumford, Essex, husbandman 0
5003625 2357951 2357951 defendant Marchall John husbandman 599814 599814 Marchall, John, of Rumford, Essex, husbandman 0
5043230 2369595 2369595 defendant Bole John yeoman 599814 599814 Bole, John, of Rumford, Essex, yeoman 4
5047573 2370894 2370894 defendant Spencer Robert yeoman 599814 599814 Spencer, Robert, of Rumford, Essex,yeoman 0
5049011 2371339 2371339 defendant Taper Edmund butcher 599814 599814 Taper, Edmund, of Rumford, Essex, butcher 2
5053603 2372679 2372679 defendant Brookman John husbandman 599814 599814 Brookman, John, of Rumford, Essex, husbandman 1
5053934 2372772 2372772 defendant Spenser Robert husbandman 599814 599814 Spenser, Robert, of Rumford, Essex, husbandman 1
5086284 2382379 2382379 defendant Rose William ostler 599814 599814 Rose, William, of Rumford, Essex, ostler 3
5111139 2389645 2389645 defendant Marchall John yeoman 599814 599814 Marchall, John, of Rumford, Essex, yeoman 1
5119937 2392268 2392268 defendant Harpeley Richard   599814 599814 Harpeley, Richard, of Rumford, Essex, mason 0
5172704 2407745 2407745 defendant Carrowe Thomas husbandman 599814 599814 Carrowe, Thomas, of Rumford, Essex, husbandman 2
5199448 2415586 2415586 defendant Kent John butcher 599814 599814 Kent, John, of Rumford, Essex, butcher 4
5199454 2415587 2415587 defendant Kent John butcher 599814 599814 Kent, John, of Rumford, Essex, butcher 4
5202964 2416629 2416629 defendant Hammes John gent 599814 599814 Hammes, John, of Rumford, Essex, gent 0
5233639 2425428 2425428 defendant Steyndrop John yeoman 599814 599814 Steyndrop, John, of Rumford, Essex, yeoman 0
5248559 2429704 2429704 defendant Chaterton Henry esq 599814 599814 Chaterton, Henry, of Rumford, Essex, esq 1
5332992 2454935 2454935 defendant Benyland Thomas chaplain 599814 599814 Benyland, Thomas, of Rumford, Essex, chaplain 0
5491508 2502343 2502343 defendant Lake William draper 599814 599814 Lake, William, of Rumford, Essex, draper 1
5508906 2507640 2507640 defendant Cook Philip esq 599814 599814 Cook, Philip, of Rumford, Essex, esq 1
5513494 2509066 2509066 defendant Skot Thomas butcher 599814 599814 Skot, Thomas, of Rumford, Essex, butcher 2
5577063 2527872 2527872 defendant Comfurst Geoffrey husbandman 599814 599814 Comfurst, Geoffrey, of Rumford, Essex, husbandman 2
5597205 2534033 2534033 defendant Coke John esq 599814 599814 Coke, John, of Rumford, Essex, esq 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);